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

[JackOfHearts]

Thanks for info, I updated the spreadsheet.

[Adri]

Hi maniac360, here are two questions I'm asking myself about your spreadsheet:

• Why do you have put 33 days instead of 32?
  
• Do you need to put the date of the night you started to listen to the sub in the first cell, or the date of the first day you made after having listened to the sub during the night?
  

Thank you very much

[JackOfHearts]

Good question, I'm glad you asked them because It's some of the problem I faced myself when I created this.

1) I didn't put 33 days , the row number doesn't equal the day number because the first row is for the column's title. I didn't find a way to remove this "problem".

2)It doesn't matter, it's all up to you, both way will work. Pick the one that make more sense to you. I chose the first one.

[Adri]

Thanks for your answers, this help me a lot

[Shawn]

1) I didn't put 33 days , the row number doesn't equal the day number because the first row is for the column's title. I didn't find a way to remove this "problem".

You could take column A as day counter and move the existing content one column to the right.

[JackOfHearts]

I can but I would have to change the code to send the mails and I don't want calculate all the things again. Maybe it's just a small thing but I'm not in the mood to check this.

[Shawn]

No problem, just a suggestion

[JackOfHearts]

I made a mistake with the mail sender so I think it works for no one even myself and the stage number will not increment because of that.

I corrected the problem with the last version :
https://docs.google.com/spreadsheets/d/1...lUtD8/edit

-If your spreadsheet didn't work properly change the number in the red cells (the stage number)
-If you want to keep the version 5 and and get the error corrected copy all the JavaScript code from the last version. Or you can copy your data in last version either way will work.

I'll try to make a video tonight to explain all this if possible.

[JackOfHearts]

1) I didn't put 33 days , the row number doesn't equal the day number because the first row is for the column's title. I didn't find a way to remove this "problem".

You could take column A as day counter and move the existing content one column to the right.

I've done what you said, now everything is more clear, it was bothering so now it's gone :@.
I'll upgrade to the new version when I'm sure everything is correct. and maybe upload a video if possible.

[JackOfHearts]

I have upgraded to the new version and I think my old code was working too and I didn't make any mistake.
This little code is more tricky than I thought. It's hard to test the code because it's base on the current date which come from the Google server. But anyway I hope now it's working, I'll see .

This upgraded version now come with a column which indicate the current day.

It's the same link by the way:
https://docs.google.com/spreadsheets/d/1...edit#gid=0

Some of you can tell me if the stage number has been incremented by one automatically? And has received the mail with the old version (version 5 and before)?

[JackOfHearts]

I'm pretty sure now the mail sender works.
So I made another version, the last hopefully and I made 2 video to describe how to use my new spreadsheet.

Here is the link to the video:
http://youtu.be/6w-Q_2PYnpw
http://youtu.be/tUmHt4mnk_M

Here is the link to the spreadsheet (it's the same link):
https://docs.google.com/spreadsheets/d/1...edit#gid=0