{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Putting Greens Nutrition Prog","Program Cost","Rec Rate"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":1,"defined_names":37,"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":"Putting Greens Nutrition Prog","index":0,"n_rows":61,"n_cols":28,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,6,1,13],[2,6,2,13],[3,6,3,8],[3,10,3,13],[10,6,10,8],[28,4,28,7],[31,17,31,18],[32,17,32,18],[31,15,31,16],[32,15,32,16],[35,3,35,7],[52,0,52,2],[53,0,53,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[46,0,46,2],[48,0,48,2],[47,0,47,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[42,0,42,2]]}
["True Performance Turfgrass Program Nutritional Calculator"]
[null,null,null,null,null,"Course Name:   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low P Correction"]
[null,null,null,null,null,"Superintendent Name:   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Early Spring"]
[null,null,null,null,null,"Salesman:   ",null,null,null,"Distributor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Spring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aerification"]
[null,null,null,null,null,null,"Putting Greens Square Footage",null,null,"Sq. Ft.","Acres"]
[null,null,null,null,null,null," Enter number of Sq. Ft.",null,null,130680,{"$f":"+J9/43560","v":3}]
[]
[null,null,null,null,null,null,"Enter # of LIQUID Applications",null,null,6,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Nutrient Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Putting Green - Cool Season"]
[null,null,null,null,null,null,null,null,null,null,"Concentrations of Nutrients ( lbs / 1000 ft2 )"]
["Product Name",null,null,"Recommended Rates",null,"Application Rate",null,null,"Seaplant Extract",null,"Primary Nutrients",null,null,"Secondary Nutrients",null,"Micronutrients",null,null,null,null,null,null,null,null,null,null,null,"Putting Green - Warm Season"]
["Emerald Isle Solutions","Bulk Density (lbs/gal)","Specific    Gravity","Cool Season Turf","Warm Season Turf","oz / 1000 ft2","Gal / Acre","# of 2.5 Gallon Jugs / Application","oz / 1000 ft2","% by Wt","N","P","K","Mg","S","Fe","Mn","Zn","Cu","B","Si"]
["CPR®  4-0-1 ",9.76,1.1739999999999999,"6-9 oz / M","6-9 oz / M",0,{"$f":"IF(F18/128*43.56=0, \"-\",F18/128*43.56)","v":"-"},{"$f":"IFERROR((G18*$K$9)/2.5, \"-\")","v":"-"},{"$f":"IF(F18*J18/C18=0, \" - \",F18*J18/C18)","v":" - "},0.6,{"$f":"IF($F18=0,\"-\",IFERROR($B18*($F18/128)*(4*0.01),\" - \"))","v":"-"},"-",{"$f":"IF(F18=0, \"-\",B18*(F18/128)*(1*0.01))","v":"-"},{"$f":"IF(F18=0,\"-\",B18*(F18/128)*(0.53*0.01))","v":"-"},{"$f":"IF(F18=0,\"-\",B18*(F18/128)*(1*0.01))","v":"-"},{"$f":"IF(F18=0,\"-\",B18*(F18/128)*(2*0.01))","v":"-"},{"$f":"IF(F18=0,\"-\",B18*(F18/128)*(0.25*0.01))","v":"-"},{"$f":"IF(F18=0,\"-\",B18*(F18/128)*(0.2*0.01))","v":"-"},"-","-","-"]
["True Foliar® K 2-0-16",10.68,1.28,"3-4 oz / M","4-8 oz / M",0,"-","-"," - ",0.4,{"$f":"IF(F19=0,\"-\",IFERROR(B19*(F19/128)*(2*0.01), \" - \"))","v":"-"},"-",{"$f":"IF(F19=0, \"-\",B19*(F19/128)*(16*0.01))","v":"-"},"-","-",{"$f":"IF(F19=0,\"-\",B19*(F19/128)*(0.6*0.01))","v":"-"},{"$f":"IF(F19=0,\"-\",B19*(F19/128)*(0.45*0.01))","v":"-"},"-","-","-","-"]
["True Foliar® MgMn 6-0-0",10.84,1.3,"3-4 oz / M","4-8 oz / M",0,"-","-"," - ",0.3,{"$f":"IF(F20=0,\"-\",IFERROR(B20*(F20/128)*(6*0.01), \" - \"))","v":"-"},"-","-",{"$f":"IF(F19=0,\"-\",B20*(F20/128)*(2*0.01))","v":"-"},"-","-",{"$f":"IF(F20=0,\"-\",B20*(F20/128)*(5*0.01))","v":"-"},"-","-","-","-"]
["True Foliar® N 19-1-6",10.84,1.3,"3-4 oz / M","4-8 oz / M",0,"-","-"," - ",0.14000000000000001,{"$f":"IF(F21=0,\"-\",IFERROR(B21*(F21/128)*(19*0.01), \" - \"))","v":"-"},{"$f":"IF($F21=0,\"-\",IFERROR($B21*($F21/128)*(1*0.01),\" - \"))","v":"-"},{"$f":"IF(F21=0, \"-\",B21*(F21/128)*(6*0.01))","v":"-"},{"$f":"IF(F21=0,\"-\",B21*(F21/128)*(2*0.01))","v":"-"},"-",{"$f":"IF(F21=0,\"-\",B21*(F21/128)*(1.2*0.01))","v":"-"},{"$f":"IF(F21=0,\"-\",B21*(F21/128)*(0.18*0.01))","v":"-"},{"$f":"IF(F21=0,\"-\",B21*(F21/128)*(0.15*0.01))","v":"-"},{"$f":"IF(F21=0,\"-\",B21*(F21/128)*(0.1*0.01))","v":"-"},"-","-"]
["True Foliar® NK Balance 10-0-10",10.68,1.28,"6-12 oz / M","6-12 oz / M",0,"-","-"," - ",0.25,{"$f":"IF(F22=0,\"-\",IFERROR(B22*(F22/128)*(10*0.01), \" - \"))","v":"-"},"-",{"$f":"IF(F22=0, \"-\",B22*(F22/128)*(10*0.01))","v":"-"},{"$f":"IF(F22=0,\"-\",B22*(F22/128)*(0.5*0.01))","v":"-"},"-",{"$f":"IF(F22=0,\"-\",B22*(F22/128)*(0.95*0.01))","v":"-"},{"$f":"IF(F22=0,\"-\",B22*(F22/128)*(2*0.01))","v":"-"},{"$f":"IF(F22=0,\"-\",B22*(F22/128)*(0.08*0.01))","v":"-"},{"$f":"IF(F22=0,\"-\",B22*(F22/128)*(0.06*0.01))","v":"-"},"-","-"]
["PanaSea Plus 0-2-2",9.01,1.08,"2-3 oz / M","2-3 oz / M",0,"-","-"," - ",1,{"$f":"IF(F23=0,\"-\",IFERROR(B23*(F23/128)*(2*0.01), \" - \"))","v":"-"},"-",{"$f":"IF(F23=0, \"-\",B23*(F23/128)*(2*0.01))","v":"-"},"-","-","-","-","-","-","-","-"]
["True Foliar® P 6-12-6",11.01,1.32,"3-4 oz / M","4-8 oz / M",0,"-","-"," - ",0.4,{"$f":"IF(F24=0, \"-\",IFERROR(B24*(F24/128)*(6*0.01), \" - \"))","v":"-"},{"$f":"IF($F24=0,\"-\",IFERROR($B24*($F24/128)*(12*0.01),\" - \"))","v":"-"},{"$f":"IF(F24=0, \"-\",B24*(F24/128)*(6*0.01))","v":"-"},"-","-",{"$f":"IF(F24=0,\"-\",B24*(F24/128)*(1.2*0.01))","v":"-"},{"$f":"IF(F24=0,\"-\",B24*(F24/128)*(0.65*0.01))","v":"-"},{"$f":"IF(F24=0,\"-\",B24*(F24/128)*(0.15*0.01))","v":"-"},{"$f":"IF(F24=0,\"-\",B24*(F24/128)*(0.1*0.01))","v":"-"},{"$f":"IF(F24=0,\"-\",B24*(F24/128)*(0.05*0.01))","v":"-"},"-"]
["True Foliar® NPK 10-3-16",11.43,1.37,"3-4 oz / M","4-8 oz / M",0,"-","-"," - ",0.3,{"$f":"IF($F25=0,\"-\",IFERROR($B25*($F25/128)*(10*0.01),\" - \"))","v":"-"},{"$f":"IF($F25=0,\"-\",IFERROR($B25*($F25/128)*(3*0.01),\" - \"))","v":"-"},{"$f":"IF(F25=0, \"-\",B25*(F25/128)*(16*0.01))","v":"-"},"-","-","-","-","-","-","-","-"]
["True Foliar® Si 3-0-10",9.76,1.17,"3-4 oz / M","4-8 oz / M",0,"-","-"," - ",0.45,{"$f":"IF(F26=0,\"-\",IFERROR(B26*(F26/128)*(3*0.01), \" - \"))","v":"-"},"-",{"$f":"IF(F26=0, \"-\",B26*(F26/128)*(10*0.01))","v":"-"},"-","-","-","-","-","-","-",{"$f":"IF(F26=0,\"-\",B26*(F26/128)*(1*0.01))","v":"-"}]
["Fairway Fertilizer 30-0-0",10.84,1.3,"4-6 oz / M","4-6 oz / M",0,"-","-"," - ",0.1,{"$f":"IF(F27=0,\"-\",IFERROR(B27*(F27/128)*(30*0.01), \" - \"))","v":"-"},"-","-","-","-","-","-","-","-","-","-"]
["Fairway SeaQuential® 6-0-2",11.04,1.32,"2-3 oz / M","2-3 oz / M",0,"-","-",{"$f":"IF(F28*J28/C28=0, \" - \",F28*J28/C28)","v":" - "},0.47,{"$f":"IF(F28=0,\"-\",IFERROR(B28*(F28/128)*(6*0.01), \" - \"))","v":"-"},"-",{"$f":"IF(F28=0, \"-\",B28*(F28/128)*(2*0.01))","v":"-"},"-",{"$f":"IF(F28=0,\"-\",B28*(F28/128)*(4*0.01))","v":"-"},{"$f":"IF(F28=0,\"-\",B28*(F28/128)*(6*0.01))","v":"-"},"-","-","-","-","-"]
[null,null,null,null,"Total Pounds of Nutrient per 1000 ft2 per Application",null,null,null,{"$f":"SUM(I18:I28)","v":0},null,{"$f":"SUM(K18:K28)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P29+Q29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lbs. of Fe + Mn"]
[]
[]
[null,null,null,"Total Pounds of Nutrient per 1000 ft2 for All Season Applications",null,null,null,null,{"$f":"I29*$J$11","v":0},null,{"$f":"K29*$J$11","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Product Name",null,null,null,null,"Application Rate",null,null,null,null,"Primary Nutrients",null,null,"Secondary Nutrients",null,"Micronutrients"]
["Country Club MD (SGN 80)",null,null,"Lbs Fert / M","Lbs Fert/ Acre","Sq. Ft. One Bag Covers","# of 40 lb. bags per App","# of Applications","Timing of Application",null,"N","P","K","Mg","S","Fe","Mn","Zn","Cu","B","Si"]
["0-0-24  3% Fe 2% Mg 1% Mn SOP",null,null,0,{"$f":"IF(D40=0,\"-\",(D40)*43.56)","v":"-"},{"$f":"IF(D40=0,\"-\",(40/D40)*1000)","v":"-"},{"$f":"IF(D40=0,\"-\",$J$9/F40)","v":"-"},null,null,null,{"$f":"IF(H40=0, IF($D40=0,\"-\",$D40*(0*0.01)),IF($D40=0,\"-\",$D40*(0*0.01))*H40)","v":"-"},{"$f":"IF(H40=0,IF($D40=0,\"-\",$D40*(0*0.01)),IF($D40=0,\"-\",$D40*(0*0.01))*H40)","v":"-"},{"$f":"IF(H40=0,IF($D40=0,\"-\",$D40*(24*0.01)),IF($D40=0,\"-\",$D40*(24*0.01))*H40)","v":"-"},{"$f":"IF(H40=0,IF($D40=0,\"-\",(D40*(2*0.01))),IF($D40=0,\"-\",(D40*(2*0.01)))*H40)","v":"-"},{"$f":"IF(H40=0, IF($D40=0,\"-\",(D40*(11*0.01))), IF($D40=0,\"-\",(D40*(11*0.01)))*H40)","v":"-"},{"$f":"IF(H40=0,IF($D40=0,\"-\",($D40*(3*0.01))),IF($D40=0,\"-\",($D40*(3*0.01)))*H40)","v":"-"},{"$f":"IF(H40=0,IF($D40=0,\"-\",($D40*(1*0.01))),IF($D40=0,\"-\",($D40*(1*0.01)))*H40)","v":"-"},"-","-","-","-"]
["11-7-21  60% Meth-Ex 2% Fe 1% Mg 1% Mn SOP",null,null,0,{"$f":"IF(D41=0,\"-\",(D41)*43.56)","v":"-"},{"$f":"IF(D41=0,\"-\",(40/D41)*1000)","v":"-"},"-",null,null,null,{"$f":"IF(H41=0,IF(D41=0,\"-\",D41*(11*0.01)),IF(D41=0,\"-\",D41*(11*0.01))*H41)","v":"-"},{"$f":"IF(H41=0,IF($D41=0,\"-\",$D41*(7*0.01)),IF($D41=0,\"-\",$D41*(7*0.01))*H41)","v":"-"},{"$f":"IF(H41=0,IF($D41=0,\"-\",$D41*(21*0.01)),IF($D41=0,\"-\",$D41*(21*0.01))*H41)","v":"-"},{"$f":"IF(H41=0,IF($D41=0,\"-\",(D41*(1*0.01))),IF($D41=0,\"-\",(D41*(1*0.01)))*H41)","v":"-"},{"$f":"IF(H41=0,IF($D41=0,\"-\",(D41*(8.4*0.01))),IF($D41=0,\"-\",(D41*(8.4*0.01)))*H41)","v":"-"},{"$f":"IF(H41=0,IF($D41=0,\"-\",($D41*(2*0.01))),IF($D41=0,\"-\",($D41*(2*0.01)))*H41)","v":"-"},{"$f":"IF(H41=0,IF($D41=0,\"-\",($D41*(1*0.01))),IF($D41=0,\"-\",($D41*(1*0.01)))*H41)","v":"-"},"-","-","-","-"]
["12-0-24  65% Meth-Ex 1.6% Fe .5% Mg .5% Mn SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H42=0,IF(D42=0,\"-\",D42*(12*0.01)),IF(D42=0,\"-\",D42*(12*0.01))*H42)","v":"-"},{"$f":"IF(H42=0,IF($D42=0,\"-\",$D42*(0*0.01)),IF($D42=0,\"-\",$D42*(0*0.01))*H42)","v":"-"},{"$f":"IF(H42=0,IF($D42=0,\"-\",$D42*(24*0.01)),IF($D42=0,\"-\",$D42*(24*0.01))*H42)","v":"-"},{"$f":"IF(H42=0,IF($D42=0,\"-\",(D42*(0.5*0.01))),IF($D42=0,\"-\",(D42*(0.5*0.01)))*H42)","v":"-"},{"$f":"IF(H42=0,IF($D42=0,\"-\",(D42*(9.5*0.01))),IF($D42=0,\"-\",(D42*(9.5*0.01)))*H42)","v":"-"},{"$f":"IF(H42=0,IF($D42=0,\"-\",($D42*(1.6*0.01))),IF($D42=0,\"-\",($D42*(1.6*0.01)))*H42)","v":"-"},{"$f":"IF(H42=0,IF($D42=0,\"-\",($D42*(0.5*0.01))),IF($D42=0,\"-\",($D42*(0.5*0.01)))*H42)","v":"-"},"-","-","-","-"]
["12-24-8  40% Meth-Ex SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H43=0,IF(D43=0,\"-\",D43*(12*0.01)),IF(D43=0,\"-\",D43*(12*0.01))*H43)","v":"-"},{"$f":"IF(H43=0,IF($D43=0,\"-\",$D43*(24*0.01)),IF($D43=0,\"-\",$D43*(24*0.01))*H43)","v":"-"},{"$f":"IF(H43=0,IF($D43=0,\"-\",$D43*(8*0.01)),IF($D43=0,\"-\",$D43*(8*0.01))*H43)","v":"-"},"-",{"$f":"IF(H43=0, IF($D43=0,\"-\",(D43*(2.6*0.01))),IF($D43=0,\"-\",(D43*(2.6*0.01)))*H43)","v":"-"},"-","-","-","-","-","-"]
["14-7-14  70% Meth-Ex 2% Fe 1.5% Mg 1% Mn SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H44=0, IF(D44=0,\"-\",D44*(14*0.01)),IF(D44=0,\"-\",D44*(14*0.01))*H44)","v":"-"},{"$f":"IF(H44=0,IF($D44=0,\"-\",$D44*(7*0.01)),IF($D44=0,\"-\",$D44*(7*0.01))*H44)","v":"-"},{"$f":"IF(H44=0,IF($D44=0,\"-\",$D44*(14*0.01)),IF($D44=0,\"-\",$D44*(14*0.01))*H44)","v":"-"},{"$f":"IF(H44=0,IF($D44=0,\"-\",(D44*(1.5*0.01))),IF($D44=0,\"-\",(D44*(1.5*0.01)))*H44)","v":"-"},{"$f":"IF(H44=0,IF($D44=0,\"-\",(D44*(6.6*0.01))),IF($D44=0,\"-\",(D44*(6.6*0.01)))*H44)","v":"-"},{"$f":"IF(H44=0,IF($D44=0,\"-\",($D44*(2*0.01))),IF($D44=0,\"-\",($D44*(2*0.01)))*H44)","v":"-"},{"$f":"IF(H44=0,IF($D44=0,\"-\",($D44*(1*0.01))),IF($D44=0,\"-\",($D44*(1*0.01)))*H44)","v":"-"},"-","-","-","-"]
["16-0-8  Ammoniacal 1% Fe 1% Mg .5% Mn SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H45=0,IF(D45=0,\"-\",D45*(16*0.01)),IF(D45=0,\"-\",D45*(16*0.01))*H45)","v":"-"},{"$f":"IF(H45=0,IF($D45=0,\"-\",$D45*(0*0.01)),IF($D45=0,\"-\",$D45*(0*0.01))*H45)","v":"-"},{"$f":"IF(H45=0,IF($D45=0,\"-\",$D45*(8*0.01)),IF($D45=0,\"-\",$D45*(8*0.01))*H45)","v":"-"},{"$f":"IF(H45=0,IF($D45=0,\"-\",(D45*(1*0.01))),IF($D45=0,\"-\",(D45*(1*0.01)))*H45)","v":"-"},{"$f":"IF(H45=0,IF($D45=0,\"-\",(D45*(20*0.01))),IF($D45=0,\"-\",(D45*(20*0.01)))*H45)","v":"-"},{"$f":"IF(H45=0,IF(D45=0,\"-\",(D45*(1*0.01))),IF(D45=0,\"-\",(D45*(1*0.01)))*H45)","v":"-"},{"$f":"IF(H45=0,IF($D45=0,\"-\",($D45*(0.5*0.01))),IF($D45=0,\"-\",($D45*(0.5*0.01)))*H45)","v":"-"},"-","-","-","-"]
["18-0-18  64% Meth-Ex 1.6% Fe .5% Mg .5% Mn SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H46=0,IF(D46=0,\"-\",D46*(18*0.01)),IF(D46=0,\"-\",D46*(18*0.01))*H46)","v":"-"},{"$f":"IF(H46=0,IF($D46=0,\"-\",$D46*(0*0.01)),IF($D46=0,\"-\",$D46*(0*0.01))*H46)","v":"-"},{"$f":"IF(H46=0,IF($D46=0,\"-\",$D46*(18*0.01)),IF($D46=0,\"-\",$D46*(18*0.01))*H46)","v":"-"},{"$f":"IF(H46=0,IF($D46=0,\"-\",(D46*(0.5*0.01))),IF($D46=0,\"-\",(D46*(0.5*0.01)))*H46)","v":"-"},{"$f":"IF(H46=0,IF($D46=0,\"-\",(D46*(6.6*0.01))),IF($D46=0,\"-\",(D46*(6.6*0.01)))*H46)","v":"-"},{"$f":"IF(H46=0,IF(D46=0,\"-\",(D46*(1.6*0.01))),IF(D46=0,\"-\",(D46*(1.6*0.01)))*H46)","v":"-"},{"$f":"IF(H46=0,IF($D46=0,\"-\",($D46*(0.5*0.01))),IF($D46=0,\"-\",($D46*(0.5*0.01)))*H46)","v":"-"},"-","-","-","-"]
["18-3-18  78% Meth-Ex 1.5% Fe .65% Mg .5% Mn SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H47=0,IF(D47=0,\"-\",D47*(18*0.01)),IF(D47=0,\"-\",D47*(18*0.01))*H47)","v":"-"},{"$f":"IF(H47=0,IF($D47=0,\"-\",$D47*(3*0.01)),IF($D47=0,\"-\",$D47*(3*0.01))*H47)","v":"-"},{"$f":"IF(H47=0,IF($D47=0,\"-\",$D47*(18*0.01)),IF($D47=0,\"-\",$D47*(18*0.01))*H47)","v":"-"},{"$f":"IF(H47=0,IF($D47=0,\"-\",(D47*(0.5*0.01))),IF($D47=0,\"-\",(D47*(0.5*0.01)))*H47)","v":"-"},{"$f":"IF(H47=0,IF($D47=0,\"-\",(D47*(8.4*0.01))),IF($D47=0,\"-\",(D47*(8.4*0.01)))*H47)","v":"-"},{"$f":"IF(H47=0,IF(D47=0,\"-\",(D47*(1.5*0.01))),IF(D47=0,\"-\",(D47*(1.5*0.01)))*H47)","v":"-"},{"$f":"IF(H47=0,IF($D47=0,\"-\",($D47*(0.5*0.01))),IF($D47=0,\"-\",($D47*(0.5*0.01)))*H47)","v":"-"},"-","-","-","-"]
["20-0-10  40% Meth-Ex SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H48=0,IF(D48=0,\"-\",D48*(20*0.01)),IF(D48=0,\"-\",D48*(20*0.01))*H48)","v":"-"},{"$f":"IF(H48=0,IF($D48=0,\"-\",$D48*(0*0.01)),IF($D48=0,\"-\",$D48*(0*0.01))*H48)","v":"-"},{"$f":"IF(H48=0,IF($D48=0,\"-\",$D48*(10*0.01)),IF($D48=0,\"-\",$D48*(10*0.01))*H48)","v":"-"},"-",{"$f":"IF(H48=0,IF($D48=0,\"-\",(D48*(12.6*0.01))),IF($D48=0,\"-\",(D48*(12.6*0.01)))*H48)","v":"-"},"-","-","-","-","-","-"]
["22-0-16  64% Meth-Ex 1.6% Fe .7% Mg .8% Mn SOP",null,null,0,"-","-","-",null,null,null,{"$f":"IF(H49=0,IF(D49=0,\"-\",D49*(22*0.01)),IF(D49=0,\"-\",D49*(22*0.01))*H49)","v":"-"},{"$f":"IF(H49=0,IF($D49=0,\"-\",$D49*(0*0.01)),IF($D49=0,\"-\",$D49*(0*0.01))*H49)","v":"-"},{"$f":"IF(H49=0,IF($D49=0,\"-\",$D49*(16*0.01)),IF($D49=0,\"-\",$D49*(16*0.01))*H49)","v":"-"},{"$f":"IF(D49=0,IF($D49=0,\"-\",(D49*(0.7*0.01))),IF($D49=0,\"-\",(D49*(0.7*0.01)))*H49)","v":"-"},{"$f":"IF(H49=0,IF($D49=0,\"-\",(D49*(6.2*0.01))),IF($D49=0,\"-\",(D49*(6.2*0.01)))*H49)","v":"-"},{"$f":"IF(H49=0,IF(D49=0,\"-\",(D49*(1.6*0.01))),IF(D49=0,\"-\",(D49*(1.6*0.01)))*H49)","v":"-"},{"$f":"IF(H49=0,IF($D49=0,\"-\",($D49*(0.8*0.01))),IF($D49=0,\"-\",($D49*(0.8*0.01)))*H49)","v":"-"},"-","-","-","-"]
[null,null,null,null,null,null,null,null,null,"Total Granular Nutrients per 1000 ft2",{"$f":"SUM(K40:K49)","v":0},{"$f":"SUM(L40:L49)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Product Name",null,null,null,null,"Application Rate",null,null,null,null,"Primary Nutrients",null,null,"Secondary Nutrients",null,"Micronutrients"]
["Emerald Isle Granular",null,null,"Lbs Fert / M","Lbs Fert/ Acre","Sq. Ft. One Bag Covers","# of 40 lb. bags per App","# of Applications","Timing of Application",null,"N","P","K","Mg","S","Fe","Mn","Zn","Cu","B","Si"]
["Sand Aid Granular Sea Plant Meal 1-0-1",null,null,0,{"$f":"IF(D54=0,\"-\",(D54)*43.56)","v":"-"},{"$f":"IF(D54=0,\"-\",(40/D54)*1000)","v":"-"},{"$f":"IF(D54=0,\"-\",$J$9/F54)","v":"-"},null,null,null,{"$f":"IF(H54=0,IF(D54=0,\"-\",D54*(1*0.01)),IF(D54=0,\"-\",D54*(1*0.01))*H54)","v":"-"},{"$f":"IF(H54=0,IF($D54=0,\"-\",$D54*(0*0.01)),IF($D54=0,\"-\",$D54*(0*0.01))*H54)","v":"-"},{"$f":"IF(H54=0,IF($D54=0,\"-\",$D54*(1*0.01)),IF($D54=0,\"-\",$D54*(1*0.01))*H54)","v":"-"},"-","-","-","-","-","-","-","-"]
[]
[null,null,null,null,null,null,null,null,"Seaplant Extract",null,"Primary Nutrients",null,null,"Secondary Nutrients",null,"Micronutrients"]
[null,null,null,null,null,null,null,null,"oz / 1000 ft2",null,"N","P","K","Mg","S","Fe","Mn","Zn","Cu","B","Si"]
[null,null,null,"Nutrient Total per 1000 ft2 for all Applications",null,null,null,null,{"$f":"I29*$J$11","v":0},null,{"$f":"IFERROR(K29*$J$11+SUM(K40:K49)+K54, K29*$J$11+SUM(K40:K49))","v":0},{"$f":"IFERROR(L29*$J$11+SUM(L40:L49)+L54, L29*$J$11+SUM(L40:L49))","v":0},{"$f":"IFERROR(M29*$J$11+SUM(M40:M49)+M54, M29*$J$11+SUM(M40:M49))","v":0},{"$f":"N29*$J$11+SUM(N40:N49)","v":0},0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Program Cost","index":1,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,1,4,3],[3,1,3,3],[1,1,1,3],[2,1,2,3]]}
["Country Club MD & Emerald Isle Nutritional Calculator"]
["Course Name:",{"$f":"IF('Putting Greens Nutrition Prog'!G2=0,\"\",'Putting Greens Nutrition Prog'!G2)","v":""}]
["Superintendent Name:",{"$f":"IF('Putting Greens Nutrition Prog'!G3=0,\"\",'Putting Greens Nutrition Prog'!G3)","v":""}]
["Salesman:",{"$f":"IF('Putting Greens Nutrition Prog'!G4=0,\"\",'Putting Greens Nutrition Prog'!G4)","v":""}]
["Distributor:",{"$f":"IF('Putting Greens Nutrition Prog'!K4=0,\"\",'Putting Greens Nutrition Prog'!K4)","v":""}]
[]
["Product Name","40 lb. Bags Per Application","Customer Bag Price ","Product         Cost ","# of Applications Per Season","# of Bags Needed for Season"]
["0-0-24  3% Fe 2% Mg 1% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G40,0),\"-\")","v":"-"},44,{"$f":"IFERROR(C8*F8,\"-\")","v":"-"},{"$f":"IF('Putting Greens Nutrition Prog'!D40=0,\"-\",IF('Putting Greens Nutrition Prog'!H40=0,1,'Putting Greens Nutrition Prog'!H40))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D40=0,0,IF('Putting Greens Nutrition Prog'!$H40=0,1,'Putting Greens Nutrition Prog'!$H40))*'Putting Greens Nutrition Prog'!$G40,0), \"-\")","v":"-"}]
["11-7-21  60% Meth-Ex 2% Fe 1% Mg 1% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G41,0),\"-\")","v":"-"},47.5,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D41=0,\"-\",IF('Putting Greens Nutrition Prog'!H41=0,1,'Putting Greens Nutrition Prog'!H41))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D41=0,0,IF('Putting Greens Nutrition Prog'!$H41=0,1,'Putting Greens Nutrition Prog'!$H41))*'Putting Greens Nutrition Prog'!$G41,0), \"-\")","v":"-"}]
["12-0-24  65% Meth-Ex 1.6% Fe .5% Mg .5% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G42,0),\"-\")","v":"-"},48,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D42=0,\"-\",IF('Putting Greens Nutrition Prog'!H42=0,1,'Putting Greens Nutrition Prog'!H42))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D42=0,0,IF('Putting Greens Nutrition Prog'!$H42=0,1,'Putting Greens Nutrition Prog'!$H42))*'Putting Greens Nutrition Prog'!$G42,0), \"-\")","v":"-"}]
["12-24-8  40% Meth-Ex SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G43,0),\"-\")","v":"-"},47,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D43=0,\"-\",IF('Putting Greens Nutrition Prog'!H43=0,1,'Putting Greens Nutrition Prog'!H43))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D43=0,0,IF('Putting Greens Nutrition Prog'!$H43=0,1,'Putting Greens Nutrition Prog'!$H43))*'Putting Greens Nutrition Prog'!$G43,0), \"-\")","v":"-"}]
["14-7-14  70% Meth-Ex 2% Fe 1.5% Mg 1% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G44,0),\"-\")","v":"-"},47,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D44=0,\"-\",IF('Putting Greens Nutrition Prog'!H44=0,1,'Putting Greens Nutrition Prog'!H44))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D44=0,0,IF('Putting Greens Nutrition Prog'!$H44=0,1,'Putting Greens Nutrition Prog'!$H44))*'Putting Greens Nutrition Prog'!$G44,0), \"-\")","v":"-"}]
["16-0-8  Ammoniacal 1% Fe 1% Mg .5% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G45,0),\"-\")","v":"-"},38,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D45=0,\"-\",IF('Putting Greens Nutrition Prog'!H45=0,1,'Putting Greens Nutrition Prog'!H45))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D45=0,0,IF('Putting Greens Nutrition Prog'!$H45=0,1,'Putting Greens Nutrition Prog'!$H45))*'Putting Greens Nutrition Prog'!$G45,0), \"-\")","v":"-"}]
["18-0-18  64% Meth-Ex 1.6% Fe .5% Mg .5% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G46,0),\"-\")","v":"-"},48,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D46=0,\"-\",IF('Putting Greens Nutrition Prog'!H46=0,1,'Putting Greens Nutrition Prog'!H46))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D46=0,0,IF('Putting Greens Nutrition Prog'!$H46=0,1,'Putting Greens Nutrition Prog'!$H46))*'Putting Greens Nutrition Prog'!$G46,0), \"-\")","v":"-"}]
["18-3-18  78% Meth-Ex 1.5% Fe .65% Mg .5% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G47,0),\"-\")","v":"-"},49,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D47=0,\"-\",IF('Putting Greens Nutrition Prog'!H47=0,1,'Putting Greens Nutrition Prog'!H47))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D47=0,0,IF('Putting Greens Nutrition Prog'!$H47=0,1,'Putting Greens Nutrition Prog'!$H47))*'Putting Greens Nutrition Prog'!$G47,0), \"-\")","v":"-"}]
["20-0-10  40% Meth-Ex SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G48,0),\"-\")","v":"-"},45,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D48=0,\"-\",IF('Putting Greens Nutrition Prog'!H48=0,1,'Putting Greens Nutrition Prog'!H48))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D48=0,0,IF('Putting Greens Nutrition Prog'!$H48=0,1,'Putting Greens Nutrition Prog'!$H48))*'Putting Greens Nutrition Prog'!$G48,0), \"-\")","v":"-"}]
["22-0-16  64% Meth-Ex 1.6% Fe .7% Mg .8% Mn SOP",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G49,0),\"-\")","v":"-"},52,"-",{"$f":"IF('Putting Greens Nutrition Prog'!D49=0,\"-\",IF('Putting Greens Nutrition Prog'!H49=0,1,'Putting Greens Nutrition Prog'!H49))","v":"-"},{"$f":"IFERROR(ROUNDUP(IF('Putting Greens Nutrition Prog'!$D49=0,0,IF('Putting Greens Nutrition Prog'!$H49=0,1,'Putting Greens Nutrition Prog'!$H49))*'Putting Greens Nutrition Prog'!$G49,0), \"-\")","v":"-"}]
[null,null,"Granular Total per 1000 sq.ft.",{"$f":"D19/43.56","v":0}]
[null,null,"Granular Total per Acre",{"$f":"SUM(D9:D17)/Acres","v":0}]
["Application A"]
["Product Name","# of 2.5 Gallon Jugs / Application","Customer                 Case Price ","Product         Cost ","# of Cases Needed Per Season","# of Gallons Needed Per Season"]
["CPR®  4-0-1 ",0,195,{"$f":"IFERROR(B22*(C22/2), \"-\")","v":0},{"$f":"IFERROR(ROUNDUP(B22*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H18*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["True Foliar® K 2-0-16",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H19,0),0)","v":0},190,{"$f":"IFERROR(B23*(C23/2), \"-\")","v":0},{"$f":"IFERROR(ROUNDUP(B23*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H19*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["True Foliar® MgMn 6-0-0",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H20,0),0)","v":0},200,0,{"$f":"IFERROR(ROUNDUP(B24*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H20*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["True Foliar® N 19-1-6",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H21,0),0)","v":0},175,0,{"$f":"IFERROR(ROUNDUP(B25*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H21*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["True Foliar® NK Balance 10-0-10",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H22,0),0)","v":0},105,0,{"$f":"IFERROR(ROUNDUP(B26*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H22*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["PanaSea Plus 0-2-2",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H23,0),0)","v":0},250,0,{"$f":"IFERROR(ROUNDUP(B27*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H23*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["True Foliar® P 6-12-6",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H24,0),0)","v":0},190,0,{"$f":"IFERROR(ROUNDUP(B28*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H24*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["True Foliar® NPK 10-3-16",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H25,0),0)","v":0},215,0,{"$f":"IFERROR(ROUNDUP(B29*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H25*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["True Foliar® Si 3-0-10",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H26,0),0)","v":0},150,0,{"$f":"IFERROR(ROUNDUP(B30*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H26*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["Fairway Fertilizer 30-0-0  (15 gallon drum)",0,205,{"$f":"IFERROR(B31*(C31/6), \"-\")","v":0},{"$f":"IFERROR(ROUNDUP(B31*'Putting Greens Nutrition Prog'!$J$11/6,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H27*15*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
["Fairway SeaQuential® 6-0-2",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!H28,0),0)","v":0},80,0,{"$f":"IFERROR(ROUNDUP(B32*'Putting Greens Nutrition Prog'!$J$11/2,0), \"-\")","v":0},{"$f":"IFERROR('Putting Greens Nutrition Prog'!H28*2.5*'Putting Greens Nutrition Prog'!$J$11,0)","v":0}]
[null,null,"LiquidTotal per 1000 sq.ft.",{"$f":"D34/43.56","v":0}]
[null,null,"Liquid Total per Acre",{"$f":"SUM(D22:D32)/Acres","v":0}]
[]
["Emerald Isle Granular","40 lb. Bags Per Application","Customer Bag Price ","Product         Cost ","# of Applications Per Season","# of Bags Needed for Season"]
["Sand Aid Granular Sea Plant Meal 1-0-1",{"$f":"IFERROR(ROUNDUP('Putting Greens Nutrition Prog'!G54,0), \"-\")","v":"-"},0,{"$f":"IFERROR(C37*F37,\"-\")","v":"-"},{"$f":"IF('Putting Greens Nutrition Prog'!D54=0,0,IF('Putting Greens Nutrition Prog'!H54=0,1,'Putting Greens Nutrition Prog'!H54))","v":0},{"$f":"IFERROR(B37*E37, \"-\")","v":"-"}]
[]
[null,null,"Total cost per Acre",{"$f":"SUM(D42:D43)/Acres","v":0}]
[]
[null,null,null,"By the Case"]
[null,null,"Total Emerald Island Solutions Cost",{"$f":"SUM(C22:C32*E22:E32)","v":0}]
[null,null,"Total Granular Cost",{"$f":"SUM(D8:D17)","v":0}]
[null,null,"Total Emerald Isle Granular Cost",{"$f":"D37","v":"-"}]
[]
[null,null,null,"By the Case"]
[null,null,"Total CC MD / EI Program",{"$f":"SUM(D42:D44)","v":0}]

{"sheet":"Rec Rate","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Cool Season Turf","Warm Season Turf"]
["CPR®  4-0-1 ","6-9 oz / M","6-9 oz / M"]
["True Foliar® K 2-0-16","3-4 oz / M","4-8 oz / M"]
["True Foliar® MgMn 6-0-0","3-4 oz / M","4-8 oz / M"]
["True Foliar® N 19-1-6","3-4 oz / M","4-8 oz / M"]
["True Foliar® NK Balance 10-0-10","6-12 oz / M","6-12 oz / M"]
["PanaSea Plus 0-2-2","2-3 oz / M","2-3 oz / M"]
["True Foliar® P 6-12-6","3-4 oz / M","4-8 oz / M"]
["True Foliar® NPK 10-3-16","3-4 oz / M","4-8 oz / M"]
["True Foliar® Si 3-0-10","3-4 oz / M","4-8 oz / M"]
["Fairway Fertilizer 30-0-0","4-6 oz / M","4-6 oz / M"]
["Fairway SeaQuential® 6-0-2","2-3 oz / M","2-3 oz / M"]