{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Subcontractor Assessment","HSE Questionnaire","Subcontractor Mitigation Plan","Developing a Mitigation Plan"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"Subcontractor Assessment","index":0,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,3,5,4],[5,5,5,6],[5,8,5,10],[5,11,5,12],[1,2,2,5],[2,10,2,13],[2,14,2,17],[1,10,1,13],[1,14,1,17],[8,3,8,4],[18,4,24,12],[18,2,19,3],[6,7,7,10],[9,8,9,10],[4,2,4,18],[1,6,2,9],[16,4,16,12],[9,3,10,4],[10,5,10,8],[10,9,10,10],[12,3,13,4],[6,3,6,4],[26,2,26,18],[43,9,43,10],[43,11,43,12],[49,3,49,6],[49,7,49,12],[47,3,47,9],[46,3,46,12],[47,10,47,12],[48,10,48,12],[48,3,48,9],[44,2,44,18],[33,11,33,12],[29,13,29,14],[32,4,32,10],[32,11,32,12],[28,4,28,10],[7,11,7,12],[41,26,41,27],[42,26,42,27],[41,28,42,29],[30,4,30,10],[30,11,30,12],[30,13,30,14],[41,8,41,10],[35,4,35,10],[35,11,35,12],[35,13,35,14],[36,4,36,10],[36,11,36,12],[36,13,36,14],[31,4,31,10],[41,24,41,25],[42,24,42,25],[33,4,33,10],[33,13,33,14],[41,22,41,23],[42,22,42,23],[42,3,42,12],[37,4,37,10],[34,4,34,10],[41,4,41,7],[41,20,42,21],[37,11,37,12],[34,11,34,12],[34,13,34,14],[37,13,37,14],[28,11,28,12],[28,13,28,14],[29,4,29,10],[29,11,29,12],[32,13,32,14],[31,11,31,12],[31,13,31,14]]}
[]
[null,null,null,null,null,null,"Subcontractor Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose an item.",null,null,null,"Choose an item. "]
[null,null,null,null,null,null,null,null,null,null,"RELATED DOCUMENT\nMS21-STD1-RD13",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontractor is not registered in registry",null,null,null,"Commercial Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 year average TRIF  ≥ 3.5",null,null,null,"Corporate Services"]
[null,null,"Section 1 - Completed by Contractor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 year average TRIF  ≥ 7.0",null,null,null,"Electricity Services"]
[null,null,null,"Date Completed:",null,null,null,null,"         Completed By:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missing information on HSE Questionnaire form",null,null,null,"Water Services"]
[null,null,null,"Contractor:",null,null,null," Assessment Expiry:\n(no later than end of calendar year)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company has had an employee fatality in the last 3 years",null,null,null,"Technologies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provincial WCB/WSIB/WorkSafe Surcharge "]
[null,null,null,"Subcontractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WCB/WSIB/WorkSafe missing or account not in good standing "]
[null,null,null,"EPCOR \nRepresentative:",null,null,null,null,"          Business Unit(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company has received an OH&S stop work order(s) and/or fine(s) within the last 3 years "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose an item."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use of mobile equipment (non-licensed vehicles)"]
[null,null,null,"High consequence work scope(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazards where an occupational exposure control plan is required "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confined space entry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working at heights where a fall protection plan is required "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demolition"]
[null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazardous Energy Isolation "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hot work"]
[null,null,"Contractor Justification:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazardous Energy Isolation "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rigging or hoisting with a lifting device over 2 ton capacity "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground disturbance "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working in an excavation "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazardous Energy Isolation "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working in a substation or switch yard "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rescue services "]
[null,null,null,"Expected frequency of subcontractor usage per year:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supervising and/or directing high consequence work "]
[null,null,"Section 2 - Completed by Subcontractor"]
[]
[null,null,null,null,"EPCOR Health, Safety & Environment Subcontractor Evaluation",null,null,null,null,null,null,null,null,"Scoring",null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose an item."]
[null,null,null,1,"Has your company operated without a recorded fatality of a worker for the last three years?",null,null,null,null,null,null,null,null,{"$f":"IF(P30=TRUE,0,IF(Q30=TRUE,\"non-compliant\",\"Incomplete\"))","v":"Incomplete"},null,false,false,null,null,null,null,null,null,null,null,null,null,"Conditional (\"B\" Status)"]
[null,null,null,2,"Select your total recordable injury frequency average over the last three years?\n  \nTOTAL RECORDABLE INJURIES (Include: Modified and Restricted Duties) X 200,000\n\nTOTAL EMPLOYEE HOURS WORKED\n",null,null,null,null,null,null,null,null,{"$f":"IF(P31=TRUE,20,IF(Q31=TRUE,\"conditional\",IF(R31=TRUE,\"non-compliant\",\"Incomplete\")))","v":"Incomplete"},null,false,false,false,null,null,null,null,null,null,null,null,null,"Conditional (\"C\" Status)"]
[null,null,null,3,"Do you have current WCB/WSIB coverage in all the provinces you operate in?",null,null,null,null,null,null,null,null,{"$f":"IF(P32=TRUE,\"0\",IF(Q32=TRUE,\"non-compliant\",\"Incomplete\"))","v":"Incomplete"},null,false,false,null,null,null,null,null,null,null,null,null,null,"Non-compliant (\"F\" Status)"]
[null,null,null,4,"Does your company currently operate without a surcharge on your Provincial WCB/WSIB account in BC, Alberta, Saskatchewan and Ontario?\nPlease include a copy of your WCB/WSIB Premium rate statements for operations in BC, Alberta, Saskatchewan, and Ontario.\n",null,null,null,null,null,null,null,null,{"$f":"IF(P33=TRUE,15,IF(Q33=TRUE,\"conditional\",\"Incomplete\"))","v":"Incomplete"},null,false,false,null,null,null,null,null,null,null,null,null,null,"Non-compliant (\"Restricted\" Status) "]
[null,null,null,5,"Has your company operated without any OH&S stop work orders and/or fines within the last three years? \nIf no, please provide detailed information on process improvement strategies and/or action plans as a direct result of orders or fines.\n",null,null,null,null,null,null,null,null,{"$f":"IF(P34=TRUE,0,IF(Q34=TRUE,\"conditional\",\"Incomplete\"))","v":"Incomplete"},null,false,false,null,null,null,null,null,null,null,null,null,null,"Not registered in contractor registry "]
[null,null,null,6,"Please complete the HSE Questionnaire",null,null,null,null,null,null,{"$f":"IF(N35=\"Incomplete\",\"Incomplete\",\"Completed\")","v":"Incomplete"},null,{"$f":"IF(COUNTIF('HSE Questionnaire'!N92,\"Incomplete\")=1,\"Incomplete\",IF('HSE Questionnaire'!N92=\"Superior\",25,IF('HSE Questionnaire'!N92=\"Above Average\",20,IF('HSE Questionnaire'!N92=\"Satisfactory\",15,IF('HSE Questionnaire'!N92=\"Below Average\",10,IF('HSE Questionnaire'!N92=\"Unacceptable\",0,\"\"))))))","v":"Incomplete"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose an item."]
[null,null,null,8,"Has your company reviewed and acknowledge compliance with EPCOR’s Health and Safety Requirements for Contractors \n\nEPCOR's Health and Safety Requirements for Contractors are located at:\nhttps://www.epcor.com/about/working-with-epcor/contractors-suppliers/Pages/hse-requirements.aspx",null,null,null,null,null,null,null,null,{"$f":"IF(P36=TRUE,\"0\",IF(Q36=TRUE,\"non-compliant\",\"Incomplete\"))","v":"Incomplete"},null,false,false,null,null,null,null,null,null,null,null,null,null,"> 3 EPCOR projects "]
[null,null,null,9,"Has your company reviewed and acknowledge compliance with EPCOR’s Alcohol and Drug Standard for Contractors\n\nEPCOR’s Alcohol and Drug Requirements are located at: \nhttps://www.epcor.com/about/working-with-epcor/contractors-suppliers/Pages/alchohol-drug-standard.aspx",null,null,null,null,null,null,null,null,{"$f":"IF(P37=TRUE,\"0\",IF(Q37=TRUE,\"non-compliant\",\"Incomplete\"))","v":"Incomplete"},null,false,false,null,null,null,null,null,null,null,null,null,null,"< 3 EPCOR projects"]
[null,null,null,10,"Has your company reviewed and acknowledge compliance with EPCOR’s Life Saving Rules Standard\n\nEPCOR’s Life Saving Rules are located at:\nhttps://www.epcor.com/about/working-with-epcor/contractors-suppliers/Pages/policies-for-contractors.aspx\n",null,null,null,null,null,null,null,null,{"$f":"IF(P38=TRUE,\"0\",IF(Q38=TRUE,\"non-compliant\",\"Incomplete\"))","v":"Incomplete"},null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N30:O38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N39>=45.01,\"A/Compliant\",IF(N39>=25.01,\"conditional\",IF(N39>=0.01,\"conditional\",IF(N39=0,\"F/Non-Compliant\",\"\"))))","v":"F/Non-Compliant"}]
[]
[null,null,null,null,"Final Result",null,null,null,{"$f":"IF(COUNTIF(N30:O38,\"Incomplete\")>=1,\"Incomplete\",IF(OR(N39<=0,N30=\"non-compliant\",N31=\"non-compliant\",N32=\"non-compliant\",N35=\"non-compliant\",N36=\"non-compliant\",N37=\"non-compliant\",N38=\"non-compliant\"),\"F/Non-Compliant\",IF(COUNTIF(N30:O40,\"conditional\")>=2,\"C/Conditional\",IF(AND(N39>=45.01,COUNTIF(N30:O40,\"conditional\")=0),\"A/Compliant\",IF(AND(N39>=25.01,COUNTIF(N30:O40,\"conditional\")=1),\"B/Conditional\",IF(N39>0,\"C/Conditional\",\"\"))))))","v":"Incomplete"}]
[]
[null,null,null,{"$f":"IF(I42=\"F/Non-Compliant\",\"Trigger(s)\",IF(I42=\"B/Conditional\",\"Trigger(s)\",IF(I42=\"C/Conditional\",\"Trigger(s)\",\"\")))","v":""},{"$f":"IF(AND(D44=\"Trigger(s)\",Q30=TRUE),\"1. \nFatality in the last 3 years\",\"\")","v":""},{"$f":"IF(AND(D44=\"Trigger(s)\",Q31=TRUE),\"2. \nTRIF >=3/5<7\",IF(AND(D44=\"Trigger(s)\",R31=TRUE),\"2. \nTRIF>=7\",\"\"))","v":""},{"$f":"IF(AND(D44=\"Trigger(s)\",Q32=TRUE),\"3. \nDo not have current WCB/WSIB coverage in all provinces operating in\",\"\")","v":""},{"$f":"IF(AND(D44=\"Trigger(s)\",Q33=TRUE),\"4. \nWCB surcharge in current year\",\"\")","v":""},{"$f":"IF(AND(D44=\"Trigger(s)\",Q34=TRUE),\"5. \nOH&S-issued stop-work orders and/or fines in the previous 3 years\",\"\")","v":""},{"$f":"IF(AND(D44=\"Trigger(s)\",N35<=10,OR(I42=\"B/Conditional\",I42=\"C/Conditional\")),\"6. Discrepancy in HSE Questionnaire\",\"\")","v":""},null,{"$f":"IF(AND(D44=\"Trigger(s)\",COUNTIF(Q36:Q38,\"TRUE\")>=1),\"8.9.10. Failure to acknowledge:\n a) EPCOR Health and Safety Requirements\n b) Alcohol and Drug Standard\n c) Life Saving Rules Standard\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(D44=\"Trigger(s)\",N40=\"conditional\",OR(I42=\"B/Conditional\",I42=\"C/Conditional\")),\"Overall Score Insufficient\",\"\")","v":""}]
[null,null,"Section 3 - Completed by Contractor"]
[]
[null,null,null,"Evaluation Results"]
[null,null,null,"Completed by the requesting contractor\nIs a Mitigation Plan Required?",null,null,null,null,null,null,{"$f":"IF(I42=\"A/Compliant\",\"No Mitigation Plan Required\",IF(I42=\"B/Conditional\",\"Yes, Mitigation Plan Required\",IF(I42=\"C/Conditional\",\"Yes, Mitigation Plan Required\",IF(I42=\"F/Non-Compliant\",\"Yes, Mitigation Plan Required\",\"\"))))","v":""}]
[null,null,null,"Has a mitigation plan been completed? "]
[null,null,null,"Reviewed by:"]

{"sheet":"HSE Questionnaire","index":1,"n_rows":92,"n_cols":19,"rows_kept":92,"cut":false,"hidden":false,"merged":[[90,10,90,12],[87,3,87,10],[87,11,87,12],[88,3,88,10],[88,11,88,12],[82,3,82,10],[82,11,82,12],[83,3,83,10],[83,11,83,12],[84,3,84,10],[84,11,84,12],[85,3,85,10],[85,11,85,12],[86,2,86,12],[77,3,77,10],[77,11,77,12],[78,3,78,10],[78,11,78,12],[79,3,79,10],[79,11,79,12],[80,3,80,10],[80,11,80,12],[81,2,81,12],[72,3,72,10],[72,11,72,12],[73,3,73,10],[73,11,73,12],[74,3,74,10],[74,11,74,12],[75,3,75,10],[75,11,75,12],[76,3,76,10],[76,11,76,12],[4,3,4,10],[4,11,4,12],[5,3,5,10],[5,11,5,12],[6,3,6,10],[6,11,6,12],[1,2,1,12],[2,2,2,12],[3,3,3,10],[3,11,3,12],[10,3,10,10],[10,11,10,12],[11,3,11,10],[11,11,11,12],[12,3,12,10],[12,11,12,12],[7,3,7,10],[7,11,7,12],[8,3,8,10],[8,11,8,12],[9,3,9,10],[9,11,9,12],[16,3,16,10],[16,11,16,12],[17,3,17,10],[17,11,17,12],[18,3,18,10],[18,11,18,12],[13,3,13,10],[13,11,13,12],[14,3,14,10],[14,11,14,12],[15,3,15,10],[15,11,15,12],[22,3,22,10],[22,11,22,12],[23,3,23,10],[23,11,23,12],[24,3,24,10],[24,11,24,12],[19,3,19,10],[19,11,19,12],[20,3,20,10],[20,11,20,12],[21,3,21,10],[21,11,21,12],[28,3,28,10],[28,11,28,12],[29,3,29,10],[29,11,29,12],[30,3,30,10],[30,11,30,12],[25,3,25,10],[25,11,25,12],[26,3,26,10],[26,11,26,12],[27,3,27,10],[27,11,27,12],[34,3,34,10],[34,11,34,12],[35,3,35,10],[35,11,35,12],[36,3,36,10],[36,11,36,12],[31,3,31,10],[31,11,31,12],[32,3,32,10],[32,11,32,12],[33,3,33,10],[33,11,33,12],[41,3,41,10],[41,11,41,12],[42,3,42,10],[42,11,42,12],[43,3,43,10],[43,11,43,12],[37,3,37,10],[37,11,37,12],[38,3,38,10],[38,11,38,12],[39,2,39,12],[40,3,40,10],[40,11,40,12],[47,3,47,10],[47,11,47,12],[48,3,48,10],[48,11,48,12],[49,3,49,10],[49,11,49,12],[44,3,44,10],[44,11,44,12],[45,3,45,10],[45,11,45,12],[46,3,46,10],[46,11,46,12],[54,3,54,10],[54,11,54,12],[55,2,55,12],[56,3,56,10],[56,11,56,12],[57,3,57,10],[57,11,57,12],[50,2,50,12],[51,3,51,10],[51,11,51,12],[52,3,52,10],[52,11,52,12],[53,3,53,10],[53,11,53,12],[61,3,61,10],[61,11,61,12],[62,3,62,10],[62,11,62,12],[63,3,63,10],[63,11,63,12],[58,3,58,10],[58,11,58,12],[59,3,59,10],[59,11,59,12],[60,3,60,10],[60,11,60,12],[71,2,71,12],[67,3,67,10],[67,11,67,12],[68,2,68,12],[69,3,69,10],[69,11,69,12],[70,3,70,10],[70,11,70,12],[64,3,64,10],[64,11,64,12],[65,3,65,10],[65,11,65,12],[66,3,66,10],[66,11,66,12]]}
[]
[null,null,"HSE Questionnaire"]
[null,null,"Health and Safety Policy, Structure and Responsibility",null,null,null,null,null,null,null,null,null,null,"Scores",{"$f":"IF(O4=TRUE,0.25,\"\")","v":""},{"$f":"IF(P4=TRUE,0.25,\"\")","v":""},{"$f":"IF(Q4=TRUE,0.25,\"\")","v":""},{"$f":"IF(R4=TRUE,0.25,\"\")","v":""}]
[null,null,"CA:2:1","Does your company establish WRITTEN annual goals in any of the following?",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O3:R3)","v":0},false,false,false,false]
[null,null,"CA:3:5","Does your company have clearly defined HSE responsibilities for managers, supervisors and workers?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O5=TRUE,1,IF(P5=TRUE,\"0\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:3:3","Does your company have a Health, Safety and Environmental (HSE) manual? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O6=TRUE,5,IF(P6=TRUE,0,\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:9:4","Does your company have scheduled and documented employee HSE meetings?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O7=TRUE,1,IF(P7=TRUE,0,\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:2:2","Are Heatlh,Safety and Environmental (HSE) meetings reviewed and critiqued by managers/supervisors?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O8=TRUE,1,IF(P8=TRUE,0,\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:4:9","If there is a change in job scope, is a management of change (MOC) performed? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O9=TRUE,\"\",IF(P9=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:4:3","Does your company hold documented pre-job/toolbox meetings to discuss and assess the hazards of the work to be performed? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O10=TRUE,1,IF(P10=TRUE,0,\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:4:10","Does your company conduct formal, documented health and safety inspections of the work site? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O11=TRUE,1,IF(P11=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:11:12","Does your company have a written program for reporting of near misses? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O12,1,IF(P12=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:6:18","Does your company have a preventative maintenance program for tools and equipment? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O13,1,IF(P13=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:1:7","Does you company have a formal Employee Assistance Program (EAP)? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O14,1,IF(P14=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:3:1","Does your company have a written Health, Safety, and Environmental (HSE) Policy Statement?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O15,1,IF(P15=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:12:6","Does your company have a system to ensure action items identified in audits and inspections are addressed? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O16=TRUE,\"\",IF(P16=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:9:6","Does your company have a system to allow for HSE-related feedback from employees? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O17=TRUE,\"\",IF(P17=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:5:2:3","Does the Vehicle Safety/Driving Safety program include restrictions on cell phone use while driving? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:5:2:4","Does the Vehicle Safety/Driving Safety program require drivers to posses a valid license for the type of motor vehicle they operate?  ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:5:2:5","Does the Vehicle Safety/Driving Safety program require vehicles to be maintained per manufacturer specifications? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:5:2:6","Does the Vehicle Safety/Driving program require loads/cargo to be adequately secured before driving? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:6:11","Do all employees participate in the worker observation (Behavioural Based Safety) program? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:5:2:8","Does your company require Defensive Driving training for employees who operate motor vehicles? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:6:10","Does your company have a documented worker observation program (Behavior Based Safety) that includes observation of employees while in the process of work? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O24=TRUE,1,IF(P24=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:5:2:2","Does the Vehicle Safety/Driving Safety program require seat belts be worn by the driver and all passengers? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:6:8","Does your company provide hands-on training to ensure workers are competent in performing their jobs/tasks?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O26=TRUE,1,IF(P26=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:2:3","How often does management visit the work site? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O27=TRUE,1,IF(P27=TRUE,1,IF(Q27=TRUE,1,IF(R27=TRUE,1,IF(S27=TRUE,0,\"Incomplete\")))))","v":"Incomplete"},false,false,false,false,false]
[null,null,"CA:10:8:44","Did your company receive any stop work orders, stop use/operation orders, No compliance orders, and/or inspector/Director's orders from Occupational Health and Safety in 2022?",null,null,null,null,null,null,null,null,null,{"$f":"IF(P28=TRUE,3,IF(O28=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:13:44","Did your company receive any stop work orders, stop use/operation orders, No compliance orders, and/or inspector/Director's orders from Occupational Health and Safety in 2021?",null,null,null,null,null,null,null,null,null,{"$f":"IF(P29,2,IF(O29=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:18:44","Did your company receive any stop work orders, stop use/operation orders, No compliance orders, and/or inspector/Director's orders from Occupational Health and Safety in 2020?",null,null,null,null,null,null,null,null,null,{"$f":"IF(P30,1,IF(O30=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:8:42","Was your company fined and/or prosecuted for any Occupational Health and Safety violations in 2022?",null,null,null,null,null,null,null,null,null,{"$f":"IF(P31=TRUE,3,IF(O31=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:13:42","Was your company fined and/or prosecuted for any Occupational Health and Safety violations in 2021?",null,null,null,null,null,null,null,null,null,{"$f":"IF(P32=TRUE,2,IF(O32=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:18:42","Was your company fined and/or prosecuted for any Occupational Health and Safety violations in 2020?",null,null,null,null,null,null,null,null,null,{"$f":"IF(P33=TRUE,1,IF(O33=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:8:48","Did your company experience any reportable spills or releases of chemical substances in 2022?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O34=TRUE,\"\",IF(P34=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:13:48","Did your company experience any reportable spills or releases of chemical substances in 2021?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O35=TRUE,\"\",IF(P35=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:10:18:48","Did your company experience any reportable spills or releases of chemical substances in 2020?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:10:8:46","Was your company fined and/or prosecuted for any environmental violations in 2022? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:10:13:46","Was your company fined and/or prosecuted for any environmental violations in 2021? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:10:18:46","Was your company fined and/or prosecuted for any environmental violations in 2020? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"Operational Controls - Programs and Procedures"]
[null,null,"CA:5:2:9","Does your company have a written Journey/Travel Management program? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:6:14","Does your company have a written Fatigue Management program? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O42=TRUE,\"\",IF(P42=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:6:1","Does your company have a written New Employee Orientation program? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O43=TRUE,1,IF(P43=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:11:10","Does your company provide training to employees on the company's Return to Work/Modified Duty program? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O44=TRUE,1,IF(P44=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:7:1:1","Does your company provide training to employees and/or subcontractors on the company's General Health and Safety Rules and Requirements? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:6:9","Does your company maintain a list of training requirements (or a training matrix) for all jobs/tasks to be used to train new and/or transferred employees? ",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:6:13","Does your company have a written Disciplinary program/policy? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O47=TRUE,\"\",IF(P47=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:13:14","Does your company provide training to employees on procedures to be followed in the event of a chemical spill or release? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O48=TRUE,\"\",IF(P48=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:7:1:11","Does your company keep records (i.e. sign-in sheets, training certificates) of all Health, Safety, and Environmental training provided to employees and/or subcontractors? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(O49,4,IF(P49=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:5:3:2","Does your company operate Commercial Vehicles with a registered gross vehicle weight or combined weight of 4,500 kg or greater (5,000 kg in BC and SK)? This may include, but is not limited to, trucks 3/4 ton or greater, truck-trailer combinations, tractor-trailer combinations, buses, and large passenger vans. If your company outsources all transport to a 3rd Party and none of your employees operate commercial vehicles, answer NO to this question.",null,null,null,null,null,null,null,null,null,{"$f":"IF(O50=TRUE,1,IF(P50=TRUE,1,\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"Drug and Alcohol "]
[null,null,"CA:5:1:1","Does your company have a written Drug and Alcohol program?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O52=TRUE,10,IF(P52=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:5:1:13","Are your company's employees subject to post-incident drug and alcohol testing?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O53=TRUE,1,IF(P53=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:5:1:14","Are your company's employees subject to reasonable cause drug and alcohol testing?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O54=TRUE,1,IF(P54=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:5:1:4","Does your company's Drug and Alcohol program prohibit employees and subcontractors from entering the workplace while under the influence?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"Incident Investigation, Reporting and Analysis"]
[null,null,"CA:11:3","Are employees informed of the requirement to report incidents?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:11:4","Does the Incident Reporting program include the roles and responsibilities of employees in the event of an incident?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:11:7"," Does the Incident Reporting program include a requirement to document all types of work related incidents (i.e. injuries/illnesses, near misses, property damage, vehicle accidents, fire/explosion, chemical spills, etc.)?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:11:11","Does your company conduct an incident investigation when an incident occurs?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:11:16","Are completed incident reports reviewed by management?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:11:12"," Does your company conduct incident investigations for near misses?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:11:8","Does your company have a Return to Work/Modified Duty program?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:11:6"," Does your company send injured employees to a specific medical provider familiar with Occupational Health (i.e. Occupational Injury Service, Company Doctor)?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O64=TRUE,\"\",IF(P64=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:11:17","Does your company have a process to share lessons learned from incidents with employees?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O65=TRUE,1,IF(P65=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:7:1:3","Does your company conduct routine emergency drills?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O66=TRUE,\"\",IF(P66=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:11:15"," Does your company have a system to ensure corrective actions identified in incident investigations are closed out?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O67,1,IF(P67=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:11:18","Does your company have a procedure for reporting security incidents?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O68=TRUE,\"\",IF(P68=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"Audits"]
[null,null,"CA:12:5","Who is responsible for reviewing the Health, Safety, and Environmental audits? Job Title: (Enter title in box) (Does not require answer)",null,null,null,null,null,null,null,null,null,{"$f":"IF(L70=\"\",0,1)","v":0}]
[null,null,"CA:12:3","Does your company perform regular audits of its Health, Safety, and Environmental program?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O71=TRUE,2,IF(P71=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"Environmental Policy and Controls "]
[null,null,"CA:13:7","Is your company's environmental program audited periodically by an accredited environmental auditor?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O73=TRUE,1,IF(P73=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:13:20","Does your company provide environmental training to its supervisors?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O74,1,IF(P74=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:13:1","Does your company have a written Environmental policy statement?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O75=TRUE,1,IF(P75=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:13:6","Does your company perform environmental audits?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O76=TRUE,\"\",IF(P76=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:13:10","Does your company have a General Waste Management program?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O77=TRUE,\"\",IF(P77=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:13:5","Are environmental topics routinely discussed during employee health and safety meetings?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:13:13","Does your company have a written Spill Prevention and Response program?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:13:15","Does your company provide adequate spill kits to contain and cleanup any spills that may be reasonably anticipated?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:13:17"," Does the Spill Prevention and Response program include a procedure to notify appropriate environmental authorities in the event of a spill/release?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"Company Information "]
[null,null,"GEN:1:28","What year was your company established?",null,null,null,null,null,null,null,null,null,{"$f":"IF(L83=\"\",\"Incomplete\",\"\")","v":"Incomplete"}]
[null,null,"CA:1:4","What is your company's Canada Revenue Agency (CRA) Business Number (BN)?",null,null,null,null,null,null,null,null,null,{"$f":"IF(L84=\"\",\"Incomplete\",\"\")","v":"Incomplete"}]
[null,null,"CA:1:6"," Is your company federally regulated?\n\nIf your company is required to comply with provincial health and safety regulations, your company is not federally regulated.\n\nOnly about 6% of Canadian workers fall under federal jurisdiction. The most common federally regulated industries amongst contractor companies are interprovincial trucking, air transportation, and telecommunications.  For a complete listing of federally regulated industries, please click here.\n\nAlthough your company may occasionally perform interprovincial trucking, you are not federally regulated under the Canada Labour Code unless trucking is your primary business. If you require further assistance in determining if your company is federally regulated, please call 800-641-4049 and listen to the automated recording.\n\nNote: The answer you provide for this question may have a significant impact on your RAVS Written Program requirements.",null,null,null,null,null,null,null,null,null,{"$f":"IF(O85=TRUE,\"\",IF(P85=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"CA:8:1"," Does your company use subcontractors?",null,null,null,null,null,null,null,null,null,{"$f":"IF(O86=TRUE,\"\",IF(P86=TRUE,\"\",\"Incomplete\"))","v":"Incomplete"},false,false]
[null,null,"Leadership and Commitment "]
[null,null,"CA:3:2","Has Senior Management approved and signed the written HSE Policy Statement?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,"CA:2:6","Does management regularly review Health and Safety performance, at minimum annually?",null,null,null,null,null,null,null,null,null,"Incomplete",false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(N4:N89,\"Incomplete\")>=1,\"Incomplete\",SUM(N4:N89))","v":"Incomplete"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N90=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Incomplete"},null,null,{"$f":"IF(COUNTIF(N90,\"Incomplete\")=1,\"Incomplete\",N90/67)","v":"Incomplete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(N91,\"Incomplete\")=1,\"Incomplete\",IF(N91>89.99%,\"Superior\",IF(N91>=80%,\"Above Average\",IF(N91>=70%,\"Satisfactory\",IF(N91>=60%,\"Below Average\",IF(N91<=59.99%,\"Unacceptable\",\"\"))))))","v":"Incomplete"}]

{"sheet":"Subcontractor Mitigation Plan","index":2,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,15,51,17],[50,15,50,17],[43,2,43,3],[41,2,42,3],[38,4,38,10],[51,2,51,3],[51,5,51,7],[43,12,43,13],[51,12,51,13],[41,5,42,7],[43,5,43,7],[49,2,50,3],[49,5,50,7],[49,12,50,13],[41,12,42,13],[35,2,35,8],[31,11,31,13],[32,11,32,13],[33,11,33,13],[31,9,31,10],[34,11,34,13],[35,11,35,13],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[31,2,31,8],[32,2,32,8],[33,2,33,8],[34,2,34,8],[1,4,3,9],[5,2,5,4],[7,2,7,4],[5,6,5,8],[7,6,7,8],[5,9,5,12],[28,2,28,12],[30,11,30,13],[9,6,9,8],[17,2,17,8],[19,2,19,12],[24,3,24,12],[9,2,9,4],[11,2,11,4],[9,9,9,11],[30,9,30,10],[30,2,30,8]]}
[]
[null,null,null,null,"Subcontractor Mitigation Plan"]
[]
[]
[]
[null,"Date:",null,null,null,null,"Project Name and Number:"]
[]
[null,"Contractor Lead Representative:",null,null,null,null,"Business Unit:"]
[]
[null,"Subcontractor:",null,null,null,null,"Status of the subcontractor in SubTracker:",null,null,{"$f":"IF('Subcontractor Assessment'!I42=\"A/Compliant\",\"A/Compliant\",IF('Subcontractor Assessment'!I42=\"B/Conditional\",\"B/Conditional\",IF('Subcontractor Assessment'!I42=\"C/Conditional\",\"C/Conditional\",IF('Subcontractor Assessment'!I42=\"F/Non-Compliant\",\"F/Non-Compliant\",IF('Subcontractor Assessment'!I42=\"Incomplete\",\"Assessment Incomplete\",\"\")))))","v":"Assessment Incomplete"}]
[]
[null,"Sign-off Expiry:"]
[null,"Must expire before March 31st of the following year"]
[]
[null,"High consequence work scope(s):"]
[]
[]
[null,"Other:"]
[]
[null,null,"The above subcontractor has been identified as Conditional/Non-Compliant due to the following reasons:"]
[]
[]
[]
[]
[null,null,"Other:"]
[]
[]
[]
[null,null,"The following controls and/or requirements are established to mitigate risk directly related to the status trigger(s):"]
[]
[null,null,"Description of control(s)",null,null,null,null,null,null,"Who is accountable to verify the control(s) (name, position)",null,"Date the control is verified as complete or as deemed effective"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"REQUIRED APPROVAL SIGNATURES"]
[]
[null,null,{"$f":"IF('Subcontractor Assessment'!I42=\"B/Conditional\",\"Contractor Lead Representative\",IF('Subcontractor Assessment'!I42=\"C/Conditional\",\"Contractor Lead Representative\",IF('Subcontractor Assessment'!I42=\"F/Non-Compliant\",\"Contractor Senior Leadership Representative\",IF('Subcontractor Assessment'!I42=\"Incomplete\",\"Assessment Incomplete\",\"\"))))","v":"Assessment Incomplete"}]
[]
[]
[null,null,"Name (Print)",null,null,"Title",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[null,null,{"$f":"IF('Subcontractor Assessment'!I42=\"B/Conditional\",\"Subcontractor Lead Representative\",IF('Subcontractor Assessment'!I42=\"C/Conditional\",\"Subcontractor Lead Representative\",IF('Subcontractor Assessment'!I42=\"F/Non-Compliant\",\"Subcontractor Senior Leadership Representative\",IF('Subcontractor Assessment'!I42=\"Incomplete\",\"Assessment Incomplete\",\"\"))))","v":"Assessment Incomplete"}]
[]
[]
[null,null,"Name (Print)",null,null,"Title",null,null,null,null,null,null,"Date"]

{"sheet":"Developing a Mitigation Plan","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,4,4,11],[21,1,21,6],[21,7,21,12],[22,1,31,6],[22,7,31,12]]}
[]
[null,null,null,null,"Developing a mitigation plan\nConditional/Non-Compliant Subcontractors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Conditional (B/C grade) Status Triggers:",null,null,null,null,null,"Non-Compliant (F grade) Status Triggers:"]