{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Inputs","Detailed Inputs","Results","Inputs_Results","Cost_by_Year","Calculations"],"not_rendered":{"charts":2,"images":6,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"Inputs","index":0,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[64,9,64,10],[65,9,65,10],[53,9,53,10],[60,9,60,10],[61,9,61,10],[63,9,63,10],[43,9,43,10],[58,9,58,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[52,9,52,10],[17,3,17,10],[19,3,19,10],[23,6,23,9],[18,3,18,10],[12,3,12,10],[13,3,13,10],[14,3,14,10],[15,3,15,10],[2,2,2,11],[3,2,3,11],[4,2,4,11],[11,3,11,10],[16,3,16,10]]}
[]
[]
[null,null,"TCRP E-09"]
[null,null,"TRANSIT STATE OF GOOD REPAIR"]
[null,null,"VEHICLE REPLACEMENT MODEL - INPUTS"]
[]
[null,null,"INSTRUCTIONS"]
[]
[null,null,"Note: this model is used to predict the average annual cost, the cost-minimizing "]
[null,null,"  replacement age, and prioritization data for transit vehicles. "]
[null,null,"  To use this model please follow these instructions, and see the TCRP E-09 report for more information."]
[null,null,null,"1.  Open the spreadsheet with macros enabled"]
[null,null,null,"2.  Select an asset type from the dropdown or select \"User-Specified\" if developing a new model."]
[null,null,null,"3.  Enter accumulated mileage (per vehicle) and number of vehicles for up to 20 subfleets of the same vehicle type."]
[null,null,null,"4.  Enter the base year and base year fleet statistics."]
[null,null,null,"5.  Enter the cost of a new vehicle."]
[null,null,null,"6.  If desired enter an estimate of other replacement benefits per vehicle mile (e.g., reduced emissions)."]
[null,null,null,"7.  If desired enter the delay cost, typical schedule headway, recovery time, vehicles per consist, and/or the discount rate."]
[null,null,null,"8.  If desired click the \"Click to Edit Details\" button to edit additional details (necessary only for a new model)."]
[null,null,null,"9.  To view results click the \"Click for Results\" button."]
[]
[null,null,"REQUIRED INPUTS"]
[]
[null,null,"Vehicle Type:",null,null,null,"Bus"]
[]
[]
[null,null,"Inventory Description:"]
[null,null,null,null,"Accumulated","Number of",null,null,"Accumulated","Number of"]
[null,null,null,"Group","Milegage","Vehicles",null,"Group","Milegage","Vehicles"]
[]
[null,null,null,1,1,1,null,11]
[null,null,null,2,null,null,null,12]
[null,null,null,3,null,null,null,13]
[null,null,null,4,null,null,null,14]
[null,null,null,5,null,null,null,15]
[null,null,null,6,null,null,null,16]
[null,null,null,7,null,null,null,17]
[null,null,null,8,null,null,null,18]
[null,null,null,9,null,null,null,19]
[null,null,null,10,null,null,null,20]
[]
[null,null,"Base Year Statistics:"]
[null,null,null,null,null,null,null,null,"Override"]
[null,null,null,null,null,null,null,"Default","Value","Notes"]
[]
[null,null,"Base Year",null,null,null,null,2009]
[null,null,"Passenger Miles (000)",null,null,null,null,1]
[null,null,"Unlinked Trips (000)",null,null,null,null,1]
[null,null,"Vehicle Miles (000)",null,null,null,null,1]
[null,null,"Revenue Vehicle Miles (000)",null,null,null,null,1]
[null,null,"Revenue Vehicle Hours (000)",null,null,null,null,1]
[null,null,"Number of Road Calls (buses) or Failures (rail)",null,null,null,null,1]
[null,null,"Energy Cost for Vehicle Operations (000)",null,null,null,null,1]
[null,null,"Vehicle Maintenance Cost (000)",null,null,null,null,1]
[]
[null,null,"OPTIONAL INPUTS"]
[]
[null,null,null,null,null,null,null,null,"Override"]
[null,null,null,null,null,null,null,"Default","Value","Notes"]
[]
[null,null,"New Vehicle Cost ($ per vehicle)",null,null,null,null,397000]
[null,null,"Other Benefits of Replacement ($/vehicle mile)",null,null,null,null,0,null,"results in higher benefit for replacement"]
[null,null,"Passenger Delay Cost ($ per hour)",null,null,null,null,48.4]
[null,null,"Typical Schedule Headway (min)",null,null,null,null,30]
[null,null,"Typical Recovery Time After Road Call/Failure (min)",null,null,null,null,60]
[null,null,"Vehicles per Consist",null,null,null,null,1,null,"leave blank for buses"]
[null,null,"Discount Rate (%)",null,null,null,null,7.0000000000000007E-2]
[]
[null,null,"Vehicle List"]
[null,null,"Bus"]
[null,null,"Heavy Rail"]
[null,null,"Light Rail"]
[null,null,"User-Specified"]

{"sheet":"Detailed Inputs","index":1,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[32,10,32,11],[2,2,2,12],[3,2,3,12],[4,2,4,12],[37,10,37,11],[8,3,8,4],[8,8,8,9],[8,5,8,6],[8,10,8,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[30,10,30,11]]}
[]
[]
[null,null,"TCRP E-09"]
[null,null,"TRANSIT STATE OF GOOD REPAIR"]
[null,null,"VEHICLE REPLACEMENT MODEL - DETAILED INPUTS"]
[]
[null,null,"REHABILITATION COSTS"]
[]
[null,null,null,"Lifetime Mileage",null,"Rehab Cost ($/vehicle mile)",null,null,"Lifetime Mileage",null,"Rehab Cost ($/vehicle mile)"]
[null,null,null,"From","To","Default","Override",null,"From","To","Default","Override"]
[]
[null,null,null,0,35000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.158991722811707,0)","v":0.15899172281170701},null,null,{"$f":"E26","v":525000},560000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.692589096171615,0)","v":0.69258909617161502}]
[null,null,null,{"$f":"E12","v":35000},70000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.373327315373453,0)","v":0.37332731537345298},null,null,{"$f":"J12","v":560000},595000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.704166159551995,0)","v":0.70416615955199502}]
[null,null,null,{"$f":"E13","v":70000},105000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.521139233863795,0)","v":0.52113923386379502},null,null,{"$f":"J13","v":595000},630000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.718158673708854,0)","v":0.718158673708854}]
[null,null,null,105000,140000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.594814011812456,0)","v":0.59481401181245597},null,null,630000,665000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.734447221511808,0)","v":0.73444722151180797}]
[null,null,null,140000,175000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.627501332157651,0)","v":0.62750133215765103},null,null,665000,700000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.752659906353446,0)","v":0.75265990635344604}]
[null,null,null,175000,210000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.641612770295223,0)","v":0.64161277029522301},null,null,700000,735000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.772132014767538,0)","v":0.77213201476753801}]
[null,null,null,210000,245000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.648354720004888,0)","v":0.64835472000488803},null,null,735000,770000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.79187968331879,0)","v":0.79187968331879}]
[null,null,null,245000,280000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.652614138282429,0)","v":0.65261413828242898},null,null,770000,805000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.81060127345571,0)","v":0.81060127345570998}]
[null,null,null,280000,315000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.656155369772874,0)","v":0.65615536977287403},null,null,805000,840000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.82672120626999,0)","v":0.82672120626999002}]
[null,null,null,315000,350000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.659476510438738,0)","v":0.65947651043873801},null,null,840000,875000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.838487681626975,0)","v":0.83848768162697496}]
[null,null,null,350000,385000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.662781693149278,0)","v":0.66278169314927804},null,null,875000,910000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.838487681626975,0)","v":0.83848768162697496}]
[null,null,null,385000,420000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.666363792828946,0)","v":0.66636379282894598},null,null,910000,945000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.838487681626975,0)","v":0.83848768162697496}]
[null,null,null,420000,455000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.670656089337205,0)","v":0.670656089337205},null,null,945000,980000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.838487681626975,0)","v":0.83848768162697496}]
[null,null,null,455000,490000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.676156233086216,0)","v":0.67615623308621597},null,null,980000,1015000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.838487681626975,0)","v":0.83848768162697496}]
[null,null,null,490000,525000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.683338177338452,0)","v":0.68333817733845204},null,null,1015000,1050000,{"$f":"IF(Inputs!$G$24=\"Bus\",0.838487681626975,0)","v":0.83848768162697496}]
[]
[null,null,"ADDITIONAL MODEL PARAMETERS"]
[]
[null,null,null,null,null,null,null,null,null,"Override"]
[null,null,null,null,null,null,null,null,"Default","Value","Notes"]
[]
[null,null,"Energy Model Coefficient 1",null,null,null,null,null,{"$f":"IF(Inputs!$G$24=\"Bus\",0.000000627,IF(Inputs!$G$24=\"Heavy Rail\",0.0000004,IF(Inputs!$G$24=\"Light Rail\",0.0000004,0)))","v":6.2699999999999999E-7},null,"populated by vehicle type"]
[null,null,"Energy Model Coefficient 2",null,null,null,null,null,{"$f":"IF(FuelC1=0,0,(FuelCost/BusMiles)/(Calculations!BC99/Calculations!BC6))","v":0.99999937300019648},null,"calculated w/ base-year data"]
[null,null,"Maintenance Model Coefficient 1",null,null,null,null,null,{"$f":"IF(Inputs!$G$24=\"Bus\",0.00000126,IF(Inputs!$G$24=\"Heavy Rail\",0.0000004,IF(Inputs!$G$24=\"Light Rail\",0.0000005,0)))","v":1.26E-6},null,"populated by vehicle type"]
[null,null,"Maintenance Model Coefficient 2",null,null,null,null,null,{"$f":"IF(MaintC1=0,0,(MaintCost/BusMiles)/(Calculations!BC100/Calculations!BC6))","v":0.99999874000079392},null,"calculated w/ base-year data"]
[null,null,"Delay Model Coefficient 1",null,null,null,null,null,{"$f":"IF(Inputs!$G$24=\"Heavy Rail\",0.0000007,IF(Inputs!$G$24=\"Light Rail\",0.000001,0.00000198))","v":1.9800000000000001E-6},null,"populated by vehicle type"]
[null,null,"Delay Model Coefficient 2",null,null,null,null,null,{"$f":"IF(DelayC1=0,0,IF(CarsPerTrain=\"\",1,CarsPerTrain)*DelayUnitCost*Headway/60*(PaxMiles/RevBusMiles+RecoverTime/60*PaxTrips/RevBusHours)*(RoadCalls/BusMiles/1000)/(Calculations!BC101/Calculations!BC6))","v":4.8399904168094872E-2},null,"calculated w/ base-year data"]
[]
[null,null,"Vehicle List"]
[null,null,"Bus"]
[null,null,"Heavy Rail"]
[null,null,"Light Rail"]
[null,null,"Other"]

{"sheet":"Results","index":2,"n_rows":237,"n_cols":22,"rows_kept":237,"cut":false,"hidden":false,"merged":[[24,2,24,3],[2,2,2,8],[3,2,3,8],[4,2,4,8],[8,3,8,5],[11,4,11,5],[12,4,12,5],[13,4,13,5]]}
[]
[]
[null,null,"TCRP E-09"]
[null,null,"TRANSIT STATE OF GOOD REPAIR"]
[null,null,"VEHICLE REPLACEMENT MODEL - RESULTS"]
[]
[null,null,"SUMMARY RESULTS"]
[]
[null,null,"Vehicle Type:",{"$f":"Inputs!G24","v":"Bus"}]
[null,null,"Cost-Minimizing Replacement Mileage (miles)",null,null,{"$f":"Inputs_Results!F38","v":60000}]
[null,null,"Cost-Minimizing Replacement Age (years)",null,null,{"$f":"Inputs_Results!F39","v":60}]
[null,null,"Average Annual Agency Cost:",null,{"$f":"Inputs_Results!F41","v":30555.675849275231}]
[null,null,"Average Annual User Cost:",null,{"$f":"Inputs_Results!F42","v":51.460877279442514}]
[null,null,"Average Annual Total Cost:",null,{"$f":"Inputs_Results!F40","v":30607.136726554672}]
[]
[null,null,"PRIORITIZATION DATA"]
[]
[null,null,"Prioritization Index (PI) Coefficients (copy and paste into the prioritization model)"]
[null,null,"Note: PI = C0 + C1 * Age + C2 * Age^2"]
[]
[null,null,"C0","C1","C2"]
[]
[null,null,{"$f":"Inputs_Results!D164","v":-7.078854418627642E-2},{"$f":"Inputs_Results!C164","v":5.1547183667716206E-6},{"$f":"Inputs_Results!B164","v":3.0023960731037653E-9}]
[]
[null,null,"Sample PI Results"]
[null,null,"Age","PI"]
[null,null,{"$f":"+Inputs_Results!A171","v":40},{"$f":"+Inputs_Results!B171","v":-7.0577552032748125E-2}]
[null,null,{"$f":"+Inputs_Results!A172","v":41},{"$f":"+Inputs_Results!B172","v":-7.0572153871647197E-2}]
[null,null,{"$f":"+Inputs_Results!A173","v":42},{"$f":"+Inputs_Results!B173","v":-7.056674977105043E-2}]
[null,null,{"$f":"+Inputs_Results!A174","v":43},{"$f":"+Inputs_Results!B174","v":-7.056133972374877E-2}]
[null,null,{"$f":"+Inputs_Results!A175","v":44},{"$f":"+Inputs_Results!B175","v":-7.0555923722523631E-2}]
[null,null,{"$f":"+Inputs_Results!A176","v":45},{"$f":"+Inputs_Results!B176","v":-7.0550501760147072E-2}]
[null,null,{"$f":"+Inputs_Results!A177","v":46},{"$f":"+Inputs_Results!B177","v":-7.0545073829381633E-2}]
[null,null,{"$f":"+Inputs_Results!A178","v":47},{"$f":"+Inputs_Results!B178","v":-7.0539639922980388E-2}]
[null,null,{"$f":"+Inputs_Results!A179","v":48},{"$f":"+Inputs_Results!B179","v":-7.0534200033686933E-2}]
[null,null,{"$f":"+Inputs_Results!A180","v":49},{"$f":"+Inputs_Results!B180","v":-7.0528754154235346E-2}]
[null,null,{"$f":"+Inputs_Results!A181","v":50},{"$f":"+Inputs_Results!B181","v":-7.0523302277350181E-2}]
[null,null,{"$f":"+Inputs_Results!A182","v":51},{"$f":"+Inputs_Results!B182","v":-7.0517844395746515E-2}]
[null,null,{"$f":"+Inputs_Results!A183","v":52},{"$f":"+Inputs_Results!B183","v":-7.0512380502129796E-2}]
[null,null,{"$f":"+Inputs_Results!A184","v":53},{"$f":"+Inputs_Results!B184","v":-7.0506910589195976E-2}]
[null,null,{"$f":"+Inputs_Results!A185","v":54},{"$f":"+Inputs_Results!B185","v":-7.0501434649631448E-2}]
[null,null,{"$f":"+Inputs_Results!A186","v":55},{"$f":"+Inputs_Results!B186","v":-7.0495952676112958E-2}]
[null,null,{"$f":"+Inputs_Results!A187","v":56},{"$f":"+Inputs_Results!B187","v":-7.049046466130772E-2}]
[null,null,{"$f":"+Inputs_Results!A188","v":57},{"$f":"+Inputs_Results!B188","v":-7.0484970597873314E-2}]
[null,null,{"$f":"+Inputs_Results!A189","v":58},{"$f":"+Inputs_Results!B189","v":-7.0479470478457679E-2}]
[null,null,{"$f":"+Inputs_Results!A190","v":59},{"$f":"+Inputs_Results!B190","v":-7.0473964295699146E-2}]
[null,null,{"$f":"+Inputs_Results!A191","v":60},{"$f":"+Inputs_Results!B191","v":-7.046845204222639E-2}]
[]
[]
[]
[null,null,"Objective Function"]
[null,null,10100.274219957704]
[]
[null,null,"Decision Variables"]
[null,null,"Description","Agency","Total"]
[null,null,"State 5-Excellent",31.927052186618152,31.9270519461421]
[null,null,"State 4-Good",175.58328098837745,175.58327970872844]
[null,null,"State 3-Adequate",503.11167926316045,503.11167737362518]
[null,null,"State 2-Marginal",1029.8383665295496,1029.8383663048057]
[null,null,"State 1-Poor",1029.8383665295496,1029.8383663048057]
[null,null,"State 0-Failed",1529.8383665175354,3029.8383663048057]
[]
[null,null,"Results by State and Action"]
[null,null,null,null,"Optimal","Agency","Total",null,"Benefit",null,null,null,"Constraints"]
[null,null,"State","Action","Action?","Cost","Cost","LT Cost","Agency",null,"User","Total","Agency","Total"]
[null,null,"5-Excellent","0-Do Minimum",{"$f":"IF(H66=MIN(H66:H68),\"Y\",\"\")","v":"Y"},0,0,31.9270519461421,0,null,{"$f":"L66-I66","v":0},0,-6.2304650327860145E-10,0]
[null,null,null,"1-Rehab",{"$f":"IF(H67=MIN(H66:H68),\"Y\",\"\")","v":""},1000,1000,1164.0965230922695,-1132.1694721022081,null,9.5608061201346572E-7,-1132.1694711461275,1132.1694721015851,1132.1694711461275]
[null,null,null,"2-Replace",{"$f":"IF(H68=MIN(H66:H68),\"Y\",\"\")","v":""},1000,1000,1029.8383663048057,-997.91131434355452,null,-1.5109094420040492E-8,-997.91131435866362,997.91131434293152,997.91131435866362]
[null,null,"4-Good","0-Do Minimum",{"$f":"IF(H69=MIN(H69:H71),\"Y\",\"\")","v":"Y"},0,0,175.58327970872844,0,null,0,0,-6.2325966609932948E-8,0]
[null,null,null,"1-Rehab",{"$f":"IF(H70=MIN(H69:H71),\"Y\",\"\")","v":""},1000,1000,1164.0965230922695,-988.51324336215168,null,-2.1389382709458005E-8,-988.51324338354107,988.51324329982572,988.51324338354107]
[null,null,null,"2-Replace",{"$f":"IF(H71=MIN(H69:H71),\"Y\",\"\")","v":""},1000,1000,1029.8383663048057,-854.25508560349817,null,-9.9257908914296422E-7,-854.25508659607726,854.25508554117221,854.25508659607726]
[null,null,"3-Adequate","0-Do Minimum",{"$f":"IF(H72=MIN(H72:H74),\"Y\",\"\")","v":"Y"},0,0,503.11167737362518,0,null,0,0,-2.2764305640521343E-7,0]
[null,null,null,"1-Rehab",{"$f":"IF(H73=MIN(H72:H74),\"Y\",\"\")","v":""},1000,1000,1164.0965230922695,-660.98484525268577,null,-4.6595857838838128E-7,-660.98484571864435,660.98484502504277,660.98484571864435]
[null,null,null,"2-Replace",{"$f":"IF(H74=MIN(H72:H74),\"Y\",\"\")","v":""},1000,1000,1029.8383663048057,-526.72668749403238,null,-1.4371481711350498E-6,-526.72668893118055,526.72668726638926,526.72668893118055]
[null,null,"2-Marginal","0-Do Minimum",{"$f":"IF(H75=MIN(H75:H77),\"Y\",\"\")","v":""},50,50,1114.9765215772229,0,null,0,0,8.2550862504469933,85.13815527241718]
[null,null,null,"1-Rehab",{"$f":"IF(H76=MIN(H75:H77),\"Y\",\"\")","v":""},1000,1000,1164.0965230922695,-126.00307150820663,null,76.883069993159978,-49.120001515046653,134.25815775865362,134.25815678746383]
[null,null,null,"2-Replace",{"$f":"IF(H77=MIN(H75:H77),\"Y\",\"\")","v":"Y"},1000,1000,1029.8383663048057,8.2550862504469222,null,76.883069021970286,85.138155272417208,7.1054273576010019E-14,-3.1974423109204508E-14]
[null,null,"1-Poor","0-Do Minimum",{"$f":"IF(H78=MIN(H78:H80),\"Y\",\"\")","v":""},100,100,1267.4872802527584,0,null,0,0,83.882775918715311,237.64891394795268]
[null,null,null,"1-Rehab",{"$f":"IF(H79=MIN(H78:H80),\"Y\",\"\")","v":""},1000,1000,1164.0965230922695,-50.375381839938314,null,153.76613900042716,103.39075716048885,134.25815775865362,134.25815678746383]
[null,null,null,"2-Replace",{"$f":"IF(H80=MIN(H78:H80),\"Y\",\"\")","v":"Y"},1000,1000,1029.8383663048057,83.88277591871524,null,153.76613802923748,237.64891394795271,7.1054273576010019E-14,-3.1974423109204508E-14]
[null,null,"0-Failed","0-Replace","Y",1500,3000,3029.8383663048057,"N/A",null,"N/A","N/A",1.2014268691018515E-8,-3.1974423109204508E-14]
[]
[null,null,"Results by State"]
[null,null,null,null,null,"Cost",null,null,"Benefit",null,null,null,null,"TP",null,null,null,null,null,"SS","Steady State Cost"]
[null,null,"State","Opt. Action",null,"Agency","Total","LT","Agency",null,"User","Total","PI",5,4,3,2,1,0,"Distrib","Agency","Total"]
[null,null,{"$f":"C66","v":"5-Excellent"},{"$f":"IF($E66=\"Y\",D66,IF($E67=\"Y\",D67,D68))","v":"0-Do Minimum"},null,{"$f":"IF($E66=\"Y\",F66,IF($E67=\"Y\",F67,F68))","v":0},0,31.9270519461421,{"$f":"IF($E66=\"Y\",I66,IF($E67=\"Y\",I67,I68))","v":0},null,0,0,{"$f":"IF(F86>0,L86/F86,\"N/A\")","v":"N/A"},0.98444276540573339,1.5557234594266611E-2,0,0,0,0,{"$f":"1/(2-N86+(1-N90)*(D98*(D102*(D105*D107+D106)+D103*D107+D104)+D99*(D105*D107+D106)+D100*D107+D101)+(1-N89)*(D102*(D105*D107+D106)+D103*D107+D104)+(1-N88)*(D105*D107+D106)+(1-N87)*D107)","v":0.60139255887831344},{"$f":"F86*$T86","v":0},0]
[null,null,{"$f":"C69","v":"4-Good"},{"$f":"IF($E69=\"Y\",D69,IF($E70=\"Y\",D70,D71))","v":"0-Do Minimum"},null,{"$f":"IF($E69=\"Y\",F69,IF($E70=\"Y\",F70,F71))","v":0},0,175.58327970872844,{"$f":"IF($E69=\"Y\",I69,IF($E70=\"Y\",I70,I71))","v":0},null,0,0,{"$f":"IF(F87>0,L87/F87,\"N/A\")","v":"N/A"},0,0.96247400327043964,3.7525996729560362E-2,0,0,0,{"$f":"D107*T86","v":0.24932062935309618},0,0]
[null,null,{"$f":"C72","v":"3-Adequate"},{"$f":"IF($E72=\"Y\",D72,IF($E73=\"Y\",D73,D74))","v":"0-Do Minimum"},null,{"$f":"IF($E72=\"Y\",F72,IF($E73=\"Y\",F73,F74))","v":0},0,503.11167737362518,{"$f":"IF($E72=\"Y\",I72,IF($E73=\"Y\",I73,I74))","v":0},null,0,0,{"$f":"IF(F88>0,L88/F88,\"N/A\")","v":"N/A"},0,0,0.93313834640197002,6.686165359802998E-2,0,0,{"$f":"D105*T87+D106*T86","v":0.1399308066468743},0,0]
[null,null,{"$f":"C75","v":"2-Marginal"},{"$f":"IF($E75=\"Y\",D75,IF($E76=\"Y\",D76,D77))","v":"2-Replace"},null,{"$f":"IF($E75=\"Y\",F75,IF($E76=\"Y\",F76,F77))","v":1000},1000,1029.8383663048057,{"$f":"IF($E75=\"Y\",I75,IF($E76=\"Y\",I76,I77))","v":8.2550862504469222},null,76.883069021970286,85.138155272417208,{"$f":"IF(F89>0,L89/F89,\"N/A\")","v":8.5138155272417207E-2},1,0,0,0,0,0,{"$f":"D102*T88+D103*T87+D104*T86","v":9.3560051217162193E-3},9.356005121716219,9.356005121716219]
[null,null,{"$f":"C78","v":"1-Poor"},{"$f":"IF($E78=\"Y\",D78,IF($E79=\"Y\",D79,D80))","v":"2-Replace"},null,{"$f":"IF($E78=\"Y\",F78,IF($E79=\"Y\",F79,F80))","v":1000},1000,1029.8383663048057,{"$f":"IF($E78=\"Y\",I78,IF($E79=\"Y\",I79,I80))","v":83.88277591871524},null,153.76613802923748,237.64891394795271,{"$f":"IF(F90>0,L90/F90,\"N/A\")","v":0.23764891394795271},1,0,0,0,0,0,{"$f":"D98*T89+D99*T88+D100*T87+D101*T86","v":0},0,0]
[null,null,{"$f":"C81","v":"0-Failed"},{"$f":"D81","v":"0-Replace"},null,{"$f":"F81","v":1500},3000,3029.8383663048057,{"$f":"I81","v":"N/A"},null,"N/A","N/A","N/A",1,0,0,0,0,0,{"$f":"1-T90-T89-T88-T87-T86","v":0},0,0]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T86:T91)","v":1.0000000000000002},{"$f":"SUM(U86:U91)","v":9.356005121716219},{"$f":"SUM(V86:V91)","v":9.356005121716219}]
[]
[null,null,"Misc. Parameters"]
[null,null,"Description","Value"]
[null,null,"Disc. Rate",7.0000000000000007E-2]
[null,null,"Disc. Factor",{"$f":"1/(1+D96)","v":0.93457943925233644}]
[null,null,"c1",{"$f":"R89/(1-R90)","v":0}]
[null,null,"c2",{"$f":"R88/(1-R90)","v":0}]
[null,null,"c3",{"$f":"R87/(1-R90)","v":0}]
[null,null,"c4",{"$f":"R86/(1-R90)","v":0}]
[null,null,"c5",{"$f":"(Q90*D99+Q88)/(1-Q89-Q90*D98)","v":6.686165359802998E-2}]
[null,null,"c6",{"$f":"(Q90*D100+Q87)/(1-Q89-Q90*D98)","v":0}]
[null,null,"c7",{"$f":"(Q90*D101+Q86)/(1-Q89-Q90*D98)","v":0}]
[null,null,"c8",{"$f":"(P90*D98*D103+P90*D100+P89*D103+P87)/(1-P88-P90*D98*D102-P90*D99-P89*D102)","v":0.56124840936727949}]
[null,null,"c9",{"$f":"(P90*D98*D104+P90*D101+P89*D104+P86)/(1-P88-P90*D98*D102-P90*D99-P89*D102)","v":0}]
[null,null,"c10",{"$f":"(O90*D98*D102*D106+O90*D98*D104+O90*D99*D106+O90*D101+O89*D102*D106+O89*D104+O88*D106+O86)/(1-O87-O90*D98*D102*D105-O90*D98*D103-O90*D99*D105-O90*D100+O89*D103+O88*D105)","v":0.41457218861855594}]
[]
[null,null,"Asset List"]
[null,null,"User-Specified"]
[null,null,"Guideway-At Grade Ballasted or Expressway"]
[null,null,"Guideway-Grade Crossing"]
[null,null,"Guideway-Elevated Structure "]
[null,null,"Guideway-Steel Viaduct"]
[null,null,"Guideway-Bridge"]
[null,null,"Guideway-Foot Walk"]
[null,null,"Guideway-Elevated Fill"]
[null,null,"Guideway-Tunnel"]
[null,null,"Guideway-Retained Cut"]
[null,null,"Guideway-Tangent Direct Fixation Track"]
[null,null,"Guideway-Curved Direct Fixation Track"]
[null,null,"Guideway-Guarded Direct Fixation Track"]
[null,null,"Guideway-Direct Fixation Tangent Platform Track"]
[null,null,"Guideway-Direct Fixation Curved Platform Track"]
[null,null,"Guideway-Guarded Curved Direct Fixation Track"]
[null,null,"Guideway-Tangent Ballasted Track"]
[null,null,"Guideway-Curved Ballasted Track"]
[null,null,"Guideway-Guarded Ballasted Track"]
[null,null,"Guideway-Ballasted Tangent Platform Track"]
[null,null,"Guideway-Ballasted Curved Platform Track"]
[null,null,"Guideway-Guarded Platform Ballasted Track"]
[null,null,"Guideway-Tangent Embedded Track"]
[null,null,"Guideway-Curved Embedded Track"]
[null,null,"Guideway-At-Grade Crossing"]
[null,null,"Guideway-Special Trackwork"]
[null,null,"Guideway-Direct Fixation Diamond Crossover"]
[null,null,"Guideway-Direct Fixation or Ballasted Turnout"]
[null,null,"Guideway-Turntable"]
[null,null,"Guideway-Yard Track"]
[null,null,"Guideway-Wood Tie"]
[null,null,"Guideway-Concrete Tie"]
[null,null,"Guideway-Retaining Wall"]
[null,null,"Guideway-At Grade Bus"]
[null,null,"Guideway-Bus Turnaround"]
[null,null,"Guideway-Elevated-Bus"]
[null,null,"Guideway-Subway Bus"]
[null,null,"Facilities-Administrative Building"]
[null,null,"Facilities-Maintenance Building"]
[null,null,"Facilities-Passenger Building"]
[null,null,"Facilities-Building Utilities"]
[null,null,"Facilities-Access and Parking"]
[null,null,"Facilities-Building Utilities-Elevators and Conveying Systems"]
[null,null,"Facilities-Building Utilities-Generator"]
[null,null,"Facilities-Storage Yard"]
[null,null,"Facilities-Storage Yard-Bus"]
[null,null,"Facilities-Bus Turnaround Facility"]
[null,null,"Facilities-Maintenance Equipment"]
[null,null,"Facilities-Pollution Treatment"]
[null,null,"Facilities-Bus Washer"]
[null,null,"Facilities-Train Washer"]
[null,null,"Facilities-Vehicle Paintbooth"]
[null,null,"Facilities-Fuel Island"]
[null,null,"Facilities-Dynamoneter"]
[null,null,"Facilities-Portable Lift"]
[null,null,"Facilities-Fixed Lift"]
[null,null,"Facilities-Wheel Truing Machine"]
[null,null,"Facilities-Brake Lathe"]
[null,null,"Facilities-Major Rail Shop"]
[null,null,"Facilities-Major Bus Shop"]
[null,null,"Facilities-Train Control Center"]
[null,null,"Systems-Train Control, Elec., Comm., Revenue Collect. & Util."]
[null,null,"Systems-Train Control"]
[null,null,"Systems-Train Control"]
[null,null,"Systems-Signals & Train Stops"]
[null,null,"Systems-Train Control Cable"]
[null,null,"Systems-Signal Bridge"]
[null,null,"Systems-Centralized Train Control"]
[null,null,"Systems-Gates, Flashers, Crossings"]
[null,null,"Systems-Roadway Traffic Signals"]
[null,null,"Systems-Interlocking"]
[null,null,"Systems-Electrification"]
[null,null,"Systems-Electrification Catenary/Pole"]
[null,null,"Systems-Electrification Substation"]
[null,null,"Systems-High Tension Towers"]
[null,null,"Systems-Electrification Substation Building Components"]
[null,null,"Systems-Electrification Breaker House"]
[null,null,"Systems-Electrification Contact Rail/Protection Boards"]
[null,null,"Systems-Heaters"]
[null,null,"Systems-Power Cable"]
[null,null,"Systems-Electrical Systems"]
[null,null,"Systems-Trolley Wire"]
[null,null,"Systems-Communications Cable"]
[null,null,"Systems-Communciations"]
[null,null,"Systems-MIS/IT/Network System"]
[null,null,"Systems-Emergency Location System"]
[null,null,"Systems-SCADA RTU"]
[null,null,"Systems-Communications Hut or Room"]
[null,null,"Systems-Bus On-Board Video System"]
[null,null,"Systems-Central Revenue Collection"]
[null,null,"Systems-Coin/Bill Counter"]
[null,null,"Systems-Revenue Collection System-Rail"]
[null,null,"Systems-Turnstile"]
[null,null,"Systems-In Station Revenue Collection Equipment"]
[null,null,"Systems-Parking Meter"]
[null,null,"Systems-Change Machine"]
[null,null,"Systems-Passenger Counter-Rail"]
[null,null,"Systems-System Utilities"]
[null,null,"Systems-Lighting"]
[null,null,"Systems-Guideway Drainage"]
[null,null,"Systems-Pump Room"]
[null,null,"Systems-Deep Utility Well"]
[null,null,"Systems-Sump Pump/Discharge Pipes"]
[null,null,"Systems-Subway Ventilation"]
[null,null,"Systems-Fan Plant"]
[null,null,"Systems-Compressed Air Pipes"]
[null,null,"Systems-Air Conditioning/HVAC-Subway"]
[null,null,"Systems-Emergency Exit"]
[null,null,"Systems-Tunnel Handrail"]
[null,null,"Systems-ITS, APC, AVL, CAD, GPL"]
[null,null,"Station-Building-Rail"]
[null,null,"Stations-Building-Subway"]
[null,null,"Stations-Shelter-Rail"]
[null,null,"Stations-Token Booth"]
[null,null,"Stations-Elevator/Escalator"]
[null,null,"Stations-Parking Garage/Lot"]
[null,null,"Stations-Parking Equipment"]
[null,null,"Stations-Pedestrian Walkway/Elevated"]
[null,null,"Stations-Pedestrian Walkway/Subway"]
[null,null,"Stations-At-Grade Rail Platform"]
[null,null,"Stations-Elevated Rail Platform"]
[null,null,"Stations-Subway Rail Platform"]
[null,null,"Stations-Building/Ground Access-Bus"]
[null,null,"Stations-Bus Shelter"]
[null,null,"Stations-Station Canopy"]
[null,null,"Stations-Bus Station Platform"]
[null,null,"Stations-Signage & Graphics"]
[null,null,"Stations-Ferry Terminal Building/Dock"]

{"sheet":"Inputs_Results","index":3,"n_rows":191,"n_cols":22,"rows_kept":191,"cut":false,"hidden":false,"merged":[[44,4,44,5],[97,8,97,14],[97,15,98,16],[97,1,99,1],[98,2,98,5],[97,2,97,7],[98,7,99,7],[97,17,98,20],[97,21,99,21],[169,10,171,10],[98,6,99,6],[98,8,98,12],[98,13,99,13],[98,14,99,14]]}
["Transit Asset Rehabilitation/Replacement Vehicle Model"]
["Inputs and Summary Results"]
[]
["Input Parameters"]
["Description",null,null,null,null,"Value"]
["Annual Statistics for Base Year Fleet"]
["Base Year",null,null,null,null,{"$f":"IF(Inputs!I46<>\"\",Inputs!I46,Inputs!H46)","v":2009}]
["Passenger Miles (000)",null,null,null,null,{"$f":"IF(Inputs!I47<>\"\",Inputs!I47,Inputs!H47)","v":1}]
["Unlinked Trips (000)",null,null,null,null,{"$f":"IF(Inputs!I48<>\"\",Inputs!I48,Inputs!H48)","v":1}]
["Vehicle Miles (000)",null,null,null,null,{"$f":"IF(Inputs!I49<>\"\",Inputs!I49,Inputs!H49)","v":1}]
["Revenue Vehicle Miles (000)",null,null,null,null,{"$f":"IF(Inputs!I50<>\"\",Inputs!I50,Inputs!H50)","v":1}]
["Revenue Vehicle Hours (000)",null,null,null,null,{"$f":"IF(Inputs!I51<>\"\",Inputs!I51,Inputs!H51)","v":1}]
["Number of Road Calls (buses) or Failures (rail)",null,null,null,null,{"$f":"IF(Inputs!I52<>\"\",Inputs!I52,Inputs!H52)","v":1}]
["Fuel Cost for Vehicle Operations (000)",null,null,null,null,{"$f":"IF(Inputs!I53<>\"\",Inputs!I53,Inputs!H53)","v":1}]
["Vehicle Maintenance Cost (000)",null,null,null,null,{"$f":"IF(Inputs!I54<>\"\",Inputs!I54,Inputs!H54)","v":1}]
["Cost Parameters"]
["New Vehicle Cost ($ per vehicle)",null,null,null,null,{"$f":"IF(Inputs!I61<>\"\",Inputs!I61,Inputs!H61)","v":397000}]
["Passenger Delay Cost ($ per hour)",null,null,null,null,{"$f":"IF(Inputs!I63<>\"\",Inputs!I63,Inputs!H63)","v":48.4}]
["Energy (Fuel) Cost Model"]
["EnergyC1",null,null,null,null,{"$f":"IF('Detailed Inputs'!J33<>\"\",'Detailed Inputs'!J33,'Detailed Inputs'!I33)","v":6.2699999999999999E-7}]
["EnergyC2",null,null,null,null,{"$f":"IF('Detailed Inputs'!J34<>\"\",'Detailed Inputs'!J34,'Detailed Inputs'!I34)","v":0.99999937300019648}]
["Maintenance Cost Model"]
["MaintC1",null,null,null,null,{"$f":"IF('Detailed Inputs'!J35<>\"\",'Detailed Inputs'!J35,'Detailed Inputs'!I35)","v":1.26E-6}]
["MaintC2",null,null,null,null,{"$f":"IF('Detailed Inputs'!J36<>\"\",'Detailed Inputs'!J36,'Detailed Inputs'!I36)","v":0.99999874000079392}]
["Delay Cost Model"]
["DelayC1",null,null,null,null,{"$f":"IF('Detailed Inputs'!J37<>\"\",'Detailed Inputs'!J37,'Detailed Inputs'!I37)","v":1.9800000000000001E-6}]
["DelayC2",null,null,null,null,{"$f":"IF('Detailed Inputs'!J38<>\"\",'Detailed Inputs'!J38,'Detailed Inputs'!I38)","v":4.8399904168094872E-2}]
["Other Analysis Parameters"]
["Discount Rate",null,null,null,null,{"$f":"IF(Inputs!I67<>\"\",Inputs!I67,Inputs!H67)","v":7.0000000000000007E-2}]
["Typical Schedule Headway (min)",null,null,null,null,{"$f":"IF(Inputs!I64<>\"\",Inputs!I64,Inputs!H64)","v":30}]
["Typical Recovery Time After Road Call/Failure (min)",null,null,null,null,{"$f":"IF(Inputs!I65<>\"\",Inputs!I65,Inputs!H65)","v":60}]
["Vehicles/Consist (leave blank for bus)",null,null,null,null,{"$f":"IF(Inputs!I66<>\"\",Inputs!I66,Inputs!H66)","v":1}]
["Other Benefits of Replacement Vehicles ($/vehicle mile)",null,null,null,null,{"$f":"IF(Inputs!I62<>\"\",Inputs!I62,Inputs!H62)","v":0}]
["Annual Miles Per Vehicle",null,null,null,null,{"$f":"BusMiles*1000/SUM(TotalFleet)","v":1000}]
[]
["Summary Results"]
["Description",null,null,null,null,"Value"]
["Cost-Minimizing Replacement Mileage",null,null,null,null,{"$f":"VLOOKUP($F$39,$A$105:$O$160,2)","v":60000}]
["Approx. Cost-Minimizing Replacement Age",null,null,null,null,{"$f":"Q160","v":60}]
["Annualized Life Cycle Cost (replace at min)",null,null,null,null,{"$f":"MIN(O105:O160)","v":30607.136726554672}]
["Annulaized Agency Life Cycle Cost (replace at min)",null,null,null,null,{"$f":"VLOOKUP($F$39,$A$105:$O$160,13)","v":30555.675849275231}]
["Annualized User Life Cycle Cost (replace at min)",null,null,null,null,{"$f":"VLOOKUP($F$39,$A$105:$O$160,14)","v":51.460877279442514}]
[]
["Inventory Description (base year)",null,null,null,"Unit Rehabilitation Costs"]
["Group","Lifetime Mileage Per Bus","Number of Vehicles",null,"Lifetime Mileage",null,"Rehab"]
[1,{"$f":"Inputs!E31","v":1},{"$f":"Inputs!F31","v":1},null,"from","to","Cost ($/mi)"]
[{"$f":"A46+1","v":2},{"$f":"Inputs!E32","v":0},{"$f":"Inputs!F32","v":0},null,0,{"$f":"+E47+35000","v":35000},{"$f":"IF('Detailed Inputs'!G12<>\"\",'Detailed Inputs'!G12,'Detailed Inputs'!F12)","v":0.15899172281170701}]
[3,{"$f":"Inputs!E33","v":0},{"$f":"Inputs!F33","v":0},null,{"$f":"+F47","v":35000},70000,{"$f":"IF('Detailed Inputs'!G13<>\"\",'Detailed Inputs'!G13,'Detailed Inputs'!F13)","v":0.37332731537345298}]
[4,{"$f":"Inputs!E34","v":0},{"$f":"Inputs!F34","v":0},null,70000,105000,{"$f":"IF('Detailed Inputs'!G14<>\"\",'Detailed Inputs'!G14,'Detailed Inputs'!F14)","v":0.52113923386379502}]
[5,{"$f":"Inputs!E35","v":0},{"$f":"Inputs!F35","v":0},null,105000,140000,{"$f":"IF('Detailed Inputs'!G15<>\"\",'Detailed Inputs'!G15,'Detailed Inputs'!F15)","v":0.59481401181245597}]
[6,{"$f":"Inputs!E36","v":0},{"$f":"Inputs!F36","v":0},null,140000,175000,{"$f":"IF('Detailed Inputs'!G16<>\"\",'Detailed Inputs'!G16,'Detailed Inputs'!F16)","v":0.62750133215765103}]
[7,{"$f":"Inputs!E37","v":0},{"$f":"Inputs!F37","v":0},null,175000,210000,{"$f":"IF('Detailed Inputs'!G17<>\"\",'Detailed Inputs'!G17,'Detailed Inputs'!F17)","v":0.64161277029522301}]
[8,{"$f":"Inputs!E38","v":0},{"$f":"Inputs!F38","v":0},null,210000,245000,{"$f":"IF('Detailed Inputs'!G18<>\"\",'Detailed Inputs'!G18,'Detailed Inputs'!F18)","v":0.64835472000488803}]
[9,{"$f":"Inputs!E39","v":0},{"$f":"Inputs!F39","v":0},null,245000,280000,{"$f":"IF('Detailed Inputs'!G19<>\"\",'Detailed Inputs'!G19,'Detailed Inputs'!F19)","v":0.65261413828242898}]
[10,{"$f":"Inputs!E40","v":0},{"$f":"Inputs!F40","v":0},null,280000,315000,{"$f":"IF('Detailed Inputs'!G20<>\"\",'Detailed Inputs'!G20,'Detailed Inputs'!F20)","v":0.65615536977287403}]
[{"$f":"A55+1","v":11},{"$f":"Inputs!I31","v":0},{"$f":"Inputs!J31","v":0},null,315000,350000,{"$f":"IF('Detailed Inputs'!G21<>\"\",'Detailed Inputs'!G21,'Detailed Inputs'!F21)","v":0.65947651043873801}]
[12,{"$f":"Inputs!I32","v":0},{"$f":"Inputs!J32","v":0},null,350000,385000,{"$f":"IF('Detailed Inputs'!G22<>\"\",'Detailed Inputs'!G22,'Detailed Inputs'!F22)","v":0.66278169314927804}]
[13,{"$f":"Inputs!I33","v":0},{"$f":"Inputs!J33","v":0},null,385000,420000,{"$f":"IF('Detailed Inputs'!G23<>\"\",'Detailed Inputs'!G23,'Detailed Inputs'!F23)","v":0.66636379282894598}]
[14,{"$f":"Inputs!I34","v":0},{"$f":"Inputs!J34","v":0},null,420000,455000,{"$f":"IF('Detailed Inputs'!G24<>\"\",'Detailed Inputs'!G24,'Detailed Inputs'!F24)","v":0.670656089337205}]
[15,{"$f":"Inputs!I35","v":0},{"$f":"Inputs!J35","v":0},null,455000,490000,{"$f":"IF('Detailed Inputs'!G25<>\"\",'Detailed Inputs'!G25,'Detailed Inputs'!F25)","v":0.67615623308621597}]
[16,{"$f":"Inputs!I36","v":0},{"$f":"Inputs!J36","v":0},null,490000,525000,{"$f":"IF('Detailed Inputs'!G26<>\"\",'Detailed Inputs'!G26,'Detailed Inputs'!F26)","v":0.68333817733845204}]
[17,{"$f":"Inputs!I37","v":0},{"$f":"Inputs!J37","v":0},null,525000,560000,{"$f":"IF('Detailed Inputs'!L12<>\"\",'Detailed Inputs'!L12,'Detailed Inputs'!K12)","v":0.69258909617161502}]
[18,{"$f":"Inputs!I38","v":0},{"$f":"Inputs!J38","v":0},null,560000,595000,{"$f":"IF('Detailed Inputs'!L13<>\"\",'Detailed Inputs'!L13,'Detailed Inputs'!K13)","v":0.70416615955199502}]
[19,{"$f":"Inputs!I39","v":0},{"$f":"Inputs!J39","v":0},null,595000,630000,{"$f":"IF('Detailed Inputs'!L14<>\"\",'Detailed Inputs'!L14,'Detailed Inputs'!K14)","v":0.718158673708854}]
[20,{"$f":"Inputs!I40","v":0},{"$f":"Inputs!J40","v":0},null,630000,665000,{"$f":"IF('Detailed Inputs'!L15<>\"\",'Detailed Inputs'!L15,'Detailed Inputs'!K15)","v":0.73444722151180797}]
[21,null,null,null,665000,700000,{"$f":"IF('Detailed Inputs'!L16<>\"\",'Detailed Inputs'!L16,'Detailed Inputs'!K16)","v":0.75265990635344604}]
[22,null,null,null,700000,735000,{"$f":"IF('Detailed Inputs'!L17<>\"\",'Detailed Inputs'!L17,'Detailed Inputs'!K17)","v":0.77213201476753801}]
[23,null,null,null,735000,770000,{"$f":"IF('Detailed Inputs'!L18<>\"\",'Detailed Inputs'!L18,'Detailed Inputs'!K18)","v":0.79187968331879}]
[24,null,null,null,770000,805000,{"$f":"IF('Detailed Inputs'!L19<>\"\",'Detailed Inputs'!L19,'Detailed Inputs'!K19)","v":0.81060127345570998}]
[25,null,null,null,805000,840000,{"$f":"IF('Detailed Inputs'!L20<>\"\",'Detailed Inputs'!L20,'Detailed Inputs'!K20)","v":0.82672120626999002}]
[26,null,null,null,840000,875000,{"$f":"IF('Detailed Inputs'!L21<>\"\",'Detailed Inputs'!L21,'Detailed Inputs'!K21)","v":0.83848768162697496}]
[27,null,null,null,875000,910000,{"$f":"IF('Detailed Inputs'!L22<>\"\",'Detailed Inputs'!L22,'Detailed Inputs'!K22)","v":0.83848768162697496}]
[28,null,null,null,910000,945000,{"$f":"IF('Detailed Inputs'!L23<>\"\",'Detailed Inputs'!L23,'Detailed Inputs'!K23)","v":0.83848768162697496}]
[29,null,null,null,945000,980000,{"$f":"IF('Detailed Inputs'!L24<>\"\",'Detailed Inputs'!L24,'Detailed Inputs'!K24)","v":0.83848768162697496}]
[30,null,null,null,980000,1015000,{"$f":"IF('Detailed Inputs'!L25<>\"\",'Detailed Inputs'!L25,'Detailed Inputs'!K25)","v":0.83848768162697496}]
[31,null,null,null,1015000,1050000,{"$f":"IF('Detailed Inputs'!L26<>\"\",'Detailed Inputs'!L26,'Detailed Inputs'!K26)","v":0.83848768162697496}]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[]
["Results by Replacement Age"]
[null,"Lifetime Mileage","Annual Cost Per Bus",null,null,null,null,null,"Life Cycle Average Cost Per Bus Per Year",null,null,null,null,null,null,"Optimal Repl. Calc",null,"Replacement Benefit",null,null,null,"Priority Index"]
[null,null,"Agency Costs",null,null,null,"Passenger Delay","Total","Agency Costs",null,null,null,null,"Passenger Delay","Total"]
["Approx Age at which Replaced",null,"Rehab.","Maint.","Energy","Subtotal",null,null,"New Buses","Rehab.","Maint.","Energy","Subtotal",null,null,"Min Calc","Age","Agency","User","Other Benefits of New Vehicles","Total"]
[{"$f":"Calculations!A196","v":1},{"$f":"AnnMiles*Calculations!A196","v":1000},{"$f":"+Calculations!C196","v":164.46231689119273},{"$f":"+Calculations!D196","v":1035.0586214928323},{"$f":"+Calculations!E196","v":1034.7317322607157},{"$f":"SUM(C101:E101)","v":2234.2526706447406},{"$f":"+Calculations!F196","v":50.114839305641333},{"$f":"SUM(F101:G101)","v":2284.3675099503821},{"$f":"+Calculations!M196","v":424790},{"$f":"+Calculations!N196","v":164.46231689119276},{"$f":"+Calculations!O196","v":1035.0586214928323},{"$f":"+Calculations!P196","v":1034.7317322607157},{"$f":"SUM(I101:L101)","v":427024.25267064472},{"$f":"+Calculations!Q196","v":50.114839305641333},{"$f":"SUM(M101:N101)","v":427074.36750995036},{"$f":"O101","v":427074.36750995036},{"$f":"A101","v":1},{"$f":"F101-$F$41","v":-28321.423178630488},{"$f":"G101-$F$42","v":-1.346037973801181},{"$f":"OtherBen*AnnMiles","v":0},{"$f":"H101-$F$40+T101","v":-28322.769216604291},{"$f":"U101/NewBusCost","v":-7.1341987951144312E-2}]
[{"$f":"Calculations!A197","v":2},{"$f":"AnnMiles*Calculations!A197","v":2000},{"$f":"+Calculations!C197","v":164.46231689119273},{"$f":"+Calculations!D197","v":1036.3636173306402},{"$f":"+Calculations!E197","v":1035.3807124908844},2236.2066467127174,{"$f":"+Calculations!F197","v":50.214164987441777},2286.420811700159,{"$f":"+Calculations!M197","v":219577.43961352648},{"$f":"+Calculations!N197","v":164.46231689119264},{"$f":"+Calculations!O197","v":1035.6890542647197},{"$f":"+Calculations!P197","v":1035.0452492801203},221812.63623396249,{"$f":"+Calculations!Q197","v":50.16282272680094},221862.79905668928,{"$f":"IF(O102<P101,O102,P101)","v":221862.79905668928},{"$f":"IF(O102<P101,A102,Q101)","v":2},-28319.469202562512,-1.246712292000737,{"$f":"OtherBen*AnnMiles","v":0},-28320.715914854514,{"$f":"U102/NewBusCost","v":-7.133681590643455E-2}]
[{"$f":"Calculations!A198","v":3},{"$f":"AnnMiles*Calculations!A198","v":3000},{"$f":"+Calculations!C198","v":164.46231689119273},{"$f":"+Calculations!D198","v":1037.6702584995446},{"$f":"+Calculations!E198","v":1036.0300997592503},2238.162675149988,{"$f":"+Calculations!F198","v":50.313687528918962},2288.4763626789068,{"$f":"+Calculations!M198","v":151277.51127562279},{"$f":"+Calculations!N198","v":164.46231689119261},{"$f":"+Calculations!O198","v":1036.3053111420172},{"$f":"+Calculations!P198","v":1035.3515886621005},153513.6304923181,{"$f":"+Calculations!Q198","v":50.20974947479246},153563.8402417929,{"$f":"IF(O103<P102,O103,P102)","v":153563.8402417929},{"$f":"IF(O103<P102,A103,Q102)","v":3},-28317.513174125241,-1.1471897505235518,{"$f":"OtherBen*AnnMiles","v":0},-28318.660363875766,{"$f":"U103/NewBusCost","v":-7.1331638196160618E-2}]
[{"$f":"Calculations!A199","v":4},{"$f":"AnnMiles*Calculations!A199","v":4000},{"$f":"+Calculations!C199","v":164.46231689119273},{"$f":"+Calculations!D199","v":1038.9785470739696},{"$f":"+Calculations!E199","v":1036.6798943211065},2240.1207582862689,{"$f":"+Calculations!F199","v":50.413407320241184},2290.5341656065102,{"$f":"+Calculations!M199","v":117205.56231690361},{"$f":"+Calculations!N199","v":164.46231689119273},{"$f":"+Calculations!O199","v":1036.9073990363786},{"$f":"+Calculations!P199","v":1035.6507604440376},119442.58279327523,{"$f":"+Calculations!Q199","v":50.25561894776741},119492.83841222299,119492.83841222299,4,-28315.555090988961,-1.0474699592013295,{"$f":"OtherBen*AnnMiles","v":0},-28316.602560948162,{"$f":"U104/NewBusCost","v":-7.132645481347144E-2}]
[{"$f":"Calculations!A200","v":5},{"$f":"AnnMiles*Calculations!A200","v":5000},{"$f":"+Calculations!C200","v":164.46231689119273},{"$f":"+Calculations!D200","v":1040.2884851309539},{"$f":"+Calculations!E200","v":1037.3300964319064},2242.0808984540531,{"$f":"+Calculations!F200","v":50.51332475235003},2292.5942232064031,{"$f":"+Calculations!M200","v":96824.605693225487},{"$f":"+Calculations!N200","v":164.46231689119273},{"$f":"+Calculations!O200","v":1037.4953384453304},{"$f":"+Calculations!P200","v":1035.9427813451684},99062.506129907168,{"$f":"+Calculations!Q200","v":50.30043158908785},99112.806561496254,99112.806561496254,5,-28313.594950821178,-0.94755252709248339,{"$f":"OtherBen*AnnMiles","v":0},-28314.542503348268,{"$f":"U105/NewBusCost","v":-7.1321265751506976E-2}]
[{"$f":"Calculations!A201","v":6},{"$f":"AnnMiles*Calculations!A201","v":6000},{"$f":"+Calculations!C201","v":164.46231689119273},{"$f":"+Calculations!D201","v":1041.6000747501555},{"$f":"+Calculations!E201","v":1037.9807063472633},2244.0430979886114,{"$f":"+Calculations!F201","v":50.613440216961934},2294.6565382055733,{"$f":"+Calculations!M201","v":83288.932504056284},{"$f":"+Calculations!N201","v":164.46231689119273},{"$f":"+Calculations!O201","v":1038.0691633398606},{"$f":"+Calculations!P201","v":1036.2276747006838},85527.691658988027,{"$f":"+Calculations!Q201","v":50.344188880552771},85578.035847868581,85578.035847868581,6,-28311.632751286619,-0.84743706248058004,0,-28312.480188349098,-7.1316071003398235E-2]
[{"$f":"Calculations!A202","v":7},{"$f":"AnnMiles*Calculations!A202","v":7000},{"$f":"+Calculations!C202","v":164.46231689119273},{"$f":"+Calculations!D202","v":1042.9133180138547},{"$f":"+Calculations!E202","v":1038.6317243229507},2246.0073592279982,{"$f":"+Calculations!F202","v":50.713754106569681},2296.7211133345677,{"$f":"+Calculations!M202","v":73664.628193570243},{"$f":"+Calculations!N202","v":164.4623168911927},{"$f":"+Calculations!O202","v":1038.6289210088316},{"$f":"+Calculations!P202","v":1036.5054703746896},75904.224901844951,{"$f":"+Calculations!Q202","v":50.386893332282732},75954.611795177232,75954.611795177232,7,-28309.668490047232,-0.7471231728728327,0,-28310.415613220106,-7.1310870562267273E-2]
[{"$f":"Calculations!A203","v":8},{"$f":"AnnMiles*Calculations!A203","v":8000},{"$f":"+Calculations!C203","v":164.46231689119273},{"$f":"+Calculations!D203","v":1044.2282170069568},{"$f":"+Calculations!E203","v":1039.2831506149025},2247.9736845130519,{"$f":"+Calculations!F203","v":50.814266814443982},2298.7879513274961,{"$f":"+Calculations!M203","v":66484.701708829598},{"$f":"+Calculations!N203","v":164.4623168911927},{"$f":"+Calculations!O203","v":1039.1746718612924},{"$f":"+Calculations!P203","v":1036.7762046526182},68725.114902234709,{"$f":"+Calculations!Q203","v":50.428548469336882},68775.543450704048,68775.543450704048,8,-28307.70216476218,-0.64661046499853114,0,-28308.348775227176,-7.1305664421227141E-2]
[{"$f":"Calculations!A204","v":9},{"$f":"AnnMiles*Calculations!A204","v":9000},{"$f":"+Calculations!C204","v":164.46231689119273},{"$f":"+Calculations!D204","v":1045.5447738169955},{"$f":"+Calculations!E204","v":1039.9349854792133},2249.9420761874017,{"$f":"+Calculations!F204","v":50.914978734634992},2300.8570549220367,{"$f":"+Calculations!M204","v":60934.128644953504},{"$f":"+Calculations!N204","v":164.4623168911927},{"$f":"+Calculations!O204","v":1039.7064891879959},{"$f":"+Calculations!P204","v":1037.0399201137714},63175.337371146459,{"$f":"+Calculations!Q204","v":50.469158815155119},63225.806529961614,63225.806529961614,9,-28305.733773087828,-0.54589854480752109,0,-28306.279671632634,-7.1300452573381953E-2]
[{"$f":"Calculations!A205","v":10},{"$f":"AnnMiles*Calculations!A205","v":10000},{"$f":"+Calculations!C205","v":164.46231689119273},{"$f":"+Calculations!D205","v":1046.8629905341365},{"$f":"+Calculations!E205","v":1040.5872291721384},2251.9125365974678,{"$f":"+Calculations!F205","v":51.015890261973837},2302.9284268594415,{"$f":"+Calculations!M205","v":56523.868582763789},{"$f":"+Calculations!N205","v":164.46231689119273},{"$f":"+Calculations!O205","v":1040.2244588836945},{"$f":"+Calculations!P205","v":1037.2966654848183},58765.852024023494,{"$f":"+Calculations!Q205","v":50.508729871938371},58816.360753895431,58816.360753895431,10,-28303.763312677762,-0.44498701746867653,0,-28304.20829969523,-7.1295235011826774E-2]
[{"$f":"Calculations!A206","v":11},{"$f":"AnnMiles*Calculations!A206","v":11000},{"$f":"+Calculations!C206","v":164.46231689119273},{"$f":"+Calculations!D206","v":1048.1828692511813},{"$f":"+Calculations!E206","v":1041.2398819500938},{"$f":"SUM(C111:E111)","v":2253.8850680924679},{"$f":"+Calculations!F206","v":51.117001792074213},{"$f":"SUM(F111:G111)","v":2305.0020698845419},{"$f":"+Calculations!M206","v":52942.691219989203},{"$f":"+Calculations!N206","v":164.4623168911927},{"$f":"+Calculations!O206","v":1040.728679131995},{"$f":"+Calculations!P206","v":1037.5464954751571},{"$f":"SUM(I111:L111)","v":55185.428711487548},{"$f":"+Calculations!Q206","v":50.547268098096971},{"$f":"SUM(M111:N111)","v":55235.975979585644},55235.975979585644,11,{"$f":"F111-$F$41","v":-28301.790781182761},{"$f":"G111-$F$42","v":-0.34387548736830098},0,{"$f":"H111-$F$40+T111","v":-28302.134656670132},-7.129001172964769E-2]
[{"$f":"Calculations!A207","v":12},{"$f":"AnnMiles*Calculations!A207","v":12000},{"$f":"+Calculations!C207","v":164.46231689119273},{"$f":"+Calculations!D207","v":1049.5044120635696},{"$f":"+Calculations!E207","v":1041.8929440696563},2255.859673024419,{"$f":"+Calculations!F207","v":51.218313721333878},2307.0779867457527,{"$f":"+Calculations!M207","v":49983.089496043118},{"$f":"+Calculations!N207","v":164.4623168911927},{"$f":"+Calculations!O207","v":1041.2192600547753},{"$f":"+Calculations!P207","v":1037.7894705951765},52226.560543584266,{"$f":"+Calculations!Q207","v":50.584780882914167},52277.145324467179,52277.145324467179,12,-28299.81617625081,-0.24256355810863539,0,-28300.058739808919,-7.128478271992171E-2]
[{"$f":"Calculations!A208","v":13},{"$f":"AnnMiles*Calculations!A208","v":13000},{"$f":"+Calculations!C208","v":164.46231689119273},{"$f":"+Calculations!D208","v":1050.8276210693828},{"$f":"+Calculations!E208","v":1042.5464157875633},2257.8363537481391,{"$f":"+Calculations!F208","v":51.319826446936268},2309.1561801950752,{"$f":"+Calculations!M208","v":47501.386710094135},{"$f":"+Calculations!N208","v":164.46231689119273},{"$f":"+Calculations!O208","v":1041.69632332835},{"$f":"+Calculations!P208","v":1038.0256569585163},49745.571007272199,{"$f":"+Calculations!Q208","v":50.621276518586662},49796.192283790784,49796.192283790784,13,-28297.839495527092,-0.14105083250624517,0,-28297.980546359599,-7.1279547975716867E-2]
[{"$f":"Calculations!A209","v":14},{"$f":"AnnMiles*Calculations!A209","v":14000},{"$f":"+Calculations!C209","v":164.46231689119273},{"$f":"+Calculations!D209","v":1052.152498369348},{"$f":"+Calculations!E209","v":1043.2002973607136},2259.8151126212542,{"$f":"+Calculations!F209","v":51.421540366851971},2311.236652988106,{"$f":"+Calculations!M209","v":45394.940632077589},{"$f":"+Calculations!N209","v":164.4623168911927},{"$f":"+Calculations!O209","v":1042.1600017687415},{"$f":"+Calculations!P209","v":1038.2551260695316},47639.81807680706,{"$f":"+Calculations!Q209","v":50.656764169817663},47690.47484097688,47690.47484097688,14,-28295.860736653976,-3.9336912590542283E-2,0,-28295.900073566565,-7.1274307490092101E-2]
[{"$f":"Calculations!A210","v":15},{"$f":"AnnMiles*Calculations!A210","v":15000},{"$f":"+Calculations!C210","v":164.46231689119273},{"$f":"+Calculations!D210","v":1053.4790460668405},{"$f":"+Calculations!E210","v":1043.8545890461673},2261.7959520042004,{"$f":"+Calculations!F210","v":51.523455879840405},2313.3194078840406,{"$f":"+Calculations!M210","v":43588.46600629959},{"$f":"+Calculations!N210","v":164.4623168911927},{"$f":"+Calculations!O210","v":1042.6104388885583},{"$f":"+Calculations!P210","v":1038.477954597214},45834.016716676553,{"$f":"+Calculations!Q210","v":50.691253841149496},45884.707970517702,45884.707970517702,15,-28293.879897271028,6.2578600397891648E-2,0,-28293.817318670634,-7.1269061256097319E-2]
[{"$f":"Calculations!A211","v":16},{"$f":"AnnMiles*Calculations!A211","v":16000},{"$f":"+Calculations!C211","v":164.46231689119273},{"$f":"+Calculations!D211","v":1054.8072662678878},{"$f":"+Calculations!E211","v":1044.509291101145},2263.7788742602256,{"$f":"+Calculations!F211","v":51.625573385451254},2315.404447645677,{"$f":"+Calculations!M211","v":42025.486147318392},{"$f":"+Calculations!N211","v":164.46231689119273},{"$f":"+Calculations!O211","v":1043.0477884281042},{"$f":"+Calculations!P211","v":1038.6942241368904},44271.69047677458,{"$f":"+Calculations!Q211","v":50.724756342232808},44322.415233116815,44322.415233116815,16,-28291.896975015006,0.16469610600874063,0,-28291.732278908996,-7.1263809266773295E-2]
[{"$f":"Calculations!A212","v":17},{"$f":"AnnMiles*Calculations!A212","v":17000},{"$f":"+Calculations!C212","v":164.46231689119273},{"$f":"+Calculations!D212","v":1056.1371610811727},{"$f":"+Calculations!E212","v":1045.164403783029},2265.7638817553943,{"$f":"+Calculations!F212","v":51.727893284026123},2317.4917750394206,{"$f":"+Calculations!M212","v":40662.801645481246},{"$f":"+Calculations!N212","v":164.46231689119273},{"$f":"+Calculations!O212","v":1043.4722138634361},{"$f":"+Calculations!P212","v":1038.9040209610603},42909.640197196939,{"$f":"+Calculations!Q212","v":50.757283251237752},42960.397480448177,42960.397480448177,17,-28289.911967519838,0.26701600458360986,0,-28289.644951515253,-7.1258551515151772E-2]
[{"$f":"Calculations!A213","v":18},{"$f":"AnnMiles*Calculations!A213","v":18000},{"$f":"+Calculations!C213","v":164.46231689119273},{"$f":"+Calculations!D213","v":1057.4687326180363},{"$f":"+Calculations!E213","v":1045.8199273493635},2267.7509768585924,{"$f":"+Calculations!F213","v":51.830415976700088},2319.5813928352923,{"$f":"+Calculations!M213","v":39466.802858369716},{"$f":"+Calculations!N213","v":164.46231689119273},{"$f":"+Calculations!O213","v":1043.883887894169},{"$f":"+Calculations!P213","v":1039.1074357607661},41714.256498915842,{"$f":"+Calculations!Q213","v":50.788846876618329},41765.04534579246,41765.04534579246,18,-28287.924872416639,0.36953869725757471,0,-28287.555333719381,-7.1253287994255371E-2]
[{"$f":"Calculations!A214","v":19},{"$f":"AnnMiles*Calculations!A214","v":19000},{"$f":"+Calculations!C214","v":164.46231689119273},{"$f":"+Calculations!D214","v":1058.8019829924817},{"$f":"+Calculations!E214","v":1046.4758620578539},2269.7401619415286,{"$f":"+Calculations!F214","v":51.933141865403229},2321.6733038069319,{"$f":"+Calculations!M214","v":38410.946895420653},{"$f":"+Calculations!N214","v":164.46231689119276},{"$f":"+Calculations!O214","v":1044.2829919138667},{"$f":"+Calculations!P214","v":1039.3045633789127},40658.996767604629,{"$f":"+Calculations!Q214","v":50.819460217445993},40709.816227822077,40709.816227822077,19,-28285.935687333702,0.47226458596071552,0,-28285.46342274774,-7.1248018697097584E-2]
[{"$f":"Calculations!A215","v":20},{"$f":"AnnMiles*Calculations!A215","v":20000},{"$f":"+Calculations!C215","v":164.46231689119273},{"$f":"+Calculations!D215","v":1060.136914321178},{"$f":"+Calculations!E215","v":1047.1322081663668},2271.7314393787374,{"$f":"+Calculations!F215","v":52.036071352862251},2323.7675107315995,{"$f":"+Calculations!M215","v":37473.991520072508},{"$f":"+Calculations!N215","v":164.46231689119273},{"$f":"+Calculations!O215","v":1044.6697154658875},{"$f":"+Calculations!P215","v":1039.4955025369572},39722.619054966548,{"$f":"+Calculations!Q215","v":50.849136922530604},39773.468191889078,39773.468191889078,20,-28283.944409896492,0.57519407341973761,0,-28283.369215823073,-7.1242743616682799E-2]
[{"$f":"Calculations!A216","v":21},{"$f":"AnnMiles*Calculations!A216","v":21000},{"$f":"+Calculations!C216","v":164.46231689119273},{"$f":"+Calculations!D216","v":1061.4735287234623},{"$f":"+Calculations!E216","v":1047.7889659329312},2273.7248115475863,{"$f":"+Calculations!F216","v":52.139204842602048},2325.8640163901882,{"$f":"+Calculations!M216","v":36638.733660714817},{"$f":"+Calculations!N216","v":164.46231689119273},{"$f":"+Calculations!O216","v":1045.0442556875516},{"$f":"+Calculations!P216","v":1039.6803555563929},38887.920588849956,{"$f":"+Calculations!Q216","v":50.877891248548096},38938.798480098507,38938.798480098507,21,-28281.951037727646,0.67832756315953446,0,-28281.272710164485,-7.1237462746006258E-2]
[{"$f":"Calculations!A217","v":22},{"$f":"AnnMiles*Calculations!A217","v":22000},{"$f":"+Calculations!C217","v":164.46231689119273},{"$f":"+Calculations!D217","v":1062.8118283213432},{"$f":"+Calculations!E217","v":1048.4461356157371},2275.7202808282732,{"$f":"+Calculations!F217","v":52.242542738947286},2327.9628235672203,{"$f":"+Calculations!M217","v":35891.091970378191},{"$f":"+Calculations!N217","v":164.46231689119273},{"$f":"+Calculations!O217","v":1045.406816745478},{"$f":"+Calculations!P217","v":1039.8592280764253},38140.820332091287,{"$f":"+Calculations!Q217","v":50.90573801739253},38191.726070108678,38191.726070108678,22,-28279.955568446956,0.78166545950477229,0,-28279.173902987452,-7.123217607805403E-2]
[{"$f":"Calculations!A218","v":23},{"$f":"AnnMiles*Calculations!A218","v":23000},{"$f":"+Calculations!C218","v":164.46231689119273},{"$f":"+Calculations!D218","v":1064.1518152395063},{"$f":"+Calculations!E218","v":1049.1037174731375},2277.7178496038368,{"$f":"+Calculations!F218","v":52.346085447024002},2330.0639350508609,{"$f":"+Calculations!M218","v":35219.428722132754},{"$f":"+Calculations!N218","v":164.46231689119273},{"$f":"+Calculations!O218","v":1045.7576092648931},{"$f":"+Calculations!P218","v":1040.0322287692347},37469.680877058076,{"$f":"+Calculations!Q218","v":50.932692572968222},37520.613569631045,37520.613569631045,23,-28277.957999671395,0.88520816758148868,0,-28277.072791503811,-7.1226883605803051E-2]
[{"$f":"Calculations!A219","v":24},{"$f":"AnnMiles*Calculations!A219","v":24000},{"$f":"+Calculations!C219","v":164.46231689119273},{"$f":"+Calculations!D219","v":1065.4934916053148},{"$f":"+Calculations!E219","v":1049.7617117636469},2279.7175202601547,{"$f":"+Calculations!F219","v":52.449833372761141},2332.1673536329158,{"$f":"+Calculations!M219","v":34614.041231572861},{"$f":"+Calculations!N219","v":164.4623168911927},{"$f":"+Calculations!O219","v":1046.0968497556548},{"$f":"+Calculations!P219","v":1040.199469054161},36864.799867273869,{"$f":"+Calculations!Q219","v":50.958770737632925},36915.758638011503,36915.758638011503,24,-28275.958329015077,0.98895609331862744,0,-28274.969372921758,-7.1221585322221059E-2]
[{"$f":"Calculations!A220","v":25},{"$f":"AnnMiles*Calculations!A220","v":25000},{"$f":"+Calculations!C220","v":164.46231689119273},{"$f":"+Calculations!D220","v":1066.8368595488143},{"$f":"+Calculations!E220","v":1050.4201187459419},2281.7192951859488,{"$f":"+Calculations!F220","v":52.553786922892215},2334.2730821088412,{"$f":"+Calculations!M220","v":34066.775336604253},{"$f":"+Calculations!N220","v":164.46231689119273},{"$f":"+Calculations!O220","v":1046.4247600376466},{"$f":"+Calculations!P220","v":1040.3610628121194},36318.02347634521,{"$f":"+Calculations!Q220","v":50.983988768497213},36369.007465113704,36369.007465113704,25,-28273.95655408928,1.0929096434497012,0,-28272.863644445832,-7.1216281220266575E-2]
[{"$f":"Calculations!A221","v":26},{"$f":"AnnMiles*Calculations!A221","v":26000},{"$f":"+Calculations!C221","v":164.46231689119273},{"$f":"+Calculations!D221","v":1068.181921202736},{"$f":"+Calculations!E221","v":1051.078938678861},2283.7231767727899,{"$f":"+Calculations!F221","v":52.657946504956868},2336.3811232777466,{"$f":"+Calculations!M221","v":33570.728070926067},{"$f":"+Calculations!N221","v":164.46231689119273},{"$f":"+Calculations!O221","v":1046.7415666681018},{"$f":"+Calculations!P221","v":1040.5171261014987},35822.449080586863,{"$f":"+Calculations!Q221","v":51.00836331377856},35873.457443900639,35873.457443900639,26,-28271.952672502441,1.1970692255143547,0,-28270.755603276924,-7.1210971292888975E-2]
[{"$f":"Calculations!A222","v":27},{"$f":"AnnMiles*Calculations!A222","v":27000},{"$f":"+Calculations!C222","v":164.46231689119273},{"$f":"+Calculations!D222","v":1069.5286787025004},{"$f":"+Calculations!E222","v":1051.738171821406},2285.7291674150993,{"$f":"+Calculations!F222","v":52.762312527302413},2338.4914799424018,{"$f":"+Calculations!M222","v":33120.016405062284},{"$f":"+Calculations!N222","v":164.4623168911927},{"$f":"+Calculations!O222","v":1047.047500373309},{"$f":"+Calculations!P222","v":1040.6677768767354},35372.193999203519,{"$f":"+Calculations!Q222","v":51.031911369400042},35423.225910572917,35423.225910572917,27,-28269.946681860132,1.3014352478598994,0,-28268.645246612272,-7.1205655533028392E-2]
[{"$f":"Calculations!A223","v":28},{"$f":"AnnMiles*Calculations!A223","v":28000},{"$f":"+Calculations!C223","v":164.46231689119273},{"$f":"+Calculations!D223","v":1070.8771341862198},{"$f":"+Calculations!E223","v":1052.39781843274},2287.7372695101526,{"$f":"+Calculations!F223","v":52.866885399085582},2340.6041549092383,{"$f":"+Calculations!M223","v":32709.59553636998},{"$f":"+Calculations!N223","v":164.4623168911927},{"$f":"+Calculations!O223","v":1047.3427954870101},{"$f":"+Calculations!P223","v":1040.813134710691},34962.213783458872,{"$f":"+Calculations!Q223","v":51.05465023601414},35013.268433694888,35013.268433694888,28,-28267.938579765079,1.4060081196430687,0,-28266.532571645435,-7.1200333933615703E-2]
[{"$f":"Calculations!A224","v":29},{"$f":"AnnMiles*Calculations!A224","v":29000},{"$f":"+Calculations!C224","v":164.46231689119273},{"$f":"+Calculations!D224","v":1072.2272897947023},{"$f":"+Calculations!E224","v":1053.05787877219},2289.7474854580851,{"$f":"+Calculations!F224","v":52.971665530273988},2342.7191509883592,{"$f":"+Calculations!M224","v":32335.114766406412},{"$f":"+Calculations!N224","v":164.46231689119273},{"$f":"+Calculations!O224","v":1047.627689397671},{"$f":"+Calculations!P224","v":1040.953320521887},34588.158093217164,{"$f":"+Calculations!Q224","v":51.076597476622119},34639.234690693789,34639.234690693789,29,-28265.928363817147,1.5107882508314745,0,-28264.417575566313,-7.1195006487572571E-2]
[{"$f":"Calculations!A225","v":30},{"$f":"AnnMiles*Calculations!A225","v":30000},{"$f":"+Calculations!C225","v":164.46231689119273},{"$f":"+Calculations!D225","v":1073.5791476714548},{"$f":"+Calculations!E225","v":1053.7183530992438},2291.7598176618912,{"$f":"+Calculations!F225","v":53.076653331647769},2344.836470993539,{"$f":"+Calculations!M225","v":31992.802193911146},{"$f":"+Calculations!N225","v":164.46231689119273},{"$f":"+Calculations!O225","v":1047.902422006659},{"$f":"+Calculations!P225","v":1041.0884563075833},34246.255389116581,{"$f":"+Calculations!Q225","v":51.097770874948182},34297.35315999153,34297.35315999153,30,-28263.916031613338,1.6157760522052556,0,-28262.300255561135,-7.1189673187811428E-2]
[{"$f":"Calculations!A226","v":31},{"$f":"AnnMiles*Calculations!A226","v":31000},{"$f":"+Calculations!C226","v":164.46231689119273},{"$f":"+Calculations!D226","v":1074.9327099626883},{"$f":"+Calculations!E226","v":1054.3792416735539},2293.7742685274352,{"$f":"+Calculations!F226","v":53.181849214801268},2346.9561177422365,{"$f":"+Calculations!M226","v":31679.371715445548},{"$f":"+Calculations!N226","v":164.4623168911927},{"$f":"+Calculations!O226","v":1048.1672351991945},{"$f":"+Calculations!P226","v":1041.2186648835996},33933.219932419532,{"$f":"+Calculations!Q226","v":51.118188394715929},33984.338120814245,33984.338120814245,31,-28261.901580747795,1.7209719353587545,0,-28260.180608812436,-7.1184334027235355E-2]
[{"$f":"Calculations!A227","v":32},{"$f":"AnnMiles*Calculations!A227","v":32000},{"$f":"+Calculations!C227","v":164.46231689119273},{"$f":"+Calculations!D227","v":1076.2879788173177},{"$f":"+Calculations!E227","v":1055.0405447549344},2295.790840463445,{"$f":"+Calculations!F227","v":53.287253592144538},2349.0780940555896,{"$f":"+Calculations!M227","v":31391.947452831559},{"$f":"+Calculations!N227","v":164.46231689119273},{"$f":"+Calculations!O227","v":1048.4223723297916},{"$f":"+Calculations!P227","v":1041.3440696317},33646.176211684244,{"$f":"+Calculations!Q227","v":51.137868139962535},33697.314079824209,33697.314079824209,32,-28259.885008811787,1.8263763127020241,0,-28258.058632499084,-7.1178988998738243E-2]
[{"$f":"Calculations!A228","v":33},{"$f":"AnnMiles*Calculations!A228","v":33000},{"$f":"+Calculations!C228","v":164.46231689119273},{"$f":"+Calculations!D228","v":1077.6449563869683},{"$f":"+Calculations!E228","v":1055.7022626033631},2297.8095358815244,{"$f":"+Calculations!F228","v":53.392866876905032},2351.2024027584293,{"$f":"+Calculations!M228","v":31128.001909878516},{"$f":"+Calculations!N228","v":164.4623168911927},{"$f":"+Calculations!O228","v":1048.6680777237323},{"$f":"+Calculations!P228","v":1041.4647942552815},33382.597098748724,{"$f":"+Calculations!Q228","v":51.156828316513383},33433.753927065234,33433.753927065234,33,-28257.866313393708,1.9319895974625183,0,-28255.934323796242,-7.1173638095204633E-2]
[{"$f":"Calculations!A229","v":34},{"$f":"AnnMiles*Calculations!A229","v":34000},{"$f":"+Calculations!C229","v":164.46231689119273},{"$f":"+Calculations!D229","v":1079.0036448259777},{"$f":"+Calculations!E229","v":1056.3643954789798},2299.8303571961505,{"$f":"+Calculations!F229","v":53.498689483129226},2353.3290466792796,{"$f":"+Calculations!M229","v":30885.305030995674},{"$f":"+Calculations!N229","v":164.4623168911927},{"$f":"+Calculations!O229","v":1048.9045961959482},{"$f":"+Calculations!P229","v":1041.5809625440158},33140.252906626833,{"$f":"+Calculations!Q229","v":51.175087194727297},33191.427993821562,33191.427993821562,34,-28255.845492079079,2.0378122036867126,0,-28253.807679875394,-7.1168281309509807E-2]
[{"$f":"Calculations!A230","v":35},{"$f":"AnnMiles*Calculations!A230","v":35000},{"$f":"+Calculations!C230","v":164.46231689119273},{"$f":"+Calculations!D230","v":1080.3640462914007},{"$f":"+Calculations!E230","v":1057.0269436420888},2301.8533068246825,{"$f":"+Calculations!F230","v":53.604721825684194},2355.4580286503665,{"$f":"+Calculations!M230","v":30661.881980654292},{"$f":"+Calculations!N230","v":164.4623168911927},{"$f":"+Calculations!O230","v":1049.1321725885186},{"$f":"+Calculations!P230","v":1041.6926981480187},32917.169168282024,{"$f":"+Calculations!Q230","v":51.192663073609459},32968.361831355636,32968.361831355636,35,-28253.822542450547,2.1438445462416809,0,-28251.678697904306,-7.1162918634519665E-2]
[{"$f":"Calculations!A231","v":36},{"$f":"AnnMiles*Calculations!A231","v":36000},{"$f":"+Calculations!C231","v":386.17277779800338},{"$f":"+Calculations!D231","v":1081.7261629430104},{"$f":"+Calculations!E231","v":1057.6899073531565},2525.5888480941703,{"$f":"+Calculations!F231","v":53.710964320259251},2579.2998124144297,{"$f":"+Calculations!M231","v":30455.977947436826},{"$f":"+Calculations!N231","v":165.95117129797762},{"$f":"+Calculations!O231","v":1049.3510513278236},{"$f":"+Calculations!P231","v":1041.8001243620274},32713.080294424653,{"$f":"+Calculations!Q231","v":51.20957424637664},32764.289868671029,32764.289868671029,36,-28030.087001181062,2.2500870408167373,0,-28027.836914140244,-7.0599085426045954E-2]
[{"$f":"Calculations!A232","v":37},{"$f":"AnnMiles*Calculations!A232","v":37000},{"$f":"+Calculations!C232","v":386.17277779800338},{"$f":"+Calculations!D232","v":1083.0899969433035},{"$f":"+Calculations!E232","v":1058.3532868728134},2527.6160616141206,{"$f":"+Calculations!F232","v":53.817417383367633},2581.4334789974882,{"$f":"+Calculations!M232","v":30266.02864326433},{"$f":"+Calculations!N232","v":167.3246599769694},{"$f":"+Calculations!O232","v":1049.5614760022252},{"$f":"+Calculations!P232","v":1041.9033639199954},32524.81814316352,{"$f":"+Calculations!Q232","v":51.225838967546231},32576.043982131068,32576.043982131068,37,-28028.05978766111,2.3565401039251199,0,-28025.703247557183,-7.0593710951025651E-2]
[{"$f":"Calculations!A233","v":38},{"$f":"AnnMiles*Calculations!A233","v":38000},{"$f":"+Calculations!C233","v":386.17277779800338},{"$f":"+Calculations!D233","v":1084.4555504575033},{"$f":"+Calculations!E233","v":1059.0170824618533},2529.6454107173599,{"$f":"+Calculations!F233","v":53.924081432348046},2583.5694921497079,{"$f":"+Calculations!M233","v":30090.635448358233},{"$f":"+Calculations!N233","v":168.59289609199595},{"$f":"+Calculations!O233","v":1049.7636889609894},{"$f":"+Calculations!P233","v":1042.0025388004251},32350.994572211643,{"$f":"+Calculations!Q233","v":51.241475421608662},32402.236047633251,32402.236047633251,38,-28026.030438557871,2.4632041529055329,0,-28023.567234404964,-7.0588330565251795E-2]
[{"$f":"Calculations!A234","v":39},{"$f":"AnnMiles*Calculations!A234","v":39000},{"$f":"+Calculations!C234","v":386.17277779800338},{"$f":"+Calculations!D234","v":1085.8228256535624},{"$f":"+Calculations!E234","v":1059.6812943812338},2531.6768978327996,{"$f":"+Calculations!F234","v":54.030956885366379},2585.7078547181659,{"$f":"+Calculations!M234","v":29928.544367846851},{"$f":"+Calculations!N234","v":169.76494705063368},{"$f":"+Calculations!O234","v":1049.9579309350029},{"$f":"+Calculations!P234","v":1042.0977700426868},32190.365015875177,{"$f":"+Calculations!Q234","v":51.256501693330421},32241.621517568507,32241.621517568507,39,-28023.998951442431,2.5700796059238655,0,-28021.428871836506,-7.0582944261552913E-2]
[{"$f":"Calculations!A235","v":40},{"$f":"AnnMiles*Calculations!A235","v":40000},{"$f":"+Calculations!C235","v":386.17277779800338},{"$f":"+Calculations!D235","v":1087.1918247021681},{"$f":"+Calculations!E235","v":1060.3459228920751},2533.7105253922464,{"$f":"+Calculations!F235","v":54.138044161417277},2587.8485695536638,{"$f":"+Calculations!M235","v":29778.628132823298},{"$f":"+Calculations!N235","v":170.84896392818399},{"$f":"+Calculations!O235","v":1050.1444406796879},{"$f":"+Calculations!P235","v":1042.1891775744964},32041.810715005664,{"$f":"+Calculations!Q235","v":51.270935739723271},32093.081650745386,32093.081650745386,40,-28021.965323882985,2.6771668819747632,0,-28019.288157001007,-7.0577552032748125E-2]
[{"$f":"Calculations!A236","v":41},{"$f":"AnnMiles*Calculations!A236","v":41000},{"$f":"+Calculations!C236","v":386.17277779800338},{"$f":"+Calculations!D236","v":1088.562549776743},{"$f":"+Calculations!E236","v":1061.0109682556624},2535.7462958304086,{"$f":"+Calculations!F236","v":54.24534368032586},2589.9916395107343,{"$f":"+Calculations!M236","v":29639.870908918012},{"$f":"+Calculations!N236","v":171.85229203718916},{"$f":"+Calculations!O236","v":1050.3234546403787},{"$f":"+Calculations!P236","v":1042.2768800506544},31904.323535646236,{"$f":"+Calculations!Q236","v":51.284795363704561},31955.608331009938,31955.608331009938,41,-28019.929553444821,2.7844664008833462,0,-28017.145087043937,-7.0572153871647197E-2]
[{"$f":"Calculations!A237","v":42},{"$f":"AnnMiles*Calculations!A237","v":42000},{"$f":"+Calculations!C237","v":386.17277779800338},{"$f":"+Calculations!D237","v":1089.9350030534504},{"$f":"+Calculations!E237","v":1061.6764307334445},2537.784211584898,{"$f":"+Calculations!F237","v":54.352855862749273},2592.1370674476475,{"$f":"+Calculations!M237","v":29511.355177789363},{"$f":"+Calculations!N237","v":172.7815657849743},{"$f":"+Calculations!O237","v":1050.4952066402807},{"$f":"+Calculations!P237","v":1042.3609947030843},31776.992944917703,{"$f":"+Calculations!Q237","v":51.298098189462252},31828.291043107165,31828.291043107165,42,-28017.891637690333,2.8919785833067593,0,-28014.999659107023,-7.056674977105043E-2]
[{"$f":"Calculations!A238","v":43},{"$f":"AnnMiles*Calculations!A238","v":43000},{"$f":"+Calculations!C238","v":386.17277779800338},{"$f":"+Calculations!D238","v":1091.3091867111978},{"$f":"+Calculations!E238","v":1062.3423105870336},2539.8242750962345,{"$f":"+Calculations!F238","v":54.460581130178426},2594.284856226413,{"$f":"+Calculations!M238","v":29392.250437851802},{"$f":"+Calculations!N238","v":173.64279037661564},{"$f":"+Calculations!O238","v":1050.6599275910091},{"$f":"+Calculations!P238","v":1042.4416372021371},31658.994793021564,{"$f":"+Calculations!Q238","v":51.310861639528916},31710.305654661093,31710.305654661093,43,-28015.851574178996,2.9997038507359122,0,-28012.851870328261,-7.056133972374877E-2]
[{"$f":"Calculations!A239","v":44},{"$f":"AnnMiles*Calculations!A239","v":44000},{"$f":"+Calculations!C239","v":386.17277779800338},{"$f":"+Calculations!D239","v":1092.685102931639},{"$f":"+Calculations!E239","v":1063.0086080782071},2541.8664888078492,{"$f":"+Calculations!F239","v":54.568519904939599},2596.4350087127887,{"$f":"+Calculations!M239","v":29281.803434921661},{"$f":"+Calculations!N239","v":174.44141245535386},{"$f":"+Calculations!O239","v":1050.8178452255843},{"$f":"+Calculations!P239","v":1042.5189215290864},31549.581614131686,{"$f":"+Calculations!Q239","v":51.323102913559495},31600.904717045247,31600.904717045247,44,-28013.809360467381,3.1076426254970855,0,-28010.701717841883,-7.0555923722523631E-2]
[{"$f":"Calculations!A240","v":45},{"$f":"AnnMiles*Calculations!A240","v":45000},{"$f":"+Calculations!C240","v":386.17277779800338},{"$f":"+Calculations!D240","v":1094.0627538991791},{"$f":"+Calculations!E240","v":1063.6753234689047},2543.9108551660875,{"$f":"+Calculations!F240","v":54.6766726101961},2598.5875277762834,{"$f":"+Calculations!M240","v":29179.329684944703},{"$f":"+Calculations!N240","v":175.18238140020125},{"$f":"+Calculations!O240","v":1050.9691838536521},{"$f":"+Calculations!P240","v":1042.5929598596697},31448.074210058228,{"$f":"+Calculations!Q240","v":51.334838968798955},31499.409049027028,31499.409049027028,45,-28011.764994109144,3.2157953307535863,0,-28008.54919877839,-7.0550501760147072E-2]
[{"$f":"Calculations!A241","v":46},{"$f":"AnnMiles*Calculations!A241","v":46000},{"$f":"+Calculations!C241","v":386.17277779800338},{"$f":"+Calculations!D241","v":1095.4421418009772},{"$f":"+Calculations!E241","v":1064.3424570212328},2545.9573766202134,{"$f":"+Calculations!F241","v":54.785039669949924},2600.7424162901634,{"$f":"+Calculations!M241","v":29084.206092376171},{"$f":"+Calculations!N241","v":175.87020270108516},{"$f":"+Calculations!O241","v":1051.1141641385927},{"$f":"+Calculations!P241","v":1042.6638624584925},31353.854321674338,{"$f":"+Calculations!Q241","v":51.346086502217986},31405.200408176555,31405.200408176555,46,-28009.718472655019,3.3241623905074107,0,-28006.39431026451,-7.0545073829381633E-2]
[{"$f":"Calculations!A242","v":47},{"$f":"AnnMiles*Calculations!A242","v":47000},{"$f":"+Calculations!C242","v":386.17277779800338},{"$f":"+Calculations!D242","v":1096.8232688269497},{"$f":"+Calculations!E242","v":1065.0100089974601},2548.0060556224134,{"$f":"+Calculations!F242","v":54.893621509043449},2602.8996771314569,{"$f":"+Calculations!M242","v":28995.864501257634},{"$f":"+Calculations!N242","v":176.50898458983181},{"$f":"+Calculations!O242","v":1051.2530028960937},{"$f":"+Calculations!P242","v":1042.7317375840621},31266.358226327622,{"$f":"+Calculations!Q242","v":51.35686193428775},31317.71508826191,31317.71508826191,47,-28007.669793652818,3.4327442296009352,0,-28004.237049423216,-7.0539639922980388E-2]
[{"$f":"Calculations!A243","v":48},{"$f":"AnnMiles*Calculations!A243","v":48000},{"$f":"+Calculations!C243","v":386.17277779800338},{"$f":"+Calculations!D243","v":1098.2061371697741},{"$f":"+Calculations!E243","v":1065.677979660021},2550.0568946277986,{"$f":"+Calculations!F243","v":55.002418553161029},2605.0593131809596,{"$f":"+Calculations!M243","v":28913.786043227818},{"$f":"+Calculations!N243","v":177.10247890866694},{"$f":"+Calculations!O243","v":1051.385912913682},{"$f":"+Calculations!P243","v":1042.796691404187},31185.071126454353,{"$f":"+Calculations!Q243","v":51.367181394358504},31236.438307848712,31236.438307848712,48,-28005.618954647431,3.541541273718515,0,-28002.077413373714,-7.0534200033686933E-2]
[{"$f":"Calculations!A244","v":49},{"$f":"AnnMiles*Calculations!A244","v":49000},{"$f":"+Calculations!C244","v":386.17277779800338},{"$f":"+Calculations!D244","v":1099.5907490248926},{"$f":"+Calculations!E244","v":1066.3463692715143},2552.10989609441,{"$f":"+Calculations!F244","v":55.111431228830774},2607.221327323241,{"$f":"+Calculations!M244","v":28837.49616889875},{"$f":"+Calculations!N244","v":177.65411703742538},{"$f":"+Calculations!O244","v":1051.5131027906314},{"$f":"+Calculations!P244","v":1042.8588279214282},31109.522216648234,{"$f":"+Calculations!Q244","v":51.377060707600343},31160.899277355835,31160.899277355835,49,-28003.56595318082,3.6505539493882608,0,-27999.915399231431,-7.0528754154235346E-2]
[{"$f":"Calculations!A245","v":50},{"$f":"AnnMiles*Calculations!A245","v":50000},{"$f":"+Calculations!C245","v":386.17277779800338},{"$f":"+Calculations!D245","v":1100.9771065905152},{"$f":"+Calculations!E245","v":1067.0151780947028},2554.1650624832214,{"$f":"+Calculations!F245","v":55.220659963426073},2609.3857224466474,{"$f":"+Calculations!M245","v":28766.560267224246},{"$f":"+Calculations!N245","v":178.16704156909691},{"$f":"+Calculations!O245","v":1051.6347767976056},{"$f":"+Calculations!P245","v":1042.9182489082805},31039.280334499228,{"$f":"+Calculations!Q245","v":51.386515383460214},31090.666849882688,31090.666849882688,50,-28001.510786792009,3.7597826839835591,0,-27997.751004108024,-7.0523302277350181E-2]
[{"$f":"Calculations!A246","v":51},{"$f":"AnnMiles*Calculations!A246","v":51000},{"$f":"+Calculations!C246","v":386.17277779800338},{"$f":"+Calculations!D246","v":1102.3652120676236},{"$f":"+Calculations!E246","v":1067.6844063925153},2556.222396258142,{"$f":"+Calculations!F246","v":55.330105185167433},2611.5525014433092,{"$f":"+Calculations!M246","v":28700.579792468197},{"$f":"+Calculations!N246","v":178.64413431501004},{"$f":"+Calculations!O246","v":1051.7511347553389},{"$f":"+Calculations!P246","v":1042.9750538517119},30973.950115390257,{"$f":"+Calculations!Q246","v":51.395560605584194},31025.345675995839,31025.345675995839,51,-27999.453453017089,3.8692279057249195,0,-27995.584225111365,-7.0517844395746515E-2]
[{"$f":"Calculations!A247","v":52},{"$f":"AnnMiles*Calculations!A247","v":52000},{"$f":"+Calculations!C247","v":386.17277779800338},{"$f":"+Calculations!D247","v":1103.755067659974},{"$f":"+Calculations!E247","v":1068.354054428044},2558.2818998860212,{"$f":"+Calculations!F247","v":55.439767323124023},2613.7216672091454,{"$f":"+Calculations!M247","v":28639.188830764822},{"$f":"+Calculations!N247","v":179.08804113140681},{"$f":"+Calculations!O247","v":1051.8623719316067},{"$f":"+Calculations!P247","v":1043.0293399066877},30913.168583734521,{"$f":"+Calculations!Q247","v":51.40421122315054},30964.572794957672,30964.572794957672,52,-27997.39394938921,3.9788900436815098,0,-27993.415059345527,-7.0512380502129796E-2]
[{"$f":"Calculations!A248","v":53},{"$f":"AnnMiles*Calculations!A248","v":53000},{"$f":"+Calculations!C248","v":386.17277779800338},{"$f":"+Calculations!D248","v":1105.1466755741021},{"$f":"+Calculations!E248","v":1069.0241224645479},2560.3435758366531,{"$f":"+Calculations!F248","v":55.549646807215431},2615.8932226438687,{"$f":"+Calculations!M248","v":28582.051048541205},{"$f":"+Calculations!N248","v":179.50119398484173},{"$f":"+Calculations!O248","v":1051.9686789557147},{"$f":"+Calculations!P248","v":1043.0812018582785},30856.602123340042,{"$f":"+Calculations!Q248","v":51.412481743556121},30908.014605083597,30908.014605083597,53,-27995.332273438577,4.0887695277729179,0,-27991.243503910802,-7.0506910589195976E-2]
[{"$f":"Calculations!A249","v":54},{"$f":"AnnMiles*Calculations!A249","v":54000},{"$f":"+Calculations!C249","v":386.17277779800338},{"$f":"+Calculations!D249","v":1106.5400380193239},{"$f":"+Calculations!E249","v":1069.6946107654499},2562.4074265827771,{"$f":"+Calculations!F249","v":55.659744068213342},2618.0671706509906,{"$f":"+Calculations!M249","v":28528.856973634433},{"$f":"+Calculations!N249","v":179.88583061192594},{"$f":"+Calculations!O249","v":1052.0702417496818},{"$f":"+Calculations!P249","v":1043.1307320919393},30803.943778087982,{"$f":"+Calculations!Q249","v":51.420386326395999},30855.364164414379,30855.364164414379,54,-27993.268422692454,4.1988667887708289,0,-27989.069555903683,-7.0501434649631448E-2]
[{"$f":"Calculations!A250","v":55},{"$f":"AnnMiles*Calculations!A250","v":55000},{"$f":"+Calculations!C250","v":386.17277779800338},{"$f":"+Calculations!D250","v":1107.9351572077428},{"$f":"+Calculations!E250","v":1070.3655195943384},2564.4734546000846,{"$f":"+Calculations!F250","v":55.770059537743172},2620.2435141378278,{"$f":"+Calculations!M250","v":28479.321567094197},{"$f":"+Calculations!N250","v":180.24401207717878},{"$f":"+Calculations!O250","v":1052.1672414752966},{"$f":"+Calculations!P250","v":1043.1780205715377},30754.91084121821,{"$f":"+Calculations!Q250","v":51.427938778674061},30806.338779996884,30806.338779996884,55,-27991.202394675147,4.3091822583006589,0,-27986.893212416846,-7.0495952676112958E-2]
[{"$f":"Calculations!A251","v":56},{"$f":"AnnMiles*Calculations!A251","v":56000},{"$f":"+Calculations!C251","v":386.17277779800338},{"$f":"+Calculations!D251","v":1109.3320353542497},{"$f":"+Calculations!E251","v":1071.0368492149669},2566.5416623672199,{"$f":"+Calculations!F251","v":55.880593648285846},2622.4222560155058,{"$f":"+Calculations!M251","v":28433.182049666881},{"$f":"+Calculations!N251","v":180.5776384893241},{"$f":"+Calculations!O251","v":1052.2598544961929},{"$f":"+Calculations!P251","v":1043.2231548247071},30709.242697477108,{"$f":"+Calculations!Q251","v":51.435152551181609},30760.677850028289,30760.677850028289,56,-27989.13418690801,4.4197163688433321,0,-27984.714470539166,-7.049046466130772E-2]
[{"$f":"Calculations!A252","v":57},{"$f":"AnnMiles*Calculations!A252","v":57000},{"$f":"+Calculations!C252","v":386.17277779800338},{"$f":"+Calculations!D252","v":1110.7306746765291},{"$f":"+Calculations!E252","v":1071.7085998912544},2568.6120523657869,{"$f":"+Calculations!F252","v":55.991346833179442},2624.6033991989661,{"$f":"+Calculations!M252","v":28390.195952011902},{"$f":"+Calculations!N252","v":180.88846309981878},{"$f":"+Calculations!O252","v":1052.3482523540849},{"$f":"+Calculations!P252","v":1043.2662199350855},30666.698887400889,{"$f":"+Calculations!Q252","v":51.442040735979177},30718.140928136869,30718.140928136869,57,-27987.063796909442,4.5304695537369284,0,-27982.533327355704,-7.0484970597873314E-2]
[{"$f":"Calculations!A253","v":58},{"$f":"AnnMiles*Calculations!A253","v":58000},{"$f":"+Calculations!C253","v":386.17277779800338},{"$f":"+Calculations!D253","v":1112.1310773950611},{"$f":"+Calculations!E253","v":1072.3807718872863},2570.6846270803508,{"$f":"+Calculations!F253","v":56.102319526620867},2626.7869466069715,{"$f":"+Calculations!M253","v":28350.139361969694},{"$f":"+Calculations!N253","v":181.17810497653772},{"$f":"+Calculations!O253","v":1052.4326017583044},{"$f":"+Calculations!P253","v":1043.3072985410161},30627.05736724555,{"$f":"+Calculations!Q253","v":51.448616064917182},30678.505983310468,30678.505983310468,58,-27984.99122219488,4.6414422471783539,0,-27980.349779947701,-7.0479470478457679E-2]
[{"$f":"Calculations!A254","v":59},{"$f":"AnnMiles*Calculations!A254","v":59000},{"$f":"+Calculations!C254","v":386.17277779800338},{"$f":"+Calculations!D254","v":1113.5332457331249},{"$f":"+Calculations!E254","v":1073.0533654673125},2572.759388998441,{"$f":"+Calculations!F254","v":56.213512163667616},2628.9729011621084,{"$f":"+Calculations!M254","v":28312.805345815887},{"$f":"+Calculations!N254","v":181.44806041939628},{"$f":"+Calculations!O254","v":1052.5130645877828},{"$f":"+Calculations!P254","v":1043.3464708402757},30590.112941663341,{"$f":"+Calculations!Q254","v":51.454890909130498},30641.567832572473,30641.567832572473,59,-27982.916460276789,4.7526348842251025,0,-27978.163825392563,-7.0473964295699146E-2]
[{"$f":"Calculations!A255","v":60},{"$f":"AnnMiles*Calculations!A255","v":60000},{"$f":"+Calculations!C255","v":386.17277779800338},{"$f":"+Calculations!D255","v":1114.9371819168034},{"$f":"+Calculations!E255","v":1073.7263808957487},2574.8363406105555,{"$f":"+Calculations!F255","v":56.324925180239454},2631.1612657907949,{"$f":"+Calculations!M255","v":28278.002523507723},{"$f":"+Calculations!N255","v":181.69971326248233},{"$f":"+Calculations!O255","v":1052.5897979046197},{"$f":"+Calculations!P255","v":1043.3838146004043},30555.675849275231,{"$f":"+Calculations!Q255","v":51.460877279442514},30607.136726554672,30607.136726554672,60,-27980.839508664674,4.8640479007969404,0,-27975.975460763879,-7.046845204222639E-2]
[]
["Fitting Model Coefficients for Use in Prioritization Tool:  Priority Index = C2*Age^2 + C1*Age + C0"]
[null,"C2","C1","C0"]
[null,{"$f":"+Calculations!B260","v":3.0023960731037653E-9},{"$f":"+Calculations!C260","v":5.1547183667716206E-6},{"$f":"+Calculations!D260","v":-7.078854418627642E-2}]
[]
[]
["Output Table and Chart Data"]
[]
[null,"Prioritization","Replacement"]
["Age","Index","Benefits"]
[{"$f":"+A172-1","v":40},{"$f":"INDEX($V$101:$V$160,A171)","v":-7.0577552032748125E-2},{"$f":"INDEX($U$101:$U$160,A171)","v":-28019.288157001007}]
[41,{"$f":"INDEX($V$101:$V$160,A172)","v":-7.0572153871647197E-2},{"$f":"INDEX($U$101:$U$160,A172)","v":-28017.145087043937}]
[42,-7.056674977105043E-2,-28014.999659107023]
[43,-7.056133972374877E-2,-28012.851870328261]
[44,-7.0555923722523631E-2,-28010.701717841883]
[45,-7.0550501760147072E-2,-28008.54919877839]
[46,-7.0545073829381633E-2,-28006.39431026451]
[47,-7.0539639922980388E-2,-28004.237049423216]
[48,-7.0534200033686933E-2,-28002.077413373714]
[{"$f":"+A181-1","v":49},-7.0528754154235346E-2,-27999.915399231431]
[{"$f":"MAX(11,MIN(50,F39))","v":50},-7.0523302277350181E-2,-27997.751004108024]
[{"$f":"1+A181","v":51},-7.0517844395746515E-2,-27995.584225111365]
[{"$f":"1+A182","v":52},-7.0512380502129796E-2,-27993.415059345527]
[53,-7.0506910589195976E-2,-27991.243503910802]
[54,-7.0501434649631448E-2,-27989.069555903683]
[55,-7.0495952676112958E-2,-27986.893212416846]
[56,-7.049046466130772E-2,-27984.714470539166]
[57,-7.0484970597873314E-2,-27982.533327355704]
[58,-7.0479470478457679E-2,-27980.349779947701]
[59,-7.0473964295699146E-2,-27978.163825392563]
[60,-7.046845204222639E-2,-27975.975460763879]

{"sheet":"Cost_by_Year","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,2,4,8],[4,0,6,0],[4,1,6,1],[5,2,5,6],[5,7,6,7],[5,8,6,8]]}
["Transit Asset Rehabilitation/Replacement Vehicle Model"]
["Predicted Costs by Year"]
[]
["Year-by-Year Data"]
["Year","Lifetime Mileage at Which Vehicles are Replaced","Annual Costs in Thousands of Dollars"]
[null,null,"Agency Costs",null,null,null,null,"Passenger Delay Cost","Total Cost"]
[null,null,"New Buses","Rehab.","Maint.","Energy","Subtotal"]
[{"$f":"+BaseYear+1","v":2010},{"$f":"Inputs_Results!F38","v":60000},{"$f":"+Calculations!BC39/1000","v":0},{"$f":"+Calculations!BC69/1000","v":0.15899172281170701},{"$f":"Calculations!BC132/1000","v":1.0012608438085528},{"$f":"+Calculations!BC102/1000","v":1.000627208898575},{"$f":"SUM(C8:F8)","v":2.1608797755188349},{"$f":"+Calculations!BC162/1000","v":4.8495932877684993E-2},{"$f":"SUM(G8:H8)","v":2.2093757083965198}]
[{"$f":"1+A8","v":2011},{"$f":"B8","v":60000},{"$f":"+Calculations!BC40/1000","v":0},{"$f":"+Calculations!BC70/1000","v":0.15899172281170701},{"$f":"Calculations!BC133/1000","v":1.0025232276065308},{"$f":"+Calculations!BC103/1000","v":1.0012547988874556},2.1627697493056934,{"$f":"+Calculations!BC163/1000","v":4.8592049949282248E-2},2.2113617992549757]
[2012,{"$f":"B9","v":60000},{"$f":"+Calculations!BC41/1000","v":0},{"$f":"+Calculations!BC71/1000","v":0.15899172281170701},{"$f":"Calculations!BC134/1000","v":1.0037872030105957},{"$f":"+Calculations!BC104/1000","v":1.0018827824986469},2.1646617083209496,{"$f":"+Calculations!BC164/1000","v":4.8688357521214365E-2},2.2133500658421639]
[2013,60000,{"$f":"+Calculations!BC42/1000","v":0},{"$f":"+Calculations!BC72/1000","v":0.15899172281170701},{"$f":"Calculations!BC135/1000","v":1.0050527720274347},{"$f":"+Calculations!BC105/1000","v":1.0025111599790275},2.1665556548181693,{"$f":"+Calculations!BC165/1000","v":4.8784855971045663E-2},2.2153405107892148]
[2014,60000,{"$f":"+Calculations!BC43/1000","v":0},{"$f":"+Calculations!BC73/1000","v":0.15899172281170701},{"$f":"Calculations!BC136/1000","v":1.0063199366662661},{"$f":"+Calculations!BC106/1000","v":1.0031399315756306},2.1684515910536035,{"$f":"+Calculations!BC166/1000","v":4.8881545677088779E-2},2.2173331367306921]
[2015,60000,{"$f":"+Calculations!BC44/1000","v":0},{"$f":"+Calculations!BC74/1000","v":0.15899172281170701},{"$f":"Calculations!BC137/1000","v":1.0075886989388398},{"$f":"+Calculations!BC107/1000","v":1.0037690975356452},2.1703495192861921,{"$f":"+Calculations!BC167/1000","v":4.8978427018406191E-2},2.2193279463045985]
[2016,60000,{"$f":"+Calculations!BC45/1000","v":0},{"$f":"+Calculations!BC75/1000","v":0.15899172281170701},{"$f":"Calculations!BC138/1000","v":1.0088590608594439},{"$f":"+Calculations!BC108/1000","v":1.0043986581064139},2.1722494417775646,{"$f":"+Calculations!BC168/1000","v":4.907550037481162E-2},2.2213249421523762]
[2017,60000,{"$f":"+Calculations!BC46/1000","v":0},{"$f":"+Calculations!BC76/1000","v":0.15899172281170701},{"$f":"Calculations!BC139/1000","v":1.0101310244449049},{"$f":"+Calculations!BC109/1000","v":1.005028613535436},2.174151360792048,{"$f":"+Calculations!BC169/1000","v":4.9172766126871562E-2},2.2233241269189197]
[2018,60000,{"$f":"+Calculations!BC47/1000","v":0},{"$f":"+Calculations!BC77/1000","v":0.15899172281170701},{"$f":"Calculations!BC140/1000","v":1.0114045917145924},{"$f":"+Calculations!BC110/1000","v":1.0056589640703648},2.1760552785966643,{"$f":"+Calculations!BC170/1000","v":4.9270224655906816E-2},2.2253255032525709]
[2019,60000,{"$f":"+Calculations!BC48/1000","v":0},{"$f":"+Calculations!BC78/1000","v":0.15899172281170701},{"$f":"Calculations!BC141/1000","v":1.0126797646904224},{"$f":"+Calculations!BC111/1000","v":1.0062897099590091},2.1779611974611388,{"$f":"+Calculations!BC171/1000","v":4.9367876343993922E-2},2.2273290738051328]
[2020,60000,{"$f":"+Calculations!BC49/1000","v":0},{"$f":"+Calculations!BC79/1000","v":0.15899172281170701},{"$f":"Calculations!BC142/1000","v":1.0139565453968591},{"$f":"+Calculations!BC112/1000","v":1.006920851449334},2.1798691196579001,{"$f":"+Calculations!BC172/1000","v":4.946572157396667E-2},2.229334841231867]
[2021,60000,{"$f":"+Calculations!BC50/1000","v":0},{"$f":"+Calculations!BC80/1000","v":0.15899172281170701},{"$f":"Calculations!BC143/1000","v":1.0152349358609205},{"$f":"+Calculations!BC113/1000","v":1.0075523887894593},2.1817790474620868,{"$f":"+Calculations!BC173/1000","v":4.9563760729417622E-2},2.2313428081915045]
[2022,60000,{"$f":"+Calculations!BC51/1000","v":0},{"$f":"+Calculations!BC81/1000","v":0.15899172281170701},{"$f":"Calculations!BC144/1000","v":1.0165149381121792},{"$f":"+Calculations!BC114/1000","v":1.0081843222276605},2.1836909831515467,{"$f":"+Calculations!BC174/1000","v":4.9661994194699625E-2},2.2333529773462462]
[2023,60000,{"$f":"+Calculations!BC52/1000","v":0},{"$f":"+Calculations!BC82/1000","v":0.15899172281170701},{"$f":"Calculations!BC145/1000","v":1.0177965541827674},{"$f":"+Calculations!BC115/1000","v":1.0088166520123691},2.1856049290068436,{"$f":"+Calculations!BC175/1000","v":4.9760422354927288E-2},2.2353653513617711]
[2024,60000,{"$f":"+Calculations!BC53/1000","v":0},{"$f":"+Calculations!BC83/1000","v":0.15899172281170701},{"$f":"Calculations!BC146/1000","v":1.0190797861073784},{"$f":"+Calculations!BC116/1000","v":1.0094493783921725},2.1875208873112579,{"$f":"+Calculations!BC176/1000","v":4.9859045595978466E-2},2.2373799329072366]
[2025,60000,{"$f":"+Calculations!BC54/1000","v":0},{"$f":"+Calculations!BC84/1000","v":0.15899172281170701},{"$f":"Calculations!BC147/1000","v":1.0203646359232723},{"$f":"+Calculations!BC117/1000","v":1.0100825016158135},2.1894388603507928,{"$f":"+Calculations!BC177/1000","v":4.9957864304495864E-2},2.2393967246552888]
[2026,60000,{"$f":"+Calculations!BC55/1000","v":0},{"$f":"+Calculations!BC85/1000","v":0.15899172281170701},{"$f":"Calculations!BC148/1000","v":1.0216511056702762},{"$f":"+Calculations!BC118/1000","v":1.0107160219321909},2.1913588504141739,{"$f":"+Calculations!BC178/1000","v":5.0056878867888469E-2},2.2414157292820622]
[2027,60000,{"$f":"+Calculations!BC56/1000","v":0},{"$f":"+Calculations!BC86/1000","v":0.15899172281170701},{"$f":"Calculations!BC149/1000","v":1.02293919739079},{"$f":"+Calculations!BC119/1000","v":1.0113499395903609},2.1932808597928579,{"$f":"+Calculations!BC179/1000","v":5.0156089674333104E-2},2.2434369494671911]
[2028,60000,{"$f":"+Calculations!BC57/1000","v":0},{"$f":"+Calculations!BC87/1000","v":0.15899172281170701},{"$f":"Calculations!BC150/1000","v":1.0242289131297886},{"$f":"+Calculations!BC120/1000","v":1.0119842548395339},2.1952048907810298,{"$f":"+Calculations!BC180/1000","v":5.0255497112775938E-2},2.2454603878938055]
[2029,60000,{"$f":"+Calculations!BC58/1000","v":0},{"$f":"+Calculations!BC88/1000","v":0.15899172281170701},{"$f":"Calculations!BC151/1000","v":1.025520254934825},{"$f":"+Calculations!BC121/1000","v":1.012618967929078},2.1971309456756103,{"$f":"+Calculations!BC181/1000","v":5.0355101572934012E-2},2.2474860472485445]
[2030,60000,{"$f":"+Calculations!BC59/1000","v":0},{"$f":"+Calculations!BC89/1000","v":0.15899172281170701},{"$f":"Calculations!BC152/1000","v":1.0268132248560331},{"$f":"+Calculations!BC122/1000","v":1.0132540791085178},2.1990590267762578,{"$f":"+Calculations!BC182/1000","v":5.0454903445296788E-2},2.2495139302215543]
[2031,60000,{"$f":"+Calculations!BC60/1000","v":0},{"$f":"+Calculations!BC90/1000","v":0.15899172281170701},{"$f":"Calculations!BC153/1000","v":1.0281078249461333},{"$f":"+Calculations!BC123/1000","v":1.0138895886275332},2.2009891363853735,{"$f":"+Calculations!BC183/1000","v":5.0554903121127669E-2},2.2515440395065012]
[2032,60000,{"$f":"+Calculations!BC61/1000","v":0},{"$f":"+Calculations!BC91/1000","v":0.15899172281170701},{"$f":"Calculations!BC154/1000","v":1.0294040572604315},{"$f":"+Calculations!BC124/1000","v":1.0145254967359618},2.2029212768081003,{"$f":"+Calculations!BC184/1000","v":5.0655100992465472E-2},2.2535763778005657]
[2033,60000,{"$f":"+Calculations!BC62/1000","v":0},{"$f":"+Calculations!BC92/1000","v":0.15899172281170701},{"$f":"Calculations!BC155/1000","v":1.0307019238568278},{"$f":"+Calculations!BC125/1000","v":1.0151618036837977},2.2048554503523325,{"$f":"+Calculations!BC185/1000","v":5.0755497452126097E-2},2.2556109478044588]
[2034,60000,{"$f":"+Calculations!BC63/1000","v":0},{"$f":"+Calculations!BC93/1000","v":0.15899172281170701},{"$f":"Calculations!BC156/1000","v":1.0320014267958146},{"$f":"+Calculations!BC126/1000","v":1.015798509721191},2.2067916593287125,{"$f":"+Calculations!BC186/1000","v":5.0856092893703936E-2},2.2576477522224163]
[2035,60000,{"$f":"+Calculations!BC64/1000","v":0},{"$f":"+Calculations!BC94/1000","v":0.15899172281170701},{"$f":"Calculations!BC157/1000","v":1.0333025681404833},{"$f":"+Calculations!BC127/1000","v":1.0164356150984499},2.2087299060506402,{"$f":"+Calculations!BC187/1000","v":5.0956887711573501E-2},2.2596867937622136]
[2036,60000,{"$f":"+Calculations!BC65/1000","v":0},{"$f":"+Calculations!BC95/1000","v":0.15899172281170701},{"$f":"Calculations!BC158/1000","v":1.0346053499565266},{"$f":"+Calculations!BC128/1000","v":1.0170731200660388},2.2106701928342725,{"$f":"+Calculations!BC188/1000","v":5.1057882300890908E-2},2.2617280751351632]
[2037,60000,{"$f":"+Calculations!BC66/1000","v":0},{"$f":"+Calculations!BC96/1000","v":0.15899172281170701},{"$f":"Calculations!BC159/1000","v":1.0359097743122407},{"$f":"+Calculations!BC129/1000","v":1.0177110248745795},2.2126125219985271,{"$f":"+Calculations!BC189/1000","v":5.1159077057595488E-2},2.2637715990561227]
[2038,60000,{"$f":"+Calculations!BC67/1000","v":0},{"$f":"+Calculations!BC97/1000","v":0.15899172281170701},{"$f":"Calculations!BC160/1000","v":1.0372158432785299},{"$f":"+Calculations!BC130/1000","v":1.0183493297748507},2.2145568958650879,{"$f":"+Calculations!BC190/1000","v":5.1260472378411276E-2},2.265817368243499]
[2039,60000,{"$f":"+Calculations!BC68/1000","v":0},{"$f":"+Calculations!BC98/1000","v":0.15899172281170701},{"$f":"Calculations!BC161/1000","v":1.0385235589289097},{"$f":"+Calculations!BC131/1000","v":1.0189880350177887},2.2165033167584056,{"$f":"+Calculations!BC191/1000","v":5.136206866084865E-2},2.2678653854192543]

{"sheet":"Calculations","index":5,"n_rows":284,"n_cols":55,"rows_kept":284,"cut":false,"hidden":false,"merged":[[193,11,194,11],[193,12,193,16],[193,7,193,10],[261,3,262,3],[261,0,262,0],[261,1,262,1],[261,2,262,2],[193,2,193,5],[193,6,194,6]]}
["Transit Asset Rehabilitation/Replacement Vehicle Model"]
["Inputs and Summary Results"]
[]
["Calculations by Fleet Group and Year"]
["Index",null,null,1,{"$f":"1+D5","v":2},{"$f":"1+E5","v":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,{"$f":"1+AR5","v":42},43,44,45,46,47,48,49,50]
["Vehicles",null,null,{"$f":"INDEX(TotalFleet,D5)","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"INDEX(TotalFleet,AJ5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D6:BB6)","v":1}]
["LTDMiles",null,0,{"$f":"INDEX(AvgLifetimeMileage,D5)","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"INDEX(AvgLifetimeMileage,AJ5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Miles by Fleet Group and Year"]
[{"$f":"IF(Cost_by_Year!B8=\"\",PolicyLTDMiles,Cost_by_Year!B8)","v":60000},null,{"$f":"1+C7","v":1},{"$f":"IF(D7+AnnMiles>=$A9,0,D7+AnnMiles)","v":1001},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"IF(AJ7+AnnMiles>=$A9,0,AJ7+AnnMiles)","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[{"$f":"IF(Cost_by_Year!B9=\"\",PolicyLTDMiles,Cost_by_Year!B9)","v":60000},null,{"$f":"1+C9","v":2},{"$f":"IF(D9+AnnMiles>=$A10,0,D9+AnnMiles)","v":2001},{"$f":"IF(E9+AnnMiles>=$A10,0,E9+AnnMiles)","v":2000},{"$f":"IF(F9+AnnMiles>=$A10,0,F9+AnnMiles)","v":2000},{"$f":"IF(G9+AnnMiles>=$A10,0,G9+AnnMiles)","v":2000},{"$f":"IF(H9+AnnMiles>=$A10,0,H9+AnnMiles)","v":2000},{"$f":"IF(I9+AnnMiles>=$A10,0,I9+AnnMiles)","v":2000},{"$f":"IF(J9+AnnMiles>=$A10,0,J9+AnnMiles)","v":2000},{"$f":"IF(K9+AnnMiles>=$A10,0,K9+AnnMiles)","v":2000},{"$f":"IF(L9+AnnMiles>=$A10,0,L9+AnnMiles)","v":2000},{"$f":"IF(M9+AnnMiles>=$A10,0,M9+AnnMiles)","v":2000},{"$f":"IF(N9+AnnMiles>=$A10,0,N9+AnnMiles)","v":2000},{"$f":"IF(O9+AnnMiles>=$A10,0,O9+AnnMiles)","v":2000},{"$f":"IF(P9+AnnMiles>=$A10,0,P9+AnnMiles)","v":2000},{"$f":"IF(Q9+AnnMiles>=$A10,0,Q9+AnnMiles)","v":2000},{"$f":"IF(R9+AnnMiles>=$A10,0,R9+AnnMiles)","v":2000},{"$f":"IF(S9+AnnMiles>=$A10,0,S9+AnnMiles)","v":2000},{"$f":"IF(T9+AnnMiles>=$A10,0,T9+AnnMiles)","v":2000},{"$f":"IF(U9+AnnMiles>=$A10,0,U9+AnnMiles)","v":2000},{"$f":"IF(V9+AnnMiles>=$A10,0,V9+AnnMiles)","v":2000},{"$f":"IF(W9+AnnMiles>=$A10,0,W9+AnnMiles)","v":2000},{"$f":"IF(X9+AnnMiles>=$A10,0,X9+AnnMiles)","v":2000},{"$f":"IF(Y9+AnnMiles>=$A10,0,Y9+AnnMiles)","v":2000},{"$f":"IF(Z9+AnnMiles>=$A10,0,Z9+AnnMiles)","v":2000},{"$f":"IF(AA9+AnnMiles>=$A10,0,AA9+AnnMiles)","v":2000},{"$f":"IF(AB9+AnnMiles>=$A10,0,AB9+AnnMiles)","v":2000},{"$f":"IF(AC9+AnnMiles>=$A10,0,AC9+AnnMiles)","v":2000},{"$f":"IF(AD9+AnnMiles>=$A10,0,AD9+AnnMiles)","v":2000},{"$f":"IF(AE9+AnnMiles>=$A10,0,AE9+AnnMiles)","v":2000},{"$f":"IF(AF9+AnnMiles>=$A10,0,AF9+AnnMiles)","v":2000},{"$f":"IF(AG9+AnnMiles>=$A10,0,AG9+AnnMiles)","v":2000},{"$f":"IF(AH9+AnnMiles>=$A10,0,AH9+AnnMiles)","v":2000},{"$f":"IF(AI9+AnnMiles>=$A10,0,AI9+AnnMiles)","v":2000},{"$f":"IF(AJ9+AnnMiles>=$A10,0,AJ9+AnnMiles)","v":2000},{"$f":"IF(AK9+AnnMiles>=$A10,0,AK9+AnnMiles)","v":2000},{"$f":"IF(AL9+AnnMiles>=$A10,0,AL9+AnnMiles)","v":2000},{"$f":"IF(AM9+AnnMiles>=$A10,0,AM9+AnnMiles)","v":2000},{"$f":"IF(AN9+AnnMiles>=$A10,0,AN9+AnnMiles)","v":2000},{"$f":"IF(AO9+AnnMiles>=$A10,0,AO9+AnnMiles)","v":2000},{"$f":"IF(AP9+AnnMiles>=$A10,0,AP9+AnnMiles)","v":2000},{"$f":"IF(AQ9+AnnMiles>=$A10,0,AQ9+AnnMiles)","v":2000},{"$f":"IF(AR9+AnnMiles>=$A10,0,AR9+AnnMiles)","v":2000},{"$f":"IF(AS9+AnnMiles>=$A10,0,AS9+AnnMiles)","v":2000},{"$f":"IF(AT9+AnnMiles>=$A10,0,AT9+AnnMiles)","v":2000},{"$f":"IF(AU9+AnnMiles>=$A10,0,AU9+AnnMiles)","v":2000},{"$f":"IF(AV9+AnnMiles>=$A10,0,AV9+AnnMiles)","v":2000},{"$f":"IF(AW9+AnnMiles>=$A10,0,AW9+AnnMiles)","v":2000},{"$f":"IF(AX9+AnnMiles>=$A10,0,AX9+AnnMiles)","v":2000},{"$f":"IF(AY9+AnnMiles>=$A10,0,AY9+AnnMiles)","v":2000},{"$f":"IF(AZ9+AnnMiles>=$A10,0,AZ9+AnnMiles)","v":2000},{"$f":"IF(BA9+AnnMiles>=$A10,0,BA9+AnnMiles)","v":2000}]
[{"$f":"IF(Cost_by_Year!B10=\"\",PolicyLTDMiles,Cost_by_Year!B10)","v":60000},null,3,3001,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000]
[{"$f":"IF(Cost_by_Year!B11=\"\",PolicyLTDMiles,Cost_by_Year!B11)","v":60000},null,4,4001,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000]
[{"$f":"IF(Cost_by_Year!B12=\"\",PolicyLTDMiles,Cost_by_Year!B12)","v":60000},null,5,5001,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000]
[{"$f":"IF(Cost_by_Year!B13=\"\",PolicyLTDMiles,Cost_by_Year!B13)","v":60000},null,6,6001,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000]
[{"$f":"IF(Cost_by_Year!B14=\"\",PolicyLTDMiles,Cost_by_Year!B14)","v":60000},null,7,7001,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000]
[{"$f":"IF(Cost_by_Year!B15=\"\",PolicyLTDMiles,Cost_by_Year!B15)","v":60000},null,8,8001,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000]
[{"$f":"IF(Cost_by_Year!B16=\"\",PolicyLTDMiles,Cost_by_Year!B16)","v":60000},null,9,9001,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000,9000]
[{"$f":"IF(Cost_by_Year!B17=\"\",PolicyLTDMiles,Cost_by_Year!B17)","v":60000},null,10,10001,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[{"$f":"IF(Cost_by_Year!B18=\"\",PolicyLTDMiles,Cost_by_Year!B18)","v":60000},null,11,11001,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000,11000]
[{"$f":"IF(Cost_by_Year!B19=\"\",PolicyLTDMiles,Cost_by_Year!B19)","v":60000},null,12,12001,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000]
[{"$f":"IF(Cost_by_Year!B20=\"\",PolicyLTDMiles,Cost_by_Year!B20)","v":60000},null,13,13001,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000,13000]
[{"$f":"IF(Cost_by_Year!B21=\"\",PolicyLTDMiles,Cost_by_Year!B21)","v":60000},null,14,14001,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,14000]
[{"$f":"IF(Cost_by_Year!B22=\"\",PolicyLTDMiles,Cost_by_Year!B22)","v":60000},null,15,15001,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000]
[{"$f":"IF(Cost_by_Year!B23=\"\",PolicyLTDMiles,Cost_by_Year!B23)","v":60000},null,16,16001,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000]
[{"$f":"IF(Cost_by_Year!B24=\"\",PolicyLTDMiles,Cost_by_Year!B24)","v":60000},null,17,17001,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000]
[{"$f":"IF(Cost_by_Year!B25=\"\",PolicyLTDMiles,Cost_by_Year!B25)","v":60000},null,18,18001,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000]
[{"$f":"IF(Cost_by_Year!B26=\"\",PolicyLTDMiles,Cost_by_Year!B26)","v":60000},null,19,19001,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000,19000]
[{"$f":"IF(Cost_by_Year!B27=\"\",PolicyLTDMiles,Cost_by_Year!B27)","v":60000},null,20,20001,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[{"$f":"IF(Cost_by_Year!B28=\"\",PolicyLTDMiles,Cost_by_Year!B28)","v":60000},null,21,21001,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000,21000]
[{"$f":"IF(Cost_by_Year!B29=\"\",PolicyLTDMiles,Cost_by_Year!B29)","v":60000},null,22,22001,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000,22000]
[{"$f":"IF(Cost_by_Year!B30=\"\",PolicyLTDMiles,Cost_by_Year!B30)","v":60000},null,23,23001,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000,23000]
[{"$f":"IF(Cost_by_Year!B31=\"\",PolicyLTDMiles,Cost_by_Year!B31)","v":60000},null,24,24001,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000]
[{"$f":"IF(Cost_by_Year!B32=\"\",PolicyLTDMiles,Cost_by_Year!B32)","v":60000},null,25,25001,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000,25000]
[{"$f":"IF(Cost_by_Year!B33=\"\",PolicyLTDMiles,Cost_by_Year!B33)","v":60000},null,26,26001,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000,26000]
[{"$f":"IF(Cost_by_Year!B34=\"\",PolicyLTDMiles,Cost_by_Year!B34)","v":60000},null,{"$f":"1+C34","v":27},27001,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000]
[{"$f":"IF(Cost_by_Year!B35=\"\",PolicyLTDMiles,Cost_by_Year!B35)","v":60000},null,{"$f":"1+C35","v":28},28001,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000,28000]
[{"$f":"IF(Cost_by_Year!B36=\"\",PolicyLTDMiles,Cost_by_Year!B36)","v":60000},null,{"$f":"1+C36","v":29},29001,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000,29000]
[{"$f":"IF(Cost_by_Year!B37=\"\",PolicyLTDMiles,Cost_by_Year!B37)","v":60000},null,{"$f":"1+C37","v":30},30001,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000]
["New Bus Cost",null,{"$f":"+C9","v":1},{"$f":"D$6*IF(D9=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ9=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D39:BB39)","v":0}]
[null,null,2,{"$f":"D$6*IF(D10=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ10=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,3,{"$f":"D$6*IF(D11=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ11=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,4,{"$f":"D$6*IF(D12=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ12=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,5,{"$f":"D$6*IF(D13=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ13=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,6,{"$f":"D$6*IF(D14=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ14=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,7,{"$f":"D$6*IF(D15=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ15=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,8,{"$f":"D$6*IF(D16=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ16=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,9,{"$f":"D$6*IF(D17=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ17=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,10,{"$f":"D$6*IF(D18=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ18=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,11,{"$f":"D$6*IF(D19=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ19=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,12,{"$f":"D$6*IF(D20=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ20=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,13,{"$f":"D$6*IF(D21=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ21=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,14,{"$f":"D$6*IF(D22=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ22=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,15,{"$f":"D$6*IF(D23=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ23=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,16,{"$f":"D$6*IF(D24=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ24=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,17,{"$f":"D$6*IF(D25=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ25=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,18,{"$f":"D$6*IF(D26=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ26=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,19,{"$f":"D$6*IF(D27=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ27=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,20,{"$f":"D$6*IF(D28=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ28=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,21,{"$f":"D$6*IF(D29=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ29=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,22,{"$f":"D$6*IF(D30=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ30=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,23,{"$f":"D$6*IF(D31=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ31=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,24,{"$f":"D$6*IF(D32=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ32=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,25,{"$f":"D$6*IF(D33=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ33=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,26,{"$f":"D$6*IF(D34=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ34=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,27,{"$f":"D$6*IF(D35=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ35=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,28,{"$f":"D$6*IF(D36=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ36=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,29,{"$f":"D$6*IF(D37=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ37=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,30,{"$f":"D$6*IF(D38=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*IF(AJ38=0,NewBusCost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
["Rehab Cost",null,1,{"$f":"D$6*VLOOKUP(D9,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ9,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,{"$f":"+C40","v":2},{"$f":"D$6*VLOOKUP(D10,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ10,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,3,{"$f":"D$6*VLOOKUP(D11,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ11,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,4,{"$f":"D$6*VLOOKUP(D12,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ12,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,5,{"$f":"D$6*VLOOKUP(D13,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ13,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,6,{"$f":"D$6*VLOOKUP(D14,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ14,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,7,{"$f":"D$6*VLOOKUP(D15,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ15,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,8,{"$f":"D$6*VLOOKUP(D16,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ16,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,9,{"$f":"D$6*VLOOKUP(D17,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ17,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,10,{"$f":"D$6*VLOOKUP(D18,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ18,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,11,{"$f":"D$6*VLOOKUP(D19,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ19,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,12,{"$f":"D$6*VLOOKUP(D20,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ20,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,13,{"$f":"D$6*VLOOKUP(D21,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ21,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,14,{"$f":"D$6*VLOOKUP(D22,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ22,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,15,{"$f":"D$6*VLOOKUP(D23,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ23,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,16,{"$f":"D$6*VLOOKUP(D24,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ24,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,17,{"$f":"D$6*VLOOKUP(D25,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ25,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,18,{"$f":"D$6*VLOOKUP(D26,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ26,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,19,{"$f":"D$6*VLOOKUP(D27,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ27,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,20,{"$f":"D$6*VLOOKUP(D28,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ28,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,21,{"$f":"D$6*VLOOKUP(D29,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ29,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,22,{"$f":"D$6*VLOOKUP(D30,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ30,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,23,{"$f":"D$6*VLOOKUP(D31,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ31,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,24,{"$f":"D$6*VLOOKUP(D32,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ32,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,25,{"$f":"D$6*VLOOKUP(D33,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ33,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,26,{"$f":"D$6*VLOOKUP(D34,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ34,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,27,{"$f":"D$6*VLOOKUP(D35,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ35,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,28,{"$f":"D$6*VLOOKUP(D36,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ36,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,29,{"$f":"D$6*VLOOKUP(D37,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ37,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
[null,null,30,{"$f":"D$6*VLOOKUP(D38,RehabArray,3)*AnnMiles","v":158.99172281170701},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*VLOOKUP(AJ38,RehabArray,3)*AnnMiles","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,158.99172281170701]
["Calibration","Fuel",null,{"$f":"D6*EXP(D7*FuelC1)","v":1.0000006270001967},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ6*EXP(AJ7*FuelC1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D99:BB99)","v":1.0000006270001967}]
[null,"Maintenance",null,{"$f":"D6*EXP(D7*MaintC1)","v":1.0000012600007937},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ6*EXP(AJ7*MaintC1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D100:BB100)","v":1.0000012600007937}]
[null,"Delay",null,{"$f":"D6*EXP(DelayC1*D7)","v":1.0000019800019602},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ6*EXP(DelayC1*AJ7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D101:BB101)","v":1.0000019800019602}]
["Fuel Cost",null,1,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D7+0.75*AnnMiles)*FuelC1)+EXP((D9+0.25*AnnMiles)*FuelC1))/2","v":1000.627208898575},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ7+0.75*AnnMiles)*FuelC1)+EXP((AJ9+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D102:BB102)","v":1000.627208898575}]
[null,null,{"$f":"1+C102","v":2},{"$f":"D$6*AnnMiles*FuelC2*(EXP((D9+0.75*AnnMiles)*FuelC1)+EXP((D10+0.25*AnnMiles)*FuelC1))/2","v":1001.2547988874555},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ9+0.75*AnnMiles)*FuelC1)+EXP((AJ10+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1001.2547988874555]
[null,null,{"$f":"1+C103","v":3},{"$f":"D$6*AnnMiles*FuelC2*(EXP((D10+0.75*AnnMiles)*FuelC1)+EXP((D11+0.25*AnnMiles)*FuelC1))/2","v":1001.882782498647},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ10+0.75*AnnMiles)*FuelC1)+EXP((AJ11+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1001.882782498647]
[null,null,4,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D11+0.75*AnnMiles)*FuelC1)+EXP((D12+0.25*AnnMiles)*FuelC1))/2","v":1002.5111599790275},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ11+0.75*AnnMiles)*FuelC1)+EXP((AJ12+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1002.5111599790275]
[null,null,5,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D12+0.75*AnnMiles)*FuelC1)+EXP((D13+0.25*AnnMiles)*FuelC1))/2","v":1003.1399315756307},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ12+0.75*AnnMiles)*FuelC1)+EXP((AJ13+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1003.1399315756307]
[null,null,6,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D13+0.75*AnnMiles)*FuelC1)+EXP((D14+0.25*AnnMiles)*FuelC1))/2","v":1003.7690975356453},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ13+0.75*AnnMiles)*FuelC1)+EXP((AJ14+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1003.7690975356453]
[null,null,7,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D14+0.75*AnnMiles)*FuelC1)+EXP((D15+0.25*AnnMiles)*FuelC1))/2","v":1004.398658106414},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ14+0.75*AnnMiles)*FuelC1)+EXP((AJ15+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1004.398658106414]
[null,null,8,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D15+0.75*AnnMiles)*FuelC1)+EXP((D16+0.25*AnnMiles)*FuelC1))/2","v":1005.028613535436},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ15+0.75*AnnMiles)*FuelC1)+EXP((AJ16+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1005.028613535436]
[null,null,9,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D16+0.75*AnnMiles)*FuelC1)+EXP((D17+0.25*AnnMiles)*FuelC1))/2","v":1005.6589640703647},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ16+0.75*AnnMiles)*FuelC1)+EXP((AJ17+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1005.6589640703647]
[null,null,10,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D17+0.75*AnnMiles)*FuelC1)+EXP((D18+0.25*AnnMiles)*FuelC1))/2","v":1006.2897099590091},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ17+0.75*AnnMiles)*FuelC1)+EXP((AJ18+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1006.2897099590091]
[null,null,11,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D18+0.75*AnnMiles)*FuelC1)+EXP((D19+0.25*AnnMiles)*FuelC1))/2","v":1006.920851449334},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ18+0.75*AnnMiles)*FuelC1)+EXP((AJ19+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1006.920851449334]
[null,null,12,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D19+0.75*AnnMiles)*FuelC1)+EXP((D20+0.25*AnnMiles)*FuelC1))/2","v":1007.5523887894592},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ19+0.75*AnnMiles)*FuelC1)+EXP((AJ20+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1007.5523887894592]
[null,null,13,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D20+0.75*AnnMiles)*FuelC1)+EXP((D21+0.25*AnnMiles)*FuelC1))/2","v":1008.1843222276605},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ20+0.75*AnnMiles)*FuelC1)+EXP((AJ21+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1008.1843222276605]
[null,null,14,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D21+0.75*AnnMiles)*FuelC1)+EXP((D22+0.25*AnnMiles)*FuelC1))/2","v":1008.8166520123692},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ21+0.75*AnnMiles)*FuelC1)+EXP((AJ22+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1008.8166520123692]
[null,null,15,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D22+0.75*AnnMiles)*FuelC1)+EXP((D23+0.25*AnnMiles)*FuelC1))/2","v":1009.4493783921724},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ22+0.75*AnnMiles)*FuelC1)+EXP((AJ23+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1009.4493783921724]
[null,null,16,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D23+0.75*AnnMiles)*FuelC1)+EXP((D24+0.25*AnnMiles)*FuelC1))/2","v":1010.0825016158134},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ23+0.75*AnnMiles)*FuelC1)+EXP((AJ24+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1010.0825016158134]
[null,null,17,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D24+0.75*AnnMiles)*FuelC1)+EXP((D25+0.25*AnnMiles)*FuelC1))/2","v":1010.7160219321909},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ24+0.75*AnnMiles)*FuelC1)+EXP((AJ25+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1010.7160219321909]
[null,null,18,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D25+0.75*AnnMiles)*FuelC1)+EXP((D26+0.25*AnnMiles)*FuelC1))/2","v":1011.3499395903608},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ25+0.75*AnnMiles)*FuelC1)+EXP((AJ26+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1011.3499395903608]
[null,null,19,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D26+0.75*AnnMiles)*FuelC1)+EXP((D27+0.25*AnnMiles)*FuelC1))/2","v":1011.9842548395339},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ26+0.75*AnnMiles)*FuelC1)+EXP((AJ27+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1011.9842548395339]
[null,null,20,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D27+0.75*AnnMiles)*FuelC1)+EXP((D28+0.25*AnnMiles)*FuelC1))/2","v":1012.6189679290781},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ27+0.75*AnnMiles)*FuelC1)+EXP((AJ28+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1012.6189679290781]
[null,null,21,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D28+0.75*AnnMiles)*FuelC1)+EXP((D29+0.25*AnnMiles)*FuelC1))/2","v":1013.2540791085178},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ28+0.75*AnnMiles)*FuelC1)+EXP((AJ29+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1013.2540791085178]
[null,null,22,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D29+0.75*AnnMiles)*FuelC1)+EXP((D30+0.25*AnnMiles)*FuelC1))/2","v":1013.8895886275332},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ29+0.75*AnnMiles)*FuelC1)+EXP((AJ30+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1013.8895886275332]
[null,null,23,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D30+0.75*AnnMiles)*FuelC1)+EXP((D31+0.25*AnnMiles)*FuelC1))/2","v":1014.5254967359617},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ30+0.75*AnnMiles)*FuelC1)+EXP((AJ31+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1014.5254967359617]
[null,null,24,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D31+0.75*AnnMiles)*FuelC1)+EXP((D32+0.25*AnnMiles)*FuelC1))/2","v":1015.1618036837976},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ31+0.75*AnnMiles)*FuelC1)+EXP((AJ32+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1015.1618036837976]
[null,null,25,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D32+0.75*AnnMiles)*FuelC1)+EXP((D33+0.25*AnnMiles)*FuelC1))/2","v":1015.798509721191},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ32+0.75*AnnMiles)*FuelC1)+EXP((AJ33+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1015.798509721191]
[null,null,26,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D33+0.75*AnnMiles)*FuelC1)+EXP((D34+0.25*AnnMiles)*FuelC1))/2","v":1016.4356150984498},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ33+0.75*AnnMiles)*FuelC1)+EXP((AJ34+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1016.4356150984498]
[null,null,27,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D34+0.75*AnnMiles)*FuelC1)+EXP((D35+0.25*AnnMiles)*FuelC1))/2","v":1017.0731200660388},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ34+0.75*AnnMiles)*FuelC1)+EXP((AJ35+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1017.0731200660388]
[null,null,28,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D35+0.75*AnnMiles)*FuelC1)+EXP((D36+0.25*AnnMiles)*FuelC1))/2","v":1017.7110248745796},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ35+0.75*AnnMiles)*FuelC1)+EXP((AJ36+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1017.7110248745796]
[null,null,29,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D36+0.75*AnnMiles)*FuelC1)+EXP((D37+0.25*AnnMiles)*FuelC1))/2","v":1018.3493297748506},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ36+0.75*AnnMiles)*FuelC1)+EXP((AJ37+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1018.3493297748506]
[null,null,30,{"$f":"D$6*AnnMiles*FuelC2*(EXP((D37+0.75*AnnMiles)*FuelC1)+EXP((D38+0.25*AnnMiles)*FuelC1))/2","v":1018.9880350177887},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*FuelC2*(EXP((AJ37+0.75*AnnMiles)*FuelC1)+EXP((AJ38+0.25*AnnMiles)*FuelC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1018.9880350177887]
["Maintenance Cost",null,1,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D7+0.75*AnnMiles)*MaintC1)+EXP((D9+0.25*AnnMiles)*MaintC1))/2","v":1001.2608438085527},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ7+0.75*AnnMiles)*MaintC1)+EXP((AJ9+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D132:BB132)","v":1001.2608438085527}]
[null,null,{"$f":"1+C132","v":2},{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D9+0.75*AnnMiles)*MaintC1)+EXP((D10+0.25*AnnMiles)*MaintC1))/2","v":1002.5232276065308},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ9+0.75*AnnMiles)*MaintC1)+EXP((AJ10+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D133:BB133)","v":1002.5232276065308}]
[null,null,{"$f":"1+C133","v":3},{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D10+0.75*AnnMiles)*MaintC1)+EXP((D11+0.25*AnnMiles)*MaintC1))/2","v":1003.7872030105957},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ10+0.75*AnnMiles)*MaintC1)+EXP((AJ11+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1003.7872030105957]
[null,null,4,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D11+0.75*AnnMiles)*MaintC1)+EXP((D12+0.25*AnnMiles)*MaintC1))/2","v":1005.0527720274348},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ11+0.75*AnnMiles)*MaintC1)+EXP((AJ12+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1005.0527720274348]
[null,null,5,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D12+0.75*AnnMiles)*MaintC1)+EXP((D13+0.25*AnnMiles)*MaintC1))/2","v":1006.3199366662661},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ12+0.75*AnnMiles)*MaintC1)+EXP((AJ13+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1006.3199366662661]
[null,null,6,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D13+0.75*AnnMiles)*MaintC1)+EXP((D14+0.25*AnnMiles)*MaintC1))/2","v":1007.5886989388398},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ13+0.75*AnnMiles)*MaintC1)+EXP((AJ14+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1007.5886989388398]
[null,null,7,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D14+0.75*AnnMiles)*MaintC1)+EXP((D15+0.25*AnnMiles)*MaintC1))/2","v":1008.859060859444},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ14+0.75*AnnMiles)*MaintC1)+EXP((AJ15+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1008.859060859444]
[null,null,8,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D15+0.75*AnnMiles)*MaintC1)+EXP((D16+0.25*AnnMiles)*MaintC1))/2","v":1010.1310244449049},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ15+0.75*AnnMiles)*MaintC1)+EXP((AJ16+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1010.1310244449049]
[null,null,9,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D16+0.75*AnnMiles)*MaintC1)+EXP((D17+0.25*AnnMiles)*MaintC1))/2","v":1011.4045917145925},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ16+0.75*AnnMiles)*MaintC1)+EXP((AJ17+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1011.4045917145925]
[null,null,10,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D17+0.75*AnnMiles)*MaintC1)+EXP((D18+0.25*AnnMiles)*MaintC1))/2","v":1012.6797646904225},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ17+0.75*AnnMiles)*MaintC1)+EXP((AJ18+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1012.6797646904225]
[null,null,11,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D18+0.75*AnnMiles)*MaintC1)+EXP((D19+0.25*AnnMiles)*MaintC1))/2","v":1013.9565453968592},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ18+0.75*AnnMiles)*MaintC1)+EXP((AJ19+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1013.9565453968592]
[null,null,12,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D19+0.75*AnnMiles)*MaintC1)+EXP((D20+0.25*AnnMiles)*MaintC1))/2","v":1015.2349358609206},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ19+0.75*AnnMiles)*MaintC1)+EXP((AJ20+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1015.2349358609206]
[null,null,13,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D20+0.75*AnnMiles)*MaintC1)+EXP((D21+0.25*AnnMiles)*MaintC1))/2","v":1016.5149381121792},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ20+0.75*AnnMiles)*MaintC1)+EXP((AJ21+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1016.5149381121792]
[null,null,14,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D21+0.75*AnnMiles)*MaintC1)+EXP((D22+0.25*AnnMiles)*MaintC1))/2","v":1017.7965541827674},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ21+0.75*AnnMiles)*MaintC1)+EXP((AJ22+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1017.7965541827674]
[null,null,15,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D22+0.75*AnnMiles)*MaintC1)+EXP((D23+0.25*AnnMiles)*MaintC1))/2","v":1019.0797861073785},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ22+0.75*AnnMiles)*MaintC1)+EXP((AJ23+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1019.0797861073785]
[null,null,16,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D23+0.75*AnnMiles)*MaintC1)+EXP((D24+0.25*AnnMiles)*MaintC1))/2","v":1020.3646359232723},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ23+0.75*AnnMiles)*MaintC1)+EXP((AJ24+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1020.3646359232723]
[null,null,17,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D24+0.75*AnnMiles)*MaintC1)+EXP((D25+0.25*AnnMiles)*MaintC1))/2","v":1021.6511056702761},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ24+0.75*AnnMiles)*MaintC1)+EXP((AJ25+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1021.6511056702761]
[null,null,18,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D25+0.75*AnnMiles)*MaintC1)+EXP((D26+0.25*AnnMiles)*MaintC1))/2","v":1022.93919739079},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ25+0.75*AnnMiles)*MaintC1)+EXP((AJ26+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1022.93919739079]
[null,null,19,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D26+0.75*AnnMiles)*MaintC1)+EXP((D27+0.25*AnnMiles)*MaintC1))/2","v":1024.2289131297887},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ26+0.75*AnnMiles)*MaintC1)+EXP((AJ27+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1024.2289131297887]
[null,null,20,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D27+0.75*AnnMiles)*MaintC1)+EXP((D28+0.25*AnnMiles)*MaintC1))/2","v":1025.5202549348251},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ27+0.75*AnnMiles)*MaintC1)+EXP((AJ28+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1025.5202549348251]
[null,null,21,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D28+0.75*AnnMiles)*MaintC1)+EXP((D29+0.25*AnnMiles)*MaintC1))/2","v":1026.813224856033},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ28+0.75*AnnMiles)*MaintC1)+EXP((AJ29+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1026.813224856033]
[null,null,22,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D29+0.75*AnnMiles)*MaintC1)+EXP((D30+0.25*AnnMiles)*MaintC1))/2","v":1028.1078249461332},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ29+0.75*AnnMiles)*MaintC1)+EXP((AJ30+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1028.1078249461332]
[null,null,23,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D30+0.75*AnnMiles)*MaintC1)+EXP((D31+0.25*AnnMiles)*MaintC1))/2","v":1029.4040572604315},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ30+0.75*AnnMiles)*MaintC1)+EXP((AJ31+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1029.4040572604315]
[null,null,24,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D31+0.75*AnnMiles)*MaintC1)+EXP((D32+0.25*AnnMiles)*MaintC1))/2","v":1030.7019238568278},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ31+0.75*AnnMiles)*MaintC1)+EXP((AJ32+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1030.7019238568278]
[null,null,25,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D32+0.75*AnnMiles)*MaintC1)+EXP((D33+0.25*AnnMiles)*MaintC1))/2","v":1032.0014267958147},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ32+0.75*AnnMiles)*MaintC1)+EXP((AJ33+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1032.0014267958147]
[null,null,26,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D33+0.75*AnnMiles)*MaintC1)+EXP((D34+0.25*AnnMiles)*MaintC1))/2","v":1033.3025681404833},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ33+0.75*AnnMiles)*MaintC1)+EXP((AJ34+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1033.3025681404833]
[null,null,27,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D34+0.75*AnnMiles)*MaintC1)+EXP((D35+0.25*AnnMiles)*MaintC1))/2","v":1034.6053499565267},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ34+0.75*AnnMiles)*MaintC1)+EXP((AJ35+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1034.6053499565267]
[null,null,28,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D35+0.75*AnnMiles)*MaintC1)+EXP((D36+0.25*AnnMiles)*MaintC1))/2","v":1035.9097743122406},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ35+0.75*AnnMiles)*MaintC1)+EXP((AJ36+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1035.9097743122406]
[null,null,29,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D36+0.75*AnnMiles)*MaintC1)+EXP((D37+0.25*AnnMiles)*MaintC1))/2","v":1037.21584327853},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ36+0.75*AnnMiles)*MaintC1)+EXP((AJ37+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1037.21584327853]
[null,null,30,{"$f":"+D$6*AnnMiles*MaintC2*(EXP((D37+0.75*AnnMiles)*MaintC1)+EXP((D38+0.25*AnnMiles)*MaintC1))/2","v":1038.5235589289098},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AJ$6*AnnMiles*MaintC2*(EXP((AJ37+0.75*AnnMiles)*MaintC1)+EXP((AJ38+0.25*AnnMiles)*MaintC1))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1038.5235589289098]
["Passenger Delay",null,1,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D7+0.75*AnnMiles))+EXP(DelayC1*(D9+0.25*AnnMiles)))/2","v":48.495932877684993},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ7+0.75*AnnMiles))+EXP(DelayC1*(AJ9+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D162:BB162)","v":48.495932877684993}]
[null,null,{"$f":"1+C162","v":2},{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D9+0.75*AnnMiles))+EXP(DelayC1*(D10+0.25*AnnMiles)))/2","v":48.592049949282249},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ9+0.75*AnnMiles))+EXP(DelayC1*(AJ10+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,48.592049949282249]
[null,null,{"$f":"1+C163","v":3},{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D10+0.75*AnnMiles))+EXP(DelayC1*(D11+0.25*AnnMiles)))/2","v":48.688357521214364},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ10+0.75*AnnMiles))+EXP(DelayC1*(AJ11+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,48.688357521214364]
[null,null,4,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D11+0.75*AnnMiles))+EXP(DelayC1*(D12+0.25*AnnMiles)))/2","v":48.784855971045666},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ11+0.75*AnnMiles))+EXP(DelayC1*(AJ12+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,48.784855971045666]
[null,null,5,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D12+0.75*AnnMiles))+EXP(DelayC1*(D13+0.25*AnnMiles)))/2","v":48.881545677088781},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ12+0.75*AnnMiles))+EXP(DelayC1*(AJ13+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,48.881545677088781]
[null,null,6,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D13+0.75*AnnMiles))+EXP(DelayC1*(D14+0.25*AnnMiles)))/2","v":48.978427018406194},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ13+0.75*AnnMiles))+EXP(DelayC1*(AJ14+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,48.978427018406194]
[null,null,7,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D14+0.75*AnnMiles))+EXP(DelayC1*(D15+0.25*AnnMiles)))/2","v":49.075500374811618},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ14+0.75*AnnMiles))+EXP(DelayC1*(AJ15+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.075500374811618]
[null,null,8,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D15+0.75*AnnMiles))+EXP(DelayC1*(D16+0.25*AnnMiles)))/2","v":49.172766126871565},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ15+0.75*AnnMiles))+EXP(DelayC1*(AJ16+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.172766126871565]
[null,null,9,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D16+0.75*AnnMiles))+EXP(DelayC1*(D17+0.25*AnnMiles)))/2","v":49.270224655906816},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ16+0.75*AnnMiles))+EXP(DelayC1*(AJ17+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.270224655906816]
[null,null,10,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D17+0.75*AnnMiles))+EXP(DelayC1*(D18+0.25*AnnMiles)))/2","v":49.36787634399392},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ17+0.75*AnnMiles))+EXP(DelayC1*(AJ18+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.36787634399392]
[null,null,11,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D18+0.75*AnnMiles))+EXP(DelayC1*(D19+0.25*AnnMiles)))/2","v":49.465721573966668},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ18+0.75*AnnMiles))+EXP(DelayC1*(AJ19+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.465721573966668]
[null,null,12,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D19+0.75*AnnMiles))+EXP(DelayC1*(D20+0.25*AnnMiles)))/2","v":49.563760729417623},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ19+0.75*AnnMiles))+EXP(DelayC1*(AJ20+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.563760729417623]
[null,null,13,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D20+0.75*AnnMiles))+EXP(DelayC1*(D21+0.25*AnnMiles)))/2","v":49.661994194699624},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ20+0.75*AnnMiles))+EXP(DelayC1*(AJ21+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.661994194699624]
[null,null,14,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D21+0.75*AnnMiles))+EXP(DelayC1*(D22+0.25*AnnMiles)))/2","v":49.760422354927286},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ21+0.75*AnnMiles))+EXP(DelayC1*(AJ22+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.760422354927286]
[null,null,15,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D22+0.75*AnnMiles))+EXP(DelayC1*(D23+0.25*AnnMiles)))/2","v":49.859045595978465},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ22+0.75*AnnMiles))+EXP(DelayC1*(AJ23+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.859045595978465]
[null,null,16,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D23+0.75*AnnMiles))+EXP(DelayC1*(D24+0.25*AnnMiles)))/2","v":49.957864304495864},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ23+0.75*AnnMiles))+EXP(DelayC1*(AJ24+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,49.957864304495864]
[null,null,17,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D24+0.75*AnnMiles))+EXP(DelayC1*(D25+0.25*AnnMiles)))/2","v":50.056878867888472},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ24+0.75*AnnMiles))+EXP(DelayC1*(AJ25+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.056878867888472]
[null,null,18,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D25+0.75*AnnMiles))+EXP(DelayC1*(D26+0.25*AnnMiles)))/2","v":50.156089674333103},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ25+0.75*AnnMiles))+EXP(DelayC1*(AJ26+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.156089674333103]
[null,null,19,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D26+0.75*AnnMiles))+EXP(DelayC1*(D27+0.25*AnnMiles)))/2","v":50.255497112775934},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ26+0.75*AnnMiles))+EXP(DelayC1*(AJ27+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.255497112775934]
[null,null,20,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D27+0.75*AnnMiles))+EXP(DelayC1*(D28+0.25*AnnMiles)))/2","v":50.355101572934011},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ27+0.75*AnnMiles))+EXP(DelayC1*(AJ28+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.355101572934011]
[null,null,21,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D28+0.75*AnnMiles))+EXP(DelayC1*(D29+0.25*AnnMiles)))/2","v":50.454903445296786},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ28+0.75*AnnMiles))+EXP(DelayC1*(AJ29+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.454903445296786]
[null,null,22,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D29+0.75*AnnMiles))+EXP(DelayC1*(D30+0.25*AnnMiles)))/2","v":50.554903121127666},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ29+0.75*AnnMiles))+EXP(DelayC1*(AJ30+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.554903121127666]
[null,null,23,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D30+0.75*AnnMiles))+EXP(DelayC1*(D31+0.25*AnnMiles)))/2","v":50.655100992465471},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ30+0.75*AnnMiles))+EXP(DelayC1*(AJ31+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.655100992465471]
[null,null,24,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D31+0.75*AnnMiles))+EXP(DelayC1*(D32+0.25*AnnMiles)))/2","v":50.7554974521261},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ31+0.75*AnnMiles))+EXP(DelayC1*(AJ32+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.7554974521261]
[null,null,25,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D32+0.75*AnnMiles))+EXP(DelayC1*(D33+0.25*AnnMiles)))/2","v":50.856092893703938},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ32+0.75*AnnMiles))+EXP(DelayC1*(AJ33+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.856092893703938]
[null,null,26,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D33+0.75*AnnMiles))+EXP(DelayC1*(D34+0.25*AnnMiles)))/2","v":50.956887711573501},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ33+0.75*AnnMiles))+EXP(DelayC1*(AJ34+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,50.956887711573501]
[null,null,27,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D34+0.75*AnnMiles))+EXP(DelayC1*(D35+0.25*AnnMiles)))/2","v":51.05788230089091},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ34+0.75*AnnMiles))+EXP(DelayC1*(AJ35+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,51.05788230089091]
[null,null,28,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D35+0.75*AnnMiles))+EXP(DelayC1*(D36+0.25*AnnMiles)))/2","v":51.159077057595489},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ35+0.75*AnnMiles))+EXP(DelayC1*(AJ36+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,51.159077057595489]
[null,null,29,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D36+0.75*AnnMiles))+EXP(DelayC1*(D37+0.25*AnnMiles)))/2","v":51.260472378411279},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ36+0.75*AnnMiles))+EXP(DelayC1*(AJ37+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,51.260472378411279]
[null,null,30,{"$f":"D$6*AnnMiles*DelayC2*(EXP(DelayC1*(D37+0.75*AnnMiles))+EXP(DelayC1*(D38+0.25*AnnMiles)))/2","v":51.362068660848649},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ$6*AnnMiles*DelayC2*(EXP(DelayC1*(AJ37+0.75*AnnMiles))+EXP(DelayC1*(AJ38+0.25*AnnMiles)))/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,51.362068660848649]
[]
["Life Cycle Cost Analysis"]
[null,"Mid-Year","Annual Cost",null,null,null,"Discount Factor","Annual Cost Accumulated and Disc.",null,null,null,"Annual-ization","Life Cycle Cost Per Year"]
["Age","LTDMiles","Rehab","Maint","Fuel","Delay",null,"Rehab","Maint","Fuel","Delay",null,"Replace","Rehab","Maint","Fuel","Delay"]
[1,{"$f":"AnnMiles*(A196-0.5)","v":500},{"$f":"AnnMiles*VLOOKUP(B196,RehabArray,3)*(1+InterestRate)^0.5","v":164.46231689119273},{"$f":"AnnMiles*MaintC2*EXP(B196*MaintC1)*(1+InterestRate)^0.5","v":1035.0586214928323},{"$f":"AnnMiles*FuelC2*EXP(B196*FuelC1)*(1+InterestRate)^0.5","v":1034.7317322607157},{"$f":"AnnMiles*DelayC2*EXP(DelayC1*B196)*(1+InterestRate)^0.5","v":50.114839305641333},{"$f":"1/(1+InterestRate)^A196","v":0.93457943925233644},{"$f":"$G196*C196","v":153.70309989831097},{"$f":"$G196*D196","v":967.34450606806763},{"$f":"$G196*E196","v":967.03900211281837},{"$f":"$G196*F196","v":46.836298416487224},{"$f":"InterestRate/(1-(1+InterestRate)^-A196)","v":1.07},{"$f":"NewBusCost*L196","v":424790},{"$f":"H196*$L196","v":164.46231689119276},1035.0586214928323,1034.7317322607157,50.114839305641333]
[{"$f":"1+A196","v":2},1500,164.46231689119273,{"$f":"AnnMiles*MaintC2*EXP(B197*MaintC1)*(1+InterestRate)^0.5","v":1036.3636173306402},{"$f":"AnnMiles*FuelC2*EXP(B197*FuelC1)*(1+InterestRate)^0.5","v":1035.3807124908844},{"$f":"AnnMiles*DelayC2*EXP(DelayC1*B197)*(1+InterestRate)^0.5","v":50.214164987441777},{"$f":"1/(1+InterestRate)^A197","v":0.87343872827321156},{"$f":"+H196+$G197*C197","v":297.35085681262024},1872.5446260179674,1871.380614909468,90.695294824419591,{"$f":"InterestRate/(1-(1+InterestRate)^-A197)","v":0.55309178743961329},219577.43961352648,164.46231689119264,1035.6890542647197,1035.0452492801203,50.16282272680094]
[{"$f":"1+A197","v":3},2500,164.46231689119273,{"$f":"AnnMiles*MaintC2*EXP(B198*MaintC1)*(1+InterestRate)^0.5","v":1037.6702584995446},{"$f":"AnnMiles*FuelC2*EXP(B198*FuelC1)*(1+InterestRate)^0.5","v":1036.0300997592503},{"$f":"AnnMiles*DelayC2*EXP(DelayC1*B198)*(1+InterestRate)^0.5","v":50.313687528918962},{"$f":"1/(1+InterestRate)^A198","v":0.81629787689085187},431.60109691945138,2719.5926549439273,2717.0897857379614,131.76625113282586,{"$f":"InterestRate/(1-(1+InterestRate)^-A198)","v":0.38105166568166948},151277.51127562279,164.46231689119261,1036.3053111420172,1035.3515886621005,50.20974947479246]
[{"$f":"1+A198","v":4},3500,164.46231689119273,{"$f":"AnnMiles*MaintC2*EXP(B199*MaintC1)*(1+InterestRate)^0.5","v":1038.9785470739696},{"$f":"AnnMiles*FuelC2*EXP(B199*FuelC1)*(1+InterestRate)^0.5","v":1036.6798943211065},{"$f":"AnnMiles*DelayC2*EXP(DelayC1*B199)*(1+InterestRate)^0.5","v":50.413407320241184},{"$f":"1/(1+InterestRate)^A199","v":0.7628952120475252},557.06861103798519,3512.2244139267532,3507.9679135414681,170.22639820043952,{"$f":"InterestRate/(1-(1+InterestRate)^-A199)","v":0.29522811666726351},117205.56231690361,164.46231689119273,1036.9073990363786,1035.6507604440376,50.25561894776741]
[{"$f":"1+A199","v":5},4500,164.46231689119273,{"$f":"AnnMiles*MaintC2*EXP(B200*MaintC1)*(1+InterestRate)^0.5","v":1040.2884851309539},{"$f":"AnnMiles*FuelC2*EXP(B200*FuelC1)*(1+InterestRate)^0.5","v":1037.3300964319064},{"$f":"AnnMiles*DelayC2*EXP(DelayC1*B200)*(1+InterestRate)^0.5","v":50.51332475235003},{"$f":"1/(1+InterestRate)^A200","v":0.71298617948366838},674.32797002726909,4253.9357265011249,4247.5699358598786,206.24170062863539,{"$f":"InterestRate/(1-(1+InterestRate)^-A200)","v":0.24389069444137404},96824.605693225487,164.46231689119273,1037.4953384453304,1035.9427813451684,50.30043158908785]
[{"$f":"1+A200","v":6},5500,164.46231689119273,{"$f":"AnnMiles*MaintC2*EXP(B201*MaintC1)*(1+InterestRate)^0.5","v":1041.6000747501555},{"$f":"AnnMiles*FuelC2*EXP(B201*FuelC1)*(1+InterestRate)^0.5","v":1037.9807063472633},{"$f":"AnnMiles*DelayC2*EXP(DelayC1*B201)*(1+InterestRate)^0.5","v":50.613440216961934},{"$f":"1/(1+InterestRate)^A201","v":0.66634222381651254},{"$f":"+H200+$G201*C201","v":783.91615599856243},{"$f":"+I200+$G201*D201","v":4947.997836637589},{"$f":"+J200+$G201*E201","v":4939.220308005948},{"$f":"+K200+$G201*F201","v":239.9675729378099},{"$f":"InterestRate/(1-(1+InterestRate)^-A201)","v":0.20979579975832816},83288.932504056284,{"$f":"H201*$L201","v":164.46231689119273},{"$f":"I201*$L201","v":1038.0691633398606},{"$f":"J201*$L201","v":1036.2276747006838},{"$f":"K201*$L201","v":50.344188880552771}]
[7,6500,164.46231689119273,1042.9133180138547,1038.6317243229507,50.713754106569681,0.62274974188459109,886.33502139229449,5597.4718362387193,5586.0279462412136,271.54955021767478,0.18555321963115931,73664.628193570243,164.4623168911927,1038.6289210088316,1036.5054703746896,50.386893332282732]
[8,7500,164.46231689119273,1044.2282170069568,1039.2831506149025,50.814266814443982,0.5820091045650384,982.05358718082914,6205.2221657804848,6190.900202120125,301.12391614547829,0.16746776249075465,66484.701708829598,164.4623168911927,1039.1746718612924,1036.7762046526182,50.428548469336882]
[9,8500,164.46231689119273,1045.5447738169955,1039.9349854792133,50.914978734634992,0.54393374258414806,1071.5101907215158,6773.9292476420596,6756.5559308160255,328.81829108220063,0.15348647013842193,60934.128644953504,164.4623168911927,1039.7064891879959,1037.0399201137714,50.469158815155119]
[10,9500,164.46231689119273,1046.8629905341365,1040.5872291721384,51.015890261973837,0.5083492921347178,1155.1144930959892,7306.101307842122,7285.5377121701094,354.75218278449745,0.14237750272736471,56523.868582763789,164.46231689119273,1040.2244588836945,1037.2966654848183,50.508729871938371]
[11,10500,164.46231689119273,1048.1828692511813,1041.2398819500938,51.117001792074213,0.47509279638758667,1233.2493551282075,7804.0854383202295,7780.2232793960602,379.03750210884328,0.13335690483624485,52942.691219989203,164.4623168911927,1040.728679131995,1037.5464954751571,50.547268098096971]
[12,11500,164.46231689119273,1049.5044120635696,1041.8929440696563,51.218313721333878,0.44401195924073528,1306.2725906723367,8270.0779485523708,8242.8362068115257,401.7790459332594,0.12590198865502045,49983.089496043118,164.4623168911927,1041.2192600547753,1037.7894705951765,50.584780882914167]
[13,12500,164.46231689119273,1050.8276210693828,1042.5464157875633,51.319826446936268,0.41496444788853759,1374.5186051995602,8706.1340521554521,8675.455904636985,423.07494938054788,0.11965084813625726,47501.386710094135,164.46231689119273,1041.69632332835,1038.0256569585163,50.621276518586662]
[14,13500,164.46231689119273,1052.152498369348,1043.2002973607136,51.421540366851971,0.3878172410173249,1438.2999271876195,9114.176931202539,9080.0269657878707,443.01710929448143,0.1143449386198428,45394.940632077589,164.4623168911927,1042.1600017687415,1038.2551260695316,50.656764169817663]
[15,14500,164.46231689119273,1053.4790460668405,1043.8545890461673,51.523455879840405,0.36244601964235967,1497.9086393259927,9496.0062182260954,9458.3679066730656,461.69158079634832,0.10979462470100652,43588.46600629959,164.4623168911927,1042.6104388885583,1038.477954597214,50.691253841149496]
[16,15500,164.46231689119273,1054.8072662678878,1044.509291101145,51.625573385451254,0.33873459779659787,1553.6177160908276,9853.3059333182773,9812.179341289022,479.17894863308788,0.1058576477262428,42025.486147318392,164.46231689119273,1043.0477884281042,1038.6942241368904,50.724756342232808]
[17,16500,164.46231689119273,1056.1371610811727,1045.164403783029,51.727893284026123,0.31657439046411018,1605.6822738149722,10187.651911334046,10143.05162535142,495.55467491947098,0.1024251930616656,40662.801645481246,164.46231689119273,1043.4722138634361,1038.9040209610603,50.757283251237752]
[18,17500,164.46231689119273,1057.4687326180363,1045.8199273493635,51.830415976700088,0.29586391632159825,1654.3407389777242,10500.518751954054,10452.472004824172,510.88942477491503,9.9412601658362007E-2,39466.802858369716,164.46231689119273,1043.883887894169,1039.1074357607661,50.788846876618329]
[19,18500,164.46231689119273,1058.8019829924817,1046.4758620578539,51.933141865403229,0.27650833301083949,1699.8159400644083,10793.286323259876,10741.83130097787,525.2493712601331,9.6753014849926072E-2,38410.946895420653,164.46231689119276,1044.2829919138667,1039.3045633789127,50.819460217445993]
[20,19500,164.46231689119273,1060.136914321178,1047.1322081663668,52.036071352862251,0.2584190028138687,1742.3161279958888,11067.245847504926,11012.430162026507,538.69648092949103,9.4392925743255696E-2,37473.991520072508,164.46231689119273,1044.6697154658875,1039.4955025369572,50.849136922530604]
[21,20500,164.46231689119273,1061.4735287234623,1047.7889659329312,52.139204842602048,0.24151308674193336,1782.0359298010108,11323.605595921781,11265.484909443108,551.28878123129778,9.2289001664269052E-2,36638.733660714817,164.46231689119273,1045.0442556875516,1039.6803555563929,50.877891248548096]
[22,21500,164.46231689119273,1062.8118283213432,1048.4461356157371,52.242542738947286,0.22571316517937698,1819.1572398992555,11563.496217682272,11502.133005233023,563.08061090992442,9.0405773225133976E-2,35891.091970378191,164.46231689119273,1045.406816745478,1039.8592280764253,50.90573801739253]
[23,22500,164.46231689119273,1064.1518152395063,1049.1037174731375,52.346085447024002,0.21094688334521211,1853.8500530751853,11787.975726513196,11723.438164739857,574.12285449029628,8.871392625222356E-2,35219.428722132754,164.46231689119273,1045.7576092648931,1040.0322287692347,50.932692572968222]
[24,23500,164.46231689119273,1065.4934916053148,1049.7617117636469,52.449833372761141,0.19714661994879637,1886.2732429592318,11998.034166960624,11930.395137965723,584.46316185661374,8.7189020734440459E-2,34614.041231572861,164.4623168911927,1046.0968497556548,1040.199469054161,50.958770737632925]
[25,24500,164.46231689119273,1066.8368595488143,1050.4201187459419,52.553786922892215,0.18424917752223957,1916.575289579836,12194.597980882902,12123.934180897475,594.14615387283561,8.5810517220665627E-2,34066.775336604253,164.46231689119273,1046.4247600376466,1040.3610628121194,50.983988768497213]
[26,25500,164.46231689119273,1068.181921202736,1051.078938678861,52.657946504956868,0.17219549301143888,1944.8949593187183,12378.534093430313,12304.925236937221,603.21361493222662,8.4561027886463649E-2,33570.728070926067,164.46231689119273,1046.7415666681018,1040.5171261014987,51.00836331377856]
[27,26500,164.46231689119273,1069.5286787025004,1051.738171821406,52.762312527302413,0.16093036730041013,1971.3619403830944,12550.653736532229,12474.181847232301,611.70467326686446,8.3425734017789133E-2,33120.016405062284,164.4623168911927,1047.047500373309,1040.6677768767354,51.031911369400042]
[28,27500,164.46231689119273,1070.8771341862198,1052.39781843274,52.866885399085582,0.15040221243028987,1996.0974367049412,12711.716026754844,12632.464807481396,619.65596979518557,8.2391928303198941E-2,32709.59553636998,164.4623168911927,1047.3427954870101,1040.813134710691,51.05465023601414]
[29,28500,164.46231689119273,1072.2272897947023,1053.05787877219,52.971665530273988,0.1405628153554111,2019.2147229870411,12862.431313309289,12780.485587653811,627.1018162361861,8.144865180455016E-2,32335.114766406412,164.46231689119273,1047.627689397671,1040.953320521887,51.076597476622119]
[30,29500,164.46231689119273,1073.5791476714548,1053.7183530992438,53.076653331647769,0.13136711715458982,2040.8196634376018,13003.464310976169,12918.909529993341,634.07434317257821,8.0586403511111196E-2,31992.802193911146,164.46231689119273,1047.902422006659,1041.0884563075833,51.097770874948182]
[31,30500,164.46231689119273,1074.9327099626883,1054.3792416735539,53.181849214801268,0.1227730066865325,2061.0111965689666,13135.437031763991,13048.35883968147,640.60363870182914,7.9796906084245708E-2,31679.371715445548,164.4623168911927,1048.1672351991945,1041.2186648835996,51.118188394715929]
[32,31500,164.46231689119273,1076.2879788173177,1055.0405447549344,53.287253592144538,0.11474112774442291,2079.8817882805229,13258.931528231256,13169.415381602741,646.71787827339483,7.9072915498316271E-2,31391.947452831559,164.46231689119273,1048.4223723297916,1041.3440696317,51.137868139962535]
[33,32500,164.46231689119273,1077.6449563869683,1055.7022626033631,53.392866876905032,0.10723469882656347,2097.5178553006685,13374.492460571379,13282.623295783535,652.44344627242651,7.8408065264177623E-2,31128.001909878516,164.4623168911927,1048.6680777237323,1041.4647942552815,51.156828316513383]
[34,33500,164.46231689119273,1079.0036448259777,1056.3643954789798,53.498689483129226,0.10021934469772288,2114.000160926973,13482.629498782293,13388.491443260444,657.80504987461268,7.7796738113339231E-2,30885.305030995674,164.4623168911927,1048.9045961959482,1041.5809625440158,51.175087194727297]
[35,34500,164.46231689119273,1080.3640462914007,1057.0269436420888,53.604721825684194,9.366293896983445E-2,2129.4041848767902,13583.819570515288,13487.495693372264,662.82582566346673,7.7233959649003259E-2,30661.881980654292,164.4623168911927,1049.1321725885186,1041.6926981480187,51.192663073609459]
[36,35500,386.17277779800338,1081.7261629430104,1057.6899073531565,53.710964320259251,8.7535456981153698E-2,2163.20799545502,13678.508964516976,13580.081062756777,667.52743947013903,7.6715309691276642E-2,30455.977947436826,165.95117129797762,1049.3510513278236,1041.8001243620274,51.20957424637664]
[37,36500,386.17277779800338,1083.0899969433035,1058.3532868728134,53.817417383367633,8.1808838300143641E-2,2194.800341789814,13767.115298941413,13666.66371566698,671.93017986658629,7.6236847967920227E-2,30266.02864326433,167.3246599769694,1049.5614760022252,1041.9033639199954,51.225838967546231]
[38,37500,386.17277779800338,1084.4555504575033,1059.0170824618533,53.924081432348046,7.6456858224433308E-2,2224.3258991120515,13850.029363213442,13747.63283459802,676.05304571554211,7.5795051507199576E-2,30090.635448358233,168.59289609199595,1049.7636889609894,1042.0025388004251,51.241475421608662]
[39,38500,386.17277779800338,1085.8228256535624,1059.6812943812338,54.030956885366379,7.1455007686386268E-2,2251.919877917881,13927.616841566571,13823.35236963315,679.91382815508882,7.538676163185605E-2,29928.544367846851,169.76494705063368,1049.9579309350029,1042.0977700426868,51.256501693330421]
[40,39500,386.17277779800338,1087.1918247021681,1060.3459228920751,54.138044161417277,6.6780381015314264E-2,2277.7086431569737,14000.219925856916,13894.162674371919,683.52918737161212,7.5009138873610326E-2,29778.628132823298,170.84896392818399,1050.1444406796879,1042.1891775744964,51.270935739723271]
[41,40500,386.17277779800338,1088.562549776743,1061.0109682556624,54.24534368032586,6.2411571042349782E-2,2301.8102929131355,14068.158824766349,13960.38203579392,686.91472449243349,7.4659624455712878E-2,29639.870908918012,171.85229203718916,1050.3234546403787,1042.2768800506544,51.284795363704561]
[42,41500,386.17277779800338,1089.9350030534504,1061.6764307334445,54.352855862749273,5.8328571067616623E-2,2324.3351992273051,14131.733176051035,14022.308104934769,690.08504890835184,7.4335907248839705E-2,29511.355177789363,172.7815657849743,1050.4952066402807,1042.3609947030843,51.298098189462252]
[43,42500,386.17277779800338,1091.3091867111978,1062.3423105870336,54.460581130178426,5.4512683240763193E-2,2345.3865135396131,14191.223368063958,14080.219234805061,693.05384131660912,7.4035895309450386E-2,29392.250437851802,173.64279037661564,1050.6599275910091,1042.4416372021371,51.310861639528916]
[44,43500,386.17277779800338,1092.685102931639,1063.0086080782071,54.568519904939599,5.0946432935292711E-2,2365.0606390651346,14246.891776379858,14134.375731566157,695.83391275632437,7.3757691271842979E-2,29281.803434921661,174.44141245535386,1050.8178452255843,1042.5189215290864,51.323102913559495]
[45,44500,386.17277779800338,1094.0627538991791,1063.6753234689047,54.6766726101961,4.761348872457262E-2,2383.4476722665568,14298.983920976612,14185.021024586749,698.43725989114705,7.3499570994822933E-2,29179.329684944703,175.18238140020125,1050.9691838536521,1042.5929598596697,51.334838968798955]
[46,45500,386.17277779800338,1095.4421418009772,1064.3424570212328,54.785039669949924,4.4498587593058525E-2,2400.6318154454561,14347.72954907667,14232.382760639519,700.87511677768953,7.3259964968201946E-2,29084.206092376171,175.87020270108516,1051.1141641385927,1042.6638624584925,51.346086502217986]
[47,46500,386.17277779800338,1096.8232688269497,1065.0100089974601,54.893621509043449,4.1587465040241613E-2,2416.6917623416234,14393.343648424334,14276.673827156208,703.15800334312917,7.3037442068659031E-2,28995.864501257634,176.50898458983181,1051.2530028960937,1042.7317375840621,51.35686193428775]
[48,47500,386.17277779800338,1098.2061371697741,1065.677979660021,55.002418553161029,3.8866789757235155E-2,2431.7010585062658,14436.027395467816,14318.09330914057,705.29577078117438,7.2830695322991981E-2,28913.786043227818,177.10247890866694,1051.385912913682,1042.796691404187,51.367181394358504]
[49,48500,386.17277779800338,1099.5907490248926,1066.3463692715143,55.111431228830774,3.6324102576855283E-2,2445.7284380993897,14475.969042627958,14356.827384040445,707.29764406228776,7.2638529392692067E-2,28837.49616889875,177.65411703742538,1051.5131027906314,1042.8588279214282,51.377060707600343]
[50,49500,386.17277779800338,1100.9771065905152,1067.0151780947028,55.220659963426073,3.3947759417621758E-2,2458.8381386537112,14513.344748566802,14393.050158601356,709.17226174160839,7.2459849539607671E-2,28766.560267224246,178.16704156909691,1051.6347767976056,1042.9182489082805,51.386515383460214]
[51,50500,386.17277779800338,1102.3652120676236,1067.6844063925153,55.330105185167433,3.1726877960394168E-2,2471.0901952465347,14548.319355117856,14426.924451463186,710.92771323635395,7.229365187019697E-2,28700.579792468197,178.64413431501004,1051.7511347553389,1042.9750538517119,51.395560605584194]
[52,51500,386.17277779800338,1103.755067659974,1068.354054428044,55.439767323124023,2.9651287813452491E-2,2482.5407154267436,14581.047114304598,14458.602525017701,712.57157373356279,7.2139014687065045E-2,28639.188830764822,179.08804113140681,1051.8623719316067,1043.0293399066877,51.40421122315054]
[53,52500,386.17277779800338,1105.1466755741021,1069.0241224645479,55.549646807215431,2.7711483937806064E-2,2493.2421361559109,14611.67236865369,14488.226769816505,714.11093687881169,7.1995090802370793E-2,28582.051048541205,179.50119398484173,1051.9686789557147,1043.0812018582785,51.412481743556121]
[54,53500,386.17277779800338,1106.5400380193239,1069.6946107654499,55.659744068213342,2.5898583119444922E-2,2503.2434639401795,14640.330187803327,14515.930344605837,715.55244538696934,7.1861100689255497E-2,28528.856973634433,179.88583061192594,1052.0702417496818,1043.1307320919393,51.420386326395999]
[55,54500,386.17277779800338,1107.9351572077428,1070.3655195943384,55.770059537743172,2.4204283289200861E-2,2512.5904992525798,14667.146964214449,14541.837774865091,716.90231970707646,7.1736326365476569E-2,28479.321567094197,180.24401207717878,1052.1672414752966,1043.1780205715377,51.427938778674061]
[56,55500,386.17277779800338,1109.3320353542497,1071.0368492149669,55.880593648285846,2.262082550392604E-2,2521.3260462735147,14692.240970612113,14566.065512539457,718.16638486505008,7.1620105918556373E-2,28433.182049666881,180.5776384893241,1052.2598544961929,1043.2231548247071,51.435152551181609]
[57,56500,386.17277779800338,1110.7306746765291,1071.7085998912544,55.991346833179442,2.1140958414884149E-2,2529.4901089099026,14715.722881615586,14588.722459482631,719.35009560004369,7.1511828594488416E-2,28390.195952011902,180.88846309981878,1052.3482523540849,1043.2662199350855,51.442040735979177]
[58,57500,386.17277779800338,1112.1310773950611,1072.3807718872863,56.102319526620867,1.9757905060639392E-2,2537.120073990639,14737.696261857744,14609.910456962436,720.45855990293228,7.1410930382795196E-2,28350.139361969694,181.17810497653772,1052.4326017583044,1043.3072985410161,51.448616064917182]
[59,58500,386.17277779800338,1113.5332457331249,1073.0533654673125,56.213512163667616,1.8465331832373259E-2,2544.2508824773086,14758.258022746586,14629.724743429635,721.4965610584976,7.1316890039838501E-2,28312.805345815887,181.44806041939628,1052.5130645877828,1043.3464708402757,51.454890909130498]
[60,59500,386.17277779800338,1114.9371819168034,1073.7263808957487,56.324925180239454,1.7257319469507721E-2,2550.9151894741958,14777.498849883357,14648.254382607591,722.46857828642908,7.122922550001945E-2,28278.002523507723,181.69971326248233,1052.5897979046197,1043.3838146004043,51.460877279442514]
[]
[]
["Fitting Model Coefficients for Use in Prioritization Tool:  Priority Index = C2*Age^2 + C1*Age + C0"]
[null,"C2","C1","C0"]
[null,{"$f":"LINEST(C264:C284,A264:B284)","v":3.0023960731037653E-9},5.1547183667716206E-6,-7.078854418627642E-2]
[]
["Age","Age^2","Priority Index","Fitted Index"]
[]
[{"$f":"+Inputs_Results!A171","v":40},{"$f":"+A264*A264","v":1600},{"$f":"+Inputs_Results!B171","v":-7.0577552032748125E-2},{"$f":"+$D$260+$C$260*A264+$B$260*B264","v":-7.057755161788859E-2}]
[{"$f":"+Inputs_Results!A172","v":41},{"$f":"+A265*A265","v":1681},{"$f":"+Inputs_Results!B172","v":-7.0572153871647197E-2},{"$f":"+$D$260+$C$260*A265+$B$260*B265","v":-7.05721537054399E-2}]
[{"$f":"+Inputs_Results!A173","v":42},1764,{"$f":"+Inputs_Results!B173","v":-7.056674977105043E-2},-7.0566749788199046E-2]
[{"$f":"+Inputs_Results!A174","v":43},1849,{"$f":"+Inputs_Results!B174","v":-7.056133972374877E-2},-7.056133986616607E-2]
[{"$f":"+Inputs_Results!A175","v":44},1936,{"$f":"+Inputs_Results!B175","v":-7.0555923722523631E-2},-7.0555923939340945E-2]
[{"$f":"+Inputs_Results!A176","v":45},2025,{"$f":"+Inputs_Results!B176","v":-7.0550501760147072E-2},-7.0550502007723656E-2]
[{"$f":"+Inputs_Results!A177","v":46},2116,{"$f":"+Inputs_Results!B177","v":-7.0545073829381633E-2},-7.0545074071314245E-2]
[{"$f":"+Inputs_Results!A178","v":47},2209,{"$f":"+Inputs_Results!B178","v":-7.0539639922980388E-2},-7.0539640130112671E-2]
[{"$f":"+Inputs_Results!A179","v":48},2304,{"$f":"+Inputs_Results!B179","v":-7.0534200033686933E-2},-7.0534200184118948E-2]
[{"$f":"+Inputs_Results!A180","v":49},2401,{"$f":"+Inputs_Results!B180","v":-7.0528754154235346E-2},-7.0528754233333088E-2]
[{"$f":"+Inputs_Results!A181","v":50},2500,{"$f":"+Inputs_Results!B181","v":-7.0523302277350181E-2},-7.0523302277755079E-2]
[{"$f":"+Inputs_Results!A182","v":51},2601,{"$f":"+Inputs_Results!B182","v":-7.0517844395746515E-2},-7.051784431738492E-2]
[{"$f":"+Inputs_Results!A183","v":52},2704,{"$f":"+Inputs_Results!B183","v":-7.0512380502129796E-2},-7.0512380352222626E-2]
[{"$f":"+Inputs_Results!A184","v":53},2809,{"$f":"+Inputs_Results!B184","v":-7.0506910589195976E-2},-7.0506910382268181E-2]
[{"$f":"+Inputs_Results!A185","v":54},2916,{"$f":"+Inputs_Results!B185","v":-7.0501434649631448E-2},-7.0501434407521574E-2]
[{"$f":"+Inputs_Results!A186","v":55},3025,{"$f":"+Inputs_Results!B186","v":-7.0495952676112958E-2},-7.0495952427982844E-2]
[{"$f":"+Inputs_Results!A187","v":56},3136,{"$f":"+Inputs_Results!B187","v":-7.049046466130772E-2},-7.0490464443651951E-2]
[{"$f":"+Inputs_Results!A188","v":57},3249,{"$f":"+Inputs_Results!B188","v":-7.0484970597873314E-2},-7.0484970454528922E-2]
[{"$f":"+Inputs_Results!A189","v":58},3364,{"$f":"+Inputs_Results!B189","v":-7.0479470478457679E-2},-7.0479470460613758E-2]
[{"$f":"+Inputs_Results!A190","v":59},3481,{"$f":"+Inputs_Results!B190","v":-7.0473964295699146E-2},-7.0473964461906416E-2]
[{"$f":"+Inputs_Results!A191","v":60},3600,{"$f":"+Inputs_Results!B191","v":-7.046845204222639E-2},-7.0468452458406952E-2]