laxdef69
Messed with Texas...
- Joined
- Mar 11, 2008
- Messages
- 850
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

)
He was really happy with that (if I didn't mention it, he's only 15). Anywho...I ran my 5 yesterday, not pretty, but finished! I'm trying to convince DS to join our Rebel team. He's a Disney freak like me and obviously he's a runner! He keeps saying he will, he just needs to find time to sign on.
Take care and stay strong!
. DS is speedy fast...it's so much fun to watch him run! Going to his cross country meets gave me a good workout--I had to get to each viewing spot pretty quickly. You've been getting in alot of workout time, what all are you doing?
!
. He did 2.3 miles with me last night and I'm very proud of him.
