Address |
Formula |
Value |
C3 |
=COUNT(Player0!$A$3:$A$30) |
0 |
D3 |
=COUNT(Player0!$AE$3:$AE$30) |
0 |
E3 |
=C3-D3 |
0 |
F3 |
=SUM(Player0!$AP$3:$AP$30) |
0 |
G3 |
=SUM(Player0!$AQ$3:$AQ$30) |
0 |
H3 |
=SUM(Player0!$AR$3:$AR$30) |
0 |
I3 |
=SUM(Player0!$AS$3:$AS$30) |
0 |
J3 |
=SUM(F3:I3) |
0 |
K3 |
=MAX(Player0!$AE$3:$AE$30) |
0 |
L3 |
=SUM(Player0!$AM$3:$AM$30) |
0 |
M3 |
=SUM(Player0!$AN$3:$AN$30) |
0 |
N3 |
=IF(C3=0,0,MAX(Player0!$AO$3:$AO$30))*3 |
0 |
O3 |
=IF(C3=0,0,MAX(Player0!$AO$3:$AO$30)) |
0 |
P3 |
=IF(C3=0,0,M3/L3) |
0 |
Q3 |
=IF(C3=0,0,D3/C3) |
0 |
C4 |
=COUNT(Player1!$A$3:$A$30) |
1 |
D4 |
=COUNT(Player1!$AE$3:$AE$30) |
1 |
E4 |
=C4-D4 |
0 |
F4 |
=SUM(Player1!$AP$3:$AP$30) |
0 |
G4 |
=SUM(Player1!$AQ$3:$AQ$30) |
0 |
H4 |
=SUM(Player1!$AR$3:$AR$30) |
0 |
I4 |
=SUM(Player1!$AS$3:$AS$30) |
0 |
J4 |
=SUM(F4:I4) |
0 |
K4 |
=MAX(Player1!$AE$3:$AE$30) |
12 |
L4 |
=SUM(Player1!$AM$3:$AM$30) |
43 |
M4 |
=SUM(Player1!$AN$3:$AN$30) |
601 |
N4 |
=IF(C4=0,0,MAX(Player1!$AO$3:$AO$30))*3 |
41.93023256 |
O4 |
=IF(C4=0,0,MAX(Player1!$AO$3:$AO$30)) |
13.97674419 |
P4 |
=IF(C4=0,0,M4/L4) |
13.97674419 |
Q4 |
=IF(C4=0,0,D4/C4) |
1 |
C5 |
=COUNT(Player2!$A$3:$A$30) |
0 |
D5 |
=COUNT(Player2!$AE$3:$AE$30) |
0 |
E5 |
=C5-D5 |
0 |
F5 |
=SUM(Player2!$AP$3:$AP$30) |
0 |
G5 |
=SUM(Player2!$AQ$3:$AQ$30) |
0 |
H5 |
=SUM(Player2!$AR$3:$AR$30) |
0 |
I5 |
=SUM(Player2!$AS$3:$AS$30) |
0 |
J5 |
=SUM(F5:I5) |
0 |
K5 |
=MAX(Player2!$AE$3:$AE$30) |
0 |
L5 |
=SUM(Player2!$AM$3:$AM$30) |
0 |
M5 |
=SUM(Player2!$AN$3:$AN$30) |
0 |
N5 |
=IF(C5=0,0,MAX(Player2!$AO$3:$AO$30))*3 |
0 |
O5 |
=IF(C5=0,0,MAX(Player2!$AO$3:$AO$30)) |
0 |
P5 |
=IF(C5=0,0,M5/L5) |
0 |
Q5 |
=IF(C5=0,0,D5/C5) |
0 |
C6 |
=COUNT(Player3!$A$3:$A$30) |
0 |
D6 |
=COUNT(Player3!$AE$3:$AE$30) |
0 |
E6 |
=C6-D6 |
0 |
F6 |
=SUM(Player3!$AP$3:$AP$30) |
0 |
G6 |
=SUM(Player3!$AQ$3:$AQ$30) |
0 |
H6 |
=SUM(Player3!$AR$3:$AR$30) |
0 |
I6 |
=SUM(Player3!$AS$3:$AS$30) |
0 |
J6 |
=SUM(F6:I6) |
0 |
K6 |
=MAX(Player3!$AE$3:$AE$30) |
0 |
L6 |
=SUM(Player3!$AM$3:$AM$30) |
0 |
M6 |
=SUM(Player3!$AN$3:$AN$30) |
0 |
N6 |
=IF(C6=0,0,MAX(Player3!$AO$3:$AO$30))*3 |
0 |
O6 |
=IF(C6=0,0,MAX(Player3!$AO$3:$AO$30)) |
0 |
P6 |
=IF(C6=0,0,M6/L6) |
0 |
Q6 |
=IF(C6=0,0,D6/C6) |
0 |
C7 |
=COUNT(Player4!$A$3:$A$30) |
0 |
D7 |
=COUNT(Player4!$AE$3:$AE$30) |
0 |
E7 |
=C7-D7 |
0 |
F7 |
=SUM(Player4!$AP$3:$AP$30) |
0 |
G7 |
=SUM(Player4!$AQ$3:$AQ$30) |
0 |
H7 |
=SUM(Player4!$AR$3:$AR$30) |
0 |
I7 |
=SUM(Player4!$AS$3:$AS$30) |
0 |
J7 |
=SUM(F7:I7) |
0 |
K7 |
=MAX(Player4!$AE$3:$AE$30) |
0 |
L7 |
=SUM(Player4!$AM$3:$AM$30) |
0 |
M7 |
=SUM(Player4!$AN$3:$AN$30) |
0 |
N7 |
=IF(C7=0,0,MAX(Player4!$AO$3:$AO$30))*3 |
0 |
O7 |
=IF(C7=0,0,MAX(Player4!$AO$3:$AO$30)) |
0 |
P7 |
=IF(C7=0,0,M7/L7) |
0 |
Q7 |
=IF(C7=0,0,D7/C7) |
0 |
C8 |
=COUNT(Player5!$A$3:$A$30) |
0 |
D8 |
=COUNT(Player5!$AE$3:$AE$30) |
0 |
E8 |
=C8-D8 |
0 |
F8 |
=SUM(Player5!$AP$3:$AP$30) |
0 |
G8 |
=SUM(Player5!$AQ$3:$AQ$30) |
0 |
H8 |
=SUM(Player5!$AR$3:$AR$30) |
0 |
I8 |
=SUM(Player5!$AS$3:$AS$30) |
0 |
J8 |
=SUM(F8:I8) |
0 |
K8 |
=MAX(Player5!$AE$3:$AE$30) |
0 |
L8 |
=SUM(Player5!$AM$3:$AM$30) |
0 |
M8 |
=SUM(Player5!$AN$3:$AN$30) |
0 |
N8 |
=IF(C8=0,0,MAX(Player5!$AO$3:$AO$30))*3 |
0 |
O8 |
=IF(C8=0,0,MAX(Player5!$AO$3:$AO$30)) |
0 |
P8 |
=IF(C8=0,0,M8/L8) |
0 |
Q8 |
=IF(C8=0,0,D8/C8) |
0 |
C9 |
=COUNT(Player6!$A$3:$A$30) |
0 |
D9 |
=COUNT(Player6!$AE$3:$AE$30) |
0 |
E9 |
=C9-D9 |
0 |
F9 |
=SUM(Player6!$AP$3:$AP$30) |
0 |
G9 |
=SUM(Player6!$AQ$3:$AQ$30) |
0 |
H9 |
=SUM(Player6!$AR$3:$AR$30) |
0 |
I9 |
=SUM(Player6!$AS$3:$AS$30) |
0 |
J9 |
=SUM(F9:I9) |
0 |
K9 |
=MAX(Player6!$AE$3:$AE$30) |
0 |
L9 |
=SUM(Player6!$AM$3:$AM$30) |
0 |
M9 |
=SUM(Player6!$AN$3:$AN$30) |
0 |
N9 |
=IF(C9=0,0,MAX(Player6!$AO$3:$AO$30))*3 |
0 |
O9 |
=IF(C9=0,0,MAX(Player6!$AO$3:$AO$30)) |
0 |
P9 |
=IF(C9=0,0,M9/L9) |
0 |
Q9 |
=IF(C9=0,0,D9/C9) |
0 |
C10 |
=COUNT(Player7!$A$3:$A$30) |
0 |
D10 |
=COUNT(Player7!$AE$3:$AE$30) |
0 |
E10 |
=C10-D10 |
0 |
F10 |
=SUM(Player7!$AP$3:$AP$30) |
0 |
G10 |
=SUM(Player7!$AQ$3:$AQ$30) |
0 |
H10 |
=SUM(Player7!$AR$3:$AR$30) |
0 |
I10 |
=SUM(Player7!$AS$3:$AS$30) |
0 |
J10 |
=SUM(F10:I10) |
0 |
K10 |
=MAX(Player7!$AE$3:$AE$30) |
0 |
L10 |
=SUM(Player7!$AM$3:$AM$30) |
0 |
M10 |
=SUM(Player7!$AN$3:$AN$30) |
0 |
N10 |
=IF(C10=0,0,MAX(Player7!$AO$3:$AO$30))*3 |
0 |
O10 |
=IF(C10=0,0,MAX(Player7!$AO$3:$AO$30)) |
0 |
P10 |
=IF(C10=0,0,M10/L10) |
0 |
Q10 |
=IF(C10=0,0,D10/C10) |
0 |
C11 |
=COUNT(Player8!$A$3:$A$30) |
0 |
D11 |
=COUNT(Player8!$AE$3:$AE$30) |
0 |
E11 |
=C11-D11 |
0 |
F11 |
=SUM(Player8!$AP$3:$AP$30) |
0 |
G11 |
=SUM(Player8!$AQ$3:$AQ$30) |
0 |
H11 |
=SUM(Player8!$AR$3:$AR$30) |
0 |
I11 |
=SUM(Player8!$AS$3:$AS$30) |
0 |
J11 |
=SUM(F11:I11) |
0 |
K11 |
=MAX(Player8!$AE$3:$AE$30) |
0 |
L11 |
=SUM(Player8!$AM$3:$AM$30) |
0 |
M11 |
=SUM(Player8!$AN$3:$AN$30) |
0 |
N11 |
=IF(C11=0,0,MAX(Player8!$AO$3:$AO$30))*3 |
0 |
O11 |
=IF(C11=0,0,MAX(Player8!$AO$3:$AO$30)) |
0 |
P11 |
=IF(C11=0,0,M11/L11) |
0 |
Q11 |
=IF(C11=0,0,D11/C11) |
0 |
C12 |
=COUNT(Player9!$A$3:$A$30) |
0 |
D12 |
=COUNT(Player9!$AE$3:$AE$30) |
0 |
E12 |
=C12-D12 |
0 |
F12 |
=SUM(Player9!$AP$3:$AP$30) |
0 |
G12 |
=SUM(Player9!$AQ$3:$AQ$30) |
0 |
H12 |
=SUM(Player9!$AR$3:$AR$30) |
0 |
I12 |
=SUM(Player9!$AS$3:$AS$30) |
0 |
J12 |
=SUM(F12:I12) |
0 |
K12 |
=MAX(Player9!$AE$3:$AE$30) |
0 |
L12 |
=SUM(Player9!$AM$3:$AM$30) |
0 |
M12 |
=SUM(Player9!$AN$3:$AN$30) |
0 |
N12 |
=IF(C12=0,0,MAX(Player9!$AO$3:$AO$30))*3 |
0 |
O12 |
=IF(C12=0,0,MAX(Player9!$AO$3:$AO$30)) |
0 |
P12 |
=IF(C12=0,0,M12/L12) |
0 |
Q12 |
=IF(C12=0,0,D12/C12) |
0 |
C13 |
=COUNT(Player10!$A$3:$A$30) |
0 |
D13 |
=COUNT(Player10!$AE$3:$AE$30) |
0 |
E13 |
=C13-D13 |
0 |
F13 |
=SUM(Player10!$AP$3:$AP$30) |
0 |
G13 |
=SUM(Player10!$AQ$3:$AQ$30) |
0 |
H13 |
=SUM(Player10!$AR$3:$AR$30) |
0 |
I13 |
=SUM(Player10!$AS$3:$AS$30) |
0 |
J13 |
=SUM(F13:I13) |
0 |
K13 |
=MAX(Player10!$AE$3:$AE$30) |
0 |
L13 |
=SUM(Player10!$AM$3:$AM$30) |
0 |
M13 |
=SUM(Player10!$AN$3:$AN$30) |
0 |
N13 |
=IF(C13=0,0,MAX(Player10!$AO$3:$AO$30))*3 |
0 |
O13 |
=IF(C13=0,0,MAX(Player10!$AO$3:$AO$30)) |
0 |
P13 |
=IF(C13=0,0,M13/L13) |
0 |
Q13 |
=IF(C13=0,0,D13/C13) |
0 |
C14 |
=COUNT(Player11!$A$3:$A$30) |
0 |
D14 |
=COUNT(Player11!$AE$3:$AE$30) |
0 |
E14 |
=C14-D14 |
0 |
F14 |
=SUM(Player11!$AP$3:$AP$30) |
0 |
G14 |
=SUM(Player11!$AQ$3:$AQ$30) |
0 |
H14 |
=SUM(Player11!$AR$3:$AR$30) |
0 |
I14 |
=SUM(Player11!$AS$3:$AS$30) |
0 |
J14 |
=SUM(F14:I14) |
0 |
K14 |
=MAX(Player11!$AE$3:$AE$30) |
0 |
L14 |
=SUM(Player11!$AM$3:$AM$30) |
0 |
M14 |
=SUM(Player11!$AN$3:$AN$30) |
0 |
N14 |
=IF(C14=0,0,MAX(Player11!$AO$3:$AO$30))*3 |
0 |
O14 |
=IF(C14=0,0,MAX(Player11!$AO$3:$AO$30)) |
0 |
P14 |
=IF(C14=0,0,M14/L14) |
0 |
Q14 |
=IF(C14=0,0,D14/C14) |
0 |
C15 |
=COUNT(Player12!$A$3:$A$30) |
0 |
D15 |
=COUNT(Player12!$AE$3:$AE$30) |
0 |
E15 |
=C15-D15 |
0 |
F15 |
=SUM(Player12!$AP$3:$AP$30) |
0 |
G15 |
=SUM(Player12!$AQ$3:$AQ$30) |
0 |
H15 |
=SUM(Player12!$AR$3:$AR$30) |
0 |
I15 |
=SUM(Player12!$AS$3:$AS$30) |
0 |
J15 |
=SUM(F15:I15) |
0 |
K15 |
=MAX(Player12!$AE$3:$AE$30) |
0 |
L15 |
=SUM(Player12!$AM$3:$AM$30) |
0 |
M15 |
=SUM(Player12!$AN$3:$AN$30) |
0 |
N15 |
=IF(C15=0,0,MAX(Player12!$AO$3:$AO$30))*3 |
0 |
O15 |
=IF(C15=0,0,MAX(Player12!$AO$3:$AO$30)) |
0 |
P15 |
=IF(C15=0,0,M15/L15) |
0 |
Q15 |
=IF(C15=0,0,D15/C15) |
0 |
C16 |
=COUNT(Player13!$A$3:$A$30) |
0 |
D16 |
=COUNT(Player13!$AE$3:$AE$30) |
0 |
E16 |
=C16-D16 |
0 |
F16 |
=SUM(Player13!$AP$3:$AP$30) |
0 |
G16 |
=SUM(Player13!$AQ$3:$AQ$30) |
0 |
H16 |
=SUM(Player13!$AR$3:$AR$30) |
0 |
I16 |
=SUM(Player13!$AS$3:$AS$30) |
0 |
J16 |
=SUM(F16:I16) |
0 |
K16 |
=MAX(Player13!$AE$3:$AE$30) |
0 |
L16 |
=SUM(Player13!$AM$3:$AM$30) |
0 |
M16 |
=SUM(Player13!$AN$3:$AN$30) |
0 |
N16 |
=IF(C16=0,0,MAX(Player13!$AO$3:$AO$30))*3 |
0 |
O16 |
=IF(C16=0,0,MAX(Player13!$AO$3:$AO$30)) |
0 |
P16 |
=IF(C16=0,0,M16/L16) |
0 |
Q16 |
=IF(C16=0,0,D16/C16) |
0 |
C17 |
=COUNT(Player14!$A$3:$A$30) |
0 |
D17 |
=COUNT(Player14!$AE$3:$AE$30) |
0 |
E17 |
=C17-D17 |
0 |
F17 |
=SUM(Player14!$AP$3:$AP$30) |
0 |
G17 |
=SUM(Player14!$AQ$3:$AQ$30) |
0 |
H17 |
=SUM(Player14!$AR$3:$AR$30) |
0 |
I17 |
=SUM(Player14!$AS$3:$AS$30) |
0 |
J17 |
=SUM(F17:I17) |
0 |
K17 |
=MAX(Player14!$AE$3:$AE$30) |
0 |
L17 |
=SUM(Player14!$AM$3:$AM$30) |
0 |
M17 |
=SUM(Player14!$AN$3:$AN$30) |
0 |
N17 |
=IF(C17=0,0,MAX(Player14!$AO$3:$AO$30))*3 |
0 |
O17 |
=IF(C17=0,0,MAX(Player14!$AO$3:$AO$30)) |
0 |
P17 |
=IF(C17=0,0,M17/L17) |
0 |
Q17 |
=IF(C17=0,0,D17/C17) |
0 |
C18 |
=COUNT(Player15!$A$3:$A$30) |
0 |
D18 |
=COUNT(Player15!$AE$3:$AE$30) |
0 |
E18 |
=C18-D18 |
0 |
F18 |
=SUM(Player15!$AP$3:$AP$30) |
0 |
G18 |
=SUM(Player15!$AQ$3:$AQ$30) |
0 |
H18 |
=SUM(Player15!$AR$3:$AR$30) |
0 |
I18 |
=SUM(Player15!$AS$3:$AS$30) |
0 |
J18 |
=SUM(F18:I18) |
0 |
K18 |
=MAX(Player15!$AE$3:$AE$30) |
0 |
L18 |
=SUM(Player15!$AM$3:$AM$30) |
0 |
M18 |
=SUM(Player15!$AN$3:$AN$30) |
0 |
N18 |
=IF(C18=0,0,MAX(Player15!$AO$3:$AO$30))*3 |
0 |
O18 |
=IF(C18=0,0,MAX(Player15!$AO$3:$AO$30)) |
0 |
P18 |
=IF(C18=0,0,M18/L18) |
0 |
Q18 |
=IF(C18=0,0,D18/C18) |
0 |
C19 |
=COUNT(Player16!$A$3:$A$30) |
0 |
D19 |
=COUNT(Player16!$AE$3:$AE$30) |
0 |
E19 |
=C19-D19 |
0 |
F19 |
=SUM(Player16!$AP$3:$AP$30) |
0 |
G19 |
=SUM(Player16!$AQ$3:$AQ$30) |
0 |
H19 |
=SUM(Player16!$AR$3:$AR$30) |
0 |
I19 |
=SUM(Player16!$AS$3:$AS$30) |
0 |
J19 |
=SUM(F19:I19) |
0 |
K19 |
=MAX(Player16!$AE$3:$AE$30) |
0 |
L19 |
=SUM(Player16!$AM$3:$AM$30) |
0 |
M19 |
=SUM(Player16!$AN$3:$AN$30) |
0 |
N19 |
=IF(C19=0,0,MAX(Player16!$AO$3:$AO$30))*3 |
0 |
O19 |
=IF(C19=0,0,MAX(Player16!$AO$3:$AO$30)) |
0 |
P19 |
=IF(C19=0,0,M19/L19) |
0 |
Q19 |
=IF(C19=0,0,D19/C19) |
0 |
C20 |
=COUNT(Player17!$A$3:$A$30) |
0 |
D20 |
=COUNT(Player17!$AE$3:$AE$30) |
0 |
E20 |
=C20-D20 |
0 |
F20 |
=SUM(Player17!$AP$3:$AP$30) |
0 |
G20 |
=SUM(Player17!$AQ$3:$AQ$30) |
0 |
H20 |
=SUM(Player17!$AR$3:$AR$30) |
0 |
I20 |
=SUM(Player17!$AS$3:$AS$30) |
0 |
J20 |
=SUM(F20:I20) |
0 |
K20 |
=MAX(Player17!$AE$3:$AE$30) |
0 |
L20 |
=SUM(Player17!$AM$3:$AM$30) |
0 |
M20 |
=SUM(Player17!$AN$3:$AN$30) |
0 |
N20 |
=IF(C20=0,0,MAX(Player17!$AO$3:$AO$30))*3 |
0 |
O20 |
=IF(C20=0,0,MAX(Player17!$AO$3:$AO$30)) |
0 |
P20 |
=IF(C20=0,0,M20/L20) |
0 |
Q20 |
=IF(C20=0,0,D20/C20) |
0 |
C21 |
=COUNT(Player18!$A$3:$A$30) |
0 |
D21 |
=COUNT(Player18!$AE$3:$AE$30) |
0 |
E21 |
=C21-D21 |
0 |
F21 |
=SUM(Player18!$AP$3:$AP$30) |
0 |
G21 |
=SUM(Player18!$AQ$3:$AQ$30) |
0 |
H21 |
=SUM(Player18!$AR$3:$AR$30) |
0 |
I21 |
=SUM(Player18!$AS$3:$AS$30) |
0 |
J21 |
=SUM(F21:I21) |
0 |
K21 |
=MAX(Player18!$AE$3:$AE$30) |
0 |
L21 |
=SUM(Player18!$AM$3:$AM$30) |
0 |
M21 |
=SUM(Player18!$AN$3:$AN$30) |
0 |
N21 |
=IF(C21=0,0,MAX(Player18!$AO$3:$AO$30))*3 |
0 |
O21 |
=IF(C21=0,0,MAX(Player18!$AO$3:$AO$30)) |
0 |
P21 |
=IF(C21=0,0,M21/L21) |
0 |
Q21 |
=IF(C21=0,0,D21/C21) |
0 |
C22 |
=COUNT(Player19!$A$3:$A$30) |
0 |
D22 |
=COUNT(Player19!$AE$3:$AE$30) |
0 |
E22 |
=C22-D22 |
0 |
F22 |
=SUM(Player19!$AP$3:$AP$30) |
0 |
G22 |
=SUM(Player19!$AQ$3:$AQ$30) |
0 |
H22 |
=SUM(Player19!$AR$3:$AR$30) |
0 |
I22 |
=SUM(Player19!$AS$3:$AS$30) |
0 |
J22 |
=SUM(F22:I22) |
0 |
K22 |
=MAX(Player19!$AE$3:$AE$30) |
0 |
L22 |
=SUM(Player19!$AM$3:$AM$30) |
0 |
M22 |
=SUM(Player19!$AN$3:$AN$30) |
0 |
N22 |
=IF(C22=0,0,MAX(Player19!$AO$3:$AO$30))*3 |
0 |
O22 |
=IF(C22=0,0,MAX(Player19!$AO$3:$AO$30)) |
0 |
P22 |
=IF(C22=0,0,M22/L22) |
0 |
Q22 |
=IF(C22=0,0,D22/C22) |
0 |
C23 |
=COUNT(Player20!$A$3:$A$30) |
0 |
D23 |
=COUNT(Player20!$AE$3:$AE$30) |
0 |
E23 |
=C23-D23 |
0 |
F23 |
=SUM(Player20!$AP$3:$AP$30) |
0 |
G23 |
=SUM(Player20!$AQ$3:$AQ$30) |
0 |
H23 |
=SUM(Player20!$AR$3:$AR$30) |
0 |
I23 |
=SUM(Player20!$AS$3:$AS$30) |
0 |
J23 |
=SUM(F23:I23) |
0 |
K23 |
=MAX(Player20!$AE$3:$AE$30) |
0 |
L23 |
=SUM(Player20!$AM$3:$AM$30) |
0 |
M23 |
=SUM(Player20!$AN$3:$AN$30) |
0 |
N23 |
=IF(C23=0,0,MAX(Player20!$AO$3:$AO$30))*3 |
0 |
O23 |
=IF(C23=0,0,MAX(Player20!$AO$3:$AO$30)) |
0 |
P23 |
=IF(C23=0,0,M23/L23) |
0 |
Q23 |
=IF(C23=0,0,D23/C23) |
0 |
C24 |
=COUNT(Player21!$A$3:$A$30) |
0 |
D24 |
=COUNT(Player21!$AE$3:$AE$30) |
0 |
E24 |
=C24-D24 |
0 |
F24 |
=SUM(Player21!$AP$3:$AP$30) |
0 |
G24 |
=SUM(Player21!$AQ$3:$AQ$30) |
0 |
H24 |
=SUM(Player21!$AR$3:$AR$30) |
0 |
I24 |
=SUM(Player21!$AS$3:$AS$30) |
0 |
J24 |
=SUM(F24:I24) |
0 |
K24 |
=MAX(Player21!$AE$3:$AE$30) |
0 |
L24 |
=SUM(Player21!$AM$3:$AM$30) |
0 |
M24 |
=SUM(Player21!$AN$3:$AN$30) |
0 |
N24 |
=IF(C24=0,0,MAX(Player21!$AO$3:$AO$30))*3 |
0 |
O24 |
=IF(C24=0,0,MAX(Player21!$AO$3:$AO$30)) |
0 |
P24 |
=IF(C24=0,0,M24/L24) |
0 |
Q24 |
=IF(C24=0,0,D24/C24) |
0 |
C25 |
=COUNT(Player22!$A$3:$A$30) |
0 |
D25 |
=COUNT(Player22!$AE$3:$AE$30) |
0 |
E25 |
=C25-D25 |
0 |
F25 |
=SUM(Player22!$AP$3:$AP$30) |
0 |
G25 |
=SUM(Player22!$AQ$3:$AQ$30) |
0 |
H25 |
=SUM(Player22!$AR$3:$AR$30) |
0 |
I25 |
=SUM(Player22!$AS$3:$AS$30) |
0 |
J25 |
=SUM(F25:I25) |
0 |
K25 |
=MAX(Player22!$AE$3:$AE$30) |
0 |
L25 |
=SUM(Player22!$AM$3:$AM$30) |
0 |
M25 |
=SUM(Player22!$AN$3:$AN$30) |
0 |
N25 |
=IF(C25=0,0,MAX(Player22!$AO$3:$AO$30))*3 |
0 |
O25 |
=IF(C25=0,0,MAX(Player22!$AO$3:$AO$30)) |
0 |
P25 |
=IF(C25=0,0,M25/L25) |
0 |
Q25 |
=IF(C25=0,0,D25/C25) |
0 |
C26 |
=COUNT(Player23!$A$3:$A$30) |
0 |
D26 |
=COUNT(Player23!$AE$3:$AE$30) |
0 |
E26 |
=C26-D26 |
0 |
F26 |
=SUM(Player23!$AP$3:$AP$30) |
0 |
G26 |
=SUM(Player23!$AQ$3:$AQ$30) |
0 |
H26 |
=SUM(Player23!$AR$3:$AR$30) |
0 |
I26 |
=SUM(Player23!$AS$3:$AS$30) |
0 |
J26 |
=SUM(F26:I26) |
0 |
K26 |
=MAX(Player23!$AE$3:$AE$30) |
0 |
L26 |
=SUM(Player23!$AM$3:$AM$30) |
0 |
M26 |
=SUM(Player23!$AN$3:$AN$30) |
0 |
N26 |
=IF(C26=0,0,MAX(Player23!$AO$3:$AO$30))*3 |
0 |
O26 |
=IF(C26=0,0,MAX(Player23!$AO$3:$AO$30)) |
0 |
P26 |
=IF(C26=0,0,M26/L26) |
0 |
Q26 |
=IF(C26=0,0,D26/C26) |
0 |
C27 |
=COUNT(Player24!$A$3:$A$30) |
0 |
D27 |
=COUNT(Player24!$AE$3:$AE$30) |
0 |
E27 |
=C27-D27 |
0 |
F27 |
=SUM(Player24!$AP$3:$AP$30) |
0 |
G27 |
=SUM(Player24!$AQ$3:$AQ$30) |
0 |
H27 |
=SUM(Player24!$AR$3:$AR$30) |
0 |
I27 |
=SUM(Player24!$AS$3:$AS$30) |
0 |
J27 |
=SUM(F27:I27) |
0 |
K27 |
=MAX(Player24!$AE$3:$AE$30) |
0 |
L27 |
=SUM(Player24!$AM$3:$AM$30) |
0 |
M27 |
=SUM(Player24!$AN$3:$AN$30) |
0 |
N27 |
=IF(C27=0,0,MAX(Player24!$AO$3:$AO$30))*3 |
0 |
O27 |
=IF(C27=0,0,MAX(Player24!$AO$3:$AO$30)) |
0 |
P27 |
=IF(C27=0,0,M27/L27) |
0 |
Q27 |
=IF(C27=0,0,D27/C27) |
0 |
C28 |
=COUNT(Player25!$A$3:$A$30) |
0 |
D28 |
=COUNT(Player25!$AE$3:$AE$30) |
0 |
E28 |
=C28-D28 |
0 |
F28 |
=SUM(Player25!$AP$3:$AP$30) |
0 |
G28 |
=SUM(Player25!$AQ$3:$AQ$30) |
0 |
H28 |
=SUM(Player25!$AR$3:$AR$30) |
0 |
I28 |
=SUM(Player25!$AS$3:$AS$30) |
0 |
J28 |
=SUM(F28:I28) |
0 |
K28 |
=MAX(Player25!$AE$3:$AE$30) |
0 |
L28 |
=SUM(Player25!$AM$3:$AM$30) |
0 |
M28 |
=SUM(Player25!$AN$3:$AN$30) |
0 |
N28 |
=IF(C28=0,0,MAX(Player25!$AO$3:$AO$30))*3 |
0 |
O28 |
=IF(C28=0,0,MAX(Player25!$AO$3:$AO$30)) |
0 |
P28 |
=IF(C28=0,0,M28/L28) |
0 |
Q28 |
=IF(C28=0,0,D28/C28) |
0 |
C29 |
=COUNT(Player26!$A$3:$A$30) |
0 |
D29 |
=COUNT(Player26!$AE$3:$AE$30) |
0 |
E29 |
=C29-D29 |
0 |
F29 |
=SUM(Player26!$AP$3:$AP$30) |
0 |
G29 |
=SUM(Player26!$AQ$3:$AQ$30) |
0 |
H29 |
=SUM(Player26!$AR$3:$AR$30) |
0 |
I29 |
=SUM(Player26!$AS$3:$AS$30) |
0 |
J29 |
=SUM(F29:I29) |
0 |
K29 |
=MAX(Player26!$AE$3:$AE$30) |
0 |
L29 |
=SUM(Player26!$AM$3:$AM$30) |
0 |
M29 |
=SUM(Player26!$AN$3:$AN$30) |
0 |
N29 |
=IF(C29=0,0,MAX(Player26!$AO$3:$AO$30))*3 |
0 |
O29 |
=IF(C29=0,0,MAX(Player26!$AO$3:$AO$30)) |
0 |
P29 |
=IF(C29=0,0,M29/L29) |
0 |
Q29 |
=IF(C29=0,0,D29/C29) |
0 |
C30 |
=COUNT(Player27!$A$3:$A$30) |
0 |
D30 |
=COUNT(Player27!$AE$3:$AE$30) |
0 |
E30 |
=C30-D30 |
0 |
F30 |
=SUM(Player27!$AP$3:$AP$30) |
0 |
G30 |
=SUM(Player27!$AQ$3:$AQ$30) |
0 |
H30 |
=SUM(Player27!$AR$3:$AR$30) |
0 |
I30 |
=SUM(Player27!$AS$3:$AS$30) |
0 |
J30 |
=SUM(F30:I30) |
0 |
K30 |
=MAX(Player27!$AE$3:$AE$30) |
0 |
L30 |
=SUM(Player27!$AM$3:$AM$30) |
0 |
M30 |
=SUM(Player27!$AN$3:$AN$30) |
0 |
N30 |
=IF(C30=0,0,MAX(Player27!$AO$3:$AO$30))*3 |
0 |
O30 |
=IF(C30=0,0,MAX(Player27!$AO$3:$AO$30)) |
0 |
P30 |
=IF(C30=0,0,M30/L30) |
0 |
Q30 |
=IF(C30=0,0,D30/C30) |
0 |
C31 |
=COUNT(Player28!$A$3:$A$30) |
0 |
D31 |
=COUNT(Player28!$AE$3:$AE$30) |
0 |
E31 |
=C31-D31 |
0 |
F31 |
=SUM(Player28!$AP$3:$AP$30) |
0 |
G31 |
=SUM(Player28!$AQ$3:$AQ$30) |
0 |
H31 |
=SUM(Player28!$AR$3:$AR$30) |
0 |
I31 |
=SUM(Player28!$AS$3:$AS$30) |
0 |
J31 |
=SUM(F31:I31) |
0 |
K31 |
=MAX(Player28!$AE$3:$AE$30) |
0 |
L31 |
=SUM(Player28!$AM$3:$AM$30) |
0 |
M31 |
=SUM(Player28!$AN$3:$AN$30) |
0 |
N31 |
=IF(C31=0,0,MAX(Player28!$AO$3:$AO$30))*3 |
0 |
O31 |
=IF(C31=0,0,MAX(Player28!$AO$3:$AO$30)) |
0 |
P31 |
=IF(C31=0,0,M31/L31) |
0 |
Q31 |
=IF(C31=0,0,D31/C31) |
0 |
C32 |
=COUNT(Player29!$A$3:$A$30) |
0 |
D32 |
=COUNT(Player29!$AE$3:$AE$30) |
0 |
E32 |
=C32-D32 |
0 |
F32 |
=SUM(Player29!$AP$3:$AP$30) |
0 |
G32 |
=SUM(Player29!$AQ$3:$AQ$30) |
0 |
H32 |
=SUM(Player29!$AR$3:$AR$30) |
0 |
I32 |
=SUM(Player29!$AS$3:$AS$30) |
0 |
J32 |
=SUM(F32:I32) |
0 |
K32 |
=MAX(Player29!$AE$3:$AE$30) |
0 |
L32 |
=SUM(Player29!$AM$3:$AM$30) |
0 |
M32 |
=SUM(Player29!$AN$3:$AN$30) |
0 |
N32 |
=IF(C32=0,0,MAX(Player29!$AO$3:$AO$30))*3 |
0 |
O32 |
=IF(C32=0,0,MAX(Player29!$AO$3:$AO$30)) |
0 |
P32 |
=IF(C32=0,0,M32/L32) |
0 |
Q32 |
=IF(C32=0,0,D32/C32) |
0 |
C33 |
=COUNT(Player30!$A$3:$A$30) |
0 |
D33 |
=COUNT(Player30!$AE$3:$AE$30) |
0 |
E33 |
=C33-D33 |
0 |
F33 |
=SUM(Player30!$AP$3:$AP$30) |
0 |
G33 |
=SUM(Player30!$AQ$3:$AQ$30) |
0 |
H33 |
=SUM(Player30!$AR$3:$AR$30) |
0 |
I33 |
=SUM(Player30!$AS$3:$AS$30) |
0 |
J33 |
=SUM(F33:I33) |
0 |
K33 |
=MAX(Player30!$AE$3:$AE$30) |
0 |
L33 |
=SUM(Player30!$AM$3:$AM$30) |
0 |
M33 |
=SUM(Player30!$AN$3:$AN$30) |
0 |
N33 |
=IF(C33=0,0,MAX(Player30!$AO$3:$AO$30))*3 |
0 |
O33 |
=IF(C33=0,0,MAX(Player30!$AO$3:$AO$30)) |
0 |
P33 |
=IF(C33=0,0,M33/L33) |
0 |
Q33 |
=IF(C33=0,0,D33/C33) |
0 |
C34 |
=COUNT(Player31!$A$3:$A$30) |
0 |
D34 |
=COUNT(Player31!$AE$3:$AE$30) |
0 |
E34 |
=C34-D34 |
0 |
F34 |
=SUM(Player31!$AP$3:$AP$30) |
0 |
G34 |
=SUM(Player31!$AQ$3:$AQ$30) |
0 |
H34 |
=SUM(Player31!$AR$3:$AR$30) |
0 |
I34 |
=SUM(Player31!$AS$3:$AS$30) |
0 |
J34 |
=SUM(F34:I34) |
0 |
K34 |
=MAX(Player31!$AE$3:$AE$30) |
0 |
L34 |
=SUM(Player31!$AM$3:$AM$30) |
0 |
M34 |
=SUM(Player31!$AN$3:$AN$30) |
0 |
N34 |
=IF(C34=0,0,MAX(Player31!$AO$3:$AO$30))*3 |
0 |
O34 |
=IF(C34=0,0,MAX(Player31!$AO$3:$AO$30)) |
0 |
P34 |
=IF(C34=0,0,M34/L34) |
0 |
Q34 |
=IF(C34=0,0,D34/C34) |
0 |
C36 |
=SUM(C3:C34) |
1 |
D36 |
=SUM(D3:D34) |
1 |
E36 |
=SUM(E3:E34) |
0 |
F36 |
=SUM(F3:F34) |
0 |
G36 |
=SUM(G3:G34) |
0 |
H36 |
=SUM(H3:H34) |
0 |
I36 |
=SUM(I3:I34) |
0 |
J36 |
=SUM(J3:J34) |
0 |
K36 |
=MAX(K3:K34) |
12 |
L36 |
=SUM(L3:L34) |
43 |
M36 |
=SUM(M3:M34) |
601 |
N36 |
=AVERAGE(N3:N34) |
1.310319767 |
O36 |
=MAX(O3:O34) |
13.97674419 |
P36 |
=IF(C36=0,0,M36/L36) |
13.97674419 |
Q36 |
=IF(C36=0,0,D36/C36) |
1 |
D45 |
=MIN(IF(Player0!$AN$3:$AN$60=601,Player0!$AM$3:$AM$60)) |
0 |
E45 |
=IF(D45=0,0,INDEX(Player0!$AE$3:$AE$60,MATCH(D45,Player0!$AM$3:$AM$60,0))) |
0 |
F45 |
=IF(ISERROR(E45),"",(IF(E45=0,"",D45))) |
|
G45 |
=IF(ISERROR(E45),"",(IF(E45=0,"",IF(F45=$F$77,C45,"")))) |
|
D46 |
=MIN(IF(Player1!$AN$3:$AN$60=601,Player1!$AM$3:$AM$60)) |
43 |
E46 |
=IF(D46=0,0,INDEX(Player1!$AE$3:$AE$60,MATCH(D46,Player1!$AM$3:$AM$60,0))) |
12 |
F46 |
=IF(ISERROR(E46),"",(IF(E46=0,"",D46))) |
43 |
G46 |
=IF(ISERROR(E46),"",(IF(E46=0,"",IF(F46=$F$77,C46,"")))) |
Tom Dick |
D47 |
=MIN(IF(Player2!$AN$3:$AN$60=601,Player2!$AM$3:$AM$60)) |
0 |
E47 |
=IF(D47=0,0,INDEX(Player2!$AE$3:$AE$60,MATCH(D47,Player2!$AM$3:$AM$60,0))) |
0 |
F47 |
=IF(ISERROR(E47),"",(IF(E47=0,"",D47))) |
|
G47 |
=IF(ISERROR(E47),"",(IF(E47=0,"",IF(F47=$F$77,C47,"")))) |
|
D48 |
=MIN(IF(Player3!$AN$3:$AN$60=601,Player3!$AM$3:$AM$60)) |
0 |
E48 |
=IF(D48=0,0,INDEX(Player3!$AE$3:$AE$60,MATCH(D48,Player3!$AM$3:$AM$60,0))) |
0 |
F48 |
=IF(ISERROR(E48),"",(IF(E48=0,"",D48))) |
|
G48 |
=IF(ISERROR(E48),"",(IF(E48=0,"",IF(F48=$F$77,C48,"")))) |
|
D49 |
=MIN(IF(Player4!$AN$3:$AN$60=601,Player4!$AM$3:$AM$60)) |
0 |
E49 |
=IF(D49=0,0,INDEX(Player4!$AE$3:$AE$60,MATCH(D49,Player4!$AM$3:$AM$60,0))) |
0 |
F49 |
=IF(ISERROR(E49),"",(IF(E49=0,"",D49))) |
|
G49 |
=IF(ISERROR(E49),"",(IF(E49=0,"",IF(F49=$F$77,C49,"")))) |
|
D50 |
=MIN(IF(Player5!$AN$3:$AN$60=601,Player5!$AM$3:$AM$60)) |
0 |
E50 |
=IF(D50=0,0,INDEX(Player5!$AE$3:$AE$60,MATCH(D50,Player5!$AM$3:$AM$60,0))) |
0 |
F50 |
=IF(ISERROR(E50),"",(IF(E50=0,"",D50))) |
|
G50 |
=IF(ISERROR(E50),"",(IF(E50=0,"",IF(F50=$F$77,C50,"")))) |
|
D51 |
=MIN(IF(Player6!$AN$3:$AN$60=601,Player6!$AM$3:$AM$60)) |
0 |
E51 |
=IF(D51=0,0,INDEX(Player6!$AE$3:$AE$60,MATCH(D51,Player6!$AM$3:$AM$60,0))) |
0 |
F51 |
=IF(ISERROR(E51),"",(IF(E51=0,"",D51))) |
|
G51 |
=IF(ISERROR(E51),"",(IF(E51=0,"",IF(F51=$F$77,C51,"")))) |
|
D52 |
=MIN(IF(Player7!$AN$3:$AN$60=601,Player7!$AM$3:$AM$60)) |
0 |
E52 |
=IF(D52=0,0,INDEX(Player7!$AE$3:$AE$60,MATCH(D52,Player7!$AM$3:$AM$60,0))) |
0 |
F52 |
=IF(ISERROR(E52),"",(IF(E52=0,"",D52))) |
|
G52 |
=IF(ISERROR(E52),"",(IF(E52=0,"",IF(F52=$F$77,C52,"")))) |
|
D53 |
=MIN(IF(Player8!$AN$3:$AN$60=601,Player8!$AM$3:$AM$60)) |
0 |
E53 |
=IF(D53=0,0,INDEX(Player8!$AE$3:$AE$60,MATCH(D53,Player8!$AM$3:$AM$60,0))) |
0 |
F53 |
=IF(ISERROR(E53),"",(IF(E53=0,"",D53))) |
|
G53 |
=IF(ISERROR(E53),"",(IF(E53=0,"",IF(F53=$F$77,C53,"")))) |
|
D54 |
=MIN(IF(Player9!$AN$3:$AN$60=601,Player9!$AM$3:$AM$60)) |
0 |
E54 |
=IF(D54=0,0,INDEX(Player9!$AE$3:$AE$60,MATCH(D54,Player9!$AM$3:$AM$60,0))) |
0 |
F54 |
=IF(ISERROR(E54),"",(IF(E54=0,"",D54))) |
|
G54 |
=IF(ISERROR(E54),"",(IF(E54=0,"",IF(F54=$F$77,C54,"")))) |
|
D55 |
=MIN(IF(Player10!$AN$3:$AN$60=601,Player10!$AM$3:$AM$60)) |
0 |
E55 |
=IF(D55=0,0,INDEX(Player10!$AE$3:$AE$60,MATCH(D55,Player10!$AM$3:$AM$60,0))) |
0 |
F55 |
=IF(ISERROR(E55),"",(IF(E55=0,"",D55))) |
|
G55 |
=IF(ISERROR(E55),"",(IF(E55=0,"",IF(F55=$F$77,C55,"")))) |
|
D56 |
=MIN(IF(Player11!$AN$3:$AN$60=601,Player11!$AM$3:$AM$60)) |
0 |
E56 |
=IF(D56=0,0,INDEX(Player11!$AE$3:$AE$60,MATCH(D56,Player11!$AM$3:$AM$60,0))) |
0 |
F56 |
=IF(ISERROR(E56),"",(IF(E56=0,"",D56))) |
|
G56 |
=IF(ISERROR(E56),"",(IF(E56=0,"",IF(F56=$F$77,C56,"")))) |
|
D57 |
=MIN(IF(Player12!$AN$3:$AN$60=601,Player12!$AM$3:$AM$60)) |
0 |
E57 |
=IF(D57=0,0,INDEX(Player12!$AE$3:$AE$60,MATCH(D57,Player12!$AM$3:$AM$60,0))) |
0 |
F57 |
=IF(ISERROR(E57),"",(IF(E57=0,"",D57))) |
|
G57 |
=IF(ISERROR(E57),"",(IF(E57=0,"",IF(F57=$F$77,C57,"")))) |
|
D58 |
=MIN(IF(Player13!$AN$3:$AN$60=601,Player13!$AM$3:$AM$60)) |
0 |
E58 |
=IF(D58=0,0,INDEX(Player13!$AE$3:$AE$60,MATCH(D58,Player13!$AM$3:$AM$60,0))) |
0 |
F58 |
=IF(ISERROR(E58),"",(IF(E58=0,"",D58))) |
|
G58 |
=IF(ISERROR(E58),"",(IF(E58=0,"",IF(F58=$F$77,C58,"")))) |
|
D59 |
=MIN(IF(Player14!$AN$3:$AN$60=601,Player14!$AM$3:$AM$60)) |
0 |
E59 |
=IF(D59=0,0,INDEX(Player14!$AE$3:$AE$60,MATCH(D59,Player14!$AM$3:$AM$60,0))) |
0 |
F59 |
=IF(ISERROR(E59),"",(IF(E59=0,"",D59))) |
|
G59 |
=IF(ISERROR(E59),"",(IF(E59=0,"",IF(F59=$F$77,C59,"")))) |
|
D60 |
=MIN(IF(Player15!$AN$3:$AN$60=601,Player15!$AM$3:$AM$60)) |
0 |
E60 |
=IF(D60=0,0,INDEX(Player15!$AE$3:$AE$60,MATCH(D60,Player15!$AM$3:$AM$60,0))) |
0 |
F60 |
=IF(ISERROR(E60),"",(IF(E60=0,"",D60))) |
|
G60 |
=IF(ISERROR(E60),"",(IF(E60=0,"",IF(F60=$F$77,C60,"")))) |
|
D61 |
=MIN(IF(Player16!$AN$3:$AN$60=601,Player16!$AM$3:$AM$60)) |
0 |
E61 |
=IF(D61=0,0,INDEX(Player16!$AE$3:$AE$60,MATCH(D61,Player16!$AM$3:$AM$60,0))) |
0 |
F61 |
=IF(ISERROR(E61),"",(IF(E61=0,"",D61))) |
|
G61 |
=IF(ISERROR(E61),"",(IF(E61=0,"",IF(F61=$F$77,C61,"")))) |
|
D62 |
=MIN(IF(Player17!$AN$3:$AN$60=601,Player17!$AM$3:$AM$60)) |
0 |
E62 |
=IF(D62=0,0,INDEX(Player17!$AE$3:$AE$60,MATCH(D62,Player17!$AM$3:$AM$60,0))) |
0 |
F62 |
=IF(ISERROR(E62),"",(IF(E62=0,"",D62))) |
|
G62 |
=IF(ISERROR(E62),"",(IF(E62=0,"",IF(F62=$F$77,C62,"")))) |
|
D63 |
=MIN(IF(Player18!$AN$3:$AN$60=601,Player18!$AM$3:$AM$60)) |
0 |
E63 |
=IF(D63=0,0,INDEX(Player18!$AE$3:$AE$60,MATCH(D63,Player18!$AM$3:$AM$60,0))) |
0 |
F63 |
=IF(ISERROR(E63),"",(IF(E63=0,"",D63))) |
|
G63 |
=IF(ISERROR(E63),"",(IF(E63=0,"",IF(F63=$F$77,C63,"")))) |
|
D64 |
=MIN(IF(Player19!$AN$3:$AN$60=601,Player19!$AM$3:$AM$60)) |
0 |
E64 |
=IF(D64=0,0,INDEX(Player19!$AE$3:$AE$60,MATCH(D64,Player19!$AM$3:$AM$60,0))) |
0 |
F64 |
=IF(ISERROR(E64),"",(IF(E64=0,"",D64))) |
|
G64 |
=IF(ISERROR(E64),"",(IF(E64=0,"",IF(F64=$F$77,C64,"")))) |
|
D65 |
=MIN(IF(Player20!$AN$3:$AN$60=601,Player20!$AM$3:$AM$60)) |
0 |
E65 |
=IF(D65=0,0,INDEX(Player20!$AE$3:$AE$60,MATCH(D65,Player20!$AM$3:$AM$60,0))) |
0 |
F65 |
=IF(ISERROR(E65),"",(IF(E65=0,"",D65))) |
|
G65 |
=IF(ISERROR(E65),"",(IF(E65=0,"",IF(F65=$F$77,C65,"")))) |
|
D66 |
=MIN(IF(Player21!$AN$3:$AN$60=601,Player21!$AM$3:$AM$60)) |
0 |
E66 |
=IF(D66=0,0,INDEX(Player21!$AE$3:$AE$60,MATCH(D66,Player21!$AM$3:$AM$60,0))) |
0 |
F66 |
=IF(ISERROR(E66),"",(IF(E66=0,"",D66))) |
|
G66 |
=IF(ISERROR(E66),"",(IF(E66=0,"",IF(F66=$F$77,C66,"")))) |
|
D67 |
=MIN(IF(Player22!$AN$3:$AN$60=601,Player22!$AM$3:$AM$60)) |
0 |
E67 |
=IF(D67=0,0,INDEX(Player22!$AE$3:$AE$60,MATCH(D67,Player22!$AM$3:$AM$60,0))) |
0 |
F67 |
=IF(ISERROR(E67),"",(IF(E67=0,"",D67))) |
|
G67 |
=IF(ISERROR(E67),"",(IF(E67=0,"",IF(F67=$F$77,C67,"")))) |
|
D68 |
=MIN(IF(Player23!$AN$3:$AN$60=601,Player23!$AM$3:$AM$60)) |
0 |
E68 |
=IF(D68=0,0,INDEX(Player23!$AE$3:$AE$60,MATCH(D68,Player23!$AM$3:$AM$60,0))) |
0 |
F68 |
=IF(ISERROR(E68),"",(IF(E68=0,"",D68))) |
|
G68 |
=IF(ISERROR(E68),"",(IF(E68=0,"",IF(F68=$F$77,C68,"")))) |
|
D69 |
=MIN(IF(Player24!$AN$3:$AN$60=601,Player24!$AM$3:$AM$60)) |
0 |
E69 |
=IF(D69=0,0,INDEX(Player24!$AE$3:$AE$60,MATCH(D69,Player24!$AM$3:$AM$60,0))) |
0 |
F69 |
=IF(ISERROR(E69),"",(IF(E69=0,"",D69))) |
|
G69 |
=IF(ISERROR(E69),"",(IF(E69=0,"",IF(F69=$F$77,C69,"")))) |
|
D70 |
=MIN(IF(Player25!$AN$3:$AN$60=601,Player25!$AM$3:$AM$60)) |
0 |
E70 |
=IF(D70=0,0,INDEX(Player25!$AE$3:$AE$60,MATCH(D70,Player25!$AM$3:$AM$60,0))) |
0 |
F70 |
=IF(ISERROR(E70),"",(IF(E70=0,"",D70))) |
|
G70 |
=IF(ISERROR(E70),"",(IF(E70=0,"",IF(F70=$F$77,C70,"")))) |
|
D71 |
=MIN(IF(Player26!$AN$3:$AN$60=601,Player26!$AM$3:$AM$60)) |
0 |
E71 |
=IF(D71=0,0,INDEX(Player26!$AE$3:$AE$60,MATCH(D71,Player26!$AM$3:$AM$60,0))) |
0 |
F71 |
=IF(ISERROR(E71),"",(IF(E71=0,"",D71))) |
|
G71 |
=IF(ISERROR(E71),"",(IF(E71=0,"",IF(F71=$F$77,C71,"")))) |
|
D72 |
=MIN(IF(Player27!$AN$3:$AN$60=601,Player27!$AM$3:$AM$60)) |
0 |
E72 |
=IF(D72=0,0,INDEX(Player27!$AE$3:$AE$60,MATCH(D72,Player27!$AM$3:$AM$60,0))) |
0 |
F72 |
=IF(ISERROR(E72),"",(IF(E72=0,"",D72))) |
|
G72 |
=IF(ISERROR(E72),"",(IF(E72=0,"",IF(F72=$F$77,C72,"")))) |
|
D73 |
=MIN(IF(Player28!$AN$3:$AN$60=601,Player28!$AM$3:$AM$60)) |
0 |
E73 |
=IF(D73=0,0,INDEX(Player28!$AE$3:$AE$60,MATCH(D73,Player28!$AM$3:$AM$60,0))) |
0 |
F73 |
=IF(ISERROR(E73),"",(IF(E73=0,"",D73))) |
|
G73 |
=IF(ISERROR(E73),"",(IF(E73=0,"",IF(F73=$F$77,C73,"")))) |
|
D74 |
=MIN(IF(Player29!$AN$3:$AN$60=601,Player29!$AM$3:$AM$60)) |
0 |
E74 |
=IF(D74=0,0,INDEX(Player29!$AE$3:$AE$60,MATCH(D74,Player29!$AM$3:$AM$60,0))) |
0 |
F74 |
=IF(ISERROR(E74),"",(IF(E74=0,"",D74))) |
|
G74 |
=IF(ISERROR(E74),"",(IF(E74=0,"",IF(F74=$F$77,C74,"")))) |
|
D75 |
=MIN(IF(Player30!$AN$3:$AN$60=601,Player30!$AM$3:$AM$60)) |
0 |
E75 |
=IF(D75=0,0,INDEX(Player30!$AE$3:$AE$60,MATCH(D75,Player30!$AM$3:$AM$60,0))) |
0 |
F75 |
=IF(ISERROR(E75),"",(IF(E75=0,"",D75))) |
|
G75 |
=IF(ISERROR(E75),"",(IF(E75=0,"",IF(F75=$F$77,C75,"")))) |
|
D76 |
=MIN(IF(Player31!$AN$3:$AN$60=601,Player31!$AM$3:$AM$60)) |
0 |
E76 |
=IF(D76=0,0,INDEX(Player31!$AE$3:$AE$60,MATCH(D76,Player31!$AM$3:$AM$60,0))) |
0 |
F76 |
=IF(ISERROR(E76),"",(IF(E76=0,"",D76))) |
|
G76 |
=IF(ISERROR(E76),"",(IF(E76=0,"",IF(F76=$F$77,C76,"")))) |
|
D77 |
=MIN(IF(D45:D76<>0,D45:D76)) |
43 |
E77 |
=VLOOKUP(D77,D45:E76,2,FALSE) |
12 |
F77 |
=MIN(IF(F45:F76<>0,F45:F76)) |
43 |
G77 |
=INDEX(G45:G76,MATCH(TRUE,LEN(G45:G76)<>0,0),1) |
Tom Dick |
K45 |
=MAX(Player0!$AM$3:$AM$30) |
0 |
L45 |
=IF(ISERROR(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0))),"-",(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0)))) |
- |
M45 |
=IF(ISERROR(FontColor(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0)),TRUE))) |
- |
N45 |
=IF(M45="Red",H45,IF(M45="Green",I45,IF(M45="No
color","Lost",IF(M45<" ","-")))) |
- |
K46 |
=MAX(Player1!$AM$3:$AM$30) |
43 |
L46 |
=IF(ISERROR(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0))),"-",(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0)))) |
12 |
M46 |
=IF(ISERROR(FontColor(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0)),TRUE))) |
Green |
N46 |
=IF(M46="Red",H46,IF(M46="Green",I46,IF(M46="No
color","Lost",IF(M46<" ","-")))) |
Tom |
K47 |
=MAX(Player2!$AM$3:$AM$30) |
0 |
L47 |
=IF(ISERROR(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0))),"-",(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0)))) |
- |
M47 |
=IF(ISERROR(FontColor(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0)),TRUE))) |
- |
N47 |
=IF(M47="Red",H47,IF(M47="Green",I47,IF(M47="No
color","Lost",IF(M47<" ","-")))) |
- |
K48 |
=MAX(Player3!$AM$3:$AM$30) |
0 |
L48 |
=IF(ISERROR(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0))),"-",(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0)))) |
- |
M48 |
=IF(ISERROR(FontColor(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0)),TRUE))) |
- |
N48 |
=IF(M48="Red",H48,IF(M48="Green",I48,IF(M48="No
color","Lost",IF(M48<" ","-")))) |
- |
K49 |
=MAX(Player4!$AM$3:$AM$30) |
0 |
L49 |
=IF(ISERROR(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0))),"-",(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0)))) |
- |
M49 |
=IF(ISERROR(FontColor(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0)),TRUE))) |
- |
N49 |
=IF(M49="Red",H49,IF(M49="Green",I49,IF(M49="No
color","Lost",IF(M49<" ","-")))) |
- |
K50 |
=MAX(Player5!$AM$3:$AM$30) |
0 |
L50 |
=IF(ISERROR(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0))),"-",(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0)))) |
- |
M50 |
=IF(ISERROR(FontColor(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0)),TRUE))) |
- |
N50 |
=IF(M50="Red",H50,IF(M50="Green",I50,IF(M50="No
color","Lost",IF(M50<" ","-")))) |
- |
K51 |
=MAX(Player6!$AM$3:$AM$30) |
0 |
L51 |
=IF(ISERROR(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0))),"-",(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0)))) |
- |
M51 |
=IF(ISERROR(FontColor(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0)),TRUE))) |
- |
N51 |
=IF(M51="Red",H51,IF(M51="Green",I51,IF(M51="No
color","Lost",IF(M51<" ","-")))) |
- |
K52 |
=MAX(Player7!$AM$3:$AM$30) |
0 |
L52 |
=IF(ISERROR(INDEX(Player7!$AE$3:$AE$30,MATCH(MAX(Player7!$AN$3:$AN$30),Player7!$AN$3:$AN$30,0))),"-",(INDEX(Player7!$AE$3:$AE$30,MATCH(MAX(Player7!$AN$3:$AN$30),Player7!$AN$3:$AN$30,0)))) |
- |
M52 |
=IF(ISERROR(FontColor(INDEX(Player7!$AE$3:$AE$30,MATCH(MAX(Player7!$AN$3:$AN$30),Player7!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player7!$AE$3:$AE$30,MATCH(MAX(Player7!$AN$3:$AN$30),Player7!$AN$3:$AN$30,0)),TRUE))) |
- |
N52 |
=IF(M52="Red",H52,IF(M52="Green",I52,IF(M52="No
color","Lost",IF(M52<" ","-")))) |
- |
K53 |
=MAX(Player8!$AM$3:$AM$30) |
0 |
L53 |
=IF(ISERROR(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0))),"-",(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0)))) |
- |
M53 |
=IF(ISERROR(FontColor(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0)),TRUE))) |
- |
N53 |
=IF(M53="Red",H53,IF(M53="Green",I53,IF(M53="No
color","Lost",IF(M53<" ","-")))) |
- |
K54 |
=MAX(Player9!$AM$3:$AM$30) |
0 |
L54 |
=IF(ISERROR(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0))),"-",(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0)))) |
- |
M54 |
=IF(ISERROR(FontColor(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0)),TRUE))) |
- |
N54 |
=IF(M54="Red",H54,IF(M54="Green",I54,IF(M54="No
color","Lost",IF(M54<" ","-")))) |
- |
K55 |
=MAX(Player10!$AM$3:$AM$30) |
0 |
L55 |
=IF(ISERROR(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0))),"-",(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0)))) |
- |
M55 |
=IF(ISERROR(FontColor(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0)),TRUE))) |
- |
N55 |
=IF(M55="Red",H55,IF(M55="Green",I55,IF(M55="No
color","Lost",IF(M55<" ","-")))) |
- |
K56 |
=MAX(Player11!$AM$3:$AM$30) |
0 |
L56 |
=IF(ISERROR(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0))),"-",(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0)))) |
- |
M56 |
=IF(ISERROR(FontColor(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0)),TRUE))) |
- |
N56 |
=IF(M56="Red",H56,IF(M56="Green",I56,IF(M56="No
color","Lost",IF(M56<" ","-")))) |
- |
K57 |
=MAX(Player12!$AM$3:$AM$30) |
0 |
L57 |
=IF(ISERROR(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0))),"-",(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0)))) |
- |
M57 |
=IF(ISERROR(FontColor(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0)),TRUE))) |
- |
N57 |
=IF(M57="Red",H57,IF(M57="Green",I57,IF(M57="No
color","Lost",IF(M57<" ","-")))) |
- |
K58 |
=MAX(Player13!$AM$3:$AM$30) |
0 |
L58 |
=IF(ISERROR(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0))),"-",(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0)))) |
- |
M58 |
=IF(ISERROR(FontColor(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0)),TRUE))) |
- |
N58 |
=IF(M58="Red",H58,IF(M58="Green",I58,IF(M58="No
color","Lost",IF(M58<" ","-")))) |
- |
K59 |
=MAX(Player14!$AM$3:$AM$30) |
0 |
L59 |
=IF(ISERROR(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0))),"-",(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0)))) |
- |
M59 |
=IF(ISERROR(FontColor(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0)),TRUE))) |
- |
N59 |
=IF(M59="Red",H59,IF(M59="Green",I59,IF(M59="No
color","Lost",IF(M59<" ","-")))) |
- |
K60 |
=MAX(Player15!$AM$3:$AM$30) |
0 |
L60 |
=IF(ISERROR(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0))),"-",(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0)))) |
- |
M60 |
=IF(ISERROR(FontColor(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0)),TRUE))) |
- |
N60 |
=IF(M60="Red",H60,IF(M60="Green",I60,IF(M60="No
color","Lost",IF(M60<" ","-")))) |
- |
K61 |
=MAX(Player16!$AM$3:$AM$30) |
0 |
L61 |
=IF(ISERROR(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0))),"-",(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0)))) |
- |
M61 |
=IF(ISERROR(FontColor(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0)),TRUE))) |
- |
N61 |
=IF(M61="Red",H61,IF(M61="Green",I61,IF(M61="No
color","Lost",IF(M61<" ","-")))) |
- |
K62 |
=MAX(Player17!$AM$3:$AM$30) |
0 |
L62 |
=IF(ISERROR(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0))),"-",(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0)))) |
- |
M62 |
=IF(ISERROR(FontColor(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0)),TRUE))) |
- |
N62 |
=IF(M62="Red",H62,IF(M62="Green",I62,IF(M62="No
color","Lost",IF(M62<" ","-")))) |
- |
K63 |
=MAX(Player18!$AM$3:$AM$30) |
0 |
L63 |
=IF(ISERROR(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0))),"-",(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0)))) |
- |
M63 |
=IF(ISERROR(FontColor(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0)),TRUE))) |
- |
N63 |
=IF(M63="Red",H63,IF(M63="Green",I63,IF(M63="No
color","Lost",IF(M63<" ","-")))) |
- |
K64 |
=MAX(Player19!$AM$3:$AM$30) |
0 |
L64 |
=IF(ISERROR(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0))),"-",(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0)))) |
- |
M64 |
=IF(ISERROR(FontColor(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0)),TRUE))) |
- |
N64 |
=IF(M64="Red",H64,IF(M64="Green",I64,IF(M64="No
color","Lost",IF(M64<" ","-")))) |
- |
K65 |
=MAX(Player20!$AM$3:$AM$30) |
0 |
L65 |
=IF(ISERROR(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0))),"-",(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0)))) |
- |
M65 |
=IF(ISERROR(FontColor(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0)),TRUE))) |
- |
N65 |
=IF(M65="Red",H65,IF(M65="Green",I65,IF(M65="No
color","Lost",IF(M65<" ","-")))) |
- |
K66 |
=MAX(Player21!$AM$3:$AM$30) |
0 |
L66 |
=IF(ISERROR(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0))),"-",(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0)))) |
- |
M66 |
=IF(ISERROR(FontColor(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0)),TRUE))) |
- |
N66 |
=IF(M66="Red",H66,IF(M66="Green",I66,IF(M66="No
color","Lost",IF(M66<" ","-")))) |
- |
K67 |
=MAX(Player22!$AM$3:$AM$30) |
0 |
L67 |
=IF(ISERROR(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0))),"-",(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0)))) |
- |
M67 |
=IF(ISERROR(FontColor(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0)),TRUE))) |
- |
N67 |
=IF(M67="Red",H67,IF(M67="Green",I67,IF(M67="No
color","Lost",IF(M67<" ","-")))) |
- |
K68 |
=MAX(Player23!$AM$3:$AM$30) |
0 |
L68 |
=IF(ISERROR(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0))),"-",(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0)))) |
- |
M68 |
=IF(ISERROR(FontColor(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0)),TRUE))) |
- |
N68 |
=IF(M68="Red",H68,IF(M68="Green",I68,IF(M68="No
color","Lost",IF(M68<" ","-")))) |
- |
K69 |
=MAX(Player24!$AM$3:$AM$30) |
0 |
L69 |
=IF(ISERROR(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0))),"-",(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0)))) |
- |
M69 |
=IF(ISERROR(FontColor(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0)),TRUE))) |
- |
N69 |
=IF(M69="Red",H69,IF(M69="Green",I69,IF(M69="No
color","Lost",IF(M69<" ","-")))) |
- |
K70 |
=MAX(Player25!$AM$3:$AM$30) |
0 |
L70 |
=IF(ISERROR(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0))),"-",(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0)))) |
- |
M70 |
=IF(ISERROR(FontColor(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0)),TRUE))) |
- |
N70 |
=IF(M70="Red",H70,IF(M70="Green",I70,IF(M70="No
color","Lost",IF(M70<" ","-")))) |
- |
K71 |
=MAX(Player26!$AM$3:$AM$30) |
0 |
L71 |
=IF(ISERROR(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0))),"-",(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0)))) |
- |
M71 |
=IF(ISERROR(FontColor(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0)),TRUE))) |
- |
N71 |
=IF(M71="Red",H71,IF(M71="Green",I71,IF(M71="No
color","Lost",IF(M71<" ","-")))) |
- |
K72 |
=MAX(Player27!$AM$3:$AM$30) |
0 |
L72 |
=IF(ISERROR(INDEX(Player27!$AE$3:$AE$30,MATCH(MAX(Player27!$AN$3:$AN$30),Player27!$AN$3:$AN$30,0))),"-",(INDEX(Player27!$AE$3:$AE$30,MATCH(MAX(Player27!$AN$3:$AN$30),Player27!$AN$3:$AN$30,0)))) |
- |
M72 |
=IF(ISERROR(FontColor(INDEX(Player27!$AE$3:$AE$30,MATCH(MAX(Player27!$AN$3:$AN$30),Player27!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player27!$AE$3:$AE$30,MATCH(MAX(Player27!$AN$3:$AN$30),Player27!$AN$3:$AN$30,0)),TRUE))) |
- |
N72 |
=IF(M72="Red",H72,IF(M72="Green",I72,IF(M72="No
color","Lost",IF(M72<" ","-")))) |
- |
K73 |
=MAX(Player28!$AM$3:$AM$30) |
0 |
L73 |
=IF(ISERROR(INDEX(Player28!$AE$3:$AE$30,MATCH(MAX(Player28!$AN$3:$AN$30),Player28!$AN$3:$AN$30,0))),"-",(INDEX(Player28!$AE$3:$AE$30,MATCH(MAX(Player28!$AN$3:$AN$30),Player28!$AN$3:$AN$30,0)))) |
- |
M73 |
=IF(ISERROR(FontColor(INDEX(Player28!$AE$3:$AE$30,MATCH(MAX(Player28!$AN$3:$AN$30),Player28!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player28!$AE$3:$AE$30,MATCH(MAX(Player28!$AN$3:$AN$30),Player28!$AN$3:$AN$30,0)),TRUE))) |
- |
N73 |
=IF(M73="Red",H73,IF(M73="Green",I73,IF(M73="No
color","Lost",IF(M73<" ","-")))) |
- |
K74 |
=MAX(Player29!$AM$3:$AM$30) |
0 |
L74 |
=IF(ISERROR(INDEX(Player29!$AE$3:$AE$30,MATCH(MAX(Player29!$AN$3:$AN$30),Player29!$AN$3:$AN$30,0))),"-",(INDEX(Player29!$AE$3:$AE$30,MATCH(MAX(Player29!$AN$3:$AN$30),Player29!$AN$3:$AN$30,0)))) |
- |
M74 |
=IF(ISERROR(FontColor(INDEX(Player29!$AE$3:$AE$30,MATCH(MAX(Player29!$AN$3:$AN$30),Player29!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player29!$AE$3:$AE$30,MATCH(MAX(Player29!$AN$3:$AN$30),Player29!$AN$3:$AN$30,0)),TRUE))) |
- |
N74 |
=IF(M74="Red",H74,IF(M74="Green",I74,IF(M74="No
color","Lost",IF(M74<" ","-")))) |
- |
K75 |
=MAX(Player30!$AM$3:$AM$30) |
0 |
L75 |
=IF(ISERROR(INDEX(Player30!$AE$3:$AE$30,MATCH(MAX(Player30!$AN$3:$AN$30),Player30!$AN$3:$AN$30,0))),"-",(INDEX(Player30!$AE$3:$AE$30,MATCH(MAX(Player30!$AN$3:$AN$30),Player30!$AN$3:$AN$30,0)))) |
- |
M75 |
=IF(ISERROR(FontColor(INDEX(Player30!$AE$3:$AE$30,MATCH(MAX(Player30!$AN$3:$AN$30),Player30!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player30!$AE$3:$AE$30,MATCH(MAX(Player30!$AN$3:$AN$30),Player30!$AN$3:$AN$30,0)),TRUE))) |
- |
N75 |
=IF(M75="Red",H75,IF(M75="Green",I75,IF(M75="No
color","Lost",IF(M75<" ","-")))) |
- |
K76 |
=MAX(Player31!$AM$3:$AM$30) |
0 |
L76 |
=IF(ISERROR(INDEX(Player31!$AE$3:$AE$30,MATCH(MAX(Player31!$AN$3:$AN$30),Player31!$AN$3:$AN$30,0))),"-",(INDEX(Player31!$AE$3:$AE$30,MATCH(MAX(Player31!$AN$3:$AN$30),Player31!$AN$3:$AN$30,0)))) |
- |
M76 |
=IF(ISERROR(FontColor(INDEX(Player31!$AE$3:$AE$30,MATCH(MAX(Player31!$AN$3:$AN$30),Player31!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player31!$AE$3:$AE$30,MATCH(MAX(Player31!$AN$3:$AN$30),Player31!$AN$3:$AN$30,0)),TRUE))) |
- |
N76 |
=IF(M76="Red",H76,IF(M76="Green",I76,IF(M76="No
color","Lost",IF(M76<" ","-")))) |
- |
K77 |
=MAX(IF(L44:L75<>0,K44:K75)) |
43 |
L77 |
=VLOOKUP(K77,K45:L76,2,FALSE) |
12 |
M77 |
=VLOOKUP(K77,K45:M76,3,FALSE) |
Green |
N77 |
=VLOOKUP(L77,L45:N76,3,FALSE) |
Tom |
|
|
|