{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Base","Summary"],"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":14,"n_cols":1,"rows_kept":14}
["This template is provided as a tool to quickly determine which classes are compliant in a class size and composition extract file.  BEFORE USING, THIS TEMPLATE MUST BE ADJUSTED TO REFLECT DISTRICT AGREEMENTS AND RULES."]
[]
["NB - This workbook is based upon class size and composition rules contained in the LOU 17 Memorandum of Agreement Implementation Guide. For the most part, these rules reflect limits contained in the Memorandum of Understanding or the School Act.  Districts must modify the these rules to conform with district agreements."]
[]
["To use this workbook:\n"]
["1) In the BASE spreadsheet, adjust maximums for each grade level in the in the YELLOW cells.  These values should reflect local agreements and/or the Memorandum of Understanding, but must not exceed the limits contained in the School Act."]
[]
["2)  In the BASE spreadsheet, set the class maximum adjustments for each designation in the BLUE cells (i.e., the amount that the allowable class maximum will be reduced for each student with the designation)."]
[]
["3) In the BASE spreadsheet, cut and paste the contents of the class size and composition extract file into the TAN cells.\n\nNote: Because the class size and composition extract is a file generated from MyEducation BC in .CSV format, you may want to open a temporary Excel spreadsheet and load the .CSV file to simplify copying the data into this workbook.  Use cut and paste to copy the cells into the appropriate area in the BASE spreadsheet."]
[]
["4) In the BASE spreadsheet, select the three left-most columns of numbers (Columns A-C: Total, Maximum and Composition Adjustment) and drag them downwards until they align with each entry in the class size and composition extract."]
[]
["5) In the SUMMARY spreadsheet, select the nine left-most columns of numbers (Columns A-I) and drag them downwards until they show one line for each of entry in the class size and composition extract."]

{"sheet":"Base","index":1,"n_rows":16,"n_cols":36,"rows_kept":16}
[{"$nulls":4},"1-Subj","2-Class","3-Sect","4-KH","5-KF","6-Gr1","7-Gr2","8-Gr3","9-Gr4","10-Gr5","11-Gr6","12-Gr7","13-Gr8","14-Gr9","15-Gr10","16-Gr11","17-Gr12","18-EA","19-(A)","20-(B)","21-( C )","22-(D)","23( E )","24-(F)","25-(G)","26-(H)","27-(K)","28-(P)","29-(Q)","30-( R)","31-ESL","32-Meets limits"]
[]
[{"$nulls":7},20,20,22,22,22,30,30,30,30,30,30,30,30,30,null,1,1,1,1,1,1,1,1,1,1,1,1,0]
[]
["Total","Maximum ","Composition Adjustment"]
[]
[{"$f":"SUM(H7:U7)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AND(L7<>0,M7<>0),MIN(24,(L$3+M$3)/2),IF(H7<>0,H$3,IF(I7<>0,I$3,IF(J7<>0,J$3,IF(K7<>0,K$3,IF(L7<>0,L$3,IF(M7<>0,M$3,IF(N7<>0,N$3,IF(O7<>O$3,O$3,IF(P7<>0,P$3,IF(Q7<>0,Q$3,IF(R7<>0,R$3,IF(S7<>0,S$3,IF(T7<>0,T$3,U$3))))))))))))))","v":{"v":30,"d":"30.0"}},{"$f":"(W$3*W7)+(X$3*X7)+(Y$3*Y7)+(Z$3*Z7)+(AA$3*AA7)+(AB$3*AB7)+(AC$3*AC7)+(AD$3*AD7)+(AE$3*AE7)+(AF$3*AF7)+(AG$3*AG7)+(AH$3*AH7)+(AI$3*AI7)","v":{"v":0,"d":"0.0"}}]
[{"$f":"SUM(H8:U8)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AND(L8<>0,M8<>0),MIN(24,(L$3+M$3)/2),IF(H8<>0,H$3,IF(I8<>0,I$3,IF(J8<>0,J$3,IF(K8<>0,K$3,IF(L8<>0,L$3,IF(M8<>0,M$3,IF(N8<>0,N$3,IF(O8<>O$3,O$3,IF(P8<>0,P$3,IF(Q8<>0,Q$3,IF(R8<>0,R$3,IF(S8<>0,S$3,IF(T8<>0,T$3,U$3))))))))))))))","v":{"v":30,"d":"30.0"}},{"$f":"(W$3*W8)+(X$3*X8)+(Y$3*Y8)+(Z$3*Z8)+(AA$3*AA8)+(AB$3*AB8)+(AC$3*AC8)+(AD$3*AD8)+(AE$3*AE8)+(AF$3*AF8)+(AG$3*AG8)+(AH$3*AH8)+(AI$3*AI8)","v":{"v":0,"d":"0.0"}}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":30,"d":"30.0"},{"v":0,"d":"0.0"}]

{"sheet":"Summary","index":2,"n_rows":21,"n_cols":9,"rows_kept":21}
["Subject","Class","Section",null,"Total","Maximum","Composition Adjustment"]
[]
[]
[]
[{"$f":"Base!E7","v":0},{"$f":"Base!F7","v":0},{"$f":"Base!G7","v":0},null,{"$f":"Base!A7","v":{"v":0,"d":"0.0"}},{"$f":"Base!B7","v":{"v":30,"d":"30.0"}},{"$f":"Base!C7","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(E5>F5-G5,\"Class not compliant\",\"\")","v":""}]
[{"$f":"Base!E8","v":0},{"$f":"Base!F8","v":0},{"$f":"Base!G8","v":0},null,{"$f":"Base!A8","v":{"v":0,"d":"0.0"}},{"$f":"Base!B8","v":{"v":30,"d":"30.0"}},{"$f":"Base!C8","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(E6>F6-G6,\"Class not compliant\",\"\")","v":""}]
[{"$f":"Base!E9","v":0},{"$f":"Base!F9","v":0},{"$f":"Base!G9","v":0},null,{"$f":"Base!A9","v":{"v":0,"d":"0.0"}},{"$f":"Base!B9","v":{"v":30,"d":"30.0"}},{"$f":"Base!C9","v":{"v":0,"d":"0.0"}},null,""]
[{"$f":"Base!E10","v":0},{"$f":"Base!F10","v":0},{"$f":"Base!G10","v":0},null,{"$f":"Base!A10","v":{"v":0,"d":"0.0"}},{"$f":"Base!B10","v":{"v":30,"d":"30.0"}},{"$f":"Base!C10","v":{"v":0,"d":"0.0"}},null,""]
[{"$f":"Base!E11","v":0},{"$f":"Base!F11","v":0},{"$f":"Base!G11","v":0},null,{"$f":"Base!A11","v":{"v":0,"d":"0.0"}},{"$f":"Base!B11","v":{"v":30,"d":"30.0"}},{"$f":"Base!C11","v":{"v":0,"d":"0.0"}},null,""]
[{"$f":"Base!E12","v":0},{"$f":"Base!F12","v":0},{"$f":"Base!G12","v":0},null,{"$f":"Base!A12","v":{"v":0,"d":"0.0"}},{"$f":"Base!B12","v":{"v":30,"d":"30.0"}},{"$f":"Base!C12","v":{"v":0,"d":"0.0"}},null,""]
[{"$f":"Base!E13","v":0},{"$f":"Base!F13","v":0},{"$f":"Base!G13","v":0},null,{"$f":"Base!A13","v":{"v":0,"d":"0.0"}},{"$f":"Base!B13","v":{"v":30,"d":"30.0"}},{"$f":"Base!C13","v":{"v":0,"d":"0.0"}},null,""]
[{"$f":"Base!E14","v":0},{"$f":"Base!F14","v":0},{"$f":"Base!G14","v":0},null,{"$f":"Base!A14","v":{"v":0,"d":"0.0"}},{"$f":"Base!B14","v":{"v":30,"d":"30.0"}},{"$f":"Base!C14","v":{"v":0,"d":"0.0"}},null,""]
[{"$f":"Base!E15","v":0},{"$f":"Base!F15","v":0},{"$f":"Base!G15","v":0},null,{"$f":"Base!A15","v":{"v":0,"d":"0.0"}},{"$f":"Base!B15","v":{"v":30,"d":"30.0"}},{"$f":"Base!C15","v":{"v":0,"d":"0.0"}},null,""]
[{"$f":"Base!E16","v":0},{"$f":"Base!F16","v":0},{"$f":"Base!G16","v":0},null,{"$f":"Base!A16","v":{"v":0,"d":"0.0"}},{"$f":"Base!B16","v":{"v":30,"d":"30.0"}},{"$f":"Base!C16","v":{"v":0,"d":"0.0"}},null,""]
[{"$nulls":8},{"$f":"IF(E15>F15-G15,\"Course not compliant\",\"\")","v":""}]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]