Google SpreadSheet 61 day Tracker Instructions

[Ogedei]

I am currently expriencing no issues with any of their websites. Maybe it's you?

[Azure]

Hello...I'm pretty new to the forum, but I like the idea of setting a challege for myself. It's already been going on, and there's only 49 days left as of today--is it okay if I just start from now and go for it? Should I set up the spreadsheet the same except leave the days prior to this one blank?

[ninja]

Originally Posted by Ogedei

I am currently expriencing no issues with any of their websites. Maybe it's you?

I get the server not found for all of google. what the hell...

[ohammersmith]

There, I made it easy to add.

Double click on cell A39 of the first sheet (61DC Day Tracker), and paste this formula in there.

=CONCATENATE("61DC Status — Nutrition: ", F5, "/", E5, ", Lifts: ", F6,"/", E6, ", Intervals: ", F7,"/",E7,", Cardio: ", F8,"/",E8, ", Personal: ", F9, ", Competitive: ", F10)

Then select A39 through G39 and click the "Merge across cells", this will make it stop wrapping in the one cell.

Then follow the steps as before, but publish the A39:G39 cells, and paste it in your sig. This is the code I used... note that I changed the height & width to make it cleaner. Your will be very similar, just a different spreadsheet id.

<iframe src="http://spreadsheets.google.com/pub?key=pUaz9Yxrz6N_bUaFx28_3MA&output=html&gid=0&single=true&range=A39:G39" frameborder="0" height="30" width="700"></iframe>

Originally Posted by ohammersmith

I tweaked it a bit. I created a new sheet, and put a formula in there that uses CONCATANATE() to put togethter all the information in a single cell, then updated the iframe to just reference that cell.

If you want to see what I did, PM me and I'll give you access to my spreadsheet.

[ohammersmith]

One last note... preview before you save your sig.