Author Topic: June Mustacian Biking Challenge  (Read 7393 times)

martynthewolf

  • Stubble
  • **
  • Posts: 171
  • Age: 36
  • Location: Hull - UK
    • The Frugal Wolf
June Mustacian Biking Challenge
« on: June 04, 2013, 01:21:25 AM »
Here is the link to this months spreadsheet. If it aint right let me know and i'll try and sort it out, didn't really know what I was doing tbh :P

https://docs.google.com/spreadsheet/ccc?key=0AtTdGj4aw5zMdFJKMllOc1J2T0hEWVRlOHJ2ZlprWUE&usp=sharing

Mrs WW

  • Stubble
  • **
  • Posts: 102
Re: June Mustacian Biking Challenge
« Reply #1 on: June 04, 2013, 05:38:20 AM »
Thanks Martyn!

My sheet still says May though, and is not editable. I wish I knew more about spreadsheets so that I could be of some help... But no.

martynthewolf

  • Stubble
  • **
  • Posts: 171
  • Age: 36
  • Location: Hull - UK
    • The Frugal Wolf
Re: June Mustacian Biking Challenge
« Reply #2 on: June 04, 2013, 06:22:14 AM »
Dang. I knew I would have missed something. I'll get on it

martynthewolf

  • Stubble
  • **
  • Posts: 171
  • Age: 36
  • Location: Hull - UK
    • The Frugal Wolf
Re: June Mustacian Biking Challenge
« Reply #3 on: June 04, 2013, 06:28:32 AM »
Try again Mrs WW it should be sorted now. I'm just kind of fumbling around myself haha.

Dwayne

  • 5 O'Clock Shadow
  • *
  • Posts: 16
Re: June Mustacian Biking Challenge
« Reply #4 on: June 04, 2013, 06:57:47 AM »
I added a list of the total mileage for past months at the bottom of the master page to make the "total miles EVER" calculations easier to update and more accurate.

jfer_rose

  • CM*MW 2023 Attendees
  • Pencil Stache
  • *
  • Posts: 984
  • Age: 46
  • Location: Urban Dweller
Re: June Mustacian Biking Challenge
« Reply #5 on: June 04, 2013, 07:52:38 AM »
I'm joining this for June!

crazy jane

  • Bristles
  • ***
  • Posts: 284
  • Location: Northbrook, Illinois
Re: June Mustacian Biking Challenge
« Reply #6 on: June 04, 2013, 08:20:35 AM »
Thank you! Hope to ride more this month.

yolfer

  • Pencil Stache
  • ****
  • Posts: 553
  • Age: 43
  • Location: Seattle, WA, USA
    • Camp Mustache
Re: June Mustacian Biking Challenge
« Reply #7 on: June 04, 2013, 03:45:43 PM »
Thanks for making the June spreadsheet, martynthewolf!!

Here's the May wrap-up:

We had a record-breaking 55 participants, who biked a combined 6,176 miles!! That's like biking from Los Angeles to Peru!

Our total mileage since the challenges started is 38,675 miles!  That's like biking from the northern tip of Alaska to the southern tip of Argentina. AND BACK AGAIN!!!!!!

When it comes to preventing CO2 from polluting the atmosphere, we've saved a collective 19 TONS of it!!! That's the weight of a Stryker tank! (Once again, we get to visualize face-punching an enormous object made entirely of CO2 right out of our atmosphere! Get outta here!)

As for the GEOGRAPHICAL SHOWDOWN, the results may be a bit messed up since they got shuffled part way through the month, so take these with a grain of salt. I grouped regions to make it more even:

The Southwest (CA, NV): 1181 mi
The Smokey Mountains (GA, SC, TN): 1003 mi
The Thirteen Colonies (NY, PA, DC): 909 mi
The Neighbors to the North (Canada): 739 mi
The Great Lakes (IL, MI): 653 mi
The United Nations (i.e. everyone not in North America): 413 mi
The Pacific Northwest (Seattle): 265 mi

As for the original rivalry (Seattle vs San Diego) it's San Diego by a landslide with 425 miles vs Seattle's 265 miles. We'll get you next time, San Diego!!!!

Stashasaurus

  • Stubble
  • **
  • Posts: 166
  • Location: Regina SK, Canada
Re: June Mustacian Biking Challenge
« Reply #8 on: June 04, 2013, 07:23:19 PM »
I added myself to the June master sheet. Thanks for setting this up!

Mrs WW

  • Stubble
  • **
  • Posts: 102
Re: June Mustacian Biking Challenge
« Reply #9 on: June 05, 2013, 11:50:10 AM »
Everything seems to be working now, except for my sheet being in miles instead of kilometres. How do I change this?

jen_saves

  • 5 O'Clock Shadow
  • *
  • Posts: 5
Re: June Mustacian Biking Challenge
« Reply #10 on: June 05, 2013, 01:07:46 PM »
This will be my first month doing this challenge (and also my first post). I just moved to a new apartment about 6.8 miles away from work, and I'm hoping to build up to riding in to work 3x/week by the end of the month. Thanks for setting up the spreadsheet!

destron

  • Bristles
  • ***
  • Posts: 377
  • Age: 45
  • Location: Seattle
    • Mustachian Financial Calculators
Re: June Mustacian Biking Challenge
« Reply #11 on: June 05, 2013, 11:16:11 PM »
Thanks, Marty! I look forward to kicking more tail in this month's challenge (mostly my own). I am bike commuting to work 8 mi round trip so that will come out to around 168 mi/ month just for work! I hope to throw some extra miles on top of that.

Lord Cashmoney

  • 5 O'Clock Shadow
  • *
  • Posts: 32
  • Age: 38
  • Location: Seattle, WA
Re: June Mustacian Biking Challenge
« Reply #12 on: June 06, 2013, 12:51:18 AM »
My beloved Pacific Northwest placed... last?! Depressing... yet no one here is really a loser if we collectively racked up THAT many miles! Nice work, everyone! I'll be training for a long bike tour coming up in August so my numbers will be steadily increasing over the next three months. I'll skew the numbers back in Seattle's favor, I'm certain of it! :)

martynthewolf

  • Stubble
  • **
  • Posts: 171
  • Age: 36
  • Location: Hull - UK
    • The Frugal Wolf
Re: June Mustacian Biking Challenge
« Reply #13 on: June 06, 2013, 01:47:36 AM »
Everything seems to be working now, except for my sheet being in miles instead of kilometres. How do I change this?

I sorted it out Mrs WW.

I'm not sure if everyone is allowed to edit it or not? Should they be able to?

Skinnyneo

  • 5 O'Clock Shadow
  • *
  • Posts: 97
  • Location: Yokoahama, Japan
    • Tsumashiku Kurashii - Living Frugally in Japan
Re: June Mustacian Biking Challenge
« Reply #14 on: June 06, 2013, 04:12:36 AM »
Thanks for setting this up!  I'm in for another month.

jen_saves

  • 5 O'Clock Shadow
  • *
  • Posts: 5
Re: June Mustacian Biking Challenge
« Reply #15 on: June 06, 2013, 01:37:55 PM »
Sorry for the stupid question, but I'm new to this: how do I add myself to the master summary page?

yolfer

  • Pencil Stache
  • ****
  • Posts: 553
  • Age: 43
  • Location: Seattle, WA, USA
    • Camp Mustache
Re: June Mustacian Biking Challenge
« Reply #16 on: June 06, 2013, 03:01:48 PM »
Sorry for the stupid question, but I'm new to this: how do I add myself to the master summary page?

It's sort of complicated. I added you. LMK if you want the instructions anyway (like if you're learning spreadsheets and want to increase your knowledge)

destron

  • Bristles
  • ***
  • Posts: 377
  • Age: 45
  • Location: Seattle
    • Mustachian Financial Calculators
Re: June Mustacian Biking Challenge
« Reply #17 on: June 06, 2013, 04:22:34 PM »
My beloved Pacific Northwest placed... last?! Depressing... yet no one here is really a loser if we collectively racked up THAT many miles! Nice work, everyone! I'll be training for a long bike tour coming up in August so my numbers will be steadily increasing over the next three months. I'll skew the numbers back in Seattle's favor, I'm certain of it! :)

Don't worry - I have moved from the SoCal to NW factions so the numbers will start to skew.

Shouldn't we be calculating this on an average per rider basis though?

jen_saves

  • 5 O'Clock Shadow
  • *
  • Posts: 5
Re: June Mustacian Biking Challenge
« Reply #18 on: June 07, 2013, 02:23:38 PM »
Thanks for adding me to the master list! And yes, when you get a chance, could you please let me know the spreadsheet trick you used? It'd come in handy elsewhere.

etselec

  • Stubble
  • **
  • Posts: 168
Re: June Mustacian Biking Challenge
« Reply #19 on: June 09, 2013, 08:53:40 PM »
Shouldn't we be calculating this on an average per rider basis though?

Nah. That would make lower-than-average-miles participants feel like they're dragging their region down - and I think the lower miles folks are the ones who need to be encouraged the most.

destron

  • Bristles
  • ***
  • Posts: 377
  • Age: 45
  • Location: Seattle
    • Mustachian Financial Calculators
Re: June Mustacian Biking Challenge
« Reply #20 on: June 09, 2013, 09:27:22 PM »
Shouldn't we be calculating this on an average per rider basis though?

Nah. That would make lower-than-average-miles participants feel like they're dragging their region down - and I think the lower miles folks are the ones who need to be encouraged the most.

That's true, I wouldn't want to disincentivize budding cyclists from joining in!

zinnie

  • Pencil Stache
  • ****
  • Posts: 710
  • Location: Boston
Re: June Mustacian Biking Challenge
« Reply #21 on: June 10, 2013, 03:17:01 PM »
I added myself! I started doing one-way trips to/ from work and the mileage is adding up fast. If someone wouldn't mind adding me to the master summary I'd appreciate it. Couldn't quite figure it out.

This will definitely help motivate me on those days I'm intimidated by the long/ hilly ride...

Nancy

  • Guest
Re: June Mustacian Biking Challenge
« Reply #22 on: June 10, 2013, 06:38:44 PM »
I'm in again.

Ottawa

  • Handlebar Stache
  • *****
  • Posts: 1033
Re: June Mustacian Biking Challenge
« Reply #23 on: June 26, 2013, 06:00:19 PM »
Hey Guys, I sorted the participants by Mileage.  Looks like half the sign-ups aren't entering data this time around...must be the heat ;-)

ToeInTheWater

  • Stubble
  • **
  • Posts: 142
  • Location: Central Indiana
Re: June Mustacian Biking Challenge
« Reply #24 on: June 26, 2013, 06:10:32 PM »
joined the club this month.  think i added everything correctly, including updating the master tab.

61 miles and change since i got the bike on 6/15.

plan on commuting Thur and/or Fri

b

boy_bye

  • Handlebar Stache
  • *****
  • Posts: 2471
Re: June Mustacian Biking Challenge
« Reply #25 on: June 26, 2013, 06:39:09 PM »
Awesome job, Toeinthewater!

I was away for several weeks but I'm back now and loving the bike rides sooo much. I feel cranky on days I don't get a ride in!

yolfer

  • Pencil Stache
  • ****
  • Posts: 553
  • Age: 43
  • Location: Seattle, WA, USA
    • Camp Mustache
Re: June Mustacian Biking Challenge
« Reply #26 on: June 27, 2013, 02:44:52 PM »
joined the club this month.  think i added everything correctly, including updating the master tab.

61 miles and change since i got the bike on 6/15.

plan on commuting Thur and/or Fri

b

If us spreadsheet nerds have done our jobs right, you shouldn't need to update the master tab! Is that not the case?

ToeInTheWater

  • Stubble
  • **
  • Posts: 142
  • Location: Central Indiana
Re: June Mustacian Biking Challenge
« Reply #27 on: June 27, 2013, 03:59:05 PM »
Quote
If us spreadsheet nerds have done our jobs right, you shouldn't need to update the master tab! Is that not the case?

Step 4 of the instructions said

Quote
4. If you feel comfortable, you can add yourself to the Master Summary sheet (this one); otherwise, ask someone in the forms to do it!   
         

also, i didn't see my name pop up on the master list when i added my tab.

thx
b                     

dweebyhawkeyes

  • 5 O'Clock Shadow
  • *
  • Posts: 98
  • Location: USA! USA! USA! WOOOOO
Re: June Mustacian Biking Challenge
« Reply #28 on: June 27, 2013, 10:22:50 PM »
D: Oh no! Please say this is a monthly event and I can join in July's version! I would have loved to participate, and especially as a Seattleite! What an awesome idea. Maybe I'll put mine in anyway, since I'm pretty predictably ~50 miles a week. :]

yolfer

  • Pencil Stache
  • ****
  • Posts: 553
  • Age: 43
  • Location: Seattle, WA, USA
    • Camp Mustache
Re: June Mustacian Biking Challenge
« Reply #29 on: June 28, 2013, 02:01:59 PM »
D: Oh no! Please say this is a monthly event and I can join in July's version! I would have loved to participate, and especially as a Seattleite! What an awesome idea. Maybe I'll put mine in anyway, since I'm pretty predictably ~50 miles a week. :]

Yes! We'll get a July one going in a couple days.