{"text_format":"1","workbook":"xlsx","n_sheets":53,"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)","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)Total","Shared Services (N-7)","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-7 Debt Service-Interest","F-8 Net Position","Capital Budget","CB-1 Capital Budget Cert.","CB-2 Capital Budget Message","CB-3 Capital Budget Proposed","CB-4 5 Year Capital Budget Cost","CB-5 5 Year Capital Budget Fund","Appendix-Change Orders"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":11,"defined_names":75,"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":86,"n_cols":1,"rows_kept":86,"cut":false,"hidden":true,"merged":[]}
["(Select Housing Authority)"]
["Asbury Park Housing Authority"]
["Atlantic City Housing Authority"]
["Bayonne Housing Authority"]
["Belmar Housing Authority"]
["Bergen County Housing Authority"]
["Berkeley Township Housing Authority"]
["Beverly Housing Authority"]
["Boonton Town Housing Authority"]
["Brick Township Housing Authority"]
["Bridgeton Housing Authority"]
["Buena Housing Authority"]
["Burlington City Housing Authority"]
["Camden City Housing Authority"]
["Cape May Housing Authority"]
["Carteret Housing Authority"]
["Clementon Housing Authority"]
["Cliffside Park Housing Authority"]
["Collingswood Housing Authority"]
["Dover Housing Authority"]
["East Orange Housing Authority"]
["Edgewater Housing Authority"]
["Edison Housing Authority"]
["Elizabeth City Housing Authority"]
["Englewood Housing Authority"]
["Florence Township Housing Authority"]
["Fort Lee Housing Authority"]
["Franklin Township Housing Authority"]
["Freehold Borough Housing Authority"]
["Garfield Housing Authority"]
["Glassboro Housing Authority"]
["Gloucester City Housing Authority"]
["Gloucester County Housing Authority"]
["Gloucester Township Housing Authority"]
["Guttenberg Housing Authority"]
["Hackensack Housing Authority"]
["Haddon Township Housing Authority"]
["Harrison Town Housing Authority"]
["Highland Park Housing Authority"]
["Highlands Housing Authority"]
["Hightstown Housing Authority"]
["Hoboken Housing Authority"]
["Irvington Housing Authority"]
["Jersey City Housing Authority"]
["Keansburg Housing Authority"]
["Lakewood Housing Authority"]
["Linden Housing Authority"]
["Lodi Housing Authority"]
["Long Branch Housing Authority"]
["Madison Borough Housing Authority"]
["Middletown Housing Authority"]
["Millville Housing Authority"]
["Morris County Housing Authority"]
["Morristown Housing Authority"]
["Neptune City Housing Authority"]
["Neptune Township Housing Authority"]
["New Brunswick Housing Authority"]
["Newark Housing Authority"]
["Newton Housing Authority"]
["North Bergen Housing Authority"]
["Ocean City Housing Authority"]
["Old Bridge Housing Authority"]
["Orange City Housing Authority"]
["Passaic City Housing Authority"]
["Paterson Housing Authority"]
["Penns Grove Housing Authority"]
["Pennsauken Housing Authority"]
["Perth Amboy Housing Authority"]
["Phillipsburg Housing Authority"]
["Plainfield Housing Authority"]
["Pleasantville Housing Authority"]
["Princeton Housing Authority"]
["Rahway Housing Authority"]
["Red Bank Housing Authority"]
["Salem Housing Authority"]
["Sayreville Housing Authority"]
["Secaucus Housing Authority"]
["South Amboy Housing Authority"]
["Summit Housing Authority"]
["Trenton Housing Authority"]
["Union City Housing Authority"]
["Vineland Housing Authority"]
["Weehawken Housing Authority"]
["West New York Housing Authority"]
["Wildwood Housing Authority"]
["Woodbridge Housing Authority"]

{"sheet":"KEY METRICS","index":1,"n_rows":291,"n_cols":4,"rows_kept":291,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["HOUSING 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(#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!)","v":{"$error":"#REF!"}}]
[null,"Dollar Value of Accrued Compensated Absence Liability",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Shared Services"]
[null,"Total Amount to be Received by/Paid from Authority",{"$f":"SUM('Shared Services (N-7)'!G7:G29)","v":0}]
[]
[null,"Revenues"]
[null,"Public Housing Management"]
[null,"Rental Fees",{"$f":"'F-2 Revenues (Proposed)'!D15","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D15","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!D37","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D37","v":0}]
[null,"Total Operating Revenue",{"$f":"SUM(C28:C29)","v":0},{"$f":"SUM(D28:D29)","v":0}]
[]
[null,"Other Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!D47","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D47","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!D52","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!D52","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"SUM(C32:C33)","v":0},{"$f":"SUM(D32:D33)","v":0}]
[]
[null,"Total Anticipated Revenues - Public Housing Management",{"$f":"C30+C34","v":0},{"$f":"D30+D34","v":0}]
[]
[null,"Section 8"]
[null,"Rental Fees",{"$f":"'F-2 Revenues (Proposed)'!E15","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E15","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!E37","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E37","v":0}]
[null,"Total Operating Revenue",{"$f":"SUM(C39:C40)","v":0},{"$f":"SUM(D39:D40)","v":0}]
[]
[null,"Other Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!E47","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E47","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!E52","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!E52","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"SUM(C43:C44)","v":0},{"$f":"SUM(D43:D44)","v":0}]
[]
[null,"Total Anticipated Revenues - Section 8",{"$f":"C41+C45","v":0},{"$f":"D41+D45","v":0}]
[]
[null,"Housing Voucher"]
[null,"Rental Fees",{"$f":"'F-2 Revenues (Proposed)'!F15","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F15","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!F37","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F37","v":0}]
[null,"Total Operating Revenue",{"$f":"SUM(C50:C51)","v":0},{"$f":"SUM(D50:D51)","v":0}]
[]
[null,"Other Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!F47","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F47","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!F52","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!F52","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"SUM(C54:C55)","v":0},{"$f":"SUM(D54:D55)","v":0}]
[]
[null,"Total Anticipated Revenues - Housing Voucher",{"$f":"C52+C56","v":0},{"$f":"D52+D56","v":0}]
[]
[null,"Other Programs"]
[null,"Rental Fees",{"$f":"'F-2 Revenues (Proposed)'!G15","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G15","v":0}]
[null,"Other Revenue",{"$f":"'F-2 Revenues (Proposed)'!G37","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G37","v":0}]
[null,"Total Operating Revenue",{"$f":"SUM(C61:C62)","v":0},{"$f":"SUM(D61:D62)","v":0}]
[]
[null,"Other Non-Operating Revenue",{"$f":"'F-2 Revenues (Proposed)'!G47","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G47","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"'F-2 Revenues (Proposed)'!G52","v":0},{"$f":"'F-3 Revenues (PY Adopted)'!G52","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"SUM(C65:C66)","v":0},{"$f":"SUM(D65:D66)","v":0}]
[]
[null,"Total Anticipated Revenues - Other Programs",{"$f":"C63+C67","v":0},{"$f":"D63+D67","v":0}]
[]
[null,"Total Rental Fees - All Programs",{"$f":"C28+C39+C50+C61","v":0},{"$f":"D28+D39+D50+D61","v":0}]
[null,"Total Other Revenue - All Programs",{"$f":"C40+C51+C62","v":0},{"$f":"D40+D51+D62","v":0}]
[null,"Total Operating Revenue - All Programs",{"$f":"SUM(C71:C72)","v":0},{"$f":"SUM(D71:D72)","v":0}]
[null,"Other Non-Operating Revenue",{"$f":"C32+C43+C54+C65","v":0},{"$f":"D32+D43+D54+D65","v":0}]
[null,"Interest on Investments and Deposits",{"$f":"C44+C55+C66+C33","v":0},{"$f":"D44+D55+D66+D33","v":0}]
[null,"Total Non-Operating Revenue",{"$f":"SUM(C74:C75)","v":0},{"$f":"SUM(D74:D75)","v":0}]
[]
[null,"GRAND TOTAL - ANTICIPATED REVENUES (All Operations)",{"$f":"C73+C76","v":0},{"$f":"D73+D76","v":0}]
[]
[]
[null,"Appropriations"]
[null,"Public Housing Management"]
[null,"Administration",{"$f":"'F-4 Appropriations (Proposed)'!D16","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D16","v":0}]
[null,"Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!D37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D37","v":0}]
[null,"Total Operating Appropriations",{"$f":"SUM(C83:C84)","v":0},{"$f":"SUM(D83:D84)","v":0}]
[]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!D42","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D42","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!D43","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D43","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!D44","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D44","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!D45","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D45","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"SUM(C87:C90)","v":0},{"$f":"SUM(D87:D90)","v":0}]
[]
[null,"Total Appropriations - Public Housing Management",{"$f":"C85+C91","v":0},{"$f":"D85+D91","v":0}]
[]
[null,"Accumulated Deficit - Public Housing Management",{"$f":"'F-4 Appropriations (Proposed)'!D48","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D48","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Public Housing Management",{"$f":"'F-4 Appropriations (Proposed)'!D53","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!D53","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Public Housing Management",{"$f":"C93+C95-C97","v":0},{"$f":"D93+D95-D97","v":0}]
[]
[null,"Section 8"]
[null,"Administration",{"$f":"'F-4 Appropriations (Proposed)'!E16","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E16","v":0}]
[null,"Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!E37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E37","v":0}]
[null,"Total Operating Appropriations",{"$f":"SUM(C102:C103)","v":0},{"$f":"SUM(D102:D103)","v":0}]
[]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!E42","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E42","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!E43","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E43","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!E44","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E44","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!E45","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E45","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"SUM(C106:C109)","v":0},{"$f":"SUM(D106:D109)","v":0}]
[]
[null,"Total Appropriations - Section 8",{"$f":"C104+C110","v":0},{"$f":"D104+D110","v":0}]
[]
[null,"Accumulated Deficit - Section 8",{"$f":"'F-4 Appropriations (Proposed)'!E48","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E48","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Section 8",{"$f":"'F-4 Appropriations (Proposed)'!E53","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!E53","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Section 8",{"$f":"C112+C114-C116","v":0},{"$f":"D112+D114-D116","v":0}]
[]
[null,"Housing Voucher"]
[null,"Administration",{"$f":"'F-4 Appropriations (Proposed)'!F16","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F16","v":0}]
[null,"Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!F37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F37","v":0}]
[null,"Total Operating Appropriations",{"$f":"SUM(C121:C122)","v":0},{"$f":"SUM(D121:D122)","v":0}]
[]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!F42","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F42","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!F43","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F43","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!F44","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F44","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!F45","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F45","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"SUM(C125:C128)","v":0},{"$f":"SUM(D125:D128)","v":0}]
[]
[null,"Total Appropriations - Housing Voucher",{"$f":"C123+C129","v":0},{"$f":"D123+D129","v":0}]
[]
[null,"Accumulated Deficit - Housing Voucher",{"$f":"'F-4 Appropriations (Proposed)'!F48","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F48","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Housing Voucher",{"$f":"'F-4 Appropriations (Proposed)'!F53","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!F53","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Housing Voucher",{"$f":"C131+C133-C135","v":0},{"$f":"D131+D133-D135","v":0}]
[]
[null,"Other Programs"]
[null,"Administration",{"$f":"'F-4 Appropriations (Proposed)'!G16","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G16","v":0}]
[null,"Cost of Providing Services",{"$f":"'F-4 Appropriations (Proposed)'!G37","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G37","v":0}]
[null,"Total Operating Appropriations",{"$f":"SUM(C140:C141)","v":0},{"$f":"SUM(D140:D141)","v":0}]
[]
[null,"Operations & Maintenance Reserve",{"$f":"'F-4 Appropriations (Proposed)'!G42","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G42","v":0}]
[null,"Renewal & Replacement Reserve",{"$f":"'F-4 Appropriations (Proposed)'!G43","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G43","v":0}]
[null,"Municipality/County Appropriation",{"$f":"'F-4 Appropriations (Proposed)'!G44","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G44","v":0}]
[null,"Other Reserves",{"$f":"'F-4 Appropriations (Proposed)'!G45","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G45","v":0}]
[null,"Total Non-Operating Appropriations",{"$f":"SUM(C144:C147)","v":0},{"$f":"SUM(D144:D147)","v":0}]
[]
[null,"Total Appropriations - Other Programs",{"$f":"C142+C148","v":0},{"$f":"D142+D148","v":0}]
[]
[null,"Accumulated Deficit - Other Programs",{"$f":"'F-4 Appropriations (Proposed)'!G48","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G48","v":0}]
[]
[null,"Total Unrestricted Net Position Utilized - Other Programs",{"$f":"'F-4 Appropriations (Proposed)'!G53","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!G53","v":0}]
[]
[null,"TOTAL NET APPROPRIATIONS - Other Programs",{"$f":"C150+C152-C154","v":0},{"$f":"D150+D152-D154","v":0}]
[]
[null,"GRAND TOTAL NET APPROPRIATIONS - ALL PROGRAMS*",{"$f":"'F-4 Appropriations (Proposed)'!H54","v":0},{"$f":"'F-5 Appropriations (PY Adopted)'!H54","v":0}]
[null,"*Includes debt service amounts excluded from individual program totals. "]
[]
[null,"Debt Service"]
[null,"Principal:"]
[null,"Total Principal",{"$f":"'F-6 Debt Service-Principal'!H15","v":0},{"$f":"'F-6 Debt Service-Principal'!F15","v":0}]
[null,"Less: HUD Subsidy",{"$f":"'F-6 Debt Service-Principal'!H16","v":0},{"$f":"'F-6 Debt Service-Principal'!F16","v":0}]
[null,"Net Principal ",{"$f":"'F-6 Debt Service-Principal'!H17","v":0},{"$f":"'F-6 Debt Service-Principal'!F17","v":0}]
[]
[null,"Total Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P15","v":0}]
[null,"Less: HUD Subsidy",{"$f":"'F-6 Debt Service-Principal'!P16","v":0}]
[null,"Net Principal Outstanding",{"$f":"'F-6 Debt Service-Principal'!P17","v":0}]
[]
[null,"Interest:"]
[null,"Total Interest",{"$f":"'F-7 Debt Service-Interest'!F15","v":0},{"$f":"'F-7 Debt Service-Interest'!D15","v":0}]
[null,"Less: HUD Subsidy",{"$f":"'F-7 Debt Service-Interest'!F16","v":0},{"$f":"'F-7 Debt Service-Interest'!D16","v":0}]
[null,"Net Interest",{"$f":"'F-7 Debt Service-Interest'!F17","v":0},{"$f":"'F-7 Debt Service-Interest'!D17","v":0}]
[]
[null,"Total Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N15","v":0}]
[null,"Less: HUD Subsidy",{"$f":"'F-7 Debt Service-Interest'!N16","v":0}]
[null,"Net Interest Outstanding",{"$f":"'F-7 Debt Service-Interest'!N17","v":0}]
[]
[null,"Bond Rating:"]
[null,"Moody's",{"$f":"'F-6 Debt Service-Principal'!D22","v":0}]
[null,"Year",{"$f":"'F-6 Debt Service-Principal'!D23","v":0}]
[]
[null,"S&P ",{"$f":"'F-6 Debt Service-Principal'!H22","v":0}]
[null,"Year",{"$f":"'F-6 Debt Service-Principal'!H23","v":0}]
[]
[null,"Fitch",{"$f":"'F-6 Debt Service-Principal'!F22","v":0}]
[null,"Year",{"$f":"'F-6 Debt Service-Principal'!F23","v":0}]
[]
[null,"Net Position"]
[null,"Public Housing Management"]
[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":"SUM(C196:C198)","v":0}]
[]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!D23","v":0}]
[]
[null,"Section 8"]
[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":"SUM(C208:C210)","v":0}]
[]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!E23","v":0}]
[]
[null,"Housing Voucher"]
[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":"SUM(C220:C222)","v":0}]
[]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!F23","v":0}]
[]
[null,"Other Programs"]
[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":"SUM(C232:C234)","v":0}]
[]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!G23","v":0}]
[]
[null,"TOTALS"]
[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":"SUM(C244:C246)","v":0}]
[]
[null,"Projected Unrestricted, Undesignated Net Position at End of Year",{"$f":"'F-8 Net Position'!H23","v":0}]
[]
[]
[null,"Capital Budget"]
[null,"Public Housing Management:"]
[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,"Section 8:"]
[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,"Housing Voucher:"]
[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,"Other Programs:"]
[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,"Total Unrestricted Net Position",{"$f":"'CB-3 Capital Budget Proposed'!E30","v":0}]
[null,"Total Renewal & Replacement Reserve",{"$f":"'CB-3 Capital Budget Proposed'!F30","v":0}]
[null,"Total Debt Authorization",{"$f":"'CB-3 Capital Budget Proposed'!G30","v":0}]
[null,"Total Capital Grants",{"$f":"'CB-3 Capital Budget Proposed'!H30","v":0}]
[null,"Total Other Sources",{"$f":"'CB-3 Capital Budget Proposed'!I30","v":0}]
[]
[null,"Total Proposed Capital Budget",{"$f":"'CB-3 Capital Budget Proposed'!C30","v":0}]

{"sheet":"Mandatory Entry Checklist","index":2,"n_rows":102,"n_cols":3,"rows_kept":102,"cut":false,"hidden":true,"merged":[[1,0,1,2],[97,0,97,1],[88,0,88,1],[84,0,84,1],[78,0,78,1],[74,0,74,1],[68,0,68,1],[60,0,60,1],[55,0,55,1],[44,0,44,1],[83,0,83,1],[87,0,87,1],[91,0,91,1],[96,0,96,1],[2,0,2,2],[29,0,29,1],[73,0,73,1],[92,0,92,1],[77,0,77,1],[39,0,39,1],[43,0,43,1],[54,0,54,1],[59,0,59,1],[67,0,67,1],[40,0,40,1],[5,0,5,1],[15,0,15,1],[19,0,19,1],[24,0,24,1],[28,0,28,1],[16,0,16,1],[6,0,6,1],[25,0,25,1],[20,0,20,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":{"$error":"#REF!"}}]
[]
[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 Housing 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":"Complete"},"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":"Complete"},"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":"Complete"},"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":{"$error":"#REF!"}}]
["Certifications",{"$f":"IF(OR('Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE,'Internet Cert. (C-3)'!#REF!<>TRUE),\"Incomplete\",\"Complete\")","v":{"$error":"#REF!"}}]
["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)'!I33)=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)'!A31)=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)'!H23)=TRUE,ISBLANK('Questionnaire (N-3)'!H24)=TRUE,ISBLANK('Questionnaire (N-3)'!H25)=TRUE,ISBLANK('Questionnaire (N-3)'!C31)=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":{"$error":"#REF!"}}]
["Accumulated Absences",{"$f":"IF(OR(ISBLANK(#REF!)=TRUE,ISBLANK(#REF!)=TRUE,ISBLANK(#REF!)=TRUE,AND(#REF!=\"\",#REF!=\"\",#REF!=\"\")),\"Incomplete\",\"Complete\")","v":{"$error":"#REF!"}},"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.'!AE11=TRUE,'CB-1 Capital Budget Cert.'!AE15=TRUE),\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Officer Signature",{"$f":"IF(OR(ISBLANK('CB-1 Capital Budget Cert.'!F22)=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'!I16)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Question #2",{"$f":"IF(OR(ISBLANK('CB-2 Capital Budget Message'!I19)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Question #3",{"$f":"IF(OR(ISBLANK('CB-2 Capital Budget Message'!I22)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Question #5",{"$f":"IF(OR(ISBLANK('CB-2 Capital Budget Message'!I30)=TRUE),\"Incomplete\",\"Complete\")","v":"Incomplete"}]

{"sheet":"Instructions","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,7],[0,0,0,1],[0,2,0,7]]}
["General Instructions to Complete the Housing Authority Budget Workbook",null,"Housing Authority Budget Template Version 2024-2025"]
["**This version of the authority budget template is required to be used for all housing authority budget cycles with a start date of July 1, 2024 and later.**",null,null,null,null,null,null,null,null,null,null,"FAST"]
["a)","This workbook shall be used for completing the Housing 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 B2 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 certifying 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],[9,2,9,3],[8,0,8,1],[17,0,17,1],[26,0,26,1]]}
["Fiscal Year Begin:",2024,"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:",2025,"Commissioner #1",null,null,null,{"$f":"B1","v":2024}]
["Begin Date:","2024-07-01","Commissioner #2",null,null,null,{"$f":"B1+1","v":2025}]
["End Date: ",{"$f":"EDATE(B3,12)-1","v":"2025-06-30"},"Commissioner #3"]
["Authority Name:","(Select Housing Authority)","Commissioner #4"]
["Web Address",null,"Commissioner #5"]
[null,null,"Commissioner #6"]
["Certification Sections",null,"Commissioner #7"]
["Preparer Certification"]
["Preparer Name"]
["Title"]
["Address"]
["Address 2"]
["Phone "]
["Fax"]
["Email"]
[]
["Approval Certification"]
["Officer's Name"]
["Title"]
["Address"]
["Address 2"]
["Phone"]
["Fax "]
["Email"]
[]
["Internet Certification",null,"If same as \"Approval Certification\", enter an \"X\" in this box:"]
["Officer's Name",{"$f":"IF(E27 = \"X\", B19,\"\")","v":""}]
["Title",{"$f":"IF(E27 = \"X\", B20,\"\")","v":""}]
[]
["Adoption Certification",null,"If same as \"Approval Certification\", enter an \"X\" in this box:"]
["Officer's Name",{"$f":"IF(E31 = \"X\",B19,\"\")","v":""}]
["Title",{"$f":"IF(E31 = \"X\",B20,\"\")","v":""}]
["Address",{"$f":"IF(E31 = \"X\",B21,\"\")","v":""}]
["Address 2",{"$f":"IF(E31 = \"X\",B22,\"\")","v":""}]
["Phone ",{"$f":"IF(E31 = \"X\",B23,\"\")","v":""}]
["Fax",{"$f":"IF(E31 = \"X\",B24,\"\")","v":""}]
["Email",{"$f":"IF(E31 = \"X\",B25,\"\")","v":""}]
[]
["Capital Budget/Program Certification",null,"If same as \"Approval Certification\", enter an \"X\" in this box:"]
["Officer's Name",{"$f":"IF(E40=\"X\",B19,\"\")","v":""}]
["Title",{"$f":"IF(E40=\"X\",B20,\"\")","v":""}]
["Address",{"$f":"IF(E40=\"X\",B21,\"\")","v":""}]
["Address 2",{"$f":"IF(E40=\"X\",B22,\"\")","v":""}]
["Phone ",{"$f":"IF(E40=\"X\",B23,\"\")","v":""}]
["Fax",{"$f":"IF(E40=\"X\",B24,\"\")","v":""}]
["Email",{"$f":"IF(E40=\"X\",B25,\"\")","v":""}]

{"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":2024},"_",{"$f":"YEAR('KEY INPUTS'!B4)","v":2025}]
[]
[null,"Housing Authority Budget of:"]
[null,{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[null,"State Filing Year",null,{"$f":"'KEY INPUTS'!B2","v":2025}]
[]
[null,"For the Period:",null,{"$f":"'KEY INPUTS'!B3","v":"2024-07-01"},"to",{"$f":"'KEY INPUTS'!B4","v":"2025-06-30"}]
[]
[]
[]
[null,{"$f":"'KEY INPUTS'!B6","v":0}]
[null,"Housing 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&\" HOUSING AUTHORITY BUDGET\"","v":"2025 HOUSING 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":[[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],[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],[8,0,8,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[6,0,6,8]]}
[{"$f":"'KEY INPUTS'!B2","v":2025}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
["HOUSING AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["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":[[39,0,39,9],[20,1,21,2],[21,3,21,5],[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],[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],[9,0,9,9],[0,0,0,9],[2,0,2,9],[4,0,4,9],[6,0,6,9],[8,0,8,9]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" PREPARER'S CERTIFICATION\"","v":"2025 PREPARER'S CERTIFICATION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
["HOUSING AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["     It is hereby certified that the Housing 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":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,1,35,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[45,1,45,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],[0,1,0,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[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]]}
[null,"HOUSING AUTHORITY INTERNET WEBSITE CERTIFICATION"]
[]
[null,"Housing 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,"The budgets for the current fiscal year and immediately preceding two prior years."]
[]
[null,"The most recent Comprehensive Annual Financial Report (Unaudited) or similar financial information"]
[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,"two prior years."]
[]
[null,"The Authority’s rules, regulations and official policy statements deemed relevant by the governing body of the Authority "]
[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,"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,"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,"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,"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":""}]
[null,"Title of Officer Certifying Compliance: ",{"$f":"'KEY INPUTS'!B29","v":""}]
[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":[[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],[19,1,20,2],[20,3,20,5],[17,1,17,2],[17,3,17,5],[18,1,18,2],[18,3,18,5],[19,3,19,5],[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]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" APPROVAL CERTIFICATION\"","v":"2025 APPROVAL CERTIFICATION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
["HOUSING AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["       It is hereby certified that the Housing 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 Housing 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":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,0,42,1],[42,4,42,5],[46,0,46,1],[46,4,46,5],[49,0,49,6],[43,0,43,1],[43,4,43,5],[44,0,44,1],[44,4,44,5],[45,0,45,1],[45,4,45,5],[47,0,47,1],[47,4,47,5],[48,0,48,1],[48,4,48,5],[37,0,37,2],[37,4,37,5],[36,0,36,6],[41,0,41,1],[41,4,41,5],[26,0,26,6],[31,8,31,10],[35,0,35,6],[32,8,32,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],[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],[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]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" HOUSING AUTHORITY BUDGET RESOLUTION\"","v":"2025 HOUSING AUTHORITY BUDGET RESOLUTION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"},null,null,null,null,null,null,null,"Use these fields to enter information into the resolution:"]
[]
[{"$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 Housing Authority) for the fiscal year beginning July 01, 2024"}]
[{"$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 June 30, 2025 has been presented before the governing body of the (Select Housing 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 Housing 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 Housing Authority) for the fiscal year beginning July 01, 2024 and ending June 30, 2025, is hereby approved; and"}]
[]
["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 Housing Authority's",null,null,null,null,null,null,null,"Considered for Adoption Date (month day, year):",null,null,"Enter date in cell IJK33 using mm/dd/yyyy format. "]
["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 Housing Authority) will consider the Annual"}]
[{"$f":"\"Budget and Capital Budget/Program for Adoption on \"&TEXT(I33, \"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}]
["Page C-5"]

{"sheet":"Adoption Cert. (C-6)","index":13,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,7],[19,1,19,2],[19,3,19,6],[15,1,15,2],[15,3,15,6],[16,3,16,6],[18,1,18,2],[18,4,18,5],[16,1,17,2],[17,3,17,6],[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]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" ADOPTION CERTIFICATION\"","v":"2025 ADOPTION CERTIFICATION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
["HOUSING AUTHORITY BUDGET"]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["       It is hereby certified that the Housing 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 Housing 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":""}]
[null,"Title:",null,{"$f":"'KEY INPUTS'!B33","v":""}]
[null,"Address:",null,{"$f":"'KEY INPUTS'!B34","v":""}]
[null,null,null,{"$f":"'KEY INPUTS'!B35","v":""}]
[null,"Phone Number:",null,{"$f":"'KEY INPUTS'!B36","v":""},"Fax:",null,{"$f":"'KEY INPUTS'!B37","v":""}]
[null,"E-mail address:",null,{"$f":"'KEY INPUTS'!B38","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page C-6"]

{"sheet":"Adopted Resolution (C-7)","index":14,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,8,4,12],[35,0,35,1],[35,4,35,5],[36,0,36,1],[36,4,36,5],[28,0,28,6],[30,0,30,2],[30,4,30,5],[34,0,34,1],[34,4,34,5],[27,0,27,6],[14,10,14,11],[19,0,19,6],[15,10,15,11],[20,0,20,6],[21,0,21,6],[43,0,43,6],[39,0,39,1],[39,4,39,5],[40,0,40,1],[40,4,40,5],[41,0,41,1],[41,4,41,5],[13,10,13,11],[17,10,17,11],[18,10,18,11],[16,0,16,6],[22,0,22,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],[0,0,0,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[6,0,6,6],[38,4,38,5],[37,4,37,5],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[17,0,17,6],[18,0,18,6],[23,0,23,6],[24,0,24,6],[25,0,25,6],[26,0,26,6]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" ADOPTED BUDGET RESOLUTION\"","v":"2025 ADOPTED BUDGET RESOLUTION"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"},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 Housing 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 July 01, 2024 and ending June 30, 2025 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 Housing 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 Housing 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 Housing 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 July 01, 2024 and ending June 30, 2025 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}]
[]
["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&\" HOUSING AUTHORITY BUDGET\"","v":"2025 HOUSING AUTHORITY BUDGET"}]
["NARRATIVE AND INFORMATION SECTION"]

{"sheet":"Message & Analysis (N-1)","index":16,"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&\" HOUSING AUTHORITY BUDGET MESSAGE & ANALYSIS\"","v":"2025 HOUSING AUTHORITY BUDGET MESSAGE & ANALYSIS"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["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'!B1&\" proposed Annual Budget and make comparison to the Fiscal Year \"&'KEY INPUTS'!B1-1&\" adopted\"","v":"1. Complete a brief statement on the Fiscal Year 2024 proposed Annual Budget and make comparison to the Fiscal Year 2023 adopted"}]
["budget for each Revenue 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 anticipates 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&\" HOUSING AUTHORITY BUDGET MESSAGE & ANALYSIS\"","v":"2025 HOUSING AUTHORITY BUDGET MESSAGE & ANALYSIS"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["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 PILOT payments, or a shared service and explain the reason "]
["for the transfer.  Housing Authorities cannot transfer Unrestricted Net Position. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"5. The proposed budget must not reflect an anticipated deficit from \"&'KEY INPUTS'!B1&\" operations.  If there exists an accumulated deficit from\"","v":"5. The proposed budget must not reflect an anticipated deficit from 2024 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."]
[]
["Page N-1 (2)"]

{"sheet":"Contact Information (N-2)","index":18,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[33,1,33,6],[43,0,43,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],[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],[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],[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]]}
["HOUSING AUTHORITY CONTACT INFORMATION"]
[{"$f":"'KEY INPUTS'!B2","v":2025}]
[]
["Please complete the following information regarding this Authority. All information requested below must be completed."]
[]
["Name of Authority:",{"$f":"'KEY INPUTS'!B5","v":"(Select Housing 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*"]
["*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":19,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,0,45,7],[0,0,0,8],[2,0,2,8],[3,0,3,5],[4,0,4,8],[10,2,10,5]]}
["HOUSING AUTHORITY INFORMATIONAL QUESTIONNAIRE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["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)"]
[]
["4. Provide the number of alternate voting members of the governing body:",null,null,null,null,"(Maximum is 2)"]
[]
["5. 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. "]
[]
["6. 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. "]
[]
["7. 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. "]
[]
["8. 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":20,"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]]}
["HOUSING AUTHORITY INFORMATIONAL QUESTIONNAIRE"]
["(CONTINUED)"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["9. 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. "]
[]
["10. 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. "]
[]
["11. 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. "]
[]
["12. 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)."]
[]
["13. Did the Authority make any payments to current or former commissioners or employees for severance or termination?"]
["If \"yes\", provide explanation, including amount paid. "]
[]
["14. 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. "]
[]
["15. 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":21,"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]]}
["HOUSING AUTHORITY INFORMATIONAL QUESTIONNAIRE"]
["(CONTINUED)"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["16. 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. "]
[]
["17. Did the Authority receive any notices of fines or assessments from the Department of Housing and Urban "]
["Development or any other entity due to noncompliance with current regulations?"]
["If \"yes\", provide description of the event or condition that resulted in the fine/assessment and indicate the amount of the fine/assessment. "]
[]
["18. Has the Authority been deemed \"troubled\" by the Department of Housing and Urban Development? "]
["If \"yes\", attach an explanation of the reason the Authority was deemed \"troubled\" and describe the Authority's plan to address"]
["the conditions identified."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page N-3 (3)"]

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

{"sheet":"Commissioner Schedule (N-4)","index":23,"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 Housing Authority)"}]
[]
[{"$f":"\"FISCAL YEAR: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"FISCAL YEAR: July 01, 2024 to June 30, 2025"}]
[]
["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":24,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,15],[0,0,0,15],[1,0,1,15],[2,0,2,15],[4,4,4,8],[4,9,4,11]]}
["Authority Schedule of Commissioners, Officers, Key Employees, Highest Compensated Employees and Independent Contractors (Continued)"]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[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,{"$f":"SUM(J23:M23)","v":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,{"$f":"SUM(J31:M31)","v":0}]
[26,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J32:M32)","v":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,{"$f":"SUM(J34:M34)","v":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":25,"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 Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
["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":26,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,10,41,23],[0,9,0,23],[1,9,1,23],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20]]}
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6)"},{"$f":"ROW()","v":1},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6)"},{"$f":"ROW()","v":2},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,"ACCUMULATED ABSENCE LIABILITY"]
[{"$f":"MID(CELL(\"filename\",A3),FIND(\"]\",CELL(\"filename\",A3))+1,256)","v":"Accumulated Absences (N-6)"},{"$f":"ROW()","v":3},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"If no accumulated absences, check this box:",null,null,null,null,null,null,null,null,null,null,"Legal basis for benefit"]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":4},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,null,"Sick Time",null,"Vacation Time",null,"Compensatory Time",null,"Personal Time",null,"Other",null,"(\"X\" applicable items)"]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":5},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"Bargaining Unit or Non-Union Position Eligible for Benefit (List Non-Union Employees by Individual Position Rather Than Each Named Individual)","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence ","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":6},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":7},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A8),FIND(\"]\",CELL(\"filename\",A8))+1,256)","v":"Accumulated Absences (N-6)"},{"$f":"ROW()","v":8},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A9),FIND(\"]\",CELL(\"filename\",A9))+1,256)","v":"Accumulated Absences (N-6)"},{"$f":"ROW()","v":9},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A10),FIND(\"]\",CELL(\"filename\",A10))+1,256)","v":"Accumulated Absences (N-6)"},{"$f":"ROW()","v":10},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A11),FIND(\"]\",CELL(\"filename\",A11))+1,256)","v":"Accumulated Absences (N-6)"},{"$f":"ROW()","v":11},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":12},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":13},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":14},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":15},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":16},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":17},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":18},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":19},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":32},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":33},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":34},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":35},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":36},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":37},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":38},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","totaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"TOTALS (THIS PAGE ONLY)",{"$f":"SUM(L6:L37)","v":0},0,0,0,0,0,0,0,0,0]
["Accumulated Absences (N-6)",{"$f":"ROW()","v":39},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"N-6 Accumulated Absence Liability"]

{"sheet":"Accumulated Absences (N-6) (2)","index":27,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,10,41,23],[0,9,0,23],[1,9,1,23],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20]]}
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6) (2)"},{"$f":"ROW()","v":1},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6) (2)"},{"$f":"ROW()","v":2},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,"ACCUMULATED ABSENCE LIABILITY"]
[{"$f":"MID(CELL(\"filename\",A3),FIND(\"]\",CELL(\"filename\",A3))+1,256)","v":"Accumulated Absences (N-6) (2)"},{"$f":"ROW()","v":3},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal basis for benefit"]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":4},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,null,"Sick Time",null,"Vacation Time",null,"Compensatory Time",null,"Personal Time",null,"Other",null,"(\"X\" applicable items)"]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":5},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"Bargaining Unit or Non-Union Position Eligible for Benefit (List Non-Union Employees by Individual Position Rather Than Each Named Individual)","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence ","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":6},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":7},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A8),FIND(\"]\",CELL(\"filename\",A8))+1,256)","v":"Accumulated Absences (N-6) (2)"},{"$f":"ROW()","v":8},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A9),FIND(\"]\",CELL(\"filename\",A9))+1,256)","v":"Accumulated Absences (N-6) (2)"},{"$f":"ROW()","v":9},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A10),FIND(\"]\",CELL(\"filename\",A10))+1,256)","v":"Accumulated Absences (N-6) (2)"},{"$f":"ROW()","v":10},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A11),FIND(\"]\",CELL(\"filename\",A11))+1,256)","v":"Accumulated Absences (N-6) (2)"},{"$f":"ROW()","v":11},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":12},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":13},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":14},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":15},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":16},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":17},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":18},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":19},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":32},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":33},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":34},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":35},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":36},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":37},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":38},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","totaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"TOTALS (THIS PAGE ONLY)",{"$f":"SUM(L6:L37)","v":0},0,0,0,0,0,0,0,0,0]
["Accumulated Absences (N-6) (2)",{"$f":"ROW()","v":39},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"N-6 (2) Accumulated Absence Liability"]

{"sheet":"Accumulated Absences (N-6) (3)","index":28,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,10,41,23],[0,9,0,23],[1,9,1,23],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20]]}
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6) (3)"},{"$f":"ROW()","v":1},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6) (3)"},{"$f":"ROW()","v":2},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,"ACCUMULATED ABSENCE LIABILITY"]
[{"$f":"MID(CELL(\"filename\",A3),FIND(\"]\",CELL(\"filename\",A3))+1,256)","v":"Accumulated Absences (N-6) (3)"},{"$f":"ROW()","v":3},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal basis for benefit"]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":4},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,null,"Sick Time",null,"Vacation Time",null,"Compensatory Time",null,"Personal Time",null,"Other",null,"(\"X\" applicable items)"]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":5},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"Bargaining Unit or Non-Union Position Eligible for Benefit (List Non-Union Employees by Individual Position Rather Than Each Named Individual)","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence ","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":6},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":7},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A8),FIND(\"]\",CELL(\"filename\",A8))+1,256)","v":"Accumulated Absences (N-6) (3)"},{"$f":"ROW()","v":8},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A9),FIND(\"]\",CELL(\"filename\",A9))+1,256)","v":"Accumulated Absences (N-6) (3)"},{"$f":"ROW()","v":9},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A10),FIND(\"]\",CELL(\"filename\",A10))+1,256)","v":"Accumulated Absences (N-6) (3)"},{"$f":"ROW()","v":10},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A11),FIND(\"]\",CELL(\"filename\",A11))+1,256)","v":"Accumulated Absences (N-6) (3)"},{"$f":"ROW()","v":11},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":12},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":13},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":14},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":15},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":16},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":17},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":18},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":19},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":32},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":33},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":34},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":35},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":36},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":37},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":38},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","totaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"TOTALS (THIS PAGE ONLY)",{"$f":"SUM(L6:L37)","v":0},0,0,0,0,0,0,0,0,0]
["Accumulated Absences (N-6) (3)",{"$f":"ROW()","v":39},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"N-6 (3) Accumulated Absence Liability"]

{"sheet":"Accumulated Absences (N-6)Total","index":29,"n_rows":43,"n_cols":24,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,10,42,23],[0,9,0,23],[1,9,1,23],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20]]}
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6)Total"},{"$f":"ROW()","v":1},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"MID(CELL(\"filename\",A2),FIND(\"]\",CELL(\"filename\",A2))+1,256)","v":"Accumulated Absences (N-6)Total"},{"$f":"ROW()","v":2},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,"ACCUMULATED ABSENCE LIABILITY"]
[{"$f":"MID(CELL(\"filename\",A3),FIND(\"]\",CELL(\"filename\",A3))+1,256)","v":"Accumulated Absences (N-6)Total"},{"$f":"ROW()","v":3},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal basis for benefit"]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":4},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,null,"Sick Time",null,"Vacation Time",null,"Compensatory Time",null,"Personal Time",null,"Other",null,"(\"X\" applicable items)"]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":5},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal",null,{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"Bargaining Unit or Non-Union Position Eligible for Benefit (List Non-Union Employees by Individual Position Rather Than Each Named Individual)","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Gross Days of Accumulated Absence ","Dollar Value of Compensated Absences ","Gross Days of Accumulated Absence","Dollar Value of Compensated Absences","Approved Labor Agreement","Resolution","Individual Employment Agreement"]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":6},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":7},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A8),FIND(\"]\",CELL(\"filename\",A8))+1,256)","v":"Accumulated Absences (N-6)Total"},{"$f":"ROW()","v":8},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A9),FIND(\"]\",CELL(\"filename\",A9))+1,256)","v":"Accumulated Absences (N-6)Total"},{"$f":"ROW()","v":9},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A10),FIND(\"]\",CELL(\"filename\",A10))+1,256)","v":"Accumulated Absences (N-6)Total"},{"$f":"ROW()","v":10},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[{"$f":"MID(CELL(\"filename\",A11),FIND(\"]\",CELL(\"filename\",A11))+1,256)","v":"Accumulated Absences (N-6)Total"},{"$f":"ROW()","v":11},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":12},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":13},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":14},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":15},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":16},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":17},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":18},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":19},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":32},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":33},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":34},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":35},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":36},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":37},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","ciaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":38},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal","totaal",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"},null,null,"TOTALS (ALL PAGES)",{"$f":"SUM(L6:L37)+'Accumulated Absences (N-6)'!L38+'Accumulated Absences (N-6) (2)'!L38+'Accumulated Absences (N-6) (3)'!L38","v":0},{"$f":"SUM(M6:M37)+'Accumulated Absences (N-6)'!M38+'Accumulated Absences (N-6) (2)'!M38+'Accumulated Absences (N-6) (3)'!M38","v":0},{"$f":"SUM(N6:N37)+'Accumulated Absences (N-6)'!N38+'Accumulated Absences (N-6) (2)'!N38+'Accumulated Absences (N-6) (3)'!N38","v":0},{"$f":"SUM(O6:O37)+'Accumulated Absences (N-6)'!O38+'Accumulated Absences (N-6) (2)'!O38+'Accumulated Absences (N-6) (3)'!O38","v":0},{"$f":"SUM(P6:P37)+'Accumulated Absences (N-6)'!P38+'Accumulated Absences (N-6) (2)'!P38+'Accumulated Absences (N-6) (3)'!P38","v":0},{"$f":"SUM(Q6:Q37)+'Accumulated Absences (N-6)'!Q38+'Accumulated Absences (N-6) (2)'!Q38+'Accumulated Absences (N-6) (3)'!Q38","v":0},{"$f":"SUM(R6:R37)+'Accumulated Absences (N-6)'!R38+'Accumulated Absences (N-6) (2)'!R38+'Accumulated Absences (N-6) (3)'!R38","v":0},{"$f":"SUM(S6:S37)+'Accumulated Absences (N-6)'!S38+'Accumulated Absences (N-6) (2)'!S38+'Accumulated Absences (N-6) (3)'!S38","v":0},{"$f":"SUM(T6:T37)+'Accumulated Absences (N-6)'!T38+'Accumulated Absences (N-6) (2)'!T38+'Accumulated Absences (N-6) (3)'!T38","v":0},{"$f":"SUM(U6:U37)+'Accumulated Absences (N-6)'!U38+'Accumulated Absences (N-6) (2)'!U38+'Accumulated Absences (N-6) (3)'!U38","v":0}]
["Accumulated Absences (N-6)Total",{"$f":"ROW()","v":39},{"$f":"'[11]Cover Page'!K6","v":"0001"},{"$f":"'[11]Cover Page'!K4","v":2024},"ufb","aal"," ",{"$f":"'[11]Cover Page'!M38","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Funds Reserved per Most Recently Completed Audit:",null,null,"Total Employees subject to accumulated absence restrictions of P.L. 2007, c. 92:"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Funds Appropriated in Current Budget:",null,null,"Total Employees subject to accumulated absence restrictions of P.L. 2010, c. 3:"]
[]
[null,null,null,null,null,null,null,null,null,null,"N-6 (TOTAL) Accumulated Absence Liability"]

{"sheet":"Shared Services (N-7)","index":30,"n_rows":35,"n_cols":30,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5],[0,0,0,5],[34,0,34,7]]}
["Schedule of Shared Service Agreements"]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4,\"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
["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":"Financial Schedule","index":31,"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&\" HOUSING AUTHORITY BUDGET\"","v":"2025 HOUSING AUTHORITY BUDGET"}]
["FINANCIAL SCHEDULES SECTION"]

{"sheet":"F-1 Summary","index":32,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,12],[31,1,31,2],[19,1,19,2],[3,3,3,7],[0,0,0,12],[1,0,1,12]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2025 Proposed Budget"},null,null,null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2024 Adopted Budget"},null,"$ Increase (Decrease) Proposed vs. Adopted","% Increase (Decrease) Proposed vs. Adopted"]
[null,null,null,"Public Housing Management","Section 8","Housing Voucher","Other Programs","Total All Operations",null,"Total All Operations",null,"All Operations","All Operations"]
["REVENUES"]
[]
[null,"Total Operating Revenues",null,{"$f":"+'F-2 Revenues (Proposed)'!D38","v":0},{"$f":"+'F-2 Revenues (Proposed)'!E38","v":0},{"$f":"+'F-2 Revenues (Proposed)'!F38","v":0},{"$f":"+'F-2 Revenues (Proposed)'!G38","v":0},{"$f":"SUM(D8:G8)","v":0},null,{"$f":"+'F-2 Revenues (Proposed)'!J38","v":0},null,{"$f":"H8-J8","v":0},{"$f":"L8/J8","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Non-Operating Revenues",null,{"$f":"+'F-2 Revenues (Proposed)'!D53","v":0},{"$f":"+'F-2 Revenues (Proposed)'!E53","v":0},{"$f":"+'F-2 Revenues (Proposed)'!F53","v":0},{"$f":"+'F-2 Revenues (Proposed)'!G53","v":0},{"$f":"SUM(D10:G10)","v":0},null,{"$f":"+'F-2 Revenues (Proposed)'!J53","v":0},null,{"$f":"H10-J10","v":0},{"$f":"L10/J10","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Total Anticipated Revenues",{"$f":"D8+D10","v":0},{"$f":"E8+E10","v":0},0,0,0,null,{"$f":"J8+J10","v":0},null,{"$f":"H12-J12","v":0},{"$f":"L12/J12","v":{"$error":"#DIV/0!"}}]
[]
["APPROPRIATIONS"]
[]
[null,"Total Administration",null,{"$f":"'F-4 Appropriations (Proposed)'!D16","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E16","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F16","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G16","v":0},{"$f":"SUM(D16:G16)","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!J16","v":0},null,{"$f":"H16-J16","v":0},{"$f":"L16/J16","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Cost of Providing Services",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":"SUM(D18:G18)","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!J37","v":0},null,{"$f":"H18-J18","v":0},{"$f":"L18/J18","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Principal Payments on Debt Service in Lieu of Depreciation",null,{"$f":"'F-4 Appropriations (Proposed)'!D38","v":"XXXXXXXXXXX"},{"$f":"+'F-4 Appropriations (Proposed)'!E38","v":"XXXXXXXXXXX"},{"$f":"+'F-4 Appropriations (Proposed)'!F38","v":"XXXXXXXXXXX"},{"$f":"+'F-4 Appropriations (Proposed)'!G38","v":"XXXXXXXXXXX"},{"$f":"+'F-6 Debt Service-Principal'!H17","v":0},null,{"$f":"+'F-4 Appropriations (Proposed)'!J38","v":0},null,{"$f":"H20-J20","v":0},{"$f":"L20/J20","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Total Operating Appropriations",{"$f":"+D16+D18","v":0},{"$f":"+E16+E18","v":0},0,0,{"$f":"+H16+H18+H20","v":0},null,{"$f":"J16+J18+J20","v":0},null,{"$f":"H22-J22","v":0},{"$f":"L22/J22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Interest Payments on Debt",null,{"$f":"'F-4 Appropriations (Proposed)'!D41","v":"XXXXXXXXXXX"},{"$f":"'F-4 Appropriations (Proposed)'!E41","v":"XXXXXXXXXXX"},{"$f":"'F-4 Appropriations (Proposed)'!F41","v":"XXXXXXXXXXX"},{"$f":"'F-4 Appropriations (Proposed)'!G41","v":"XXXXXXXXXXX"},{"$f":"'F-4 Appropriations (Proposed)'!H41","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!J41","v":0},null,{"$f":"H24-J24","v":0},{"$f":"L24/J24","v":{"$error":"#DIV/0!"}}]
[null,"Total Other Non-Operating Appropriations",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":"SUM(D25:G25)","v":0},null,{"$f":"J26-J24","v":0},null,{"$f":"H25-J25","v":0},{"$f":"L25/J25","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Non-Operating Appropriations",{"$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},null,{"$f":"+'F-4 Appropriations (Proposed)'!J46","v":0},null,{"$f":"H26-J26","v":0},{"$f":"L26/J26","v":{"$error":"#DIV/0!"}}]
[]
[null,"Accumulated Deficit",null,{"$f":"+'F-4 Appropriations (Proposed)'!D48","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E48","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!F48","v":0},{"$f":"+'F-4 Appropriations (Proposed)'!G48","v":0},{"$f":"SUM(D28:G28)","v":0},null,{"$f":"+'F-4 Appropriations (Proposed)'!J48","v":0},null,{"$f":"H28-J28","v":0},{"$f":"L28/J28","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,null,{"$f":"+J22+J26+J28","v":0},null,{"$f":"H30-J30","v":0},{"$f":"L30/J30","v":{"$error":"#DIV/0!"}}]
[]
[null,"Less: Total Unrestricted Net Position Utilized",null,{"$f":"'F-4 Appropriations (Proposed)'!D53","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E53","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F53","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G53","v":0},{"$f":"SUM(D32:G32)","v":0},null,{"$f":"'F-4 Appropriations (Proposed)'!J53","v":0},null,{"$f":"H32-J32","v":0},{"$f":"L32/J32","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Net Total Appropriations",{"$f":"+D30-D32","v":0},{"$f":"+E30-E32","v":0},0,0,0,null,{"$f":"J30-J32","v":0},null,{"$f":"H34-J34","v":0},{"$f":"L34/J34","v":{"$error":"#DIV/0!"}}]
[]
["ANTICIPATED SURPLUS (DEFICIT)",null,null,{"$f":"+D12-D34","v":0},{"$f":"+E12-E34","v":0},0,0,0,null,{"$f":"J12-J34","v":0},null,{"$f":"H36-J36","v":0},{"$f":"L36/J36","v":{"$error":"#DIV/0!"}}]
[]
["Page F-1"]

{"sheet":"F-2 Revenues (Proposed)","index":33,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,3,3,7],[0,0,0,12],[1,0,1,12],[55,0,55,12]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2025 Proposed Budget"},null,null,null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2024 Adopted Budget"},null,"$ Increase (Decrease) Proposed vs. Adopted","% Increase (Decrease) Proposed vs. Adopted"]
[null,null,null,"Public Housing Management","Section 8","Housing Voucher","Other Programs","Total All Operations",null,"Total All Operations",null,"All Operations","All Operations"]
["OPERATING REVENUES"]
["Rental Fees"]
[null,"Homebuyers' Monthly Payments",null,null,null,null,null,{"$f":"SUM(D8:G8)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H8","v":0},null,{"$f":"H8-J8","v":0},{"$f":"L8/J8","v":{"$error":"#DIV/0!"}}]
[null,"Dwelling Rental ",null,null,null,null,null,{"$f":"SUM(D9:G9)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!H9","v":0},null,{"$f":"H9-J9","v":0},{"$f":"L9/J9","v":{"$error":"#DIV/0!"}}]
[null,"Excess Utilities",null,null,null,null,null,{"$f":"SUM(D10:G10)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!H10","v":0},null,{"$f":"H10-J10","v":0},{"$error":"#DIV/0!"}]
[null,"Non-Dwelling Rental",null,null,null,null,null,{"$f":"SUM(D11:G11)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!H11","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"HUD Operating Subsidy",null,null,null,null,null,0,null,{"$f":"'F-3 Revenues (PY Adopted)'!H12","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"New Construction - Acc Section 8",null,null,null,null,null,{"$f":"SUM(D13:G13)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!H13","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Voucher - Acc Housing Voucher",null,null,null,null,null,{"$f":"SUM(D14:G14)","v":0},null,{"$f":"'F-3 Revenues (PY Adopted)'!H14","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Rental Fees",{"$f":"SUM(D8:D14)","v":0},{"$f":"SUM(E8:E14)","v":0},0,0,0,null,{"$f":"SUM(J8:J14)","v":0},null,{"$f":"H15-J15","v":0},{"$error":"#DIV/0!"}]
["Other Operating Revenues (List)"]
[null,null,null,null,null,null,null,{"$f":"SUM(D17:G17)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H17","v":0},null,{"$f":"H17-J17","v":0},{"$f":"L17/J17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"SUM(D18:G18)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H18","v":0},null,{"$f":"H18-J18","v":0},{"$f":"L18/J18","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"SUM(D19:G19)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H19","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,{"$f":"SUM(D20:G20)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H20","v":0},null,{"$f":"H20-J20","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H21","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H22","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H23","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H24","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H25","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H26","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H27","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H28","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H29","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H30","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H31","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H32","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H33","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H34","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H35","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H36","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Other Revenue",{"$f":"SUM(D17:D36)","v":0},{"$f":"SUM(E17:E36)","v":0},0,0,0,null,{"$f":"SUM(J17:J36)","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Operating Revenues",{"$f":"+D15+D37","v":0},{"$f":"+E15+E37","v":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,{"$f":"SUM(D41:G41)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H41","v":0},null,{"$f":"H41-J41","v":0},{"$f":"L41/J41","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H42","v":0},null,{"$f":"H42-J42","v":0},{"$f":"L42/J42","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H43","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H44","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H45","v":0},null,{"$f":"H45-J45","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,null,{"$f":"+'F-3 Revenues (PY Adopted)'!H46","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Other Non-Operating Revenue",{"$f":"SUM(D41:D46)","v":0},0,0,0,0,null,{"$f":"SUM(J41:J46)","v":0},null,0,{"$error":"#DIV/0!"}]
["Interest on Investments & Deposits (List)"]
[null,"Interest Earned",null,null,null,null,null,{"$f":"SUM(D49:G49)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H49","v":0},null,{"$f":"H49-J49","v":0},{"$f":"L49/J49","v":{"$error":"#DIV/0!"}}]
[null,"Penalties",null,null,null,null,null,{"$f":"SUM(D50:G50)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H50","v":0},null,{"$f":"H50-J50","v":0},{"$f":"L50/J50","v":{"$error":"#DIV/0!"}}]
[null,"Other",null,null,null,null,null,{"$f":"SUM(D51:G51)","v":0},null,{"$f":"+'F-3 Revenues (PY Adopted)'!H51","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"Total Interest ",{"$f":"SUM(D49:D51)","v":0},0,0,0,0,null,{"$f":"SUM(J49:J51)","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Non-Operating Revenues",{"$f":"+D47+D52","v":0},{"$f":"+E47+E52","v":0},0,0,0,null,0,null,0,{"$f":"L53/J53","v":{"$error":"#DIV/0!"}}]
["TOTAL ANTICIPATED REVENUES",null,null,{"$f":"+D38+D53","v":0},0,0,0,0,null,{"$f":"+J38+J53","v":0},null,{"$f":"H54-J54","v":0},{"$error":"#DIV/0!"}]
[]
["Page F-2"]

{"sheet":"F-3 Revenues (PY Adopted)","index":34,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,3,1,4],[3,3,3,7],[55,0,55,7]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[]
[null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2024 Adopted Budget"}]
[null,null,null,"Public Housing Management","Section 8","Housing Voucher","Other Programs","Total All Operations"]
["OPERATING REVENUES"]
["Rental Fees"]
[null,"Homebuyers' Monthly Payments",null,null,null,null,null,{"$f":"SUM(D8:G8)","v":0}]
[null,"Dwelling Rental ",null,null,null,null,null,{"$f":"SUM(D9:G9)","v":0}]
[null,"Excess Utilities",null,null,null,null,null,{"$f":"SUM(D10:G10)","v":0}]
[null,"Non-Dwelling Rental",null,null,null,null,null,{"$f":"SUM(D11:G11)","v":0}]
[null,"HUD Operating Subsidy",null,null,null,null,null,0]
[null,"New Construction - Acc Section 8",null,null,null,null,null,{"$f":"SUM(D13:G13)","v":0}]
[null,"Voucher - Acc Housing Voucher",null,null,null,null,null,{"$f":"SUM(D14:G14)","v":0}]
[null,null,"Total Rental Fees",{"$f":"SUM(D8:D14)","v":0},{"$f":"SUM(E8:E14)","v":0},0,0,0]
["Other Revenue (List)"]
[null,{"$f":"'F-2 Revenues (Proposed)'!B17","v":0},null,null,null,null,null,{"$f":"SUM(D17:G17)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B18","v":0},null,null,null,null,null,{"$f":"SUM(D18:G18)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B19","v":0},null,null,null,null,null,{"$f":"SUM(D19:G19)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B20","v":0},null,null,null,null,null,{"$f":"SUM(D20:G20)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B21","v":0},null,null,null,null,null,{"$f":"SUM(D21:G21)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B22","v":0},null,null,null,null,null,{"$f":"SUM(D22:G22)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B23","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B24","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B25","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B26","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B27","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B28","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B29","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B30","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B31","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B32","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B33","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B34","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B35","v":0},null,null,null,null,null,{"$f":"SUM(D35:G35)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B36","v":0},null,null,null,null,null,{"$f":"SUM(D36:G36)","v":0}]
[null,null,"Total Other Revenue",{"$f":"SUM(D17:D36)","v":0},{"$f":"SUM(E17:E36)","v":0},{"$f":"SUM(F17:F36)","v":0},{"$f":"SUM(G17:G36)","v":0},{"$f":"SUM(H17:H36)","v":0}]
[null,null,"     Total Operating Revenues",{"$f":"+D15+D37","v":0},{"$f":"+E15+E37","v":0},{"$f":"+F15+F37","v":0},{"$f":"+G15+G37","v":0},{"$f":"+H15+H37","v":0}]
["NON-OPERATING REVENUES"]
["Other Non-Operating Revenues (List)"]
[null,{"$f":"'F-2 Revenues (Proposed)'!B41","v":0},null,null,null,null,null,{"$f":"SUM(D41:G41)","v":0}]
[null,{"$f":"'F-2 Revenues (Proposed)'!B42","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B43","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B44","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B45","v":0},null,null,null,null,null,0]
[null,{"$f":"'F-2 Revenues (Proposed)'!B46","v":0},null,null,null,null,null,0]
[null,null,"Other Non-Operating Revenues",{"$f":"SUM(D41:D46)","v":0},{"$f":"SUM(E41:E46)","v":0},0,0,0]
["Interest on Investments & Deposits"]
[null,"Interest Earned",null,null,null,null,null,{"$f":"SUM(D49:G49)","v":0}]
[null,"Penalties",null,null,null,null,null,{"$f":"SUM(D50:G50)","v":0}]
[null,"Other",null,null,null,null,null,{"$f":"SUM(D51:G51)","v":0}]
[null,null,"Total Interest ",{"$f":"SUM(D49:D51)","v":0},0,0,0,0]
[null,null,"     Total Non-Operating Revenues",{"$f":"+D47+D52","v":0},{"$f":"+E47+E52","v":0},0,0,0]
["TOTAL ANTICIPATED REVENUES",null,null,{"$f":"+D38+D53","v":0},{"$f":"+E38+E53","v":0},{"$f":"+F38+F53","v":0},{"$f":"+G38+G53","v":0},{"$f":"+H38+H53","v":0}]
[]
["Page F-3"]

{"sheet":"F-4 Appropriations (Proposed)","index":35,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,0,58,12],[0,0,0,12],[1,0,1,12],[28,1,28,2],[29,1,29,2],[55,0,55,9],[37,0,37,2],[48,0,48,2],[35,1,35,2],[3,3,3,7],[26,1,26,2],[27,1,27,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[14,1,14,2]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2025 Proposed Budget"},null,null,null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2-1&\" Adopted Budget\"","v":"FY 2024 Adopted Budget"},null,"$ Increase (Decrease) Proposed vs. Adopted","% Increase (Decrease) Proposed vs. Adopted"]
[null,null,null,"Public Housing Management","Section 8","Housing Voucher","Other Programs","Total All Operations",null,"Total All Operations",null,"All Operations","All Operations"]
["OPERATING APPROPRIATIONS"]
["Administration"]
[null,"Salary & Wages",null,null,null,null,null,{"$f":"SUM(D8:G8)","v":0},null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H8","v":0},null,{"$f":"H8-J8","v":0},{"$f":"L8/J8","v":{"$error":"#DIV/0!"}}]
[null,"Fringe Benefits",null,null,null,null,null,{"$f":"SUM(D9:G9)","v":0},null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H9","v":0},null,{"$f":"H9-J9","v":0},{"$f":"L9/J9","v":{"$error":"#DIV/0!"}}]
[null,"Legal",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H10","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Staff Training",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H11","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Travel ",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H12","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Accounting Fees",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H13","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Auditing Fees",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H14","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Miscellaneous Administration*",null,null,null,null,null,{"$f":"SUM(D15:G15)","v":0},null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H15","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Administration",{"$f":"SUM(D8:D15)","v":0},{"$f":"SUM(E8:E15)","v":0},0,0,{"$f":"SUM(H8:H15)","v":0},null,{"$f":"SUM(J8:J15)","v":0},null,{"$f":"H16-J16","v":0},{"$error":"#DIV/0!"}]
["Cost of Providing Services"]
[null,"Salary & Wages - Tenant Services",null,null,null,null,null,{"$f":"SUM(D18:G18)","v":0},null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H18","v":0},null,{"$f":"H18-J18","v":0},{"$error":"#DIV/0!"}]
[null,"Salary & Wages - Maintenance & Operation",null,null,null,null,null,{"$f":"SUM(D19:G19)","v":0},null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H19","v":0},null,{"$f":"H19-J19","v":0},{"$f":"L19/J19","v":{"$error":"#DIV/0!"}}]
[null,"Salary & Wages - Protective Services",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H20","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Salary & Wages - Utility Labor",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H21","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Fringe Benefits",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H22","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Tenant Services",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H23","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Utilities",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H24","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Maintenance & Operation",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H25","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Protective Services",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H26","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Insurance",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H27","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Payment in Lieu of Taxes (PILOT)",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H28","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Terminal Leave Payments",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H29","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Collection Losses",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H30","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Other General Expense",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H31","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Rents",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H32","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Extraordinary Maintenance",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H33","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Replacement of Non-Expendible Equipment",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H34","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Property Betterment/Additions",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H35","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Miscellaneous COPS*",null,null,null,null,null,0,null,{"$f":"+'F-5 Appropriations (PY Adopted)'!H36","v":0},null,0,{"$error":"#DIV/0!"}]
[null,null,"     Total Cost of Providing Services",{"$f":"SUM(D18:D36)","v":0},{"$f":"SUM(E18:E36)","v":0},0,0,0,null,{"$f":"SUM(J18:J36)","v":0},null,{"$f":"H37-J37","v":0},{"$error":"#DIV/0!"}]
["Total Principal Payments on Debt Service in Lieu of Depreciation",null,null,"XXXXXXXXXXX","XXXXXXXXXXX","XXXXXXXXXXX","XXXXXXXXXXX",{"$f":"+'F-6 Debt Service-Principal'!H17","v":0},null,{"$f":"+'F-6 Debt Service-Principal'!F17","v":0},null,{"$f":"H38-J38","v":0},{"$error":"#DIV/0!"}]
[null,null,"          Total Operating Appropriations",{"$f":"+D16+D37","v":0},{"$f":"+E16+E37","v":0},0,0,{"$f":"+H16+H37+H38","v":0},null,{"$f":"+J16+J37+J38","v":0},null,0,{"$error":"#DIV/0!"}]
["NON-OPERATING APPROPRIATIONS"]
["Total Interest Payments on Debt",null,null,"XXXXXXXXXXX","XXXXXXXXXXX","XXXXXXXXXXX","XXXXXXXXXXX",{"$f":"+'F-7 Debt Service-Interest'!F17","v":0},null,{"$f":"+'F-7 Debt Service-Interest'!D17","v":0},null,{"$f":"H41-J41","v":0},{"$error":"#DIV/0!"}]
["Operations & Maintenance Reserve",null,null,null,null,null,null,{"$f":"SUM(D42:G42)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!H42","v":0},null,{"$f":"H42-J42","v":0},{"$error":"#DIV/0!"}]
["Renewal & Replacement Reserve",null,null,null,null,null,null,{"$f":"SUM(D43:G43)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!H43","v":0},null,0,{"$error":"#DIV/0!"}]
["Municipality/County Appropriation",null,null,null,null,null,null,{"$f":"SUM(D44:G44)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!H44","v":0},null,0,{"$error":"#DIV/0!"}]
["Other Reserves",null,null,null,null,null,null,{"$f":"SUM(D45:G45)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!H45","v":0},null,0,{"$error":"#DIV/0!"}]
[null,"Total Non-Operating Appropriations",null,{"$f":"SUM(D42:D45)","v":0},{"$f":"SUM(E42:E45)","v":0},0,0,{"$f":"SUM(H41:H45)","v":0},null,{"$f":"SUM(J41:J45)","v":0},null,{"$f":"H46-J46","v":0},{"$error":"#DIV/0!"}]
["TOTAL APPROPRIATIONS",null,null,{"$f":"+D39+D46","v":0},{"$f":"+E39+E46","v":0},0,0,{"$f":"+H39+H46","v":0},null,{"$f":"+J39+J46","v":0},null,0,{"$error":"#DIV/0!"}]
["ACCUMULATED DEFICIT",null,null,null,null,null,null,{"$f":"SUM(D48:G48)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!H48","v":0},null,0,{"$error":"#DIV/0!"}]
["TOTAL APPROPRIATIONS & ACCUMULATED DEFICIT",null,null,{"$f":"+D47+D48","v":0},{"$f":"+E47+E48","v":0},0,0,0,null,{"$f":"+J47+J48","v":0},null,0,{"$error":"#DIV/0!"}]
["UNRESTRICTED NET POSITION UTILIZED"]
["Municipality/County Appropriation",null,null,{"$f":"D44","v":0},{"$f":"E44","v":0},0,0,{"$f":"SUM(D51:G51)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!H51","v":0},null,{"$f":"H51-J51","v":0},{"$error":"#DIV/0!"}]
["Other",null,null,null,null,null,null,{"$f":"SUM(D52:G52)","v":0},null,{"$f":"'F-5 Appropriations (PY Adopted)'!H52","v":0},null,{"$f":"H52-J52","v":0},{"$error":"#DIV/0!"}]
[null,"Total Unrestricted Net Position Utilized",null,{"$f":"+D51+D52","v":0},{"$f":"+E51+E52","v":0},0,0,0,null,{"$f":"+J51+J52","v":0},null,0,{"$error":"#DIV/0!"}]
["TOTAL NET APPROPRIATIONS",null,null,{"$f":"+D49-D53","v":0},{"$f":"+E49-E53","v":0},0,0,0,null,{"$f":"+J49-J53","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":"D39*0.05","v":0},{"$f":"E39*0.05","v":0},0,0,0]
[]
["Page F-4"]

{"sheet":"F-4 Appropriation Detail","index":36,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,5],[7,0,7,5],[0,0,0,5],[1,0,1,5],[2,0,2,2],[3,0,3,5],[5,0,5,5]]}
["HOUSING AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-4 Appropriations (Proposed)\""]
[]
["Line Item:","Public Housing Mgt.","Section 8","Housing Voucher","Other Programs","Total"]
[null,null,null,null,null,{"$f":"SUM(B11:E11)","v":0}]
[null,null,null,null,null,{"$f":"SUM(B12:E12)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(B48:E48)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
["Page F-4 Detail"]

{"sheet":"F-4 Appropriation Detail (2)","index":37,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,5],[7,0,7,5],[0,0,0,5],[1,0,1,5],[2,0,2,2],[3,0,3,5],[5,0,5,5]]}
["HOUSING AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-4 Appropriations (Proposed)\""]
[]
["Line Item:","Public Housing Mgt.","Section 8","Housing Voucher","Other Programs","Total"]
[null,null,null,null,null,{"$f":"SUM(B11:E11)","v":0}]
[null,null,null,null,null,{"$f":"SUM(B12:E12)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(B48:E48)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
["Page F-4 (Detail) (2)"]

{"sheet":"F-4 Appropriation Detail (3)","index":38,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,5],[7,0,7,5],[0,0,0,5],[1,0,1,5],[2,0,2,2],[3,0,3,5],[5,0,5,5]]}
["HOUSING AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-4 Appropriations (Proposed)\""]
[]
["Line Item:","Public Housing Mgt.","Section 8","Housing Voucher","Other Programs","Total"]
[null,null,null,null,null,{"$f":"SUM(B11:E11)","v":0}]
[null,null,null,null,null,{"$f":"SUM(B12:E12)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(B48:E48)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
["Page F-4 (Detail) (3)"]

{"sheet":"F-5 Appropriations (PY Adopted)","index":39,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,0,58,8],[55,0,55,7],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[35,1,35,2],[12,1,12,2],[14,1,14,2],[11,1,11,2],[37,0,37,2],[48,0,48,2],[1,3,1,4],[3,3,3,7],[9,1,9,2],[10,1,10,2],[0,0,0,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[]
[null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B1&\" Adopted Budget\"","v":"FY 2024 Adopted Budget"}]
[null,null,null,"Public Housing Management","Section 8","Housing Voucher","Other Programs","Total All Operations"]
["OPERATING APPROPRIATIONS"]
["Administration"]
[null,"Salary & Wages",null,null,null,null,null,{"$f":"SUM(D8:G8)","v":0}]
[null,"Fringe Benefits",null,null,null,null,null,{"$f":"SUM(D9:G9)","v":0}]
[null,"Legal",null,null,null,null,null,{"$f":"SUM(D10:G10)","v":0}]
[null,"Staff Training",null,null,null,null,null,{"$f":"SUM(D11:G11)","v":0}]
[null,"Travel ",null,null,null,null,null,{"$f":"SUM(D12:G12)","v":0}]
[null,"Accounting Fees",null,null,null,null,null,0]
[null,"Auditing Fees",null,null,null,null,null,{"$f":"SUM(D14:G14)","v":0}]
[null,"Miscellaneous Administration*",null,null,null,null,null,{"$f":"SUM(D15:G15)","v":0}]
[null,null,"     Total Administration",{"$f":"SUM(D8:D15)","v":0},{"$f":"SUM(E8:E15)","v":0},0,0,{"$f":"SUM(H8:H15)","v":0}]
["Cost of Providing Services"]
[null,"Salary & Wages - Tenant Services",null,null,null,null,null,{"$f":"SUM(D18:G18)","v":0}]
[null,"Salary & Wages - Maintenance & Operation",null,null,null,null,null,0]
[null,"Salary & Wages - Protective Services",null,null,null,null,null,0]
[null,"Salary & Wages - Utility Labor",null,null,null,null,null,0]
[null,"Fringe Benefits",null,null,null,null,null,0]
[null,"Tenant Services",null,null,null,null,null,0]
[null,"Utilities",null,null,null,null,null,0]
[null,"Maintenance & Operation",null,null,null,null,null,0]
[null,"Protective Services",null,null,null,null,null,0]
[null,"Insurance",null,null,null,null,null,0]
[null,"Payment in Lieu of Taxes (PILOT)",null,null,null,null,null,0]
[null,"Terminal Leave Payments",null,null,null,null,null,0]
[null,"Collection Losses",null,null,null,null,null,0]
[null,"Other General Expense",null,null,null,null,null,0]
[null,"Rents",null,null,null,null,null,0]
[null,"Extraordinary Maintenance",null,null,null,null,null,0]
[null,"Replacement of Non-Expendible Equipment",null,null,null,null,null,0]
[null,"Property Betterment/Additions",null,null,null,null,null,0]
[null,"Miscellaneous COPS*",null,null,null,null,null,0]
[null,null,"     Total Cost of Providing Services",{"$f":"SUM(D18:D36)","v":0},{"$f":"SUM(E18:E36)","v":0},0,0,0]
["Total Principal Payments on Debt Service in Lieu of Depreciation",null,null,"XXXXXXXXXXXXXX","XXXXXXXXXXXXXX","XXXXXXXXXXXXXX","XXXXXXXXXXXXXX",{"$f":"+'F-6 Debt Service-Principal'!F17","v":0}]
[null,null,"          Total Operating Appropriations",{"$f":"+D16+D37","v":0},{"$f":"+E16+E37","v":0},0,0,{"$f":"+H16+H37+H38","v":0}]
["NON-OPERATING APPROPRIATIONS"]
["Total Interest Payments on Debt",null,null,"XXXXXXXXXXXXXX","XXXXXXXXXXXXXX","XXXXXXXXXXXXXX","XXXXXXXXXXXXXX",{"$f":"+'F-7 Debt Service-Interest'!D17","v":0}]
["Operations & Maintenance Reserve",null,null,null,null,null,null,{"$f":"SUM(D42:G42)","v":0}]
["Renewal & Replacement Reserve",null,null,null,null,null,null,{"$f":"SUM(D43:G43)","v":0}]
["Municipality/County Appropriation",null,null,null,null,null,null,{"$f":"SUM(D44:G44)","v":0}]
["Other Reserves",null,null,null,null,null,null,{"$f":"SUM(D45:G45)","v":0}]
[null,"Total Non-Operating Appropriations",null,{"$f":"SUM(D42:D45)","v":0},{"$f":"SUM(E42:E45)","v":0},0,0,{"$f":"SUM(H41:H45)","v":0}]
["TOTAL APPROPRIATIONS",null,null,{"$f":"+D46+D39","v":0},{"$f":"+E46+E39","v":0},0,0,{"$f":"+H46+H39","v":0}]
["ACCUMULATED DEFICIT",null,null,null,null,null,null,{"$f":"SUM(D48:G48)","v":0}]
["TOTAL APPROPRIATIONS & ACCUMULATED DEFICIT",null,null,{"$f":"+D47+D48","v":0},{"$f":"+E47+E48","v":0},0,0,0]
["UNRESTRICTED NET POSITION UTILIZED"]
["Municipality/County Appropriation",null,null,{"$f":"D44","v":0},{"$f":"E44","v":0},0,0,{"$f":"SUM(D51:G51)","v":0}]
["Other",null,null,null,null,null,null,{"$f":"SUM(D52:G52)","v":0}]
[null,"Total Unrestricted Net Position Utilized",null,{"$f":"+D51+D52","v":0},{"$f":"+E51+E52","v":0},0,0,0]
["TOTAL NET APPROPRIATIONS",null,null,{"$f":"+D49-D53","v":0},{"$f":"+E49-E53","v":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":"D39*0.05","v":0},{"$f":"E39*0.05","v":0},0,0,0]
[]
["Page F-5"]

{"sheet":"F-5 Appropriation Detail","index":40,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,5],[7,0,7,5],[0,0,0,5],[1,0,1,5],[2,0,2,2],[3,0,3,5],[5,0,5,5]]}
["HOUSING AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-5 Prior Year Appropriations (Adopted)\""]
[]
["Line Item:","Public Housing Mgt.","Section 8","Housing Voucher","Other Programs","Total"]
[null,null,null,null,null,{"$f":"SUM(B11:E11)","v":0}]
[null,null,null,null,null,{"$f":"SUM(B12:E12)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(B48:E48)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
["Page F-5 (Detail)"]

{"sheet":"F-5 Appropriation Detail (2)","index":41,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,5],[7,0,7,5],[0,0,0,5],[1,0,1,5],[2,0,2,2],[3,0,3,5],[5,0,5,5]]}
["HOUSING AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-5 Prior Year Appropriations (Adopted)\""]
[]
["Line Item:","Public Housing Mgt.","Section 8","Housing Voucher","Other Programs","Total"]
[null,null,null,null,null,{"$f":"SUM(B11:E11)","v":0}]
[null,null,null,null,null,{"$f":"SUM(B12:E12)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(B48:E48)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
["Page F-5 (Detail) (2)"]

{"sheet":"F-5 Appropriation Detail (3)","index":42,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,5],[7,0,7,5],[0,0,0,5],[1,0,1,5],[2,0,2,2],[3,0,3,5],[5,0,5,5]]}
["HOUSING AUTHORITY PROPOSED APPROPRIATIONS"]
["APPROPRIATION DETAIL PAGE"]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
["Use the space below to provide further detail of any Appropriations listed on \"F-5 Prior Year Appropriations (Adopted)\""]
[]
["Line Item:","Public Housing Mgt.","Section 8","Housing Voucher","Other Programs","Total"]
[null,null,null,null,null,{"$f":"SUM(B11:E11)","v":0}]
[null,null,null,null,null,{"$f":"SUM(B12:E12)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(B48:E48)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
["Page F-5 (Detail) (3)"]

{"sheet":"F-6 Debt Service-Principal","index":43,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,15],[0,0,0,17],[24,3,24,7],[2,5,2,13]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing 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":"2024 (Adopted Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2, 'KEY INPUTS'!B1)&\" (Proposed Budget)\"","v":"2025 (Proposed Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2+1, 'KEY INPUTS'!B1+1)","v":2026},{"$f":"+J4+1","v":2027},{"$f":"+K4+1","v":2028},{"$f":"+L4+1","v":2029},{"$f":"+M4+1","v":2030},"Thereafter","Total Principal Outstanding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J5:O5)+H5","v":0}]
[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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J8:O8)+H8","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,{"$f":"SUM(J11:O11)+H11","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,"TOTAL PRINCIPAL",null,null,null,{"$f":"SUM(F5:F14)","v":0},null,{"$f":"SUM(H5:H14)","v":0},null,{"$f":"SUM(J5:J14)","v":0},0,0,0,0,0,{"$f":"SUM(P5:P14)","v":0}]
[null,"LESS: HUD SUBSIDY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J16:O16)+H16","v":0}]
[null,"NET PRINCIPAL",null,null,null,{"$f":"+F15-F16","v":0},null,{"$f":"+H15-H16","v":0},null,{"$f":"+J15-J16","v":0},{"$f":"+K15-K16","v":0},0,0,0,0,{"$f":"+P15-P16","v":0}]
[]
[]
[null,"Indicate the Authority's most recent bond rating and the year of the rating by ratings service."]
[null,null,null,"Moody's",null,"Fitch",null,"Standard & Poors"]
[null,"Bond Rating"]
[null,"Year of Last Rating"]
[]
[null,null,null,"If no rating, type \"Not Applicable\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-6"]

{"sheet":"F-7 Debt Service-Interest","index":44,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,13],[38,0,38,13],[2,3,2,11]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing 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":"2024 (Adopted Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2, 'KEY INPUTS'!B1)&\" (Proposed Budget)\"","v":"2025 (Proposed Budget)"},null,{"$f":"IF('KEY INPUTS'!B1 <> 'KEY INPUTS'!B2, 'KEY INPUTS'!B2+1, 'KEY INPUTS'!B1+1)","v":2026},{"$f":"+H4+1","v":2027},{"$f":"+I4+1","v":2028},{"$f":"+J4+1","v":2029},{"$f":"+K4+1","v":2030},"Thereafter","Total Interest Payments Outstanding"]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B5<>\"\",'F-6 Debt Service-Principal'!B5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H5:M5)+F5","v":0}]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B6<>\"\",'F-6 Debt Service-Principal'!B6,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H6:M6)+F6","v":0}]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B7<>\"\",'F-6 Debt Service-Principal'!B7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H7:M7)+F7","v":0}]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B8<>\"\",'F-6 Debt Service-Principal'!B8,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B9<>\"\",'F-6 Debt Service-Principal'!B9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H9:M9)+F9","v":0}]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B10<>\"\",'F-6 Debt Service-Principal'!B10,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B11<>\"\",'F-6 Debt Service-Principal'!B11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B12<>\"\",'F-6 Debt Service-Principal'!B12,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B13<>\"\",'F-6 Debt Service-Principal'!B13,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF('F-6 Debt Service-Principal'!B14<>\"\",'F-6 Debt Service-Principal'!B14,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL INTEREST",null,{"$f":"SUM(D5:D14)","v":0},null,{"$f":"SUM(F5:F14)","v":0},null,{"$f":"SUM(H5:H14)","v":0},0,0,0,0,0,0]
[null,"LESS: HUD SUBSIDY",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H16:M16)+F16","v":0}]
[null,"NET INTEREST ",null,{"$f":"+D15-D16","v":0},null,{"$f":"+F15-F16","v":0},null,{"$f":"+H15-H16","v":0},{"$f":"+I15-I16","v":0},{"$f":"+J15-J16","v":0},0,{"$f":"+L15-L16","v":0},0,{"$f":"+N15-N16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page F-7"]

{"sheet":"F-8 Net Position","index":45,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,30,7],[22,0,22,2],[28,0,28,7],[26,0,26,7],[25,0,25,7],[24,0,24,7],[0,0,0,7],[5,0,5,2],[3,3,3,7],[17,0,17,2],[1,0,1,7]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[null,null,null,{"$f":"+\"FY \"&'KEY INPUTS'!B2&\" Proposed Budget\"","v":"FY 2025 Proposed Budget"}]
[null,null,null,"Public Housing Management","Section 8","Housing Voucher","Other Programs","Total All Operations"]
["TOTAL NET POSITION BEGINNING OF CURRENT YEAR (1)",null,null,0,0,0,0,{"$f":"SUM(D6:G6)","v":0}]
[null,"Less: Invested in Capital Assets, Net of Related Debt (1)",null,null,null,null,null,0]
[null,"Less: Restricted for Debt Service Reserve (1)",null,null,null,null,null,0]
[null,"Less: Other Restricted Net Position (1)",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]
[null,"Less: Designated for Non-Operating Improvements & Repairs",null,null,null,null,null,0]
[null,"Less: Designated for Rate Stabilization",null,null,null,null,null,0]
[null,"Less: Other Designated by Resolution",null,null,null,null,null,0]
[null,"Plus: Accrued Unfunded Pension Liability (1)",null,null,null,null,null,0]
[null,"Plus: Accrued Unfunded Other Post-Employment Benefit Liability (1)",null,null,null,null,null,0]
[null,"Plus: Estimated Income (Loss) on Current Year Operations (2)",null,null,null,null,null,0]
[null,"Plus: Other Adjustments (attach schedule)",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]
[null,"Unrestricted Net Position Utilized to Balance Proposed Budget",null,{"$f":"+'F-4 Appropriations (Proposed)'!D52","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E52","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F52","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G52","v":0},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},0]
[null,"Appropriation to Municipality/County (3)",null,{"$f":"+'F-4 Appropriations (Proposed)'!D44","v":0},{"$f":"'F-4 Appropriations (Proposed)'!E44","v":0},{"$f":"'F-4 Appropriations (Proposed)'!F44","v":0},{"$f":"'F-4 Appropriations (Proposed)'!G44","v":0},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]
["PROJECTED UNRESTRICTED UNDESIGNATED NET POSITION AT END OF YEAR (4)",null,null,{"$f":"+D18-D22","v":0},{"$f":"+E18-E22","v":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}]
["(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":46,"n_rows":14,"n_cols":1,"rows_kept":14,"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":"'KEY INPUTS'!B2","v":2025}]
[]
[]
[]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
["(Housing Authority Name)"]
[]
[]
[]
[]
[{"$f":"\"\"&'KEY INPUTS'!B2&\" HOUSING AUTHORITY\"","v":"2025 HOUSING AUTHORITY"}]
["CAPITAL BUDGET / PROGRAM"]

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

{"sheet":"CB-2 Capital Budget Message","index":48,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[6,0,6,10],[25,0,27,10],[46,0,46,10],[58,0,58,5],[58,6,58,8],[59,0,59,5],[59,6,59,8],[63,2,63,3],[63,5,63,6],[63,7,63,9],[67,2,67,3],[68,0,68,10]]}
[{"$f":"\"\"&'KEY INPUTS'!B2&\" CAPITAL BUDGET/PROGRAM MESSAGE\"","v":"2025 CAPITAL BUDGET/PROGRAM MESSAGE"}]
[]
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[]
[{"$f":"\"Fiscal Year: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"Fiscal Year: July 01, 2024 to June 30, 2025"}]
[]
["Answer all questions below using the space provided."]
[]
["This section is included in the Capital Budget pursuant to N.J.A.C. 5:31-2.  It does not in itself confer any authorization to raise or expend"]
["fund.  Rather, it is a document used as part of the Housing Authority's planning and management system.  Specific authorization to "]
["spend funds for the purposes described in this section must be granted elsewhere, by a separate financing agreement, security"]
["agreement, by resolution appropriating funds from the Renewal and Replacement Reserve, or other lawful means. "]
[]
["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 plan or report and have the full life cycle costs of each"]
["been calculated?"]
[]
["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 - HUD)."]
[]
[]
[]
[]
["5. Have the current capital projects been reviewed and approved by HUD?"]
[]
["Provide additional documentation as necessary.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page CB-2"]

{"sheet":"CB-3 Capital Budget Proposed","index":49,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8],[3,4,3,8],[31,0,31,8],[1,0,1,8],[46,0,46,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[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"]
["Public Housing Management"]
[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}]
["Section 8 "]
[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}]
["Housing Voucher"]
[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}]
["Other Programs"]
[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}]
["TOTAL PROPOSED CAPITAL BUDGET",null,{"$f":"+C29+C23+C17+C11","v":0},null,{"$f":"+E29+E23+E17+E11","v":0},0,0,0,0]
[]
["Enter brief description of up to four projects for each operation above. For operations with more than four budgeted projects, please attach additional schedules. Input total amount of all projects for the operation on single line and enter \"See Attached Schedule\" instead of project description."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page CB-3"]

{"sheet":"CB-4 5 Year Capital Budget Cost","index":50,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,4,3,9],[31,0,31,9],[1,0,1,9],[50,0,50,9]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[null,null,null,null,"Fiscal Year Beginning in"]
[null,null,"Estimated Total Cost",null,{"$f":"+\"Current Budget Year \"&'KEY INPUTS'!B2&\"\"","v":"Current Budget Year 2025"},{"$f":"\"\"&'KEY INPUTS'!B2+1&\"\"","v":"2026"},{"$f":"+F5+1","v":2027},{"$f":"G5+1","v":2028},{"$f":"H5+1","v":2029},{"$f":"I5+1","v":2030}]
["Public Housing Management"]
[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]
["Section 8"]
[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]
["Housing Voucher"]
[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]
["Other Programs"]
[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]
["TOTAL ",null,{"$f":"+C29+C23+C17+C11","v":0},null,{"$f":"+E29+E23+E17+E11","v":0},0,0,0,0,0]
[]
["Project descriptions entered on Page CB-3 will carry forward to Pages CB-4 and CB-5. No need to re-enter project descriptions above. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page CB-4"]

{"sheet":"CB-5 5 Year Capital Budget Fund","index":51,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,8],[3,4,3,8],[33,0,33,8],[1,0,1,8],[48,0,48,8]]}
[{"$f":"'KEY INPUTS'!B5","v":"(Select Housing Authority)"}]
[{"$f":"\"For the Period: \"&TEXT('KEY INPUTS'!B3, \"mmmm dd, yyyy\")&\" to \"&TEXT('KEY INPUTS'!B4, \"mmmm dd, yyyy\")&\"\"","v":"For the Period: July 01, 2024 to June 30, 2025"}]
[]
[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"]
["Public Housing Management"]
[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}]
["Section 8"]
[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}]
["Housing Voucher"]
[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}]
["Other Programs"]
[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}]
["TOTAL ",null,{"$f":"+C29+C23+C17+C11","v":0},null,{"$f":"+E29+E23+E17+E11","v":0},{"$f":"+F29+F23+F17+F11","v":0},{"$f":"+G29+G23+G17+G11","v":0},{"$f":"+H29+H23+H17+H11","v":0},{"$f":"+I29+I23+I17+I11","v":0}]
[null,"Total 5 Year Plan per CB-4",{"$f":"'CB-4 5 Year Capital Budget Cost'!C30","v":0}]
[null,"Balance check",{"$f":"C30-C31","v":0},"If amount is other than zero, verify that projects listed above match projects listed on CB-4."]
[]
["Project descriptions entered on Page CB-3 will carry forward to Pages CB-4 and CB-5. No need to re-enter project descriptions above. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Page CB-5"]

{"sheet":"Appendix-Change Orders","index":52,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,1,39,16],[2,1,2,16],[3,1,3,16],[6,3,6,9],[6,13,6,16],[36,10,36,14],[37,3,37,5],[37,10,37,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 Housing 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":"2023-06-30"}]
[]
[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"]