{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["allotted times 1 trial","Entries","Single Trial Calculator","Double Trial Calculator","Judge List","Formulas","allotted times 2 trials"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"allotted times 1 trial","index":0,"n_rows":9,"n_cols":22,"rows_kept":9,"hidden":true}
["Setup/Admin",120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120]
["courses",17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17]
["Nov",3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["Adv",4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
["Exc",5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["Exc Int",7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5]
["Mas",6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6]
["Mas Int",10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
["Det",15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15]

{"sheet":"Entries","index":1,"n_rows":53,"n_cols":105,"rows_kept":53,"merged":[[1,0,26,0],[1,1,26,1],[27,0,52,0],[27,1,52,1]]}
[{"$nulls":3},"Judge","Class Totals",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100]
["Trial  1- ","2019XXXXXX","Container Novice A",null,{"$f":"SUM(F2:DA2)","v":1},1]
[null,null,"Container Novice B",null,{"$f":"SUM(F3:DA3)","v":1},1]
[null,null,"Container Advanced",null,1,1]
[null,null,"Container Excellent",null,1,1]
[null,null,"Container Master",null,1,1]
[null,null,"Interior Novice A",null,1,1]
[null,null,"Interior Novice B",null,1,1]
[null,null,"Interior Advanced",null,1,1]
[null,null,"Interior Exc.",null,{"$f":"SUM(F10:DA10)","v":1},1]
[null,null,"Interior Mas.",null,{"$f":"SUM(F11:DA11)","v":1},1]
[null,null,"Exterior Novice A",null,{"$f":"SUM(F12:DA12)","v":1},1]
[null,null,"Exterior Novice B",null,{"$f":"SUM(F13:DA13)","v":1},1]
[null,null,"Exterior Advanced",null,{"$f":"SUM(F14:DA14)","v":1},1]
[null,null,"Exterior Excellent",null,{"$f":"SUM(F15:DA15)","v":1},1]
[null,null,"Exterior Master",null,{"$f":"SUM(F16:DA16)","v":1},1]
[null,null,"Buried Novice A",null,{"$f":"SUM(F17:DA17)","v":1},1]
[null,null,"Buried Novice B",null,{"$f":"SUM(F18:DA18)","v":1},1]
[null,null,"Buried Advanced",null,{"$f":"SUM(F19:DA19)","v":1},1]
[null,null,"Buried Excellent",null,{"$f":"SUM(F20:DA20)","v":1},1]
[null,null,"Buried Master",null,{"$f":"SUM(F21:DA21)","v":1},1]
[null,null,"Handler Disc. Novice A",null,{"$f":"SUM(F22:DA22)","v":1},1]
[null,null,"Handler Disc. Novice B",null,{"$f":"SUM(F23:DA23)","v":1},1]
[null,null,"Handler Disc. Advanced",null,{"$f":"SUM(F24:DA24)","v":1},1]
[null,null,"Handler Disc. Excellent",null,{"$f":"SUM(F25:DA25)","v":1},1]
[null,null,"Handler Disc. Master",null,{"$f":"SUM(F26:DA26)","v":1},1]
[null,null,"The Detective Class",null,{"$f":"SUM(F27:DA27)","v":1},1]
["Trial 2- ","2019XXXXXX","Container Novice A",null,{"$f":"SUM(F28:DA28)","v":1},1]
[null,null,"Container Novice B",null,{"$f":"SUM(F29:DA29)","v":1},1]
[null,null,"Container Advanced",null,{"$f":"SUM(F30:DA30)","v":1},1]
[null,null,"Container Excellent",null,{"$f":"SUM(F31:DA31)","v":1},1]
[null,null,"Container Master",null,{"$f":"SUM(F32:DA32)","v":1},1]
[null,null,"Interior Novice A",null,{"$f":"SUM(F33:DA33)","v":1},1]
[null,null,"Interior Novice B",null,{"$f":"SUM(F34:DA34)","v":1},1]
[null,null,"Interior Advanced",null,{"$f":"SUM(F35:DA35)","v":1},1]
[null,null,"Interior Exc.",null,{"$f":"SUM(F36:DA36)","v":1},1]
[null,null,"Interior Mas.",null,{"$f":"SUM(F37:DA37)","v":1},1]
[null,null,"Exterior Novice A",null,{"$f":"SUM(F38:DA38)","v":1},1]
[null,null,"Exterior Novice B",null,{"$f":"SUM(F39:DA39)","v":1},1]
[null,null,"Exterior Advanced",null,{"$f":"SUM(F40:DA40)","v":1},1]
[null,null,"Exterior Excellent",null,{"$f":"SUM(F41:DA41)","v":1},1]
[null,null,"Exterior Master",null,{"$f":"SUM(F42:DA42)","v":1},1]
[null,null,"Buried Novice A",null,{"$f":"SUM(F43:DA43)","v":1},1]
[null,null,"Buried Novice B",null,{"$f":"SUM(F44:DA44)","v":1},1]
[null,null,"Buried Advanced",null,{"$f":"SUM(F45:DA45)","v":1},1]
[null,null,"Buried Excellent",null,{"$f":"SUM(F46:DA46)","v":1},1]
[null,null,"Buried Master",null,{"$f":"SUM(F47:DA47)","v":1},1]
[null,null,"Handler Disc. Novice A",null,{"$f":"SUM(F48:DA48)","v":1},1]
[null,null,"Handler Disc. Novice B",null,{"$f":"SUM(F49:DA49)","v":1},1]
[null,null,"Handler Disc. Advanced",null,{"$f":"SUM(F50:DA50)","v":1},1]
[null,null,"Handler Disc. Excellent",null,{"$f":"SUM(F51:DA51)","v":1},1]
[null,null,"Handler Disc. Master",null,{"$f":"SUM(F52:DA52)","v":1},1]
[null,null,"The Detective Class",null,{"$f":"SUM(F53:DA53)","v":1},1]

{"sheet":"Single Trial Calculator","index":2,"n_rows":19,"n_cols":19,"rows_kept":19,"merged":[[1,4,1,5],[1,7,1,8],[1,9,1,16],[2,0,16,0],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,15],[4,16,4,17],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[15,18,16,18],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17]]}
[]
[{"$nulls":3},"Date:",{"$nulls":3},"Club Name:"]
[{"$f":"Entries!B2","v":"2019XXXXXX"},null,"Judge 1",null,"Judge 2",null,"Judge 3",null,"Judge 4",null,"Judge 5",null,"Judge 6",null,"Judge 7",null,"Judge 8"]
[null,null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name"]
[null,"Total Minutes",{"$f":"SUM(D8:D9,D11:D17)","v":{"v":120,"d":"120 mins"}},null,{"$f":"SUM(F8:F9,F11:F17)","v":{"v":120,"d":"120 mins"}},null,{"$f":"SUM(H8:H9,H11:H17)","v":{"v":120,"d":"120 mins"}},null,{"$f":"SUM(J8:J9,J11:J17)","v":{"v":120,"d":"120 mins"}},null,{"$f":"SUM(L8:L9,L11:L17)","v":{"v":120,"d":"120 mins"}},null,{"$f":"SUM(N8:N9,N11:N17)","v":{"v":120,"d":"120 mins"}},null,{"$f":"SUM(P8:P9,P11:P17)","v":{"v":120,"d":"120 mins"}},null,{"$f":"SUM(R8:R9,R11:R17)","v":{"v":120,"d":"120 mins"}}]
[null,"Total Hours",{"$f":"+C5/60","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"+E5/60","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"+G5/60","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"+I5/60","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"+K5/60","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"+M5/60","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"+O5/60","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"+Q5/60","v":{"v":2,"d":"2.00 hours"}}]
[null,null,"#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins"]
[null,"Setup/Admin",1,{"$f":"'allotted times 1 trial'!B1","v":120},1,{"$f":"'allotted times 1 trial'!B1","v":120},1,{"$f":"'allotted times 1 trial'!B1","v":120},1,{"$f":"SUM('allotted times 1 trial'!B1)","v":120},1,{"$f":"SUM('allotted times 1 trial'!B1)","v":120},1,{"$f":"SUM('allotted times 1 trial'!B1)","v":120},1,{"$f":"SUM('allotted times 1 trial'!B1)","v":120},1,{"$f":"SUM('allotted times 1 trial'!B1)","v":120}]
[null,"# courses",{"$f":"COUNTIF(Entries!D2:D27,\"J1\")","v":0},{"$f":"SUM(C9*'allotted times 1 trial'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J2\")","v":0},{"$f":"SUM(E9*'allotted times 1 trial'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J3\")","v":0},{"$f":"SUM(G9*'allotted times 1 trial'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J4\")","v":0},{"$f":"SUM(I9*'allotted times 1 trial'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J5\")","v":0},{"$f":"SUM(K9*'allotted times 1 trial'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J6\")","v":0},{"$f":"SUM(M9*'allotted times 1 trial'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J7\")","v":0},{"$f":"SUM(O9*'allotted times 1 trial'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J8\")","v":0},{"$f":"SUM(Q9*'allotted times 1 trial'!B2)","v":0}]
[null,null,"Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins"]
[null,"Nov",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(C11*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(E11*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(G11*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(I11*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(K11*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(M11*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(O11*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(Q11*'allotted times 1 trial'!B3)","v":0}]
[null,"Adv",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(C12*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(E12*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(G12*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(I12*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(K12*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(M12*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(O12*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(Q12*'allotted times 1 trial'!B4)","v":0}]
[null,"Exc",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(C13*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(E13*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(G13*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(I13*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(K13*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(M13*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(O13*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(Q13*'allotted times 1 trial'!B5)","v":0}]
[null,"Exc Int",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Exc.\")","v":0},{"$f":"SUM(C14*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(E14*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(G14*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(I14*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(K14*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(M14*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(O14*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(Q14*'allotted times 1 trial'!B6)","v":0}]
[null,"Mas",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(C15*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(E15*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(G15*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(I15*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(K15*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(M15*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(O15*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(Q15*'allotted times 1 trial'!B7)","v":0}]
[null,"Mas Int",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(C16*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(E16*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Mas.\")","v":0},{"$f":"SUM(G16*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(I16*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(K16*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(M16*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(O16*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(Q16*'allotted times 1 trial'!B8)","v":0},"Total Entries"]
[null,"Det",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(C17*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(E17*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(G17*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(I17*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(K17*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(M17*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(O17*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(Q17*'allotted times 1 trial'!B9)","v":0}]
[{"$nulls":18},{"$f":"SUM(C11:C17,E11:E17,G11:G17,I11:I17,K11:K17,M11:M17,O11:O17,Q11:Q17)","v":0}]
[null,"DAILY TOTAL",{"$f":"SUM(C11:C17)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(E11:E17)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(G11:G17)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(I11:I17)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(K11:K17)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(M11:M17)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(O11:O17)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(Q11:Q17)","v":{"v":0,"d":"0 entries"}}]

{"sheet":"Double Trial Calculator","index":3,"n_rows":33,"n_cols":19,"rows_kept":33,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,17],[1,0,15,0],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,15],[4,16,4,17],[14,18,15,18],[16,0,30,0],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,16,17,17],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17],[19,2,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[29,18,30,18],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[31,16,31,17],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[32,12,32,13],[32,14,32,15],[32,16,32,17]]}
[null,"Date:",null,null,"Club Name:"]
[{"$f":"Entries!B2","v":"2019XXXXXX"},null,"Judge 1",null,"Judge 2",null,"Judge 3",null,"Judge 4",null,"Judge 5",null,"Judge 6",null,"Judge 7",null,"Judge 8"]
[null,null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name"]
[null,"Total Minutes",{"$f":"SUM(D7:D8,D10:D16)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(F7:F8,F10:F16)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(H7:H8,H10:H16)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(J7:J8,J10:J16)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(L7:L8,L10:L16)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(N7:N8,N10:N16)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(P7:P8,P10:P16)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(R7:R8,R10:R16)","v":{"v":60,"d":"60 mins"}}]
[null,"Total Hours",{"$f":"+C4/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+E4/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+G4/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+I4/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+K4/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+M4/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+O4/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+Q4/60","v":{"v":1,"d":"1.00 hours"}}]
[null,null,"#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins"]
[null,"Setup/Admin",1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60}]
[null,"# courses",{"$f":"COUNTIF(Entries!D2:D27,\"J1\")","v":0},{"$f":"SUM(C8*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J2\")","v":0},{"$f":"SUM(E8*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J3\")","v":0},{"$f":"SUM(G8*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J4\")","v":0},{"$f":"SUM(I8*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J5\")","v":0},{"$f":"SUM(K8*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J6\")","v":0},{"$f":"SUM(M8*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J7\")","v":0},{"$f":"SUM(O8*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D2:D27,\"J8\")","v":0},{"$f":"SUM(Q8*'allotted times 2 trials'!B2)","v":0}]
[null,null,"Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins"]
[null,"Nov",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(C10*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(E10*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(G10*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(I10*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(K10*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(M10*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(O10*'allotted times 1 trial'!B3)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Novice*\")","v":0},{"$f":"SUM(Q10*'allotted times 1 trial'!B3)","v":0}]
[null,"Adv",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(C11*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(E11*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(G11*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(I11*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(K11*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(M11*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(O11*'allotted times 1 trial'!B4)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Advanced*\")","v":0},{"$f":"SUM(Q11*'allotted times 1 trial'!B4)","v":0}]
[null,"Exc",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(C12*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(E12*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(G12*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(I12*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(K12*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(M12*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(O12*'allotted times 1 trial'!B5)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Excellent*\")","v":0},{"$f":"SUM(Q12*'allotted times 1 trial'!B5)","v":0}]
[null,"Exc Int",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(C13*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(E13*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(G13*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(I13*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(K13*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(M13*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(O13*'allotted times 1 trial'!B6)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Exc.*\")","v":0},{"$f":"SUM(Q13*'allotted times 1 trial'!B6)","v":0}]
[null,"Mas",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(C14*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(E14*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(G14*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(I14*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(K14*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(M14*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(O14*'allotted times 1 trial'!B7)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Master*\")","v":0},{"$f":"SUM(Q14*'allotted times 1 trial'!B7)","v":0}]
[null,"Mas Int",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(C15*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(E15*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(G15*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(I15*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(K15*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(M15*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(O15*'allotted times 1 trial'!B8)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Mas.*\")","v":0},{"$f":"SUM(Q15*'allotted times 1 trial'!B8)","v":0},"Total Entries T1"]
[null,"Det",{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J1\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(C16*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J2\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(E16*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J3\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(G16*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J4\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(I16*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J5\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(K16*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J6\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(M16*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J7\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(O16*'allotted times 1 trial'!B9)","v":0},{"$f":"SUMIFS(Entries!E2:E27,Entries!D2:D27,\"J8\",Entries!C2:C27,\"*Detective*\")","v":0},{"$f":"SUM(Q16*'allotted times 1 trial'!B9)","v":0}]
[{"$f":"Entries!B28","v":"2019XXXXXX"},null,"Judge 1",null,"Judge 2",null,"Judge 3",null,"Judge 4",null,"Judge 5",null,"Judge 6",null,"Judge 7",null,"Judge 8",null,{"$f":"SUM(C10:C16,E10:E16,G10:G16,I10:I16,K10:K16,M10:M16,O10:O16,Q10:Q16)","v":0}]
[null,null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name"]
[null,"Total Minutes",{"$f":"SUM(D22:D23,D25:D31)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(F22:F23,F25:F31)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(H22:H23,H25:H31)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(J22:J23,J25:J31)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(L22:L23,L25:L31)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(N22:N23,N25:N31)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(P22:P23,P25:P31)","v":{"v":60,"d":"60 mins"}},null,{"$f":"SUM(R22:R23,R25:R31)","v":{"v":60,"d":"60 mins"}}]
[null,"Total Hours",{"$f":"+C19/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+E19/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+G19/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+I19/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+K19/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+M19/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+O19/60","v":{"v":1,"d":"1.00 hours"}},null,{"$f":"+Q19/60","v":{"v":1,"d":"1.00 hours"}}]
[null,null,"#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins","#","Mins"]
[null,"Setup/Admin",1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60},1,{"$f":"'allotted times 2 trials'!B1","v":60}]
[null,"# courses",{"$f":"COUNTIF(Entries!D28:D53,\"J1\")","v":0},{"$f":"SUM(C23*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D28:D53,\"J2\")","v":0},{"$f":"SUM(E23*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D28:D53,\"J3\")","v":0},{"$f":"SUM(G23*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D28:D53,\"J4\")","v":0},{"$f":"SUM(I23*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D28:D53,\"J5\")","v":0},{"$f":"SUM(K23*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D28:D53,\"J6\")","v":0},{"$f":"SUM(M23*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D28:D53,\"J7\")","v":0},{"$f":"SUM(O23*'allotted times 2 trials'!B2)","v":0},{"$f":"COUNTIF(Entries!D28:D53,\"J8\")","v":0},{"$f":"SUM(Q23*'allotted times 2 trials'!B2)","v":0}]
[null,null,"Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins","Entries","Mins"]
[null,"Nov",{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J1\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(C25*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J2\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(E25*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J3\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(G25*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J4\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(I25*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J5\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(K25*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J6\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(M25*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J7\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(O25*'allotted times 2 trials'!B3)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J8\",Entries!C28:C53,\"*Novice*\")","v":0},{"$f":"SUM(Q25*'allotted times 2 trials'!B3)","v":0}]
[null,"Adv",{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J1\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(C26*'allotted times 2 trials'!B4)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J2\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(E26*'allotted times 2 trials'!B4)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J3\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(G26*'allotted times 2 trials'!B4)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J4\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(I26*'allotted times 2 trials'!B4)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J5\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(K26*'allotted times 2 trials'!B4)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J6\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(M26*'allotted times 2 trials'!B4)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J7\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(O26*'allotted times 2 trials'!B4)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J8\",Entries!C28:C53,\"*Advanced*\")","v":0},{"$f":"SUM(Q26*'allotted times 2 trials'!B4)","v":0}]
[null,"Exc",{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J1\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(C27*'allotted times 2 trials'!B5)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J2\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(E27*'allotted times 2 trials'!B5)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J3\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(G27*'allotted times 2 trials'!B5)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J4\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(I27*'allotted times 2 trials'!B5)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J5\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(K27*'allotted times 2 trials'!B5)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J6\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(M27*'allotted times 2 trials'!B5)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J7\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(O27*'allotted times 2 trials'!B5)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J8\",Entries!C28:C53,\"*Excellent*\")","v":0},{"$f":"SUM(Q27*'allotted times 2 trials'!B5)","v":0}]
[null,"Exc Int",{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J1\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(C28*'allotted times 2 trials'!B6)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J2\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(E28*'allotted times 2 trials'!B6)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J3\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(G28*'allotted times 2 trials'!B6)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J4\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(I28*'allotted times 2 trials'!B6)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J5\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(K28*'allotted times 2 trials'!B6)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J6\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(M28*'allotted times 2 trials'!B6)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J7\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(O28*'allotted times 2 trials'!B6)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J8\",Entries!C28:C53,\"*Exc.*\")","v":0},{"$f":"SUM(Q28*'allotted times 2 trials'!B6)","v":0}]
[null,"Mas",{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J1\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(C29*'allotted times 2 trials'!B7)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J2\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(E29*'allotted times 2 trials'!B7)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J3\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(G29*'allotted times 2 trials'!B7)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J4\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(I29*'allotted times 2 trials'!B7)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J5\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(K29*'allotted times 2 trials'!B7)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J6\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(M29*'allotted times 2 trials'!B7)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J7\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(O29*'allotted times 2 trials'!B7)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J8\",Entries!C28:C53,\"*Master*\")","v":0},{"$f":"SUM(Q29*'allotted times 2 trials'!B7)","v":0}]
[null,"Mas Int",{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J1\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(C30*'allotted times 2 trials'!B8)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J2\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(E30*'allotted times 2 trials'!B8)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J3\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(G30*'allotted times 2 trials'!B8)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J4\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(I30*'allotted times 2 trials'!B8)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J5\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(K30*'allotted times 2 trials'!B8)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J6\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(M30*'allotted times 2 trials'!B8)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J7\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(O30*'allotted times 2 trials'!B8)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J8\",Entries!C28:C53,\"*Mas.*\")","v":0},{"$f":"SUM(Q30*'allotted times 2 trials'!B8)","v":0},"Total Entries T2"]
[null,"Det",{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J1\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(C31*'allotted times 2 trials'!B9)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J2\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(E31*'allotted times 2 trials'!B9)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J3\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(G31*'allotted times 2 trials'!B9)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J4\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(I31*'allotted times 2 trials'!B9)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J5\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(K31*'allotted times 2 trials'!B9)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J6\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(M31*'allotted times 2 trials'!B9)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J7\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(O31*'allotted times 2 trials'!B9)","v":0},{"$f":"SUMIFS(Entries!E28:E53,Entries!D28:D53,\"J8\",Entries!C28:C53,\"*Detective*\")","v":0},{"$f":"SUM(Q31*'allotted times 2 trials'!B9)","v":0}]
[null,"DAILY TOTAL:",{"$f":"SUM(C20,C5)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(E5,E20)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(G5,G20)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(I20,I5)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(K20,K5)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(M20,M5)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(O20,O5)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(Q20,Q5)","v":{"v":2,"d":"2.00 hours"}},null,{"$f":"SUM(C25:C31,E25:E31,G25:G31,I25:I31,K25:K31,M25:M31,O25:O31,Q25:Q31)","v":0}]
[null,null,{"$f":"SUM(C10:C16,C25:C31)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(E10:E16,E25:E31)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(G10:G16,G25:G31)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(I10:I16,I25:I31)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(K10:K16,K25:K31)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(M10:M16,M25:M31)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(O10:O16,O25:O31)","v":{"v":0,"d":"0 entries"}},null,{"$f":"SUM(Q10:Q16,Q25:Q31)","v":{"v":0,"d":"0 entries"}}]

{"sheet":"Judge List","index":4,"n_rows":8,"n_cols":1,"rows_kept":8,"hidden":true}
["J1"]
["J2"]
["J3"]
["J4"]
["J5"]
["J6"]
["J7"]
["J8"]

{"sheet":"Formulas","index":5,"n_rows":13,"n_cols":1,"rows_kept":13,"hidden":true}
[]
["SUMIFS(Entries!D2:D27,Entries!C2:C27,\"J1\",Entries!B2:B27,\"*Novice*\")"]
{"$rows_empty":9}
["Formula for Counting Classes by Judge:"]
["COUNTIF(Entries!C2:C27,\"J1\")"]

{"sheet":"allotted times 2 trials","index":6,"n_rows":9,"n_cols":24,"rows_kept":9,"hidden":true}
["Setup/Admin",60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60]
["courses",17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17,17]
["Nov",3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["Adv",4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
["Exc",5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["Exc Int",7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5]
["Mas",6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6]
["Mas Int",10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
["Det",15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15]