{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Directions","Budget Overview ","16700 Funding","Actual Spent","Travel Information","Category Description","Admin Code References","For DHS Use","Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Directions","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[1,"Select \"Enable Content.\""]
[2,"Enter data into the \"Budget Overview\" tab to account for…. You can only input data into the yellow highlighted cells. The yellow highlight will automatically be removed once data is entered."]
[3,"For each invoice paid, enter data into the \"Actual Spent\" tab. Be sure to fill out each column for each invoice and select the corresponding category from the dropdown in column E."]
[4,"Feel free to enter parameters and definitions into the \"Category Description\" tab to help you define which items belong in which category of spending."]
[5,"The \"Admin Code Refereces\" tab is included to assist you with quickly finding relevant administrative codes. Click on the link in column A to open the webpage for each referenced section of code."]

{"sheet":"Budget Overview ","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["State Fiscal Year 2024: 7/1/2025-6/30/2026"]
["RTAC ","Region 2: North Central Wisconsin","Fiscal Agent (business)"]
["RTAC Chair ",null,"Fiscal Agent Contact Name"]
[null,null,"Fiscal Agent Email "]
[]
[null,"GPR Funding Total ",29247]
[null,"16700 Funding Total ",800]
[null,"Total Granted",{"$f":"SUM(C6:C7)","v":30047}]
[null,"Amount Encumbered",{"$f":"C8-C24","v":30047}]
[]
["Category ","Budget Estimate per Category ","Actual Spent per Category ","Amount Remaining per Category","Project Code\n(For RTAC use if desired)"]
["Injury Prevention ",4500,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Injury Prevention\", 'Actual Spent'!D3:D200)","v":0},{"$f":"B12-C12","v":4500}]
["Prehospital ",4500,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Prehospital\", 'Actual Spent'!D3:D200)","v":0},{"$f":"B13-C13","v":4500}]
["Hospital",4500,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Hospital\", 'Actual Spent'!D3:D200)","v":0},4500]
["Joint Prehospital/Hospital",5000,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Joint Prehospital/Hospital\", 'Actual Spent'!D3:D200)","v":0},5000]
["Regional PI/Data Management",1000,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Regional PI/Data Management\", 'Actual Spent'!D3:D200)","v":0},1000]
["Travel ",2500,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Travel\", 'Actual Spent'!D3:D200)","v":0},2500]
["RTAC Coordinator Support ",2000,{"$f":"SUMIF('Actual Spent'!E3:E200, \"RTAC Coordinator Support\", 'Actual Spent'!D3:D200)","v":0},2000]
["Supplies",572.29999999999995,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Supplies\", 'Actual Spent'!D3:D200)","v":0},572.29999999999995]
["Operating Costs",1750,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Operating Costs\", 'Actual Spent'!D3:D200)","v":0},1750]
["Fiscal Agent Fees",2924.7,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Fiscal Agent Fees\", 'Actual Spent'!D3:D200)","v":0},2924.7]
["Other",0,{"$f":"SUMIF('Actual Spent'!E3:E200, \"Other\", 'Actual Spent'!D3:D200)","v":0},0]
["16700 Education Courses",800,{"$f":"SUMIF('Actual Spent'!E3:E201, \"16700 Education Courses\", 'Actual Spent'!D3:D201)","v":0},{"$f":"B23-C23","v":800}]
["Total ",{"$f":"SUM(B12:B23)","v":30047},{"$f":"SUM(C12:C22)","v":0},{"$f":"SUM(D12:D23)","v":30047}]

{"sheet":"16700 Funding","index":2,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Course","Region 2 Seats","per seat","Region 2 Total ","Participant 1","Participant 2"]
["TOPIC/Rural TOPIC course from STN",2,400,{"$f":"C2*B2","v":800},"Lynn Gehrman ","Rachel Milkey"]
[null,null,null,{"$f":"SUM(D2:D2)","v":800}]

{"sheet":"Actual Spent","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Actual Spent"]
["Item Description ","Invoice Number","Purchase Date","Total ","Category ",null,null,"Row Labels","Sum of Total "]
[null,null,null,null,null,null,null,"16700 Education Courses",13]
[null,null,null,null,null,null,null,"Bleeding Control",12]
[null,null,null,null,null,null,null,"Fiscal Agent Fees",11]
[null,null,null,null,null,null,null,"Hospital",3]
[null,null,null,null,null,null,null,"Injury Prevention",1]
[null,null,null,null,null,null,null,"Joint Prehospital/Hospital",4]
[null,null,null,null,null,null,null,"Operating Costs",10]
[null,null,null,null,null,null,null,"Other",14]
[null,null,null,null,null,null,null,"Prehospital",2]
[null,null,null,null,null,null,null,"Regional PI/Data Management",5]
[null,null,null,null,null,null,null,"RTAC Coordinator Support",8]
[null,null,null,null,null,null,null,"Supplies",9]
[null,null,null,null,null,null,null,"Travel",7]
[null,null,null,null,null,null,null,"Grand Total",99]

{"sheet":"Travel Information","index":4,"n_rows":3,"n_cols":22,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,18,1,20],[0,0,0,6],[1,0,1,5],[1,7,1,10],[1,12,1,14],[1,15,1,16]]}
["*does not include no overnight travel for RTAC coordinator"]
["Details",null,null,null,null,null,"Conference Info","Accomodation Information ",null,null,null,null,"Flying Only",null,null,"Driving Only",null,null,"Justification/Approvals",null,null,"Other"]
["Traveler","Conference/Event (link)","City ","State","Travel date","Return travel date","Registration cost","# nights proposed","Nightly hotel rate","Is this at/under rate high-cost city threshold?","Is this the organized/negotiated conference hotel rate for this conference? ","Mode of transport?","Est. flight cost?","Parking costs","ground transport (taxi/uber) costs ","Est. Mileage ","Mileage cost ($0.51/mile)","Other proposed costs?","1-2 sentences justification ","RTAC leadership approval ","OPEHC Approval ","Other Description"]

{"sheet":"Category Description","index":5,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["RTAC Budget Categories "]
["Categories ","Description ","RTAC Specific Definitions and Justifications ",null,null,null,null,"Lists"]
["Injury Prevention","Equipment, materials, or training related to injury prevention specifically","Enter your own items here if desired",null,null,null,null,"Yes","Driving"]
["Prehospital","Courses, education, or supplies provided to pre-hospital providers","Enter your own items here if desired",null,null,null,null,"No","Flying"]
["Hospital","Courses, education, or supplies provided to hospital providers","Enter your own items here if desired",null,null,null,null,null,"Other"]
["Joint Prehospital/Hospital","Other courses, education, or supplies items that do not fit nicely into pre-hospital or hospital ","Enter your own items here if desired"]
["Regional PI/Data Management","Costs assocaited with regional or Data evaluation (not courses)","Enter your own items here if desired"]
["Travel","Travel for coordinator, includes mileage and lodging","Enter your own items here if desired"]
["RTAC Coordinator Support","education/conference fees for coordiantor only ","Enter your own items here if desired"]
["Supplies","Supplies for meeting or trainings (pens, printed materials, etc)","Enter your own items here if desired"]
["Operating Costs","Storage lockers, website fees, website updates","Enter your own items here if desired"]
["Fiscal Agent Fees","Selected related to DHS 118.06(3)(f)","Enter your own items here if desired"]
["Bleeding Control","Items related to bleeding control or STB, can include equipment, education, etc"]
["16700 Education Courses","Education offered through the additional 16700 funding ","List specific course "]
["Other","Things that don’t fit anywhere else","Enter your own items here if desired"]

{"sheet":"Admin Code References","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["DHS 118 Language Related to RTACs"]
["Reference ","Language "]
["DHS 118.06(1)","Purpose. The purpose of a regional trauma advisory council is to develop, implement, monitor and improve the regional trauma system."]
["DHS 118.06(2)","Participation in RTAC activities. A regional trauma advisory council may include facilities or organizations located in a neighboring state that provide trauma care to Wisconsin residents."]
["DHS 118.06(3)(b)1.","Establish an executive council "]
["DHS 118.06(3)(c)1.","Select a coordinating facility. "]
["DHS 118.06(3)(d)1.","Select a Wisconsin fiscal agent and submit the name of the fiscal agent to the department for review and approval pursuant to s. DHS 118.04 (2) (b) 4."]
["DHS 118.06(3)(f)","Transmit all pertinent materials to all regional trauma advisory council members in a timely manner."]
["DHS 118.06(3)(g)"," Develop a format for meetings, agendas and minutes, and provide the department with all RTAC meeting times, agendas and minutes."]
["DHS 118.06(3)(i)","Analyze local and regional trauma registry data collected under s. DHS 118.09."]
["DHS 118.06(3)(j)","Create a local and regional performance improvement process that is consistent with that specified in s. DHS 118.10."]
["DHS 118.06(3)(k)","Develop and implement injury prevention and education strategies based on performance improvement findings."]

{"sheet":"For DHS Use","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["RTAC","Category","Actual Spent per Category"]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$12","v":"Injury Prevention "},{"$f":"'Budget Overview '!$C$12","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$13","v":"Prehospital "},{"$f":"'Budget Overview '!$C$13","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$14","v":"Hospital"},{"$f":"'Budget Overview '!$C$14","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$15","v":"Joint Prehospital/Hospital"},{"$f":"'Budget Overview '!$C$15","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$16","v":"Regional PI/Data Management"},{"$f":"'Budget Overview '!$C$16","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$17","v":"Travel "},{"$f":"'Budget Overview '!$C$17","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$18","v":"RTAC Coordinator Support "},{"$f":"'Budget Overview '!$C$18","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$19","v":"Supplies"},{"$f":"'Budget Overview '!$C$19","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$20","v":"Operating Costs"},{"$f":"'Budget Overview '!$C$20","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$21","v":"Fiscal Agent Fees"},{"$f":"'Budget Overview '!$C$21","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},"16700 Education Courses",{"$f":"'Budget Overview '!C23","v":0}]
[{"$f":"'Budget Overview '!$B$2","v":"Region 2: North Central Wisconsin"},{"$f":"'Budget Overview '!$A$22","v":"Other"},{"$f":"'Budget Overview '!$C$22","v":0}]

{"sheet":"Sheet1","index":8,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["Injury Prevention"]
["Prehospital"]
["Hospital"]
["Joint Prehospital/Hospital"]
["Regional PI/Data Management"]
["Travel"]
["RTAC Coordinator Support"]
["Supplies"]
["Operating Costs"]
["Fiscal Agent Fees"]
["Other"]