{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2024 FALL CALCULATOR","SUMMARY","Pricing"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":15,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2024 FALL CALCULATOR","index":0,"n_rows":107,"n_cols":52,"rows_kept":107,"cut":false,"hidden":false,"merged":[[66,51,68,51],[66,24,68,24],[66,25,68,25],[66,26,68,26],[66,27,68,27],[66,28,68,28],[66,29,68,29],[66,30,68,30],[66,31,68,31],[66,32,68,32],[66,33,68,33],[66,34,68,34],[66,38,68,38],[66,39,68,39],[24,31,26,31],[55,30,58,30],[66,50,68,50],[66,48,68,48],[66,49,68,49],[24,48,26,48],[24,49,26,49],[24,38,26,38],[24,39,26,39],[24,37,26,37],[24,30,26,30],[24,29,26,29],[66,37,68,37],[24,27,26,27],[24,28,26,28],[66,1,68,1],[55,1,58,1],[24,16,26,16],[24,14,25,14],[24,7,26,7],[24,8,26,8],[49,1,51,1],[24,26,26,26],[66,12,68,12],[66,13,68,13],[66,17,68,17],[24,20,26,20],[106,1,106,4],[24,25,26,25],[24,9,26,9],[24,10,26,10],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,6,26,6],[24,19,26,19],[24,24,26,24],[24,15,26,15],[102,1,102,3],[100,1,100,3],[24,5,26,5],[101,1,101,3],[103,1,103,3],[104,1,104,3],[98,1,98,3],[99,1,99,3],[66,16,68,16],[97,1,97,3],[96,1,96,3],[84,1,87,1],[66,11,67,11],[66,2,68,2],[66,3,68,3],[66,4,68,4],[66,5,68,5],[66,6,68,6],[66,7,68,7],[24,21,26,21],[66,21,68,21],[94,1,94,4],[66,14,67,14],[66,15,68,15],[66,8,68,8],[24,18,26,18],[66,9,68,9],[66,10,68,10],[66,18,68,18],[66,19,68,19],[66,20,68,20],[44,1,46,1],[15,1,15,2],[24,11,25,11],[24,13,26,13],[24,12,26,12],[24,17,26,17]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":" V13","v":"Fall Solutions National Calculator - version 2024-0009-0017"}]
[]
[null,{"$f":"IF(C22=\"National\", \"NATIONAL\", IF(C22=\"CA\",\"CALIFORNIA\",\"WASHINGTON\"))","v":"NATIONAL"},{"$f":" B3& \" 2024 FALL SOLUTIONS CALCULATOR\"","v":"NATIONAL 2024 FALL SOLUTIONS CALCULATOR"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-0009-0017"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" \"Fall Solutions National Calculator - version \" & V5","v":"Fall Solutions National Calculator - version 2024-0009-0017"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL PURCHASE REBATE"]
[null,"NAME YOUR DRAFT ORDER HERE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINIMUM QTY","MAXIMUM QTY","REBATE %"]
[null,"Description: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5000,13999,0.03]
[null,"Dist/DSR: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADMIN COLUMNS",null,null,null,null,null,null,null,null,null,null,null,14000,22499,0.04]
[null,"MER#: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22500,31499,0.05]
[null,"Last Updated: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31500,39999,0.06]
[null,"Created For: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40000,48499,0.08]
[null,"Region:","National",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48500,999999.99,0.09]
[null,null,null,null,null,"HIDE","HIDE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE",null,"HIDE",null,null,null,null,null,null,null,null,null,null,"HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE","HIDE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SELECT REBATE",null,"PAIRING REBATE",null,null,"SPECTICLE FLO LOYALTY BONUS",null,null,"MIRACAST",null,null,"LARGE LAWN",null,"PURCHASE TIER REBATE"]
[null,"REBATE FINDER. (Minimum Program Purchase to receive rebates is $5,000)","PRODUCT NAME","UNIT SIZE","# UNITS","INSEASON PRICE","INSEASON SUBTOTAL","PRICE/\nUNIT*","INVOICE SUBTOTAL ($5,000 minimum across NOW/FALL program  to receive  rebates)","SELECT REBATES**†","PAIRING REBATES**†","SPECTICLE FLO LOYALTY BONUS**†","Specticle Flo Large Lawn User Rebate **†","STRATEGIC PARTNER REBATE/unit **†","PURCHASE TIER REBATE**†","NET PRICE/UNIT (all rebates, incl. purchase tier)","TOTAL AFTER REBATE","USE RATE / 1,000 FT2","INTENDED/\nACRE \nUSE RATE","TOTAL ACRES TREATED","COST/ ACRE","COST/          \n1,000 FT2",null,null,"Required Qty","Rebate","Required Qty","Qualify?","Rebate ","Brands Qualifying","Total Brands/ Specticle Tier","Specticle Bonus",null,null,null,null,null,"Aug - Oct Early Pay Bonus","Purchase Tier Rebate","Total must be > $5000 to qualify for rebates",null,null,null,null,null,null,null,null,"National Price","National invoice for rebate calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specticle FLO Loyalty Bonus Matrix"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP(AE32,$AQ$27:$AS$27,$AQ$31:$AS$34)),0)","v":0},null,null,{"$f":"IF(AND(I92<>\"\",AM92>0),IF(AM92>0.07,AM92,(AM92+0.01)),0)","v":0.04},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiers/Brands",1,2,3]
[null,"Purchase Tier","Altus (64 fl.oz. bottle), 1-15","64 fl oz",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C28,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":428.4},{"$f":"IF(ISERROR(E28*F28),\"\",E28*F28)","v":0},{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C28,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":428.4},{"$f":"IF(ISERROR(E28*H28),0,E28*H28)","v":0},null,null,null,null,null,{"$f":"IF(OR(AW28 =\"\",AL28+AM28=0),0,E28*AW28*(AL28+AM28))","v":0},{"$f":"IF(AND(E28<>\"\",E28>0),(H28-((SUM(J28:M28)+N28*E28+O28)/E28)),\"\")","v":""},{"$f":"IF(AND(E28<>\"\",E28>0), E28*P28,\"\")","v":""},{"$f":"S28/43.56","v":0.16069788797061524},7,{"$f":"IF(AND(TRIM(S28)<>\"\",TRIM(E28)<>\"\"),(E28*64)/S28,\"\")","v":""},{"$f":"IF(E28<>0,Q28/T28,0)","v":0},{"$f":"U28/43.56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E28 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E28 <>\"\", AM$92,0)","v":0},{"$f":"IF(E28 = \"\",0,IFERROR(H28*E28,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C28,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":428.4},{"$f":"AW28*E28","v":0}]
[null,"Purchase Tier","Altus (64 fl.oz. bottle), 16-31","64 fl oz",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C29,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":428.4},{"$f":"IF(ISERROR(E29*F29),\"\",E29*F29)","v":0},{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C29,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":406.98},0,null,null,null,null,null,{"$f":"IF(OR(AW29 =\"\",AL29+AM29=0),0,E29*AW29*(AL29+AM29))","v":0},"",{"$f":"IF(AND(E29<>\"\",E29>0), E29*P29,\"\")","v":""},{"$f":"S29/43.56","v":0.16069788797061524},7,{"$f":"IF(AND(TRIM(S29)<>\"\",TRIM(E29)<>\"\"),(E29*64)/S29,\"\")","v":""},{"$f":"IF(E29<>0,Q29/T29,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C29,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":406.98},{"$f":"AW29*E29","v":0}]
[null,"Purchase Tier","Altus (64 fl.oz. bottle), 32+","64 fl oz",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C30,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":428.4},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C30,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":385.56},0,null,null,null,null,null,0,"",{"$f":"IF(AND(E30<>\"\",E30>0), E30*P30,\"\")","v":""},{"$f":"S30/43.56","v":0.16069788797061524},7,"",{"$f":"IF(E30<>0,Q30/T30,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C30,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":385.56},0]
[null,"$25 Select for 2+/$75 for 2+ Pairing with 12+ Signature or 24+ Signature XTRA","Banol® ","2.5 gal. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C31,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1254},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C31,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1254},{"$f":"IF(ISERROR(E31*H31),0,E31*H31)","v":0},{"$f":"IF(OR(E31 =\"\",E31<Y31,Y31=0),0,E31*Z31)","v":0},{"$f":"IF(OR(E31 =\"\",E31<AA31,AB31=\"No\",AA31=0),0,E31*AC31)","v":0},null,null,null,0,{"$f":"IF(AND(E31<>\"\",E31>0),(H31-((SUM(J31:M31)+N31*E31+O31)/E31)),\"\")","v":""},{"$f":"IF(AND(E31<>\"\",E31>0), E31*P31,\"\")","v":""},2,{"$f":"R31*43.56","v":87.12},{"$f":"IF(AND(TRIM(S31)<>\"\",TRIM(E31)<>\"\"),(E31*319.999849189052)/S31,\"\")","v":""},{"$f":"IF(E31<>0,Q31/T31,0)","v":0},{"$f":"U31/43.56","v":0},null,null,2,25,2,{"$f":"IF(AND(OR((E34+E35)>=AA35,(E54+E55)>=AA55),E31>=AA31),\"Yes\",\"No\")","v":"No"},75,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(E31 = \"\",0,IFERROR(H31*E31,0))","v":0},null,1,2.5000000000000001E-3,5.0000000000000001E-3,0.01,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C31,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1254},0]
[null,"$10 Select for 8+/up to 4% Loyalty Bonus/Tier","Celsius","10 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C32,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":128.4},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C32,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":128.4},{"$f":"IF(ISERROR(E32*H32),0,E32*H32)","v":0},{"$f":"IF(OR(E32 =\"\",E32<Y32,Y32=0),0,E32*Z32)","v":0},null,{"$f":"IFERROR(IF(I32*AF32<>0,I32*AF32,0),0)","v":0},null,null,0,"",{"$f":"IF(AND(E32<>\"\",E32>0), E32*P32,\"\")","v":""},{"$f":"S32/43.56","v":0.11294765840220385},4.92,{"$f":"IF(AND(TRIM(S32)<>\"\",TRIM(E32)<>\"\"),(E32*10)/S32,\"\")","v":""},{"$f":"IF(E32<>0,Q32/T32,0)","v":0},{"$f":"U32/43.56","v":0},null,null,8,10,null,null,null,{"$f":"IF(E32>=Y32,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AD$32+$AD$33+$AD$53+$AD$63>=3,3,$AD$32+$AD$33+$AD$53+$AD$63=2,2,$AD$32+$AD$33+$AD$53+$AD$63=1,1,$AD$32+$AD$33+$AD$53+$AD$63<=0,0),0)","v":0},{"$f":"IFERROR(IF(E32>=Y32,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP(AE32,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,{"$f":"IF(E32 = \"\",0,IFERROR(H32*E32,0))","v":0},null,7,5.0000000000000001E-3,0.01,0.02,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C32,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":128.4},0]
[null,"$10 Select for 8+/up to 4% Loyalty Bonus/Tier","Celsius XTRA","10 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C33,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":166.4},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C33,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":166.4},0,{"$f":"IF(OR(E33 =\"\",E33<Y33,Y33=0),0,E33*Z33)","v":0},null,{"$f":"IFERROR(IF(I33*AF33<>0,I33*AF33,0),0)","v":0},null,null,0,"","",{"$f":"S33/43.56","v":0.2295684113865932},10,{"$f":"IF(AND(TRIM(S33)<>\"\",TRIM(E33)<>\"\"),(E33*10)/S33,\"\")","v":""},0,0,null,null,8,10,null,null,null,{"$f":"IF(E33>=Y33,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AD$32+$AD$33+$AD$53+$AD$63>=3,3,$AD$32+$AD$33+$AD$53+$AD$63=2,2,$AD$32+$AD$33+$AD$53+$AD$63=1,1,$AD$32+$AD$33+$AD$53+$AD$63<=0,0),0)","v":0},{"$f":"IFERROR(IF(E33>=Y33,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP(AE33,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,0,null,14,7.4999999999999997E-3,1.4999999999999999E-2,0.03,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C33,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":166.4},0]
[null,"Purchase Tier","Chipco Signature Stressgard (1-8 units)","11 lb. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C34,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":392.8},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C34,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":392.8},0,null,null,null,null,null,0,"","",4,{"$f":"R34*43.56","v":174.24},{"$f":"IF(AND(TRIM(S34)<>\"\",TRIM(E34)<>\"\"),(E34*176)/S34,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,26,0.01,0.02,0.04,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C34,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":392.8},0]
[null,"$10 for 12+ with 2+ Banol/Tier","Chipco Signature Stressgard (9+ units)","11 lb. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C35,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":392.8},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C35,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":368.8},0,null,{"$f":"IF(OR(E35 =\"\",E35<AA35,AB35=\"No\",AA35=0),0,E35*AC35)","v":0},null,null,null,0,"","",4,174.24,{"$f":"IF(AND(TRIM(S35)<>\"\",TRIM(E35)<>\"\"),(E35*176)/S35,\"\")","v":""},0,0,null,null,null,null,12,{"$f":"IF(AND((E34+E35)>=AA35,E31>=AA31),\"Yes\",\"No\")","v":"No"},10,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C35,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":368.8},0]
[null,"Add 1+ to Greens Health or Snow Mold for $50 pairing rebate/Tier","Castlon™ (1 gal.)","1 gal. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C36,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":2600},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C36,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":2600},0,null,{"$f":"IF(OR(E36 =\"\",E36<AA36,AB36=\"No\",AA36=0),0,E36*AC36)","v":0},null,null,null,0,"","",0.18,{"$f":"R36*43.56","v":7.8407999999999998},{"$f":"IF(AND(TRIM(S36)<>\"\",TRIM(E36)<>\"\"),(E36*128)/S36,\"\")","v":""},0,0,null,null,null,null,1,{"$f":"IFERROR(_xlfn.IFS(AND(AB31=\"Yes\",AB35=\"Yes\",E36>=1),\"Yes\",AND(AB31=\"Yes\",AB55=\"Yes\",E36>=1),\"Yes\",AND(AB44=\"Yes\",AB48=\"Yes\",E36>=1),\"Yes\",AND(AB39=\"Yes\",AB62=\"Yes\",E36>=1),\"Yes\",AND(AB61=\"Yes\",E36>=1),\"Yes\"),\"No\")","v":"No"},50,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C36,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":2600},0]
[null,"Purchase Tier","Castlon™ (16oz.)","16 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C37,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":366.5},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C37,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":366.5},0,null,null,null,null,null,0,"","",0.18,{"$f":"R37*43.56","v":7.8407999999999998},{"$f":"IF(AND(TRIM(S37)<>\"\",TRIM(E37)<>\"\"),(E37*16)/S37,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C37,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":366.5},0]
[null,"$35 Select 1+/Add 4+ to Greens Health or Snow Mold for $35 pairing rebate/Tier","Densicor®","51 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C38,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":739.6},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C38,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":739.6},0,{"$f":"IF(OR(E38 =\"\",E38<Y38,Y38=0),0,E38*Z38)","v":0},{"$f":"IF(OR(E38 =\"\",E38<AA38,AB38=\"No\",AA38=0),0,E38*AC38)","v":0},null,null,null,0,"","",{"$f":"0.196","v":0.19600000000000001},8.5377600000000005,{"$f":"IF(AND(TRIM(S38)<>\"\",TRIM(E38)<>\"\"),(E38*51)/S38,\"\")","v":""},0,0,null,null,1,35,4,{"$f":"IFERROR(_xlfn.IFS(AND(AB31=\"Yes\",AB35=\"Yes\",E38>=AA38),\"Yes\",AND(AB31=\"Yes\",AB55=\"Yes\",E38>=AA38),\"Yes\",AND(AB44=\"Yes\",AB48=\"Yes\",E38>=AA38),\"Yes\",AND(AB39=\"Yes\",AB62=\"Yes\",E38>=AA38),\"Yes\",AND(AB61=\"Yes\",E38>=AA38),\"Yes\"),\"No\")","v":"No"},35,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C38,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":739.6},0]
[null,"$45 Pairing Rebate/16+","Exteris® Stressgard®","2.5 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C39,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":366},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C39,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":366},0,null,{"$f":"IF(OR(E39 =\"\",E39<AA39,AB39=\"No\",AA39=0),0,E39*AC39)","v":0},null,null,null,0,"",{"$f":"IF(AND(E39<>\"\",E39>0), E39*P39,\"\")","v":""},4,174.24,{"$f":"IF(AND(TRIM(S39)<>\"\",TRIM(E39)<>\"\"),(E39*320)/S39,\"\")","v":""},{"$f":"IF(E39<>0,Q39/T39,0)","v":0},{"$f":"U39/43.56","v":0},null,null,null,null,16,{"$f":"IF(AND(E39>=AA39,E62>=AA62),\"Yes\",\"No\")","v":"No"},45,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(E39 = \"\",0,IFERROR(H39*E39,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C39,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":366},0]
[null,"$10 Select for 8+","Fiata® Stressgard®","2.5 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C40,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":190},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C40,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":190},0,{"$f":"IF(OR(E40 =\"\",E40<Y40,Y40=0),0,E40*Z40)","v":0},null,null,null,null,0,"","",5,217.8,{"$f":"IF(AND(TRIM(S40)<>\"\",TRIM(E40)<>\"\"),(E40*320)/S40,\"\")","v":""},0,0,null,null,8,10,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C40,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":190},0]
[null,"Purchase Tier","Indemnify® (1-2 units)","17.1 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C41,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1963.6},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C41,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1963.6},0,null,null,null,null,null,0,"","",{"$f":"S41/43.56","v":0.39003673094582181},16.989999999999998,{"$f":"IF(AND(TRIM(S41)<>\"\",TRIM(E41)<>\"\"),(E41*17.1)/S41,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C41,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1963.6},0]
[null,"Purchase Tier","Indemnify® (3+ units)","17.1 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C42,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1963.6},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C42,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1767.2},0,null,null,null,null,null,0,"","",{"$f":"S42/43.56","v":0.39003673094582181},16.989999999999998,{"$f":"IF(AND(TRIM(S42)<>\"\",TRIM(E42)<>\"\"),(E42*17.1)/S42,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C42,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1767.2},0]
[null,"Purchase Tier","Interface® Stressgard® (1-5 units)","2.5 gal. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C43,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":561},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C43,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":561},0,null,null,null,null,null,0,"","",4,{"$f":"R43*43.56","v":174.24},{"$f":"IF(AND(TRIM(S43)<>\"\",TRIM(E43)<>\"\"),(E43*319.999849189052)/S43,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C43,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":561},0]
[null,"$25 Select for 6+, $25 Pairing w/2+ Mirage/Tier","Interface® Stressgard® (6+ units)","2.5 gal. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C44,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":561},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C44,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":494},0,{"$f":"IF(OR(E44 =\"\",E44<Y44,Y44=0),0,E44*Z44)","v":0},{"$f":"IF(OR(E44 =\"\",E44<AA44,AB44=\"No\",AA44=0),0,E44*AC44)","v":0},null,null,null,{"$f":"IF(OR(AW44 =\"\",AL44+AM44=0),0,E44*AW44*(AL44+AM44))","v":0},"","",4,174.24,{"$f":"IF(AND(TRIM(S44)<>\"\",TRIM(E44)<>\"\"),(E44*319.999849189052)/S44,\"\")","v":""},0,0,null,null,6,25,6,{"$f":"IF(AND(E44>=AA44,E48>=AA48),\"Yes\",\"No\")","v":"No"},25,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C44,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":494},0]
[null,"$6.50 Golf FL/SC/TX ONLY Pairing: 12+ Kontos & 4+ Tetrino \nSee State-Level Bermudagrass Mite 24(c)","Kontos (1-11 units)","250 ml. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C45,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":221.6},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C45,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":221.6},{"$f":"IF(ISERROR(E45*H45),0,E45*H45)","v":0},null,{"$f":"IF(OR(E46 =\"\",E46<AA46,AB46=\"No\",AA46=0),0,E45*AC46)","v":0},null,null,null,null,{"$f":"IF(AND(E45<>\"\",E45>0),(H45-((SUM(J45:M45)+N45*E45+O45)/E45)),\"\")","v":""},{"$f":"IF(AND(E45<>\"\",E45>0), E45*P45,\"\")","v":""},null,5,{"$f":"IF(AND(TRIM(S45)<>\"\",TRIM(E45)<>\"\"),(E45*8.45)/S45,\"\")","v":""},0,0,null,null,null,null,12,{"$f":"IF(AND(E64>=AA64,(E45+E46+E47)>=AA47),\"Yes\",\"No\")","v":"No"},6.5,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(E45 = \"\",0,IFERROR(H45*E45,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C45,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":221.6},{"$f":"AW45*E45","v":0}]
[null,null,"Kontos (12-29 units)","250 ml. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C46,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":221.6},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C46,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":210.52},0,null,{"$f":"IF(OR(E46 =\"\",E46<AA46,AB46=\"No\",AA46=0),0,E46*AC46)","v":0},null,null,null,null,"","",null,5,{"$f":"IF(AND(TRIM(S46)<>\"\",TRIM(E46)<>\"\"),(E46*8.45)/S46,\"\")","v":""},0,0,null,null,null,null,12,{"$f":"IF(AND(E64>=AA64,(E46+E47)>=AA47),\"Yes\",\"No\")","v":"No"},6.5,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C46,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":210.52},0]
[null,null,"Kontos (30+ units)","250 ml. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C47,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":221.6},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C47,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":199.44},0,null,{"$f":"IF(OR(E47 =\"\",E47<AA47,AB47=\"No\",AA47=0),0,E47*AC47)","v":0},null,null,null,null,"","",null,5,{"$f":"IF(AND(TRIM(S47)<>\"\",TRIM(E47)<>\"\"),(E47*8.45)/S47,\"\")","v":""},0,0,null,null,null,null,12,{"$f":"IF(AND(E64>=AA64,(E46+E47)>=AA47),\"Yes\",\"No\")","v":"No"},6.5,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C47,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":199.44},0]
[null,"$25 2+ Pairing w/6+ Interface, $50 1+ w/1+ Castlon/Tier","Mirage® Stressgard®","2.5 gal. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C48,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":488},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C48,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":488},0,null,{"$f":"IF(OR(E48 =\"\",E48<AA48,AB48=\"No\",AA48=0),E48*AI48,E48*(AC48+AI48))","v":0},null,null,null,{"$f":"IF(OR(AW48 =\"\",AL48+AM48=0),0,E48*AW48*(AL48+AM48))","v":0},"","",1,43.56,{"$f":"IF(AND(TRIM(S48)<>\"\",TRIM(E48)<>\"\"),(E48*319.999849189052)/S48,\"\")","v":""},0,0,null,null,null,null,2,{"$f":"IF(AND(E44>=AA44,E48>=AA48),\"Yes\",\"No\")","v":"No"},25,null,null,null,1,{"$f":"IF(AND(E48>=AG48,E36>=1),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AH48=\"Yes\",50,0)","v":0},null,null,{"$f":"IF(AND(E48 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E48 <>\"\", AM$92,0)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C48,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":488},0]
[null,"Add 4+ to Greens Health or Snow Mold for $30 pairing rebate/Tier","Resilia ™","2.72 gal. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C49,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":918.87},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C49,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":918.87},0,null,{"$f":"IF(OR(E49 =\"\",E49<AA49,AB49=\"No\",AA49=0),0,E49*AC49)","v":0},null,null,null,0,"","",4,174.24,{"$f":"IF(AND(TRIM(S49)<>\"\",TRIM(E49)<>\"\"),(E49*348.16)/S49,\"\")","v":""},0,0,null,null,null,null,4,{"$f":"IFERROR(_xlfn.IFS(AND(AB31=\"Yes\",AB35=\"Yes\",E49>=AA49),\"Yes\",AND(AB31=\"Yes\",AB55=\"Yes\",E49>=AA49),\"Yes\",AND(AB44=\"Yes\",AB48=\"Yes\",E49>=AA49),\"Yes\",AND(AB39=\"Yes\",AB62=\"Yes\",E49>=AA49),\"Yes\",AND(AB61=\"Yes\",E49>=AA49),\"Yes\"),\"No\")","v":"No"},30,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C49,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":918.87},0]
[null,"Purchases count towards rebate tier but do not receive purchase tier rebate. ","Ronstar® FLO 1 to 11","2.5 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C50,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":552},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C50,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":552},{"$f":"IF(ISERROR(E50*H50),0,E50*H50)","v":0},null,null,null,null,null,null,"","",{"$f":"S50/43.56","v":2.3298898071625342},101.49,{"$f":"IF(AND(TRIM(S50)<>\"\",TRIM(E50)<>\"\"),(E50*319.999849189052)/S50,\"\")","v":""},{"$f":"IF(E50<>0,Q50/T50,0)","v":0},{"$f":"U50/43.56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C50,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":552},0]
[null,null,"Ronstar® FLO 12 to 39","2.5 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C51,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":552},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C51,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":453},0,null,null,null,null,null,null,"","",{"$f":"S51/43.56","v":2.3298898071625342},101.49,{"$f":"IF(AND(TRIM(S51)<>\"\",TRIM(E51)<>\"\"),(E51*319.999849189052)/S51,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C51,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":453},0]
[null,null,"Ronstar® FLO 40+","2.5 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C52,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":552},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C52,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":393},0,null,null,null,null,null,null,{"$f":"IF(AND(E52<>\"\",E52>0),(H52-((SUM(J52:M52)+N52*E52+O52)/E52)),\"\")","v":""},"",{"$f":"S52/43.56","v":2.3298898071625342},101.49,"",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C52,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":393},0]
[null,"$35 Select for 4+/up to 4% Loyalty Bonus/Tier","Revolver® (87 oz. bottle)","87 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C53,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":758},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C53,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":758},0,{"$f":"IF(OR(E53 =\"\",E53<Y53,Y53=0),0,E53*Z53)","v":0},null,{"$f":"IFERROR(IF(I53*AF53<>0,I53*AF53,0),0)","v":0},null,null,{"$f":"IF(OR(AW53 =\"\",AL53+AM53=0),0,E53*AW53*(AL53+AM53))","v":0},"","",{"$f":"S53/43.56","v":0.39990817263544537},17.420000000000002,{"$f":"IF(AND(TRIM(S53)<>\"\",TRIM(E53)<>\"\"),(E53*87)/S53,\"\")","v":""},0,0,null,null,4,35,null,null,null,{"$f":"IF(E53>=Y53,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AD$32+$AD$33+$AD$53+$AD$63>=3,3,$AD$32+$AD$33+$AD$53+$AD$63=2,2,$AD$32+$AD$33+$AD$53+$AD$63=1,1,$AD$32+$AD$33+$AD$53+$AD$63<=0,0),0)","v":0},{"$f":"IFERROR(IF(E53>=Y53,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP(AE53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C53,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":758},0]
[null,"Purchase Tier","Signature XTRA Stressgard (1 to 23)","5.5 lb bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C54,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":210.4},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C54,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":210.4},0,null,null,null,null,null,0,"","",4,{"$f":"R54*43.56","v":174.24},{"$f":"IF(AND(TRIM(S54)<>\"\",TRIM(E54)<>\"\"),(E54*87.9999998763089)/S54,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C54,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":210.4},0]
[null,"$10  for 24+ with 2+ Banol/Tier","Signature XTRA Stressgard (24+)","5.5 lb bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C55,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":210.4},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C55,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":192.8},0,null,{"$f":"IF(OR(E55 =\"\",E55<AA55,AB55=\"No\",AA55=0),0,E55*AC55)","v":0},null,null,null,0,"","",4,174.24,{"$f":"IF(AND(TRIM(S55)<>\"\",TRIM(E55)<>\"\"),(E55*87.9999998763089)/S55,\"\")","v":""},0,0,null,null,null,null,24,{"$f":"IF(AND((E54+E55)>=AA55,E31>=AA31),\"Yes\",\"No\")","v":"No"},10,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C55,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":192.8},0]
[null,"Purchases may earn Loyalty Bonus and count towards rebate tier but do not receive purchase tier rebate. ","Specticle® FLO (1-6 units)","1 gal. bottle ",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C56,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":2072},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C56,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1968.4},0,null,null,{"$f":"IFERROR(IF(I56*AF56<>0,I56*AF56,0),0)","v":0},null,null,null,"","",{"$f":"S56/43.56","v":0.1379706152433425},6.01,{"$f":"IF(AND(TRIM(S56)<>\"\",TRIM(E56)<>\"\"),(E56*127.999939675621)/S56,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(E56+E57+E58+E59>=26,26,E56+E57+E58+E59>=14,14,E56+E57+E58+E59>=7,7,E56+E57+E58+E59>=1,1,E56+E57+E58+E59<=0,0)","v":0},{"$f":"IFERROR(IF(E56>=0,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP($AE$53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C56,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1968.4},0]
[null,null,"Specticle® FLO (7-13 units)","1 gal. bottle ",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C57,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":2072},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C57,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1895.88},0,null,null,{"$f":"IFERROR(IF(I57*AF57<>0,I57*AF57,0),0)","v":0},null,null,null,"","",0.1379706152433425,6.01,{"$f":"IF(AND(TRIM(S57)<>\"\",TRIM(E57)<>\"\"),(E57*127.999939675621)/S57,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E57>=0,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP($AE$53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C57,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1895.88},0]
[null,null,"Specticle® FLO (14-25 units)","1 gal. bottle ",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C58,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1778.4},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C58,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1657.6},0,null,null,{"$f":"IFERROR(IF(I58*AF58<>0,I58*AF58,0),0)","v":0},null,null,null,"","",{"$f":"S58/43.56","v":0.1379706152433425},6.01,{"$f":"IF(AND(TRIM(S58)<>\"\",TRIM(E58)<>\"\"),(E58*127.999939675621)/S58,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E58>=0,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP($AE$53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C58,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1657.6},0]
[null,null,"Specticle® FLO (26+ units)","1 gal. bottle ",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C59,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1778.4},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C59,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1533.28},0,null,null,{"$f":"IFERROR(IF(I59*AF59<>0,I59*AF59,0),0)","v":0},{"$f":"IFERROR(IF(E59*AL59<>0,E59*AL59,0),0)","v":0},null,null,"","",0.1379706152433425,6.01,{"$f":"IF(AND(TRIM(S59)<>\"\",TRIM(E59)<>\"\"),(E59*127.999939675621)/S59,\"\")","v":""},0,0,null,null,26,null,null,null,null,null,null,{"$f":"IFERROR(IF(E59>=0,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP($AE$53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,{"$f":"IFERROR(_xlfn.IFS(E59>=52,52,E59>=38,38,E59>=26,26),0)","v":0},{"$f":"IFERROR(_xlfn.IFS(AJ59=52,242,AJ59=38,182,AJ59=26,152),0)","v":0},0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C59,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1533.28},0]
[null,"$11.50 Select  for 20+ /Tier","Specticle® G","50 lb. bag",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C60,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":128},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C60,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":128},0,{"$f":"IF(OR(E60 =\"\",E60<Y60,Y60=0),0,E60*Z60)","v":0},null,null,null,null,{"$f":"IF(OR(AW60 =\"\",AL60+AM60=0),0,E60*AW60*(AL60+AM60))","v":0},"","",null,150,{"$f":"IF(AND(TRIM(S60)<>\"\",TRIM(E60)<>\"\"),(E60*50)/S60,\"\")","v":""},{"$f":"IF(E60<>0,Q60/T60,0)","v":0},0,null,null,20,11.5,null,null,null,null,null,{"$f":"IFERROR(IF(E60>=0,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP($AE$53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C60,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":128},0]
[null,"$20 Select Rebate/2+/Tier","Tartan® Stressgard® (1 to 5 units)","2.5 gal",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C61,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1033},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C61,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1033},{"$f":"IF(ISERROR(E61*H61),0,E61*H61)","v":0},{"$f":"IF(OR(E61 =\"\",E61<Y61,Y61=0),0,E61*Z61)","v":0},null,null,null,null,0,"",{"$f":"IF(AND(E61<>\"\",E61>0), E61*P61,\"\")","v":""},1.5,{"$f":"R61*43.56","v":65.34},{"$f":"IF(AND(TRIM(S61)<>\"\",TRIM(E61)<>\"\"),(E61*319.999849189052)/S61,\"\")","v":""},{"$f":"IF(E61<>0,Q61/T61,0)","v":0},{"$f":"U61/43.56","v":0},null,null,2,20,2,{"$f":"IF(AND((E61+E62)>=AA61,E49>=AA49),\"Yes\",\"No\")","v":"No"},0,null,null,{"$f":"IFERROR(IF(E61>=0,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP($AE$53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,{"$f":"IF(AND(E61 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E61 <>\"\", AM$92,0)","v":0},{"$f":"IF(E61 = \"\",0,IFERROR(H61*E61,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C61,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1033},0]
[null,"$30 Pairing Rebate/6+/Tier","Tartan® Stressgard® 6+","2.5 gal",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C62,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1033},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C62,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":940},0,0,{"$f":"IF(OR(E62 =\"\",E62<AA62,AB62=\"No\",AA62=0),0,E62*AC62)","v":0},null,null,null,0,{"$f":"IF(AND(E62<>\"\",E62>0),(H62-((SUM(J62:M62)+N62*E62+O62)/E62)),\"\")","v":""},"",1.5,65.34,{"$f":"IF(AND(TRIM(S62)<>\"\",TRIM(E62)<>\"\"),(E62*319.999849189052)/S62,\"\")","v":""},{"$f":"IF(E62<>0,Q62/T62,0)","v":0},0,null,null,2,20,6,{"$f":"IF(AND(E62>=AA62,E39>=AA39),\"Yes\",\"No\")","v":"No"},30,null,null,{"$f":"IFERROR(IF(E62>=0,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP($AE$53,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C62,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":940},0]
[null,"$30 Select for 6+/up to 4% Loyalty Bonus/Tier","Tribute® Total ","6 oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C63,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":413.6},0,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C63,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":413.6},0,{"$f":"IF(OR(E63 =\"\",E63<Y63,Y63=0),0,E63*Z63)","v":0},null,{"$f":"IFERROR(IF(I63*AF63<>0,I63*AF63,0),0)","v":0},null,null,0,"",{"$f":"IF(AND(E63<>\"\",E63>0), E63*P63,\"\")","v":""},2.2956841138659319E-2,1,{"$f":"IF(AND(TRIM(S63)<>\"\",TRIM(E63)<>\"\"),(E63*6)/S63,\"\")","v":""},0,0,null,null,6,30,null,null,null,{"$f":"IF(E63>=Y63,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AD$32+$AD$33+$AD$53+$AD$63>=3,3,$AD$32+$AD$33+$AD$53+$AD$63=2,2,$AD$32+$AD$33+$AD$53+$AD$63=1,1,$AD$32+$AD$33+$AD$53+$AD$63<=0,0),0)","v":0},{"$f":"IFERROR(IF(E63>=Y63,(_xlfn.XLOOKUP($AE$56,$AP$31:$AP$34,_xlfn.XLOOKUP(AE63,$AQ$27:$AS$27,$AQ$31:$AS$34))),0),0)","v":0},null,null,null,null,null,{"$f":"IF(AND(E63 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E63 <>\"\", AM$92,0)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C63,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":413.6},0]
[null,"$25 Select for 4+/Tier\n$15 Golf FL/SC/TX ONLY Pairing: 12+ Kontos & 4+ Tetrino \nSee State-Level Bermudagrass Mite 24C","Tetrino®","1 gal bottle",11,{"$f":"INDEX(Pricing!$E$5:$G$100,MATCH('2024 FALL CALCULATOR'!$C64,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":498},5478,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C64,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":498},5478,{"$f":"IF(OR(E64 =\"\",E64<Y64,Y64=0),0,E64*Z64)","v":275},{"$f":"IF(OR(E64 =\"\",E64<AA64,AB64=\"No\",AA64=0),0,E64*AC64)","v":0},null,null,null,219.12,453.08,4983.88,null,16,{"$f":"IF(AND(TRIM(S64)<>\"\",TRIM(E64)<>\"\"),(E64*127.999939675621)/S64,\"\")","v":87.999958526989431},56.635026691193872,1.300161310633468,null,null,4,25,4,{"$f":"IF(AND(E64>=AA64,(E46+E47)>=AA47),\"Yes\",\"No\")","v":"No"},15,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E64 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0.01},{"$f":"IF(E64 <>\"\", AM$92,0)","v":0.03},5478,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C64,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":498},5478]
[]
[null,null,null,null,null,null,null,null,"Non-Agency Products"]
[null,"REBATE FINDER. (Minimum Program Purchase to receive rebates is $5,000)","PRODUCT NAME","UNIT SIZE","# UNITS","INSEASON PRICE","INSEASON SUBTOTAL","PRICE/\nUNIT*","INVOICE SUBTOTAL ($5,000 minimum across NOW/FALL program  to receive  rebates)","SELECT REBATES**†","PAIRING REBATES**†","SPECTICLE FLO LOYALTY BONUS**†","SPECTICLE FLO LARGE LAWN USER REBATE **†","STRATEGIC PARTNER REBATE/unit **†","PURCHASE TIER REBATE**†","NET PRICE/UNIT (all rebates, incl. purchase tier)","TOTAL AFTER REBATE","USE RATE / 1,000 FT2","INTENDED/ACRE USE RATE","TOTAL ACRES TREATED","COST/ ACRE","COST/          \n1,000 FT2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"National Price","National invoice for rebate calculations","Dist Suggested Min Price (DSMP)","DSMP  invoice for rebate calculations"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L27","v":0},null,null,{"$f":"O27","v":0.04}]
[null,"$24 Select 1+/Tier","Armada® 50 WDG","2 lb. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C70,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":114},{"$f":"IF(ISERROR(E70*F70),\"\",E70*F70)","v":0},null,{"$f":"IF(E70*H70= 0,0,E70*H70)","v":0},{"$f":"IF(OR(E70 =\"\",E70<Y70,Y70=0),0,E70*Z70)","v":0},null,null,null,null,{"$f":"IF(OR(AW70 =\"\",AL70+AM70=0),0,E70*AW70*(AL70+AM70))","v":0},{"$f":"IF(AND(E70<>\"\",E70>0),(H70-((SUM(J70:M70)+N70*E70+O70)/E70)),\"\")","v":""},{"$f":"IF(AND(E70<>\"\",E70>0), E70*P70,\"\")","v":""},{"$f":"S70/43.56","v":0.5},21.78,{"$f":"IF(AND(TRIM(S70)<>\"\",TRIM(E70)<>\"\"),(E70*127.999939675621)/S70,\"\")","v":""},{"$f":"IF(I70<>0,Q70/T70,0)","v":0},{"$f":"U70/43.56","v":0},null,null,1,24,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E70 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E70 <>\"\", AM$92,0)","v":0},{"$f":"IF(E70 = \"\",0,IFERROR(F70*E70,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C70,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":114},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C70,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},{"$f":"AY70*E70","v":0}]
[null,"$90 Select 1+/Tier","Acclaim® Extra (1 gal)","1 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C71,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":665.2},0,null,{"$f":"IF(E71*H71= 0,0,E71*H71)","v":0},{"$f":"IF(OR(E71 =\"\",E71<Y71,Y71=0),0,E71*Z71)","v":0},null,null,null,null,0,"",{"$f":"IF(AND(E71<>\"\",E71>0), E71*P71,\"\")","v":""},{"$f":"S71/43.56","v":0.5},21.78,{"$f":"IF(AND(TRIM(S71)<>\"\",TRIM(E71)<>\"\"),(E71*127.999939675621)/S71,\"\")","v":""},{"$f":"IF(I71<>0,Q71/T71,0)","v":0},0,null,null,1,90,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E71 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E71 <>\"\", AM$92,0)","v":0},{"$f":"IF(E71 = \"\",0,IFERROR(F71*E71,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C71,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":665.2},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C71,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},{"$f":"AY71*E71","v":0}]
[null,"5% Select/Tier","Acclaim Accelerate (0.5 gal)",".5 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C72,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":45.65},0,null,{"$f":"IF(E72*H72= 0,0,E72*H72)","v":0},0,null,null,null,null,{"$f":"IF(OR(AW72 =\"\",AL72+AM72=0),0,E72*AY72*(AL72+AM72))","v":0},"","",1.45,{"$f":"R72*43.56","v":63.161999999999999},{"$f":"IF(AND(TRIM(S72)<>\"\",TRIM(E72)<>\"\"),(E72*64)/S72,\"\")","v":""},0,0,null,null,1,{"$f":"AY72*0.05","v":2.75},null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(E72 = \"\",0,IFERROR(F72*E72,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C72,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":45.65},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C72,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":55},0]
[null,"5% Select/Tier","Acclaim Accelerate (2.5 gal)","2.5 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C73,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":219.95},0,null,0,0,null,null,null,null,{"$f":"IF(OR(AW73 =\"\",AL73+AM73=0),0,E73*AY73*(AL73+AM73))","v":0},"","",1.45,63.161999999999999,{"$f":"IF(AND(TRIM(S73)<>\"\",TRIM(E73)<>\"\"),(E73*320)/S73,\"\")","v":""},0,0,null,null,1,{"$f":"AY73*0.05","v":13.25},null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C73,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":219.95},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C73,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":265},0]
[null,"5% Select/Tier","Terradex™ Power Premix (2.5 gal)","2.5 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C74,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":186.75},0,null,0,0,null,null,null,null,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(S74)<>\"\",TRIM(E74)<>\"\"),(E74*320)/S74,\"\")","v":""},0,0,null,null,1,11.25,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C74,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":186.75},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C74,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":225},0]
[null,"5% Select/Tier","Terradex™ Power Premix (30 gal)","30 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C75,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":2041.8},0,null,0,0,null,null,null,null,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(S75)<>\"\",TRIM(E75)<>\"\"),(E75*3840)/S75,\"\")","v":""},0,0,null,null,1,123,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C75,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":2041.8},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C75,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":2460},0]
[null,"5% Select/Tier","Terradex™ Quick Strike (1 gal)","1 gal.jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C76,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":66.400000000000006},0,null,0,0,null,null,null,null,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(S76)<>\"\",TRIM(E76)<>\"\"),(E76*127.999939675621)/S76,\"\")","v":""},0,0,null,null,1,4,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C76,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":66.400000000000006},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C76,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":80},0]
[null,"5% Select/Tier","Terradex™ Quick Strike (2.5 gal)","2.5 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C77,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":157.69999999999999},0,null,0,0,null,null,null,null,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(S77)<>\"\",TRIM(E77)<>\"\"),(E77*320)/S77,\"\")","v":""},0,0,null,null,1,9.5,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C77,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":157.69999999999999},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C77,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":190},0]
[null,"5% Select/Tier","Terradex™ Quick Strike (30 gal)","30 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C78,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":1792.8},0,null,0,0,null,null,null,null,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(S78)<>\"\",TRIM(E78)<>\"\"),(E78*3840)/S78,\"\")","v":""},0,0,null,null,1,108,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C78,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":1792.8},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C78,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":2160},0]
[null,"5% Select/Tier","Terradex™ Crabgrass & Broadleaf (1 gal)","1 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C79,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":94.62},0,null,0,0,null,null,null,null,0,"","",2.9,126.324,{"$f":"IF(AND(TRIM(S79)<>\"\",TRIM(E79)<>\"\"),(E79*127.999939675621)/S79,\"\")","v":""},0,0,null,null,1,5.7,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C79,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":94.62},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C79,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":114},0]
[null,"5% Select/Tier","Terradex™ Crabgrass & Broadleaf (2.5 gal)","2.5 gal.jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C80,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":226.18},0,null,0,0,null,null,null,null,0,"","",2.9,126.324,{"$f":"IF(AND(TRIM(S80)<>\"\",TRIM(E80)<>\"\"),(E80*320)/S80,\"\")","v":""},0,0,null,null,1,13.625,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C80,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":226.18},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C80,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":272.5},0]
[null,"Purchase Tier","26 GT®","2.5 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C81,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":503.9},0,null,0,null,null,null,null,null,0,"","",4,174.24,{"$f":"IF(AND(TRIM(S81)<>\"\",TRIM(E81)<>\"\"),(E81*319.999849189052)/S81,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E81 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E81 <>\"\", AM$92,0)","v":0},{"$f":"IF(E81 = \"\",0,IFERROR(F81*E81,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C81,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":503.9},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C81,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,"Purchase Tier","Chipco® Choice","50 lb. bag",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C82,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":161},0,null,0,null,null,null,null,null,{"$f":"IF(OR(AW82 =\"\",AL82+AM82=0),0,E82*AW82*(AL82+AM82))","v":0},{"$f":"IF(AND(E82<>\"\",E82>0),(H82-((SUM(J82:M82)+N82*E82+O82)/E82)),\"\")","v":""},"",null,25,{"$f":"IF(AND(TRIM(S82)<>\"\",TRIM(E82)<>\"\"),(E82*50)/S82,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C82,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":161},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C82,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,"Purchase Tier","Dylox 420 SL","2.5 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C83,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":218.75},0,null,0,null,null,null,null,null,0,{"$f":"IF(AND(E83<>\"\",E83>0),(H83-((SUM(J83:M83)+N83*E83+O83)/E83)),\"\")","v":""},"",4.59,12.5,{"$f":"IF(AND(TRIM(S83)<>\"\",TRIM(E83)<>\"\"),(E83*319.999849189052)/S83,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C83,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":218.75},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C83,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,"Purchase Tier","Forbid® ","8 fl.oz. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C84,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":244.18},0,null,0,null,null,null,null,null,0,"","",3,130.68,{"$f":"IF(AND(TRIM(S84)<>\"\",TRIM(E84)<>\"\"),(E84*8)/S84,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C84,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":244.18},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C84,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,"Purchases count towards rebate tier but do not receive purchase tier rebate","Merit® 75 WSP","4x1.6 oz",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C85,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":102.64},0,null,0,null,null,null,null,null,null,"","",0.14499999999999999,{"$f":"R85*43.56","v":6.3162000000000003},{"$f":"IF(AND(TRIM(S85)<>\"\",TRIM(E85)<>\"\"),(E85*16)/S85,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C85,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":102.64},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C85,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,null,"Merit 2F","1 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C86,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":40.15},0,null,0,null,null,null,null,null,null,"","",0.6,26.135999999999999,{"$f":"IF(AND(TRIM(S86)<>\"\",TRIM(E86)<>\"\"),(E86*127.999939675621)/S86,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C86,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":40.15},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C86,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,null,"Prograss® EC","2.5 gal jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C87,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":368.25},0,null,0,null,null,null,null,null,null,"","",1.5,65.34,{"$f":"IF(AND(TRIM(S87)<>\"\",TRIM(E87)<>\"\"),(E87*319.999849189052)/S87,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C87,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":368.25},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C87,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,null,"Proxy® ","2.5 gal. jug",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C88,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":102.25},0,null,0,null,null,null,null,null,null,"","",5,217.8,{"$f":"IF(AND(TRIM(S88)<>\"\",TRIM(E88)<>\"\"),(E88*319.999849189052)/S88,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C88,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":102.25},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C88,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,"Purchase Tier","Revolver®(32 oz. bottle)","32 oz bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C89,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":288.56},0,null,0,null,null,null,null,null,{"$f":"IF(OR(AW89 =\"\",AL89+AM89=0),0,E89*AW89*(AL89+AM89))","v":0},"","",0.4,17.420000000000002,{"$f":"IF(AND(TRIM(S89)<>\"\",TRIM(E89)<>\"\"),(E89*32)/S89,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E89 <>\"\",AN$92>=5000,AM$92<=0.07),0.01,0)","v":0},{"$f":"IF(E89 <>\"\", AM$92,0)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C89,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":288.56},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C89,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,"Purchase Tier","Sencor® 75","5 lb.bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C90,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":586},0,null,0,null,null,null,null,null,0,"","",0.24199999999999999,0.66,{"$f":"IF(AND(TRIM(S90)<>\"\",TRIM(E90)<>\"\"),(E90*5)/S90,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C90,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":586},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C90,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,"Purchases count towards rebate tier but do not receive purchase tier rebate","Topchoice®","50 lb. bag",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C91,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":63},0,null,0,null,null,null,null,null,null,"","",null,87,{"$f":"IF(AND(TRIM(S91)<>\"\",TRIM(E91)<>\"\"),(E91*50)/S91,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C91,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":63},0,{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C91,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},0]
[null,null,null,null,null,null,{"$f":"SUM(G28:G64) + SUM(G70:G91)","v":5478},null,{"$f":"SUM(I28:I64) + SUM(I70:I91)","v":5478},{"$f":"SUM(J28:J64) + SUM(J70:J91)","v":275},{"$f":"SUM(K28:K64) + SUM(K70:K91)","v":0},{"$f":"SUM(L28:L64) + SUM(L70:L91)","v":0},{"$f":"SUM(M28:M64) + SUM(M70:M91)","v":0},{"$f":"SUMPRODUCT(N28:N64,E28:E64)","v":0},219.12,null,{"$f":"SUM(Q28:Q64) + SUM(Q70:Q91)","v":4983.88},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AN$92=\"\",AN$92<=$AL$17),0,(VLOOKUP(AN92,AL17:AN22,3)))","v":0.03},{"$f":"SUM(AN28:AN64) + SUM(AN70:AN91)","v":5478}]
[]
[null,"Summary"]
[null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[null,"Total Before Off Invoice Volume Discounts",null,null,{"$f":"IF(G92<I92,I92,G92)","v":5478}]
[null,"Off Invoice Volume Discount",null,null,{"$f":"IF((SUM(G28:G64)-SUM(I28:I64))<0,0,(SUM(G28:G64)-SUM(I28:I64)))","v":0}]
[null,"Invoice Total ",null,null,{"$f":"I92","v":5478}]
[null,"Purchase Tier Level \nStandard calculation assumes order is invoiced by Oct 31, 2024 and will receive 1% Oct bonus to purchase tier rebate",null,null,{"$f":"IF(AND(I92<>\"\",I92> 0),O27,0)","v":0.04}]
[null,"Rebate \nTotal Program Purchase must be a minimum of $5,000 to receive rebates",null,null,{"$f":"SUM(J92:O92)","v":494.12}]
[null,"Net Total after Rebate",null,null,{"$f":"Q92","v":4983.88}]
[null,"Rebate % \nTotal Program Purchase must be a minimum of $5,000 to receive rebates",null,null,{"$f":"IF(AND(I92<>\"\",I92>0),MIN((E101/E99),1),0)","v":9.0200803212851413E-2}]
[null,"Total Savings (Rebates + Off Invoice Volume Discounts)",null,null,{"$f":"E98+E101","v":494.12}]
[null,"Total Savings % (Rebates + Off Invoice Volume Discounts)",null,null,{"$f":"IF(AND(E97 <> \"\", E97 > 0), E104/E97,0)","v":9.0200803212851413E-2}]
[]
[null,{"$f":"CONCATENATE(\"Estimated MER points to be earned: \",TEXT(IF(AND(E101 <>\"\", E101 > 0),E101*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned: 49,412"},null,null,null,null,null,null,{"$f":"V13","v":"Fall Solutions National Calculator - version 2024-0009-0017"}]

{"sheet":"SUMMARY","index":1,"n_rows":96,"n_cols":7,"rows_kept":96,"cut":false,"hidden":false,"merged":[[81,1,81,5],[16,5,18,5],[16,6,18,6],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[85,1,85,5],[86,1,86,5],[87,1,87,5],[88,1,88,5],[82,1,84,5],[89,1,89,5],[90,1,90,5],[91,1,91,5],[92,1,92,5],[93,1,93,5],[95,1,95,6],[14,2,14,6],[13,2,13,6],[8,1,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!V13","v":"Fall Solutions National Calculator - version 2024-0009-0017"}]
[null,{"$f":"'2024 FALL CALCULATOR'!B16","v":"NAME YOUR DRAFT ORDER HERE:"}]
[null,"Description: ",{"$f":"IF('2024 FALL CALCULATOR'!C17=\"\",\"\",'2024 FALL CALCULATOR'!C17)","v":""}]
[null,"Distributor/DSR: ",{"$f":"IF('2024 FALL CALCULATOR'!C18=\"\",\"\",'2024 FALL CALCULATOR'!C18)","v":""}]
[null,"MER#: ",{"$f":"IF('2024 FALL CALCULATOR'!C19=\"\",\"\",'2024 FALL CALCULATOR'!C19)","v":""}]
[null,"Last Updated: ",{"$f":"IF('2024 FALL CALCULATOR'!C20=\"\",\"\",'2024 FALL CALCULATOR'!C20)","v":""}]
[null,"Created For: ",{"$f":"IF('2024 FALL CALCULATOR'!C21=\"\",\"\",'2024 FALL CALCULATOR'!C21)","v":""}]
[null,"Region:",{"$f":"IF('2024 FALL CALCULATOR'!C22=\"\",\"\",'2024 FALL CALCULATOR'!C22)","v":"National"}]
[]
[null,"PRODUCT NAME","UNIT SIZE","# UNITS","PRICE/UNIT","SUBTOTAL","NET PRICE/UNIT"]
[]
[]
[null,{"$f":"'2024 FALL CALCULATOR'!C28","v":"Altus (64 fl.oz. bottle), 1-15"},{"$f":"'2024 FALL CALCULATOR'!D28","v":"64 fl oz"},{"$f":"'2024 FALL CALCULATOR'!E28","v":0},{"$f":"'2024 FALL CALCULATOR'!H28","v":428.4},{"$f":"'2024 FALL CALCULATOR'!I28","v":0},{"$f":"'2024 FALL CALCULATOR'!P28","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C29","v":"Altus (64 fl.oz. bottle), 16-31"},{"$f":"'2024 FALL CALCULATOR'!D29","v":"64 fl oz"},{"$f":"'2024 FALL CALCULATOR'!E29","v":0},{"$f":"'2024 FALL CALCULATOR'!H29","v":406.98},{"$f":"'2024 FALL CALCULATOR'!I29","v":0},{"$f":"'2024 FALL CALCULATOR'!P29","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C30","v":"Altus (64 fl.oz. bottle), 32+"},{"$f":"'2024 FALL CALCULATOR'!D30","v":"64 fl oz"},{"$f":"'2024 FALL CALCULATOR'!E30","v":0},{"$f":"'2024 FALL CALCULATOR'!H30","v":385.56},{"$f":"'2024 FALL CALCULATOR'!I30","v":0},{"$f":"'2024 FALL CALCULATOR'!P30","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C31","v":"Banol® "},{"$f":"'2024 FALL CALCULATOR'!D31","v":"2.5 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E31","v":0},{"$f":"'2024 FALL CALCULATOR'!H31","v":1254},{"$f":"'2024 FALL CALCULATOR'!I31","v":0},{"$f":"'2024 FALL CALCULATOR'!P31","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C32","v":"Celsius"},{"$f":"'2024 FALL CALCULATOR'!D32","v":"10 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E32","v":0},{"$f":"'2024 FALL CALCULATOR'!H32","v":128.4},{"$f":"'2024 FALL CALCULATOR'!I32","v":0},{"$f":"'2024 FALL CALCULATOR'!P32","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C33","v":"Celsius XTRA"},{"$f":"'2024 FALL CALCULATOR'!D33","v":"10 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E33","v":0},{"$f":"'2024 FALL CALCULATOR'!H33","v":166.4},{"$f":"'2024 FALL CALCULATOR'!I33","v":0},{"$f":"'2024 FALL CALCULATOR'!P33","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C34","v":"Chipco Signature Stressgard (1-8 units)"},{"$f":"'2024 FALL CALCULATOR'!D34","v":"11 lb. bottle"},{"$f":"'2024 FALL CALCULATOR'!E34","v":0},{"$f":"'2024 FALL CALCULATOR'!H34","v":392.8},{"$f":"'2024 FALL CALCULATOR'!I34","v":0},{"$f":"'2024 FALL CALCULATOR'!P34","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C35","v":"Chipco Signature Stressgard (9+ units)"},{"$f":"'2024 FALL CALCULATOR'!D35","v":"11 lb. bottle"},{"$f":"'2024 FALL CALCULATOR'!E35","v":0},{"$f":"'2024 FALL CALCULATOR'!H35","v":368.8},{"$f":"'2024 FALL CALCULATOR'!I35","v":0},{"$f":"'2024 FALL CALCULATOR'!P35","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C36","v":"Castlon™ (1 gal.)"},{"$f":"'2024 FALL CALCULATOR'!D36","v":"1 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E36","v":0},{"$f":"'2024 FALL CALCULATOR'!H36","v":2600},{"$f":"'2024 FALL CALCULATOR'!I36","v":0},{"$f":"'2024 FALL CALCULATOR'!P36","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C37","v":"Castlon™ (16oz.)"},{"$f":"'2024 FALL CALCULATOR'!D37","v":"16 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E37","v":0},{"$f":"'2024 FALL CALCULATOR'!H37","v":366.5},{"$f":"'2024 FALL CALCULATOR'!I37","v":0},{"$f":"'2024 FALL CALCULATOR'!P37","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C38","v":"Densicor®"},{"$f":"'2024 FALL CALCULATOR'!D38","v":"51 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E38","v":0},{"$f":"'2024 FALL CALCULATOR'!H38","v":739.6},{"$f":"'2024 FALL CALCULATOR'!I38","v":0},{"$f":"'2024 FALL CALCULATOR'!P38","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C39","v":"Exteris® Stressgard®"},{"$f":"'2024 FALL CALCULATOR'!D39","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E39","v":0},{"$f":"'2024 FALL CALCULATOR'!H39","v":366},{"$f":"'2024 FALL CALCULATOR'!I39","v":0},{"$f":"'2024 FALL CALCULATOR'!P39","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C40","v":"Fiata® Stressgard®"},{"$f":"'2024 FALL CALCULATOR'!D40","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E40","v":0},{"$f":"'2024 FALL CALCULATOR'!H40","v":190},{"$f":"'2024 FALL CALCULATOR'!I40","v":0},{"$f":"'2024 FALL CALCULATOR'!P40","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C41","v":"Indemnify® (1-2 units)"},{"$f":"'2024 FALL CALCULATOR'!D41","v":"17.1 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E41","v":0},{"$f":"'2024 FALL CALCULATOR'!H41","v":1963.6},{"$f":"'2024 FALL CALCULATOR'!I41","v":0},{"$f":"'2024 FALL CALCULATOR'!P41","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C42","v":"Indemnify® (3+ units)"},{"$f":"'2024 FALL CALCULATOR'!D42","v":"17.1 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E42","v":0},{"$f":"'2024 FALL CALCULATOR'!H42","v":1767.2},{"$f":"'2024 FALL CALCULATOR'!I42","v":0},{"$f":"'2024 FALL CALCULATOR'!P42","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C43","v":"Interface® Stressgard® (1-5 units)"},{"$f":"'2024 FALL CALCULATOR'!D43","v":"2.5 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E43","v":0},{"$f":"'2024 FALL CALCULATOR'!H43","v":561},{"$f":"'2024 FALL CALCULATOR'!I43","v":0},{"$f":"'2024 FALL CALCULATOR'!P43","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C44","v":"Interface® Stressgard® (6+ units)"},{"$f":"'2024 FALL CALCULATOR'!D44","v":"2.5 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E44","v":0},{"$f":"'2024 FALL CALCULATOR'!H44","v":494},{"$f":"'2024 FALL CALCULATOR'!I44","v":0},{"$f":"'2024 FALL CALCULATOR'!P44","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C45","v":"Kontos (1-11 units)"},{"$f":"'2024 FALL CALCULATOR'!D45","v":"250 ml. bottle"},{"$f":"'2024 FALL CALCULATOR'!E45","v":0},{"$f":"'2024 FALL CALCULATOR'!H45","v":221.6},{"$f":"'2024 FALL CALCULATOR'!I45","v":0},{"$f":"'2024 FALL CALCULATOR'!P45","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C46","v":"Kontos (12-29 units)"},{"$f":"'2024 FALL CALCULATOR'!D46","v":"250 ml. bottle"},{"$f":"'2024 FALL CALCULATOR'!E46","v":0},{"$f":"'2024 FALL CALCULATOR'!H46","v":210.52},{"$f":"'2024 FALL CALCULATOR'!I46","v":0},{"$f":"'2024 FALL CALCULATOR'!P46","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C47","v":"Kontos (30+ units)"},{"$f":"'2024 FALL CALCULATOR'!D47","v":"250 ml. bottle"},{"$f":"'2024 FALL CALCULATOR'!E47","v":0},{"$f":"'2024 FALL CALCULATOR'!H47","v":199.44},{"$f":"'2024 FALL CALCULATOR'!I47","v":0},{"$f":"'2024 FALL CALCULATOR'!P47","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C48","v":"Mirage® Stressgard®"},{"$f":"'2024 FALL CALCULATOR'!D48","v":"2.5 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E48","v":0},{"$f":"'2024 FALL CALCULATOR'!H48","v":488},{"$f":"'2024 FALL CALCULATOR'!I48","v":0},{"$f":"'2024 FALL CALCULATOR'!P48","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C49","v":"Resilia ™"},{"$f":"'2024 FALL CALCULATOR'!D49","v":"2.72 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E49","v":0},{"$f":"'2024 FALL CALCULATOR'!H49","v":918.87},{"$f":"'2024 FALL CALCULATOR'!I49","v":0},{"$f":"'2024 FALL CALCULATOR'!P49","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C50","v":"Ronstar® FLO 1 to 11"},{"$f":"'2024 FALL CALCULATOR'!D50","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E50","v":0},{"$f":"'2024 FALL CALCULATOR'!H50","v":552},{"$f":"'2024 FALL CALCULATOR'!I50","v":0},{"$f":"'2024 FALL CALCULATOR'!P50","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C51","v":"Ronstar® FLO 12 to 39"},{"$f":"'2024 FALL CALCULATOR'!D51","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E51","v":0},{"$f":"'2024 FALL CALCULATOR'!H51","v":453},{"$f":"'2024 FALL CALCULATOR'!I51","v":0},{"$f":"'2024 FALL CALCULATOR'!P51","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C52","v":"Ronstar® FLO 40+"},{"$f":"'2024 FALL CALCULATOR'!D52","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E52","v":0},{"$f":"'2024 FALL CALCULATOR'!H52","v":393},{"$f":"'2024 FALL CALCULATOR'!I52","v":0},{"$f":"'2024 FALL CALCULATOR'!P52","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C53","v":"Revolver® (87 oz. bottle)"},{"$f":"'2024 FALL CALCULATOR'!D53","v":"87 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E53","v":0},{"$f":"'2024 FALL CALCULATOR'!H53","v":758},{"$f":"'2024 FALL CALCULATOR'!I53","v":0},{"$f":"'2024 FALL CALCULATOR'!P53","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C54","v":"Signature XTRA Stressgard (1 to 23)"},{"$f":"'2024 FALL CALCULATOR'!D54","v":"5.5 lb bottle"},{"$f":"'2024 FALL CALCULATOR'!E54","v":0},{"$f":"'2024 FALL CALCULATOR'!H54","v":210.4},{"$f":"'2024 FALL CALCULATOR'!I54","v":0},{"$f":"'2024 FALL CALCULATOR'!P54","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C55","v":"Signature XTRA Stressgard (24+)"},{"$f":"'2024 FALL CALCULATOR'!D55","v":"5.5 lb bottle"},{"$f":"'2024 FALL CALCULATOR'!E55","v":0},{"$f":"'2024 FALL CALCULATOR'!H55","v":192.8},{"$f":"'2024 FALL CALCULATOR'!I55","v":0},{"$f":"'2024 FALL CALCULATOR'!P55","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C56","v":"Specticle® FLO (1-6 units)"},{"$f":"'2024 FALL CALCULATOR'!D56","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E56","v":0},{"$f":"'2024 FALL CALCULATOR'!H56","v":1968.4},{"$f":"'2024 FALL CALCULATOR'!I56","v":0},{"$f":"'2024 FALL CALCULATOR'!P56","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C57","v":"Specticle® FLO (7-13 units)"},{"$f":"'2024 FALL CALCULATOR'!D57","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E57","v":0},{"$f":"'2024 FALL CALCULATOR'!H57","v":1895.88},{"$f":"'2024 FALL CALCULATOR'!I57","v":0},{"$f":"'2024 FALL CALCULATOR'!P57","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C58","v":"Specticle® FLO (14-25 units)"},{"$f":"'2024 FALL CALCULATOR'!D58","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E58","v":0},{"$f":"'2024 FALL CALCULATOR'!H58","v":1657.6},{"$f":"'2024 FALL CALCULATOR'!I58","v":0},{"$f":"'2024 FALL CALCULATOR'!P58","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C59","v":"Specticle® FLO (26+ units)"},{"$f":"'2024 FALL CALCULATOR'!D59","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E59","v":0},{"$f":"'2024 FALL CALCULATOR'!H59","v":1533.28},{"$f":"'2024 FALL CALCULATOR'!I59","v":0},{"$f":"'2024 FALL CALCULATOR'!P59","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C60","v":"Specticle® G"},{"$f":"'2024 FALL CALCULATOR'!D60","v":"50 lb. bag"},{"$f":"'2024 FALL CALCULATOR'!E60","v":0},{"$f":"'2024 FALL CALCULATOR'!H60","v":128},{"$f":"'2024 FALL CALCULATOR'!I60","v":0},{"$f":"'2024 FALL CALCULATOR'!P60","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C61","v":"Tartan® Stressgard® (1 to 5 units)"},{"$f":"'2024 FALL CALCULATOR'!D61","v":"2.5 gal"},{"$f":"'2024 FALL CALCULATOR'!E61","v":0},{"$f":"'2024 FALL CALCULATOR'!H61","v":1033},{"$f":"'2024 FALL CALCULATOR'!I61","v":0},{"$f":"'2024 FALL CALCULATOR'!P61","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C62","v":"Tartan® Stressgard® 6+"},{"$f":"'2024 FALL CALCULATOR'!D62","v":"2.5 gal"},{"$f":"'2024 FALL CALCULATOR'!E62","v":0},{"$f":"'2024 FALL CALCULATOR'!H62","v":940},{"$f":"'2024 FALL CALCULATOR'!I62","v":0},{"$f":"'2024 FALL CALCULATOR'!P62","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C63","v":"Tribute® Total "},{"$f":"'2024 FALL CALCULATOR'!D63","v":"6 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E63","v":0},{"$f":"'2024 FALL CALCULATOR'!H63","v":413.6},{"$f":"'2024 FALL CALCULATOR'!I63","v":0},{"$f":"'2024 FALL CALCULATOR'!P63","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C64","v":"Tetrino®"},{"$f":"'2024 FALL CALCULATOR'!D64","v":"1 gal bottle"},{"$f":"'2024 FALL CALCULATOR'!E64","v":11},{"$f":"'2024 FALL CALCULATOR'!H64","v":498},{"$f":"'2024 FALL CALCULATOR'!I64","v":5478},{"$f":"'2024 FALL CALCULATOR'!P64","v":453.08}]
[null,{"$f":"'2024 FALL CALCULATOR'!C70","v":"Armada® 50 WDG"},{"$f":"'2024 FALL CALCULATOR'!D70","v":"2 lb. bottle"},{"$f":"'2024 FALL CALCULATOR'!E70","v":0},{"$f":"'2024 FALL CALCULATOR'!H70","v":0},{"$f":"'2024 FALL CALCULATOR'!I70","v":0},{"$f":"'2024 FALL CALCULATOR'!P70","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C71","v":"Acclaim® Extra (1 gal)"},{"$f":"'2024 FALL CALCULATOR'!D71","v":"1 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E71","v":0},{"$f":"'2024 FALL CALCULATOR'!H71","v":0},{"$f":"'2024 FALL CALCULATOR'!I71","v":0},{"$f":"'2024 FALL CALCULATOR'!P71","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C72","v":"Acclaim Accelerate (0.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D72","v":".5 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E72","v":0},{"$f":"'2024 FALL CALCULATOR'!H72","v":0},{"$f":"'2024 FALL CALCULATOR'!I72","v":0},{"$f":"'2024 FALL CALCULATOR'!P72","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C73","v":"Acclaim Accelerate (2.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D73","v":"2.5 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E73","v":0},{"$f":"'2024 FALL CALCULATOR'!H73","v":0},{"$f":"'2024 FALL CALCULATOR'!I73","v":0},{"$f":"'2024 FALL CALCULATOR'!P73","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C74","v":"Terradex™ Power Premix (2.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D74","v":"2.5 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E74","v":0},{"$f":"'2024 FALL CALCULATOR'!H74","v":0},{"$f":"'2024 FALL CALCULATOR'!I74","v":0},{"$f":"'2024 FALL CALCULATOR'!P74","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C75","v":"Terradex™ Power Premix (30 gal)"},{"$f":"'2024 FALL CALCULATOR'!D75","v":"30 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E75","v":0},{"$f":"'2024 FALL CALCULATOR'!H75","v":0},{"$f":"'2024 FALL CALCULATOR'!I75","v":0},{"$f":"'2024 FALL CALCULATOR'!P75","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C76","v":"Terradex™ Quick Strike (1 gal)"},{"$f":"'2024 FALL CALCULATOR'!D76","v":"1 gal.jug"},{"$f":"'2024 FALL CALCULATOR'!E76","v":0},{"$f":"'2024 FALL CALCULATOR'!H76","v":0},{"$f":"'2024 FALL CALCULATOR'!I76","v":0},{"$f":"'2024 FALL CALCULATOR'!P76","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C77","v":"Terradex™ Quick Strike (2.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D77","v":"2.5 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E77","v":0},{"$f":"'2024 FALL CALCULATOR'!H77","v":0},{"$f":"'2024 FALL CALCULATOR'!I77","v":0},{"$f":"'2024 FALL CALCULATOR'!P77","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C78","v":"Terradex™ Quick Strike (30 gal)"},{"$f":"'2024 FALL CALCULATOR'!D78","v":"30 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E78","v":0},{"$f":"'2024 FALL CALCULATOR'!H78","v":0},{"$f":"'2024 FALL CALCULATOR'!I78","v":0},{"$f":"'2024 FALL CALCULATOR'!P78","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C79","v":"Terradex™ Crabgrass & Broadleaf (1 gal)"},{"$f":"'2024 FALL CALCULATOR'!D79","v":"1 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E79","v":0},{"$f":"'2024 FALL CALCULATOR'!H79","v":0},{"$f":"'2024 FALL CALCULATOR'!I79","v":0},{"$f":"'2024 FALL CALCULATOR'!P79","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C80","v":"Terradex™ Crabgrass & Broadleaf (2.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D80","v":"2.5 gal.jug"},{"$f":"'2024 FALL CALCULATOR'!E80","v":0},{"$f":"'2024 FALL CALCULATOR'!H80","v":0},{"$f":"'2024 FALL CALCULATOR'!I80","v":0},{"$f":"'2024 FALL CALCULATOR'!P80","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C81","v":"26 GT®"},{"$f":"'2024 FALL CALCULATOR'!D81","v":"2.5 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E81","v":0},{"$f":"'2024 FALL CALCULATOR'!H81","v":0},{"$f":"'2024 FALL CALCULATOR'!I81","v":0},{"$f":"'2024 FALL CALCULATOR'!P81","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C82","v":"Chipco® Choice"},{"$f":"'2024 FALL CALCULATOR'!D82","v":"50 lb. bag"},{"$f":"'2024 FALL CALCULATOR'!E82","v":0},{"$f":"'2024 FALL CALCULATOR'!H82","v":0},{"$f":"'2024 FALL CALCULATOR'!I82","v":0},{"$f":"'2024 FALL CALCULATOR'!P82","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C83","v":"Dylox 420 SL"},{"$f":"'2024 FALL CALCULATOR'!D83","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E83","v":0},{"$f":"'2024 FALL CALCULATOR'!H83","v":0},{"$f":"'2024 FALL CALCULATOR'!I83","v":0},{"$f":"'2024 FALL CALCULATOR'!P83","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C84","v":"Forbid® "},{"$f":"'2024 FALL CALCULATOR'!D84","v":"8 fl.oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E84","v":0},{"$f":"'2024 FALL CALCULATOR'!H84","v":0},{"$f":"'2024 FALL CALCULATOR'!I84","v":0},{"$f":"'2024 FALL CALCULATOR'!P84","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C85","v":"Merit® 75 WSP"},{"$f":"'2024 FALL CALCULATOR'!D85","v":"4x1.6 oz"},{"$f":"'2024 FALL CALCULATOR'!E85","v":0},{"$f":"'2024 FALL CALCULATOR'!H85","v":0},{"$f":"'2024 FALL CALCULATOR'!I85","v":0},{"$f":"'2024 FALL CALCULATOR'!P85","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C86","v":"Merit 2F"},{"$f":"'2024 FALL CALCULATOR'!D86","v":"1 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E86","v":0},{"$f":"'2024 FALL CALCULATOR'!H86","v":0},{"$f":"'2024 FALL CALCULATOR'!I86","v":0},{"$f":"'2024 FALL CALCULATOR'!P86","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C87","v":"Prograss® EC"},{"$f":"'2024 FALL CALCULATOR'!D87","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E87","v":0},{"$f":"'2024 FALL CALCULATOR'!H87","v":0},{"$f":"'2024 FALL CALCULATOR'!I87","v":0},{"$f":"'2024 FALL CALCULATOR'!P87","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C88","v":"Proxy® "},{"$f":"'2024 FALL CALCULATOR'!D88","v":"2.5 gal. jug"},{"$f":"'2024 FALL CALCULATOR'!E88","v":0},{"$f":"'2024 FALL CALCULATOR'!H88","v":0},{"$f":"'2024 FALL CALCULATOR'!I88","v":0},{"$f":"'2024 FALL CALCULATOR'!P88","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C89","v":"Revolver®(32 oz. bottle)"},{"$f":"'2024 FALL CALCULATOR'!D89","v":"32 oz bottle"},{"$f":"'2024 FALL CALCULATOR'!E89","v":0},{"$f":"'2024 FALL CALCULATOR'!H89","v":0},{"$f":"'2024 FALL CALCULATOR'!I89","v":0},{"$f":"'2024 FALL CALCULATOR'!P89","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C90","v":"Sencor® 75"},{"$f":"'2024 FALL CALCULATOR'!D90","v":"5 lb.bottle"},{"$f":"'2024 FALL CALCULATOR'!E90","v":0},{"$f":"'2024 FALL CALCULATOR'!H90","v":0},{"$f":"'2024 FALL CALCULATOR'!I90","v":0},{"$f":"'2024 FALL CALCULATOR'!P90","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C91","v":"Topchoice®"},{"$f":"'2024 FALL CALCULATOR'!D91","v":"50 lb. bag"},{"$f":"'2024 FALL CALCULATOR'!E91","v":0},{"$f":"'2024 FALL CALCULATOR'!H91","v":0},{"$f":"'2024 FALL CALCULATOR'!I91","v":0},{"$f":"'2024 FALL CALCULATOR'!P91","v":""}]
[null,null,null,null,null,{"$f":"SUM(F20:F78)","v":5478}]
[]
[]
[null,"Summary"]
[null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[]
[null,{"$f":"'2024 FALL CALCULATOR'!B97","v":"Total Before Off Invoice Volume Discounts"},null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E97","v":5478}]
[null,{"$f":"'2024 FALL CALCULATOR'!B98","v":"Off Invoice Volume Discount"},null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E98","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B99","v":"Invoice Total "},null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E99","v":5478}]
[null,"Purchase Tier Level \nStandard calculation assumes order is invoiced by Oct 31, 2024 and will receive 1% Oct bonus to purchase tier rebate",null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E100","v":0.04}]
[null,"Rebate \nTotal Program Purchase must be a minimum of $5,000 to receive rebates",null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E101","v":494.12}]
[null,{"$f":"'2024 FALL CALCULATOR'!B102","v":"Net Total after Rebate"},null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E102","v":4983.88}]
[null,"Rebate % \nTotal Program Purchase must be a minimum of $5,000 to receive rebates",null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E103","v":9.0200803212851413E-2}]
[null,{"$f":"'2024 FALL CALCULATOR'!B104","v":"Total Savings (Rebates + Off Invoice Volume Discounts)"},null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E104","v":494.12}]
[null,{"$f":"'2024 FALL CALCULATOR'!B105","v":"Total Savings % (Rebates + Off Invoice Volume Discounts)"},null,null,null,null,{"$f":"'2024 FALL CALCULATOR'!E105","v":9.0200803212851413E-2}]
[]
[null,{"$f":"CONCATENATE(\"Estimated MER points to be earned in the Product Cart: \",TEXT(IF(AND(G90 <>\"\", G90 > 0),G90*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned in the Product Cart: 49,412"}]

{"sheet":"Pricing","index":2,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":true,"merged":[[2,4,2,6]]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5]
[]
[null,null,null,null,"In Season Price"]
["Product","National","CA","WA","National","CA","WA","Dist Suggested Min Price (DSMP)"]
["26 GT®",503.9,503.9,503.9,503.9,503.9,503.9]
["Acclaim Accelerate (0.5 gal)",45.65,45.65,45.65,45.65,45.65,45.65,55]
["Acclaim Accelerate (2.5 gal)",219.95,219.95,219.95,219.95,219.95,219.95,265]
["Acclaim® Extra (1 gal)",665.2,665.2,665.2,665.2,665.2,665.2]
["Altus (64 fl.oz. bottle), 1-15",428.4,439.22,431.4,428.4,439.22,431.4]
["Altus (64 fl.oz. bottle), 16-31",406.98,417.26,409.82,428.4,439.22,431.4]
["Altus (64 fl.oz. bottle), 32+",385.56,395.3,388.26,428.4,439.22,431.4]
["Armada® 50 WDG",114,114,114,114,114,114]
["Banol® ",1254,1285.6500000000001,1262.8,1254,1285.6500000000001,1262.8]
["Castlon™ (1 gal.)",2600,"N/A",2618.1999999999998,2600,"N/A",2618.1999999999998]
["Castlon™ (16oz.)",366.5,"N/A",369.07,366.5,"N/A",369.07]
["Celsius",128.4,131.63999999999999,129.30000000000001,128.4,131.63999999999999,129.30000000000001]
["Celsius XTRA",166.4,"N/A",167.56,166.4,"N/A",167.56]
["Chipco Signature Stressgard (1-8 units)",392.8,402.72,395.54,392.8,402.72,395.54]
["Chipco Signature Stressgard (9+ units)",368.8,378.12,371.38,392.8,402.72,395.54]
["Chipco® Choice",161,161,161,161,161,161]
["Densicor®",739.6,"N/A",744.78,739.6,"N/A",744.78]
["Dylox 420 SL",218.75,218.75,218.75,218.75,218.75,218.75]
["Exteris® Stressgard®",366,375.25,368.55,366,375.25,368.55]
["Fiata® Stressgard®",190,194.8,191.35,190,194.8,191.35]
["Forbid® ",244.18,244.18,244.18,244.18,244.18,244.18]
["Indemnify® (1-2 units)",1963.6,2013.18,1977.34,1963.6,2013.18,1977.34]
["Indemnify® (3+ units)",1767.2,1811.82,1779.58,1963.6,2013.18,1977.34]
["Interface® Stressgard® (1-5 units)",561,575.15,564.95000000000005,561,575.15,564.95000000000005]
["Interface® Stressgard® (6+ units)",494,506.45,497.45,561,575.15,564.95000000000005]
["Merit 2F",40.15,40.15,40.15,40.15,40.15,40.15]
["Merit® 75 WSP",102.64,102.64,102.64,102.64,102.64,102.64]
["Mirage® Stressgard®",488,500.3,491.4,488,500.3,491.4]
["Prograss® EC",368.25,368.25,368.25,368.25,368.25,368.25]
["Proxy® ",102.25,102.25,102.25,102.25,102.25,102.25]
["Resilia ™",918.87,"N/A",925.29,918.87,"N/A",925.29]
["Revolver® (87 oz. bottle)",758,777.14,763.3,758,777.14,763.3]
["Revolver®(32 oz. bottle)",288.56,288.56,288.56,288.56,288.56,288.56]
["Ronstar® FLO 1 to 11",552,565.95000000000005,555.85,552,565.95000000000005,555.85]
["Ronstar® FLO 12 to 39",453,464.45,456.15,552,565.95000000000005,555.85]
["Ronstar® FLO 40+",393,402.9,395.75,552,565.95000000000005,555.85]
["Sencor® 75",586,586,586,586,586,586]
["Signature XTRA Stressgard (1 to 23)",210.4,215.72,211.88,210.4,215.72,211.88]
["Signature XTRA Stressgard (24+)",192.8,197.66,194.14,210.4,215.72,211.88]
["Specticle® FLO (1-6 units)",1968.4,2018.1,1982.18,2072,2117.06,2086.5]
["Specticle® FLO (14-25 units)",1657.6,1699.46,1669.2,1778.4,1817.08,1790.84]
["Specticle® FLO (7-13 units)",1895.88,1943.76,1909.16,2072,2117.06,2086.5]
["Specticle® FLO (26+ units)",1533.28,1572,1544.02,1778.4,1817.08,1790.84]
["Specticle® G",128,131,129,128,131,129]
["Tartan® Stressgard® (1 to 5 units)",1033,1059.0999999999999,1040.25,1033,1059.0999999999999,1040.25]
["Tartan® Stressgard® 6+",940,963.75,946.6,1033,1059.0999999999999,1040.25]
["Terradex™ Crabgrass & Broadleaf (1 gal)",94.62,94.62,94.62,94.62,94.62,94.62,114]
["Terradex™ Crabgrass & Broadleaf (2.5 gal)",226.18,226.18,226.18,226.18,226.18,226.18,272.5]
["Terradex™ Power Premix (2.5 gal)",186.75,186.75,186.75,186.75,186.75,186.75,225]
["Terradex™ Power Premix (30 gal)",2041.8,2041.8,2041.8,2041.8,2041.8,2041.8,2460]
["Terradex™ Quick Strike (1 gal)",66.400000000000006,66.400000000000006,66.400000000000006,66.400000000000006,66.400000000000006,66.400000000000006,80]
["Terradex™ Quick Strike (2.5 gal)",157.69999999999999,157.69999999999999,157.69999999999999,157.69999999999999,157.69999999999999,157.69999999999999,190]
["Terradex™ Quick Strike (30 gal)",1792.8,1792.8,1792.8,1792.8,1792.8,1792.8,2160]
["Tetrino®",498,510.2,501.48,498,510.2,501.48]
["Topchoice®",63,63,63,63,63,63]
["Tribute® Total ",413.6,424.04,416.5,413.6,424.04,416.5]
["Kontos (1-11 units)",221.6,"N/A","N/A",221.6,"N/A","N/A"]
["Kontos (12-29 units)",210.52,"N/A","N/A",221.6,"N/A","N/A"]
["Kontos (30+ units)",199.44,"N/A","N/A",221.6,"N/A","N/A"]