{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Budget & Narrative"],"not_rendered":{"charts":0,"images":1,"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":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions for completing the Program Budget and Budget Narrative:\n\n-DACC Amount is the  amount for the program funded by the City of Austin Downtown Austin Community Court (DACC).\n\n-Other Funders Amount is the  amount of funding received from all other funding sources for the program being funded by the DACC.\n\n-Total Program Budget is the sum of all funding sources, DACC and Other Funders, which is the entrie cost to administer the program being funded by DACC.\n\n-All line item amounts must be whole dollars only\n\n-Program Budget Narrative should include high level details to describe or explain the amount of funding ONLY in the DACC Amount column for the amount listed in each budget line item.  Do not exceed one page for the Program Budget Narrative.\n"]
["Line 1","Salary is the amount of funding for agency program staff wages."]
["Line 2","Fringe is the amount of funding for agency program staff non-salary expenses such as insurance, FICA, unemployment taxes, short- and long-term disability taxes, etc…"]
["Line 3","General Operating Expenses is the amount of funding for all operating expenses which are NOT inlcuded in any other Operating Expenses line item.  Examples include any Travel/ Training/ Conferences WITHIN Travis County, Insurance/Bonding, Audit expenses, equipment costing < $5,000, general office supplies, rent, utilities, telecommunications, postage, bookkeeping, lawn maintenance, copier lease, indirect rate, program service fee."]
["Line 4","Program Subcontractors is the amount of funding for individuals or agencies that provide services to the clients being served in the program being funded by DACC."]
["Line 5","Staff Travel - Out of Travis County is the amount of funding for agency program staff funded by DACC to travel outside of Travis County for trainings/meetings/professional development.  Examples include transportation cost, lodging, meals and other expenses associated with traveling."]
["Line 6","Conferences - Out of Travis County is the amount of funding for agency program staff funded by DACC to attend traings/meetings/professional develoment outside of Travis County.  Examples include conference/registration fees or other costs associated with attending the event."]
["Line 7","Food/Beverage for Clients is the amount of funding for food and beverages for program clients being served which is an essential component of the program being funded by DACC."]
["Line 8","Direct Financial Assistance for Clients is the amount of funding to support the clients directly through the program funded by DACC.  Examples include, rent, mortgage, utilities,  transportation."]
["Line 9","Other is the amount of funding  to support the clients through the program funded by DACC which are NOT included in any other Assistance for Program Clients line item."]
["Line 10","Capital Equipment (>$5,000) is the amount of funding for items with a per unit cost of $5,000 or more including freight charges."]

{"sheet":"Budget & Narrative","index":1,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[3,0,3,4],[5,2,5,4],[10,0,10,4],[6,2,6,4],[7,2,7,4],[32,0,32,4],[33,0,33,4],[35,0,35,4],[28,0,28,4],[14,0,14,4],[20,0,20,4],[25,0,25,4],[50,2,50,4],[42,0,42,4],[47,0,47,4],[51,0,51,4],[40,0,40,1],[41,0,41,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[52,2,52,4],[38,0,38,1],[39,0,39,4],[38,2,38,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[48,0,48,1],[49,0,49,1],[50,0,50,1],[52,0,52,1],[40,2,40,4],[41,2,41,4],[48,2,48,4],[49,2,49,4]]}
["City of Austin"]
["Downtown Austin Community Court"]
[]
["     ANNUAL PROGRAM BUDGET & BUDGET NARRATIVE"]
[]
[null,"Agency Name:","Agency Name"]
[null,"Program Name:","Program Name"]
[]
[]
["Line","Item","DACC Amount","Other Funders Amount","Total Program Budget"]
["PERSONNEL"]
[1,"Salary",null,null,{"$f":"SUM(C12:D12)","v":0}]
[2,"Fringe",null,null,{"$f":"SUM(C13:D13)","v":0}]
["A","Subtotal - Personnel",{"$f":"SUM(C12:C13)","v":0},{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(C14:D14)","v":0}]
["OPERATING EXPENSES"]
[3,"General Operating Expenses",null,null,{"$f":"SUM(C16:D16)","v":0}]
[4,"Program Subcontractors",null,null,{"$f":"SUM(C17:D17)","v":0}]
[5,"Staff Travel - Out of Travis County",null,null,{"$f":"SUM(C18:D18)","v":0}]
[6,"Conferences - Out of Travis County",null,null,{"$f":"SUM(C19:D19)","v":0}]
["B","Subtotal - Operating Expenses",{"$f":"SUM(C16:C19)","v":0},{"$f":"SUM(D16:D19)","v":0},{"$f":"SUM(C20:D20)","v":0}]
["ASSISTANCE FOR PROGRAM CLIENTS"]
[7,"Food/Beverage for Clients",null,null,{"$f":"SUM(C22:D22)","v":0}]
[8,"Direct Financial Assistance for Clients",null,null,{"$f":"SUM(C23:D23)","v":0}]
[9,"Other",null,null,{"$f":"SUM(C24:D24)","v":0}]
["C","Subtotal - Direct Client Assistance",{"$f":"SUM(C22:C24)","v":0},{"$f":"SUM(D22:D24)","v":0},{"$f":"SUM(C25:D25)","v":0}]
["CAPITAL OUTLAY (with per Unit Cost >$5,000)"]
[10,"Capital Equipment (>$5,000)",null,null,{"$f":"SUM(C27:D27)","v":0}]
["D","Subtotal Capital",{"$f":"SUM(C27)","v":0},{"$f":"SUM(D27)","v":0},{"$f":"SUM(C28:D28)","v":0}]
["TOTALS"]
["E","Total (A+B+C+D+E)",{"$f":"SUM(C28,C25,C20,C14)","v":0},{"$f":"SUM(D28,D25,D20,D14)","v":0},{"$f":"SUM(C30:D30)","v":0}]
[null,"Percent Share by Funding Source",{"$f":"C30/E30","v":{"$error":"#DIV/0!"}},{"$f":"D30/E30","v":{"$error":"#DIV/0!"}},1]
[]
["City of Austin"]
["Downtown Austin Community Court"]
[]
["PROGRAM BUDGET & BUDGET NARRATIVE"]
[]
[]
["Line Item",null,"Narrative/Description"]
["PERSONNEL"]
["Salary"]
["Fringe"]
["OPERATING EXPENSES"]
["General Operating Expenses"]
["Program Subcontractors"]
["Staff Travel - Out of Travis County"]
["Conferences/Seminars - Out of Travis County"]
["DIRECT ASSISTANCE FOR PROGRAM CLIENTS"]
["Food/Beverage for Clients"]
["Financial Assistance for Clients"]
["Other"]
["CAPITAL OUTLAY (with per Unit Cost >$5,000)"]
["Capital Equipment (>$5,000)"]