{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Setup","DA 1) Application & attachments","DA 2) Configuration","DA 3) Vehicle Details","DA 4) Design Rules","DA 5) Assessment","REPORT","Vehicle Approval application","Lists","Identical-Footprint","Variation Amend Info","Template Info","Change Log"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":3740,"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":{"$error":"#N/A"}},"©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,"3.0.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":""},null,{"$f":"INDIRECT(\"'Change Log'!c9\")","v":"2021-09-25T10:07:00"}]
[]
[null,"Account name",null,"Account Id",null,"Archive date",null,"Archived"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(thisVersion, releaseTable[],4,FALSE),\"\")","v":""},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.eyJpZCI6IjM5IiwiZmlyc3ROYW1lIjoiSm9obiIsIm5hbWUiOiJCYXJyeSIsImVtYWlsIjoiSm9obi5CYXJyeUBuaHZyLmdvdi5hdSIsInVzZXJJbWFnZVVybCI6Imh0dHBzOi8vbmh2cmFwcHNwcm9kLmJsb2IuY29yZS53aW5kb3dzLm5ldC91c2VyLW1vZGVsL2ltZzM5LWE1YzQzMmQ5NmE4Yzk2MTVkMmJmM2NjZWRmMmQ5N2NjYzgxNWRiNjNmaWxlLnBuZyIsImFjY291bnROYW1lIjoiTmF0aW9uYWwgSGVhdnkgVmVoaWNsZSBSZWd1bGF0b3IiLCJhY2NvdW50VHlwZSI6InByb3ZpZGVyIiwiYWNjb3VudElkIjoyNCwiaWRWZXJpZmllZCI6dHJ1ZSwiYXBpRW5hYmxlZCI6dHJ1ZSwiYWNjb3VudEltYWdlVXJsIjoiIiwiYWNjb3VudENvdW50IjoyNywicm9sZXMiOlsicHJvdmlkZXJBY2NvdW50QWRtaW4iLCJwcm92aWRlckFjY2Vzc0Rpc2FibGVkIiwicHJvdmlkZXJBY2NyZWRpdGF0aW9uU3VibWl0dGVyIiwicHJvdmlkZXJWU1N1Ym1pdHRlciIsInByb3ZpZGVyUEJTU3VibWl0dGVyIiwicHJvdmlkZXJSZWdpc3RyYXRpb25FbmFibGVkIiwicHJvdmlkZXJDb21wbGlhbmNlRGlzYWJsZWQiXSwiaXAiOiI0MC4xMjYuMjQ0LjcxIiwidGhpcmRQYXJ0eVRva2VucyI6W3sibmFtZSI6ImludGVyY29tIiwidG9rZW4iOiI4YjViMTZjNzljODc0NTk5ZGM1ZjdjYjg1OTYzOTgzZWVkZmMyMTlhNTkwYzljYjRmMWU4ODE1ZDA4NDkwYzMxIn1dLCJpYXQiOjE2Mzg0NDU2MTEsImV4cCI6MTYzODQ0NTkxMX0.S4X21EkXRloCVa122EC--uiuMC5GRQL9K4wP9GoGQGA",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":"DA 1) Application & attachments","index":1,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[103,1,103,3],[104,1,104,3],[105,1,105,3],[106,1,106,3],[107,1,107,3],[98,1,98,3],[99,1,99,3],[100,1,100,3],[101,1,101,3],[102,1,102,3],[93,1,93,3],[94,1,94,3],[95,1,95,3],[96,1,96,3],[97,1,97,3],[88,1,88,3],[89,1,89,3],[90,1,90,3],[91,1,91,3],[92,1,92,3],[83,1,83,3],[84,1,84,3],[85,1,85,3],[86,1,86,3],[87,1,87,3],[78,1,78,3],[79,1,79,3],[80,1,80,3],[81,1,81,3],[82,1,82,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[76,1,76,3],[77,1,77,3],[41,5,41,7],[42,5,115,7],[58,1,62,3],[42,9,115,11],[108,1,108,3],[57,1,57,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[69,1,69,3],[70,1,70,3],[71,1,71,3],[72,1,72,3]]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                     DA 1) Application Details & Attachments"]
[]
[]
[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,"Comments"]

{"sheet":"DA 2) Configuration","index":2,"n_rows":148,"n_cols":11,"rows_kept":148,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                     DA 2) Configuration"]
[]
[]
[]
[null,"Application Nickname",null,"Application Id"]
[null,{"$f":"IF(LEN('DA 1) Application & attachments'!name) > 0, 'DA 1) Application & attachments'!name, \"\")","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,pbsAssessor[],3,FALSE), \"\")","v":""},{"$f":"'DA 1) Application & attachments'!id","v":0},null,"Design Approval"]
[]
[null,"Configuration (Combination)"]
[null,"Vehicle configuration (required)",null,"Max Length (required)","Max Width (required)","Max Height (required)"]
[null,"Rigid-truck and dog",null,18900,2500,4300]
[null,{"$f":"IFERROR(VLOOKUP(B12,vehicleComponentSetTypes[],3,FALSE), \"\")","v":38}]
[]
[null,"Components (Units)"]
[null,null,null,"Vehicle unit 1","Vehicle unit 2","Vehicle unit 3","Vehicle unit 4","Vehicle unit 5","Vehicle unit 6","Vehicle unit 7","Vehicle unit 8"]
[null,null,null,"(required)","(required)"]
[null,"Vehicle components (required)\nSelect from dropdown menu",{"$f":"IFERROR(VLOOKUP(D18,vehicleComponentSetTypes[],2,FALSE), \"\")","v":""},"Rigid truck long bonnet 1-2 axle","Dog trailer 1-2 axle"]
[null,"Vehicle component id",null,{"$f":"IFERROR(VLOOKUP(D18,vehicleComponents1[],4,FALSE), \"\")","v":86},{"$f":"IFERROR(VLOOKUP(E18,vehicleComponents2[],4,FALSE), \"\")","v":39},null,{"$f":"IFERROR(VLOOKUP(G18,vehicleComponents4[],4,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(H18,vehicleComponents5[],4,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(I18,vehicleComponents6[],4,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(J18,vehicleComponents7[],4,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(K18,vehicleComponents8[],4,FALSE), \"\")","v":""}]
[null,"# Axle groups",null,{"$f":"IFERROR(VLOOKUP(D18,vehicleComponents1[],2,FALSE), \"\")","v":2},{"$f":"IFERROR(VLOOKUP(E18,vehicleComponents2[],2,FALSE), \"\")","v":2},null,{"$f":"IFERROR(VLOOKUP(G18,vehicleComponents4[],2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(H18,vehicleComponents5[],2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(I18,vehicleComponents6[],2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(J18,vehicleComponents7[],2,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(K18,vehicleComponents8[],2,FALSE), \"\")","v":""}]
[null,"# Axles",null,1,1,null,{"$f":"IFERROR(VLOOKUP(G18,vehicleComponents4[],3,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(H18,vehicleComponents5[],3,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(I18,vehicleComponents6[],3,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(J18,vehicleComponents7[],3,FALSE), \"\")","v":""},{"$f":"IFERROR(VLOOKUP(K18,vehicleComponents8[],3,FALSE), \"\")","v":""}]
[null,"Body type (required)\nSelect from dropdown menu",null,null,"Bin"]
[null,"Load type 1 (required)\nSelect from dropdown menu",null,null,"Quarry and Bulk"]
[null,"Load type 2\nSelect from dropdown menu"]
[null,"Load type 3\nSelect from dropdown menu"]
[null,"Min. Tare mass (required)\n ",null,10500,4500]
[]
[null,"Max lengths & heights (required - where applicable to unit)"]
[null,null,null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Max. Front overhang (m)",null,750]
[null,"Max. Wheelbase (m)",null,5445]
[null,"Max. S dimension (m)",null,null,4369]
[null,"Max. Rear overhang (m)",null,null,2037]
[null,"Max. Tow coupling rear overhang (m)",null,1614]
[null,"Max. Drawbar length (m)",null,null,4686]
[null,"Max. Fifth wheel offset (m)"]
[null,"Max. Height front (m)",null,1386,1400]
[null,"Max. Height rear (m)",null,1386,1400]
[null,"Max. Floor height front (m)",null,3236,3250]
[null,"Max. Floor height rear (m)",null,3236,3250]
[null,"Max. Drawbar height (m)",null,null,100]
[]
[null,"Min lengths & heights (required - where applicable to unit)"]
[null,null,null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Min. Front overhang (m)",null,750]
[null,"Min. Wheelbase (m)",null,5445]
[null,"Min. S dimension (m)",null,null,4369]
[null,"Min. Rear overhang (m)",null,null,2037]
[null,"Min. Tow coupling rear overhang (m)",null,1614]
[null,"Min. Drawbar length (m)",null,null,4686]
[null,"Min. Fifth wheel offset (m)"]
[null,"Min. Height front (m)",null,1386,1400]
[null,"Min. Height rear (m)",null,1386,1400]
[null,"Min. Floor height front (m)",null,3236,3250]
[null,"Min. Floor height rear (m)",null,3236,3250]
[null,"Min. Drawbar height (m)",null,null,100]
[]
[null,"Axle groups"]
[null,"Min. Axle spread (mm)",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,{"$f":"IF(LEN(B$68)>0,B$68,\"\")","v":"Axle Group 1"}]
[null,{"$f":"IF(LEN(B$69)>0,B$69,\"\")","v":"Axle Group 2"},null,1370,1650]
[]
[null,"Max. Axle spread (mm)",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,{"$f":"IF(LEN(B$68)>0,B$68,\"\")","v":"Axle Group 1"}]
[null,{"$f":"IF(LEN(B$69)>0,B$69,\"\")","v":"Axle Group 2"},null,1370,1650]
[]
[null,"Min. Track width (mm)\n[Used to specify axle groups per unit]",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1",null,2050,1870]
[null,"Axle Group 2",null,1860,1870]
[]
[null,"Min. Dual tyre spacing (mm)",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,{"$f":"IF(LEN(B$68)>0,B$68,\"\")","v":"Axle Group 1"},null,null,340]
[null,{"$f":"IF(LEN(B$69)>0,B$69,\"\")","v":"Axle Group 2"},null,340,340]
[]
[null,"Tyre size section width (mm)",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,{"$f":"IF(LEN(B$68)>0,B$68,\"\")","v":"Axle Group 1"},null,295,295]
[null,{"$f":"IF(LEN(B$69)>0,B$69,\"\")","v":"Axle Group 2"},null,295,295]
[]
[null,"Axles"]
[null,"No. Tyres on axle",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1 - Axle 1",null,2,4]
[null,"Axle Group 1 - Axle 2"]
[null,"Axle Group 1 - Axle 3"]
[null,"Axle Group 1 - Axle 4"]
[null,"Axle Group 2 - Axle 1",null,4,4]
[null,"Axle Group 2 - Axle 2",null,4,4]
[null,"Axle Group 2 - Axle 3"]
[null,"Axle Group 2 - Axle 4"]
[]
[null,"Min. Spacing (mm)",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1 - Axle 0 - 1",null,null,5615]
[null,"Axle Group 1 - Axle 1 - 2"]
[null,"Axle Group 1 - Axle 2 - 3"]
[null,"Axle Group 1 - Axle 3 - 4"]
[null,"Axle Group 2 - Axle 0 - 1",null,4760,3544]
[null,"Axle Group 2 - Axle 1 - 2",null,1370,1650]
[null,"Axle Group 2 - Axle 2 - 3"]
[null,"Axle Group 2 - Axle 3 - 4"]
[]
[null,"Max. Spacing (mm)",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1 - Axle 0 - 1",null,null,5615]
[null,"Axle Group 1 - Axle 1 - 2"]
[null,"Axle Group 1 - Axle 2 - 3"]
[null,"Axle Group 1 - Axle 3 - 4"]
[null,"Axle Group 2 - Axle 0 - 1",null,4760,3544]
[null,"Axle Group 2 - Axle 1 - 2",null,1370,1650]
[null,"Axle Group 2 - Axle 2 - 3"]
[null,"Axle Group 2 - Axle 3 - 4"]
[]
[null,"Steer",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1 - Axle 1",null,"Active steer"]
[null,"Axle Group 1 - Axle 2"]
[null,"Axle Group 1 - Axle 3"]
[null,"Axle Group 1 - Axle 4"]
[null,"Axle Group 2 - Axle 1"]
[null,"Axle Group 2 - Axle 2"]
[null,"Axle Group 2 - Axle 3"]
[null,"Axle Group 2 - Axle 4"]
[]
[null,"Steer optional",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1 - Axle 1"]
[null,"Axle Group 1 - Axle 2"]
[null,"Axle Group 1 - Axle 3"]
[null,"Axle Group 1 - Axle 4"]
[null,"Axle Group 2 - Axle 1"]
[null,"Axle Group 2 - Axle 2"]
[null,"Axle Group 2 - Axle 3"]
[null,"Axle Group 2 - Axle 4"]
[]
[null,"Drive",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1 - Axle 1"]
[null,"Axle Group 1 - Axle 2"]
[null,"Axle Group 1 - Axle 3"]
[null,"Axle Group 1 - Axle 4"]
[null,"Axle Group 2 - Axle 1",null,"Yes"]
[null,"Axle Group 2 - Axle 2",null,"Yes"]
[null,"Axle Group 2 - Axle 3"]
[null,"Axle Group 2 - Axle 4"]
[]
[null,"Liftable",null,{"$f":"IF(LEN(D$18) > 0, D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},{"$f":"IF(LEN(E$18) > 0, E$18, \"\")","v":"Dog trailer 1-2 axle"},"","","","","",""]
[null,"Axle Group 1 - Axle 1"]
[null,"Axle Group 1 - Axle 2"]
[null,"Axle Group 1 - Axle 3"]
[null,"Axle Group 1 - Axle 4"]
[null,"Axle Group 2 - Axle 1"]
[null,"Axle Group 2 - Axle 2"]
[null,"Axle Group 2 - Axle 3"]
[null,"Axle Group 2 - Axle 4"]

{"sheet":"DA 3) Vehicle Details","index":3,"n_rows":126,"n_cols":58,"rows_kept":126,"cut":false,"hidden":false,"merged":[[125,54,125,55],[125,12,125,13],[125,19,125,20],[125,26,125,27],[125,33,125,34],[125,40,125,41],[125,47,125,48],[125,5,125,6],[33,5,33,6],[35,5,35,6],[33,12,33,13],[35,12,35,13],[121,5,121,6],[122,5,122,6],[123,5,123,6],[124,5,124,6],[121,12,121,13],[122,12,122,13],[123,12,123,13],[124,12,124,13],[105,12,105,13],[106,12,106,13],[121,26,121,27],[122,26,122,27],[123,26,123,27],[124,26,124,27],[121,19,121,20],[122,19,122,20],[123,19,123,20],[124,19,124,20],[33,54,33,55],[35,19,35,20],[35,26,35,27],[35,33,35,34],[35,40,35,41],[35,47,35,48],[35,54,35,55],[33,19,33,20],[33,26,33,27],[33,33,33,34],[33,40,33,41],[33,47,33,48],[105,54,105,55],[106,54,106,55],[107,54,107,55],[108,54,108,55],[109,54,109,55],[121,33,121,34],[122,33,122,34],[123,33,123,34],[124,33,124,34],[121,54,121,55],[122,54,122,55],[123,54,123,55],[124,54,124,55],[121,47,121,48],[122,47,122,48],[123,47,123,48],[124,47,124,48],[121,40,121,41],[122,40,122,41],[123,40,123,41],[124,40,124,41],[105,40,105,41],[106,40,106,41],[107,40,107,41],[108,40,108,41],[109,40,109,41],[105,47,105,48],[106,47,106,48],[107,47,107,48],[108,47,108,48],[109,47,109,48],[105,26,105,27],[106,26,106,27],[107,26,107,27],[108,26,108,27],[109,26,109,27],[105,33,105,34],[106,33,106,34],[107,33,107,34],[108,33,108,34],[109,33,109,34],[107,12,107,13],[108,12,108,13],[109,12,109,13],[105,5,105,6],[106,5,106,6],[107,5,107,6],[108,5,108,6],[109,5,109,6],[105,19,105,20],[106,19,106,20],[107,19,107,20],[108,19,108,20],[109,19,109,20],[90,47,90,48],[91,47,91,48],[92,47,92,48],[93,47,93,48],[94,47,94,48],[90,54,90,55],[91,54,91,55],[92,54,92,55],[93,54,93,55],[94,54,94,55],[94,33,94,34],[90,26,90,27],[91,26,91,27],[92,26,92,27],[93,26,93,27],[94,26,94,27],[90,40,90,41],[91,40,91,41],[92,40,92,41],[93,40,93,41],[90,33,90,34],[91,33,91,34],[92,33,92,34],[93,33,93,34],[78,26,78,27],[78,19,78,20],[78,12,78,13],[78,5,78,6],[94,40,94,41],[78,54,78,55],[78,47,78,48],[78,40,78,41],[78,33,78,34],[90,5,90,6],[91,5,91,6],[92,5,92,6],[93,5,93,6],[94,5,94,6],[90,12,90,13],[91,12,91,13],[92,12,92,13],[93,12,93,13],[94,12,94,13],[90,19,90,20],[91,19,91,20],[92,19,92,20],[93,19,93,20],[94,19,94,20]]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                     DA 3) Vehicle Details"]
[]
[]
[]
[null,"Application Nickname",null,"Application Id"]
[null,{"$f":"IF(LEN('DA 1) Application & attachments'!name) > 0, 'DA 1) Application & attachments'!name, \"\")","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,pbsAssessor[],3,FALSE), \"\")","v":""},{"$f":"'DA 1) Application & attachments'!id","v":0},null,"Design Approval"]
[]
[null,"{assessment: false,justification: '', products: []}"]
[null,null,null,"Vehicle component 1",null,null,null,null,null,null,"Vehicle component 2",null,null,null,null,null,null,"Vehicle component 3",null,null,null,null,null,null,"Vehicle component 4",null,null,null,null,null,null,"Vehicle component 5",null,null,null,null,null,null,"Vehicle component 6",null,null,null,null,null,null,"Vehicle component 7",null,null,null,null,null,null,"Vehicle component 8"]
[null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!D$17) > 0, 'DA 2) Configuration'!D$17, \"\")","v":"(required)"},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!E$17) > 0, 'DA 2) Configuration'!E$17, \"\")","v":"(required)"},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!F$17) > 0, 'DA 2) Configuration'!F$17, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!G$17) > 0, 'DA 2) Configuration'!G$17, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!H$17) > 0, 'DA 2) Configuration'!H$17, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!I$17) > 0, 'DA 2) Configuration'!I$17, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!J$17) > 0, 'DA 2) Configuration'!J$17, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!K$17) > 0, 'DA 2) Configuration'!K$17, \"\")","v":""}]
[null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!D$18) > 0, 'DA 2) Configuration'!D$18, \"\")","v":"Rigid truck long bonnet 1-2 axle"},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!E$18) > 0, 'DA 2) Configuration'!E$18, \"\")","v":"Dog trailer 1-2 axle"},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!F$18) > 0, 'DA 2) Configuration'!F$18, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!GY$18) > 0, 'DA 2) Configuration'!G$18, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!H$18) > 0, 'DA 2) Configuration'!H$18, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!I$18) > 0, 'DA 2) Configuration'!I$18, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!J$18) > 0, 'DA 2) Configuration'!J$18, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(LEN('DA 2) Configuration'!K$18) > 0, 'DA 2) Configuration'!K$18, \"\")","v":""}]
[]
[null,"Vehicle units",null,"Make","Model",null,null,null,null,null,"Make","Model",null,null,null,null,null,"Make","Model",null,null,null,null,null,"Make","Model",null,null,null,null,null,"Make","Model",null,null,null,null,null,"Make","Model",null,null,null,null,null,"Make","Model",null,null,null,null,null,"Make","Model"]
[null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)"]
[null,"paramVehicle",null,"make","model",null,null,null,null,null,"make","model",null,null,null,null,null,"make","model",null,null,null,null,null,"make","model",null,null,null,null,null,"make","model",null,null,null,null,null,"make","model",null,null,null,null,null,"make","model",null,null,null,null,null,"make","model"]
[null,null,null,"MAKE","MODEL",null,null,null,null,null,"MAKE2","MODEL2",null,null,null,null,null,"MAKE","MODEL",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,"MAKE","MODEL",null,null,null,null,null,"MAKE","MODEL"]
[]
[]
[]
[]
[]
[null,"Engine",null,"Make","Model","Power (kW)","Torque (Nm)",null,null,null,"Make","Model","Power (kW)","Torque (Nm)",null,null,null,"Make","Model","Power (kW)","Torque (Nm)",null,null,null,"Make","Model","Power (kW)","Torque (Nm)",null,null,null,"Make","Model","Power (kW)","Torque (Nm)",null,null,null,"Make","Model","Power (kW)","Torque (Nm)",null,null,null,"Make","Model","Power (kW)","Torque (Nm)",null,null,null,"Make","Model","Power (kW)","Torque (Nm)"]
[null,null,null,"(required)",null,"(required)","(required)",null,null,null,"(required)",null,"(required)","(required)",null,null,null,"(required)",null,"(required)","(required)",null,null,null,"(required)",null,"(required)","(required)",null,null,null,"(required)",null,"(required)","(required)",null,null,null,"(required)",null,"(required)","(required)",null,null,null,"(required)",null,"(required)","(required)",null,null,null,"(required)",null,"(required)","(required)"]
[null,"paramEngine",null,"make","model","enginePower (integer)","engineTorque (integer)",null,null,null,"make","model","enginePower (integer)","engineTorque (integer)",null,null,null,"make","model","enginePower (integer)","engineTorque (integer)",null,null,null,"make","model","enginePower (integer)","engineTorque (integer)",null,null,null,"make","model","enginePower (integer)","engineTorque (integer)",null,null,null,"make","model","enginePower (integer)","engineTorque (integer)",null,null,null,"make","model","enginePower (integer)","engineTorque (integer)",null,null,null,"make","model","enginePower (integer)","engineTorque (integer)"]
[null,null,null,"Emake","emodel",100,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emake","emodel",100,200]
[]
[]
[]
[]
[]
[null,"Driveline"]
[null,null,null,"Clutch engagement torque",null,"test",null,null,null,null,"Clutch engagement torque",null,null,null,null,null,null,"Clutch engagement torque",null,null,null,null,null,null,"Clutch engagement torque",null,null,null,null,null,null,"Clutch engagement torque",null,null,null,null,null,null,"Clutch engagement torque",null,null,null,null,null,null,"Clutch engagement torque",null,null,null,null,null,null,"Clutch engagement torque"]
[]
[null,null,null,"Torque converter characteristics",null,"test",null,null,null,null,"Torque converter characteristics",null,null,null,null,null,null,"Torque converter characteristics",null,null,null,null,null,null,"Torque converter characteristics",null,null,null,null,null,null,"Torque converter characteristics",null,null,null,null,null,null,"Torque converter characteristics",null,null,null,null,null,null,"Torque converter characteristics",null,null,null,null,null,null,"Torque converter characteristics"]
[]
[]
[null,"Gearbox",null,"Make","Model","Gearbox ratios",null,null,null,null,"Make","Model","Gearbox ratios",null,null,null,null,"Make","Model","Gearbox ratios",null,null,null,null,"Make","Model","Gearbox ratios",null,null,null,null,"Make","Model","Gearbox ratios",null,null,null,null,"Make","Model","Gearbox ratios",null,null,null,null,"Make","Model","Gearbox ratios",null,null,null,null,"Make","Model","Gearbox ratios"]
[null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)"]
[null,"paramGearbox",null,"make","model","gearboxRatios (string)",null,null,null,null,"make","model","gearboxRatios (string)",null,null,null,null,"make","model","gearboxRatios (string)",null,null,null,null,"make","model","gearboxRatios (string)",null,null,null,null,"make","model","gearboxRatios (string)",null,null,null,null,"make","model","gearboxRatios (string)",null,null,null,null,"make","model","gearboxRatios (string)",null,null,null,null,"make","model","gearboxRatios (string)"]
[null,null,null,"Gmake","Gmodel",1.2]
[]
[]
[]
[]
[]
[null,"Differential",null,"Make","Model","Drive ratios",null,null,null,null,"Make","Model","Drive ratios",null,null,null,null,"Make","Model","Drive ratios",null,null,null,null,"Make","Model","Drive ratios",null,null,null,null,"Make","Model","Drive ratios",null,null,null,null,"Make","Model","Drive ratios",null,null,null,null,"Make","Model","Drive ratios",null,null,null,null,"Make","Model","Drive ratios"]
[null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)"]
[null,"paramDifferential",null,"make","model","driveRatios (string)",null,null,null,null,"make","model","driveRatios (string)",null,null,null,null,"make","model","driveRatios (string)",null,null,null,null,"make","model","driveRatios (string)",null,null,null,null,"make","model","driveRatios (string)",null,null,null,null,"make","model","driveRatios (string)",null,null,null,null,"make","model","driveRatios (string)",null,null,null,null,"make","model","driveRatios (string)"]
[null,null,null,"dmake","Dmake",1]
[]
[]
[]
[]
[]
[]
[null,null,null,"Make","Model","Tyre size","Retread","Steer","Drive",null,"Make","Model","Tyre size","Retread","Steer","Drive",null,"Make","Model","Tyre size","Retread","Steer","Drive",null,"Make","Model","Tyre size","Retread","Steer","Drive",null,"Make","Model","Tyre size","Retread","Steer","Drive",null,"Make","Model","Tyre size","Retread","Steer","Drive",null,"Make","Model","Tyre size","Retread","Steer","Drive",null,"Make","Model","Tyre size","Retread","Steer","Drive"]
[null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)",null,null,null,null,"(required)",null,"(required)"]
[null,"paramTyre",null,"make","model","tyreSize (string)","retread","steer","drive",null,"make","model","tyreSize (string)","retread","steer","drive",null,"make","model","tyreSize (string)","retread","steer","drive",null,"make","model","tyreSize (string)","retread","steer","drive",null,"make","model","tyreSize (string)","retread","steer","drive",null,"make","model","tyreSize (string)","retread","steer","drive",null,"make","model","tyreSize (string)","retread","steer","drive",null,"make","model","tyreSize (string)","retread","steer","drive"]
[null,null,null,"tmake","tmodel",1000,"No","Yes","No",null,"tmake1","tmodel2",1000,"No","Yes","No",null,"tmake","tmodel",1000,"No","Yes","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tyres"]
[null,null,null,"Tyre condition (New/Retread)",null,"retread",null,null,null,null,"Tyre condition (New/Retread)",null,"retread",null,null,null,null,"Tyre condition (New/Retread)",null,null,null,null,null,null,"Tyre condition (New/Retread)",null,null,null,null,null,null,"Tyre condition (New/Retread)",null,null,null,null,null,null,"Tyre condition (New/Retread)",null,null,null,null,null,null,"Tyre condition (New/Retread)",null,null,null,null,null,null,"Tyre condition (New/Retread)"]
[]
[]
[null,"Suspension",null,"Make","Model","Steer","Drive",null,null,null,"Make","Model","Steer","Drive",null,null,null,"Make","Model","Steer","Drive",null,null,null,"Make","Model","Steer","Drive",null,null,null,"Make","Model","Steer","Drive",null,null,null,"Make","Model","Steer","Drive",null,null,null,"Make","Model","Steer","Drive",null,null,null,"Make","Model","Steer","Drive"]
[null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)"]
[null,"paramSuspension",null,"make","model","steer","drive",null,null,null,"make","model","steer","drive",null,null,null,"make","model","steer","drive",null,null,null,"make","model","steer","drive",null,null,null,"make","model","steer","drive",null,null,null,"make","model","steer","drive",null,null,null,"make","model","steer","drive",null,null,null,"make","model","steer","drive"]
[null,null,null,"smake","smodel","Yes","Yes",null,null,null,"smake1","smodel2","Yes","Yes",null,null,null,"smake","smodel","Yes","Yes"]
[]
[]
[]
[]
[]
[null,null,null,"Other suspension requirement 1",null,null,null,null,null,null,"Other suspension requirement 1",null,null,null,null,null,null,"Other suspension requirement 1",null,null,null,null,null,null,"Other suspension requirement 1",null,null,null,null,null,null,"Other suspension requirement 1",null,null,null,null,null,null,"Other suspension requirement 1",null,null,null,null,null,null,"Other suspension requirement 1",null,null,null,null,null,null,"Other suspension requirement 1"]
[null,null,null,"Other suspension requirement 2",null,null,null,null,null,null,"Other suspension requirement 2",null,null,null,null,null,null,"Other suspension requirement 2",null,null,null,null,null,null,"Other suspension requirement 2",null,null,null,null,null,null,"Other suspension requirement 2",null,null,null,null,null,null,"Other suspension requirement 2",null,null,null,null,null,null,"Other suspension requirement 2",null,null,null,null,null,null,"Other suspension requirement 2"]
[null,null,null,"Other suspension requirement 3",null,null,null,null,null,null,"Other suspension requirement 3",null,null,null,null,null,null,"Other suspension requirement 3",null,null,null,null,null,null,"Other suspension requirement 3",null,null,null,null,null,null,"Other suspension requirement 3",null,null,null,null,null,null,"Other suspension requirement 3",null,null,null,null,null,null,"Other suspension requirement 3",null,null,null,null,null,null,"Other suspension requirement 3"]
[null,null,null,"Other suspension requirement 4",null,null,null,null,null,null,"Other suspension requirement 4",null,null,null,null,null,null,"Other suspension requirement 4",null,null,null,null,null,null,"Other suspension requirement 4",null,null,null,null,null,null,"Other suspension requirement 4",null,null,null,null,null,null,"Other suspension requirement 4",null,null,null,null,null,null,"Other suspension requirement 4",null,null,null,null,null,null,"Other suspension requirement 4"]
[null,null,null,"Other suspension requirement 5",null,null,null,null,null,null,"Other suspension requirement 5",null,null,null,null,null,null,"Other suspension requirement 5",null,null,null,null,null,null,"Other suspension requirement 5",null,null,null,null,null,null,"Other suspension requirement 5",null,null,null,null,null,null,"Other suspension requirement 5",null,null,null,null,null,null,"Other suspension requirement 5",null,null,null,null,null,null,"Other suspension requirement 5"]
[]
[null,"Brakes",null,"Type","Notes",null,null,null,null,null,"Type","Notes",null,null,null,null,null,"Type","Notes",null,null,null,null,null,"Type","Notes",null,null,null,null,null,"Type","Notes",null,null,null,null,null,"Type","Notes",null,null,null,null,null,"Type","Notes",null,null,null,null,null,"Type","Notes"]
[null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)",null,null,null,null,null,null,"(required)"]
[null,"paramBrake",null,"brakeType","note",null,null,null,null,null,"brakeType","note",null,null,null,null,null,"brakeType","note",null,null,null,null,null,"brakeType","note",null,null,null,null,null,"brakeType","note",null,null,null,null,null,"brakeType","note",null,null,null,null,null,"brakeType","note",null,null,null,null,null,"brakeType","note"]
[null,null,null,"disc",null,null,null,null,null,null,"disc",null,null,null,null,null,null,"disc"]
[]
[]
[]
[]
[]
[null,null,null,"Other wheel/axle requirement 1",null,null,null,null,null,null,"Other wheel/axle requirement 1",null,null,null,null,null,null,"Other wheel/axle requirement 1",null,null,null,null,null,null,"Other wheel/axle requirement 1",null,null,null,null,null,null,"Other wheel/axle requirement 1",null,null,null,null,null,null,"Other wheel/axle requirement 1",null,null,null,null,null,null,"Other wheel/axle requirement 1",null,null,null,null,null,null,"Other wheel/axle requirement 1"]
[null,null,null,"Other wheel/axle requirement 2",null,null,null,null,null,null,"Other wheel/axle requirement 2",null,null,null,null,null,null,"Other wheel/axle requirement 2",null,null,null,null,null,null,"Other wheel/axle requirement 2",null,null,null,null,null,null,"Other wheel/axle requirement 2",null,null,null,null,null,null,"Other wheel/axle requirement 2",null,null,null,null,null,null,"Other wheel/axle requirement 2",null,null,null,null,null,null,"Other wheel/axle requirement 2"]
[null,null,null,"Other wheel/axle requirement 3",null,null,null,null,null,null,"Other wheel/axle requirement 3",null,null,null,null,null,null,"Other wheel/axle requirement 3",null,null,null,null,null,null,"Other wheel/axle requirement 3",null,null,null,null,null,null,"Other wheel/axle requirement 3",null,null,null,null,null,null,"Other wheel/axle requirement 3",null,null,null,null,null,null,"Other wheel/axle requirement 3",null,null,null,null,null,null,"Other wheel/axle requirement 3"]
[null,null,null,"Other wheel/axle requirement 4",null,null,null,null,null,null,"Other wheel/axle requirement 4",null,null,null,null,null,null,"Other wheel/axle requirement 4",null,null,null,null,null,null,"Other wheel/axle requirement 4",null,null,null,null,null,null,"Other wheel/axle requirement 4",null,null,null,null,null,null,"Other wheel/axle requirement 4",null,null,null,null,null,null,"Other wheel/axle requirement 4",null,null,null,null,null,null,"Other wheel/axle requirement 4"]
[null,null,null,"Other wheel/axle requirement 5",null,null,null,null,null,null,"Other wheel/axle requirement 5",null,null,null,null,null,null,"Other wheel/axle requirement 5",null,null,null,null,null,null,"Other wheel/axle requirement 5",null,null,null,null,null,null,"Other wheel/axle requirement 5",null,null,null,null,null,null,"Other wheel/axle requirement 5",null,null,null,null,null,null,"Other wheel/axle requirement 5",null,null,null,null,null,null,"Other wheel/axle requirement 5"]
[]
[null,"Coupling",null,"Type","D rating","Notes",null,null,null,null,"Type","D rating","Notes",null,null,null,null,"Type","D rating","Notes",null,null,null,null,"Type","D rating","Notes",null,null,null,null,"Type","D rating","Notes",null,null,null,null,"Type","D rating","Notes",null,null,null,null,"Type","D rating","Notes",null,null,null,null,"Type","D rating","Notes"]
[null,null,null,"(required)","(required)",null,null,null,null,null,"(required)","(required)",null,null,null,null,null,"(required)","(required)",null,null,null,null,null,"(required)","(required)",null,null,null,null,null,"(required)","(required)",null,null,null,null,null,"(required)","(required)",null,null,null,null,null,"(required)","(required)",null,null,null,null,null,"(required)","(required)"]
[null,"paramCoupling",null,"couplingType","dRating (string)","note",null,null,null,null,"couplingType","dRating (string)","note",null,null,null,null,"couplingType","dRating (string)","note",null,null,null,null,"couplingType","dRating (string)","note",null,null,null,null,"couplingType","dRating (string)","note",null,null,null,null,"couplingType","dRating (string)","note",null,null,null,null,"couplingType","dRating (string)","note",null,null,null,null,"couplingType","dRating (string)","note"]
[null,null,null,"cType","dType",null,null,null,null,null,"ctype1","dtype2"]
[]
[]
[]
[]
[]
[null,"Other"]
[null,null,null,"Other vehicle requirement 1",null,null,null,null,null,null,"Other vehicle requirement 1",null,null,null,null,null,null,"Other vehicle requirement 1",null,null,null,null,null,null,"Other vehicle requirement 1",null,null,null,null,null,null,"Other vehicle requirement 1",null,null,null,null,null,null,"Other vehicle requirement 1",null,null,null,null,null,null,"Other vehicle requirement 1",null,null,null,null,null,null,"Other vehicle requirement 1"]
[null,null,null,"Other vehicle requirement 2",null,null,null,null,null,null,"Other vehicle requirement 2",null,null,null,null,null,null,"Other vehicle requirement 2",null,null,null,null,null,null,"Other vehicle requirement 2",null,null,null,null,null,null,"Other vehicle requirement 2",null,null,null,null,null,null,"Other vehicle requirement 2",null,null,null,null,null,null,"Other vehicle requirement 2",null,null,null,null,null,null,"Other vehicle requirement 2"]
[null,null,null,"Other vehicle requirement 3",null,null,null,null,null,null,"Other vehicle requirement 3",null,null,null,null,null,null,"Other vehicle requirement 3",null,null,null,null,null,null,"Other vehicle requirement 3",null,null,null,null,null,null,"Other vehicle requirement 3",null,null,null,null,null,null,"Other vehicle requirement 3",null,null,null,null,null,null,"Other vehicle requirement 3",null,null,null,null,null,null,"Other vehicle requirement 3"]
[null,null,null,"Other vehicle requirement 4",null,null,null,null,null,null,"Other vehicle requirement 4",null,null,null,null,null,null,"Other vehicle requirement 4",null,null,null,null,null,null,"Other vehicle requirement 4",null,null,null,null,null,null,"Other vehicle requirement 4",null,null,null,null,null,null,"Other vehicle requirement 4",null,null,null,null,null,null,"Other vehicle requirement 4",null,null,null,null,null,null,"Other vehicle requirement 4"]
[null,null,null,"Other vehicle requirement 5",null,null,null,null,null,null,"Other vehicle requirement 5",null,null,null,null,null,null,"Other vehicle requirement 5",null,null,null,null,null,null,"Other vehicle requirement 5",null,null,null,null,null,null,"Other vehicle requirement 5",null,null,null,null,null,null,"Other vehicle requirement 5",null,null,null,null,null,null,"Other vehicle requirement 5",null,null,null,null,null,null,"Other vehicle requirement 5"]

{"sheet":"DA 4) Design Rules","index":4,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,3,37,4],[39,3,39,4],[41,3,41,4],[43,3,43,4],[45,3,45,4]]}
[null,{"$f":"warningText","v":""}]
[]
[null,"                     DA 4) Design Rules","                     DA 4) Design Rules"]
[]
[]
[]
[null,null,"Application Nickname","Application Id"]
[null,null,{"$f":"IF(LEN('DA 1) Application & attachments'!name) > 0, 'DA 1) Application & attachments'!name, \"\")","v":""},{"$f":"'DA 1) Application & attachments'!id","v":0},null,"Design Approval"]
[]
[null,null,"Design Rules"]
[null,null,null,"Australian Design Rules - Exemptions"]
[null,{"$f":"IFERROR(VLOOKUP(C12,designRules[],2,FALSE), \"\")","v":1},"Rule 43, Clause 6.1.1 (Length – Motor vehicles)","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C13,designRules[],2,FALSE), \"\")","v":2},"Rule 43, Clause 6.2.1 (Length – Trailers)"]
[null,{"$f":"IFERROR(VLOOKUP(C14,designRules[],2,FALSE), \"\")","v":3},"Rule 43, Clause 6.2.3 (Rear overhang – Trailers)"]
[null,{"$f":"IFERROR(VLOOKUP(C15,designRules[],2,FALSE), \"\")","v":4},"Rule 43, Clause 6.2.4 (Height – Trailers)"]
[null,{"$f":"IFERROR(VLOOKUP(C16,designRules[],2,FALSE), \"\")","v":5},"Rule 43, Clause 6.2.6 (Width – Trailers)","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C17,designRules[],2,FALSE), \"\")","v":6},"Rule 43, Clause 6.2.2 (Drawbar length – Trailers)"]
[null,{"$f":"IFERROR(VLOOKUP(C18,designRules[],2,FALSE), \"\")","v":7},"Rule 43, Clause 9.4 (Retractable axles)"]
[null,{"$f":"IFERROR(VLOOKUP(C19,designRules[],2,FALSE), \"\")","v":8},"Rule 62, Clause 5.2 (Tow coupling overhang)"]
[null,{"$f":"IFERROR(VLOOKUP(C20,designRules[],2,FALSE), \"\")","v":9},"Rule 63, Clause 5.1 (Tow coupling location)"]
[null,null,null,"Heavy Vehicle (Mass, Dimension and Loading) National Regulation - Authorisations"]
[null,{"$f":"IFERROR(VLOOKUP(C22,designRules[],2,FALSE), \"\")","v":10},"Schedule 6, Section 3 (Length – General)"]
[null,{"$f":"IFERROR(VLOOKUP(C23,designRules[],2,FALSE), \"\")","v":11},"Schedule 6, Section 4 (Length – Trailers)"]
[null,{"$f":"IFERROR(VLOOKUP(C24,designRules[],2,FALSE), \"\")","v":12},"Schedule 6, Section 5 (Length – Rear overhang)"]
[null,{"$f":"IFERROR(VLOOKUP(C25,designRules[],2,FALSE), \"\")","v":13},"Schedule 6, Section 6 (Length – Trailer drawbars)"]
[null,{"$f":"IFERROR(VLOOKUP(C26,designRules[],2,FALSE), \"\")","v":14},"Schedule 6, Section 7 (Width)"]
[null,{"$f":"IFERROR(VLOOKUP(C27,designRules[],2,FALSE), \"\")","v":15},"Schedule 6, Section 8 (Height)"]
[null,null,null,"Heavy Vehicle (Vehicle Standards) National Regulation - Exemptions"]
[null,{"$f":"IFERROR(VLOOKUP(C29,designRules[],2,FALSE), \"\")","v":16},"Schedule 3, Section 29 (Attachment of couplings and drawbar eyes on road trains)"]
[null,{"$f":"IFERROR(VLOOKUP(C30,designRules[],2,FALSE), \"\")","v":17},"Schedule 3, Section 31 (Tow coupling overhang on road trains)"]
[null,null,null,"Additional Exemptions"]
[null,null,null,"Australian Design Rules - Exemptions"]
[null,{"$f":"IFERROR(VLOOKUP(C33,designRules[],2,FALSE), \"\")","v":18},"Rule 43, Clause 7 (Axle configuration)"]
[null,{"$f":"IFERROR(VLOOKUP(C34,designRules[],2,FALSE), \"\")","v":19},"Rule 43, Clause 9 (Retractable axles)"]
[null,null,null,"Heavy Vehicle (Vehicle Standards) National Regulation - Exemptions"]
[null,{"$f":"IFERROR(VLOOKUP(C36,designRules[],2,FALSE), \"\")","v":20},"Schedule 2, Clause 32(3) (Axle configuration – heavy trailer)"]
[]
[null,null,"Additional exemptions"]

{"sheet":"DA 5) Assessment","index":5,"n_rows":149,"n_cols":25,"rows_kept":149,"cut":false,"hidden":false,"merged":[[144,3,144,4],[119,2,119,4],[120,2,124,4],[128,3,128,4],[130,3,130,4],[132,3,132,4],[134,3,134,4],[109,8,109,23],[21,9,21,23],[138,3,138,4],[140,3,140,4],[142,3,142,4],[12,9,12,23],[66,9,66,23],[75,9,75,23],[93,9,93,23],[102,9,102,23],[19,8,19,23],[28,8,28,23],[46,8,46,23],[55,8,55,23],[73,8,73,23],[82,8,82,23],[100,8,100,23],[48,9,48,23],[39,9,39,23]]}
[null,null,{"$f":"warningText","v":""}]
[]
[null,null,"                     DA 5) Assessment & Mass Tables"]
[]
[]
[]
[null,null,"Application Nickname","Application Id"]
[null,{"$f":"IFERROR(VLOOKUP(#REF!,pbsAssessor[],3,FALSE), \"\")","v":""},{"$f":"IF(LEN('DA 1) Application & attachments'!name) > 0, 'DA 1) Application & attachments'!name, \"\")","v":""},{"$f":"'DA 1) Application & attachments'!id","v":0},null,"Design Approval"]
[]
[null,null,"Assessment - Set 1"]
[null,null,"Performance Standard","Results and level",null,"Mass tables"]
[null,null,"GCM"]
[null,null,"Level",1,null,"Mass table 1",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C14,technicalResults[],2,FALSE), \"\")","v":1},"Startability",24.5,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C15,technicalResults[],2,FALSE), \"\")","v":2},"Gradeability - Maximum grade",26.7,null,"GML","No","GML1",46.5,6.5,16.5,9,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C16,technicalResults[],2,FALSE), \"\")","v":3},"Gradeability - Speed on a 1% grade",94.6,null,"CML","Yes","CML1",46.5,6.5,16.5,9,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C17,technicalResults[],2,FALSE), \"\")","v":4},"Acceleration capability",19.600000000000001,null,"HML","Yes","HML1",46.5,6.5,16.5,9,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C18,technicalResults[],2,FALSE), \"\")","v":5},"Tracking Ability on a Straight Path",2.85,null,"Custom","No","PBS1"]
[null,{"$f":"IFERROR(VLOOKUP(C19,technicalResults[],2,FALSE), \"\")","v":6},"Low-Speed Swept Path",5.52,null,"Bridge Tier",1,null,42.5,6,16,8,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C20,technicalResults[],2,FALSE), \"\")","v":7},"Frontal Swing - Maximum Frontal Swing",0.42,null,"Spacings","min","Notes","Test"]
[null,{"$f":"IFERROR(VLOOKUP(C21,technicalResults[],2,FALSE), \"\")","v":8},"Frontal Swing -  Maximum of Difference",0.03]
[null,{"$f":"IFERROR(VLOOKUP(C22,technicalResults[],2,FALSE), \"\")","v":9},"Frontal Swing -  Difference of Maxima",0,null,"Mass table 2 (optional)",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C23,technicalResults[],2,FALSE), \"\")","v":10},"Tail Swing",0.05,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C24,technicalResults[],2,FALSE), \"\")","v":11},"Steer-Tyre Friction Demand",21,null,"GML","No","GML2",46.5,6.5,16.5,9,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C25,technicalResults[],2,FALSE), \"\")","v":12},"Static Rollover Threshold (Worst)",0.41,null,"CML","No","CML2",46.5,6.5,16.5,9,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C26,technicalResults[],2,FALSE), \"\")","v":13},"Static Rollover Threshold of last unit",0.45,null,"HML","Yes","HML2",46.5,6.5,16.5,9,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C27,technicalResults[],2,FALSE), \"\")","v":14},"Rearward Amplification",2.58,null,"Custom","No","PBS2"]
[null,{"$f":"IFERROR(VLOOKUP(C28,technicalResults[],2,FALSE), \"\")","v":15},"High-Speed Transient Off-tracking",0.6,null,"Bridge Tier",1,null,46.5,6.5,16.5,9,16.5]
[null,{"$f":"IFERROR(VLOOKUP(C29,technicalResults[],2,FALSE), \"\")","v":16},"Yaw Damping Coefficient",0.2,null,"Spacings","max","Notes"]
[null,{"$f":"IFERROR(VLOOKUP(C30,technicalResults[],2,FALSE), \"\")","v":17},"Directional stability under braking","EBS"]
[null,null,"Infrastructure Standard","Results and level"]
[null,{"$f":"IFERROR(VLOOKUP(C32,technicalResults[],2,FALSE), \"\")","v":18},"Pavement Vertical Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C33,technicalResults[],2,FALSE), \"\")","v":19},"Pavement Horizontal Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C34,technicalResults[],2,FALSE), \"\")","v":20},"Tyre Contact Pressure Distribution"]
[null,{"$f":"IFERROR(VLOOKUP(C35,technicalResults[],2,FALSE), \"\")","v":21},"Bridge Loading"]
[]
[null,null,"Assessment - Set 2 (optional)"]
[null,null,"Performance Standard","Results and level",null,"Mass tables"]
[null,null,"GCM"]
[null,null,"Level",2,null,"Mass table 1",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C41,technicalResults[],2,FALSE), \"\")","v":1},"Startability",24.5,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C42,technicalResults[],2,FALSE), \"\")","v":2},"Gradeability - Maximum grade",26.7,null,"GML","No",null,46.5,6.5,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C43,technicalResults[],2,FALSE), \"\")","v":3},"Gradeability - Speed on a 1% grade",94.6,null,"CML","Yes",null,46.5,6.5,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C44,technicalResults[],2,FALSE), \"\")","v":4},"Acceleration capability",19.600000000000001,null,"HML","Yes",null,46.5,6.5,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C45,technicalResults[],2,FALSE), \"\")","v":5},"Tracking Ability on a Straight Path",2.85,null,"Custom","No"]
[null,{"$f":"IFERROR(VLOOKUP(C46,technicalResults[],2,FALSE), \"\")","v":6},"Low-Speed Swept Path",5.52,null,"Bridge Tier",1,null,42.5,6,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C47,technicalResults[],2,FALSE), \"\")","v":7},"Frontal Swing - Maximum Frontal Swing",0.42,null,"Spacings","min","Notes","Test2"]
[null,{"$f":"IFERROR(VLOOKUP(C48,technicalResults[],2,FALSE), \"\")","v":8},"Frontal Swing -  Maximum of Difference",0.03]
[null,{"$f":"IFERROR(VLOOKUP(C49,technicalResults[],2,FALSE), \"\")","v":9},"Frontal Swing -  Difference of Maxima",0,null,"Mass table 2 (optional)",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C50,technicalResults[],2,FALSE), \"\")","v":10},"Tail Swing",0.05,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C51,technicalResults[],2,FALSE), \"\")","v":11},"Steer-Tyre Friction Demand",21,null,"GML","No",null,46.5,6.5,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C52,technicalResults[],2,FALSE), \"\")","v":12},"Static Rollover Threshold (Worst)",0.41,null,"CML","No",null,46.5,6.5,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C53,technicalResults[],2,FALSE), \"\")","v":13},"Static Rollover Threshold of last unit",0.45,null,"HML","Yes",null,46.5,6.5,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C54,technicalResults[],2,FALSE), \"\")","v":14},"Rearward Amplification",2.58,null,"Custom","No"]
[null,{"$f":"IFERROR(VLOOKUP(C55,technicalResults[],2,FALSE), \"\")","v":15},"High-Speed Transient Off-tracking",0.6,null,"Bridge Tier",1,null,46.5,6.5,21,14,21]
[null,{"$f":"IFERROR(VLOOKUP(C56,technicalResults[],2,FALSE), \"\")","v":16},"Yaw Damping Coefficient",0.2,null,"Spacings","max","Notes"]
[null,{"$f":"IFERROR(VLOOKUP(C57,technicalResults[],2,FALSE), \"\")","v":17},"Directional stability under braking","EBS"]
[null,null,"Infrastructure Standard","Results and level"]
[null,{"$f":"IFERROR(VLOOKUP(C59,technicalResults[],2,FALSE), \"\")","v":18},"Pavement Vertical Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C60,technicalResults[],2,FALSE), \"\")","v":19},"Pavement Horizontal Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C61,technicalResults[],2,FALSE), \"\")","v":20},"Tyre Contact Pressure Distribution"]
[null,{"$f":"IFERROR(VLOOKUP(C62,technicalResults[],2,FALSE), \"\")","v":21},"Bridge Loading"]
[]
[null,null,"Assessment - Set 3 (optional)"]
[null,null,"Performance Standard","Results and level",null,"Mass tables"]
[null,null,"GCM"]
[null,null,"Level",null,null,"Mass table 1",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C68,technicalResults[],2,FALSE), \"\")","v":1},"Startability",null,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C69,technicalResults[],2,FALSE), \"\")","v":2},"Gradeability - Maximum grade",null,null,"GML","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C70,technicalResults[],2,FALSE), \"\")","v":3},"Gradeability - Speed on a 1% grade",null,null,"CML","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C71,technicalResults[],2,FALSE), \"\")","v":4},"Acceleration capability",null,null,"HML","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C72,technicalResults[],2,FALSE), \"\")","v":5},"Tracking Ability on a Straight Path",null,null,"Custom","No"]
[null,{"$f":"IFERROR(VLOOKUP(C73,technicalResults[],2,FALSE), \"\")","v":6},"Low-Speed Swept Path",null,null,"Bridge Tier",1]
[null,{"$f":"IFERROR(VLOOKUP(C74,technicalResults[],2,FALSE), \"\")","v":7},"Frontal Swing - Maximum Frontal Swing",null,null,"Spacings","min","Notes"]
[null,{"$f":"IFERROR(VLOOKUP(C75,technicalResults[],2,FALSE), \"\")","v":8},"Frontal Swing -  Maximum of Difference"]
[null,{"$f":"IFERROR(VLOOKUP(C76,technicalResults[],2,FALSE), \"\")","v":9},"Frontal Swing -  Difference of Maxima",null,null,"Mass table 2 (optional)",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C77,technicalResults[],2,FALSE), \"\")","v":10},"Tail Swing",null,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C78,technicalResults[],2,FALSE), \"\")","v":11},"Steer-Tyre Friction Demand",null,null,"GML","No"]
[null,{"$f":"IFERROR(VLOOKUP(C79,technicalResults[],2,FALSE), \"\")","v":12},"Static Rollover Threshold (Worst)",null,null,"CML","No"]
[null,{"$f":"IFERROR(VLOOKUP(C80,technicalResults[],2,FALSE), \"\")","v":13},"Static Rollover Threshold of last unit",null,null,"HML","No"]
[null,{"$f":"IFERROR(VLOOKUP(C81,technicalResults[],2,FALSE), \"\")","v":14},"Rearward Amplification",null,null,"Custom","No"]
[null,{"$f":"IFERROR(VLOOKUP(C82,technicalResults[],2,FALSE), \"\")","v":15},"High-Speed Transient Off-tracking",null,null,"Bridge Tier"]
[null,{"$f":"IFERROR(VLOOKUP(C83,technicalResults[],2,FALSE), \"\")","v":16},"Yaw Damping Coefficient",null,null,"Spacings",null,"Notes"]
[null,{"$f":"IFERROR(VLOOKUP(C84,technicalResults[],2,FALSE), \"\")","v":17},"Directional stability under braking"]
[null,null,"Infrastructure Standard","Results and level"]
[null,{"$f":"IFERROR(VLOOKUP(C86,technicalResults[],2,FALSE), \"\")","v":18},"Pavement Vertical Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C87,technicalResults[],2,FALSE), \"\")","v":19},"Pavement Horizontal Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C88,technicalResults[],2,FALSE), \"\")","v":20},"Tyre Contact Pressure Distribution"]
[null,{"$f":"IFERROR(VLOOKUP(C89,technicalResults[],2,FALSE), \"\")","v":21},"Bridge Loading"]
[]
[null,null,"Assessment - Set 4 (optional)"]
[null,null,"Performance Standard","Results and level",null,"Mass tables"]
[null,null,"GCM"]
[null,null,"Level",null,null,"Mass table 1",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C95,technicalResults[],2,FALSE), \"\")","v":1},"Startability",null,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C96,technicalResults[],2,FALSE), \"\")","v":2},"Gradeability - Maximum grade",null,null,"GML","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C97,technicalResults[],2,FALSE), \"\")","v":3},"Gradeability - Speed on a 1% grade",null,null,"CML","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C98,technicalResults[],2,FALSE), \"\")","v":4},"Acceleration capability",null,null,"HML","Yes"]
[null,{"$f":"IFERROR(VLOOKUP(C99,technicalResults[],2,FALSE), \"\")","v":5},"Tracking Ability on a Straight Path",null,null,"Custom","No"]
[null,{"$f":"IFERROR(VLOOKUP(C100,technicalResults[],2,FALSE), \"\")","v":6},"Low-Speed Swept Path",null,null,"Bridge Tier",1]
[null,{"$f":"IFERROR(VLOOKUP(C101,technicalResults[],2,FALSE), \"\")","v":7},"Frontal Swing - Maximum Frontal Swing",null,null,"Spacings","min","Notes"]
[null,{"$f":"IFERROR(VLOOKUP(C102,technicalResults[],2,FALSE), \"\")","v":8},"Frontal Swing -  Maximum of Difference"]
[null,{"$f":"IFERROR(VLOOKUP(C103,technicalResults[],2,FALSE), \"\")","v":9},"Frontal Swing -  Difference of Maxima",null,null,"Mass table 2 (optional)",null,null,null,"Axle groups"]
[null,{"$f":"IFERROR(VLOOKUP(C104,technicalResults[],2,FALSE), \"\")","v":10},"Tail Swing",null,null,"Mass Limit","Assess","Label","Total","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","#14","#15","#16"]
[null,{"$f":"IFERROR(VLOOKUP(C105,technicalResults[],2,FALSE), \"\")","v":11},"Steer-Tyre Friction Demand",null,null,"GML","No"]
[null,{"$f":"IFERROR(VLOOKUP(C106,technicalResults[],2,FALSE), \"\")","v":12},"Static Rollover Threshold (Worst)",null,null,"CML","No"]
[null,{"$f":"IFERROR(VLOOKUP(C107,technicalResults[],2,FALSE), \"\")","v":13},"Static Rollover Threshold of last unit",null,null,"HML","No"]
[null,{"$f":"IFERROR(VLOOKUP(C108,technicalResults[],2,FALSE), \"\")","v":14},"Rearward Amplification",null,null,"Custom","No"]
[null,{"$f":"IFERROR(VLOOKUP(C109,technicalResults[],2,FALSE), \"\")","v":15},"High-Speed Transient Off-tracking",null,null,"Bridge Tier"]
[null,{"$f":"IFERROR(VLOOKUP(C110,technicalResults[],2,FALSE), \"\")","v":16},"Yaw Damping Coefficient",null,null,"Spacings",null,"Notes"]
[null,{"$f":"IFERROR(VLOOKUP(C111,technicalResults[],2,FALSE), \"\")","v":17},"Directional stability under braking"]
[null,null,"Infrastructure Standard","Results and level"]
[null,{"$f":"IFERROR(VLOOKUP(C113,technicalResults[],2,FALSE), \"\")","v":18},"Pavement Vertical Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C114,technicalResults[],2,FALSE), \"\")","v":19},"Pavement Horizontal Loading"]
[null,{"$f":"IFERROR(VLOOKUP(C115,technicalResults[],2,FALSE), \"\")","v":20},"Tyre Contact Pressure Distribution"]
[null,{"$f":"IFERROR(VLOOKUP(C116,technicalResults[],2,FALSE), \"\")","v":21},"Bridge Loading"]
[]
[]
[]
[null,null,"Notes"]
[]
[]
[]
[]
[]
[]
[null,null,"Data sources"]
[]
[null,null,"Mass properties"]
[]
[null,null,"Dimensions"]
[]
[null,null,"Suspension"]
[]
[null,null,"Tyres"]
[]
[null,null,"Assessment method"]
[]
[null,null,"Standards 1 to 3"]
[]
[null,null,"Standards 5, 7 to 14"]
[]
[null,null,"Standards 16 to 19"]
[]
[null,null,"Standards 20"]
[]
[null,null,"This set complies with Section 8"]
[]
[null,null,"This set complies with Section 9"]

{"sheet":"REPORT","index":6,"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":"Vehicle Approval application","index":7,"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 to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"Adding vehicles (truck/pm/bus)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"x  truck/pm/bus\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"Adding vehicles (trailer)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"x  trailer\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"Adding vehicles (dolly)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_0 = \"No\", otherVehicleApprovalTypes_0 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"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 to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"Removing vehicles (truck/pm/bus)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"x  truck/pm/bus\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"Removing vehicles (trailer)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"x  trailer\")","v":""}]
[null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"Removing vehicles (dolly)\")","v":""},null,{"$f":"IF(OR(otherVehicleApprovalTypes_1 = \"No\", otherVehicleApprovalTypes_1 = \"\", vehicleApprovalType = \"\", vehicleApprovalType=\"New\", vehicleApprovalType=\"Transfer to different company\", vehicleApprovalType=\"Change of company name\"),\"\",\"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":"Lists","index":8,"n_rows":49,"n_cols":74,"rows_kept":49,"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,null,null,"Design Rules",null,null,"Technical results",null,null,"Vehicle Configurations",null,null,null,"Vehicle Components 1",null,null,null,null,"Vehicle Components 2",null,null,null,null,"Vehicle Components 3",null,null,null,null,"Vehicle Components 4",null,null,null,null,"Vehicle Components 5",null,null,null,null,"Vehicle Components 6",null,null,null,null,"Vehicle Components 7",null,null,null,null,"Vehicle Components 8"]
[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,"Name","Id",null,"Name","Id",null,"Name","Parent","Id",null,"Name","# axle groups","# axles","Id",null,"Name","# axle groups","# axles","Id",null,"Name","# axle groups","# axles","Id",null,"Name","# axle groups","# axles","Id",null,"Name","# axle groups","# axles","Id",null,"Name","# axle groups","# axles","Id",null,"Name","# axle groups","# axles","Id",null,"Name","# axle groups","# axles","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,"National Heavy Vehicle Regulator","customer",5873,null,"Rule 43, Clause 6.1.1 (Length – Motor vehicles)",1,null,"Startability",1,null,"B-Double",2,13,null,"Rigid truck long bonnet 1-1 axle",2,2,85,null,"Dog trailer 1-1 axle",2,2,38]
[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,"TOLL TRANSPORT PTY. LIMITED","customer",2236,null,"Rule 43, Clause 6.2.1 (Length – Trailers)",2,null,"Gradeability - Maximum grade",2,null,"A doubles",6,21,null,"Rigid truck long bonnet 1-2 axle",2,3,86,null,"Dog trailer 1-2 axle",2,3,39]
[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,"BORAL TRANSPORT LIMITED","customer",1568,null,"Rule 43, Clause 6.2.3 (Rear overhang – Trailers)",3,null,"Gradeability - Speed on a 1% grade",3,null,"Rigid-truck and dog",37,38,null,"Rigid truck long bonnet 2-2 axle",2,4,87,null,"Dog trailer 1-3 axle",2,4,40]
[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,"Payload dimensions updated",null,"ADR Compliance Services","provider",1,null,"Rule 43, Clause 6.2.4 (Height – Trailers)",4,null,"Acceleration capability",4,null,"Articulated Bus",3,52,null,"Rigid truck long bonnet 1-3 axle",2,4,88,null,"Dog trailer 2-3 axle",2,5,41]
[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,"Updating FDR and Drive suspension",null,"BISITECNIKS PTY. LTD.","provider",2,null,"Rule 43, Clause 6.2.6 (Width – Trailers)",5,null,"Tracking Ability on a Straight Path",5,null,"Prime and Semi-trailer (Freight)",31,32,null,"Rigid truck long bonnet 2-3 axle",2,5,142,null,"Dog trailer 2-2 axle",2,4,126]
[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,"Other",null,"BTT ENGINEERING CONSULTING PTY LTD","provider",3,null,"Rule 43, Clause 6.2.2 (Drawbar length – Trailers)",6,null,"Low-Speed Swept Path",6,null,"B triples",6,20,null,"Rigid truck short bonnet 1-1 axle",2,2,212,null,"Dog trailer 3-3 axle",2,6,127]
[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,"BUS & COACH SOLUTIONS PTY LTD","provider",4,null,"Rule 43, Clause 9.4 (Retractable axles)",7,null,"Frontal Swing - Maximum Frontal Swing",7,null,"Controlled Access Bus (CAB)",3,14,null,"Rigid truck short bonnet 1-2 axle",2,3,213,null,"Dog trailer 3-4 axle",2,7,128]
[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,"DMZ ENGINEERING","provider",5,null,"Rule 62, Clause 5.2 (Tow coupling overhang)",8,null,"Frontal Swing -  Maximum of Difference",8,null,"AB triples",6,22,null,"Rigid truck short bonnet 2-2 axle",2,4,214]
[null,null,null,null,null,null,null,null,null,"B-Double",null,null,null,"3-2",null,"Cars",null,"Skeletal",null,"Other",null,"H COWELL & K.D COWELL","provider",6,null,"Rule 63, Clause 5.1 (Tow coupling location)",9,null,"Frontal Swing -  Difference of Maxima",9,null,"Double Decker Bus",3,87,null,"Rigid truck short bonnet 1-3 axle",2,4,215]
[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,"KENNDEL PTY LTD","provider",7,null,"Schedule 6, Section 3 (Length – General)",10,null,"Tail Swing",10,null,"Rigid-truck and 2 dogs",6,36,null,"Rigid truck short bonnet 2-3 axle",2,5,216]
[null,null,null,null,null,null,null,null,null,"Road-train - B-Triple",null,null,null,"1",null,"Containers (Mixed Freight)",null,"Refrigerator",null,"Tyre options updated",null,"LAROCCA, MARIO","provider",8,null,"Schedule 6, Section 4 (Length – Trailers)",11,null,"Steer-Tyre Friction Demand",11,null,"A triples",6,19]
[null,null,null,null,null,null,null,null,null,"Road-train - A-Quad",null,null,null,"4",null,"Containers (Empty)",null,"Livestock",null,"Payload heights updated",null,"NEBCOH QLD PTY LTD","provider",9,null,"Schedule 6, Section 5 (Length – Rear overhang)",12,null,"Static Rollover Threshold (Worst)",12,null,"Ultra-low Floor Bus",3,153]
[null,null,null,null,null,null,null,null,null,"Road-train - B-Quad",null,null,null,"1-3-1",null,"Logs",null,null,null,"Payload height and dimensions updated",null,"PRAIN FAMILY TRUST","provider",10,null,"Schedule 6, Section 6 (Length – Trailer drawbars)",13,null,"Static Rollover Threshold of last unit",13,null,"ABB quads",6,23]
[null,null,null,null,null,null,null,null,null,"Road-train - AB-Triple",null,null,null,"1-1-1",null,"Woodchip",null,null,null,"Updating FDR and Drive suspension",null,"SINGH, JAGDEEP","provider",11,null,"Schedule 6, Section 7 (Width)",14,null,"Rearward Amplification",14,null,"BAB quads",6,24]
[null,null,null,null,null,null,null,null,null,"Road-train - BA-Triple",null,null,null,"1-2-1",null,"Waste",null,null,null,null,null,"SMEDLEYS ENGINEERS PTY LTD","provider",12,null,"Schedule 6, Section 8 (Height)",15,null,"High-Speed Transient Off-tracking",15,null,"AAB quads",6,25]
[null,null,null,null,null,null,null,null,null,"Road-train - AAB-Quad",null,null,null,"2-2-2",null,"Livestock",null,null,null,null,null,"TEC National Pty Ltd","provider",13,null,"Schedule 3, Section 29 (Attachment of couplings and drawbar eyes on road trains)",16,null,"Yaw Damping Coefficient",16]
[null,null,null,null,null,null,null,null,null,"Road-train - BAB-Quad",null,null,null,"2-2-3",null,"Unladen",null,null,null,null,null,"J THOMPSON & ASSOCIATES PTY LTD","provider",14,null,"Schedule 3, Section 31 (Tow coupling overhang on road trains)",17,null,"Directional stability under braking",17]
[null,null,null,null,null,null,null,null,null,"Other",null,null,null,"3-2-2",null,"Public Transport/ People",null,null,null,null,null,"TRANSPORT ENGINEERING AND MANAGEMENT PTY LTD","provider",15,null,"Rule 43, Clause 7 (Axle configuration)",18,null,"Pavement Vertical Loading",18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-2-3",null,"Other",null,null,null,null,null,"The trustee for G & J FINDLATER TRUST","provider",16,null,"Rule 43, Clause 9 (Retractable axles)",19,null,"Pavement Horizontal Loading",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-2",null,null,null,null,null,null,null,"ANDREW OBRIEN & ASSOCIATES PTY. LTD.","provider",17,null,"Schedule 2, Clause 32(3) (Axle configuration – heavy trailer)",20,null,"Tyre Contact Pressure Distribution",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3",null,null,null,null,null,null,null,"WALSH ENGINEERING SOLUTIONS PTY LTD","provider",18,null,null,null,null,"Bridge Loading",21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-4",null,null,null,null,null,null,null,"ARRB GROUP LTD","provider",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-2-3",null,null,null,null,null,null,null,"Jalavica Pty Ltd","provider",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-3-4",null,null,null,null,null,null,null,"BREMAR AUTOMOTION PTY LTD","provider",21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-4",null,null,null,null,null,null,null,"MECHANICAL SYSTEM DYNAMICS PTY LTD","provider",22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-3",null,null,null,null,null,null,null,"Tiger Spider Pty Ltd","provider",23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-4",null,null,null,null,null,null,null,"National Heavy Vehicle Regulator","provider",24]
[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,"Sydney AVV Pty Ltd","provider",69]
[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,"Department of State Growth","partner",190]
[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,"Department of Infrastructure and Transport (DIT)","partner",478]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4-4-4",null,null,null,null,null,null,null,"Transport for New South Wales (TfNSW)","partner",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,"Department of Transport and Main Roads (TMR) ","partner",220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3-3-3",null,null,null,null,null,null,null,"SOUTHERN GRAMPIANS SHIRE COUNCIL","partner",360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2-2-2-2",null,null,null,null,null,null,null,"National Heavy Vehicle Regulator","operations",1]
[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":9,"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":10,"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":11,"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":12,"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":{"$error":"#N/A"}}]
[]
[]
[]
[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'","2021-09-25T10:07:00",true,"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]