{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PHP Code","VB Code"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"PHP Code","index":0,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,"$Conversion=60;"]
[]
[null,null,null,null,null,null,null,null,null,null,"INPUTS","Value"]
[null,"   $K_SLP=0.15/(1-$BSF);",null,null,null,null,null,null,null,"$BSF","Bare Soil NDVI",0.15]
[null,null,null,null,null,null,null,null,null,"$RichStrip","N Rich Strip",0.79]
[null,"   $K_Inter=($K_SLP*$BSF);",null,null,null,null,null,null,null,"$FarmerPractice","Farmer Practice",0.7]
[null,null,null,null,null,null,null,null,null,"$MaxYield","Maximum Yield",250,"bu/ac"]
[null,"   $INF_SLP=0.73/(1-$BSF);",null,null,null,null,null,null,null,"$NUE","Expected NUE",70,"%"]
[null,"   $INF_Inter=($INF_SLP*$BSF);",null,null,null,null,null,null,null,"$PercentN","Percent N in Grain",1.1000000000000001]
[null,"  $ InfPt = $RichStrip*$INF_SLP-$INF_Inter;",null,null,null,null,null,null,null,"$Conv","Weight/bushel, lbs",60]
[null,"   $Curve = $RichStrip*$K_SLP-$K_Inter;",null,null,null,null,null,null,null,"$NUE","Nitrogen Use Efficiency",70]
[null,"   $RI    = $RichStrip/$FarmerPractice;",null,null,null,null,null,null,null,"$K_SLP","K Slope",{"$f":"0.15/(1-L4)","v":0.17647058823529413}]
[null,"   $YP0   = $Conversion*($MaxYield/(1+EXP(-(($FarmerPractice-$infPt)/$Curve))));     ",null,null,null,null,null,null,null,"$K_Inter","K Intercept",{"$f":"L12*L4","v":2.6470588235294117E-2}]
[null,"   $YPN   = $Conversion*($MaxYield/(1+EXP(-(($FarmerPractice*$RI-$infPt)/$Curve))));",null,null,null,null,null,null,null,"$INF_SLP","Inf_Slope",{"$f":"0.73/(1-L4)","v":0.85882352941176465}]
[null,"                 // MaxYield automatically takes care of the mertric/english conversion",null,null,null,null,null,null,null,"$INF_Inter","Inf_Intercept",{"$f":"L14*L4","v":0.1288235294117647}]
[null,"   $NRate = (($YPN-$YP0)*$PercentN)/$NUE;",null,null,null,null,null,null,null,"$InfPt","Inflection Point",{"$f":"(L5*L14-L15)","v":0.54964705882352949}]
[null,null,null,null,null,null,null,null,null,"$Curve","Curve",{"$f":"L5*L12-L13","v":0.11294117647058825}]
[null,"$CRate1=1.12;",null,null,null,null,null,null,null,"$RI","Response Index",{"$f":"L5/L6","v":1.1285714285714288},null,"bu/ac"]
[null,"$CRate2=60;",null,null,null,null,null,null,null,"$YP0","Yield Potential",{"$f":"L10*(L7/(1+EXP(-((L6-L16)/L17))))","v":11865.709864115139},"lb/ac",{"$f":"L19/60","v":197.76183106858565}]
[null,"$Conversion = 60 lbs/bu wheat",null,null,null,null,null,null,null,"$YPN","Yield Potential with N",{"$f":"L10*(L7/(1+EXP(-((L6*L18-L16)/L17))))","v":13404.103151859183},"lb/ac",{"$f":"L20/60","v":223.40171919765305}]
[null,"$Conversion = 56 lbs/bu corn",null,null,null,null,null,null,null,"$Nrate","Nitrogen Rate",{"$f":"((L20-L19)*L9)/L11","v":24.174751664549262},null,null,null,"Grain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CROP","% N","lb/bu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigated corn",1.25,56]
[null,null,null,null,null,null,null,null,null,"IF THEN",null,null,null,null,"Dryland corn",1.3,56]
[null,null,null,null,null,null,null,null,null,"NDVI",null,null,null,null,"Winter wheat",2.2999999999999998,60]
[null,null,null,null,null,null,null,null,null,"IF NDVI>N Rich, N rate = 0",null,null,null,null,"Spring wheat",2.4500000000000002,60]
[null,null,null,null,null,null,null,null,null,"IF NDVI <  bare soil, N rate = 0",null,null,null,null,"Barley",1.7,48]
[null,"Farmer Practice",null,null,null,null,null,null,null,null,null,null,null,null,"Sorghum",1.34,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rice",1.28,45]
[null,"NDVI","$K_SLP","$K_Inter","$INF_SLP","$INF_Inter","$InfPt","$Curve","$RI","YPO","YPN","N Rate"]
[null,0,{"$f":"0.15/(1-$L$4)","v":0.17647058823529413},{"$f":"$L$4*C31","v":2.6470588235294117E-2},{"$f":"0.73/(1-$L$4)","v":0.85882352941176465},{"$f":"E31*$L$4","v":0.1288235294117647},{"$f":"($L$5*E31-F31)","v":0.54964705882352949},{"$f":"$L$5*C31-D31","v":0.11294117647058825},{"$f":"$L$5/$L$6","v":1.1285714285714288},{"$f":"$L$10*($L$7/(1+EXP(-((B31-$L$16)/$L$17))))","v":114.60246498479925},{"$f":"$L$10*($L$7/(1+EXP(-((B31*$L$18-$L$16)/$L$17))))","v":114.60246498479925},{"$f":"((K31-J31)*$L$9)/$L$11","v":0}]
[null,0.05,{"$f":"0.15/(1-$L$4)","v":0.17647058823529413},{"$f":"$L$4*C32","v":2.6470588235294117E-2},{"$f":"0.73/(1-$L$4)","v":0.85882352941176465},{"$f":"E32*$L$4","v":0.1288235294117647},{"$f":"($L$5*E32-F32)","v":0.54964705882352949},{"$f":"$L$5*C32-D32","v":0.11294117647058825},{"$f":"$L$5/$L$6","v":1.1285714285714288},{"$f":"$L$10*($L$7/(1+EXP(-((B32-$L$16)/$L$17))))","v":177.67068050816889},{"$f":"$L$10*($L$7/(1+EXP(-((B32*$L$18-$L$16)/$L$17))))","v":187.94659569552945},{"$f":"((K32-J32)*$L$9)/$L$11","v":0.1614786672299518},null,"NUE","Source","Method"]
[null,0.1,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,{"$f":"$L$10*($L$7/(1+EXP(-((B33-$L$16)/$L$17))))","v":274.80594311456787},307.26113290758286,0.51001012531880707,null,40,"UAN, Urea","Broadcast without incorporation"]
[null,0.15,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,{"$f":"($L$5*E34-F34)","v":0.54964705882352949},{"$f":"$L$5*C34-D34","v":0.11294117647058825},1.1285714285714288,423.52911399585651,499.76471454786332,1.1979880086743928]
[null,0.2,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,649.19180136373416,806.25639006933761,2.4681578225166261]
[null,0.25,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,986.94994254959829,1284.0658017579608,4.6689635018456972]
[null,0.3,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,1482.2844185384456,2005.0378630639166,8.2146969854002592]
[null,0.35,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,2187.4132742030001,3041.0651973246222,13.414530220482634,null,"http://www.unc.edu/~rowlett/units/scales/bushels.html"]
[null,0.4,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,3149.8143986040377,4429.9293215296548,20.116091645973984]
[null,0.45,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,4390.5467167913794,6128.0613871408023,27.303801962633788]
[null,0.5,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,5877.6038558498785,7985.3697976260664,33.122036227911522]
[null,0.55000000000000004,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,7511.718740463265,9784.7603630125304,35.719225497202743]
[null,0.6,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,9144.7217422203667,11334.45188181607,34.410045050789634]
[null,0.65,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,10628.836981600238,12539.454630980328,30.02399163311571]
[null,0.7,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,11865.709864115139,13404.103151859183,24.174751664549262]
[null,0.75,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,12824.238571551088,13989.397445868641,18.309639453561541]
[null,0.8,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,13526.043464498043,14370.122382135054,13.264097277153029]
[null,0.82,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,13745.241997056633,14480.269637075071,11.550434343146877]
[null,0.9,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,14354.678981467212,14761.788166261382,6.3974300467655256]
[null,0.95,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,14579.035632009156,14854.555152392129,4.3295924631610125]
[null,1,0.17647058823529413,2.6470588235294117E-2,0.85882352941176465,0.1288235294117647,0.54964705882352949,0.11294117647058825,1.1285714285714288,14726.87506193535,14911.412630593157,2.8998760789083855]

{"sheet":"VB Code","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Excel version of the GA equation"]
[]
[null,"INPUTS","Value"]
[null,"Bare Soil NDVI",0.25]
[null,"N Rich Strip",0.8]
[null,"Farmer Practice",0.7]
[null,"Maximum Yield",100,"bu/ac"]
[null,"Expected NUE",70,"%"]
[null,"Percent N in Grain",2.39]
[]
[null,"N Rate",{"$f":"GA_Nrate(C4,C5,C6,C7,C8,C9)","v":20.519762939266688},"lb/acre"]