{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Bridges Summary","Contact Information","Names","Data Validation","Bridges Utilization"," Bridges RTC Summary","Bridges RTC Utilization","Bridges Current Grantees","Bridges RTC Current Grantees"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":635,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":115,"n_cols":3,"rows_kept":115,"cut":false,"hidden":false,"merged":[[15,1,15,3],[7,1,7,3],[16,1,16,3],[22,1,22,3],[19,1,19,3],[20,1,20,3],[18,1,18,3],[13,1,13,3],[14,1,14,3],[0,1,0,3],[4,1,4,3],[2,1,2,3],[10,1,10,3],[8,1,8,3],[3,1,3,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[60,1,60,3],[61,1,61,3]]}
[null,"MINNESOTA HOUSING BRIDGES AND BRIDGES RTC  BUDGET WORKBOOK INSTRUCTIONS"]
[]
[null,"General Instructions"]
[null,"Complete all tabs by entering relevant information. Any cell that is  yellow needs to have data entered by the applicant."]
[null,"Complete all tabs that are relevant to the funding for which you are applying. If you are applying for Bridges and Bridges RTC, complete the tabs applicable to both programs. New applicants do not need to complete the Current Grantee tab."]
[null,"There are six tabs beyond the Instructions tab. Information pertaining to each tab is listed below. "]
[]
[null,"Contact Information Tab (Bridges and Bridges RTC Applicants) "]
[null,"Enter full information for each relevant contact type. If one organization fills more than one role, please enter applicable information in each contact type.  "]
[]
[null,"Bridges Summary "]
[null,"Development Number: Found on Exhibit A of the current Grant Agreement. Not applicable for new grantees."]
[null,"Application Date: Due date for the RFP "]
[null,"Applicant: Name of grantee organization"]
[null,"Service Area: List all counties and tribal nations in your service area"]
[null,"Enter the name of your Continuum of Care (CoC) Region"]
[null,"Enter the name of your Adult Mental Health Initiative (AMHI) "]
[]
[null,"Enter number of households you anticipate serving per month"]
[null,"Enter the amount of admin fee you are requesting: Refer to current Grant Agreement. If new applicant, enter proposed admin fee"]
[null,"Admin Fee permitted range is $53 to $68(current grantees increase current amount by $8 per household per month, new applicants refer to Bridges and Bridges RTC Program guide for admin fee guidance)"]
[]
[null,"Enter the funding requested in each category"]
[]
[null,"Identify Agency (Agencies) that operate a Housing Choice Vouchers (HCV) Program or Native American Housing Assistance and Self Determination Act (NAHASDA) opportunities in the area you anticipate serving and the estimated waiting time for households to receive assistance."]
[null,"Complete the agency name; waiting list open; expected wait time","     "]
[]
[null,"Staff Costs Associated with Administering Bridges (please include staff from partnering agencies). Do not include fringe or other related costs."]
[null,"Staff Title"]
[null,"Bridges Related Task(s)"]
[null,"Hourly Rate","     "]
[null,"Average staff hours a month"]
[null,null,"     "]
[null,"List all Organizations and Institutions from which you will Receive Referrals  (Coordinated Entry should be listed)"]
[null,"Name of Organization/Institution"]
[null,"Type of Organization/Institution"]
[null,"Anticipated Average Number of Annual Referrals"]
[null,"     ","     "]
[null,"Bridges Utilization","     "]
[null,"UTILIZATION PROJECTION FOR FUNDING REQUEST"]
[null,"Complete each of the yellow fields/ Hover over the column headings to see instructions within this section"]
[null," # of Households (HH)- estimate the number of households expected to be in housing each month"]
[null,"Average Rental Subsidy/HH -estimate the average subsidy amount, using the contract rent minus expected income contributions"]
[null,"Average Housing Related Expenses - include security deposits and up to one application fee/  Some months should be blank or $0, unless you anticipate a new security deposit each month"]
[null,"Note: If there is an amount entered in Column G, and Column H shows a negative amount or no amount, manually enter the Monthly Housing Related Expense in Column H"]
[null," Administrative Fee/HH - permitted range of $53 to $68 (current grantees increase current amount by $8 per household per month, new applicants refer to Bridges guide for admin fee guidance)"]
[]
[null,"Bridges RTC Summary"]
[null,"Development Number: Found on Exhibit A of the current Grant Agreement. Not applicable for new grantees"]
[null,"Application Date: Due date for the RFP "]
[null,"Applicant: Name of grantee organization"]
[null,"Program Name: N/A"]
[null,"Service Area: List all counties and tribal nations in your service area"]
[null,"Enter the name of your Continuum of Care (CoC) Region"]
[null,"Enter the name of your Adult Mental Health Initiative (AMHI) "]
[]
[null,"Enter number of households you anticipate serving per month"]
[null,"Enter the amount of admin fee you are requesting: Refer to current Grant Agreement. If new applicant, enter proposed admin fee"]
[null,"Admin Fee permitted range is $53 to $68 (current grantees increase current amount by $8 per household per month, new applicants refer to Bridges and Bridges RTC Program guide for admin fee guidance)"]
[]
[null,"Enter the funding requested in each category"]
[]
[null,"Identify Agency (Agencies) that operate a Housing Choice Vouchers (HCV) Program or Native American Housing Assistance and Self Determination Act (NAHASDA) opportunities in the area you anticipate serving and the estimated waiting time for households to receive assistance."]
[null,"Complete the agency name; waiting list open; expected wait time","     "]
[]
[null,"Staff Costs Associated with Administering Bridges (please include staff from partnering agencies). Do not include fringe or other related costs."]
[null,"Staff Title"]
[null,"Bridges Related Task(s)"]
[null,"Hourly Rate","     "]
[null,"Average staff hours a month"]
[]
[null,"Bridges RTC Utilization"]
[null,"UTILIZATION PROJECTION FOR FUNDING REQUEST"]
[null,"Complete each of the yellow fields. Hover over the column headings to see instructions within this section."]
[null,"Number of Households (HH): Estimate the number of households expected to be in housing each month"]
[null,"Average Rental Subsidy/HH: Estimate the average subsidy amount, using the contract rent minus expected income contributions"]
[null,"Average Housing Related Expenses: Include security deposits and up to one application fee/ Some months should be blank or $0, unless you anticipate a new security deposit each month"]
[null,"NOTE: If there is an amount entered in Column G, and Column H shows a negative amount or no amount, manually enter the Monthly Housing Related Expense in Column H"]
[null,"Administrative Fee/HH - permitted range of $53 to $68 (current grantees increase current amount by $8 per household per month, new applicants refer to Bridges guide for admin fee guidance)"]
[]
[null,"Bridges Current Grantees"]
[null,"Complete the grant and participant information for the months completed in your current grant period "]
[null,"Enter the number of months have you completed in your current grant term"]
[null,"What was the number of households that transitioned to another permanent subsidy?"]
[null,"How many households were terminated due to eviction or notice to vacate?"]
[null,"How many households were initially enrolled but unable to find housing? "]
[]
[null,"List the percentages of the priority populations for your current participants:"]
[null,"Percentage leaving institutions or segregated settings"]
[null,"Percentage of households at imminent risk of homelessness"]
[null,"Percentage of households experiencing homelessness"]
[]
[null,"Grant Utilization and Adult Mental Health Initiative Resources "]
[null,"Estimated percentage of the grant that will be utilized at the end of the contract period"]
[null,"What was the total amount of dollars spent on housing subsidies through AMHI (BRASS Code 443x) for the current contract term?         "]
[null,"How many households did the AMHI resources serve?  "]
[]
[null," Bridges RTC Current Grantees"]
[null,"Complete the grant and participant information for the months completed in your current grant period "]
[null,"Enter the number of months have you completed in your current grant term"]
[null,"What was the number of households that transitioned to another permanent subsidy?"]
[null,"How many households were terminated due to eviction or notice to vacate?"]
[null,"How many households were initially enrolled but unable to find housing? "]
[]
[null,"List the percentages of the priority populations for your current participants:"]
[null,"Percentage leaving institutions or segregated settings"]
[null,"Percentage of households at imminent risk of homelessness"]
[null,"Percentage of households experiencing homelessness"]
[]
[null,"Grant Utilization and Adult Mental Health Initiative Resources "]
[null,"Estimated percentage of the grant that will be utilized at the end of the contract period"]
[null,"What was the total amount of dollars spent on housing subsidies through AMHI (BRASS Code 443x) for the current contract term?         "]
[null,"How many households did the AMHI resources serve?  "]
[]
[null,"Ver. 2.19.19"]

{"sheet":"Bridges Summary","index":1,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,3],[22,1,22,3],[30,1,30,3],[39,1,39,3]]}
[null,"BRIDGES SUMMARY (2022-2023 Request for Proposals) "]
[]
[null,"Development Number"]
[null,"Application Date"]
[null,"Grant Start Date","2021-07-01"]
[null,"Grant End Date","2023-06-30"]
[null,"Applicant"]
[null,"Service Area "]
[null,"County (Counties) "]
[null,"Tribal Nation(s)"]
[null,"Continuum of Care (CoC) Region"]
[null,"Adult Mental Health Initiative (AMHI)"]
[]
[null,"Target Number of Households/Month"]
[null,"Administrative Fee Amount"]
[]
[null,"Funding Request Summary","Amount For Each Type"]
[null,"Total Rental Assistance (subsidy only)"]
[null,"Total Administrative Fees"]
[null,"Total Housing Related Expenses"]
[null,"Total Amount of Funding Requested (Bridges) ",{"$f":"SUM(C18:C20)","v":0}]
[]
[null,"Agency (ies) that Operate (HCV) Program or Native American Housing Assistance and Self Determination Act (NAHASDA) Opportunities "]
[null,"Agency Name ","Is the waiting list open?","Estimated Wait time"]
[null,"     ","     ","     "]
[null,null,"     ","     "]
[]
[]
[null,"     ","     ","     "]
[]
[null,"Staff Costs Associated with Administering Bridges (please include staff from partnering agencies)"]
[null,"Staff Title","Bridges Related Task(S)","Hourly Rate","Average Staff Hours a Month"]
[]
[]
[]
[]
[]
[null,null,null,"Total Staff Hours a Month",{"$f":"SUM(E33:E37)","v":0}]
[]
[null,"List the Organizations/ Institutions that you will receive referrrals from and indicate the type"]
[null,"Name of Organization/Institution","Type of Organization/Institution"]
[null,"     ","     "]
[null,"     ","     "]
[null,"     ","     "]

{"sheet":"Contact Information","index":2,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"CONTACT INFORMATION"]
[]
[null,"Applicant Agency Name"]
[null,"Contact person"]
[null,"Title"]
[null,"Address"]
[null,"City"]
[null,"State"]
[null,"Zip Code"]
[null,"Phone"]
[null,"Email"]
[]
[null,"Adult Mental Health Initiative"]
[null,"Contact person"]
[null,"Title"]
[null,"Address"]
[null,"City"]
[null,"State"]
[null,"Zip Code"]
[null,"Phone"]
[null,"Email"]
[]
[null,"Contact Information to Apply for Bridges"]
[null,"Contact person"]
[null,"Title"]
[null,"Address"]
[null,"City"]
[null,"State"]
[null,"Zip Code"]
[null,"Phone"]
[null,"Email"]
[]
[null,"County and/or Tribal Nation Mental Health Agency"]
[null,"Contact person"]
[null,"Title"]
[null,"Address"]
[null,"City"]
[null,"State"]
[null,"Zip Code"]
[null,"Phone"]
[null,"Email"]

{"sheet":"Names","index":3,"n_rows":301,"n_cols":2,"rows_kept":301,"cut":false,"hidden":true,"merged":[]}
["Name","Sheet"]
["grantMgmt","Contact Info"]
["grantMgmtAddr","Contact Info"]
["grantMgmtCity","Contact Info"]
["grantMgmtContact","Contact Info"]
["grantMgmtEmail","Contact Info"]
["grantMgmtPhone","Contact Info"]
["grantMgmtState","Contact Info"]
["grantMgmtZip","Contact Info"]
["hmis","Contact Info"]
["hmisAddr","Contact Info"]
["hmisCity","Contact Info"]
["hmisContact","Contact Info"]
["hmisEmail","Contact Info"]
["hmisPhone","Contact Info"]
["hmisState","Contact Info"]
["hmisZip","Contact Info"]
["mhis","Contact Info"]
["mhisAddr","Contact Info"]
["mhisCity","Contact Info"]
["mhisContact","Contact Info"]
["mhisEmail","Contact Info"]
["mhisPhone","Contact Info"]
["mhisState","Contact Info"]
["mhisZip","Contact Info"]
["ownAddr","Contact Info"]
["ownCity","Contact Info"]
["ownContact","Contact Info"]
["ownEmail","Contact Info"]
["owner","Contact Info"]
["ownPhone","Contact Info"]
["ownState","Contact Info"]
["ownZip","Contact Info"]
["propMgr","Contact Info"]
["propMgrAddr","Contact Info"]
["propMgrCity","Contact Info"]
["propMgrContact","Contact Info"]
["propMgrEmail","Contact Info"]
["propMgrPhone","Contact Info"]
["propMgrState","Contact Info"]
["propMgrZip","Contact Info"]
["servProv","Contact Info"]
["servProvAddr","Contact Info"]
["servProvCity","Contact Info"]
["servProvContact","Contact Info"]
["servProvEmail","Contact Info"]
["servProvPhone","Contact Info"]
["servProvState","Contact Info"]
["servProvZip","Contact Info"]
["DateSign_FD","FD and TSC Budget"]
["Desc1","FD and TSC Budget"]
["Desc2","FD and TSC Budget"]
["Desc3","FD and TSC Budget"]
["Desc4","FD and TSC Budget"]
["Desc5","FD and TSC Budget"]
["Desc6","FD and TSC Budget"]
["Desc7","FD and TSC Budget"]
["ExpDesc1","FD and TSC Budget"]
["ExpDesc10","FD and TSC Budget"]
["ExpDesc11","FD and TSC Budget"]
["ExpDesc12","FD and TSC Budget"]
["ExpDesc13","FD and TSC Budget"]
["ExpDesc14","FD and TSC Budget"]
["ExpDesc15","FD and TSC Budget"]
["ExpDesc16","FD and TSC Budget"]
["ExpDesc17","FD and TSC Budget"]
["ExpDesc18","FD and TSC Budget"]
["ExpDesc19","FD and TSC Budget"]
["ExpDesc2","FD and TSC Budget"]
["ExpDesc3","FD and TSC Budget"]
["ExpDesc4","FD and TSC Budget"]
["ExpDesc5","FD and TSC Budget"]
["ExpDesc6","FD and TSC Budget"]
["ExpDesc7","FD and TSC Budget"]
["ExpDesc8","FD and TSC Budget"]
["ExpDesc9","FD and TSC Budget"]
["ExpLY1","FD and TSC Budget"]
["ExpLY10","FD and TSC Budget"]
["ExpLY11","FD and TSC Budget"]
["ExpLY12","FD and TSC Budget"]
["ExpLY13","FD and TSC Budget"]
["ExpLY14","FD and TSC Budget"]
["ExpLY15","FD and TSC Budget"]
["ExpLY16","FD and TSC Budget"]
["ExpLY17","FD and TSC Budget"]
["ExpLY18","FD and TSC Budget"]
["ExpLY19","FD and TSC Budget"]
["ExpLY2","FD and TSC Budget"]
["ExpLY3","FD and TSC Budget"]
["ExpLY4","FD and TSC Budget"]
["ExpLY5","FD and TSC Budget"]
["ExpLY6","FD and TSC Budget"]
["ExpLY7","FD and TSC Budget"]
["ExpLY8","FD and TSC Budget"]
["ExpLY9","FD and TSC Budget"]
["ExpPurp1","FD and TSC Budget"]
["ExpPurp10","FD and TSC Budget"]
["ExpPurp11","FD and TSC Budget"]
["ExpPurp12","FD and TSC Budget"]
["ExpPurp13","FD and TSC Budget"]
["ExpPurp14","FD and TSC Budget"]
["ExpPurp15","FD and TSC Budget"]
["ExpPurp16","FD and TSC Budget"]
["ExpPurp17","FD and TSC Budget"]
["ExpPurp18","FD and TSC Budget"]
["ExpPurp19","FD and TSC Budget"]
["ExpPurp2","FD and TSC Budget"]
["ExpPurp3","FD and TSC Budget"]
["ExpPurp4","FD and TSC Budget"]
["ExpPurp5","FD and TSC Budget"]
["ExpPurp6","FD and TSC Budget"]
["ExpPurp7","FD and TSC Budget"]
["ExpPurp8","FD and TSC Budget"]
["ExpPurp9","FD and TSC Budget"]
["ExpTY1","FD and TSC Budget"]
["ExpTY10","FD and TSC Budget"]
["ExpTY11","FD and TSC Budget"]
["ExpTY12","FD and TSC Budget"]
["ExpTY13","FD and TSC Budget"]
["ExpTY14","FD and TSC Budget"]
["ExpTY15","FD and TSC Budget"]
["ExpTY16","FD and TSC Budget"]
["ExpTY17","FD and TSC Budget"]
["ExpTY18","FD and TSC Budget"]
["ExpTY19","FD and TSC Budget"]
["ExpTY2","FD and TSC Budget"]
["ExpTY3","FD and TSC Budget"]
["ExpTY4","FD and TSC Budget"]
["ExpTY5","FD and TSC Budget"]
["ExpTY6","FD and TSC Budget"]
["ExpTY7","FD and TSC Budget"]
["ExpTY8","FD and TSC Budget"]
["ExpTY9","FD and TSC Budget"]
["ExpType1","FD and TSC Budget"]
["ExpType10","FD and TSC Budget"]
["ExpType11","FD and TSC Budget"]
["ExpType12","FD and TSC Budget"]
["ExpType13","FD and TSC Budget"]
["ExpType14","FD and TSC Budget"]
["ExpType15","FD and TSC Budget"]
["ExpType16","FD and TSC Budget"]
["ExpType17","FD and TSC Budget"]
["ExpType18","FD and TSC Budget"]
["ExpType19","FD and TSC Budget"]
["ExpType2","FD and TSC Budget"]
["ExpType3","FD and TSC Budget"]
["ExpType4","FD and TSC Budget"]
["ExpType5","FD and TSC Budget"]
["ExpType6","FD and TSC Budget"]
["ExpType7","FD and TSC Budget"]
["ExpType8","FD and TSC Budget"]
["ExpType9","FD and TSC Budget"]
["FD_MOS","FD and TSC Budget"]
["FiscalYearEnd","FD and TSC Budget"]
["LY_1","FD and TSC Budget"]
["LY_2","FD and TSC Budget"]
["LY_3","FD and TSC Budget"]
["LY_4","FD and TSC Budget"]
["LY_5","FD and TSC Budget"]
["LY_6","FD and TSC Budget"]
["LY_7","FD and TSC Budget"]
["OwnerSign_FD","FD and TSC Budget"]
["Purpose1","FD and TSC Budget"]
["Purpose2","FD and TSC Budget"]
["Purpose3","FD and TSC Budget"]
["Purpose4","FD and TSC Budget"]
["Purpose5","FD and TSC Budget"]
["Purpose6","FD and TSC Budget"]
["Purpose7","FD and TSC Budget"]
["SCNotes1","FD and TSC Budget"]
["SCNotes10","FD and TSC Budget"]
["SCNotes11","FD and TSC Budget"]
["SCNotes12","FD and TSC Budget"]
["SCNotes13","FD and TSC Budget"]
["SCNotes14","FD and TSC Budget"]
["SCNotes15","FD and TSC Budget"]
["SCNotes16","FD and TSC Budget"]
["SCNotes17","FD and TSC Budget"]
["SCNotes18","FD and TSC Budget"]
["SCNotes19","FD and TSC Budget"]
["SCNotes2","FD and TSC Budget"]
["SCNotes20","FD and TSC Budget"]
["SCNotes21","FD and TSC Budget"]
["SCNotes3","FD and TSC Budget"]
["SCNotes4","FD and TSC Budget"]
["SCNotes5","FD and TSC Budget"]
["SCNotes6","FD and TSC Budget"]
["SCNotes7","FD and TSC Budget"]
["SCNotes8","FD and TSC Budget"]
["SCNotes9","FD and TSC Budget"]
["SCPropertyName","FD and TSC Budget"]
["SCPropertyNumber","FD and TSC Budget"]
["Source1","FD and TSC Budget"]
["Source2","FD and TSC Budget"]
["Source3","FD and TSC Budget"]
["Source4","FD and TSC Budget"]
["Source5","FD and TSC Budget"]
["Source6","FD and TSC Budget"]
["Source7","FD and TSC Budget"]
["TY_1","FD and TSC Budget"]
["TY_2","FD and TSC Budget"]
["TY_3","FD and TSC Budget"]
["TY_4","FD and TSC Budget"]
["TY_5","FD and TSC Budget"]
["TY_6","FD and TSC Budget"]
["TY_7","FD and TSC Budget"]
["appDate","Grant Renewal Info"]
["applicant","Grant Renewal Info"]
["city","Grant Renewal Info"]
["county","Grant Renewal Info"]
["fdAmount","Grant Renewal Info"]
["FrontDesk","Grant Renewal Info"]
["grantAmt","Grant Renewal Info"]
["hhType","Grant Renewal Info"]
["LTHUnits","Grant Renewal Info"]
["numSHunits","Grant Renewal Info"]
["projName","Grant Renewal Info"]
["Revenue","Grant Renewal Info"]
["rsfAmount","Grant Renewal Info"]
["smiUnits","Grant Renewal Info"]
["Tenant","Grant Renewal Info"]
["tscAmount","Grant Renewal Info"]
["DateSign","RSF Budget"]
["FiscalYE","RSF Budget"]
["LY_AdminMarketing","RSF Budget"]
["LY_Insurance","RSF Budget"]
["LY_InterestIncome","RSF Budget"]
["LY_LTHUnits","RSF Budget"]
["LY_MaintOper","RSF Budget"]
["LY_MgmntFee","RSF Budget"]
["LY_MortInterest","RSF Budget"]
["LY_MortPrincipal","RSF Budget"]
["LY_NetReserveActivity","RSF Budget"]
["LY_OperatingSubsidy","RSF Budget"]
["LY_OtherFinExp","RSF Budget"]
["LY_OtherIncome","RSF Budget"]
["LY_RentalSubsidy","RSF Budget"]
["LY_ReserveBal","RSF Budget"]
["LY_ReserveDeposits","RSF Budget"]
["LY_RETaxes","RSF Budget"]
["LY_SMIUnits","RSF Budget"]
["LY_TenantRents","RSF Budget"]
["LY_Utilities","RSF Budget"]
["LY_VacancyLoss","RSF Budget"]
["LY_VacantUnits","RSF Budget"]
["OSMOS","RSF Budget"]
["OSNotes1","RSF Budget"]
["OSNotes10","RSF Budget"]
["OSNotes11","RSF Budget"]
["OSNotes12","RSF Budget"]
["OSNotes13","RSF Budget"]
["OSNotes14","RSF Budget"]
["OSNotes15","RSF Budget"]
["OSNotes16","RSF Budget"]
["OSNotes17","RSF Budget"]
["OSNotes18","RSF Budget"]
["OSNotes19","RSF Budget"]
["OSNotes2","RSF Budget"]
["OSNotes20","RSF Budget"]
["OSNotes21","RSF Budget"]
["OSNotes22","RSF Budget"]
["OSNotes23","RSF Budget"]
["OSNotes24","RSF Budget"]
["OSNotes25","RSF Budget"]
["OSNotes26","RSF Budget"]
["OSNotes27","RSF Budget"]
["OSNotes28","RSF Budget"]
["OSNotes29","RSF Budget"]
["OSNotes3","RSF Budget"]
["OSNotes30","RSF Budget"]
["OSNotes4","RSF Budget"]
["OSNotes5","RSF Budget"]
["OSNotes6","RSF Budget"]
["OSNotes7","RSF Budget"]
["OSNotes8","RSF Budget"]
["OSNotes9","RSF Budget"]
["OSPropertyName","RSF Budget"]
["OSPropertyNumber","RSF Budget"]
["OwnerSign","RSF Budget"]
["TotalUnits","RSF Budget"]
["TY_AdminMarketing","RSF Budget"]
["TY_Insurance","RSF Budget"]
["TY_InterestIncome","RSF Budget"]
["TY_LTHUnits","RSF Budget"]
["TY_MaintOper","RSF Budget"]
["TY_MgmntFee","RSF Budget"]
["TY_MortInterest","RSF Budget"]
["TY_MortPrincipal","RSF Budget"]
["TY_NetReserveActivity","RSF Budget"]
["TY_OperatingSubsidy","RSF Budget"]
["TY_OtherFinExp","RSF Budget"]
["TY_OtherIncome","RSF Budget"]
["TY_RentalSubsidy","RSF Budget"]
["TY_ReserveBal","RSF Budget"]
["TY_ReserveDeposits","RSF Budget"]
["TY_RETaxes","RSF Budget"]
["TY_SMIUnits","RSF Budget"]
["TY_TenantRents","RSF Budget"]
["TY_Utilities","RSF Budget"]
["TY_VacancyLoss","RSF Budget"]
["TY_VacantUnits","RSF Budget"]

{"sheet":"Data Validation","index":4,"n_rows":89,"n_cols":2,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
["co","tribe"]
[]
["Aitkin","Red Lake"]
["Anoka","White Earth"]
["Becker","Leech Lake"]
["Beltrami","Boise Forte/Nett Lake"]
["Benton","Grand Portage"]
["Big Stone","Fond du Lac"]
["Blue Earth","Mille Lacs"]
["Brown","Shakopee Mdewakanton Sioux"]
["Carlton","Prairie Island"]
["Carver","Upper Sioux"]
["Cass","Lower Sioux"]
["Chippewa"]
["Chisago"]
["Clay"]
["Clearwater"]
["Cook"]
["Cottonwood"]
["Crow Wing"]
["Dakota"]
["Dodge"]
["Douglas"]
["Faribault"]
["Fillmore"]
["Freeborn"]
["Goodhue"]
["Grant"]
["Hennepin"]
["Houston"]
["Hubbard"]
["Isanti"]
["Itasca"]
["Jackson"]
["Kanabec"]
["Kandiyohi"]
["Kittson"]
["Koochiching"]
["Lac qui Parle"]
["Lake"]
["Lake of the Woods"]
["Le Sueur"]
["Lincoln"]
["Lyon"]
["Mahnomen"]
["Marshall"]
["Martin"]
["McLeod"]
["Meeker"]
["Mille Lacs"]
["Morrison"]
["Mower"]
["Murray"]
["Nicollet"]
["Nobles"]
["Norman"]
["Olmsted"]
["Otter Tail"]
["Pennington"]
["Pine"]
["Pipestone"]
["Polk"]
["Pope"]
["Ramsey"]
["Red Lake"]
["Redwood"]
["Renville"]
["Rice"]
["Rock"]
["Roseau"]
["Scott"]
["Sherburne"]
["Sibley"]
["Saint Louis"]
["Stearns"]
["Steele"]
["Stevens"]
["Swift"]
["Todd"]
["Traverse"]
["Wabasha"]
["Wadena"]
["Waseca"]
["Washington"]
["Watonwan"]
["Wilkin"]
["Winona"]
["Wright"]
["Yellow Medicine"]

{"sheet":"Bridges Utilization","index":5,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"BRIDGES UTILIZATION PROJECTION FOR FUNDING REQUEST"]
[null,"Hover your mouse over the column headings for instructions"]
[null,"Month","# of Households (HH)","Average Rental Subsidy/HH","Monthly Rental Subsidy Expense","Average Housing Related Expenses","Monthly Housing Related Expense","Administrative Fee/HH","Monthly Administrative \nFee Expense","Total Projected Monthly Expenses"]
[null,"2021-07-01",null,null,{"$f":"SUM(C5*D5)","v":0},null,{"$f":"C5*F5","v":0},null,{"$f":"C5*H5","v":0},{"$f":"E5+G5+I5","v":0}]
[null,{"$f":"DATE(YEAR(B5)+0,MONTH(B5)+1,DAY(B5)+0)","v":"2021-08-01"},null,null,{"$f":"C6*D6","v":0},null,0,null,{"$f":"C6*H6","v":0},{"$f":"E6+G6+I6","v":0}]
[null,{"$f":"DATE(YEAR(B6)+0,MONTH(B6)+1,DAY(B6)+0)","v":"2021-09-01"},null,null,{"$f":"SUM(C7*D7)","v":0},null,0,null,0,0]
[null,"2021-10-01",null,null,{"$f":"SUM(C8*D8)","v":0},null,0,null,0,0]
[null,"2021-11-01",null,null,{"$f":"C9*D9","v":0},null,0,null,0,0]
[null,"2021-12-01",null,null,0,null,0,null,0,0]
[null,"2022-01-01",null,null,0,null,0,null,0,0]
[null,"2022-02-01",null,null,0,null,0,null,0,0]
[null,"2022-03-01",null,null,0,null,0,null,0,0]
[null,"2022-04-01",null,null,0,null,0,null,0,0]
[null,"2022-05-01",null,null,0,null,0,null,0,0]
[null,"2022-06-01",null,null,0,null,0,null,0,0]
[null,"2022-07-01",null,null,0,null,0,null,0,0]
[null,"2022-08-01",null,null,0,null,0,null,0,0]
[null,"2022-09-01",null,null,0,null,0,null,0,0]
[null,"2022-10-01",null,null,0,null,0,null,0,0]
[null,"2022-11-01",null,null,0,null,0,null,0,0]
[null,"2022-12-01",null,null,0,null,0,null,0,0]
[null,"2023-01-01",null,null,0,null,0,null,0,0]
[null,"2023-02-01",null,null,0,null,0,null,0,0]
[null,"2023-03-01",null,null,0,null,0,null,0,0]
[null,"2023-04-01",null,null,0,null,0,null,0,0]
[null,"2023-05-01",null,null,0,null,0,null,0,0]
[null,"2023-06-01",null,null,0,null,0,null,0,0]
[null,"Totals",{"$f":"SUM(C5:C28)","v":0},{"$f":"SUM(D5:D28)","v":0},{"$f":"SUM(E5:E28)","v":0},0,0,0,0,0]

{"sheet":" Bridges RTC Summary","index":6,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[19,1,19,3],[27,1,27,3],[0,1,0,3]]}
[null,"BRIDGES RTC SUMMARY (2022-2023 Request for Proposals) "]
[]
[null,"Development Number"]
[null,"Application Date"]
[null,"Grant Start Date","2021-07-01"]
[null,"Grant End Date","2023-06-30"]
[null,"Applicant"]
[null,"Service Area "]
[null,"County (Counties) "]
[null,"Tribal Nation(s)"]
[null,"Continuum of Care (CoC) Region"]
[null,"Adult Mental Health Initiative (AMHI)"]
[]
[null,"Funding Request Summary","Amount For Each Type"]
[null,"Total Rental Assistance (subsidy only)"]
[null,"Total Administrative Fees"]
[null,"Total Housing Related Expenses"]
[null,"Total Amount of Funding Requested (Bridges RTC)",{"$f":"SUM(C15:C17)","v":0}]
[]
[null,"Agency (ies) that Operate (HCV) Program or Native American Housing Assistance and Self Determination Act (NAHASDA) Opportunities "]
[null,"Agency Name ","Is the waiting list open?","Estimated Wait time"]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[]
[]
[null,"     ","     ","     "]
[]
[null,"Staff Costs Associated with Administering Bridges RTC (please include staff from partnering agencies)"]
[null,"Staff Title","Bridges Related task(S)","Hourly Rate","Average Staff Hours a Month"]
[]
[]
[]
[]
[]
[null,null,null,"Total Staff Hours a Month",{"$f":"SUM(E30:E34)","v":0}]

{"sheet":"Bridges RTC Utilization","index":7,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"BRIDGES RTC UTILIZATION PROJECTION FOR FUNDING REQUEST"]
[null,"Hover your mouse over the column headings for instructions"]
[null,"Month","# of Households (HH)","Average Rental Subsidy/HH","Monthly Rental Subsidy Expense","Average Housing Related Expenses","Monthly Housing Related Expense","Administrative Fee/HH","Monthly Administrative \nFee Expense","Total Projected Monthly Expenses"]
[null,"2021-07-01",null,null,{"$f":"C5*D5","v":0},null,{"$f":"C5*F5","v":0},null,{"$f":"C5*H5","v":0},{"$f":"E5+G5+I5","v":0}]
[null,{"$f":"DATE(YEAR(B5)+0,MONTH(B5)+1,DAY(B5)+0)","v":"2021-08-01"},null,null,{"$f":"C6*D6","v":0},null,{"$f":"C6*F6","v":0},null,{"$f":"C6*H6","v":0},{"$f":"E6+G6+I6","v":0}]
[null,{"$f":"DATE(YEAR(B6)+0,MONTH(B6)+1,DAY(B6)+0)","v":"2021-09-01"},null,null,{"$f":"SUM(C7*D7)","v":0},null,{"$f":"C7*F7","v":0},null,{"$f":"C7*H7","v":0},0]
[null,"2021-10-01",null,null,0,null,null,null,0,0]
[null,"2021-11-01",null,null,0,null,{"$f":"C9*F9","v":0},null,0,0]
[null,"2021-12-01",null,null,0,null,0,null,0,0]
[null,"2022-01-01",null,null,0,null,0,null,0,0]
[null,"2022-02-01",null,null,0,null,0,null,0,0]
[null,"2022-03-01",null,null,{"$f":"C13*D13","v":0},null,0,null,0,0]
[null,"2022-04-01",null,null,0,null,0,null,0,0]
[null,"2022-05-01",null,null,0,null,0,null,0,0]
[null,"2022-06-01",null,null,0,null,0,null,0,0]
[null,"2022-07-01",null,null,0,null,0,null,0,0]
[null,"2022-08-01",null,null,0,null,0,null,0,0]
[null,"2022-09-01",null,null,0,null,0,null,0,0]
[null,"2022-10-01",null,null,0,null,0,null,0,0]
[null,"2022-11-01",null,null,0,null,0,null,0,0]
[null,"2022-12-01",null,null,0,null,0,null,0,0]
[null,"2023-01-01",null,null,0,null,0,null,0,0]
[null,"2023-02-01",null,null,0,null,0,null,0,0]
[null,"2023-03-01",null,null,0,null,0,null,0,0]
[null,"2023-04-01",null,null,0,null,0,null,0,0]
[null,"2023-05-01",null,null,0,null,0,null,0,0]
[null,"2023-06-01",null,null,0,null,0,null,0,0]
[null,"Totals",{"$f":"SUM(C5:C28)","v":0},{"$f":"SUM(D5:D28)","v":0},{"$f":"SUM(E5:E28)","v":0},0,0,0,0,0]

{"sheet":"Bridges Current Grantees","index":8,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,1,2],[3,1,3,2]]}
[null,"Bridges CURRENT GRANTEES (not applicable for new applicants)"]
[]
[]
[null,"Grant and Participant Information From Current Grant Period"]
[null,"Enter the number of months have you completed in your current grant term"]
[null,"Number of households that transitioned to another permanent subsidy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no"]
[null,"Number of households  that were terminated due to eviction or notice to vacate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"unsure"]
[null,"Number of households that were initially enrolled but unable to find housing"]
[]
[null," List the percentage of each priority population that you are currently serving"]
[null,"Percentage of Households that Left Institutions or Segregated Settings"]
[null,"Percentage of Households that were at Imminent Risk of Homelessness"]
[null,"Percentage of Households that were Experiencing Homelessness"]
[]
[null,"Estimated percentage of the grant that will be utilized at the end of the contract period"]
[null,"Total amount  spent on housing subsidies through AMHI (BRASS Code 443x) for the current contract term         "]
[null," Number of households that the AMHI amount served"]

{"sheet":"Bridges RTC Current Grantees","index":9,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,1,2],[3,1,3,2]]}
[null,"Bridges RTC CURRENT GRANTEES (not applicable for new applicants)"]
[]
[]
[null,"Grant and Participant Information From Current Grant Period"]
[null,"Enter the number of months have you completed in your current grant term"]
[null,"Number of households that transitioned to another permanent subsidy"]
[null,"Number of households  that were terminated due to eviction or notice to vacate"]
[null,"Number of households that were initially enrolled but unable to find housing"]
[]
[null," List the percentage of each priority population that you are currently serving"]
[null,"Percentage of Households that Left Institutions or Segregated Settings"]
[null,"Percentage of Households that were at Imminent Risk of Homelessness"]
[null,"Percentage of Households that were Experiencing Homelessness"]
[]
[null,"Estimated percentage of the grant that will be utilized at the end of the contract period"]
[null,"Total amount  spent on housing subsidies through AMHI (BRASS Code 443x) for the current contract term         "]
[null," Number of households that the AMHI amount served"]