{"text_format":"5","workbook":"xlsx","n_sheets":7,"sheets":["Budget & Output Summary","Street Outreach","Emergency Shelter","Homelessness Prevention","Rapid Rehousing","HMIS","Anticipated Match"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Budget & Output Summary","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[1,0,1,10],[2,0,2,10],[3,0,3,3],[3,4,3,10],[4,0,4,3],[4,4,4,10],[5,0,5,10],[6,0,6,10],[7,0,9,10],[25,2,25,3],[26,0,26,10],[27,0,29,10],[30,6,30,7]],"headers":{"header":["","North Carolina Emergency Solutions Grant FY17 Application for Program Year 2018 Project Application: Budget and Output Summary"],"footer":["FY17 NC ESG Application Project Budget"]}}
[]
["General Information"]
[]
["Applicant Organization"]
["Fiscal Sponsor Name (optional)"]
[]
["Budget  and Output Summary"]
["The budget summary below will autopopulate based upon the totals from the other budget components. You do not have to fill this section out, but please make sure that the information below is correct."]
[]
[]
[]
[null,"Component",{"$nulls":3},"Amount",null,"%",null,"Total Served"]
[]
[null,"Street Outreach",{"$nulls":3},{"$f":"'Street Outreach'!H30","v":0},null,{"$f":"F14/F24","v":{"$error":"#DIV/0!"}},null,{"$f":"'Street Outreach'!O10","v":0}]
[]
[null,"Emergency Shelter",{"$nulls":3},{"$f":"'Emergency Shelter'!H36","v":0},null,{"$f":"F16/F24","v":{"$error":"#DIV/0!"}},null,{"$f":"'Emergency Shelter'!O12","v":0}]
[]
[null,"Homelessness Prevention",{"$nulls":3},{"$f":"'Homelessness Prevention'!H46","v":0},null,{"$f":"F18/F24","v":{"$error":"#DIV/0!"}},null,{"$f":"'Homelessness Prevention'!P15","v":0}]
[]
[null,"Rapid Rehousing",{"$nulls":3},{"$f":"'Rapid Rehousing'!H46","v":0},null,{"$f":"F20/F24","v":{"$error":"#DIV/0!"}},null,{"$f":"'Rapid Rehousing'!P15","v":0}]
[]
[null,"HMIS",{"$nulls":3},{"$f":"HMIS!J21","v":0},null,{"$f":"F22/F24","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":4},"Total",{"$f":"(SUM(F14+F16+F18+F20+F22))","v":0}]
[]
[]
["Anticipated Matching Funds"]
["The ESG program requires 100% match. The anticipated match must match the total request. If the box below is red, adjustments will need to be made to conform to ESG program requirements."]
[]
[]
[{"$nulls":4},"Total Anticipated Match",{"$f":"'Anticipated Match'!F22","v":0}]

{"sheet":"Street Outreach","index":1,"n_rows":30,"n_cols":15,"rows_kept":30,"merged":[[8,0,8,6],[8,7,8,8],[8,9,8,13],[9,1,9,6],[9,14,11,14],[10,1,10,6],[10,9,11,13],[11,1,11,6],[12,1,12,6],[12,14,15,14],[13,1,13,6],[13,9,15,13],[14,1,14,6],[15,1,15,6],[16,1,16,6],[16,14,18,14],[17,1,17,6],[17,9,18,13],[18,1,18,6],[19,1,19,6],[19,14,23,14],[20,1,20,6],[20,9,23,13],[21,1,21,6],[22,1,22,6],[23,1,23,6],[24,1,24,6],[24,14,28,14],[25,1,25,6],[25,9,28,13],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,0,29,6],[29,9,29,14]],"headers":{"header":["","Street Outreach Detailed Budget and Outputs"],"footer":["FY17 NC ESG Application Project Budget"]}}
["Indicate which services the project sponsor proposes to provide by checking the box(es) below. Check all that apply."]
[]
[null,null,"Engagement",{"$nulls":3},"Case Management",null,null,"     Emergency Health Services"]
[]
[null,null,"Emergency Mental Health Services",{"$nulls":3},"Transportation"]
[]
["Note: The outputs listed in questions 2-5 must be less than or equal to the output in question 1."]
[]
["Budget Line Item and Method of Calculation",{"$nulls":6},"Amount",null,"Output Measures",{"$nulls":4},"2018 Targets"]
[1,{"$nulls":8},"1. Street Outreach"]
[2,{"$nulls":8},"Unduplicated number of persons to be served with ESG Street Outreach funds"]
[3]
[4,{"$nulls":8},"2. Engagement"]
[5,{"$nulls":8},"Unduplicated number of persons living on the streets who will be engaged through repeated contacts and delivery of basic services"]
[6]
[7]
[8,{"$nulls":8},"3. Case Management"]
[9,{"$nulls":8},"Unduplicated number of persons to receive case management"]
[10]
[11,{"$nulls":8},"4. Housing Destination"]
[12,{"$nulls":8},"Unduplicated number of persons who will be placed in temporary or transitional housing destinations or permanent housing destinations as a results of ESG Street Outreach assistance"]
[13]
[14]
[15]
[16,{"$nulls":8},"5. Non-Cash Benefits"]
[17,{"$nulls":8},"Unduplicated number of persons who will have more non-cash benefits at program exit than at program entry, as a result of ESG Street Outreach Assistance"]
[18]
[19]
[20]
["Total Street Outreach Funds Requested",{"$nulls":6},{"$f":"SUM(H10:I29)","v":0}]

{"sheet":"Emergency Shelter","index":2,"n_rows":36,"n_cols":15,"rows_kept":36,"merged":[[0,0,0,12],[10,0,10,8],[10,9,10,13],[11,0,11,6],[11,14,13,14],[12,1,12,6],[12,9,13,13],[13,1,13,6],[14,1,14,6],[14,14,16,14],[15,1,15,6],[15,9,16,13],[16,1,16,6],[17,1,17,6],[17,14,19,14],[18,1,18,6],[18,9,19,13],[19,1,19,6],[20,1,20,6],[20,14,22,14],[21,1,21,6],[21,9,22,13],[22,0,22,6],[23,0,23,6],[23,14,26,14],[24,1,24,6],[24,9,26,13],[25,1,25,6],[26,1,26,6],[27,1,27,6],[27,14,30,14],[28,1,28,6],[28,9,30,13],[29,1,29,6],[30,1,30,6],[31,1,31,6],[31,9,35,14],[32,1,32,6],[33,1,33,6],[34,0,34,6],[35,0,35,6]],"headers":{"header":["","Emergency Shelter Detailed Budget and Outputs"],"footer":["FY17 NC ESG Application Project Budget"]}}
["Indicate which services the project sponsor proposes to provide by checking the box(es) below. Check all that apply."]
[]
["Essential Services"]
["Case Management",{"$nulls":4},"Education Services",null,"           Employment Assistance & Job Training",{"$nulls":3},"         Outpatient Health Services"]
["Mental Health Services\n",{"$nulls":4},"Child Care",null,"           Substance Abuse Treatment Services\n",{"$nulls":3},"         Transportation"]
[]
["Shelter Operations"]
[]
["Note: The outputs listed in questions 2-6 must be less than or equal to the output in question 1."]
[]
["Budget Line Item and Method of Calculation",{"$nulls":8},"Output  Measures",{"$nulls":4},"2018 Targets"]
["Essential Services",{"$nulls":6},"Amount",null,"1. Emergency Shelter"]
[1,{"$nulls":8},"Unduplicated number of persons to be served with ESG Emergency Shelter funds "]
[2]
[3,{"$nulls":8},"2. Shelters"]
[4,{"$nulls":8},"Unduplicated number of persons to be housed in emergency shelters or to be served in day shelters "]
[5]
[6,{"$nulls":8},"3. Essential Services"]
[7,{"$nulls":8},"Unduplicated number of persons to be served with essential services "]
[8]
[9,{"$nulls":8},"4. Case Management"]
[10,{"$nulls":8},"Unduplicated number of persons who will receive case management "]
["Subtotal",{"$nulls":6},{"$f":"SUM(H13:I22)","v":0}]
["Shelter Operations",{"$nulls":6},"Amount",null,"5. Temporary Housing Destination"]
[1,{"$nulls":8},"Unduplicated number of persons who will exit to temporary housing destinations as a result of receiving ESG Emergency Shelters services "]
[2]
[3]
[4,{"$nulls":8},"6. Permanent Housing Destination"]
[5,{"$nulls":8},"Unduplicated number of persons who will exit to Permanent Housing destinations as a result of receiving ESG Emergency Shelters services "]
[6]
[7]
[8]
[9]
[10]
["Subtotal",{"$nulls":6},{"$f":"SUM(H25:I34)","v":0}]
["Total Emergency Shelter Funds Requested",{"$nulls":6},{"$f":"H23+H35","v":0}]

{"sheet":"Homelessness Prevention","index":3,"n_rows":46,"n_cols":16,"rows_kept":46,"merged":[[0,0,0,12],[13,0,13,8],[13,9,13,14],[14,0,14,6],[14,7,14,8],[14,9,16,14],[14,15,16,15],[15,1,15,6],[15,7,15,8],[16,1,16,6],[16,7,16,8],[17,1,17,6],[17,7,17,8],[17,9,19,14],[17,15,19,15],[18,1,18,6],[18,7,18,8],[19,1,19,6],[19,7,19,8],[20,1,20,6],[20,7,20,8],[20,9,23,14],[20,15,23,15],[21,1,21,6],[21,7,21,8],[22,1,22,6],[22,7,22,8],[23,1,23,6],[23,7,23,8],[24,1,24,6],[24,7,24,8],[24,9,27,14],[24,15,27,15],[25,0,25,6],[25,7,25,8],[26,0,26,6],[26,7,26,8],[27,1,27,6],[27,7,27,8],[28,1,28,6],[28,7,28,8],[28,9,32,14],[28,15,32,15],[29,1,29,6],[29,7,29,8],[30,1,30,6],[30,7,30,8],[31,1,31,6],[31,7,31,8],[32,1,32,6],[32,7,32,8],[33,1,33,6],[33,7,33,8],[33,9,36,14],[33,15,36,15],[34,1,34,6],[34,7,34,8],[35,1,35,6],[35,7,35,8],[36,1,36,6],[36,7,36,8],[37,0,37,6],[37,7,37,8],[37,9,40,14],[37,15,40,15],[38,0,38,6],[38,7,38,8],[39,1,39,6],[39,7,39,8],[40,1,40,6],[40,7,40,8],[41,1,41,6],[41,7,41,8],[41,9,44,14],[41,15,44,15],[42,1,42,6],[42,7,42,8],[43,1,43,6],[43,7,43,8],[44,0,44,6],[44,7,44,8],[45,0,45,6],[45,7,45,8],[45,9,45,15]],"headers":{"header":["","Homelessness Prevention Detailed Budget and Outputs"],"footer":["FY17 NC ESG Application Project Budget"]}}
["Indicate which services the project sponsor proposes to provide by checking the box(es) below. Check all that apply."]
[]
["Financial Assistance Costs"]
["Rental application fees",null,null,"Security deposits",null,"Last month's rent",null,null,"Utility deposits",null,"      Utility payments",null,"             Arrears",null,"     Moving Costs"]
[]
["Housing Services Costs"]
["Housing search & placement",{"$nulls":3},"Housing stability case management",{"$nulls":3},"         Mediation",null,"          Legal services",null,null,"     Credit repair"]
[]
["Rental Assistance"]
["Short-term rental assistance",{"$nulls":3},"Medium-term rental assistance"]
[]
["Note: The outputs listed in questions 2-8 must be less than or equal to the output in question 1."]
[]
["Budget Line Item and Method of Calculation",{"$nulls":8},"Output  Measures",{"$nulls":5},"2018 Targets"]
["Financial Assistance Costs",{"$nulls":6},"Amount",null,"1.  Homelessness Prevention (HP): Unduplicated persons to be served with ESG HP funds"]
[1]
[2]
[3,{"$nulls":8},"2. Financial Assistance: Unduplicated persons to receive financial assistance"]
[4]
[5]
[6,{"$nulls":8},"3. Housing Search & Placement: Unduplicated persons to receive housing search & placement services"]
[7]
[8]
[9]
[10,{"$nulls":8},"4. Housing Stability Case Management: Unduplicated persons to receive housing stability case management"]
["Subtotal",{"$nulls":6},{"$f":"SUM(H16:I25)","v":0}]
["Housing Services Costs",{"$nulls":6},"Amount"]
[1]
[2,{"$nulls":8},"5. Permanent Housing Destination: Unduplicated number of persons who at program exit will have a Permanent Housing Destination as a result of receiving ESG HP assistance"]
[3]
[4]
[5]
[6]
[7,{"$nulls":8},"6. Maintaining Housing: Unduplicated number of persons who after program exit will have maintained their housing for 3 months or more "]
[8]
[9]
[10]
["Subtotal",{"$nulls":6},{"$f":"SUM(H28:I37)","v":0},null,"7. Higher Income: Unduplicated number of persons who will have higher income at program exit than at program entry as a result of receiving ESG HP assistance"]
["Rental Assistance",{"$nulls":6},"Amount"]
[1]
[2]
[3,{"$nulls":8},"8. Non-Cash Benefits: Unduplicated number of persons who will have more non-cash benefits at program exit than at program entry as a result of receiving ESG HP assistance\n"]
[4]
[5]
["Subtotal",{"$nulls":6},{"$f":"SUM(H40:I44)","v":0}]
["Total Homelessness Prevention Funds Requested",{"$nulls":6},{"$f":"H45+H38+H26","v":0}]

{"sheet":"Rapid Rehousing","index":4,"n_rows":46,"n_cols":16,"rows_kept":46,"merged":[[0,0,0,12],[13,0,13,8],[13,9,13,14],[14,0,14,6],[14,7,14,8],[14,9,16,14],[14,15,16,15],[15,1,15,6],[15,7,15,8],[16,1,16,6],[16,7,16,8],[17,1,17,6],[17,7,17,8],[17,9,19,14],[17,15,19,15],[18,1,18,6],[18,7,18,8],[19,1,19,6],[19,7,19,8],[20,1,20,6],[20,7,20,8],[20,9,23,14],[20,15,23,15],[21,1,21,6],[21,7,21,8],[22,1,22,6],[22,7,22,8],[23,1,23,6],[23,7,23,8],[24,1,24,6],[24,7,24,8],[24,9,27,14],[24,15,27,15],[25,0,25,6],[25,7,25,8],[26,0,26,6],[26,7,26,8],[27,1,27,6],[27,7,27,8],[28,1,28,6],[28,7,28,8],[28,9,32,14],[28,15,32,15],[29,1,29,6],[29,7,29,8],[30,1,30,6],[30,7,30,8],[31,1,31,6],[31,7,31,8],[32,1,32,6],[32,7,32,8],[33,1,33,6],[33,7,33,8],[33,9,36,14],[33,15,36,15],[34,1,34,6],[34,7,34,8],[35,1,35,6],[35,7,35,8],[36,1,36,6],[36,7,36,8],[37,0,37,6],[37,7,37,8],[37,9,40,14],[37,15,40,15],[38,0,38,6],[38,7,38,8],[39,1,39,6],[39,7,39,8],[40,1,40,6],[40,7,40,8],[41,1,41,6],[41,7,41,8],[41,9,44,14],[41,15,44,15],[42,1,42,6],[42,7,42,8],[43,1,43,6],[43,7,43,8],[44,0,44,6],[44,7,44,8],[45,0,45,6],[45,7,45,8],[45,9,45,15]],"headers":{"header":["","Rapid Rehousing Detailed Budget and Outputs"],"footer":["FY17 NC ESG Application Project Budget"]}}
["Indicate which services the project sponsor proposes to provide by checking the box(es) below. Check all that apply."]
[]
["Financial Assistance Costs"]
["Rental application fees",null,null,"Security deposits",null,"Last month's rent",null,null,"Utility deposits",null,"      Utility payments",null,"             Arrears",null,"     Moving Costs"]
[]
["Housing Services Costs"]
["Housing search & placement",{"$nulls":3},"Housing stability case management",{"$nulls":3},"         Mediation",null,"          Legal services",null,null,"     Credit repair"]
[]
["Rental Assistance"]
["Short-term rental assistance",{"$nulls":3},"Medium-term rental assistance"]
[]
["Note: The outputs listed in questions 2-8 must be less than or equal to the output in question 1."]
[]
["Budget Line Item and Method of Calculation",{"$nulls":8},"Output  Measures",{"$nulls":5},"2018 Targets"]
["Financial Assistance Costs",{"$nulls":6},"Amount",null,"1.  Rapid Rehousing: Unduplicated persons to be served with ESG RRH funds"]
[1]
[2]
[3,{"$nulls":8},"2. Financial Assistance: Unduplicated persons to receive financial assistance"]
[4]
[5]
[6,{"$nulls":8},"3. Housing Search & Placement: Unduplicated persons to receive housing search & placement services"]
[7]
[8]
[9]
[10,{"$nulls":8},"4. Housing Stability Case Management: Unduplicated persons to receive housing stability case management"]
["Subtotal",{"$nulls":6},{"$f":"SUM(H16:I25)","v":0}]
["Housing Services Costs",{"$nulls":6},"Amount"]
[1]
[2,{"$nulls":8},"5. Permanent Housing Destination: Unduplicated number of persons who at program exit will have a Permanent Housing Destination as a result of receiving ESG RRH assistance"]
[3]
[4]
[5]
[6]
[7,{"$nulls":8},"6. Maintaining Housing: Unduplicated number of persons who after program exit will have maintained their housing for 3 months or more "]
[8]
[9]
[10]
["Subtotal",{"$nulls":6},{"$f":"SUM(H28:I37)","v":0},null,"7. Higher Income: Unduplicated number of persons who will have higher income at program exit than at program entry as a result of receiving ESG RRH assistance"]
["Rental Assistance",{"$nulls":6},"Amount"]
[1]
[2]
[3,{"$nulls":8},"8. Non-Cash Benefits: Unduplicated number of persons who will have more non-cash benefits at program exit than at program entry as a result of receiving ESG RRH assistance\n"]
[4]
[5]
["Subtotal",{"$nulls":6},{"$f":"SUM(H40:I44)","v":0}]
["Total Rapid Rehousing Funds Requested",{"$nulls":6},{"$f":"H45+H38+H26","v":0}]

{"sheet":"HMIS","index":5,"n_rows":21,"n_cols":10,"rows_kept":21,"merged":[[9,2,9,8],[9,9,9,10],[10,3,10,8],[10,9,10,10],[11,3,11,8],[11,9,11,10],[12,3,12,8],[12,9,12,10],[13,3,13,8],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,3,16,8],[16,9,16,10],[17,3,17,8],[17,9,17,10],[18,3,18,8],[18,9,18,10],[19,3,19,8],[19,9,19,10],[20,2,20,8],[20,9,20,10]],"headers":{"header":["","HMIS Detailed Budget"],"footer":["FY17 NC ESG Application Project Budget"]}}
[]
["Indicate which expenses the project sponsor proposes to charge to ESG by checking the box(es) below. Check all that apply:"]
[]
[null,null,"Hardware, equipment or software costs",{"$nulls":3},"Salaries for operating HMIS for ESG"]
[]
[null,null,"Training & overhead costs",{"$nulls":3},"HMIS license fees"]
[]
[]
[]
[null,null,"Budget Line Item and Method of Calculation",{"$nulls":6},"Amount"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,"Total HMIS Funds Requested",{"$nulls":6},{"$f":"SUM(J11:K20)","v":0}]

{"sheet":"Anticipated Match","index":6,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,0,8,5],[21,0,21,4]],"headers":{"header":["","Anticipated Match Detailed Budget"],"footer":["FY17 NC ESG Application Project Budget"]}}
["For each match resource proposed, complete the following match table with the dollar value of the match, the type of funding source, the source of match funds (including name of grant/grantor and a brief description), the eligible activity component and the method of calculation. \n\nMatch figures should be based on eligible match sources, and should, at a minimum, equal the total budget amount.\nMatch documentation must be submitted with project application. See appendix 5 for match documentation requirements.  "]
{"$rows_empty":9}
["Match Type","Eligible Activity","Source Type","Source + Description","Method of Calculation","Amount"]
{"$rows_empty":10}
["Total Anticipated Match",{"$nulls":4},{"$f":"SUM(F12:F21)","v":0}]