{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Budget and Narrative Form","Funding Summary","Instructions"],"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":"Budget and Narrative Form","index":0,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,0,33,0],[34,3,34,4],[5,4,6,4],[29,0,30,0],[21,4,24,4],[15,4,18,4],[9,4,12,4],[25,4,27,4],[28,0,28,4],[31,0,31,4]]}
["Form 3 - Program Budget and Narrative"]
["Agency Name: Click or tap here to enter text."]
["Program Name: Click or tap here to enter text."]
[]
["A.  PERSONNEL","Requested On-going\nCITY OF AUSTIN \nFunds 12-months","Amount Funded by ALL OTHER Sources 12-months "," TOTAL  Budget (ALL funding sources) \n12 months","Budget Narrative\nPlease complete an explanation for each City-funded line item."]
["Salaries",0,0,{"$f":"SUM(B6:C6)","v":0}]
["Fringe and Payroll Taxes",0,0,{"$f":"SUM(B7:C7)","v":0}]
["A.  SUBTOTALS: PERSONNEL",{"$f":"SUM(B6:B7)","v":0},{"$f":"SUM(C6:C7)","v":0},{"$f":"SUM(D6:D7)","v":0}]
["B.  OPERATIONS"]
["General Operations",0,0,{"$f":"SUM(B10:C10)","v":0}]
["Outsourced Professional Services",0,0,{"$f":"SUM(B11:C11)","v":0}]
["Supplemental Programmatic Services",0,0,{"$f":"SUM(B12:C12)","v":0}]
["Training/Travel Outside Austin and/or Travis County",0,0,{"$f":"SUM(B13:C13)","v":0}]
["B.  SUBTOTALS: OPERATIONS",{"$f":"SUM(B10:B13)","v":0},{"$f":"SUM(C10:C13)","v":0},{"$f":"SUM(D10:D13)","v":0}]
["C.  ASSISTANCE TO CLIENTS"]
["Rental/Mortgage Assistance",0,0,{"$f":"SUM(B16:C16)","v":0}]
["General Housing Assistance",0,0,{"$f":"SUM(B17:C17)","v":0}]
["Direct Client Assistance",0,0,{"$f":"SUM(B18:C18)","v":0}]
["Client Food and Beverage",0,0,{"$f":"SUM(B19:C19)","v":0}]
["C.  SUBTOTALS: ASSISTANCE TO CLIENTS",{"$f":"SUM(B16:B19)","v":0},{"$f":"SUM(C16:C19)","v":0},{"$f":"SUM(D16:D19)","v":0}]
["D. SUB-GRANTEES/SUB-RECIPIENTS"]
["Personnel-Sub",0,0,{"$f":"SUM(B22:C22)","v":0}]
["Operations-Sub",0,0,{"$f":"SUM(B23:C23)","v":0}]
["Direct Client Assistance-Sub",0,0,{"$f":"SUM(B24:C24)","v":0}]
["Other-Sub",0,0,{"$f":"SUM(B25:C25)","v":0}]
["D.  SUB-GRANTEES/SUB-RECIPIENTS",{"$f":"SUM(B22:B25)","v":0},{"$f":"SUM(C22:C25)","v":0},{"$f":"SUM(D22:D25)","v":0}]
["GRAND TOTAL (A - D)",{"$f":"B20+B14+B8+B26","v":0},{"$f":"C20+C14+C8+C26","v":0},{"$f":"D20+D14+D8+D26","v":0}]
["PERCENT SHARE of 12-month Total for Funding Sources:",{"$f":"IF(B27=0,\"\", B27/D27)","v":""},{"$f":"IF(C27=0, \"\", C27/D27)","v":""},1]
["COMPLETE IF PROPOSING DIRECT SERVICES MODEL"]
["E. COST PER CLIENT CALCULATION","Total Unduplicated Clients 12-months October 1, 2022 - September 30, 2023","City Portion","Other Funded Portion","$ Cost per client"]
[null,null,{"$f":"IF(B31=\"\", \"\", B31*B28)","v":""},{"$f":"IF(B31=\"\", \"\", B31*C28)","v":""},{"$f":"IF(B31=\"\", \"\", D27/B31)","v":""}]
["COMPLETE IF PROPOSING SUB-AWARDS MODEL"]
["F. ESTIMATED AWARDS","Average Amount of Each Award","Number of Anticipated Awards","Total Amount to be Awarded to the Community (Must total $50,000)"]
[null,null,null,{"$f":"IF(B34=\"\", \"\", B34*C34)","v":""}]
[null,null,null,{"$f":"IF(D26=0, \"\", \"Does Not Match Section D Subtotal\")","v":""}]

{"sheet":"Funding Summary","index":1,"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-10-01","2023-09-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='Budget and Narrative Form'!D27, \"\", \"Does Not Match\")","v":""}]

{"sheet":"Instructions","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[29,1,32,1],[14,0,14,1],[15,0,15,1],[16,1,17,1],[18,0,18,1],[23,0,23,1],[28,0,28,1],[9,0,9,1],[6,0,6,1],[7,0,7,1],[8,0,8,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]]}
["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.  "]
["·         The amount requested for ongoing funding must reflect an 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."]
[" 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 in Column E.  "]
["·         Do not enter narrative for budget lines that are blank or budgeted amounts from Other Funding."]
["·        If you are proposing a Sub-award Program, include administrative costs as appropriate (up to $7,500 total) in the appropriate line itmes, and complete Section D. Sub-grantees/Subrecipients and Section F. Estimated Awards"]
["·         If proposing a Direct Service Program, complete Section E. Cost per Client Calculation: Add the number of total clients projected to be served in a 12-month period to get the cost per client in the space below the budget"]
["Funding Summary 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."]
["·         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"]