{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Budget Narrative","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":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[21,0,21,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[18,0,18,1],[16,0,16,1],[17,0,17,1],[20,0,20,1],[31,0,31,1],[36,0,36,1],[37,1,40,1],[22,0,22,1],[23,0,23,1],[24,1,25,1],[26,0,26,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],[19,0,19,1],[8,0,8,1],[7,0,7,1],[10,0,10,1]]}
["Budget Narrative Tab Instructions"]
["·         Please enter information into cells that are highlighted orange. Do not leave B2-B4 blank. ",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 the 12-month contract period."]
["·         Column C: List expected amounts from funding sources other than COA for the 12-month contract period."]
["·         Calculate and check all subtotals and totals; ensure all line item amounts, subtotals, and totals are in WHOLE DOLLARS and are correct."]
["·         Column E: For every budget line containing a requested amount of City of Austin funding, enter a short description and/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."]
[]
["Subgrantee Budget Tab Instructions (only for applicants that will have subgrantees)."]
["·         Column A: List each subgrantee agency's name in separate rows. "]
["·         Column B: List the date that each subgrantee will begin services funded by this contract."]
["·         Column C: List the date that each subgrantee will end services funded by this contract."]
["·         Column D: List all program services that this contract will fund subgrantee(s) to provide.  "]
["·         Column E: List the unduplicated client count that each sub-grantee will bring in, which will be separate from the clients from the Lead Agency's clients. These clients will contribute to the overall number of clients served.  "]
["·         Column  F: List the amount of City funding from this contract that subgrantees will receive for services listed in Column E. "]
["·         Column G: List expected funding amounts from sources other than COA for subgrantees' services listed in Column E. "]
[]
["Cost per Client Tab: "]
["·         This tab will auto-populate with data from the Budget and Narrative tab. "]
[]
["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 that provides  services such as consulting, accounting or auditing, or translation/interpretation and language access services, includeding sign language interpretation. 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 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 benefits 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/Subrecipients"]
["Personnel-Sub","If the organization will be subcontracting, the Lead Agency would assume full responsibility for paying subgrantees/subrecipients with City funds.  These categories are for costs associated with subgrantees/subrecipients with individuals or agencies to provide client services that contribute to the unduplicated client count in the proposed performance measures. These clients would be unique clients brought in from the subgrantee, 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 Narrative","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,0,5,4]]}
["Form 3 - Program Budget and Narrative"]
["Agency Name:"," "]
["Program Name:"," "]
["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 for the SAME program 12 months","Total Budget (All Funding Sources) 12 Months","Complete an explanation for each City-funded line item."]
["Salaries"]
["Personnel (benefits and payroll taxes)",null,null,{"$f":"SUM(B10:C10)","v":0}]
["Operations"]
["General Operations",null,null,{"$f":"SUM(B12:C12)","v":0}]
["Outsourced Professional Services",null,null,{"$f":"SUM(B13:C13)","v":0}]
["Supplemental Programmatic Services",null,null,0]
["Training/Travel Outside of Austin/Travis County",null,null,0]
["Financial Assistance to Clients",null,null,{"$f":"SUM(B16:C16)","v":0}]
["Rental Assistance",null,null,{"$f":"SUM(B17:C17)","v":0}]
["General Housing Assistance",null,null,{"$f":"SUM(B18:C18)","v":0}]
["Direct Client Assistance",null,null,0]
["Client Food and Beverage",null,null,0]
["Sub-Grantees - Use SubGrantee Budget worksheet to enter amounts (If applicable)"]
["Sub-Grantee Personnel",{"$f":"SUM('Subgrantee Budget'!G7,'Subgrantee Budget'!G11,'Subgrantee Budget'!G15,'Subgrantee Budget'!G19,'Subgrantee Budget'!G23,'Subgrantee Budget'!G27,'Subgrantee Budget'!G31,'Subgrantee Budget'!G35,'Subgrantee Budget'!G39)","v":0},{"$f":"SUM('Subgrantee Budget'!H7,'Subgrantee Budget'!H11,'Subgrantee Budget'!H15,'Subgrantee Budget'!H19,'Subgrantee Budget'!H23,'Subgrantee Budget'!H27,'Subgrantee Budget'!H31,'Subgrantee Budget'!H35,'Subgrantee Budget'!H39)","v":0},{"$f":"SUM(B22:C22)","v":0}]
["Sub-Grantee Operations",{"$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(B23:C23)","v":0}]
["Sub-Grantee Direct Assistance",{"$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},0]
["Sub-Grantee Other",{"$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]
["Program Income"]
["Program Income",null,null,0]
["Other"]
["Other",null,null,{"$f":"SUM(B29:C29)","v":0}]
["Total:",{"$f":"SUM(B10,B12,B13,B14,B15,B17,B18,B19,B22,B23,B24,B25,B27,B29)","v":0},{"$f":"SUM(C10,C12,C13,C14,C15,C17,C18,C19,C22,C23,C24,C25,C27,C29)","v":0},{"$f":"SUM(D10,D12,D13,D14,D15,D17,D18,D19,D22,D23,D24,D25,D27,D29)","v":0}]

{"sheet":"Subgrantee Budget","index":2,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[38,0,41,0],[38,1,41,1],[38,2,41,2],[38,3,41,3],[38,4,41,4],[34,0,37,0],[34,1,37,1],[34,2,37,2],[34,3,37,3],[34,4,37,4],[30,0,33,0],[30,1,33,1],[30,2,33,2],[30,3,33,3],[30,4,33,4],[22,0,25,0],[22,1,25,1],[22,2,25,2],[22,3,25,3],[22,4,25,4],[26,0,29,0],[26,1,29,1],[26,2,29,2],[26,3,29,3],[26,4,29,4],[18,0,21,0],[18,1,21,1],[18,2,21,2],[18,3,21,3],[18,4,21,4],[10,0,13,0],[10,1,13,1],[10,2,13,2],[10,3,13,3],[10,4,13,4],[14,0,17,0],[14,1,17,1],[14,2,17,2],[14,3,17,3],[14,4,17,4],[6,0,9,0],[6,1,9,1],[6,2,9,2],[6,3,9,3],[6,4,9,4]]}
[{"$f":"'Budget Narrative'!A1","v":"Form 3 - Program Budget and Narrative"}]
[{"$f":"'Budget Narrative'!A2","v":"Agency Name:"},{"$f":"'Budget Narrative'!B2","v":" "}]
[{"$f":"'Budget Narrative'!A3","v":"Program Name:"},{"$f":"'Budget Narrative'!B3","v":" "}]
[{"$f":"'Budget Narrative'!A4","v":"Total Proposed Clients Served:"},{"$f":"'Budget Narrative'!B4","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(G7:H7)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G8:H8)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G10:H10)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G11:H11)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G12:H12)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G14:H14)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G15:H15)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G16:H16)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G18:H18)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G19:H19)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G20:H20)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G22:H22)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G23:H23)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G24:H24)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G26:H26)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G27:H27)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G28:H28)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G30:H30)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G31:H31)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G32:H32)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G34:H34)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G35:H35)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G36:H36)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G38:H38)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G39:H39)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G40:H40)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G42:H42)","v":0}]
[null,null,null,null,null,"Total:",{"$f":"SUM(G7:G42)","v":0},{"$f":"SUM(H7:H42)","v":0},0]

{"sheet":"Cost Per Client","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Budget Narrative'!A1","v":"Form 3 - Program Budget and Narrative"}]
[{"$f":"'Budget Narrative'!A2","v":"Agency Name:"},{"$f":"'Budget Narrative'!B2","v":" "}]
[{"$f":"'Budget Narrative'!A3","v":"Program Name:"},{"$f":"'Budget Narrative'!B3","v":" "}]
[{"$f":"'Budget Narrative'!A4","v":"Total Proposed Clients Served:"},{"$f":"'Budget Narrative'!B4","v":0}]
[]
["Overall Budget:",{"$f":"'Budget Narrative'!D30","v":0}]
["Cost per client",{"$f":"IF(B4=\"\",\"\",SUM(B6/B4))","v":{"$error":"#DIV/0!"}}]