{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Override","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Override","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,0,10,3],[13,0,13,3],[32,0,33,3],[1,0,1,1]]}
[]
["Estimate Override Calculation for Districts FY",null,{"$f":"VLOOKUP(Sheet1!B2,Sheet1!C2:D13,2,FALSE)","v":2023}]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Total Weigthed ADM  - Most Recent BSA-55 FY \"&C2-1","v":"Total Weigthed ADM  - Most Recent BSA-55 FY 2022"}]
[{"$f":"\"FY \"&(C2)-1&\" Total Weighted ADM\"","v":"FY 2022 Total Weighted ADM"},0,null,{"$f":"B12","v":0}]
[]
[{"$f":"\"K-3 Reading Weighted ADM - Most Recent BSA-55 FY \"&(C2)-1&\" \nDo not enter counts if already included in \"&A12","v":"K-3 Reading Weighted ADM - Most Recent BSA-55 FY 2022 \nDo not enter counts if already included in FY 2022 Total Weighted ADM"}]
[{"$f":"\"FY \"&(C2-1)&\" Non-AOI\"","v":"FY 2022 Non-AOI"},0,"X 1.0",{"$f":"B15*1","v":0}]
[{"$f":"\"FY \"&(C2)-1&\" AOI-FT\"","v":"FY 2022 AOI-FT"},0,"X .95",{"$f":"B16*0.95","v":0}]
[{"$f":"\"FY \"&(C2)-1&\" AOI-PT\"","v":"FY 2022 AOI-PT"},0,"X .85",{"$f":"B17*0.85","v":0}]
[]
["Description & Source","Function","Fiscal Year","Value"]
[{"$f":"A12","v":"FY 2022 Total Weighted ADM"},null,{"$f":"C2-1","v":2022},{"$f":"SUM(D12,D15,D16,D17)","v":0}]
["Base Level Amount (BLA) - BSA-55, Page 2 of 5","X",{"$f":"$C$2","v":2023},0]
["Teacher Experience Index (TEI) - BSA-55, Page 2 of 5","X",2023,0]
["Base Support Level (BSL) - Formula: (WSC*BSA*TEI)","=",2023,{"$f":"D20*D21*D22","v":0}]
["Audit Service Expense (ASE) - BSA-55, Page 2 of 5","+",2023,0]
["Other Adjustments - BSA-55, Page 2 of 5","+",2023,0]
["Transport. Revenue Control Limit (TRCL) - BSA-55, Page 3 of 5","+",2023,0]
["Override Revenue Control Limit (RCL) - Formula: (BSL+TRCL+ASE)","=",2023,{"$f":"SUM(D23:D26)","v":0}]
["Override % - Election Results %","X",2023,0]
[null,null,null,{"$f":"IF(D31=3,D28*(2/3),IF(D31=4,D28*(1/3),\"\"))","v":""}]
["Override Amount $ - Formula (RCL*Override%)","=",{"$f":"$C$2","v":2023},{"$f":"IF(D29=\"\",DOLLAR(D27*D28),DOLLAR(D27*D29))","v":"$0.00"}]
[null,null,null,1]
[]
[{"$f":"A2&\" \"&C2&\" \"&D30","v":"Estimate Override Calculation for Districts FY 2023 $0.00"}]

{"sheet":"Sheet1","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Choose Phase Down Status",null,null,{"$f":"TODAY()","v":"2022-06-01"}]
["Not in Phase Down",{"$f":"MONTH(TODAY())","v":6},1,{"$f":"YEAR($D$1)","v":2022}]
["Phase Down 1 - Reduced by 1/3",null,2,{"$f":"YEAR($D$1)","v":2022}]
["Phase Down 2  - Reduced by 2/3",null,3,2022]
[null,null,4,{"$f":"YEAR($D$1)+1","v":2023}]
[null,null,5,{"$f":"YEAR($D$1)+1","v":2023}]
[null,null,6,2023]
[null,null,7,2023]
[null,null,8,2023]
[null,null,9,2023]
[null,null,10,2023]
[null,null,11,2023]
[null,null,12,2023]