2012 - 1000 mile challenge - How far have you run since Jan 1st?

RayCun · 29-02-2012 2:53pm

There was a formula on the running streak page, which I just noticed and removed. It looked at the date entered as 'start of streak', calculated the days since then and entered that as the number of days in the running streak. Which sounds fine, but it assumes that your running streak is continuing unless you specifically go in to say it has stopped. Which is not how things usually work.

CloseToTheEdge · 01-03-2012 12:07am

Must hold my hand up in some respect, I put the formula in my own row to save me updating both the days and the distance every day. Of course it must have been spotted and someone copied it across many people.

CloseToTheEdge · 01-03-2012 12:24am

What about putting in the following into the distance column

=vlookup("CloseToTheEdge",'Enter distance here'!A2:E300,5,False)

it would copy my miles from the other sheet.

a generic one would be

=vlookup(A10,'Enter distance here'!A2:E19,5,False)

I'll let you decide RayCun.

RayCun · 01-03-2012 8:36am

Same problem there - it will keep updating your 'running streak miles' value even after your running streak has stopped. When you start a new streak you'll be starting again from zero, but the formula can't handle that.

CloseToTheEdge · 01-03-2012 2:38pm

Thats true, it works currently but I would have to subtract the previous streak distances from the formula if I started a new streak.

Anyway just back from my 8 mile lunch time run, must update the distance and streak pages while I'm logged on.

robinph · 01-03-2012 2:50pm

See, this way of doing the 1000 mile challenge is educational as well with people thinking up al these weird calculations.

rom · 01-03-2012 11:09pm

CloseToTheEdge wrote: »

What about putting in the following into the distance column

=vlookup("CloseToTheEdge",'Enter distance here'!A2:E300,5,False)

it would copy my miles from the other sheet.

a generic one would be

=vlookup(A10,'Enter distance here'!A2:E19,5,False)

I'll let you decide RayCun.

why can't you do it for your own one if you want like =''Enter distance here'!A2 if you want ?

RayCun · 02-03-2012 8:58am

rom wrote: »

why can't you do it for your own one if you want like =''Enter distance here'!A2 if you want ?

That still assumes that the streak is unbroken, and started on Jan 1.

rom · 02-03-2012 2:20pm

RayCun wrote: »

That still assumes that the streak is unbroken, and started on Jan 1.

I agree. Just giving the better formula even though its flawed in concept but if a person was to maintain their own one each then it would be ok

hardCopy · 02-03-2012 4:26pm

My estimated completion date is creeping ever closer. Hoping I can get it into 2013 by the end of the week.

hardCopy · 05-03-2012 9:46am

hardCopy wrote: »

My estimated completion date is creeping ever closer. Hoping I can get it into 2013 by the end of the week.

Done, thanks to 5 runs last week including a 20K long run I am now comfortably inside 2013 for 1000 miles!

OldBloke · 05-03-2012 2:35pm

My estimated completion date creeps ever further - thanks to a slight tear in my calf I must rest a while longer.

Bally8 · 05-03-2012 10:00pm

My aim for this week is to get my completion date into 2013 too

Its feb 2014 at the moment!

rom · 06-03-2012 3:10pm

Someone broke positions.

robinph · 06-03-2012 4:31pm

rom wrote: »

Someone broke positions.

It looks worse than it is. It's just an error caused when a line in one of the other sheets gets deleted and Google has a bit of a fit and throws in that duff #ref stuff.

I tried to fix it just now but Google is insisting on talking to me in Greek at the moment so I'm not sure what the message it just spat out at me was. Any idea how to force what language of Google you get so that you don't get the "local" one due to Google thinking it knows better than me?

Edit: Found it, copy and paste of some formulas obviously doesn't quite work right when you are using the ελληνικά version.

littlebug · 07-03-2012 9:08pm

Some missing again? Can't see myself, Madon or Meathcountysec there now. I'd assume more than us gone? must get myself onto the locked sheet:rolleyes:

Now I have to do some counting... can't remember if I was just under or just over 190:(

RayCun · 08-03-2012 8:41am

littlebug wrote: »

Now I have to do some counting... can't remember if I was just under or just over 190:(

There's a 195 there with no name attached?
But yeah, go on to the locked sheet...

littlebug · 08-03-2012 9:24am

Not me at 195 so there's obviously someone else gone. I've put myself back in at 189 thanks to Madon remembering my mileage

tHE vAGGABOND · 08-03-2012 10:11am

I have been removed too

(

kit3 · 08-03-2012 2:57pm

I'm gone too - must set up a gmail account !

tHE vAGGABOND · 09-03-2012 12:57pm

Not going to bother adding myself back in, if someone is getting their kicks ruining it, will track on my log.

Krusty_Clown · 09-03-2012 1:19pm

Top 6, and random others gone from the list now..
How do I get access to the locked sheet?

menoscemo · 09-03-2012 1:24pm

Krusty_Clown wrote: »

Top 6, and random others gone from the list now..
How do I get access to the locked sheet?

Sign in using a google account and drop Robinph a PM with your google name to get access!1

I grabbed my opportunity to access the locked sheet and go top of the league for the first time. Woohoo!!

RayCun · 09-03-2012 1:26pm

in case anyone's lost info, a few hours ago the top places were
ray_lanigan M35 950 950.00
T-Runner M35 1389 863.09
opus M40 1118.5 695.01
Krusty_Clown M40 688.45 688.45
TFBubendorfer M40 680 680.00
menoscemo M 640 640.00
ultrapercy M35 634.13 634.13
jeffontour M35 1004.76 624.33

robinph · 09-03-2012 1:37pm

I've reverted to just before that deletion. Also a couple more people added to access the locked sheet including Krusty.

Krusty_Clown · 09-03-2012 2:56pm

Thanks. I deleted my original entry from the list, so caused one of those referential errors.

robinph · 09-03-2012 2:57pm

^and fixed your #REF things.

Comic Book Guy · 09-03-2012 10:37pm

I was one of the random people deleted :mad:.

Have my distances saved on my phone though so added myself back in so no harm done

b.harte · 10-03-2012 12:53pm

Krusty_Clown wrote: »

Thanks. I deleted my original entry from the list, so caused one of those referential errors.

Ahem, I think I might have sort of maybe done the same thing when I removed my row from the sheet, on the locked sheet now.:o:o

coach22 · 10-03-2012 1:04pm

Just back from the bundoran 10 mile run. beat my time by 2 minutes 20 on last year so delighted with that. it took me 1:08:10. Still along way off completing a 1000 miles this year though!

eyeball kid · 10-03-2012 5:39pm

Second longest run of the year there for me. 13km - 2 laps around Hyde Park
in London.

Then did a gentle 4 mile cycle home. Is that a good way to warm down after a run?

littlebug · 11-03-2012 10:19am

Updated my miles in the locked sheet AND the "enter distance here" sheet and now I'm in the positions sheet twice :rolleyes: Could someone sort/ delete/ whatever for me?

RayCun · 11-03-2012 10:53am

littlebug wrote: »

Updated my miles in the locked sheet AND the "enter distance here" sheet and now I'm in the positions sheet twice :rolleyes: Could someone sort/ delete/ whatever for me?

deleted you from the open sheet

robinph · 11-03-2012 5:44pm

I saw the message this morning but then forgot to fix it before heading out, thanks for fixing that RayCun. No running miles for me today, but I'm totally knackered from doing 57miles on the bike, doesn't help that I've not been on the bike in many months. Was a lovely day for it.

BeepBeep67 · 11-03-2012 6:25pm

Just completed my highest mileage week in 28 years - 65.3 miles to rocket up to 41st place

RayCun · 12-03-2012 10:11am

Ray Lanigan first one over the 1000 - 1013 miles as of yesterday? this morning?
Very impressive, great running.

pconn062 · 12-03-2012 9:01pm

RayCun wrote: »

Ray Lanigan first one over the 1000 - 1013 miles as of yesterday? this morning?
Very impressive, great running.

:eek:

He should be locked up!

davedanon · 13-03-2012 4:22pm

A round of applause from me. 11th March? Outstanding.

Foxx92 · 15-03-2012 12:05pm

I think somebody has something against me as its the second time I've been deleted off the list :eek::rolleyes:

Also well done ray!

RubyK · 16-03-2012 9:08am

Incredible training Ray, well done!

TFBubendorfer · 20-03-2012 10:23am

Ray, astounding achievement!

Robin, there should be a date in the "completion date" column in the positions sheet. It's fine in the entry and "copy" sheets.

Trampas · 20-03-2012 2:05pm

haven't ran in nearly 3 weeks now since I have tear in my mcl.

hopefully back in a week or so

RayCun · 21-03-2012 8:46am

I'm competing against that '1000 mile estimate date' column these days, trying to drag it back into May. Down to June 4 now, from June 10 (?) a couple of weeks ago...

robinph · 21-03-2012 9:36am

RayCun wrote: »

I'm competing against that '1000 mile estimate date' column these days, trying to drag it back into May. Down to June 4 now, from June 10 (?) a couple of weeks ago...

Agreed, that date column is great. That and trying to beat Woddle are my main motivations.

roseybear · 21-03-2012 7:07pm

how am i getting up so high on the table?! is this because ppl are only using the locked sheet now? if that's not the case, cmon lads, i'm only a young one, yaz should be schooling me in the mileage

RayCun · 21-03-2012 7:19pm

roseybear wrote: »

how am i getting up so high on the table?!

You're running a lot

The locked sheet also feeds into the Positions sheet, and you're 23rd overall.

Krusty_Clown · 21-03-2012 9:15pm

roseybear wrote: »

cmon lads, i'm only a young one:p

Running is easier for young ones. Oldies have to work harder.

ecoli · 21-03-2012 9:49pm

And Im back. Ya miss me:D

Stanley Devastating · 22-03-2012 12:20pm

300 miles since the 16th January.

pconn062 · 22-03-2012 1:25pm

Well done to T runner, second person to 1000 miles on the 21st, very impressive.

2012 - 1000 mile challenge - How far have you run since Jan 1st?

Comments