{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Updates"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[8,2,8,6]]}
["Manufacturer","Tools"]
["File as","T"]
["Product Code","N"]
["CCTD Effective Date","2/1/22"]
[]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,null,"Product"]
[null,null,"Code","Disc. %"]
[null,null,{"$f":"+B3","v":"N"},0,"  This is a \"NET\" price list.  0% is the discount for this spreadsheet"]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"GP Margin % for","Group","GP Margin","Round Nickel","add/subtract","Ending Cents"]
[null,"Barwalt - Saws/Cutters","PR1",null,"No",0]
[null,"Barwalt - All Other","PR",null,"No",0]
[null,"DeWalt - Saws/Cutters","DW1",null,"No",0]
[null,"DeWalt - All Other","DW",null,"No",0]
[null,"ETM - HP","ET1",null,"No",0]
[null,"ETM - All Other","ET",null,"No",0]
[null,"Gundlach - All","GU",null,"No",0]
[null,"Hydra - All","HY",null,"No",0]
[null,"Imer - Saws/Cutters","IE1",null,"No",0]
[null,"Imer - All Other","IE",null,"No",0]
[null,"IQ Tools - Saws/Cutters","IQ1",null,"No",0]
[null,"IQ Tools - All Other","IQ",null,"No",0]
[null,"MK - Saws/Cutters","MK1",null,"No",0]
[null,"MK - All Other","MK",null,"No",0]
[null,"Primo - Saws/Cutters","PM1",null,"No",0]
[null,"Primo - All Other","PM",null,"No",0]
[null,"Progress Profiles - All","PP",null,"No",0]
[null,"Sigma - Saws/Cutters","RS1",null,"No",0]
[null,"Sigma - All Other","RS",null,"No",0]
[null,"Rubi - Saws/Cutters","RU1",null,"No",0]
[null,"Rubi - All Other","RU",null,"No",0]
[null,"Schluter - Trowels","SH",null,"No",0]
[null,"SuperiorBilt - Saws/Cutters","SF1",null,"No",0]
[null,"SuperiorBilt - All Other","SF",null,"No",0]
[null,"Troxell - Saws/Cutters","TR1",null,"No",0]
[null,"Troxell - All Other","TR",null,"No",0]
[null,"Extend-O-Drains","XX",null,"No",0]
[]
["If you want to manually adjust your price list, hit \"F5\" and go to \"Customer_Cost\" to manually adjust pricing."]
["You can enter a value in the column labeled \"Adj.\" to change your price manually."]
[]
[null,"Click on \"Your Price Calculation\" to set the print area for your personal cost calculation report."]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Your Price List\" to set the print area for your personal price list."]
[null,"Then you can send it to print"]
[null,null,null,null,null,null,"Yes"]
[]
["If you have any questions on how to best use this spreadsheet, please feel free to contact"]
["Jim Vogel at (800) 422-6860, ext. 4201 or via e-mail at jimvogel@cctd.com"]

{"sheet":"Index","index":1,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,0,5,10],[47,0,47,10],[49,0,49,10],[2,5,2,10],[3,4,3,7],[10,2,10,4],[10,8,10,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'T' - Tools"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 2/1/22"}]
[]
[]
[]
[]
["Page",null,"Product Type",null,null,null,"Page",null,"Product Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This price list is available electronically on an Excel spreadsheet.  If you would like to obtain a copy, please email Conestoga Tile at service@cctd.com."]
[]
["The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference."]

{"sheet":"Price List","index":2,"n_rows":439,"n_cols":41,"rows_kept":439,"cut":false,"hidden":false,"merged":[[3,22,3,23],[4,22,4,23],[3,14,3,19],[4,30,4,32],[428,3,428,4],[423,2,423,19],[8,2,8,4],[421,2,421,18],[9,2,9,18],[10,2,10,18],[8,14,8,15],[355,2,355,18],[207,18,208,18]]}
[null,{"$error":"#N/A"},null,"Our Part #",null,"Description",null,null,null,null,null,null,null,null,"Mfg.",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA1,'Price List'!AG1)","v":{"$error":"#N/A"}},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":{"$error":"#N/A"}},null,"new",{"$error":"#N/A"},{"$f":"+W1","v":0},{"$f":"+X1","v":{"$error":"#N/A"}},{"$f":"(AG1-AC1)/AG1","v":{"$error":"#N/A"}},null,{"$f":"+A1","v":0},{"$f":"SUM(AJ1:AL1)+AE1","v":{"$error":"#N/A"}},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(AF1,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,4,FALSE),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF1,Group,5,FALSE))","v":{"$error":"#N/A"}},null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'T' - Tools"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"2/1/22"},null,null,"Cost",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-01-05"},null,null,null,null,null,null,null,null,null,"X"]
[null,null,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'N'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Part Number",null,null,"Description",null,null,null,null,null,null,null,null,"Manufacturer",null,"Stock","Note","Net Price","U/M","Code",null,"Disc.","Net",null,"Chg","Net Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"Pricing is subject to change without notice.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"PRICING LISTED IS NET PRICING.  TRADE DISCOUNTS DO NOT APPLY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Trowels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"U-Notched - Trowels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR71073",null,"1/4 x 1/4",null,"71073 #72",null,"- Soft Grip",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA16,'Price List'!AG16)","v":10.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA16*(1-W16)+0.004999,2)","v":10.85},null,"YES",10.85,{"$f":"+W16","v":0},{"$f":"+X16","v":10.85},{"$f":"(AG16-AC16)/AG16","v":0},null,{"$f":"+A16","v":"PR"},{"$f":"SUM(AJ16:AL16)+AE16","v":10.85},null,null,{"$f":"ROUND(AC16/(1-VLOOKUP(AF16,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF16,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ16,1)-AJ16,2),Round,2,FALSE)+VLOOKUP(AF16,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF16,Group,5,FALSE)=\"\",0,ROUND(AJ16-0.04999,1)-AJ16+AM16)","v":0},{"$f":"IF(VLOOKUP(AF16,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF16,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["TR","Troxell - All Other",null,"TX14-66SS",null,"3/8 x 1/4",null,"14-66SS",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Troxell",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA18,'Price List'!AG18)","v":13.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA18*(1-W18)+0.004999,2)","v":13.15},null,"new",13.15,{"$f":"+W18","v":0},13.15,{"$f":"(AG18-AC18)/AG18","v":0},null,{"$f":"+A18","v":"TR"},{"$f":"SUM(AJ18:AL18)+AE18","v":13.15},null,null,{"$f":"ROUND(AC18/(1-VLOOKUP(AF18,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF18,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ18,1)-AJ18,2),Round,2,FALSE)+VLOOKUP(AF18,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF18,Group,5,FALSE)=\"\",0,ROUND(AJ18-0.04999,1)-AJ18+AM18)","v":0},{"$f":"IF(VLOOKUP(AF18,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF18,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR71080",null,"1/2 x 1/4",null,"71080 #78",null,"- Soft Grip",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA20,'Price List'!AG20)","v":10.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA20*(1-W20)+0.004999,2)","v":10.85},null,"YES",10.85,{"$f":"+W20","v":0},{"$f":"+X20","v":10.85},{"$f":"(AG20-AC20)/AG20","v":0},null,{"$f":"+A20","v":"PR"},{"$f":"SUM(AJ20:AL20)+AE20","v":10.85},null,null,{"$f":"ROUND(AC20/(1-VLOOKUP(AF20,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF20,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ20,1)-AJ20,2),Round,2,FALSE)+VLOOKUP(AF20,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF20,Group,5,FALSE)=\"\",0,ROUND(AJ20-0.04999,1)-AJ20+AM20)","v":0},{"$f":"IF(VLOOKUP(AF20,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF20,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70962",null,"1/2 x 1/4",null,"70962 #78",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA21,'Price List'!AG21)","v":12.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA21*(1-W21)+0.004999,2)","v":12.35},null,"YES",12.35,{"$f":"+W21","v":0},{"$f":"+X21","v":12.35},{"$f":"(AG21-AC21)/AG21","v":0},null,{"$f":"+A21","v":"PR"},{"$f":"SUM(AJ21:AL21)+AE21","v":12.35},null,null,{"$f":"ROUND(AC21/(1-VLOOKUP(AF21,Group,2,FALSE)),2)","v":12.35},{"$f":"IF(VLOOKUP(AF21,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ21,1)-AJ21,2),Round,2,FALSE)+VLOOKUP(AF21,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF21,Group,5,FALSE)=\"\",0,ROUND(AJ21-0.04999,1)-AJ21+AM21)","v":0},{"$f":"IF(VLOOKUP(AF21,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF21,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Square Notched - Trowels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR71138",null,"1/2 x 1/2",null,"71138 #58",null,"- Soft Grip, Extra Long 16\"",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA25,'Price List'!AG25)","v":12.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA25*(1-W25)+0.004999,2)","v":12.35},null,"YES",12.35,{"$f":"+W25","v":0},{"$f":"+X25","v":12.35},{"$f":"(AG25-AC25)/AG25","v":0},null,{"$f":"+A25","v":"PR"},{"$f":"SUM(AJ25:AL25)+AE25","v":12.35},null,null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":12.35},{"$f":"IF(VLOOKUP(AF25,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ25,1)-AJ25,2),Round,2,FALSE)+VLOOKUP(AF25,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,5,FALSE)=\"\",0,ROUND(AJ25-0.04999,1)-AJ25+AM25)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF25,Group,5,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Euro-Notched - Trowels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["TR","Troxell - All Other",null,"TX14-EUSS",null,"Euro-Notch",null,"14-EUSS",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Troxell",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA28,'Price List'!AG28)","v":13.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA28*(1-W28)+0.004999,2)","v":13.15},null,"new",13.15,{"$f":"+W28","v":0},{"$f":"+X28","v":13.15},{"$f":"(AG28-AC28)/AG28","v":0},null,{"$f":"+A28","v":"TR"},{"$f":"SUM(AJ28:AL28)+AE28","v":13.15},null,null,{"$f":"ROUND(AC28/(1-VLOOKUP(AF28,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF28,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ28,1)-AJ28,2),Round,2,FALSE)+VLOOKUP(AF28,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,5,FALSE)=\"\",0,ROUND(AJ28-0.04999,1)-AJ28+AM28)","v":0},{"$f":"IF(VLOOKUP(AF28,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF28,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Schluter Sized - Trowels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["SH","Schluter - Trowels",null,"SHTRLKER6",null,"1/8 x 1/8",null,"TRL-KER",null,"Schluter Kerdi trowel",null,null,null,null,"Schluter",null,"n/s",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA31,'Price List'!AG31)","v":20.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":20.55},null,"YES",20.55,{"$f":"+W31","v":0},{"$f":"+X31","v":20.55},{"$f":"(AG31-AC31)/AG31","v":0},null,{"$f":"+A31","v":"SH"},{"$f":"SUM(AJ31:AL31)+AE31","v":20.55},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":20.55},{"$f":"IF(VLOOKUP(AF31,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ31,1)-AJ31,2),Round,2,FALSE)+VLOOKUP(AF31,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"\",0,ROUND(AJ31-0.04999,1)-AJ31+AM31)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF31,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX1410SS",null,"1/8 x 1/8",null,"14-10SS",null,"Kerdi-Size Trowel, Soft Grip, Stainless",null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA32,'Price List'!AG32)","v":13.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":13.15},null,"YES",13.15,{"$f":"+W32","v":0},{"$f":"+X32","v":13.15},{"$f":"(AG32-AC32)/AG32","v":0},null,{"$f":"+A32","v":"TR"},{"$f":"SUM(AJ32:AL32)+AE32","v":13.15},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF32,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ32,1)-AJ32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"\",0,ROUND(AJ32-0.04999,1)-AJ32+AM32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF32,Group,5,FALSE))","v":""},null,"X"]
[]
["SH","Schluter - Trowels",null,"SHTRLDIT6",null,"11/64 x 11/64",null,"TRL-DIT",null,"Schluter Ditra trowel",null,null,null,null,"Schluter",null,"n/s",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA34,'Price List'!AG34)","v":20.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":20.55},null,"YES",20.55,{"$f":"+W34","v":0},{"$f":"+X34","v":20.55},{"$f":"(AG34-AC34)/AG34","v":0},null,{"$f":"+A34","v":"SH"},{"$f":"SUM(AJ34:AL34)+AE34","v":20.55},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":20.55},{"$f":"IF(VLOOKUP(AF34,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ34,1)-AJ34,2),Round,2,FALSE)+VLOOKUP(AF34,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,5,FALSE)=\"\",0,ROUND(AJ34-0.04999,1)-AJ34+AM34)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF34,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX1420SS",null,"11/64 x 11/64",null,"14-20SS",null,"Ditra-Size Trowel, Soft Grip, Stainless",null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA35,'Price List'!AG35)","v":13.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":13.15},null,"YES",13.15,{"$f":"+W35","v":0},{"$f":"+X35","v":13.15},{"$f":"(AG35-AC35)/AG35","v":0},null,{"$f":"+A35","v":"TR"},{"$f":"SUM(AJ35:AL35)+AE35","v":13.15},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF35,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ35,1)-AJ35,2),Round,2,FALSE)+VLOOKUP(AF35,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"\",0,ROUND(AJ35-0.04999,1)-AJ35+AM35)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF35,Group,5,FALSE))","v":""},null,"X"]
[]
[null,null,null,"V-Notched - Trowels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["TR","Troxell - All Other",null,"TX14-44SS",null,"3/16 x 1/4",null,"14-44SS",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Troxell",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA38,'Price List'!AG38)","v":13.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":13.15},null,"new",13.15,{"$f":"+W38","v":0},{"$f":"+X38","v":13.15},{"$f":"(AG38-AC38)/AG38","v":0},null,{"$f":"+A38","v":"TR"},{"$f":"SUM(AJ38:AL38)+AE38","v":13.15},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF38,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ38,1)-AJ38,2),Round,2,FALSE)+VLOOKUP(AF38,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,5,FALSE)=\"\",0,ROUND(AJ38-0.04999,1)-AJ38+AM38)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF38,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["TR","Troxell - All Other",null,"TX14-33SS",null,"1/4 x 5/16",null,"14-33SS",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Troxell",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA40,'Price List'!AG40)","v":13.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":13.15},null,"new",13.15,{"$f":"+W40","v":0},{"$f":"+X40","v":13.15},{"$f":"(AG40-AC40)/AG40","v":0},null,{"$f":"+A40","v":"TR"},{"$f":"SUM(AJ40:AL40)+AE40","v":13.15},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":13.15},{"$f":"IF(VLOOKUP(AF40,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ40,1)-AJ40,2),Round,2,FALSE)+VLOOKUP(AF40,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,5,FALSE)=\"\",0,ROUND(AJ40-0.04999,1)-AJ40+AM40)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF40,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"Note:","3/16\" x 1/4\" is recommended for installation of Schluter Kerdi Matting.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,"1/4\"\" x 5/16\" is recommended for installation of Schluter Ditra Matting.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Margin Trowels - Notched",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR70921",null,"5\" x 2\"",null,"70921",null,"1/4\" Square Notched",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA46,'Price List'!AG46)","v":2.2999999999999998},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":2.2999999999999998},null,"YES",2.2999999999999998,{"$f":"+W46","v":0},{"$f":"+X46","v":2.2999999999999998},{"$f":"(AG46-AC46)/AG46","v":0},null,{"$f":"+A46","v":"PR"},{"$f":"SUM(AJ46:AL46)+AE46","v":2.2999999999999998},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":2.2999999999999998},{"$f":"IF(VLOOKUP(AF46,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ46,1)-AJ46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"\",0,ROUND(AJ46-0.04999,1)-AJ46+AM46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF46,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Margin Trowels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["TR","Troxell - All Other",null,"TX15-522",null,"5\" x 2\"",null,"15-522",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Troxell",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA49,'Price List'!AG49)","v":7.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA49*(1-W49)+0.004999,2)","v":7.35},null,"new",7.35,{"$f":"+W49","v":0},7.35,{"$f":"(AG49-AC49)/AG49","v":0},null,{"$f":"+A49","v":"TR"},{"$f":"SUM(AJ49:AL49)+AE49","v":7.35},null,null,{"$f":"ROUND(AC49/(1-VLOOKUP(AF49,Group,2,FALSE)),2)","v":7.35},{"$f":"IF(VLOOKUP(AF49,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ49,1)-AJ49,2),Round,2,FALSE)+VLOOKUP(AF49,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,5,FALSE)=\"\",0,ROUND(AJ49-0.04999,1)-AJ49+AM49)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF49,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX15-582",null,"8\" x 2\"",null,"15-582",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Troxell",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA50,'Price List'!AG50)","v":8.4499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA50*(1-W50)+0.004999,2)","v":8.4499999999999993},null,"new",8.4499999999999993,0,8.4499999999999993,{"$f":"(AG50-AC50)/AG50","v":0},null,{"$f":"+A50","v":"TR"},{"$f":"SUM(AJ50:AL50)+AE50","v":8.4499999999999993},null,null,{"$f":"ROUND(AC50/(1-VLOOKUP(AF50,Group,2,FALSE)),2)","v":8.4499999999999993},{"$f":"IF(VLOOKUP(AF50,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ50,1)-AJ50,2),Round,2,FALSE)+VLOOKUP(AF50,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,5,FALSE)=\"\",0,ROUND(AJ50-0.04999,1)-AJ50+AM50)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF50,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Floats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Regular Floats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR71158",null,"4\" x 9\"",null,"71158",null,"- Lightweight w/ Cushion Handle",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA56,'Price List'!AG56)","v":9.65},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":9.65},null,"YES",9.65,{"$f":"+W56","v":0},9.65,{"$f":"(AG56-AC56)/AG56","v":0},null,{"$f":"+A56","v":"PR"},{"$f":"SUM(AJ56:AL56)+AE56","v":9.65},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":9.65},{"$f":"IF(VLOOKUP(AF56,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR71175",null,"4\" x 9\"",null,"71175",null,"- Gum Rubber w/ Metal Backing, Soft Grip",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA57,'Price List'!AG57)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},9.9499999999999993,null,"YES",9.9499999999999993,0,9.9499999999999993,0,null,"PR",9.9499999999999993,null,null,9.9499999999999993,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX0943P",null,"4\" x 9\"",null,"09-43P",null,"Super-Grip PROFLEX Gum Float",null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA58,'Price List'!AG58)","v":13},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},13,null,"YES",13,0,13,0,null,"TR",13,null,null,13,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PRUWF1",null,"3.5\" x 10\"",null,"81319 UWF-1B",null,"- Ultralight w/ Hollow Handle (Green)",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA59,'Price List'!AG59)","v":13.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},13.8,null,"YES",13.8,0,13.8,0,null,"PR",13.8,null,null,13.8,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR71185",null,"4\" x 10-1/2\"",null,"71185",null,"- Ultrasoft Float",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA60,'Price List'!AG60)","v":12.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},12.9,null,"YES",12.9,0,12.9,0,null,"PR",12.9,null,null,12.9,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX0943PXL",null,"4\" x 12\"",null,"09-43PXL",null,"Super-Grip PROFLEX Gum Float",null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA61,'Price List'!AG61)","v":16.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},16.05,null,"YES",16.05,0,16.05,0,null,"TR",16.05,null,null,16.05,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Offset Floats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR71178",null,"3\" x 12\"",null,"71178",null,"- Gum Rubber w/ Metal Backing, Soft Grip",null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA64,'Price List'!AG64)","v":9.9499999999999993},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":9.9499999999999993},null,"YES",9.9499999999999993,{"$f":"+W64","v":0},{"$f":"+X64","v":9.9499999999999993},{"$f":"(AG64-AC64)/AG64","v":0},null,{"$f":"+A64","v":"PR"},{"$f":"SUM(AJ64:AL64)+AE64","v":9.9499999999999993},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":9.9499999999999993},{"$f":"IF(VLOOKUP(AF64,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF64,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Epoxy Floats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["TR","Troxell - All Other",null,"TX09KF",null,"4\" x 9\"",null,"09-KF",null,"Super-Grip PROFLEX Yellow Float",null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA67,'Price List'!AG67)","v":15.6},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA67*(1-W67)+0.004999,2)","v":15.6},null,"YES",15.6,{"$f":"+W67","v":0},{"$f":"+X67","v":15.6},{"$f":"(AG67-AC67)/AG67","v":0},null,{"$f":"+A67","v":"TR"},{"$f":"SUM(AJ67:AL67)+AE67","v":15.6},null,null,{"$f":"ROUND(AC67/(1-VLOOKUP(AF67,Group,2,FALSE)),2)","v":15.6},{"$f":"IF(VLOOKUP(AF67,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ67,1)-AJ67,2),Round,2,FALSE)+VLOOKUP(AF67,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF67,Group,5,FALSE)=\"\",0,ROUND(AJ67-0.04999,1)-AJ67+AM67)","v":0},{"$f":"IF(VLOOKUP(AF67,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF67,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PRUFF2000",null,null,null,"81400 UFF-2000",null,"- Ultralight w/ Solid Handle",null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA68,'Price List'!AG68)","v":16.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":16.45},null,"YES",16.45,{"$f":"+W68","v":0},{"$f":"+X68","v":16.45},{"$f":"(AG68-AC68)/AG68","v":0},null,{"$f":"+A68","v":"PR"},{"$f":"SUM(AJ68:AL68)+AE68","v":16.45},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":16.45},{"$f":"IF(VLOOKUP(AF68,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ68,1)-AJ68,2),Round,2,FALSE)+VLOOKUP(AF68,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"\",0,ROUND(AJ68-0.04999,1)-AJ68+AM68)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF68,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Margin Floats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR70922",null,"2\" x 6\"",null,"70922",null,"- Wood Handle",null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA71,'Price List'!AG71)","v":5.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":5.4},null,"YES",5.4,{"$f":"+W71","v":0},{"$f":"+X71","v":5.4},{"$f":"(AG71-AC71)/AG71","v":0},null,{"$f":"+A71","v":"PR"},{"$f":"SUM(AJ71:AL71)+AE71","v":5.4},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":5.4},{"$f":"IF(VLOOKUP(AF71,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX09MTF",null,"2\" x 6\"",null,"09-MTF",null,"- Soft Grip, Stainless Steel",null,null,null,null,"Troxell",null,"n/s","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA72,'Price List'!AG72)","v":9.3000000000000007},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":9.3000000000000007},null,"new",9.3000000000000007,{"$f":"+W72","v":0},{"$f":"+X72","v":9.3000000000000007},{"$f":"(AG72-AC72)/AG72","v":0},null,{"$f":"+A72","v":"TR"},{"$f":"SUM(AJ72:AL72)+AE72","v":9.3000000000000007},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":9.3000000000000007},{"$f":"IF(VLOOKUP(AF72,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ72,1)-AJ72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"\",0,ROUND(AJ72-0.04999,1)-AJ72+AM72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF72,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Grouting Clean Up Systems / Sponges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Ultra Grouting System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR81584",null,"81584 Ultra Grouting System",null,null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA77,'Price List'!AG77)","v":113.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":113.75},null,"YES",113.75,{"$f":"+W77","v":0},{"$f":"+X77","v":113.75},{"$f":"(AG77-AC77)/AG77","v":0},null,{"$f":"+A77","v":"PR"},{"$f":"SUM(AJ77:AL77)+AE77","v":113.75},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":113.75},{"$f":"IF(VLOOKUP(AF77,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF77,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR81510",null,null,"81510 Wall Sponge Holder",null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA78,'Price List'!AG78)","v":16.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},16.55,null,"YES",16.55,0,16.55,0,null,"PR",16.55,null,null,16.55,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR81511",null,null,"81511 Wall Replacement Sponge",null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA79,'Price List'!AG79)","v":5.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},5.45,null,"YES",5.45,0,5.45,0,null,"PR",5.45,null,null,5.45,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR81520",null,null,"81520 Floor Sponge Holder",null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA80,'Price List'!AG80)","v":16.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},16.55,null,"YES",16.55,0,16.55,0,null,"PR",16.55,null,null,16.55,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR81521",null,null,"81521 Floor Replacement Sponge",null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA81,'Price List'!AG81)","v":5.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},5.45,null,"YES",5.45,0,5.45,0,null,"PR",5.45,null,null,5.45,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX09CADDY",null,"09-CADDY Troxell Grout Caddy (Complete Set)",null,null,null,null,null,null,null,null,"Troxell",null,"n/s","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA82,'Price List'!AG82)","v":115.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},115.2,null,"new",115.2,0,115.2,0,null,"TR",115.2,null,null,115.2,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX09CADDYS",null,null,"Grout Caddy Replacement - 5\"x11\" Wall Sponge",null,null,null,null,null,null,null,"Troxell",null,"n/s","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA83,'Price List'!AG83)","v":6.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},6.2,null,"new",6.2,0,6.2,0,null,"TR",6.2,null,null,6.2,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX09CADDYH",null,null,"Grout Caddy Replacement - 5\"x11\" Wall Handle",null,null,null,null,null,null,null,"Troxell",null,"n/s","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA84,'Price List'!AG84)","v":9.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},9.1,null,"new",9.1,0,9.1,0,null,"TR",9.1,null,null,9.1,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX09CADDYSXL",null,null,"Grout Caddy Replacement - 8\"x14\" Floor Sponge",null,null,null,null,null,null,null,"Troxell",null,"n/s","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA85,'Price List'!AG85)","v":12.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},12.55,null,"new",12.55,0,12.55,0,null,"TR",12.55,null,null,12.55,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX09CADDYHXL",null,null,"Grout Caddy Replacement - 8\"x14\" Floor Handle",null,null,null,null,null,null,null,"Troxell",null,"n/s","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA86,'Price List'!AG86)","v":17.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},17.55,null,"new",17.55,0,17.55,0,null,"TR",17.55,null,null,17.55,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Doodlebugs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["GU","Gundlach - All",null,"GU8242",null,"8242 Medium Blue Doodlebug Pad",null,null,null,null,null,null,null,null,"Gundlach",null,"Stock",null,5.15,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},5.55,null,"YES",5.55,0,5.55,0,null,{"$f":"+A89","v":"GU"},5.55,null,null,5.55,{"$f":"IF(VLOOKUP(AF89,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ89,1)-AJ89,2),Round,2,FALSE)+VLOOKUP(AF89,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,5,FALSE)=\"\",0,ROUND(AJ89-0.04999,1)-AJ89+AM89)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF89,Group,5,FALSE))","v":""},null,"X"]
["GU","Gundlach - All",null,"GU8440",null,"8440 Fine White Doodlebug Pad",null,null,null,null,null,null,null,null,"Gundlach",null,"Stock",null,5.15,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},5.55,null,"YES",5.55,0,5.55,0,null,{"$f":"+A90","v":"GU"},5.55,null,null,5.55,{"$f":"IF(VLOOKUP(AF90,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ90,1)-AJ90,2),Round,2,FALSE)+VLOOKUP(AF90,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,5,FALSE)=\"\",0,ROUND(AJ90-0.04999,1)-AJ90+AM90)","v":0},{"$f":"IF(VLOOKUP(AF90,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF90,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX10112",null,"10-112","6\"x12\" Scrub Pad Handle with Velcro",null,null,null,null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA91,'Price List'!AG91)","v":9.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},9.1,null,"YES",9.1,0,9.1,0,null,{"$f":"+A91","v":"TR"},9.1,null,null,9.1,{"$f":"IF(VLOOKUP(AF91,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ91,1)-AJ91,2),Round,2,FALSE)+VLOOKUP(AF91,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"\",0,ROUND(AJ91-0.04999,1)-AJ91+AM91)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF91,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX10200",null,"10-200","6\"x12\" Scrub Pad - White Fine ",null,null,null,null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA92,'Price List'!AG92)","v":5.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":5.15},null,"YES",5.15,{"$f":"+W92","v":0},{"$f":"+X92","v":5.15},{"$f":"(AG92-AC92)/AG92","v":0},null,{"$f":"+A92","v":"TR"},{"$f":"SUM(AJ92:AL92)+AE92","v":5.15},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":5.15},{"$f":"IF(VLOOKUP(AF92,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ92,1)-AJ92,2),Round,2,FALSE)+VLOOKUP(AF92,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"\",0,ROUND(AJ92-0.04999,1)-AJ92+AM92)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF92,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX10201",null,"10-201","6\"x12\" Scrub Pad - Blue Medium ",null,null,null,null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA93,'Price List'!AG93)","v":6.6},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},6.6,null,"YES",6.6,0,6.6,0,null,{"$f":"+A93","v":"TR"},6.6,null,null,6.6,{"$f":"IF(VLOOKUP(AF93,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ93,1)-AJ93,2),Round,2,FALSE)+VLOOKUP(AF93,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"\",0,ROUND(AJ93-0.04999,1)-AJ93+AM93)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF93,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"continued on the next page",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Grouting Clean Up Systems / Sponges (continued)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sponges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["HY","Hydra - All",null,"HY6HS",null,"TM-B","6\" Medium Sponge",null,null,null,null,null,null,null,"Hydra",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA99,'Price List'!AG99)","v":1.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1.85,null,"YES",1.85,0,1.85,0,null,{"$f":"+A99","v":"HY"},1.85,null,null,1.85,{"$f":"IF(VLOOKUP(AF99,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ99,1)-AJ99,2),Round,2,FALSE)+VLOOKUP(AF99,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,5,FALSE)=\"\",0,ROUND(AJ99-0.04999,1)-AJ99+AM99)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF99,Group,5,FALSE))","v":""},null,"X"]
["HY","Hydra - All",null,"HY6HS",null,"TM-B","6\" Medium Sponge",null,null,"- Bag of 40",null,null,null,null,"Hydra",null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA100,'Price List'!AG100)","v":1.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1.35,null,"YES",1.35,0,1.35,0,null,"HY",1.35,null,null,1.35,0,0,"",null,"X"]
["HY","Hydra - All",null,"HY6HS",null,"TM-B","6\" Medium Sponge",null,null,"- Bail of 600",null,null,null,null,"Hydra",null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA101,'Price List'!AG101)","v":1.1499999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1.1499999999999999,null,"YES",1.1499999999999999,0,1.1499999999999999,0,null,"HY",1.1499999999999999,null,null,1.1499999999999999,0,0,"",null,"X"]
["HY","Hydra - All",null,"HY8HS",null,"TXL-B","8\" X-Large Sponge",null,null,null,null,null,null,null,"Hydra",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA102,'Price List'!AG102)","v":2.5499999999999998},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},2.5499999999999998,null,"YES",2.5499999999999998,0,2.5499999999999998,0,null,"HY",2.5499999999999998,null,null,2.5499999999999998,0,0,"",null,"X"]
["HY","Hydra - All",null,"HY8HS",null,"TXL-B","8\" X-Large Sponge",null,null,"- Bag of 25",null,null,null,null,"Hydra",null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA103,'Price List'!AG103)","v":2.0499999999999998},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},2.0499999999999998,null,"YES",2.0499999999999998,0,2.0499999999999998,0,null,"HY",2.0499999999999998,null,null,2.0499999999999998,0,0,"",null,"X"]
["HY","Hydra - All",null,"HY8HS",null,"TXL-B","8\" X-Large Sponge",null,null,"- Bail of 450",null,null,null,null,"Hydra",null,"Stock","a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA104,'Price List'!AG104)","v":1.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1.85,null,"YES",1.85,0,1.85,0,null,"HY",1.85,null,null,1.85,0,0,"",null,"X"]
["HY","Hydra - All",null,"HYEPL",null,"EPL","Epoxy Sponge White",null,null,null,null,null,null,null,"Hydra",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA105,'Price List'!AG105)","v":2.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},2.5,null,"YES",2.5,0,2.5,0,null,"HY",2.5,null,null,2.5,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) Special Pricing for FULL BAG and BAIL purchases.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Tile Spacers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Hollow Spacers - specially designed to be grouted over - they don't have to be removed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR116G",null,"1/16\"  +",null,"16000 - Clamshell",null,null,null,"- 500 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA113,'Price List'!AG113)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA113*(1-W113)+0.004999,2)","v":8.85},null,"YES",8.85,{"$f":"+W113","v":0},{"$f":"+X113","v":8.85},{"$f":"(AG113-AC113)/AG113","v":0},null,{"$f":"+A113","v":"PR"},{"$f":"SUM(AJ113:AL113)+AE113","v":8.85},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF113,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ113,1)-AJ113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"\",0,ROUND(AJ113-0.04999,1)-AJ113+AM113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF113,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR18H",null,"1/8\"  +",null,"16020 - Clamshell",null,null,null,"- 500 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA114,'Price List'!AG114)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},8.85,null,"YES",8.85,0,8.85,0,null,{"$f":"+A114","v":"PR"},8.85,null,null,8.85,{"$f":"IF(VLOOKUP(AF114,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ114,1)-AJ114,2),Round,2,FALSE)+VLOOKUP(AF114,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,5,FALSE)=\"\",0,ROUND(AJ114-0.04999,1)-AJ114+AM114)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF114,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR316H",null,"3/16\"  + ",null,"16030 - Clamshell",null,null,null,"- 500 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA115,'Price List'!AG115)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},8.85,null,"YES",8.85,0,8.85,0,null,{"$f":"+A115","v":"PR"},8.85,null,null,8.85,{"$f":"IF(VLOOKUP(AF115,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ115,1)-AJ115,2),Round,2,FALSE)+VLOOKUP(AF115,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,5,FALSE)=\"\",0,ROUND(AJ115-0.04999,1)-AJ115+AM115)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF115,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR14H",null,"1/4\"  +",null,"16040 - Clamshell",null,null,null,"- 400 Count",null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA116,'Price List'!AG116)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},8.85,null,"YES",8.85,0,8.85,0,null,{"$f":"+A116","v":"PR"},8.85,null,null,8.85,{"$f":"IF(VLOOKUP(AF116,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ116,1)-AJ116,2),Round,2,FALSE)+VLOOKUP(AF116,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"\",0,ROUND(AJ116-0.04999,1)-AJ116+AM116)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF116,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR18TH",null,"1/8\"  T",null,"16120 - Clamshell",null,null,null,"- 500 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA118,'Price List'!AG118)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},8.85,null,"YES",8.85,0,8.85,0,null,{"$f":"+A118","v":"PR"},8.85,null,null,8.85,{"$f":"IF(VLOOKUP(AF118,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ118,1)-AJ118,2),Round,2,FALSE)+VLOOKUP(AF118,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"\",0,ROUND(AJ118-0.04999,1)-AJ118+AM118)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF118,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR316TH",null,"3/16\"  T",null,"16130 - Clamshell",null,null,null,"- 500 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA119,'Price List'!AG119)","v":8.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},8.85,null,"YES",8.85,0,8.85,0,null,{"$f":"+A119","v":"PR"},8.85,null,null,8.85,{"$f":"IF(VLOOKUP(AF119,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF119,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Precision Tile Spacers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR18",null,"1/8\"  +",null,"10020 - Bag",null,null,null,"- 200 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA122,'Price List'!AG122)","v":2.2999999999999998},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},2.2999999999999998,null,"YES",2.2999999999999998,0,2.2999999999999998,0,null,{"$f":"+A122","v":"PR"},2.2999999999999998,null,null,2.2999999999999998,{"$f":"IF(VLOOKUP(AF122,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ122,1)-AJ122,2),Round,2,FALSE)+VLOOKUP(AF122,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,5,FALSE)=\"\",0,ROUND(AJ122-0.04999,1)-AJ122+AM122)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF122,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR316",null,"3/16\"  + ",null,"10030 - Bag",null,null,null,"- 150 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA123,'Price List'!AG123)","v":2.2999999999999998},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},2.2999999999999998,null,"YES",2.2999999999999998,0,2.2999999999999998,0,null,{"$f":"+A123","v":"PR"},2.2999999999999998,null,null,2.2999999999999998,{"$f":"IF(VLOOKUP(AF123,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ123,1)-AJ123,2),Round,2,FALSE)+VLOOKUP(AF123,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"\",0,ROUND(AJ123-0.04999,1)-AJ123+AM123)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF123,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Horseshoe Shim Spacers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR116U",null,"1/16\" U",null,"12000 - Box",null,null,null,"- 270 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA126,'Price List'!AG126)","v":18.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},18.95,null,"YES",18.95,0,18.95,0,null,{"$f":"+A126","v":"PR"},18.95,null,null,18.95,{"$f":"IF(VLOOKUP(AF126,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ126,1)-AJ126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"\",0,ROUND(AJ126-0.04999,1)-AJ126+AM126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR18U",null,"1/8 U",null,"12020 - Box",null,null,null,"- 160 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA127,'Price List'!AG127)","v":13.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},13.45,null,"YES",13.45,0,13.45,0,null,{"$f":"+A127","v":"PR"},13.45,null,null,13.45,{"$f":"IF(VLOOKUP(AF127,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ127,1)-AJ127,2),Round,2,FALSE)+VLOOKUP(AF127,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"\",0,ROUND(AJ127-0.04999,1)-AJ127+AM127)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF127,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Wedges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PRWEDGEJAR",null,null,null,"12370 - Reg. Wedges",null,null,null,"- 450 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA130,'Price List'!AG130)","v":6.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},6.4,null,"YES",6.4,0,6.4,0,null,{"$f":"+A130","v":"PR"},6.4,null,null,6.4,{"$f":"IF(VLOOKUP(AF130,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ130,1)-AJ130,2),Round,2,FALSE)+VLOOKUP(AF130,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,5,FALSE)=\"\",0,ROUND(AJ130-0.04999,1)-AJ130+AM130)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF130,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PRWEDGESUPER",null,null,null,"12380 - Super Wedges",null,null,null,"- 75 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA131,'Price List'!AG131)","v":6.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},6.4,null,"YES",6.4,0,6.4,0,null,{"$f":"+A131","v":"PR"},6.4,null,null,6.4,{"$f":"IF(VLOOKUP(AF131,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ131,1)-AJ131,2),Round,2,FALSE)+VLOOKUP(AF131,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,5,FALSE)=\"\",0,ROUND(AJ131-0.04999,1)-AJ131+AM131)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF131,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR16370",null,null,null,"16370 - Gripper Wedges",null,null,null,"- 550 Count",null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA132,'Price List'!AG132)","v":8.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},8.9,null,"YES",8.9,0,8.9,0,null,{"$f":"+A132","v":"PR"},8.9,null,null,8.9,{"$f":"IF(VLOOKUP(AF132,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ132,1)-AJ132,2),Round,2,FALSE)+VLOOKUP(AF132,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"\",0,ROUND(AJ132-0.04999,1)-AJ132+AM132)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF132,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Chasers/Removers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PRSC1",null,"84000 SC-1 Spacer Chaser",null,null,null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA135,'Price List'!AG135)","v":3.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},3.5,null,"YES",3.5,0,3.5,0,null,{"$f":"+A135","v":"PR"},3.5,null,null,3.5,{"$f":"IF(VLOOKUP(AF135,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ135,1)-AJ135,2),Round,2,FALSE)+VLOOKUP(AF135,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"\",0,ROUND(AJ135-0.04999,1)-AJ135+AM135)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF135,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Lippage Reduction Systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"ProLeveling System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PP","Progress Profiles - All",null,"PPPRSL1",null,"1 mm - 1/16\"",null,"PRSL1","Linear Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA141,'Price List'!AG141)","v":31.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA141*(1-W141)+0.004999,2)","v":31.8},null,"YES",31.8,{"$f":"+W141","v":0},{"$f":"+X141","v":31.8},{"$f":"(AG141-AC141)/AG141","v":0},null,{"$f":"+A141","v":"PP"},{"$f":"SUM(AJ141:AL141)+AE141","v":31.8},null,null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":31.8},{"$f":"IF(VLOOKUP(AF141,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ141,1)-AJ141,2),Round,2,FALSE)+VLOOKUP(AF141,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,5,FALSE)=\"\",0,ROUND(AJ141-0.04999,1)-AJ141+AM141)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF141,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSL2",null,"2 mm - 3/32\"",null,"PRSL2","Linear Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA142,'Price List'!AG142)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A142","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF142,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ142,1)-AJ142,2),Round,2,FALSE)+VLOOKUP(AF142,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,5,FALSE)=\"\",0,ROUND(AJ142-0.04999,1)-AJ142+AM142)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF142,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSL3",null,"3 mm - 1/8\"",null,"PRSL3","Linear Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA143,'Price List'!AG143)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A143","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF143,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ143,1)-AJ143,2),Round,2,FALSE)+VLOOKUP(AF143,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"\",0,ROUND(AJ143-0.04999,1)-AJ143+AM143)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF143,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSL5",null,"5 mm - 3/16\"",null,"PRSL5","Linear Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA144,'Price List'!AG144)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A144","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF144,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PP","Progress Profiles - All",null,"PPPRST1",null,"1 mm - 1/16\"",null,"PRST1","T-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA146,'Price List'!AG146)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A146","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF146,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ146,1)-AJ146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"\",0,ROUND(AJ146-0.04999,1)-AJ146+AM146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF146,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRST2",null,"2 mm - 3/32\"",null,"PRST2","T-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA147,'Price List'!AG147)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A147","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF147,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ147,1)-AJ147,2),Round,2,FALSE)+VLOOKUP(AF147,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,5,FALSE)=\"\",0,ROUND(AJ147-0.04999,1)-AJ147+AM147)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF147,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRST3",null,"3 mm - 1/8\"",null,"PRST3","T-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA148,'Price List'!AG148)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A148","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF148,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF148,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRST5",null,"5 mm - 3/16\"",null,"PRST5","T-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA149,'Price List'!AG149)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A149","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF149,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ149,1)-AJ149,2),Round,2,FALSE)+VLOOKUP(AF149,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"\",0,ROUND(AJ149-0.04999,1)-AJ149+AM149)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF149,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PP","Progress Profiles - All",null,"PPPRSC1",null,"1 mm - 1/16\"",null,"PRSC1","Cross-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA151,'Price List'!AG151)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A151","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF151,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ151,1)-AJ151,2),Round,2,FALSE)+VLOOKUP(AF151,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,5,FALSE)=\"\",0,ROUND(AJ151-0.04999,1)-AJ151+AM151)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF151,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSC2",null,"2 mm - 3/32\"",null,"PRSC2","Cross-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA152,'Price List'!AG152)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A152","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF152,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ152,1)-AJ152,2),Round,2,FALSE)+VLOOKUP(AF152,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"\",0,ROUND(AJ152-0.04999,1)-AJ152+AM152)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF152,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSC3",null,"3 mm - 1/8\"",null,"PRSC3","Cross-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA153,'Price List'!AG153)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A153","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF153,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ153,1)-AJ153,2),Round,2,FALSE)+VLOOKUP(AF153,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"\",0,ROUND(AJ153-0.04999,1)-AJ153+AM153)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF153,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSC5",null,"5 mm - 3/16\"",null,"PRSC5","Cross-Shaped Levelers",null,null,null,"- 100 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA154,'Price List'!AG154)","v":43.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},43.45,null,"YES",43.45,0,43.45,0,null,{"$f":"+A154","v":"PP"},43.45,null,null,43.45,{"$f":"IF(VLOOKUP(AF154,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ154,1)-AJ154,2),Round,2,FALSE)+VLOOKUP(AF154,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"\",0,ROUND(AJ154-0.04999,1)-AJ154+AM154)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF154,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PP","Progress Profiles - All",null,"PPPRST",null,"PRST","Universal Rotating Pommel Cap (re-usable)",null,null,null,null,null,"- 50 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA156,'Price List'!AG156)","v":81.650000000000006},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},81.650000000000006,null,"YES",81.650000000000006,0,81.650000000000006,0,null,{"$f":"+A156","v":"PP"},81.650000000000006,null,null,81.650000000000006,{"$f":"IF(VLOOKUP(AF156,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ156,1)-AJ156,2),Round,2,FALSE)+VLOOKUP(AF156,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"\",0,ROUND(AJ156-0.04999,1)-AJ156+AM156)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF156,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSTT",null,"PRSTT","Transparent Rotating Pommel Cap (re-usable)",null,null,null,null,null,"- 50 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA157,'Price List'!AG157)","v":96},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":96},null,"YES",96,{"$f":"+W157","v":0},{"$f":"+X157","v":96},{"$f":"(AG157-AC157)/AG157","v":0},null,{"$f":"+A157","v":"PP"},{"$f":"SUM(AJ157:AL157)+AE157","v":96},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":96},{"$f":"IF(VLOOKUP(AF157,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSPC",null,"PRSPC","System Protection Cap (re-usable)",null,null,null,null,null,"- 50 Count",null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA158,'Price List'!AG158)","v":80.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},80.95,null,"YES",80.95,0,80.95,0,null,{"$f":"+A158","v":"PP"},80.95,null,null,80.95,{"$f":"IF(VLOOKUP(AF158,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,5,FALSE))","v":""},null,"X"]
["PP","Progress Profiles - All",null,"PPPRSSV",null,"PRSSV","Pommel Remover",null,null,null,null,null,null,null,"Progress",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA159,'Price List'!AG159)","v":1.6},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1.6,null,"YES",1.6,0,1.6,0,null,{"$f":"+A159","v":"PP"},1.6,null,null,1.6,{"$f":"IF(VLOOKUP(AF159,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Delta Leveling System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
["RU","Rubi - All Other",null,"RU02842",null,"1/16\" Clip",null,"02842 Delta Leveling System",null,null,null,null,"- 400 Count",null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA163,'Price List'!AG163)","v":41},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA163*(1-W163)+0.004999,2)","v":41},null,"YES",41,{"$f":"+W163","v":0},41,{"$f":"(AG163-AC163)/AG163","v":0},null,{"$f":"+A163","v":"RU"},{"$f":"SUM(AJ163:AL163)+AE163","v":41},null,null,{"$f":"ROUND(AC163/(1-VLOOKUP(AF163,Group,2,FALSE)),2)","v":41},{"$f":"IF(VLOOKUP(AF163,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ163,1)-AJ163,2),Round,2,FALSE)+VLOOKUP(AF163,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,5,FALSE)=\"\",0,ROUND(AJ163-0.04999,1)-AJ163+AM163)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF163,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU02868",null,"1/8\" Clip",null,"02868 Delta Leveling System",null,null,null,null,"- 400 Count",null,"Rubi",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA164,'Price List'!AG164)","v":41.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":41.05},null,"new",41.05,{"$f":"+W164","v":0},{"$f":"+X164","v":41.05},{"$f":"(AG164-AC164)/AG164","v":0},null,{"$f":"+A164","v":"RU"},{"$f":"SUM(AJ164:AL164)+AE164","v":41.05},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":41.05},{"$f":"IF(VLOOKUP(AF164,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ164,1)-AJ164,2),Round,2,FALSE)+VLOOKUP(AF164,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,5,FALSE)=\"\",0,ROUND(AJ164-0.04999,1)-AJ164+AM164)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF164,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU02845",null,"Wedge",null,"02845 Delta Leveling System",null,null,null,null,"- 400 Count",null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA165,'Price List'!AG165)","v":52.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":52.8},null,"YES",52.8,0,52.8,{"$f":"(AG165-AC165)/AG165","v":0},null,{"$f":"+A165","v":"RU"},{"$f":"SUM(AJ165:AL165)+AE165","v":52.8},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":52.8},{"$f":"IF(VLOOKUP(AF165,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ165,1)-AJ165,2),Round,2,FALSE)+VLOOKUP(AF165,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"\",0,ROUND(AJ165-0.04999,1)-AJ165+AM165)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF165,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU03901",null,"Pliers",null,"03901 Tile Level Pliers Fast-Fix",null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA166,'Price List'!AG166)","v":37.700000000000003},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":37.700000000000003},null,"new",37.700000000000003,0,37.700000000000003,{"$f":"(AG166-AC166)/AG166","v":0},null,{"$f":"+A166","v":"RU"},{"$f":"SUM(AJ166:AL166)+AE166","v":37.700000000000003},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":37.700000000000003},{"$f":"IF(VLOOKUP(AF166,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF166,Group,5,FALSE))","v":""},null,"X"]
[]
[null,null,"Knee Pads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PRKN1",null,"20010 KN-1 UltraLight",null,null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA170,'Price List'!AG170)","v":20.399999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA170*(1-W170)+0.004999,2)","v":20.399999999999999},null,"YES",20.399999999999999,{"$f":"+W170","v":0},{"$f":"+X170","v":20.399999999999999},{"$f":"(AG170-AC170)/AG170","v":0},null,{"$f":"+A170","v":"PR"},{"$f":"SUM(AJ170:AL170)+AE170","v":20.399999999999999},null,null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":20.399999999999999},{"$f":"IF(VLOOKUP(AF170,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ170,1)-AJ170,2),Round,2,FALSE)+VLOOKUP(AF170,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"\",0,ROUND(AJ170-0.04999,1)-AJ170+AM170)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF170,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PRKN1BUTTON",null,null,"20993 Replacement Buttons for KN-1",null,null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA171,'Price List'!AG171)","v":2.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},2.9,null,"YES",2.9,0,2.9,0,null,"PR",2.9,null,null,2.9,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PRKN1LINER",null,null,"20992 Replacement Liner for KN-1",null,null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA172,'Price List'!AG172)","v":7.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},7.95,null,"YES",7.95,0,7.95,0,null,"PR",7.95,null,null,7.95,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PRKN1STRAPS",null,null,"20991 Replacement Straps for KN-1",null,null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA173,'Price List'!AG173)","v":4.5999999999999996},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},4.5999999999999996,null,"YES",4.5999999999999996,0,4.5999999999999996,0,null,"PR",4.5999999999999996,null,null,4.5999999999999996,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX17209",null,"17-209 Super Soft Knee Pads - Regular","Super Soft Knee Pads",null,null,null,null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA174,'Price List'!AG174)","v":31.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},31.75,null,"YES",31.75,0,31.75,0,null,"TR",31.75,null,null,31.75,0,0,"",null,"X"]
["TR","Troxell - All Other",null,"TX17209L",null,"17-209L Super Soft Knee Pads - Large",null,null,null,null,null,null,null,null,"Troxell",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA175,'Price List'!AG175)","v":42.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},42.4,null,"YES",42.4,0,42.4,0,null,"TR",42.4,null,null,42.4,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Wet Saws",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Saws - Cutting Length 48\" and greater",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUDS2501500",null,"DS250N 1500 Bridge Saw w/ Folding Legs - ZERO DUST",null,null,null,null,null,null,null,null,"Rubi",null,"n/s",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA180,'Price List'!AG180)","v":2995},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA180*(1-W180)+0.004999,2)","v":2995},null,"YES",2995,{"$f":"+W180","v":0},{"$f":"+X180","v":2995},{"$f":"(AG180-AC180)/AG180","v":0},null,{"$f":"+A180","v":"RU1"},{"$f":"SUM(AJ180:AL180)+AE180","v":2995},null,null,{"$f":"ROUND(AC180/(1-VLOOKUP(AF180,Group,2,FALSE)),2)","v":2995},{"$f":"IF(VLOOKUP(AF180,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ180,1)-AJ180,2),Round,2,FALSE)+VLOOKUP(AF180,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,5,FALSE)=\"\",0,ROUND(AJ180-0.04999,1)-AJ180+AM180)","v":0},{"$f":"IF(VLOOKUP(AF180,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF180,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- 61\" cutting length / 42\" diagonal",null,null,null,null,"- Dimensions: 87\" x 29\" x 51\" "]
[null,null,null,null,"- Weight = 242 lbs",null,null,null,null,"- Precise Mitre Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- 10\" Saw Blade Capacity - 1\" Arbor",null,null,null,null,"- Plunge Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Horsepower = 3 hp",null,null,null,null,"- Folding Legs w/ Wheels for easy transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUDS2501300",null,"DS250N 1300 Bridge Saw w/ Folding Legs - ZERO DUST",null,null,null,null,null,null,null,null,"Rubi",null,"n/s",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA186,'Price List'!AG186)","v":2855},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA186*(1-W186)+0.004999,2)","v":2855},null,"YES",2855,{"$f":"+W186","v":0},{"$f":"+X186","v":2855},{"$f":"(AG186-AC186)/AG186","v":0},null,{"$f":"+A186","v":"RU1"},{"$f":"SUM(AJ186:AL186)+AE186","v":2855},null,null,{"$f":"ROUND(AC186/(1-VLOOKUP(AF186,Group,2,FALSE)),2)","v":2855},{"$f":"IF(VLOOKUP(AF186,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ186,1)-AJ186,2),Round,2,FALSE)+VLOOKUP(AF186,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,5,FALSE)=\"\",0,ROUND(AJ186-0.04999,1)-AJ186+AM186)","v":0},{"$f":"IF(VLOOKUP(AF186,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF186,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- 51\" cutting length / 37\" diag cut",null,null,null,null,"- Dimensions: 79\" x 29\" x 51\" "]
[null,null,null,null,"- Weight = 275 lbs",null,null,null,null,"- Precise Mitre Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- 10\" Saw Blade Capacity - 1\" Arbor",null,null,null,null,"- Plunge Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Horsepower = 3 hp",null,null,null,null,"- Folding Legs w/ Wheels for easy transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUDC250/1200",null,"DC250 1200 Bridge Saw w/ Folding Legs",null,null,null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA192,'Price List'!AG192)","v":1495},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA192*(1-W192)+0.004999,2)","v":1495},null,"YES",1495,{"$f":"+W192","v":0},{"$f":"+X192","v":1495},{"$f":"(AG192-AC192)/AG192","v":0},null,{"$f":"+A192","v":"RU1"},{"$f":"SUM(AJ192:AL192)+AE192","v":1495},null,null,{"$f":"ROUND(AC192/(1-VLOOKUP(AF192,Group,2,FALSE)),2)","v":1495},{"$f":"IF(VLOOKUP(AF192,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ192,1)-AJ192,2),Round,2,FALSE)+VLOOKUP(AF192,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF192,Group,5,FALSE)=\"\",0,ROUND(AJ192-0.04999,1)-AJ192+AM192)","v":0},{"$f":"IF(VLOOKUP(AF192,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF192,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- 48\" cutting length / 33\" diag cut",null,null,null,null,"- Dimensions: 67\" x 31\" x 51\" "]
[null,null,null,null,"- Weight = 132 lbs",null,null,null,null,"- Precise Mitre Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- 10\" Saw Blade Capacity - 5/8\" Arbor",null,null,null,null,"- Plunge Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Horsepower = 1.5 hp",null,null,null,null,"- Folding Legs w/ Wheels for easy transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Removable Table for easy cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Saws - Cutting Length 36\" to 48\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUDC2500/850",null,"DC250 850 Bridge Saw w/ Folding Legs",null,null,null,null,null,null,null,null,"Rubi",null,"n/s",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA200,'Price List'!AG200)","v":1285},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA200*(1-W200)+0.004999,2)","v":1285},null,"YES",1285,{"$f":"+W200","v":0},{"$f":"+X200","v":1285},{"$f":"(AG200-AC200)/AG200","v":0},null,{"$f":"+A200","v":"RU1"},{"$f":"SUM(AJ200:AL200)+AE200","v":1285},null,null,{"$f":"ROUND(AC200/(1-VLOOKUP(AF200,Group,2,FALSE)),2)","v":1285},{"$f":"IF(VLOOKUP(AF200,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ200,1)-AJ200,2),Round,2,FALSE)+VLOOKUP(AF200,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,5,FALSE)=\"\",0,ROUND(AJ200-0.04999,1)-AJ200+AM200)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF200,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- 38\" cutting length / 27\" diag cut",null,null,null,null,"- Dimensions: 58\" x 31\" x 51\" "]
[null,null,null,null,"- Weight = 121 lbs",null,null,null,null,"- Precise Mitre Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- 10\" Saw Blade Capacity - 5/8\" Arbor",null,null,null,null,"- Plunge Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Horsepower = 1.5 hp",null,null,null,null,"- Folding Legs w/ Wheels for easy transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Removable Table for easy cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Saws - Cutting Length between 20\" to 36\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["IQ1","IQ Tools - Saws/Cutters",null,"IQIQTS244",null,"IQTS244 Dry Cut Tile Saw w/ Integrated Dust Containment",null,null,null,null,null,null,null,null,"IQ Tools",null,"Stock",null,{"$f":"+AA208+AA209","v":2185},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA208*(1-W208)+0.004999,2)","v":2000},null,"YES",2000,{"$f":"+W208","v":0},2000,{"$f":"(AG208-AC208)/AG208","v":0},null,{"$f":"+A208","v":"IQ1"},{"$f":"SUM(AJ208:AL208)+AE208","v":2000},null,null,{"$f":"ROUND(AC208/(1-VLOOKUP(AF208,Group,2,FALSE)),2)","v":2000},{"$f":"IF(VLOOKUP(AF208,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ208,1)-AJ208,2),Round,2,FALSE)+VLOOKUP(AF208,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,5,FALSE)=\"\",0,ROUND(AJ208-0.04999,1)-AJ208+AM208)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF208,Group,5,FALSE))","v":""},null,"X"]
["IQ","IQ Tools - All Other",null,"IQIQTS244STAND",null,null,"IQTS244 Stand",null,"(Saw & Stand are only sold as a set)",null,null,null,null,null,"IQ Tools",null,"Stock",null,null,"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA209*(1-W209)+0.004999,2)","v":185},null,"YES",185,0,185,{"$f":"(AG209-AC209)/AG209","v":0},null,{"$f":"+A209","v":"IQ"},{"$f":"SUM(AJ209:AL209)+AE209","v":185},null,null,{"$f":"ROUND(AC209/(1-VLOOKUP(AF209,Group,2,FALSE)),2)","v":185},{"$f":"IF(VLOOKUP(AF209,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ209,1)-AJ209,2),Round,2,FALSE)+VLOOKUP(AF209,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,5,FALSE)=\"\",0,ROUND(AJ209-0.04999,1)-AJ209+AM209)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF209,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- 24\" cutting length / 18\" diag cut",null,null,null,null,"- Dimensions: 34\" x 27\" x 28\" "]
[null,null,null,null,"- Dust Containment System",null,null,null,null,"- Meets OSHA 2017 Silica Standard"]
[null,null,null,null,"- Horsepower = 1.5 hp",null,null,null,null,"- Adjustable Cutting Head - Cuts up to 1\""]
[null,null,null,null,"- Weight = 92 lbs",null,null,null,null,"- Includes Stand & Blade"]
[null,null,null,null,"- 10\" Saw Blade Capacity (must use their blade - Q-Drive Blade with Cool Cut Technology)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["IQ","IQ Tools - All Other",null,"     IQIQTS244TABLEEXT",null,null,"iQTS244 Extension Table Accessory",null,null,null,null,null,null,null,"IQ Tools",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA216,'Price List'!AG216)","v":317},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":317},null,"YES",317,{"$f":"+W216","v":0},317,{"$f":"(AG216-AC216)/AG216","v":0},null,{"$f":"+A216","v":"IQ"},{"$f":"SUM(AJ216:AL216)+AE216","v":317},null,null,{"$f":"ROUND(AC216/(1-VLOOKUP(AF216,Group,2,FALSE)),2)","v":317},{"$f":"IF(VLOOKUP(AF216,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ216,1)-AJ216,2),Round,2,FALSE)+VLOOKUP(AF216,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"\",0,ROUND(AJ216-0.04999,1)-AJ216+AM216)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF216,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,"- Extension table allows you to rip cut any length plank tile"]
["IQ","IQ Tools - All Other",null,"     IQIQTS244MITER",null,null,"iQTS244 Miter Attachment Accessory",null,null,null,null,null,null,null,"IQ Tools",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA218,'Price List'!AG218)","v":192},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA218*(1-W218)+0.004999,2)","v":192},null,"YES",192,0,192,{"$f":"(AG218-AC218)/AG218","v":0},null,{"$f":"+A218","v":"IQ"},{"$f":"SUM(AJ218:AL218)+AE218","v":192},null,null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":192},{"$f":"IF(VLOOKUP(AF218,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ218,1)-AJ218,2),Round,2,FALSE)+VLOOKUP(AF218,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"\",0,ROUND(AJ218-0.04999,1)-AJ218+AM218)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF218,Group,5,FALSE))","v":""},null,"X"]
["IQ","IQ Tools - All Other",null,"     IQIQTS244FILTER",null,null,"iQTS244 Replacement Vacuum Filter Kit",null,null,null,null,null,null,null,"IQ Tools",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA219,'Price List'!AG219)","v":90},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA219*(1-W219)+0.004999,2)","v":90},null,"YES",90,{"$f":"+W219","v":0},{"$f":"+X219","v":90},{"$f":"(AG219-AC219)/AG219","v":0},null,{"$f":"+A219","v":"IQ"},{"$f":"SUM(AJ219:AL219)+AE219","v":90},null,null,{"$f":"ROUND(AC219/(1-VLOOKUP(AF219,Group,2,FALSE)),2)","v":90},{"$f":"IF(VLOOKUP(AF219,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ219,1)-AJ219,2),Round,2,FALSE)+VLOOKUP(AF219,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,5,FALSE)=\"\",0,ROUND(AJ219-0.04999,1)-AJ219+AM219)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF219,Group,5,FALSE))","v":""},null,"X"]
["IQ","IQ Tools - All Other",null,"     IQIQTS24HOSE",null,null,"iQTS244 Vacuum Port Hose Kit",null,null,null,null,null,null,null,"IQ Tools",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA220,'Price List'!AG220)","v":112},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA220*(1-W220)+0.004999,2)","v":112},null,"YES",112,0,112,{"$f":"(AG220-AC220)/AG220","v":0},null,{"$f":"+A220","v":"IQ"},{"$f":"SUM(AJ220:AL220)+AE220","v":112},null,null,{"$f":"ROUND(AC220/(1-VLOOKUP(AF220,Group,2,FALSE)),2)","v":112},{"$f":"IF(VLOOKUP(AF220,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ220,1)-AJ220,2),Round,2,FALSE)+VLOOKUP(AF220,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF220,Group,5,FALSE)=\"\",0,ROUND(AJ220-0.04999,1)-AJ220+AM220)","v":0},{"$f":"IF(VLOOKUP(AF220,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF220,Group,5,FALSE))","v":""},null,"X"]
["IQ","IQ Tools - All Other",null,"     IQIQPDS00100",null,null,"iQPDS00100-TS 8\" Professional Dressing Stone",null,null,null,null,null,null,null,"IQ Tools",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA221,'Price List'!AG221)","v":15.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA221*(1-W221)+0.004999,2)","v":15.1},null,"YES",15.1,{"$f":"+W221","v":0},{"$f":"+X221","v":15.1},{"$f":"(AG221-AC221)/AG221","v":0},null,{"$f":"+A221","v":"IQ"},{"$f":"SUM(AJ221:AL221)+AE221","v":15.1},null,null,{"$f":"ROUND(AC221/(1-VLOOKUP(AF221,Group,2,FALSE)),2)","v":15.1},{"$f":"IF(VLOOKUP(AF221,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ221,1)-AJ221,2),Round,2,FALSE)+VLOOKUP(AF221,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,5,FALSE)=\"\",0,ROUND(AJ221-0.04999,1)-AJ221+AM221)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF221,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["DW1","DeWalt - Saws/Cutters",null,"DWD24000S",null,"D24000S 24\" Wet Saw w/ Stand",null,null,null,null,null,null,null,null,"Dewalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA223,'Price List'!AG223)","v":949},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA223*(1-W223)+0.004999,2)","v":949},null,"",949,{"$f":"+W223","v":0},{"$f":"+X223","v":949},{"$f":"(AG223-AC223)/AG223","v":0},null,{"$f":"+A223","v":"DW1"},{"$f":"SUM(AJ223:AL223)+AE223","v":949},null,null,{"$f":"ROUND(AC223/(1-VLOOKUP(AF223,Group,2,FALSE)),2)","v":949},{"$f":"IF(VLOOKUP(AF223,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ223,1)-AJ223,2),Round,2,FALSE)+VLOOKUP(AF223,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,5,FALSE)=\"\",0,ROUND(AJ223-0.04999,1)-AJ223+AM223)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF223,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- 24\" cutting length / 18\" diagonal cut",null,null,null,null,"- Pivoting Head for precise mitre cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- 10\" Saw Blade Capacity",null,null,null,null,"- Plunge Cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Horsepower = 1.5 HP",null,null,null,null,"- Edge Guide with 2-position 45 degree guide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Weight = 69 lbs",null,null,null,null,"- Water Retention System!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Dimensions:  34\" x 27\"",null,null,null,null,"- Includes Stand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["IQ1","IQ Tools - Saws/Cutters",null,"IQIQ228CYCLONE",null,"IQ228Cyclone Dry Cut Tabletop Tile Saw ",null,null,null,null,null,null,null,null,"IQ Tools",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA230,'Price List'!AG230)","v":710},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA230*(1-W230)+0.004999,2)","v":710},null,"new",710,{"$f":"+W230","v":0},{"$f":"+X230","v":710},{"$f":"(AG230-AC230)/AG230","v":0},null,{"$f":"+A230","v":"IQ1"},{"$f":"SUM(AJ230:AL230)+AE230","v":710},null,null,{"$f":"ROUND(AC230/(1-VLOOKUP(AF230,Group,2,FALSE)),2)","v":710},{"$f":"IF(VLOOKUP(AF230,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ230,1)-AJ230,2),Round,2,FALSE)+VLOOKUP(AF230,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,5,FALSE)=\"\",0,ROUND(AJ230-0.04999,1)-AJ230+AM230)","v":0},{"$f":"IF(VLOOKUP(AF230,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF230,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,"w/ Integrated Dust Containment"]
[null,null,null,null,"- 18\" w/ Rolling Table / Lock the table in place to cut 24\"+ planks with IQ Micro Fence"]
[null,null,null,null,"- Dust Containment System",null,null,null,null,"- Dimensions: 17\" x 25\" x 10\""]
[null,null,null,null,"- Horsepower = ",null,null,null,null,"- Meets OSHA 2017 Silica Standard"]
[null,null,null,null,"- Weight = 36 lbs",null,null,null,null,"- 99.5% Dust- Free"]
[null,null,null,null,"- Adjustable Cutting Head - Cuts up to 1.25\"",null,null,null,null,"- Includes Blade & Dressing Stone"]
[null,null,null,null,"- Unique Rail System allows for easy 22.5 and 45 degree cuts"]
[null,null,null,null,"- 7\" Saw Blade Capacity (must use their blade - Q-Drive Blade with Cool Cut Technology)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Wet Saws - Diamond Blades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Diamond Blades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU","Rubi - All Other",null,"RU31914",null,"4-1/2\" Blade",null,"31914 Dry/Wet Continuous Rim Blade for Porcelain Tiles",null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA243,'Price List'!AG243)","v":13},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA243*(1-W243)+0.004999,2)","v":13},null,"YES",13,{"$f":"+W243","v":0},{"$f":"+X243","v":13},{"$f":"(AG243-AC243)/AG243","v":0},null,{"$f":"+A243","v":"RU"},{"$f":"SUM(AJ243:AL243)+AE243","v":13},null,null,{"$f":"ROUND(AC243/(1-VLOOKUP(AF243,Group,2,FALSE)),2)","v":13},{"$f":"IF(VLOOKUP(AF243,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ243,1)-AJ243,2),Round,2,FALSE)+VLOOKUP(AF243,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,5,FALSE)=\"\",0,ROUND(AJ243-0.04999,1)-AJ243+AM243)","v":0},{"$f":"IF(VLOOKUP(AF243,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF243,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU31907",null,"10\" Blade",null,"31907 Porcelaim Diamond Blade",null,null,null,null,null,null,"Rubi",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA244,'Price List'!AG244)","v":43.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA244*(1-W244)+0.004999,2)","v":43.35},null,"new",43.35,{"$f":"+W244","v":0},{"$f":"+X244","v":43.35},{"$f":"(AG244-AC244)/AG244","v":0},null,{"$f":"+A244","v":"RU"},{"$f":"SUM(AJ244:AL244)+AE244","v":43.35},null,null,{"$f":"ROUND(AC244/(1-VLOOKUP(AF244,Group,2,FALSE)),2)","v":43.35},{"$f":"IF(VLOOKUP(AF244,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ244,1)-AJ244,2),Round,2,FALSE)+VLOOKUP(AF244,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF244,Group,5,FALSE)=\"\",0,ROUND(AJ244-0.04999,1)-AJ244+AM244)","v":0},{"$f":"IF(VLOOKUP(AF244,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF244,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- good performance, smooth continuous rim blades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"High-Performance - Diamond Blades - reinforced core",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU","Rubi - All Other",null,"RU31926",null,"4\" Blade",null,"31926 Viper Dry/Wet Blade",null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA248,'Price List'!AG248)","v":29.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA248*(1-W248)+0.004999,2)","v":29.95},null,"YES",29.95,{"$f":"+W248","v":0},29.95,{"$f":"(AG248-AC248)/AG248","v":0},null,{"$f":"+A248","v":"RU"},{"$f":"SUM(AJ248:AL248)+AE248","v":29.95},null,null,{"$f":"ROUND(AC248/(1-VLOOKUP(AF248,Group,2,FALSE)),2)","v":29.95},{"$f":"IF(VLOOKUP(AF248,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ248,1)-AJ248,2),Round,2,FALSE)+VLOOKUP(AF248,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF248,Group,5,FALSE)=\"\",0,ROUND(AJ248-0.04999,1)-AJ248+AM248)","v":0},{"$f":"IF(VLOOKUP(AF248,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF248,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU31929",null,"7\" Blade",null,"31929 Viper Blade",null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA249,'Price List'!AG249)","v":58.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA249*(1-W249)+0.004999,2)","v":58.3},null,"YES",58.3,0,58.3,{"$f":"(AG249-AC249)/AG249","v":0},null,{"$f":"+A249","v":"RU"},{"$f":"SUM(AJ249:AL249)+AE249","v":58.3},null,null,{"$f":"ROUND(AC249/(1-VLOOKUP(AF249,Group,2,FALSE)),2)","v":58.3},{"$f":"IF(VLOOKUP(AF249,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ249,1)-AJ249,2),Round,2,FALSE)+VLOOKUP(AF249,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF249,Group,5,FALSE)=\"\",0,ROUND(AJ249-0.04999,1)-AJ249+AM249)","v":0},{"$f":"IF(VLOOKUP(AF249,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF249,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU31940",null,"8\" Blade",null,"31940 Viper Blade",null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA250,'Price List'!AG250)","v":68.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA250*(1-W250)+0.004999,2)","v":68.75},null,"YES",68.75,0,68.75,{"$f":"(AG250-AC250)/AG250","v":0},null,{"$f":"+A250","v":"RU"},{"$f":"SUM(AJ250:AL250)+AE250","v":68.75},null,null,{"$f":"ROUND(AC250/(1-VLOOKUP(AF250,Group,2,FALSE)),2)","v":68.75},{"$f":"IF(VLOOKUP(AF250,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ250,1)-AJ250,2),Round,2,FALSE)+VLOOKUP(AF250,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF250,Group,5,FALSE)=\"\",0,ROUND(AJ250-0.04999,1)-AJ250+AM250)","v":0},{"$f":"IF(VLOOKUP(AF250,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF250,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU31941",null,"10\" Blade",null,"31941 Viper Blade",null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA251,'Price List'!AG251)","v":77.599999999999994},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA251*(1-W251)+0.004999,2)","v":77.599999999999994},null,"YES",77.599999999999994,0,77.599999999999994,{"$f":"(AG251-AC251)/AG251","v":0},null,{"$f":"+A251","v":"RU"},{"$f":"SUM(AJ251:AL251)+AE251","v":77.599999999999994},null,null,{"$f":"ROUND(AC251/(1-VLOOKUP(AF251,Group,2,FALSE)),2)","v":77.599999999999994},{"$f":"IF(VLOOKUP(AF251,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ251,1)-AJ251,2),Round,2,FALSE)+VLOOKUP(AF251,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF251,Group,5,FALSE)=\"\",0,ROUND(AJ251-0.04999,1)-AJ251+AM251)","v":0},{"$f":"IF(VLOOKUP(AF251,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF251,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- Thicker center to avoid vibrations and wobbling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- Specifically designed to provide greater speed without sacrificing finish quality",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- for ceramic tile, porcelain tile, extra hard tiles and hard natural stones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Q-Drive Blade with Cool Cut Technology for IQTS244 Dry Cut Tile Saw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["IQ","IQ Tools - All Other",null,"IQBLADE07",null,"7\" Blade",null,"Q-Drive Blade for IQ228Cyclone Saw",null,null,null,null,null,null,"IQ Tools",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA257,'Price List'!AG257)","v":63.6},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA257*(1-W257)+0.004999,2)","v":63.6},null,"new",63.6,{"$f":"+W257","v":0},{"$f":"+X257","v":63.6},{"$f":"(AG257-AC257)/AG257","v":0},null,{"$f":"+A257","v":"IQ"},{"$f":"SUM(AJ257:AL257)+AE257","v":63.6},null,null,{"$f":"ROUND(AC257/(1-VLOOKUP(AF257,Group,2,FALSE)),2)","v":63.6},{"$f":"IF(VLOOKUP(AF257,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ257,1)-AJ257,2),Round,2,FALSE)+VLOOKUP(AF257,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF257,Group,5,FALSE)=\"\",0,ROUND(AJ257-0.04999,1)-AJ257+AM257)","v":0},{"$f":"IF(VLOOKUP(AF257,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF257,Group,5,FALSE))","v":""},null,"X"]
["IQ","IQ Tools - All Other",null,"IQBLADE10",null,"10\" Blade",null,"Q-Drive Blade for IQTS244 Saw",null,null,null,null,null,null,"IQ Tools",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA258,'Price List'!AG258)","v":109.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA258*(1-W258)+0.004999,2)","v":109.5},null,"YES",109.5,{"$f":"+W258","v":0},{"$f":"+X258","v":109.5},{"$f":"(AG258-AC258)/AG258","v":0},null,{"$f":"+A258","v":"IQ"},{"$f":"SUM(AJ258:AL258)+AE258","v":109.5},null,null,{"$f":"ROUND(AC258/(1-VLOOKUP(AF258,Group,2,FALSE)),2)","v":109.5},{"$f":"IF(VLOOKUP(AF258,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ258,1)-AJ258,2),Round,2,FALSE)+VLOOKUP(AF258,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF258,Group,5,FALSE)=\"\",0,ROUND(AJ258-0.04999,1)-AJ258+AM258)","v":0},{"$f":"IF(VLOOKUP(AF258,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF258,Group,5,FALSE))","v":""},null,"X"]
[]
["IQ","IQ Tools - All Other",null,"IQBLADE07HARD",null,"7\" Blade",null,"Q-Drive Blade for 20cm Thick",null,null,null,null,null,null,"IQ Tools",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA260,'Price List'!AG260)","v":63.6},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA260*(1-W260)+0.004999,2)","v":63.6},null,"new",63.6,{"$f":"+W260","v":0},{"$f":"+X260","v":63.6},{"$f":"(AG260-AC260)/AG260","v":0},null,{"$f":"+A260","v":"IQ"},{"$f":"SUM(AJ260:AL260)+AE260","v":63.6},null,null,{"$f":"ROUND(AC260/(1-VLOOKUP(AF260,Group,2,FALSE)),2)","v":63.6},{"$f":"IF(VLOOKUP(AF260,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ260,1)-AJ260,2),Round,2,FALSE)+VLOOKUP(AF260,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF260,Group,5,FALSE)=\"\",0,ROUND(AJ260-0.04999,1)-AJ260+AM260)","v":0},{"$f":"IF(VLOOKUP(AF260,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF260,Group,5,FALSE))","v":""},null,"X"]
["IQ","IQ Tools - All Other",null,"IQBLADE10HARD",null,"10\" Blade",null,"Q-Drive Blade for 20cm Thick",null,null,null,null,null,null,"IQ Tools",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA261,'Price List'!AG261)","v":109.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},109.5,null,"new",109.5,0,109.5,0,null,{"$f":"+A261","v":"IQ"},109.5,null,null,{"$f":"ROUND(AC261/(1-VLOOKUP(AF261,Group,2,FALSE)),2)","v":109.5},{"$f":"IF(VLOOKUP(AF261,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ261,1)-AJ261,2),Round,2,FALSE)+VLOOKUP(AF261,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,5,FALSE)=\"\",0,ROUND(AJ261-0.04999,1)-AJ261+AM261)","v":0},{"$f":"IF(VLOOKUP(AF261,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF261,Group,5,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Glass Diamond Blade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU","Rubi - All Other",null,"RU31920",null,"7\" Blade",null,"31920 Glass Blade",null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA264,'Price List'!AG264)","v":49.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA264*(1-W264)+0.004999,2)","v":49.05},null,"YES",49.05,{"$f":"+W264","v":0},{"$f":"+X264","v":49.05},{"$f":"(AG264-AC264)/AG264","v":0},null,{"$f":"+A264","v":"RU"},{"$f":"SUM(AJ264:AL264)+AE264","v":49.05},null,null,{"$f":"ROUND(AC264/(1-VLOOKUP(AF264,Group,2,FALSE)),2)","v":49.05},{"$f":"IF(VLOOKUP(AF264,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ264,1)-AJ264,2),Round,2,FALSE)+VLOOKUP(AF264,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF264,Group,5,FALSE)=\"\",0,ROUND(AJ264-0.04999,1)-AJ264+AM264)","v":0},{"$f":"IF(VLOOKUP(AF264,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF264,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU31919",null,"10\" Blade",null,"31919 Glass Blade",null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA265,'Price List'!AG265)","v":85.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA265*(1-W265)+0.004999,2)","v":85.85},null,"YES",85.85,{"$f":"+W265","v":0},{"$f":"+X265","v":85.85},{"$f":"(AG265-AC265)/AG265","v":0},null,{"$f":"+A265","v":"RU"},{"$f":"SUM(AJ265:AL265)+AE265","v":85.85},null,null,{"$f":"ROUND(AC265/(1-VLOOKUP(AF265,Group,2,FALSE)),2)","v":85.85},{"$f":"IF(VLOOKUP(AF265,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ265,1)-AJ265,2),Round,2,FALSE)+VLOOKUP(AF265,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,5,FALSE)=\"\",0,ROUND(AJ265-0.04999,1)-AJ265+AM265)","v":0},{"$f":"IF(VLOOKUP(AF265,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF265,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- Specialized wheel for cutting glass tiles to reduce chipping of glass edge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"- for glass tile, ceramic tile, porcelain tile and soft natural stones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Tile Cutters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR1","Barwalt - Saws/Cutters",null,"PR70623",null,"70623 JP-680 Ishii Tile Cutter",null,null,null,null,"- 27\" Straight - 18\" Diagonal",null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA271,'Price List'!AG271)","v":499},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA271*(1-W271)+0.004999,2)","v":499},null,"YES",499,{"$f":"+W271","v":0},{"$f":"+X271","v":499},{"$f":"(AG271-AC271)/AG271","v":0},null,{"$f":"+A271","v":"PR1"},{"$f":"SUM(AJ271:AL271)+AE271","v":499},null,null,{"$f":"ROUND(AC271/(1-VLOOKUP(AF271,Group,2,FALSE)),2)","v":499},{"$f":"IF(VLOOKUP(AF271,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ271,1)-AJ271,2),Round,2,FALSE)+VLOOKUP(AF271,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,5,FALSE)=\"\",0,ROUND(AJ271-0.04999,1)-AJ271+AM271)","v":0},{"$f":"IF(VLOOKUP(AF271,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF271,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70660",null,null,"70660 Ishii Replacement Scoring Wheels",null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA272,'Price List'!AG272)","v":39.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA272*(1-W272)+0.004999,2)","v":39.75},null,"YES",39.75,{"$f":"+W272","v":0},{"$f":"+X272","v":39.75},{"$f":"(AG272-AC272)/AG272","v":0},null,{"$f":"+A272","v":"PR"},{"$f":"SUM(AJ272:AL272)+AE272","v":39.75},null,null,{"$f":"ROUND(AC272/(1-VLOOKUP(AF272,Group,2,FALSE)),2)","v":39.75},{"$f":"IF(VLOOKUP(AF272,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ272,1)-AJ272,2),Round,2,FALSE)+VLOOKUP(AF272,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF272,Group,5,FALSE)=\"\",0,ROUND(AJ272-0.04999,1)-AJ272+AM272)","v":0},{"$f":"IF(VLOOKUP(AF272,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF272,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTZ0850",null,"18974 TS-66 MAX Rubi Tile Cutter",null,null,null,null,"- 26\" Straight - 18\" Diagonal",null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA274,'Price List'!AG274)","v":459},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA274*(1-W274)+0.004999,2)","v":459},null,"YES",459,{"$f":"+W274","v":0},459,{"$f":"(AG274-AC274)/AG274","v":0},null,{"$f":"+A274","v":"RU1"},{"$f":"SUM(AJ274:AL274)+AE274","v":459},null,null,{"$f":"ROUND(AC274/(1-VLOOKUP(AF274,Group,2,FALSE)),2)","v":459},{"$f":"IF(VLOOKUP(AF274,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ274,1)-AJ274,2),Round,2,FALSE)+VLOOKUP(AF274,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,5,FALSE)=\"\",0,ROUND(AJ274-0.04999,1)-AJ274+AM274)","v":0},{"$f":"IF(VLOOKUP(AF274,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF274,Group,5,FALSE))","v":""},null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUSPEED62N",null,"14985 SPEED-62 N Rubi Tile Cutter",null,null,null,null,"- 24\" Straight - 17\" Diagonal",null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA275,'Price List'!AG275)","v":279},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA275*(1-W275)+0.004999,2)","v":279},null,"YES",279,0,279,{"$f":"(AG275-AC275)/AG275","v":0},null,{"$f":"+A275","v":"RU1"},{"$f":"SUM(AJ275:AL275)+AE275","v":279},null,null,{"$f":"ROUND(AC275/(1-VLOOKUP(AF275,Group,2,FALSE)),2)","v":279},{"$f":"IF(VLOOKUP(AF275,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ275,1)-AJ275,2),Round,2,FALSE)+VLOOKUP(AF275,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF275,Group,5,FALSE)=\"\",0,ROUND(AJ275-0.04999,1)-AJ275+AM275)","v":0},{"$f":"IF(VLOOKUP(AF275,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF275,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU01945",null,null,"01945 1/4\" (6mm) Carbide Scoring Wheel",null,null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA276,'Price List'!AG276)","v":13.65},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA276*(1-W276)+0.004999,2)","v":13.65},null,"YES",13.65,0,13.65,{"$f":"(AG276-AC276)/AG276","v":0},null,{"$f":"+A276","v":"RU"},{"$f":"SUM(AJ276:AL276)+AE276","v":13.65},null,null,{"$f":"ROUND(AC276/(1-VLOOKUP(AF276,Group,2,FALSE)),2)","v":13.65},{"$f":"IF(VLOOKUP(AF276,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ276,1)-AJ276,2),Round,2,FALSE)+VLOOKUP(AF276,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF276,Group,5,FALSE)=\"\",0,ROUND(AJ276-0.04999,1)-AJ276+AM276)","v":0},{"$f":"IF(VLOOKUP(AF276,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF276,Group,5,FALSE))","v":""},null,"X"]
["RU","Rubi - All Other",null,"RU01946",null,null,"01946 3/8\" (10mm) Carbide Scoring Wheel",null,null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA277,'Price List'!AG277)","v":17.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA277*(1-W277)+0.004999,2)","v":17.7},null,"YES",17.7,0,17.7,{"$f":"(AG277-AC277)/AG277","v":0},null,{"$f":"+A277","v":"RU"},{"$f":"SUM(AJ277:AL277)+AE277","v":17.7},null,null,{"$f":"ROUND(AC277/(1-VLOOKUP(AF277,Group,2,FALSE)),2)","v":17.7},{"$f":"IF(VLOOKUP(AF277,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ277,1)-AJ277,2),Round,2,FALSE)+VLOOKUP(AF277,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF277,Group,5,FALSE)=\"\",0,ROUND(AJ277-0.04999,1)-AJ277+AM277)","v":0},{"$f":"IF(VLOOKUP(AF277,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF277,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTX0710",null,"17910 - TX-710 MAX Rubi Tile Cutter",null,null,null,null,"- 28\" Straight - 20\" Diagonal",null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA279,'Price List'!AG279)","v":725},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA279*(1-W279)+0.004999,2)","v":725},null,"YES",725,{"$f":"+W279","v":0},725,{"$f":"(AG279-AC279)/AG279","v":0},null,{"$f":"+A279","v":"RU1"},{"$f":"SUM(AJ279:AL279)+AE279","v":725},null,null,{"$f":"ROUND(AC279/(1-VLOOKUP(AF279,Group,2,FALSE)),2)","v":725},{"$f":"IF(VLOOKUP(AF279,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ279,1)-AJ279,2),Round,2,FALSE)+VLOOKUP(AF279,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF279,Group,5,FALSE)=\"\",0,ROUND(AJ279-0.04999,1)-AJ279+AM279)","v":0},{"$f":"IF(VLOOKUP(AF279,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF279,Group,5,FALSE))","v":""},null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTX1020",null,"17916 - TX-1020 MAX Rubi Tile Cutter",null,null,null,null,"- 40\" Straight - 28\" Diagonal",null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA280,'Price List'!AG280)","v":765},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA280*(1-W280)+0.004999,2)","v":765},null,"YES",765,0,765,{"$f":"(AG280-AC280)/AG280","v":0},null,{"$f":"+A280","v":"RU1"},{"$f":"SUM(AJ280:AL280)+AE280","v":765},null,null,{"$f":"ROUND(AC280/(1-VLOOKUP(AF280,Group,2,FALSE)),2)","v":765},{"$f":"IF(VLOOKUP(AF280,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ280,1)-AJ280,2),Round,2,FALSE)+VLOOKUP(AF280,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,5,FALSE)=\"\",0,ROUND(AJ280-0.04999,1)-AJ280+AM280)","v":0},{"$f":"IF(VLOOKUP(AF280,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF280,Group,5,FALSE))","v":""},null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTX1250",null,"17922 - TX-1250 MAX Rubi Tile Cutter",null,null,null,null,"- 49\" Straight - 33\" Diagonal",null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA281,'Price List'!AG281)","v":1259},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA281*(1-W281)+0.004999,2)","v":1259},null,"YES",1259,0,1259,{"$f":"(AG281-AC281)/AG281","v":0},null,{"$f":"+A281","v":"RU1"},{"$f":"SUM(AJ281:AL281)+AE281","v":1259},null,null,{"$f":"ROUND(AC281/(1-VLOOKUP(AF281,Group,2,FALSE)),2)","v":1259},{"$f":"IF(VLOOKUP(AF281,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ281,1)-AJ281,2),Round,2,FALSE)+VLOOKUP(AF281,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,5,FALSE)=\"\",0,ROUND(AJ281-0.04999,1)-AJ281+AM281)","v":0},{"$f":"IF(VLOOKUP(AF281,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF281,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTZ0850",null,"17956 - TZ-850 Rubi Tile Cutter",null,null,null,null,"- 33\" Straight - 24\" Diagonal",null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA283,'Price List'!AG283)","v":895},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA283*(1-W283)+0.004999,2)","v":895},null,"YES",895,{"$f":"+W283","v":0},895,{"$f":"(AG283-AC283)/AG283","v":0},null,{"$f":"+A283","v":"RU1"},{"$f":"SUM(AJ283:AL283)+AE283","v":895},null,null,{"$f":"ROUND(AC283/(1-VLOOKUP(AF283,Group,2,FALSE)),2)","v":895},0,0,"",null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTZ1020",null,"17955 - TZ-1020 Rubi Tile Cutter",null,null,null,null,"- 40\" Straight - 28\" Diagonal",null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA284,'Price List'!AG284)","v":935},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},935,null,"YES",935,0,935,0,null,"RU1",935,null,null,935,0,0,"",null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTZ1300",null,"17957 - TZ-1300 Rubi Tile Cutter",null,null,null,null,"- 51\" Straight - 36\" Diagonal",null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA285,'Price List'!AG285)","v":1255},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1255,null,"YES",1255,0,1255,0,null,"RU1",1255,null,null,1255,0,0,"",null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTZ1550",null,"17958 - TZ-1550 Rubi Tile Cutter",null,null,null,null,"- 61\" Straight - 44\" Diagonal",null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA286,'Price List'!AG286)","v":1385},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1385,null,"YES",1385,0,1385,0,null,"RU1",1385,null,null,1385,0,0,"",null,"X"]
["RU","Rubi - All Other",null,"RU01959",null,null,"01959 5/16\" (8mm) Plus Carbide Scoring Wheel",null,null,null,null,null,null,null,"Rubi",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA287,'Price List'!AG287)","v":19.899999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},19.899999999999999,null,"YES",19.899999999999999,{"$f":"+W287","v":0},19.899999999999999,0,null,"RU",19.899999999999999,null,null,19.899999999999999,0,0,"",null,"X"]
["RU","Rubi - All Other",null,"RU01905",null,null,"01905 3/4\" (18mm) Plus Carbide Scoring Wheel",null,null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA288,'Price List'!AG288)","v":29.25},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},29.25,null,"YES",29.25,0,29.25,0,null,"RU",29.25,null,null,29.25,0,0,"",null,"X"]
["RU","Rubi - All Other",null,"RU01900",null,null,"01900 7/8\" (22mm) Extreme Tungsten Carbide Scoring Wheel",null,null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA289,'Price List'!AG289)","v":68.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},68.75,null,"YES",68.75,0,68.75,{"$f":"(AG289-AC289)/AG289","v":0},null,"RU",{"$f":"SUM(AJ289:AL289)+AE289","v":68.75},null,null,{"$f":"ROUND(AC289/(1-VLOOKUP(AF289,Group,2,FALSE)),2)","v":68.75},{"$f":"IF(VLOOKUP(AF289,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ289,1)-AJ289,2),Round,2,FALSE)+VLOOKUP(AF289,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,5,FALSE)=\"\",0,ROUND(AJ289-0.04999,1)-AJ289+AM289)","v":0},{"$f":"IF(VLOOKUP(AF289,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF289,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RS1","Sigma - Saws/Cutters",null,"RSTC2G",null,"2G - Sigma 14\" Pull Handle Tile Cutter",null,null,null,null,"- 14\" Straight - 10\" Diagonal",null,null,null,"Sigma",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA291,'Price List'!AG291)","v":275},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA291*(1-W291)+0.004999,2)","v":275},null,"new",275,{"$f":"+W291","v":0},{"$f":"+X291","v":275},{"$f":"(AG291-AC291)/AG291","v":0},null,{"$f":"+A291","v":"RS1"},{"$f":"SUM(AJ291:AL291)+AE291","v":275},null,null,{"$f":"ROUND(AC291/(1-VLOOKUP(AF291,Group,2,FALSE)),2)","v":275},{"$f":"IF(VLOOKUP(AF291,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ291,1)-AJ291,2),Round,2,FALSE)+VLOOKUP(AF291,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF291,Group,5,FALSE)=\"\",0,ROUND(AJ291-0.04999,1)-AJ291+AM291)","v":0},{"$f":"IF(VLOOKUP(AF291,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF291,Group,5,FALSE))","v":""},null,"X"]
["RS1","Sigma - Saws/Cutters",null,"RSTC3B4",null,"3B4 - Sigma 26\" Pull Handle Tile Cutter",null,null,null,null,"- 26\" Straight - 18\" Diagonal",null,null,null,"Sigma",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA292,'Price List'!AG292)","v":550},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA292*(1-W292)+0.004999,2)","v":550},null,"new",550,{"$f":"+W292","v":0},{"$f":"+X292","v":550},{"$f":"(AG292-AC292)/AG292","v":0},null,"RS1",{"$f":"SUM(AJ292:AL292)+AE292","v":550},null,null,{"$f":"ROUND(AC292/(1-VLOOKUP(AF292,Group,2,FALSE)),2)","v":550},{"$f":"IF(VLOOKUP(AF292,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ292,1)-AJ292,2),Round,2,FALSE)+VLOOKUP(AF292,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF292,Group,5,FALSE)=\"\",0,ROUND(AJ292-0.04999,1)-AJ292+AM292)","v":0},{"$f":"IF(VLOOKUP(AF292,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF292,Group,5,FALSE))","v":""},null,"X"]
["RS1","Sigma - Saws/Cutters",null,"RSTC3D4",null,"3D4 - Sigma 36\" Pull Handle Tile Cutter",null,null,null,null,"- 36\" Straight - 26\" Diagonal",null,null,null,"Sigma",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA293,'Price List'!AG293)","v":745},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},745,null,"new",745,0,745,0,null,"RS1",745,null,null,745,0,0,"",null,"X"]
["RS","Sigma - All Other",null,"RSTC14A",null,null,"14A (12mm) Tile Cutter Wheel for 3B4 & 3D4",null,null,null,null,null,null,null,"Sigma",null,"Stock","New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA294,'Price List'!AG294)","v":24.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA294*(1-W294)+0.004999,2)","v":24.8},null,"new",24.8,{"$f":"+W294","v":0},{"$f":"+X294","v":24.8},{"$f":"(AG294-AC294)/AG294","v":0},null,"RS",{"$f":"SUM(AJ294:AL294)+AE294","v":24.8},null,null,24.8,0,0,"",null,"X"]
["RS1","Sigma - Saws/Cutters",null,"RSTC3D4M",null,"3D4M - Sigma 36\" Push Handle Tile Cutter",null,null,null,null,"- 36\" Straight - 26\" Diagonal",null,null,null,"Sigma",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA295,'Price List'!AG295)","v":810},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},810,null,"new",810,0,810,0,null,"RS1",810,null,null,810,0,0,"",null,"X"]
["RS1","Sigma - Saws/Cutters",null,"RSTC3E4M",null,"3E4M - Sigma 51\" Push Handle Tile Cutter",null,null,null,null,"- 51\" Straight - 35\" Diagonal",null,null,null,"Sigma",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA296,'Price List'!AG296)","v":1215},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},1215,null,"new",1215,{"$f":"+W296","v":0},{"$f":"+X296","v":1215},{"$f":"(AG296-AC296)/AG296","v":0},null,"RS1",{"$f":"SUM(AJ296:AL296)+AE296","v":1215},null,null,1215,0,0,"",null,"X"]
["RS","Sigma - All Other",null,"RSTC14MX",null,null,"14MX (19mm) Tile Cutter Wheel for 3D4M and 3E4M",null,null,null,null,null,null,null,"Sigma",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA297,'Price List'!AG297)","v":52.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},52.95,null,"new",52.95,0,52.95,0,null,"RS",52.95,null,null,52.95,0,0,"",null,"X"]
[]
[null,null,"Marble Polishing Tools",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR72563",null,"72563 Alpha 4\" Quick Change Adapter (PVA-58P)",null,null,null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA301,'Price List'!AG301)","v":79.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA301*(1-W301)+0.004999,2)","v":79.55},null,"YES",79.55,{"$f":"+W301","v":0},{"$f":"+X301","v":79.55},{"$f":"(AG301-AC301)/AG301","v":0},null,{"$f":"+A301","v":"PR"},{"$f":"SUM(AJ301:AL301)+AE301","v":79.55},null,null,{"$f":"ROUND(AC301/(1-VLOOKUP(AF301,Group,2,FALSE)),2)","v":79.55},{"$f":"IF(VLOOKUP(AF301,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ301,1)-AJ301,2),Round,2,FALSE)+VLOOKUP(AF301,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,5,FALSE)=\"\",0,ROUND(AJ301-0.04999,1)-AJ301+AM301)","v":0},{"$f":"IF(VLOOKUP(AF301,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF301,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR72562",null,null,"72562 Alpha 4\" Quick Change Pads - Kit consists of all 5 polishers",null,null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA302,'Price List'!AG302)","v":64.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA302*(1-W302)+0.004999,2)","v":64.3},null,"YES",64.3,{"$f":"+W302","v":0},{"$f":"+X302","v":64.3},{"$f":"(AG302-AC302)/AG302","v":0},null,{"$f":"+A302","v":"PR"},{"$f":"SUM(AJ302:AL302)+AE302","v":64.3},null,null,{"$f":"ROUND(AC302/(1-VLOOKUP(AF302,Group,2,FALSE)),2)","v":64.3},{"$f":"IF(VLOOKUP(AF302,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ302,1)-AJ302,2),Round,2,FALSE)+VLOOKUP(AF302,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF302,Group,5,FALSE)=\"\",0,ROUND(AJ302-0.04999,1)-AJ302+AM302)","v":0},{"$f":"IF(VLOOKUP(AF302,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF302,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Other Cutting Tools & Markers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Hole Saws & Diamond Drill Bits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR70470",null,70470,"1/8\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA307,'Price List'!AG307)","v":10.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA307*(1-W307)+0.004999,2)","v":10.55},null,"YES",10.55,{"$f":"+W307","v":0},10.55,{"$f":"(AG307-AC307)/AG307","v":0},null,{"$f":"+A307","v":"PR"},{"$f":"SUM(AJ307:AL307)+AE307","v":10.55},null,null,{"$f":"ROUND(AC307/(1-VLOOKUP(AF307,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF307,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ307,1)-AJ307,2),Round,2,FALSE)+VLOOKUP(AF307,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,5,FALSE)=\"\",0,ROUND(AJ307-0.04999,1)-AJ307+AM307)","v":0},{"$f":"IF(VLOOKUP(AF307,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF307,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70471",null,70471,"3/16\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA308,'Price List'!AG308)","v":11.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},11.3,null,"YES",11.3,0,11.3,0,null,{"$f":"+A308","v":"PR"},11.3,null,null,11.3,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70472",null,70472,"1/4\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA309,'Price List'!AG309)","v":12.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},12.55,null,"YES",12.55,0,12.55,0,null,{"$f":"+A309","v":"PR"},12.55,null,null,12.55,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70473",null,70473,"5/16\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA310,'Price List'!AG310)","v":15.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},15.45,null,"YES",15.45,0,15.45,0,null,{"$f":"+A310","v":"PR"},15.45,null,null,15.45,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR70474",null,70474,"3/8\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA312,'Price List'!AG312)","v":18.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},18.05,null,"YES",18.05,0,18.05,0,null,{"$f":"+A312","v":"PR"},18.05,null,null,18.05,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70475",null,70475,"1/2\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA313,'Price List'!AG313)","v":22.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},22.95,null,"YES",22.95,0,22.95,0,null,{"$f":"+A313","v":"PR"},22.95,null,null,22.95,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70476",null,70476,"5/8\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA314,'Price List'!AG314)","v":25.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},25.7,null,"YES",25.7,0,25.7,0,null,{"$f":"+A314","v":"PR"},25.7,null,null,25.7,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70477",null,70477,"3/4\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA315,'Price List'!AG315)","v":28.95},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA315*(1-W315)+0.004999,2)","v":28.95},null,"YES",28.95,{"$f":"+W315","v":0},{"$f":"+X315","v":28.95},{"$f":"(AG315-AC315)/AG315","v":0},null,{"$f":"+A315","v":"PR"},{"$f":"SUM(AJ315:AL315)+AE315","v":28.95},null,null,{"$f":"ROUND(AC315/(1-VLOOKUP(AF315,Group,2,FALSE)),2)","v":28.95},0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70478",null,70478,"7/8\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA316,'Price List'!AG316)","v":31.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},31.85,null,"YES",31.85,0,31.85,0,null,{"$f":"+A316","v":"PR"},31.85,null,null,31.85,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR70479",null,70479,"1\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA318,'Price List'!AG318)","v":33.549999999999997},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},33.549999999999997,null,"YES",33.549999999999997,0,33.549999999999997,0,null,{"$f":"+A318","v":"PR"},33.549999999999997,null,null,33.549999999999997,{"$f":"IF(VLOOKUP(AF318,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ318,1)-AJ318,2),Round,2,FALSE)+VLOOKUP(AF318,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,5,FALSE)=\"\",0,ROUND(AJ318-0.04999,1)-AJ318+AM318)","v":0},{"$f":"IF(VLOOKUP(AF318,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF318,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70480",null,70480,"1-1/8\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA319,'Price List'!AG319)","v":36.15},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},36.15,null,"YES",36.15,0,36.15,0,null,"PR",36.15,null,null,36.15,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70481",null,70481,"1-1/4\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA320,'Price List'!AG320)","v":37.799999999999997},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},37.799999999999997,null,"YES",37.799999999999997,0,37.799999999999997,0,null,"PR",37.799999999999997,null,null,37.799999999999997,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70482",null,70482,"1-3/8\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA321,'Price List'!AG321)","v":41.65},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},41.65,null,"YES",41.65,0,41.65,0,null,"PR",41.65,null,null,41.65,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70483",null,70483,"1-1/2\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA322,'Price List'!AG322)","v":45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},45,null,"YES",45,0,45,0,null,"PR",45,null,null,45,0,0,"",null,"X"]
["PR","Barwalt - All Other",null,"PR70484",null,70484,"1-3/4\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA323,'Price List'!AG323)","v":48.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},48.1,null,"YES",48.1,0,48.1,0,null,"PR",48.1,null,null,48.1,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR70485",null,70485,"2\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA325,'Price List'!AG325)","v":52.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},52.7,null,"YES",52.7,0,52.7,0,null,{"$f":"+A325","v":"PR"},52.7,null,null,52.7,{"$f":"IF(VLOOKUP(AF325,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ325,1)-AJ325,2),Round,2,FALSE)+VLOOKUP(AF325,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,5,FALSE)=\"\",0,ROUND(AJ325-0.04999,1)-AJ325+AM325)","v":0},{"$f":"IF(VLOOKUP(AF325,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF325,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70486",null,70486,"2-1/4\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA326,'Price List'!AG326)","v":60.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},60.8,null,"YES",60.8,0,60.8,0,null,{"$f":"+A326","v":"PR"},60.8,null,null,60.8,{"$f":"IF(VLOOKUP(AF326,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ326,1)-AJ326,2),Round,2,FALSE)+VLOOKUP(AF326,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,5,FALSE)=\"\",0,ROUND(AJ326-0.04999,1)-AJ326+AM326)","v":0},{"$f":"IF(VLOOKUP(AF326,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF326,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70487",null,70487,"2-1/2\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA327,'Price List'!AG327)","v":66.650000000000006},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},66.650000000000006,null,"YES",66.650000000000006,0,66.650000000000006,0,null,{"$f":"+A327","v":"PR"},66.650000000000006,null,null,66.650000000000006,{"$f":"IF(VLOOKUP(AF327,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ327,1)-AJ327,2),Round,2,FALSE)+VLOOKUP(AF327,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF327,Group,5,FALSE)=\"\",0,ROUND(AJ327-0.04999,1)-AJ327+AM327)","v":0},{"$f":"IF(VLOOKUP(AF327,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF327,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70488",null,70488,"2-3/4\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA328,'Price List'!AG328)","v":75.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},75.05,null,"YES",75.05,0,75.05,0,null,{"$f":"+A328","v":"PR"},75.05,null,null,75.05,{"$f":"IF(VLOOKUP(AF328,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ328,1)-AJ328,2),Round,2,FALSE)+VLOOKUP(AF328,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF328,Group,5,FALSE)=\"\",0,ROUND(AJ328-0.04999,1)-AJ328+AM328)","v":0},{"$f":"IF(VLOOKUP(AF328,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF328,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70489",null,70489,"3\"","Diamond Sure Bit for Porcelain Tile",null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA329,'Price List'!AG329)","v":84.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},84.85,null,"YES",84.85,0,84.85,0,null,{"$f":"+A329","v":"PR"},84.85,null,null,84.85,{"$f":"IF(VLOOKUP(AF329,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ329,1)-AJ329,2),Round,2,FALSE)+VLOOKUP(AF329,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF329,Group,5,FALSE)=\"\",0,ROUND(AJ329-0.04999,1)-AJ329+AM329)","v":0},{"$f":"IF(VLOOKUP(AF329,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF329,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Nippers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU","Rubi - All Other",null,"RU83942",null,"83942 Nippers for Porcelain and Glass Tiles",null,null,null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA332,'Price List'!AG332)","v":58.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA332*(1-W332)+0.004999,2)","v":58.5},null,"YES",58.5,{"$f":"+W332","v":0},{"$f":"+X332","v":58.5},{"$f":"(AG332-AC332)/AG332","v":0},null,{"$f":"+A332","v":"RU"},{"$f":"SUM(AJ332:AL332)+AE332","v":58.5},null,null,{"$f":"ROUND(AC332/(1-VLOOKUP(AF332,Group,2,FALSE)),2)","v":58.5},{"$f":"IF(VLOOKUP(AF332,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ332,1)-AJ332,2),Round,2,FALSE)+VLOOKUP(AF332,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF332,Group,5,FALSE)=\"\",0,ROUND(AJ332-0.04999,1)-AJ332+AM332)","v":0},{"$f":"IF(VLOOKUP(AF332,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF332,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Rub Stones / Dressing Sticks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["IQ","IQ Tools - All Other",null,"IQIQPDS00100",null,null,"iQPDS00100 8\" Professional Dressing Stone",null,null,null,null,null,null,null,"IQ Tools",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA335,'Price List'!AG335)","v":15.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA335*(1-W335)+0.004999,2)","v":15.1},null,"YES",15.1,{"$f":"+W335","v":0},{"$f":"+X335","v":15.1},{"$f":"(AG335-AC335)/AG335","v":0},null,{"$f":"+A335","v":"IQ"},{"$f":"SUM(AJ335:AL335)+AE335","v":15.1},null,null,{"$f":"ROUND(AC335/(1-VLOOKUP(AF335,Group,2,FALSE)),2)","v":15.1},{"$f":"IF(VLOOKUP(AF335,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ335,1)-AJ335,2),Round,2,FALSE)+VLOOKUP(AF335,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF335,Group,5,FALSE)=\"\",0,ROUND(AJ335-0.04999,1)-AJ335+AM335)","v":0},{"$f":"IF(VLOOKUP(AF335,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF335,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Mixers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PRMX1",null,"82000 MX-1 Kwik-Mixer Blade",null,null,null,null,"- Double Box - Round",null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA339,'Price List'!AG339)","v":15.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},15.85,null,"YES",15.85,0,15.85,0,null,{"$f":"+A339","v":"PR"},15.85,null,null,15.85,{"$f":"IF(VLOOKUP(AF339,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ339,1)-AJ339,2),Round,2,FALSE)+VLOOKUP(AF339,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF339,Group,5,FALSE)=\"\",0,ROUND(AJ339-0.04999,1)-AJ339+AM339)","v":0},{"$f":"IF(VLOOKUP(AF339,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF339,Group,5,FALSE))","v":""},null,"X"]
["TR","Troxell - All Other",null,"TX07366",null,"07-366 28\" Cheater Beater",null,null,null,null,"- Double Box - Round",null,null,null,"Troxell",null,null,"New",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA340,'Price List'!AG340)","v":15.9},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA340*(1-W340)+0.004999,2)","v":15.9},null,"new",15.9,{"$f":"+W340","v":0},{"$f":"+X340","v":15.9},{"$f":"(AG340-AC340)/AG340","v":0},null,{"$f":"+A340","v":"TR"},{"$f":"SUM(AJ340:AL340)+AE340","v":15.9},null,null,{"$f":"ROUND(AC340/(1-VLOOKUP(AF340,Group,2,FALSE)),2)","v":15.9},{"$f":"IF(VLOOKUP(AF340,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ340,1)-AJ340,2),Round,2,FALSE)+VLOOKUP(AF340,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF340,Group,5,FALSE)=\"\",0,ROUND(AJ340-0.04999,1)-AJ340+AM340)","v":0},{"$f":"IF(VLOOKUP(AF340,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF340,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Water Heaters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"PR71340",null,"71340 Bucket Water Heater",null,null,null,null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA344,'Price List'!AG344)","v":86.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},86.55,null,"YES",86.55,0,86.55,0,null,{"$f":"+A344","v":"PR"},86.55,null,null,86.55,{"$f":"IF(VLOOKUP(AF344,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ344,1)-AJ344,2),Round,2,FALSE)+VLOOKUP(AF344,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,5,FALSE)=\"\",0,ROUND(AJ344-0.04999,1)-AJ344+AM344)","v":0},{"$f":"IF(VLOOKUP(AF344,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF344,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Miscellaneous Tools",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"MIQPK101KIT",null,"Pitch",null,null,"71512 Quick-Pitch Kit (Mark E Industries)",null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA348,'Price List'!AG348)","v":40.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},40.85,null,"YES",40.85,0,40.85,0,null,{"$f":"+A348","v":"PR"},40.85,null,null,40.85,{"$f":"IF(VLOOKUP(AF348,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ348,1)-AJ348,2),Round,2,FALSE)+VLOOKUP(AF348,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF348,Group,5,FALSE)=\"\",0,ROUND(AJ348-0.04999,1)-AJ348+AM348)","v":0},{"$f":"IF(VLOOKUP(AF348,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF348,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null," - kit contains: 6-float sticks 1\" to 1-3/4\" x 36\" length and center ring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["PR","Barwalt - All Other",null,"MIEFS103",null,"Pitch",null,null,"71514 Quick Pitch Extended Float Stick Kit",null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA350,'Price List'!AG350)","v":29.4},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA350*(1-W350)+0.004999,2)","v":29.4},null,"YES",29.4,{"$f":"+W350","v":0},29.4,{"$f":"(AG350-AC350)/AG350","v":0},null,{"$f":"+A350","v":"PR"},{"$f":"SUM(AJ350:AL350)+AE350","v":29.4},null,null,{"$f":"ROUND(AC350/(1-VLOOKUP(AF350,Group,2,FALSE)),2)","v":29.4},{"$f":"IF(VLOOKUP(AF350,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ350,1)-AJ350,2),Round,2,FALSE)+VLOOKUP(AF350,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF350,Group,5,FALSE)=\"\",0,ROUND(AJ350-0.04999,1)-AJ350+AM350)","v":0},{"$f":"IF(VLOOKUP(AF350,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF350,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR73302",null,"Suction Cup",null,null,"73302 - 2 Cup Aluminum Vacuum Lifter",null,null,null,null,null,"Barwalt",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA351,'Price List'!AG351)","v":20.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA351*(1-W351)+0.004999,2)","v":20.85},null,"YES",20.85,0,20.85,{"$f":"(AG351-AC351)/AG351","v":0},null,{"$f":"+A351","v":"PR"},{"$f":"SUM(AJ351:AL351)+AE351","v":20.85},null,null,{"$f":"ROUND(AC351/(1-VLOOKUP(AF351,Group,2,FALSE)),2)","v":20.85},{"$f":"IF(VLOOKUP(AF351,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ351,1)-AJ351,2),Round,2,FALSE)+VLOOKUP(AF351,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF351,Group,5,FALSE)=\"\",0,ROUND(AJ351-0.04999,1)-AJ351+AM351)","v":0},{"$f":"IF(VLOOKUP(AF351,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF351,Group,5,FALSE))","v":""},null,"X"]
["PR","Barwalt - All Other",null,"PR70800",null,"Suction Cup",null,null,"70800 - Single Cup Aluminum Vacuum Lifter",null,null,null,null,null,"Barwalt",null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA352,'Price List'!AG352)","v":10.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA352*(1-W352)+0.004999,2)","v":10.5},null,"YES",10.5,0,10.5,{"$f":"(AG352-AC352)/AG352","v":0},null,{"$f":"+A352","v":"PR"},{"$f":"SUM(AJ352:AL352)+AE352","v":10.5},null,null,{"$f":"ROUND(AC352/(1-VLOOKUP(AF352,Group,2,FALSE)),2)","v":10.5},{"$f":"IF(VLOOKUP(AF352,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ352,1)-AJ352,2),Round,2,FALSE)+VLOOKUP(AF352,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,5,FALSE)=\"\",0,ROUND(AJ352-0.04999,1)-AJ352+AM352)","v":0},{"$f":"IF(VLOOKUP(AF352,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF352,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[]
[null,null,"SEE NEXT PAGE FOR GAUGED TILES/PANELS TOOLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gauged Tiles/Panels Tools",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Handling & Transport Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Handling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET1","ETM - HP",null,"ETETMGRIP3GEN",null,"ETM-GRIP3: 2' x 10' Adjustable Frame w/ 12 Suction Cups",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA363,'Price List'!AG363)","v":2605.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA363*(1-W363)+0.004999,2)","v":2605.75},null,"YES",2605.75,{"$f":"+W363","v":0},2605.75,{"$f":"(AG363-AC363)/AG363","v":0},null,{"$f":"+A363","v":"ET1"},{"$f":"SUM(AJ363:AL363)+AE363","v":2605.75},null,null,{"$f":"ROUND(AC363/(1-VLOOKUP(AF363,Group,2,FALSE)),2)","v":2605.75},{"$f":"IF(VLOOKUP(AF363,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ363,1)-AJ363,2),Round,2,FALSE)+VLOOKUP(AF363,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF363,Group,5,FALSE)=\"\",0,ROUND(AJ363-0.04999,1)-AJ363+AM363)","v":0},{"$f":"IF(VLOOKUP(AF363,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF363,Group,5,FALSE))","v":""},null,"X"]
["ET1","ETM - HP",null,"ETETMSLIDE2GEN",null,"ETM-SLIDE2: 2-10' Adjustable Spines, 2-2' Spines, and 2 Suction Cups",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA364,'Price List'!AG364)","v":1306.4000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA364*(1-W364)+0.004999,2)","v":1306.4000000000001},null,"YES",1306.4000000000001,0,1306.4000000000001,{"$f":"(AG364-AC364)/AG364","v":0},null,{"$f":"+A364","v":"ET1"},{"$f":"SUM(AJ364:AL364)+AE364","v":1306.4000000000001},null,null,{"$f":"ROUND(AC364/(1-VLOOKUP(AF364,Group,2,FALSE)),2)","v":1306.4000000000001},{"$f":"IF(VLOOKUP(AF364,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ364,1)-AJ364,2),Round,2,FALSE)+VLOOKUP(AF364,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF364,Group,5,FALSE)=\"\",0,ROUND(AJ364-0.04999,1)-AJ364+AM364)","v":0},{"$f":"IF(VLOOKUP(AF364,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF364,Group,5,FALSE))","v":""},null,"X"]
["ET1","ETM - HP",null,"ETETMSPINE",null,"ETM-SPINE: 2-2' Spines with 2 Suction Cups",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA365,'Price List'!AG365)","v":290.10000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA365*(1-W365)+0.004999,2)","v":290.10000000000002},null,"YES",290.10000000000002,0,290.10000000000002,{"$f":"(AG365-AC365)/AG365","v":0},null,{"$f":"+A365","v":"ET1"},{"$f":"SUM(AJ365:AL365)+AE365","v":290.10000000000002},null,null,{"$f":"ROUND(AC365/(1-VLOOKUP(AF365,Group,2,FALSE)),2)","v":290.10000000000002},{"$f":"IF(VLOOKUP(AF365,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ365,1)-AJ365,2),Round,2,FALSE)+VLOOKUP(AF365,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF365,Group,5,FALSE)=\"\",0,ROUND(AJ365-0.04999,1)-AJ365+AM365)","v":0},{"$f":"IF(VLOOKUP(AF365,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF365,Group,5,FALSE))","v":""},null,"X"]
["ET","ETM - All Other",null,"ET51B",null,"Aluminum Suction Cup for EURO-GRIP, EURO-SLIDE, EURO-SPINE",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA366,'Price List'!AG366)","v":31.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA366*(1-W366)+0.004999,2)","v":31.05},null,"YES",31.05,0,31.05,{"$f":"(AG366-AC366)/AG366","v":0},null,{"$f":"+A366","v":"ET"},{"$f":"SUM(AJ366:AL366)+AE366","v":31.05},null,null,{"$f":"ROUND(AC366/(1-VLOOKUP(AF366,Group,2,FALSE)),2)","v":31.05},{"$f":"IF(VLOOKUP(AF366,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ366,1)-AJ366,2),Round,2,FALSE)+VLOOKUP(AF366,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF366,Group,5,FALSE)=\"\",0,ROUND(AJ366-0.04999,1)-AJ366+AM366)","v":0},{"$f":"IF(VLOOKUP(AF366,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF366,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Transport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET1","ETM - HP",null,"ETETRANS",null,"ETM-TRANSPORTER: - holds 8 6mm pieces or 16 3mm pieces",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA369,'Price List'!AG369)","v":2555},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA369*(1-W369)+0.004999,2)","v":2555},null,"YES",2555,{"$f":"+W369","v":0},{"$f":"+X369","v":2555},{"$f":"(AG369-AC369)/AG369","v":0},null,{"$f":"+A369","v":"ET1"},{"$f":"SUM(AJ369:AL369)+AE369","v":2555},null,null,{"$f":"ROUND(AC369/(1-VLOOKUP(AF369,Group,2,FALSE)),2)","v":2555},{"$f":"IF(VLOOKUP(AF369,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ369,1)-AJ369,2),Round,2,FALSE)+VLOOKUP(AF369,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF369,Group,5,FALSE)=\"\",0,ROUND(AJ369-0.04999,1)-AJ369+AM369)","v":0},{"$f":"IF(VLOOKUP(AF369,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF369,Group,5,FALSE))","v":""},null,"X"]
["ET1","ETM - HP",null,"ETEAFRM",null,"ETM-A-FRAME: holder or transporter",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA370,'Price List'!AG370)","v":1317.55},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA370*(1-W370)+0.004999,2)","v":1317.55},null,"YES",1317.55,{"$f":"+W370","v":0},{"$f":"+X370","v":1317.55},{"$f":"(AG370-AC370)/AG370","v":0},null,{"$f":"+A370","v":"ET1"},{"$f":"SUM(AJ370:AL370)+AE370","v":1317.55},null,null,{"$f":"ROUND(AC370/(1-VLOOKUP(AF370,Group,2,FALSE)),2)","v":1317.55},{"$f":"IF(VLOOKUP(AF370,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ370,1)-AJ370,2),Round,2,FALSE)+VLOOKUP(AF370,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF370,Group,5,FALSE)=\"\",0,ROUND(AJ370-0.04999,1)-AJ370+AM370)","v":0},{"$f":"IF(VLOOKUP(AF370,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF370,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Cutting Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET1","ETM - HP",null,"ETETABLE3",null,"ETM-TABLE3: 2 Connectable 39\" x 72\" Tables with Adjustable X-Bars",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA373,'Price List'!AG373)","v":3386.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA373*(1-W373)+0.004999,2)","v":3386.8},null,"YES",3386.8,{"$f":"+W373","v":0},{"$f":"+X373","v":3386.8},{"$f":"(AG373-AC373)/AG373","v":0},null,{"$f":"+A373","v":"ET1"},{"$f":"SUM(AJ373:AL373)+AE373","v":3386.8},null,null,{"$f":"ROUND(AC373/(1-VLOOKUP(AF373,Group,2,FALSE)),2)","v":3386.8},{"$f":"IF(VLOOKUP(AF373,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ373,1)-AJ373,2),Round,2,FALSE)+VLOOKUP(AF373,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF373,Group,5,FALSE)=\"\",0,ROUND(AJ373-0.04999,1)-AJ373+AM373)","v":0},{"$f":"IF(VLOOKUP(AF373,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF373,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Tile Cutters & Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Rail Cutters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET1","ETM - HP",null,"ETETMRAIL3GEN",null,"ETM-RAIL CUTTER: 2-6' Connectable Rails with Cutter Head,",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA378,'Price List'!AG378)","v":2149.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA378*(1-W378)+0.004999,2)","v":2149.35},null,"YES",2149.35,{"$f":"+W378","v":0},{"$f":"+X378","v":2149.35},{"$f":"(AG378-AC378)/AG378","v":0},null,{"$f":"+A378","v":"ET1"},{"$f":"SUM(AJ378:AL378)+AE378","v":2149.35},null,null,{"$f":"ROUND(AC378/(1-VLOOKUP(AF378,Group,2,FALSE)),2)","v":2149.35},{"$f":"IF(VLOOKUP(AF378,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ378,1)-AJ378,2),Round,2,FALSE)+VLOOKUP(AF378,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF378,Group,5,FALSE)=\"\",0,ROUND(AJ378-0.04999,1)-AJ378+AM378)","v":0},{"$f":"IF(VLOOKUP(AF378,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF378,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,"Pressure Pliers, 3 Suction Cups and 2 Specialized Measuring tapes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTC125",null,"51957","TC125 Circular Saw (120V, 60Hz)",null,null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA380,'Price List'!AG380)","v":315},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA380*(1-W380)+0.004999,2)","v":315},null,"YES",315,{"$f":"+W380","v":0},{"$f":"+X380","v":315},{"$f":"(AG380-AC380)/AG380","v":0},null,{"$f":"+A380","v":"RU1"},{"$f":"SUM(AJ380:AL380)+AE380","v":315},null,null,{"$f":"ROUND(AC380/(1-VLOOKUP(AF380,Group,2,FALSE)),2)","v":315},{"$f":"IF(VLOOKUP(AF380,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ380,1)-AJ380,2),Round,2,FALSE)+VLOOKUP(AF380,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF380,Group,5,FALSE)=\"\",0,ROUND(AJ380-0.04999,1)-AJ380+AM380)","v":0},{"$f":"IF(VLOOKUP(AF380,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF380,Group,5,FALSE))","v":""},null,"X"]
["RU1","Rubi - Saws/Cutters",null,"RUTC125KIT",null,"51903","TC125 Circular Saw Kit",null,null,null,null,null,null,null,"Rubi",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA381,'Price List'!AG381)","v":629},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA381*(1-W381)+0.004999,2)","v":629},null,"YES",629,{"$f":"+W381","v":0},{"$f":"+X381","v":629},{"$f":"(AG381-AC381)/AG381","v":0},null,{"$f":"+A381","v":"RU1"},{"$f":"SUM(AJ381:AL381)+AE381","v":629},null,null,{"$f":"ROUND(AC381/(1-VLOOKUP(AF381,Group,2,FALSE)),2)","v":629},{"$f":"IF(VLOOKUP(AF381,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ381,1)-AJ381,2),Round,2,FALSE)+VLOOKUP(AF381,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF381,Group,5,FALSE)=\"\",0,ROUND(AJ381-0.04999,1)-AJ381+AM381)","v":0},{"$f":"IF(VLOOKUP(AF381,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF381,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,"- Kit includes TC125 circular saw, 3 rails, 2 suction cups to place rails to tile panel, case and bag"]
[null,null,null,null,"- Rails allow for straight cuts up to 126\" - Great for Gauged Panel Tiles"]
[null,null,null,null,"- Compatible with both 4-1/2\" and 5\" saw blades, wet or dry cut"]
[null,null,null,null,"- Able to do plunge and mitre cuts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Express Cutters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET1","ETM - HP",null,"ETEEXPRESS",null,"ETM-EXPRESS CUTTER",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA388,'Price List'!AG388)","v":648.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA388*(1-W388)+0.004999,2)","v":648.1},null,"YES",648.1,{"$f":"+W388","v":0},{"$f":"+X388","v":648.1},{"$f":"(AG388-AC388)/AG388","v":0},null,{"$f":"+A388","v":"ET1"},{"$f":"SUM(AJ388:AL388)+AE388","v":648.1},null,null,{"$f":"ROUND(AC388/(1-VLOOKUP(AF388,Group,2,FALSE)),2)","v":648.1},{"$f":"IF(VLOOKUP(AF388,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ388,1)-AJ388,2),Round,2,FALSE)+VLOOKUP(AF388,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF388,Group,5,FALSE)=\"\",0,ROUND(AJ388-0.04999,1)-AJ388+AM388)","v":0},{"$f":"IF(VLOOKUP(AF388,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF388,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Breakers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET","ETM - All Other",null,"ETEZB",null,"ETM EZ BREAKER 3 GEN",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA391,'Price List'!AG391)","v":576.29999999999995},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA391*(1-W391)+0.004999,2)","v":576.29999999999995},null,"YES",576.29999999999995,{"$f":"+W391","v":0},576.29999999999995,{"$f":"(AG391-AC391)/AG391","v":0},null,{"$f":"+A391","v":"ET"},{"$f":"SUM(AJ391:AL391)+AE391","v":576.29999999999995},null,null,{"$f":"ROUND(AC391/(1-VLOOKUP(AF391,Group,2,FALSE)),2)","v":576.29999999999995},{"$f":"IF(VLOOKUP(AF391,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ391,1)-AJ391,2),Round,2,FALSE)+VLOOKUP(AF391,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF391,Group,5,FALSE)=\"\",0,ROUND(AJ391-0.04999,1)-AJ391+AM391)","v":0},{"$f":"IF(VLOOKUP(AF391,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF391,Group,5,FALSE))","v":""},null,"X"]
["ET","ETM - All Other",null,"ET41C",null,"Pressure Pliers: for breaking up to 4mm tiles",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA392,'Price List'!AG392)","v":26.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA392*(1-W392)+0.004999,2)","v":26.8},null,"YES",26.8,0,26.8,{"$f":"(AG392-AC392)/AG392","v":0},null,{"$f":"+A392","v":"ET"},{"$f":"SUM(AJ392:AL392)+AE392","v":26.8},null,null,{"$f":"ROUND(AC392/(1-VLOOKUP(AF392,Group,2,FALSE)),2)","v":26.8},{"$f":"IF(VLOOKUP(AF392,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ392,1)-AJ392,2),Round,2,FALSE)+VLOOKUP(AF392,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF392,Group,5,FALSE)=\"\",0,ROUND(AJ392-0.04999,1)-AJ392+AM392)","v":0},{"$f":"IF(VLOOKUP(AF392,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF392,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Scoring Wheels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET","ETM - All Other",null,"ET14G",null,"12mm KERA & EURO Cutters Scoring Wheel",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA395,'Price List'!AG395)","v":33.200000000000003},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA395*(1-W395)+0.004999,2)","v":33.200000000000003},null,"YES",33.200000000000003,{"$f":"+W395","v":0},{"$f":"+X395","v":33.200000000000003},{"$f":"(AG395-AC395)/AG395","v":0},null,{"$f":"+A395","v":"ET"},{"$f":"SUM(AJ395:AL395)+AE395","v":33.200000000000003},null,null,{"$f":"ROUND(AC395/(1-VLOOKUP(AF395,Group,2,FALSE)),2)","v":33.200000000000003},{"$f":"IF(VLOOKUP(AF395,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ395,1)-AJ395,2),Round,2,FALSE)+VLOOKUP(AF395,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF395,Group,5,FALSE)=\"\",0,ROUND(AJ395-0.04999,1)-AJ395+AM395)","v":0},{"$f":"IF(VLOOKUP(AF395,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF395,Group,5,FALSE))","v":""},null,"X"]
["ET","ETM - All Other",null,"ET14MK",null,"19mm KERA & EURO Cutters Scoring Wheel",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA396,'Price List'!AG396)","v":49.3},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA396*(1-W396)+0.004999,2)","v":49.3},null,"YES",49.3,{"$f":"+W396","v":0},{"$f":"+X396","v":49.3},{"$f":"(AG396-AC396)/AG396","v":0},null,{"$f":"+A396","v":"ET"},{"$f":"SUM(AJ396:AL396)+AE396","v":49.3},null,null,{"$f":"ROUND(AC396/(1-VLOOKUP(AF396,Group,2,FALSE)),2)","v":49.3},{"$f":"IF(VLOOKUP(AF396,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ396,1)-AJ396,2),Round,2,FALSE)+VLOOKUP(AF396,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF396,Group,5,FALSE)=\"\",0,ROUND(AJ396-0.04999,1)-AJ396+AM396)","v":0},{"$f":"IF(VLOOKUP(AF396,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF396,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET","ETM - All Other",null,"ET51C",null,"Suction Cups for KERA-CUT",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA399,'Price List'!AG399)","v":69.650000000000006},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA399*(1-W399)+0.004999,2)","v":69.650000000000006},null,"YES",69.650000000000006,{"$f":"+W399","v":0},{"$f":"+X399","v":69.650000000000006},{"$f":"(AG399-AC399)/AG399","v":0},null,{"$f":"+A399","v":"ET"},{"$f":"SUM(AJ399:AL399)+AE399","v":69.650000000000006},null,null,{"$f":"ROUND(AC399/(1-VLOOKUP(AF399,Group,2,FALSE)),2)","v":69.650000000000006},{"$f":"IF(VLOOKUP(AF399,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ399,1)-AJ399,2),Round,2,FALSE)+VLOOKUP(AF399,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF399,Group,5,FALSE)=\"\",0,ROUND(AJ399-0.04999,1)-AJ399+AM399)","v":0},{"$f":"IF(VLOOKUP(AF399,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF399,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Edge Finishing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Beveling, Mitering & Bullnosing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET1","ETM - HP",null,"ETE36B3",null,"KERA-EDGE KIT: includes 36A KERA-EDGE, Bosch 1380 Slim Grinder,",null,null,null,null,null,null,null,null,"ETM",null,null,"a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA404,'Price List'!AG404)","v":1053.9000000000001},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA404*(1-W404)+0.004999,2)","v":1053.9000000000001},null,"YES",1053.9000000000001,{"$f":"+W404","v":0},{"$f":"+X404","v":1053.9000000000001},{"$f":"(AG404-AC404)/AG404","v":0},null,{"$f":"+A404","v":"ET1"},{"$f":"SUM(AJ404:AL404)+AE404","v":1053.9000000000001},null,null,{"$f":"ROUND(AC404/(1-VLOOKUP(AF404,Group,2,FALSE)),2)","v":1053.9000000000001},{"$f":"IF(VLOOKUP(AF404,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ404,1)-AJ404,2),Round,2,FALSE)+VLOOKUP(AF404,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF404,Group,5,FALSE)=\"\",0,ROUND(AJ404-0.04999,1)-AJ404+AM404)","v":0},{"$f":"IF(VLOOKUP(AF404,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF404,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,"Water Kit, Diamond Cup, Backer Pad, and 4 Diamond Pads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Diamond Sponge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET","ETM - All Other",null,"ETEDSB4",null,"4-Sided Diamond Sponge (60, 200, 400 & 800 grit surfaces)",null,null,null,null,null,null,null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA408,'Price List'!AG408)","v":84.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA408*(1-W408)+0.004999,2)","v":84.75},null,"YES",84.75,{"$f":"+W408","v":0},{"$f":"+X408","v":84.75},{"$f":"(AG408-AC408)/AG408","v":0},null,{"$f":"+A408","v":"ET"},{"$f":"SUM(AJ408:AL408)+AE408","v":84.75},null,null,{"$f":"ROUND(AC408/(1-VLOOKUP(AF408,Group,2,FALSE)),2)","v":84.75},{"$f":"IF(VLOOKUP(AF408,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ408,1)-AJ408,2),Round,2,FALSE)+VLOOKUP(AF408,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF408,Group,5,FALSE)=\"\",0,ROUND(AJ408-0.04999,1)-AJ408+AM408)","v":0},{"$f":"IF(VLOOKUP(AF408,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF408,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Corner Protectors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["ET","ETM - All Other",null,"ETTC6MM",null,"Corner Protectors - fits up to 6mm tiles",null,null,null,null,null,null,null,null,"ETM",null,null,"a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AA412,'Price List'!AG412)","v":6.85},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA412*(1-W412)+0.004999,2)","v":6.85},null,"YES",6.85,{"$f":"+W412","v":0},{"$f":"+X412","v":6.85},{"$f":"(AG412-AC412)/AG412","v":0},null,{"$f":"+A412","v":"ET"},{"$f":"SUM(AJ412:AL412)+AE412","v":6.85},null,null,{"$f":"ROUND(AC412/(1-VLOOKUP(AF412,Group,2,FALSE)),2)","v":6.85},{"$f":"IF(VLOOKUP(AF412,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ412,1)-AJ412,2),Round,2,FALSE)+VLOOKUP(AF412,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF412,Group,5,FALSE)=\"\",0,ROUND(AJ412-0.04999,1)-AJ412+AM412)","v":0},{"$f":"IF(VLOOKUP(AF412,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF412,Group,5,FALSE))","v":""},null,"X"]
["ET","ETM - All Other",null,"ETSTC6MM",null,"GPTP Corner Protectors - fits up to 6mm tiles",null,null,null,null,null,"(Set of 4)",null,null,"ETM",null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA413,'Price List'!AG413)","v":27.45},"SET",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$D$23","v":0},{"$f":"ROUND($AA413*(1-W413)+0.004999,2)","v":27.45},null,"YES",27.45,{"$f":"+W413","v":0},{"$f":"+X413","v":27.45},{"$f":"(AG413-AC413)/AG413","v":0},null,{"$f":"+A413","v":"ET"},{"$f":"SUM(AJ413:AL413)+AE413","v":27.45},null,null,{"$f":"ROUND(AC413/(1-VLOOKUP(AF413,Group,2,FALSE)),2)","v":27.45},{"$f":"IF(VLOOKUP(AF413,Group,3,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ413,1)-AJ413,2),Round,2,FALSE)+VLOOKUP(AF413,Group,4,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF413,Group,5,FALSE)=\"\",0,ROUND(AJ413-0.04999,1)-AJ413+AM413)","v":0},{"$f":"IF(VLOOKUP(AF413,Group,5,FALSE)=\"\",\"\",VLOOKUP(AF413,Group,5,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","a) ETE36B3 and ETTC6MM have been discontinued - check Conestoga Tile for remaining stock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[]
[]
[]
[]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page"]
["Barwalt","www.barwalt.com"]
["European Tile Masters (ETMM)","www.europeantilemasters"]
["IQ Saws","https://iqpowertools.com/"]
["Mark E. Ind.","www.markeindustries.com"]
["MK Diamond","www.mkdiamond.com"]
["Progress Profiles","www.progressprofiles.com"]
["Rubi Tools","www.rubi.com"]
["Sigma (RTC)","www.rtcproducts.com"]
["Troxell Tools","https://troxellusa.com/"]
[]
["Product","Direct Website Link"]

{"sheet":"Updates","index":4,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Price List"]
["Mfg","Date","Description"]
[]
["New Products"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Discontinued Products"]