{"text_format":"3","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":{"images":6,"macros":1,"defined_names":7,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Step 1 - Fungicide Planner","index":0,"n_rows":35,"n_cols":15,"rows_kept":35,"merged":[[16,0,16,9],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,9,18,9],[21,0,22,0],[23,0,24,0],[26,0,27,0],[28,0,29,0],[30,0,31,0],[33,0,33,9],[34,0,43,9]]}
{"$rows_empty":16}
["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*)"]
[{"$nulls":10},"Article","Rate","Coverage","Cases"]
["Emerald®",{"$f":"VLOOKUP(C20,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"10 x 0.49 lb"},59021463,null,0,"8.0 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$75,2,FALSE))/(G20*E20))","v":0},{"$f":"IF(G20*E20=0,0,((VLOOKUP(K20,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H20,2))/(G20*E20))","v":0},59021463,7,{"$f":"IF(L20=0,0,VLOOKUP(K20,'Coverage Reference'!$B$4:$H$19,L20,FALSE))","v":{"v":10,"d":"10.00"}},{"$f":"H20","v":0}]
["Encartis®",{"$f":"VLOOKUP(C21,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},59014003,null,0,"Select Rate",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$75,2,FALSE))/(G21*E21))","v":0},{"$f":"IF(G21*E21=0,0,((VLOOKUP(K21,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H21,2))/(G21*E21))","v":0},59014003,{"$f":"IF(F21=\"130.5 fl oz\",5,IF(F21=\"152.5 fl oz\",6,IF(F21=\"174.0 fl oz\",7,)))","v":0},{"$f":"IF(L21=0,0,VLOOKUP(K21,'Coverage Reference'!$B$4:$H$19,L21,FALSE))","v":0},{"$f":"H21","v":0}]
["Honor® Intrinsic®",{"$f":"VLOOKUP(C22,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"6 x 3 lb"},59012350,null,0,"48.0 oz",0,0,{"$f":"IF(G22*E22=0,0,(ROUND(H22,2)*VLOOKUP(K22,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G22*E22))","v":0},{"$f":"IF(G22*E22=0,0,((VLOOKUP(K22,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H22,2))/(G22*E22))","v":0},59012350,7,{"$f":"IF(L22=0,0,VLOOKUP(K22,'Coverage Reference'!$B$4:$H$19,L22,FALSE))","v":{"v":6,"d":"6.00"}},{"$f":"H22","v":0}]
[null,{"$f":"VLOOKUP(C23,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"1 x 36 lb"},59012885,null,0,"48.0 oz",0,0,{"$f":"IF(G23*E23=0,0,(ROUND(H23,2)*VLOOKUP(K23,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G23*E23))","v":0},{"$f":"IF(G23*E23=0,0,((VLOOKUP(K23,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H23,2))/(G23*E23))","v":0},59012885,7,{"$f":"IF(L23=0,0,VLOOKUP(K23,'Coverage Reference'!$B$4:$H$19,L23,FALSE))","v":{"v":12,"d":"12.00"}},0]
["Insignia® SC Intrinsic®",{"$f":"VLOOKUP(C24,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,null,0,"30.5 oz",0,0,{"$f":"IF(G24*E24=0,0,(ROUND(H24,2)*VLOOKUP(K24,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G24*E24))","v":0},{"$f":"IF(G24*E24=0,0,((VLOOKUP(K24,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H24,2))/(G24*E24))","v":0},59014134,7,{"$f":"IF(L24=0,0,VLOOKUP(K24,'Coverage Reference'!$B$4:$H$19,L24,FALSE))","v":{"v":4,"d":"4.00"}},0,"Greens"]
[null,{"$f":"VLOOKUP(C25,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},59014135,null,0,"30.5 oz",0,0,{"$f":"IF(G25*E25=0,0,(ROUND(H25,2)*VLOOKUP(K25,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G25*E25))","v":0},{"$f":"IF(G25*E25=0,0,((VLOOKUP(K25,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H25,2))/(G25*E25))","v":0},59014135,7,{"$f":"IF(L25=0,0,VLOOKUP(K25,'Coverage Reference'!$B$4:$H$19,L25,FALSE))","v":{"v":21,"d":"21.00"}},0,"Fairways"]
["Lexicon® Intrinsic®",{"$f":"VLOOKUP(C26,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 21 oz"},59027998,null,0,"21.0 oz",0,0,{"$f":"IF(G26*E26=0,0,(ROUND(H26,2)*VLOOKUP(K26,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G26*E26))","v":0},{"$f":"IF(G26*E26=0,0,((VLOOKUP(K26,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H26,2))/(G26*E26))","v":0},59027998,7,{"$f":"IF(L26=0,0,VLOOKUP(K26,'Coverage Reference'!$B$4:$H$19,L26,FALSE))","v":{"v":4,"d":"4.00"}},0]
["Maxtima®",{"$f":"VLOOKUP(C27,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 26 oz"},59018087,null,0,"Select Rate",0,0,{"$f":"IF(G27*E27=0,0,(ROUND(H27,2)*VLOOKUP(K27,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G27*E27))","v":0},{"$f":"IF(G27*E27=0,0,((VLOOKUP(K27,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H27,2))/(G27*E27))","v":0},59018087,{"$f":"IF(F27=\"8.7 oz\",4,IF(F27=\"17.4 oz\",5,IF(F27=\"26.1 oz\",6,IF(F27=\"34.8 oz\",7,0))))","v":0},{"$f":"IF(L27=0,0,VLOOKUP(K27,'Coverage Reference'!$B$4:$H$19,L27,FALSE))","v":0},0]
[null,{"$f":"VLOOKUP(C28,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},59018071,null,0,"Select Rate",0,0,{"$f":"IF(G28*E28=0,0,(ROUND(H28,2)*VLOOKUP(K28,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G28*E28))","v":0},{"$f":"IF(G28*E28=0,0,((VLOOKUP(K28,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H28,2))/(G28*E28))","v":0},59018071,{"$f":"IF(F28=\"8.7 oz\",4,IF(F28=\"17.4 oz\",5,IF(F28=\"26.1 oz\",6,IF(F28=\"34.8 oz\",7,0))))","v":0},{"$f":"IF(L28=0,0,VLOOKUP(K28,'Coverage Reference'!$B$4:$H$19,L28,FALSE))","v":0},0]
["Navicon® Intrinsic®",{"$f":"VLOOKUP(C29,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 37 fl oz"},59018094,null,0,"37.5 oz",0,0,{"$f":"IF(G29*E29=0,0,(ROUND(H29,2)*VLOOKUP(K29,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G29*E29))","v":0},{"$f":"IF(G29*E29=0,0,((VLOOKUP(K29,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H29,2))/(G29*E29))","v":0},59018094,7,{"$f":"IF(L29=0,0,VLOOKUP(K29,'Coverage Reference'!$B$4:$H$19,L29,FALSE))","v":{"v":4,"d":"4.00"}},0]
[null,{"$f":"VLOOKUP(C30,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},59018095,null,0,"37.5 oz",0,0,{"$f":"IF(G30*E30=0,0,(ROUND(H30,2)*VLOOKUP(K30,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G30*E30))","v":0},{"$f":"IF(G30*E30=0,0,((VLOOKUP(K30,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H30,2))/(G30*E30))","v":0},59018095,7,{"$f":"IF(L30=0,0,VLOOKUP(K30,'Coverage Reference'!$B$4:$H$19,L30,FALSE))","v":{"v":17,"d":"17.00"}},0]
["Xzemplar®",{"$f":"VLOOKUP(C31,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 11.4 oz"},59014120,null,0,"Select Rate",0,0,{"$f":"IF(G31*E31=0,0,(ROUND(H31,2)*VLOOKUP(K31,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G31*E31))","v":0},{"$f":"IF(G31*E31=0,0,((VLOOKUP(K31,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H31,2))/(G31*E31))","v":0},59014120,{"$f":"IF(F31=\"9.135 oz\",6,IF(F31=\"11.31 oz\",7,0))","v":0},{"$f":"IF(L31=0,0,VLOOKUP(K31,'Coverage Reference'!$B$4:$H$19,L31,FALSE))","v":0},0]
[null,{"$f":"VLOOKUP(C32,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 114 oz"},59013833,null,0,"Select Rate",0,0,{"$f":"IF(G32*E32=0,0,(ROUND(H32,2)*VLOOKUP(K32,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE))/(G32*E32))","v":0},{"$f":"IF(G32*E32=0,0,((VLOOKUP(K32,'Step 2 - Order Planner'!$C$26:$D$75,2,FALSE)*(1-'Step 2 - Order Planner'!$B$20))*ROUND(H32,2))/(G32*E32))","v":0},59013833,{"$f":"IF(F32=\"9.135 oz\",6,IF(F32=\"11.31 oz\",7,0))","v":0},{"$f":"IF(L32=0,0,VLOOKUP(K32,'Coverage Reference'!$B$4:$H$19,L32,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 2024 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":81,"n_cols":17,"rows_kept":81,"merged":[[6,0,6,8],[7,0,7,8],[8,0,8,8],[14,15,14,16],[15,0,15,8],[15,15,16,16],[16,1,16,2],[16,3,16,6],[16,7,16,8],[17,0,18,0],[17,1,18,2],[17,3,17,6],[17,7,17,8],[17,15,18,15],[17,16,18,16],[18,3,18,6],[18,7,18,8],[19,1,19,2],[19,3,19,6],[19,7,19,8],[19,15,20,15],[19,16,20,16],[20,1,20,2],[20,3,20,6],[20,7,20,8],[21,1,21,2],[21,3,21,6],[21,7,21,8],[21,15,22,15],[21,16,22,16],[22,1,22,2],[22,3,22,6],[22,7,22,8],[38,0,38,4],[38,9,38,11],[39,4,74,4],[39,7,75,8],[40,0,40,3],[40,5,40,6],[46,0,46,3],[46,5,46,6],[51,0,51,3],[51,5,51,6],[64,0,64,3],[64,5,64,6],[70,0,70,3],[70,5,70,6],[75,0,75,4],[75,9,75,11],[80,0,89,8]]}
{"$rows_empty":14}
[{"$nulls":15},"Upgrade Your DYOP Rebate"]
["EOP Rebate Calculator",{"$nulls":14},{"$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"}]
["DYOP Rebate Program Locked",{"$f":"IF(AND(G39>=3000,'Range Reference'!Q17>=1),\"October Rebate Locked\",IF(AND(J39>=3000,'Range Reference'!S17>=3),\"Nov-Dec Rebate Locked\",\"Rebate Level Not Achieved\"))","v":"Rebate Level Not Achieved"},null,"DYOP Total Purchases",{"$nulls":3},{"$f":"G39+I39","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,"DYOP Rebate",{"$nulls":3},{"$f":"IF(AND(B20=0,B21>0),H17*B21,(B20*H17))","v":0},{"$nulls":7},"Spend for Next DYOP Level","Next Level"]
[{"$nulls":3},"Across-the-Course-Solutions Purchases",{"$nulls":3},{"$f":"G76","v":0}]
["DYOP Rebate",{"$f":"IF(AND('Range Reference'!S17<3,G39>=3000),0.08,'Range Reference'!G16)","v":{"v":0,"d":"0%"}},null,"Across-the-Course-Solutions Rebate",{"$nulls":3},{"$f":"(H19*B21)","v":0},{"$nulls":7},{"$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'!S17>=3,H17>=20000),0.12,'Range Reference'!G6)","v":{"v":0,"d":"0%"}},null,"TOTAL EOP PURCHASE",{"$nulls":3},{"$f":"H17+H19","v":0}]
["Insignia® Intrinsic® Kicker - 5%",{"$f":"IF((F31+H31)>=1,(G31+I31)*0.05,0)","v":0},null,"Total Effective Rebate on All Purchases",{"$nulls":3},{"$f":"IF(H21=0,0,H23/H21)","v":{"v":0,"d":"0.00%"}},{"$nulls":7},"Spend for Next ATS Level","Next Level"]
["Honor® Intrinsic® Kicker - 5%",{"$f":"IF((F29+H29)>=2,(G29+I29)*0.05,0)","v":0},null,"TOTAL EOP Rebate",{"$nulls":3},{"$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(H17>=25000,0,HLOOKUP(H19,'Range Reference'!$H$19:$H$23,5,FALSE))","v":{"v":3000,"d":"$3,000.00"}},{"$f":"IF(P25=0,\"Max\",VLOOKUP(P25,'Range Reference'!H20:I22,2,FALSE))","v":{"v":0.04,"d":"4%"}}]
[{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Emerald® fungicide"},{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"10 x 0.49 lb"},59021463,{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":1187.4,"d":"$1,187.40"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C26,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C26,'Step 1 - Fungicide Planner'!$K$20:$N$32,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$19,4,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F26+H26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F26+H26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F26+H26))","v":0},{"v":1,"d":"1.000000"},{"$f":"1/10","v":{"v":0.1,"d":"0.100000"}},null,"Insignia® Intrinsic® Kicker",{"$f":"IF(B22>0,\"Achieved\",\"Buy 5 gallons\")","v":"Buy 5 gallons"}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Encartis® fungicide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"2 x 2.5 gal"},59014003,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":645.66,"d":"$645.66"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C27,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C27,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M27),N27)","v":0},0,{"$f":"D27*F27","v":0},0,{"$f":"H27*D27","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F27+H27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F27+H27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F27+H27))","v":0},{"v":1,"d":"1.000000"},{"v":0.5,"d":"0.500000"},null,"Honor® Intrinsic® Kicker",{"$f":"IF(B23>0,\"Achieved\",\"Buy 72 pounds\")","v":"Buy 72 pounds"}]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"6 x 3 lb"},59012350,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":3303.54,"d":"$3,303.54"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C28,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C28,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M28),N28)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F28+H28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F28+H28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F28+H28))","v":0},{"v":1,"d":"1.000000"},{"v":0.16666666666666666,"d":"0.166667"}]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"1 x 36 lb"},59012885,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":4867.2,"d":"$4,867.20"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C29,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C29,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M29),N29)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F29+H29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F29+H29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F29+H29))","v":0},0,{"v":1,"d":"1.000000"}]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":2169.16,"d":"$2,169.16"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C30,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C30,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M30),N30)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F30+H30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F30+H30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F30+H30))","v":0},{"v":2,"d":"2.000000"},{"v":0.25,"d":"0.250000"}]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"2 x 2.5 gal"},59014135,{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":7225.1,"d":"$7,225.10"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C31,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C31,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M31),N31)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F31+H31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F31+H31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F31+H31))","v":0},{"v":1,"d":"1.000000"},{"v":0.5,"d":"0.500000"}]
[{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"4 x 21 oz"},59027998,{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":2418.36,"d":"$2,418.36"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C32,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C32,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M32),N32)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F32+H32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F32+H32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F32+H32))","v":0},{"v":2,"d":"2.000000"},{"v":0.25,"d":"0.250000"}]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"4 x 26 oz"},59018087,{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":907.92,"d":"$907.92"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C33,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C33,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M33),N33)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F33+H33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F33+H33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F33+H33))","v":0},{"v":2,"d":"2.000000"},{"v":0.25,"d":"0.250000"}]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"2 x 2.5 gal"},59018071,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":4508.4,"d":"$4,508.40"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C34,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C34,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M34),N34)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F34+H34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F34+H34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F34+H34))","v":0},{"v":1,"d":"1.000000"},{"v":0.5,"d":"0.500000"}]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"4 x 37 fl oz"},59018094,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":2172.64,"d":"$2,172.64"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C35,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C35,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M35),N35)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F35+H35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F35+H35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F35+H35))","v":0},{"v":2,"d":"2.000000"},{"v":0.25,"d":"0.250000"}]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"2 x 2.5 gal"},59018095,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":6998,"d":"$6,998.00"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C36,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C36,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M36),N36)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F36+H36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F36+H36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F36+H36))","v":0},{"v":1,"d":"1.000000"},{"v":0.5,"d":"0.500000"}]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":808.04,"d":"$808.04"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C37,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C37,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M37),N37)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F37+H37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F37+H37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F37+H37))","v":0},{"v":2,"d":"2.000000"},{"v":0.25,"d":"0.250000"}]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$C$37,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$C$37,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$15,4,FALSE)","v":{"v":3451.92,"d":"$3,451.92"}},{"$f":"CEILING(ROUNDUP(IF(ISNA(VLOOKUP(C38,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE))=TRUE,\"\",VLOOKUP(C38,'Step 1 - Fungicide Planner'!$K$20:$N$32,4,FALSE)),M38),N38)","v":0},0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F38+H38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F38+H38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F38+H38))","v":0},{"v":1,"d":"1.000000"},{"v":0.5,"d":"0.500000"}]
["QUALIFYING FUNGICIDE EOP SUB-TOTAL",{"$nulls":5},{"$f":"SUM(G26:G38)","v":0},null,{"$f":"SUM(I26:I38)","v":0},{"$f":"I39+G39","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($C42,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Alucion® 35 WG insecticide"},{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"10 x 2.375 lbs"},59024020,{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":2442.9,"d":"$2,442.90"}},null,0,{"$f":"F42*D42","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F42+H42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F42+H42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F42+H42))","v":0}]
[{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1266.4,"d":"$1,266.40"}},null,0,{"$f":"F43*D43","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F43+H43))","v":0},{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F43+H43))","v":0},{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F43+H43))","v":0}]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":709.68,"d":"$709.68"}},null,0,{"$f":"F44*D44","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F44+H44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F44+H44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F44+H44))","v":0}]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":536.25,"d":"$536.25"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F45+H45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F45+H45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F45+H45))","v":0}]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":294.19,"d":"$294.19"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F46+H46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F46+H46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F46+H46))","v":0}]
["Fungicides"]
[{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Orkestra® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 16 oz"},59014379,{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":668.8,"d":"$668.80"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F48+H48))","v":0},{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F48+H48))","v":0},{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F48+H48))","v":0}]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":443.36,"d":"$443.36"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F49+H49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F49+H49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F49+H49))","v":0}]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":56.63,"d":"$56.63"}},null,0,{"$f":"F50*D50","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F50+H50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F50+H50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F50+H50))","v":0}]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":105,"d":"$105.00"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F51+H51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F51+H51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F51+H51))","v":0}]
["Herbicides"]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Basagran® herbicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 1 gal"},59011636,{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":125.58,"d":"$125.58"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F53+H53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F53+H53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F53+H53))","v":0}]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":221.25,"d":"$221.25"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F54+H54))","v":0},{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F54+H54))","v":0},{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F54+H54))","v":0}]
[{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":514.44,"d":"$514.44"}},null,0,{"$f":"F55*D55","v":0}]
[{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Finale®  XL T&O herbicide "},{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59024131,{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":543.75,"d":"$543.75"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F56+H56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F56+H56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F56+H56))","v":0}]
[{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"FreeHand® 1.75G herbicide"},{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 50 lb"},59011296,{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":109.5,"d":"$109.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F57+H57))","v":0},{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F57+H57))","v":0},{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F57+H57))","v":0}]
[{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":85.5,"d":"$85.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F58+H58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F58+H58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F58+H58))","v":0}]
[{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":48.5,"d":"$48.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F59+H59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F59+H59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F59+H59))","v":0}]
[{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":281.25,"d":"$281.25"}},null,0,{"$f":"F60*D60","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F60+H60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F60+H60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F60+H60))","v":0}]
[{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":983.1,"d":"$983.10"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F61+H61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F61+H61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F61+H61))","v":0}]
[{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1376,"d":"$1,376.00"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F62+H62))","v":0},{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F62+H62))","v":0},{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F62+H62))","v":0}]
[{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Segment® II herbicide"},{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59014427,{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1562.5,"d":"$1,562.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F63+H63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F63+H63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F63+H63))","v":0}]
[{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1972.5,"d":"$1,972.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F64+H64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F64+H64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F64+H64))","v":0}]
["Colorants"]
[{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Admiral® lake colorant"},{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59014151,{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":251.45,"d":"$251.45"}},null,0,{"$f":"F66*D66","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F66+H66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F66+H66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F66+H66))","v":0}]
[{"$f":"VLOOKUP($C67,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Black Onyx lake & pond colorant"},{"$f":"VLOOKUP($C67,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59013424,{"$f":"VLOOKUP($C67,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":428,"d":"$428.00"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F67+H67))","v":0},{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F67+H67))","v":0},{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F67+H67))","v":0}]
[{"$f":"VLOOKUP($C68,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Green Lawnger® colorant"},{"$f":"VLOOKUP($C68,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59013430,{"$f":"VLOOKUP($C68,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":376.56,"d":"$376.56"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F68+H68))","v":0},{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F68+H68))","v":0},{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F68+H68))","v":0}]
[{"$f":"VLOOKUP($C69,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Green Lawnger® Transition HC colorant"},{"$f":"VLOOKUP($C69,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59013410,{"$f":"VLOOKUP($C69,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":787.5,"d":"$787.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F69+H69))","v":0},{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F69+H69))","v":0},{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F69+H69))","v":0}]
[{"$f":"VLOOKUP($C70,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Green Lawnger® Vision Pro colorant"},{"$f":"VLOOKUP($C70,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59013342,{"$f":"VLOOKUP($C70,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":707.5,"d":"$707.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F70+H70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F70+H70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F70+H70))","v":0}]
["Spray Indicators"]
[{"$f":"VLOOKUP($C72,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator"},{"$f":"VLOOKUP($C72,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"12 x 0.25 gal"},59013723,{"$f":"VLOOKUP($C72,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":247.5,"d":"$247.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F72+H72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F72+H72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F72+H72))","v":0}]
[{"$f":"VLOOKUP($C73,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator"},{"$f":"VLOOKUP($C73,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 30 gal"},59013314,{"$f":"VLOOKUP($C73,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1556.25,"d":"$1,556.25"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F73+H73))","v":0},{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F73+H73))","v":0},{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F73+H73))","v":0}]
[{"$f":"VLOOKUP($C74,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C74,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59013417,{"$f":"VLOOKUP($C74,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":278.13,"d":"$278.13"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F74+H74))","v":0},{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F74+H74))","v":0},{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F74+H74))","v":0}]
[{"$f":"VLOOKUP($C75,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator - green"},{"$f":"VLOOKUP($C75,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59013486,{"$f":"VLOOKUP($C75,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":333.88,"d":"$333.88"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C75,'Coverage Reference'!$B$4:$H$19,4,FALSE))=TRUE,0,VLOOKUP($C75,'Coverage Reference'!$B$4:$H$19,4,FALSE)*(F75+H75))","v":0},{"$f":"IF(ISNA(VLOOKUP($C75,'Coverage Reference'!$B$4:$H$19,5,FALSE))=TRUE,0,VLOOKUP($C75,'Coverage Reference'!$B$4:$H$19,5,FALSE)*(F75+H75))","v":0},{"$f":"IF(ISNA(VLOOKUP($C75,'Coverage Reference'!$B$4:$H$19,6,FALSE))=TRUE,0,VLOOKUP($C75,'Coverage Reference'!$B$4:$H$19,6,FALSE)*(F75+H75))","v":0}]
["QUALIFYING EOP PRODUCTS SUB-TOTAL",{"$nulls":5},{"$f":"SUM(G42:G75)","v":0},null,null,{"$f":"I76+G76","v":0}]
[]
[]
[]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2024 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,"hidden":true,"merged":[[15,0,15,1],[16,0,16,1],[19,0,19,8],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,20,4],[20,5,20,6],[20,7,20,8],[22,0,23,0],[24,0,25,0],[26,0,27,0],[29,0,30,0],[31,0,32,0],[33,0,34,0],[35,0,36,0],[39,0,46,8]]}
{"$rows_empty":14}
["Enter Acres for your Course (Required)"]
["Fairways & Tees Acres",null,{"v":40,"d":"40.00"}]
["Greens Acres",null,{"v":10,"d":"10.00"}]
[]
["Please complete Yellow \"Use Area\" cells with either Fairways or Greens"]
["Fungicide Planner",{"$nulls":11},"Fairways"]
["Product Name","Case Size","Use Area","Low Rate",null,"Mid Rate",null,"High Rate",{"$nulls":4},"Greens"]
[{"$nulls":3},"Total Acres","Applications","Total Acres","Applications","Total Acres","Applications"]
["Emerald","10 x .49 lb.","Fairways",{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K23)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K23)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K23)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K24)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K24)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K24)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K24)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K24)","v":0},0,null,59012825]
["Honor","1 x 36 lb",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K25)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K25)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K25)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K25)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K25)","v":0},0,null,59012885]
[null,"6 x 3 lb",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K26)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K26)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K26)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$K26)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$38,'Step 2 - Order Planner'!$C$26:$C$38,$K26)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K26)","v":0},0,null,59012350]
["Insignia SC","2 x 2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K27)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K27)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K27)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K27)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K27)","v":0},0,null,59014135]
[null,"4 x 30.5 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K28)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K28)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K28)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K28)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K29)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K29)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K29)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$K29)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$38,'Step 2 - Order Planner'!$C$26:$C$38,$K29)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K29)","v":0},0,null,59013840]
["Maxtima","4 x26 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K30)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K30)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K30)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$K30)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$38,'Step 2 - Order Planner'!$C$26:$C$38,$K30)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K30)","v":0},0,null,59018087]
[null,"2x 2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K31)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K31)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K31)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K31)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K31)","v":0},0,null,59018071]
["Navicon","4x37 fl oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K32)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K32)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K32)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$K32)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$38,'Step 2 - Order Planner'!$C$26:$C$38,$K32)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K32)","v":0},0,null,59018094]
[null,"2x2.5 gal",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K33)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K33)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K33)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$K33)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$38,'Step 2 - Order Planner'!$C$26:$C$38,$K33)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K33)","v":0},0,null,59018095]
["Pillar G","15 lbs",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K34)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K34)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K34)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K34)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K34)","v":0},0,null,59017959]
[null,"30 lbs ",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K35)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K35)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K35)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$K35)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$38,'Step 2 - Order Planner'!$C$26:$C$38,$K35)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$K35)","v":0},0,null,59012784]
["Xzemplar","2 x 114 oz",null,{"$f":"SUMIFS('Step 2 - Order Planner'!J$26:J$38,'Step 2 - Order Planner'!$C$26:$C$38,$K36)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K36)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K36)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$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$38,'Step 2 - Order Planner'!$C$26:$C$38,$K37)+SUMIFS('Step 2 - Order Planner'!J$42:J$75,'Step 2 - Order Planner'!$C$42:$C$75,$K37)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!K$26:K$38,'Step 2 - Order Planner'!$C$26:$C$38,$K37)+SUMIFS('Step 2 - Order Planner'!K$42:K$75,'Step 2 - Order Planner'!$C$42:$C$75,$K37)","v":0},0,{"$f":"SUMIFS('Step 2 - Order Planner'!L$26:L$38,'Step 2 - Order Planner'!$C$26:$C$38,$K37)+SUMIFS('Step 2 - Order Planner'!L$42:L$75,'Step 2 - Order Planner'!$C$42:$C$75,$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":72,"n_cols":6,"rows_kept":72,"merged":[[10,0,11,5],[18,3,19,4],[18,5,19,5],[21,2,22,3],[38,0,38,4],[69,0,69,4],[71,0,80,5]]}
{"$rows_empty":10}
["BASF 2024 EOP ORDER SUMMARY"]
[]
[{"$f":"NOW()","v":"2023-08-08T16:56:15.450"},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":{"v":0,"d":"0%"}}]
["<Enter Business Name>","<Enter Business Name>",null,"Across-The-Course Rebate",null,{"$f":"'Step 2 - Order Planner'!B21","v":{"v":0,"d":"0%"}}]
["<City, ST Zip Code>","<City, ST Zip Code>",null,"Insignia® Intrinsic® Kicker - 5%",null,{"$f":"'Step 2 - Order Planner'!B22","v":0}]
["<Phone>","<Phone>",null,"Honor® Intrinsic® Kicker - 5%",null,{"$f":"'Step 2 - Order Planner'!B23","v":0}]
["<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$50,2,FALSE)","v":"Emerald® fungicide"},{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"10 x 0.49 lb"},59021463,{"$f":"VLOOKUP($C26,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1187.4,"d":"$1,187.40"}},{"$f":"VLOOKUP(C26,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C26,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E26*D26","v":0}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Encartis® fungicide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59014003,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":645.66,"d":"$645.66"}},{"$f":"VLOOKUP(C27,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C27,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E27*D27","v":0}]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"6 x 3 lb"},59012350,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":3303.54,"d":"$3,303.54"}},{"$f":"VLOOKUP(C28,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C28,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 36 lb"},59012885,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":4867.2,"d":"$4,867.20"}},{"$f":"VLOOKUP(C29,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C29,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":2169.16,"d":"$2,169.16"}},{"$f":"VLOOKUP(C30,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C30,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59014135,{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":7225.1,"d":"$7,225.10"}},{"$f":"VLOOKUP(C31,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C31,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 21 oz"},59027998,{"$f":"VLOOKUP($C32,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":2418.36,"d":"$2,418.36"}},{"$f":"VLOOKUP(C32,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C32,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 26 oz"},59018087,{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":907.92,"d":"$907.92"}},{"$f":"VLOOKUP(C33,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C33,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59018071,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":4508.4,"d":"$4,508.40"}},{"$f":"VLOOKUP(C34,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C34,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 37 fl oz"},59018094,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":2172.64,"d":"$2,172.64"}},{"$f":"VLOOKUP(C35,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C35,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59018095,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":6998,"d":"$6,998.00"}},{"$f":"VLOOKUP(C36,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C36,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":808.04,"d":"$808.04"}},{"$f":"VLOOKUP(C37,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C37,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":3451.92,"d":"$3,451.92"}},{"$f":"VLOOKUP(C38,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C38,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
["Design-Your-Own-Program Rebate Purchases Sub-Total",{"$nulls":4},{"$f":"'Step 2 - Order Planner'!H17","v":0}]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Admiral® lake colorant"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59014151,{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":251.45,"d":"$251.45"}},{"$f":"VLOOKUP(C40,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C40,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Alucion® 35 WG insecticide"},{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"10 x 2.375 lbs"},59024020,{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":2442.9,"d":"$2,442.90"}},{"$f":"VLOOKUP(C41,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C41,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E41*D41","v":0}]
[{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":536.25,"d":"$536.25"}},{"$f":"VLOOKUP(C42,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C42,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Basagran® herbicide"},{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 1 gal"},59011636,{"$f":"VLOOKUP($C43,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":125.58,"d":"$125.58"}},{"$f":"VLOOKUP(C43,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C43,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Black Onyx lake & pond colorant"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59013424,{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":428,"d":"$428.00"}},{"$f":"VLOOKUP(C44,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C44,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":221.25,"d":"$221.25"}},{"$f":"VLOOKUP(C45,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C45,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":514.44,"d":"$514.44"}},{"$f":"VLOOKUP(C46,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C46,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E46*D46","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Finale®  XL T&O herbicide "},{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59024131,{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":543.75,"d":"$543.75"}},{"$f":"VLOOKUP(C47,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C47,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E47*D47","v":0}]
[{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"FreeHand® 1.75G herbicide"},{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 50 lb"},59011296,{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":109.5,"d":"$109.50"}},{"$f":"VLOOKUP(C48,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C48,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Green Lawnger® colorant"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59013430,{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":376.56,"d":"$376.56"}},{"$f":"VLOOKUP(C49,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C49,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Green Lawnger® Transition HC colorant"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59013410,{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":787.5,"d":"$787.50"}},{"$f":"VLOOKUP(C50,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C50,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Green Lawnger® Vision Pro colorant"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 gal"},59013342,{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":707.5,"d":"$707.50"}},{"$f":"VLOOKUP(C51,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C51,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Orkestra® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 16 oz"},59014379,{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":668.8,"d":"$668.80"}},{"$f":"VLOOKUP(C52,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C52,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":443.36,"d":"$443.36"}},{"$f":"VLOOKUP(C53,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C53,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":48.5,"d":"$48.50"}},{"$f":"VLOOKUP(C54,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C54,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":85.5,"d":"$85.50"}},{"$f":"VLOOKUP(C55,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C55,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E55*D55","v":0}]
[{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C56,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":281.25,"d":"$281.25"}},{"$f":"VLOOKUP(C56,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C56,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C57,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":983.1,"d":"$983.10"}},{"$f":"VLOOKUP(C57,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C57,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E57*D57","v":0}]
[{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C58,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":56.63,"d":"$56.63"}},{"$f":"VLOOKUP(C58,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C58,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C59,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":105,"d":"$105.00"}},{"$f":"VLOOKUP(C59,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C59,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C60,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1376,"d":"$1,376.00"}},{"$f":"VLOOKUP(C60,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C60,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Segment® II herbicide"},{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59014427,{"$f":"VLOOKUP($C61,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1562.5,"d":"$1,562.50"}},{"$f":"VLOOKUP(C61,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C61,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C62,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":294.19,"d":"$294.19"}},{"$f":"VLOOKUP(C62,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C62,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C63,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":709.68,"d":"$709.68"}},{"$f":"VLOOKUP(C63,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C63,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C64,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1972.5,"d":"$1,972.50"}},{"$f":"VLOOKUP(C64,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C64,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C65,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator"},{"$f":"VLOOKUP($C65,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"12 x 0.25 gal"},59013723,{"$f":"VLOOKUP($C65,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":247.5,"d":"$247.50"}},{"$f":"VLOOKUP(C65,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C65,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator"},{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"1 x 30 gal"},59013314,{"$f":"VLOOKUP($C66,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1556.25,"d":"$1,556.25"}},{"$f":"VLOOKUP(C66,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C66,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C67,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator - blue"},{"$f":"VLOOKUP($C67,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59013417,{"$f":"VLOOKUP($C67,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":278.13,"d":"$278.13"}},{"$f":"VLOOKUP(C67,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C67,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C68,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Turf Mark spray indicator - green"},{"$f":"VLOOKUP($C68,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"2 x 2.5 gal"},59013486,{"$f":"VLOOKUP($C68,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":333.88,"d":"$333.88"}},{"$f":"VLOOKUP(C68,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C68,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C69,'Article Reference'!$A$3:$D$50,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C69,'Article Reference'!$A$3:$D$50,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C69,'Article Reference'!$A$3:$D$50,4,FALSE)","v":{"v":1266.4,"d":"$1,266.40"}},{"$f":"VLOOKUP(C69,'Step 2 - Order Planner'!$C$26:$H$75,4,FALSE)+VLOOKUP(C69,'Step 2 - Order Planner'!$C$26:$H$75,6,FALSE)","v":0},{"$f":"E69*D69","v":0}]
["Across-the-Course-Solutions Rebate Purchase Sub-Total",{"$nulls":4},{"$f":"'Step 2 - Order Planner'!H19","v":0}]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2024 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":24,"rows_kept":23,"hidden":true,"merged":[[1,16,2,16],[1,17,2,17],[1,18,2,18],[4,16,5,16],[4,17,5,17],[4,18,5,18],[5,2,5,3],[6,16,7,16],[6,17,7,17],[6,18,7,18],[9,16,10,16],[9,17,10,17],[9,18,10,18],[11,16,12,16],[11,17,12,17],[11,18,12,18],[13,16,15,16],[13,17,15,17],[13,18,15,18],[15,2,15,3],[22,2,22,3]]}
["Standard",null,"Oct","Nov-Dec",{"$nulls":7},"Article#","Article","Package","Oct Order","Nov-Dec Order","Oct Count","Nov-Dec Count","Total","Case Size","Total Vol","Gal/LB Coversion","Gal/LB Volume"]
["Low","High","Discount","Discount","Oct Applied",null,"Rebate Applied",{"$nulls":4},59021463,{"$f":"VLOOKUP($L2,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Emerald® fungicide"},{"$f":"VLOOKUP($L2,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"10 x 0.49 lb"},{"$f":"VLOOKUP(L2,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L2,'Step 2 - Order Planner'!$C$26:$H$38,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}]
[{"v":3000,"d":"$3,000.00"},{"$f":"A4-1","v":{"v":7999,"d":"$7,999.00"}},{"v":0.04,"d":"4%"},{"v":0.04,"d":"4%"},{"$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":{"v":0,"d":"0%"}}]
[{"v":8000,"d":"$8,000.00"},{"$f":"A5-1","v":{"v":19999,"d":"$19,999.00"}},{"v":0.06,"d":"6%"},{"v":0.06,"d":"6%"},{"$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":{"v":0,"d":"0%"}},{"$nulls":4},59014003,{"$f":"VLOOKUP($L4,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Encartis® fungicide"},{"$f":"VLOOKUP($L4,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L4,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L4,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0},{"$f":"IF(O4>0,1,0)","v":0},{"$f":"IF(P4>0,1,0)","v":0},{"$f":"IF(OR(Q4=1,R4=1),1,0)","v":0}]
[{"v":20000,"d":"$20,000.00"},{"v":1000000,"d":"$1,000,000.00"},{"v":0.12,"d":"12%"},{"v":0.12,"d":"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":{"v":0,"d":"0%"}},{"$nulls":4},59012350,{"$f":"VLOOKUP($L5,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L5,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"6 x 3 lb"},{"$f":"VLOOKUP(L5,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L5,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0},{"$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},{"$f":"6*3","v":18},{"$f":"(O5+P5)*T5","v":0},1,{"$f":"V5*U5","v":0}]
[null,null,"DISCOUNT",null,{"$f":"SUM(E3:E5)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(E6:F6)","v":{"v":0,"d":"0%"}},{"$nulls":4},59012885,{"$f":"VLOOKUP($L6,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Honor® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L6,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"1 x 36 lb"},{"$f":"VLOOKUP(L6,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L6,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0},{"$nulls":3},{"$f":"1*36","v":36},{"$f":"(O6+P6)*T6","v":0},1,{"$f":"V6*U6","v":0}]
[{"$nulls":4},0,{"$nulls":6},59014134,{"$f":"VLOOKUP($L7,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L7,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 30.5 fl oz"},{"$f":"VLOOKUP(L7,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L7,'Step 2 - Order Planner'!$C$26:$H$38,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},{"$f":"4*30.5","v":122},{"$f":"(O7+P7)*T7","v":0},7.8125E-3,{"$f":"V7*U7","v":0}]
[{"$nulls":11},59014135,{"$f":"VLOOKUP($L8,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L8,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L8,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L8,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0},{"$nulls":3},5,{"$f":"(O8+P8)*T8","v":0},1,{"$f":"V8*U8","v":0}]
["DYOP",null,"Oct","Nov-Dec",{"$nulls":7},59027998,{"$f":"VLOOKUP($L9,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Lexicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L9,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 21 oz"},{"$f":"VLOOKUP(L9,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L9,'Step 2 - Order Planner'!$C$26:$H$38,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},{"$nulls":3},59018087,{"$f":"VLOOKUP($L10,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($L10,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 26 oz"},{"$f":"VLOOKUP(L10,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L10,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0},{"$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}]
[{"v":3000,"d":"$3,000.00"},{"$f":"A12-1","v":{"v":7999,"d":"$7,999.00"}},{"v":0.08,"d":"8%"},{"v":0.04,"d":"4%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39)>=3000,Q17>=1),C11)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$39)>=3000,S17>=1),D11)","v":false},{"$f":"IF(E11<>FALSE,E11,F11)","v":false},{"$f":"A11-H10","v":{"v":3000,"d":"$3,000.00"}},{"v":0.08,"d":"8%"},null,null,59018071,{"$f":"VLOOKUP($L11,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Maxtima® fungicide"},{"$f":"VLOOKUP($L11,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L11,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L11,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0}]
[{"v":8000,"d":"$8,000.00"},{"$f":"A13-1","v":{"v":19999,"d":"$19,999.00"}},{"v":0.14,"d":"14%"},{"v":0.07,"d":"7%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39)>=3000,$Q$17>=1,'Step 2 - Order Planner'!J39>=$A12,'Step 2 - Order Planner'!J39<=$B12),C12)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$39)>=3000,$S$17>=1,'Step 2 - Order Planner'!J39>=$A12,'Step 2 - Order Planner'!J39<=$B12),D12)","v":false},{"$f":"IF(E12<>FALSE,E12,F12)","v":false},{"$f":"A12-H10","v":{"v":8000,"d":"$8,000.00"}},{"v":0.14,"d":"14%"},null,null,59018094,{"$f":"VLOOKUP($L12,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L12,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 37 fl oz"},{"$f":"VLOOKUP(L12,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L12,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0},{"$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}]
[{"v":20000,"d":"$20,000.00"},{"$f":"A14-1","v":{"v":29999,"d":"$29,999.00"}},{"v":0.17,"d":"17%"},{"v":0.1,"d":"10%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39)>=3000,Q17>=1,'Step 2 - Order Planner'!J39>=$A13,'Step 2 - Order Planner'!J39<=$B13),C13)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$39)>=3000,$S$17>=1,'Step 2 - Order Planner'!J39>=$A13,'Step 2 - Order Planner'!J39<=$B13),D13)","v":false},{"$f":"IF(E13<>FALSE,E13,F13)","v":false},{"$f":"A13-H10","v":{"v":20000,"d":"$20,000.00"}},{"v":0.17,"d":"17%"},null,null,59018095,{"$f":"VLOOKUP($L13,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Navicon® Intrinsic® brand fungicide"},{"$f":"VLOOKUP($L13,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 2.5 gal"},{"$f":"VLOOKUP(L13,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L13,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0}]
[{"v":30000,"d":"$30,000.00"},{"$f":"A15-1","v":{"v":39999,"d":"$39,999.00"}},{"v":0.2,"d":"20%"},{"v":0.12,"d":"12%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39)>=3000,Q17>=1,'Step 2 - Order Planner'!J39>=$A14,'Step 2 - Order Planner'!J39<=$B14),C14)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$39)>=3000,$S$17>=1,'Step 2 - Order Planner'!J39>=$A14,'Step 2 - Order Planner'!J39<=$B14),D14)","v":false},{"$f":"IF(E14<>FALSE,E14,F14)","v":false},{"$f":"A14-H10","v":{"v":30000,"d":"$30,000.00"}},{"v":0.2,"d":"20%"},null,null,59013833,{"$f":"VLOOKUP($L14,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($L14,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"2 x 114 oz"},{"$f":"VLOOKUP(L14,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L14,'Step 2 - Order Planner'!$C$26:$H$38,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}]
[{"v":40000,"d":"$40,000.00"},{"v":10000000,"d":"$10,000,000.00"},{"v":0.24,"d":"24%"},{"v":0.14,"d":"14%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39)>=3000,Q17>=1,'Step 2 - Order Planner'!J39>=$A15,'Step 2 - Order Planner'!J39<=$B15),C15)","v":false},{"$f":"IF(AND(('Step 2 - Order Planner'!$J$39)>=3000,$S$17>=1,'Step 2 - Order Planner'!J40>=$A15,'Step 2 - Order Planner'!J40<=$B15),D15)","v":false},{"$f":"IF(E15<>FALSE,E15,F15)","v":false},{"$f":"A15-H10","v":{"v":40000,"d":"$40,000.00"}},{"v":0.24,"d":"24%"}]
[null,null,"DISCOUNT",{"$nulls":3},{"$f":"MAX(G11:G15)","v":{"v":0,"d":"0%"}},{"$f":"MIN(IF(H11:H15>0,H11:H15))","v":{"v":3000,"d":"$3,000.00"}},{"$nulls":3},59014120,{"$f":"VLOOKUP($L16,'Article Reference'!$A$3:$C$15,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($L16,'Article Reference'!$A$3:$C$15,3,FALSE)","v":"4 x 11.4 oz"},{"$f":"VLOOKUP(L16,'Step 2 - Order Planner'!$C$26:$F$38,4,FALSE)","v":0},{"$f":"VLOOKUP(L16,'Step 2 - Order Planner'!$C$26:$H$38,6,FALSE)","v":0}]
[{"$nulls":16},{"$f":"SUM(Q2:Q16)","v":0},{"$f":"SUM(R2:R16)","v":0},{"$f":"SUM(S2:S16)","v":0},null,null,{"$f":"'Step 2 - Order Planner'!G30+'Step 2 - Order Planner'!G31+'Step 2 - Order Planner'!I30+'Step 2 - Order Planner'!I31","v":0},{"$f":"SUM(W7:W8)","v":0},"Insignia Total"]
["Table B for Fungicides",{"$nulls":20},{"$f":"'Step 2 - Order Planner'!G28+'Step 2 - Order Planner'!G29+'Step 2 - Order Planner'!I28+'Step 2 - Order Planner'!I29","v":0},{"$f":"SUM(W5:W6)","v":0},"Honor Total"]
["Low","High","Discount","Discount",null,null,"Rebate Applied",{"$f":"'Step 2 - Order Planner'!H19:I19","v":0}]
[{"v":3000,"d":"$3,000.00"},{"$f":"A21-1","v":{"v":7999,"d":"$7,999.00"}},{"v":0.04,"d":"4%"},{"v":0.04,"d":"4%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76)>=3000,'Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76>=$A20,'Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76<=$B20,S17<=3),C20)","v":false},{"$f":"IF(AND(SUM('Step 2 - Order Planner'!G26:G38)>=3000,SUM('Step 2 - Order Planner'!G26:G38)<8000),0.04,0)","v":{"v":0,"d":"0%"}},{"$f":"SUM(E20:F20)","v":{"v":0,"d":"0%"}},{"$f":"A20-$H$19","v":{"v":3000,"d":"$3,000.00"}},{"v":0.04,"d":"4%"},{"$nulls":10},">>Above yellow is not used, but could be for kickers"]
[{"v":8000,"d":"$8,000.00"},{"$f":"A22-1","v":{"v":19999,"d":"$19,999.00"}},{"v":0.06,"d":"6%"},{"v":0.06,"d":"6%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76)>=3000,'Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76>=$A21,'Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76<=$B21,S17<=3),C21)","v":false},null,{"$f":"SUM(E21:F21)","v":{"v":0,"d":"0%"}},{"$f":"A21-$H$19","v":{"v":8000,"d":"$8,000.00"}},{"v":0.06,"d":"6%"}]
[{"v":20000,"d":"$20,000.00"},{"v":1000000,"d":"$1,000,000.00"},{"v":0.12,"d":"12%"},{"v":0.12,"d":"12%"},{"$f":"IF(AND(('Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76)>=3000,'Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76>=$A22,'Step 2 - Order Planner'!$G$39+'Step 2 - Order Planner'!$I$39+'Step 2 - Order Planner'!$G$76<=$B22,S17<=3),C22)","v":false},null,{"$f":"SUM(E22:F22)","v":{"v":0,"d":"0%"}},{"v":20000,"d":"$20,000.00"},{"v":0.12,"d":"12%"}]
[null,null,"DISCOUNT",null,{"$f":"SUM(E20:E22)","v":{"v":0,"d":"0%"}},{"$f":"SUM(F20:F22)","v":{"v":0,"d":"0%"}},{"$f":"SUM(E23:F23)","v":{"v":0,"d":"0%"}},{"$f":"MIN(IF(H20:H22>0,H20:H22))","v":{"v":3000,"d":"$3,000.00"}}]

{"sheet":"Article Reference","index":5,"n_rows":51,"n_cols":12,"rows_kept":51,"hidden":true,"merged":[[0,0,0,4],[16,0,16,4]]}
["2022 Qualifying Fungicides"]
["Article Number","Qaulifying Non-Agency Products","Package","Price","CA Redemption","Case UOM","Price/UOM","Case Price"]
[59021463,"Emerald® fungicide","10 x 0.49 lb",{"v":1187.4,"d":"$1,187.40"},{"v":1213.2,"d":"$1,213.20"},{"$f":"10*0.49","v":4.9},{"$f":"H3/F3","v":{"v":242.3265306122449,"d":"$242.33"}},{"$f":"D3","v":{"v":1187.4,"d":"$1,187.40"}}]
[59014003,"Encartis® fungicide","2 x 2.5 gal",{"v":645.66,"d":"$645.66"},{"v":659.7,"d":"$659.70"},{"$f":"2*2.5","v":5},{"$f":"H4/F4","v":{"v":129.132,"d":"$129.13"}},{"$f":"D4","v":{"v":645.66,"d":"$645.66"}}]
[59012350,"Honor® Intrinsic® brand fungicide","6 x 3 lb",{"v":3303.54,"d":"$3,303.54"},{"v":3375.36,"d":"$3,375.36"},{"$f":"6*3","v":18},{"v":183.53,"d":"$183.53"},{"v":3303.54,"d":"$3,303.54"}]
[59012885,"Honor® Intrinsic® brand fungicide","1 x 36 lb",{"v":4867.2,"d":"$4,867.20"},{"v":4973.04,"d":"$4,973.04"},36,{"v":135.2,"d":"$135.20"},{"v":4867.2,"d":"$4,867.20"}]
[59014134,"Insignia® SC Intrinsic® brand fungicide","4 x 30.5 fl oz",{"v":2169.16,"d":"$2,169.16"},{"v":2216.76,"d":"$2,216.76"},{"$f":"4*30.5","v":122},{"v":17.779999999999998,"d":"$17.78"},{"v":2169.16,"d":"$2,169.16"}]
[59014135,"Insignia® SC Intrinsic® brand fungicide","2 x 2.5 gal",{"v":7225.1,"d":"$7,225.10"},{"v":7382.26,"d":"$7,382.26"},5,{"v":1445.02,"d":"$1,445.02"},{"v":7225.1,"d":"$7,225.10"}]
[59027998,"Lexicon® Intrinsic® brand fungicide","4 x 21 oz",{"v":2418.36,"d":"$2,418.36"},{"v":2471.28,"d":"$2,471.28"},{"$f":"4*21","v":84},{"v":28.790000000000003,"d":"$28.79"},{"v":2418.36,"d":"$2,418.36"}]
[59018087,"Maxtima® fungicide","4 x 26 oz",{"v":907.92,"d":"$907.92"},{"v":927.68,"d":"$927.68"},{"$f":"4*26","v":104},{"v":8.73,"d":"$8.73"},{"v":907.92,"d":"$907.92"}]
[59018071,"Maxtima® fungicide","2 x 2.5 gal",{"v":4508.4,"d":"$4,508.40"},{"v":4606.46,"d":"$4,606.46"},5,{"v":901.68,"d":"$901.68"},{"v":4508.4,"d":"$4,508.40"}]
[59018094,"Navicon® Intrinsic® brand fungicide","4 x 37 fl oz",{"v":2172.64,"d":"$2,172.64"},{"v":2220,"d":"$2,220.00"},{"$f":"4*37","v":148},{"v":14.68,"d":"$14.68"},{"v":2172.64,"d":"$2,172.64"}]
[59018095,"Navicon® Intrinsic® brand fungicide","2 x 2.5 gal",{"v":6998,"d":"$6,998.00"},{"v":7150.2,"d":"$7,150.20"},5,{"v":1399.6,"d":"$1,399.60"},{"v":6998,"d":"$6,998.00"}]
[59013833,"Xzemplar® fungicide","2 x 114 oz",{"v":3451.92,"d":"$3,451.92"},{"v":3527.16,"d":"$3,527.16"},{"$f":"2*114","v":228},{"v":15.14,"d":"$15.14"},{"v":3451.92,"d":"$3,451.92"}]
[59014120,"Xzemplar® fungicide","4 x 11.4 oz",{"v":808.04,"d":"$808.04"},{"v":825.8,"d":"$825.80"},{"$f":"4*11.4","v":45.6},{"v":17.72017543859649,"d":"$17.72"},{"v":808.04,"d":"$808.04"}]
[{"$nulls":3},{"$f":"SUM(D3:D15)","v":{"v":40663.34,"d":"$40,663.34"}},{"$f":"SUM(E3:E15)","v":{"v":41548.899999999994,"d":"$41,548.90"}}]
["2022 Rest of Portfolio"]
["Article Number","Qaulifying Non-Agency Products","Package","Price","CA Redemption"]
[59014151,"Admiral® lake colorant","4 x 1 gal",{"v":251.45,"d":"$251.45"},{"$f":"D19","v":{"v":251.45,"d":"$251.45"}},4,{"$f":"H19/F19","v":{"v":62.8625,"d":"$62.86"}},{"$f":"D19","v":{"v":251.45,"d":"$251.45"}}]
[59024020,"Alucion® 35 WG insecticide","10 x 2.375 lbs",{"v":2442.9,"d":"$2,442.90"},"NO CA",{"$f":"10*38","v":380},{"v":6.428684210526316,"d":"$6.43"},{"v":2442.9,"d":"$2,442.90"}]
[59021451,"Amdro Pro Fire Ant Bait","1 x 25lbs",{"v":536.25,"d":"$536.25"},{"$f":"D21","v":{"v":536.25,"d":"$536.25"}},25,{"v":21.45,"d":"$21.45"},{"v":536.25,"d":"$536.25"}]
[59011636,"Basagran® herbicide","2 x 1 gal",{"v":125.58,"d":"$125.58"},"NO CA",2,{"v":62.79,"d":"$62.79"},{"v":125.58,"d":"$125.58"}]
[59013424,"Black Onyx lake & pond colorant","4 x 1 gal",{"v":428,"d":"$428.00"},{"v":428,"d":"$428.00"},4,{"v":107,"d":"$107.00"},{"v":428,"d":"$428.00"}]
[59011404,"Drive® XLR8 herbicide","4 x 0.5 gal",{"v":221.25,"d":"$221.25"},{"v":221.25,"d":"$221.25"},{"$f":"4*0.5","v":2},{"v":110.625,"d":"$110.63"},{"v":221.25,"d":"$221.25"}]
[59018043,"Drive® XLR8 herbicide","2 x 2.5 gal",{"v":514.44,"d":"$514.44"},{"v":514.44,"d":"$514.44"},null,null,{"v":514.44,"d":"$514.44"}]
[59024131,"Finale®  XL T&O herbicide ","2 x 2.5 gal",{"v":543.75,"d":"$543.75"},{"v":543.75,"d":"$543.75"},5,{"$f":"H26/F26","v":{"v":108.75,"d":"$108.75"}},{"v":543.75,"d":"$543.75"}]
[59011296,"FreeHand® 1.75G herbicide","1 x 50 lb",{"v":109.5,"d":"$109.50"},{"v":112,"d":"$112.00"},50,{"v":2.19,"d":"$2.19"},{"v":109.5,"d":"$109.50"},null,59013674,"FreeHand® 1.75G CA herbicide","1 x 50 lb"]
[59013430,"Green Lawnger® colorant","2 x 2.5 gal",{"v":376.56,"d":"$376.56"},{"$f":"D28","v":{"v":376.56,"d":"$376.56"}},5,{"v":75.312,"d":"$75.31"},{"v":376.56,"d":"$376.56"}]
[59013410,"Green Lawnger® Transition HC colorant","4 x 1 gal",{"v":787.5,"d":"$787.50"},{"v":787.5,"d":"$787.50"},4,{"v":196.875,"d":"$196.88"},{"v":787.5,"d":"$787.50"}]
[59013342,"Green Lawnger® Vision Pro colorant","4 x 1 gal",{"v":707.5,"d":"$707.50"},{"v":707.5,"d":"$707.50"},4,{"v":176.875,"d":"$176.88"},{"v":707.5,"d":"$707.50"}]
[59020732,"Insignia® SC Intrinsic® brand fungicide","4 x 122 oz",{"v":9760,"d":"$9,760.00"},{"$f":"D31","v":{"v":9760,"d":"$9,760.00"}},{"$f":"4*122","v":488},{"v":20,"d":"$20.00"},{"v":9760,"d":"$9,760.00"},null,"<--","lawn care only?"]
[59014379,"Orkestra® Intrinsic® brand Fungicide","4 x 16 oz",{"v":668.8,"d":"$668.80"},{"v":683.52,"d":"$683.52"},{"$f":"4*16","v":64},{"v":10.45,"d":"$10.45"},{"v":668.8,"d":"$668.80"}]
[59012349,"Pageant® Intrinsic® brand Fungicide","4 x 1 lb",{"v":443.36,"d":"$443.36"},{"v":453,"d":"$453.00"},4,{"v":110.84,"d":"$110.84"},{"v":443.36,"d":"$443.36"}]
[59017972,"Pendulum® 2G herbicide","20 lbs bag",{"v":48.5,"d":"$48.50"},{"$f":"D34","v":{"v":48.5,"d":"$48.50"}},20,{"v":2.425,"d":"$2.43"},{"v":48.5,"d":"$48.50"}]
[59015072,"Pendulum® 2G herbicide","40 lbs bag",{"v":85.5,"d":"$85.50"},{"v":85.5,"d":"$85.50"},40,{"v":2.1375,"d":"$2.14"},{"v":85.5,"d":"$85.50"}]
[59049276,"Pendulum® AquaCap herbicide","2 x 2.5 gal",{"v":281.25,"d":"$281.25"},{"v":281.25,"d":"$281.25"},5,{"v":56.25,"d":"$56.25"},{"v":281.25,"d":"$281.25"}]
[59011279,"Pendulum® AquaCap herbicide","1 x 15 gal",{"v":983.1,"d":"$983.10"},{"v":1004.55,"d":"$1,004.55"},15,{"v":65.54,"d":"$65.54"},{"v":983.1,"d":"$983.10"}]
[59017959,"Pillar® G Intrinsic® brand fungicide","15 lbs bag",{"v":56.63,"d":"$56.63"},{"$f":"D38","v":{"v":56.63,"d":"$56.63"}},15,{"v":3.7753333333333337,"d":"$3.78"},{"v":56.63,"d":"$56.63"}]
[59012784,"Pillar® G Intrinsic® brand fungicide","30 lbs bag",{"v":105,"d":"$105.00"},{"v":105,"d":"$105.00"},30,{"v":3.5,"d":"$3.50"},{"v":105,"d":"$105.00"}]
[59026395,"Pillar® SC Intrinsic brand fungicide","4 x 43.5 oz",{"v":856.95,"d":"$856.95"},{"$f":"D40","v":{"v":856.95,"d":"$856.95"}},{"$f":"4*43.5","v":174},{"v":4.925,"d":"$4.93"},{"v":856.95,"d":"$856.95"},null,"<--","lawn care only?","CA Registration?"]
[59018005,"Pylex® herbicide","4 x 4 oz",{"v":1376,"d":"$1,376.00"},{"v":1405.92,"d":"$1,405.92"},16,{"v":86,"d":"$86.00"},{"v":1376,"d":"$1,376.00"}]
[59014427,"Segment® II herbicide","2 x 2.5 gal",{"v":1562.5,"d":"$1,562.50"},"NO CA",5,{"v":312.5,"d":"$312.50"},{"v":1562.5,"d":"$1,562.50"}]
[59011057,"Siesta® Fire Ant Bait","15 lbs",{"v":294.19,"d":"$294.19"},{"$f":"D43","v":{"v":294.19,"d":"$294.19"}},15,{"v":19.612666666666666,"d":"$19.61"},{"v":294.19,"d":"$294.19"}]
[59023753,"Sultan® miticide","4 x 0.125 gal",{"v":709.68,"d":"$709.68"},{"v":725.12,"d":"$725.12"},{"$f":"4*0.125","v":0.5},{"v":1419.36,"d":"$1,419.36"},{"v":709.68,"d":"$709.68"}]
[59014247,"Tower® herbicide","2 x 2.5 gal",{"v":1972.5,"d":"$1,972.50"},{"v":2015.4,"d":"$2,015.40"},5,{"v":394.5,"d":"$394.50"},{"v":1972.5,"d":"$1,972.50"}]
[59013723,"Turf Mark spray indicator","12 x 0.25 gal",{"v":247.5,"d":"$247.50"},{"$f":"D46","v":{"v":247.5,"d":"$247.50"}},{"$f":"12*0.25","v":3},{"v":82.5,"d":"$82.50"},{"v":247.5,"d":"$247.50"}]
[59013314,"Turf Mark spray indicator","1 x 30 gal",{"v":1556.25,"d":"$1,556.25"},{"v":1556.25,"d":"$1,556.25"},30,{"v":51.875,"d":"$51.88"},{"v":1556.25,"d":"$1,556.25"}]
[59013417,"Turf Mark spray indicator - blue","2 x 2.5 gal",{"v":278.13,"d":"$278.13"},{"v":278.13,"d":"$278.13"},5,{"v":55.626,"d":"$55.63"},{"v":278.13,"d":"$278.13"}]
[59013486,"Turf Mark spray indicator - green","2 x 2.5 gal",{"v":333.88,"d":"$333.88"},{"v":333.88,"d":"$333.88"},5,{"v":66.776,"d":"$66.78"},{"v":333.88,"d":"$333.88"}]
[59014680,"Ventigra® insecticide","4 x 20 oz",{"v":1266.4,"d":"$1,266.40"},{"v":1293.6,"d":"$1,293.60"},{"$f":"4*20","v":80},{"v":15.830000000000002,"d":"$15.83"},{"v":1266.4,"d":"$1,266.40"}]
[{"$nulls":3},{"$f":"SUM(D19:D50)","v":{"v":29930.800000000003,"d":"$29,930.80"}},{"$f":"SUM(E19:E50)","v":{"v":25963.590000000004,"d":"$25,963.59"}}]

{"sheet":"Coverage Reference","index":6,"n_rows":39,"n_cols":13,"rows_kept":39,"hidden":true,"merged":[[1,0,1,1]]}
["Calculator Acreage"]
["Acre Coverage",{"$nulls":3},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"]
["Emerald® Fungicide",59021463,"10 x .49 lb.",{"$nulls":4},{"v":10,"d":"10.00"},null,null,{"v":13.9,"d":"13.90"},{"v":12,"d":"12.00"},{"v":10,"d":"10.00"}]
["Emerald® Fungicide",59012825,"50 x .49 lb.",{"$nulls":4},{"v":50,"d":"50.00"},null,null,{"v":69.3,"d":"69.30"},{"v":60,"d":"60.00"},{"v":50,"d":"50.00"}]
["Encartis® fungicide",59014003,"2 x 2.5 gal",null,null,{"v":4.9,"d":"4.90"},{"v":4.2,"d":"4.20"},{"v":3.7,"d":"3.70"},null,null,{"v":99,"d":"99.00"},{"v":99,"d":"99.00"},{"v":99,"d":"99.00"}]
["Honor® Intrinsic™ brand Fungicide",59012885,"1 x 36 lb",{"$nulls":4},{"v":12,"d":"12.00"},null,null,{"v":24,"d":"24.00"},{"v":18,"d":"18.00"},{"v":12,"d":"12.00"}]
["Honor® Intrinsic™ brand Fungicide",59012350,"6 x 3 lb",{"$nulls":4},{"v":6,"d":"6.00"},null,null,{"v":12,"d":"12.00"},{"v":9,"d":"9.00"},{"v":6,"d":"6.00"}]
["Insignia® SC Intrinsic™ brand Fungicide",59014135,"2 x 2.5 gal",{"$nulls":4},{"v":21,"d":"21.00"},null,null,{"v":36.8,"d":"36.80"},{"v":28.9,"d":"28.90"},{"v":21,"d":"21.00"}]
["Insignia® SC Intrinsic™ brand Fungicide",59014134,"4 x 30.5 oz",{"$nulls":4},{"v":4,"d":"4.00"},null,null,{"v":7,"d":"7.00"},{"v":5.5,"d":"5.50"},{"v":4,"d":"4.00"}]
["Lexicon® Intrinsic™ Brand Fungicide",59027998,"4 x 21 oz",{"$nulls":4},{"v":4,"d":"4.00"},null,null,5.68,4.84,{"v":4,"d":"4.00"}]
["Maxtima® Fungicide",59018087,"4 x26 oz",null,{"v":12,"d":"12.00"},{"v":6,"d":"6.00"},{"v":4,"d":"4.00"},{"v":3,"d":"3.00"},null,null,{"v":12,"d":"12.00"},{"v":6,"d":"6.00"},{"v":3,"d":"3.00"}]
["Maxtima Fungicide",59018071,"2 x 2.5 gal",null,{"v":73.5,"d":"73.50"},{"v":36,"d":"36.00"},{"v":24.6,"d":"24.60"},{"v":18,"d":"18.00"},null,null,{"v":73.5,"d":"73.50"},{"v":36,"d":"36.00"},{"v":18,"d":"18.00"}]
["Navicon® Intrinsic™ brand Fungicide",59018094,"4 x 37 fl oz",{"$nulls":4},{"v":4,"d":"4.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"v":4,"d":"4.00"}]
["Navicon Intrinsic™ brand Fungicide",59018095,"2 x 2.5 gal",{"$nulls":4},{"v":17,"d":"17.00"},{"$nulls":3},{"v":21,"d":"21.00"},{"v":17,"d":"17.00"}]
["Pillar G Intrinsic™",59017959,"15 lbs",{"$nulls":7},0.11,0.11,0.11]
["Pillar G Intrinsic™",59012784,"30 lbs ",{"$nulls":7},0.22,0.22,0.22]
["Xzemplar™ Fungicide",59013833,"2 x 114 oz",{"$nulls":3},{"v":25,"d":"25.00"},{"v":20,"d":"20.00"},null,null,{"v":32.8,"d":"32.80"},24.95,{"v":20,"d":"20.00"}]
["Xzemplar™Fungicide",59014120,"4 x 11.4 oz",{"$nulls":3},{"v":5,"d":"5.00"},{"v":4,"d":"4.00"},null,null,{"v":6.6,"d":"6.60"},{"v":5,"d":"5.00"},{"v":4,"d":"4.00"}]
[]
[]
["Brand","Rate","Rate Level Above",null,43.5]
["Emerald",{"$f":"\"8.0\"&\" \"&F23","v":"8.0 oz"},"All",0.18,{"$f":"D23*$E$22","v":7.83},"oz"]
["Encartis","Select Rate"]
["Encartis","130.5 fl oz",5]
["Encartis","152.5 fl oz",6]
["Encartis","174.0 fl oz",7]
["Honor",{"$f":"\"48.0\"&\" \"&F28","v":"48.0 oz"},"All",1.1,{"$f":"D28*$E$22","v":47.85},"oz"]
["Insignia",{"$f":"30.5&\" \"&F29","v":"30.5 oz"},"All",0.7,{"$f":"D29*$E$22","v":30.45},"oz"]
["Lexicon",{"$f":"\"21.0\"&\" \"&F30","v":"21.0 oz"},"All",0.47,{"$f":"D30*$E$22","v":{"v":20.445,"d":"20.45"}},"oz"]
["Navicon",{"$f":"37.5&\" \"&F31","v":"37.5 oz"},"All",0.85,{"$f":"D31*$E$22","v":{"v":36.975,"d":"36.98"}},"oz"]
["Maxtima","Select Rate"]
["Maxtima",{"$f":"E33&\" \"&F33","v":"8.7 oz"},4,0.2,{"$f":"D33*$E$22","v":{"v":8.700000000000001,"d":"8.70"}},"oz"]
["Maxtima","17.4 oz",5,0.4,{"$f":"D34*$E$22","v":{"v":17.400000000000002,"d":"17.40"}},"oz"]
["Maxtima","26.1 oz",6,0.6,{"$f":"D35*$E$22","v":{"v":26.099999999999998,"d":"26.10"}},"oz"]
["Maxtima","34.8 oz",7,0.8,{"$f":"D36*$E$22","v":{"v":34.800000000000004,"d":"34.80"}},"oz"]
["Xzemplar ","Select Rate"]
["Xzemplar ",{"$f":"E38&\" \"&F38","v":"9.135 oz"},6,0.21,{"$f":"D38*$E$22","v":{"v":9.135,"d":"9.14"}},"oz"]
["Xzemplar ","11.31 oz",7,0.26,{"$f":"D39*$E$22","v":11.31},"oz"]

{"sheet":"Sheet1","index":7,"n_rows":19,"n_cols":16,"rows_kept":19,"hidden":true,"merged":[[11,10,11,12],[11,14,11,15],[12,10,13,10],[12,11,12,12],[12,14,13,14]]}
[]
[null,"Qualifying Fungicide EOP Purchase Level","October 1st - October 31st, 2021 Earned Rebate","November 1st - December 10th, 2021 Earned Incentive %","January 1 - September 30, 2021 Earned Incentive %",null,"Qualifying EOP Purchase Level (Excluding DYP Fungicides)","October 1st - December 4th, 2021 Earned Rebate","January 1 - September 30, 2022 Earned Incentive %",null,"Qualifying Fungicide EOP Purchase Level","October 1st - October 31st, 2021 Earned Rebate","November 1st - December 3rd, 2021 Earned Incentive %",null,"Qualifying EOP Purchase Level (Excluding DYP Fungicides)","October 1st - December 3rd, 2021 Earned Rebate"]
[null,"$5,000-$14,999",{"v":0.12,"d":"12%"},{"v":0.06,"d":"6%"},"-",null,"$2,000-$6,999",{"v":0.04,"d":"4%"},"-",null,"$5,000-$14,999",{"v":0.12,"d":"12%"},{"v":0.08,"d":"8%"},null,"$2,000-$6,999",{"v":0.04,"d":"4%"}]
[null,"$15,000-$24,999",{"v":0.16,"d":"16%"},{"v":0.08,"d":"8%"},"-",null,"$7,000-$14,999",{"v":0.06,"d":"6%"},"-",null,"$15,000-$24,999",{"v":0.16,"d":"16%"},{"v":0.1,"d":"10%"},null,"$7,000-$14,999",{"v":0.06,"d":"6%"}]
[null,"$25,000-$34,999",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.07,"d":"7%"},null,"$15,000+",{"v":0.1,"d":"10%"},"$25,000-$34,999 =  7%",null,"$25,000-$34,999",{"v":0.2,"d":"20%"},{"v":0.12,"d":"12%"},null,"$15,000+",{"v":0.1,"d":"10%"}]
[null,"$35,000+",{"v":0.24,"d":"24%"},{"v":0.12,"d":"12%"},{"v":0.1,"d":"10%"},{"$nulls":3},"$35,000+ = 10%",null,"$35,000+",{"v":0.24,"d":"24%"},{"v":0.14,"d":"14%"}]
[null,"$25,000-$34,999",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.07,"d":"7%"},null,"$15,000+",{"v":0.1,"d":"10%"},"$25,000-$34,999 =  7%"]
[]
[]
[]
[]
[{"$nulls":10},"Design Your Own Program (DYOP)",{"$nulls":3},"Across the Course Solutions (ACS)"]
[{"$nulls":10},"Qualifying Fungicide Purchase Level (DYOP)","Earned Incentive %",null,null,"Qualifying EOP Purchase Level (Excluding DYOP Fungicides)","Earned Incentive %"]
[{"$nulls":11},"Oct. 1-31, 2023","Nov. 1-Dec. 1, 2023",null,null,"Oct.1-Dec. 1, 2023"]
[{"$nulls":10},"$3,000-$7,999 (Par)",{"v":0.08,"d":"8%"},{"v":0.04,"d":"4%"},null,"$3,000-$7,999",{"v":0.04,"d":"4%"}]
[{"$nulls":10},"$8,000-$19,999 (Birdie)",{"v":0.14,"d":"14%"},{"v":0.07,"d":"7%"},null,"$8,000-$19,999",{"v":0.06,"d":"6%"}]
[{"$nulls":10},"$20,000-$29,999 (Eagle)","17% (+12% on ACS brands)","10% (+12% on ACS brands)",null,"$20,000+",{"v":0.12,"d":"12%"}]
[{"$nulls":10},"$30,000-$39,999 (Albatross)","20% (+12% on ACS brands)","12% (+12% on ACS brands)"]
[{"$nulls":10},"$40,000+ (Ace)","24% (+12% on ACS brands)","14% (+12% on ACS Brands)"]