{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Base Sheet"],"not_rendered":{"charts":1,"images":7,"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":"Base Sheet","index":0,"n_rows":53,"n_cols":137,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["First Name ","Last Name",null,null,"HW 1","HW 2","HW 3","HW 4","HW 5","HW 6","HW 7","HW 8","Test 1","Test 2","Test 3","Test 4","Test 5","Test 6","Test 7"," Test 8","FExam","Avg","Grade",null,null,null,"AdvAvg","Adv Grade","A Req","A Imp","BReq","BImp","CReq","CImp","DReq","DImp","MT2Avg","MT2Grade","AReq","AImp","BReq","BImp","CReq","CImp","DReq","DImp","MT1Avg","MT1Grade","AHW","BAHW","UHW","SHW","HWStatus","TestAs","TestBs","TestCs","TestDs","TestFs","TestMFs","TStatus",null,"HW Avg","Low Test","T Spread","Low Final","Hi Final",null,null,null,null,"fl state","AptFact","FExamLG","ChangeT","ChangeF","TermTrend","FTrend","BFGrade","HW Fact","HW Avg 1","TAvg 1","TAvgO1","TAvgO2","HW Avg 2","T Avg 2","TAvgO1","TAvgO2","Test to Ct","Adv HW Adj","Ex Tests","TAvg A","TAvgO1","TAvgO2",null,null,"MT1","MT2","Adv","Final","MT21Slope","MTA2Slope","AFSlope","DMT21Slope","DMTA2Slope","DAFSlope","Test1 ","Test 2","Test 3","Test 4","Test 5","Test 6","Test 7","Test 8",null,"MT2","AHW","BAHW","UHW","SHW","TestAs","TestBs","TestCs","TestDs","TestFs","TestMFs",null,"MT1","AHW","BAHW","UHW","SHW","TestAs","TestBs","TestCs","TestDs","TestFs","TestMFs"]
["WhoEver","you are",null,null,null,5,10,10,12,5,10,10,30,32,38,42,45,41,48,58,275,{"$f":"AA2*0.7+U2/10","v":77.45},{"$f":"VLOOKUP(V2,E$21:F$31,2)","v":"B+"},null,null,null,{"$f":"(CM2+CK2)/0.7","v":71.357142857142861},{"$f":"VLOOKUP(AA2,G$21:H$25,2)","v":"C"},{"$f":"(G$25-AA2*0.7)/30*300","v":350.49999999999994},{"$f":"(AC2/5)/CM2","v":1.6790419161676646},{"$f":"(G$24-0.7*AA2)/30*300","v":230.49999999999997},{"$f":"(AE2/5)/CM2","v":1.1041916167664669},{"$f":"(G$23-0.7*AA2)/30*300","v":100.49999999999997},{"$f":"(AG2/5)/CM2","v":0.48143712574850284},{"$f":"(G$22-0.7*AA2)/30*300","v":0.49999999999997158},{"$f":"(AI2/5)/CM2","v":2.3952095808381871E-3},{"$f":"(CF2+CG2)/0.7","v":64},{"$f":"VLOOKUP(AK2,G$21:H$25,2)","v":"C"},{"$f":"(G$25-(AK2*0.425+4))/(100*(1-0.475))*60","v":61.485714285714288},{"$f":"AM2/(SUM($M2:$Q2)/5)","v":1.6440030557677618},{"$f":"(G$24-(AK2*0.425+4))/(100*(1-0.475))*60","v":47.771428571428565},{"$f":"AO2/(SUM($M2:$Q2)/5)","v":1.2773109243697478},{"$f":"(G$23-(AK2*0.425+4))/(100*(1-0.475))*60","v":32.914285714285718},{"$f":"AQ2/(SUM($M2:$Q2)/5)","v":0.88006111535523313},{"$f":"(G$22-(AK2*0.425+4))/(100*(1-0.475))*60","v":21.485714285714288},{"$f":"AS2/(SUM($M2:$Q2)/5)","v":0.57448433919022157},{"$f":"(CB2+CC2)/0.7","v":54.761904761904766},{"$f":"VLOOKUP(AU2,G$21:H$25,2)","v":"D"},{"$f":"COUNTIF(E2:L2,\">=8\")","v":5},{"$f":"COUNTIF(E2:L2,\"=5\")","v":2},{"$f":"COUNTIF(E2:L2,\"=0\")","v":0},{"$f":"8-COUNT(E2:L2)","v":1},{"$f":"VLOOKUP((DX2*BX$17+DY2*BX$18+DZ2*BX$20+EA2*BX$19),BW$23:BX$27,2)","v":"Troublesome"},{"$f":"COUNTIF(M2:T2,\">51\")","v":1},{"$f":"COUNTIF(M2:T2,\">=44\")-BB2","v":2},{"$f":"COUNTIF(M2:T2,\">=36\")-(BB2+BC2)","v":3},{"$f":"COUNTIF(M2:T2,\">=30\")-SUM(BB2:BD2)","v":2},{"$f":"COUNTIF(M2:T2,\"<30\")","v":0},{"$f":"COUNTIF(M2:T2,\"<=18\")","v":0},{"$f":"VLOOKUP(((EB2+EC2)*BX$40+ED2*BX$43+EE2*BX$41+(EF2-EG2)*BX$39+EG2*BX$42),BW$47:BX$51,2)","v":"Troublesome"},null,{"$f":"(SUM(E2:J2)+2*SUM(K2:L2))/10","v":8.1999999999999993},{"$f":"IF(MIN(M2:T2)<(AVERAGE(M2:T2)-12),1,0)","v":0},{"$f":"IF(STDEV(M2:T2)>12,1,0)","v":0},{"$f":"IF(U2/5<(AVERAGE(M2:T2)-12),1,0)","v":0},{"$f":"IF(U2/5>(AVERAGE(M2:T2)+10),1,0)","v":1},{"$f":"IF(BK2=1,\"lt\",\"\")","v":""},{"$f":"IF(BL2=1,\"ts\",\"\")","v":""},{"$f":"IF(BM2=1,\"lf\",\"\")","v":""},{"$f":"IF(BN2=1,\"hf\",\"\")","v":"hf"},{"$f":"IF(SUM(BK2:BN2)=0,\"\",CONCATENATE(\"fl:\",BO2,BP2,BQ2,BR2))","v":"fl:hf"},{"$f":"IF(CA2<0,0,IF(CA2>20,1,CA2/20))","v":0.75},{"$f":"VLOOKUP((U2/3),G$21:H$25,2)","v":"A"},{"$f":"AA2-AU2","v":16.595238095238095},{"$f":"U2/3-AA2","v":20.30952380952381},{"$f":"VLOOKUP(BV2,E$42:F$46,2)","v":"MI"},{"$f":"VLOOKUP(BW2,E$49:F$53,2)","v":"MI"},{"$f":"VLOOKUP(V2,G$21:H$25,2)","v":"B"},{"$f":"(3*AW2+AX2+0*AY2+-2*AZ2)","v":15},{"$f":"SUM(E2:G2)/3","v":5},{"$f":"MAX(CD2:CE2)","v":33.333333333333336},{"$f":"SUM(M2:O2)/3","v":33.333333333333336},0,{"$f":"SUM(E2:I2)/5","v":7.4},{"$f":"MAX(CH2:CI2)","v":37.4},{"$f":"SUM(M2:Q2)/5","v":37.4},null,{"$f":"8-CL2","v":8},{"$f":"(SUM(E2:J2)+2*SUM(K2:L2))/10","v":8.1999999999999993},null,{"$f":"MAX(CN2:CO2)","v":41.75},{"$f":"SUM(M2:T2)/CJ2","v":41.75},0,null,null,{"$f":"AU2","v":54.761904761904766},{"$f":"AK2","v":64},{"$f":"AA2","v":71.357142857142861},{"$f":"V2","v":77.45},{"$f":"(CS2-CR2)/(5-3)","v":4.6190476190476168},{"$f":"(CT2-CS2)/(8-5)","v":2.4523809523809539},{"$f":"CU2-CT2","v":6.0928571428571416},{"$f":"DEGREES(ATAN(CV2))","v":77.784280865869135},{"$f":"DEGREES(ATAN(CW2))","v":67.81598665473004},{"$f":"DEGREES(ATAN(CX2))","v":80.679336904937571},{"$f":"IF(M2=\"\",\"\",VLOOKUP(M2,$K$21:$L$26,2))","v":"D"},"D","C","C","B","C","B","A",null,null,{"$f":"COUNTIF(E2:I2,\">=8\")","v":3},{"$f":"COUNTIF(E2:I2,\"=5\")","v":1},{"$f":"COUNTIF(E2:I2,\"=0\")","v":0},{"$f":"5-COUNT(E2:I2)","v":1},{"$f":"COUNTIF(M2:Q2,\">51\")","v":0},{"$f":"COUNTIF(M2:Q2,\">=44\")-DP2","v":1},{"$f":"COUNTIF(M2:Q2,\">=36\")-(DP2+DQ2)","v":2},{"$f":"COUNTIF(M2:Q2,\">=30\")-SUM(DP2:DR2)","v":2},{"$f":"COUNTIF(M2:Q2,\"<30\")","v":0},{"$f":"COUNTIF(M2:Q2,\"<=18\")","v":0},null,null,{"$f":"COUNTIF(E2:G2,\">=8\")","v":1},{"$f":"COUNTIF(E2:G2,\"=5\")","v":1},{"$f":"COUNTIF(E2:G2,\"=0\")","v":0},{"$f":"3-COUNT(E2:G2)","v":1},{"$f":"COUNTIF(M2:O2,\">51\")","v":0},{"$f":"COUNTIF(M2:O2,\">=44\")-EB2","v":0},{"$f":"COUNTIF(M2:O2,\">=36\")-(EB2+EC2)","v":1},{"$f":"COUNTIF(M2:O2,\">=30\")-SUM(EB2:ED2)","v":2},{"$f":"COUNTIF(M2:O2,\"<30\")","v":0},{"$f":"COUNTIF(M2:O2,\"<=18\")","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     "]
[]
[]
[]
[null,null,null,null,null,"F","D","D+","C-","C","C+","B-","B","B+","A-","A"]
[null,null,null,null,null,0,50,53,57,60,64,69,73,77,82,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"COUNTIF(AL$2:AL$2,AK9)","v":0}]
[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,"B",{"$f":"COUNTIF(AL$2:AL$2,AK10)","v":0}]
[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,"C",{"$f":"COUNTIF(AL$2:AL$2,AK11)","v":1}]
[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,"D",{"$f":"COUNTIF(AL$2:AL$2,AK12)","v":0}]
[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,"F",{"$f":"COUNTIF(AL$2:AL$2,AK13)","v":0}]
[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,"MF",{"$f":"COUNTIF(AK2:AK2,\"<30\")","v":0},null,null,null,null,null,null,null,null,"MF",{"$f":"COUNTIF(AU2:AU2,\"<30\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(M2:M11)","v":51.5},54.5,60,63.5,45,41,48,58,{"$f":"AVERAGE(U2:U2)","v":275}]
[null,null,null,null,null,null,null,null,null,null,null,"Diff Fact",{"$f":"M15/AVERAGE($M15:$T15)","v":0.97746144721233685},1.0344009489916963,1.1387900355871887,1.2052194543297745,0.85409252669039148,0.77817319098457893,0.91103202846975084,1.1008303677342823,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,"HW Ass Rate Table"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"A",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FExam D",{"$f":"AVERAGE(M15:T15)/(U15/5)","v":0.9579545454545455},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,"M",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FE Fact",{"$f":"1+(V18-1)/2","v":0.97897727272727275},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,"S",-20]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"U",0]
[null,null,null,null,0,"F",0,"F",null,null,0,"MF",{"$f":"COUNTIF(DB$2:DB$11,$L21)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,50,"D",50,"D",null,null,19,"F ",0,0,0,0,0,0,0,0,"A",{"$f":"COUNTIF(W$2:W$2,\"A\")+COUNTIF(W$2:W$2,\"A-\")","v":0},{"$f":"V22/SUM(V$22:V$27)","v":0}]
[null,null,null,null,53,"D+",60,"C",null,null,30,"D",1,1,0,0,0,0,0,0,"B",{"$f":"COUNTIF(W$2:W$2,\"B\")+COUNTIF(W$2:W$2,\"B-\")+COUNTIF(W$2:W$2,\"B+\")","v":1},0.1111111111111111,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,-100,"Very Serious"]
[null,null,null,null,57,"C-",73,"B",null,null,36,"C",0,0,1,1,0,1,0,0,"C",{"$f":"COUNTIF(W$2:W$2,\"C\")+COUNTIF(W$2:W$2,\"C-\")+COUNTIF(W$2:W$2,\"C+\")","v":0},0,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,10,"Serious"]
[null,null,null,null,60,"C",85,"A",null,null,43,"B",0,0,0,0,1,0,1,0,"D",{"$f":"COUNTIF(W$2:W$2,\"D\")+COUNTIF(W$2:W$2,\"D+\")","v":0},0,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,40,"Troublesome"]
[null,null,null,null,64,"C+",null,null,null,null,51,"A",0,0,0,0,0,0,0,1,"F",{"$f":"COUNTIF(W$2:W$2,\"F\")","v":0},0,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,60,"OK"]
[null,null,null,null,69,"B-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W",8,0.88888888888888884,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,120,"Outstanding"]
[null,null,null,null,73,"B"]
[null,null,null,null,77,"B+"]
[null,null,null,null,82,"A-"]
[null,null,null,null,85,"A"]
[]
[]
[null,null,null,null,0,0]
[null,null,null,null,5,0.35]
[null,null,null,null,6,0.5]
[null,null,null,null,7,0.75]
[null,null,null,null,8,1]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Failed",-20]
["No Students",{"$f":"COUNTA(B2:B11)","v":1},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,null,null,null,null,null,null,null,null,null,null,"Good",50]
[null,null,null,null,"Term Trend",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,null,null,null,null,null,null,null,"Marginal",0]
[null,null,null,null,-100,"MD",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,null,null,null,null,null,null,"Miserable",-50]
[null,null,null,null,-8,"D",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,null,null,null,null,null,null,"OK",15]
[null,null,null,null,-2.5,"C"]
[null,null,null,null,1.5,"I"]
[null,null,null,null,4,"MI"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,-200,"Very Serious"]
[null,null,null,null,"Final Trend",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,null,null,null,null,null,null,null,-60,"Serious"]
[null,null,null,null,-100,"MD",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,null,null,null,null,null,null,0,"Troublesome"]
[null,null,null,null,-12,"D",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,null,null,null,null,null,null,45,"OK"]
[null,null,null,null,-5,"C",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,null,null,null,null,null,null,110,"Great Performance"]
[null,null,null,null,5,"I"]
[null,null,null,null,15,"MI"]