{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Setup","Design Approval application","Vehicle Approval application","REPORT","Lists","Identical-Footprint","Variation Amend Info","Template Info","Change Log"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":168,"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":"Setup","index":0,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                       Setup instructions"]
[]
[]
[]
[null,"Step 1"]
[null,"Visit the NHVR Developer Portal to obtain an API subscription key:",null,null,{"$f":"developerPortalUrl","v":"https://api-portal.nhvr.gov.au"}]
[]
[]
[null,"Step 2"]
[null,"Enter the 'API subscription key' into the box below and click 'Save API Key'."]
[null,"API Subscription Key"]
[null,"***************"]
[]
[null,"The key will be saved into a file named 'API_KEY_DO_NOT_SHARE.txt' in the same folder as this spreadsheet."]
[]
[]
[null,"Note: If you copy and share this spreadsheet please ensure you DO NOT share the API Key file."]
[null,"For help or technical support you can reach us at: digital@nhvr.gov.au"]
[null,{"$f":"releaseName","v":"PBS-Submission-Tool v2.3.0 (25-Sep-21)"},"©2021 National Heavy Vehicle Regulator"]
[]
[]
[]
[]
[null,"Advanced settings"]
[null,"These settings should not be changed."]
[]
[null,"Environment (select)",null,"Version status",null,"This version",null,"Latest version"]
[null,"PROD",null,{"$f":"IF(thisVersionDate >= latestVersionDate, \"Current\", \"Old\")","v":"Current"},null,"2.3.0",null,{"$f":"INDIRECT(\"'Change Log'!B9\")","v":"2.3.0"}]
[]
[null,null,null,null,null,"This version release date",null,"Latest version release date"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(thisVersion, releaseTable[],2,FALSE),\"\")","v":"2021-09-25T10:07:00"},null,{"$f":"INDIRECT(\"'Change Log'!c9\")","v":"2021-09-25T10:07:00"}]
[]
[null,"Account name",null,"Account Id",null,"Archive date",null,"Archived"]
[null,"BISITECNIKS PTY. LTD.",null,2,null,{"$f":"IFERROR(VLOOKUP(thisVersion, releaseTable[],4,FALSE),\"\")","v":"00:00:00"},null,{"$f":"IFERROR(VLOOKUP(thisVersion, releaseTable[],5,FALSE), FALSE)","v":false}]
[]
[null,"Token",null,"Account Type",null,"API Subscription Key filename",null,"Update Url"]
[null,"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQ1MzYxIiwiZmlyc3ROYW1lIjoiS2VuIiwibmFtZSI6IkNvd2VsbCIsImVtYWlsIjoia2VuQGtkY293ZWxsYXNzb2MuY29tLmF1IiwidXNlckltYWdlVXJsIjoiIiwiYWNjb3VudE5hbWUiOiJIIENPV0VMTCAmIEsuRCBDT1dFTEwiLCJhY2NvdW50VHlwZSI6InByb3ZpZGVyIiwiYWNjb3VudElkIjo2LCJpZFZlcmlmaWVkIjpmYWxzZSwiYXBpRW5hYmxlZCI6dHJ1ZSwiYWNjb3VudEltYWdlVXJsIjoiIiwiYWNjb3VudENvdW50IjoxLCJyb2xlcyI6WyJwcm92aWRlckFjY291bnRBZG1pbiIsInByb3ZpZGVyQWNjZXNzRGlzYWJsZWQiLCJwcm92aWRlckFjY3JlZGl0YXRpb25TdWJtaXR0ZXIiLCJwcm92aWRlclZTU3VibWl0dGVyIiwicHJvdmlkZXJQQlNTdWJtaXR0ZXIiLCJwcm92aWRlclJlZ2lzdHJhdGlvbkVuYWJsZWQiLCJwcm92aWRlckNvbXBsaWFuY2VEaXNhYmxlZCJdLCJpcCI6IjQwLjEyNi4yNDQuNzEiLCJ0aGlyZFBhcnR5VG9rZW5zIjpbeyJuYW1lIjoiaW50ZXJjb20iLCJ0b2tlbiI6IjU4NmRiZTg3MTY4YmJjOTNmZmY3NGNiNjBiYjJhOGQwNTUxYTA0MmUzOTVhYjNmYWM0ODA3ZmE2NjQ1NWYxYmYifV0sImlhdCI6MTYzMjQ0MzgyOSwiZXhwIjoxNjMyNDQ0MTI5fQ.fC1jC8Ws1U6fifm0sX31YgHPOO_UIIc1DEvFFVTyr1Q",null,"provider",null,"API_KEY_DO_NOT_SHARE.txt",null,{"$f":"IFERROR(VLOOKUP(latestVersion, releaseTable[],6,FALSE),\"\")","v":"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V2.3.0.xlsm"}]
[]
[null,"Warning text",null,"Show warning",null,"NHVR Developer Portal URL",null,"NHVR API URL"]
[null,"WARNING >> This form connects and submits to the test environment (UAT)",null,{"$f":"environment = \"UAT\"","v":false},null,{"$f":"IF(environment=\"UAT\", \"https://api-portal-uat.nhvr.gov.au\", \"https://api-portal.nhvr.gov.au\")","v":"https://api-portal.nhvr.gov.au"},null,{"$f":"IF(environment = \"UAT\", \"https://api-public-uat.nhvr.gov.au\", \"https://api-public.nhvr.gov.au\")","v":"https://api-public.nhvr.gov.au"}]
[null,"UPDATE >> A new version is now available",null,{"$f":"versionStatus = \"Old\"","v":false}]
[null,"WARNING >> This version is no longer supported",null,{"$f":"versionArchived","v":false}]
[]
[null,{"$f":"IF(showUnsupported, unsupportedWarningText, IF(showUpdate, updateWarningText, IF(showUat,uatWarningText, \"\")))","v":""},null,{"$f":"OR(showUat,showUpdate,showUnsupported)","v":false}]

{"sheet":"Design Approval application","index":1,"n_rows":105,"n_cols":10,"rows_kept":105,"cut":false,"hidden":false,"merged":[[41,5,41,7],[42,5,109,7],[105,1,109,3],[42,9,109,11],[102,1,102,3]]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                     Design Approval application"]
[]
[]
[null,"Assessor details",null,null,null,"Application details"]
[]
[null,"Assessor Name  (required)",null,"Accreditation Number (required) digits only","pbsCertifierId (hide field)","Application Nickname",null,"Application Id",null,"Application Type"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B9,pbsAssessor[],2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,pbsAssessor[],3,FALSE), \"\")","v":""},"",null,null,null,"Design Approval"]
[]
[null,"Applicant details"]
[]
[null,"ABN  (required - 11 digits)"]
[]
[null,"Company name (required)",null,"",null,"Applicant type (required)\nSelect from dropdown menu",null,""]
[]
[]
[null,"Applicant address (physical)",null,null,null,"Postal address"]
[]
[null,"Street (required)",null,null,null,"Street (required)"]
[]
[null,"Suburb (required)",null,null,null,"Suburb (required)"]
[]
[null,"State (required - select)",null,null,null,"State (required - select)"]
[]
[null,"Postcode (required)",null,"",null,"Postcode (required)",null,""]
[]
[null,"Applicant contact",null,null,null,"Contact person address"]
[]
[null,"Contact first name  (required)",null,null,null,"Street (required)"]
[]
[null,"Contact last name  (required)",null,null,null,"Suburb (required)"]
[]
[null,"Email (required)",null,null,null,"State (required)"]
[]
[null,"Phone number ",null,"",null,"Postcode (required)",null,""]
[]
[]
[]
[]
[null,"Assessment\ndetails",null,null,null,"Upload application\nattachments"]
[]
[null,"Asessor Job Number",null,""]
[]
[null,"Design approval type (required)\nSelect from dropdown menu"]
[null,null,null,"What is Amend/Variation?"]
[]
[null,"Pre-advised Design Approval application"]
[]
[null,"Design Application No","V"]
[]
[null,"Variation Summary 1\nSelect from dropdown menu"]
[null,"Variation Summary 2\nSelect from dropdown menu"]
[null,"Variation Summary 3\nSelect from dropdown menu"]
[null,"Variation Summary 4\nSelect from dropdown menu"]
[]
[null,"Vehicle details"]
[]
[null,"Combination type (required)\nSelect from dropdown menu",null,""]
[]
[null,"Hauling Unit (required)\nSelect from dropdown menu",null,""]
[]
[null,"Towed Unit (required)\nSelect from dropdown menu",null,""]
[]
[null,"Body type 1 (required)\nSelect from dropdown menu",null,""]
[null,"Body type 2\nSelect from dropdown menu",null,""]
[null,"Body type 3\nSelect from dropdown menu",null,""]
[null,"Body type 4\nSelect from dropdown menu",null,""]
[]
[null,"Load Type 1 (required)\nSelect from dropdown menu",null,""]
[null,"Load Type 2\nSelect from dropdown menu",null,""]
[null,"Load Type 3\nSelect from dropdown menu",null,""]
[null,"Load Type 4\nSelect from dropdown menu",null,""]
[]
[null,"PBS Access - Entry 1"]
[]
[null,"Level (required)\nSelect from dropdown menu",null,""]
[]
[null,"Bridge (required)\nSelect from dropdown menu",null,""]
[]
[null,"Length (required)",null,null,"mm"]
[]
[null,"Width (required)",null,null,"mm"]
[]
[null,"Height (required)",null,null,"mm"]
[]
[null,"Mass (required)",null,null,"kg"]
[]
[null,"PBS Access - Entry 2 (optional)"]
[]
[null,"Level",null,""]
[]
[null,"Bridge",null,""]
[]
[null,"Length",null,null,"mm"]
[]
[null,"Width",null,null,"mm"]
[]
[null,"Height",null,null,"mm"]
[]
[null,"Mass",null,null,"kg"]
[]
[null,"NOTE: If applying for more than two PBS levels, please limit the Portal entry to two worst case levels and provide the full information in the Part A."]
[]
[null,"Comments"]

{"sheet":"Vehicle Approval application","index":2,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[[82,1,86,3],[41,5,41,7],[42,5,86,7],[42,9,86,11]]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                     Vehicle Approval application"]
[]
[]
[null,"Certifier details",null,null,null,"Application details"]
[]
[null,"Certifier Name  (required)",null,"Accreditation Number (required) digits only","pbsCertifierId (hide field)","Application Nickname",null,"Application Id",null,"Application Type"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B9,pbsCertifier[],2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,pbsCertifier[],3,FALSE), \"\")","v":""},"",null,null,null,"Vehicle Approval"]
[]
[null,"Operator details"]
[]
[null,"ABN  (required - 11 digits)"]
[]
[null,"Company name (required)",null,""]
[]
[]
[null,"Operator address (physical)",null,null,null,"Postal address"]
[]
[null,"Street (required)",null,null,null,"Street (required)"]
[]
[null,"Suburb (required)",null,null,null,"Suburb (required)"]
[]
[null,"State (required - select)",null,null,null,"State (required - select)"]
[]
[null,"Postcode (required)",null,"",null,"Postcode (required)",null,""]
[]
[null,"Operator contact",null,null,null,"Contact person address"]
[]
[null,"Contact first name  (required)",null,null,null,"Street"]
[]
[null,"Contact last name  (required)",null,null,null,"Suburb"]
[]
[null,"Email (required)",null,null,null,"State"]
[]
[null,"Phone number ",null,"",null,"Postcode",null,""]
[]
[]
[]
[]
[null,"Certification\ndetails",null,null,null,"Upload application\nattachments"]
[]
[null,"Certification Job Number (required)",null,""]
[]
[null,"Certification method (required)\nSelect from dropdown menu"]
[]
[null,"Design application number (required)","V"]
[]
[null,"Variation / Amendment\nSelect from dropdown menu"]
[null,null,null,"What is Amend/Variation?"]
[]
[null,"Variation / Amendment number \n(digits only)",null,""]
[]
[null,"Combination Type",null,""]
[]
[null,"Certification type (required)\nSelect from dropdown menu"]
[]
[null,"Certificate type - Adding\nSelect from dropdown menu"]
[null,null,null,"What is Identical-Footprint vehicle?"]
[]
[null,"Adding vehicles (required - digits only)"]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"Adding vehicles (truck/pm/bus)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"x  truck/pm/bus\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"Adding vehicles (trailer)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"x  trailer\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"Adding vehicles (dolly)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"x  dolly\")","v":""}]
[]
[null,"Certificate type - Removing\nSelect from dropdown menu"]
[]
[null,"Removing vehicles (required - digits only)"]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"Removing vehicles (truck/pm/bus)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"x  truck/pm/bus\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"Removing vehicles (trailer)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"x  trailer\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"Removing vehicles (dolly)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer\"),\"\",\"x  dolly\")","v":""}]
[]
[null,"Certificate type - Modification\nSelect from dropdown menu"]
[]
[null,"Certificate type - Tyre update\nSelect from dropdown menu"]
[]
[null,"Previous Vehicle Approval Type"]
[null,"Previous Vehicle Approval Number\n(required - select VA or FA and enter 4 digit number)","VA",""]
[]
[null,"Previous Vehicle Approval Version\n(required - up to 2 digits only)","V",""]
[]
[null,"Comments"]

{"sheet":"REPORT","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                         Submission report"]
[]
[]
[]
[null,"Errors"]
[null,"Column1","Message"]

{"sheet":"Lists","index":4,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                         Data lists"]
[]
[]
[]
[null,"Certifiers",null,null,null,"Assessors",null,null,null,"Combination Types",null,"Hauling Units",null,"Towed Units",null,"Load Types",null,"Body Types",null,"Variation Summaries",null,"Accounts"]
[null,"Name","Number","Id",null,"Name","Number","Id",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name",null,"Name","Number","Id"]
[null,null,null,null,null,null,null,null,null,"Bus",null,"1-1",null,"2",null,"DG (Liquid)",null,"Compliant bus",null,"Adding new variant",null,"BISITECNIKS PTY. LTD.","provider",2]
[null,null,null,null,null,null,null,null,null,"Rigid truck",null,"1-2",null,"3",null,"DG (Powder)",null,"Coach",null,"Tyre options updated"]
[null,null,null,null,null,null,null,null,null,"Truck and pig",null,"1-3",null,"1-1",null,"Non-DG (Liquid)",null,"Tanker",null,"Payload heights updated"]
[null,null,null,null,null,null,null,null,null,"Truck and dog",null,"2-2",null,"1-2",null,"Non-DG (Powder)",null,"Van/Curtainsider",null,"Dimensions updated"]
[null,null,null,null,null,null,null,null,null,"Prime mover and semitrailer",null,"2-3",null,"1-3",null,"General Freight (Mixed Freight)",null,"Platform",null,"Tyre options updated"]
[null,null,null,null,null,null,null,null,null,"Prime mover and semitrailer - 2+ axle groups",null,null,null,"2-1",null,"General Freight (Uniform Density)",null,"Bin",null,"Payload heights updated"]
[null,null,null,null,null,null,null,null,null,"A-Double",null,null,null,"2-2",null,"Hanging Loads",null,"Other",null,"Payload dimensions updated"]
[null,null,null,null,null,null,null,null,null,"AB-Double",null,null,null,"2-3",null,"Quarry and Bulk",null,"Logger",null,"Updating FDR and Drive suspension"]
[null,null,null,null,null,null,null,null,null,"B-Double",null,null,null,"3-2",null,"Cars",null,"Skeletal",null,"Other"]
[null,null,null,null,null,null,null,null,null,"Road-train - A-Triple",null,null,null,"3-3",null,"Containers (Uniform Density)",null,"Car Carrier",null,"Adding new variant"]
[null,null,null,null,null,null,null,null,null,"Road-train - B-Triple",null,null,null,"4",null,"Containers (Mixed Freight)",null,"Refrigerator",null,"Tyre options updated"]
[null,null,null,null,null,null,null,null,null,"Road-train - A-Quad",null,null,null,"1-3-1",null,"Containers (Empty)",null,"Livestock",null,"Payload heights updated"]
[null,null,null,null,null,null,null,null,null,"Road-train - B-Quad",null,null,null,"1-2-1",null,"Logs",null,null,null,"Payload height and dimensions updated"]
[null,null,null,null,null,null,null,null,null,"Road-train - AB-Triple",null,null,null,"2-2-2",null,"Woodchip",null,null,null,"Updating FDR and Drive suspension"]
[null,null,null,null,null,null,null,null,null,"Road-train - BA-Triple",null,null,null,"2-2-3",null,"Waste"]
[null,null,null,null,null,null,null,null,null,"Road-train - AAB-Quad",null,null,null,"3-2-2",null,"Livestock"]
[null,null,null,null,null,null,null,null,null,"Road-train - BAB-Quad",null,null,null,"3-2-3",null,"Unladen"]
[null,null,null,null,null,null,null,null,null,"Other",null,null,null,"3-3-2",null,"Public Transport/ People"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3",null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-2-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-3-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-2-3-2-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3-3-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3-3-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-4-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3-3-3-3-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2-2-2-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-2-3-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-4-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2-2-1-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2-2-2-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2-2-3-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3-3-3-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-2-3-3"]

{"sheet":"Identical-Footprint","index":5,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,2,7,11],[16,2,17,11],[24,3,24,4]]}
[]
[]
[null,null,"Identical-Footprint Combination"]
[]
[null,null,"Identical-Footprint means a combination with axle spacings identical to existing combinations."]
[null,null,"There is no tolerance for axle spacings - the new combination's axle spacings must be identical to the existing combinations."]
[null,null,"The overall length can vary provided it remains within the same length bracket - see Table 1."]
[null,null,"In summary, Identical-Footprint combinations must have the same dimensions except for FOH and ROH which can vary provided that the combination remains within the same length bracket as previously approved combinations."]
[]
[null,null,"Identical-Footprint vehicles can vary in specifications:"]
[null,null,null,"Different vehicle components, such as engines, tyres, and suspensions are permitted"]
[null,null,null,"Different bin and payload heights are permitted"]
[]
[null,null,"The VA number will not change if adding Identical-Footprint combinations."]
[null,null,"The existing access permits will not require updating as the VA number will remain the same. "]
[]
[null,null,"If vehicles are Non-Identical-Footprint a new PBS Vehicle Approval number will be issued requiring an update to any existing access permits and a new Road Manager consent maybe required."]
[]
[]
[null,null,"If adding a mix of Identical-Footprint and Non-Identical-Footprint vehicles please select Non-Identical-Footprint."]
[]
[null,null,"For more information, refer to our Information Sheet 'Adding Identical-Footprint Vehicles to a PBS Vehicle Approval'"]
[]
[null,null,"Table 1","Access Class ‘A’","Access Class ‘B’"]
[null,null,"Level 1","≤ 20m"]
[null,null,"Level 2","≤ 26m","≤ 30m"]
[null,null,"Level 3","≤ 36.5m","≤ 42m"]
[null,null,"Level 4","≤ 53.5m","≤ 60m"]

{"sheet":"Variation Amend Info","index":6,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"What is Variation/ Amend?"]
[]
["·       Variation/ Amendment refers to PBS Design Approval modification number"]
["·     This information is specified on the Part B"]
[null,"For more information, refer to our Information Sheet 'PBS Design Approval modification process'"]
[]
[null,"Example - Variation 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Example - Variation 5"]
[]
[]
[]
[]
[]
[]
[]
[null,"Example - Amend 1"]
[]
[]
[]
[]
[]
[]
[]
[null,"Example - Amend 2"]

{"sheet":"Template Info","index":7,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INDEX"]
[]
[1,"Enable macros"]
[]
[2,"Turn on macro code"]
[]
[3,"Setup"]
[]
[4,"How to use this template"]
[]
[5,"Feedback"]
[]
[1,"Enable macros"]
[]
[null,null,"When you open the workbook make sure to Enable the macros – a message like this will appear at the top of the screen."]
[null,null," Press the Enable Content button."]
[]
[]
[]
[]
[2,"Turn on macro code"]
[]
[null,null,"For the macro to work you must enable the 'Microsoft Scripting Runtime' reference library:"]
[null,null,"- Open Visual Basic Editor ( ALT + F11 ) or go to DEVELOPER* tab and click Visual Basic"]
[null,null,"- Go to Tools > References"]
[null,null,"- Tick the checkbox next to 'Microsoft Scripting Runtime'"]
[]
[null,null,"* To display the DEVELOPER tab, click on the File menu and then select Options from the drop down menu."]
[null,null,"Click on the Customize Ribbon option on the left. Then click on the OK button."]
[null,null,"Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button."]
[]
[3,"Setup"]
[]
[null,"1)","Visit the NHVR Developer Portal to obtain an API subscription key"]
[null,"2)","Enter the 'API subscription key' into the Setup sheet and click 'Save API Key'."]
[null,"3)","The key will be saved into a file named 'API_KEY_DO_NOT_SHARE.txt' in the same folder as this spreadsheet."]
[]
[]
[4,"How to use this template"]
[]
[null,"1)","Create a new folder (parent folder) and place all certification files and the Excel submission template into the folder."]
[null,null,"You can have folders with files inside the parent folder."]
[null,null,"You can rename the Excel submission template if required."]
[null,"2)","Fill out sheet the 'Design Approval application' or 'Vehicle Approval application'"]
[null,"4)","Press the ‘Submit’ button to generate a submissiondirectly to the NHVR Portal."]
[]
[5,"Feedback"]
[]
[null,null,"If you find any issues with the template or if anything doesn’t work please send us an email to digital@nhvr.gov.au."]
[null,null,"If you have any issues you need answered promptly you can contact John Barry via Microsoft Teams at john.barry@nhvr.gov.au"]

{"sheet":"Change Log","index":8,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                        Change Log"]
[null,{"$f":"\"PBS-Submission-Tool v\" & VLOOKUP(thisVersion, releaseTable[],1,FALSE)  & \" (\" &TEXT(VLOOKUP(thisVersion, releaseTable[],2,FALSE), \"dd-mmm-yy\") & \")\"","v":"PBS-Submission-Tool v2.3.0 (25-Sep-21)"}]
[]
[]
[]
[null,"Release version","Release date","Release notes","Archive date","Archived","Download url"]
[null,"2.3.0","2021-09-25T10:07:00","Breaking change to support release 9.9.0 DA full feature form",null,false,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V2.3.0.xlsm"]
[null,"2.2.0","2021-07-22T10:07:00","Breaking change of VA applications - 'Transfer' split into 'Transfer to another company', 'Change of company name'",null,false,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V2.2.0.xlsm"]
[null,"2.1.0","2021-03-31T10:07:00","Breaking change to PBS application schema - add requirement for designRules array to support future DA Smart Forms","2021-07-22T10:07:00",true,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V2.1.0.xlsm"]
[null,"2.0.0","2021-03-09T10:07:00","Breaking change to name of pbsAssessor and pbsCertifier endpoints; Fix adding 'V' or 'A' to variation/amendment numbers","2021-03-31T10:07:00",true,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V2.1.0.xlsm"]
[null,"1.9.0","2021-01-28T10:07:00","Add update check feature","2021-03-09T10:07:00",true,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V2.1.0.xlsm"]
[null,"1.8.0","2021-01-27T09:07:00","Update font to Calibri","2021-01-29T09:07:00",true,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V1.8.0.xlsm"]
[null,"1.7.0","2021-01-23T09:07:00","Add Body Types and data load feature","2021-01-29T09:07:00",true,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V1.7.0.xlsm"]
[null,"1.6.0","2021-01-20T09:07:00","Add Combination & Load Types data load feature\r\nAdd Hauling & Towed Units data load feature","2021-01-29T09:07:00",true,"https://nhvrappsprod.blob.core.windows.net/policies/PBS-Submission-Tool-V1.6.0.xlsm"]
[null,"1.5.0","2021-01-19T09:07:01","Add ABN lookup feature\r\nAdd PBS Certifier and PBS Assessor data load feature","2021-01-29T09:07:00",true]
[null,"1.4.0","2021-01-19T09:07:00","Add Design Approval application submission feature","2021-01-29T09:07:00",true]
[null,"1.3.0","2021-01-12T09:07:00","Add setup tab with save API key feature","2021-01-29T09:07:00",true]
[null,"1.2.0","2020-12-25T09:07:00","Add lists tab for maintaining PBS Certifier and Assessor details","2021-01-29T09:07:00",true]
[null,"1.1.0","2020-12-22T09:07:00","Add report tab for displaying error messages","2021-01-29T09:07:00",true]
[null,"1.0.0","2020-12-15T09:07:00","Initial release with Vehicle Approval application submission feature","2021-01-29T09:07:00",true]