{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Summary"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Data","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,2,25,6],[1,1,2,7]]}
[]
[null,"Pickup and Trailer Cost Calculator\nTexas Agrilife Extension and Oklahoma State University\n\nDeveloped by\nJames McGrann, Professor Emeritus, Texas A&M University and Christy Waggoner, Former Programmer, Texas A&M University\nUpdate by\nDamona Doye and Roger Sahs, Agricultural Economics, Oklahoma State University\n"]
[]
[]
[null,null,"Ranch Name:",null,null,null,"Date:"]
[null,null,"OK Ranch",null,null,null,{"$f":"NOW()","v":"2016-01-14T10:47:42.090"}]
[null,null,""]
[null,null,null,null,null,"Pickup","Trailer"]
[null,null,"Input Data","Units",null,"Values","Values"]
[]
[null,null,"Current Value","$",null,22000,4000]
[null,null,"Total Miles Used (useful life)","Mile",null,150000,50000]
[null,null,"Current Mileage","Mile",null,40000,30000]
[null,null,"Salvage Value (trade or junk)","$",null,7000,500]
[null,null,"Annual Miles of Use","Mile",null,25000,1000]
[null,null,"Fuel Use (miles per gallon)","Gal.",null,18,6]
[null,null,"Cost of Fuel","$/Gal.",null,2.5,{"$f":"F17","v":2.5}]
[null,null,"Interest Rate on Capital","%",null,5,{"$f":"F18","v":5}]
[null,null,"Monthly Loan Payments (if made)","$",null,0,0]
[null,null,"Annual License & Tax","$",null,120,20]
[null,null,"Annual Insurance","$",null,1250,40]
[null,null,"Tire Cost (per set)","$",null,800,650]
[null,null,"Tire Life in Miles","Mile",null,25000,20000]
[null,null,"Annual Repair & Maintenance Cost","$",null,1000,200]
[]
[null,null,"Calculated Cost for a Trip"]
[]
[null,null,"Input Data","Units",null,"Value"]
[]
[null,null,"Total Miles Traveled for Trip","Miles",null,120]
[null,null,"Total Driver Labor Required","Hr.",null,2]
[null,null,"Driver Labor Cost per Hour","$/Hr.",null,15]
[null,null,"Total Additional Labor Required","Hr.",null,0]
[null,null,"Additional Labor Cost / Hour","$/Hr.",null,0]
[null,null,"Total Number Hauled per Trip","Head",null,10]

{"sheet":"Summary","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,6],[32,1,32,6]]}
[]
[null,"Per Mile and Annual Costs"]
[null," "," "," "," "," "]
[null,null,null,null,"Pickup","Trailer","Combined"]
[null,"Cost Components","Units",null,"Values","Values","Costs"]
[]
[null,"Variable Cost"]
[null,"    Fuel","$/Mi.",null,{"$f":"IF(Data!F16=0,0,Data!F17/Data!F16)*+IF(Data!F15=0,0,1)","v":0.1388888888888889},{"$f":"IF(Data!G16=0,0,Data!G17/Data!G16)*+IF(Data!F15=0,0,1)","v":0.41666666666666669},{"$f":"(E8+F8)","v":0.55555555555555558}]
[null,"    Tires","$/Mi.",null,{"$f":"IF(Data!F23=0,0,Data!F22/Data!F23)*+IF(Data!F15=0,0,1)","v":3.2000000000000001E-2},{"$f":"IF(Data!G23=0,0,Data!G22/Data!G23)*+IF(Data!F15=0,0,1)","v":3.2500000000000001E-2},{"$f":"(E9+F9)","v":6.4500000000000002E-2}]
[null,"    Repair & Maintenance","$/Mi.",null,{"$f":"IF(Data!F15=0,0,Data!F24/Data!F15)","v":0.04},{"$f":"IF(Data!G15=0,0,Data!G24/Data!G15)","v":0.2},{"$f":"(E10+F10)","v":0.24000000000000002}]
[null,null,null,null," -----------"," -----------"," -----------"]
[null,"Total Variable Cost","$/Mi.",null,{"$f":"SUM(E8:E10)","v":0.2108888888888889},{"$f":"SUM(F8:F10)","v":0.64916666666666667},{"$f":"SUM(G8:G10)","v":0.86005555555555557}]
[null,"Annual Variable Cost","$",null,{"$f":"(E12*Data!F15)","v":5272.2222222222226},{"$f":"(F12*Data!G15)","v":649.16666666666663},{"$f":"(E13+F13)","v":5921.3888888888896}]
[]
[null,"Fixed Costs"]
[null,"   License / Tax","$/Mi.",null,{"$f":"IF(Data!F15=0,0,Data!F20/Data!F15)","v":4.7999999999999996E-3},{"$f":"IF(Data!G15=0,0,Data!G20/Data!G15)","v":0.02},{"$f":"(E16+F16)","v":2.4799999999999999E-2}]
[null,"   Insurance","$/Mi.",null,{"$f":"IF(Data!F15=0,0,Data!F21/Data!F15)","v":0.05},{"$f":"IF(Data!G15=0,0,Data!G21/Data!G15)","v":0.04},{"$f":"(E17+F17)","v":0.09}]
[null,"   Interest (non-cash)","$/Mi.",null,{"$f":"IF(OR(Data!F15=0,(Data!F12=Data!F13)),0,(((Data!F11+Data!F14)/2))*Data!F18*0.01/Data!F15)","v":2.9000000000000001E-2},{"$f":"IF(OR(Data!G15=0,(Data!G12=Data!G13)),0,(((Data!G11+Data!G14)/2))*Data!G18*0.01/Data!G15)","v":0.1125},{"$f":"(E18+F18)","v":0.14150000000000001}]
[null,"   Depreciation","$/Mi.",null,{"$f":"IF(OR(Data!F15=0,(Data!F12=Data!F13)),0,((Data!F11-Data!F14)*Data!F15/(Data!F12-Data!F13))/Data!F15)","v":0.13636363636363635},{"$f":"IF(OR(Data!G15=0,(Data!G12=Data!G13)),0,((Data!G11-Data!G14)*Data!G15/(Data!G12-Data!G13))/Data!G15)","v":0.17499999999999999},{"$f":"(E19+F19)","v":0.31136363636363634}]
[null,null,null,null," -----------"," -----------"," -----------"]
[null,"Total Fixed Cost","$/Mi.",null,{"$f":"SUM(E16:E19)","v":0.22016363636363634},{"$f":"SUM(F16:F19)","v":0.34749999999999998},{"$f":"SUM(G16:G19)","v":0.56766363636363637}]
[null,"Total Annual Fixed Cost","$",null,{"$f":"(E21*Data!F15)","v":5504.0909090909081},{"$f":"(F21*Data!G15)","v":347.5},{"$f":"(E22+F22)","v":5851.5909090909081}]
[]
[null,"Total Cost per Mile","$/Mi.",null,{"$f":"IF(Data!F15=0,0,((E13+E22)/Data!F15))","v":0.43105252525252524},{"$f":"IF(Data!G15=0,0,((F13+F22)/Data!G15))","v":0.99666666666666659},{"$f":"(G12+G21)","v":1.4277191919191918}]
[null,"Total Annual Cost","$",null,{"$f":"(E13+E22)","v":10776.313131313131},{"$f":"(F13+F22)","v":996.66666666666663},{"$f":"(E25+F25)","v":11772.979797979797}]
[null,"-","-","-","-","-","-"]
[null,"Total Cash Costs per Mile","$/Mi.",null,{"$f":"IF(Data!F15=0,0,E28/Data!F15)","v":0.26568888888888892},{"$f":"IF(Data!G15=0,0,F28/Data!G15)","v":0.70916666666666661},{"$f":"(E27+F27)","v":0.97485555555555559}]
[null,"Total Cash Costs","$",null,{"$f":"(E13+Data!F19*12+Data!F20+Data!F21)","v":6642.2222222222226},{"$f":"(F13+Data!G19*12+Data!G20+Data!G21)","v":709.16666666666663},{"$f":"(E28+F28)","v":7351.3888888888896}]
[]
[]
[]
[]
[null,"Calculated Cost for a Trip"]
[]
[null,null,null,null,"Per","Per"]
[null,"Cost Components","Units",null,"Trip",{"$f":"+Data!D35","v":"Head"}]
[]
[null,"Total Variable Cost","$",null,{"$f":"(G12*Data!F30+Data!F31*Data!F32+Data!F33*Data!F34)","v":133.20666666666665},{"$f":"IF(Data!F35=0,0,E38/Data!F35)","v":13.320666666666664}]
[null,"Total Fixed Cost","$",null,{"$f":"(G21*Data!F30)","v":68.11963636363636},{"$f":"IF(Data!F35=0,0,E39/Data!F35)","v":6.811963636363636}]
[null,"Total Cost","$",null,{"$f":"SUM(E38:E39)","v":201.326303030303},{"$f":"SUM(F38:F39)","v":20.1326303030303}]
[null,"-","-","-","-","-"]
[null,"Total Cash Cost","$",null,{"$f":"(G27*Data!F30+Data!F31*Data!F32+Data!F33*Data!F34)","v":146.98266666666666},{"$f":"IF(Data!F35=0,0,E42/Data!F35)","v":14.698266666666665}]
[null,"Total Cash Cost","$/Mile",null,{"$f":"E42/Data!F30","v":1.2248555555555556}]