{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["IrrigationEnergy","Irr energy costs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":4,"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":"IrrigationEnergy","index":0,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,1,53,10],[4,1,5,9],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[27,1,27,4],[28,1,28,11],[29,1,31,11],[35,1,37,11],[39,1,39,5],[48,1,48,5]]}
[]
[]
[null,"KSU-Irrigation Energy Costs"]
[]
[null,"A spreadsheet to compare the costs of irrigation energy options"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 5.23.2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly. "]
[null,"In the spreadsheet all blue numbers are inputs and all black numbers are calculated from these inputs.  Several of the input cells (i.e., blue number) have a red diamond in the upper right hand corner of the cell.  By moving your mouse cursor over this diamond, a brief description of the input will be displayed on the screen."]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"This spreadsheet is based on the publication \"Developing a Spreadsheet Template for Comparing Irrigation Energy Costs\" (AF-161) by David A. Pacey and Freddie R. Lamm.  In addition, K-State Farm Management Guide crop budgets and other useful information is available via the K-State Agricultural Economics website (www.agmanager.info)."]
[]
[]
[]
[null,"With Questions contact:"]
[null,"Terry Griffin"]
[null,"Agricultural Economist"]
[null,"Department of Agricultural Economics"]
[null,"Kansas State University"]
[null,"twgriffin@k-state.edu"]
[null,"785-532-3527"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"This spreadsheet was originally developed by: "]
[null,"Kevin C. Dhuyvetter, Ph.D.",null,null,null,null,null,"Troy Dumler"]
[null,"Former Extension Agricultural Economist",null,null,null,null,null,"Former Extension Agricultural Economist"]
[null,"Department of Agricultural Economics",null,null,null,null,null,"Department of Agricultural Economics"]
[null,"Kansas State University",null,null,null,null,null,"Kansas State University"]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Irr energy costs","index":1,"n_rows":71,"n_cols":14,"rows_kept":71,"cut":false,"hidden":false,"merged":[[22,3,22,9],[35,3,35,9],[48,3,48,9],[12,12,18,14],[6,12,7,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[61,3,61,9],[24,3,24,9],[37,3,37,9],[50,3,50,9],[63,3,63,9]]}
[]
[null,"IRRIGATION ENERGY COST COMPARISON"]
[]
[null,"Compares energy costs of irrigation pumping with different fuels at various prices and levels of"]
[null,"performance.  % NPPPC is percent of Nebraska Pumping Plant Performance Criteria."]
[]
[null,"-INPUT------",null,null,null,null,null,null,null,null,null,null,"Nebraska Pumping Plant Performance Criteria*"]
[null,null,"Acres",null,1,"  Electric:",null,0.08,"$/kWh",90,"% NPPPC"]
[null,null,"Inches Applied",null,1,"  Nat. Gas:",null,6,"$/mcf",90,"% NPPPC",null,0.88500000000000001," whp-hr/kWh Electricity"]
[null,null,"Feet Lift",null,300,"  Diesel:",null,1.1000000000000001,"$/gal",90,"% NPPPC",null,61.7," whp-hr/mcf Natural Gas"]
[null,null,"PSI Pressure",null,20,"  Propane:",null,0.9,"$/gal",90,"% NPPPC",null,12.5," whp-hr/gal Diesel"]
[null,"-OUTPUT-----",null,null,null,null,null,null,null,null,null,null,6.89," whp-hr/gal Propane"]
[null,null,"Energy",null,"Energy ","Energy",null,"  ----- Cost as percent of: -----",null,null,null,null,"* These factors represent what a well-designed and maintained irrigation pumping plant should be capable of doing (i.e., work done per unit of fuel) based on the Nebraska Pumping Plant Performance Criteria (NPPPC)."]
[null,null,"Source",null,"Cost ($)","Use ",null,"Elec.","Nat. Gas","Diesel","Propane"]
[]
[null,{"$f":"LEFT(C16,4)&\"-\"&FIXED(H8,3,TRUE)&\" \"&I8","v":"Elec-0.080 $/kWh"},"Electricity",null,{"$f":"M$22*H8*E$8*(E$10+M$23*E$11)*E$9/(M9*J8)","v":3.9779314500941618},{"$f":"E16/H8","v":49.724143126177019},"kWh",{"$f":"E16/E$16","v":1},{"$f":"E16/E$17","v":0.92956685499058378},{"$f":"E16/E$18","v":1.027221366204417},{"$f":"E16/E$19","v":0.69202762084118019}]
[null,{"$f":"LEFT(C17,3)&\" \"&RIGHT(C17,3)&\"-\"&FIXED(H9,2,TRUE)&\" \"&I9","v":"Nat Gas-6.00 $/mcf"},"Natural Gas",null,{"$f":"M$22*H9*E$8*(E$10+M$23*E$11)*E$9/(M10*J9)","v":4.2793387358184765},{"$f":"E17/H9","v":0.71322312263641274},"mcf",{"$f":"E17/E$16","v":1.0757698541329013},{"$f":"E17/E$17","v":1},{"$f":"E17/E$18","v":1.1050537792839252},{"$f":"E17/E$19","v":0.74446245272825506}]
[null,{"$f":"LEFT(C18,6)&\"-\"&FIXED(H10,2,TRUE)&\" \"&I10","v":"Diesel-1.10 $/gal"},"Diesel",null,{"$f":"M$22*H10*E$8*(E$10+M$23*E$11)*E$9/(M11*J10)","v":3.8725162666666666},{"$f":"E18/H10","v":3.5204693333333328},"gal",{"$f":"E18/E$16","v":0.97350000000000003},{"$f":"E18/E$17","v":0.90493333333333337},{"$f":"E18/E$18","v":1},{"$f":"E18/E$19","v":0.67368888888888889}]
[null,{"$f":"LEFT(C19,4)&\"-\"&FIXED(H11,2,TRUE)&\" \"&I11","v":"Prop-0.90 $/gal"},"Propane",null,{"$f":"M$22*H11*E$8*(E$10+M$23*E$11)*E$9/(M12*J11)","v":5.7482264150943392},{"$f":"E19/H11","v":6.3869182389937098},"gal",{"$f":"E19/E$16","v":1.4450290275761972},{"$f":"E19/E$17","v":1.3432510885341074},{"$f":"E19/E$18","v":1.4843646919118616},{"$f":"E19/E$19","v":1}]
[]
[]
[null,"ENERGY PUMPING COST/ACRE WITH ELECTRICITY",null,null,null,null,null,null,null,null,null,null,{"$f":"(M24*M25*M26)/(M27*M28*M29)","v":11.44},"conversion factor"]
[null,null,null,"Pressure (PSI)",null,null,null,null,null,null,null,null,2.31,"TDH/lb of psi"]
[null,null,null,5,{"$f":"D24+10","v":15},25,35,45,55,65,null,null,43560,"square feet per acre"]
[null,null,"$/kWh","-------- Energy Cost ($/Acre) --------",null,null,null,null,null,null,null,null,62.4,"pounds/cubic foot water"]
[null,null,{"$f":"C28-0.02","v":0.05},{"$f":"$M$22*$C26*($E$10+$M$23*D$24)*$E$9/($M$9*$J$8)","v":2.2373709981167602},2.4032617702448205,2.5691525423728812,2.7350433145009414,2.9009340866290017,3.0668248587570619,3.2327156308851221,null,null,100,"percent"]
[null,null,{"$f":"C28-0.01","v":6.0000000000000005E-2},2.6848451977401129,2.8839141242937849,3.0829830508474578,3.2820519774011303,3.4811209039548019,3.6801898305084744,3.8792587570621464,null,null,12,"inch/foot"]
[null,null,{"$f":"C29-0.01","v":7.0000000000000007E-2},3.1323193973634651,3.3645664783427498,3.5968135593220336,3.8290606403013183,4.0613077212806026,4.2935548022598873,4.5258018832391711,null,null,33000,"foot pound/minute-hp"]
[null,null,{"$f":"H8","v":0.08},3.5797935969868173,3.8452188323917134,4.1106440677966098,4.3760693032015068,4.6414945386064028,4.9069197740112989,5.1723450094161958,null,null,60,"minutes/hour"]
[null,null,{"$f":"C28+0.02","v":9.0000000000000011E-2},4.0272677966101691,4.3258711864406774,4.6244745762711865,4.9230779661016948,5.2216813559322031,5.5202847457627122,5.8188881355932205]
[null,null,{"$f":"C28+0.03","v":0.1},4.4747419962335204,4.8065235404896409,5.1383050847457623,5.4700866290018828,5.8018681732580033,6.1336497175141238,6.4654312617702443]
[null,null,{"$f":"C28+0.04","v":0.11000000000000001},4.9222161958568744,5.2871758945386071,5.6521355932203399,6.0170952919020726,6.3820549905838044,6.747014689265538,7.1119743879472699]
[]
[]
[null,"ENERGY PUMPING COST/ACRE WITH NATURAL GAS"]
[null,null,null,"Pressure (PSI)"]
[null,null,null,{"$f":"D$24","v":5},{"$f":"D37+10","v":15},25,35,45,55,65]
[null,null,"$/mcf","-------- Energy Cost ($/Acre) --------"]
[null,null,{"$f":"C41-0.5","v":5.25},{"$f":"$M$22*$C39*($E$10+$M$23*D$37)*$E$9/($M$10*$J$9)","v":3.3696547811993516},3.6194991896272279,3.8693435980551047,4.1191880064829816,4.3690324149108584,4.6188768233387361,4.868721231766612]
[null,null,{"$f":"C41-0.25","v":5.5},3.5301145326850349,3.791856293895191,4.0535980551053479,4.3153398163155048,4.5770815775256608,4.8388233387358177,5.1005650999459746]
[null,null,{"$f":"C42-0.25","v":5.75},3.6905742841707188,3.9642133981631549,4.2378525121555919,4.511491626148028,4.7851307401404641,5.0587698541329011,5.3324089681253373]
[null,null,{"$f":"H9","v":6},3.8510340356564021,4.1365705024311188,4.4221069692058341,4.7076434359805512,4.9931799027552675,5.2787163695299837,5.5642528363046999]
[null,null,{"$f":"C41+0.5","v":6.25},4.0114937871420855,4.3089276066990809,4.6063614262560781,4.9037952458130745,5.2012290653700699,5.4986628849270662,5.7960967044840626]
[null,null,{"$f":"C41+0.75","v":6.5},4.1719535386277684,4.4812847109670439,4.7906158833063213,5.0999470556455968,5.4092782279848723,5.7186094003241497,6.0279405726634243]
[null,null,{"$f":"C41+1","v":6.75},4.3324132901134522,4.6536418152350079,4.9748703403565635,5.29609886547812,5.6173273905996757,5.9385559157212313,6.2597844408427878]
[]
[]
[null,"ENERGY PUMPING COST/ACRE WITH DIESEL"]
[null,null,null,"Pressure (PSI)"]
[null,null,null,{"$f":"D$24","v":5},{"$f":"D50+10","v":15},25,35,45,55,65]
[null,null,"$/gal","-------- Energy Cost ($/Acre) --------"]
[null,null,{"$f":"C54-0.3","v":0.65000000000000013},{"$f":"$M$22*$C52*($E$10+$M$23*D$50)*$E$9/($M$11*$J$10)","v":2.0592762666666666},2.2119621333333335,2.3646480000000003,2.5173338666666671,2.6700197333333335,2.8227056000000004,2.9753914666666672]
[null,null,{"$f":"C54-0.15","v":0.8},2.5344938666666663,2.722414933333333,2.9103359999999996,3.0982570666666662,3.2861781333333329,3.4740991999999999,3.6620202666666666]
[null,null,{"$f":"C55-0.15","v":0.95000000000000007},3.0097114666666669,3.2328677333333333,3.4560240000000002,3.6791802666666666,3.9023365333333335,4.1254928,4.3486490666666668]
[null,null,{"$f":"H10","v":1.1000000000000001},3.4849290666666666,3.7433205333333333,4.0017119999999995,4.2601034666666662,4.5184949333333329,4.7768863999999995,5.0352778666666662]
[null,null,{"$f":"C54+0.3","v":1.25},3.9601466666666667,4.2537733333333323,4.5473999999999997,4.8410266666666661,5.1346533333333326,5.42828,5.7219066666666665]
[null,null,{"$f":"C54+0.45","v":1.4000000000000001},4.4353642666666673,4.7642261333333336,5.0930880000000007,5.4219498666666679,5.7508117333333342,6.0796736000000013,6.4085354666666676]
[null,null,{"$f":"C54+0.6","v":1.55},4.910581866666667,5.274678933333333,5.638776,6.002873066666667,6.3669701333333331,6.7310672,7.0951642666666661]
[]
[]
[null,"ENERGY PUMPING COST/ACRE WITH PROPANE"]
[null,null,null,"Pressure (PSI)"]
[null,null,null,{"$f":"D$24","v":5},{"$f":"D63+10","v":15},25,35,45,55,65]
[null,null,"$/gal","-------- Energy Cost ($/Acre) --------"]
[null,null,{"$f":"C67-0.2","v":0.60000000000000009},{"$f":"$M$22*$C65*($E$10+$M$23*D$63)*$E$9/($M$12*$J$11)","v":3.4486037735849058},3.7043018867924529,3.9600000000000004,4.2156981132075479,4.4713962264150942,4.7270943396226421,4.9827924528301883]
[null,null,{"$f":"C67-0.1","v":0.70000000000000007},4.0233710691823905,4.3216855345911949,4.620000000000001,4.9183144654088062,5.2166289308176106,5.5149433962264158,5.8132578616352202]
[null,null,{"$f":"C68-0.1","v":0.8},4.5981383647798735,4.9390691823899369,5.2799999999999994,5.6209308176100619,5.9618616352201252,6.3027924528301877,6.6437232704402511]
[null,null,{"$f":"H11","v":0.9},5.1729056603773582,5.556452830188678,5.9399999999999995,6.323547169811321,6.7070943396226408,7.0906415094339614,7.4741886792452821]
[null,null,{"$f":"C67+0.2","v":1},5.747672955974843,6.1738364779874209,6.6,7.0261635220125784,7.4523270440251572,7.878490566037736,8.304654088050313]
[null,null,{"$f":"C67+0.3","v":1.1000000000000001},6.3224402515723268,6.7912201257861629,7.2599999999999989,7.7287798742138358,8.1975597484276719,8.6663396226415088,9.135119496855344]
[null,null,{"$f":"C67+0.4","v":1.2000000000000002},6.8972075471698115,7.4086037735849057,7.9200000000000008,8.4313962264150959,8.9427924528301883,9.4541886792452843,9.9655849056603767]