{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Multiyear Budget and Narrative ","Funding Summary"],"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":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,0,5,1],[9,0,9,1],[14,0,14,1],[30,1,33,1],[15,0,15,1],[16,0,16,1],[17,1,18,1],[19,0,19,1],[24,0,24,1],[29,0,29,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[10,0,10,1],[6,0,6,1],[8,0,8,1],[7,0,7,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,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.  "]
["·         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."]
[]
[" Budget Narrative Instructions"]
["·         Complete the tab labeled Budget and Narrative Form"]
["·         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. Line item description examples are included below for your reference.  "]
["·         Do not enter narrative for budget lines that are blank or budgeted amounts from Other Funding."]
[]
["Funding Summary Instructions"]
["·         Include the funding source, grant/contract name (if applicable), and ANNUAL (first 12 months) amount of all funding including the requested City of Austin funding in the table."]
["·         The totals in this form should match the total shaded in yellow in the Program Budget and Narrative Form \"Total Budget All Funding Sources Column\" which includes Requested CITY OF AUSTIN Amount and ALL OTHER Sources."]
[]
["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. 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":"Multiyear Budget and Narrative ","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,0,35,0],[33,0,33,4],[13,4,16,6],[17,4,17,6],[18,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[1,2,1,3],[2,2,2,3],[4,4,4,6],[5,4,6,6],[7,4,7,6],[8,4,11,6],[12,4,12,6]]}
["Form 3: Program Budget and Narrative"]
["Agency Name: Click or tap here to enter text.","Period 1 dates","7/1/2022 - 6/30/2023"]
["Program Name: Click or tap here to enter text.","Period 2 dates","7/1/2023 - 6/30/2024"]
[]
["Line Item Category","City of Austin  Period 1","City of Austin  Period 2","Other Funding (Period 1)","Narrative (City of Austin funding only)"]
["Salaries"]
["Fringe"]
["SUBTOTALS: PERSONNEL",{"$f":"SUM(B6:B7)","v":0},{"$f":"SUM(C6:C7)","v":0},0]
["General Operations"]
["Outsourced Professional Services"]
["Supplemental Programmatic Services"]
["Training/Travel Outside Austin and/or Travis County"]
["SUBTOTALS: OPERATIONS",{"$f":"SUM(B9:B12)","v":0},{"$f":"SUM(C9:C12)","v":0},0]
["Rental/Mortgage Assistance"]
["General Housing Assistance"]
["Direct Client Assistance"]
["Client Food and Beverage"]
["SUBTOTALS: ASSISTANCE TO CLIENTS",{"$f":"SUM(B14:B17)","v":0},{"$f":"SUM(C14:C17)","v":0},0]
["Personnel-Sub"]
["Operations-Sub"]
["Direct Client Assistance-Sub"]
["Other-Sub"]
["SUBTOTALS: SUB-GRANTEES/SUB-RECIPIENTS",{"$f":"SUM(B19:B22)","v":0},{"$f":"SUM(C19:C22)","v":0},0]
["Capital Outlay - $5,000"]
["SUBTOTALS: CAPITAL OUTLAY",{"$f":"B24","v":0},{"$f":"C24","v":0},0]
["Deliverables Amount"]
["SUBTOTALS: DELIVERABLE AMOUNT",{"$f":"B26","v":0},{"$f":"C26","v":0},0]
["Program Income"]
["SUBTOTALS: PROGRAM INCOME",{"$f":"B28","v":0},{"$f":"C28","v":0},0]
["Other"]
["SUBTOTALS: OTHER",{"$f":"B30","v":0},{"$f":"C30","v":0},0]
["GRAND TOTAL ",{"$f":"B8+B13+B18+B23+B25+B27+B29+B31","v":0},{"$f":"C8+C13+C18+C23+C25+C27+C29+C31","v":0},0]
[]
["COMPLETE FOR OUTPUT: UNDUPLICATED CLIENTS SERVED"]
["E. COST PER CLIENT CALCULATION","Total Unduplicated Clients for Program Period 1, July 1, 2022 - June 30, 2023","City Portion for Program Period 1","Other Funded Portion for Program Period 1","$ Cost per Client"]
[null,null,{"$f":"IF(B36=0,\"\",SUM(B36*(B32/SUM(B32,D32))))","v":""},{"$f":"IF(B36=0, \"\", SUM(B36-C36))","v":""},{"$f":"IF(B36=\"\",\"\",(B32+D32)/B36)","v":""}]

{"sheet":"Funding Summary","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,1,26,2],[27,1,27,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[28,2,28,4],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[4,0,5,0],[4,1,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5]]}
["Form 3 - Program Funding Summary"]
["Agency Name: Click or tap here to enter text."]
["Program Name: Click or tap here to enter text."]
[]
["Funding Sources","Grant/Contract Name",null,"Funding Period Start Date","Funding Period End Date","Funding Amount"]
[]
["City of Austin ","Social Service Contract (City of Austin prgm. budget)",null,"2022-07-01","2023-06-30",0]
["City of Austin",null,null,null,null,0]
["City of Austin",null,null,null,null,0]
[null,null,null,null,null,0]
["Travis County",null,null,null,null,0]
["Travis County",null,null,null,null,0]
[null,null,null,null,null,0]
["Federal",null,null,null,null,0]
["Federal",null,null,null,null,0]
[null,null,null,null,null,0]
["State",null,null,null,null,0]
["State",null,null,null,null,0]
[null,null,null,null,null,0]
["United Way",null,null,null,null,0]
[null,null,null,null,null,0]
["Contributions",null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Other (Specify)",null,null,null,null,0]
["Other (Specify)",null,null,null,null,0]
["Other (Specify)",null,null,null,null,0]
["Other (Specify)",null,null,null,null,0]
[null,null,"TOTAL PROGRAM FUNDING:  ",null,null,{"$f":"SUM(F7:F28)","v":0}]
[null,null,null,null,null,{"$f":"IF(F29='Multiyear Budget and Narrative '!D27, \"\", \"Does Not Match\")","v":""}]