Crummy Weather Winter Showdown week one! (Nov 12-18) (Page 2)

I used your new spreadsheet and realized my original post for the week was calculated incorrectly, when I put "calm" in for the wind it gave me a multiplier of 4 and when I put zero in it took all my points away. So since I am not as savvy with excel formulas, I just took out the multiplier on Sunday and got a new point total. And changed my Tuesday run to an 8 multiplier since it was 0 degrees out. (Also I dont think I have to worry about this one but fyi...if I pretended it was warm here and put in a temp 36 or higher it also takes away your points.) Sorry I dont know how to put a spreadsheet with the corrections together but hoping you know how to do that bcuz I do like the spreadsheet.  Thanks.

Corrected point total

[sarc/on]

Oh, that's just great!  Those of us who thought we were hard core are going to get kicked around all winter by people in Alaska!  Great.  We can't complain to the Cajuns about the heat in the summer and now we can't complain to the Alaskans about the cold in the winter.  And Mesteren (Iceland) hasn't even thrown his 2 cents in yet. 

[sarc/off]

Sorry everyone, I'm no pro, just enjoy farting around with numbers and these formulas.  It is amazing how something simple like this can suddenly get complex.  Anyway, I think I figured out my errors and I've attached a new spreadsheet that corrects the problems in the previous post.  version 3.0, if you will...

Wind must be a number, fyi.  Calm, put in 0.

Im in on this. Put me down for 220 pts for my ride today.

Edit:  Oh I guess I should put a break down for this on here:

 110 min x ( 0 pt for temp + 1 pt for winds (9mph) + 0 pts for precip + 1 pt for bike sub 40 deg) =

110 x 2 = 220 pts of suckerage! 

Okay, so since the upper limit is now 50,  I DID get some points for my ride yesterday:

45 Degrees / 8 mph winds / 94 mins

94 x (1+1) =  188,  right?   

This is fun, but maybe we need a web app to caculate points!!

I forgot about my other ride this week so here's my weekly total:

11/18: 45 Degrees / 8 mph winds / 94 mins = 94 x (1+1) = 188

11/16:  45 / no wind / 65 mins = 65

Total  = 253

my stats for week one.  Just two workouts. 

Total points = 206.25

Here is my list for Nov 12-18:

Total points = 438

(Thanks to hangloose for "letting" me borrow this table format)

Here is my list for last week.  Looks like it is warming up this week. Still makes for some crummy weather but not quite as sucky, which actually is a good thing!

willow - 2006-11-20 3:43 PM ...can't believe I'm hoping for crappy weather

Hee hee!  This cracks me up!  This is what its all about.  I love it.  I'm always been disappointed when I go outside to run and its not raining or snowing, now I have a reason for it!  I can't believe it's been balmy (30's) and dry since we started this challenge!  Grrrrrrr, bring on the snow!!!!

Heck yeah.  The 10 day forcast shows "low point" weather for the next 8 days.  After that it's going to be 8 degrees/snowing, time to rack up the points.