{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Data input","Cost defaults","O_O cost","Appr Sum","RTM Calculator","Trucks","Trailers","Definitions","Help","Module1"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":12,"comments":4,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":9,"reason":"part_missing"}],"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":"Data input","index":0,"n_rows":1000,"n_cols":37,"rows_kept":1000,"cut":false,"hidden":false,"merged":[[9,6,9,7],[10,4,11,5],[10,6,11,7],[12,4,13,5],[12,6,13,7],[4,2,4,3],[3,2,3,3],[9,1,9,3],[10,1,11,3],[9,4,9,5]]}
[null,"HaulCost 22.0 - TRUCKING APPRAISAL - DATA INPUT"]
[null,"April 10, 2023 - Microsoft Excel"]
[]
[null,null,"Sale name",null,"Volume type","Geographic area","Date","Appraisal point"]
[]
[]
[null,null,"Sale RTM's <traveling> <only>","Avg volume per load","Is scaling done?","Inflate costs?","Fuel cost per gallon","One-way trip mileage"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor rates…"]
[null,"Select truck or Truck-trailer combo",null,null,"Select trailer",null,"Select attached loader",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State","Rate/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,"Vol type","Inflate/Scale",null,null,null,null,null,"AL",31.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CCF","No",null,null,null,null,null,"AK",45.74]
[null,null,null,null,{"$f":"IF(OR(AF27=1,AF27=2),\"<<Trailer selection not needed w/stinger-steer>>\",0)","v":0},null,{"$f":"IF(OR(AF27=1,AF27=2),\"<<Loader selection not needed w/stringer-steer>>\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MBF","Yes",null," ",null,null,null,"AR",28.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ",33.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current default rtm's:",1,null,null,null,null,"CA",33.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO",32.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailer options","Trucks",null,null,"Index","Cost","Tires",null,"CT",37.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NT","Truck-trailer (standard stinger-steer, west US)",null,null,1,250000,18,null,"DE",38.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NT","Truck-trailer (self-loading, standard stinger-steer, west US)",null,null,2,300000,18,null,"FL",21.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T","Truck (with 5th wheel, needs trailer)",null,null,3,150000,10,null,"GA",33.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","Truck-tractor (3 axles, tandom axle, trailer optional)",null,null,4,175000,10,null,"HI",30.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","Truck-tractor (4 axles, tri axle, trailer optional)",null,null,5,190000,14,null,"IA",37.880000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","Truck-tractor (5 axles, trailer optional)",null,null,6,230000,18,null,"ID",33.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","Truck-tractor (6 axles, R9, trailer optional)",null,null,7,260000,22,null,"IL",38.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","Truck-tractor (7 axles, trailer optional)",null,null,8,270000,20,null,"IN",32.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<Not used>",null,null,9,0,0,null,"KS",43.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current truck index =",{"$f":"IF(ISERROR(VLOOKUP(B11,AC18:AF26,4,FALSE)),10,VLOOKUP(B11,AC18:AF26,4,FALSE))","v":9},58492.928000000007,null,null,"KY",36.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA",38.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailers",null,null,"Index","Cost","Tires",null,"MA",31.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<None>",null,null,1,0,0,null,"MD",32.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailer-pup, (2 axles)",null,null,2,50000,8,null,"ME",24.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailer (3 axles)",null,null,3,70000,12,null,"MI",30.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailer–crib (3 axles)",null,null,4,70000,12,null,"MN",33.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailer (5 axles)",null,null,5,90000,20,null,"MO",41.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailer–crib (7 axles)",null,null,6,120000,28,null,"MS",34.590000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chip Van",null,null,7,50000,8,null,"MT",33.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<Not used>",null,null,8,0,0,null,"NC",23.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<Not used>",null,null,9,0,0,null,"ND",34.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<Not used>",null,null,10,0,0,null,"NE",32.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<Not used>",null,null,11,0,0,null,"NH",33.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current trailer index =",{"$f":"IF(ISERROR(VLOOKUP(E11,AC30:AF40,4,FALSE)),12,VLOOKUP(E11,AC30:AF40,4,FALSE))","v":11},null,null,null,"NJ",34.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM",34.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detachable loaders",null,null,"Index","Cost",null,null,"NV",31.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<None>",null,null,1,0,null,null,"NY",33.369999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detachable loader (small, east US)",null,null,2,51935.019114168324,null,null,"OH",37.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detachable loader (large, east US)",null,null,3,66583.617391296531,null,null,"OK",33.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<Not used>",null,null,4,0,null,null,"OR",37.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<Not used>",null,null,5,0,null,null,"PA",34.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current self-loader index =",{"$f":"IF(ISERROR(VLOOKUP(G11,AC44:AF48,4,FALSE)),6,VLOOKUP(G11,AC44:AF48,4,FALSE))","v":5},null,null,null,"RI",36.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC",31.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD",30.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN",48.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX",22.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT",33.409999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA",38.409999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT",31.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA",31.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI",38.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV",31.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY",32.39]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["berger00"]

{"sheet":"Cost defaults","index":1,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,5,3,6],[4,5,4,6],[4,1,4,2],[3,1,3,2],[4,3,4,4],[3,3,3,4]]}
[null,"TRUCKING APPRAISAL - COST DEFAULTS"]
[null,"HaulCost ver 22.0"]
[]
[null,"Sale Name:",null,"Geographic Area:",null,"Date:"]
[null,{"$f":"IF(ISTEXT('Data input'!$C$5),'Data input'!$C$5,\"\")","v":""},null,{"$f":"IF(ISTEXT('Data input'!F5),'Data input'!F5,\"\")","v":""},null,{"$f":"IF('Data input'!$G$5>0,'Data input'!$G$5,\"\")","v":""}]
[]
[null,"Inflation rate","# Years to Inflate","Scale cost per unit vol",{"$f":"\"Truck cost\"&IF(OR('Data input'!AF49=2,'Data input'!AF49=3,'Data input'!AF27=2),\" (w/loader)\",\"\")","v":"Truck cost"},"Trailer cost","Hours per day"]
[null,{"$f":"C14","v":""},{"$f":"E19","v":""},{"$f":"C15","v":""},{"$f":"C16","v":0},{"$f":"C17","v":0},{"$f":"C18","v":10}]
[]
[null,"Standing rtm's","Not used","Operator labor rate","Overhead rate","PUC tax wt-mile","Scaling defect"]
[null,{"$f":"C19","v":65},null,{"$f":"E15","v":0},{"$f":"E16","v":0.1},{"$f":"E17","v":0.21},{"$f":"E18","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scale","Inflate","Type","Type2"]
[null,"Original Defaults Used In Above Table",null,null,null,null,"Volume Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISTEXT('Data input'!E8),'Data input'!E8=\"Yes\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT('Data input'!F8),'Data input'!F8=\"Yes\"),1,0)","v":0},{"$f":"IF(ISTEXT('Data input'!E5),IF('Data input'!E5=\"MBF\",1,2),0)","v":0},{"$f":"IF(ISTEXT('Data input'!E5),IF('Data input'!E5=\"MBF\",1,2),3)","v":3}]
[null,"inflation rate/yr",{"$f":"IF(AB13=1,0.04,\"\")","v":""},null,null,null,{"$f":"IF(ISTEXT('Data input'!$E$5),'Data input'!$E$5,\"\")","v":""}]
[null,"scale cost per uom",{"$f":"IF(AND(AA13=1,AC13=1),9.86,IF(AND(AA13=1,AC13=2),4.28,\"\"))","v":""},{"$f":"IF(ISTEXT('Data input'!F5),\"labor rate (\"&'Data input'!F5&\")\",\"labor rate (none)\")","v":"labor rate (none)"},{"$f":"IF(ISTEXT('Data input'!F5),VLOOKUP('Data input'!F5,'Data input'!AJ11:AK60,2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type","Cost"]
[null,{"$f":"\"truck cost\"&IF(OR('Data input'!AF49=2,'Data input'!AF49=3,'Data input'!AF27=2),\" (w/loader)\",\"\")","v":"truck cost"},{"$f":"AD16","v":0},"overhead rate",0.1,null,"Appraisal point:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Truck",{"$f":"CHOOSE('Data input'!AF27,'Data input'!AG18,'Data input'!AG19,'Data input'!AG20,'Data input'!AG24,'Data input'!AG22,'Data input'!AG21,'Data input'!AG23,'Data input'!AG25,'Data input'!AG26,0)+CHOOSE('Data input'!AF49,'Data input'!AG44,'Data input'!AG45,'Data input'!AG46,'Data input'!AG47,'Data input'!AG48,0)","v":0}]
[null,"trailer cost",{"$f":"AD17","v":0},"puc tax, $/mi",0.21,null,{"$f":"IF(ISTEXT('Data input'!$H$5),'Data input'!$H$5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailer",{"$f":"IF(OR('Data input'!AF27=1,'Data input'!AF27=2),'Data input'!AG27,CHOOSE('Data input'!AF41,'Data input'!AG30,'Data input'!AG31,'Data input'!AG32,'Data input'!AG33,'Data input'!AG34,'Data input'!AG35,'Data input'!AG36,,'Data input'!AG37,'Data input'!AG38,'Data input'!AG39,'Data input'!AG40,0))","v":0}]
[null,"haul hrs/day",10,"scaling defect",{"$f":"IF(AA13=1,0.05,\"\")","v":""}]
[null,{"$f":"\"standing rtm's \"&IF('Data input'!E8=\"Yes\",\"w/scale\", \"no scale\")","v":"standing rtm's w/scale"},{"$f":"IF(AND(ISTEXT('Data input'!E8),'Data input'!E8=\"Yes\"),85,65)","v":65},"years to inflate",{"$f":"IF(AB13=1,1,\"\")","v":""}]

{"sheet":"O_O cost","index":2,"n_rows":27,"n_cols":51,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[6,12,7,12],[6,13,7,13],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,11,13,11],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,6,7,6],[6,7,7,7],[12,7,13,7],[12,8,13,8],[12,9,13,9],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[23,7,23,10],[24,7,24,10],[25,7,25,10],[26,9,26,10],[3,3,3,5],[21,7,21,10],[22,7,22,10],[19,7,20,10],[12,10,13,10],[19,6,20,6],[3,10,3,11]]}
[null,"TRUCKING APPRAISAL - OWNING & OPERATING COST"]
[null,{"$f":"'Cost defaults'!B2","v":"HaulCost ver 22.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,"Fuel & Lube Table…"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lube Cost","Miles","Fuel","Fuel Cost","Lube Use","Lube Cost","Tot Fuel"]
[null,null,"Sale name:",{"$f":"IF(ISTEXT('Data input'!$C$5),'Data input'!$C$5,\"\")","v":""},null,null,"Geo. Area: ",{"$f":"IF(ISTEXT('Data input'!F5),'Data input'!F5,\"\")","v":""},null,"Appraisal point:",{"$f":"IF(ISTEXT('Data input'!H5),'Data input'!H5,\"\")","v":""},null,"Date:",{"$f":"IF('Data input'!$G$5>0,'Data input'!$G$5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Gal","Per Month","Mileage","Per Mile","Gal/Month","Per Mile","Lube/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,null,20,{"$f":"AC12/11","v":3272.7272727272725},7.5,{"$f":"IF(AD5>0,'Data input'!G8/AD5,0)","v":0},1,{"$f":"IF(AB5>0,AF5*AB5/AC5,0)","v":6.1111111111111114E-3},{"$f":"AG5+AE5","v":6.1111111111111114E-3}]
[null,"Ownership Cost, $/hour...",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," per mile"]
[null,"Equipment type","Equipment cost","Season -weeks","Hours per day","Days per week","Hours per year","Salvage %","Life-years","AAI","Ins, tax, lic - %","Trailer damage-%","Federal HVUT","Total cost per hour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maint & Repair Table…",null,null,"Total Maint & Repair Cost - $/Mi",null,null,{"$f":"ROUND(AE12+AJ12+AM12+AP12+AS12+AU12+AY12/2,2)","v":0.36}," truck",null,"Total Maint & Repair Cost - $/Mi",null,null,0.08," trailer"]
[null,"Truck",{"$f":"'Cost defaults'!E8-C11","v":0},40,{"$f":"'Cost defaults'!$G$8","v":10},5,{"$f":"F9*E9*D9","v":2000},0.2,8,{"$f":"(C9-H9*C9)*(I9+1)/(2*I9)+H9*C9","v":0},0.1,0,412.5,{"$f":"((C9-(H9*C9)+M9)/I9+K9*J9)/G9","v":2.5781249999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Truck","Weekly Service (48 wks)",null,"Seven Week Service",null,null,null,null,"Engine Rebuild",null,null,"Transmission Replace",null,null,"Rear End Replace",null,null,"Suspension Service",null,null,"Brakes Replace"]
[null,"Trailer",{"$f":"'Cost defaults'!F8","v":0},40,{"$f":"'Cost defaults'!$G$8","v":10},5,{"$f":"F10*E10*D10","v":2000},0.2,6,{"$f":"(C10-H10*C10)*(I10+1)/(2*I10)+H10*C10","v":0},0.05,0.05,0,{"$f":"((C10-(H10*C10)+M10)/I10+K10*J10+L10*J10)/G10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Shop","Miles Per","Min Per","$'s Per","Oil Change","Filter","Shop","Oil Sample","$'s Per","Rebuild","Rebuild","$'s Per","Replace","Replace","$'s Per","Replace","Replace","$'s Per","Service","Truck","Trailer","Replace","Replace ","$'s Per"]
[null,"Attach loader",{"$f":"CHOOSE('Data input'!AF49,'Data input'!AG44,'Data input'!AG45,'Data input'!AG46,'Data input'!AG47,'Data input'!AG48,0)","v":0},40,{"$f":"'Cost defaults'!$G$8","v":10},5,{"$f":"F11*E11*D11","v":2000},0.2,6,{"$f":"(C11-H11*C11)*(I11+1)/(2*I11)+H11*C11","v":0},0.05,0,0,{"$f":"((C11-(H11*C11)+M11)/I11+K11*J11+L11*J11)/G11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor/Hour","Year (11 mo)","Truck","Mile","Gallons","Cost","Labor Hrs","Exam-$'s","Mile","Miles","Cost","Mile","Miles","Cost","Mile","Miles","Cost","Mile","Miles","Cost/Mi","Cost/Mi","Miles","Cost","Mile"]
[null,null,"Labor Cost, $/hour...",null,null,null,null,"Truck Operating (Opr) Cost, $/mile...",null,null,null,null,null,{"$f":"SUM(N9:N11)","v":2.5781249999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,40,36000,60,{"$f":"AD12/60*AB12/AC12*48","v":5.333333333333333E-2},11,50,2,15,{"$f":"(AF12*AB5+AG12+AH12*AB12+AI12)*51/7/AC12","v":7.3869047619047612E-2},200000,15000,{"$f":"AL12/AK12","v":7.4999999999999997E-2},400000,40000,{"$f":"AO12/AN12","v":0.1},400000,8000,{"$f":"AR12/AQ12","v":0.02},200000,{"$f":"(1500+(16*AB12))/AT12","v":1.0699999999999999E-2},{"$f":"(250+4*AB12)/AT12","v":2.0500000000000002E-3},30000,1500,{"$f":"AX12/AW12","v":0.05}]
[null,null,"Labor type","Rate per hour","Overhead inflator","Total labor $/hour",null,"Fuel & lube/mi","Tire cost per mile","Maint & repair/mi","PUC tax wt per mile","Total cost per 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,null,"Total Maint & Repair Cost - $/Mi",null,null,0.4," truck"]
[null,null,"Straight time",{"$f":"'Cost defaults'!D11","v":0},{"$f":"1+'Cost defaults'!E11","v":1.1000000000000001},{"$f":"E15*D15","v":0},null,{"$f":"AH5","v":6.1111111111111114E-3},{"$f":"AD24","v":0},{"$f":"IF(C9=0,0,AE16)","v":0},{"$f":"IF(C9=0,0,'Cost defaults'!F11)","v":0},{"$f":"SUM(H15:K15)","v":6.1111111111111114E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Maint & Repair Cost - $/Mi",null,null,0.1," trailer"]
[null,null,"Overtime",{"$f":"D15*1.5","v":0},{"$f":"1+'Cost defaults'!E11","v":1.1000000000000001},{"$f":"E16*D16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Maint & Repair Cost - $/Mi",null,null,{"$f":"AE15+AE14","v":0.5}," total"]
[null,null,null,null,null,null,null,"Mi/trip","Trips","Tot miles","Mi for puc","Tot opr cost","Opr cost/hr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tire Table…"]
[null,null,null,null,null,null,null,{"$f":"'Data input'!H8*2","v":0},{"$f":"IF(increment>0,(60*'Cost defaults'!G8)/(increment+rtm),0)","v":0},{"$f":"I18*H18","v":0},{"$f":"J18/2","v":0},{"$f":"(J18*L15-K18*K15)","v":0},{"$f":"IF('Cost defaults'!G8>0,L18/'Cost defaults'!G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost New","Cost","Total","Number","Number","Tire Life","Tire Repair","Total Tire","Total Tire"]
[null,null,"Total Owning, Operating Cost & 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,"Tire","Recap (2)","Cost/Tire","Tires-truck","Tires-trailer","Miles","Percent","$/Mile-truck","$/Mile-trailer"]
[null,null,"Cost type","Straight time $/hr","Overtime $/hour","Straight time $/min","Overtime $/minute","Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,0,{"$f":"AC20+AB20","v":500},{"$f":"CHOOSE('Data input'!AF27,'Data input'!AH18-8,'Data input'!AH19,'Data input'!AH20,'Data input'!AH24,'Data input'!AH22,'Data input'!AH21,'Data input'!AH23,'Data input'!AH25,'Data input'!AH26,0)","v":0},{"$f":"IF(OR('Data input'!AF27=1,'Data input'!AF27=2),8,CHOOSE('Data input'!AF41,'Data input'!AH30,'Data input'!AH31,'Data input'!AH32,'Data input'!AH33,'Data input'!AH34,'Data input'!AH35,'Data input'!AH36,'Data input'!AH37,'Data input'!AH38,'Data input'!AH39,'Data input'!AH40,0))","v":0},30000,0,{"$f":"ROUND((AE20*AD20/(AG20))*(1+AH20),2)","v":0},{"$f":"ROUND(AF20*AD20/(AG20)*(1+AH20),2)","v":0}]
[]
[null,null,"Standing",{"$f":"F15+N12","v":2.5781249999999999E-2},{"$f":"F16+N12","v":2.5781249999999999E-2},{"$f":"D22/60","v":4.296875E-4},{"$f":"E22/60","v":4.296875E-4},"ownership + labor costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Tire Cost - $/MI",null,{"$f":"AI20","v":0}," truck",null,"Overtime…"]
[null,null,"Traveling",{"$f":"D22+M18","v":2.5781249999999999E-2},{"$f":"E22+M18","v":2.5781249999999999E-2},{"$f":"D23/60","v":4.296875E-4},{"$f":"E23/60","v":4.296875E-4},"ownership + labor + operating costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Tire Cost - $/MI",null,{"$f":"AJ20","v":0}," trailer",null,{"$f":"'Cost defaults'!G8-8","v":2}]
[null,null,null,"Average standing ",null,{"$f":"IF(AND('Cost defaults'!G8>0,increment>0),(F22*(8)+G22*(AG24))/'Cost defaults'!G8,0)","v":0},"($/min)","ownership + labor costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Tire Cost - $/MI",null,{"$f":"AD23+AD22","v":0}," total",null,{"$f":"IF(AG23>0,AG23,0)","v":2}]
[null,null,null,"Average traveling ",null,{"$f":"IF(AND('Cost defaults'!G8>0,increment>0),(F23*(8)+G23*(AG24))/'Cost defaults'!G8,0)","v":0},"($/min)","ownership + labor + operating costs"]
[null,null,null,"Wt. average combined ",null,{"$f":"IF(increment>0,((F25*(increment))+(F24*rtm))/(increment+rtm),0)","v":0},"($/min)",{"$f":"\"avg $/\"&IF('Data input'!E5=\"MBF\",\"mbf-min\",\"ccf-min\")&\"=\"&TEXT(IF('Data input'!$D$8>0,F26/'Data input'!$D$8,0),\"0.0000\")&\",  \"&TEXT(IF('Data input'!$D$8>0,(F26/'Data input'!$D$8)*('Data input'!C8+'Cost defaults'!B11)*'Data input'!D8,0),\"$0,0.00\")&\" cost per trip\"","v":"avg $/mbf-min=0.0000,  $00.00 cost per trip"}]
[null,null,null,null,null,null,null,null,null,{"$f":"TEXT(I18,\"0.000\")&\" total trips\"","v":"0.000 total trips"}]

{"sheet":"Appr Sum","index":3,"n_rows":17,"n_cols":30,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,6,12,6],[11,4,12,5],[3,2,3,4],[10,3,12,3],[14,5,16,6],[14,3,15,3]]}
[null,"TRUCKING APPRAISAL - APPRAISAL SUMMARY"]
[null,{"$f":"'Cost defaults'!B2","v":"HaulCost ver 22.0"}]
[]
[null,"Sale name:",{"$f":"IF(ISTEXT('Data input'!$C$5),'Data input'!$C$5,\"\")","v":""},null,null,"Geo. area: ",{"$f":"IF(ISTEXT('Data input'!F5),'Data input'!F5,\"\")","v":""},null,null,"Date:",{"$f":"IF('Data input'!$G$5>0,'Data input'!$G$5,\"\")","v":""}]
[]
[null,"Cost type","Average trip rtm's",{"$f":"IF(AND(ISTEXT('Data input'!E5),'Data input'!E5=\"MBF\"),\"MBF\",\"CCF\")&\" per load\"","v":"CCF per load"},"Tot rtm's per day","Total OT rtm's",{"$f":"IF(AND(ISTEXT('Data input'!E5),'Data input'!E5=\"MBF\"),\"MBF\",\"CCF\")&\" vol per day\"","v":"CCF vol per day"},"Gross cost per day","Net cost per day",{"$f":"\"Net cost per \"&IF(AND(ISTEXT('Data input'!E5),'Data input'!E5=\"MBF\"),\"mbf\",\"ccf\")","v":"Net cost per ccf"},{"$f":"\"Net $/\"&IF(AND(ISTEXT('Data input'!E5),'Data input'!E5=\"MBF\"),\"mbf\",\"ccf\")&\" w/inflation\"","v":"Net $/ccf w/inflation"}]
[null,"w/o scale",{"$f":"IF(AND(AA11=0,increment>0),increment+rtm,0)","v":0},{"$f":"IF(AND(AA11=0,'Data input'!D8>0),'Data input'!$D$8,0)","v":0},{"$f":"IF(AND(AA11=0,'Data input'!D8>0),'Cost defaults'!$G$8*60,0)","v":0},{"$f":"IF(AND(AA11=0,'Data input'!D8>0),'O_O cost'!AG24*60,0)","v":0},{"$f":"IF(AND(AA11=0,C7>0),'O_O cost'!I18*D7,0)","v":0},{"$f":"IF(AND(AA11=0,'Data input'!D8>0),E7*'O_O cost'!F26,0)","v":0},{"$f":"IF(AA11=0,H7,0)","v":0},{"$f":"IF(AND(AA11=0,G7>0),I7/G7,0)","v":0},{"$f":"IF(AND(AA11=0,AB11=1,'Data input'!D8>0),J7*(1+'Cost defaults'!$B$8)^'Cost defaults'!$C$8,J7)","v":0}]
[]
[null,"with scale",{"$f":"IF(AND(AA11=1,increment>0),increment+rtm,0)","v":0},{"$f":"IF(AND(AA11=1,'Data input'!D8>0),'Data input'!$D$8,0)","v":0},{"$f":"IF(AND(AA11=1,'Data input'!D8>0),'Cost defaults'!$G$8*60,0)","v":0},{"$f":"IF(AND(AA11=1,'Data input'!D8>0),'O_O cost'!AG24*60,0)","v":0},{"$f":"IF(AND(AA11=1,C9>0),'O_O cost'!I18*D9,0)","v":0},{"$f":"IF(AND(AA11=1,'Data input'!D8>0),IF('Appr Sum'!D14=\"No\",E9*'O_O cost'!F26,(E9*'O_O cost'!F26)+'Cost defaults'!D8*G9),0)","v":0},{"$f":"IF(AND(AA11=1,'Data input'!D8>0),H9/(1-'Cost defaults'!G11),0)","v":0},{"$f":"IF(AND(AA11=1,G9>0),I9/G9,0)","v":0},{"$f":"IF(AND(AA11=1,AB11=1,'Data input'!D8>0),J9*(1+'Cost defaults'!$B$8)^'Cost defaults'!$C$8,J9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conditions…"]
[null,null,{"$f":"IF(AD11=1,\"<<Scaling cost is included in the total haul cost/vol below>>\",\"<<Scaling cost is not included in the total haul cost/vol below>>\")","v":"<<Scaling cost is not included in the total haul cost/vol below>>"},null,null,null,null,null,null,null,{"$f":"IF('Data input'!F8=\"Yes\",\"Yrs. inflated = \"&TEXT('Cost defaults'!C8,\"0.0\")&\"  at \"&TEXT('Cost defaults'!B8*100,\"0.0\")&\"%\",0)","v":"Yrs. inflated =   at 0.0%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scale","Inflate","Use","Use2"]
[null,null,null,"Include scale cost in final haul cost",null,null,null,null,{"$f":"TEXT(increment,\"0\")&\" minutes\"","v":"0 minutes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISTEXT('Data input'!E8),'Data input'!E8=\"Yes\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT('Data input'!F8),'Data input'!F8=\"Yes\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT('Data input'!E8),'Data input'!E8=\"Yes\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT('Appr Sum'!D14),AC11=1),IF('Appr Sum'!D14=\"Yes\",1,2),3)","v":3}]
[null,null,null,null,{"$f":"\"Total haul cost, $/\"&IF(AND(ISTEXT('Data input'!E5),'Data input'!E5=\"MBF\"),\"mbf\",\"ccf\")&\" = \"","v":"Total haul cost, $/ccf = "},null,{"$f":"MAXA(J7:K9)","v":0}]
[null,"Volume Type:",null,null,null,null,null,null,null,null,"Appraisal point:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include scale"]
[null,{"$f":"IF(ISTEXT('Data input'!$E$5),'Data input'!$E$5,\"\")","v":""},null,"No",null,"Sale or Haul Narrative",null,null,null,null,{"$f":"IF(ISTEXT('Data input'!H5),'Data input'!H5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,{"$f":"IF(OR(ISBLANK('Data input'!E8),'Data input'!E8=\"No\"),\"scaling not selected in Data Input\",\"\")","v":"scaling not selected in Data Input"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,"Scaling total dollar cost/day:",{"$f":"'Cost defaults'!D8*G9","v":0}]

{"sheet":"RTM Calculator","index":4,"n_rows":52,"n_cols":78,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Traveling Round Trip Minutes (RTM's) Calculator"]
[{"$f":"'Cost defaults'!B2","v":"HaulCost ver 22.0"}]
[null,"Total traveling RTM's ",null,{"$f":"SUM(D7:D36)","v":0}]
[null,"Total one-way distance in miles",null,{"$f":"SUM(C7:C36)","v":0}]
[]
["Road type segments","Avg. grade in direction of loaded truck","One-way distance in miles","Traveling RTM's"]
[null,null,null,{"$f":"IF(OR(ISBLANK(A7),C7=0),0,VLOOKUP(A7,$AI$9:$BZ$29,VLOOKUP(B7,$AF$10:$AG$52,2,FALSE),FALSE)*C7)","v":0}]
[null,null,null,{"$f":"IF(OR(ISBLANK(A8),C8=0),0,VLOOKUP(A8,$AI$9:$BZ$29,VLOOKUP(B8,$AF$10:$AG$52,2,FALSE),FALSE)*C8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade LU table…",null,null,"BNG Table, round trip travel times (minutes) per mile based on road type and grade…"]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade","Column",null,"Grade Percent (+/-)",-0.21,{"$f":"AJ9+0.01","v":-0.19999999999999998},{"$f":"AK9+0.01","v":-0.18999999999999997},-0.17999999999999997,-0.16999999999999996,-0.15999999999999995,-0.14999999999999994,-0.13999999999999993,-0.12999999999999992,-0.11999999999999993,-0.10999999999999993,-9.9999999999999936E-2,-8.9999999999999941E-2,-7.9999999999999946E-2,-6.9999999999999951E-2,-5.9999999999999949E-2,-4.9999999999999947E-2,-3.9999999999999945E-2,-2.9999999999999943E-2,-1.9999999999999941E-2,-9.9999999999999412E-3,5.8980598183211441E-17,1.0000000000000059E-2,2.0000000000000059E-2,3.0000000000000061E-2,4.0000000000000063E-2,5.0000000000000065E-2,6.0000000000000067E-2,7.0000000000000062E-2,8.0000000000000057E-2,9.0000000000000052E-2,0.10000000000000005,0.11000000000000004,0.12000000000000004,0.13000000000000003,0.14000000000000004,0.15000000000000005,0.16000000000000006,0.17000000000000007,0.18000000000000008,0.19000000000000009,0.20000000000000009,0.2100000000000001]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.21,2,null,"Paved super elevation hwy or interstate",9.9,9.5,9.1,8.6999999999999993,8.3000000000000007,7.9,7.5,7.1,6.7,6.3,5.9,5.5,5,4.5999999999999996,4.2,3.8,3.4,3,2.7,2.6,2.6,2.6,3,3.6,4.7,5.0999999999999996,6,6.9,7.7,8.6,9.4,10.3,11.2,12.1,13,13.9,14.8,15.7,16.600000000000001,17.5,18.399999999999999,19.3,20.2]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF10+0.01","v":-0.19999999999999998},{"$f":"AG10+1","v":3},null,"2 lane paved, alignment excellent",9.9,9.5,9.1,8.6999999999999993,8.3000000000000007,7.9,7.5,7.1,6.7,6.3,5.9,5.5,5,4.5999999999999996,4.2,3.8,3.4,3,2.7,2.6,2.6,2.6,3,3.6,4.3,5.0999999999999996,6,6.9,7.7,8.6,9.4,10.3,11.2,12.1,13,13.9,14.8,15.7,16.600000000000001,17.5,18.399999999999999,19.3,20.2]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF11+0.01","v":-0.18999999999999997},{"$f":"AG11+1","v":4},null,"2 lane paved, alignment good",9.9,9.5,9.1,8.6999999999999993,8.3000000000000007,7.9,7.5,7.1,6.7,6.3,5.9,5.5,5,4.5999999999999996,4.2,3.8,3.4,3,2.9,2.9,2.9,2.9,3.2,3.8,4.3,5.0999999999999996,6,6.9,7.7,8.6,9.4,10.3,11.2,12.1,13,13.9,14.8,15.7,16.600000000000001,17.5,18.399999999999999,19.3,20.2]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.17999999999999997,5,null,"2 lane paved, alignment fair",9.9,9.5,9.1,8.6999999999999993,8.3000000000000007,7.9,7.5,7.1,6.7,6.3,5.9,5.5,5,4.5999999999999996,4.2,3.8,3.5,3.4,3.4,3.4,3.4,3.4,3.5,4,4.7,5.3,6,6.9,7.7,8.6,9.4,10.3,11.2,12.1,13,13.9,14.8,15.7,16.600000000000001,17.5,18.399999999999999,19.3,20.2]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.16999999999999996,6,null,"1 lane paved, alignment excellent",9.9,9.5,9.1,8.6999999999999993,8.3000000000000007,7.9,7.5,7.1,6.7,6.3,5.9,5.5,5,4.5999999999999996,4.2,3.8,3.5,3.3,3.3,3.3,3.3,3.3,3.3,3.9,4.5999999999999996,6.4,6,6.8,7.7,8.6,9.4,10.3,11.2,12.1,13,13.9,14.9,15.7,16.600000000000001,17.5,18.399999999999999,19.3,20.2]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.15999999999999995,7,null,"1 lane paved, alignment good",9.9,9.5,9.1,8.6999999999999993,8.3000000000000007,7.9,7.5,7.1,6.7,6.3,5.9,5.5,5,4.5999999999999996,4.3,4.2,4.2,4.2,4.2,4.2,4.2,4.2,4.2,4.3,5,5.6,6.3,7,7.7,8.6,9.4,10.3,11.2,12.1,13,13.9,14.9,15.7,16.600000000000001,17.5,18.399999999999999,19.3,20.2]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.14999999999999994,8,null,"1 lane paved, alignment poor",9.9,9.5,9.1,8.6999999999999993,8.3000000000000007,7.9,7.5,7.1,6.7,6.3,5.9,5.5,5.2,5,5,5,5,5,5,5,5,5,5,5,5.5,6.1,6.8,7.4,8.1,8.9,9.4,10.3,11.2,12.1,13,13.9,14.8,15.7,16.600000000000001,17.5,18.399999999999999,19.3,20.2]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.13999999999999993,9,null,"2 lane gravel, alignment excellent",10,9.6,9.1999999999999993,8.8000000000000007,8.4,8,7.6,7.2,6.8,6.4,6,5.6,5.0999999999999996,4.7,4.3,3.9,3.4,3,2.8,2.6,2.6,2.8,3.3,3.9,4.5,5.4,6.3,7.2,8.1,8.9,9.8000000000000007,10.7,11.6,12.5,13.4,14.3,15.2,16.100000000000001,17,17.899999999999999,18.8,19.7,20.6]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.12999999999999992,10,null,"2 lane gravel, alignment good",10,9.6,9.1999999999999993,8.8000000000000007,8.4,8,7.6,7.2,6.8,6.4,6,5.6,5.0999999999999996,4.7,4.3,3.9,3.4,3.1,2.9,2.9,2.9,3,3.5,4.0999999999999996,4.7,5.4,6.3,7.2,8.1,8.9,9.8000000000000007,10.7,11.6,12.5,13.4,14.3,15.2,16.100000000000001,17,17.899999999999999,18.8,19.7,20.6]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.11999999999999993,11,null,"2 lane gravel, alignment fair",10,9.9,9.1999999999999993,8.8000000000000007,8.4,8,7.6,7.2,6.8,6.4,6,5.6,5.0999999999999996,4.7,4.3,3.9,3.6,3.4,3.4,3.4,3.4,3.4,3.8,4.4000000000000004,5,5.7,6.3,7.2,8.1,8.9,9.8000000000000007,10.7,11.6,12.5,13.4,14.3,15.2,16.100000000000001,17,17.899999999999999,18.8,19.7,20.6]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.10999999999999993,12,null,"1 lane gravel with turn-outs and ditch, alignment excellent",10,9.6,9.1999999999999993,8.8000000000000007,8.4,8,7.6,7.2,6.8,6.4,6,5.6,5.0999999999999996,4.7,4.3,3.9,3.6,3.4,3.4,3.4,3.4,3.4,3.7,4.2,4.9000000000000004,5.6,6.3,7.2,8.1,8.9,9.8000000000000007,10.7,11.6,12.5,13.4,14.3,15.2,16.100000000000001,17,17.899999999999999,18.8,19.7,20.6]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-9.9999999999999936E-2,13,null,"1 lane gravel with turn-outs and ditch, alignment good",10,9.6,9.1999999999999993,8.8000000000000007,8.4,8,7.6,7.2,6.8,6.4,6,5.6,5.0999999999999996,4.7,4.5,4.2,4.2,4.2,4.2,4.2,4.2,4.2,4.2,4.5999999999999996,5.3,6,6.6,7.3,8.1,8.9,9.8000000000000007,10.7,11.6,12.5,13.4,14.3,15.2,16.100000000000001,17,17.899999999999999,18.8,19.7,20.6]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-8.9999999999999941E-2,14,null,"1 lane gravel with turn-outs and ditch, alignment fair",10,9.6,9.1999999999999993,8.8000000000000007,8.4,8,7.6,7.2,6.8,6.4,6,5.6,5.3,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.8,6.4,7.1,7.8,8.5,9.1,9.8000000000000007,10.7,11.6,12.5,13.4,14.3,15.2,16.100000000000001,17,17.899999999999999,18.8,19.7,20.6]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-7.9999999999999946E-2,15,null,"1 lane gravel with turn-outs and ditch, alignment poor",9.3000000000000007,9,8.6999999999999993,8.4,8.1,7.8,7.5,7.2,6.9,6.6,6.3,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.3,7,7.6,8.3000000000000007,9,9.6,10.3,11,11.7,12.4,13.1,13.8,14.5,15.2,15.9,16.600000000000001,17.3,18,18.7]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-6.9999999999999951E-2,16,null,"1 lane dirt with turn-outs and ditch, alignment good",11.1,10.6,10.1,9.6,9.1,8.6,8.1,7.6,7.1,6.6,6.1,5.7,5.3,4.8,4.5,4.3,4.2,4.2,4.2,4.2,4.2,4.2,4.3,4.9000000000000004,5.6,6.3,6.9,7.6,8.3000000000000007,9.1999999999999993,10.1,11,11.9,12.8,13.7,14.6,15.5,16.399999999999999,17.3,18.2,19.100000000000001,20,20.9]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.9999999999999949E-2,17,null,"1 lane dirt with turn-outs and ditch, alignment fair",11.1,10.6,10.1,9.6,9.1,8.6,8.1,7.6,7.1,6.6,6.1,5.7,5.5,5.2,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.0999999999999996,5.4,6,6.7,7.4,8.1,8.8000000000000007,9.4,10.1,11,11.9,12.8,13.7,14.6,15.5,16.399999999999999,17.3,18.2,19.100000000000001,20,20.9]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.9999999999999947E-2,18,null,"1 lane dirt with turn-outs and ditch, alignment poor",8.5,8.3000000000000007,8.1,7.9,7.7,7.5,7.3,7.1,6.9,6.7,6.5,6.2,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.1,6.6,7.2,7.9,8.6,9.3000000000000007,10,10.6,11.3,12,12.7,13.4,14.1,14.8,15.5,16.2,16.899999999999999,17.600000000000001,18.3,19]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.9999999999999945E-2,19,null,"1 lane dirt with turn-outs, alignment good",11.1,10.6,10.1,9.6,9.1,8.6,8.1,7.6,7.1,6.6,6.1,5.7,5.3,4.8,4.5999999999999996,4.3,4.3,4.3,4.3,4.3,4.3,4.3,4.4000000000000004,5,5.7,6.3,7,7.7,8.4,9.1999999999999993,10.1,11,11.9,12.8,13.7,14.6,15.5,16.399999999999999,17.3,18.2,19.100000000000001,20,20.9]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.9999999999999943E-2,20,null,"1 lane dirt with turn-outs, alignment fair",11.1,10.6,10.1,9.6,9.1,8.6,8.1,7.6,7.1,6.6,6.1,5.8,5.6,5.3,5.3,5.3,5.3,5.3,5.3,5.3,5.3,5.3,5.3,5.5,6.2,6.9,7.6,8.1999999999999993,8.9,9.6,10.3,11,11.7,12.4,13.1,13.8,14.5,15.2,15.9,16.600000000000001,17.3,18,18.7]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.9999999999999941E-2,21,null,"1 lane dirt with turn-outs, alignment poor",8.9,8.6999999999999993,8.5,8.3000000000000007,8.1,7.9,7.7,7.5,7.3,7.1,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,6.9,7.6,8.3000000000000007,9,9.6,10.3,11,11.7,12.4,13.1,13.8,14.5,15.2,15.9,16.600000000000001,17.3,18,18.7,19.399999999999999]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-9.9999999999999412E-3,22]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8980598183211441E-17,23]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0000000000000059E-2,24]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0000000000000059E-2,25]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.0000000000000061E-2,26]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0000000000000063E-2,27]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0000000000000065E-2,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.0000000000000067E-2,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000062E-2,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.0000000000000057E-2,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.0000000000000052E-2,32]
[null,null,null,null,null,null,null,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.10000000000000005,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11000000000000004,34]
[null,null,null,null,null,null,null,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.12000000000000004,35]
[null,null,null,null,null,null,null,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.13000000000000003,36]
[null,null,null,null,null,null,null,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.14000000000000004,37]
[null,null,null,null,null,null,null,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.15000000000000005,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16000000000000006,39]
[null,null,null,null,null,null,null,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.17000000000000007,40]
[null,null,null,null,null,null,null,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.18000000000000008,41]
[null,null,null,null,null,null,null,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.19000000000000009,42]
[null,null,null,null,null,null,null,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.20000000000000009,43]
[null,null,null,null,null,null,null,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.2100000000000001,44]

{"sheet":"Trucks","index":5,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Truck Pictures"]
[{"$f":"'Cost defaults'!B2","v":"HaulCost ver 22.0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Truck w/5th wheel",null,null,null,null,"Truck-trailer, standard stinger-steer",null,null,null,null,"Truck-tractor, 5 axles, Detactable Loader"]
[null,null,null,null,null,null,"18 tires, western US",null,null,null,null,"18 tires"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Truck-tractor, 4 axles, (tri axle)",null,null,null,null,"Truck-tractor, 6 axles, w/detachable loader",null,null,null,null,"Truck-tractor, 7 axles, detachable loader"]
[null,"14 tires",null,null,null,null,"22 tires",null,null,null,null,"20 tires, 3 dual tire axles + 3 single tire axles"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Truck-tractor, 3 axles, tandom axle"]
[null,"10 tires"]

{"sheet":"Trailers","index":6,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Trailer & Loader Pictures"]
[{"$f":"'Cost defaults'!B2","v":"HaulCost ver 22.0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Trailer, 5 axles",null,null,null,null,"Tri axle with 2 axle pup, w/attached loader",null,null,null,null,"Trailer–crib, 3 axles"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Trailer–crib, 8 axles (similar to 7 axles)",null,null,null,null,"Michigan trailer-crib, 7axles",null,null,null,null,"Trailer–crib, 3 axles "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Trailer-pup, 4 axles",null,null,null,null,"Trailer-pup, 3 axles",null,null,null,null,"Attachable loader"]

{"sheet":"Definitions","index":7,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["TRUCKING APPRAISAL - DEFINITIONS"]
[{"$f":"'Cost defaults'!B2","v":"HaulCost ver 22.0"}]
[]
["Term Used","Definition","Where Found (tabs)"]
[".xxx","data input as a percentage, i.e. .050 = 5.0%","Cost defaults tab"]
["aai-$","average annual investment","O_O cost tab"]
["attached loader","a log loader that can be easily attached to the truck - eastern US","Data input tab, Cost defaults tab"]
["ccf or mbf","wood volume expressed in 100's of cubic feet (cunits) or mbf (1,000's of board feet)","Data input tab, Cost defaults tab, Appr summary tab"]
["ccf or mbf per load","the average volume (in 100's of cubic feet or 1,000's of board feet) loaded on a truck","Data input tab, Appr summary tab"]
["ccf or mbf vol per day","the amount of volume hauled per day (1 truck) in ccf or mbf","Appr summary tab"]
["fuel & lube","the cost (expressed here as $/mile) of fuel and lubrication for equipment","O_O cost tab"]
["geographic area","state the haul process takes place in primarily (for labor rates)","Data input tab, Cost defaults tab, Appr summary tab"]
["gross cost per day","the total dollar haul cost spent per day on the average (gross scale)","Appr summary tab"]
["hours per day","the average number of hours per day spent hauling logs","Cost defaults tab"]
["HVUT","heavy vehicle use tax (federal on public roads)","O_O cost tab"]
["inflation (inflate)","higher prices as a result of an expanding supply of money","Data input tab, Cost defaults tab, Appr summary tab"]
["ins, tax, lic-%","insurance, taxes, and license percentage (of aai-$)","O_O cost tab"]
["maint & repair","the cost (expressed here as $/mile) of maintaining and repairing equipment","O_O cost tab"]
["mm/dd/yy","date format for input, i.e. 04/10/99","Data Input tab"]
["net cost per day","the total dollar haul cost spent per day on the average (net scale)","Appr summary tab"]
["O and O","owning and operating","O_O cost tab"]
["one-way mileage","average one-way mileage of a truck making a trip: landing to mill or landing to sort yard","Data input tab"]
["opport cost-%","opportunity cost of invested capital (% of aai-$)","O_O cost tab"]
["overhead","materials and services that are necessary to conduct business ","O_O cost tab"]
["overtime (ot)","work preformed in excess of 8 hours","O_O cost tab"]
["puc tax wt-mile","a weight-mile tax imposed by state and/or federal law","Cost defaults tab, O_O cost tab"]
["rtm - average sale (total)","round trip minutes from landing to mill and back to landing (traveling + standing time)","Appr summary tab"]
["rtm - standing","round trip minutes for load, unload, set binders, scaling, etc. (included in total sale rtm's)","Cost defaults tab"]
["rtm - traveling","round trip minutes for traveling from landing to mill and back only (included in total sale rtm's)","Data input tab, Appr summary tab, RTM Calculator tab"]
["salv-%","salvage value of equipment in percent","O_O cost tab"]
["scaling","the measurement of hauled volume, usually on the truck","Data input tab, Cost defaults tab, Appr summary tab"]
["scaling defect","log defect on the truck detected during the scale process (if applicable)","Data input tab"]
["self-loader, stinger-steer","a kind of self-loader usually used in the western US on a stinger-steer truck","Data input tab, Cost defaults tab"]
["sensitivity analysis","the process of changing a variable(s) and its effect on final cost, \"what-if\"","Appr summary tab"]
["standing cost","the sum of ownership and labor costs","O_O cost tab"]
["stinger-steer","a truck-trailer combination commonly used in the western US ","Data input tab"]
["trailer damage","an allowance for damage to the trailer from loading and hauling (% of aai-$)","O_O cost tab"]
["traveling cost","the sum of ownership, labor, and operating costs","O_O cost tab"]

{"sheet":"Help","index":8,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["TRUCKING APPRAISAL - HELP"]
[{"$f":"'Cost defaults'!B2","v":"HaulCost ver 22.0"}]
[]
["The following are brief instructions by worksheet tab or screen (Data Input, Cost Defaults, etc.).  Note that valid inputs can be made"]
["into colored cells or cell dropdown lists.  Use the DELETE key to erase entries.  NEVER USE the SPACE BAR to erase entries. "]
["Cells that could possibly have input or selection, will flash a brief description when selected.  Cells with a \"red dot\" in the upper"]
["right-hand corner contain a comment or information about input requirements (hover the cursor over the \"red dot\" to view info)."]
[]
["The Haul Cost Spreadsheet is organized into a series of screens (or tabs) located at the top of the screen.  The user can"]
["move from tab to tab by left clicking on the tab with the mouse pointer.  The appraisal is built by moving through each tab or screen"]
["from left to right.  Input all necessary data where appropriate.  The results of the appraisal can be found in the Appr Summary tab."]
[]
["Macro Buttons:  These buttons are found in each screen.  They consist of the following: PRINT and DEFAULTS"]
[null,"      (the Defaults Button is found in the Cost Defaults screen only).  The user can"]
[null,"      activate a macro by left clicking on the appropriate button with the mouse.  The PRINT macro will print the"]
[null,"      the current screen.  The DEFAULTS button will restore the original cost defaults used in the Cost Defaults"]
[null,"      screen if overridden.  Use the spreadsheet's menu system to save and quit the program"]
[null,"      (select FILE from the upper menu bar).  The screen may \"flicker\" when the Print macro is launched - this is normal."]
["I.  Data Input Tab"]
[null,"a.  Enter the sale name and date (in mm/dd/yy format) in the colored cells provided."]
[null,"b.  Select the volume type (MBF or CCF) and the geographic area from the cell dropdown lists."]
[null,"c.  Enter traveling round trip minutes (rtm's) from the weighted sale centroid to the mill or appraisal point and back."]
[null,"     This value is normally determined by the engineer doing the road maintenance."]
[null,"d.  Enter the average volume per truck load expressed in net CCF (cunits) or MBF."]
[null,"e.  Indicated whether or not scaling will be done.  Select \"yes\" or \"no\" from the cell dropdown list.  NO SCALING IN R5."]
[null,"f.  Indicate whether the program should inflate the final cost or not.  Select \"yes\" or \"no\" from the cell dropdown list."]
[null,"     See the support tab for the date of the last update to help make this decision.  The inflation rate and the number"]
[null,"     of years to inflate are entered in the Cost Defaults screen or accept defaults.  Input the average cost for diesel fuel"]
[null,"     in the local area in $'s per gallon.  Input to average one-way mileage (landing to mill or landing to sort yard)"]
[null,"g.  Select a truck or truck trailer combination from the cell dropdown list.  The most common configuration in the"]
[null,"     western US is a standard \"stinger-steer\" truck-trailer combination.  If this configuration is selected, a trailer selection"]
[null,"     is not necessary.  If the  \"truck (w/5th wheel)\" is selected, a trailer configuration will be needed (see \"h\" below)."]
[null,"     If any of the other options are selected, the trailer selection is optional."]
[null,"h.  Select a trailer configuration from the cell dropdown list.  A trailer configuration is needed if the transport vehicle"]
[null,"     selected above is a \"tractor (w/5th wheel)\".  If a trailer is not needed, select \"<none>\" or leave blank."]
[null,"i.  Select an attached loader, if needed, from the cell dropdown list.  If an attached loader is not needed, "]
[null,"    select \"<none>\" or leave blank."]
["II.  Cost Defaults Tab"]
[null,"a.  The defaults are shown in the colored cells of the table.  No input is required here unless the user wishes to"]
[null,"     change a particular default.  If a change is desired, over-type the value in the appropriate colored cell and press the"]
[null,"     ENTER key.  If the inflation option was selected, check the \"number of years to inflate\" and the \"inflation rate\""]
[null,"     because the defaults used may be incorrect.  Change if necessary."]
[null,"b.  If scaling was selected, check the defaults for \"scaling cost per CCF or MBF\" and \"scaling defect\".  Change if necessary."]
[null,"c.  The original defaults are shown in the lower table.  If the user wants to restore these defaults, left click on the \"Defaults\""]
[null,"     button next to this table.  Scaling cost is for third party scaling."]
[null,"d.  Check Standing RTM's cell.  Default=65 rtm's (no scaling), 85 rtm's (with scaling).  Change if desired."]
["III.  O_O Cost Tab"]
[null,"a.  This screen displays the values used in the appraisal and the calculation of the owning and operating costs"]
[null,"     associated with the haul machinery.  These cells are protected and should not be changed."]
["IV.  Appr Summary Tab"]
[null,"a.  This screen displays the results of the haul cost appraisal. "]
[null,"b.  The final appraised cost is displayed in the cell below the table.  The appraised value is in dollars per CCF or MBF and"]
[null,"     estimates the cost of hauling logs from the landing to the appraisal point (mill) in terms of scaling or not scaling."]
[null,"c.  Select whether or not to include the scaling cost per unit of measure in the final calculated haul cost by selecting \"Yes\""]
[null,"     or \"No\" from the blue shaded cell dropdown.  Sometimes the scaling cost per unit of measure is included as a separate"]
[null,"     cost item in the overall sale appraisal.  If this is the case, select \"No\" in this cell (avoids double-counting the cost)."]
[null,"d.  Use the \"SCROLL BAR\" to change traveling round trip minutes by one minute increments - use for sensitivity analysis."]
[null,"e.  Launch the \"create text file\" button to create a comma-delimited text file for use in other spreadsheets (i.e. R6-TEA)."]
["V.  RTM Calculator Tab"]
[null,"a.  Use this tool to estimate the traveling Round Trip Minutes (RTM's) by road segment standards."]
["VI.  Definitions Tab"]
[null,"a.  This screen displays the definition of various terms used in the spreadsheet.  Also displayed is the screen tab where"]
[null,"     the term can be found."]
["VII.  Trucks Tab"]
[null,"a.  This screen displays pictures of example truck configurations"]
["VIII.  Trailers Tab"]
[null,"a.  This screen displays pictures of example trailer configurations"]