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

RayCun

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

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

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

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

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

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

rom

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

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

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

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

hardCopy

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

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

Bally8

My aim for this week is to get my completion date into 2013 too Its feb 2014 at the moment!

rom

Someone broke positions.

robinph

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

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

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

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

I have been removed too (

kit3

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

tHE vAGGABOND

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

Krusty_Clown

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

menoscemo

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

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

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

Krusty_Clown

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

robinph

^and fixed your #REF things.

Comic Book Guy

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

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

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

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

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

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

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

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

RayCun

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

pconn062

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

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

Foxx92

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

Incredible training Ray, well done!

TFBubendorfer

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

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

hopefully back in a week or so

RayCun

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

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

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

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

roseybear wrote: »

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

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

ecoli

And Im back. Ya miss me:D

Stanley Devastating

300 miles since the 16th January.

pconn062

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