{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Information Sheet","Input Data","Crop Drying Cost Report","Assumptions","Coefficients"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Information Sheet","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,0,16,1],[18,0,18,8],[16,2,16,8],[14,2,14,8],[15,0,15,1],[13,2,13,8],[13,0,13,1],[4,0,4,9],[5,0,5,9],[6,0,6,9],[15,2,15,8],[20,0,22,8],[19,0,19,8],[17,0,17,1],[17,2,17,8],[14,0,14,1],[1,0,1,8],[12,0,12,1],[12,2,12,8],[11,0,11,1],[11,2,11,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
[]
["Guidelines for Estimating"]
["Grain Drying Cost Calculator"]
["Based on Batch or Continuous Flow Dryers"]
[]
[]
[]
[]
["Name of Farmer:  "]
["Mailing Address:  "]
["Phone Number:  "]
["Municipality :  "]
["Date Completed:  "]
["Prepared By:  "]
["Phone Number: "]
[]
[]
["Note:  This budget is only a guide and is not intended  to be an in-depth study of grain drying.  Interpretation and utilization of this information is the responsibility of the user.  If you need help with a budget, contact your local Manitoba Agriculture office. No liability for decisions based on this publication is assumed."]

{"sheet":"Input Data","index":1,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,6],[47,0,47,4],[39,0,40,4],[22,3,23,6],[30,3,31,6],[32,3,32,4],[33,3,33,4],[7,0,7,5],[42,0,42,4],[43,0,43,4],[34,1,34,4],[15,0,15,3],[8,3,12,5],[13,3,13,4],[8,0,13,0],[18,0,18,3],[19,0,19,3],[50,0,50,4],[24,3,24,4],[25,3,25,4],[44,0,44,4],[45,0,45,4],[41,0,41,4],[46,0,46,4],[31,0,34,0],[32,1,33,2],[48,0,48,4],[2,0,2,5],[3,3,4,5],[5,3,5,4],[16,0,16,3],[17,0,17,3],[3,0,5,0],[5,1,5,2],[6,0,6,5],[13,1,13,2],[49,0,49,4],[21,0,21,6],[26,3,26,4],[23,0,27,0],[26,1,26,2],[29,0,29,6],[24,1,25,2],[36,0,36,6],[37,0,38,4],[27,1,27,4]]}
["Crop Drying Cost Report - Input Data"]
[]
["Dryer Type"]
[null,1,"Batch"]
[null,2,"Continuous Flow"]
[null,null,null,"(1 or 2)...",null,2]
[]
["Grain Type"]
[null,1,"Wheat"]
[null,2,"Barley"]
[null,3,"Canola"]
[null,4,"Corn"]
[null,5,"Sunflowers"]
[null,null,null,"(1 to 5)…",null,4]
[]
["Estimated Market Price per Tonne of Crop",null,null,null,null,175," /tonne"]
["Outside Air Temp (Celsius), (at time of drying)",null,null,null,null,0,"deg. Celsius"]
["Temp. of Drying Air (deg. C)",null,null,null,null,100,"deg. Celsius"]
["Initial Moisture Content of Grain (%)",null,null,null,null,22,"%"]
["Final Moisture Content of Grain (%)",null,null,null,null,15.4,"%"]
[]
["Batch Dryers Only"]
["Holding Capacity of Dryer",1,"Cubic Metres"]
[null,2,"Bushels"]
[null,null,null,"(1 or 2)...",null,2]
[null,null,null,"Capacity",null,250,{"$f":"IF(F25=1,\"m3\",\"bu\")","v":"bu"}]
[null,"Capacity in Cubic Metres",null,null,null,{"$f":"IF(F6=2,\"Continuous Flow\",IF(F25=1,F26,IF(F25=2,F26*0.035,0)))","v":"Continuous Flow"},"m3"]
[null,"Hours to Dry a Batch",null,null,null,1.5,"hrs"]
[]
["Continuous Flow Dryers Only"]
["Approx. Drying Rate",1,"Tonnes/Hour"]
[null,2,"Bushels/Hour"]
[null,null,null,"(1 or 2)...",null,2]
[null,null,null,"Drying Rate",null,200,{"$f":"IF(F33=1,\"t/hr\",\"bu/hr\")","v":"bu/hr"}]
[null,"Drying Rate in Tonnes per Hour",null,null,null,{"$f":"IF(F6=1,\"Batch Chosen  \",IF(F33=1,F34,IF(F33=2,F34*VLOOKUP(F14,Coefficients!B5:C10,2),0)))","v":5.08},"t/hr"]
[]
["All Dryers"]
["Electrical Energy Cost ($/kWh)",null,null,null,null,0,"/kwh"]
[null,null,null,null,null,{"$f":"IF(F38=0,0.08527,F38)","v":8.5269999999999999E-2},"/kwh"]
["Cost of Propane ($/L)",null,null,null,null,0,"/litre"]
[null,null,null,null,null,{"$f":"IF(F40=0,0.52,F40)","v":0.52},"/litre"]
["Total Power of Electric Motors on Dryer (HP)",null,null,null,null,15,"HP"]
["Tractor Size Required to Drive Dryer (HP)",null,null,null,null,0,"HP"]
["Labour Charge per Hour",null,null,null,null,22,"/hr"]
["Estimated Hours of Use per Year",null,null,null,null,150,"hrs"]
["Cost of Grain Dryer",null,null,null,null,30000]
["Cost of Auxiliary Equipment (augers, foundations, electrical service, etc.)",null,null,null,null,7500]
["Cost of Surge Bins",null,null,null,null,12000]
["Depreciation rate on dryer",null,null,null,null,10,"%"]
["Depreciation rate on surge bins",null,null,null,null,5,"%"]
["Investment Rate (%)",null,null,null,null,2.75,"%"]
[]
[]
[null,null,{"$f":"IF(F25=1,\"metric\",\"imperial\")","v":"imperial"},{"$f":"IF(F33=1,\"metric\",\"imperial\")","v":"imperial"},null,{"$f":"IF(C54=D54,\"Metric\",\"imperial\")","v":"Metric"}]

{"sheet":"Crop Drying Cost Report","index":2,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[19,0,19,2],[22,0,22,2],[23,0,23,2],[0,0,0,5],[14,0,14,2],[20,0,20,2],[2,3,2,4],[30,0,36,5],[28,0,28,2],[21,0,21,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[25,0,25,2],[24,0,24,2],[26,0,26,2]]}
["Crop Drying Cost Report"]
[]
[null,null,"DRYER TYPE:",{"$f":"IF('Input Data'!F6=0,(\" \"),VLOOKUP('Input Data'!F6,Coefficients!B28:C29,2))","v":"Continuous Flow"}]
[]
[null,null,"GRAIN TYPE:",{"$f":"IF('Input Data'!F14=0,(\" \"),VLOOKUP('Input Data'!F14,Coefficients!F21:G26,2))","v":"Corn"}]
[null,null,"Initial Moisture Content:",{"$f":"('Input Data'!F19)/100","v":0.22}]
[null,null,"Final Moisture Content:",{"$f":"'Input Data'!F20/100","v":0.154}]
[]
[null,null,"DRYING RATE:",{"$f":"IF('Input Data'!F6=1,'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F35,0))","v":5.08},{"$f":"IF('Input Data'!F54=\"metric\",\"Tonne/Hour\",\"Bushels/Hour\")","v":"Tonne/Hour"}]
[null,null,"Drying Temp.:",{"$f":"'Input Data'!F18","v":100}]
[null,null,"Ambient Temp.:",{"$f":"'Input Data'!F17","v":0}]
[]
[]
[]
["OPERATING COSTS",null,null,"Cost/Hour","Cost/Bushel","Cost/Tonne"]
["Repair Costs",null,null,{"$f":"('Input Data'!F46+'Input Data'!F47)*0.00015","v":5.6249999999999991},{"$f":"IF(D16=0,0,F16*VLOOKUP('Input Data'!F14,Coefficients!B32:C37,2))","v":2.8126485078412134E-2},{"$f":"IF(D16=0,0,D16/IF('Input Data'!F6=1,'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F35,0)))","v":1.1072834645669289}]
["Labour",null,null,{"$f":"'Input Data'!F44","v":22},{"$f":"IF(D17=0,0,F17*VLOOKUP('Input Data'!F14,Coefficients!B32:C37,2))","v":0.1100058083066786},{"$f":"IF(D17=0,0,D17/IF('Input Data'!F6=1,'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F35,0)))","v":4.3307086614173231}]
["Power Costs",null,null,{"$f":"'Input Data'!F39*'Input Data'!F42+'Input Data'!F43*0.4286","v":1.27905},{"$f":"IF(D18=0,0,F18*VLOOKUP('Input Data'!F14,Coefficients!B32:C37,2))","v":6.3955876870298743E-3},{"$f":"IF(D18=0,0,D18/IF('Input Data'!F6=1,'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F35,0)))","v":0.25178149606299211}]
["Propane Cost",null,null,{"$f":"IF('Input Data'!F6=1,'Input Data'!F41*VLOOKUP('Input Data'!F14,Coefficients!F5:G10,2)*'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F41*VLOOKUP('Input Data'!F14,Coefficients!F5:G10,2)*'Input Data'!F35,0))","v":47.335489029490617},{"$f":"IF(D19=0,0,F19*VLOOKUP('Input Data'!F14,Coefficients!B32:C37,2))","v":0.23668994237641056},{"$f":"IF(D19=0,0,D19/IF('Input Data'!F6=1,'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F35,0)))","v":9.3180096514745312}]
["TOTAL OPERATING COSTS",null,null,{"$f":"SUM(D16:D19)","v":76.239539029490615},{"$f":"SUM(E16:E19)","v":0.38121782344853117},{"$f":"SUM(F16:F19)","v":15.007783273521774}]
[]
["FIXED COSTS"]
["Depreciation",null,null,{"$f":"IF('Input Data'!F45=0,0,(('Input Data'!F46+'Input Data'!F47)*'Input Data'!F49/100+'Input Data'!F48*'Input Data'!F50/100)/'Input Data'!F45)","v":29},{"$f":"IF(D23=0,0,F23*VLOOKUP('Input Data'!F14,Coefficients!B32:C36,2))","v":0.14500765640425814},{"$f":"IF(D23=0,0,D23/IF('Input Data'!F6=1,'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F35,0)))","v":5.7086614173228343}]
["Investment Cost",null,null,{"$f":"IF('Input Data'!F45=0,0,(0.6*('Input Data'!F46+'Input Data'!F47+'Input Data'!F48))*'Input Data'!F51/100/'Input Data'!F45)","v":5.4450000000000003},{"$f":"IF(D24=0,0,F24*VLOOKUP('Input Data'!F14,Coefficients!B32:C36,2))","v":2.7226437555902955E-2},{"$f":"IF(D24=0,0,D24/IF('Input Data'!F6=1,'Input Data'!F27*VLOOKUP('Input Data'!F14,Coefficients!F13:G17,2)/'Input Data'!F28,IF('Input Data'!F6=2,'Input Data'!F35,0)))","v":1.0718503937007875}]
["TOTAL FIXED COSTS",null,null,{"$f":"SUM(D23:D24)","v":34.445},{"$f":"SUM(E23:E24)","v":0.17223409396016109},{"$f":"SUM(F23:F24)","v":6.7805118110236222}]
[]
["TOTAL COSTS",null,null,{"$f":"D20+D25","v":110.68453902949062},{"$f":"E20+E25","v":0.55345191740869226},{"$f":"F20+F25","v":21.788295084545396}]
[]
["Total Overdrying Cost",null,null,null,{"$f":"IF(D27=0,0,F29*VLOOKUP('Input Data'!F14,Coefficients!B32:C36,2))","v":5.3342816500711043E-3},{"$f":"IF('Input Data'!F14=0,(\" \"),(VLOOKUP('Input Data'!F14,Coefficients!H21:I25,2)-'Input Data'!F20)*1.2*'Input Data'!F16/100)","v":0.20999999999999924}]
[]
["Note:  This budget is only a guide and is not intended  to be an in-depth study of grain drying.  Interpretation and utilization of this information is the responsibility of the user.  If you need help with a budget, contact your local Manitoba Agriculture office. No liability for decisions based on this publication is assumed."]

{"sheet":"Assumptions","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7],[3,1,3,3],[5,2,5,6],[7,2,7,6],[9,2,9,6],[20,2,20,6],[13,2,13,6],[18,2,18,6],[15,2,15,6],[16,4,16,6],[11,2,11,6]]}
["Crop Drying Cost Report - Assumptions"]
[]
[]
[null,"ASSUMPTIONS:"]
[]
[null,1,"Fuel consumptions based on PAMI test reports and CSAE paper 84-211 \"Heated Air Grain Dryer Performance\"."]
[]
[null,2,{"$f":"\"Default value for electrical cost = $\"&'Input Data'!F39&\"/kWh which is the present runoff rate.\"","v":"Default value for electrical cost = $0.08527/kWh which is the present runoff rate."}]
[]
[null,3,{"$f":"\"Default value for propane cost = $\"&'Input Data'!F41&\"/Litre.\"","v":"Default value for propane cost = $0.52/Litre."}]
[]
[null,4,"Hourly repair rate is 1.5% of new cost per 100 hours of use."]
[]
[null,5,"Tractor cost used is $0.4286/HPh) which includes fuel but no markup."]
[]
[null,6,{"$f":"\"Depreciation Rate used - \"&'Input Data'!F49&\"% on dryer\"","v":"Depreciation Rate used - 10% on dryer"}]
[null,null,null,"-",{"$f":"'Input Data'!F50&\"% on surge bins.\"","v":"5% on surge bins."}]
[]
[null,7,"Investment Cost includes 20% salvage value."]
[]
[null,null,"Note:  Fuel consumptions on individual dryers may vary as much as 25% from the averages used in this program. See individual PAMI test reports for comparisons between dryers."]

{"sheet":"Coefficients","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,9],[19,1,19,8],[27,2,27,4],[28,2,28,4],[3,1,3,2],[3,3,3,4],[3,5,3,6],[11,1,11,6]]}
["Crop Drying Cost Report - Coefficients"]
[]
[]
[null,"Drying Rate",null,"Basic Fuel Consumption",null,"FUEL CONSUMPTION"]
[null,1,2.7199999999999998E-2,1,{"$f":"IF('Input Data'!F6=1,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*355/('Input Data'!F18+273)*11.4,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*363/('Input Data'!F18+273)*10.5)","v":11.35388739946381},1,{"$f":"IF('Input Data'!F19>=19.5,E5+0.19*E5*('Input Data'!F19-19.5)+0.2*E5*(14.5-'Input Data'!F20),E5+0.16*E5*('Input Data'!F19-19.5)+0.2*E5*(14.5-'Input Data'!F20))","v":14.703284182305634}]
[null,2,2.18E-2,2,{"$f":"IF('Input Data'!F6=1,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*363/('Input Data'!F18+273)*11.3,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*353/('Input Data'!F18+273)*10.8)","v":11.35656836461126},2,{"$f":"IF('Input Data'!F19>=19.8,E6+0.19*E6*('Input Data'!F19-19.8)+0.2*E6*(14.8-'Input Data'!F20),E6+0.16*E6*('Input Data'!F19-19.8)+0.2*E6*(14.8-'Input Data'!F20))","v":14.740825737265414}]
[null,3,2.2700000000000001E-2,3,{"$f":"IF('Input Data'!F6=1,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*345/('Input Data'!F18+273)*10.2,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*335/('Input Data'!F18+273)*9)","v":8.9812332439678286},3,{"$f":"IF('Input Data'!F19>=15,E7+0.19*E7*('Input Data'!F19-15)+0.2*E7*(10-'Input Data'!F20),E7+0.16*E7*('Input Data'!F19-15)+0.2*E7*(10-'Input Data'!F20))","v":11.226541554959786}]
[null,4,2.5399999999999999E-2,4,{"$f":"IF('Input Data'!F6=1,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*385/('Input Data'!F18+273)*22,('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*378/('Input Data'!F18+273)*21.8)","v":24.546916890080432},4,{"$f":"IF('Input Data'!F19>=25.5,E8+0.095*E8*('Input Data'!F19-25.5)+0.1*E8*(15.5-'Input Data'!F20),E8+0.08*E8*('Input Data'!F19-25.5)+0.1*E8*(15.5-'Input Data'!F20))","v":17.919249329758713}]
[null,5,1.0200000000000001E-2,5,{"$f":"('Input Data'!F18-'Input Data'!F17)/('Input Data'!F18-10)*353/('Input Data'!F18+273)*('Input Data'!F19-'Input Data'!F20)*2.3","v":15.962287756925823},5,{"$f":"E9","v":15.962287756925823}]
[null,6,null,6,null,6]
[]
[null,"Initial M.C. Range"]
[null,1,{"$f":"(\"17 % \")","v":"17 % "},1,{"$f":"(\"- 25 %\")","v":"- 25 %"},1,0.77]
[null,2,{"$f":"(\"17 % \")","v":"17 % "},2,{"$f":"(\"- 25 %\")","v":"- 25 %"},2,0.62]
[null,3,{"$f":"(\"12 % \")","v":"12 % "},3,{"$f":"(\"- 20 %\")","v":"- 20 %"},3,0.64]
[null,4,{"$f":"(\"18 % \")","v":"18 % "},4,{"$f":"(\"- 32 %\")","v":"- 32 %"},4,0.7]
[null,5,{"$f":"(\"12 % \")","v":"12 % "},5,{"$f":"(\"- 20 %\")","v":"- 20 %"},5,0.28999999999999998]
[null,6,null,6,null,6]
[]
[null,"Final M.C. Range"]
[null,1,{"$f":"(\"13 % \")","v":"13 % "},1,{"$f":"(\"- 14.5 %\")","v":"- 14.5 %"},1,{"$f":"(\"Wheat\")","v":"Wheat"},1,14.5]
[null,2,{"$f":"(\"13.3 % \")","v":"13.3 % "},2,{"$f":"(\"- 14.8 %\")","v":"- 14.8 %"},2,{"$f":"(\"Barley\")","v":"Barley"},2,14.8]
[null,3,{"$f":"(\"8.5 % \")","v":"8.5 % "},3,{"$f":"(\"- 10 %\")","v":"- 10 %"},3,{"$f":"(\"Canola\")","v":"Canola"},3,10]
[null,4,{"$f":"(\"14 % \")","v":"14 % "},4,{"$f":"(\"- 15.5 %\")","v":"- 15.5 %"},4,{"$f":"(\"Corn\")","v":"Corn"},4,15.5]
[null,5,{"$f":"(\"8 % \")","v":"8 % "},5,{"$f":"(\"- 9.5 %\")","v":"- 9.5 %"},5,{"$f":"(\"Sunflower\")","v":"Sunflower"},5,9.5]
[null,6,null,6,null,6,"Flax",6]
[]
[null,1,{"$f":"(\"Batch\")","v":"Batch"}]
[null,2,{"$f":"(\"Continuous Flow\")","v":"Continuous Flow"}]
[]
[]
[null,1,{"$f":"1/36.743","v":2.7216068366763737E-2}]
[null,2,{"$f":"1/45.929","v":2.1772736179755708E-2}]
[null,3,{"$f":"1/44.092","v":2.2679851220175996E-2}]
[null,4,{"$f":"1/39.368","v":2.5401341190814875E-2}]
[null,5,{"$f":"1/73.487","v":1.3607849007307415E-2}]
[null,6]