{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["2023","2024","2025","Narrative","PersonnelDetail","ExpenseDetail","ContractDetail","AdminDetail"],"read":"whole","date_system":"1900"}

{"sheet":"2023","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"merged":[[3,0,4,0],[3,1,4,3],[14,1,14,3]]}
["Detailed _______________________Program Budget",null,"Year",2023]
[]
["Please disclose how the funds requested and other funds are proposed to be used for the project.   Note:  This information can be provided in the application."]
[null,"Total Program Revenue Budget"]
[]
["Revenues:","Opioid Abatement funds","Other Funding Sources","Total"]
["Randolph County Opioid Abatement Funding"]
[]
[]
[]
[]
[]
["Total Revenues:"]
[]
[null,"Total Program Expense Budget"]
["Expenses","Opioid Abatement Funds","Other Funding Sources ","Total"]
["Salaries and Benefits:"]
[]
[]
[]
["Operating Expenses:"]
{"$rows_empty":11}
["Contracted Services:"]
[]
[]
[]
[]
["Capital"]
["Administrative/Indirect cost  (no more than 5%)"]
[]
["Total Expenses"]

{"sheet":"2024","index":1,"n_rows":41,"n_cols":4,"rows_kept":41,"merged":[[3,0,4,0],[3,1,4,3],[14,1,14,3]]}
["Detailed _______________________Program Budget",null,"Year",2024]
[]
["Please disclose how the funds requested and other funds are proposed to be used for the project.   Note:  This information can be provided in the application."]
[null,"Total Program Revenue Budget"]
[]
["Revenues:","Opioid Abatement funds","Other Funding Sources","Total"]
["Randolph County Opioid Abatement Funding"]
[]
[]
[]
[]
[]
["Total Revenues:"]
[]
[null,"Total Program Expense Budget"]
["Expenses","Opioid Abatement Funds","Other Funding Sources ","Total"]
["Salaries and Benefits:"]
[]
[]
[]
["Operating Expenses:"]
{"$rows_empty":11}
["Contracted Services:"]
[]
[]
[]
[]
["Capital"]
["Administrative/Indirect cost  (no more than 5%)"]
[]
["Total Expenses"]

{"sheet":"2025","index":2,"n_rows":41,"n_cols":4,"rows_kept":41,"merged":[[3,0,4,0],[3,1,4,3],[14,1,14,3]]}
["Detailed _______________________Program Budget",null,"Year",2025]
[]
["Please disclose how the funds requested and other funds are proposed to be used for the project.   Note:  This information can be provided in the application."]
[null,"Total Program Revenue Budget"]
[]
["Revenues:","Opioid Abatement funds","Other Funding Sources","Total"]
["Randolph County Opioid Abatement Funding"]
[]
[]
[]
[]
[]
["Total Revenues:"]
[]
[null,"Total Program Expense Budget"]
["Expenses","Opioid Abatement Funds","Other Funding Sources ","Total"]
["Salaries and Benefits:"]
[]
[]
[]
["Operating Expenses:"]
{"$rows_empty":11}
["Contracted Services:"]
[]
[]
[]
[]
["Capital"]
["Administrative/Indirect cost  (no more than 5%)"]
[]
["Total Expenses"]

{"sheet":"Narrative","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"merged":[[7,0,7,4],[10,0,10,4],[13,0,13,4],[16,0,16,4],[19,0,19,4]]}
["Opioid Abatement Strategies RFP",null,null,"Budget Narrative"]
["Agency"]
["Proposed Program",null,null,"Year"]
[]
[]
[]
["Personnel and Fringe Benefits"]
[]
[]
["Operating Costs"]
[]
[]
["Contracted Services"]
[]
[]
["Administrative Costs / Indirect costs"]
[]
[]
["Other"]

{"sheet":"PersonnelDetail","index":4,"n_rows":30,"n_cols":12,"rows_kept":30}
["Personnel Costs"]
[]
[]
["Position","Employee Name","Hourly Pay \nRate","Annual Salary","% of Time on Program","Program Salary Expense",null,"FICA taxes","Health Insurance","Retirement","Other","Total Fringe Benefits"]
["example",null,null,{"v":25000,"d":"$25,000"},{"v":0.95,"d":"95%"},{"$f":"D5*E5","v":{"v":23750,"d":"$23,750"}},null,{"$f":"F5*0.0765","v":{"v":1816.875,"d":"$1,817"}},2000,2000,null,{"$f":"SUM(H5:K5)","v":{"v":5816.875,"d":"$5,817"}}]
[{"$nulls":5},{"$f":"D6*E6","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$nulls":3},{"$f":"SUM(H6:K6)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"$f":"SUM(H7:K7)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":5},{"$f":"SUM(F6:F29)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H6:H29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I6:I29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(J6:J29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(K6:K29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(L6:L29)","v":{"v":0,"d":"$0"}}]

{"sheet":"ExpenseDetail","index":5,"n_rows":31,"n_cols":8,"rows_kept":31}
["Operating Expenses"]
[]
[]
[{"$nulls":5},"Total",null,"Justification"]
[]
[null,"example",100,null,null,{"$f":"SUM(C6:E6)","v":{"v":100,"d":"$100"}}]
[]
["Operating costs"]
[{"$nulls":5},{"$f":"SUM(C9:E9)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[null,null,{"$f":"SUM(C8:C30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D8:D30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E8:E30)","v":{"v":0,"d":"$0"}},{"$f":"D31*0.0765","v":{"v":0,"d":"$0"}}]

{"sheet":"ContractDetail","index":6,"n_rows":31,"n_cols":8,"rows_kept":31}
["Contracted Services"]
[]
[]
[{"$nulls":5},"Total",null,"Justification"]
[]
[null,"example",100,null,null,{"$f":"SUM(C6:E6)","v":{"v":100,"d":"$100"}}]
[]
["Contracted Services"]
[{"$nulls":5},{"$f":"SUM(C9:E9)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"}]
[null,null,{"$f":"SUM(C8:C30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D8:D30)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E8:E30)","v":{"v":0,"d":"$0"}},{"$f":"D31*0.0765","v":{"v":0,"d":"$0"}}]

{"sheet":"AdminDetail","index":7,"n_rows":30,"n_cols":9,"rows_kept":30}
["Administrative Costs"]
["Limited to 5% of total grant"]
[]
[{"$nulls":6},"Total ",null,"Justification"]
[null,"example",null,100,null,null,{"$f":"SUM(C5:F5)","v":{"v":100,"d":"$100"}}]
[]
["Administrative"]
[{"$nulls":6},{"$f":"SUM(C8:F8)","v":{"v":0,"d":"$0"}}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[{"$nulls":6},{"v":0,"d":"$0"}]
[]
[]
["Indirect cost",{"$nulls":5},{"v":0,"d":"$0"},null,"Provide calculation"]
[]
[null,null,{"$f":"SUM(C7:C29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D7:D29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E7:E29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F7:F29)","v":{"v":0,"d":"$0"}},{"$f":"E30*0.0765","v":{"v":0,"d":"$0"}}]