{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Training Matrix","Variables"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"Training Matrix","index":0,"n_rows":96,"n_cols":81,"rows_kept":96,"cut":false,"hidden":false,"merged":[[0,1,0,3],[2,14,4,15],[2,13,5,13],[2,17,5,17],[2,18,4,21],[2,31,4,31],[6,31,72,31],[16,0,21,0],[23,0,28,0],[2,10,4,11],[2,3,4,4],[2,1,4,1],[2,8,4,9],[2,6,4,7],[2,0,3,0],[7,0,14,0],[2,5,5,5],[2,23,5,23],[2,24,4,25],[2,26,4,27],[2,29,5,29]]}
[null,"Skills and Training Matrix"]
[null,null,null,"Roles 6 - (Refer to the Skills and Training Guideline in the VESI for Descriptions of roles)"]
[60,null,{"$f":"C2+A2","v":0},"Lineworker",null,"Cable Jointer ","Substation Electrician / Fitter",null,"Tester",null,"HV Switching Operator",null,null,"Asset Inspector","Auditor ",null,null,"Civil Worker ","Communictions Worker",null,null,null,null,"No Go Zone Assessor","Plant Operator",null,"Rigger",null,null,"Technical Officer / Maint Worker"]
[]
[]
[null,null,"Qualification / Competency Standard Unit (CSU) number","Distribution ","Transmission ",null,"Distribution Substations","Terminal & Zone Substations","Distribution Assets","Terminal & Zone Substations","Distribution","Terminal & Zone Substations","Metering Technician",null,"General","Underground","Cable Hauler",null,"HV/LV Enclosures","Pole work","Tower","Underground work","Electrical Inspector",null,"ESI worker","Day hire","General","Towers","Supervisor / Team leader",null,"Trade assistant","Vegetation Work",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee Name","Employee Name","Employee Name"]
[null,"Qualifications",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,null,null,"Refer to the VESI Vegetation Management Guideline for all Vegetation training requirements",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Attended","Date Attended","Date Attended"]
["Qualifications","Certificate II in Asset Inspection1","UET20612",null,null,null,null,null,null,null,null,null,null,"M"]
[null,"Certificate II in ESI - Powerline Vegetation Control1","UET20312 "]
[null,"Certificate III in ESI - Power Systems - Distribution Overhead1","UET30612","M",null,null,null,null,null,null,"A7","A7",null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,"Certificate III in ESI - Power Systems - Transmission Overhead1","UET30512",null,"M"]
[null,"Certificate III in ESI - Power Systems - Distribution Cable Jointing1","UET30812",null,null,"M",null,null,null,null,"A7","A7",null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,"Certificate III in Electrotechnology Electrician1","UEE30811",null,null,null,"M","M",null,null,"A7","A7","M",null,null,null,null,null,null,null,null,null,"M","A"]
[null,"Certificate IV in ESI - Power Systems Substations1","UET40512",null,null,null,null,null,null,null,"A7","A7"]
[null,"Advanced Diploma of ESI - Power Systems1","UET60212",null,null,null,null,null,"M","M"]
[null,"Licence"]
["Licence","Licenced Electrical Inspector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,"Licenced Electrical Worker",null,null,null,null,"A","A",null,null,null,null,"A"]
[null,"High Risk Work Licence - Dogging (DG)",null,"M","M","A","A","A"]
[null,"High Risk Work Licence - Rigging15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,"High Risk Work Licence - Crane15",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","A"]
[null,"High Risk Work Licence - Elevating Work Platform (WP)",null,"M","A","A","A","A","A","A","A","A"]
[null,"Initial training"]
["Initial training","Apply ESI safety rules, codes of practice and procedures for work on or near electrical apparatus (Green Book / Blue book)","UETTDRRF01B","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M"]
[null,"Work safely in the construction industry (White card) or equivalent","CPCCWHS1001","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M"]
[null,"Working safely near live electrical apparatus as a non electrical worker ","UETTDREL14A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","M","M","M"]
[null,"VEDN Installation of Underground Electrical Infrastructure14",null,null,null,null,null,null,null,null,null,null,null,null,null,"M","M","A8",null,null,null,null,null,null,"A8"]
[null,"VEDN Auditor training14",null,null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,"Lay ESI electrical cables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M"]
["Frequency","Training2"]
["1  Year","Attached Climbing for Tower Work",null,"A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,"A","M"]
["1  Year","Cable pit / trench / excavation Rescue   ","UETTDRRF07B",null,null,"M"]
["1  Year","CPR3","HLTAID001","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M"]
["1  Year","EWP Controlled Descent Escape   ","UETTDRRF08B","M","M","A","A","A","A","A","M",null,null,null,null,null,null,null,null,"M",null,null,null,null,null,null,"A","A"]
["1  Year","EWP Rescue           ","UETTDRRF03B","M","M","A","A","A","A","A","M",null,null,null,null,null,null,null,null,"M",null,null,null,null,null,null,"A","A"]
["1  Year","First Aid in an ESI environment3","UETTDRRF10B","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M"]
["1  Year","High Voltage Live Work - Pole Erection Recovery Unit Operator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A9"]
["1  Year","High Voltage Live Work - Vehicle Mounted Crane Operator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A10"]
["1  Year","Live LV Panel Rescue                            ","UETTDRRF06B",null,null,"M","A","A","M","M"]
["1  Year","Maintain energised HV distribution overhead electrical apparatus (glove)","UETTDRDP14A","A"]
["1  Year","Maintain energised HV distribution overhead electrical apparatus (stick) ","UETTDRDP13A ","A","A"]
["1  Year","Maintain energised transmission lines using high voltage live work Barehand method","UETTDRTP32A",null,"A"]
["1  Year","Maintain energised transmission lines using high voltage live work stick method ","UETTDRTP31A",null,"A"]
["1  Year","Pole Top Rescue                            ","UETTDRRF02B","M",null,"A",null,null,"A",null,"M"]
["1  Year","Safe Approach Distances ",null,"M","M","M","M","M","M","M","M","M","M","M","A","M","M","M",null,null,null,null,"M",null,"M",null,"M","M","A",null,"M"]
["1  Year","Switchyard structures at Heights Rescue   ","UETTDRRF05B",null,null,null,"A","M",null,"A"]
["1  Year","Testing of connections to low voltage electricity networks  (Servicing Procedures)","UETTDRRF11A ","M",null,"M",null,null,null,null,null,null,"M11",null,null,null,null,null,null,null,null,null,"M"]
["1  Year","Tower Rescue      ","UETTDRRF04B","A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,"A","M"]
["1  Year","Undertake release and rescue from a tree near live electrical apparatus","UETTDRVC34A"]
["3  Yearly","Confined spaces",null,null,null,"A","A","A","A"]
["3  Yearly","Live Low Voltage Work - Cable Jointing",null,null,null,"M"]
["3  Yearly","Live Low Voltage Work - Overhead",null,"M"]
["3  Yearly","Live Low Voltage Work - Ground level",null,null,null,null,"A","A","A","A"]
["3  Yearly","Making LV Dead",null,"M",null,"A12",null,null,null,null,"A"]
["3  Yearly","Manual Handling",null,"M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M","M","M","M",null,"M",null,"M","M","A",null,"M"]
["3  Yearly","Measuring Conductor Heights Using Telescopic Measuring Sticks",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,"A"]
["3  Yearly","No Go Zone Assessor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M"]
["3  Yearly","Safe to Approach SWER4",null,"M",null,"A",null,null,"A",null,"M",null,null,"M","A",null,"A","A",null,null,null,null,"A",null,null,null,null,null,"A","A","A"]
["3  Yearly","Safe to Climb",null,"M",null,"A",null,null,"A",null,"M",null,null,null,null,null,null,null,null,"M"]
["3  Yearly","Control traffic with stop-slow bat ","RIIWHS205D","M","A","M","M","A","M","A","M",null,"A","M","A","A","M","M","A","M","A","M",null,null,"M",null,"A","A","M","A","M"]
["3  Yearly","Implement traffic management plan","RIIWHS302D","M","A","M","M","A","M","A","M",null,"A","M","A","A","M","M","A","M","A","M",null,null,"M",null,"A","A","M","A","M"]
["3  Yearly","VESI Environmental Framework",null,"M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M"]
["3  Yearly","VESI Safety Framework",null,"M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M"]
["3  Yearly","Wash HV Insulators",null,"A","A"]
[null,"Authority Training* 2"]
["3  Yearly","Apply access procedures to work on or near electrical network infrastructure (Receive Access Permit)","UETTDRRF09B","M","M","M","M","M","M","M","M","M",null,null,null,null,null,null,null,null,"A",null,null,"M",null,null,"M","M","A13"]
["3  Yearly","Enter Enclosures",null,null,null,null,null,null,null,null,null,null,"A","M","A","A","A","A","M","A",null,null,"M",null,"A",null,null,null,"A13","M","A"]
["3  Yearly","High Voltage Switching5",null,null,null,null,null,null,null,null,"M","M"]
["3  Yearly","Make Application for",null,"A","A","A","A","A","A","A",null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,"A","A"]
["3  Yearly","Receive Sanction For Testing",null,null,null,null,null,null,"A","A"]
[null,"Other"]
[null,"Australian ESI Skills Passport",null,"M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M"]
[null,"Network Operator Induction",null,"M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M","M",null,"M","M","M","M","M"]
[]
["Legend"]
["M - Mandatory                                                                                                                                                                                                                                                                                "]
["A - Additional - If an employee requires this training for the works being performed and has the initial training, refresher is mandatory"]
["* Following the completion of training apply to your applicable Network Operator/s for Authorisation"]
[]
["Notes"]
["1 - Refers to a National qualification or recognised equivalents. Could include enterprise training (e.g. SECV).  If the evidence is a recognised equivalent this shall be reviewed by the Network Operator"]
["2 - For the training and assessment criteria refer to VESI training and assessment reference material  on the VESI website"]
["3 - If a worker has successfully completed Provide First Aid (HLTAID003) or Apply First Aid (HLTFA311A) within the same year then equivalence is given. Note: HLTAID003 and HLTFA311A have a recommended 3 yearly refresher, therefore        "]
["     CPR & First Aid in an ESI environment shall be completed in the following years"]
["4 - This is not a Mandatory requirement on the CitiPower and Jemena Networks"]
["5 - Training/assessment for HV switching is dependant on the Authorisation class (E.g. RSO, DSO, DS, ZSS) issued by the Network Operator. Refer to the VESI Skills and Training Guideline for HV switching training associated with the relevant Authorisation class"]
["6 - Where a person performs multiple roles they shall undertake the mandatory training for each of those roles"]
["7 - Entry pathway to this role maybe varied and shall be determined by the Network Operator"]
["8 - For tasks that involve excavation for the purposes of installing underground infrastructure this module is Mandatory"]
["9 - Required for Pole Erection Recovery Unit (PERU) operators working with HV live work crews"]
["10 - Required for Vehicle Mounted Crane Operators working with HV live work crews"]
["11 - Not required for Technicians whose duties are limited to Current Transformer (CT) metering work and are not required to undertake installation connections"]
["12 - Making LV dead is mandatory for Cable Jointers who have the National Competency Standard Unit in Low Voltage Field Switching and who perform LV Switching"]
["13 - Workers to complete either Auth to Enter or Auth to receive depending on work being performed"]
["14 - Refer to the VEDN website for training specifications"]
["15 - Class of Licence is dependant on the tasks / Plant being undertaken / utilised"]

{"sheet":"Variables","index":1,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":true,"merged":[[5,5,5,6]]}
[null,null,null,null,null,"Right Footer","May 2016"]
["Position","Position subgroup","Position Abr","Sheet Name"]
[null,"Lineworker - Distribution",null,"Lineworker - Distribution",{"$f":"COUNTIF(D:D,D3)","v":1}]
[null,"Lineworker - Transmission",null,"Lineworker - Transmission",1]
["Cable Jointer","Cable Jointer",null,"Cable Jointer",1]
["Substations Electrician / Fitter","Electrical Fitter - Distribution Substations",null,"Electrical Fitter - Distributi",1,null,null,null,null,null,null,null,null,"Employee Name","Employee Name"]
["Substations Electrician / Fitter","Electrical Fitter - Terminal & Zone Substations",null,"Electrical Fitter - Terminal &",1,"Date Attended","Expiry",null,null,null,null,null,null,"Date Attended","Date Attended"]
["Tester","Tester - Distribution Assets",null,"Tester - Distribution Assets",1,null,{"$f":"IF(F8>0,F8+365,0)","v":"00:00:00"}]
["Tester","Tester - Terminal & Zone Substations",null,"Tester - Terminal & Zone Subst",1,null,{"$f":"IF(F9>0,F9+365,0)","v":"00:00:00"}]
[null,"HV Switching Operator - Distribution",null,"HV Switching Operator - Distri",1,null,"00:00:00"]
[null,"HV Switching Operator - Terminal & Zone Substations ",null,"HV Switching Operator - Termin",1,null,"00:00:00"]
["Metering","Metering Technician",null,"Metering Technician",1,null,"00:00:00"]
[null,"Asset Inspector",null,"Asset Inspector",1,null,"00:00:00"]
[null,"Auditor - General",null,"Auditor - General",1,null,"00:00:00"]
[null,"Auditor - Underground",null,"Auditor - Underground",1,null,"00:00:00"]
[null,"Cable Hauler",null,"Cable Hauler",1,null,"00:00:00"]
[null,"Civil Worker",null,"Civil Worker",1,null,"00:00:00"]
["Communications Worker","Communications Worker - HV LV Enclosures",null,"Communications Worker - HV LV",1,null,"00:00:00"]
["Communications Worker","Communications Worker - Pole Work",null,"Communications Worker - Pole W",1,null,"00:00:00"]
["Communications Worker","Communications Worker - Tower",null,"Communications Worker - Tower",1,null,"00:00:00"]
["Communications Worker","Communications Worker - Underground Work",null,"Communications Worker - Underg",1,null,"00:00:00"]
[null,"Electrical Inspector",null,"Electrical Inspector",1,null,"00:00:00"]
[null,"No Go Zone Assessor",null,"No Go Zone Assessor",1,null,"00:00:00"]
["Plant Operator","Plant Operator - ESI Worker",null,"Plant Operator - ESI Worker",1,null,"00:00:00"]
["Plant Operator","Plant Operator - Day Hire",null,"Plant Operator - Day Hire",1,null,"00:00:00"]
[null,"Rigger - General",null,"Rigger - General",1,null,"00:00:00"]
[null,"Rigger - Towers",null,"Rigger - Towers",1,null,"00:00:00"]
[null,"Supervisor  Team Leader",null,"Supervisor  Team Leader",1,null,"00:00:00"]
[null,"Technical Officer/Maint Worker",null,"Technical OfficerMaint Worker",1,null,"00:00:00"]
[null,"Trade Assistant",null,"Trade Assistant",null,null,"00:00:00"]