{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Proposed Budget Worksheet","Leased Units","Rental Assistance Worksheet","Supportive Services ","Operating"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Proposed Budget Worksheet","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,3,10,8],[1,0,1,1],[2,3,3,8],[4,3,4,8],[0,0,0,1],[2,0,3,0],[2,1,3,1]]}
["Project Name"]
["(enter project name here)"]
["Project Type  (Eg.  TH/RRH/SSO/SSO-CE etc.):","(enter project type here)",null,"The FY 2026 Spokane, WA HUD Metro FMR Area FMRs for All Bedroom Sizes"]
[]
["Eligible Costs","Annual Assistance Requested",null,"Final FY 2024 & Final FY 2023 FMRs By Unit Bedrooms"]
["Leased Units",{"$f":"'Leased Units'!J26","v":0},null,"Year","Efficiency","One-Bedroom","Two-Bedroom","Three-Bedroom","Four-Bedroom"]
["Rental Assistance",{"$f":"'Rental Assistance Worksheet'!J23","v":0},null,"FY 2026 FMR",1103,1193,1531,2088,2506]
["Supportive Services",{"$f":"'Supportive Services '!F24","v":0},null,"FY 2025 FM",998,1123,1444,1997,2339]
["Operating",{"$f":"Operating!C15","v":0},null,"Spokane County, WA is part of the Spokane, WA HUD Metro FMR Area, which consists of the following counties: Spokane County, WA. All information here applies to the entirety of the Spokane, WA HUD Metro FMR Area."]
["Sub-total Costs Requested",{"$f":"SUM(B6:B9)","v":0}]
["Agency Admin (up to 5% of the total of the HUD estimated amount)"]
["UFA City Admin Costs (5% of the HUD estimated amount)"]
["Total Assistance plus admin requested*",{"$f":"SUM(B10:B12)","v":0}]
["Cash Match"]
["In-Kind Match"]
["Total Match(Min. 25% of Total Assistance Requested)",{"$f":"SUM(B14:B15)","v":0}]
["Total Budget",{"$f":"SUM(B13+B16)","v":0}]
[]
["All Budget amounts should be for costs anticipated to be incurred during the FY 2026 grant term (8/1/2027-7/31/2028)"]

{"sheet":"Leased Units","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,3,0,7],[4,3,4,7]]}
[null,null,null,"Leasing Units Worksheet"]
[null,"Leasing",null,{"$f":"SUM(J26)","v":0}]
[]
[]
[null,"County/FMR Area:",null,"Spokane, WA HUD Metro FMR Area"]
[]
[null,"Address:",null,null,null,"If multiple addresses, include those in the Project Detail Workbook"]
[null,"City:"]
[null,"State:"]
[null,"Zip:"]
[]
[null,"Size of Units",null,"# of Units",null,"FMR Rate",null,"# of Months",null,"Total Budget"]
[]
[null,"Efficiency",null,null,"x",1103,"x",12,"=",{"$f":"(D14*F14*H14)","v":0}]
[]
[null,"1 Bedroom",null,null,"x",1193,"x",12,"=",{"$f":"(D16*F16*H16)","v":0}]
[]
[null,"2 Bedrooms",null,null,"x",1531,"x",12,"=",{"$f":"(D18*F18*H18)","v":0}]
[]
[null,"3 Bedrooms",null,null,"x",2088,"x",12,"=",{"$f":"(D20*F20*H20)","v":0}]
[]
[null,"4 Bedrooms",null,null,"x",2506,"x",12,"=",{"$f":"(D22*F22*H22)","v":0}]
[]
[null,"Other",null,null,"x",null,"x",12,"=",{"$f":"(D24*F24*H24)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D14,D16,D18,D20,D22,D24)","v":0},null,null,null,null,"=",{"$f":"SUM(J14,J16,J18,J20,J22,J24)","v":0}]

{"sheet":"Rental Assistance Worksheet","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,3,0,7],[2,3,2,7],[6,3,6,7]]}
[null,null,null,"Rental Assistance Worksheet"]
[]
[]
[null,"Rental Assistance:",null,{"$f":"SUM(J21)","v":0}]
[]
[]
[null,"County/FMR Area:",null,"Spokane, WA HUD Metro FMR Area"]
[]
[null,"Size of Units",null,"# of Units",null,"FMR Rate",null,"# of Months",null,"Total Budget"]
[]
[null,"Efficiency",null,null,"x",1103,"x",12,"=",{"$f":"(D11*F11*H11)","v":0}]
[]
[null,"1 Bedroom",null,null,"x",1193,"x",12,"=",{"$f":"(D13*F13*H13)","v":0}]
[]
[null,"2 Bedrooms",null,null,"x",1531,"x",12,"=",{"$f":"(D15*F15*H15)","v":0}]
[]
[null,"3 Bedrooms",null,null,"x",2088,"x",12,"=",{"$f":"(D17*F17*H17)","v":0}]
[]
[null,"4 Bedrooms",null,null,"x",2506,"x",12,"=",{"$f":"(D19*F19*H19)","v":0}]
[]
[null,"Other",null,null,"x",null,"x",12,"=",{"$f":"(D21*F21*H21)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D11,D13,D15,D17,D19,D21)","v":0},null,null,null,null,"=",{"$f":"SUM(J11,J13,J15,J17,J19,J21)","v":0}]

{"sheet":"Supportive Services ","index":3,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,0,43,4],[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[2,1,4,5],[2,0,4,0],[23,0,23,4],[21,1,21,4],[22,1,22,4],[19,1,19,4],[8,1,8,4],[9,1,9,4],[26,1,26,4],[27,1,27,4],[25,0,25,5],[1,0,1,5],[16,1,16,4],[17,1,17,4],[18,1,18,4],[20,1,20,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[6,1,6,4],[7,1,7,4]]}
[]
["Supportive Services "]
["Quantity and Description:","Include a specific description of how this eligible cost category will be used including quantities and cost / unit.  See example at the bottom of this worksheet.  For additional information on these items, see: https://www.hudexchange.info/homelessness-assistance/coc-esg-virtual-binders/coc-eligible-activities/supportive-services/"]
[]
[]
[]
["Eligible Cost","Quantity AND Description",null,null,null,"Annual Assistance Requested"]
["Assessment Of Service Needs"]
["Assistance With Moving Costs"]
["Case Management"]
["Child Care"]
["Education Services"]
["Employment Assistance "]
["Food"]
["Housing/Counseling Services"]
["Legal Services"]
["Life Skills "]
["Mental Health Services"]
["Outpatient Health Services"]
["Outreach Services"]
["Substance Abuse Treatment Services"]
["Transportation "]
["Utility Deposits"]
["TOTAL ",null,null,null,null,{"$f":"SUM(F8:F23)","v":0}]
[]
["EXAMPLE"]
["Eligible Cost","Quantity AND Description",null,null,null,"Annual Assistance Requested"]
["Assessment Of Service Needs",".5 FTE Assessor at $50k/year",null,null,null,25000]
["Assistance With Moving Costs","Truck Rental for move in - 6 households @ $300/household",null,null,null,1800]
["Case Management","2.0 FTE Case Managers at $75k/year",null,null,null,150000]
["Child Care"]
["Education Services"]
["Employment Assistance "]
["Food"]
["Housing/Counseling Services"]
["Legal Services"]
["Life Skills "]
["Mental Health Services"]
["Outpatient Health Services"]
["Outreach Services"]
["Substance Abuse Treatment Services"]
["Transportation ","Travel to housing units @ $0.25/mile.  ~ 1000 miles/year",null,null,null,250]
["Utility Deposits"]
["TOTAL ",null,null,null,null,{"$f":"SUM(F28:F43)","v":177050}]

{"sheet":"Operating","index":4,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[14,0,14,1],[1,0,3,0],[1,1,3,2],[0,0,0,2],[26,0,26,1],[16,0,16,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]]}
["Operating Costs"]
["Quantity and Description:","Include a specific description of how this eligible cost category will be used including quantities and cost / unit.  See example at the bottom of this worksheet.  For additional information on these items, see: https://www.hudexchange.info/homelessness-assistance/coc-esg-virtual-binders/coc-eligible-activities/operating-costs/"]
[]
[]
[]
["Eligible Cost","Quantity AND Description","Annual Assistance Requested"]
["Maintenance/Repair"]
["Property Taxes and Insurance"]
["Replacement Reserve"]
["Building Security"]
["Electricity, Gas, Water, sewer, trash removal"]
["Furniture"]
["Equipment (lease, buy)"]
["Staff time spent carrying out the above eligible operating activities that are part of the approved grant"]
["TOTAL",null,{"$f":"SUM(C7:C13)","v":0}]
[]
["EXAMPLE"]
["Eligible Cost","Quantity AND Description","Annual Assistance Requested"]
["Maintenance/Repair","HH Transition Maintenance to Units.   20 units @$100/unit",2000]
["Property Taxes and Insurance"]
["Replacement Reserve"]
["Building Security",".75 FTE Building Security @100k/year",75000]
["Electricity, Gas, Water, sewer, trash removal"]
["Furniture","5 replacement mattresses @$150/unit and 4 replacement desks $50/unit",950]
["Equipment (lease, buy)"]
["Staff time spent carrying out the above eligible operating activities that are part of the approved grant"]
["TOTAL",null,{"$f":"SUM(C19:C25)","v":77950}]