{"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":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[52,2,52,3],[53,1,53,3],[54,1,54,3],[18,1,18,3],[20,0,20,5],[34,2,34,3],[35,1,35,3],[36,1,36,3],[38,0,38,5],[17,1,17,3],[0,0,0,5],[1,0,1,5],[2,0,2,5],[2,7,4,7],[16,2,16,3]]}
["ONLY Title I Schools - Student to Instructional-Staff Salary Expenditure Ratio"]
["This is a special use worksheet for comparing average salary expenditure per student at each school at each school  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 ."]
["Title I School Name","Grade Span","October 1 Student Enrollment","Amount of Instructional Staff Base Salaries ","Salary Expenditure per Pupil \n(Calculation of Column 4/3)","Comparable"]
[null,null,null,0,{"$f":"D5/C5","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E5<$E$19, E5>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D6/C6","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E6<$E$19, E6>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E7<$E$19, E7>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E8<$E$19, E8>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E9<$E$19, E9>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E10<$E$19, E10>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E11<$E$19, E11>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E12<$E$19, E12>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E13<$E$19, E13>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E14<$E$19, E14>$E$18), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
["Totals",null,{"$f":"SUM(C5:C15)","v":0},{"$f":"SUM(D5:D15)","v":0}]
[null,null,"AVG Salary Expenditure per Pupil ",null,{"$f":"D16/C16","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Elementary Salary Expenditure per Pupil ",null,null,{"$f":"E17*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Elementary AVG Salary Expenditure per Pupil ",null,null,{"$f":"E17*1.1","v":{"$error":"#DIV/0!"}}]
[]
["Middle Schools"]
["Title I School Name","Grade Span","October 1 Student Enrollment","Amount of Instructional Staff Base Salaries ","Salary Expenditure per Pupil \n(Calculation of Column 4/3)","Comparable"]
[null,null,null,0,{"$f":"D23/C23","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E23<$E$37, E23>$E$36), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D24/C24","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E24<$E$37, E24>$E$36), \"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(C23:C33)","v":0},{"$f":"SUM(D23:D33)","v":0}]
[null,null,"AVG Salary Expenditure per Pupil ",null,{"$f":"D34/C34","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Middle School  AVG Salary Expenditure per Pupil ",null,null,{"$f":"E35*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Middle School AVG Salary Expenditure per Pupil ",null,null,{"$f":"E35*1.1","v":{"$error":"#DIV/0!"}}]
[]
["High Schools"]
["Title I School Name","Grade Span","October 1 Student Enrollment","Amount of Instructional Staff Base Salaries ","Salary Expenditure per Pupil \n(Calculation of Column 4/3)","Comparable"]
[null,null,null,0,{"$f":"D41/C41","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E41<$E$55, E41>$E$54), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D42/C42","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E42<$E$55, E42>$E$54), \"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(C41:C51)","v":0},{"$f":"SUM(D41:D51)","v":0}]
[null,null,"AVG Salary Expenditure per Pupil ",null,{"$f":"D52/C52","v":{"$error":"#DIV/0!"}}]
[null,"90% of the High School AVG Salary Expenditure per Pupil ",null,null,{"$f":"E53*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the High School AVG Salary Expenditure per Pupil ",null,null,{"$f":"E53*1.1","v":{"$error":"#DIV/0!"}}]

{"sheet":"Title I and Non-Title I Schools","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[40,1,40,3],[19,1,19,3],[0,0,0,5],[1,0,1,5],[3,7,5,7],[17,2,17,3],[18,1,18,3],[38,2,38,3],[39,1,39,3]]}
["BOTH Title I and Non-Title I Schools - Student to Instructional-Staff Salary Expenditure Ratio"]
["This is a special use worksheet for comparingaverage salary expenditure per student at each school for LEAs with Title I and Non-Title I schools. "]
[]
["Title I - School Names","Grade Span","October 1 Student Enrollment","Amount of Instructional Staff Base Salaries ","Salary Expenditure per Pupil \n(Calculation of Column 4/3)","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":"D5/C5","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E5<$E$41, E5>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D6/C6","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E6<$E$41, E6>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E7<$E$41, E7>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E8<$E$41, E8>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E9<$E$41, E9>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E10<$E$41, E10>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E11<$E$41, E11>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E12<$E$41, E12>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E13<$E$41, E13>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E14<$E$41, E14>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D15/C15","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E15<$E$41, E15>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
["Totals",null,{"$f":"SUM(C5:C16)","v":0},{"$f":"SUM(D5:D16)","v":0}]
[null,null,"Title I AVG Salary Expenditure per Pupil ",null,{"$f":"D17/C17","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Title I AVG Salary Expenditure per Pupil ",null,null,{"$f":"E18*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Title I AVG Salary Expenditure per Pupil ",null,null,{"$f":"E18*1.1","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
["Non-Title I - School Names","Grade Span","October 1 Student Enrollment","Amount of Instructional Staff Base Salaries ","Salary Expenditure per Pupil \n(Calculation of Column 4/3)","Comparable within Non-Title I"]
[null,null,null,0,{"$f":"D26/C26","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E26<$E$41, E26>$E$40), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D27/C27","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E27<$E$41, E27>$E$40), \"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(C26:C37)","v":0},{"$f":"SUM(D26:D37)","v":0}]
[null,null,"Non-Title I AVG Salary Expenditure per Pupil ",null,{"$f":"D38/C38","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Non-Title I AVG Salary Expenditure per Pupil ",null,null,{"$f":"E39*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Non-Title I AVG Salary Expenditure per Pupil ",null,null,{"$f":"E39*1.1","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Difference between AVG Non-Title I Schools and AVG Title I Schools",null,null,null,{"$f":"E39-E18","v":{"$error":"#DIV/0!"}}]
[null,"(for informational pusporses ONLY)"]