{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["All Title I Schools","Title I and Non-Title I Schools"],"not_rendered":{"charts":0,"images":0,"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":"All Title I Schools","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,1,18,3],[0,0,0,5],[1,0,1,5],[2,0,2,5],[2,7,4,7],[17,2,17,3],[53,2,53,3],[54,1,54,3],[55,1,55,3],[19,1,19,3],[21,0,21,5],[35,2,35,3],[36,1,36,3],[37,1,37,3],[39,0,39,5]]}
["ONLY Title I Schools -  Student to Instructional-Staff Ratio"]
["This is a special use worksheet for comparing average number of students per instructional staff each school per grade span for LEAs with all Title I schools. "]
["Elementary Schools",null,null,null,null,null,null,"Fill in the Yellow  area only\n\nTo add additional rows for Schools, click on the blank row below the yellow section you intend to expand, and then click on button, \"Add Row\"  to right ."]
["School Name","Grade Span","October 1 Student Enrollment","Total FTE","Student-to-Staff Ratio\n(Calculation of Column 3/4)","Comparable"]
[null,null,null,0,{"$f":"C5/D5","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E5<$E$20, E5>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"C6/D6","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E6<$E$20, E6>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E7<$E$20, E7>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E8<$E$20, E8>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E9<$E$20, E9>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E10<$E$20, E10>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E11<$E$20, E11>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E12<$E$20, E12>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E13<$E$20, E13>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E14<$E$20, E14>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E15<$E$20, E15>$E$19), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
["Totals",null,{"$f":"SUM(C5:C16)","v":0},{"$f":"SUM(D5:D16)","v":0}]
[null,null,"AVG Student to Staff Ratio",null,{"$f":"C17/D17","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Elementary AVG Student to Staff Ratio",null,null,{"$f":"E18*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Elementary AVG Student to Staff Ratio",null,null,{"$f":"E18*1.1","v":{"$error":"#DIV/0!"}}]
[]
["Middle Schools"]
["School Name","Grade Span","October 1 Student Enrollment","Total FTE","Student-to-Staff Ratio\n(Calculation of Column 3/4)","Comparable"]
[null,null,null,0,{"$f":"C24/D24","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E24<$E$38, E24>$E$37), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"C25/D25","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E25<$E$38, E25>$E$37), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Totals",null,{"$f":"SUM(C24:C34)","v":0},{"$f":"SUM(D24:D34)","v":0}]
[null,null,"AVG Student to Staff Ratio",null,{"$f":"C35/D35","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Middle School AVG Student to Staff Ratio",null,null,{"$f":"E36*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Middle School AVG Student to Staff Ratio",null,null,{"$f":"E36*1.1","v":{"$error":"#DIV/0!"}}]
[]
["High Schools"]
["School Name","Grade Span","October 1 Student Enrollment","Total FTE","Student-to-Staff Ratio\n(Calculation of Column 3/4)","Comparable"]
[null,null,null,0,{"$f":"C42/D42","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E42<$E$56, E42>$E$55), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"C43/D43","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E43<$E$56, E43>$E$55), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Totals",null,{"$f":"SUM(C42:C52)","v":0},{"$f":"SUM(D42:D52)","v":0}]
[null,null,"AVG Student to Staff Ratio",null,{"$f":"C53/D53","v":{"$error":"#DIV/0!"}}]
[null,"90% of the High School AVG Student to Staff Ratio",null,null,{"$f":"E54*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the High School AVG Student to Staff Ratio",null,null,{"$f":"E54*1.1","v":{"$error":"#DIV/0!"}}]

{"sheet":"Title I and Non-Title I Schools","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[39,1,39,3],[18,1,18,3],[0,0,0,5],[1,0,1,5],[2,7,4,7],[16,2,16,3],[17,1,17,3],[37,2,37,3],[38,1,38,3]]}
["BOTH Title I and Non-Title I Schools - Student to Instructional-Staff Ratio"]
["This is a special use worksheet for comparing average number of students per instructional staff each school per grade span  for LEAs with Title I and Non-Title I schools. "]
["Title I School Name","Grade Span","October 1 Student Enrollment","Total FTE","Student-to-Staff Ratio\n(Calculation of Column 3/4)","Title I Comparable to non-Title I",null,"Fill in the Yellow  area only\n\nTo add additional rows for Schools, click on the blank row below the yellow section you intend to expand, and then click on button, \"Add Row\"  to right ."]
[null,null,null,0,{"$f":"C4/D4","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E4<$E$40, E4>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"C5/D5","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E5<$E$40, E5>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E6<$E$40, E6>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E7<$E$40, E7>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E8<$E$40, E8>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E9<$E$40, E9>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E10<$E$40, E10>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E11<$E$40, E11>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E12<$E$40, E12>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"C13/D13","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E13<$E$40, E13>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E14<$E$40, E14>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
["Totals",null,{"$f":"SUM(C4:C14)","v":0},{"$f":"SUM(D4:D14)","v":0}]
[null,null,"Title I AVG Student to Staff Ratio",null,{"$f":"C16/D16","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Title I AVG Student to Staff Ratio",null,null,{"$f":"E17*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Title I AVG Student to Staff Ratio",null,null,{"$f":"E17*1.1","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
["Non-Title I School Name","Grade Span","October 1 Student Enrollment","Total FTE","Student-to-Staff Ratio\n(Calculation of Column 3/4)","Comparable within Non-Title I"]
[null,null,null,0,{"$f":"C25/D25","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E25<$E$40, E25>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"C26/D26","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E26<$E$40, E26>$E$39), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Totals",null,{"$f":"SUM(C25:C36)","v":0},{"$f":"SUM(D25:D36)","v":0}]
[null,null,"Non-Title I AVG Student/Staff Ratio",null,{"$f":"C37/D37","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Non-Title I AVG Student to Staff Ratio",null,null,{"$f":"E38*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Non-Title I AVG Student to Staff Ratio",null,null,{"$f":"E38*1.1","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Difference between AVG Non-Title I Schools and AVG Title I Schools",null,null,null,{"$f":"E38-E17","v":{"$error":"#DIV/0!"}}]
[null,"(for informational pusporses ONLY)"]