{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Truck Shmt Ex"],"read":"whole","date_system":"1900"}

{"sheet":"Truck Shmt Ex","index":0,"n_rows":35,"n_cols":5,"rows_kept":35}
["Common","PPI_TL",{"v":131,"d":"131.0"},"Jan 18","Prod Price Index for TL"]
[null,"PPI_LTL",177.4,"Jan 18","Prod Price Index for LTL"]
[null,"Kwt",25,"ton","Physical weight capacity"]
[null,"Kcu",2750,"ft^3","Effective cube capacity"]
[null,"unit cube",9,"ft^3"]
[null,"unit weight",40,"lb"]
[null,"s",{"$f":"C6/C5","v":{"v":4.444444444444445,"d":"4.4444"}},"lb/ft^3","Density (Class 200)"]
[null,"d",532,"mi","Distance"]
[null,"rTL",{"$f":"2*(C1/102.7)","v":{"v":2.5511197663096397,"d":"2.5511"}},"$/mi","TL rev per loaded tr-mi"]
[null,"qmax",{"$f":"MIN(C3,C7*C4/2000)","v":{"v":6.111111111111112,"d":"6.1111"}},"ton","Max payload"]
[]
["One-Time","no. units",320]
[null,"qTL",{"$f":"C12*C6/2000","v":6.4},"ton"]
[null,"nTL",{"$f":"CEILING(C13/C10,1)","v":2}]
[null,"cTL",{"$f":"C14*C9*C8","v":{"v":2714.3914313534565,"d":"2714.39"}},"$"]
[null,"c1TL",{"$f":"C15/C14","v":{"v":1357.1957156767282,"d":"1357.20"}},"$/TL"]
[null,"qLTL",{"$f":"C13-C10","v":{"v":0.28888888888888875,"d":"0.2889"}},"ton"]
[null,"qLTL",{"$f":"C17*2000","v":{"v":577.7777777777775,"d":"578"}},"lb"]
[null,"no. units",{"$f":"CEILING(C18/C6,1)","v":15}]
[null,"rLTL",{"$f":"C2*(((C7^2)/8+14)/((C17^(1/7)*C8^(15/29)-7/2)*(C7^2+2*C7+14)))","v":{"v":3.8014078092039134,"d":"3.8014"}},"$/ton-mi"]
[null,"cLTL",{"$f":"C20*C17*C8","v":{"v":584.2341424100946,"d":"584.23"}},"$"]
[null,"c1TL+cLTL",{"$f":"C16 + C21","v":{"v":1941.4298580868228,"d":"1941.43"}},"$"]
[null,"savings",{"$f":"C15-C22","v":{"v":772.9615732666336,"d":"772.96"}},"$"]
[null,"MC_TL",{"$f":"(C9/2)*45","v":{"v":57.40019474196689,"d":"57.40"}},"$","Min charge TL"]
[null,"MC_LTL",{"$f":"(C2/104.2)*(45+C8^(28/19)/1625)","v":{"v":87.5107523114767,"d":"87.51"}},"$","Min charge LTL"]
[null,"cLTL (FedEx LTL)",1251.64,"$","1/27/2020, Liab ?, 2 Serv days"]
[null,"Reverse trip (FedEx)",1091.76,"$","1/27/2020, Liab ?, 2 Serv days"]
[null,"OD(200,2)",127.69,"¢/cwt"]
[null,"OD(200,3)",99.92,"¢/cwt"]
[null,"q2B",0.5,"ton"]
[null,"MC",95.23,"$"]
[null,"disc",0]
[null,"cLTL (Czar, no disc)",{"$f":"(1 - C32)*MAX(C31,MIN(C28*20*C17,C29*20*C30))","v":{"v":737.7644444444442,"d":"737.76"}},"$"]
[null,"disc, Czar to est",{"$f":"1 -C21/ C33","v":{"v":0.20810206183080815,"d":"20.81%"}}]
[null,"q3W",{"$f":"(C29/C28)*C30","v":{"v":0.3912600830135485,"d":"0.3913"}},"ton"]