laxdef69
Messed with Texas...
- Joined
- Mar 11, 2008
I can send you an updated spreadsheet...this version will carry through new teammembers names through the end of the year.
Each week ends on Friday, unless its a short or long week...you can tell by checking the formulas.
No particular reason for Friday ending, thats what Lisa (princessrunner) wanted for the goofs.
Each person's monthly total is at the bottom of their column, and the team weekly totals are in blue on each months page.
The team monthly totals and YTD are on the summary page.
let me know if you want the new version, linked here:
https://spreadsheets.google.com/ccc?key=pDo_Y1OjfFxhlUz1xx6nRZg&hl=en
I haven't tried it, but I wonder if you opened both documents, if you could copy the February sheet from your existing to the new one...that might preserve all the entries so far.
Regarding time entry, you have it right...all miles and minutes count.
For example, I rode 40 minutes on my bike trainer this AM, so I would enter 40 minutes. When I go to the YMCA and get 40 minutes on the elliptical and 5 miles, I'll have a total entry of 5 miles and 80 minutes.
Good luck Rebels!!!!
Mike
Each week ends on Friday, unless its a short or long week...you can tell by checking the formulas.
No particular reason for Friday ending, thats what Lisa (princessrunner) wanted for the goofs.
Each person's monthly total is at the bottom of their column, and the team weekly totals are in blue on each months page.
The team monthly totals and YTD are on the summary page.
let me know if you want the new version, linked here:
https://spreadsheets.google.com/ccc?key=pDo_Y1OjfFxhlUz1xx6nRZg&hl=en
I haven't tried it, but I wonder if you opened both documents, if you could copy the February sheet from your existing to the new one...that might preserve all the entries so far.
Regarding time entry, you have it right...all miles and minutes count.
For example, I rode 40 minutes on my bike trainer this AM, so I would enter 40 minutes. When I go to the YMCA and get 40 minutes on the elliptical and 5 miles, I'll have a total entry of 5 miles and 80 minutes.
Good luck Rebels!!!!
Mike