{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Sheet1","index":0,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,2,13,3],[14,2,14,3],[15,2,15,3],[0,0,0,3]]}
["HS ART"]
[null,"Student Name (Last and First)","Score","Target Met?",null,null,null,"Score Criteria","Score Validation","SGP Validation",null,"High Growth Counter","Typical Growth Counter","Low Growth Counter","Score Counted for Data Counter","High + Count","Typical + Count","Low + Count"]
[1,null,null,{"$f":"IF((Score>=Cut_Score),\"YES\",\"NO\")","v":"NO"},null,null,null,0,{"$f":"IF(OR(Score<Min_Score,Score>Max_Score),invalidscore(),\"OK\")","v":"OK"},{"$f":"IF(C3>=100,InvalidSGP())","v":false},"YES",{"$f":"COUNTIF(C23,\"HIGH\")","v":0},{"$f":"COUNTIF(C23,\"TYPICAL\")","v":0},{"$f":"COUNTIF(C23,\"LOW\")","v":0},{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$f":"L3+O3","v":{"$error":"#REF!"}},{"$f":"M3+O3","v":{"$error":"#REF!"}},{"$f":"N3+O3","v":{"$error":"#REF!"}}]
[2,null,null,"NO",null,null,null,30,null,{"$f":"IF(C4>=100,InvalidSGP())","v":false},"NO",{"$f":"COUNTIF(D4,\"HIGH\")","v":0},{"$f":"COUNTIF(D4,\"TYPICAL\")","v":0},{"$f":"COUNTIF(D4,\"LOW\")","v":0},{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$f":"L4+O4","v":{"$error":"#REF!"}},{"$f":"M4+O4","v":{"$error":"#REF!"}},{"$f":"N4+O4","v":{"$error":"#REF!"}}]
[3,null,null,"NO",null,null,null,11,null,{"$f":"IF(C5>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[4,null,null,"NO",null,null,null,null,null,{"$f":"IF(C6>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[5,null,null,"NO",null,null,null,null,null,{"$f":"IF(C7>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[6,null,null,"NO",null,null,null,null,null,{"$f":"IF(C8>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[7,null,null,"NO",null,null,null,null,null,{"$f":"IF(C9>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[8,null,null,"NO",null,null,null,null,null,{"$f":"IF(C10>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[9,null,null,"NO",null,null,null,null,null,{"$f":"IF(C11>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[10,null,null,"NO",null,null,null,null,null,{"$f":"IF(C12>=100,InvalidSGP())","v":false},null,0,0,0,{"$f":"COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"Highly Effective (HE):","8 or more students Met Target"]
[null,"Teacher",", ",null,null,"Effective (E):","6 or 7 students Met Target"]
[null,"Total Met Target",{"$f":"COUNTIF(Target_Met?,\"YES\")","v":0},null,null,"Improvement Necessary (IN):","3 to 5 students Met Target"]
[null,"Rating",{"$f":"IF(AND(Counter1>=0,Counter1<3), \"IE\", IF(AND(Counter1>=3,Counter1<6),\"IN\",IF(AND(Counter1>=6,Counter1<8),\"E\",IF(AND(Counter1>=8),\"HE\"))))","v":"IE"},null,null,"Ineffective (IE):","Less than 3 students Met Target"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}