{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Step 1 - Order Planner","Step 2 - OldManage Apps","Step 2 - Review Order","Range Reference","Article Reference","Sheet1"],"not_rendered":{"images":4,"macros":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Step 1 - Order Planner","index":0,"n_rows":61,"n_cols":12,"rows_kept":61,"merged":[[6,0,6,8],[7,0,7,8],[8,0,8,8],[15,0,15,8],[16,0,18,0],[16,1,18,2],[16,3,18,6],[16,7,18,8],[19,0,20,0],[19,1,20,2],[19,3,19,6],[19,7,19,8],[20,3,20,6],[20,7,20,8],[21,0,22,0],[21,1,22,2],[21,3,22,6],[21,7,22,8],[24,4,54,4],[24,7,55,8],[25,0,25,3],[25,5,25,6],[31,0,31,3],[31,5,31,6],[42,0,42,3],[42,5,42,6],[55,0,55,4],[55,9,55,11],[60,0,69,8]]}
{"$rows_empty":15}
["EOP Rebate Calculator"]
["Across-The-Lawn Rebate",{"$f":"'Range Reference'!G6","v":{"v":0,"d":"0%"}},null,"Across-The-Lawn Solutions Purchases",{"$nulls":3},{"$f":"G56","v":0}]
[]
[]
["Spend for Next ATL Level",{"$f":"HLOOKUP(H17,'Range Reference'!H2:H6,5,FALSE)","v":{"v":3000,"d":"$3,000.00"}}]
[]
["Next Level Rebate",{"$f":"IF(B17=0.12,\"Max Rebate Achieved\",VLOOKUP(B20,'Range Reference'!H3:I6,2,FALSE))","v":{"v":0.04,"d":"4%"}},null,"TOTAL EOP Rebate",{"$nulls":3},{"$f":"(H17*B17)","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($C27,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Alucion® 35 WG insecticide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"10 x 2.375 lbs"},59024020,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":2442.9,"d":"$2,442.90"}},null,0,{"$f":"F27*D27","v":0}]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":536.25,"d":"$536.25"}},null,0,{"$f":"F28*D28","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C28,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C28,#REF!,4,FALSE)*(F28+H28))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C28,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C28,#REF!,5,FALSE)*(F28+H28))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C28,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C28,#REF!,6,FALSE)*(F28+H28))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":294.19,"d":"$294.19"}},null,0,{"$f":"F29*D29","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C29,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C29,#REF!,4,FALSE)*(F29+H29))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C29,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C29,#REF!,5,FALSE)*(F29+H29))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C29,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C29,#REF!,6,FALSE)*(F29+H29))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":709.68,"d":"$709.68"}},null,0,{"$f":"F30*D30","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C30,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C30,#REF!,4,FALSE)*(F30+H30))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C30,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C30,#REF!,5,FALSE)*(F30+H30))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C30,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C30,#REF!,6,FALSE)*(F30+H30))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1266.4,"d":"$1,266.40"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C31,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C31,#REF!,4,FALSE)*(F31+H31))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C31,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C31,#REF!,5,FALSE)*(F31+H31))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C31,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C31,#REF!,6,FALSE)*(F31+H31))","v":{"$error":"#REF!"}}]
["Fungicides"]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":2169.16,"d":"$2,169.16"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C33,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C33,#REF!,4,FALSE)*(F33+H33))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C33,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C33,#REF!,5,FALSE)*(F33+H33))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C33,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C33,#REF!,6,FALSE)*(F33+H33))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59014135,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":7225.1,"d":"$7,225.10"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C34,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C34,#REF!,4,FALSE)*(F34+H34))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C34,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C34,#REF!,5,FALSE)*(F34+H34))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C34,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C34,#REF!,6,FALSE)*(F34+H34))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 122 oz"},59020732,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":9760,"d":"$9,760.00"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C35,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C35,#REF!,4,FALSE)*(F35+H35))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C35,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C35,#REF!,5,FALSE)*(F35+H35))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C35,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C35,#REF!,6,FALSE)*(F35+H35))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Orkestra® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 16 oz"},59014379,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":668.8,"d":"$668.80"}},null,0,{"$f":"F36*D36","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C36,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C36,#REF!,4,FALSE)*(F36+H36))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C36,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C36,#REF!,5,FALSE)*(F36+H36))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C36,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C36,#REF!,6,FALSE)*(F36+H36))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":443.36,"d":"$443.36"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C37,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C37,#REF!,4,FALSE)*(F37+H37))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C37,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C37,#REF!,5,FALSE)*(F37+H37))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C37,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C37,#REF!,6,FALSE)*(F37+H37))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":56.63,"d":"$56.63"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C38,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C38,#REF!,4,FALSE)*(F38+H38))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C38,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C38,#REF!,5,FALSE)*(F38+H38))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C38,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C38,#REF!,6,FALSE)*(F38+H38))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":105,"d":"$105.00"}},null,0,{"$f":"F39*D39","v":0}]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pillar® SC Intrinsic brand fungicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 43.5 oz"},59026395,{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":856.95,"d":"$856.95"}},null,0,0]
[{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":3451.92,"d":"$3,451.92"}},null,0,0]
[{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":808.04,"d":"$808.04"}},null,0,0]
["Herbicides"]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Basagran® herbicide"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 1 gal"},59011636,{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":125.58,"d":"$125.58"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C44,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C44,#REF!,4,FALSE)*(F44+H44))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C44,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C44,#REF!,5,FALSE)*(F44+H44))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C44,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C44,#REF!,6,FALSE)*(F44+H44))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":221.25,"d":"$221.25"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C45,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C45,#REF!,4,FALSE)*(F45+H45))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C45,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C45,#REF!,5,FALSE)*(F45+H45))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C45,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C45,#REF!,6,FALSE)*(F45+H45))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":514.44,"d":"$514.44"}},null,0,{"$f":"F46*D46","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Finale®  XL T&O herbicide "},{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59024131,{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":543.75,"d":"$543.75"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C47,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C47,#REF!,4,FALSE)*(F47+H47))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C47,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C47,#REF!,5,FALSE)*(F47+H47))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C47,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C47,#REF!,6,FALSE)*(F47+H47))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"FreeHand® 1.75G herbicide"},{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"1 x 50 lb"},59011296,{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":109.5,"d":"$109.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C48,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C48,#REF!,4,FALSE)*(F48+H48))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C48,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C48,#REF!,5,FALSE)*(F48+H48))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C48,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C48,#REF!,6,FALSE)*(F48+H48))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":48.5,"d":"$48.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C49,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C49,#REF!,4,FALSE)*(F49+H49))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C49,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C49,#REF!,5,FALSE)*(F49+H49))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C49,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C49,#REF!,6,FALSE)*(F49+H49))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":85.5,"d":"$85.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C50,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C50,#REF!,4,FALSE)*(F50+H50))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C50,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C50,#REF!,5,FALSE)*(F50+H50))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C50,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C50,#REF!,6,FALSE)*(F50+H50))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":281.25,"d":"$281.25"}},null,0,{"$f":"F51*D51","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($C51,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C51,#REF!,4,FALSE)*(F51+H51))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C51,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C51,#REF!,5,FALSE)*(F51+H51))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C51,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C51,#REF!,6,FALSE)*(F51+H51))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":983.1,"d":"$983.10"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C52,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C52,#REF!,4,FALSE)*(F52+H52))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C52,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C52,#REF!,5,FALSE)*(F52+H52))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C52,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C52,#REF!,6,FALSE)*(F52+H52))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1376,"d":"$1,376.00"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C53,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C53,#REF!,4,FALSE)*(F53+H53))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C53,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C53,#REF!,5,FALSE)*(F53+H53))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C53,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C53,#REF!,6,FALSE)*(F53+H53))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Segment® II herbicide"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59014427,{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1562.5,"d":"$1,562.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C54,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C54,#REF!,4,FALSE)*(F54+H54))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C54,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C54,#REF!,5,FALSE)*(F54+H54))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C54,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C54,#REF!,6,FALSE)*(F54+H54))","v":{"$error":"#REF!"}}]
[{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1972.5,"d":"$1,972.50"}},null,0,0,null,null,{"$f":"IF(ISNA(VLOOKUP($C55,#REF!,4,FALSE))=TRUE,0,VLOOKUP($C55,#REF!,4,FALSE)*(F55+H55))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C55,#REF!,5,FALSE))=TRUE,0,VLOOKUP($C55,#REF!,5,FALSE)*(F55+H55))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP($C55,#REF!,6,FALSE))=TRUE,0,VLOOKUP($C55,#REF!,6,FALSE)*(F55+H55))","v":{"$error":"#REF!"}}]
["QUALIFYING EOP PRODUCTS SUB-TOTAL",{"$nulls":5},{"$f":"SUM(G27:G55)","v":0},null,null,{"$f":"I56+G56","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":1,"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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K23)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K23)","v":{"$error":"#REF!"}},{"$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":{"$error":"#REF!"}},{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K23)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K23)","v":{"$error":"#REF!"}},{"$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":{"$error":"#REF!"}},{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K23)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K23)","v":{"$error":"#REF!"}},{"$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":{"$error":"#REF!"}},null,59021463]
[null,"50 x .49 lb.",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K24)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K24)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K24)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K24)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K24)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K24)","v":{"$error":"#REF!"}},0,null,59012825]
["Honor","1 x 36 lb",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K25)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K25)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K25)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K25)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K25)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K25)","v":{"$error":"#REF!"}},0,null,59012885]
[null,"6 x 3 lb",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K26)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K26)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K26)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K26)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K26)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K26)","v":{"$error":"#REF!"}},0,null,59012350]
["Insignia SC","2 x 2.5 gal",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K27)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K27)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K27)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K27)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K27)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K27)","v":{"$error":"#REF!"}},0,null,59014135]
[null,"4 x 30.5 oz",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K28)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K28)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K28)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K28)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K28)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K28)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K29)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K29)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K29)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K29)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K29)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K29)","v":{"$error":"#REF!"}},0,null,59013840]
["Maxtima","4 x26 oz",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K30)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K30)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K30)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K30)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K30)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K30)","v":{"$error":"#REF!"}},0,null,59018087]
[null,"2x 2.5 gal",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K31)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K31)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K31)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K31)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K31)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K31)","v":{"$error":"#REF!"}},0,null,59018071]
["Navicon","4x37 fl oz",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K32)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K32)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K32)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K32)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K32)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K32)","v":{"$error":"#REF!"}},0,null,59018094]
[null,"2x2.5 gal",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K33)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K33)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K33)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K33)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K33)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K33)","v":{"$error":"#REF!"}},0,null,59018095]
["Pillar G","15 lbs",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K34)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K34)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K34)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K34)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K34)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K34)","v":{"$error":"#REF!"}},0,null,59017959]
[null,"30 lbs ",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K35)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K35)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K35)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K35)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K35)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K35)","v":{"$error":"#REF!"}},0,null,59012784]
["Xzemplar","2 x 114 oz",null,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K36)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K36)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K36)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K36)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K36)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K36)","v":{"$error":"#REF!"}},{"$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 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K37)+SUMIFS('Step 1 - Order Planner'!J$28:J$55,'Step 1 - Order Planner'!$C$28:$C$55,$K37)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K37)+SUMIFS('Step 1 - Order Planner'!K$28:K$55,'Step 1 - Order Planner'!$C$28:$C$55,$K37)","v":{"$error":"#REF!"}},0,{"$f":"SUMIFS('Step 1 - Order Planner'!#REF!,'Step 1 - Order Planner'!#REF!,$K37)+SUMIFS('Step 1 - Order Planner'!L$28:L$55,'Step 1 - Order Planner'!$C$28:$C$55,$K37)","v":{"$error":"#REF!"}},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 2 - Review Order","index":2,"n_rows":58,"n_cols":6,"rows_kept":58,"merged":[[13,3,13,4],[14,3,16,4],[14,5,16,5],[17,3,19,4],[17,5,19,5],[21,2,22,3],[25,0,25,4],[31,0,31,4],[42,0,42,4],[55,0,55,4],[57,0,66,5]]}
{"$rows_empty":12}
[{"$f":"NOW()","v":"2023-08-08T16:58:31.710"},null,null,"Rebate Summary"]
["Order For","Order Prepared By",null,"Total Purchase",null,{"$f":"'Step 1 - Order Planner'!H17","v":0}]
["<Enter Customer Name>","<Enter Name>",null,"Across-The-Lawn-Solutions Rebate Earned",null,{"$f":"'Step 1 - Order Planner'!B17","v":{"v":0,"d":"0%"}}]
["<Enter Business Name>","<Enter Business Name>"]
["<City, ST Zip Code>","<City, ST Zip Code>"]
["<Phone>","<Phone>",null,"Total EOP Rebate",null,{"$f":"'Step 1 - Order Planner'!H22","v":0}]
["<email address>","<email address>"]
[]
[]
[]
["Your Order Detail"]
[]
["Product","Package","Article No.","Redemption Value","Quantity","Total"]
["Insecticide Subtotal",{"$nulls":4},{"$f":"SUM(F27:F31)","v":0}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Alucion® 35 WG insecticide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"10 x 2.375 lbs"},59024020,{"$f":"VLOOKUP($C27,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":2442.9,"d":"$2,442.90"}},{"$f":"VLOOKUP(C27,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C27,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E27*D27","v":0}]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"1 x 25lbs"},59021451,{"$f":"VLOOKUP($C28,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":536.25,"d":"$536.25"}},{"$f":"VLOOKUP(C28,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C28,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E28*D28","v":0}]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Siesta® Fire Ant Bait"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"15 lbs"},59011057,{"$f":"VLOOKUP($C29,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":294.19,"d":"$294.19"}},{"$f":"VLOOKUP(C29,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C29,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Sultan® miticide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 0.125 gal"},59023753,{"$f":"VLOOKUP($C30,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":709.68,"d":"$709.68"}},{"$f":"VLOOKUP(C30,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C30,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Ventigra® insecticide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 20 oz"},59014680,{"$f":"VLOOKUP($C31,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1266.4,"d":"$1,266.40"}},{"$f":"VLOOKUP(C31,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C31,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E31*D31","v":0}]
["Fungicide Subtotal",{"$nulls":4},{"$f":"SUM(F33:F42)","v":0}]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,{"$f":"VLOOKUP($C33,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":2169.16,"d":"$2,169.16"}},{"$f":"VLOOKUP(C33,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C33,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59014135,{"$f":"VLOOKUP($C34,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":7225.1,"d":"$7,225.10"}},{"$f":"VLOOKUP(C34,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C34,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Insignia® SC Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 122 oz"},59020732,{"$f":"VLOOKUP($C35,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":9760,"d":"$9,760.00"}},{"$f":"VLOOKUP(C35,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C35,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Orkestra® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 16 oz"},59014379,{"$f":"VLOOKUP($C36,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":668.8,"d":"$668.80"}},{"$f":"VLOOKUP(C36,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C36,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pageant® Intrinsic® brand Fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 1 lb"},59012349,{"$f":"VLOOKUP($C37,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":443.36,"d":"$443.36"}},{"$f":"VLOOKUP(C37,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C37,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E37*D37","v":0}]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"15 lbs bag"},59017959,{"$f":"VLOOKUP($C38,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":56.63,"d":"$56.63"}},{"$f":"VLOOKUP(C38,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C38,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pillar® G Intrinsic® brand fungicide"},{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"30 lbs bag"},59012784,{"$f":"VLOOKUP($C39,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":105,"d":"$105.00"}},{"$f":"VLOOKUP(C39,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C39,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pillar® SC Intrinsic brand fungicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 43.5 oz"},59026395,{"$f":"VLOOKUP($C40,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":856.95,"d":"$856.95"}},{"$f":"VLOOKUP(C40,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C40,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 114 oz"},59013833,{"$f":"VLOOKUP($C41,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":3451.92,"d":"$3,451.92"}},{"$f":"VLOOKUP(C41,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C41,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E41*D41","v":0}]
[{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Xzemplar® fungicide"},{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 11.4 oz"},59014120,{"$f":"VLOOKUP($C42,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":808.04,"d":"$808.04"}},{"$f":"VLOOKUP(C42,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C42,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
["Herbicide Subtotal",{"$nulls":4},{"$f":"SUM(F44:F55)","v":0}]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Basagran® herbicide"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 1 gal"},59011636,{"$f":"VLOOKUP($C44,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":125.58,"d":"$125.58"}},{"$f":"VLOOKUP(C44,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C44,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E44*D44","v":0}]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 0.5 gal"},59011404,{"$f":"VLOOKUP($C45,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":221.25,"d":"$221.25"}},{"$f":"VLOOKUP(C45,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C45,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Drive® XLR8 herbicide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59018043,{"$f":"VLOOKUP($C46,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":514.44,"d":"$514.44"}},{"$f":"VLOOKUP(C46,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C46,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E46*D46","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Finale®  XL T&O herbicide "},{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59024131,{"$f":"VLOOKUP($C47,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":543.75,"d":"$543.75"}},{"$f":"VLOOKUP(C47,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C47,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"FreeHand® 1.75G herbicide"},{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"1 x 50 lb"},59011296,{"$f":"VLOOKUP($C48,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":109.5,"d":"$109.50"}},{"$f":"VLOOKUP(C48,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C48,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E48*D48","v":0}]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"20 lbs bag"},59017972,{"$f":"VLOOKUP($C49,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":48.5,"d":"$48.50"}},{"$f":"VLOOKUP(C49,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C49,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E49*D49","v":0}]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® 2G herbicide"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"40 lbs bag"},59015072,{"$f":"VLOOKUP($C50,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":85.5,"d":"$85.50"}},{"$f":"VLOOKUP(C50,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C50,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59049276,{"$f":"VLOOKUP($C51,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":281.25,"d":"$281.25"}},{"$f":"VLOOKUP(C51,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C51,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pendulum® AquaCap herbicide"},{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"1 x 15 gal"},59011279,{"$f":"VLOOKUP($C52,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":983.1,"d":"$983.10"}},{"$f":"VLOOKUP(C52,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C52,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Pylex® herbicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"4 x 4 oz"},59018005,{"$f":"VLOOKUP($C53,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1376,"d":"$1,376.00"}},{"$f":"VLOOKUP(C53,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C53,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Segment® II herbicide"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59014427,{"$f":"VLOOKUP($C54,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1562.5,"d":"$1,562.50"}},{"$f":"VLOOKUP(C54,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C54,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},0]
[{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$49,2,FALSE)","v":"Tower® herbicide"},{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$49,3,FALSE)","v":"2 x 2.5 gal"},59014247,{"$f":"VLOOKUP($C55,'Article Reference'!$A$3:$D$49,4,FALSE)","v":{"v":1972.5,"d":"$1,972.50"}},{"$f":"VLOOKUP(C55,'Step 1 - Order Planner'!$C$25:$H$55,4,FALSE)+VLOOKUP(C55,'Step 1 - Order Planner'!$C$25:$H$55,6,FALSE)","v":0},{"$f":"E55*D55","v":0}]
["Total",{"$nulls":4},{"$f":"F14","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":3,"n_rows":6,"n_cols":9,"rows_kept":6,"hidden":true,"merged":[[5,2,5,3]]}
["Standard",null,"Oct","Nov-Dec"]
["Low","High","Discount","Discount","Oct Applied",null,"Rebate Applied",{"$f":"'Step 1 - Order Planner'!H17","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 1 - Order Planner'!$G$56)>=2000,'Step 1 - Order Planner'!$G$56>=$A3,'Step 1 - Order Planner'!$G$56<=$B3),C3)","v":false},null,{"$f":"SUM(E3:F3)","v":{"v":0,"d":"0%"}},{"$f":"A3-$H$2","v":{"v":3000,"d":"$3,000.00"}},{"v":0.04,"d":"4%"}]
[{"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 1 - Order Planner'!$G$56)>=2000,'Step 1 - Order Planner'!$G$56>=$A4,'Step 1 - Order Planner'!$G$56<=$B4),C4)","v":false},null,{"$f":"SUM(E4:F4)","v":{"v":0,"d":"0%"}},{"$f":"A4-$H$2","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 1 - Order Planner'!$G$56)>=2000,'Step 1 - Order Planner'!$G$56>=$A5,'Step 1 - Order Planner'!$G$56<=$B5),C5)","v":false},null,{"$f":"SUM(E5:F5)","v":{"v":0,"d":"0%"}},{"$f":"A5-$H$2","v":{"v":20000,"d":"$20,000.00"}},{"v":0.12,"d":"12%"}]
[null,null,"DISCOUNT",null,{"$f":"SUM(E3:E5)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(E6:F6)","v":{"v":0,"d":"0%"}},{"$f":"MIN(IF(H3:H5>0,H3:H5))","v":{"v":3000,"d":"$3,000.00"}}]

{"sheet":"Article Reference","index":4,"n_rows":52,"n_cols":11,"rows_kept":52,"hidden":true,"merged":[[0,0,0,3],[15,0,15,3]]}
["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"}},{"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"}]
["2022 Rest of Portfolio"]
["Article Number","Qaulifying Non-Agency Products","Package","Price"]
[59014151,"Admiral® lake colorant","4 x 1 gal",{"v":251.45,"d":"$251.45"},{"$f":"D18","v":{"v":251.45,"d":"$251.45"}},4,{"$f":"H18/F18","v":{"v":62.8625,"d":"$62.86"}},{"$f":"D18","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":"D20","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"}]
[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":"H25/F25","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"}]
[59013430,"Green Lawnger® colorant","2 x 2.5 gal",{"v":376.56,"d":"$376.56"},{"$f":"D27","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":"D30","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":"D33","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":"D37","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":"D39","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?"]
[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":"D42","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":"D45","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":9},{"$f":"SUM(D18:D49)","v":{"v":29930.800000000003,"d":"$29,930.80"}}]
[59013674,"FreeHand® 1.75G CA herbicide","1 x 50 lb"]

{"sheet":"Sheet1","index":5,"n_rows":26,"n_cols":16,"rows_kept":26,"hidden":true,"merged":[[12,10,13,10],[12,11,12,12],[12,14,13,14],[21,12,22,12],[21,14,22,14],[23,12,24,12],[25,12,26,12]]}
[]
[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%"}]
[]
[]
[]
[]
[]
[]
[{"$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, 2022","Nov. 1-Dec. 2, 2022",null,null,"Oct.1-Dec. 2, 2022"]
[{"$nulls":10},"$5,000-$14,999",{"v":0.12,"d":"12%"},{"v":0.08,"d":"8%"},null,"$2,000-$6,999",{"v":0.04,"d":"4%"}]
[{"$nulls":10},"$15,000-$24,999",{"v":0.16,"d":"16%"},{"v":0.1,"d":"10%"},null,"$7,000-$14,999",{"v":0.06,"d":"6%"}]
[{"$nulls":10},"$25,000-$34,999",{"v":0.2,"d":"20%"},{"v":0.12,"d":"12%"},null,"$15,000+",{"v":0.1,"d":"10%"}]
[{"$nulls":10},"$35,000+",{"v":0.24,"d":"24%"},{"v":0.14,"d":"14%"}]
[]
[]
[]
[{"$nulls":12},"Start earning rebates at only $3,000",null,"Qualifying Purchase Levels","Earned Incentive %"]
[{"$nulls":15},"Oct.1-Dec. 1, 2023"]
[{"$nulls":12},"Earn 12% rebate by reaching only $20,000 in total purchases.",null,"$3,000-$7,999",{"v":0.04,"d":"4%"}]
[{"$nulls":14},"$8,000-$19,999",{"v":0.06,"d":"6%"}]
[{"$nulls":12},"Count your savings and win with EOP.",null,"$20,000+",{"v":0.12,"d":"12%"}]