{"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":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[54,2,54,3],[55,1,55,3],[56,1,56,3],[20,1,20,3],[22,0,22,5],[36,2,36,3],[37,1,37,3],[38,1,38,3],[40,0,40,5],[19,1,19,3],[0,0,0,5],[1,0,1,5],[2,0,2,5],[2,7,4,7],[18,2,18,3]]}
["ONLY Title I Schools - Per Pupil Expenditure"]
["This is a special use worksheet for comparing average purchase of instructional materials per student 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","State & Local Funds Allocated for Expenditures","Expenditure Per Pupil","Comparable within Elementary"]
[null,null,null,0,{"$f":"D5/C5","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E5<$E$21, E5>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D6/C6","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E6<$E$21, E6>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E7<$E$21, E7>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E8<$E$21, E8>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E9<$E$21, E9>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E10<$E$21, E10>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E11<$E$21, E11>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E12<$E$21, E12>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E13<$E$21, E13>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D14/C14","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E14<$E$21, E14>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D15/C15","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E15<$E$21, E15>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E16<$E$21, E16>$E$20), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
["Totals",null,{"$f":"SUM(C5:C17)","v":0},{"$f":"SUM(D5:D17)","v":0}]
[null,null,"AVG Expenditure per-Pupil ratio",null,{"$f":"D18/C18","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Elementary per-Pupil amount",null,null,{"$f":"E19*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Elementary per-Pupil amount",null,null,{"$f":"E19*1.1","v":{"$error":"#DIV/0!"}}]
[]
["Middle Schools"]
["School Name","Grade Span","October 1 Student Enrollment","State & Local Funds Allocated for Expenditures","Expenditure Per Pupil","Comparable within Middle"]
[null,null,null,0,{"$f":"D25/C25","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E25<$E$39, E25>$E$38), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D26/C26","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E26<$E$39, E26>$E$38), \"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(C25:C35)","v":0},{"$f":"SUM(D25:D35)","v":0}]
[null,null,"AVG Expenditure per-Pupil ratio",null,{"$f":"D36/C36","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Middle School per-Pupil amount",null,null,{"$f":"E37*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Middle School per-Pupil amount",null,null,{"$f":"E37*1.1","v":{"$error":"#DIV/0!"}}]
[]
["High Schools"]
["School Name","Grade Span","October 1 Student Enrollment","State & Local Funds Allocated for Expenditures","Expenditure Per Pupil","Comparable within High School"]
[null,null,null,0,{"$f":"D43/C43","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E43<$E$57, E43>$E$56), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D44/C44","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E44<$E$57, E44>$E$56), \"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(C43:C53)","v":0},{"$f":"SUM(D43:D53)","v":0}]
[null,null,"AVG Expenditure per-Pupil ratio",null,{"$f":"D54/C54","v":{"$error":"#DIV/0!"}}]
[null,"90% of the High School per-Pupil amount",null,null,{"$f":"E55*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the High School per-Pupil amount",null,null,{"$f":"E55*1.1","v":{"$error":"#DIV/0!"}}]

{"sheet":"Title I and Non-Title I Schools","index":1,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[52,1,52,3],[24,1,24,3],[0,0,0,5],[1,0,1,5],[2,7,4,7],[22,2,22,3],[23,1,23,3],[50,2,50,3],[51,1,51,3]]}
["Both Title I and Non-Title I Schools - Per Pupil Expenditure"]
["This is a special use worksheet for comparing average purchase of instructional materials per student for LEAs with both Title I and Non-Title I schools. "]
["Title I School Names","Grade Span","October 1 Student Enrollment","State & Local Funds Allocated for Expenditures","Expenditure Per Pupil","Title I Comparable to Non-Title I schools",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":"D4/C4","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E4<$E$53, E4>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D5/C5","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E5<$E$53, E5>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E6<$E$53, E6>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E7<$E$53, E7>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E8<$E$53, E8>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E9<$E$53, E9>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E10<$E$53, E10>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E11<$E$53, E11>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E12<$E$53, E12>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E13<$E$53, E13>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D14/C14","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E14<$E$53, E14>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E15<$E$53, E15>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E16<$E$53, E16>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E17<$E$53, E17>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E18<$E$53, E18>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E19<$E$53, E19>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$error":"#DIV/0!"},{"$f":"IF(AND(E20<$E$53, E20>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
["Totals",null,{"$f":"SUM(C4:C21)","v":0},{"$f":"SUM(D4:D21)","v":0}]
[null,null,"Title I AVG Expenditure per pupil Ratio",null,{"$f":"D22/C22","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Title I per-Pupil amount",null,null,{"$f":"E23*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Title I per-Pupil amount",null,null,{"$f":"E23*1.1","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
["Non-Title I School Names","Grade Span","October 1 Student Enrollment","State & Local Funds Allocated for Expenditures","Expenditure Per Pupil","Comparable within Non-Title I"]
[null,null,null,0,{"$f":"D32/C32","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E32<$E$53, E32>$E$52), \"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,{"$f":"D33/C33","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E33<$E$53, E33>$E$52), \"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!"}]
[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(C32:C49)","v":0},{"$f":"SUM(D32:D49)","v":0}]
[null,null,"Non-Title I AVG Expenditure per-pupil Ratio",null,{"$f":"D50/C50","v":{"$error":"#DIV/0!"}}]
[null,"90% of the Non-Title I per-Pupil amount",null,null,{"$f":"E51*0.9","v":{"$error":"#DIV/0!"}}]
[null,"110% of the Non-Title I per-Pupil amount",null,null,{"$f":"E51*1.1","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Difference between AVG Non-Title I Schools and AVG Title I Schools",null,null,null,{"$f":"E51-E23","v":{"$error":"#DIV/0!"}}]
[null,"(for informational pusporses ONLY)"]