login
Another record keeping option for challenges.
-
No new posts
 2007-11-02 10:52 AM |
 Lethbridge, Alberta Bronze member |  Subject: Another record keeping option for challenges.I was over on slowtwitch and saw a useful new idea, new to me at least. For the November swim challenge on that site they are using a Google spreadsheet to let everyone record their own goals and daily progress. I'm sure that kind of online document would work for some of our challenges too. Check it out if you're interested.  |
| 2007-11-02 11:55 AM in reply to: #1034952 |
Iron Donkey 38643      , Wisconsin | Subject: RE: Another record keeping option for challenges. You have the URL/link? I don't visit that site. Thanks. |
| 2007-11-02 12:25 PM in reply to: #1034952 |
| Lethbridge, Alberta Bronze member | Subject: RE: Another record keeping option for challenges. Check out docs.google.com for a description of the online doc system. For their swim challenge they have created a spreadsheet that everyone in the challenge can edit online. It contains cell formulas to total up daily distance entries, automatically convert between yards and meters, compare totals and goals, etc. Pretty much anything you would expect a spreadsheet to do, just letting everyone take care of their own data entry. |
| 2007-11-02 3:53 PM in reply to: #1034952 |
Champion 26509 Sydney | Subject: RE: Another record keeping option for challenges. That sounds fantastic from a team leaders point of view!!! And it would make the challenges easier to set up! |
| 2007-11-02 9:16 PM in reply to: #1035116 |
Champion 23360 Taser-World | Subject: RE: Another record keeping option for challenges. 1stTimeTri - 2007-11-02 12:55 PM You have the URL/link? I don't visit that site. Thanks. I found a link via Google search: http://forum.slowtwitch.com/Slowtwitch_Forums_C1/Triathlon_Forum_F1... Wow. It looks like a really cool spreadsheet idea! |
| 2007-11-02 9:23 PM in reply to: #1035168 |
Champion 23360 Taser-World | Subject: RE: Another record keeping option for challenges. Micawber - 2007-11-02 1:25 PM Check out docs.google.com for a description of the online doc system. For their swim challenge they have created a spreadsheet that everyone in the challenge can edit online. It contains cell formulas to total up daily distance entries, automatically convert between yards and meters, compare totals and goals, etc. Pretty much anything you would expect a spreadsheet to do, just letting everyone take care of their own data entry. I REALLY like this spreadsheet. BUT, what's to keep people from messing it all up? For example, say n00bieX logs in, and accidently deletes half the columns? If we can work out how to prevent this, I think it's a great idea. The answer may just be that we just download it frequently to our personal computers. That way, we'd have a relatively recent backup copy all the time. Worst case, people might need to re-enter their data for that day. (Cat - check out some of the goals these people have! Kind of inspires me for next month! LOL) Dee |
| 2007-11-02 9:35 PM in reply to: #1035845 |
Champion 26509 Sydney | Subject: RE: Another record keeping option for challenges. D001 - 2007-11-03 1:23 PM Micawber - 2007-11-02 1:25 PM Check out docs.google.com for a description of the online doc system. For their swim challenge they have created a spreadsheet that everyone in the challenge can edit online. It contains cell formulas to total up daily distance entries, automatically convert between yards and meters, compare totals and goals, etc. Pretty much anything you would expect a spreadsheet to do, just letting everyone take care of their own data entry. I REALLY like this spreadsheet. BUT, what's to keep people from messing it all up? For example, say n00bieX logs in, and accidently deletes half the columns? If we can work out how to prevent this, I think it's a great idea. The answer may just be that we just download it frequently to our personal computers. That way, we'd have a relatively recent backup copy all the time. Worst case, people might need to re-enter their data for that day. (Cat - check out some of the goals these people have! Kind of inspires me for next month! LOL) Dee Maybe there is a way of locking the cells or something based on login? I dont know... The goals are great... will be interesting to see what us BTers can come up with next month |
| 2007-11-03 10:54 AM in reply to: #1035860 |
Champion 23360 Taser-World | Subject: RE: Another record keeping option for challenges. OK, since I have nothing to do this weekend.... (Hahahahaha!) I'll try to set up one of these. (For my team, of course!) |
| 2007-11-03 12:21 PM in reply to: #1036128 |
Champion 23360 Taser-World | Subject: RE: Another record keeping option for challenges. It was really easy to do this. You just create a Google Docs account. Then you upload an existing spreadsheet. (Don't try to create the spreadsheet directly on Google Docs. For me, with dial-up, it was more difficult to move around the online spreadsheet.) If you want people to access it themselves, you can add their email addresses. Very cool! Dee |
| 2007-11-03 7:53 PM in reply to: #1035860 |
Champion 23360 Taser-World | Subject: RE: Another record keeping option for challenges. OK, take a look at this: http://spreadsheets.google.com/pub?key=puhAA5NRKHA1WLsma93eYbw 1) Set up a Google Docs account. 2) Upload the spreadsheet. 3) Change the "Share" option to public - so everyone can see it. 4) Add emails for the team members, so they can edit it. (I haven't done this step yet.) Then everyone can enter their own data. VERY much easier than having all the team leaders enter the info for each person.... Dee |
|
|
|
View profile
Add to friends
Go to training log
Go to race log
Send a message
View album
CONNECT WITH FACEBOOK