{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Sec A-F","Section G (Unres.)","Section G (Res.)","Section G (Comb.)","Sec H (MYP)","Sec H1 (Assumptions)","Section I","Section J","Section K","Section L","Section M"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":51,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sec A-F","index":0,"n_rows":97,"n_cols":7,"rows_kept":97,"cut":false,"hidden":false,"merged":[[61,2,61,3],[64,2,64,3],[96,0,96,4],[2,0,3,6],[15,0,16,4],[24,2,24,3],[44,2,44,3],[49,2,49,3],[53,2,53,3],[76,0,76,6],[68,0,68,6],[72,0,72,6],[70,0,70,6],[81,0,81,6],[74,0,74,6],[93,0,93,6],[78,0,78,6],[80,0,80,4],[86,0,86,6],[91,0,91,6],[88,0,88,6],[36,2,36,3],[38,2,38,3],[40,2,40,3],[13,4,13,5],[23,0,26,0],[27,0,30,0],[31,0,34,0],[19,2,19,3],[21,2,21,3],[33,2,33,3],[18,4,18,6],[25,2,25,3],[19,0,22,1],[56,0,59,0],[60,0,62,0],[83,0,83,6],[20,6,22,6],[54,2,54,3],[45,2,45,3],[50,2,50,3],[37,2,37,3],[39,2,39,3],[41,2,41,3],[63,0,66,0],[35,0,42,0],[57,2,57,3],[43,0,47,0],[48,0,51,0],[52,0,55,0],[0,0,0,6],[1,0,1,6],[22,2,22,3],[19,4,19,6],[20,2,20,3],[20,4,22,4],[20,5,22,5]]}
["DISCLOSURE OF COLLECTIVE BARGAINING AGREEMENT"]
["In accordance with California Government Code Section 3547.5, Education Code Section 42142, and the criteria and standards adopted by the State Board of Education."]
["Instructions to complete this disclosure are provided in the AB1200 Fiscal Oversight Manual Section 800 Collective Bargaining. Please provide a copy of the tentative agreement, along with this disclosure and your latest LCFF calculator, to RCOE at least ten (10) working days prior to the date the governing board is to take action. Additionally, please contact DFS retirement prior to any retroactive pay."]
[]
[]
[null,null,"(School District Name)",null,null,"Certificated"]
[{"$nulls":5},"Classified"]
[null,null,"(Bargaining Unit Name)"]
[]
["The proposed new agreement covers the period from:",{"$nulls":4},"to"]
[null,"or"]
["The proposed reopened agreement covers the period from:",{"$nulls":4},"to"]
[]
["The governing board is to act on this agreement at its meeting on: ",null,null,null,"enter date here",null,"(Date)"]
[]
["Does the bargaining unit remain open, or have contingency reopener language, for salaries or health & welfare benefits in the current fiscal year?",{"$nulls":4},"Yes"]
[{"$nulls":5},"No"]
[]
["(A)","Proposed Change in Compensation"]
["COMPENSATION\n(ALL FUNDS COMBINED)",null,"COST PRIOR",null,"FISCAL IMPACT OF PROPOSED AGREEMENT"]
[null,null,"TO PROPOSED",null,"Current Year \nIncrease/\n(Decrease)","Year 2\nIncrease/\n(Decrease)","Year 3\nIncrease/\n(Decrease)"]
[null,null,"AGREEMENT"]
[null,null,"(Current Budget)"]
["1."]
[null,"Salary Schedule - Increase (Decrease)"]
[null,"(Includes Step and Column reported on Line 8)","% Salary Schedule",null,{"$f":"+E25/C25","v":{"$error":"#DIV/0!"}},{"$f":"+F25/(C25+F58+E25)","v":{"$error":"#DIV/0!"}},{"$f":"+G25/(C25+E25+F25+F58+G58)","v":{"$error":"#DIV/0!"}}]
[]
["2."]
[null,"Statutory Benefits"]
[null,"(STRS, PERS, FICA, Medicare, etc)",null,"% Statutory Benefits",{"$f":"+E29/C29","v":{"$error":"#DIV/0!"}},{"$f":"+F29/(C29+E29+$F$58*$C$29/$C$25)","v":{"$error":"#DIV/0!"}},{"$f":"+G29/(C29+E29+F29+F58*C29/C25+G58*C29/C25)","v":{"$error":"#DIV/0!"}}]
[]
["3."]
[null,"Base Costs",{"$f":"C25+C29","v":0},null,{"$f":"+E25+E29","v":0},{"$f":"+F25+F29","v":0},{"$f":"+G25+G29","v":0}]
[null,"(Total of Lines 1 & 2)","% Base Costs",null,{"$f":"+E33/C33","v":{"$error":"#DIV/0!"}},{"$f":"+F33/($C$33+$E$33+$F$58+$F$58*$C$29/$C$25)","v":{"$error":"#DIV/0!"}},{"$f":"+G33/($C$33+$E$33+$F$33+$F$58+$F$58*$C$29/$C$25+$G$58+$G$58*$C$29/$C$25)","v":{"$error":"#DIV/0!"}}]
[]
["4."]
[null,"a.  Other Compensation - Increase (Decrease)","N/A"]
[null,"(Describe in Section 12, Page 2)","% Salary Schedule",null,{"$f":"+E37/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"+F37/($C$25+$E$25+$F$58)","v":{"$error":"#DIV/0!"}},{"$f":"+G37/($C$25+$E$25+$F$25+$F$58+$G$58)","v":{"$error":"#DIV/0!"}}]
[null,"b.  Changes to Step and Column With Agreement","N/A"]
[null,"(Describe in Section 13, Page 2)","% Salary Schedule",null,{"$f":"+E39/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"+F39/($C$25+$E$25+$F$58)","v":{"$error":"#DIV/0!"}},{"$f":"+G39/($C$25+$E$25+$F$25+$F$58+$G$58)","v":{"$error":"#DIV/0!"}}]
[null,"c.  Applicable Statutory Benefits","N/A"]
[null," ","% Salary Schedule",null,{"$f":"+E41/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"+F41/($C$25+$E$25+$F$58)","v":{"$error":"#DIV/0!"}},{"$f":"+G41/($C$25+$E$25+$F$25+$F$58+$G$58)","v":{"$error":"#DIV/0!"}}]
[]
["5."]
[null,"Health/Welfare Benefits - Increase (Decrease)"]
[null,"Current Cap:    $________________","% Salary Schedule",null,{"$f":"+E45/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"+F45/($C$25+$E$25+$F$58)","v":{"$error":"#DIV/0!"}},{"$f":"+G45/($C$25+$E$25+$F$25+$F$58+$G$58)","v":{"$error":"#DIV/0!"}}]
[null,"Proposed Cap: $________________"]
[]
["6."]
[null,"Proposed Negotiated Change in Compensation",null,null,{"$f":"+E25+E37+E39+E45","v":0},{"$f":"+F25+F37+F39+F45","v":0},{"$f":"+G25+G37+G39+G45","v":0}]
[null,"(Excludes Statutory Benefits) (Lines 1, 4a, 4b, & 5)                                             ","% Salary Schedule",null,{"$f":"+E50/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"+F50/($C$25+$E$25+$F$58)","v":{"$error":"#DIV/0!"}},{"$f":"+G50/($C$25+$E$25+$F$25+$F$58+$G$58)","v":{"$error":"#DIV/0!"}}]
[]
["7."]
[null,"Total Cost of Agreement ",{"$f":"C33+C45","v":0},null,{"$f":"E33+E37+E39+E41+E45","v":0},{"$f":"F33+F37+F39+F41+F45","v":0},{"$f":"G33+G37+G39+G41+G45","v":0}]
[null,"(Includes Statutory Benefits) (Lines 3, 4, & 5)                                             ","% Base Costs",null,{"$f":"E54/C33","v":{"$error":"#DIV/0!"}},{"$f":"+F54/($C$33+$E$33+$F$58)","v":{"$error":"#DIV/0!"}},{"$f":"+G54/($C$33+$E$33+$F$33+$F$58+$G$58)","v":{"$error":"#DIV/0!"}}]
[]
["8."]
[null,"Step and Column Due to Movement\n(Included in Salary Schedule reported on Line 1)",null,null,"N/A"]
[null,"% Salary Schedule",{"$f":"+C58/(C25-C58)","v":{"$error":"#DIV/0!"}},null,"N/A",{"$f":"+F58/($C$25+$E$25)","v":{"$error":"#DIV/0!"}},{"$f":"+G58/($C$25+$E$25+$F$25+$F$58)","v":{"$error":"#DIV/0!"}}]
[]
["9."]
[null,"Total Number of Represented Employees"]
[]
["10."]
[null,"Cost of Agreement per Average Employee",{"$f":"C54/C62","v":{"$error":"#DIV/0!"}},null,{"$f":"E54/E62","v":{"$error":"#DIV/0!"}},{"$f":"+F54/F62","v":{"$error":"#DIV/0!"}},{"$f":"+G54/G62","v":{"$error":"#DIV/0!"}}]
[null,null,null," % from Prior Year",{"$f":"+E65/C65","v":{"$error":"#DIV/0!"}},{"$f":"+F65/(C65+E65)","v":{"$error":"#DIV/0!"}},{"$f":"+G65/(C65+E65+F65)","v":{"$error":"#DIV/0!"}}]
[]
[]
["11.  What is the negotiated percentage increase or decrease in compensation?  If the increase in \"Year 1\" is for less than a full year, indicate the annualized percentage of that increase for \"Year  1\". Page 1, Section A, 1."]
[]
[]
[]
["12.  Are there any other compensation items included in the agreement?  Please explain any changes indicated on Page 1, Section A, 4a."]
[]
[]
[]
["13.  Is the district adding any steps, columns, or ranges due to the agreement?  Please explain any changes indicated on Page 1, Section A, 4b."]
[]
[]
[]
["14.  Does this unit have a negotiated cap for health and welfare benefits?",{"$nulls":4},"yes           no"]
["Please describe the district's annual health and welfare cost per employee for this bargaining unit, and indicate the current and proposed cap on Page 1, Section A, 5."]
[]
[]
[]
["(B)","Proposed Negotiated Changes in Non-Compensation Items "]
["Please discuss proposed changes in non-compensation items such as class size adjustments, staff development days, teacher prep time, classified staffing ratios, etc."]
[]
[]
[]
["(C)","Proposed Contingency Language "]
["Please detail proposed contingency language relating to funding restoration, reopening, applicable fiscal years, or other significant provisions.  Please indicate when restoration will occur, if applicable."]
[]
[]
[]
["(E)","Impact on Deficit Spending "]
["Will this agreement increase deficit spending in the current or subsequent years? ",{"$nulls":4},"yes           no"]

{"sheet":"Section G (Unres.)","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[40,0,42,5],[3,0,6,1],[39,0,39,5],[2,2,2,5]]}
["(G) Impact of Proposed Agreement on Current Year General Fund Operating Budget"]
["In accordance with California Government Code Section 3547.5, Education Code Section 42142, and the criteria and standards adopted by the State Board of Education."]
[null,null,"UNRESTRICTED GENERAL FUND"]
["CURRENT YEAR OPERATING BUDGET",null,"(Col. 1)","(Col. 2)*","(Col. 3)*","(Col. 4)"]
[null,null,"Board-Approved","Adjustments","Other Revisions","Total Revised"]
[null,null,"Budget Prior to","Resulting from","Board Approved ","Budget"]
[null,null,"Settlement","Settlement","Date_________","(Col. 1+2+3)"]
["REVENUES"]
["LCFF Sources","8010-8099",null,null,null,{"$f":"SUM(C9:E9)","v":0}]
["Federal Revenue","8100-8299",null,null,null,{"$f":"SUM(C10:E10)","v":0}]
["Other State Revenue","8300-8599",null,null,null,{"$f":"SUM(C11:E11)","v":0}]
["Other Local Revenue","8600-8799",null,null,null,{"$f":"SUM(C12:E12)","v":0}]
["TOTAL REVENUES",null,{"$f":"SUM(C9:C12)","v":0},{"$f":"SUM(D9:D12)","v":0},{"$f":"SUM(E9:E12)","v":0},{"$f":"SUM(F9:F12)","v":0}]
["EXPENDITURES"]
["Certificated Salaries","1000-1999",null,null,null,{"$f":"SUM(C15:E15)","v":0}]
["Classified Salaries","2000-2999",null,null,null,0]
["Employee Benefits","3000-3999",null,null,null,0]
["Books and Supplies","4000-4999",null,null,null,0]
["Services & Operating Expenditures","5000-5999",null,null,null,0]
["Capital Outlay","6000-6999",null,null,null,0]
["Other Outgo","7100-7299     7400-7499",null,null,null,0]
["Indirect/Direct Support Costs","7300-7399",null,null,null,0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D22)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0}]
["OTHER FINANCING SOURCES/USES"]
["Contributions","8980-8999",null,null,null,{"$f":"SUM(C25:E25)","v":0}]
["Transfers In and Other Sources","8910-8979",null,null,null,{"$f":"SUM(C26:E26)","v":0}]
["Transfers Out and Other Uses","7610-7699",null,null,null,{"$f":"SUM(C27:E27)","v":0}]
["TOTAL EXPENDITURES AND USES",null,{"$f":"+C23+C27","v":0},{"$f":"+D23+D27","v":0},{"$f":"+E23+E27","v":0},{"$f":"+F23+F27","v":0}]
["INCREASE (DECREASE) IN FUND BALANCE",null,{"$f":"+C13+C26+C25-C28","v":0},{"$f":"+D13+D26+D25-D28","v":0},{"$f":"+E13+E26+E25-E28","v":0},{"$f":"+F13+F25+F26-F28","v":0}]
["BEGINNING BALANCE","9791,9793,9795",null,null,null,{"$f":"SUM(C30:E30)","v":0}]
["ENDING BALANCE",null,{"$f":"+C30+C29","v":0},{"$f":"+D30+D29","v":0},{"$f":"+E30+E29","v":0},{"$f":"+F30+F29","v":0}]
["COMPONENTS OF ENDING BALANCE"]
["Nonspendable","9711-9719",null,null,null,{"$f":"SUM(C33:E33)","v":0}]
["Restricted",9740,null,null,null,0]
["Committed","9750-9760",null,null,null,0]
["Assigned",9780,null,null,null,0]
["Reserve for Economic Uncertainties",9789,null,null,null,0]
["Unassigned/Unappropriated",9790,{"$f":"+C31-(C33+C34+C35+C36+C37)","v":0},{"$f":"+D31-(D33+D34+D35+D36+D37)","v":0},{"$f":"+E31-(E33+E34+E35+E36+E37)","v":0},0]
[]
["*If the total adjustments in Col. 2 do not agree with the Total Cost of Agreement on page 1, Section A, Line 7, please explain the variance below (e.g. partially budgeted, salaries and benefits are budgeted in other funds), and/or explain any revisions included in Col. 3."]

{"sheet":"Section G (Res.)","index":2,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[40,0,42,5],[3,0,6,1],[39,0,39,5],[2,2,2,5]]}
["(G) Impact of Proposed Agreement on Current Year General Fund Operating Budget"]
["In accordance with Government Code Section 3547.5, Education Code Section 42142, and the criteria and standards adopted by the State Board of Education."]
[null,null,"RESTRICTED GENERAL FUND"]
["CURRENT YEAR OPERATING BUDGET",null,"(Col. 1)","(Col. 2)*","(Col. 3)*","(Col. 4)"]
[null,null,"Board-Approved","Adjustments","Other Revisions","Total Revised"]
[null,null,"Budget Prior to","Resulting from","Board Approved ","Budget"]
[null,null,"Settlement","Settlement","Date_________","(Col. 1+2+3)"]
["REVENUES"]
["LCFF Sources","8010-8099",null,null,null,{"$f":"SUM(C9:E9)","v":0}]
["Federal Revenue","8100-8299",null,null,null,{"$f":"SUM(C10:E10)","v":0}]
["Other State Revenue","8300-8599",null,null,null,{"$f":"SUM(C11:E11)","v":0}]
["Other Local Revenue","8600-8799",null,null,null,{"$f":"SUM(C12:E12)","v":0}]
["TOTAL REVENUES",null,{"$f":"SUM(C9:C12)","v":0},{"$f":"SUM(D9:D12)","v":0},{"$f":"SUM(E9:E12)","v":0},{"$f":"SUM(F9:F12)","v":0}]
["EXPENDITURES"]
["Certificated Salaries","1000-1999",null,null,null,{"$f":"SUM(C15:E15)","v":0}]
["Classified Salaries","2000-2999",null,null,null,0]
["Employee Benefits","3000-3999",null,null,null,0]
["Books and Supplies","4000-4999",null,null,null,0]
["Services & Operating Expenditures","5000-5999",null,null,null,0]
["Capital Outlay","6000-6999",null,null,null,0]
["Other Outgo","7100-7299     7400-7499",null,null,null,0]
["Indirect/Direct Support Costs","7300-7399",null,null,null,0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D22)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0}]
["OTHER FINANCING SOURCES/USES"]
["Contributions","8980-8999",null,null,null,{"$f":"SUM(C25:E25)","v":0}]
["Transfers In and Other Sources","8910-8979",null,null,null,{"$f":"SUM(C26:E26)","v":0}]
["Transfers Out and Other Uses","7610-7699",null,null,null,{"$f":"SUM(C27:E27)","v":0}]
["TOTAL EXPENDITURES AND USES",null,{"$f":"+C23+C27","v":0},{"$f":"+D23+D27","v":0},{"$f":"+E23+E27","v":0},{"$f":"+F23+F27","v":0}]
["INCREASE (DECREASE) IN FUND BALANCE",null,{"$f":"+C13+C26+C25-C28","v":0},{"$f":"+D13+D25+D26-D28","v":0},{"$f":"+E13+E25+E26-E28","v":0},{"$f":"+F13+F25+F26-F28","v":0}]
["BEGINNING BALANCE","9791,9793,9795",null,null,null,{"$f":"SUM(C30:E30)","v":0}]
["ENDING BALANCE",null,{"$f":"+C30+C29","v":0},{"$f":"+D30+D29","v":0},{"$f":"+E30+E29","v":0},{"$f":"+F30+F29","v":0}]
["COMPONENTS OF ENDING BALANCE"]
["Nonspendable","9711-9719",null,null,null,{"$f":"SUM(C33:E33)","v":0}]
["Restricted",9740,null,null,null,0]
["Committed","9750-9760",null,null,null,0]
["Assigned",9780,null,null,null,0]
["Reserve for Economic Uncertainties",9789,null,null,null,0]
["Unassigned/Unappropriated",9790,{"$f":"+C31-(C33+C34+C35+C36+C37)","v":0},{"$f":"+D31-(D33+D34+D35+D36+D37)","v":0},{"$f":"+E31-(E33+E34+E35+E36+E37)","v":0},0]
[]
["*If the total adjustments in Col. 2 do not agree with the Total Cost of Agreement on page 1, Section A, Line 7, please explain the variance below (e.g. partially budgeted, salaries and benefits are budgeted in other funds), and/or explain any revisions included in Col. 3."]

{"sheet":"Section G (Comb.)","index":3,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[40,0,42,5],[3,0,6,1],[39,0,39,5],[2,2,2,5]]}
["(G) Impact of Proposed Agreement on Current Year General Fund Operating Budget"]
["In accordance with Government Code Section 3547.5, Education Code Section 42142, and the criteria and standards adopted by the State Board of Education."]
[null,null,"COMBINED GENERAL FUND"]
["CURRENT YEAR OPERATING BUDGET",null,"(Col. 1)","(Col. 2)*","(Col. 3)*","(Col. 4)"]
[null,null,"Board-Approved","Adjustments","Other Revisions","Total Revised"]
[null,null,"Budget Prior to","Resulting from","Board Approved ","Budget"]
[null,null,"Settlement","Settlement","Date_________","(Col. 1+2+3)"]
["REVENUES"]
["LCFF Sources","8010-8099",{"$f":"'Section G (Unres.)'!C9+'Section G (Res.)'!C9","v":0},{"$f":"'Section G (Unres.)'!D9+'Section G (Res.)'!D9","v":0},{"$f":"'Section G (Unres.)'!E9+'Section G (Res.)'!E9","v":0},{"$f":"SUM(C9:E9)","v":0}]
["Federal Revenue","8100-8299",{"$f":"'Section G (Unres.)'!C10+'Section G (Res.)'!C10","v":0},{"$f":"'Section G (Unres.)'!D10+'Section G (Res.)'!D10","v":0},{"$f":"'Section G (Unres.)'!E10+'Section G (Res.)'!E10","v":0},{"$f":"SUM(C10:E10)","v":0}]
["Other State Revenue","8300-8599",{"$f":"'Section G (Unres.)'!C11+'Section G (Res.)'!C11","v":0},{"$f":"'Section G (Unres.)'!D11+'Section G (Res.)'!D11","v":0},{"$f":"'Section G (Unres.)'!E11+'Section G (Res.)'!E11","v":0},{"$f":"SUM(C11:E11)","v":0}]
["Other Local Revenue","8600-8799",{"$f":"'Section G (Unres.)'!C12+'Section G (Res.)'!C12","v":0},{"$f":"'Section G (Unres.)'!D12+'Section G (Res.)'!D12","v":0},{"$f":"'Section G (Unres.)'!E12+'Section G (Res.)'!E12","v":0},{"$f":"SUM(C12:E12)","v":0}]
["TOTAL REVENUES",null,{"$f":"SUM(C9:C12)","v":0},{"$f":"SUM(D9:D12)","v":0},{"$f":"SUM(E9:E12)","v":0},{"$f":"SUM(F9:F12)","v":0}]
["EXPENDITURES"]
["Certificated Salaries","1000-1999",{"$f":"'Section G (Unres.)'!C15+'Section G (Res.)'!C15","v":0},{"$f":"'Section G (Unres.)'!D15+'Section G (Res.)'!D15","v":0},{"$f":"'Section G (Unres.)'!E15+'Section G (Res.)'!E15","v":0},{"$f":"SUM(C15:E15)","v":0}]
["Classified Salaries","2000-2999",{"$f":"'Section G (Unres.)'!C16+'Section G (Res.)'!C16","v":0},{"$f":"'Section G (Unres.)'!D16+'Section G (Res.)'!D16","v":0},{"$f":"'Section G (Unres.)'!E16+'Section G (Res.)'!E16","v":0},0]
["Employee Benefits","3000-3999",{"$f":"'Section G (Unres.)'!C17+'Section G (Res.)'!C17","v":0},{"$f":"'Section G (Unres.)'!D17+'Section G (Res.)'!D17","v":0},{"$f":"'Section G (Unres.)'!E17+'Section G (Res.)'!E17","v":0},0]
["Books and Supplies","4000-4999",{"$f":"'Section G (Unres.)'!C18+'Section G (Res.)'!C18","v":0},{"$f":"'Section G (Unres.)'!D18+'Section G (Res.)'!D18","v":0},{"$f":"'Section G (Unres.)'!E18+'Section G (Res.)'!E18","v":0},0]
["Services & Operating Expenditures","5000-5999",{"$f":"'Section G (Unres.)'!C19+'Section G (Res.)'!C19","v":0},{"$f":"'Section G (Unres.)'!D19+'Section G (Res.)'!D19","v":0},{"$f":"'Section G (Unres.)'!E19+'Section G (Res.)'!E19","v":0},0]
["Capital Outlay","6000-6999",{"$f":"'Section G (Unres.)'!C20+'Section G (Res.)'!C20","v":0},{"$f":"'Section G (Unres.)'!D20+'Section G (Res.)'!D20","v":0},{"$f":"'Section G (Unres.)'!E20+'Section G (Res.)'!E20","v":0},0]
["Other Outgo","7100-7299     7400-7499",{"$f":"'Section G (Unres.)'!C21+'Section G (Res.)'!C21","v":0},{"$f":"'Section G (Unres.)'!D21+'Section G (Res.)'!D21","v":0},{"$f":"'Section G (Unres.)'!E21+'Section G (Res.)'!E21","v":0},0]
["Indirect/Direct Support Costs","7300-7399",{"$f":"'Section G (Unres.)'!C22+'Section G (Res.)'!C22","v":0},{"$f":"'Section G (Unres.)'!D22+'Section G (Res.)'!D22","v":0},{"$f":"'Section G (Unres.)'!E22+'Section G (Res.)'!E22","v":0},0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D22)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0}]
["OTHER FINANCING SOURCES/USES"]
["Contributions","8980-8999",{"$f":"'Section G (Unres.)'!C25+'Section G (Res.)'!C25","v":0},{"$f":"'Section G (Unres.)'!D25+'Section G (Res.)'!D25","v":0},{"$f":"'Section G (Unres.)'!E25+'Section G (Res.)'!E25","v":0},{"$f":"SUM(C25:E25)","v":0}]
["Transfers In and Other Sources","8910-8979",{"$f":"'Section G (Unres.)'!C26+'Section G (Res.)'!C26","v":0},{"$f":"'Section G (Unres.)'!D26+'Section G (Res.)'!D26","v":0},{"$f":"'Section G (Unres.)'!E26+'Section G (Res.)'!E26","v":0},{"$f":"SUM(C26:E26)","v":0}]
["Transfers Out and Other Uses","7610-7699",{"$f":"'Section G (Unres.)'!C27+'Section G (Res.)'!C27","v":0},{"$f":"'Section G (Unres.)'!D27+'Section G (Res.)'!D27","v":0},{"$f":"'Section G (Unres.)'!E27+'Section G (Res.)'!E27","v":0},{"$f":"SUM(C27:E27)","v":0}]
["TOTAL EXPENDITURES AND USES",null,{"$f":"+C23+C27","v":0},{"$f":"+D23+D27","v":0},{"$f":"+E23+E27","v":0},{"$f":"+F23+F27","v":0}]
["INCREASE (DECREASE) IN FUND BALANCE",null,{"$f":"+C13+C26+C25-C28","v":0},{"$f":"+D13+D26+D25-D28","v":0},{"$f":"+E13+E26+E25-E28","v":0},{"$f":"+F13+F26+F25-F28","v":0}]
["BEGINNING BALANCE","9791,9793,9795",{"$f":"'Section G (Unres.)'!C30+'Section G (Res.)'!C30","v":0},null,null,{"$f":"SUM(C30:E30)","v":0}]
["ENDING BALANCE",null,{"$f":"+C30+C29","v":0},{"$f":"+D30+D29","v":0},{"$f":"+E30+E29","v":0},{"$f":"+F30+F29","v":0}]
["COMPONENTS OF ENDING BALANCE"]
["Nonspendable","9711-9719",{"$f":"'Section G (Unres.)'!C33+'Section G (Res.)'!C33","v":0},{"$f":"'Section G (Unres.)'!D33+'Section G (Res.)'!D33","v":0},{"$f":"'Section G (Unres.)'!E33+'Section G (Res.)'!E33","v":0},{"$f":"SUM(C33:E33)","v":0}]
["Restricted",9740,{"$f":"'Section G (Unres.)'!C34+'Section G (Res.)'!C34","v":0},{"$f":"'Section G (Unres.)'!D34+'Section G (Res.)'!D34","v":0},{"$f":"'Section G (Unres.)'!E34+'Section G (Res.)'!E34","v":0},0]
["Committed","9750-9760",{"$f":"'Section G (Unres.)'!C35+'Section G (Res.)'!C35","v":0},{"$f":"'Section G (Unres.)'!D35+'Section G (Res.)'!D35","v":0},{"$f":"'Section G (Unres.)'!E35+'Section G (Res.)'!E35","v":0},0]
["Assigned",9780,{"$f":"'Section G (Unres.)'!C36+'Section G (Res.)'!C36","v":0},{"$f":"'Section G (Unres.)'!D36+'Section G (Res.)'!D36","v":0},{"$f":"'Section G (Unres.)'!E36+'Section G (Res.)'!E36","v":0},0]
["Reserve for Economic Uncertainties",9789,{"$f":"'Section G (Unres.)'!C37+'Section G (Res.)'!C37","v":0},{"$f":"'Section G (Unres.)'!D37+'Section G (Res.)'!D37","v":0},{"$f":"'Section G (Unres.)'!E37+'Section G (Res.)'!E37","v":0},0]
["Unassigned/Unappropriated",9790,{"$f":"'Section G (Unres.)'!C38+'Section G (Res.)'!C38","v":0},{"$f":"'Section G (Unres.)'!D38+'Section G (Res.)'!D38","v":0},{"$f":"'Section G (Unres.)'!E38+'Section G (Res.)'!E38","v":0},0]
[]
["*If the total adjustments in Col. 2 do not agree with the Total Cost of Agreement on page 1, Section A, Line 7, please explain the variance below (e.g. partially budgeted, salaries and benefits are budgeted in other funds), and/or explain any revisions included in Col. 3."]

{"sheet":"Sec H (MYP)","index":4,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,0,2,14],[1,0,1,14],[0,5,0,9]]}
["(H) Multi-Year Financial Projections    ",{"$nulls":4},{"$f":"'Sec A-F'!B6","v":0}]
["Combined General Fund"]
["Multi-Year Financial Projections 2022-23 to 2026-27"]
[]
[{"$nulls":5}," ","Percent",null,"Percent",null,"Percent",null,"Percent",null,"Percent"]
[{"$nulls":4},"Prior Year","Prior Year","of","Adopted","of","Revised","of","Projected","of","Projected","of"]
[{"$nulls":4},"Actuals","Actuals","Change","Budget","Change","Budget","Change","Budget","Change","Budget","Change"]
[{"$nulls":4},"2022-23","2023-24","over PY","2024-25","over PY","2024-25","over PY","2025-26","over PY","2026-27","over PY"]
[]
["REVENUES"]
[null,"LCFF Sources",{"$nulls":4},{"$f":"(F11-E11)/E11","v":{"$error":"#DIV/0!"}},null,{"$f":"(H11-F11)/F11","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F9","v":0},{"$f":"(J11-F11)/F11","v":{"$error":"#DIV/0!"}},{"$f":"_2526LCFF","v":0},{"$f":"(L11-J11)/J11","v":{"$error":"#DIV/0!"}},{"$f":"_2627LCFF","v":0},{"$f":"(N11-L11)/L11","v":{"$error":"#DIV/0!"}}]
[null,"Federal",{"$nulls":4},{"$f":"(F12-E12)/E12","v":{"$error":"#DIV/0!"}},null,{"$f":"(H12-F12)/F12","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F10","v":0},{"$f":"(J12-F12)/F12","v":{"$error":"#DIV/0!"}},{"$f":"_2526Federal","v":0},{"$f":"(L12-J12)/J12","v":{"$error":"#DIV/0!"}},{"$f":"_2627Federal","v":0},{"$f":"(N12-L12)/L12","v":{"$error":"#DIV/0!"}}]
[null,"State",{"$nulls":4},{"$f":"(F13-E13)/E13","v":{"$error":"#DIV/0!"}},null,{"$f":"(H13-F13)/F13","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F11","v":0},{"$f":"(J13-F13)/F13","v":{"$error":"#DIV/0!"}},{"$f":"_2526State","v":0},{"$f":"(L13-J13)/J13","v":{"$error":"#DIV/0!"}},{"$f":"_2627State","v":0},{"$f":"(N13-L13)/L13","v":{"$error":"#DIV/0!"}}]
[null,"Local",{"$nulls":4},{"$f":"(F14-E14)/E14","v":{"$error":"#DIV/0!"}},null,{"$f":"(H14-F14)/F14","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F12","v":0},{"$f":"(J14-F14)/F14","v":{"$error":"#DIV/0!"}},{"$f":"_2526Local","v":0},{"$f":"(L14-J14)/J14","v":{"$error":"#DIV/0!"}},{"$f":"_2627Local","v":0},{"$f":"(N14-L14)/L14","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Revenues",null,null,{"$f":"SUM(E11:E14)","v":0},{"$f":"SUM(F11:F14)","v":0},{"$f":"(F16-E16)/E16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H11:H14)","v":0},{"$f":"(H16-F16)/F16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J11:J14)","v":0},{"$f":"(J16-F16)/F16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L11:L14)","v":0},{"$f":"(L16-J16)/J16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N11:N14)","v":0},{"$f":"(N16-L16)/L16","v":{"$error":"#DIV/0!"}}]
[]
["EXPENDITURES"]
[null,"Certificated Salaries",{"$nulls":4},{"$f":"(F19-E19)/E19","v":{"$error":"#DIV/0!"}},null,{"$f":"(H19-F19)/F19","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F15","v":0},{"$f":"(J19-F19)/F19","v":{"$error":"#DIV/0!"}},{"$f":"_25261XXX","v":0},{"$f":"(L19-J19)/J19","v":{"$error":"#DIV/0!"}},{"$f":"_26271XXX","v":0},{"$f":"(N19-L19)/L19","v":{"$error":"#DIV/0!"}}]
[null,"Classified Salaries",{"$nulls":4},{"$f":"(F20-E20)/E20","v":{"$error":"#DIV/0!"}},null,{"$f":"(H20-F20)/F20","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F16","v":0},{"$error":"#DIV/0!"},{"$f":"_25262XXX","v":0},{"$error":"#DIV/0!"},{"$f":"_26272XXX","v":0},{"$error":"#DIV/0!"}]
[null,"Benefits",{"$nulls":4},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"'Section G (Comb.)'!F17","v":0},{"$error":"#DIV/0!"},{"$f":"_25263XXX","v":0},{"$error":"#DIV/0!"},{"$f":"_26273XXX","v":0},{"$error":"#DIV/0!"}]
[null,"Books & Supplies",{"$nulls":4},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"'Section G (Comb.)'!F18","v":0},{"$error":"#DIV/0!"},{"$f":"_25264XXX","v":0},{"$error":"#DIV/0!"},{"$f":"_26274XXX","v":0},{"$error":"#DIV/0!"}]
[null,"Contracts & Services",{"$nulls":4},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"'Section G (Comb.)'!F19","v":0},{"$error":"#DIV/0!"},{"$f":"_25265XXX","v":0},{"$error":"#DIV/0!"},{"$f":"_26275XXX","v":0},{"$error":"#DIV/0!"}]
[null,"Capital Outlay",{"$nulls":4},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"'Section G (Comb.)'!F20","v":0},{"$error":"#DIV/0!"},{"$f":"_25266XXX","v":0},{"$error":"#DIV/0!"},{"$f":"_26276XXX","v":0},{"$error":"#DIV/0!"}]
[null,"Other Outgo",{"$nulls":4},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"'Section G (Comb.)'!F21","v":0},{"$error":"#DIV/0!"},{"$f":"_2526Other","v":0},{"$error":"#DIV/0!"},{"$f":"_2627Other","v":0},{"$error":"#DIV/0!"}]
[null,"Support Costs",{"$nulls":4},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"'Section G (Comb.)'!F22","v":0},{"$error":"#DIV/0!"},{"$f":"_2526Indirect","v":0},{"$error":"#DIV/0!"},{"$f":"_2627Indirect","v":0},{"$error":"#DIV/0!"}]
[]
[null,"Total Expenditures",null,null,{"$f":"SUM(E19:E27)","v":0},{"$f":"SUM(F19:F27)","v":0},{"$f":"(F28-E28)/E28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H19:H27)","v":0},{"$f":"(H28-F28)/F28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J19:J27)","v":0},{"$f":"(J28-F28)/F28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L19:L27)","v":0},{"$f":"(L28-J28)/J28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N19:N27)","v":0},{"$f":"(N28-L28)/L28","v":{"$error":"#DIV/0!"}}]
[]
["OTHER SOURCES & USES"]
[null,"Transfers In & Other Sources",{"$nulls":4},{"$f":"(F31-E31)/E31","v":{"$error":"#DIV/0!"}},null,{"$f":"(H31-F31)/F31","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F26","v":0},{"$f":"(J31-F31)/F31","v":{"$error":"#DIV/0!"}},{"$f":"_2526XferIn","v":0},{"$f":"(L31-J31)/J31","v":{"$error":"#DIV/0!"}},{"$f":"_2627XferIn","v":0},{"$f":"(N31-L31)/L31","v":{"$error":"#DIV/0!"}}]
[null,"Transfers Out & Other Uses",{"$nulls":4},{"$f":"(F32-E32)/E32","v":{"$error":"#DIV/0!"}},null,{"$f":"(H32-F32)/F32","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F27","v":0},{"$f":"(J32-F32)/F32","v":{"$error":"#DIV/0!"}},{"$f":"_2526XferOut","v":0},{"$f":"(L32-J32)/J32","v":{"$error":"#DIV/0!"}},{"$f":"_2627XferOut","v":0},{"$f":"(N32-L32)/L32","v":{"$error":"#DIV/0!"}}]
[null,"Total Expenditures & Uses",null,null,{"$f":"E28+E32","v":0},{"$f":"F28+F32","v":0},{"$f":"(F33-E33)/E33","v":{"$error":"#DIV/0!"}},{"$f":"H28+H32","v":0},{"$f":"(H33-F33)/F33","v":{"$error":"#DIV/0!"}},{"$f":"J28+J32","v":0},{"$f":"(J33-F33)/F33","v":{"$error":"#DIV/0!"}},{"$f":"L28+L32","v":0},{"$f":"(L33-J33)/J33","v":{"$error":"#DIV/0!"}},{"$f":"N28+N32","v":0},{"$f":"(N33-L33)/L33","v":{"$error":"#DIV/0!"}}]
[]
["NET INCREASE (DECREASE) IN FUND BALANCE",null,null,null,{"$f":"SUM(E16+E31-E33)","v":0},{"$f":"SUM(F16+F31-F33)","v":0},{"$f":"(F35-E35)/E35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H16+H31-H33)","v":0},{"$f":"(H35-F35)/F35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J16+J31-J33)","v":0},{"$f":"(J35-F35)/F35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L16+L31-L33)","v":0},{"$f":"(L35-J35)/J35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N16+N31-N33)","v":0},{"$f":"(N35-L35)/L35","v":{"$error":"#DIV/0!"}}]
[]
["FUND BALANCE, RESERVES"]
[null,"Beginning Balance",null,null,null,{"$f":"+E39","v":0},{"$f":"(F38-E38)/E38","v":{"$error":"#DIV/0!"}},null,{"$f":"(H38-F38)/F38","v":{"$error":"#DIV/0!"}},{"$f":"'Section G (Comb.)'!F30","v":0},{"$f":"(J38-F38)/F38","v":{"$error":"#DIV/0!"}},{"$f":"+J39","v":0},{"$f":"(L38-J38)/J38","v":{"$error":"#DIV/0!"}},{"$f":"L39","v":0},{"$f":"(N38-L38)/L38","v":{"$error":"#DIV/0!"}}]
[null,"Ending Balance",null,null,{"$f":"E38+E35","v":0},{"$f":"F38+F35","v":0},{"$f":"(F39-E39)/E39","v":{"$error":"#DIV/0!"}},{"$f":"H38+H35","v":0},{"$f":"(H39-F39)/F39","v":{"$error":"#DIV/0!"}},{"$f":"J38+J35","v":0},{"$f":"(J39-F39)/F39","v":{"$error":"#DIV/0!"}},{"$f":"L38+L35","v":0},{"$f":"(L39-J39)/J39","v":{"$error":"#DIV/0!"}},{"$f":"N38+N35","v":0},{"$f":"(N39-L39)/L39","v":{"$error":"#DIV/0!"}}]
[]
["Components of Ending Fund Balance:"]
[null,"Nonspendable",{"$nulls":7},{"$f":"'Section G (Comb.)'!F33","v":0}]
[null,"Restricted",{"$nulls":7},{"$f":"'Section G (Comb.)'!F34","v":0}]
[null,"Committed",{"$nulls":7},{"$f":"'Section G (Comb.)'!F35","v":0}]
[null,"Assigned",{"$nulls":7},{"$f":"'Section G (Comb.)'!F36","v":0}]
[null,"Reserve for Economic Uncertainties",{"$nulls":7},{"$f":"'Section G (Comb.)'!F37","v":0}]
[null,"Unassigned/Unappropriated",null,null,{"$f":"E39-(E42+E43+E44+E45+E46)","v":0},{"$f":"F39-(F42+F43+F44+F45+F46)","v":0},null,0,null,{"$f":"'Section G (Comb.)'!F38","v":0},null,0,null,0]
[null,null,"Total Ending Balance",null,{"$f":"SUM(E42:E47)","v":0},{"$f":"SUM(F41:F47)","v":0},null,{"$f":"SUM(H41:H47)","v":0},null,{"$f":"SUM(J41:J47)","v":0},null,{"$f":"SUM(L41:L47)","v":0},null,{"$f":"SUM(N41:N47)","v":0}]
[null,null,"% Reserve (9789 and 9790)",null,{"$f":"(SUM(E46:E47)/E33)","v":{"$error":"#DIV/0!"}},{"$f":"(SUM(F46:F47)/F33)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]

{"sheet":"Sec H1 (Assumptions)","index":5,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[31,0,31,1],[0,7,0,10],[0,14,0,18],[1,0,1,18],[5,0,5,1],[6,0,6,1],[14,0,14,1],[22,0,22,1],[23,0,23,1]]}
["Multi-Year Financial Projection Assumptions"]
["COMBINED GENERAL FUND"]
[null,null,"Certificated","Classified","Benefits","Supplies","Services","Capital Outlay","Other Outgo","Indirects","Interfund Transfers Out","Total","LCFF","Federal","State","Local","Contributions","Interfund Transfers In","Total "]
[null,"Resource Code","1XXX","2XXX","3XXX","4XXX","5XXX","6XXX","71000-7299\n7400-7499","7300-7399","7610-7629","Exp Change","80XX","81XX-82XX","83XX-85XX","86XX-87XX","89XX","891X","Rev Change"]
["2024-25 Revised Budget",null,{"$f":"+'Sec H (MYP)'!J19","v":0},{"$f":"+'Sec H (MYP)'!J20","v":0},{"$f":"+'Sec H (MYP)'!J21","v":0},{"$f":"+'Sec H (MYP)'!J22","v":0},{"$f":"+'Sec H (MYP)'!J23","v":0},{"$f":"+'Sec H (MYP)'!J24","v":0},{"$f":"+'Sec H (MYP)'!J25","v":0},{"$f":"+'Sec H (MYP)'!J26","v":0},{"$f":"+'Sec H (MYP)'!J32","v":0},{"$f":"SUM(C5:K5)","v":0},{"$f":"+'Sec H (MYP)'!J11","v":0},{"$f":"+'Sec H (MYP)'!J12","v":0},{"$f":"+'Sec H (MYP)'!J13","v":0},{"$f":"+'Sec H (MYP)'!J14","v":0},0,{"$f":"+'Sec H (MYP)'!J31","v":0},{"$f":"SUM(M5:R5)","v":0}]
["2025-26 Adjustments",{"$nulls":10},{"$f":"SUM(C6:K6)","v":0},{"$nulls":6},{"$f":"SUM(M6:R6)","v":0}]
["Unrestricted Fund - Fund 03"]
["List separately:",{"$nulls":10},0,{"$nulls":6},0]
["e.g. ADA change, LCFF",{"$nulls":10},0,{"$nulls":6},0]
["step/column increase",{"$nulls":10},0,{"$nulls":6},0]
["negotiations, furlough days",{"$nulls":10},0,{"$nulls":6},0]
["one-time expenditures",{"$nulls":10},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
["Restricted Fund - Fund 06"]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
["2025-26 TOTALS",null,{"$f":"SUBTOTAL(9,INDIRECT(\"C5:C\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"D5:D\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"E5:E\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"F5:F\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"G5:G\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"H5:H\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"I5:I\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"J5:J\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"K5:K\"&ROW()-1))","v":0},{"$f":"SUM(C22:K22)","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"M5:M\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"N5:N\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"O5:O\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"P5:P\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"Q5:Q\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"R5:R\"&ROW()-1))","v":0},{"$f":"SUM(M22:R22)","v":0}]
["2026-27 Adjustments",{"$nulls":10},0,{"$nulls":6},0]
["Unrestricted Fund - Fund 03"]
["List separately:",{"$nulls":10},0,{"$nulls":6},0]
["e.g. ADA change, LCFF",{"$nulls":10},0,{"$nulls":6},0]
["step/column increase",{"$nulls":10},0,{"$nulls":6},0]
["negotiations, furlough days",{"$nulls":10},0,{"$nulls":6},0]
["one-time expenditures",{"$nulls":10},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
["Restricted Fund - Fund 06"]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":6},0]
["2026-27 TOTALS",null,{"$f":"SUBTOTAL(9,INDIRECT(\"C5:C\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"D5:D\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"E5:E\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"F5:F\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"G5:G\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"H5:H\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"I5:I\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"J5:J\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"K5:K\"&ROW()-1))","v":0},{"$f":"SUM(C39:K39)","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"M5:M\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"N5:N\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"O5:O\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"P5:P\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"Q5:Q\"&ROW()-1))","v":0},{"$f":"SUBTOTAL(9,INDIRECT(\"R5:R\"&ROW()-1))","v":0},{"$f":"SUM(M39:R39)","v":0}]

{"sheet":"Section I","index":6,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[20,0,20,4],[3,0,3,1],[0,0,0,4],[5,0,9,0],[10,0,12,0],[13,0,17,0],[3,2,4,2],[3,3,4,3],[3,4,4,4],[38,0,41,0],[50,0,50,4],[52,0,59,4],[22,0,25,0],[26,0,29,0],[30,0,34,0],[35,0,37,0]]}
["(I) Impact of Proposed Agreement on Unrestricted Reserves"]
[]
[]
["1. State Reserve Standard Calculation",null,"Current Year","Year 2","Year 3"]
[]
["1a."]
[null,"Total Expenditures, Transfers Out, and Uses"]
[null,"(Including Cost of Proposed Agreement) for both",{"$f":"'Sec H (MYP)'!J33","v":0},{"$f":"'Sec H (MYP)'!L33","v":0},{"$f":"'Sec H (MYP)'!N33","v":0}]
[null,"Unrestricted and Restricted General Fund"]
[]
["1b."]
[null,"Enter State Standard Minimum Reserve Percentage"]
[]
["1c."]
[null,"State Standard Minimum Unrestricted Fund Reserve"]
[null,"(Line 1a times Line 1b.  For a district with less than",{"$f":"+C8*C12","v":0},{"$f":"+D8*D12","v":0},{"$f":"+E8*E12","v":0}]
[null,"1,001 ADA, the greater of Line 1a times 1b or $60,000)"]
[]
[]
[]
["2.  Budgeted Unrestricted Reserve (After Impact of Proposed Agreement)"]
[]
["2a."]
[null,"General Fund Reserve for Economic Uncertainties"]
[null,"(Object 9789)",{"$f":"'Sec H (MYP)'!J46","v":0},{"$f":"'Sec H (MYP)'!L46","v":0},{"$f":"'Sec H (MYP)'!N46","v":0}]
[]
["2b."]
[null,"General Fund Budgeted as Unassigned/"]
[null,"Unappropriated Amount (Object 9790)",{"$f":"'Sec H (MYP)'!J47","v":0},{"$f":"'Sec H (MYP)'!L47","v":0},{"$f":"'Sec H (MYP)'!N47","v":0}]
[]
["2c."]
[null,"Special Reserve Fund for Other Than Capital Outlay"]
[null,"Projects Budgeted for Economic Uncertainties",0,0,0]
[null,"(Fund 17, Object 9789)"]
[]
["2d."]
[null,"Total District Budgeted Unrestricted Reserves",{"$f":"C25+C29+C33","v":0},{"$f":"D25+D29+D33","v":0},{"$f":"E25+E29+E33","v":0}]
[]
["2e."]
[null,"Reserve for Economic Uncertainties Percentage"]
[null,"(Line 2d divided by Line 1a)",{"$f":"+C37/C8","v":{"$error":"#DIV/0!"}},{"$f":"+D37/D8","v":{"$error":"#DIV/0!"}},{"$f":"+E37/E8","v":{"$error":"#DIV/0!"}}]
[]
[]
["3.  Does the district's budgeted unrestricted reserves meet the state standard minimum reserve amount?"]
[null,"(Line 1c is less than or equal to Line 2d?)"]
[]
[null,"Current Year:","2024-25","yes","no"]
[null,"Year 2:","2025-26","yes","no"]
[null,"Year 3:","2026-27","yes","no"]
[]
["4.  If no, how does the district plan to restore reserves?"]

{"sheet":"Section J","index":7,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[30,0,43,3],[1,0,1,3],[28,0,28,1],[0,0,0,3],[4,0,5,0],[4,2,5,2]]}
["(J) Impact of Proposed Agreement on Current Year Operating Budget"]
["Itemized Budget Revisions Necessary to Meet Agreement's Cost"]
[]
["Year 1: 2024-25"]
["Description of the Revision","Attached Fund Transfer/","Amount","County Use Only:"]
[null,"Budget Resolution Numbers",null,"Date Action Taken"]
[null,null,0," "]
[null,null,0," "]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL REVISIONS",null,{"$f":"SUM(C7:C25)","v":0}]
[]
[]
["Please provide an explanation if no budget revisions are necessary."]

{"sheet":"Section K","index":8,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[30,0,37,3],[2,0,2,3],[1,0,1,3],[0,0,0,3],[28,0,28,3]]}
["(K) Impact of Proposed Agreement on Subsequent Fiscal Year Budgets"]
["Itemized Budget Revisions Included in the Multi-Year Financial Projections to Meet Agreement's Cost"]
[]
["Year 2: 2025-26"]
["Description of the Revision","Major Object Code Series","Amount","County Use Only: Date Action Taken"]
[" ",null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL YEAR 2",null,{"$f":"SUM(C6:C13)","v":0}]
[]
[]
["Year 3: 2026-27"]
["Description of the Revision","Major Object Code Series","Amount","County Use Only: Date Action Taken"]
[" ",null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL YEAR 3",null,{"$f":"SUM(C19:C26)","v":0}]
[]
["Please provide an explanation if no budget revisions are necessary."]

{"sheet":"Section L","index":9,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,3,0,6],[10,6,10,7],[15,6,15,7],[6,1,6,7],[2,0,2,8],[10,1,10,4],[3,0,3,8],[1,3,1,6],[16,1,16,4],[11,1,11,4],[15,1,15,4],[11,6,11,7],[16,6,16,7]]}
["(L) Certification No. 1",null,null,{"$f":"'Sec A-F'!B6","v":0}]
[null,null,null,{"$f":"'Sec A-F'!B8","v":0}]
["The District Superintendent and Chief Business Official should sign this certification at the time of public disclosure."]
[]
[]
[]
[null,"In accordance with the requirements of Government Code Section 3547.5, the undersigned hereby certify that the costs incurred under the provisions of the agreement can be met by the district during the term of the agreement, and that the itemized budget revisions necessary to meet such costs, as indicated in sections J and K, are included in the district's budget and multi-year financial projections."]
[]
[]
[]
[]
[null,"Signature - District Superintendent",{"$nulls":4},"Date"]
[]
[]
[]
[]
[null,"Signature - Chief Business Official",{"$nulls":4},"Date"]
[]
[]
[]
[]
["District Contact Person:",{"$nulls":5},"Phone:"]

{"sheet":"Section M","index":10,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[19,1,19,4],[14,1,14,4],[18,1,18,4],[14,6,14,7],[19,6,19,7],[1,3,1,6],[0,3,0,6],[13,6,13,7],[18,6,18,7],[8,1,8,7],[9,4,9,5],[10,5,10,7],[6,1,6,7],[2,0,2,8],[13,1,13,4],[3,0,3,8]]}
["(M) Certification No. 2",null,null,{"$f":"'Sec A-F'!B6","v":0}]
[null,null,null,{"$f":"'Sec A-F'!B8","v":0}]
["The District Superintendent and Governing Board Clerk or President should sign this certification at the time of formal board action on the proposed agreement."]
[]
[]
[]
[null,"The information provided in this document summarizes the financial implications of the proposed agreement and is submitted to the Governing Board for certification and public disclosure of the major provisions of the agreement, in accordance with Government Code Section 3547.5."]
[]
[null,"After public disclosure of the major provisions contained in this Collective Bargaining Disclosure, the                    "]
[null,"District's Governing Board, at its meeting on:  ",null,null,{"$f":"'Sec A-F'!E14:F14","v":"enter date here"},null,", took action to approve the "]
[null,"proposed agreement with the following bargaining unit:",null,null,null,{"$f":"'Sec A-F'!B8","v":0}]
[]
[]
[]
[null,"Signature - District Superintendent",{"$nulls":4},"Date"]
[]
[]
[]
[]
[null,"Signature - Governing Board Clerk/President",{"$nulls":4},"Date"]
[]
[]
[]
[]
["District Contact Person:",{"$nulls":5},"Phone:"]