Subliminal Talk
how to record and calculate a 6 stage program with a spreasheet - Printable Version

+- Subliminal Talk (https://subliminal-talk.com)
+-- Forum: Website and Subliminal Feedback (https://subliminal-talk.com/Forum-Website-and-Subliminal-Feedback)
+--- Forum: Forum, Website & Shopping (https://subliminal-talk.com/Forum-Forum-Website-Shopping)
+--- Thread: how to record and calculate a 6 stage program with a spreasheet (/Thread-how-to-record-and-calculate-a-6-stage-program-with-a-spreasheet)

Pages: 1 2


how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-01-2014

I made a spreadsheet with Google drive so I can record and calculate when each stage end without any paper.
In this spreadsheet I added an application that send an email at the last day of each Stage.

I made a video to explain how to use this spreadsheet so you can use it for yourself. You can export it to Microsoft Office or LibreOffice if you want. But the application that send an email will only work with a gmail account which is link to Google Drive.

The link to the spreadsheet :
https://docs.google.com/spreadsheets/d/1lFUd4CDZTQ8Pydc1DCfsakSS822MisRviWNeQsw5LZc/edit?usp=sharing

The first video explain how to set the file to calculate each stage:
http://youtu.be/6oPTfp1jAuI

This video explain how to configure the email sender so you can receive your notification when your stage is over:
http://youtu.be/6P-r2s-Egi0


RE: how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-01-2014

it was the wrong link for the spreadsheet, here is the right one:
https://docs.google.com/spreadsheets/d/1lFUd4CDZTQ8Pydc1DCfsakSS822MisRviWNeQsw5LZc/edit?usp=sharing
I have changed the one above too


RE: how to record and calculate a 6 stage program with a spreasheet - jonathan4all - 04-01-2014

(04-01-2014, 10:59 AM)maniac360 Wrote: it was the wrong link for the spreadsheet, here is the right one:
https://docs.google.com/spreadsheets/d/1lFUd4CDZTQ8Pydc1DCfsakSS822MisRviWNeQsw5LZc/edit?usp=sharing
I have changed the one above too

Good work Maniac. Appreciate it man .


RE: how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-02-2014

I have upgraded the application:
https://docs.google.com/spreadsheets/d/1JAnENvs6DXmzlGKIuXdHuVlEkN8f794yHEqSJAuZ-P8/edit?usp=sharing

There is now a day counter that is updated automaticaly and the finished day are colored automaticaly too.

The old version is still available if you prefer to do it manualy. It's a bit more complicated to use
if you missed some day I prefer to keep the old version too.


RE: how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-03-2014

Version 3 available:
https://docs.google.com/spreadsheets/d/1z07GN9wqIcDN5oBJriPcAI0fwF2FiaA3lRHQ9abGp80/edit?usp=sharing

I added some charts, some data and a new menu to clean all the content.

I will make a new video maybe but it's pretty simple.


RE: how to record and calculate a 6 stage program with a spreasheet - jonathan4all - 04-03-2014

(04-03-2014, 04:51 AM)maniac360 Wrote: Version 3 available:
https://docs.google.com/spreadsheets/d/1z07GN9wqIcDN5oBJriPcAI0fwF2FiaA3lRHQ9abGp80/edit?usp=sharing

I added some charts, some data and a new menu to clean all the content.

I will make a new video maybe but it's pretty simple.

Thanks for your effort man.


RE: how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-03-2014

It feels good to do something useful for once. I didn't put any effort, it was all pleasure Big Grin


RE: how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-03-2014

Version 5 available:
https://docs.google.com/spreadsheets/d/1utQ4cgJ64ETs9WwlXSVS-gR6_YDPhmdBJuK3xClUtD8/edit?usp=sharing

I added a menu to activate the Email sender so now the video are almost useless.
I added new charts for fear and confidence and I removed the comment column.
The menu to clean now restart the stage number too.

I will do a new video to explain it all even if now it's super simple to use it Wink


RE: how to record and calculate a 6 stage program with a spreasheet - MJ1 - 04-20-2014

what if you miss a day between stages?

i downloaded it as excel.


RE: how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-20-2014

If you missed a day, change the date of the last day (day 32) to reflect the last day you really used the sub.
if for expample the 04/20/2014 is the 32th day but you added 3 days so you have to change in the spreadsheet the 32th date to 07/20/2014 (+3)


RE: how to record and calculate a 6 stage program with a spreasheet - MJ1 - 04-22-2014

i get it.you can improve the code like this

current day = previous_day + 1 ; this way you can change the day where ever you want.

if that's possible in syntax.


RE: how to record and calculate a 6 stage program with a spreasheet - JackOfHearts - 04-22-2014

It's already like that actually, It's the spreadsheet formula who is doing the job.
Click on a cell date you will see the formula in the top left.


RE: how to record and calculate a 6 stage program with a spreasheet - Fonzy3 - 04-25-2014

Hey appreciate the spreadsheet man! I might consider using this when I do AM6.

Thanks

Fonzy


RE: how to record and calculate a 6 stage program with a spreasheet - LionKing - 05-10-2014

FYI, I changed the "Stage usage: total in day" to "=(SUM(B2:B33)/COUNT(B2:B33))" and changed to format of that field to Duration. This way it shows the average listening hours per day, even if the stage isn't completed yet. You just have to set at least one Usage time for the stages that haven't begun yet, so that COUNT won't become zero.