{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Version","How to use","Data Information ","Link Excel to CAD","Design Standards and Guides","Drop lists","Calculation","Entry Form","ROAD 1","ROAD 1 and ROAD 2"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Version","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,1,14,1],[9,1,11,1],[6,1,8,1]]}
[null,"Version 2.3"]
[]
[]
[]
[null,"Revision Number","Description of Key Changes ","Revision Date"]
[null,1,"Initial Release","25th March 2019"]
[null,2," Design for two  Roads Added","10th July 2019"]
[null,null,"Side track for Detours Added"]
[null,null,"Macros Updated"]
[null,2.1,"Vertical Crest Curve K Values modified based on equation","17th Sep 2019"]
[null,null,"Vertical Sag Curve  K  Values modified based on Headlight criteria and Comfort Criteria"]
[null,null,"Values for Overtaking sight distance modified based on Road Classification and  Seal Conditions"]
[null,2.2000000000000002,"Reorganised the data input information  for Project Criteria and Geometry","7th April 2020"]
[null,null,"Added the multiple option for Austroad guideline Selection\nNotes updated in \"How to use\"  worksheet. "]
[null,null,"New worksheets \" Data Information \"  and \"Link Excel to CAD\" have been added to explain the  standards and calculations  used for Basis of Design  and procedure for linking to AutoCAD."]
[null,2.2999999999999998,"On Entry Form, following changes done\nAdded Curve lane widening requirement\nRemoved Overtaking Continuation Sight Distance (OCD) values   \nAdded Overtaking length and Barrier line length\nRevised Sag curve K values for Car and Truck based on head light criteria.\nAdded Deceleration Lane Lengths values.  \nRemoved Clear zone requirement \nAdded Hazard treatment   option\nRevised How to use,Data Information, Link Excel to CAD, Drop Lists and Calculation spread sheets to reflect the updated changes.  ","11th December 2023"]

{"sheet":"How to use","index":1,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Basis of Design Use Instructions"]
[]
[null,"On the \"Entry Form\" worksheet"]
[null,"1. Enter all required information into the allocated cells in \"column B\" for one Road design  and in \"column E \"for a second Road design ."]
[null,"2. To select multiple standards and guides, open the drop box as many times as required and select them all individually"]
[null,"3. If a standard is selected by mistake, click  on cell, right click and select \"Clear Contents\" to start again."]
[null,"5. Not all cells need to be filled in before you press the \"Data Log\" button. This allows for a preliminary design to be done whilst you wait for extra information"]
[null,"6. Make amendments to the design by updating all the necessary fields."]
[null,"7. \"Clear all Data\" will clean the project specific and  guideline design input from \"Entry Form \"."]
[null,"8. View all the design data and compare to the minimum or maximum standard required."]
[null,"9. If project requirement meet the design guidelines , the comment will appear as \"N/A\". If project requirement does not meet the design guidelines , the comment will appear as \"No Explanation Given\"."]
[null,"10. Provide explanations for any extended designs you've used with any appropriate clauses in comment section . To add comments , first import the data link in AutoCAD, then unlock the relevant cell and provide explanation."]
[null,"11. Press \"Data Log ROAD 1\" to  transfer the data for  one road design on \"ROAD 1' worksheet.  Press \"Data Log ROAD 2\" to  transfer the data for 2 roads design to\" ROAD 1 and ROAD 2\" worksheet."]
[null,"A copy will be left on the \"Entry Form\" worksheet"]
[null,"Note:  "]
[null,"The work  sheets  named  \"ROAD 1\" or \"ROAD 1 and ROAD 2\" will change their names  based on Road Name entered in \"Cell B2\" and \"Cell E2\" in \"Entry Form \" worksheet."]
[]
[null,"On the \"Data Information \" worksheet"]
[null,"1. this work sheet explains that which Australian standards and reference have been used and selected as a criteria for Basis of Design."]
[]
[null,"On the \"Link Excel to CAD \" worksheet"]
[null,"1. this work sheet explains how we can transfer the data from Excel to AutoCAD and update the changes if required."]
[]
[null,"On the \"Design Standards and Guides\" worksheet"]
[null,"1. All the relevant DIPL design standards and guides to be used are listed here with any links as appropriate"]
[]
[null,"On the \"Drop lists\" worksheet"]
[null,"1. This sheet contains all the drop lists , do not change these values"]
[]
[null,"On the \"Calculation\" worksheet"]
[null,"1. This sheet contains all  formulas used, do not change these values"]
[]
[null,"On the \"ROAD 1\" worksheet"]
[null,"1. This sheet is used to create a data link between this file and AutoCAD for 1 Road design option, do not change the settings"]
[]
[null,"On the \"ROAD  1 and ROAD 2 \" worksheet"]
[null,"1. This sheet is used to create a data link between this file and AutoCAD for 2 Roads design Option, do not change the settings"]
[]
[null,"Note:"]
[null,"The designer needs to revise his design and provide comments   based on the prompts appear in the comment section after importing the basis of design table into the AutoCAD.e.g"]
[null,"If the project design values < Guideline Design Values , the prompts come as \"Provide Explanation\""]
[null,"If  the prompts come as \" Curve lane wideneing required\" the designer need to update the design and  select \" Curve lane wideneing applied\""]

{"sheet":"Data Information ","index":2,"n_rows":73,"n_cols":2,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["BASIS OF DESIGN"]
["PROJECT CRITERIA"," PROJECT SPECIFIC VALUES REFERENCE "]
["ROAD CLASS - AUSTROADS CLASS","https://dipl.nt.gov.au/__data/assets/pdf_file/0014/240404/Performance-and-Design-Standards-for-Northern-Territory-Government-Roads.pdf"]
["DESIGN VEHICLE","Austroad codes doc  - Road categories picture"]
["DESIGN SPEED (km/h)","Drop down list provided"]
["POSTED SPEED (km/h)","Drop down list provided"]
["REACTION TIME","Austroad road design guide part 3 –  table 5.2, page 124,"]
["CARRIAGEWAY TYPE","Drop down list provided"]
["SURFACE SEAL TYPE","Sealed/Unsealed"]
["MAX SUPERELEVATION (%)","3% used for sealed roads & 4% used for unsealed roads"]
["GEOMETRY"]
["1. MIN HORIZONTAL CURVE RADIUS FOR CAR (m)","Austroad road design guide part 3 –  Equation 5 , page 159     "]
["1. MIN HORIZONTAL CURVE RADIUS FOR TRUCK (m)","Austroad road design guide part 3 –  Equation 5 , page 159     "]
["CURVE LANE WIDENING","Drop down list provided"]
["2. MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m)","Austroad road design guide part 3 –  Table 5.9 , page 141"]
["3. MIN OVERTAKING LENGTH  (m)","AS1742.2 Table 5.2, page 150"]
["4. MIN LENGTH OF BARRIER LINES (m)","AS1742.2 Table 5.2, page 150"]
["5. MIN CAR STOPPING SIGHT DISTANCE (m)","Austroad road design guide part 3 –  Equation 1 , page 128"]
["6. MIN TRUCK STOPPING SIGHT DISTANCE (m)","Austroad road design guide part 3 –  Equation 1 , page 128"]
["7. MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)","Austroad road design guide part 4A –  Equation 2 , page 18"]
["8. MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m)","Austroad road design guide part 4A –  Equation 2 , page 18"]
["9. MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L)","Austroad road design guide part 3 –  Equation 18 , page 212"]
["10. MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L)","Austroad road design guide part 3 –  Equation 18, page 212"]
["11. MIN SAG  VERTICAL CURVE K VALUE FOR CARS","Austroad road design guide part 3/ Figure 8.9 page 221"]
["12. MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK","Austroad road design guide part 3/ Figure 8.9 page 221"]
["13. DECELERATION LANE INCLUDING TAPER TO STOP CONDITION","Austroad road design guide part 4A –  Table 5.2 , page 36 , Equation 6 &7 ,page 37"]
["HAZARD TREATMENT","Drop down list provided"]
["NUMBER OF TRAFFIC ACCIDENTS (IN THE LAST 10 YEARS:","https://dipl.nt.gov.au/data/traffic-report"]
["GUIDE AND STANDARD USED","Austroad pavement technology part 2"]
[""]
["ROAD SAFETY AUDIT"]
["ROAD SAFETY AUDIT UNDERTAKEN","https://dipl.nt.gov.au/industry/technical-standards-guidelines-and-specifications/road-safety-audits"]
[""]
["PAVEMENT"]
["TRAFFIC VOLUME (AADT / YEAR)","https://dipl.nt.gov.au/data/traffic-report"]
["GROWTH RATE (%)","https://dipl.nt.gov.au/data/traffic-report"]
["PERCENT HEAVY VEHICLES (%)","https://dipl.nt.gov.au/data/traffic-report"]
["DESIGN TRAFFIC IN ESA'S (X 10^6)","Austroad pavement technology part 2"]
["PAVEMENT DESIGN LIFE (YEARS)"]
["DESIGN CBR VALUES"]
["FROM CH. TO CH."]
["DESIGN METHOD USED","Austroad pavement technology part 2"]
["GUIDE AND STANDARD USED","Austroad pavement technology part 2"]
[""]
["ROAD SAFETY BARRIERS"]
["ROAD SAFETY BARRIERS USED","https://dipl.nt.gov.au/industry/technical-standards-guidelines-and-specifications/road-safety-barriers"]
["APPROACH TERMINALS USED"]
["END TERMINALS USED"]
[""]
["DRAINAGE"]
["MAJOR SYSTEM CAPACITY (URBAN)","https://dipl.nt.gov.au/__data/assets/pdf_file/0015/240423/StormwaterDrainage.pdf"]
["MINOR SYSTEM CAPACITY  (URBAN)"]
["CULVERT DESIGN "]
["FLOODWAY DESIGN "]
["BRIDGE DESIGN"]
["AATOC"]
["PROTECTED AT X% AEP"]
["GUIDE AND STANDARD USED","Austroad road design guide part5/5A/5B/Australian Rainfall and Runoff 2016"]
[""]
["SURVEY"]
["SURVEY BY"]
["DATE OF SURVEY"]
["GEODETIC DATUM"]
["LEVEL DATUM"]
[""]
["LIGHTING"]
["ROADWAY LIGHTING LEVEL","AS1158.1.1:2005 Cat V table 2.1 page 9"]
["INTERSECTION LIGHTING LEVEL","AS1158.1.1:2005 Cat V page 35(c) flag lighting"]
["","AS1158.3.1:2020 Cat P table 2.1 page 13"]
["SIDE TRACK FOR DETOURS"]
["SIDE TRACK STANDARD"]
[]
["LIGHTING STANDARDS"]

{"sheet":"Link Excel to CAD","index":3,"n_rows":262,"n_cols":2,"rows_kept":262,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PROJECT EXAMPLES:"]

{"sheet":"Design Standards and Guides","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Surface treatment Guides and Standards",null,"Geometry Guides and Standards",null,"Pavement Guides and Standards",null,"Drainage Guides and Standards"]
[]
["Bituminous Surfacing Works Treatment And Selection",null,"Austroads Guide to Road Design Part 1",null,"Road Pavement Acceptance During Construction",null,"Austroads Guide to Road Design Part 5"]
[null,null,"Austroads Guide to Road Design Part 2",null,"Austroads Guide to Pavement Technology Part 2",null,"Austroads Guide to Road Design Part 5A"]
[null,null,"Austroads Guide to Road Design Part 3",null,null,null,"Austroads Guide to Road Design Part 5B"]
[null,null,"Austroads Guide to Road Design Part 4",null,null,null,"Australian Rainfall and Runoff 2016"]
[null,null,"Austroads Guide to Road Design Part 4A"]
[null,null,"Austroads Guide to Road Design Part 4B"]
[null,null,"Austroads Guide to Road Design Part 4C"]
[null,null,"Austroads Guide to Road Design Part 6"]
[null,null,"Austroads Guide to Road Design Part 6A"]
[null,null,"Austroads Guide to Road Design Part 6B"]
[null,null,"Austroads Guide to Road Design Part 7"]
[null,null,"Austroads Guide to Road Design Part 8"]

{"sheet":"Drop lists","index":5,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["Road class","CH lookup","Reaction Time (sec)","Pavement Surface seal","CARRIAGEWAY TYPE","Car/Truck","Design Vehicle",null,"Design Speeds","Reaction Time","Hazard Treatment","Geometry Guides and Standards","Road Safety Audit","Growth Rate (%)","Percent Heavy Vehicles (%)","Pavement Design Life (Years)","Design method used","Pavement Guides and Standards","Geodetic Datum","Level Datum"]
["Choose an item"," ",null,"Choose an item","Choose an item",null,"Choose an item",null,"Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item"]
["Rural National Highway - Class 1","V3",2.5,"Sealed","Inbound","C","Passenger vehicle (5.2m)","A",50,"1.5 seconds","Traversable 1 in 6 batter","AGRD Part 01","Stage 1 - Feasibility Design",0.01,0.01,10,"Empirical design","AGPT Part 1","GDA94, MGA Zone 52","A.H.D"]
["Urban National Highway - Class 1","V3",2,"Asphalt","Outbound","C","Service vehicle (8.8m)","A",60,"2.0 seconds","Traversable 1 in 4 batter","AGRD Part 02","Stage 2 - Preliminary Design",0.02,0.02,15,"Mechanistic procedure","AGPT Part 2","GDA94, MGA Zone 53","Local"]
["Rural  Arterial - Class 3","V2",2.5,"Unsealed","Undivided two way","T","Single unit truck bus (12.5m)","A",70,"2.5 seconds","Culvert Traversable wingwalls and grates","AGRD Part 03","Stage 3 - Detailed Design",0.03,0.03,20,"Base Thickness design",null,"GDA2020, MGA Zone 52"]
["Rural Secondary - Class 4","V4/V5",2.5,null,null,"T","Long rigid bus (14.5m)","A",80,null,"Road Safety Barrier","AGRD Part 04","Stage 4 - Pre-opening",0.04,0.04,25,"CIRCLY",null,"GDA2020, MGA Zone 53"]
["Rural Local - Class 5","P3/P4",2.5,"Curve LANE Widening",null,"T","Articulated bus (19m)","A",90,null,null,"AGRD Part 4A","Work Zone Traffic Management",0.05,0.05,30,"AASHTOWare",null,"WGS84"]
["Pastoral 1 - Class 5","V4/V5",2.5,"Choose an item",null,"T","Prime mover and semi-trailer (19m)","A",100,null,null,"AGRD Part 4B","Land Use Developments",0.06,0.06,35,"DesignPave"]
["Pastoral 2 - Class 5","V4/V5",2.5,"Curve lane widening applied",null,"T","Prime mover and long semi-trailer (25m)","A",110,null,null,"AGRD Part 4C","Existing Roads",7.0000000000000007E-2,7.0000000000000007E-2,40,"PAVEXpress"]
["Pastoral 3 - Class 5","V4/V5",2.5,"Curve lane widening not applied",null,"T","B-double (25m)","B",120,null,null,"AGRD Part 06","None",0.08,0.08,"N/A","N/A"]
["Urban Primary Arterial - Class 6","V1",2,"N/A",null,"T","B-double (26m)","B",130,null,null,"AGRD Part 6A","N/A",0.09,0.09]
["Urban Sub Arterial - Class 7","V4/V5",2,null,null,"T","A-double (Type 1)(36.2m)","C",140,null,null,"AGRD Part 6B",null,0.1,0.1]
["Urban Collector - Class 8","P3/P4",2,null,null,"T","B-triple (35.4m)","C",null,null,null,"AGRD Part 07",null,"N/A",0.11]
["Urban Local - Class 9","P1/P2",2,null,null,"T","A-triple (Type 2)(53.4m)","D",null,null,null,"AGRD Part 08",null,null,0.12]
[null,null,null,null,null,null,null,null,null,null,null,"AS1742 Parts 1-15",null,null,0.13]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM  Part 01",null,null,0.14000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 02",null,null,0.15]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 03",null,null,0.16]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 04",null,null,0.17]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 05",null,null,0.18]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 06",null,null,0.19]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 07",null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 08",null,null,0.21]
[null,null,null,null,null,null,null,null,null,null,null,"AGTM Part 09",null,null,0.22]
["Barriers","Approach terminals","End terminals","Major storm capacity","Protected at x% AEP","Drainage Guides and Standards","Lighting","Intersection lighting ","Side Track Standard",null,null,"AGTM Part 10",null,null,0.23]
["Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item",null,null,"AGTM Part 11",null,null,0.24]
["MASH  TL1 - STEEL BEAM BARRIER","MASH TL1 GATING TERMINAL ","MASH TL1 GATING TERMINAL ","0.5EY",0.01,"AGRD Part 5","V1","V1","Built Under Traffic",null,null,"AGTM Part 12",null,null,0.25]
["MASH  TL2 - STEEL BEAM BARRIER","MASH TL2 GATING TERMINAL ","MASH TL2 GATING TERMINAL ","0.2EY",0.02,"AGRD Part 5A","V2","V2","Detour Designed for  National Highway",null,null,"AGTM Part 13",null,null,0.26]
["MASH  TL3 - STEEL BEAM BARRIER","MASH TL3 GATING TERMINAL ","MASH TL3 GATING TERMINAL ","0.11EY",0.05,"AGRD Part 5B","V3","V3","Detour Designed for  Secondary Highway",null,null,null,null,null,0.27]
["MASH  TL4 - STEEL BEAM BARRIER","MASH TL4 GATING TERMINAL ","MASH TL4 GATING TERMINAL ","0.05EY",0.1,"Australian Rainfall and Runoff 2016","V4/V5","V4/V5","Detour Designed for  Local Road",null,null,null,null,null,0.28000000000000003]
["NCHRP 350  TL2 - WIRE ROPE BARRIER","N/A","GATING FISH TAIL END TERMINAL","0.02EY",0.2,null,"PR1/PR2","PR1/PR2",null,null,null,null,null,null,0.28999999999999998]
["NCHRP 350  TL3 - WIRE ROPE BARRIER",null,"N/A","0.01EY",0.5,null,"PR3/PR4","PR3/PR4",null,null,null,null,null,null,0.3]
["NCHRP 350  TL4 - WIRE ROPE BARRIER",null,null,"N/A","N/A",null,"N/A","FLAG  LIGHTING",null,null,null,null,null,null,0.31]
["N/A",null,null,null,null,null,null,"N/A",null,null,null,null,null,null,0.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38999999999999901]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39999999999999902]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Surface treatment Guides and Standards","Minor storm capacity","Trafficable at x% AEP"]
["Choose an item","Choose an item","Choose an item"]
["Bituminous Surfacing Works Treatment And Selection","0.5EY",0.01]
[null,"0.2EY",0.02]
[null,"0.11EY",0.05]
[null,"0.05EY",0.1]
[null,"0.02EY",0.2]
[null,"0.01EY",0.5]
[null,"N/A","N/A"]

{"sheet":"Calculation","index":6,"n_rows":52,"n_cols":41,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,32,39,36],[9,34,10,34],[7,9,7,14],[10,11,10,12],[24,0,24,3],[25,0,25,3],[9,9,10,9],[13,22,13,31],[56,9,56,13],[37,22,37,31],[33,16,34,16],[38,1,39,2],[34,15,35,15],[33,10,33,14]]}
[]
[null,"SEALED/ASPHALT"]
[]
[null,"e Max",3,"dcar",0.36,"d truck",0.28999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e Max",3,"dcar",0.36,"d truck",0.28999999999999998,"d lane",{"$f":"2.5/9.81","v":0.254841997961264}]
[null,"h1 car",1.1000000000000001,"h1truck",2.4,"h2",0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h1 car",1.1000000000000001,"h1truck",2.4,"h2",0.2]
["Geometry:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rt",{"$f":"LEFT('Entry Form'!$B$7,3)","v":"0"}]
[null,"ROAD A","ROAD B"]
["Rt",{"$f":"LEFT('Entry Form'!B7,3)","v":"0"},{"$f":"LEFT('Entry Form'!E7,3)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEALED / ASPHALT"]
["Design Speed",{"$f":"'Entry Form'!B5","v":"Choose an item"},{"$f":"'Entry Form'!E5","v":"Choose an item"},null,"Reference"]
["Operating Speed",{"$f":"'Entry Form'!B6","v":""},{"$f":"'Entry Form'!E6","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESIGN /OPERATING SPEED",50,60,70,80,90,100,110,120,130,140,null,null,"Vposted","VOP/des","fmax(car)","fmax(truck)"]
["MIN HORIZONTAL CURVE RADIUS  CAR(m)   #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,3,FALSE)","v":{"$error":"#N/A"}},"Rmin=V2/127(emax+fmax) , AGRD Part 3 :Eq 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSTED SPEED",40,50,60,70,80,90,100,110,120,130,null,null,null,null,"Desire max",null,"OL","BL","d (unsealed)"]
["MIN HORIZONTAL CURVE RADIUS TRUCK (m) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,4,FALSE)","v":{"$error":"#N/A"}},"Rmin=V2/127(emax+fmax) , AGRD Part 3 :Eq 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN HORIZONTAL CURVE RADIUS (C) ",{"$f":"_xlfn.CEILING.MATH(((W10)^2)/(((127)*(($X$4/100)+VLOOKUP(W10,$AJ$12:$AN$22,2,FALSE)))),5)","v":60},{"$f":"_xlfn.CEILING.MATH(((X10)^2)/(((127)*(($X$4/100)+VLOOKUP(X10,$AJ$12:$AN$22,2,FALSE)))),5)","v":105},180,270,400,525,640,810,955,1105,null,null,30,40,0.3,0.21,100,60,0.27]
["MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m) #",{"$f":"IF('Entry Form'!B5<>\"\",VLOOKUP('Entry Form'!B5,Calculation!K37:O47,Calculation!L35,FALSE),\"\")","v":{"$error":"#N/A"}},{"$f":"IF('Entry Form'!E6<>\"\",VLOOKUP('Entry Form'!E5,Calculation!K37:O47,Calculation!O35,FALSE),\"\")","v":""},"Table :5.9 page 139, AGRD part 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN HORIZONTAL CURVE RADIUS (T) ",{"$f":"_xlfn.CEILING.MATH(((W10)^2)/(((127)*(($X$4/100)+VLOOKUP(W10,$AJ$12:$AN$22,3,FALSE)))),5)","v":85},{"$f":"_xlfn.CEILING.MATH(((X10)^2)/(((127)*(($X$4/100)+VLOOKUP(X10,$AJ$12:$AN$22,3,FALSE)))),5)","v":145},230,315,430,525,640,810,955,1105,null,null,40,50,0.3,0.21,125,75,0.27]
["MIN OVERTAKING LENGTH  (m) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,6,FALSE)","v":{"$error":"#N/A"}},"Table 5.2 AS1742.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m) #","ESD and Overtaking lane values are applicable for sealed  undivided 2way carriageway.",null,null,null,null,null,null,null,null,null,null,null,50,60,0.24,0.17,150,90,0.27]
["MIN LENGTH OF BARRIER LINES (m) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,7,FALSE)","v":{"$error":"#N/A"}},"Table 5.2 AS1742.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN OVERTAKING LENGTH  (m) #",{"$f":"_xlfn.CEILING.MATH(VLOOKUP(W10,$AJ$12:$AN$22,4,FALSE),5)","v":125},{"$f":"_xlfn.CEILING.MATH(VLOOKUP(X10,$AJ$12:$AN$22,4,FALSE),5)","v":150},175,200,225,250,275,300,300,300,null,null,60,70,0.19,0.14000000000000001,175,105,0.26]
["MIN CAR STOPPING SIGHT DISTANCE (m) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,8,FALSE)","v":{"$error":"#N/A"}},"SSD= [RtV/3.6]+[V2/254(d)] , AGRD Part 3 :Eq 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN LENGTH OF BARRIER LINES (m) #",{"$f":"_xlfn.CEILING.MATH(VLOOKUP(W10,$AJ$12:$AN$22,5,FALSE),5)","v":75},{"$f":"_xlfn.CEILING.MATH(VLOOKUP(X10,$AJ$12:$AN$22,5,FALSE),5)","v":90},105,120,135,150,165,180,180,180,null,null,70,80,0.16,0.13,200,120,0.25]
["MIN TRUCK STOPPING SIGHT DISTANCE (m) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,9,FALSE)","v":{"$error":"#N/A"}},"SSD= [RtV/3.6]+[V2/254(d)] , AGRD Part 3 :Eq 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN CAR STOPPING SIGHT DISTANCE (m) #",{"$f":"_xlfn.CEILING.MATH((($X$6*W10)/3.6) + ((W10^2)/((254*$Z$4))),5)","v":30},{"$f":"_xlfn.CEILING.MATH((($X$6*X10)/3.6) + ((X10^2)/((254*$Z$4))),5)","v":40},55,70,90,110,135,160,185,215,null,null,80,90,0.13,0.12,225,135,0.24]
["MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)  #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,10,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,10,FALSE)","v":{"$error":"#N/A"}},"SISD= [DtV/3.6]+[V2/254(d)] used  AGRD Part 4A :Eq 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN TRUCK STOPPING SIGHT DISTANCE (m) #",{"$f":"_xlfn.CEILING.MATH((($X$6*W10)/3.6) + ((W10^2)/((254*$AB$4))),5)","v":35},{"$f":"_xlfn.CEILING.MATH((($X$6*X10)/3.6) + ((X10^2)/((254*$AB$4))),5)","v":50},70,90,110,140,165,200,230,270,null,null,90,100,0.12,0.12,250,150,0.24]
["MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,11,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,11,FALSE)","v":{"$error":"#N/A"}},"SISD= [DtV/3.6]+[V2/254(d)] used  AGRD Part 4A :Eq 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)  #",{"$f":"_xlfn.CEILING.MATH(((($X$6+3)*W10)/3.6) + ((W10^2)/((254*$Z$4))),5)","v":70},{"$f":"_xlfn.CEILING.MATH(((($X$6+3)*X10)/3.6) + ((X10^2)/((254*$Z$4))),5)","v":90},115,140,165,195,225,260,295,335,null,null,100,110,0.12,0.12,275,165,0.24]
["MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,12,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,12,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h11/2+h21/2)2 AGRD Part 3 :Eq 18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m) #",{"$f":"_xlfn.CEILING.MATH(((($X$6+3)*W10)/3.6) + ((W10^2)/((254*$AB$4))),5)","v":80},{"$f":"_xlfn.CEILING.MATH(((($X$6+3)*X10)/3.6) + ((X10^2)/((254*$AB$4))),5)","v":100},125,155,185,220,260,300,340,385,null,null,110,120,0.11,0.11,300,180,0.24]
["MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L) #",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,13,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h11/2+h21/2)2 AGRD Part 3 :Eq 18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L) #",{"$f":"_xlfn.CEILING.MATH((W17^2)/(200*((($X$5^0.5)+($AB$5^0.5))^2)),2)","v":4},{"$f":"_xlfn.CEILING.MATH((X17^2)/(200*((($X$5^0.5)+($AB$5^0.5))^2)),5)","v":5},10,15,20,30,45,60,80,105,null,null,120,130,0.11,0.11,300,180,0.24]
["MIN SAG  VERTICAL CURVE K VALUE FOR CAR",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,14,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,14,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h+Stanq) C4  (Headlight Criteria) ",null,null,null,{"$f":"IF(OR(RIGHT('Entry Form'!B3,1)=\"1\",RIGHT('Entry Form'!B3,1)=\"5\"),B22,B23)","v":{"$error":"#N/A"}},"Col:B",null,null,null,null,null,null,null,null,null,null,null,null,"MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L) #",{"$f":"_xlfn.CEILING.MATH((W18^2)/(200*((($Z$5^0.5)+($AB$5^0.5))^2)),5)","v":5},{"$f":"_xlfn.CEILING.MATH((X18^2)/(200*((($Z$5^0.5)+($AB$5^0.5))^2)),5)","v":5},10,15,{"$f":"_xlfn.CEILING.MATH((AA18^2)/(200*((($Z$5^0.5)+($AB$5^0.5))^2)),5)","v":20},25,{"$f":"_xlfn.CEILING.MATH((AC18^2)/(200*((($Z$5^0.5)+($AB$5^0.5))^2)),5)","v":35},55,70,95,null,null,130,140,0.11,0.11,300,180,0.24]
["MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,15,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,15,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h+Stanq) C4  (Headlight Criteria) ",null,null,null,{"$f":"IF(OR(RIGHT('Entry Form'!E3,1)=\"1\",RIGHT('Entry Form'!E3,1)=\"5\"),C22,C23)","v":{"$error":"#N/A"}},"Col:E",null,null,null,null,null,null,null,null,null,null,null,null,"MIN SAG  VERTICAL CURVE K VALUE FOR CAR",{"$f":"_xlfn.CEILING.MATH((W17^2)/((200)*(0.65+(W17*0.01746))),5)","v":5},{"$f":"_xlfn.CEILING.MATH((X17^2)/((200)*(0.65+(X17*0.01746))),5)","v":10},{"$f":"_xlfn.CEILING.MATH((Y17^2)/((200)*(0.65+(Y17*0.01746))),5)","v":10},15,20,{"$f":"_xlfn.CEILING.MATH((AB17^2)/((200)*(0.65+(AB17*0.01746))),5)","v":25},35,40,45,{"$f":"_xlfn.CEILING.MATH((AF17^2)/((200)*(0.65+(AF17*0.01746))),5)","v":55}]
["Deceleration Lane Including taper to stop Condition (Formaula based)",{"$f":"HLOOKUP($B$9,$W$10:$AF$25,16,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$9,$W$10:$AF$25,16,FALSE)","v":{"$error":"#N/A"}},"D=V2/254d Equation  6 , Table 5.2\nAGRD part 4A   V= Design Speed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK",{"$f":"_xlfn.CEILING.MATH((W18^2)/((200)*(0.65+(W18*0.01746))),5)","v":5},{"$f":"_xlfn.CEILING.MATH((X18^2)/((200)*(0.65+(X18*0.01746))),5)","v":10},{"$f":"_xlfn.CEILING.MATH((Y18^2)/((200)*(0.65+(Y18*0.01746))),5)","v":15},{"$f":"_xlfn.CEILING.MATH((Z18^2)/((200)*(0.65+(Z18*0.01746))),5)","v":20},{"$f":"_xlfn.CEILING.MATH((AA18^2)/((200)*(0.65+(AA18*0.01746))),5)","v":25},35,40,50,60,{"$f":"_xlfn.CEILING.MATH((AF18^2)/((200)*(0.65+(AF18*0.01746))),5)","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deceleration Lane Including taper to stop Condition (Formaula based)",{"$f":"_xlfn.CEILING.MATH((W10^2)/(254*$AD$4),5)","v":40},{"$f":"_xlfn.CEILING.MATH((X10^2)/(254*$AD$4),5)","v":60},80,100,130,155,190,225,265,305]
[]
[null,"UNSEALED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e Max",4,"dcar",0.36,"d truck",0.2,"d lane",{"$f":"2.5/9.81","v":0.254841997961264}]
[null,"e Max",4,"dcar","Table 5.4","d truck",0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h1 car",1.1000000000000001,"h1truck",2.4,"h2",0.2]
[null,"h1 car",1.1000000000000001,"h1truck",2.4,"h2",0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rt",{"$f":"LEFT('Entry Form'!$E$7,3)","v":"0"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road B",{"$f":"IF(AND(LEFT('Entry Form'!E4,2)<>\"Pa\",LEFT('Entry Form'!E4,2)<>\"Se\"),LEFT('Entry Form'!E4,1)&RIGHT('Entry Form'!E4,7),\"Pa\")","v":"Can item"},{"$f":"VLOOKUP(R32,$R$36:$T$46,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(R32,$R$36:$T$46,3,FALSE)","v":{"$error":"#N/A"}},null,"UNSEALED"]
[null,"ROAD A","ROAD B",null,null,null,null,null,null,null,null,null,null,null,null,null,"Road A",{"$f":"IF(AND(LEFT('Entry Form'!B4,2)<>\"Pa\",LEFT('Entry Form'!B4,2)<>\"Se\"),LEFT('Entry Form'!B4,1)&RIGHT('Entry Form'!B4,7),\"Pa\")","v":"Can item"},{"$f":"VLOOKUP(R33,$R$36:$T$46,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(R33,$R$36:$T$46,3,FALSE)","v":{"$error":"#N/A"}}]
["Rt",{"$f":"LEFT('Entry Form'!B7,3)","v":"0"},{"$f":"LEFT('Entry Form'!E7,3)","v":"0"},null,null,null,null,null,null,null,"Overtaking Establishment Sight Distance",null,null,null,null,null,"Vdes","Curve Radius for Truck",null,null,null,"DESIGN /OPERATING SPEED",50,60,70,80,90,100,110,120,130,140,"Rmin=V2/127(emax+fmax) , AGRD Part 3 :Eq 5"]
["Design Speed",{"$f":"'Entry Form'!B5","v":"Choose an item"},{"$f":"'Entry Form'!E5","v":"Choose an item"},null,"Reference",null,null,null,null,"DESIGN VEHICLE B & E:",{"$f":"VLOOKUP('Entry Form'!B4,'Drop lists'!G2:H14,2,FALSE)","v":0},{"$f":"ch2num(K35)","v":-15},null,{"$f":"VLOOKUP('Entry Form'!E4,'Drop lists'!G2:H14,2,FALSE)","v":0},{"$f":"ch2num(N35)","v":-15},"d car\nUnsealed",null,"Design Vehicle","Min Curve","Max Curve",null,"POSTED SPEED",40,50,60,70,80,90,100,110,120,130,"Rmin=V2/127(emax+fmax) , AGRD Part 3 :Eq 5"]
["Operating Speed",{"$f":"'Entry Form'!B6","v":""},{"$f":"'Entry Form'!E6","v":""},null,null,null,null,null,null,"VPOSTED","VDES/OP","A","B","C","D",null,null,"S(12.5m)",40,400,null,"MIN HORIZONTAL CURVE RADIUS (C) ",{"$f":"_xlfn.CEILING.MATH(((W34)^2)/(((127)*(($X$28/100)+VLOOKUP(W34,$AJ$12:$AN$22,2,FALSE)))),5)","v":60},{"$f":"_xlfn.CEILING.MATH(((X34)^2)/(((127)*(($X$28/100)+VLOOKUP(X34,$AJ$12:$AN$22,2,FALSE)))),5)","v":105},170,255,380,495,600,760,890,1030,"Table :5.9 page 139, AGRD part 3"]
["MIN HORIZONTAL CURVE RADIUS  CAR(m)  #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,3,FALSE)","v":{"$error":"#N/A"}},"Rmin=V2/127(emax+fmax) , AGRD Part 3 :Eq 5",null,null,null,null,null,30,40,"N/A","N/A","N/A","N/A",0.27,50,"L(14.5m)",60,600,null,"MIN HORIZONTAL CURVE RADIUS (T) ",{"$f":"_xlfn.CEILING.MATH(((W34)^2)/(((127)*(($X$28/100)+VLOOKUP(W34,$AJ$12:$AN$22,3,FALSE)))),5)","v":80},{"$f":"_xlfn.CEILING.MATH(((X34)^2)/(((127)*(($X$28/100)+VLOOKUP(X34,$AJ$12:$AN$22,3,FALSE)))),5)","v":135},215,300,400,495,600,760,890,1030,"Table 5.2 AS1742.2"]
["MIN HORIZONTAL CURVE RADIUS TRUCK (m)  #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,4,FALSE)","v":{"$error":"#N/A"}},"Rmin=V2/127(emax+fmax) , AGRD Part 3 :Eq 5",null,null,null,null,null,40,50,"N/A","N/A","N/A","N/A",0.27,60,"As (19m)",50,450,null,"MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m) #","ESD and Overtaking lane values are applicable for sealed  undivided 2way carriageway.",null,null,null,null,null,null,null,null,null,"Table 5.2 AS1742.2"]
["MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m) #","ESD and Overtaking lane values are applicable for sealed  undivided 2way carriageway.",null,null,null,null,null,null,null,50,60,"N/A","N/A","N/A","N/A",0.27,70,"Pr (19m)",70,600,null,"MIN OVERTAKING LENGTH  (m) #",{"$f":"VLOOKUP(W34,$AJ$12:$AN$22,4,FALSE)","v":125},{"$f":"VLOOKUP(X34,$AJ$12:$AN$22,4,FALSE)","v":150},175,200,225,250,275,300,300,300,"N/A for unsealed roads"]
["MIN OVERTAKING LENGTH  (m)  #",null,null,null,null,null,null,null,null,60,70,570,600,640,690,0.26,80,"Pr (25m)",120,1200,null,"MIN LENGTH OF BARRIER LINES (m) #",{"$f":"VLOOKUP(W34,$AJ$12:$AN$22,5,FALSE)","v":75},{"$f":"VLOOKUP(X34,$AJ$12:$AN$22,5,FALSE)","v":90},105,120,135,150,165,180,180,180]
["Coefficient of  Deceleration (d) FOR UNSEALED",{"$f":"VLOOKUP($B$35,$AJ$12:$AO$22,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$35,$AJ$12:$AO$22,6,FALSE)","v":{"$error":"#N/A"}},"AGRD PART 3 : Table 5.4",null,null,null,null,null,70,80,710,740,790,860,0.25,90,"Be (25m)",80,800,null,"MIN CAR STOPPING SIGHT DISTANCE (m) #",{"$f":"_xlfn.CEILING.MATH((($X$30*W34)/3.6) + ((W34^2)/((254*(VLOOKUP(W34,$AJ$12:$AO$22,6,FALSE))))),5)","v":40},{"$f":"_xlfn.CEILING.MATH((($X$30*X34)/3.6) + ((X34^2)/((254*(VLOOKUP(X34,$AJ$12:$AO$22,6,FALSE))))),5)","v":55},75,105,135,165,200,240,280,325,"SSD= [RtV/3.6]+[V2/254(d)] , AGRD Part 3 :Eq 1"]
["MIN CAR STOPPING SIGHT DISTANCE (m)  #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,8,FALSE)","v":{"$error":"#N/A"}},"SSD= [RtV/3.6]+[V2/254(d)] , AGRD Part 3 :Eq 1",null,null,null,null,null,80,90,850,890,950,1040,0.24,100,"Be (26m)",90,900,null,"MIN TRUCK STOPPING SIGHT DISTANCE (m) #",{"$f":"_xlfn.CEILING.MATH((($X$30*W34)/3.6) + ((W34^2)/((254*$AB$28))),5)","v":50},{"$f":"_xlfn.CEILING.MATH((($X$30*X34)/3.6) + ((X34^2)/((254*$AB$28))),5)","v":75},100,130,160,200,240,285,335,390,"SSD= [RtV/3.6]+[V2/254(d)] , AGRD Part 3 :Eq 1"]
["MIN TRUCK STOPPING SIGHT DISTANCE (m)  #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,9,FALSE)","v":{"$error":"#N/A"}},"SSD= [RtV/3.6]+[V2/254(d)] , AGRD Part 3 :Eq 1",null,null,null,null,null,90,100,1020,1070,1130,1240,0.24,110,"A(36.2m)",120,1200,null,"MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)  #",{"$f":"_xlfn.CEILING.MATH(((($X$30+3)*W34)/3.6) + ((W34^2)/((254*(VLOOKUP(W34,$AJ$12:$AO$22,6,FALSE))))),5)","v":80},{"$f":"_xlfn.CEILING.MATH(((($X$30+3)*X34)/3.6) + ((X34^2)/((254*(VLOOKUP(X34,$AJ$12:$AO$22,6,FALSE))))),5)","v":105},135,170,210,250,295,340,390,440,"SISD= [DtV/3.6]+[V2/254(d)] used  AGRD Part 4A :Eq 2"]
["MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)  #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,10,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,10,FALSE)","v":{"$error":"#N/A"}},"SISD= [DtV/3.6]+[V2/254(d)] used  AGRD Part 4A :Eq 2",null,null,null,null,null,100,110,1230,1290,1200,1310,0.24,120,"B(35.4m)",120,1200,null,"MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m) #",{"$f":"_xlfn.CEILING.MATH(((($X$30+3)*W34)/3.6) + ((W34^2)/((254*$AB$28))),5)","v":95},{"$f":"_xlfn.CEILING.MATH(((($X$30+3)*X34)/3.6) + ((X34^2)/((254*$AB$28))),5)","v":125},155,195,235,285,330,385,445,505,"SISD= [DtV/3.6]+[V2/254(d)] used  AGRD Part 4A :Eq 2"]
["MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m) (Based on Op speed) #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,11,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,11,FALSE)","v":{"$error":"#N/A"}},"SISD= [DtV/3.6]+[V2/254(d)] used  AGRD Part 4A :Eq 2",null,null,null,null,null,110,120,1230,1290,1200,1310,0.24,130,"A(53.4m)",160,1600,null,"MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L) #",{"$f":"_xlfn.CEILING.MATH((W41^2)/(200*((($X$29^0.5)+($AB$29^0.5))^2)),5)","v":5},{"$f":"_xlfn.CEILING.MATH((X41^2)/(200*((($X$29^0.5)+($AB$29^0.5))^2)),5)","v":10},15,25,45,65,90,130,180,240,"K=S2/200(h11/2+h21/2)2 AGRD Part 3 :Eq 18"]
["MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L)  #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,12,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,12,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h11/2+h21/2)2 AGRD Part 3 :Eq 18",null,null,null,null,null,120,130,1230,1290,1200,1310,0.24,140,"Pa",0,0,null,"MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L) #",{"$f":"_xlfn.CEILING.MATH((W42^2)/(200*((($Z$29^0.5)+($AB$29^0.5))^2)),5)","v":5},{"$f":"_xlfn.CEILING.MATH((X42^2)/(200*((($Z$29^0.5)+($AB$29^0.5))^2)),5)","v":10},15,25,35,55,75,105,145,195,"K=S2/200(h11/2+h21/2)2 AGRD Part 3 :Eq 18"]
["MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L) #",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,13,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h11/2+h21/2)2 AGRD Part 3 :Eq 18",null,null,null,null,null,130,140,1230,1290,1200,1310,"AGRD PART 3 : Table 5.4",null,"AGRD PART 3 : Table 7.13",null,null,null,"MIN SAG  VERTICAL CURVE K VALUE FOR CAR",{"$f":"_xlfn.CEILING.MATH((W41^2)/((200)*(0.65+(W41*0.01746))),5)","v":10},{"$f":"_xlfn.CEILING.MATH((X41^2)/((200)*(0.65+(X41*0.01746))),5)","v":10},15,25,35,40,50,60,75,85,"K=S2/200(h+Stanq) C4  (Headlight Criteria) "]
["MIN SAG  VERTICAL CURVE K VALUE FOR CAR",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,14,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,14,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h+Stanq) C4  (Headlight Criteria) ",null,null,null,{"$f":"IF(OR(RIGHT('Entry Form'!B3,1)=\"1\",RIGHT('Entry Form'!B3,1)=\"5\"),IF(OR('Entry Form'!B9=\"Unsealed\"),B48,\"\"),B49)","v":{"$error":"#N/A"}},"Col:B (Not Used)","col ref",1,2,3,4,5,null,null,null,null,null,null,"MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK",{"$f":"_xlfn.CEILING.MATH((W42^2)/((200)*(0.65+(W42*0.01746))),5)","v":10},{"$f":"_xlfn.CEILING.MATH((X42^2)/((200)*(0.65+(X42*0.01746))),5)","v":15},25,30,40,50,60,75,90,105,"K=S2/200(h+Stanq) C4  (Headlight Criteria) "]
["MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,15,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,15,FALSE)","v":{"$error":"#N/A"}},"K=S2/200(h+Stanq) C4  (Headlight Criteria) ",null,null,null,{"$f":"IF(OR(RIGHT('Entry Form'!E3,1)=\"1\",RIGHT('Entry Form'!E3,1)=\"5\"),IF(OR('Entry Form'!E9=\"Unsealed\"),C48,\"\"),C49)","v":{"$error":"#N/A"}},"Col:E (Not Used)",null,null,null,null,null,null,null,null,null,null,null,null,"Deceleration Lane Including taper to stop Condition (Formaula based)",{"$f":"_xlfn.CEILING.MATH((W34^2)/(254*$AD$28),5)","v":40},{"$f":"_xlfn.CEILING.MATH((X34^2)/(254*$AD$28),5)","v":60},80,100,130,155,190,225,265,305,"D=V2/254d Equation  6 , Table 5.2\nAGRD part 4A   V= Design Speed"]
["Deceleration Lane Including taper to stop Condition (Formaula based) ©©",{"$f":"HLOOKUP($B$35,$W$34:$AF$49,16,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($C$35,$W$34:$AF$49,16,FALSE)","v":{"$error":"#N/A"}},"D=V2/254d Equation  6 , Table 5.2\nAGRD part 4A   V= Design Speed",null,null,null,null,null,null,null,"AGRD PART 3 : Table 5.9"]
[null,null,null,null,null,null,null,null,null,null,"ESD  values are applicable for sealed  undivided 2way carriageway."]
[null,null,null,null,null,null,null,null,null,null,"ESD is dependent on vehicle classification as well"]

{"sheet":"Entry Form","index":7,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["BASIS OF DESIGN","ROAD 1",null,null,"ROAD 2"]
["PROJECT CRITERIA","\nPROJECT SPECIFIC VALUES","GUIDELINE DESIGN VALUES","COMMENT ON PROJECT \nVALUES NOT MEETING \nDESIGN CRITERIA","\nPROJECT SPECIFIC VALUES","GUIDELINE DESIGN VALUES","COMMENT ON PROJECT \nVALUES NOT MEETING \nDESIGN CRITERIA"]
["ROAD CLASS - AUSTROADS CLASS","Choose an item",null,null,"Choose an item",null,null,null,1]
["DESIGN VEHICLE","Choose an item",null,null,"Choose an item"]
["DESIGN SPEED (km/h)","Choose an item",null,null,"Choose an item"]
["POSTED SPEED (km/h)",{"$f":"IF(B5<>\"Choose an item\",B5-10,\"\")","v":""},null,null,{"$f":"IF(E5<>\"Choose an item\",E5-10,\"\")","v":""}]
["REACTION TIME",{"$f":"VLOOKUP(B3,'Drop lists'!A1:C14,3,FALSE)","v":0},null,null,{"$f":"VLOOKUP(E3,'Drop lists'!A1:C14,3,FALSE)","v":0}]
["CARRIAGEWAY TYPE","Choose an item",null,null,"Choose an item"]
["SURFACE  TYPE","Choose an item",null,null,"Choose an item"]
["MAX SUPERELEVATION (%)",{"$f":"IF(B9<>\"Choose an item\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),3,4),\"\")","v":""},null,null,{"$f":"IF(E9<>\"Choose an item\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),3,4),\"\")","v":""}]
["GEOMETRY"]
["MIN HORIZONTAL CURVE RADIUS  FOR CAR(m)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B11,Calculation!B37))","v":""},{"$f":"IF(B12<>\"\",IF(B12>=C12,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C11,Calculation!C37))","v":""},{"$f":"IF(E12<>\"\",IF(E12>=F12,\"N/A\",\"Provide Explanation\"),\"\")","v":""}]
["MIN HORIZONTAL CURVE RADIUS  FOR TRUCK(m)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B12,Calculation!B38))","v":""},{"$f":"IF(B13<>\"\",IF(B13>=C13,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C12,Calculation!C38))","v":""},{"$f":"IF(E13<>\"\",IF(E13>=F13,\"N/A\",\"Provide Explanation\"),\"\")","v":""}]
["CURVE LANE WIDENEING","Choose an item",{"$f":"IF(B4<>\"Choose an item\",IF(AND(C13>=Calculation!S33,C13<=Calculation!T33),\"Curve lane widening required\",\"Curve lane widening not required\"),\"\")","v":""},"-","Choose an item",{"$f":"IF(E4<>\"Choose an item\",IF(AND(F13>=Calculation!S32,F13<=Calculation!T32),\"Curve lane widening required \",\"Curve lane widening not required\"),\"\")","v":""},"-"]
["MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m)",null,{"$f":"IF(B4<>\"Choose an item\",IF(AND(B8= \"Undivided two way\",OR(B9=\"Sealed\",B9=\"Asphalt\")),Calculation!B13,\"N/A\"),\"\")","v":""},{"$f":"IF(B15<>\"\",IF(C15=\"N/A\",C15,IF(B15>=C15,\"N/A\",\"Provide Explanation\")),\"\")","v":""},null,{"$f":"IF(E4<>\"Choose an item\",IF(AND(E8= \"Undivided two way\",OR(E9=\"Sealed\",E9=\"Asphalt\")),Calculation!C13,\"N/A\"),\"\")","v":""},{"$f":"IF(E15<>\"\",IF(F15=\"N/A\",F15,IF(E15>=F15,\"N/A\",\"Provide Explanation\")),\"\")","v":""}]
["MIN OVERTAKING LENGTH  (m)",null,{"$f":"IF(B5<>\"Choose an item\",IF(AND(OR(B9=\"Asphalt\",B9=\"Sealed\"),B8=\"Undivided two way\"),Calculation!B14,\"N/A\"),\"\")","v":""},{"$f":"IF(B16<>\"\",IF(C16=\"N/A\",C16,IF(B16>=C16,\"N/A\",\"Provide Explanation\")),\"\")","v":""},null,{"$f":"IF(E5<>\"Choose an item\",IF(AND(OR(E9=\"Asphalt\",E9=\"Sealed\"),E8=\"Undivided two way\"),Calculation!C14,\"N/A\"),\"\")","v":""},{"$f":"IF(E16<>\"\",IF(F16=\"N/A\",F16,IF(E16>=F16,\"N/A\",\"Provide Explanation\")),\"\")","v":""}]
["MIN LENGTH OF BARRIER LINES (m)",null,{"$f":"IF(B5<>\"Choose an item\",IF(AND(OR(B9=\"Asphalt\",B9=\"Sealed\"),B8=\"Undivided two way\"),Calculation!B15,\"N/A\"),\"\")","v":""},{"$f":"IF(B17<>\"\",IF(C17=\"N/A\",C17,IF(B17>=C17,\"N/A\",\"Provide Explanation\")),\"\")","v":""},null,{"$f":"IF(E5<>\"Choose an item\",IF(AND(OR(E9=\"Asphalt\",E9=\"Sealed\"),E8=\"Undivided two way\"),Calculation!C15,\"N/A\"),\"\")","v":""},{"$f":"IF(E17<>\"\",IF(F17=\"N/A\",F17,IF(E17>=F17,\"N/A\",\"Provide Explanation\")),\"\")","v":""}]
["MIN CAR STOPPING SIGHT DISTANCE (m)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B16,Calculation!B42))","v":""},{"$f":"IF(B18<>\"\",IF(B18>=C18,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C16,Calculation!C42))","v":""},{"$f":"IF(E18<>\"\",IF(F18=\"N/A\",F18,IF(E18>=F18,\"N/A\",\"Provide Explanation\")),\"\")","v":""}]
["MIN TRUCK STOPPING SIGHT DISTANCE (m)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B17,Calculation!B43))","v":""},{"$f":"IF(B19<>\"\",IF(B19>=C19,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C17,Calculation!C43))","v":""},""]
["MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B18,Calculation!B44))","v":""},{"$f":"IF(B20<>\"\",IF(B20>=C20,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C18,Calculation!C44))","v":""},""]
["MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B19,Calculation!B45))","v":""},{"$f":"IF(B21<>\"\",IF(B21>=C21,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C19,Calculation!C45))","v":""},""]
["MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B20,Calculation!B46))","v":""},{"$f":"IF(B22<>\"\",IF(C22<=B22,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C20,Calculation!C46))","v":""},""]
["MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B21,Calculation!B47))","v":""},{"$f":"IF(B23<>\"\",IF(C23<=B23,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C21,Calculation!C47))","v":""},""]
["MIN SAG  VERTICAL CURVE K VALUE FOR CAR (S<L)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B22,Calculation!B48))","v":""},{"$f":"IF(B24<>\"\",IF(C24<=B24,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C22,Calculation!C48))","v":""},""]
["MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK (S<L)",null,{"$f":"IF(OR(B9=\"Choose an item\",B6=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B23,Calculation!B49))","v":""},{"$f":"IF(B25<>\"\",IF(C25<=B25,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E6=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C23,Calculation!C49))","v":""},""]
["DECELERATION LANE INCLUDING TAPER TO STOP CONDITION",null,{"$f":"IF(OR(B9=\"Choose an item\",B5=\"Choose an item\"),\"\",IF(OR(B9=\"Sealed\",B9=\"Asphalt\"),Calculation!B24,Calculation!B50))","v":""},{"$f":"IF(B26<>\"\",IF(C26<=B26,\"N/A\",\"Provide Explanation\"),\"\")","v":""},null,{"$f":"IF(OR(E9=\"Choose an item\",E5=\"Choose an item\"),\"\",IF(OR(E9=\"Sealed\",E9=\"Asphalt\"),Calculation!C24,Calculation!C50))","v":""},""]
["HAZARD TREATMENT","Choose an item","DROP DOWN LIST",null,"Choose an item"]
["NUMBER OF TRAFFIC ACCIDENTS (IN THE LAST 10 YEARS)",null,"FIXED FORMULAS"]
["GUIDE AND STANDARD USED","Choose an item","DATA INPUT",null,"Choose an item"]
[""]
["ROAD SAFETY AUDIT"]
["ROAD SAFETY AUDIT UNDERTAKEN","Choose an item",null,null,"Choose an item"]
[""]
["PAVEMENT"]
["TRAFFIC VOLUME (AADT / YEAR)"]
["GROWTH RATE (%)","Choose an item",null,null,"Choose an item"]
["PERCENT HEAVY VEHICLES (%)","Choose an item",null,null,"Choose an item"]
["DESIGN TRAFFIC IN ESA'S (X 10^6)"]
["PAVEMENT DESIGN LIFE (YEARS)","Choose an item",null,null,"Choose an item"]
["DESIGN CBR VALUES"]
["FROM CH. TO CH."]
["DESIGN METHOD USED","Choose an item",null,null,"Choose an item"]
["GUIDE AND STANDARD USED","Choose an item",null,null,"Choose an item"]
[""]
["ROAD SAFETY BARRIERS"]
["ROAD SAFETY BARRIERS USED","Choose an item",null,null,"Choose an item"]
["APPROACH TERMINALS USED","Choose an item",null,null,"Choose an item"]
["END TERMINALS USED","Choose an item",null,null,"Choose an item"]
[""]
["DRAINAGE"]
["MAJOR SYSTEM CAPACITY (URBAN)","Choose an item",null,null,"Choose an item"]
["MINOR SYSTEM CAPACITY  (URBAN)","Choose an item",null,null,"Choose an item"]
["CULVERT DESIGN ","Choose an item",null,null,"Choose an item"]
["FLOODWAY DESIGN ","Choose an item",null,null,"Choose an item"]
["BRIDGE DESIGN","Choose an item",null,null,"Choose an item"]
["AATOC"]
["PROTECTED AT X% AEP","Choose an item",null,null,"Choose an item"]
["GUIDE AND STANDARD USED","Choose an item",null,null,"Choose an item"]
[""]
["SURVEY"]
["SURVEY BY"]
["DATE OF SURVEY"]
["GEODETIC DATUM","Choose an item",null,null,"Choose an item",null,"`"]
["LEVEL DATUM","Choose an item",null,null,"Choose an item"]
[""]
["LIGHTING"]
["ROADWAY LIGHTING LEVEL","Choose an item",{"$f":"VLOOKUP(B3,'Drop lists'!A2:B14,2,FALSE)","v":" "},{"$f":"IF(B3<>\"Choose an item\",IF(OR(B67=\"N/A\",B67=C67),\"N/A\",\"Provide Explanation\"),\"\")","v":""},"Choose an item",{"$f":"VLOOKUP(E3,'Drop lists'!A2:B14,2,FALSE)","v":" "},{"$f":"IF(E3<>\"Choose an item\",IF(OR(E67=\"N/A\",E67=F67),\"N/A\",\"Provide Explanation \"),\"\")","v":""}]
["INTERSECTION LIGHTING LEVEL","Choose an item",{"$f":"VLOOKUP(B3,'Drop lists'!A2:B14,2,FALSE)","v":" "},{"$f":"IF(B3<>\"Choose an item\",IF(OR(B68=\"N/A\",B68=C68),\"N/A\",\"Provide Explanation\"),\"\")","v":""},"Choose an item",{"$f":"VLOOKUP(E3,'Drop lists'!A2:B14,2,FALSE)","v":" "},{"$f":"IF(E3<>\"Choose an item\",IF(OR(E68=\"N/A\",E68=F68),\"N/A\",\"Provide Explanation\"),\"\")","v":""}]
[""]
["SIDE TRACK FOR DETOURS"]
["SIDE TRACK STANDARD","Choose an item",{"$f":"IF(B71=\"Choose an item\",\"\",\"As per Road Specifications 'Provisions for Traffic'\")","v":""},null,"Choose an item",{"$f":"IF(E71=\"Choose an item\",\"\",\"As per Road Specifications 'Provisions for Traffic'\")","v":""}]

{"sheet":"ROAD 1","index":8,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,0,71,3],[0,1,0,3],[10,0,10,3],[30,0,30,3],[33,0,33,3],[69,40,69,43],[69,44,69,47],[69,48,69,51],[69,52,69,55],[69,56,69,59],[69,20,69,23],[69,24,69,27],[69,28,69,31],[69,32,69,35],[69,36,69,39],[69,0,69,3],[69,4,69,7],[69,8,69,11],[69,12,69,15],[69,16,69,19],[44,0,44,3],[49,0,49,3],[59,0,59,3],[65,0,65,3],[28,1,28,3],[42,1,42,3],[57,1,57,3],[26,1,26,3],[27,2,27,3],[48,0,48,3],[29,0,29,3],[32,0,32,3],[43,0,43,3],[69,120,69,123],[69,124,69,127],[69,128,69,131],[69,132,69,135],[69,136,69,139],[69,100,69,103],[69,104,69,107],[69,108,69,111],[69,112,69,115],[69,116,69,119],[69,80,69,83],[69,84,69,87],[69,88,69,91],[69,92,69,95],[69,96,69,99],[69,60,69,63],[69,64,69,67],[69,68,69,71],[69,72,69,75],[69,76,69,79],[58,0,58,3],[64,0,64,3],[68,0,68,3],[69,200,69,203],[69,204,69,207],[69,208,69,211],[69,212,69,215],[69,216,69,219],[69,180,69,183],[69,184,69,187],[69,188,69,191],[69,192,69,195],[69,196,69,199],[69,160,69,163],[69,164,69,167],[69,168,69,171],[69,172,69,175],[69,176,69,179],[69,140,69,143],[69,144,69,147],[69,148,69,151],[69,152,69,155],[69,156,69,159],[69,280,69,283],[69,284,69,287],[69,288,69,291],[69,292,69,295],[69,296,69,299],[69,260,69,263],[69,264,69,267],[69,268,69,271],[69,272,69,275],[69,276,69,279],[69,240,69,243],[69,244,69,247],[69,248,69,251],[69,252,69,255],[69,256,69,259],[69,220,69,223],[69,224,69,227],[69,228,69,231],[69,232,69,235],[69,236,69,239],[69,360,69,363],[69,364,69,367],[69,368,69,371],[69,372,69,375],[69,376,69,379],[69,340,69,343],[69,344,69,347],[69,348,69,351],[69,352,69,355],[69,356,69,359],[69,320,69,323],[69,324,69,327],[69,328,69,331],[69,332,69,335],[69,336,69,339],[69,300,69,303],[69,304,69,307],[69,308,69,311],[69,312,69,315],[69,316,69,319],[69,440,69,443],[69,444,69,447],[69,448,69,451],[69,452,69,455],[69,456,69,459],[69,420,69,423],[69,424,69,427],[69,428,69,431],[69,432,69,435],[69,436,69,439],[69,400,69,403],[69,404,69,407],[69,408,69,411],[69,412,69,415],[69,416,69,419],[69,380,69,383],[69,384,69,387],[69,388,69,391],[69,392,69,395],[69,396,69,399],[69,520,69,523],[69,524,69,527],[69,528,69,531],[69,532,69,535],[69,536,69,539],[69,500,69,503],[69,504,69,507],[69,508,69,511],[69,512,69,515],[69,516,69,519],[69,480,69,483],[69,484,69,487],[69,488,69,491],[69,492,69,495],[69,496,69,499],[69,460,69,463],[69,464,69,467],[69,468,69,471],[69,472,69,475],[69,476,69,479],[69,600,69,603],[69,604,69,607],[69,608,69,611],[69,612,69,615],[69,616,69,619],[69,580,69,583],[69,584,69,587],[69,588,69,591],[69,592,69,595],[69,596,69,599],[69,560,69,563],[69,564,69,567],[69,568,69,571],[69,572,69,575],[69,576,69,579],[69,540,69,543],[69,544,69,547],[69,548,69,551],[69,552,69,555],[69,556,69,559],[69,680,69,683],[69,684,69,687],[69,688,69,691],[69,692,69,695],[69,696,69,699],[69,660,69,663],[69,664,69,667],[69,668,69,671],[69,672,69,675],[69,676,69,679],[69,640,69,643],[69,644,69,647],[69,648,69,651],[69,652,69,655],[69,656,69,659],[69,620,69,623],[69,624,69,627],[69,628,69,631],[69,632,69,635],[69,636,69,639],[69,760,69,763],[69,764,69,767],[69,768,69,771],[69,772,69,775],[69,776,69,779],[69,740,69,743],[69,744,69,747],[69,748,69,751],[69,752,69,755],[69,756,69,759],[69,720,69,723],[69,724,69,727],[69,728,69,731],[69,732,69,735],[69,736,69,739],[69,700,69,703],[69,704,69,707],[69,708,69,711],[69,712,69,715],[69,716,69,719],[69,840,69,843],[69,844,69,847],[69,848,69,851],[69,852,69,855],[69,856,69,859],[69,820,69,823],[69,824,69,827],[69,828,69,831],[69,832,69,835],[69,836,69,839],[69,800,69,803],[69,804,69,807],[69,808,69,811],[69,812,69,815],[69,816,69,819],[69,780,69,783],[69,784,69,787],[69,788,69,791],[69,792,69,795],[69,796,69,799],[69,920,69,923],[69,924,69,927],[69,928,69,931],[69,932,69,935],[69,936,69,939],[69,900,69,903],[69,904,69,907],[69,908,69,911],[69,912,69,915],[69,916,69,919],[69,880,69,883],[69,884,69,887],[69,888,69,891],[69,892,69,895],[69,896,69,899],[69,860,69,863],[69,864,69,867],[69,868,69,871],[69,872,69,875],[69,876,69,879],[69,1000,69,1003],[69,1004,69,1007],[69,1008,69,1011],[69,1012,69,1015],[69,1016,69,1019],[69,980,69,983],[69,984,69,987],[69,988,69,991],[69,992,69,995],[69,996,69,999],[69,960,69,963],[69,964,69,967],[69,968,69,971],[69,972,69,975],[69,976,69,979],[69,940,69,943],[69,944,69,947],[69,948,69,951],[69,952,69,955],[69,956,69,959],[69,1080,69,1083],[69,1084,69,1087],[69,1088,69,1091],[69,1092,69,1095],[69,1096,69,1099],[69,1060,69,1063],[69,1064,69,1067],[69,1068,69,1071],[69,1072,69,1075],[69,1076,69,1079],[69,1040,69,1043],[69,1044,69,1047],[69,1048,69,1051],[69,1052,69,1055],[69,1056,69,1059],[69,1020,69,1023],[69,1024,69,1027],[69,1028,69,1031],[69,1032,69,1035],[69,1036,69,1039],[69,1160,69,1163],[69,1164,69,1167],[69,1168,69,1171],[69,1172,69,1175],[69,1176,69,1179],[69,1140,69,1143],[69,1144,69,1147],[69,1148,69,1151],[69,1152,69,1155],[69,1156,69,1159],[69,1120,69,1123],[69,1124,69,1127],[69,1128,69,1131],[69,1132,69,1135],[69,1136,69,1139],[69,1100,69,1103],[69,1104,69,1107],[69,1108,69,1111],[69,1112,69,1115],[69,1116,69,1119],[69,1240,69,1243],[69,1244,69,1247],[69,1248,69,1251],[69,1252,69,1255],[69,1256,69,1259],[69,1220,69,1223],[69,1224,69,1227],[69,1228,69,1231],[69,1232,69,1235],[69,1236,69,1239],[69,1200,69,1203],[69,1204,69,1207],[69,1208,69,1211],[69,1212,69,1215],[69,1216,69,1219],[69,1180,69,1183],[69,1184,69,1187],[69,1188,69,1191],[69,1192,69,1195],[69,1196,69,1199],[69,1320,69,1323],[69,1324,69,1327],[69,1328,69,1331],[69,1332,69,1335],[69,1336,69,1339],[69,1300,69,1303],[69,1304,69,1307],[69,1308,69,1311],[69,1312,69,1315],[69,1316,69,1319],[69,1280,69,1283],[69,1284,69,1287],[69,1288,69,1291],[69,1292,69,1295],[69,1296,69,1299],[69,1260,69,1263],[69,1264,69,1267],[69,1268,69,1271],[69,1272,69,1275],[69,1276,69,1279],[69,1400,69,1403],[69,1404,69,1407],[69,1408,69,1411],[69,1412,69,1415],[69,1416,69,1419],[69,1380,69,1383],[69,1384,69,1387],[69,1388,69,1391],[69,1392,69,1395],[69,1396,69,1399],[69,1360,69,1363],[69,1364,69,1367],[69,1368,69,1371],[69,1372,69,1375],[69,1376,69,1379],[69,1340,69,1343],[69,1344,69,1347],[69,1348,69,1351],[69,1352,69,1355],[69,1356,69,1359],[69,1480,69,1483],[69,1484,69,1487],[69,1488,69,1491],[69,1492,69,1495],[69,1496,69,1499],[69,1460,69,1463],[69,1464,69,1467],[69,1468,69,1471],[69,1472,69,1475],[69,1476,69,1479],[69,1440,69,1443],[69,1444,69,1447],[69,1448,69,1451],[69,1452,69,1455],[69,1456,69,1459],[69,1420,69,1423],[69,1424,69,1427],[69,1428,69,1431],[69,1432,69,1435],[69,1436,69,1439],[69,1560,69,1563],[69,1564,69,1567],[69,1568,69,1571],[69,1572,69,1575],[69,1576,69,1579],[69,1540,69,1543],[69,1544,69,1547],[69,1548,69,1551],[69,1552,69,1555],[69,1556,69,1559],[69,1520,69,1523],[69,1524,69,1527],[69,1528,69,1531],[69,1532,69,1535],[69,1536,69,1539],[69,1500,69,1503],[69,1504,69,1507],[69,1508,69,1511],[69,1512,69,1515],[69,1516,69,1519],[69,1640,69,1643],[69,1644,69,1647],[69,1648,69,1651],[69,1652,69,1655],[69,1656,69,1659],[69,1620,69,1623],[69,1624,69,1627],[69,1628,69,1631],[69,1632,69,1635],[69,1636,69,1639],[69,1600,69,1603],[69,1604,69,1607],[69,1608,69,1611],[69,1612,69,1615],[69,1616,69,1619],[69,1580,69,1583],[69,1584,69,1587],[69,1588,69,1591],[69,1592,69,1595],[69,1596,69,1599],[69,1720,69,1723],[69,1724,69,1727],[69,1728,69,1731],[69,1732,69,1735],[69,1736,69,1739],[69,1700,69,1703],[69,1704,69,1707],[69,1708,69,1711],[69,1712,69,1715],[69,1716,69,1719],[69,1680,69,1683],[69,1684,69,1687],[69,1688,69,1691],[69,1692,69,1695],[69,1696,69,1699],[69,1660,69,1663],[69,1664,69,1667],[69,1668,69,1671],[69,1672,69,1675],[69,1676,69,1679],[69,1800,69,1803],[69,1804,69,1807],[69,1808,69,1811],[69,1812,69,1815],[69,1816,69,1819],[69,1780,69,1783],[69,1784,69,1787],[69,1788,69,1791],[69,1792,69,1795],[69,1796,69,1799],[69,1760,69,1763],[69,1764,69,1767],[69,1768,69,1771],[69,1772,69,1775],[69,1776,69,1779],[69,1740,69,1743],[69,1744,69,1747],[69,1748,69,1751],[69,1752,69,1755],[69,1756,69,1759],[69,1880,69,1883],[69,1884,69,1887],[69,1888,69,1891],[69,1892,69,1895],[69,1896,69,1899],[69,1860,69,1863],[69,1864,69,1867],[69,1868,69,1871],[69,1872,69,1875],[69,1876,69,1879],[69,1840,69,1843],[69,1844,69,1847],[69,1848,69,1851],[69,1852,69,1855],[69,1856,69,1859],[69,1820,69,1823],[69,1824,69,1827],[69,1828,69,1831],[69,1832,69,1835],[69,1836,69,1839],[69,1960,69,1963],[69,1964,69,1967],[69,1968,69,1971],[69,1972,69,1975],[69,1976,69,1979],[69,1940,69,1943],[69,1944,69,1947],[69,1948,69,1951],[69,1952,69,1955],[69,1956,69,1959],[69,1920,69,1923],[69,1924,69,1927],[69,1928,69,1931],[69,1932,69,1935],[69,1936,69,1939],[69,1900,69,1903],[69,1904,69,1907],[69,1908,69,1911],[69,1912,69,1915],[69,1916,69,1919],[69,2040,69,2043],[69,2044,69,2047],[69,2048,69,2051],[69,2052,69,2055],[69,2056,69,2059],[69,2020,69,2023],[69,2024,69,2027],[69,2028,69,2031],[69,2032,69,2035],[69,2036,69,2039],[69,2000,69,2003],[69,2004,69,2007],[69,2008,69,2011],[69,2012,69,2015],[69,2016,69,2019],[69,1980,69,1983],[69,1984,69,1987],[69,1988,69,1991],[69,1992,69,1995],[69,1996,69,1999],[69,2120,69,2123],[69,2124,69,2127],[69,2128,69,2131],[69,2132,69,2135],[69,2136,69,2139],[69,2100,69,2103],[69,2104,69,2107],[69,2108,69,2111],[69,2112,69,2115],[69,2116,69,2119],[69,2080,69,2083],[69,2084,69,2087],[69,2088,69,2091],[69,2092,69,2095],[69,2096,69,2099],[69,2060,69,2063],[69,2064,69,2067],[69,2068,69,2071],[69,2072,69,2075],[69,2076,69,2079],[69,2200,69,2203],[69,2204,69,2207],[69,2208,69,2211],[69,2212,69,2215],[69,2216,69,2219],[69,2180,69,2183],[69,2184,69,2187],[69,2188,69,2191],[69,2192,69,2195],[69,2196,69,2199],[69,2160,69,2163],[69,2164,69,2167],[69,2168,69,2171],[69,2172,69,2175],[69,2176,69,2179],[69,2140,69,2143],[69,2144,69,2147],[69,2148,69,2151],[69,2152,69,2155],[69,2156,69,2159],[69,2280,69,2283],[69,2284,69,2287],[69,2288,69,2291],[69,2292,69,2295],[69,2296,69,2299],[69,2260,69,2263],[69,2264,69,2267],[69,2268,69,2271],[69,2272,69,2275],[69,2276,69,2279],[69,2240,69,2243],[69,2244,69,2247],[69,2248,69,2251],[69,2252,69,2255],[69,2256,69,2259],[69,2220,69,2223],[69,2224,69,2227],[69,2228,69,2231],[69,2232,69,2235],[69,2236,69,2239],[69,2360,69,2363],[69,2364,69,2367],[69,2368,69,2371],[69,2372,69,2375],[69,2376,69,2379],[69,2340,69,2343],[69,2344,69,2347],[69,2348,69,2351],[69,2352,69,2355],[69,2356,69,2359],[69,2320,69,2323],[69,2324,69,2327],[69,2328,69,2331],[69,2332,69,2335],[69,2336,69,2339],[69,2300,69,2303],[69,2304,69,2307],[69,2308,69,2311],[69,2312,69,2315],[69,2316,69,2319],[69,2440,69,2443],[69,2444,69,2447],[69,2448,69,2451],[69,2452,69,2455],[69,2456,69,2459],[69,2420,69,2423],[69,2424,69,2427],[69,2428,69,2431],[69,2432,69,2435],[69,2436,69,2439],[69,2400,69,2403],[69,2404,69,2407],[69,2408,69,2411],[69,2412,69,2415],[69,2416,69,2419],[69,2380,69,2383],[69,2384,69,2387],[69,2388,69,2391],[69,2392,69,2395],[69,2396,69,2399],[69,2520,69,2523],[69,2524,69,2527],[69,2528,69,2531],[69,2532,69,2535],[69,2536,69,2539],[69,2500,69,2503],[69,2504,69,2507],[69,2508,69,2511],[69,2512,69,2515],[69,2516,69,2519],[69,2480,69,2483],[69,2484,69,2487],[69,2488,69,2491],[69,2492,69,2495],[69,2496,69,2499],[69,2460,69,2463],[69,2464,69,2467],[69,2468,69,2471],[69,2472,69,2475],[69,2476,69,2479],[69,2600,69,2603],[69,2604,69,2607],[69,2608,69,2611],[69,2612,69,2615],[69,2616,69,2619],[69,2580,69,2583],[69,2584,69,2587],[69,2588,69,2591],[69,2592,69,2595],[69,2596,69,2599],[69,2560,69,2563],[69,2564,69,2567],[69,2568,69,2571],[69,2572,69,2575],[69,2576,69,2579],[69,2540,69,2543],[69,2544,69,2547],[69,2548,69,2551],[69,2552,69,2555],[69,2556,69,2559],[69,2680,69,2683],[69,2684,69,2687],[69,2688,69,2691],[69,2692,69,2695],[69,2696,69,2699],[69,2660,69,2663],[69,2664,69,2667],[69,2668,69,2671],[69,2672,69,2675],[69,2676,69,2679],[69,2640,69,2643],[69,2644,69,2647],[69,2648,69,2651],[69,2652,69,2655],[69,2656,69,2659],[69,2620,69,2623],[69,2624,69,2627],[69,2628,69,2631],[69,2632,69,2635],[69,2636,69,2639],[69,2760,69,2763],[69,2764,69,2767],[69,2768,69,2771],[69,2772,69,2775],[69,2776,69,2779],[69,2740,69,2743],[69,2744,69,2747],[69,2748,69,2751],[69,2752,69,2755],[69,2756,69,2759],[69,2720,69,2723],[69,2724,69,2727],[69,2728,69,2731],[69,2732,69,2735],[69,2736,69,2739],[69,2700,69,2703],[69,2704,69,2707],[69,2708,69,2711],[69,2712,69,2715],[69,2716,69,2719],[69,2840,69,2843],[69,2844,69,2847],[69,2848,69,2851],[69,2852,69,2855],[69,2856,69,2859],[69,2820,69,2823],[69,2824,69,2827],[69,2828,69,2831],[69,2832,69,2835],[69,2836,69,2839],[69,2800,69,2803],[69,2804,69,2807],[69,2808,69,2811],[69,2812,69,2815],[69,2816,69,2819],[69,2780,69,2783],[69,2784,69,2787],[69,2788,69,2791],[69,2792,69,2795],[69,2796,69,2799],[69,2920,69,2923],[69,2924,69,2927],[69,2928,69,2931],[69,2932,69,2935],[69,2936,69,2939],[69,2900,69,2903],[69,2904,69,2907],[69,2908,69,2911],[69,2912,69,2915],[69,2916,69,2919],[69,2880,69,2883],[69,2884,69,2887],[69,2888,69,2891],[69,2892,69,2895],[69,2896,69,2899],[69,2860,69,2863],[69,2864,69,2867],[69,2868,69,2871],[69,2872,69,2875],[69,2876,69,2879],[69,3000,69,3003],[69,3004,69,3007],[69,3008,69,3011],[69,3012,69,3015],[69,3016,69,3019],[69,2980,69,2983],[69,2984,69,2987],[69,2988,69,2991],[69,2992,69,2995],[69,2996,69,2999],[69,2960,69,2963],[69,2964,69,2967],[69,2968,69,2971],[69,2972,69,2975],[69,2976,69,2979],[69,2940,69,2943],[69,2944,69,2947],[69,2948,69,2951],[69,2952,69,2955],[69,2956,69,2959],[69,3080,69,3083],[69,3084,69,3087],[69,3088,69,3091],[69,3092,69,3095],[69,3096,69,3099],[69,3060,69,3063],[69,3064,69,3067],[69,3068,69,3071],[69,3072,69,3075],[69,3076,69,3079],[69,3040,69,3043],[69,3044,69,3047],[69,3048,69,3051],[69,3052,69,3055],[69,3056,69,3059],[69,3020,69,3023],[69,3024,69,3027],[69,3028,69,3031],[69,3032,69,3035],[69,3036,69,3039],[69,3160,69,3163],[69,3164,69,3167],[69,3168,69,3171],[69,3172,69,3175],[69,3176,69,3179],[69,3140,69,3143],[69,3144,69,3147],[69,3148,69,3151],[69,3152,69,3155],[69,3156,69,3159],[69,3120,69,3123],[69,3124,69,3127],[69,3128,69,3131],[69,3132,69,3135],[69,3136,69,3139],[69,3100,69,3103],[69,3104,69,3107],[69,3108,69,3111],[69,3112,69,3115],[69,3116,69,3119],[69,3240,69,3243],[69,3244,69,3247],[69,3248,69,3251],[69,3252,69,3255],[69,3256,69,3259],[69,3220,69,3223],[69,3224,69,3227],[69,3228,69,3231],[69,3232,69,3235],[69,3236,69,3239],[69,3200,69,3203],[69,3204,69,3207],[69,3208,69,3211],[69,3212,69,3215],[69,3216,69,3219],[69,3180,69,3183],[69,3184,69,3187],[69,3188,69,3191],[69,3192,69,3195],[69,3196,69,3199],[69,3320,69,3323],[69,3324,69,3327],[69,3328,69,3331],[69,3332,69,3335],[69,3336,69,3339],[69,3300,69,3303],[69,3304,69,3307],[69,3308,69,3311],[69,3312,69,3315],[69,3316,69,3319],[69,3280,69,3283],[69,3284,69,3287],[69,3288,69,3291],[69,3292,69,3295],[69,3296,69,3299],[69,3260,69,3263],[69,3264,69,3267],[69,3268,69,3271],[69,3272,69,3275],[69,3276,69,3279],[69,3400,69,3403],[69,3404,69,3407],[69,3408,69,3411],[69,3412,69,3415],[69,3416,69,3419],[69,3380,69,3383],[69,3384,69,3387],[69,3388,69,3391],[69,3392,69,3395],[69,3396,69,3399],[69,3360,69,3363],[69,3364,69,3367],[69,3368,69,3371],[69,3372,69,3375],[69,3376,69,3379],[69,3340,69,3343],[69,3344,69,3347],[69,3348,69,3351],[69,3352,69,3355],[69,3356,69,3359],[69,3480,69,3483],[69,3484,69,3487],[69,3488,69,3491],[69,3492,69,3495],[69,3496,69,3499],[69,3460,69,3463],[69,3464,69,3467],[69,3468,69,3471],[69,3472,69,3475],[69,3476,69,3479],[69,3440,69,3443],[69,3444,69,3447],[69,3448,69,3451],[69,3452,69,3455],[69,3456,69,3459],[69,3420,69,3423],[69,3424,69,3427],[69,3428,69,3431],[69,3432,69,3435],[69,3436,69,3439],[69,3560,69,3563],[69,3564,69,3567],[69,3568,69,3571],[69,3572,69,3575],[69,3576,69,3579],[69,3540,69,3543],[69,3544,69,3547],[69,3548,69,3551],[69,3552,69,3555],[69,3556,69,3559],[69,3520,69,3523],[69,3524,69,3527],[69,3528,69,3531],[69,3532,69,3535],[69,3536,69,3539],[69,3500,69,3503],[69,3504,69,3507],[69,3508,69,3511],[69,3512,69,3515],[69,3516,69,3519],[69,3640,69,3643],[69,3644,69,3647],[69,3648,69,3651],[69,3652,69,3655],[69,3656,69,3659],[69,3620,69,3623],[69,3624,69,3627],[69,3628,69,3631],[69,3632,69,3635],[69,3636,69,3639],[69,3600,69,3603],[69,3604,69,3607],[69,3608,69,3611],[69,3612,69,3615],[69,3616,69,3619],[69,3580,69,3583],[69,3584,69,3587],[69,3588,69,3591],[69,3592,69,3595],[69,3596,69,3599],[69,3720,69,3723],[69,3724,69,3727],[69,3728,69,3731],[69,3732,69,3735],[69,3736,69,3739],[69,3700,69,3703],[69,3704,69,3707],[69,3708,69,3711],[69,3712,69,3715],[69,3716,69,3719],[69,3680,69,3683],[69,3684,69,3687],[69,3688,69,3691],[69,3692,69,3695],[69,3696,69,3699],[69,3660,69,3663],[69,3664,69,3667],[69,3668,69,3671],[69,3672,69,3675],[69,3676,69,3679],[69,3800,69,3803],[69,3804,69,3807],[69,3808,69,3811],[69,3812,69,3815],[69,3816,69,3819],[69,3780,69,3783],[69,3784,69,3787],[69,3788,69,3791],[69,3792,69,3795],[69,3796,69,3799],[69,3760,69,3763],[69,3764,69,3767],[69,3768,69,3771],[69,3772,69,3775],[69,3776,69,3779],[69,3740,69,3743],[69,3744,69,3747],[69,3748,69,3751],[69,3752,69,3755],[69,3756,69,3759],[69,3880,69,3883],[69,3884,69,3887],[69,3888,69,3891],[69,3892,69,3895],[69,3896,69,3899],[69,3860,69,3863],[69,3864,69,3867],[69,3868,69,3871],[69,3872,69,3875],[69,3876,69,3879],[69,3840,69,3843],[69,3844,69,3847],[69,3848,69,3851],[69,3852,69,3855],[69,3856,69,3859],[69,3820,69,3823],[69,3824,69,3827],[69,3828,69,3831],[69,3832,69,3835],[69,3836,69,3839],[69,3960,69,3963],[69,3964,69,3967],[69,3968,69,3971],[69,3972,69,3975]],"merged_total":4113,"flags":["merged_cut"]}
["BASIS OF DESIGN",{"$f":"'Entry Form'!B1","v":"ROAD 1"},null,null,null,null,"Font","ISOCPEUR"]
["PROJECT CRITERIA","PROJECT SPECIFIC VALUES","GUIDELINE DESIGN VALUES","COMMENT ON PROJECT VALUES ",null,null,"Heading text size","19.5 excel = 4.939 AutoCAD"]
[{"$f":"IF('Entry Form'!A3<>\"\",('Entry Form'!A3),\"\")","v":"ROAD CLASS - AUSTROADS CLASS"},{"$f":"IF('Entry Form'!B3<>\"\",'Entry Form'!B3,\"\")","v":"Choose an item"},null,null,null,null,"Data text size","14.5 excel = 3.528 AutoCAD"]
[{"$f":"IF('Entry Form'!A4<>\"\",('Entry Form'!A4),\"\")","v":"DESIGN VEHICLE"},{"$f":"IF('Entry Form'!B4<>\"\",'Entry Form'!B4,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A5<>\"\",('Entry Form'!A5),\"\")","v":"DESIGN SPEED (km/h)"},{"$f":"IF('Entry Form'!B5<>\"\",'Entry Form'!B5,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A6<>\"\",('Entry Form'!A6),\"\")","v":"POSTED SPEED (km/h)"},{"$f":"IF('Entry Form'!B6<>\"\",'Entry Form'!B6,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A7<>\"\",('Entry Form'!A7),\"\")","v":"REACTION TIME"},{"$f":"IF('Entry Form'!B7<>\"\",'Entry Form'!B7,\"\")","v":0}]
[{"$f":"IF('Entry Form'!A8<>\"\",('Entry Form'!A8),\"\")","v":"CARRIAGEWAY TYPE"},{"$f":"IF('Entry Form'!B8<>\"\",'Entry Form'!B8,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A9<>\"\",('Entry Form'!A9),\"\")","v":"SURFACE  TYPE"},{"$f":"IF('Entry Form'!B9<>\"\",'Entry Form'!B9,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A10<>\"\",('Entry Form'!A10),\"\")","v":"MAX SUPERELEVATION (%)"},{"$f":"IF('Entry Form'!B10<>\"\",'Entry Form'!B10,\"\")","v":""}]
["GEOMETRY",{"$f":"IF('Entry Form'!B11<>\"\",'Entry Form'!B11,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A12<>\"\",('Entry Form'!A12),\"\")","v":"MIN HORIZONTAL CURVE RADIUS  FOR CAR(m)"},{"$f":"IF('Entry Form'!B12<>\"\",'Entry Form'!B12,\"\")","v":""},{"$f":"'Entry Form'!C12","v":""},{"$f":"'Entry Form'!D12","v":""}]
[{"$f":"IF('Entry Form'!A13<>\"\",('Entry Form'!A13),\"\")","v":"MIN HORIZONTAL CURVE RADIUS  FOR TRUCK(m)"},{"$f":"IF('Entry Form'!B13<>\"\",'Entry Form'!B13,\"\")","v":""},{"$f":"'Entry Form'!C13","v":""},{"$f":"'Entry Form'!D13","v":""}]
[{"$f":"IF('Entry Form'!A14<>\"\",('Entry Form'!A14),\"\")","v":"CURVE LANE WIDENEING"},{"$f":"IF('Entry Form'!B14<>\"\",'Entry Form'!B14,\"\")","v":"Choose an item"},{"$f":"'Entry Form'!C14","v":""},{"$f":"'Entry Form'!D14","v":"-"}]
[{"$f":"IF('Entry Form'!A15<>\"\",('Entry Form'!A15),\"\")","v":"MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m)"},{"$f":"IF('Entry Form'!B15<>\"\",'Entry Form'!B15,\"\")","v":""},{"$f":"'Entry Form'!C15","v":""},{"$f":"'Entry Form'!D15","v":""}]
[{"$f":"IF('Entry Form'!A16<>\"\",('Entry Form'!A16),\"\")","v":"MIN OVERTAKING LENGTH  (m)"},{"$f":"IF('Entry Form'!B16<>\"\",'Entry Form'!B16,\"\")","v":""},{"$f":"'Entry Form'!C16","v":""},{"$f":"'Entry Form'!D16","v":""}]
[{"$f":"IF('Entry Form'!A17<>\"\",('Entry Form'!A17),\"\")","v":"MIN LENGTH OF BARRIER LINES (m)"},{"$f":"IF('Entry Form'!B17<>\"\",'Entry Form'!B17,\"\")","v":""},{"$f":"'Entry Form'!C17","v":""},{"$f":"'Entry Form'!D17","v":""}]
[{"$f":"IF('Entry Form'!A18<>\"\",('Entry Form'!A18),\"\")","v":"MIN CAR STOPPING SIGHT DISTANCE (m)"},{"$f":"IF('Entry Form'!B18<>\"\",'Entry Form'!B18,\"\")","v":""},{"$f":"'Entry Form'!C18","v":""},{"$f":"'Entry Form'!D18","v":""}]
[{"$f":"IF('Entry Form'!A19<>\"\",('Entry Form'!A19),\"\")","v":"MIN TRUCK STOPPING SIGHT DISTANCE (m)"},{"$f":"IF('Entry Form'!B19<>\"\",'Entry Form'!B19,\"\")","v":""},{"$f":"'Entry Form'!C19","v":""},{"$f":"'Entry Form'!D19","v":""}]
[{"$f":"IF('Entry Form'!A20<>\"\",('Entry Form'!A20),\"\")","v":"MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)"},{"$f":"IF('Entry Form'!B20<>\"\",'Entry Form'!B20,\"\")","v":""},{"$f":"'Entry Form'!C20","v":""},{"$f":"'Entry Form'!D20","v":""}]
[{"$f":"IF('Entry Form'!A21<>\"\",('Entry Form'!A21),\"\")","v":"MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m)"},{"$f":"IF('Entry Form'!B21<>\"\",'Entry Form'!B21,\"\")","v":""},{"$f":"'Entry Form'!C21","v":""},{"$f":"'Entry Form'!D21","v":""}]
[{"$f":"IF('Entry Form'!A22<>\"\",('Entry Form'!A22),\"\")","v":"MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L)"},{"$f":"IF('Entry Form'!B22<>\"\",'Entry Form'!B22,\"\")","v":""},{"$f":"'Entry Form'!C22","v":""},{"$f":"'Entry Form'!D22","v":""}]
[{"$f":"IF('Entry Form'!A23<>\"\",('Entry Form'!A23),\"\")","v":"MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L)"},{"$f":"IF('Entry Form'!B23<>\"\",'Entry Form'!B23,\"\")","v":""},{"$f":"'Entry Form'!C23","v":""},{"$f":"'Entry Form'!D23","v":""}]
[{"$f":"IF('Entry Form'!A24<>\"\",('Entry Form'!A24),\"\")","v":"MIN SAG  VERTICAL CURVE K VALUE FOR CAR (S<L)"},{"$f":"IF('Entry Form'!B24<>\"\",'Entry Form'!B24,\"\")","v":""},{"$f":"'Entry Form'!C24","v":""},{"$f":"'Entry Form'!D24","v":""}]
[{"$f":"IF('Entry Form'!A25<>\"\",('Entry Form'!A25),\"\")","v":"MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK (S<L)"},{"$f":"IF('Entry Form'!B25<>\"\",'Entry Form'!B25,\"\")","v":""},{"$f":"'Entry Form'!C25","v":""},{"$f":"'Entry Form'!D25","v":""}]
[{"$f":"IF('Entry Form'!A26<>\"\",('Entry Form'!A26),\"\")","v":"DECELERATION LANE INCLUDING TAPER TO STOP CONDITION"},{"$f":"IF('Entry Form'!B26<>\"\",'Entry Form'!B26,\"\")","v":""},{"$f":"'Entry Form'!C26","v":""},{"$f":"'Entry Form'!D26","v":""}]
[{"$f":"IF('Entry Form'!A27<>\"\",('Entry Form'!A27),\"\")","v":"HAZARD TREATMENT"},{"$f":"IF('Entry Form'!B27<>\"\",UPPER(LineTxt('Entry Form'!B27)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[{"$f":"IF('Entry Form'!A28<>\"\",('Entry Form'!A28),\"\")","v":"NUMBER OF TRAFFIC ACCIDENTS (IN THE LAST 10 YEARS)"},{"$f":"IF('Entry Form'!B28<>\"\",'Entry Form'!B28,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A29<>\"\",('Entry Form'!A29),\"\")","v":"GUIDE AND STANDARD USED"},{"$f":"IF('Entry Form'!B29<>\"\",UPPER(LineTxt('Entry Form'!B29)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[]
["ROAD SAFETY AUDIT",{"$f":"IF('Entry Form'!B31<>\"\",'Entry Form'!B31,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A32<>\"\",('Entry Form'!A32),\"\")","v":"ROAD SAFETY AUDIT UNDERTAKEN"},{"$f":"IF('Entry Form'!B32<>\"\",'Entry Form'!B32,\"\")","v":"Choose an item"}]
[null,{"$f":"IF('Entry Form'!B33<>\"\",'Entry Form'!B33,\"\")","v":""}]
["PAVEMENT",{"$f":"IF('Entry Form'!B34<>\"\",'Entry Form'!B34,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A35<>\"\",('Entry Form'!A35),\"\")","v":"TRAFFIC VOLUME (AADT / YEAR)"},{"$f":"IF('Entry Form'!B35<>\"\",'Entry Form'!B35,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A36<>\"\",('Entry Form'!A36),\"\")","v":"GROWTH RATE (%)"},{"$f":"IF('Entry Form'!B36<>\"\",'Entry Form'!B36,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A37<>\"\",('Entry Form'!A37),\"\")","v":"PERCENT HEAVY VEHICLES (%)"},{"$f":"IF('Entry Form'!B37<>\"\",'Entry Form'!B37,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A38<>\"\",('Entry Form'!A38),\"\")","v":"DESIGN TRAFFIC IN ESA'S (X 10^6)"},{"$f":"IF('Entry Form'!B38<>\"\",'Entry Form'!B38,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A39<>\"\",('Entry Form'!A39),\"\")","v":"PAVEMENT DESIGN LIFE (YEARS)"},{"$f":"IF('Entry Form'!B39<>\"\",'Entry Form'!B39,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A40<>\"\",('Entry Form'!A40),\"\")","v":"DESIGN CBR VALUES"},{"$f":"IF('Entry Form'!B40<>\"\",'Entry Form'!B40,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A41<>\"\",('Entry Form'!A41),\"\")","v":"FROM CH. TO CH."},{"$f":"IF('Entry Form'!B41<>\"\",'Entry Form'!B41,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A42<>\"\",('Entry Form'!A42),\"\")","v":"DESIGN METHOD USED"},{"$f":"IF('Entry Form'!B42<>\"\",'Entry Form'!B42,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A43<>\"\",('Entry Form'!A43),\"\")","v":"GUIDE AND STANDARD USED"},{"$f":"IF('Entry Form'!B43<>\"\",UPPER(LineTxt('Entry Form'!B43)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[null,{"$f":"IF('Entry Form'!B44<>\"\",'Entry Form'!B44,\"\")","v":""}]
["ROAD SAFETY BARRIERS",{"$f":"IF('Entry Form'!B45<>\"\",'Entry Form'!B45,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A46<>\"\",('Entry Form'!A46),\"\")","v":"ROAD SAFETY BARRIERS USED"},{"$f":"IF('Entry Form'!B46<>\"\",'Entry Form'!B46,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A47<>\"\",('Entry Form'!A47),\"\")","v":"APPROACH TERMINALS USED"},{"$f":"IF('Entry Form'!B47<>\"\",'Entry Form'!B47,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A48<>\"\",('Entry Form'!A48),\"\")","v":"END TERMINALS USED"},{"$f":"IF('Entry Form'!B48<>\"\",'Entry Form'!B48,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A49<>\"\",('Entry Form'!A49),\"\")","v":""},{"$f":"IF('Entry Form'!B49<>\"\",'Entry Form'!B49,\"\")","v":""}]
["DRAINAGE",{"$f":"IF('Entry Form'!B50<>\"\",'Entry Form'!B50,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A51<>\"\",('Entry Form'!A51),\"\")","v":"MAJOR SYSTEM CAPACITY (URBAN)"},{"$f":"IF('Entry Form'!B51<>\"\",'Entry Form'!B51,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A52<>\"\",('Entry Form'!A52),\"\")","v":"MINOR SYSTEM CAPACITY  (URBAN)"},{"$f":"IF('Entry Form'!B52<>\"\",'Entry Form'!B52,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A53<>\"\",('Entry Form'!A53),\"\")","v":"CULVERT DESIGN "},{"$f":"IF('Entry Form'!B53<>\"\",'Entry Form'!B53,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A54<>\"\",('Entry Form'!A54),\"\")","v":"FLOODWAY DESIGN "},{"$f":"IF('Entry Form'!B54<>\"\",'Entry Form'!B54,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A55<>\"\",('Entry Form'!A55),\"\")","v":"BRIDGE DESIGN"},{"$f":"IF('Entry Form'!B55<>\"\",'Entry Form'!B55,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A56<>\"\",('Entry Form'!A56),\"\")","v":"AATOC"},{"$f":"IF('Entry Form'!B56<>\"\",'Entry Form'!B56,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A57<>\"\",('Entry Form'!A57),\"\")","v":"PROTECTED AT X% AEP"},{"$f":"IF('Entry Form'!B57<>\"\",'Entry Form'!B57,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A58<>\"\",('Entry Form'!A58),\"\")","v":"GUIDE AND STANDARD USED"},{"$f":"IF('Entry Form'!B58<>\"\",UPPER(LineTxt('Entry Form'!B58)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[null,{"$f":"IF('Entry Form'!B59<>\"\",'Entry Form'!B59,\"\")","v":""}]
["SURVEY",{"$f":"IF('Entry Form'!B60<>\"\",'Entry Form'!B60,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A61<>\"\",('Entry Form'!A61),\"\")","v":"SURVEY BY"},{"$f":"IF('Entry Form'!B61<>\"\",'Entry Form'!B61,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A62<>\"\",('Entry Form'!A62),\"\")","v":"DATE OF SURVEY"},{"$f":"IF('Entry Form'!B62<>\"\",'Entry Form'!B62,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A63<>\"\",('Entry Form'!A63),\"\")","v":"GEODETIC DATUM"},{"$f":"IF('Entry Form'!B63<>\"\",'Entry Form'!B63,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A64<>\"\",('Entry Form'!A64),\"\")","v":"LEVEL DATUM"},{"$f":"IF('Entry Form'!B64<>\"\",'Entry Form'!B64,\"\")","v":"Choose an item"}]
[null,{"$f":"IF('Entry Form'!B65<>\"\",'Entry Form'!B65,\"\")","v":""}]
["LIGHTING",{"$f":"IF('Entry Form'!B66<>\"\",'Entry Form'!B66,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A67<>\"\",('Entry Form'!A67),\"\")","v":"ROADWAY LIGHTING LEVEL"},{"$f":"IF('Entry Form'!B67<>\"\",'Entry Form'!B67,\"\")","v":"Choose an item"},{"$f":"IF('Entry Form'!C67<>\"\",'Entry Form'!C67,\"\")","v":" "},{"$f":"IF('Entry Form'!D67<>\"\",'Entry Form'!D67,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A68<>\"\",('Entry Form'!A68),\"\")","v":"INTERSECTION LIGHTING LEVEL"},{"$f":"IF('Entry Form'!B68<>\"\",'Entry Form'!B68,\"\")","v":"Choose an item"},{"$f":"IF('Entry Form'!C68<>\"\",'Entry Form'!C68,\"\")","v":" "},{"$f":"IF('Entry Form'!D68<>\"\",'Entry Form'!D68,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A69<>\"\",UPPER('Entry Form'!A69),\"\")","v":""},{"$f":"IF('Entry Form'!B70<>\"\",'Entry Form'!B70,\"\")","v":""}]
["SIDE TRACK FOR DETOURS"]
[{"$f":"IF('Entry Form'!A71<>\"\",('Entry Form'!A71),\"\")","v":"SIDE TRACK STANDARD"},{"$f":"IF('Entry Form'!B71<>\"\",'Entry Form'!B71,\"\")","v":"Choose an item"},null,{"$f":"IF('Entry Form'!C71<>\"\",'Entry Form'!C71,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A72<>\"\",UPPER('Entry Form'!A72),\"\")","v":""}]

{"sheet":"ROAD 1 and ROAD 2","index":9,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":true,"merged":[[64,0,64,6],[68,0,68,6],[71,0,71,6],[27,2,27,3],[27,5,27,6],[65,0,65,6],[69,0,69,6],[0,1,0,3],[69,52,69,55],[69,56,69,59],[69,60,69,63],[69,64,69,67],[69,68,69,71],[10,0,10,6],[30,0,30,6],[33,0,33,6],[44,0,44,6],[49,0,49,6],[59,0,59,6],[69,72,69,75],[69,28,69,31],[69,32,69,35],[69,36,69,39],[69,40,69,43],[69,44,69,47],[69,48,69,51],[69,8,69,11],[69,12,69,15],[69,16,69,19],[69,20,69,23],[69,24,69,27],[28,1,28,3],[28,4,28,6],[57,4,57,6],[57,1,57,3],[42,1,42,3],[42,4,42,6],[26,1,26,3],[26,4,26,6],[29,0,29,6],[32,0,32,6],[43,0,43,6],[48,0,48,6],[58,0,58,6],[69,124,69,127],[69,128,69,131],[69,132,69,135],[69,136,69,139],[69,140,69,143],[69,144,69,147],[69,100,69,103],[69,104,69,107],[69,108,69,111],[69,112,69,115],[69,116,69,119],[69,120,69,123],[69,76,69,79],[69,80,69,83],[69,84,69,87],[69,88,69,91],[69,92,69,95],[69,96,69,99],[69,196,69,199],[69,200,69,203],[69,204,69,207],[69,208,69,211],[69,212,69,215],[69,216,69,219],[69,172,69,175],[69,176,69,179],[69,180,69,183],[69,184,69,187],[69,188,69,191],[69,192,69,195],[69,148,69,151],[69,152,69,155],[69,156,69,159],[69,160,69,163],[69,164,69,167],[69,168,69,171],[69,276,69,279],[69,292,69,295],[69,296,69,299],[69,300,69,303],[69,304,69,307],[69,308,69,311],[69,312,69,315],[69,412,69,415],[69,280,69,283],[69,284,69,287],[69,288,69,291],[69,244,69,247],[69,248,69,251],[69,252,69,255],[69,256,69,259],[69,260,69,263],[69,264,69,267],[69,220,69,223],[69,224,69,227],[69,228,69,231],[69,232,69,235],[69,236,69,239],[69,240,69,243],[69,340,69,343],[69,344,69,347],[69,388,69,391],[69,392,69,395],[69,396,69,399],[69,400,69,403],[69,404,69,407],[69,408,69,411],[69,364,69,367],[69,368,69,371],[69,372,69,375],[69,376,69,379],[69,380,69,383],[69,384,69,387],[69,348,69,351],[69,352,69,355],[69,356,69,359],[69,360,69,363],[69,316,69,319],[69,320,69,323],[69,324,69,327],[69,328,69,331],[69,332,69,335],[69,336,69,339],[69,268,69,271],[69,272,69,275],[69,460,69,463],[69,464,69,467],[69,468,69,471],[69,472,69,475],[69,476,69,479],[69,480,69,483],[69,436,69,439],[69,440,69,443],[69,444,69,447],[69,448,69,451],[69,452,69,455],[69,456,69,459],[69,416,69,419],[69,420,69,423],[69,424,69,427],[69,428,69,431],[69,432,69,435],[69,540,69,543],[69,556,69,559],[69,560,69,563],[69,564,69,567],[69,568,69,571],[69,572,69,575],[69,576,69,579],[69,676,69,679],[69,544,69,547],[69,548,69,551],[69,552,69,555],[69,508,69,511],[69,512,69,515],[69,516,69,519],[69,520,69,523],[69,524,69,527],[69,528,69,531],[69,484,69,487],[69,488,69,491],[69,492,69,495],[69,496,69,499],[69,500,69,503],[69,504,69,507],[69,604,69,607],[69,608,69,611],[69,652,69,655],[69,656,69,659],[69,660,69,663],[69,664,69,667],[69,668,69,671],[69,672,69,675],[69,628,69,631],[69,632,69,635],[69,636,69,639],[69,640,69,643],[69,644,69,647],[69,648,69,651],[69,612,69,615],[69,616,69,619],[69,620,69,623],[69,624,69,627],[69,580,69,583],[69,584,69,587],[69,588,69,591],[69,592,69,595],[69,596,69,599],[69,600,69,603],[69,532,69,535],[69,536,69,539],[69,724,69,727],[69,728,69,731],[69,732,69,735],[69,736,69,739],[69,740,69,743],[69,744,69,747],[69,700,69,703],[69,704,69,707],[69,708,69,711],[69,712,69,715],[69,716,69,719],[69,720,69,723],[69,680,69,683],[69,684,69,687],[69,688,69,691],[69,692,69,695],[69,696,69,699],[69,796,69,799],[69,800,69,803],[69,804,69,807],[69,808,69,811],[69,812,69,815],[69,816,69,819],[69,772,69,775],[69,776,69,779],[69,780,69,783],[69,784,69,787],[69,788,69,791],[69,792,69,795],[69,748,69,751],[69,752,69,755],[69,756,69,759],[69,760,69,763],[69,764,69,767],[69,768,69,771],[69,868,69,871],[69,872,69,875],[69,876,69,879],[69,880,69,883],[69,884,69,887],[69,888,69,891],[69,844,69,847],[69,848,69,851],[69,852,69,855],[69,856,69,859],[69,860,69,863],[69,864,69,867],[69,820,69,823],[69,824,69,827],[69,828,69,831],[69,832,69,835],[69,836,69,839],[69,840,69,843],[69,940,69,943],[69,944,69,947],[69,948,69,951],[69,952,69,955],[69,956,69,959],[69,960,69,963],[69,916,69,919],[69,920,69,923],[69,924,69,927],[69,928,69,931],[69,932,69,935],[69,936,69,939],[69,892,69,895],[69,896,69,899],[69,900,69,903],[69,904,69,907],[69,908,69,911],[69,912,69,915],[69,1012,69,1015],[69,1016,69,1019],[69,1020,69,1023],[69,1024,69,1027],[69,1028,69,1031],[69,1032,69,1035],[69,988,69,991],[69,992,69,995],[69,996,69,999],[69,1000,69,1003],[69,1004,69,1007],[69,1008,69,1011],[69,964,69,967],[69,968,69,971],[69,972,69,975],[69,976,69,979],[69,980,69,983],[69,984,69,987],[69,1084,69,1087],[69,1088,69,1091],[69,1092,69,1095],[69,1096,69,1099],[69,1100,69,1103],[69,1104,69,1107],[69,1060,69,1063],[69,1064,69,1067],[69,1068,69,1071],[69,1072,69,1075],[69,1076,69,1079],[69,1080,69,1083],[69,1036,69,1039],[69,1040,69,1043],[69,1044,69,1047],[69,1048,69,1051],[69,1052,69,1055],[69,1056,69,1059],[69,1156,69,1159],[69,1160,69,1163],[69,1164,69,1167],[69,1168,69,1171],[69,1172,69,1175],[69,1176,69,1179],[69,1132,69,1135],[69,1136,69,1139],[69,1140,69,1143],[69,1144,69,1147],[69,1148,69,1151],[69,1152,69,1155],[69,1108,69,1111],[69,1112,69,1115],[69,1116,69,1119],[69,1120,69,1123],[69,1124,69,1127],[69,1128,69,1131],[69,1228,69,1231],[69,1232,69,1235],[69,1236,69,1239],[69,1240,69,1243],[69,1244,69,1247],[69,1248,69,1251],[69,1204,69,1207],[69,1208,69,1211],[69,1212,69,1215],[69,1216,69,1219],[69,1220,69,1223],[69,1224,69,1227],[69,1180,69,1183],[69,1184,69,1187],[69,1188,69,1191],[69,1192,69,1195],[69,1196,69,1199],[69,1200,69,1203],[69,1300,69,1303],[69,1304,69,1307],[69,1308,69,1311],[69,1312,69,1315],[69,1316,69,1319],[69,1320,69,1323],[69,1276,69,1279],[69,1280,69,1283],[69,1284,69,1287],[69,1288,69,1291],[69,1292,69,1295],[69,1296,69,1299],[69,1252,69,1255],[69,1256,69,1259],[69,1260,69,1263],[69,1264,69,1267],[69,1268,69,1271],[69,1272,69,1275],[69,1372,69,1375],[69,1376,69,1379],[69,1380,69,1383],[69,1384,69,1387],[69,1388,69,1391],[69,1392,69,1395],[69,1348,69,1351],[69,1352,69,1355],[69,1356,69,1359],[69,1360,69,1363],[69,1364,69,1367],[69,1368,69,1371],[69,1324,69,1327],[69,1328,69,1331],[69,1332,69,1335],[69,1336,69,1339],[69,1340,69,1343],[69,1344,69,1347],[69,1444,69,1447],[69,1448,69,1451],[69,1452,69,1455],[69,1456,69,1459],[69,1460,69,1463],[69,1464,69,1467],[69,1420,69,1423],[69,1424,69,1427],[69,1428,69,1431],[69,1432,69,1435],[69,1436,69,1439],[69,1440,69,1443],[69,1396,69,1399],[69,1400,69,1403],[69,1404,69,1407],[69,1408,69,1411],[69,1412,69,1415],[69,1416,69,1419],[69,1516,69,1519],[69,1520,69,1523],[69,1524,69,1527],[69,1528,69,1531],[69,1532,69,1535],[69,1536,69,1539],[69,1492,69,1495],[69,1496,69,1499],[69,1500,69,1503],[69,1504,69,1507],[69,1508,69,1511],[69,1512,69,1515],[69,1468,69,1471],[69,1472,69,1475],[69,1476,69,1479],[69,1480,69,1483],[69,1484,69,1487],[69,1488,69,1491],[69,1588,69,1591],[69,1592,69,1595],[69,1596,69,1599],[69,1600,69,1603],[69,1604,69,1607],[69,1608,69,1611],[69,1564,69,1567],[69,1568,69,1571],[69,1572,69,1575],[69,1576,69,1579],[69,1580,69,1583],[69,1584,69,1587],[69,1540,69,1543],[69,1544,69,1547],[69,1548,69,1551],[69,1552,69,1555],[69,1556,69,1559],[69,1560,69,1563],[69,1660,69,1663],[69,1664,69,1667],[69,1668,69,1671],[69,1672,69,1675],[69,1676,69,1679],[69,1680,69,1683],[69,1636,69,1639],[69,1640,69,1643],[69,1644,69,1647],[69,1648,69,1651],[69,1652,69,1655],[69,1656,69,1659],[69,1612,69,1615],[69,1616,69,1619],[69,1620,69,1623],[69,1624,69,1627],[69,1628,69,1631],[69,1632,69,1635],[69,1732,69,1735],[69,1736,69,1739],[69,1740,69,1743],[69,1744,69,1747],[69,1748,69,1751],[69,1752,69,1755],[69,1708,69,1711],[69,1712,69,1715],[69,1716,69,1719],[69,1720,69,1723],[69,1724,69,1727],[69,1728,69,1731],[69,1684,69,1687],[69,1688,69,1691],[69,1692,69,1695],[69,1696,69,1699],[69,1700,69,1703],[69,1704,69,1707],[69,1804,69,1807],[69,1808,69,1811],[69,1812,69,1815],[69,1816,69,1819],[69,1820,69,1823],[69,1824,69,1827],[69,1780,69,1783],[69,1784,69,1787],[69,1788,69,1791],[69,1792,69,1795],[69,1796,69,1799],[69,1800,69,1803],[69,1756,69,1759],[69,1760,69,1763],[69,1764,69,1767],[69,1768,69,1771],[69,1772,69,1775],[69,1776,69,1779],[69,1876,69,1879],[69,1880,69,1883],[69,1884,69,1887],[69,1888,69,1891],[69,1892,69,1895],[69,1896,69,1899],[69,1852,69,1855],[69,1856,69,1859],[69,1860,69,1863],[69,1864,69,1867],[69,1868,69,1871],[69,1872,69,1875],[69,1828,69,1831],[69,1832,69,1835],[69,1836,69,1839],[69,1840,69,1843],[69,1844,69,1847],[69,1848,69,1851],[69,1948,69,1951],[69,1952,69,1955],[69,1956,69,1959],[69,1960,69,1963],[69,1964,69,1967],[69,1968,69,1971],[69,1924,69,1927],[69,1928,69,1931],[69,1932,69,1935],[69,1936,69,1939],[69,1940,69,1943],[69,1944,69,1947],[69,1900,69,1903],[69,1904,69,1907],[69,1908,69,1911],[69,1912,69,1915],[69,1916,69,1919],[69,1920,69,1923],[69,2020,69,2023],[69,2024,69,2027],[69,2028,69,2031],[69,2032,69,2035],[69,2036,69,2039],[69,2040,69,2043],[69,1996,69,1999],[69,2000,69,2003],[69,2004,69,2007],[69,2008,69,2011],[69,2012,69,2015],[69,2016,69,2019],[69,1972,69,1975],[69,1976,69,1979],[69,1980,69,1983],[69,1984,69,1987],[69,1988,69,1991],[69,1992,69,1995],[69,2092,69,2095],[69,2096,69,2099],[69,2100,69,2103],[69,2104,69,2107],[69,2108,69,2111],[69,2112,69,2115],[69,2068,69,2071],[69,2072,69,2075],[69,2076,69,2079],[69,2080,69,2083],[69,2084,69,2087],[69,2088,69,2091],[69,2044,69,2047],[69,2048,69,2051],[69,2052,69,2055],[69,2056,69,2059],[69,2060,69,2063],[69,2064,69,2067],[69,2164,69,2167],[69,2168,69,2171],[69,2172,69,2175],[69,2176,69,2179],[69,2180,69,2183],[69,2184,69,2187],[69,2140,69,2143],[69,2144,69,2147],[69,2148,69,2151],[69,2152,69,2155],[69,2156,69,2159],[69,2160,69,2163],[69,2116,69,2119],[69,2120,69,2123],[69,2124,69,2127],[69,2128,69,2131],[69,2132,69,2135],[69,2136,69,2139],[69,2236,69,2239],[69,2240,69,2243],[69,2244,69,2247],[69,2248,69,2251],[69,2252,69,2255],[69,2256,69,2259],[69,2212,69,2215],[69,2216,69,2219],[69,2220,69,2223],[69,2224,69,2227],[69,2228,69,2231],[69,2232,69,2235],[69,2188,69,2191],[69,2192,69,2195],[69,2196,69,2199],[69,2200,69,2203],[69,2204,69,2207],[69,2208,69,2211],[69,2308,69,2311],[69,2312,69,2315],[69,2316,69,2319],[69,2320,69,2323],[69,2324,69,2327],[69,2328,69,2331],[69,2284,69,2287],[69,2288,69,2291],[69,2292,69,2295],[69,2296,69,2299],[69,2300,69,2303],[69,2304,69,2307],[69,2260,69,2263],[69,2264,69,2267],[69,2268,69,2271],[69,2272,69,2275],[69,2276,69,2279],[69,2280,69,2283],[69,2380,69,2383],[69,2384,69,2387],[69,2388,69,2391],[69,2392,69,2395],[69,2396,69,2399],[69,2400,69,2403],[69,2356,69,2359],[69,2360,69,2363],[69,2364,69,2367],[69,2368,69,2371],[69,2372,69,2375],[69,2376,69,2379],[69,2332,69,2335],[69,2336,69,2339],[69,2340,69,2343],[69,2344,69,2347],[69,2348,69,2351],[69,2352,69,2355],[69,2452,69,2455],[69,2456,69,2459],[69,2460,69,2463],[69,2464,69,2467],[69,2468,69,2471],[69,2472,69,2475],[69,2428,69,2431],[69,2432,69,2435],[69,2436,69,2439],[69,2440,69,2443],[69,2444,69,2447],[69,2448,69,2451],[69,2404,69,2407],[69,2408,69,2411],[69,2412,69,2415],[69,2416,69,2419],[69,2420,69,2423],[69,2424,69,2427],[69,2524,69,2527],[69,2528,69,2531],[69,2532,69,2535],[69,2536,69,2539],[69,2540,69,2543],[69,2544,69,2547],[69,2500,69,2503],[69,2504,69,2507],[69,2508,69,2511],[69,2512,69,2515],[69,2516,69,2519],[69,2520,69,2523],[69,2476,69,2479],[69,2480,69,2483],[69,2484,69,2487],[69,2488,69,2491],[69,2492,69,2495],[69,2496,69,2499],[69,2596,69,2599],[69,2600,69,2603],[69,2604,69,2607],[69,2608,69,2611],[69,2612,69,2615],[69,2616,69,2619],[69,2572,69,2575],[69,2576,69,2579],[69,2580,69,2583],[69,2584,69,2587],[69,2588,69,2591],[69,2592,69,2595],[69,2548,69,2551],[69,2552,69,2555],[69,2556,69,2559],[69,2560,69,2563],[69,2564,69,2567],[69,2568,69,2571],[69,2668,69,2671],[69,2672,69,2675],[69,2676,69,2679],[69,2680,69,2683],[69,2684,69,2687],[69,2688,69,2691],[69,2644,69,2647],[69,2648,69,2651],[69,2652,69,2655],[69,2656,69,2659],[69,2660,69,2663],[69,2664,69,2667],[69,2620,69,2623],[69,2624,69,2627],[69,2628,69,2631],[69,2632,69,2635],[69,2636,69,2639],[69,2640,69,2643],[69,2740,69,2743],[69,2744,69,2747],[69,2748,69,2751],[69,2752,69,2755],[69,2756,69,2759],[69,2760,69,2763],[69,2716,69,2719],[69,2720,69,2723],[69,2724,69,2727],[69,2728,69,2731],[69,2732,69,2735],[69,2736,69,2739],[69,2692,69,2695],[69,2696,69,2699],[69,2700,69,2703],[69,2704,69,2707],[69,2708,69,2711],[69,2712,69,2715],[69,2812,69,2815],[69,2816,69,2819],[69,2820,69,2823],[69,2824,69,2827],[69,2828,69,2831],[69,2832,69,2835],[69,2788,69,2791],[69,2792,69,2795],[69,2796,69,2799],[69,2800,69,2803],[69,2804,69,2807],[69,2808,69,2811],[69,2764,69,2767],[69,2768,69,2771],[69,2772,69,2775],[69,2776,69,2779],[69,2780,69,2783],[69,2784,69,2787],[69,2884,69,2887],[69,2888,69,2891],[69,2892,69,2895],[69,2896,69,2899],[69,2900,69,2903],[69,2904,69,2907],[69,2860,69,2863],[69,2864,69,2867],[69,2868,69,2871],[69,2872,69,2875],[69,2876,69,2879],[69,2880,69,2883],[69,2836,69,2839],[69,2840,69,2843],[69,2844,69,2847],[69,2848,69,2851],[69,2852,69,2855],[69,2856,69,2859],[69,2956,69,2959],[69,2960,69,2963],[69,2964,69,2967],[69,2968,69,2971],[69,2972,69,2975],[69,2976,69,2979],[69,2932,69,2935],[69,2936,69,2939],[69,2940,69,2943],[69,2944,69,2947],[69,2948,69,2951],[69,2952,69,2955],[69,2908,69,2911],[69,2912,69,2915],[69,2916,69,2919],[69,2920,69,2923],[69,2924,69,2927],[69,2928,69,2931],[69,3028,69,3031],[69,3032,69,3035],[69,3036,69,3039],[69,3040,69,3043],[69,3044,69,3047],[69,3048,69,3051],[69,3004,69,3007],[69,3008,69,3011],[69,3012,69,3015],[69,3016,69,3019],[69,3020,69,3023],[69,3024,69,3027],[69,2980,69,2983],[69,2984,69,2987],[69,2988,69,2991],[69,2992,69,2995],[69,2996,69,2999],[69,3000,69,3003],[69,3100,69,3103],[69,3104,69,3107],[69,3108,69,3111],[69,3112,69,3115],[69,3116,69,3119],[69,3120,69,3123],[69,3076,69,3079],[69,3080,69,3083],[69,3084,69,3087],[69,3088,69,3091],[69,3092,69,3095],[69,3096,69,3099],[69,3052,69,3055],[69,3056,69,3059],[69,3060,69,3063],[69,3064,69,3067],[69,3068,69,3071],[69,3072,69,3075],[69,3172,69,3175],[69,3176,69,3179],[69,3180,69,3183],[69,3184,69,3187],[69,3188,69,3191],[69,3192,69,3195],[69,3148,69,3151],[69,3152,69,3155],[69,3156,69,3159],[69,3160,69,3163],[69,3164,69,3167],[69,3168,69,3171],[69,3124,69,3127],[69,3128,69,3131],[69,3132,69,3135],[69,3136,69,3139],[69,3140,69,3143],[69,3144,69,3147],[69,3244,69,3247],[69,3248,69,3251],[69,3252,69,3255],[69,3256,69,3259],[69,3260,69,3263],[69,3264,69,3267],[69,3220,69,3223],[69,3224,69,3227],[69,3228,69,3231],[69,3232,69,3235],[69,3236,69,3239],[69,3240,69,3243],[69,3196,69,3199],[69,3200,69,3203],[69,3204,69,3207],[69,3208,69,3211],[69,3212,69,3215],[69,3216,69,3219],[69,3316,69,3319],[69,3320,69,3323],[69,3324,69,3327],[69,3328,69,3331],[69,3332,69,3335],[69,3336,69,3339],[69,3292,69,3295],[69,3296,69,3299],[69,3300,69,3303],[69,3304,69,3307],[69,3308,69,3311],[69,3312,69,3315],[69,3268,69,3271],[69,3272,69,3275],[69,3276,69,3279],[69,3280,69,3283],[69,3284,69,3287],[69,3288,69,3291],[69,3388,69,3391],[69,3392,69,3395],[69,3396,69,3399],[69,3400,69,3403],[69,3404,69,3407],[69,3408,69,3411],[69,3364,69,3367],[69,3368,69,3371],[69,3372,69,3375],[69,3376,69,3379],[69,3380,69,3383],[69,3384,69,3387],[69,3340,69,3343],[69,3344,69,3347],[69,3348,69,3351],[69,3352,69,3355],[69,3356,69,3359],[69,3360,69,3363],[69,3460,69,3463],[69,3464,69,3467],[69,3468,69,3471],[69,3472,69,3475],[69,3476,69,3479],[69,3480,69,3483],[69,3436,69,3439],[69,3440,69,3443],[69,3444,69,3447],[69,3448,69,3451],[69,3452,69,3455],[69,3456,69,3459],[69,3412,69,3415],[69,3416,69,3419],[69,3420,69,3423],[69,3424,69,3427],[69,3428,69,3431],[69,3432,69,3435],[69,3532,69,3535],[69,3536,69,3539],[69,3540,69,3543],[69,3544,69,3547],[69,3548,69,3551],[69,3552,69,3555],[69,3508,69,3511],[69,3512,69,3515],[69,3516,69,3519],[69,3520,69,3523],[69,3524,69,3527],[69,3528,69,3531],[69,3484,69,3487],[69,3488,69,3491],[69,3492,69,3495],[69,3496,69,3499],[69,3500,69,3503],[69,3504,69,3507],[69,3604,69,3607],[69,3608,69,3611],[69,3612,69,3615],[69,3616,69,3619],[69,3620,69,3623],[69,3624,69,3627],[69,3580,69,3583],[69,3584,69,3587],[69,3588,69,3591],[69,3592,69,3595],[69,3596,69,3599],[69,3600,69,3603],[69,3556,69,3559],[69,3560,69,3563],[69,3564,69,3567],[69,3568,69,3571],[69,3572,69,3575],[69,3576,69,3579],[69,3676,69,3679],[69,3680,69,3683],[69,3684,69,3687],[69,3688,69,3691],[69,3692,69,3695],[69,3696,69,3699],[69,3652,69,3655],[69,3656,69,3659],[69,3660,69,3663],[69,3664,69,3667],[69,3668,69,3671],[69,3672,69,3675],[69,3628,69,3631],[69,3632,69,3635],[69,3636,69,3639],[69,3640,69,3643],[69,3644,69,3647],[69,3648,69,3651],[69,3748,69,3751],[69,3752,69,3755],[69,3756,69,3759],[69,3760,69,3763],[69,3764,69,3767],[69,3768,69,3771],[69,3724,69,3727],[69,3728,69,3731],[69,3732,69,3735],[69,3736,69,3739],[69,3740,69,3743],[69,3744,69,3747],[69,3700,69,3703],[69,3704,69,3707],[69,3708,69,3711],[69,3712,69,3715],[69,3716,69,3719],[69,3720,69,3723],[69,3820,69,3823],[69,3824,69,3827],[69,3828,69,3831],[69,3832,69,3835],[69,3836,69,3839],[69,3840,69,3843],[69,3796,69,3799],[69,3800,69,3803],[69,3804,69,3807],[69,3808,69,3811],[69,3812,69,3815],[69,3816,69,3819],[69,3772,69,3775],[69,3776,69,3779],[69,3780,69,3783],[69,3784,69,3787],[69,3788,69,3791],[69,3792,69,3795],[69,3892,69,3895],[69,3896,69,3899],[69,3900,69,3903],[69,3904,69,3907],[69,3908,69,3911],[69,3912,69,3915],[69,3868,69,3871],[69,3872,69,3875],[69,3876,69,3879],[69,3880,69,3883],[69,3884,69,3887],[69,3888,69,3891],[69,3844,69,3847],[69,3848,69,3851]],"merged_total":4118,"flags":["merged_cut"]}
["BASIS OF DESIGN",{"$f":"'Entry Form'!B1","v":"ROAD 1"},null,null,{"$f":"'Entry Form'!E1","v":"ROAD 2"},null,null,"ISOCPEUR"]
["PROJECT CRITERIA","PROJECT SPECIFIC VALUES","GUIDELINE DESIGN VALUES","COMMENT ON PROJECT VALUES ","PROJECT SPECIFIC VALUES","GUIDELINE DESIGN VALUES","COMMENT ON PROJECT VALUES ","19.5 excel = 4.939 AutoCAD"]
[{"$f":"IF('Entry Form'!A3<>\"\",('Entry Form'!A3),\"\")","v":"ROAD CLASS - AUSTROADS CLASS"},{"$f":"IF('Entry Form'!B3<>\"\",'Entry Form'!B3,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E3<>\"\",'Entry Form'!E3,\"\")","v":"Choose an item"},null,null,"14.5 excel = 3.528 AutoCAD"]
[{"$f":"IF('Entry Form'!A4<>\"\",('Entry Form'!A4),\"\")","v":"DESIGN VEHICLE"},{"$f":"IF('Entry Form'!B4<>\"\",'Entry Form'!B4,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E4<>\"\",'Entry Form'!E4,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A5<>\"\",('Entry Form'!A5),\"\")","v":"DESIGN SPEED (km/h)"},{"$f":"IF('Entry Form'!B5<>\"\",'Entry Form'!B5,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E5<>\"\",'Entry Form'!E5,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A6<>\"\",('Entry Form'!A6),\"\")","v":"POSTED SPEED (km/h)"},{"$f":"IF('Entry Form'!B6<>\"\",'Entry Form'!B6,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E6<>\"\",'Entry Form'!E6,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A7<>\"\",('Entry Form'!A7),\"\")","v":"REACTION TIME"},{"$f":"IF('Entry Form'!B7<>\"\",'Entry Form'!B7,\"\")","v":0},null,null,{"$f":"IF('Entry Form'!E7<>\"\",'Entry Form'!E7,\"\")","v":0}]
[{"$f":"IF('Entry Form'!A8<>\"\",('Entry Form'!A8),\"\")","v":"CARRIAGEWAY TYPE"},{"$f":"IF('Entry Form'!B8<>\"\",'Entry Form'!B8,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E8<>\"\",'Entry Form'!E8,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A9<>\"\",('Entry Form'!A9),\"\")","v":"SURFACE  TYPE"},{"$f":"IF('Entry Form'!B9<>\"\",'Entry Form'!B9,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E9<>\"\",'Entry Form'!E9,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A10<>\"\",('Entry Form'!A10),\"\")","v":"MAX SUPERELEVATION (%)"},{"$f":"IF('Entry Form'!B10<>\"\",'Entry Form'!B10,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E10<>\"\",'Entry Form'!E10,\"\")","v":""}]
["GEOMETRY"]
[{"$f":"IF('Entry Form'!A12<>\"\",('Entry Form'!A12),\"\")","v":"MIN HORIZONTAL CURVE RADIUS  FOR CAR(m)"},{"$f":"IF('Entry Form'!B12<>\"\",'Entry Form'!B12,\"\")","v":""},{"$f":"'Entry Form'!C12","v":""},{"$f":"'Entry Form'!D12","v":""},{"$f":"IF('Entry Form'!E12<>\"\",'Entry Form'!E12,\"\")","v":""},{"$f":"'Entry Form'!F12","v":""},{"$f":"'Entry Form'!G12","v":""}]
[{"$f":"IF('Entry Form'!A13<>\"\",('Entry Form'!A13),\"\")","v":"MIN HORIZONTAL CURVE RADIUS  FOR TRUCK(m)"},{"$f":"IF('Entry Form'!B13<>\"\",'Entry Form'!B13,\"\")","v":""},{"$f":"'Entry Form'!C13","v":""},{"$f":"'Entry Form'!D13","v":""},{"$f":"IF('Entry Form'!E13<>\"\",'Entry Form'!E13,\"\")","v":""},{"$f":"'Entry Form'!F13","v":""},{"$f":"'Entry Form'!G13","v":""}]
[{"$f":"IF('Entry Form'!A14<>\"\",('Entry Form'!A14),\"\")","v":"CURVE LANE WIDENEING"},{"$f":"IF('Entry Form'!B14<>\"\",'Entry Form'!B14,\"\")","v":"Choose an item"},{"$f":"'Entry Form'!C14","v":""},{"$f":"'Entry Form'!D14","v":"-"},{"$f":"IF('Entry Form'!E14<>\"\",'Entry Form'!E14,\"\")","v":"Choose an item"},{"$f":"'Entry Form'!F14","v":""},{"$f":"'Entry Form'!G14","v":"-"}]
[{"$f":"IF('Entry Form'!A15<>\"\",('Entry Form'!A15),\"\")","v":"MIN OVERTAKING ESTABLISHMENT SIGHT DISTANCE (m)"},{"$f":"IF('Entry Form'!B15<>\"\",'Entry Form'!B15,\"\")","v":""},{"$f":"'Entry Form'!C15","v":""},{"$f":"'Entry Form'!D15","v":""},{"$f":"IF('Entry Form'!E15<>\"\",'Entry Form'!E15,\"\")","v":""},{"$f":"'Entry Form'!F15","v":""},{"$f":"'Entry Form'!G15","v":""}]
[{"$f":"IF('Entry Form'!A16<>\"\",('Entry Form'!A16),\"\")","v":"MIN OVERTAKING LENGTH  (m)"},{"$f":"IF('Entry Form'!B16<>\"\",'Entry Form'!B16,\"\")","v":""},{"$f":"'Entry Form'!C16","v":""},{"$f":"'Entry Form'!D16","v":""},{"$f":"IF('Entry Form'!E16<>\"\",'Entry Form'!E16,\"\")","v":""},{"$f":"'Entry Form'!F16","v":""},{"$f":"'Entry Form'!G16","v":""}]
[{"$f":"IF('Entry Form'!A17<>\"\",('Entry Form'!A17),\"\")","v":"MIN LENGTH OF BARRIER LINES (m)"},{"$f":"IF('Entry Form'!B17<>\"\",'Entry Form'!B17,\"\")","v":""},{"$f":"'Entry Form'!C17","v":""},{"$f":"'Entry Form'!D17","v":""},{"$f":"IF('Entry Form'!E17<>\"\",'Entry Form'!E17,\"\")","v":""},{"$f":"'Entry Form'!F17","v":""},{"$f":"'Entry Form'!G17","v":""}]
[{"$f":"IF('Entry Form'!A18<>\"\",('Entry Form'!A18),\"\")","v":"MIN CAR STOPPING SIGHT DISTANCE (m)"},{"$f":"IF('Entry Form'!B18<>\"\",'Entry Form'!B18,\"\")","v":""},{"$f":"'Entry Form'!C18","v":""},{"$f":"'Entry Form'!D18","v":""},{"$f":"IF('Entry Form'!E18<>\"\",'Entry Form'!E18,\"\")","v":""},{"$f":"'Entry Form'!F18","v":""},{"$f":"'Entry Form'!G18","v":""}]
[{"$f":"IF('Entry Form'!A19<>\"\",('Entry Form'!A19),\"\")","v":"MIN TRUCK STOPPING SIGHT DISTANCE (m)"},{"$f":"IF('Entry Form'!B19<>\"\",'Entry Form'!B19,\"\")","v":""},{"$f":"'Entry Form'!C19","v":""},{"$f":"'Entry Form'!D19","v":""},{"$f":"IF('Entry Form'!E19<>\"\",'Entry Form'!E19,\"\")","v":""},{"$f":"'Entry Form'!F19","v":""},{"$f":"'Entry Form'!G19","v":""}]
[{"$f":"IF('Entry Form'!A20<>\"\",('Entry Form'!A20),\"\")","v":"MIN INTERSECTION SIGHT DISTANCE FOR CARS (m)"},{"$f":"IF('Entry Form'!B20<>\"\",'Entry Form'!B20,\"\")","v":""},{"$f":"'Entry Form'!C20","v":""},{"$f":"'Entry Form'!D20","v":""},{"$f":"IF('Entry Form'!E20<>\"\",'Entry Form'!E20,\"\")","v":""},{"$f":"'Entry Form'!F20","v":""},{"$f":"'Entry Form'!G20","v":""}]
[{"$f":"IF('Entry Form'!A21<>\"\",('Entry Form'!A21),\"\")","v":"MIN INTERSECTION SIGHT DISTANCE FOR TRUCKS (m)"},{"$f":"IF('Entry Form'!B21<>\"\",'Entry Form'!B21,\"\")","v":""},{"$f":"'Entry Form'!C21","v":""},{"$f":"'Entry Form'!D21","v":""},{"$f":"IF('Entry Form'!E21<>\"\",'Entry Form'!E21,\"\")","v":""},{"$f":"'Entry Form'!F21","v":""},{"$f":"'Entry Form'!G21","v":""}]
[{"$f":"IF('Entry Form'!A22<>\"\",('Entry Form'!A22),\"\")","v":"MIN CREST VERTICAL CURVE K VALUE FOR CARS (S<L)"},{"$f":"IF('Entry Form'!B22<>\"\",'Entry Form'!B22,\"\")","v":""},{"$f":"'Entry Form'!C22","v":""},{"$f":"'Entry Form'!D22","v":""},{"$f":"IF('Entry Form'!E22<>\"\",'Entry Form'!E22,\"\")","v":""},{"$f":"'Entry Form'!F22","v":""},{"$f":"'Entry Form'!G22","v":""}]
[{"$f":"IF('Entry Form'!A23<>\"\",('Entry Form'!A23),\"\")","v":"MIN CREST VERTICAL CURVE K VALUE FOR TRUCKS (S<L)"},{"$f":"IF('Entry Form'!B23<>\"\",'Entry Form'!B23,\"\")","v":""},{"$f":"'Entry Form'!C23","v":""},{"$f":"'Entry Form'!D23","v":""},{"$f":"IF('Entry Form'!E23<>\"\",'Entry Form'!E23,\"\")","v":""},{"$f":"'Entry Form'!F23","v":""},{"$f":"'Entry Form'!G23","v":""}]
[{"$f":"IF('Entry Form'!A24<>\"\",('Entry Form'!A24),\"\")","v":"MIN SAG  VERTICAL CURVE K VALUE FOR CAR (S<L)"},{"$f":"IF('Entry Form'!B24<>\"\",'Entry Form'!B24,\"\")","v":""},{"$f":"'Entry Form'!C24","v":""},{"$f":"'Entry Form'!D24","v":""},{"$f":"IF('Entry Form'!E24<>\"\",'Entry Form'!E24,\"\")","v":""},{"$f":"'Entry Form'!F24","v":""},{"$f":"'Entry Form'!G24","v":""}]
[{"$f":"IF('Entry Form'!A25<>\"\",('Entry Form'!A25),\"\")","v":"MIN SAG  VERTICAL CURVE K VALUE FOR TRUCK (S<L)"},{"$f":"IF('Entry Form'!B25<>\"\",'Entry Form'!B25,\"\")","v":""},{"$f":"'Entry Form'!C25","v":""},{"$f":"'Entry Form'!D25","v":""},{"$f":"IF('Entry Form'!E25<>\"\",'Entry Form'!E25,\"\")","v":""},{"$f":"'Entry Form'!F25","v":""},{"$f":"'Entry Form'!G25","v":""}]
[{"$f":"IF('Entry Form'!A26<>\"\",('Entry Form'!A26),\"\")","v":"DECELERATION LANE INCLUDING TAPER TO STOP CONDITION"},{"$f":"IF('Entry Form'!B26<>\"\",'Entry Form'!B26,\"\")","v":""},{"$f":"'Entry Form'!C26","v":""},{"$f":"'Entry Form'!D26","v":""},{"$f":"IF('Entry Form'!E26<>\"\",'Entry Form'!E26,\"\")","v":""},{"$f":"'Entry Form'!F26","v":""},{"$f":"'Entry Form'!G26","v":""}]
[{"$f":"IF('Entry Form'!A27<>\"\",('Entry Form'!A27),\"\")","v":"HAZARD TREATMENT"},{"$f":"IF('Entry Form'!B27<>\"\",UPPER(LineTxt('Entry Form'!B27)),\"\")","v":"1) CHOOSE AN ITEM.  "},null,null,{"$f":"IF('Entry Form'!E27<>\"\",UPPER(LineTxt('Entry Form'!E27)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[{"$f":"IF('Entry Form'!A28<>\"\",('Entry Form'!A28),\"\")","v":"NUMBER OF TRAFFIC ACCIDENTS (IN THE LAST 10 YEARS)"},{"$f":"IF('Entry Form'!B28<>\"\",'Entry Form'!B28,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E28<>\"\",'Entry Form'!E28,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A29<>\"\",('Entry Form'!A29),\"\")","v":"GUIDE AND STANDARD USED"},{"$f":"IF('Entry Form'!B29<>\"\",UPPER(LineTxt('Entry Form'!B29)),\"\")","v":"1) CHOOSE AN ITEM.  "},null,null,{"$f":"IF('Entry Form'!E29<>\"\",UPPER(LineTxt('Entry Form'!E29)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[]
["ROAD SAFETY AUDIT"]
[{"$f":"IF('Entry Form'!A32<>\"\",('Entry Form'!A32),\"\")","v":"ROAD SAFETY AUDIT UNDERTAKEN"},{"$f":"IF('Entry Form'!B32<>\"\",'Entry Form'!B32,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E32<>\"\",'Entry Form'!E32,\"\")","v":"Choose an item"}]
[null,{"$f":"IF('Entry Form'!B33<>\"\",'Entry Form'!B33,\"\")","v":""}]
["PAVEMENT"]
[{"$f":"IF('Entry Form'!A35<>\"\",('Entry Form'!A35),\"\")","v":"TRAFFIC VOLUME (AADT / YEAR)"},{"$f":"IF('Entry Form'!B35<>\"\",'Entry Form'!B35,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E35<>\"\",'Entry Form'!E35,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A36<>\"\",('Entry Form'!A36),\"\")","v":"GROWTH RATE (%)"},{"$f":"IF('Entry Form'!B36<>\"\",'Entry Form'!B36,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E36<>\"\",'Entry Form'!E36,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A37<>\"\",('Entry Form'!A37),\"\")","v":"PERCENT HEAVY VEHICLES (%)"},{"$f":"IF('Entry Form'!B37<>\"\",'Entry Form'!B37,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E37<>\"\",'Entry Form'!E37,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A38<>\"\",('Entry Form'!A38),\"\")","v":"DESIGN TRAFFIC IN ESA'S (X 10^6)"},{"$f":"IF('Entry Form'!B38<>\"\",'Entry Form'!B38,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E38<>\"\",'Entry Form'!E38,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A39<>\"\",('Entry Form'!A39),\"\")","v":"PAVEMENT DESIGN LIFE (YEARS)"},{"$f":"IF('Entry Form'!B39<>\"\",'Entry Form'!B39,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E39<>\"\",'Entry Form'!E39,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A40<>\"\",('Entry Form'!A40),\"\")","v":"DESIGN CBR VALUES"},{"$f":"IF('Entry Form'!B40<>\"\",'Entry Form'!B40,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E40<>\"\",'Entry Form'!E40,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A41<>\"\",('Entry Form'!A41),\"\")","v":"FROM CH. TO CH."},{"$f":"IF('Entry Form'!B41<>\"\",'Entry Form'!B41,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E41<>\"\",'Entry Form'!E41,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A42<>\"\",('Entry Form'!A42),\"\")","v":"DESIGN METHOD USED"},{"$f":"IF('Entry Form'!B42<>\"\",'Entry Form'!B42,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E42<>\"\",'Entry Form'!E42,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A43<>\"\",('Entry Form'!A43),\"\")","v":"GUIDE AND STANDARD USED"},{"$f":"IF('Entry Form'!B43<>\"\",UPPER(LineTxt('Entry Form'!B43)),\"\")","v":"1) CHOOSE AN ITEM.  "},null,null,{"$f":"IF('Entry Form'!E43<>\"\",UPPER(LineTxt('Entry Form'!E43)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[null,{"$f":"IF('Entry Form'!B44<>\"\",'Entry Form'!B44,\"\")","v":""}]
["ROAD SAFETY BARRIERS"]
[{"$f":"IF('Entry Form'!A46<>\"\",('Entry Form'!A46),\"\")","v":"ROAD SAFETY BARRIERS USED"},{"$f":"IF('Entry Form'!B46<>\"\",'Entry Form'!B46,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E46<>\"\",'Entry Form'!E46,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A47<>\"\",('Entry Form'!A47),\"\")","v":"APPROACH TERMINALS USED"},{"$f":"IF('Entry Form'!B47<>\"\",'Entry Form'!B47,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E47<>\"\",'Entry Form'!E47,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A48<>\"\",('Entry Form'!A48),\"\")","v":"END TERMINALS USED"},{"$f":"IF('Entry Form'!B48<>\"\",'Entry Form'!B48,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E48<>\"\",'Entry Form'!E48,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A49<>\"\",('Entry Form'!A49),\"\")","v":""},{"$f":"IF('Entry Form'!B49<>\"\",'Entry Form'!B49,\"\")","v":""}]
["DRAINAGE"]
[{"$f":"IF('Entry Form'!A51<>\"\",('Entry Form'!A51),\"\")","v":"MAJOR SYSTEM CAPACITY (URBAN)"},{"$f":"IF('Entry Form'!B51<>\"\",'Entry Form'!B51,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E51<>\"\",'Entry Form'!E51,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A52<>\"\",('Entry Form'!A52),\"\")","v":"MINOR SYSTEM CAPACITY  (URBAN)"},{"$f":"IF('Entry Form'!B52<>\"\",'Entry Form'!B52,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E52<>\"\",'Entry Form'!E52,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A53<>\"\",('Entry Form'!A53),\"\")","v":"CULVERT DESIGN "},{"$f":"IF('Entry Form'!B53<>\"\",'Entry Form'!B53,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E53<>\"\",'Entry Form'!E53,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A54<>\"\",('Entry Form'!A54),\"\")","v":"FLOODWAY DESIGN "},{"$f":"IF('Entry Form'!B54<>\"\",'Entry Form'!B54,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E54<>\"\",'Entry Form'!E54,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A55<>\"\",('Entry Form'!A55),\"\")","v":"BRIDGE DESIGN"},{"$f":"IF('Entry Form'!B55<>\"\",'Entry Form'!B55,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E55<>\"\",'Entry Form'!E55,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A56<>\"\",('Entry Form'!A56),\"\")","v":"AATOC"},{"$f":"IF('Entry Form'!B56<>\"\",'Entry Form'!B56,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E56<>\"\",'Entry Form'!E56,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A57<>\"\",('Entry Form'!A57),\"\")","v":"PROTECTED AT X% AEP"},{"$f":"IF('Entry Form'!B57<>\"\",'Entry Form'!B57,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E57<>\"\",'Entry Form'!E57,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A58<>\"\",('Entry Form'!A58),\"\")","v":"GUIDE AND STANDARD USED"},{"$f":"IF('Entry Form'!B58<>\"\",UPPER(LineTxt('Entry Form'!B58)),\"\")","v":"1) CHOOSE AN ITEM.  "},null,null,{"$f":"IF('Entry Form'!E58<>\"\",UPPER(LineTxt('Entry Form'!E58)),\"\")","v":"1) CHOOSE AN ITEM.  "}]
[null,{"$f":"IF('Entry Form'!B59<>\"\",'Entry Form'!B59,\"\")","v":""}]
["SURVEY"]
[{"$f":"IF('Entry Form'!A61<>\"\",('Entry Form'!A61),\"\")","v":"SURVEY BY"},{"$f":"IF('Entry Form'!B61<>\"\",'Entry Form'!B61,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E61<>\"\",'Entry Form'!E61,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A62<>\"\",('Entry Form'!A62),\"\")","v":"DATE OF SURVEY"},{"$f":"IF('Entry Form'!B62<>\"\",'Entry Form'!B62,\"\")","v":""},null,null,{"$f":"IF('Entry Form'!E62<>\"\",'Entry Form'!E62,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A63<>\"\",('Entry Form'!A63),\"\")","v":"GEODETIC DATUM"},{"$f":"IF('Entry Form'!B63<>\"\",'Entry Form'!B63,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E63<>\"\",'Entry Form'!E63,\"\")","v":"Choose an item"}]
[{"$f":"IF('Entry Form'!A64<>\"\",('Entry Form'!A64),\"\")","v":"LEVEL DATUM"},{"$f":"IF('Entry Form'!B64<>\"\",'Entry Form'!B64,\"\")","v":"Choose an item"},null,null,{"$f":"IF('Entry Form'!E64<>\"\",'Entry Form'!E64,\"\")","v":"Choose an item"}]
[null,{"$f":"IF('Entry Form'!B65<>\"\",'Entry Form'!B65,\"\")","v":""}]
["LIGHTING"]
[{"$f":"IF('Entry Form'!A67<>\"\",('Entry Form'!A67),\"\")","v":"ROADWAY LIGHTING LEVEL"},{"$f":"IF('Entry Form'!B67<>\"\",'Entry Form'!B67,\"\")","v":"Choose an item"},{"$f":"IF('Entry Form'!C67<>\"\",'Entry Form'!C67,\"\")","v":" "},{"$f":"IF('Entry Form'!D67<>\"\",'Entry Form'!D67,\"\")","v":""},{"$f":"IF('Entry Form'!E67<>\"\",'Entry Form'!E67,\"\")","v":"Choose an item"},{"$f":"IF('Entry Form'!F67<>\"\",'Entry Form'!F67,\"\")","v":" "},{"$f":"IF('Entry Form'!G67<>\"\",'Entry Form'!G67,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A68<>\"\",('Entry Form'!A68),\"\")","v":"INTERSECTION LIGHTING LEVEL"},{"$f":"IF('Entry Form'!B68<>\"\",'Entry Form'!B68,\"\")","v":"Choose an item"},{"$f":"IF('Entry Form'!C68<>\"\",'Entry Form'!C68,\"\")","v":" "},{"$f":"IF('Entry Form'!D68<>\"\",'Entry Form'!D68,\"\")","v":""},{"$f":"IF('Entry Form'!E68<>\"\",'Entry Form'!E68,\"\")","v":"Choose an item"},{"$f":"IF('Entry Form'!F68<>\"\",'Entry Form'!F68,\"\")","v":" "},{"$f":"IF('Entry Form'!G68<>\"\",'Entry Form'!G68,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A69<>\"\",UPPER('Entry Form'!A69),\"\")","v":""},{"$f":"IF('Entry Form'!B70<>\"\",'Entry Form'!B70,\"\")","v":""}]
["SIDE TRACK FOR DETOURS"]
[{"$f":"IF('Entry Form'!A71<>\"\",('Entry Form'!A71),\"\")","v":"SIDE TRACK STANDARD"},{"$f":"IF('Entry Form'!B71<>\"\",'Entry Form'!B71,\"\")","v":"Choose an item"},null,{"$f":"IF('Entry Form'!C71<>\"\",'Entry Form'!C71,\"\")","v":""},{"$f":"IF('Entry Form'!E71<>\"\",'Entry Form'!E71,\"\")","v":"Choose an item"},null,{"$f":"IF('Entry Form'!F71<>\"\",'Entry Form'!F71,\"\")","v":""}]
[{"$f":"IF('Entry Form'!A72<>\"\",UPPER('Entry Form'!A72),\"\")","v":""}]