{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":18,"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":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Kronos"]
["File as","K"]
["Product Code","G"]
["CCTD Effective Date","7/1/23"]
[]
[]
[]
["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,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"G"}]
[]
[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,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,"Import I - Field Tile",null,"No",0]
[null,5,null,"Import I - Trim",null,"No",0]
[null,6,null,"Import I - Decos",null,"No",0]
[null,7,null,{"$error":"#REF!"},null,"No",0]
[null,8,null,{"$error":"#REF!"},null,"No",0]
[null,9,null,{"$error":"#REF!"},null,"No",0,null,null," "]
[]
["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,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":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,0,5,11],[49,0,49,11],[51,0,51,11],[2,6,2,11]]}
[]
[]
[null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'K' - Kronos"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 7/1/23"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,null,"Page",null,"Series",null,"Product Type"]
[1,null,"COTTO",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"CROSS CUT ANDES",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"CROSS CUT TIVOLI",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"ICON TRAVERTINE",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"MONOCROMATICA",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"OCEAN STONE",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"PENNSYLVANIA",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"PRIMA MATERIA",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"QUARTZITE",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"STONE",null,"3/4\" Thick Porcelain Pavers"]
[1,null,"TERRAZZO",null,"3/4\" Thick Porcelain Pavers"]
[2,null,"TEX - WOOD",null,"3/4\" Thick Porcelain Pavers"]
[2,null,"TIMBER - WOOD",null,"3/4\" Thick Porcelain Pavers"]
[2,null,"Trims / Copings (All Colors)"]
[2,null,"Accessories"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
["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":214,"n_cols":41,"rows_kept":214,"cut":false,"hidden":false,"merged":[[8,14,8,19],[8,22,8,23],[8,25,8,32],[11,14,11,19],[13,13,14,19],[12,30,12,32],[11,22,11,23],[9,14,9,15],[203,3,203,4],[17,2,17,19],[16,14,16,15],[199,2,199,18],[198,2,198,19]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0.05},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF1,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA2,AG2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,2,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,3,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"Size",null,"Field",null,"Description",null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,4,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,5,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,6,0.05,null,null,0.05,0,0,"",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,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA10,AG10)","v":"List Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","List Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",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 'K' - Kronos"},null,null,null,null,null,null,null,"Cost",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":"7/1/23"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-06-01"},null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!C8=\"\",\"\",+Instructions!C8)","v":""},null,null,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,{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'G'"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},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,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$10","v":"List Price"},"U/M",{"$f":"+U$10","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$10","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$10","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"ALL ITEMS MARKED WITH PACKAGING QUANTITY ARE SOLD IN MULTIPLES OF THAT QUANTITY ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,null,"COTTO - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null," "," ",null,null,null,null,null,"Item # Lookup:","KRCO",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,"Color:","Cotto",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA24,AG24)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA24*(1-W24)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W24","v":0},{"$f":"+X24","v":12.95},{"$f":"(AG24-AC24)/AG24","v":0},null,1,{"$f":"SUM(AJ24:AL24)+AE24","v":12.95},null,null,{"$f":"ROUND(AC24/(1-VLOOKUP(AF24,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF24,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ24,1)-AJ24,2),Round,2,FALSE)+VLOOKUP(AF24,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF24,Group,7,FALSE)=\"\",0,ROUND(AJ24-0.04999,1)-AJ24+AM24)","v":0},{"$f":"IF(VLOOKUP(AF24,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF24,Group,7,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,"CROSS CUT ANDES - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRCA",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,"Colors:","Cappuccino          Shell          Silver",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":16.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":16.25},null,"new",16.25,{"$f":"+W30","v":0},{"$f":"+X30","v":16.25},{"$f":"(AG30-AC30)/AG30","v":0},null,1,{"$f":"SUM(AJ30:AL30)+AE30","v":16.25},null,null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":16.25},{"$f":"IF(VLOOKUP(AF30,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ30,1)-AJ30,2),Round,2,FALSE)+VLOOKUP(AF30,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",0,ROUND(AJ30-0.04999,1)-AJ30+AM30)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF30,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W31","v":0},{"$f":"+X31","v":13.5},{"$f":"(AG31-AC31)/AG31","v":0},null,1,{"$f":"SUM(AJ31:AL31)+AE31","v":13.5},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ31,1)-AJ31,2),Round,2,FALSE)+VLOOKUP(AF31,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",0,ROUND(AJ31-0.04999,1)-AJ31+AM31)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF31,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W32","v":0},{"$f":"+X32","v":12.95},{"$f":"(AG32-AC32)/AG32","v":0},null,1,{"$f":"SUM(AJ32:AL32)+AE32","v":12.95},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ32,1)-AJ32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",0,ROUND(AJ32-0.04999,1)-AJ32+AM32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF32,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA33,AG33)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},13.55,null,"new",13.55,0,13.55,0,null,1,13.55,null,null,13.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,"CROSS CUT TIVOLI - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRCT",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,"Colors:","Avorio          Crema          Walnut",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA39,AG39)","v":16.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA39*(1-W39)+0.004999,2)","v":16.25},null,"new",16.25,{"$f":"+W39","v":0},{"$f":"+X39","v":16.25},{"$f":"(AG39-AC39)/AG39","v":0},null,1,{"$f":"SUM(AJ39:AL39)+AE39","v":16.25},null,null,{"$f":"ROUND(AC39/(1-VLOOKUP(AF39,Group,2,FALSE)),2)","v":16.25},{"$f":"IF(VLOOKUP(AF39,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ39,1)-AJ39,2),Round,2,FALSE)+VLOOKUP(AF39,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",0,ROUND(AJ39-0.04999,1)-AJ39+AM39)","v":0},{"$f":"IF(VLOOKUP(AF39,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF39,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W40","v":0},{"$f":"+X40","v":13.5},{"$f":"(AG40-AC40)/AG40","v":0},null,1,{"$f":"SUM(AJ40:AL40)+AE40","v":13.5},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF40,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ40,1)-AJ40,2),Round,2,FALSE)+VLOOKUP(AF40,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",0,ROUND(AJ40-0.04999,1)-AJ40+AM40)","v":0},{"$f":"IF(VLOOKUP(AF40,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF40,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA41,AG41)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W41","v":0},{"$f":"+X41","v":12.95},{"$f":"(AG41-AC41)/AG41","v":0},null,1,{"$f":"SUM(AJ41:AL41)+AE41","v":12.95},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF41,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ41,1)-AJ41,2),Round,2,FALSE)+VLOOKUP(AF41,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",0,ROUND(AJ41-0.04999,1)-AJ41+AM41)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF41,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":13.55},null,"new",13.55,{"$f":"+W42","v":0},{"$f":"+X42","v":13.55},{"$f":"(AG42-AC42)/AG42","v":0},null,1,{"$f":"SUM(AJ42:AL42)+AE42","v":13.55},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF42,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ42,1)-AJ42,2),Round,2,FALSE)+VLOOKUP(AF42,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",0,ROUND(AJ42-0.04999,1)-AJ42+AM42)","v":0},{"$f":"IF(VLOOKUP(AF42,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF42,Group,7,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,"ICON TRAVERTINE - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRIC",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,"Colors:","Pearl          River",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA48,AG48)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA48*(1-W48)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W48","v":0},{"$f":"+X48","v":13.5},{"$f":"(AG48-AC48)/AG48","v":0},null,1,{"$f":"SUM(AJ48:AL48)+AE48","v":13.5},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF48,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ48,1)-AJ48,2),Round,2,FALSE)+VLOOKUP(AF48,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",0,ROUND(AJ48-0.04999,1)-AJ48+AM48)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF48,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA49,AG49)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA49*(1-W49)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W49","v":0},{"$f":"+X49","v":12.95},{"$f":"(AG49-AC49)/AG49","v":0},null,1,{"$f":"SUM(AJ49:AL49)+AE49","v":12.95},null,null,{"$f":"ROUND(AC49/(1-VLOOKUP(AF49,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF49,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ49,1)-AJ49,2),Round,2,FALSE)+VLOOKUP(AF49,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,7,FALSE)=\"\",0,ROUND(AJ49-0.04999,1)-AJ49+AM49)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF49,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA50,AG50)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA50*(1-W50)+0.004999,2)","v":13.55},null,"new",13.55,{"$f":"+W50","v":0},{"$f":"+X50","v":13.55},{"$f":"(AG50-AC50)/AG50","v":0},null,1,{"$f":"SUM(AJ50:AL50)+AE50","v":13.55},null,null,{"$f":"ROUND(AC50/(1-VLOOKUP(AF50,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF50,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ50,1)-AJ50,2),Round,2,FALSE)+VLOOKUP(AF50,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",0,ROUND(AJ50-0.04999,1)-AJ50+AM50)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF50,Group,7,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,"MONOCROMATICA - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRMO",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,"Colors:","Ash          Basalt          Bone          Cognac          Leather          Sand",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA56,AG56)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W56","v":0},{"$f":"+X56","v":13.5},{"$f":"(AG56-AC56)/AG56","v":0},null,1,{"$f":"SUM(AJ56:AL56)+AE56","v":13.5},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA57,AG57)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W57","v":0},{"$f":"+X57","v":12.95},{"$f":"(AG57-AC57)/AG57","v":0},null,1,{"$f":"SUM(AJ57:AL57)+AE57","v":12.95},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF57,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ57,1)-AJ57,2),Round,2,FALSE)+VLOOKUP(AF57,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",0,ROUND(AJ57-0.04999,1)-AJ57+AM57)","v":0},{"$f":"IF(VLOOKUP(AF57,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF57,Group,7,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,"OCEAN STONE - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KROC",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,"Colors:","Black          Tan          White Cool",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA63,AG63)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA63*(1-W63)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W63","v":0},{"$f":"+X63","v":13.5},{"$f":"(AG63-AC63)/AG63","v":0},null,1,{"$f":"SUM(AJ63:AL63)+AE63","v":13.5},null,null,{"$f":"ROUND(AC63/(1-VLOOKUP(AF63,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF63,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ63,1)-AJ63,2),Round,2,FALSE)+VLOOKUP(AF63,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF63,Group,7,FALSE)=\"\",0,ROUND(AJ63-0.04999,1)-AJ63+AM63)","v":0},{"$f":"IF(VLOOKUP(AF63,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF63,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA64,AG64)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA64*(1-W64)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W64","v":0},{"$f":"+X64","v":12.95},{"$f":"(AG64-AC64)/AG64","v":0},null,1,{"$f":"SUM(AJ64:AL64)+AE64","v":12.95},null,null,{"$f":"ROUND(AC64/(1-VLOOKUP(AF64,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ64,1)-AJ64,2),Round,2,FALSE)+VLOOKUP(AF64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",0,ROUND(AJ64-0.04999,1)-AJ64+AM64)","v":0},{"$f":"IF(VLOOKUP(AF64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF64,Group,7,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,"Color:","Black",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA68,AG68)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":13.55},null,"new",13.55,{"$f":"+W68","v":0},{"$f":"+X68","v":13.55},{"$f":"(AG68-AC68)/AG68","v":0},null,1,{"$f":"SUM(AJ68:AL68)+AE68","v":13.55},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ68,1)-AJ68,2),Round,2,FALSE)+VLOOKUP(AF68,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",0,ROUND(AJ68-0.04999,1)-AJ68+AM68)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF68,Group,7,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,"PENNSYLVANIA - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRPE",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,"Colors:","Full Color          True Blue",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA74,AG74)","v":16.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA74*(1-W74)+0.004999,2)","v":16.25},null,"new",16.25,{"$f":"+W74","v":0},{"$f":"+X74","v":16.25},{"$f":"(AG74-AC74)/AG74","v":0},null,1,{"$f":"SUM(AJ74:AL74)+AE74","v":16.25},null,null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":16.25},{"$f":"IF(VLOOKUP(AF74,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ74,1)-AJ74,2),Round,2,FALSE)+VLOOKUP(AF74,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",0,ROUND(AJ74-0.04999,1)-AJ74+AM74)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF74,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA75,AG75)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA75*(1-W75)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W75","v":0},{"$f":"+X75","v":13.5},{"$f":"(AG75-AC75)/AG75","v":0},null,1,{"$f":"SUM(AJ75:AL75)+AE75","v":13.5},null,null,{"$f":"ROUND(AC75/(1-VLOOKUP(AF75,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF75,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ75,1)-AJ75,2),Round,2,FALSE)+VLOOKUP(AF75,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF75,Group,7,FALSE)=\"\",0,ROUND(AJ75-0.04999,1)-AJ75+AM75)","v":0},{"$f":"IF(VLOOKUP(AF75,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF75,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA76,AG76)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W76","v":0},{"$f":"+X76","v":12.95},{"$f":"(AG76-AC76)/AG76","v":0},null,1,{"$f":"SUM(AJ76:AL76)+AE76","v":12.95},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA77,AG77)","v":14.2},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":14.2},null,"new",14.2,{"$f":"+W77","v":0},{"$f":"+X77","v":14.2},{"$f":"(AG77-AC77)/AG77","v":0},null,1,{"$f":"SUM(AJ77:AL77)+AE77","v":14.2},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":14.2},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF77,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":13.55},null,"new",13.55,{"$f":"+W78","v":0},{"$f":"+X78","v":13.55},{"$f":"(AG78-AC78)/AG78","v":0},null,1,{"$f":"SUM(AJ78:AL78)+AE78","v":13.55},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,Group,7,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,"PRIMA MATERIA - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRPR",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,"Colors:","Cemento          Cenere          Sandalo",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA84,AG84)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W84","v":0},{"$f":"+X84","v":12.95},{"$f":"(AG84-AC84)/AG84","v":0},null,1,{"$f":"SUM(AJ84:AL84)+AE84","v":12.95},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF84,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ84,1)-AJ84,2),Round,2,FALSE)+VLOOKUP(AF84,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",0,ROUND(AJ84-0.04999,1)-AJ84+AM84)","v":0},{"$f":"IF(VLOOKUP(AF84,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF84,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA85*(1-W85)+0.004999,2)","v":13.55},null,"new",13.55,{"$f":"+W85","v":0},{"$f":"+X85","v":13.55},{"$f":"(AG85-AC85)/AG85","v":0},null,1,{"$f":"SUM(AJ85:AL85)+AE85","v":13.55},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ85,1)-AJ85,2),Round,2,FALSE)+VLOOKUP(AF85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",0,ROUND(AJ85-0.04999,1)-AJ85+AM85)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF85,Group,7,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,"QUARTZITE - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRQU",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,"Colors:","Crystal White          Sandy Island",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA91,AG91)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W91","v":0},{"$f":"+X91","v":13.5},{"$f":"(AG91-AC91)/AG91","v":0},null,1,{"$f":"SUM(AJ91:AL91)+AE91","v":13.5},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF91,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ91,1)-AJ91,2),Round,2,FALSE)+VLOOKUP(AF91,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",0,ROUND(AJ91-0.04999,1)-AJ91+AM91)","v":0},{"$f":"IF(VLOOKUP(AF91,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF91,Group,7,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,"Colors:","Cloud          Crystal White          Laguna          Sandy Island",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA95,AG95)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA95*(1-W95)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W95","v":0},{"$f":"+X95","v":12.95},{"$f":"(AG95-AC95)/AG95","v":0},null,1,{"$f":"SUM(AJ95:AL95)+AE95","v":12.95},null,null,{"$f":"ROUND(AC95/(1-VLOOKUP(AF95,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF95,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ95,1)-AJ95,2),Round,2,FALSE)+VLOOKUP(AF95,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",0,ROUND(AJ95-0.04999,1)-AJ95+AM95)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF95,Group,7,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,"STONE - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRST",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,"Color:","Creamstone",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 12\"",null,"Field",null,null,null,null,null,null,null,null,"4.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA101,AG101)","v":16.25},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA101*(1-W101)+0.004999,2)","v":16.25},null,"new",16.25,{"$f":"+W101","v":0},{"$f":"+X101","v":16.25},{"$f":"(AG101-AC101)/AG101","v":0},null,1,{"$f":"SUM(AJ101:AL101)+AE101","v":16.25},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":16.25},{"$f":"IF(VLOOKUP(AF101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ101,1)-AJ101,2),Round,2,FALSE)+VLOOKUP(AF101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",0,ROUND(AJ101-0.04999,1)-AJ101+AM101)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF101,Group,7,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,"Colors:","Creamstone          Moonstone",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA105,AG105)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W105","v":0},{"$f":"+X105","v":13.5},{"$f":"(AG105-AC105)/AG105","v":0},null,1,{"$f":"SUM(AJ105:AL105)+AE105","v":13.5},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF105,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ105,1)-AJ105,2),Round,2,FALSE)+VLOOKUP(AF105,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",0,ROUND(AJ105-0.04999,1)-AJ105+AM105)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF105,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W106","v":0},{"$f":"+X106","v":12.95},{"$f":"(AG106-AC106)/AG106","v":0},null,1,{"$f":"SUM(AJ106:AL106)+AE106","v":12.95},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF106,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ106,1)-AJ106,2),Round,2,FALSE)+VLOOKUP(AF106,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",0,ROUND(AJ106-0.04999,1)-AJ106+AM106)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF106,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA107,AG107)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA107*(1-W107)+0.004999,2)","v":13.55},null,"new",13.55,{"$f":"+W107","v":0},{"$f":"+X107","v":13.55},{"$f":"(AG107-AC107)/AG107","v":0},null,1,{"$f":"SUM(AJ107:AL107)+AE107","v":13.55},null,null,{"$f":"ROUND(AC107/(1-VLOOKUP(AF107,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF107,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ107,1)-AJ107,2),Round,2,FALSE)+VLOOKUP(AF107,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",0,ROUND(AJ107-0.04999,1)-AJ107+AM107)","v":0},{"$f":"IF(VLOOKUP(AF107,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF107,Group,7,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,"TERRAZZO - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRTE",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,"Colors:","Charcoal          Cool Grey          Cool White          Grey Black          White Black",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA113,AG113)","v":13.5},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA113*(1-W113)+0.004999,2)","v":13.5},null,"new",13.5,{"$f":"+W113","v":0},{"$f":"+X113","v":13.5},{"$f":"(AG113-AC113)/AG113","v":0},null,1,{"$f":"SUM(AJ113:AL113)+AE113","v":13.5},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":13.5},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ113,1)-AJ113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",0,ROUND(AJ113-0.04999,1)-AJ113+AM113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF113,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA114,AG114)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA114*(1-W114)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W114","v":0},{"$f":"+X114","v":12.95},{"$f":"(AG114-AC114)/AG114","v":0},null,1,{"$f":"SUM(AJ114:AL114)+AE114","v":12.95},null,null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF114,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ114,1)-AJ114,2),Round,2,FALSE)+VLOOKUP(AF114,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",0,ROUND(AJ114-0.04999,1)-AJ114+AM114)","v":0},{"$f":"IF(VLOOKUP(AF114,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF114,Group,7,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,"TEX - WOOD - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRTX",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,"Colors:","Brown          Grey          Ivory",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA120,AG120)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W120","v":0},{"$f":"+X120","v":12.95},{"$f":"(AG120-AC120)/AG120","v":0},null,1,{"$f":"SUM(AJ120:AL120)+AE120","v":12.95},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF120,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ120,1)-AJ120,2),Round,2,FALSE)+VLOOKUP(AF120,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",0,ROUND(AJ120-0.04999,1)-AJ120+AM120)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF120,Group,7,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,"TIMBER - WOOD - 3/4\" Thick Porcelain Pavers (Rectified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","KRTM",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,"Colors:"," Ipe'          Teak",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA126,AG126)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA126*(1-W126)+0.004999,2)","v":12.95},null,"new",12.95,{"$f":"+W126","v":0},{"$f":"+X126","v":12.95},{"$f":"(AG126-AC126)/AG126","v":0},null,1,{"$f":"SUM(AJ126:AL126)+AE126","v":12.95},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ126,1)-AJ126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",0,ROUND(AJ126-0.04999,1)-AJ126+AM126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,7,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,"Color:"," Ipe'",null,null,null,null,null,null,null,null,null,null,null,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,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA130,AG130)","v":13.55},"SF",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA130*(1-W130)+0.004999,2)","v":13.55},null,"new",13.55,{"$f":"+W130","v":0},{"$f":"+X130","v":13.55},{"$f":"(AG130-AC130)/AG130","v":0},null,1,{"$f":"SUM(AJ130:AL130)+AE130","v":13.55},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":13.55},{"$f":"IF(VLOOKUP(AF130,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ130,1)-AJ130,2),Round,2,FALSE)+VLOOKUP(AF130,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",0,ROUND(AJ130-0.04999,1)-AJ130+AM130)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF130,Group,7,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,"Trims / Copings (All Colors)",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Trim",null,null,"12\" x 24\"",null,"Coping - Full Bullnose (One Side)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":101.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA134*(1-W134)+0.004999,2)","v":101.4},null,"new",101.4,{"$f":"+W134","v":0},101.4,{"$f":"(AG134-AC134)/AG134","v":0},null,2,{"$f":"SUM(AJ134:AL134)+AE134","v":101.4},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":101.4},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ134,1)-AJ134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AJ134-0.04999,1)-AJ134+AM134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"12\" x 24\"",null,"Coping - Full Bullnose Corner (Two Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA135,AG135)","v":239.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA135*(1-W135)+0.004999,2)","v":239.4},null,"new",239.4,0,239.4,{"$f":"(AG135-AC135)/AG135","v":0},null,2,{"$f":"SUM(AJ135:AL135)+AE135","v":239.4},null,null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":239.4},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ135,1)-AJ135,2),Round,2,FALSE)+VLOOKUP(AF135,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",0,ROUND(AJ135-0.04999,1)-AJ135+AM135)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF135,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"12\" x 24\"",null,"Coping - Full Bullnose (Two 24\" Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":329.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA136*(1-W136)+0.004999,2)","v":329.4},null,"new",329.4,0,329.4,{"$f":"(AG136-AC136)/AG136","v":0},null,2,{"$f":"SUM(AJ136:AL136)+AE136","v":329.4},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":329.4},{"$f":"IF(VLOOKUP(AF136,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ136,1)-AJ136,2),Round,2,FALSE)+VLOOKUP(AF136,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",0,ROUND(AJ136-0.04999,1)-AJ136+AM136)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF136,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"12\" x 24\"",null,"Coping - Full Bullnose (Two Long Sides & One Short Side)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA137,AG137)","v":479.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA137*(1-W137)+0.004999,2)","v":479.4},null,"new",479.4,0,479.4,{"$f":"(AG137-AC137)/AG137","v":0},null,2,{"$f":"SUM(AJ137:AL137)+AE137","v":479.4},null,null,{"$f":"ROUND(AC137/(1-VLOOKUP(AF137,Group,2,FALSE)),2)","v":479.4},{"$f":"IF(VLOOKUP(AF137,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ137,1)-AJ137,2),Round,2,FALSE)+VLOOKUP(AF137,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",0,ROUND(AJ137-0.04999,1)-AJ137+AM137)","v":0},{"$f":"IF(VLOOKUP(AF137,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF137,Group,7,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,"Trim",null,null,"12\" x 24\"",null,"Coping - Double Bevel (One Side)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA139,AG139)","v":101.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA139*(1-W139)+0.004999,2)","v":101.4},null,"new",101.4,{"$f":"+W139","v":0},101.4,{"$f":"(AG139-AC139)/AG139","v":0},null,2,{"$f":"SUM(AJ139:AL139)+AE139","v":101.4},null,null,{"$f":"ROUND(AC139/(1-VLOOKUP(AF139,Group,2,FALSE)),2)","v":101.4},{"$f":"IF(VLOOKUP(AF139,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ139,1)-AJ139,2),Round,2,FALSE)+VLOOKUP(AF139,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",0,ROUND(AJ139-0.04999,1)-AJ139+AM139)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF139,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"12\" x 24\"",null,"Coping - Double Bevel Corner (Two Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA140,AG140)","v":239.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":239.4},null,"new",239.4,0,239.4,{"$f":"(AG140-AC140)/AG140","v":0},null,2,{"$f":"SUM(AJ140:AL140)+AE140","v":239.4},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":239.4},{"$f":"IF(VLOOKUP(AF140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ140,1)-AJ140,2),Round,2,FALSE)+VLOOKUP(AF140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",0,ROUND(AJ140-0.04999,1)-AJ140+AM140)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF140,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"12\" x 24\"",null,"Coping - Double Bevel (Two 24\" Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA141,AG141)","v":329.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA141*(1-W141)+0.004999,2)","v":329.4},null,"new",329.4,0,329.4,{"$f":"(AG141-AC141)/AG141","v":0},null,2,{"$f":"SUM(AJ141:AL141)+AE141","v":329.4},null,null,{"$f":"ROUND(AC141/(1-VLOOKUP(AF141,Group,2,FALSE)),2)","v":329.4},{"$f":"IF(VLOOKUP(AF141,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ141,1)-AJ141,2),Round,2,FALSE)+VLOOKUP(AF141,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",0,ROUND(AJ141-0.04999,1)-AJ141+AM141)","v":0},{"$f":"IF(VLOOKUP(AF141,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF141,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"12\" x 24\"",null,"Coping - Double Bevel (Two Long Sides & One Short Side)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA142,AG142)","v":479.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA142*(1-W142)+0.004999,2)","v":479.4},null,"new",479.4,0,479.4,{"$f":"(AG142-AC142)/AG142","v":0},null,2,{"$f":"SUM(AJ142:AL142)+AE142","v":479.4},null,null,{"$f":"ROUND(AC142/(1-VLOOKUP(AF142,Group,2,FALSE)),2)","v":479.4},{"$f":"IF(VLOOKUP(AF142,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ142,1)-AJ142,2),Round,2,FALSE)+VLOOKUP(AF142,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",0,ROUND(AJ142-0.04999,1)-AJ142+AM142)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF142,Group,7,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,"Trim",null,null,"24\" x 24\"",null,"Coping - Full Bullnose (One Side)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA144,AG144)","v":205.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA144*(1-W144)+0.004999,2)","v":205.75},null,"new",205.75,{"$f":"+W144","v":0},205.75,{"$f":"(AG144-AC144)/AG144","v":0},null,2,{"$f":"SUM(AJ144:AL144)+AE144","v":205.75},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":205.75},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"24\" x 24\"",null,"Coping - Full Bullnose Corner (Two Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":365.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA145*(1-W145)+0.004999,2)","v":365.4},null,"new",365.4,0,365.4,{"$f":"(AG145-AC145)/AG145","v":0},null,2,{"$f":"SUM(AJ145:AL145)+AE145","v":365.4},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":365.4},{"$f":"IF(VLOOKUP(AF145,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ145,1)-AJ145,2),Round,2,FALSE)+VLOOKUP(AF145,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",0,ROUND(AJ145-0.04999,1)-AJ145+AM145)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF145,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"24\" x 24\"",null,"Coping - Full Bullnose Corner (Three Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA146,AG146)","v":500.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA146*(1-W146)+0.004999,2)","v":500.4},null,"new",500.4,0,500.4,{"$f":"(AG146-AC146)/AG146","v":0},null,2,{"$f":"SUM(AJ146:AL146)+AE146","v":500.4},null,null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":500.4},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ146,1)-AJ146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",0,ROUND(AJ146-0.04999,1)-AJ146+AM146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF146,Group,7,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,"Trim",null,null,"24\" x 24\"",null,"Coping - Double Bevel (One Side)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA148,AG148)","v":205.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":205.75},null,"new",205.75,{"$f":"+W148","v":0},205.75,{"$f":"(AG148-AC148)/AG148","v":0},null,2,{"$f":"SUM(AJ148:AL148)+AE148","v":205.75},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":205.75},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"24\" x 24\"",null,"Coping - Double Bevel Corner (Two Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA149,AG149)","v":365.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA149*(1-W149)+0.004999,2)","v":365.4},null,"new",365.4,0,365.4,{"$f":"(AG149-AC149)/AG149","v":0},null,2,{"$f":"SUM(AJ149:AL149)+AE149","v":365.4},null,null,{"$f":"ROUND(AC149/(1-VLOOKUP(AF149,Group,2,FALSE)),2)","v":365.4},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ149,1)-AJ149,2),Round,2,FALSE)+VLOOKUP(AF149,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",0,ROUND(AJ149-0.04999,1)-AJ149+AM149)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF149,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"24\" x 24\"",null,"Coping - Double Bevel Corner (Three Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA150,AG150)","v":500.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA150*(1-W150)+0.004999,2)","v":500.4},null,"new",500.4,0,500.4,{"$f":"(AG150-AC150)/AG150","v":0},null,2,{"$f":"SUM(AJ150:AL150)+AE150","v":500.4},null,null,{"$f":"ROUND(AC150/(1-VLOOKUP(AF150,Group,2,FALSE)),2)","v":500.4},{"$f":"IF(VLOOKUP(AF150,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ150,1)-AJ150,2),Round,2,FALSE)+VLOOKUP(AF150,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",0,ROUND(AJ150-0.04999,1)-AJ150+AM150)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF150,Group,7,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,"Trim",null,null,"24\" x 48\"",null,"Coping - Full Bullnose (48\" Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA152,AG152)","v":345.5},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA152*(1-W152)+0.004999,2)","v":345.5},null,"new",345.5,{"$f":"+W152","v":0},{"$f":"+X152","v":345.5},{"$f":"(AG152-AC152)/AG152","v":0},null,2,{"$f":"SUM(AJ152:AL152)+AE152","v":345.5},null,null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":345.5},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ152,1)-AJ152,2),Round,2,FALSE)+VLOOKUP(AF152,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",0,ROUND(AJ152-0.04999,1)-AJ152+AM152)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF152,Group,7,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,"Trim",null,null,"24\" x 48\"",null,"Coping - Double Bevel (48\" Sides)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA154,AG154)","v":345.5},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":345.5},null,"new",345.5,{"$f":"+W154","v":0},{"$f":"+X154","v":345.5},{"$f":"(AG154-AC154)/AG154","v":0},null,2,{"$f":"SUM(AJ154:AL154)+AE154","v":345.5},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":345.5},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ154,1)-AJ154,2),Round,2,FALSE)+VLOOKUP(AF154,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",0,ROUND(AJ154-0.04999,1)-AJ154+AM154)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF154,Group,7,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,"Trim",null,null,"12\" x 24\"",null,"Coping - Mitered Edge \"L\" Shape with 2\" Drop on 1 Long Side",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA156,AG156)","v":171.3},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA156*(1-W156)+0.004999,2)","v":171.3},null,"new",171.3,{"$f":"+W156","v":0},{"$f":"+X156","v":171.3},{"$f":"(AG156-AC156)/AG156","v":0},null,2,{"$f":"SUM(AJ156:AL156)+AE156","v":171.3},null,null,{"$f":"ROUND(AC156/(1-VLOOKUP(AF156,Group,2,FALSE)),2)","v":171.3},{"$f":"IF(VLOOKUP(AF156,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ156,1)-AJ156,2),Round,2,FALSE)+VLOOKUP(AF156,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",0,ROUND(AJ156-0.04999,1)-AJ156+AM156)","v":0},{"$f":"IF(VLOOKUP(AF156,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF156,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim"," ",null,"12\" x 24\"",null,"Coping - Double Mitered Edge \"L\" Shape with 2\" Drop on 1 Long Side & 1 Short Side",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA157,AG157)","v":201.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":201.75},null,"new",201.75,{"$f":"+W157","v":0},{"$f":"+X157","v":201.75},{"$f":"(AG157-AC157)/AG157","v":0},null,2,{"$f":"SUM(AJ157:AL157)+AE157","v":201.75},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":201.75},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"12\" x 24\"",null,"Coping - w/45° Corner Cut & Mitered Edge \"L\" Shape with 2\" Drop on 1 Long Side",null,null,null,null,null,null,null,null,null,null,null,219.3,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},219.3,null,"new",219.3,0,219.3,0,null,2,219.3,null,null,219.3,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,"Accessories / Pedestals",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Trim",null,null,"24\" x 24\"",null,"Shock Control",null,null,null,"SC01",null,"Black",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA162,AG162)","v":17.75},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA162*(1-W162)+0.004999,2)","v":17.75},null,"new",17.75,{"$f":"+W162","v":0},{"$f":"+X162","v":17.75},{"$f":"(AG162-AC162)/AG162","v":0},null,2,{"$f":"SUM(AJ162:AL162)+AE162","v":17.75},null,null,{"$f":"ROUND(AC162/(1-VLOOKUP(AF162,Group,2,FALSE)),2)","v":17.75},{"$f":"IF(VLOOKUP(AF162,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ162,1)-AJ162,2),Round,2,FALSE)+VLOOKUP(AF162,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",0,ROUND(AJ162-0.04999,1)-AJ162+AM162)","v":0},{"$f":"IF(VLOOKUP(AF162,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF162,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"24\" x 48\"",null,"Shock Control",null,null,null,"SC02",null,"Black",null,null,null,null,null,35.450000000000003,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},35.450000000000003,null,"new",35.450000000000003,0,35.450000000000003,0,null,2,35.450000000000003,null,null,35.450000000000003,0,0,"",null,"X"]
[null,"Trim",null,null,"16\" x 48\"",null,"Shock Control",null,null,null,"SC03",null,"Black",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA164,AG164)","v":23.65},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":23.65},null,"new",23.65,{"$f":"+W164","v":0},{"$f":"+X164","v":23.65},{"$f":"(AG164-AC164)/AG164","v":0},null,2,{"$f":"SUM(AJ164:AL164)+AE164","v":23.65},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":23.65},{"$f":"IF(VLOOKUP(AF164,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ164,1)-AJ164,2),Round,2,FALSE)+VLOOKUP(AF164,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",0,ROUND(AJ164-0.04999,1)-AJ164+AM164)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF164,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"24\" x 24\"",null,"Metal Basket",null,null,null,3459,null,"Steel",null,null,null,null,null,28.6,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},28.6,null,"new",28.6,0,28.6,0,null,2,28.6,null,null,28.6,0,0,"",null,"X"]
[null,"Trim",null,null,null,null,"Mini DM Spacers",null,null,null,3580,null,null,null,null,"100 EA/PKG",null,null,{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":0.85},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":0.85},null,"new",0.85,{"$f":"+W166","v":0},{"$f":"+X166","v":0.85},{"$f":"(AG166-AC166)/AG166","v":0},null,2,{"$f":"SUM(AJ166:AL166)+AE166","v":0.85},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":0.85},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,Group,7,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,"Import I - Trim",null,null,"1/16''- 3/32''",null,"Lucky Compensator",null,null,null,"LUK",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA168,AG168)","v":1.95},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA168*(1-W168)+0.004999,2)","v":1.95},null,"new",1.95,{"$f":"+W168","v":0},{"$f":"+X168","v":1.95},{"$f":"(AG168-AC168)/AG168","v":0},null,5,{"$f":"SUM(AJ168:AL168)+AE168","v":1.95},null,null,{"$f":"ROUND(AC168/(1-VLOOKUP(AF168,Group,2,FALSE)),2)","v":1.95},{"$f":"IF(VLOOKUP(AF168,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ168,1)-AJ168,2),Round,2,FALSE)+VLOOKUP(AF168,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",0,ROUND(AJ168-0.04999,1)-AJ168+AM168)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF168,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"15/32\" - 45/64\"",null,"Junior Self-Levelling Base",null,null,null,"J1",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA169,AG169)","v":10.199999999999999},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA169*(1-W169)+0.004999,2)","v":10.199999999999999},null,"new",10.199999999999999,{"$f":"+W169","v":0},{"$f":"+X169","v":10.199999999999999},{"$f":"(AG169-AC169)/AG169","v":0},null,5,{"$f":"SUM(AJ169:AL169)+AE169","v":10.199999999999999},null,null,{"$f":"ROUND(AC169/(1-VLOOKUP(AF169,Group,2,FALSE)),2)","v":10.199999999999999},{"$f":"IF(VLOOKUP(AF169,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ169,1)-AJ169,2),Round,2,FALSE)+VLOOKUP(AF169,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",0,ROUND(AJ169-0.04999,1)-AJ169+AM169)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF169,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"45/64\" - 15/16\"",null,"Junior Self-Levelling Base",null,null,null,"J2",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA170,AG170)","v":12.35},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA170*(1-W170)+0.004999,2)","v":12.35},null,"new",12.35,{"$f":"+W170","v":0},{"$f":"+X170","v":12.35},{"$f":"(AG170-AC170)/AG170","v":0},null,5,{"$f":"SUM(AJ170:AL170)+AE170","v":12.35},null,null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":12.35},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ170,1)-AJ170,2),Round,2,FALSE)+VLOOKUP(AF170,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",0,ROUND(AJ170-0.04999,1)-AJ170+AM170)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF170,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"15/16\" - 1-11/64\"",null,"Junior Self-Levelling Base",null,null,null,"J3",null,null,null,null,null,null,null,14.35,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},14.35,null,"new",14.35,0,14.35,0,null,5,14.35,null,null,14.35,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"13/16\" - 1-11/64\"",null,"Queen Paving Support",null,null,null,"Q1",null,null,null,null,null,null,null,12.3,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},12.3,null,"new",12.3,0,12.3,0,null,5,12.3,null,null,12.3,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"1-9/64\" - 1-23/32\"",null,"Queen Paving Support",null,null,null,"Q2",null,null,null,null,null,null,null,13.7,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},13.7,null,"new",13.7,0,13.7,0,null,5,13.7,null,null,13.7,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"1-11/16\" - 2-53/64\"",null,"Queen Paving Support",null,null,null,"Q3",null,null,null,null,null,null,null,15.8,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},15.8,null,"new",15.8,0,15.8,0,null,5,15.8,null,null,15.8,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"2-3/4\" - 4-61/64\"",null,"Queen Paving Support",null,null,null,"Q4",null,null,null,null,null,null,null,18.399999999999999,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},18.399999999999999,null,"new",18.399999999999999,0,18.399999999999999,0,null,5,18.399999999999999,null,null,18.399999999999999,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"4-7/8\" - 9-13/64\"",null,"Queen Paving Support",null,null,null,"Q5",null,null,null,null,null,null,null,22.3,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},22.3,null,"new",22.3,0,22.3,0,null,5,22.3,null,null,22.3,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"5-1/ 8''",null,"Head",null,null,null,null," ",null,null,null,null,null,null,4.6500000000000004,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},4.6500000000000004,null,"new",4.6500000000000004,0,4.6500000000000004,0,null,5,4.6500000000000004,null,null,4.6500000000000004,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"29/32'' - 1-3/16\"",null,"Tower",null,null,null,"QTS",null,null,null,null,null,null,null,5.2,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},5.2,null,"new",5.2,0,5.2,0,null,5,5.2,null,null,5.2,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"2-33/64'' - 4-21/64''",null,"Tower",null,null,null,"QTL",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA179,AG179)","v":8.1},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA179*(1-W179)+0.004999,2)","v":8.1},null,"new",8.1,{"$f":"+W179","v":0},{"$f":"+X179","v":8.1},{"$f":"(AG179-AC179)/AG179","v":0},null,5,{"$f":"SUM(AJ179:AL179)+AE179","v":8.1},null,null,{"$f":"ROUND(AC179/(1-VLOOKUP(AF179,Group,2,FALSE)),2)","v":8.1},{"$f":"IF(VLOOKUP(AF179,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ179,1)-AJ179,2),Round,2,FALSE)+VLOOKUP(AF179,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",0,ROUND(AJ179-0.04999,1)-AJ179+AM179)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF179,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"9/32''",null,"Q Plus",null,null,null,"QPLUS",null,null,null,null,null,null,null,2.6,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},2.6,null,"new",2.6,0,2.6,0,null,5,2.6,null,null,2.6,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"1-39/64\" - 1-61/64\"",null,"Queen Joist",null,null,null,"QJ1",null,null,null,null,null,null,null,12.65,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},12.65,null,"new",12.65,0,12.65,0,null,5,12.65,null,null,12.65,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"2-5/16\" - 2-33/64\"",null,"Queen Joist",null,null,null,"QJ2",null,null,null,null,null,null,null,14.25,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},14.25,null,"new",14.25,0,14.25,0,null,5,14.25,null,null,14.25,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"2-15/32\" - 3-39/64\"",null,"Queen Joist",null,null,null,"QJ3",null,null,null,null,null,null,null,16.100000000000001,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},16.100000000000001,null,"new",16.100000000000001,0,16.100000000000001,0,null,5,16.100000000000001,null,null,16.100000000000001,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"3-17/32\" - 5-47/64\"",null,"Queen Joist",null,null,null,"QJ4",null,null,null,null,null,null,null,18.850000000000001,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},18.850000000000001,null,"new",18.850000000000001,0,18.850000000000001,0,null,5,18.850000000000001,null,null,18.850000000000001,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"5-21/32\" - 10\"",null,"Queen Joist",null,null,null,"QJ5",null,null,null,null,null,null,null,22.75,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},22.75,null,"new",22.75,0,22.75,0,null,5,22.75,null,null,22.75,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"H= 25/32''",null,"Head",null,null,null,"QJH",null,null,null,null,null,null,null,5.15,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},5.15,null,"new",5.15,0,5.15,0,null,5,5.15,null,null,5.15,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"2.40\" x 95\"",null,"Aluminum Rail/Joist",null,null,null,"ARAIL",null,null,null,null,null,null,null,124.6,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},124.6,null,"new",124.6,0,124.6,0,null,5,124.6,null,null,124.6,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,"Import I - Trim",null,null,null,null,"Klip Up",null,null,null,"KUP",null,"Steel",null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA189,AG189)","v":13.4},"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA189*(1-W189)+0.004999,2)","v":13.4},null,"new",13.4,{"$f":"+W189","v":0},{"$f":"+X189","v":13.4},{"$f":"(AG189-AC189)/AG189","v":0},null,5,{"$f":"SUM(AJ189:AL189)+AE189","v":13.4},null,null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":13.4},{"$f":"IF(VLOOKUP(AF189,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ189,1)-AJ189,2),Round,2,FALSE)+VLOOKUP(AF189,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",0,ROUND(AJ189-0.04999,1)-AJ189+AM189)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF189,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,null,null,"Klip Down",null,null,null,"KDOWN",null,"Steel",null,null,null,null,null,13.45,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},13.45,null,"new",13.45,0,13.45,0,null,5,13.45,null,null,13.45,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,null,null,"Klip Wall",null,null,null,"KWALL",null,"Steel",null,null,null,null,null,13.35,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},13.35,null,"new",13.35,0,13.35,0,null,5,13.35,null,null,13.35,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"7-7/8\" Diameter",null,"SKUDO liscio / smooth",null,null,null,"SKU",null,"Black",null,null,null,null,null,6.25,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},6.25,null,"new",6.25,0,6.25,0,null,5,6.25,null,null,6.25,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,null,null,"Power Key",null,null,null,"KTPOWKEY",null,"Steel",null,null,null,null,null,142.25,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},142.25,null,"new",142.25,0,142.25,0,null,5,142.25,null,null,142.25,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,null,null,"Power Up",null,null,null,"KTPOWUP4",null,null,null,null,null,null,null,58.1,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},58.1,null,"new",58.1,0,58.1,0,null,5,58.1,null,null,58.1,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"24\" x 24\"",null,"Pinza Lifting Handle",null,null,null,"MO3 0600",null,null,null,null,null,null,null,481.25,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},481.25,null,"new",481.25,0,481.25,0,null,5,481.25,null,null,481.25,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"5/32\" - h= 19/32\"",null,"Kross Plate 4-H15mm",null,null,null,"KSPACEP4",null,"Black",null,null,"100 EA/PKG",null,null,1,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},1,null,"new",1,0,1,0,null,5,1,null,null,1,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"1/8\" - h= 19/32\"",null,"Kross Easy 3-H15mm",null,null,null,"KSPACE13",null,"Black",null,null,"100 EA/PKG",null,null,0.85,"EA",{"$f":"+Instructions!$B$3","v":"G"},null,{"$f":"+Instructions!$C$22","v":0},0.85,null,"new",0.85,0,0.85,0,null,5,0.85,null,null,0.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"]
[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,"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.",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["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","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01,null,null,null,null,null," "]
[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":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","https://kronos-usa.com/"]
[]
[]
["Product","Direct Website Link"]

{"sheet":"Changes","index":4,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Discontinued Products:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Changes:"]