{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["InCA","Rail Cost","Marine Cost","Not Used","Maps","Routes","Model","Data","Trial Hub","Truck Cost","BNSF"],"not_rendered":{"charts":20,"images":26,"macros":1,"external_links":0,"defined_names":134,"comments":4,"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":"InCA","index":0,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,"Welcome to InCA - the Intermodal Corridor Analyzer",null,null,null,null,null,null,null,"Model: ","Updated April 23, 2009",null,null,null,"Version: ",0.49,null,"Center for Transportion Research"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"miles ="]
[]
[null,null,null,null,null,null,null,null,null,"Miles ="]
[null,null,null,null,null,null,null,null,null,"No. of Containers"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"miles = "]

{"sheet":"Rail Cost","index":1,"n_rows":148,"n_cols":39,"rows_kept":148,"cut":false,"hidden":true,"merged":[[20,21,20,24],[38,5,38,7],[49,26,49,29]]}
[null,"RAIL LINE HAUL COST ANALYSIS",null,null,null,null,null,null,null,null,"Model: Updated June 08, 2009","Version: ",0.8]
[]
[null,null,{"$f":"P16","v":" "}]
[null,"cell legend:","user input","calculation",null,"cost calculation",null,"optional inputs",null,null,"note: Calculation cells have been locked. To edit cells, go to \"Review\" tab, and click \"unprotect sheet\".",null,null,null,null,null,null,null,null,"Default Unit: tons"]
[]
[null,null,null,null,null,"new to rail technology?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.uprr.com/customers/equip-resources/cartypes/intermodal.shtml"]
[]
[null,null,null,null,null,"total cost",null,{"$f":"H25","v":36671.312683463424}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.isocontainers.com/specs.htm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error Messages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Model!D8>VLOOKUP(Model!D5,Data!D4:G9,4),\"Warning! Cargo weight exceeds allowed payload. Max. is \" & VLOOKUP(Model!D5,Data!D5:G9,4) & \" tons\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Model!N6&Model!N7","v":"ALLIANCECHICAGO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P19,BNSF_City_Terminals,1,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"Model!M55","v":"fuel cost"},null,{"$f":"Model!N55","v":5187.7232142853363},null,null,null,null,null,null,null,{"$f":"P17","v":"ALLIANCECHICAGO"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to Model"]
[null,null,null,null,null,"maint. cost",null,{"$f":"Model!N56","v":10670}]
[null,null,null,null,null,{"$f":"Model!M57","v":"crew labor cost"},null,{"$f":"Model!N57","v":720},null,null,null,null,null,null,null,null,null,null,null,null,null,"Rail Companies"]
[null,null,null,null,null,{"$f":"Model!M58","v":"capital & invest. cost"},null,{"$f":"Model!N58","v":93.589469178088507},null,null,null,null,null,null,null,null,null,null,null,null,null,"railroad","Distance","Schedule","Maps"]
[null,null,null,null,null,{"$f":"Model!M59","v":"loading/unloading"},null,{"$f":"Model!N59","v":20000},null,null,null,null,null,null,null,null,null,null,null,null,null,"CTR RailRoad"]
[null,null,null,null,null,{"$f":"Model!M60","v":"other cost"},null,{"$f":"Model!N60","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"BNSF",null,"Go to BNSF Sched","BNSF Map"]
[null,null,null,null,null,"total cost",null,{"$f":"SUM(H19:H24)","v":36671.312683463424},null,null,null,null,null,null,null,null,null,null,null,null,null,"UP",null,"Go to UP Sched","UP Map"]
[null,null,null,null,null,"cents/ton-mile",null,{"$f":"Model!N44","v":6.9453243718680726},null,null,null,null,null,null,null,null,null,null,null,null,null,"KCS"]
[null,null,null,null,null,"per ton",null,{"$f":"H25/Model!I41","v":19.099642022637202},null,null,null,null,null,null,null,null,null,null,null,null,null,"NS"]
[null,null,null,null,null,"per mile",null,{"$f":"Model!N47","v":133.35022793986698}]
[null,null,null,null,null,"per teu",null,{"$f":"Model!N45","v":183.35656341731712},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.all-railroads.com/instock/newmodal.htm"]
[null,null,null,null,null,"per feu",null,{"$f":"Model!N46","v":733.42625366926848},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.uprr.com/aboutup/reference/locorost.shtml"]
[null,null,null,null,null,"% fuel",null,{"$f":"H19/H25","v":0.14146543536808515}]
[null,null,null,null,null,"cost/minute",null,{"$f":"Model!N43/(Model!N37*60)","v":177.80030391981069}]
[null,null,null,null,null,"cost/carload",null,{"$f":"total_cost/Model!D18","v":733.42625366926848}]
[null,null,null,null,null,"cost/ton",null,{"$f":"total_cost/Model!I41","v":19.099642022637202}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.alk.com/pcmiler/rail-screenshots.asp"]
[]
[]
[]
[null,null,null,null,null,"Summary of Train Data Inputs"]
[null,null,null,null,null,"Type of Container",null,{"$f":"Model!D5","v":"40 ft Dry"}]
[null,null,null,null,null,"Cargo Weight",null,{"$f":"Model!D8","v":15}]
[null,null,null,null,null,"Type of Car",null,{"$f":"Model!D11","v":"Container Carriers (5-unit)"}]
[null,null,null,null,null,"No. of Containers",null,{"$f":"Model!D14","v":100}]
[null,null,null,null,null,"Double Stacked",null,{"$f":"Model!D15","v":"Yes"}]
[null,null,null,null,null,"Utilization Ratio",null,{"$f":"Model!D19","v":1}]
[null,null,null,null,null,"HPPT",null,{"$f":"Model!I10","v":4.1233766233760445}]
[null,null,null,null,null,"Locomotive HP",null,{"$f":"Model!I5","v":4000}]
[null,null,null,null,null,"Optional Inputs",null,{"$f":"IF(AND(Model!D41=\"No\",Model!I23=\"No\"),\"No\",\"Yes\")","v":"No"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equations"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"where"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.0183 = gallons of fuel comsumed per hour (n)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"based on"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Work (W) = 2545 Btu. = 1 hp-hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy (E) = 139,000 Btu. in a gallon of diesel fuel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermal efficiency = W/(E*n)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost = n*total HP * price * Trip time"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallons of Fuel Consumed by one locomotive"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Capacity of Locmotives"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3600,"gals"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"locomotive lease"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Model!S54*24","v":0},"$/day"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q = track maintenance cost per car, per locomotive)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
["Note: Calculation cells have been locked. To freely edit cells, \"Unprotect Sheet\" (under \"Review\" tab)."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"http://www.uprr.com/aboutup/maps/grossweight.shtml"]
[null,"http://westernrailroads.com/Engine%20Type/sd70.htm"]
[null,"http://en.wikipedia.org/wiki/EMD_SD70M#SD70M"]
[null,"http://www.emdiesels.com/emdweb/products/sd70m.jsp"]
[null,"http://www.tealinc.com/wellposting.htm"]
[null,"http://wiki.answers.com/Q/How_much_does_a_real_locomotive_cost"]
[null,"http://www.co.dane.wi.us/rail/report/systemop.htm"]
[null,"http://exotic.railfan.net/dieselfaq.htm"]
[null,"http://www.transnow.org/publication/final-reports/documents/TNW94-08vol1.pdf"]
[]
[null,"T.E.","tractive effort"]
[]
[null,"Questions??"]
[null,"1. Are crew wages charged by the hour, by the day or by the mile?"]
[null,"2. Is there a special formula for calculating crew wages eg. <100 mile = $2"]
[null,"3. How do you account for fuel consumption? HP? Diesel engine efficiency?"]
[null,"4. How do you determine the required no. of locomotives? HPTT ratio? Tractive effort?"]
[null,"which equations are involved?"]
[null,"5. What is involved in administrative cost?"]
[null,"6. Is equipment depreciation being accounted for?"]
[null,"7. How do you account for loaded vs. empty ratio?"]
[null,"8. What role does road grade play? Tractive effort or HP?"]

{"sheet":"Marine Cost","index":2,"n_rows":97,"n_cols":57,"rows_kept":97,"cut":false,"hidden":true,"merged":[[6,32,7,32],[62,42,63,42],[62,43,63,43],[62,50,63,50],[6,21,7,21],[6,22,7,22],[6,23,7,23],[6,24,7,24],[6,25,7,25],[6,26,7,26],[59,42,59,50],[60,42,60,50],[61,42,61,43],[61,44,61,50],[66,47,67,47],[66,48,67,48],[66,49,67,49],[66,50,67,50],[64,42,65,42],[64,43,65,43],[64,44,65,44],[64,45,65,45],[64,46,65,46],[64,47,65,47],[64,48,65,48],[64,49,65,49],[64,50,65,50],[66,42,67,42],[66,43,67,43],[66,44,67,44],[66,45,67,45],[66,46,67,46],[70,49,71,49],[70,50,71,50],[72,42,73,42],[72,43,73,43],[72,44,73,44],[72,45,73,45],[72,46,73,46],[72,47,73,47],[72,48,73,48],[70,42,71,42],[70,43,71,43],[70,44,71,44],[70,45,71,45],[70,46,71,46],[70,47,71,47],[72,49,73,49],[72,50,73,50],[70,48,71,48],[68,42,69,42],[68,43,69,43],[68,44,69,44],[68,45,69,45],[68,46,69,46],[68,47,69,47],[68,48,69,48],[68,49,69,49],[68,50,69,50],[76,47,77,47],[76,48,77,48],[76,49,77,49],[76,50,77,50],[74,42,75,42],[74,43,75,43],[74,44,75,44],[74,45,75,45],[74,46,75,46],[74,47,75,47],[74,48,75,48],[74,49,75,49],[74,50,75,50],[76,42,77,42],[76,43,77,43],[76,44,77,44],[76,45,77,45],[76,46,77,46],[78,50,79,50],[80,42,81,42],[80,43,81,43],[80,44,81,44],[80,45,81,45],[80,46,81,46],[80,47,81,47],[80,48,81,48],[78,42,79,42],[78,43,79,43],[78,44,79,44],[78,45,79,45],[78,46,79,46],[78,47,79,47],[1,0,1,16383],[3,0,3,16383],[4,0,4,3],[4,8,4,11],[5,24,5,26],[82,50,83,50],[84,42,85,42],[84,48,85,48],[84,49,85,49],[84,50,85,50],[80,49,81,49],[80,50,81,50],[84,43,85,43],[84,44,85,44],[84,45,85,45],[84,46,85,46],[84,47,85,47],[82,47,83,47],[82,48,83,48],[82,49,83,49],[78,48,79,48],[78,49,79,49],[82,44,83,44],[82,45,83,45],[88,49,89,49],[88,50,89,50],[86,48,87,48],[86,49,87,49],[86,50,87,50],[71,8,71,10],[116,0,117,12],[2,7,2,12],[88,47,89,47],[88,48,89,48],[86,42,87,42],[86,43,87,43],[86,44,87,44],[86,45,87,45],[86,46,87,46],[86,47,87,47],[88,42,89,42],[88,43,89,43],[88,44,89,44],[88,45,89,45],[88,46,89,46],[82,42,83,42],[82,43,83,43],[82,46,83,46]]}
[null,"    SHIPPING LINE HAUL COST ANALYSIS",null,null,"Credit  to: Jim Kruse, TTI",null,null,null,null,"Model: Updated May 05, 2009","Version: ",0.6]
[]
[null,"Cell Legend >>","User Input","Calculation"," Total Cost"]
[]
["Cargo Weight and Ship Data",null,null,null,null,null,null,null,"Basic Trip Details ",null,null,null,null,null,null,null,null,null,null,"Data Table",null,"Container shipping tables"]
[null,null,"Input/Output",null,null,null,null,null,null,null,"Input/Output",null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"Million USD"]
[null,"cargo weight of one (1) container (FEU)",30,"tons",null,null,null,null,null,"port of loading","Long Beach","port",null,null,null,null,null,null,null,"No",null,"TEU Capacity","Service Speed","Fuel Consumption","DNV Newbuild","Alphaliner Newbuild","Average Newbuild",null,null,null,null,"Daily Rep & Maint","Daily Others",null,null,null,null,"Northbound",null,null,null,null,null,null,null,"CONTAINER-RELATED PORT CHARGES",null,null,null,null,null,null,null,null,null,null,"Port Distance Matrix"]
[null,null,null,null,null,null,null,null,null,"port of discharging","Houston-BC","port",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daily","No. of","Daily","Daily","Daily Rep",null,null,"Panama3","Suez Canal","Estimated","Suez",null,null,null,"LOADED",null,null,null,null,null,null,null,null,null,null,null,"Port Charges"]
[null,"tare weight of one (1) container (40 feet)",4,"tons",null,null,null,null,null,"distance (nautical miles)",4454,"nautical miles",null,null,null,null,null,null,null,null,null,null,"(knots)","(tonnes/day)","price","price","price","Manning","Crew","H&M Ins","P&I","price","price","DWT","Canal Chg","Net Tonn.","GRT2","Dues1",null,null,null,null,"Port","Total","% of",null,null,null,null,null,"Clean ","Stevedore",null,"http://www.portofhouston.com/pdf/maritime/2009_Tariff14&15_Rates.pdf"]
[null,null,null,null,null,null,null,null,null,"trip time",{"$f":"(K9/K19)/24","v":10.484934086629002},"days",null,null,null,null,null,null,null,null,null,600,16.399999999999999,18.899999999999999,19,18.8,{"$f":"(Z10+Y10)/2","v":18.899999999999999},3167,16,398,274,870,1300,9000,43468,10000,{"$f":"(0.458636*AH10)+849.572834","v":4977.2968339999998},100891,null,null,null,null,null,"TEUs","TEUs","Wharfage","Security","Throughput","Gate Fee","Infra Fee","Truck","Fee"]
[null,"gross weight of one (1) container (FEU)",{"$f":"C7+C9","v":34},"tons",null,null,null,null,null,"distance (miles)",{"$f":"K9*1.15077945","v":5125.5716702999998},"miles",null,null,null,null,null,null,null,null,null,1000,17.7,31.6,25,21.4,23.2,3167,16,398,274,870,1300,14000,73428,10000,7270.4768339999991,125506,null,null,null,null,"Charleston",1754377,{"$f":"AR11/$AR$27","v":0.2697900119180347},"4.20/ST","$5.75/box",null,"$61/box",null,null,"$0.53/ST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1200,18.399999999999999,39.1,{"$f":"(25+29)/2","v":27},21.4,24.2,3167,16,398,274,870,1300,17000,88130,10571,8646.3848340000004,143854,null,null,null,null,"Hampton Rds",2128366,{"$f":"AR12/$AR$27","v":0.32730244896389987},"$3.89/ST cargo only","$5.75/box"]
[null,"select TEU capacity of ship",600,"TEU",null,null,null,null,"Fuel Consumption",null,null,"$$$",null,null,null,null,null,null,null,null,null,1400,18.899999999999999,46.4,29,27.1,28.05,3167,16,398,274,870,1300,20000,103258,11429,10022.292834,162393,null,null,null,null,"Houston-Bay",null,null,160,"2.60/box","89.78/box",0]
[null,null,null,null,null,null,null,null,null,null,"Input/Output",null,null,null,null,null,null,null,null,null,null,1600,19.399999999999999,53.7,31,33.5,32.25,3167,16,398,274,870,1300,23000,115889,12286,11398.200834000001,175355,null,null,null,null,"Houston-BC",null,null,160,"2.60/box","89.78/box",0,0,0]
[null,"number of containers (FEU)",50,"containers",null,null,null,null,null,"price per ton of fuel",285,"$/ton",null,null,null,null,null,null,null,null,null,2000,20.100000000000001,65.599999999999994,39,42.6,40.799999999999997,3167,16,398,274,870,1300,28000,146886,13714,13691.380834,196959,null,null,null,null,"Long Beach",7316465,{"$f":"AR15/$AR$28","v":0.41104036153073026},160,0,0,0,12,70]
[null,"percent full",1,null,null,null,null,null,null,"service speed",{"$f":"VLOOKUP(C13,V10:X23,2)","v":16.399999999999999},"knots",null,null,null,null,"http://www.apl.com/routes/html/asia_north_america.html",null,null,null,null,2200,20.5,72.7,{"$f":"39+0.4*6","v":41.4},42.6,42,3167,16,398,274,870,1300,31000,159518,14571,15067.288834000001,210048,null,null,null,null,"Los Angeles",8355039,{"$f":"AR16/$AR$28","v":0.46938764159513524},388.5,0,0,0,12,70]
[null,null,{"$f":"IF(C15<=C13,\" \",\"Warning: No. of Containers exceed ship capacity\")","v":" "},null,null,null,null,null,null,"service fuel consumption",{"$f":"VLOOKUP(C13,V10:X23,3)","v":18.899999999999999},"tons/day",null,null,null,null,null,null,null,null,null,2500,20.9,82,45,46,45.5,3167,16,398,274,870,1300,35000,178465,15714,16901.832834000001,227331,null,null,null,null,"NY/NJ (Maher Tariff)",5299105,{"$f":"AR17/$AR$27","v":0.81490215677982392},0,0,"$342.53/box",0,0,0]
[null,"number of full containers (FEU)",{"$f":"C15*C16","v":50},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2800,21.4,91.4,{"$f":"45+0.6*7","v":49.2},46,47.6,3365,17,398,274,870,1300,39000,197412,24000,18736.376833999999,244614,null,null,null,null,"Oakland",2388182,{"$f":"AR18/$AR$28","v":0.13416850797224925},"$332/FEU",0,0,0,0,0]
[null,"number of empty containers (FEU)",{"$f":"C15-C18","v":0},null,null,null,null,null,null,"actual speed",17.7,"knots",null,null,null,null,null,null,null,null,null,3000,21.6,98.3,52,50.2,51.1,3365,17,640,394,870,1300,42000,210044,27000,20112.284833999998,257227,null,null,null,null,"Savannah",2604312,{"$f":"AR19/$AR$27","v":0.40049394486947831},"4.20/ST","$5.75/box","$115/box",0,0,0,"$0.53/ST"]
[null,null,null,null,null,null,null,null,null,"actual fuel consumption",{"$f":"K17*((K19/K16)^3)","v":23.760198202470949},"tons/day",null,null,null,null,null,null,null,null,null,3500,22.3,114.3,58,57.1,57.55,3365,17,640,394,870,1300,49000,241623,34000,23322.736833999999,285378,null,null,null,null,"Seattle",1973504,{"$f":"AR20/$AR$28","v":0.11087182097397341},"$10.98/MT","$325/day/vessel",0,0,0,0]
[null,"loaded container units transported",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4000,23,127.9,65,65.099999999999994,65.05,3365,17,640,394,870,1300,55000,275848,35000,26074.552833999998,309561,null,null,null,null,"Tacoma",1924934,{"$f":"AR21/$AR$28","v":0.1081431493600796},"$89.22/FEU","$325/day/vessel","$58.62/box","$60.35/box",0,0]
[null,"total TEU",{"$f":"C18*2","v":100},"TEU","fuel cost",null,{"$f":"C53","v":71000.371930872396},null,null,"trip time in hrs",{"$f":"K10*24","v":251.63841807909603},"hrs",null,null,null,null,null,null,null,null,null,4800,24,165.4,{"$f":"65+0.4*25","v":75},64.7,69.849999999999994,3365,17,640,394,870,1300,66000,275848,35000,31119.548833999997,353889,null,null,null,null,null,null,null,"per box and per TEU"]
[null,"total FEU",{"$f":"C18","v":50},"FEU","maint. cost",null,11501.829063797952,null,null,"trip time in days",{"$f":"K22/24","v":10.484934086629002},"days",null,null,null,null,null,null,null,null,null,6000,24.6,203.6,90,94.7,92.35,3365,17,995,480,870,1300,82000,275848,41000,38457.724834000001,420328]
[null,null,null,null,{"$f":"B55","v":"crew labor cost"},null,33205.786252354046,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7650,25,250,111,113.4,112.2,3365,17,995,480,870,1300,90000,275848,48000,42126.812833999997,434098]
[null,"gross weight of cargo (full) (payload)",{"$f":"(C18*C11)","v":1700},"tons",{"$f":"B56","v":"capital & invest. cost"},null,59812.285025664089,null,null,"fuel surcharge (optional)",0,"$/mile"]
[null,"gross weight of cargo (empty)",{"$f":"C19*C9","v":0},"tons",{"$f":"B57","v":"insurance"},null,6756.3191703428529,null,null,"total fuel surcharge",{"$f":"K25*K9","v":0},"$$$"]
[null,null,null,null,{"$f":"B58","v":"loading/unloading"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From USACE tables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 Per Online Toll Calculator for Suez Canal Transit",null,null,null,"Total East",null,{"$f":"SUM(AR19:AR22)","v":6502750},{"$f":"SUM(AS19:AS22)","v":0.61950891520353135}]
[null,null,null,null,{"$f":"B59","v":"other cost"},null,51468,null,null,"Total Fuel cost per trip",{"$f":"K15*K20*K10","v":71000.371930872396},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.lethagencies.com/calculator.asp?Port=SUEZTREG",null,null,null,"Total West",null,{"$f":"SUM(AR12:AR16)","v":17799870},{"$f":"SUM(AS12:AS16)","v":1.2077304520897654}]
[null,"total gross weight of cargo",{"$f":"C25+C26","v":1700},"tons","total cost",null,{"$f":"SUM(G22:G28)","v":233744.59144303133},null,null,"ton-miles per gallon",{"$f":"C29*K11/(K23*K20*6.45*40)","v":135.56755461549102},"ton-miles per gal.",null,null,null,null,null,null,null,null,null,null,"Handysize","Handysize",null,null,null,null,null,null,null,null,null,null,null,null,null,"SDR =    on April 23, 2009"]
[null,null,null,null,"cents/ton-mile",null,{"$f":"K93","v":2.6825655232297843},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handymax","Handymax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EMPTY"]
[null,null,null,null,"per mile",null,{"$f":"K96","v":45.603613894906331},null,"Maintenance and repairs",null,null,"$$$",null,null,null,null,null,null,null,null,null,null,"Panamax","Panamax",null,null,null,null,null,null,null,null,null,null,"3 http://boydsteamship.com/transit_container.php",null,null,null,null,null,null,null,"Port","Total","% of",null,null,null,null,null,"Clean "]
[null,null,null,null,"per teu",null,{"$f":"K94","v":2337.4459144303132},null,null,null,"Input/Output","(unit)",null,null,null,null,null,null,null,null,null,null,"Aframax","Aframax",null,null,null,null,null,null,null,null,null,null,"as of 4/24/09",null,null,null,null,null,null,null,null,"TEUs","TEUs","Wharfage","Security","Throughput","Gate Fee","Infra Fee","Truck"]
[null,null,null,null,"per feu",null,{"$f":"K95","v":4674.8918288606264},null,null,"maintenance",{"$f":"VLOOKUP(C13,V10:AG24,10)*350","v":95900},"$/annum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 Formula =",null,null,null,null,null,"LA",null,null,"18.74/FEU",0,0,0,0,0]
[null,"Findings",null,null,"cost/minute",null,{"$f":"K92/(K22*60)","v":15.481512006217837},null,null,"stores/supplies/spares & mgmt/admin.",{"$f":"VLOOKUP(C13,V10:AG24,11)*350","v":304500},"$/annum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y = 0.458636(x) + 849.572834",null,null,null,null,null,"LB",null,null,"19.40/FEU",0,0,0,0,0]
["Ship Data","Cost of shipping is independent of number of containers carried",null,null,null,null,null,null,null,"navigation and comms service",null,"$/annum","Set up table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDR = ","1.4962 USD",null,null,null,null,"Oak",null,null,"$19/FEU",0,0,0,0,0]
[null,"cost/minute is independent of only trip miles except in ships",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seattle",null,null,0,"$325/day/vessel",0,0,0,0]
[null,"cost/minute is highest in rail, ships, car",null,null,null,null,null,null,null,"Total Trip Maintenance Cost",{"$f":"(K33+K34+K35)/365*$K$10","v":11501.829063797952},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tacoma",null,null,"$89.22/FEU","$325/day/vessel","$58.62/box","$60.35/box",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Houston-BC",null,null,"$12.40/box",0,"$35.91/box",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Houston-Bay",null,null,"$12.40/box",0,"$30.50/box","$5.41/box"]
[null,null,null,null,null,null,null,null,"Crew Labor Cost",null,null,"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY/NJ (Maher Tariff)",null,null,0,0,"$342.53/box",0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Input/Output","(unit)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hampton Rds",null,null,0,"$5.75/box",0,0,0,0]
[null,null,null,null,null,null,null,null,null,"daily crew wages ",{"$f":"VLOOKUP(C13,V10:AG24,7)","v":3167},"$/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charleston",null,null,0,"$5.75/box",null,"$61/box",0,0,0]
[null,null,null,null,null,null,null,null,null,"number of onboard crew members",{"$f":"VLOOKUP(C13,V10:AG24,8)","v":16},"number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savannah",null,null,0,"$5.75/box",0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Total Trip Labor Cost",{"$f":"K42*K10","v":33205.786252354046},"$$$"]
[]
[]
[null,null,null,null,null,null,null,null,"Capital and Investment Cost",null,null,"$$$"]
[null,null,null,null,null,null,null,null,null,null,"Input/Output","(unit)"]
[null,null,null,null,null,null,null,null,null,"cost of a ship",{"$f":"VLOOKUP(C13,V10:AG24,6)*1000000","v":18900000},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"16/17","v":0.94117647058823528}]
[null,null,null,null,null,null,null,null,null,"equipment life (years)",25,"years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6500 teu","2500 or less","< 3k teu",null,"3-5k teu","5k teu"]
[null,"Cost Break Down",null,null,null,null,null,null,null,"salvage value (percentage)",0,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,2008]
[null,"fuel cost",{"$f":"K28","v":71000.371930872396},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daily costs",null,"manning",2755,3365,{"$f":"$AV$50*AU53","v":3167.0588235294117}]
[null,"maintenance cost",{"$f":"K37","v":11501.829063797952},"$$$",null,null,null,null,null,"hourly depreciation of ship",{"$f":"(K50-(K52*K50))/(K51*8760)","v":86.301369863013704},"$/hr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h&m",935,995,null,{"$f":"140/350*995","v":398},null,{"$f":"225/350*995","v":639.64285714285722},995]
[null,"crew labor cost",{"$f":"K45","v":33205.786252354046},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p&i",450,480,null,{"$f":"80/140*480","v":274.28571428571428},null,{"$f":"115/140*480","v":394.28571428571428},480]
[null,"capital & invest. cost",{"$f":"K61","v":59812.285025664089},"$$$",null,null,null,null,null,"annual interest rate",0.1,"percent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r&m",745,870,870,870,null,870,870]
[null,"insurance",{"$f":"K69","v":6756.3191703428529},"$$$",null,null,null,null,null,"total interest over 25 years",{"$f":"(PMT(K56,25,K50)*(-1)*25)-K50","v":33154414.109784849},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main Engine for 8200 TEU Container Ship",null,null,null,null,null,null,null,null,null,null,null,null,"others",1180,1300,1300,1300,null,1300,1300]
[null,"loading/unloading",{"$f":"K77","v":0},"$$$",null,null,null,null,null,"hourly interest charge for ship",{"$f":"K57/(8760*K51)","v":151.39001876614086},"$/hr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. power: 68,650 KW/93360 PS",null,null,null,null,null,null,null,null,null,null,null,null,"total",6065,7010]
[null,"other cost",{"$f":"K87","v":51468},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Consumption: 230t/day at 25Kn"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source:",null,null,null,null,null,null,null,null,null,null,"All figures is based on SDR (see below)",null,null,null,null,null,null,null,null,null,"1.48271 on 4/22/09"]
[null,null,null,null,null,null,null,null,null,"Total Trip Depreciation and Interest charges",{"$f":"(K54+K58)*$K$22","v":59812.285025664089},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.naval.ntua.gr/~sdl/Courses/Undergraduate/Presentations/Containership%20NTUA%202005.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DWT","SDR"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suez Canal Suez Canal net tonnage net tonnage ",null,null,null,null,null,null,5000,8]
[null,null," ",null,null,null,null,null,"Insurance",null,null,"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"380 cst bunker fuel is 6.45 bbl per ton",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vessel type","Condition","First","Next","Next","Next","Next","Next","Rest ",5000,5.5,null,{"$f":"AZ62+AZ63","v":10000}]
[null,null,null,null,null,null,null,null,null,null,"Input/Output","(unit)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"There are 40 gal per barrel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5000,5000,10000,20000,30000,50000,null,10000,4.7,null,{"$f":"AZ64+BC63","v":20000}]
[null,null,null,null,null,null,null,null,null,"hull and machinery (H & M)",{"$f":"VLOOKUP(C13,V10:AG24,9)*350","v":139300},"$/annum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tankers of Crude Oil","Laden","7,65","4,80","3,90","1,70","1,50","1,40","1,30",20000,3,null,{"$f":"AZ65+BC64","v":40000}]
[null,null,null,null,null,null,null,null,null,"protection and indemnity (P& I)",{"$f":"VLOOKUP(C13,V10:AG24,10)*350","v":95900},"$/annum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30000,2.9,null,{"$f":"AZ66+BC65","v":70000}]
[null,null,null,null,null,null,null,null,null,"other",null,"$/annum",null,null,null,null,null,null,"Revise so that there is a declining debt balance each period,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ballast","6,50","4,08","3,32","1,45","1,28","1,19","1,11",50000,2.8,null,{"$f":"AZ67+BC66","v":120000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"just as with mortgages.",null,null,null,null,null,null,null,null,null,"Source: ","http://www.tsacarriers.org/fs_bunker.html"]
[null,null,null,null,null,null,null,null,null,"Total Insurance  Cost",{"$f":"(K65+K66+K67)/365*$K$10","v":6756.3191703428529},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A More Transparent Formula",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tankers of Petroleum Products","Laden","7,65","4,80","3,90","2,35","2,30","2,20","2,10"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSA’s new bunker charge calculation formula starts with fewer variables:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ballast","6,50","4,08","3,32","1,45","1,28","1,19","1,11"]
[null,null,null,null,null,null,null,null,"Loading and Unloading Cost (experimental)",null,null,"$$$"]
[null,null,null,null,null,null,null,null,null,"set input to 0 if not in use","Input/Output","(unit)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. We use a publicly accessible web site, http://www.bunkerworld.com/markets/tsaindex/, to track fuel prices.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Bulk Carriers","Laden","7,65","5,20","4,40","1,40","1,30","1,25","1,20"]
[null,null,null,null,null,null,null,null,null,"loading cost per unit container",null,"$$$"]
[null,null,null,null,null,null,null,null,null,"unloading cost per unit container",null,"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. We base the formula on CS 380 (IFO 380) marine bunker fuel only, which accounts for 98% of marine fuel-related costs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ballast","6,50","4,42","3,74","1,19","1,11","1,06","1,02"]
[]
[null,null,null,null,null,null,null,null,null,"Total Loading and Unloading Cost (experimental)",{"$f":"(K74*C22/1.6)+(K75*C22/1.6)","v":0},"$$$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Few Basic Assumptions",null,null,null,null,null,null,null,null,null,null,null,null,null,"LPG Carriers","Laden","7,65","4,90","3,90","2,80","2,60","2,50","2,50"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In order to calculate the cost impacts of fuel price fluctuations on an average transpacific sailing, we assume the following, based on a survey of TSA members:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ballast","6,50","4,17","3,32","2,38","2,21","2,13","2,13"]
[null,null,null,null,null,null,null,null,"Other Cost $$$",null,null,"$$$"]
[null,null,null,null,null,null,null,null,null,null,"Input/Output","(unit)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Vessel Effective Capacity:*",null,null,null,null,null,null,null,null,null,null,null,null,null,"LNG Carriers","Laden","7,65","5,30","4,90","3,40","3,30","3,20","3,10"]
[null,null,null,null,null,null,null,null,null,"Repositioning of Empty Containers ",null,"percent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,744 40’ containers (FEU) to the WC"]
[null,null,null,null,null,null,null,null,null,"Port Charges (Origin)",{"$f":"VLOOKUP(K7,AQ12:AZ22,4)*C15","v":8000},"$ USD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,928 40’ containers (FEU) to the EC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ballast","6,50","4,51","4,17","2,89","2,81","2,72","2,64"]
[null,null,null,null,null,null,null,null,null,"Port Charges (Destination)",{"$f":"VLOOKUP(K8,AQ12:AZ22,4)*C15","v":8000},"$ USD"]
[null,null,null,null,null,null,null,"(Y/N)","Yes","Panama Canal Dues ",{"$f":"IF(I85=\"Yes\",VLOOKUP(C13,V10:AL24,14),0)","v":43468},"$ USD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilization:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Chemical and Other Liquid Bulk","Laden","8,00","5,50","4,70","3,00","2,90","2,80","2,80"]
[null,null,null,null,null,null,null,"(Y/N)","No","Suez Canal Dues",{"$f":"IF(I86=\"Yes\",VLOOKUP(C13,V10:AL24,17),0)","v":0},"$ USD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"88.19% to the WC / 91.56% to the EC"]
[null,null,null,null,null,null,null,null,null,"Total Other Cost",{"$f":"K82*SUM(K28,K37,K45,K69,K77,K61)+K83+K85+K86","v":51468},"$$$",null,null,"A fully laden Panamax ship, the largest that can",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/day",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ballast","6,80","4,68","4,00","2,55","2,47","2,38","2,38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fit through the canal, typically pays a toll of ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Vessel Fuel Consumption:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"about $250,000 for 2,000 FEUs",null,null,null,null,null,null,null,null,null,null,null,null,null,"158.45 tons per day to the WC / 127 tons per day to the EC",null,null,null,null,null,null,null,null,null,null,null,null,null,"Container Ships","Laden","7,65","5,00","4,00","2,80","2,60","2,05","1,95"]
[null,null,null,null,null,null,null,null,"Total Shipping Cost",null,null,"$$$",null,null,"2000 FEUs is approximately 3200 TEUs"]
[null,null,null,null,null,null,null,null,null,null,"Input/Output","(unit)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average One-Way Steaming Time (excluding time in port):"]
[null,null,null,null,null,null,null,null,null,"Total Shipment Cost",{"$f":"SUM(K28,K37,K45,K69,K61,K77,K87)","v":233744.59144303133},"$$$",null,null,"According to Lloyd's List, the Suez dues for a",null,null,null,null,null,null,null,null,null,null,null,null,null,"13.94 days to the WC / 24 days to the EC",null,null,null,null,null,null,null,null,null,{"$f":"AZ62*BA62","v":40000}]
[null,null,null,null,null,null,null,null,null,"per ton-mile (cents)",{"$f":"K92/(C25*K11)*100","v":2.6825655232297843},"cents/ton-mile",null,null,"container ship are running about $600,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27500,{"$f":"AM92+AM93","v":67500}]
[null,null,null,null,null,null,null,null,null,"per TEU",{"$f":"K92/C22","v":2337.4459144303132},"$/TEU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty Reposition Share of Westbound Vessel Deadweight:**",null,null,null,null,null,null,null,null,null,47000,{"$f":"AM93+AM94","v":74500}]
[null,null,null,null,null,null,null,null,null,"per FEU",{"$f":"K92/C23","v":4674.8918288606264},"$/FEU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.714% from WC / 8.84% from EC",null,null,null,null,null,null,null,null,null,60000,{"$f":"AM94+AM95","v":107000}]
[null,null,null,null,null,null,null,null,null,"per mile",{"$f":"K92/K11","v":45.603613894906331},"$/mile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87000,{"$f":"AM95+AM96","v":147000}]
[null,null,null,null,null,null,null,null,null,"per TEU-mile",{"$f":"(K92/(C22*K11))","v":0.45603613894906331},"$/TEU-mile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140000,{"$f":"AM96+AM97","v":227000}]

{"sheet":"Not Used","index":3,"n_rows":132,"n_cols":27,"rows_kept":132,"cut":false,"hidden":true,"merged":[[132,14,132,20],[0,14,0,20],[1,14,1,20],[3,14,3,16],[3,17,3,19],[3,20,4,20],[2,14,2,20]]}
[null,null,null,"Service Level","Equipment","Goal Hrs 0","Goal Hrs 1","Goal Hrs 2","Goal Hrs 3","Goal Hrs 4","Goal Hrs 5","Goal Hrs 6",null,null,"BNSF 6003 Rail Miles Inquiry",null,null,null,null,null,null,null,null,"Union Pacific"]
[null,"Alliance, TX  - Chicago, IL",null,"Expedited","Container",37,37,37,38,38,40,null,null,null,"Search Date - May 14 , 2009 | Effective Date - May 14 , 2009",null,null,null,null,null,null,null,null,"Origin, St","Destination, St","Service Level","Hrs"]
[null,"Alliance, TX - Global Gateway So, CA",null,"Expedited","Trailer",35,35,35,36,36,38,null,null,null,null,null,null,null,null,null,null,null,null,"Dallas (DIT, TX)","Los Angeles (ICTF, CA)","Standard",85]
[null,"Alliance, TX - Kansas City, KS",null,"Premium","Container",58,58,58,58,58,58,null,null,null,"Origin",null,null,"Destination",null,null,"Rail Miles",null,null,"Dallas (DIT, TX)","Northern California (Oakland, CA)","Standard",157]
[null,"Alliance, TX - La Harbor Apm Termi, CA",null,"Premium","Container",null,null,null,96,null,null,null,"Restricted*",null,"City","State","SPLC","City","State","SPLC",null,null,null,"Dallas (Mesquite, TX)","Chicago (Yard Center, IL)","Standard",47]
[null,"Alliance, TX - Long Beach A Pier, CA",null,"Expedited","Trailer",null,28,28,28,31,31,31,null,null,"ALLIANCE","TX",668100,"CHICAGO","IL",380000,963,null,null,"Dallas (Mesquite, TX)","Los Angeles (Los Angeles, CA)","Standard",66]
[null,"Alliance, TX - Long Beach Its, CA",null,"Premium","Container",null,30,30,30,30,30,30,null,null,"ALLIANCE","TX",668100,"CHICAGO","IL",380000,963,null,null,"Dallas (Mesquite, TX)","Los Angeles (Los Angeles, CA)","Expedited",62]
[null,"Alliance, TX - Long Beach J Pier, CA",null,"Premium","Container",null,96,null,null,96,null,null,"Restricted*",null,"ALLIANCE","TX",668100,"CHICAGO","IL",380000,963,null,null,"Dallas (Mesquite, TX)","Los Angeles (Los Angeles, CA)","SuperFlyer",57]
[null,"Alliance, TX - Long Beach Lbc, CA",null,"Premium","Container",null,null,null,null,null,96,null,"Restricted*",null,"ALLIANCE","TX",668100,"GLOBAL GATEWAY SO","CA",883735,1521,null,null,"Dallas (Mesquite, TX)","Memphis (Marion, AR)","Standard",64]
[null,"Alliance, TX - Long Beach Pct, CA",null,"Premium","Container",null,null,null,null,null,96,null,"Restricted*",null,"ALLIANCE","TX",668100,"KANSAS CITY","KS",581520,529,null,null,"Dallas (Mesquite, TX)","Portland (Albina, OR)","Standard",138]
[null,"Alliance, TX - Long Beach T Pier, CA",null,"Premium","Container",null,null,null,null,null,96,null,"Restricted*",null,"ALLIANCE","TX",668100,"KANSAS CITY","KS",581520,529,null,null,"Dallas (Mesquite, TX)","Seattle (Seattle, WA)","Standard",138]
[null,"Alliance, TX - Los Angeles, CA",null,"Premium","Container",null,null,null,null,null,96,null,"Restricted*",null,"ALLIANCE","TX",668100,"LA HARBOR","CA",null,"OD Pair Unavailable",null,null,"Dallas (Mesquite, TX)","St. Louis (Dupo, IL)","Standard",40]
[null,"Alliance, TX - Oakland Int Gateway, CA",null,"Premium","Container",null,null,null,null,null,96,null,"Restricted*",null,"ALLIANCE","TX",668100,"LONG BEACH A PIER","CA",883743,1587,null,null,"El Paso (Alfalfa, TX)","Chicago (Chicanup, IL)","Standard",66]
[null,"Alliance, TX - Phoenix, AZ",null,"Premium","Container",null,null,null,null,null,96,null,"Restricted*",null,"ALLIANCE","TX",668100,"LONG BEACH ITS","CA",883710,1587,null,null,"El Paso (Alfalfa, TX)","Houston (Englewood, TX)","Standard",105]
[null,"Alliance, TX - San Bernardino, CA",null,"Expedited","Trailer",68,68,68,68,68,68,null,null,null,"ALLIANCE","TX",668100,"LONG BEACH J PIER","CA",883715,1588,null,null,"El Paso (Alfalfa, TX)","Los Angeles (ICTF, CA)","Standard",66]
[null,"Alliance, TX - South Seattle, WA",null,"Premium","Container",92,92,92,92,92,92,null,null,null,"ALLIANCE","TX",668100,"LONG BEACH LBC","CA",883733,1587,null,null,"Houston (Barbours Cut, TX)","Los Angeles (ICTF, CA)","Standard",146]
[null,"Alliance, TX - Stockton, CA",null,"Premium","Container",null,null,114,null,null,114,null,"Restricted*",null,"ALLIANCE","TX",668100,"LONG BEACH PCT","CA",883209,1588,null,null,"Houston (Englewood, TX)","Los Angeles (ICTF, CA)","Standard",91]
[null,"Alliance, TX - Tictf, CA",null,"Expedited","Trailer",null,53,53,53,53,53,53,null,null,"ALLIANCE","TX",668100,"LONG BEACH T PIER","CA",883734,1587,null,null,"Houston (Englewood, TX)","Northern California (Oakland, CA)","Standard",139]
[null,"Alliance, TX - West Basin, CA",null,"Premium","Container",83,83,83,83,83,83,null,null,null,"ALLIANCE","TX",668100,"LOS ANGELES","CA",883000,1545,null,null,"Houston (Settegast, TX)","Chicago (Yard Center, IL)","Standard",67]
[null,"Amarillo, TX",null,"Expedited","Container",60,60,60,60,60,60,60,null,null,"ALLIANCE","TX",668100,"LOS ANGELES","CA",883000,1545,null,null,"Houston (Settegast, TX)","Denver (Denver, CO)","Standard",160]
[null,"Atlanta, GA",null,"Expedited","Trailer",57,57,57,57,57,57,57,null,null,"ALLIANCE","TX",668100,"OAKLAND INT GATEWAY","CA",876411,1861,null,null,"Houston (Settegast, TX)","El Paso (Alfalfa, TX)","Standard",63]
[null,"Barbours Cut, TX",null,"Premium","Container",86,86,86,86,86,86,null,null,null,"ALLIANCE","TX",668100,"PHOENIX","AZ",797000,1247,null,null,"Houston (Settegast, TX)","Los Angeles (City Of Industry, CA)","Standard",109]
[null,"Birmingham, AL",null,"Expedited","Trailer",149,145,145,149,145,149,null,null,null,"ALLIANCE","TX",668100,"PHOENIX","AZ",797000,1247,null,null,"Houston (Settegast, TX)","Los Angeles (Los Angeles, CA)","Standard",109]
[null,"Chicago, IL",null,"Expedited","Container",74,74,74,74,74,74,null,null,null,"ALLIANCE","TX",668100,"SAN BERNARDINO","CA",880270,1485,null,null,"Houston (Settegast, TX)","Memphis (Marion, AR)","Standard",65]
[null,"El Paso, TX",null,"Expedited","Trailer",73,73,73,73,73,73,null,null,null,"ALLIANCE","TX",668100,"SAN BERNARDINO","CA",880270,1485,null,null,"Houston (Settegast, TX)","Portland (Albina, OR)","Standard",161]
[null,"Global Gateway So, CA",null,"Premium","Container",108,108,108,108,108,108,null,null,null,"ALLIANCE","TX",668100,"SAN BERNARDINO","CA",880270,1485,null,null,"Houston (Settegast, TX)","Salt Lake City (SLCIT, UT)","Standard",136]
[null,"Houston, TX",null,"Premium","Container",null,null,96,null,null,null,null,"Restricted*",null,"ALLIANCE","TX",668100,"SOUTH SEATTLE","WA",845203,2385,null,null,"Houston (Settegast, TX)","Seattle (Seattle, WA)","Standard",161]
[null,"La Harbor APM Termi, CA",null,"Premium","Container",96,null,null,null,null,null,null,"Restricted*",null,"ALLIANCE","TX",668100,"STOCKTON","CA",875640,1779,null,null,"Houston (Settegast, TX)","St. Louis (Dupo, IL)","Standard",49]
[null,"Long Beach A Pier, CA","Global Gateway So, CA","Premium","Container",163,163,163,163,163,163,null,"Restricted*",null,"ALLIANCE","TX",668100,"STOCKTON","CA",875640,1779,null,null,"Laredo (Port Laredo, TX)","Chicago (Yard Center, IL)","Standard",82]
[null,"Long Beach CUT, CA - Alliance, TX","Oakland Int Gateway, CA","Premium","Container",143,143,143,143,143,143,null,"Restricted*",null,"ALLIANCE","TX",668100,"STOCKTON","CA",875640,1779,null,null,"Laredo (Port Laredo, TX)","Los Angeles (City Of Industry, CA)","Standard",110]
[null,"Long Beach CUT, CA","Tictf, CA","Premium","Container",163,163,163,163,163,163,null,"Restricted*",null,"ALLIANCE","TX",668100,"TICTF","CA",883213,1588,null,null,"Laredo (Port Laredo, TX)","Los Angeles (ICTF, CA)","Standard",86]
[null,"Long Beach ITS, CA - Alliance, TX","Global Gateway So, CA","Premium","Container",165,null,null,null,null,165,null,"Restricted*",null,"ALLIANCE","TX",668100,"WEST BASIN","CA",883252,1588,null,null,"Laredo (Port Laredo, TX)","Los Angeles (Los Angeles, CA)","Standard",110]
[null,"Long Beach ITS, CA","La Harbor Apm Termi, CA","Premium","Container",null,null,165,null,null,165,null,"Restricted*",null,"AMARILLO","TX",672700,"GLOBAL GATEWAY SO","CA",883735,1192,null,null,"Laredo (Port Laredo, TX)","St. Louis (Dupo, IL)","Standard",70]
[null,"Long Beach J Pier, CA - Alliance, TX","Los Angeles, CA","Expedited","Trailer",null,108,108,108,108,108,null,null,null,"AMARILLO","TX",672700,"OAKLAND INT GATEWAY","CA",876411,1532,null,null,"Los Angeles (City Of Industry, CA)","Chicago (Global 1, IL)","Standard",88]
[null,"Long Beach J Pier, CA","Los Angeles, CA","Premium","Container",113,113,113,113,113,113,null,null,null,"AMARILLO","TX",672700,"TICTF","CA",883213,1259,null,null,"Los Angeles (City Of Industry, CA)","Chicago (Global 1, IL)","Expedited",84]
[null,"Long Beach LBC, CA - Alliance, TX","Oakland Int Gateway, CA","Premium","Container",null,null,161,null,null,null,null,"Restricted*",null,"ATLANTA","GA",456200,"GLOBAL GATEWAY SO","CA",883735,2543,null,null,"Los Angeles (City Of Industry, CA)","Chicago (Global 1, IL)","SuperFlyer",82]
[null,"Long Beach LBC, CA","Stockton, CA","Premium","Container",137,137,null,137,null,137,null,null,null,"ATLANTA","GA",456200,"LA HARBOR","CA",null,"OD Pair Unavailable",null,null,"Los Angeles (City Of Industry, CA)","Houston (Settegast, TX)","Standard",82]
[null,"Long Beach PCT, CA - Alliance, TX","La Harbor Apm Termi, CA","Premium","Container",null,null,null,null,113,null,null,"Restricted*",null,"ATLANTA","GA",456200,"LOS ANGELES","CA",883000,2567,null,null,"Los Angeles (City Of Industry, CA)","Laredo (Port Laredo, TX)","Standard",82]
[null,"Long Beach PCT, CA","Los Angeles, CA","Premium","Container",null,null,null,null,117,null,null,"Restricted*",null,"ATLANTA","GA",456200,"LOS ANGELES","CA",883000,2567,null,null,"Los Angeles (ICTF, CA)","Chicago (Global 2, IL)","Standard",104]
[null,"Long Beach T Pier, CA - Alliance, TX","Oakland Int Gateway, CA","Premium","Container",null,null,null,null,141,null,null,"Restricted*",null,"ATLANTA","GA",456200,"OAKLAND INT GATEWAY","CA",876411,2883,null,null,"Los Angeles (ICTF, CA)","Chicago (Global 3, IL)","Standard",104]
[null,"Long Beach T Pier, CA","Global Gateway So, CA","Premium","Container",null,163,null,null,null,163,null,"Restricted*",null,"ATLANTA","GA",456200,"STOCKTON","CA",875640,2801,null,null,"Los Angeles (ICTF, CA)","Dallas (DIT, TX)","Standard",73]
[null,"Los Angeles, CA - Alliance, TX","Long Beach A Pier, CA","Premium","Container",null,163,null,null,null,163,null,"Restricted*",null,"BARBOURS CUT","TX",684815,"LA HARBOR APM","CA",null,"OD Pair Unavailable",null,null,"Los Angeles (ICTF, CA)","Denver (Denver, CO)","Standard",74]
[null,"Los Angeles, CA","Long Beach J Pier, CA","Premium","Container",null,163,null,null,null,163,null,"Restricted*",null,"BARBOURS CUT","TX",684815,"LOS ANGELES","CA",883000,1781,null,null,"Los Angeles (ICTF, CA)","El Paso (Alfalfa, TX)","Standard",61]
[null,"Lubbock, TX","Los Angeles, CA","Premium","Container",null,139,null,139,null,139,null,null,null,"BARBOURS CUT","TX",684815,"OAKLAND INT GATEWAY","CA",876411,2097,null,null,"Los Angeles (ICTF, CA)","Houston (Barbours Cut, TX)","Standard",95]
[null,"Oakland Int Gateway, CA - Alliance, TX","Oakland Int Gateway, CA","Premium","Container",null,163,null,null,null,163,null,"Restricted*",null,"BIRMINGHAM","AL",472600,"GLOBAL GATEWAY SO","CA",883735,2305,null,null,"Los Angeles (ICTF, CA)","Houston (Englewood, TX)","Standard",93]
[null,"Oakland Int Gateway, CA","Stockton, CA","Premium","Container",null,159,null,null,null,159,null,null,null,"BIRMINGHAM","AL",472600,"LONG BEACH A PIER","CA",883743,2371,null,null,"Los Angeles (ICTF, CA)","Laredo (Port Laredo, TX)","Standard",119]
[null,"Phoenix, AZ - Alliance, TX","Tictf, CA","Premium","Container",null,null,null,null,null,163,null,"Restricted*",null,"BIRMINGHAM","AL",472600,"LONG BEACH J PIER","CA",883715,2372,null,null,"Los Angeles (ICTF, CA)","Memphis (Marion, AR)","Standard",106]
[null,"San Bernardino, CA - Alliance, TX","West Basin, CA","Premium","Container",null,163,null,null,null,163,null,"Restricted*",null,"BIRMINGHAM","AL",472600,"LOS ANGELES","CA",883000,2329,null,null,"Los Angeles (ICTF, CA)","New Orleans (Avondale, LA)","Standard",109]
[null,"Stockton, CA - Alliance, TX","Albuquerque, NM","Expedited","Trailer",64,64,64,66,66,66,64,null,null,"BIRMINGHAM","AL",472600,"OAKLAND INT GATEWAY","CA",876411,2645,null,null,"Los Angeles (ICTF, CA)","Northern California (Oakland, CA)","Standard",51]
[null,"Stockton, CA","Alliance, TX","Expedited","Container",40,40,40,40,43,43,43,null,null,"BIRMINGHAM","AL",472600,"STOCKTON","CA",875640,2563,null,null,"Los Angeles (ICTF, CA)","Omaha (Council Bluffs, IA)","Standard",121]
[null,"Tictf, CA - Alliance, TX","Alliance, TX","Expedited","Trailer",36,36,36,36,39,39,36,null,null,"BIRMINGHAM","AL",472600,"TICTF","CA",883213,2372,null,null,"Los Angeles (ICTF, CA)","Salt Lake City (SLCIT, UT)","Standard",50]
[null,"Tictf, CA","Alliance, TX","Premium","Container",44,44,44,44,44,44,47,null,null,"BIRMINGHAM","AL",472600,"WEST BASIN","CA",883252,2372,null,null,"Los Angeles (ICTF, CA)","San Antonio (SAIT, TX)","Standard",73]
[null,"West Basin, CA - Alliance, TX","Denver, CO","Expedited","Container",40,40,40,40,40,40,40,null,null,"CHICAGO","IL",380000,"ALBUQUERQUE","NM",774900,1277,null,null,"Los Angeles (Los Angeles, CA)","Chicago (Global 1, IL)","Standard",104]
[null,"West Basin, CA - Houston, TX","Denver, CO","Expedited","Trailer",32,32,32,32,32,32,32,null,null,"CHICAGO","IL",380000,"ALLIANCE","TX",668100,963,null,null,"Los Angeles (Los Angeles, CA)","Chicago (Global 3, IL)","Standard",106]
[null,null,"Denver, CO","Premium","Container",null,60,null,60,null,null,60,null,null,"CHICAGO","IL",380000,"ALLIANCE","TX",668100,963,null,null,"Los Angeles (Los Angeles, CA)","Dallas (Mesquite, TX)","Standard",80]
[null,null,"Dilworth, MN","Premium","Container",39,39,39,87,63,39,39,"Restricted*",null,"CHICAGO","IL",380000,"ALLIANCE","TX",668100,963,null,null,"Los Angeles (Los Angeles, CA)","Dallas (Mesquite, TX)","Expedited",56]
[null,null,"El Paso, TX","Premium","Container",null,null,null,144,null,144,null,"Restricted*",null,"CHICAGO","IL",380000,"DENVER","CO",744300,1009,null,null,"Los Angeles (Los Angeles, CA)","Dallas (Mesquite, TX)","SuperFlyer",55]
[null,null,"Fresno, CA","Expedited","Trailer",null,null,99,75,68,68,null,null,null,"CHICAGO","IL",380000,"DENVER","CO",744300,1009,null,null,"Los Angeles (Los Angeles, CA)","Denver (Denver, CO)","Standard",56]
[null,null,"Fresno, CA","Premium","Container",null,null,133,133,133,133,null,null,null,"CHICAGO","IL",380000,"DENVER","CO",744300,1009,null,null,"Los Angeles (Los Angeles, CA)","Denver (Denver, CO)","Expedited",55]
[null,null,"Global Gateway So, CA","Premium","Container",158,null,null,null,null,null,null,"Restricted*",null,"CHICAGO","IL",380000,"DILWORTH","MN",503963,672,null,null,"Los Angeles (Los Angeles, CA)","Denver (Denver, CO)","SuperFlyer",54]
[null,null,"Houston, TX","Premium","Container",72,null,72,null,72,null,null,null,null,"CHICAGO","IL",380000,"EL PASO","TX",696900,1367,null,null,"Los Angeles (Los Angeles, CA)","Houston (Settegast, TX)","Standard",103]
[null,null,"Kansas City, KS","Expedited","Trailer",null,null,null,null,null,null,14,null,null,"CHICAGO","IL",380000,"FRESNO","CA",878600,2234,null,null,"Los Angeles (Los Angeles, CA)","Kansas City (Kansas City, MO)","Standard",84]
[null,null,"Kansas City, KS","Expedited","Trailer",20,20,20,20,28,20,null,null,null,"CHICAGO","IL",380000,"FRESNO","CA",878600,2234,null,null,"Los Angeles (Los Angeles, CA)","Laredo (Port Laredo, TX)","Standard",127]
[null,null,"Kansas City, KS","Premium","Container",54,54,54,54,54,54,null,null,null,"CHICAGO","IL",380000,"GLOBAL GATEWAY SO","CA",883735,2096,null,null,"Los Angeles (Los Angeles, CA)","Memphis (Marion, AR)","Standard",106]
[null,null,"La Harbor Apm Termi, CA","Premium","Container",null,null,146,null,146,null,146,"Restricted*",null,"CHICAGO","IL",380000,"HOUSTON","TX",684800,1183,null,null,"Los Angeles (Los Angeles, CA)","Memphis (Marion, AR)","Expedited",80]
[null,null,"Long Beach A Pier, CA","Premium","Container",161,null,161,null,null,161,null,"Restricted*",null,"CHICAGO","IL",380000,"KANSAS CITY","KS",581520,434,null,null,"Los Angeles (Los Angeles, CA)","Memphis (Marion, AR)","SuperFlyer",77]
[null,null,"Long Beach J Pier, CA","Premium","Container",161,null,161,null,161,null,null,"Restricted*",null,"CHICAGO","IL",380000,"KANSAS CITY","KS",581520,434,null,null,"Los Angeles (Los Angeles, CA)","Salt Lake City (SLCIT, UT)","Standard",54]
[null,null,"Chicago, IL","Premium","Container",128,null,128,null,128,null,128,"Restricted*",null,"CHICAGO","IL",380000,"KANSAS CITY","KS",581520,434,null,null,"Los Angeles (Los Angeles, CA)","Salt Lake City (SLCIT, UT)","Expedited",32]
[null,null,"Los Angeles, CA","Premium","Container",null,123,null,null,null,123,null,"Restricted*",null,"CHICAGO","IL",380000,"LA HARBOR APM TERMI","CA",883737,2163,null,null,"Los Angeles (Los Angeles, CA)","Salt Lake City (SLCIT, UT)","SuperFlyer",32]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"CHICAGO","IL",380000,"LONG BEACH A PIER","CA",883743,2162,null,null,"Los Angeles (Los Angeles, CA)","San Antonio (SAIT, TX)","Standard",79]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"CHICAGO","IL",380000,"LONG BEACH J PIER","CA",883715,2163,null,null,"Los Angeles (Los Angeles, CA)","St. Louis (Dupo, IL)","Standard",94]
[null,null,"Chicago, IL","Premium","Container",72,null,72,null,72,null,null,null,null,"EL PASO","TX",696900,"CHICAGO","IL",380000,1367,null,null,"Northern California (Oakland, CA)","Dallas (DIT, TX)","Standard",134]
[null,null,"Global Gateway So, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"EL PASO","TX",696900,"LOS ANGELES","CA",883000,1096,null,null,"Northern California (Oakland, CA)","Houston (Englewood, TX)","Standard",149]
[null,null,"La Harbor Apm Termi, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"GLOBAL GATEWAY SO","CA",883735,"ALLIANCE","TX",668100,1521,null,null,"San Antonio (SAIT, TX)","Chicago (Yard Center, IL)","Standard",80]
[null,null,"Long Beach A Pier, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"GLOBAL GATEWAY SO","CA",883735,"HOUSTON","TX",684800,1734,null,null,"San Antonio (SAIT, TX)","Los Angeles (City Of Industry, CA)","Standard",87]
[null,null,"Long Beach Its, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"HOUSTON","TX",684800,"CHICAGO","IL",380000,1183,null,null,"San Antonio (SAIT, TX)","Los Angeles (ICTF, CA)","Standard",86]
[null,null,"Long Beach J Pier, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"HOUSTON","TX",684800,"GLOBAL GATEWAY SO","CA",883735,1734,null,null,"San Antonio (SAIT, TX)","Los Angeles (Los Angeles, CA)","Standard",87]
[null,null,"Long Beach Pct, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"HOUSTON","TX",684800,"LA HARBOR","CA",null,"OD Pair Unavailable"]
[null,null,"Long Beach T Pier, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"HOUSTON","TX",684800,"LONG BEACH A PIER","CA",883743,1800]
[null,null,"Los Angeles, CA","Premium","Container",null,92,null,92,92,null,null,null,null,"HOUSTON","TX",684800,"LONG BEACH ITS","CA",883710,1800]
[null,null,"Oakland Int Gateway, CA","Premium","Container",140,null,140,null,null,140,null,"Restricted*",null,"HOUSTON","TX",684800,"LONG BEACH J PIER","CA",883715,1801]
[null,null,"Stockton, CA","Premium","Container",136,null,136,null,null,136,null,null,null,"HOUSTON","TX",684800,"LONG BEACH PCT","CA",883209,1801]
[null,null,"Tictf, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"HOUSTON","TX",684800,"LONG BEACH T PIER","CA",883734,1800]
[null,null,"West Basin, CA","Premium","Container",136,null,136,null,null,136,null,"Restricted*",null,"HOUSTON","TX",684800,"LOS ANGELES","CA",883000,1758]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"HOUSTON","TX",684800,"OAKLAND INT GATEWAY","CA",876411,2074]
[null,null,"Barbours Cut, TX","Premium","Container",149,null,null,null,135,null,null,"Restricted*",null,"HOUSTON","TX",684800,"STOCKTON","CA",875640,1992]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"HOUSTON","TX",684800,"TICTF","CA",883213,1801]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"HOUSTON","TX",684800,"WEST BASIN","CA",883252,1801]
[null,null,"Barbours Cut, TX","Premium","Container",149,null,null,null,135,null,null,"Restricted*",null,"LA HARBOR APM TERMI","CA",883737,"ALLIANCE","TX",668100,1588]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"LA HARBOR APM TERMI","CA",883737,"BARBOURS CUT","TX",684815,1824]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"LA HARBOR APM TERMI","CA",883737,"HOUSTON","TX",684800,1801]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"LONG BEACH A PIER","CA",883743,"ALLIANCE","TX",668100,1587]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"LONG BEACH A PIER","CA",883743,"BARBOURS CUT","TX",684815,1823]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"LONG BEACH A PIER","CA",883743,"HOUSTON","TX",684800,1800]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"LONG BEACH CUT","CA",883732,"ALLIANCE","TX",668100,1524]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"LONG BEACH CUT","CA",883732,"HOUSTON","TX",684800,1737]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"LONG BEACH ITS","CA",883710,"ALLIANCE","TX",668100,1587]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"LONG BEACH ITS","CA",883710,"HOUSTON","TX",684800,1800]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"LONG BEACH J PIER","CA",883715,"ALLIANCE","TX",668100,1588]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"LONG BEACH J PIER","CA",883715,"HOUSTON","TX",684800,1801]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"LONG BEACH LBC","CA",883733,"ALLIANCE","TX",668100,1587]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"LONG BEACH LBC","CA",883733,"HOUSTON","TX",684800,1800]
[null,null,"Alliance, TX","Expedited","Trailer",null,null,55,55,55,55,null,null,null,"LONG BEACH PCT","CA",883209,"ALLIANCE","TX",668100,1588]
[null,null,"Alliance, TX","Premium","Container",79,79,79,79,79,79,null,null,null,"LONG BEACH PCT","CA",883209,"HOUSTON","TX",684800,1801]
[null,null,"El Paso, TX","Premium","Container",null,154,null,154,null,154,null,"Restricted*",null,"LONG BEACH T PIER","CA",883734,"ALLIANCE","TX",668100,1587]
[null,null,"Houston, TX","Premium","Container",null,105,null,105,null,105,null,null,null,"LONG BEACH T PIER","CA",883734,"HOUSTON","TX",684800,1800]
[null,null,"Global Gateway So, CA","Premium","Container",164,null,null,null,164,null,null,"Restricted*",null,"LOS ANGELES","CA",883000,"ALLIANCE","TX",668100,1545]
[null,null,"Long Beach A Pier, CA","Premium","Container",164,null,null,null,164,null,null,"Restricted*",null,"LOS ANGELES","CA",883000,"ALLIANCE","TX",668100,1545]
[null,null,"Los Angeles, CA","Premium","Container",140,null,null,null,140,null,null,"Restricted*",null,"LOS ANGELES","CA",883000,"EL PASO","TX",696900,1096]
[null,null,"Oakland Int Gateway, CA","Premium","Container",144,null,null,null,144,null,null,"Restricted*",null,"LOS ANGELES","CA",883000,"HOUSTON","TX",684800,1758]
[null,null,"Tictf, CA","Premium","Container",164,null,null,null,164,null,null,"Restricted*",null,"LUBBOCK","TX",677200,"GLOBAL GATEWAY SO","CA",883735,1189]
[null,null,"West Basin, CA","Premium","Container",164,null,null,null,164,null,null,"Restricted*",null,"LUBBOCK","TX",677200,"LONG BEACH A PIER","CA",883743,1255]
[null,null,"Alliance, TX","Premium","Container",null,109,null,null,null,109,null,"Restricted*",null,"LUBBOCK","TX",677200,"LOS ANGELES","CA",883000,1213]
[null,null,"Barbours Cut, TX","Premium","Container",null,null,null,null,null,159,null,"Restricted*",null,"LUBBOCK","TX",677200,"OAKLAND INT GATEWAY","CA",876411,1529]
[null,null,"Houston, TX","Premium","Container",null,135,null,null,null,135,null,"Restricted*",null,"LUBBOCK","TX",677200,"TICTF","CA",883213,1256]
[null,null,"Alliance, TX","Expedited","Trailer",null,null,null,null,75,null,null,null,null,"LUBBOCK","TX",677200,"WEST BASIN","CA",883252,1256]
[null,null,"Alliance, TX","Premium","Container",null,null,null,null,83,null,null,null,null,"OAKLAND INT GATEWAY","CA",876411,"ALLIANCE","TX",668100,1861]
[null,null,"Alliance, TX","Expedited","Container",59,59,57,57,57,57,null,null,null,"OAKLAND INT GATEWAY","CA",876411,"BARBOURS CUT","TX",684815,2097]
[null,null,"Alliance, TX","Expedited","Trailer",55,55,55,55,55,55,null,null,null,"OAKLAND INT GATEWAY","CA",876411,"HOUSTON","TX",684800,2074]
[null,null,"Alliance, TX","Premium","Container",81,81,81,81,81,81,null,null,null,"PHOENIX","AZ",797000,"ALLIANCE","TX",668100,1247]
[null,null,"Alliance, TX","Expedited","Container",92,92,92,92,92,null,null,null,null,"PHOENIX","AZ",797000,"ALLIANCE","TX",668100,1247]
[null,null,"Alliance, TX","Expedited","Trailer",92,92,92,92,92,null,null,null,null,"SAN BERNARDINO","CA",880270,"ALLIANCE","TX",668100,1485]
[null,null,"Alliance, TX","Premium","Container",108,108,108,108,108,null,null,null,null,"SAN BERNARDINO","CA",880270,"ALLIANCE","TX",668100,1485]
[null,null,"Houston, TX","Premium","Container",null,110,null,110,110,null,null,null,null,"SAN BERNARDINO","CA",880270,"ALLIANCE","TX",668100,1485]
[null,null,"Alliance, TX","Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"STOCKTON","CA",875640,"ALLIANCE","TX",668100,1779]
[null,null,"Houston, TX","Premium","Container",111,111,111,111,111,111,111,"Restricted*",null,"STOCKTON","CA",875640,"ALLIANCE","TX",668100,1779]
[null,null,null,"Premium","Container",109,109,109,109,109,109,109,"Restricted*",null,"STOCKTON","CA",875640,"ALLIANCE","TX",668100,1779]
[null,null,null,"Premium","Container",159,135,111,111,111,111,111,"Restricted*",null,"STOCKTON","CA",875640,"HOUSTON","TX",684800,1992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TICTF","CA",883213,"ALLIANCE","TX",668100,1588]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TICTF","CA",883213,"HOUSTON","TX",684800,1801]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEST BASIN","CA",883252,"ALLIANCE","TX",668100,1588]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEST BASIN","CA",883252,"HOUSTON","TX",684800,1801]

{"sheet":"Maps","index":4,"n_rows":142,"n_cols":21,"rows_kept":142,"cut":false,"hidden":true,"merged":[[123,16,123,17]]}
[]
[]
[null,null,null,null,null,null,null,null,"BNSF Terminals",null,null,null,null,null,null,null,null,null,null,null,"UP Terminals"]
[null,null,null,null,null,null,null,null,"Alliance, TX",null,null,null,null,null,null,null,null,null,null,null,"Barbours Cut, TX"]
[null,null,null,null,null,null,null,null,"Amarillo, TX",null,null,null,null,null,null,null,null,null,null,null,"Dallas (DIT, TX)"]
[null,null,null,null,null,null,null,null,"Atlanta, GA",null,null,null,null,null,null,null,null,null,null,null,"Dallas (Mesquite, TX)"]
[null,null,null,null,null,null,null,null,"Barbours Cut, TX",null,null,null,null,null,null,null,null,null,null,null,"El Paso (Alfalfa, TX)"]
[null,null,null,null,null,null,null,null,"Birmingham, AL",null,null,null,null,null,null,null,null,null,null,null,"Englewood (Houston, TX)"]
[null,null,null,null,null,null,null,null,"Chicago, IL",null,null,null,null,null,null,null,null,null,null,null,"Laredo (Port Laredo, TX)"]
[null,null,null,null,null,null,null,null,"El Paso, TX",null,null,null,null,null,null,null,null,null,null,null,"Long Beach (ICTF, CA)"]
[null,null,null,null,null,null,null,null,"Global Gateway So, CA",null,null,null,null,null,null,null,null,null,null,null,"Los Angeles (City Of Industry, CA) "]
[null,null,null,null,null,null,null,null,"Houston, TX",null,null,null,null,null,null,null,null,null,null,null,"Los Angeles (LA, CA)"]
[null,null,null,null,null,null,null,null,"La Harbor Apm Termi, CA",null,null,null,null,null,null,null,null,null,null,null,"Northern California (Oakland, CA)"]
[null,null,null,null,null,null,null,null,"Long Beach A Pier, CA",null,null,null,null,null,null,null,null,null,null,null,"San Antonio (SAIT, TX)"]
[null,null,null,null,null,null,null,null,"Long Beach CUT, CA",null,null,null,null,null,null,null,null,null,null,null,"Houston (Settegast, TX)"]
[null,null,null,null,null,null,null,null,"Long Beach ITS, CA"]
[null,null,null,null,null,null,null,null,"Long Beach J Pier, CA"]
[null,null,null,null,null,null,null,null,"Long Beach LBC, CA"]
[null,null,null,null,null,null,null,null,"Long Beach PCT, CA"]
[null,null,null,null,null,null,null,null,"Long Beach T Pier, CA"]
[null,null,null,null,null,null,null,null,"Los Angeles, CA"]
[null,null,null,null,null,null,null,null,"Lubbock, TX"]
[null,null,null,null,null,null,null,null,"Oakland Int Gateway, CA"]
[null,null,null,null,null,null,null,null,"Phoenix, AZ"]
[null,null,null,null,null,null,null,null,"San Bernardino, CA"]
[null,null,null,null,null,null,null,null,"Stockton, CA"]
[null,null,null,null,null,null,null,null,"Tictf, CA"]
[null,null,null,null,null,null,null,null,"West Basin, CA"]
[]
[null,"BNSF Origin - Destination Matrix","Distance","Goal Hrs 0","Goal Hrs 1","Goal Hrs 2","Goal Hrs 3","Goal Hrs 4","Goal Hrs 5","Goal Hrs 6","Min Time","Comments","Speeds",null,null,null,"UP  Origin - Destination,","Distance","Hrs","Equipment"]
[null,"Alliance, TX  - Chicago, IL",963,58,58,58,58,58,58,null,58,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.603448275862068},null,null,null,"Barbours Cut (Houston, TX) - El Paso (Alfalfa, TX)"]
[null,"Alliance, TX  - Chicago, IL (Expedited)",963,37,37,37,38,38,40,null,{"$f":"MIN(D32:J32)","v":37},null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":26.027027027027028},null,null,null,"Barbours Cut (Houston, TX) - Englewood (Houston, TX)",null,null,133,181]
[null,"Alliance, TX - Global Gateway So, CA",1521,null,null,null,96,null,null,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.84375},null,null,null,"Barbours Cut (Houston, TX) - Los Angeles (ICTF, CA)"]
[null,"Alliance, TX - Kansas City, KS",529,null,30,30,30,30,30,30,30,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":17.633333333333333},null,null,null,"Barbours Cut (Houston, TX) - Northern California (Oakland, CA)",null,null,88]
[null,"Alliance, TX - La Harbor Apm Termi, CA",null,null,96,null,null,96,null,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":0},null,null,null,"Dallas (DIT, TX) - Los Angeles (ICTF, CA)"]
[null,"Alliance, TX - Long Beach A Pier, CA",1587,null,null,null,null,null,96,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.53125},null,null,null,"Dallas (DIT, TX) - Northern California (Oakland, CA)"]
[null,"Alliance, TX - Long Beach Its, CA",1587,null,null,null,null,null,96,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.53125},null,null,null,"Dallas (Mesquite, TX) - Chicago (Yard Center, IL)"]
[null,"Alliance, TX - Long Beach J Pier, CA",1588,null,null,null,null,null,96,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.541666666666668},null,null,null,"Dallas (Mesquite, TX) - Los Angeles (Los Angeles, CA)",null,66]
[null,"Alliance, TX - Long Beach Lbc, CA",1587,null,null,null,null,null,96,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.53125},null,null,null,"Dallas (Mesquite, TX) - Los Angeles (Los Angeles, CA)  - SuperFlyer",null,57]
[null,"Alliance, TX - Long Beach Pct, CA",1588,null,null,null,null,null,96,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.541666666666668},null,null,null,"Dallas (Mesquite, TX) - Los Angeles (Los Angeles, CA) - Expedited",null,62]
[null,"Alliance, TX - Long Beach T Pier, CA",1587,null,null,null,null,null,96,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.53125},null,null,null,"Dallas (Mesquite, TX) - Memphis (Marion, AR)"]
[null,"Alliance, TX - Los Angeles, CA",1545,92,92,92,92,92,92,null,92,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.793478260869566},null,null,null,"Dallas (Mesquite, TX) - Portland (Albina, OR)"]
[null,"Alliance, TX - Oakland Int Gateway, CA",1861,null,null,114,null,null,114,null,114,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.32456140350877},null,null,null,"Dallas (Mesquite, TX) - Seattle (Seattle, WA)"]
[null,"Alliance, TX - Phoenix, AZ",1247,83,83,83,83,83,83,null,83,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.024096385542169},null,null,null,"Dallas (Mesquite, TX) - St. Louis (Dupo, IL)"]
[null,"Alliance, TX - San Bernardino, CA",1485,86,86,86,86,86,86,null,86,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":17.267441860465116},null,null,null,"El Paso (Alfalfa, TX) - Chicago (Chicanup, IL)"]
[null,"Alliance, TX - San Bernardino, CA (Expedited)",1485,60,60,60,60,60,60,60,60,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":24.75},null,null,null,"El Paso (Alfalfa, TX) - Englewood (Houston, TX)",null,105,163]
[null,"Alliance, TX - Stockton, CA",1779,108,108,108,108,108,108,null,108,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.472222222222221},null,null,null,"El Paso (Alfalfa, TX) - Los Angeles (ICTF, CA)",null,66]
[null,"Alliance, TX - Stockton, CA (Expedited)",1779,74,74,74,74,74,74,null,74,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":24.04054054054054},null,null,null,"El Paso (Alfalfa, TX) - Northern California (Oakland, CA)"]
[null,"Alliance, TX - TICTF, CA",1588,null,null,96,null,null,null,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.541666666666668},null,null,null,"Englewood (Houston, TX) -  Laredo (Port Laredo, TX)"]
[null,"Alliance, TX - West Basin, CA",1588,96,null,null,null,null,null,null,96,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.541666666666668},null,null,null,"Englewood (Houston, TX) - Barbours Cut (Houston, TX)"]
[null,"Amarillo, TX - Global Gateway So, CA",1192,163,163,163,163,163,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":7.3128834355828225},null,null,null,"Englewood (Houston, TX) - Los Angeles (ICTF, CA)"]
[null,"Amarillo, TX - Oakland Int Gateway, CA",1532,143,143,143,143,143,143,null,143,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":10.713286713286713},null,null,null,"Englewood (Houston, TX) - Northern California (Oakland, CA)",null,139,113,89]
[null,"Amarillo, TX - TICTF, CA",1259,163,163,163,163,163,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":7.7239263803680984},null,null,null,"Laredo (Port Laredo, TX) - Chicago (Yard Center, IL)",null,82]
[null,"Atlanta, GA - Global Gateway So, CA",2543,165,null,null,null,null,165,null,165,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.412121212121212},null,null,null,"Laredo (Port Laredo, TX) - Englewood (Houston, TX)",null,null,184]
[null,"Atlanta, GA - La Harbor Apm Termi, CA",null,null,null,165,null,null,165,null,165,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":0},null,null,null,"Laredo (Port Laredo, TX) - Los Angeles (City Of Industry, CA)",null,110]
[null,"Atlanta, GA - La Harbor Apm Termi, CA",null,null,null,null,null,113,null,null,113,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":0},null,null,null,"Laredo (Port Laredo, TX) - Los Angeles (ICTF, CA)",null,86]
[null,"Atlanta, GA - Los Angeles, CA",1781,null,null,null,null,117,null,null,117,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.222222222222221},null,null,null,"Laredo (Port Laredo, TX) - Los Angeles (Los Angeles, CA)",null,110,88]
[null,"Atlanta, GA - Los Angeles, CA",2567,113,113,113,113,113,113,null,113,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":22.716814159292035},null,null,null,"Laredo (Port Laredo, TX) - St. Louis (Dupo, IL)",null,70]
[null,"Atlanta, GA - Oakland Int Gateway, CA",2097,null,null,null,null,141,null,null,141,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.872340425531915},null,null,null,"Long Beach (ICTF, CA) - Barbours Cut (Houston, TX)",null,95,110,140]
[null,"Atlanta, GA - Oakland Int Gateway, CA",2883,null,null,161,null,null,null,null,161,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":17.906832298136646},null,null,null,"Long Beach (ICTF, CA) - Chicago (Global 2, IL)",null,104]
[null,"Atlanta, GA - Stockton, CA",2801,137,137,null,137,null,137,null,137,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":20.445255474452555},null,null,null,"Long Beach (ICTF, CA) - Chicago (Global 3, IL)",null,104,118]
[null,"Birmingham, AL - Global Gateway So, CA",2305,null,163,null,null,null,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.141104294478527},null,null,null,"Long Beach (ICTF, CA) - Dallas (DIT, TX)",null,73]
[null,"Birmingham, AL - Long Beach A Pier, CA",2371,null,163,null,null,null,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.54601226993865},null,null,null,"Long Beach (ICTF, CA) - Denver (Denver, CO)",null,74]
[null,"Birmingham, AL - Long Beach J Pier, CA",2372,null,163,null,null,null,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.552147239263803},null,null,null,"Long Beach (ICTF, CA) - El Paso (Alfalfa, TX)",null,61]
[null,"Birmingham, AL - Los Angeles, CA",2329,null,139,null,139,null,139,null,139,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.755395683453237},null,null,null,"Long Beach (ICTF, CA) - Englewood (Houston, TX)",null,93]
[null,"Birmingham, AL - Oakland Int Gateway, CA",2645,null,163,null,null,null,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.226993865030675},null,null,null,"Long Beach (ICTF, CA) - Laredo (Port Laredo, TX)",null,119]
[null,"Birmingham, AL - Stockton, CA",2563,null,159,null,null,null,159,null,159,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.119496855345911},null,null,null,"Long Beach (ICTF, CA) - Los Angeles (LA, CA) "]
[null,"Birmingham, AL - TICTF, CA",2372,null,null,null,null,null,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.552147239263803},null,null,null,"Long Beach (ICTF, CA) - Memphis (Marion, AR)",null,106]
[null,"Birmingham, AL - West Basin, CA",2372,null,163,null,null,null,163,null,163,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.552147239263803},null,null,null,"Long Beach (ICTF, CA) - New Orleans (Avondale, LA)",null,109]
[null,"Chicago, IL - Alliance, TX",963,44,44,44,44,44,44,47,44,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":21.886363636363637},null,null,null,"Long Beach (ICTF, CA) - Northern California (Oakland, CA)",null,51]
[null,"Chicago, IL - Alliance, TX (Expedited)",963,40,40,40,40,43,43,43,40,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":24.074999999999999},null,null,null,"Long Beach (ICTF, CA) - Omaha (Council Bluffs, IA)",null,121]
[null,"Chicago, IL - Denver, CO",1009,null,60,null,60,null,null,60,60,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.816666666666666},null,null,null,"Long Beach (ICTF, CA) - Salt Lake City (SLCIT, UT)",null,50]
[null,"Chicago, IL - Denver, CO (Expedited)",1009,40,40,40,40,40,40,40,40,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":25.225000000000001},null,null,null,"Long Beach (ICTF, CA) - San Antonio (SAIT, TX)",null,73]
[null,"Chicago, IL - Dilworth, MN",672,39,39,39,87,63,39,39,39,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":17.23076923076923},null,null,null,"Los Angeles (City Of Industry, CA) - Chicago (Global 1, IL)",null,88]
[null,"Chicago, IL - El Paso, TX",1367,null,null,null,144,null,144,null,144,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":9.4930555555555554},null,null,null,"Los Angeles (City Of Industry, CA) - Chicago (Global 1, IL) - Expedited",null,84]
[null,"Chicago, IL - Fresno, CA",2234,null,null,133,133,133,133,null,133,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.796992481203006},null,null,null,"Los Angeles (City Of Industry, CA) - Chicago (Global 1, IL) - SuperFlyer",null,82]
[null,"Chicago, IL - Global Gateway So, CA",2096,158,null,null,null,null,null,null,158,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.265822784810126},null,null,null,"Los Angeles (City Of Industry, CA) - Laredo (Port Laredo, TX)",null,82]
[null,"Chicago, IL - Houston, TX",1183,72,null,72,null,72,null,null,72,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.430555555555557},null,null,null,"Los Angeles (City Of Industry, CA) - Settegast (Houston, TX)",null,82]
[null,"Chicago, IL - Kansas City, KS",434,54,54,54,54,54,54,null,54,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":8.0370370370370363},null,null,null,"Los Angeles (LA, CA) - Chicago (Global 1, IL)",null,104]
[null,"Chicago, IL - La Harbor Apm Termi, CA",2163,null,null,146,null,146,null,146,146,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.815068493150685},null,null,null,"Los Angeles (LA, CA) - Chicago (Global 3, IL)",null,106]
[null,"Chicago, IL - Long Beach A Pier, CA",2162,161,null,161,null,null,161,null,161,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.428571428571429},null,null,null,"Los Angeles (LA, CA) - Dallas (Mesquite, TX)",null,80]
[null,"Chicago, IL - Long Beach J Pier, CA",2163,161,null,161,null,161,null,null,161,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.434782608695652},null,null,null,"Los Angeles (LA, CA) - Dallas (Mesquite, TX) - Expedited",null,56]
[null,"El Paso, TX - Chicago, IL",1367,128,null,128,null,128,null,128,128,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":10.6796875},null,null,null,"Los Angeles (LA, CA) - Dallas (Mesquite, TX) - SuperFlyer",null,55]
[null,"El Paso, TX - Los Angeles, CA",1096,null,123,null,null,null,123,null,123,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":8.9105691056910565},null,null,null,"Los Angeles (LA, CA) - Denver (Denver, CO)",null,56]
[null,"Global Gateway So, CA - Alliance, TX",1521,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.954128440366972},null,null,null,"Los Angeles (LA, CA) - Denver (Denver, CO) - Expedited",null,55]
[null,"Global Gateway So, CA - Houston, TX",1734,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.621621621621621},null,null,null,"Los Angeles (LA, CA) - Denver (Denver, CO) - SuperFlyer",null,54]
[null,"Houston, TX - Chicago, IL",1183,72,null,72,null,72,null,null,72,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.430555555555557},null,null,null,"Los Angeles (LA, CA) - Kansas City (Kansas City, MO)",null,84]
[null,"Houston, TX - Global Gateway So, CA",1734,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":12.75},null,null,null,"Los Angeles (LA, CA) - Laredo (Port Laredo, TX)",null,127]
[null,"Houston, TX - La Harbor Apm Termi, CA",null,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":0},null,null,null,"Los Angeles (LA, CA) - Memphis (Marion, AR)",null,106]
[null,"Houston, TX - Long Beach A Pier, CA",1800,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.235294117647058},null,null,null,"Los Angeles (LA, CA) - Memphis (Marion, AR) - Expedited",null,80]
[null,"Houston, TX - Long Beach Its, CA",1800,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.235294117647058},null,null,null,"Los Angeles (LA, CA) - Memphis (Marion, AR) - SuperFlyer",null,77]
[null,"Houston, TX - Long Beach J Pier, CA",1801,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.242647058823529},null,null,null,"Los Angeles (LA, CA) - Northern California (Oakland, CA)"]
[null,"Houston, TX - Long Beach Pct, CA",1801,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.242647058823529},null,null,null,"Los Angeles (LA, CA) - Salt Lake City (SLCIT, UT)",null,54]
[null,"Houston, TX - Long Beach T Pier, CA",1800,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.235294117647058},null,null,null,"Los Angeles (LA, CA) - Salt Lake City (SLCIT, UT) - Expedited",null,32]
[null,"Houston, TX - Los Angeles, CA",1758,null,92,null,92,92,null,null,92,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":19.108695652173914},null,null,null,"Los Angeles (LA, CA) - Salt Lake City (SLCIT, UT) - SuperFlyer",null,32]
[null,"Houston, TX - Oakland Int Gateway, CA",2074,140,null,140,null,null,140,null,140,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.814285714285715},null,null,null,"Los Angeles (LA, CA) - San Antonio (SAIT, TX)",null,79]
[null,"Houston, TX - Stockton, CA",1992,136,null,136,null,null,136,null,136,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.647058823529411},null,null,null,"Los Angeles (LA, CA) - Settegast (Houston, TX)",null,103]
[null,"Houston, TX - TICTF, CA",1801,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.242647058823529},null,null,null,"Los Angeles (LA, CA) - St. Louis (Dupo, IL)",null,94]
[null,"Houston, TX - West Basin, CA",1801,136,null,136,null,null,136,null,136,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.242647058823529},null,null,null,"Northern California (Oakland, CA) - Dallas (DIT, TX)",null,134]
[null,"La Harbor APM Termi, CA - Alliance, TX",1588,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.568807339449542},null,null,null,"Northern California (Oakland, CA) - El Paso (Alfalfa, TX) "]
[null,"La Harbor APM Termi, CA - Barbours Cut, TX",1824,149,null,null,null,135,null,null,135,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.511111111111111},null,null,null,"Northern California (Oakland, CA) - Englewood (Houston, TX)",null,149]
[null,"La Harbor APM Termi, CA - Houston, TX",1801,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.225225225225227},null,null,null,"San Antonio (SAIT, TX) - Chicago (Yard Center, IL)",null,80]
[null,"Long Beach A Pier, CA - Alliance, TX",1587,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.559633027522937},null,null,null,"San Antonio (SAIT, TX) - Los Angeles (City Of Industry, CA)",null,87]
[null,"Long Beach A Pier, CA - Barbours Cut, TX",1823,149,null,null,null,135,null,null,135,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.503703703703703},null,null,null,"San Antonio (SAIT, TX) - Long Beach (ICTF, CA)",null,86]
[null,"Long Beach A Pier, CA - Houston, TX",1800,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.216216216216218},null,null,null,"San Antonio (SAIT, TX) - Los Angeles (Los Angeles, CA)",null,87]
[null,"Long Beach CUT, CA - Alliance, TX",1524,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.98165137614679},null,null,null,"Settegast (Houston, TX) - Chicago (Yard Center, IL)",null,67]
[null,"Long Beach CUT, CA - Houston, TX",1737,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.648648648648649},null,null,null,"Settegast (Houston, TX) - Denver (Denver, CO)",null,160]
[null,"Long Beach ITS, CA - Alliance, TX",1587,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.559633027522937},null,null,null,"Settegast (Houston, TX) - El Paso (Alfalfa, TX)",null,63]
[null,"Long Beach ITS, CA - Houston, TX",1800,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.216216216216218},null,null,null,"Settegast (Houston, TX) - Los Angeles (City Of Industry, CA)",null,109]
[null,"Long Beach J Pier, CA - Alliance, TX",1588,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.568807339449542},null,null,null,"Settegast (Houston, TX) - Los Angeles (Los Angeles, CA)",null,109]
[null,"Long Beach J Pier, CA - Houston, TX",1801,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.225225225225227},null,null,null,"Settegast (Houston, TX) - Memphis (Marion, AR)",null,65]
[null,"Long Beach LBC, CA - Alliance, TX",1587,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.559633027522937},null,null,null,"Settegast (Houston, TX) - Portland (Albina, OR)",null,161]
[null,"Long Beach LBC, CA - Houston, TX",1800,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.216216216216218},null,null,null,"Settegast (Houston, TX) - Salt Lake City (SLCIT, UT)",null,136]
[null,"Long Beach PCT, CA - Alliance, TX",1588,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.568807339449542},null,null,null,"Settegast (Houston, TX) - Seattle (Seattle, WA)",null,161]
[null,"Long Beach PCT, CA - Houston, TX",1801,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.225225225225227},null,null,null,"Settegast (Houston, TX) - St. Louis (Dupo, IL)",null,49]
[null,"Long Beach T Pier, CA - Alliance, TX",1587,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.559633027522937}]
[null,"Long Beach T Pier, CA - Houston, TX",1800,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.216216216216218}]
[null,"Los Angeles, CA - Alliance, TX",1545,79,79,79,79,79,79,null,79,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":19.556962025316455}]
[null,"Los Angeles, CA - El Paso, TX",1096,null,154,null,154,null,154,null,154,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":7.116883116883117}]
[null,"Los Angeles, CA - Houston, TX",1758,null,105,null,105,null,105,null,105,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.742857142857144}]
[null,"Lubbock, TX - Global Gateway So, CA",1189,164,null,null,null,164,null,null,164,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":7.25}]
[null,"Lubbock, TX - Long Beach A Pier, CA",1255,164,null,null,null,164,null,null,164,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":7.6524390243902438},null,null,null,"UP Notes and Information."]
[null,"Lubbock, TX - Los Angeles, CA",1213,140,null,null,null,140,null,null,140,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":8.6642857142857146}]
[null,"Lubbock, TX - Oakland Int Gateway, CA",1529,144,null,null,null,144,null,null,144,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":10.618055555555555},null,null,null,"1. 90th Percentile Hrs represents the hours from cutoff to availability in which 90% of the units arrived by during the past 60 days. At terminals utilizing the Gate Reservation System, cutoff is based on the associated gate reservation."]
[null,"Lubbock, TX - TICTF CA",1256,164,null,null,null,164,null,null,164,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":7.6585365853658534},null,null,null,"2. Holiday schedules and times may vary."]
[null,"Lubbock, TX - West Basin, CA",1256,164,null,null,null,164,null,null,164,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":7.6585365853658534},null,null,null,"3. Scheduled Available Time also referred to as Van Grounding Time."]
[null,"Oakland Int Gateway, CA - Alliance, TX",1861,null,109,null,null,null,109,null,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":17.073394495412845},null,null,null,"4. View Union Pacific's Highest Elevation Map for Intermodal Customers."]
[null,"Oakland Int Gateway, CA - Barbours Cut, TX",2097,null,null,null,null,null,159,null,159,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":13.188679245283019},null,null,null,"5. Ramp Service Matrix."]
[null,"Oakland Int Gateway, CA - Houston, TX",2074,null,135,null,null,null,135,null,135,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.362962962962962}]
[null,"Phoenix, AZ - Alliance, TX",1247,null,null,null,null,83,null,null,83,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":15.024096385542169}]
[null,"San Bernardino, CA - Alliance, TX",1485,81,81,81,81,81,81,null,81,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":18.333333333333332}]
[null,"San Bernardino, CA - Alliance, TX (Expedited)",1485,59,59,57,57,57,57,null,57,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":26.05263157894737}]
[null,"Stockton, CA - Alliance, TX",1779,108,108,108,108,108,null,null,108,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.472222222222221}]
[null,"Stockton, CA - Alliance, TX (Expedited)",1779,92,92,92,92,92,null,null,92,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":19.336956521739129}]
[null,"Stockton, CA - Houston, TX",1992,null,110,null,110,110,null,null,110,null,{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":18.109090909090909}]
[null,"TICTF, CA - Alliance, TX",1588,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.568807339449542}]
[null,"TICTF, CA - Houston, TX",1801,111,111,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.225225225225227}]
[null,"West Basin, CA - Alliance, TX",1588,109,109,109,109,109,109,109,109,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":14.568807339449542}]
[null,"West Basin, CA - Houston, TX",1801,159,135,111,111,111,111,111,111,"Restricted*",{"$f":"Table7[[#This Row],[Distance]]/Table7[[#This Row],[Min Time]]","v":16.225225225225227}]
[]
[]
[null,"Restricted* = Available to International Contract Holders only"]

{"sheet":"Routes","index":5,"n_rows":82,"n_cols":25,"rows_kept":82,"cut":false,"hidden":true,"merged":[[2,1,2,14],[30,1,30,15],[64,2,64,16]]}
[]
[]
[null,"Union Pacific",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resources"]
[null,null,"Barbours Cut, TX","Dallas (DIT, TX)","Dallas (Mesquite, TX)","El Paso (Alfalfa, TX)","Englewood (Houston, TX)","Laredo (Port Laredo, TX)","Long Beach (ICTF, CA)","Los Angeles (City Of Industry, CA) ","Los Angeles (LA, CA)","Northern California (Oakland, CA)","San Antonio (SAIT, TX)","Houston (Settegast, TX)",null,null,null,"http://www.bnsf.com/markets/intermodal/pdf/small_Intermodal_map_2009.pdf"]
[null,"Barbours Cut, TX",0,290,301,833,26,384,1671,1641,1656,2086,229,24,null,null,null,"http://www.uprr.com/customers/intermodal/intmap/index.shtml"]
[null,"Dallas (DIT, TX)",290,0,15,642,266,442,1466,1450,1466,1896,290,265,null,null,null,"http://c02.my.uprr.com/cdm/intermodal/intermodal_schedule.jas?industryaffiliation=intermodal&cmd"]
[null,"Dallas (Mesquite, TX)",{"$f":"E5","v":301},{"$f":"E6","v":15},0,657,278,453,1496,1465,1481,1911,301,277,null,null,null,"http://www.bnsf.com/markets/intermodal/pdf/Intermodal_map_large_2009.pdf"]
[null,"El Paso (Alfalfa, TX)",{"$f":"$F5","v":833},{"$f":"F6","v":642},{"$f":"F7","v":657},0,812,741,1481,808,824,1254,604,810,null,null,null,"http://www.kcsouthern.com/en-us/KCS/Documents/system_map%5B1%5D.pdf"]
[null,"Englewood (Houston, TX)",{"$f":"G5","v":26},{"$f":"G6","v":266},{"$f":"G7","v":278},{"$f":"G8","v":812},0,352,1651,1620,1636,2066,204,4,null,null,null,"http://www.kcsouthern.com/en-us/Customers/Pages/Intermodal.aspx"]
[null,"Laredo (Port Laredo, TX)",{"$f":"H5","v":384},{"$f":"H6","v":442},{"$f":"H7","v":453},{"$f":"H8","v":741},{"$f":"H9","v":352},0,1568,1549,1565,1995,155,361,null,null,null,"http://www.bnsf.com/tools/glossary.html"]
[null,"Long Beach (ICTF, CA)",1671,1466,1496,1481,1651,1568,0,41,19,490,1442,1649,null,null,null,"http://www.bnsf.com/tools/reference/division_maps/?menu=5&submenu=0"]
[null,"Los Angeles (City Of Industry, CA) ",1641,1450,1465,808,1620,1549,41,0,28,488,1411,1618,null,null,null,"http://www.uprr.com/aboutup/maps/index.shtml"]
[null,"Los Angeles (LA, CA)",1656,1466,1481,824,1636,1565,19,28,0,473,1427,1633,null,null,null,"http://c02.my.uprr.com/mlg/mileagecalculator/mileage_query.jas"]
[null,"Northern California (Oakland, CA)",2086,1896,1911,1254,2066,1995,490,488,473,0,1857,2063,null,null,null,"http://www.bnsf.com/bnsf.was6/siisweb/cntrl"]
[null,"San Antonio (SAIT, TX)",229,290,301,604,204,155,1442,1411,1427,1857,0,206,null,null,null,"http://www.csx.com/?fuseaction=customers.maps"]
[null,"Houston (Settegast, TX)",24,265,277,810,4,361,1649,1618,1633,2063,206,0,null,null,null,"http://www.uprr.com/newsinfo/attachments/2005/sunset.pdf"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glossary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Availability: Arrival times for intermodal and over-the-road freight. Cutoff- to-availability tables reflect transit times of shipments."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cutoff Time: Time a container or trailer must be ingated at the terminal to meet a scheduled train loading for departure. If a unit comes in after the scheduled cutoff, it is scheduled for the train coinciding with a later cut-off time. Cutoff-to-availability tables reflect transit times of shipments."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,0]
[null,"BNSF"]
[]
[null,null,"Alliance, TX ","Amarillo, TX","Barbours Cut, TX","Birmingham, AL","Chicago, IL","El Paso, TX","Global Gateway So, CA","Houston, TX","La Harbor APM Termi, CA","La Harbor APM Termi, CA","Long Beach A Pier, CA","Long Beach ITS, CA ","Long Beach J Pier, CA ","Long Beach LBC, CA ","Long Beach PCT, CA ","Long Beach T Pier, CA ","Los Angeles, CA ","Lubbock, TX","Oakland Int Gateway, CA","San Bernardino, CA ","Stockton, CA ","Tictf, CA ","West Basin, CA "]
[null,"Alliance, TX ","-",null,null,null,963,null,1521,null,1588,1588,1587,1587,1588,1587,1588,1587,1545,null,1861,1485,1779,1588,1588]
[null,"Amarillo, TX",null,"-",null,null,null,null,1192,null,null,null,null,null,null,null,null,null,null,null,1532,null,null,1259]
[null,"Barbours Cut, TX",null,null,"-",null,null,null,null,null,1824,null,null,null,null,null,null,null,null,null,2097]
[null,"Birmingham, AL",null,null,null,"-",null,null,2305,null,null,null,2371,null,2372,null,null,null,2329,null,2645,null,2563,2372,2372]
[null,"Chicago, IL",963,null,null,null,"-",1367,2096,1183,2163,2163,2162,null,2163]
[null,"El Paso, TX",null,null,null,null,1367,"-",null,null,null,null,null,null,null,null,null,null,1096]
[null,"Global Gateway So, CA",1521,1192,null,2305,2096,null,"-",null,null,null,null,null,null,null,null,null,null,1189]
[null,"Houston, TX",null,null,null,null,1183,null,1734,"-",1801,null,null,1801,null,1801,null,1800]
[null,"La Harbor APM Termi, CA",1588,null,null,null,2163,null,null,1801,"-","-"]
[null,"Long Beach A Pier, CA",1587,null,null,2371,2162,null,null,1800,null,null,"-",null,null,null,null,null,null,1255]
[null,"Long Beach ITS, CA ",1587,null,null,null,null,null,null,1800,null,null,null,"-"]
[null,"Long Beach J Pier, CA ",1588,null,null,2372,2163,null,null,1801,null,null,null,null,"-"]
[null,"Long Beach LBC, CA ",1587,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Long Beach PCT, CA ",1588,null,null,null,null,null,null,1801,null,null,null,null,null,null,"-"]
[null,"Long Beach T Pier, CA ",1587,null,null,null,null,null,null,1800,null,null,null,null,null,null,null,"-"]
[null,"Los Angeles, CA ",1545,null,null,2329,null,1096,null,1758,null,null,null,null,null,null,null,null,"-",1213]
[null,"Lubbock, TX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Oakland Int Gateway, CA",1861,1532,null,2645,null,null,null,2074,null,null,null,null,null,null,null,null,null,1529,"-"]
[null,"San Bernardino, CA ",1485,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Stockton, CA ",1779,null,null,2563,null,null,null,1992,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Tictf, CA ",1588,1259,null,2372,null,null,null,1801,null,null,null,null,null,null,null,null,null,1256,null,null,null,"-"]
[null,"West Basin, CA ",1588,null,null,2372,null,null,null,1801,null,null,null,null,null,null,null,null,null,1256,null,null,null,null,"-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"KCS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interchange with NS ","Interchange with NS ","Interchange with NS ","Interchange with NS "]
[null,null,"Lazaro Cardenas","Toluca, EM ","San Luis Potosi, SL ","México City, DF","Monterrey, NL ","Laredo, TX ","Houston, TX ","Dallas, TX ","Jackson, MS ","Corinth, MS ","Kansas City, MO","Atlanta, GA ","Charlotte, NC ","Rutherford, PA","Croxton, NJ"]
[null,"Lazaro Cardenas",0,437,481,535,789,944,1322,1838,1845,2134,2182,2252,2512,3006,3181]
[null,"Toluca, EM ",437,0]
[null,"San Luis Potosi, SL ",481,null,0]
[null,"México City, DF",535,null,null,0]
[null,"Monterrey, NL ",789,null,null,null,0]
[null,"Laredo, TX ",944,null,null,null,null,0,{"$f":"I68-H68","v":378},885,889,1167,1288]
[null,"Houston, TX ",1322,null,null,null,null,378,0,{"$f":"J68-I68","v":516},{"$f":"K68-I68","v":523},{"$f":"L68-H68","v":1190},{"$f":"M68-I68","v":860}]
[null,"Dallas, TX ",1838,null,null,null,null,885,516,0,426,704,747]
[null,"Jackson, MS ",1845,null,null,null,null,889,523,426,0,279,769]
[null,"Corinth, MS ",2134,null,null,null,null,1167,1190,704,279,0,1048]
[null,"Kansas City, MO",2182,null,null,null,null,1288,860,747,769,1048,0]
[null,"Atlanta, GA ",2252,null,null,null,null,null,null,null,null,null,null,0]
[null,"Charlotte, NC ",2512,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Rutherford, PA",3006,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Croxton, NJ",3181,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Model","index":6,"n_rows":77,"n_cols":27,"rows_kept":77,"cut":false,"hidden":false,"merged":[[65,6,65,9],[51,6,51,9],[40,11,40,14],[20,21,20,24],[38,16,38,19],[38,6,38,9],[21,16,21,19],[37,21,37,24],[7,7,7,8],[48,21,48,24],[0,2,0,3],[0,7,0,8],[0,17,0,18],[0,22,0,23],[2,1,2,4],[2,6,2,9],[0,12,0,13],[2,16,2,19],[2,21,2,24],[2,11,2,14]]}
[null,null,"STEP 1",null,null,null,null,{"$f":"IF(OR(ROUND(equation_of_motion,2)<>0,ROUND(equation_maxspeed_upperbound,2)<>0),\"RECALCULATE SPEED NOW\",\"STEP 2\")","v":"STEP 2"},null,null,null,null,{"$f":"IF(OR(ROUND(equation_of_motion,2)<>0,ROUND(equation_maxspeed_upperbound,2)<>0),\"RECALCULATE SPEED NOW\",\"STEP 2\")","v":"STEP 2"},null,null,null,null,"STEP 4",null,null,null,null,"STEP 5"]
[]
[null,"Cargo Weight, Number of Containers, and Rail Car Configuration Module",null,null,null,null,"Configure Locomotives Module",null,null,null,null,"Basic Trip Details Module",null,null,null,null,"Fuel Consumption & Cost Module ($$$)",null,null,null,null,"Maintenance Cost Module ($$$)"]
[null,"required [x]",null,"Input/Output",null,null,"type-1 loco",null,"Input/Output",null,null,"required [x]",null,"Input/Output",null,null,null,null,"Input/Output",null,null,null,null,"Input/Output"]
[null,"x","select type of container (20ft., 40ft., 45ft. HC)","40 ft Dry","type",null,null,"select locomotive horsepower ",4000,"hp",null,"x","select railroad company","BNSF",null,null,"x","price per gallon of fuel (p)",2.5,"$ USD",null,null,"track maintenance",0.5,"$ per car, per loco. mile"]
[null,null,{"$f":"\"tare weight of one \" & D5","v":"tare weight of one 40 ft Dry"},{"$f":"VLOOKUP(D5,Data!D4:E9,2)","v":4.2},"tons",null,null,"average length of a locomotive",{"$f":"VLOOKUP(I5,Data!I19:L26,3)","v":75},"ft.",null,{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"x\")","v":"x"},{"$f":"IF($N$5=\"CTR RailRoad\",\"[inputs disabled]\",\"select origin\")","v":"select origin"},"ALLIANCE",null,null,"x","thermal efficiency of diesel-electric engine (decimal)(η)",0.35,"(25-30%)",null,null,"car maintenance",0.12,"$/mile"]
[null,null,null,null,null,null,null,"number of axles",6,"axles",null,{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"x\")","v":"x"},{"$f":"IF($N$5=\"CTR RailRoad\",\"\",\"select destination\")","v":"select destination"},"CHICAGO",null,null,null,"total horsepower of locomotives ",{"$f":"I13","v":11545.454545452925},"hp",null,null,"locomotive maintenance",2.1,"$/mile"]
[null,"x",{"$f":"IF(input_container_type=Data!D8,\"input cargo weight per car\", \"input cargo weight per container\")","v":"input cargo weight per container"},15,"tons",null,null,{"$f":"IF(input_hptt_ratio>6,\"WARNING!! MAX HPTT = 6.0\", \" \")","v":" "}]
[null,null,{"$f":"IF(input_container_type=Data!D8,\"cargo weight of one car\", \"gross weight of one container\")","v":"gross weight of one container"},{"$f":"D8+D6","v":19.2},"tons",null,null,"input desired maximum train speed",80,"mph",null,null,{"$f":"IF($N$5=\"CTR RailRoad\",\"go to 'user rail inputs', and select 'Yes'\",\"default distance\")","v":"default distance"},{"$f":"IF($N$5=\"CTR Railroad\",\" \",VLOOKUP($N$5,Data!D18:F21,2))","v":963},{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"miles\")","v":"miles"},null,null,"fuel surcharge (optional)",0,"$/mile",null,null,"Total maintenance",{"$f":"(X5*(D23+I28)+(X6*D23)+(X7*I28))*N32","v":10670},"$$$"]
[null,null,null,{"$f":"IF(Model!D16>VLOOKUP(input_car_type,Data!I4:P13,3),\"Max. Allowable Weight  of \" & VLOOKUP(input_car_type,Data!I4:P13,3)& \" tons Exceeded\",\" \")","v":" "},null,null,null,"input desired horsepower per ton ratio",4.1233766233760445,"hptt",null,null,"percentage grade of terrain",0,"%",null,null,"total fuel surcharge",{"$f":"S9*N32","v":0},"$$$",null,null,"track only maintenance cost per gross ton-mile",{"$f":"X9/(I42*N32)","v":1.1411764705882352E-2},"$/ton-mile"]
[null,"x","select type of car","Container Carriers (5-unit)","car type",null,null,"calculated horsepower per ton ratio",4.1233766233760445,"hptt",null,null,"curve of c degrees",0,"degress °"]
[null,null,"tare weight of car",{"$f":"VLOOKUP(D11,data_rail_cars,2)","v":17.600000000000001},"tons",null,null,null,null,null,null,null,{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"estimated cruising speed\")","v":"estimated cruising speed"},{"$f":"cruising_speed","v":79.9999999999946},{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"mph\")","v":"mph"},null,null,"Total Fuel cost per trip",{"$f":"(N37*S5*0.0183*S7/S6 )+S10","v":5187.7232142853363},"$$$"]
[null,null,null,null,null,null,null,"required horsepower",{"$f":"D31*input_hptt_ratio","v":11545.454545452925},"hp",null,null,{"$f":"IF($N$5=\"CTR RailRoad\",\" \",\"number of sidings to be used\")","v":"number of sidings to be used"},0,{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"sidings\")","v":"sidings"},null,null,"ton-miles per gallon (compare with AAR claim)",{"$f":"I41*N32/(S12/S5)","v":254.44688266427571},"ton-miles per gal."]
[null,"x",{"$f":"IF(input_car_type=Data!$I$7,\"input number of containers\",\"number of cars\")","v":"input number of containers"},100,{"$f":"IF(input_car_type=Data!$I$7,\"containers\",\"cars\")","v":"containers"},null,null,null,null,null,null,null,{"$f":"IF($N$5=\"CTR RailRoad\",\" \",\"estimated wait time per siding\")","v":"estimated wait time per siding"},0,{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"mins\")","v":"mins"},null,null,"gallons consumed per hr per locomotive",{"$f":"S18/I28","v":201.22077922075096},"gals/hr/loco."]
[null,{"$f":"IF(input_car_type=Data!$I$7,\"x\",\"  \")","v":"x"},{"$f":"IF(input_car_type=Data!$I$7,\"are containers double stacked?\",\"double-stacking?\")","v":"are containers double stacked?"},"Yes",null,null,null,{"$f":"IF(S7<I13,\"Warning! Total Loco HP is less than req. hp\",\" Good!! Desired Locomotive HP achieved\")","v":" Good!! Desired Locomotive HP achieved"},{"$f":"(I5*I29)+IF(I23=\"Yes\",(I24*I25),0)","v":12000},"hp",null,null,"total siding stop delay",{"$f":"((N14/60)*N13)","v":0},"hrs",null,null,"total gallons consumed per locomotive ",{"$f":"S12/(S5*I28)","v":691.69642857137819},"gals",null,null,null,null,{"$f":"8*45","v":360}]
[null,null,"gross weight of one car",{"$f":"IF(input_double_stacked=\"Yes\",(2*D9+D12),D9+D12)","v":56},"tons",null,null,{"$f":"IF(I23=\"Yes\",IF((I15-I13)>(I25*I24),\"Excess HP!! reduce no. of type-1 loco by ...\", \"if necessary, reduce no. of type-1 loco by ...\"),\" \")","v":" "},null,{"$f":"IF(H16=\" \",\"\",\"locomotive(s)\")","v":""},null,null,{"$f":"IF($N$5=\"CTR RailRoad\",\" \",\"calculated travel time\")","v":"calculated travel time"},{"$f":"IF($N$5=\"USER SPECIFIED\",\" \",(N9/N12)+N15)","v":12.037500000000813},{"$f":"IF($N$5=\"CTR RailRoad\",\"  \",\"hrs\")","v":"hrs"},null,null,"fuel cost per gross ton mile",{"$f":"S12/(I42*N32)","v":5.5483670741019644E-3},"gross ton mile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GTM/gallon of fuel",{"$f":"(gross_weight_of_train*train_trip_miles)/(S15*number_of_locomotives)","v":450.5830213846549},"GTM/gal",null,null,{"$f":"CEILING(train_travel_time/24,1)","v":1}]
[null,null,{"$f":"IF(D15=\"Yes\",\"required no. of double stacked \" & D11,\"required no. of single stacked \" & D11)","v":"required no. of double stacked Container Carriers (5-unit)"},{"$f":"ROUNDUP(IF(D15=\"Yes\",D14/2,D14),0.1)","v":50},{"$f":"IF(input_car_type=Data!I7,\"wells\",\"cars\")","v":"wells"},null,null,null,null,null,null,null,null,null,null,null,null,"total gallons consumed per hr",{"$f":"(S12/S5)/N37","v":603.66233766225287},"gals/hr"]
[null,"x",{"$f":"IF(input_car_type=Data!$I$7,\"utilization ratio (no. of full containers)\",\"utilization ratio (number of full \"  &D11 &\")\")","v":"utilization ratio (no. of full containers)"},1,"percent",null,null,null,null,null,null,"USER SPECIFIED INPUTS",null,{"$f":"IF($N$5=\"CTR RailRoad\",\"[required input]\",\"[optional]\")","v":"[optional]"}]
[null,null,{"$f":"IF(input_car_type=Data!$I$7,\"number of full containers\",\"number of full cars\")","v":"number of full containers"},{"$f":"ROUND(D14*D19,0)","v":100},null,null,null,null,null,null,null,{"$f":"IF($N$5=\"CTR RailRoad\",\"x\",\" \")","v":" "},{"$f":"IF($N$5=\"USER SPECIFIED\",\"select 'Yes' & input USER SPECIFIED data \",\"compare with my inputs?\")","v":"compare with my inputs?"},"Yes","yes/no"]
[null,null,{"$f":"IF(input_car_type=Data!$I$7,\"number of empty containers\",\"number of empty cars\")","v":"number of empty containers"},{"$f":"D14-D20","v":0},null,null,{"$f":"IF(I22=\"Yes\",\"type-2 loco\",\" \")","v":" "},null,null,null,null,{"$f":"IF($N$20=\"Yes\",\"x\",\" \")","v":"x"},{"$f":"IF(N20=\"Yes\",\"input distance\",\"[inputs disabled]\")","v":"input distance"},275,{"$f":"IF($N$20=\"Yes\",\"miles\",\" \")","v":"miles"},null,null,null,null,null,null,"Crew Labor Cost Module ($$$)"]
[null,null,null,null,null,null,{"$f":"IF(I23=\"Yes\",\"type-2 loco\",\" \")","v":" "},null,"[optional inputs]",null,null,null,{"$f":"IF($N$20=\"Yes\",\"percentage grade of terrain\",\" \")","v":"percentage grade of terrain"},0,{"$f":"IF($N$20=\"Yes\",\"%\",\" \")","v":"%"},null,"Rail Emission Module",null,null,null,null,null,null,"Input/Output"]
[null,null,{"$f":"IF(input_car_type=Data!I7,\"total number of wells (intermodal)\",\"total number of cars\")","v":"total number of wells (intermodal)"},{"$f":"D18+D54","v":50},{"$f":"IF(input_car_type=Data!I7,\"wells\",\"cars\")","v":"wells"},null,null,"add additional loco of different hp (type-2)","No",null,null,null,{"$f":"IF($N$20=\"Yes\",\"curve of c degrees\",\" \")","v":"curve of c degrees"},0,{"$f":"IF($N$20=\"Yes\",\"degress °\",\" \")","v":"degress °"},null,null,null,"Input/Output",null,null,null,"average crew wages ",360,"$/day"]
[null,null,null,null,null,null,null,{"$f":"IF(I23=\"Yes\",\"horsepower of one (1) type-2 locomotive\",\"[optional inputs disabled]\")","v":"[optional inputs disabled]"},"horsepower",null,null,{"$f":"IF($N$20=\"Yes\",\"x\",\" \")","v":"x"},{"$f":"IF($N$20=\"Yes\",\"input speed\",\" \")","v":"input speed"},{"$f":"cruising_speed","v":79.9999999999946},{"$f":"IF($N$20=\"Yes\",\"mph\",\" \")","v":"mph"},null,null,"gallons of fuel consumed",{"$f":"S15*number_of_locomotives","v":2075.0892857141343},"gals",null,null,"number of crew members",2,"number"]
[null,null,"total TEU - full",{"$f":"IF($D$41=\"Yes\",($D$20*VLOOKUP(D5,Data!D5:F8,3)+$D$57*VLOOKUP(D42,Data!D5:F8,3)),$D$20*VLOOKUP(D5,Data!D5:F8,3))","v":200},"TEU",null,null,{"$f":"IF(I23=\"Yes\",\"number of type-2 locomotive desired\",\" \")","v":" "},null,null,null,null,{"$f":"IF($N$20=\"Yes\",\"number of sidings to be used\",\" \")","v":"number of sidings to be used"},0,{"$f":"IF($N$20=\"Yes\",\"sidings\",\" \")","v":"sidings"},null,null,"select TIER ","Tier 0"]
[null,null,"total TEU - empty",{"$f":"($D$21*VLOOKUP(D5,Data!D5:F8,3)+$D$58*VLOOKUP(D42,Data!D5:F8,3))","v":0},"TEU",null,null,null,null,null,null,null,{"$f":"IF($N$20=\"Yes\",\"estimated wait time per siding\",\" \")","v":"estimated wait time per siding"},0,{"$f":"IF($N$20=\"Yes\",\"mins\",\" \")","v":"mins"},null,null,null,null,null,null,null,"other crew labor wages ",0,"$/hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$20=\"Yes\",\"total siding stop delay\",\" \")","v":"total siding stop delay"},{"$f":"((N26/60)*N25)","v":0},{"$f":"IF($N$20=\"Yes\",\"hrs\",\" \")","v":"hrs"},null,null,"Pollutants (g/gal)","emission factors",null,null,null,null,0,"number"]
[null,null,"gross weight of full cars/containers",{"$f":"IF($D$41=\"Yes\",(D9*D20)+(D46*D57),(D9*D20))","v":1920},"tons",null,null,"total number of locomotives",{"$f":"IF(I23=\"Yes\",ROUNDUP(I13/I5,0.1)+I25-I16,ROUNDUP(I13/I5,0.1))","v":3},"locomotive(s)",null,null,{"$f":"IF($N$20=\"Yes\",\"calculated time travel time\",\" \")","v":"calculated time travel time"},{"$f":"(N21/N24)+N27","v":3.4375000000002318},{"$f":"IF($N$20=\"Yes\",\"hrs\",\" \")","v":"hrs"},null,null,"HC",{"$f":"(INDEX(data_emission_factor, MATCH($S$25,Data!$R$17:$R$23,), MATCH(R28,Data!$R$17:$W$17,))*$S$24)/(1000*907.18)","v":2.2874063424173089E-2},"tons"]
[null,null,"gross weight of empy cars/containers",{"$f":"(D6*D21)+(D43*D58)","v":0},"tons",null,null,"number of type-1 locomotives",{"$f":"IF(I23=\"Yes\",ROUNDUP(I13/I5,0)-IF(I23=\"Yes\",I16,0.1),ROUNDUP(I13/I5,0.1))","v":3},"locomotive(s)",null,null,null,null,null,null,null,"CO",{"$f":"(INDEX(data_emission_factor, MATCH($S$25,Data!$R$17:$R$23,), MATCH(R29,Data!$R$17:$W$17,))*$S$24)/(1000*907.18)","v":6.0845008708300424E-2},"tons",null,null,"other crew labor wages (per mile calculation)",0,"$/mile"]
[null,null,null,null,null,null,null,{"$f":"IF($I$23=\"Yes\",\"number of type-2 locomotives\",\"\")","v":""},{"$f":"IF(I23=\"Yes\",I25,0)","v":0},{"$f":"IF($I$23=\"Yes\",\"locomotive(s)\",\"\")","v":""},null,null,null,null,null,null,null,"NOx",{"$f":"(INDEX(data_emission_factor, MATCH($S$25,Data!$R$17:$R$23,), MATCH(R30,Data!$R$17:$W$17,))*$S$24)/(1000*907.18)","v":0.40715832895028098},"tons",null,null,null,0,"number"]
[null,null,"total gross weight of all cars and containers",{"$f":"(D54*D49)+(D18*D12)+D28+D29","v":2800},"tons",null,null,null,null,null,null,"trip summary (USE FOR FINAL CHECK)",null,null,null,null,null,"PM",{"$f":"(INDEX(data_emission_factor, MATCH($S$25,Data!$R$17:$R$23,), MATCH(R31,Data!$R$17:$W$17,))*$S$24)/(1000*907.18)","v":1.5325622494195971E-2},"tons"]
[null,null,null,null,null,null,null,{"$f":"IF(I23=\"Yes\",\"weight of type-1 locomotive\",\"weight of single type-1 locomotive\")","v":"weight of single type-1 locomotive"},{"$f":"VLOOKUP(I5,Data!I19:L26,2)","v":200},"tons",null,null,"distance used in calculations",{"$f":"IF($N$20=\"Yes\",N21,N9)","v":275},"miles",null,null,"VOC",{"$f":"(INDEX(data_emission_factor, MATCH($S$25,Data!$R$17:$R$23,), MATCH(R32,Data!$R$17:$W$17,))*$S$24)/(1000*907.18)","v":2.4086388785654261E-2},"tons",null,null,"Total Labor Cost",{"$f":"(X24*X23*CEILING(train_travel_time/24,1))+(X26*X27*CEILING(train_travel_time/24,1))+(X29*X30*train_trip_miles)","v":720},"$$$"]
[null,null,"length of car",{"$f":"VLOOKUP(input_car_type,data_rail_cars,4)","v":53},"ft",null,null,{"$f":"IF($I$23=\"Yes\",\"weight of type-2 locomotive\",\"\")","v":""},{"$f":"IF(I23=\"Yes\",VLOOKUP(I24,Data!I19:L26,2),0)","v":0},{"$f":"IF($I$23=\"Yes\",\"tons\",\"\")","v":""},null,null,"percentage grade of terrain",{"$f":"IF($N$20=\"Yes\",N22,N10)","v":0},"%",null,null,null,{"$f":"SUM(S28:S32)","v":0.53028941236260474},null,null,null,"labor cost per crew member per day",{"$f":"X23*X24","v":720},"$/day"]
[null,null,"number of axles",{"$f":"VLOOKUP(input_car_type,data_rail_cars,6)","v":4},"axles",null,null,null,null,null,null,null,"curve of c degrees",{"$f":"IF($N$20=\"Yes\",N23,N11)","v":0},"degress °"]
[null,null,"k-value",{"$f":"VLOOKUP(input_car_type,data_rail_cars,7)","v":9.35E-2},null,null,null,"weight of all locomotives",{"$f":"(I29*I32)+(I30*I33)","v":600},"tons",null,null,"trip speed",{"$f":"IF($N$20=\"Yes\",N24,N12)","v":79.9999999999946},"mph"]
[null,null,"k-adj-value",{"$f":"VLOOKUP(input_car_type,data_rail_cars,8)","v":0.95},null,null,null,null,null,null,null,null,"total siding stop delay",{"$f":"IF($N$20=\"Yes\",N27,N15)","v":0},"hrs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"trip time used in calculations",{"$f":"IF(N20=\"Yes\",N28,N16)","v":3.4375000000002318},"hrs"]
[null,{"$f":"IF($D$41=\"Yes\",\"x\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading and Unloading Cost Module ($$$) (experimental)"]
[null,null,null,null,null,null,"Train Data Summary",null,null,null,null,null,null,null,null,null,"Capital Cost Module ($$$)",null,null,"$$$",null,null,"set input to 0 if not in use","Input/Output"]
[null,null,null,"[optional inputs]",null,null,null,null,"Input/Output",null,null,null,null,null,null,null,null,null,"Input/Output",null,null,null,"loading cost per unit container",100]
[null,null,"happen to have other containers or rail cars?","No",null,null,null,"weight of cargo",{"$f":"SUM(D28:D29)","v":1920},"tons",null,"Total Rail Cost ($$$)",null,null,null,null,null,"cost of one (1) car",{"$f":"VLOOKUP(input_car_type,Data!I4:M13,5)","v":39000},"$$$",null,null,"unloading cost per unit container",100]
[null,{"$f":"IF($D$41=\"Yes\",\"x\",\" \")","v":" "},{"$f":"IF($D$41=\"Yes\",\"select type of container\",\"[optional inputs disabled]\")","v":"[optional inputs disabled]"},"20 ft. Reefer",{"$f":"IF($D$41=\"Yes\",\"type\",\"\")","v":""},null,null,"gross weight of train",{"$f":"gross_wt_of_cars+gross_wt_of_locomotives","v":3400},"tons",null,null,null,"Input/Output",null,null,null,"cost of one (1) locomotive",2000000,"$$$"]
[null,null,{"$f":"IF($D$41=\"Yes\",\"tare weight of one \" &D42,\" \")","v":" "},{"$f":"IF(D41=\"Yes\",VLOOKUP(D42,Data!D5:E9,2),0)","v":0},{"$f":"IF($D$41=\"Yes\",\"tons\",\"\")","v":""},null,null,"length of cars",{"$f":"(VLOOKUP(input_car_type,data_rail_cars,4)*number_of_carswells)","v":2650},"ft",null,null,"Total Rail Cost",{"$f":"SUM(S12,X9,X32,S57,X43,X57)","v":36671.312683463424},"$$$",null,null,"rail equipment life (years)",30,"years",null,null,"Total Loading and Unloading Cost (experimental)",{"$f":"(X40*D14)+(X41*D14)","v":20000},"$$$"]
[null,null,null,{"$f":"IF(AND(D41=\"Yes\",D45>VLOOKUP(D42,Data!D5:G9,4)),\"Warning! cargo weight exceeds allowed container payload. Maximum is \"&VLOOKUP(D42,Data!D5:G9,4)&\" tons\",\" \")","v":" "},null,null,null,"length of locomotives",{"$f":"VLOOKUP(input_locomotive_hp,data_locomotives,3)*I29","v":225},"ft",null,null,"per ton-mile (cents)",{"$f":"N43/(I41*N32)*100","v":6.9453243718680726},"cents/ton-mile",null,null,"salvage value (percentage)",0.1,"percent'"]
[null,{"$f":"IF($D$41=\"Yes\",\"x\",\" \")","v":" "},{"$f":"IF($D$41=\"Yes\",\"input cargo weight per container\",\"\")","v":""},null,{"$f":"IF($D$41=\"Yes\",\"tons\",\"\")","v":""},null,null,"length of train",{"$f":"I43+I44","v":2875},"ft",null,null,"per TEU",{"$f":"N43/D25","v":183.35656341731712},"$/TEU"]
[null,null,{"$f":"IF($D$41=\"Yes\",\"gross weight of one  container\",\" \")","v":" "},{"$f":"IF(D41=\"Yes\",D45+D43,0)","v":0},{"$f":"IF($D$41=\"Yes\",\"tons\",\"\")","v":""},null,null,"total number of axles - locomotives ",{"$f":"I7*number_of_locomotives","v":18},"axles",null,null,"per FEU",{"$f":"N43/number_of_carswells","v":733.42625366926848},"$/FEU",null,null,"hourly depreciation of one (1) car",{"$f":"(S41-(S44*S41))/(S43*8760)","v":0.13356164383561644},"$/hr"]
[null,null,null,null,null,null,null,"total number of axles - cars",{"$f":"number_of_carswells*D34","v":200},"axles",null,null,"per mile",{"$f":"N43/N32","v":133.35022793986698},"$/mile",null,null,"all cars",{"$f":"S46*D23","v":6.6780821917808222},"$/hr"]
[null,{"$f":"IF($D$41=\"Yes\",\"x\",\" \")","v":" "},{"$f":"IF(D41=\"Yes\", \"select type of car\", \" \")","v":" "},"5 unit cars",{"$f":"IF(D41=\"Yes\",\"car type\",\"\")","v":""},null,null,null,null,null,null,null,"per TEU-mile",{"$f":"(N43/(D25*N32))","v":0.66675113969933497},"$/TEU-mile",null,null,"hourly depreciation of one (1) locomotive",{"$f":"(S42-(S44*S42))/(S43*8760)","v":6.8493150684931505},"$/hr"]
[null,null,{"$f":"IF($D$41=\"Yes\",\"tare weight of one \" &D48,\" \")","v":" "},{"$f":"IF(D41=\"Yes\",VLOOKUP(D48,Data!I4:J6,2),0)","v":0},{"$f":"IF(D41=\"Yes\",\"tons\",\"\")","v":""},null,null,null,null,null,null,null,"per ton",{"$f":"total_cost/I41","v":19.099642022637202},"$/ton",null,null,"all locomotives",{"$f":"S48*I28","v":20.547945205479451},"$/hr",null,"Other Cost Calculation Module ($$$)"]
[null,{"$f":"IF($D$41=\"Yes\",\"x\",\" \")","v":" "},null,null,null,null,null,117000,105000,{"$f":"SUM(H50:I50)","v":222000},null,null,"percentage fuel",{"$f":"N55/total_cost","v":0.14146543536808515},"%",null,null,null,null,null,null,null,null,"Input/Output"]
[null,null,{"$f":"IF($D$41=\"Yes\",\"input number of containers\",\"\")","v":""},null,{"$f":"IF($D$41=\"Yes\",\"containers\",\"\")","v":""},null,null,null,null,null,null,null,"percentage maintenance",{"$f":"N56/total_cost","v":0.2909631321927435},"%",null,null,"annual interest rate",0,"percent",null,null,"Empty Return Ratio (experimental)",0,"percent"]
[null,null,null,null,null,null,"Locomotive Performance Module (Used in Calculating Train Speed)",null,null,null,null,null,"cost per carload",{"$f":"total_cost/number_of_carswells","v":733.42625366926848},"$/carload",null,null,"hourly interest charge for one car",{"$f":"S41*S43*S51/(8760*S43)","v":0},"$/hr",null,null,"other",null,"$/hr"]
[null,{"$f":"IF($D$41=\"Yes\",\"x\",\" \")","v":" "},{"$f":"IF($D$41=\"Yes\",\"are containers double stacked?\",\"\")","v":""},"Yes",{"$f":"IF($D$41=\"Yes\",\"yes/no\",\"\")","v":""},null,null,null,"Input/Output",null,null,null,null,null,null,null,null,"all cars",{"$f":"S52*D23","v":0},"$/hr",null,null,"other",null,"$/hr"]
[null,null,{"$f":"IF(D41=\"Yes\",\"number of \" &D48& \" needed\",\" \")","v":" "},{"$f":"IF(D41=\"Yes\",ROUNDUP(IF(D53=\"Yes\",D51/(2*VLOOKUP(D48,Data!I5:K7,3)),D51/VLOOKUP(D48,Data!I5:K7,3)),0.1),0)","v":0},{"$f":"IF(D41=\"Yes\",\"cars\",\" \")","v":" "},null,null,"iterated speed",79.9999999999946,"mph",null,null,"Cost Break Down",null,null,null,null,"hourly interest charge for one (1) locomotive",{"$f":"S42*S43*S51/(8760*S43)","v":0},"$/hr",null,null,"other",null,"$/mile"]
[null,null,{"$f":"IF(D42=\"Yes\",\"number of \" &D49& \" needed\",\" \")","v":" "},null,null,null,null,"equation of motion",{"$f":"308*required_horsepower-(1.3*gross_wt_of_locomotives+0.6*k_adj_value*gross_wt_of_cars+(20*user_input_percent_grade+0.8*user_input_curve_degrees)*gross_weight_of_train+29*no_of_axles_locomotives+20*k_adj_value*no_of_axles_cars)*iterated_speed-(0.03*gross_wt_of_locomotives+0.01*k_adj_value*gross_wt_of_cars)*iterated_speed^2-(0.3*number_of_locomotives+k_adj_value*k_value*number_of_carswells)*iterated_speed^3","v":1.2945383787155151E-7},null,null,null,"fuel cost",{"$f":"S12","v":5187.7232142853363},"$ USD",null,null,"all locomotives",{"$f":"S54*I28","v":0},"$/hr",null,null,"other",null,"$/mile"]
[null,null,{"$f":"IF($D$41=\"Yes\",\"utilization ratio (number of full containers)\",\"\")","v":""},null,{"$f":"IF($D$41=\"Yes\",\"percent\",\"\")","v":""},null,null,"cruising speed",{"$f":"iterated_speed","v":79.9999999999946},"mph",null,null,"maintenance cost",{"$f":"X9","v":10670},"$ USD"]
[null,null,{"$f":"IF($D$41=\"Yes\",\"number of full containers\",\" \")","v":" "},{"$f":"IF(D41=\"Yes\",ROUND(D51*D56,0.1),0)","v":0},{"$f":"IF($D$41=\"Yes\",$D$42,\"\")","v":""},null,null,"difference from maximum speed equation",{"$f":"input_maximum_train_speed-cruising_speed","v":5.4001247917767614E-12},"mph",null,null,"crew labor cost",{"$f":"X32","v":720},"$ USD",null,null,"Total Depreciation and Interest charges",{"$f":"(S47+S49+S53+S55)*N37","v":93.589469178088507},"$$$",null,null,"Total Other Cost",{"$f":"X51*SUM(S12,X9,X32,X43,S57)+(X52*train_travel_time)+(X53*+train_travel_time)+(X54*train_trip_miles)+(X55*train_trip_miles)","v":0},"$$$"]
[null,null,{"$f":"IF($D$41=\"Yes\",\"number of empty containers\",\" \")","v":" "},{"$f":"IF(D41=\"Yes\",D51-D57,0)","v":0},{"$f":"IF($D$41=\"Yes\",$D$42,\"\")","v":""},null,null,"tractive effort ",{"$f":"308*required_horsepower/iterated_speed","v":44449.999999996762},"lbs/ton",null,null,"capital & invest. cost",{"$f":"S57","v":93.589469178088507},"$ USD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"loading/unloading",{"$f":"X43","v":20000},"$ USD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"other cost",{"$f":"X57","v":0},"$ USD"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advanced Trip Details "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Station #","Location Name","Dist. Travelled","Elevation","Grade","Curvature","Speed","Travel Time","No. of Stops","Avg. Stop Delay","Fuel Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Dallas",1000,100,{"$f":"(T66-T65)/S65","v":5.0000000000000001E-3}]
[null,null,null,null,null,null,"Locomotive Performance Module - DeSalvo's Formulation (for Comparison)",null,null,null,null,null,null,null,null,null,null,null,null,105]
[]
[null,null,null,null,null,null,null,"iterated velocity",38.375002599960766,"mph"]
[null,null,null,null,null,null,null,"percentage grade of terrain",{"$f":"user_input_percent_grade","v":0},"%"]
[null,null,null,null,null,null,null,"curve of c degrees",{"$f":"user_input_curve_degrees","v":0},"degress °"]
[null,null,null,null,null,null,null,"total number of axles of locomotive units",{"$f":"I7*number_of_locomotives","v":18},"axles"]
[null,null,null,null,null,null,null,"total number of axles of freight cars",{"$f":"D34*D23","v":200},"axles"]
[null,null,null,null,null,null,null,"weight per axle",{"$f":"D31/SUM(I72)","v":14}]
[]
[null,null,null,null,null,null,null,"equation of motion (DeSalvo)",{"$f":"(308*I15)-((1.3+20*I69+0.8*I70)*I42+29*SUM(I71:I72))*I68-(0.03*I35+0.045*D31)*(I68^2)-(0.28125*number_of_locomotives+0.04375*D23)*(I68^3)","v":2900411.6383155938},"mph"]
[null,null,null,null,null,null,null,"tractive effort ",{"$f":"308*required_horsepower/I68","v":92664.488835842742},"lbs"]
[null,null,null,null,null,null,null,"cruising speed",{"$f":"IF(I75<10,I68,\"Keep trying\")","v":"Keep trying"},"mph"]

{"sheet":"Data","index":7,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[24,3,24,6],[33,3,33,6],[15,17,15,22],[1,17,1,18],[1,8,1,15],[15,3,15,5],[1,3,1,6],[16,8,16,12]]}
[]
[null,"Select ",null,"Containers",null,null,null,null,"Rail Cars (Single unit data)  Source: http://www.tealinc.com/carposting.htm",null,null,null,null,null,null,null,null,"Kadj values"]
[null,"Yes",null,"container","tare wt.","TEUs","max. payload (tons)",null,"type","tare weight (tons)","max gross wt.","length","cost","axles","K values","Kadj values",null,"equipment","Kadj"]
[null,"No",null,"20 ft. Dry",2.5,1,24,null,"Auto Transporters",74,130,145.33000000000001,null,4,7.0000000000000007E-2,1.3,null,"Pre-1950 equipment",1]
[null,null,null,"20 ft. Reefer",3.2,1,24,null,"Boxcars",37.1,143,58.35,null,4,7.0000000000000007E-2,0.85,null,"Conventional post-1950 cars",0.85]
[null,{"$f":"IF(input_containers=Data!I7,$B$3:$B$4,\"inactive\")","v":"inactive"},null,"40 ft Dry",4.2,2,30,null,"Center Partition Railcars",30.5,143,80.53,null,4,7.0000000000000007E-2,0.85,null,"Container-on-flatcar",0.95]
[null,null,null,"45 ft. H. Cube",4.5,2,30,null,"Container Carriers (5-unit)",17.600000000000001,110,53,{"$f":"195000/5","v":39000},4,9.35E-2,0.95,null,"Trailer-on-flatcar and hopper cars",1.05]
[null,null,null,"No Containers",0,0,30,null,"Gondolas",37.5,143,66,null,4,7.0000000000000007E-2,0.85,null,"Empty, covered auto racks",1.2]
[null,null,null,"Reefer 40 ft.",4.8,2,30.5,null,"High Cube Box Cars",39.65,143,67.875,null,4,7.0000000000000007E-2,0.85,null,"Loaded auto racks",1.3]
[null,null,null,null,null,null,null,null,"Hoppers",30.75,143,58,null,4,7.0000000000000007E-2,1.05,null,"Empty, uncovered auto racks",1.9]
[null,null,null,null,null,null,null,null,"Intermodal Flatcars",34,110,70,85000,4,9.35E-2,0.95]
[null,null,null,"http://www.railgoat.railfan.net/railwhales/a-axles.htm",null,null,null,null,"Other Flatcars",34,110,90,null,4,0.16,1.05]
[null,null,null,null,null,null,null,null,"Tankers",32.85,131.5,57.125,null,4,7.0000000000000007E-2,0.85]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sources","(Car Weight)"]
[null,null,null,"Data retrieval from Routes",null,null,null,null,null,null,null,null,null,"http://chicago.railfan.net/cgi/photos.pl/?page=DTTX_73342",null,null,null,"Line-Haul Emission Factors (g/gal)"]
[null,null,null,"RailRoad","Distance","Trip Time",null,null,"Locomotives",null,null,null,null,"http://www.tealinc.com/carposting.htm",null,null,null,null,"HC","CO","NOx","PM","VOC"]
[null,null,null,"BNSF",{"$f":"IFERROR(VLOOKUP(Model!N6&Model!N7,BNSF_Distances_Only,2),\"N/A\")","v":963},null,null,null,"horsepower","wt. (tons)","length (ft.)","cost","axles",null,null,null,null,"Uncontrolled",10,26.6,270.39999999999998,6.7,{"$f":"1.053*S18","v":10.53}]
[null,null,null,"KCS",{"$f":"INDEX(Routes!$B$67:$U$86, MATCH(Model!$N$6,Routes!$B$67:$B$86,), MATCH(Model!$N$7,Routes!$B$67:$U$67,))","v":{"$error":"#N/A"}},null,null,null,2000,190,75,null,6,null,null,null,null,"Tier 0",10,26.6,178,6.7,10.53]
[null,null,null,"UP",{"$f":"INDEX(Routes!$B$4:$O$16, MATCH(Model!$N$6,Routes!$B$4:$B$16,), MATCH(Model!$N$7,Routes!$B$4:$O$4,))","v":{"$error":"#N/A"}},null,null,null,3000,195,75,null,6,null,null,null,null,"Tier 1",9.8000000000000007,26.6,139,6.7,10.3194]
[null,null,null,"NS",null,null,null,null,3500,200,75,null,6,null,null,null,null,"Tier 2",5.4,26.6,103,3.6,5.6862000000000004]
[null,null,null,"USER SPECIFIED",null,null,null,null,3800,200,75,null,6,null,null,null,null,"Tier 3",2.7,26.6,103,1.66,2.8431000000000002]
[null,null,null,null,null,null,null,null,4000,200,75,null,6,null,null,null,null,"Tier 4",0.83,26.6,20.8,0.31,0.87398999999999993]
[null,null,null,null,null,null,null,null,4400,200,75,null,6]
[null,null,null,"Unit Convertor",null,null,null,null,5000,200,75,null,6]
[null,null,null,220000,"lbs",{"$f":"D26*0.0005","v":110},"tons",null,6000,200,75,null,6]
[null,null,null,null,"tons",{"$f":"D27*2000","v":0},"lbs"]
[null,null,null,null,"km",{"$f":"D28*0.62137","v":0},"miles"]
[null,null,null,null,"miles",{"$f":"D29* 1.6093","v":0},"km"]
[]
[]
[null,null,null,null,null,null,null,null,"220,000 lbs. Approx. Tare Weight 68,200 lbs. For Sale. "]
[]
[null,null,null,"Rail Facts from Jim Blaze"]
[null,null,1,"40ft - 53 ft well - 286,000 lbs (110 tons) gross weight"]
[null,null,2,"Westbound Rail: 50-60% empty",null,null,null,null,null,null,null,null,null,{"$f":"1.053*J37","v":0}]
[null,null,3,"Eastbound Rail: 5% empty"]
[null,null,4,"Eastern Railroads use 2.5-3.00 HPTT (BNSF), UP uses 2.2 HPTT"]
[null,null,5,"BNSF: 70mph"]
[null,null,5,"Average locomotive horsepower: 4400HP"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recent Emissions Standards for Locomotives"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.epa.gov/OMS/regs/nonroad/locomotv/420f09025.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.epa.gov/OMS/locomotives.htm#il"]

{"sheet":"Trial Hub","index":8,"n_rows":105,"n_cols":29,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,28,2,31],[2,14,2,17],[27,17,30,18],[0,0,3,0],[8,21,8,22],[0,19,0,21],[25,7,25,18],[0,3,0,4],[2,1,2,12]]}
[null,"User Input Column",null,"MACROS MUST BE ENABLED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYSTEM REQUIREMENTS: EXCEL 2007 AND ABOVE WITH MACROS ENABLED."]
[]
[null,"Analysis Table",null,null,null,null,null,null,null,null,null,null,null,null,"Scenario Manager",null,null,null,null,null,null,null,null,null,null,null,null,null,"Don’t Delete"]
[null,"Input Data Column","total cost","per ton-mile","per mile","per  TEU","per  FEU/Carload","%fuel","No. of Locos","Speed (mph)","Travel Time (hr)","Horsepower Rqd","% maintenance",null,null,"Build","Output",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,50,9150.4343000000008,3.4660736143183066,33.274299999999997,91.504300000000001,366.01740000000001,0.33768805190173812,2,80,3.4375,6876.8831168798706,0.62210161696871014,null,"Fuel Price ($)",2.5,{"$f":"input_fuel_price","v":2.5},{"$f":"IF(P5=Q5,\"GOOD\",\"ANALYZED\")","v":"GOOD"},null,null,null,null,null,null,null,null,null,null,"No"]
[null,60,10424.776099999999,3.2906490233658907,37.908299999999997,86.873099999999994,347.49250000000001,0.33665361104292607,2,80,3.4375,7810.5974025941559,0.62783122950894676,null,"Distance (miles)",275,{"$f":"user_input_distance","v":275},{"$f":"IF(P6=Q6,\"GOOD\",\"ANALYZED\")","v":"GOOD"}]
[null,70,12437.662399999999,3.36516839577757,45.227899999999998,88.840400000000002,355.36180000000002,0.31590218245386043,3,80,3.4375,8744.3116883084422,0.65225279036394368,null,"Max Speed (mph)",80,{"$f":"train_trip_speed","v":79.9999999999946},"ANALYZED"]
[null,80,13712.004199999999,3.2462131048811962,49.861800000000002,85.7,342.80009999999999,0.31714042806466575,3,80,3.4375,9678.0259740259735,0.65380668636386652,null,"No. of Sidings",0,{"$f":"user_input_sidings","v":0},"GOOD"]
[null,90,14986.3459,3.1536923230722915,54.495800000000003,83.257499999999993,333.0299,0.31816808890641346,3,80,3.4375,10611.740259737015,0.65509631586684891,null,"  Average Sidings Delay (min.)",0,{"$f":"user_input_sidings_delay","v":0},"GOOD"]
[null,100,16260.6877,3.0796756976254431,59.129800000000003,81.303399999999996,325.21379999999999,0.3190346752407246,3,80,3.4375,11545.454545451303,0.65618381016269967,null,"Type of Container","40 ft Dry",{"$f":"input_container_type","v":"40 ft Dry"},"GOOD"]
[null,110,18604.327799999999,3.2032244825697607,67.652100000000004,84.565100000000001,338.26049999999998,0.31917429534629782,4,80,3.4375,13215.27272727273,0.65777705784367824,null,"Cargo Weight (tons)",15,{"$f":"input_cargo_weight","v":15},"GOOD"]
[null,120,19878.669600000001,3.1374162814057014,72.286100000000005,82.827799999999996,331.31119999999999,0.31981865631845502,4,80,3.4375,14148.987012983769,0.65849477306102822,null,"Type of Car","Container Carriers (5-unit)",{"$f":"input_car_type","v":"Container Carriers (5-unit)"},"GOOD"]
[null,130,21153.011299999998,3.0817324188826909,76.92,81.357699999999994,325.43090000000001,0.32038537954111962,4,80,3.4375,15082.701298701299,0.65912601222413958,null,"No. of Containers / No. of Cars",100,{"$f":"input_containers","v":100},"GOOD"]
[null,140,23496.651399999999,3.1786595555344568,85.442400000000006,83.916600000000003,335.66640000000001,0.32036120475307994,5,80,3.4375,16752.519480516239,0.66009405822055511,null,"Double Stacked","Yes",{"$f":"input_double_stacked","v":"Yes"},"GOOD"]
[null,150,24770.993200000001,3.1276506564057471,90.076300000000003,82.57,330.2799,0.32081724260853339,5,80,3.4375,17686.233766230522,0.66055082526269382,null,"Utilization Ratio (%)",1,{"$f":"input_utilization_ratio","v":1},"GOOD"]
[null,160,26045.334999999999,3.0830178696682986,94.710300000000004,81.3917,325.56670000000003,0.32122865457719346,5,80,3.4375,18619.948051948053,0.66096289506291739,null,"Starting HPTT",7,{"$f":"calculated_hptt_ratio","v":4.1233766233760445},"ANALYZED"]
[null,170,27319.6767,3.0436359990174462,99.344300000000004,80.352000000000004,321.40800000000002,0.32160168545813461,5,80,3.4375,19553.662337662343,0.66133652240564311,null,"Locomotive HP",4000,{"$f":"input_locomotive_hp","v":4000},"GOOD"]
[null,180,29663.316800000001,3.1211402397391108,107.86660000000001,82.398099999999999,329.5924,0.32148643840328173,6,80,3.4375,21223.480519477274,0.66192867462915161,null,"Loading and Unloading Cost",100,{"$f":"input_loading_cost_per_container","v":100},{"$f":"IF(P18=Q18,\"GOOD\",\"ANALYZED\")","v":"GOOD"}]
[null,190,30937.658599999999,3.0838973886267267,112.50060000000001,81.414900000000003,325.65960000000001,0.32180522718130461,6,80,3.4375,22157.194805191564,0.66221882732295101]
[null,200,32212.000400000001,3.0503788226255808,117.1345,80.53,322.12,0.32209879269786129,6,80,3.4375,23090.90909090585,0.66248602250455002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Analysis Run: ","Number of Containers Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Train Length after last run =",{"$f":"Model!I43","v":2650},"ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Train Weight after last run =",{"$f":"gross_weight_of_train","v":3400},"tons"]
["Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cargo Weight after last run =",{"$f":"gross_wt_of_cars","v":2800},"tons"]
["To begin, Macros must be Enabled"]
["1. Build train using Scenario Manager. Use Build Column only!",null,null,null,null,null,null,"NUMBER OF CARS/CONTAINERS ANALYSIS COMPLETED!!!"]
["2. Input variables of interest into Input Data Column (i.e. varying distances, varying fuel prices, etc.) "]
["3. Perform Analysis of interest  by clicking on buttons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT TOUCH. ONLY VIEW IF YOUR ANALYSIS INFLUENCES TRAIN SPEED"]
["4. Check Output column of Scenario Manager to make sure all the rows read GOOD."]
["The row which reads ANALYZED is the row containing the variable that was just analyzed."]
["5. Copy graphs or data of interest into Word document or different spreadsheet before re-running"]
[" OR click Save Run to save analysis in different sheet without graphs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"Iterated Speed"]
["6. If Save Run is used, delete generated sheets when not needed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"308*hub_required_horsepower-(1.3*gross_wt_of_locomotives+0.6*k_adj_value*gross_wt_of_cars+(20*user_input_percent_grade+0.8*user_input_curve_degrees)*gross_weight_of_train+29*no_of_axles_locomotives+20*k_adj_value*no_of_axles_cars)*iterated_speed_hub-(0.03*gross_wt_of_locomotives+0.01*k_adj_value*gross_wt_of_cars)*iterated_speed_hub^2-(0.3*number_of_locomotives+k_adj_value*k_value*number_of_carswells)*iterated_speed_hub^3","v":-4.9965456128120422E-7},"Equation of Motion (Hub)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"equation_maxspeed_upperbound","v":5.4001247917767614E-12},"Equation Max Speed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P24*hub_calculated_hptt_ratio","v":11545.454545452925},"Required Horsepower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1233766233760445,"Calculated HPTT Ratio"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Truck Cost","index":9,"n_rows":93,"n_cols":28,"rows_kept":93,"cut":false,"hidden":false,"merged":[[86,8,86,10],[6,23,6,25],[68,1,68,6],[12,8,12,10],[24,8,24,10],[78,1,78,6],[22,0,22,2],[30,0,30,2],[77,8,77,10],[69,8,69,10],[55,8,55,10],[46,8,46,10],[22,4,22,6],[35,8,35,10],[4,22,4,25],[2,7,2,12],[3,0,3,16383],[4,0,4,3],[4,8,4,11]]}
[null,"SEMI-TRAILER LINE HAUL COST ANALYSIS",null,null,null,null,null,null,null,"Model: Updated April 16, 2009","Version: ",0.7]
[]
[null,"Cell Legend >>","User Input","Calculation"," Total Cost",null,null,"note: calculation cells have been locked. to freely edit cells, \"unprotect sheet\" (under \"review\" tab)."]
[]
["Cargo and Trailer Weight",null,null,null,null,null,null,null,"Basic Trip Details ",null,null,null,null,null,null,null,null,"Data Table",null,null,null,null,"Vehicle Configuration"]
[null,null,"Input/Output","(unit)",null,null,null,null,null,null,"Input/Output","(unit)",null,null,null,null,null,"Yes"]
[null,"cargo weight of one (1) container",15,"tons",null,null,null,null,null,"distance",275,"miles",null,null,null,null,null,"No",null,null,null,null,"type","Container Sizes",null,null,"Tare Weight","cost"]
[null,null,null,null,null,null,null,null,null,"average speed",65,"mph",null,null,null,null,null,null,null,null,null,null,"Standard Double",20,20,null,17.600000000000001]
[null,"tare weight of one (1) container (40 feet)",4,"tons",null,null,null,null,null,"estimated annual mileage",60000,"miles",null,null,null,null,null,null,null,null,null,null,"Standard Tractor-Semi",53,null,null,17.7]
[null,"tare weight of trailer",5,"tons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-Axle Tractor-Semi",53,null,null,18.850000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rocky Mountain Double",40,30,null,22.25]
[null,"gross weight of one (1) car (or well)",{"$f":"C7+C9+C10","v":24},"tons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Triple Trailer",20,20,20,23.55]
[null,null,{"$f":"IF(C12>110,\"Warning! Recommended max of 110 tons exceeded\", \" \")","v":" "},null,null,null,null,null,"Fuel Consumption",null,null,"$$$",null,null,null,null,null,null,null,null,null,null,"Turnpike Double",40,40,null,25.6]
[null,"number of trailers",1,"trailers",null,null,null,null,null,null,"Input/Output","(unit)"]
[null,null,null,null,null,null,null,null,"p","price per gallon of diesel fuel",2.5,"$ USD"]
[null,null,null,null,null,null,null,null,"η","fuel efficiency",5.5,"mpg"]
[null,"container units transported"]
[null,"total TEU",{"$f":"C14*2","v":2},"TEU",null,null,null,null,"F","Trip Fuel Cost",{"$f":"K7/K16*K15","v":125},"$$$"]
[null,"total FEU",{"$f":"C14","v":1},"FEU",null,null,null,null,null,"per mile",{"$f":"K18/K7","v":0.45454545454545453},"cents/mile"]
[null,null,null,null,null,null,null,null,null,"fuel consumption",{"$f":"K7/K16","v":50},"gals"]
[]
[null,null,null,null,null,null,null,null,"T","trip time (known)",null,"hr",{"$f":"K22/24","v":0},"day(s)"]
["Truck Tractor",null,null,null,"mini cost table",null,null,null,"T","trip time (calculated)",{"$f":"K7/K8","v":4.2307692307692308},"hr",{"$f":"K23/24","v":0.17628205128205129},"day(s)"]
[null,null,"Input/Output","(unit)",{"$f":"B42","v":"fuel cost"},null,{"$f":"C42","v":125}]
[null,"gross weight of truck tractor",5,"tons","maintenance cost",null,53.854166666666664,null,"Truck Emmisions",null,null,"$$$"]
[null,null,null,null,"labor and admin cost",null,194.61538461538461]
[null,null,null,null,"capital & invest. cost",null,134.75]
[null,null,null,null,"loading/unloading",null,0]
[null,null,null,null,"other cost",null,0]
[null,null,null,null,"total cost",null,{"$f":"SUM(G24:G29)","v":508.21955128205127}]
["Total Gross Weight of Semi-Trailer",null,null,null,"cents/ton-mile",null,{"$f":"K90","v":7.7002962315462318}]
[null,null,"Input/Output",null,"per mile",null,{"$f":"K93","v":1.8480710955710955},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LP Tardiff & Associates, 2006"]
["W","gross weight of semi-trailer",{"$f":"C25+(C14*C12)","v":29},"tons",{"$f":"J91","v":"per TEU"},null,{"$f":"K91","v":254.10977564102564}]
[null," in pounds",{"$f":"C33*2000","v":58000},"lbs",{"$f":"J92","v":"per FEU"},null,{"$f":"K92","v":508.21955128205127}]
[null,null,null,null,"cost per minute",null,{"$f":"K89/(K23*60)","v":2.0020770202020204}]
[null,null,null,null,null,null,null,null,"Maintenance",null,null,"$$$"]
[null,"1 ton = 2000 lbs",null,null,null,null,null,null,null,null,"Input/Output","(unit)"]
[null,null,null,null,null,null,null,null,null,"annual cost of repairs",5000,"$/yr"]
[null,null,null,null,null,null,null,null,null,"annual cost of license",1750,"$/yr"]
[null,null,null,null,null,null,null,null,null,"annual cost of insurance",5000,"$/yr"]
[null,"Cost Break Down Chart"]
[null,"fuel cost",{"$f":"K18","v":125},"$$$",null,null,null,null,null,"Annual maintenance cost",{"$f":"SUM(K38:K40)","v":11750},"$$$/yr"]
[null,"maintenance cost",{"$f":"K45","v":53.854166666666664},"$$$",null,null,null,null,null,"per mile",{"$f":"K42/K9","v":0.19583333333333333},"$/mile"]
[null,"labor and admin cost",{"$f":"K53","v":194.61538461538461},"$$$"]
[null,"capital & invest. cost",{"$f":"K67","v":134.75},"$$$",null,null,null,null,null,"Trip maintenance cost",{"$f":"K43*K7","v":53.854166666666664},"$$$"]
[null,"loading/unloading",{"$f":"K75","v":0},"$$$"]
[null,"other cost",{"$f":"K84","v":0},"$$$",null,null,null,null,"Labor and Admin Cost",null,null,"$$$"]
[null,null,null,null,null,null,null,null,null,null,"Input/Output","(unit)"]
[null,null,null,null,null,null,null,null,null,"driver wage",45,"$/hr",{"$f":"K49*8","v":360},"$/day"]
[null,null,null,null,null,null,null,null,null,"tolls",1,"$/hr"]
[null,null," "]
[null,null," "]
[null,null," ",null,null,null,null,null,null,"Trip Administrative Cost",{"$f":"SUM(K49:K51)*IF($K$23=0,$K$22,$K$23)","v":194.61538461538461},"$$$"]
[null,null," "]
[null,null," ",null,null," "]
[null,null," ",null,null,null,null,null,"Capital and Investment Cost",null,null,"$$$"]
[null,null," ",null,null,null,null,null,null,null,"Input/Output","(unit)"]
[null,null," ",null,null,null,null,null,null,"purchase price",110000,"$$$"]
[null,null," ",null,null,null,null,null,null,"years truck will be owned",5,"years"]
[null,null," ",null,null,null,null,null,null,"expected salvage value at end of ownership",18000,"$$$"]
[null,null," "]
[null,null," ",null,null,null,null,null,null,"annual interest rate",0.1,"%"]
[null,null," "]
[null,null," ",null,null,null,null,null,null,"Depreciation per mile",{"$f":"(K58-K60)/(K9*K59)","v":0.30666666666666664},"$/mile"]
[null,null," ",null,null,null,null,null,null,"Interest charges per mile",{"$f":"(K58*K59*K62)/(K9*K59)","v":0.18333333333333332},"$/mile"]
[null,null," "]
[null,null," ",null,null,null,null,null,null,"Trip Depreciation and Interest Cost",{"$f":"(K64+K65)*K7","v":134.75},"$$$"]
[null,null," "]
[]
[null,null," ",null,null,null,null,null,"Loading and Unloading Cost (experimental)",null,null,"$$$"]
[null,"Data Sources:"," ",null,null,null,null,null,null,"set input to 0 if not in use","Input/Output","(unit)"]
[null,"http://www.atri-online.org/research/results/economicanalysis/Operational_Costs_OnePager.pdf"," ",null,null,null,null,null,null,"loading cost per unit container",0,"$$$"]
[null,"http://www.ooida.com/trucking_tools/cpm/cost_per_mile.htm",null,null,null,null,null,null,null,"unloading cost per unit container",0,"$$$"]
[null,"http://www.truckinfo.net/trucking/shop-talk/costpermileadvice.htm"]
[null,"http://tonto.eia.doe.gov/oog/info/gdu/gasdiesel.asp",null,null,null,null,null,null,null,"Total Loading and Unloading Cost (experimental)",{"$f":"(K72*C14)+(K73*C14)","v":0},"$$$"]
[]
[]
[null,null,null,null,null,null,null,null,"Other Cost $$$",null,null,"$$$"]
[null,"Note: Calculation cells have been locked. To freely edit cells, \"Unprotect Sheet\" (under \"Review\" tab).",null,null,null,null,null,null,null,null,"Input/Output","(unit)"]
[null,null,null,null,null,null,null,null,null,"other",null,"percent"]
[null,null,null,null,null,null,null,null,null,"other",null,"$/hr"]
[null,null,null,null,null,null,null,null,null,"other",null,"$/mile"]
[]
[null,null,null,null,null,null,null,null,null,"Total Other Cost",{"$f":"K80*(K18+K45+K53+K67+K75)+(K81*MAX(K22,K23))+(K82*K7)","v":0},"$$$"]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL TRUCK COST",null,null,"$$$"]
[null,null,null,null,null,null,null,null,null,null,"Input/Output","(unit)"]
[null,null,null,null,null,null,null,null,null,"Total Truck Cost",{"$f":"SUM(K18,K45,K53, K67,K75,K84)","v":508.21955128205127},"$$$"]
[null,null,null,null,null,null,null,null,null,"per ton-mile",{"$f":"K89/(C12*K7)*100","v":7.7002962315462318},"cents/ton-mile"]
[null,null,null,null,null,null,null,null,null,"per TEU",{"$f":"K89/C18","v":254.10977564102564},"$/TEU"]
[null,null,null,null,null,null,null,null,null,"per FEU",{"$f":"K89/C19","v":508.21955128205127},"$/FEU"]
[null,null,null,null,null,null,null,null,null,"per mile",{"$f":"K89/K7","v":1.8480710955710955},"$/mile"]

{"sheet":"BNSF","index":10,"n_rows":374,"n_cols":12,"rows_kept":374,"cut":false,"hidden":true,"merged":[[2,8,2,11],[373,0,373,6],[374,0,374,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,2],[3,3,3,5],[3,6,4,6]]}
["BNSF 6003 Rail Miles Inquiry"]
["Search Date - Aug 24 , 2009 | Effective Date - Aug 24 , 2009"]
[null,null,null,null,null,null,null,null,"DO NOT TOUCH"]
["Origin",null,null,"Destination",null,null,"Rail Miles",null,null,null,null,"City/Terminals"]
["City","State","SPLC","City","State","SPLC",null,null,null,"Miles",null,"ALBUQUERQUE"]
["ALBUQUERQUE","NM",774900,"CHICAGO","IL",380000,1277,null,{"$f":"A6&D6","v":"ALBUQUERQUECHICAGO"},{"$f":"G6","v":1277},null,"ALLIANCE"]
[null,null,null,null,null,null,"OD Pair Unavailable",null,{"$f":"A7&D7","v":""},{"$f":"G7","v":"OD Pair Unavailable"},null,"AMARILLO"]
["ALLIANCE","TX",668100,"CHICAGO","IL",380000,963,null,"ALLIANCECHICAGO",963,null,"ATLANTA"]
["ALLIANCE","TX",668100,"GLOBAL GATEWAY SO","CA",883735,1521,null,"ALLIANCEGLOBAL GATEWAY SO",1521,null,"BARBOURS CUT"]
["ALLIANCE","TX",668100,"KANSAS CITY","KS",581520,529,null,"ALLIANCEKANSAS CITY",529,null,"BIRMINGHAM"]
["ALLIANCE","TX",668100,"LA HARBOR APM TERMI","CA",883737,1588,null,"ALLIANCELA HARBOR APM TERMI",1588,null,"CHICAGO"]
["ALLIANCE","TX",668100,"LONG BEACH A PIER","CA",883743,1587,null,"ALLIANCELONG BEACH A PIER",1587,null,"CHICAGO WESTERN AVE"]
["ALLIANCE","TX",668100,"LONG BEACH ITS","CA",883710,1587,null,"ALLIANCELONG BEACH ITS",1587,null,"DENVER"]
["ALLIANCE","TX",668100,"LONG BEACH J PIER","CA",883715,1588,null,"ALLIANCELONG BEACH J PIER",1588,null,"DILWORTH"]
["ALLIANCE","TX",668100,"LONG BEACH LBC","CA",883733,1587,null,"ALLIANCELONG BEACH LBC",1587,null,"EAST WINONA"]
["ALLIANCE","TX",668100,"LONG BEACH PCT","CA",883209,1588,null,"ALLIANCELONG BEACH PCT",1588,null,"EL PASO"]
["ALLIANCE","TX",668100,"LONG BEACH T PIER","CA","f",1587,null,"ALLIANCELONG BEACH T PIER",1587,null,"FRESNO"]
["ALLIANCE","TX",668100,"LOS ANGELES","CA",883000,1545,null,"ALLIANCELOS ANGELES",1545,null,"GLOBAL GATEWAY SO"]
["ALLIANCE","TX",668100,"OAKLAND INT GATEWAY","CA",876411,1861,null,"ALLIANCEOAKLAND INT GATEWAY",1861,null,"HOUSTON"]
["ALLIANCE","TX",668100,"PHOENIX","AZ",797000,1247,null,"ALLIANCEPHOENIX",1247,null,"KANSAS CITY"]
["ALLIANCE","TX",668100,"SAN BERNARDINO","CA",880270,1485,null,"ALLIANCESAN BERNARDINO",1485,null,"LA HARBOR APM TERMI"]
["ALLIANCE","TX",668100,"SOUTH SEATTLE","WA",845203,2385,null,"ALLIANCESOUTH SEATTLE",2385,null,"LOGISTICS PARK CHIC"]
["ALLIANCE","TX",668100,"STOCKTON","CA",875640,1779,null,"ALLIANCESTOCKTON",1779,null,"LONG BEACH A PIER"]
["ALLIANCE","TX",668100,"TICTF","CA",883213,1588,null,"ALLIANCETICTF",1588,null,"LONG BEACH CUT"]
["ALLIANCE","TX",668100,"WEST BASIN","CA",883252,1588,null,"ALLIANCEWEST BASIN",1588,null,"LONG BEACH ITS"]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable",null,"LONG BEACH J PIER"]
["AMARILLO","TX",672700,"GLOBAL GATEWAY SO","CA",883735,1192,null,"AMARILLOGLOBAL GATEWAY SO",1192,null,"LONG BEACH LBC"]
["AMARILLO","TX",672700,"OAKLAND INT GATEWAY","CA",876411,1532,null,"AMARILLOOAKLAND INT GATEWAY",1532,null,"LONG BEACH PCT"]
["AMARILLO","TX",672700,"TICTF","CA",883213,1259,null,"AMARILLOTICTF",1259,null,"LONG BEACH T PIER"]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable",null,"LOS ANGELES"]
["ATLANTA","GA",456200,"GLOBAL GATEWAY SO","CA",883735,2543,null,"ATLANTAGLOBAL GATEWAY SO",2543,null,"LUBBOCK"]
["ATLANTA","GA",456200,"LA HARBOR APM TERMI","CA",883737,2610,null,"ATLANTALA HARBOR APM TERMI",2610,null,"MEMPHIS"]
["ATLANTA","GA",456200,"LOS ANGELES","CA",883000,2567,null,"ATLANTALOS ANGELES",2567,null,"NEW ORLEANS"]
["ATLANTA","GA",456200,"OAKLAND INT GATEWAY","CA",876411,2883,null,"ATLANTAOAKLAND INT GATEWAY",2883,null,"OAKLAND INT GATEWAY"]
["ATLANTA","GA",456200,"PHOENIX","AZ",797000,2269,null,"ATLANTAPHOENIX",2269,null,"OMAHA"]
["ATLANTA","GA",456200,"STOCKTON","CA",875640,2801,null,"ATLANTASTOCKTON",2801,null,"PHOENIX"]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable",null,"PORTLAND"]
["BARBOURS CUT","TX",684815,"LA HARBOR APM TERMI","CA",883737,1824,null,"BARBOURS CUTLA HARBOR APM TERMI",1824,null,"SAN BERNARDINO"]
["BARBOURS CUT","TX",684815,"LOS ANGELES","CA",883000,1781,null,"BARBOURS CUTLOS ANGELES",1781,null,"SEATTLE"]
["BARBOURS CUT","TX",684815,"OAKLAND INT GATEWAY","CA",876411,2097,null,"BARBOURS CUTOAKLAND INT GATEWAY",2097,null,"SOUTH SEATTLE"]
[null,null,null,null,null,null,null,null,"",0,null,"SPOKANE"]
["BIRMINGHAM","AL",472600,"GLOBAL GATEWAY SO","CA",883735,2305,null,"BIRMINGHAMGLOBAL GATEWAY SO",2305,null,"ST LOUIS"]
["BIRMINGHAM","AL",472600,"LONG BEACH A PIER","CA",883743,2371,null,"BIRMINGHAMLONG BEACH A PIER",2371,null,"ST PAUL"]
["BIRMINGHAM","AL",472600,"LONG BEACH J PIER","CA",883715,2372,null,"BIRMINGHAMLONG BEACH J PIER",2372,null,"STOCKTON"]
["BIRMINGHAM","AL",472600,"LOS ANGELES","CA",883000,2329,null,"BIRMINGHAMLOS ANGELES",2329,null,"TACOMA"]
["BIRMINGHAM","AL",472600,"OAKLAND INT GATEWAY","CA",876411,2645,null,"BIRMINGHAMOAKLAND INT GATEWAY",2645,null,"TACOMA BLAIR"]
["BIRMINGHAM","AL",472600,"STOCKTON","CA",875640,2563,null,"BIRMINGHAMSTOCKTON",2563,null,"TACOMA EXP"]
["BIRMINGHAM","AL",472600,"TICTF","CA",883213,2372,null,"BIRMINGHAMTICTF",2372,null,"TACOMA SIM"]
["BIRMINGHAM","AL",472600,"WEST BASIN","CA",883252,2372,null,"BIRMINGHAMWEST BASIN",2372,null,"TICTF"]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable",null,"WEST BASIN"]
["CHICAGO","IL",380000,"ALBUQUERQUE","NM",774900,1277,null,"CHICAGOALBUQUERQUE",1277]
["CHICAGO","IL",380000,"ALLIANCE","TX",668100,963,null,"CHICAGOALLIANCE",963]
["CHICAGO","IL",380000,"DENVER","CO",744300,1009,null,"CHICAGODENVER",1009]
["CHICAGO","IL",380000,"DILWORTH","MN",503963,672,null,"CHICAGODILWORTH",672]
["CHICAGO","IL",380000,"EL PASO","TX",696900,1367,null,"CHICAGOEL PASO",1367]
["CHICAGO","IL",380000,"FRESNO","CA",878600,2234,null,"CHICAGOFRESNO",2234]
["CHICAGO","IL",380000,"GLOBAL GATEWAY SO","CA",883735,2096,null,"CHICAGOGLOBAL GATEWAY SO",2096]
["CHICAGO","IL",380000,"HOUSTON","TX",684800,1183,null,"CHICAGOHOUSTON",1183]
["CHICAGO","IL",380000,"KANSAS CITY","KS",581520,434,null,"CHICAGOKANSAS CITY",434]
["CHICAGO","IL",380000,"LA HARBOR APM TERMI","CA",883737,2163,null,"CHICAGOLA HARBOR APM TERMI",2163]
["CHICAGO","IL",380000,"LONG BEACH A PIER","CA",883743,2162,null,"CHICAGOLONG BEACH A PIER",2162]
["CHICAGO","IL",380000,"LONG BEACH J PIER","CA",883715,2163,null,"CHICAGOLONG BEACH J PIER",2163]
["CHICAGO","IL",380000,"LONG BEACH LBC","CA",883733,2162,null,"CHICAGOLONG BEACH LBC",2162]
["CHICAGO","IL",380000,"LONG BEACH PCT","CA",883209,2163,null,"CHICAGOLONG BEACH PCT",2163]
["CHICAGO","IL",380000,"LONG BEACH T PIER","CA",883734,2162,null,"CHICAGOLONG BEACH T PIER",2162]
["CHICAGO","IL",380000,"LOS ANGELES","CA",883000,2120,null,"CHICAGOLOS ANGELES",2120]
["CHICAGO","IL",380000,"OAKLAND INT GATEWAY","CA",876411,2418,null,"CHICAGOOAKLAND INT GATEWAY",2418]
["CHICAGO","IL",380000,"OMAHA","NE",553200,495,null,"CHICAGOOMAHA",495]
["CHICAGO","IL",380000,"PHOENIX","AZ",797000,1821,null,"CHICAGOPHOENIX",1821]
["CHICAGO","IL",380000,"PORTLAND","OR",853470,2216,null,"CHICAGOPORTLAND",2216]
["CHICAGO","IL",380000,"SAN BERNARDINO","CA",880270,2060,null,{"$f":"A71&D71","v":"CHICAGOSAN BERNARDINO"},{"$f":"G71","v":2060}]
["CHICAGO","IL",380000,"SEATTLE","WA",845200,2161,null,"CHICAGOSEATTLE",2161]
["CHICAGO","IL",380000,"SOUTH SEATTLE","WA",845203,2170,null,"CHICAGOSOUTH SEATTLE",2170]
["CHICAGO","IL",380000,"SPOKANE","WA",840600,1832,null,"CHICAGOSPOKANE",1832]
["CHICAGO","IL",380000,"ST PAUL","MN",504450,423,null,"CHICAGOST PAUL",423]
["CHICAGO","IL",380000,"STOCKTON","CA",875640,2336,null,"CHICAGOSTOCKTON",2336]
["CHICAGO","IL",380000,"TACOMA","WA",846200,2201,null,"CHICAGOTACOMA",2201]
["CHICAGO","IL",380000,"TACOMA BLAIR","WA",846206,2202,null,"CHICAGOTACOMA BLAIR",2202]
["CHICAGO","IL",380000,"TACOMA EXP","WA",846203,2201,null,"CHICAGOTACOMA EXP",2201]
["CHICAGO","IL",380000,"TACOMA PCT","WA",846209,2201,null,"CHICAGOTACOMA PCT",2201]
["CHICAGO","IL",380000,"TACOMA SIM","WA",846212,2202,null,"CHICAGOTACOMA SIM",2202]
["CHICAGO","IL",380000,"TICTF","CA",883213,2163,null,"CHICAGOTICTF",2163]
["CHICAGO","IL",380000,"WEST BASIN","CA",883252,2163,null,"CHICAGOWEST BASIN",2163]
["CHICAGO WESTERN AVE","IL",380423,"LONG BEACH PCT","CA",883209,"OD Pair Unavailable",null,"CHICAGO WESTERN AVELONG BEACH PCT","OD Pair Unavailable"]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["DENVER","CO",744300,"CHICAGO","IL",380000,1009,null,"DENVERCHICAGO",1009]
["DENVER","CO",744300,"SEATTLE","WA",845200,1604,null,"DENVERSEATTLE",1604]
["DENVER","CO",744300,"TACOMA","WA",846200,1644,null,"DENVERTACOMA",1644]
["DENVER","CO",744300,"TACOMA BLAIR","WA",846206,1645,null,"DENVERTACOMA BLAIR",1645]
["DENVER","CO",744300,"TACOMA EXP","WA",846203,1644,null,"DENVERTACOMA EXP",1644]
["DENVER","CO",744300,"TACOMA PCT","WA",846209,1644,null,"DENVERTACOMA PCT",1644]
["DENVER","CO",744300,"TACOMA SIM","WA",846212,1645,null,"DENVERTACOMA SIM",1645]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["DILWORTH","MN",503963,"CHICAGO","IL",380000,672,null,"DILWORTHCHICAGO",672]
["DILWORTH","MN",503963,"SEATTLE","WA",845200,1489,null,"DILWORTHSEATTLE",1489]
["DILWORTH","MN",503963,"TACOMA","WA",846200,1529,null,"DILWORTHTACOMA",1529]
["DILWORTH","MN",503963,"TACOMA BLAIR","WA",846206,1530,null,"DILWORTHTACOMA BLAIR",1530]
[null,null,null,null,null,null,null,null,"",0]
["EAST WINONA","WI",329886,"SEATTLE","WA",845200,1841,null,"EAST WINONASEATTLE",1841]
["EAST WINONA","WI",329886,"TACOMA","WA",846200,1881,null,"EAST WINONATACOMA",1881]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["EL PASO","TX",696900,"CHICAGO","IL",380000,1367,null,"EL PASOCHICAGO",1367]
["EL PASO","TX",696900,"LOS ANGELES","CA",883000,1096,null,"EL PASOLOS ANGELES",1096]
[null,null,null,null,null,null,null,null,"",0]
["FRESNO","CA",878600,"CHICAGO","IL",380000,2234,null,"FRESNOCHICAGO",2234]
[null,null,null,null,null,null,null,null,"",0]
["GLOBAL GATEWAY SO","CA",883735,"ALLIANCE","TX",668100,1521,null,"GLOBAL GATEWAY SOALLIANCE",1521]
["GLOBAL GATEWAY SO","CA",883735,"CHICAGO","IL",380000,2096,null,"GLOBAL GATEWAY SOCHICAGO",2096]
["GLOBAL GATEWAY SO","CA",883735,"HOUSTON","TX",684800,1734,null,"GLOBAL GATEWAY SOHOUSTON",1734]
["GLOBAL GATEWAY SO","CA",883735,"KANSAS CITY","KS",581520,1661,null,"GLOBAL GATEWAY SOKANSAS CITY",1661]
["GLOBAL GATEWAY SO","CA",883735,"LOGISTICS PARK CHIC","IL",384020,2068,null,"GLOBAL GATEWAY SOLOGISTICS PARK CHIC",2068]
["GLOBAL GATEWAY SO","CA",883735,"MEMPHIS","TN",439900,2066,null,"GLOBAL GATEWAY SOMEMPHIS",2066]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["HOUSTON","TX",684800,"CHICAGO","IL",380000,1183,null,"HOUSTONCHICAGO",1183]
["HOUSTON","TX",684800,"GLOBAL GATEWAY SO","CA",883735,1734,null,"HOUSTONGLOBAL GATEWAY SO",1734]
["HOUSTON","TX",684800,"LA HARBOR APM TERMI","CA",883737,1801,null,"HOUSTONLA HARBOR APM TERMI",1801]
["HOUSTON","TX",684800,"LONG BEACH A PIER","CA",883743,1800,null,"HOUSTONLONG BEACH A PIER",1800]
["HOUSTON","TX",684800,"LONG BEACH ITS","CA",883710,1800,null,"HOUSTONLONG BEACH ITS",1800]
["HOUSTON","TX",684800,"LONG BEACH J PIER","CA",883715,1801,null,"HOUSTONLONG BEACH J PIER",1801]
["HOUSTON","TX",684800,"LONG BEACH PCT","CA",883209,1801,null,"HOUSTONLONG BEACH PCT",1801]
["HOUSTON","TX",684800,"LONG BEACH T PIER","CA",883734,1800,null,"HOUSTONLONG BEACH T PIER",1800]
["HOUSTON","TX",684800,"LOS ANGELES","CA",883000,1758,null,"HOUSTONLOS ANGELES",1758]
["HOUSTON","TX",684800,"OAKLAND INT GATEWAY","CA",876411,2074,null,"HOUSTONOAKLAND INT GATEWAY",2074]
["HOUSTON","TX",684800,"STOCKTON","CA",875640,1992,null,"HOUSTONSTOCKTON",1992]
["HOUSTON","TX",684800,"TICTF","CA",883213,1801,null,"HOUSTONTICTF",1801]
["HOUSTON","TX",684800,"WEST BASIN","CA",883252,1801,null,"HOUSTONWEST BASIN",1801]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["KANSAS CITY","KS",581520,"CHICAGO","IL",380000,434,null,"KANSAS CITYCHICAGO",434]
["KANSAS CITY","KS",581520,"GLOBAL GATEWAY SO","CA",883735,1661,null,"KANSAS CITYGLOBAL GATEWAY SO",1661]
["KANSAS CITY","KS",581520,"LA HARBOR APM TERMI","CA",883737,1728,null,"KANSAS CITYLA HARBOR APM TERMI",1728]
["KANSAS CITY","KS",581520,"LONG BEACH A PIER","CA",883743,1727,null,"KANSAS CITYLONG BEACH A PIER",1727]
["KANSAS CITY","KS",581520,"LONG BEACH ITS","CA",883710,1727,null,"KANSAS CITYLONG BEACH ITS",1727]
["KANSAS CITY","KS",581520,"LONG BEACH J PIER","CA",883715,1728,null,"KANSAS CITYLONG BEACH J PIER",1728]
["KANSAS CITY","KS",581520,"LONG BEACH LBC","CA",883733,1727,null,"KANSAS CITYLONG BEACH LBC",1727]
["KANSAS CITY","KS",581520,"LONG BEACH PCT","CA",883209,1728,null,{"$f":"A135&D135","v":"KANSAS CITYLONG BEACH PCT"},{"$f":"G135","v":1728}]
["KANSAS CITY","KS",581520,"LONG BEACH T PIER","CA",883734,1727,null,"KANSAS CITYLONG BEACH T PIER",1727]
["KANSAS CITY","KS",581520,"LOS ANGELES","CA",883000,1685,null,"KANSAS CITYLOS ANGELES",1685]
["KANSAS CITY","KS",581520,"OAKLAND INT GATEWAY","CA",876411,2001,null,"KANSAS CITYOAKLAND INT GATEWAY",2001]
["KANSAS CITY","KS",581520,"PHOENIX","AZ",797000,1387,null,"KANSAS CITYPHOENIX",1387]
["KANSAS CITY","KS",581520,"SAN BERNARDINO","CA",880270,1625,null,"KANSAS CITYSAN BERNARDINO",1625]
["KANSAS CITY","KS",581520,"SEATTLE","WA",845200,2019,null,"KANSAS CITYSEATTLE",2019]
["KANSAS CITY","KS",581520,"STOCKTON","CA",875640,1919,null,"KANSAS CITYSTOCKTON",1919]
["KANSAS CITY","KS",581520,"TACOMA","WA",846200,2059,null,"KANSAS CITYTACOMA",2059]
["KANSAS CITY","KS",581520,"TACOMA BLAIR","WA",846206,2060,null,"KANSAS CITYTACOMA BLAIR",2060]
["KANSAS CITY","KS",581520,"TACOMA EXP","WA",846203,2059,null,"KANSAS CITYTACOMA EXP",2059]
["KANSAS CITY","KS",581520,"TACOMA PCT","WA",846209,2059,null,"KANSAS CITYTACOMA PCT",2059]
["KANSAS CITY","KS",581520,"TIC SEASIDE","CA",883213,1728,null,"KANSAS CITYTIC SEASIDE",1728]
["KANSAS CITY","KS",581520,"TICTF","CA",883213,1728,null,"KANSAS CITYTICTF",1728]
["KANSAS CITY","KS",581520,"WEST BASIN","CA",883252,1728,null,"KANSAS CITYWEST BASIN",1728]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LA HARBOR APM TERMI","CA",883737,"ALLIANCE","TX",668100,1588,null,"LA HARBOR APM TERMIALLIANCE",1588]
["LA HARBOR APM TERMI","CA",883737,"BARBOURS CUT","TX",684815,1824,null,"LA HARBOR APM TERMIBARBOURS CUT",1824]
["LA HARBOR APM TERMI","CA",883737,"CHICAGO","IL",380000,2163,null,"LA HARBOR APM TERMICHICAGO",2163]
["LA HARBOR APM TERMI","CA",883737,"HOUSTON","TX",684800,1801,null,"LA HARBOR APM TERMIHOUSTON",1801]
["LA HARBOR APM TERMI","CA",883737,"KANSAS CITY","KS",581520,1728,null,"LA HARBOR APM TERMIKANSAS CITY",1728]
["LA HARBOR APM TERMI","CA",883737,"LOGISTICS PARK CHIC","IL",384020,2135,null,"LA HARBOR APM TERMILOGISTICS PARK CHIC",2135]
["LA HARBOR APM TERMI","CA",883737,"MEMPHIS","TN",439900,2133,null,"LA HARBOR APM TERMIMEMPHIS",2133]
[null,null,null,null,null,null,null,null,"",0]
["LOGISTICS PARK CHIC","IL",384020,"DENVER","CO",744300,981,null,"LOGISTICS PARK CHICDENVER",981]
["LOGISTICS PARK CHIC","IL",384020,"GLOBAL GATEWAY SO","CA",883735,2068,null,"LOGISTICS PARK CHICGLOBAL GATEWAY SO",2068]
["LOGISTICS PARK CHIC","IL",384020,"LA HARBOR APM TERMI","CA",883737,2135,null,"LOGISTICS PARK CHICLA HARBOR APM TERMI",2135]
["LOGISTICS PARK CHIC","IL",384020,"LONG BEACH A PIER","CA",883743,2134,null,"LOGISTICS PARK CHICLONG BEACH A PIER",2134]
["LOGISTICS PARK CHIC","IL",384020,"LONG BEACH J PIER","CA",883715,2135,null,"LOGISTICS PARK CHICLONG BEACH J PIER",2135]
["LOGISTICS PARK CHIC","IL",384020,"LONG BEACH LBC","CA",883733,2134,null,"LOGISTICS PARK CHICLONG BEACH LBC",2134]
["LOGISTICS PARK CHIC","IL",384020,"LONG BEACH PCT","CA",883209,2135,null,"LOGISTICS PARK CHICLONG BEACH PCT",2135]
["LOGISTICS PARK CHIC","IL",384020,"LONG BEACH T PIER","CA",883734,2134,null,"LOGISTICS PARK CHICLONG BEACH T PIER",2134]
["LOGISTICS PARK CHIC","IL",384020,"LOS ANGELES","CA",883000,2092,null,"LOGISTICS PARK CHICLOS ANGELES",2092]
["LOGISTICS PARK CHIC","IL",384020,"OAKLAND INT GATEWAY","CA",876411,2390,null,"LOGISTICS PARK CHICOAKLAND INT GATEWAY",2390]
["LOGISTICS PARK CHIC","IL",384020,"OMAHA","NE",553200,467,null,"LOGISTICS PARK CHICOMAHA",467]
["LOGISTICS PARK CHIC","IL",384020,"PORTLAND","OR",853470,2260,null,"LOGISTICS PARK CHICPORTLAND",2260]
["LOGISTICS PARK CHIC","IL",384020,"SEATTLE","WA",845200,2205,null,"LOGISTICS PARK CHICSEATTLE",2205]
["LOGISTICS PARK CHIC","IL",384020,"TACOMA","WA",846200,2245,null,"LOGISTICS PARK CHICTACOMA",2245]
["LOGISTICS PARK CHIC","IL",384020,"TACOMA BLAIR","WA",846206,2246,null,"LOGISTICS PARK CHICTACOMA BLAIR",2246]
["LOGISTICS PARK CHIC","IL",384020,"TACOMA EXP","WA",846203,2245,null,"LOGISTICS PARK CHICTACOMA EXP",2245]
["LOGISTICS PARK CHIC","IL",384020,"TACOMA PCT","WA",846209,2245,null,"LOGISTICS PARK CHICTACOMA PCT",2245]
["LOGISTICS PARK CHIC","IL",384020,"TIC SEASIDE","CA",883213,2135,null,"LOGISTICS PARK CHICTIC SEASIDE",2135]
["LOGISTICS PARK CHIC","IL",384020,"TICTF","CA",883213,2135,null,"LOGISTICS PARK CHICTICTF",2135]
["LOGISTICS PARK CHIC","IL",384020,"WEST BASIN","CA",883252,2135,null,"LOGISTICS PARK CHICWEST BASIN",2135]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LONG BEACH A PIER","CA",883743,"ALLIANCE","TX",668100,1587,null,"LONG BEACH A PIERALLIANCE",1587]
["LONG BEACH A PIER","CA",883743,"BARBOURS CUT","TX",684815,1823,null,"LONG BEACH A PIERBARBOURS CUT",1823]
["LONG BEACH A PIER","CA",883743,"CHICAGO","IL",380000,2162,null,"LONG BEACH A PIERCHICAGO",2162]
["LONG BEACH A PIER","CA",883743,"HOUSTON","TX",684800,1800,null,"LONG BEACH A PIERHOUSTON",1800]
["LONG BEACH A PIER","CA",883743,"KANSAS CITY","KS",581520,1727,null,"LONG BEACH A PIERKANSAS CITY",1727]
["LONG BEACH A PIER","CA",883743,"LOGISTICS PARK CHIC","IL",384020,2134,null,"LONG BEACH A PIERLOGISTICS PARK CHIC",2134]
["LONG BEACH A PIER","CA",883743,"MEMPHIS","TN",439900,2132,null,"LONG BEACH A PIERMEMPHIS",2132]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LONG BEACH CUT","CA",883732,"ALLIANCE","TX",668100,1524,null,"LONG BEACH CUTALLIANCE",1524]
["LONG BEACH CUT","CA",883732,"CHICAGO","IL",380000,2099,null,"LONG BEACH CUTCHICAGO",2099]
["LONG BEACH CUT","CA",883732,"HOUSTON","TX",684800,1737,null,"LONG BEACH CUTHOUSTON",1737]
["LONG BEACH CUT","CA",883732,"KANSAS CITY","KS",581520,1664,null,"LONG BEACH CUTKANSAS CITY",1664]
["LONG BEACH CUT","CA",883732,"LOGISTICS PARK CHIC","IL",384020,2071,null,"LONG BEACH CUTLOGISTICS PARK CHIC",2071]
["LONG BEACH CUT","CA",883732,"MEMPHIS","TN",439900,2069,null,"LONG BEACH CUTMEMPHIS",2069]
[null,null,null,null,null,null,null,null,"",0]
["LONG BEACH ITS","CA",883710,"ALLIANCE","TX",668100,1587,null,"LONG BEACH ITSALLIANCE",1587]
["LONG BEACH ITS","CA",883710,"CHICAGO","IL",380000,2162,null,"LONG BEACH ITSCHICAGO",2162]
["LONG BEACH ITS","CA",883710,"HOUSTON","TX",684800,1800,null,"LONG BEACH ITSHOUSTON",1800]
["LONG BEACH ITS","CA",883710,"KANSAS CITY","KS",581520,1727,null,"LONG BEACH ITSKANSAS CITY",1727]
["LONG BEACH ITS","CA",883710,"LOGISTICS PARK CHIC","IL",384020,2134,null,{"$f":"A199&D199","v":"LONG BEACH ITSLOGISTICS PARK CHIC"},{"$f":"G199","v":2134}]
["LONG BEACH ITS","CA",883710,"MEMPHIS","TN",439900,2132,null,"LONG BEACH ITSMEMPHIS",2132]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LONG BEACH J PIER","CA",883715,"ALLIANCE","TX",668100,1588,null,"LONG BEACH J PIERALLIANCE",1588]
["LONG BEACH J PIER","CA",883715,"CHICAGO","IL",380000,2163,null,"LONG BEACH J PIERCHICAGO",2163]
["LONG BEACH J PIER","CA",883715,"HOUSTON","TX",684800,1801,null,"LONG BEACH J PIERHOUSTON",1801]
["LONG BEACH J PIER","CA",883715,"KANSAS CITY","KS",581520,1728,null,"LONG BEACH J PIERKANSAS CITY",1728]
["LONG BEACH J PIER","CA",883715,"LOGISTICS PARK CHIC","IL",384020,2135,null,"LONG BEACH J PIERLOGISTICS PARK CHIC",2135]
["LONG BEACH J PIER","CA",883715,"MEMPHIS","TN",439900,2133,null,"LONG BEACH J PIERMEMPHIS",2133]
[null,null,null,null,null,null,null,null,"",0]
["LONG BEACH LBC","CA",883733,"ALLIANCE","TX",668100,1587,null,"LONG BEACH LBCALLIANCE",1587]
["LONG BEACH LBC","CA",883733,"CHICAGO","IL",380000,2162,null,"LONG BEACH LBCCHICAGO",2162]
["LONG BEACH LBC","CA",883733,"HOUSTON","TX",684800,1800,null,"LONG BEACH LBCHOUSTON",1800]
["LONG BEACH LBC","CA",883733,"KANSAS CITY","KS",581520,1727,null,"LONG BEACH LBCKANSAS CITY",1727]
["LONG BEACH LBC","CA",883733,"LOGISTICS PARK CHIC","IL",384020,2134,null,"LONG BEACH LBCLOGISTICS PARK CHIC",2134]
["LONG BEACH LBC","CA",883733,"MEMPHIS","TN",439900,2132,null,"LONG BEACH LBCMEMPHIS",2132]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LONG BEACH PCT","CA",883209,"ALLIANCE","TX",668100,1588,null,"LONG BEACH PCTALLIANCE",1588]
["LONG BEACH PCT","CA",883209,"CHICAGO","IL",380000,2163,null,"LONG BEACH PCTCHICAGO",2163]
["LONG BEACH PCT","CA",883209,"HOUSTON","TX",684800,1801,null,"LONG BEACH PCTHOUSTON",1801]
["LONG BEACH PCT","CA",883209,"KANSAS CITY","KS",581520,1728,null,"LONG BEACH PCTKANSAS CITY",1728]
["LONG BEACH PCT","CA",883209,"LOGISTICS PARK CHIC","IL",384020,2135,null,"LONG BEACH PCTLOGISTICS PARK CHIC",2135]
["LONG BEACH PCT","CA",883209,"MEMPHIS","TN",439900,2133,null,"LONG BEACH PCTMEMPHIS",2133]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LONG BEACH T PIER","CA",883734,"ALLIANCE","TX",668100,1587,null,"LONG BEACH T PIERALLIANCE",1587]
["LONG BEACH T PIER","CA",883734,"CHICAGO","IL",380000,2162,null,"LONG BEACH T PIERCHICAGO",2162]
["LONG BEACH T PIER","CA",883734,"HOUSTON","TX",684800,1800,null,"LONG BEACH T PIERHOUSTON",1800]
["LONG BEACH T PIER","CA",883734,"KANSAS CITY","KS",581520,1727,null,"LONG BEACH T PIERKANSAS CITY",1727]
["LONG BEACH T PIER","CA",883734,"LOGISTICS PARK CHIC","IL",384020,2134,null,"LONG BEACH T PIERLOGISTICS PARK CHIC",2134]
["LONG BEACH T PIER","CA",883734,"MEMPHIS","TN",439900,2132,null,"LONG BEACH T PIERMEMPHIS",2132]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LOS ANGELES","CA",883000,"ALBUQUERQUE","NM",774900,890,null,"LOS ANGELESALBUQUERQUE",890]
["LOS ANGELES","CA",883000,"ALLIANCE","TX",668100,1545,null,"LOS ANGELESALLIANCE",1545]
["LOS ANGELES","CA",883000,"ATLANTA","GA",456200,2567,null,"LOS ANGELESATLANTA",2567]
["LOS ANGELES","CA",883000,"BIRMINGHAM","AL",472600,2329,null,"LOS ANGELESBIRMINGHAM",2329]
["LOS ANGELES","CA",883000,"CHICAGO","IL",380000,2120,null,"LOS ANGELESCHICAGO",2120]
["LOS ANGELES","CA",883000,"CLEVELAND","OH",null,"OD Pair Unavailable",null,"LOS ANGELESCLEVELAND","OD Pair Unavailable"]
["LOS ANGELES","CA",883000,"EL PASO","TX",696900,1096,null,"LOS ANGELESEL PASO",1096]
["LOS ANGELES","CA",883000,"HOUSTON","TX",684800,1758,null,"LOS ANGELESHOUSTON",1758]
["LOS ANGELES","CA",883000,"KANSAS CITY","KS",581520,1685,null,"LOS ANGELESKANSAS CITY",1685]
["LOS ANGELES","CA",883000,"LOGISTICS PARK CHIC","IL",384020,2092,null,"LOS ANGELESLOGISTICS PARK CHIC",2092]
["LOS ANGELES","CA",883000,"MEMPHIS","TN",439900,2090,null,"LOS ANGELESMEMPHIS",2090]
["LOS ANGELES","CA",883000,"NEW ORLEANS","LA",647000,2098,null,"LOS ANGELESNEW ORLEANS",2098]
["LOS ANGELES","CA",883000,"ST LOUIS","MO",567500,1982,null,"LOS ANGELESST LOUIS",1982]
["LOS ANGELES","CA",883000,"ST PAUL","MN",504450,2289,null,"LOS ANGELESST PAUL",2289]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["LUBBOCK","TX",677200,"GLOBAL GATEWAY SO","CA",883735,1189,null,"LUBBOCKGLOBAL GATEWAY SO",1189]
["LUBBOCK","TX",677200,"LONG BEACH A PIER","CA",883743,1255,null,"LUBBOCKLONG BEACH A PIER",1255]
["LUBBOCK","TX",677200,"LOS ANGELES","CA",883000,1213,null,"LUBBOCKLOS ANGELES",1213]
["LUBBOCK","TX",677200,"OAKLAND INT GATEWAY","CA",876411,1529,null,"LUBBOCKOAKLAND INT GATEWAY",1529]
["LUBBOCK","TX",677200,"TICTF","CA",883213,1256,null,"LUBBOCKTICTF",1256]
["LUBBOCK","TX",677200,"WEST BASIN","CA",883252,1256,null,"LUBBOCKWEST BASIN",1256]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["MEMPHIS","TN",439900,"GLOBAL GATEWAY SO","CA",883735,2066,null,"MEMPHISGLOBAL GATEWAY SO",2066]
["MEMPHIS","TN",439900,"LA HARBOR APM TERMI","CA",883737,2133,null,"MEMPHISLA HARBOR APM TERMI",2133]
["MEMPHIS","TN",439900,"LONG BEACH A PIER","CA",883743,2132,null,"MEMPHISLONG BEACH A PIER",2132]
["MEMPHIS","TN",439900,"LONG BEACH ITS","CA",883710,2132,null,"MEMPHISLONG BEACH ITS",2132]
["MEMPHIS","TN",439900,"LONG BEACH J PIER","CA",883715,2133,null,"MEMPHISLONG BEACH J PIER",2133]
["MEMPHIS","TN",439900,"LONG BEACH LBC","CA",883733,2132,null,"MEMPHISLONG BEACH LBC",2132]
["MEMPHIS","TN",439900,"LONG BEACH PCT","CA",883209,2133,null,"MEMPHISLONG BEACH PCT",2133]
["MEMPHIS","TN",439900,"LONG BEACH T PIER","CA",883734,2132,null,"MEMPHISLONG BEACH T PIER",2132]
["MEMPHIS","TN",439900,"LOS ANGELES","CA",883000,2090,null,"MEMPHISLOS ANGELES",2090]
["MEMPHIS","TN",439900,"OAKLAND INT GATEWAY","CA",876411,2406,null,"MEMPHISOAKLAND INT GATEWAY",2406]
["MEMPHIS","TN",439900,"STOCKTON","CA",875640,2324,null,"MEMPHISSTOCKTON",2324]
["MEMPHIS","TN",439900,"TACOMA SIM","WA",846212,2557,null,{"$f":"A263&D263","v":"MEMPHISTACOMA SIM"},{"$f":"G263","v":2557}]
["MEMPHIS","TN",439900,"TICTF","CA",883213,2133,null,"MEMPHISTICTF",2133]
["MEMPHIS","TN",439900,"WEST BASIN","CA",883252,2133,null,"MEMPHISWEST BASIN",2133]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["NEW ORLEANS","LA",647000,"LA HARBOR APM TERMI","CA",883737,2141,null,"NEW ORLEANSLA HARBOR APM TERMI",2141]
["NEW ORLEANS","LA",647000,"LONG BEACH A PIER","CA",883743,2140,null,"NEW ORLEANSLONG BEACH A PIER",2140]
["NEW ORLEANS","LA",647000,"LOS ANGELES","CA",883000,2098,null,"NEW ORLEANSLOS ANGELES",2098]
["NEW ORLEANS","LA",647000,"OAKLAND INT GATEWAY","CA",876411,2414,null,"NEW ORLEANSOAKLAND INT GATEWAY",2414]
["NEW ORLEANS","LA",647000,"TICTF","CA",883213,2141,null,"NEW ORLEANSTICTF",2141]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["OAKLAND INT GATEWAY","CA",876411,"ALLIANCE","TX",668100,1861,null,"OAKLAND INT GATEWAYALLIANCE",1861]
["OAKLAND INT GATEWAY","CA",876411,"ATLANTA","GA",456200,2883,null,"OAKLAND INT GATEWAYATLANTA",2883]
["OAKLAND INT GATEWAY","CA",876411,"BARBOURS CUT","TX",684815,2097,null,"OAKLAND INT GATEWAYBARBOURS CUT",2097]
["OAKLAND INT GATEWAY","CA",876411,"BIRMINGHAM","AL",472600,2645,null,"OAKLAND INT GATEWAYBIRMINGHAM",2645]
["OAKLAND INT GATEWAY","CA",876411,"CHICAGO","IL",380000,2418,null,"OAKLAND INT GATEWAYCHICAGO",2418]
["OAKLAND INT GATEWAY","CA",876411,"EL PASO","TX",696900,1412,null,"OAKLAND INT GATEWAYEL PASO",1412]
["OAKLAND INT GATEWAY","CA",876411,"HOUSTON","TX",684800,2074,null,"OAKLAND INT GATEWAYHOUSTON",2074]
["OAKLAND INT GATEWAY","CA",876411,"KANSAS CITY","KS",581520,2001,null,"OAKLAND INT GATEWAYKANSAS CITY",2001]
["OAKLAND INT GATEWAY","CA",876411,"LOGISTICS PARK CHIC","IL",384020,2390,null,"OAKLAND INT GATEWAYLOGISTICS PARK CHIC",2390]
["OAKLAND INT GATEWAY","CA",876411,"MEMPHIS","TN",439900,2406,null,"OAKLAND INT GATEWAYMEMPHIS",2406]
["OAKLAND INT GATEWAY","CA",876411,"ST LOUIS","MO",567500,2298,null,"OAKLAND INT GATEWAYST LOUIS",2298]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["OMAHA","NE",553200,"CHICAGO","IL",380000,495,null,"OMAHACHICAGO",495]
["OMAHA","NE",553200,"SEATTLE","WA",845200,1867,null,"OMAHASEATTLE",1867]
["OMAHA","NE",553200,"TACOMA","WA",846200,1907,null,"OMAHATACOMA",1907]
["OMAHA","NE",553200,"TACOMA BLAIR","WA",846206,1908,null,"OMAHATACOMA BLAIR",1908]
["OMAHA","NE",553200,"TACOMA EXP","WA",846203,1907,null,"OMAHATACOMA EXP",1907]
["OMAHA","NE",553200,"TACOMA PCT","WA",846209,1907,null,"OMAHATACOMA PCT",1907]
["OMAHA","NE",553200,"TACOMA SIM","WA",846212,1908,null,"OMAHATACOMA SIM",1908]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["PHOENIX","AZ",797000,"ALLIANCE","TX",668100,1247,null,"PHOENIXALLIANCE",1247]
["PHOENIX","AZ",797000,"CHICAGO","IL",380000,1821,null,"PHOENIXCHICAGO",1821]
["PHOENIX","AZ",797000,"KANSAS CITY","KS",581520,1387,null,"PHOENIXKANSAS CITY",1387]
[null,null,null,null,null,null,null,null,"",0]
["PORTLAND","OR",853470,"CHICAGO","IL",380000,2216,null,"PORTLANDCHICAGO",2216]
["PORTLAND","OR",853470,"ST PAUL","MN",504450,1793,null,"PORTLANDST PAUL",1793]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["SAN BERNARDINO","CA",880270,"ALLIANCE","TX",668100,1485,null,"SAN BERNARDINOALLIANCE",1485]
["SAN BERNARDINO","CA",880270,"CHICAGO","IL",380000,2060,null,"SAN BERNARDINOCHICAGO",2060]
["SAN BERNARDINO","CA",880270,"KANSAS CITY","KS",581520,1625,null,"SAN BERNARDINOKANSAS CITY",1625]
["SAN BERNARDINO","CA",880270,"ST PAUL","MN",504450,2229,null,"SAN BERNARDINOST PAUL",2229]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["SEATTLE","WA",845200,"CHICAGO","IL",380000,2161,null,"SEATTLECHICAGO",2161]
["SEATTLE","WA",845200,"DENVER","CO",744300,1604,null,"SEATTLEDENVER",1604]
["SEATTLE","WA",845200,"KANSAS CITY","KS",581520,2019,null,"SEATTLEKANSAS CITY",2019]
["SEATTLE","WA",845200,"LOGISTICS PARK CHIC","IL",384020,2205,null,"SEATTLELOGISTICS PARK CHIC",2205]
["SEATTLE","WA",845200,"MEMPHIS","TN",439900,2516,null,"SEATTLEMEMPHIS",2516]
["SEATTLE","WA",845200,"OMAHA","NE",553200,1867,null,"SEATTLEOMAHA",1867]
["SEATTLE","WA",845200,"ST PAUL","MN",504450,1738,null,"SEATTLEST PAUL",1738]
[null,null,null,null,null,null,null,null,"",0]
["SOUTH SEATTLE","WA",845203,"CHICAGO","IL",380000,2170,null,"SOUTH SEATTLECHICAGO",2170]
["SOUTH SEATTLE","WA",845203,"ST PAUL","MN",504450,1747,null,"SOUTH SEATTLEST PAUL",1747]
[null,null,null,null,null,null,null,null,"",0]
["SPOKANE","WA",840600,"CHICAGO","IL",380000,1832,null,"SPOKANECHICAGO",1832]
["SPOKANE","WA",840600,"ST PAUL","MN",504450,1409,null,"SPOKANEST PAUL",1409]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["ST LOUIS","MO",567500,"LONG BEACH A PIER","CA",883743,2024,null,"ST LOUISLONG BEACH A PIER",2024]
["ST LOUIS","MO",567500,"LOS ANGELES","CA",883000,1982,null,"ST LOUISLOS ANGELES",1982]
["ST LOUIS","MO",567500,"OAKLAND INT GATEWAY","CA",876411,2298,null,"ST LOUISOAKLAND INT GATEWAY",2298]
["ST LOUIS","MO",567500,"STOCKTON","CA",875640,2216,null,"ST LOUISSTOCKTON",2216]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["ST PAUL","MN",504450,"CHICAGO","IL",380000,423,null,"ST PAULCHICAGO",423]
["ST PAUL","MN",504450,"LOS ANGELES","CA",883000,2289,null,"ST PAULLOS ANGELES",2289]
["ST PAUL","MN",504450,"PORTLAND","OR",853470,1793,null,"ST PAULPORTLAND",1793]
["ST PAUL","MN",504450,"SEATTLE","WA",845200,1738,null,{"$f":"A327&D327","v":"ST PAULSEATTLE"},{"$f":"G327","v":1738}]
["ST PAUL","MN",504450,"SOUTH SEATTLE","WA",845203,1747,null,"ST PAULSOUTH SEATTLE",1747]
["ST PAUL","MN",504450,"SPOKANE","WA",840600,1409,null,"ST PAULSPOKANE",1409]
["ST PAUL","MN",504450,"TACOMA BLAIR","WA",846206,1779,null,"ST PAULTACOMA BLAIR",1779]
["ST PAUL","MN",504450,"TACOMA EXP","WA",846203,1778,null,"ST PAULTACOMA EXP",1778]
["ST PAUL","MN",504450,"TACOMA PCT","WA",846209,1778,null,"ST PAULTACOMA PCT",1778]
["ST PAUL","MN",504450,"TACOMA SIM","WA",846212,1779,null,"ST PAULTACOMA SIM",1779]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["STOCKTON","CA",875640,"ALLIANCE","TX",668100,1779,null,"STOCKTONALLIANCE",1779]
["STOCKTON","CA",875640,"ATLANTA","GA",456200,2801,null,"STOCKTONATLANTA",2801]
["STOCKTON","CA",875640,"BIRMINGHAM","AL",472600,2563,null,"STOCKTONBIRMINGHAM",2563]
["STOCKTON","CA",875640,"CHICAGO","IL",380000,2336,null,"STOCKTONCHICAGO",2336]
["STOCKTON","CA",875640,"HOUSTON","TX",684800,1992,null,"STOCKTONHOUSTON",1992]
["STOCKTON","CA",875640,"KANSAS CITY","KS",581520,1919,null,"STOCKTONKANSAS CITY",1919]
["STOCKTON","CA",875640,"MEMPHIS","TN",439900,2324,null,"STOCKTONMEMPHIS",2324]
["STOCKTON","CA",875640,"ST PAUL","MN",504450,2261,null,"STOCKTONST PAUL",2261]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["TACOMA","WA",846200,"OMAHA","NE",553200,1907,null,"TACOMAOMAHA",1907]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["TACOMA BLAIR","WA",846206,"CHICAGO","IL",380000,2202,null,"TACOMA BLAIRCHICAGO",2202]
["TACOMA BLAIR","WA",846206,"DENVER","CO",744300,1645,null,"TACOMA BLAIRDENVER",1645]
["TACOMA BLAIR","WA",846206,"KANSAS CITY","KS",581520,2060,null,"TACOMA BLAIRKANSAS CITY",2060]
["TACOMA BLAIR","WA",846206,"OMAHA","NE",553200,1908,null,"TACOMA BLAIROMAHA",1908]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["TACOMA EXP","WA",846203,"KANSAS CITY","KS",581520,2059,null,"TACOMA EXPKANSAS CITY",2059]
["TACOMA EXP","WA",846203,"LOGISTICS PARK CHIC","IL",384020,2245,null,"TACOMA EXPLOGISTICS PARK CHIC",2245]
["TACOMA EXP","WA",846203,"OMAHA","NE",553200,1907,null,"TACOMA EXPOMAHA",1907]
["TACOMA SIM","WA",846212,"CHICAGO","IL",380000,2202,null,"TACOMA SIMCHICAGO",2202]
["TACOMA SIM","WA",846212,"DENVER","CO",744300,1645,null,"TACOMA SIMDENVER",1645]
["TACOMA SIM","WA",846212,"KANSAS CITY","KS",581520,2060,null,"TACOMA SIMKANSAS CITY",2060]
["TACOMA SIM","WA",846212,"LOGISTICS PARK CHIC","IL",384020,2246,null,"TACOMA SIMLOGISTICS PARK CHIC",2246]
["TACOMA SIM","WA",846212,"MEMPHIS","TN",439900,2557,null,"TACOMA SIMMEMPHIS",2557]
["TACOMA SIM","WA",846212,"OMAHA","NE",553200,1908,null,"TACOMA SIMOMAHA",1908]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["TICTF","CA",883213,"ALLIANCE","TX",668100,1588,null,"TICTFALLIANCE",1588]
["TICTF","CA",883213,"CHICAGO","IL",380000,2163,null,"TICTFCHICAGO",2163]
["TICTF","CA",883213,"HOUSTON","TX",684800,1801,null,"TICTFHOUSTON",1801]
["TICTF","CA",883213,"KANSAS CITY","KS",581520,1728,null,"TICTFKANSAS CITY",1728]
["TICTF","CA",883213,"LOGISTICS PARK CHIC","IL",384020,2135,null,"TICTFLOGISTICS PARK CHIC",2135]
["TICTF","CA",883213,"MEMPHIS","TN",439900,2133,null,"TICTFMEMPHIS",2133]
[null,null,null,null,null,null,"OD Pair Unavailable",null,"","OD Pair Unavailable"]
["WEST BASIN","CA",883252,"ALLIANCE","TX",668100,1588,null,"WEST BASINALLIANCE",1588]
["WEST BASIN","CA",883252,"CHICAGO","IL",380000,2163,null,"WEST BASINCHICAGO",2163]
["WEST BASIN","CA",883252,"HOUSTON","TX",684800,1801,null,"WEST BASINHOUSTON",1801]
["WEST BASIN","CA",883252,"KANSAS CITY","KS",581520,1728,null,"WEST BASINKANSAS CITY",1728]
["WEST BASIN","CA",883252,"LOGISTICS PARK CHIC","IL",384020,2135,null,"WEST BASINLOGISTICS PARK CHIC",2135]
["WEST BASIN","CA",883252,"MEMPHIS","TN",439900,2133,null,"WEST BASINMEMPHIS",2133]
[null,null,null,null,null,null,null,null,"",0]