Spreadsheet: 159514d1338724507-calulating-range-of-smallest-cells-values-book1_bazzabarry
Sheet: Sheet1

Please Note: It's hard to show the current leader in the Grand Prix results because runners need to complete in 3 from 5 races in the Road, Fell & Trail races. The best 3 results from each category will go towards the final results where runners need to complete the 9 races to count, this will become alot clearer when the runners  have completed alot more races. The winner will be the runner with the lowest points from the 9 races. This system works with all other Grand Prix series around the North-west including the mid-Lancs. and Red rose cross country.
 |  |  |  |  | Hameldon (fell) | Pinhaw ( Trail) | [NAME]( Trail) | Burnley Lions 10K(road) | Kelbrook(fell) | Barley Classic(fell) | Burnley Boys Club 10K(Road) | Hendon Brook(Road) | Trawden(Trail) | Towneley 5K(road) | [NAME]) | Hurst Green(Trail) | Cliviger 6 mile( Road) | Worsthorne Moor (Trail) | Buulsworth Fell( fell) | Total Road Points ( 3from 5) | Total Trail points ( 3from 5) | Total Fell points ( 3 from 5) | Overall points best 3 from 5 road,Trail & Fell
Num | Forename | Surname | Cat | Club | F | T | T | R | F | F | R | R | T | R | F | T | R | T | F | Road | Trail | Fell | Overall | Rank | Helper
107 | Beckie | [NAME] | FJ | [NAME] | 2
209 | [NAME] | [NAME] | F | Holmfirth |  | 2
34 | [NAME] | Green | F | Keighley + Craven AC | 1 | 1 | 1 |  | 1 | 2 | 1 | 2 | 1 | 3 |  | 5 |  |  |  | 6 | 3 | 4 | 13 | 1 | 1.006
136 | [NAME] | [NAME] | F | Clayton le Moors Harriers | 3 |  | 2 |  | 2
3 | [NAME] | Horrocks | F45 | Clayton le Moors Harriers | 7
125 | Helena | Leathley | FJ | Clayton le Moors Harriers | 4 |  | 3
47 | [NAME] | Koth | F35 | [NAME] | 9
220 | [NAME] | Whittaker | F50 | Wharfdale |  | 9
148 | Tamara | Hemsley | F35 | Wharfedale Harriers | 10
230 | [NAME] | Waterhouse | F55 | Central |  | 11
32 | [NAME] | Butterworth | F45 | Skipton AC | 6 | 6 |  |  | 7
58 | [NAME] | Bunce | F | Red Rose Road Runners | 12
94 | Gayle | Whittaker | F35 | Clayton le Moors Harriers | 8 |  | 4 |  | 3
244 | [NAME] | Gartside | F40 | Trawden AC |  | 12 |  |  | 10
245 | [NAME] | Tipier | F | unattached |  | 5 | 7 |  | 4
302 | Dawn | Richards | F45 | Clayton le Moors Harriers |  |  | 12
43 | Molly | Ralphson | F35 | Trawden AC | 5 | 3 | 5
132 | Kaye | Callaghan | F40 | Accrington Road Runners | 13
250 | [NAME] | Bostock | F55 | [NAME] |  | 14
289 | Anna | [NAME] | F | Unattached |  |  | 15
259 | [NAME] | Helliwell | F | unattached |  | 16
265 | [NAME] | Knightley | F50 | Clayton le Moors Harriers |  |  | 16
117 | [NAME] | Hoyle | F | Trawden AC | 17
229 | Helen | [NAME] | F40 | Todmorden Harriers |  | 17
11 | [NAME] | Newbold | F45 | Wharfedale Harriers | 18
267 | [NAME] | Adams | F60 | Northern Vets AC |  |  | 18
109 | [NAME] | [NAME] | F45 | Accrington Road Runners | 19
71 | [NAME] | Plowman | F45 | Red Rose Road Runners | 20
287 | [NAME] | Maxfield | F | Trawden AC |  |  | 20
61 | Glenda | [NAME] | F50 | Red Rose Road Runners | 22
260 | Julie | Wyant | F40 | Todmorden Harriers |  | 22
290 | [NAME] | Southworth | F | Unattached |  |  | 22
91 | Nikki | [NAME] | F35 | Red Rose Road Runners | 23
296 | [NAME] | Motley | F | Unattached |  |  | 23
42 | Sue | Narey | F40 | Wharfedale Harriers | 24
214 | [NAME] | Whittaker | F | [NAME] |  | 24 |  |  | 16
235 | [NAME] | Wood | F40 | Trawden AC |  | 13 | 11 |  | 12
52 | Sue | Morley | F55 | [NAME] | 25
300 | Kelly | Domington | F | [NAME] |  |  | 25
188 | Rebecca | Coxhead | F | Newbury AC | 26
295 | Yvonne | [NAME] | F45 | Clayton le Moors Harriers |  |  | 26
54 | Emma | Raven | F | Bingley Harriers + AC | 11 | 11 | 6
272 | Charlotte | Langowski | F | A1PersonalTraining U/a |  |  | 28
7 | Caren | Crabtree | F35 | Wharfedale Harriers | 29
168 | [NAME] | Toms | F | Rossendale Harriers | 16 | 4 | 9 |  | 9
133 | Nicola | [NAME] | F40 | Trawden AC | 15 | 7 | 8 |  | 6
274 | [NAME] | Toms | F45 | Unattached |  |  | 30
147 | Anne | Milner | F45 | Unattached | 31
187 | [NAME] | Roche | F50 | Clayton le Moors Harriers | 14 | 8 | 10 |  | 8
159 | [NAME] | Holland | F40 | Unattached | 33
157 | [NAME] | Mills | F35 | Unattached | 35
18 | [NAME] | Cape | F45 | Red Rose Road Runners | 37
163 | Cathryn | [NAME] | F40 | Accrington Road Runners | 38
253 | [NAME] | Rawlinson | F60 | [NAME] |  | 21 | 17
6 | Lynda | Hargreaves | F45 | Wharfedale Harriers | 39
50 | [NAME] | Pudge | F40 | Trawden AC | 40
25 | Pauline | Byers | F50 | Unattached | 42
36 | [NAME] | Parfitt | F | Unattached | 43
24 | [NAME] | Strong | F | Wharfedale Harriers | 45
128 | Dawn | Lock | F65 | [NAME] | 46
199 | Gabrielle | [NAME] | F | Unattached | 47
201 | Maxine | [NAME] | F35 | Accrington Road Runners | 30 | 18 |  |  | 15
104 | Helen | Buchan | F | Unattached | 21 | 15 | 13
115 | [NAME] | Catlow | F | Trawden AC | 32 | 23
165 | Colette | Mallabourn | F40 | Accrington Road Runners | 36 |  | 21
134 | Rachel | [NAME] | F40 | Unattached | 28 | 19 | 14
141 | [NAME] | Livesey | F | Trawden AC | 27 | 20 | 19 |  | 19
31 | Karin | Goss | F60 | Clayton le Moors Harriers | 34 | 25 | 24 |  | 17
20 | [NAME] | Sharples | F40 | Accrington Road Runners | 41 | 26 | 27
122 | Christine | Leathley | F60 | Clayton le Moors Harriers | 44 | 27 | 29
312 | Val | Kerr | F50 | [NAME] |  |  |  |  | 11
317 | [NAME] | Smith | F40 | [NAME] |  |  |  |  | 5
323 | [NAME] | Sugden | F45 | Trawden AC |  |  |  |  | 14
325 | [NAME] | Savage | F45 | Clayton le Moors Harriers |  |  |  |  | 13
334 | [NAME] | Haworth | F35 | [NAME] |  |  |  |  | 18