{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Budget","Detailed Budget","SubGrantee Budget","Cost Per Client"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[12,0,12,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[8,0,8,1],[25,0,25,1],[30,0,30,1],[31,1,34,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,1,19,1],[20,0,20,1],[14,0,14,1]]}
["Program Budget Instructions"]
["·         Please enter into cells that are highlighted orange. >>>",null,"Example"]
["·         All line item amounts must be entered as WHOLE DOLLARS."]
["·         If no funds are budgeted for a line item, leave it blank.  "]
["·         Column B: Please complete Column B for a 12-month period."]
["·         Column C: The amount listed must reflect the expected amounts from other funding sources, other than COA, for the annual 12-month contract period."]
["·         Calculate and check all subtotals and totals, including the percentages by funding source at the bottom, and ensure all line item amounts, subtotals, and totals are in WHOLE DOLLARS and are correct."]
["·         Cost per Client Calculation: Add the number of total clients projected to be served in a 12-month period in cell B5"]
["·         Cost per Client Housed (If applicable): Add the number of total number of clients projected to be housed in a 12-month period in cell B6"]
["Budget Narrative Instructions"]
["·         For every budget line containing a requested amount of City of Austin funding, enter a short description or list of items included in that budget line.  "]
["·         Do not enter narrative for budget lines that are blank or budgeted amounts from Other Funding."]
["Detailed Budget Instructions"]
["·        For each program component, enter the proposed amount of City funding to be used for each activity in whole dollars. "]
["·        The Running Budget Balance section will show the remaining funding available per budget line-item as listed on the Budget form. The Running Budget Balance section must read $0 at the end of each section - if it does not, then there are additional funds requested on the Budget worksheet that have not been accounted for. "]
["·        Please complete a brief explanation of what services will be provided with each City-funded line-item."]
["Budget Line Items Instructions"]
["A. Personnel"]
["Salaries","These line items included in Personnel includes Salaries plus Fringe and Payroll Taxes."]
["Fringe and Payroll Taxes"]
["B. Operations"]
["General Operating Expenses","Include all operating expenses which are NOT included in any other line item).  Examples are any travel/training/conferences WITHIN Travis County, insurance/bonding, equipment costing less than $5,000 per item, general office supplies, rent, utilities, telecommunications, postage, program supplies, software licenses such as HMIS. Food that benefit a group of clients such as food for meetings, foodbank and commercial kitchen meals (shelter or community meals) should be included here."]
["Outsourced Professional Services","Include any sub-agreements/sub-contracts made with an individual or company which provides a service such as with a consulting, accounting or auditing, or translation services. Sub-agreements/sub-contracts with individuals or agencies to provide client services that do not contribute to the unduplicated client count in your proposed performance measures should be included here"]
["Supplemental Programmatic Services","Include any sub-agreements/sub-contracts made with an individual or company that is providing program or direct client services, but do not have unique clients that contribute to the program in the RFGA proposed performance measures. These services will be supplemental services provided to your program clients. "]
["Training/Travel Outside Austin and/or Travis Count","Include any necessary training that will take place outside Austin and/or Travis County."]
["C. Assistance to Clients"]
["Rental/Mortgage Assistance","Rental payments and arrears, mortgage payments or assistance. "]
["General Housing Assistance","Assistance related to obtaining housing OTHER THAN Rent/Mortgage such as utility payments and arrears, housing application deposits. "]
["Direct Client Assistance","Assistance to clients not related to obtaining housing that benefit an individual in the program such as clothing, bus passes, child care, transportation assistance, incentives."]
["Client Food and Beverage","Food and Beverages for clients such as groceries, and food assistance that benefits an individual in the program.  Food that benefit a group of clients such as food for meetings, foodbank and commercial kitchen meals (shelter or community meals) should be included in General Operations."]
["D. Subgrantees/Sub-recipients"]
["Personnel-Sub","In the case that the organization will be sub-contracting, the Lead Agency would assume full responsibility for paying sub-grantees/sub-recipients with City funds.  These categories are for costs associated with sub-grantees/sub-recipients with individuals or agencies to provide client services that contribute to the unduplicated client count in the RFGA proposed performance measures. These clients would be unique clients brought in from the sub-grantee, separate from the clients of the Lead Agency, but the clients would contribute to the overall number of clients served.  "]
["Operations-Sub"]
["Direct Client Assistance-Sub"]
["Other-Sub"]

{"sheet":"Budget","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[25,4,25,6],[27,4,27,6],[29,4,29,6],[28,4,28,6],[26,4,26,6],[7,0,7,3],[23,4,23,6],[24,4,24,6],[15,4,15,6],[16,4,16,6],[18,4,18,6],[19,4,19,6],[9,4,9,6],[11,4,11,6],[13,4,13,6],[20,4,20,6],[22,4,22,6],[14,4,14,6]]}
["Form 3 - Progarm Budget and Narrative"]
["Agency Name:","Sample Agency"]
["Program Name:","Sample Program"]
["Program Type:","Please Select"]
[{"$f":"IF(B4=\"Landlord Outreach\",\"Proposed Units Secured\",\"Total Proposed Clients Served:\")","v":"Total Proposed Clients Served:"},0]
[{"$f":"IF(B4=\"Landlord Outreach\",\"Not Used for Outreach\",\"Total Proposed Clients Housed:\")","v":"Total Proposed Clients Housed:"},0]
[]
["Instruction: Applicants must identify all funding requested in the budget below. The completed Detailed Budget will be reviewed by evaluators.  Funds requested should correspond to the activities and services proposed in the application narrative. If awarded, funds may be transferred between line items."]
[]
["Budget Line-Item","Requested COA Funding 12-Months","Amounts Funded by ALL OTHER Sources 12-Months","Total Budget (All Funding Sources) 12-Months","Complete an explanation for each City-funded line item."]
["Salaries"]
["Personnel",null,null,{"$f":"SUM(B12:C12)","v":0}]
["Operations"]
["General Operations",null,null,{"$f":"SUM(B14:C14)","v":0}]
["Outsourced Professional Services",null,null,{"$f":"SUM(B15:C15)","v":0}]
["Supplemental Programmatic Services",null,null,0]
["Training/Travel Outside of Austin/Travis County",null,null,0]
["Assistance to Clients"]
["Rental Assistance",null,null,{"$f":"SUM(B19:C19)","v":0}]
["General Housing Assistance",null,null,{"$f":"SUM(B20:C20)","v":0}]
["Direct Client Assistance",null,null,0]
["Sub-Grantees (If Applicable)"]
["Sub-Grantee Personnel",null,null,{"$f":"SUM(B23:C23)","v":0}]
["Sub-Grantee Operations",null,null,{"$f":"SUM(B24:C24)","v":0}]
["Sub-Grantee Direct Assistance",null,null,0]
["Sub-Grantee Other",null,null,0]
["Program Income"]
["Program Income",null,null,0]
["Other"]
["Other",null,null,{"$f":"SUM(B30:C30)","v":0}]
["Total:",{"$f":"SUM(B11:B30)","v":0},{"$f":"SUM(C11:C30)","v":0},{"$f":"SUM(D11:D30)","v":0}]

{"sheet":"Detailed Budget","index":2,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[7,0,7,3]]}
[{"$f":"Budget!A1","v":"Form 3 - Progarm Budget and Narrative"}]
[{"$f":"Budget!A2","v":"Agency Name:"},{"$f":"Budget!B2","v":"Sample Agency"}]
[{"$f":"Budget!A3","v":"Program Name:"},{"$f":"Budget!B3","v":"Sample Program"}]
["Program Type:",{"$f":"Budget!B4","v":"Please Select"}]
[{"$f":"Budget!A5","v":"Total Proposed Clients Served:"},{"$f":"Budget!B5","v":0}]
["Total Proposed Clients Housed:",{"$f":"Budget!B6","v":0}]
[]
["For each program component, enter the proposed amount of City funding to be used for each activity in whole dollars. The Running Budget Balance section will show the remaining funding available per budget line-item as listed on the Budget form. The Running Budget Balance section must read $0 at the end of each section - if it does not, then there are additional funds requested on the Budget worksheet that have not been accounted for. Please complete a brief explanation of what services will be provided with each City-funded line-item."]
[]
["Program Components","Proposed Budget By Activity","Amount From Budget","Note","Budget Narrative"]
["Personnel",null,{"$f":"SUM(Budget!B12)","v":0}]
[null,null,"Running Budget Balance",null,"Complete an explanation for each City-funded line item."]
["Outreach/Engagement/Move-In",null,{"$f":"SUM(C11-B13)","v":0}]
["Housing Stability Case Management",null,{"$f":"SUM(C13-B14)","v":0}]
["Employment Assistance",null,{"$f":"SUM(C14-B15)","v":0}]
["Peer Support",null,0]
["SSI/SSDI Outreach, Access, Recovery (SOAR)",null,0]
["Mental Health Services",null,0]
["Coordination of Medical Care",null,0]
["Substance Abuse Services",null,0,"<-This must equal $0 once all components are entered"]
["General Operations",null,{"$f":"SUM(Budget!B14:B17)","v":0}]
["Operational Costs",null,{"$f":"SUM(C21-B22)","v":0},"<-This must equal $0 once all components are entered"]
["Financial Assistance",null,{"$f":"SUM(Budget!B19:B21)","v":0}]
["Rental Assistance",null,{"$f":"SUM(C23-B24)","v":0}]
["Security Deposits",null,{"$f":"SUM(C24-B25)","v":0}]
["Application Fees",null,{"$f":"SUM(C25-B26)","v":0}]
["Direct Client Assistance",null,0]
["Utility Assistance",null,{"$f":"SUM(C27-B28)","v":0}]
["Move-in Assistance",null,0,"<-This must equal $0 once all components are entered"]
["SubGrantees",null,{"$f":"SUM(Budget!B23:B26)","v":0}]
["SubGrantee Personnel",null,{"$f":"SUM(C30-B31)","v":0}]
["SubGrantee Operations",null,{"$f":"SUM(C31-B32)","v":0}]
["SubGrantee Direct Assistance",null,0]
["SubGrantee Other",null,0,"<-This must equal $0 once all components are entered"]
["Program Income",null,{"$f":"Budget!B28","v":0}]
["Program Income",null,{"$f":"SUM(C35-B36)","v":0},"<-This must equal $0 once all components are entered"]
["Other",null,{"$f":"Budget!B30","v":0}]
["Other Costs",null,0,"<-This must equal $0 once all components are entered"]
["Total:",{"$f":"SUM(B11:B38)","v":0},{"$f":"SUM(C20,C22,C29,C34,C36,C38)","v":0},"<-This must equal $0 once all components are entered"]

{"sheet":"SubGrantee Budget","index":3,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,0,11,0],[8,1,11,1],[8,2,11,2],[8,3,11,3],[8,4,11,4],[16,0,19,0],[16,1,19,1],[16,2,19,2],[16,3,19,3],[16,4,19,4],[12,0,15,0],[12,1,15,1],[12,2,15,2],[12,3,15,3],[12,4,15,4],[20,0,23,0],[20,1,23,1],[20,2,23,2],[20,3,23,3],[20,4,23,4],[28,0,31,0],[28,1,31,1],[28,2,31,2],[28,3,31,3],[28,4,31,4],[24,0,27,0],[24,1,27,1],[24,2,27,2],[24,3,27,3],[24,4,27,4],[32,0,35,0],[32,1,35,1],[32,2,35,2],[32,3,35,3],[32,4,35,4],[36,0,39,0],[36,1,39,1],[36,2,39,2],[36,3,39,3],[36,4,39,4],[40,0,43,0],[40,1,43,1],[40,2,43,2],[40,3,43,3],[40,4,43,4]]}
[{"$f":"Budget!A1","v":"Form 3 - Progarm Budget and Narrative"}]
[{"$f":"Budget!A2","v":"Agency Name:"},{"$f":"Budget!B2","v":"Sample Agency"}]
[{"$f":"Budget!A3","v":"Program Name:"},{"$f":"Budget!B3","v":"Sample Program"}]
["Program Type:",{"$f":"Budget!B4","v":"Please Select"}]
[{"$f":"Budget!A5","v":"Total Proposed Clients Served:"},{"$f":"Budget!B5","v":0}]
["Total Proposed Clients Housed:",{"$f":"Budget!B6","v":0}]
[]
["SubGrantee Name:","Start Date:","End Date:","Services Agreed to Perform","Unduplicated Clients Served","Line-Items","COA Amount","Other Funded Amount:","Total Amount:"]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G9:H9)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G10:H10)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G12:H12)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G13:H13)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G14:H14)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G16:H16)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G17:H17)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G18:H18)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G20:H20)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G21:H21)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G22:H22)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G24:H24)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G25:H25)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G26:H26)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G28:H28)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G29:H29)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G30:H30)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G32:H32)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G33:H33)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G34:H34)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G36:H36)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G37:H37)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G38:H38)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G40:H40)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G41:H41)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G42:H42)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G44:H44)","v":0}]
[null,null,null,null,null,"Total:",{"$f":"SUM(G9:G44)","v":0},{"$f":"SUM(H9:H44)","v":0},0]
[null,null,null,null,null,"Total From Budget:",{"$f":"SUM(Budget!B23:B26)","v":0},{"$f":"SUM(Budget!C23:C26)","v":0},{"$f":"SUM(G46:H46)","v":0}]

{"sheet":"Cost Per Client","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Budget!A1","v":"Form 3 - Progarm Budget and Narrative"}]
[{"$f":"Budget!A2","v":"Agency Name:"},{"$f":"Budget!B2","v":"Sample Agency"}]
[{"$f":"Budget!A3","v":"Program Name:"},{"$f":"Budget!B3","v":"Sample Program"}]
["Program Type:",{"$f":"Budget!B4","v":"Please Select"}]
[{"$f":"Budget!A5","v":"Total Proposed Clients Served:"},{"$f":"Budget!B5","v":0}]
[{"$f":"Budget!A6","v":"Total Proposed Clients Housed:"},{"$f":"Budget!B6","v":0}]
[]
["Program Type:",{"$f":"Budget!B4","v":"Please Select"}]
["Overall Budget:",{"$f":"Budget!D31","v":0}]
[{"$f":"IF(B8=\"Landlord Outreach\",\"Cost Per Unit Secured\",\"Cost Per Client Served:\")","v":"Cost Per Client Served:"},{"$f":"IF(B9=0,\"\",SUM(B9/B5))","v":""}]
["Cost Per Client Housed:",{"$f":"IF(B8=\"Landlord Outreach\",\"N/A\",IF(B9=0,\"\",SUM(B9/B6)))","v":""}]
["Financial Assistance Per Housed:",{"$f":"IF(B8=\"Landlord Outreach\",\"N/A\",IF(B9=0,\"\",SUM(Budget!D19:D21,Budget!D25,Budget!D26)/B6))","v":""}]