{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main Tool","OriginalData","DataSorting","Report-Segment","Report-Network","User Guide","UserSettings"],"not_rendered":{"charts":6,"images":6,"macros":1,"external_links":0,"defined_names":104,"comments":2,"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":"Main Tool","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,2,17,3],[14,2,14,3]]}
[]
[null,"Impacts of Heavy Trucks on Pavements"]
[]
[null,null,"Minnesota State University, Mankato"]
[null,null,"for the Minnesota Local Road Research Board"]
[]
[null,null,"Version",1.04]
[null,null,"Date","2014-12-08"]
[]
[]
[]
[]
[null,"Last Database Imported"]
[null,null,"Filename"]
[null,null,"ESAL Calculation Trial.xls"]
[]
[null,null,"Date"]
[null,null,"2014-12-06"]

{"sheet":"OriginalData","index":1,"n_rows":15,"n_cols":69,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,1,0,19],[0,20,0,32],[0,52,0,57],[0,59,0,64]]}
[{"$f":"COUNTA(A3:A100000)","v":13},"Original Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After Street is Selected",null,null,null,null,null,null,null,null,null,null,"After Segment is Selected",null,null,null,null,null,"More original Data",null,null,null,null,null,null,"More Custom Data"]
["Segment ID","Name","From","To","From-To Concatenation","ADT","HCADT","Surface Type","Surface Thickness, in","Base Type","Base Thickness, in","Subbase Type","Subbase Thickness","Subgrade R Value","Recent PCI","Recent SR","Year of Last Reconstruction","Percent Trucks","Segment Width","Segment Length","Custom ADT","Custom HCADT","Custom Surface Type","Custom Surface Thickness","Custom Base Type","Custom Base Thickness","Custom Subbase Type","Custom Subbase Thickness","Custom R-Value","Custom PCI","Custom SR","Year of Last Reconstruction","Custom Percent Trucks","Original Design ESALs","Segment ID","Name","From","To","From-To Concatenation",null,null,null,null,null,null,"Segment ID","Name","From","To","From-To Concatenation",null,null,null,null,null,null,null,null,null,"1st PCI","1st PCI Date","2nd PCI","2nd PCI Date","3rd PCI","3rd PCI Date",null,null,null,"Unique Segment ID from Importing  Database"]
[1,"3 ST","45TH AVE","46TH AVE","45TH AVE to 46TH AVE",600,44.82,"Asphalt",3.5,"Mn/DOT Class 5",6,"Select Granular Borrow",2,70,null,null,2008,7.47,30,660,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"3 ST","45TH AVE","46TH AVE","45TH AVE to 46TH AVE",null,null,null,null,null,null,3,"3 ST","60TH AVE","61ST AVE","60TH AVE to 61ST AVE",null,null,95,"2008-10-01",95,"2011-10-01",89.100000000000009,"2014-10-07"]
[2,"3 ST","SATELLITE LN","MISSISSIPPI ST","SATELLITE LN to MISSISSIPPI ST",2000,71.2,"Asphalt",3.5,"Mn/DOT Class 5",6,"Select Granular Borrow",2,70,null,null,1996,3.56,32,655,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"3 ST","SATELLITE LN","MISSISSIPPI ST","SATELLITE LN to MISSISSIPPI ST",null,null,null,null,null,null,null,null,null,null,null,null,null,94.5,"2014-10-07"]
[3,"3 ST","60TH AVE","61ST AVE","60TH AVE to 61ST AVE",800,42.32,"Asphalt",1.5,"Mn/DOT Class 7",4,"Select Granular Borrow",2,70,null,null,2011,5.29,35,660,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3 ST","60TH AVE","61ST AVE","60TH AVE to 61ST AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2011-10-01",85.050000000000011,"2014-10-07"]
[4,"3 ST","46TH AVE","49TH AVE","46TH AVE to 49TH AVE",600,44.82,"Asphalt",3,"Mn/DOT Class 6",4,"Select Granular Borrow",2,70,null,null,1966,7.47,35,1975,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"3 ST","46TH AVE","49TH AVE","46TH AVE to 49TH AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,70,"2008-10-01",53,"2011-10-01",52.650000000000006,"2014-10-07"]
[5,"3 ST","49TH AVE","HORIZON DR","49TH AVE to HORIZON DR",800,42.32,"Asphalt",3,"Mn/DOT Class 6",6,"Select Granular Borrow",2,70,null,null,1969,5.29,40,1320,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3 ST","49TH AVE","HORIZON DR","49TH AVE to HORIZON DR",null,null,null,null,null,null,null,null,null,null,null,null,null,70,"2008-10-01",53,"2011-10-01",54,"2014-10-07"]
[6,"3 ST","HORIZON DR","53RD AVE","HORIZON DR to 53RD AVE",800,42.32,"Asphalt",3,"Mn/DOT Class 6",6,"Select Granular Borrow",2,70,null,null,1969,5.29,40,1320,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"3 ST","HORIZON DR","53RD AVE","HORIZON DR to 53RD AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,70,"2008-10-01",51,"2011-10-01",40.5,"2014-10-07"]
[7,"3 ST","58TH AVE","59TH AVE","58TH AVE to 59TH AVE",800,42.32,"Asphalt",3,"Mn/DOT Class 5",2,"Select Granular Borrow",2,70,null,null,1978,5.29,35,660,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"3 ST","58TH AVE","59TH AVE","58TH AVE to 59TH AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",89,"2011-10-01",79.650000000000006,"2014-10-07"]
[8,"3 ST","470' N 59TH AVE","60TH AVE","470' N 59TH AVE to 60TH AVE",800,42.32,"Asphalt",3,"Mn/DOT Class 5",2,"Select Granular Borrow",2,70,null,null,1978,5.29,35,190,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"3 ST","470' N 59TH AVE","60TH AVE","470' N 59TH AVE to 60TH AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,78,"2011-10-01",70.2,"2014-10-07"]
[9,"3 ST","57TH AVE","57TH PLACE","57TH AVE to 57TH PLACE",1200,63.48,"Asphalt",3,"Mn/DOT Class 6",4,"Select Granular Borrow",2,70,null,null,1966,5.29,39,211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"3 ST","57TH AVE","57TH PLACE","57TH AVE to 57TH PLACE",null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",95,"2011-10-01",81,"2014-10-07"]
[10,"3 ST","57TH PLACE","58TH AVE","57TH PLACE to 58TH AVE",800,42.32,"Asphalt",3.5,"Mn/DOT Class 5",6,"Select Granular Borrow",2,70,null,null,2006,5.29,40,502,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"3 ST","57TH PLACE","58TH AVE","57TH PLACE to 58TH AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",95,"2011-10-01",78.300000000000011,"2014-10-07"]
[11,"3 ST","59TH AVE","470' N 59TH AVE","59TH AVE to 470' N 59TH AVE",800,42.32,"Asphalt",3.5,"Mn/DOT Class 5",6,"Select Granular Borrow",2,70,null,null,2006,5.29,35,470,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"3 ST","59TH AVE","470' N 59TH AVE","59TH AVE to 470' N 59TH AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",85,"2011-10-01",91.800000000000011,"2014-10-07"]
[12,"3a ST","59TH AVE","470' N 59TH AVE","59TH AVE to 470' N 59TH AVE",800,42.32,"Asphalt",3.5,"Mn/DOT Class 5",6,"Select Granular Borrow",2,30,null,null,2006,5.29,35,470,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",85,"2011-10-01",91.800000000000011,"2014-10-07"]
[13,"3b ST","59TH AVE","470' N 59TH AVE","59TH AVE to 470' N 59TH AVE",800,42.32,"Asphalt",3.5,"Mn/DOT Class 5",6,"Select Granular Borrow",2,10,null,null,2006,5.29,35,470,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",85,"2011-10-01",91.800000000000011,"2014-10-07"]

{"sheet":"DataSorting","index":2,"n_rows":22,"n_cols":64,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["New Sorted Unique List",null,"#listed, colA",{"$f":"COUNTA(A1:A100000)","v":4},null,null,null,null,null,"Criteria range for street selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After Street is Selected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After Segment is Selected"]
["3 ST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Sorted Unique List",null,null,"ADT",null,null,"Base Type","Base Thickness, in","Subgrade R Value","Recent PCI","Recent SR","Recent Other CI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Sorted Unique List",null,null,"ADT",null,null,"Base Type","Base Thickness, in","Subgrade R Value","Recent PCI","Recent SR","Recent Other CI"]
["3a ST",null,null,null,null,null,null,null,null,"Name"]
["3b ST",null,null,null,null,null,null,null,null,"=3 ST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Criteria Range for segment selection"]
[]
[null,null,null,null,null,null,null,null,null,"Name","From","To"]
[null,null,null,null,null,null,null,null,null,"=3 ST","=60TH AVE","=61ST AVE"]

{"sheet":"Report-Segment","index":3,"n_rows":84,"n_cols":426,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,2,2,10],[3,2,3,10],[7,9,8,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PSI",null,"PSI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Most Recent Segment Analysis",null,null,null,null,null,null,"Predicted PCI Since Last Reconstruction"]
[null,null,"Heavy Vehicle Impacts Tool",null,null,null,null,null,null,null,null,null,"Year","ESALs without Additional Heavy Vehicles","PCI Without Additional Heavy Vehicles","ESALs With Additional Heavy Vehicles","PCI With Additional Heavy Vehicles",null,null,null,"Year","ESALs","Without Additional Heavy Vehicles","With Additional Heavy Vehicles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI-Date Regression"]
[null,null,"Individual Segment Analysis Report",null,null,null,null,null,null,null,null,null,0,0,97.9998779296875,0,97.9998779296875,null,null,null,null,null,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,1,9002.0673828125,97.991172790527344,9310.474609375,97.990081787109375,null,null,null,null,null,100,99]
[null,null,null,null,null,null,null,null,null,null,null,null,2,18094.15625,97.873519897460938,18714.0546875,97.854690551757813,null,null,null,null,null,99,97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI","PCI-date","PCI-Date-Serial Number",null,null,"Age","Modeled PCI",null,"(act-model)^2"]
[null,null,"Analysis Name","NewAnalysis2",null,null,"Heavy Vehicles Included in this Analysis",null,null,null,null,null,3,27277.166015625,97.329666137695313,28211.669921875,97.232032775878906,null,null,null,null,null,98,94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",{"$f":"PC7","v":"2008-10-01"},null,null,{"$f":"(PD7-$PD$11)/365.25","v":2.1711156741957565},{"$f":"IF(PG7<>\"\",$PC$15+$PC$16*EXP(-(($PC$17/PG7)^$PC$18)),NA())","v":95.002899942923094},null,{"$f":"(PB7-PH7)^2","v":8.4096689572005961E-6}]
[null,null,"Segment Name","3 ST",null,null,null,null,null,"Vehicles per Week",null,null,4,36552.00390625,95.925559997558594,37804.26171875,95.645683288574219,null,null,null,null,null,96,92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2011-10-01",{"$f":"PC8","v":"2011-10-01"},null,null,{"$f":"(PD8-$PD$11)/365.25","v":5.1690622861054072},{"$f":"IF(PG8<>\"\",$PC$15+$PC$16*EXP(-(($PC$17/PG8)^$PC$18)),NA())","v":94.997095379591855},null,{"$f":"(PB8-PH8)^2","v":8.4368197154142837E-6}]
[null,null,"From / To","60TH AVE to 61ST AVE",null,null,null,"Vehicle",null,null,"Full / Empty",null,5,45919.58984375,93.338340759277344,47492.77734375,92.765495300292969,null,null,null,null,null,94,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,"2014-10-07",{"$f":"PC9","v":"2014-10-07"},null,null,8.1861738535249824,{"$f":"IF(PG9<>\"\",$PC$15+$PC$16*EXP(-(($PC$17/PG9)^$PC$18)),NA())","v":77.999548599559759},null,{"$f":"(PB9-PH9)^2","v":2.037623574497194E-7}]
[null,null,"Segment Length, ft",660,null,null,null,"W5 - Waste - Side Load",null,4,"1/2 Full",null,6,55380.8515625,89.460823059082031,57278.1796875,88.508560180664063,null,null,null,null,null,92,82]
[null,null,"Segment Length, mi",0.13,null,null,null,null,null,null,null,null,7,64936.7265625,84.371391296386719,67161.4375,82.990196228027344,null,null,null,null,null,90,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Recon",2006,{"$f":"TEXT(\"7/31/\"&PC11,\"0\")","v":"38929"},"(31 July of reconstruct year)",null,null,null,"sum",{"$f":"SUM(PJ7:PJ9)","v":1.7050251030064599E-5}]
[null,null,null,null,null,null,null,null,null,null,null,null,8,74588.1640625,78.257400512695312,77143.5234375,76.432891845703125,null,null,null,null,null,88,70]
[null,null,"Percent Life Consumed",17,null,null,null,null,null,null,null,null,9,84336.109375,71.347587585449219,87225.4375,69.092208862304688,null,null,null,null,null,86,63]
[null,null,"Total Segment Consumed Life Cost",6190,null,null,null,null,null,null,null,null,10,94181.5390625,63.868450164794922,97408.1640625,61.212387084960938,null,null,null,null,null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regression Factors"]
[null,null,null,null,null,null,null,null,null,null,null,null,11,104125.421875,56.0218505859375,107692.71875,53.005264282226563,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",95.002899942923094]
[null,null,"Additional Asphalt Thickness","0.0 in.",null,null,null,null,null,null,null,null,12,114168.7421875,47.976470947265625,118080.1171875,44.643779754638672,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",-683.55274042345172]
[null,null,"Total Additional Asphalt Cost",177,null,null,null,null,null,null,null,null,13,124312.5,39.867176055908203,128571.390625,36.263278961181641,null,null,null,null,null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",13.79680504543979]
[null,null,null,null,null,null,null,null,null,null,null,null,14,134557.6875,31.798168182373047,139167.578125,27.966066360473633,null,null,null,null,null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",2.5032662153042913]
[null,null,null,null,null,null,null,null,null,null,null,null,15,144905.328125,23.847539901733398,149869.734375,19.827018737792969]
[null,null,"Insufficient or invalid historical PCI data.  A default curve is used.",null,null,null,null,null,null,null,null,null,16,155356.453125,16.072044372558594,160678.90625,11.899087905883789]
[null,null,null,null,null,null,null,null,null,null,null,null,17,165912.078125,8.5114355087280273,171596.171875,4.2180094718933105]
[null,null,null,null,null,null,null,null,null,null,null,null,18,176573.265625,1.1921979188919067,182622.609375]
[null,null,null,null,null,null,null,null,null,null,null,null,19,187341.0625,null,193759.3125]
[null,null,null,null,null,null,null,null,null,null,null,null,20,198216.546875,null,205007.375]
[null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,"Heavy Vehicle Impacts Tool",null,null,null,null,null,null,null,"Analysis Date: 8 Dec 2014",null,49]
[null,null,{"$f":"\"Version \" & 'Main Tool'!D7","v":"Version 1.04"},null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,null,null,null,68]
[null,null,null,null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,null,80]

{"sheet":"Report-Network","index":4,"n_rows":59,"n_cols":426,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,2,2,10],[3,2,3,10],[7,9,8,9],[5,15,5,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Averages",{"$f":"AVERAGE(S8:OFFSET($S$8,Y1,0))","v":18.000000000000004},{"$f":"AVERAGE(T8:OFFSET($T$8,Y1,0))","v":5208.2346153846156},{"$f":"AVERAGE(U8:OFFSET($U$8,Y1,0))","v":3.0769230769230771E-2},{"$f":"AVERAGE(V8:OFFSET($V$8,Y1,0))","v":618.86692307692306},null,"Num Results",{"$f":"COUNT(S8:S20)","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Network Report",null,"Totals",null,{"$f":"SUM(T8:OFFSET($T$8,Y1,0))","v":67707.05},null,{"$f":"SUM(V8:OFFSET($V$8,Y1,0))","v":8045.27}]
[null,null,"Heavy Vehicle Impacts Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI-Date Regression"]
[null,null," Network Analysis Report",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y1","v":13},"Count of PSI values",null,null,null,null,null,null,null,null,null,"Distributions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add'l Bit Thickness",null,null,null,"Percent Life Consumed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI in 10 Years",null,null,null,null,null,null,null,null,null,"Thickness","Number","Percent",null,null,"Number","Percent",null,null,null,null,null,null,null,null,null,null,null,null,"ESAL over time - Without",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI over time - Without",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESAL over time - With",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PSI over time - With",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI","PCI-date","PCI-Date-Serial Number",null,null,"Age","Modeled PCI",null,"(act-model)^2"]
[null,null,"Analysis Name","NewAnalysis2",null,null,"Heavy Vehicles Included in this Analysis",null,null,null,null,null,null,null,"Segment ID","Without Additional","With Additional","Additional PCI Loss","% life over design","% Life Cost, $/lane mile","Additional Bit","Additional Bit. Cost","lane miles",null,null,"0.0-1.0",{"$f":"COUNTIF($U$8:OFFSET($U$8,Y1,0),\"<=1\")","v":13},{"$f":"AA7/$Y$1","v":1},null,"0-25",{"$f":"COUNTIF(S8:OFFSET($S$8,Y1,0),\"<=25\")","v":10},{"$f":"AE7/$Y$1","v":0.76923076923076927},null,null,null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,"2008-10-01",{"$f":"PC7","v":"2008-10-01"},null,null,{"$f":"(PD7-$PD$11)/365.25","v":2.1711156741957565},{"$f":"IF(PG7<>\"\",$PC$15+$PC$16*EXP(-(($PC$17/PG7)^$PC$18)),NA())","v":90.666667172993286},null,{"$f":"(PB7-PH7)^2","v":18.777773389614001}]
[null,null,"Number of Segments Analyzed",13,null,null,null,null,null,"Vehicles per Week",null,null,null,null,1,0,0,{"$f":"P8-Q8","v":0},0.9,267.36,0.1,531.19000000000005,0.3125,null,null,"1.0-2.0",{"$f":"COUNTIFS($U$8:OFFSET($U$8,Y1,0),\">1\",$U$8:OFFSET($U$8,Y1,0),\"<=2.0\")","v":0},{"$f":"AA8/$Y$1","v":0},null,"25-50",{"$f":"COUNTIFS(S8:OFFSET($S$8,Y1,0),\">25\",S8:OFFSET($S$8,Y1,0),\"<=50\")","v":0},{"$f":"AE8/$Y$1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,9594,19284,29071,38956,48940,59023,69207,79493,89882,100375,110973,121677,132488,143407,154435,165573,176823,188185,199661,211252,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.061851501464844,82.774726867675781,71.880577087402344,58.0706787109375,42.261295318603516,25.309894561767578,7.9046149253845215,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9902,19903,30004,40206,50510,60918,71430,82047,92770,103600,114538,125586,136744,148014,159397,170893,182504,194231,206076,218039,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.061851501464844,82.478591918945313,71.072158813476563,56.620872497558594,40.133136749267578,22.53338623046875,4.5448188781738281,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,"2011-10-01",{"$f":"PC8","v":"2011-10-01"},null,null,{"$f":"(PD8-$PD$11)/365.25","v":5.1690622861054072},{"$f":"IF(PG8<>\"\",$PC$15+$PC$16*EXP(-(($PC$17/PG8)^$PC$18)),NA())","v":90.666667172993286},null,{"$f":"(PB8-PH8)^2","v":32.111116849479721}]
[null,null,"Number of Segments in Database",13,null,null,null,"Vehicle",null,null,"Full / Empty",null,null,null,2,0,0,{"$f":"P9-Q9","v":0},0.9,283.02,0,224.92,0.33080807328224182,null,null,"2.0-3.0",{"$f":"COUNTIFS($U$8:OFFSET($U$8,Y1,0),\">2.0\",$U$8:OFFSET($U$8,Y1,0),\"<=3.0\")","v":0},0,null,"50-75",{"$f":"COUNTIFS(S8:OFFSET($S$8,Y1,0),\">50\",S8:OFFSET($S$8,Y1,0),\"<=75\")","v":3},0.23076923076923078,null,null,null,null,null,null,null,null,null,null,null,null,15330,30813,46451,62246,78198,94310,110583,127019,143619,160385,177319,194422,211696,229143,246764,264562,282538,300693,319030,337550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23.847539901733398,16.072044372558594,8.5114355087280273,1.1921979188919067,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15638,31433,47386,63498,79771,96207,112807,129573,146507,163610,180885,198332,215954,233752,251728,269884,288221,306742,325448,344341,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23.847539901733398,15.91791820526123,8.2120904922485352,0.75834721326828003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,"2014-10-07",{"$f":"PC9","v":"2014-10-07"},null,null,8.1861738535249824,{"$f":"IF(PG9<>\"\",$PC$15+$PC$16*EXP(-(($PC$17/PG9)^$PC$18)),NA())","v":90.66666717019902},null,{"$f":"(PB9-PH9)^2","v":1.77777643502509}]
[null,null,null,null,null,null,null,"W5 - Waste - Side Load",null,4,"1/2 Full",null,null,null,3,63.868450164794922,61.218475341796875,2.6499748229980469,67.900000000000006,24758.23,0,495.01,0.3645833432674408,null,null,">3.0",{"$f":"COUNTIF($U$8:OFFSET($U$8,Y1,0),\">3.0\")","v":0},0,null,"75-100",{"$f":"COUNTIFS(S8:OFFSET($S$8,Y1,0),\">75\",S8:OFFSET($S$8,Y1,0),\"<=100\")","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97.9998779296875,97.991172790527344,97.873519897460938,97.329666137695313,95.925559997558594,93.338340759277344,89.460823059082031,84.371391296386719,78.257400512695312,71.347587585449219,63.868450164794922,56.0218505859375,47.976470947265625,39.867176055908203,31.798168182373047,23.847539901733398,16.072044372558594,8.5114355087280273,1.1921979188919067,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97.9998779296875,97.990089416503906,97.854728698730469,97.232192993164063,95.6461181640625,92.76641845703125,88.510238647460938,82.992942810058594,76.43701171875,69.097213745117188,61.218475341796875,53.012668609619141,44.651042938232422,36.270675659179688,27.973939895629883,19.834873199462891,11.907296180725098,4.2269439697265625,0,0,0]
[null,null,"Average Percent of Life Consumed",{"$f":"ROUND(S1,1) & \"%\"","v":"18%"},null,null,null,null,null,null,null,null,null,null,4,52.919677734375,52.919677734375,0,2.4,2576.94,0.1,1854.48,1.0909880399703979,null,null,null,null,null,null,">100",{"$f":"COUNTIF(S8:OFFSET($S$8,Y1,0),\">100\")","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,9594,19284,29071,38956,48940,59023,69207,79493,89882,100375,110973,121677,132488,143407,154435,165573,176823,188185,199661,211252,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52.922210693359375,52.920299530029297,52.919834136962891,52.919719696044922,52.919689178466797,52.919681549072266,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9902,19903,30004,40206,50510,60918,71430,82047,92770,103600,114538,125586,136744,148014,159397,170893,182504,194231,206076,218039,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52.922210693359375,52.920272827148437,52.919822692871094,52.919712066650391,52.919685363769531,52.919681549072266,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,52.919677734375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Recon",2006,{"$f":"TEXT(\"7/31/\"&PC11,\"0\")","v":"38929"},"(31 July of reconstruct year)",null,null,null,"sum",{"$f":"SUM(PJ7:PJ9)","v":52.666666674118815}]
[null,null,"Total Network Cost of Consumed Life",{"$f":"T2","v":67707.05},null,null,null,null,null,null,null,null,null,null,5,53.488037109375,53.488037109375,0,1.2,1028.9100000000001,0,1131.46,0.83333331346511841,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53.48809814453125,53.488044738769531,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53.48809814453125,53.488044738769531,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375,53.488037109375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,27.103008270263672,26.928155899047852,0.17485237121582031,1.2,1028.9100000000001,0,1131.46,0.83333331346511841,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40.515636444091797,37.925319671630859,35.758392333984375,33.941505432128906,32.414402008056641,31.127595901489258,30.04045295715332,29.119583129882813,28.337497711181641,27.671545028686523,27.103008270263672,26.616397857666016,26.198863983154297,25.839717864990234,25.530054092407227,25.262424468994141,25.03059196472168,24.829320907592773,24.654201507568359,24.501508712768555,24.368097305297852,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40.515636444091797,37.844810485839844,35.623737335205078,33.772369384765625,32.225124359130859,30.928512573242188,29.838907241821289,28.920680999755859,28.144699096679687,27.487030029296875,26.928155899047852,26.451948165893555,26.045015335083008,25.696449279785156,25.397119522094727,25.139400482177734,24.916996002197266,24.724613189697266,24.55780029296875,24.412834167480469,24.286581039428711]
[null,null,"Average Additional Asphalt Thickness",{"$f":"ROUND(U1,1) & \" in.\"","v":"0 in."},null,null,null,null,null,null,null,null,null,null,7,26.104801177978516,23.482982635498047,2.6218185424804687,67.900000000000006,24758.23,0,495.01,0.3645833432674408,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80.656791687011719,77.033805847167969,73.029891967773438,68.632583618164063,63.830928802490234,58.615520477294922,52.978443145751953,46.913230895996094,40.414825439453125,33.479499816894531,26.104801177978516,18.289470672607422,10.033384323120117,1.3374619483947754,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80.656791687011719,76.903457641601562,72.741836547851562,68.15863037109375,63.141902923583984,57.681491851806641,51.768936157226563,45.397430419921875,38.561775207519531,31.257474899291992,23.482982635498047,15.237407684326172,6.5192699432373047,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regression Factors"]
[null,null,"Total Network Cost of Additional Asphalt",{"$f":"V2","v":8045.27},null,null,null,null,null,null,null,null,null,null,8,0,0,0,67.900000000000006,7127.37,0,142.5,0.10495580732822418,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-78.842231750488281,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-78.842231750488281,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",90.666667172993286]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,0,2.4,306.77,0,139.66999999999999,0.12987689673900604,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13505,27145,40921,54835,68888,83082,97418,111897,126521,141291,156209,171276,186494,201864,217388,233067,248903,264897,281051,297367,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83.774711608886719,62.021781921386719,18.881696701049805,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13813,27765,41856,56088,70462,84980,99643,114453,129411,144519,159778,175189,190754,206475,222353,238390,254587,270946,287469,304157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83.774711608886719,61.304737091064453,16.292087554931641,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",-212.70231589577568]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,0,0.9,271.14,0,430.3,0.31691917777061462,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.534934997558594,55.881591796875,14.181037902832031,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.534934997558594,54.712604522705078,10.814775466918945,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",45.69121514038541]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,89.973411560058594,89.821372985839844,0.15203857421875,0.9,222.12,0,352.51,0.25962752103805542,null,"AT 5 YEARS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.666664123535156,90.666664123535156,90.666656494140625,90.666549682617188,90.665634155273437,90.6610107421875,90.644500732421875,90.599296569824219,90.498039245605469,90.303726196289062,89.973411560058594,89.463180541992188,88.73321533203125,87.751609802246094,86.49664306640625,84.957435607910156,83.1334228515625,81.032997131347656,78.671745300292969,76.070571899414063,73.253952026367188,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.666664123535156,90.666664123535156,90.666656494140625,90.666511535644531,90.665336608886719,90.65936279296875,90.6383056640625,90.581413269042969,90.455886840820313,90.218658447265625,89.821372985839844,89.216461181640625,88.362457275390625,87.228469848632813,85.795639038085938,84.057167053222656,82.017745971679688,79.691162109375,77.097999572753906,74.263923645019531,71.217597961425781,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",1.87331951071172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,89.973411560058594,89.821372985839844,0.15203857421875,2,528.15,0.1,494.2,0.25962752103805542,null,null,"Final Condition Rating - Without",null,null,null,"Final Condition Rating - With",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.666664123535156,90.666664123535156,90.666656494140625,90.666549682617188,90.665634155273437,90.6610107421875,90.644500732421875,90.599296569824219,90.498039245605469,90.303726196289062,89.973411560058594,89.463180541992188,88.73321533203125,87.751609802246094,86.49664306640625,84.957435607910156,83.1334228515625,81.032997131347656,78.671745300292969,76.070571899414063,73.253952026367188,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.666664123535156,90.666664123535156,90.666656494140625,90.666511535644531,90.665336608886719,90.65936279296875,90.6383056640625,90.581413269042969,90.455886840820313,90.218658447265625,89.821372985839844,89.216461181640625,88.362457275390625,87.228469848632813,85.795639038085938,84.057167053222656,82.017745971679688,79.691162109375,77.097999572753906,74.263923645019531,71.217597961425781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,89.973411560058594,89.821372985839844,0.15203857421875,17.5,4549.8999999999996,0.1,622.55999999999995,0.25962752103805542,null,null,null,"Number","Percent",null,null,"Number","Percent",null,null,null,null,null,null,null,null,null,null,null,null,9021,18132,27334,36628,46015,55496,65072,74744,84512,94378,104343,114407,124572,134839,145208,155681,166259,176943,187733,198631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.666664123535156,90.666664123535156,90.666656494140625,90.666549682617188,90.665634155273437,90.6610107421875,90.644500732421875,90.599296569824219,90.498039245605469,90.303726196289062,89.973411560058594,89.463180541992188,88.73321533203125,87.751609802246094,86.49664306640625,84.957435607910156,83.1334228515625,81.032997131347656,78.671745300292969,76.070571899414063,73.253952026367188,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9329,18752,28269,37881,47589,57394,67297,77299,87401,97604,107909,118318,128831,139449,150173,161004,171943,182992,194151,205422,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90.666664123535156,90.666664123535156,90.666656494140625,90.666511535644531,90.665336608886719,90.65936279296875,90.6383056640625,90.581413269042969,90.455886840820313,90.218658447265625,89.821372985839844,89.216461181640625,88.362457275390625,87.228469848632813,85.795639038085938,84.057167053222656,82.017745971679688,79.691162109375,77.097999572753906,74.263923645019531,71.217597961425781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-30","< 2.0",{"$f":"COUNTIF($EA$8:OFFSET($EA$8,Y1,0),\"<=30\")","v":5},{"$f":"AA21/$Y$1","v":0.38461538461538464},null,"< 2.0",{"$f":"COUNTIF($KG$8:OFFSET($KG$8,Y1,0),\"<=30\")","v":5},{"$f":"AE21/$Y$1","v":0.38461538461538464}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-50","2.0-2.5",{"$f":"COUNTIFS($EA$8:OFFSET($EA$8,Y1,0),\">30\",$EA$8:OFFSET($EA$8,Y1,0),\"<=50\")","v":1},{"$f":"AA22/$Y$1","v":7.6923076923076927E-2},null,"2.0-2.5",{"$f":"COUNTIFS($KG$8:OFFSET($KG$8,Y1,0),\">30\",$KG$8:OFFSET($KG$8,Y1,0),\"<=50\")","v":1},{"$f":"AE22/$Y$1","v":7.6923076923076927E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50-70","2.5-3.0",{"$f":"COUNTIFS($EA$8:OFFSET($EA$8,Y1,0),\">50\",$EA$8:OFFSET($EA$8,Y1,0),\"<=70\")","v":3},0.23076923076923078,null,"2.5-3.0",{"$f":"COUNTIFS($KG$8:OFFSET($KG$8,Y1,0),\">50\",$KG$8:OFFSET($KG$8,Y1,0),\"<=70\")","v":3},0.23076923076923078]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70-80","3.0-3.5",{"$f":"COUNTIFS($EA$8:OFFSET($EA$8,Y1,0),\">70\",$EA$8:OFFSET($EA$8,Y1,0),\"<=80\")","v":0},0,null,"3.0-3.5",{"$f":"COUNTIFS($KG$8:OFFSET($KG$8,Y1,0),\">70\",$KG$8:OFFSET($KG$8,Y1,0),\"<=80\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80-90","3.5-4.0",{"$f":"COUNTIFS($EA$8:OFFSET($EA$8,Y1,0),\">80\",$EA$8:OFFSET($EA$8,Y1,0),\"<=90\")","v":0},0,null,"3.5-4.0",{"$f":"COUNTIFS($KG$8:OFFSET($KG$8,Y1,0),\">80\",$KG$8:OFFSET($KG$8,Y1,0),\"<=90\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90-100",">4.0",{"$f":"COUNTIF($EA$8:OFFSET($EA$8,Y1,0),\">90\")","v":4},0.30769230769230771,null,">4.0",{"$f":"COUNTIF($KG$8:OFFSET($KG$8,Y1,0),\">90\")","v":4},0.30769230769230771]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AT 10 YEARS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final Condition Rating - Without",null,null,null,"Final Condition Rating - With"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number","Percent",null,null,"Number","Percent"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-30","< 2.0",{"$f":"COUNTIF($EF$8:OFFSET($EF$8,Y1,0),\"<=30\")","v":7},{"$f":"AA35/$Y$1","v":0.53846153846153844},null,"< 2.0",{"$f":"COUNTIF($KL$8:OFFSET($KL$8,Y1,0),\"<=30\")","v":7},{"$f":"AE35/$Y$1","v":0.53846153846153844}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-50","2.0-2.5",{"$f":"COUNTIFS($EF$8:OFFSET($EF$8,Y1,0),\">30\",$EF$8:OFFSET($EF$8,Y1,0),\"<=50\")","v":0},{"$f":"AA36/$Y$1","v":0},null,"2.0-2.5",{"$f":"COUNTIFS($KL$8:OFFSET($KL$8,Y1,0),\">30\",$KL$8:OFFSET($KL$8,Y1,0),\"<=50\")","v":0},{"$f":"AE36/$Y$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50-70","2.5-3.0",{"$f":"COUNTIFS($EF$8:OFFSET($EF$8,Y1,0),\">50\",$EF$8:OFFSET($EF$8,Y1,0),\"<=70\")","v":3},0.23076923076923078,null,"2.5-3.0",{"$f":"COUNTIFS($KL$8:OFFSET($KL$8,Y1,0),\">50\",$KL$8:OFFSET($KL$8,Y1,0),\"<=70\")","v":3},0.23076923076923078]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70-80","3.0-3.5",{"$f":"COUNTIFS($EF$8:OFFSET($EF$8,Y1,0),\">70\",$EF$8:OFFSET($EF$8,Y1,0),\"<=80\")","v":0},0,null,"3.0-3.5",{"$f":"COUNTIFS($KL$8:OFFSET($KL$8,Y1,0),\">70\",$KL$8:OFFSET($KL$8,Y1,0),\"<=80\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80-90","3.5-4.0",{"$f":"COUNTIFS($EF$8:OFFSET($EF$8,Y1,0),\">80\",$EF$8:OFFSET($EF$8,Y1,0),\"<=90\")","v":3},0.23076923076923078,null,"3.5-4.0",{"$f":"COUNTIFS($KL$8:OFFSET($KL$8,Y1,0),\">80\",$KL$8:OFFSET($KL$8,Y1,0),\"<=90\")","v":3},0.23076923076923078]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90-100",">4.0",{"$f":"COUNTIF($EF$8:OFFSET($EF$8,Y1,0),\">90\")","v":0},0,null,">4.0",{"$f":"COUNTIF($KL$8:OFFSET($KL$8,Y1,0),\">90\")","v":0},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Heavy Vehicle Impacts Tool",null,null,null,null,null,null,null,"Analysis Date:  23 Jan 2015"]
[null,null,{"$f":"\"Version \" & 'Main Tool'!D7","v":"Version 1.04"}]

{"sheet":"User Guide","index":5,"n_rows":109,"n_cols":6,"rows_kept":109,"cut":false,"hidden":false,"merged":[[1,1,1,12],[2,1,2,12]]}
[]
[null,{"$f":"\"Heavy Vehicles Impacts Tool, Version \" & 'Main Tool'!D7","v":"Heavy Vehicles Impacts Tool, Version 1.04"}]
[null,{"$f":"\"Released \" & TEXT('Main Tool'!D8,\"mmm yyyy\")","v":"Released Dec 2014"}]
[]
[]
[null,"User Guide"]
[]
[null,"1.  There are no user settings or inputs accessible in the spreadsheet itself.  "]
[null,null,"a.","To change inputs or settings, press the \"Launch…\" button and use the user interface that opens."]
[]
[null,"2.  User-Defined Settings"]
[null,null,"a.       ","Click on the “Settings” button to access user-defined settings"]
[null,null,"b.      ","Select startup behavior:  Load the previous analysis on startup, or begin with a blank analysis"]
[null,null,"c.        ","Press “Cancel” to exit without saving the settings changes, or “OK” to save the changes and exit"]
[]
[null,"3.  User Inputs"]
[null,null,"a.       ","Cost and Other Information"]
[null,null,null,null,"Click “Cost and Other Information” to access this area."]
[null,null,null,null,"Enter construction cost information, minimum overlay thickness desired, traffic growth rate, etc."]
[null,null,null,null,"Press “Cancel” to exit without saving the changes, or “OK” to save and exit"]
[null,null,"b.      ","Analysis Vehicles"]
[null,null,null,null,"Select the interval desired: “Additional vehicles per…” (Day, Week, Month, Season, Year)"]
[null,null,null,null,"Select up to nine vehicle types.  Duplicates are accepted"]
[null,null,null,null,"For each vehicle, enter the number expected per chosen interval"]
[null,null,null,null,"Also for each vehicle, indicate whether they are to be modeled as Full, ½ Full, or Empty"]
[null,null,"c.       ","To review vehicle types and axle configurations, click “Review Vehicle Types”"]
[null,null,null,null,"Select the vehicle type to review by clicking in the list"]
[null,null,null,null,"End by pressing “Close”"]
[null,null,"d.      ","To enter a custom vehicle types configuration, click “Define Custom Vehicles”"]
[null,null,null,null,"To review characteristics of a previously defined vehicle, select from the list"]
[null,null,null,null,"To create a new vehicle definition:"]
[null,null,null,null,null,"Select “Create New Vehicle” from the list"]
[null,null,null,null,null,"Enter axle load and configurations (once the data has been changed, the “Save As…” button will become active."]
[null,null,null,null,null,"After pressing “Save As…”, enter a name for the vehicle and press “OK”"]
[null,null,null,null,null,"Pressing “Cancel” will return to the custom vehicle data entry without saving the information"]
[null,null,null,null,null,"Press “Close” to exit the custom vehicle data entry"]
[null,null,null,null,"To delete a custom vehicle:"]
[null,null,null,null,null,"Select a vehicle to delete"]
[null,null,null,null,null,"Press “Delete Selected” – This is not reversible!"]
[null,null,"e.       ","Selecting a Street Segment"]
[null,null,null,null,"To select a specific street segment, for the “Street Segment Level” analysis select the Street Name first."]
[null,null,null,null,"Select a specific Segment from the drop-down menu"]
[null,null,null,null,"To view or modify the street inventory data"]
[null,null,null,null,null,"Press “View/Enter Data”"]
[null,null,null,null,null,"View or change information for surface, base, and subbase thickness and type"]
[null,null,null,null,null,"View or change information for subgrade R-Value, year of last reconstruction, ADT, HCADT, and % Trucks, if available"]
[null,null,null,null,null,"View or change information for current condition, PCI or SR values, if available."]
[null,null,null,null,null,"Press “Cancel” to exit without saving the changes, or “OK” to save and exit"]
[null,null,null,null,null,"Select to “Use Database Values” or “Use Custom Values”"]
[]
[null,"4. Network vs. Segment Level Analysis"]
[null,null,"a.       ","Choose the type of analysis to conduct – street segment level or Network Level"]
[null,null,null,null,"Network level analysis applies the “Analysis Vehicles” to every street segment in the network, provided that they have enough information to conduct the analysis."]
[null,null,null,null,"Street Segment Level analysis applies the “Analysis Vehicles” to the single segment, but provides more detailed information in the analysis results"]
[]
[null,"5.  Importing a Street Network"]
[null,null,"a.       ","Press “Load/Update Street Network”"]
[null,null,"b.      ","Select the spreadsheet file to import from the File Open box"]
[null,null,"c.      ","If the import routine recognizes the spreadsheet file to contain pavement network information, it will open a window called “Heavy Vehicle Impacts Tool – Database Import”"]
[null,null,"d.      ","Select if the data has column headers or not"]
[null,null,null,null,"The import routine assumes that the data starts on Row 1 if there are no headers, and Row 2 if there are headers"]
[null,null,"e.       ","Choose to preserve current / existing data"]
[null,null,null,null,"If this is checked, the import routine will import only data for new roadway segments"]
[null,null,"f.      ","Align the columns with the required information.  For example, if the first column is not “Segment Name” in the imported data, select the appropriate column in the drop down box."]
[null,null,"g.     ","If the first column contains the segment name, but it is called by a different column heading, choose that header to associate it with “Segment Name”"]
[null,null,null,null,"There is no way to check and make sure that the columns are lined up correctly.  If the import causes errors, try importing again and selecting the proper columns"]
[null,null,"h.      ","Once all available columns are matched with a corresponding data type, press “Import”"]
[null,null,"i.        ","Press “Cancel at any time to return to the main tool without importing any data."]
[]
[null,"6.  Conducting an Analysis"]
[null,null,"a.       ","Press “Analyze and Report”"]
[null,null,"b.      ","Depending on the type of analysis selected, the “Segment Analysis and Report” or “Network Analysis and Report” window will appear"]
[null,null,"c.       ","Computations are shown for “Consumed Life” and “Design”.  "]
[null,null,"d.     ","“Consumed Life” reports  (Street Segment Level)"]
[null,null,null,null,"Additional ESALs per year"]
[null,null,null,null,"Percent of life consumed over design period, %"]
[null,null,null,null,"Total cost of consumed life, $/lane mile"]
[null,null,null,null,"Total cost of consumed life, $/ESAL/lane mile"]
[null,null,null,null,"Total cost of consumed life for the entire segment"]
[null,null,"e.       ","“Consumed Life” reports  (Network Level)"]
[null,null,null,null,"Additional ESALs per year"]
[null,null,null,null,"Average percent of life consumed over design period, %"]
[null,null,null,null,"Network cost of consumed life, $/lane mile"]
[null,null,"f.       ","“Design” reports (Street Segment Level)"]
[null,null,null,null,"“Additional bituminous thickness that would be required at design to accommodate the additional heavy vehicles, inch”"]
[null,null,null,null,"“Cost of additional bituminous at construction, $/sy”"]
[null,null,null,null,"“Cost of additional thickness at construction” for the entire segment"]
[null,null,"g.       ","“Design” reports (Network Level)"]
[null,null,null,null,"“Average additional bituminous thickness required, inch”"]
[null,null,null,null,"“Network cost of additional bituminous at construction, $”"]
[null,null,"h.      ","From each report a detailed summary may be printed by pressing “Print Summary”"]
[null,null,null,null,"In order to print to a specific printer, select the appropriate printer as the “default printer” in the computer’s settings prior to pressing “Print Summary”"]
[]
[null,"7.  Miscellaneous Items"]
[null,null,"a.       ","Load a Saved Analysis"]
[null,null,null,null,"Analyses are saved within the spreadsheet, and not as individual files.  There is no need to specify a location.  All previously saved analyses appear in the drop-down box.  "]
[null,null,null,null,"Select one analysis in the drop-down box and press “OK”"]
[null,null,null,null,"Press “Cancel” to quit without loading a new analysis"]
[null,null,"b.      ","Save Current Analysis"]
[null,null,null,null,"By pressing “Save Current Analysis” the current analysis is updated in the spreadsheet records.  No additional action is needed by the user.   "]
[null,null,"c.       ","Save As New Analysis"]
[null,null,null,null,"To save the current analysis to a different name, press “Save As New Analysis”"]
[null,null,null,null,"The current analysis is saved as a new analysis with the specified name, and placed in the list of valid analyses that may be loaded at a later time.  A new analysis name may be entered, or the current analysis may overwrite an existing analysis by selecting one from the drop-down box."]
[]
[null,"8.  Technical Background"]
[null,null,"a.  ","Percent of Life Consumed Method"]
[null,null,null,null,"The portion of the original design life (in ESALs) that is consumed by the development."]
[null,null,"b.  ","Additional Asphalt Thickness Method"]
[null,null,null,null,"The additional bituminous layer thickness that would have been required at design, using the GE method, as a result of the additional heavy vehicles."]

{"sheet":"UserSettings","index":6,"n_rows":227,"n_cols":138,"rows_kept":227,"cut":false,"hidden":true,"merged":[[13,1,13,6],[102,68,102,78],[102,57,102,67]]}
[null,null,null,null,"Name",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Segment Analysis Settings",null,null,"Data to Use (Original = TRUE)",false,null,null,null,"If SegmentID = 0 it is a \"network analysis\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,2,"Number of Rows in file:",1169,null,"StartRow",2,null,null,null,null,null,null,null,null,"List of all segments with complete data",null,null,null,null,null,null,null,null,null,null,"TEMP-list of custom data to save"]
[null,null,null,null,"TRUE=Network",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment Info","Original",null,null,null,"NumSavedAnalyses",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data import Section",null,null,null,null,null,null,null,null,null,null,null,null,"segment id",null,null,null,null,"List of all segments with incomplete data",null,null,null,null,null,null,"1 = need to save"]
[null,null,null,null,"FALSE=Segment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saved Analyses","Analysis Name","Analysis Type (F=segment, T=network)","PMS Info (T=database F=modified)","Segment ID","Final PSI without","Final PSI with","Time Frame for Truck Entry","Type 1","Type 2","Type 3","Type 4","Type 5","Type 6","Type 7","Type 8","Type 9","NumPerPeriod1","NumPerPeriod2","NumPerPeriod3","NumPerPeriod4","NumPerPeriod5","NumPerPeriod6","NumPerPeriod7","NumPerPeriod8","NumPerPeriod9","Full1","Full2","Full3","Full4","Full5","Full6","Full7","Full8","Full9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H:\\FRID\\N15108348\\Pavement Rating\\Fridley Pavement\\ESAL Calculation Trial.xls",null,null,null,"Last imported file (attemped)","C:\\WJW\\Projects\\02-10-006-EffectOfGarbageHaulers\\SampleData.xlsx",null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,"ADT",null,null,null,null,null,null,null,"PCI-Date Regression"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"New Analysis",false,true,2,4.1863765716552734,4.1845555305480957,"Week","G1 - Front Load","R1 - Recycle","G2 - Front Load",null,null,null,null,null,null,6,3,4,null,null,null,null,null,null,true,true,true,true,true,true,true,true,true,null,null,null,null,null,null,null,null,null,null,null,null,"Default Values",null,"Box Number","columns in imported sheet",null,null,null,"Column Headers from import file","User Selected","Load into Form",null,"No Column Headers","Default Fields",null,"Destination Columns","Box Number",null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,"HCADT"]
[null,null,null,null,"Use Database Pavement Information",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"NewAnalysis2",true,true,3,2.5480186939239502,2.4386615753173828,"Week","W5 - Waste - Side Load",null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,true,true,true,true,true,true,true,true,null,null,null,null,null,null,null,null,null,null,null,"Surface Thickness",3,null,1,1,null,null,null,"Segment Name",1,"Name",null,"Column 1","Name",null,2,1,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,"SurfType"]
[null,null,null,null,"TRUE=Use database pavement information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Thickness",8,null,2,2,null,null,null,"From",2,"From",null,"Column 2","From",null,3,2,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,"SurfThix",null,null,null,null,null,null,null,null,"PCI","PCI-date","PCI-Date-Serial Number",null,null,"Age","Modeled PCI",null,"(act-model)^2"]
[null,null,null,null,"FALSE=Use custom values (load them if they already exist)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subbase Thickness",0,null,3,3,null,null,null,"To",3,"To",null,"Column 3","To",null,4,3,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,"BaseType",null,null,null,null,null,null,null,null,98,"2001-05-08",{"$f":"EA7","v":"2001-05-08"},null,null,{"$f":"(EB7-$EB$11)/365.25","v":1.7713894592744694},{"$f":"IF(EE7<>\"\",$EA$15+$EA$16*EXP(-(($EA$17/EE7)^$EA$18)),NA())","v":97.999947444472454},null,{"$f":"(DZ7-EF7)^2","v":2.7620834756284355E-9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R value",10,null,4,4,null,null,null,"ADT",4,"ADT",null,"Column 4","ADT",null,6,4,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,"BaseThix",null,null,null,null,null,null,null,null,86,"2009-04-13",{"$f":"EA8","v":"2009-04-13"},null,null,{"$f":"(EB8-$EB$11)/365.25","v":9.7029431895961675},85.999968168404862,null,{"$f":"(DZ8-EF8)^2","v":1.0132504489997847E-9}]
[null,null,null,null,"Automatically load last used analysis?",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,null,null,null,"HCADT",5,"HCADT",null,"Column 5","HCADT",null,7,5,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,"SubbaseType",null,null,null,null,null,null,null,null,64,"2012-07-24",{"$f":"EA9","v":"2012-07-24"},null,null,12.982888432580424,{"$f":"IF(EE9<>\"\",$EA$15+$EA$16*EXP(-(($EA$17/EE9)^$EA$18)),NA())","v":64.000047368026884},null,{"$f":"(DZ9-EF9)^2","v":2.2437299708821258E-9}]
[null,null,null,null,"Use Custom PCI Curve?",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,null,null,null,"Surface Type",8,"Surface Type",null,"Column 6","Surface Type",null,8,6,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"SubbaseThix"]
[null,null,null,null,"Current Analysis Name","NewAnalysis2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(AJ14:AJ100)","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,null,null,null,"Surface Thickness",9,"Surface Thickness",null,"Column 7","Surf Thick",null,9,7,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,"Subgrade R",null,null,null,null,null,null,null,null,"Last Recon",1999,{"$f":"TEXT(\"7/31/\"&EA11,\"0\")","v":"36372"},"(31 July of reconstruct year)",null,null,null,"sum",{"$f":"SUM(EH7:EH9)","v":6.0190638955103462E-9}]
[null,null,null,null,"Current Analysis Number",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include in lists?","Truck Label List",null,"Truck label list for comboboxes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,null,null,null,"Base Type",10,"Base Type",null,"Column 8","Base Type",null,10,8,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,"LastRecon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1=yes, 0=no",null,null,null,null,null,"Bus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,null,null,null,"Base Thickness",11,"Base Thickness",null,"Column 9","Base Thick",null,11,9,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,"PctTrucks",null,null,null,null,null,null,null,"Default Factors"]
[null,"Cost and other Top Level Info",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time Frames",null,null,null,null,1,"B1 - City Bus",null,"B1 - City Bus",null,null,"Delivery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,null,null,null,"Subbase Type",12,"Subbase Type",null,"Column 10","Subbase Type",null,12,10,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,"PCI1",null,null,null,null,null,null,null,null,"Regression Factors"]
[null,null,null,null,null,"Prepared by","City Engineer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day",null,null,null,null,1,"B2 - Short School Bus",null,"B2 - Short School Bus",null,null,"Grain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,11,null,null,null,"Subbase Thickness",13,"Subbase Thickness",null,"Column 11","Subbase Thick",null,13,11,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,"PCI2",null,null,null,null,null,null,null,null,"a",97.99994744448847]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Week",null,null,null,null,1,"B3 - Long School Bus",null,"B3 - Long School Bus",null,null,"Hauling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,12,null,null,null,"Subgrade R Value",6,"Subgrade R Value",null,"Column 12","R Value",null,14,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI3",null,null,null,null,null,null,null,null,"b",-317.27865646688116]
[null,null,null,null,null,"Cost of pavement surface reconstruction, $/lane mile",100000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month",null,null,null,null,1,"D1 - 2 Axle Delivery",null,"C1 - Front Load",null,null,"Waste/Recycling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,13,null,null,null,"Percent Trucks",14,"Recent PCI",null,"Column 13","Percent Trucks",null,18,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCIdate1",null,null,null,null,null,null,null,null,"c",23.92645591754691]
[null,null,null,null,null,"Cost of overlay, $/sy/inch",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Season",null,null,null,null,1,"D2 - 5 Axle Semi",null,"C4 - Wind Turbine Truck",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,14,null,null,null,"Yr of Last Recon",15,"Recent SR",null,"Column 14","Year of Last Reconstruction",null,17,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCIdate2",null,null,null,null,null,null,null,null,"d",1.3143566449263855]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year",null,null,null,null,1,"D3 - 3 Axle Semi + 2 Axle Trailer",null,"D1 - 2 Axle Delivery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,15,null,null,null,"Segment Width",7,"Year of Last Reconstruction",null,"Column 15","Segment Width",null,19,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCIdate3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"D4 - 4 Axle Semi + 2 Axle Trailer",null,"D2 - 5 Axle Semi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,16,null,null,null,"Segment Length",16,"Percent Trucks",null,"Column 16","Segment Length",null,20,16]
[null,null,null,null,null,"Minimum overlay thickness, in",1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G1 - Cattle Truck",null,"D3 - 3 Axle Semi + 2 Axle Trailer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,17,null,null,null,"1st PCI",17,"Segment Width",null,"Column 17","1st PCI",null,53,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Default Curve",null,null,null,null,"Custom Default Factors",null,null,null,null,null,null,null,1,{"$f":"IF(EG21<>\"\",$EA$15+$EA$16*EXP(-(($EA$17/EG21)^$EA$18)),NA())","v":97.99994744448847}]
[null,null,null,null,null,"Overlay thickness increment, in",0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Trucks - Axle Types",null,null,null,null,1,"G2 - 5 Axle Grain",null,"D4 - 4 Axle Semi + 2 Axle Trailer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,18,null,null,null,"1st PCI Date",18,"Segment Length",null,"Column 18","1st PCI Date",null,54,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI","Age at PCI",null,null,null,"Regression Factors",null,null,null,null,null,null,2,{"$f":"IF(EG22<>\"\",$EA$15+$EA$16*EXP(-(($EA$17/EG22)^$EA$18)),NA())","v":97.999947443024951}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Single, Single Axle",null,null,null,1,"G3 - 3 Axle Grain",null,"G1 - Cattle Truck",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,19,null,null,null,"2nd PCI",null,null,null,"Column 19","2nd PCI",null,55,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,1,null,null,null,"a",95.00146484375,null,null,null,null,null,3,97.999876896767063]
[null,null,null,null,null,"Standard Pavement Design Life, yrs",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Dual, Single Axle",null,null,null,1,"G4 - 3+ Axle Sugar Beet",null,"G2 - 5 Axle Grain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20,null,null,null,"2nd PCI Date",null,null,null,"Column 20","2nd PCI Date",null,56,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,5,null,null,null,"b",-198.47273254394531,null,null,null,null,null,4,97.991174127030888]
[null,null,null,null,null,"Growth Rate, %",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Dual, Tandem Axle",null,null,null,1,"H1 - Concrete Truck",null,"G3 - 3 Axle Grain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,21,null,null,null,"3rd PCI",null,null,null,"Column 21","3rd PCI",null,57,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,10,null,null,null,"c",26.204938888549805,null,null,null,null,null,5,97.87351689708656]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Dual Tandem with Tag Axle",null,null,null,1,"H2 - Tanker Truck",null,"G4 - 3+ Axle Sugar Beet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,22,null,null,null,"3rd PCI Date",null,null,null,"Column 22","3rd PCI Date",null,58,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",0.75597035884857178,null,null,null,null,null,6,97.329669752266867]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Tridem",null,null,null,1,"H3 - 2 Axle Dump",null,"H1 - Concrete Truck",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,95.925556527549517]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"H4 - 3 Axle Dump",null,"H2 - Tanker Truck",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,93.338337536143968]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"H5 - 6 Axle Dump",null,"H3 - 2 Axle Dump",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,89.460824272748752]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"H6 - 6 Axle Aggregate",null,"H4 - 3 Axle Dump",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,84.371387467963274]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"H7 - 7 Axle Aggregate",null,"H5 - 6 Axle Dump",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,78.257399601194621]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"W1 - Waste - Front Load",null,"H6 - 6 Axle Aggregate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,71.347581365354074]
[null,null,null,"ESAL Calculations for Heavy Vehicles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"W2 - Waste - Front Load",null,"H7 - 7 Axle Aggregate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,63.868446875827317]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"W3 - Waste - Rear Load",null,"W1 - Waste - Front Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,56.021847237508048]
[null,null,null,"Terminal PSI",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"W4 - Waste - Rear Load",null,"W2 - Waste - Front Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,47.976467054210005]
[null,null,null,"Structural Number",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"W5 - Waste - Side Load",null,"W3 - Waste - Rear Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,39.867174036397827]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"W6 - Recycle",null,"W4 - Waste - Rear Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,31.798164409971932]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"W7 - Recycle",null,"W5 - Waste - Side Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,23.847535962153046]
[null,null,null,"G",{"$f":"LOG10((4.2-E35)/(4.2-1.5))","v":-8.8941083336781038E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"C1 - Front Load",null,"W6 - Recycle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,16.072040527043995]
[null,null,null,"B18",{"$f":"0.4+(0.081*19^3.23)/(E36+1)^5.19","v":1.2206685583806203},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"C4 - Wind Turbine Truck",null,"W7 - Recycle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,8.5114324451089942]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,1.1921946197511062]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,-5.8693902894318626]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,-12.66477068431233]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,-19.191174197354542]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,-25.450083475262346]
[null,"Surface types for cboSurfaceType",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,-31.446056894229883]
[null,"Asphalt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,-37.185823083517562]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,-42.677590432294863]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,-47.93052409387127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,-52.954352753839459]
[null,"Base types for cboBaseType",null,null,null,"Subbase types for cboSubbaseType",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,-57.759075491411977]
[null,"Mn/DOT Class 5",null,null,null,"Mn/DOT Class 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,-62.354745568802485]
[null,"Mn/DOT Class 6",null,null,null,"Mn/DOT Class 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,-66.751313150924119]
[null,"Mn/DOT Class 7",null,null,null,"Select Granular",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,-70.958513019885345]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,-74.985786520172411]
[]
[null,"Cancel Import?"]
[null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"AVAILABLE TRUCK TYPES"]
[]
[null,null,null,null,null,null,null,null,"FULL Trucks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NumTypes",{"$f":"MAX(Y105:Y133)","v":25}]
[null,null,null,null,null,null,null,null,"ESALs per truck",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number","Type","Truck type",null,"Front Axle Wt","Rear Axle Wt2","Rear Axle Type2","Rear Axle Wt3","Rear Axle Type3","Rear Axle Wt4","Rear Axle Type4","Rear Axle Wt5","Rear Axle Type5","FrontAxleLoad-1/2Full","AxleLoad2-1/2Full","AxleLoad3-1/2Full","AxleLoad4-1/2Full","AxleLoad5-1/2Full","FrontAxleLoad-Empty","AxleLoad2-Empty","AxleLoad3-Empty","AxleLoad4-Empty","AxleLoad5-Empty","Front Tire Type","Rear Tire Type","Capacity, cy",null,"Picture File List",null,null,null,null,null,"1/2-full",null,null,null,null,null,null,null,null,null,null,"Empty"]
[null,null,null,null,null,null,"List","MnDOT Classification","Bx-Front","ESAL-Front","Rear Axle Type2","Bx-Rear2","ESAL-Rear2","Rear Axle Type3","Bx-Rear3","ESAL-Rear3","Rear Axle Type4","Bx-Rear4","ESAL-Rear4","Rear Axle Type5","Bx-Rear5","ESAL-Rear5","Truck ESAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bx-Front","Bx-2","Bx-3","Bx-4","Bx-5","ESAL-front","ESAL-2","ESAL-3","ESAL-4","ESAL-5","Truck ESAL","Bx-Front","Bx-2","Bx-3","Bx-4","Bx-5","ESAL-front","ESAL-2","ESAL-3","ESAL-4","ESAL-5","Truck ESAL"]
[null,null,null,null,null,null,{"$f":"Z105 & \" - \" & AA105","v":"B1 - City Bus"},4,{"$f":"0.4+(0.081*(AC105/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.87108709561177999},{"$f":"1/(((18+1)/(AC105/1000+1))^4.79*10^($E$39/I105)/10^($E$39/$E$40)*1^4.33)","v":0.4696192795387491},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AE105)),IF(ISERROR(SEARCH(\"Single\",AE105)),3,1),2)","v":1},{"$f":"0.4+(0.081*(AD105/1000+K105)^3.23)/($E$36+1)^5.19","v":2.145323653955117},{"$f":"IF(AD105>0,1/(((18+1)/(AD105/1000+K105))^4.79*10^($E$39/L105)/10^($E$39/$E$40)*K105^4.33),0)","v":2.8482468091334887},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AG105)),IF(ISERROR(SEARCH(\"Single\",AG105)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AF105/1000+N105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AF105>0,1/(((18+1)/(AF105/1000+N105))^4.79*10^($E$39/O105)/10^($E$39/$E$40)*N105^4.33),0)","v":0},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AI105)),IF(ISERROR(SEARCH(\"Single\",AI105)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AH105/1000+Q105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH105>0,1/(((18+1)/(AH105/1000+Q105))^4.79*10^($E$39/R105)/10^($E$39/$E$40)*Q105^4.33),0)","v":0},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AK105)),IF(ISERROR(SEARCH(\"Single\",AK105)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AJ105/1000+T105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ105>0,1/(((18+1)/(AJ105/1000+T105))^4.79*10^($E$39/U105)/10^($E$39/$E$40)*T105^4.33),0)","v":0},{"$f":"J105+M105","v":3.317866088672238},null,1,"B1","City Bus",null,15000,23000,"Dual, Single Axle",null,null,null,null,null,null,10000,17500,null,null,null,10000,12000,null,null,null,null,null,null,null,"2Ax-CityBus.jpg",null,null,null,null,null,{"$f":"0.4+(0.081*(AL105/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.54044039327450166},{"$f":"0.4+(0.081*(AM105/1000+K105)^3.23)/($E$36+1)^5.19","v":1.1529364926195083},{"$f":"0.4+(0.081*(AN105/1000+N105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AO105/1000+Q105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AP105/1000+T105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AL105/1000+1))^4.79*10^($E$39/BF105)/10^($E$39/$E$40)*1^4.33)","v":9.0105252778641398E-2},{"$f":"IF(AM105>0,1/(((18+1)/(AM105/1000+K105))^4.79*10^($E$39/BG105)/10^($E$39/$E$40)*K105^4.33),0)","v":0.88879851747895289},{"$f":"IF(AN105>0,1/(((18+1)/(AN105/1000+N105))^4.79*10^($E$39/BH105)/10^($E$39/$E$40)*N105^4.33),0)","v":0},{"$f":"IF(AO105>0,1/(((18+1)/(AO105/1000+Q105))^4.79*10^($E$39/BI105)/10^($E$39/$E$40)*Q105^4.33),0)","v":0},{"$f":"IF(AP105>0,1/(((18+1)/(AP105/1000+T105))^4.79*10^($E$39/BJ105)/10^($E$39/$E$40)*T105^4.33),0)","v":0},{"$f":"SUM(BK105:BO105)","v":0.97890377025759423},{"$f":"0.4+(0.081*(AQ105/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.54044039327450166},{"$f":"0.4+(0.081*(AR105/1000+K105)^3.23)/($E$36+1)^5.19","v":0.64089661187135705},{"$f":"0.4+(0.081*(AS105/1000+N105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AT105/1000+Q105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AU105/1000+T105)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AQ105/1000+1))^4.79*10^($E$39/BQ105)/10^($E$39/$E$40)*1^4.33)","v":9.0105252778641398E-2},{"$f":"IF(AR105>0,1/(((18+1)/(AR105/1000+K105))^4.79*10^($E$39/BR105)/10^($E$39/$E$40)*K105^4.33),0)","v":0.18900458246016152},{"$f":"IF(AS105>0,1/(((18+1)/(AS105/1000+N105))^4.79*10^($E$39/BS105)/10^($E$39/$E$40)*N105^4.33),0)","v":0},{"$f":"IF(AT105>0,1/(((18+1)/(AT105/1000+Q105))^4.79*10^($E$39/BT105)/10^($E$39/$E$40)*Q105^4.33),0)","v":0},{"$f":"IF(AU105>0,1/(((18+1)/(AU105/1000+T105))^4.79*10^($E$39/BU105)/10^($E$39/$E$40)*T105^4.33),0)","v":0},{"$f":"SUM(BV105:BZ105)","v":0.27910983523880295}]
[null,null,null,null,null,null,"B2 - Short School Bus",4,0.54044039327450166,9.0105252778641398E-2,1,1.3685466646091502,1.2555406361084562,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,1.3456458888870977,null,2,"B2","Short School Bus",null,10000,19000,"Dual, Single Axle",null,null,null,null,null,null,8000,14500,null,null,null,8000,10000,null,null,null,null,null,null,null,"2Ax-ShortSchoolBus.jpg",null,null,null,null,null,0.47345087425383986,0.82517238469714838,0.40211297966083381,0.40211297966083381,0.40211297966083381,3.6356856023823943E-2,0.40867807488160568,0,0,0,0.44503493090542962,0.47345087425383986,0.54044039327450166,0.40211297966083381,0.40211297966083381,0.40211297966083381,3.6356856023823943E-2,9.0105252778641398E-2,0,0,0,0.12646210880246533]
[null,null,null,null,null,null,"B3 - Long School Bus",4,0.54044039327450166,9.0105252778641398E-2,1,1.3685466646091502,1.2555406361084562,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,1.3456458888870977,null,3,"B3","Long School Bus",null,10000,19000,"Dual, Single Axle",null,null,null,null,null,null,8000,14500,null,null,null,8000,10000,null,null,null,null,null,null,null,"2Ax-LongSchoolBus.jpg",null,null,null,null,null,0.47345087425383986,0.82517238469714838,0.40211297966083381,0.40211297966083381,0.40211297966083381,3.6356856023823943E-2,0.40867807488160568,0,0,0,0.44503493090542962,0.47345087425383986,0.54044039327450166,0.40211297966083381,0.40211297966083381,0.40211297966083381,3.6356856023823943E-2,9.0105252778641398E-2,0,0,0,0.12646210880246533]
[null,null,null,null,null,null,"D1 - 2 Axle Delivery",5,0.64089661187135705,0.18900458246016152,1,1.5338666608015639,1.560712685742603,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,1.7497172682027646,null,4,"D1","2 Axle Delivery",null,12000,20000,"Dual, Single Axle",null,null,null,null,null,null,8000,15000,null,null,null,8000,10000,null,null,null,null,null,null,null,"2Ax-Delivery.jpg",null,null,null,null,null,0.47345087425383986,0.87108709561177999,0.40211297966083381,0.40211297966083381,0.40211297966083381,3.6356856023823943E-2,0.4696192795387491,0,0,0,0.50597613556257304,0.47345087425383986,0.54044039327450166,0.40211297966083381,0.40211297966083381,0.40211297966083381,3.6356856023823943E-2,9.0105252778641398E-2,0,0,0,0.12646210880246533]
[null,null,null,null,null,null,"D2 - 5 Axle Semi",9,{"$f":"0.4+(0.081*(AC109/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"1/(((18+1)/(AC109/1000+1))^4.79*10^($E$39/I109)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},2,{"$f":"0.4+(0.081*(AD109/1000+K109)^3.23)/($E$36+1)^5.19","v":6.8662239433651449},{"$f":"IF(AD109>0,1/(((18+1)/(AD109/1000+K109))^4.79*10^($E$39/L109)/10^($E$39/$E$40)*K109^4.33),0)","v":0.92489018409640167},2,{"$f":"0.4+(0.081*(AF109/1000+N109)^3.23)/($E$36+1)^5.19","v":6.8662239433651449},{"$f":"IF(AF109>0,1/(((18+1)/(AF109/1000+N109))^4.79*10^($E$39/O109)/10^($E$39/$E$40)*N109^4.33),0)","v":0.92489018409640167},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AI109)),IF(ISERROR(SEARCH(\"Single\",AI109)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AH109/1000+Q109)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH109>0,1/(((18+1)/(AH109/1000+Q109))^4.79*10^($E$39/R109)/10^($E$39/$E$40)*Q109^4.33),0)","v":0},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AK109)),IF(ISERROR(SEARCH(\"Single\",AK109)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AJ109/1000+T109)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ109>0,1/(((18+1)/(AJ109/1000+T109))^4.79*10^($E$39/U109)/10^($E$39/$E$40)*T109^4.33),0)","v":0},{"$f":"J109+M109","v":1.1138947665565633},null,23,"D2","5 Axle Semi",null,12000,34000,"Dual, Tandem Axle",34000,"Dual, Tandem Axle",null,null,null,null,10000,22000,22000,null,null,10000,15000,15000,null,null,null,null,null,null,"5Ax-Semi.jpg",null,null,null,null,null,{"$f":"0.4+(0.081*(AL109/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.54044039327450166},{"$f":"0.4+(0.081*(AM109/1000+K109)^3.23)/($E$36+1)^5.19","v":2.145323653955117},{"$f":"0.4+(0.081*(AN109/1000+N109)^3.23)/($E$36+1)^5.19","v":2.145323653955117},{"$f":"0.4+(0.081*(AO109/1000+Q109)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AP109/1000+T109)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AL109/1000+1))^4.79*10^($E$39/BF109)/10^($E$39/$E$40)*1^4.33)","v":9.0105252778641398E-2},{"$f":"IF(AM109>0,1/(((18+1)/(AM109/1000+K109))^4.79*10^($E$39/BG109)/10^($E$39/$E$40)*K109^4.33),0)","v":0.14161776571276394},{"$f":"IF(AN109>0,1/(((18+1)/(AN109/1000+N109))^4.79*10^($E$39/BH109)/10^($E$39/$E$40)*N109^4.33),0)","v":0.14161776571276394},{"$f":"IF(AO109>0,1/(((18+1)/(AO109/1000+Q109))^4.79*10^($E$39/BI109)/10^($E$39/$E$40)*Q109^4.33),0)","v":0},{"$f":"IF(AP109>0,1/(((18+1)/(AP109/1000+T109))^4.79*10^($E$39/BJ109)/10^($E$39/$E$40)*T109^4.33),0)","v":0},{"$f":"SUM(BK109:BO109)","v":0.37334078420416927},{"$f":"0.4+(0.081*(AQ109/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.54044039327450166},{"$f":"0.4+(0.081*(AR109/1000+K109)^3.23)/($E$36+1)^5.19","v":0.9729855634738207},{"$f":"0.4+(0.081*(AS109/1000+N109)^3.23)/($E$36+1)^5.19","v":0.9729855634738207},{"$f":"0.4+(0.081*(AT109/1000+Q109)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AU109/1000+T109)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AQ109/1000+1))^4.79*10^($E$39/BQ109)/10^($E$39/$E$40)*1^4.33)","v":9.0105252778641398E-2},{"$f":"IF(AR109>0,1/(((18+1)/(AR109/1000+K109))^4.79*10^($E$39/BR109)/10^($E$39/$E$40)*K109^4.33),0)","v":3.0458505563430247E-2},{"$f":"IF(AS109>0,1/(((18+1)/(AS109/1000+N109))^4.79*10^($E$39/BS109)/10^($E$39/$E$40)*N109^4.33),0)","v":3.0458505563430247E-2},{"$f":"IF(AT109>0,1/(((18+1)/(AT109/1000+Q109))^4.79*10^($E$39/BT109)/10^($E$39/$E$40)*Q109^4.33),0)","v":0},{"$f":"IF(AU109>0,1/(((18+1)/(AU109/1000+T109))^4.79*10^($E$39/BU109)/10^($E$39/$E$40)*T109^4.33),0)","v":0},{"$f":"SUM(BV109:BZ109)","v":0.15102226390550189}]
[null,null,null,null,null,null,"D3 - 3 Axle Semi + 2 Axle Trailer",11,{"$f":"0.4+(0.081*(AC110/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"1/(((18+1)/(AC110/1000+1))^4.79*10^($E$39/I110)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},1,{"$f":"0.4+(0.081*(AD110/1000+K110)^3.23)/($E$36+1)^5.19","v":1.5338666608015639},{"$f":"IF(AD110>0,1/(((18+1)/(AD110/1000+K110))^4.79*10^($E$39/L110)/10^($E$39/$E$40)*K110^4.33),0)","v":1.560712685742603},1,{"$f":"0.4+(0.081*(AF110/1000+N110)^3.23)/($E$36+1)^5.19","v":1.5338666608015639},{"$f":"IF(AF110>0,1/(((18+1)/(AF110/1000+N110))^4.79*10^($E$39/O110)/10^($E$39/$E$40)*N110^4.33),0)","v":1.560712685742603},1,{"$f":"0.4+(0.081*(AH110/1000+Q110)^3.23)/($E$36+1)^5.19","v":1.5338666608015639},{"$f":"IF(AH110>0,1/(((18+1)/(AH110/1000+Q110))^4.79*10^($E$39/R110)/10^($E$39/$E$40)*Q110^4.33),0)","v":1.560712685742603},1,{"$f":"0.4+(0.081*(AJ110/1000+T110)^3.23)/($E$36+1)^5.19","v":1.5338666608015639},{"$f":"IF(AJ110>0,1/(((18+1)/(AJ110/1000+T110))^4.79*10^($E$39/U110)/10^($E$39/$E$40)*T110^4.33),0)","v":1.560712685742603},{"$f":"J110+M110","v":1.7497172682027646},null,24,"D3","3 Axle Semi + 2 Axle Trailer",null,12000,20000,"Dual, Single Axle",20000,"Dual, Single Axle",20000,"Dual, Single Axle",20000,"Dual, Single Axle",11000,13000,13000,13000,13000,10000,8000,8000,8000,8000,null,null,null,null,"3Ax-Semi+2AxTrailer.jpg",null,null,null,null,null,{"$f":"0.4+(0.081*(AL110/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.58601548059875952},{"$f":"0.4+(0.081*(AM110/1000+K110)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"0.4+(0.081*(AN110/1000+N110)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"0.4+(0.081*(AO110/1000+Q110)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"0.4+(0.081*(AP110/1000+T110)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"1/(((18+1)/(AL110/1000+1))^4.79*10^($E$39/BF110)/10^($E$39/$E$40)*1^4.33)","v":0.13272673299467366},{"$f":"IF(AM110>0,1/(((18+1)/(AM110/1000+K110))^4.79*10^($E$39/BG110)/10^($E$39/$E$40)*K110^4.33),0)","v":0.26171676481536849},{"$f":"IF(AN110>0,1/(((18+1)/(AN110/1000+N110))^4.79*10^($E$39/BH110)/10^($E$39/$E$40)*N110^4.33),0)","v":0.26171676481536849},{"$f":"IF(AO110>0,1/(((18+1)/(AO110/1000+Q110))^4.79*10^($E$39/BI110)/10^($E$39/$E$40)*Q110^4.33),0)","v":0.26171676481536849},{"$f":"IF(AP110>0,1/(((18+1)/(AP110/1000+T110))^4.79*10^($E$39/BJ110)/10^($E$39/$E$40)*T110^4.33),0)","v":0.26171676481536849},{"$f":"SUM(BK110:BO110)","v":1.1795937922561475},{"$f":"0.4+(0.081*(AQ110/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.54044039327450166},{"$f":"0.4+(0.081*(AR110/1000+K110)^3.23)/($E$36+1)^5.19","v":0.47345087425383986},{"$f":"0.4+(0.081*(AS110/1000+N110)^3.23)/($E$36+1)^5.19","v":0.47345087425383986},{"$f":"0.4+(0.081*(AT110/1000+Q110)^3.23)/($E$36+1)^5.19","v":0.47345087425383986},{"$f":"0.4+(0.081*(AU110/1000+T110)^3.23)/($E$36+1)^5.19","v":0.47345087425383986},{"$f":"1/(((18+1)/(AQ110/1000+1))^4.79*10^($E$39/BQ110)/10^($E$39/$E$40)*1^4.33)","v":9.0105252778641398E-2},{"$f":"IF(AR110>0,1/(((18+1)/(AR110/1000+K110))^4.79*10^($E$39/BR110)/10^($E$39/$E$40)*K110^4.33),0)","v":3.6356856023823943E-2},{"$f":"IF(AS110>0,1/(((18+1)/(AS110/1000+N110))^4.79*10^($E$39/BS110)/10^($E$39/$E$40)*N110^4.33),0)","v":3.6356856023823943E-2},{"$f":"IF(AT110>0,1/(((18+1)/(AT110/1000+Q110))^4.79*10^($E$39/BT110)/10^($E$39/$E$40)*Q110^4.33),0)","v":3.6356856023823943E-2},{"$f":"IF(AU110>0,1/(((18+1)/(AU110/1000+T110))^4.79*10^($E$39/BU110)/10^($E$39/$E$40)*T110^4.33),0)","v":3.6356856023823943E-2},{"$f":"SUM(BV110:BZ110)","v":0.23553267687393714}]
[null,null,null,null,null,null,"D4 - 4 Axle Semi + 2 Axle Trailer",12,{"$f":"0.4+(0.081*(AC111/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"1/(((18+1)/(AC111/1000+1))^4.79*10^($E$39/I111)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},2,{"$f":"0.4+(0.081*(AD111/1000+K111)^3.23)/($E$36+1)^5.19","v":1.7177072121296426},{"$f":"IF(AD111>0,1/(((18+1)/(AD111/1000+K111))^4.79*10^($E$39/L111)/10^($E$39/$E$40)*K111^4.33),0)","v":9.5594161242888817E-2},1,{"$f":"0.4+(0.081*(AF111/1000+N111)^3.23)/($E$36+1)^5.19","v":1.5338666608015639},{"$f":"IF(AF111>0,1/(((18+1)/(AF111/1000+N111))^4.79*10^($E$39/O111)/10^($E$39/$E$40)*N111^4.33),0)","v":1.560712685742603},1,{"$f":"0.4+(0.081*(AH111/1000+Q111)^3.23)/($E$36+1)^5.19","v":1.5338666608015639},{"$f":"IF(AH111>0,1/(((18+1)/(AH111/1000+Q111))^4.79*10^($E$39/R111)/10^($E$39/$E$40)*Q111^4.33),0)","v":1.560712685742603},1,{"$f":"0.4+(0.081*(AJ111/1000+T111)^3.23)/($E$36+1)^5.19","v":1.5338666608015639},{"$f":"IF(AJ111>0,1/(((18+1)/(AJ111/1000+T111))^4.79*10^($E$39/U111)/10^($E$39/$E$40)*T111^4.33),0)","v":1.560712685742603},{"$f":"J111+M111","v":0.28459874370305033},null,25,"D4","4 Axle Semi + 2 Axle Trailer",null,12000,20000,"Dual, Tandem Axle",20000,"Dual, Single Axle",20000,"Dual, Single Axle",20000,"Dual, Single Axle",11000,13000,13000,13000,13000,10000,8000,8000,8000,8000,null,null,null,null,"4Ax-Semi+2AxTrailer.jpg",null,null,null,null,null,{"$f":"0.4+(0.081*(AL111/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.58601548059875952},{"$f":"0.4+(0.081*(AM111/1000+K111)^3.23)/($E$36+1)^5.19","v":0.782444509683766},{"$f":"0.4+(0.081*(AN111/1000+N111)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"0.4+(0.081*(AO111/1000+Q111)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"0.4+(0.081*(AP111/1000+T111)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"1/(((18+1)/(AL111/1000+1))^4.79*10^($E$39/BF111)/10^($E$39/$E$40)*1^4.33)","v":0.13272673299467366},{"$f":"IF(AM111>0,1/(((18+1)/(AM111/1000+K111))^4.79*10^($E$39/BG111)/10^($E$39/$E$40)*K111^4.33),0)","v":1.760336481856915E-2},{"$f":"IF(AN111>0,1/(((18+1)/(AN111/1000+N111))^4.79*10^($E$39/BH111)/10^($E$39/$E$40)*N111^4.33),0)","v":0.26171676481536849},{"$f":"IF(AO111>0,1/(((18+1)/(AO111/1000+Q111))^4.79*10^($E$39/BI111)/10^($E$39/$E$40)*Q111^4.33),0)","v":0.26171676481536849},{"$f":"IF(AP111>0,1/(((18+1)/(AP111/1000+T111))^4.79*10^($E$39/BJ111)/10^($E$39/$E$40)*T111^4.33),0)","v":0.26171676481536849},{"$f":"SUM(BK111:BO111)","v":0.9354803922593482},{"$f":"0.4+(0.081*(AQ111/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.54044039327450166},{"$f":"0.4+(0.081*(AR111/1000+K111)^3.23)/($E$36+1)^5.19","v":0.5032270850689049},{"$f":"0.4+(0.081*(AS111/1000+N111)^3.23)/($E$36+1)^5.19","v":0.47345087425383986},{"$f":"0.4+(0.081*(AT111/1000+Q111)^3.23)/($E$36+1)^5.19","v":0.47345087425383986},{"$f":"0.4+(0.081*(AU111/1000+T111)^3.23)/($E$36+1)^5.19","v":0.47345087425383986},{"$f":"1/(((18+1)/(AQ111/1000+1))^4.79*10^($E$39/BQ111)/10^($E$39/$E$40)*1^4.33)","v":9.0105252778641398E-2},{"$f":"IF(AR111>0,1/(((18+1)/(AR111/1000+K111))^4.79*10^($E$39/BR111)/10^($E$39/$E$40)*K111^4.33),0)","v":2.9186983916575969E-3},{"$f":"IF(AS111>0,1/(((18+1)/(AS111/1000+N111))^4.79*10^($E$39/BS111)/10^($E$39/$E$40)*N111^4.33),0)","v":3.6356856023823943E-2},{"$f":"IF(AT111>0,1/(((18+1)/(AT111/1000+Q111))^4.79*10^($E$39/BT111)/10^($E$39/$E$40)*Q111^4.33),0)","v":3.6356856023823943E-2},{"$f":"IF(AU111>0,1/(((18+1)/(AU111/1000+T111))^4.79*10^($E$39/BU111)/10^($E$39/$E$40)*T111^4.33),0)","v":3.6356856023823943E-2},{"$f":"SUM(BV111:BZ111)","v":0.2020945192417708}]
[null,null,null,null,null,null,{"$f":"Z112 & \" - \" & AA112","v":"G1 - Cattle Truck"},9,{"$f":"0.4+(0.081*(AC112/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"1/(((18+1)/(AC112/1000+1))^4.79*10^($E$39/I112)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AE112)),IF(ISERROR(SEARCH(\"Single\",AE112)),3,1),2)","v":2},{"$f":"0.4+(0.081*(AD112/1000+K112)^3.23)/($E$36+1)^5.19","v":6.8662239433651449},{"$f":"IF(AD112>0,1/(((18+1)/(AD112/1000+K112))^4.79*10^($E$39/L112)/10^($E$39/$E$40)*K112^4.33),0)","v":0.92489018409640167},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AG112)),IF(ISERROR(SEARCH(\"Single\",AG112)),3,1),2)","v":2},{"$f":"0.4+(0.081*(AF112/1000+N112)^3.23)/($E$36+1)^5.19","v":6.8662239433651449},{"$f":"IF(AF112>0,1/(((18+1)/(AF112/1000+N112))^4.79*10^($E$39/O112)/10^($E$39/$E$40)*N112^4.33),0)","v":0.92489018409640167},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AI112)),IF(ISERROR(SEARCH(\"Single\",AI112)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AH112/1000+Q112)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH112>0,1/(((18+1)/(AH112/1000+Q112))^4.79*10^($E$39/R112)/10^($E$39/$E$40)*Q112^4.33),0)","v":0},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AK112)),IF(ISERROR(SEARCH(\"Single\",AK112)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AJ112/1000+T112)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ112>0,1/(((18+1)/(AJ112/1000+T112))^4.79*10^($E$39/U112)/10^($E$39/$E$40)*T112^4.33),0)","v":0},{"$f":"J112+M112","v":1.1138947665565633},null,5,"G1","Cattle Truck",null,12000,34000,"Dual, Tandem Axle",34000,"Dual, Tandem Axle",null,null,null,null,12000,23000,23000,null,null,12000,12000,12000,null,null,null,null,null,null,"5Ax-CattleTruck.jpg",null,null,null,null,null,{"$f":"0.4+(0.081*(AL112/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"0.4+(0.081*(AM112/1000+K112)^3.23)/($E$36+1)^5.19","v":2.3913146640267504},{"$f":"0.4+(0.081*(AN112/1000+N112)^3.23)/($E$36+1)^5.19","v":2.3913146640267504},{"$f":"0.4+(0.081*(AO112/1000+Q112)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AP112/1000+T112)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AL112/1000+1))^4.79*10^($E$39/BF112)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},{"$f":"IF(AM112>0,1/(((18+1)/(AM112/1000+K112))^4.79*10^($E$39/BG112)/10^($E$39/$E$40)*K112^4.33),0)","v":0.17051940026554022},{"$f":"IF(AN112>0,1/(((18+1)/(AN112/1000+N112))^4.79*10^($E$39/BH112)/10^($E$39/$E$40)*N112^4.33),0)","v":0.17051940026554022},{"$f":"IF(AO112>0,1/(((18+1)/(AO112/1000+Q112))^4.79*10^($E$39/BI112)/10^($E$39/$E$40)*Q112^4.33),0)","v":0},{"$f":"IF(AP112>0,1/(((18+1)/(AP112/1000+T112))^4.79*10^($E$39/BJ112)/10^($E$39/$E$40)*T112^4.33),0)","v":0},{"$f":"SUM(BK112:BO112)","v":0.53004338299124198},{"$f":"0.4+(0.081*(AQ112/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"0.4+(0.081*(AR112/1000+K112)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"0.4+(0.081*(AS112/1000+N112)^3.23)/($E$36+1)^5.19","v":0.7060463604200784},{"$f":"0.4+(0.081*(AT112/1000+Q112)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AU112/1000+T112)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AQ112/1000+1))^4.79*10^($E$39/BQ112)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},{"$f":"IF(AR112>0,1/(((18+1)/(AR112/1000+K112))^4.79*10^($E$39/BR112)/10^($E$39/$E$40)*K112^4.33),0)","v":1.3012827176308205E-2},{"$f":"IF(AS112>0,1/(((18+1)/(AS112/1000+N112))^4.79*10^($E$39/BS112)/10^($E$39/$E$40)*N112^4.33),0)","v":1.3012827176308205E-2},{"$f":"IF(AT112>0,1/(((18+1)/(AT112/1000+Q112))^4.79*10^($E$39/BT112)/10^($E$39/$E$40)*Q112^4.33),0)","v":0},{"$f":"IF(AU112>0,1/(((18+1)/(AU112/1000+T112))^4.79*10^($E$39/BU112)/10^($E$39/$E$40)*T112^4.33),0)","v":0},{"$f":"SUM(BV112:BZ112)","v":0.21503023681277791}]
[null,null,null,null,null,null,"G2 - 5 Axle Grain",9,{"$f":"0.4+(0.081*(AC113/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"1/(((18+1)/(AC113/1000+1))^4.79*10^($E$39/I113)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},2,{"$f":"0.4+(0.081*(AD113/1000+K113)^3.23)/($E$36+1)^5.19","v":6.8662239433651449},{"$f":"IF(AD113>0,1/(((18+1)/(AD113/1000+K113))^4.79*10^($E$39/L113)/10^($E$39/$E$40)*K113^4.33),0)","v":0.92489018409640167},2,{"$f":"0.4+(0.081*(AF113/1000+N113)^3.23)/($E$36+1)^5.19","v":6.8662239433651449},{"$f":"IF(AF113>0,1/(((18+1)/(AF113/1000+N113))^4.79*10^($E$39/O113)/10^($E$39/$E$40)*N113^4.33),0)","v":0.92489018409640167},3,{"$f":"0.4+(0.081*(AH113/1000+Q113)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH113>0,1/(((18+1)/(AH113/1000+Q113))^4.79*10^($E$39/R113)/10^($E$39/$E$40)*Q113^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AJ113/1000+T113)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ113>0,1/(((18+1)/(AJ113/1000+T113))^4.79*10^($E$39/U113)/10^($E$39/$E$40)*T113^4.33),0)","v":0},{"$f":"J113+M113","v":1.1138947665565633},null,6,"G2","5 Axle Grain",null,12000,34000,"Dual, Tandem Axle",34000,"Dual, Tandem Axle",null,null,null,null,12000,23000,23000,null,null,12000,12000,12000,null,null,null,null,null,null,"5Ax-GrainTruck.jpg",null,null,null,null,null,0.64089661187135705,2.3913146640267504,2.3913146640267504,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.17051940026554022,0.17051940026554022,0,0,0.53004338299124198,0.64089661187135705,0.7060463604200784,0.7060463604200784,0.40211297966083381,0.40211297966083381,0.18900458246016152,1.3012827176308205E-2,1.3012827176308205E-2,0,0,0.21503023681277791]
[null,null,null,null,null,null,"G3 - 3 Axle Grain",8,{"$f":"0.4+(0.081*(AC114/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":1.2206685583806203},{"$f":"1/(((18+1)/(AC114/1000+1))^4.79*10^($E$39/I114)/10^($E$39/$E$40)*1^4.33)","v":1},2,{"$f":"0.4+(0.081*(AD114/1000+K114)^3.23)/($E$36+1)^5.19","v":14.672546289811264},{"$f":"IF(AD114>0,1/(((18+1)/(AD114/1000+K114))^4.79*10^($E$39/L114)/10^($E$39/$E$40)*K114^4.33),0)","v":2.9452320645891428},3,{"$f":"0.4+(0.081*(AF114/1000+N114)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AF114>0,1/(((18+1)/(AF114/1000+N114))^4.79*10^($E$39/O114)/10^($E$39/$E$40)*N114^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AH114/1000+Q114)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH114>0,1/(((18+1)/(AH114/1000+Q114))^4.79*10^($E$39/R114)/10^($E$39/$E$40)*Q114^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AJ114/1000+T114)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ114>0,1/(((18+1)/(AJ114/1000+T114))^4.79*10^($E$39/U114)/10^($E$39/$E$40)*T114^4.33),0)","v":0},{"$f":"J114+M114","v":3.9452320645891428},null,7,"G3","3 Axle Grain",null,18000,44000,"Dual, Tandem Axle",null,null,null,null,null,null,14000,29500,null,null,null,14000,15000,null,null,null,null,null,null,null,"3Ax-GrainTruck.jpg",null,null,null,null,null,0.782444509683766,4.6008459199207659,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.35404264021645498,0.49509300148180863,0,0,0,0.84913564169826361,0.782444509683766,0.9729855634738207,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.35404264021645498,3.0458505563430247E-2,0,0,0,0.38450114577988526]
[null,null,null,null,null,null,"G4 - 3+ Axle Sugar Beet",8,{"$f":"0.4+(0.081*(AC115/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.87108709561177999},{"$f":"1/(((18+1)/(AC115/1000+1))^4.79*10^($E$39/I115)/10^($E$39/$E$40)*1^4.33)","v":0.4696192795387491},3,{"$f":"0.4+(0.081*(AD115/1000+K115)^3.23)/($E$36+1)^5.19","v":11.8788075686317},{"$f":"IF(AD115>0,1/(((18+1)/(AD115/1000+K115))^4.79*10^($E$39/L115)/10^($E$39/$E$40)*K115^4.33),0)","v":0.36963568918565026},3,{"$f":"0.4+(0.081*(AF115/1000+N115)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AF115>0,1/(((18+1)/(AF115/1000+N115))^4.79*10^($E$39/O115)/10^($E$39/$E$40)*N115^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AH115/1000+Q115)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH115>0,1/(((18+1)/(AH115/1000+Q115))^4.79*10^($E$39/R115)/10^($E$39/$E$40)*Q115^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AJ115/1000+T115)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ115>0,1/(((18+1)/(AJ115/1000+T115))^4.79*10^($E$39/U115)/10^($E$39/$E$40)*T115^4.33),0)","v":0},{"$f":"J115+M115","v":0.83925496872439931},null,8,"G4","3+ Axle Sugar Beet",null,15000,40000,"Tridem",null,null,null,null,null,null,10000,25000,null,null,null,10000,10000,null,null,null,null,null,null,null,"3+Ax-SugarBeet.jpg",null,null,null,null,null,0.54044039327450166,3.2715349406870713,0.40211297966083381,0.40211297966083381,0.40211297966083381,9.0105252778641398E-2,4.9550259887681129E-2,0,0,0,0.13965551266632253,0.54044039327450166,0.64089661187135705,0.40211297966083381,0.40211297966083381,0.40211297966083381,9.0105252778641398E-2,1.6238178118969154E-3,0,0,0,9.1729070590538309E-2]
[null,null,null,null,null,null,"H1 - Concrete Truck",6,{"$f":"0.4+(0.081*(AC116/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.87108709561177999},{"$f":"1/(((18+1)/(AC116/1000+1))^4.79*10^($E$39/I116)/10^($E$39/$E$40)*1^4.33)","v":0.4696192795387491},2,{"$f":"0.4+(0.081*(AD116/1000+K116)^3.23)/($E$36+1)^5.19","v":8.1000701360362743},{"$f":"IF(AD116>0,1/(((18+1)/(AD116/1000+K116))^4.79*10^($E$39/L116)/10^($E$39/$E$40)*K116^4.33),0)","v":1.1928655185401966},3,{"$f":"0.4+(0.081*(AF116/1000+N116)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AF116>0,1/(((18+1)/(AF116/1000+N116))^4.79*10^($E$39/O116)/10^($E$39/$E$40)*N116^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AH116/1000+Q116)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH116>0,1/(((18+1)/(AH116/1000+Q116))^4.79*10^($E$39/R116)/10^($E$39/$E$40)*Q116^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AJ116/1000+T116)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ116>0,1/(((18+1)/(AJ116/1000+T116))^4.79*10^($E$39/U116)/10^($E$39/$E$40)*T116^4.33),0)","v":0},{"$f":"J116+M116","v":1.6624847980789457},null,9,"H1","Concrete Truck",null,15000,36000,"Dual, Tandem Axle",null,null,null,null,null,null,12000,24000,null,null,null,12000,12000,null,null,null,null,null,null,null,"2+Ax-ConcreteTruck.jpg",null,null,null,null,null,0.64089661187135705,2.6602557244341978,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.20398742304623985,0,0,0,0.39299200550640134,0.64089661187135705,0.7060463604200784,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,1.3012827176308205E-2,0,0,0,0.20201740963646972]
[null,null,null,null,null,null,"H2 - Tanker Truck",9,0.64089661187135705,0.18900458246016152,2,6.8662239433651449,0.92489018409640167,2,6.8662239433651449,0.92489018409640167,3,0.40211297966083381,0,3,0.40211297966083381,0,1.1138947665565633,null,10,"H2","Tanker Truck",null,12000,34000,"Dual, Tandem Axle",34000,"Dual, Tandem Axle",null,null,null,null,12000,21000,21000,null,null,12000,8000,8000,null,null,null,null,null,null,"5Ax-Tanker.jpg",null,null,null,null,null,0.64089661187135705,1.9211588701332967,1.9211588701332967,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.1167937610278682,0.1167937610278682,0,0,0.4225921045158979,0.64089661187135705,0.5032270850689049,0.5032270850689049,0.40211297966083381,0.40211297966083381,0.18900458246016152,2.9186983916575969E-3,2.9186983916575969E-3,0,0,0.19484197924347671]
[null,null,null,null,null,null,"H3 - 2 Axle Dump",5,0.64089661187135705,0.18900458246016152,1,1.9211588701332967,2.3489811147637858,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,2.5379856972239474,null,11,"H3","2 Axle Dump",null,12000,22000,"Dual, Single Axle",null,null,null,null,null,null,12000,16000,null,null,null,12000,10000,null,null,null,null,null,null,null,"2Ax-DumpTruck.jpg",null,null,null,null,null,0.64089661187135705,0.9729855634738207,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.61258798177886931,0,0,0,0.8015925642390308,0.64089661187135705,0.54044039327450166,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,9.0105252778641398E-2,0,0,0,0.27910983523880295]
[null,null,null,null,null,null,"H4 - 3 Axle Dump",6,1.2206685583806203,1,2,14.672546289811264,2.9452320645891428,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,3.9452320645891428,null,12,"H4","3 Axle Dump",null,18000,44000,"Dual, Tandem Axle",null,null,null,null,null,null,12000,30000,null,null,null,12000,16000,null,null,null,null,null,null,null,"3Ax-DumpTruck.jpg",null,null,null,null,null,0.64089661187135705,4.8200592789250836,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.53280519125814052,0,0,0,0.72180977371830202,0.64089661187135705,1.0891660190123136,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,3.9161820697268819E-2,0,0,0,0.22816640315743034]
[null,null,null,null,null,null,"H5 - 6 Axle Dump",10,0.64089661187135705,0.18900458246016152,2,2.6602557244341978,0.20398742304623985,3,15.699236038102242,0.56362035885764838,3,0.40211297966083381,0,3,0.40211297966083381,0,0.39299200550640134,null,13,"H5","6 Axle Dump",null,12000,24000,"Dual, Tandem Axle",44000,"Tridem",null,null,null,null,10000,18000,28000,null,null,10000,12000,12000,null,null,null,null,null,null,"6Ax-DumpTruck.jpg",null,null,null,null,null,0.54044039327450166,1.3685466646091502,4.3892562577686149,0.40211297966083381,0.40211297966083381,9.0105252778641398E-2,6.2426773928820956E-2,7.9406946137584866E-2,0,0,0.23193897284504722,0.54044039327450166,0.7060463604200784,0.782444509683766,0.40211297966083381,0.40211297966083381,9.0105252778641398E-2,1.3012827176308205E-2,3.0417291362534486E-3,0,0,0.10615980909120305]
[null,null,null,null,null,null,"H6 - 6 Axle Aggregate",10,0.64089661187135705,0.18900458246016152,2,2.6602557244341978,0.20398742304623985,3,15.699236038102242,0.56362035885764838,3,0.40211297966083381,0,3,0.40211297966083381,0,0.39299200550640134,null,14,"H6","6 Axle Aggregate",null,12000,24000,"Dual, Tandem Axle",44000,"Tridem",null,null,null,null,12000,18000,28000,null,null,12000,12000,12000,null,null,null,null,null,null,"6Ax-AggregateTruck.jpg",null,null,null,null,null,0.64089661187135705,1.3685466646091502,4.3892562577686149,0.40211297966083381,0.40211297966083381,0.18900458246016152,6.2426773928820956E-2,7.9406946137584866E-2,0,0,0.33083830252656737,0.64089661187135705,0.7060463604200784,0.782444509683766,0.40211297966083381,0.40211297966083381,0.18900458246016152,1.3012827176308205E-2,3.0417291362534486E-3,0,0,0.20505913877272317]
[null,null,null,null,null,null,"H7 - 7 Axle Aggregate",10,{"$f":"0.4+(0.081*(AC122/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.64089661187135705},{"$f":"1/(((18+1)/(AC122/1000+1))^4.79*10^($E$39/I122)/10^($E$39/$E$40)*1^4.33)","v":0.18900458246016152},3,{"$f":"0.4+(0.081*(AD122/1000+K122)^3.23)/($E$36+1)^5.19","v":15.699236038102242},{"$f":"IF(AD122>0,1/(((18+1)/(AD122/1000+K122))^4.79*10^($E$39/L122)/10^($E$39/$E$40)*K122^4.33),0)","v":0.56362035885764838},3,{"$f":"0.4+(0.081*(AF122/1000+N122)^3.23)/($E$36+1)^5.19","v":15.699236038102242},{"$f":"IF(AF122>0,1/(((18+1)/(AF122/1000+N122))^4.79*10^($E$39/O122)/10^($E$39/$E$40)*N122^4.33),0)","v":0.56362035885764838},3,{"$f":"0.4+(0.081*(AH122/1000+Q122)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH122>0,1/(((18+1)/(AH122/1000+Q122))^4.79*10^($E$39/R122)/10^($E$39/$E$40)*Q122^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AJ122/1000+T122)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ122>0,1/(((18+1)/(AJ122/1000+T122))^4.79*10^($E$39/U122)/10^($E$39/$E$40)*T122^4.33),0)","v":0},{"$f":"J122+M122","v":0.75262494131780988},null,14,"H7","7 Axle Aggregate",null,12000,44000,"Tridem",44000,"Tridem",null,null,null,null,12000,18000,28000,null,null,12000,12000,12000,null,null,null,null,null,null,"7Ax-AggregateTruck.jpg",null,null,null,null,null,0.64089661187135705,1.5338666608015639,4.3892562577686149,0.40211297966083381,0.40211297966083381,0.18900458246016152,1.3408738694981088E-2,7.9406946137584866E-2,0,0,0.28182026729272747,0.64089661187135705,0.782444509683766,0.782444509683766,0.40211297966083381,0.40211297966083381,0.18900458246016152,3.0417291362534486E-3,3.0417291362534486E-3,0,0,0.19508804073266842]
[null,null,null,null,null,null,"W1 - Waste - Front Load",7,{"$f":"0.4+(0.081*(AC123/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":1.5338666608015639},{"$f":"1/(((18+1)/(AC123/1000+1))^4.79*10^($E$39/I123)/10^($E$39/$E$40)*1^4.33)","v":1.560712685742603},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AE123)),IF(ISERROR(SEARCH(\"Single\",AE123)),3,1),2)","v":2},{"$f":"0.4+(0.081*(AD123/1000+K123)^3.23)/($E$36+1)^5.19","v":16.775812632637177},{"$f":"IF(AD123>0,1/(((18+1)/(AD123/1000+K123))^4.79*10^($E$39/L123)/10^($E$39/$E$40)*K123^4.33),0)","v":3.6049151219772075},3,{"$f":"0.4+(0.081*(AF123/1000+N123)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AF123>0,1/(((18+1)/(AF123/1000+N123))^4.79*10^($E$39/O123)/10^($E$39/$E$40)*N123^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AH123/1000+Q123)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH123>0,1/(((18+1)/(AH123/1000+Q123))^4.79*10^($E$39/R123)/10^($E$39/$E$40)*Q123^4.33),0)","v":0},3,{"$f":"0.4+(0.081*(AJ123/1000+T123)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ123>0,1/(((18+1)/(AJ123/1000+T123))^4.79*10^($E$39/U123)/10^($E$39/$E$40)*T123^4.33),0)","v":0},{"$f":"J123+M123+P123+S123+U123","v":5.5677407873806448},null,15,"W1","Waste - Front Load",null,20000,46000,"Dual, Tandem Axle",null,null,null,null,null,null,16000,33000,null,null,null,16000,20000,null,null,null,"425/65R22.5","11R22.5",40,null,"FrontLoader-2.jpg",null,null,null,null,null,0.9729855634738207,6.3038246112414837,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.61258798177886931,0.81029427570111345,0,0,0,1.4228822574799826,0.9729855634738207,1.7177072121296426,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.61258798177886931,9.5594161242888817E-2,0,0,0,0.70818214302175808]
[null,null,null,null,null,null,{"$f":"Z124 & \" - \" & AA124","v":"W2 - Waste - Front Load"},7,{"$f":"0.4+(0.081*(AC124/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":1.2206685583806203},1,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AE124)),IF(ISERROR(SEARCH(\"Single\",AE124)),3,1),2)","v":2},16.775812632637177,3.6049151219772075,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AG124)),IF(ISERROR(SEARCH(\"Single\",AG124)),3,1),2)","v":3},0.40211297966083381,0,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AI124)),IF(ISERROR(SEARCH(\"Single\",AI124)),3,1),2)","v":3},0.40211297966083381,0,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AK124)),IF(ISERROR(SEARCH(\"Single\",AK124)),3,1),2)","v":3},0.40211297966083381,0,{"$f":"J124+M124","v":4.6049151219772071},null,16,"W2","Waste - Front Load",null,18000,46000,"Dual Tandem with Tag Axle",null,null,null,null,null,null,15000,34500,null,null,null,15000,23000,null,null,null,"385/65R22.5","12R22.5",40,null,"FrontLoader-3.jpg",null,null,null,null,null,{"$f":"0.4+(0.081*(AL124/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.87108709561177999},{"$f":"0.4+(0.081*(AM124/1000+K124)^3.23)/($E$36+1)^5.19","v":7.1608237773063061},{"$f":"0.4+(0.081*(AN124/1000+N124)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AO124/1000+Q124)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AP124/1000+T124)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AL124/1000+1))^4.79*10^($E$39/BF124)/10^($E$39/$E$40)*1^4.33)","v":0.4696192795387491},{"$f":"IF(AM124>0,1/(((18+1)/(AM124/1000+K124))^4.79*10^($E$39/BG124)/10^($E$39/$E$40)*K124^4.33),0)","v":0.98684990180697951},{"$f":"IF(AN124>0,1/(((18+1)/(AN124/1000+N124))^4.79*10^($E$39/BH124)/10^($E$39/$E$40)*N124^4.33),0)","v":0},{"$f":"IF(AO124>0,1/(((18+1)/(AO124/1000+Q124))^4.79*10^($E$39/BI124)/10^($E$39/$E$40)*Q124^4.33),0)","v":0},{"$f":"IF(AP124>0,1/(((18+1)/(AP124/1000+T124))^4.79*10^($E$39/BJ124)/10^($E$39/$E$40)*T124^4.33),0)","v":0},{"$f":"SUM(BK124:BO124)","v":1.4564691813457287},{"$f":"0.4+(0.081*(AQ124/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.87108709561177999},{"$f":"0.4+(0.081*(AR124/1000+K124)^3.23)/($E$36+1)^5.19","v":2.3913146640267504},{"$f":"0.4+(0.081*(AS124/1000+N124)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AT124/1000+Q124)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"0.4+(0.081*(AU124/1000+T124)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"1/(((18+1)/(AQ124/1000+1))^4.79*10^($E$39/BQ124)/10^($E$39/$E$40)*1^4.33)","v":0.4696192795387491},{"$f":"IF(AR124>0,1/(((18+1)/(AR124/1000+K124))^4.79*10^($E$39/BR124)/10^($E$39/$E$40)*K124^4.33),0)","v":0.17051940026554022},{"$f":"IF(AS124>0,1/(((18+1)/(AS124/1000+N124))^4.79*10^($E$39/BS124)/10^($E$39/$E$40)*N124^4.33),0)","v":0},{"$f":"IF(AT124>0,1/(((18+1)/(AT124/1000+Q124))^4.79*10^($E$39/BT124)/10^($E$39/$E$40)*Q124^4.33),0)","v":0},{"$f":"IF(AU124>0,1/(((18+1)/(AU124/1000+T124))^4.79*10^($E$39/BU124)/10^($E$39/$E$40)*T124^4.33),0)","v":0},{"$f":"SUM(BV124:BZ124)","v":0.64013867980428929}]
[null,null,null,null,null,null,"W3 - Waste - Rear Load",6,0.64089661187135705,0.18900458246016152,1,1.2206685583806203,1,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,1.1890045824601616,null,17,"W3","Waste - Rear Load",null,12000,18000,"Dual, Single Axle",null,null,null,null,null,null,12000,14000,null,null,null,12000,10000,null,null,null,"11R22.5","11R22.5",11,null,"2Ax-GarbageTruck.jpg",null,null,null,null,null,0.64089661187135705,0.782444509683766,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.35404264021645498,0,0,0,0.54304722267661654,0.64089661187135705,0.54044039327450166,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,9.0105252778641398E-2,0,0,0,0.27910983523880295]
[null,null,null,null,null,null,"W4 - Waste - Rear Load",6,1.2206685583806203,1,2,11.038707580455377,1.9136789214308114,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,2.9136789214308116,null,18,"W4","Waste - Rear Load",null,18000,40000,"Dual, Tandem Axle",null,null,null,null,null,null,16000,31000,null,null,null,16000,22000,null,null,null,"315/80R22.5","315/80R22.5",25,null,"RearLoader-2.jpg",null,null,null,null,null,0.9729855634738207,5.2819540754569658,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.61258798177886931,0.61513184934134235,0,0,0,1.2277198311202118,0.9729855634738207,2.145323653955117,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.61258798177886931,0.14161776571276394,0,0,0,0.75420574749163327]
[null,null,null,null,null,null,"W5 - Waste - Side Load",6,1.2206685583806203,1,2,14.672546289811264,2.9452320645891428,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,3.9452320645891428,null,19,"W5","Waste - Side Load",null,18000,44000,"Dual, Tandem Axle",null,null,null,null,null,null,16000,33500,null,null,null,16000,23000,null,null,null,"315/80R22.5","11R22.5",27,null,"SideLoader-2.jpg",null,null,null,null,null,0.9729855634738207,6.5806086341641086,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.61258798177886931,0.86607841396136132,0,0,0,1.4786663957402306,0.9729855634738207,2.3913146640267504,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.61258798177886931,0.17051940026554022,0,0,0,0.78310738204440955]
[null,null,null,null,null,null,"W6 - Recycle",6,0.64089661187135705,0.18900458246016152,1,1.7177072121296426,1.922610227336119,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,2.1116148097962806,null,20,"W6","Recycle",null,12000,21000,"Dual, Single Axle",null,null,null,null,null,null,12000,16500,null,null,null,12000,12000,null,null,null,"11R22.5","11R22.5",null,null,"Recycle-1.jpg",null,null,null,null,null,0.64089661187135705,1.0292258573028601,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.69578557660266194,0,0,0,0.88479015906282343,0.64089661187135705,0.64089661187135705,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.18900458246016152,0,0,0,0.37800916492032305]
[null,null,null,null,null,null,"W7 - Recycle",6,0.7060463604200784,0.26171676481536849,1,2.3913146640267504,3.4295226679876003,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,3.691239432802969,null,21,"W7","Recycle",null,13000,24000,"Dual, Single Axle",null,null,null,null,null,null,12000,18000,null,null,null,12000,12000,null,null,null,"11R22.5","11R22.5",null,null,"Recycle-1a.jpg",null,null,null,null,null,0.64089661187135705,1.2206685583806203,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,1,0,0,0,1.1890045824601616,0.64089661187135705,0.64089661187135705,0.40211297966083381,0.40211297966083381,0.40211297966083381,0.18900458246016152,0.18900458246016152,0,0,0,0.37800916492032305]
[null,null,null,null,null,null,"W8 - Recycle",6,0.64089661187135705,0.18900458246016152,1,1.5338666608015639,1.560712685742603,3,0.40211297966083381,0,3,0.40211297966083381,0,3,0.40211297966083381,0,1.7497172682027646,null,22,"W8","Recycle",null,12000,20000,"Dual, Single Axle",null,null,null,null,null,null,10000,15000,null,null,null,10000,10000,null,null,null,"11R22.5","11R22.5",null,null,"Recycle-1b.jpg",null,null,null,null,null,0.54044039327450166,0.87108709561177999,0.40211297966083381,0.40211297966083381,0.40211297966083381,9.0105252778641398E-2,0.4696192795387491,0,0,0,0.5597245323173905,0.54044039327450166,0.54044039327450166,0.40211297966083381,0.40211297966083381,0.40211297966083381,9.0105252778641398E-2,9.0105252778641398E-2,0,0,0,0.1802105055572828]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"ESALs per truck",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number","Type","Truck type",null,"Front Axle Wt","Rear Axle Wt","Rear Axle Type","Rear Axle Wt","Rear Axle Type","Rear Axle Wt","Rear Axle Type","Rear Axle Wt","Rear Axle Type","Front Tire Type","Rear Tire Type","Capacity, cy",null,"Picture File List"]
[null,null,null,null,null,null,null,null,"Bx-Front","ESAL-Front","Rear Axle Type2","Bx-Rear2","ESAL-Rear2","Rear Axle Type3","Bx-Rear3","ESAL-Rear3","Rear Axle Type4","Bx-Rear4","ESAL-Rear4","Rear Axle Type5","Bx-Rear5","ESAL-Rear5","Truck ESAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Trucks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NumCustomTypes",2]
[null,null,null,null,null,null,"List",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number","Type","Truck type",null,"Front Axle Wt","Rear Axle Wt2","Rear Axle Typ2","Rear Axle Wt3","Rear Axle Typ3","Rear Axle Wt4","Rear Axle Typ4","Rear Axle Wt5","Rear Axle Typ5","Front Tire Type","Rear Tire Type","Capacity, cy",null,"Picture File List"]
[null,null,null,null,null,null,{"$f":"Z225 & \" - \" & AA225","v":"C0 - Create New Vehicle"},null,{"$f":"0.4+(0.081*(AC225/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":0.40117257300572873},{"$f":"IF(AC225>0,1/(((18+1)/(AC225/1000+1))^4.79*10^($E$39/I225)/10^($E$39/$E$40)*1^4.33),0)","v":8.5063470167276621E-5},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AE225)),IF(ISERROR(SEARCH(\"Single\",AE225)),3,1),2)","v":1},{"$f":"0.4+(0.081*(AD225/1000+K225)^3.23)/($E$36+1)^5.19","v":0.40782834727746059},{"$f":"IF(AD225>0,1/(((18+1)/(AD225/1000+K225))^4.79*10^($E$39/L225)/10^($E$39/$E$40)*K225^4.33),0)","v":1.4089000904755988E-3},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AG225)),IF(ISERROR(SEARCH(\"Single\",AG225)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AF225/1000+N225)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AF225>0,1/(((18+1)/(AF225/1000+N225))^4.79*10^($E$39/O225)/10^($E$39/$E$40)*N225^4.33),0)","v":0},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AI225)),IF(ISERROR(SEARCH(\"Single\",AI225)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AH225/1000+Q225)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AH225>0,1/(((18+1)/(AH225/1000+Q225))^4.79*10^($E$39/R225)/10^($E$39/$E$40)*Q225^4.33),0)","v":0},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AK225)),IF(ISERROR(SEARCH(\"Single\",AK225)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AJ225/1000+T225)^3.23)/($E$36+1)^5.19","v":0.40211297966083381},{"$f":"IF(AJ225>0,1/(((18+1)/(AJ225/1000+T225))^4.79*10^($E$39/U225)/10^($E$39/$E$40)*T225^4.33),0)","v":0},{"$f":"J225+M225+P225+S225+V225","v":1.4939635606428755E-3},null,0,"C0","Create New Vehicle",null,1500,3500,"Dual, Single Axle",null,null,null,null,null,null,"225/65R17","225/65R17",4,null,"SampleTruck.jpg"]
[null,null,null,null,null,null,{"$f":"Z226 & \" - \" & AA226","v":"C1 - Front Load"},null,1.5338666608015639,1.560712685742603,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AE226)),IF(ISERROR(SEARCH(\"Single\",AE226)),3,1),2)","v":2},16.775812632637177,3.6049151219772075,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AG226)),IF(ISERROR(SEARCH(\"Single\",AG226)),3,1),2)","v":3},0.40211297966083381,0,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AI226)),IF(ISERROR(SEARCH(\"Single\",AI226)),3,1),2)","v":3},0.40211297966083381,0,{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AK226)),IF(ISERROR(SEARCH(\"Single\",AK226)),3,1),2)","v":3},0.40211297966083381,0,{"$f":"J226+M226+P226+S226+V226","v":5.1656278077198108},null,1,"C1","Front Load",null,20000,46000,"Dual, Tandem Axle",null,null,null,null,null,null,"425/65R22.5","11R22.5",40,null,"FrontLoader-2.jpg"]
[null,null,null,null,null,null,{"$f":"Z227 & \" - \" & AA227","v":"C4 - Wind Turbine Truck"},null,{"$f":"0.4+(0.081*(AC227/1000+1)^3.23)/(($E$36+1)^5.19*1^3.23)","v":1.2206685583806203},{"$f":"IF(AC227>0,1/(((18+1)/(AC227/1000+1))^4.79*10^($E$39/I227)/10^($E$39/$E$40)*1^4.33),0)","v":1},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AE227)),IF(ISERROR(SEARCH(\"Single\",AE227)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AD227/1000+K227)^3.23)/($E$36+1)^5.19","v":11.8788075686317},{"$f":"IF(AD227>0,1/(((18+1)/(AD227/1000+K227))^4.79*10^($E$39/L227)/10^($E$39/$E$40)*K227^4.33),0)","v":0.36963568918565026},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AG227)),IF(ISERROR(SEARCH(\"Single\",AG227)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AF227/1000+N227)^3.23)/($E$36+1)^5.19","v":11.8788075686317},{"$f":"IF(AF227>0,1/(((18+1)/(AF227/1000+N227))^4.79*10^($E$39/O227)/10^($E$39/$E$40)*N227^4.33),0)","v":0.36963568918565026},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AI227)),IF(ISERROR(SEARCH(\"Single\",AI227)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AH227/1000+Q227)^3.23)/($E$36+1)^5.19","v":11.8788075686317},{"$f":"IF(AH227>0,1/(((18+1)/(AH227/1000+Q227))^4.79*10^($E$39/R227)/10^($E$39/$E$40)*Q227^4.33),0)","v":0.36963568918565026},{"$f":"IF(ISERROR(SEARCH(\"Tandem\",AK227)),IF(ISERROR(SEARCH(\"Single\",AK227)),3,1),2)","v":3},{"$f":"0.4+(0.081*(AJ227/1000+T227)^3.23)/($E$36+1)^5.19","v":11.8788075686317},{"$f":"IF(AJ227>0,1/(((18+1)/(AJ227/1000+T227))^4.79*10^($E$39/U227)/10^($E$39/$E$40)*T227^4.33),0)","v":0.36963568918565026},{"$f":"J227+M227+P227+S227+V227","v":2.478542756742601},null,4,"C4","Wind Turbine Truck",null,18000,40000,"Tridem",40000,"Tridem",40000,"Tridem",40000,"Tridem"]