{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SCORING","TEAMNAMES","HELP"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SCORING","index":0,"n_rows":101,"n_cols":52,"rows_kept":101,"cut":false,"hidden":false,"merged":[[16,26,17,26],[70,2,70,5],[70,6,70,9],[70,10,70,13],[70,14,70,17],[70,18,70,21],[70,22,70,25],[69,2,69,5],[69,6,69,9],[69,10,69,13],[69,14,69,17],[69,18,69,21],[69,22,69,25],[16,2,16,5],[16,6,16,9],[16,10,16,13],[16,14,16,17],[16,18,16,21],[16,22,16,25],[15,2,15,5],[15,6,15,9],[15,10,15,13],[15,14,15,17],[15,18,15,21],[15,22,15,25]]}
[null,null,null,null,null,"Thames Valley Junior League gala scoring spreadsheet"]
[]
[null,null,"Fill in the lane draw on the “TEAMNAMES” tab at the bottom.  You can only change cells with the fawn background."]
[null,null,"Enter only times:  mssdd or m.ss.dd - or m:ss.dd, or DQ, or NS (no swim).  When each line is filled it should add place, score and go green. Check placings agree with referee"]
[null,null,"Referee's decisions: where two have equal times but different places, add .001 second to slower placed team to keep order. Enter DQ reason (Start, Relay, Turn,Finish, Legs, Arms)"]
[null,null,"in the time box. At end, all red cells should have vanished. Send results to secretary@tvjl.org.uk (copy chairman@tvjl.org.uk please) by Tuesday after the meet at the latest, please."]
[]
[null,null,"Round",{"$f":"TEAMNAMES!B4","v":2},"Hosted at",null,{"$f":"TEAMNAMES!D4","v":"Reading"},null,"Date",null,{"$f":"TEAMNAMES!F4","v":"2008-01-14"}]
[]
["max pts",{"$f":"TEAMNAMES!B17","v":5}]
[null,null,null,"posn","total",null,null,"posn","total",null,null,"posn","total",null,null,"posn","total",null,null,"posn","total",null,null,"posn","total"]
["After 16 events",null,null,{"$f":"RANK(E12,$AF12:$AK12,0)","v":1},{"$f":"SUM(E$19:E34)","v":0},null,null,{"$f":"RANK(I12,$AF12:$AK12,0)","v":1},{"$f":"SUM(I$19:I34)","v":0},null,null,{"$f":"RANK(M12,$AF12:$AK12,0)","v":1},{"$f":"SUM(M$19:M34)","v":0},null,null,{"$f":"RANK(Q12,$AF12:$AK12,0)","v":1},{"$f":"SUM(Q$19:Q34)","v":0},null,null,{"$f":"RANK(U12,$AF12:$AK12,0)","v":1},{"$f":"SUM(U$19:U34)","v":0},null,null,{"$f":"RANK(Y12,$AF12:$AK12,0)","v":1},{"$f":"SUM(Y$19:Y34)","v":0},null,null,null,null,null,null,{"$f":"E12","v":0},{"$f":"I12","v":0},{"$f":"M12","v":0},{"$f":"Q12","v":0},{"$f":"U12","v":0},{"$f":"Y12","v":0}]
["After 32 events",null,null,{"$f":"RANK(E13,$AF13:$AK13,0)","v":1},{"$f":"SUM(E$19:E50)","v":0},null,null,{"$f":"RANK(I13,$AF13:$AK13,0)","v":1},{"$f":"SUM(I$19:I50)","v":0},null,null,{"$f":"RANK(M13,$AF13:$AK13,0)","v":1},{"$f":"SUM(M$19:M50)","v":0},null,null,{"$f":"RANK(Q13,$AF13:$AK13,0)","v":1},{"$f":"SUM(Q$19:Q50)","v":0},null,null,{"$f":"RANK(U13,$AF13:$AK13,0)","v":1},{"$f":"SUM(U$19:U50)","v":0},null,null,{"$f":"RANK(Y13,$AF13:$AK13,0)","v":1},{"$f":"SUM(Y$19:Y50)","v":0},null,null,null,null,null,null,{"$f":"E13","v":0},{"$f":"I13","v":0},{"$f":"M13","v":0},{"$f":"Q13","v":0},{"$f":"U13","v":0},{"$f":"Y13","v":0}]
["Current scores",null,null,{"$f":"RANK(E14,$AF14:$AK14,0)","v":1},{"$f":"SUM(E$19:E70)","v":0},null,null,{"$f":"RANK(I14,$AF14:$AK14,0)","v":1},{"$f":"SUM(I$19:I70)","v":0},null,null,{"$f":"RANK(M14,$AF14:$AK14,0)","v":1},{"$f":"SUM(M$19:M70)","v":0},null,null,{"$f":"RANK(Q14,$AF14:$AK14,0)","v":1},{"$f":"SUM(Q$19:Q70)","v":0},null,null,{"$f":"RANK(U14,$AF14:$AK14,0)","v":1},{"$f":"SUM(U$19:U70)","v":0},null,null,{"$f":"RANK(Y14,$AF14:$AK14,0)","v":1},{"$f":"SUM(Y$19:Y70)","v":0},null,null,null,null,null,null,{"$f":"E14","v":0},{"$f":"I14","v":0},{"$f":"M14","v":0},{"$f":"Q14","v":0},{"$f":"U14","v":0},{"$f":"Y14","v":0}]
[]
[null,null,{"$f":"TEAMNAMES!B7","v":"Team 1"},null,null,null,{"$f":"TEAMNAMES!B8","v":"Team 2"},null,null,null,{"$f":"TEAMNAMES!B9","v":"Team 3"},null,null,null,{"$f":"TEAMNAMES!B10","v":"Team 4"},null,null,null,{"$f":"TEAMNAMES!B11","v":"Team 5"},null,null,null,{"$f":"TEAMNAMES!B12","v":"Team 6"}]
[null,null,{"$f":"TEAMNAMES!A7","v":"Lane 1"},null,null,null,{"$f":"TEAMNAMES!A8","v":"Lane 2"},null,null,null,{"$f":"TEAMNAMES!A9","v":"Lane 3"},null,null,null,{"$f":"TEAMNAMES!A10","v":"Lane 4"},null,null,null,{"$f":"TEAMNAMES!A11","v":"Lane 5"},null,null,null,{"$f":"TEAMNAMES!A12","v":"Lane 6"},null,null,null,"Verify Placing",null,null,{"$f":"TEAMNAMES!B19","v":15},null,null,"--- work area --- race times / dq ---",null,null,null,null,null,null,"--- work are --- positions ---",null,null,null,null,null,null,"-- position of lane --"]
["#","Event","time","posn","pts","chk","time","posn","pts","chk","time","posn","pts","chk","time","posn","pts","chk","time","posn","pts","chk","time","posn","pts","chk",null,"DQs","DQ pts","check",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6]
[1,"12 year girls medley relay","NS",{"$f":"IF(ISNUMBER(AF19),RANK(C19,$AF19:$AK19,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AF19),$B$10+1-(D19+(COUNTIF($AN19:$AS19,\"=\"&AN19)-1)/2),0)","v":0},{"$f":"IF(AF19=0,IF(C19=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG19),RANK(G19,$AF19:$AK19,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AG19),$B$10+1-(H19+(COUNTIF($AN19:$AS19,\"=\"&AO19)-1)/2),0)","v":0},{"$f":"IF(AG19=0,IF(G19=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH19),RANK(K19,$AF19:$AK19,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AH19),$B$10+1-(L19+(COUNTIF($AN19:$AS19,\"=\"&AP19)-1)/2),0)","v":0},{"$f":"IF(AH19=0,IF(K19=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI19),RANK(O19,$AF19:$AK19,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AI19),$B$10+1-(P19+(COUNTIF($AN19:$AS19,\"=\"&AQ19)-1)/2),0)","v":0},{"$f":"IF(AI19=0,IF(O19=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ19),RANK(S19,$AF19:$AK19,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AJ19),$B$10+1-(T19+(COUNTIF($AN19:$AS19,\"=\"&AR19)-1)/2),0)","v":0},{"$f":"IF(AJ19=0,IF(S19=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK19),RANK(W19,$AF19:$AK19,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AK19),$B$10+1-(X19+(COUNTIF($AN19:$AS19,\"=\"&AS19)-1)/2),0)","v":0},{"$f":"IF(AK19=0,IF(W19=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},{"$f":"AU19&AV19&AW19&AX19&AY19&AZ19","v":""},{"$f":"$B$10-COUNTIF($AF19:$AK19,\">0\")","v":5},{"$f":"(1+AB19)*AB19/2","v":15},{"$f":"E19+I19+M19+Q19+U19+Y19+AC19","v":15},null,{"$f":"IF(ISNUMBER(C19),C19,\"\")","v":""},{"$f":"IF(ISNUMBER(G19),G19,\"\")","v":""},{"$f":"IF(ISNUMBER(K19),K19,\"\")","v":""},{"$f":"IF(ISNUMBER(O19),O19,\"\")","v":""},{"$f":"IF(ISNUMBER(S19),S19,\"\")","v":""},{"$f":"IF(ISNUMBER(W19),W19,\"\")","v":""},null,null,{"$f":"IF(OR(AF19=0,AF19=\"\"),0,RANK(AF19,$AF19:$AK19,1))","v":0},{"$f":"IF(OR(AG19=0,AG19=\"\"),0,RANK(AG19,$AF19:$AK19,1))","v":0},{"$f":"IF(OR(AH19=0,AH19=\"\"),0,RANK(AH19,$AF19:$AK19,1))","v":0},{"$f":"IF(OR(AI19=0,AI19=\"\"),0,RANK(AI19,$AF19:$AK19,1))","v":0},{"$f":"IF(OR(AJ19=0,AJ19=\"\"),0,RANK(AJ19,$AF19:$AK19,1))","v":0},{"$f":"IF(OR(AK19=0,AK19=\"\"),0,RANK(AK19,$AF19:$AK19,1))","v":0},null,{"$f":"IF(ISNA(MATCH(1, $AN19:$AS19,0)),\"\",MATCH(1, $AN19:$AS19, 0))","v":""},{"$f":"IF(ISNA(MATCH(2, $AN19:$AS19,0)),\"\",MATCH(2, $AN19:$AS19, 0))","v":""},{"$f":"IF(ISNA(MATCH(3, $AN19:$AS19,0)),\"\",MATCH(3, $AN19:$AS19, 0))","v":""},{"$f":"IF(ISNA(MATCH(4, $AN19:$AS19,0)),\"\",MATCH(4, $AN19:$AS19, 0))","v":""},{"$f":"IF(ISNA(MATCH(5, $AN19:$AS19,0)),\"\",MATCH(5, $AN19:$AS19, 0))","v":""},{"$f":"IF(ISNA(MATCH(6, $AN19:$AS19,0)),\"\",MATCH(6, $AN19:$AS19, 0))","v":""}]
[2,"12 year boys medley relay","NS",{"$f":"IF(ISNUMBER(AF20),RANK(C20,$AF20:$AK20,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AF20),$B$10+1-(D20+(COUNTIF($AN20:$AS20,\"=\"&AN20)-1)/2),0)","v":0},{"$f":"IF(AF20=0,IF(C20=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG20),RANK(G20,$AF20:$AK20,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AG20),$B$10+1-(H20+(COUNTIF($AN20:$AS20,\"=\"&AO20)-1)/2),0)","v":0},{"$f":"IF(AG20=0,IF(G20=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH20),RANK(K20,$AF20:$AK20,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AH20),$B$10+1-(L20+(COUNTIF($AN20:$AS20,\"=\"&AP20)-1)/2),0)","v":0},{"$f":"IF(AH20=0,IF(K20=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI20),RANK(O20,$AF20:$AK20,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AI20),$B$10+1-(P20+(COUNTIF($AN20:$AS20,\"=\"&AQ20)-1)/2),0)","v":0},{"$f":"IF(AI20=0,IF(O20=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ20),RANK(S20,$AF20:$AK20,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AJ20),$B$10+1-(T20+(COUNTIF($AN20:$AS20,\"=\"&AR20)-1)/2),0)","v":0},{"$f":"IF(AJ20=0,IF(S20=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK20),RANK(W20,$AF20:$AK20,1),\"\")","v":""},{"$f":"IF(ISNUMBER(AK20),$B$10+1-(X20+(COUNTIF($AN20:$AS20,\"=\"&AS20)-1)/2),0)","v":0},{"$f":"IF(AK20=0,IF(W20=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},{"$f":"AU20&AV20&AW20&AX20&AY20&AZ20","v":""},5,{"$f":"(1+AB20)*AB20/2","v":15},{"$f":"E20+I20+M20+Q20+U20+Y20+AC20","v":15},null,{"$f":"IF(ISNUMBER(C20),C20,\"\")","v":""},{"$f":"IF(ISNUMBER(G20),G20,\"\")","v":""},{"$f":"IF(ISNUMBER(K20),K20,\"\")","v":""},{"$f":"IF(ISNUMBER(O20),O20,\"\")","v":""},{"$f":"IF(ISNUMBER(S20),S20,\"\")","v":""},{"$f":"IF(ISNUMBER(W20),W20,\"\")","v":""},null,null,0,{"$f":"IF(OR(AG20=0,AG20=\"\"),0,RANK(AG20,$AF20:$AK20,1))","v":0},{"$f":"IF(OR(AH20=0,AH20=\"\"),0,RANK(AH20,$AF20:$AK20,1))","v":0},{"$f":"IF(OR(AI20=0,AI20=\"\"),0,RANK(AI20,$AF20:$AK20,1))","v":0},{"$f":"IF(OR(AJ20=0,AJ20=\"\"),0,RANK(AJ20,$AF20:$AK20,1))","v":0},{"$f":"IF(OR(AK20=0,AK20=\"\"),0,RANK(AK20,$AF20:$AK20,1))","v":0},null,{"$f":"IF(ISNA(MATCH(1, $AN20:$AS20,0)),\"\",MATCH(1, $AN20:$AS20, 0))","v":""},{"$f":"IF(ISNA(MATCH(2, $AN20:$AS20,0)),\"\",MATCH(2, $AN20:$AS20, 0))","v":""},{"$f":"IF(ISNA(MATCH(3, $AN20:$AS20,0)),\"\",MATCH(3, $AN20:$AS20, 0))","v":""},{"$f":"IF(ISNA(MATCH(4, $AN20:$AS20,0)),\"\",MATCH(4, $AN20:$AS20, 0))","v":""},{"$f":"IF(ISNA(MATCH(5, $AN20:$AS20,0)),\"\",MATCH(5, $AN20:$AS20, 0))","v":""},{"$f":"IF(ISNA(MATCH(6, $AN20:$AS20,0)),\"\",MATCH(6, $AN20:$AS20, 0))","v":""}]
[3,"9 year girls medley relay","NS",{"$f":"IF(ISNUMBER(AF21),RANK(C21,$AF21:$AK21,1),\"\")","v":""},0,{"$f":"IF(AF21=0,IF(C21=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG21),RANK(G21,$AF21:$AK21,1),\"\")","v":""},0,{"$f":"IF(AG21=0,IF(G21=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH21),RANK(K21,$AF21:$AK21,1),\"\")","v":""},0,{"$f":"IF(AH21=0,IF(K21=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI21),RANK(O21,$AF21:$AK21,1),\"\")","v":""},0,{"$f":"IF(AI21=0,IF(O21=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ21),RANK(S21,$AF21:$AK21,1),\"\")","v":""},0,{"$f":"IF(AJ21=0,IF(S21=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK21),RANK(W21,$AF21:$AK21,1),\"\")","v":""},0,{"$f":"IF(AK21=0,IF(W21=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"",5,{"$f":"(1+AB21)*AB21/2","v":15},{"$f":"E21+I21+M21+Q21+U21+Y21+AC21","v":15},null,{"$f":"IF(ISNUMBER(C21),C21,\"\")","v":""},{"$f":"IF(ISNUMBER(G21),G21,\"\")","v":""},{"$f":"IF(ISNUMBER(K21),K21,\"\")","v":""},{"$f":"IF(ISNUMBER(O21),O21,\"\")","v":""},{"$f":"IF(ISNUMBER(S21),S21,\"\")","v":""},{"$f":"IF(ISNUMBER(W21),W21,\"\")","v":""},null,null,{"$f":"IF(OR(AF21=0,AF21=\"\"),0,RANK(AF21,$AF21:$AK21,1))","v":0},0,0,0,0,0,null,"","","","","",""]
[4,"9 year boys medley relay","NS",{"$f":"IF(ISNUMBER(AF22),RANK(C22,$AF22:$AK22,1),\"\")","v":""},0,{"$f":"IF(AF22=0,IF(C22=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG22),RANK(G22,$AF22:$AK22,1),\"\")","v":""},0,{"$f":"IF(AG22=0,IF(G22=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH22),RANK(K22,$AF22:$AK22,1),\"\")","v":""},0,{"$f":"IF(AH22=0,IF(K22=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI22),RANK(O22,$AF22:$AK22,1),\"\")","v":""},0,{"$f":"IF(AI22=0,IF(O22=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ22),RANK(S22,$AF22:$AK22,1),\"\")","v":""},0,{"$f":"IF(AJ22=0,IF(S22=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK22),RANK(W22,$AF22:$AK22,1),\"\")","v":""},0,{"$f":"IF(AK22=0,IF(W22=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"",5,{"$f":"(1+AB22)*AB22/2","v":15},{"$f":"E22+I22+M22+Q22+U22+Y22+AC22","v":15},null,{"$f":"IF(ISNUMBER(C22),C22,\"\")","v":""},{"$f":"IF(ISNUMBER(G22),G22,\"\")","v":""},{"$f":"IF(ISNUMBER(K22),K22,\"\")","v":""},{"$f":"IF(ISNUMBER(O22),O22,\"\")","v":""},{"$f":"IF(ISNUMBER(S22),S22,\"\")","v":""},{"$f":"IF(ISNUMBER(W22),W22,\"\")","v":""},null,null,0,0,0,0,0,0,null,"","","","","",""]
[5,"10 year girls medley relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[6,"10 year boys medley relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[7,"11 year girls medley relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[8,"11 year boys medley relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[9,"9 year girls 25m back","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[10,"9 year boys 25m back","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[11,"10 year girls 50m breast","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[12,"10 year boys 50m breast","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[13,"11 year girls 50m fly","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[14,"11 year boys 50m fly","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[15,"12 year girls 50m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[16,"12 year boys 50m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[17,"9 year girls 25m breast","NS",{"$f":"IF(ISNUMBER(AF35),RANK(C35,$AF35:$AK35,1),\"\")","v":""},0,{"$f":"IF(AF35=0,IF(C35=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG35),RANK(G35,$AF35:$AK35,1),\"\")","v":""},0,{"$f":"IF(AG35=0,IF(G35=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH35),RANK(K35,$AF35:$AK35,1),\"\")","v":""},0,{"$f":"IF(AH35=0,IF(K35=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI35),RANK(O35,$AF35:$AK35,1),\"\")","v":""},0,{"$f":"IF(AI35=0,IF(O35=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ35),RANK(S35,$AF35:$AK35,1),\"\")","v":""},0,{"$f":"IF(AJ35=0,IF(S35=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK35),RANK(W35,$AF35:$AK35,1),\"\")","v":""},0,{"$f":"IF(AK35=0,IF(W35=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"",5,{"$f":"(1+AB35)*AB35/2","v":15},{"$f":"E35+I35+M35+Q35+U35+Y35+AC35","v":15},null,{"$f":"IF(ISNUMBER(C35),C35,\"\")","v":""},{"$f":"IF(ISNUMBER(G35),G35,\"\")","v":""},{"$f":"IF(ISNUMBER(K35),K35,\"\")","v":""},{"$f":"IF(ISNUMBER(O35),O35,\"\")","v":""},{"$f":"IF(ISNUMBER(S35),S35,\"\")","v":""},{"$f":"IF(ISNUMBER(W35),W35,\"\")","v":""},null,null,{"$f":"IF(OR(AF35=0,AF35=\"\"),0,RANK(AF35,$AF35:$AK35,1))","v":0},0,0,0,0,0,null,"","","","","",""]
[18,"9 year boys 25m breast","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[19,"10 year girls 50m fly","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[20,"10 year boys 50m fly","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[21,"11 year girls 50m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[22,"11 year boys 50m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[23,"12 year girls 50m back","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[24,"12 year boys 50m back","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[25,"9 year girls 25m fly","NS",{"$f":"IF(ISNUMBER(AF43),RANK(C43,$AF43:$AK43,1),\"\")","v":""},0,{"$f":"IF(AF43=0,IF(C43=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG43),RANK(G43,$AF43:$AK43,1),\"\")","v":""},0,{"$f":"IF(AG43=0,IF(G43=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH43),RANK(K43,$AF43:$AK43,1),\"\")","v":""},0,{"$f":"IF(AH43=0,IF(K43=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI43),RANK(O43,$AF43:$AK43,1),\"\")","v":""},0,{"$f":"IF(AI43=0,IF(O43=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ43),RANK(S43,$AF43:$AK43,1),\"\")","v":""},0,{"$f":"IF(AJ43=0,IF(S43=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK43),RANK(W43,$AF43:$AK43,1),\"\")","v":""},0,{"$f":"IF(AK43=0,IF(W43=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"",5,{"$f":"(1+AB43)*AB43/2","v":15},{"$f":"E43+I43+M43+Q43+U43+Y43+AC43","v":15},null,{"$f":"IF(ISNUMBER(C43),C43,\"\")","v":""},{"$f":"IF(ISNUMBER(G43),G43,\"\")","v":""},{"$f":"IF(ISNUMBER(K43),K43,\"\")","v":""},{"$f":"IF(ISNUMBER(O43),O43,\"\")","v":""},{"$f":"IF(ISNUMBER(S43),S43,\"\")","v":""},{"$f":"IF(ISNUMBER(W43),W43,\"\")","v":""},null,null,{"$f":"IF(OR(AF43=0,AF43=\"\"),0,RANK(AF43,$AF43:$AK43,1))","v":0},0,0,0,0,0,null,"","","","","",""]
[26,"9 year boys 25m fly","NS",{"$f":"IF(ISNUMBER(AF44),RANK(C44,$AF44:$AK44,1),\"\")","v":""},0,{"$f":"IF(AF44=0,IF(C44=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG44),RANK(G44,$AF44:$AK44,1),\"\")","v":""},0,{"$f":"IF(AG44=0,IF(G44=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH44),RANK(K44,$AF44:$AK44,1),\"\")","v":""},0,{"$f":"IF(AH44=0,IF(K44=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI44),RANK(O44,$AF44:$AK44,1),\"\")","v":""},0,{"$f":"IF(AI44=0,IF(O44=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ44),RANK(S44,$AF44:$AK44,1),\"\")","v":""},0,{"$f":"IF(AJ44=0,IF(S44=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK44),RANK(W44,$AF44:$AK44,1),\"\")","v":""},0,{"$f":"IF(AK44=0,IF(W44=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"",5,{"$f":"(1+AB44)*AB44/2","v":15},{"$f":"E44+I44+M44+Q44+U44+Y44+AC44","v":15},null,{"$f":"IF(ISNUMBER(C44),C44,\"\")","v":""},{"$f":"IF(ISNUMBER(G44),G44,\"\")","v":""},{"$f":"IF(ISNUMBER(K44),K44,\"\")","v":""},{"$f":"IF(ISNUMBER(O44),O44,\"\")","v":""},{"$f":"IF(ISNUMBER(S44),S44,\"\")","v":""},{"$f":"IF(ISNUMBER(W44),W44,\"\")","v":""},null,null,0,0,0,0,0,0,null,"","","","","",""]
[27,"10 year girls 50m back","NS",{"$f":"IF(ISNUMBER(AF45),RANK(C45,$AF45:$AK45,1),\"\")","v":""},0,{"$f":"IF(AF45=0,IF(C45=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AG45),RANK(G45,$AF45:$AK45,1),\"\")","v":""},0,{"$f":"IF(AG45=0,IF(G45=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AH45),RANK(K45,$AF45:$AK45,1),\"\")","v":""},0,{"$f":"IF(AH45=0,IF(K45=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AI45),RANK(O45,$AF45:$AK45,1),\"\")","v":""},0,{"$f":"IF(AI45=0,IF(O45=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AJ45),RANK(S45,$AF45:$AK45,1),\"\")","v":""},0,{"$f":"IF(AJ45=0,IF(S45=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"NS",{"$f":"IF(ISNUMBER(AK45),RANK(W45,$AF45:$AK45,1),\"\")","v":""},0,{"$f":"IF(AK45=0,IF(W45=\"NS\",\"NS\",\"err\"),\"ok\")","v":"ok"},"",5,{"$f":"(1+AB45)*AB45/2","v":15},{"$f":"E45+I45+M45+Q45+U45+Y45+AC45","v":15},null,{"$f":"IF(ISNUMBER(C45),C45,\"\")","v":""},{"$f":"IF(ISNUMBER(G45),G45,\"\")","v":""},{"$f":"IF(ISNUMBER(K45),K45,\"\")","v":""},{"$f":"IF(ISNUMBER(O45),O45,\"\")","v":""},{"$f":"IF(ISNUMBER(S45),S45,\"\")","v":""},{"$f":"IF(ISNUMBER(W45),W45,\"\")","v":""},null,null,0,0,0,0,0,0,null,"","","","","",""]
[28,"10 year boys 50m back","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[29,"11 year girls 50m breast","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[30,"11 year boys 50m breast","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[31,"12 year girls 50 fly","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[32,"12 year boys 50 fly","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[33,"9 year girls 25m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[34,"9 year boys 25m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[35,"10 year girls 50m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[36,"10 year boys 50m free","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[37,"11 year girls 50m back","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[38,"11 year boys 50m back","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[39,"12 year girls 50m breast","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[40,"12 year boys 50m breast","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[41,"9 year girls freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[42,"9 year boys freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[43,"10 year girls freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[44,"10 year boys freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[45,"11 year girls freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[46,"11 year boys freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[47,"12 year girls freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[48,"12 year boys freestyle relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[49,"8 x 25 squadron relay","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","NS","",0,"ok","",5,15,15,null,"","","","","","",null,null,0,0,0,0,0,0,null,"","","","","",""]
[]
[]
["TOTALS",null,{"$f":"C16","v":"Team 1"},null,null,null,{"$f":"G16","v":"Team 2"},null,null,null,{"$f":"K16","v":"Team 3"},null,null,null,{"$f":"O16","v":"Team 4"},null,null,null,{"$f":"S16","v":"Team 5"},null,null,null,{"$f":"W16","v":"Team 6"}]
[null,null,{"$f":"C17","v":"Lane 1"},null,null,null,{"$f":"G17","v":"Lane 2"},null,null,null,{"$f":"K17","v":"Lane 3"},null,null,null,{"$f":"O17","v":"Lane 4"},null,null,null,{"$f":"S17","v":"Lane 5"},null,null,null,{"$f":"W17","v":"Lane 6"},null,null,null,null,"DQ pts",null,{"$f":"SUM(AD19:AD67)","v":735}]
[]
[null,"TOTAL PTS",null,{"$f":"SUM(E19:E67)","v":0},null,null,null,{"$f":"SUM(I19:I67)","v":0},null,null,null,{"$f":"SUM(M19:M67)","v":0},null,null,null,{"$f":"SUM(Q19:Q67)","v":0},null,null,null,{"$f":"SUM(U19:U67)","v":0},null,null,null,{"$f":"SUM(Y19:Y67)","v":0},null,null,null,{"$f":"SUM(AC19:AC67)","v":735},">",{"$f":"SUM(D73:AC73)","v":735}]
[null,"OVERALL POSN",null,{"$f":"RANK(D73,$D73:$X73)","v":1},null,null,null,{"$f":"RANK(H73,$D73:$X73)","v":1},null,null,null,{"$f":"RANK(L73,$D73:$X73)","v":1},null,null,null,{"$f":"RANK(P73,$D73:$X73)","v":1},null,null,null,{"$f":"RANK(T73,$D73:$X73)","v":1},null,null,null,{"$f":"RANK(X73,$D73:$X73)","v":1}]
[]
[null,"TOTAL POSN",1,{"$f":"COUNTIF(D$19:D$73,$C76)","v":0},null,null,null,{"$f":"COUNTIF(H$19:H$73,$C76)","v":0},null,null,null,{"$f":"COUNTIF(L$19:L$73,$C76)","v":0},null,null,null,{"$f":"COUNTIF(P$19:P$73,$C76)","v":0},null,null,null,{"$f":"COUNTIF(T$19:T$73,$C76)","v":0},null,null,null,{"$f":"COUNTIF(X$19:X$73,$C76)","v":0},null,null,null,null,null,{"$f":"SUM(D76:AC76)","v":0}]
[null,"TOTAL POSN",2,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,0]
[null,"TOTAL POSN",3,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,0]
[null,"TOTAL POSN",4,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,0]
[null,"TOTAL POSN",5,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,0]
[null,"TOTAL POSN",6,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,0]
[null,"TOTAL","DQ",{"$f":"COUNTIF(E$19:E$73,0)","v":49},null,null,"`",{"$f":"COUNTIF(I$19:I$73,0)","v":49},null,null,null,{"$f":"COUNTIF(M$19:M$73,0)","v":49},null,null,null,{"$f":"COUNTIF(Q$19:Q$73,0)","v":49},null,null,null,{"$f":"COUNTIF(U$19:U$73,0)","v":49},null,null,null,{"$f":"COUNTIF(Y$19:Y$73,0)","v":49},null,null,null,null,null,294]
[]
[null,"TOTAL","NS",{"$f":"COUNTIF(C$19:C$73,$C84)","v":49},null,null,null,{"$f":"COUNTIF(G$19:G$73,$C84)","v":49},null,null,null,{"$f":"COUNTIF(K$19:K$73,$C84)","v":49},null,null,null,{"$f":"COUNTIF(O$19:O$73,$C84)","v":49},null,null,null,{"$f":"COUNTIF(S$19:S$73,$C84)","v":49},null,null,null,{"$f":"COUNTIF(W$19:W$73,$C84)","v":49},null,null,null,null,null,{"$f":"SUM(D84:AC84)","v":294}]
[null,"TOTAL  ","SWUM",{"$f":"49-D84","v":0},null,null,null,{"$f":"49-H84","v":0},null,null,null,{"$f":"49-L84","v":0},null,null,null,{"$f":"49-P84","v":0},null,null,null,{"$f":"49-T84","v":0},null,null,null,{"$f":"49-X84","v":0},"Red if less than 15 events swum"]
[]
[null,"Total events",null,{"$f":"SUM(D76:D82)","v":49},null,null,null,{"$f":"SUM(H76:H82)","v":49},null,null,null,{"$f":"SUM(L76:L82)","v":49},null,null,null,{"$f":"SUM(P76:P82)","v":49},null,null,null,{"$f":"SUM(T76:T82)","v":49},null,null,null,{"$f":"SUM(X76:X82)","v":49},null,null,null,null,null,{"$f":"SUM(AD76:AD82)","v":294}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD87/$B$10","v":58.8}]
[]
[]
[]
[]
[null,null,"time entry field"]
[null,null,"accepts:"]
[null,null,"46"]
[null,null,"46.0"]
[null,null,"46:0"]
[null,null,"10045"]
[null,null,"1:00.45"]
[null,null,"1.00.45"]
[null,null,"provided macros have been enabled when you opened the sheet"]

{"sheet":"TEAMNAMES","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Configure team names etc here, then switch back to the SCORING tab"]
[]
["TVJL Round Number:",2,"Hosted by","Reading","on (date)","2008-01-14"]
[]
["Lane Number","Team Name"]
["Lane 1","Team 1"]
["Lane 2","Team 2"]
["Lane 3","Team 3"]
["Lane 4","Team 4"]
["Lane 5","Team 5"]
["Lane 6","Team 6"]
["Lane 7"]
["Lane 8"]
[]
[]
["Number of teams",5]
[]
["So total points per event are",{"$f":"(1+B17)*B17/2","v":15}]
["and per gala are",{"$f":"49*B19","v":735}]

{"sheet":"HELP","index":2,"n_rows":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["GETTING STARTED"]
[]
["Normally, you can only type into the light-brown coloured boxes."]
[]
["MAKE SURE Macros are ENABLED otherwise time input will result in 00:00.00. See scoring races, below."]
[]
["Start with entering the Team names in column B on the TEAMNAMES tab."]
[]
["You also enter the venue and the date."]
[]
["This will place the team names into the SCORING spreadsheet."]
[]
["Usually, the lanes are numbered 1-6; If this is not the case, change the lane numbers in Column A. (affects the finishing number)"]
[]
["When you have done this, switch to the SCORING tab, and check the teams are in the correct columns/lanes."]
[]
["SCORING RACES"]
[]
["If you are not using lanes 1-6, you can change the lane numbers on the scoring sheet."]
[]
["When you are scoring a race, you should only need to enter the times."]
[]
["The system with accept a time in the form mssdd (eg 12345), m.ss.dd (1.23.45) or m:ss.dd (1:23.45) - all these enter a time of one minute 23.45 seconds."]
[]
["You will find it easier to use the first two forms because of the location of the \":\" symbol."]
[]
["For sub-minute times, the system will also accept 2345 and 23.45."]
[]
["If you find that entering almost anything gets you \"00:00.00\" or a date, check your macro settings are correct: File, Options (usually bottom left), Trust Center, Trust Center Settings, Macro Settings, check Disable All Macros with notification, and reload the scoring spreadsheet."]
[]
[]
["ENTERING TIMES"]
[]
["Enter the times only.  Do not enter the placing.  "]
[]
["VERIFY the placings the computer has calculated against the score sheet. They should match."]
[]
["If they disagree, check your input - if the scoring slip is wrong, check with the referee."]
[]
["If the referee has awarded equal times but different placing, add 0.001 seconds to the later place, so that the system will order the races correctly."]
[]
["DQs are denoted as \"DQ\" or \"NS\" (no swimmer).  Add a reason eg DQ Overage, DQ Legs, DQ takeover, DQ Arms, DQ Start."]
[]
[]
["ADVANCED ISSUES"]
[]
["The spreadsheet has been protected so that you can only type in the relevant fields.  This is to save you accidentally deleting a formula or formatting."]
[]
["If you need to unprotect the sheet, use FILE > UNPROTECT SHEET - the password is the 4 lower case characters  tvjl"]
[]
["If you need to do this, please add a note when you return the scoresheet so that we can improve it."]
[]
["Of course, any other suggestions on improvments are welcome."]
[]
[]
["COLOURED BOXES"]
[]
[null," This contains the placng order calculated from the times input; Check this is the same as the results slip from the referee."]
[]
[null,"These are cells that you will need to complete."]