{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rebate Calculator","Program Overview"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Rebate Calculator","index":0,"n_rows":101,"n_cols":7,"rows_kept":101,"cut":false,"hidden":false,"merged":[[45,3,45,4],[39,1,39,2],[1,1,1,6],[23,1,23,4],[30,1,30,4],[23,5,23,6],[30,5,30,6],[3,2,4,2],[3,4,4,5],[5,1,5,6],[3,3,4,3],[44,1,44,2],[38,1,38,2],[38,3,38,4],[38,5,38,6],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[46,1,46,6],[2,1,2,6],[24,5,28,6],[31,5,36,6],[39,5,45,6],[3,1,4,1],[3,6,4,6],[22,1,22,6],[29,1,29,6],[45,1,45,2],[6,1,6,4],[37,1,37,6],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2]]}
[]
[null,"REBATE CALCULATOR"]
[]
[]
[]
[]
["     ","BULK BONUSES"]
[null,"SKU NUMBER","ITEM DESCRIPTION","BULK THRESHOLD","BULK BONUS PER UNIT","UNITS PURCHASED","TOTAL BONUS"]
[null,82004432,"BIFEN I/T (4 X 3/4 GAL)",192,0.4,{"$f":"_xlfn.XLOOKUP(B9,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},{"$f":"IF(F9>=D9,F9*E9,0)","v":0}]
[null,82004435,"BIFEN I/T (4X1 GAL) TIP & MEASURE",120,0.5,{"$f":"_xlfn.XLOOKUP(B10,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82004433,"BIFEN I/T 30 GAL (40 UNIT) DRUM",5,14.45,{"$f":"_xlfn.XLOOKUP(B11,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82004438,"BIFEN L/P 25LB (.2%)",1632,0.30000000000000004,{"$f":"_xlfn.XLOOKUP(B12,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},{"$f":"IF(F12>=D12,F12*E12,0)","v":0}]
[null,82002403,"CYZMIC CS (6X1 QT)",60,6,{"$f":"_xlfn.XLOOKUP(B13,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82002507,"DOMINION 2L (2X2.15 GAL)",72,3.0500000000000003,{"$f":"_xlfn.XLOOKUP(B14,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82002506,"DOMINION 2L (6X27.5 OZ)",480,0.35000000000000003,{"$f":"_xlfn.XLOOKUP(B15,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82995003,"DOMINION 2L 4X1 GALLON",192,1.1000000000000001,{"$f":"_xlfn.XLOOKUP(B16,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82690036,"DURAFLEX (6X1 QT)",240,1.25,{"$f":"_xlfn.XLOOKUP(B17,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82100008,"FUSE 4 X QUART",100,2,{"$f":"_xlfn.XLOOKUP(B18,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82300320,"TAURUS 9.1SC (2X2.5 GAL)",72,9.5500000000000007,{"$f":"_xlfn.XLOOKUP(B19,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82003598,"TAURUS 9.1SC (4X20 OZ)",702,0.60000000000000009,{"$f":"_xlfn.XLOOKUP(B20,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82003599,"TAURUS 9.1SC (4X78OZ)",180,2.4000000000000004,{"$f":"_xlfn.XLOOKUP(B21,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[null,82003596,"TAURUS 9.1 SC (4X20OZ) NEW YORK ONLY",702,0.6,{"$f":"_xlfn.XLOOKUP(B22,Table_Calculator[SKU NUMBER],Table_Calculator[UNITS PURCHASED])","v":0},0]
[]
[" ","INNOVATION INCENTIVE MULTIPLIERS"]
[null,"TIER","CRITERIA","MULTIPLIER","ACHIEVED"]
[null,"Tier 1","> 50% Innovative Products",1.2,{"$f":"IFERROR(IF(D42/D41>=0.5,\"YES\",\"NO\"),\"NO\")","v":"NO"}]
[null,"Tier 2","> 25% Innovative Products",1.1000000000000001,{"$f":"IFERROR(IF(D42/D41>=0.25,\"YES\",\"NO\"),\"NO\")","v":"NO"}]
[null,"Tier 3",">10% Innovative Products",1.05,{"$f":"IFERROR(IF(D42/D41>=0.1,\"YES\",\"NO\"),\"NO\")","v":"NO"}]
[null,"Base","< 10% Innovative Products",1,{"$f":"IFERROR(IF(D42/D41>=0,\"YES\",\"NO\"),\"YES\")","v":"YES"}]
[]
[null,"VOLUME INCENTIVE MULTIPLIERS"]
[" ","TIER","CRITERIA","MULTIPLIER","ACHIEVED"]
[null,"Tier 1","> $5,000 Earned",1.8,{"$f":"IF(D41>5000,\"YES\",\"NO\")","v":"NO"}]
[null,"Tier 2","> $2,000 Earned",1.6,{"$f":"IF(D41>2000,\"YES\",\"NO\")","v":"NO"}]
[null,"Tier 3","> $1,000 Earned",1.4,{"$f":"IF(D41>1000,\"YES\",\"NO\")","v":"NO"}]
[null,"Tier 4","> $200 Earned",1.2,{"$f":"IF(D41>200,\"YES\",\"NO\")","v":"NO"}]
[null,"Base","< $200 Earned",1,{"$f":"IF(D41>=0,\"YES\",\"NO\")","v":"YES"}]
[]
[null,"CALCULATED TOTAL REBATE",null,{"$f":"IF(D41>=200,D45+D46,0)","v":0}]
[null,"COMPONENT",null,"SUBTOTAL"]
[null,"Total Base Rebate",null,{"$f":"SUBTOTAL(9,Table_Calculator[BASE REBATE EARNED])","v":0}]
[null,"Base Rebate - Innovative Products",null,{"$f":"SUMIFS(Table_Calculator[BASE REBATE EARNED],Table_Calculator[INNOVATION],\"Yes\")","v":0}]
[null,"Innovation Multiplier",null,{"$f":"_xlfn.IFS(E26=\"YES\",D26,E27=\"YES\",D27,E28=\"YES\",D28,E29=\"YES\",D29)","v":1}]
[null,"Volume Multiplier",null,{"$f":"_xlfn.IFS(E33=\"YES\",D33,E34=\"YES\",D34,E35=\"YES\",D35,E36=\"YES\",D36,E37=\"YES\",D37)","v":1}]
[null,"Subtotal",null,{"$f":"IFERROR((D41*D43)*D44,0)","v":0}]
[null,"Bulk Bonuses",null,{"$f":"IF(D41>=200,SUM(Table_Bulk_Bonuses[TOTAL BONUS]),0)","v":0}]
[]
[null,"SKU NUMBER","ITEM DESCRIPTION","INNOVATION","BASE REBATE","UNITS PURCHASED","BASE REBATE EARNED"]
[null,82004432,"BIFEN I/T (4 X 3/4 GAL)","No",0.18,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82004435,"BIFEN I/T (4X1 GAL) TIP & MEASURE","No",0.25,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82004433,"BIFEN I/T 30 GAL (40 UNIT) DRUM","No",14.450000000000001,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82004438,"BIFEN L/P 25LB (.2%)","No",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82004443,"BIFEN XTS (4X1 GAL)","No",2.0500000000000003,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82004441,"BIFEN XTS (6X1 QT)","No",0.60000000000000009,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82031975,"CYONARA 9.7 (6X1 QT)","No",1.05,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82008300,"CYPER TC (4X1 GAL)","No",0.85000000000000009,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82008301,"CYPER TC 30 GALLON DRUM","No",24.75,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82300305,"CYPER WSP (6x1lb) Pail","No",0.9,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002403,"CYZMIC CS (6X1 QT)","No",2,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002401,"CYZMIC CS (12X8OZ)","No",0.4,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002479,"D-FENSE DUST (12X1 LB)","No",0.1,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002500,"D-FENSE NXT  AEROSOL (12 X 15oz.)","Yes",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002475,"D-FENSE SC (12X1 PINT)","No",0.55000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002478,"D-FENSE SC (4X1 GAL)","No",3.25,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002507,"DOMINION 2L (2X2.15 GAL)","No",3.0500000000000003,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002506,"DOMINION 2L (6X27.5 OZ)","No",0.35000000000000003,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82995003,"DOMINION 2L 4X1 GALLON","No",1.1000000000000001,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002491,"DOMINION PT (2 X 2.15 GALLON)","No",5.4,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82770012,"DOXEM NXT AE 12  X 15oz.","Yes",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82304500,"DOXEM REFILL 12 X (4 X 5 grams)","Yes",1.55,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82690036,"DURAFLEX (6X1 QT)","Yes",1.25,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82100009,"FUSE 128 oz. 2  X GALLON","Yes",8,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82100008,"FUSE 4 X QUART","Yes",2,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82250030,"FUSE COCKROACH GEL BAIT (1X33 GM)","Yes",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82770008,"FUSE FOAM (6 X 15 oz)","Yes",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82250043,"KLEER 76 (30 GAL DRUM)","Yes",78.5,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002492,"MOSQUITO MIST ULTRA (6 X Quart)","Yes",0.60000000000000009,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82300306,"MOSQUITO MIST ULTRA 4 X 1 GAL","Yes",2.0500000000000003,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82994503,"PERMETHRIN 10% EC (4X1 GAL)","No",0.8,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82004509,"PERMETHRIN SFR 4 X 1GAL","No",1.2000000000000002,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82250028,"PERMETHRIN SFR (NEW REG) 4 X 1GAL","No",1.2000000000000002,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82250011,"PIVOT 10 (6 X 1 PINT)","No",2,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82770006,"PIVOT ULTRA PLUS (NEW) 12 X 15OZ. Aerosol","No",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82300329,"PROFLEX CS (6X1 QT)","Yes",1.9500000000000002,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82300319,"SPECTRE 2SC (6X15 OZ)","No",0.5,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82770001,"SPECTRE PS 12 X 15 oz. AEROSOL","No",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82250045,"PDS KIT (GUN & HOLSTER) ","Yes",2.6,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82100100,"STRYKER 6-60 (6 X 1 PT)","No",0.95000000000000007,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82770003,"STRYKER 54 12  X 15oz. AEROSOL","No",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82002495,"STRYKER WASP AND HORNET AEROSOL 12  X 15OZ","No",0.15000000000000002,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82300320,"TAURUS 9.1SC (2X2.5 GAL)","No",9.5500000000000007,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82003598,"TAURUS 9.1SC (4X20 OZ)","No",0.60000000000000009,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82003599,"TAURUS 9.1SC (4X78OZ)","No",2.4000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82003596,"TAURUS 9.1 SC (4X20OZ) NEW YORK ONLY","No",0.60000000000000009,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82304505,"TAURUS DRY REFILL (4X3) GRAMS","Yes",2.5500000000000003,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82100005,"TEKKO PRO (6X1 PT)","Yes",0.75,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82690035,"TEKKO TRIO CONCENTRATE (6X1 PT)","Yes",2.15,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82770009,"TEKKO TRIO FOAM 12X15oz. AEROSOL","Yes",0.30000000000000004,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82003254,"VECTOR BAN PLUS (6X1/2 GAL)","No",0.95000000000000007,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82250036,"VECTOR KLEER (4X1 GAL)","Yes",2.75,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]
[null,82250037,"VECTOR KLEER (30 GAL DRUM)","Yes",78.5,null,{"$f":"Table_Calculator[[#This Row],[BASE REBATE]]*Table_Calculator[[#This Row],[UNITS PURCHASED]]","v":0}]

{"sheet":"Program Overview","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}