{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["2024 ORN-EOP-CALCULATOR","PRINTABLE SUMMARY","Pricing","Dropdowns"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":14,"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":"2024 ORN-EOP-CALCULATOR","index":0,"n_rows":63,"n_cols":28,"rows_kept":63,"cut":false,"hidden":false,"merged":[[42,1,44,1],[36,1,38,1],[20,12,21,12],[1,1,1,5],[14,7,14,8],[24,10,25,10],[24,11,26,11],[27,2,29,2],[30,2,32,2],[24,9,25,9],[42,2,44,2],[30,1,32,1],[27,1,29,1],[54,1,54,3],[53,1,53,3],[24,7,26,7],[24,8,26,8],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,6,26,6],[24,5,26,5],[51,1,51,4],[39,1,41,1],[39,2,41,2],[36,2,38,2],[33,2,35,2],[33,1,35,1],[24,27,26,27],[24,25,26,25],[24,24,25,24],[24,12,26,12],[24,23,25,23],[24,18,25,18],[24,19,25,19],[24,20,25,20],[24,21,25,21],[24,22,25,22],[24,26,26,26],[62,1,62,4],[59,1,59,3],[57,1,57,3],[58,1,58,3],[60,1,60,3],[61,1,61,3],[50,8,52,14],[53,8,62,14],[24,17,25,17],[21,2,21,3],[0,8,0,9],[46,10,47,10],[46,2,47,2],[14,10,14,14],[20,2,20,3],[14,1,14,3],[16,2,16,3],[15,1,15,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[22,9,23,10]]}
[null,null,null,null,null,null,null,null,{"$f":" \"version \" & O5","v":"version 2024-0008-0014"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-0008-0014"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-0008-0009"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" \"Ornamental EOP Calculator - version \" & O5","v":"Ornamental EOP Calculator - version 2024-0008-0014"}]
[null,null,null,null,null,null,null,"MULTI-BRAND REBATE",null,null,"PURCHASE TIER REBATE*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL PURCHASE REBATE"]
[null,"NAME YOUR DRAFT ORDER HERE:",null,null,null,null,null,"QUALIFYING BRAND PURCHASES","MULTI-BRAND REBATE**†",null,"MINIMUM","MAXIMUM","BASE INCENTIVE†","SEPTEMBER BONUS","BASE + BONUS†",null,null,null,null,null,null,null,null,null,null,"MINIMUM QTY","MAXIMUM QTY","REBATE %"]
[null,"Description: ",null,null,null,null,null,3,0.02,null,5000,24999,0.02,0.01,0.03,null,null,null,null,null,null,null,null,null,null,5000,24999,0.02]
[null,"Dist/DSR: ",null,null,null,null,null,4,0.03,null,25000,49999,0.03,0.01,0.04,null,null,null,"ADMIN COLUMNS",null,null,null,null,null,null,25000,49999,0.03]
[null,"MER#: ",null,null,null,null,null,5,0.04,null,50000,999999.99,0.04,0.01,0.05,null,null,null,null,null,null,null,null,null,null,50000,999999.99,0.04]
[null,"Last Updated: "]
[null,"Created For: ",null,null,null,null,null,null,null,null,null,null,"Count Sept. Bonus?"]
[null,"Region","National"]
[null,null,null,null,null,"HIDE",null,null,null,"Invoice subtotal must be a minimum of  $5,000\n to receive rebates",null,null,"Yes",null,null,null,null,"HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI-BRAND REBATE",null,null,null,null,null,null,null,"PURCHASE TIER REBATE"]
[null,"MULTI-BRAND REBATE REQUIREMENT","PRODUCT NAME","VOLUME BREAKS","# UNITS","INSEASON PRICE","INSEASON SUBTOTAL","PRICE/\nUNIT*","INVOICE SUBTOTAL","MULTI-BRAND REBATE**†","PURCHASE TIER REBATE**†","NET PRICE/UNIT (all rebates, incl. purchase tier)","TOTAL AFTER REBATE",null,null,null,null,"Altus","Broadform","Kontos","Marengo FLO","Marengo G","Savate","Qualifying Brands","Rebate ","Sept. Bonus","Purchase Tier Rebate","Total must be > $5000 to qualify for rebates"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Y27","v":0},{"$f":"IF(AND(AB49>=5000,M23=\"Yes\"),AA49+0.01,IF(AB49>=5000,AA49,0))","v":0},null,null,null,null,null,null,16,16,12,8,40,12,{"$f":"AVERAGE(X28:X45)","v":0},{"$f":"MAX(Y28:Y45)","v":0}]
["Altus (64 fl.oz. bottle), 1-15","16 Bottles","Altus® (64 fl.oz. bottle)","1-15 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A28,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":428.4},{"$f":"IF(E28*F28= 0,\"\",E28*F28)","v":""},{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A28,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":428.4},{"$f":"IF(E28*H28= 0,\"\",E28*H28)","v":""},{"$f":"IF(E28*Y28= 0,0,I28*Y28)","v":0},{"$f":"IF(OR(G28 =\"\",Z28+AA28=0),0,E28*H28*(Z28+AA28))","v":0},{"$f":"IF(AND(E28<>\"\",E28>0),((I28/E28)-((J28+K28)/E28)),\"\")","v":""},{"$f":"IF(AND(E28<>\"\",E28>0), E28*L28,\"\")","v":""},null,null,null,null,{"$f":"IF(($E$28+$E$29+$E$30)>=$R$27,\"Yes\",\"No\")","v":"No"},{"$f":"IF(($E$31+$E$32+$E$33)>=$S$27,\"Yes\",\"No\")","v":"No"},{"$f":"IF(($E$34+$E$35+$E$36)>=$T$27,\"Yes\",\"No\")","v":"No"},{"$f":"IF(($E$37+$E$38+$E$39)>=$U$27,\"Yes\",\"No\")","v":"No"},{"$f":"IF(($E$40+$E$41+$E$42)>=$V$27,\"Yes\",\"No\")","v":"No"},{"$f":"IF(($E$43+$E$44+$E$45)>=$W$27,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF(R28:W28,\"Yes\")","v":0},{"$f":"IF(R28=\"No\",0,IF(X28>=5,0.04,IF(X28=4,0.03,IF(X28=3,0.02,0))))","v":0},{"$f":"IF(AND(E28 <>\"\",AB$49>=5000,$M$23=\"Yes\"),0.01,0)","v":0},{"$f":"IF(E28 <>\"\", AA$49,0)","v":0},{"$f":"IF(E28 = \"\",0,H28*E28)","v":0}]
["Altus (64 fl.oz. bottle), 16-31",null,null,"16-31 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A29,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":428.4},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A29,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":406.98},{"$f":"IF(E29*H29= 0,\"\",E29*H29)","v":""},{"$f":"IF(E29*Y29= 0,0,I29*Y29)","v":0},0,{"$f":"IF(AND(E29<>\"\",E29>0),((I29/E29)-((J29+K29)/E29)),\"\")","v":""},{"$f":"IF(AND(E29<>\"\",E29>0), E29*L29,\"\")","v":""},null,null,null,null,{"$f":"IF(($E$28+$E$29+$E$30)>=$R$27,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No",0,{"$f":"IF(R29=\"No\",0,IF(X29>=5,0.04,IF(X29=4,0.03,IF(X29=3,0.02,0))))","v":0},0,0,0]
["Altus (64 fl.oz. bottle), 32+",null,null,"32+ bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A30,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":428.4},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A30,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":385.56},"",0,0,"","",null,null,null,null,{"$f":"IF(($E$28+$E$29+$E$30)>=$R$27,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No",0,0,0,0,0]
["Broadform (12 fl. oz. bottle), 1-15","16 Bottles","Broadform® (12 fl. oz. bottle)","1-15 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A31,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":247.2},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A31,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":247.2},"",0,0,"","",null,null,null,null,{"$f":"IF(($E$28+$E$29+$E$30)>=$R$27,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No",0,{"$f":"IF(S31=\"No\",0,IF(X31>=5,0.04,IF(X31=4,0.03,IF(X31=3,0.02,0))))","v":0},0,0,0]
["Broadform (12 fl. oz. bottle), 16-31",null,null,"16-31 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A32,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":247.2},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A32,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":234.84},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(S32=\"No\",0,IF(X32>=5,0.04,IF(X32=4,0.03,IF(X32=3,0.02,0))))","v":0},0,0,0]
["Broadform (12 fl. oz. bottle), 32+",null,null,"32+ bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A33,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":247.2},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A33,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":222.48},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,0,0,0,0]
["Kontos (250 ml. bottle), 1-11","12 Bottles","Kontos® (250 ml. bottle)","1-11 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A34,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":221.6},{"$f":"IF(E34*F34= 0,\"\",E34*F34)","v":""},{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A34,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":221.6},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(T34=\"No\",0,IF(X34>=5,0.04,IF(X34=4,0.03,IF(X34=3,0.02,0))))","v":0},0,0,0]
["Kontos (250 ml. bottle), 12-29",null,null,"12-29 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A35,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":221.6},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A35,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":210.52},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(T35=\"No\",0,IF(X35>=5,0.04,IF(X35=4,0.03,IF(X35=3,0.02,0))))","v":0},0,0,0]
["Kontos (250 ml. bottle), 30+",null,null,"30+ bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A36,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":221.6},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A36,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":199.44},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,0,0,0,0]
["Marengo FLO (64 fl.oz. bottle), 1-3","8 Bottles","Marengo® FLO (64 fl.oz. bottle)","1-3 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A37,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":1134},{"$f":"IF(E37*F37= 0,\"\",E37*F37)","v":""},{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A37,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":1134},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(U37=\"No\",0,IF(X37>=5,0.04,IF(X37=4,0.03,IF(X37=3,0.02,0))))","v":0},0,0,0]
["Marengo FLO (64 fl.oz. bottle), 4-15",null,null,"4-15 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A38,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":1134},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A38,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":1077.3},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(U38=\"No\",0,IF(X38>=5,0.04,IF(X38=4,0.03,IF(X38=3,0.02,0))))","v":0},0,0,0]
["Marengo FLO (64 fl.oz. bottle), 16+",null,null,"16+ bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A39,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":1134},{"$f":"IF(E39*F39= 0,\"\",E39*F39)","v":""},{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A39,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":1020.6},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,0,0,0,0]
["Marengo G (50 lb. bag), 1-39","40 Bags","Marengo® G (50 lb. bag)","1-39 bags",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A40,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":124},{"$f":"IF(E40*F40= 0,\"\",E40*F40)","v":""},{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A40,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":124},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(V40=\"No\",0,IF(X40>=5,0.04,IF(X40=4,0.03,IF(X40=3,0.02,0))))","v":0},0,0,0]
["Marengo G (50 lb. bag), 40-119",null,null,"40-119 bags",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A41,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":124},{"$f":"IF(E41*F41= 0,\"\",E41*F41)","v":""},{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A41,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":117.8},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(V41=\"No\",0,IF(X41>=5,0.04,IF(X41=4,0.03,IF(X41=3,0.02,0))))","v":0},0,0,0]
["Marengo G (50 lb. bag), 120+",null,null,"120+ bags",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A42,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":124},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A42,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":111.6},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,0,0,0,0]
["Savate (8 fl.oz. bottle), 1-11","12 Bottles","Savate® (8 fl.oz. bottle)","1-11 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A43,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":380.8},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A43,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":380.8},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(W43=\"No\",0,IF(X43>=5,0.04,IF(X43=4,0.03,IF(X43=3,0.02,0))))","v":0},0,0,0]
["Savate (8 fl.oz. bottle), 12-29",null,null,"12-29 bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A44,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":380.8},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A44,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":361.76},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,{"$f":"IF(W44=\"No\",0,IF(X44>=5,0.04,IF(X44=4,0.03,IF(X44=3,0.02,0))))","v":0},0,0,0]
["Savate (8 fl.oz. bottle), 30+",null,null,"30+ bottles",null,{"$f":"INDEX(Pricing!$G$4:$I$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A45,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$G$3:$I$3,0))","v":380.8},"",{"$f":"INDEX(Pricing!$A$4:$F$21,MATCH('2024 ORN-EOP-CALCULATOR'!$A45,Pricing!$A$4:$A$21,0),MATCH('2024 ORN-EOP-CALCULATOR'!$C$22,Pricing!$A$3:$F$3,0))","v":342.72},"",0,0,"","",null,null,null,null,"No","No","No","No","No","No",0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G28:G45)","v":0},null,{"$f":"SUM(I28:I45)","v":0},{"$f":"SUM(J28:J45)","v":0},{"$f":"SUM(K28:K45)","v":0},null,{"$f":"SUM(M28:M45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB$49=\"\",AB$49<=5000),0,(VLOOKUP(AB49,Z17:AB19,3)))","v":0},{"$f":"SUM(AB28:AB48)","v":0}]
[]
[null,"Summary",null,null,null,null,null,null,"ALWAYS READ AND FOLLOW LABEL INSTRUCTIONS. Environmental Science U.S. LLC, 5000 CentreGreen Way, Suite 400, Cary, NC 27513. Not all products are registered in all states. Envu, the Envu logo, Altus, Broadform, Kontos, Marengo, and Savate are trademarks owned by Environmental Science U.S. LLC or one of its affiliates. ©2024 Environmental Science U.S. LLC."]
[null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[null,"Total Before Off Invoice Volume Discounts",null,null,{"$f":"G46","v":0},null,null,null,"*Pricing for all states except CA or WA. Must be purchased on a single invoice to receive volume discount price. \n**Savings compared to 1 unit at the in-season National price. \n†Must be registered in My Envu Rewards and accept current Terms and Conditions to participate. \n\nCustomer Ornamentals promotional cumulative purchases (Sept. 1 - Nov. 15, 2024) must be $5,000 or more to qualify for rebates. New members signed up before Dec. 31, 2024, will receive Ornamentals EOP rebates. All rebates for the 2024 Ornamentals EOP will be paid in points, which can be redeemed for thousands of catalog items, distributor credits and/or company checks (no checks can be issued to a third party). All products must be invoiced between September 1 and November 15, 2024, to qualify. Rebate calculations will be based on the date of actual product invoice and calculator tools are provided for estimation purposes only. Rebates will only be paid or delivered to the company or name listed on the invoice. Please allow for rebates to be fulfilled by July 31, 2025. End users are only eligible for one Envu incentive program on these invoiced products. Must be an end user with MER membership and accept current Terms and Conditions. Golf and Lawn Care operators are not eligible for the Altus Multi-Brand rebate. Resale of product(s) purchased within this program will not qualify for rebates. If questions arise, please contact MER at 1-888-456-6464 or email info@myenvurewards.com. Envu reserves the right to modify any portion thereof, or discontinue this program without prior notice."]
[null,"Off Invoice Volume Discount",null,null,{"$f":"E54-E56","v":0}]
[null,"Ornamental EOP Invoice Total ",null,null,{"$f":"I46","v":0}]
[null,"Purchase Tier Level ",null,null,{"$f":"IF(AND(I46<>\"\",I46> 0),K27,0)","v":0}]
[null,"Rebate (Total Program Purchase must be a minimum of $5,000 to receive rebates)",null,null,{"$f":"IF(E57=0,0,SUM(J28:K45))","v":0}]
[null,"Net Total after Rebate",null,null,{"$f":"E56-E58","v":0}]
[null,"Rebate % (Total Program Purchase must be a minimum of $5,000 to receive rebates)",null,null,{"$f":"IF(AND(E58<>\"\",E58> 0), (E58/E56),0)","v":0}]
[null,"Total Savings (Rebates + Off Invoice Volume Discounts)",null,null,{"$f":"IF(AND(E56<>\"\",E56> 0),E54-E59,0)","v":0}]
[null,"Total Savings % (Rebates + Off Invoice Volume Discounts)",null,null,{"$f":"IF(AND(E54 <> \"\", E54 > 0), ((E54 - E56) + E58)/E54,0)","v":0}]
[null,{"$f":"CONCATENATE(\"Estimated MER points to be earned: \",TEXT(IF(AND(E58 <>\"\", E58 > 0),E58*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned: 0"}]

{"sheet":"PRINTABLE SUMMARY","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[28,1,30,1],[31,1,33,1],[34,1,36,1],[19,6,19,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[50,1,50,4],[52,1,52,5],[39,1,41,5],[42,1,42,4],[43,1,43,4],[44,1,44,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[45,1,45,4],[49,1,49,4],[8,1,8,7],[19,1,21,1],[22,1,24,1],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,2,12,7],[13,2,13,7],[14,2,14,7],[38,1,38,7],[35,6,35,7],[36,6,36,7],[18,6,18,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[20,6,20,7],[25,1,27,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":" \"Ornamental EOP Calculator - version \" & '2024 ORN-EOP-CALCULATOR'!O5","v":"Ornamental EOP Calculator - version 2024-0008-0014"}]
[null,{"$f":"'2024 ORN-EOP-CALCULATOR'!B16","v":"NAME YOUR DRAFT ORDER HERE:"}]
[null,"Description: ",{"$f":"IF('2024 ORN-EOP-CALCULATOR'!C17=\"\",\"\",'2024 ORN-EOP-CALCULATOR'!C17)","v":""}]
[null,"Distributor/DSR: ",{"$f":"IF('2024 ORN-EOP-CALCULATOR'!C18=\"\",\"\",'2024 ORN-EOP-CALCULATOR'!C18)","v":""}]
[null,"MER#: ",{"$f":"IF('2024 ORN-EOP-CALCULATOR'!C19=\"\",\"\",'2024 ORN-EOP-CALCULATOR'!C19)","v":""}]
[null,"Last Updated: ",{"$f":"IF('2024 ORN-EOP-CALCULATOR'!C20=\"\",\"\",'2024 ORN-EOP-CALCULATOR'!C20)","v":""}]
[null,"Created For: ",{"$f":"IF('2024 ORN-EOP-CALCULATOR'!C21=\"\",\"\",'2024 ORN-EOP-CALCULATOR'!C21)","v":""}]
[null,"Region:",{"$f":"'2024 ORN-EOP-CALCULATOR'!C22","v":"National"}]
[]
[]
[null,"AGENCY PRODUCTS"]
[null,"PRODUCT NAME","VOLUME BREAKS","# UNITS","PRICE/UNIT","SUBTOTAL","NET PRICE/UNIT"]
[null,"Altus® (64 fl.oz. jug)","1-15 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E28","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H28","v":428.4},{"$f":"'2024 ORN-EOP-CALCULATOR'!I28","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L28","v":""}]
[null,null,"16-31 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E29","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H29","v":406.98},{"$f":"'2024 ORN-EOP-CALCULATOR'!I29","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L29","v":""}]
[null,null,"32+ bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E30","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H30","v":385.56},{"$f":"'2024 ORN-EOP-CALCULATOR'!I30","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L30","v":""}]
[null,"Broadform® (12 fl. oz. bottle)","1-15 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E31","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H31","v":247.2},{"$f":"'2024 ORN-EOP-CALCULATOR'!I31","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L31","v":""}]
[null,null,"16-31 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E32","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H32","v":234.84},{"$f":"'2024 ORN-EOP-CALCULATOR'!I32","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L32","v":""}]
[null,null,"32+ bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E33","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H33","v":222.48},{"$f":"'2024 ORN-EOP-CALCULATOR'!I33","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L33","v":""}]
[null,"Kontos® (250 ml. bottle)","1-11 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E34","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H34","v":221.6},{"$f":"'2024 ORN-EOP-CALCULATOR'!I34","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L34","v":""}]
[null,null,"12-29 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E35","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H35","v":210.52},{"$f":"'2024 ORN-EOP-CALCULATOR'!I35","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L35","v":""}]
[null,null,"30+ bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E36","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H36","v":199.44},{"$f":"'2024 ORN-EOP-CALCULATOR'!I36","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L36","v":""}]
[null,"Marengo® FLO (64 fl.oz. jug)","1-3 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E37","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H37","v":1134},{"$f":"'2024 ORN-EOP-CALCULATOR'!I37","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L37","v":""}]
[null,null,"4-15 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E38","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H38","v":1077.3},{"$f":"'2024 ORN-EOP-CALCULATOR'!I38","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L38","v":""}]
[null,null,"16+ bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E39","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H39","v":1020.6},{"$f":"'2024 ORN-EOP-CALCULATOR'!I39","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L39","v":""}]
[null,"Marengo® G (50 lb. bag)","1-39 bags",{"$f":"'2024 ORN-EOP-CALCULATOR'!E40","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H40","v":124},{"$f":"'2024 ORN-EOP-CALCULATOR'!I40","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L40","v":""}]
[null,null,"40-119 bags",{"$f":"'2024 ORN-EOP-CALCULATOR'!E41","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H41","v":117.8},{"$f":"'2024 ORN-EOP-CALCULATOR'!I41","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L41","v":""}]
[null,null,"120+ bags",{"$f":"'2024 ORN-EOP-CALCULATOR'!E42","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H42","v":111.6},{"$f":"'2024 ORN-EOP-CALCULATOR'!I42","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L42","v":""}]
[null,"Savate® (8 fl.oz. bottle)","1-11 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E43","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H43","v":380.8},{"$f":"'2024 ORN-EOP-CALCULATOR'!I43","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L43","v":""}]
[null,null,"12-29 bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E44","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H44","v":361.76},{"$f":"'2024 ORN-EOP-CALCULATOR'!I44","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L44","v":""}]
[null,null,"30+ bottles",{"$f":"'2024 ORN-EOP-CALCULATOR'!E45","v":0},{"$f":"'2024 ORN-EOP-CALCULATOR'!H45","v":342.72},{"$f":"'2024 ORN-EOP-CALCULATOR'!I45","v":""},{"$f":"'2024 ORN-EOP-CALCULATOR'!L45","v":""}]
[null,null,null,null,null,{"$f":"SUM(F20:F37)","v":0}]
[null,"Summary"]
[null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[]
[null,"Total Before Off Invoice Discounts",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E54","v":0}]
[null,"Off Invoice Volume Discount",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E55","v":0}]
[null,"Ornamental EOP Total",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E56","v":0}]
[null,"Purchase Tier Level ",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E57","v":0}]
[null,"Rebate (Total Program Purchase must be a min of $5K to receive rebates)",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E58","v":0}]
[null,"Net Total after Rebates",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E59","v":0}]
[null,"Rebate % (Total Program Purchase must be a min of $5K to receive rebates)",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E60","v":0}]
[null,"Total Savings  (Rebates + Off Invoice Discounts)",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E61","v":0}]
[null,"Total Savings % (Rebates + Off Invoice Discounts)",null,null,null,{"$f":"'2024 ORN-EOP-CALCULATOR'!E62","v":0}]
[]
[null,{"$f":"CONCATENATE(\"Estimated MER points to be earned in the Product Cart: \",TEXT(IF(AND(F47 <>\"\", F47 > 0),F47*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned in the Product Cart: 0"}]

{"sheet":"Pricing","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,6,1,8]]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9]
[null,null,null,null,null,null,"In Season Price"]
[null,null,null,"National","CA","WA","National","CA","WA"]
["Altus (64 fl.oz. bottle), 1-15","Altus (64 fl.oz. bottle)","1-15",428.4,439.22,431.4,428.4,439.22,431.4]
["Altus (64 fl.oz. bottle), 16-31","Altus (64 fl.oz. bottle)","16-31",406.98,417.26,409.82,428.4,439.22,431.4]
["Altus (64 fl.oz. bottle), 32+","Altus (64 fl.oz. bottle)","32+",385.56,395.3,388.26,428.4,439.22,431.4]
["Broadform (12 fl. oz. bottle), 1-15","Broadform (12 fl. oz. bottle)","1-15",247.2,253.44,248.94,247.2,253.44,248.94]
["Broadform (12 fl. oz. bottle), 16-31","Broadform (12 fl. oz. bottle)","16-31",234.84,240.76,236.48,247.2,253.44,248.94]
["Broadform (12 fl. oz. bottle), 32+","Broadform (12 fl. oz. bottle)","32+",222.48,228.1,224.05,247.2,253.44,248.94]
["Kontos (250 ml. bottle), 1-11","Kontos (250 ml. bottle)","1-11",221.6,227.2,223.16,221.6,227.2,223.16]
["Kontos (250 ml. bottle), 12-29","Kontos (250 ml. bottle)","12-29",210.52,215.83999999999997,212.00199999999998,221.6,227.2,223.16]
["Kontos (250 ml. bottle), 30+","Kontos (250 ml. bottle)","30+",199.44,204.48,200.84,221.6,227.2,223.16]
["Marengo FLO (64 fl.oz. bottle), 1-3","Marengo FLO (64 fl.oz. bottle)","1-3",1134,1162.6400000000001,1141.94,1134,1162.6400000000001,1141.94]
["Marengo FLO (64 fl.oz. bottle), 4-15","Marengo FLO (64 fl.oz. bottle)","4-15",1077.3,1104.5,1084.8399999999999,1134,1162.6400000000001,1141.94]
["Marengo FLO (64 fl.oz. bottle), 16+","Marengo FLO (64 fl.oz. bottle)","16+",1020.6,1046.3800000000001,1027.74,1134,1162.6400000000001,1141.94]
["Marengo G (50 lb. bag), 1-39","Marengo G (50 lb. bag)","1-39",124,127,125,124,127,125]
["Marengo G (50 lb. bag), 40-119","Marengo G (50 lb. bag)","40-119",117.8,121,119,124,127,125]
["Marengo G (50 lb. bag), 120+","Marengo G (50 lb. bag)","120+",111.6,114,112,124,127,125]
["Savate (8 fl.oz. bottle), 1-11","Savate (8 fl.oz. bottle)","1-11",380.8,390.42,383.46,380.8,390.42,383.46]
["Savate (8 fl.oz. bottle), 12-29","Savate (8 fl.oz. bottle)","12-29",361.76,370.9,364.3,380.8,390.42,383.46]
["Savate (8 fl.oz. bottle), 30+","Savate (8 fl.oz. bottle)","30+",342.72,351.37,345.11,380.8,390.42,383.46]

{"sheet":"Dropdowns","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Yes","CA"]
["No","WA"]
[null,"National"]