{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Battery Buggy B, 2018"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":"Battery Buggy B, 2018","index":0,"n_rows":110,"n_cols":63,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,15,1,22],[2,9,3,9],[2,10,2,12],[2,7,3,7],[2,8,3,8],[2,14,3,14],[2,16,3,16],[2,15,3,15],[2,17,3,17],[2,18,2,20],[2,22,3,22],[2,21,3,21],[1,1,3,3],[1,5,3,5],[2,13,3,13],[1,4,3,4],[1,6,3,6],[1,7,1,14],[1,23,3,23],[1,26,1,38],[2,26,2,30],[2,31,3,31],[2,32,2,36],[2,38,3,38],[1,24,3,24],[2,37,3,37],[1,61,1,62],[1,48,1,52],[2,25,3,25],[2,49,3,49],[2,61,3,61],[2,62,3,62],[2,52,3,52],[2,48,3,48],[2,45,2,47],[2,51,3,51],[2,50,3,50],[1,39,1,44],[2,39,2,41],[2,42,2,44]]}
[]
[null,"Team Name and State",null,null,"1. Vehicle & material impounded","2. No lithium and/or lead acid batteries","3. # of N's under Construction","Run 1",null,null,null,null,null,null,null,"Run 2",null,null,null,null,null,null,null,"20. Practice logs status","21. Bad Sportsmanship (DQ)",{"$f":"MAX(Z9:Z108)","v":41},"Scoring and Ranking",null,null,null,null,null,null,null,null,null,null,null,null,"Tie Breaker",null,null,null,null,null,null,null,null,"Final Score",null,null,null,null,null,null,null,null,null,null,null,null,"Final Ranking"]
[null,null,null,null,null,null,null,"4. # of Additional N's under Constr.","5. # of N's under Competition","6. Distance to target (cm)","Time",null,null,"10. Center Line Bonus","11. Failed run?","12. # of Additional N's under Constr.","13. # of N's under Competition","14. Distance to target (cm)","Time",null,null,"18. Center Line Bonus","19. Failed Run?",null,null,"Team present?","Run 1",null,null,null,null,"Better Run","Run 2",null,null,null,null,"Better Run Tier","Better Run Score","Tie Breaker 1",null,null,"Tie Breaker 2",null,null,"Tie Breaker 3",null,null,"Score","Tier","Tiebreaker","Rank","Points",null,null,null,null,null,null,null,null,"Rank","Team Name"]
[null,null,null,null,null,null,null,null,null,null,"7. Timer 1 (in sec)","8. Timer 2 (in sec)","9. Timer 3 (in sec)",null,null,null,null,null,"15. Timer 1 (in sec)","16. Timer 2 (in sec)","17. Timer 3 (in sec)",null,null,null,null,null,"Run 1 Status","Run 1 Distance Score","Run 1 Time Score","Run 1 Penalties","Run 1 Score",null,"Run 2 Status","Run 2 Distance Score","Run 2 Time Score","Run 2 Penalties","Run 2 Score",null,null,"Rank","Distance Score","Tie 1 Adjusted Rank","Rank after Tie Breaker 1","Time Score","Tie 2 Adjusted Rank","Rank after Tie Breaker 2","Non-Scored Adjusted Run","Tie 3 Adjusted Rank",null,null,null,null,null,null,{"$f":"SUM(BC9:BC108)","v":24}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incomplete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missing"]
[null,1,"Chippewa MS Maroon",null,null,null,0,0,0,45.2,5.5,5.52,5.64,"n","n",0,0,54.1,4.59,5.66,5.48,"n","n","Complete",null,{"$f":"IF(ISBLANK(C9),\"\",ROW(C9)-8)","v":1},{"$f":"IF(ISBLANK($C9),\"\",\nIF(OR(LEFT($Y9)=\"y\",LEFT($Y9)=\"t\",$Y9=1), \"DQ\",\nIF(AND(ISBLANK($K9), ISBLANK($L9), ISBLANK($M9), ISBLANK($J9), ISBLANK($S9), ISBLANK($T9), ISBLANK($U9), ISBLANK($R9),NOT(OR(LEFT($O9)=\"y\",LEFT($O9)=\"t\",$O9=1, LEFT($W9)=\"y\",LEFT($W9)=\"t\",$W9=1))),\"NS\",\nIF(OR(AND(ISBLANK(K9), ISBLANK(L9), ISBLANK(M9)), ISBLANK(J9),LEFT(O9)=\"y\",LEFT($O9)=\"t\",$O9=1,LEFT(F9)=\"n\",LEFT(F9)=\"f\"),\"P\",\n1\n)\n)\n)\n)","v":1},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER(AA9),ROUND(J9,1)*4,AA9))","v":180.8},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER(AA9),\n2*ROUND(MEDIAN(K9:M9),2),AA9))","v":11.04},{"$f":"IF(ISBLANK($C9),\"\",\n    IF(ISNUMBER(AA9),\n        MIN(3,(IF(ISBLANK($G9),0,$G9)+IF(ISBLANK(H9),0,H9)))*5000+\n        IF(ISBLANK(I9),0,MIN(4,I9))*1000+\n        IF(OR(LEFT($E9)=\"n\",LEFT($E9)=\"f\"),10000,0)+\nIF($X9=\"Incomplete\",250,IF($X9=\"Missing\",500,0)),\n    AA9)\n)","v":0},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER(AA9),SUM(AB9:AD9)+IF(OR(LEFT(N9)=\"y\",LEFT(N9)=\"t\",N9=1),-25,0),AA9))","v":191.84},{"$f":"IF(ISBLANK($C9),\"\",\nIF(AND(ISNUMBER(AA9),ISNUMBER(AG9)), IF(AE9=AK9,\"=\",IF(AE9>AK9,\"->\",\"<-\")),\nIF(OR(AA9=\"DQ\",AA9=\"NS\"), IF(AA9=\"DQ\",\"DQ\",\"NS\"),\nIF(OR(AND(AA9=\"P\",AG9=\"P\"),AND(AA9=\"P\",AG9=\"NS\"),AND(AA9=\"NS\",AG9=\"P\")),\"P\",IF(AA9=\"P\", \"->\",\"<-\"))\n)\n)\n)","v":"<-"},{"$f":"IF(ISBLANK($C9),\"\",\nIF(OR(LEFT($Y9)=\"y\",LEFT($Y9)=\"t\",$Y9=1), \"DQ\",\nIF(AND(ISBLANK($K9), ISBLANK($L9), ISBLANK($M9), ISBLANK($J9), ISBLANK($S9), ISBLANK($T9), ISBLANK($U9), ISBLANK($R9),NOT(OR(LEFT($O9)=\"y\",LEFT($O9)=\"t\",$O9=1, LEFT($W9)=\"y\",LEFT($W9)=\"t\",$W9=1))),\"NS\",\nIF(OR(AND(ISBLANK(S9), ISBLANK(T9), ISBLANK(U9)), ISBLANK(R9),LEFT(W9)=\"y\",LEFT($W9)=\"t\",$W9=1,LEFT(F9)=\"n\",LEFT(F9)=\"f\"),\"P\",\n1\n)\n)\n)\n)","v":1},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER(AG9),ROUND(R9,1)*4,AG9))","v":216.4},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER(AG9),\n2*ROUND(MEDIAN(S9:U9),2),AG9))","v":10.96},{"$f":"IF(ISBLANK($C9),\"\",\n    IF(ISNUMBER(AG9),\n        MIN(3,(IF(ISBLANK($G9),0,$G9)+IF(ISBLANK(P9),0,P9)))*5000+\n        IF(ISBLANK(Q9),0,MIN(4,Q9))*1000+\n        IF(OR(LEFT($E9)=\"n\",LEFT($E9)=\"f\"),10000,0)+\nIF($X9=\"Incomplete\",250,IF($X9=\"Missing\",500,0)),\n    AG9)\n)","v":0},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AG9),SUM(AH9:AJ9)+IF(OR(LEFT(V9)=\"y\",LEFT(V9)=\"t\",V9=1),-25,0),AG9))","v":227.36},{"$f":"IF(ISBLANK($C9),\"\",IF(OR(AF9=\"NS\",AF9=\"P\",AF9=\"DQ\"),AF9,IF(AF9=\"<-\",AA9,AG9)))","v":1},{"$f":"IF(ISBLANK($C9),\"\",IF(OR(AF9=\"NS\",AF9=\"P\",AF9=\"DQ\"),AF9,IF(AF9=\"<-\",AE9,AK9)))","v":191.84},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AM9),RANK(AM9,OFFSET(AM$9,0,0,$Z$2),1),AM9))","v":15},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),IF($AF9=\"=\",MIN(AB9,AH9),IF($AF9=\"<-\",AB9,AH9)),$AN9))","v":180.8},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),AN9+AO9/(MAX(AO$9:AO$108,1)*2),$AN9))","v":15.064571428571428},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),RANK(AP9,OFFSET(AP$9,0,0,$Z$2),1),$AN9))","v":15},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),IF($AF9=\"=\",MIN(AC9,AI9),IF($AF9=\"<-\",AC9,AI9)),$AN9))","v":11.04},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),AQ9+AR9/(MAX(AR$9:AR$108,1)*2),$AN9))","v":15.181221273801707},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),RANK(AS9,OFFSET(AS$9,0,0,$Z$2),1),$AN9))","v":15},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),IF($AF9=\"=\",MIN(AH9,AN9),IF($AF9=\"<-\",AH9,AN9)),$AN9))","v":216.4},{"$f":"IF(ISBLANK($C9),\"\",IF(ISNUMBER($AN9),AT9+IF(ISNUMBER(AU9),AU9/ABS((MAX(MAX(AU$9:AU$108,1),-MIN(AU$9:AU$108,1)))*2),0.6),$AN9))","v":15.17796052631579},{"$f":"IF(ROW(C9)-8>$Z$2,\"\",  IF(ISBLANK($C9),\"NS\",IF(OR(ISNUMBER($AL9),ISNUMBER($AM9)),AM9,$AL9)))","v":191.84},{"$f":"IF(ROW(C9)-8>$Z$2,\"\",IF(ISBLANK($C9),\"NS\",AL9))","v":1},{"$f":"IF(ROW(C9)-8>$Z$2,\"\",IF(ISBLANK($C9),\"NS\",IF(ISNUMBER(AS9),AN9-AZ9,AS9)))","v":0},{"$f":"IF(ROW(C9)-8>$Z$2,\"\",IF(ISBLANK($C9),\"NS\",IF(ISNUMBER(AV9),RANK(AV9,OFFSET($AV$9,0,0,$Z$2),1),AV9)))","v":15},{"$f":"IF(ROW(C9)-8>$Z$2,\"\",IF(ISNUMBER(AZ9),AZ9,IF(AZ9=\"P\",$Z$2,IF(AZ9=\"NS\",$Z$2+1,IF(AZ9=\"DQ\",$Z$2+2)))))","v":15},null,{"$f":"IF(ISNUMBER(AZ9),1,0)","v":1},1,{"$f":"IF(ISBLANK($C9),\"\",BA9+ROW($B9)/1000)","v":15.009},{"$f":"IF(ISBLANK($C9),\"\",RANK(BE9,OFFSET(BE$9,0,0,$Z$2),1))","v":15},{"$f":"IF(ISBLANK($C9),\"\",$C9)","v":"Chippewa MS Maroon"},{"$f":"IF(ISBLANK($C9),\"\",BA9)","v":15},{"$f":"AZ9","v":15},{"$f":"IF(BD9>BC$4,\"\",VLOOKUP(BD9,OFFSET(BF$9,0,0,$Z$2,4),4,FALSE))","v":1},{"$f":"IF(BD9>BC$4,\"\",VLOOKUP(BD9,OFFSET(BF$9,0,0,$Z$2,4),2,FALSE))","v":"Boulan Park MS Red"}]
[null,2,"Chippewa MS Blue",null,null,null,0,0,0,32.9,9.2100000000000009,9.25,9.36,"n","n",0,0,87.2,9.92,10.63,10.56,"n","n","Complete",null,{"$f":"IF(ISBLANK(C10),\"\",ROW(C10)-8)","v":2},{"$f":"IF(ISBLANK($C10),\"\",\nIF(OR(LEFT($Y10)=\"y\",LEFT($Y10)=\"t\",$Y10=1), \"DQ\",\nIF(AND(ISBLANK($K10), ISBLANK($L10), ISBLANK($M10), ISBLANK($J10), ISBLANK($S10), ISBLANK($T10), ISBLANK($U10), ISBLANK($R10),NOT(OR(LEFT($O10)=\"y\",LEFT($O10)=\"t\",$O10=1, LEFT($W10)=\"y\",LEFT($W10)=\"t\",$W10=1))),\"NS\",\nIF(OR(AND(ISBLANK(K10), ISBLANK(L10), ISBLANK(M10)), ISBLANK(J10),LEFT(O10)=\"y\",LEFT($O10)=\"t\",$O10=1,LEFT(F10)=\"n\",LEFT(F10)=\"f\"),\"P\",\n1\n)\n)\n)\n)","v":1},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER(AA10),ROUND(J10,1)*4,AA10))","v":131.6},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER(AA10),\n2*ROUND(MEDIAN(K10:M10),2),AA10))","v":18.5},{"$f":"IF(ISBLANK($C10),\"\",\n    IF(ISNUMBER(AA10),\n        MIN(3,(IF(ISBLANK($G10),0,$G10)+IF(ISBLANK(H10),0,H10)))*5000+\n        IF(ISBLANK(I10),0,MIN(4,I10))*1000+\n        IF(OR(LEFT($E10)=\"n\",LEFT($E10)=\"f\"),10000,0)+\nIF($X10=\"Incomplete\",250,IF($X10=\"Missing\",500,0)),\n    AA10)\n)","v":0},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER(AA10),SUM(AB10:AD10)+IF(OR(LEFT(N10)=\"y\",LEFT(N10)=\"t\",N10=1),-25,0),AA10))","v":150.1},{"$f":"IF(ISBLANK($C10),\"\",\nIF(AND(ISNUMBER(AA10),ISNUMBER(AG10)), IF(AE10=AK10,\"=\",IF(AE10>AK10,\"->\",\"<-\")),\nIF(OR(AA10=\"DQ\",AA10=\"NS\"), IF(AA10=\"DQ\",\"DQ\",\"NS\"),\nIF(OR(AND(AA10=\"P\",AG10=\"P\"),AND(AA10=\"P\",AG10=\"NS\"),AND(AA10=\"NS\",AG10=\"P\")),\"P\",IF(AA10=\"P\", \"->\",\"<-\"))\n)\n)\n)","v":"<-"},{"$f":"IF(ISBLANK($C10),\"\",\nIF(OR(LEFT($Y10)=\"y\",LEFT($Y10)=\"t\",$Y10=1), \"DQ\",\nIF(AND(ISBLANK($K10), ISBLANK($L10), ISBLANK($M10), ISBLANK($J10), ISBLANK($S10), ISBLANK($T10), ISBLANK($U10), ISBLANK($R10),NOT(OR(LEFT($O10)=\"y\",LEFT($O10)=\"t\",$O10=1, LEFT($W10)=\"y\",LEFT($W10)=\"t\",$W10=1))),\"NS\",\nIF(OR(AND(ISBLANK(S10), ISBLANK(T10), ISBLANK(U10)), ISBLANK(R10),LEFT(W10)=\"y\",LEFT($W10)=\"t\",$W10=1,LEFT(F10)=\"n\",LEFT(F10)=\"f\"),\"P\",\n1\n)\n)\n)\n)","v":1},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER(AG10),ROUND(R10,1)*4,AG10))","v":348.8},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER(AG10),\n2*ROUND(MEDIAN(S10:U10),2),AG10))","v":21.12},{"$f":"IF(ISBLANK($C10),\"\",\n    IF(ISNUMBER(AG10),\n        MIN(3,(IF(ISBLANK($G10),0,$G10)+IF(ISBLANK(P10),0,P10)))*5000+\n        IF(ISBLANK(Q10),0,MIN(4,Q10))*1000+\n        IF(OR(LEFT($E10)=\"n\",LEFT($E10)=\"f\"),10000,0)+\nIF($X10=\"Incomplete\",250,IF($X10=\"Missing\",500,0)),\n    AG10)\n)","v":0},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AG10),SUM(AH10:AJ10)+IF(OR(LEFT(V10)=\"y\",LEFT(V10)=\"t\",V10=1),-25,0),AG10))","v":369.92},{"$f":"IF(ISBLANK($C10),\"\",IF(OR(AF10=\"NS\",AF10=\"P\",AF10=\"DQ\"),AF10,IF(AF10=\"<-\",AA10,AG10)))","v":1},{"$f":"IF(ISBLANK($C10),\"\",IF(OR(AF10=\"NS\",AF10=\"P\",AF10=\"DQ\"),AF10,IF(AF10=\"<-\",AE10,AK10)))","v":150.1},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AM10),RANK(AM10,OFFSET(AM$9,0,0,$Z$2),1),AM10))","v":14},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),IF($AF10=\"=\",MIN(AB10,AH10),IF($AF10=\"<-\",AB10,AH10)),$AN10))","v":131.6},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),AN10+AO10/(MAX(AO$9:AO$108,1)*2),$AN10))","v":14.047000000000001},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),RANK(AP10,OFFSET(AP$9,0,0,$Z$2),1),$AN10))","v":14},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),IF($AF10=\"=\",MIN(AC10,AI10),IF($AF10=\"<-\",AC10,AI10)),$AN10))","v":18.5},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),AQ10+AR10/(MAX(AR$9:AR$108,1)*2),$AN10))","v":14.303676953381483},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),RANK(AS10,OFFSET(AS$9,0,0,$Z$2),1),$AN10))","v":14},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),IF($AF10=\"=\",MIN(AH10,AN10),IF($AF10=\"<-\",AH10,AN10)),$AN10))","v":348.8},{"$f":"IF(ISBLANK($C10),\"\",IF(ISNUMBER($AN10),AT10+IF(ISNUMBER(AU10),AU10/ABS((MAX(MAX(AU$9:AU$108,1),-MIN(AU$9:AU$108,1)))*2),0.6),$AN10))","v":14.286842105263158},{"$f":"IF(ROW(C10)-8>$Z$2,\"\",  IF(ISBLANK($C10),\"NS\",IF(OR(ISNUMBER($AL10),ISNUMBER($AM10)),AM10,$AL10)))","v":150.1},{"$f":"IF(ROW(C10)-8>$Z$2,\"\",IF(ISBLANK($C10),\"NS\",AL10))","v":1},{"$f":"IF(ROW(C10)-8>$Z$2,\"\",IF(ISBLANK($C10),\"NS\",IF(ISNUMBER(AS10),AN10-AZ10,AS10)))","v":0},{"$f":"IF(ROW(C10)-8>$Z$2,\"\",IF(ISBLANK($C10),\"NS\",IF(ISNUMBER(AS10),RANK(AS10,OFFSET($AS$9,0,0,$Z$2),1),AS10)))","v":14},{"$f":"IF(ROW(C10)-8>$Z$2,\"\",IF(ISNUMBER(AZ10),AZ10,IF(AZ10=\"P\",$Z$2,IF(AZ10=\"NS\",$Z$2+1,IF(AZ10=\"DQ\",$Z$2+2)))))","v":14},null,{"$f":"IF(ISNUMBER(AZ10),1,0)","v":1},2,{"$f":"IF(ISBLANK($C10),\"\",BA10+ROW($B10)/1000)","v":14.01},{"$f":"IF(ISBLANK($C10),\"\",RANK(BE10,OFFSET(BE$9,0,0,$Z$2),1))","v":14},{"$f":"IF(ISBLANK($C10),\"\",$C10)","v":"Chippewa MS Blue"},{"$f":"IF(ISBLANK($C10),\"\",BA10)","v":14},{"$f":"AZ10","v":14},{"$f":"IF(BD10>BC$4,\"\",VLOOKUP(BD10,OFFSET(BF$9,0,0,$Z$2,4),4,FALSE))","v":2},{"$f":"IF(BD10>BC$4,\"\",VLOOKUP(BD10,OFFSET(BF$9,0,0,$Z$2,4),2,FALSE))","v":"Fowlerville Jr. HS"}]
[null,3,"Clague MS Green",null,null,null,0,0,0,29.3,3.33,3.26,3.41,"n","n",0,0,16.399999999999999,3.25,3.25,3.15,"y","n","Complete",null,3,1,117.2,6.66,0,123.86,"->",1,65.599999999999994,6.5,0,47.099999999999994,1,47.099999999999994,10,65.599999999999994,10.023428571428571,10,6.5,10.106697307944845,10,10,10.008223684210526,47.099999999999994,1,0,10,10,null,1,3,10.010999999999999,10,"Clague MS Green",10,10,3,"Boulan Park MS Purple"]
[null,4,"Clague MS Blue",null,null,null,0,0,0,26.8,3.99,3.67,3.92,"n","n",0,0,13.3,3.76,3.88,3.78,"y","n","Complete",null,4,1,107.2,7.84,0,115.04,"->",1,53.2,7.56,0,35.760000000000005,1,35.760000000000005,7,53.2,7.0190000000000001,7,7.56,7.1240971766250825,7,7,7.0057565789473681,35.760000000000005,1,0,7,7,null,1,4,7.0119999999999996,7,"Clague MS Blue",7,7,4,"Meads Mill MS Maroon"]
[null,5,"Boulan Park MS Purple",null,null,null,0,0,0,59.5,2.68,2.71,2.67,"n","n",0,0,9,2.64,2.65,2.79,"Y","n","Complete",null,5,1,238,5.36,0,243.36,"->",1,36,5.3,0,16.299999999999997,1,16.299999999999997,3,36,3.0128571428571429,3,5.3,3.0869993434011818,3,3,3.002467105263158,16.299999999999997,1,0,3,3,null,1,5,3.0129999999999999,3,"Boulan Park MS Purple",3,3,5,"L’Anse Creuse MS South"]
[null,6,"Boulan Park MS White",null,null,null,0,0,0,45,3.17,3.25,3.4,"n","n",0,0,21.5,3.22,3.22,3.22,"y","n","Complete",null,6,1,180,6.5,0,186.5,"->",1,86,6.44,0,67.44,1,67.44,12,86,12.030714285714286,12,6.44,12.105712409717663,12,12,12.009868421052632,67.44,1,0,12,12,null,1,6,12.013999999999999,12,"Boulan Park MS White",12,12,6,"Dansville MS Black"]
[null,7,"Boulan Park MS Red",null,null,null,0,0,0,4,3.7,3.67,3.65,"y","n",0,0,13,3.57,3.58,3.65,"y","n","Complete",null,7,1,16,7.34,0,-1.6600000000000001,"<-",1,52,7.16,0,34.159999999999997,1,-1.6600000000000001,1,16,1.0057142857142858,1,7.34,1.1204858831254103,1,52,1.0427631578947369,-1.6600000000000001,1,0,1,1,null,1,7,1.0149999999999999,1,"Boulan Park MS Red",1,1,7,"Clague MS Blue"]
[null,8,"Smith MS Gold",null,null,null,0,0,0,14,5.1100000000000003,5.31,5.16,"y","n",0,0,24.2,4.63,4.6500000000000004,4.82,"y","n","Complete",null,8,1,56,10.32,0,41.319999999999993,"<-",1,96.8,9.3000000000000007,0,81.099999999999994,1,41.319999999999993,9,56,9.02,9,10.32,9.1694024950755093,9,96.8,9.0796052631578945,41.319999999999993,1,0,9,9,null,1,8,9.016,9,"Smith MS Gold",9,9,8,"Hillside MS Red"]
[null,9,"Smith MS White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,9,42.017000000000003,27,"Smith MS White",42,"NS",9,"Smith MS Gold"]
[null,10,"Dansville MS Black",null,null,null,0,0,0,44.8,4.43,4.83,5.04,"y","n",0,0,12.3,4.62,5.29,5.1100000000000003,"y","n","Complete",null,10,1,179.2,9.66,0,163.85999999999999,"->",1,49.2,10.220000000000001,0,34.42,1,34.42,6,49.2,6.0175714285714283,6,10.220000000000001,6.1677609980302037,6,6,6.0049342105263159,34.42,1,0,6,6,null,1,10,6.0179999999999998,6,"Dansville MS Black",6,6,10,"Clague MS Green"]
[null,11,"Dansville MS Gold",null,null,null,0,0,1,350,20.420000000000002,20.75,20.65,"n","n",0,1,350,15.23,15.47,13.89,"n","n","Missing",null,11,1,1400,41.3,1500,2941.3,"->",1,1400,30.46,1500,2930.46,1,2930.46,24,1400,24.5,24,30.46,24.5,24,24,24.019736842105264,2930.46,1,0,24,24,null,1,11,24.018999999999998,24,"Dansville MS Gold",24,24,11,"Canton Charter Acad.  White"]
[null,12,"Power MS",null,null,null,0,0,0,68,2.3199999999999998,2.41,2.5099999999999998,"n","n",0,0,53.1,2.38,2.42,2.33,"n","n","Complete",null,12,1,272,4.82,0,276.82,"->",1,212.4,4.76,0,217.16,1,217.16,17,212.4,17.075857142857142,17,4.76,17.078135259356532,17,17,17.013980263157894,217.16,1,0,17,17,null,1,12,17.02,17,"Power MS",17,17,12,"Boulan Park MS White"]
[null,13,"Washington Woods MS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,13,42.021000000000001,28,"Washington Woods MS",42,"NS",13,"Canton Charter Acad.  Blue"]
[null,14,"Hope MS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,14,42.021999999999998,29,"Hope MS",42,"NS",14,"Chippewa MS Blue"]
[null,15,"Holt Jr. HS  Gold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,15,42.023000000000003,30,"Holt Jr. HS  Gold",42,"NS",15,"Chippewa MS Maroon"]
[null,16,"Holt Jr. HS  Brown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,16,42.024000000000001,31,"Holt Jr. HS  Brown",42,"NS",16,"Liberty MS Blue"]
[null,17,"Kinawa MS  Maroon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,17,42.024999999999999,32,"Kinawa MS  Maroon",42,"NS",17,"Power MS"]
[null,18,"Kinawa MS  White",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,18,42.026000000000003,33,"Kinawa MS  White",42,"NS",18,"Hillside MS Black"]
[null,19,"Liberty MS Blue",null,null,null,0,0,0,190,2.64,2.27,2.34,"n","n",0,0,52.8,2.46,2.48,2.59,"n","n","Complete",null,19,1,760,4.68,0,764.68,"->",1,211.2,4.96,0,216.16,1,216.16,16,211.2,16.075428571428571,16,4.96,16.081418253447143,16,16,16.013157894736842,216.16,1,0,16,16,null,1,19,16.027000000000001,16,"Liberty MS Blue",16,16,19,"Scranton MS 2"]
[null,20,"Liberty MS Silver",null,null,null,0,0,0,89.1,5.15,4.82,5.07,"n","y",0,0,126.4,2.1800000000000002,1.95,1.85,"n","n","Complete",null,20,"P","P","P","P","P","->",1,505.6,3.9,0,509.5,1,509.5,22,505.6,22.180571428571429,22,3.9,22.064018384766907,22,22,22.018092105263158,509.5,1,0,22,22,null,1,20,22.027999999999999,22,"Liberty MS Silver",22,22,20,"Washtenaw Int’l Academy "]
[null,21,"Ionia MS 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,21,42.029000000000003,34,"Ionia MS 1",42,"NS",21,"Meads Mill MS Gold"]
[null,22,"Ionia MS 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,22,42.03,35,"Ionia MS 2",42,"NS",22,"Liberty MS Silver"]
[null,23,"Haslett MS Gold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,23,42.030999999999999,36,"Haslett MS Gold",42,"NS",23,"McCord Jr HS Red"]
[null,24,"Haslett MS Blue",null,null,null,null,null,2,null,null,null,null,null,"y",null,2,null,null,null,null,null,"y","Missing",null,24,"P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P",41,null,0,24,41.031999999999996,25,"Haslett MS Blue",41,"P",24,"Dansville MS Gold"]
[null,25,"McCord Jr HS Red",null,null,null,0,0,1,350,3.76,6.15,5.3,"n","n",0,0,169.2,2.67,1.27,2.46,"n","n","Complete",null,25,1,1400,10.6,1000,2410.6,"->",1,676.8,4.92,0,681.71999999999991,1,681.71999999999991,23,676.8,23.241714285714284,23,4.92,23.080761654629022,23,23,23.018914473684209,681.71999999999991,1,0,23,23,null,1,25,23.033000000000001,23,"McCord Jr HS Red",23,23,"",""]
[null,26,"McCord Jr HS Black",null,null,null,0,0,0,null,null,null,null,null,"y",null,null,null,null,null,null,null,"y","Incomplete",null,26,"P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P",41,null,0,26,41.033999999999999,26,"McCord Jr HS Black",41,"P","",""]
[null,27,"L’Anse Creuse MS South",null,null,null,0,0,0,9.6999999999999993,6.66,5.58,5.83,"y","n",0,0,50.5,4.2699999999999996,4.41,4.38,"n","n","Complete",null,27,1,38.799999999999997,11.66,0,25.459999999999994,"<-",1,202,8.76,0,210.76,1,25.459999999999994,5,38.799999999999997,5.0138571428571428,5,11.66,5.1913985554825999,5,202,5.1661184210526319,25.459999999999994,1,0,5,5,null,1,27,5.0350000000000001,5,"L’Anse Creuse MS South",5,5,"",""]
[null,28,"Warner MS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,28,42.036000000000001,37,"Warner MS",42,"NS","",""]
[null,29,"Novi Meadows Elementary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,29,42.036999999999999,38,"Novi Meadows Elementary",42,"NS","",""]
[null,30,"Lansing Homeschool Scholars",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,30,42.037999999999997,39,"Lansing Homeschool Scholars",42,"NS","",""]
[null,31,"Meads Mill MS Gold",null,null,null,0,0,0,88.7,3.32,3.58,3.4,"n","n",0,1,null,null,null,null,null,"y","Complete",null,31,1,354.8,6.8,0,361.6,"<-","P","P","P","P","P",1,361.6,21,354.8,21.126714285714286,21,6.8,21.111621799080762,21,"P",21.6,361.6,1,0,21,21,null,1,31,21.039000000000001,21,"Meads Mill MS Gold",21,21,"",""]
[null,32,"Meads Mill MS Maroon",null,null,null,0,0,0,58.5,3.42,3.58,3.32,"n","n",0,0,10.7,3.62,3.65,3.73,"y","n","Complete",null,32,1,234,6.84,0,240.84,"->",1,42.8,7.3,0,25.099999999999994,1,25.099999999999994,4,42.8,4.0152857142857146,4,7.3,4.1198292843072881,4,4,4.0032894736842106,25.099999999999994,1,0,4,4,null,1,32,4.04,4,"Meads Mill MS Maroon",4,4,"",""]
[null,33,"St. Martha ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,33,42.040999999999997,40,"St. Martha ",42,"NS","",""]
[null,34,"Canton Charter Acad.  Blue",null,null,null,0,0,0,32.4,3.11,3.18,3.37,"n","n",0,0,27.2,3.31,3.32,3.95,"n","n","Complete",null,34,1,129.6,6.36,0,135.96,"->",1,108.8,6.64,0,115.44,1,115.44,13,108.8,13.038857142857143,13,6.64,13.108995403808272,13,13,13.010690789473685,115.44,1,0,13,13,null,1,34,13.042,13,"Canton Charter Acad.  Blue",13,13,"",""]
[null,35,"Canton Charter Acad.  White",null,null,null,0,0,0,45.5,3.69,3.71,3.72,"n","n",0,0,14,3.89,3.58,3.69,"n","n","Complete",null,35,1,182,7.42,0,189.42,"->",1,56,7.38,0,63.38,1,63.38,11,56,11.02,11,7.38,11.121142481943533,11,11,11.009046052631579,63.38,1,0,11,11,null,1,35,11.042999999999999,11,"Canton Charter Acad.  White",11,11,"",""]
[null,36,"Washtenaw Int’l Academy ",null,null,null,0,0,0,76.3,6.1,4.79,4.79,"n","n",0,0,152,4.59,4.63,4.78,"n","n","Complete",null,36,1,305.2,9.58,0,314.77999999999997,"<-",1,608,9.26,0,617.26,1,314.77999999999997,20,305.2,20.109000000000002,20,9.58,20.157255416940249,20,608,20.5,314.77999999999997,1,0,20,20,null,1,36,20.044,20,"Washtenaw Int’l Academy ",20,20,"",""]
[null,37,"Hillside MS Red",null,null,null,0,0,0,17,2.66,2.76,2.77,"y","n",0,0,14,2.58,2.66,3.05,"y","n","Complete",null,37,1,68,5.52,0,48.519999999999996,"->",1,56,5.32,0,36.32,1,36.32,8,56,8.02,8,5.32,8.0873276428102425,8,8,8.0065789473684212,36.32,1,0,8,8,null,1,37,8.0449999999999999,8,"Hillside MS Red",8,8,"",""]
[null,38,"Hillside MS Black",null,null,null,0,0,0,105.1,9.42,9.59,9.5399999999999991,"n","n",0,0,63.3,9.27,9.42,9.51,"n","n","Complete",null,38,1,420.4,19.079999999999998,0,439.47999999999996,"->",1,253.2,18.84,0,272.03999999999996,1,272.03999999999996,18,253.2,18.090428571428571,18,18.84,18.309258043335522,18,18,18.014802631578949,272.03999999999996,1,0,18,18,null,1,38,18.045999999999999,18,"Hillside MS Black",18,18,"",""]
[null,39,"Scranton MS 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",42,null,0,39,42.046999999999997,41,"Scranton MS 1",42,"NS","",""]
[null,40,"Scranton MS 2",null,null,null,0,0,0,80.400000000000006,10.01,11.06,10.86,"n","n",0,0,67.8,11.19,11.2,11.48,"n","n","Complete",null,40,1,321.60000000000002,21.72,0,343.32000000000005,"->",1,271.2,22.4,0,293.59999999999997,1,293.59999999999997,19,271.2,19.096857142857143,19,22.4,19.367695338148391,19,19,19.015625,293.59999999999997,1,0,19,19,null,1,40,19.047999999999998,19,"Scranton MS 2",19,19,"",""]
[null,41,"Fowlerville Jr. HS",null,null,null,0,0,0,75,6.74,6.82,6.86,"n","n",0,0,7,6.34,6.5,6.38,"y","n","Complete",null,41,1,300,13.64,0,313.64,"->",1,28,12.76,0,15.759999999999998,1,15.759999999999998,2,28,2.0099999999999998,2,12.76,2.2094550229809586,2,2,2.0016447368421053,15.759999999999998,1,0,2,2,null,1,41,2.0489999999999999,2,"Fowlerville Jr. HS",2,2,"",""]
[null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,42,"","","","","","",""]
[null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,43,"","","","","","",""]
[null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,44,"","","","","","",""]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,45,"","","","","","",""]
[null,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,46,"","","","","","",""]
[null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,47,"","","","","","",""]
[null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,48,"","","","","","",""]
[null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,49,"","","","","","",""]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,50,"","","","","","",""]
[null,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,51,"","","","","","",""]
[null,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,52,"","","","","","",""]
[null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,53,"","","","","","",""]
[null,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,54,"","","","","","",""]
[null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,55,"","","","","","",""]
[null,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,56,"","","","","","",""]
[null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,57,"","","","","","",""]
[null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,58,"","","","","","",""]
[null,59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,59,"","","","","","",""]
[null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,60,"","","","","","",""]
[null,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,61,"","","","","","",""]
[null,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,62,"","","","","","",""]
[null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,63,"","","","","","",""]
[null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,64,"","","","","","",""]
[null,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,65,"","","","","","",""]
[null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C74),\"\",ROW(C74)-8)","v":""},{"$f":"IF(ISBLANK($C74),\"\",\nIF(OR(LEFT($Y74)=\"y\",LEFT($Y74)=\"t\",$Y74=1), \"DQ\",\nIF(AND(ISBLANK($K74), ISBLANK($L74), ISBLANK($M74), ISBLANK($J74), ISBLANK($S74), ISBLANK($T74), ISBLANK($U74), ISBLANK($R74),NOT(OR(LEFT($O74)=\"y\",LEFT($O74)=\"t\",$O74=1, LEFT($W74)=\"y\",LEFT($W74)=\"t\",$W74=1))),\"NS\",\nIF(OR(AND(ISBLANK(K74), ISBLANK(L74), ISBLANK(M74)), ISBLANK(J74),LEFT(O74)=\"y\",LEFT($O74)=\"t\",$O74=1,LEFT(F74)=\"n\",LEFT(F74)=\"f\"),\"P\",\n1\n)\n)\n)\n)","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER(AA74),ROUND(J74,1)*4,AA74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER(AA74),\n2*ROUND(MEDIAN(K74:M74),2),AA74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",\n    IF(ISNUMBER(AA74),\n        MIN(3,(IF(ISBLANK($G74),0,$G74)+IF(ISBLANK(H74),0,H74)))*5000+\n        IF(ISBLANK(I74),0,MIN(4,I74))*1000+\n        IF(OR(LEFT($E74)=\"n\",LEFT($E74)=\"f\"),10000,0)+\nIF($X74=\"Incomplete\",250,IF($X74=\"Missing\",500,0)),\n    AA74)\n)","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER(AA74),SUM(AB74:AD74)+IF(OR(LEFT(N74)=\"y\",LEFT(N74)=\"t\",N74=1),-25,0),AA74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",\nIF(AND(ISNUMBER(AA74),ISNUMBER(AG74)), IF(AE74=AK74,\"=\",IF(AE74>AK74,\"->\",\"<-\")),\nIF(OR(AA74=\"DQ\",AA74=\"NS\"), IF(AA74=\"DQ\",\"DQ\",\"NS\"),\nIF(OR(AND(AA74=\"P\",AG74=\"P\"),AND(AA74=\"P\",AG74=\"NS\"),AND(AA74=\"NS\",AG74=\"P\")),\"P\",IF(AA74=\"P\", \"->\",\"<-\"))\n)\n)\n)","v":""},{"$f":"IF(ISBLANK($C74),\"\",\nIF(OR(LEFT($Y74)=\"y\",LEFT($Y74)=\"t\",$Y74=1), \"DQ\",\nIF(AND(ISBLANK($K74), ISBLANK($L74), ISBLANK($M74), ISBLANK($J74), ISBLANK($S74), ISBLANK($T74), ISBLANK($U74), ISBLANK($R74),NOT(OR(LEFT($O74)=\"y\",LEFT($O74)=\"t\",$O74=1, LEFT($W74)=\"y\",LEFT($W74)=\"t\",$W74=1))),\"NS\",\nIF(OR(AND(ISBLANK(S74), ISBLANK(T74), ISBLANK(U74)), ISBLANK(R74),LEFT(W74)=\"y\",LEFT($W74)=\"t\",$W74=1,LEFT(F74)=\"n\",LEFT(F74)=\"f\"),\"P\",\n1\n)\n)\n)\n)","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER(AG74),ROUND(R74,1)*4,AG74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER(AG74),\n2*ROUND(MEDIAN(S74:U74),2),AG74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",\n    IF(ISNUMBER(AG74),\n        MIN(3,(IF(ISBLANK($G74),0,$G74)+IF(ISBLANK(P74),0,P74)))*5000+\n        IF(ISBLANK(Q74),0,MIN(4,Q74))*1000+\n        IF(OR(LEFT($E74)=\"n\",LEFT($E74)=\"f\"),10000,0)+\nIF($X74=\"Incomplete\",250,IF($X74=\"Missing\",500,0)),\n    AG74)\n)","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AG74),SUM(AH74:AJ74)+IF(OR(LEFT(V74)=\"y\",LEFT(V74)=\"t\",V74=1),-25,0),AG74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(OR(AF74=\"NS\",AF74=\"P\",AF74=\"DQ\"),AF74,IF(AF74=\"<-\",AA74,AG74)))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(OR(AF74=\"NS\",AF74=\"P\",AF74=\"DQ\"),AF74,IF(AF74=\"<-\",AE74,AK74)))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AM74),RANK(AM74,OFFSET(AM$9,0,0,$Z$2),1),AM74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),IF($AF74=\"=\",MIN(AB74,AH74),IF($AF74=\"<-\",AB74,AH74)),$AN74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),AN74+AO74/(MAX(AO$9:AO$108,1)*2),$AN74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),RANK(AP74,OFFSET(AP$9,0,0,$Z$2),1),$AN74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),IF($AF74=\"=\",MIN(AC74,AI74),IF($AF74=\"<-\",AC74,AI74)),$AN74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),AQ74+AR74/(MAX(AR$9:AR$108,1)*2),$AN74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),RANK(AS74,OFFSET(AS$9,0,0,$Z$2),1),$AN74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),IF($AF74=\"=\",MIN(AH74,AN74),IF($AF74=\"<-\",AH74,AN74)),$AN74))","v":""},{"$f":"IF(ISBLANK($C74),\"\",IF(ISNUMBER($AN74),AT74+IF(ISNUMBER(AU74),AU74/ABS((MAX(MAX(AU$9:AU$108,1),-MIN(AU$9:AU$108,1)))*2),0.6),$AN74))","v":""},{"$f":"IF(ROW(C74)-8>$Z$2,\"\",  IF(ISBLANK($C74),\"NS\",IF(OR(ISNUMBER($AL74),ISNUMBER($AM74)),AM74,$AL74)))","v":""},{"$f":"IF(ROW(C74)-8>$Z$2,\"\",IF(ISBLANK($C74),\"NS\",AL74))","v":""},{"$f":"IF(ROW(C74)-8>$Z$2,\"\",IF(ISBLANK($C74),\"NS\",IF(ISNUMBER(AS74),AN74-AZ74,AS74)))","v":""},{"$f":"IF(ROW(C74)-8>$Z$2,\"\",IF(ISBLANK($C74),\"NS\",IF(ISNUMBER(AS74),RANK(AS74,OFFSET($AS$9,0,0,$Z$2),1),AS74)))","v":""},{"$f":"IF(ROW(C74)-8>$Z$2,\"\",IF(ISNUMBER(AZ74),AZ74,IF(AZ74=\"P\",$Z$2,IF(AZ74=\"NS\",$Z$2+1,IF(AZ74=\"DQ\",$Z$2+2)))))","v":""},null,{"$f":"IF(ISNUMBER(AZ74),1,0)","v":0},66,{"$f":"IF(ISBLANK($C74),\"\",BA74+ROW($B74)/1000)","v":""},{"$f":"IF(ISBLANK($C74),\"\",RANK(BE74,OFFSET(BE$9,0,0,$Z$2),1))","v":""},{"$f":"IF(ISBLANK($C74),\"\",$C74)","v":""},{"$f":"IF(ISBLANK($C74),\"\",BA74)","v":""},{"$f":"AZ74","v":""},{"$f":"IF(BD74>BC$4,\"\",VLOOKUP(BD74,OFFSET(BF$9,0,0,$Z$2,4),4,FALSE))","v":""},{"$f":"IF(BD74>BC$4,\"\",VLOOKUP(BD74,OFFSET(BF$9,0,0,$Z$2,4),2,FALSE))","v":""}]
[null,67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,67,"","","","","","",""]
[null,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,68,"","","","","","",""]
[null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,69,"","","","","","",""]
[null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,70,"","","","","","",""]
[null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,71,"","","","","","",""]
[null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,72,"","","","","","",""]
[null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,73,"","","","","","",""]
[null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,74,"","","","","","",""]
[null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,75,"","","","","","",""]
[null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,76,"","","","","","",""]
[null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,77,"","","","","","",""]
[null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,78,"","","","","","",""]
[null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,79,"","","","","","",""]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,80,"","","","","","",""]
[null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,81,"","","","","","",""]
[null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,82,"","","","","","",""]
[null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,83,"","","","","","",""]
[null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,84,"","","","","","",""]
[null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,85,"","","","","","",""]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,86,"","","","","","",""]
[null,87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,87,"","","","","","",""]
[null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,88,"","","","","","",""]
[null,89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,89,"","","","","","",""]
[null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,90,"","","","","","",""]
[null,91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,91,"","","","","","",""]
[null,92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,92,"","","","","","",""]
[null,93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,93,"","","","","","",""]
[null,94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,94,"","","","","","",""]
[null,95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,95,"","","","","","",""]
[null,96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,96,"","","","","","",""]
[null,97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,97,"","","","","","",""]
[null,98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,98,"","","","","","",""]
[null,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,99,"","","","","","",""]
[null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,0,100,"","","","","","",""]
[]
[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,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,null,null,null,null,"Direct all questions to Peter Hung (scoresheets@soinc.org)."]