{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions (Please Read)","Budget Summary","Revenue","Expenditures","Cash & Investments","Additional Details","Notes","Tasks","Formula Map","Sheet1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":48,"comments":1,"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":"Instructions (Please Read)","index":0,"n_rows":267,"n_cols":22,"rows_kept":267,"cut":false,"hidden":false,"merged":[[26,1,26,12],[7,1,7,12],[0,1,0,12],[22,1,22,12],[20,1,20,12],[14,2,14,11],[15,2,15,12],[17,2,17,12],[13,2,13,10],[12,2,12,11],[10,2,10,11],[8,1,8,12],[24,1,24,12]]}
[null,{"$f":"VLOOKUP(U2,R1:S5,2,FALSE)","v":"Proposed Budget"},null,null,null,null,null,null,null,null,null,null,null,null,"This budget form is currently dated for the Fiscal Year Ending","If the date is wrong, change the year below.",null,1,"Proposed Budget"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" DATE(P2,6,30)","v":"2024-06-30"},{"$f":"YEAR(NOW())+1","v":2024},null,2,"Final Budget",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(NOW())+1","v":2024},null,3,"Amended Budget",null,1,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(NOW())+1","v":2024}]
[null,"INSTRUCTIONS FOR COMPLETING BUDGET REQUEST FORM "]
[null,"In accordance with the requirements of WS 16-12-403, the Department of Audit has modified the Standard Budget Form.  "]
[]
[null,"1.","Please follow the steps below:"]
[null,null,"a.  Download this as an Excel file and save to your computer."]
[null,null,"b.  Begin by reading this instruction sheet and continue by inputting data on the following worksheets (Tabs are along the bottom of the page).  This will automatically fill results to the \"Budget Summary\" sheet."]
[null,null,"c. Enter all required information at the top of the Budget Summary sheet (Name, County, District address, District phone, FYE, Your name, Date, Location, and Time of Budget Hearing)."]
[null,null,"You cannot enter data into cells shaded in gray as they are automatic totals."]
[null,"2.","Choose, in the drop-down box at the top of this page, which budget (\"proposed\" or \"final\") you intend to submit at this time.  Note:  If you are preparing a proposed budget the \"Final Budget\" column will be crossed out. "]
[null,"3.","In places you are asked to identify a specific item, please describe it in detail. SAVE THE EXCEL FILE AS YOU WILL NEED IT LATER."]
[null,"4.","For EACH budget form prepared (Proposed or Final) you will click the \"Create a PDF\" button on the Budget Summary page.  This will save a copy of the budget in your folder in .pdf format.  The saved copy of the budget will then need to be submitted via email to your county government AND to the Wyoming Department of Audit at doa-pfd-web@wyo.gov."]
[null,"5.","If you have ANY questions, or concerns, please contact the Public Funds Division at 307-777-7798."]
[]
[null,"Helpful Tip:  Certain headings have comments associated with them, which contain more detailed information regarding the section of the budget form you are about to complete.  They appear in red boxes to the right of the budget form.  SAVE ALL EXCEL FILE VERSIONS FOR FUTURE USE."]
[]
[null,"NOTE:  The column headed \"Final Approval\" will not be completed until the Public Budget hearing is held.  The public hearing is to be held not later than the third Thursday in July in accordance with W.S. 16-12-406.  Or, the governing board of any special purpose district may choose to hold the budget hearing in conjunction with the county budget hearings and so advertise.  Final budgets must be approved within three (3) business days of hearing."]
[]
[]
[]
[null,"The Budget Process"]
[]
[null,"Introduction"]
[]
[null,"The budget is the master financial plan of the governmental entity, showing the proposed cost for"]
[null,"each function of activity and the proposed means of financing them. The budget should not be"]
[null,"thought of merely as a means of determining the amount to be raised by tax levy to supplement other"]
[null,"revenues. The necessity of preparation and use of a budget cannot be overemphasized and is required by law."]
[]
[null,"The budget should be comprehensive, covering all proposed expenditures and all anticipated"]
[null,"receipts and revenues, regardless of source. Expenditure estimates should be in sufficient detail to"]
[null,"show the need for the appropriations requested, and cover all items, whether for ordinary operation or"]
[null,"capital outlay. Revenue estimates should be made with due consideration for possible failure to"]
[null,"realize the full amount anticipated, and thereby avoid the possibility of revenue deficits during the"]
[null,"fiscal year."]
[]
[null,"Chart of Account guidance is shown on the Revenue, Expenditures, and Cash & Investment tabs."]
[null,"Use of this exact chart of accounts is not required.  It is shown as a guide to assist entities in the"]
[null,"categorization of their budgeted items.  For definitions and guidance on these specific accounts, please refer "]
[null,"to the Wyoming Governmental Entity budgeting, Accounting, and Reporting Manual which can be found "]
[null,"at publicfunds.wyo.gov under the Resources tab."]
[]
[null,"Budgets are required by Wyoming statute W.S. 16-12-401 for all governmental entities listed in"]
[null,"W.S. 16-12-202(a) (unless otherwise specified).  This form is optional for all other governmental entities."]
[]
[null,"The annual budgetary process involves three phases: preparation, adoption, and execution. The"]
[null,"preparation phase of the budgetary process is the responsibility of the designated budget officer"]
[null,"(usually the clerk or treasurer). It is accomplished by the correlation of financial data produced by"]
[null,"the accounting system and the projected program requirements of the various functions and activities"]
[null,"for which a particular governmental entity may have responsibility. The adoption phase involves the"]
[null,"proposed budget that has been reviewed by the Department of Audit being presented to the governing "]
[null,"body for consideration, possible modification, and final enactment. The budget execution phase is the "]
[null,"phase of the budget cycle which encompasses all the actions required to effectively, efficiently, and "]
[null,"economically accomplish the programs for which funds were requested and approved."]
[]
[null,"Budget Preparation"]
[]
[null,"The appropriate budget officer (generally the clerk or treasurer) shall prepare a proposed budget for"]
[null,"each entity and present the proposed budget to the governing body in a timely fashion allowing the"]
[null,"governing body to meet the hearing date and notice requirements established by W.S. 16-12-406."]
[]
[null,"Special purpose districts having the authority under the general laws of Wyoming to levy taxes or"]
[null,"impose assessments and public entities receiving funds from a municipality, as defined by"]
[null,"W.S. 16-4-102(a)(xiv), shall prepare budgets in a format acceptable to the Director of the State"]
[null,"Department of Audit [W.S. 16-4-125(c) and W.S. 16-12-403 respectively]. In addition, special "]
[null,"districts must report their proposed and final budgets to the Department of Audit and the County Clerk "]
[null,"[W.S 9-1-507(a)(viii)]. To enhance consistency, the Department of Audit has created a budget form for "]
[null,"which only special districts are required to use when preparing their budget. The budget form is "]
[null,"available on the Department of Audit's website. (publicfunds.wyo.gov)"]
[]
[null,"Further, the degree of detail necessary to provide adequate control over expenditures will vary from"]
[null,"entity to entity. However, at a minimum, each governmental entity shall specify functions when"]
[null,"preparing the budget. The Department of Audit's Uniform Chart of Accounts provides flexibility for"]
[null,"varying degrees of control."]
[]
[null,"The governing body may not make any appropriation in excess of the estimated expendable revenues"]
[null,"and reserves available to the district for the budget year. It is a violation to adopt a budget that expends "]
[null,"more than the resources available (negative spending) [W.S. 16-12-407]."]
[]
[null,"Department of Audit's Budget Format"]
[]
[null,"The budget format, as designed by the Department of Audit for required entities, shall have five basic"]
[null,"sections [W.S. 16-12-403]:"]
[null,null,"A. Budget Message"]
[null,null,"B. Budget Summary"]
[null,null,"C. Revenue Forecasts"]
[null,null,"D. Expenditure Plan"]
[null,null,"E. Statements of Cash Available and Reserves"]
[]
[null,"Each proposed and adopted budget shall be accompanied by a budget message and reserve message."]
[null,"The budget message shall contain an outline of the proposed financial policies for the budget"]
[null,"year and describe in connection therewith the important features of the budgetary plan.  It shall"]
[null,"also state the reasons for changes from the previous year in appropriation and revenue."]
[null,"The reserve message shall state the amount of reserves on hand and outline the reserve policy for the "]
[null,"budget year."]
[]
[null,"The Department of Audit's budget format is designed to manage the budgeting by individual entity, "]
[null,"NOT by individual fund."]
[]
[null,"Budgets for all entities should contain essentially the same detail. Budgets for governmental entities"]
[null,"are required by W.S. 16-12-403 to contain:"]
[]
[null,null,"1. Actual revenues and expenditures for the last completed fiscal year."]
[null,null,"2. Estimated total revenues and expenditures for the current fiscal year."]
[null,null,"3. Estimated available revenues and expenditures for the ensuing fiscal year."]
[]
[null,"The Statements of Cash Available, the Revenue Forecasts and Expenditure Plan shall document"]
[null,"past, present, and future financial information that supports the Budget Summary."]
[]
[null,"An ideal method of preparing a budget with this information is to have four columns labeled Actual"]
[null,"Prior Year, Estimated Current Year, Proposed Budget, and Approved Budget for the revenue and"]
[null,"expenditure schedules."]
[]
[null,null,"• The Actual Prior Year column should contain the financial information for the last complete"]
[null,null,"  fiscal year from the Survey of Local Government Finances Form (F-32)or Survey of Major Special"]
[null,null," Agencies (F-66 WY-4) file with the Department of Audit."]
[]
[null,null,"• The Estimated Current Year column should contain year-to-date data through the month"]
[null,null,"  proceeding the month in which the budget is prepared, plus estimated information for the"]
[null,null,"  remainder of the current fiscal year."]
[]
[null,null,"• The Proposed Budget is the unapproved budget, while the Final Budget is the "]
[null,null,"  approved budget for the next fiscal year."]
[]
[null,null,"• Once the detailed revenue and expenditure budget schedules are created, the aggregate totals"]
[null,null,"  of these budgets will automatically populate the Budget Summary."]
[]
[null,"EXAMPLE:  If a budget is being prepared for the fiscal year ending June 30, 2019, the Actual Prior"]
[null,"Year would be June 30, 2017. The Estimated Current Year (i.e., the year in which the budget is being"]
[null,"prepared) would be the fiscal year ending June 30, 2018. Since the budget should be prepared during"]
[null,"the last quarter of the current fiscal year (usually beginning in April), the remaining figures for April, "]
[null,"May, and June would be estimated for the Estimated Current Year column. The Proposed Budget "]
[null,"would be the estimated revenues and expenditures for the fiscal year ending June 30, 2019, and the"]
[null,"Final Budget would be created after the budget hearing and approval incorporating any changes made "]
[null,"in that process."]
[]
[null,"In addition, to improve management control of the budget, anticipated revenue and expenditures"]
[null,"should be shown for all appropriate accounts presented in the Chart of Accounts. However, the"]
[null,"governing body may deem it unnecessary to determine budgeting by object code."]
[]
[null,"In preparing the annual budget, a governmental entity may accumulate net position in any enterprise"]
[null,"or intra-governmental service fund or accumulate a fund surplus in any other fund.  Special Districts"]
[null,"may accumulate reserves in any fund.  However, the surplus in the general fund"]
[null,"may only be used for a few specific purposes [W.S. 16-12-404]."]
[]
[null,"Reserves"]
[]
[null,"A reserve is a liquid asset held by a bank in order to meet expected future payments and/or emergency needs."]
[null,"To qualify as a reserve, the funds must be separated from the general operating fund in either a separate bank"]
[null,"account or a specific general ledger item in the chart of accounts.  The reserve item must be entered into the meeting"]
[null,"minutes when the reserve is established, increased, or spent.  Reserves can be classified as non spendable, legally or    "]
[null,"legislatively restricted, committed, or unassigned (emergency) purposes.  Operating funds should NOT be held in"]
[null,"reserve."]
[]
[null,"Special District's Budget Form Process"]
[]
[null,"All applicable forms should be completed, and if additional schedules or exhibits are needed for additional funds "]
[null,"and/or departments, they should be prepared and inserted where necessary."]
[]
[null,"The Proposed budget must be submitted electronically to both the Department of Audit and the "]
[null,"County Clerk of the county where the special district is located no later than June 1 of each"]
[null,"year. For electronic submission to the Department of Audit, please email to doa-pfd-web@wyo.gov. "]
[null,"Hardcopy submissions will NOT be accepted. "]
[]
[null,"* It is imperative that the district saves the Excel File used to create the Proposed and Final budget. "]
[null,"The Proposed Budget file will be used to create the Final Budget, and once adopted, the Final Budget "]
[null,"file will be used to create any Amended budgets the district may file for that year."]
[]
[null,"Budget Adoption"]
[]
[null,"The Proposed Budget shall be reviewed and considered by the governing body in a regular or special"]
[null,"meeting called for this purpose. Following a public hearing as provided in W.S. 16-12-406, the"]
[null,"governing body shall adopt a budget [W.S. 16-12-403(d)]. Budget hearing notices are due to the "]
[null,"Department of Audit no later than September 30."]
[]
[null,"The budget shall be approved and passed by resolution (by minutes)."]
[]
[null,"After the budget is approved for adoption, the Final Budget must be submitted electronically to both "]
[null,"the Department of Audit and the County Clerk of the county where the special district is "]
[null,"located no later than July 31 of each year [W.S. 16-12-408(a)]. For electronic submission to the Department"]
[null,"of Audit, please email to doa-pfd-web@wyo.gov. Hardcopy submissions will NOT be accepted.  "]
[]
[null,"To create a Final Budget, open the Excel file that was used to create the Proposed budget. In the "]
[null,"drop-down box at the top of the Instructions tab, select “Final Budget”. The information from the "]
[null,"Proposed Budget will remain in the form, and will be added to the new Final Approval column."]
[null,"If needed, enter the new values that changed after the budget hearing into the Final Approval column."]
[]
[null,"* Save the Excel file to use if the district needs to file any Amended Budgets for the fiscal year."]
[]
[null,"DO NOT change the values in the Proposed Budget column, or in the Budget Summary Tab."]
[null,"Once the values for the Final Budget are updated, save the file as a .pdf file, and submit the .pdf copy to the "]
[null,"Department of Audit and County Clerk. "]
[]
[null,"Budget Execution"]
[]
[null,"The budget execution phase is the phase of the budget cycle which encompasses all the actions"]
[null,"required to effectively, efficiently, and economically accomplish the programs for which funds were"]
[null,"requested and approved. During this phase, it is important to align the budget classifications with the"]
[null,"chart of accounts in order to facilitate the meaningful comparison of actual against budgeted"]
[null,"revenues and expenditures. Performing this comparison will help to ensure spending is within"]
[null,"approved budget limits. It is important to remain within budget, as it is against state statute and,"]
[null,"therefore, illegal to 'go over' budget [W.S. 16-12-407 and Wyoming Constitution Article 16, "]
[null,"Section 7]."]
[]
[null,"In order to prevent unauthorized and illegal spending, if an unforeseen increase in revenues or"]
[null,"expenditures occurs, it may be necessary to amend the budget. The budget must be amended if the"]
[null,"entity intends to spend more than the total amount of expenditures approved within the budget [W.S."]
[null,"16-12-407]. Amending the budget must be approved prior to exceeding the budget. It is"]
[null,"unnecessary to amend the budget if budgeted funds are reallocated, but remain under or equal to"]
[null,"the total approved expenditure. In the latter situation, although it is unnecessary to amend the"]
[null,"budget, the movement must be approved in a board meeting and documented in the meeting minutes"]
[null,"[W.S. 16-12-409]."]
[]
[null,"EXAMPLE:   If an entity only budgeted for a police department to spend $5,000 on uniforms and"]
[null,"$15,000 on a vehicle, their budgeted \"bottom line\" expenditures would total $20,000"]
[null,"($15,000+$5,000). If the actual vehicle cost $11,000, the police department would be able to move"]
[null,"$4,000 ($15,000-$11,000) from the vehicle budget to the uniforms, as long as the board approved the"]
[null,"movement and it was documented in the meeting minutes. However, if the actual vehicle cost"]
[null,"$25,000 and the department purchased the vehicle, they would have gone over budget by $10,000,"]
[null,"since the \"bottom line\" expenditure would have totaled $30,000 ($25,000+$5,000). This would be"]
[null,"illegal if the entity did not amend their budget appropriately. Therefore, prior to purchase, the"]
[null,"entity would have to amend the budget. If the budget is amended and the estimated expendable"]
[null,"revenues remain greater than expenditures, as required by state statute [W.S. 16-12-407], then the"]
[null,"department could purchase the vehicle legally."]
[]
[null,"It is important to note that additional funding sources such as grants or special appropriations may"]
[null,"not be known at the time of the original budget preparation, but become available at a later date."]
[null,"Even if the cash is available, the authorization to spend the unexpected revenue has not been made."]
[null,"These funds must then be included in an amended budget or remain unspent."]
[]
[null,"If it is necessary to amend a budget, perform the following items:"]
[null,null,"1. Publish a hearing notice to include a summary of the tentative amended budget."]
[null,null,"2. Hold a hearing to adopt the amended budget."]
[null,null,"3. Then, send a copy of the certified amended budget to the County Clerk and the"]
[null,null,"    Department of Audit, Public Funds Division."]
[]
[null,"To create an Amended budget, open the Excel file that was used to create the Final Budget. In the "]
[null,"drop-down box at the top of the Instructions tab, select “Amended Budget”. In the top right corner of the "]
[null,"Instructions tab (in cell P2), enter the fiscal year end that is being amended. This will ensure the columns "]
[null,"of the form are labeled with the correct fiscal years. "]
[]
[null,"In column L of the Budget Summary tab, enter the date of the Amended Budget approval. "]
[null,"DO NOT change the original budget hearing information."]
[]
[null,"The information from the Final Budget will remain in the form, and will be added to the new Amended Budget column. "]
[null,"Enter the new values for any items that have changed into the Amended Budget column. DO NOT change any values "]
[null,"that do not need amended, or any values in any of the other columns, or the Budget Summary tab. "]
[]
[null,"* Save the Excel file to use if the district needs to file any more Amended Budgets for the fiscal year."]
[]
[null,"Once the values for the Amended Budget are updated, save the file as a .pdf file, and submit the .pdf copy to the "]
[null,"Department of Audit and the County Clerk of the county where the special district is located. "]
[]
[null,"Emergency Expenditures - If the governing body determines an emergency exists and the"]
[null,"expenditure of money in excess of the general fund budget is necessary, it may make the"]
[null,"expenditures from revenues available under W.S. 16-12-404(a)(ii) as reasonably necessary to meet the"]
[null,"emergency. Notice of the declaration of emergency shall be published in a newspaper of general"]
[null,"circulation within the district [W.S. 16-12-411], and notice of the emergency budget hearing shall be sent to the "]
[null,"Department of Audit [W.S. 16-12-406(c)], along with the amended budget."]
[]
[null,"The process for an increased budget due to emergency expenditures follow the same process as the amended budget."]

{"sheet":"Budget Summary","index":1,"n_rows":167,"n_cols":28,"rows_kept":167,"cut":false,"hidden":false,"merged":[[34,1,62,10],[154,13,155,14],[31,8,31,10],[31,1,31,5],[120,1,120,6],[108,1,108,6],[130,1,130,6],[134,1,134,6],[73,1,73,3],[74,1,74,3],[75,1,75,3],[76,1,76,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[80,1,80,3],[2,1,2,10],[4,1,4,5],[5,1,5,5],[6,1,6,5],[4,8,4,10],[5,8,5,10],[6,8,6,10],[3,8,3,10],[165,1,165,10],[93,1,93,10],[156,1,156,7],[155,7,155,9],[155,1,155,6],[161,3,161,5],[163,1,163,2],[163,3,163,5],[160,7,160,8],[160,1,160,2],[160,3,160,5],[160,9,160,10],[64,1,67,10],[82,1,82,3],[85,1,85,10],[88,1,88,10],[91,1,91,10],[69,1,69,3],[73,7,73,10],[74,7,74,10],[75,7,75,10],[72,7,72,10],[81,1,81,3],[70,1,70,3],[71,1,71,3],[72,1,72,3]]}
[null,null,null,null,null,null,null,null,null,null,null,"New Column:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,{"$f":"\"FY \"&TEXT(DATE('Instructions (Please Read)'!$P$2-1,7,1),\"m/d/y\")&\"-\"&TEXT(DATE('Instructions (Please Read)'!$P$2,6,30),\"m/d/y\")","v":"FY 7/1/23-6/30/24"},null,null,null,null,{"$f":"VLOOKUP('Instructions (Please Read)'!U2,'Instructions (Please Read)'!R1:S8,2,FALSE)","v":"Proposed Budget"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Name of \n District/Board:",null,null,null,null,null,null,null,null,null,null,null,null,"If you cannot see the pdf button,"]
[null,null,null,null,null,null,null,null,"Budget Hearing Information",null,null,"Date of",null,"save and reopen the excel file."]
["Address:",null,null,null,null,null,null,"Location:",null,null,null,"Amended",null,{"$f":"IF(O5=\"Complete\",\"All District/Board Information is Complete\",IF(K71=\"Yes\",\"Fill in the yellow boxes below. (\"&(COUNTA(B3,B5,B6,B7,B32,I5,I6,I7,I32,B35,B86,B89,B92,B65)+IF(COUNT(A72:A83)>0,1,0)+IF(OR(K71=\"No\",K71=\"Yes\"),1,0))&\" of 16 done)\"&CHAR(10)&\"Office info required below (\"&COUNTA(H73:K76)&\" of 4 done)\",\"Fill in the yellow boxes below. (\"&(COUNTA(B3,B5,B6,B7,B32,I5,I6,I7,I32,B35,B86,B89,B92,B65)+IF(COUNT(A72:A83)>0,1,0)+IF(OR(K71=\"No\",K71=\"Yes\"),1,0))&\" of 16 done)\"&IF(AND(K71=\"No\",OR(K80<>\"Yes\",K80<>\"No\")),CHAR(10)&\"Records Location Needed (Yes or No below in red)\",\"\")))","v":"Fill in the yellow boxes below. (0 of 16 done)"},{"$f":"IF(K71=\"Yes\",IF((COUNTA(H73:K76)+COUNTA(B3,B5,B6,B7,B32,I5,I6,I7,I32,B35,B86,B89,B92,B65)+IF(COUNTA(B72:D83)>0,1,0)+IF(OR(K71=\"No\",K71=\"Yes\"),1,0))=20,\"Complete\",\"Incomplete\"),IF(K71=\"No\",IF((COUNTA(B3,B5,B6,B7,B32,I5,I6,I7,I32,B35,B86,B89,B92,B65)+IF(COUNTA(B72:D83)>0,1,0)+IF(OR(K71=\"No\",K71=\"Yes\"),1,0))=16,\"Complete\",\"Incomplete\"),\"Incomplete\"))","v":"Incomplete"}]
["City, State, Zip:",null,null,null,null,null,null,"Date:",null,null,null,"Budget"]
["District Phone:",null,null,null,null,null,null,"Time:",null,null,null,"Approval:"]
[{"$f":"IF(LEN('Budget Summary'!B7)<7,\"Required ↗\",\"\")","v":"Required ↗"}]
[null,"Albany County"]
[null,"Big Horn County"]
[null,"Campbell County"]
[null,"Carbon County"]
[null,"Converse County"]
[null,"Crook County"]
[null,"Fremont County"]
[null,"Goshen County"]
[null,"Hot Springs County"]
[null,"Johnson County"]
[null,"Laramie County"]
[null,"Lincoln County"]
[null,"Natrona County"]
[null,"Niobrara County"]
[null,"Park County"]
[null,"Platte County"]
[null,"Sheridan County"]
[null,"Sublette County"]
[null,"Sweetwater County"]
[null,"Teton County"]
[null,"Uinta County"]
[null,"Washakie County"]
[null,"Weston County"]
["County:",null,null,null,null,null,null,"Budget Prepared by:"]
[]
[null,"S-A",{"$f":"IF('Budget Summary'!B35=\"\",\"BUDGET MESSAGE — REQUIRED\",\"BUDGET MESSAGE\")","v":"BUDGET MESSAGE — REQUIRED"},null,null,null,null,null,null,null,"W.S. 16-4-104(d)"]
[]
[{"$f":"IF(LEN('Budget Summary'!B35)<10,\"→\",\"\")","v":"→"}]
[{"$f":"IF('Budget Summary'!B35=\"\",\"THE BUDGET\",IF(LEN('Budget Summary'!B35)<50,\"THE BUDGET\",\"\"))","v":"THE BUDGET"}]
[{"$f":"IF('Budget Summary'!B35=\"\",\"MESSAGE\",IF(LEN('Budget Summary'!B35)<50,\"MESSAGE\",\"\"))","v":"MESSAGE"}]
[{"$f":"IF('Budget Summary'!B35=\"\",\"IS BLANK\",IF(LEN('Budget Summary'!B35)<50,\"IS TOO SHORT\",\"\"))","v":"IS BLANK"}]
[]
[{"$f":"IF('Budget Summary'!B35=\"\",\"A BUDGET\",IF(LEN('Budget Summary'!B35)<50,\"PLEASE\",\"\"))","v":"A BUDGET"}]
[{"$f":"IF('Budget Summary'!B35=\"\",\"MESSAGE\",IF(LEN('Budget Summary'!B35)<50,\"ADD MORE\",\"\"))","v":"MESSAGE"}]
[{"$f":"IF('Budget Summary'!B35=\"\",\"IS REQUIRED\",IF(LEN('Budget Summary'!B35)<50,\"CONTENT\",\"\"))","v":"IS REQUIRED"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"S-B","RESERVE DESCRIPTION"]
[]
[]
[]
[]
[null,"S-C"]
[null,null,null,null,"Date of End",null,{"$f":"IF(OR(K71=\"Yes\",K71=\"No\"),\"\",\"Answer Required:\")","v":"Answer Required:"},"Does the district have regular office hours"]
[null,"Names of Board Members",null,null,"of Term",null,null,"exceeding 20 hours per week?",null,null,"Yes/No"]
[{"$f":"IF(COUNTA(B72:E72)=2,A71+1,\"\")","v":""},null,null,null,null,null,{"$f":"IF($K$71=\"Yes\",\"If Yes, enter\",\"\")","v":""}]
[{"$f":"IF(COUNTA(B73:E73)=2,A72+1,\"\")","v":""},null,null,null,null,null,{"$f":"IF($K$71=\"Yes\",\"Address of office:\",\"\")","v":""}]
["",null,null,null,null,null,{"$f":"IF($K$71=\"Yes\",\"City, State, Zip:\",\"\")","v":""}]
["",null,null,null,null,null,{"$f":"IF($K$71=\"Yes\",\"Phone Number:\",\"\")","v":""}]
["",null,null,null,null,null,{"$f":"IF($K$71=\"Yes\",\"Hours Open:\",\"\")","v":""}]
[""]
["",null,null,null,null,null,{"$f":"IF(K71=\"No\",\"If no above:\",\"\")","v":""},{"$f":"IF(K71=\"No\",\"Are the records on file with the\",\"\")","v":""}]
["",null,null,null,null,null,null,{"$f":"IF(K71=\"No\",\"County Clerk as required by\",\"\")","v":""},null,null,null,null,null,{"$f":"IF('Budget Summary'!B35=\"\",\"\",IF(LEN('Budget Summary'!B35)<50,\"CHARACTER\",\"\"))","v":""}]
["",null,null,null,null,null,null,{"$f":"IF(K71=\"No\",\"W.S. 16-12-303(c)?\",\"\")","v":""},null,null,{"$f":"IF(K71=\"No\",\"Yes/No\",\"\")","v":""},null,{"$f":"IF(K71=\"No\",IF(OR(K80=\"No\",K80=\"Yes\"),\"\",\"Yes or No\"),\"\")","v":""},{"$f":"IF('Budget Summary'!B35=\"\",\"\",IF(LEN('Budget Summary'!B35)<50,\"MINIMUM\",\"\"))","v":""}]
["",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M80=\"Yes or No\",\"(Required)\",\"\")","v":""},{"$f":"IF('Budget Summary'!B35=\"\",\"\",IF(LEN('Budget Summary'!B35)<50,\"NOT MET\",\"\"))","v":""}]
[""]
[""]
[]
[null,"Where are the minutes of your board meeting available for public review?",null,null,null,null,null,null,null,null,null,null,null,"Issues:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Incomplete=\"Incomplete\",\"Please finish filling out the information requested in the boxes shaded in yellow.\",\"\")","v":"Please finish filling out the information requested in the boxes shaded in yellow."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M106=\"Balanced or Surplus - No Additional Funding Needed\",\"\",M106)","v":""}]
[null,"How and where are the notices of meeting posted for the public?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J119:L119)<=0,\"There are no budgeted revenues.\",\"\")","v":"There are no budgeted revenues."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J129:L129)<=0,\"There are no budgeted expenditures.\",\"\")","v":"There are no budgeted expenditures."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J137:L137)<=0,\"The budget shows no available general funds.\",\"\")","v":"The budget shows no available general funds."}]
[null,"Where are the public meetings held? "]
[]
[]
[null,{"$f":"UPPER(VLOOKUP('Instructions (Please Read)'!U2,'Instructions (Please Read)'!R1:S8,2,FALSE))&\" SUMMARY\"","v":"PROPOSED BUDGET SUMMARY"}]
[]
[null,"OVERVIEW",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
[]
[null,"S-1","Total Budgeted Expenditures",null,null,null,null,{"$f":"H129","v":0},{"$f":"+'Budget Summary'!I129","v":0},{"$f":"+'Budget Summary'!J129","v":0},{"$f":"+'Budget Summary'!K129","v":0},{"$f":"+'Budget Summary'!L129","v":0}]
[null,"S-2","Total Principal to Pay on Debt",null,null,null,null,{"$f":"H133","v":0},{"$f":"I133","v":0},{"$f":"J133","v":0},{"$f":"K133","v":0},{"$f":"L133","v":0}]
[null,"S-3","Total Change to Restricted Funds",null,null,null,null,{"$f":"'Budget Summary'!H149-H152","v":0},{"$f":"'Budget Summary'!I149-I152","v":0},{"$f":"'Budget Summary'!J149-J152","v":0},{"$f":"'Budget Summary'!K149-K152","v":0},{"$f":"'Budget Summary'!L149-L152","v":0}]
[]
[null,"S-4","Total General Fund and Forecasted Revenues Available",null,null,null,null,{"$f":"H119+H137","v":0},{"$f":"I119+I137","v":0},{"$f":"J119+J137","v":0},{"$f":"K119+K137","v":0},{"$f":"L119+L137","v":0}]
[]
[null,"S-5","Amount requested from County Commissioners",null,null,null,null,{"$f":"+H112+H115","v":0},{"$f":"+I112+I115","v":0},{"$f":"+J112+J115","v":0},{"$f":"+K112+K115","v":0},{"$f":"+L112+L115","v":0}]
[]
[null,"S-6",null,null,null,null,"Additional Funding Needed :  ",null,null,{"$f":"IF(J98+J99+J100-J102<0,0,J98+J99+J100-J102)","v":0},{"$f":"IF(K98+K99+K100-K102<0,0,K98+K99+K100-K102)","v":0},{"$f":"IF(L98+L99+L100-L102<0,0,L98+L99+L100-L102)","v":0},{"$f":"IF(AND(J106=0,K106=0),\"Balanced or Surplus - No Additional Funding Needed\",\"Deficit - Additional Funding Needed to Meet Budget Needs\")","v":"Balanced or Surplus - No Additional Funding Needed"}]
[]
[]
[null,"REVENUE SUMMARY",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
[]
[null,"S-7","Operating Revenues",null,null,null,null,{"$f":"+Revenue!H26","v":0},{"$f":"+Revenue!I26","v":0},{"$f":"+Revenue!J26","v":0},{"$f":"+Revenue!K26","v":0},{"$f":"+Revenue!L26","v":0}]
[null,"S-8","Tax levy (From the County Treasurer)",null,null,null,null,{"$f":"+Revenue!H10","v":0},{"$f":"+Revenue!I10","v":0},{"$f":"+Revenue!J10","v":0},{"$f":"+Revenue!K10","v":0},{"$f":"+Revenue!L10","v":0}]
[null,"S-9","Government Support",null,null,null,null,{"$f":"+Revenue!H21","v":0},{"$f":"+Revenue!I21","v":0},{"$f":"+Revenue!J21","v":0},{"$f":"+Revenue!K21","v":0},{"$f":"+Revenue!L21","v":0}]
[null,"S-10","Grants",null,null,null,null,{"$f":"+Revenue!H31","v":0},{"$f":"+Revenue!I31","v":0},{"$f":"+Revenue!J31","v":0},{"$f":"+Revenue!K31","v":0},{"$f":"+Revenue!L31","v":0}]
[null,"S-11","Other County Support (Not from Co. Treas.)",null,null,null,null,{"$f":"+Revenue!H11","v":0},{"$f":"+Revenue!I11","v":0},{"$f":"+Revenue!J11","v":0},{"$f":"+Revenue!K11","v":0},{"$f":"+Revenue!L11","v":0}]
[null,"S-12","Miscellaneous",null,null,null,null,{"$f":"+Revenue!H36","v":0},{"$f":"+Revenue!I36","v":0},{"$f":"+Revenue!J36","v":0},{"$f":"+Revenue!K36","v":0},{"$f":"+Revenue!L36","v":0}]
[null,"S-13","Other Forecasted Revenue",null,null,null,null,{"$f":"+Revenue!H45","v":0},{"$f":"+Revenue!I45","v":0},{"$f":"+Revenue!J45","v":0},{"$f":"+Revenue!K45","v":0},{"$f":"+Revenue!L45","v":0}]
[]
[null,"S-14","Total Revenue",null,null,null,null,{"$f":"SUM(H111:H117)","v":0},{"$f":"SUM(I111:I117)","v":0},{"$f":"SUM(J111:J117)","v":0},{"$f":"SUM(K111:K117)","v":0},{"$f":"SUM(L111:L117)","v":0}]
[null,{"$f":"\"FY \"&TEXT(DATE('Instructions (Please Read)'!$P$2-1,7,1),\"m/d/y\")&\"-\"&TEXT(DATE('Instructions (Please Read)'!$P$2,6,30),\"m/d/y\")","v":"FY 7/1/23-6/30/24"},null,null,null,null,null,null,null,null,{"$f":"IF(B3=\"\",\"\",B3)","v":""}]
[null,"EXPENDITURE SUMMARY",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
[]
[null,"S-15","Capital Outlay",null,null,null,null,{"$f":"+Expenditures!H17","v":0},{"$f":"+Expenditures!I17","v":0},{"$f":"+Expenditures!J17","v":0},{"$f":"+Expenditures!K17","v":0},{"$f":"+Expenditures!L17","v":0}]
[null,"S-16","Interest and Fees On Debt",null,null,null,null,{"$f":"Expenditures!H135+Expenditures!H136","v":0},{"$f":"Expenditures!I135+Expenditures!I136","v":0},{"$f":"Expenditures!J135+Expenditures!J136","v":0},{"$f":"Expenditures!K135+Expenditures!K136","v":0},{"$f":"Expenditures!L135+Expenditures!L136","v":0}]
[null,"S-17","Administration ",null,null,null,null,{"$f":"+Expenditures!H55","v":0},{"$f":"+Expenditures!I55","v":0},{"$f":"+Expenditures!J55","v":0},{"$f":"+Expenditures!K55","v":0},{"$f":"+Expenditures!L55","v":0}]
[null,"S-18","Operations",null,null,null,null,{"$f":"+Expenditures!H100","v":0},{"$f":"+Expenditures!I100","v":0},{"$f":"+Expenditures!J100","v":0},{"$f":"+Expenditures!K100","v":0},{"$f":"+Expenditures!L100","v":0}]
[null,"S-19","Indirect Costs",null,null,null,null,{"$f":"+Expenditures!H127","v":0},{"$f":"+Expenditures!I127","v":0},{"$f":"+Expenditures!J127","v":0},{"$f":"+Expenditures!K127","v":0},{"$f":"+Expenditures!L127","v":0}]
["From line S-32","S-20R","Expenditures paid by Reserves",null,null,null,null,{"$f":"H152","v":0},0,0,0,{"$f":"L152","v":0}]
[null,"S-20","Total Expenditures ",null,null,null,null,{"$f":"SUM(H123:H128)","v":0},0,0,0,{"$f":"SUM(L123:L128)","v":0}]
[]
[null,"DEBT SUMMARY",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
[]
[null,"S-21","Principal Paid on Debt",null,null,null,null,{"$f":"Expenditures!H134","v":0},{"$f":"Expenditures!I134","v":0},{"$f":"Expenditures!J134","v":0},{"$f":"Expenditures!K134","v":0},{"$f":"Expenditures!L134","v":0}]
[]
[null,"CASH AND INVESTMENTS",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
[]
[null,"S-22","TOTAL GENERAL FUNDS",null,null,null,null,{"$f":"SUM('Cash & Investments'!H9:H12)","v":0},{"$f":"SUM('Cash & Investments'!I9:I12)","v":0},{"$f":"SUM('Cash & Investments'!J9:J12)","v":0},{"$f":"SUM('Cash & Investments'!K9:K12)","v":0},{"$f":"SUM('Cash & Investments'!L9:L12)","v":0}]
[]
[null,"Summary of Reserve Funds"]
[null,"S-23","Beginning Balance in Reserve Accounts"]
[null,"S-24","a. Sinking and Debt Service Funds",null,null,null,null,{"$f":"'Cash & Investments'!H27","v":0},{"$f":"'Cash & Investments'!I27","v":0},{"$f":"'Cash & Investments'!J27","v":0},{"$f":"'Cash & Investments'!K27","v":0},{"$f":"'Cash & Investments'!L27","v":0}]
[null,"S-25","b. Reserves",null,null,null,null,{"$f":"'Cash & Investments'!H43","v":0},{"$f":"'Cash & Investments'!I43","v":0},{"$f":"'Cash & Investments'!J43","v":0},{"$f":"'Cash & Investments'!K43","v":0},{"$f":"'Cash & Investments'!L43","v":0}]
[null,"S-26","c. Bond Funds",null,null,null,null,{"$f":"'Cash & Investments'!H59","v":0},{"$f":"'Cash & Investments'!I59","v":0},{"$f":"'Cash & Investments'!J59","v":0},{"$f":"'Cash & Investments'!K59","v":0},{"$f":"'Cash & Investments'!L59","v":0}]
[null,null,null,null,"Total Reserves (a+b+c)",null,null,{"$f":"SUM(H141:H143)","v":0},{"$f":"SUM(I141:I143)","v":0},{"$f":"SUM(J141:J143)","v":0},{"$f":"SUM(K141:K143)","v":0},{"$f":"SUM(L141:L143)","v":0}]
[null,"S-27","Amount to be added "]
[null,"S-28","a. Sinking and Debt Service Funds",null,null,null,null,{"$f":"'Cash & Investments'!H29","v":0},{"$f":"'Cash & Investments'!I29","v":0},{"$f":"'Cash & Investments'!J29","v":0},{"$f":"'Cash & Investments'!K29","v":0},{"$f":"'Cash & Investments'!L29","v":0}]
[null,"S-29","b. Reserves",null,null,null,null,{"$f":"'Cash & Investments'!H45","v":0},{"$f":"'Cash & Investments'!I45","v":0},{"$f":"'Cash & Investments'!J45","v":0},{"$f":"'Cash & Investments'!K45","v":0},{"$f":"'Cash & Investments'!L45","v":0}]
[null,"S-30","c. Bond Funds",null,null,null,null,{"$f":"'Cash & Investments'!H61","v":0},{"$f":"'Cash & Investments'!I61","v":0},{"$f":"'Cash & Investments'!J61","v":0},{"$f":"'Cash & Investments'!K61","v":0},{"$f":"'Cash & Investments'!L61","v":0}]
[null,null,null,"Total to be added (a+b+c)",null,null,null,{"$f":"SUM(H146:H148)","v":0},{"$f":"SUM(I146:I148)","v":0},{"$f":"SUM(J146:J148)","v":0},{"$f":"SUM(K146:K148)","v":0},{"$f":"SUM(L146:L148)","v":0}]
[]
[null,"S-31","Subtotal",null,null,null,null,{"$f":"+H144+H149","v":0},{"$f":"+I144+I149","v":0},{"$f":"+J144+J149","v":0},{"$f":"+K144+K149","v":0},{"$f":"+L144+L149","v":0}]
[null,"S-32","Less Total to be spent",null,null,null,null,{"$f":"'Cash & Investments'!H68","v":0},{"$f":"'Cash & Investments'!I68","v":0},{"$f":"'Cash & Investments'!J68","v":0},{"$f":"'Cash & Investments'!K68","v":0},{"$f":"'Cash & Investments'!L68","v":0},"To line S-20R"]
[null,"S-33","TOTAL RESERVES AT END OF FISCAL YEAR",null,null,null,null,{"$f":"+H151-H152","v":0},{"$f":"+I151-I152","v":0},{"$f":"+J151-J152","v":0},{"$f":"+K151-K152","v":0},{"$f":"+L151-L152","v":0}]
[null,null,null,null,null,null,null,null,null,null,"End of Summary"]
[]
[null,null,null,null,null,null,null,"Date adopted by Special District"]
[null,"Budget Officer / District Official (if not same as \"Submitted by\")"]
[]
[]
[]
[null,"DISTRICT ADDRESS:",null,{"$f":"IF(COUNTA('Budget Summary'!B5)=1,'Budget Summary'!B5,\"\")","v":""},null,null,null,"PREPARED BY:",null,{"$f":"IF(COUNTA('Budget Summary'!I32)=1,'Budget Summary'!I32,\"Enter on First Page\")","v":"Enter on First Page"}]
[null,null,null,{"$f":"IF(COUNTA('Budget Summary'!B6)=1,'Budget Summary'!B6,\"\")","v":""}]
[]
[null,"DISTRICT PHONE:",null,{"$f":"IF(COUNTA('Budget Summary'!B7)=1,'Budget Summary'!B7,\"\")","v":""}]
[]
[null,"Prepared in compliance with the Uniform Municipal Fiscal Procedures Act (W.S. 16-4-101 through 124) as it applies."]
[null,"2019-01-23","Form approved by Wyoming Department of Audit, Public Funds Division",null,null,null,null,null,null,null,null,{"$f":"\"FY \"&TEXT(DATE('Instructions (Please Read)'!$P$2-1,7,1),\"m/d/y\")&\"-\"&TEXT(DATE('Instructions (Please Read)'!$P$2,6,30),\"m/d/y\")","v":"FY 7/1/23-6/30/24"}]

{"sheet":"Revenue","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[33,3,33,4],[2,1,2,4],[3,1,3,4],[0,1,0,11],[43,3,43,5]]}
[null,{"$f":"VLOOKUP('Instructions (Please Read)'!U2,'Instructions (Please Read)'!R1:S8,2,FALSE)","v":"Proposed Budget"}]
[]
[null,{"$f":"IF('Budget Summary'!B3=\"\",\"Please Enter Name on First Page\",'Budget Summary'!B3)","v":"Please Enter Name on First Page"},null,null,null,null,null,null,null,"FYE",{"$f":"'Instructions (Please Read)'!O2","v":"2024-06-30"}]
[null,"NAME OF DISTRICT/BOARD"]
[]
[null,"PROPERTY TAXES AND ASSESSMENTS"]
[]
[null,null,null,null,null,null,"DOA Chart        of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
[null,"R-1","Property Taxes and Assessments Received"]
["H-1","R-1.1","Tax Levy (From the County Treasurer)",null,null,null,4001,null,null,null,{"$f":"J10","v":0},{"$f":"K10","v":0}]
["H-2","R-1.2","Other County Support (see note on the right)",null,null,null,4005,null,null,null,{"$f":"J11","v":0},{"$f":"K11","v":0}]
[]
[null,"FORECASTED REVENUE"]
[]
[null,null,null,null,null,null,"DOA Chart        of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["G-1","R-2","Revenues from Other Governments"]
["G-1.1","R-2.1","State Aid",null,null,null,4211,null,null,null,{"$f":"J17","v":0},0]
["G-1.2","R-2.2","Additional County Aid (non-treasurer)",null,null,null,4237,null,null,null,0,0]
["G-1.3","R-2.3","City (or Town) Aid",null,null,null,4237,null,null,null,0,0]
["G-1.4","R-2.4","Other (Specify)",null,null,null,4237,null,null,null,0,0]
["G-1.5","R-2.5","Total Government Support",null,null,null,null,{"$f":"SUM(H17:H20)","v":0},{"$f":"SUM(I17:I20)","v":0},{"$f":"SUM(J17:J20)","v":0},{"$f":"SUM(K17:K20)","v":0},{"$f":"SUM(L17:L20)","v":0}]
["G-2","R-3","Operating Revenues"]
["G-2.1","R-3.1","Customer Charges",null,null,null,4300,null,null,null,{"$f":"J23","v":0},0]
["G-2.2","R-3.2","Sales of Goods or Services",null,null,null,4300,null,null,null,0,0]
["G-2.3","R-3.3","Other Assessments",null,null,null,4503,null,null,null,0,0]
["G-2.4","R-3.4","Total Operating Revenues",null,null,null,null,{"$f":"SUM(H23:H25)","v":0},{"$f":"SUM(I23:I25)","v":0},{"$f":"SUM(J23:J25)","v":0},{"$f":"SUM(K23:K25)","v":0},{"$f":"SUM(L23:L25)","v":0}]
["G-3","R-4","Grants"]
["G-3.1","R-4.1","Direct Federal Grants",null,null,null,4201,null,null,null,{"$f":"J28","v":0},0]
["G-3.2","R-4.2","Federal Grants thru State Agencies",null,null,null,4201,null,null,null,0,0]
["G-3.3",{"$f":"IF(SUM('Additional Details'!$N$22:$Q$22)=0,\"R-4.3\",\"R-4.3\")","v":"R-4.3"},"Grants from State Agencies",null,null,null,4211,null,null,null,0,0]
["G-3.4","R-4.4","Total Grants",null,null,null,null,{"$f":"SUM(H28:H30)","v":0},{"$f":"SUM(I28:I30)","v":0},{"$f":"SUM(J28:J30)","v":0},{"$f":"SUM(K28:K30)","v":0},{"$f":"SUM(L28:L30)","v":0}]
["G-4","R-5","Miscellaneous Revenue"]
["G-4.1","R-5.1","Interest",null,null,null,4501,null,null,null,{"$f":"J33","v":0},{"$f":"K33","v":0}]
["G-4.2","R-5.2","Other: Specify",null,null,null,4500,null,null,null,{"$f":"J34","v":0},{"$f":"K34","v":0}]
[{"$f":"IF(SUM('Additional Details'!$N$22:$Q$22)=0,\"G-4.3\",\"G-4.3\")","v":"G-4.3"},"R-5.3",{"$f":"IF(SUM('Additional Details'!$N$22:$Q$22)=0,\"Other: Additional\",\"Other: See Additional\")","v":"Other: Additional"},null,null,null,null,{"$f":"IF('Additional Details'!N22=0,\"\",'Additional Details'!N22)","v":""},{"$f":"IF('Additional Details'!O22=0,\"\",'Additional Details'!O22)","v":""},{"$f":"IF('Additional Details'!P22=0,\"\",'Additional Details'!P22)","v":""},{"$f":"IF('Additional Details'!Q22=0,\"\",'Additional Details'!Q22)","v":""},{"$f":"IF('Additional Details'!R22=0,\"\",'Additional Details'!R22)","v":""}]
["G-4.4","R-5.4","Total Miscellaneous",null,null,null,null,{"$f":"SUM(H33:H35)","v":0},{"$f":"SUM(I33:I35)","v":0},{"$f":"SUM(J33:J35)","v":0},{"$f":"SUM(K33:K35)","v":0},{"$f":"SUM(L33:L35)","v":0}]
["G-5","R-5.5","Total Forecasted Revenue",null,null,null,null,{"$f":"+H36+H31+H26+H21","v":0},{"$f":"+I36+I31+I26+I21","v":0},{"$f":"+J36+J31+J26+J21","v":0},{"$f":"+K36+K31+K26+K21","v":0},{"$f":"+L36+L31+L26+L21","v":0}]
[]
["G-12","R-6","Other Forecasted Revenue"]
["G-12.1","R-6.1","a. Other past due as estimated by Co. Treas.",null,null,null,4004,null,null,null,{"$f":"J40","v":0},{"$f":"K40","v":0}]
["G-12.2","R-6.2","b. Other forecasted revenue (specify): "]
["G-12.3","R-6.3",null,null,null,null,4500,null,null,null,{"$f":"J42","v":0},{"$f":"K42","v":0}]
["G-12.4","R-6.4",null,null,null,null,4500,null,null,null,{"$f":"J43","v":0},{"$f":"K43","v":0}]
["G-12.5","R-6.5",null,null,null,null,null,{"$f":"IF('Additional Details'!N25=0,\"\",'Additional Details'!N25)","v":""},{"$f":"IF('Additional Details'!O25=0,\"\",'Additional Details'!O25)","v":""},{"$f":"IF('Additional Details'!P25=0,\"\",'Additional Details'!P25)","v":""},{"$f":"IF('Additional Details'!Q25=0,\"\",'Additional Details'!Q25)","v":""},{"$f":"IF('Additional Details'!R25=0,\"\",'Additional Details'!R25)","v":""}]
["G-12.6","R-6.6",{"$f":"IF(SUM('Additional Details'!N25:Q25)>0,\"Total Other Forecasted Revenue (a+b) with additional details\",\"Total Other Forecasted Revenue (a+b)\")","v":"Total Other Forecasted Revenue (a+b)"},null,null,null,null,{"$f":"SUM(H40:H44)","v":0},{"$f":"SUM(I40:I44)","v":0},{"$f":"SUM(J40:J44)","v":0},{"$f":"SUM(K40:K44)","v":0},{"$f":"SUM(L40:L44)","v":0}]

{"sheet":"Expenditures","index":3,"n_rows":137,"n_cols":14,"rows_kept":137,"cut":false,"hidden":false,"merged":[[0,1,0,11],[8,2,8,3],[132,2,132,3],[23,2,23,3],[31,2,31,3],[38,2,38,3],[30,3,30,4],[37,3,37,4],[62,2,62,3],[15,3,15,4],[19,2,19,3],[68,3,68,4],[74,3,74,4],[75,2,75,4],[44,3,44,4],[53,3,53,4],[114,3,114,4],[124,3,124,4],[92,3,92,4],[98,3,98,4],[1,1,1,4],[2,1,2,4],[80,3,80,4],[81,2,81,4],[56,1,56,11],[57,1,57,4],[102,1,102,4],[101,1,101,10],[86,3,86,4]]}
[null,{"$f":"VLOOKUP('Instructions (Please Read)'!$U$2,'Instructions (Please Read)'!$R$1:$S$8,2,FALSE)","v":"Proposed Budget"}]
[null,{"$f":"IF('Budget Summary'!$B$3=\"\",\"Please Enter Name on First Page\",'Budget Summary'!$B$3)","v":"Please Enter Name on First Page"},null,null,null,null,null,null,null,"FYE",{"$f":"'Instructions (Please Read)'!$O$2","v":"2024-06-30"}]
[null,"NAME OF DISTRICT/BOARD"]
[]
[]
[null,"CAPITAL OUTLAY BUDGET"]
[]
[null,null,null,null,null,null,"DOA Chart of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["E-1","E-1","Capital Outlay"]
["E-1.1","E-1.1","Real Property",null,null,null,6201,null,null,null,{"$f":"J10","v":0},0]
["E-1.2","E-1.2","Vehicles",null,null,null,6210,null,null,null,0,0]
["E-1.3","E-1.3","Office Equipment",null,null,null,6211,null,null,null,0,0]
["E-1.4","E-1.4","Other (Specify) "]
["E-1.5","E-1.5",null,null,null,null,6200,null,null,null,{"$f":"J14","v":0},{"$f":"K14","v":0}]
["E-1.6","E-1.6",null,null,null,null,6200,null,null,null,{"$f":"J15","v":0},{"$f":"K15","v":0}]
[{"$f":"IF(SUM(G16:J16)=0,\"\",\"E-1.7\")","v":""},"E-1.7",null,{"$f":"IF(SUM(H16:K16)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N20=0,\"\",'Additional Details'!N20)","v":""},{"$f":"IF('Additional Details'!O20=0,\"\",'Additional Details'!O20)","v":""},{"$f":"IF('Additional Details'!P20=0,\"\",'Additional Details'!P20)","v":""},{"$f":"IF('Additional Details'!Q20=0,\"\",'Additional Details'!Q20)","v":""},{"$f":"IF('Additional Details'!R20=0,\"\",'Additional Details'!R20)","v":""}]
["E-2","E-1.8","TOTAL CAPITAL OUTLAY",null,null,null,null,{"$f":"SUM(H10:H16)","v":0},{"$f":"SUM(I10:I16)","v":0},{"$f":"SUM(J10:J16)","v":0},{"$f":"SUM(K10:K16)","v":0},{"$f":"SUM(L10:L16)","v":0}]
[]
[]
[]
[null,"ADMINISTRATION BUDGET"]
[]
[null,null,null,null,null,null,"DOA Chart of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["B-1","E-2","Personnel Services"]
["B-1.1","E-2.1","Administrator",null,null,null,7002,null,null,null,{"$f":"J25","v":0},0]
["B-1.2","E-2.2","Secretary",null,null,null,7003,null,null,null,0,0]
["B-1.3","E-2.3","Clerical",null,null,null,7004,null,null,null,0,0]
["B-1.4","E-2.4","Other (Specify)"]
["B-1.5","E-2.5",null,null,null,null,7005,null,null,null,{"$f":"J29","v":0},{"$f":"K29","v":0}]
["B-1.6","E-2.6",null,null,null,null,7005,null,null,null,{"$f":"J30","v":0},{"$f":"K30","v":0}]
[{"$f":"IF(SUM(G31:J31)=0,\"\",\"B-1.7\")","v":""},"E-2.7",null,{"$f":"IF(SUM(H31:K31)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N5=0,\"\",'Additional Details'!N5)","v":""},{"$f":"IF('Additional Details'!O5=0,\"\",'Additional Details'!O5)","v":""},{"$f":"IF('Additional Details'!P5=0,\"\",'Additional Details'!P5)","v":""},{"$f":"IF('Additional Details'!Q5=0,\"\",'Additional Details'!Q5)","v":""},{"$f":"IF('Additional Details'!R5=0,\"\",'Additional Details'!R5)","v":""}]
["B-2","E-3","Board Expenses"]
["B-2.1","E-3.1","Travel",null,null,null,7011,null,null,null,{"$f":"J33","v":0},{"$f":"K33","v":0}]
["B-2.2","E-3.2","Mileage",null,null,null,7012,null,null,null,{"$f":"J34","v":0},{"$f":"K34","v":0}]
["B-2.3","E-3.3","Other (Specify)",null,null,null,7013]
["B-2.4","E-3.4",null,null,null,null,7013,null,null,null,{"$f":"J36","v":0},{"$f":"K36","v":0}]
["B-2.5","E-3.5",null,null,null,null,7013,null,null,null,{"$f":"J37","v":0},{"$f":"K37","v":0}]
[{"$f":"IF(SUM(G38:J38)=0,\"\",\"B-2.6\")","v":""},"E-3.6",null,{"$f":"IF(SUM(H38:K38)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N6=0,\"\",'Additional Details'!N6)","v":""},{"$f":"IF('Additional Details'!O6=0,\"\",'Additional Details'!O6)","v":""},{"$f":"IF('Additional Details'!P6=0,\"\",'Additional Details'!P6)","v":""},{"$f":"IF('Additional Details'!Q6=0,\"\",'Additional Details'!Q6)","v":""},{"$f":"IF('Additional Details'!R6=0,\"\",'Additional Details'!R6)","v":""}]
["B-3","E-4","Contractual Services"]
["B-3.1","E-4.1","Legal",null,null,null,7021,null,null,null,{"$f":"J40","v":0},{"$f":"K40","v":0}]
["B-3.2","E-4.2","Accounting/Auditing",null,null,null,7022,null,null,null,{"$f":"J41","v":0},{"$f":"K41","v":0}]
["B-3.3","E-4.3","Other (Specify) "]
["B-3.4","E-4.4",null,null,null,null,7023,null,null,null,{"$f":"J43","v":0},{"$f":"K43","v":0}]
["B-3.5","E-4.5",null,null,null,null,7023,null,null,null,{"$f":"J44","v":0},{"$f":"K44","v":0}]
[{"$f":"IF(SUM(G45:J45)=0,\"\",\"B-3.6\")","v":""},"E-4.6",null,{"$f":"IF(SUM(H45:K45)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N7=0,\"\",'Additional Details'!N7)","v":""},{"$f":"IF('Additional Details'!O7=0,\"\",'Additional Details'!O7)","v":""},{"$f":"IF('Additional Details'!P7=0,\"\",'Additional Details'!P7)","v":""},{"$f":"IF('Additional Details'!Q7=0,\"\",'Additional Details'!Q7)","v":""},{"$f":"IF('Additional Details'!R7=0,\"\",'Additional Details'!R7)","v":""}]
["B-4","E-5","Other Administrative Expenses"]
["B-4.1","E-5.1","Office Supplies",null,null,null,7031,null,null,null,{"$f":"J47","v":0},0]
["B-4.2","E-5.2","Office equipment, rent & repair",null,null,null,7032,null,null,null,0,0]
["B-4.3","E-5.3","Education",null,null,null,7033,null,null,null,0,0]
["B-4.4","E-5.4","Registrations",null,null,null,7034,null,null,null,0,0]
["B-4.5","E-5.5","Other (Specify) "]
["B-4.6","E-5.6",null,null,null,null,7035,null,null,null,{"$f":"J52","v":0},{"$f":"K52","v":0}]
["B-4.7","E-5.7",null,null,null,null,7035,null,null,null,{"$f":"J53","v":0},{"$f":"K53","v":0}]
[{"$f":"IF(SUM(G54:J54)=0,\"\",\"B-4.8\")","v":""},"E-5.8",null,{"$f":"IF(SUM(H54:K54)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N8=0,\"\",'Additional Details'!N8)","v":""},{"$f":"IF('Additional Details'!O8=0,\"\",'Additional Details'!O8)","v":""},{"$f":"IF('Additional Details'!P8=0,\"\",'Additional Details'!P8)","v":""},{"$f":"IF('Additional Details'!Q8=0,\"\",'Additional Details'!Q8)","v":""},{"$f":"IF('Additional Details'!R8=0,\"\",'Additional Details'!R8)","v":""}]
["B-5","E-6","TOTAL ADMINISTRATION ",null,null,null,null,{"$f":"SUM(H25:H54)","v":0},{"$f":"SUM(I25:I54)","v":0},{"$f":"SUM(J25:J54)","v":0},{"$f":"SUM(K25:K54)","v":0},{"$f":"SUM(L25:L54)","v":0}]
[]
[null,{"$f":"VLOOKUP('Instructions (Please Read)'!$U$2,'Instructions (Please Read)'!$R$1:$S$8,2,FALSE)","v":"Proposed Budget"}]
[null,{"$f":"IF('Budget Summary'!$B$3=\"\",\"Please Enter Name on First Page\",'Budget Summary'!$B$3)","v":"Please Enter Name on First Page"},null,null,null,null,null,null,null,"FYE",{"$f":"'Instructions (Please Read)'!$O$2","v":"2024-06-30"}]
[]
[null,"OPERATIONS BUDGET"]
[]
[null,null,null,null,null,null,"DOA Chart of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["C-1","E-7","Personnel Services"]
["C-1.1","E-7.1","Wages--Operations",null,null,null,7202,null,null,null,{"$f":"J64","v":0},{"$f":"K64","v":0}]
["C-1.2","E-7.2","Service Contracts",null,null,null,7203,null,null,null,{"$f":"J65","v":0},{"$f":"K65","v":0}]
["C-1.3","E-7.3","Other (Specify) "]
["C-1.4","E-7.4",null,null,null,null,7204,null,null,null,{"$f":"J67","v":0},{"$f":"K67","v":0}]
["C-1.5","E-7.5",null,null,null,null,7204,null,null,null,{"$f":"J68","v":0},{"$f":"K68","v":0}]
["C-1.6","E-7.6",null,{"$f":"IF(SUM(H69:K69)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N10=0,\"\",'Additional Details'!N10)","v":""},{"$f":"IF('Additional Details'!O10=0,\"\",'Additional Details'!O10)","v":""},{"$f":"IF('Additional Details'!P10=0,\"\",'Additional Details'!P10)","v":""},{"$f":"IF('Additional Details'!Q10=0,\"\",'Additional Details'!Q10)","v":""},{"$f":"IF('Additional Details'!R10=0,\"\",'Additional Details'!R10)","v":""}]
["C-2","E-8","Travel"]
["C-2.1","E-8.1","Mileage",null,null,null,7211,null,null,null,{"$f":"J71","v":0},{"$f":"K71","v":0}]
["C-2.2","E-8.2","Other (Specify) "]
["C-2.3","E-8.3",null,null,null,null,7212,null,null,null,{"$f":"J73","v":0},{"$f":"K73","v":0}]
["C-2.4","E-8.4",null,null,null,null,7212,null,null,null,{"$f":"J74","v":0},{"$f":"K74","v":0}]
["C-2.5","E-8.5",null,{"$f":"IF(SUM(H75:K75)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N11=0,\"\",'Additional Details'!N11)","v":""},{"$f":"IF('Additional Details'!O11=0,\"\",'Additional Details'!O11)","v":""},{"$f":"IF('Additional Details'!P11=0,\"\",'Additional Details'!P11)","v":""},{"$f":"IF('Additional Details'!Q11=0,\"\",'Additional Details'!Q11)","v":""},{"$f":"IF('Additional Details'!R11=0,\"\",'Additional Details'!R11)","v":""}]
["C-3","E-9","Operating supplies (List) "]
["C-3.1","E-9.1",null,null,null,null,7220,null,null,null,{"$f":"J77","v":0},0]
["C-3.2","E-9.2",null,null,null,null,7220,null,null,null,0,0]
["C-3.3","E-9.3",null,null,null,null,7220,null,null,null,0,0]
["C-3.4","E-9.4",null,null,null,null,7220,null,null,null,0,0]
["C-3.5","E-9.5",null,{"$f":"IF(SUM(H81:K81)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N12=0,\"\",'Additional Details'!N12)","v":""},{"$f":"IF('Additional Details'!O12=0,\"\",'Additional Details'!O12)","v":""},{"$f":"IF('Additional Details'!P12=0,\"\",'Additional Details'!P12)","v":""},{"$f":"IF('Additional Details'!Q12=0,\"\",'Additional Details'!Q12)","v":""},{"$f":"IF('Additional Details'!R12=0,\"\",'Additional Details'!R12)","v":""}]
["C-4","E-10","Program Services (List)"]
["C-4.1","E-10.1",null,null,null,null,7230,null,null,null,{"$f":"J83","v":0},0]
["C-4.2","E-10.2",null,null,null,null,7230,null,null,null,0,0]
["C-4.3","E-10.3",null,null,null,null,7230,null,null,null,0,0]
["C-4.4","E-10.4",null,null,null,null,7230,null,null,null,0,0]
["C-4.5","E-10.5",null,{"$f":"IF(SUM(H87:K87)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N13=0,\"\",'Additional Details'!N13)","v":""},{"$f":"IF('Additional Details'!O13=0,\"\",'Additional Details'!O13)","v":""},{"$f":"IF('Additional Details'!P13=0,\"\",'Additional Details'!P13)","v":""},{"$f":"IF('Additional Details'!Q13=0,\"\",'Additional Details'!Q13)","v":""},{"$f":"IF('Additional Details'!R13=0,\"\",'Additional Details'!R13)","v":""}]
["C-5","E-11","Contractual Arrangements (List)  "]
["C-5.1","E-11.1",null,null,null,null,7400,null,null,null,{"$f":"J89","v":0},0]
["C-5.2","E-11.2",null,null,null,null,7400,null,null,null,0,0]
["C-5.3","E-11.3",null,null,null,null,7400,null,null,null,0,0]
["C-5.4","E-11.4",null,null,null,null,7400,null,null,null,0,0]
["C-5.5","E-11.5",null,{"$f":"IF(SUM(H93:K93)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N14=0,\"\",'Additional Details'!N14)","v":""},{"$f":"IF('Additional Details'!O14=0,\"\",'Additional Details'!O14)","v":""},{"$f":"IF('Additional Details'!P14=0,\"\",'Additional Details'!P14)","v":""},{"$f":"IF('Additional Details'!Q14=0,\"\",'Additional Details'!Q14)","v":""},{"$f":"IF('Additional Details'!R14=0,\"\",'Additional Details'!R14)","v":""}]
["C-6","E-12","Other operations (Specify)  "]
["C-6.1","E-12.1",null,null,null,null,7450,null,null,null,{"$f":"J95","v":0},0]
["C-6.2","E-12.2",null,null,null,null,7450,null,null,null,0,0]
["C-6.3","E-12.3",null,null,null,null,7450,null,null,null,0,0]
["C-6.4","E-12.4",null,null,null,null,7450,null,null,null,0,0]
["C-6.5","E-12.5",null,{"$f":"IF(SUM(H99:K99)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N15=0,\"\",'Additional Details'!N15)","v":""},{"$f":"IF('Additional Details'!O15=0,\"\",'Additional Details'!O15)","v":""},{"$f":"IF('Additional Details'!P15=0,\"\",'Additional Details'!P15)","v":""},{"$f":"IF('Additional Details'!Q15=0,\"\",'Additional Details'!Q15)","v":""},{"$f":"IF('Additional Details'!R15=0,\"\",'Additional Details'!R15)","v":""}]
["C-7","E-13","TOTAL OPERATIONS",null,null,null,null,{"$f":"SUM(H64:H99)","v":0},{"$f":"SUM(I64:I99)","v":0},{"$f":"SUM(J64:J99)","v":0},{"$f":"SUM(K64:K99)","v":0},{"$f":"SUM(L64:L99)","v":0}]
[]
[null,{"$f":"VLOOKUP('Instructions (Please Read)'!$U$2,'Instructions (Please Read)'!$R$1:$S$8,2,FALSE)","v":"Proposed Budget"}]
[null,{"$f":"IF('Budget Summary'!$B$3=\"\",\"Please Enter Name on First Page\",'Budget Summary'!$B$3)","v":"Please Enter Name on First Page"},null,null,null,null,null,null,null,"FYE",{"$f":"'Instructions (Please Read)'!$O$2","v":"2024-06-30"}]
[]
[null,"INDIRECT COSTS BUDGET"]
[]
[null,null,null,null,null,null,"DOA Chart of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["D-1","E-14","Insurance"]
["D-1.1","E-14.1","Liability",null,null,null,7502,null,null,null,{"$f":"J109","v":0},0]
["D-1.2","E-14.2","Buildings and vehicles",null,null,null,7503,null,null,null,0,0]
["D-1.3","E-14.3","Equipment",null,null,null,7504,null,null,null,0,0]
["D-1.4","E-14.4","Other (Specify) "]
["D-1.5","E-14.5",null,null,null,null,7505,null,null,null,{"$f":"J113","v":0},{"$f":"K113","v":0}]
["D-1.6","E-14.6",null,null,null,null,7505,null,null,null,{"$f":"J114","v":0},{"$f":"K114","v":0}]
["D-1.7","E-14.7",null,{"$f":"IF(SUM(H115:K115)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N17=0,\"\",'Additional Details'!N17)","v":""},{"$f":"IF('Additional Details'!O17=0,\"\",'Additional Details'!O17)","v":""},{"$f":"IF('Additional Details'!P17=0,\"\",'Additional Details'!P17)","v":""},{"$f":"IF('Additional Details'!Q17=0,\"\",'Additional Details'!Q17)","v":""},{"$f":"IF('Additional Details'!R17=0,\"\",'Additional Details'!R17)","v":""}]
["D-2","E-15","Indirect payroll costs:"]
["D-2.1","E-15.1","FICA (Social Security) taxes",null,null,null,7511,null,null,null,{"$f":"J117","v":0},{"$f":"K117","v":0}]
["D-2.2","E-15.2","Workers Compensation",null,null,null,7512,null,null,null,0,0]
["D-2.3","E-15.3","Unemployment Taxes",null,null,null,7513,null,null,null,0,0]
["D-2.4","E-15.4","Retirement",null,null,null,7514,null,null,null,0,0]
["D-2.5","E-15.5","Health Insurance",null,null,null,7515,null,null,null,0,0]
["D-2.6","E-15.6","Other (Specify) ",null,null,null,null,null,null,null,0,0]
[null,"E-15.7",null,null,null,null,7516,null,null,null,0,0]
[null,"E-15.8",null,null,null,null,7516,null,null,null,0,0]
[null,"E-15.9",null,{"$f":"IF(SUM(H125:K125)=0,\"\",\"see additional details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N18=0,\"\",'Additional Details'!N18)","v":""},{"$f":"IF('Additional Details'!O18=0,\"\",'Additional Details'!O18)","v":""},{"$f":"IF('Additional Details'!P18=0,\"\",'Additional Details'!P18)","v":""},{"$f":"IF('Additional Details'!Q18=0,\"\",'Additional Details'!Q18)","v":""},{"$f":"IF('Additional Details'!R18=0,\"\",'Additional Details'!R18)","v":""}]
["D-3",null,null,null,null,null,null,null,null,null,null,null,null,"Note: Line E-16 (Depreciation Expenses) has been removed from the budget form for 2019-20."]
["D-4","E-17","TOTAL INDIRECT COSTS",null,null,null,null,{"$f":"SUM(H109:H125)","v":0},{"$f":"SUM(I109:I125)","v":0},{"$f":"SUM(J109:J125)","v":0},{"$f":"SUM(K109:K125)","v":0},{"$f":"SUM(L109:L125)","v":0}]
[]
[]
[null,"DEBT SERVICE BUDGET"]
[]
[null,null,null,null,null,null,"DOA Chart of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["F-1","D-1","Debt Service"]
["F-1.1","D-1.1","Principal",null,null,null,6401,null,null,null,{"$f":"J134","v":0},0]
["F-1.2","D-1.2","Interest",null,null,null,6410,null,null,null,0,0]
["F-1.3","D-1.3","Fees",null,null,null,6420,null,null,null,0,0]
["F-2","D-2","TOTAL DEBT SERVICE",null,null,null,null,{"$f":"SUM(H134:H136)","v":0},{"$f":"SUM(I134:I136)","v":0},{"$f":"SUM(J134:J136)","v":0},{"$f":"SUM(K134:K136)","v":0},{"$f":"SUM(L134:L136)","v":0}]

{"sheet":"Cash & Investments","index":4,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,1,0,11],[27,5,27,6],[35,2,35,4],[35,5,35,6],[51,2,51,4],[51,5,51,6],[45,2,45,4],[45,5,45,6],[34,3,34,4],[32,3,32,4],[33,3,33,4],[47,2,47,5],[48,3,48,4],[49,3,49,4],[43,2,43,4],[43,5,43,6],[67,2,67,5],[50,3,50,4],[53,2,53,5],[63,2,63,5],[65,2,65,5],[59,2,59,4],[61,2,61,4],[61,5,61,6],[64,2,64,4],[64,5,64,6],[59,5,59,6],[37,2,37,6],[1,1,1,4],[2,1,2,4],[31,2,31,6],[29,2,29,4],[29,5,29,6],[27,2,27,4],[8,2,8,3],[9,2,9,3],[10,2,10,3],[13,2,13,5]]}
[null,{"$f":"VLOOKUP('Instructions (Please Read)'!U2,'Instructions (Please Read)'!R1:S8,2,FALSE)","v":"Proposed Budget"}]
[null,{"$f":"IF('Budget Summary'!B3=\"\",\"Please Enter Name on First Page\",'Budget Summary'!B3)","v":"Please Enter Name on First Page"},null,null,null,null,null,null,null,"FYE",{"$f":"'Instructions (Please Read)'!O2","v":"2024-06-30"}]
[null,"NAME OF DISTRICT/BOARD"]
[]
[]
[null,"GENERAL FUNDS"]
[null,null,null,null,null,null,null,"End of Year","Beginning","Beginning"]
[null,"C-1","Balances at Beginning of Fiscal Year",null,null,null,"DOA Chart of Accounts",{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
[null,"C-1.1","General Fund Checking Account Balance",null,null,null,1010,null,{"$f":"H9","v":0},null,{"$f":"J9","v":0},0]
[null,"C-1.2","Savings and Investments Account Balance",null,null,null,1040,null,{"$f":"H10","v":0},null,0,0]
[null,"C-1.3","General Fund CD Balance",null,null,null,1050,null,{"$f":"H11","v":0},null,0,0]
[null,"C-1.4","All Other Funds",null,null,null,1020,null,{"$f":"H12","v":0},null,0,0]
[null,"C-1.5","Reserves (From Below)",null,null,null,null,{"$f":"'Budget Summary'!H153","v":0},{"$f":"H13","v":0},{"$f":"'Budget Summary'!J153","v":0},{"$f":"'Budget Summary'!K153","v":0},{"$f":"'Budget Summary'!L153","v":0}]
["G-9","C-1.6","Total Estimated Cash and Investments on Hand",null,null,null,null,{"$f":"SUM(H9:H13)","v":0},{"$f":"SUM(I9:I13)","v":0},{"$f":"SUM(J9:J13)","v":0},{"$f":"SUM(K9:K13)","v":0},{"$f":"SUM(L9:L13)","v":0}]
[]
["G-10","C-2","General Fund Reductions:"]
["G-10.1","C-2.1","a.","Unpaid bills at FYE",null,null,2010,null,null,null,{"$f":"J17","v":0},{"$f":"K17","v":0}]
["G-10.2","C-2.2","b.","Reserves",null,null,null,{"$f":"'Budget Summary'!H153","v":0},{"$f":"'Budget Summary'!I153","v":0},{"$f":"'Budget Summary'!J153","v":0},{"$f":"'Budget Summary'!K153","v":0},{"$f":"'Budget Summary'!L153","v":0}]
["G-10.3","C-2.3",null,"Total Deductions (a+b)",null,null,null,{"$f":"SUM(H17:H18)","v":0},{"$f":"SUM(I17:I18)","v":0},{"$f":"SUM(J17:J18)","v":0},{"$f":"SUM(K17:K18)","v":0},{"$f":"SUM(L17:L18)","v":0}]
["G-11","C-2.4","Estimated Non-Restricted Funds Available",null,null,null,null,{"$f":"+H14-H19","v":0},{"$f":"+I14-I19","v":0},{"$f":"+J14-J19","v":0},{"$f":"+K14-K19","v":0},{"$f":"+L14-L19","v":0}]
[]
[]
[null,null,null,null,null,null,"DOA Chart of Accounts"]
["G-6","SINKING & DEBT SERVICE FUNDS ",null,null,null,null,1070]
[]
[null,"C-3",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["G-6.1","C-3.1","Beginning Balance in Reserve Account (end of previous year)",null,null,null,null,null,{"$f":"H38","v":0},{"$f":"I38","v":0},{"$f":"J27","v":0},{"$f":"K27","v":0}]
[null,"C-3.2","Date of Reserve Approval in Minutes:"]
["G-6.2","C-3.3","Amount to be added to the reserve",null,null,null,null,null,null,null,{"$f":"J29","v":0},{"$f":"K29","v":0}]
[null,"C-3.4","Date of Reserve Approval in Minutes:"]
["G-6.3","C-3.5","SUB-TOTAL",null,null,null,null,{"$f":"SUM(H27:H29)","v":0},{"$f":"SUM(I27:I29)","v":0},{"$f":"SUM(J27:J29)","v":0},{"$f":"SUM(K27:K29)","v":0},{"$f":"SUM(L27:L29)","v":0}]
["G-6.4","C-3.6","Identify  the amount and project to be spent"]
[null,"C-3.7","a.",null,null,null,null,null,null,null,{"$f":"J33","v":0},{"$f":"K33","v":0}]
[null,"C-3.8","b.",null,null,null,null,null,null,null,{"$f":"J34","v":0},{"$f":"K34","v":0}]
[null,"C-3.9","c.",{"$f":"IF(SUM('Additional Details'!$N$23:$Q$23)=0,\"\",\"See Additional Details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N23=0,\"\",'Additional Details'!N23)","v":""},{"$f":"IF('Additional Details'!O23=0,\"\",'Additional Details'!O23)","v":""},{"$f":"IF('Additional Details'!P23=0,\"\",'Additional Details'!P23)","v":""},{"$f":"IF('Additional Details'!Q23=0,\"\",'Additional Details'!Q23)","v":""},{"$f":"IF('Additional Details'!R23=0,\"\",'Additional Details'!R23)","v":""}]
[null,"C-3.10","Date of Reserve Approval in Minutes:"]
["G-6.5","C-3.11",{"$f":"IF(SUM('Additional Details'!N23:Q23)>0,\"TOTAL CAPITAL OUTLAY (a+b+c) +additional details\",\"TOTAL CAPITAL OUTLAY (a+b+c)\")","v":"TOTAL CAPITAL OUTLAY (a+b+c)"},null,null,null,null,{"$f":"SUM(H33:H35)","v":0},{"$f":"SUM(I33:I35)","v":0},{"$f":"SUM(J33:J35)","v":0},{"$f":"SUM(K33:K35)","v":0},{"$f":"SUM(L33:L35)","v":0}]
["G-6.6","C-3.12","Balance to be retained",null,null,null,null,{"$f":"+H31-H37","v":0},{"$f":"+I31-I37","v":0},{"$f":"+J31-J37","v":0},{"$f":"+K31-K37","v":0},{"$f":"+L31-L37","v":0}]
[]
["G-7","RESERVES ",null,null,null,null,1090]
[]
[null,"C-4",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["G-7.1","C-4.1","Beginning Balance in Reserve Account (end of previous year)",null,null,null,null,null,{"$f":"H54","v":0},{"$f":"I54","v":0},{"$f":"J43","v":0},{"$f":"K43","v":0}]
[null,"C-4.2","Date of Reserve Approval in Minutes:"]
["G-7.2","C-4.3","Amount to be added to the reserve",null,null,null,null,null,null,null,{"$f":"J45","v":0},{"$f":"K45","v":0}]
[null,"C-4.4","Date of Reserve Approval in Minutes:"]
["G-7.3","C-4.5","SUB-TOTAL",null,null,null,null,{"$f":"SUM(H43:H45)","v":0},{"$f":"SUM(I43:I45)","v":0},{"$f":"SUM(J43:J45)","v":0},{"$f":"SUM(K43:K45)","v":0},{"$f":"SUM(L43:L45)","v":0}]
["G-7.4","C-4.6","Identify  the amount and project to be spent"]
[null,"C-4.7","a.",null,null,null,null,null,null,null,{"$f":"J49","v":0},{"$f":"K49","v":0}]
[null,"C-4.8","b.",null,null,null,null,null,null,null,{"$f":"J50","v":0},{"$f":"K50","v":0}]
[null,"C-4.9","c.",{"$f":"IF(SUM('Additional Details'!$N$24:$Q$24)=0,\"\",\"See Additional Details\")","v":""},null,null,null,{"$f":"IF('Additional Details'!N24=0,\"\",'Additional Details'!N24)","v":""},{"$f":"IF('Additional Details'!O24=0,\"\",'Additional Details'!O24)","v":""},{"$f":"IF('Additional Details'!P24=0,\"\",'Additional Details'!P24)","v":""},{"$f":"IF('Additional Details'!Q24=0,\"\",'Additional Details'!Q24)","v":""},{"$f":"IF('Additional Details'!R24=0,\"\",'Additional Details'!R24)","v":""}]
[null,"C-4.10","Date of Reserve Approval in Minutes:"]
["G-7.5","C-4.11",{"$f":"IF(SUM('Additional Details'!N24:Q24)>0,\"TOTAL OTHER RESERVE OUTLAY (a+b+c)\",\"TOTAL OTHER RESERVE OUTLAY (a+b+c)\")","v":"TOTAL OTHER RESERVE OUTLAY (a+b+c)"},null,null,null,null,{"$f":"SUM(H49:H51)","v":0},{"$f":"SUM(I49:I51)","v":0},{"$f":"SUM(J49:J51)","v":0},{"$f":"SUM(K49:K51)","v":0},{"$f":"SUM(L49:L51)","v":0}]
["G-7.6","C-4.12",{"$f":"\"Balance to be retained\"","v":"Balance to be retained"},null,null,null,null,{"$f":"+H47-H53","v":0},{"$f":"+I47-I53","v":0},{"$f":"+J47-J53","v":0},{"$f":"+K47-K53","v":0},{"$f":"+L47-L53","v":0}]
[]
["G-8","BOND FUNDS ",null,null,null,null,1060]
[]
[null,"C-5",null,null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget"]
["G-8.1","C-5.1","Beginning Balance in Reserve Account (end of previous year)",null,null,null,null,null,{"$f":"H66","v":0},{"$f":"I66","v":0},{"$f":"J59","v":0},{"$f":"K59","v":0}]
[null,"C-5.2","Date of Reserve Approval in Minutes:"]
["G-8.2","C-5.3","Amount to be added to the reserve",null,null,null,null,null,null,null,{"$f":"J61","v":0},{"$f":"K61","v":0}]
[null,"C-5.4","Date of Reserve Approval in Minutes:"]
["G-8.3","C-5.5","SUB-TOTAL",null,null,null,null,{"$f":"SUM(H59:H61)","v":0},{"$f":"SUM(I59:I61)","v":0},{"$f":"SUM(J59:J61)","v":0},{"$f":"SUM(K59:K61)","v":0},{"$f":"SUM(L59:L61)","v":0}]
["G-8.4","C-5.6","Identify  the amount and project to be spent",null,null,null,null,null,null,null,{"$f":"J64","v":0},{"$f":"K64","v":0}]
[null,"C-5.7","Date of Reserve Approval in Minutes:"]
["G-8.5","C-5.8","Balance to be retained",null,null,null,null,{"$f":"+H63-H64","v":0},{"$f":"+I63-I64","v":0},{"$f":"+J63-J64","v":0},{"$f":"+K63-K64","v":0},{"$f":"+L63-L64","v":0}]
["G-8.6"]
[null,"C-5.9","TOTAL TO BE SPENT",null,null,null,null,{"$f":"+H37+H53+H64","v":0},{"$f":"+I37+I53+I64","v":0},{"$f":"+J37+J53+J64","v":0},{"$f":"+K37+K53+K64","v":0},{"$f":"+L37+L53+L64","v":0}]

{"sheet":"Additional Details","index":5,"n_rows":208,"n_cols":24,"rows_kept":208,"cut":false,"hidden":false,"merged":[[5,8,6,8],[3,1,3,4],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7]]}
[]
[null,{"$f":"IF('Instructions (Please Read)'!U2=1,\"Proposed Budget\",\"Final Budget\")","v":"Proposed Budget"},null,null,null,null,null,null,null,null,null,"Totals from \nthis Page Only","DOA Chart of Accounts",{"$f":"E6","v":"2021-2022 Actual"},{"$f":"F6","v":"2022-2023 Estimated"},{"$f":"G6","v":"2023-2024 Proposed"},{"$f":"H6","v":"Pending Approval"},{"$f":"I6","v":"Amended Budget"},"Cell below is to check for amount for printer array \"formatting\" macro"]
[null,{"$f":"IF('Budget Summary'!B3=\"\",\"Please Enter Name on First Page\",'Budget Summary'!B3)","v":"Please Enter Name on First Page"},null,null,null,null,"FYE",{"$f":"'Instructions (Please Read)'!O2","v":"2024-06-30"},null,null,"Line","Section",null,null,null,null,null,null,{"$f":"SUM(N5:Q25)","v":0}]
[null,"NAME OF DISTRICT/BOARD",null,null,null,null,null,null,null,null,null,"Administration Budget"]
[null,null,null,"ADDITIONAL DETAILS",null,null,null,null,null,null,"E-2.7","Personnel Services",7005,{"$f":"SUMIF($B$10:$B$140,$S5,E$10:E$140)","v":0},0,0,0,0,{"$f":"CONCATENATE(K5,\" \",L5)","v":"E-2.7 Personnel Services"},null,null,null,"Original Copy Paste"]
[null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget",null,"E-3.6","Board Expenses",7013,0,0,0,0,0,{"$f":"CONCATENATE(K6,\" \",L6)","v":"E-3.6 Board Expenses"}]
[null,null,null,null,{"$f":"'Instructions (Please Read)'!$P$2-3&\"-\"&'Instructions (Please Read)'!$P$2-2&\" Actual\"","v":"2021-2022 Actual"},{"$f":"'Instructions (Please Read)'!$P$2-2&\"-\"&'Instructions (Please Read)'!$P$2-1&\" Estimated\"","v":"2022-2023 Estimated"},{"$f":"'Instructions (Please Read)'!$P$2-1&\"-\"&'Instructions (Please Read)'!$P$2&\" Proposed\"","v":"2023-2024 Proposed"},{"$f":"IF('Instructions (Please Read)'!$B$1=\"Proposed Budget\",\"Pending Approval\",\"Final Approval\")","v":"Pending Approval"},"Amended Budget",null,"E-4.6","Contractual Services",7023,0,0,0,0,0,{"$f":"CONCATENATE(K7,\" \",L7)","v":"E-4.6 Contractual Services"},null,"Previous Line","All","Section","Subsections"]
[null,"Add to Section",null,"Description","DATA INPUT",null,null,null,null,null,"E-5.8","Other",7035,0,0,0,0,0,{"$f":"CONCATENATE(K8,\" \",L8)","v":"E-5.8 Other"}]
[null,null,null,null,null,null,null,null,null,null,null,"Operations Budget",null,null,null,null,null,null,{"$f":"CONCATENATE(K10,\" \",L10)","v":"E-7.6 Personnel Services"}]
[null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),\"\")","v":""},null,null,null,null,{"$f":"IF(G10=\"\",\"\",G10)","v":""},{"$f":"IF(H10=\"\",\"\",H10)","v":""},null,"E-7.6","Personnel Services",7204,{"$f":"SUMIF($B$10:$B$140,$S9,E$10:E$140)","v":0},0,0,0,0,"E-8.5 Travel",null,null,null,"SCHEDULE B"]
[null,null,"",null,null,null,null,{"$f":"IF(G11=\"\",\"\",G11)","v":""},"",null,"E-8.5","Travel",7212,0,0,0,0,0,"E-9.5 Operating supplies"]
[null,null,"",null,null,null,null,{"$f":"IF(G12=\"\",\"\",G12)","v":""},"",null,"E-9.5","Operating supplies",7220,0,0,0,0,0,"E-10.5 Program Services"]
[null,null,"",null,null,null,null,{"$f":"IF(G13=\"\",\"\",G13)","v":""},"",null,"E-10.5","Program Services",7230,0,0,0,0,0,"E-11.5 Contractual Arrangements",null,null,null,"ACTIVITY"]
[null,null,"",null,null,null,null,{"$f":"IF(G14=\"\",\"\",G14)","v":""},"",null,"E-11.5","Contractual Arrangements",7400,0,0,0,0,0,"E-12.5 Other operations",null,null,"B-1","Personnel Services:"]
[null,null,"",null,null,null,null,{"$f":"IF(G15=\"\",\"\",G15)","v":""},"",null,"E-12.5","Other operations",7450,0,0,0,0,0,{"$f":"CONCATENATE(K17,\" \",L17)","v":"E-14.7 Insurance"},null,null,"B-1.1",null,"Administrator"]
[null,null,"",null,null,null,null,{"$f":"IF(G16=\"\",\"\",G16)","v":""},"",null,null,"Indirect Costs Budget",null,null,null,null,null,null,{"$f":"CONCATENATE(K18,\" \",L18)","v":"E-15.9 Indirect payroll costs"},null,null,"B-1.2",null,"Secretary"]
[null,null,"",null,null,null,null,{"$f":"IF(G17=\"\",\"\",G17)","v":""},"",null,"E-14.7","Insurance",7505,{"$f":"SUMIF($B$10:$B$140,$S15,E$10:E$140)","v":0},0,0,0,0,{"$f":"CONCATENATE(K20,\" \",L20)","v":"E-1.7 Capital Outlay"},null,null,"B-1.3",null,"Clerical"]
[null,null,"",null,null,null,null,{"$f":"IF(G18=\"\",\"\",G18)","v":""},"",null,"E-15.9","Indirect payroll costs",7516,0,0,0,0,0,{"$f":"CONCATENATE(K22,\" \",L22)","v":"R-5.3 Miscellaneous"},null,null,"B-1.4",null,"Other (Specify)"]
[null,null,"",null,null,null,null,{"$f":"IF(G19=\"\",\"\",G19)","v":""},"",null,null,"Capital Outlay Budget",null,null,null,null,null,null,{"$f":"CONCATENATE(K23,\" \",L23)","v":"C-3.9 Sinking & Debt Service Funds "},null,null,"B-1.5"]
[null,null,"",null,null,null,null,{"$f":"IF(G20=\"\",\"\",G20)","v":""},"",null,"E-1.7","Capital Outlay",6200,{"$f":"SUMIF($B$10:$B$140,$S17,E$10:E$140)","v":0},{"$f":"SUMIF($B$10:$B$140,$S17,F$10:F$140)","v":0},{"$f":"SUMIF($B$10:$B$140,$S17,G$10:G$140)","v":0},{"$f":"SUMIF($B$10:$B$140,$S17,H$10:H$140)","v":0},{"$f":"SUMIF($B$10:$B$140,$S17,I$10:I$140)","v":0},{"$f":"CONCATENATE(K24,\" \",L24)","v":"C-4.9 Reserves "},null,"B-1.6","B-1.6"]
[null,null,"",null,null,null,null,{"$f":"IF(G21=\"\",\"\",G21)","v":""},"",null,null,"Cash & Forecasted Revenue",null,null,null,null,null,null,{"$f":"CONCATENATE(K25,\" \",L25)","v":"R-6.5 Bond Funds "}]
[null,null,"",null,null,null,null,{"$f":"IF(G22=\"\",\"\",G22)","v":""},"",null,"R-5.3","Miscellaneous",4500,{"$f":"SUMIF($B$10:$B$140,$S18,E$10:E$140)","v":0},0,0,0,0,null,null,null,"B-2","Board Expenses:"]
[null,null,"",null,null,null,null,{"$f":"IF(G23=\"\",\"\",G23)","v":""},"",null,"C-3.9",{"$f":"PROPER('Cash & Investments'!B24)","v":"Sinking & Debt Service Funds "},1070,0,0,0,0,0,{"$f":"SUM(E63:H140)","v":0},null,null,"B-2.1",null,"Travel"]
[null,null,"",null,null,null,null,{"$f":"IF(G24=\"\",\"\",G24)","v":""},"",null,"C-4.9",{"$f":"PROPER('Cash & Investments'!B40)","v":"Reserves "},1090,0,0,0,0,0,"Sum above is to check for second page",null,null,"B-2.2",null,"Mileage"]
[null,null,"",null,null,null,null,{"$f":"IF(G25=\"\",\"\",G25)","v":""},"",null,"R-6.5",{"$f":"PROPER('Cash & Investments'!B56)","v":"Bond Funds "},1060,0,0,0,0,0,null,null,null,"B-2.3",null,"Other (Specify)"]
[null,null,"",null,null,null,null,{"$f":"IF(G26=\"\",\"\",G26)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-2.4"]
[null,null,"",null,null,null,null,{"$f":"IF(G27=\"\",\"\",G27)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"B-2.5","B-2.5"]
[null,null,"",null,null,null,null,{"$f":"IF(G28=\"\",\"\",G28)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G29=\"\",\"\",G29)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-3","Contractual Services:"]
[null,null,"",null,null,null,null,{"$f":"IF(G30=\"\",\"\",G30)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-3.1",null,"Legal"]
[null,null,"",null,null,null,null,{"$f":"IF(G31=\"\",\"\",G31)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-3.2",null,"Accounting/Auditing"]
[null,null,"",null,null,null,null,{"$f":"IF(G32=\"\",\"\",G32)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-3.3",null,"Other (Specify) "]
[null,null,"",null,null,null,null,{"$f":"IF(G33=\"\",\"\",G33)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-3.4"]
[null,null,"",null,null,null,null,{"$f":"IF(G34=\"\",\"\",G34)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"B-3.5","B-3.5"]
[null,null,"",null,null,null,null,{"$f":"IF(G35=\"\",\"\",G35)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G36=\"\",\"\",G36)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-4","Other:"]
[null,null,"",null,null,null,null,{"$f":"IF(G37=\"\",\"\",G37)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-4.1",null,"Office Supplies"]
[null,null,"",null,null,null,null,{"$f":"IF(G38=\"\",\"\",G38)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-4.2",null,"Office equipment, rent & repair"]
[null,null,"",null,null,null,null,{"$f":"IF(G39=\"\",\"\",G39)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-4.3",null,"Education"]
[null,null,"",null,null,null,null,{"$f":"IF(G40=\"\",\"\",G40)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-4.4",null,"Registrations"]
[null,null,"",null,null,null,null,{"$f":"IF(G41=\"\",\"\",G41)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-4.5",null,"Other (Specify) "]
[null,null,"",null,null,null,null,{"$f":"IF(G42=\"\",\"\",G42)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-4.6"]
[null,null,"",null,null,null,null,{"$f":"IF(G43=\"\",\"\",G43)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"B-4.7","B-4.7"]
[null,null,"",null,null,null,null,{"$f":"IF(G44=\"\",\"\",G44)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B-5","TOTAL ADMINISTRATION "]
[null,null,"",null,null,null,null,{"$f":"IF(G45=\"\",\"\",G45)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G46=\"\",\"\",G46)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE C"]
[null,null,"",null,null,null,null,{"$f":"IF(G47=\"\",\"\",G47)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G48=\"\",\"\",G48)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G49=\"\",\"\",G49)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"ACTIVITY"]
[null,null,"",null,null,null,null,{"$f":"IF(G50=\"\",\"\",G50)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-1","Personnel Services:"]
[null,null,"",null,null,null,null,{"$f":"IF(G51=\"\",\"\",G51)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-1.1",null,"Wages--Operations"]
[null,null,"",null,null,null,null,{"$f":"IF(G52=\"\",\"\",G52)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-1.2",null,"Service Contracts"]
[null,null,"",null,null,null,null,{"$f":"IF(G53=\"\",\"\",G53)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-1.3",null,"Other (Specify) "]
[null,null,"",null,null,null,null,{"$f":"IF(G54=\"\",\"\",G54)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-1.4"]
[null,null,"",null,null,null,null,{"$f":"IF(G55=\"\",\"\",G55)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"C-1.5","C-1.5"]
[null,null,"",null,null,null,null,{"$f":"IF(G56=\"\",\"\",G56)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G57=\"\",\"\",G57)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-2","Travel:"]
[null,null,"",null,null,null,null,{"$f":"IF(G58=\"\",\"\",G58)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-2.1",null,"Mileage"]
[null,null,"",null,null,null,null,{"$f":"IF(G59=\"\",\"\",G59)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-2.2",null,"Other (Specify) "]
[null,null,"",null,null,null,null,{"$f":"IF(G60=\"\",\"\",G60)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-2.3"]
[null,null,"",null,null,null,null,{"$f":"IF(G61=\"\",\"\",G61)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"C-2.4","C-2.4"]
[null,null,"",null,null,null,null,{"$f":"IF(G62=\"\",\"\",G62)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G63=\"\",\"\",G63)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-3","Operating supplies (List): "]
[null,null,"",null,null,null,null,{"$f":"IF(G64=\"\",\"\",G64)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-3.1"]
[null,null,"",null,null,null,null,{"$f":"IF(G65=\"\",\"\",G65)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-3.2"]
[null,null,"",null,null,null,null,{"$f":"IF(G66=\"\",\"\",G66)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-3.3"]
[null,null,"",null,null,null,null,{"$f":"IF(G67=\"\",\"\",G67)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"C-3.4","C-3.4"]
[null,null,"",null,null,null,null,{"$f":"IF(G68=\"\",\"\",G68)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G69=\"\",\"\",G69)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-4","Program Services (List):"]
[null,null,"",null,null,null,null,{"$f":"IF(G70=\"\",\"\",G70)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-4.1"]
[null,null,"",null,null,null,null,{"$f":"IF(G71=\"\",\"\",G71)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-4.2"]
[null,null,"",null,null,null,null,{"$f":"IF(G72=\"\",\"\",G72)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-4.3"]
[null,null,"",null,null,null,null,{"$f":"IF(G73=\"\",\"\",G73)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"C-4.4","C-4.4"]
[null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),\"\")","v":""},null,null,null,null,{"$f":"IF(G74=\"\",\"\",G74)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G75=\"\",\"\",G75)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-5","Contractual Arrangements (List):  "]
[null,null,"",null,null,null,null,{"$f":"IF(G76=\"\",\"\",G76)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-5.1"]
[null,null,"",null,null,null,null,{"$f":"IF(G77=\"\",\"\",G77)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-5.2"]
[null,null,"",null,null,null,null,{"$f":"IF(G78=\"\",\"\",G78)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-5.3"]
[null,null,"",null,null,null,null,{"$f":"IF(G79=\"\",\"\",G79)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"C-5.4","C-5.4"]
[null,null,"",null,null,null,null,{"$f":"IF(G80=\"\",\"\",G80)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G81=\"\",\"\",G81)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-6","Other operations (Specify):  "]
[null,null,"",null,null,null,null,{"$f":"IF(G82=\"\",\"\",G82)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-6.1"]
[null,null,"",null,null,null,null,{"$f":"IF(G83=\"\",\"\",G83)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-6.2"]
[null,null,"",null,null,null,null,{"$f":"IF(G84=\"\",\"\",G84)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-6.3"]
[null,null,"",null,null,null,null,{"$f":"IF(G85=\"\",\"\",G85)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"C-6.4","C-6.4"]
[null,null,"",null,null,null,null,{"$f":"IF(G86=\"\",\"\",G86)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"C-7","TOTAL OPERATIONS"]
[null,null,"",null,null,null,null,{"$f":"IF(G87=\"\",\"\",G87)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G88=\"\",\"\",G88)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G89=\"\",\"\",G89)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE D"]
[null,null,"",null,null,null,null,{"$f":"IF(G90=\"\",\"\",G90)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G91=\"\",\"\",G91)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G92=\"\",\"\",G92)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"ACTIVITY"]
[null,null,"",null,null,null,null,{"$f":"IF(G93=\"\",\"\",G93)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-1","Insurance"]
[null,null,"",null,null,null,null,{"$f":"IF(G94=\"\",\"\",G94)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-1.1",null,"Liability"]
[null,null,"",null,null,null,null,{"$f":"IF(G95=\"\",\"\",G95)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-1.2",null,"Buildings and vehicles"]
[null,null,"",null,null,null,null,{"$f":"IF(G96=\"\",\"\",G96)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-1.3",null,"Equipment"]
[null,null,"",null,null,null,null,{"$f":"IF(G97=\"\",\"\",G97)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-1.4",null,"Other (Specify) "]
[null,null,"",null,null,null,null,{"$f":"IF(G98=\"\",\"\",G98)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-1.5"]
[null,null,"",null,null,null,null,{"$f":"IF(G99=\"\",\"\",G99)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"D-1.6","D-1.6"]
[null,null,"",null,null,null,null,{"$f":"IF(G100=\"\",\"\",G100)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-2","Indirect payroll costs:"]
[null,null,"",null,null,null,null,{"$f":"IF(G101=\"\",\"\",G101)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-2.1",null,"FICA (Social Security) taxes"]
[null,null,"",null,null,null,null,{"$f":"IF(G102=\"\",\"\",G102)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-2.2",null,"Workers Compensation"]
[null,null,"",null,null,null,null,{"$f":"IF(G103=\"\",\"\",G103)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-2.3",null,"Unemployment Taxes"]
[null,null,"",null,null,null,null,{"$f":"IF(G104=\"\",\"\",G104)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-2.4",null,"Retirement"]
[null,null,"",null,null,null,null,{"$f":"IF(G105=\"\",\"\",G105)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-2.5",null,"Health Insurance"]
[null,null,"",null,null,null,null,{"$f":"IF(G106=\"\",\"\",G106)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"D-2.6","D-2.6",null,"Other (Specify) "]
[null,null,"",null,null,null,null,{"$f":"IF(G107=\"\",\"\",G107)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G108=\"\",\"\",G108)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G109=\"\",\"\",G109)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-3","Depreciation Expenses"]
[null,null,"",null,null,null,null,{"$f":"IF(G110=\"\",\"\",G110)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"D-4","TOTAL INDIRECT COSTS"]
[null,null,"",null,null,null,null,{"$f":"IF(G111=\"\",\"\",G111)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G112=\"\",\"\",G112)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G113=\"\",\"\",G113)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G114=\"\",\"\",G114)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE E"]
[null,null,"",null,null,null,null,{"$f":"IF(G115=\"\",\"\",G115)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G116=\"\",\"\",G116)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G117=\"\",\"\",G117)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"ACTIVITY"]
[null,null,"",null,null,null,null,{"$f":"IF(G118=\"\",\"\",G118)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"E-1","Capital Outlay"]
[null,null,"",null,null,null,null,{"$f":"IF(G119=\"\",\"\",G119)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"E-1.1",null,"Real Property"]
[null,null,"",null,null,null,null,{"$f":"IF(G120=\"\",\"\",G120)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"E-1.2",null,"Vehicles"]
[null,null,"",null,null,null,null,{"$f":"IF(G121=\"\",\"\",G121)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"E-1.3",null,"Office Equipment"]
[null,null,"",null,null,null,null,{"$f":"IF(G122=\"\",\"\",G122)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"E-1.4",null,"Other (Specify) "]
[null,null,"",null,null,null,null,{"$f":"IF(G123=\"\",\"\",G123)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"E-1.5"]
[null,null,"",null,null,null,null,{"$f":"IF(G124=\"\",\"\",G124)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"E-1.6","E-1.6"]
[null,null,"",null,null,null,null,{"$f":"IF(G125=\"\",\"\",G125)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G126=\"\",\"\",G126)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"E-2","TOTAL CAPITAL OUTLAY"]
[null,null,"",null,null,null,null,{"$f":"IF(G127=\"\",\"\",G127)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G128=\"\",\"\",G128)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G129=\"\",\"\",G129)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE G"]
[null,null,"",null,null,null,null,{"$f":"IF(G130=\"\",\"\",G130)","v":""},""]
[null,null,"",null,null,null,null,{"$f":"IF(G131=\"\",\"\",G131)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,"FORECASTED REVENUE"]
[null,null,"",null,null,null,null,{"$f":"IF(G132=\"\",\"\",G132)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-1","Government Support"]
[null,null,"",null,null,null,null,{"$f":"IF(G133=\"\",\"\",G133)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-1.1",null,"State Aid"]
[null,null,"",null,null,null,null,{"$f":"IF(G134=\"\",\"\",G134)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-1.2",null,"County Aid"]
[null,null,"",null,null,null,null,{"$f":"IF(G135=\"\",\"\",G135)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-1.3",null,"City (or Town) Aid"]
[null,null,"",null,null,null,null,{"$f":"IF(G136=\"\",\"\",G136)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-1.4",null,"Other (Specify)"]
[null,null,"",null,null,null,null,{"$f":"IF(G137=\"\",\"\",G137)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-1.5",null,"Total Government Support"]
[null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),\"\")","v":""},null,null,null,null,{"$f":"IF(G138=\"\",\"\",G138)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-2","Operating Revenues"]
[null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),\"\")","v":""},null,null,null,null,{"$f":"IF(G139=\"\",\"\",G139)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-2.1",null,"Customer Charges"]
[null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),\"\")","v":""},null,null,null,null,{"$f":"IF(G140=\"\",\"\",G140)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"G-2.2",null,"Sales of Goods or Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-2.3",null,"Other Assessments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-2.4",null,"Total Operating Revenues"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-3","Grants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-3.1",null,"Direct Federal Grants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-3.2",null,"Federal Grants thru State Agencies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-3.3",null,"Grants from State Agencies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-3.4",null,"Total Grants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-4","Miscellaneous:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-4.1",null,"Interest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-4.2","G-4.2",null,"Other: Specify"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-4.3",null,"Total Miscellaneous"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-5","Total Forecasted Revenue"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-6","DEPRECIATION (REPLACEMENT) RESERVE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-5.1","Balance in Reserve Account, beginning of budget year"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-5.2","Amount to be added to the reserve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-5.3","SUB-TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-5.4","G-5.4","Identify  the amount to be spent from \"Reserve for Capital Outlay\" "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-5.5",null,"TOTAL CAPITAL OUTLAY (a+b+c)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-5.6","Balance to be retained in Depreciation Reserve Account (Line 3 - Line 5)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7","OTHER RESERVE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.1","Balance in Reserve Account, beginning of budget year"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.2","Amount to be added to the reserve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.3","SUB-TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.4","G-7.4","Identify  the amount and project to be spent from \"Other Reserves\" "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.5",null,"TOTAL OTHER RESERVE  OUTLAY (a+b+c)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.6","Balance to be retained in Other Reserve Account (Line 9 - Line 11)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-8","EMERGENCY RESERVE (cash)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-8.1","Balance in Reserve Account, beginning of budget year"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-8.2","Amount to be added to the reserve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-8.3","SUB-TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-8.4","Amount to be spent from Emergency Reserve (Cash)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-8.5","Balance to be retained in Cash Reserve Account (Line 15 - Line 16)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-9","TOTAL TO BE SPENT"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-6","Total Estimated Cash and Investments on Hand (less any reserves listed above)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7","Deductions:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.1","a.","Unpaid bills at FYE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.2","b.","Reserves"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-7.3",null,"Total Deductions (a+b)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-8","Estimated cash available"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-9","Other Forecasted revenues:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-9.1","a.","Other past due-as estimated by Co. Treas."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-9.2","b.","Other forecasted revenue (specify): "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-9.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-9.4","G-9.4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-9.5",null,"Total Other Forecasted Revenue (a+b)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G-10","Total Cash Available and Forecasted Revenue"]

{"sheet":"Notes","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tasks","index":7,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Budget Form Development Tasks:"]
[]
[null,null,null,null,null,null,null,null,"ü","Fix Broken formulas"]
[null,null,null,null,null,null,null,null,"ü","Fix broken macro"]
[null,null,null,null,null,null,null,null,"ü","Redo Contents Box (to the left)"]
[]
[null,null,null,null,null,null,null,null,"ü","Add Cash sections"]
[]
[null,null,null,null,null,null,null,null,null,"Amended option?"]
[null,null,null,null,null,null,null,null,"ü","mark as different"]
[null,null,null,null,null,null,null,null,"ü","equal approved column"]
[]
[null,null,null,null,null,null,null,null,"ü","Change line numbers"]
[null,null,null,null,null,null,null,null,"ü","Update line numbers to additional Details page"]
[]
[]
[null,null,null,null,null,null,null,null,"ü","lock/unlock cells"]
[]
[null,null,null,null,null,null,null,null,null,"hyperlinks on go to menu"]

{"sheet":"Formula Map","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet1","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}