61 Day Challenge Tracker.
Step 0: Green is good, white is bad.
In the tracker there are cells that are colored green. These are to be used to enter data. The white cells are either not used or
contain formulas. If they contain formulas and you change them, the sheet will not work properly and will be a useless tool for you.
Step 1: Setting up the sheet for your use.
The first thing you will need to do is open the spreadsheet at the following location.
http://spreadsheets.google.com/ ccc?key=pcYKF234Hk5Ugwwq35c-IFw
This will open the master copy.
Click on "File, copy spreadsheet". This will make a personal copy in your google documents.
Step 2: Setting your goals.
a) Nutrition: We have 61 days to account for, each day has two segments. So we have 122 chances to eat well on this challenge. How many times will you eat well? My personal goal is 110. I enter that into the green target box for nutrition in the goal section.
b) Resistance Training/interval/cardio: How many times in this 61 day period will you train? 2x a week? 3x a week. I am aiming for twice a week so I enter 16 sessions in the Green target areas for the various areas.
Step 3: Tracking our progress
a) Personal goal: Very up in the air, track it however you want. I put a place for a basic description and some notes. if you type "yes" into the completion box it will add the points on to the total for you.
b) Competitive goal: Enter the name of the event, when it is, and if you have registered. Again type yes in the completion box when you are finished. An example is provided in the purple circles below
c) Nutrtion: Each day has a single spot. Enter 2 if you ate according to your plan the whole day or 1 if you screwed up a little and only managed to eat clean for part of the day. If you really screwed the pooch, enter 0. Nutrition is illustrated in the red circle below.
d) Fitness: on the seperate page each of the days has 3 categories, RT(Resistance), Int (Intervals), SS(Steady state). Enter the number of sessions you completed on the given day.
As the challenge progresses the tracker will tally up your sessions and compared them to the goals you have set and express them as a percentage. It will also caluclate the total points you have attained based on the multipliers discussed in the official rules.
If you choose to publish your tracker sheet you can make it viewable to everyone so we can view your progress on the fly. As you will find in my signature.
I hope this helps you use the google spreadsheet a little better.
Pros and Cons: The excel spreadsheet is prettier. The google sheet can be accessed anywhere.
Keith
Google SpreadSheet 61 day Tracker Instructions
