{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["2025 ORNAMENTALS - UNITS","SUMMARY - UNITS (2025)","REBATE MATRIX (NOW)","2025 NOW_EOP_LL"],"not_rendered":{"images":2,"macros":1,"defined_names":19,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"2025 ORNAMENTALS - UNITS","index":0,"n_rows":60,"n_cols":34,"rows_kept":60,"merged":[[0,6,0,12],[3,5,3,6],[11,13,12,14],[13,0,15,0],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,5,15,5],[13,6,15,6],[13,7,15,7],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[13,13,14,13],[13,14,14,14],[13,15,15,15],[13,16,15,16],[16,2,18,2],[16,3,18,3],[16,6,18,6],[19,2,21,2],[19,3,21,3],[19,6,21,6],[22,2,24,2],[22,3,24,3],[22,6,24,6],[25,2,27,2],[25,3,27,3],[25,6,27,6],[28,2,30,2],[28,3,30,3],[28,6,30,6],[31,2,33,2],[31,3,33,3],[31,6,33,6],[47,5,47,8],[47,11,59,16],[49,5,49,6],[49,7,49,8],[50,5,50,6],[50,7,50,8],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,6],[56,5,56,6],[57,5,57,6],[57,7,57,8],[59,5,59,8]]}
[{"$nulls":6},"         NATIONAL 2025 ORNAMENTALS SOLUTIONS CALCULATOR                  "]
[]
[{"$nulls":10},"AGENCY MULTI-BRAND REBATE",null,null,"PURCHASE TIER REBATE",{"$nulls":19},"National"]
[{"$nulls":5},"NAME YOUR DRAFT ORDER HERE:",{"$nulls":4},"QUALIFYING BRAND PURCHASES","MULTI-BRAND REBATE**†",null,"MINIMUM","MAXIMUM","BASE INCENTIVE†","SEPTEMBER BONUS","BASE + BONUS†",{"$nulls":14},"Yes","CA"]
[{"$nulls":5},"Description: ",{"$nulls":4},3,{"v":0.02,"d":"2%"},{"$f":"K5=$D$35","v":false},{"v":5000,"d":"$ 5,000"},{"v":19999,"d":"$ 19,999"},{"v":0.02,"d":"2%"},{"v":0.01,"d":"1%"},{"v":0.03,"d":"3%"},{"$f":"AND($T$5>=N5,$T$5<N6)","v":false},{"$f":"M35+SUM(M40:M44)","v":{"v":0,"d":"0.00"}},{"$nulls":12},"No","WA"]
[{"$nulls":5},"Dist/DSR: ",{"$nulls":4},4,{"v":0.03,"d":"3%"},{"$f":"K6=$D$35","v":false},{"v":20000,"d":"$ 20,000"},{"v":39999,"d":"$ 39,999"},{"v":0.03,"d":"3%"},{"v":0.01,"d":"1%"},{"v":0.04,"d":"4%"},{"$f":"AND($T$5>=N6,$T$5<N7)","v":false}]
[{"$nulls":5},"MER#: ",{"$nulls":4},5,{"v":0.04,"d":"4%"},{"$f":"K7<=$D$35","v":false},{"v":40000,"d":"$ 40,000"},{"v":74999,"d":"$ 74,999"},{"v":0.04,"d":"4%"},{"v":0.01,"d":"1%"},{"v":0.05,"d":"5%"},{"$f":"AND($T$5>=N7,$T$5<N8)","v":false}]
[{"$nulls":5},"Last Updated: ",{"$nulls":7},{"v":75000,"d":"$ 75,000"},{"v":1000000,"d":"$ 1,000,000"},{"v":0.05,"d":"5%"},{"v":0.01,"d":"1%"},{"v":0.06,"d":"6%"},{"$f":"AND($T$5>=N8)","v":false}]
[{"$nulls":5},"Created For: "]
[{"$nulls":5},"Region:","National",{"$nulls":6},"Count Sept. Bonus?","Yes"]
[]
[{"$nulls":13},"Invoice subtotal must be a minimum of \n$5,000 to receive rebates"]
["ZM ADD"]
["SKU Code","SKU Code - LOOKUP","Min Multi-Brand","Multi-Brand Counter",null,"MULTI-BRAND REBATE REQUIREMENT","PRODUCT NAME","VOLUME \nBREAKS","# UNITS","ESTIMATED INSEASON PRICE","INSEASON SUBTOTAL","PRICE/\nUNIT*","INVOICE SUBTOTAL","MULTI-BRAND REBATE","PURCHASE TIER REBATE","NET PRICE/UNIT \n(after all rebates)","TOTAL AFTER REBATE"]
[]
[{"$nulls":13},{"$f":"IF(M5=TRUE,L5,IF(M6=TRUE,L6,IF(M7=TRUE,L7,\"n/a\")))","v":"n/a"},{"$f":"IFERROR(INDEX($P$5:$P$8,MATCH(TRUE,$S$5:S8,0))+IF(O10=\"yes\",0.01,0),\"n/a\")","v":"n/a"}]
["D00000903",{"$f":"A17&\"-1\"","v":"D00000903-1"},16,{"$f":"OR(I17>=C17,I18>=C17,I19>=C17)","v":false},null,null,"Altus® (64 fl.oz. bottle)","1-15 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B17,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B17,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B17,PRICING[Lookup],0)),\"\")))","v":{"v":437.2,"d":"$ 437.20"}},{"$f":"IF(I17*J17= 0,\"\",I17*J17)","v":""},{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B17,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B17,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B17,PRICING[Lookup],0)),\"\")))","v":{"v":437.2,"d":"$ 437.20"}},{"$f":"IF(I17*L17= 0,\"\",I17*L17)","v":""},{"$f":"IFERROR(IF(I17=\"\",\"\",$N$16*M17),\"\")","v":""},{"$f":"IFERROR(IF(I17=\"\",\"\",$O$16*M17),\"\")","v":""},{"$f":"IFERROR((M17-SUM(N17:O17))/I17,\"\")","v":""},{"$f":"IF(AND(I17<>\"\",I17>0), I17*P17,\"\")","v":""}]
["D00000903",{"$f":"A18&\"-2\"","v":"D00000903-2"},{"$nulls":3},"16 bottles",null,"16-31 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B18,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B18,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B18,PRICING[Lookup],0)),\"\")))","v":{"v":437.2,"d":"$ 437.20"}},{"$f":"IF(I18*J18= 0,\"\",I18*J18)","v":""},{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B18,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B18,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B18,PRICING[Lookup],0)),\"\")))","v":{"v":415.36,"d":"$ 415.36"}},{"$f":"IF(I18*L18= 0,\"\",I18*L18)","v":""},{"$f":"IFERROR(IF(I18=\"\",\"\",$N$16*M18),\"\")","v":""},{"$f":"IFERROR(IF(I18=\"\",\"\",$O$16*M18),\"\")","v":""},"",""]
["D00000903",{"$f":"A19&\"-3\"","v":"D00000903-3"},{"$nulls":5},"32+ units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B19,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B19,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B19,PRICING[Lookup],0)),\"\")))","v":{"v":437.2,"d":"$ 437.20"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B19,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B19,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B19,PRICING[Lookup],0)),\"\")))","v":{"v":393.6,"d":"$ 393.60"}},"","","","",""]
["D00000908",{"$f":"A20&\"-1\"","v":"D00000908-1"},16,{"$f":"OR(I20>=C20,I21>=C20,I22>=C20)","v":false},null,null,"Broadform® (12 fl. oz. bottle)","1-15 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B20,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B20,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B20,PRICING[Lookup],0)),\"\")))","v":{"v":250,"d":"$ 250.00"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B20,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B20,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B20,PRICING[Lookup],0)),\"\")))","v":{"v":250,"d":"$ 250.00"}},"","","","",""]
["D00000908",{"$f":"A21&\"-2\"","v":"D00000908-2"},{"$nulls":3},"16 bottles",null,"16-31 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B21,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B21,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B21,PRICING[Lookup],0)),\"\")))","v":{"v":250,"d":"$ 250.00"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B21,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B21,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B21,PRICING[Lookup],0)),\"\")))","v":{"v":237.48,"d":"$ 237.48"}},{"$f":"IF(I21*L21= 0,\"\",I21*L21)","v":""},"","",{"$f":"IFERROR((M21-SUM(N21:O21))/I21,\"\")","v":""},""]
["D00000908",{"$f":"A22&\"-3\"","v":"D00000908-3"},{"$nulls":5},"32+ units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B22,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B22,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B22,PRICING[Lookup],0)),\"\")))","v":{"v":250,"d":"$ 250.00"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B22,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B22,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B22,PRICING[Lookup],0)),\"\")))","v":{"v":225,"d":"$ 225.00"}},"","","",{"$f":"IFERROR((M22-SUM(N22:O22))/I22,\"\")","v":""},""]
["D00001272",{"$f":"A23&\"-1\"","v":"D00001272-1"},8,{"$f":"OR(I23>=C23,I24>=C23,I25>=C23)","v":false},null,null,"Kontos® (32 oz. bottle)","1-3 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B23,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B23,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B23,PRICING[Lookup],0)),\"\")))","v":{"v":744,"d":"$ 744.00"}},{"$f":"IF(I23*J23= 0,\"\",I23*J23)","v":""},{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B23,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B23,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B23,PRICING[Lookup],0)),\"\")))","v":{"v":744,"d":"$ 744.00"}},{"$f":"IF(I23*L23= 0,\"\",I23*L23)","v":""},"","","",""]
["D00001272",{"$f":"A24&\"-2\"","v":"D00001272-2"},{"$nulls":3},"8 bottles",null,"4-15 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B24,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B24,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B24,PRICING[Lookup],0)),\"\")))","v":{"v":744,"d":"$ 744.00"}},{"$f":"IF(I24*J24= 0,\"\",I24*J24)","v":""},{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B24,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B24,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B24,PRICING[Lookup],0)),\"\")))","v":{"v":706.88,"d":"$ 706.88"}},{"$f":"IF(I24*L24= 0,\"\",I24*L24)","v":""},"","","",""]
["D00001272",{"$f":"A25&\"-3\"","v":"D00001272-3"},{"$nulls":5},"16+ units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B25,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B25,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B25,PRICING[Lookup],0)),\"\")))","v":{"v":744,"d":"$ 744.00"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B25,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B25,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B25,PRICING[Lookup],0)),\"\")))","v":{"v":669.6,"d":"$ 669.60"}},"","","","",""]
["D00000946",{"$f":"A26&\"-1\"","v":"D00000946-1"},8,{"$f":"OR(I26>=C26,I27>=C26,I28>=C26)","v":false},null,null,"Marengo® (64 fl.oz. bottle)","1-3 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B26,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B26,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B26,PRICING[Lookup],0)),\"\")))","v":{"v":1156.8,"d":"$ 1,156.80"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B26,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B26,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B26,PRICING[Lookup],0)),\"\")))","v":{"v":1156.8,"d":"$ 1,156.80"}},"","","","",""]
["D00000946",{"$f":"A27&\"-2\"","v":"D00000946-2"},{"$nulls":3},"8 bottles",null,"4-15 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B27,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B27,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B27,PRICING[Lookup],0)),\"\")))","v":{"v":1156.8,"d":"$ 1,156.80"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B27,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B27,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B27,PRICING[Lookup],0)),\"\")))","v":{"v":1098.88,"d":"$ 1,098.88"}},"","","","",""]
["D00000946",{"$f":"A28&\"-3\"","v":"D00000946-3"},{"$nulls":5},"16+ units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B28,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B28,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B28,PRICING[Lookup],0)),\"\")))","v":{"v":1156.8,"d":"$ 1,156.80"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B28,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B28,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B28,PRICING[Lookup],0)),\"\")))","v":{"v":1041.28,"d":"$ 1,041.28"}},"","","","",""]
["D00000945",{"$f":"A29&\"-1\"","v":"D00000945-1"},40,{"$f":"OR(I29>=C29,I30>=C29,I31>=C29)","v":false},null,null,"Marengo® G (50 lb. bag)","1-39 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B29,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B29,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B29,PRICING[Lookup],0)),\"\")))","v":{"v":126.5,"d":"$ 126.50"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B29,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B29,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B29,PRICING[Lookup],0)),\"\")))","v":{"v":126.5,"d":"$ 126.50"}},"","","","",""]
["D00000945",{"$f":"A30&\"-2\"","v":"D00000945-2"},{"$nulls":3},"40 bags",null,"40-119 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B30,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B30,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B30,PRICING[Lookup],0)),\"\")))","v":{"v":126.5,"d":"$ 126.50"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B30,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B30,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B30,PRICING[Lookup],0)),\"\")))","v":{"v":120,"d":"$ 120.00"}},"","","","",""]
["D00000945",{"$f":"A31&\"-3\"","v":"D00000945-3"},{"$nulls":5},"120+ units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B31,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B31,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B31,PRICING[Lookup],0)),\"\")))","v":{"v":126.5,"d":"$ 126.50"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B31,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B31,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B31,PRICING[Lookup],0)),\"\")))","v":{"v":114,"d":"$ 114.00"}},"","","","",""]
["D00000987",{"$f":"A32&\"-1\"","v":"D00000987-1"},12,{"$f":"OR(I32>=C32,I33>=C32,I34>=C32)","v":false},null,null,"Savate® (8 fl.oz. bottle)","1-11 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B32,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B32,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B32,PRICING[Lookup],0)),\"\")))","v":{"v":384.8,"d":"$ 384.80"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B32,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B32,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B32,PRICING[Lookup],0)),\"\")))","v":{"v":384.8,"d":"$ 384.80"}},"","","","",""]
["D00000987",{"$f":"A33&\"-2\"","v":"D00000987-2"},{"$nulls":3},"12 bottles",null,"12-29 units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B33,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B33,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B33,PRICING[Lookup],0)),\"\")))","v":{"v":384.8,"d":"$ 384.80"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B33,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B33,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B33,PRICING[Lookup],0)),\"\")))","v":{"v":365.6,"d":"$ 365.60"}},"","","","",""]
["D00000987",{"$f":"A34&\"-3\"","v":"D00000987-3"},{"$nulls":5},"30+ units",null,{"$f":"IF($G$10=$AH$3,INDEX(PRICING[2025 In-Season Price],MATCH(B34,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA In-season Price],MATCH(B34,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA In-season Price],MATCH(B34,PRICING[Lookup],0)),\"\")))","v":{"v":384.8,"d":"$ 384.80"}},"",{"$f":"IF($G$10=$AH$3,INDEX(PRICING[NOW Price],MATCH(B34,PRICING[Lookup],0)),\nIF($G$10=$AH$4,INDEX(PRICING[CA NOW Price],MATCH(B34,PRICING[Lookup],0)),\nIF($G$10=$AH$5,INDEX(PRICING[WA NOW Price],MATCH(B34,PRICING[Lookup],0)),\"\")))","v":{"v":346.32,"d":"$ 346.32"}},"","","","",""]
[{"$nulls":3},{"$f":"COUNTIF($D$17:$D$34,TRUE)","v":0},{"$nulls":6},{"$f":"SUM(K17:K34)","v":{"v":0,"d":"$ 0.00"}},null,{"$f":"SUM(M17:M34)","v":{"v":0,"d":"$ 0.00"}},{"$f":"SUM(N17:N34)","v":{"v":0,"d":"$ 0.00"}},{"$f":"SUM(O17:O34)","v":{"v":0,"d":"$ 0.00"}},null,{"$f":"SUM(Q17:Q34)","v":{"v":0,"d":"$ 0.00"}}]
[]
[]
[{"$nulls":5},"NON-AGENCY BRAND REBATES"]
[{"$nulls":5},"MINIMUM QUANTITY \nREQUIREMENT","PRODUCT NAME","REBATE PER UNIT","# UNITS","ESTIMATED INSEASON \nPRICE","ESTIMATED TOTAL PRICE BEFORE REBATE","ESTIMATED PRICE AFTER REBATE","ESTIMATED TOTAL AFTER REBATE"]
[11008513,{"$f":"A40&\"-1\"","v":"11008513-1"},{"$nulls":3},"8+ bottles","Aria® (160 gram bottle)",{"v":21,"d":"$ 21.00"},null,{"v":193.38,"d":"$ 193.38"},{"$f":"IF(I40=\"\",\"\",I40*J40)","v":""},{"$f":"IF(I40=\"\",\"\",IF(I40<8,\"n/a\",J40-H40))","v":""},{"$f":"IF(I40=\"\",\"\",IF(I40>=8,I40*L40,\"n/a\"))","v":""},{"$nulls":8},{"$f":"IF(I40<W40,J40*I40,(J40-H40)*I40)","v":0},8]
["D00001274","D00001274-1",{"$nulls":3},"4+ bags","B-Nine® (5 lb. bag)",{"v":12,"d":"$ 12.00"},null,{"v":260.1,"d":"$ 260.10"},{"$f":"IF(I41=\"\",\"\",I41*J41)","v":""},{"$f":"IF(I41=\"\",\"\",IF(I41<4,\"n/a\",J41-H41))","v":""},{"$f":"IF(I41=\"\",\"\",IF(I41>=4,I41*L41,\"n/a\"))","v":""},{"$nulls":8},{"$f":"IF(I41<W41,J41*I41,(J41-H41)*I41)","v":0},4]
["D00001275","D00001275-1",{"$nulls":3},"4+ bottles","Floramite® (32 fl. oz. bottle)",{"v":50,"d":"$50.00"},null,{"v":329.75,"d":"$ 329.75"},"",{"$f":"IF(I42=\"\",\"\",IF(I42<4,\"n/a\",J42-H42))","v":""},{"$f":"IF(I42=\"\",\"\",IF(I42>=4,I42*L42,\"n/a\"))","v":""},{"$nulls":8},0,4]
["D00001276","D00001276-1",{"$nulls":3},"4+ bottles","Shuttle® (32 fl. oz. bottle)",{"v":24,"d":"$24.00"},null,{"v":417.6,"d":"$ 417.60"},"","","",{"$nulls":8},0,4]
[11008457,"11008457-1",{"$nulls":3},"4+ bottles","Talstar® Select (1 gallon bottle)",{"v":6,"d":"$6.00"},null,{"v":60.72,"d":"$ 60.72"},"","","",{"$nulls":8},0,4]
[]
[]
[{"$nulls":5},"Summary"]
[{"$nulls":5},"Summary is provided as an estimate only. See program rules and conditions.",{"$nulls":5},"TALSTAR SELECT IS A RESTRICTED USE PESTICIDE. For retail sale to and use only by Certified Applicators or persons under their direct supervision and only for those uses covered by the Certified Applicator’s certification. *Pricing for all states except CA or WA. Must be purchased on a single invoice to receive volume discount price. **Savings compared to 1 unit at the in-season National price. †Must be registered in My Envu Rewards and accept current Terms and Conditions to participate. Customer Ornamentals promotional cumulative purchases (Sept. 1 - Dec. 5, 2025) must be $5,000 or more to qualify for rebates. New members signed up before Dec. 31, 2025, will receive Ornamentals EOP rebates. All rebates for the 2025 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 Sept. 1 - Dec. 5, 2025, 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, 2026. 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, Kontos or Broadform 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. \n\nALWAYS READ AND FOLLOW LABEL INSTRUCTIONS. Environmental Science U.S. LLC, 5000 CentreGreen Way, Suite 400, Cary, NC 27513. For additional product information, call toll-free 1-800-331-2867. www.envu.com. Please verify state registration of these products in your state before selling, using or distributing. Not all products are registered in all states. Envu, the Envu logo and product logos are trademarks owned by Environmental Science U.S. LLC or one of its affiliates. Other trademarks are the property of their respective owners. ©2025 Environmental Science U.S. LLC\n"]
[]
[{"$nulls":5},"Estimated Total Before Off Invoice Discounts:",null,{"$f":"K35+SUMPRODUCT($I$40:$I$44,$J$40:$J$44)","v":{"v":0,"d":"$ 0.00"}}]
[{"$nulls":5},"Estimated Total After Off Invoice Total:",null,{"$f":"M35+SUMPRODUCT($J$40:$J$44,$I$40:$I$44)","v":{"v":0,"d":"$ 0.00"}}]
[{"$nulls":5},"Estimated Off-Invoice Discount:",null,{"$f":"IFERROR(I52/H50,\"n/a\")","v":"n/a"},{"$f":"H50-H51","v":{"v":0,"d":"$ 0.00"}}]
[{"$nulls":5},"Multi-Brand Rebate, Volume Rebate and Tier Rebate"]
[{"$nulls":5},"Estimated Multi-Brand Rebate:",null,{"$f":"$N$16","v":"n/a"},{"$f":"$N$35","v":{"v":0,"d":"$ 0.00"}}]
[{"$nulls":5},"Estimated Volume Buy Rebate (non-agency):",null,{"$f":"IFERROR(I55/H51,\"n/a\")","v":"n/a"},{"$f":"SUM(K40:K44)-SUM($V$40:$V$44)","v":{"v":0,"d":"$ 0.00"}}]
[{"$nulls":5},"Estimated Tier Rebate:",null,{"$f":"$O$16","v":"n/a"},{"$f":"$O$35","v":{"v":0,"d":"$ 0.00"}}]
[{"$nulls":5},"Estimated Total Rebate:",null,{"$f":"SUM(H54:H56)","v":{"v":0,"d":"0.0%"}},{"$f":"SUM(I54:I56)","v":{"v":0,"d":"$ 0.00"}}]
[{"$nulls":5},"Estimated Net Total after Rebates & Discounts:",null,{"$f":"H51-I57","v":{"v":0,"d":"$ 0.00"}}]
[]
[{"$nulls":5},{"$f":"CONCATENATE(\"Estimated MER points to be earned: \",TEXT(IF(AND(I57 <>\"\", I57 > 0),I57*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned: 0"}]

{"sheet":"SUMMARY - UNITS (2025)","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"merged":[[1,2,1,6],[2,3,2,6],[3,3,3,6],[4,3,4,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[9,2,11,2],[9,3,11,3],[9,4,11,4],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[12,2,14,2],[15,2,17,2],[18,2,20,2],[21,2,23,2],[24,2,26,2],[27,2,29,2],[38,2,39,8],[40,2,40,5],[40,6,40,7],[41,2,41,5],[41,6,41,7],[42,2,42,5],[43,2,43,7],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[48,6,48,7],[50,2,50,7],[52,2,63,9]]}
[]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F4","v":"NAME YOUR DRAFT ORDER HERE:"}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F5","v":"Description: "}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F6","v":"Dist/DSR: "}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F7","v":"MER#: "}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F8","v":"Last Updated: "}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F9","v":"Created For: "}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F10","v":"Region:"}]
[null,null,"Page 1 of 1"]
[null,null,"PRODUCT NAME","Volume Tier","# UNITS","ORIGINAL PRICE/UNIT","EOP \nPRICE/UNIT","SUBTOTAL\n(before rebates)","NET PRICE/UNIT\n(after rebate)","SUBTOTAL\n(after rebate)"]
[]
[]
["D00000907",null,"Altus® (64 fl.oz. bottle)",{"$f":"'2025 ORNAMENTALS - UNITS'!H17","v":"1-15 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I17","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J17","v":{"v":437.2,"d":"$ 437.20"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L17","v":{"v":437.2,"d":"$ 437.20"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M17","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P17","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q17","v":""}]
["D00000623",null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H18","v":"16-31 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I18","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J18","v":{"v":437.2,"d":"$ 437.20"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L18","v":{"v":415.36,"d":"$ 415.36"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M18","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P18","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q18","v":""}]
["D00000914",null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H19","v":"32+ units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I19","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J19","v":{"v":437.2,"d":"$ 437.20"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L19","v":{"v":393.6,"d":"$ 393.60"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M19","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P19","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q19","v":""}]
["D00001373",null,"Broadform® (12 fl. oz. bottle)",{"$f":"'2025 ORNAMENTALS - UNITS'!H20","v":"1-15 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I20","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J20","v":{"v":250,"d":"$ 250.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L20","v":{"v":250,"d":"$ 250.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M20","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P20","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q20","v":""}]
[11008557,null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H21","v":"16-31 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I21","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J21","v":{"v":250,"d":"$ 250.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L21","v":{"v":237.48,"d":"$ 237.48"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M21","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P21","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q21","v":""}]
[11009500,null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H22","v":"32+ units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I22","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J22","v":{"v":250,"d":"$ 250.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L22","v":{"v":225,"d":"$ 225.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M22","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P22","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q22","v":""}]
["D00001379",null,"Kontos® (32 oz. bottle)",{"$f":"'2025 ORNAMENTALS - UNITS'!H23","v":"1-3 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I23","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J23","v":{"v":744,"d":"$ 744.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L23","v":{"v":744,"d":"$ 744.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M23","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P23","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q23","v":""}]
[81701245,null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H24","v":"4-15 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I24","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J24","v":{"v":744,"d":"$ 744.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L24","v":{"v":706.88,"d":"$ 706.88"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M24","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P24","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q24","v":""}]
["D00000965",null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H25","v":"16+ units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I25","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J25","v":{"v":744,"d":"$ 744.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L25","v":{"v":669.6,"d":"$ 669.60"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M25","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P25","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q25","v":""}]
[11003880,null,"Marengo® (64 fl.oz. bottle)",{"$f":"'2025 ORNAMENTALS - UNITS'!H26","v":"1-3 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I26","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J26","v":{"v":1156.8,"d":"$ 1,156.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L26","v":{"v":1156.8,"d":"$ 1,156.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M26","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P26","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q26","v":""}]
["D00000125",null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H27","v":"4-15 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I27","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J27","v":{"v":1156.8,"d":"$ 1,156.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L27","v":{"v":1098.88,"d":"$ 1,098.88"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M27","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P27","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q27","v":""}]
[11014245,null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H28","v":"16+ units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I28","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J28","v":{"v":1156.8,"d":"$ 1,156.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L28","v":{"v":1041.28,"d":"$ 1,041.28"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M28","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P28","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q28","v":""}]
["D00000989",null,"Marengo® G (50 lb. bag)",{"$f":"'2025 ORNAMENTALS - UNITS'!H29","v":"1-39 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I29","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J29","v":{"v":126.5,"d":"$ 126.50"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L29","v":{"v":126.5,"d":"$ 126.50"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M29","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P29","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q29","v":""}]
[79714858,null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H30","v":"40-119 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I30","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J30","v":{"v":126.5,"d":"$ 126.50"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L30","v":{"v":120,"d":"$ 120.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M30","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P30","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q30","v":""}]
["D00000911",null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H31","v":"120+ units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I31","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J31","v":{"v":126.5,"d":"$ 126.50"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L31","v":{"v":114,"d":"$ 114.00"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M31","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P31","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q31","v":""}]
[79545312,null,"Savate® (8 fl.oz. bottle)",{"$f":"'2025 ORNAMENTALS - UNITS'!H32","v":"1-11 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I32","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J32","v":{"v":384.8,"d":"$ 384.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L32","v":{"v":384.8,"d":"$ 384.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M32","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P32","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q32","v":""}]
[11013862,null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H33","v":"12-29 units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I33","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J33","v":{"v":384.8,"d":"$ 384.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L33","v":{"v":365.6,"d":"$ 365.60"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M33","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P33","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q33","v":""}]
["D00000990",null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!H34","v":"30+ units"},{"$f":"'2025 ORNAMENTALS - UNITS'!I34","v":0},{"$f":"'2025 ORNAMENTALS - UNITS'!J34","v":{"v":384.8,"d":"$ 384.80"}},{"$f":"'2025 ORNAMENTALS - UNITS'!L34","v":{"v":346.32,"d":"$ 346.32"}},{"$f":"'2025 ORNAMENTALS - UNITS'!M34","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!P34","v":""},{"$f":"'2025 ORNAMENTALS - UNITS'!Q34","v":""}]
[null,null,"NON-AGENCY PRODUCTS"]
["D00000990",null,"Aria® (160 gram bottle)","n/a",{"$f":"'2025 ORNAMENTALS - UNITS'!I40","v":0},{"$f":"IF(E32=\"\",\"\",'2025 ORNAMENTALS - UNITS'!J40)","v":{"v":193.38,"d":"$ 193.38"}},{"$f":"IF(E32=\"\",\"\",\"n/a\")","v":"n/a"},{"$f":"IF(E32=\"\",\"\",E32*F32)","v":{"v":0,"d":"$ 0.00"}},{"$f":"IF(E32=\"\",\"\",IF(E32>=8,'2025 ORNAMENTALS - UNITS'!J40-'2025 ORNAMENTALS - UNITS'!H40,'2025 ORNAMENTALS - UNITS'!J40))","v":{"v":193.38,"d":"$ 193.38"}},{"$f":"IF(E32=\"\",\"\",E32*I32)","v":{"v":0,"d":"$ 0.00"}}]
[null,null,"B-Nine® (5 lb. bag)","n/a",{"$f":"'2025 ORNAMENTALS - UNITS'!I41","v":0},{"$f":"IF(E33=\"\",\"\",'2025 ORNAMENTALS - UNITS'!J41)","v":{"v":260.1,"d":"$ 260.10"}},{"$f":"IF(E33=\"\",\"\",\"n/a\")","v":"n/a"},{"$f":"IF(E33=\"\",\"\",E33*F33)","v":{"v":0,"d":"$ 0.00"}},{"$f":"IF(E33=\"\",\"\",IF(E33>=4,'2025 ORNAMENTALS - UNITS'!J41-'2025 ORNAMENTALS - UNITS'!H41,'2025 ORNAMENTALS - UNITS'!J41))","v":{"v":260.1,"d":"$ 260.10"}},{"$f":"IF(E33=\"\",\"\",E33*I33)","v":{"v":0,"d":"$ 0.00"}}]
[null,null,"Floramite® (32 fl. oz. bottle)","n/a",{"$f":"'2025 ORNAMENTALS - UNITS'!I42","v":0},{"$f":"IF(E34=\"\",\"\",'2025 ORNAMENTALS - UNITS'!J42)","v":{"v":329.75,"d":"$ 329.75"}},"n/a",{"v":0,"d":"$ 0.00"},{"$f":"IF(E34=\"\",\"\",IF(E34>=4,'2025 ORNAMENTALS - UNITS'!J42-'2025 ORNAMENTALS - UNITS'!H42,'2025 ORNAMENTALS - UNITS'!J42))","v":{"v":329.75,"d":"$ 329.75"}},{"v":0,"d":"$ 0.00"}]
[null,null,"Shuttle® (32 fl. oz. bottle)","n/a",{"$f":"'2025 ORNAMENTALS - UNITS'!I43","v":0},{"$f":"IF(E35=\"\",\"\",'2025 ORNAMENTALS - UNITS'!J43)","v":{"v":417.6,"d":"$ 417.60"}},"n/a",{"v":0,"d":"$ 0.00"},{"$f":"IF(E35=\"\",\"\",IF(E35>=4,'2025 ORNAMENTALS - UNITS'!J43-'2025 ORNAMENTALS - UNITS'!H43,'2025 ORNAMENTALS - UNITS'!J43))","v":{"v":417.6,"d":"$ 417.60"}},{"v":0,"d":"$ 0.00"}]
[null,null,"Talstar® Select (1 gallon bottle)","n/a",{"$f":"'2025 ORNAMENTALS - UNITS'!I44","v":0},{"$f":"IF(E36=\"\",\"\",'2025 ORNAMENTALS - UNITS'!J44)","v":{"v":60.72,"d":"$ 60.72"}},"n/a",{"v":0,"d":"$ 0.00"},{"$f":"IF(E36=\"\",\"\",IF(E36>=4,'2025 ORNAMENTALS - UNITS'!J44-'2025 ORNAMENTALS - UNITS'!H44,'2025 ORNAMENTALS - UNITS'!J44))","v":{"v":60.72,"d":"$ 60.72"}},{"v":0,"d":"$ 0.00"}]
[{"$nulls":7},{"$f":"SUM(H13:H36)","v":{"v":0,"d":"$ 0.00"}},null,{"$f":"SUM(J13:J36)","v":{"v":0,"d":"$ 0.00"}}]
[null,null,"Summary"]
[null,null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F50","v":"Estimated Total Before Off Invoice Discounts:"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H50","v":{"v":0,"d":"$ 0.00"}}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F51","v":"Estimated Total After Off Invoice Total:"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H51","v":{"v":0,"d":"$ 0.00"}}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F52","v":"Estimated Off-Invoice Discount:"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H52","v":"n/a"},{"$f":"'2025 ORNAMENTALS - UNITS'!I52","v":{"v":0,"d":"$ 0.00"}}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F53","v":"Multi-Brand Rebate, Volume Rebate and Tier Rebate"}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F54","v":"Estimated Multi-Brand Rebate:"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H54","v":"n/a"},{"$f":"'2025 ORNAMENTALS - UNITS'!I54","v":{"v":0,"d":"$ 0.00"}}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F55","v":"Estimated Volume Buy Rebate (non-agency):"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H55","v":"n/a"},{"$f":"'2025 ORNAMENTALS - UNITS'!I55","v":{"v":0,"d":"$ 0.00"}}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F56","v":"Estimated Tier Rebate:"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H56","v":"n/a"},{"$f":"'2025 ORNAMENTALS - UNITS'!I56","v":{"v":0,"d":"$ 0.00"}}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F57","v":"Estimated Total Rebate:"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H57","v":{"v":0,"d":"0.0%"}},{"$f":"'2025 ORNAMENTALS - UNITS'!I57","v":{"v":0,"d":"$ 0.00"}}]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F58","v":"Estimated Net Total after Rebates & Discounts:"},{"$nulls":3},{"$f":"'2025 ORNAMENTALS - UNITS'!H58","v":{"v":0,"d":"$ 0.00"}}]
[]
[null,null,{"$f":"'2025 ORNAMENTALS - UNITS'!F60","v":"Estimated MER points to be earned: 0"}]
[]
[null,null,"TALSTAR SELECT IS A RESTRICTED USE PESTICIDE. For retail sale to and use only by Certified Applicators or persons under their direct supervision and only for those uses covered by the Certified Applicator’s certification. *Pricing for all states except CA or WA. Must be purchased on a single invoice to receive volume discount price. **Savings compared to 1 unit at the in-season National price. †Must be registered in My Envu Rewards and accept current Terms and Conditions to participate. Customer Ornamentals promotional cumulative purchases (Sept. 1 - Dec. 5, 2025) must be $5,000 or more to qualify for rebates. New members signed up before Dec. 31, 2025, will receive Ornamentals EOP rebates. All rebates for the 2025 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 Sept. 1 - Dec. 5, 2025, 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, 2026. 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, Kontos or Broadform 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. \n\nALWAYS READ AND FOLLOW LABEL INSTRUCTIONS. Environmental Science U.S. LLC, 5000 CentreGreen Way, Suite 400, Cary, NC 27513. For additional product information, call toll-free 1-800-331-2867. www.envu.com. Please verify state registration of these products in your state before selling, using or distributing. Not all products are registered in all states. Envu, the Envu logo and product logos are trademarks owned by Environmental Science U.S. LLC or one of its affiliates. Other trademarks are the property of their respective owners. ©2025 Environmental Science U.S. LLC"]

{"sheet":"REBATE MATRIX (NOW)","index":2,"n_rows":46,"n_cols":18,"rows_kept":46,"hidden":true}
[{"$nulls":15},{"$f":"COUNTIF(Rebate_Lookup[Volume Buy Counter],TRUE)","v":0}]
[null,"SKU CODE","Agency/TT","Description","Size","Instances","MOQ_1","MOQ_2","MOQ_3","REB_MOQ_1","REB_MOQ_2","REB_MOQ_3","Order Form Quantity","Qualified Rebate Tier","Column1","Volume Buy Counter"]
[null,"D00000903","A","Altus®","64 oz",2,1,16,32,{"$nulls":3},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3}]
[null,"D00000908","A","Broadform","12 oz",2,1,16,32,{"$nulls":3},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3}]
[null,"D00001272","A","Kontos","1 qt",2,1,4,16,{"$nulls":3},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3}]
[null,"D00000946","A","Marengo FLO","64 oz",2,1,4,16,{"$nulls":3},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3}]
[null,"D00000945","A","Marengo G","50 lb",2,1,40,120,{"$nulls":3},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3}]
[null,"D00000987","A","Savate","8 oz",2,1,12,30,{"$nulls":3},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":3}]
[null,11008513,"TT","Aria® Insecticide  ","160 g",2,1,8,null,0,{"v":21,"d":"$21.00"},null,{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00001274","TT","B-Nine","5 lb",2,1,4,null,0,{"v":12,"d":"$12.00"},null,{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00001275","TT","Floramite","1 qt",2,1,4,null,0,{"v":50,"d":"$50.00"},null,{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00001276","TT","Shuttle","1 qt",2,1,4,null,0,{"v":25,"d":"$25.00"},null,{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,11008457,"TT","Talstar® Select Insecticide (RUP) ","1 gal",2,1,4,null,0,{"v":6,"d":"$6.00"},null,{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":0},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":1},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":false},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[{"$nulls":12},{"$f":"INDEX('2025 ORNAMENTALS - UNITS'!I:I,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 ORNAMENTALS - UNITS'!A:A,0))","v":{"$error":"#N/A"}},{"$f":"IF(Rebate_Lookup[[#This Row],[Instances]]=1,1,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=2,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]]),2,\nIF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_2]]),1,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[MOQ_2]]<=Rebate_Lookup[[#This Row],[Order Form Quantity]],Rebate_Lookup[[#This Row],[Order Form Quantity]]<Rebate_Lookup[[#This Row],[MOQ_3]]),2,IF(AND(Rebate_Lookup[[#This Row],[Instances]]=3,Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_3]]),3))))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0},{"$f":"IFERROR(Rebate_Lookup[[#This Row],[Order Form Quantity]]>=Rebate_Lookup[[#This Row],[MOQ_2]],0)","v":0},null,{"$f":"COUNTIF('2025 ORNAMENTALS - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]

{"sheet":"2025 NOW_EOP_LL","index":3,"n_rows":24,"n_cols":33,"rows_kept":24,"hidden":true}
["Manufacturer","Agency/TT","Segment","Region","Indication","Vol Buys","Program","Old Bayer SKU ","Old Envu SKU","SKU","Product","Size","2025 In-Season Price","NOW Price","In SZN-NOW delta","Min Qty","Rebate $","Final Price","CA In-season Price","CA NOW Price","CA Final Price","WA In-season Price","WA NOW Price","WA Final Price","Package Ounces","Standard Use Rate (oz/M)","Standard Use Rate (oz/Acre)","Price/1000 sq ft","Price/Acre","Total %","*cumlative","Set","Lookup"]
["Envu","A","GLO","NST","I",null,"EOP/ORN","84989509",null,"D00000903","Altus®","64 oz",437.2,437.2,0,"1-15",null,437.2,449.33,449.33,449.33,440.26,440.26,440.26,64,0.32,13.939200000000001,2.186,95.22216,0.1,null,1,{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000903-1"}]
["Envu","A","GLO","NST","I",null,"EOP/ORN","84989509",null,"D00000903","Altus®","64 oz",437.2,415.36,21.839999999999975,"16-31",null,415.36,449.33,426.89,426.89,440.26,418.27,418.27,64,0.32,13.939200000000001,2.0768,90.46540800000001,0.14995425434583712,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J2,AF2+1,1)","v":2},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000903-2"}]
["Envu","A","GLO","NST","I",null,"EOP/ORN","84989509",null,"D00000903","Altus®","64 oz",437.2,393.6,43.599999999999966,"32+",null,393.6,449.33,404.52,404.52,440.26,396.36,396.36,64,0.32,13.939200000000001,1.9680000000000002,85.72608000000001,0.19972552607502284,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J3,AF3+1,1)","v":3},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000903-3"}]
["FMC","TT","O",null,"I",null,"ORN",null,null,11008513,"Aria® Insecticide  ","160 g",193.38,193.38,0,"8+",{"v":21,"d":"$21.00"},172.38,{"$nulls":6},5.64383,0.09871441689623507,4.3,3.015043186023144,131.33528118316815,0.1085944771951598,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J4,AF4+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"11008513-1"}]
["Envu","TT","O",null,"PGR",null,"ORN",null,null,"D00001274","B-Nine","5 lb",260.09999999999997,260.09999999999997,0,"4+",{"v":12,"d":"$12.00"},248.09999999999997,{"$nulls":6},80,2.7089072543617996,118,8.40099862258953,365.94749999999993,0.046136101499423265,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J5,AF5+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00001274-1"}]
["Envu","A","O",null,"F",null,"ORN","86762153",null,"D00000908","Broadform","12 oz",250,250,0,"1-15",null,250,256.94,256.94,256.94,251.75,251.75,251.75,12,0.18365472910927455,8,3.826140189776553,166.66666666666666,0.1,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J6,AF6+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000908-1"}]
["Envu","A","O",null,"F",null,"ORN","86762153",null,"D00000908","Broadform","12 oz",250,237.48,12.52000000000001,"16-31",null,237.48,256.94,244.07,244.07,251.75,239.14,239.14,12,0.18365472910927455,8,3.6345270890725434,158.32,0.15008000000000002,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J7,AF7+1,1)","v":2},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000908-2"}]
["Envu","A","O",null,"F",null,"ORN","86762153",null,"D00000908","Broadform","12 oz",250,225,25,"32+",null,225,256.94,231.24,231.24,251.75,226.58,226.58,12,0.18365472910927455,8,3.443526170798898,150,0.19999999999999998,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J8,AF8+1,1)","v":3},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000908-3"}]
["Envu","TT","O",null,"I",null,"ORN",null,null,"D00001275","Floramite","1 qt",329.75,329.75,0,"4+",{"v":50,"d":"$50.00"},279.75,{"$nulls":6},32,0.18365472910927455,8,1.605544077134986,69.9375,0.15163002274450343,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J9,AF9+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00001275-1"}]
["Envu","A","O",null,"I",null,"ORN",null,null,"D00001272","Kontos","1 qt",{"v":744,"d":"$744.00"},{"v":744,"d":"$744.00"},{"v":0,"d":"$0.00"},"1-3",null,744,764.65,764.65,764.65,749.21,749.21,749.21,32,0.07805325987144168,3.4,1.814738292011019,79.05,0.1,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J10,AF10+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00001272-1"}]
["Envu","A","O",null,"I",null,"ORN",null,null,"D00001272","Kontos","1 qt",744,706.88,37.120000000000005,"4-15",null,706.88,764.65,726.41,726.41,749.21,711.75,711.75,32,0.07805325987144168,3.4,1.7241965105601467,75.106,0.1498924731182796,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J11,AF11+1,1)","v":2},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00001272-2"}]
["Envu","A","O",null,"I",null,"ORN",null,null,"D00001272","Kontos","1 qt",744,669.6,74.39999999999998,"16+",null,{"v":669.6,"d":"$669.60"},{"v":764.65,"d":"$764.65"},{"v":688.18,"d":"$688.18"},{"v":688.18,"d":"$688.18"},{"v":749.21,"d":"$749.21"},{"v":674.29,"d":"$674.29"},{"v":674.29,"d":"$674.29"},{"v":32,"d":"$32.00"},0.07805325987144168,3.4,1.6332644628099173,71.145,0.19999999999999998,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J12,AF12+1,1)","v":3},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00001272-3"}]
["Envu","A","O",null,"H",null,"ORN","86729148",null,"D00000946","Marengo FLO","64 oz",1156.8,1156.8,0,"1-3",null,1156.8,1188.9,1188.9,1188.9,1164.9,1164.9,1164.9,64,0.4247015610651974,18.5,7.676480716253443,334.3875,0.1,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J13,AF13+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000946-1"}]
["Envu","A","O",null,"H",null,"ORN","86729148",null,"D00000946","Marengo FLO","64 oz",1156.8,1098.88,57.919999999999845,"4-15",null,1098.88,1188.9,1129.37,1129.37,1164.9,1106.57,1106.57,64,0.4247015610651974,18.5,7.29212580348944,317.64500000000004,0.1500691562932225,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J14,AF14+1,1)","v":2},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000946-2"}]
["Envu","A","O",null,"H",null,"ORN","86729148",null,"D00000946","Marengo FLO","64 oz",1156.8,1041.28,115.51999999999998,"16+",null,1041.28,1188.9,1070.18,1070.18,1164.9,1048.57,1048.57,64,0.4247015610651974,18.5,6.909894398530762,300.995,0.19986168741355462,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J15,AF15+1,1)","v":3},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000946-3"}]
["Envu","A","O",null,"H",null,"ORN","84922757",null,"D00000945","Marengo G","50 lb",126.5,126.5,0,"1-39",null,126.5,130.01,130.01,130.01,127,127,127,50,3.443526170798898,150,8.712121212121211,379.49999999999994,0.1,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J16,AF16+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000945-1"}]
["Envu","A","O",null,"H",null,"ORN","84922757",null,"D00000945","Marengo G","50 lb",126.5,120,6.5,"40-119",null,120,130.01,123.33,123.33,127,120.84,120.84,50,3.443526170798898,150,8.264462809917354,360,0.1513833992094862,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J17,AF17+1,1)","v":2},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000945-2"}]
["Envu","A","O",null,"H",null,"ORN","84922757",null,"D00000945","Marengo G","50 lb",126.5,{"v":114,"d":"$114.00"},{"v":12.5,"d":"$12.50"},"120+",null,114,130.01,117.16,117.16,127,114.8,114.8,50,3.443526170798898,150,7.851239669421487,341.99999999999994,0.19881422924901185,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J18,AF18+1,1)","v":3},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000945-3"}]
["Envu","A","O",null,"I",null,"ORN","84907898",null,"D00000987","Savate","8 oz",384.8,{"v":384.8,"d":"$384.80"},0,"1-11",null,384.8,395.48,395.48,395.48,387.5,387.5,387.5,8,0.09182736455463728,4,4.416896235078053,192.4,0.1,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J19,AF19+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000987-1"}]
["Envu","A","O",null,"I",null,"ORN","84907898",null,"D00000987","Savate","8 oz",384.8,{"v":365.6,"d":"$365.60"},{"v":19.19999999999999,"d":"$19.20"},"12-29",null,365.6,395.48,375.75,375.75,387.5,368.16,368.16,8,0.09182736455463728,4,4.1965105601469235,182.8,0.1498960498960499,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J20,AF20+1,1)","v":2},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000987-2"}]
["Envu","A","O",null,"I",null,"ORN","84907898",null,"D00000987","Savate","8 oz",384.8,{"v":346.32,"d":"$346.32"},{"v":38.48000000000002,"d":"$38.48"},"30+",null,346.32,395.48,355.93,355.93,387.5,348.74,348.74,8,0.09182736455463728,4,3.9752066115702474,173.16,0.2000000000000001,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J21,AF21+1,1)","v":3},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00000987-3"}]
["Envu","TT","O",null,"I",null,"ORN",null,null,"D00001276","Shuttle","1 qt",417.59999999999997,{"v":417.59999999999997,"d":"$417.60"},0,"4+",{"v":25,"d":"$25.00"},392.59999999999997,{"$nulls":6},32,0.2938475665748393,12.8,3.6051423324150593,157.04,0.05986590038314177,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J22,AF22+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"D00001276-1"}]
["FMC","TT","G","NST","I",null,"EOP/ORN",null,null,11008457,"Talstar® Select Insecticide (RUP) ","1 gal",60.72,{"v":60.72,"d":"$60.72"},0,"4+",{"v":6,"d":"$6.00"},54.72,{"$nulls":6},128,1.8365472910927456,80,0.7851239669421487,34.2,0.09881422924901184,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J23,AF23+1,1)","v":1},{"$f":"PRICING[[#This Row],[SKU]]&\"-\"&PRICING[[#This Row],[Set]]","v":"11008457-1"}]