| Address | Clive | Value | |
| B3 | =IF(Player0!$B$1="","",Player0!$B$1) | Caz | |
| C3 | =COUNT(Player0!$A$3:$A$70) | 1 | |
| D3 | =COUNT(Player0!$AE$3:$AE$70) | 0 | |
| E3 | =C3-D3 | 1 | |
| F3 | =SUM(Player0!$AN$3:$AN$70) | 0 | |
| G3 | =SUM(Player0!$AO$3:$AO$70) | 0 | |
| H3 | =SUM(Player0!$AP$3:$AP$70) | 0 | |
| I3 | =SUM(Player0!$AQ$3:$AQ$70) | 0 | |
| J3 | =SUM(F3:I3) | 0 | |
| K3 | =MAX(Player0!$AE$3:$AE$70) | 0 | |
| L3 | =SUM(Player0!$AK$3:$AK$70) | 60 | |
| M3 | =SUM(Player0!$AL$3:$AL$70) | 474 | |
| N3 | =IF(C3=0,0,MAX(Player0!$AM$3:$AM$64))*3 | 23.7 | |
| O3 | =IF(C3=0,0,MAX(Player0!$AM$3:$AM$70)) | 7.9 | |
| P3 | =IF(C3=0,0,M3/L3) | 7.9 | |
| Q3 | =IF(C3=0,0,D3/C3) | 0 | |
| B4 | =IF(Player1!$B$1="","",Player1!$B$1) | David | |
| C4 | =COUNT(Player1!$A$3:$A$70) | 2 | |
| D4 | =COUNT(Player1!$AE$3:$AE$70) | 0 | |
| E4 | =C4-D4 | 2 | |
| F4 | =SUM(Player1!$AN$3:$AN$70) | 0 | |
| G4 | =SUM(Player1!$AO$3:$AO$70) | 0 | |
| H4 | =SUM(Player1!$AP$3:$AP$70) | 0 | |
| I4 | =SUM(Player1!$AQ$3:$AQ$70) | 0 | |
| J4 | =SUM(F4:I4) | 0 | |
| K4 | =MAX(Player1!$AE$3:$AE$70) | 0 | |
| L4 | =SUM(Player1!$AK$3:$AK$70) | 51 | |
| M4 | =SUM(Player1!$AL$3:$AL$70) | 818 | |
| N4 | =IF(C4=0,0,MAX(Player1!$AM$3:$AM$64))*3 | 53.875 | |
| O4 | =IF(C4=0,0,MAX(Player1!$AM$3:$AM$70)) | 17.95833333 | |
| P4 | =IF(C4=0,0,M4/L4) | 16.03921569 | |
| Q4 | =IF(C4=0,0,D4/C4) | 0 | |
| B5 | =IF(Player2!$B$1="","",Player2!$B$1) | Diane | |
| C5 | =COUNT(Player2!$A$3:$A$72) | 0 | |
| D5 | =COUNT(Player2!$AE$3:$AE$67) | 0 | |
| E5 | =C5-D5 | 0 | |
| F5 | =SUM(Player2!$AN$3:$AN$67) | 0 | |
| G5 | =SUM(Player2!$AO$3:$AO$67) | 0 | |
| H5 | =SUM(Player2!$AP$3:$AP$67) | 0 | |
| I5 | =SUM(Player2!$AQ$3:$AQ$67) | 0 | |
| J5 | =SUM(F5:I5) | 0 | |
| K5 | =MAX(Player2!$AE$3:$AE$67) | 0 | |
| L5 | =SUM(Player2!$AK$3:$AK$67) | 0 | |
| M5 | =SUM(Player2!$AL$3:$AL$67) | 0 | |
| N5 | =IF(C5=0,0,MAX(Player2!$AM$3:$AM$67))*3 | 0 | |
| O5 | =IF(C5=0,0,MAX(Player2!$AM$3:$AM$72)) | 0 | |
| P5 | =IF(C5=0,0,M5/L5) | 0 | |
| Q5 | =IF(C5=0,0,D5/C5) | 0 | |
| B6 | =IF(Player3!$B$1="","",Player3!$B$1) | Jay | |
| C6 | =COUNT(Player3!$A$3:$A$72) | 2 | |
| D6 | =COUNT(Player3!$AE$3:$AE$67) | 2 | |
| E6 | =C6-D6 | 0 | |
| F6 | =SUM(Player3!$AN$3:$AN$67) | 0 | |
| G6 | =SUM(Player3!$AO$3:$AO$67) | 0 | |
| H6 | =SUM(Player3!$AP$3:$AP$67) | 0 | |
| I6 | =SUM(Player3!$AQ$3:$AQ$67) | 0 | |
| J6 | =SUM(F6:I6) | 0 | |
| K6 | =MAX(Player3!$AE$3:$AE$67) | 16 | |
| L6 | =SUM(Player3!$AK$3:$AK$67) | 86 | |
| M6 | =SUM(Player3!$AL$3:$AL$67) | 1002 | |
| N6 | =IF(C6=0,0,MAX(Player3!$AM$3:$AM$67))*3 | 38.53846154 | |
| O6 | =IF(C6=0,0,MAX(Player3!$AM$3:$AM$72)) | 12.84615385 | |
| P6 | =IF(C6=0,0,M6/L6) | 11.65116279 | |
| Q6 | =IF(C6=0,0,D6/C6) | 1 | |
| B7 | =IF(Player4!$B$1="","",Player4!$B$1) | Les | |
| C7 | =COUNT(Player4!$A$3:$A$71) | 1 | |
| D7 | =COUNT(Player4!$AE$3:$AE$67) | 1 | |
| E7 | =C7-D7 | 0 | |
| F7 | =SUM(Player4!$AN$3:$AN$67) | 0 | |
| G7 | =SUM(Player4!$AO$3:$AO$67) | 1 | |
| H7 | =SUM(Player4!$AP$3:$AP$67) | 0 | |
| I7 | =SUM(Player4!$AQ$3:$AQ$67) | 0 | |
| J7 | =SUM(F7:I7) | 1 | |
| K7 | =MAX(Player4!$AE$3:$AE$67) | 4 | |
| L7 | =SUM(Player4!$AK$3:$AK$67) | 37 | |
| M7 | =SUM(Player4!$AL$3:$AL$67) | 501 | |
| N7 | =IF(C7=0,0,MAX(Player4!$AM$3:$AM$65))*3 | 40.62162162 | |
| O7 | =IF(C7=0,0,MAX(Player4!$AM$3:$AM$67)) | 13.54054054 | |
| P7 | =IF(C7=0,0,M7/L7) | 13.54054054 | |
| Q7 | =IF(C7=0,0,D7/C7) | 1 | |
| B8 | =IF(Player5!$B$1="","",Player5!$B$1) | Mike | |
| C8 | =COUNT(Player5!$A$3:$A$70) | 0 | |
| D8 | =COUNT(Player5!$AE$3:$AE$64) | 0 | |
| E8 | =C8-D8 | 0 | |
| F8 | =SUM(Player5!$AN$3:$AN$64) | 0 | |
| G8 | =SUM(Player5!$AO$3:$AO$64) | 0 | |
| H8 | =SUM(Player5!$AP$3:$AP$64) | 0 | |
| I8 | =SUM(Player5!$AQ$3:$AQ$64) | 0 | |
| J8 | =SUM(F8:I8) | 0 | |
| K8 | =MAX(Player5!$AE$3:$AE$64) | 0 | |
| L8 | =SUM(Player5!$AK$3:$AK$64) | 0 | |
| M8 | =SUM(Player5!$AL$3:$AL$64) | 0 | |
| N8 | =IF(C8=0,0,MAX(Player5!$AM$3:$AM$64))*3 | 0 | |
| O8 | =IF(C8=0,0,MAX(Player5!$AM$3:$AM$64)) | 0 | |
| P8 | =IF(C8=0,0,M8/L8) | 0 | |
| Q8 | =IF(C8=0,0,D8/C8) | 0 | |
| B9 | =IF(Player6!$B$1="","",Player6!$B$1) | Pete | |
| C9 | =COUNT(Player6!$A$3:$A$67) | 2 | |
| D9 | =COUNT(Player6!$AE$3:$AE$60) | 0 | |
| E9 | =C9-D9 | 2 | |
| F9 | =SUM(Player6!$AN$3:$AN$60) | 1 | |
| G9 | =SUM(Player6!$AO$3:$AO$60) | 0 | |
| H9 | =SUM(Player6!$AP$3:$AP$60) | 0 | |
| I9 | =SUM(Player6!$AQ$3:$AQ$60) | 0 | |
| J9 | =SUM(F9:I9) | 1 | |
| K9 | =MAX(Player6!$AE$3:$AE$60) | 0 | |
| L9 | =SUM(Player6!$AK$3:$AK$60) | 69 | |
| M9 | =SUM(Player6!$AL$3:$AL$60) | 883 | |
| N9 | =IF(C9=0,0,MAX(Player6!$AM$3:$AM$60))*3 | 43.54545455 | |
| O9 | =IF(C9=0,0,MAX(Player6!$AM$3:$AM$60)) | 14.51515152 | |
| P9 | =IF(C9=0,0,M9/L9) | 12.79710145 | |
| Q9 | =IF(C9=0,0,D9/C9) | 0 | |
| B10 | =IF(Player7!$B$1="","",Player7!$B$1) | Rob | |
| C10 | =COUNT(Player7!$A$3:$A$67) | 1 | |
| D10 | =COUNT(Player7!$AE$3:$AE$60) | 0 | |
| E10 | =C10-D10 | 1 | |
| F10 | =SUM(Player7!$AN$3:$AN$60) | 0 | |
| G10 | =SUM(Player7!$AO$3:$AO$60) | 0 | |
| H10 | =SUM(Player7!$AP$3:$AP$60) | 0 | |
| I10 | =SUM(Player7!$AQ$3:$AQ$60) | 0 | |
| J10 | =SUM(F10:I10) | 0 | |
| K10 | =MAX(Player7!$AE$3:$AE$60) | 0 | |
| L10 | =SUM(Player7!$AK$3:$AK$60) | 39 | |
| M10 | =SUM(Player7!$AL$3:$AL$60) | 465 | |
| N10 | =IF(C10=0,0,MAX(Player7!$AM$3:$AM$60))*3 | 35.76923077 | |
| O10 | =IF(C10=0,0,MAX(Player7!$AM$3:$AM$60)) | 11.92307692 | |
| P10 | =IF(C10=0,0,M10/L10) | 11.92307692 | |
| Q10 | =IF(C10=0,0,D10/C10) | 0 | |
| B11 | =IF(Player8!$B$1="","",Player8!$B$1) | Steve | |
| C11 | =COUNT(Player8!$A$3:$A$67) | 1 | |
| D11 | =COUNT(Player8!$AE$3:$AE$60) | 0 | |
| E11 | =C11-D11 | 1 | |
| F11 | =SUM(Player8!$AN$3:$AN$60) | 0 | |
| G11 | =SUM(Player8!$AO$3:$AO$60) | 0 | |
| H11 | =SUM(Player8!$AP$3:$AP$60) | 0 | |
| I11 | =SUM(Player8!$AQ$3:$AQ$60) | 0 | |
| J11 | =SUM(F11:I11) | 0 | |
| K11 | =MAX(Player8!$AE$3:$AE$60) | 0 | |
| L11 | =SUM(Player8!$AK$3:$AK$60) | 24 | |
| M11 | =SUM(Player8!$AL$3:$AL$60) | 261 | |
| N11 | =IF(C11=0,0,MAX(Player8!$AM$3:$AM$60))*3 | 32.625 | |
| O11 | =IF(C11=0,0,MAX(Player8!$AM$3:$AM$60)) | 10.875 | |
| P11 | =IF(C11=0,0,M11/L11) | 10.875 | |
| Q11 | =IF(C11=0,0,D11/C11) | 0 | |
| B12 | =IF(Player9!$B$1="","",Player9!$B$1) | Sue | |
| C12 | =COUNT(Player9!$A$3:$A$70) | 0 | |
| D12 | =COUNT(Player9!$AE$3:$AE$67) | 0 | |
| E12 | =C12-D12 | 0 | |
| F12 | =SUM(Player9!$AN$3:$AN$67) | 0 | |
| G12 | =SUM(Player9!$AO$3:$AO$67) | 0 | |
| H12 | =SUM(Player9!$AP$3:$AP$67) | 0 | |
| I12 | =SUM(Player9!$AQ$3:$AQ$67) | 0 | |
| J12 | =SUM(F12:I12) | 0 | |
| K12 | =MAX(Player9!$AE$3:$AE$67) | 0 | |
| L12 | =SUM(Player9!$AK$3:$AK$67) | 0 | |
| M12 | =SUM(Player9!$AL$3:$AL$67) | 0 | |
| N12 | =IF(C12=0,0,MAX(Player9!$AM$3:$AM$64))*3 | 0 | |
| O12 | =IF(C12=0,0,MAX(Player9!$AM$3:$AM$67)) | 0 | |
| P12 | =IF(C12=0,0,M12/L12) | 0 | |
| Q12 | =IF(C12=0,0,D12/C12) | 0 | |
| B13 | =IF(Player10!$B$1="","",Player10!$B$1) | Wiz | |
| C13 | =COUNT(Player10!$A$3:$A$70) | 2 | |
| D13 | =COUNT(Player10!$AE$3:$AE$67) | 1 | |
| E13 | =C13-D13 | 1 | |
| F13 | =SUM(Player10!$AN$3:$AN$67) | 1 | |
| G13 | =SUM(Player10!$AO$3:$AO$67) | 0 | |
| H13 | =SUM(Player10!$AP$3:$AP$67) | 0 | |
| I13 | =SUM(Player10!$AQ$3:$AQ$67) | 0 | |
| J13 | =SUM(F13:I13) | 1 | |
| K13 | =MAX(Player10!$AE$3:$AE$67) | 36 | |
| L13 | =SUM(Player10!$AK$3:$AK$67) | 71 | |
| M13 | =SUM(Player10!$AL$3:$AL$67) | 903 | |
| N13 | =IF(C13=0,0,MAX(Player10!$AM$3:$AM$64))*3 | 39.55263158 | |
| O13 | =IF(C13=0,0,MAX(Player10!$AM$3:$AM$67)) | 13.18421053 | |
| P13 | =IF(C13=0,0,M13/L13) | 12.71830986 | |
| Q13 | =IF(C13=0,0,D13/C13) | 0.5 | |
| C16 | =SUM(C3:C13) | 12 | |
| D16 | =SUM(D3:D14) | 4 | |
| E16 | =SUM(E3:E13) | 8 | |
| F16 | =SUM(F3:F13) | 2 | |
| G16 | =SUM(G3:G13) | 1 | |
| H16 | =SUM(H3:H13) | 0 | |
| I16 | =SUM(I3:I13) | 0 | |
| J16 | =SUM(J3:J13) | 3 | |
| K16 | =MAX(K3:K13) | 36 | |
| L16 | =SUM(L3:L13) | 437 | |
| M16 | =SUM(M3:M13) | 5307 | |
| N16 | =AVERAGE(N3:N13) | 28.02067273 | |
| O16 | =MAX(O3:O13) | 17.95833333 | |
| P16 | =IF(C16=0,0,M16/L16) | 12.14416476 | |
| Q16 | =IF(C16=0,0,D16/C16) | 0.333333333 | |
| C26 | =MAX(IF(Player0!$AL$3:$AL$70=501,Player0!$AK$3:$AK$70)) | 0 | |
| D26 | =IF(C26=0,0,INDEX(Player0!$AE$3:$AE$64,MATCH(C26&501,Player0!$AK$3:$AK$64&Player0!$AL$3:$AL$64,0))) | 0 | |
| E26 | =MAX(Player0!$AK$3:$AK$64) | 60 | |
| C27 | =MAX(IF(Player1!$AL$3:$AL$70=501,Player1!$AK$3:$AK$70)) | 0 | |
| D27 | =IF(C27=0,0,INDEX(Player1!$AE$3:$AE$64,MATCH(C27&501,Player1!$AK$3:$AK$64&Player1!$AL$3:$AL$64,0))) | 0 | |
| E27 | =MAX(Player1!$AK$3:$AK$64) | 27 | |
| C28 | =MAX(IF(Player2!$AL$3:$AL$72=501,Player2!$AK$3:$AK$72)) | 0 | |
| D28 | =IF(C28=0,0,INDEX(Player2!$AE$3:$AE$67,MATCH(C28&501,Player2!$AK$3:$AK$67&Player2!$AL$3:$AL$67,0))) | 0 | |
| E28 | =MAX(Player2!$AK$3:$AK$67) | 0 | |
| C29 | =MAX(IF(Player3!$AL$3:$AL$72=501,Player3!$AK$3:$AK$72)) | 47 | |
| D29 | =IF(C29=0,0,INDEX(Player3!$AE$3:$AE$67,MATCH(C29&501,Player3!$AK$3:$AK$67&Player3!$AL$3:$AL$67,0))) | 14 | |
| E29 | =MAX(Player3!$AK$3:$AK$67) | 47 | |
| C30 | =MAX(IF(Player4!$AL$3:$AL$71=501,Player4!$AK$3:$AK$71)) | 37 | |
| D30 | =IF(C30=0,0,INDEX(Player4!$AE$3:$AE$65,MATCH(C30&501,Player4!$AK$3:$AK$65&Player4!$AL$3:$AL$65,0))) | 4 | |
| E30 | =MAX(Player4!$AK$3:$AK$65) | 37 | |
| C31 | =MAX(IF(Player5!$AL$3:$AL$70=501,Player5!$AK$3:$AK$70)) | 0 | |
| D31 | =IF(C31=0,0,INDEX(Player5!$AE$3:$AE$64,MATCH(C31&501,Player5!$AK$3:$AK$64&Player5!$AL$3:$AL$64,0))) | 0 | |
| E31 | =MAX(Player5!$AK$3:$AK$64) | 0 | |
| C32 | =MAX(IF(Player6!$AL$3:$AL$67=501,Player6!$AK$3:$AK$67)) | 0 | |
| D32 | =IF(C32=0,0,INDEX(Player6!$AE$3:$AE$60,MATCH(C32&501,Player6!$AK$3:$AK$60&Player6!$AL$3:$AL$60,0))) | 0 | |
| E32 | =MAX(Player6!$AK$3:$AK$60) | 36 | |
| C33 | =MAX(IF(Player7!$AL$3:$AL$67=501,Player7!$AK$3:$AK$67)) | 0 | |
| D33 | =IF(C33=0,0,INDEX(Player7!$AE$3:$AE$60,MATCH(C33&501,Player7!$AK$3:$AK$60&Player7!$AL$3:$AL$60,0))) | 0 | |
| E33 | =MAX(Player7!$AK$3:$AK$60) | 39 | |
| C34 | =MAX(IF(Player8!$AL$3:$AL$67=501,Player8!$AK$3:$AK$67)) | 0 | |
| D34 | =IF(C34=0,0,INDEX(Player8!$AE$3:$AE$60,MATCH(C34&501,Player8!$AK$3:$AK$60&Player8!$AL$3:$AL$60,0))) | 0 | |
| E34 | =MAX(Player8!$AK$3:$AK$60) | 24 | |
| C35 | =MAX(IF(Player9!$AL$3:$AL$70=501,Player9!$AK$3:$AK$70)) | 0 | |
| D35 | =IF(C35=0,0,INDEX(Player9!$AE$3:$AE$64,MATCH(C35&501,Player9!$AK$3:$AK$64&Player9!$AL$3:$AL$64,0))) | 0 | |
| E35 | =MAX(Player9!$AK$3:$AK$64) | 0 | |
| C36 | =MAX(IF(Player10!$AL$3:$AL$70=501,Player10!$AK$3:$AK$70)) | 38 | |
| D36 | =IF(C36=0,0,INDEX(Player10!$AE$3:$AE$64,MATCH(C36&501,Player10!$AK$3:$AK$64&Player10!$AL$3:$AL$64,0))) | 36 | |
| E36 | =MAX(Player10!$AK$3:$AK$64) | 38 | |
| C37 | =MAX(C26:C36) | 47 | |
| D37 | =VLOOKUP(MAX(C26:C36),C26:D36, 2, FALSE) | 14 | |
| E37 | =MAX(E26:E36) | 60 | |
| L26 | =MIN(IF(Player0!$AL$3:$AL$70=501,Player0!$AK$3:$AK$70)) | 0 | |
| M26 | =IF(L26=0,0,INDEX(Player0!$AE$3:$AE$65,MATCH(L26&501,Player0!$AK$3:$AK$64&Player0!$AL$3:$AL$64,0))) | 0 | |
| N26 | =IF(ISERROR(M26),"-",(IF(M26=0,"-",L26))) | - | |
| O26 | =IF(ISERROR(M26),"-",(IF(M26=0,"-",IF(N26=$N$37,K26,"-")))) | - | |
| L27 | =MIN(IF(Player1!$AL$3:$AL$70=501,Player1!$AK$3:$AK$70)) | 0 | |
| M27 | =IF(L27=0,0,INDEX(Player1!$AE$3:$AE$65,MATCH(L27&501,Player1!$AK$3:$AK$64&Player1!$AL$3:$AL$64,0))) | 0 | |
| N27 | =IF(ISERROR(M27),"-",(IF(M27=0,"-",L27))) | - | |
| O27 | =IF(ISERROR(M27),"-",(IF(M27=0,"-",IF(N27=$N$37,K27,"-")))) | - | |
| L28 | =MIN(IF(Player2!$AL$3:$AL$72=501,Player2!$AK$3:$AK$72)) | 0 | |
| M28 | =IF(L28=0,0,INDEX(Player2!$AE$3:$AE$68,MATCH(L28&501,Player2!$AK$3:$AK$67&Player2!$AL$3:$AL$67,0))) | 0 | |
| N28 | =IF(ISERROR(M28),"-",(IF(M28=0,"-",L28))) | - | |
| O28 | =IF(ISERROR(M28),"-",(IF(M28=0,"-",IF(N28=$N$37,K28,"-")))) | - | |
| L29 | =MIN(IF(Player3!$AL$3:$AL$72=501,Player3!$AK$3:$AK$72)) | 39 | |
| M29 | =IF(L29=0,0,INDEX(Player3!$AE$3:$AE$68,MATCH(L29&501,Player3!$AK$3:$AK$67&Player3!$AL$3:$AL$67,0))) | 16 | |
| N29 | =IF(ISERROR(M29),"-",(IF(M29=0,"-",L29))) | 39 | |
| O29 | =IF(ISERROR(M29),"-",(IF(M29=0,"-",IF(N29=$N$37,K29,"-")))) | - | |
| L30 | =MIN(IF(Player4!$AL$3:$AL$71=501,Player4!$AK$3:$AK$71)) | 37 | |
| M30 | =IF(L30=0,0,INDEX(Player4!$AE$3:$AE$67,MATCH(L30&501,Player4!$AK$3:$AK$65&Player4!$AL$3:$AL$65,0))) | 4 | |
| N30 | =IF(ISERROR(M30),"-",(IF(M30=0,"-",L30))) | 37 | |
| O30 | =IF(ISERROR(M30),"-",(IF(M30=0,"-",IF(N30=$N$37,K30,"-")))) | Les | |
| L31 | =MIN(IF(Player5!$AL$3:$AL$70=501,Player5!$AK$3:$AK$70)) | 0 | |
| M31 | =IF(L31=0,0,INDEX(Player5!$AE$3:$AE$65,MATCH(L31&501,Player5!$AK$3:$AK$64&Player5!$AL$3:$AL$64,0))) | 0 | |
| N31 | =IF(ISERROR(M31),"-",(IF(M31=0,"-",L31))) | - | |
| O31 | =IF(ISERROR(M31),"-",(IF(M31=0,"-",IF(N31=$N$37,K31,"-")))) | - | |
| L32 | =MIN(IF(Player6!$AL$3:$AL$67=501,Player6!$AK$3:$AK$67)) | 0 | |
| M32 | =IF(L32=0,0,INDEX(Player6!$AE$3:$AE$61,MATCH(L32&501,Player6!$AK$3:$AK$60&Player6!$AL$3:$AL$60,0))) | 0 | |
| N32 | =IF(ISERROR(M32),"-",(IF(M32=0,"-",L32))) | - | |
| O32 | =IF(ISERROR(M32),"-",(IF(M32=0,"-",IF(N32=$N$37,K32,"-")))) | - | |
| L33 | =MIN(IF(Player7!$AL$3:$AL$67=501,Player7!$AK$3:$AK$67)) | 0 | |
| M33 | =IF(L33=0,0,INDEX(Player7!$AE$3:$AE$61,MATCH(L33&501,Player7!$AK$3:$AK$60&Player7!$AL$3:$AL$60,0))) | 0 | |
| N33 | =IF(ISERROR(M33),"-",(IF(M33=0,"-",L33))) | - | |
| O33 | =IF(ISERROR(M33),"-",(IF(M33=0,"-",IF(N33=$N$37,K33,"-")))) | - | |
| L34 | =MIN(IF(Player8!$AL$3:$AL$67=501,Player8!$AK$3:$AK$67)) | 0 | |
| M34 | =IF(L34=0,0,INDEX(Player8!$AE$3:$AE$61,MATCH(L34&501,Player8!$AK$3:$AK$60&Player8!$AL$3:$AL$60,0))) | 0 | |
| N34 | =IF(ISERROR(M34),"-",(IF(M34=0,"-",L34))) | - | |
| O34 | =IF(ISERROR(M34),"-",(IF(M34=0,"-",IF(N34=$N$37,K34,"-")))) | - | |
| L35 | =MIN(IF(Player9!$AL$3:$AL$70=501,Player9!$AK$3:$AK$70)) | 0 | |
| M35 | =IF(L35=0,0,INDEX(Player9!$AE$3:$AE$65,MATCH(L35&501,Player9!$AK$3:$AK$64&Player9!$AL$3:$AL$64,0))) | 0 | |
| N35 | =IF(ISERROR(M35),"-",(IF(M35=0,"-",L35))) | - | |
| O35 | =IF(ISERROR(M35),"-",(IF(M35=0,"-",IF(N35=$N$37,K35,"-")))) | - | |
| L36 | =MIN(IF(Player10!$AL$3:$AL$70=501,Player10!$AK$3:$AK$70)) | 38 | |
| M36 | =IF(L36=0,0,INDEX(Player10!$AE$3:$AE$65,MATCH(L36&501,Player10!$AK$3:$AK$64&Player10!$AL$3:$AL$64,0))) | 36 | |
| N36 | =IF(ISERROR(M36),"-",(IF(M36=0,"-",L36))) | 38 | |
| O36 | =IF(ISERROR(M36),"-",(IF(M36=0,"-",IF(N36=$N$37,K36,"-")))) | - | |
| L37 | =MIN(IF(L26:L36<>0,L26:L36)) | 37 | |
| M37 | =VLOOKUP(MAX(L37:L37),L26:M36,2,FALSE) | 4 | |
| N37 | =MIN(IF(N26:N36<>0,N26:N36)) | 37 | |
| O37 | =VLOOKUP(M37,M26:O36,3,FALSE) | Les | |
| B26 | =IF(Player0!$B$1="","",Player0!$B$1) | Caz | |
| B27 | =IF(Player1!$B$1="","",Player1!$B$1) | David | |
| B28 | =IF(Player2!$B$1="","",Player2!$B$1) | Diane | |
| B29 | =IF(Player3!$B$1="","",Player3!$B$1) | Jay | |
| B30 | =IF(Player4!$B$1="","",Player4!$B$1) | Les | |
| B31 | =IF(Player5!$B$1="","",Player5!$B$1) | Mike | |
| B32 | =IF(Player6!$B$1="","",Player6!$B$1) | Pete | |
| B33 | =IF(Player7!$B$1="","",Player7!$B$1) | Rob | |
| B34 | =IF(Player8!$B$1="","",Player8!$B$1) | Steve | |
| B35 | =IF(Player9!$B$1="","",Player9!$B$1) | Sue | |
| B36 | =IF(Player10!$B$1="","",Player10!$B$1) | Wiz | |
| K26 | =IF(Player0!$B$1="","",Player0!$B$1) | Caz | |
| K27 | =IF(Player1!$B$1="","",Player1!$B$1) | David | |
| K28 | =IF(Player2!$B$1="","",Player2!$B$1) | Diane | |
| K29 | =IF(Player3!$B$1="","",Player3!$B$1) | Jay | |
| K30 | =IF(Player4!$B$1="","",Player4!$B$1) | Les | |
| K31 | =IF(Player5!$B$1="","",Player5!$B$1) | Mike | |
| K32 | =IF(Player6!$B$1="","",Player6!$B$1) | Pete | |
| K33 | =IF(Player7!$B$1="","",Player7!$B$1) | Rob | |
| K34 | =IF(Player8!$B$1="","",Player8!$B$1) | Steve | |
| K35 | =IF(Player9!$B$1="","",Player9!$B$1) | Sue | |
| K36 | =IF(Player10!$B$1="","",Player10!$B$1) | Wiz | |
| C41 | =SUM(Player0!$AF$66) | 2 | |
| D41 | =SUM(Player0!$AF$67) | 3 | |
| E41 | =SUM(D3) | 0 | |
| C42 | =SUM(Player1!$AF$66) | 2 | |
| D42 | =SUM(Player1!$AF$67) | 0 | |
| E42 | =SUM(D4) | 0 | |
| C43 | =SUM(Player2!$AF$66) | 0 | |
| D43 | =SUM(Player2!$AF$67) | 0 | |
| E43 | =SUM(D5) | 0 | |
| C44 | =SUM(Player3!$AF$66) | 1 | |
| D44 | =SUM(Player3!$AF$67) | 5 | |
| E44 | =SUM(D6) | 2 | |
| C45 | =SUM(Player4!$AF$66) | 1 | |
| D45 | =SUM(Player4!$AF$67) | 4 | |
| E45 | =SUM(D7) | 1 | |
| C46 | =SUM(Player5!$AF$66) | 0 | |
| D46 | =SUM(Player5!$AF$67) | 0 | |
| E46 | =SUM(D8) | 0 | |
| C47 | =SUM(Player6!$AF$66) | 2 | |
| D47 | =SUM(Player6!$AF$67) | 0 | |
| E47 | =SUM(D9) | 0 | |
| C48 | =SUM(Player7!$AF$66) | 0 | |
| D48 | =SUM(Player7!$AF$67) | 0 | |
| E48 | =SUM(D10) | 0 | |
| C49 | =SUM(Player8!$AF$66) | 0 | |
| D49 | =SUM(Player8!$AF$67) | 0 | |
| E49 | =SUM(D11) | 0 | |
| C50 | =SUM(Player9!$AF$66) | 0 | |
| D50 | =SUM(Player9!$AF$67) | 0 | |
| E50 | =SUM(D12) | 0 | |
| C51 | =SUM(Player10!$AF$66) | 2 | |
| D51 | =SUM(Player10!$AF$67) | 0 | |
| E51 | =SUM(D13) | 1 | |
| C52 | =SUM(C41:C51) | 10 | |
| D52 | =SUM(D41:D51) | 12 | |
| E52 | =SUM(E41:E51) | 4 |