{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Funding","Budget"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Funding","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,1,33,9],[34,1,34,9]]}
[null,"Joseph McAvinnue Elementary School"]
[null,"School Year 20-21 Budget",null,null,null,null,"Comparison to previous year budget"]
[null,"Category","Students","Weight","Amount",null,"Year","19-20","20-21","Change"]
[null,"Weights",null,null,null,null,"Enrollment",472,471.8,{"$f":"I4-H4","v":-0.19999999999998863}]
[null,"All students",471.8,4500,{"$f":"C5*D5","v":2123100},null,"FSF Budget",{"$f":"4820685-107539","v":4713146},4713146,0,"Orig Allocation was overstated by 1 GC"]
[null,"Economically disadvantaged",316,1575,497700,null,"Other Funding",{"$f":"SUM(E27:E28)","v":293767.15000000002},{"$f":"SUM(E27:E28)","v":293767.15000000002},0]
[null,"Low incoming performance",0,900,0,null,"Total Budget",{"$f":"SUM(H5:H6)","v":5006913.1500000004},5006913.1500000004,0]
[null,"Grades PreK-3",379.8,1575,598185,null,"$ per pupil",{"$f":"H7/H4","v":10607.866843220339},10612.363607460789,4.4967642404499202]
[null,"Grade 9",0,3750,0]
[null,"ELL below Level 3",70,2750,192500]
[null,"ELL Level 3 and above",83,1400,116200]
[null,"SWD substantially separate",24,22500,540000]
[null,"SWD inclusion/language",38,6250,237500]
[]
[null,"Baseline"]
[null,"ELL Baseline",null,null,0]
[null,"SWD Baseline",null,null,0]
[null,"General Ed Baseline",null,null,0]
[]
[null,"Other Policies"]
[null,"Transition amount",null,null,{"$f":"515500-107539","v":407961},"Reduced by the 1 GC overstated in current yr allocation"]
[null,"Budget Exceptions",null,null,0,"Exception Reason: "]
[]
[null,"FSF Total"]
[null,null,null,null,{"$f":"SUM(E5:E13,E16:E18,E21:E22)","v":4713146}]
[null,"Funding from outside FSF"]
[null,"Title I",null,null,{"$f":"Budget!C152","v":168725}]
[null,"Other positions provided outside of FSF",null,null,{"$f":"SUM(Budget!G87,Budget!G93,Budget!G81, Budget!G115, Budget!G139:G142)","v":125042.15000000001}]
[]
[null,"Total funding"]
[null,null,null,null,{"$f":"SUM(E25,E27,E28)","v":5006913.1500000004}]
[]
[]
[null,"Summary"]
[null,"The McAvinnue's funding decreased due to weights but was supplemented by transition policy."]

{"sheet":"Budget","index":1,"n_rows":157,"n_cols":10,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["Joseph McAvinnue Elementary School","Last year's staff","Required minimum","Budgeted Staff","Check: Sufficient Staff? ","Average Salary + Benefits","Amount","Notes","Title I Check"]
["School Year 20-21 Budget",null,null,"Budget in blank cells",null,null,{"$f":"G3-G157","v":0.20000000018626451},"Amount remaining to budget",{"$f":"B152-G152","v":0},"Amount remaining in Title I budget"]
["Positions in navy blue have been HS-only in the past",null,null,"Gray cells are budgeted for you",null,null,{"$f":"Funding!E31","v":5006913.1500000004},"Total Allocation, All Sources",{"$f":"B152","v":168725},"Title I  budget"]
["2100 Principal's Office:"]
["Principal/Coordinator",1,1,1,{"$f":"IF(D5<C5, \"Please budget additional staff\", \"Yes\")","v":"Yes"},140268,{"$f":"D5*F5","v":140268}]
["Headmaster",0,0,null,"Yes",173679.8376]
["Assistant Principal",1,null,1,"Yes",128579,{"$f":"D7*F7","v":128579}]
["House Deans",0,null,null,"Yes",141596.384716]
["Administrative Assistant",1,1,1,"Yes",56107.200000000004,{"$f":"D9*F9","v":56107.200000000004}]
[null,{"$f":"SUM(B5:B9)","v":3},2,{"$f":"SUM(D5:D9)","v":3},null,null,{"$f":"SUM(G5:G9)","v":324954.2}]
[]
["Coaches:"]
["Math Resource Teacher",1,null,1,{"$f":"IF(D13<C13, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,{"$f":"D13*F13","v":93512}]
["Literacy Specialist",1,1,1,"Yes",97985,97985]
["Instructional Specialist",0,0,null,"Yes",97985,0]
["Additional professional development coaches",null,null,null,"Yes",97985,0]
[null,{"$f":"SUM(B13:B16)","v":2},1,{"$f":"SUM(D13:D16)","v":2},null,null,{"$f":"SUM(G13:G16)","v":191497}]
[]
["General Education Teachers:"]
["Classroom Teachers"]
["PreSchool Teachers",1,1,1,{"$f":"IF(D21<C21, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,{"$f":"D21*F21","v":93512}]
["Kindergarten Teachers",4,3,4,"Yes",93512,374048]
[]
["1st Grade Teachers",4,"see below",4,"see below",93512,{"$f":"D24*F24","v":374048}]
["2nd Grade Teachers",4,"see below",4,"see below",93512,374048]
["3rd Grade Teachers",4,"see below",4,"see below",93512,374048]
["4th Grade Teachers",4,"see below",4,"see below",93512,374048]
["5th Grade Teachers",0,"see below",null,"see below",93512,0]
["6th Grade Teachers",0,"see below",null,"see below",93512,0]
["7th Grade Teachers",0,"see below",null,"see below",93512,0]
["8th Grade Teachers",0,"see below",null,"see below",93512,0]
["Loopers",0,"see below",null,"see below",93512,0]
["All Grades 1-8 Teachers",16,14,{"$f":"SUM(D24:D32)","v":16},{"$f":"IF(D33<C33, \"Please budget additional staff\", \"Yes\")","v":"Yes"}]
[]
[]
["Allied Arts "]
["Art",1,null,1,{"$f":"IF(D37<C37, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,{"$f":"D37*F37","v":93512}]
["Music",1,null,1,"Yes",93512,93512]
["Physical Education",1,1,1,"Yes",93512,93512]
["Technology Ed",0,null,null,"Yes",93512,0]
["Drama",0,null,null,"Yes",93512,0]
["ITS",0,null,null,"Yes",93512,0]
["Content Literacy",1,null,1,"Yes",93512,93512]
["Health",0,null,null,"Yes",93512,0]
["Dance",0,null,null,"Yes",93512,0]
["Library/Media Specialist",0,null,null,"Yes",108441.77525000001,0]
["Other",0,null,null,"Yes",93512,0]
[]
["Subject Teachers (High school only)"]
["Math Teachers",0,"see below",null,"see below",93512,{"$f":"D50*F50","v":0}]
["Science Teachers",0,"see below",null,"see below",93512,0]
["Social Studies Teachers",0,"see below",null,"see below",93512,0]
["English",0,"see below",null,"see below",93512,0]
["Foreign Language",0,"see below",null,"see below",93512,0]
["All HS Subject Teachers",0,0,null,{"$f":"IF(D55<C55, \"Please budget additional staff\", \"Yes\")","v":"Yes"}]
[]
["In House Suspension",0,null,null,{"$f":"IF(D57<C57, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,{"$f":"D57*F57","v":0}]
["Consumer Science",0,null,null,"Yes",93512,0]
["Business ",0,null,null,"Yes",93512,0]
["Video Production ",0,null,null,"Yes",93512,0]
["ROTC",0,null,null,"Yes",93512,0]
[]
["All General Education Teachers",{"$f":"SUM(B21:B22,B24:B32, B37:B47, B50:B54,B57:B61)","v":25},null,{"$f":"SUM(D21:D22,D24:D32, D37:D47, D50:D54,D57:D61)","v":25},null,null,{"$f":"SUM(G21:G61)","v":2337800}]
[]
[]
["Paraprofessionals:"]
["Mainstream Paras"]
["Preschool Para",1,1,1,{"$f":"IF(D68<C68, \"Please budget additional staff\", \"Yes\")","v":"Yes"},37989.25,{"$f":"D68*F68","v":37989.25}]
["Kindergarten Para",4,3,4,"Yes",37989.25,151957]
["Mainstream Paras",4,null,4,"Yes",37989.25,151957]
["All General Education Paras",{"$f":"SUM(B68:B70)","v":9},4,{"$f":"SUM(D68:D70)","v":9},null,null,{"$f":"SUM(G68:G70)","v":341903.25}]
[]
["Special Programs"]
["Special Education","If you plan to change special education staffing, contact Mike Lovato by 3/16/2020"]
["Adjustment Teachers",0,null,null,{"$f":"IF(D75<>B75, \"Contact Mike Lovato\", \"No change\")","v":"No change"},93512,{"$f":"D75*F75","v":0}]
["LEAP Teachers",0,null,null,"No change",93512,0]
["CSA Teachers",3,null,3,"No change",93512,280536]
["Other Special Ed Teachers",4,null,4,"No change",93512,374048]
[null,null,null,null,"No change"]
["Special Education Classroom Paras",9,null,9,"No change",37989.25,{"$f":"D80*F80","v":341903.25}]
["504 /1to1",0,"Provided outside of SSB",{"$f":"B81","v":0},"Provided outside of SSB",37989.25,0]
[]
[]
["English Language Learners"]
["ELL Teachers",2.6,3,3,{"$f":"IF(D85<C85, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,{"$f":"D85*F85","v":280536}]
["ELL Para",2,null,2,"Yes",37989.25,75978.5]
["ELL Tutor (Title III)",1,"Provided outside of SSB",{"$f":"B87","v":1},"Provided outside of SSB",15750,15750]
[]
["All Special Programs Teachers & Paras",{"$f":"SUM(B75:B87)","v":21.6},3,{"$f":"SUM(D85:D87,D75:D81)","v":22},null,null,{"$f":"SUM(G85:G87,G75:G81)","v":1368751.75}]
[]
["Student Support:"]
["Guidance Counselor",0,null,null,{"$f":"IF(D92<C92, \"Please budget additional staff\", \"Yes\")","v":"Yes"},107538.8,{"$f":"D92*F92","v":0}]
["Social Worker",1,"Provided outside of SSB",{"$f":"B93","v":1},"Provided outside of SSB",109292.15000000001,109292.15000000001]
["Additional social workers",0,null,null,{"$f":"IF(D94<C94, \"Please budget additional staff\", \"Yes\")","v":"Yes"},109292.15000000001,0]
["SEL Tutors: 18 hrs/week",0,null,null,"Yes",18900,0]
["Tutors: 18 hrs/week",0,null,null,"Yes",18900,0]
["Tutors: 15 hrs/week (Title I)",4,null,5,"Yes",14850,74250]
["Parent Liaisons: Stipended (Title I)",0,null,null,"Yes",3000,0]
["Parent Liaisons: 18 hrs/week (Title I)",1,null,1,"Yes",11340,11340]
["Parent  Liaison, full time",0,null,null,"Yes",{"$f":"36865*1.1689","v":43091.498500000002},0]
[null,{"$f":"SUM(B92:B100)","v":6},0,{"$f":"SUM(D92:D100)","v":7},null,null,{"$f":"SUM(G92:G100)","v":194882.15000000002}]
[]
["Facilities"]
["Security Guards",0,0,null,{"$f":"IF(D104<C104, \"Please budget additional staff\", \"Yes\")","v":"Yes"},52524.625532099999,{"$f":"D104*F104","v":0}]
["Custodians",3,null,3,"Yes",56107.200000000004,168321.6]
[null,{"$f":"SUM(B104:B105)","v":3},0,{"$f":"SUM(D104:D105)","v":3},null,null,{"$f":"SUM(G104:G105)","v":168321.6}]
[]
["High School-Specific Positions"]
["Coordinator of Student Support Services",0,null,null,{"$f":"IF(D109<C109, \"Please budget additional staff\", \"Yes\")","v":"Yes"},146909.68979999999,{"$f":"D109*F109","v":0}]
["Discipline & Operations Specialist",0,null,null,"Yes",126736.81360000001,0]
["Academic Chairs",0,null,null,"Yes",135108.95597375333,0]
["Director of the Freshman Academy",0,null,null,"Yes",137154.93876399999,0]
["Student Services Specialist - Freshman Academy",0,null,null,"Yes",117795.59358600002,0]
["Bursar/Financial Specialist",0,null,null,"Yes",58072.202723000002,0]
["Clerk Schedulers",0,null,null,"Yes",53207.876804600004,0]
["Administrator of Athletics",0,null,null,"Yes",141670.79689000003,0]
["Student Activity Advisor",0,null,null,"Yes",96122.317345999996,0]
[null,{"$f":"SUM(B109:B117)","v":0},0,{"$f":"SUM(D109:D117)","v":0},null,null,{"$f":"SUM(G109:G117)","v":0}]
[]
["Other Positions"]
["Other (Please describe)",0,null,null,{"$f":"IF(D121<C121, \"Please budget additional staff\", \"Yes\")","v":"Yes"},"See James Hall and Linus Guillory to estimate salary + benefits",{"$f":"IFERROR(D121*F121, 0)","v":0}]
["Other (Please describe)",0,null,null,"Yes","See James Hall and Linus Guillory to estimate salary + benefits",0]
[null,{"$f":"SUM(B121:B122)","v":0},null,{"$f":"SUM(D121:D122)","v":0},null,null,{"$f":"SUM(G121:G122)","v":0}]
[]
["Total Staffing "]
[null,{"$f":"B123+B118+B106+B101+B89+B71+B63+B17+B10","v":69.599999999999994},null,{"$f":"D123+D118+D106+D101+D89+D71+D63+D17+D10","v":71},null,null,{"$f":"SUM(G10,G17,G63,G71,G89,G101,G106,G118, G123)","v":4928109.95}]
[]
["Non-Personnel"]
["Instructional Supplies",37760,null,{"$f":"91000-12197","v":78803},{"$f":"IF(D129<C129, \"Please budget additional funds\", \"Yes\")","v":"Yes"},null,{"$f":"D129","v":78803}]
["STEM Lead Stipends",0,null,null,"Yes",null,0]
["Enrichment",0,null,null,"Yes",null,0]
["Athletics: Coaches",0,null,null,"Yes",null,0]
["Athletics: Contracted Services",0,null,null,"Yes",null,0]
["Athletics: Transportation",0,null,null,"Yes",null,0]
["Athletics: Supplies & Uniforms",0,null,null,"Yes",null,0]
["Athletics: Rental Fees",0,null,null,"Yes",null,0]
["Student Activity Stipends",0,null,null,"Yes",null,0]
["Student Activity Supplies",0,null,null,"Yes",null,0]
["Dual Enrollment",0,"Provided outside of SSB",{"$f":"B139","v":0},"Provided outside of SSB",null,0]
["SCORE Peer Mediation",0,"Provided outside of SSB",0,"Provided outside of SSB",null,0]
["Band camp",0,"Provided outside of SSB",0,"Provided outside of SSB",null,0]
["Choral supplies",0,"Provided outside of SSB",0,"Provided outside of SSB",null,0]
["Jr. Air Force ROTC Supplies & Equip.",0,null,null,{"$f":"IF(D143<C143, \"Please budget additional funds\", \"Yes\")","v":"Yes"},null,0]
["Other (describe in column H)",null,null,null,"Yes",null,0]
[null,{"$f":"SUM(B129:B144)","v":37760},null,{"$f":"SUM(D129:D144)","v":78803},null,null,{"$f":"SUM(G129:G144)","v":78803}]
[]
["Title I Review"]
["Coaches",1,1,{"$f":"SUM(D14:D15)","v":1},"See below",97985,{"$f":"D148*F148","v":97985}]
["Parent Liaisons: Stipended",0,null,{"$f":"D98","v":0},"See below",3000,0]
["Parent Liaisons: 18 hrs/week",1,null,1,"See below",11340,11340]
["Tutors: 15 hrs/wk",4,null,4,"See below",14850,59400]
["Total Title I Allocation",168725,168725,{"$f":"SUM(D148:D151)","v":6},{"$f":"IF(G152<C152, \"You have used \"&ROUND(G152/C152*100, 0)&\"% of your Title I budget\", IF(G152>C152, \"Exceeds Title I budget\", \"Yes\"))","v":"Yes"},null,{"$f":"SUM(G148:G151)","v":168725}]
[]
[]
[]
["Total Budget"]
[null,null,null,null,null,null,{"$f":"SUM(G126,G145)","v":5006912.95}]