{"text_format":"1","workbook":"xlsx","n_sheets":71,"sheets":["Info","KEY METRICS","Mandatory Entry Checklist","Instructions","KEY INPUTS","Budget Front Cover","Cover Sheet","Certification Section","Division Cert. (C-1)","Preparer Cert. (C-2)","Internet Cert. (C-3)","Approval Cert. (C-4)","Approval Resolution (C-5)","Adoption Cert. (C-6)","Adopted Resolution (C-7)","Narrative and Information","Message & Analysis (N-1)","Message & Analysis (N-1)(2)","Message & Analysis (N-1)(3)","Contact Information (N-2)","Questionnaire (N-3)","Questionnaire (N-3)(2)","Questionnaire (N-3)(3)","Questionnaire (N-3)(4)","Commissioner Schedule (N-4)","Page N-4 (2 of 2)","Health Benefits (N-5)","Accumulated Absences (N-6)","Accumulated Absences (N-6) (2)","Accumulated Absences (N-6) (3)","Accumulated Absences (N-6) (4)","Accumulated Absences (N-6) (5)","Accumulated Absences (N-6) (6)","Accumulated Absences (N-6) (7)","Accumulated Absences (N-6) (8)","TOTAL Accumulated Absences","Shared Services (N-7)","Shared Services (N-7) (2)","Financial Schedule","F-1 Summary","F-2 Revenues (Proposed)","F-3 Revenues (PY Adopted)","F-4 Appropriations (Proposed)","F-4 Appropriation Detail","F-4 Appropriation Detail (2)","F-4 Appropriation Detail (3)","F-5 Appropriations (PY Adopted)","F-5 Appropriation Detail","F-5 Appropriation Detail (2)","F-5 Appropriation Detail (3)","F-6 Debt Service-Principal","F-6 Detail","F-7 Debt Service-Interest","F-7 Detail","F-8 Net Position","Capital Budget","CB-1 Capital Budget Cert.","CB-2 Capital Budget Message","CB-3 Capital Budget Proposed","CB-3 Detail","CB-3 Detail (2)","CB-3 Detail Totals","CB-4 5 Year Capital Budget Cost","CB-4 Detail","CB-4 Detail (2)","CB-4 Detail Totals","CB-5 5 Year Capital Budget Fund","CB-5 Detail","CB-5 Detail (2)","CB-5 Detail Totals","Appendix-Change Orders"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":10,"defined_names":89,"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":"Info","index":0,"n_rows":184,"n_cols":5,"rows_kept":184,"cut":false,"hidden":true,"merged":[]}
["(Select Authority)",null,"Authority Name (Alphabetical)"]
["Atlantic City Municipal Utilities Authority",null,"Atlantic City Municipal Utilities Authority",null,{"$f":"IF(A2=C2,\"TRUE\",\"FALSE\")","v":"TRUE"}]
["Atlantic County Improvement Authority",null,"Atlantic County Improvement Authority",null,{"$f":"IF(A3=C3,\"TRUE\",\"FALSE\")","v":"TRUE"}]
["Atlantic County Utilities Authority",null,"Atlantic County Utilities Authority",null,"TRUE"]
["Bayonne Municipal Utilities Authority",null,"Bayonne Municipal Utilities Authority",null,"TRUE"]
["Bayshore Regional Sewerage Authority",null,"Bayshore Regional Sewerage Authority",null,"TRUE"]
["Beach Haven Sewerage Authority",null,"Beach Haven Sewerage Authority",null,"TRUE"]
["Beachwood Sewerage Authority",null,"Beachwood Sewerage Authority",null,"TRUE"]
["Bellmawr Redevelopment Agency",null,"Bellmawr Redevelopment Agency",null,"TRUE"]
["Bergen County Improvement Authority",null,"Bergen County Improvement Authority",null,{"$f":"IF(A10=C10,\"TRUE\",\"FALSE\")","v":"TRUE"}]
["Bergen County Utilities Authority",null,"Bergen County Utilities Authority",null,"TRUE"]
["Berkeley Municipal Utilities Authority",null,"Berkeley Municipal Utilities Authority",null,"TRUE"]
["Berkeley Township Sewerage Authority",null,"Berkeley Township Sewerage Authority",null,"TRUE"]
["Bernards Sewerage Authority",null,"Bernards Sewerage Authority",null,"TRUE"]
["Beverly Sewerage Authority",null,"Beverly Sewerage Authority",null,"TRUE"]
["Bordentown Sewerage Authority",null,"Bordentown Sewerage Authority",null,"TRUE"]
["Brick Municipal Utilities Authority",null,"Brick Municipal Utilities Authority",null,"TRUE"]
["Bridgeton Municipal Port Authority",null,"Bridgeton Municipal Port Authority",null,"TRUE"]
["Buena Municipal Utilities Authority",null,"Buena Municipal Utilities Authority",null,"TRUE"]
["Burlington County Bridge Commission",null,"Burlington County Bridge Commission",null,"TRUE"]
["Camden County Improvement Authority",null,"Camden County Improvement Authority",null,"TRUE"]
["Camden County Pollution Control Financing Authority",null,"Camden County Pollution Control Financing Authority",null,"TRUE"]
["Camden County Utilities Authority",null,"Camden County Utilities Authority",null,"TRUE"]
["Camden Municipal Port Authority",null,"Camden Municipal Port Authority",null,"TRUE"]
["Camden Parking Authority",null,"Camden Parking Authority",null,"TRUE"]
["Camden Redevelopment Agency",null,"Camden Redevelopment Agency",null,"TRUE"]
["Cape May County Bridge Commission",null,"Cape May County Bridge Commission",null,"TRUE"]
["Cape May County Pollution Control Financing Authority",null,"Cape May County Pollution Control Financing Authority",null,"TRUE"]
["Cape May County Utilities Authority",null,"Cape May County Utilities Authority",null,"TRUE"]
["Carlstadt Sewerage Authority",null,"Carlstadt Sewerage Authority",null,"TRUE"]
["Carney's Point Sewerage Authority",null,"Carney's Point Sewerage Authority",null,"TRUE"]
["Carteret Port Authority",null,"Carteret Port Authority",null,"TRUE"]
["Carteret Redevelopment Agency",null,"Carteret Redevelopment Agency",null,"TRUE"]
["Cinnaminson Sewerage Authority",null,"Cinnaminson Sewerage Authority",null,"TRUE"]
["Clinton Sewerage Authority",null,"Clinton Sewerage Authority",null,"TRUE"]
["Cumberland County Improvement Authority",null,"Cumberland County Improvement Authority",null,"TRUE"]
["Cumberland County Utilities Authority",null,"Cumberland County Utilities Authority",null,"TRUE"]
["Delanco Sewerage Authority",null,"Delanco Sewerage Authority",null,"TRUE"]
["Delaware Municipal Utilities Authority",null,"Delaware Municipal Utilities Authority",null,"TRUE"]
["Deptford Municipal Utilities Authority",null,"Deptford Municipal Utilities Authority",null,"TRUE"]
["Dunellen Parking Authority",null,"Dunellen Parking Authority",null,{"$f":"IF(A41=C41,\"TRUE\",\"FALSE\")","v":"TRUE"}]
["East Brunswick Redevelopment Agency",null,"East Brunswick Redevelopment Agency",null,{"$f":"IF(A42=C42,\"TRUE\",\"FALSE\")","v":"TRUE"}]
["East Orange Parking Authority",null,"East Orange Parking Authority",null,"TRUE"]
["East Windsor Municipal Utilities Authority",null,"East Windsor Municipal Utilities Authority",null,"TRUE"]
["Eatontown Sewerage Authority",null,"Eatontown Sewerage Authority",null,"TRUE"]
["Edgewater Park Sewerage Authority",null,"Edgewater Park Sewerage Authority",null,"TRUE"]
["Egg Harbor Township Municipal Utilities Authority",null,"Egg Harbor Municipal Utilities Authority",null,"FALSE"]
["Elizabeth Parking Authority",null,"Elizabeth Parking Authority",null,"TRUE"]
["Essex County Improvement Authority",null,"Essex County Improvement Authority",null,"TRUE"]
["Essex County Utilities Authority",null,"Essex County Utilities Authority",null,"TRUE"]
["Evesham Municipal Utilities Authority",null,"Evesham Municipal Utilities Authority",null,"TRUE"]
["Ewing Township Redevelopment Agency",null,"Ewing Township Redevelopment Agency",null,"TRUE"]
["Ewing-Lawrence Sewerage Authority",null,"Ewing-Lawrence Sewerage Authority",null,"TRUE"]
["Fort Lee Parking Authority",null,"Fort Lee Parking Authority",null,"TRUE"]
["Franklin (Somerset) Sewerage Authority",null,"Franklin (Somerset) Sewerage Authority",null,"TRUE"]
["Franklin Redevelopment Agency",null,"Franklin Redevelopment Agency",null,"TRUE"]
["Garfield Redevelopment Agency",null,"Garfield Redevelopment Agency",null,"TRUE"]
["Gloucester County Improvement Authority",null,"Gloucester County Improvement Authority",null,"TRUE"]
["Gloucester County Pollution Control Financing Authority",null,"Gloucester County Pollution Control Financing Authority",null,"TRUE"]
["Gloucester County Utilities Authority",null,"Gloucester County Utilities Authority",null,"TRUE"]
["Gloucester Township Municipal Utilities Authority",null,"Gloucester Township Municipal Utilities Authority",null,"TRUE"]
["Hackettstown Municipal Utilities Authority",null,"Hackettstown Municipal Utilities Authority",null,"TRUE"]
["Hackettstown Parking Authority",null,"Hackettstown Parking Authority",null,"TRUE"]
["Hamilton Municipal Utilities Authority (Atlantic)",null,"Hamilton Municipal Utilities Authority (Atlantic)",null,"TRUE"]
["Hanover Sewerage Authority",null,"Hanover Sewerage Authority",null,"TRUE"]
["Hardyston Municipal Utilities Authority",null,"Hardyston Municipal Utilities Authority",null,"TRUE"]
["Harrison Redevelopment Agency",null,"Harrison Redevelopment Agency",null,"TRUE"]
["Hillsborough Municipal Utilities Authority",null,"Hillsborough Municipal Utilities Authority",null,"TRUE"]
["Hoboken Hospital Authority",null,"Hoboken Hospital Authority",null,"TRUE"]
["Hudson County Improvement Authority",null,"Hudson County Improvement Authority",null,"TRUE"]
["Jackson Municipal Utilities Authority",null,"Jackson Municipal Utilities Authority",null,"TRUE"]
["Jersey City Municipal Utilities Authority",null,"Jersey City Municipal Utilities Authority",null,"TRUE"]
["Jersey City Redevelopment Agency",null,"Jersey City Redevelopment Agency",null,"TRUE"]
["Kearny Municipal Utilities Authority",null,"Kearny Municipal Utilities Authority",null,"TRUE"]
["Lacey Municipal Utilities Authority",null,"Lacey Municipal Utilities Authority",null,"TRUE"]
["Lakewood Municipal Utilities Authority",null,"Lakewood Municipal Utilities Authority",null,"TRUE"]
["Lambertville Sewerage Authority",null,"Lambertville Sewerage Authority",null,"TRUE"]
["Landis Sewerage Authority",null,"Landis Sewerage Authority",null,"TRUE"]
["Lebanon Borough Sewerage Authority",null,"Lebanon Borough Sewerage Authority",null,"TRUE"]
["Linden-Roselle Sewerage Authority",null,"Linden-Roselle Sewerage Authority",null,"TRUE"]
["Little Egg Harbor Municipal Utilities Authority",null,"Little Egg Harbor Municipal Utilities Authority",null,"TRUE"]
["Logan Municipal Utilities Authority",null,"Logan Municipal Utilities Authority",null,"TRUE"]
["Long Branch Sewerage Authority",null,"Long Branch Sewerage Authority",null,"TRUE"]
["Lower Municipal Utilities Authority",null,"Lower Municipal Utilities Authority",null,"TRUE"]
["Manasquan River Regional Sewerage Authority",null,"Manasquan River Regional Sewerage Authority",null,"TRUE"]
["Manchester Municipal Utilities Authority",null,"Manchester Municipal Utilities Authority",null,"TRUE"]
["Mantua Municipal Utilities Authority",null,"Mantua Municipal Utilities Authority",null,"TRUE"]
["Mercer County Improvement Authority",null,"Mercer County Improvement Authority",null,"TRUE"]
["Merchantville-Pennsauken Water Commission",null,"Merchantville-Pennsauken Water Commission",null,"TRUE"]
["Metuchen Parking Authority",null,"Metuchen Parking Authority",null,"TRUE"]
["Middlesex County Improvement Authority",null,"Middlesex County Improvement Authority",null,"TRUE"]
["Middlesex County Utilities Authority",null,"Middlesex County Utilities Authority",null,"TRUE"]
["Middletown Sewerage Authority",null,"Middletown Sewerage Authority",null,"TRUE"]
["Milltown-Ford Avenue Redevelopment Agency",null,"Milltown-Ford Avenue Redevelopment Agency",null,"TRUE"]
["Monmouth County Bayshore Outfall Authority",null,"Monmouth County Bayshore Outfall Authority",null,"TRUE"]
["Monmouth County Improvement Authority",null,"Monmouth County Improvement Authority",null,"TRUE"]
["Monroe (Gloucester) Municipal Utilities Authority",null,"Monroe (Gloucester) Municipal Utilities Authority",null,"TRUE"]
["Morris County Improvement Authority",null,"Morris County Improvement Authority",null,"TRUE"]
["Morris County Utilities Authority",null,"Morris County Utilities Authority",null,"TRUE"]
["Morristown Parking Authority",null,"Morristown Parking Authority",null,"TRUE"]
["Mount Holly Municipal Utilities Authority",null,"Mount Holly Municipal Utilities Authority",null,"TRUE"]
["Mount Laurel Municipal Utilities Authority",null,"Mount Laurel Municipal Utilities Authority",null,"TRUE"]
["Musconetcong Sewerage Authority",null,"Musconetcong Sewerage Authority",null,"TRUE"]
["Neptune Township Sewerage Authority",null,"Neptune Township Sewerage Authority",null,"TRUE"]
["New Brunswick Parking Authority",null,"New Brunswick Parking Authority",null,{"$f":"IF(A105=C105,\"TRUE\",\"FALSE\")","v":"TRUE"}]
["New Jersey Public Power Authority",null,"New Jersey Public Power Authority",null,"TRUE"]
["Newark Parking Authority",null,"Newark Parking Authority",null,"TRUE"]
["Newton Parking Authority",null,"Newton Parking Authority",null,"TRUE"]
["North Bergen Municipal Utilities Authority",null,"North Bergen Municipal Utilities Authority",null,"TRUE"]
["North Bergen Parking Authority",null,"North Bergen Parking Authority",null,"TRUE"]
["North Hudson Regional Sewerage Authority",null,"North Hudson Regional Sewerage Authority",null,"TRUE"]
["Northwest Bergen County Utilities Authority",null,"Northwest Bergen County Utilities Authority",null,"TRUE"]
["Ocean County Utilities Authority",null,"Ocean County Utilities Authority",null,"TRUE"]
["Ocean Grove Sewerage Authority",null,"Ocean Grove Sewerage Authority",null,"TRUE"]
["Ocean Township Sewerage Authority",null,"Ocean Township Sewerage Authority",null,"TRUE"]
["Old Bridge Municipal Utilities Authority",null,"Old Bridge Municipal Utilities Authority",null,"TRUE"]
["Old Bridge Redevelopment Agency",null,"Old Bridge Redevelopment Agency",null,"TRUE"]
["Passaic County Improvement Authority",null,"Passaic County Improvement Authority",null,"TRUE"]
["Passaic County Utilities Authority",null,"Passaic County Utilities Authority",null,"TRUE"]
["Passaic Parking Authority",null,"Passaic Parking Authority",null,"TRUE"]
["Passaic Redevelopment Agency",null,"Passaic Redevelopment Agency",null,"TRUE"]
["Passaic Valley Water Commission",null,"Passaic Valley Water Commission",null,"TRUE"]
["Paterson Parking Authority",null,"Paterson Parking Authority",null,"TRUE"]
["Penns Grove Redevelopment Agency",null,"Penns Grove Redevelopment Agency",null,"TRUE"]
["Penns Grove Sewerage Authority",null,"Penns Grove Sewerage Authority",null,"TRUE"]
["Pennsauken Sewerage Authority",null,"Pennsauken Sewerage Authority",null,"TRUE"]
["Pennsville Sewerage Authority",null,"Pennsville Sewerage Authority",null,"TRUE"]
["Pequannock River Basin Regional Sewerage Authority",null,"Pequannock River Basin Regional Sewerage Authority",null,"TRUE"]
["Pequannock-Lincoln Park-Fairfield Sewerage Authority",null,"Pequannock-Lincoln Park-Fairfield Sewerage Authority",null,"TRUE"]
["Perth Amboy Redevelopment Agency",null,"Perth Amboy Redevelopment Agency",null,"TRUE"]
["Pine Hill Municipal Utilities Authority",null,"Pine Hill Municipal Utilities Authority",null,"TRUE"]
["Plainfield Regional Sewerage Authority",null,"Plainfield Regional Sewerage Authority",null,"TRUE"]
["Plumsted Municipal Utilities Authority",null,"Plumsted Municipal Utilities Authority",null,"TRUE"]
["Point Pleasant Beach Parking Authority",null,"Point Pleasant Beach Parking Authority",null,"TRUE"]
["Pompton Lakes Municipal Utilities Authority",null,"Pompton Lakes Municipal Utilities Authority",null,"TRUE"]
["Rahway Redevelopment Agency",null,"Rahway Redevelopment Agency",null,"TRUE"]
["Rahway Valley Sewerage Authority",null,"Rahway Valley Sewerage Authority",null,"TRUE"]
["Raritan Township Municipal Utilities Authority",null,"Raritan Township Municipal Utilities Authority",null,"TRUE"]
["Readington-Lebanon Sewerage Authority",null,"Readington-Lebanon Sewerage Authority",null,"TRUE"]
["Riverside Sewerage Authority",null,"Riverside Sewerage Authority",null,"TRUE"]
["Rockaway Valley Regional Sewerage Authority",null,"Rockaway Valley Regional Sewerage Authority",null,"TRUE"]
["Rockleigh Sewerage Authority",null,"Rockleigh Sewerage Authority",null,"TRUE"]
["Salem County Improvement Authority",null,"Salem County Improvement Authority",null,"TRUE"]
["Salem County Pollution Control Financing Authority",null,"Salem County Pollution Control Financing Authority",null,"TRUE"]
["Salem Municipal Port Authority",null,"Salem Municipal Port Authority",null,"TRUE"]
["Sayreville Redevelopment Agency",null,"Sayreville Redevelopment Agency",null,"TRUE"]
["Secaucus Municipal Utilities Authority",null,"Secaucus Municipal Utilities Authority",null,"TRUE"]
["Somerset County Improvement Authority",null,"Somerset County Improvement Authority",null,"TRUE"]
["Somerset-Raritan Valley Regional Sewerage Authority",null,"Somerset-Raritan Valley Regional Sewerage Authority",null,"TRUE"]
["South Amboy Redevelopment Agency",null,"South Amboy Redevelopment Agency",null,"TRUE"]
["South Monmouth Regional Sewerage Authority",null,"South Monmouth County Regional Sewerage Authority",null,"FALSE"]
["South Orange Parking Authority",null,"South Orange Parking Authority",null,"TRUE"]
["South Toms River Sewerage Authority",null,"South Toms River Sewerage Authority",null,"TRUE"]
["Southeast Monmouth Municipal Utilities Authority",null,"Southeast Monmouth Municipal Utilities Authority",null,"TRUE"]
["Southeast Morris County Utilities Authority",null,"Southeast Morris County Utilities Authority",null,"TRUE"]
["Stony Brook Regional Sewerage Authority",null,"Stony Brook Regional Sewerage Authority",null,"TRUE"]
["Sussex County Utilities Authority",null,"Sussex County Utilities Authority",null,"TRUE"]
["Toms River Municipal Utilities Authority",null,"Toms River Municipal Utilities Authority",null,"TRUE"]
["Toms River Parking Authority",null,"Toms River Parking Authority",null,"TRUE"]
["Trenton Parking Authority",null,"Trenton Parking Authority",null,"TRUE"]
["Two Rivers Water Reclamation Authority",null,"Two Rivers Water Reclamation Authority",null,"TRUE"]
["Union City Parking Authority",null,"Union City Parking Authority",null,"TRUE"]
["Union City Redevelopment Authority",null,"Union City Redevelopment Authority",null,"TRUE"]
["Union County Improvement Authority",null,"Union County Improvement Authority",null,"TRUE"]
["Union County Utilities Authority",null,"Union County Utilities Authority",null,"TRUE"]
["Vernon Township Municipal Utilities Authority",null,"Vernon Township Municipal Utilities Authority",null,"TRUE"]
["Wanaque Valley Regional Sewerage Authority",null,"Wanaque Valley Regional Sewerage Authority",null,{"$f":"IF(A167=C167,\"TRUE\",\"FALSE\")","v":"TRUE"}]
["Warren County - Pequest River Utilities Authority",null,"Warren County - Pequest River Utilities Authority",null,"TRUE"]
["Warren County Pollution Control Financing Authority",null,"Warren County Pollution Control Financing Authority",null,"TRUE"]
["Washington Township Municipal Utilities Authority (Gloucester)",null,"Washington Township Municipal Utilities Authority (Gloucester)",null,"TRUE"]
["Washington Township Municipal Utilities Authority (Morris)",null,"Washington Township Municipal Utilities Authority (Morris)",null,"TRUE"]
["Weehawken Parking Authority",null,"Weehawken Parking Authority",null,"TRUE"]
["West New York Parking Authority",null,"West New York Parking Authority",null,"TRUE"]
["West Windsor Parking Authority",null,"West Windsor Parking Authority",null,"TRUE"]
["Western Monmouth Utilities Authority",null,"Western Monmouth County Utilities Authority",null,"FALSE"]
["Westwood Parking Authority",null,"Westwood Parking Authority",null,"TRUE"]
["Weymouth Municipal Utilities Authority",null,"Weymouth Municipal Utilities Authority",null,"TRUE"]
["Wildwoods Tourism Improvement and Development Authority",null,"Wildwoods Tourism Improvement and Development Authority",null,"TRUE"]
["Willingboro Municipal Utilities Authority",null,"Willingboro Municipal Utilities Authority",null,"TRUE"]
["Woodbine Municipal Port Authority",null,"Woodbine Municipal Port Authority",null,"TRUE"]
["Woodbine Municipal Utilities Authority",null,"Woodbine Municipal Utilities Authority",null,"TRUE"]
["Woodbridge Redevelopment Agency",null,"Woodbridge Redevelopment Agency",null,"TRUE"]
["Woodstown Sewerage Authority",null,"Woodstown Sewerage Authority",null,"TRUE"]
["Wrightstown Municipal Utilities Authority",null,"Wrightstown Municipal Utilities Authority",null,"TRUE"]

{"sheet":"KEY METRICS","index":1,"n_rows":469,"n_cols":4,"rows_kept":469,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["AUTHORITY BUDGET KEY METRICS"]
[]
[null,null,"Current Year (Proposed)","Prior Year"]
[null,"Health Benefits"]
[null,"Active Employees"]
[null,"# of Covered Members",{"$f":"'Health Benefits (N-5)'!B13","v":0},{"$f":"'Health Benefits (N-5)'!E13","v":0}]
[null,"Total Cost ",{"$f":"'Health Benefits (N-5)'!D13","v":0},{"$f":"'Health Benefits (N-5)'!G13","v":0}]
[null,"Commissioners"]
[null,"# of Covered Members",{"$f":"'Health Benefits (N-5)'!B21","v":0},{"$f":"'Health Benefits (N-5)'!E21","v":0}]
[null,"Total Cost ",{"$f":"'Health Benefits (N-5)'!D21","v":0},{"$f":"'Health Benefits (N-5)'!G21","v":0}]
[null,"Retirees"]
[null,"# of Covered Members",{"$f":"'Health Benefits (N-5)'!B29","v":0},{"$f":"'Health Benefits (N-5)'!E29","v":0}]
[null,"Total Cost ",{"$f":"'Health Benefits (N-5)'!D29","v":0},{"$f":"'Health Benefits (N-5)'!G29","v":0}]
[null,"GRAND TOTAL (Total Cost)",{"$f":"C7+C10+C13","v":0},{"$f":"D7+D10+D13","v":0}]
[]
[null,"SHBP Coverage (Medical)",{"$f":"'Health Benefits (N-5)'!D33","v":0}]
[null,"SHBP Coverage (Prescription)",{"$f":"'Health Benefits (N-5)'!D34","v":0}]
[]
[null,"Accumulated Absences"]
[null,"Gross Days of Accumulated Compensated Absences",{"$f":"SUM('Accumulated Absences (N-6)'!B7:B24,'Accumulated Absences (N-6) (2)'!B7:B24,'Accumulated Absences (N-6) (3)'!B7:B24,'Accumulated Absences (N-6) (4)'!B7:B24,'Accumulated Absences (N-6) (5)'!B7:B24,'Accumulated Absences (N-6) (6)'!B7:B24,'Accumulated Absences (N-6) (7)'!B7:B24,'Accumulated Absences (N-6) (8)'!B7:B24,'TOTAL Accumulated Absences'!B7:B24)","v":0}]
[null,"Dollar Value of Accrued Compensated Absence Liability",{"$f":"'TOTAL Accumulated Absences'!C25","v":0}]
[]
[null,"Shared Services"]
[null,"Total Amount to be Received by/Paid from Authority",{"$f":"SUM('Shared Services (N-7)'!G7:G26)","v":0}]
[]
[null,"Revenues"]
[null,"Operation #1"]
[null,"Service Charges",{"$f":"'F-2 Revenues (Proposed)'!D13","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D13","v":0}]
[null,"Connection Fees",{"$f":"'F-2 Revenues (Proposed)'!D20","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D20","v":0}]
[null,"Parking Fees",{"$f":"'F-2 Revenues (Proposed)'!D26","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D26","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!D39","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D39","v":0}]
[null,"Total Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!D40","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D40","v":0}]
[]
[null,"Other Revenues (Non-Operating)",{"$f":"'F-2 Revenues (Proposed)'!D49","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D49","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!D54","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D54","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!D55","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D55","v":0}]
[]
[null,"Total Anticipated Revenues - Operation 1",{"$f":"'F-2 Revenues (Proposed)'!D56","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D56","v":0}]
[]
[null,"Operation #2"]
[null,"Service Charges",{"$f":"'F-2 Revenues (Proposed)'!E13","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E13","v":0}]
[null,"Connection Fees",{"$f":"'F-2 Revenues (Proposed)'!E20","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E20","v":0}]
[null,"Parking Fees",{"$f":"'F-2 Revenues (Proposed)'!E26","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E26","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!E39","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E39","v":0}]
[null,"Total Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!E40","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E40","v":0}]
[]
[null,"Other Revenues (Non-Operating)",{"$f":"'F-2 Revenues (Proposed)'!E49","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E49","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!E54","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E54","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!E55","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E55","v":0}]
[]
[null,"Total Anticipated Revenues - Operation 2",{"$f":"'F-2 Revenues (Proposed)'!E56","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E56","v":0}]
[]
[null,"Operation #3"]
[null,"Service Charges",{"$f":"'F-2 Revenues (Proposed)'!F13","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F13","v":0}]
[null,"Connection Fees",{"$f":"'F-2 Revenues (Proposed)'!F20","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F20","v":0}]
[null,"Parking Fees",{"$f":"'F-2 Revenues (Proposed)'!F26","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F26","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!F39","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F39","v":0}]
[null,"Total Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!F40","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F40","v":0}]
[]
[null,"Other Revenues (Non-Operating)",{"$f":"'F-2 Revenues (Proposed)'!F49","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F49","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!F54","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F54","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!F55","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F55","v":0}]
[]
[null,"Total Anticipated Revenues - Operation 3",{"$f":"'F-2 Revenues (Proposed)'!F56","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F56","v":0}]
[]
[null,"Operation #4"]
[null,"Service Charges",{"$f":"'F-2 Revenues (Proposed)'!G13","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G13","v":0}]
[null,"Connection Fees",{"$f":"'F-2 Revenues (Proposed)'!G20","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G20","v":0}]
[null,"Parking Fees",{"$f":"'F-2 Revenues (Proposed)'!G26","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G26","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!G39","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G39","v":0}]
[null,"Total Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!G40","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G40","v":0}]
[]
[null,"Other Revenues (Non-Operating)",{"$f":"'F-2 Revenues (Proposed)'!G49","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G49","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!G54","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G54","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!G55","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G55","v":0}]
[]
[null,"Total Anticipated Revenues - Operation 4",{"$f":"'F-2 Revenues (Proposed)'!G56","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G56","v":0}]
[]
[null,"Operation #5"]
[null,"Service Charges",{"$f":"'F-2 Revenues (Proposed)'!H13","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H13","v":0}]
[null,"Connection Fees",{"$f":"'F-2 Revenues (Proposed)'!H20","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H20","v":0}]
[null,"Parking Fees",{"$f":"'F-2 Revenues (Proposed)'!H26","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H26","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!H39","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H39","v":0}]
[null,"Total Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!H40","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H40","v":0}]
[]
[null,"Other Revenues (Non-Operating)",{"$f":"'F-2 Revenues (Proposed)'!H49","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H49","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!H54","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H54","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!H55","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H55","v":0}]
[]
[null,"Total Anticipated Revenues - Operation 5",{"$f":"'F-2 Revenues (Proposed)'!H56","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!H56","v":0}]
[]
[null,"Operation #6"]
[null,"Service Charges",{"$f":"'F-2 Revenues (Proposed)'!I13","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I13","v":0}]
[null,"Connection Fees",{"$f":"'F-2 Revenues (Proposed)'!I20","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I20","v":0}]
[null,"Parking Fees",{"$f":"'F-2 Revenues (Proposed)'!I26","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I26","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!I39","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I39","v":0}]
[null,"Total Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!I40","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I40","v":0}]
[]
[null,"Other Revenues (Non-Operating)",{"$f":"'F-2 Revenues (Proposed)'!H49","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I49","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!I54","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I54","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!I55","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I55","v":0}]
[]
[null,"Total Anticipated Revenues - Operation 6",{"$f":"'F-2 Revenues (Proposed)'!I56","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I56","v":0}]
[]
[null,"TOTALS"]
[null,"Total Service Charges - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J13","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J13","v":0}]
[null,"Total Connection Fees - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J20","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J20","v":0}]
[null,"Total Parking Fees - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J26","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J26","v":0}]
[null,"Total Other Revenue - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J39","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J39","v":0}]
[null,"Total Operating Revenue - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J40","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J40","v":0}]
[]
[null,"Total Other Revenues (Non-Operating) - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J49","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J49","v":0}]
[null,"Total Interest on Investments and Deposits - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J54","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J54","v":0}]
[null,"Total Non-Operating Revenue - All Operations",{"$f":"'F-2 Revenues (Proposed)'!J55","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!J55","v":0}]
[]
[null,"GRAND TOTAL - Total Anticipated Revenues - All Operations ",{"$f":"'F-2 Revenues (Proposed)'!J56","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!I56","v":0}]
[]
[null,"Appropriations"]
[null,"Operation #1"]
[null,"Administration - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!D10","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D10","v":0}]
[null,"Administration - Other",{"$f":"'F-4 Appropriations (Proposed)'!D17","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D17","v":0}]
[null,"Total Administration",{"$f":"'F-4 Appropriations (Proposed)'!D18","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D118","v":0}]
[null,"Cost of Providing Services - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!D22","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D22","v":0}]
[null,"Cost of Providing Services - Other",{"$f":"'F-4 Appropriations (Proposed)'!D29","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D29","v":0}]
[null,"Total Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!D30","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D30","v":0}]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",{"$f":"'F-4 Appropriations (Proposed)'!D31","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D31","v":0}]
[null,"Total Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!D32","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D32","v":0}]
[]
[null,"Total Interest Payments on Debt",{"$f":"'F-4 Appropriations (Proposed)'!D34","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D34","v":0}]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!D35","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D35","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!D36","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D36","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!D37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D37","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!D38","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D38","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!D39","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D39","v":0}]
[]
[null,"Total Appropriations - Operation #1",{"$f":"'F-4 Appropriations (Proposed)'!D40","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D40","v":0}]
[]
[null,"Accumulated Deficit - Operation #1",{"$f":"'F-4 Appropriations (Proposed)'!D41","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D41","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Operation #1",{"$f":"'F-4 Appropriations (Proposed)'!D46","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D46","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Operation #1",{"$f":"'F-4 Appropriations (Proposed)'!D47","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D47","v":0}]
[]
[null,"Operation #2"]
[null,"Administration - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!E10","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E10","v":0}]
[null,"Administration - Other",{"$f":"'F-4 Appropriations (Proposed)'!E17","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E17","v":0}]
[null,"Total Administration",{"$f":"'F-4 Appropriations (Proposed)'!E18","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E18","v":0}]
[null,"Cost of Providing Services - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!E22","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E22","v":0}]
[null,"Cost of Providing Services - Other",{"$f":"'F-4 Appropriations (Proposed)'!E29","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E29","v":0}]
[null,"Total Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!E30","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E30","v":0}]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",{"$f":"'F-4 Appropriations (Proposed)'!E31","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E31","v":0}]
[null,"Total Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!E32","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E32","v":0}]
[]
[null,"Total Interest Payments on Debt",{"$f":"'F-4 Appropriations (Proposed)'!E34","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E34","v":0}]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!E35","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E35","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!E36","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E36","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!E37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E37","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!E38","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E38","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!E39","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E39","v":0}]
[]
[null,"Total Appropriations - Operation #2",{"$f":"'F-4 Appropriations (Proposed)'!E40","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E40","v":0}]
[]
[null,"Accumulated Deficit - Operation #2",{"$f":"'F-4 Appropriations (Proposed)'!E41","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E41","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Operation #2",{"$f":"'F-4 Appropriations (Proposed)'!E46","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E46","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Operation #2",{"$f":"'F-4 Appropriations (Proposed)'!E47","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E47","v":0}]
[]
[null,"Operation #3"]
[null,"Administration - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!F10","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F10","v":0}]
[null,"Administration - Other",{"$f":"'F-4 Appropriations (Proposed)'!F17","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F17","v":0}]
[null,"Total Administration",{"$f":"'F-4 Appropriations (Proposed)'!F18","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F18","v":0}]
[null,"Cost of Providing Services - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!F22","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F22","v":0}]
[null,"Cost of Providing Services - Other",{"$f":"'F-4 Appropriations (Proposed)'!F29","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F29","v":0}]
[null,"Total Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!F30","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F30","v":0}]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",{"$f":"'F-4 Appropriations (Proposed)'!F31","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F31","v":0}]
[null,"Total Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!F32","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F32","v":0}]
[]
[null,"Total Interest Payments on Debt",{"$f":"'F-4 Appropriations (Proposed)'!F34","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F34","v":0}]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!F35","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F35","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!F36","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F36","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!F37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F37","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!F38","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F38","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!F39","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F39","v":0}]
[]
[null,"Total Appropriations - Operation #3",{"$f":"'F-4 Appropriations (Proposed)'!F40","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F40","v":0}]
[]
[null,"Accumulated Deficit - Operation #3",{"$f":"'F-4 Appropriations (Proposed)'!F41","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F41","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Operation #3",{"$f":"'F-4 Appropriations (Proposed)'!F46","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F46","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Operation #3",{"$f":"'F-4 Appropriations (Proposed)'!F47","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F47","v":0}]
[]
[null,"Operation #4"]
[null,"Administration - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!G10","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G10","v":0}]
[null,"Administration - Other",{"$f":"'F-4 Appropriations (Proposed)'!G17","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G17","v":0}]
[null,"Total Administration",{"$f":"'F-4 Appropriations (Proposed)'!G18","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G18","v":0}]
[null,"Cost of Providing Services - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!G22","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G22","v":0}]
[null,"Cost of Providing Services - Other",{"$f":"'F-4 Appropriations (Proposed)'!G29","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G29","v":0}]
[null,"Total Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!G30","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G30","v":0}]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",{"$f":"'F-4 Appropriations (Proposed)'!G31","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G31","v":0}]
[null,"Total Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!G32","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G32","v":0}]
[]
[null,"Total Interest Payments on Debt",{"$f":"'F-4 Appropriations (Proposed)'!G34","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G34","v":0}]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!G35","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G35","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!G36","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G36","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!G37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G37","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!G38","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G38","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!G39","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G39","v":0}]
[]
[null,"Total Appropriations - Operation #4",{"$f":"'F-4 Appropriations (Proposed)'!G40","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G40","v":0}]
[]
[null,"Accumulated Deficit - Operation #4",{"$f":"'F-4 Appropriations (Proposed)'!G41","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G41","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Operation #4",{"$f":"'F-4 Appropriations (Proposed)'!G46","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G46","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Operation #4",{"$f":"'F-4 Appropriations (Proposed)'!G47","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G47","v":0}]
[]
[null,"Operation #5"]
[null,"Administration - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!H10","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H10","v":0}]
[null,"Administration - Other",{"$f":"'F-4 Appropriations (Proposed)'!H17","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H17","v":0}]
[null,"Total Administration",{"$f":"'F-4 Appropriations (Proposed)'!H18","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H18","v":0}]
[null,"Cost of Providing Services - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!H22","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H22","v":0}]
[null,"Cost of Providing Services - Other",{"$f":"'F-4 Appropriations (Proposed)'!H29","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H29","v":0}]
[null,"Total Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!H30","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H30","v":0}]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",{"$f":"'F-4 Appropriations (Proposed)'!H31","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H31","v":0}]
[null,"Total Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!H32","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H32","v":0}]
[]
[null,"Total Interest Payments on Debt",{"$f":"'F-4 Appropriations (Proposed)'!H34","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H34","v":0}]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!H35","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H35","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!H36","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H36","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!H37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H37","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!H38","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H38","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!H39","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H39","v":0}]
[]
[null,"Total Appropriations - Operation #5",{"$f":"'F-4 Appropriations (Proposed)'!H40","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H40","v":0}]
[]
[null,"Accumulated Deficit - Operation #5",{"$f":"'F-4 Appropriations (Proposed)'!H41","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H41","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Operation #5",{"$f":"'F-4 Appropriations (Proposed)'!H46","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H46","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Operation #5",{"$f":"'F-4 Appropriations (Proposed)'!H47","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H47","v":0}]
[]
[null,"Operation #6"]
[null,"Administration - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!I10","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I10","v":0}]
[null,"Administration - Other",{"$f":"'F-4 Appropriations (Proposed)'!I17","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I17","v":0}]
[null,"Total Administration",{"$f":"'F-4 Appropriations (Proposed)'!I18","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I18","v":0}]
[null,"Cost of Providing Services - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!I22","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I22","v":0}]
[null,"Cost of Providing Services - Other",{"$f":"'F-4 Appropriations (Proposed)'!I29","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I29","v":0}]
[null,"Total Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!I30","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I30","v":0}]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",{"$f":"'F-4 Appropriations (Proposed)'!I31","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I31","v":0}]
[null,"Total Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!I32","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I32","v":0}]
[]
[null,"Total Interest Payments on Debt",{"$f":"'F-4 Appropriations (Proposed)'!I34","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I34","v":0}]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!I35","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I35","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!I36","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I36","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!I37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I37","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!I38","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I38","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!I39","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I39","v":0}]
[]
[null,"Total Appropriations - Operation #6",{"$f":"'F-4 Appropriations (Proposed)'!I40","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I40","v":0}]
[]
[null,"Accumulated Deficit - Operation #6",{"$f":"'F-4 Appropriations (Proposed)'!I41","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I41","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Operation #6",{"$f":"'F-4 Appropriations (Proposed)'!I46","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I46","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Operation #6",{"$f":"'F-4 Appropriations (Proposed)'!I47","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!I47","v":0}]
[]
[null,"TOTALS"]
[null,"Total Administration - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!J10","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J10","v":0}]
[null,"Total Administration - Other",{"$f":"'F-4 Appropriations (Proposed)'!J17","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J17","v":0}]
[null,"Total Administration",{"$f":"'F-4 Appropriations (Proposed)'!J18","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J18","v":0}]
[null,"Total Cost of Providing Services - Personnel",{"$f":"'F-4 Appropriations (Proposed)'!J22","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J22","v":0}]
[null,"Total Cost of Providing Services - Other",{"$f":"'F-4 Appropriations (Proposed)'!J29","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J29","v":0}]
[null,"Total Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!J30","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J30","v":0}]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",{"$f":"'F-4 Appropriations (Proposed)'!J31","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J31","v":0}]
[null,"Total Operating Appropriations ",{"$f":"'F-4 Appropriations (Proposed)'!J32","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J32","v":0}]
[]
[null,"Total Interest Payments on Debt",{"$f":"'F-4 Appropriations (Proposed)'!J34","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J34","v":0}]
[null,"Total Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!J35","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J35","v":0}]
[null,"Total Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!J36","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J36","v":0}]
[null,"Total Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!J37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J37","v":0}]
[null,"Total Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!J38","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J38","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!J39","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J39","v":0}]
[]
[null,"Total Appropriations - All Operations ",{"$f":"'F-4 Appropriations (Proposed)'!J40","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J40","v":0}]
[]
[null,"Accumulated Deficit - All Operations ",{"$f":"'F-4 Appropriations (Proposed)'!J41","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J41","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - All Operations",{"$f":"'F-4 Appropriations (Proposed)'!J46","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J46","v":0}]
[]
[null,"TOTAL NEW APPROPRIATIONS - ALL OPERATIONS",{"$f":"'F-4 Appropriations (Proposed)'!J47","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!J47","v":0}]
[]
[]
[null,"Debt Service"]
[null,"Principal:"]
[null,"Operation #1:"]
[null,"Total Principal ",{"$f":"'F-6 Debt Service-Principal'!H10","v":0},{"$f":"'F-6 Debt Service-Principal'!F10","v":0}]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P10","v":0}]
[null,"Operation #2:"]
[null,"Total Principal ",{"$f":"'F-6 Debt Service-Principal'!H16","v":0},{"$f":"'F-6 Debt Service-Principal'!F16","v":0}]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P16","v":0}]
[null,"Operation #3:"]
[null,"Total Principal ",{"$f":"'F-6 Debt Service-Principal'!H22","v":0},{"$f":"'F-6 Debt Service-Principal'!F22","v":0}]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P22","v":0}]
[null,"Operation #4:"]
[null,"Total Principal ",{"$f":"'F-6 Debt Service-Principal'!H28","v":0},{"$f":"'F-6 Debt Service-Principal'!F28","v":0}]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P28","v":0}]
[null,"Operation #5:"]
[null,"Total Principal ",{"$f":"'F-6 Debt Service-Principal'!H34","v":0},{"$f":"'F-6 Debt Service-Principal'!F34","v":0}]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P34","v":0}]
[null,"Operation #6:"]
[null,"Total Principal ",{"$f":"'F-6 Debt Service-Principal'!H40","v":0},{"$f":"'F-6 Debt Service-Principal'!F40","v":0}]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P40","v":0}]
[null,"Total - All Operations"]
[null,"Total Principal",{"$f":"'F-6 Debt Service-Principal'!H41","v":0},{"$f":"'F-6 Debt Service-Principal'!F41","v":0}]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P41","v":0}]
[null,"Interest:"]
[null,"Operation #1:"]
[null,"Total Interest ",{"$f":"'F-7 Debt Service-Interest'!F10","v":0},{"$f":"'F-7 Debt Service-Interest'!D10","v":0}]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N10","v":0}]
[null,"Operation #2:"]
[null,"Total Interest ",{"$f":"'F-7 Debt Service-Interest'!F16","v":0},{"$f":"'F-7 Debt Service-Interest'!D16","v":0}]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N16","v":0}]
[null,"Operation #3:"]
[null,"Total Interest ",{"$f":"'F-7 Debt Service-Interest'!F22","v":0},{"$f":"'F-7 Debt Service-Interest'!D22","v":0}]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N22","v":0}]
[null,"Operation #4:"]
[null,"Total Interest ",{"$f":"'F-7 Debt Service-Interest'!F28","v":0},{"$f":"'F-7 Debt Service-Interest'!D28","v":0}]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N28","v":0}]
[null,"Operation #5:"]
[null,"Total Interest ",{"$f":"'F-7 Debt Service-Interest'!F34","v":0},{"$f":"'F-7 Debt Service-Interest'!D34","v":0}]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N34","v":0}]
[null,"Operation #6:"]
[null,"Total Interest ",{"$f":"'F-7 Debt Service-Interest'!F40","v":0},{"$f":"'F-7 Debt Service-Interest'!D40","v":0}]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N40","v":0}]
[null,"Total - All Operations"]
[null,"Total Interest ",{"$f":"'F-7 Debt Service-Interest'!F41","v":0},{"$f":"'F-7 Debt Service-Interest'!D41","v":0}]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N41","v":0}]
[null,"Bond Rating:"]
[null,"Moody's",{"$f":"'F-6 Debt Service-Principal'!F45","v":0}]
[null,"Year",{"$f":"'F-6 Debt Service-Principal'!F46","v":0}]
[]
[null,"S&P ",{"$f":"'F-6 Debt Service-Principal'!J45","v":0}]
[null,"Year",{"$f":"'F-6 Debt Service-Principal'!J46","v":0}]
[]
[null,"Fitch",{"$f":"'F-6 Debt Service-Principal'!H45","v":0}]
[null,"Year",{"$f":"'F-6 Debt Service-Principal'!H46","v":0}]
[]
[null,"Net Position"]
[null,"Operation #1"]
[null,"Total Net Position Beginning of Current Year",{"$f":"'F-8 Net Position'!D6","v":0}]
[null,"Unrestricted Net Position Available for Use in Proposed Budget",{"$f":"'F-8 Net Position'!D18","v":0}]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",{"$f":"'F-8 Net Position'!D19","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",{"$f":"'F-8 Net Position'!D20","v":0}]
[null,"Appropriation to Municipality/County",{"$f":"'F-8 Net Position'!D21","v":0}]
[null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"'F-8 Net Position'!D22","v":0}]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!D23","v":0}]
[]
[null,"Operation #2"]
[null,"Total Net Position Beginning of Current Year",{"$f":"'F-8 Net Position'!E6","v":0}]
[null,"Unrestricted Net Position Available for Use in Proposed Budget",{"$f":"'F-8 Net Position'!E18","v":0}]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",{"$f":"'F-8 Net Position'!E19","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",{"$f":"'F-8 Net Position'!E20","v":0}]
[null,"Appropriation to Municipality/County",{"$f":"'F-8 Net Position'!E21","v":0}]
[null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"'F-8 Net Position'!E22","v":0}]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!E23","v":0}]
[]
[null,"Operation #3"]
[null,"Total Net Position Beginning of Current Year",{"$f":"'F-8 Net Position'!F6","v":0}]
[null,"Unrestricted Net Position Available for Use in Proposed Budget",{"$f":"'F-8 Net Position'!F18","v":0}]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",{"$f":"'F-8 Net Position'!F19","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",{"$f":"'F-8 Net Position'!F20","v":0}]
[null,"Appropriation to Municipality/County",{"$f":"'F-8 Net Position'!F21","v":0}]
[null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"'F-8 Net Position'!F22","v":0}]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!F23","v":0}]
[]
[null,"Operation #4"]
[null,"Total Net Position Beginning of Current Year",{"$f":"'F-8 Net Position'!G6","v":0}]
[null,"Unrestricted Net Position Available for Use in Proposed Budget",{"$f":"'F-8 Net Position'!G18","v":0}]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",{"$f":"'F-8 Net Position'!G19","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",{"$f":"'F-8 Net Position'!G20","v":0}]
[null,"Appropriation to Municipality/County",{"$f":"'F-8 Net Position'!G21","v":0}]
[null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"'F-8 Net Position'!G22","v":0}]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!G23","v":0}]
[]
[null,"Operation #5"]
[null,"Total Net Position Beginning of Current Year",{"$f":"'F-8 Net Position'!H6","v":0}]
[null,"Unrestricted Net Position Available for Use in Proposed Budget",{"$f":"'F-8 Net Position'!H18","v":0}]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",{"$f":"'F-8 Net Position'!H19","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",{"$f":"'F-8 Net Position'!H20","v":0}]
[null,"Appropriation to Municipality/County",{"$f":"'F-8 Net Position'!H21","v":0}]
[null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"'F-8 Net Position'!H22","v":0}]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!H23","v":0}]
[]
[null,"Operation #6"]
[null,"Total Net Position Beginning of Current Year",{"$f":"'F-8 Net Position'!I6","v":0}]
[null,"Unrestricted Net Position Available for Use in Proposed Budget",{"$f":"'F-8 Net Position'!I18","v":0}]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",{"$f":"'F-8 Net Position'!I19","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",{"$f":"'F-8 Net Position'!I20","v":0}]
[null,"Appropriation to Municipality/County",{"$f":"'F-8 Net Position'!I21","v":0}]
[null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"'F-8 Net Position'!I22","v":0}]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!I23","v":0}]
[]
[null,"Totals - All Operations"]
[null,"Total Net Position Beginning of Current Year",{"$f":"'F-8 Net Position'!J6","v":0}]
[null,"Unrestricted Net Position Available for Use in Proposed Budget",{"$f":"'F-8 Net Position'!J18","v":0}]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",{"$f":"'F-8 Net Position'!J19","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",{"$f":"'F-8 Net Position'!J20","v":0}]
[null,"Appropriation to Municipality/County",{"$f":"'F-8 Net Position'!J21","v":0}]
[null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"'F-8 Net Position'!J22","v":0}]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!J23","v":0}]
[]
[null,"Capital Budget"]
[null,"Operation #1"]
[null,"Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E11","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F11","v":0}]
[null,"Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G11","v":0}]
[null,"Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H11","v":0}]
[null,"Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I11","v":0}]
[null,"Estimated Total Cost",{"$f":"'CB-3 Capital Budget Proposed'!C11","v":0}]
[]
[null,"Operation #2"]
[null,"Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E17","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F17","v":0}]
[null,"Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G17","v":0}]
[null,"Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H17","v":0}]
[null,"Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I17","v":0}]
[null,"Estimated Total Cost",{"$f":"'CB-3 Capital Budget Proposed'!C17","v":0}]
[]
[null,"Operation #3"]
[null,"Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E23","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F23","v":0}]
[null,"Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G23","v":0}]
[null,"Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H23","v":0}]
[null,"Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I23","v":0}]
[null,"Estimated Total Cost",{"$f":"'CB-3 Capital Budget Proposed'!C23","v":0}]
[]
[null,"Operation #4"]
[null,"Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E29","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F29","v":0}]
[null,"Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G29","v":0}]
[null,"Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H29","v":0}]
[null,"Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I29","v":0}]
[null,"Estimated Total Cost",{"$f":"'CB-3 Capital Budget Proposed'!C29","v":0}]
[]
[null,"Operation #5"]
[null,"Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E35","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F35","v":0}]
[null,"Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G35","v":0}]
[null,"Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H35","v":0}]
[null,"Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I35","v":0}]
[null,"Estimated Total Cost",{"$f":"'CB-3 Capital Budget Proposed'!C35","v":0}]
[]
[null,"Operation #6"]
[null,"Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E41","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F41","v":0}]
[null,"Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G41","v":0}]
[null,"Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H41","v":0}]
[null,"Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I41","v":0}]
[null,"Estimated Total Cost",{"$f":"'CB-3 Capital Budget Proposed'!C41","v":0}]
[]
[null,"Totals - All Operations"]
[null,"Total Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E42","v":0}]
[null,"Total Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F42","v":0}]
[null,"Total Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G42","v":0}]
[null,"Total Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H42","v":0}]
[null,"Total Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I42","v":0}]
[null,"Total Proposed Capital Budget - All Operations",{"$f":"'CB-3 Capital Budget Proposed'!C42","v":0}]

{"sheet":"Mandatory Entry Checklist","index":2,"n_rows":102,"n_cols":3,"rows_kept":102,"cut":false,"hidden":true,"merged":[[91,0,91,1],[92,0,92,1],[96,0,96,1],[97,0,97,1],[77,0,77,1],[78,0,78,1],[83,0,83,1],[84,0,84,1],[87,0,87,1],[88,0,88,1],[74,0,74,1],[39,0,39,1],[40,0,40,1],[43,0,43,1],[44,0,44,1],[54,0,54,1],[55,0,55,1],[59,0,59,1],[60,0,60,1],[67,0,67,1],[68,0,68,1],[73,0,73,1],[29,0,29,1],[1,0,1,2],[2,0,2,2],[5,0,5,1],[6,0,6,1],[15,0,15,1],[16,0,16,1],[19,0,19,1],[20,0,20,1],[24,0,24,1],[25,0,25,1],[28,0,28,1]]}
[]
["BUDGET STATUS"]
[{"$f":"IF(AND(A7=\"Complete\",A17=\"Complete\",A21=\"Complete\",A26=\"Complete\",A30=\"Complete\",A41=\"Complete\",A45=\"Complete\",A56=\"Complete\",A61=\"Complete\",A69=\"Complete\",A75=\"Complete\",A79=\"Complete\",A85=\"Complete\",A89=\"Complete\",A93=\"Complete\",A98=\"Complete\"),\"COMPLETE\",\"INCOMPLETE, DO NOT SUBMIT UNTIL ALL MANDATORY FIELDS COMPLETE\")","v":"INCOMPLETE, DO NOT SUBMIT UNTIL ALL MANDATORY FIELDS COMPLETE"}]
[]
[null,null,"Formula Notes"]
["KEY INPUTS"]
[{"$f":"IF(AND(B8=\"Complete\",B9=\"Complete\",B10=\"Complete\",B11=\"Complete\",B12=\"Complete\",B13=\"Complete\",B14=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Authority Name",{"$f":"IF('KEY INPUTS'!B5=\"(Select Authority)\",\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Preparer Certification",{"$f":"IF(OR(ISBLANK('KEY INPUTS'!B10)=TRUE,ISBLANK('KEY INPUTS'!B11)=TRUE,ISBLANK('KEY INPUTS'!B12)=TRUE,ISBLANK('KEY INPUTS'!B14)=TRUE,ISBLANK('KEY INPUTS'!B16)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Approval Certification",{"$f":"IF(OR(ISBLANK('KEY INPUTS'!B19)=TRUE,ISBLANK('KEY INPUTS'!B20)=TRUE,ISBLANK('KEY INPUTS'!B21)=TRUE,ISBLANK('KEY INPUTS'!B23)=TRUE,ISBLANK('KEY INPUTS'!B25)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Internet Certification",{"$f":"IF(OR(ISBLANK('KEY INPUTS'!B28)=TRUE,ISBLANK('KEY INPUTS'!B29)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields must be completed"]
["Adoption Certification",{"$f":"IF(OR(ISBLANK('KEY INPUTS'!B32)=TRUE,ISBLANK('KEY INPUTS'!B33)=TRUE,ISBLANK('KEY INPUTS'!B34)=TRUE,ISBLANK('KEY INPUTS'!B36)=TRUE,ISBLANK('KEY INPUTS'!B38)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Capital Budget/Program Certification",{"$f":"IF(OR(ISBLANK('KEY INPUTS'!B41)=TRUE,ISBLANK('KEY INPUTS'!B42)=TRUE,ISBLANK('KEY INPUTS'!B43)=TRUE,ISBLANK('KEY INPUTS'!B45)=TRUE,ISBLANK('KEY INPUTS'!B47)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Governing Body Members",{"$f":"IF(OR(ISBLANK('KEY INPUTS'!D2)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"Must enter at least one governing body member's information"]
[]
["PREPARER CERT"]
[{"$f":"IF(B18=\"Complete\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Preparer's Signature",{"$f":"IF(OR(ISBLANK('Preparer Cert. (C-2)'!D18)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["INTERNET CERT",null,"Required new formulas on tab for checkboxes in column AD"]
[{"$f":"IF(AND(B22=\"Complete\",B23=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Certifications",{"$f":"IF(OR('Internet Cert. (C-3)'!AD11<>TRUE,'Internet Cert. (C-3)'!AD13<>TRUE,'Internet Cert. (C-3)'!AD15<>TRUE,'Internet Cert. (C-3)'!AD19<>TRUE,'Internet Cert. (C-3)'!AD22<>TRUE,'Internet Cert. (C-3)'!AD25<>TRUE,'Internet Cert. (C-3)'!AD28<>TRUE,'Internet Cert. (C-3)'!AD31<>TRUE,'Internet Cert. (C-3)'!AD34<>TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Signature",{"$f":"IF(OR(ISBLANK('Internet Cert. (C-3)'!C44)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["APPROVAL CERT"]
[{"$f":"IF(B27=\"Complete\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Officer Signature",{"$f":"IF(OR(ISBLANK('Approval Cert. (C-4)'!D17)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["APPROVAL RESOLUTION"]
[{"$f":"IF(AND(B31=\"Complete\",B32=\"Complete\",B33=\"Complete\",B34=\"Complete\",B35=\"Complete\",B36=\"Complete\",B37=\"Complete\",B38=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Secretary's Signature",{"$f":"IF(OR(ISBLANK('Approval Resolution (C-5)'!A38)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Date",{"$f":"IF(OR(ISBLANK('Approval Resolution (C-5)'!E38)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Governing Body Recorded Vote",{"$f":"IF(AND(ISBLANK('Approval Resolution (C-5)'!C43)=TRUE,ISBLANK('Approval Resolution (C-5)'!D43)=TRUE,ISBLANK('Approval Resolution (C-5)'!E43)=TRUE,ISBLANK('Approval Resolution (C-5)'!G43)=TRUE),\"Incomplete\",IF(ISBLANK('Approval Resolution (C-5)'!A43:B43)=FALSE,\"Incomplete\",\"Complete\"))","v":"Incomplete"},"At least one vote type for one member must be selected"]
["Open Public Meeting Date (month day, year)",{"$f":"IF(OR(ISBLANK('Approval Resolution (C-5)'!I9)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Total Budget Revenues",{"$f":"IF(OR(ISBLANK('Approval Resolution (C-5)'!K12)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Total Budget Appropriations",{"$f":"IF(OR(ISBLANK('Approval Resolution (C-5)'!K13)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Unrestricted Net Position Used",{"$f":"IF(OR(ISBLANK('Approval Resolution (C-5)'!K14)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Considered for Adoption Date (month day, year)",{"$f":"IF(OR(ISBLANK('Approval Resolution (C-5)'!I30)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["ADOPTION CERT"]
[{"$f":"IF(B42=\"Complete\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Officer Signature",{"$f":"IF(OR(ISBLANK('Adoption Cert. (C-6)'!D14)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["ADOPTED RESOLUTION"]
[{"$f":"IF(AND(B46=\"Complete\",B47=\"Complete\",B48=\"Complete\",B49=\"Complete\",B50=\"Complete\",B51=\"Complete\",B52=\"Complete\",B53=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Secretary's Signature",{"$f":"IF(OR(ISBLANK('Adopted Resolution (C-7)'!A31)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Date",{"$f":"IF(OR(ISBLANK('Adopted Resolution (C-7)'!E31)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Governing Body Recorded Vote",{"$f":"IF(AND(ISBLANK('Adopted Resolution (C-7)'!C36)=TRUE,ISBLANK('Adopted Resolution (C-7)'!D36)=TRUE,ISBLANK('Adopted Resolution (C-7)'!E36)=TRUE,ISBLANK('Adopted Resolution (C-7)'!G36)=TRUE),\"Incomplete\",IF(ISBLANK('Adopted Resolution (C-7)'!A36:B36)=FALSE,\"Incomplete\",\"Complete\"))","v":"Incomplete"},"At least one vote type for one member must be selected"]
["Open Public Meeting Date",{"$f":"IF(OR(ISBLANK('Adopted Resolution (C-7)'!I9)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Total Budget Revenues",{"$f":"IF(OR(ISBLANK('Adopted Resolution (C-7)'!K14)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Total Budget Appropriations",{"$f":"IF(OR(ISBLANK('Adopted Resolution (C-7)'!K15)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Total Capital Appropriations",{"$f":"IF(OR(ISBLANK('Adopted Resolution (C-7)'!K18)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Total Capital Net Position Used",{"$f":"IF(OR(ISBLANK('Adopted Resolution (C-7)'!K19)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["MESSAGE & ANALYSIS"]
[{"$f":"IF(AND(B57=\"Complete\",B58=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Question #1",{"$f":"IF(OR(ISBLANK('Message & Analysis (N-1)'!A14)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Question #2",{"$f":"IF(OR(ISBLANK('Message & Analysis (N-1)'!A32)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["CONTACT INFORMATION"]
[{"$f":"IF(AND(B62=\"Complete\",B63=\"Complete\",B64=\"Complete\",B65=\"Complete\",B66=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Name of Authority",{"$f":"IF(OR(ISBLANK('Contact Information (N-2)'!B7)=TRUE,ISBLANK('Contact Information (N-2)'!B8)=TRUE,ISBLANK('Contact Information (N-2)'!B10)=TRUE,ISBLANK('Contact Information (N-2)'!B11)=TRUE,ISBLANK('Contact Information (N-2)'!F10)=TRUE,ISBLANK('Contact Information (N-2)'!G10)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Preparer’s Name",{"$f":"IF(OR(ISBLANK('Contact Information (N-2)'!B13)=TRUE,ISBLANK('Contact Information (N-2)'!B14)=TRUE,ISBLANK('Contact Information (N-2)'!B15)=TRUE,ISBLANK('Contact Information (N-2)'!B16)=TRUE,ISBLANK('Contact Information (N-2)'!F15)=TRUE,ISBLANK('Contact Information (N-2)'!G15)=TRUE,ISBLANK('Contact Information (N-2)'!B17)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Chief Executive Officer",{"$f":"IF(OR(ISBLANK('Contact Information (N-2)'!B19)=TRUE,ISBLANK('Contact Information (N-2)'!B21)=TRUE,ISBLANK('Contact Information (N-2)'!B22)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Chief Financial Officer",{"$f":"IF(OR(ISBLANK('Contact Information (N-2)'!B24)=TRUE,ISBLANK('Contact Information (N-2)'!B26)=TRUE,ISBLANK('Contact Information (N-2)'!B27)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
["Name of Auditor",{"$f":"IF(OR(ISBLANK('Contact Information (N-2)'!B29)=TRUE,ISBLANK('Contact Information (N-2)'!B30)=TRUE,ISBLANK('Contact Information (N-2)'!B31)=TRUE,ISBLANK('Contact Information (N-2)'!B32)=TRUE,ISBLANK('Contact Information (N-2)'!B33)=TRUE,ISBLANK('Contact Information (N-2)'!F32)=TRUE,ISBLANK('Contact Information (N-2)'!G32)=TRUE,ISBLANK('Contact Information (N-2)'!B33)=TRUE,ISBLANK('Contact Information (N-2)'!B34)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"All fields except fax must be completed"]
[]
["QUESTIONNAIRE"]
[{"$f":"IF(AND(B70=\"Complete\",B71=\"Complete\",B72=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Questionnaire",{"$f":"IF(OR(ISBLANK('Questionnaire (N-3)'!C8)=TRUE,ISBLANK('Questionnaire (N-3)'!C11)=TRUE,ISBLANK('Questionnaire (N-3)'!C13)=TRUE,ISBLANK('Questionnaire (N-3)'!C15)=TRUE,ISBLANK('Questionnaire (N-3)'!C18)=TRUE,ISBLANK('Questionnaire (N-3)'!C24)=TRUE,ISBLANK('Questionnaire (N-3)'!H29)=TRUE,ISBLANK('Questionnaire (N-3)'!H30)=TRUE,ISBLANK('Questionnaire (N-3)'!H31)=TRUE,ISBLANK('Questionnaire (N-3)'!C37)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Questionnaire (2)",{"$f":"IF(OR(ISBLANK('Questionnaire (N-3)(2)'!D8)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!D12)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C16)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C17)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C18)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C19)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C20)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C21)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C22)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C23)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C24)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C30)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C35)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!C38)=TRUE,ISBLANK('Questionnaire (N-3)(2)'!D43)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Questionnaire (3)",{"$f":"IF(OR(ISBLANK('Questionnaire (N-3)(3)'!D9)=TRUE,ISBLANK('Questionnaire (N-3)(3)'!D13)=TRUE,ISBLANK('Questionnaire (N-3)(3)'!D16)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["PAGE N-4 (2 of 2)"]
[{"$f":"IF(B76=\"Complete\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Authority Schedule of Commissioners, Officers, Key Employees, Highest Compensated Employees and Independent Contractors (Continued)",{"$f":"IF(OR(ISBLANK('Page N-4 (2 of 2)'!B7)=TRUE,ISBLANK('Page N-4 (2 of 2)'!C7)=TRUE,ISBLANK('Page N-4 (2 of 2)'!D7)=TRUE,'Page N-4 (2 of 2)'!N7=0,AND('Page N-4 (2 of 2)'!E7=\"\",'Page N-4 (2 of 2)'!F7=\"\",'Page N-4 (2 of 2)'!G7=\"\",'Page N-4 (2 of 2)'!H7=\"\",'Page N-4 (2 of 2)'!I7=\"\")),\"Incomplete\",\"Complete\")","v":"Incomplete"},"Complete information for at least one employee must be entered including at least one compensation entry"]
[]
["HEALTH BENEFITS"]
[{"$f":"IF(AND(B80=\"Complete\",B81=\"Complete\",B82=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Active Employees Health Benefits",{"$f":"IF(OR(ISBLANK('Health Benefits (N-5)'!B8)=TRUE,ISBLANK('Health Benefits (N-5)'!B9)=TRUE,ISBLANK('Health Benefits (N-5)'!B10)=TRUE,ISBLANK('Health Benefits (N-5)'!B11)=TRUE,ISBLANK('Health Benefits (N-5)'!C8)=TRUE,ISBLANK('Health Benefits (N-5)'!C9)=TRUE,ISBLANK('Health Benefits (N-5)'!C10)=TRUE,ISBLANK('Health Benefits (N-5)'!C11)=TRUE,ISBLANK('Health Benefits (N-5)'!E8)=TRUE,ISBLANK('Health Benefits (N-5)'!E9)=TRUE,ISBLANK('Health Benefits (N-5)'!E10)=TRUE,ISBLANK('Health Benefits (N-5)'!E11)=TRUE,ISBLANK('Health Benefits (N-5)'!F8)=TRUE,ISBLANK('Health Benefits (N-5)'!F9)=TRUE,ISBLANK('Health Benefits (N-5)'!F10)=TRUE,ISBLANK('Health Benefits (N-5)'!F11)=TRUE,ISBLANK('Health Benefits (N-5)'!D12)=TRUE,ISBLANK('Health Benefits (N-5)'!G12)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"},"Information must be entered in each of the gray-highlighted cells"]
["Is medical coverage provided by the SHBP (Yes or No)?",{"$f":"IF(OR(ISBLANK('Health Benefits (N-5)'!D33)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Is prescription drug coverage provided by the SHBP (Yes or No)?",{"$f":"IF(OR(ISBLANK('Health Benefits (N-5)'!D34)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["ACCUMULATED ABSENCES"]
[{"$f":"IF(B86=\"Complete\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Accumulated Absences",{"$f":"IF(OR(ISBLANK('Accumulated Absences (N-6)'!A7)=TRUE,ISBLANK('Accumulated Absences (N-6)'!B7)=TRUE,ISBLANK('Accumulated Absences (N-6)'!C7)=TRUE,AND('Accumulated Absences (N-6)'!D7=\"\",'Accumulated Absences (N-6)'!E7=\"\",'Accumulated Absences (N-6)'!F7=\"\")),\"Incomplete\",\"Complete\")","v":"Incomplete"},"Complete information for at least one employee must be entered including at least one compensation entry"]
[]
["SHARED SERVICES",null,"Required new formulas on tab for checkboxes in column AD"]
[{"$f":"IF(B90=\"Complete\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Shared Service Agreements",{"$f":"IF('Shared Services (N-7)'!AD4=TRUE,\"Complete\",IF(OR(ISBLANK('Shared Services (N-7)'!A7)=TRUE,ISBLANK('Shared Services (N-7)'!B7)=TRUE,ISBLANK('Shared Services (N-7)'!C7)=TRUE,ISBLANK('Shared Services (N-7)'!E7)=TRUE,ISBLANK('Shared Services (N-7)'!F7)=TRUE,ISBLANK('Shared Services (N-7)'!G7)=TRUE),\"Incomplete\",\"Complete\"))","v":"Incomplete"},"The \"No shared services\" box must be checked or there must be complete information for at least one shared service except the comments section"]
[]
["CAPITAL BUDGET CERTIFICATION",null,"Required new formulas on tab for checkboxes in column AD"]
[{"$f":"IF(AND(B95=\"Complete\",B94=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Certification",{"$f":"IF(OR('CB-1 Capital Budget Cert.'!AD11=TRUE,'CB-1 Capital Budget Cert.'!AD15=TRUE),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Officer Signature",{"$f":"IF(OR(ISBLANK('CB-1 Capital Budget Cert.'!D22)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["CAPITAL BUDGET MESSAGE"]
[{"$f":"IF(AND(B99=\"Complete\",B100=\"Complete\",B101=\"Complete\",B102=\"Complete\"),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Question #1",{"$f":"IF(OR(ISBLANK('CB-2 Capital Budget Message'!I11)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Question #2",{"$f":"IF(OR(ISBLANK('CB-2 Capital Budget Message'!I14)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Question #3",{"$f":"IF(OR(ISBLANK('CB-2 Capital Budget Message'!I19)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Question #5",{"$f":"IF(OR(ISBLANK('CB-2 Capital Budget Message'!I28)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]

{"sheet":"Instructions","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[null,"General Instructions to Complete the Authority Budget Workbook","Authority Budget Template Version 2024.1"]
[null,null,null,null,null,null,null,null,null,null,null,"FAST"]
["a)","This workbook shall be used for completing the Authority Introduced and Adopted Budgets.",null,null,null,null,null,null,null,null,null,"Version 1.3"]
["b)","It is designed to automatically calculate amounts linked from various data entry points. "]
["c)","The individual tabs containing formulas are locked to protect the formulas. "]
["d)","Fill in only the gray and yellow highlighted sections of the worksheet. "]
["e)","Begin by navigating to the \"KEY INPUTS\" tab."]
["f)","Select the Authority by clicking  on cell B5 and selecting from the dropdown menu. This will populate the entity name and county.  Continue to complete each of the fields in order to populate standard information throughout the workbook."]
["g)","When copying information from another document, users must select \"Paste Values\" when pasting the information into this workbook. "]
["h)","In all \"signature\" cells, enter the email address of the cerifying official. "]

{"sheet":"KEY INPUTS","index":4,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[39,0,39,1],[30,0,30,1],[0,2,0,3],[7,0,7,1],[16,2,16,3],[8,0,8,1],[17,0,17,1],[26,0,26,1],[19,2,19,3]]}
["Fiscal Year Begin:",2023,"Governing Body Members",null,"Commissioner names will appear on the approval and adoption resolutions in the order they are listed on this page. "]
["Fiscal Year End:",2023,"Commissioner #1",null,null,null,{"$f":"B1","v":2023}]
["Begin Date:","2023-01-01","Commissioner #2",null,null,null,{"$f":"B1+1","v":2024}]
["End Date: ",{"$f":"EDATE(B3,12)-1","v":"2023-12-31"},"Commissioner #3"]
["Authority Name:","(Select Authority)","Commissioner #4"]
["Web Address",null,"Commissioner #5"]
[null,null,"Commissioner #6"]
["Certification Sections",null,"Commissioner #7"]
["Preparer Certification",null,"Commissioner #8",null,"Regional Authorities. "]
["Preparer Name",null,"Commissioner #9",null,"Regional Authorities. "]
["Title",null,"Commissioner #10",null,"Regional Authorities. "]
["Address",null,"Commissioner #11",null,"Regional Authorities. "]
["Address 2",null,"Commissioner #12",null,"Regional Authorities. "]
["Phone ",null,"Commissioner #13",null,"Regional Authorities. "]
["Fax",null,"Commissioner #14",null,"Regional Authorities. "]
["Email"]
[null,null,"# of Pages Needed:"]
["Approval Certification",null,"Accumulated Absences","Standard","\"Standard\" will provide 3 pages for \"Accumulated Absences\", \"Expanded\" will provide 9 pages. "]
["Officer's Name"]
["Title",null,"Authority Operations and Functions:"]
["Address",null,"Operation #1","Operation #1"]
["Address 2",null,"Operation #2","Operation #2"]
["Phone",null,"Operation #3","Operation #3"]
["Fax ",null,"Operation #4","Operation #4"]
["Email",null,"Operation #5","Operation #5"]
[null,null,"Operation #6","Operation #6"]
["Internet Certification"]
["Officer's Name"]
["Title"]
[]
["Adoption Certification"]
["Officer's Name"]
["Title"]
["Address"]
["Address 2"]
["Phone "]
["Fax"]
["Email"]
[]
["Capital Budget/Program Certification"]
["Officer's Name"]
["Title"]
["Address"]
["Address 2"]
["Phone "]
["Fax"]
["Email"]

{"sheet":"Budget Front Cover","index":5,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":true,"merged":[[7,1,7,5],[8,1,8,5],[11,1,11,3],[40,1,40,5],[17,1,17,5],[16,1,16,5]]}
[]
[]
[]
[null,null,null,null,null,"Can end in 2021"]
[null,null,null,"Start Year",null,"End Year"]
[null,"Fiscal Year",null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"_",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Authority Budget of:"]
[null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,"State Filing Year",null,2020]
[null,"For the Period:"]
[null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},"to",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Authority Web Address"]
[null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Division of Local Government Services"]

{"sheet":"Cover Sheet","index":6,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,36,5],[7,1,7,5],[8,1,8,5],[16,1,16,5],[17,1,17,5]]}
[]
[]
[]
[]
[null,null,null,"Start Year",null,"End Year"]
[null,"Fiscal Year",null,{"$f":"'KEY INPUTS'!B1","v":2023},"_",{"$f":"YEAR('KEY INPUTS'!B4)","v":2023}]
[]
[null,"Authority Budget of:"]
[null,{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[null,"State Filing Year",null,{"$f":"'KEY INPUTS'!B2","v":2023}]
[]
[null,"For the Period:",null,{"$f":"'KEY INPUTS'!B3","v":"2023-01-01"},"to",{"$f":"'KEY INPUTS'!B4","v":"2023-12-31"}]
[]
[]
[]
[null,{"$f":"'KEY INPUTS'!B6","v":0}]
[null,"Authority Web Address"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Division of Local Government Services"]

{"sheet":"Certification Section","index":7,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,5],[13,0,13,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY BUDGET\"","v":"2023 AUTHORITY BUDGET"}]
["CERTIFICATION SECTION"]

{"sheet":"Division Cert. (C-1)","index":8,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,0,8,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[6,0,6,8],[22,0,22,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[21,0,21,8],[29,0,29,8],[30,0,30,8],[31,0,31,8],[38,0,38,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[27,0,27,8],[28,0,28,8]]}
[{"$f":"\"FISCAL YEAR \"&'KEY INPUTS'!B2&\"\"","v":"FISCAL YEAR 2023"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
["AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["For Division Use Only"]
[]
["CERTIFICATION OF APPROVED BUDGET"]
[]
["It is hereby certified that the approved Budget made a part hereof complies with the requirements of"]
["law and the rules and regulations of the Local Finance Board, and approval is given pursuant to"]
["N.J.S.A. 40A:5A-11."]
["State of New Jersey"]
["Department of Community Affairs"]
["Director of the Division of Local Government Services"]
[]
["By:                                                                                     Date:                              "]
[]
["CERTIFICATION OF ADOPTED BUDGET"]
[]
["It is hereby certified that the adopted Budget made a part hereof has been compared with the approved"]
["Budget previously certified by the Division, and any amendments made thereto.  This adopted Budget is"]
["certified with respect to such amendments and comparisons only. "]
[]
["State of New Jersey"]
["Department of Community Affairs"]
["Director of the Division of Local Government Services"]
[]
["By:                                                                                     Date:                              "]
[]
[]
[]
[]
[]
[]
["Page C-1"]

{"sheet":"Preparer Cert. (C-2)","index":9,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[9,0,9,9],[0,0,0,9],[2,0,2,9],[4,0,4,9],[6,0,6,9],[8,0,8,9],[19,1,19,2],[19,3,19,5],[10,0,10,9],[11,0,11,9],[12,0,12,8],[13,0,13,9],[14,0,14,9],[15,0,15,9],[16,0,16,8],[17,1,17,2],[17,3,17,5],[18,1,18,2],[18,3,18,5],[39,0,39,9],[21,3,21,5],[20,1,21,2],[24,1,24,2],[24,3,24,5],[20,3,20,5],[22,1,22,2],[22,3,22,5],[23,1,23,2],[23,3,23,5]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" PREPARER'S CERTIFICATION\"","v":"2023 PREPARER'S CERTIFICATION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
["AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["     It is hereby certified that the Authority Budget, including the Annual Budget and the Capital Budget/Program "]
["annexed hereto, represents the members of the governing body's resolve with respect to statute in that; all estimates of"]
["revenue are reasonable, accurate and correctly stated; all items of appropriation are properly set forth; and in itemization,"]
["form, and content, the budget will permit the exercise of the comptroller function within the Authority. "]
[]
["     It is further certified that all proposed budgeted amounts and totals are correct.  Also, I hereby provide reasonable"]
["assurance that all assertations contained herein are accurate and all required schedules are completed and attached."]
[]
[]
[null,"Preparer's Signature:"]
[null,"Name: ",null,{"$f":"'KEY INPUTS'!B10","v":0}]
[null,"Title:",null,{"$f":"'KEY INPUTS'!B11","v":0}]
[null,"Address:",null,{"$f":"'KEY INPUTS'!B12","v":0}]
[null,null,null,{"$f":"'KEY INPUTS'!B13","v":0}]
[null,"Phone Number:",null,{"$f":"'KEY INPUTS'!B14","v":0}]
[null,"Fax Number:",null,{"$f":"'KEY INPUTS'!B15","v":0}]
[null,"E-mail Address:",null,{"$f":"'KEY INPUTS'!B16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page C-2"]

{"sheet":"Internet Cert. (C-3)","index":10,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[15,1,15,5],[16,1,16,5],[8,1,8,5],[9,1,9,5],[10,1,10,2],[12,1,12,5],[14,1,14,5],[0,1,0,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[34,1,34,5],[17,1,17,5],[18,1,18,5],[21,1,21,5],[22,1,22,5],[24,1,24,5],[25,1,25,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,5],[33,1,33,5],[35,1,35,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[45,1,45,5]]}
[null,"AUTHORITY INTERNET WEBSITE CERTIFICATION"]
[]
[null,"Authority’s Web Address:",{"$f":"'KEY INPUTS'!B6","v":0}]
[]
[null,"       All authorities shall maintain either an Internet website or a webpage on the municipality's or county's Internet website."]
[null,"The purpose of the website or webpage shall be to provide increased public access to the authority's operations and"]
[null,"activities.  N.J.S.A. 40A:5A-17.1 requires the following items to be included on the Authority's website at a "]
[null,"minimum for public disclosure.  Check the boxes below to certify the Authority's compliance with N.J.S.A. "]
[null,"40A:5A-17.1."]
[]
[null,"A description of the Authority's mission and responsibilities.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"The budgets for the current fiscal year and immediately preceding two prior years.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"The most recent Comprehensive Annual Financial Report (Unaudited) or similar financial information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,"(Similar information includes items such as Revenue and Expenditure pie charts, or other types of charts, along with"]
[null,"other information that would be useful to the public in understanding the finances/budget of the Authority)."]
[]
[null,"The complete (all pages) annual audits (not the Audit Synopsis) for the most recent fiscal year and immediately preceding ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,"two prior years."]
[]
[null,"The Authority’s rules, regulations and official policy statements deemed relevant by the governing body of the Authority ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"to the interests of the residents within the Authority's service area or jurisdiction."]
[]
[null,"Notice posted pursuant to the \"Open Public Meetings Act\" for each meeting of the Authority, setting forth the time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"date, location and agenda of each meeting."]
[]
[null,"The approved minutes of each meeting of the Authority including all resolutions of the board and their committees; for at",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"least three consecutive fiscal years."]
[]
[null,"The name, mailing address, electronic mail address and phone number of every person who exercises day-to-day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"supervision or management over some or all of the operations of the Authority."]
[]
[null,"A list of attorneys, advisors, consultants and any other person, firm, business, partnership, corporation or",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"other organization which received any renumeration of $17,500 or more during the preceding fiscal year"]
[null,"for any service whatsoever rendered to the Authority. "]
[]
[null,"       It is hereby certified by the below authorized representative of the Authority that the Authority's website or "]
[null,"webpage as identified above complies with the minimum statutory requirements of N.J.S.A. 40A:5A-17.1 as listed"]
[null,"above.  A check in each of the above boxes signifies compliance. "]
[]
[null,"Name of Officer Certifying Compliance:",{"$f":"'KEY INPUTS'!B28","v":0}]
[null,"Title of Officer Certifying Compliance: ",{"$f":"'KEY INPUTS'!B29","v":0}]
[null,"Signature:"]
[]
[null,"Page C-3"]

{"sheet":"Approval Cert. (C-4)","index":11,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,1,16,2],[16,3,16,5],[0,0,0,8],[2,0,2,8],[4,0,4,8],[6,0,6,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[20,3,20,5],[19,1,20,2],[17,1,17,2],[17,3,17,5],[18,1,18,2],[18,3,18,5],[19,3,19,5],[38,0,38,8],[21,1,21,2],[21,3,21,5],[22,1,22,2],[22,3,22,5],[23,1,23,2],[23,3,23,5]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" APPROVAL CERTIFICATION\"","v":"2023 APPROVAL CERTIFICATION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
["AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["       It is hereby certified that the Authority Budget, including all schedules appended hereto, are a true "]
["copy of the Annual Budget and Capital Budget/Program approved by resolution by the governing body of the"]
[{"$f":"\"\"&'KEY INPUTS'!B5&\", at an open public meeting held pursuant to N.J.A.C. 5:31-2.3,\"","v":"(Select Authority), at an open public meeting held pursuant to N.J.A.C. 5:31-2.3,"}]
[{"$f":"\"on \"&IF('Approval Resolution (C-5)'!I9=\"\",\"\",TEXT('Approval Resolution (C-5)'!I9,\"mmmm d, yyyy\"))&\".\"","v":"on ."}]
[]
["       It is further certified that the recorded vote appearing in the resolution represents not less than a majority "]
["of the full membership of the governing body thereof. "]
[]
[null,"Officer's Signature:"]
[null,"Name: ",null,{"$f":"'KEY INPUTS'!B19","v":0}]
[null,"Title:",null,{"$f":"'KEY INPUTS'!B20","v":0}]
[null,"Address:",null,{"$f":"'KEY INPUTS'!B21","v":0}]
[null,null,null,{"$f":"'KEY INPUTS'!B22","v":0}]
[null,"Phone Number:",null,{"$f":"'KEY INPUTS'!B23","v":0}]
[null,"Fax Number:",null,{"$f":"'KEY INPUTS'!B24","v":0}]
[null,"E-mail Address:",null,{"$f":"'KEY INPUTS'!B25","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page C-4"]

{"sheet":"Approval Resolution (C-5)","index":12,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[6,0,6,6],[7,0,7,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[7,8,7,10],[8,0,8,6],[9,0,9,6],[22,0,22,6],[24,0,24,6],[19,0,19,6],[20,0,20,6],[21,0,21,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[17,0,17,6],[18,0,18,6],[36,0,36,6],[41,0,41,1],[41,4,41,5],[26,0,26,6],[28,8,28,10],[35,0,35,6],[29,8,29,10],[32,0,32,6],[33,0,33,6],[34,0,34,6],[29,0,29,6],[30,0,30,6],[31,0,31,6],[27,0,27,6],[28,0,28,6],[47,0,47,1],[47,4,47,5],[48,0,48,1],[48,4,48,5],[37,0,37,2],[37,4,37,5],[42,0,42,1],[42,4,42,5],[46,0,46,1],[46,4,46,5],[43,0,43,1],[43,4,43,5],[44,0,44,1],[44,4,44,5],[45,0,45,1],[45,4,45,5],[52,4,52,5],[51,4,51,5],[50,4,50,5],[49,4,49,5],[53,0,53,1],[52,0,52,1],[51,0,51,1],[50,0,50,1],[49,0,49,1],[54,0,54,1],[54,4,54,5],[55,0,55,1],[55,4,55,5],[53,4,53,5]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY BUDGET RESOLUTION\"","v":"2023 AUTHORITY BUDGET RESOLUTION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
[{"$f":"\"WHEREAS, the Annual Budget for \"&A3&\" for the fiscal year beginning \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\"\"","v":"WHEREAS, the Annual Budget for (Select Authority) for the fiscal year beginning January 01, 2023"},null,null,null,null,null,null,null,"Use these fields to enter information into the resolution:"]
[{"$f":"\"and ending \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\" has been presented before the governing body of the \"&'KEY INPUTS'!B5&\"\"","v":"and ending December 31, 2023 has been presented before the governing body of the (Select Authority)"},null,null,null,null,null,null,null,"Open Public Meeting Date (month day, year):",null,null,"Enter date in cell I9 using mm/dd/yyyy format. "]
[{"$f":"\"at its open public meeting of \"&IF(I9=\"\",\"\",(TEXT(I9,\"mmmm d, yyyy\")))&\"; and\"","v":"at its open public meeting of ; and"}]
[]
[{"$f":"\"WHEREAS, the Annual Budget as introduced reflects Total Revenues of \"&TEXT(K12, \"$#,##0.00\")&\", Total Appropriations including any\"","v":"WHEREAS, the Annual Budget as introduced reflects Total Revenues of $0.00, Total Appropriations including any"}]
[{"$f":"\"Accumulated Deficit, if any, of \"&TEXT(K13, \"$#,##0.00\")&\", and Total Unrestriced Net Position planned to be utilized\"","v":"Accumulated Deficit, if any, of $0.00, and Total Unrestriced Net Position planned to be utilized"},null,null,null,null,null,null,null,"Total Budget Revenues:"]
[{"$f":"\"as funding thereof, of \"&TEXT(K14, \"$#,##0.00\")&\"; and\"","v":"as funding thereof, of $0.00; and"},null,null,null,null,null,null,null,"Total Budget Appropriations:"]
[null,null,null,null,null,null,null,null,"Unrestricted Net Position Used:"]
[{"$f":"\"WHEREAS, the Capital Budget as introduced reflects Total Capital Appropriations of \"&TEXT(K16,\"$#,##0.00\")&\" and Total Unrestricted\"","v":"WHEREAS, the Capital Budget as introduced reflects Total Capital Appropriations of $0.00 and Total Unrestricted"}]
[{"$f":"\"Net Position planned to be utilized as funding thereof, of \"&TEXT(K17, \"$#,##0.00\")&\"; and\"","v":"Net Position planned to be utilized as funding thereof, of $0.00; and"},null,null,null,null,null,null,null,"Total Capital Appropriations:"]
[null,null,null,null,null,null,null,null,"Total Capital Net Position Used:"]
["WHEREAS, the schedule of rents, fees and other charges in effect will produce sufficient revenues, together with all other anticipated"]
["revenues to satisfy all obligations to the holders of bonds of the Authority, to meet operating expenses, capital outlays, debt service"]
["requirements, and to provide for such reserves, all as may be required by law, regulation or terms of contracts and agreements; and"]
[]
["WHEREAS, the Capital Budget/Program, pursuant to N.J.A.C. 5:31-2, does not confer any authorization to raise or expend funds; rather"]
["it is a document to be used as part of the said Authority's planning and management objectives.  Specific authorization to expend funds"]
["for the purposes described in this section of the budget must be granted elsewhere; by bond resolution, by a project financing "]
["agreement, by resolution appropriating funds from the Renewal and Replacement Reserve or other means provided by law. "]
[]
[{"$f":"\"NOW, THEREFORE BE IT RESOLVED, by the governing body of the \"&'KEY INPUTS'!B5&\", at an open public\"","v":"NOW, THEREFORE BE IT RESOLVED, by the governing body of the (Select Authority), at an open public"}]
[{"$f":"\"meeting held on \"&((TEXT(I9,\"mmmm d, yyyy\"))&\" that the Annual Budget, including all related schedules, and the Capital Budget/Program of the\")","v":"meeting held on January 0, 1900 that the Annual Budget, including all related schedules, and the Capital Budget/Program of the"}]
[{"$f":"\"\"&'KEY INPUTS'!B5&\" for the fiscal year beginning \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" and ending \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\", is hereby approved; and\"","v":"(Select Authority) for the fiscal year beginning January 01, 2023 and ending December 31, 2023, is hereby approved; and"},null,null,null,null,null,null,null,"Considered for Adoption Date (month day, year):"]
[]
["BE IT FURTHER RESOLVED, that the anticipated revenues as reflected in the Annual Budget are of sufficient amount to "]
["meet all proposed expenditures/expenses and all covenants, terms and provisions as stipulated in the said Authority's"]
["outstanding debt obligations, capital lease arrangements, service contracts, and other pledged agreements; and"]
[]
[{"$f":"\"BE IT FURTHER RESOLVED, that the governing body of the \"&'KEY INPUTS'!B5&\" will consider the Annual\"","v":"BE IT FURTHER RESOLVED, that the governing body of the (Select Authority) will consider the Annual"}]
[{"$f":"\"Budget and Capital Budget/Program for Adoption on \"&TEXT(I30, \"mmmm dd, yyyy\")&\".\"","v":"Budget and Capital Budget/Program for Adoption on January 00, 1900."}]
[]
[]
["(Secretary’s Signature)                                                                                          ",null,null,null,"(Date)"]
[]
["Governing Body Recorded Vote"]
["Member",null,"Aye","Nay","Abstain",null,"Absent"]
[{"$f":"'KEY INPUTS'!D2","v":0}]
[{"$f":"'KEY INPUTS'!D3","v":0}]
[{"$f":"'KEY INPUTS'!D4","v":0}]
[{"$f":"'KEY INPUTS'!D5","v":0}]
[{"$f":"'KEY INPUTS'!D6","v":0}]
[{"$f":"'KEY INPUTS'!D7","v":0}]
[{"$f":"'KEY INPUTS'!D8","v":0}]
[{"$f":"'KEY INPUTS'!D9","v":0}]
[{"$f":"'KEY INPUTS'!D10","v":0}]
[{"$f":"'KEY INPUTS'!D11","v":0}]
[{"$f":"'KEY INPUTS'!D12","v":0}]
[{"$f":"'KEY INPUTS'!D13","v":0}]
[{"$f":"'KEY INPUTS'!D14","v":0}]
[{"$f":"'KEY INPUTS'!D15","v":0}]

{"sheet":"Adoption Cert. (C-6)","index":13,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,1,14,2],[14,3,14,6],[0,0,0,7],[1,0,1,6],[2,0,2,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[8,0,8,7],[9,0,9,7],[10,0,10,7],[13,1,13,2],[13,3,13,6],[15,1,15,2],[15,3,15,6],[16,3,16,6],[18,1,18,2],[18,4,18,5],[40,0,40,7],[16,1,17,2],[17,3,17,6],[19,1,19,2],[19,3,19,6]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" ADOPTION CERTIFICATION\"","v":"2023 ADOPTION CERTIFICATION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
["AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["       It is hereby certified that the Authority Budget and Capital Budget/Program annexed hereto is a true copy of"]
[{"$f":"\"the Budget adopted by the governing body of the \"&'KEY INPUTS'!B5&\", pursuant to N.J.A.C 5:31-2.3,\"","v":"the Budget adopted by the governing body of the (Select Authority), pursuant to N.J.A.C 5:31-2.3,"}]
[{"$f":"\"on \"&TEXT('Adopted Resolution (C-7)'!I9, \"mmmm dd, yyyy\")&\".\"","v":"on January 00, 1900."}]
[]
[]
[null,"Officer’s Signature:"]
[null,"Name:",null,{"$f":"'KEY INPUTS'!B32","v":0}]
[null,"Title:",null,{"$f":"'KEY INPUTS'!B33","v":0}]
[null,"Address:",null,{"$f":"'KEY INPUTS'!B34","v":0}]
[null,null,null,{"$f":"'KEY INPUTS'!B35","v":0}]
[null,"Phone Number:",null,{"$f":"'KEY INPUTS'!B36","v":0},"Fax:",null,{"$f":"'KEY INPUTS'!B37","v":0}]
[null,"E-mail address:",null,{"$f":"'KEY INPUTS'!B38","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page C-6"]

{"sheet":"Adopted Resolution (C-7)","index":14,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[6,0,6,6],[13,10,13,11],[17,10,17,11],[18,10,18,11],[16,0,16,6],[7,8,7,11],[8,0,8,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[7,0,7,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[27,0,27,6],[14,10,14,11],[19,0,19,6],[15,10,15,11],[20,0,20,6],[21,0,21,6],[22,0,22,6],[23,0,23,6],[24,0,24,6],[25,0,25,6],[26,0,26,6],[17,0,17,6],[18,0,18,6],[28,0,28,6],[30,0,30,2],[30,4,30,5],[34,0,34,1],[34,4,34,5],[35,0,35,1],[35,4,35,5],[36,0,36,1],[36,4,36,5],[49,0,49,6],[43,0,43,1],[43,4,43,5],[44,0,44,1],[44,4,44,5],[46,0,46,1],[46,4,46,5],[45,4,45,5],[42,4,42,5],[41,4,41,5],[40,4,40,5],[39,4,39,5],[37,4,37,5],[45,0,45,1],[42,0,42,1],[41,0,41,1],[40,0,40,1],[39,0,39,1],[38,0,38,1],[37,0,37,1],[48,0,48,1],[48,4,48,5],[47,0,47,1],[47,4,47,5],[38,4,38,5]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" ADOPTED BUDGET RESOLUTION\"","v":"2023 ADOPTED BUDGET RESOLUTION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"},null,null,null,null,null,null,null,"Use these fields to enter information into the resolution:"]
[]
[{"$f":"\"WHEREAS, the Annual Budget and Capital Budget/Program  for the \"&A3&\" for the fiscal year\"","v":"WHEREAS, the Annual Budget and Capital Budget/Program  for the (Select Authority) for the fiscal year"}]
[{"$f":"\"beginning \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" and ending \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\" has been presented for adoption before the governing body of the\"","v":"beginning January 01, 2023 and ending December 31, 2023 has been presented for adoption before the governing body of the"},null,null,null,null,null,null,null,"Open Public Meeting Date (month day, year):",null,null,null,"Enter date in cell I9 using mm/dd/yyyy"]
[{"$f":"\"\"&'KEY INPUTS'!B5&\" at its open public meeting of \"&TEXT(I9, \"mmmm d, yyyy\")&\"; and\"","v":"(Select Authority) at its open public meeting of January 0, 1900; and"},null,null,null,null,null,null,null,null,null,null,null,"format. "]
[]
["WHEREAS, the Annual Budget and Capital Budget as presented for adoption reflects each item of revenue and appropriation in the"]
["same amount and title as set forth in the introduced and approved budget, including all amendments thereto, if any, which have been"]
["approved by the Director of the Division of Local Government Services; and"]
[null,null,null,null,null,null,null,null,"Total Budget Revenues:"]
[{"$f":"\"WHEREAS, the Annual Budget presented for adoption reflects Total Revenues of \"&TEXT(K14, \"$#,##0.00\")&\", Total Appropriations, including any\"","v":"WHEREAS, the Annual Budget presented for adoption reflects Total Revenues of $0.00, Total Appropriations, including any"},null,null,null,null,null,null,null,"Total Budget Appropriations:"]
[{"$f":"\"Accumulated Deficit, if any, of \"&TEXT(K15, \"$#,##0.00\")&\", and Total Unrestricted Net Position utilized of \"&TEXT(K16, \"$#,##0.00\")&\"; and\"","v":"Accumulated Deficit, if any, of $0.00, and Total Unrestricted Net Position utilized of $0.00; and"},null,null,null,null,null,null,null,"Unrestricted Net Position Used:"]
[]
[{"$f":"\"WHEREAS, the Capital Budget as presented for adoption reflect Total Capital Appropriations of \"&TEXT(K18,\"$#,##0.00\")&\" and Total\"","v":"WHEREAS, the Capital Budget as presented for adoption reflect Total Capital Appropriations of $0.00 and Total"},null,null,null,null,null,null,null,"Total Capital Appropriations:"]
[{"$f":"\"Unrestriced Net Position Utilized of \"&TEXT(K19, \"$#,##0.00\")&\"; and\"","v":"Unrestriced Net Position Utilized of $0.00; and"},null,null,null,null,null,null,null,"Total Capital Net Position Used:"]
[]
[{"$f":"\"NOW, THEREFORE BE IT RESOLVED, by the governing body of the \"&'KEY INPUTS'!B5&\" at an open public\"","v":"NOW, THEREFORE BE IT RESOLVED, by the governing body of the (Select Authority) at an open public"}]
[{"$f":"\"meeting held on \"&IF(I9=\"\",\"\",TEXT(I9,\"mmmm d, yyyy\"))&\" that the Annual Budget and Capital Budget/Program of the \"&'KEY INPUTS'!B5&\"\"","v":"meeting held on  that the Annual Budget and Capital Budget/Program of the (Select Authority)"}]
[{"$f":"\"for the fiscal year beginning \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" and ending \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\" is hereby adopted and shall constitute appropriations \"","v":"for the fiscal year beginning January 01, 2023 and ending December 31, 2023 is hereby adopted and shall constitute appropriations "}]
["for the purposes stated; and"]
[]
["BE IT FURTHER RESOLVED, that the Annual Budget and Capital Budget/Program as presented for adoption reflects each item of "]
["revenue and appropriation in the same amount and title as set forth in the introduced and approved budget, including all amendments"]
["thereto, if any, which have been approved by the Director of the Division of Local Government Services. "]
[]
[]
[]
["(Secretary’s Signature)                                                                                         ",null,null,null,"(Date) "]
[]
["Governing Body Recorded Vote"]
["Member",null,"Aye","Nay","Abstain",null,"Absent"]
[{"$f":"'KEY INPUTS'!D2","v":0}]
[{"$f":"'KEY INPUTS'!D3","v":0}]
[{"$f":"'KEY INPUTS'!D4","v":0}]
[{"$f":"'KEY INPUTS'!D5","v":0}]
[{"$f":"'KEY INPUTS'!D6","v":0}]
[{"$f":"'KEY INPUTS'!D7","v":0}]
[{"$f":"'KEY INPUTS'!D8","v":0}]
[{"$f":"'KEY INPUTS'!D9","v":0}]
[{"$f":"'KEY INPUTS'!D10","v":0}]
[{"$f":"'KEY INPUTS'!D11","v":0}]
[{"$f":"'KEY INPUTS'!D12","v":0}]
[{"$f":"'KEY INPUTS'!D13","v":0}]
[{"$f":"'KEY INPUTS'!D14","v":0}]
[{"$f":"'KEY INPUTS'!D15","v":0}]
["Page C-7"]

{"sheet":"Narrative and Information","index":15,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,5],[13,0,13,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY BUDGET\"","v":"2023 AUTHORITY BUDGET"}]
["NARRATIVE AND INFORMATION SECTION"]

{"sheet":"Message & Analysis (N-1)","index":16,"n_rows":50,"n_cols":1,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[6,0,6,10]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY BUDGET MESSAGE & ANALYSIS\"","v":"2023 AUTHORITY BUDGET MESSAGE & ANALYSIS"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["Answer all questions below using the space provided. Do not attach answers as a separate document. "]
[]
[{"$f":"\"1. Complete a brief statement on the Fiscal Year \"&'KEY INPUTS'!B2&\" proposed Annual Budget and make comparison to the Fiscal Year \"&'KEY INPUTS'!B2-1&\" adopted\"","v":"1. Complete a brief statement on the Fiscal Year 2023 proposed Annual Budget and make comparison to the Fiscal Year 2022 adopted"}]
["budget for each Revenues and Appropriations.  Explain any variances over +/-10% (as shown on budget pages F-2 and F-4) for each "]
["individual revenue and appropriation line item.  Explanations of variances should include a description of the reason for the increase"]
["or decrease in the budgeted line item, not just an indication of the amount and percent of change.  Upload any supporting documentation"]
["that will help explain the reason for the increase or decrease in the budgeted line item. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2. Describe the state of the local/regional economy and how it may impact the proposed Annual Budget, including the planned "]
["Capital Program."]
[]
[]
[]
[]
[]
[]
[]
["3. Describe the reasons for utilizing Unrestricted Net Position in the proposed Annual Budget (i.e. rate stabilization, debt service "]
["reduction, to balance the budget, etc.) If the Authority's budget anticipated a use of Unrestricted Net Position, this question must be "]
["answered. "]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-1"]

{"sheet":"Message & Analysis (N-1)(2)","index":17,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,0,47,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[6,0,6,10]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY BUDGET MESSAGE & ANALYSIS\"","v":"2023 AUTHORITY BUDGET MESSAGE & ANALYSIS"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["Answer all questions below using the space provided. Do not attach answers as a separate document. "]
[]
["4. Identify any sources of funds transferred to the County/Municipality as a budget subsidy or shared service payments, pilot"]
["payments, or other types of contracts or agreements. (Example - To provide police services to the Authority, etc. and explain the "]
["reason for the transfer (i.e. to balance the County/Municipal Budget, etc.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"5. The proposed budget must not reflect an anticipated deficit from \"&'KEY INPUTS'!B2-1&\" operations.  If there exists an accumulated deficit from\"","v":"5. The proposed budget must not reflect an anticipated deficit from 2022 operations.  If there exists an accumulated deficit from"}]
["prior year's budgets (and funding is included in the proposed budget as a result of a prior year deficit) explain the funding plan to "]
["eliminate said deficit (N.J.S.A. 40A:5A-12).  If the Authority has a net deficit reported in its most recent audit, it must provide a deficit"]
["reduction plan in response to this question. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(Prepare a response to deficits in most recent audit report pertaining to Deficits to Unrestricted Net Position caused by recording"]
["Pension and Post-Employment Benefits liabilities as required by GASB 68 and GASB 75) and similar types of deficits in the audit"]
["report. How would these deficits be funded?"]
[]
["Page N-1 (2)"]

{"sheet":"Message & Analysis (N-1)(3)","index":18,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,0,47,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[6,0,6,10]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY BUDGET MESSAGE & ANALYSIS\"","v":"2023 AUTHORITY BUDGET MESSAGE & ANALYSIS"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["Answer all questions below using the space provided. Do not attach answers as a separate document. "]
[]
[]
["6. Attach a schedule of the Authority's existing rate structure (connection fees, parking fees, service charges, etc.) if it has been changed"]
["since the prior year budget submission and a schedule of the proposed rate structure for the upcoming fiscal year. Explain any proposed "]
["changes in the rate structure and attach the resolution approving the change in rate structure, if applicable.  (If no changes to fees or "]
["rates, indicate answer as \"Rates Are Staying The Same\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-1 (3)"]

{"sheet":"Contact Information (N-2)","index":19,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,1,9,4],[0,0,0,6],[1,0,1,6],[3,0,3,6],[5,1,5,6],[7,1,7,6],[6,1,6,6],[7,0,8,0],[8,1,8,6],[17,0,17,6],[10,1,10,2],[10,3,10,4],[10,5,10,6],[11,0,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,4],[15,1,15,2],[15,3,15,4],[15,5,15,6],[16,1,16,6],[27,1,27,6],[18,1,18,6],[20,1,20,2],[20,3,20,4],[20,5,20,6],[21,1,21,6],[22,0,22,6],[23,1,23,6],[25,1,25,2],[25,3,25,4],[25,5,25,6],[26,1,26,6],[33,1,33,6],[42,0,42,6],[44,0,44,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[31,1,31,4],[32,1,32,2],[32,3,32,4],[32,5,32,6]]}
["AUTHORITY CONTACT INFORMATION"]
[{"$f":"\"FISCAL YEAR \"&'KEY INPUTS'!B2&\"\"","v":"FISCAL YEAR 2023"}]
[]
["Please complete the following information regarding this Authority. All information requested below must be completed."]
[]
["Name of Authority:",{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
["Federal ID Number:"]
["Address:"]
[]
["City, State, Zip:"]
["Phone: (ext.)",null,null,"Fax:"]
[]
["Preparer’s Name:"]
["Preparer's Address: "]
["City, State, Zip:"]
["Phone: (ext.)",null,null,"Fax:"]
["E-mail:"]
[]
["Chief Executive Officer*",0]
["*Or person who performs these functions under another title. "]
["Phone: (ext.)",null,null,"Fax:"]
["E-mail:"]
[]
["Chief Financial Officer*"]
["*Or person who performs these functions under another title. "]
["Phone: (ext.)",null,null,"Fax:"]
["E-mail:"]
[]
["Name of Auditor:"]
["Name of Firm:"]
["Address:"]
["City, State, Zip:"]
["Phone: (ext.)",null,null,"Fax:"]
["E-mail:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-2"]

{"sheet":"Questionnaire (N-3)","index":20,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,0,47,10],[0,0,0,8],[2,0,2,8],[3,0,3,5],[4,0,4,8],[10,2,10,5]]}
["AUTHORITY INFORMATIONAL QUESTIONNAIRE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["1. Provide the number of individuals employed as reported on the Authority's most  "]
["recent Form W-3, Transmittal of Wage, and Tax Statement: "]
[]
["2. Provide the amount of total salaries and wages reported on the Authority's most"]
["recent Form W-3, Transmittal of Wage, and Tax Statements:"]
[]
["3. Provide the number of regular voting members of the governing body:",null,null,null,null,"(5 or 7 per State statute, possibly"]
[null,null,null,null,null,"more for regional authorities)"]
["4. Provide the number of alternate voting members of the governing body:",null,null,null,null,"(Maximum is 2)"]
[]
["5. Regional Authorities Only - Did all individuals that were required to file a Financial Disclosure Statement for the current fiscal year"]
["because of their relationship with the Authority file the form as required?"]
["Check to see if individuals filed their FDS on the FDS webpage: https://www.nj.gov/dca/divisions/dlgs/resources/fds.html. "]
["If \"no\", provide a list of those individuals who failed to file a Financial Disclosure Statement and an explanation as to the reason for "]
["their failure to file. "]
[]
["6. Does the Authority have any amounts receivable from current or former commissioners, officers, key employees, or the highest "]
["compensated employee?"]
["If \"yes\", provide a list of those individuals, their position, the amount receivable, and a description of the amount due to the Authority. "]
[]
["7. Was the Authority a party to a business transaction with one of the following parties:"]
["a. A current or former commissioner, officer, key employee, or highest compensated employee?"]
["b. A family member of a current or former commissioner, officer, key employee, or highest compensated employee?"]
["c. An entity of which a current of former commissioner, officer, key employee, or highest compensated employee"]
["(or family member thereof) was an officer or direct or indirect owner? "]
["If the answer to any of the above is \"yes\", provide a description of the transaction including the name of the commissioner, officer,"]
["key employee, or highest compensated employee (or family member thereof) of the Authority; the name of the entity and relationship"]
["to the individual or family member; the amount paid; and whether the transaction was subject to a competitive bid process. "]
[]
["8. Did the Authority during the most recent fiscal year pay premiums, directly "]
["or indirectly, on a personal benefit contract*?  "]
["*A personal benefit contract is generally any life insurance, annuity, or endowment contract that benefits, directly or indirectly,"]
["the transferor, a member of the transferor's family, or any other person designated by the transferor. "]
["If \"yes\", provide a description of the arrangement, the premiums paid, and indicate the beneficiary of the contract. "]
[]
["9. Explain the Authority's process for determining compensation for all persons listed on Page N-4.  Include whether the Authority's"]
["process includes any of the following: 1) review and approval by the commissioners or a committee thereof; 2) study or survey of"]
["compensation data for comparable positions in similarly sized entities; 3) annual or periodic performance evaluation; 4) independent"]
["compensation consultant; and/or 5) written employment contract. Attach a narrative of your Authority's procedures for all"]
["individuals listed on Page N-4 (2 of 2)."]
[]
["Page N-3"]

{"sheet":"Questionnaire (N-3)(2)","index":21,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,4],[0,0,0,4],[1,0,1,4],[2,0,2,2],[3,0,3,4],[5,0,5,4]]}
["AUTHORITY INFORMATIONAL QUESTIONNAIRE"]
["(CONTINUED)"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["10. Did the Authority pay for meals or catering during the current fiscal year?"]
["If \"yes\", provide a detailed list of all meals and/or catering invoices for the current fiscal year"]
["and provide an explanation for each expenditure listed. "]
[]
["11. Did the Authority pay for travel expenses for any employee of individual listed on Page N-4? "]
["If \"yes\", provide a detailed list of all travel expenses for the current fiscal year and provide an explanation for each expenditure listed. "]
[]
["12. Did the Authority provide any of the following to or for a person listed on Page N-4 or any other employee of the Authority?"]
["a. First class or charter travel"]
["b. Travel for companions"]
["c. Tax indemnification and gross-up payments"]
["d. Discretionary spending account"]
["e. Housing allowance or residence for personal use"]
["f. Payments for business use of personal residence"]
["g. Vehicle/auto allowance or vehicle for personal use"]
["h. Health or social club dues or initiation fees"]
["i. Personal services (i.e. maid, chauffeur, chef)"]
["If the answer to any of the above is \"yes\", provide a description of the transaction including the name and position of the individual "]
["and the amount expended. "]
[]
["13. Did the Authority follow a written policy regarding payment or reimbursement for expenses incurred by employees"]
["and/or commissioners during the course of Authority business and does that policy require substantiation"]
["of expenses through receipts or invoices prior to reimbursement?"]
["If \"no\", attach an explanation of the Authority's process for reimbursing employees and commissioners for expenses.  "]
["(If your authority does not allow for reimbursements, indicate that in answer)."]
[]
["14. Did the Authority make any payments to current or former commissioners or employees for severance or termination?"]
["If \"yes\", provide explanation, including amount paid. "]
[]
["15. Did the Authority make payments to current or former commissioners or employees that were contingent upon"]
["the performance of the Authority or that were considered discretionary bonuses? "]
["If \"yes\", provide explanation including amount paid. "]
[]
["16. Did the Authority receive any notices from the Department of Environmental Protection or any other"]
["entity regarding maintenance or repairs required to the Authority's systems to bring them into compliance"]
["with current regulations and standards that it has not yet taken action to remediate?"]
["If \"yes\", provide explanation as to why the Authority has not yet undertaken the required maintenance or repairs and describe"]
["the Authority's plan to address the conditions identified. "]
[]
["Page N-3 (2)"]

{"sheet":"Questionnaire (N-3)(3)","index":22,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,4],[0,0,0,4],[1,0,1,4],[2,0,2,2],[3,0,3,4],[5,0,5,4]]}
["AUTHORITY INFORMATIONAL QUESTIONNAIRE"]
["(CONTINUED)"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["17. Did the Authority receive any notices of fines or assessments from the Department of Environmental Protection or any other entity"]
["due to noncompliance with current regulations (i.e. sewer overflow, etc.)?"]
["If \"yes\", provide description of the event or condition that resulted in the fine/assessment and indicate the amount of the fine/assessment. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-3 (3)"]

{"sheet":"Questionnaire (N-3)(4)","index":23,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,7],[2,0,2,2],[1,0,1,7],[0,0,0,7],[6,0,6,7],[5,0,5,7],[3,0,3,7]]}
["AUTHORITY INFORMATIONAL QUESTIONNAIRE"]
["(CONTINUED)"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
["Use the space below to provide clarification for any Questionnaire responses."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-3 (4)"]

{"sheet":"Commissioner Schedule (N-4)","index":24,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,0,47,5],[0,0,0,5],[1,0,1,5],[3,0,3,5],[5,0,5,5],[7,0,7,5]]}
["AUTHORITY SCHEDULE OF COMMISSIONERS, OFFICERS, KEY EMPLOYEES"]
["HIGHEST COMPENSATED EMPLOYEES AND INDEPENDENT CONTRACTORS"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: January 01, 2023 to December 31, 2023"}]
[]
["Complete the attached table for all persons required to be listed per #1-4 below."]
["1)     List all of the Authority's current commissioners and officers and amount of compensation from the Authority"]
[" as defined below.  Enter zero if no compensation was paid. "]
["2)     List all of the Authority's key employees and highest compensated employees other than a commissioner of officer"]
["as defined below and amount of compensation from the Authority."]
["3)     List all of the Authority's former officers, key employees, and highest compensated employees who received more than"]
["$100,000 in reportable compensation from the Authority during the most recent fiscal year completed. "]
["4)     List all of the Authority's former commissioners who received more than $10,000 in reportable compensation from the Authority"]
["during the most recent fiscal year completed. "]
[]
["Commissioner: A member of the governing body of the authority with voting rights.  Include alternates for the purposes"]
["                            of this schedule. "]
[]
["Officer: A person elected or appointed to manage the authority's daily operations at any time during the year, such as the"]
["                chairperson, vice-chairperson, secretary, or treasurer.  For the purposes of this schedule, treat the authority's top"]
["                management official and top financial officer as officers, if applicable. A member of the governing body may be "]
["                both a commissioner and an officer for the purposes of this schedule. "]
[]
["Key Employee: An employee or independent contractor of the authority (other than a commissioner or officer) who meets"]
["                a) The individual received reportable compensation from the authority and other public entities in excess of"]
["                $150,000 for the most recent fiscal year completed; and"]
["                b) The individual has responsibilities or influence over the authority as a whole or has power to control or"]
["                determine 10% or more of the authority's capital expenditures or operating budget. "]
[]
["Highest Compensated Employee: One of the five highest compensated employees or independent contractors of the authority"]
["                other than current commissioners, officers, or key employees whose aggregate reportable compensation from the "]
["                authority and other public entities is greater than $100,000 for the most recent fiscal year completed. "]
[]
["Compensation: All forms of cash and non-cash payments or benefits provided in exchance for services, including salaries and"]
["                wages, bonuses, severance payments, deferred payments, retirement benefits, fringe benefits, and other financial"]
["                arrangements or transactions such as perosnal vehicles, meals, housing, personal, and family education benefits, below-"]
["                market loans, payment of personal or family travel, entertainment, and personal use of the Authority's prperty.  "]
["                Compensation includes payments and other benefits provided to both employees and independent contractors "]
["                in exchange for services. "]
[]
["Reportable Compensation (Use the most recent W-2 available): The aggregate compensation that is reported (or required to be"]
["                reported) on Form W-2, box 1 or 5, whichever amount is greater, and/or Form 1099-MISC, box 7, for the most recent"]
["                calendar year ended 60 days before the start of the proposed budget year. "]
[]
[]
["Page N-4"]

{"sheet":"Page N-4 (2 of 2)","index":25,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[4,4,4,8],[4,9,4,11],[44,0,44,14],[0,0,0,14],[1,0,1,14],[2,0,2,14]]}
["Authority Schedule of Commissioners, Officers, Key Employees, Highest Compensated Employees and Independent Contractors (Continued)"]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Position",null,null,null,null,"Reportable Compensation from Authority (W-2/ 1099)"]
[null,"Name","Title","Average Hours per Week Dedicated to Position","Commissioner","Officer","Key Employee","Highest Compensated","Former","Base Salary/ Stipend","Bonus","Other (auto allowance, expense account, payment in lieu of health benefits, etc.)","Estimated amount of other compensation from the Authority (health benefits, pension, etc.)","Total Compensation from Authority"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:M7)","v":0}]
[{"$f":"A7+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J8:M8)","v":0}]
[{"$f":"A8+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total:",null,null,null,null,null,null,null,{"$f":"SUM(J7:J41)","v":0},{"$f":"SUM(K7:K41)","v":0},{"$f":"SUM(L7:L41)","v":0},{"$f":"SUM(M7:M41)","v":0},{"$f":"SUM(N7:N41)","v":0}]
[]
[]
["Page N-4 (2)"]

{"sheet":"Health Benefits (N-5)","index":26,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[32,0,32,2],[33,0,33,2]]}
["Schedule of Health Benefits - Detailed Cost Analysis"]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
["If no health benefits, check this box: "]
[null," # of Covered Members (Medical & Rx) Proposed Budget","Annual Cost Estimate per Employee Proposed Budget ","Total Cost Estimate Proposed Budget ","# of Covered Members (Medical & Rx) Current Year","Annual Cost per Employee Current Year","Total Current Year Cost","$ Increase (Decrease)","% Increase (Decrease)"]
[]
["Active Employees - Health Benefits - Annual Cost"]
["Single Coverage",null,null,{"$f":"B8*C8","v":0},null,null,{"$f":"E8*F8","v":0},{"$f":"D8-G8","v":0},{"$f":"IFERROR(H8/G8,0)","v":0}]
["Parent & Child",null,null,{"$f":"B9*C9","v":0},null,null,{"$f":"E9*F9","v":0},{"$f":"D9-G9","v":0},{"$f":"IFERROR(H9/G9,0)","v":0}]
["Employee & Spouse (or Partner)",null,null,{"$f":"B10*C10","v":0},null,null,{"$f":"E10*F10","v":0},{"$f":"D10-G10","v":0},0]
["Family",null,null,{"$f":"B11*C11","v":0},null,null,{"$f":"E11*F11","v":0},{"$f":"D11-G11","v":0},0]
["Employee Cost Sharing Contribution (enter as negative - )",null,null,null,null,null,null,{"$f":"D12-G12","v":0},0]
["Subtotal",{"$f":"SUM(B8:B12)","v":0},null,{"$f":"SUM(D8:D12)","v":0},{"$f":"SUM(E8:E12)","v":0},null,0,0,0]
[]
["Commissioners - Health Benefits - Annual Cost "]
["Single Coverage",null,null,{"$f":"B16*C16","v":0},null,null,{"$f":"E16*F16","v":0},{"$f":"D16-G16","v":0},{"$f":"IFERROR(H16/G16,0)","v":0}]
["Parent & Child",null,null,{"$f":"B17*C17","v":0},null,null,{"$f":"E17*F17","v":0},{"$f":"D17-G17","v":0},0]
["Employee & Spouse (or Partner)",null,null,{"$f":"B18*C18","v":0},null,null,{"$f":"E18*F18","v":0},{"$f":"D18-G18","v":0},0]
["Family",null,null,{"$f":"B19*C19","v":0},null,null,{"$f":"E19*F19","v":0},{"$f":"D19-G19","v":0},0]
["Employee Cost Sharing Contribution (enter as negative - )",null,null,null,null,null,null,{"$f":"D20-G20","v":0},0]
["Subtotal",{"$f":"SUM(B16:B20)","v":0},null,{"$f":"SUM(D16:D20)","v":0},0,null,{"$f":"SUM(G16:G20)","v":0},0,0]
[]
["Retirees - Health Benefits - Annual Cost "]
["Single Coverage",null,null,{"$f":"B24*C24","v":0},null,null,{"$f":"E24*F24","v":0},{"$f":"D24-G24","v":0},{"$f":"IFERROR(H24/G24,0)","v":0}]
["Parent & Child",null,null,{"$f":"B25*C25","v":0},null,null,{"$f":"E25*F25","v":0},{"$f":"D25-G25","v":0},0]
["Employee & Spouse (or Partner)",null,null,{"$f":"B26*C26","v":0},null,null,{"$f":"E26*F26","v":0},{"$f":"D26-G26","v":0},0]
["Family",null,null,{"$f":"B27*C27","v":0},null,null,{"$f":"E27*F27","v":0},{"$f":"D27-G27","v":0},0]
["Employee Cost Sharing Contribution (enter as negative - )",null,null,null,null,null,null,{"$f":"D28-G28","v":0},0]
["Subtotal",{"$f":"SUM(B24:B28)","v":0},null,{"$f":"SUM(D24:D28)","v":0},0,null,{"$f":"SUM(G24:G28)","v":0},0,0]
[]
["GRAND TOTAL",{"$f":"+B29+B21+B13","v":0},null,{"$f":"+D29+D21+D13","v":0},{"$f":"+E29+E21+E13","v":0},null,{"$f":"+G29+G21+G13","v":0},{"$f":"+H29+H21+H13","v":0},{"$f":"IFERROR(H31/G31,0)","v":0}]
[]
["Is medical coverage provided by the SHBP (Yes or No)?"]
["Is prescription drug coverage provided by the SHBP (Yes or No)?"]
[]
["Page N-5"]

{"sheet":"Accumulated Absences (N-6)","index":27,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
["If no accumulated absences, check this box:",null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit","Gross Days of Accumulated Compensated Absences per Most Recent Audit","Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6"]

{"sheet":"Accumulated Absences (N-6) (2)","index":28,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6 (2)"]

{"sheet":"Accumulated Absences (N-6) (3)","index":29,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6 (3)"]

{"sheet":"Accumulated Absences (N-6) (4)","index":30,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6 (4)"]

{"sheet":"Accumulated Absences (N-6) (5)","index":31,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6 (5)"]

{"sheet":"Accumulated Absences (N-6) (6)","index":32,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6 (6)"]

{"sheet":"Accumulated Absences (N-6) (7)","index":33,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6 (7)"]

{"sheet":"Accumulated Absences (N-6) (8)","index":34,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (this page only)",null,{"$f":"SUM(C7:C24)","v":0}]
["Page N-6 (8)"]

{"sheet":"TOTAL Accumulated Absences","index":35,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[4,3,4,5],[24,0,24,1],[25,0,25,6]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Complete the below table for the Authority's accrued liability for compensated absences. "]
[null,null,null,"Legal Basis for Benefit (check applicable items)"]
["Individuals Eligible for Benefit",{"$f":"'Accumulated Absences (N-6)'!B6","v":"Gross Days of Accumulated Compensated Absences per Most Recent Audit"},"Dollar Value of Accrued Compensated Absence Liability","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total liability for accumulated compensated absences at per most recent audit (all pages)",null,{"$f":"SUM(C7:C24)+'Accumulated Absences (N-6)'!C25+'Accumulated Absences (N-6) (2)'!C25+'Accumulated Absences (N-6) (3)'!C25+'Accumulated Absences (N-6) (4)'!C25+'Accumulated Absences (N-6) (5)'!C25+'Accumulated Absences (N-6) (6)'!C25+'Accumulated Absences (N-6) (7)'!C25+'Accumulated Absences (N-6) (8)'!C25","v":0}]
["Page N-6 (Totals)"]

{"sheet":"Shared Services (N-7)","index":36,"n_rows":39,"n_cols":30,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,6],[2,0,2,6],[1,0,1,6],[0,0,0,6]]}
["Schedule of Shared Service Agreements"]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
["If no shared services, check this box:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["Enter the shared service agreements that the Authority currently engages in and identify the amount that is received/paid for those services. "]
["Name of Entity Providing Service","Name of Entity Receiving Service","Type of Shared Service Provided","Comments (Enter more specifics if needed)","Agreement Effective Date","Agreement End Date","Amount to be Received by/ Paid from Authority"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-7"]

{"sheet":"Shared Services (N-7) (2)","index":37,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,6],[2,0,2,6],[1,0,1,6],[0,0,0,6]]}
["Schedule of Shared Service Agreements (Cont.)"]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Enter the shared service agreements that the Authority currently engages in and identify the amount that is received/paid for those services. "]
["Name of Entity Providing Service","Name of Entity Receiving Service","Type of Shared Service Provided","Comments (Enter more specifics if needed)","Agreement Effective Date","Agreement End Date","Amount to be Received by/ Paid from Authority"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-7(2)"]

{"sheet":"Financial Schedule","index":38,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,5],[13,0,13,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY BUDGET\"","v":"2023 AUTHORITY BUDGET"}]
["FINANCIAL SCHEDULES SECTION"]

{"sheet":"F-1 Summary","index":39,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,14],[3,3,3,9],[19,1,19,2],[31,1,31,2],[0,0,0,14],[1,0,1,14]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2023 Proposed Budget"},null,null,null,null,null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"},null,"$ Increase (Decrease) Proposed vs. Adopted","% Increase (Decrease) Proposed vs. Adopted"]
[null,null,null,{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"},"Total All Operations",null,"Total All Operations",null,"All Operations","All Operations"]
["REVENUES"]
[]
[null,"Total Operating Revenues",null,{"$f":"+'F-2 Revenues (Proposed)'!D40","v":0},{"$f":"+'F-2 Revenues (Proposed)'!E40","v":0},{"$f":"+'F-2 Revenues (Proposed)'!F40","v":0},{"$f":"+'F-2 Revenues (Proposed)'!G40","v":0},{"$f":"+'F-2 Revenues (Proposed)'!H40","v":0},{"$f":"+'F-2 Revenues (Proposed)'!I40","v":0},{"$f":"SUM(D8:I8)","v":0},null,{"$f":"+'F-2 Revenues (Proposed)'!L40","v":0},null,{"$f":"J8-L8","v":0},{"$f":"N8/L8","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Non-Operating Revenues",null,{"$f":"+'F-2 Revenues (Proposed)'!D55","v":0},{"$f":"+'F-2 Revenues (Proposed)'!E55","v":0},{"$f":"+'F-2 Revenues (Proposed)'!F55","v":0},{"$f":"+'F-2 Revenues (Proposed)'!G55","v":0},{"$f":"+'F-2 Revenues (Proposed)'!H55","v":0},{"$f":"+'F-2 Revenues (Proposed)'!I55","v":0},{"$f":"SUM(D10:I10)","v":0},null,{"$f":"+'F-2 Revenues (Proposed)'!L55","v":0},null,{"$f":"J10-L10","v":0},{"$f":"N10/L10","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Total Anticipated Revenues",{"$f":"D8+D10","v":0},{"$f":"E8+E10","v":0},0,0,0,{"$f":"I8+I10","v":0},0,null,{"$f":"L8+L10","v":0},null,{"$f":"J12-L12","v":0},{"$f":"N12/L12","v":{"$error":"#DIV/0!"}}]
[]
["APPROPRIATIONS"]
[]
[null,"Total Administration",null,{"$f":"'F-4 Appropriations (Proposed)'!D18","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E18","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F18","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G18","v":0},{"$f":"'F-4 Appropriations (Proposed)'!H18","v":0},{"$f":"'F-4 Appropriations (Proposed)'!I18","v":0},{"$f":"SUM(D16:I16)","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!L18","v":0},null,{"$f":"J16-L16","v":0},{"$f":"N16/L16","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Cost of Providing Services",null,{"$f":"'F-4 Appropriations (Proposed)'!D30","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E30","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F30","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G30","v":0},{"$f":"'F-4 Appropriations (Proposed)'!H30","v":0},{"$f":"'F-4 Appropriations (Proposed)'!I30","v":0},{"$f":"SUM(D18:I18)","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!L30","v":0},null,{"$f":"J18-L18","v":0},{"$f":"N18/L18","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",null,{"$f":"'F-4 Appropriations (Proposed)'!D31","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!E31","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!F31","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!G31","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!H31","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!I31","v":0},{"$f":"SUM(D20:I20)","v":0},null,{"$f":"+'F-4 Appropriations (Proposed)'!L31","v":0},null,{"$f":"J20-L20","v":0},{"$f":"N20/L20","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Total Operating Appropriations",{"$f":"+D16+D18+D20","v":0},{"$f":"+E16+E18+E20","v":0},0,0,0,0,0,null,{"$f":"L16+L18+L20","v":0},null,{"$f":"J22-L22","v":0},{"$f":"N22/L22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Interest Payments on Debt",null,{"$f":"'F-4 Appropriations (Proposed)'!D34","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E34","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F34","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G34","v":0},{"$f":"'F-4 Appropriations (Proposed)'!H34","v":0},{"$f":"'F-4 Appropriations (Proposed)'!I34","v":0},{"$f":"'F-4 Appropriations (Proposed)'!J34","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!L34","v":0},null,{"$f":"J24-L24","v":0},{"$f":"N24/L24","v":{"$error":"#DIV/0!"}}]
[null,"Total Other Non-Operating Appropriations",null,{"$f":"D26-D24","v":0},{"$f":"E26-E24","v":0},0,0,0,0,0,null,{"$f":"L26-L24","v":0},null,{"$f":"J25-L25","v":0},{"$f":"N25/L25","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Non-Operating Appropriations",{"$f":"'F-4 Appropriations (Proposed)'!D39","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!E39","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!F39","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!G39","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!H39","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!I39","v":0},{"$f":"SUM(D26:I26)","v":0},null,{"$f":"+'F-4 Appropriations (Proposed)'!L39","v":0},null,{"$f":"J26-L26","v":0},{"$f":"N26/L26","v":{"$error":"#DIV/0!"}}]
[]
[null,"Accumulated Deficit",null,{"$f":"+'F-4 Appropriations (Proposed)'!D41","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E41","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!F41","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!G41","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!H41","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!I41","v":0},{"$f":"SUM(D28:I28)","v":0},null,{"$f":"+'F-4 Appropriations (Proposed)'!L41","v":0},null,{"$f":"J28-L28","v":0},{"$f":"N28/L28","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Total Appropriations and Accumulated Deficit",{"$f":"+D22+D26+D28","v":0},{"$f":"+E22+E26+E28","v":0},0,0,0,0,0,null,{"$f":"+L22+L26+L28","v":0},null,{"$f":"J30-L30","v":0},{"$f":"N30/L30","v":{"$error":"#DIV/0!"}}]
[]
[null,"Less: Total Unrestricted Net Position Utilized",null,{"$f":"'F-4 Appropriations (Proposed)'!D46","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E46","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F46","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G46","v":0},{"$f":"'F-4 Appropriations (Proposed)'!H46","v":0},{"$f":"'F-4 Appropriations (Proposed)'!I46","v":0},{"$f":"SUM(D32:I32)","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!L46","v":0},null,{"$f":"J32-L32","v":0},{"$f":"N32/L32","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Net Total Appropriations",{"$f":"+D30-D32","v":0},{"$f":"+E30-E32","v":0},0,0,0,0,0,null,{"$f":"L30-L32","v":0},null,{"$f":"J34-L34","v":0},{"$f":"N34/L34","v":{"$error":"#DIV/0!"}}]
[]
["ANTICIPATED SURPLUS (DEFICIT)",null,null,{"$f":"+D12-D34","v":0},{"$f":"+E12-E34","v":0},0,0,0,0,0,null,{"$f":"L12-L34","v":0},null,{"$f":"J36-L36","v":0},{"$f":"N36/L36","v":{"$error":"#DIV/0!"}}]
[]
["Page F-1"]

{"sheet":"F-2 Revenues (Proposed)","index":40,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,3,3,9],[0,0,0,14],[1,0,1,14],[57,0,57,14]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2023 Proposed Budget"},null,null,null,null,null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"},null,"$ Increase (Decrease) Proposed vs. Adopted","% Increase (Decrease) Proposed vs. Adopted"]
[null,null,null,{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"},"Total All Operations",null,"Total All Operations",null,"All Operations","All Operations"]
["OPERATING REVENUES"]
["Service Charges"]
[null,"Residential",null,null,null,null,null,null,null,{"$f":"SUM(D8:I8)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!J8","v":0},null,{"$f":"J8-L8","v":0},{"$f":"N8/L8","v":{"$error":"#DIV/0!"}}]
[null,"Business/Commercial",null,null,null,null,null,null,null,{"$f":"SUM(D9:I9)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J9","v":0},null,{"$f":"J9-L9","v":0},{"$f":"N9/L9","v":{"$error":"#DIV/0!"}}]
[null,"Industrial",null,null,null,null,null,null,null,0,null,{"$f":"'F-3 Revenues (PY Adopted)'!J10","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Intergovernmental",null,null,null,null,null,null,null,0,null,{"$f":"'F-3 Revenues (PY Adopted)'!J11","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Other ",null,null,null,null,null,null,null,0,null,{"$f":"'F-3 Revenues (PY Adopted)'!J12","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Service Charges",{"$f":"SUM(D8:D12)","v":0},{"$f":"SUM(E8:E12)","v":0},0,0,0,0,0,null,{"$f":"SUM(L8:L12)","v":0},null,{"$f":"J13-L13","v":0},{"$error":"#DIV/0!"}]
["Connection Fees"]
[null,"Residential",null,null,null,null,null,null,null,{"$f":"SUM(D15:I15)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J15","v":0},null,{"$f":"J15-L15","v":0},{"$f":"N15/L15","v":{"$error":"#DIV/0!"}}]
[null,"Business/Commercial",null,null,null,null,null,null,null,{"$f":"SUM(D16:I16)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J16","v":0},null,{"$f":"J16-L16","v":0},{"$f":"N16/L16","v":{"$error":"#DIV/0!"}}]
[null,"Industrial",null,null,null,null,null,null,null,{"$f":"SUM(D17:I17)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J17","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Intergovernmental",null,null,null,null,null,null,null,{"$f":"SUM(D18:I18)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J18","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Other ",null,null,null,null,null,null,null,{"$f":"SUM(D19:I19)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J19","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Connection Fees",{"$f":"SUM(D15:D19)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(L15:L19)","v":0},null,0,{"$error":"#DIV/0!"}]
["Parking Fees"]
[null,"Meters",null,null,null,null,null,null,null,{"$f":"SUM(D22:I22)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J22","v":0},null,{"$f":"J22-L22","v":0},{"$f":"N22/L22","v":{"$error":"#DIV/0!"}}]
[null,"Permits",null,null,null,null,null,null,null,{"$f":"SUM(D23:I23)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!J23","v":0},null,{"$f":"J23-L23","v":0},{"$f":"N23/L23","v":{"$error":"#DIV/0!"}}]
[null,"Fines/Penalties",null,null,null,null,null,null,null,0,null,{"$f":"'F-3 Revenues (PY Adopted)'!J24","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Other ",null,null,null,null,null,null,null,0,null,{"$f":"'F-3 Revenues (PY Adopted)'!J25","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Parking Fees",{"$f":"SUM(D22:D25)","v":0},{"$f":"SUM(E22:E25)","v":0},0,0,0,0,0,null,{"$f":"SUM(L22:L25)","v":0},null,0,{"$error":"#DIV/0!"}]
["Other Operating Revenues (List)"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:I28)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!J28","v":0},null,{"$f":"J28-L28","v":0},{"$f":"N28/L28","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:I29)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!J29","v":0},null,{"$f":"J29-L29","v":0},{"$f":"N29/L29","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J30","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J31","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J32","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J33","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J34","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J35","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J36","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J37","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J38","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Other Revenue",{"$f":"SUM(D28:D38)","v":0},{"$f":"SUM(E28:E38)","v":0},0,0,0,0,0,null,{"$f":"SUM(L28:L38)","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Operating Revenues",{"$f":"+D13+D20+D26+D39","v":0},{"$f":"+E13+E20+E26+E39","v":0},0,0,0,0,0,null,0,null,0,{"$error":"#DIV/0!"}]
["NON-OPERATING REVENUES"]
["Other Non-Operating Revenues (List)"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D43:I43)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!J43","v":0},null,{"$f":"J43-L43","v":0},{"$f":"N43/L43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D44:I44)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!J44","v":0},null,{"$f":"J44-L44","v":0},{"$f":"N44/L44","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J45","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J46","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J47","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J48","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Other Non-Operating Revenue",{"$f":"SUM(D43:D48)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(L43:L48)","v":0},null,0,{"$error":"#DIV/0!"}]
["Interest on Investments & Deposits (List)"]
[null,"Interest Earned",null,null,null,null,null,null,null,{"$f":"SUM(D51:I51)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!J51","v":0},null,{"$f":"J51-L51","v":0},{"$f":"N51/L51","v":{"$error":"#DIV/0!"}}]
[null,"Penalties",null,null,null,null,null,null,null,{"$f":"SUM(D52:I52)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!J52","v":0},null,{"$f":"J52-L52","v":0},{"$f":"N52/L52","v":{"$error":"#DIV/0!"}}]
[null,"Other",null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!J53","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Interest ",{"$f":"SUM(D51:D53)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(L51:L53)","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Non-Operating Revenues",{"$f":"+D49+D54","v":0},{"$f":"+E49+E54","v":0},0,0,0,0,0,null,0,null,0,{"$error":"#DIV/0!"}]
["TOTAL ANTICIPATED REVENUES",null,null,{"$f":"+D40+D55","v":0},0,0,0,0,0,0,null,{"$f":"+L40+L55","v":0},null,{"$f":"J56-L56","v":0},{"$error":"#DIV/0!"}]
[]
["Page F-2"]

{"sheet":"F-3 Revenues (PY Adopted)","index":41,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,3,1,4],[1,6,1,7],[3,3,3,9],[57,0,57,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[]
[null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"}]
[null,null,null,{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"},"Total All Operations"]
["OPERATING REVENUES"]
["Service Charges"]
[null,"Residential",null,null,null,null,null,null,null,{"$f":"SUM(D8:I8)","v":0}]
[null,"Business/Commercial",null,null,null,null,null,null,null,{"$f":"SUM(D9:I9)","v":0}]
[null,"Industrial",null,null,null,null,null,null,null,0]
[null,"Intergovernmental",null,null,null,null,null,null,null,0]
[null,"Other ",null,null,null,null,null,null,null,0]
[null,null,"Total Service Charges",{"$f":"SUM(D8:D12)","v":0},{"$f":"SUM(E8:E12)","v":0},0,0,0,0,0]
["Connection Fees"]
[null,"Residential",null,null,null,null,null,null,null,{"$f":"SUM(D15:I15)","v":0}]
[null,"Business/Commercial",null,null,null,null,null,null,null,{"$f":"SUM(D16:I16)","v":0}]
[null,"Industrial",null,null,null,null,null,null,null,0]
[null,"Intergovernmental",null,null,null,null,null,null,null,0]
[null,"Other ",null,null,null,null,null,null,null,0]
[null,null,"Total Connection Fees",{"$f":"SUM(D15:D19)","v":0},{"$f":"SUM(E15:E19)","v":0},0,0,0,0,0]
["Parking Fees"]
[null,"Meters",null,null,null,null,null,null,null,{"$f":"SUM(D22:I22)","v":0}]
[null,"Permits",null,null,null,null,null,null,null,{"$f":"SUM(D23:I23)","v":0}]
[null,"Fines/Penalties",null,null,null,null,null,null,null,0]
[null,"Other ",null,null,null,null,null,null,null,0]
[null,null,"Total Parking Fees",{"$f":"SUM(D22:D25)","v":0},{"$f":"SUM(E22:E25)","v":0},0,0,0,0,0]
["Other Operating Revenues (List)"]
[null,{"$f":"'F-2 Revenues (Proposed)'!B28","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D28:I28)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B29","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D29:I29)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B30","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B31","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B32","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B33","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B34","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B35","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B36","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B37","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B38","v":0},null,null,null,null,null,null,null,0]
[null,null,"Total Other Revenue",{"$f":"SUM(D28:D38)","v":0},{"$f":"SUM(E28:E38)","v":0},0,0,0,0,0]
[null,null,"     Total Operating Revenues",{"$f":"+D13+D20+D26+D39","v":0},{"$f":"+E13+E20+E26+E39","v":0},0,0,0,0,0]
["NON-OPERATING REVENUES"]
["Other Non-Operating Revenues (List)"]
[null,{"$f":"'F-2 Revenues (Proposed)'!B43","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D43:I43)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B44","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D44:I44)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B45","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B46","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B47","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B48","v":0},null,null,null,null,null,null,null,0]
[null,null,"Other Non-Operating Revenues",{"$f":"SUM(D43:D48)","v":0},{"$f":"SUM(E43:E48)","v":0},0,0,0,0,0]
["Interest on Investments & Deposits"]
[null,"Interest Earned",null,null,null,null,null,null,null,{"$f":"SUM(D51:I51)","v":0}]
[null,"Penalties",null,null,null,null,null,null,null,{"$f":"SUM(D52:I52)","v":0}]
[null,"Other",null,null,null,null,null,null,null,0]
[null,null,"Total Interest ",{"$f":"SUM(D51:D53)","v":0},0,0,0,0,0,0]
[null,null,"     Total Non-Operating Revenues",{"$f":"+D49+D54","v":0},{"$f":"+E49+E54","v":0},0,0,0,0,0]
["TOTAL ANTICIPATED REVENUES",null,null,{"$f":"+D40+D55","v":0},0,0,0,0,0,0]
[]
["Page F-3"]

{"sheet":"F-4 Appropriations (Proposed)","index":42,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[15,1,15,2],[27,1,27,2],[51,0,51,14],[30,0,30,2],[41,0,41,2],[48,0,48,11],[3,3,3,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2023 Proposed Budget"},null,null,null,null,null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"},null,"$ Increase (Decrease) Proposed vs. Adopted","% Increase (Decrease) Proposed vs. Adopted"]
[null,null,null,{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"},"Total All Operations",null,"Total All Operations",null,"All Operations","All Operations"]
["OPERATING APPROPRIATIONS"]
["Administration - Personnel"]
[null,"Salary & Wages",null,null,null,null,null,null,null,{"$f":"SUM(D8:I8)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J8","v":0},null,{"$f":"J8-L8","v":0},{"$f":"N8/L8","v":{"$error":"#DIV/0!"}}]
[null,"Fringe Benefits",null,null,null,null,null,null,null,{"$f":"SUM(D9:I9)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J9","v":0},null,{"$f":"J9-L9","v":0},{"$f":"N9/L9","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Administration - Personnel",{"$f":"SUM(D8:D9)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(L8:L9)","v":0},null,0,{"$error":"#DIV/0!"}]
["Administration - Other (List)"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D12:I12)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J12","v":0},null,{"$f":"J12-L12","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:I13)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J13","v":0},null,{"$f":"J13-L13","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:I14)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J14","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:I15)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J15","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Miscellaneous Administration*",null,null,null,null,null,null,null,{"$f":"SUM(D16:I16)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J16","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Administration - Other",{"$f":"SUM(D12:D16)","v":0},{"$f":"SUM(E12:E16)","v":0},0,0,0,0,{"$f":"SUM(J12:J16)","v":0},null,{"$f":"SUM(L12:L16)","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Administration",{"$f":"D17+D10","v":0},{"$f":"E17+E10","v":0},0,0,0,0,0,null,{"$f":"+L17+L10","v":0},null,0,{"$error":"#DIV/0!"}]
["Cost of Providing Services - Personnel"]
[null,"Salary & Wages",null,null,null,null,null,null,null,{"$f":"SUM(D20:I20)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J20","v":0},null,{"$f":"J20-L20","v":0},{"$error":"#DIV/0!"}]
[null,"Fringe Benefits",null,null,null,null,null,null,null,{"$f":"SUM(D21:I21)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J21","v":0},null,{"$f":"J21-L21","v":0},{"$error":"#DIV/0!"}]
[null,null,"Total COPS - Personnel",{"$f":"SUM(D20:D21)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(L20:L21)","v":0},null,0,{"$error":"#DIV/0!"}]
["Cost of Providing Services - Other (List)"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D24:I24)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J24","v":0},null,{"$f":"J24-L24","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D25:I25)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J25","v":0},null,{"$f":"J25-L25","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"'F-5 Appropriations (PY Adopted)'!J26","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"'F-5 Appropriations (PY Adopted)'!J27","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Miscellaneous COPS*",null,null,null,null,null,null,null,0,null,{"$f":"'F-5 Appropriations (PY Adopted)'!J28","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total COPS - Other",{"$f":"SUM(D24:D28)","v":0},{"$f":"SUM(E24:E28)","v":0},0,0,0,0,0,null,{"$f":"SUM(L24:L28)","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Cost of Providing Services",{"$f":"D29+D22","v":0},{"$f":"E29+E22","v":0},0,0,0,0,0,null,{"$f":"L29+L22","v":0},null,0,{"$error":"#DIV/0!"}]
["Total Principal Payments on Debt Service in Lieu of Depreciation",null,null,{"$f":"+'F-6 Debt Service-Principal'!H10","v":0},{"$f":"+'F-6 Debt Service-Principal'!H16","v":0},{"$f":"+'F-6 Debt Service-Principal'!H22","v":0},{"$f":"+'F-6 Debt Service-Principal'!H28","v":0},{"$f":"+'F-6 Debt Service-Principal'!H34","v":0},{"$f":"+'F-6 Debt Service-Principal'!H40","v":0},{"$f":"SUM(D31:I31)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J31","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"          Total Operating Appropriations",{"$f":"+D30+D18+D31","v":0},{"$f":"+E30+E18+E31","v":0},0,0,0,0,0,null,{"$f":"+L30+L18+L31","v":0},null,0,{"$error":"#DIV/0!"}]
["NON-OPERATING APPROPRIATIONS"]
["Total Interest Payments on Debt",null,null,{"$f":"'F-7 Debt Service-Interest'!F10","v":0},{"$f":"'F-7 Debt Service-Interest'!F16","v":0},{"$f":"'F-7 Debt Service-Interest'!F22","v":0},{"$f":"'F-7 Debt Service-Interest'!F28","v":0},{"$f":"'F-7 Debt Service-Interest'!F34","v":0},{"$f":"'F-7 Debt Service-Interest'!F40","v":0},{"$f":"SUM(D34:I34)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J34","v":0},null,{"$f":"J34-L34","v":0},{"$error":"#DIV/0!"}]
["Operations & Maintenance Reserve",null,null,null,null,null,null,null,null,{"$f":"SUM(D35:I35)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J35","v":0},null,{"$f":"J35-L35","v":0},{"$error":"#DIV/0!"}]
["Renewal & Replacement Reserve",null,null,null,null,null,null,null,null,0,null,{"$f":"'F-5 Appropriations (PY Adopted)'!J36","v":0},null,0,{"$error":"#DIV/0!"}]
["Municipality/County Appropriation",null,null,null,null,null,null,null,null,0,null,{"$f":"'F-5 Appropriations (PY Adopted)'!J37","v":0},null,0,{"$error":"#DIV/0!"}]
["Other Reserves",null,null,null,null,null,null,null,null,0,null,{"$f":"'F-5 Appropriations (PY Adopted)'!J38","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Total Non-Operating Appropriations",null,{"$f":"SUM(D34:D38)","v":0},{"$f":"SUM(E34:E38)","v":0},0,0,0,0,0,null,{"$f":"SUM(L34:L38)","v":0},null,0,{"$error":"#DIV/0!"}]
["TOTAL APPROPRIATIONS",null,null,{"$f":"+D39+D32","v":0},{"$f":"+E39+E32","v":0},0,0,0,0,0,null,{"$f":"+L39+L32","v":0},null,0,{"$error":"#DIV/0!"}]
["ACCUMULATED DEFICIT",null,null,null,null,null,null,null,null,{"$f":"SUM(D41:I41)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J41","v":0},null,0,{"$error":"#DIV/0!"}]
["TOTAL APPROPRIATIONS & ACCUMULATED DEFICIT",null,null,{"$f":"+D40+D41","v":0},{"$f":"+E40+E41","v":0},0,0,0,0,0,null,{"$f":"+L40+L41","v":0},null,0,{"$error":"#DIV/0!"}]
["UNRESTRICTED NET POSITION UTILIZED"]
["Municipality/County Appropriation",null,null,{"$f":"D37","v":0},{"$f":"E37","v":0},0,0,0,0,{"$f":"SUM(D44:I44)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J44","v":0},null,{"$f":"J44-L44","v":0},{"$error":"#DIV/0!"}]
["Other",null,null,null,null,null,null,null,null,{"$f":"SUM(D45:I45)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!J45","v":0},null,{"$f":"J45-L45","v":0},{"$error":"#DIV/0!"}]
[null,"Total Unrestricted Net Position Utilized",null,{"$f":"+D44+D45","v":0},{"$f":"+E44+E45","v":0},0,0,0,0,0,null,{"$f":"+L44+L45","v":0},null,0,{"$error":"#DIV/0!"}]
["TOTAL NET APPROPRIATIONS",null,null,{"$f":"+D42-D46","v":0},{"$f":"+E42-E46","v":0},0,0,0,0,0,null,{"$f":"+L42-L46","v":0},null,0,{"$error":"#DIV/0!"}]
[]
["* Miscellaneous line items may not exceed 5% of total operating appropriations shown below. If amount in miscellaneous is greater than the amount shown below, then the line item must be itemized above. "]
[null,null,"5% of Total Operating Appropriations",{"$f":"D32*0.05","v":0},{"$f":"E32*0.05","v":0},0,0,0,0,0]
[]
["Page F-4"]

{"sheet":"F-4 Appropriation Detail","index":43,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,6],[0,0,0,6],[1,0,1,6],[3,0,3,6],[5,0,5,6],[7,0,7,6],[2,0,2,2]]}
["AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-4 Appropriations (Proposed)\""]
[]
["Line Item:",{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-4 (Detail)"]

{"sheet":"F-4 Appropriation Detail (2)","index":44,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,6],[7,0,7,6],[0,0,0,6],[1,0,1,6],[2,0,2,2],[3,0,3,6],[5,0,5,6]]}
["AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-4 Appropriations (Proposed)\""]
[]
["Line Item:",{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-4 (Detail) (2)"]

{"sheet":"F-4 Appropriation Detail (3)","index":45,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,6],[7,0,7,6],[0,0,0,6],[1,0,1,6],[2,0,2,2],[3,0,3,6],[5,0,5,6]]}
["AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-4 Appropriations (Proposed)\""]
[]
["Line Item:",{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-4 (Detail) (3)"]

{"sheet":"F-5 Appropriations (PY Adopted)","index":46,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,0,51,9],[27,1,27,2],[30,0,30,2],[41,0,41,2],[48,0,48,9],[0,0,0,9],[1,3,1,4],[1,6,1,7],[3,3,3,9],[15,1,15,2]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[]
[null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"}]
[null,null,null,{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"},"Total All Operations"]
["OPERATING APPROPRIATIONS"]
["Administration - Personnel"]
[null,"Salary & Wages",null,null,null,null,null,null,null,{"$f":"SUM(D8:I8)","v":0}]
[null,"Fringe Benefits",null,null,null,null,null,null,null,{"$f":"SUM(D9:I9)","v":0}]
[null,null,"Total Administration - Personnel",{"$f":"SUM(D8:D9)","v":0},0,0,0,0,0,0]
["Administration - Other (List)"]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B12","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D12:I12)","v":0}]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B13","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D13:I13)","v":0}]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B14","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D14:I14)","v":0}]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B15","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D15:I15)","v":0}]
[null,"Miscellaneous Administration*",null,null,null,null,null,null,null,{"$f":"SUM(D16:I16)","v":0}]
[null,null,"Total Administration - Other",{"$f":"SUM(D12:D16)","v":0},{"$f":"SUM(E12:E16)","v":0},0,0,0,0,{"$f":"SUM(J12:J16)","v":0}]
[null,null,"     Total Administration",{"$f":"D17+D10","v":0},{"$f":"E17+E10","v":0},0,0,0,0,0]
["Cost of Providing Services - Personnel"]
[null,"Salary & Wages",null,null,null,null,null,null,null,{"$f":"SUM(D20:I20)","v":0}]
[null,"Fringe Benefits",null,null,null,null,null,null,null,{"$f":"SUM(D21:I21)","v":0}]
[null,null,"Total COPS - Personnel",{"$f":"SUM(D20:D21)","v":0},0,0,0,0,0,0]
["Cost of Providing Services - Other (List)"]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B24","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D24:I24)","v":0}]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B25","v":0},null,null,null,null,null,null,null,{"$f":"SUM(D25:I25)","v":0}]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B26","v":0},null,null,null,null,null,null,null,0]
[null,{"$f":"'F-4 Appropriations (Proposed)'!B27","v":0},null,null,null,null,null,null,null,0]
[null,"Miscellaneous COPS*",null,null,null,null,null,null,null,0]
[null,null,"Total COPS - Other",{"$f":"SUM(D24:D28)","v":0},{"$f":"SUM(E24:E28)","v":0},0,0,0,0,0]
[null,null,"     Total Cost of Providing Services",{"$f":"D29+D22","v":0},{"$f":"E29+E22","v":0},0,0,0,0,0]
["Total Principal Payments on Debt Service in Lieu of Depreciation",null,null,{"$f":"'F-6 Debt Service-Principal'!F10","v":0},{"$f":"'F-6 Debt Service-Principal'!F16","v":0},{"$f":"'F-6 Debt Service-Principal'!F22","v":0},{"$f":"'F-6 Debt Service-Principal'!F28","v":0},{"$f":"'F-6 Debt Service-Principal'!F34","v":0},{"$f":"'F-6 Debt Service-Principal'!F40","v":0},{"$f":"SUM(D31:I31)","v":0}]
[null,null,"          Total Operating Appropriations",{"$f":"+D30+D18+D31","v":0},{"$f":"+E30+E18+E31","v":0},0,0,0,0,0]
["NON-OPERATING APPROPRIATIONS"]
["Total Interest Payments on Debt",null,null,{"$f":"'F-7 Debt Service-Interest'!D10","v":0},{"$f":"'F-7 Debt Service-Interest'!D16","v":0},{"$f":"'F-7 Debt Service-Interest'!D22","v":0},{"$f":"'F-7 Debt Service-Interest'!D28","v":0},{"$f":"'F-7 Debt Service-Interest'!D34","v":0},{"$f":"'F-7 Debt Service-Interest'!D40","v":0},{"$f":"SUM(D34:I34)","v":0}]
["Operations & Maintenance Reserve",null,null,null,null,null,null,null,null,{"$f":"SUM(D35:I35)","v":0}]
["Renewal & Replacement Reserve",null,null,null,null,null,null,null,null,0]
["Municipality/County Appropriation",null,null,null,null,null,null,null,null,0]
["Other Reserves",null,null,null,null,null,null,null,null,0]
[null,"Total Non-Operating Appropriations",null,{"$f":"SUM(D34:D38)","v":0},{"$f":"SUM(E34:E38)","v":0},0,0,0,0,0]
["TOTAL APPROPRIATIONS",null,null,{"$f":"+D39+D32","v":0},{"$f":"+E39+E32","v":0},0,0,0,0,0]
["ACCUMULATED DEFICIT",null,null,null,null,null,null,null,null,{"$f":"SUM(D41:I41)","v":0}]
["TOTAL APPROPRIATIONS & ACCUMULATED DEFICIT",null,null,{"$f":"+D40+D41","v":0},{"$f":"+E40+E41","v":0},0,0,0,0,0]
["UNRESTRICTED NET POSITION UTILIZED"]
["Municipality/County Appropriation",null,null,{"$f":"D37","v":0},{"$f":"E37","v":0},0,0,0,0,{"$f":"SUM(D44:I44)","v":0}]
["Other",null,null,null,null,null,null,null,null,{"$f":"SUM(D45:I45)","v":0}]
[null,"Total Unrestricted Net Position Utilized",null,{"$f":"+D44+D45","v":0},{"$f":"+E44+E45","v":0},0,0,0,0,0]
["TOTAL NET APPROPRIATIONS",null,null,{"$f":"+D42-D46","v":0},{"$f":"+E42-E46","v":0},0,0,0,0,0]
[]
["* Miscellaneous line items may not exceed 5% of total operating appropriations shown below. If amount in miscellaneous is greater than the amount shown below, then the line item must be itemized above. "]
[null,null,"5% of Total Operating Appropriations",{"$f":"D32*0.05","v":0},{"$f":"E32*0.05","v":0},0,0,0,0,0]
[]
["Page F-5"]

{"sheet":"F-5 Appropriation Detail","index":47,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,6],[7,0,7,6],[0,0,0,6],[1,0,1,6],[2,0,2,2],[3,0,3,6],[5,0,5,6]]}
["AUTHORITY PRIOR YEAR ADOPTED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-5 Appropriations (PY Adopted)\""]
[]
["Line Item:",{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-5 (Detail)"]

{"sheet":"F-5 Appropriation Detail (2)","index":48,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,6],[7,0,7,6],[0,0,0,6],[1,0,1,6],[2,0,2,2],[3,0,3,6],[5,0,5,6]]}
["AUTHORITY PRIOR YEAR ADOPTED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-5 Appropriations (PY Adopted)\""]
[]
["Line Item:",{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-5 (Detail) (2)"]

{"sheet":"F-5 Appropriation Detail (3)","index":49,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,6],[7,0,7,6],[0,0,0,6],[1,0,1,6],[2,0,2,2],[3,0,3,6],[5,0,5,6]]}
["AUTHORITY PRIOR YEAR ADOPTED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2022 Adopted Budget"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-5 Appropriations (PY Adopted)\""]
[]
["Line Item:",{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-5 (Detail) (3)"]

{"sheet":"F-6 Debt Service-Principal","index":50,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,16],[47,0,47,16],[2,5,2,13],[42,1,42,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[null,"If Authority has no debt, check this box:"]
[null,null,null,null,null,"Fiscal Year Ending in"]
[null,null,null,"Date of Local Finance Board Approval",null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B1,'KEY INPUTS'!B1-1)&\" (Adopted Budget)\"","v":"2022 (Adopted Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2, 'KEY INPUTS'!B1)&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2+1, 'KEY INPUTS'!B1+1)","v":2024},{"$f":"+J4+1","v":2025},{"$f":"+K4+1","v":2026},{"$f":"+L4+1","v":2027},{"$f":"+M4+1","v":2028},"Thereafter","Total Principal Outstanding"]
[{"$f":"'KEY INPUTS'!D21","v":"Operation #1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:O6)+H6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:O7)+H7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Principal ",null,null,null,{"$f":"SUM(F6:F9)","v":0},null,{"$f":"SUM(H6:H9)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(P6:P9)","v":0}]
[{"$f":"'KEY INPUTS'!D22","v":"Operation #2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J12:O12)+H12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J13:O13)+H13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Principal",null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":0},null,{"$f":"SUM(J12:J15)","v":0},0,0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D23","v":"Operation #3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J18:O18)+H18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:O19)+H19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Principal",null,null,null,{"$f":"SUM(F18:F21)","v":0},null,{"$f":"SUM(H18:H21)","v":0},null,{"$f":"SUM(J18:J21)","v":0},0,0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D24","v":"Operation #4"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J24:O24)+H24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J25:O25)+H25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Principal",null,null,null,{"$f":"SUM(F24:F27)","v":0},null,{"$f":"SUM(H24:H27)","v":0},null,{"$f":"SUM(J24:J27)","v":0},0,0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D25","v":"Operation #5"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J30:O30)+H30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J31:O31)+H31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Principal",null,null,null,{"$f":"SUM(F30:F33)","v":0},null,{"$f":"SUM(H30:H33)","v":0},null,{"$f":"SUM(J30:J33)","v":0},0,0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J36:O36)+H36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:O37)+H37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Principal",null,null,null,{"$f":"SUM(F36:F39)","v":0},null,{"$f":"SUM(H36:H39)","v":0},null,{"$f":"SUM(J36:J39)","v":0},0,0,0,0,0,0]
["TOTAL PRINCIPAL ALL OPERATIONS",null,null,null,null,{"$f":"F40+F34+F28+F22+F16+F10","v":0},null,{"$f":"+H40+H34+H28+H22+H16+H10","v":0},null,{"$f":"+J40+J34+J28+J22+J16+J10","v":0},0,0,0,0,0,0]
[]
[null,"Indicate the Authority's most recent bond rating and the year of the rating by ratings service."]
[null,null,null,null,null,"Moody's",null,"Fitch",null,"Standard & Poors"]
[null,null,null,"Bond Rating"]
[null,null,null,"Year of Last Rating"]
[]
["Page F-6"]

{"sheet":"F-6 Detail","index":51,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,16],[2,5,2,13],[42,1,42,9],[47,0,47,16]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[null,null,null,null,null,"Fiscal Year Ending in"]
[null,null,null,"Date of Local Finance Board Approval",null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B1,'KEY INPUTS'!B1-1)&\" (Adopted Budget)\"","v":"2022 (Adopted Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2, 'KEY INPUTS'!B1)&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2+1, 'KEY INPUTS'!B1+1)","v":2024},{"$f":"+J4+1","v":2025},{"$f":"+K4+1","v":2026},{"$f":"+L4+1","v":2027},{"$f":"+M4+1","v":2028},"Thereafter","Total Principal Outstanding"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:O6)+H6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:O7)+H7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["TOTAL PRINCIPAL ALL OPERATIONS",null,null,null,null,{"$f":"SUM(F6:F39)","v":0},null,{"$f":"SUM(H6:H39)","v":0},null,{"$f":"SUM(J6:J39)","v":0},{"$f":"SUM(K6:K39)","v":0},0,0,0,{"$f":"SUM(O6:O39)","v":0},{"$f":"SUM(P6:P39)","v":0}]
[]
[]
[]
[]
[]
[]
["Page F-6 (Detail)"]

{"sheet":"F-7 Debt Service-Interest","index":52,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,13],[42,0,42,13],[2,3,2,11]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[null,"If Authority has no debt, check this box:"]
[null,null,null,"Fiscal Year Ending in"]
[null,null,null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B1,'KEY INPUTS'!B1-1)&\" (Adopted Budget)\"","v":"2022 (Adopted Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2, 'KEY INPUTS'!B1)&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2+1, 'KEY INPUTS'!B1+1)","v":2024},{"$f":"+H4+1","v":2025},{"$f":"+I4+1","v":2026},{"$f":"+J4+1","v":2027},{"$f":"+K4+1","v":2028},"Thereafter","Total Interest Payments Outstanding"]
[{"$f":"'F-6 Debt Service-Principal'!A5","v":"Operation #1"}]
[null,{"$f":"'F-6 Debt Service-Principal'!B6","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H6:M6)+F6","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B7","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H7:M7)+F7","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B8","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'F-6 Debt Service-Principal'!B9","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Interest Payments",null,{"$f":"SUM(D6:D9)","v":0},null,{"$f":"SUM(F6:F9)","v":0},null,{"$f":"SUM(H6:H9)","v":0},0,0,0,0,0,0]
[{"$f":"'F-6 Debt Service-Principal'!A11","v":"Operation #2"}]
[null,{"$f":"'F-6 Debt Service-Principal'!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H12:M12)+F12","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H13:M13)+F13","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B14","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'F-6 Debt Service-Principal'!B15","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Interest Payments",null,{"$f":"SUM(D12:D15)","v":0},null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":0},0,0,0,0,0,0]
[{"$f":"'F-6 Debt Service-Principal'!A17","v":"Operation #3"}]
[null,{"$f":"'F-6 Debt Service-Principal'!B18","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H18:M18)+F18","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B19","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H19:M19)+F19","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'F-6 Debt Service-Principal'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Interest Payments",null,{"$f":"SUM(D18:D21)","v":0},null,{"$f":"SUM(F18:F21)","v":0},null,{"$f":"SUM(H18:H21)","v":0},0,0,0,0,0,0]
[{"$f":"'F-6 Debt Service-Principal'!A23","v":"Operation #4"}]
[null,{"$f":"'F-6 Debt Service-Principal'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H24:M24)+F24","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H25:M25)+F25","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B26","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'F-6 Debt Service-Principal'!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Interest Payments",null,{"$f":"SUM(D24:D27)","v":0},null,{"$f":"SUM(F24:F27)","v":0},null,{"$f":"SUM(H24:H27)","v":0},0,0,0,0,0,0]
[{"$f":"'F-6 Debt Service-Principal'!A29","v":"Operation #5"}]
[null,{"$f":"'F-6 Debt Service-Principal'!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H30:M30)+F30","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H31:M31)+F31","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B32","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'F-6 Debt Service-Principal'!B33","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Interest Payments",null,{"$f":"SUM(D30:D33)","v":0},null,{"$f":"SUM(F30:F33)","v":0},null,{"$f":"SUM(H30:H33)","v":0},0,0,0,0,0,0]
[{"$f":"'F-6 Debt Service-Principal'!A35","v":"Operation #6"}]
[null,{"$f":"'F-6 Debt Service-Principal'!B36","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H36:M36)+F36","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B37","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H37:M37)+F37","v":0}]
[null,{"$f":"'F-6 Debt Service-Principal'!B38","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'F-6 Debt Service-Principal'!B39","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"     Total Interest Payments",null,{"$f":"SUM(D36:D39)","v":0},null,{"$f":"SUM(F36:F39)","v":0},null,{"$f":"SUM(H36:H39)","v":0},0,0,0,0,0,0]
["TOTAL INTEREST ALL OPERATIONS",null,null,{"$f":"D40+D34+D28+D22+D16+D10","v":0},null,{"$f":"+F40+F34+F28+F22+F16+F10","v":0},null,{"$f":"+H40+H34+H28+H22+H16+H10","v":0},0,0,0,0,0,{"$f":"+N40+N34+N28+N22+N16+N10","v":0}]
[]
["Page F-7"]

{"sheet":"F-7 Detail","index":53,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,14],[2,3,2,11],[42,1,42,7],[47,0,47,14]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[null,null,null,"Fiscal Year Ending in"]
[null,null,null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B1,'KEY INPUTS'!B1-1)&\" (Adopted Budget)\"","v":"2022 (Adopted Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2, 'KEY INPUTS'!B1)&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2+1, 'KEY INPUTS'!B1+1)","v":2024},{"$f":"+H4+1","v":2025},{"$f":"+I4+1","v":2026},{"$f":"+J4+1","v":2027},{"$f":"+K4+1","v":2028},"Thereafter","Total Interest Payments Outstanding"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H6:M6)+F6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H7:M7)+F7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["TOTAL INTEREST ALL OPERATIONS",null,null,{"$f":"SUM(D6:D39)","v":0},null,{"$f":"SUM(F6:F39)","v":0},null,{"$f":"SUM(H6:H39)","v":0},{"$f":"SUM(I6:I39)","v":0},0,0,0,{"$f":"SUM(M6:M39)","v":0},{"$f":"SUM(N6:N39)","v":0}]
[]
[]
[]
[]
[]
[]
["Page F-7 (Detail)"]

{"sheet":"F-8 Net Position","index":54,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,30,9],[22,0,22,2],[24,0,24,9],[25,0,25,9],[26,0,26,9],[28,0,28,9],[1,0,1,9],[0,0,0,9],[3,3,3,9],[5,0,5,2],[17,0,17,2]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,{"$f":"\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2023 Proposed Budget"}]
[null,null,null,{"$f":"'KEY INPUTS'!D21","v":"Operation #1"},{"$f":"'KEY INPUTS'!D22","v":"Operation #2"},{"$f":"'KEY INPUTS'!D23","v":"Operation #3"},{"$f":"'KEY INPUTS'!D24","v":"Operation #4"},{"$f":"'KEY INPUTS'!D25","v":"Operation #5"},{"$f":"'KEY INPUTS'!D26","v":"Operation #6"},"Total All Operations"]
["TOTAL NET POSITION BEGINNING OF LATEST AUDIT REPORT YEAR(1)",null,null,0,null,null,null,null,null,{"$f":"SUM(D6:I6)","v":0}]
[null,"Less: Invested in Capital Assets, Net of Related Debt (1)",null,null,null,null,null,null,null,{"$f":"SUM(D7:I7)","v":0}]
[null,"Less: Restricted for Debt Service Reserve (1)",null,null,null,null,null,null,null,0]
[null,"Less: Other Restricted Net Position (1)",null,null,null,null,null,null,null,0]
[null,null,"Total Unrestricted Net Position (1)",{"$f":"+D6-D7-D8-D9","v":0},{"$f":"+E6-E7-E8-E9","v":0},0,0,0,0,{"$f":"SUM(D10:I10)","v":0}]
[null,"Less: Designated for Non-Operating Improvements & Repairs",null,null,null,null,null,null,null,{"$f":"SUM(D11:I11)","v":0}]
[null,"Less: Designated for Rate Stabilization",null,null,null,null,null,null,null,{"$f":"SUM(D12:I12)","v":0}]
[null,"Less: Other Designated by Resolution",null,null,null,null,null,null,null,0]
[null,"Plus: Accrued Unfunded Pension Liability (1)",null,null,null,null,null,null,null,0]
[null,"Plus: Accrued Unfunded Other Post-Employment Benefit Liability (1)",null,null,null,null,null,null,null,0]
[null,"Plus: Estimated Income (Loss) on Current Year Operations (2)",null,null,null,null,null,null,null,0]
[null,"Plus: Other Adjustments (attach schedule)",null,null,null,null,null,null,null,0]
["UNRESTRICTED NET POSITION AVAILABLE FOR USE IN PROPOSED BUDGET",null,null,{"$f":"D10-D11-D12-D13+D17+D14+D15+D16","v":0},{"$f":"E10-E11-E12-E13+E17+E14+E15+E16","v":0},0,0,0,0,0]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",null,{"$f":"+'F-4 Appropriations (Proposed)'!D45","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E45","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F45","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G45","v":0},{"$f":"'F-4 Appropriations (Proposed)'!H45","v":0},{"$f":"'F-4 Appropriations (Proposed)'!I45","v":0},{"$f":"SUM(D19:I19)","v":0}]
[null,"Unrestricted Net Position Utilized in Proposed Capital Budget",null,{"$f":"'CB-3 Capital Budget Proposed'!E11","v":0},{"$f":"'CB-3 Capital Budget Proposed'!E17","v":0},{"$f":"'CB-3 Capital Budget Proposed'!E23","v":0},{"$f":"'CB-3 Capital Budget Proposed'!E29","v":0},{"$f":"'CB-3 Capital Budget Proposed'!E35","v":0},{"$f":"'CB-3 Capital Budget Proposed'!E41","v":0},{"$f":"SUM(D20:I20)","v":0}]
[null,"Appropriation to Municipality/County (3)",null,{"$f":"+'F-4 Appropriations (Proposed)'!D37","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E37","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F37","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G37","v":0},{"$f":"'F-4 Appropriations (Proposed)'!H37","v":0},{"$f":"'F-4 Appropriations (Proposed)'!I37","v":0},{"$f":"SUM(D21:I21)","v":0}]
[null,null,"Total Unrestricted Net Position Utilized in Proposed Budget",{"$f":"SUM(D19:D21)","v":0},{"$f":"SUM(E19:E21)","v":0},0,0,0,0,0]
["PROJECTED UNRESTRICTED UNDESIGNATED NET POSITION AT END OF YEAR Last issued Audit Report (4)",null,null,{"$f":"+D18-D22","v":0},{"$f":"+E18-E22","v":0},0,0,0,0,0]
[]
["(1) Total of all operations for this line item must agree to audited financial statements. "]
["(2) Include budgeted and unbudgeted use of unrestricted net position in the current year's operations. "]
["(3) Amount may not exceed 5% of total operating appropriations. See calculation below. "]
[null,null,"Maximum Allowable Appropriation to Municipality/County",{"$f":"'F-1 Summary'!D22*0.05","v":0},{"$f":"'F-1 Summary'!E22*0.05","v":0},{"$f":"'F-1 Summary'!F22*0.05","v":0},{"$f":"'F-1 Summary'!G22*0.05","v":0},{"$f":"'F-1 Summary'!H22*0.05","v":0},{"$f":"'F-1 Summary'!I22*0.05","v":0},{"$f":"'F-1 Summary'!J22*0.05","v":0}]
["(4) If Authority is projecting a deficit for any operation at the end of the budget period, the Authority must attach a statement explaining its plan to reduce the deficit, including the timeline for elimination of the deficit, if not already detailed in the budget narrative section."]
[]
["Page F-8"]

{"sheet":"Capital Budget","index":55,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,0,12,5],[13,0,13,5],[1,0,1,5],[6,0,6,5],[7,0,7,5]]}
[]
[{"$f":"\"FISCAL YEAR \"&'KEY INPUTS'!B2&\"\"","v":"FISCAL YEAR 2023"}]
[]
[]
[]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
["(Authority Name)"]
[]
[]
[]
[]
[{"$f":"\"\"&'KEY INPUTS'!B2&\" AUTHORITY CAPITAL BUDGET/PROGRAM\"","v":"2023 AUTHORITY CAPITAL BUDGET/PROGRAM"}]

{"sheet":"CB-1 Capital Budget Cert.","index":56,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,41,8],[1,0,1,8],[4,0,4,8],[14,0,14,8],[18,0,19,8],[9,0,9,8],[26,1,26,2],[26,3,26,5],[27,1,27,2],[27,3,27,5],[28,1,28,2],[28,3,28,5],[22,1,22,2],[22,3,22,5],[23,1,23,2],[23,3,23,5],[24,3,24,5],[12,0,12,8],[13,0,13,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[21,1,21,2],[21,3,21,5],[24,1,25,2],[25,3,25,5],[12,9,12,10],[11,0,11,8],[0,0,0,8],[3,0,3,8],[5,0,5,8],[7,0,7,8],[10,0,10,8]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" CERTIFICATION OF\"","v":"2023 CERTIFICATION OF"}]
["AUTHORITY CAPITAL BUDGET / PROGRAM"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
["(Authority Name)"]
[]
[]
[{"$f":"\"Fiscal Year: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"Fiscal Year: January 01, 2023 to December 31, 2023"}]
["             "]
["Check the box for the applicable statement below:"]
["       It is hereby certified that the Authority Capital Budget/Program annexed hereto is a true copy of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["the Capital Budget/Program approved, pursuant to N.J.A.C. 5:31-2.2, along with the Annual Budget, of the"]
[{"$f":"\"governing body of the \"&'KEY INPUTS'!B5&\", on \"&TEXT(L13,\"mmmm dd, yyyy\")&\".\"","v":"governing body of the (Select Authority), on January 00, 1900."},null,null,null,null,null,null,null,null,"Approval Date:"]
[]
[{"$f":"\"       It is hereby certified that the governing body of the \"&'KEY INPUTS'!B5&\" have\"","v":"       It is hereby certified that the governing body of the (Select Authority) have"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["elected NOT to adopt and Capital Budget/Program for the aforesaid fiscal year, pursuant to N.J.A.C."]
[{"$f":"\"5:31-2.2, along with the Annual Budget by the governing body of the \"&'KEY INPUTS'!B5&\",\"","v":"5:31-2.2, along with the Annual Budget by the governing body of the (Select Authority),"}]
["for the following reason(s):"]
[]
[]
[]
[null,"Officer's Signature:"]
[null,"Name: ",null,{"$f":"'KEY INPUTS'!B41","v":0}]
[null,"Title:",null,{"$f":"'KEY INPUTS'!B42","v":0}]
[null,"Address:",null,{"$f":"'KEY INPUTS'!B43","v":0}]
[null,null,null,{"$f":"'KEY INPUTS'!B44","v":0}]
[null,"Phone Number:",null,{"$f":"'KEY INPUTS'!B45","v":0}]
[null,"Fax Number:",null,{"$f":"'KEY INPUTS'!B46","v":0}]
[null,"E-mail Address:",null,{"$f":"'KEY INPUTS'!B47","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page CB-1"]

{"sheet":"CB-2 Capital Budget Message","index":57,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[[65,2,65,3],[65,5,65,6],[65,7,65,9],[69,2,69,3],[70,0,70,10],[48,0,48,10],[60,0,60,5],[60,6,60,8],[61,0,61,5],[61,6,61,8],[23,0,27,10],[31,0,35,10],[40,0,46,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[6,0,6,10]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" CAPITAL BUDGET/PROGRAM MESSAGE\"","v":"2023 CAPITAL BUDGET/PROGRAM MESSAGE"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[]
[{"$f":"\"Fiscal Year: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"Fiscal Year: January 01, 2023 to December 31, 2023"}]
[]
["Answer all questions below using the space provided."]
[]
[]
["1. Has each municipality or county affected by the actions of the authority participated in the development of the capital plan and "]
["reviewed or approved the plans or projects included within the Capital Budget/Program (this may include the governing body or "]
["certain officials, such as planning boards, Construction Code Officials) as to these projects?"]
[]
["2. Has each capital project/project financing been developed from a specific capital improvement plan or report;"]
["does it include lifecycle costs; and is it consistent with the appropriate elements of Master Plans or other"]
["plans in the jurisdiction(s) served by the authority?"]
[]
[]
["3. Has a long-term (5 years or more) infrastructure needs and other capital items (Vehicles, Equipment)"]
["needs assessment been prepared?"]
[]
["4. If amounts are on Page CB-3 in the column Debt Authorizations, indicate the primary source of funding the debt service for the"]
["Debt Authorizations (example - rate increase). "]
[]
[]
[]
[]
[]
[]
["5. Please indicate which capital projects/project financings are being undertaken in the Metropolitan or Suburban Planning Areas "]
["as defined in the State Development and Redevelopment Plan."]
[]
[]
[]
[]
[]
[]
["6. Please indicate which capital projects/project financings are being undertaken within the boundary of a State Planning Commission-"]
["designated Center and/or Endorsed Plan and if the project was included in the Plan Implementation Agenda for that Center/Endorsed"]
["Plan. "]
[]
[]
[]
[]
[]
[]
[]
[]
["Page CB-2"]

{"sheet":"CB-3 Capital Budget Proposed","index":58,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8],[3,4,3,8],[43,0,43,8],[1,0,1,8],[46,0,46,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[{"$f":"'KEY INPUTS'!D21","v":"Operation #1"}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,{"$f":"SUM(E8:I8)","v":0}]
[null,null,0]
[null,null,0]
[null,"     Total",{"$f":"SUM(C7:C10)","v":0},null,{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F10)","v":0},{"$f":"SUM(G7:G10)","v":0},{"$f":"SUM(H7:H10)","v":0},{"$f":"SUM(I7:I10)","v":0}]
[{"$f":"'KEY INPUTS'!D22","v":"Operation #2"}]
[null,null,{"$f":"SUM(E13:I13)","v":0}]
[null,null,{"$f":"SUM(E14:I14)","v":0}]
[null,null,0]
[null,null,0]
[null,"     Total",{"$f":"SUM(C13:C16)","v":0},null,{"$f":"SUM(E13:E16)","v":0},{"$f":"SUM(F13:F16)","v":0},{"$f":"SUM(G13:G16)","v":0},{"$f":"SUM(H13:H16)","v":0},{"$f":"SUM(I13:I16)","v":0}]
[{"$f":"'KEY INPUTS'!D23","v":"Operation #3"}]
[null,null,{"$f":"SUM(E19:I19)","v":0}]
[null,null,{"$f":"SUM(E20:I20)","v":0}]
[null,null,0]
[null,null,0]
[null,"     Total",{"$f":"SUM(C19:C22)","v":0},null,{"$f":"SUM(E19:E22)","v":0},{"$f":"SUM(F19:F22)","v":0},{"$f":"SUM(G19:G22)","v":0},{"$f":"SUM(H19:H22)","v":0},{"$f":"SUM(I19:I22)","v":0}]
[{"$f":"'KEY INPUTS'!D24","v":"Operation #4"}]
[null,null,{"$f":"SUM(E25:I25)","v":0}]
[null,null,{"$f":"SUM(E26:I26)","v":0}]
[null,null,0]
[null,null,0]
[null,"     Total ",{"$f":"SUM(C25:C28)","v":0},null,{"$f":"SUM(E25:E28)","v":0},{"$f":"SUM(F25:F28)","v":0},{"$f":"SUM(G25:G28)","v":0},{"$f":"SUM(H25:H28)","v":0},{"$f":"SUM(I25:I28)","v":0}]
[{"$f":"'KEY INPUTS'!D25","v":"Operation #5"}]
[null,null,{"$f":"SUM(E31:I31)","v":0}]
[null,null,{"$f":"SUM(E32:I32)","v":0}]
[null,null,0]
[null,null,0]
[null,"     Total",{"$f":"SUM(C31:C34)","v":0},null,{"$f":"SUM(E31:E34)","v":0},{"$f":"SUM(F31:F34)","v":0},{"$f":"SUM(G31:G34)","v":0},{"$f":"SUM(H31:H34)","v":0},{"$f":"SUM(I31:I34)","v":0}]
[{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[null,null,{"$f":"SUM(E37:I37)","v":0}]
[null,null,{"$f":"SUM(E38:I38)","v":0}]
[null,null,0]
[null,null,0]
[null,"     Total ",{"$f":"SUM(C37:C40)","v":0},null,{"$f":"SUM(E37:E40)","v":0},{"$f":"SUM(F37:F40)","v":0},{"$f":"SUM(G37:G40)","v":0},{"$f":"SUM(H37:H40)","v":0},{"$f":"SUM(I37:I40)","v":0}]
["TOTAL PROPOSED CAPITAL BUDGET",null,{"$f":"+C41+C35+C29+C23+C17+C11","v":0},null,{"$f":"+E41+E35+E29+E23+E17+E11","v":0},{"$f":"+F41+F35+F29+F23+F17+F11","v":0},{"$f":"+G41+G35+G29+G23+G17+G11","v":0},{"$f":"+H41+H35+H29+H23+H17+H11","v":0},{"$f":"+I41+I35+I29+I23+I17+I11","v":0}]
[]
["Enter brief description of up to four projects for each operation above. For operations with more than four budgeted projects, please utilize the additional pages. Input total amount of all projects for the operation on single line and enter \"See Additional Pages\" instead of project description."]
[]
[]
["Page CB-3"]

{"sheet":"CB-3 Detail","index":59,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,4,3,8],[46,0,46,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"SUM(E39:I39)","v":0}]
[null,null,0]
[null,null,0]
["TOTAL THIS PAGE ONLY",null,{"$f":"SUM(C6:C41)","v":0},null,{"$f":"SUM(E6:E41)","v":0},{"$f":"SUM(F6:F41)","v":0},0,0,0]
[]
[]
[]
[]
["Page CB-3 Detail"]

{"sheet":"CB-3 Detail (2)","index":60,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,4,3,8],[46,0,46,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"SUM(E39:I39)","v":0}]
[null,null,0]
[null,null,0]
["TOTAL THIS PAGE ONLY",null,{"$f":"SUM(C6:C41)","v":0},null,{"$f":"SUM(E6:E41)","v":0},0,0,0,0]
[]
[]
[]
[]
["Page CB-3 Detail (2)"]

{"sheet":"CB-3 Detail Totals","index":61,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,4,3,8],[46,0,46,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"SUM(E39:I39)","v":0}]
[null,null,0]
[null,null,0]
["TOTAL ALL DETAIL PAGES",null,{"$f":"SUM(C6:C41)+'CB-3 Detail (2)'!C42+'CB-3 Detail'!C42","v":0},null,{"$f":"SUM(E6:E41)+'CB-3 Detail (2)'!E42+'CB-3 Detail'!E42","v":0},{"$f":"SUM(F6:F41)+'CB-3 Detail (2)'!F42+'CB-3 Detail'!F42","v":0},{"$f":"SUM(G6:G41)+'CB-3 Detail (2)'!G42+'CB-3 Detail'!G42","v":0},{"$f":"SUM(H6:H41)+'CB-3 Detail (2)'!H42+'CB-3 Detail'!H42","v":0},{"$f":"SUM(I6:I41)+'CB-3 Detail (2)'!I42+'CB-3 Detail'!I42","v":0}]
[]
[]
[]
[]
["Page CB-3 (Totals)"]

{"sheet":"CB-4 5 Year Capital Budget Cost","index":62,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,4,3,9],[43,0,43,9],[1,0,1,9],[45,0,45,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Fiscal Year Ending in"]
[null,null,"Estimated Total Cost",null,{"$f":"\"\"&'KEY INPUTS'!B2&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},{"$f":"'KEY INPUTS'!B2+1","v":2024},{"$f":"+F5+1","v":2025},{"$f":"G5+1","v":2026},{"$f":"H5+1","v":2027},{"$f":"I5+1","v":2028}]
[{"$f":"'KEY INPUTS'!D21","v":"Operation #1"}]
[null,null,{"$f":"SUM(E7:J7)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C7","v":0}]
[null,null,{"$f":"SUM(E8:J8)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C8","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C9","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C10","v":0}]
[null,"     Total",{"$f":"SUM(C7:C10)","v":0},null,{"$f":"SUM(E7:E10)","v":0},0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D22","v":"Operation #2"}]
[null,null,{"$f":"SUM(E13:J13)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C13","v":0}]
[null,null,{"$f":"SUM(E14:J14)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C14","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C15","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C16","v":0}]
[null,"     Total",{"$f":"SUM(C13:C16)","v":0},null,{"$f":"SUM(E13:E16)","v":0},0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D23","v":"Operation #3"}]
[null,null,{"$f":"SUM(E19:J19)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C19","v":0}]
[null,null,{"$f":"SUM(E20:J20)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C20","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C21","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C22","v":0}]
[null,"     Total",{"$f":"SUM(C19:C22)","v":0},null,{"$f":"SUM(E19:E22)","v":0},0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D24","v":"Operation #4"}]
[null,null,{"$f":"SUM(E25:J25)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C25","v":0}]
[null,null,{"$f":"SUM(E26:J26)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C26","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C27","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C28","v":0}]
[null,"     Total ",{"$f":"SUM(C25:C28)","v":0},null,{"$f":"SUM(E25:E28)","v":0},0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D25","v":"Operation #5"}]
[null,null,{"$f":"SUM(E31:J31)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C31","v":0}]
[null,null,{"$f":"SUM(E32:J32)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C32","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C33","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C34","v":0}]
[null,"     Total",{"$f":"SUM(C31:C34)","v":0},null,{"$f":"SUM(E31:E34)","v":0},0,0,0,0,0]
[{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[null,null,{"$f":"SUM(E37:J37)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C37","v":0}]
[null,null,{"$f":"SUM(E38:J38)","v":0},null,{"$f":"'CB-3 Capital Budget Proposed'!C38","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C39","v":0}]
[null,null,0,null,{"$f":"'CB-3 Capital Budget Proposed'!C40","v":0}]
[null,"     Total ",{"$f":"SUM(C37:C40)","v":0},null,{"$f":"SUM(E37:E40)","v":0},0,0,0,0,0]
["TOTAL ",null,{"$f":"+C41+C35+C29+C23+C17+C11","v":0},null,{"$f":"+E41+E35+E29+E23+E17+E11","v":0},0,0,0,0,0]
[]
[]
[]
["Page CB-4"]

{"sheet":"CB-4 Detail","index":63,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[3,4,3,9],[43,0,43,9],[45,0,45,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Fiscal Year Ending in"]
[null,null,"Estimated Total Cost",null,{"$f":"\"\"&'KEY INPUTS'!B2&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},{"$f":"'KEY INPUTS'!B2+1","v":2024},{"$f":"+F5+1","v":2025},{"$f":"G5+1","v":2026},{"$f":"H5+1","v":2027},{"$f":"I5+1","v":2028}]
[null,null,{"$f":"SUM(E6:J6)","v":0}]
[null,null,{"$f":"SUM(E7:J7)","v":0}]
[null,null,{"$f":"SUM(E8:J8)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"SUM(E38:J38)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL THIS PAGE ONLY",null,{"$f":"SUM(C6:C41)","v":0},null,{"$f":"SUM(E6:E41)","v":0},{"$f":"SUM(F6:F41)","v":0},0,0,0,0]
[]
[]
[]
["Page CB-4 Detail"]

{"sheet":"CB-4 Detail (2)","index":64,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[3,4,3,9],[43,0,43,9],[45,0,45,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Fiscal Year Ending in"]
[null,null,"Estimated Total Cost",null,{"$f":"\"\"&'KEY INPUTS'!B2&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},{"$f":"'KEY INPUTS'!B2+1","v":2024},{"$f":"+F5+1","v":2025},{"$f":"G5+1","v":2026},{"$f":"H5+1","v":2027},{"$f":"I5+1","v":2028}]
[null,null,{"$f":"SUM(E6:J6)","v":0}]
[null,null,{"$f":"SUM(E7:J7)","v":0}]
[null,null,{"$f":"SUM(E8:J8)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL THIS PAGE ONLY",null,{"$f":"SUM(C6:C41)","v":0},null,{"$f":"SUM(E6:E41)","v":0},{"$f":"SUM(F6:F41)","v":0},0,0,0,0]
[]
[]
[]
["Page CB-4 Detail (2)"]

{"sheet":"CB-4 Detail Totals","index":65,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[3,4,3,9],[43,0,43,9],[45,0,45,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Fiscal Year Ending in"]
[null,null,"Estimated Total Cost",null,{"$f":"\"\"&'KEY INPUTS'!B2&\" (Proposed Budget)\"","v":"2023 (Proposed Budget)"},{"$f":"'KEY INPUTS'!B2+1","v":2024},{"$f":"+F5+1","v":2025},{"$f":"G5+1","v":2026},{"$f":"H5+1","v":2027},{"$f":"I5+1","v":2028}]
[null,null,{"$f":"SUM(E6:J6)","v":0}]
[null,null,{"$f":"SUM(E7:J7)","v":0}]
[null,null,{"$f":"SUM(E8:J8)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL ALL DETAIL PAGES",null,{"$f":"SUM(C6:C41)+'CB-4 Detail'!C42+'CB-4 Detail (2)'!C42","v":0},null,{"$f":"SUM(E6:E41)+'CB-4 Detail'!E42+'CB-4 Detail (2)'!E42","v":0},{"$f":"SUM(F6:F41)+'CB-4 Detail'!F42+'CB-4 Detail (2)'!F42","v":0},{"$f":"SUM(G6:G41)+'CB-4 Detail'!G42+'CB-4 Detail (2)'!G42","v":0},{"$f":"SUM(H6:H41)+'CB-4 Detail'!H42+'CB-4 Detail (2)'!H42","v":0},{"$f":"SUM(I6:I41)+'CB-4 Detail'!I42+'CB-4 Detail (2)'!I42","v":0},{"$f":"SUM(J6:J41)+'CB-4 Detail'!J42+'CB-4 Detail (2)'!J42","v":0}]
[]
[]
[]
["Page CB-4 Detail (Totals)"]

{"sheet":"CB-5 5 Year Capital Budget Fund","index":66,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,8],[3,4,3,8],[45,0,45,8],[1,0,1,8],[47,0,47,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[{"$f":"'KEY INPUTS'!D21","v":"Operation #1"}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,{"$f":"SUM(E8:I8)","v":0}]
[null,null,0]
[null,null,0]
[null,"     Total",{"$f":"SUM(C7:C10)","v":0},null,{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F10)","v":0},{"$f":"SUM(G7:G10)","v":0},{"$f":"SUM(H7:H10)","v":0},{"$f":"SUM(I7:I10)","v":0}]
[{"$f":"'KEY INPUTS'!D22","v":"Operation #2"}]
[null,null,{"$f":"SUM(E13:I13)","v":0}]
[null,null,{"$f":"SUM(E14:I14)","v":0}]
[null,null,{"$f":"SUM(E15:I15)","v":0}]
[null,null,{"$f":"SUM(E16:I16)","v":0}]
[null,"     Total",{"$f":"SUM(C13:C16)","v":0},null,{"$f":"SUM(E13:E16)","v":0},{"$f":"SUM(F13:F16)","v":0},{"$f":"SUM(G13:G16)","v":0},{"$f":"SUM(H13:H16)","v":0},{"$f":"SUM(I13:I16)","v":0}]
[{"$f":"'KEY INPUTS'!D23","v":"Operation #3"}]
[null,null,{"$f":"SUM(E19:I19)","v":0}]
[null,null,{"$f":"SUM(E20:I20)","v":0}]
[null,null,{"$f":"SUM(E21:I21)","v":0}]
[null,null,{"$f":"SUM(E22:I22)","v":0}]
[null,"     Total",{"$f":"SUM(C19:C22)","v":0},null,{"$f":"SUM(E19:E22)","v":0},{"$f":"SUM(F19:F22)","v":0},{"$f":"SUM(G19:G22)","v":0},{"$f":"SUM(H19:H22)","v":0},{"$f":"SUM(I19:I22)","v":0}]
[{"$f":"'KEY INPUTS'!D24","v":"Operation #4"}]
[null,null,{"$f":"SUM(E25:I25)","v":0}]
[null,null,{"$f":"SUM(E26:I26)","v":0}]
[null,null,{"$f":"SUM(E27:I27)","v":0}]
[null,null,{"$f":"SUM(E28:I28)","v":0}]
[null,"     Total ",{"$f":"SUM(C25:C28)","v":0},null,{"$f":"SUM(E25:E28)","v":0},{"$f":"SUM(F25:F28)","v":0},{"$f":"SUM(G25:G28)","v":0},{"$f":"SUM(H25:H28)","v":0},{"$f":"SUM(I25:I28)","v":0}]
[{"$f":"'KEY INPUTS'!D25","v":"Operation #5"}]
[null,null,{"$f":"SUM(E31:I31)","v":0}]
[null,null,{"$f":"SUM(E32:I32)","v":0}]
[null,null,{"$f":"SUM(E33:I33)","v":0}]
[null,null,{"$f":"SUM(E34:I34)","v":0}]
[null,"     Total",{"$f":"SUM(C31:C34)","v":0},null,{"$f":"SUM(E31:E34)","v":0},{"$f":"SUM(F31:F34)","v":0},{"$f":"SUM(G31:G34)","v":0},{"$f":"SUM(H31:H34)","v":0},{"$f":"SUM(I31:I34)","v":0}]
[{"$f":"'KEY INPUTS'!D26","v":"Operation #6"}]
[null,null,{"$f":"SUM(E37:I37)","v":0}]
[null,null,{"$f":"SUM(E38:I38)","v":0}]
[null,null,{"$f":"SUM(E39:I39)","v":0}]
[null,null,{"$f":"SUM(E40:I40)","v":0}]
[null,"     Total ",{"$f":"SUM(C37:C40)","v":0},null,{"$f":"SUM(E37:E40)","v":0},{"$f":"SUM(F37:F40)","v":0},{"$f":"SUM(G37:G40)","v":0},{"$f":"SUM(H37:H40)","v":0},{"$f":"SUM(I37:I40)","v":0}]
["TOTAL ",null,{"$f":"+C41+C35+C29+C23+C17+C11","v":0},null,{"$f":"+E41+E35+E29+E23+E17+E11","v":0},{"$f":"+F41+F35+F29+F23+F17+F11","v":0},{"$f":"+G41+G35+G29+G23+G17+G11","v":0},{"$f":"+H41+H35+H29+H23+H17+H11","v":0},{"$f":"+I41+I35+I29+I23+I17+I11","v":0}]
[null,"Total 5 Year Plan per CB-4",{"$f":"'CB-4 5 Year Capital Budget Cost'!C42","v":0}]
[null,"Balance check",{"$f":"C42-C43","v":0},"If amount is other than zero, verify that projects listed above match projects listed on CB-4."]
[]
[]
[]
["Page CB-5"]

{"sheet":"CB-5 Detail","index":67,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,4,3,8],[45,0,45,8],[47,0,47,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,{"$f":"SUM(E8:I8)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL THIS PAGE ONLY",null,{"$f":"SUM(C6:C41)","v":0},null,{"$f":"SUM(E6:E41)","v":0},0,0,0,0]
[]
[]
[]
[]
[]
["Page CB-5 Detail"]

{"sheet":"CB-5 Detail (2)","index":68,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,4,3,8],[45,0,45,8],[47,0,47,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,{"$f":"SUM(E8:I8)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL THIS PAGE ONLY",null,{"$f":"SUM(C6:C41)","v":0},null,{"$f":"SUM(E6:E41)","v":0},0,0,0,0]
[]
[]
[]
[]
[]
["Page CB-5 Detail (2)"]

{"sheet":"CB-5 Detail Totals","index":69,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,4,3,8],[45,0,45,8],[47,0,47,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: January 01, 2023 to December 31, 2023"}]
[]
[null,null,null,null,"Funding Sources"]
[null,null,"Estimated Total Cost",null,"Unrestricted Net Position Utilized","Renewal & Replacement Reserve","Debt Authorization","Capital Grants","Other Sources"]
[null,null,{"$f":"SUM(E6:I6)","v":0}]
[null,null,{"$f":"SUM(E7:I7)","v":0}]
[null,null,{"$f":"SUM(E8:I8)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL ALL DETAIL PAGES",null,{"$f":"SUM(C6:C41)+'CB-5 Detail (2)'!C42+'CB-5 Detail'!C42","v":0},null,{"$f":"SUM(E6:E41)+'CB-5 Detail (2)'!E42+'CB-5 Detail'!E42","v":0},{"$f":"SUM(F6:F41)+'CB-5 Detail (2)'!F42+'CB-5 Detail'!F42","v":0},{"$f":"SUM(G6:G41)+'CB-5 Detail (2)'!G42+'CB-5 Detail'!G42","v":0},{"$f":"SUM(H6:H41)+'CB-5 Detail (2)'!H42+'CB-5 Detail'!H42","v":0},{"$f":"SUM(I6:I41)+'CB-5 Detail (2)'!I42+'CB-5 Detail'!I42","v":0}]
[]
[]
[]
[]
[]
["Page CB-5 Detail (Totals)"]

{"sheet":"Appendix-Change Orders","index":70,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,16],[3,1,3,16],[37,3,37,5],[39,1,39,16],[6,3,6,9],[6,13,6,16],[37,10,37,14],[36,10,36,14]]}
[]
[]
[null,"Annual List of Change Orders Approved"]
[null,"Pursuant to N.J.A.C. 5:30-11"]
[]
[]
[null,"Contracting Unit:",null,{"$f":"'KEY INPUTS'!B5","v":"(Select Authority)"},null,null,null,null,null,null,null,"Year Ending:",null,{"$f":"DATE(YEAR('KEY INPUTS'!B4)-2,MONTH('KEY INPUTS'!B4),DAY('KEY INPUTS'!B4))","v":"2021-12-31"}]
[]
[null,null,"The following is a complete list of all change orders which caused the originally awarded contract price to be exceeded by more than 20 percent.  For regulatory details"]
[null,"please consult N.J.A.C. 5:30-11.1 et seq.  Please identify each change order by name of the project."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"For each change order listed above, submit with introduced budget a copy of the governing body resolution authorizing the change order and an Affidavit of Publication for"]
[null,"the newspaper notice required by N.J.A.C. 5:30-11.9(d).  (Affidavit must include a copy of the newspaper notice.)"]
[null,null,"If you have not had a change order exceeding the 20 percent threshold for the year indicated above, please check here ",null,null,null,null,null,null,null,null,null,null,"    and certify below."]
[]
[]
[null,null,null,"Date",null,null,null,null,null,null,"Clerk/Secretary to the Governing Body"]
[]
[null,"Appendix to Budget Document"]