Other Resources Challenge Me! » July Tri Challenge - Weekly Update Rss Feed  
Moderators: the bear, kaqphin, tinkerbeth, D001, k9car363, alicefoeller Reply
 
 
of 3
 
 
2005-07-15 4:40 PM
in reply to: #196550

User image

Veteran
197
100252525
Newport, RI
Subject: RE: July Tri Challenge - Weekly Update
got it. thanks!

Boy, for a minute I thought we had some real ultra athletes in here. A run goal of 200? I thought that was miles!!!! Boy, was I feeling like a schoolboy. I get it....minutes!!!!


2005-07-15 7:49 PM
in reply to: #196550

User image

Extreme Veteran
347
10010010025
Chapel Hill, North Carolina
Subject: RE: July Tri Challenge - Weekly Update
Renee......YOU ROCK!!! 
2005-07-18 12:36 PM
in reply to: #196550

User image

Giver
18427
5000500050002000100010010010010025
Subject: RE: July Tri Challenge - Weekly Update

Filling in for the amazing Capt. Kimj81. Team Hoss' Week Two Numbers (to date):

1. Kimj81: 2400yds/76.33miles/11.2miles

2. KathyG: 236.5min/522.9min/242.0min

3. joeinco: 7750yds/148.5miles/28.4miles

4. Rollin' Thunder: 7108.49yds/274.72miles/33.5miles

5. tupuppy: 100yds/63.17miles/14.7miles

6.run4yrlif: 13143.18yds/163.35miles/16.4miles

7. Gwozdzilla: 9855yds/59.6miles/8miles

8. Blackbud: 4900yds/95.72miles/18.85miles

9. Whizzer: 3960yds/249.27miles/20.7miles

2005-07-18 1:45 PM
in reply to: #196550

User image

Champion
5495
5000100100100100252525
Whizzzzzlandia
Silver member
Subject: RE: July Tri Challenge - Weekly Update

OK here's a question.... is it better to have a higher number or a lower number???? Our Team Hoss average is 1.9.... what does that MEAN?

No lengthy explanation needed... I'm just wondering....

Thanks, Whizzzzzzzzzzzz

2005-07-18 1:48 PM
in reply to: #201302

User image

Buttercup
14334
500050002000200010010010025
Subject: RE: July Tri Challenge - Weekly Update
That is the average # of people on your team who are at or above goal. Higher is better.
2005-07-18 3:09 PM
in reply to: #196550

User image

Expert
1099
1000252525
Orlando, FL
Subject: RE: July Tri Challenge - Weekly Update
Here's our Week #2 numbers:
Team Good In10tions

Name: Swim/Bike/Run totals (actual) to date

Annabananamc: 61.25/128/400.25
JodiLynn: 1600/45.1/15.52
lawlessryde: 5750/100.25/25.5
Dodgersmom: 0/11.47/156
goblue9696: 200/185/240
ejc999: 9440.42/174.39/27.6
splerph: 105/245/50
Chris Tree: 4450/91.5/32
kirby: 132/143/89
kausnfxx: 3.5/406.24/67.6


2005-07-19 10:25 AM
in reply to: #201435

User image

Buttercup
14334
500050002000200010010010025
Subject: RE: July Tri Challenge - Weekly Update
Thanks, Anna. Next time would you email? Thanks again!
2005-07-19 10:54 AM
in reply to: #202143

User image

Buttercup
14334
500050002000200010010010025
Subject: 2nd Week Update Posted Here

Team Couer de Leon is the only non-reporting team (that's why their font is red).



Edited by Renee 2005-07-19 10:55 AM




Attachments
----------------
July Tri Challenge 071805.xls (47KB - 66 downloads)

2005-07-19 12:18 PM
in reply to: #202190

Subject: ...
This user's post has been ignored.
2005-07-19 12:46 PM
in reply to: #196550

Lethbridge, Alberta
Bronze member
Subject: RE: July Tri Challenge - Weekly Update
Renee, I noticed something funny in the Five Alive team's counts. cbass shows 50% or better in two columns but her count is only 1.

Both values are correct but if you wanted to be nitpicky about the mismatched display... Her biking is actually 49.5370% and the display averages it up to 50. However, the counting function only counts columns where the actual value is >49.9%. You could change the count test to >49.4, but another solution might be to trunc() the result of the division that is displayed as a percentage. Or maybe there's a better way; I'm no excel expert.

Edit: wait a minute... just use round() on the division so the actual value is rounded and not just the displayed percentage.

Edited by Micawber 2005-07-19 12:58 PM
2005-07-19 1:22 PM
in reply to: #202314

Buttercup
14334
500050002000200010010010025
Subject: RE: July Tri Challenge - Weekly Update
Thanks, Dwayne. I'll take a look at it.


2005-07-19 3:08 PM
in reply to: #202343

Buttercup
14334
500050002000200010010010025
Subject: WEEK 2 UPDATE

I gathered Team Coeur de Leon's numbers myself. Here is the final, updated WEEK 2 tally.

Kittens of Couer de Leon, you need to get yourselves in gear and give Courtney your tallies on Mondays so that she can give them to me in a timely manner. Courtney, if you are still missing the updates from your teammates by end of day Monday, then you need to go check their logs and gather the numbers yourself.



Edited by Renee 2005-07-19 3:10 PM




Attachments
----------------
July Tri Challenge 071805.xls (47KB - 136 downloads)

2005-07-19 4:08 PM
in reply to: #202457

Subject: ...
This user's post has been ignored.
2005-07-19 4:47 PM
in reply to: #202457

Veteran
138
10025
Aurora, CO
Subject: RE: WEEK 2 UPDATE
Renee - 2005-07-19 2:08 PM

I gathered Team Coeur de Leon's numbers myself. Here is the final, updated WEEK 2 tally.

Kittens of Couer de Leon, you need to get yourselves in gear and give Courtney your tallies on Mondays so that she can give them to me in a timely manner. Courtney, if you are still missing the updates from your teammates by end of day Monday, then you need to go check their logs and gather the numbers yourself.



Hi Renee,

My (Mekarual) goal run distance is actually 40 miles, not 10. Thanks!
2005-07-20 11:16 AM
in reply to: #202586

Buttercup
14334
500050002000200010010010025
Subject: RE: WEEK 2 UPDATE
Sorry, Laura. Done.
2005-07-21 1:19 PM
in reply to: #196550

Expert
936
50010010010010025
Westchester County NY
Subject: RE: July Tri Challenge - Weekly Update

Renee,

What an awesome spreadsheet!  How did you ever come up with all those nifty formulas?  You are to be commended for your terrific bookkeeeping.!



2005-07-22 2:09 PM
in reply to: #203962

Buttercup
14334
500050002000200010010010025
Subject: RE: July Tri Challenge - Weekly Update
Thanks, Polly. The HELP option comes in handy quite a bit.
2005-07-25 4:50 PM
in reply to: #204938

Buttercup
14334
500050002000200010010010025
Subject: 3rd WEEK CHALLENGE UPDATE

... is not done because we have 3 non-reporting teams - Team Coeur de Leon, Team Five Alive and Team Guinness.

Lane, as former captain of Team Guinness maybe you could get off your ass help out and pick-up the ball for Brett. He's usually very punctual, so I assume he's simply very busy with real-life matters.

2005-07-25 5:03 PM
in reply to: #196550

Subject: ...
This user's post has been ignored.
2005-07-26 10:56 AM
in reply to: #206897

Buttercup
14334
500050002000200010010010025
Subject: 3rd WEEK UPDATE - DONE

Team Yuengling is leaving the competition way behind. 85% average goal attainment, 7 out of 10 team members are at or above their goals in all 3 sports. Impressive.

If your numbers are in red font, it's to draw your attention to it because what was reported was either a) less than what was reported last week (you went backwards?) or b) I didn't understand your numbers.





Attachments
----------------
July Tri Challenge 072505.xls (48KB - 119 downloads)
2005-07-26 2:47 PM
in reply to: #207618

Master
1315
1000100100100
Shreveport, LA
Subject: RE: 3rd WEEK UPDATE - DONE
Renee - 2005-07-26 10:56 AM
If your numbers are in red font, it's to draw your attention to it because what was reported was either a) less than what was reported last week (you went backwards?) or b) I didn't understand your numbers.


My name was in red and my numbers were not updated.

My totals as of 7/26
Swim 160 minutes
Bike 281.75 minutes
Run 162 minutes


2005-07-26 2:55 PM
in reply to: #207940

Buttercup
14334
500050002000200010010010025
Subject: RE: 3rd WEEK UPDATE - DONE
I updated your numbers. Your team % is now at 66%.
2005-08-01 9:56 PM
in reply to: #196550

Veteran
221
100100
Subject: RE: July Tri Challenge - Weekly Update
Renee I'm updated and I'm all ready to go. If you feel like paddening my numbers so they add up to 100% I won't be mad. lol
2005-08-02 9:45 AM
in reply to: #213374

Buttercup
14334
500050002000200010010010025
Subject: Final Tally - and the Winner Is...

Team Yuengling with a very impressive showing: 100% aggregrate goal attainment; all 10 members reached their goals in A3S. Congratulations!

Here's how each team ranked:

  1. Team Yuengling: 100% with 10 members at 100% for A3S
  2. Team Good In-10-tions: 96% with 8 at 100%
  3. Team Thunderbird: 95% with 4 at 100%
  4. Team Crazy Eight: 93% with 5 at 100%
  5. Team Hoss: 91% with 5 at 100%
  6. Team Guinness: 91% with 4 at 100%
  7. Team Lucky Lancers: 91% with 2 at 100%
  8. Team Endless Summer: 87% with 5 at 100%
  9. Team Five Alive: 80% with 1 at 100%
  10. Team Coeur de Leone: 60% with 1 at 100%

Some other interesting and impressive stats:

  • Average goal attainment of all participants = 90%
  • Number of participants who achieved 100% = 52%
  • Number of participants who achieved 90% or > = 67%

If you scroll down the spreadsheet, you will see all participants listed in order of % of goal attainment.

Congratulations to all!





Attachments
----------------
July Tri Challenge Final.xls (84KB - 74 downloads)
2005-08-02 9:57 AM
in reply to: #196550

Master
1315
1000100100100
Shreveport, LA
Subject: RE: July Tri Challenge - Weekly Update
For some reason, my numbers were in distances when my goals were in time:

I was 100% on all my goals:

Bike
Goal: 350 mins
Act: 357.75

Run:
Goal: 200 mins
Act: 205.3

Swim:
Goal: 170 mins
Act: 172.66

This would give us 6 at 100% and an overall % of 93%.

Sorry for the confusion.

-mnewton




Attachments
----------------
July.xls (81KB - 41 downloads)
New Thread
Other Resources Challenge Me! » July Tri Challenge - Weekly Update Rss Feed  
 
 
of 3