2016 - 1000 mile challenge

robinph

New thread, new year. Welcome to the 2016 version and what I think might be the 6th incarnation of the spreadsheet, and possibly year 8 of the 1000 mile challenge.

https://docs.google.com/spreadsheets/d/1P2ZIllebMPwlqLZv2bxxdbQ_Ehps4kyT8g6Qt58u9a8/edit#gid=0

Same as last year we are using Google Docs again, just click on the link above and enter your boardsie name in column A and then how far your total miles are for the year in column C, or if you count in kilometres enter that in column D. If you want you can also enter you age/ gender category in column B. Your ranking amongst the boardsies is shown on the Positions sheet.

Do not edit any other columns, except for the completion date when you have done your 1000miles. People who had access to the locked sheet last year should already be setup with access to the same sheet again, anyone that wants access to that then you'll need to PM me your Google email address so that I can enable access.

kookiebrew

Woooohoooo my six my run has put in first place

Ted_YNWA

kookiebrew wrote: »

Woooohoooo my six my run has put in first place

oooh, you have a target on your back now kookie.

robinph

As usual round this time it now happens that I'm now not in front of a PC for a day or so. Those of you who have messaged me about access to the spreadsheet jus bear with me for a day or so and I'll get you added to the list.

You can put your details onto the open sheet of the spreadsheet for now though and I'll sort things out afterwards.

robinph

kookiebrew wrote: »

Woooohoooo my six my run has put in first place

Woooohooo, my parkrun followed by a 10km race has put me in first place.


Sorry kookiebrew, but couldn't let you get too comfortable at the top of the table. I'm sure someone crazier than me will have a 20+ mile day logged shortly.

robinph

I've just spotted that I need to tweak the estimated completion date calculations. I'll get to that in a couple of days also.

kookiebrew

It was good while it lasted, literally 15 mins of fame

28064212

Yeah, sciencerunning, bitch!

I'm coming for you too, Clown*

* Probably not

TFBubendorfer

The formulas in the last 4 columns in the positions sheet all need sorting.
They all say 2015 where it should say 2016. I'd fix it myself but it won't let me

robinph

TFBubendorfer wrote: »

The formulas in the last 4 columns in the positions sheet all need sorting.
They all say 2015 where it should say 2016. I'd fix it myself but it won't let me

That should all be fixed now.

Let me know if there are any other errors in the calculations.

gilly29

do i just stick in my name, miles to date and i'll on the list then?

robinph

gilly29 wrote: »

do i just stick in my name, miles to date and i'll on the list then?

Yep, simple as that.

Then on the "Positions" tab you'll be able to see where you stack up against the rest of boardsies and a prediction for when you'll complete the 1000 miles or your total for the year.

gilly29

thanks!

eyeball kid

I went looking through the old threads just to see how I got on over the years...

2010 - 165 miles
2011 - 210 miles
2012 - 338 miles
2013 - 490 miles
2014 - 226 miles (lots of injuries )
2015 - 747 miles

I know its been slow progress but if I can continue how I got on last year and stay injury free, I'll should beat the 1000 this year (hopefully )

stringbox

Hi lads, I'm not a boards regular but I just added myself to the open sheet, hope that's ok.
I don't know what my category is, is it just gender and age? I'll just put that in for now.

_Tombstone_

stringbox wrote: »

Hi lads, I'm not a boards regular but I just added myself to the open sheet, hope that's ok.
I don't know what my category is, is it just gender and age? I'll just put that in for now.

Yup, Gender and Age............or Jedi/sith lord/wookie

TFBubendorfer

_Tombstone_ wrote: »

Yup, Gender and Age............or Jedi/sith lord/wookie

Well, actually, ...

the original intention was to put in your age group, which works in 5-year steps once you are over the ripe old age of 35, i.e. M35, F40, M45 and so on.

But you can put in anything you like.

HelenAnne

I'm in too, now! How often do people update the sheet, usually?

Ted_YNWA

HelenAnne wrote:

I'm in too, now! How often do people update the sheet, usually?

Can update as often as you like.

Varies for me. Whenever I think of it. Weekly - monthly.

kookiebrew

HelenAnne wrote: »

I'm in too, now! How often do people update the sheet, usually?

30 secs after I'm back in the house from my run

Ted_YNWA

kookiebrew wrote: »

30 secs after I'm back in the house from my run

is that your way of keeping near the top of the table :pac:

kookiebrew

Ted_YNWA wrote: »

is that your way of keeping near the top of the table :pac:

Could put in next weeks runs and would be nowhere near some of the top runners here lol

lenny palmer

I've an android phone. Can I add myself from it or do I need to use a pc/laptop. Any help would be appreciated

robinph

lenny palmer wrote: »

I've an android phone. Can I add myself from it or do I need to use a pc/laptop. Any help would be appreciated

Yes, you should be able to edit OK via the phone. Just have to watch a bit more carefully that you are editing the right cells. You'll soon figure it out.

stringbox

Wooo! Just hit 26.2 miles (cumulatively)!

BeepBeep67

Calculation in column 'M' Year total estimate should be *366, not *365

robinph

BeepBeep67 wrote: »

Calculation in column 'M' Year total estimate should be *366, not *365

Fixed, but you are now incharge of remembering to tell me to change it back to 365 next year. And also figuring out if years ending in a zero are actually leap years as I think sometimes they are not.

28064212

robinph wrote: »

Fixed, but you are now incharge of remembering to tell me to change it back to 365 next year. And also figuring out if years ending in a zero are actually leap years as I think sometimes they are not.

It's a leap year when divisible by 4, except when it's also divisible by 100, except when that's divisible by 400. Easy

Or you could just replace 366 with this that will return the number of days in the current year:

DATEDIF(DATE(YEAR(NOW()),1,1), DATE(YEAR(NOW()),12,31), "D") + 1

robinph

<Head_Explodes>

lenny palmer

This may sound stupid (well it does in my head) however. I have logged 86+ kilometres so far, when I go to log my next lot do I erase the 86+ and put in my new weeks total or do I add it to the 86+. I suppose what I'm trying to say is does it add the totals up or do I have to do it 💆

robinph

You need to add the totals yourself and then put the new number in the spreadsheet.

If you are logging your miles via something like Strava then that will show you a running total of your miles covered for the year anyway.

Bulmers74

Bit late to the 2016 party - hopefully can get a bit of consistency going & remain injury free.

stephendowney

Only getting back training properly this week so a little behind on the mileage but thought I would join anyway.
I should be back up to 25-30 miles a week from this week so hoping to break the 1000 this year.

L.Jenkins

Is it too late to join in? I've only racked up 15 km so far and I'm back on the road running.

Ted_YNWA

Never too late to join Itzy, the more the merrier.

L.Jenkins

Thanks Ted. Just working out my distance ran since I started back. Not far off 50 mile at the moment. Long way to go, with another few miles tomorrow.

Krusty_Clown

......
Woah, livin' on a prayer!

BeepBeep67

Solid start to the year, 500 on the clock.

davedanon

Just over half that at the moment. Not really worrying about mileage so much now, though. That will change when Berlin training kicks in in June, and would like to hit 2,500 for the year.

spaceylou

Just added myself - better late than never. It has my expected 1000 mile completion date in Jan 2018 - haha! Hope to do a little better than that although realistically probably won't make it to 1000 by the end of 2016

L.Jenkins

Ever little helps Spaceylou. Mine is projected to be March or May of next year. Either way, I'm running and getting fit.

liamog

I'm planning on hitting the 1600 km mark this year so I guess a 1000 mile challenge will do nicely.

Ted_YNWA

The spreadsheet assumes you will continue at same level of running for entire year. If you are starting out now, you might be going out 2/3 times a week.

As you improve both frequency & distances will increase during the year & you will see your target date get closer.

glacial_pace71

I've just entered my details. Alas I'm using a very old MacBook, that's running OS X 10.5.8 Leopard. As a result the highest versions of Safari and Chrome I have available are still ancient and so I get the "browser not supported" message. I don't think I did any harm to the spreadsheet, it seemed to save without any further warning messages.

liamog

Just hit 2017 for the projected 1000 mile completion date, it's fun watching it go down every week.

Krusty_Clown

Well, rather coincidentally (as I only run the miles that my plan tells me to), I wrapped up the first 1k miles a day earlier than last year. Given that it's a leap year, I'm going to call it a draw!

Ososlo

Krusty_Clown wrote: »

Well, rather coincidentally (as I only run the miles that my plan tells me to), I wrapped up the first 1k miles a day earlier than last year. Given that it's a leap year, I'm going to call it a draw!

Congrats

BeepBeep67

Strava tells me we are over the 1k

Ososlo

BOOM! Tonight's run brings me to 1,000.
6 weeks earlier than last year!

TFBubendorfer

Aaaaaand ..... 1000!

Coffee Fulled Runner

Hit 500 miles last night. Happy how the year is going so far I only got 830km last year.