{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["2019 EOP Planning Tool"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"2019 EOP Planning Tool","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"merged":[[1,6,1,13],[2,1,2,8],[2,9,2,13],[3,2,3,3],[3,5,3,6],[3,9,3,10],[9,1,10,1],[9,8,10,8],[9,12,10,12],[13,1,14,1],[13,8,14,8],[13,12,14,12],[17,1,18,1],[17,8,18,8],[17,12,18,12],[19,1,21,1],[19,8,21,8],[19,12,21,12],[23,1,24,1],[23,8,24,8],[23,12,24,12],[25,1,26,1],[25,8,26,8],[25,12,26,12],[27,1,28,1],[27,8,28,8],[27,12,28,12],[30,1,30,8],[31,1,31,8],[33,4,33,13],[34,4,34,5],[34,7,34,9],[34,10,34,12],[35,6,36,6],[35,7,35,9],[35,10,36,10],[35,12,36,12],[36,2,36,3],[36,7,36,9],[37,4,37,11],[38,4,38,13],[40,1,40,13],[41,1,41,13],[42,1,42,13],[43,1,43,13],[44,1,44,13],[45,1,45,13]]}
[]
[]
[null,"2019 END-USER EARLY ORDER PROGRAM\nREBATE CALCULATOR & PLANNING TOOL",{"$nulls":7},"CALCULATE YOUR REBATE"]
[null,"PRODUCTS","UNIT SIZE",null,"MINIMUM \nUNIT QTY*","PERIOD 1\nOCT. 1 – 31",null,"UNIT QTY",null,"PERIOD 2\nNOV. 1 – DEC. 13",null,"UNIT QTY",null,"TOTAL\nREBATE"]
[null,"FUNGICIDES"]
[null,"Pedigree™\nFungicide SC",2.5,"gal.","2 units",{"v":52.5,"d":"$52.50"},"x",0,"+",{"v":30,"d":"$30.00"},"x",0,"=",{"$f":"IF((H6+L6)>=2, IF(H6>=2,(F6*H6+J6*L6),(J6*(H6+L6))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"Segway®\nFungicide SC",39.2,"fl. oz.","4 units",{"v":29.1,"d":"$29.10"},"x",0,"+",{"v":12.5,"d":"$12.50"},"x",0,"=",{"$f":"IF((H7+L7)>=4, IF(H7>=4,(F7*H7+J7*L7),(J7*(H7+L7))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"Tekken™\nBroad Spectrum Fungicide",2.5,"gal.","2 units",{"v":23.1,"d":"$23.10"},"x",0,"+",{"v":13.2,"d":"$13.20"},"x",0,"=",{"$f":"IF((H8+L8)>=2, IF(H8>=2,(F8*H8+J8*L8),(J8*(H8+L8))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"INSECTICIDES"]
[null,"Zylam® Liquid\nSystemic Insecticide",1,"gal.","2 units",{"v":35.3,"d":"$35.30"},"x",0,"+",{"v":17.7,"d":"$17.70"},"x",0,"=",{"$f":"IF((H10+L10)>=2, IF(H10>=2,(F10*H10+J10*L10),(J10*(H10+L10))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,null,1,"qt.","4 units",{"v":8.9,"d":"$8.90"},"x",0,null,{"v":4.3,"d":"$4.30"},"x",0,null,{"$f":"IF((H11+L11)>=4, IF(H11>=4,(F11*H11+J11*L11),(J11*(H11+L11))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"GROWTH REGULATORS/HERBICIDES"]
[null,"Atrimmec®\nPlant Growth Regulator",1,"gal.","2 units",{"v":35.2,"d":"$35.20"},"x",0,"+",{"v":17.5,"d":"$17.50"},"x",0,"=",{"$f":"IF((H13+L13)>=2, IF(H13>=2,(F13*H13+J13*L13),(J13*(H13+L13))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"Avenue™ South\nBroadleaf Herbicide for Turfgrass",30,"gal.","1 unit",{"v":158.2,"d":"$158.20"},"x",0,"+",{"v":79.1,"d":"$79.10"},"x",0,"=",{"$f":"IF((H14+L14)>=1, IF(H14>=1,(F14*H14+J14*L14),(J14*(H14+L14))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,null,2.5,"gal.","2 units",{"v":11.4,"d":"$11.40"},"x",0,null,{"v":3.9,"d":"$3.90"},"x",0,null,{"$f":"IF((H15+L15)>=2, IF(H15>=2,(F15*H15+J15*L15),(J15*(H15+L15))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"Bensumec™ 4LF\nPre-Emergent Grass & Weed Herbicide",2.5,"gal.","2 units",{"v":10,"d":"$10.00"},"x",0,"+",{"v":5,"d":"$5.00"},"x",0,"=",{"$f":"IF((H16+L16)>=2, IF(H16>=2,(F16*H16+J16*L16),(J16*(H16+L16))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"Katana®\nTurf Herbicide",5,"oz.","4 units",{"v":15.6,"d":"$15.60"},"x",0,"+",{"v":7.8,"d":"$7.80"},"x",0,"=",{"$f":"IF((H17+L17)>=4, IF(H17>=4,(F17*H17+J17*L17),(J17*(H17+L17))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"Q4® Plus\nTurf Herbicide for Grassy & Broadleaf Weeds",30,"gal.","1 unit\n",{"v":177.4,"d":"$177.40"},"x",0,"+",{"v":88.7,"d":"$88.70"},"x",0,"=",{"$f":"IF((H18+L18)>=1, IF(H18>=1,(F18*H18+J18*L18),(J18*(H18+L18))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,null,2.5,"gal.","2 units",{"v":14.8,"d":"$14.80"},"x",0,null,{"v":7.4,"d":"$7.40"},"x",0,null,{"$f":"IF((H19+L19)>=2, IF(H19>=2,(F19*H19+J19*L19),(J19*(H19+L19))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"SpeedZone®\nBroadleaf Herbicide for Turf",275,"gal. tote","1 unit\n",{"v":887.1,"d":"$887.10"},"x",0,"+",{"v":443.6,"d":"$443.60"},"x",0,"=",{"$f":"IF((H20+L20)>=1, IF(H20>=1,(F20*H20+J20*L20),(J20*(H20+L20))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,null,30,"gal.","1 unit\n",{"v":96.8,"d":"$96.80"},"x",0,null,{"v":48.4,"d":"$48.40"},"x",0,null,{"v":0,"d":"$0.00"}]
[null,null,2.5,"gal.","2 units",{"v":8.1,"d":"$8.10"},"x",0,null,{"v":4.1,"d":"$4.10"},"x",0,null,{"$f":"IF((H22+L22)>=2, IF(H22>=2,(F22*H22+J22*L22),(J22*(H22+L22))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"SpeedZone® Southern\nBroadleaf Herbicide for Turf**",1,"gal.","4 units",{"v":3.1,"d":"$3.10"},"x",0,"+",{"v":1.6,"d":"$1.60"},"x",0,"=",{"$f":"IF((H23+L23)>=4, IF(H23>=4,(F23*H23+J23*L23),(J23*(H23+L23))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"SpeedZone® Southern EW\nBroadleaf Herbicide for Turf",30,"gal.","1 unit\n",{"v":84.1,"d":"$84.10"},"x",0,"+",{"v":42.1,"d":"$42.10"},"x",0,"=",{"$f":"IF((H24+L24)>=1, IF(H24>=1,(F24*H24+J24*L24),(J24*(H24+L24))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,null,2.5,"gal.","2 units",{"v":6.8,"d":"$6.80"},"x",0,null,{"v":3.4,"d":"$3.40"},"x",0,null,{"$f":"IF((H25+L25)>=2, IF(H25>=2,(F25*H25+J25*L25),(J25*(H25+L25))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"Surge®\nBroadleaf Herbicide for Turf",30,"gal.","1 unit\n",{"v":124.6,"d":"$124.60"},"x",0,"+",{"v":62.3,"d":"$62.30"},"x",0,"=",{"$f":"IF((H26+L26)>=1, IF(H26>=1,(F26*H26+J26*L26),(J26*(H26+L26))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,null,2.5,"gal.","2 units",{"v":10.2,"d":"$10.20"},"x",0,null,{"v":5.2,"d":"$5.20"},"x",0,null,{"$f":"IF((H27+L27)>=2, IF(H27>=2,(F27*H27+J27*L27),(J27*(H27+L27))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,"TZone™ SE\nBroadleaf Herbicide for Tough Weeds",30,"gal.","1 unit\n",{"v":171.6,"d":"$171.60"},"x",0,"+",{"v":69.7,"d":"$69.70"},"x",0,"=",{"$f":"IF((H28+L28)>=1, IF(H28>=1,(F28*H28+J28*L28),(J28*(H28+L28))), 0)","v":{"v":0,"d":"$0.00"}}]
[null,null,2.5,"gal.","2 units",{"v":10.6,"d":"$10.60"},"x",0,null,{"v":5.3,"d":"$5.30"},"x",0,null,{"$f":"IF((H29+L29)>=2, IF(H29>=2,(F29*H29+J29*L29),(J29*(H29+L29))), 0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},"TOTAL","=",{"$f":"IF(((SUM(N6:N29))>=100),(SUM(N6:N29)),\"$0.00\")","v":"$0.00"}]
[null,"*Orders below each unit minimum will not qualify for the rebate for that specific package size only. If you do not meet the minimum number of units for a specific package until Period 2, then your rebate for that specific package will be calculated based on the total number of units at the Period 2 unit rate.",{"$nulls":11},"TOTAL REBATE"]
[null,"** For use in California."]
[]
[{"$nulls":4},"BONUS BOOSTER"]
[{"$nulls":4},"Rebate Level",null,null,"Total Rebate",null,null,"Rebate Bonus*",null,null,"Bonus"]
[{"$nulls":4},"LEVEL I","$500–$999",null,{"$f":"IF(AND((SUM(N6:N29))>=500,((SUM(N6:N29))<1000)),(SUM(N6:N29)),\"–\")","v":"–"},null,null,"x",{"v":0.15,"d":"15%"},"=",{"$f":"IF(AND((SUM(N6:N29))>=500,(SUM(N6:N29))<=999.99),H36*0.15,\"\")","v":""}]
[null,1000,null,null,"LEVEL II","$1,000+",null,{"$f":"IF(((SUM(N6:N29))>=1000),(SUM(N6:N29)),\"–\")","v":"–"},{"$nulls":3},{"v":0.25,"d":"25%"},null,{"$f":"IF(((SUM(N6:N29))>1000),H37*0.25,\"\")","v":""}]
[{"$nulls":4},"GRAND TOTAL",{"$nulls":7},"=",{"$f":"N30+SUM(N36:N37)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"*Rebate bonus is calculated from the rebate amount. Example: If your rebate is $750, your rebate bonus will be $112.50 ($750 x 15%). Added together, your total rebate will be $862.50."]
[]
[null,"PLEASE NOTE:\nThis tool is for planning purposes only. Rebates will be issued based on actual purchase documentation. \nSee complete program write-up or visit EOP.PBIGordonTurf.com for additional details and requirements, submission instructions, and deadlines."]
[null,"Always read and follow label directions."]
[null,"Avenue™, Bensumec™, Tekken™, and TZone™ are trademarks, and Q4®, SpeedZone®, Surge®, and Zylam® are registered trademarks of PBI-Gordon Corporation."]
[null,"Pedigree™ is a trademark of Nichino America, Inc."]
[null,"Katana®, and Segway® are registered trademarks of Ishihara Sangyo Kaisha, LTD."]
[null,"08/19 05757"]