{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Step 1 - Make Selections","Step 2 - Manage Applications","Step 3 - Review Order","Range Reference","Article Reference","Coverage Reference"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Step 1 - Make Selections","index":0,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[82,0,91,7],[77,8,77,10],[47,0,47,4],[77,0,77,4],[20,6,20,7],[20,3,20,5],[22,1,22,2],[22,3,22,5],[22,6,22,7],[21,3,21,5],[19,0,20,0],[19,1,20,2],[19,6,19,7],[15,0,15,2],[21,1,21,2],[16,1,16,2],[47,8,47,10],[17,6,17,7],[16,6,16,7],[15,6,15,7],[18,3,18,5],[17,3,17,5],[16,3,16,5],[15,3,15,5],[18,6,18,7],[21,6,21,7],[19,3,19,5],[18,1,18,2],[17,1,17,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EOP Rebate Calculator",null,null,"TOTAL EOP PURCHASE",null,null,{"$f":"I48+I78","v":0}]
["Rebate Program Locked",{"$f":"IF((F78+F48)>=2000,\"October Rebate Locked\",IF((I48+I78)>=2000,\"Nov-Dec Rebate Locked\",\"Rebate Level Not Achieved\"))","v":"Rebate Level Not Achieved"},null,"$ To Reach Rebate Level 1",null,null,{"$f":"IF(2000-$G$16<=0,\"Reached\",3000-$G$16)","v":3000}]
["Rebate Level",{"$f":"IF('Range Reference'!G7=0,0,'Range Reference'!G7)","v":0},null,"$ To Reach Rebate Level 2",null,null,{"$f":"IF(10000-$G$16<=0,\"Reached\",10000-$G$16)","v":10000}]
["EOP Cube Kicker",{"$f":"IF((E26+G26+G30+E30)>=1,0.02,0)","v":0},null,"$ To Reach Rebate Level 3",null,null,{"$f":"IF(18000-$G$16<=0,\"Reached\",18000-$G$16)","v":18000}]
["TOTAL REBATE",{"$f":"B18+B19","v":0},null,"$ To Reach Rebate Level 4",null,null,{"$f":"IF(35000-$G$16<=0,\"Reached\",35000-$G$16)","v":35000}]
[null,null,null,"Rebate $ on Total Purchases",null,null,{"$f":"IF(B18=0,\"Not Achieved\",B20*G16)","v":"Not Achieved"}]
["Insignia Intrnsic Rebate",{"$f":"IF('Range Reference'!R2+'Range Reference'!R4=0,\"Not Achieved\",'Range Reference'!R2+'Range Reference'!R4)","v":"Not Achieved"},null,"Additional Insignia Intrinsic Rebate",null,null,{"$f":"IF('Range Reference'!R7=0,\"Not Achieved\",'Range Reference'!R7)","v":"Not Achieved"}]
["Season Year Rebate Lock",{"$f":"IF(G20=\"Reached\",\"10% Full Year Rebate Locked\",\"Not Achieved\")","v":"Not Achieved"},null,"TOTAL EOP Rebate",null,null,{"$f":"IF(G22=\"Not Achieved\",G16*B20,(G16*B20)+G22)","v":0}]
[]
["Qualifying Agency Products","Package","Article No.","Agency Price","Oct Order (Cases)","Oct Sales","Nov-Dec Order (Cases)","Nov-Dec Sales","Acres Low","Acres Mid","Acres High"]
["Warm Season Zone Herbicide Cube","Cube",59017962,3610,0,{"$f":"D26*E26","v":0},0,{"$f":"G26*D26","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E26+G26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E26+G26))","v":0},{"$f":"IF(ISNA(VLOOKUP($C26,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C26,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E26+G26))","v":0}]
[{"$f":"VLOOKUP($C27,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Tower® Herbicide"},{"$f":"VLOOKUP($C27,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"2 x 2.5 gal"},59014247,null,{"$f":"2*E26","v":0},null,{"$f":"2*G26","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E27+G27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E27+G27))","v":0},{"$f":"IF(ISNA(VLOOKUP($C27,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C27,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E27+G27))","v":0}]
[{"$f":"VLOOKUP($C28,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pylex Herbicide "},{"$f":"VLOOKUP($C28,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4x 8 fl oz"},59013624,null,{"$f":"1*E26","v":0},null,{"$f":"1*G26","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E28+G28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E28+G28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E28+G28))","v":0}]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Drive XLR8 Herbicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4x .5 gal"},59011404,null,{"$f":"1*E26","v":0},null,{"$f":"1*G26","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E29+G29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E29+G29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E29+G29))","v":0}]
["Cool Season Zone Herbicide Cube","Cube",59017954,2461,0,{"$f":"D30*E30","v":0},0,{"$f":"G30*D30","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E30+G30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E30+G30))","v":0},{"$f":"IF(ISNA(VLOOKUP($C30,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C30,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E30+G30))","v":0}]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pendulum® AquaCap™ Herbicide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"1 x 15 gal"},59011279,null,{"$f":"E30*1","v":0},null,{"$f":"G30*1","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E31+G31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E31+G31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E31+G31))","v":0}]
[{"$f":"VLOOKUP($C32,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pylex Herbicide "},{"$f":"VLOOKUP($C32,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4x 8 fl oz"},59013624,null,{"$f":"E31*1","v":0},null,{"$f":"G31*1","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E32+G32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E32+G32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E32+G32))","v":0}]
[{"$f":"VLOOKUP($C33,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Drive XLR8 Herbicide"},{"$f":"VLOOKUP($C33,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4x .5 gal"},59011404,null,{"$f":"E32*1","v":0},null,{"$f":"G32*1","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E33+G33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E33+G33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E33+G33))","v":0}]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Segment II Herbicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"2x 2.5 gal"},59014427,null,{"$f":"E33*1","v":0},null,{"$f":"G33*1","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E34+G34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E34+G34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E34+G34))","v":0}]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Insignia® SC Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"2x 2.5 gal"},59014135,5997.8499999999995,0,{"$f":"D35*E35","v":0},0,{"$f":"G35*D35","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E35+G35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E35+G35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E35+G35))","v":0}]
[{"$f":"VLOOKUP($C36,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Insignia® SC Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C36,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4 x 122 fl oz"},59012450,6592.88,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E36+G36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E36+G36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E36+G36))","v":0}]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Insignia® SC Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,1760.46,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E37+G37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E37+G37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E37+G37))","v":0}]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Orkestra™ Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4x 16 oz"},59014379,563.20000000000005,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E38+G38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E38+G38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E38+G38))","v":0}]
[{"$f":"VLOOKUP($C39,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pageant® Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C39,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4 x 1 lb"},59012349,373.56,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E39+G39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E39+G39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E39+G39))","v":0}]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pageant® Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4 x 12 lb"},59012429,4150.08,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E40+G40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E40+G40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E40+G40))","v":0}]
[{"$f":"VLOOKUP($C41,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pendulum® AquaCap™ Bulk Herbicide"},{"$f":"VLOOKUP($C41,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"110 gal"},59049202,5500,0,{"$f":"D41*E41","v":0},0,{"$f":"G41*D41","v":0},{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E41+G41))","v":0},{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E41+G41))","v":0},{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E41+G41))","v":0}]
[{"$f":"VLOOKUP($C42,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pendulum® AquaCap™ Bulk Herbicide"},"220 gal",59049202,11000,0,{"$f":"D42*E42","v":0},0,{"$f":"G42*D42","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E42+G42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E42+G42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E42+G42))","v":0}]
[{"$f":"VLOOKUP($C43,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Pendulum® AquaCap™ Herbicide"},{"$f":"VLOOKUP($C43,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"1 x 15 gal"},59011279,750,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E43+G43))","v":0},{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E43+G43))","v":0},{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E43+G43))","v":0}]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Sultan™ Miticide"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4x 0.125 gal"},59014112,629.02499999999998,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E44+G44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E44+G44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E44+G44))","v":0}]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Tower® Herbicide"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"2 x 2.5 gal"},59014247,1527,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E45+G45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E45+G45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E45+G45))","v":0}]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Xzemplar™ Fungicide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"2x 114 oz"},59013833,3691.32,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E46+G46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E46+G46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E46+G46))","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$2:$C$46,2,FALSE)","v":"Xzemplar™Fungicide"},{"$f":"VLOOKUP($C47,'Article Reference'!$A$2:$C$46,3,FALSE)","v":"4 x 11.4 oz"},59014120,849.52800000000002,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E47+G47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E47+G47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E47+G47))","v":0}]
["AGENCY SUB-TOTAL",null,null,null,null,{"$f":"SUM(F26:F47)","v":0},null,{"$f":"SUM(H26:H47)","v":0},{"$f":"H48+F48","v":0}]
["Qualifying Non-Agency Products","Package","Article Number","Redemption Value","Oct Order (Cases)","Oct Sales","Nov-Dec Order (Cases)","Nov-Dec Sales","Acres Low","Acres Mid","Acres High"]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"All Weather Foam Concentrate"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4x1 gal"},59013451,195,0,{"$f":"E50*D50","v":0},0,{"$f":"G50*D50","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E50+G50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E50+G50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E50+G50))","v":0}]
[{"$f":"VLOOKUP($C51,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Amdro Pro Fire Ant Bait"},{"$f":"VLOOKUP($C51,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"1 x 25lbs"},59021451,391.875,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E51+G51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E51+G51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E51+G51))","v":0}]
[{"$f":"VLOOKUP($C52,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Basagran Herbicide"},{"$f":"VLOOKUP($C52,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x 1 gal"},59011636,221.85,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E52+G52))","v":0},{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E52+G52))","v":0},{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E52+G52))","v":0}]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Drive XLR8 Herbicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4x .5 gal"},59011404,299.89999999999998,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E53+G53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E53+G53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E53+G53))","v":0}]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Green Lawnger"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4x1 gal"},59013434,233.35000000000002,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E54+G54))","v":0},{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E54+G54))","v":0},{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E54+G54))","v":0}]
[{"$f":"VLOOKUP($C55,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Green Lawnger"},{"$f":"VLOOKUP($C55,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x2.5 gal"},59013430,291.3125,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E55+G55))","v":0},{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E55+G55))","v":0},{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E55+G55))","v":0}]
[{"$f":"VLOOKUP($C56,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Green Lawnger Transition HC Colorant"},{"$f":"VLOOKUP($C56,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4x 1 gal"},59013410,618.5,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E56+G56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E56+G56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E56+G56))","v":0}]
[{"$f":"VLOOKUP($C57,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Green Lawnger Turf Colorant"},{"$f":"VLOOKUP($C57,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"1x 30 gal"},59013284,1606.5,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E57+G57))","v":0},{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E57+G57))","v":0},{"$f":"IF(ISNA(VLOOKUP($C57,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C57,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E57+G57))","v":0}]
[{"$f":"VLOOKUP($C58,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Green Lawnger Vision Pro"},{"$f":"VLOOKUP($C58,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4x1 gal"},59013342,551,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E58+G58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E58+G58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E58+G58))","v":0}]
[{"$f":"VLOOKUP($C59,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Neutralize Dry"},{"$f":"VLOOKUP($C59,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"12 x 2 lbs"},59013346,147.30000000000001,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E59+G59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E59+G59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E59+G59))","v":0}]
[{"$f":"VLOOKUP($C60,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Neutralize Liquid"},{"$f":"VLOOKUP($C60,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4 x 1 gal"},59014385,119.05,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E60+G60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E60+G60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E60+G60))","v":0}]
[{"$f":"VLOOKUP($C61,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"NutroSol Tank Cleaner"},{"$f":"VLOOKUP($C61,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"12x2 lbs"},59013352,111.89999999999999,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E61+G61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E61+G61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E61+G61))","v":0}]
[{"$f":"VLOOKUP($C62,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Pendulum 2G"},{"$f":"VLOOKUP($C62,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"40 lbs bag"},59015072,70,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E62+G62))","v":0},{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E62+G62))","v":0},{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E62+G62))","v":0}]
[{"$f":"VLOOKUP($C63,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Pendulum 3.3EC"},{"$f":"VLOOKUP($C63,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x2.5 gal"},59015228,203.25000000000003,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E63+G63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E63+G63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E63+G63))","v":0}]
[{"$f":"VLOOKUP($C64,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Pendulum Aquacap"},{"$f":"VLOOKUP($C64,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x2.5 gal"},59049276,344.625,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E64+G64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E64+G64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E64+G64))","v":0}]
[{"$f":"VLOOKUP($C65,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Pillar G"},{"$f":"VLOOKUP($C65,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"30 lbs bag"},59012784,76.874999999999986,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E65+G65))","v":0},{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E65+G65))","v":0},{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E65+G65))","v":0}]
[{"$f":"VLOOKUP($C66,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Pillar G (New)"},{"$f":"VLOOKUP($C66,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"15 lbs bag"},59017959,42.9375,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E66+G66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E66+G66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E66+G66))","v":0}]
[{"$f":"VLOOKUP($C67,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Pylex Herbicide "},{"$f":"VLOOKUP($C67,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4x 8 fl oz"},59013624,2224.7999999999997,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E67+G67))","v":0},{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E67+G67))","v":0},{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E67+G67))","v":0}]
[{"$f":"VLOOKUP($C68,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Segment II Herbicide"},{"$f":"VLOOKUP($C68,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x 2.5 gal"},59014427,1175.625,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E68+G68))","v":0},{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E68+G68))","v":0},{"$f":"IF(ISNA(VLOOKUP($C68,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C68,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E68+G68))","v":0}]
[{"$f":"VLOOKUP($C69,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Shakedown Anti Foam"},{"$f":"VLOOKUP($C69,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"12x 1 qt"},59013697,179.0625,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E69+G69))","v":0},{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E69+G69))","v":0},{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E69+G69))","v":0}]
[{"$f":"VLOOKUP($C70,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Siesta Fire Ant Bait"},{"$f":"VLOOKUP($C70,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"15 lbs"},59011057,214.125,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E70+G70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E70+G70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E70+G70))","v":0}]
[{"$f":"VLOOKUP($C71,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Sprint 330 Iron Chelate "},{"$f":"VLOOKUP($C71,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"6x5 lbs"},59014404,330,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E71+G71))","v":0},{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E71+G71))","v":0},{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E71+G71))","v":0}]
[{"$f":"VLOOKUP($C72,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Sprint 330 Iron Chelate "},{"$f":"VLOOKUP($C72,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"1x50 lbs"},59014406,485,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E72+G72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E72+G72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E72+G72))","v":0}]
[{"$f":"VLOOKUP($C73,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Trinity Fungicide"},{"$f":"VLOOKUP($C73,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x2.5gal"},59011038,1155.0625,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E73+G73))","v":0},{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E73+G73))","v":0},{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E73+G73))","v":0}]
[{"$f":"VLOOKUP($C74,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Turf Mark"},{"$f":"VLOOKUP($C74,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"12 x .25 gal"},59013723,195.45,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E74+G74))","v":0},{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E74+G74))","v":0},{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E74+G74))","v":0}]
[{"$f":"VLOOKUP($C75,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Turf Mark"},{"$f":"VLOOKUP($C75,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"1 x 30 gal"},59013314,1231.5,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C75,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C75,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E75+G75))","v":0},{"$f":"IF(ISNA(VLOOKUP($C75,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C75,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E75+G75))","v":0},{"$f":"IF(ISNA(VLOOKUP($C75,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C75,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E75+G75))","v":0}]
[{"$f":"VLOOKUP($C76,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Turf Mark Blue"},{"$f":"VLOOKUP($C76,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x 2.5 gal"},59013417,217.1875,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C76,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C76,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E76+G76))","v":0},{"$f":"IF(ISNA(VLOOKUP($C76,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C76,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E76+G76))","v":0},{"$f":"IF(ISNA(VLOOKUP($C76,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C76,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E76+G76))","v":0}]
[{"$f":"VLOOKUP($C77,'Article Reference'!$A$2:$C$54,2,FALSE)","v":"Turf Mark Green"},{"$f":"VLOOKUP($C77,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x 2.5 gal"},59013486,264.0625,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C77,'Coverage Reference'!$B$4:$G$17,4,FALSE))=TRUE,0,VLOOKUP($C77,'Coverage Reference'!$B$4:$G$17,4,FALSE)*(E77+G77))","v":0},{"$f":"IF(ISNA(VLOOKUP($C77,'Coverage Reference'!$B$4:$G$17,5,FALSE))=TRUE,0,VLOOKUP($C77,'Coverage Reference'!$B$4:$G$17,5,FALSE)*(E77+G77))","v":0},{"$f":"IF(ISNA(VLOOKUP($C77,'Coverage Reference'!$B$4:$G$17,6,FALSE))=TRUE,0,VLOOKUP($C77,'Coverage Reference'!$B$4:$G$17,6,FALSE)*(E77+G77))","v":0}]
["NON-AGENCY SUB-TOTAL",null,null,null,null,{"$f":"SUM(F50:F77)","v":0},null,{"$f":"SUM(H50:H77)","v":0},{"$f":"H78+F78","v":0}]
[]
[]
[]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2019 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 - Manage Applications","index":1,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,0,16,1],[20,7,20,8],[20,5,20,6],[20,3,20,4],[19,0,19,8],[32,0,39,8],[22,0,23,0],[20,2,21,2],[24,0,26,0],[20,0,21,0],[20,1,21,1],[28,0,29,0]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Enter Acres for your Application (Required)"]
["Acres",null,0]
[]
[]
["Fungicide Planner",null,null,null,null,null,null,null,null,null,null,null,"Lawn"]
["Product Name","Case Size","Use Area","Low Rate",null,"Mid Rate",null,"High Rate"]
[null,null,null,"Total Acres","Applications","Total Acres","Applications","Total Acres","Applications"]
["Xzemplar",{"$f":"VLOOKUP(K23,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x 114 oz"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K23)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K23)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C23=\"Lawn\",D23/$C$17,0))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K23)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K23)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C23=\"Lawn\",F23/$C$17,0))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K23)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K23)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C23=\"Lawn\",H23/$C$17,0))","v":"Please Enter Acreage"},null,59013833]
[null,{"$f":"VLOOKUP(K24,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4 x 11.4 oz"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K24)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K24)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C24=\"Lawn\",D24/$C$17,0))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K24)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K24)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K24)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K24)","v":0},"Please Enter Acreage",null,59014120]
["Insignia SC",{"$f":"VLOOKUP(K25,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4 x 30.5 fl oz"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K25)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K25)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K25)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K25)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K25)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K25)","v":0},"Please Enter Acreage",null,59014134]
[null,{"$f":"VLOOKUP(K26,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"4 x 122 fl oz"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K26)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K26)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K26)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K26)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K26)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K26)","v":0},"Please Enter Acreage",null,59012450]
[null,{"$f":"VLOOKUP(K27,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x 2.5 gal"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K27)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K27)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K27)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K27)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K27)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K27)","v":0},"Please Enter Acreage",null,59014135]
["Trinity",{"$f":"VLOOKUP(K28,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"2x2.5gal"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K28)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K28)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K28)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K28)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K28)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K28)","v":0},"Please Enter Acreage",null,59011038]
["Pillar G Intrinsic",{"$f":"VLOOKUP(K29,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"15 lbs bag"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K29)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K29)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C29=\"Lawn\",D29/$C$17,0))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K29)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K29)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C29=\"Lawn\",F29/$C$17,0))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K29)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K29)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C29=\"Lawn\",H29/$C$17,0))","v":"Please Enter Acreage"},null,59017959]
[null,{"$f":"VLOOKUP(K30,'Article Reference'!$A$2:$C$54,3,FALSE)","v":"30 lbs bag"},"Lawn",{"$f":"SUMIFS('Step 1 - Make Selections'!I$26:I$85,'Step 1 - Make Selections'!$C$26:$C$85,$K30)+SUMIFS('Step 1 - Make Selections'!I$88:I$117,'Step 1 - Make Selections'!$C$88:$C$117,$K30)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$26:J$85,'Step 1 - Make Selections'!$C$26:$C$85,$K30)+SUMIFS('Step 1 - Make Selections'!J$88:J$117,'Step 1 - Make Selections'!$C$88:$C$117,$K30)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C30=\"Lawn\",F30/$C$17,0))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$26:K$85,'Step 1 - Make Selections'!$C$26:$C$85,$K30)+SUMIFS('Step 1 - Make Selections'!K$88:K$117,'Step 1 - Make Selections'!$C$88:$C$117,$K30)","v":0},{"$f":"IF($C$17=0,\"Please Enter Acreage\",IF(C30=\"Lawn\",H30/$C$17,0))","v":"Please Enter Acreage"},null,59012784]

{"sheet":"Step 3 - Review Order","index":2,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[23,2,24,3],[71,0,80,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"NOW()","v":"2018-09-12T15:00:56.890"}]
["Order For","Order Prepared By",null,"Rebate Summary"]
["<Enter Customer Name>","<Enter Name>",null,"Total Purchase",null,{"$f":"'Step 1 - Make Selections'!G16","v":0}]
["<Enter Business Name>","<Enter Business Name>",null,"Rebate Level Attained",null,{"$f":"'Step 1 - Make Selections'!B20","v":0}]
["<City, ST Zip Code>","<City, ST Zip Code>",null,"Total Spend Rebate",null,{"$f":"'Step 1 - Make Selections'!G21","v":"Not Achieved"}]
["<Phone>","<Phone>",null,"Intrinsic Rebate",null,{"$f":"'Step 1 - Make Selections'!G22","v":"Not Achieved"}]
["<email address>","<email address>",null,"Total EOP Rebate",null,{"$f":"'Step 1 - Make Selections'!G23","v":0}]
[]
[]
[]
["Your Order Detail"]
[]
["Product / Cubes","Package","Article No.","Price","Quantity","Total"]
["Warm Season Zone Herbicide Cube","Cube",59017962,3610,{"$f":"VLOOKUP(C28,'Step 1 - Make Selections'!$C$26:$G$77,3,FALSE)+VLOOKUP(C28,'Step 1 - Make Selections'!$C$26:$G$77,5,FALSE)","v":0},{"$f":"E28*D28","v":0}]
["Cool Season Zone Herbicide Cube","Cube",59017954,2461,{"$f":"VLOOKUP(C29,'Step 1 - Make Selections'!$C$26:$G$77,3,FALSE)+VLOOKUP(C29,'Step 1 - Make Selections'!$C$26:$G$77,5,FALSE)","v":0},0]
["Insignia® SC Intrinsic™ Brand Fungicide","2x 2.5 gal",59014135,5997.8499999999995,{"$f":"VLOOKUP(C30,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C30,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},{"$f":"E30*D30","v":0}]
["Insignia® SC Intrinsic™ Brand Fungicide","4 x 122 fl oz",59012450,6592.88,{"$f":"VLOOKUP(C31,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C31,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Insignia® SC Intrinsic™ Brand Fungicide","4 x 30.5 fl oz",59014134,1760.46,{"$f":"VLOOKUP(C32,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C32,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Orkestra™ Intrinsic™ Brand Fungicide","4x 16 oz",59014379,563.20000000000005,{"$f":"VLOOKUP(C33,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C33,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pageant® Intrinsic™ Brand Fungicide","4 x 1 lb",59012349,373.56,{"$f":"VLOOKUP(C34,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C34,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pageant® Intrinsic™ Brand Fungicide","4 x 12 lb",59012429,4150.08,{"$f":"VLOOKUP(C35,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C35,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pendulum® AquaCap™ Bulk Herbicide","110 gal",59049202,5500,{"$f":"VLOOKUP(C36,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C36,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pendulum® AquaCap™ Bulk Herbicide",220,59049202,11000,{"$f":"VLOOKUP(C37,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C37,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pendulum® AquaCap™ Herbicide","1 x 15 gal",59011279,750,{"$f":"VLOOKUP(C38,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C38,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Sultan™ Miticide","4x 0.125 gal",59014112,629.02499999999998,{"$f":"VLOOKUP(C39,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C39,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Tower® Herbicide","2 x 2.5 gal",59014247,1527,{"$f":"VLOOKUP(C40,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C40,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Xzemplar™ Fungicide","2x 114 oz",59013833,3691.32,{"$f":"VLOOKUP(C41,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C41,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Xzemplar™Fungicide","4 x 11.4 oz",59014120,849.52800000000002,{"$f":"VLOOKUP(C42,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C42,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["All Weather Foam Concentrate","4x1 gal",59013451,"See Agent for Price",{"$f":"VLOOKUP(C43,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C43,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Amdro Pro Fire Ant Bait","1 x 25lbs",59021451,"See Agent for Price",{"$f":"VLOOKUP(C44,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C44,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Basagran Herbicide","2x 1 gal",59011636,"See Agent for Price",{"$f":"VLOOKUP(C45,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C45,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Drive XLR8 Herbicide","4x .5 gal",59011404,"See Agent for Price",{"$f":"VLOOKUP(C46,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C46,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Green Lawnger","4x1 gal",59013434,"See Agent for Price",{"$f":"VLOOKUP(C47,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C47,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Green Lawnger","2x2.5 gal",59013430,"See Agent for Price",{"$f":"VLOOKUP(C48,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C48,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Green Lawnger Transition HC Colorant","4x 1 gal",59013410,"See Agent for Price",{"$f":"VLOOKUP(C49,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C49,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Green Lawnger Turf Colorant","1x 30 gal",59013284,"See Agent for Price",{"$f":"VLOOKUP(C50,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C50,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Green Lawnger Vision Pro","4x1 gal",59013342,"See Agent for Price",{"$f":"VLOOKUP(C51,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C51,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Neutralize Dry","12 x 2 lbs",59013346,"See Agent for Price",{"$f":"VLOOKUP(C52,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C52,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Neutralize Liquid","4 x 1 gal",59014385,"See Agent for Price",{"$f":"VLOOKUP(C53,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C53,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["NutroSol Tank Cleaner","12x2 lbs",59013352,"See Agent for Price",{"$f":"VLOOKUP(C54,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C54,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pendulum 2G","40 lbs bag",59015072,"See Agent for Price",{"$f":"VLOOKUP(C55,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C55,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pendulum 3.3EC","2x2.5 gal",59015228,"See Agent for Price",{"$f":"VLOOKUP(C56,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C56,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pendulum Aquacap","2x2.5 gal",59049276,"See Agent for Price",{"$f":"VLOOKUP(C57,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C57,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pillar G","30 lbs bag",59012784,"See Agent for Price",{"$f":"VLOOKUP(C58,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C58,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pillar G (New)","15 lbs bag",59017959,"See Agent for Price",{"$f":"VLOOKUP(C59,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C59,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Pylex Herbicide ","4x 8 fl oz",59013624,"See Agent for Price",{"$f":"VLOOKUP(C60,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C60,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Segment II Herbicide","2x 2.5 gal",59014427,"See Agent for Price",{"$f":"VLOOKUP(C61,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C61,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Shakedown Anti Foam","12x 1 qt",59013697,"See Agent for Price",{"$f":"VLOOKUP(C62,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C62,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Siesta Fire Ant Bait","15 lbs",59011057,"See Agent for Price",{"$f":"VLOOKUP(C63,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C63,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Sprint 330 Iron Chelate ","6x5 lbs",59014404,"See Agent for Price",{"$f":"VLOOKUP(C64,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C64,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Sprint 330 Iron Chelate ","1x50 lbs",59014406,"See Agent for Price",{"$f":"VLOOKUP(C65,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C65,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Trinity Fungicide","2x2.5gal",59011038,"See Agent for Price",{"$f":"VLOOKUP(C66,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C66,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Turf Mark","12 x .25 gal",59013723,"See Agent for Price",{"$f":"VLOOKUP(C67,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C67,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Turf Mark","1 x 30 gal",59013314,"See Agent for Price",{"$f":"VLOOKUP(C68,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C68,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Turf Mark Blue","2x 2.5 gal",59013417,"See Agent for Price",{"$f":"VLOOKUP(C69,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C69,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
["Turf Mark Green","2x 2.5 gal",59013486,"See Agent for Price",{"$f":"VLOOKUP(C70,'Step 1 - Make Selections'!$C$35:$G$77,3,FALSE)+VLOOKUP(C70,'Step 1 - Make Selections'!$C$35:$G$77,5,FALSE)","v":0},0]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2019 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":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":true,"merged":[[6,2,6,3],[6,9,6,16]]}
[null,null,"Oct","Nov-Dec",null,null,null,null,null,"Article Description","Pkg Size","Art #","Cases","Cov Vol","Rebate","Sales","Rebate $","Rebate Combined $"]
["Low","High","Discount","Discount","Oct Applied","Nov-Dec Applied","Rebate Applied",null,null,"Honor® Intrinsic™ brand Fungicide","6 x 3 lb",59012350,{"$f":"'Step 1 - Make Selections'!#REF!+'Step 1 - Make Selections'!#REF!","v":{"$error":"#REF!"}},{"$f":"M2*18","v":{"$error":"#REF!"}},{"$f":"IF((N2+N3)>=72,0.12,0)","v":{"$error":"#REF!"}},{"$f":"'Step 1 - Make Selections'!#REF!+'Step 1 - Make Selections'!#REF!","v":{"$error":"#REF!"}},{"$f":"(P2+P3)*O2","v":{"$error":"#REF!"}}]
[3000,9999,0.04,0.03,{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)>=2000,'Step 1 - Make Selections'!$G$16>=$A3,'Step 1 - Make Selections'!$G$16<=$B3),C3)","v":false},{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)<2000,'Step 1 - Make Selections'!$G$16>=$A3,'Step 1 - Make Selections'!$G$16<=$B3),D3)","v":false},{"$f":"SUM(E3:F3)","v":0},null,null,"Honor® Intrinsic™ brand Fungicide","1 x 36 lb",59012885,{"$f":"'Step 1 - Make Selections'!#REF!+'Step 1 - Make Selections'!#REF!","v":{"$error":"#REF!"}},{"$f":"36*M3","v":{"$error":"#REF!"}},null,{"$f":"'Step 1 - Make Selections'!#REF!+'Step 1 - Make Selections'!#REF!","v":{"$error":"#REF!"}}]
[10000,17999,7.0000000000000007E-2,0.05,{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)>=2000,'Step 1 - Make Selections'!$G$16>=$A4,'Step 1 - Make Selections'!$G$16<=$B4),C4)","v":false},{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)<2000,'Step 1 - Make Selections'!$G$16>=$A4,'Step 1 - Make Selections'!$G$16<=$B4),D4)","v":false},{"$f":"SUM(E4:F4)","v":0},null,null,"Insignia® SC Intrinsic™ brand Fungicide","4 x 30.5 fl oz",59014134,{"$f":"'Step 1 - Make Selections'!E37+'Step 1 - Make Selections'!G37","v":0},{"$f":"(122*0.0078125)*M4","v":0},{"$f":"IF((N4+N5+N6)>=5,0.12,0)","v":0},{"$f":"'Step 1 - Make Selections'!F37+'Step 1 - Make Selections'!H37","v":0},{"$f":"(P4+P5+P6)*O4","v":0},{"$f":"Q4","v":0}]
[18000,34999,0.08,0.06,{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)>=2000,'Step 1 - Make Selections'!$G$16>=$A5,'Step 1 - Make Selections'!$G$16<=$B5),C5)","v":false},{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)<2000,'Step 1 - Make Selections'!$G$16>=$A5,'Step 1 - Make Selections'!$G$16<=$B5),D5)","v":false},{"$f":"SUM(E5:F5)","v":0},null,null,"Insignia® SC Intrinsic™ brand Fungicide","4 x 122 fl oz",59012450,{"$f":"'Step 1 - Make Selections'!E36+'Step 1 - Make Selections'!G36","v":0},{"$f":"(488*0.0078125)*M5","v":0},null,{"$f":"'Step 1 - Make Selections'!F36+'Step 1 - Make Selections'!H36","v":0}]
[35000,1000000,0.1,0.1,{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)>=2000,'Step 1 - Make Selections'!$G$16>=$A6,'Step 1 - Make Selections'!$G$16<=$B6),C6)","v":false},{"$f":"IF(AND(('Step 1 - Make Selections'!$F$48+'Step 1 - Make Selections'!$F$78)<2000,'Step 1 - Make Selections'!$G$16>=$A6,'Step 1 - Make Selections'!$G$16<=$B6),D6)","v":false},{"$f":"SUM(E6:F6)","v":0},null,null,"Insignia® SC Intrinsic™ brand Fungicide","2x 2.5 gal",59012382,{"$f":"'Step 1 - Make Selections'!E35+'Step 1 - Make Selections'!G35","v":0},{"$f":"5*M6","v":0},null,{"$f":"'Step 1 - Make Selections'!F35+'Step 1 - Make Selections'!H35","v":0}]
[null,null,"DISCOUNT",null,{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":0},{"$f":"SUM(E7:F7)","v":0},null,null,"TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(R4+R2)","v":0}]

{"sheet":"Article Reference","index":4,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["ART","BRAND","PACKAGE"]
[59021463,"Emerald® Fungicide","10 x 0.49 lb"]
[59012825,"Emerald® Fungicide","50 x 0.49 lb"]
[59011296,"FreeHand® Herbicide","1 x 50 lb"]
[59012350,"Honor® Intrinsic™ Brand Fungicide","6 x 3 lb"]
[59012885,"Honor® Intrinsic™ Brand Fungicide","1 x 36 lb"]
[59014134,"Insignia® SC Intrinsic™ Brand Fungicide","4 x 30.5 fl oz"]
[59012450,"Insignia® SC Intrinsic™ Brand Fungicide","4 x 122 fl oz"]
[59014135,"Insignia® SC Intrinsic™ Brand Fungicide","2x 2.5 gal"]
[59013840,"Lexicon® Intrinsic™ Brand Fungicide","4x 21 oz"]
[59014379,"Orkestra™ Intrinsic™ Brand Fungicide","4x 16 oz"]
[59012349,"Pageant® Intrinsic™ Brand Fungicide","4 x 1 lb"]
[59012429,"Pageant® Intrinsic™ Brand Fungicide","4 x 12 lb"]
[59011279,"Pendulum® AquaCap™ Herbicide","1 x 15 gal"]
[59049202,"Pendulum® AquaCap™ Bulk Herbicide","110 gal"]
[59049202,"Pendulum® AquaCap™ Bulk Herbicide","220 gal"]
[59017968,"Pylex Herbicide (New)","4x 4 oz"]
[59014176,"Pylon® Insecticide","2 x 0.5 gal"]
[59014112,"Sultan™ Miticide","4x 0.125 gal"]
[59014247,"Tower® Herbicide","2 x 2.5 gal"]
[59013833,"Xzemplar™ Fungicide","2x 114 oz"]
[59014120,"Xzemplar™Fungicide","4 x 11.4 oz"]
[null,"BASF 2016 EOP Qualifying  Non-Agency Products"]
["Article Number","Qaulifying Non-Agency Products","Package"]
[59013341,"Admiral Lake Colorant","4x1 gal"]
[59013451,"All Weather Foam Concentrate","4x1 gal"]
[59021451,"Amdro Pro Fire Ant Bait","1 x 25lbs"]
[59011636,"Basagran Herbicide","2x 1 gal"]
[59013424,"Black Onyx","4x1 gal"]
[59011404,"Drive XLR8 Herbicide","4x .5 gal"]
[59013434,"Green Lawnger","4x1 gal"]
[59013430,"Green Lawnger","2x2.5 gal"]
[59013410,"Green Lawnger Transition HC Colorant","4x 1 gal"]
[59013284,"Green Lawnger Turf Colorant","1x 30 gal"]
[59013342,"Green Lawnger Vision Pro","4x1 gal"]
[59013346,"Neutralize Dry","12 x 2 lbs"]
[59014385,"Neutralize Liquid","4 x 1 gal"]
[59013352,"NutroSol Tank Cleaner","12x2 lbs"]
[59015072,"Pendulum 2G","40 lbs bag"]
[59015228,"Pendulum 3.3EC","2x2.5 gal"]
[59049276,"Pendulum Aquacap","2x2.5 gal"]
[59012784,"Pillar G","30 lbs bag"]
[59017959,"Pillar G (New)","15 lbs bag"]
[59013624,"Pylex Herbicide ","4x 8 fl oz"]
[59014427,"Segment II Herbicide","2x 2.5 gal"]
[59013697,"Shakedown Anti Foam","12x 1 qt"]
[59011057,"Siesta Fire Ant Bait","15 lbs"]
[59014404,"Sprint 330 Iron Chelate ","6x5 lbs"]
[59014406,"Sprint 330 Iron Chelate ","1x50 lbs"]
[59011038,"Trinity Fungicide","2x2.5gal"]
[59013723,"Turf Mark","12 x .25 gal"]
[59013314,"Turf Mark","1 x 30 gal"]
[59013417,"Turf Mark Blue","2x 2.5 gal"]
[59013486,"Turf Mark Green","2x 2.5 gal"]

{"sheet":"Coverage Reference","index":5,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,0,1,1]]}
["Calculator Acreage"]
["Acre Coverage"]
["Product Name","Article #","Package Size","Price/Case","Low Rate","Mid Rate","High rate"]
["Xzemplar",59013833,"2 x 114 oz",null,32.799999999999997,24.95,20]
["Xzemplar",59014120,"4 x 11.4 oz",null,6.6,5,4]
["Emerald",59021463,"10 x .49 lb.",null,13.9,12,10]
["Emerald",59012825,"50 x .49 lb.",null,69.3,60,50]
["Curalan ",59013627,"12 x 2.75 lb.",null,12,12,12]
["Trinity",59011038,"2 x 2.5 gal",null,29.4,18.3,7.3]
["Lexicon",59013840,"4 x 21 oz",null,5.68,4.84,4]
["Honor",59012885,"1 x 36 lb",null,24,18,12]
["Honor",59012350,"6 x 3 lb",null,12,9,6]
["Insignia SC",59014135,"2 x 2.5 gal",null,36.799999999999997,28.9,21]
["Insignia SC",59014134,"4 x 30.5 oz",null,7,5.5,4]
["Insignia SC",59012450,"4 x 122 oz",null,28,22,16]
["Pillar G",59017959,"15 lbs",null,0.11,0.11,0.11]
["Pillar G",59012784,"30 lbs ",null,0.22,0.22,0.22]