hrrl? |
=IF(S2="","u",LOOKUP(S2,HRRL_teams!B$2:B$584,HRRL_teams!C$2:C$584)) |
team nm? |
=IF(F2="h",LOOKUP(S2,HRRL_teams!B$2:B$584,HRRL_teams!D$2:D$584),"") |
|
|
f tm seq |
=IF(F6<>F5,"A",IF(AND(F6<>F2,F6=F3),"B","")) |
f tm sco |
=IF(H6="","",IF(AND(H7="",H8=""),SUM(G6:G8),IF(AND(H7="",H8<>""),SUM(G6:G7)+257,0))) |
f tm sta |
=IF(I2="","",IF(AND(I3="",I4=""),"c",IF(AND(I3="",I4<>""),"i","n"))) |
|
|
m tm seq |
=IF(F258<>F257,"A",IF(AND(F258<>F253,F258=F254),"B","")) |
m tm sco |
=IF(S197="","",IF(AND(S198="",S199="",S200=""),SUM(Q197:Q200),IF(AND(S198="",S199=""),SUM(Q197:Q199)+252,0))) |
m tm sta |
=IF(S168="","",IF(AND(S169="",S170="",S171=""),"c",IF(AND(S169="",S170=""),"i","n"))) |
|
|
cat |
=LOOKUP(V2,HRRL_cats!A$2:A$59,HRRL_cats!C$2:C$59) |
|
|
# hrrl f |
81 |
# hrrl m |
115 |
indiv sco |
=100*( |
|
|