{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Step 1 - Make Selections","Step 2 - Manage Applications","Step 3 - Review Order","Range Reference","Article Reference","Coverage Reference","Cube Reference"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":96,"n_cols":11,"rows_kept":96,"cut":false,"hidden":false,"merged":[[18,0,18,2],[23,1,23,2],[19,1,19,2],[74,8,74,10],[20,6,20,7],[19,6,19,7],[18,6,18,7],[21,3,21,5],[20,3,20,5],[19,3,19,5],[18,3,18,5],[21,6,21,7],[23,6,23,7],[20,0,22,0],[20,1,22,2],[95,0,104,7],[90,8,90,10],[74,0,74,4],[90,0,90,4],[22,6,22,7],[22,3,22,5],[24,1,24,2],[24,3,24,5],[24,6,24,7],[23,3,23,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"G19*#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B24=\"Not Achieved\",0,B24)","v":0}]
[]
[]
[]
[]
[]
["EOP Rebate Calculator",null,null,"TOTAL EOP PURCHASE",null,null,{"$f":"I75+I91","v":0}]
["Rebate Program Locked",{"$f":"IF((F91+F75)>=2000,\"October Rebate Locked\",IF((I75+I91)>=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$19<=0,\"Reached\",2000-$G$19)","v":2000}]
["Rebate Level",{"$f":"IF('Range Reference'!G6=0,0,'Range Reference'!G6)","v":0},null,"$ To Reach Rebate Level 2",null,null,{"$f":"IF(7000-$G$19<=0,\"Reached\",7000-$G$19)","v":7000}]
[null,null,null,"$ To Reach Rebate Level 3",null,null,{"$f":"IF(20000-$G$19<=0,\"Reached\",20000-$G$19)","v":20000}]
[null,null,null,"Rebate $ on Total Purchases",null,null,{"$f":"IF(B21=0,\"Not Achieved\",B21*G19)","v":"Not Achieved"}]
["Intrinsic Fairway Rebate",{"$f":"IF('Range Reference'!R3+'Range Reference'!R5=0,\"Not Achieved\",'Range Reference'!R3+'Range Reference'!R5)","v":"Not Achieved"},null,"Additional Intrinsic/Freehand Rebate",null,null,{"$f":"IF('Range Reference'!R8=0,\"Not Achieved\",'Range Reference'!R8)","v":"Not Achieved"}]
["Freehand Bulk Rebate",{"$f":"IF('Range Reference'!R2=0,\"Not Achieved\",'Range Reference'!R2)","v":"Not Achieved"},null,"TOTAL EOP Rebate",null,null,{"$f":"IF(G24=\"Not Achieved\",G19*B21,(G19*B21)+G24)","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"]
["Multi-course Fairway Cube","Cube",59014559,32226,0,{"$f":"D28*E28","v":0},0,{"$f":"G28*D28","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E28+G28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E28+G28))","v":0},{"$f":"IF(ISNA(VLOOKUP($C28,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C28,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E28+G28))","v":0}]
[{"$f":"VLOOKUP($C29,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Xzemplar™ Fungicide"},{"$f":"VLOOKUP($C29,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2x 114 oz"},59013833,null,{"$f":"E28*5","v":0},null,{"$f":"G28*5","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E29+G29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E29+G29))","v":0},{"$f":"IF(ISNA(VLOOKUP($C29,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C29,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E29+G29))","v":0}]
[{"$f":"VLOOKUP($C30,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Emerald® Fungicide"},{"$f":"VLOOKUP($C30,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"50 x 0.49 lb"},59012825,null,{"$f":"E28*1","v":0},null,{"$f":"G28*1","v":0}]
[{"$f":"VLOOKUP($C31,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Emerald® Fungicide"},{"$f":"VLOOKUP($C31,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"10 x 0.49 lb"},59021463,null,{"$f":"E28*1","v":0},null,{"$f":"G28*1","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E31+G31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E31+G31))","v":0},{"$f":"IF(ISNA(VLOOKUP($C31,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C31,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E31+G31))","v":0}]
[{"$f":"VLOOKUP($C32,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Honor® Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C32,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 36 lb"},59012885,null,{"$f":"E28*3","v":0},null,{"$f":"G28*3","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E32+G32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E32+G32))","v":0},{"$f":"IF(ISNA(VLOOKUP($C32,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C32,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E32+G32))","v":0}]
["Dollar Spot Foundation Cube","Cube",59014560,13869,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E33+G33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E33+G33))","v":0},{"$f":"IF(ISNA(VLOOKUP($C33,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C33,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E33+G33))","v":0}]
[{"$f":"VLOOKUP($C34,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Xzemplar™ Fungicide"},{"$f":"VLOOKUP($C34,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2x 114 oz"},59013833,null,{"$f":"E33*3","v":0},null,{"$f":"G33*3","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E34+G34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E34+G34))","v":0},{"$f":"IF(ISNA(VLOOKUP($C34,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C34,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E34+G34))","v":0}]
[{"$f":"VLOOKUP($C35,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Emerald® Fungicide"},{"$f":"VLOOKUP($C35,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"10 x 0.49 lb"},59021463,null,{"$f":"E33*3","v":0},null,{"$f":"G33*3","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E35+G35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E35+G35))","v":0},{"$f":"IF(ISNA(VLOOKUP($C35,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C35,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E35+G35))","v":0}]
["New Innovation Cube","Cube",59014244,7441,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E36+G36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E36+G36))","v":0},{"$f":"IF(ISNA(VLOOKUP($C36,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C36,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E36+G36))","v":0}]
[{"$f":"VLOOKUP($C37,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Xzemplar™Fungicide"},{"$f":"VLOOKUP($C37,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4 x 11.4 oz"},59014120,null,{"$f":"3*E36","v":0},null,{"$f":"3*G36","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E37+G37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E37+G37))","v":0},{"$f":"IF(ISNA(VLOOKUP($C37,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C37,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E37+G37))","v":0}]
[{"$f":"VLOOKUP($C38,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Lexicon® Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C38,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4x 21 oz"},59013840,null,{"$f":"3*E36","v":0},null,{"$f":"3*G36","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E38+G38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E38+G38))","v":0},{"$f":"IF(ISNA(VLOOKUP($C38,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C38,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E38+G38))","v":0}]
["Fairway Building Block Cube","Cube",59014398,6036,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E39+G39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E39+G39))","v":0},{"$f":"IF(ISNA(VLOOKUP($C39,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C39,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E39+G39))","v":0}]
[{"$f":"VLOOKUP($C40,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Xzemplar™ Fungicide"},{"$f":"VLOOKUP($C40,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2x 114 oz"},59013833,null,{"$f":"1*E39","v":0},null,{"$f":"1*G39","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E40+G40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E40+G40))","v":0},{"$f":"IF(ISNA(VLOOKUP($C40,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C40,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E40+G40))","v":0}]
[{"$f":"VLOOKUP($C41,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Emerald® Fungicide"},{"$f":"VLOOKUP($C41,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"10 x 0.49 lb"},59021463,null,{"$f":"2*E39","v":0},null,{"$f":"2*G39","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E41+G41))","v":0},{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E41+G41))","v":0},{"$f":"IF(ISNA(VLOOKUP($C41,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C41,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E41+G41))","v":0}]
["More Resilience II Cube","Cube",59014397,30284,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E42+G42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E42+G42))","v":0},{"$f":"IF(ISNA(VLOOKUP($C42,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C42,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E42+G42))","v":0}]
[{"$f":"VLOOKUP($C43,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Xzemplar™ Fungicide"},{"$f":"VLOOKUP($C43,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2x 114 oz"},59013833,null,{"$f":"2*E42","v":0},null,{"$f":"2*G42","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E43+G43))","v":0},{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E43+G43))","v":0},{"$f":"IF(ISNA(VLOOKUP($C43,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C43,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E43+G43))","v":0}]
[{"$f":"VLOOKUP($C44,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Emerald® Fungicide"},{"$f":"VLOOKUP($C44,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"50 x 0.49 lb"},59012825,null,{"$f":"1*E42","v":0},null,{"$f":"1*G42","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E44+G44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E44+G44))","v":0},{"$f":"IF(ISNA(VLOOKUP($C44,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C44,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E44+G44))","v":0}]
[{"$f":"VLOOKUP($C45,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Trinity fungicide"},{"$f":"VLOOKUP($C45,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2.5 gal."},59011038,null,{"$f":"2*E42","v":0},null,{"$f":"2*G42","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E45+G45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E45+G45))","v":0},{"$f":"IF(ISNA(VLOOKUP($C45,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C45,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E45+G45))","v":0}]
[{"$f":"VLOOKUP($C46,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Honor® Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C46,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 36 lb"},59012885,null,{"$f":"3*E42","v":0},null,{"$f":"3*G42","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E46+G46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E46+G46))","v":0},{"$f":"IF(ISNA(VLOOKUP($C46,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C46,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E46+G46))","v":0}]
[{"$f":"VLOOKUP($C47,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Lexicon® Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C47,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4x 21 oz"},59013840,null,{"$f":"3*E42","v":0},null,{"$f":"3*G42","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E47+G47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E47+G47))","v":0},{"$f":"IF(ISNA(VLOOKUP($C47,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C47,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E47+G47))","v":0}]
["Plant Health Cube","Cube",59014232,8727,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E48+G48))","v":0},{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E48+G48))","v":0},{"$f":"IF(ISNA(VLOOKUP($C48,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C48,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E48+G48))","v":0}]
[{"$f":"VLOOKUP($C49,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Honor® Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C49,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 36 lb"},59012885,null,{"$f":"1*E48","v":0},null,{"$f":"1*G48","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E49+G49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E49+G49))","v":0},{"$f":"IF(ISNA(VLOOKUP($C49,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C49,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E49+G49))","v":0}]
[{"$f":"VLOOKUP($C50,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Lexicon® Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C50,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4x 21 oz"},59013840,null,{"$f":"3*E48","v":0},null,{"$f":"3*G48","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E50+G50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E50+G50))","v":0},{"$f":"IF(ISNA(VLOOKUP($C50,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C50,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E50+G50))","v":0}]
["Greens Foundation Cube","Cube",59014396,5791,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E51+G51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E51+G51))","v":0},{"$f":"IF(ISNA(VLOOKUP($C51,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C51,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E51+G51))","v":0}]
[{"$f":"VLOOKUP($C52,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Lexicon® Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C52,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4x 21 oz"},59013840,null,{"$f":"1*E51","v":0},null,{"$f":"1*G51","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E52+G52))","v":0},{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E52+G52))","v":0},{"$f":"IF(ISNA(VLOOKUP($C52,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C52,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E52+G52))","v":0}]
[{"$f":"VLOOKUP($C53,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Insignia® SC Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C53,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,null,{"$f":"2*E51","v":0},null,{"$f":"2*G51","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E53+G53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E53+G53))","v":0},{"$f":"IF(ISNA(VLOOKUP($C53,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C53,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E53+G53))","v":0}]
[{"$f":"VLOOKUP($C54,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Trinity fungicide"},{"$f":"VLOOKUP($C54,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2.5 gal."},59011038,null,{"$f":"1*E51","v":0},null,{"$f":"1*G51","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E54+G54))","v":0},{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E54+G54))","v":0},{"$f":"IF(ISNA(VLOOKUP($C54,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C54,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E54+G54))","v":0}]
["Naturalized Area II Cube","Cube",59014556,4338,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E55+G55))","v":0},{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E55+G55))","v":0},{"$f":"IF(ISNA(VLOOKUP($C55,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C55,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E55+G55))","v":0}]
[{"$f":"VLOOKUP($C56,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Pendulum® AquaCap™ Herbicide"},{"$f":"VLOOKUP($C56,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 15 gal"},59011279,null,{"$f":"E55*2","v":0},null,{"$f":"G55*2","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E56+G56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E56+G56))","v":0},{"$f":"IF(ISNA(VLOOKUP($C56,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C56,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E56+G56))","v":0}]
[{"$f":"VLOOKUP($C57,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Pylex Herbicide"},"2 x 2.5 gal.",59013624,null,{"$f":"E55*1","v":0},null,{"$f":"G55*1","v":0}]
[{"$f":"VLOOKUP($C58,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Segment II Herbicide"},"4 x 1 gal",59014427,null,{"$f":"E55*1","v":0},null,{"$f":"G55*1","v":0},null,{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E58+G58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E58+G58))","v":0},{"$f":"IF(ISNA(VLOOKUP($C58,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C58,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E58+G58))","v":0}]
[{"$f":"VLOOKUP($C59,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Emerald® Fungicide"},{"$f":"VLOOKUP($C59,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"10 x 0.49 lb"},59021463,1568,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E59+G59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E59+G59))","v":0},{"$f":"IF(ISNA(VLOOKUP($C59,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C59,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E59+G59))","v":0}]
[{"$f":"VLOOKUP($C60,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Emerald® Fungicide"},{"$f":"VLOOKUP($C60,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"50 x 0.49 lb"},59012825,6835.5,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E60+G60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E60+G60))","v":0},{"$f":"IF(ISNA(VLOOKUP($C60,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C60,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E60+G60))","v":0}]
[{"$f":"VLOOKUP($C61,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"FreeHand® Herbicide"},{"$f":"VLOOKUP($C61,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 50 lb"},59011296,93.5,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E61+G61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E61+G61))","v":0},{"$f":"IF(ISNA(VLOOKUP($C61,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C61,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E61+G61))","v":0}]
[{"$f":"VLOOKUP($C62,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Honor® Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C62,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"6 x 3 lb"},59012350,2616.12,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E62+G62))","v":0},{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E62+G62))","v":0},{"$f":"IF(ISNA(VLOOKUP($C62,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C62,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E62+G62))","v":0}]
[{"$f":"VLOOKUP($C63,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Honor® Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C63,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 36 lb"},59012885,3891.24,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E63+G63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E63+G63))","v":0},{"$f":"IF(ISNA(VLOOKUP($C63,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C63,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E63+G63))","v":0}]
[{"$f":"VLOOKUP($C64,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Insignia® SC Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C64,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4 x 30.5 fl oz"},59014134,1700.68,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E64+G64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E64+G64))","v":0},{"$f":"IF(ISNA(VLOOKUP($C64,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C64,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E64+G64))","v":0}]
[{"$f":"VLOOKUP($C65,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Insignia® SC Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C65,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4 x 122 fl oz"},59012450,6368.4,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E65+G65))","v":0},{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E65+G65))","v":0},{"$f":"IF(ISNA(VLOOKUP($C65,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C65,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E65+G65))","v":0}]
[{"$f":"VLOOKUP($C66,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Insignia® SC Intrinsic™ brand Fungicide"},{"$f":"VLOOKUP($C66,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2x 2.5 gal"},59014135,5795,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E66+G66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E66+G66))","v":0},{"$f":"IF(ISNA(VLOOKUP($C66,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C66,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E66+G66))","v":0}]
[{"$f":"VLOOKUP($C67,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Lexicon® Intrinsic™ Brand Fungicide"},{"$f":"VLOOKUP($C67,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4x 21 oz"},59013840,1935.36,0,{"$f":"D67*E67","v":0},0,{"$f":"G67*D67","v":0},{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E67+G67))","v":0},{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E67+G67))","v":0},{"$f":"IF(ISNA(VLOOKUP($C67,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C67,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E67+G67))","v":0}]
[{"$f":"VLOOKUP($C68,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Orkestra™ Intrinsic™ brand fungicide"},{"$f":"VLOOKUP($C68,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4x 16 oz"},59014379,544,0,{"$f":"D68*E68","v":0},0,{"$f":"G68*D68","v":0}]
[{"$f":"VLOOKUP($C69,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Pendulum® AquaCap™ Herbicide"},{"$f":"VLOOKUP($C69,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 15 gal"},59011279,735.3,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E69+G69))","v":0},{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E69+G69))","v":0},{"$f":"IF(ISNA(VLOOKUP($C69,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C69,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E69+G69))","v":0}]
[{"$f":"VLOOKUP($C70,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Pendulum® AquaCap™ Bulk Herbicide"},{"$f":"VLOOKUP($C70,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"110 gal"},59049202,5392.2,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E70+G70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E70+G70))","v":0},{"$f":"IF(ISNA(VLOOKUP($C70,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C70,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E70+G70))","v":0}]
[{"$f":"VLOOKUP($C71,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Pendulum® AquaCap™ Bulk Herbicide"},"220 gal",59049202,10784.4,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E71+G71))","v":0},{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E71+G71))","v":0},{"$f":"IF(ISNA(VLOOKUP($C71,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C71,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E71+G71))","v":0}]
[{"$f":"VLOOKUP($C72,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Tower® Herbicide"},{"$f":"VLOOKUP($C72,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2 x 2.5 gal"},59014247,1482.5,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E72+G72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E72+G72))","v":0},{"$f":"IF(ISNA(VLOOKUP($C72,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C72,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E72+G72))","v":0}]
[{"$f":"VLOOKUP($C73,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Xzemplar™ Fungicide"},{"$f":"VLOOKUP($C73,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"2x 114 oz"},59013833,3565.92,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E73+G73))","v":0},{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E73+G73))","v":0},{"$f":"IF(ISNA(VLOOKUP($C73,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C73,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E73+G73))","v":0}]
[{"$f":"VLOOKUP($C74,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"Xzemplar™Fungicide"},{"$f":"VLOOKUP($C74,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"4 x 11.4 oz"},59014120,820.8,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E74+G74))","v":0},{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E74+G74))","v":0},{"$f":"IF(ISNA(VLOOKUP($C74,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C74,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E74+G74))","v":0}]
["AGENCY SUB-TOTAL",null,null,null,null,{"$f":"SUM(F28:F74)","v":0},null,{"$f":"SUM(H28:H74)","v":0},{"$f":"H75+F75","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"]
["Admiral Lake Colorant","4 x 1 gal.",59013341,163.95,0,{"$f":"E77*D77","v":0},0,{"$f":"G77*D77","v":0},{"$f":"IF(ISNA(VLOOKUP($C77,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C77,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E77+G77))","v":0},{"$f":"IF(ISNA(VLOOKUP($C77,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C77,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E77+G77))","v":0},{"$f":"IF(ISNA(VLOOKUP($C77,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C77,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E77+G77))","v":0}]
["Black Onyx Lake Colorant","4 x 1 gal.",59013424,298.10000000000002,0,{"$f":"E78*D78","v":0},0,{"$f":"G78*D78","v":0},{"$f":"IF(ISNA(VLOOKUP($C78,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C78,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E78+G78))","v":0},{"$f":"IF(ISNA(VLOOKUP($C78,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C78,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E78+G78))","v":0},{"$f":"IF(ISNA(VLOOKUP($C78,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C78,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E78+G78))","v":0}]
["Drive XLR8 herbicide","4 x 0.5 lb.",59011404,294.02999999999997,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C79,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C79,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E79+G79))","v":0},{"$f":"IF(ISNA(VLOOKUP($C79,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C79,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E79+G79))","v":0},{"$f":"IF(ISNA(VLOOKUP($C79,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C79,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E79+G79))","v":0}]
["Green Lawnger turf colorant","2 x 2.5 gal.",59013430,285.63,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C80,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C80,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E80+G80))","v":0},{"$f":"IF(ISNA(VLOOKUP($C80,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C80,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E80+G80))","v":0},{"$f":"IF(ISNA(VLOOKUP($C80,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C80,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E80+G80))","v":0}]
["Pendulum Aquacap herbicide","2 x 2.5 gal.",59049276,337.88,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C81,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C81,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E81+G81))","v":0},{"$f":"IF(ISNA(VLOOKUP($C81,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C81,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E81+G81))","v":0},{"$f":"IF(ISNA(VLOOKUP($C81,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C81,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E81+G81))","v":0}]
["Pillar G Intrinsic brand fungicide","30 lb.",59012784,74.63,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C82,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C82,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E82+G82))","v":0},{"$f":"IF(ISNA(VLOOKUP($C82,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C82,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E82+G82))","v":0},{"$f":"IF(ISNA(VLOOKUP($C82,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C82,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E82+G82))","v":0}]
["Pylex Herbicide","4x 8 fl. Oz. ",59013624,2224.8000000000002,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C83,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C83,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E83+G83))","v":0},{"$f":"IF(ISNA(VLOOKUP($C83,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C83,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E83+G83))","v":0},{"$f":"IF(ISNA(VLOOKUP($C83,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C83,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E83+G83))","v":0}]
["Segment II Herbicide-NEW","2x2.5 gallon",59011288,1125,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C84,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C84,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E84+G84))","v":0},{"$f":"IF(ISNA(VLOOKUP($C84,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C84,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E84+G84))","v":0},{"$f":"IF(ISNA(VLOOKUP($C84,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C84,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E84+G84))","v":0}]
["Siesta Insecticide Fire Ant bait","15 lb.",59011057,204,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C85,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C85,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E85+G85))","v":0},{"$f":"IF(ISNA(VLOOKUP($C85,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C85,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E85+G85))","v":0},{"$f":"IF(ISNA(VLOOKUP($C85,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C85,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E85+G85))","v":0}]
["Transition HC dark turf colorant","4 x 1 gal.",59013410,606.35,0,0,0,0]
["Trinity fungicide","2x 2.5 gal.",59011038,1100.06,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C87,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C87,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E87+G87))","v":0},{"$f":"IF(ISNA(VLOOKUP($C87,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C87,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E87+G87))","v":0},{"$f":"IF(ISNA(VLOOKUP($C87,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C87,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E87+G87))","v":0}]
["Turf Mark spray indicator-Blue","2 x 2.5 gal.",59013417,212.94,0,{"$f":"E88*D88","v":0},0,{"$f":"G88*D88","v":0}]
["Turf Mark spray indicator-Green","2 x 2.5 gal.",59013486,258.88,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C89,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C89,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E89+G89))","v":0},{"$f":"IF(ISNA(VLOOKUP($C89,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C89,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E89+G89))","v":0},{"$f":"IF(ISNA(VLOOKUP($C89,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C89,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E89+G89))","v":0}]
["Vision Pro HD turf colorant","4x1 gal.",59013342,540.20000000000005,0,0,0,0,{"$f":"IF(ISNA(VLOOKUP($C90,'Coverage Reference'!$B$4:$G$16,4,FALSE))=TRUE,0,VLOOKUP($C90,'Coverage Reference'!$B$4:$G$16,4,FALSE)*(E90+G90))","v":0},{"$f":"IF(ISNA(VLOOKUP($C90,'Coverage Reference'!$B$4:$G$16,5,FALSE))=TRUE,0,VLOOKUP($C90,'Coverage Reference'!$B$4:$G$16,5,FALSE)*(E90+G90))","v":0},{"$f":"IF(ISNA(VLOOKUP($C90,'Coverage Reference'!$B$4:$G$16,6,FALSE))=TRUE,0,VLOOKUP($C90,'Coverage Reference'!$B$4:$G$16,6,FALSE)*(E90+G90))","v":0}]
["NON-AGENCY SUB-TOTAL",null,null,null,null,{"$f":"SUM(F77:F90)","v":0},null,{"$f":"SUM(H77:H90)","v":0},{"$f":"H91+F91","v":0}]
[]
[]
[]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2018 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":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,45,8],[24,0,25,0],[22,2,23,2],[30,0,32,0],[28,0,29,0],[26,0,27,0],[22,0,23,0],[22,1,23,1],[18,0,18,1],[17,0,17,1],[22,7,22,8],[22,5,22,6],[22,3,22,4],[21,0,21,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Enter Acres for your Course (Required)"]
["Fairways & Tees Acres",null,0]
["Greens Acres",null,0]
[]
["Please complete Yellow \"Use Area\" cells with either Fairways or Greens"]
["Fungicide Planner",null,null,null,null,null,null,null,null,null,null,null,"Fairways"]
["Product Name","Case Size","Use Area","Low Rate",null,"Mid Rate",null,"High Rate",null,null,null,null,"Greens"]
[null,null,null,"Total Acres","Applications","Total Acres","Applications","Total Acres","Applications"]
["Xzemplar","2 x 114 oz",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K25)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K25)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C25=\"Greens\",D25/$C$19,IF(C25=\"Fairways\",D25/$C$18,0)))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K25)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K25)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C25=\"Greens\",F25/$C$19,IF(C25=\"Fairways\",F25/$C$18,0)))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K25)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K25)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C25=\"Greens\",H25/$C$19,IF(C25=\"Fairways\",H25/$C$18,0)))","v":"Please Enter Acreage"},null,59013833]
[null,"4 x 11.4 oz",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K26)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K26)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K26)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K26)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C26=\"Greens\",F26/$C$19,IF(C26=\"Fairways\",F26/$C$18,0)))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K26)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K26)","v":0},"Please Enter Acreage",null,59014120]
["Emerald","10 x .49 lb.",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K27)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K27)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K27)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K27)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C27=\"Greens\",F27/$C$19,IF(C27=\"Fairways\",F27/$C$18,0)))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K27)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K27)","v":0},"Please Enter Acreage",null,59021463]
[null,"50 x .49 lb.",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K28)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K28)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K28)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K28)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K28)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K28)","v":0},"Please Enter Acreage",null,59012825]
["Honor","1 x 36 lb",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K29)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K29)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K29)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K29)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C29=\"Greens\",F29/$C$19,IF(C29=\"Fairways\",F29/$C$18,0)))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K29)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K29)","v":0},"Please Enter Acreage",null,59012885]
[null,"6 x 3 lb",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K30)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K30)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K30)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K30)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K30)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K30)","v":0},"Please Enter Acreage",null,59012350]
["Insignia SC","4 x 30.5 fl oz",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K31)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K31)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K31)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K31)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C31=\"Greens\",F31/$C$19,IF(C31=\"Fairways\",F31/$C$18,0)))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K31)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K31)","v":0},"Please Enter Acreage",null,59014134]
[null,"4 x 122 fl oz",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K32)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K32)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K32)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K32)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K32)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K32)","v":0},"Please Enter Acreage",null,59012450]
[null,"2x 2.5 gal",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K33)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K33)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K33)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K33)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K33)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K33)","v":0},"Please Enter Acreage",null,59014135]
["Trinity","2 x 2.5 gal",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K34)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K34)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K34)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K34)","v":0},{"$f":"IF(OR($C$18=0,$C$19=0),\"Please Enter Acreage\",IF(C34=\"Greens\",F34/$C$19,IF(C34=\"Fairways\",F34/$C$18,0)))","v":"Please Enter Acreage"},{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K34)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K34)","v":0},"Please Enter Acreage",null,59011038]
["Lexicon","4 x 21 oz",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K35)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K35)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K35)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K35)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K35)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K35)","v":0},"Please Enter Acreage",null,59013840]
["Pillar G Intrinsic","30 lb.",null,{"$f":"SUMIFS('Step 1 - Make Selections'!I$28:I$74,'Step 1 - Make Selections'!$C$28:$C$74,$K36)+SUMIFS('Step 1 - Make Selections'!I$77:I$90,'Step 1 - Make Selections'!$C$77:$C$90,$K36)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!J$28:J$74,'Step 1 - Make Selections'!$C$28:$C$74,$K36)+SUMIFS('Step 1 - Make Selections'!J$77:J$90,'Step 1 - Make Selections'!$C$77:$C$90,$K36)","v":0},"Please Enter Acreage",{"$f":"SUMIFS('Step 1 - Make Selections'!K$28:K$74,'Step 1 - Make Selections'!$C$28:$C$74,$K36)+SUMIFS('Step 1 - Make Selections'!K$77:K$90,'Step 1 - Make Selections'!$C$77:$C$90,$K36)","v":0},"Please Enter Acreage",null,59012784]
[]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2018 Early Order Program.  The calculator is being shared with you for information purposes only and for your private use in preparing your own calculations. While every effort has been made to ensure the accuracy and reliability of the information and formulas, no guarantee is given nor responsibility taken by BASF for the accuracy of the calculator or the applicability to your particular circumstances.\n\nBASF PROVIDES THIS CALCULATOR AND ANY RESULT THEREFROM AS IS WITH ALL FAULTS AND WITH NO WARRANTY WHATSOEVER, EITHER EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY AND FITNESS FOR PARTICULAR PURPOSE.  YOU ASSUME ANY AND ALL RISKS IN USING THE CALCULATOR AND RELYING ON THE INFORMATION CONTAINED HEREIN.  IN NO CIRCUMSTANCES SHALL BASF BE LIABLE FOR ANY DAMAGES WHATSOEVER, INCLUDING BUT NOT LIMITED TO LOSS OF PROFIT, LOSS OF BUSINESS, LOSS OF SAVINGS, OR CONSEQUENTIAL DAMAGES, EVEN IF BASF HAS BEEN NOTIFIED AS SUCH."]

{"sheet":"Step 3 - Review Order","index":2,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[17,2,18,3],[60,0,69,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"NOW()","v":"2017-09-26T09:18:23.380"}]
["Order For","Order Prepared By",null,"Rebate Summary"]
["<Enter Customer Name>","<Enter Name>",null,"Total Purchase",null,{"$f":"'Step 1 - Make Selections'!G19","v":0}]
["<Enter Business Name>","<Enter Business Name>",null,"Rebate Level Attained",null,{"$f":"'Step 1 - Make Selections'!B21","v":0}]
["<City, ST Zip Code>","<City, ST Zip Code>",null,"Total Spend Rebate",null,{"$f":"'Step 1 - Make Selections'!G23","v":"Not Achieved"}]
["<Phone>","<Phone>",null,"Intrinsic/Freehand Rebate",null,{"$f":"'Step 1 - Make Selections'!G24","v":"Not Achieved"}]
["<email address>","<email address>",null,"Total EOP Rebate",null,{"$f":"'Step 1 - Make Selections'!G25","v":0}]
[]
[]
[]
["Your Order Detail"]
[]
["Product / Cubes","Package","Article No.","Price","Quantity","Total"]
["Multi-course Fairway Cube","Cube",59014559,32226,{"$f":"VLOOKUP(C22,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C22,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},{"$f":"E22*D22","v":0}]
["Dollar Spot Foundation Cube","Cube",59014560,13869,{"$f":"VLOOKUP(C23,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C23,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},{"$f":"E23*D23","v":0}]
["New Innovation Cube","Cube",59014244,7441,{"$f":"VLOOKUP(C24,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C24,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},0]
["Fairway Building Block Cube","Cube",59014398,6036,{"$f":"VLOOKUP(C25,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C25,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},0]
["More Resilience II Cube","Cube",59014397,30284,{"$f":"VLOOKUP(C26,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C26,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},0]
["Plant Health Cube","Cube",59014232,8727,{"$f":"VLOOKUP(C27,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C27,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},0]
["Greens Foundation Cube","Cube",59014396,5791,{"$f":"VLOOKUP(C28,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C28,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},0]
["Naturalized Area II Cube","Cube",59014556,4338,{"$f":"VLOOKUP(C29,'Step 1 - Make Selections'!$C$28:$G$90,3,FALSE)+VLOOKUP(C29,'Step 1 - Make Selections'!$C$28:$G$90,5,FALSE)","v":0},{"$f":"E29*D29","v":0}]
["Emerald® Fungicide","10 x 0.49 lb",59021463,1568,{"$f":"VLOOKUP(C30,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C30,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Emerald® Fungicide","50 x 0.49 lb",59012825,6835.5,{"$f":"VLOOKUP(C31,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C31,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["FreeHand® Herbicide","1 x 50 lb",59011296,93.5,{"$f":"VLOOKUP(C32,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C32,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Honor® Intrinsic™ brand Fungicide","6 x 3 lb",59012350,2616.12,{"$f":"VLOOKUP(C33,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C33,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Honor® Intrinsic™ brand Fungicide","1 x 36 lb",59012885,3891.24,{"$f":"VLOOKUP(C34,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C34,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Insignia® SC Intrinsic™ brand Fungicide","4 x 30.5 fl oz",59014134,1700.68,{"$f":"VLOOKUP(C35,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C35,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Insignia® SC Intrinsic™ brand Fungicide","4 x 122 fl oz",59012450,6368.4,{"$f":"VLOOKUP(C36,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C36,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Insignia® SC Intrinsic™ brand Fungicide","2x 2.5 gal",59014135,5795,{"$f":"VLOOKUP(C37,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C37,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Lexicon® Intrinsic™ Brand Fungicide","4x 21 oz",59013840,1935.36,{"$f":"VLOOKUP(C38,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C38,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Orkestra™ Intrinsic™ brand fungicide","4x 16 oz",59014379,544,{"$f":"VLOOKUP(C39,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C39,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Pendulum® AquaCap™ Herbicide","1 x 15 gal",59011279,735.3,{"$f":"VLOOKUP(C40,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C40,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Pendulum® AquaCap™ Bulk Herbicide","110 gal",59049202,5392.2,{"$f":"VLOOKUP(C41,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C41,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Pendulum® AquaCap™ Bulk Herbicide","220 gal",59049202,10784.4,{"$f":"VLOOKUP(C42,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C42,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Tower® Herbicide","2 x 2.5 gal",59014247,1482.5,{"$f":"VLOOKUP(C43,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C43,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Xzemplar™ Fungicide","2x 114 oz",59013833,3565.92,{"$f":"VLOOKUP(C44,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C44,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Xzemplar™Fungicide","4 x 11.4 oz",59014120,820.8,{"$f":"VLOOKUP(C45,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C45,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},0]
["Admiral Lake Colorant","4 x 1 gal.",59013341,"See Agent for Price",{"$f":"VLOOKUP(C46,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C46,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Black Onyx Lake Colorant","4 x 1 gal.",59013424,"See Agent for Price",{"$f":"VLOOKUP(C47,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C47,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Drive XLR8 herbicide","4 x 0.5 lb.",59011404,"See Agent for Price",{"$f":"VLOOKUP(C48,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C48,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Green Lawnger turf colorant","2 x 2.5 gal.",59013430,"See Agent for Price",{"$f":"VLOOKUP(C49,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C49,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Pendulum Aquacap herbicide","2 x 2.5 gal.",59049276,"See Agent for Price",{"$f":"VLOOKUP(C50,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C50,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Pillar G Intrinsic brand fungicide","30 lb.",59012784,"See Agent for Price",{"$f":"VLOOKUP(C51,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C51,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Pylex Herbicide","4x 8 fl. Oz. ",59013624,"See Agent for Price",{"$f":"VLOOKUP(C52,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C52,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Segment II Herbicide-NEW","2x2.5 gallon",59011288,"See Agent for Price",{"$f":"VLOOKUP(C53,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C53,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Siesta Insecticide Fire Ant bait","15 lb.",59011057,"See Agent for Price",{"$f":"VLOOKUP(C54,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C54,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Transition HC dark turf colorant","4 x 1 gal.",59013410,"See Agent for Price",{"$f":"VLOOKUP(C55,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C55,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Trinity fungicide","2x 2.5 gal.",59011038,"See Agent for Price",{"$f":"VLOOKUP(C56,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C56,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Turf Mark spray indicator-Blue","2 x 2.5 gal.",59013417,"See Agent for Price",{"$f":"VLOOKUP(C57,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C57,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Turf Mark spray indicator-Green","2 x 2.5 gal.",59013486,"See Agent for Price",{"$f":"VLOOKUP(C58,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C58,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
["Vision Pro HD turf colorant","4x1 gal.",59013342,"See Agent for Price",{"$f":"VLOOKUP(C59,'Step 1 - Make Selections'!$C$59:$G$90,3,FALSE)+VLOOKUP(C59,'Step 1 - Make Selections'!$C$59:$G$90,5,FALSE)","v":0},{"$f":"0","v":0}]
[]
["BASF has developed this calculator using formulas that approximate the rebate amount under the 2018 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":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":true,"merged":[[5,2,5,3],[7,9,7,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,{"$f":"VLOOKUP($L2,'Article Reference'!$A$2:$C$45,2,FALSE)","v":"FreeHand® Herbicide"},{"$f":"VLOOKUP($L2,'Article Reference'!$A$2:$C$45,3,FALSE)","v":"1 x 50 lb"},59011296,{"$f":"SUM('Step 1 - Make Selections'!E61+'Step 1 - Make Selections'!G61)","v":0},{"$f":"M2*50","v":0},{"$f":"IF(N2>=16000,0.1,0)","v":0},{"$f":"SUM('Step 1 - Make Selections'!F61+'Step 1 - Make Selections'!H61)","v":0},{"$f":"P2*O2","v":0},{"$f":"Q2","v":0}]
[2000,6999.99,0.04,0.03,{"$f":"IF(AND(('Step 1 - Make Selections'!$F$75+'Step 1 - Make Selections'!$F$91)>=2000,'Step 1 - Make Selections'!$G$19>=$A3,'Step 1 - Make Selections'!$G$19<=$B3),C3)","v":false},{"$f":"IF(AND(('Step 1 - Make Selections'!$F$75+'Step 1 - Make Selections'!$F$91)<2000,'Step 1 - Make Selections'!$G$19>=$A3,'Step 1 - Make Selections'!$G$19<=$B3),D3)","v":false},{"$f":"SUM(E3:F3)","v":0},null,null,"Honor® Intrinsic™ brand Fungicide","6 x 3 lb",59012350,{"$f":"SUM('Step 1 - Make Selections'!E62+'Step 1 - Make Selections'!G62)","v":0},{"$f":"M3*18","v":0},{"$f":"IF((N3+N4)>=108,0.1,0)","v":0},{"$f":"SUM('Step 1 - Make Selections'!F62+'Step 1 - Make Selections'!H62)","v":0},{"$f":"(P3+P4)*O3","v":0},{"$f":"Q3","v":0}]
[7000,19999.990000000002,7.0000000000000007E-2,0.05,{"$f":"IF(AND(('Step 1 - Make Selections'!$F$75+'Step 1 - Make Selections'!$F$91)>=2000,'Step 1 - Make Selections'!$G$19>=$A4,'Step 1 - Make Selections'!$G$19<=$B4),C4)","v":false},{"$f":"IF(AND(('Step 1 - Make Selections'!$F$75+'Step 1 - Make Selections'!$F$91)<2000,'Step 1 - Make Selections'!$G$19>=$A4,'Step 1 - Make Selections'!$G$19<=$B4),D4)","v":false},{"$f":"SUM(E4:F4)","v":0},null,null,"Honor® Intrinsic™ brand Fungicide","1 x 36 lb",59012885,{"$f":"SUM('Step 1 - Make Selections'!E63+'Step 1 - Make Selections'!G63)","v":0},{"$f":"36*M4","v":0},null,{"$f":"SUM('Step 1 - Make Selections'!F63+'Step 1 - Make Selections'!H63)","v":0}]
[20000,10000000,0.1,7.0000000000000007E-2,{"$f":"IF(AND(('Step 1 - Make Selections'!$F$75+'Step 1 - Make Selections'!$F$91)>=2000,'Step 1 - Make Selections'!$G$19>=$A5,'Step 1 - Make Selections'!$G$19<=$B5),C5)","v":false},{"$f":"IF(AND(('Step 1 - Make Selections'!$F$75+'Step 1 - Make Selections'!$F$91)<2000,'Step 1 - Make Selections'!$G$19>=$A5,'Step 1 - Make Selections'!$G$19<=$B5),D5)","v":false},{"$f":"SUM(E5:F5)","v":0},null,null,"Insignia® SC Intrinsic™ brand Fungicide","4 x 30.5 fl oz",59014134,{"$f":"SUM('Step 1 - Make Selections'!E64+'Step 1 - Make Selections'!G64)","v":0},{"$f":"(122*0.0078125)*M5","v":0},{"$f":"IF((N5+N6+N7)>=10,0.1,0)","v":0},{"$f":"SUM('Step 1 - Make Selections'!F64+'Step 1 - Make Selections'!H64)","v":0},{"$f":"(P5+P6+P7)*O5","v":0},{"$f":"Q5","v":0}]
[null," ","DISCOUNT",null,{"$f":"SUM(E3:E5)","v":0},{"$f":"SUM(F3:F5)","v":0},{"$f":"SUM(E6:F6)","v":0},null,null,"Insignia® SC Intrinsic™ brand Fungicide","4 x 122 fl oz",59012450,{"$f":"SUM('Step 1 - Make Selections'!E65+'Step 1 - Make Selections'!G65)","v":0},{"$f":"(488*0.0078125)*M6","v":0},null,{"$f":"SUM('Step 1 - Make Selections'!F65+'Step 1 - Make Selections'!H65)","v":0}]
[null,null,null,null,null,null,null,null,null,"Insignia® SC Intrinsic™ brand Fungicide","2x 2.5 gal",59012382,{"$f":"SUM('Step 1 - Make Selections'!E66+'Step 1 - Make Selections'!G66)","v":0},{"$f":"5*M7","v":0},null,{"$f":"SUM('Step 1 - Make Selections'!F66+'Step 1 - Make Selections'!H66)","v":0}]
[null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(R5+R3+R2)","v":0}]

{"sheet":"Article Reference","index":4,"n_rows":56,"n_cols":3,"rows_kept":56,"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"]
[59014176,"Pylon® Insecticide","2 x 0.5 gal"]
[59013978,"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","4 x 1 gal."]
[59013424,"Black Onyx Lake Colorant","4 x 1 gal."]
[59013627,"Curalan Fungicide","12 x 2.75 lb."]
[59011404,"Drive XLR8 herbicide","4 x 0.5 lb."]
[59012851,"Empress Intrinsic brand fungicide","24 fl. Oz."]
[59013430,"Green Lawnger turf colorant","2 x 2.5 gal."]
[59012736,"Orvego fungicide","28 fl. Oz."]
[59014427,"Segment II Herbicide","2x2.5 gallon"]
[59019276,"Pendulum Aquacap herbicide","2 x 2.5 gal."]
[59012784,"Pillar G Intrinsic brand fungicide","30 lb."]
[59013624,"Pylex Herbicide","8 fl. Oz. "]
[59011057,"Siesta Insecticide Fire Ant bait","15 lb."]
[null,"Stature SC Fungicide","6 x 25 oz."]
[59011637,"Tower Herbicide-New Size!","2 x 2.5 gal."]
[59013410,"Transition HC dark turf colorant","4 x 1 gal."]
[59011038,"Trinity fungicide","2.5 gal."]
[59013486,"Turf Mark spray indicator-Blue","2 x 2.5 gal."]
[null,"Turf Mark spray indicator-Green","2 x 2.5 gal."]
[59013342,"Vision Pro HD turf colorant","4x1 gal."]
[59011401,"Trinity Fungicide","4 x .5 gal"]
[59011288,"Stature Fungicide","6 x 25 oz"]
[59014112,"Sultan Miticide","4 X 1 PT"]
[59014240,"Complete Cube","Cube"]
[59014253,"Deep Freeze Cube","Cube"]
[59014237,"Defend Your Fairway Cube","Cube"]
[59014251,"Honor America Cube","Cube"]
[59014244,"New Innovation Cube","Cube"]
[59014249,"Mini Your Cube","Cube"]
[59014252,"More Resliience Cube","Cube"]
[59014232,"Plant Health Cube","Cube"]
[59014245,"Power Within Cube","Cube"]
[59014246,"Southern Weed Surrounds","Cube"]
[59014231,"Greenhouse & Nursery Foundation Cube","Cube"]

{"sheet":"Coverage Reference","index":5,"n_rows":16,"n_cols":7,"rows_kept":16,"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",59012784,"30 lbs ",null,0.22,0.22,0.22]

{"sheet":"Cube Reference","index":6,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["CUBE ART#","CUBE NAME","PRODUCT NAME","PROD ART#","CONCAT","PROD VOL","CASE SIZE","ACRES TREATED","2016 EOP PRICE","TOTAL BY PRODUCT","Low Rate Acres","High Rate Acres"]
[59014401,"Defent Your Fairways II Cube","Xzemplar",59013833,{"$f":"A2&D2","v":"5901440159013833"},5,"2 x 114 oz",100,3428.76,17143.800000000003,{"$f":"VLOOKUP($D2,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F2","v":164},{"$f":"VLOOKUP($D2,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F2","v":124.75}]
[59014401,"Defent Your Fairways II Cube","Emerald",59021463,{"$f":"A3&D3","v":"5901440159021463"},6,"10 x .49 lbs.",60,1524.29,9145.74,{"$f":"VLOOKUP($D3,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F3","v":83.4},{"$f":"VLOOKUP($D3,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F3","v":72}]
[59014401,"Defent Your Fairways II Cube","Trinity",59011038,"5901440159011038",2,"2x2.5 gal",30,963.89,1927.78,{"$f":"VLOOKUP($D4,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F4","v":58.8},{"$f":"VLOOKUP($D4,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F4","v":36.6}]
[59014399,"Honor Fairway Cube","Honor",59012885,"5901439959012885",4,"1x 36 lbs",48,3780,15120,{"$f":"VLOOKUP($D5,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F5","v":96},{"$f":"VLOOKUP($D5,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F5","v":72}]
[59014399,"Honor Fairway Cube","Emerald",59012825,"5901439959012825",1,"50 x .49 lb.",50,6636.81,6636.81,{"$f":"VLOOKUP($D6,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F6","v":69.3},{"$f":"VLOOKUP($D6,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F6","v":60}]
[59014244,{"$f":"VLOOKUP(A7,'Article Reference'!$A$2:$C$56,2,FALSE)","v":"New Innovation Cube"},"Lexicon",59013840,"5901424459013840",3,"4x 21 oz",12,1879.08,5637.24,{"$f":"VLOOKUP($D7,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F7","v":17.04},{"$f":"VLOOKUP($D7,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F7","v":14.52}]
[59014244,{"$f":"VLOOKUP(A8,'Article Reference'!$A$2:$C$56,2,FALSE)","v":"New Innovation Cube"},"Xzemplar",59014120,"5901424459014120",3,"4 x 11.4 oz",12,788.66,2365.98,{"$f":"VLOOKUP($D8,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F8","v":19.799999999999997},{"$f":"VLOOKUP($D8,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F8","v":15}]
[59014396,"Greens Foundation Cube","Lexicon",59013840,"5901439659013840",1,"4x 21 oz",4,1879.08,1879.08,{"$f":"VLOOKUP($D9,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F9","v":5.68},{"$f":"VLOOKUP($D9,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F9","v":4.84}]
[59014396,"Greens Foundation Cube","Insignia SC",59014134,"5901439659014134",2,"4 x30.5 oz",8,1651.88,3303.76,{"$f":"VLOOKUP($D10,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F10","v":14},{"$f":"VLOOKUP($D10,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F10","v":11}]
[59014396,"Greens Foundation Cube","Trinity",59011038,"5901439659011038",1,"2x 2.5 gal",15,963.89,963.89,{"$f":"VLOOKUP($D11,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F11","v":29.4},{"$f":"VLOOKUP($D11,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F11","v":18.3}]
[59014397,"More Resilience II Cube","Lexicon",59013840,"5901439759013840",3,"4x 21 oz",12,3052.92,1879.08,5637.24,{"$f":"VLOOKUP($D12,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F12","v":14.52}]
[59014397,"More Resilience II Cube","Xzemplar",59013833,"5901439759013833",2,"2 x114 oz",40,6247.5,3428.76,6857.52,{"$f":"VLOOKUP($D13,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F13","v":49.9}]
[59014397,"More Resilience II Cube","Emerald",59012825,"5901439759012825",1,"50 x .49 lb.",50,1100.55,6636.81,6636.81,{"$f":"VLOOKUP($D14,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F14","v":60}]
[59014397,"More Resilience II Cube","Trinity",59011038,"5901439759011038",2,"2x 2.5 gal",30,11340,963.89,1927.78,{"$f":"VLOOKUP($D15,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F15","v":36.6}]
[59014397,"More Resilience II Cube","Honor",59012885,"5901439759012885",3,"36 lbs",36,1689.24,3780,11340,{"$f":"VLOOKUP($D16,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F16","v":54}]
[59014232,{"$f":"VLOOKUP(A17,'Article Reference'!$A$2:$C$56,2,FALSE)","v":"Plant Health Cube"},"Lexicon",59013840,"5901423259013840",3,"4x 21 oz",12,1879.08,5637.24,{"$f":"VLOOKUP($D17,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F17","v":17.04},{"$f":"VLOOKUP($D17,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F17","v":14.52}]
[59014232,{"$f":"VLOOKUP(A18,'Article Reference'!$A$2:$C$56,2,FALSE)","v":"Plant Health Cube"},"Honor",59012885,"5901423259012885",1,"36 lbs",12,3780,3780,{"$f":"VLOOKUP($D18,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F18","v":24},{"$f":"VLOOKUP($D18,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F18","v":18}]
[59014398,"Fairway Building Block Cube","Xzemplar",59013833,"5901439859013833",1,"2 x114 oz",20,3428.76,3428.76,{"$f":"VLOOKUP($D19,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F19","v":32.799999999999997},{"$f":"VLOOKUP($D19,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F19","v":24.95}]
[59014398,"Fairway Building Block Cube","Emerald",59021463,"5901439859021463",2,"10 x .49 lbs.",20,1524.29,3048.58,{"$f":"VLOOKUP($D20,'Coverage Reference'!$B$4:$G$15,4,FALSE)*F20","v":27.8},{"$f":"VLOOKUP($D20,'Coverage Reference'!$B$4:$G$15,5,FALSE)*F20","v":24}]