{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["2024 ORN-EOP-CALCULATOR","PRINTABLE SUMMARY","Pricing","Dropdowns"],"not_rendered":{"charts":0,"images":11,"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":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":false,"merged":[[55,1,55,3],[56,1,56,3],[64,8,65,14],[63,1,63,4],[59,1,59,3],[57,1,57,3],[58,1,58,3],[60,1,60,3],[61,1,61,3],[15,1,15,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[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],[24,17,25,17],[1,1,1,5],[24,10,25,10],[24,11,26,11],[27,2,29,2],[24,9,25,9],[27,1,29,1],[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],[21,2,21,3],[14,1,14,3],[16,2,16,3],[54,1,54,3],[53,1,53,3],[42,1,44,1],[36,1,38,1],[20,12,21,12],[30,2,32,2],[42,2,44,2],[30,1,32,1],[46,10,47,10],[46,2,47,2],[20,2,20,3],[51,1,51,4],[24,7,26,7]]}
[null,null,null,null,null,null,null,{"$f":"O14","v":"Ornamental EOP Calculator - version 2024-0009-0010"}]
[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-0009-0010"]
[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-0009-0010"}]
[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,"TOTAL PURCHASE REBATE"]
[null,"NAME YOUR DRAFT ORDER HERE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMUM QTY","MAXIMUM QTY","REBATE %"]
[null,"Description: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5000,24999,0.02]
[null,"Dist/DSR: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADMIN COLUMNS",null,null,null,null,null,null,25000,49999,0.03]
[null,"MER#: ",null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,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\n(must be a minimum of  $5,000\n to receive rebates)","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,"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,"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 \nTotal 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 % \nTotal 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":[[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],[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],[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":" \"Ornamental EOP Calculator - version \" & '2024 ORN-EOP-CALCULATOR'!O5","v":"Ornamental EOP Calculator - version 2024-0009-0010"}]
[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"]