Spreadsheet: 52373d1252067640-populate-cells-depending-on-criteria-of-other-cell-uploadfile
Sheet: Members

 | Pre | 7/8ths | BB | Score | New H'Cap |  | Pre | 7/8ths | MB | Score | New H'Cap |  | Pre | 7/8ths | [NAME] | Score | New H'Cap
 | 12.6 | 11 | Old Links | 4 | 12.8 |  | 16 | 14 | Old Links | 22 | 16.4 |  | 29.6 | 26 | Old Links | 2 | 30.2
 | 13 | 11 | Fairhaven | 0 | 12.8 |  | 16 | 14 | Fairhaven | 0 | 16.4 |  | 30 | 26 | Fairhaven | 0 | 30.2
 | 13 | 11 | Clitheroe | 0 | 12.8 |  | 16 | 14 | Clitheroe | 0 | 16.4 |  | 30 | 26 | Clitheroe | 0 | 30.2
 | 13 | 11 | Lancaster | 30 | 12.8 |  | 16 | 14 | Lancaster | 22 | 16.8 |  | 30 | 26 | Lancaster | 28 | 30.8
 | 13 | 11 | Pleasington | 30 | 12.8 |  | 17 | 15 | Pleasington | 24 | 17.2 |  | 31 | 27 | Pleasington | 28 | 31.4
 | 13 | 11 | Fleetwood | 30 | 12.4 |  | 17 | 15 | Fleetwood | 29 | 16.8 |  | 31 | 27 | Fleetwood | 28 | 31.4
 | 12 | 11 | Shaw Hill | 30 | 12.6 |  | 17 | 15 | Shaw Hill | 42 | 14.4 |  | 31 | 27 | Shaw Hill | 33 | 32
 | 13 | 11 | Green Drive | 33 | 12.8 |  | 14 | 12 | Green Drive | 23 | 14.8 |  | 32 | 28 | Green Drive | 21 | 32.6
 | Pre | 7/8ths | PC | Score | New H'Cap |  | Pre | 7/8ths | TD | Score | New H'Cap |  | Pre | 7/8ths | [NAME] | Score | New H'Cap
 | 13 | 11 | Old Links | 23 | 13 |  | 26 | 23 | Old Links | 14 | 26.6 |  | 7.2 | 6 | Old Links | 2 | 7.4
 | 13 | 11 | Fairhaven | 0 | 13 |  | 27 | 24 | Fairhaven | 0 | 26.6 |  | 7 | 6 | Fairhaven | 0 | 7.4
 | 13 | 11 | Clitheroe | 0 | 13 |  | 27 | 24 | Clitheroe | 0 | 26.6 |  | 7 | 6 | Clitheroe | 0 | 7.4
 | 13 | 11 | Lancaster | 16 | 13.2 |  | 27 | 24 | Lancaster | 26 | 27.2 |  | 7 | 6 | Lancaster | 25 | 7.6
 | 13 | 11 | Pleasington | 27 | 13.4 |  | 27 | 24 | Pleasington | 21 | 27.8 |  | 8 | 7 | Pleasington | 0 | 7.6
 | 13 | 11 | Fleetwood | 27 | 13.6 |  | 28 | 25 | Fleetwood | 26 | 28.4 |  | 8 | 7 | Fleetwood | 0 | 7.6
 | 14 | 12 | Shaw Hill | 0 | 13.6 |  | 28 | 25 | Shaw Hill | 31 | 29 |  | 8 | 7 | Shaw Hill | 28 | 7.8
 | 14 | 12 | Green Drive | 0 | 13.6 |  | 29 | 25 | Green Drive | 25 | 29.6 |  | 8 | 7 | Green Drive | 29 | 8
 | Pre | 7/8ths | JF | Score | New H'Cap |  | Pre | 7/8ths | SG | Score | New H'Cap |  | Pre | 7/8ths | AL | Score | New H'Cap
 | 7.4 | 6 | Old Links | 23 | 7.4 |  | 19.4 | 17 | Old Links | 16 | 19.8 |  | 13 | 11 | Old Links | 33 | 11
 | 7 | 6 | Fairhaven | 0 | 7.4 |  | 20 | 18 | Fairhaven | 0 | 19.8 |  | 11 | 10 | Fairhaven | 0 | 11
 | 7 | 6 | Clitheroe | 0 | 7.4 |  | 20 | 18 | Clitheroe | 0 | 19.8 |  | 11 | 10 | Clitheroe | 0 | 11
 | 7 | 6 | Lancaster | 22 | 7.6 |  | 20 | 18 | Lancaster | 23 | 20.2 |  | 11 | 10 | Lancaster | 22 | 11.2
 | 8 | 7 | Pleasington | 37 | 6.2 |  | 20 | 18 | Pleasington | 23 | 20.6 |  | 11 | 10 | Pleasington | 36 | 10
 | 6 | 5 | Fleetwood | 24 | 6.4 |  | 21 | 18 | Fleetwood | 23 | 21.2 |  | 10 | 9 | Fleetwood | 22 | 10.2
 | 6 | 5 | Shaw Hill | 24 | 6.6 |  | 21 | 18 | Shaw Hill | 23 | 21.8 |  | 10 | 9 | Shaw Hill | 17 | 10.4
 | 7 | 6 | Green Drive | 33 | 6.8 |  | 22 | 19 | Green Drive | 39 | 20.6 |  | 10 | 9 | Green Drive | 25 | 10.6
 | Pre | 7/8ths | PM | Score | New H'Cap |  | Pre | 7/8ths | BS | Score | New H'Cap |  | Pre | 7/8ths | DS | Score | New H'Cap
 | 12.8 | 11 | Old Links | 23 | 12.8 |  | 8.4 | 7 | Old Links | 17 | 8.6 |  | 27.4 | 24 | Old Links | 5 | 28
 | 13 | 11 | Fairhaven | 0 | 12.8 |  | 9 | 8 | Fairhaven | 0 | 8.6 |  | 28 | 25 | Fairhaven | 0 | 28
 | 13 | 11 | Clitheroe | 0 | 12.8 |  | 9 | 8 | Clitheroe | 0 | 8.6 |  | 28 | 25 | Clitheroe | 0 | 28
 | 13 | 11 | Lancaster | 31 | 12.6 |  | 9 | 8 | Lancaster | 0 | 8.6 |  | 28 | 25 | Lancaster | 38 | 23.2
 | 13 | 11 | Pleasington | 21 | 12.8 |  | 9 | 8 | Pleasington | 37 | 7.2 |  | 23 | 20 | Pleasington | 31 | 22.6
 | 13 | 11 | Fleetwood | 21 | 13 |  | 7 | 6 | Fleetwood | 20 | 7.4 |  | 23 | 20 | Fleetwood | 19 | 23.2
 | 13 | 11 | Shaw Hill | 23 | 13.2 |  | 7 | 6 | Shaw Hill | 20 | 7.6 |  | 23 | 20 | Shaw Hill | 27 | 23.8
 | 13 | 11 | Green Drive | 21 | 13.4 |  | 8 | 7 | Green Drive | 33 | 7.8 |  | 24 | 21 | Green Drive | 34 | 24.4
 | Pre | 7/8ths | PW | Score | New H'Cap |  | Pre | 7/8ths | AW | Score | New H'Cap |  | Pre | 7/8ths | WE | Score | New H'Cap
 | 18 | 16 | Old Links | 5 | 18.4 |  | 17 | 15 | Old Links | 5 | 17.4 |  |  |  | Old Links | 0
 | 18 | 16 | Fairhaven | 0 | 18.4 |  | 17 | 15 | Fairhaven | 0 | 17.4 |  |  |  | Fairhaven | 0
 | 18 | 16 | Clitheroe | 0 | 18.4 |  | 17 | 15 | Clitheroe | 0 | 17.4 |  |  |  | Clitheroe | 0
 | 18 | 16 | Lancaster | 18 | 18.8 |  | 17 | 15 | Lancaster | 22 | 17.8 |  |  |  | Lancaster | 0
 | 19 | 17 | Pleasington | 18 | 19.2 |  | 18 | 16 | Pleasington | 17 | 18.2 |  |  |  | Pleasington | 0
 | 19 | 17 | Fleetwood | 18 | 19.6 |  | 18 | 16 | Fleetwood | 17 | 18.6 |  |  |  | Fleetwood | 0
 | 20 | 18 | Shaw Hill | 18 | 20 |  | 19 | 17 | Shaw Hill | 17 | 19 |  |  |  | Shaw Hill | 0
 | 20 | 18 | Green Drive | 37 | 20 |  | 19 | 17 | Green Drive | 42 | 17 |  |  |  | Green Drive | 0
 | Pre | 7/8ths |  | Score | New H'Cap |  | Pre | 7/8ths |  | Score | New H'Cap |  | Pre | 7/8ths |  | Score | New H'Cap
 |  |  | Old Links | 0 |  |  |  |  | Old Links | 0 |  |  |  |  | Old Links | 0
 |  |  | Fairhaven | 0 |  |  |  |  | Fairhaven | 0 |  |  |  |  | Fairhaven | 0
 |  |  | Clitheroe | 0 |  |  |  |  | Clitheroe | 0 |  |  |  |  | Clitheroe | 0
 |  |  | Lancaster | 0 |  |  |  |  | Lancaster | 0 |  |  |  |  | Lancaster | 0
 |  |  | Pleasington | 0 |  |  |  |  | Pleasington | 0 |  |  |  |  | Pleasington | 0
 |  |  | Fleetwood | 0 |  |  |  |  | Fleetwood | 0 |  |  |  |  | Fleetwood | 0
 |  |  | Shaw Hill | 0 |  |  |  |  | Shaw Hill | 0 |  |  |  |  | Shaw Hill | 0
 |  |  | Green Drive | 0 |  |  |  |  | Green Drive | 0 |  |  |  |  | Green Drive | 0
 | Pre | 7/8ths |  | Score | New H'Cap |  | Pre | 7/8ths |  | Score | New H'Cap |  | Pre | 7/8ths |  | Score | New H'Cap
 |  |  | Old Links | 0 |  |  |  |  | Old Links | 0 |  |  |  |  | Old Links | 0
 |  |  | Fairhaven | 0 |  |  |  |  | Fairhaven | 0 |  |  |  |  | Fairhaven | 0
 |  |  | Clitheroe | 0 |  |  |  |  | Clitheroe | 0 |  |  |  |  | Clitheroe | 0
 |  |  | Lancaster | 0 |  |  |  |  | Lancaster | 0 |  |  |  |  | Lancaster | 0
 |  |  | Pleasington | 0 |  |  |  |  | Pleasington | 0 |  |  |  |  | Pleasington | 0
 |  |  | Fleetwood | 0 |  |  |  |  | Fleetwood | 0 |  |  |  |  | Fleetwood | 0
 |  |  | Shaw Hill | 0 |  |  |  |  | Shaw Hill | 0 |  |  |  |  | Shaw Hill | 0
 |  |  | Green Drive | 0 |  |  |  |  | Green Drive | 0 |  |  |  |  | Green Drive | 0
 | Pre | 7/8ths |  | Score | New H'Cap |  | Pre | 7/8ths |  | Score | New H'Cap |  | Pre | 7/8ths |  | Score | New H'Cap
 |  |  | Old Links | 0 |  |  |  |  | Old Links | 0 |  |  |  |  | Old Links | 0
 |  |  | Fairhaven | 0 |  |  |  |  | Fairhaven | 0 |  |  |  |  | Fairhaven | 0
 |  |  | Clitheroe | 0 |  |  |  |  | Clitheroe | 0 |  |  |  |  | Clitheroe | 0
 |  |  | Lancaster | 0 |  |  |  |  | Lancaster | 0 |  |  |  |  | Lancaster | 0
 |  |  | Pleasington | 0 |  |  |  |  | Pleasington | 0 |  |  |  |  | Pleasington | 0
 |  |  | Fleetwood | 0 |  |  |  |  | Fleetwood | 0 |  |  |  |  | Fleetwood | 0
 |  |  | Shaw Hill | 0 |  |  |  |  | Shaw Hill | 0 |  |  |  |  | Shaw Hill | 0
 |  |  | Green Drive | 0 |  |  |  |  | Green Drive | 0 |  |  |  |  | Green Drive | 0