Google SpreadSheet 61 day Tracker Instructions

[Ogedei]

sometimes it takes a second to update (ie 30 seconds)

Where are you entering data and where are you expecting it to go?

Cell examples of what you are entering are great if you have them

[ohammersmith]

I don't mean half days, I mean account for the current day if I have already recorded it. Because if you put in your number for today, your current + remaining is actually higher than the possible.

I put this forumula above the first column of dates:

=VLOOKUP(B5, A24:B36, 2, 1)

That gives me the number recorded for the current day. Then I just subtracted that from the remaining.

I have to fix it so it will do the lookup on the other columns, but right now that will render an annoying error message that it can't find the column, when I know it won't until later in the month.

[Ogedei]

Publishing your tracker sheet

Problem:
People can't view your sheet. It tells them their e-mail address dosen't have permission or something similar.


Solution:
You have used the share tab instead of the publish tab to get the link for your signature. Open your sheet up and click on Publish in the top right hand side of the sheet. Use the link it displays in here. As well select automatically publish every five minutes.

[Ogedei]

Today we are on Day 2. 60 1/2 blocks remaining total possible before we start or 120.

I understand that if you enter both 1/2 blocks it does not decrease at all.

My logic is that you don't know you have eaten both 1/2 days cleanly until after midnight, really until you get up and start the next day. Maybe you get up and break down in the middle of the night. Who knows.

Personally I think we are splitting hairs. The column is not big enough to put a heading in that says "Maximum 1/2 days remaining including today" Just be aware that's what it is.

Originally Posted by ohammersmith

I don't mean half days, I mean account for the current day if I have already recorded it. Because if you put in your number for today, your current + remaining is actually higher than the possible.

[ohammersmith]

Originally Posted by Ogedei

My logic is that you don't know you have eaten both 1/2 days cleanly until after midnight, really until you get up and start the next day. Maybe you get up and break down in the middle of the night. Who knows.

Ah gotcha, I wasn't grokking what the confusion was. Also you don't know if I put in 1 because I've gotten through 1/2 the day, or messed up 1/2 a day.

It boils down to when I enter stuff. I tend to open it once at the end of the day and not worry about it.

You're right, splitting hairs.

[Ogedei]

Ok I consolidate the help files into a single website so people don't have to struggle through the banter.

Feel free to post here or PM me if you are having issues still.

I will update the new site as issues arise and stuff is added into the sheet.

http://ogedei.googlepages.com/61daytrackerinstructions

[kingkop182]

Basic question I know but can somebody show me how to do the 'my link here' thing which links to your chart. I tried the link button but that just seems to publish the url rather than my own words as the link

[ljk]

This would make a good sticky!

[Ogedei]

When you are editing your signature type the words you want as the link.

Select the words and then click on the icon of the globe and the sideways 8. It will open a window where you can paste your URL for your sheet.

[kingkop182]

Thanks Keith - worked a treat

[Victoria]

Originally Posted by Ogedei

icon of the globe and the sideways 8.

Hmmm...now where have I seen that before?....hmmmm :p

[Ogedei]

Originally Posted by Victoria

Hmmm...now where have I seen that before?....hmmmm :p

Good to see you are paying attention

[SpacecityPaula]

Originally Posted by Ogedei

Click this and forget about it.

No, no, no

I do believe the proper terminology for this is "Set it and forget it!"

[James Newman]

To All: I am very sorry for all of the confusion: For the poorly written rules, for the 8.7 weeks of duration, etc. Og and others bailed me out on the Challenge. I did the best that I could. I am certain that you guys will do better next time.

Per your request, I made this a sticky....

Newman

[LisaS]

Originally Posted by James Newman

TFor the poorly written rules, for the 8.7 weeks of duration, etc.

those are the some of the parts I like best - don't sweat it -

[Egham]

Ogedei -

This tracker spreadsheet is GREAT! Thank you for all the work you put into it.

- E