{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","IDOC Summary","Personnel","Fringe","Series 200","Series 300","Series 400","List Options"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"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":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,10],[2,0,2,10],[4,0,4,10],[6,0,6,10],[9,1,9,10],[11,1,11,10],[12,1,12,10],[13,1,13,10],[7,1,7,10],[10,1,10,10],[8,1,8,10]]}
["Budget Instructions"]
[]
["The applicant shall specify costs, including all anticipated costs for successful implementation of all deliverables outlined using this budget worksheet. The budget worksheet must be completed for each contract/grant year and demonstrate how costs were determined. The budget shall remain the same with few revisions for the term of the contract.   \nThe budget should set forth the costs as follows:\n-Allowable costs associated with staff, services, supplies, meetings, transportation, and other activities relative to achieving outlined goals  \n-Details on any additional funding outside of Community Corrections & Justice Reinvestment Grants being used to support this proposal; including source, amount and purpose of funds.\n\nThe proposed budget should be complete, cost effective, and allowable (i.e. reasonable, allocable, and necessary for project activities). \n\n"]
[]
["Notes:\nDo not change the names of the tabs. You may add additional rows to each section by selecting the button \"Add New Row\" and it will insert a new row. You will not have the capability to delete rows.\n"]
[]
["Budget Category Descriptions:"]
["Summary","Community Corrections Entities: Select the name of the Advisory Board from the drop down\n1006 Entities: Select the name of the county that the program is established in\n\nThis form automatically calculates from the budget detail tabs\n"]
["Project Income vs. User Fees","Project Income: The amount the program budgets from the county Community Corrections Project Income Fund.\nUser Fees: The amount  the program budgets from other user fee accounts. \n"]
["Series 100: Personnel","List each position by title and name of employee (if available) under the proposed grant program. If a position splits its time between multiple grant programs, please list it in the budget for the program where it will spend the majority of the time. Do not list one position in multiple grant program budgets.\n"]
["Series 100: Fringe","Fringe benefits should be based on actual known costs or an approved negotiated rate by a county agency.  Fringe benefits are for the personnel listed in the Series 100: Personnel section. "]
["Series 200: Supplies","Itemize or list all supplies under this grant program including, but not limited to: office supplies, vehicle supplies, program materials, etc. "]
["Series 300: Contractual Services","Itemize or list all services under this grant program including, but not limited to: leasing of equipment, travel/training, professional contracts, etc. Note: Please include provider name and type of service, example: Henry Labs - Drug Testing"]
["Series 400: Capital","Itemize or list all equipment under this grant program including, but not limited to: office equipment, vehicles, monitoring equipment, etc. "]

{"sheet":"IDOC Summary","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[12,0,12,6],[19,0,19,6],[5,1,5,3],[0,0,0,7],[1,0,1,7],[7,1,7,3],[3,1,3,5]]}
["Community Corrections & Justice Reinvestment Grants"]
["CY2026 \nCOUNTY BUDGET SUMMARY"]
[]
["ADVISORY BOARD NAME: ","Select from the Dropdown Options"]
[]
["ENTITY:","Select from the Dropdown Options"]
[]
["AGENCY NAME:"]
[]
[]
[]
[]
["Personnel Summary"]
["Category","Grant","Project Income","User Fees","County General","Other","Total"]
["Salary",{"$f":"Personnel!E12","v":0},{"$f":"Personnel!F12","v":0},{"$f":"Personnel!G12","v":0},{"$f":"Personnel!H12","v":0},{"$f":"Personnel!I12","v":0},{"$f":"Personnel!J12","v":0}]
["Fringe",{"$f":"Fringe!B15","v":0},{"$f":"Fringe!C15","v":0},{"$f":"Fringe!D15","v":0},{"$f":"Fringe!E15","v":0},{"$f":"Fringe!F15","v":0},{"$f":"Fringe!G15","v":0}]
["Subtotal",{"$f":"SUM(B15:B16)","v":0},{"$f":"SUM(C15:C16)","v":0},0,0,0,0]
[]
[]
["Budget Summary"]
["Series","Grant","Project Income","User Fees","County General","Other","Total"]
[100,{"$f":"B17","v":0},{"$f":"SUM(C15:C16)","v":0},{"$f":"SUM(D15:D16)","v":0},{"$f":"SUM(E15:E16)","v":0},{"$f":"SUM(F15:F16)","v":0},{"$f":"SUM(B22:F22)","v":0}]
[200,{"$f":"'Series 200'!B24","v":0},{"$f":"'Series 200'!C24","v":0},{"$f":"'Series 200'!D24","v":0},{"$f":"'Series 200'!E24","v":0},{"$f":"'Series 200'!F24","v":0},{"$f":"'Series 200'!G24","v":0}]
[300,{"$f":"'Series 300'!C30","v":0},{"$f":"'Series 300'!D30","v":0},{"$f":"'Series 300'!E30","v":0},{"$f":"'Series 300'!F30","v":0},{"$f":"'Series 300'!G30","v":0},{"$f":"'Series 300'!H30","v":0}]
[400,{"$f":"'Series 400'!B16","v":0},{"$f":"'Series 400'!C16","v":0},{"$f":"'Series 400'!D16","v":0},{"$f":"'Series 400'!E16","v":0},{"$f":"'Series 400'!F16","v":0},{"$f":"'Series 400'!G16","v":0}]
["Subtotal",{"$f":"SUM(B22:B25)","v":0},{"$f":"SUM(C22:C25)","v":0},0,0,0,{"$f":"SUM(G22:G25)","v":0}]

{"sheet":"Personnel","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[4,0,4,9],[11,0,11,3],[2,0,2,3]]}
[{"$f":"'IDOC Summary'!B4","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B6","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B8","v":0}]
[]
["Series 100: Personnel"]
["Select the cell to trigger the dropdown options. \nFrom the list of options, select the best option that describes what type of position it is.\n *This is for reporting purposes only*","Select the cell to trigger the dropdown options. \nFrom the list of options, select the whether the position is a New (i.e., new request), a current employee, or whether the position is vacant","Select the cell to trigger the dropdown options. \nFrom the list of options, select whether the proposed employee is  full or part time","Type in the Title of the Position","Type in the amount of requested grant funding for this line item","Type in the estimated amount of Project Income used to support this line item\nIf none, enter 0","Type in the amount of user fees used to support this line item\nIf none, enter 0","Type in the amount of county general used to support this line item\nIf none, enter 0","Type in the amount of any other funding sources (federal grants, states grants, local grants, etc.) used to support this line item\nIf none, enter 0"," Gross Salary of the Position:\nNo action of this cell. It auto calculates to a total based on the previous figures\n"]
["Position Category","Employee Status","Full or Part Time","Position / Title Name","Grant","Project Income"," User Fees ","County General","Other","Total \n"]
[]
["Select from the Dropdown Options","Select from the Dropdown Options","Select from the Dropdown Options",null,null,null,null,null,null,{"$f":"SUM(Table26[[#This Row],[Grant]:[Other]])","v":0}]
["Select from the Dropdown Options","Select from the Dropdown Options","Select from the Dropdown Options",null,null,null,null,null,null,{"$f":"SUM(Table26[[#This Row],[Grant]:[Other]])","v":0}]
["Select from the Dropdown Options","Select from the Dropdown Options","Select from the Dropdown Options",null,null,null,null,null,null,{"$f":"SUM(Table26[[#This Row],[Grant]:[Other]])","v":0}]
["Subtotal",null,null,null,{"$f":"SUM(Table26[Grant])","v":0},{"$f":"SUM(Table26[Project Income])","v":0},{"$f":"SUM(Table26[[ User Fees ]])","v":0},{"$f":"SUM(Table26[County General])","v":0},{"$f":"SUM(Table26[Other])","v":0},{"$f":"SUM(Table26[Total \n])","v":0}]

{"sheet":"Fringe","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[4,0,4,6],[2,0,2,3]]}
[{"$f":"'IDOC Summary'!B4","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B6","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B8","v":0}]
[]
["Series 100: Fringe"]
[null,"Type in the amount of requested grant funding for this line item","Type in the estimated amount of Project Income used to support this line item\nIf none, enter 0","Type in the amount of user fees used to support this line item\nIf none, enter 0","Type in the amount of county general used to support this line item\nIf none, enter 0","Type in the amount of any other funding sources (federal grants, states grants, local grants, etc.) used to support this line item\nIf none, enter 0"," Total Line Item Cost:\nNo action of this cell. It auto calculates to a total based on the previous figures\n"]
["Categroy","Grant","Project Income"," User Fees ","County General","Other","Total"]
["WORKER'S COMPENSATION",null,null,null,null,null,{"$f":"SUM(B8:F8)","v":0}]
["OVERTIME",null,null,null,null,null,{"$f":"SUM(B9:F9)","v":0}]
["UNEMPLOYMENT",null,null,null,null,null,0]
["FICA (SOCIAL SECURITY)",null,null,null,null,null,0]
["HEALTH INSURANCE",null,null,null,null,null,0]
["PERF",null,null,null,null,null,0]
["OTHER",null,null,null,null,null,{"$f":"SUM(B14:F14)","v":0}]
["Subtotal",{"$f":"SUM(Table9[Grant])","v":0},{"$f":"SUM(Table9[Project Income])","v":0},{"$f":"SUM(Table9[[ User Fees ]])","v":0},{"$f":"SUM(Table9[County General])","v":0},{"$f":"SUM(Table9[Other])","v":0},{"$f":"SUM(Table9[Total])","v":0}]

{"sheet":"Series 200","index":4,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[4,0,4,6],[2,0,2,3]]}
[{"$f":"'IDOC Summary'!B4","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B6","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B8","v":0}]
[]
["Series 200: Supplies"]
[null,"Type in the amount of requested grant funding for this line item","Type in the estimated amount of Project Income used to support this line item\nIf none, enter 0","Type in the amount of user fees used to support this line item\nIf none, enter 0","Type in the amount of county general used to support this line item\nIf none, enter 0","Type in the amount of any other funding sources (federal grants, states grants, local grants, etc.) used to support this line item\nIf none, enter 0"," Total Line Item Cost:\nNo action of this cell. It auto calculates to a total based on the previous figures\n"]
["Category","Grant","Project Income","User Fees ","County General","Other","Total"]
["GENERAL OFFICE SUPPLIES",null,null,null,null,null,{"$f":"SUM(B8:F8)","v":0}]
["COPIER SUPPLIES",null,null,null,null,null,0]
["CLEANING SUPPLIES",null,null,null,null,null,0]
["FIRST AID",null,null,null,null,null,0]
["WEARING APPAREL (FOR CLIENTS)",null,null,null,null,null,0]
["DRUG TESTING SUPPLIES",null,null,null,null,null,0]
["ASSESSMENTS",null,null,null,null,null,0]
["PROGRAM & EDUCATION MATERIALS",null,null,null,null,null,0]
["INCENTIVES (GIFTCARDS PI ONLY)",null,null,null,null,null,0]
["FOOD (FOR CLIENTS)",null,null,null,null,null,0]
["MOTOR VEHICLE SUPPLIES",null,null,null,null,null,0]
["BUILDING MAINTENANCE SUPPLIES",null,null,null,null,null,0]
["PREVENTATIVE MAINTENANCE SUPPLIES",null,null,null,null,null,0]
["OTHER SUPPLIES (LIST BELOW):"]
["(Type Here)",null,null,null,null,null,{"$f":"SUM(B22:F22)","v":0}]
["(Type Here)",null,null,null,null,null,{"$f":"SUM(B23:F23)","v":0}]
["Subtotal",{"$f":"SUM(B8:B23)","v":0},0,0,0,0,0]

{"sheet":"Series 300","index":5,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,2],[0,0,0,2],[2,0,2,3],[23,1,23,2],[23,3,23,7],[4,0,4,6]]}
[{"$f":"'IDOC Summary'!B4","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B6","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B8","v":0}]
[]
["Series 300: Services"]
[null,"Type in the amount of requested grant funding for this line item","Type in the estimated amount of Project Income used to support this line item\nIf none, enter 0","Type in the amount of user fees used to support this line item\nIf none, enter 0","Type in the amount of county general used to support this line item\nIf none, enter 0","Type in the amount of any other funding sources (federal grants, states grants, local grants, etc.) used to support this line item\nIf none, enter 0"," Total Line Item Cost:\nNo action of this cell. It auto calculates to a total based on the previous figures\n"]
["Category","Grant","Project Income","User Fees","County General","Other","Total"]
["BUILDING LEASE",null,null,null,null,null,{"$f":"SUM(B8:F8)","v":0}]
["BUILDING MAINTENANCE/REPAIRS",null,null,null,null,null,0]
["UTILITIES",null,null,null,null,null,0]
["PEST CONTROL",null,null,null,null,null,0]
["WASTE MANAGEMENT",null,null,null,null,null,0]
["VEHICLE LEASING",null,null,null,null,null,0]
["INSURANCE",null,null,null,null,null,0]
["FOOD & VENDING",null,null,null,null,null,0]
["LAUNDRY",null,null,null,null,null,0]
["POSTAGE",null,null,null,null,null,0]
["COPIER & PRINTING",null,null,null,null,null,0]
["INTERNET",null,null,null,null,null,0]
["TELEPHONE",null,null,null,null,null,0]
["DUES & SUBSCRIPTIONS",null,null,null,null,null,0]
["CONFERENCES",null,null,null,null,null,0]
[]
["PROFESSIONAL  SERVICES CONTRACTS \n",null,null,"Note: Please include provider name and type of service, example: Henry Labs - Drug Testing"]
["Type","Contractor/ Service Provider's Name","Grant","Project Income","User Fees","County General","Other","Total"]
["Select from the Dropdown Options","(Type Here)",null,null,null,null,null,{"$f":"SUM(C26:G26)","v":0}]
["Select from the Dropdown Options","(Type Here)",null,null,null,null,null,{"$f":"SUM(C27:G27)","v":0}]
["Select from the Dropdown Options","(Type Here)",null,null,null,null,null,{"$f":"SUM(C28:G28)","v":0}]
["Select from the Dropdown Options","(Type Here)",null,null,null,null,null,{"$f":"SUM(C29:G29)","v":0}]
["Subtotal",null,{"$f":"SUM(Table6[Grant])+SUM(Table7[Grant])","v":0},{"$f":"SUM(Table6[Project Income])+SUM(Table7[Project Income])","v":0},{"$f":"SUM(Table6[User Fees])+SUM(Table7[User Fees])","v":0},{"$f":"SUM(Table6[County General])+SUM(Table7[County General])","v":0},{"$f":"SUM(Table6[Other])+SUM(Table7[Other])","v":0},{"$f":"SUM(Table6[Total])+SUM(Table7[Total])","v":0}]

{"sheet":"Series 400","index":6,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[4,0,4,6],[2,0,2,3]]}
[{"$f":"'IDOC Summary'!B4","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B6","v":"Select from the Dropdown Options"}]
[{"$f":"'IDOC Summary'!B8","v":0}]
[]
["Series 400: Capital Equipment"]
[null,"Type in the amount of requested grant funding for this line item","Type in the estimated amount of Project Income used to support this line item\nIf none, enter 0","Type in the amount of user fees used to support this line item\nIf none, enter 0","Type in the amount of county general used to support this line item\nIf none, enter 0","Type in the amount of any other funding sources (federal grants, states grants, local grants, etc.) used to support this line item\nIf none, enter 0"," Total Line Item Cost:\nNo action of this cell. It auto calculates to a total based on the previous figures\n"]
["Category","Grant","Project Income","User Fees ","County General","Other","Total"]
["OFFICE EQUIPMENT",null,null,null,null,null,{"$f":"SUM(B8:F8)","v":0}]
["VEHICLES",null,null,null,null,null,{"$f":"SUM(B9:F9)","v":0}]
["DATA PROCESSING EQUIPMENT",null,null,null,null,null,{"$f":"SUM(B10:F10)","v":0}]
["WORK CREW EQUIPMENT",null,null,null,null,null,{"$f":"SUM(B11:F11)","v":0}]
["ELECTRONIC MONITORING EQUIPMENT",null,null,null,null,null,{"$f":"SUM(B12:F12)","v":0}]
["MISC. EQUIPMENT (LIST BELOW):"]
["(Type Here)",null,null,null,null,null,{"$f":"SUM(B14:F14)","v":0}]
["(Type Here)",null,null,null,null,null,{"$f":"SUM(B15:F15)","v":0}]
["Subtotal",{"$f":"SUM(B8:B15)","v":0},0,0,0,0,0]

{"sheet":"List Options","index":7,"n_rows":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
["Advisory Board or County Name","Entity Types","Position Category","Full or Part Time","Status","Contracts"]
["Select from the Dropdown Options","Select from the Dropdown Options","Select from the Dropdown Options","Select from the Dropdown Options","Select from the Dropdown Options","Select from the Dropdown Options"]
["Adams","Alcohol & Drug Program","Administrative or Support","Full","Current Position","Alcohol Monitoring Equipment"]
["Allen","CC Community Supervision","Business or Financial Manager","Part","New Position","Drug Testing Kits"]
["Bartholomew","CC Residential/Work Release","Case Manager",null,"Vacant","Drug Testing Services"]
["Benton","Domestic Violence Court","Certified Probation Officer",null,null,"Facilitator"]
["Blackford","Drug Court","Chief Probation Officer",null,null,"GPS Equipment"]
["Boone","Jail Treatment","Counselor",null,null,"Home Detention Equipment"]
["Brown","Mental Health Court","Court Coordinator",null,null,"Medical Services"]
["Carroll","Pretrial Services","Facilitator",null,null,"Other"]
["Cass","Probation","Field or Surveillance Officer",null,null,"Residential/Work Release Beds"]
["Cass/Pulaski Regional","Prosecutor's Diversion","Grant Director",null,null,"Surveillance or Monitoring Services or Agency"]
["Clark","Re-entry Court","Intake or Screening",null,null,"Training"]
["Clay","Veterans Court","Intern",null,null,"Transportation"]
["Clinton",null,"Legal",null,null,"Treatment Center"]
["Crawford ",null,"Maintenance or Facility"]
["Daviess",null,"Other"]
["Dearborn",null,"Other Executive Staff"]
["Decatur",null,"Pretrial Coordinator"]
["DeKalb",null,"Pretrial Officer"]
["Delaware",null,"Probation Officer Assistant"]
["Dubois",null,"Problem Solving Court Officer"]
["Elkhart",null,"Program or Service Coordinator"]
["Fayette",null,"Residential Correctional Officer"]
["Floyd",null,"Supervisor"]
["Fountain",null,"Team Leader"]
["Franklin"]
["Fulton"]
["Gibson"]
["Grant"]
["Greene"]
["Hamilton"]
["Hancock"]
["Harrison"]
["Hendricks"]
["Henry"]
["Howard"]
["Huntington"]
["Jackson"]
["Jackson/Jennings Regional"]
["Jasper"]
["Jay"]
["Jefferson"]
["Jennings"]
["Johnson"]
["Knox"]
["Kosciusko"]
["LaGrange"]
["Lake"]
["LaPorte"]
["Lawrence"]
["Madison"]
["Marion"]
["Marshall"]
["Martin"]
["Miami"]
["Montgomery"]
["Monroe"]
["Morgan"]
["Newton"]
["Noble"]
["Northeast Regional"]
["Ohio"]
["Orange"]
["Owen"]
["Parke"]
["Perry"]
["Pike"]
["Porter"]
["Posey"]
["Pulaski "]
["Putnam"]
["Randolph"]
["Ripley"]
["Rush"]
["Scott"]
["Shelby"]
["South Central Indiana Community Resources"]
["Southeast Regional"]
["Spencer"]
["St. Joseph"]
["Starke"]
["Steuben"]
["Sullivan"]
["Switzerland"]
["Tippecanoe"]
["Tipton"]
["Union"]
["Vanderburgh"]
["Vermillion"]
["Vigo"]
["Wabash"]
["Wabash Valley Regional"]
["Warren"]
["Warren"]
["Warrick"]
["Washington"]
["Wayne"]
["Wells"]
["West Central Regional"]
["White"]
["Whitley"]