login
BT Swim Challenge (Page 12)
-
No new posts
|
 2005-05-09 4:07 PM in reply to: #155013 |
Pro  4578    Vancouver, BC |  Subject: RE: BT Swim ChallengeI could be wrong, but I think that if you have your default setting set in meters, then you will see everyone's results in meters no matter what their default setting is. Maybe you will need to convert everyone that pledged in yards to a pledge in meters. This will probably take some time. I can help if you need it. Or maybe there is another way? Oh, did everyone add a link to the blog of the person listed underneath them. This should have made the viewing of the logs easier. Jen |
| 2005-05-09 4:08 PM in reply to: #155013 |
Pro 4578 Vancouver, BC | Subject: RE: BT Swim Challenge |
 2005-05-09 4:19 PM in reply to: #155022 |
| Subject: ... This user's post has been ignored. |
| 2005-05-09 4:26 PM in reply to: #151233 |
Coach 10487  Boston, MA | Subject: RE: BT Swim Challenge Sorry to be a pain but there is a few percentages off on the team chyck… From whizzer to pirategirl the formula is off. The formula is taking the value from the cell above ex. =SUM(C27:F27)/C26 - It should be =SUM(C27:F27)/C27. Therefore jeubank for instance has a 108% when it should be 32% By fixing this the net % for the girls should be 28% |
| 2005-05-09 4:31 PM in reply to: #155037 |
| Kodiak, Alaska | Subject: RE: BT Swim Challenge amiine - 2005-05-10 12:26 PM Sorry to be a pain but there is a few percentages off on the team chyck… From whizzer to pirategirl the formula is off. The formula is taking the value from the cell above ex. =SUM(C27:F27)/C26 - It should be =SUM(C27:F27)/C27. Therefore jeubank for instance has a 108% when it should be 32% By fixing this the net % for the girls should be 28% DANG! I was hoping no one would notice!  |
| 2005-05-09 4:32 PM in reply to: #151233 |
| Veteran 257 Stirling, Scotland | Subject: RE: BT Swim Challenge I've got to agree with Jeng. Just had a look at pirategirl's total's and they are showing as 2652 meters for me, but looking through her logs you can see that she has done 2900 yards. How much do you wish you had never made this challenge TH3 FRB? Can I also point out that jeubanks percentage is obviously wrong. |
| 2005-05-09 4:34 PM in reply to: #151233 |
Master 1315 Shreveport, LA | Subject: RE: BT Swim Challenge My default was/is in yards, but the spreadsheet shows my totals in meters. |
| 2005-05-09 4:36 PM in reply to: #155021 |
| 8763 Boulder, Colorado | Subject: RE: BT Swim Challenge Hey everyone - here is what I do and have done for 15-16 years or however long I have been swimming. I log everything in yards so when I swim in meters I multiply by 1.07. If I swim 3,000 meters I enter it into my log as 3210 yards. So why doesn't everyone ENTER the number of yards they swam (either converted or true yards) and then you don't have to worry about changing defaults and all that. |
| 2005-05-09 4:50 PM in reply to: #151233 |
| Pro 3870 Virginia Beach, VA | Subject: RE: BT Swim Challenge Our slogan is now "all metric, all the time" Okay, here's PLAN B: Everyone set your default unit to meters. If you pledged in meters then you're done. If you pledged in yards then you need to convert to meters and PM me so I can change your pledge. You can still log your daily workout in meters or yards and specify the units for that specific workout...the log will do the conversion for you and add it to your monthly total. Also, everyone PLEASE add the next person on the roster (below you) to your blog tracker so I can just click from one person to the next rather than searching the entire thread. Percentages should be fixed now...I hope. Edited by TH3_FRB 2005-05-09 4:56 PM |
| 2005-05-09 5:01 PM in reply to: #155050 |
| Pro 4578 Vancouver, BC | Subject: RE: BT Swim Challenge So I did a quick conversion for Team Chyck trying to make your life easier, since you've already complained about us once today. Name Pledge Y/M Pledge in Metres Week 1 Percentage AdventureBear 6000 Y 5486.4 1097.28 0.2 Akabak 22000 Y 20116.8 5212.08 0.259090909 bmax 18000 Y 16459.2 4160.52 0.252777778 CLLinIA 17000 M 17000 5650 0.332352941 Gwozdzilla 18000 Y 16459.2 5669.28 0.344444444 InfoSteward 30000 M 30000 9050 0.301666667 Jasmine 26000 Y 23774.4 5715 0.240384615 Jeng 30000 M 30000 15575 0.519166667 JLDicarlo 46000 M 46000 15700 0.341304348 KatieYows 25000 M 25000 2200 0.088 Kepola 18000 Y 16459.2 7200 0.437445319 lingphd 20000 Y 18288 10287 0.5625 Mimir98 20000 M 20000 4800 0.24 NukeAngel 10000 Y 9144 3108.96 0.34 Possum 30000 Y 27432 4937.76 0.18 PTinVA 18000 Y 16459.2 3931.92 0.238888889 Renee 40000 Y 36576 9601.2 0.2625 Squishy 16000 M 16000 4500 0.28125 StartingtoTri 12000 M 12000 3750 0.3125 Sulis 12000 Y 10972.8 3246.12 0.295833333 SwampLantern 25000 M 25000 4000 0.16 Swimmom2002 30000 Y 27432 10744.2 0.391666667 Tizzy 6000 M 6000 2450 0.408333333 TriTakeMeAway 30000 Y 27432 6035 0.219998542 Whizzer 12000 Y 10972.8 3749.04 0.341666667 Nytrigal 20000 Y 18288 1828.8 0.1 Sleepy 12000 M 12000 4000 0.333333333 jeubank 40000 Y 36576 12938.76 0.35375 Ellie 12000 M 12000 5250 0.4375 trimom3 16000 Y 14630.4 3840.48 0.2625 nikki 8000 Y 7315.2 1371.6 0.1875 sue7013 10000 Y 9144 3383.28 0.37 lynda 25000 ? 25000 4900 0.196 PirateGirl 15000 Y 13716 2651.76 0.193333333 danae 42000 Y 38404.8 6126 0.159511311 TOTAL 737000 697538.4 198661.04 0.289862831 AVERAGE 21057.14286 19929.66857 You should be able to copy and paste this into Excel. If not I've saved it as an Excel spreadsheet, but I am not sure if I can include it in a PM. Jen |
| 2005-05-09 5:03 PM in reply to: #155060 |
| Pro 4578 Vancouver, BC | Subject: RE: BT Swim Challenge PS - If we just convert all the pledges to meters, no one should need to change their defaults. If you've set your default to meters, you will see everyone's totals in meters. Jen |
| 2005-05-09 5:07 PM in reply to: #155060 |
| Pro 3870 Virginia Beach, VA | Subject: RE: BT Swim Challenge So the second number is their pledge in meters right? And the "week 1" is thier total so far in meters also? Can you email me the xls? |
| 2005-05-09 5:13 PM in reply to: #155066 |
| Pro 4578 Vancouver, BC | Subject: RE: BT Swim Challenge Yep, that's right. Week 1 is their total in meters which I got from your spreadsheet. I've started working on it for team D!CK, oops I mean DY!K as well. I don't know how to send you an email since I don't know your addy, but I've pm'd you mine. Jen |
| 2005-05-09 5:33 PM in reply to: #151233 |
| Extreme Veteran 332 PohangSi | Subject: RE: BT Swim Challenge Wow lots of guys under 20% and 7 guys under 10% !?!?! Time to suck it up buttercup! Thanks for putting in all the effort Joel and Jen. Edited by DharmaBum 2005-05-09 5:34 PM |
| 2005-05-09 5:34 PM in reply to: #151233 |
| Master 1315 Shreveport, LA | Subject: RE: BT Swim Challenge Here is the spreadsheet for the guys. Everything is converted to meters. So all you need to do is input what you see. Also, I started hyperlinking to people's calendars, but I don't have time to do that for everyone. You may want to add those, when you do this next week. Attachments ---------------- Swim Challenge.xls (30KB - 51 downloads) |
| 2005-05-09 5:35 PM in reply to: #155031 |
| Elite 2553 Tucson, AZ | Subject: RE: BT Swim Challenge Gwozdzilla - 2005-05-09 1:19 PM My Sunday (4th swim day) where I do a coached workout with my tri club, is in meters. I am going to leave my default as yards BUT on the day I swim meters I will do the conversion (via my handy, dandy calculator) to meters and log that as yards too. ARRGGHH! I forgot that the UA pool is in meters. Dang it. Edited to add: Ok, I fixed it. 2806.29 meters this week. I'll just convert the UA pool on Sundays to yds in my daily blog, but my cumulative blog list is now in meters. At least these mistakes keep increasing my percentage. ;) You know, spacecraft end up crashing into planets because of stuff like this. ;) Edited by PirateGirl 2005-05-09 5:41 PM |
| 2005-05-09 6:52 PM in reply to: #155080 |
| Pro 3906 St Charles, IL | Subject: RE: BT Swim Challenge DharmaBum - 2005-05-09 4:33 PM Wow lots of guys under 20% and 7 guys under 10% !?!?! Time to suck it up buttercup! Thanks for putting in all the effort Joel and Jen. Hey, I put in 10k on my rest week ( last week )! Now that I'm off rest week, watch out. Or maybe I shouldn't broadcast that info since there are SPIES watching...  -Chris |
| 2005-05-09 7:02 PM in reply to: #155109 |
| Extreme Veteran 332 PohangSi | Subject: RE: BT Swim Challenge coredump - 2005-05-10 7:52 AM DharmaBum - 2005-05-09 4:33 PM Hey, I put in 10k on my rest week ( last week )! Now that I'm off rest week, watch out. Wow lots of guys under 20% and 7 guys under 10% !?!?! Time to suck it up buttercup! Thanks for putting in all the effort Joel and Jen. Or maybe I shouldn't broadcast that info since there are SPIES watching... -ChrisYeah, and you're at 24% right on target Chris. Great Job! Under 20% is still in the ball game but got some work to do. Under 10%, something is wrong. Hope it was just a freak week. |
| 2005-05-09 9:10 PM in reply to: #151233 |
| Veteran 118 Roseville, California | Subject: RE: BT Swim Challenge OK, maybe I'm missing something obvious, but why does it matter whether any individual is logging in meters or yards? The only calculation that is meaningful is the percentage of total pledged swim distance for each person during the month of May. That calculation will remain the same, regardless if you're basing it on meters or yards. The final calculation--the one that determines overall winners (men) from losers (women)--is the average percentage achieved for each team. Somebody please tell me what I'm missing... |
| 2005-05-09 9:14 PM in reply to: #155149 |
| Master 1315 Shreveport, LA | Subject: RE: BT Swim Challenge Vapor Trail - 2005-05-09 8:10 PM OK, maybe I'm missing something obvious, but why does it matter whether any individual is logging in meters or yards? The only calculation that is meaningful is the percentage of total pledged swim distance for each person during the month of May. That calculation will remain the same, regardless if you're basing it on meters or yards. The final calculation--the one that determines overall winners (men) from losers (women)--is the average percentage achieved for each team. Somebody please tell me what I'm missing... I pleged 12,000 Yards, but if it is taken as 12,000 meters then I have to swim ~10% more to make my pledge. |
| 2005-05-09 9:24 PM in reply to: #155151 |
| Veteran 118 Roseville, California | Subject: RE: BT Swim Challenge mnewton - 2005-05-09 9:14 PM Vapor Trail - 2005-05-09 8:10 PM OK, maybe I'm missing something obvious, but why does it matter whether any individual is logging in meters or yards? The only calculation that is meaningful is the percentage of total pledged swim distance for each person during the month of May. That calculation will remain the same, regardless if you're basing it on meters or yards. The final calculation--the one that determines overall winners (men) from losers (women)--is the average percentage achieved for each team. Somebody please tell me what I'm missing... I pleged 12,000 Yards, but if it is taken as 12,000 meters then I have to swim ~10% more to make my pledge. So the instant conversion to meters from yards makes all initial pledges in yards invalid? That makes no sense. If there is going to be a conversion to meters from yards then your 12,000 yards would commit you to 10,972 meters. Apples to apples. But, of course, doing such a conversion is meaningless in this competition, since the outcome either way is the same. Edited by Vapor Trail 2005-05-09 9:25 PM |
| 2005-05-09 10:27 PM in reply to: #151233 |
| Extreme Veteran 596 ma | Subject: RE: BT Swim Challenge First, I'll say...I appreciate all the effort here and the great inspirations put forth. Now....In spite of reading all the above, I'm left with being unsure how you want me to enter my distance. Further, if I am to change it, do you mean in the logs where it says "100/yards", and thats all? I submitted my goal in yards, the tally appears to be in meters. Meanwhile...i'll try to just keep on swimming. I only have until next thursday to get all in, cuz i'm getting my knee scoped!! argh!!! I hope I don't have to ask one of my comrades to swim the extra mile for me!! once again.....thank you for the inspiration!! |
| 2005-05-09 10:38 PM in reply to: #155188 |
| Pro 3870 Virginia Beach, VA | Subject: RE: BT Swim Challenge Here's the deal: My default unit for swimming is meters so when i check your log to update the spreadsheet everything gets reportd in meters automatically. If you pledged in meters then all is good. If you pledged in yards the problem is that your percentages will be off since it is taking your weekly totals (in meters) and dividing through by your pledge (in yards). the solution is to convert your PLEDGE to meters and I'll continue to update everything in meters so the spreadsheet works properly. You can log your workouts any way you like...meters if you swim meters or yards if you swim yards. You can even log yards one day and meters another if you swim at different pools. It will all be converted to meters automatically and tallied in your monthly total when I check it each week. Thanks to those that have helped do the conversions for the rest of the team...I'll sort it all out Tuesday morning and post once I *think* I have it all fixed and you all can check my work. Keep swimming!!! |
| 2005-05-09 10:39 PM in reply to: #155188 |
| Extreme Veteran 332 PohangSi | Subject: RE: BT Swim Challenge nikki - 2005-05-10 11:27 AM First, I'll say...I appreciate all the effort here and the great inspirations put forth. Now....In spite of reading all the above, I'm left with being unsure how you want me to enter my distance. Further, if I am to change it, do you mean in the logs where it says "100/yards", and thats all? I submitted my goal in yards, the tally appears to be in meters. Meanwhile...i'll try to just keep on swimming. I only have until next thursday to get all in, cuz i'm getting my knee scoped!! argh!!! I hope I don't have to ask one of my comrades to swim the extra mile for me!! once again.....thank you for the inspiration!! Nikki, Don't think you have to do anything. I think they are adjusting all of the yards goals to meters, so your goal amount will look different on the spreadsheet. Also when Joel reads your months total he will see meters because that is what his settings are so your amount swam will be converted for you. Just keep swimming. |
| 2005-05-10 9:55 AM in reply to: #151233 |
| Expert 957 St. Louis, MO | Subject: RE: BT Swim Challenge TH3 FRB, An option to clicking around trying to find everyone's logs is to create a hyperlink to that person's calendar log through your spreadsheet. Here's how you do it. 1. Find that person's log and click on "calendar" if it comes up as the blog form (Calendar view is easier because the weekly totals are posted after the last day of that week). 2. In your spreadsheet, highlight the cell of the participant's name and click the Insert drop down on your menu bar at the top. Click Hyperlink in that dropdown. This will ask you for the website that you want to correlate with this cell. 3. Click back to the person's log and highlight the the web address and copy it. Back in Excel, (if the website has not already been Auto-filled with the address (by just simply clicking on the address line)), paste the address in the field labeled "Type the file or Web page name:" 4. The text in the cell automatically becomes a link to that person's log. You just have to click on it and then enter their totals. I am terrible at explaining. If this isn't clear, just let me know and I can try to explain it a little better by email or phone. |
|
|
|
|
View profile
Add to friends
Go to training log
Go to race log
Send a message
View album
CONNECT WITH FACEBOOK