Subject: RE: Run 1,000 Miles in 2015OK, I can't resist getting a little anal...
I've changed the formulas at the top do calculations based on a 365 day year. It was set for a 366 day year - I'm guessing that the formulas were originally entered for a leap year.
Some people appear to be using column B for current mileage, while other people are using column C. Not a big deal either way but the bar graph won't work for everyone if we don't agree on the column to use. My suggestion is column C since it already has the heading labelled "Current Mileage". If there are no objections I can move things around a little to tidy this up.
In Column B, beside my name I have entered a formula for my personal Pace Rabbit. Since my goal isn't 1000 miles I need a different pace rabbit. If others enter their goal mileage in column E, they can copy my formula. Or I can do it for anyone that hates spreadsheets.
In column J, I have entered a formula to estimate the mileage for 2015 based on the average for the year so far.
Don
|