{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Cert","Truck and Dog","A-Double","B-Double","PM and Semi","Road Train","Bus","Other","AD Trailer Sets","BD Trailer Sets","TD Trailer Sets","Truck and Pig","Comb Mtrx","Rev Tble","Index","User Guide","Make"],"not_rendered":{"charts":0,"images":4,"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":"Cert","index":0,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[[11,1,11,2],[13,1,13,2],[15,1,15,2],[39,1,39,7],[21,1,21,2],[22,1,23,7],[24,1,27,7],[51,1,55,7],[41,3,41,4],[45,1,45,2],[32,1,32,2],[34,1,34,2],[41,1,41,2],[43,1,43,2]]}
[]
[]
[null,"Performance Based Standards"]
[]
[null,"Certifier's Certificate"]
[null,"Heavy Vehicle National Law S23"]
[null,"Heavy Vehicle (General) National Regulation S13"]
[]
[]
[null,"Step 1  |  Application details"]
[]
[null,"Application Number"]
[]
[null,"DA Number"]
[]
[null,"Variation/Amend"]
[]
[null,"Certifier Job Number"]
[]
[null,"Previous VA number"]
[]
[null,"Comments"]
[null,"<auto-generated comment>"]
[]
[null,"<type additional comments here>"]
[]
[]
[]
[]
[]
[null,"Step 2  |  VIN's and Combination Matrix"]
[]
[null,"Vehicle"]
[]
[null,"Combination Matrix"]
[]
[]
[null,"Step 3  |  Declaration"]
[]
[null,"By submitting this application, I hereby certify that the information in this Vehicle Approval application and the attached Certifier’s Certificate any supporting documents are true and correct.  Giving false and misleading information is a serious offence (Section 702 of the Heavy Vehicle National Law). Penalties apply."]
[]
[null,"Certifier Name"]
[]
[null,"Accreditation Number"]
[]
[null,"Date"]
[]
[]
[null,"© National Heavy Vehicle Regulator"]
[]
[null,"Disclaimer"]
[null,"The NHVR is collecting your personal information to issue a PBS Vehicle Approval under Chapter 1 of the Heavy Vehicle National Law and Section 13 of the Heavy Vehicle (General) National Regulation. We are authorised under this Act to collect information we reasonably require to decide this application. \nWe may disclose protected information contained in your application for the purposes set out in section 727 of the Act to an entity (including a private or public sector entity) identified in that section. This can include disclosure to an authorised employee or agent of the entity. We may disclose protected information to a law enforcement agency, including a service provider authorised to enforce the Heavy Vehicle National Law nationally. A police agency may disclose protected information disclosed to or otherwise held by it to another police agency authorised to hold protected information."]
[]
[]
[]
[]
[]
[null,"Version 2.4","2024-11-25"]
[null,"-","Fixed the issue where the 'Add to Index' function was not capturing the date"]
[null,"-","Fixed the issue where the existing Comb Matrix was wiped when re-running 'Generate Trailer Sets' or 'Generate CM'"]
[null,"-","Added a hyperlink from the Vehicle Sheet to the Index sheet for easier navigation"]
[null,"-","Added option to bulk bold or unbold all VIN's"]

{"sheet":"Truck and Dog","index":1,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":true,"merged":[[15,2,15,4],[14,1,14,2],[20,2,20,4],[19,1,19,2],[0,1,0,5],[1,1,2,2],[6,1,6,2],[8,1,10,5],[1,4,1,5],[2,4,2,5]]}
[]
[null,"Truck and Dog",null,"Truck"]
[null,null,null,"Dog",null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"Truck",null,null,null,"Table Number"]
[null,{"$f":"IF(B15=\"Truck\",\"1\",\"\")&IF(B15=\"Dog Trailer\",\"2/3\",\"\")&IF(B15=\"Dolly\",\"2\",\"\")&IF(B15=\"Semitrailer\",\"3\",\"\")","v":"1"},"<label>",null,null,"<wb>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B15=\"Truck\",\"GCM (t)\",\"ATM (t)\")","v":"GCM (t)"},null,"6.5t","Chk","Lift","Rmv"]
[null,1]
[]
[null,"Dog Trailer",null,null,null,"Table Number"]
[null,{"$f":"IF(B20=\"Truck\",\"1\",\"\")&IF(B20=\"Dog Trailer\",\"2/3\",\"\")&IF(B20=\"Dolly\",\"2\",\"\")&IF(B20=\"Semitrailer\",\"3\",\"\")","v":"2/3"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B20=\"Truck\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]

{"sheet":"A-Double","index":2,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":true,"merged":[[15,2,15,4],[14,1,14,2],[0,1,0,5],[6,1,6,2],[1,1,2,2],[1,4,1,5],[2,4,2,5],[8,1,10,5],[20,2,20,4],[19,1,19,2],[25,2,25,4],[24,1,24,2],[30,2,30,4],[29,1,29,2]]}
[]
[null,"A-Double",null,"PM"]
[null,null,null,"TS",null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"Prime Mover",null,null,null,"Table Number"]
[null,{"$f":"IF(B15=\"Prime Mover\",\"1\",\"\")&IF(B15=\"Lead Trailer\",\"2\",\"\")&IF(B15=\"Dolly\",\"3\",\"\")&IF(B15=\"Rear Trailer\",\"4\",\"\")&IF(B15=\"Lead/Rear Trailer\",\"2/4\",\"\")&IF(B15=\"Dog Trailer\",\"3/4\",\"\")","v":"1"},"<label>",null,null,"<wb>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B15=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"GCM (t)"},null,"6.5t","Chk","Lift","Rmv"]
[null,1]
[]
[null,"Lead Trailer",null,null,null,"Table Number"]
[null,{"$f":"IF(B20=\"Prime Mover\",\"1\",\"\")&IF(B20=\"Lead Trailer\",\"2\",\"\")&IF(B20=\"Dolly\",\"3\",\"\")&IF(B20=\"Rear Trailer\",\"4\",\"\")&IF(B20=\"Lead/Rear Trailer\",\"2/4\",\"\")&IF(B20=\"Dog Trailer\",\"3/4\",\"\")","v":"2"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B20=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]
[]
[null,"Dolly",null,null,null,"Table Number"]
[null,{"$f":"IF(B25=\"Prime Mover\",\"1\",\"\")&IF(B25=\"Lead Trailer\",\"2\",\"\")&IF(B25=\"Dolly\",\"3\",\"\")&IF(B25=\"Rear Trailer\",\"4\",\"\")&IF(B25=\"Lead/Rear Trailer\",\"2/4\",\"\")&IF(B25=\"Dog Trailer\",\"3/4\",\"\")","v":"3"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B25=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]
[]
[null,"Rear Trailer",null,null,null,"Table Number"]
[null,{"$f":"IF(B30=\"Prime Mover\",\"1\",\"\")&IF(B30=\"Lead Trailer\",\"2\",\"\")&IF(B30=\"Dolly\",\"3\",\"\")&IF(B30=\"Rear Trailer\",\"4\",\"\")&IF(B30=\"Lead/Rear Trailer\",\"2/4\",\"\")&IF(B30=\"Dog Trailer\",\"3/4\",\"\")","v":"4"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B30=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]

{"sheet":"B-Double","index":3,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[25,2,25,4],[24,1,24,2],[8,1,9,5],[0,1,0,5],[1,1,2,2],[1,4,1,6],[2,4,2,6],[6,1,6,2],[15,2,15,4],[14,1,14,2],[20,2,20,4],[19,1,19,2],[12,1,12,5]]}
[]
[null,"B-Double",null,"PM"]
[null,null,null,"TS",null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"Prime Mover",null,null,null,"Table Number"]
[null,{"$f":"IF(B15=\"Prime Mover\",\"1\",\"\")&IF(B15=\"Lead Trailer\",\"2\",\"\")&IF(B15=\"Rear Trailer\",\"3\",\"\")","v":"1"},"<label>",null,null,"<wb>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B15=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"GCM (t)"},null,"6.5t","Chk","Lift","Rmv"]
[null,1]
[]
[null,"Lead Trailer",null,null,null,"Table Number"]
[null,{"$f":"IF(B20=\"Prime Mover\",\"1\",\"\")&IF(B20=\"Lead Trailer\",\"2\",\"\")&IF(B20=\"Rear Trailer\",\"3\",\"\")","v":"2"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B20=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]
[]
[null,"Rear Trailer",null,null,null,"Table Number"]
[null,{"$f":"IF(B25=\"Prime Mover\",\"1\",\"\")&IF(B25=\"Lead Trailer\",\"2\",\"\")&IF(B25=\"Rear Trailer\",\"3\",\"\")","v":"3"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B25=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]

{"sheet":"PM and Semi","index":4,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":true,"merged":[[20,2,20,4],[19,1,19,2],[15,2,15,4],[14,1,14,2],[0,1,0,5],[1,1,2,2],[6,1,6,2],[1,4,1,5],[2,4,2,5],[8,1,10,5]]}
[]
[null,"PM and Semi",null,"PM"]
[null,null,null,"Semi",null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"Prime Mover",null,null,null,"Table Number"]
[null,{"$f":"IF(B15=\"Prime Mover\",\"1\",\"\")&IF(B15=\"Semitrailer\",\"2\",\"\")","v":"1"},"<label>",null,null,"<wb>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B15=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"GCM (t)"},null,"6.5t","Chk","Lift","Rmv"]
[null,1]
[]
[null,"Semitrailer",null,null,null,"Table Number"]
[null,{"$f":"IF(B20=\"Prime Mover\",\"1\",\"\")&IF(B20=\"Semitrailer\",\"2\",\"\")","v":"2"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B20=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]

{"sheet":"Road Train","index":5,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":true,"merged":[[8,1,10,5],[0,1,0,5],[1,1,2,2],[6,1,6,2],[1,4,1,5],[2,4,2,5]]}
[]
[null,null,null,"PM"]
[null,null,null,"TS",null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]

{"sheet":"Bus","index":6,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":true,"merged":[[15,2,15,4],[14,1,14,2],[0,1,0,5],[1,1,2,2],[6,1,6,2],[1,4,1,5],[8,1,10,5]]}
[null,null,null,null,null,null,null,null,null,null,"Insert blank VIN Table"]
[null,"Bus",null,"Bus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"Bus",null,null,null,"Table Number"]
[null,{"$f":"IF(B15=\"Bus\",\"1\",\"\")","v":"1"},"<label>",null,null,"<wb>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B15=\"Bus\",\"GCM (t)\",\"ATM (t)\")","v":"GCM (t)"},null,"6.5t","Chk","Lift","Rmv"]
[null,1]

{"sheet":"Other","index":7,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":true,"merged":[[8,1,10,5],[15,2,15,4],[14,1,14,2],[0,1,0,5],[1,1,2,2],[6,1,6,2],[1,4,1,5],[2,4,2,5]]}
[]
[null,"Other",null,"Lead"]
[null,null,null,"TS/Trailer",null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"Prime Mover",null,null,null,"Table Number"]
[null,{"$f":"IF(B15=\"Prime Mover\",\"1\",\"\")&IF(B15=\"Truck\",\"1\",\"\")&IF(B15=\"Trailer\",\"2\",\"\")&IF(B15=\"Dolly\",\"3\",\"\")","v":"1"},"<label>",null,null,"<wb>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B15=\"Prime Mover\",\"GCM (t)\",\"ATM (t)\")","v":"GCM (t)"},null,"6.5t","Chk","Lift","Rmv"]
[null,1]

{"sheet":"AD Trailer Sets","index":8,"n_rows":3,"n_cols":49,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,31,1,33],[1,36,1,38],[1,41,1,43],[1,46,1,48],[1,1,1,3],[1,6,1,8],[1,11,1,13],[1,16,1,18],[1,21,1,23],[1,26,1,28]]}
[]
[]
["TS","Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear",null,null,"Lead","Dolly","Rear"]

{"sheet":"BD Trailer Sets","index":9,"n_rows":4,"n_cols":39,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,25,1,26],[1,29,1,30],[1,33,1,34],[1,37,1,38],[1,1,1,2],[1,5,1,6],[1,9,1,10],[1,13,1,14],[1,17,1,18],[1,21,1,22]]}
["BD Trailer Sets"]
[]
["TS","Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear",null,null,"Lead","Rear"]
[1]

{"sheet":"TD Trailer Sets","index":10,"n_rows":4,"n_cols":39,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,25,1,26],[1,29,1,30],[1,33,1,34],[1,37,1,38],[1,1,1,2],[1,5,1,6],[1,9,1,10],[1,13,1,14],[1,17,1,18],[1,21,1,22]]}
["TD Trailer Sets"]
[null,"Dog 1",null,null,null,"Dog 2",null,null,null,"Dolly 1"]
["TS","Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer",null,null,"Dolly","Trailer"]
[1,"Dog 1","Dog 1","c",2,"Dog 2","Dog 2",null,3,"Dolly 1","Semi 1","c"]

{"sheet":"Truck and Pig","index":11,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":true,"merged":[[20,2,20,4],[19,1,19,2],[15,2,15,4],[14,1,14,2],[8,1,10,5],[0,1,0,5],[1,1,2,2],[6,1,6,2],[1,4,1,5],[2,4,2,5]]}
[]
[null,"Truck and Pig",null,"Truck"]
[null,null,null,"Pig",null,null,null,null,null,null,null,null,null,null,null,"number of rows in blank VIN table"]
[]
[null,null,null,null,"Combination Matrix"]
[]
[null,"Certification Revision Table"]
[]
[]
[]
[]
[]
[]
[]
[null,"Truck",null,null,null,"Table Number"]
[null,{"$f":"IF(B15=\"Truck\",\"1\",\"\")&IF(B15=\"Pig Trailer\",\"2\",\"\")","v":"1"},"<label>",null,null,"<wb>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B15=\"Truck\",\"GCM (t)\",\"ATM (t)\")","v":"GCM (t)"},null,"6.5t","Chk","Lift","Rmv"]
[null,1]
[]
[null,"Pig Trailer",null,null,null,"Table Number"]
[null,{"$f":"IF(B20=\"Truck\",\"1\",\"\")&IF(B20=\"Pig Trailer\",\"2\",\"\")","v":"2"},"<label>",null,null,"<s-dim>"]
[null,"N","VIN","Make","Model",{"$f":"IF(B20=\"Truck\",\"GCM (t)\",\"ATM (t)\")","v":"ATM (t)"},null,null,"Chk","Lift","Rmv"]
[null,1]

{"sheet":"Comb Mtrx","index":12,"n_rows":6,"n_cols":20,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"source"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"filter 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"filter 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"filter 3"]

{"sheet":"Rev Tble","index":13,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N","DATE","JOB NUMBER","COMMENT"]

{"sheet":"Index","index":14,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N","VIN","label","action","job number","date"]

{"sheet":"User Guide","index":15,"n_rows":170,"n_cols":6,"rows_kept":170,"cut":false,"hidden":false,"merged":[[143,2,143,4],[24,1,24,2],[25,2,25,4],[117,1,118,1],[124,1,125,1],[135,2,135,4]]}
[]
[null,"Quick User Guide"]
[]
[1,"How to use this template"]
[null,1,"Start at 'Cert' sheet"]
[null,null,"Fill out the form and press 'get template' button"]
[null,2,"Fill out VIN's in the vehicle template"]
[null,3,"Run 'check VINs'"]
[null,4,"Make sure you are happy with cert revision table comment and press the 'add comment' button"]
[null,5,"Check auto-generated Index and press 'add to Index'"]
[null,4,"Generate Trailer Sets (for ad and bd, and truck and dog containing dolly and semitrailers)"]
[null,5,"Select Trailer Sets"]
[null,6,"Fill out Combination Matrix"]
[null,7,"Drag and drop drawing file name into the Combination Matrix"]
[]
[2,"Do I need to physically sign the Certificate?"]
[null,"No, by submitting the certificate you declare that the information contained in the Certificate is true and correct."]
[]
[3,"New VINs"]
[null,"New VIN's added to the certificate are to be highlighted in bold font"]
[null,"There's no change to this rule - as per current practice"]
[]
[4,"VIN table"]
[]
[null,"Unit name (select from a drop-down)",null,null,"<Table Number>","(table number, inserted automatically by the 'check VIN's' macro)"]
[null,"unit pos","<label> (type label here)"]
[null,"N","VIN","Make Model","GCM"]
[null,1,"6F500000050000032",null,"(t)"]
[]
[null,"unit pos","is the unit's position in a vehicle combination"]
[null,null,"unit pos is auto-populated by a formula based on the 'Unit name' selection"]
[null,null,"for example, 1 for Truck or PM, 2 for Semitrailer in a pm and semi combination"]
[null,"GCM","must be listed in tonnes"]
[null,"New VIN's","new VIN's must be listed in bold font"]
[null,null,"VIN's listed in bold must not be marked as removed ('Rmv' column)"]
[null,"Old VIN's","old VIN's must be listed in regular font (not bold)"]
[null,null,"VIN's listed in regular font can be marked as removed ('Rmv' column)"]
[]
[null,"VINs with identical specs"]
[null,"If a list of VIN's have identical specs i.e., same make model, GCM/ATM, 6.5t compliance"]
[null,"It is acceptable to only fill out the top row, meaning that the rest of the list is the same."]
[]
[5,"Other columns"]
[]
[null,"6.5t","Chk","Lift","Rmv"]
[null,"(1)","(2)","(3)","(4)"]
[]
[null,"(1)","select 'Y' from the drop-down if the pm/truck complies with 6.5t steer axle requirements"]
[null,null,"vehicles that are grouped under the same label (listed in the same table) must all comply with the 6.5t steer requirements"]
[null,null,"it's not permitted to have a mix of compliant and non-compliant pms/trucks in one table"]
[null,null,"non 6.5t compliant pms/trucks must be separated into a different table and use a separate label"]
[null,null,"this is because these combinations will require separate mass tables (with 6.5t and with 6.0t)"]
[null,"(2)","after you run 'check VIN's' - VIN character count will be inserted this column"]
[null,null,"valid VIN character count must equal 17 and must not contain any spaces"]
[null,"(3)","select 'Y' from the drop-down if the vehicle contains lift axles"]
[null,"(4)","select 'Y' from the drop-down if the VIN is being removed from the certificate"]
[]
[6,"Why is VIN red?"]
[null,"VIN is highlighted red if it contains prohibited characters - \"I\", \"O\", \"Q\""]
[null,"These characters are not allowed in a VIN"]
[null,null,"1FVJAWDR1FLGP373O"]
[]
[7,"Why is VIN cell yellow?"]
[null,"Cells that contain duplicate VIN's are highlighted with a yellow fill colour"]
[null,null,"1FVJAWDR1FLGP3731"]
[null,null,"1FVJAWDR1FLGP3731"]
[]
[8,"Why is 'Chk' red?"]
[null,"The number in 'Chk' column is highlighted red if VIN character count doesn’t equal 17"]
[null,"A valid VIN must contain 17 characters"]
[null,"Chk"]
[null,18]
[]
[9,"check VIN's' button"]
[null,"- refreshes the formatting of all VIN tables"]
[null,"- inserts conditional formatting to highlight duplicate VIN's (yellow fill colour)"]
[null,"- checks VIN's character count and inserts conditional formatting if VIN character counter does not equal 17"]
[null,"- removes spaces in VINs - VIN must not contain any spaces"]
[null,"- populates 'VIN Count' table"]
[null,"- populates 'VIN Count - Total' table"]
[null,"- populates 'Combination Count' table"]
[]
[10,"What is the difference between 'VIN Count' and 'VIN Count - Total'?"]
[null,"'VIN Count' - counts VINs in each certification table (for each table or vehicle label)"]
[null,"'VIN Count - Total' - counts VINs for each vehicle position"]
[null,"'VIN Count - Total' - is a more compact summary of 'VIN Count' table"]
[]
[11,"How does VIN Count work?"]
[null,"VIN count' - counts old (existing VIN's not in bold) and new (VIN's in bold) for each VIN table"]
[null,"and presents it in a summary table"]
[]
[12,"How does Combination Count work?"]
[null,"'Combination Count' - counts potential number of combinations that can be made up based on the number of VIN's in each position"]
[null,"For each unit position (i.e., for an a-double it'll be 1, 2, 3, 4 - pm, lead, dolly, rear) it counts the number of vins that can be used in that position"]
[null,"Counts old (existing VIN's not in bold) and new (VIN's in bold)"]
[null,"Number of possible new combinations added is calculated by subtracting the old number of combination from the total number of possible combinations (last column)"]
[null,"The combination count is a possible number of new combinations because it doesn't take into account Trailer Set and Compatibility Matrix"]
[null,"Tt assumes that all vehicle units are compatible - therefore it is a 'possible' number of combinations"]
[]
[13,"How to insert rows into a VIN table?"]
[null,"To insert additional rows into a VIN table - insert rows how you normally would in an Excel workbook"]
[null,"Right click - and select 'Entire Row'"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[14,"Combination Matrix Legend"]
[null,"<variant> name in the top cell"]
[null,"dwg file name in the bottom cell"]
[]
[null,null,"TS 1"]
[null,"PM 1","<variant>"]
[null,null,"dwg file"]
[]
[null,"If PM and Trailer are not compatible, type \"NA\" in <variant cell"]
[null,"The cells will be automatically greyed-out"]
[]
[null,null,"TS 1"]
[null,"PM 1","NA"]
[]
[]
[15,"What is 'Index' sheet?"]
[null,"Index sheet contains a list of all VIN's along with the date and certification job number when it was added"]
[]
[16,"Selecting Trailer Sets"]
[null,"For a-double and b-double combinations, you'll need to first 'Generate Trailer Sets' and then 'Select Trailer Sets'"]
[null,"On the Trailer Sets sheet, put any character to indicate a selection - see below:"]
[]
[null,"AD Trailer Sets"]
[null,null,"Lead 1"]
[null,"TS","Lead","Dolly","Rear"]
[null,1,"Lead 1","Dolly 1","Rear 1","x"]
[null,2,"Lead 1","Dolly 1","Rear 2","x"]
[]
[null,"If you wish the TS to be arranged in a particular order - enter numbers instead of a character:"]
[]
[null,"AD Trailer Sets"]
[null,null,"Lead 1"]
[null,"TS","Lead","Dolly","Rear"]
[null,1,"Lead 1","Dolly 1","Rear 1",2]
[null,2,"Lead 1","Dolly 1","Rear 2"]
[null,3,"Lead 1","Dolly 2","Rear 1",1]
[null,4,"Lead 1","Dolly 2","Rear 2"]
[]
[null,"You can click 'Select All' to select all Trailer Sets"]
[]
[17,"Trailer Sets for Truck and Dog combinations"]
[null,"Trailer Sets for Truck and Dog combinations are not required unless there are separate dollies and semitrailers that can make-up Trailer Sets"]
[null,"If there are only Dog trailers, please proceed to generate Combination Matrix using the 'Generate CM' button"]
[]
[18,"Road Train"]
[null,"For Road Train combinations, you'll need to select the specific type of combination in cell shown below:"]
[]
[]
[]
[]
[]
[]
[null,"Combination count is not available for Road Train combinations"]
[null,"Generate 'Trailer Sets' is also not available, you'll need to do this step manually"]
[]
[19,"Axle configuration for Road Train"]
[null,"For PM, select axle configuration from the drop down"]
[null,"For Trailer Set, type axle configuration manually - example for B-Triple - '(3-3-3)'"]

{"sheet":"Make","index":16,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Make","Abbreviation"]
["Caterpillar","CAT"]
["Cummins ","CUM"]
["DAF","DAF"]
["Daysworth ","DAY"]
["Diamond Reo","DIA"]
["ERF ","ERF"]
["Ford","FOR"]
["Freightliner ","FRL"]
["Fuso","FUS"]
["Hino","HIN"]
["International","INT"]
["Isuzu","ISU"]
["Iveco","IVE"]
["Kenworth","KW"]
["Mack","MAC"]
["MAN","MAN"]
["Mercedes-Benz","MB"]
["Mitsubishi","MIT"]
["Nissan","NIS"]
["Peterbilt","PET"]
["Scania","SCA"]
["Sinotruk","SIN"]
["Sterling","STE"]
["UD","UD"]
["Volvo","VOL"]
["Western Star ","WS"]