{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Getting started","Incident costs","Investigation costs","Worker Replacement Costs","Productivity costs","Vehicle and Related Damage Cost","Single Incident Costs","Annual Incident Costs"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Getting started","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"merged":[[15,2,15,4],[16,2,26,7]]}
[null,null,"Road Traffic Crash Cost Calculator"]
[]
[]
[]
["The Cost Calculator is easy to use and does not require you to spend hours collecting data."]
[" It is an effective, efficient way to estimate the true costs of the most common type(s) of Motor Vehicle Crashes (MVCs) experienced by your workers who drive."]
[1,"Choose the most common type of MVC experienced by your workers (e.g., rear enders; backing-up incidents)."]
[2,"Select one single crash of this type."]
[3,"Use the calculator to estimate costs for that one crash and then all of the crash of that type within your organization within a year."]
[4,"Provide estimated costs for each item if you don’t have exact data."]
[5,"If a section in the calculator is not relevant to your situation, move on to the next."]
[6,"All data input to this calculator is confidential. Print a summary report of your calculations. Once you leave the calculator, all data is lost."]
[]
[]
[]
[null,"Company Name:"]
[null,"Description of crash:"]
[null,"(including injury and/or vehicle damage)"]
{"$rows_empty":10}
[null,"How to use the calculator:"]
[1,"Fill the 'blue' cells in the different tabs"]
[2,"Rate per hour: the costs to the organisation of the staff member involved (salary, benefits etc)"]

{"sheet":"Incident costs","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[10,2,13,3],[14,2,14,3]]}
[]
[]
[]
[]
[]
[]
[null,"Step 1: Incident Costs"]
[null,null,"Time hrs","Rate per hour","Costs",null,"Explanation"]
[null,"Lost productivity of affected worker(s) in the vehicle (for MVCs that do not result in time off work due to injury)",8,100,{"$f":"C9*D9","v":{"v":800,"d":"$800.00"}},null,"Costs of lost productivity, for example: salary costs from when the accident occurs until working again, time that it takes to complete forms at the accident spot, being checked by  first aid attendant, attending medical facilities for a check"]
[null,"Lost productivity of other worker(s)",null,null,{"$f":"C10*D10","v":0},null,"Cost to consider: salary costs of person remaining with or visiting injured person at medical centre, salary cost to visit incident site, salary cost to re-schedule day's work, time to arrange vehicle to be towed from incident site"]
[null,"Cost of first aid supplies and equipment used",null,null,"$  "]
[null,"Cost of ambulance or taxi",null,null,"$  "]
[null,"Cost of towing, impoundment and /or inspection fees",null,null,"$  "]
[null,"Other Costs:  ",null,null,"$  "]
[null,null,"Subtotal",null,{"$f":"SUM(E9:E14)","v":{"v":800,"d":"$800.00"}}]

{"sheet":"Investigation costs","index":2,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[8,2,8,4],[15,2,15,4],[18,2,18,3],[19,2,19,3]]}
[]
[]
[]
[]
[]
[]
[null,"Step 2: Investigation Costs"]
[null,null,"Time hrs","Rate per hour","Costs",null,"Explanation"]
[null,"Time spent to complete an crash report for your organisation"]
[null,"By the manager",null,null,{"$f":"C10*D10","v":0}]
[null,"By the involved worker(s)",null,null,0]
[null,"Time to complete related paperwork for your organisation",null,null,0,null,"Costs to consider: time to complete organisation records, crash report forms, pay roll records, organisation report forms"]
[null,"Time to follow up with police / insurer",null,null,0]
[null,"If worker is injured, time to complete related paperwork",null,null,0,null,"Costs to consider time to complete insurance reports, police reports"]
[null,"For a serious crash involving an injured worker, time taken to report crash",null,null,0,null,"Costs to consider: time taken to report incident to Health and Safety Council "]
[null,"Time spent to analyse the crash"]
[null,"By the crash investigation manager / team",null,null,0,null,"Costs to consider: time taken to interview the staff involved in the analysis, time to write crash analysis report"]
[null,"Follow-up meetings to discuss the crash",null,null,0,null,"Costs to consider: time taken by the staff involved in the crash to assist in the investigation"]
[null,"Other Costs:  ",null,null,{"$f":"C19*D19","v":0}]
[null,null,"Subtotal",null,{"$f":"SUM(E10:E19)","v":0}]

{"sheet":"Worker Replacement Costs","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[12,2,13,3],[14,2,14,3]]}
[]
[]
[]
[]
[]
[]
[null,"Step 3: Worker Replacement Costs"]
[null,null,"Time hrs","Rate per hour","Costs",null,"Explanation"]
[null,"Time to hire or relocate replacement worker",null,null,{"$f":"C9*D9","v":0},null,"Costs to consider: time to complete recruitment / selection / relocation process"]
[null,"Relocation or rescheduling of another worker",null,null,{"$f":"C10*D10","v":0},null,"Costs to consider: overtime costs and / or difference in pay, lost productivity from where relocated worker was removed"]
[null,"Trainer time for new or relocated worker",null,null,0,null,"Costs to consider: time to train new or relocated worker, time for added supervision, lost productivity of person required to train and supervise"]
[null,"Trainee time for new or relocated worker",null,null,0,null,"Costs to consider: time for training, reduced productivity for new or relocated worker"]
[null,"Cost to hire a replacement worker",{"$nulls":4},"Costs to consider: costs for advertisement, costs for agency if temporary worker is used"]
[null,"Other costs:  "]
[null,null,"Subtotal",null,{"$f":"SUM(E9:E14)","v":0}]

{"sheet":"Productivity costs","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"merged":[[11,2,11,3],[12,2,12,3]]}
[]
[]
[]
[]
[]
[]
[null,"Step 4: Productivity Costs"]
[null,null,"Time hrs","Rate per hour","Costs",null,"Explanation"]
[null,"Lost productivity (work time) due to disruption (delays, waiting to resume, etc.)",12,100,{"$f":"C9*D9","v":{"v":1200,"d":"$1,200.00"}},null,"Costs to consider: reduced productivity due to anxiety and stress felt by co-workers, costs of lost productivity on day of the crash (ie. Programme disruption), costs of lost production during investigation"]
[null,"Time spent managing the injury claim",null,null,{"$f":"C10*D10","v":0},null,"Costs to consider: time to contact worker to coordinate return to work activities, time to update co-workers on progress of injured worker, time to update workers family, time to update police, time to update Human Resources"]
[null,"Reduced productivity of injured worker after they return to work",null,null,0,null,"Costs to consider: time to get 'up to speed' on work (reintegration), worker might not be able to carry full workload, time to follow up on medical appointments"]
[null,"Other costs (e.g., medical costs not covered by insurance): ",null,null,{"v":50000,"d":"$50,000.00"}]
[null,null,"Subtotal",null,{"$f":"SUM(E9:E12)","v":{"v":51200,"d":"$51,200.00"}}]

{"sheet":"Vehicle and Related Damage Cost","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[22,2,22,3]]}
[]
[]
[]
[]
[]
[]
[null,"Step 5: Vehicle and Related Damage Costs"]
[null,null,"Time hrs","Rate per hour","Costs",null,"Explanation"]
[null,"Time to assess damage",4,80,{"$f":"C9*D9","v":{"v":320,"d":"$320.00"}}]
[null,"Time to replace or repair vehicle",null,null,{"$f":"C10*D10","v":0},null,"Costs to consider: Labour costs for repairs, time spent obtaining a replacement vehicle"]
[null,"Time to coordinate repair work",null,null,0,null,"Costs to consider: time spent obtaining quotes from repair facilities, time to coordinate repair process"]
[null,"On-board equipment replacement, clean-up, salvage time",null,null,0]
[null,"Cost of outside contractors and materials for clean-up",null,null,{"v":100,"d":"$100.00"}]
[null,"Cost to dispose of damaged equipment/load",null,null,{"v":12,"d":"$12.00"}]
[null,"Cost of replacement parts or equipment",null,null,{"v":12000,"d":"$12,000.00"}]
[null,"Cost of damaged or lost load or cargo",null,null," $  "]
[null,"Cost of insurance deductible associated with damaged/lost cargo",null,null," $  "]
[null,"Cost of other property damage (e.g., building structure, support beams)",null,null," $  "]
[null,"Loss due to reduction in vehicle resale value",null,null," $  "]
[null,"Cost of replacement vehicle (new or temporary replacement)",null,null," $  "]
[null,"Cost of vehicle insurance deductible",null,null," $  "]
[null,"Other costs:  ",null,null," $  "]
[null,null,"Subtotal",null,{"$f":"SUM(E9:E22)","v":{"v":12432,"d":"$12,432.00"}}]

{"sheet":"Single Incident Costs","index":6,"n_rows":23,"n_cols":7,"rows_kept":23}
[]
[]
[]
[]
[]
[null,"Single Crash  Costs"]
[]
[null,"Crash Costs",null,null,{"$f":"'Incident costs'!E15","v":{"v":800,"d":"$800.00"}}]
[null,"Investigation Costs",null,null,{"$f":"'Investigation costs'!E20","v":0}]
[null,"Replacement Costs",null,null,{"$f":"'Worker Replacement Costs'!E15","v":0}]
[null,"Productivity Costs",null,null,{"$f":"'Productivity costs'!E13","v":{"v":51200,"d":"$51,200.00"}}]
[null,"Vehicle and Related Damage Costs",null,null,{"$f":"'Vehicle and Related Damage Cost'!E23","v":{"v":12432,"d":"$12,432.00"}}]
[null,"Total",null,null,{"$f":"SUM(E8:E12)","v":{"v":64432,"d":"$64,432.00"}}]
[]
[]
[null,"How will this cost impact the organization?"]
[null,"Total cost of the incident:",null,null,{"$f":"E13","v":{"v":64432,"d":"$64,432.00"}}]
[null,"Potential Impacts (check all that apply):","Y","N",null,null,"What is the impact of the cost of this incident on the organisation? Is there enough funding to cover  the costs"]
[null,"Programs reduced or eliminated"]
[null,"Staff cut"]
[null,"Client services reduced or eliminated"]
[null,"Other  "]
[null,"Other  "]

{"sheet":"Annual Incident Costs","index":7,"n_rows":14,"n_cols":3,"rows_kept":14}
[]
[]
[]
[]
[]
[]
[null," Annual Cost Summary  "]
[]
[null,"Total cost of the incident:",{"$f":"'Single Incident Costs'!E17","v":{"v":64432,"d":"$64,432"}}]
[null,"Enter approximate number of MVIs of this type, per year",12]
[null,"Annual cost of MVIs of this type",{"$f":"C9*C10","v":{"v":773184,"d":"$773,184"}}]
[null,"Enter estimated increase in annual vehicle insurance premiums, if applicable"]
[null,"Enter estimated annual costs related to 3rd party claims"]
[null,"Total annual costs related to MVIs of this type",{"$f":"SUM(C11:C13)","v":{"v":773184,"d":"$773,184"}}]