how to record and calculate a 6 stage program with a spreasheet

[JackOfHearts]

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/1...sp=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

[JackOfHearts]

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

[jonathan4all]

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

Good work Maniac. Appreciate it man .

[JackOfHearts]

I have upgraded the application:
https://docs.google.com/spreadsheets/d/1...sp=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.

[JackOfHearts]

Version 3 available:
https://docs.google.com/spreadsheets/d/1...sp=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.

[jonathan4all]

Version 3 available:
https://docs.google.com/spreadsheets/d/1...sp=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.

[JackOfHearts]

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

[JackOfHearts]

Version 5 available:
https://docs.google.com/spreadsheets/d/1...sp=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

[MJ1]

what if you miss a day between stages?

i downloaded it as excel.

[JackOfHearts]

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)

[MJ1]

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.

[JackOfHearts]

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.

[Fonzy3]

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

Thanks

Fonzy

[LionKing]

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.