{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","_@RISKFitInformation","Deterministic","Stochastic","Background","DataSource","UserManual"],"not_rendered":{"charts":7,"images":60,"macros":1,"external_links":0,"defined_names":136,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,3,6,18]]}
[null,null,null,"Maintenance Equipment Life-Cycle Cost Analysis Tool (E-L-T)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Instructions:"]
[null,null,null,"* This tool is developed for Iowa counties to support equipment management decisions"]
[null,null,null,"* This tool adopts the life-cycle cost analysis method and uses historical equipment performance data for future cost estimation"]
[null,null,null,"*  Inputs include equipment usage and current ownership and operating costs, and the outputs include future costs and optimum replacement time"]
[null,null,null,"* This tool works for two types of equipment, motor graders and trucks, which are the most common types of equipment in Iowa counties"]
[null,null,null,"* This tool considers two acquisition options, purchasing and leasing"]
[null,null,null,"* This tool has two modules, deterministic analysis and stochastic analysis"]
[null,null,null,"* The deterministic analysis receives predetermined and constant input variables and yields one-point estimations "]
[null,null,null,"* The stochastic analysis considers uncertainties associated with inputs and provides a range of values and confidence intervals for results"]

{"sheet":"_@RISKFitInformation","index":1,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Created By Version","7.6.0"]
["Required Version","5.0.0"]
["Recommended Version","5.0.0"]
["Modified By Version","7.6.0"]
[]
[]
[]
[]
["Count",2]
["GUID","Name","Range","CRC","Options","Comp. Graph Serialization","PP Graph Serialization","QQ Graph Serialization","Unsued","Fixed Params","Bootstrap Options","BootstrapParamGraphSerialization","BatchFit Options","BootstrapGOFGraphSerialization","FitSelector"]
["FIT_CE167_35E8B","Dataset 1",{"$f":"Background!#REF!","v":{"$error":"#REF!"}},0,"F1\t0\t0\t-1E+300\t 1E+300\t 1\t0\t0\t 0\t0\t 1\t25\tBetaGeneral\tBinomial\tExpon\tExtValue\tExtValueMin\tGamma\tGeomet\tIntUniform\tInvGauss\tKumaraswamy\tLaplace\tLevy\tLogistic\tLogLogistic\tLognorm\tNegBin\tNormal\tPareto\tPearson5\tPearson6\tPoisson\tReciprocal\tTriang\tUniform\tWeibull\t0\t1\t-1\t1\t 0\t 1\t0\t0\t0","GF1_rK0qDwEAEAC2AQwjACYANABxAIUAhgCUAKIAkAGyAawBKgD//wAAAAAAAQQAAAAAAAAAAAEcRml0IENvbXBhcmlzb24gZm9yIERhdGFzZXQgMQEbUmlza05vcm1hbCgxMDU3NjQuNCwxOTcwLjApAQEQAAIAAQpTdGF0aXN0aWNzAwEBAP8BAQEBAQABAQEABAAAAAEBAQEBAAEBAQAEAAAACsEAAdAAAOAAAPYAAAwBACIBADgBAE4BAGQBAHoBAA0ABUlucHV0AAAlAQECAA4ABk5vcm1hbAABLwEAAgAUAAxVbnVzZWQgQ3VydmUAAk8BAAIAFAAMVW51c2VkIEN1cnZlAAOMAQACABQADFVudXNlZCBDdXJ2ZQAETAEAAgAUAAxVbnVzZWQgQ3VydmUABTkBAAIAFAAMVW51c2VkIEN1cnZlAAZOAQACABQADFVudXNlZCBDdXJ2ZQAHIwEAAgAUAAxVbnVzZWQgQ3VydmUACCkBAAIAFAAMVW51c2VkIEN1cnZlAAlgAQACAJgBogEBAQIBmpmZmZmZqT8AAGZmZmZmZu4/AAAFAAEBAQABAQEA",null,null,null," 0\t 8\t\t\t\t\t\t\t\t","F1\t0\t 1000\t .95",null,null,null,1,true]

{"sheet":"Deterministic","index":2,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[[16,13,18,14],[19,13,20,14],[1,0,1,1],[1,3,1,6],[16,7,16,8],[15,0,15,10],[16,0,16,6]]}
[null,null,null,null,"Life cycle cost analysis Inputs"]
["General data",null,null,"Equipment  data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Examples:"]
["Years to simulate",15,null,"Purchasing option",null,"Leasing option"]
["Inflation rate (%)",0.04,null,"Type",null,"Type"]
["Insurance and mis.($)",8000,null,"Acquisition year",null,"Acquisition year"]
[null,null,null,"Model description","CAT 140 H","Model description"]
[null,null,null,"Estimated working hours/ year",1800,"Estimated mileage/ year",null,null,null,"Result Buttons"]
[null,null,null,"Purchase price ($)",176500,"Down payment ($)"]
[null,null,null,"Cumulative hours",15036,"Annual payment ($)"]
[null,null,null,"Total operating cost ($)",239789,"Total years of payment"]
[null,null,null,null,null,"Years of warranty"]
[null,null,null,null,null,"Residual value($) (end of lease)"]
[null,null,null,null,null,"Cumulative mileage"]
[null,null,null,null,null,"Total operating cost ($)"]
[null,null,null,null,"Life cycle cost analysis Outputs"]
["Purchasing option LCCA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Results and graphs"]
["Ownership",null,null,null,null,null,null,"Operation",null,"Total ","Cumulative ",null,null,"The Optimum year for replacement (Purchasing op.)"]
["Year","Cumulative hours","Purchase price","Trade-in value","Ins. and misc.","Total ownership cost","Own. cost/ hr","Oper. cost","Oper. cost/ hr","cost/ hr","LCC"]
[2019,16836,176500,33499.699999999997,128000,{"$f":"C19+E19-D19","v":271000.3},{"$f":"F19/B19","v":16.096477785697314},285952.74555683136,{"$f":"H19/B19","v":16.984601185366557},{"$f":"I19+G19","v":33.081078971063874},579231.16742399998]
[2020,18636,176500,32634.850000000002,136000,{"$f":"C20+E20-D20","v":279865.15000000002},{"$f":"F20/B20","v":15.017447413608071},335748.75420331955,{"$f":"H20/B20","v":18.016138345316566},{"$f":"I20+G20","v":33.033585758924637},665847.99878272007,null,null,2020]
[2021,20436,176500,31840.600000000002,144000,288659.40000000002,14.125044039929538,389176.97393894196,19.043696121498431,33.168740161427969,762473.73489064968]
[2022,22236,176500,31099.3,152000,297400.7,13.374739161719734,446237.42580413818,20.068241851238451,33.442981012958185,869951.42700948706]
[2023,24036,176500,30428.6,160000,306071.40000000002,12.733874188716925,506930.13083934784,21.090453105314854,33.824327294031775,989140.67210346309]
[2024,25836,176500,30428.6,168000,314071.40000000002,12.156347731847037,571255.04696369171,22.110816185310874,34.267163917157909,1120220.3909665914]
[2025,27636,176500,30428.6,176000,322071.40000000002,11.65405268490375,639212.1741771698,23.129692219466268,34.783744904370018,1264983.604147194]
[2026,29436,176500,30428.6,184000,330071.40000000002,11.213187933143091,710801.55456066132,24.147355434184718,35.360543367327807,1424506.5110694538]
[2027,31236,176500,30428.6,192000,338071.4,10.823133563836599,786023.14603328705,25.164014151405016,35.987147715241619,1599937.0456003665]
[2028,33036,176500,30428.6,200000,346071.4,10.47558421116358,864876.99067592621,26.179833838113762,36.655418049277344,1792499.4346647416]
[2029,34836,176500,30428.6,208000,354071.4,10.163951085084395,947363.0884885788,27.19494455415601,37.358895639240401,2003498.6023496641]
[2030,36636,176500,30428.6,216000,362071.4,9.8829402773228523,1033481.3553094864,28.209448501732897,38.092388779055753,2234324.9239461999]
[2031,38436,176500,30428.6,224000,370071.4,9.628249557706317,1123231.8753004074,29.223433117400546,38.851682675106865,2486459.7220818624]
[2032,40236,176500,30428.6,232000,378071.4,9.396346555323591,1216614.6484613419,30.236968099745052,39.633314655068645,2761480.2715082336]
[2033,42036,176500,30428.6,240000,386071.4,9.1843039299647931,1313629.6747922897,31.250111209256108,40.434415139220903,3061065.6119641857]
[]
[]
[]
[]
[2019,0]
[2020,0]
[2021,0]
[2022,0]
[2023,0]
[2024,0]
[2025,0]
[2026,0]
[2027,0]
[2028,0]
[2029,0]
[2030,0]
[2031,0]
[2032,0]
[2033,0]

{"sheet":"Stochastic","index":3,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[35,0,35,10],[36,0,36,6],[36,7,36,8],[36,10,37,10],[17,13,19,14],[20,13,21,14],[1,0,1,1],[16,0,16,10],[17,7,17,8],[17,0,17,6],[17,10,18,10],[1,4,1,9]]}
[null,null,null,null,null,"Life cycle cost analysis Inputs"]
["General data",null,null,null,"Equipment  data"]
["Item","Vale",null,null,"Item","Value",null,"Item","Value"]
["Years to simulate",15,null,null,"Purchasing option",null,null,"Leasing option"]
[null,null,null,null,"Type",null,null,"Type"]
[null,null,null,null,"Acquisition year",null,null,"Acquisition year"]
[null,null,null,null,"Model description","CAT 12 M3",null,"Model description"]
[null,null,null,null,"Work hours/year",null,null,"Work hours/year",null,null,null,"Result Buttons",null,null,null,"Monte_Carlo simulation buttons"]
[null,null,null,null,"Purchase price ($)",230000,null,"Down payment ($)",10000]
[null,null,null,null,"Cumulative hours",2501,null,"Annual payment ($)",18800]
["Stochastic items","Min","Most likely","Max","Total operating cost ($)",30514,null,"Total years of payment",5]
["Inflation rate (%)",3.5000000000000003E-2,0.04,4.4999999999999998E-2,null,null,null,"Years of warranty",5,null,null,null,null,null,null,null,null,null,null,null,"Year of"]
["Insurance and mis. ($)",5000,5260,5500,null,null,null,"Residual value($) (end of lease)",156000]
["Est. hours / year (Purch.)",1700,1800,1900,null,null,null,"Cumulative mileage",4616,null,null,null,null,null,null,null,null,null,null,null,"Year of"]
["Est. mileage/ year",1700,1800,1900,null,null,null,"Total operating cost ($)",60000]
[null,null,null,null,null,"Life cycle cost analysis Outputs"]
["Purchasing option LCCA"]
["Ownership",null,null,null,null,null,null,"Operation",null,"Total ","Cumulative LCC",null,null,"The Optimum year for replacement (Purchasing op.)"]
["Year","Cumulative mileage","Purchase price","Trade-in value","Ins. and misc.","Total ownership cost","Own. cost/ miles","Operation cost","Oper. cost/ miles","cost/ miles"]
[2019,4346.819909066021,230000,93720.478787121421,16078.21672453927,152357.74,35.050391593687237,55433.916598558426,12.752752071550809,47.8,215990.44409993233]
[2020,6167.8496299840672,230000,95223.190348094387,20664.552420924327,155441.35999999999,25.201872504210439,79535.548537969589,12.895182806232819,38.1,254019.2260045867,null,null,2026]
[2021,7904.3850883488203,230000,79009.712022499807,26728.393621592193,177718.68,22.483555395341245,112363.96208405495,14.215395738452335,36.700000000000003,328178.74220596609]
[2022,9326.7422168786034,230000,77621.548300774462,32252.224933192083,184630.68,19.795838215178058,141538.10694813728,15.175513979989555,34.97,380240.86201788927]
[2023,11661.878579352111,230000,70669.267652092924,35720.196314708104,195050.93,16.725515419560839,194718.74967217445,16.69703113225329,33.42,468316.88779014972]
[2024,13481.488226868334,230000,65721.738411777216,42031.732915209155,206309.99,15.303205887079168,245096.29920125008,18.180210899233515,33.479999999999997,575458.25253469334]
[2025,15200.371652837975,230000,50096.014109729527,47679.1067327973,227583.09,14.972205627453144,312120.04378437996,20.533711341309594,35.51,733852.28546760138]
[2026,17333.680686894339,230000,59126.656975822531,52892.440596543667,223765.78,12.909305533081902,388342.18934178352,22.40390810900411,35.31,829944.64214946574]
[2027,18090.012834842622,230000,58411.209130212119,60075.65209826886,231664.44,12.806206502728299,454497.84830212593,25.124241339652649,37.93,1018873.0040646583]
[2028,20407.835596476878,230000,52234.237503692406,64103.0183311359,241868.78,11.851760509172037,536281.07741475105,26.278194709319454,38.130000000000003,1144094.3488837755]
[2029,22353.44710109384,230000,51355.343744538564,69284.757917043127,247929.41,11.091327833185419,589090.3277695179,26.353444510630915,37.44,1301070.9956709326]
[2030,23705.210993425731,230000,45859.080446781954,76077.164628058221,260218.08,10.977252219867074,650241.49134755135,27.430318653579345,38.409999999999997,1439511.5858444781]
[2031,26124.791446742263,230000,43169.283098309039,78464.769395143318,265295.49,10.154932357673696,705771.00470662117,27.015373735663218,37.17,1554293.8825705003]
[2032,28402.048383471156,230000,42527.174066732427,83067.268153381825,270540.09000000003,9.5253724783260143,796000.91174244881,28.026179694956102,37.549999999999997,1881320.6034168762]
[2033,29247.259318947024,230000,45332.858552167461,89494.885167576926,274162.03000000003,9.3739391787179098,955323.15209507942,32.663681122460602,42.04,2289164.2005477445]
[]
["Leasing option LCCA"]
["Ownership",null,null,null,null,null,null,"Operation",null,"Total ","Cumulative LCC"]
["Year","Cumulative mileage","Residual or Salvage value","Total payments","Ins. and misc.","Total ownership cost","Own. cost/ miles","Operation cost","Oper. cost/ miles","cost/ miles"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Purchasing results:","Monte-Carlo simulation's Bar chart (the optimum year)",null,null,null,"Probabilistic results of the LCC",null,null,"LCC histogram and the fitted normal-distribution "]

{"sheet":"Background","index":4,"n_rows":505,"n_cols":79,"rows_kept":505,"cut":false,"hidden":true,"merged":[[27,1,27,5],[69,1,69,5]]}
[null,null,"Minimum","Most likely","Maximum",null,null,"Probabilistic",null,null,null,null,null,null,"Formula","Grader:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,72,73,74,75]
[null,null,"a","b","c",null,"alpha","beta","Prob. Func.",null,null,null,null,null,null,"Truck:"]
["Grader Salvage value",1,0.5444,0.70689999999999997,0.70940000000000003,null,{"$f":"(4*D3+E3-5*C3)/(E3-C3)","v":4.9393939393939377},{"$f":"(5*E3-C3-4*D3)/(E3-C3)","v":1.0606060606060619},{"$f":"_xlfn.BETA.INV(RAND(),G3,H3,C3,E3)","v":0.690729056355875},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red","Yellow","Green"]
["y = 0.6269x-0.431",2,0.38500148701249964,0.505,0.54500148701249962,null,{"$f":"(4*D4+E4-5*B4)/(E4-B4)","v":5.1099698361350647},{"$f":"(5*E4-C4-4*D4)/(E4-C4)","v":2.0000371753124915},{"$f":"_xlfn.BETA.INV(RAND(),G4,H4,C4,E4)","v":0.46697263677383621},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,2019,{"$f":"COUNTIF($AS$4:$AS$103,AU4)","v":0},null,{"$f":"IF(AV4>0,AU4,\"\")","v":""},{"$f":"IF(AV4>3,AV4/100,\"\")","v":""},null,{"$f":"IF(AY4<0.34*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18)),AY4,\"\")","v":""},{"$f":"IF(AND(AY4>0.339*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18)),AY4<0.66*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18))),AY4,\"\")","v":""},{"$f":"IF(AY4>0.661*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18)),AY4,\"\")","v":""},null,null,null,null,null,2033,null,2019,{"$f":"COUNTIF($BI$4:$BI$103,BK4)","v":0},null,{"$f":"IF(BL4>0,BK4,\"\")","v":""},{"$f":"IF(BL4>3,BL4/100,\"\")","v":""},null,712668.68]
[null,3,0.31294422987698667,0.39040000000000002,0.46794422987698669,null,5.1225000346232026,3.0011414161803023,{"$f":"_xlfn.BETA.INV(RAND(),G5,H5,C5,E5)","v":0.38988396229090011},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,2020,{"$f":"COUNTIF($AS$4:$AS$103,AU5)","v":0},null,{"$f":"IF(AV5>0,AU5,\"\")","v":""},{"$f":"IF(AV5>0,AV5/100,\"\")","v":""},null,{"$f":"IF(AY5<0.34*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18)),AY5,\"\")","v":""},{"$f":"IF(AND(AY5>0.339*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18)),AY5<0.66*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18))),AY5,\"\")","v":""},{"$f":"IF(AY5>0.661*(MAX($AY$4:$AY$18)-MIN($AY$4:$AY$18)),AY5,\"\")","v":""},null,null,null,null,null,2033,null,2020,0,null,{"$f":"IF(BL5>0,BK5,\"\")","v":""},{"$f":"IF(BL5>0,BL5/100,\"\")","v":""},null,739978.66,null,"max",{"$f":"MAX(BQ4:BQ103)","v":758897.47},null,null,"mean",{"$f":"AVERAGE(BQ4:BQ103)","v":708400.58659999981}]
[null,4,0.26991367510581571,0.34489999999999998,0.41991367510581573,null,5.0838121411589521,3.0003646694884187,0.34106660468940575,null,null,null,null,null,null,null,null,null,null,"Grader",null,null,null,null,"Cum.Hrs",null,null,0.24101702868938446,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,2021,0,null,"",{"$f":"IF(AV6>0,AV6/100,\"\")","v":""},null,"","","",null,null,null,null,null,2032,null,2021,0,null,"","",null,727106.68,null,"min",{"$f":"MIN(BQ4:BQ103)","v":635186.06999999995},null,null,"sd",{"$f":"_xlfn.STDEV.S(BQ4:BQ103)","v":25907.494797618918}]
[null,5,0.24078687302464918,0.31330000000000002,0.3857868730246492,null,5.0628379062951216,2.9996378765420459,0.32351313651529373,null,null,null,null,null,null,null,null,null,null,"Intercept","Hrs","Hrs^2",null,null,27447.259318947024,null,null,0.34580673277378082,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,2022,4,null,2022,0.04,null,0.04,"","",null,null,null,null,null,2033,null,2022,0,null,"","",null,729192.14,null,"range",{"$f":"BT5-BT6","v":123711.40000000002},null,null,"Formula",0.55500000000000005]
[null,6,0.21961101848500408,0.28960000000000002,0.3596110184850041,null,5.049649780335681,3.0003148138572597,0.33528292273473348,null,null,null,null,null,null,null,null,null,null,"B0","B1","B2",null,null,null,null,null,0.4885389655828476,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,2023,{"$f":"COUNTIF($AS$4:$AS$103,AU8)","v":17},null,2023,0.17,null,"",0.17,"",null,null,null,null,null,2033,null,2023,0,null,"","",null,640483.03,null,"number of bins",10,null,null,"alpha",3.57]
[null,7,0.20349483564485882,0.27100000000000002,0.33849483564485883,null,5.0405282794080923,2.9998469820698923,0.29251141399382624,null,null,null,null,null,null,null,null,null,"Mean",3.2309999999999999E-3,5.0700000000000002E-2,4.1999999999999997E-3,null,"Det",{"$f":"T9+U9*(Y7/1150)+V9*(Y7/1150)^2","v":3.6057951133471517},null,null,0.61538307368755341,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,2024,{"$f":"COUNTIF($AS$4:$AS$103,AU9)","v":29},null,2024,0.28999999999999998,null,"","",0.28999999999999998,null,null,null,null,null,2033,null,2024,0,null,"","",null,705459.57,null,"range of bins",{"$f":"BT7/BT8","v":12371.140000000003},null,null,"beta",69054]
[null,8,0.19083884481600011,0.25580000000000003,0.32083884481600011,null,5.0338780986629486,3.0011952251076939,0.26974834121312952,null,null,null,null,null,null,null,null,null,"SE",2.3909999999999998E-4,2.42905995290708E-3,6.2795371498172961E-5,null,null,null,null,null,0.84660325944423676,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029,null,2025,24,null,2025,0.24,null,"","",0.24,null,null,null,null,null,2032,null,2025,0,null,"","",null,673983.08,null,null,null,null,null,null,3.57]
[null,9,0.18317546122863809,0.2432,0.30317546122863809,null,5.0275849931023728,2.9991820409546039,0.2466171606786986,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.065636083483696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,2026,{"$f":"COUNTIF($AS$4:$AS$103,AU11)","v":14},null,{"$f":"IF(AV11>0,AU11,\"\")","v":2026},0.14000000000000001,null,"",0.14000000000000001,"",null,null,null,null,null,2033,null,2026,{"$f":"COUNTIF($BI$4:$BI$103,BK11)","v":0},null,{"$f":"IF(BL11>0,BK11,\"\")","v":""},"",null,697857.99]
[null,10,0.1773797444854969,0.2324,0.28737974448549691,null,5.0226426002619755,2.9992634358362502,0.24954797066737258,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.NORM.INV(RAND(),T9,T10)","v":3.0315465589210782E-3},{"$f":"_xlfn.NORM.INV(RAND(),U9,U10)","v":5.3233069509034101E-2},{"$f":"_xlfn.NORM.INV(RAND(),V9,V10)","v":4.1632571932328439E-3},null,"Stoch",{"$f":"IF(T12+U12*(Y7/1150)+V12*(Y7/1150)^2<0,0,T12+U12*(Y7/1150)+V12*(Y7/1150)^2)","v":3.6451226311391043},null,null,1.357043668627739,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,2027,{"$f":"COUNTIF($AS$4:$AS$103,AU12)","v":8},null,{"$f":"IF(AV12>0,AU12,\"\")","v":2027},0.08,null,0.08,"","",null,null,null,null,null,2033,null,2027,0,null,{"$f":"IF(BL12>0,BK12,\"\")","v":""},"",null,680099.54,null,null,null,"Freq"]
[null,11,0.17302729781699672,0.223,0.27302729781699675,null,5.0186547683884069,3.0010919126798696,0.24781903999707883,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6884443014860153,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,2028,{"$f":"COUNTIF($AS$4:$AS$103,AU13)","v":1},null,2028,0.01,null,0.01,"","",null,null,null,null,null,2033,null,2028,0,null,"","",null,683810.24,null,{"$f":"BT6","v":635186.06999999995},{"$f":"BS13+$BT$9","v":647557.21},1]
[null,12,0.16981823935353552,0.21479999999999999,0.25981823935353554,null,5.0153381745773098,3.0008106379349133,0.21589867815806751,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.976077601313591,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,2029,3,null,2029,0.03,null,0.03,"","",null,null,null,null,null,2033,null,2029,{"$f":"COUNTIF($BI$4:$BI$103,BK14)","v":0},null,"","",null,699432.56,null,{"$f":"BS13+$BT$9","v":647557.21},{"$f":"BS14+$BT$9","v":659928.35},2,null,null,null,null,null,"RiskWeibull(3.5732,69054,RiskShift(416377))"]
[null,13,0.16753372679088213,0.20749999999999999,0.24753372679088215,null,5.0125571715880515,3.0016863395441082,0.222651908638554,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3316568583250046,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,2030,0,null,"","",null,"","","",null,null,null,null,null,2033,null,2030,0,null,"","",null,696670.43,null,{"$f":"BS14+$BT$9","v":659928.35},{"$f":"BS15+$BT$9","v":672299.49},6]
[null,14,0.16600973288812776,0.20100000000000001,0.23600973288812777,null,5.0101742974845838,3.000556165035869,0.2187901496208722,null,null,null,null,null,null,null,null,null,null,"Truck",null,null,null,null,"Cum.Mileage",null,null,2.5612622946500778,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,2031,0,null,"","",null,"","","",null,null,null,null,null,2033,null,2031,0,null,"","",null,720699.27,null,672299.49,{"$f":"BS16+$BT$9","v":684670.63},9]
[null,15,0.16512051661936267,0.1951,0.22512051661936267,null,5.008127448119799,3.0013677746241769,0.21110407318775024,null,null,null,null,null,null,null,null,null,null,"Intercept","Mile","Mile^2",null,null,30098.091970477632,null,null,2.8271369189023972,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,null,2032,0,null,"","",null,"","","",null,null,null,null,null,2033,null,2032,9,null,2032,0.09,null,715704.51,null,684670.63,697041.77,10]
[null,16,0.1647678150821506,0.1898,0.21476781508215059,null,5.0063268793995972,2.997425206572049,0.20159436285481502,null,null,null,null,null,null,null,null,null,null,"B0","B1","B2",null,null,null,null,null,3.0685695856809616,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,2033,{"$f":"COUNTIF($AS$4:$AS$103,AU18)","v":0},null,"","",null,"","","",null,null,null,null,null,2033,null,2033,91,null,2033,0.91,null,731120.6,null,697041.77,709412.91,20]
[null,17,0.16487355168766302,0.18490000000000001,0.204873551687663,null,5.0047569875104259,2.9973551687663011,0.18832803250563118,null,null,null,null,null,null,null,null,null,"Mean",2.1789999999999999E-3,6.1600000000000002E-2,3.3E-3,null,"Det",{"$f":"T19+U19*(Y17/18000)+V19*(Y17/18000)^2","v":0.11440806894979812},null,null,3.4608735293149948,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,"",null,710745.59999999998,null,709412.91,721784.05,20]
[null,18,0.16537478238358139,0.1804,0.19537478238358141,null,5.0033642454588181,2.9966376511441859,0.18773987921192856,null,null,null,null,null,null,null,null,null,"SE",8.4178385445037582E-4,6.9122840690978996E-3,1.3287653797199801E-4,null,null,null,null,null,4.1535789221525192,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,"",null,689790.48,null,721784.05,734155.19000000006,16]
[null,19,0.16622010992970102,0.1762,0.18622010992970103,null,5.0021303767745229,3.0040219859402058,0.17381777780388916,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.978999525308609,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,717483.46,null,734155.19000000006,746526.33000000007,9]
[null,20,0.16736708683576454,0.1724,0.17736708683576455,null,5.0010023061734579,2.9868347343058184,0.17424953315665731,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.NORM.INV(RAND(),T19,T20)","v":2.3987837228140949E-3},{"$f":"_xlfn.NORM.INV(RAND(),U19,U20)","v":6.9859342724191337E-2},{"$f":"_xlfn.NORM.INV(RAND(),V19,V20)","v":2.9827593326799172E-3},null,"Stoch",{"$f":"IF((T22+U22*(Y17/18000)+V22*(Y17/18000)^2)>0,(T22+U22*(Y17/18000)+V22*(Y17/18000)^2),0)","v":0.12755143738215591},null,null,5.4506873190402985,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,"Red","Yellow","Green",null,null,717844.77,null,746526.33000000007,758897.47000000009,6]
[null,null,null,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.9429539740085602,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,{"$f":"BN4","v":""},{"$f":"IF(BO4<0.34*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO4,\"\")","v":""},{"$f":"IF(AND(BO4>0.339*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO4<0.66*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18))),BO4,\"\")","v":""},{"$f":"IF(BO4>0.661*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO4,\"\")","v":""},null,null,747199.77]
[null,null,null,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.4558004438877106,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,{"$f":"BN5","v":""},{"$f":"IF(BO5<0.34*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO5,\"\")","v":""},{"$f":"IF(AND(BO5>0.339*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO5<0.66*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18))),BO5,\"\")","v":""},{"$f":"IF(BO5>0.661*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO5,\"\")","v":""},null,null,731810.55]
[null,null,null,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.989225298166275,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,727893.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3481856882572174,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,673938.51,null,"Binc Center",null,"NormalDist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5700191557407379,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,null,"","","","",null,null,684350.28,null,{"$f":"AVERAGE(BS13:BT13)","v":641371.6399999999},{"$f":"BU13","v":1},{"$f":"_xlfn.NORM.DIST(BS27,$BX$5,$BX$6,FALSE)","v":5.4192647870524584E-7},{"$f":"BU27*$BT$9*100","v":0.6704248337769616}]
[null,"**Please modify just this column**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7984522879123688,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,745796.12,null,{"$f":"AVERAGE(BS14:BT14)","v":653742.78},{"$f":"BU14","v":2},{"$f":"_xlfn.NORM.DIST(BS28,$BX$5,$BX$6,FALSE)","v":1.6633025564340605E-6},{"$f":"BU28*$BT$9*100","v":2.0576948788003668}]
[null,null,null,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.0334855616092682,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,743448,null,{"$f":"AVERAGE(BS15:BT15)","v":666113.91999999993},6,4.0642021375645005E-6,5.0278813632109705]
[null,null,null,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.2751189768314362,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,693647.17,null,{"$f":"AVERAGE(BS16:BT16)","v":678485.06},9,7.9059216498843406E-6,9.7805263559750184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1666.3034133911133,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,729086.83,null,690856.2,10,1.2243423537930999E-5,15.146510666703975]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1745.5760345458984,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,666116.47,null,703227.34000000008,20,1.5094766587309098E-5,18.673947071892314]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1826.0585632324219,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,735628.34,null,715598.48,20,1.4815731250974745E-5,18.328748550818375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,null,{"$f":"Q34","v":0},null,null,null,null,null,null,null,null,null,-1907.7601547241211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"","","","",null,null,696307.04,null,727969.62000000011,16,1.1576917607730259E-5,14.321966849369613]
[null,null,"Minimum","Most likely","Maximum",null,null,"Probabilistic",null,null,null,null,null,null,null,2019,null,{"$f":"Q35+R34","v":0},null,null,null,null,null,null,null,null,null,-1990.6899490356445,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,"",{"$f":"IF(BO16<0.34*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO16,\"\")","v":""},"","",null,null,735751.64,null,740340.76,9,7.2017153964152854E-6,8.9093429409209008]
["Trucks salvage value",null,"a","b","c",null,"alpha","beta","Prob. Func.",null,null,null,null,null,null,2020,null,{"$f":"Q36+R35","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,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,2032,{"$f":"IF(BO17<0.34*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO17,\"\")","v":0.09},"","",null,null,704358.93,null,752711.90000000014,6,3.5665812972290755E-6,4.4122676549402513]
["y = 1.0583x-0.672",1,0.69,0.74,0.81,null,{"$f":"(4*D37+E37-5*B37)/(E37-B37)","v":6.4736842105263177},0.8,{"$f":"_xlfn.BETA.INV(RAND(),G37,H37,C37,E37)","v":0.79719312309844248},null,null,null,null,null,null,2021,null,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,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,{"$f":"BN18","v":2033},{"$f":"IF(BO18<0.34*(MAX($BO$4:$BO$18)-MIN($BO$4:$BO$18)),BO18,\"\")","v":""},"",0.91,null,null,703608.39]
[null,2,0.60622717418721073,0.62,0.72222717418721083,null,5.3200167420126006,{"$f":"(5*E38-B38-4*D38)/(E38-B38)","v":0.67998325798739934},{"$f":"_xlfn.BETA.INV(RAND(),G38,H38,C38,E38)","v":0.72150028799221388},null,null,null,null,null,null,2022,null,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,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,708394.1]
[null,3,0.4498052269029264,0.50580000000000003,0.56180522690292645,null,5.0918798244026862,{"$f":"(5*E39-B39-4*D39)/(E39-B39)","v":0.90812017559731417},0.56113665960036008,null,null,null,null,null,null,2023,null,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,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,732729.76,null,"95% confidence",{"$f":"_xlfn.NORM.INV(95%,BX5,BX6)","v":751014.62338308967}]
[null,4,0.36289288380301155,0.41689999999999999,0.47089288380301153,null,5.0611972173416993,{"$f":"(5*E40-B40-4*D40)/(E40-B40)","v":0.93880278265830042},0.4448463134338479,null,null,null,null,null,null,2024,null,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,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,739934.62,null,"75% confidence",{"$f":"_xlfn.NORM.INV(75%,BX5,BX6)","v":725874.92629425204}]
[null,5,0.30684008693003417,0.35880000000000001,0.41084008693003415,null,5.0453591401614251,{"$f":"(5*E41-B41-4*D41)/(E41-B41)","v":0.95464085983857438},0.37479742863064758,null,null,null,null,null,null,2025,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,708572.71,null,"50% confidence",{"$f":"_xlfn.NORM.INV(50%,BX5,BX6)","v":708400.58659999981}]
[null,6,0.26746156718780284,0.3175,0.36746156718780282,null,5.0354806755666353,{"$f":"(5*E42-B42-4*D42)/(E42-B42)","v":0.9645193244333653},0.34556295743034404,null,null,null,null,null,null,2026,null,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,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,733579.08,null,"25% confidence",{"$f":"_xlfn.NORM.INV(25%,BX5,BX6)","v":690926.24690574757}]
[null,7,0.23822193486855991,0.28620000000000001,0.33422193486856,null,{"$f":"(4*D43+E43-5*B43)/(E43-B43)","v":5.0288170019459608},{"$f":"(5*E43-B43-4*D43)/(E43-B43)","v":0.97118299805403852},0.32158979962150147,null,null,null,null,null,null,2027,null,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,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,755115.55]
[null,8,0.21565698020148494,0.26169999999999999,0.30765698020148502,null,5.023897519953648,0.97610248004635203,0.28683838608062967,null,null,null,null,null,null,2028,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,666153.43000000005]
[null,9,0.1977451833717479,0.2417,0.28574518337174803,null,5.020217532903767,0.97978246709623296,0.24367727002013267,null,null,null,null,null,null,2029,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,710868.4]
[null,10,0.18322095523635029,0.22520000000000001,0.26722095523635037,null,5.0172698691886808,0.98273013081131921,0.26160628822884785,null,null,null,null,null,null,2030,null,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,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,711194.7]
[null,11,0.17124814872758609,0.2112,0.25124814872758616,null,5.0149033671189818,0.98509663288101845,0.24692834164737104,null,null,null,null,null,null,2031,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,699080.09]
[null,12,0.16125030679977093,0.1993,0.23725030679977099,null,5.0129052501463018,0.98709474985369827,0.22776464600941149,null,null,null,null,null,null,2032,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,730725.25]
[null,13,0.15281603058859719,0.1888,0.22481603058859731,null,5.0112768726226822,0.98872312737731738,0.20604978535486215,null,null,null,null,null,null,2033,null,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,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,708272.59]
[null,14,0.1456431890656141,0.17960000000000001,0.21364318906561422,null,5.0098773561521677,0.99012264384783277,0.19844189185718825,null,null,null,null,null,null,2034,null,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,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,680693.04]
[null,15,0.13950448038506261,0.17150000000000001,0.20350448038506272,null,5.0086519082420935,0.99134809175790672,0.19736587919348964,null,null,null,null,null,null,2035,null,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,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,729622.12]
[null,16,0.13422533928526048,0.16420000000000001,0.1942253392852607,null,5.0075985745538656,0.9924014254461343,0.1923522082301285,null,null,null,null,null,null,2036,null,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,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,691420.91]
[null,17,0.12966929326859383,0.15770000000000001,0.18566929326859405,null,{"$f":"(4*D53+E53-5*B53)/(E53-B53)","v":5.0066536798297641},{"$f":"(5*E53-B53-4*D53)/(E53-B53)","v":0.99334632017023505},0.18243712181614771,null,null,null,null,null,null,2037,null,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,2029,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,729218.23]
[null,18,0.12572797885702083,0.1517,0.17772797885702105,null,5.0058416746924612,0.994158325307538,0.15533704234327328,null,null,null,null,null,null,2038,null,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,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,657074.64]
[null,19,0.12231416604778603,0.14630000000000001,0.17031416604778624,null,5.0051013418406551,0.99489865815934408,0.16889889607455411,null,null,null,null,null,null,2039,null,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,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,698287.22]
[null,20,0.11935677847905621,0.1414,0.16335677847905641,null,5.0044275189574883,0.99557248104251117,0.16046236379718096,null,null,null,null,null,null,2040,null,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,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,673209.06]
[null,21,0.11679726987695976,0.1368,0.15679726987695997,null,5.0038376577987336,0.99616234220126654,0.15056631552708793,null,null,null,null,null,null,2041,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,688401.08]
[null,22,0.1145869421540244,0.1326,0.1505869421540246,null,5.0032928925104585,0.99670710748954139,0.15049072386491871,null,null,null,null,null,null,2042,null,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,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,730511.74]
[null,23,0.11268492990558923,0.12870000000000001,0.14468492990558943,null,5.0027975864443901,0.99720241355561023,0.14163773754836334,null,null,null,null,null,null,2043,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,708522.14]
[null,24,0.11105666469011294,0.12509999999999999,0.13905666469011313,null,5.0023396668763649,0.99766033312363478,0.13684948205124664,null,null,null,null,null,null,2044,null,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,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,728619.26]
[null,25,0.10967269015208767,0.12167269015208776,0.13367269015208785,null,5.0019303212493709,0.99806967875062957,0.12995062449012701,null,null,null,null,null,null,2045,null,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,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,705998.15]
[null,26,0.10850773735151628,0.11850773735151643,0.12850773735151658,null,{"$f":"(4*D62+E62-5*B62)/(E62-B62)","v":5.0015461033168833},{"$f":"(5*E62-B62-4*D62)/(E62-B62)","v":0.99845389668311668},0.12836889498197274,null,null,null,null,null,null,2046,null,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,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,716993.68]
[null,27,0.10753999558540731,0.11553999558540731,0.12353999558540732,null,{"$f":"(4*D63+E63-5*B63)/(E63-B63)","v":5.001190632992393},{"$f":"(5*E63-B63-4*D63)/(E63-B63)","v":0.99880936700760647},0.12270505407490312,null,null,null,null,null,null,2047,null,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,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,716617.87]
[null,28,0.10675053182937888,0.11275053182937889,0.11875053182937889,null,{"$f":"(4*D64+E64-5*B64)/(E64-B64)","v":5.0008607935604674},{"$f":"(5*E64-B64-4*D64)/(E64-B64)","v":0.99913920643953213},0.11694132684102539,null,null,null,null,null,null,2048,null,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,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,749564.29]
[null,29,0.10612282440216879,0.11012282440216878,0.11412282440216877,null,{"$f":"(4*D65+E65-5*B65)/(E65-B65)","v":5.0005539038992222},{"$f":"(5*E65-B65-4*D65)/(E65-B65)","v":0.99944609610077828},0.11367202020987155,null,null,null,null,null,null,2049,null,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,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,null,null,null,null,null,null,null,658648.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2050,null,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,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,744139.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,717885.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,695867.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,720447.78]
[null,"**Please modify just this column**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,null,null,null,null,null,null,null,713034.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,705987.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,758897.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,703064.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,707145.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,738686.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,null,null,null,null,null,null,null,755151.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,723395.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2028,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,711849.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,null,null,null,null,null,null,null,701720.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,704700.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,null,null,null,null,null,null,null,660708.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,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,686202.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,682407.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,691449.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,693621.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,710161.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,734537.21]
["Rigid-Frame","Truck","(0-99,999","lbs)",0.55110000000000003,0.50900000000000001,0.46960000000000002,0.43319999999999997,0.39960000000000001,0.36880000000000002,0.34100000000000003,0.31590000000000001,0.29380000000000001,0.27450000000000002,0.25800000000000001,0.2445,0.23369999999999999,0.22589999999999999,0.22090000000000001,0.21870000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,713559.38]
["Rigid-Frame","Truck","(100,000+","lbs)",0.60529999999999995,0.55820000000000003,0.51339999999999997,0.47070000000000001,0.43020000000000003,0.39200000000000002,0.35589999999999999,0.32200000000000001,0.2903,0.26090000000000002,0.2336,0.20849999999999999,0.1857,0.16500000000000001,0.14649999999999999,0.1303,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,704417.95]
["Articulated","Truck","(0-49,999","lbs)",0.5444,0.4783,0.41789999999999999,0.36330000000000001,0.3145,0.27150000000000002,0.23419999999999999,0.20280000000000001,0.17710000000000001,0.15720000000000001,0.14299999999999999,0.13469999999999999,0.1321,0.1321,0.1321,0.1321,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,721567.32]
["Articulated","Truck","(50,000+","lbs)",0.52039999999999997,0.45500000000000002,0.39550000000000002,0.34210000000000002,0.29459999999999997,0.25309999999999999,0.2177,0.18820000000000001,0.1648,0.14729999999999999,0.1358,0.13039999999999999,0.13039999999999999,0.13039999999999999,0.13039999999999999,0.13039999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,675884.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,635186.06999999995]
["Min",null,null,null,{"$f":"MIN(E88:E91)","v":0.52039999999999997},{"$f":"MIN(F88:F91)","v":0.45500000000000002},0.39550000000000002,0.34210000000000002,0.29459999999999997,0.25309999999999999,0.2177,0.18820000000000001,0.1648,0.14729999999999999,0.1358,0.13039999999999999,0.13039999999999999,0.13039999999999999,0.13039999999999999,0.1303,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,725819.48]
["F",null,null,null,{"$f":"_xlfn.QUARTILE.INC(E88:E91, 1)","v":0.53839999999999999},{"$f":"_xlfn.QUARTILE.INC(F88:F91, 1)","v":0.47247499999999998},0.4123,0.35799999999999998,0.30952499999999999,0.26690000000000003,0.230075,0.19914999999999999,0.17402500000000001,0.154725,0.14119999999999999,0.13362499999999999,0.13167499999999999,0.13167499999999999,0.13167499999999999,0.13037499999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,728963.55]
["Med",null,null,null,{"$f":"_xlfn.QUARTILE.INC(E88:E91, 2)","v":0.54774999999999996},{"$f":"_xlfn.QUARTILE.INC(F88:F91, 2)","v":0.49365000000000003},0.44374999999999998,0.39824999999999999,0.35704999999999998,0.32015000000000005,0.28760000000000002,0.25935000000000002,0.23370000000000002,0.20905000000000001,0.1883,0.17159999999999997,0.15889999999999999,0.14855000000000002,0.13929999999999998,0.13124999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,749070.25]
["Thir",null,null,null,{"$f":"_xlfn.QUARTILE.INC(E88:E91, 3)","v":0.56464999999999999},{"$f":"_xlfn.QUARTILE.INC(F88:F91, 3)","v":0.52129999999999999},0.48055000000000003,0.442575,0.40725,0.37460000000000004,0.344725,0.31742500000000001,0.29117500000000002,0.26430000000000003,0.2397,0.2175,0.19769999999999999,0.180225,0.1651,0.15375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,671935.01]
["Max",null,null,null,{"$f":"MAX(E88:E91)","v":0.60529999999999995},{"$f":"MAX(F88:F91)","v":0.55820000000000003},0.51339999999999997,0.47070000000000001,0.43020000000000003,0.39200000000000002,0.35589999999999999,0.32200000000000001,0.29380000000000001,0.27450000000000002,0.25800000000000001,0.2445,0.23369999999999999,0.22589999999999999,0.22090000000000001,0.21870000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,709937.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,719800.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,669389.35]
["Minimum value","MIN(cell range)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,null,null,null,null,null,null,null,697116.48]
["First quartile","QUARTILE.INC(cell range, 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,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,717296.42]
["Median value","QUARTILE.INC(cell range, 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,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,663692.07999999996]
["Third quartile","QUARTILE.INC(cell range, 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,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,null,null,null,null,null,null,null,698268.09]
["Maximum value","MAX(cell range)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]

{"sheet":"DataSource","index":5,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,0,0,6],[0,8,0,14],[1,4,22,4],[1,12,20,12],[0,16,0,20]]}
["Truck's database",null,null,null,null,null,null,null,"Grader's database",null,null,null,null,null,null,null,"Construction machinery and equipment price index"]
["Year","Number of data","Average of mileage","Average of adjusted cumulative operating cost",null,"The equipment model year","Average of  purchase  price",null,"Year","Number of data","Average of mileage","Average of adjusted cumulative operating cost",null,"The equipment model year","Average of  purchase  price",null,"Year ","Index",null,"Year ","Index"]
[1,25,21367.795666666665,11728.315621313915,null,1985,9284.7546036513086,null,1,35,1068.6434285714288,10500.397980423277,null,1998,229908.15154994262,null,1982,100,null,2001,149.9]
[2,25,41015.606666666667,18730.226866138149,null,1987,22565.911872705019,null,2,36,2050.8344444444447,40650.042321226021,null,1999,249202.00766974964,null,1983,102.35,null,2002,150.6]
[3,20,64005.308333333334,21497.075877555242,null,1989,38501.47215703009,null,3,34,3091.5051960784313,46206.303065692264,null,2000,251717.1717171717,null,1984,103.84166666666667,null,2003,153.25]
[4,19,81229.061403508778,32044.291198394109,null,1990,26104.532374100716,null,4,32,4067.2312499999998,71381.234506894922,null,2001,148432.28819212809,null,1985,105.44166666666666,null,2004,158.45833333333334]
[5,21,100628.46031746033,33712.420134969972,null,1991,24410.869999334354,null,5,29,5121.9310344827591,82502.720968553433,null,2002,259965.98605577691,null,1986,106.68333333333334,null,2005,168.30833333333334]
[6,16,122313.19791666667,58076.483231737802,null,1995,87228.032197085195,null,6,22,6110.9127272727283,98634.667516051195,null,2003,176710.91007958882,null,1987,108.93333333333334,null,2006,175.45]
[7,10,136545.26666666666,67473.839525155287,null,1998,35126.900114810567,null,7,20,7246.0726666666669,120650.31158350522,null,2005,222956.76052422108,null,1988,111.75833333333334,null,2007,179.56666666666666]
[8,7,112274.16666666666,57191.037913998254,null,1999,70661.465404097384,null,8,14,8357.1075000000001,131600.13650435497,null,2006,210596.38738482006,null,1989,117.175,null,2008,185.35833333333332]
[9,6,113593.52777777777,69635.581894056915,null,2000,95624.057239057234,null,9,9,10113.335925925925,152616.77365462205,null,2007,240880.72210878041,null,1990,121.625,null,2009,191.02500000000001]
[10,6,121393.36111111111,77329.286900325897,null,2001,56634.339559706466,null,10,9,10147.688888888888,175629.8724529146,null,2008,192060.42350402378,null,1991,125.19166666666666,null,2010,191.41666666666666]
[11,6,127753.61111111111,80736.595550791535,null,2005,85928.603257909621,null,11,8,10632.514999999999,195879.18115496522,null,2009,209658.42167255591,null,1992,128.70833333333334,null,2011,197.38333333333333]
[12,6,134122.19444444444,87328.076005729788,null,2006,90235.195212311184,null,12,6,11365.506666666668,136780.80149290865,null,2010,253265.99002651684,null,1993,132.02500000000001,null,2012,205.375]
[13,4,155144.79166666666,94426.254142402497,null,2007,86736.58808242064,null,13,4,14478.875,191223.305272661,null,2011,246154.48705935184,null,1994,133.71666666666667,null,2013,210.73333333333332]
[14,1,187247.16666666666,139448.06013390137,null,2011,162408.27915224183,null,14,5,16192.1,217723.45653432951,null,2012,275649.19659160066,null,1995,136.65833333333333,null,2014,214.26666666666668]
[15,1,196681.16666666666,149959.79824422649,null,2012,114587.51231118239,null,15,5,17284.900000000001,219286.38284789599,null,2013,298978.04674762121,null,1996,139.88333333333333,null,2015,216.92500000000001]
[16,1,207292.16666666666,160905.84905880521,null,2013,109923.56767537961,null,16,4,20153.875,225402.95451375935,null,2014,355821.86356944451,null,1997,142.24166666666667,null,2016,218.94166666666666]
[17,2,260988.08333333331,148437.99105220695,null,2014,123926.8484471347,null,17,3,20617.5,228424.43254971507,null,2015,301026.78114555718,null,1998,145.16666666666666,null,2017,220.84166666666667]
[18,5,302692.6333333333,129838.5536161839,null,2015,164112.02028350811,null,18,3,21409.5,235030.5998796272,null,2016,274645.12182523066,null,1999,147.76666666666665,null,2018,222.5]
[19,3,302681.05555555556,72612.130985748954,null,2016,160530.57239643091,null,19,1,10830,204671.7662352364,null,2017,372778.38572129351,null,2000,148.5]
[20,2,292697.58333333331,99107.984999999986,null,2017,135971.08411003358]
[23,1,414000,65690.89]
[]
["** All costs are adjecsted using the construction machinery and equipment price index (CMEPI), considering the year of 2018 as the base year **"]

{"sheet":"UserManual","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}