{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Budget","SubGrantee Budget","Source of All Funds","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":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[17,0,17,1],[7,0,7,1],[8,0,8,1],[16,0,16,1],[11,0,11,1],[9,0,9,1],[12,0,12,1],[15,0,15,1],[13,0,13,1],[10,0,10,1],[14,0,14,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[6,0,6,1],[4,0,4,1],[5,0,5,1],[39,0,39,1],[27,0,27,1],[34,0,34,1],[35,1,38,1],[18,0,18,1],[19,0,19,1],[20,1,21,1],[22,0,22,1],[32,0,32,1]]}
["Program Budget Narrative and Funding Summary Form 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.  "]
["Budget Instructions"]
["·         Header: Please complete Agency Name, Program Name, select a Program Type from the dropdown menu, and enter the anticipated number of clients served in cell B5"]
["·         Column B: Please complete Column B for the period October 1, 2022 – September 30, 2023."]
["·         Column C: The amount listed must reflect the expected amounts from other funding sources, other than COA, for the annual 12-month contract period of October 1, 2022 – September 30, 2023"]
["·         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."]
["·         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 in Column E-G"]
["·         Do not enter narrative for budget lines that are blank or budgeted amounts from Other Funding."]
["SubGrantee Budget Instructions"]
["·         Complete as needed for all SubGrantees involved with this Proposal"]
["Source of All Funds Instructions"]
["·         Include the funding source, grant/contract name (if applicable), and ANNUAL amount of all funding including the requested City of Austin funding in the table."]
["Cost Per Client"]
["·         Cost per Client Calculation: This tab will autocomplete when all necessary items are complete in other tabs. Use this calculation in your Final Proposal"]
[]
["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 (not eligible for this solicitation)","Rental payments and arrears, mortgage payments or assistance. (not eligible for this solicitation)"]
["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."]
["Capital Expenses"]
["Capital Outlay","Applicants may request funds for equipment exceeding $5,000 with the approval of APH staff and following the required procurement requirements of the funding"]
["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"]
["E. Other"]
["Other","Other costs not listed above that are necessary for the operation of the program"]

{"sheet":"Budget","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,4,30,6],[29,4,29,6],[6,0,6,3],[26,4,26,6],[27,4,27,6],[15,4,15,6],[16,4,16,6],[18,4,18,6],[19,4,19,6],[8,4,8,6],[10,4,10,6],[13,4,13,6],[20,4,20,6],[25,4,25,6],[14,4,14,6],[11,4,11,6],[21,4,21,6],[22,0,22,6],[23,4,23,6],[28,4,28,6]]}
["Form 3 - Program Budget and Narrative"]
["Agency Name:"]
["Program Name:"]
["Program Type:","Please Select","Note: Offerors may only propose one Program Type per Proposal."]
[{"$f":"IF(B4=\"Landlord Outreach\",\"Proposed Units Secured\",\"Total Proposed Clients Served:\")","v":"Total Proposed Clients Served:"}]
[]
["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"]
["Salaries"]
["Fringe and Payroll Taxes"]
["Operations"]
["General Operating Expenses"]
["Outsourced Professional Services"]
["Supplemental Programmatic Services"]
["Training/Travel Outside Austin and/or Travis Count"]
["Direct Client Assistance"]
["Rental/Mortgage Assistance (not eligible for this solicitation)"]
["General Housing Assistance"]
["Direct Client Assistance"]
["Client Food and Beverage"]
["Capital"]
["Capital Outlay"]
["Sub-Grantees (If Applicable) - Enter information under SubGrantee Budget Worksheet"]
["Personnel Sub-Grantee",{"$f":"SUM('SubGrantee Budget'!G8,'SubGrantee Budget'!G12,'SubGrantee Budget'!G16,'SubGrantee Budget'!G20,'SubGrantee Budget'!G24,'SubGrantee Budget'!G28,'SubGrantee Budget'!G32,'SubGrantee Budget'!G36,'SubGrantee Budget'!G40)","v":0},{"$f":"SUM('SubGrantee Budget'!H8,'SubGrantee Budget'!H12,'SubGrantee Budget'!H16,'SubGrantee Budget'!H20,'SubGrantee Budget'!H24,'SubGrantee Budget'!H28,'SubGrantee Budget'!H32,'SubGrantee Budget'!H36,'SubGrantee Budget'!H40)","v":0},{"$f":"SUM(B26:C26)","v":0}]
["Operations Sub-Grantee",{"$f":"SUM('SubGrantee Budget'!G9,'SubGrantee Budget'!G13,'SubGrantee Budget'!G17,'SubGrantee Budget'!G21,'SubGrantee Budget'!G25,'SubGrantee Budget'!G29,'SubGrantee Budget'!G33,'SubGrantee Budget'!G37,'SubGrantee Budget'!G41)","v":0},{"$f":"SUM('SubGrantee Budget'!H9,'SubGrantee Budget'!H13,'SubGrantee Budget'!H17,'SubGrantee Budget'!H21,'SubGrantee Budget'!H25,'SubGrantee Budget'!H29,'SubGrantee Budget'!H33,'SubGrantee Budget'!H37,'SubGrantee Budget'!H41)","v":0},{"$f":"SUM(B27:C27)","v":0}]
["Direct Client Assistance Sub-Grantee",{"$f":"SUM('SubGrantee Budget'!G10,'SubGrantee Budget'!G14,'SubGrantee Budget'!G18,'SubGrantee Budget'!G22,'SubGrantee Budget'!G26,'SubGrantee Budget'!G30,'SubGrantee Budget'!G34,'SubGrantee Budget'!G38,'SubGrantee Budget'!G42)","v":0},{"$f":"SUM('SubGrantee Budget'!H10,'SubGrantee Budget'!H14,'SubGrantee Budget'!H18,'SubGrantee Budget'!H22,'SubGrantee Budget'!H26,'SubGrantee Budget'!H30,'SubGrantee Budget'!H34,'SubGrantee Budget'!H38,'SubGrantee Budget'!H42)","v":0},0]
["Other Sub-Grantee",{"$f":"SUM('SubGrantee Budget'!G11,'SubGrantee Budget'!G15,'SubGrantee Budget'!G19,'SubGrantee Budget'!G23,'SubGrantee Budget'!G27,'SubGrantee Budget'!G31,'SubGrantee Budget'!G35,'SubGrantee Budget'!G39,'SubGrantee Budget'!G43)","v":0},{"$f":"SUM('SubGrantee Budget'!H11,'SubGrantee Budget'!H15,'SubGrantee Budget'!H19,'SubGrantee Budget'!H23,'SubGrantee Budget'!H27,'SubGrantee Budget'!H31,'SubGrantee Budget'!H35,'SubGrantee Budget'!H39,'SubGrantee Budget'!H43)","v":0},0]
["Other"]
["Other",null,null,{"$f":"SUM(B31:C31)","v":0}]
["Total:",{"$f":"SUM(B11:B31)","v":0},{"$f":"SUM(C11:C31)","v":0},{"$f":"SUM(D11:D31)","v":0}]

{"sheet":"SubGrantee Budget","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[7,0,10,0],[7,1,10,1],[7,2,10,2],[7,3,10,3],[7,4,10,4],[15,0,18,0],[15,1,18,1],[15,2,18,2],[15,3,18,3],[15,4,18,4],[11,0,14,0],[11,1,14,1],[11,2,14,2],[11,3,14,3],[11,4,14,4],[19,0,22,0],[19,1,22,1],[19,2,22,2],[19,3,22,3],[19,4,22,4],[27,0,30,0],[27,1,30,1],[27,2,30,2],[27,3,30,3],[27,4,30,4],[23,0,26,0],[23,1,26,1],[23,2,26,2],[23,3,26,3],[23,4,26,4],[31,0,34,0],[31,1,34,1],[31,2,34,2],[31,3,34,3],[31,4,34,4],[35,0,38,0],[35,1,38,1],[35,2,38,2],[35,3,38,3],[35,4,38,4],[39,0,42,0],[39,1,42,1],[39,2,42,2],[39,3,42,3],[39,4,42,4]]}
[{"$f":"Budget!A1","v":"Form 3 - Program Budget and Narrative"}]
[{"$f":"Budget!A2","v":"Agency Name:"}]
[{"$f":"Budget!A3","v":"Program Name:"}]
["Program Type:",{"$f":"Budget!B4","v":"Please Select"}]
[{"$f":"Budget!A5","v":"Total Proposed Clients Served:"},{"$f":"Budget!B5","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(G8:H8)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G9:H9)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G11:H11)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G12:H12)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G13:H13)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G15:H15)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G16:H16)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G17:H17)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G19:H19)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G20:H20)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G21:H21)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G23:H23)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G24:H24)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G25:H25)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G27:H27)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G28:H28)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G29:H29)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G31:H31)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G32:H32)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G33:H33)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G35:H35)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G36:H36)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G37:H37)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G39:H39)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G40:H40)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G41:H41)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G43:H43)","v":0}]
[null,null,null,null,null,"Total:",{"$f":"SUM(G8:G43)","v":0},{"$f":"SUM(H8:H43)","v":0},0]
[null,null,null,null,null,"Total From Budget:",{"$f":"SUM(Budget!B26:B29)","v":0},{"$f":"SUM(Budget!C26:C29)","v":0},{"$f":"SUM(G45:H45)","v":0}]

{"sheet":"Source of All Funds","index":3,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Budget!A1","v":"Form 3 - Program Budget and Narrative"}]
[{"$f":"Budget!A2","v":"Agency Name:"},{"$f":"Budget!B2","v":0}]
[{"$f":"Budget!A3","v":"Program Name:"},{"$f":"Budget!B3","v":0}]
[{"$f":"Budget!A4","v":"Program Type:"},{"$f":"Budget!B4","v":"Please Select"}]
[{"$f":"Budget!A5","v":"Total Proposed Clients Served:"},{"$f":"Budget!B5","v":0}]
[]
["Funding Source","Amount","Grant/Contract Title","Period Start","Period End"]
["City of Austin",{"$f":"Budget!B32","v":0},{"$f":"Budget!B3","v":0},"2022-10-01","2023-09-30"]
["City of Austin"]
["Travis County"]
["Travis County"]
["Federal"]
["Federal"]
["State"]
["State"]
["Contributions"]
["Other(Specify)"]
["Other(Specify)"]
["Other(Specify)"]
["Other(Specify)"]
["Total of All Funding:",{"$f":"SUM(B8:B20)","v":0}]
["Total from Budget Worksheet:",{"$f":"Budget!D32","v":0}]
["Difference:",{"$f":"SUM(B21-B22)","v":0}]

{"sheet":"Cost Per Client","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Budget!A1","v":"Form 3 - Program Budget and Narrative"}]
[{"$f":"Budget!A2","v":"Agency Name:"},{"$f":"Budget!B2","v":0}]
[{"$f":"Budget!A3","v":"Program Name:"},{"$f":"Budget!B3","v":0}]
["Program Type:",{"$f":"Budget!B4","v":"Please Select"}]
[{"$f":"Budget!A5","v":"Total Proposed Clients Served:"},{"$f":"Budget!B5","v":0}]
[]
["Program Type:",{"$f":"Budget!B4","v":"Please Select"}]
["Overall Budget:",{"$f":"Budget!D32","v":0}]
["Cost Per Client Served:",{"$f":"IF(B8=0,\"\",SUM(B8/B5))","v":""}]