{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Lists","Summary Page","Personnel B.1","Fringe B.2","Travel B.3","Equipment B.4","Office Supplies B.5","Contractual B.6","Other Office Expense B.7","Client Services B.8"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"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":"Lists","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Subrecipients"]
["Arkansas River Valley Area Council, Inc. (ARVAC)"]
["Black River Area Development Corporation (BRAD)"]
["Central Arkansas Development Council (CADC)"]
["Community Action Program for Central Arkansas, Inc (CAPCA)"]
["Crowley's Ridge Development Council, Inc. (CRDC)"]
["Crawford-Sebastian Community Development Council, Inc. (CSCDC)"]
["Community Services Office, Inc. (CSO)"]
["Economic Opportunity Agency of Washington Co. Inc. (EOAWC)"]
["Mississippi County, Arkansas EOC, Inc. (MCAEOC)"]
["Mid-Delta Community Services, Inc. (MDCS)"]
["Northcentral Arkansas Development Council, Inc (NADC)"]
["Office of Human Concern, Inc. (OHC)"]
["Ozark Opportunities, Inc. (OOI)"]
["Pine Bluff-Jefferson County EOC, Inc (PBJCEOC)"]
["Southeast Arkansas Community Action Corporation (SEACAC)"]
["Arkansas Community Action Agencies Association, Inc. (ACAAA)"]
["Neighbor-to-Neighbor"]
["Arkansas Single Parent Scholarship Fund"]
["Watershed Human and Community Dev. Agency, Inc (Watershed)"]

{"sheet":"Summary Page","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,0,23,1],[34,0,34,1],[24,0,24,1],[27,0,27,1],[33,0,33,1],[31,0,31,1],[27,2,27,3],[16,0,16,1],[28,0,28,1],[29,0,29,3],[30,0,30,1],[19,0,19,1],[22,0,22,1],[17,0,17,1],[18,0,18,1],[17,2,18,3],[15,2,16,3],[19,2,20,3],[21,2,22,3],[23,2,24,3],[20,0,20,1],[21,0,21,1],[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[6,2,6,3],[6,0,6,1],[15,0,15,1],[11,0,11,1],[4,1,4,3],[5,1,5,3],[8,0,8,1],[8,2,8,3],[9,0,9,1],[10,0,10,1],[9,2,10,3],[11,2,12,3],[13,2,14,3],[7,0,7,3],[12,0,12,1],[13,0,13,1],[14,0,14,1]]}
["Arkansas Department of Human Services/DCO/OCS"]
["Community Services Block Grant Discretionary Budget"]
["CARES ACT DISCRETIONARY FUNDS"]
["Please enter the requested information into the yellow highlighted cells \non each page and sign the Summary Page below"]
["Subrecipient:"]
["Service Area:"]
["CSBG Discretionary Allocation:"]
["IMPORTANT! This \"Summary Page\" will self-populate as you complete each of the worksheets (B.1 - B.9):"]
["BUDGET CATEGORIES",null,"AMOUNT"]
["B.1 Personnel",null,{"$f":"'Personnel B.1'!F47","v":0}]
[]
["B.2 Fringe Benefits",null,{"$f":"'Fringe B.2'!F31","v":0}]
[]
["B.3 Travel",null,{"$f":"'Travel B.3'!D8","v":0}]
[]
["B.4 Equipment",null,{"$f":"'Equipment B.4'!G29","v":0}]
[]
["B.5 Office Supplies",null,{"$f":"'Office Supplies B.5'!C8","v":0}]
[]
["B.6 Contractual",null,{"$f":"'Contractual B.6'!G13","v":0}]
[]
["B.7 Other Office Expense",null,{"$f":"'Other Office Expense B.7'!F24","v":0}]
[]
["B.8 Client Services",null,{"$f":"'Client Services B.8'!F16","v":0}]
[]
[]
[]
["TOTAL BUDGET*",null,{"$f":"SUM(C10:D23)","v":0}]
["*TOTAL BUDGET\" must equal the \"CSBG DiscretionaryAllocation\" above.",null,"Diff.:",{"$f":"C28-C7","v":0}]
["Subrecipient Approval"]
[]
["Signature of Preparer",null,null,"Date"]
[]
[]
["Signature of Approver",null,null,"Date"]

{"sheet":"Personnel B.1","index":2,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[21,0,21,1],[12,0,12,1],[19,0,19,1],[1,0,1,5],[0,1,0,5],[5,0,5,1],[14,0,14,1],[11,0,11,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[13,0,13,1],[28,0,28,1],[36,0,36,1],[45,0,45,4],[46,0,46,4],[32,0,32,1],[44,0,44,4],[30,0,30,1],[43,0,43,1],[31,0,31,1],[33,0,33,1],[35,0,35,1],[37,0,37,1],[41,0,41,1],[42,0,42,1],[40,0,40,1],[38,0,38,1],[39,0,39,1],[29,0,29,1],[34,0,34,1],[23,0,23,1],[27,0,27,5],[4,0,4,1],[9,0,9,1],[2,0,2,5],[10,0,10,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[16,0,16,1],[20,0,20,1],[22,0,22,1],[26,0,26,4],[24,0,24,1],[25,0,25,1],[3,0,3,1]]}
["Subrecipient:"]
["Personnel"]
["Administrative and Management Staff"]
["Identify Job Title NOT staff names",null,"No. of Months","Annual Salary","% of CSBG Support","Amount Budgeted to CSBG Funds"]
[null,null,null,null,null,{"$f":"((D5/12)*C5)*E5","v":0}]
[null,null,null,null,null,{"$f":"((D6/12)*C6)*E6","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Subtotal Section 1 (CSBG ONLY):",null,null,null,null,{"$f":"SUM(F5:F26)","v":0}]
[" Program Staff/Direct Client Support Staff"]
["Identify Job Title NOT staff names",null,"No. of Months","Annual Salary","% of CSBG Support","Amount Budgeted to CSBG Funds"]
[null,null,null,null,null,{"$f":"((D30/12)*C30)*E30","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Subtotal Section 2 (CSBG ONLY):",null,null,null,null,{"$f":"SUM(F30:F44)","v":0}]
["Total Section 1 and 2:",null,null,null,null,{"$f":"SUM(F27+F45)","v":0}]
["Total Personnel Tab",null,null,null,null,{"$f":"F46","v":0}]

{"sheet":"Fringe B.2","index":3,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,5],[11,0,13,0],[25,0,27,0],[15,0,15,5],[3,0,3,4],[1,0,1,5],[2,0,2,5],[14,0,14,4],[9,0,9,4],[10,0,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[4,0,4,4],[7,0,7,4],[8,0,8,4],[5,0,5,4],[6,0,6,4],[27,1,27,4],[28,0,28,4],[29,0,29,4],[16,0,16,5],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[30,0,30,4],[25,1,25,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[26,1,26,4]]}
["Subrecipient:",{"$f":"'Summary Page'!B5","v":0}]
["Fringe Benefits"]
["Section 1: Administrative & Management Staff"]
["Items",null,null,null,null,"Amount"]
["F.I.C.A"]
["Unemployment"]
["Workman's Comp. Insurance"]
["Health Insurance"]
["Dental Insurance"]
["Life Insurance"]
["Retirement Contribution"]
["Others (List):"]
[]
[]
["Subtotal Section 1 (CSBG ONLY):",null,null,null,null,{"$f":"SUM(F5:F14)","v":0}]
[]
["Section 2: Program Staff/Direct Client Support Staff"]
["Items",null,null,null,null,"Amount"]
["F.I.C.A"]
["Unemployment"]
["Workman's Comp. Insurance"]
["Health Insurance"]
["Dental Insurance"]
["Life Insurance"]
["Retirement Contribution"]
["Others (List):"]
[]
[]
["Subtotal Section 2 (CSBG ONLY):",null,null,null,null,{"$f":"SUM(F19:F28)","v":0}]
["Total Section 1 and 2 (CSBG ONLY):",null,null,null,null,{"$f":"SUM(F15+F29)","v":0}]
["Total Fringe Benefits Tab",null,null,null,null,{"$f":"F30","v":0}]

{"sheet":"Travel B.3","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,3],[6,0,6,2],[7,0,7,2],[5,0,5,2],[4,0,4,2],[1,0,1,3],[2,0,3,0]]}
["Subrecipient:",{"$f":"'Summary Page'!B5","v":0}]
["Travel"]
["Local Travel   (*Rate cannot be higher than the State rate)","Miles","x State Rate*","Amount"]
[null,null,0.42,{"$f":"B4*C4","v":0}]
["Per Diem"]
["Non-Local Travel (out-of-state)"]
[]
["Total Travel Tab",null,null,{"$f":"SUM(D4:D7)","v":0}]

{"sheet":"Equipment B.4","index":5,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,0,27,5],[28,0,28,5],[0,1,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[5,0,5,6],[16,0,16,6]]}
["Subrecipient:",{"$f":"'Summary Page'!B5","v":0}]
["Equipment (Purchases and Leases)"]
["Note: Subrecipient is also reminded to follow procurement policies/procedures. "]
[]
["Equipment Description","No. of Units","Brand & Model","Unit Cost","Total Cost","% Budgeted to CSBG","Amount(s) Budgeted to CSBG"]
["Purchases"]
[null,1,null,null,{"$f":"B7*D7","v":0},null,{"$f":"E7*F7","v":0}]
[null,null,null,null,0,null,{"$f":"E8*F8","v":0}]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
["Leases"]
[null,1,null,null,{"$f":"B18*D18","v":0},null,{"$f":"E18*F18","v":0}]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,{"$f":"B27*D27","v":0},null,{"$f":"E27*F27","v":0}]
["Subtotal (CSBG):",null,null,null,null,null,{"$f":"SUM(G7:G16,G18:G27)","v":0}]
["Total Equipment Tab",null,null,null,null,null,{"$f":"SUM(G28:G28)","v":0}]

{"sheet":"Office Supplies B.5","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,0,2,1],[3,0,3,1],[1,0,1,2],[7,0,7,1],[4,0,4,1],[5,0,5,1]]}
["Subrecipient:",{"$f":"'Summary Page'!B5","v":0}]
["Office Supplies"]
["Supplies"]
[]
[]
[]
[]
["Total Supplies Tab",null,{"$f":"SUM(C3:C7)","v":0}]

{"sheet":"Contractual B.6","index":7,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,0,3,3],[4,0,4,3],[11,0,11,5],[12,0,12,5],[0,0,0,1],[0,2,0,6],[6,0,10,1],[7,2,7,3],[8,2,8,3],[9,2,9,3],[5,0,5,3],[6,2,6,3],[10,2,10,3],[1,0,1,6],[2,0,2,3]]}
["Subrecipient:",null,{"$f":"'Summary Page'!B5","v":0}]
["Contractual"]
["CSBG Budget Items (Categories)",null,null,null,"Total Cost","% Budgeted to CSBG","Amount Budgeted to CSBG"]
[null,null,null,null,null,null,{"$f":"E4*F4","v":0}]
[null,null,null,null,null,null,{"$f":"E5*F5","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Subtotal (CSBG):",null,null,null,null,null,{"$f":"SUM(G4:G11)","v":0}]
["Total Contractual Tab",null,null,null,null,null,{"$f":"SUM(G12:G12)","v":0}]

{"sheet":"Other Office Expense B.7","index":8,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,0,21,2],[20,0,20,2],[23,0,23,4],[22,0,22,4],[16,0,16,2],[17,0,17,2],[19,0,19,2],[18,0,18,2],[0,0,0,1],[6,0,6,2],[12,0,12,2],[0,2,0,5],[1,0,1,5],[3,0,3,2],[4,0,4,2],[10,0,10,2],[11,0,11,2],[9,0,9,2],[7,0,7,2],[13,0,13,2],[14,0,14,2],[5,0,5,2],[15,0,15,2],[2,0,2,2],[8,0,8,2]]}
["Subrecipient:",null,{"$f":"'Summary Page'!B5","v":0}]
["Other Office Expense"]
["Other Items (such as copying, rent, utilities, phone, insurance, etc. see budget instructions p.4 Other Office Expense)  Itemize below:",null,null,"Total Costs","% Budgeted to CSBG","Amount Budgeted to CSBG"]
[null,null,null,null,null,{"$f":"D4*E4","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Subtotal for Other Items (CSBG):",null,null,null,null,{"$f":"SUM(F4:F22)","v":0}]
["Total Other Tab",null,null,null,null,{"$f":"F23","v":0}]

{"sheet":"Client Services B.8","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,4],[6,0,6,4],[7,0,7,2],[8,0,8,2],[9,0,9,2],[13,0,13,2],[14,0,14,4],[10,0,10,2],[11,0,11,2],[12,0,12,2],[0,0,0,1],[0,2,0,5],[1,0,1,5],[2,0,2,2],[3,0,5,2],[3,4,4,5]]}
["Subrecipient:",null,{"$f":"'Summary Page'!B5","v":0}]
["Client Services (TOP/TSS)"]
[null,null,null,"Total Costs","% Budgeted to CSBG","Amount Budgeted to CSBG"]
["Direct Services to Case Management Clients to Transition into Self-Sufficiency (TSS) or Transistion Out of Poverty (TOP). Subrecipients are encouraged to allocate a reasonable amount of CSBG funds to assist clients transitioning into self-sufficiency. (TSS/TOP allocation % will be auto-populated above the TSS/TOP allocation entered in the cell to the right).",null,null,{"$f":"'Summary Page'!C7","v":0}]
[null,null,null,{"$f":"D6/D4","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,0,{"$f":"D6*E6","v":0}]
["Subtotal for Direct Services TSS & TOP (CSBG):",null,null,null,null,{"$f":"F6","v":0}]
["Emergency Assistance/Direct Services to Clients not working towards Self-Sufficiency or TOP \n(Itemize Assistance/Services below)",null,null,"Total Costs","% Budgeted to CSBG","Amount Budgeted to CSBG"]
[null,null,null,null,0,{"$f":"D9*E9","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Subtotal for Emergency Assistance/Direct Services to non-TOP (CSBG):",null,null,null,null,{"$f":"SUM(F9:F14)","v":0}]
["Total Client Services Tab",null,null,null,null,{"$f":"F7+F15","v":0}]