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*(