Forum Champs

imo it's easier if Daz does the inserting and formatting of the table (sorry daz). for the reason that the thread is readable and entry errors are less likely to happen. just a thought.

seems like a good idead to post my formula for excel from an earlier post.

------------------------------------------------------------------------------------------------
this might be of use to any other geeks that keep a race record in excel.
=ROUND(1-(A1-B1)/(B1),2)*100

cell A1 is your time. cell B1 is the winning time. It works if you have converted to seconds already or if you format the cells to TIME

Al - step aside!

Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Tot	Upcoming Races
Mole	82	78	89	88	89								426	Fairfield
IanDarkpeak	73	76	92	89									330	James' Thorn, Trunce, Burbage Skyline
Rob Furness		73	86	87	63								309	Wharfedale Marathon, Holme Moss(?), Borrowdale (or Sedbergh), Yorkshireman
noel			75	91	96								262	Rainow, Mount Famine
Hes	64	64	64	63									255	Ossy Oiks?, Rydal Round?, Borrowdale?
superflyguy		51	54	70	67								242	Burnsall
zephr	76		76	89									241	Mount Famine
Eleanor	58	56	66	57									237	Three Peaks
Mark G	67	58	52	58									235	Fairfield, Jura
Sam Harrison		69	85	73									227	Goatfell, Welsh 1000m, Clougha Pike, Wasdale
Latege	53	8	52	59	52								224	Shining Tor?, Harrock Hill?, Ilkley Trail
Stolly	76	68	69										213	Fellsman, Borrowdale
Marvin	69	76	64										209
Multiterrainer		43	69	67									179	Post Hill Challenge, Osmotherley Phoenix 33
TheReverand	89	86											175
L.F.F.		89		84									173	4 for LCT all being well!!
mrs noel			87	83									170	Masson Hill
sore legs	75		75										150	Fellsman, Surrey Hills, Welsh 1000m, Pen Y Fan, Fan y Big
DazTheSlug		4	37	41	54								136	OCT, Vanessa Chappell, Ennerdale, Welsh 1000m, Whaley Waltz
Stagger	52		35	42									129
Al Fowler					97								97
manothemoors	64												64
BritNick					64								64	Rainow, BB40, OCT, Northants Ultra, Vanessa Chappell, Games 100, Baslow Boot Bash, Classic Quarter, Whaley Waltz
PaulE			53										53
Penguin														Sedbergh
dominion

Quote:

---

Originally Posted by superflyguy

imo it's easier if Daz does the inserting and formatting of the table (sorry daz). for the reason that the thread is readable and entry errors are less likely to happen. just a thought.

---

A wise idea!

Quote:

---

Originally Posted by superflyguy

seems like a good idead to post my formula for excel from an earlier post.

------------------------------------------------------------------------------------------------
this might be of use to any other geeks that keep a race record in excel.
=ROUND(1-(A1-B1)/(B1),2)*100

cell A1 is your time. cell B1 is the winning time. It works if you have converted to seconds already or if you format the cells to TIME

---

Hey thats brilliant!

Apologies for screwing up the calcs earlier on in the thread. I had tried working it out both ways for one of my results and it turned out the same so I thought I had it right. I've re-checked and nothing needs changing so I'll make note and do it correctly from now on.

64 points for me at Fairfield Horseshoe (me: 6460, winner: 4758). I won't be doing Goatfell anymore so this could well be my best score this month!

DTS - now that the Fellsman results are out, could I put forward my results - winner 11:02, me 14:45 so I believe that makes 66 points for Apr.

When you have 5 minutes could I request that you update the table to save it going to a pile of s**t.

Paul

Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Tot	Upcoming Races
Mole	82	78	89	88	89								426	Fairfield
IanDarkpeak	73	76	92	89									330	James' Thorn, Trunce, Burbage Skyline
Rob Furness		73	86	87	63								309	Wharfedale Marathon, Holme Moss(?), Borrowdale (or Sedbergh), Yorkshireman
Sam Harrison		69	85	73	64								291	Welsh 1000m, Clougha Pike, Wasdale
noel			75	91	96								262	Rainow, Mount Famine
Hes	64	64	64	63									255	Ossy Oiks?, Rydal Round?, Borrowdale?
superflyguy		51	54	70	67								242	Burnsall
zephr	76		76	89									241	Mount Famine
Eleanor	58	56	66	57									237	Three Peaks
Mark G	67	58	52	58									235	Fairfield, Jura
Latege	53	8	52	59	52								224	Shining Tor?, Harrock Hill?, Ilkley Trail
sore legs	75		75	66									216	Surrey Hills, Welsh 1000m, Pen Y Fan, Fan y Big
Stolly	76	68	69										213	Fellsman, Borrowdale
Marvin	69	76	64										209
Multiterrainer		43	69	67									179	Post Hill Challenge, Osmotherley Phoenix 33
TheReverand	89	86											175
L.F.F.		89		84									173	4 for LCT all being well!!
mrs noel			87	83									170	Masson Hill
DazTheSlug		4	37	41	54								136	OCT, Vanessa Chappell, Ennerdale, Welsh 1000m, Whaley Waltz
Stagger	52		35	42									129
Al Fowler					97								97
manothemoors	64												64
BritNick					64								64	Rainow, BB40, OCT, Northants Ultra, Vanessa Chappell, Games 100, Baslow Boot Bash, Classic Quarter, Whaley Waltz
PaulE			53										53
Penguin														Sedbergh
dominion

Updated my next races, and Mrs Noel's score from Burbage (her time: 48:07; Rob Little 38:44 = 76 points)

Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Tot	Upcoming Races
Mole	82	78	89	88	89								426	Fairfield
IanDarkpeak	73	76	92	89									330	James' Thorn, Trunce, Burbage Skyline
Rob Furness		73	86	87	63								309	Wharfedale Marathon, Holme Moss(?), Borrowdale (or Sedbergh), Yorkshireman
Sam Harrison		69	85	73	64								291	Welsh 1000m, Clougha Pike, Wasdale
noel			75	91	96								262	Vanessa Chapel, Shutlingsloe
Hes	64	64	64	63									255	Ossy Oiks?, Rydal Round?, Borrowdale?
mrs noel			87	83	76								246	Shutlingsloe
superflyguy		51	54	70	67								242	Burnsall
zephr	76		76	89									241	Mount Famine
Eleanor	58	56	66	57									237	Three Peaks
Mark G	67	58	52	58									235	Fairfield, Jura
Latege	53	8	52	59	52								224	Shining Tor?, Harrock Hill?, Ilkley Trail
sore legs	75		75	66									216	Surrey Hills, Welsh 1000m, Pen Y Fan, Fan y Big
Stolly	76	68	69										213	Fellsman, Borrowdale
Marvin	69	76	64										209
Multiterrainer		43	69	67									179	Post Hill Challenge, Osmotherley Phoenix 33
TheReverand	89	86											175
L.F.F.		89		84									173	4 for LCT all being well!!
DazTheSlug		4	37	41	54								136	OCT, Vanessa Chappell, Ennerdale, Welsh 1000m, Whaley Waltz
Stagger	52		35	42									129
Al Fowler					97								97
manothemoors	64												64
BritNick					64								64	Rainow, BB40, OCT, Northants Ultra, Vanessa Chappell, Games 100, Baslow Boot Bash, Classic Quarter, Whaley Waltz
PaulE			53										53
Penguin														Sedbergh
dominion

Can I claim my team time for leg 1 on Calderdale way relay? What does everyone think?

Winning time - 1:16:57 and our time 1:36:06 would give 75 points (bit better than my dismal Coniston score)

Maybe claim half the points Rob:wink: