{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Help and Instructions","Fertilizer Optimization"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":107,"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":"Help and Instructions","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This excel workbook must have the macro features and Solver Add-Ins enabled  to function."]
[]
[null,"Steps required to enable macro features:"]
[null,"1) Locate the Security Warning for the spreadsheet underneath the excel toolbar."]
[null,"2) Click on the options button near the security warning."]
[null,"3) After clicking options, the Security Alert - Macro will appear, next click Enable this content and select Ok."]
[]
[null,"Steps required to enable Solver Add-Inns:"]
[null,"1) Click the Office 2007 round icon (or File in Office 2010) and select Excel Options."]
[null,"2) Select the Add-Ins Tab and select Go."]
[null,"3) When the Add-Ins window appears, selected the Solver Add-In checkbox and click ok. "]

{"sheet":"Fertilizer Optimization","index":1,"n_rows":88,"n_cols":30,"rows_kept":88,"cut":false,"hidden":false,"merged":[[74,1,74,8],[57,18,57,21],[57,22,57,23],[57,24,57,25],[9,2,9,3],[11,2,11,3],[10,2,10,3],[23,1,23,5],[15,24,15,26],[49,22,49,23],[43,13,43,20],[57,11,57,17],[72,1,72,8],[13,1,13,3],[32,1,32,2],[34,1,34,2],[70,1,70,8],[29,27,29,29],[29,14,29,18],[29,19,29,26],[15,13,15,23],[29,11,29,13],[41,2,41,6],[40,1,40,6],[60,1,60,3],[51,1,51,3],[68,1,68,8],[61,2,61,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer",null,"Abbreviation","Nitrogen","Phosphorous","Potassium","Price/kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Urea",null,"Urea",{"$f":"IF(OR(C26=0,C26=\"%\"),0,C26)","v":0.46},{"$f":"IF(OR(D26=0,D26=\"%\"),0,D26*0.437)","v":0},{"$f":"IF(OR(E26=0,E26=\"%\"),0,E26*0.83)","v":0},{"$f":"IF(F26<=0,0,(F26/50))","v":0}]
[null,"Producer Name:","xxx",null,null,null,null,null,null,null,null,null,null,"Triple Super Phosphate",null,"TSP",{"$f":"IF(OR(C27=0,C27=\"%\"),0,C27)","v":0},{"$f":"IF(OR(D27=0,D27=\"%\"),0,D27*0.437)","v":0.20102},{"$f":"IF(OR(E27=0,E27=\"%\"),0,E27*0.83)","v":0},{"$f":"IF(F27<=0,0,(F27/50))","v":0}]
[null,"Prepared By:","xxx",null,null,null,null,null,null,null,null,null,null,"Diammonium Phosphate",null,"DAP",0.18,{"$f":"IF(OR(D28=0,D28=\"%\"),0,D28*0.437)","v":0.20102},{"$f":"IF(OR(E28=0,E28=\"%\"),0,E28*0.83)","v":0},{"$f":"IF(F28<=0,0,(F28/50))","v":0}]
[null,"Date Prepared:",{"$f":"TODAY()","v":"2013-06-21"},null,null,null,null,null,null,null,null,null,null,"Murate of Potash",null,"KCl",0,{"$f":"IF(OR(D29=0,D29=\"%\"),0,D29*0.437)","v":0},{"$f":"IF(OR(E29=0,E29=\"%\"),0,E29*0.83)","v":0.49799999999999994},{"$f":"IF(F29<=0,0,(F29/50))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B30","v":"xxx"},null,{"$f":"LEFT(N13,4)","v":"xxx"},0,{"$f":"IF(OR(D30=0,D30=\"%\"),0,D30*0.437)","v":0},{"$f":"IF(OR(E30=0,E30=\"%\"),0,E30*0.83)","v":0},{"$f":"IF(F30<=0,0,(F30/50))","v":0}]
[null,"Crop Selection and Prices"]
[null,"Crop","Area Planted \n(Ha)*","Expected \nGrain Value/kg †"]
[null,"Maize",0,0,null,null,null,null,null,null,null,null,null,"Fertilizer Constraints ",null,null,null,null,null,null,null,null,null,null,"Fertilizer Total Maxes"]
[null,"Sorghum",0,0,null,null,null,null,null,null,null,null,null,"Crop","Urea Min","TSP Min","DAP Min","KCl Min",{"$f":"P13&\" Min\"","v":"xxx Min"},"Urea Max","TSP Max","DAP Max","KCl Max",{"$f":"P13&\" Max\"","v":"xxx Max"},"N Sum","P Sum","K Sum"]
[null,"Upland rice, paddy",0,0,null,null,null,null,null,null,null,null,null,"Maize",0,0,0,0,0,{"$f":"IF($F$26<=0,0,100)","v":0},{"$f":"IF($F$27<=0,0,50)","v":0},{"$f":"IF($F$28<=0,0,50)","v":0},0,{"$f":"IF($F$30<=0,0,200)","v":0},46,10,15]
[null,"Beans",0,0,null,null,null,null,null,null,null,null,null,"Sorghum",0,0,0,0,0,{"$f":"IF($F$26<=0,0,100)","v":0},{"$f":"IF($F$27<=0,0,50)","v":0},{"$f":"IF($F$28<=0,0,50)","v":0},0,0,46,10,15]
[null,"Soybeans",0,0,null,null,null,null,null,null,null,null,null,"Upland rice, paddy",0,0,0,0,0,{"$f":"IF($F$26<=0,0,200)","v":0},{"$f":"IF($F$27<=0,0,150)","v":0},{"$f":"IF($F$28<=0,0,150)","v":0},0,0,92,30,15]
[null,"Groundnuts, unshelled",0,0,null,null,null,null,null,null,null,null,null,"Beans",0,0,0,0,0,0,{"$f":"IF($F$27<=0,0,120)","v":0},{"$f":"IF($F$28<=0,0,120)","v":0},0,0,46,25,15]
[null,"Total hectares",{"$f":"SUM(C16:C21)","v":0},null,null,null,null,null,null,null,null,null,null,"Soybeans",0,0,0,0,0,0,{"$f":"IF($F$27<=0,0,150)","v":0},0,{"$f":"IF($F$29<=0,0,100)","v":0},0,15,30,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground nuts, unshelled",0,0,0,0,0,0,{"$f":"IF($F$27<=0,0,175)","v":0},0,{"$f":"IF($F$29<=0,0,100)","v":0},0,15,35,50]
[null,"Fertilizer Selection and Prices"]
[null,"Fertilizer Product","N","P2O5","K2O","Price/50 kg bag ¶*"]
[null,"Urea",0.46,0,0,0]
[null,"Triple super phosphate, TSP",0,0.46,0,0]
[null,"Diammonium phosphate, DAP",0.18,0.46,0,0]
[null,"Murate of potash, KCL",0,0,0.6,0]
[null,"xxx","%","%","%",0,null,null,null,null,null,"Area Planted and Price",null,null,"Fertilizer Amount",null,null,null,null,"Fertilizer Units Applied/Ha",null,null,null,null,null,null,null,"Fertilizer Totals"]
[null,null,null,null,null,null,null,null,null,null,null,"Crop","Ha Planted","Value/kg","Urea kg ","TSP kg ","DAP kg ","KCl kg ",{"$f":"P13&\" kg\"","v":"xxx kg"},"Urea kg (N)","TSP kg (P)","DAP kg (N)","DAP kg (P)","KCl kg (K)",{"$f":"P13& \" kg (N)\"","v":"xxx kg (N)"},{"$f":"P13&\" kg (P)\"","v":"xxx kg (P)"},{"$f":"P13&\" kg (K)\"","v":"xxx kg (K)"},"N Sum","P Sum","K Sum"]
[null,null,null,null,null,null,null,null,null,null,null,"Maize",{"$f":"C16","v":0},{"$f":"IF(D16<=0,0,D16)","v":0},0,0,0,0,0,{"$f":"IF(M32<=0,0,O32*$Q$9)","v":0},{"$f":"IF(M32<=0,0,P32*$R$10)","v":0},{"$f":"IF(M32<=0,0,Q32*$Q$11)","v":0},{"$f":"IF(M32<=0,0,Q32*$R$11)","v":0},{"$f":"IF(M32<=0,0,R32*$S$12)","v":0},{"$f":"IF(OR(M32<=0,$C$30=0,$C$30=\"%\"),0,S32*$Q$13)","v":0},{"$f":"IF(OR(M32<=0,$D$30=0,$D$30=\"%\"),0,S32*$R$13)","v":0},{"$f":"IF(OR(M32<=0,$E$30=0,$E$30=\"%\"),0,S32*$S$13)","v":0},{"$f":"T32+V32+Y32","v":0},{"$f":"U32+W32+Z32","v":0},{"$f":"X32+AA32","v":0}]
[null,"Budget Constraint",null,null,null,null,null,null,null,null,null,"Sorghum",0,0,0,0,0,0,0,{"$f":"IF(M33<=0,0,O33*$Q$9)","v":0},{"$f":"IF(M33<=0,0,P33*$R$10)","v":0},{"$f":"IF(M33<=0,0,Q33*$Q$11)","v":0},{"$f":"IF(M33<=0,0,Q33*$R$11)","v":0},{"$f":"IF(M33<=0,0,R33*$S$12)","v":0},{"$f":"IF(OR(M33<=0,$C$30=0,$C$30=\"%\"),0,S33*$Q$13)","v":0},{"$f":"IF(OR(M33<=0,$D$30=0,$D$30=\"%\"),0,S33*$R$13)","v":0},{"$f":"IF(OR(M33<=0,$E$30=0,$E$30=\"%\"),0,S33*$S$13)","v":0},0,0,{"$f":"X33+AA33","v":0}]
[null,"Amount available to invest in fertilizer",0,null,null,null,null,null,null,null,null,"Upland rice, paddy",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Beans",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Soybeans",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Groundnuts, unshelled",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(M32:M37)","v":0},null,{"$f":"SUM(O32:O37)","v":0},{"$f":"SUM(P32:P37)","v":0},{"$f":"SUM(Q32:Q37)","v":0},0,{"$f":"SUM(S32:S37)","v":0},{"$f":"SUM(T32:T37)","v":0},{"$f":"SUM(U32:U37)","v":0},0,0,0,{"$f":"SUM(Y32:Y37)","v":0},{"$f":"SUM(Z32:Z37)","v":0},{"$f":"SUM(AA32:AA37)","v":0},{"$f":"SUM(AB32:AB37)","v":0},{"$f":"SUM(AC32:AC37)","v":0},{"$f":"SUM(AD32:AD37)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total fertilizer needed",{"$f":"$M$32*O32+$M$33*O33+$M$34*O34+$M$35*O35+$M$36*O36+$M$37*O37","v":0},{"$f":"$M$32*P32+$M$33*P33+$M$34*P34+$M$35*P35+$M$36*P36+$M$37*P37","v":0},0,0,0]
[]
[null,"Fertilizer Optimization"]
[null,null,"Application Rate - kg/Ha"]
[null,"Crop","Urea","TSP","DAP","KCL",{"$f":"LEFT(B30,4)","v":"xxx"}]
[null,"Maize",{"$f":"O32","v":0},{"$f":"P32","v":0},{"$f":"Q32","v":0},{"$f":"R32","v":0},{"$f":"S32","v":0},null,null,null,null,null,null,"Fertilizer Cost "]
[null,"Sorghum",{"$f":"O33","v":0},0,0,0,{"$f":"S33","v":0},null,null,null,null,null,null,"Crop","Urea ","TSP ","DAP ","KCl ",{"$f":"P13","v":"xxx"},"Fertilizer Cost/Crop","Budget Constraint"]
[null,"Upland rice, paddy",0,0,0,0,0,null,null,null,null,null,null,"Maize",{"$f":"O32*$T$9","v":0},{"$f":"P32*$T$10","v":0},{"$f":"Q32*$T$11","v":0},{"$f":"R32*$T$12","v":0},{"$f":"S32*$T$13","v":0},{"$f":"SUM(O46:S46)*M32","v":0}]
[null,"Beans",0,0,0,0,0,null,null,null,null,null,null,"Sorghum",{"$f":"O33*$T$9","v":0},0,0,0,0,{"$f":"SUM(O47:S47)*M33","v":0}]
[null,"Soybeans",0,0,0,0,0,null,null,null,null,null,null,"Upland rice, paddy",0,0,0,0,0,0]
[null,"Groundnuts, unshelled",{"$f":"O37","v":0},0,0,0,{"$f":"S37","v":0},null,null,null,null,null,null,"Beans",0,0,0,0,0,0]
[null,"Total fertilizer needed",{"$f":"O39","v":0},{"$f":"P39","v":0},{"$f":"Q39","v":0},{"$f":"R39","v":0},{"$f":"S39","v":0},null,null,null,null,null,null,"Soybeans",0,0,0,0,0,0,null,null,"Fertilizer Application Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Groundnuts, unshelled",0,0,0,0,0,0,null,null,"N Amt Req P","P Amt Req K"]
[null,"Expected Average Effects per Ha",null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(O46:O51)","v":0},{"$f":"SUM(P46:P51)","v":0},0,0,0,{"$f":"SUM(T46:T51)","v":0},{"$f":"C34","v":0},null,20,10]
[null,"Crop","Yield Increases","Net Returns"]
[null,"Maize",{"$f":"Y60","v":0},{"$f":"Z60","v":0}]
[null,"Sorghum",{"$f":"Y62","v":0},{"$f":"Z62","v":0}]
[null,"Upland rice, paddy",{"$f":"Y64","v":0},{"$f":"Z64","v":0}]
[null,"Beans",{"$f":"Y66","v":0},{"$f":"Z66","v":0}]
[null,"Soybeans",{"$f":"Y68","v":0},{"$f":"Z68","v":0},null,null,null,null,null,null,null,"Crop and Yield Responses",null,null,null,null,null,null,"Returns and Expenses",null,null,null,"Fertilizer Requirements",null,"Output Variable - kg/Ha"]
[null,"Groundnuts, unshelled",{"$f":"Y70","v":0},{"$f":"Z70","v":0},null,null,null,null,null,null,null,"Functions","Constant","Coefficient 1","Coefficient 2","Base Production","Expected  Change ","Expected Yield Kg","Individual Net Value","Net Value per Fertilizer","Fert Costs","Net Return","N Amt Req P","P Amt Req K","Yield Increases","Net Returns"]
[null,null,null,null,null,null,null,null,null,null,null,"Maize N",3.9287000000000001,2.1387,0.9476,{"$f":"M60-N60","v":1.79},{"$f":"M60-N60*POWER(O60,AB32)-(P60)","v":0},{"$f":"Q60*1000","v":0},{"$f":"R60*N32*M32","v":0},{"$f":"S60+S61","v":0},{"$f":"T46","v":0},{"$f":"T60-U60","v":0},null,null,{"$f":"R60+R61","v":0},{"$f":"IF(OR(M32=0,M32=1),$V$60,IF(M32<1,$V$60/M32,IF(M32>1,$V$60/M32,0)))","v":0}]
[null,"Total Expected Net Returns to Fertilizer",null,null,null,null,null,null,null,null,null,"Maize P",3.98,0.377,0.80900000000000005,3.6029999999999998,{"$f":"(M61-N61*POWER(O61,AC32)-(P61))*W61","v":0},0,{"$f":"R61*N32*M32","v":0},null,null,null,{"$f":"IF(AB32<$W$52,0,1)","v":0}]
[null,"Total net returns to investment in fertilizer",{"$f":"V76","v":0},null,null,null,null,null,null,null,null,"Sorghum N ",2.27,1.58,0.93200000000000005,0.69,{"$f":"M62-N62*POWER(O62,AB33)-(P62)","v":0},0,{"$f":"R62*N33*M33","v":0},{"$f":"S62+S63","v":0},{"$f":"T47","v":0},{"$f":"T62-U62","v":0},null,null,{"$f":"R62+R63","v":0},{"$f":"IF(OR(M33=0,M33=1),$V$62,IF(M33<1,$V$62/M33,IF(M33>1,$V$62/M33,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Sorghum P",2.3050000000000002,0.36199999999999999,0.83899999999999997,1.9430000000000001,{"$f":"(M63-N63*POWER(O63,AC33)-(P63))*W63","v":0},0,{"$f":"R63*N33*M33","v":0},null,null,null,{"$f":"IF(AB33<$W$52,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Upland Rice N",3.6749999999999998,2.3959999999999999,0.95799999999999996,1.2789999999999999,{"$f":"M64-N64*POWER(O64,AB34)-(P64)","v":0},0,{"$f":"R64*N34*M34","v":0},{"$f":"S64+S65","v":0},{"$f":"T48","v":0},{"$f":"T64-U64","v":0},null,null,{"$f":"R64+R65","v":0},{"$f":"IF(OR(M34=0,M34=1),$V$64,IF(M34<1,$V$64/M34,IF(M34>1,$V$64/M34,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Upland Rice P",3.79,0.55600000000000005,0.94699999999999995,3.234,{"$f":"(M65-N65*POWER(O65,AC34)-(P65))*W65","v":0},0,{"$f":"R65*N34*M34","v":0},null,null,null,{"$f":"IF(AB34<$W$52,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Beans N ",1.79,0.98899999999999999,0.89200000000000002,0.80100000000000005,{"$f":"M66-N66*POWER(O66,AB35)-(P66)","v":0},0,{"$f":"R66*N35*M35","v":0},{"$f":"S66+S67","v":0},{"$f":"T49","v":0},{"$f":"T66-U66","v":0},null,null,{"$f":"R66+R67","v":0},{"$f":"IF(OR(M35=0,M35=1),$V$66,IF(M35<1,$V$66/M35,IF(M35>1,$V$66/M35,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Beans P",1.81,0.28599999999999998,0.92600000000000005,1.524,{"$f":"(M67-N67*POWER(O67,AC35)-(P67))*W67","v":0},0,{"$f":"R67*N35*M35","v":0},null,null,null,{"$f":"IF(AB35<$W$52,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Soybeans P ",1.9219999999999999,1.095,0.88700000000000001,0.82699999999999996,{"$f":"M68-N68*POWER(O68,AC36)-(P68)","v":0},{"$f":"Q68*1000","v":0},{"$f":"R68*N36*M36","v":0},{"$f":"S68+S69","v":0},{"$f":"T50","v":0},{"$f":"T68-U68","v":0},null,null,{"$f":"R68+R69","v":0},{"$f":"IF(OR(M36=0,M36=1),$V$68,IF(M36<1,$V$68/M36,IF(M36>1,$V$68/M36,0)))","v":0}]
[null,"Credits: Kayuki C. Kaizzi et al. of the National Agricultural Research Laboratories-Kawanda, National Agricultural Research Organization and Makerere University; and Charles Wortmann, Jim Jansen, and Matthew Stockton, University of Nebraska-Lincoln",null,null,null,null,null,null,null,null,null,"Soybeans K",1.972,0.28499999999999998,0.97399999999999998,1.6870000000000001,{"$f":"(M69-N69*POWER(O69,AD36)-(P69))*X69","v":0},0,{"$f":"R69*N36*M36","v":0},null,null,null,null,{"$f":"IF(AC36<$X$52,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Groundnuts, unshelled P",1.792,0.93700000000000006,0.89300000000000002,0.85499999999999998,{"$f":"M70-N70*POWER(O70,AC37)-(P70)","v":0},{"$f":"Q70*1000","v":0},{"$f":"R70*N37*M37","v":0},{"$f":"S70+S71","v":0},{"$f":"T51","v":0},{"$f":"T70-U70","v":0},null,null,{"$f":"R70+R71","v":0},{"$f":"IF(OR(M37=0,M37=1),$V$70,IF(M37<1,$V$70/M37,IF(M37>1,$V$70/M37,0)))","v":0}]
[null,"For information, contact: Dr. Kayuki C. Kaizzi, NARL-NARO, kckaizzi@gmail.com or karidir@infocom.co.ug or landuse@infocom.co.ug",null,null,null,null,null,null,null,null,null,"Groundnuts, unshelled K",1.72,0.221,0.94199999999999995,1.4989999999999999,{"$f":"(M71-N71*POWER(O71,AD37)-(P71))*X71","v":0},0,{"$f":"R71*N37*M37","v":0},null,null,null,null,{"$f":"IF(AC37<$X$52,0,1)","v":0}]
[]
[null,"Acknowledgements: support of personnel from the Uganda Ministry of Agriculture, Animal Industry, and Fisheries; and funding support from the Alliance for a  Green Revolution in Africa--Soil Health Programme, INTSORMIL-USAID, and University of Nebraska-Lincoln."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accumulated Sums"]
[null,"© 2013, The Board of Regents of the University of Nebraska. All rights reserved.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Net Value"," Fertilizer Cost"," Net Returns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T60:T71)","v":0},{"$f":"SUM(U60:U71)","v":0},{"$f":"SUM(V60:V71)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]