{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["2025 NOW-CALCULATOR - UNITS","SUMMARY - UNITS (2025)","REBATE MATRIX (NOW)","2025 NOW_EOP_LL","Sheet4"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"comments":2,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2025 NOW-CALCULATOR - UNITS","index":0,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":false,"merged":[[6,22,7,23],[8,22,8,23],[6,17,7,17],[6,18,7,19],[8,18,8,19],[6,20,7,21],[8,20,8,21],[45,3,45,5],[46,3,46,5],[46,11,49,23],[11,16,13,16],[44,3,44,5],[11,23,13,23],[50,3,50,5],[53,3,53,7],[51,3,51,5],[51,6,51,7],[47,3,47,5],[48,3,48,5],[49,3,49,5],[0,4,0,11],[11,15,13,15],[11,13,13,13],[11,3,13,3],[11,4,13,4],[11,5,13,5],[11,7,13,7],[11,8,13,8],[11,9,13,9],[3,3,3,4],[11,0,13,0],[43,3,43,5],[11,12,13,12],[11,14,13,14],[11,1,13,1],[11,10,13,10],[11,11,13,11],[38,3,38,7],[41,3,41,5],[42,3,42,5],[38,11,43,23],[11,22,13,22],[11,6,13,6],[11,17,13,17],[11,18,13,18],[41,6,41,7],[40,3,40,5],[40,6,40,7],[11,20,13,20],[11,21,13,21],[11,19,13,19]]}
[null,null,null,null,"         CALIFORNIA 2025 NOW SOLUTIONS CALCULATOR                  "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Rebates & Bonus Unlocks:"]
[null,null,null,"NAME YOUR DRAFT ORDER HERE:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spend Requirement:","$5k+","$10k+","$20k+","$50k+","$100k+","$150k+"]
[null,null,null,"Description: ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier Rebate:",0.02,0.02,0.03,0.04,0.05,0.06]
[null,null,null,"Dist/DSR: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND($L$36>=5000,$L$36<10000)","v":false},{"$f":"AND($L$36>=10000,$L$36<20000)","v":false},{"$f":"AND($L$36>=20000,$L$36<50000)","v":false},{"$f":"AND($L$36>=50000,$L$36<100000)","v":false},{"$f":"AND($L$36>=100000,$L$36<150000)","v":false},{"$f":"$L$36>=150000","v":false}]
[null,null,null,"MER#: ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Product:","Stressgard &Chipco Sig.\n(>$10k)",null,"Serata\n(8 unit min.)",null,"Volume Buy\n(5 or more products)"]
[null,null,null,"Last Updated: "]
[null,null,null,"Created For: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S11=0,\"n/a\",S11)","v":"n/a"},null,{"$f":"IF(U11=0,\"n/a\",U11)","v":"n/a"},null,{"$f":"IF(W11=0,\"n/a\",W11)","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spend < $50k = 1.0%;   Spend > $50k =  2.0%"]
["ZM ADD",null,null,null,null,null,null,null,null,"HIDE",null,null,"HIDE","HIDE","HIDE",null,null,null,{"$f":"SUM(IF(\nAND(SUM($AB$17,$AB$21:$AB$22,$AB$25)>=10000,$L$36<50000,L36>=10000),0.01,\nIF(AND(SUM($AB$17,$AB$21:$AB$22,$AB$25)>=10000,$L$36>=50000),0.02,0)))","v":0},null,{"$f":"IF(AND(H24>=8,L36<50000),0.01,IF(AND(H24>=8,L36>=50000),0.02,0))","v":0},null,{"$f":"IF(AND('REBATE MATRIX (NOW)'!$P$1>=5,L36>=10000,L36<50000),0.01,\nIF(AND('REBATE MATRIX (NOW)'!$P$1>=5,L36>=50000),0.02,0))","v":0}]
["SKU Code","RELEVANT",null,"REBATE FINDER. (Minimum Program Purchase to receive rebates is $5,000)","PRODUCT NAME","UNIT SIZE","CATEGORY","# UNITS","ORIGINAL PRICE","INSEASON SUBTOTAL","NOW PRICE/\nUNIT*","INVOICE SUBTOTAL must be a minimum of $5,000 across NOW/FALL program  to receive  rebates","REBATE TIERS AVAILABLE","REBATE TIERS QUALIFIED","QUALIFIED REBATE PER UNIT","VOL BUY \nREBATES**†","ENVU EXTRAS + TIER REBATES","NET PRICE/UNIT \n(all NOW rebates)","TOTAL AFTER REBATE","USE RATE / 1,000 FT2","USE RATE / ACRE","TOTAL ACRES TREATED","COST/ ACRE","COST/ 1,000 FT2"]
[]
[]
["D00000907",{"$f":"H15>0","v":false},null,"$90 off 2+ units","Banol® ","2.5 gal. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A15,PRICING[SKU],0))","v":1302.1600000000001},{"$f":"IF(H15*I15= 0,\"\",H15*I15)","v":""},{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A15,PRICING[SKU],0))","v":1302.1600000000001},{"$f":"IF(H15*K15= 0,\"\",H15*K15)","v":""},{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A15,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H15=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A15,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H15=\"\",\"\",IF(N15=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A15,Rebate_Lookup[SKU CODE],0)),IF(N15=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A15,Rebate_Lookup[SKU CODE],0)),IF(N15=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A15,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},{"$f":"IF(OR(O15=0,O15=\"\"),\"\",H15*O15)","v":""},{"$f":"IFERROR(L15*SUM($G$46:$G$49),\"\")","v":""},{"$f":"IFERROR((L15-SUM(P15:Q15))/H15,\"\")","v":""},{"$f":"IF(AND(H15<>\"\",H15>0), H15*R15,\"\")","v":""},2,{"$f":"T15*43.56","v":87.12},{"$f":"IF(AND(TRIM(U15)<>\"\",TRIM(H15)<>\"\"),(H15*320)/U15,\"\")","v":""},{"$f":"IF(H15<>0,S15/V15,0)","v":0},{"$f":"W15/43.56","v":0}]
["D00000623",false,null,"$525 off 5-9 units; $585 off 10+ units","Castlon™","1 gal. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A16,PRICING[SKU],0))","v":2824.46},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A16,PRICING[SKU],0))","v":2683.24},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A16,Rebate_Lookup[SKU CODE],0))","v":3},{"$f":"IF(H16=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A16,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H16=\"\",\"\",IF(N16=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A16,Rebate_Lookup[SKU CODE],0)),IF(N16=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A16,Rebate_Lookup[SKU CODE],0)),IF(N16=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A16,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"",{"$f":"IFERROR(L16*SUM($G$46:$G$49),\"\")","v":""},{"$f":"IFERROR((L16-SUM(P16:Q16))/H16,\"\")","v":""},"",{"$f":"U16/43.56","v":0.3673094582185491},16,{"$f":"IF(AND(TRIM(U16)<>\"\",TRIM(H16)<>\"\"),(H16*127.999939675621)/U16,\"\")","v":""},0,0]
["D00000914",false,null,"$5 off 9+ units","Chipco® Signature™","11 lb. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A17,PRICING[SKU],0))","v":416.03},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A17,PRICING[SKU],0))","v":395.23},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A17,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H17=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A17,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H17=\"\",\"\",IF(N17=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A17,Rebate_Lookup[SKU CODE],0)),IF(N17=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A17,Rebate_Lookup[SKU CODE],0)),IF(N17=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A17,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",4,{"$f":"T17*43.56","v":174.24},{"$f":"IF(AND(TRIM(U17)<>\"\",TRIM(H17)<>\"\"),(H17*176)/U17,\"\")","v":""},0,0,null,null,"Str/ChipSig",{"$f":"L17","v":""}]
[11008557,false,null,"$410 off 4+ units","Fame® SC Fungicide","64 oz","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A18,PRICING[SKU],0))","v":1592.45},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A18,PRICING[SKU],0))","v":1512.83},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A18,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H18=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A18,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H18=\"\",\"\",IF(N18=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A18,Rebate_Lookup[SKU CODE],0)),IF(N18=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A18,Rebate_Lookup[SKU CODE],0)),IF(N18=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A18,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",{"$f":"U18/43.56","v":0.3673094582185491},16,{"$f":"IF(AND(TRIM(U18)<>\"\",TRIM(H18)<>\"\"),(H18*64)/U18,\"\")","v":""},0,0]
[11009500,false,null,"$1450 off 2-3 units; $1600 off 4+ units","Fame® SC Fungicide","2.5 gal. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A19,PRICING[SKU],0))","v":7054.06},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A19,PRICING[SKU],0))","v":6701.36},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A19,Rebate_Lookup[SKU CODE],0))","v":3},{"$f":"IF(H19=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A19,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H19=\"\",\"\",IF(N19=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A19,Rebate_Lookup[SKU CODE],0)),IF(N19=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A19,Rebate_Lookup[SKU CODE],0)),IF(N19=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A19,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",0.3673094582185491,16,{"$f":"IF(AND(TRIM(U19)<>\"\",TRIM(H19)<>\"\"),(H19*320)/U19,\"\")","v":""},0,0]
["D00001379",false,null,"$185 off 3-5 units; $410 off 6+ units","Indemnify®","17.1 oz. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A20,PRICING[SKU],0))","v":2018.09},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A20,PRICING[SKU],0))","v":1917.19},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A20,Rebate_Lookup[SKU CODE],0))","v":3},{"$f":"IF(H20=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A20,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H20=\"\",\"\",IF(N20=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A20,Rebate_Lookup[SKU CODE],0)),IF(N20=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A20,Rebate_Lookup[SKU CODE],0)),IF(N20=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A20,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",0.39,{"$f":"T20*43.56","v":16.988400000000002},{"$f":"IF(AND(TRIM(U20)<>\"\",TRIM(H20)<>\"\"),(H20*17.1)/U20,\"\")","v":""},0,0]
[81701245,false,null,"$90 off 6+ units","Interface® Stressgard®","2.5 gal. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A21,PRICING[SKU],0))","v":588.9},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A21,PRICING[SKU],0))","v":559.46},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A21,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H21=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A21,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H21=\"\",\"\",IF(N21=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A21,Rebate_Lookup[SKU CODE],0)),IF(N21=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A21,Rebate_Lookup[SKU CODE],0)),IF(N21=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A21,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",4,174.24,{"$f":"IF(AND(TRIM(U21)<>\"\",TRIM(H21)<>\"\"),(H21*320)/U21,\"\")","v":""},0,0,null,null,"Str/ChipSig",{"$f":"L21","v":""}]
["D00000965",false,null,"$90 off 4+ units","Mirage® Stressgard®","2.5 gal. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A22,PRICING[SKU],0))","v":506.68},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A22,PRICING[SKU],0))","v":506.68},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A22,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H22=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A22,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H22=\"\",\"\",IF(N22=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A22,Rebate_Lookup[SKU CODE],0)),IF(N22=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A22,Rebate_Lookup[SKU CODE],0)),IF(N22=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A22,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",1,43.56,{"$f":"IF(AND(TRIM(U22)<>\"\",TRIM(H22)<>\"\"),(H22*320)/U22,\"\")","v":""},0,0,null,null,"Str/ChipSig",""]
[11003880,false,null,"$160 off 6+ units","Rayora® Fungicide ","2.5 gal. bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A23,PRICING[SKU],0))","v":648.91999999999996},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A23,PRICING[SKU],0))","v":648.91999999999996},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A23,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H23=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A23,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H23=\"\",\"\",IF(N23=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A23,Rebate_Lookup[SKU CODE],0)),IF(N23=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A23,Rebate_Lookup[SKU CODE],0)),IF(N23=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A23,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",1.4,60.984000000000002,{"$f":"IF(AND(TRIM(U23)<>\"\",TRIM(H23)<>\"\"),(H23*320)/U23,\"\")","v":""},0,0]
[11014245,false,null,"$15 off 8+ units","Serata® Fungicide ","35 oz","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A24,PRICING[SKU],0))","v":513.66999999999996},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A24,PRICING[SKU],0))","v":487.99},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A24,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H24=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A24,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H24=\"\",\"\",IF(N24=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A24,Rebate_Lookup[SKU CODE],0)),IF(N24=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A24,Rebate_Lookup[SKU CODE],0)),IF(N24=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A24,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",0.6,26.135999999999999,{"$f":"IF(AND(TRIM(U24)<>\"\",TRIM(H24)<>\"\"),(H24*35)/U24,\"\")","v":""},0,0]
["D00000989",false,null,"$15 off 24+ units","Signature™ XTRA Stressgard® ","5.5 lb bottle","Fungicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A25,PRICING[SKU],0))","v":216.24},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A25,PRICING[SKU],0))","v":205.43},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A25,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H25=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A25,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H25=\"\",\"\",IF(N25=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A25,Rebate_Lookup[SKU CODE],0)),IF(N25=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A25,Rebate_Lookup[SKU CODE],0)),IF(N25=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A25,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",4,174.24,{"$f":"IF(AND(TRIM(U25)<>\"\",TRIM(H25)<>\"\"),(H25*88)/U25,\"\")","v":""},0,0,null,null,"Str/ChipSig",{"$f":"L25","v":""}]
[79714858,false,null,"$12 off 48+ units","Celsius®","10 oz. bottle","Herbicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A26,PRICING[SKU],0))","v":134.84},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A26,PRICING[SKU],0))","v":128.1},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A26,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H26=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A26,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H26=\"\",\"\",IF(N26=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A26,Rebate_Lookup[SKU CODE],0)),IF(N26=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A26,Rebate_Lookup[SKU CODE],0)),IF(N26=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A26,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",{"$f":"U26/43.56","v":8.4940312213039479E-2},3.7,{"$f":"IF(AND(TRIM(U26)<>\"\",TRIM(H26)<>\"\"),(H26*10)/U26,\"\")","v":""},0,0]
[79545312,false,null,"$50 off 16+ units","Revolver®","87 oz. bottle","Herbicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A27,PRICING[SKU],0))","v":786.85},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A27,PRICING[SKU],0))","v":747.5},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A27,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H27=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A27,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H27=\"\",\"\",IF(N27=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A27,Rebate_Lookup[SKU CODE],0)),IF(N27=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A27,Rebate_Lookup[SKU CODE],0)),IF(N27=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A27,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",{"$f":"U27/43.56","v":0.39990817263544537},17.420000000000002,{"$f":"IF(AND(TRIM(U27)<>\"\",TRIM(H27)<>\"\"),(H27*87)/U27,\"\")","v":""},0,0]
[11013862,false,null,"$40 off 24+ units","Solitare® WSL Herbicide","2.5 gal. bottle","Herbicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A28,PRICING[SKU],0))","v":269.68},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A28,PRICING[SKU],0))","v":256.2},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A28,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H28=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A28,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H28=\"\",\"\",IF(N28=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A28,Rebate_Lookup[SKU CODE],0)),IF(N28=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A28,Rebate_Lookup[SKU CODE],0)),IF(N28=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A28,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",3.9,{"$f":"T28*43.56","v":169.88400000000001},{"$f":"IF(AND(TRIM(U28)<>\"\",TRIM(H28)<>\"\"),(H28*320)/U28,\"\")","v":""},0,0]
["D00000990",false,null,"n/a","Specticle® FLO (1-6 units)","1 gal. bottle ","Herbicide",null,2150.88,"",2000.31,"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A29,Rebate_Lookup[SKU CODE],0))","v":3},{"$f":"IF(H29=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A29,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H29=\"\",\"\",IF(N29=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A29,Rebate_Lookup[SKU CODE],0)),IF(N29=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A29,Rebate_Lookup[SKU CODE],0)),IF(N29=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A29,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"",null,"","",{"$f":"U29/43.56","v":0.13774104683195593},6,{"$f":"IF(AND(TRIM(U29)<>\"\",TRIM(H29)<>\"\"),(H29*127.999939675621)/U29,\"\")","v":""},0,0]
["D00000990",false,null,"$38 off 7-13 units","Specticle® FLO (7-13 units)","1 gal. bottle ","Herbicide",null,2150.88,"",1876.28,"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A30,Rebate_Lookup[SKU CODE],0))","v":3},2,{"$f":"IF(H30=\"\",\"\",IF(N30=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A30,Rebate_Lookup[SKU CODE],0)),IF(N30=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A30,Rebate_Lookup[SKU CODE],0)),IF(N30=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A30,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"",null,"","",0.13774104683195593,6,{"$f":"IF(AND(TRIM(U30)<>\"\",TRIM(H30)<>\"\"),(H30*127.999939675621)/U30,\"\")","v":""},0,0]
["D00000990",false,null,"$32 off 14-25 units","Specticle® FLO (14-25 units)","1 gal. bottle ","Herbicide",null,1846.25,"",1638.85,"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A31,Rebate_Lookup[SKU CODE],0))","v":3},3,{"$f":"IF(H31=\"\",\"\",IF(N31=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A31,Rebate_Lookup[SKU CODE],0)),IF(N31=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A31,Rebate_Lookup[SKU CODE],0)),IF(N31=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A31,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"",null,"","",0.13774104683195593,6,{"$f":"IF(AND(TRIM(U31)<>\"\",TRIM(H31)<>\"\"),(H31*127.999939675621)/U31,\"\")","v":""},0,0]
["D00000990",false,null,"$131 off 26+ units","Specticle® FLO (26+ units)","1 gal. bottle ","Herbicide",null,1846.25,"",1495.46,"",null,4,{"$f":"IF(H32>0,131,\"\")","v":""},"",null,"","",0.13774104683195593,6,{"$f":"IF(AND(TRIM(U32)<>\"\",TRIM(H32)<>\"\"),(H32*127.999939675621)/U32,\"\")","v":""},0,0]
["D00000992",false,null,"$8 off 20+ units","Specticle® G","50 lb. bag","Herbicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A33,PRICING[SKU],0))","v":134.12},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A33,PRICING[SKU],0))","v":127.42},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A33,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H33=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A33,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H33=\"\",\"\",IF(N33=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A33,Rebate_Lookup[SKU CODE],0)),IF(N33=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A33,Rebate_Lookup[SKU CODE],0)),IF(N33=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A33,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",3.443526170798898,150,{"$f":"IF(AND(TRIM(U33)<>\"\",TRIM(H33)<>\"\"),(H33*50)/U33,\"\")","v":""},0,0]
[81746257,false,null,"$30 off 24+ units","Tribute® Total ","6 oz. bottle","Herbicide",null,{"$f":"INDEX(PRICING[CA In-season Price],MATCH(A34,PRICING[SKU],0))","v":438.23},"",{"$f":"INDEX(PRICING[CA NOW Price],MATCH(A34,PRICING[SKU],0))","v":416.32},"",{"$f":"INDEX(Rebate_Lookup[Instances],MATCH(A34,Rebate_Lookup[SKU CODE],0))","v":2},{"$f":"IF(H34=\"\",\"\",INDEX(Rebate_Lookup[Qualified Rebate Tier],MATCH(A34,Rebate_Lookup[SKU CODE],0)))","v":""},{"$f":"IF(H34=\"\",\"\",IF(N34=1,INDEX(Rebate_Lookup[REB_MOQ_1],MATCH(A34,Rebate_Lookup[SKU CODE],0)),IF(N34=2,INDEX(Rebate_Lookup[REB_MOQ_2],MATCH(A34,Rebate_Lookup[SKU CODE],0)),IF(N34=3,INDEX(Rebate_Lookup[REB_MOQ_3],MATCH(A34,Rebate_Lookup[SKU CODE],0)),\"#err\"))))","v":""},"","","","",2.2956841138659319E-2,1,{"$f":"IF(AND(TRIM(U34)<>\"\",TRIM(H34)<>\"\"),(H34*6)/U34,\"\")","v":""},0,0]
[null,null,null,null,"Durentis FAW Program:"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J15:J34)","v":0},null,{"$f":"SUM(L15:L35)","v":0},null,null,null,{"$f":"SUM(P15:P34)","v":0},{"$f":"SUM(Q15:Q34)","v":0},null,{"$f":"SUM(S17:S34)","v":0}]
[]
[null,null,null,"Summary"]
[null,null,null,"Summary is provided as an estimate only. See program rules and conditions.",null,null,null,null,null,null,null,"TOPCHOICE AND TRIPLE CROWN GOLF ARE RESTRICTED USE PESTICIDES. *Pricing for all states except CA or WA. Must be purchased on a single invoice to receive volume discount price. Purchase tier amount credited for non-agency products is predetermined by Envu. **Must be registered in My Envu Rewards and accept the current Terms and Conditions to participate. ***Customer Fall Solutions and NOW Solutions promotional cumulative purchases (Aug. 1 - Dec. 5, 2025) must be $5,000 or more to qualify for program rebates. Specticle FLO and Ronstar FLO herbicides are not eligible for Envu Extras and tier rebates. New members signed up before Dec. 31, 2025, will receive 2025 NOW/Fall Solutions rebates. All rebates for 2025 NOW/Fall Solutions 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 Aug. 1 and Sept. 30, 2025, to qualify for NOW Solutions. 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. Resale of product(s) purchased within this program will not qualify for rebates. If questions arise, please contact MER at 1-888-456-6464 or email  info@myenvurewards.com. Envu reserves the right to modify any portion thereof, or discontinue this program without prior notice."]
[]
[null,null,null,"Estimated Total Before Off Invoice Discounts:",null,null,{"$f":"J36+L35","v":0}]
[null,null,null,"Estimated Invoice Total:",null,null,{"$f":"L36","v":0}]
[null,null,null,"Estimated Off-Invoice Discount:",null,null,{"$f":"H43/G42","v":{"$error":"#DIV/0!"}},{"$f":"G41-G42","v":0}]
[null,null,null,"Volume Buy Rebate, Envu Extras & Tier Rebates:"]
[null,null,null,"Estimated Total Volume Buy Rebate:",null,null,{"$f":"H45/G42","v":{"$error":"#DIV/0!"}},{"$f":"P36","v":0}]
[null,null,null,"Estimated Tier Rebate Amount:",null,null,{"$f":"IF(S6=TRUE,S5,IF(T6=TRUE,T5,IF(U6=TRUE,U5,IF(V6=TRUE,V5,IF(W6=TRUE,W5,IF(X6=TRUE,X5,\"n/a\"))))))","v":"n/a"},{"$f":"IFERROR(($L$36-SUM($L$29:$L$32,L35))*$G$46,\"n/a\")","v":"n/a"}]
[null,null,null,"Estimated Chipco Signature & Stressgard® Rebate ($10k+):",null,null,{"$f":"S9","v":"n/a"},{"$f":"IFERROR(($L$36-SUM($L$29:$L$32,L35))*$G$47,\"n/a\")","v":"n/a"},null,null,null,"Title Transfer value shown is Redemption Value for the Programs\n \n†ALWAYS 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."]
[null,null,null,"Estimated Serata Rebate (8+ units):",null,null,{"$f":"U9","v":"n/a"},{"$f":"IFERROR(($L$36-SUM($L$29:$L$32,L35))*$G$48,\"n/a\")","v":"n/a"}]
[null,null,null,"Estimated Volume Buy Rebate (5 or more products):",null,null,{"$f":"W9","v":"n/a"},{"$f":"IFERROR(($L$36-SUM($L$29:$L$32,L35))*$G$49,\"n/a\")","v":"n/a"}]
[null,null,null,"Estimated Total Rebate:",null,null,{"$f":"SUM(G45:G49)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H45:H49)","v":0}]
[null,null,null,"Estimated Total Savings (Rebates + Off Invoice Discounts):  ",null,null,{"$f":"H51/G42","v":{"$error":"#DIV/0!"}},{"$f":"H50+H43","v":0}]
[null,null,null,"Estimated Net Total after Rebates & Discounts:",null,null,{"$f":"G42-H50","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"Estimated MER points to be earned: \",TEXT(IF(AND(H50 <>\"\", H50 > 0),H50*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned: 0"}]

{"sheet":"SUMMARY - UNITS (2025)","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[40,2,40,5],[46,2,46,5],[34,2,35,8],[8,7,10,7],[8,8,10,8],[39,2,39,4],[37,6,37,7],[38,2,38,5],[37,2,37,5],[36,2,36,5],[36,6,36,7],[1,2,1,6],[2,3,2,6],[3,3,3,6],[4,3,4,6],[5,3,5,6],[6,3,6,6],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,6,10,6],[8,5,10,5],[51,2,59,8],[60,2,64,8],[41,2,41,5],[47,2,47,5],[45,2,45,5],[44,2,44,5],[43,2,43,5],[42,2,42,5],[47,6,47,7],[49,2,49,7]]}
[]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D4","v":"NAME YOUR DRAFT ORDER HERE:"}]
[null,null,"Description: ",{"$f":"IF('2025 NOW-CALCULATOR - UNITS'!E5=\"\",\"\",'2025 NOW-CALCULATOR - UNITS'!E5)","v":""}]
[null,null,"Distributor/DSR: ",{"$f":"IF('2025 NOW-CALCULATOR - UNITS'!E6=\"\",\"\",'2025 NOW-CALCULATOR - UNITS'!E6)","v":""}]
[null,null,"MER#: ",{"$f":"IF('2025 NOW-CALCULATOR - UNITS'!E7=\"\",\"\",'2025 NOW-CALCULATOR - UNITS'!E7)","v":""}]
[null,null,"Last Updated: ",{"$f":"IF('2025 NOW-CALCULATOR - UNITS'!E8=\"\",\"\",'2025 NOW-CALCULATOR - UNITS'!E8)","v":""}]
[null,null,"Created For: ",{"$f":"IF('2025 NOW-CALCULATOR - UNITS'!E9=\"\",\"\",'2025 NOW-CALCULATOR - UNITS'!E9)","v":""}]
[null,null,"Page 1 of 1"]
[null,null,"PRODUCT NAME","UNIT SIZE","# UNITS","ORIGINAL PRICE/UNIT","NOW \nPRICE/UNIT","SUBTOTAL","NET PRICE/UNIT\n(after rebate)"]
[]
[]
["D00000907",null,"Banol® ","2.5 gal. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H15","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I15","v":1302.1600000000001},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K15","v":1302.1600000000001},{"$f":"E12*G12","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!R15","v":""}]
["D00000623",null,"Castlon™","1 gal. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H16","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I16","v":2824.46},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K16","v":2683.24},{"$f":"E13*G13","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!R16","v":""}]
["D00000914",null,"Chipco® Signature™","11 lb. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H17","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I17","v":416.03},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K17","v":395.23},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R17","v":""}]
[11008557,null,"Fame® SC Fungicide","64 oz",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H18","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I18","v":1592.45},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K18","v":1512.83},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R18","v":""}]
[11009500,null,"Fame® SC Fungicide","2.5 gal. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H19","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I19","v":7054.06},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K19","v":6701.36},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R19","v":""}]
["D00001379",null,"Indemnify®","17.1 oz. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H20","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I20","v":2018.09},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K20","v":1917.19},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R20","v":""}]
[81701245,null,"Interface® Stressgard®","2.5 gal. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H21","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I21","v":588.9},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K21","v":559.46},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R21","v":""}]
["D00000965",null,"Mirage® Stressgard®","2.5 gal. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H22","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I22","v":506.68},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K22","v":506.68},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R22","v":""}]
[11003880,null,"Rayora® Fungicide ","2.5 gal. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H23","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I23","v":648.91999999999996},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K23","v":648.91999999999996},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R23","v":""}]
[11014245,null,"Serata® Fungicide ","35 oz",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H24","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I24","v":513.66999999999996},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K24","v":487.99},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R24","v":""}]
["D00000989",null,"Signature™ XTRA Stressgard® ","5.5 lb bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H25","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I25","v":216.24},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K25","v":205.43},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R25","v":""}]
[79714858,null,"Celsius®","10 oz. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H26","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I26","v":134.84},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K26","v":128.1},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R26","v":""}]
[79545312,null,"Revolver®","87 oz. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H27","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I27","v":786.85},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K27","v":747.5},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R27","v":""}]
[11013862,null,"Solitare® WSL Herbicide","2.5 gal. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H28","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I28","v":269.68},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K28","v":256.2},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R28","v":""}]
["D00000990",null,"Specticle® FLO (1-6 units)","1 gal. bottle ",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H29","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I29","v":2150.88},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K29","v":2000.31},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R29","v":""}]
["D00000990",null,"Specticle® FLO (7-13 units)","1 gal. bottle ",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H30","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I30","v":2150.88},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K30","v":1876.28},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R30","v":""}]
["D00000990",null,"Specticle® FLO (14-25 units)","1 gal. bottle ",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H31","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I31","v":1846.25},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K31","v":1638.85},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R31","v":""}]
["D00000990",null,"Specticle® FLO (26+ units)","1 gal. bottle ",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H32","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I32","v":1846.25},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K32","v":1495.46},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R32","v":""}]
["D00000992",null,"Specticle® G","50 lb. bag",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H33","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I33","v":134.12},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K33","v":127.42},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R33","v":""}]
[81746257,null,"Tribute® Total ","6 oz. bottle",{"$f":"'2025 NOW-CALCULATOR - UNITS'!H34","v":0},{"$f":"'2025 NOW-CALCULATOR - UNITS'!I34","v":438.23},{"$f":"'2025 NOW-CALCULATOR - UNITS'!K34","v":416.32},0,{"$f":"'2025 NOW-CALCULATOR - UNITS'!R34","v":""}]
[null,null,"Durentis FAW Program:",null,null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!L35","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H32)","v":0}]
[null,null,"Summary"]
[null,null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D41","v":"Estimated Total Before Off Invoice Discounts:"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G41","v":0}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D42","v":"Estimated Invoice Total:"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G42","v":0}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D43","v":"Estimated Off-Invoice Discount:"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G43","v":{"$error":"#DIV/0!"}},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H43","v":0}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D44","v":"Volume Buy Rebate, Envu Extras & Tier Rebates:"}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D45","v":"Estimated Total Volume Buy Rebate:"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G45","v":{"$error":"#DIV/0!"}},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H45","v":0}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D46","v":"Estimated Tier Rebate Amount:"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G46","v":"n/a"},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H46","v":"n/a"}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D47","v":"Estimated Chipco Signature & Stressgard® Rebate ($10k+):"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G47","v":"n/a"},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H47","v":"n/a"}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D48","v":"Estimated Serata Rebate (8+ units):"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G48","v":"n/a"},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H48","v":"n/a"}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D49","v":"Estimated Volume Buy Rebate (5 or more products):"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G49","v":"n/a"},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H49","v":"n/a"}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D50","v":"Estimated Total Rebate:"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G50","v":{"$error":"#DIV/0!"}},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H50","v":0}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D51","v":"Estimated Total Savings (Rebates + Off Invoice Discounts):  "},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G51","v":{"$error":"#DIV/0!"}},{"$f":"'2025 NOW-CALCULATOR - UNITS'!H51","v":0}]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D52","v":"Estimated Net Total after Rebates & Discounts:"},null,null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!G52","v":0}]
[]
[null,null,{"$f":"'2025 NOW-CALCULATOR - UNITS'!D54","v":"Estimated MER points to be earned: 0"}]
[]
[null,null,"TOPCHOICE AND TRIPLE CROWN GOLF ARE RESTRICTED USE PESTICIDES. *Pricing for all states except CA or WA. Must be purchased on a single invoice to receive volume discount price. Purchase tier amount credited for non-agency products is predetermined by Envu. **Must be registered in My Envu Rewards and accept the current Terms and Conditions to participate. ***Customer Fall Solutions and NOW Solutions promotional cumulative purchases (Aug. 1 - Dec. 5, 2025) must be $5,000 or more to qualify for program rebates. Specticle FLO and Ronstar FLO herbicides are not eligible for Envu Extras and tier rebates. New members signed up before Dec. 31, 2025, will receive 2025 NOW/Fall Solutions rebates. All rebates for 2025 NOW/Fall Solutions 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 Aug. 1 and Sept. 30, 2025, to qualify for NOW Solutions. 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. Resale of product(s) purchased within this program will not qualify for rebates. If questions arise, please contact MER at 1-888-456-6464 or email  info@myenvurewards.com. Envu reserves the right to modify any portion thereof, or discontinue this program without prior notice."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Title Transfer value shown is Redemption Value for the Programs\n \n†ALWAYS 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":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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,"D00000665",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B3,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B3)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000666",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B4,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B4)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,87300722,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B5,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B5)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000898",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B6,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B6)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000907",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B7,PRICING[SKU],0))","v":"Banol®"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"2.5 gal "},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B7)","v":2},0,2,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":90},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,11008351,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B8,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B8)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000623",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B9,PRICING[SKU],0))","v":"Castlon™"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"1 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B9)","v":3},0,5,10,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":525},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":585},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00000624",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B10,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},3,0,4,8,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,79714858,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B11,PRICING[SKU],0))","v":"Celsius® WG"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"10 oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B11)","v":2},0,48,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":12},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00000911",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B12,PRICING[SKU],0))","v":"Celsius® XTRA"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"10 oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B12)","v":2},0,16,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":12},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000914",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B13,PRICING[SKU],0))","v":"Chipco® Signature™"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"11 lb"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B13)","v":2},0,9,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":5},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00001373",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B14,PRICING[SKU],0))","v":"Densicor®"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"51 oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B14)","v":2},0,3,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":100},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,11008357,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B15,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B15)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,11008474,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B16,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B16)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,11008336,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B17,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B17)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00001040",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B18,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B18)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,11008557,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B19,PRICING[SKU],0))","v":"Fame® SC Fungicide"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"64 oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B19)","v":2},0,4,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":410},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,11009500,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B20,PRICING[SKU],0))","v":"Fame® SC Fungicide"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"2.5 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B20)","v":3},0,2,4,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":1450},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":1600},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,3944704,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B21,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B21)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00001379",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B22,PRICING[SKU],0))","v":"Indemnify®"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"17.1 fl oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B22)","v":3},0,3,6,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":185},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":410},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,81701245,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B23,PRICING[SKU],0))","v":"Interface® Stressgard®"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"2.5 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B23)","v":2},0,6,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":90},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00000961",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B24,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B24)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000965",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B25,PRICING[SKU],0))","v":"Mirage® Stressgard®"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"2.5 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B25)","v":2},0,4,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":90},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00000913",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B26,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B26)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,11008447,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B27,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B27)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,11003880,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B28,PRICING[SKU],0))","v":"Rayora® Fungicide "},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"2.5 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B28)","v":2},0,6,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":160},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00000125",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B29,PRICING[SKU],0))","v":"Resilia™"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"2.72 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B29)","v":3},0,4,15,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":65},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":180},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,79545312,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B30,PRICING[SKU],0))","v":"Revolver®"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"87 fl oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B30)","v":2},0,16,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":50},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,79850980,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B31,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B31)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,427709,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B32,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B32)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,11014245,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B33,PRICING[SKU],0))","v":"Serata® Fungicide "},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"35 oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B33)","v":2},0,8,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":15},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00000989",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B34,PRICING[SKU],0))","v":"Signature™ XTRA Stressgard® "},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"5.5 lb"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B34)","v":2},0,24,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":15},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,11013862,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B35,PRICING[SKU],0))","v":"Solitare® WSL Herbicide"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"2.5 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B35)","v":2},0,24,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":40},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,"D00000990",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B36,PRICING[SKU],0))","v":"Specticle® FLO "},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"1 gal"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B36)","v":3},0,7,14,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":38},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":32},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":4},{"$f":"IF(OR('2025 NOW-CALCULATOR - UNITS'!H29>6,'2025 NOW-CALCULATOR - UNITS'!H30>6,'2025 NOW-CALCULATOR - UNITS'!H31>6,'2025 NOW-CALCULATOR - UNITS'!H32>6),TRUE,0)","v":0},null,{"$f":"COUNTIF('2025 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":4}]
[null,"D00000992",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B37,PRICING[SKU],0))","v":"Specticle® G"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"50 lb"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B37)","v":2},0,20,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":8},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]
[null,11008457,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B38,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B38)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000675",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B39,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B39)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000674",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B40,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B40)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000669",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B41,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B41)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000670",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B42,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B42)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000673",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B43,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B43)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000672",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B44,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B44)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00000671",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B45,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B45)","v":0},175,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,"D00001012",{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Product],MATCH(B46,PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B46)","v":0},0,null,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":0}]
[null,81746257,{"$f":"INDEX(PRICING[Agency/TT],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"A"},{"$f":"INDEX(PRICING[Product],MATCH(B47,PRICING[SKU],0))","v":"Tribute® Total"},{"$f":"INDEX(PRICING[Size],MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[SKU],0))","v":"6 oz"},{"$f":"COUNTIFS(PRICING[Program],\"NOW\",PRICING[SKU],B47)","v":2},0,24,null,{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],1)","v":0},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],2)","v":30},{"$f":"SUMIFS(PRICING[Rebate $],PRICING[Program],\"NOW\",PRICING[SKU],Rebate_Lookup[[#This Row],[SKU CODE]],PRICING[Set],3)","v":0},{"$f":"INDEX('2025 NOW-CALCULATOR - UNITS'!H:H,MATCH(Rebate_Lookup[[#This Row],[SKU CODE]],'2025 NOW-CALCULATOR - 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 NOW-CALCULATOR - 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 NOW-CALCULATOR - UNITS'!A:A,Rebate_Lookup[[#This Row],[SKU CODE]])","v":1}]

{"sheet":"2025 NOW_EOP_LL","index":3,"n_rows":123,"n_cols":32,"rows_kept":123,"cut":false,"hidden":true,"merged":[]}
["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"]
["Envu","A","G","NST","F","X","NOW",79895402,null,"D00000907","Banol®","2.5 gal ",1267,1267,0,null,null,1267,1302.1600000000001,1302.1600000000001,1302.1600000000001,1275.8499999999999,1275.8499999999999,1275.8499999999999,320,2,87.12,7.9187500000000002,344.94075000000004,0,null,1]
["Envu","A","G","NST","F","X","NOW",79895402,null,"D00000907","Banol®","2.5 gal ",1267,1267,0,"2+",90,1177,1302.1600000000001,1302.1600000000001,1212.1600000000001,1275.8499999999999,1275.8499999999999,1185.8499999999999,320,2,87.12,7.3562500000000002,320.43825000000004,7.1033938437253363E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J2,AF2+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW",null,null,"D00000623","Castlon™","1 gal",2748.2,2610.79,137.40999999999985,null,null,2610.79,2824.46,2683.24,2683.24,2767.44,2629.07,2629.07,128,0.36,15.6816,7.3428468749999993,319.85440987499999,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J3,AF3+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW",null,null,"D00000623","Castlon™","1 gal",2748.2,2610.79,137.40999999999985,"5-9",525,2085.79,2824.46,2683.24,2158.2399999999998,2767.44,2629.07,2104.0700000000002,128,0.36,15.6816,5.8662843749999993,255.53534737499999,0.24103413143148233,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J4,AF4+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW",null,null,"D00000623","Castlon™","1 gal",2748.2,2610.79,137.40999999999985,"10+",585,2025.79,2824.46,2683.24,2098.2399999999998,2767.44,2629.07,2044.0700000000002,128,0.36,15.6816,5.697534375,248.18459737499998,0.26286660359508041,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J5,AF5+1,1)","v":3}]
["Envu","A","GL","ST","H","X","NOW",null,null,79714858,"Celsius® WG","10 oz",131.19999999999999,124.64,6.5599999999999881,null,null,124.64,134.84,128.1,128.1,132.12,125.51,125.51,10,8.4940312213039507E-2,3.7000000000000011,1.0586960514233243,46.116800000000012,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J6,AF6+1,1)","v":1}]
["Envu","A","GL","ST","H","X","NOW",null,null,79714858,"Celsius® WG","10 oz",131.19999999999999,124.64,6.5599999999999881,"48+",12,112.64,134.84,128.1,116.1,132.12,125.51,113.51,10,8.4940312213039507E-2,3.7000000000000011,0.95676767676767693,41.676800000000007,0.14146341463414625,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J7,AF7+1,1)","v":2}]
["Envu","A","GL","ST","H","X","NOW","86773201",null,"D00000911","Celsius® XTRA","10 oz",166.4,158.08000000000001,8.3199999999999932,null,null,158.08000000000001,"NA","NA","NA",167.56,159.19,159.19,10,0.17217630853994489,7.5,2.721763085399449,118.56000000000002,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J8,AF8+1,1)","v":1}]
["Envu","A","GL","ST","H","X","NOW","86773201",null,"D00000911","Celsius® XTRA","10 oz",166.4,158.08000000000001,8.3199999999999932,"16+",12,146.08000000000001,"NA","NA","NA",167.56,159.19,147.19,10,0.17217630853994489,7.5,2.5151515151515151,109.56,0.12211538461538463,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J9,AF9+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW","87276341",null,"D00000914","Chipco® Signature™","11 lb",404.8,384.56,20.240000000000009,null,0,384.56,416.03,395.23,395.23,407.64,387.25,387.25,10,4,174.24,153.82400000000001,6700.573440000001,5.0000000000000044E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J10,AF10+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW","87276341",null,"D00000914","Chipco® Signature™","11 lb",404.8,384.56,20.240000000000009,"9+",5,379.56,416.03,395.23,390.23,407.64,387.25,382.25,10,4,174.24,151.82400000000001,6613.4534400000011,6.2351778656126511E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J11,AF11+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW","87348709","D00000926","D00001373","Densicor®","51 oz",702.8,667.66,35.139999999999986,null,null,667.66,"NA","NA","NA",707.72,672.33,672.33,51,0.19600000000000001,8.5377600000000005,2.5659090196078429,111.77099689411764,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J12,AF12+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW","87348709","D00000926","D00001373","Densicor®","51 oz",702.8,667.66,35.139999999999986,"3+",100,567.66,"NA","NA","NA",707.72,672.33,572.33000000000004,51,0.19600000000000001,8.5377600000000005,2.1815952941176473,95.030291011764717,0.19228799089356863,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J13,AF13+1,1)","v":2}]
["FMC","A","GL","NST","F","X","NOW",null,null,11008557,"Fame® SC Fungicide","64 oz",1549.45,1471.98,77.470000000000027,null,null,1471.98,1592.45,1512.83,1512.83,1560.3,1482.28,1482.28,64,0.36,15.6816,8.2798874999999992,360.67189949999999,4.9998386524250593E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J14,AF14+1,1)","v":1}]
["FMC","A","GL","NST","F","X","NOW",null,null,11008557,"Fame® SC Fungicide","64 oz",1549.45,1471.98,77.470000000000027,"4+",410,1061.98,1592.45,1512.83,1102.83,1560.3,1482.28,1072.28,64,0.36,15.6816,5.9736374999999997,260.21164950000002,0.3146084094356062,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J15,AF15+1,1)","v":2}]
["FMC","A","GL","NST","F","X","NOW",null,null,11009500,"Fame® SC Fungicide","2.5 gal",6863.6,6520.42,343.18000000000029,null,null,6520.42,7054.06,6701.36,6701.36,6911.64,6566.06,6566.06,320,0.36,15.6816,7.3354724999999998,319.53318210000003,5.0000000000000044E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J16,AF16+1,1)","v":1}]
["FMC","A","GL","NST","F","X","NOW",null,null,11009500,"Fame® SC Fungicide","2.5 gal",6863.6,6520.42,343.18000000000029,"2-3",1450,5070.42,7054.06,6701.36,5251.36,6911.64,6566.06,5116.0600000000004,320,0.36,15.6816,5.7042225000000002,248.47593209999999,0.26125939740078097,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J17,AF17+1,1)","v":2}]
["FMC","A","GL","NST","F","X","NOW",null,null,11009500,"Fame® SC Fungicide","2.5 gal",6863.6,6520.42,343.18000000000029,"4+",1600,4920.42,7054.06,6701.36,5101.3599999999997,6911.64,6566.06,4966.0600000000004,320,0.36,15.6816,5.5354725,241.12518210000002,0.28311381782155143,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J18,AF18+1,1)","v":3}]
["Envu","A","G","NST","F","X","NOW","84411426","D00000940","D00001379","Indemnify®","17.1 fl oz",1963.6,1865.42,98.179999999999836,null,null,1865.42,2018.09,1917.19,1917.19,1977.34,1878.48,1878.48,17.100000000000001,0.39,16.988400000000002,42.544666666666672,1853.2456800000002,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J19,AF19+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW","84411426","D00000940","D00001379","Indemnify®","17.1 fl oz",1963.6,1865.42,98.179999999999836,"3-5",185,1680.42,2018.09,1917.19,1732.19,1977.34,1878.48,1693.48,17.100000000000001,0.39,16.988400000000002,38.32536842105263,1669.4530484210527,0.14421470767977174,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J20,AF20+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW","84411426","D00000940","D00001379","Indemnify®","17.1 fl oz",1963.6,1865.42,98.179999999999836,"6+",410,1455.42,2018.09,1917.19,1507.19,1977.34,1878.48,1468.48,17.100000000000001,0.39,16.988400000000002,33.193789473684213,1445.9214694736845,0.25880016296598074,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J21,AF21+1,1)","v":3}]
["Envu","A","G","NST","F","X","NOW",null,null,81701245,"Interface® Stressgard®","2.5 gal",573,544.35,28.649999999999977,null,null,544.35,588.9,559.46,559.46,577,548.16,548.16,320,4,174.24,6.8043750000000003,296.39857500000005,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J22,AF22+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW",null,null,81701245,"Interface® Stressgard®","2.5 gal",573,544.35,28.649999999999977,"6+",90,454.35,588.9,559.46,469.46000000000004,577,548.16,458.15999999999997,320,4,174.24,5.6793750000000003,247.39357500000003,0.20706806282722512,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J23,AF23+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW","80973942",null,"D00000965","Mirage® Stressgard®","2.5 gal",493,493,0,null,null,493,506.68,506.68,506.68,496.45,496.45,496.45,320,1,43.56,1.5406249999999999,67.109624999999994,0,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J24,AF24+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW","80973942",null,"D00000965","Mirage® Stressgard®","2.5 gal",493,493,0,"4+",90,403,506.68,506.68,416.68,496.45,496.45,406.45,320,1,43.56,1.2593749999999999,54.858375000000002,0.18255578093306291,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J25,AF25+1,1)","v":2}]
["FMC","A","G","NST","F","X","NOW",null,null,11003880,"Rayora® Fungicide ","2.5 gal",631.4,631.4,0,null,null,631.4,648.91999999999996,648.91999999999996,648.91999999999996,635.82000000000005,635.82000000000005,635.82000000000005,320,1.22,53.1432,2.4072125,104.8581765,0,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J26,AF26+1,1)","v":1}]
["FMC","A","G","NST","F","X","NOW",null,null,11003880,"Rayora® Fungicide ","2.5 gal",631.4,631.4,0,"6+",160,471.4,648.91999999999996,648.91999999999996,488.91999999999996,635.82000000000005,635.82000000000005,475.82000000000005,320,1.22,53.1432,1.7972124999999999,78.286576499999995,0.25340513145391197,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J27,AF27+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW",null,null,"D00000125","Resilia™","2.72 gal",946.56,946.56,0,null,null,946.56,"NA","NA","NA",953.2,953.2,953.2,348.16,4,174.24,10.874999999999998,473.71499999999997,0,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J28,AF28+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW",null,null,"D00000125","Resilia™","2.72 gal",946.56,946.56,0,"4-14",65,881.56,"NA","NA","NA",953.2,953.2,888.2,348.16,4,174.24,10.128216911764705,441.18512867647058,6.8669709263015521E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J29,AF29+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW",null,null,"D00000125","Resilia™","2.72 gal",946.56,946.56,0,"15+",180,766.56,"NA","NA","NA",953.2,953.2,773.2,348.16,4,174.24,8.806985294117645,383.63227941176461,0.1901622718052739,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J30,AF30+1,1)","v":3}]
["Envu","A","GL","ST","H","X","NOW",null,null,79545312,"Revolver®","87 fl oz",765.6,727.32,38.279999999999973,null,null,727.32,786.85,747.5,747.5,770.96,732.41,732.41,87,0.3994490358126721,17.399999999999999,3.3393939393939394,145.464,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J31,AF31+1,1)","v":1}]
["Envu","A","GL","ST","H","X","NOW",null,null,79545312,"Revolver®","87 fl oz",765.6,727.32,38.279999999999973,"16+",50,677.32,786.85,747.5,697.5,770.96,732.41,682.41,87,0.3994490358126721,17.399999999999999,3.1098255280073461,135.464,0.11530825496342734,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J32,AF32+1,1)","v":2}]
["FMC","A","G","NST","F","X","NOW",null,null,11014245,"Serata® Fungicide ","35 oz",499.8,474.81,24.990000000000009,null,null,474.81,513.66999999999996,487.99,487.99,503.3,478.13,478.13,35,0.6,26.135999999999999,8.1395999999999997,354.56097599999998,5.0000000000000044E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J33,AF33+1,1)","v":1}]
["FMC","A","G","NST","F","X","NOW",null,null,11014245,"Serata® Fungicide ","35 oz",499.8,474.81,24.990000000000009,"8+",15,459.81,513.66999999999996,487.99,472.99,503.3,478.13,463.13,35,0.6,26.135999999999999,7.8824571428571426,343.35983314285716,8.0012004801920833E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J34,AF34+1,1)","v":2}]
["Envu","A","G","NST","F","X","NOW","85355422",null,"D00000989","Signature™ XTRA Stressgard® ","5.5 lb",210.4,199.88,10.52000000000001,null,null,199.88,216.24,205.43,205.43,211.88,201.28,201.28,88,4,174.24,9.0854545454545459,395.76240000000001,5.0000000000000044E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J35,AF35+1,1)","v":1}]
["Envu","A","G","NST","F","X","NOW","85355422",null,"D00000989","Signature™ XTRA Stressgard® ","5.5 lb",210.4,199.88,10.52000000000001,"24+",15,184.88,216.24,205.43,190.43,211.88,201.28,186.28,88,4,174.24,8.4036363636363642,366.06240000000003,0.12129277566539931,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J36,AF36+1,1)","v":2}]
["FMC","A","GL","NST","H","X","NOW",null,null,11013862,"Solitare® WSL Herbicide","2.5 gal",262.39999999999998,249.28,13.119999999999976,null,null,249.28,269.68,256.2,256.2,264.24,251.02,251.02,320,3.9,169.88400000000001,3.0381,132.33963600000001,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J37,AF37+1,1)","v":1}]
["FMC","A","GL","NST","H","X","NOW",null,null,11013862,"Solitare® WSL Herbicide","2.5 gal",262.39999999999998,249.28,13.119999999999976,"24+",40,209.28,269.68,256.2,216.2,264.24,251.02,211.02,320,3.9,169.88400000000001,2.5506000000000002,111.10413600000001,0.20243902439024386,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J38,AF38+1,1)","v":2}]
["Envu","A","GL","ST","H","X","NOW","86775387",null,"D00000990","Specticle® FLO ","1 gal",2092.8000000000002,1946.3,146.50000000000023,"1-6",null,1946.3,2150.88,2000.31,2000.31,2107.44,1959.92,1959.92,128,0.13774104683195593,6.0000000000000009,2.0944171831955924,91.232812500000009,7.0001911314984788E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J39,AF39+1,1)","v":1}]
["Envu","A","GL","ST","H","X","NOW","86775387",null,"D00000990","Specticle® FLO ","1 gal",2092.8000000000002,1862.59,230.21000000000026,"7-13",38,1824.59,2150.88,1914.28,1876.28,2107.44,1875.63,1837.63,128,0.13774104683195593,6.0000000000000009,1.9634448174931129,85.527656250000007,0.12815844801223253,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J40,AF40+1,1)","v":2}]
["Envu","A","GL","ST","H","X","NOW","86775387",null,"D00000990","Specticle® FLO ","1 gal",1796.4,1625.74,170.66000000000008,"14-25",32,1593.74,1846.25,1670.85,1638.85,1808.98,1637.12,1605.12,128,0.13774104683195593,6.0000000000000009,1.7150266873278237,74.706562500000018,0.1128145179247384,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J41,AF41+1,1)","v":3}]
["Envu","A","GL","ST","H","X","NOW","84056146",null,"D00000992","Specticle® G","50 lb",130.5,123.98,6.519999999999996,null,null,123.98,134.12,127.42,127.42,131.5,124.85,124.85,800,3.443526170798898,150,0.53366046831955927,23.24625,4.9961685823754709E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J42,AF42+1,1)","v":1}]
["Envu","A","GL","ST","H","X","NOW","84056146",null,"D00000992","Specticle® G","50 lb",130.5,123.98,6.519999999999996,"20+",8,115.98,134.12,127.42,119.42,131.5,124.85,116.85,800,3.443526170798898,150,0.49922520661157022,21.74625,0.11126436781609195,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J43,AF43+1,1)","v":2}]
["Envu","A","GL","ST","H","X","NOW",null,null,81746257,"Tribute® Total","6 oz",426.4,405.08,21.319999999999993,null,null,405.08,438.23,416.32,416.32,429.38,407.92,407.92,6,2.2956841138659319E-2,1,1.5498928680746862,67.513333333333335,4.9999999999999933E-2,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J44,AF44+1,1)","v":1}]
["Envu","A","GL","ST","H","X","NOW",null,null,81746257,"Tribute® Total","6 oz",426.4,405.08,21.319999999999993,"24+",30,375.08,438.23,416.32,386.32,429.38,407.92,377.92,6,2.2956841138659319E-2,1,1.4351086623813893,62.513333333333328,0.12035647279549722,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J45,AF45+1,1)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J46,AF46+1,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J47,AF47+1,1)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J48,AF48+1,1)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J49,AF49+1,1)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J50,AF50+1,1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J51,AF51+1,1)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J52,AF52+1,1)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J53,AF53+1,1)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J54,AF54+1,1)","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J55,AF55+1,1)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J56,AF56+1,1)","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J57,AF57+1,1)","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J58,AF58+1,1)","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J59,AF59+1,1)","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J60,AF60+1,1)","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J61,AF61+1,1)","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J62,AF62+1,1)","v":17}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J63,AF63+1,1)","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J64,AF64+1,1)","v":19}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J65,AF65+1,1)","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J66,AF66+1,1)","v":21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J67,AF67+1,1)","v":22}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J68,AF68+1,1)","v":23}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J69,AF69+1,1)","v":24}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J70,AF70+1,1)","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J71,AF71+1,1)","v":26}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J72,AF72+1,1)","v":27}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J73,AF73+1,1)","v":28}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J74,AF74+1,1)","v":29}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J75,AF75+1,1)","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J76,AF76+1,1)","v":31}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J77,AF77+1,1)","v":32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J78,AF78+1,1)","v":33}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J79,AF79+1,1)","v":34}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J80,AF80+1,1)","v":35}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J81,AF81+1,1)","v":36}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J82,AF82+1,1)","v":37}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J83,AF83+1,1)","v":38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J84,AF84+1,1)","v":39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J85,AF85+1,1)","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J86,AF86+1,1)","v":41}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J87,AF87+1,1)","v":42}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J88,AF88+1,1)","v":43}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J89,AF89+1,1)","v":44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J90,AF90+1,1)","v":45}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J91,AF91+1,1)","v":46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J92,AF92+1,1)","v":47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J93,AF93+1,1)","v":48}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J94,AF94+1,1)","v":49}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J95,AF95+1,1)","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J96,AF96+1,1)","v":51}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J97,AF97+1,1)","v":52}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J98,AF98+1,1)","v":53}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J99,AF99+1,1)","v":54}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J100,AF100+1,1)","v":55}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J101,AF101+1,1)","v":56}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J102,AF102+1,1)","v":57}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J103,AF103+1,1)","v":58}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J104,AF104+1,1)","v":59}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J105,AF105+1,1)","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J106,AF106+1,1)","v":61}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J107,AF107+1,1)","v":62}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J108,AF108+1,1)","v":63}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J109,AF109+1,1)","v":64}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J110,AF110+1,1)","v":65}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J111,AF111+1,1)","v":66}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J112,AF112+1,1)","v":67}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J113,AF113+1,1)","v":68}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J114,AF114+1,1)","v":69}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J115,AF115+1,1)","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J116,AF116+1,1)","v":71}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J117,AF117+1,1)","v":72}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J118,AF118+1,1)","v":73}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J119,AF119+1,1)","v":74}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J120,AF120+1,1)","v":75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J121,AF121+1,1)","v":76}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PRICING[[#This Row],[SKU]]=J122,AF122+1,1)","v":77}]

{"sheet":"Sheet4","index":4,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[]
[]
["SKU","Product","Program","Agency/TT","NOW Price"]
[427709,"Sencor 75","NOW","TT",710.1]
[3944704,"Forbid","NOW","TT",304.73999999999995]
[11003880,"Rayora","NOW","A",631.4]
[11008336,"Dismiss® Turf Herbicide","NOW","TT",363.59999999999997]
[11008351,"Blindside® Herbicide ","NOW","TT",166.86]
[11008357,"Dismiss® CA Herbicide","NOW","TT",81.78]
[11008447,"QuickSilver® ","NOW","TT",199.92]
[11008457,"Talstar® Select Insecticide (RUP) ","NOW","TT",60.72]
[11008474,"Dismiss® South Herbicide","NOW","TT",186.66]
[11008520,"Triple Crown T&O","NOW","A",330.79]
[11008521,"Triple Crown Golf (RUP)","NOW","A",330.79]
[11008522,"Solitare","NOW","A",566.58000000000004]
[11008557,"Fame SC","NOW","A",1471.98]
[11008589,"Dismiss NXT","NOW","A",479.56]
[11009495,"Scion","NOW","A",156.6]
[11009500,"Fame SC","NOW","A",6520.42]
[11013862,"Solitare WSL","NOW","A",249.28]
[11014245,"Serata","NOW","A",474.81]
[11015990,"Tarvecta","NOW","A",772.8]
[79545312,"Revolver","NOW","A",720.1]
[79714858,"Celsius","NOW","A",124.64]
[79850980,"Revolver","NOW","TT",349.73999999999995]
[81701245,"Interface Stressgard","NOW","A",544.35]
[81746257,"Tribute Total","NOW","A",405.08]
[87300722,"Acclaim Extra","NOW","TT",798.24]
["D00000125","Resilia","NOW","A",946.56]
["D00000623","Castlon","NOW","A",2610.79]
["D00000665","Acclaim Accelerate","NOW","TT",55.32]
["D00000666","Acclaim Accelerate","NOW","TT",266.58]
["D00000669","Terradex Power Premix","NOW","TT",226.32]
["D00000670","Terradex Power Premix","NOW","TT",2474.64]
["D00000671","Terradex Quick Strike","NOW","TT",2172.9]
["D00000672","Terradex Quick Strike","NOW","TT",191.16]
["D00000673","Terradex Quick Strike","NOW","TT",80.459999999999994]
["D00000674","Terradex C&B","NOW","TT",274.14]
["D00000675","Terradex C&B","NOW","TT",114.66]
["D00000898","Armada 50 WDG","NOW","TT",136.79999999999998]
["D00000907","Banol®","NOW","A",1267]
["D00000911","Celsius XTRA","NOW","A",158.08000000000001]
["D00000913","Proxy","NOW","TT",122.69999999999999]
["D00000914","Chipco Signature","NOW","A",383.8]
["D00000961","Merit 2F","NOW","TT",63]
["D00000965","Mirage Stressgard","NOW","A",493]
["D00000989","Signature XTRA Stressgard","NOW","A",199.88]
["D00000990","Specticle FLO","NOW","A",1643.71]
[null,null,null,null,1883.52]
[null,null,null,null,1967.23]
["D00000992","Specticle G","NOW","A",123.98]
["D00000998","Tartan Stressgard","NOW","A",893]
[null,null,null,null,981.35]
["D00001012","TopChoice","NOW","TT",76.2]
["D00001040","Dylox 420 SL","NOW","TT",270.45599999999996]
["D00001373","Densicor","NOW","A",667.66]
["D00001379","Indemnify","NOW","A",1865.42]