{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions & Descriptions","GenOps","Program Budget and Narrative","Amendment_Renewal","MultiYear"],"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 & Descriptions","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,0,25,1],[27,0,27,1],[11,0,11,1],[20,0,20,1],[21,1,24,1],[18,0,18,1],[16,0,16,1],[1,0,1,1],[2,0,2,1],[0,0,0,1],[6,0,6,1],[3,0,3,1]]}
["Program Budget And Narrative Instructions"]
["·  All line item amounts must be entered as WHOLE DOLLARS.\r\n· If no funds are budgeted for a line item, leave it blank. \r\n·  The dollar amount requested must reflect amounts for ANNUAL FUNDING (typically a 12-month period).  \r\n·  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.\r\n· 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.  \r\n· Do not enter narrative for budget lines that are blank or budgeted amounts from Other Funding."]
["Budget Narrative Descriptions"]
["Salaries and Benefits "]
["Salaries","Personnel wages"]
["Fringe and Payroll Taxes","Personnel benefits and payroll taxes"]
["General Operating Expenses"]
["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 performance. These services will be supplemental services provided to your program clients such as counseling by an external provider for a client receiving case management by your agency."]
["Training/Travel Outside Austin and/or Travis County","Include any necessary training that will take place outside Austin and/or Travis County that contributes to the work of the program funded by APH. Examples include: registration fees, airplane tickets, rental car, per diem, hotel fees. Not to exceed OMB daily allowance per location."]
["Assistance to Clients"]
["Rental/Mortgage Assistance","HOUSING PROGRAMS ONLY. Rental payments and arrears, mortgage payments or assistance. "]
["General Housing Assistance","HOUSING PROGRAMS ONLY. 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, 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."]
["Client Food and Beverage","Direct food or meals for clients."]
["Capital Outlay"]
["Capital Outlay - $5,000.00","Single item valued at $5,000 or more per unit. Examples: commercial refrigerator, computer server."]
["Deliverable Amount"]
["Deliverable Amount","Total amount of Deliverables contract 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"]
["Program Income"]
["Program Income (Zero dollars budgeted for monthly credit)","Funding anticipated to be earned from clients funded by program. Examples: Medicaid reimbursements, client fees. "]
["Other"]
["Other","Any item not accounted for in any other category and not a general operating expense."]
[]
[]
[null,"                                     "]

{"sheet":"GenOps","index":1,"n_rows":82,"n_cols":1,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["GENERAL OPERATING EXPENSES"]
["Expense Category"]
["Occupancy"]
["Rent for agency offices or buildings"]
["Mortgage payments for agency offices or buildings"]
["Utilities for agency offices or buildings"]
["Insurance"]
["Building"]
["General Liability"]
["Worker's compensation"]
["Professional"]
["Directors and Officers (D&O)"]
["Sexual abuse and molestation (SAM)"]
["Auto"]
["Transportation"]
["Mileage at City-approved annual rate"]
["TxTag/toll fees"]
["Parking"]
["Bus/train "]
["Cabs/Rideshares to meetings"]
["Maintenance"]
["IT services"]
["Pest control"]
["Elevator maintenance"]
["Painting"]
["Grounds keeping"]
["Printer/copier maintenance"]
["Vehicle maintenance"]
["HVAC maintenance"]
["Janitorial services"]
["Security"]
["Building renovation"]
["Building repairs"]
["Office Supplies"]
["Paper goods"]
["Writing utensils"]
["Office organizational supplies"]
["Office furniture"]
["Basic items for office breakroom"]
["Printer ink/toner"]
["Stapler, staples, paperclips, desk organizational tools, calendars"]
["Other similar items used in office work"]
["Workplace facility health and safety items"]
["Mother-friendly room including equipment"]
["Office wellness/health items"]
["Equipment"]
["Laptop"]
["Desktop"]
["Input devices and peripherals, computer accessories"]
["Monitors"]
["Printers"]
["Networking devices"]
["Computer servers"]
["Security cameras"]
["Washer/dryer units"]
["Commercial kitchen equipment"]
["Van for client transportation"]
["Communications"]
["Telephone"]
["Wireless phone network"]
["Cellular phones for office work"]
["Internet"]
["Cable"]
["Postage"]
["Courier services"]
["Database and server subsriptions"]
["Software development"]
["Marketing/Outreach"]
["Costs associated with client outreach"]
["Printing"]
["Direct mail"]
["Magazines, radio, television, direct mail ads"]
["Postage"]
["Exhibits and outreach event supplies"]
["Social Media campaign"]
["HR advertising"]
["Program Supplies"]
["Laundry services"]
["Toiletries for clients"]
["Art supplies"]
["Educational materials"]
["Community and recreation activity supplies"]

{"sheet":"Program Budget and Narrative","index":2,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[25,4,25,6],[26,4,26,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[23,4,23,6],[39,4,39,6],[16,0,16,6],[22,0,22,6],[28,0,28,6],[31,0,31,6],[34,0,34,6],[37,0,37,6],[17,4,17,6],[18,4,18,6],[38,4,38,6],[29,4,29,6],[30,4,30,6],[27,4,27,6],[32,4,32,6],[33,4,33,6],[35,4,35,6],[36,4,36,6],[0,0,0,3],[1,1,1,2],[2,1,2,2],[6,0,6,6],[10,0,10,6],[5,4,5,6],[7,4,7,6],[8,4,8,6],[15,4,15,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[9,4,9,6],[24,4,24,6]]}
[" Program Budget and Narrative"]
["Agency Name  ","Program Name",null,"Date prepared","Notes"]
[]
[]
["PROGRAM BUDGET AND NARRATIVE"]
["Line Item Category","Requested CITY OF AUSTIN Amount","Amount Funded by ALL OTHER Sources "," TOTAL  Budget (ALL funding sources)"," NARRATIVE "]
["PERSONNEL"]
["Salaries"]
["Fringe and Payroll Taxes"]
["SUBTOTALS: PERSONNEL",{"$f":"SUM(B8:B9)","v":0},0,0]
["OPERATIONS"]
["General Operations"]
["Outsourced Professional Services"]
["Supplemental Programmatic Services"]
["Training/Travel Outside Austin and/or Travis County"]
["SUBTOTALS: OPERATIONS",{"$f":"SUM(B12:B15)","v":0},0,0]
["ASSISTANCE TO CLIENTS"]
["Rental/Mortgage Assistance",0,0,{"$f":"SUM(B18:C18)","v":0}]
["General Housing Assistance",0,0,0]
["Direct Client Assistance",0,0,0]
["Client Food and Beverage",0,0,0]
["SUBTOTALS: ASSISTANCE TO CLIENTS",{"$f":"SUM(B18:B21)","v":0},0,0]
["SUB-GRANTEES/SUB-RECIPIENTS"]
["Personnel-Sub"]
["Operations-Sub"]
["Direct Client Assistance-Sub"]
["Other-Sub"]
["SUBTOTALS: SUB-GRANTEES/SUB-RECIPIENTS",{"$f":"SUM(B24:B27)","v":0},{"$f":"SUM(C24:C27)","v":0},{"$f":"SUM(D24:D27)","v":0}]
["CAPITAL OUTLAY"]
["Capital Outlay - $5,000"]
["SUBTOTALS: CAPITAL OUTLAY"]
["DELIVERABLE AMOUNT"]
["Deliverables Amount"]
["SUBTOTALS: DELIVERABLE AMOUNT"]
["PROGRAM INCOME"]
["Program Income"]
["SUBTOTALS: PROGRAM INCOME"]
["OTHER"]
["Other"]
["SUBTOTALS: OTHER"]
["GRAND TOTAL ",{"$f":"B22+B16+B10+B28","v":0},{"$f":"C22+C16+C10+C28","v":0},{"$f":"D22+D16+D10+D28","v":0}]
["PERCENT SHARE of Total for Funding Sources:",{"$f":"B41/D41","v":{"$error":"#DIV/0!"}},{"$f":"C41/D41","v":{"$error":"#DIV/0!"}},1]

{"sheet":"Amendment_Renewal","index":3,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[9,0,9,6],[4,4,4,6],[0,0,0,2],[5,0,5,6],[6,4,6,6],[7,4,7,6],[8,4,8,6],[32,4,32,6],[33,0,33,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,0,27,6],[28,4,28,6],[29,4,29,6],[30,0,30,6],[31,4,31,6],[21,0,21,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[15,0,15,6],[34,4,34,6],[35,4,35,6],[36,0,36,6],[37,4,37,6],[38,4,38,6]]}
["Budget and Narrative Adjustments"]
["Current Annual Amount","$"]
["Amendment/Renewal Annual Amount","$"," ",null," "]
["Difference","$"]
[null,"Current Budget","Amended/Renewal Budget","Difference","Amended/Renewal Budget Narrative"]
["PERSONNEL"]
["Salaries"]
["Fringe and Payroll Taxes"]
["SUBTOTALS: PERSONNEL",{"$f":"SUM(B7:B8)","v":0},0,0]
["OPERATIONS"]
["General Operations"]
["Outsourced Professional Services"]
["Supplemental Programmatic Services"]
["Training/Travel Outside Austin and/or Travis County"]
["SUBTOTALS: OPERATIONS",{"$f":"SUM(B11:B14)","v":0},0,0]
["ASSISTANCE TO CLIENTS"]
["Rental/Mortgage Assistance",0,0,{"$f":"SUM(B17:C17)","v":0}]
["General Housing Assistance",0,0,0]
["Direct Client Assistance",0,0,0]
["Client Food and Beverage",0,0,0]
["SUBTOTALS: ASSISTANCE TO CLIENTS",{"$f":"SUM(B17:B20)","v":0},0,0]
["SUB-GRANTEES/SUB-RECIPIENTS"]
["Personnel-Sub"]
["Operations-Sub"]
["Direct Client Assistance-Sub"]
["Other-Sub"]
["SUBTOTALS: SUB-GRANTEES/SUB-RECIPIENTS",{"$f":"SUM(B23:B26)","v":0},{"$f":"SUM(C23:C26)","v":0},{"$f":"SUM(D23:D26)","v":0}]
["CAPITAL OUTLAY"]
["Capital Outlay - $5,000"]
["SUBTOTALS: CAPITAL OUTLAY"]
["DELIVERABLE AMOUNT"]
["Deliverables Amount"]
["SUBTOTALS: DELIVERABLE AMOUNT"]
["PROGRAM INCOME"]
["Program Income"]
["SUBTOTALS: PROGRAM INCOME"]
["OTHER"]
["Other"]
["SUBTOTALS: OTHER"]
["GRAND TOTAL ",{"$f":"B21+B15+B9+B27","v":0},{"$f":"C21+C15+C9+C27","v":0},{"$f":"D21+D15+D9+D27","v":0}]

{"sheet":"MultiYear","index":4,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,6,33,8],[0,7,0,8],[1,7,1,8],[2,7,2,8],[3,7,3,8],[7,6,7,8],[20,6,20,8],[25,6,25,8],[26,6,26,8],[27,6,27,8],[28,6,28,8],[29,6,29,8],[30,6,30,8],[31,6,31,8],[3,1,3,5],[4,1,4,5],[0,1,0,5],[1,1,1,5],[2,1,2,5],[32,6,32,8],[5,1,5,5],[8,6,9,8],[10,6,10,8],[15,6,15,8],[11,6,14,8],[16,6,19,8],[21,6,24,8]]}
["Agency:",null,null,null,null,null,"Period 1 dates",null,null,null,null,"Period 1","Period 2","Period 3","Period 4"]
["Program:",null,null,null,null,null,"Period 2 dates",null,null,null,"Total program",{"$f":"B35+F35","v":0},{"$f":"C35+F35","v":0},{"$f":"D35+G35","v":0},{"$f":"E35+H35","v":0}]
["Financial Contact:",null,null,null,null,null,"Period 3 dates",null,null,null,"City percentage of funding",{"$f":"B35/L2","v":{"$error":"#DIV/0!"}},{"$f":"M2/C35","v":{"$error":"#DIV/0!"}},{"$f":"N2/D35","v":{"$error":"#DIV/0!"}},{"$f":"O2/E35","v":{"$error":"#DIV/0!"}}]
["Telephone:",null,null,null,null,null,"Period 4 dates",null,null,null,"Total program goal"]
["Contract Manager:",null,null,null,null,null,null,null,null,null,"City goal",{"$f":"L4*L3","v":{"$error":"#DIV/0!"}},{"$f":"M4*M3","v":{"$error":"#DIV/0!"}},{"$f":"N4*N3","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Telephone:",null,null,null,null,null,null,null,null,null,"Other funding goal",{"$f":"L4-L5","v":{"$error":"#DIV/0!"}},{"$f":"M4-M5","v":{"$error":"#DIV/0!"}},{"$f":"N4-N5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["Line Item Category","City of Austin  Period 1","City of Austin  Period 2","City of Austin Period 3","City of Austin Period 4","Other Funding (Period 1 or 2)","Narrative"]
["Salaries"]
["Fringe and Payroll Taxes"]
["SUBTOTALS: PERSONNEL",{"$f":"SUM(B9:B10)","v":0},{"$f":"SUM(C9:C10)","v":0},0,0,0]
["General Operations"]
["Outsourced Professional Services"]
["Supplemental Programmatic Services"]
["Training/Travel Outside Austin and/or Travis County"]
["SUBTOTALS: OPERATIONS",{"$f":"SUM(B12:B15)","v":0},{"$f":"SUM(C12:C15)","v":0},0,0,0]
["Rental/Mortgage Assistance"]
["General Housing Assistance"]
["Direct Client Assistance"]
["Client Food and Beverage"]
["SUBTOTALS: ASSISTANCE TO CLIENTS",{"$f":"SUM(B17:B20)","v":0},{"$f":"SUM(C17:C20)","v":0},0,0,0]
["Personnel-Sub"]
["Operations-Sub"]
["Direct Client Assistance-Sub"]
["Other-Sub"]
["SUBTOTALS: SUB-GRANTEES/SUB-RECIPIENTS",{"$f":"SUM(B22:B25)","v":0},{"$f":"SUM(C22:C25)","v":0},0,0,0]
["Capital Outlay - $5,000"]
["SUBTOTALS: CAPITAL OUTLAY",{"$f":"B27","v":0},{"$f":"C27","v":0},0,0,0]
["Deliverables Amount"]
["SUBTOTALS: DELIVERABLE AMOUNT",{"$f":"B29","v":0},{"$f":"C29","v":0},0,0,0]
["Program Income"]
["SUBTOTALS: PROGRAM INCOME",{"$f":"B31","v":0},{"$f":"C31","v":0},0,0,0]
["Other"]
["SUBTOTALS: OTHER",{"$f":"B33","v":0},{"$f":"C33","v":0},0,0,0]
["GRAND TOTAL ",{"$f":"B11+B16+B21+B26+B28+B30+B32+B34","v":0},{"$f":"C11+C16+C21+C26+C28+C30+C32+C34","v":0},0,0,0]