{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Step 1 - Fungicide Planner","Step 2 - Order Planner","Step 2 - OldManage Apps","Step 3 - Review Order","Range Reference","Article Reference","Coverage Reference","Sheet1"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":7,"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":"Step 1 - Fungicide Planner","index":0,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[28,0,29,0],[17,2,18,2],[16,0,16,9],[17,9,18,9],[36,0,45,9],[17,8,18,8],[32,0,33,0],[17,6,18,6],[17,7,18,7],[30,0,31,0],[17,0,18,0],[17,1,18,1],[17,4,18,4],[17,5,18,5],[23,0,24,0],[25,0,26,0],[17,3,18,3],[35,0,35,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Design Your Own Program Fungicide Planner"]
["BASF Brand Name","Case Size","Article No.","Use Area","Acres","Application Rate","Number of Applications","Cases of Product Needed","Cost per Acre\n(before rebate)","Cost per Acre\n(after rebate*)"]
[null,null,null,null,null,null,null,null,null,null,"Article","Rate","Coverage","Cases"]
["Aramax™ Intrinsic®",{"$f":"VLOOKUP(C20,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"2 x 2.5 gal"},59026671,null,0,"43.5 oz",0,{"$f":"IF(M20=0,0,(G20*E20)/M20)","v":0},{"$f":"IF(G20*E20=0,0,(ROUND(H20,2)*VLOOKUP(K20,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G20*E20))","v":0},{"$f":"IF(G20*E20=0,0,((VLOOKUP(K20,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H20,2))/(G20*E20))","v":0},59026671,7,{"$f":"IF(L20=0,0,VLOOKUP(K20,'Coverage Reference'!$B$4:$H$21,L20,FALSE))","v":14.712643678160919},{"$f":"H20","v":0}]
["Aramax™ Intrinsic®","4 x 43.5 fl oz",59032979,null,0,"43.5 oz",0,{"$f":"IF(M21=0,0,(G21*E21)/M21)","v":0},{"$f":"IF(G21*E21=0,0,(ROUND(H21,2)*VLOOKUP(K21,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G21*E21))","v":0},{"$f":"IF(G21*E21=0,0,((VLOOKUP(K21,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H21,2))/(G21*E21))","v":0},59032979,7,{"$f":"IF(L21=0,0,VLOOKUP(K21,'Coverage Reference'!$B$4:$H$21,L21,FALSE))","v":4},{"$f":"H21","v":0}]
["Emerald®",{"$f":"VLOOKUP(C22,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"10 x 0.49 lb"},59021463,null,0,"8.0 oz",0,{"$f":"IF(M22=0,0,(G22*E22)/M22)","v":0},{"$f":"IF(G22*E22=0,0,(ROUND(H22,2)*VLOOKUP(K22,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G22*E22))","v":0},{"$f":"IF(G22*E22=0,0,((VLOOKUP(K22,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H22,2))/(G22*E22))","v":0},59021463,7,{"$f":"IF(L22=0,0,VLOOKUP(K22,'Coverage Reference'!$B$4:$H$21,L22,FALSE))","v":10},{"$f":"H22","v":0}]
["Encartis®",{"$f":"VLOOKUP(C23,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"2 x 2.5 gal"},59014003,null,0,"Select Rate",0,{"$f":"IF(M23=0,0,(G23*E23)/M23)","v":0},{"$f":"IF(G23*E23=0,0,(ROUND(H23,2)*VLOOKUP(K23,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G23*E23))","v":0},{"$f":"IF(G23*E23=0,0,((VLOOKUP(K23,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H23,2))/(G23*E23))","v":0},59014003,{"$f":"IF(F23=\"130.5 fl oz\",5,IF(F23=\"152.5 fl oz\",6,IF(F23=\"174.0 fl oz\",7,)))","v":0},{"$f":"IF(L23=0,0,VLOOKUP(K23,'Coverage Reference'!$B$4:$H$21,L23,FALSE))","v":0},{"$f":"H23","v":0}]
["Honor® Intrinsic®",{"$f":"VLOOKUP(C24,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"6 x 3 lb"},59012350,null,0,"48.0 oz",0,0,{"$f":"IF(G24*E24=0,0,(ROUND(H24,2)*VLOOKUP(K24,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G24*E24))","v":0},{"$f":"IF(G24*E24=0,0,((VLOOKUP(K24,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H24,2))/(G24*E24))","v":0},59012350,7,{"$f":"IF(L24=0,0,VLOOKUP(K24,'Coverage Reference'!$B$4:$H$21,L24,FALSE))","v":6},{"$f":"H24","v":0}]
[null,{"$f":"VLOOKUP(C25,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"1 x 36 lb"},59012885,null,0,"48.0 oz",0,0,{"$f":"IF(G25*E25=0,0,(ROUND(H25,2)*VLOOKUP(K25,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G25*E25))","v":0},{"$f":"IF(G25*E25=0,0,((VLOOKUP(K25,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H25,2))/(G25*E25))","v":0},59012885,7,{"$f":"IF(L25=0,0,VLOOKUP(K25,'Coverage Reference'!$B$4:$H$21,L25,FALSE))","v":12},0]
["Insignia® SC Intrinsic®",{"$f":"VLOOKUP(C26,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"4 x 30.5 fl oz"},59028038,null,0,"30.5 oz",0,0,{"$f":"IF(G26*E26=0,0,(ROUND(H26,2)*VLOOKUP(K26,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G26*E26))","v":0},{"$f":"IF(G26*E26=0,0,((VLOOKUP(K26,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H26,2))/(G26*E26))","v":0},59028038,7,{"$f":"IF(L26=0,0,VLOOKUP(K26,'Coverage Reference'!$B$4:$H$21,L26,FALSE))","v":4},0,"Greens"]
[null,{"$f":"VLOOKUP(C27,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"2 x 2.5 gal"},59028040,null,0,"30.5 oz",0,0,{"$f":"IF(G27*E27=0,0,(ROUND(H27,2)*VLOOKUP(K27,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G27*E27))","v":0},{"$f":"IF(G27*E27=0,0,((VLOOKUP(K27,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H27,2))/(G27*E27))","v":0},59028040,7,{"$f":"IF(L27=0,0,VLOOKUP(K27,'Coverage Reference'!$B$4:$H$21,L27,FALSE))","v":21},0,"Fairways"]
["Lexicon® Intrinsic®",{"$f":"VLOOKUP(C28,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"4 x 21 oz"},59027998,null,0,"21.0 oz",0,0,{"$f":"IF(G28*E28=0,0,(ROUND(H28,2)*VLOOKUP(K28,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G28*E28))","v":0},{"$f":"IF(G28*E28=0,0,((VLOOKUP(K28,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H28,2))/(G28*E28))","v":0},59027998,7,{"$f":"IF(L28=0,0,VLOOKUP(K28,'Coverage Reference'!$B$4:$H$21,L28,FALSE))","v":4},0]
["Maxtima®",{"$f":"VLOOKUP(C29,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"4 x 26 oz"},59018087,null,0,"Select Rate",0,0,{"$f":"IF(G29*E29=0,0,(ROUND(H29,2)*VLOOKUP(K29,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G29*E29))","v":0},{"$f":"IF(G29*E29=0,0,((VLOOKUP(K29,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H29,2))/(G29*E29))","v":0},59018087,{"$f":"IF(F29=\"8.7 oz\",4,IF(F29=\"17.4 oz\",5,IF(F29=\"26.1 oz\",6,IF(F29=\"34.8 oz\",7,0))))","v":0},{"$f":"IF(L29=0,0,VLOOKUP(K29,'Coverage Reference'!$B$4:$H$21,L29,FALSE))","v":0},0]
[null,{"$f":"VLOOKUP(C30,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"2 x 2.5 gal"},59018071,null,0,"Select Rate",0,0,{"$f":"IF(G30*E30=0,0,(ROUND(H30,2)*VLOOKUP(K30,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G30*E30))","v":0},{"$f":"IF(G30*E30=0,0,((VLOOKUP(K30,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H30,2))/(G30*E30))","v":0},59018071,{"$f":"IF(F30=\"8.7 oz\",4,IF(F30=\"17.4 oz\",5,IF(F30=\"26.1 oz\",6,IF(F30=\"34.8 oz\",7,0))))","v":0},{"$f":"IF(L30=0,0,VLOOKUP(K30,'Coverage Reference'!$B$4:$H$21,L30,FALSE))","v":0},0]
["Navicon® Intrinsic®",{"$f":"VLOOKUP(C31,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"4 x 37 fl oz"},59018094,null,0,"37.5 oz",0,0,{"$f":"IF(G31*E31=0,0,(ROUND(H31,2)*VLOOKUP(K31,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G31*E31))","v":0},{"$f":"IF(G31*E31=0,0,((VLOOKUP(K31,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H31,2))/(G31*E31))","v":0},59018094,7,{"$f":"IF(L31=0,0,VLOOKUP(K31,'Coverage Reference'!$B$4:$H$21,L31,FALSE))","v":4},0]
[null,{"$f":"VLOOKUP(C32,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"2 x 2.5 gal"},59018095,null,0,"37.5 oz",0,0,{"$f":"IF(G32*E32=0,0,(ROUND(H32,2)*VLOOKUP(K32,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G32*E32))","v":0},{"$f":"IF(G32*E32=0,0,((VLOOKUP(K32,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H32,2))/(G32*E32))","v":0},59018095,7,{"$f":"IF(L32=0,0,VLOOKUP(K32,'Coverage Reference'!$B$4:$H$21,L32,FALSE))","v":17},0]
["Xzemplar®",{"$f":"VLOOKUP(C33,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"4 x 11.4 oz"},59014120,null,0,"Select Rate",0,0,{"$f":"IF(G33*E33=0,0,(ROUND(H33,2)*VLOOKUP(K33,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G33*E33))","v":0},{"$f":"IF(G33*E33=0,0,((VLOOKUP(K33,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H33,2))/(G33*E33))","v":0},59014120,{"$f":"IF(F33=\"7 oz\",5,IF(F33=\"9.2 oz\",6,IF(F33=\"11.4 oz\",7,0)))","v":0},{"$f":"IF(L33=0,0,VLOOKUP(K33,'Coverage Reference'!$B$4:$H$21,L33,FALSE))","v":0},0]
[null,{"$f":"VLOOKUP(C34,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"2 x 114 oz"},59013833,null,0,"Select Rate",0,0,{"$f":"IF(G34*E34=0,0,(ROUND(H34,2)*VLOOKUP(K34,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE))/(G34*E34))","v":0},{"$f":"IF(G34*E34=0,0,((VLOOKUP(K34,'Step 2 - Order Planner'!$C$26:$D$72,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H34,2))/(G34*E34))","v":0},59013833,{"$f":"IF(F34=\"7 oz\",5,IF(F34=\"9.2 oz\",6,IF(F34=\"11.4 oz\",7,0)))","v":0},{"$f":"IF(L34=0,0,VLOOKUP(K34,'Coverage Reference'!$B$4:$H$21,L34,FALSE))","v":0},0]
[]
["* Cost per Acre after rebate is estimated based on orders in \"Step 2 - Order Planner\" tab"]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2026 Early Order Program.  The calculator is being shared with you for information purposes only and for your private use in preparing your own calculations. While every effort has been made to ensure the accuracy and reliability of the information and formulas, no guarantee is given nor responsibility taken by BASF for the accuracy of the calculator or the applicability to your particular circumstances.\n\nBASF PROVIDES THIS CALCULATOR AND ANY RESULT THEREFROM AS IS WITH ALL FAULTS AND WITH NO WARRANTY WHATSOEVER, EITHER EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY AND FITNESS FOR PARTICULAR PURPOSE.  YOU ASSUME ANY AND ALL RISKS IN USING THE CALCULATOR AND RELYING ON THE INFORMATION CONTAINED HEREIN.  IN NO CIRCUMSTANCES SHALL BASF BE LIABLE FOR ANY DAMAGES WHATSOEVER, INCLUDING BUT NOT LIMITED TO LOSS OF PROFIT, LOSS OF BUSINESS, LOSS OF SAVINGS, OR CONSEQUENTIAL DAMAGES, EVEN IF BASF HAS BEEN NOTIFIED AS SUCH."]

{"sheet":"Step 2 - Order Planner","index":1,"n_rows":79,"n_cols":17,"rows_kept":79,"cut":false,"hidden":false,"merged":[[28,15,29,15],[78,0,87,8],[19,1,19,2],[17,0,18,0],[17,1,18,2],[68,0,68,3],[68,5,68,6],[22,3,22,6],[22,7,22,8],[21,3,21,6],[21,7,21,8],[73,9,73,11],[40,9,40,11],[40,0,40,4],[73,0,73,4],[41,4,71,4],[42,0,42,3],[47,0,47,3],[51,0,51,3],[61,0,61,3],[42,5,42,6],[47,5,47,6],[51,5,51,6],[61,5,61,6],[41,7,73,8],[7,0,7,8],[8,0,8,8],[15,0,15,8],[19,7,19,8],[16,1,16,2],[17,7,17,8],[16,7,16,8],[20,7,20,8],[18,3,18,6],[17,3,17,6],[20,1,20,2],[16,3,16,6],[20,3,20,6],[18,7,18,8],[19,3,19,6],[30,15,31,15],[30,16,31,16],[32,15,33,15],[32,16,33,16],[6,0,6,8],[14,15,14,16],[15,15,16,16],[17,16,18,16],[17,15,18,15],[19,15,20,15],[19,16,20,16],[25,15,27,15],[25,16,27,16],[28,16,29,16],[21,16,22,16],[21,15,22,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upgrade Your DYOP Rebate"]
["EOP Rebate Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Range Reference'!S18=0,\"Buy 3 fungicide brands to qualify\",IF('Range Reference'!S18=1,\"Buy 2 more fungicide brands to qualify\",IF('Range Reference'!S18=2,\"Buy 1 more fungicide brand to qualify\",\"Qualified\")))","v":"Buy 3 fungicide brands to qualify"}]
["DYOP Rebate Program Locked",{"$f":"IF(AND(G41>=3000,'Range Reference'!Q18>=1),\"October Rebate Locked\",IF(AND(J41>=3000,'Range Reference'!S18>=1),\"Nov-Dec Rebate Locked\",\"Rebate Level Not Achieved\"))","v":"Rebate Level Not Achieved"},null,"DYOP Total Purchases",null,null,null,{"$f":"'Article Reference'!G18","v":0}]
["3 or More Fungicide Brands",{"$f":"IF(AND(H17>=3000,'Range Reference'!S18>=3),\"Design Your Own Program Rebate\",\"Need to buy \"&3-'Range Reference'!S18&\" More Brand(s)\")","v":"Need to buy 3 More Brand(s)"},null,"DYOP Rebate",null,null,null,{"$f":"IF(AND(B20=0,B21>0),H17*B21,(B20*H17))","v":0},null,null,null,null,null,null,null,"Spend for Next DYOP Level","Next Level"]
[null,null,null,"Across-the-Course-Solutions Purchases",null,null,null,{"$f":"'Article Reference'!G54","v":0}]
["DYOP Rebate",{"$f":"IF(AND('Range Reference'!S18<3,G41>=3000),0.08,IF(AND('Range Reference'!S18<3,I41>=3000),0.03,'Range Reference'!G16))","v":0},null,"Across-the-Course-Solutions Rebate",null,null,null,{"$f":"(H19*B21)","v":0},null,null,null,null,null,null,null,{"$f":"IF(P16<>\"Qualified\",\"\",HLOOKUP(H17,'Range Reference'!$H$10:$H$16,7,FALSE))","v":""},{"$f":"IF(ISNA(IF(P20=0,\"Max\",VLOOKUP(P20,'Range Reference'!H11:I15,2,FALSE)))=TRUE,\"\",IF(P20=0,\"Max\",VLOOKUP(P20,'Range Reference'!H11:I15,2,FALSE)))","v":""}]
["Across-The-Course Rebate",{"$f":"IF(AND('Range Reference'!S18>=3,H17>=20000),0.12,'Range Reference'!G6)","v":0},null,"TOTAL EOP PURCHASE",null,null,null,{"$f":"H17+H19","v":0}]
["Aramax™ SC Intrinsic® Kicker Rebate",{"$f":"IF((F26+H26)>=1.5,(G26+I26)*Q29,0)","v":0},{"$f":"Q29","v":0},"Total Effective Rebate on All Purchases",null,null,null,{"$f":"IF(H21=0,0,H23/H21)","v":0},null,null,null,null,null,null,null,"Spend for Next ACS Level","Next Level"]
["Tower® Herbicide Fairway Kicker Rebate",{"$f":"IF(F61>=1,(G61*Q33),0)","v":0},{"$f":"Q33","v":0},"TOTAL EOP Rebate",null,null,null,{"$f":"(H18+H20)+(B22+B23)","v":0}]
[]
["Qualifying Fungicide EOP Products","Package","Article No.","Redemption Value","Cases Needed (rounded up to partial cases)","Oct Order (Cases)","Oct Sales","Nov-Dec Order (Cases)","Nov-Dec Sales","Acres Low","Acres Mid","Acres High","roundup","ceiling",null,{"$f":"IF(Q20=\"Max\",0,HLOOKUP(H19,'Range Reference'!$H$19:$H$23,5,FALSE))","v":3000},{"$f":"IF(P25=0,\"Max\",VLOOKUP(P25,'Range Reference'!H20:I22,2,FALSE))","v":0.04}]
[{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Aramax™ Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"2 x 2.5 gal"},59026671,{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$E$17,5,FALSE)","v":5359.7},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C26,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C26,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M26),N26)","v":0},0,{"$f":"D26*F26","v":0},0,{"$f":"H26*D26","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F26+H26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F26+H26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F26+H26))","v":0},2,0.5,null,"Aramax™ Intrinsic® Kicker (bottles)",{"$f":"IF(B22>0,\"Achieved\",\"Buy 3 or more bottles\")","v":"Buy 3 or more bottles"}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Aramax™ Intrinsic brand fungicide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"4 x 43.5 fl oz"},59032979,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$E$17,5,FALSE)","v":1520.76},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C27,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C27,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M27),N27)","v":0},0,{"$f":"D27*F27","v":0},0,0,{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F27+H27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F27+H27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F27+H27))","v":0},2,0.25]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Emerald® fungicide"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"10 x 0.49 lb"},59021463,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$E$17,5,FALSE)","v":1274.0999999999999},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C28,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C28,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M28),N28)","v":0},0,{"$f":"D28*F28","v":0},0,{"$f":"H28*D28","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F28+H28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F28+H28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F28+H28))","v":0},2,1]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Encartis® fungicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"2 x 2.5 gal"},59014003,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$E$17,5,FALSE)","v":698.86},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C29,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C29,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M29),N29)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F29+H29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F29+H29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F29+H29))","v":0},2,0.5,null,{"$f":"'Range Reference'!P22","v":0},{"$f":"IF(P29>=3,0.09,0)","v":0}]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"6 x 3 lb"},59012350,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$E$17,5,FALSE)","v":3625.92},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C30,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C30,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M30),N30)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F30+H30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F30+H30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F30+H30))","v":0},2,{"$f":"1/6","v":0.16666666666666666}]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"1 x 36 lb"},59012885,{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$E$17,5,FALSE)","v":5253.84},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C31,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C31,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M31),N31)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F31+H31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F31+H31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F31+H31))","v":0},0,1,null,"Tower® Herbicide Fairway Kicker (bottles)",{"$f":"IF(B23>0,\"Achieved\",\"Buy 2 or more bottles\")","v":"Buy 2 or more bottles"}]
[{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"4 x 30.5 fl oz"},59028038,{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$E$17,5,FALSE)","v":2366.8000000000002},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C32,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C32,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M32),N32)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F32+H32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F32+H32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F32+H32))","v":0},2,0.25]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"2 x 2.5 gal"},59028040,{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$E$17,5,FALSE)","v":7731.26},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C33,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C33,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M33),N33)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F33+H33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F33+H33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F33+H33))","v":0},2,0.5,null,{"$f":"'Range Reference'!P23","v":0},{"$f":"IF(P33>=2,0.05,0)","v":0}]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"4 x 21 oz"},59027998,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$E$17,5,FALSE)","v":2589.7199999999998},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C34,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C34,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M34),N34)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F34+H34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F34+H34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F34+H34))","v":0},2,0.25]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"4 x 26 oz"},59018087,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$E$17,5,FALSE)","v":983.84},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C35,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C35,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M35),N35)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F35+H35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F35+H35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F35+H35))","v":0},2,0.25]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"2 x 2.5 gal"},59018071,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$E$17,5,FALSE)","v":4845.8599999999997},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C36,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C36,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M36),N36)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F36+H36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F36+H36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F36+H36))","v":0},2,0.5]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"4 x 37 fl oz"},59018094,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$E$17,5,FALSE)","v":2372.44},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C37,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C37,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M37),N37)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F37+H37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F37+H37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F37+H37))","v":0},2,0.25]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"2 x 2.5 gal"},59018095,{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$E$17,5,FALSE)","v":7523.16},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C38,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C38,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M38),N38)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F38+H38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F38+H38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F38+H38))","v":0},2,0.5]
[{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$E$17,5,FALSE)","v":3702.72},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C39,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C39,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M39),N39)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F39+H39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F39+H39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F39+H39))","v":0},2,0.5]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$C$40,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$C$40,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$E$17,5,FALSE)","v":885.56},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C40,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE))=TRUE,\"\",VLOOKUP(C40,'Step 1 - Fungicide Planner'!$K$20:$N$34,4,FALSE)),M40),N40)","v":0},0,{"$f":"D40*F40","v":0},0,{"$f":"H40*D40","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$H$21,4,FALSE)*(F40+H40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$H$21,5,FALSE)*(F40+H40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$H$21,6,FALSE)*(F40+H40))","v":0},2,0.25]
["QUALIFYING FUNGICIDE EOP SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(G26:G40)","v":0},null,{"$f":"SUM(I26:I40)","v":0},{"$f":"I41+G41","v":0}]
["Qualifying EOP Products","Package","Article Number","Redemption Value",null,"EOP Order (Cases)","EOP Sales",null,null,"Acres Low","Acres Mid","Acres High"]
["Insecticides"]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C44,'Article Reference'!$A$5:$E$53,5,FALSE)","v":625},null,0,{"$f":"F44*D44","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F44+H44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F44+H44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F44+H44))","v":0}]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C45,'Article Reference'!$A$5:$E$53,5,FALSE)","v":318.75},null,0,{"$f":"F45*D45","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F45+H45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F45+H45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F45+H45))","v":0}]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C46,'Article Reference'!$A$5:$E$53,5,FALSE)","v":760.52},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F46+H46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F46+H46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F46+H46))","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C47,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C47,'Article Reference'!$A$5:$E$53,5,FALSE)","v":1397.6},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F47+H47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F47+H47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F47+H47))","v":0}]
["Fungicides"]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C49,'Article Reference'!$A$5:$E$53,5,FALSE)","v":472.76},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F49+H49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F49+H49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F49+H49))","v":0}]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C50,'Article Reference'!$A$5:$E$53,5,FALSE)","v":60.75},null,0,{"$f":"F50*D50","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F50+H50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F50+H50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F50+H50))","v":0}]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C51,'Article Reference'!$A$5:$E$53,5,FALSE)","v":112.5},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F51+H51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F51+H51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F51+H51))","v":0}]
["Herbicides"]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C53,'Article Reference'!$A$5:$E$53,5,FALSE)","v":228.13},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F53+H53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F53+H53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F53+H53))","v":0}]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C54,'Article Reference'!$A$5:$E$53,5,FALSE)","v":529.69000000000005},null,0,{"$f":"F54*D54","v":0}]
[{"$f":"VLOOKUP($C55,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"FreeHand® 1.75G CA herbicide"},{"$f":"VLOOKUP($C55,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"1 x 50 lb"},59013674,{"$f":"VLOOKUP($C55,'Article Reference'!$A$5:$E$53,5,FALSE)","v":119},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F55+H55))","v":0},{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F55+H55))","v":0},{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F55+H55))","v":0}]
[{"$f":"VLOOKUP($C56,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C56,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C56,'Article Reference'!$A$5:$E$53,5,FALSE)","v":92},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F56+H56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F56+H56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F56+H56))","v":0}]
[{"$f":"VLOOKUP($C57,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C57,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C57,'Article Reference'!$A$5:$E$53,5,FALSE)","v":52.5},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F57+H57))","v":0},{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F57+H57))","v":0},{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F57+H57))","v":0}]
[{"$f":"VLOOKUP($C58,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C58,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C58,'Article Reference'!$A$5:$E$53,5,FALSE)","v":290.63},null,0,{"$f":"F58*D58","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F58+H58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F58+H58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F58+H58))","v":0}]
[{"$f":"VLOOKUP($C59,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C59,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C59,'Article Reference'!$A$5:$E$53,5,FALSE)","v":1063.6500000000001},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F59+H59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F59+H59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F59+H59))","v":0}]
[{"$f":"VLOOKUP($C60,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C60,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C60,'Article Reference'!$A$5:$E$53,5,FALSE)","v":1595.04},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F60+H60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F60+H60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F60+H60))","v":0}]
[{"$f":"VLOOKUP($C61,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C61,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C61,'Article Reference'!$A$5:$E$53,5,FALSE)","v":2158.3000000000002},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F61+H61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F61+H61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F61+H61))","v":0}]
["Colorants"]
[{"$f":"VLOOKUP($C63,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Admiral® lake colorant"},{"$f":"VLOOKUP($C63,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 1 gal"},59014151,{"$f":"VLOOKUP($C63,'Article Reference'!$A$5:$E$53,5,FALSE)","v":280},null,0,{"$f":"F63*D63","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F63+H63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F63+H63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F63+H63))","v":0}]
[{"$f":"VLOOKUP($C64,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Black Onyx lake & pond colorant"},{"$f":"VLOOKUP($C64,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 1 gal"},59013424,{"$f":"VLOOKUP($C64,'Article Reference'!$A$5:$E$53,5,FALSE)","v":480},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F64+H64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F64+H64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F64+H64))","v":0}]
[{"$f":"VLOOKUP($C65,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Green Lawnger® colorant"},{"$f":"VLOOKUP($C65,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59013430,{"$f":"VLOOKUP($C65,'Article Reference'!$A$5:$E$53,5,FALSE)","v":418.75},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F65+H65))","v":0},{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F65+H65))","v":0},{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F65+H65))","v":0}]
[{"$f":"VLOOKUP($C66,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Green Lawnger® Transition HC colorant"},{"$f":"VLOOKUP($C66,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 1 gal"},59013410,{"$f":"VLOOKUP($C66,'Article Reference'!$A$5:$E$53,5,FALSE)","v":875},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F66+H66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F66+H66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F66+H66))","v":0}]
[{"$f":"VLOOKUP($C67,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Green Lawnger® Transition HC colorant"},{"$f":"VLOOKUP($C67,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"1 x 30 gal"},59023772,{"$f":"VLOOKUP($C67,'Article Reference'!$A$5:$E$53,5,FALSE)","v":2652},null,0,{"$f":"F67*D67","v":0}]
[{"$f":"VLOOKUP($C68,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Green Lawnger® Vision Pro colorant"},{"$f":"VLOOKUP($C68,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 1 gal"},59013342,{"$f":"VLOOKUP($C68,'Article Reference'!$A$5:$E$53,5,FALSE)","v":790},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F68+H68))","v":0},{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F68+H68))","v":0},{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F68+H68))","v":0}]
["Spray Indicators"]
[{"$f":"VLOOKUP($C70,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C70,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"12 x 0.25 gal"},59013723,{"$f":"VLOOKUP($C70,'Article Reference'!$A$5:$E$53,5,FALSE)","v":273.75},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F70+H70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F70+H70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F70+H70))","v":0}]
[{"$f":"VLOOKUP($C71,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C71,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"1 x 30 gal"},59013314,{"$f":"VLOOKUP($C71,'Article Reference'!$A$5:$E$53,5,FALSE)","v":1717.5},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F71+H71))","v":0},{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F71+H71))","v":0},{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F71+H71))","v":0}]
[{"$f":"VLOOKUP($C72,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C72,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59030213,{"$f":"VLOOKUP($C72,'Article Reference'!$A$5:$E$53,5,FALSE)","v":305.63},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$6:$H$21,4,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$6:$H$21,4,FALSE)*(F72+H72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$6:$H$21,5,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$6:$H$21,5,FALSE)*(F72+H72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$6:$H$21,6,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$6:$H$21,6,FALSE)*(F72+H72))","v":0}]
[{"$f":"VLOOKUP($C73,'Article Reference'!$A$5:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C73,'Article Reference'!$A$5:$D$53,3,FALSE)","v":"4 x 1 gal"},59013420,{"$f":"VLOOKUP($C73,'Article Reference'!$A$5:$E$53,5,FALSE)","v":262.5},null,0,{"$f":"F73*D73","v":0}]
["QUALIFYING EOP PRODUCTS SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(G44:G73)","v":0},null,null,{"$f":"G74","v":0}]
[]
[]
[]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2026 Early Order Program.  The calculator is being shared with you for information purposes only and for your private use in preparing your own calculations. While every effort has been made to ensure the accuracy and reliability of the information and formulas, no guarantee is given nor responsibility taken by BASF for the accuracy of the calculator or the applicability to your particular circumstances.\n\nBASF PROVIDES THIS CALCULATOR AND ANY RESULT THEREFROM AS IS WITH ALL FAULTS AND WITH NO WARRANTY WHATSOEVER, EITHER EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY AND FITNESS FOR PARTICULAR PURPOSE.  YOU ASSUME ANY AND ALL RISKS IN USING THE CALCULATOR AND RELYING ON THE INFORMATION CONTAINED HEREIN.  IN NO CIRCUMSTANCES SHALL BASF BE LIABLE FOR ANY DAMAGES WHATSOEVER, INCLUDING BUT NOT LIMITED TO LOSS OF PROFIT, LOSS OF BUSINESS, LOSS OF SAVINGS, OR CONSEQUENTIAL DAMAGES, EVEN IF BASF HAS BEEN NOTIFIED AS SUCH."]

{"sheet":"Step 2 - OldManage Apps","index":2,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[[16,0,16,1],[15,0,15,1],[20,7,20,8],[20,5,20,6],[20,3,20,4],[19,0,19,8],[39,0,46,8],[22,0,23,0],[20,2,21,2],[24,0,25,0],[20,0,21,0],[20,1,21,1],[35,0,36,0],[33,0,34,0],[31,0,32,0],[29,0,30,0],[26,0,27,0]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Enter Acres for your Course (Required)"]
["Fairways & Tees Acres",null,40]
["Greens Acres",null,10]
[]
["Please complete Yellow \"Use Area\" cells with either Fairways or Greens"]
["Fungicide Planner",null,null,null,null,null,null,null,null,null,null,null,"Fairways"]
["Product Name","Case Size","Use Area","Low Rate",null,"Mid Rate",null,"High Rate",null,null,null,null,"Greens"]
[null,null,null,"Total Acres","Applications","Total Acres","Applications","Total Acres","Applications"]
["Emerald","10 x .49 lb.","Fairways",{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K23)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K23)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C23=\"Greens\",D23/$C$17,IF(C23=\"Fairways\",D23/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K23)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K23)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C23=\"Greens\",F23/$C$17,IF(C23=\"Fairways\",F23/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K23)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K23)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C23=\"Greens\",H23/$C$17,IF(C23=\"Fairways\",H23/$C$16,0)))","v":0},null,59021463]
[null,"50 x .49 lb.",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K24)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K24)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K24)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K24)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C24=\"Greens\",F24/$C$17,IF(C24=\"Fairways\",F24/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K24)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K24)","v":0},0,null,59012825]
["Honor","1 x 36 lb",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K25)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K25)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K25)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K25)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C25=\"Greens\",F25/$C$17,IF(C25=\"Fairways\",F25/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K25)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K25)","v":0},0,null,59012885]
[null,"6 x 3 lb",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K26)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K26)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K26)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K26)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K26)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K26)","v":0},0,null,59012350]
["Insignia SC","2 x 2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K27)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K27)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K27)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K27)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C27=\"Greens\",F27/$C$17,IF(C27=\"Fairways\",F27/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K27)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K27)","v":0},0,null,59014135]
[null,"4 x 30.5 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K28)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K28)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K28)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K28)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C28=\"Greens\",F28/$C$17,IF(C28=\"Fairways\",F28/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K28)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K28)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C28=\"Greens\",H28/$C$17,IF(C28=\"Fairways\",H28/$C$16,0)))","v":0},null,59014134]
["Lexicon","4 x 21 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K29)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K29)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K29)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K29)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K29)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K29)","v":0},0,null,59013840]
["Maxtima","4 x26 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K30)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K30)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K30)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K30)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K30)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K30)","v":0},0,null,59018087]
[null,"2x 2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K31)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K31)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K31)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K31)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C31=\"Greens\",F31/$C$17,IF(C31=\"Fairways\",F31/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K31)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K31)","v":0},0,null,59018071]
["Navicon","4x37 fl oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K32)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K32)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K32)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K32)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K32)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K32)","v":0},0,null,59018094]
[null,"2x2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K33)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K33)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K33)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K33)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K33)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K33)","v":0},0,null,59018095]
["Pillar G","15 lbs",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K34)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K34)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K34)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K34)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C34=\"Greens\",F34/$C$17,IF(C34=\"Fairways\",F34/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K34)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K34)","v":0},0,null,59017959]
[null,"30 lbs ",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K35)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K35)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K35)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K35)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K35)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K35)","v":0},0,null,59012784]
["Xzemplar","2 x 114 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K36)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K36)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C36=\"Greens\",D36/$C$17,IF(C36=\"Fairways\",D36/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K36)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K36)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C36=\"Greens\",F36/$C$17,IF(C36=\"Fairways\",F36/$C$16,0)))","v":0},{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K36)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K36)","v":0},{"$f":"IF(OR($C$16=0,$C$17=0),\"Please Enter Acreage\",IF(C36=\"Greens\",H36/$C$17,IF(C36=\"Fairways\",H36/$C$16,0)))","v":0},null,59013833]
[null,"4 x 11.4 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$39,'Step 2 - Order Planner'!$C$26:$C$39,$K37)+SUMIFS('Step 2 - Order Planner'!J$44:J$72,'Step 2 - Order Planner'!$C$44:$C$72,$K37)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$39,'Step 2 - Order Planner'!$C$26:$C$39,$K37)+SUMIFS('Step 2 - Order Planner'!K$44:K$72,'Step 2 - Order Planner'!$C$44:$C$72,$K37)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$39,'Step 2 - Order Planner'!$C$26:$C$39,$K37)+SUMIFS('Step 2 - Order Planner'!L$44:L$72,'Step 2 - Order Planner'!$C$44:$C$72,$K37)","v":0},0,null,59014120]
[]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2020 Early Order Program.  The calculator is being shared with you for information purposes only and for your private use in preparing your own calculations. While every effort has been made to ensure the accuracy and reliability of the information and formulas, no guarantee is given nor responsibility taken by BASF for the accuracy of the calculator or the applicability to your particular circumstances.\n\nBASF PROVIDES THIS CALCULATOR AND ANY RESULT THEREFROM AS IS WITH ALL FAULTS AND WITH NO WARRANTY WHATSOEVER, EITHER EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY AND FITNESS FOR PARTICULAR PURPOSE.  YOU ASSUME ANY AND ALL RISKS IN USING THE CALCULATOR AND RELYING ON THE INFORMATION CONTAINED HEREIN.  IN NO CIRCUMSTANCES SHALL BASF BE LIABLE FOR ANY DAMAGES WHATSOEVER, INCLUDING BUT NOT LIMITED TO LOSS OF PROFIT, LOSS OF BUSINESS, LOSS OF SAVINGS, OR CONSEQUENTIAL DAMAGES, EVEN IF BASF HAS BEEN NOTIFIED AS SUCH."]

{"sheet":"Step 3 - Review Order","index":3,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":false,"merged":[[10,0,11,5],[68,0,77,5],[40,0,40,4],[66,0,66,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[20,3,21,4],[20,5,21,5],[18,3,18,4],[19,3,19,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BASF 2026 EOP ORDER SUMMARY"]
[]
[{"$f":"NOW()","v":"2025-07-15T11:22:01"},null,null,"Rebate Summary"]
["Order For","Order Prepared By",null,"Total Purchase",null,{"$f":"'Step 2 - Order Planner'!H21","v":0}]
["<Enter Customer Name>","<Enter Name>",null,"DYOP Rebate Attained",null,{"$f":"'Step 2 - Order Planner'!B20","v":0}]
["<Enter Business Name>","<Enter Business Name>",null,"Across-The-Course Rebate",null,{"$f":"'Step 2 - Order Planner'!B21","v":0}]
["<City, ST Zip Code>","<City, ST Zip Code>",null,{"$f":"'Step 2 - Order Planner'!A22","v":"Aramax™ SC Intrinsic® Kicker Rebate"},null,{"$f":"'Step 2 - Order Planner'!B22","v":0}]
["<Phone>","<Phone>",null,"Aramax™ SC Intrinsic® % Attained",null,{"$f":"'Step 2 - Order Planner'!C22","v":0}]
["<email address>","<email address>",null,"Tower® Herbicide Fairway Kicker Rebate",null,{"$f":"'Step 2 - Order Planner'!B23","v":0}]
[null,null,null,"Tower® Herbicide Fairway Kicker % Attained",null,{"$f":"'Step 2 - Order Planner'!C23","v":0}]
[null,null,null,"Total EOP Rebate",null,{"$f":"'Step 2 - Order Planner'!H23","v":0}]
[]
["Your Order Detail"]
[]
["Product","Package","Article No.","Redemption Value","Quantity","Total"]
[{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Aramax™ Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59026671,{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$53,4,FALSE)","v":5215},{"$f":"VLOOKUP(C26,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C26,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E26*D26","v":0}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Aramax™ Intrinsic brand fungicide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 43.5 fl oz"},59032979,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$53,4,FALSE)","v":1479},{"$f":"VLOOKUP(C27,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C27,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E27*D27","v":0}]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Emerald® fungicide"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"10 x 0.49 lb"},59021463,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$53,4,FALSE)","v":1239.7},{"$f":"VLOOKUP(C28,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C28,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Encartis® fungicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59014003,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$53,4,FALSE)","v":680},{"$f":"VLOOKUP(C29,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C29,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"6 x 3 lb"},59012350,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$53,4,FALSE)","v":3528},{"$f":"VLOOKUP(C30,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C30,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"1 x 36 lb"},59012885,{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$53,4,FALSE)","v":5112},{"$f":"VLOOKUP(C31,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C31,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 30.5 fl oz"},59028038,{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$53,4,FALSE)","v":2303.36},{"$f":"VLOOKUP(C32,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C32,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59028040,{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$53,4,FALSE)","v":7522.5},{"$f":"VLOOKUP(C33,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C33,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 21 oz"},59027998,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$53,4,FALSE)","v":2520},{"$f":"VLOOKUP(C34,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C34,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 26 oz"},59018087,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$53,4,FALSE)","v":956.8},{"$f":"VLOOKUP(C35,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C35,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59018071,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$53,4,FALSE)","v":4715},{"$f":"VLOOKUP(C36,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C36,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 37 fl oz"},59018094,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$53,4,FALSE)","v":2308.8000000000002},{"$f":"VLOOKUP(C37,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C37,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59018095,{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$53,4,FALSE)","v":7320},{"$f":"VLOOKUP(C38,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C38,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$53,4,FALSE)","v":3602.4},{"$f":"VLOOKUP(C39,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C39,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$53,4,FALSE)","v":861.84},{"$f":"VLOOKUP(C40,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C40,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
["Design-Your-Own-Program Rebate Purchases Sub-Total",null,null,null,null,{"$f":"'Step 2 - Order Planner'!H17","v":0}]
[{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Admiral® lake colorant"},{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 1 gal"},59014151,{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$53,4,FALSE)","v":280},{"$f":"VLOOKUP(C42,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C42,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$53,4,FALSE)","v":625},{"$f":"VLOOKUP(C43,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C43,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Black Onyx lake & pond colorant"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 1 gal"},59013424,{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$53,4,FALSE)","v":480},{"$f":"VLOOKUP(C44,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C44,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$53,4,FALSE)","v":228.13},{"$f":"VLOOKUP(C45,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C45,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$53,4,FALSE)","v":529.69000000000005},{"$f":"VLOOKUP(C46,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C46,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E46*D46","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"FreeHand® 1.75G CA herbicide"},{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"1 x 50 lb"},59013674,{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$53,4,FALSE)","v":116},{"$f":"VLOOKUP(C47,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C47,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Green Lawnger® colorant"},{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59013430,{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$53,4,FALSE)","v":418.75},{"$f":"VLOOKUP(C48,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C48,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Green Lawnger® Transition HC colorant"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 1 gal"},59013410,{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$53,4,FALSE)","v":875},{"$f":"VLOOKUP(C49,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C49,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Green Lawnger® Vision Pro colorant"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 1 gal"},59013342,{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$53,4,FALSE)","v":790},{"$f":"VLOOKUP(C50,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C50,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$53,4,FALSE)","v":460},{"$f":"VLOOKUP(C51,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C51,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$53,4,FALSE)","v":52.5},{"$f":"VLOOKUP(C52,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C52,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$53,4,FALSE)","v":92},{"$f":"VLOOKUP(C53,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C53,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E53*D53","v":0}]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$53,4,FALSE)","v":290.63},{"$f":"VLOOKUP(C54,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C54,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$53,4,FALSE)","v":1035},{"$f":"VLOOKUP(C55,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C55,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E55*D55","v":0}]
[{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$53,4,FALSE)","v":60.75},{"$f":"VLOOKUP(C56,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C56,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$53,4,FALSE)","v":112.5},{"$f":"VLOOKUP(C57,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C57,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$53,4,FALSE)","v":1552},{"$f":"VLOOKUP(C58,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C58,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$53,4,FALSE)","v":318.75},{"$f":"VLOOKUP(C59,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C59,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$53,4,FALSE)","v":740},{"$f":"VLOOKUP(C60,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C60,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$53,4,FALSE)","v":2100},{"$f":"VLOOKUP(C61,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C61,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"12 x 0.25 gal"},59013723,{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$53,4,FALSE)","v":273.75},{"$f":"VLOOKUP(C62,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C62,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"1 x 30 gal"},59013314,{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$53,4,FALSE)","v":1717.5},{"$f":"VLOOKUP(C63,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C63,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"2 x 2.5 gal"},59030213,{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$53,4,FALSE)","v":305.63},{"$f":"VLOOKUP(C64,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C64,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E64*D64","v":0}]
[{"$f":"VLOOKUP($C65,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C65,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 1 gal"},59013420,{"$f":"VLOOKUP($C65,'Article Reference'!$A$3:$D$53,4,FALSE)","v":262.5},{"$f":"VLOOKUP(C65,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C65,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E65*D65","v":0}]
[{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$53,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$53,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$53,4,FALSE)","v":1360},{"$f":"VLOOKUP(C66,'Step 2 - Order Planner'!$C$26:$H$73,4,FALSE)+VLOOKUP(C66,'Step 2 - Order Planner'!$C$26:$H$73,6,FALSE)","v":0},{"$f":"E66*D66","v":0}]
["Across-the-Course-Solutions Rebate Purchase Sub-Total",null,null,null,null,{"$f":"'Step 2 - Order Planner'!H19","v":0}]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2026 Early Order Program.  The calculator is being shared with you for information purposes only and for your private use in preparing your own calculations. While every effort has been made to ensure the accuracy and reliability of the information and formulas, no guarantee is given nor responsibility taken by BASF for the accuracy of the calculator or the applicability to your particular circumstances.\n\nBASF PROVIDES THIS CALCULATOR AND ANY RESULT THEREFROM AS IS WITH ALL FAULTS AND WITH NO WARRANTY WHATSOEVER, EITHER EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY AND FITNESS FOR PARTICULAR PURPOSE.  YOU ASSUME ANY AND ALL RISKS IN USING THE CALCULATOR AND RELYING ON THE INFORMATION CONTAINED HEREIN.  IN NO CIRCUMSTANCES SHALL BASF BE LIABLE FOR ANY DAMAGES WHATSOEVER, INCLUDING BUT NOT LIMITED TO LOSS OF PROFIT, LOSS OF BUSINESS, LOSS OF SAVINGS, OR CONSEQUENTIAL DAMAGES, EVEN IF BASF HAS BEEN NOTIFIED AS SUCH."]

{"sheet":"Range Reference","index":4,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":true,"merged":[[14,16,16,16],[1,16,2,16],[1,17,2,17],[1,18,2,18],[22,2,22,3],[5,18,6,18],[5,17,6,17],[5,16,6,16],[7,18,8,18],[7,17,8,17],[7,16,8,16],[14,18,16,18],[10,18,11,18],[10,17,11,17],[10,16,11,16],[12,18,13,18],[12,17,13,17],[12,16,13,16],[14,17,16,17]]}
["Standard",null,"Oct","Nov-Dec",null,null,null,null,null,null,null,"Article#","Article","Package","Oct Order","Nov-Dec Order","Oct Count","Nov-Dec Count","Total"]
["Low","High","Discount","Discount","Oct Applied",null,"Rebate Applied",null,null,null,null,59026671,{"$f":"VLOOKUP($L2,'Article Reference'!$A$3:$C$17,2,FALSE)","v":"Aramax™ Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($L2,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L2,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L2,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O2+O3>0,1,0)","v":0},{"$f":"IF(P2+P3>0,1,0)","v":0},{"$f":"IF(OR(Q2=1,R2=1),1,0)","v":0}]
[3000,{"$f":"A4-1","v":7999},0.04,0.04,{"$f":"IF(AND(('Step 2 - Order Planner'!$H$19+$E$7)>=3000,'Step 2 - Order Planner'!$H$19+$E$7>=$A3,'Step 2 - Order Planner'!$H$19+$E$7<=$B3),C3)","v":false},null,{"$f":"SUM(E3:F3)","v":0},null,null,null,null,59032979,{"$f":"VLOOKUP($L3,'Article Reference'!$A$3:$C$17,2,FALSE)","v":"Aramax™ Intrinsic brand fungicide"},{"$f":"VLOOKUP($L3,'Article Reference'!$A$3:$C$17,3,FALSE)","v":"4 x 43.5 fl oz"}]
[8000,{"$f":"A5-1","v":19999},0.06,0.06,{"$f":"IF(AND(('Step 2 - Order Planner'!$H$19+$E$7)>=3000,'Step 2 - Order Planner'!$H$19+$E$7>=$A4,'Step 2 - Order Planner'!$H$19+$E$7<=$B4),C4)","v":false},null,{"$f":"SUM(E4:F4)","v":0},null,null,null,null,59021463,{"$f":"VLOOKUP($L4,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Emerald® fungicide"},{"$f":"VLOOKUP($L4,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"10 x 0.49 lb"},{"$f":"VLOOKUP(L4,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L4,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O4>0,1,0)","v":0},0,{"$f":"IF(OR(Q4=1,R4=1),1,0)","v":0}]
[20000,1000000,0.12,0.12,{"$f":"IF(AND(('Step 2 - Order Planner'!$H$19+$E$7)>=3000,'Step 2 - Order Planner'!$H$19+$E$7>=$A5,'Step 2 - Order Planner'!$H$19+$E$7<=$B5),C5)","v":false},null,{"$f":"SUM(E5:F5)","v":0},null,null,null,null,59014003,{"$f":"VLOOKUP($L5,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Encartis® fungicide"},{"$f":"VLOOKUP($L5,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L5,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L5,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,0,{"$f":"IF(OR(Q5=1,R5=1),1,0)","v":0}]
[null,null,"DISCOUNT",null,{"$f":"SUM(E3:E5)","v":0},null,{"$f":"SUM(E6:F6)","v":0},null,null,null,null,59012350,{"$f":"VLOOKUP($L6,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L6,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"6 x 3 lb"},{"$f":"VLOOKUP(L6,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L6,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O6+O7>0,1,0)","v":0},{"$f":"IF(P6+P7>0,1,0)","v":0},{"$f":"IF(OR(Q6=1,R6=1),1,0)","v":0}]
[null,null,null,null,0,null,null,null,null,null,null,59012885,{"$f":"VLOOKUP($L7,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L7,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"1 x 36 lb"},{"$f":"VLOOKUP(L7,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L7,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,59028038,{"$f":"VLOOKUP($L8,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L8,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"4 x 30.5 fl oz"},{"$f":"VLOOKUP(L8,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L8,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O8+O9>0,1,0)","v":0},{"$f":"IF(P8+P9>0,1,0)","v":0},{"$f":"IF(OR(Q8=1,R8=1),1,0)","v":0}]
["DYOP",null,"Oct","Nov-Dec",null,null,null,null,null,null,null,59028040,{"$f":"VLOOKUP($L9,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L9,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L9,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L9,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0}]
["Low","High","Discount","Discount","Oct Applied","Nov-Dec Applied","Rebate Applied",{"$f":"'Step 2 - Order Planner'!H17:I17","v":0},null,null,null,59027998,{"$f":"VLOOKUP($L10,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L10,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"4 x 21 oz"},{"$f":"VLOOKUP(L10,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L10,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O10>0,1,0)","v":0},{"$f":"IF(P10>0,1,0)","v":0},{"$f":"IF(OR(Q10=1,R10=1),1,0)","v":0}]
[3000,{"$f":"A12-1","v":7999},0.08,0.03,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41)>=3000,Q18>=1),C11)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$41)>=3000,S18>=1),D11)","v":false},{"$f":"IF(E11<>FALSE,E11,F11)","v":false},{"$f":"A11-H10","v":3000},0.08,null,null,59018087,{"$f":"VLOOKUP($L11,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($L11,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"4 x 26 oz"},{"$f":"VLOOKUP(L11,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L11,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O11+O12>0,1,0)","v":0},{"$f":"IF(P11+P12>0,1,0)","v":0},{"$f":"IF(OR(Q11=1,R11=1),1,0)","v":0}]
[8000,{"$f":"A13-1","v":19999},0.14000000000000001,0.06,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41)>=3000,$Q$18>=1,'Step 2 - Order Planner'!J41>=$A12,'Step 2 - Order Planner'!J41<=$B12),C12)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$41)>=3000,$S$18>=1,'Step 2 - Order Planner'!J41>=$A12,'Step 2 - Order Planner'!J41<=$B12),D12)","v":false},{"$f":"IF(E12<>FALSE,E12,F12)","v":false},{"$f":"A12-H10","v":8000},0.14000000000000001,null,null,59018071,{"$f":"VLOOKUP($L12,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($L12,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L12,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L12,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0}]
[20000,{"$f":"A14-1","v":29999},0.17,0.09,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41)>=3000,Q18>=1,'Step 2 - Order Planner'!J41>=$A13,'Step 2 - Order Planner'!J41<=$B13),C13)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$41)>=3000,$S$18>=1,'Step 2 - Order Planner'!J41>=$A13,'Step 2 - Order Planner'!J41<=$B13),D13)","v":false},{"$f":"IF(E13<>FALSE,E13,F13)","v":false},{"$f":"A13-H10","v":20000},0.17,null,null,59018094,{"$f":"VLOOKUP($L13,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L13,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"4 x 37 fl oz"},{"$f":"VLOOKUP(L13,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L13,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O13+O14>0,1,0)","v":0},{"$f":"IF(P13+P14>0,1,0)","v":0},{"$f":"IF(OR(Q13=1,R13=1),1,0)","v":0}]
[30000,{"$f":"A15-1","v":39999},0.2,0.1,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41)>=3000,Q18>=1,'Step 2 - Order Planner'!J41>=$A14,'Step 2 - Order Planner'!J41<=$B14),C14)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$41)>=3000,$S$18>=1,'Step 2 - Order Planner'!J41>=$A14,'Step 2 - Order Planner'!J41<=$B14),D14)","v":false},{"$f":"IF(E14<>FALSE,E14,F14)","v":false},{"$f":"A14-H10","v":30000},0.2,null,null,59018095,{"$f":"VLOOKUP($L14,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L14,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L14,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L14,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0}]
[40000,10000000,0.24,0.12,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41)>=3000,Q18>=1,'Step 2 - Order Planner'!J41>=$A15,'Step 2 - Order Planner'!J41<=$B15),C15)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$41)>=3000,$S$18>=1,'Step 2 - Order Planner'!J41>=$A15,'Step 2 - Order Planner'!J41<=$B15),D15)","v":false},{"$f":"IF(E15<>FALSE,E15,F15)","v":false},{"$f":"A15-H10","v":40000},0.24,null,null,59013833,{"$f":"VLOOKUP($L15,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($L15,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"2 x 114 oz"},{"$f":"VLOOKUP(L15,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L15,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"IF(O15+O17>0,1,0)","v":0},{"$f":"IF(P15+P17>0,1,0)","v":0},{"$f":"IF(OR(Q15=1,R15=1),1,0)","v":0}]
[null,null,"DISCOUNT",null,null,null,{"$f":"MAX(G11:G15)","v":0},{"$f":"MIN(IF(H11:H15>0,H11:H15))","v":3000}]
[null,null,null,null,null,null,null,null,null,null,null,59014120,{"$f":"VLOOKUP($L17,'Article Reference'!$A$5:$C$17,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($L17,'Article Reference'!$A$5:$C$17,3,FALSE)","v":"4 x 11.4 oz"},{"$f":"VLOOKUP(L17,'Step 2 - Order Planner'!$C$26:$F$40,4,FALSE)","v":0},{"$f":"VLOOKUP(L17,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0}]
["Table B for Fungicides",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q17)","v":0},{"$f":"SUM(R2:R17)","v":0},{"$f":"SUM(S2:S17)","v":0}]
["Low","High","Discount","Discount",null,null,"Rebate Applied",{"$f":"'Step 2 - Order Planner'!H19:I19","v":0}]
[3000,{"$f":"A21-1","v":7999},0.04,0.04,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74)>=3000,'Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74>=$A20,'Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74<=$B20,S18<=3),C20)","v":false},{"$f":"IF(AND(SUM('Step 2 - Order Planner'!G26:G39)>=3000,SUM('Step 2 - Order Planner'!G26:G39)<8000),0.04,0)","v":0},{"$f":"SUM(E20:F20)","v":0},{"$f":"A20-$H$19","v":3000},0.04]
[8000,{"$f":"A22-1","v":19999},0.06,0.06,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74)>=3000,'Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74>=$A21,'Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74<=$B21,S18<=3),C21)","v":false},null,{"$f":"SUM(E21:F21)","v":0},{"$f":"A21-$H$19","v":8000},0.06,null,null,"Article Number","Qaulifying Non-Agency Products","Package","Quantity Ordered","Conv. to bottle"]
[20000,1000000,0.12,0.12,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74)>=3000,'Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74>=$A22,'Step 2 - Order Planner'!$G$41+'Step 2 - Order Planner'!$I$41+'Step 2 - Order Planner'!$G$74<=$B22,S18<=3),C22)","v":false},null,{"$f":"SUM(E22:F22)","v":0},{"$f":"A22-$H$19","v":20000},0.12,null,null,59026671,"Aramax™ Intrinsic® Brand Fungicide","2 x 2.5 gal",{"$f":"'Step 2 - Order Planner'!F26+'Step 2 - Order Planner'!H26","v":0},{"$f":"O22*2","v":0}]
[null,null,"DISCOUNT",null,{"$f":"SUM(E20:E22)","v":0},{"$f":"SUM(F20:F22)","v":0},{"$f":"SUM(E23:F23)","v":0},{"$f":"MIN(IF(H20:H22>0,H20:H22))","v":3000},null,null,null,59014247,"Tower® herbicide","2 x 2.5 gal",{"$f":"'Step 2 - Order Planner'!F61","v":0},{"$f":"O23*2","v":0}]

{"sheet":"Article Reference","index":5,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,0,0,4],[18,0,18,4]]}
["2026 Qualifying Fungicides"]
["Article Number","Qaulifying Non-Agency Products","Package","Price","CA Redemption","Volume","Rebae Sales Total","Case UOM","Price/UOM","Case Price"]
[59026671,"Aramax™ Intrinsic® brand Fungicide","2 x 2.5 gal",5215,5359.7,{"$f":"VLOOKUP($A3,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A3,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"F3*D3","v":0},5,{"$f":"J3/H3","v":1043},{"$f":"D3","v":5215}]
[59032979,"Aramax™ Intrinsic brand fungicide","4 x 43.5 fl oz",1479,1520.76,{"$f":"VLOOKUP($A4,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A4,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},{"$f":"F4*D4","v":0},{"$f":"4*43.5","v":174},{"$f":"J4/H4","v":8.5},{"$f":"D4","v":1479}]
[59021463,"Emerald® fungicide","10 x 0.49 lb",1239.7,1274.0999999999999,{"$f":"VLOOKUP($A5,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A5,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"10*0.49","v":4.9000000000000004},{"$f":"J5/H5","v":253},{"$f":"D5","v":1239.7}]
[59014003,"Encartis® fungicide","2 x 2.5 gal",680,698.86,{"$f":"VLOOKUP($A6,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A6,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"2*2.5","v":5},{"$f":"J6/H6","v":136},{"$f":"D6","v":680}]
[59012350,"Honor® Intrinsic® brand fungicide","6 x 3 lb",3528,3625.92,{"$f":"VLOOKUP($A7,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A7,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"6*3","v":18},196,3528]
[59012885,"Honor® Intrinsic® brand fungicide","1 x 36 lb",5112,5253.84,{"$f":"VLOOKUP($A8,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A8,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,36,142,5112]
[59028038,"Insignia® SC Intrinsic® brand fungicide","4 x 30.5 fl oz",2303.36,2366.8000000000002,{"$f":"VLOOKUP($A9,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A9,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"4*30.5","v":122},18.880000000000003,2303.36]
[59028040,"Insignia® SC Intrinsic® brand fungicide","2 x 2.5 gal",7522.5,7731.26,{"$f":"VLOOKUP($A10,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A10,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,5,1504.5,7522.5]
[59027998,"Lexicon® Intrinsic® brand fungicide","4 x 21 oz",2520,2589.7199999999998,{"$f":"VLOOKUP($A11,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A11,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"4*21","v":84},30,2520]
[59018087,"Maxtima® fungicide","4 x 26 oz",956.8,983.84,{"$f":"VLOOKUP($A12,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A12,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"4*26","v":104},9.1999999999999993,956.8]
[59018071,"Maxtima® fungicide","2 x 2.5 gal",4715,4845.8599999999997,{"$f":"VLOOKUP($A13,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A13,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,5,943,4715]
[59018094,"Navicon® Intrinsic® brand fungicide","4 x 37 fl oz",2308.8000000000002,2372.44,{"$f":"VLOOKUP($A14,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A14,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"4*37","v":148},15.600000000000001,2308.8000000000002]
[59018095,"Navicon® Intrinsic® brand fungicide","2 x 2.5 gal",7320,7523.16,{"$f":"VLOOKUP($A15,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A15,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,5,1464,7320]
[59013833,"Xzemplar® fungicide","2 x 114 oz",3602.4,3702.72,{"$f":"VLOOKUP($A16,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A16,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"2*114","v":228},15.8,3602.4]
[59014120,"Xzemplar® fungicide","4 x 11.4 oz",861.84,885.56,{"$f":"VLOOKUP($A17,'Step 2 - Order Planner'!$C$26:$H$40,4,FALSE)+VLOOKUP($A17,'Step 2 - Order Planner'!$C$26:$H$40,6,FALSE)","v":0},0,{"$f":"4*11.4","v":45.6},18.899999999999999,861.84]
[null,null,null,{"$f":"SUM(D3:D17)","v":49364.4},{"$f":"SUM(E3:E17)","v":50734.539999999994},null,{"$f":"SUM(G3:G17)","v":0}]
["2026 Rest of Portfolio"]
["Article Number","Qaulifying Non-Agency Products","Package","Price","CA Redemption"]
[59014151,"Admiral® lake colorant","4 x 1 gal",280,280,{"$f":"VLOOKUP(A21,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},{"$f":"F21*D21","v":0},4,{"$f":"J21/H21","v":70},{"$f":"D21","v":280}]
[59024020,"Alucion® 35 WG insecticide","10 x 2.375 lbs",2636.3,"NO CA",0,{"$f":"F22*D22","v":0},{"$f":"10*38","v":380},6.9376315789473688,2636.3]
[59021451,"Amdro Pro Fire Ant Bait","1 x 25lbs",625,625,{"$f":"VLOOKUP(A23,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,25,25,625]
[59011636,"Basagran® herbicide","2 x 1 gal",127.5,"NO CA",0,0,2,63.75,127.5]
[59013424,"Black Onyx lake & pond colorant","4 x 1 gal",480,480,{"$f":"VLOOKUP(A25,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,4,120,480]
[59011404,"Drive® XLR8 herbicide","4 x 0.5 gal",228.13,228.13,{"$f":"VLOOKUP(A26,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,{"$f":"4*0.5","v":2},114.065,228.13]
[59018043,"Drive® XLR8 herbicide","2 x 2.5 gal",529.69000000000005,529.69000000000005,{"$f":"VLOOKUP(A27,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,null,null,529.69000000000005]
[59024131,"Finale®  XL T&O herbicide ","2 x 2.5 gal",null,null,null,0,5,{"$f":"J28/H28","v":0},0,null,"<--","Discontinued ???"]
[59013674,"FreeHand® 1.75G CA herbicide","1 x 50 lb",116,119,{"$f":"VLOOKUP(A29,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,50,2.3199999999999998,116,null,59013674,"FreeHand® 1.75G CA herbicide","1 x 50 lb"]
[59013430,"Green Lawnger® colorant","2 x 2.5 gal",418.75,418.75,{"$f":"VLOOKUP(A30,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,5,83.75,418.75]
[59013410,"Green Lawnger® Transition HC colorant","4 x 1 gal",875,875,{"$f":"VLOOKUP(A31,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,4,218.75,875]
[59023772,"Green Lawnger® Transition HC colorant","1 x 30 gal",2652,2652,{"$f":"VLOOKUP(A32,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,1,2652,2652]
[59013342,"Green Lawnger® Vision Pro colorant","4 x 1 gal",790,790,{"$f":"VLOOKUP(A33,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,4,197.5,790]
[59020732,"Insignia® SC Intrinsic® brand fungicide","4 x 122 oz",null,{"$f":"D34","v":0},null,0,{"$f":"4*122","v":488},0,0,null,"<--","Discontinued"]
[59014379,"Orkestra® Intrinsic® brand Fungicide","4 x 16 oz",684.8,"NO CA",0,0,{"$f":"4*16","v":64},10.7,684.8]
[59012349,"Pageant® Intrinsic® brand Fungicide","4 x 1 lb",460,472.76,{"$f":"VLOOKUP(A36,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,4,115,460]
[59017972,"Pendulum® 2G herbicide","20 lbs bag",52.5,52.5,{"$f":"VLOOKUP(A37,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,20,2.625,52.5]
[59015072,"Pendulum® 2G herbicide","40 lbs bag",92,92,{"$f":"VLOOKUP(A38,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,40,2.2999999999999998,92]
[59049276,"Pendulum® AquaCap herbicide","2 x 2.5 gal",290.63,290.63,{"$f":"VLOOKUP(A39,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,5,58.125999999999998,290.63]
[59011279,"Pendulum® AquaCap herbicide","1 x 15 gal",1035,1063.6500000000001,{"$f":"VLOOKUP(A40,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,15,69,1035]
[59017959,"Pillar® G Intrinsic® brand fungicide","15 lbs bag",60.75,60.75,{"$f":"VLOOKUP(A41,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,15,4.05,60.75]
[59012784,"Pillar® G Intrinsic® brand fungicide","30 lbs bag",112.5,112.5,{"$f":"VLOOKUP(A42,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,30,3.75,112.5]
[59026395,"Pillar® SC Intrinsic brand fungicide","4 x 43.5 oz",0,{"$f":"D43","v":0},0,0,{"$f":"4*43.5","v":174},0,0,null,"<--","lawn care only"]
[59018005,"Pylex® herbicide","4 x 4 oz",1552,1595.04,{"$f":"VLOOKUP(A44,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,16,97,1552]
[59014427,"Segment® II herbicide","2 x 2.5 gal",1706.25,"NO CA",0,0,5,341.25,1706.25]
[59011057,"Siesta® Fire Ant Bait","15 lbs",318.75,318.75,{"$f":"VLOOKUP(A46,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,15,21.25,318.75]
[59023753,"Sultan® miticide","4 x 0.125 gal",740,760.52,{"$f":"VLOOKUP(A47,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,{"$f":"4*0.125","v":0.5},1480,740]
[59014247,"Tower® herbicide","2 x 2.5 gal",2100,2158.3000000000002,{"$f":"VLOOKUP(A48,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,5,420,2100]
[59013723,"Turf Mark spray indicator - blue","12 x 0.25 gal",273.75,273.75,{"$f":"VLOOKUP(A49,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,{"$f":"12*0.25","v":3},91.25,273.75,null,"x"]
[59013314,"Turf Mark spray indicator - blue","1 x 30 gal",1717.5,1717.5,{"$f":"VLOOKUP(A50,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,30,57.25,1717.5,null,"x"]
[59030213,"Turf Mark spray indicator - blue","2 x 2.5 gal",305.63,305.63,{"$f":"VLOOKUP(A51,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,5,61.125999999999998,305.63]
[59013420,"Turf Mark spray indicator - blue","4 x 1 gal",262.5,262.5,{"$f":"VLOOKUP(A52,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,4,65.625,262.5,null,"<--","Discontinued"]
[59014680,"Ventigra® insecticide","4 x 20 oz",1360,1397.6,{"$f":"VLOOKUP(A53,'Step 2 - Order Planner'!$C$44:$F$73,4,FALSE)","v":0},0,{"$f":"4*20","v":80},17,1360]
[null,null,null,{"$f":"SUM(D21:D53)","v":22882.93},{"$f":"SUM(E21:E53)","v":17931.949999999997},null,{"$f":"SUM(G21:G53)","v":0}]

{"sheet":"Coverage Reference","index":6,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":true,"merged":[[1,0,1,1]]}
["Calculator Acreage"]
["Acre Coverage",null,null,null,4,5,6,7]
["Product Name","Article #","Package Size","Price/Case","Low Rate","Mid Rate","Mid2 Rate","High rate",null,null,"Low Rate","Mid Rate","High rate"]
["Aramax™ Intrinsic® Brand Fungicide",59026671,"2 x 2.5 gal",null,null,null,null,{"$f":"640/43.5","v":14.712643678160919},null,null,null,null,{"$f":"640/43.5","v":14.712643678160919}]
["Aramax™ Intrinsic® Brand Fungicide",59032979,"4 x 43.5 fl oz",null,null,null,null,{"$f":"174/43.5","v":4},null,null,null,null,{"$f":"174/43.5","v":4}]
["Emerald® Fungicide",59021463,"10 x .49 lb.",null,null,null,null,10,null,null,13.9,12,10,null,null,null,5,"gal"]
["Emerald® Fungicide",59012825,"50 x .49 lb.",null,null,null,null,50,null,null,69.3,60,50,null,null,null,640,"foz"]
["Encartis® fungicide",59014003,"2 x 2.5 gal",null,null,4.9000000000000004,4.2,3.7,null,null,99,99,99]
["Honor® Intrinsic™ brand Fungicide",59012885,"1 x 36 lb",null,null,null,null,12,null,null,24,18,12,null,null,null,{"$f":"4*43.5","v":174}]
["Honor® Intrinsic™ brand Fungicide",59012350,"6 x 3 lb",null,null,null,null,6,null,null,12,9,6]
["Insignia® SC Intrinsic™ brand Fungicide",59028040,"2 x 2.5 gal",null,null,null,null,21,null,null,36.799999999999997,28.9,21,null,null,null,{"$f":"Q7/Q9","v":3.6781609195402298}]
["Insignia® SC Intrinsic™ brand Fungicide",59028038,"4 x 30.5 oz",null,null,null,null,4,null,null,7,5.5,4]
["Lexicon® Intrinsic™ Brand Fungicide",59027998,"4 x 21 oz",null,null,null,null,4,null,null,5.68,4.84,4]
["Maxtima® Fungicide",59018087,"4 x26 oz",null,12,6,4,3,null,null,12,6,3]
["Maxtima Fungicide",59018071,"2 x 2.5 gal",null,73.5,36,24.6,18,null,null,73.5,36,18]
["Navicon® Intrinsic™ brand Fungicide",59018094,"4 x 37 fl oz",null,null,null,null,4,null,null,null,5,4]
["Navicon Intrinsic™ brand Fungicide",59018095,"2 x 2.5 gal",null,null,null,null,17,null,null,null,21,17]
["Pillar G Intrinsic™",59017959,"15 lbs",null,null,null,null,null,null,null,0.11,0.11,0.11]
["Pillar G Intrinsic™",59012784,"30 lbs ",null,null,null,null,null,null,null,0.22,0.22,0.22]
["Xzemplar™ Fungicide",59013833,"2 x 114 oz",null,null,32.799999999999997,25,20,null,null,32.799999999999997,24.95,20]
["Xzemplar™Fungicide",59014120,"4 x 11.4 oz",null,null,6.6,5,4,null,null,6.6,5,4]
[]
[]
["Brand","Rate","Rate Level Above",null,43.5]
["Aramax","43.5 oz"]
["Emerald",{"$f":"\"8.0\"&\" \"&F26","v":"8.0 oz"},"All",0.18,{"$f":"D26*$E$24","v":7.83},"oz",null,null,null,null,null,null,{"$f":"5*128","v":640},{"$f":"M26/43.6","v":14.678899082568806}]
["Encartis","Select Rate"]
["Encartis","130.5 fl oz",5]
["Encartis","152.5 fl oz",6,null,null,null,null,null,null,null,null,null,{"$f":"5*128","v":640}]
["Encartis","174.0 fl oz",7,null,null,null,null,null,null,null,null,null,{"$f":"M29/43.6","v":14.678899082568806}]
["Honor",{"$f":"\"48.0\"&\" \"&F31","v":"48.0 oz"},"All",1.1000000000000001,{"$f":"D31*$E$24","v":47.85},"oz"]
["Insignia",{"$f":"30.5&\" \"&F32","v":"30.5 oz"},"All",0.7,{"$f":"D32*$E$24","v":30.45},"oz"]
["Lexicon",{"$f":"\"21.0\"&\" \"&F33","v":"21.0 oz"},"All",0.47,{"$f":"D33*$E$24","v":20.445},"oz",null,null,null,null,null,null,{"$f":"0.07*M26","v":44.800000000000004}]
["Navicon",{"$f":"37.5&\" \"&F34","v":"37.5 oz"},"All",0.85,{"$f":"D34*$E$24","v":36.975000000000001},"oz"]
["Maxtima","Select Rate",null,null,null,null,null,null,null,null,null,null,{"$f":"0.07*M26","v":44.800000000000004}]
["Maxtima",{"$f":"E36&\" \"&F36","v":"8.7 oz"},4,0.2,{"$f":"D36*$E$24","v":8.7000000000000011},"oz"]
["Maxtima","17.4 oz",5,0.4,{"$f":"D37*$E$24","v":17.400000000000002},"oz"]
["Maxtima","26.1 oz",6,0.6,{"$f":"D38*$E$24","v":26.099999999999998},"oz",null,null,null,null,null,null,{"$f":"640/43.6","v":14.678899082568806}]
["Maxtima","34.8 oz",7,0.8,{"$f":"D39*$E$24","v":34.800000000000004},"oz"]
["Xzemplar ","Select Rate"]
["Xzemplar ",{"$f":"E41&\" \"&F41","v":"7 oz"},5,null,7,"oz"]
["Xzemplar ",{"$f":"E42&\" \"&F42","v":"9.2 oz"},6,0.21,9.1999999999999993,"oz"]
["Xzemplar ",{"$f":"E43&\" \"&F43","v":"11.4 oz"},7,0.26,11.4,"oz"]

{"sheet":"Sheet1","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,6,1,7],[1,1,1,4],[2,4,3,4],[6,7,8,7],[7,6,8,6],[2,1,3,1],[2,2,2,3],[2,6,3,6]]}
[]
[null,"Design Your Own Program (DYOP)",null,null,null,null,"Across the Course Solutions (ACS)"]
[null,"Qualifying Fungicide Purchase Level (DYOP)","Earned Incentive %",null,"DYOP Brand Requirements",null,"Qualifying EOP Purchase Level (Excluding DYOP Fungicides)","Earned Incentive %"]
[null,null,"Oct. 1-31, 2025","Nov. 1-Dec. 5, 2025",null,null,null,"Oct.1-Dec. 1, 2025"]
[null,"$3,000-$7,999 (Par)",0.08,0.03,"One (1) Qualifying Brand",null,"$3,000-$7,999",0.04]
[null,"$8,000-$19,999 (Birdie)",0.14000000000000001,0.06,"Three (3) Qualifying Brands",null,"$8,000-$19,999",0.06]
[null,"$20,000-$29,999 (Eagle)","17% (+12% on ACS brands)","9% (+12% on ACS brands)","Three (3) Qualifying Brands",null,"$20,000+",0.12]
[null,"$30,000-$39,999 (Albatross)","20% (+12% on ACS brands)","10% (+12% on ACS brands)","Three (3) Qualifying Brands",null,"(Eagle, Albatross, Ace DYOP customers  automatically qualify for this tier)"]
[null,"$40,000+ (Ace)","24% (+12% on ACS brands)","12% (+12% on ACS Brands)","Three (3) Qualifying Brands"]