{"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":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,0,16,9],[17,9,18,9],[26,0,35,9],[17,8,18,8],[22,0,23,0],[17,6,18,6],[17,7,18,7],[17,0,18,0],[17,1,18,1],[17,4,18,4],[17,5,18,5],[19,0,20,0],[17,3,18,3],[25,0,25,9],[17,2,18,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["Insignia® SC Intrinsic®",{"$f":"VLOOKUP(C20,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,null,0,"30.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$53,2,FALSE))/(G20*E20))","v":0},{"$f":"IF(G20*E20=0,0,((VLOOKUP(K20,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H20,2))/(G20*E20))","v":0},59014134,7,{"$f":"IF(L20=0,0,VLOOKUP(K20,'Coverage Reference'!$B$4:$H$20,L20,FALSE))","v":4},{"$f":"H20","v":0},"Lawn"]
[null,{"$f":"VLOOKUP(C21,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"2 x 2.5 gal"},59014135,null,0,"30.5 oz",0,0,{"$f":"IF(G21*E21=0,0,(ROUND(H21,2)*VLOOKUP(K21,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE))/(G21*E21))","v":0},{"$f":"IF(G21*E21=0,0,((VLOOKUP(K21,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H21,2))/(G21*E21))","v":0},59014135,7,{"$f":"IF(L21=0,0,VLOOKUP(K21,'Coverage Reference'!$B$4:$H$20,L21,FALSE))","v":21},0]
["Lexicon® Intrinsic®",{"$f":"VLOOKUP(C22,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"4 x 21 oz"},59027998,null,0,"21.0 oz",0,0,{"$f":"IF(G22*E22=0,0,(ROUND(H22,2)*VLOOKUP(K22,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE))/(G22*E22))","v":0},{"$f":"IF(G22*E22=0,0,((VLOOKUP(K22,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H22,2))/(G22*E22))","v":0},59027998,7,{"$f":"IF(L22=0,0,VLOOKUP(K22,'Coverage Reference'!$B$4:$H$20,L22,FALSE))","v":4},0]
["Xzemplar®",{"$f":"VLOOKUP(C23,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"4 x 11.4 oz"},59014120,null,0,"Select Rate",0,0,{"$f":"IF(G23*E23=0,0,(ROUND(H23,2)*VLOOKUP(K23,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE))/(G23*E23))","v":0},{"$f":"IF(G23*E23=0,0,((VLOOKUP(K23,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H23,2))/(G23*E23))","v":0},59014120,{"$f":"IF(F23=\"9.135 oz\",6,IF(F23=\"11.31 oz\",7,0))","v":0},{"$f":"IF(L23=0,0,VLOOKUP(K23,'Coverage Reference'!$B$4:$H$20,L23,FALSE))","v":0},0]
[null,{"$f":"VLOOKUP(C24,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"2 x 114 oz"},59013833,null,0,"Select Rate",0,0,{"$f":"IF(G24*E24=0,0,(ROUND(H24,2)*VLOOKUP(K24,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE))/(G24*E24))","v":0},{"$f":"IF(G24*E24=0,0,((VLOOKUP(K24,'Step 2 - Order Planner'!$C$26:$D$53,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H24,2))/(G24*E24))","v":0},59013833,{"$f":"IF(F24=\"9.135 oz\",6,IF(F24=\"11.31 oz\",7,0))","v":0},{"$f":"IF(L24=0,0,VLOOKUP(K24,'Coverage Reference'!$B$4:$H$20,L24,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 2025 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":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[21,16,22,16],[21,15,22,15],[14,15,14,16],[15,15,16,16],[17,16,18,16],[17,15,18,15],[19,15,20,15],[19,16,20,16],[58,0,67,8],[17,0,18,0],[17,1,18,2],[22,3,22,6],[22,7,22,8],[21,3,21,6],[21,7,21,8],[19,0,20,0],[19,1,20,2],[21,0,22,0],[21,1,22,2],[53,9,53,11],[30,9,30,11],[30,0,30,4],[53,0,53,4],[31,4,52,4],[32,0,32,3],[37,0,37,3],[43,0,43,3],[32,5,32,6],[37,5,37,6],[43,5,43,6],[6,0,6,8],[31,7,53,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],[16,3,16,6],[20,3,20,6],[18,7,18,8],[19,3,19,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upgrade Your Fungicide Rebate"]
["EOP Rebate Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Range Reference'!S17=0,\"Buy 3 fungicide brands to qualify\",IF('Range Reference'!S17=1,\"Buy 2 more fungicide brands to qualify\",IF('Range Reference'!S17=2,\"Buy 1 more fungicide brand to qualify\",\"Qualified\")))","v":"Buy 3 fungicide brands to qualify"}]
["Agency Fungicide Rebate Program Locked",{"$f":"IF(AND(G31>=3000,'Range Reference'!Q17>=1),\"October Rebate Locked\",IF(AND(J31>=3000,'Range Reference'!S17>=1),\"Nov-Dec Rebate Locked\",\"Rebate Level Not Achieved\"))","v":"Rebate Level Not Achieved"},null,"Fungicide Total Purchases",null,null,null,{"$f":"'Article Reference'!G8","v":0}]
["3 or More Fungicide Brands",{"$f":"IF(AND(H17>=3000,'Range Reference'!S17>=3),\"Design Your Own Program Rebate\",\"Need to buy \"&3-'Range Reference'!S17&\" More Brand(s)\")","v":"Need to buy 3 More Brand(s)"},null,"Agency Fungicide Rebate",null,null,null,{"$f":"IF(AND(B20=0,B22>0),H17*B22,(B20*H17))","v":0},null,null,null,null,null,null,null,"Spend for Next Fungicide Level","Next Level"]
[null,null,null,"Across-the-Lawn-Solutions Purchases",null,null,null,{"$f":"'Article Reference'!G43","v":0}]
["Agency Fungicide Rebate",{"$f":"IF(AND('Range Reference'!S17<3,G31>=3000),0.08,IF(AND('Range Reference'!S17<3,I31>=3000),0.03,'Range Reference'!G16))","v":0},null,"Across-the-Lawn-Solutions Rebate",null,null,null,{"$f":"(H19*B22)","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":""}]
[null,null,null,"TOTAL EOP PURCHASE",null,null,null,{"$f":"H17+H19","v":0}]
["Across-The-Lawn Rebate",{"$f":"IF(AND('Range Reference'!S17>=3,H17>=20000),0.12,'Range Reference'!G6)","v":0},null,"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\nAcross the Lawn Level","Next Level"]
[null,null,null,"TOTAL EOP Rebate",null,null,null,{"$f":"(H18+H20)","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$29,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$C$29,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$E$7,5,FALSE)","v":2305.8000000000002},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C26,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE))=TRUE,\"\",VLOOKUP(C26,'Step 1 - Fungicide Planner'!$K$20:$N$24,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$20,4,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$20,4,FALSE)*(F26+H26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$20,5,FALSE)*(F26+H26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$20,6,FALSE)*(F26+H26))","v":0},1,{"$f":"1/4","v":0.25}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$C$29,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$C$29,3,FALSE)","v":"2 x 2.5 gal"},59014135,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$E$7,5,FALSE)","v":7535.4},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C27,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE))=TRUE,\"\",VLOOKUP(C27,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE)),M27),N27)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$20,4,FALSE)*(F27+H27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$20,5,FALSE)*(F27+H27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$20,6,FALSE)*(F27+H27))","v":0},2,{"$f":"0.5","v":0.5}]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$C$29,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$C$29,3,FALSE)","v":"4 x 21 oz"},59027998,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$E$7,5,FALSE)","v":2531.7600000000002},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C28,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE))=TRUE,\"\",VLOOKUP(C28,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE)),M28),N28)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$20,4,FALSE)*(F28+H28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$20,5,FALSE)*(F28+H28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$20,6,FALSE)*(F28+H28))","v":0},2,{"$f":"0.25","v":0.25}]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$C$29,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$C$29,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$E$7,5,FALSE)","v":3611.52},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C29,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE))=TRUE,\"\",VLOOKUP(C29,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE)),M29),N29)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$20,4,FALSE)*(F29+H29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$20,5,FALSE)*(F29+H29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$20,6,FALSE)*(F29+H29))","v":0},1,0.5]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$C$29,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$C$29,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$E$7,5,FALSE)","v":841.76},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C30,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE))=TRUE,\"\",VLOOKUP(C30,'Step 1 - Fungicide Planner'!$K$20:$N$24,4,FALSE)),M30),N30)","v":0},0,{"$f":"D30*F30","v":0},0,{"$f":"H30*D30","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$20,4,FALSE)*(F30+H30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$20,5,FALSE)*(F30+H30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$20,6,FALSE)*(F30+H30))","v":0},1,{"$f":"0.25","v":0.25}]
["QUALIFYING FUNGICIDE EOP SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(G26:G30)","v":0},null,{"$f":"SUM(I26:I30)","v":0},{"$f":"I31+G31","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($C34,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$E$42,5,FALSE)","v":593.75},null,0,{"$f":"F34*D34","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F34+H34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F34+H34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F34+H34))","v":0}]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$E$42,5,FALSE)","v":289.13},null,0,{"$f":"F35*D35","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F35+H35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F35+H35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F35+H35))","v":0}]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$E$42,5,FALSE)","v":743.32},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F36+H36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F36+H36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F36+H36))","v":0}]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$E$42,5,FALSE)","v":1361.6},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F37+H37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F37+H37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F37+H37))","v":0}]
["Fungicides"]
[{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Orkestra® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 16 oz"},59014379,{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$E$42,5,FALSE)","v":702.08},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F39+H39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F39+H39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F39+H39))","v":0}]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$E$42,5,FALSE)","v":463.4},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F40+H40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F40+H40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F40+H40))","v":0}]
[{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$E$42,5,FALSE)","v":59.63},null,0,{"$f":"F41*D41","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F41+H41))","v":0},{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F41+H41))","v":0},{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F41+H41))","v":0}]
[{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$E$42,5,FALSE)","v":110.63},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F42+H42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F42+H42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F42+H42))","v":0}]
[{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pillar® SC Intrinsic brand fungicide"},{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 43.5 oz"},59026395,{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$E$42,5,FALSE)","v":891.75},null,0,{"$f":"F43*D43","v":0}]
["Herbicides"]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$E$42,5,FALSE)","v":228.13},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F45+H45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F45+H45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F45+H45))","v":0}]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$E$42,5,FALSE)","v":529.69000000000005},null,0,{"$f":"F46*D46","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"FreeHand® 1.75G CA herbicide"},{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"1 x 50 lb"},59013674,{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$E$42,5,FALSE)","v":116.5},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F47+H47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F47+H47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F47+H47))","v":0}]
[{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$E$42,5,FALSE)","v":90},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F48+H48))","v":0},{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F48+H48))","v":0},{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F48+H48))","v":0}]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$E$42,5,FALSE)","v":51.25},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F49+H49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F49+H49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F49+H49))","v":0}]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$E$42,5,FALSE)","v":290.63},null,0,{"$f":"F50*D50","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F50+H50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F50+H50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F50+H50))","v":0}]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$E$42,5,FALSE)","v":1061.0999999999999},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F51+H51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F51+H51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F51+H51))","v":0}]
[{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$E$42,5,FALSE)","v":1509.12},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F52+H52))","v":0},{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F52+H52))","v":0},{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F52+H52))","v":0}]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$E$42,5,FALSE)","v":2145.6999999999998},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$5:$H$20,4,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$5:$H$20,4,FALSE)*(F53+H53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$5:$H$20,5,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$5:$H$20,5,FALSE)*(F53+H53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$5:$H$20,6,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$5:$H$20,6,FALSE)*(F53+H53))","v":0}]
["QUALIFYING EOP PRODUCTS SUB-TOTAL",null,null,null,null,null,{"$f":"SUM(G34:G53)","v":0},null,null,{"$f":"G54","v":0}]
[]
[]
[]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2025 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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K23)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K23)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K23)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K24)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K24)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K24)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K24)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K24)","v":0},0,null,59012825]
["Honor","1 x 36 lb",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K25)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K25)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K25)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K25)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K25)","v":0},0,null,59012885]
[null,"6 x 3 lb",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K26)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K26)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K26)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$K26)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$29,'Step 2 - Order Planner'!$C$26:$C$29,$K26)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K26)","v":0},0,null,59012350]
["Insignia SC","2 x 2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K27)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K27)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K27)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K27)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K27)","v":0},0,null,59014135]
[null,"4 x 30.5 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K28)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K28)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K28)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K28)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K29)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K29)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K29)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$K29)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$29,'Step 2 - Order Planner'!$C$26:$C$29,$K29)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K29)","v":0},0,null,59013840]
["Maxtima","4 x26 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K30)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K30)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K30)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$K30)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$29,'Step 2 - Order Planner'!$C$26:$C$29,$K30)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K30)","v":0},0,null,59018087]
[null,"2x 2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K31)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K31)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K31)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K31)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K31)","v":0},0,null,59018071]
["Navicon","4x37 fl oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K32)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K32)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K32)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$K32)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$29,'Step 2 - Order Planner'!$C$26:$C$29,$K32)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K32)","v":0},0,null,59018094]
[null,"2x2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K33)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K33)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K33)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$K33)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$29,'Step 2 - Order Planner'!$C$26:$C$29,$K33)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K33)","v":0},0,null,59018095]
["Pillar G","15 lbs",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K34)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K34)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K34)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K34)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K34)","v":0},0,null,59017959]
[null,"30 lbs ",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K35)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K35)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K35)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$K35)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$29,'Step 2 - Order Planner'!$C$26:$C$29,$K35)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$K35)","v":0},0,null,59012784]
["Xzemplar","2 x 114 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$29,'Step 2 - Order Planner'!$C$26:$C$29,$K36)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K36)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K36)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$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$29,'Step 2 - Order Planner'!$C$26:$C$29,$K37)+SUMIFS('Step 2 - Order Planner'!J$34:J$53,'Step 2 - Order Planner'!$C$34:$C$53,$K37)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$29,'Step 2 - Order Planner'!$C$26:$C$29,$K37)+SUMIFS('Step 2 - Order Planner'!K$34:K$53,'Step 2 - Order Planner'!$C$34:$C$53,$K37)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$29,'Step 2 - Order Planner'!$C$26:$C$29,$K37)+SUMIFS('Step 2 - Order Planner'!L$34:L$53,'Step 2 - Order Planner'!$C$34:$C$53,$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":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[10,0,11,5],[18,3,19,4],[18,5,19,5],[21,2,22,3],[50,0,59,5],[30,0,30,4],[48,0,48,4],[13,3,13,4],[14,3,15,4],[14,5,15,5],[16,3,17,4],[16,5,17,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BASF 2025 EOP ORDER SUMMARY"]
[]
[{"$f":"NOW()","v":"2024-09-09T13:37:43.390"},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,"Agency Fungicide Rebate Attained",null,{"$f":"'Step 2 - Order Planner'!B20","v":0}]
["<Enter Business Name>","<Enter Business Name>"]
["<City, ST Zip Code>","<City, ST Zip Code>",null,"Across-The-Lawn Rebate",null,{"$f":"'Step 2 - Order Planner'!B22","v":0}]
["<Phone>","<Phone>"]
["<email address>","<email address>",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$42,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$42,4,FALSE)","v":2257},{"$f":"VLOOKUP(C26,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C26,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},{"$f":"E26*D26","v":0}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 2.5 gal"},59014135,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$42,4,FALSE)","v":7375},{"$f":"VLOOKUP(C27,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C27,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 21 oz"},59027998,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$42,4,FALSE)","v":2478},{"$f":"VLOOKUP(C28,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C28,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$42,4,FALSE)","v":3534},{"$f":"VLOOKUP(C29,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C29,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$42,4,FALSE)","v":824},{"$f":"VLOOKUP(C30,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C30,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
["Agency Lawn Fungicide Program Rebate Purchases Sub-Total",null,null,null,null,{"$f":"'Step 2 - Order Planner'!H17","v":0}]
[{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$42,4,FALSE)","v":593.75},{"$f":"VLOOKUP(C32,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C32,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$42,4,FALSE)","v":228.13},{"$f":"VLOOKUP(C33,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C33,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$42,4,FALSE)","v":529.69000000000005},{"$f":"VLOOKUP(C34,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C34,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},{"$f":"E34*D34","v":0}]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"FreeHand® 1.75G CA herbicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"1 x 50 lb"},59013674,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$42,4,FALSE)","v":113.5},{"$f":"VLOOKUP(C35,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C35,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Orkestra® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 16 oz"},59014379,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$42,4,FALSE)","v":684.8},{"$f":"VLOOKUP(C36,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C36,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$42,4,FALSE)","v":452},{"$f":"VLOOKUP(C37,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C37,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$42,4,FALSE)","v":51.25},{"$f":"VLOOKUP(C38,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C38,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$42,4,FALSE)","v":90},{"$f":"VLOOKUP(C39,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C39,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},{"$f":"E39*D39","v":0}]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$42,4,FALSE)","v":290.63},{"$f":"VLOOKUP(C40,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C40,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$42,4,FALSE)","v":1035},{"$f":"VLOOKUP(C41,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C41,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},{"$f":"E41*D41","v":0}]
[{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$42,4,FALSE)","v":59.63},{"$f":"VLOOKUP(C42,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C42,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$42,4,FALSE)","v":110.63},{"$f":"VLOOKUP(C43,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C43,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$42,4,FALSE)","v":1472},{"$f":"VLOOKUP(C44,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C44,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$42,4,FALSE)","v":289.13},{"$f":"VLOOKUP(C45,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C45,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$42,4,FALSE)","v":725},{"$f":"VLOOKUP(C46,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C46,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$42,4,FALSE)","v":2100},{"$f":"VLOOKUP(C47,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C47,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$42,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$42,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$42,4,FALSE)","v":1328},{"$f":"VLOOKUP(C48,'Step 2 - Order Planner'!$C$26:$H$53,4,FALSE)+VLOOKUP(C48,'Step 2 - Order Planner'!$C$26:$H$53,6,FALSE)","v":0},{"$f":"E48*D48","v":0}]
["Across-the-Lawn-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 2025 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":[[13,18,15,18],[9,18,10,18],[9,17,10,17],[9,16,10,16],[11,18,12,18],[11,17,12,17],[11,16,12,16],[4,18,5,18],[4,17,5,17],[4,16,5,16],[6,18,7,18],[6,17,7,17],[6,16,7,16],[13,17,15,17],[13,16,15,16],[22,2,22,3],[5,2,5,3],[15,2,15,3]]}
["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,"Aramax™ Intrinsic® Brand Fungicide","2 x 2.5 gal",null,null,{"$f":"IF(O2>0,1,0)","v":0},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,59021463,{"$f":"VLOOKUP($L3,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L3,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}},null,null,0,0,{"$f":"IF(OR(Q3=1,R3=1),1,0)","v":0}]
[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,59014003,{"$f":"VLOOKUP($L4,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L4,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}},null,null,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,59012350,{"$f":"VLOOKUP($L5,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L5,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(O5+O6>0,1,0)","v":0},{"$f":"IF(P5+P6>0,1,0)","v":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,59012885,{"$f":"VLOOKUP($L6,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L6,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,0,null,null,null,null,null,null,59014134,{"$f":"VLOOKUP($L7,'Article Reference'!$A$3:$C$7,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L7,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"4 x 30.5 fl oz"},{"$f":"VLOOKUP(L7,'Step 2 - Order Planner'!$C$26:$F$30,4,FALSE)","v":0},{"$f":"VLOOKUP(L7,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},{"$f":"IF(O7+O8>0,1,0)","v":0},{"$f":"IF(P7+P8>0,1,0)","v":0},{"$f":"IF(OR(Q7=1,R7=1),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,59014135,{"$f":"VLOOKUP($L8,'Article Reference'!$A$3:$C$7,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L8,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L8,'Step 2 - Order Planner'!$C$26:$F$30,4,FALSE)","v":0},{"$f":"VLOOKUP(L8,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0}]
["DYOP",null,"Oct","Nov-Dec",null,null,null,null,null,null,null,59027998,{"$f":"VLOOKUP($L9,'Article Reference'!$A$3:$C$7,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L9,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"4 x 21 oz"},{"$f":"VLOOKUP(L9,'Step 2 - Order Planner'!$C$26:$F$30,4,FALSE)","v":0},{"$f":"VLOOKUP(L9,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},{"$f":"IF(O9>0,1,0)","v":0},{"$f":"IF(P9>0,1,0)","v":0},{"$f":"IF(OR(Q9=1,R9=1),1,0)","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,59018087,{"$f":"VLOOKUP($L10,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L10,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(O10+O11>0,1,0)","v":0},{"$f":"IF(P10+P11>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.04,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$31)>=3000,Q17>=1),C11)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$31)>=3000,S17>=1),D11)","v":false},{"$f":"IF(E11<>FALSE,E11,F11)","v":false},{"$f":"A11-H10","v":3000},0.08,null,null,59018071,{"$f":"VLOOKUP($L11,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L11,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}}]
[8000,{"$f":"A13-1","v":19999},0.14000000000000001,7.0000000000000007E-2,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$31)>=3000,$Q$17>=1,'Step 2 - Order Planner'!J31>=$A12,'Step 2 - Order Planner'!J31<=$B12),C12)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$31)>=3000,$S$17>=1,'Step 2 - Order Planner'!J31>=$A12,'Step 2 - Order Planner'!J31<=$B12),D12)","v":false},{"$f":"IF(E12<>FALSE,E12,F12)","v":false},{"$f":"A12-H10","v":8000},0.14000000000000001,null,null,59018094,{"$f":"VLOOKUP($L12,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L12,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(O12+O13>0,1,0)","v":0},{"$f":"IF(P12+P13>0,1,0)","v":0},{"$f":"IF(OR(Q12=1,R12=1),1,0)","v":0}]
[20000,{"$f":"A14-1","v":29999},0.17,0.09,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$31)>=3000,Q17>=1,'Step 2 - Order Planner'!J31>=$A13,'Step 2 - Order Planner'!J31<=$B13),C13)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$31)>=3000,$S$17>=1,'Step 2 - Order Planner'!J31>=$A13,'Step 2 - Order Planner'!J31<=$B13),D13)","v":false},{"$f":"IF(E13<>FALSE,E13,F13)","v":false},{"$f":"A13-H10","v":20000},0.17,null,null,59018095,{"$f":"VLOOKUP($L13,'Article Reference'!$A$3:$C$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($L13,'Article Reference'!$A$3:$C$7,3,FALSE)","v":{"$error":"#N/A"}}]
[30000,{"$f":"A15-1","v":39999},0.2,0.1,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$31)>=3000,Q17>=1,'Step 2 - Order Planner'!J31>=$A14,'Step 2 - Order Planner'!J31<=$B14),C14)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$31)>=3000,$S$17>=1,'Step 2 - Order Planner'!J31>=$A14,'Step 2 - Order Planner'!J31<=$B14),D14)","v":false},{"$f":"IF(E14<>FALSE,E14,F14)","v":false},{"$f":"A14-H10","v":30000},0.2,null,null,59013833,{"$f":"VLOOKUP($L14,'Article Reference'!$A$3:$C$7,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($L14,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"2 x 114 oz"},{"$f":"VLOOKUP(L14,'Step 2 - Order Planner'!$C$26:$F$30,4,FALSE)","v":0},{"$f":"VLOOKUP(L14,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},{"$f":"IF(O14+O16>0,1,0)","v":0},{"$f":"IF(P14+P16>0,1,0)","v":0},{"$f":"IF(OR(Q14=1,R14=1),1,0)","v":0}]
[40000,10000000,0.24,0.12,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$31)>=3000,Q17>=1,'Step 2 - Order Planner'!J31>=$A15,'Step 2 - Order Planner'!J31<=$B15),C15)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$31)>=3000,$S$17>=1,'Step 2 - Order Planner'!J31>=$A15,'Step 2 - Order Planner'!J31<=$B15),D15)","v":false},{"$f":"IF(E15<>FALSE,E15,F15)","v":false},{"$f":"A15-H10","v":40000},0.24]
[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,59014120,{"$f":"VLOOKUP($L16,'Article Reference'!$A$3:$C$7,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($L16,'Article Reference'!$A$3:$C$7,3,FALSE)","v":"4 x 11.4 oz"},{"$f":"VLOOKUP(L16,'Step 2 - Order Planner'!$C$26:$F$30,4,FALSE)","v":0},{"$f":"VLOOKUP(L16,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q16)","v":0},{"$f":"SUM(R2:R16)","v":0},{"$f":"SUM(S2:S16)","v":0}]
["Table B for Fungicides"]
["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$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54)>=3000,'Step 2 - Order Planner'!$G$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54>=$A20,'Step 2 - Order Planner'!$G$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54<=$B20,S17<=3),C20)","v":false},{"$f":"IF(AND(SUM('Step 2 - Order Planner'!G26:G29)>=3000,SUM('Step 2 - Order Planner'!G26:G29)<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$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54)>=3000,'Step 2 - Order Planner'!$G$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54>=$A21,'Step 2 - Order Planner'!$G$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54<=$B21,S17<=3),C21)","v":false},null,{"$f":"SUM(E21:F21)","v":0},{"$f":"A21-$H$19","v":8000},0.06]
[20000,1000000,0.12,0.12,{"$f":"IF(AND(('Step 2 - Order Planner'!$G$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54)>=3000,'Step 2 - Order Planner'!$G$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54>=$A22,'Step 2 - Order Planner'!$G$31+'Step 2 - Order Planner'!$I$31+'Step 2 - Order Planner'!$G$54<=$B22,S17<=3),C22)","v":false},null,{"$f":"SUM(E22:F22)","v":0},20000,0.12]
[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}]

{"sheet":"Article Reference","index":5,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,0,0,4],[8,0,8,4]]}
["2025 Qualifying Fungicides"]
["Article Number","Qaulifying Non-Agency Products","Package","Price","CA Redemption","Volume","Rebate Sales","Case UOM","Price/UOM","Case Price"]
[59014134,"Insignia® SC Intrinsic® brand fungicide","4 x 30.5 fl oz",2257,2305.8000000000002,{"$f":"VLOOKUP($A3,'Step 2 - Order Planner'!$C$26:$H$30,4,FALSE)+VLOOKUP($A3,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},{"$f":"F3*D3","v":0},{"$f":"4*30.5","v":122},{"$f":"J3/H3","v":18.5},{"$f":"D3","v":2257}]
[59014135,"Insignia® SC Intrinsic® brand fungicide","2 x 2.5 gal",7375,7535.4,{"$f":"VLOOKUP($A4,'Step 2 - Order Planner'!$C$26:$H$30,4,FALSE)+VLOOKUP($A4,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},{"$f":"F4*D4","v":0},5,1475,7375]
[59027998,"Lexicon® Intrinsic® brand fungicide","4 x 21 oz",2478,2531.7600000000002,{"$f":"VLOOKUP($A5,'Step 2 - Order Planner'!$C$26:$H$30,4,FALSE)+VLOOKUP($A5,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},0,{"$f":"4*21","v":84},29.5,2478]
[59013833,"Xzemplar® fungicide","2 x 114 oz",3534,3611.52,{"$f":"VLOOKUP($A6,'Step 2 - Order Planner'!$C$26:$H$30,4,FALSE)+VLOOKUP($A6,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},0,{"$f":"2*114","v":228},15.5,3534]
[59014120,"Xzemplar® fungicide","4 x 11.4 oz",824,841.76,{"$f":"VLOOKUP($A7,'Step 2 - Order Planner'!$C$26:$H$30,4,FALSE)+VLOOKUP($A7,'Step 2 - Order Planner'!$C$26:$H$30,6,FALSE)","v":0},0,{"$f":"4*11.4","v":45.6},18.07017543859649,824]
[null,null,null,{"$f":"SUM(D3:D7)","v":16468},{"$f":"SUM(E3:E7)","v":16826.240000000002},null,{"$f":"SUM(G3:G7)","v":0}]
["2022 Rest of Portfolio"]
["Article Number","Qaulifying Non-Agency Products","Package","Price","CA Redemption"]
[59014151,"Admiral® lake colorant","4 x 1 gal",null,null,null,null,4,{"$f":"J11/H11","v":0},{"$f":"D11","v":0}]
[59024020,"Alucion® 35 WG insecticide","10 x 2.375 lbs",2565,"NO CA",null,null,{"$f":"10*38","v":380},6.75,2565]
[59021451,"Amdro Pro Fire Ant Bait","1 x 25lbs",593.75,593.75,{"$f":"VLOOKUP(A13,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},{"$f":"F13*D13","v":0},25,23.75,593.75]
[59011636,"Basagran® herbicide","2 x 1 gal",127.5,"NO CA",null,null,2,63.75,127.5]
[59013424,"Black Onyx lake & pond colorant","4 x 1 gal",null,null,null,null,4,0,0]
[59011404,"Drive® XLR8 herbicide","4 x 0.5 gal",228.13,228.13,{"$f":"VLOOKUP(A16,'Step 2 - Order Planner'!$C$34:$F$53,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(A17,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,null,null,529.69000000000005]
[59024131,"Finale®  XL T&O herbicide ","2 x 2.5 gal",null,null,null,null,5,{"$f":"J18/H18","v":0},0,null,"<--","Discontinued ???"]
[59013674,"FreeHand® 1.75G CA herbicide","1 x 50 lb",113.5,116.5,{"$f":"VLOOKUP(A19,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,50,2.27,113.5,null,59013674,"FreeHand® 1.75G CA herbicide","1 x 50 lb"]
[59013430,"Green Lawnger® colorant","2 x 2.5 gal",null,null,null,null,5,0,0]
[59013410,"Green Lawnger® Transition HC colorant","4 x 1 gal",null,null,null,null,4,0,0]
[59013342,"Green Lawnger® Vision Pro colorant","4 x 1 gal",null,null,null,null,4,0,0]
[59020732,"Insignia® SC Intrinsic® brand fungicide","4 x 122 oz",null,{"$f":"D23","v":0},null,null,{"$f":"4*122","v":488},0,0,null,"<--","Discontinued"]
[59014379,"Orkestra® Intrinsic® brand Fungicide","4 x 16 oz",684.8,702.08,{"$f":"VLOOKUP(A24,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,{"$f":"4*16","v":64},10.7,684.8]
[59012349,"Pageant® Intrinsic® brand Fungicide","4 x 1 lb",452,463.4,{"$f":"VLOOKUP(A25,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,4,113,452]
[59017972,"Pendulum® 2G herbicide","20 lbs bag",51.25,51.25,{"$f":"VLOOKUP(A26,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,20,2.5625,51.25]
[59015072,"Pendulum® 2G herbicide","40 lbs bag",90,90,{"$f":"VLOOKUP(A27,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,40,2.25,90]
[59049276,"Pendulum® AquaCap herbicide","2 x 2.5 gal",290.63,290.63,{"$f":"VLOOKUP(A28,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,5,58.125999999999998,290.63]
[59011279,"Pendulum® AquaCap herbicide","1 x 15 gal",1035,1061.0999999999999,{"$f":"VLOOKUP(A29,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,15,69,1035]
[59017959,"Pillar® G Intrinsic® brand fungicide","15 lbs bag",59.63,59.63,{"$f":"VLOOKUP(A30,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,15,3.9753333333333334,59.63]
[59012784,"Pillar® G Intrinsic® brand fungicide","30 lbs bag",110.63,110.63,{"$f":"VLOOKUP(A31,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,30,3.6876666666666664,110.63]
[59026395,"Pillar® SC Intrinsic brand fungicide","4 x 43.5 oz",891.75,891.75,{"$f":"VLOOKUP(A32,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,{"$f":"4*43.5","v":174},5.125,891.75,null,"<--","lawn care only"]
[59018005,"Pylex® herbicide","4 x 4 oz",1472,1509.12,{"$f":"VLOOKUP(A33,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,16,92,1472]
[59014427,"Segment® II herbicide","2 x 2.5 gal",1625,"NO CA",null,null,5,325,1625]
[59011057,"Siesta® Fire Ant Bait","15 lbs",289.13,289.13,{"$f":"VLOOKUP(A35,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,15,19.275333333333332,289.13]
[59023753,"Sultan® miticide","4 x 0.125 gal",725,743.32,{"$f":"VLOOKUP(A36,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,{"$f":"4*0.125","v":0.5},1450,725]
[59014247,"Tower® herbicide","2 x 2.5 gal",2100,2145.6999999999998,{"$f":"VLOOKUP(A37,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,5,420,2100]
[59013723,"Turf Mark spray indicator","12 x 0.25 gal",null,null,null,null,{"$f":"12*0.25","v":3},0,0]
[59013314,"Turf Mark spray indicator","1 x 30 gal",null,null,null,null,30,0,0]
[59013417,"Turf Mark spray indicator - blue","2 x 2.5 gal",null,null,null,null,5,0,0]
[59013486,"Turf Mark spray indicator - green","2 x 2.5 gal",null,null,null,null,5,0,0,null,"<--","Discontinued"]
[59014680,"Ventigra® insecticide","4 x 20 oz",1328,1361.6,{"$f":"VLOOKUP(A42,'Step 2 - Order Planner'!$C$34:$F$53,4,FALSE)","v":0},0,{"$f":"4*20","v":80},16.600000000000001,1328]
[null,null,null,{"$f":"SUM(D11:D42)","v":15362.39},{"$f":"SUM(E11:E42)","v":11237.410000000002},null,{"$f":"SUM(G11:G42)","v":0}]
[]
[]
[null,null,null,null,{"$f":"11237.41-E43","v":0}]

{"sheet":"Coverage Reference","index":6,"n_rows":41,"n_cols":14,"rows_kept":41,"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.6","v":14.678899082568806},null,null,null,null,{"$f":"640/43.6","v":14.678899082568806}]
["Emerald® Fungicide",59021463,"10 x .49 lb.",null,null,null,null,10,null,null,13.9,12,10]
["Emerald® Fungicide",59012825,"50 x .49 lb.",null,null,null,null,50,null,null,69.3,60,50]
["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]
["Honor® Intrinsic™ brand Fungicide",59012350,"6 x 3 lb",null,null,null,null,6,null,null,12,9,6]
["Insignia® SC Intrinsic™ brand Fungicide",59014135,"2 x 2.5 gal",null,null,null,null,21,null,null,36.799999999999997,28.9,21]
["Insignia® SC Intrinsic™ brand Fungicide",59014134,"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,null,25,20,null,null,32.799999999999997,24.95,20]
["Xzemplar™Fungicide",59014120,"4 x 11.4 oz",null,null,null,5,4,null,null,6.6,5,4]
[]
[]
["Brand","Rate","Rate Level Above",null,43.5]
["Aramax","43.6 oz"]
["Emerald",{"$f":"\"8.0\"&\" \"&F25","v":"8.0 oz"},"All",0.18,{"$f":"D25*$E$23","v":7.83},"oz",null,null,null,null,null,null,{"$f":"5*128","v":640},{"$f":"M25/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":"M28/43.6","v":14.678899082568806}]
["Honor",{"$f":"\"48.0\"&\" \"&F30","v":"48.0 oz"},"All",1.1000000000000001,{"$f":"D30*$E$23","v":47.85},"oz"]
["Insignia",{"$f":"30.5&\" \"&F31","v":"30.5 oz"},"All",0.7,{"$f":"D31*$E$23","v":30.45},"oz"]
["Lexicon",{"$f":"\"21.0\"&\" \"&F32","v":"21.0 oz"},"All",0.47,{"$f":"D32*$E$23","v":20.445},"oz",null,null,null,null,null,null,{"$f":"0.07*M25","v":44.800000000000004}]
["Navicon",{"$f":"37.5&\" \"&F33","v":"37.5 oz"},"All",0.85,{"$f":"D33*$E$23","v":36.975000000000001},"oz"]
["Maxtima","Select Rate",null,null,null,null,null,null,null,null,null,null,{"$f":"0.07*M25","v":44.800000000000004}]
["Maxtima",{"$f":"E35&\" \"&F35","v":"8.7 oz"},4,0.2,{"$f":"D35*$E$23","v":8.7000000000000011},"oz"]
["Maxtima","17.4 oz",5,0.4,{"$f":"D36*$E$23","v":17.400000000000002},"oz"]
["Maxtima","26.1 oz",6,0.6,{"$f":"D37*$E$23","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":"D38*$E$23","v":34.800000000000004},"oz"]
["Xzemplar ","Select Rate"]
["Xzemplar ",{"$f":"E40&\" \"&F40","v":"9.135 oz"},6,0.21,{"$f":"D40*$E$23","v":9.1349999999999998},"oz"]
["Xzemplar ","11.31 oz",7,0.26,{"$f":"D41*$E$23","v":11.31},"oz"]

{"sheet":"Sheet1","index":7,"n_rows":20,"n_cols":8,"rows_kept":20,"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],[14,6,15,6],[13,1,14,1],[13,2,13,3],[13,4,14,4],[13,6,13,7]]}
[]
[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, 2024","Nov. 1-Dec. 6, 2024",null,null,null,"Oct.1-Dec. 1, 2023"]
[null,"$3,000-$7,999 (Par)",0.08,0.04,"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"]
[]
[]
[]
[]
[null,"Agency Lawn Fungicides","Earned Incentive %",null,"DYOP Brand Requirements",null,"Across the Lawn Solutions"]
[null,null,"Oct. 1-31, 2024","Nov. 1-Dec. 6, 2024",null,null,"Qualifying Purchase Level","Earned Incentive %"]
[null,"$3,000-$7,999",0.08,0.04,"One (1) Qualifying Brand",null,null,"Oct.1-Dec. 1, 2023"]
[null,"$8,000-$19,999",0.14000000000000001,0.06,"Three (3) Qualifying Brands",null,"$3,000-$7,999",0.04]
[null,"$20,000-$29,999",0.17,0.09,"Three (3) Qualifying Brands",null,"$8,000-$19,999",0.06]
[null,"$30,000-$39,999",0.2,0.1,"Three (3) Qualifying Brands",null,"$20,000+",0.12]
[null,"$40,000+",0.24,0.12,"Three (3) Qualifying Brands"]