{"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":106,"n_cols":51,"rows_kept":106,"cut":false,"hidden":false,"merged":[[65,50,67,50],[65,23,67,23],[65,24,67,24],[65,25,67,25],[65,26,67,26],[65,27,67,27],[65,28,67,28],[65,29,67,29],[65,30,67,30],[65,31,67,31],[65,32,67,32],[65,33,67,33],[65,37,67,37],[65,38,67,38],[24,30,26,30],[54,29,57,29],[65,49,67,49],[65,47,67,47],[65,48,67,48],[24,47,26,47],[24,48,26,48],[24,37,26,37],[24,38,26,38],[24,36,26,36],[24,29,26,29],[24,28,26,28],[65,36,67,36],[24,26,26,26],[24,27,26,27],[65,1,67,1],[54,1,57,1],[24,15,26,15],[24,13,25,13],[24,7,26,7],[24,8,26,8],[48,1,50,1],[24,25,26,25],[44,1,45,1],[65,12,67,12],[65,16,67,16],[65,17,67,17],[105,1,105,4],[24,24,26,24],[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,18,26,18],[24,23,26,23],[24,14,26,14],[101,1,101,3],[99,1,99,3],[24,5,26,5],[100,1,100,3],[102,1,102,3],[103,1,103,3],[97,1,97,3],[98,1,98,3],[65,15,67,15],[93,1,93,4],[96,1,96,3],[95,1,95,3],[65,13,66,13],[65,14,67,14],[83,1,86,1],[65,11,66,11],[65,2,67,2],[65,3,67,3],[65,4,67,4],[65,5,67,5],[12,10,12,13],[24,17,26,17],[15,1,15,2],[24,11,25,11],[24,12,26,12],[65,18,67,18],[65,19,67,19],[24,16,26,16],[24,19,26,19],[24,20,26,20],[65,20,67,20],[65,6,67,6],[65,7,67,7],[65,8,67,8],[65,9,67,9],[65,10,67,10]]}
[null,null,null,null,null,null,null,null,null,{"$f":" U13","v":"Fall Solutions National Large Lawn Calculator - version 2024-0011-0002"}]
[]
[null,{"$f":"IF(C22=\"National\", \"NATIONAL\", IF(C22=\"CA\",\"CALIFORNIA\",\"WASHINGTON\"))","v":"NATIONAL"},{"$f":" B3& \" 2024 Fall SOLUTIONS LARGE LAWN CALCULATOR\"","v":"NATIONAL 2024 Fall SOLUTIONS LARGE LAWN CALCULATOR"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-0011-0002"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" \"Fall Solutions National Large Lawn Calculator - version \" & U5","v":"Fall Solutions National Large Lawn Calculator - version 2024-0011-0002"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,"TOTAL PURCHASE REBATE","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,"MINIMUM QTY","MAXIMUM QTY","REBATE %",null,null,null,"Date Start","2024-08-01"]
[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,5000,13999,0.03,null,null,null,"Date end","2024-10-30"]
[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,"ADMIN COLUMNS",null,null,null,null,null,null,null,null,null,null,null,14000,22499,0.04,null,null,null,"Rebate",{"$f":"IF(AND(TODAY() >AR16, TODAY() < AR17),0.01,0)","v":0}," If Purchase tier rebate > 7% then Early Pay 0%"]
[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,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,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,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,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,"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,"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 **†","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,"Specticle FLO Loyalty Bonus Matrix"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP(AD32,$AP$27:$AR$27,$AP$31:$AR$34)),0)","v":0},null,{"$f":"IF(AND(I91<>\"\",I91> 0,AL91>0),IF(AL91>0.07,AL91,(AL91+$AR$18)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"IF(OR(AV28 =\"\",AK28+AL28=0),0,E28*AV28*(AK28+AL28))","v":0},{"$f":"IF(AND(E28<>\"\",E28>0),((I28/E28)-((J28+K28+L28+N28)/E28)),\"\")","v":""},{"$f":"IF(AND(E28<>\"\",E28>0), E28*O28,\"\")","v":""},{"$f":"R28/43.56","v":0.16069788797061524},7,{"$f":"IF(AND(TRIM(R28)<>\"\",TRIM(E28)<>\"\"),(E28*64)/R28,\"\")","v":""},{"$f":"IF(E28<>0,P28/S28,0)","v":0},{"$f":"T28/43.56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E28 <>\"\",AM$91>=5000,AL$91<=0.07),0.01,0)","v":0},{"$f":"IF(E28 <>\"\", AL$91,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":"AV28*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,0,"",{"$f":"IF(AND(E29<>\"\",E29>0), E29*O29,\"\")","v":""},{"$f":"R29/43.56","v":0.16069788797061524},7,{"$f":"IF(AND(TRIM(R29)<>\"\",TRIM(E29)<>\"\"),(E29*64)/R29,\"\")","v":""},{"$f":"IF(E29<>0,P29/S29,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},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,0,"",{"$f":"IF(AND(E30<>\"\",E30>0), E30*O30,\"\")","v":""},{"$f":"R30/43.56","v":0.16069788797061524},7,"",{"$f":"IF(E30<>0,P30/S30,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<X31,X31=0),0,E31*Y31)","v":0},{"$f":"IF(OR(E31 =\"\",E31<Z31,AA31=\"No\",Z31=0),0,E31*AB31)","v":0},null,null,0,{"$f":"IF(AND(E31<>\"\",E31>0),((I31/E31)-((J31+K31+L31+N31)/E31)),\"\")","v":""},{"$f":"IF(AND(E31<>\"\",E31>0), E31*O31,\"\")","v":""},2,{"$f":"Q31*43.56","v":87.12},{"$f":"IF(AND(TRIM(R31)<>\"\",TRIM(E31)<>\"\"),(E31*319.999849189052)/R31,\"\")","v":""},{"$f":"IF(E31<>0,P31/S31,0)","v":0},{"$f":"T31/43.56","v":0},null,null,2,25,2,{"$f":"IF(AND(OR((E34+E35)>=Z35,(E53+E54)>=Z54),E31>=Z31),\"Yes\",\"No\")","v":"No"},75,null,null,null,null,null,null,null,null,0,0,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<X32,X32=0),0,E32*Y32)","v":0},null,{"$f":"IFERROR(IF(I32*AE32<>0,I32*AE32,0),0)","v":0},null,0,{"$f":"IF(AND(E32<>\"\",E32>0),(H32-(SUM(J32:N32)/E32)),\"\")","v":""},{"$f":"IF(AND(E32<>\"\",E32>0), E32*O32,\"\")","v":""},{"$f":"R32/43.56","v":0.11294765840220385},4.92,{"$f":"IF(AND(TRIM(R32)<>\"\",TRIM(E32)<>\"\"),(E32*10)/R32,\"\")","v":""},{"$f":"IF(E32<>0,P32/S32,0)","v":0},{"$f":"T32/43.56","v":0},null,null,8,10,null,null,null,{"$f":"IF(E32>=X32,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AC$32+$AC$33+$AC$52+$AC$62>=3,3,$AC$32+$AC$33+$AC$52+$AC$62=2,2,$AC$32+$AC$33+$AC$52+$AC$62=1,1,$AC$32+$AC$33+$AC$52+$AC$62<=0,0),0)","v":0},{"$f":"IFERROR(IF(E32>=X32,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP(AD32,$AP$27:$AR$27,$AP$31:$AR$34))),0),0)","v":0},null,null,null,null,null,{"$f":"IF(AND(E32 <>\"\",AM$91>=5000,AL$91<=0.07),$AR$18,0)","v":0},0,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<X33,X33=0),0,E33*Y33)","v":0},null,{"$f":"IFERROR(IF(I33*AE33<>0,I33*AE33,0),0)","v":0},null,0,{"$f":"IF(AND(E33<>\"\",E33>0),(H33-(SUM(J33:N33)/E33)),\"\")","v":""},"",{"$f":"R33/43.56","v":0.2295684113865932},10,{"$f":"IF(AND(TRIM(R33)<>\"\",TRIM(E33)<>\"\"),(E33*10)/R33,\"\")","v":""},0,0,null,null,8,10,null,null,null,{"$f":"IF(E33>=X33,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AC$32+$AC$33+$AC$52+$AC$62>=3,3,$AC$32+$AC$33+$AC$52+$AC$62=2,2,$AC$32+$AC$33+$AC$52+$AC$62=1,1,$AC$32+$AC$33+$AC$52+$AC$62<=0,0),0)","v":0},{"$f":"IFERROR(IF(E33>=X33,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP(AD33,$AP$27:$AR$27,$AP$31:$AR$34))),0),0)","v":0},null,null,null,null,null,{"$f":"IF(AND(E33 <>\"\",AM$91>=5000,AL$91<=0.07),$AR$18,0)","v":0},{"$f":"IF(E33 <>\"\", AL$91,0)","v":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 (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,0,"","",4,{"$f":"Q34*43.56","v":174.24},{"$f":"IF(AND(TRIM(R34)<>\"\",TRIM(E34)<>\"\"),(E34*176)/R34,\"\")","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 (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<Z35,AA35=\"No\",Z35=0),0,E35*AB35)","v":0},null,null,0,"","",4,174.24,{"$f":"IF(AND(TRIM(R35)<>\"\",TRIM(E35)<>\"\"),(E35*176)/R35,\"\")","v":""},0,0,null,null,null,null,12,{"$f":"IF(AND((E34+E35)>=Z35,E31>=Z31),\"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<Z36,AA36=\"No\",Z36=0),0,E36*AB36)","v":0},null,null,0,"","",0.18,{"$f":"Q36*43.56","v":7.8407999999999998},{"$f":"IF(AND(TRIM(R36)<>\"\",TRIM(E36)<>\"\"),(E36*128)/R36,\"\")","v":""},0,0,null,null,null,null,1,{"$f":"IFERROR(_xlfn.IFS(AND(AA31=\"Yes\",AA35=\"Yes\",E36>=1),\"Yes\",AND(AA31=\"Yes\",AA54=\"Yes\",E36>=1),\"Yes\",AND(AA44=\"Yes\",AA47=\"Yes\",E36>=1),\"Yes\",AND(AA39=\"Yes\",AA61=\"Yes\",E36>=1),\"Yes\",AND(AA60=\"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,0,"","",0.18,{"$f":"Q37*43.56","v":7.8407999999999998},{"$f":"IF(AND(TRIM(R37)<>\"\",TRIM(E37)<>\"\"),(E37*16)/R37,\"\")","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<X38,X38=0),0,E38*Y38)","v":0},{"$f":"IF(OR(E38 =\"\",E38<Z38,AA38=\"No\",Z38=0),0,E38*AB38)","v":0},null,null,0,"","",{"$f":"0.196","v":0.19600000000000001},8.5377600000000005,{"$f":"IF(AND(TRIM(R38)<>\"\",TRIM(E38)<>\"\"),(E38*51)/R38,\"\")","v":""},0,0,null,null,1,35,4,{"$f":"IFERROR(_xlfn.IFS(AND(AA31=\"Yes\",AA35=\"Yes\",E38>=Z38),\"Yes\",AND(AA31=\"Yes\",AA54=\"Yes\",E38>=Z38),\"Yes\",AND(AA44=\"Yes\",AA47=\"Yes\",E38>=Z38),\"Yes\",AND(AA39=\"Yes\",AA61=\"Yes\",E38>=Z38),\"Yes\",AND(AA60=\"Yes\",E38>=Z38),\"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<Z39,AA39=\"No\",Z39=0),0,E39*AB39)","v":0},null,null,0,"",{"$f":"IF(AND(E39<>\"\",E39>0), E39*O39,\"\")","v":""},4,174.24,{"$f":"IF(AND(TRIM(R39)<>\"\",TRIM(E39)<>\"\"),(E39*51)/R39,\"\")","v":""},{"$f":"IF(E39<>0,P39/S39,0)","v":0},{"$f":"T39/43.56","v":0},null,null,null,null,16,{"$f":"IF(AND(E39>=Z39,E61>=Z61),\"Yes\",\"No\")","v":"No"},45,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'!$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<X40,X40=0),0,E40*Y40)","v":0},null,null,null,0,"","",5,217.8,"",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,0,"","",{"$f":"R41/43.56","v":0.39003673094582181},16.989999999999998,{"$f":"IF(AND(TRIM(R41)<>\"\",TRIM(E41)<>\"\"),(E41*17.1)/R41,\"\")","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,0,"","",{"$f":"R42/43.56","v":0.39003673094582181},16.989999999999998,{"$f":"IF(AND(TRIM(R42)<>\"\",TRIM(E42)<>\"\"),(E42*17.1)/R42,\"\")","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,0,"","",4,{"$f":"Q43*43.56","v":174.24},{"$f":"IF(AND(TRIM(R43)<>\"\",TRIM(E43)<>\"\"),(E43*319.999849189052)/R43,\"\")","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<X44,X44=0),0,E44*Y44)","v":0},{"$f":"IF(OR(E44 =\"\",E44<Z44,AA44=\"No\",Z44=0),0,E44*AB44)","v":0},null,null,0,"","",4,174.24,{"$f":"IF(AND(TRIM(R44)<>\"\",TRIM(E44)<>\"\"),(E44*319.999849189052)/R44,\"\")","v":""},0,0,null,null,6,25,6,{"$f":"IF(AND(E44>=Z44,E47>=Z47),\"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 (12-29 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":210.52},0,null,{"$f":"IF(OR(E45 =\"\",E45<Z45,AA45=\"No\",Z45=0),0,E45*AB45)","v":0},null,null,null,"","",null,5,{"$f":"IF(AND(TRIM(R45)<>\"\",TRIM(E45)<>\"\"),(E45*8.45)/R45,\"\")","v":""},0,0,null,null,null,null,12,{"$f":"IF(AND(E63>=Z63,(E45+E46)>=Z46),\"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'!$C45,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'!$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":199.44},0,null,{"$f":"IF(OR(E46 =\"\",E46<Z46,AA46=\"No\",Z46=0),0,E46*AB46)","v":0},null,null,null,"","",null,5,{"$f":"IF(AND(TRIM(R46)<>\"\",TRIM(E46)<>\"\"),(E46*8.45)/R46,\"\")","v":""},0,0,null,null,null,null,12,{"$f":"IF(AND(E63>=Z63,(E45+E46)>=Z46),\"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":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'!$C47,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'!$C47,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":488},0,null,{"$f":"IF(OR(E47 =\"\",E47<Z47,AA47=\"No\",Z47=0),E47*AH47,E47*(AB47+AH47))","v":0},null,null,{"$f":"IF(OR(AV47 =\"\",AK47+AL47=0),0,E47*AV47*(AK47+AL47))","v":0},"","",1,43.56,{"$f":"IF(AND(TRIM(R47)<>\"\",TRIM(E47)<>\"\"),(E47*319.999849189052)/R47,\"\")","v":""},0,0,null,null,null,null,2,{"$f":"IF(AND(E44>=Z44,E47>=Z47),\"Yes\",\"No\")","v":"No"},25,null,null,null,1,{"$f":"IF(AND(E47>=AF47,E36>=1),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AG47=\"Yes\",50,0)","v":0},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":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'!$C48,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'!$C48,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":918.87},0,null,{"$f":"IF(OR(E48 =\"\",E48<Z48,AA48=\"No\",Z48=0),0,E48*AB48)","v":0},null,null,{"$f":"IF(OR(AV48 =\"\",AK48+AL48=0),0,E48*AV48*(AK48+AL48))","v":0},"","",4,174.24,{"$f":"IF(AND(TRIM(R48)<>\"\",TRIM(E48)<>\"\"),(E48*348.16)/R48,\"\")","v":""},0,0,null,null,null,null,4,{"$f":"IFERROR(_xlfn.IFS(AND(AA31=\"Yes\",AA35=\"Yes\",E48>=Z48),\"Yes\",AND(AA31=\"Yes\",AA54=\"Yes\",E48>=Z48),\"Yes\",AND(AA44=\"Yes\",AA47=\"Yes\",E48>=Z48),\"Yes\",AND(AA39=\"Yes\",AA61=\"Yes\",E48>=Z48),\"Yes\",AND(AA60=\"Yes\",E48>=Z48),\"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'!$C48,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'!$C49,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'!$C49,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":552},{"$f":"IF(ISERROR(E49*H49),0,E49*H49)","v":0},null,null,null,null,null,"","",{"$f":"R49/43.56","v":2.3298898071625342},101.49,{"$f":"IF(AND(TRIM(R49)<>\"\",TRIM(E49)<>\"\"),(E49*319.999849189052)/R49,\"\")","v":""},{"$f":"IF(E49<>0,P49/S49,0)","v":0},{"$f":"T49/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'!$C49,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'!$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":453},0,null,null,null,null,null,"","",{"$f":"R50/43.56","v":2.3298898071625342},101.49,{"$f":"IF(AND(TRIM(R50)<>\"\",TRIM(E50)<>\"\"),(E50*319.999849189052)/R50,\"\")","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'!$C50,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'!$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":393},0,null,null,null,null,null,"","",{"$f":"R51/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'!$C51,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'!$C52,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'!$C52,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":758},0,{"$f":"IF(OR(E52 =\"\",E52<X52,X52=0),0,E52*Y52)","v":0},null,{"$f":"IFERROR(IF(I52*AE52<>0,I52*AE52,0),0)","v":0},null,{"$f":"IF(OR(AV52 =\"\",AK52+AL52=0),0,E52*AV52*(AK52+AL52))","v":0},"","",{"$f":"R52/43.56","v":0.39990817263544537},17.420000000000002,{"$f":"IF(AND(TRIM(R52)<>\"\",TRIM(E52)<>\"\"),(E52*87)/R52,\"\")","v":""},0,0,null,null,4,35,null,null,null,{"$f":"IF(E52>=X52,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AC$32+$AC$33+$AC$52+$AC$62>=3,3,$AC$32+$AC$33+$AC$52+$AC$62=2,2,$AC$32+$AC$33+$AC$52+$AC$62=1,1,$AC$32+$AC$33+$AC$52+$AC$62<=0,0),0)","v":0},{"$f":"IFERROR(IF(E52>=X52,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP(AD52,$AP$27:$AR$27,$AP$31:$AR$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'!$C52,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'!$C53,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'!$C53,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":210.4},0,null,null,null,null,{"$f":"IF(OR(AV53 =\"\",AK53+AL53=0),0,E53*AV53*(AK53+AL53))","v":0},"","",4,{"$f":"Q53*43.56","v":174.24},{"$f":"IF(AND(TRIM(R53)<>\"\",TRIM(E53)<>\"\"),(E53*87.9999998763089)/R53,\"\")","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'!$C53,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'!$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":192.8},0,null,{"$f":"IF(OR(E54 =\"\",E54<Z54,AA54=\"No\",Z54=0),0,E54*AB54)","v":0},null,null,{"$f":"IF(OR(AV54 =\"\",AK54+AL54=0),0,E54*AV54*(AK54+AL54))","v":0},"","",4,174.24,{"$f":"IF(AND(TRIM(R54)<>\"\",TRIM(E54)<>\"\"),(E54*87.9999998763089)/R54,\"\")","v":""},0,0,null,null,null,null,24,{"$f":"IF(AND((E53+E54)>=Z54,E31>=Z31),\"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'!$C54,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. Must be a large Lawn Care Company  to qualify for Specticle rebate","Specticle® FLO (1-6 units)","1 gal. 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":2072},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":1968.4},0,null,null,{"$f":"IFERROR(IF(I55*AE55<>0,I55*AE55,0),0)","v":0},null,null,"","",{"$f":"R55/43.56","v":0.1379706152433425},6.01,{"$f":"IF(AND(TRIM(R55)<>\"\",TRIM(E55)<>\"\"),(E55*127.999939675621)/R55,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(E55+E56+E57+E58>=26,26,E55+E56+E57+E58>=14,14,E55+E56+E57+E58>=7,7,E55+E56+E57+E58>=1,1,E55+E56+E57+E58<=0,0)","v":0},{"$f":"IFERROR(IF(E55>=0,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP($AD$52,$AP$27:$AR$27,$AP$31:$AR$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'!$C55,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'!$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":1895.88},0,null,null,{"$f":"IFERROR(IF(I56*AE56<>0,I56*AE56,0),0)","v":0},null,null,"","",0.1379706152433425,6.01,{"$f":"IF(AND(TRIM(R56)<>\"\",TRIM(E56)<>\"\"),(E56*127.999939675621)/R56,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E56>=0,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP($AD$52,$AP$27:$AR$27,$AP$31:$AR$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":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'!$C57,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'!$C57,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1657.6},0,null,null,{"$f":"IFERROR(IF(I57*AE57<>0,I57*AE57,0),0)","v":0},null,null,"","",{"$f":"R57/43.56","v":0.1379706152433425},6.01,{"$f":"IF(AND(TRIM(R57)<>\"\",TRIM(E57)<>\"\"),(E57*127.999939675621)/R57,\"\")","v":""},0,0,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E57>=0,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP($AD$52,$AP$27:$AR$27,$AP$31:$AR$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":1657.6},0]
[null,null,"Specticle® FLO (26+ 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":1533.28},0,null,null,{"$f":"IFERROR(IF(I58*AE58<>0,I58*AE58,0),0)","v":0},{"$f":"IFERROR(IF(E58*AJ58<>0,E58*AJ58,0),0)","v":0},null,"","",0.1379706152433425,6.01,{"$f":"IF(AND(TRIM(R58)<>\"\",TRIM(E58)<>\"\"),(E58*127.999939675621)/R58,\"\")","v":""},0,0,null,null,26,null,null,null,null,null,null,{"$f":"IFERROR(IF(E58>=0,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP($AD$52,$AP$27:$AR$27,$AP$31:$AR$34))),0),0)","v":0},null,null,null,{"$f":"IFERROR(_xlfn.IFS(E58>=52,52,E58>=38,38,E58>=26,26),0)","v":0},{"$f":"IFERROR(_xlfn.IFS(AI58=52,242,AI58=38,182,AI58=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'!$C58,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'!$C59,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'!$C59,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":128},0,{"$f":"IF(OR(E59 =\"\",E59<X59,X59=0),0,E59*Y59)","v":0},null,null,null,{"$f":"IF(OR(AV59 =\"\",AK59+AL59=0),0,E59*AV59*(AK59+AL59))","v":0},"","",null,150,{"$f":"IF(AND(TRIM(R59)<>\"\",TRIM(E59)<>\"\"),(E59*50)/R59,\"\")","v":""},{"$f":"IF(E59<>0,P59/S59,0)","v":0},0,null,null,20,11.5,null,null,null,null,null,{"$f":"IFERROR(IF(E59>=0,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP($AD$52,$AP$27:$AR$27,$AP$31:$AR$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'!$C59,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'!$C60,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'!$C60,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":1033},{"$f":"IF(ISERROR(E60*H60),0,E60*H60)","v":0},{"$f":"IF(OR(E60 =\"\",E60<X60,X60=0),0,E60*Y60)","v":0},null,null,null,{"$f":"IF(OR(AV60 =\"\",AK60+AL60=0),0,E60*AV60*(AK60+AL60))","v":0},"",{"$f":"IF(AND(E60<>\"\",E60>0), E60*O60,\"\")","v":""},1.5,{"$f":"Q60*43.56","v":65.34},{"$f":"IF(AND(TRIM(R60)<>\"\",TRIM(E60)<>\"\"),(E60*319.999849189052)/R60,\"\")","v":""},{"$f":"IF(E60<>0,P60/S60,0)","v":0},{"$f":"T60/43.56","v":0},null,null,2,20,2,{"$f":"IF(AND((E60+E61)>=Z60,E48>=Z48),\"Yes\",\"No\")","v":"No"},0,null,null,{"$f":"IFERROR(IF(E60>=0,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP($AD$52,$AP$27:$AR$27,$AP$31:$AR$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":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'!$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":940},0,0,{"$f":"IF(OR(E61 =\"\",E61<Z61,AA61=\"No\",Z61=0),0,E61*AB61)","v":0},null,null,{"$f":"IF(OR(AV61 =\"\",AK61+AL61=0),0,E61*AV61*(AK61+AL61))","v":0},"","",1.5,65.34,{"$f":"IF(AND(TRIM(R61)<>\"\",TRIM(E61)<>\"\"),(E61*319.999849189052)/R61,\"\")","v":""},{"$f":"IF(E61<>0,P61/S61,0)","v":0},0,null,null,2,20,6,{"$f":"IF(AND(E61>=Z61,E39>=Z39),\"Yes\",\"No\")","v":"No"},30,null,null,{"$f":"IFERROR(IF(E61>=0,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP($AD$52,$AP$27:$AR$27,$AP$31:$AR$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'!$C61,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'!$C62,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'!$C62,Pricing!$A$5:$A$100,0),MATCH($C$22,Pricing!$A$4:$D$4,0))","v":413.6},0,{"$f":"IF(OR(E62 =\"\",E62<X62,X62=0),0,E62*Y62)","v":0},null,{"$f":"IFERROR(IF(I62*AE62<>0,I62*AE62,0),0)","v":0},null,{"$f":"IF(OR(AV62 =\"\",AK62+AL62=0),0,E62*AV62*(AK62+AL62))","v":0},"",{"$f":"IF(AND(E62<>\"\",E62>0), E62*O62,\"\")","v":""},2.2956841138659319E-2,1,{"$f":"IF(AND(TRIM(R62)<>\"\",TRIM(E62)<>\"\"),(E62*6)/R62,\"\")","v":""},0,0,null,null,6,30,null,null,null,{"$f":"IF(E62>=X62,1,0)","v":0},{"$f":"IFERROR(_xlfn.IFS($AC$32+$AC$33+$AC$52+$AC$62>=3,3,$AC$32+$AC$33+$AC$52+$AC$62=2,2,$AC$32+$AC$33+$AC$52+$AC$62=1,1,$AC$32+$AC$33+$AC$52+$AC$62<=0,0),0)","v":0},{"$f":"IFERROR(IF(E62>=X62,(_xlfn.XLOOKUP($AD$55,$AO$31:$AO$34,_xlfn.XLOOKUP(AD62,$AP$27:$AR$27,$AP$31:$AR$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":413.6},0]
[null,"$25 Select for 4+/Tier\nSee State-Level Bermudagrass Mite 24C","Tetrino®","1 gal 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":498},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":498},0,{"$f":"IF(OR(E63 =\"\",E63<X63,X63=0),0,E63*Y63)","v":0},{"$f":"IF(OR(E63 =\"\",E63<Z63,AA63=\"No\",Z63=0),0,E63*AB63)","v":0},null,null,{"$f":"IF(OR(AV63 =\"\",AK63+AL63=0),0,E63*AV63*(AK63+AL63))","v":0},"","",null,16,{"$f":"IF(AND(TRIM(R63)<>\"\",TRIM(E63)<>\"\"),(E63*127.999939675621)/R63,\"\")","v":""},0,0,null,null,4,25,4,{"$f":"IF(AND(E63>=Z63,(E45+E46)>=Z46),\"Yes\",\"No\")","v":"No"},15,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'!$C63,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":498},0]
[]
[null,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 **†","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,{"$f":"N27","v":0}]
[null,"$24 Select 1+/Tier","Armada® 50 WDG","2 lb. bottle",null,{"$f":"INDEX(Pricing!$E$5:$G$101,MATCH('2024 FALL CALCULATOR'!$C69,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":114},{"$f":"IF(ISERROR(E69*F69),\"\",E69*F69)","v":0},null,{"$f":"IF(E69*H69= 0,0,E69*H69)","v":0},{"$f":"IF(OR(E69 =\"\",E69<X69,X69=0),0,E69*Y69)","v":0},null,null,null,{"$f":"IF(OR(AV69 =\"\",AK69+AL69=0),0,E69*AV69*(AK69+AL69))","v":0},{"$f":"IF(AND(E69<>\"\",E69>0),(H69-(SUM(J69:N69)/E69)),\"\")","v":""},{"$f":"IF(AND(E69<>\"\",E69>0), E69*O69,\"\")","v":""},{"$f":"R69/43.56","v":0.5},21.78,{"$f":"IF(AND(TRIM(R69)<>\"\",TRIM(E69)<>\"\"),(E69*127.999939675621)/R69,\"\")","v":""},{"$f":"IF(I69<>0,P69/S69,0)","v":0},{"$f":"T69/43.56","v":0},null,null,1,24,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E69 <>\"\",AM$91>=5000,AL$91<=0.07),$AR$18,0)","v":0},{"$f":"IF(E69 <>\"\", AL$91,0)","v":0},{"$f":"IF(E69 = \"\",0,IFERROR(F69*E69,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(Pricing!$A$5:$D$100,MATCH('2024 FALL CALCULATOR'!$C69,Pricing!$A$5:$A$100,0),MATCH(\"National\",Pricing!$A$4:$D$4,0))","v":114},{"$f":"AV69*E69","v":0},{"$f":"INDEX(Pricing!$A$5:$K$100,MATCH('2024 FALL CALCULATOR'!$C69,Pricing!$A$5:$A$100,0),MATCH(\"Dist Suggested Min Price (DSMP)\",Pricing!$A$4:$K$4,0))","v":0},{"$f":"AX69*E69","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'!$C70,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":665.2},0,null,{"$f":"IF(E70*H70= 0,0,E70*H70)","v":0},{"$f":"IF(OR(E70 =\"\",E70<X70,X70=0),0,E70*Y70)","v":0},null,null,null,{"$f":"IF(OR(AV70 =\"\",AK70+AL70=0),0,E70*AV70*(AK70+AL70))","v":0},{"$f":"IF(AND(E70<>\"\",E70>0),(H70-(SUM(J70:N70)/E70)),\"\")","v":""},{"$f":"IF(AND(E70<>\"\",E70>0), E70*O70,\"\")","v":""},{"$f":"R70/43.56","v":0.5},21.78,{"$f":"IF(AND(TRIM(R70)<>\"\",TRIM(E70)<>\"\"),(E70*127.999939675621)/R70,\"\")","v":""},{"$f":"IF(I70<>0,P70/S70,0)","v":0},0,null,null,1,90,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E70 <>\"\",AM$91>=5000,AL$91<=0.07),$AR$18,0)","v":0},0,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":665.2},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},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'!$C71,Pricing!$A$5:$A$101,0),MATCH($C$22,Pricing!$E$4:$G$4,0))","v":45.65},0,null,{"$f":"IF(E71*H71= 0,0,E71*H71)","v":0},0,null,null,null,{"$f":"IF(OR(AV71 =\"\",AK71+AL71=0),0,E71*AX71*(AK71+AL71))","v":0},"","",1.45,{"$f":"Q71*43.56","v":63.161999999999999},{"$f":"IF(AND(TRIM(R71)<>\"\",TRIM(E71)<>\"\"),(E71*64)/R71,\"\")","v":""},0,0,null,null,1,{"$f":"AX71*0.05","v":2.75},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'!$C71,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'!$C71,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'!$C72,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,0,"","",1.45,63.161999999999999,{"$f":"IF(AND(TRIM(R72)<>\"\",TRIM(E72)<>\"\"),(E72*320)/R72,\"\")","v":""},0,0,null,null,1,{"$f":"AX72*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'!$C72,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'!$C72,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'!$C73,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,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(R73)<>\"\",TRIM(E73)<>\"\"),(E73*320)/R73,\"\")","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'!$C73,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'!$C73,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'!$C74,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,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(R74)<>\"\",TRIM(E74)<>\"\"),(E74*3840)/R74,\"\")","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'!$C74,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'!$C74,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'!$C75,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,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(R75)<>\"\",TRIM(E75)<>\"\"),(E75*127.999939675621)/R75,\"\")","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'!$C75,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'!$C75,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'!$C76,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,{"$f":"IF(OR(AV76 =\"\",AK76+AL76=0),0,E76*AX76*(AK76+AL76))","v":0},"","",1.5,65.34,{"$f":"IF(AND(TRIM(R76)<>\"\",TRIM(E76)<>\"\"),(E76*320)/R76,\"\")","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'!$C76,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'!$C76,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'!$C77,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,0,"","",1.5,65.34,{"$f":"IF(AND(TRIM(R77)<>\"\",TRIM(E77)<>\"\"),(E77*3840)/R77,\"\")","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'!$C77,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'!$C77,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'!$C78,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,0,"","",2.9,126.324,{"$f":"IF(AND(TRIM(R78)<>\"\",TRIM(E78)<>\"\"),(E78*127.999939675621)/R78,\"\")","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'!$C78,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'!$C78,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'!$C79,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,0,"","",2.9,126.324,{"$f":"IF(AND(TRIM(R79)<>\"\",TRIM(E79)<>\"\"),(E79*320)/R79,\"\")","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'!$C79,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'!$C79,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'!$C80,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,{"$f":"IF(OR(AV80 =\"\",AK80+AL80=0),0,E80*AV80*(AK80+AL80))","v":0},"","",4,174.24,{"$f":"IF(AND(TRIM(R80)<>\"\",TRIM(E80)<>\"\"),(E80*319.999849189052)/R80,\"\")","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'!$C80,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'!$C80,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,146.5,0,null,0,null,null,null,null,{"$f":"IF(OR(AV81 =\"\",AK81+AL81=0),0,E81*AV81*(AK81+AL81))","v":0},"","",null,25,{"$f":"IF(AND(TRIM(R81)<>\"\",TRIM(E81)<>\"\"),(E81*50)/R81,\"\")","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'!$C81,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'!$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","Dylox 420 SL","2.5 gal jug",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":218.75},0,null,0,null,null,null,null,{"$f":"IF(OR(AV82 =\"\",AK82+AL82=0),0,E82*AV82*(AK82+AL82))","v":0},"","",4.59,12.5,{"$f":"IF(AND(TRIM(R82)<>\"\",TRIM(E82)<>\"\"),(E82*319.999849189052)/R82,\"\")","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":218.75},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","Forbid® ","8 fl.oz. bottle",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":244.18},0,null,0,null,null,null,null,{"$f":"IF(OR(AV83 =\"\",AK83+AL83=0),0,E83*AV83*(AK83+AL83))","v":0},"","",3,130.68,{"$f":"IF(AND(TRIM(R83)<>\"\",TRIM(E83)<>\"\"),(E83*8)/R83,\"\")","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":244.18},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,"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'!$C84,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,"","",0.14499999999999999,{"$f":"Q84*43.56","v":6.3162000000000003},{"$f":"IF(AND(TRIM(R84)<>\"\",TRIM(E84)<>\"\"),(E84*16)/R84,\"\")","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'!$C84,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'!$C84,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'!$C85,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,"","",0.6,26.135999999999999,{"$f":"IF(AND(TRIM(R85)<>\"\",TRIM(E85)<>\"\"),(E85*127.999939675621)/R85,\"\")","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":40.15},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,"Prograss® EC","2.5 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":368.25},0,null,0,null,null,null,null,null,"","",1.5,65.34,{"$f":"IF(AND(TRIM(R86)<>\"\",TRIM(E86)<>\"\"),(E86*319.999849189052)/R86,\"\")","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'!$C86,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'!$C86,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'!$C87,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,"","",5,217.8,{"$f":"IF(AND(TRIM(R87)<>\"\",TRIM(E87)<>\"\"),(E87*319.999849189052)/R87,\"\")","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":102.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,"Purchase Tier","Revolver®(32 oz. bottle)","32 oz bottle",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":288.56},0,null,0,null,null,null,null,{"$f":"IF(OR(AV88 =\"\",AK88+AL88=0),0,E88*AV88*(AK88+AL88))","v":0},"","",0.4,17.420000000000002,{"$f":"IF(AND(TRIM(R88)<>\"\",TRIM(E88)<>\"\"),(E88*32)/R88,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E88 <>\"\",AM$91>=5000,AL$91<=0.07),$AR$18,0)","v":0},{"$f":"IF(E88 <>\"\", AL$91,0)","v":0},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":288.56},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","Sencor® 75","5 lb.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":586},0,null,0,null,null,null,null,{"$f":"IF(OR(AV89 =\"\",AK89+AL89=0),0,E89*AV89*(AK89+AL89))","v":0},"","",0.24199999999999999,0.66,{"$f":"IF(AND(TRIM(R89)<>\"\",TRIM(E89)<>\"\"),(E89*5)/R89,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E89 <>\"\",AM$91>=5000,AL$91<=0.07),0.01,0)","v":0},{"$f":"IF(E89 <>\"\", AL$91,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":586},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,"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'!$C90,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,87,{"$f":"IF(AND(TRIM(R90)<>\"\",TRIM(E90)<>\"\"),(E90*50)/R90,\"\")","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'!$C90,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'!$C90,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:G63) + SUM(I69:I90)","v":0},null,{"$f":"SUM(I28:I63) + SUM(I69:I90)","v":0},0,0,0,0,0,null,{"$f":"SUM(P28:P63) + SUM(P69:P90)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AM$91=\"\",AM$91<=5000),0,(VLOOKUP(AM91,AK17:AM22,3)))","v":0},{"$f":"SUM(AM28:AM63) + SUM(AM69:AM90)","v":0}]
[]
[null,"Summary"]
[null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[null,"Total Before Off Invoice Volume Discounts",null,null,{"$f":"IF(G91<I91,I91,G91)","v":0}]
[null,"Off Invoice Volume Discount",null,null,{"$f":"IF((SUM(G28:G63)-SUM(I28:I63))<0,0,(SUM(G28:G63)-SUM(I28:I63)))","v":0}]
[null,"Invoice Total ",null,null,{"$f":"I91","v":0}]
[null,"Purchase Tier Level \n(Standard calculation assumes order is invoiced by Oct 31, 2024 and will receive 1% Oct bonus to purchase tier rebate)",null,null,{"$f":"IF(AND(I91<>\"\",I91> 0),N27,0)","v":0}]
[null,"Rebate \n(Total Program Purchase must be a minimum of $5,000 to receive rebates)",null,null,{"$f":"IF(E99=0,0,MIN(SUM(J91:O91),E98))","v":0}]
[null,"Net Total after Rebate",null,null,{"$f":"P91","v":0}]
[null,"Rebate % \n(Total Program Purchase must be a minimum of $5,000 to receive rebates)",null,null,{"$f":"IF(AND(I91<>\"\",I91>0),MIN((E100/E98),1),0)","v":0}]
[null,"Total Savings (Rebates + Off Invoice Volume Discounts)",null,null,{"$f":"E97+E100","v":0}]
[null,"Total Savings % (Rebates + Off Invoice Volume Discounts)",null,null,{"$f":"IF(AND(E96 <> \"\", E96 > 0), E103/E96,0)","v":0}]
[]
[null,{"$f":"CONCATENATE(\"Estimated MER points to be earned: \",TEXT(IF(AND(E100 <>\"\", E100 > 0),E100*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned: 0"},null,null,null,null,null,null,{"$f":"U13","v":"Fall Solutions National Large Lawn Calculator - version 2024-0011-0002"}]

{"sheet":"SUMMARY","index":1,"n_rows":95,"n_cols":7,"rows_kept":95,"cut":false,"hidden":false,"merged":[[80,1,80,5],[16,5,18,5],[87,1,87,4],[16,6,18,6],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[92,1,92,4],[94,1,94,5],[81,1,83,5],[84,1,84,4],[85,1,85,4],[86,1,86,4],[88,1,88,4],[89,1,89,4],[90,1,90,4],[91,1,91,4],[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'!U13","v":"Fall Solutions National Large Lawn Calculator - version 2024-0011-0002"}]
[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'!O28","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'!O29","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'!O30","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'!O31","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'!O32","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'!O33","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C34","v":"Chipco Signature (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'!O34","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C35","v":"Chipco Signature (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'!O35","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'!O36","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'!O37","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'!O38","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'!O39","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'!O40","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'!O41","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'!O42","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'!O43","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'!O44","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C45","v":"Kontos (12-29 units)"},{"$f":"'2024 FALL CALCULATOR'!D45","v":"250 ml. bottle"},{"$f":"'2024 FALL CALCULATOR'!E45","v":0},{"$f":"'2024 FALL CALCULATOR'!H45","v":210.52},{"$f":"'2024 FALL CALCULATOR'!I45","v":0},{"$f":"'2024 FALL CALCULATOR'!O45","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C46","v":"Kontos (30+ units)"},{"$f":"'2024 FALL CALCULATOR'!D46","v":"250 ml. bottle"},{"$f":"'2024 FALL CALCULATOR'!E46","v":0},{"$f":"'2024 FALL CALCULATOR'!H46","v":199.44},{"$f":"'2024 FALL CALCULATOR'!I46","v":0},{"$f":"'2024 FALL CALCULATOR'!O46","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C47","v":"Mirage® Stressgard®"},{"$f":"'2024 FALL CALCULATOR'!D47","v":"2.5 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E47","v":0},{"$f":"'2024 FALL CALCULATOR'!H47","v":488},{"$f":"'2024 FALL CALCULATOR'!I47","v":0},{"$f":"'2024 FALL CALCULATOR'!O47","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C48","v":"Resilia ™"},{"$f":"'2024 FALL CALCULATOR'!D48","v":"2.72 gal. bottle"},{"$f":"'2024 FALL CALCULATOR'!E48","v":0},{"$f":"'2024 FALL CALCULATOR'!H48","v":918.87},{"$f":"'2024 FALL CALCULATOR'!I48","v":0},{"$f":"'2024 FALL CALCULATOR'!O48","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C49","v":"Ronstar® FLO 1 to 11"},{"$f":"'2024 FALL CALCULATOR'!D49","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E49","v":0},{"$f":"'2024 FALL CALCULATOR'!H49","v":552},{"$f":"'2024 FALL CALCULATOR'!I49","v":0},{"$f":"'2024 FALL CALCULATOR'!O49","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C50","v":"Ronstar® FLO 12 to 39"},{"$f":"'2024 FALL CALCULATOR'!D50","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E50","v":0},{"$f":"'2024 FALL CALCULATOR'!H50","v":453},{"$f":"'2024 FALL CALCULATOR'!I50","v":0},{"$f":"'2024 FALL CALCULATOR'!O50","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C51","v":"Ronstar® FLO 40+"},{"$f":"'2024 FALL CALCULATOR'!D51","v":"2.5 gal jug"},{"$f":"'2024 FALL CALCULATOR'!E51","v":0},{"$f":"'2024 FALL CALCULATOR'!H51","v":393},{"$f":"'2024 FALL CALCULATOR'!I51","v":0},{"$f":"'2024 FALL CALCULATOR'!O51","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C52","v":"Revolver® (87 oz. bottle)"},{"$f":"'2024 FALL CALCULATOR'!D52","v":"87 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E52","v":0},{"$f":"'2024 FALL CALCULATOR'!H52","v":758},{"$f":"'2024 FALL CALCULATOR'!I52","v":0},{"$f":"'2024 FALL CALCULATOR'!O52","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C53","v":"Signature XTRA Stressgard (1 to 23)"},{"$f":"'2024 FALL CALCULATOR'!D53","v":"5.5 lb bottle"},{"$f":"'2024 FALL CALCULATOR'!E53","v":0},{"$f":"'2024 FALL CALCULATOR'!H53","v":210.4},{"$f":"'2024 FALL CALCULATOR'!I53","v":0},{"$f":"'2024 FALL CALCULATOR'!O53","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C54","v":"Signature XTRA Stressgard (24+)"},{"$f":"'2024 FALL CALCULATOR'!D54","v":"5.5 lb bottle"},{"$f":"'2024 FALL CALCULATOR'!E54","v":0},{"$f":"'2024 FALL CALCULATOR'!H54","v":192.8},{"$f":"'2024 FALL CALCULATOR'!I54","v":0},{"$f":"'2024 FALL CALCULATOR'!O54","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C55","v":"Specticle® FLO (1-6 units)"},{"$f":"'2024 FALL CALCULATOR'!D55","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E55","v":0},{"$f":"'2024 FALL CALCULATOR'!H55","v":1968.4},{"$f":"'2024 FALL CALCULATOR'!I55","v":0},{"$f":"'2024 FALL CALCULATOR'!O55","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C56","v":"Specticle® FLO (7-13 units)"},{"$f":"'2024 FALL CALCULATOR'!D56","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E56","v":0},{"$f":"'2024 FALL CALCULATOR'!H56","v":1895.88},{"$f":"'2024 FALL CALCULATOR'!I56","v":0},{"$f":"'2024 FALL CALCULATOR'!O56","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C57","v":"Specticle® FLO (14-25 units)"},{"$f":"'2024 FALL CALCULATOR'!D57","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E57","v":0},{"$f":"'2024 FALL CALCULATOR'!H57","v":1657.6},{"$f":"'2024 FALL CALCULATOR'!I57","v":0},{"$f":"'2024 FALL CALCULATOR'!O57","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C58","v":"Specticle® FLO (26+ units)"},{"$f":"'2024 FALL CALCULATOR'!D58","v":"1 gal. bottle "},{"$f":"'2024 FALL CALCULATOR'!E58","v":0},{"$f":"'2024 FALL CALCULATOR'!H58","v":1533.28},{"$f":"'2024 FALL CALCULATOR'!I58","v":0},{"$f":"'2024 FALL CALCULATOR'!O58","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C59","v":"Specticle® G"},{"$f":"'2024 FALL CALCULATOR'!D59","v":"50 lb. bag"},{"$f":"'2024 FALL CALCULATOR'!E59","v":0},{"$f":"'2024 FALL CALCULATOR'!H59","v":128},{"$f":"'2024 FALL CALCULATOR'!I59","v":0},{"$f":"'2024 FALL CALCULATOR'!O59","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C60","v":"Tartan® Stressgard® (1 to 5 units)"},{"$f":"'2024 FALL CALCULATOR'!D60","v":"2.5 gal"},{"$f":"'2024 FALL CALCULATOR'!E60","v":0},{"$f":"'2024 FALL CALCULATOR'!H60","v":1033},{"$f":"'2024 FALL CALCULATOR'!I60","v":0},{"$f":"'2024 FALL CALCULATOR'!O60","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C61","v":"Tartan® Stressgard® 6+"},{"$f":"'2024 FALL CALCULATOR'!D61","v":"2.5 gal"},{"$f":"'2024 FALL CALCULATOR'!E61","v":0},{"$f":"'2024 FALL CALCULATOR'!H61","v":940},{"$f":"'2024 FALL CALCULATOR'!I61","v":0},{"$f":"'2024 FALL CALCULATOR'!O61","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C62","v":"Tribute® Total "},{"$f":"'2024 FALL CALCULATOR'!D62","v":"6 oz. bottle"},{"$f":"'2024 FALL CALCULATOR'!E62","v":0},{"$f":"'2024 FALL CALCULATOR'!H62","v":413.6},{"$f":"'2024 FALL CALCULATOR'!I62","v":0},{"$f":"'2024 FALL CALCULATOR'!O62","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C63","v":"Tetrino®"},{"$f":"'2024 FALL CALCULATOR'!D63","v":"1 gal bottle"},{"$f":"'2024 FALL CALCULATOR'!E63","v":0},{"$f":"'2024 FALL CALCULATOR'!H63","v":498},{"$f":"'2024 FALL CALCULATOR'!I63","v":0},{"$f":"'2024 FALL CALCULATOR'!O63","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C69","v":"Armada® 50 WDG"},{"$f":"'2024 FALL CALCULATOR'!D69","v":"2 lb. bottle"},{"$f":"'2024 FALL CALCULATOR'!E69","v":0},{"$f":"'2024 FALL CALCULATOR'!H69","v":0},{"$f":"'2024 FALL CALCULATOR'!I69","v":0},{"$f":"'2024 FALL CALCULATOR'!O69","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C70","v":"Acclaim® Extra (1 gal)"},{"$f":"'2024 FALL CALCULATOR'!D70","v":"1 gal. jug"},{"$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'!O70","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C71","v":"Acclaim Accelerate (0.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D71","v":".5 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'!O71","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C72","v":"Acclaim Accelerate (2.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D72","v":"2.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'!O72","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C73","v":"Terradex™ Power Premix (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'!O73","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C74","v":"Terradex™ Power Premix (30 gal)"},{"$f":"'2024 FALL CALCULATOR'!D74","v":"30 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'!O74","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C75","v":"Terradex™ Quick Strike (1 gal)"},{"$f":"'2024 FALL CALCULATOR'!D75","v":"1 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'!O75","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C76","v":"Terradex™ Quick Strike (2.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D76","v":"2.5 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'!O76","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C77","v":"Terradex™ Quick Strike (30 gal)"},{"$f":"'2024 FALL CALCULATOR'!D77","v":"30 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'!O77","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C78","v":"Terradex™ Crabgrass & Broadleaf (1 gal)"},{"$f":"'2024 FALL CALCULATOR'!D78","v":"1 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'!O78","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C79","v":"Terradex™ Crabgrass & Broadleaf (2.5 gal)"},{"$f":"'2024 FALL CALCULATOR'!D79","v":"2.5 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'!O79","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C80","v":"26 GT®"},{"$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'!O80","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C81","v":"Chipco® Choice"},{"$f":"'2024 FALL CALCULATOR'!D81","v":"50 lb. bag"},{"$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'!O81","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C82","v":"Dylox 420 SL"},{"$f":"'2024 FALL CALCULATOR'!D82","v":"2.5 gal jug"},{"$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'!O82","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C83","v":"Forbid® "},{"$f":"'2024 FALL CALCULATOR'!D83","v":"8 fl.oz. bottle"},{"$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'!O83","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C84","v":"Merit® 75 WSP"},{"$f":"'2024 FALL CALCULATOR'!D84","v":"4x1.6 oz"},{"$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'!O84","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C85","v":"Merit 2F"},{"$f":"'2024 FALL CALCULATOR'!D85","v":"1 gal. jug"},{"$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'!O85","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C86","v":"Prograss® EC"},{"$f":"'2024 FALL CALCULATOR'!D86","v":"2.5 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'!O86","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C87","v":"Proxy® "},{"$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'!O87","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C88","v":"Revolver®(32 oz. bottle)"},{"$f":"'2024 FALL CALCULATOR'!D88","v":"32 oz bottle"},{"$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'!O88","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C89","v":"Sencor® 75"},{"$f":"'2024 FALL CALCULATOR'!D89","v":"5 lb.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'!O89","v":""}]
[null,{"$f":"'2024 FALL CALCULATOR'!C90","v":"Topchoice®"},{"$f":"'2024 FALL CALCULATOR'!D90","v":"50 lb. bag"},{"$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'!O90","v":""}]
[null,null,null,null,null,{"$f":"SUM(F20:F77)","v":0}]
[]
[]
[null,"Summary"]
[null,"Summary is provided as an estimate only. See program rules and conditions."]
[]
[]
[null,{"$f":"'2024 FALL CALCULATOR'!B96","v":"Total Before Off Invoice Volume Discounts"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E96","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B97","v":"Off Invoice Volume Discount"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E97","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B98","v":"Invoice Total "},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E98","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B99","v":"Purchase Tier Level \n(Standard calculation assumes order is invoiced by Oct 31, 2024 and will receive 1% Oct bonus to purchase tier rebate)"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E99","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B100","v":"Rebate \n(Total Program Purchase must be a minimum of $5,000 to receive rebates)"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E100","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B101","v":"Net Total after Rebate"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E101","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B102","v":"Rebate % \n(Total Program Purchase must be a minimum of $5,000 to receive rebates)"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E102","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B103","v":"Total Savings (Rebates + Off Invoice Volume Discounts)"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E103","v":0}]
[null,{"$f":"'2024 FALL CALCULATOR'!B104","v":"Total Savings % (Rebates + Off Invoice Volume Discounts)"},null,null,null,{"$f":"'2024 FALL CALCULATOR'!E104","v":0}]
[]
[null,{"$f":"CONCATENATE(\"Estimated MER points to be earned in the Product Cart: \",TEXT(IF(AND(F89 <>\"\", F89 > 0),F89*100, 0),\"#,##0\"))","v":"Estimated MER points to be earned in the Product Cart: 0"}]

{"sheet":"Pricing","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"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 (1-8 units)",392.8,402.72,395.54,392.8,402.72,395.54]
["Chipco Signature (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 (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"]