{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":3,"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":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Serenissima"]
["File as","S"]
["Product Code","B"]
["CCTD Effective Date","10/1/23 (Updated)"]
[]
[]
[]
["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":"B"}]
[]
[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,null,"  "]
[null,3,null,"Decos",null,"No",0]
[null,4,null,0,null,"No",0]
[null,5,null,0,null,"No",0]
[null,6,null,0,null,"No",0]
[null,7,null,0,null,"No",0]
[]
["If you want to manually adjust your price list, hit \"F5\" and go to \"Customer_Cost\" to manually adjust pricing."]
["You can enter a value in the column labeled \"Adj.\" to change your price manually."]
[]
[null,"Click on \"Your Price Calculation\" to set the print area for your personal cost calculation report."]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Your Price List\" to set the print area for your personal price list."]
[null,"Then you can send it to print"]
[null,null,null,null,null,null,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":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[48,0,48,10],[50,0,50,10],[2,5,2,10],[3,4,3,7]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'S' - Serenissima"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 10/1/23 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":120,"n_cols":41,"rows_kept":120,"cut":false,"hidden":false,"merged":[[10,14,10,15],[9,14,9,19],[109,3,109,4],[18,2,18,19],[17,14,17,15],[19,2,19,19],[103,2,103,19],[9,25,9,32],[12,22,12,23],[9,22,9,23],[105,2,105,19],[104,2,104,19],[102,2,102,19],[13,30,13,32],[14,13,15,19],[100,2,100,19],[12,14,12,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":"B"},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":"B"},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,{"$f":"IF(Suggested=\"Yes\",AA3,AG3)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},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,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA4,'Price List'!AG4)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,4,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA5,'Price List'!AG5)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,5,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA6,'Price List'!AG6)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,6,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AA7,'Price List'!AG7)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,null,null,0,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\",AA11,AG11)","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 'S' - Serenissima"},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":"10/1/23 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-10-02"},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 'B'"},null,null,null,null,null,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$11","v":"List Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","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,"NON-Stock ITEMS - MINIMUM 6-8 WEEK DELIVERY"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,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,"FOSSIL - Glazed Porcelain",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","SRFO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Bruno          Crema          Perla          Piombo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Matte / Rectified",null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA26,AG26)","v":8.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA26*(1-W26)+0.004999,2)","v":8.25},null,"",8.25,{"$f":"+W26","v":0},{"$f":"+X26","v":8.25},{"$f":"(AG26-AC26)/AG26","v":0},null,1,{"$f":"SUM(AJ26:AL26)+AE26","v":8.25},null,null,{"$f":"ROUND(AC26/(1-VLOOKUP(AF26,Group,2,FALSE)),2)","v":8.25},{"$f":"IF(VLOOKUP(AF26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ26,1)-AJ26,2),Round,2,FALSE)+VLOOKUP(AF26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",0,ROUND(AJ26-0.04999,1)-AJ26+AM26)","v":0},{"$f":"IF(VLOOKUP(AF26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF26,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,"Matte / Rectified",null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA27,AG27)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.8000000000000007,null,"",8.8000000000000007,0,8.8000000000000007,0,null,1,8.8000000000000007,null,null,8.8000000000000007,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,"Matte / Rectified",null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA28,AG28)","v":10.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.6,null,"",10.6,0,10.6,0,null,1,10.6,null,null,10.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,"Field Tile",null,null,"12\" x 24\"",null,"Field - Lines",null,null,null,null,null,"Matte / Rectified",null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":9.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":9.9},null,"",9.9,{"$f":"+W30","v":0},{"$f":"+X30","v":9.9},{"$f":"(AG30-AC30)/AG30","v":0},null,1,{"$f":"SUM(AJ30:AL30)+AE30","v":9.9},null,null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":9.9},{"$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 48\"",null,"Field - Lines",null,null,null,null,null,"Matte / Rectified",null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":10.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":10.5},null,"",10.5,{"$f":"+W31","v":0},{"$f":"+X31","v":10.5},{"$f":"(AG31-AC31)/AG31","v":0},null,1,{"$f":"SUM(AJ31:AL31)+AE31","v":10.5},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":10.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"1-1/4\" x 1-1/4\"",null,null,null,"Matte / Rectified",null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA33,AG33)","v":23.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":23.85},null,"",23.85,{"$f":"+W33","v":0},{"$f":"+X33","v":23.85},{"$f":"(AG33-AC33)/AG33","v":0},null,3,{"$f":"SUM(AJ33:AL33)+AE33","v":23.85},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":23.85},{"$f":"IF(VLOOKUP(AF33,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ33,1)-AJ33,2),Round,2,FALSE)+VLOOKUP(AF33,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",0,ROUND(AJ33-0.04999,1)-AJ33+AM33)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF33,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Basketweave",null,null,null,"Matte / Rectified",null,null,"5.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA34,AG34)","v":24.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":24.65},null,"",24.65,0,24.65,0,null,3,24.65,null,null,24.65,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Losanga (Elongated Hex)",null,null,null,"Matte / Rectified",null,null,"5.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":30.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":30.1},null,"",30.1,0,30.1,0,null,3,30.1,null,null,30.1,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"2-9/16\" x 24\"",null,"Bullnose",null,null,null,null,null,"Matte / Rectified",null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA37,AG37)","v":12.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":12.45},null,"",12.45,{"$f":"+W37","v":0},{"$f":"+X37","v":12.45},{"$f":"(AG37-AC37)/AG37","v":0},null,2,{"$f":"SUM(AJ37:AL37)+AE37","v":12.45},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":12.45},{"$f":"IF(VLOOKUP(AF37,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ37,1)-AJ37,2),Round,2,FALSE)+VLOOKUP(AF37,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",0,ROUND(AJ37-0.04999,1)-AJ37+AM37)","v":0},{"$f":"IF(VLOOKUP(AF37,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF37,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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,"Lux / Rectified",null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA39,AG39)","v":10.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA39*(1-W39)+0.004999,2)","v":10.15},null,"",10.15,{"$f":"+W39","v":0},{"$f":"+X39","v":10.15},{"$f":"(AG39-AC39)/AG39","v":0},null,1,{"$f":"SUM(AJ39:AL39)+AE39","v":10.15},null,null,{"$f":"ROUND(AC39/(1-VLOOKUP(AF39,Group,2,FALSE)),2)","v":10.15},{"$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,"24\" x 24\"",null,"Field",null,null,null,null,null,"Lux / Rectified",null,null,"11.62 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.55,null,"",10.55,0,10.55,0,null,1,10.55,null,null,10.55,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,"Lux / Rectified",null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA41,AG41)","v":11.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.95,null,"",11.95,0,11.95,0,null,1,11.95,null,null,11.95,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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"1-1/4\" x 1-1/4\"",null,null,null,"Lux / Rectified",null,null,"5.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA43,AG43)","v":24.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA43*(1-W43)+0.004999,2)","v":24.65},null,"",24.65,{"$f":"+W43","v":0},{"$f":"+X43","v":24.65},{"$f":"(AG43-AC43)/AG43","v":0},null,3,{"$f":"SUM(AJ43:AL43)+AE43","v":24.65},null,null,{"$f":"ROUND(AC43/(1-VLOOKUP(AF43,Group,2,FALSE)),2)","v":24.65},{"$f":"IF(VLOOKUP(AF43,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ43,1)-AJ43,2),Round,2,FALSE)+VLOOKUP(AF43,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF43,Group,7,FALSE)=\"\",0,ROUND(AJ43-0.04999,1)-AJ43+AM43)","v":0},{"$f":"IF(VLOOKUP(AF43,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF43,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Basketweave",null,null,null,"Lux / Rectified",null,null,"5.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA44,AG44)","v":25.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},25.75,null,"",25.75,0,25.75,0,null,3,25.75,null,null,25.75,0,0,"",null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"Losanga (Elongated Hex)",null,null,null,"Lux / Rectified",null,null,"5.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA45,AG45)","v":32.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},32.25,null,"",32.25,0,32.25,0,null,3,32.25,null,null,32.25,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,"Trim",null,null,"2-9/16\" x 24\"",null,"Bullnose",null,null,null,null,null,"Lux / Rectified",null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":13.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":13.1},null,"",13.1,{"$f":"+W47","v":0},{"$f":"+X47","v":13.1},{"$f":"(AG47-AC47)/AG47","v":0},null,2,{"$f":"SUM(AJ47:AL47)+AE47","v":13.1},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":13.1},{"$f":"IF(VLOOKUP(AF47,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ47,1)-AJ47,2),Round,2,FALSE)+VLOOKUP(AF47,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",0,ROUND(AJ47-0.04999,1)-AJ47+AM47)","v":0},{"$f":"IF(VLOOKUP(AF47,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF47,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"FUORITONO - Glazed Porcelain",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","SRFU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Beige          Bianco          Grigio          Muschio          Nero          Petrolio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"4\" x 12\"",null,"Field",null,null,null,null,null,"Matte (Opaco)",null,null,"5.49 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA53,AG53)","v":7.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":7.8},null,"",7.8,{"$f":"+W53","v":0},{"$f":"+X53","v":7.8},{"$f":"(AG53-AC53)/AG53","v":0},null,1,{"$f":"SUM(AJ53:AL53)+AE53","v":7.8},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":7.8},{"$f":"IF(VLOOKUP(AF53,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ53,1)-AJ53,2),Round,2,FALSE)+VLOOKUP(AF53,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",0,ROUND(AJ53-0.04999,1)-AJ53+AM53)","v":0},{"$f":"IF(VLOOKUP(AF53,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF53,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"5.5\" x 10\"",null,"Field - Rhomboid",null,null,null,null,null,"Matte (Opaco)",null,null,"11.51 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA54,AG54)","v":8.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5,null,"",8.5,0,8.5,0,null,1,8.5,null,null,8.5,0,0,"",null,"X"]
[null,"Field Tile",null,null,"11\" x 10\"",null,"Field - Hexagon",null,null,null,null,null,"Matte (Opaco)",null,null,"10.44 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA55,AG55)","v":8.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5,null,"",8.5,0,8.5,0,null,1,8.5,null,null,8.5,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"4\" x 12\"",null,"Field",null,null,null,null,null,"Glossy (Fuori)",null,null,"5.49 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA57,AG57)","v":7.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA57*(1-W57)+0.004999,2)","v":7.8},null,"",7.8,{"$f":"+W57","v":0},{"$f":"+X57","v":7.8},{"$f":"(AG57-AC57)/AG57","v":0},null,1,{"$f":"SUM(AJ57:AL57)+AE57","v":7.8},null,null,{"$f":"ROUND(AC57/(1-VLOOKUP(AF57,Group,2,FALSE)),2)","v":7.8},{"$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,"Field Tile",null,null,"5.5\" x 10\"",null,"Field - Rhomboid",null,null,null,null,null,"Glossy (Fuori)",null,null,"11.51 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA58,AG58)","v":8.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5,null,"",8.5,0,8.5,0,null,1,8.5,null,null,8.5,0,0,"",null,"X"]
[null,"Field Tile",null,null,"11\" x 10\"",null,"Field - Hexagon",null,null,null,null,null,"Glossy (Fuori)",null,null,"10.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":8.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.5,null,"",8.5,0,8.5,0,null,1,8.5,null,null,8.5,0,0,"",null,"X"]
[]
[null,null,"HERITAGE - Glazed Porcelain",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","SRHE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Grey          Ivory          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,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"8\" x 8\"",null,"Field",null,null,null,null,null,null,null,null,"11.19 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":7.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":7.45},null,"",7.45,{"$f":"+W65","v":0},{"$f":"+X65","v":7.45},{"$f":"(AG65-AC65)/AG65","v":0},null,1,{"$f":"SUM(AJ65:AL65)+AE65","v":7.45},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":7.45},{"$f":"IF(VLOOKUP(AF65,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ65,1)-AJ65,2),Round,2,FALSE)+VLOOKUP(AF65,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",0,ROUND(AJ65-0.04999,1)-AJ65+AM65)","v":0},{"$f":"IF(VLOOKUP(AF65,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF65,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"8\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"11.19 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":7.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.45,null,"",7.45,0,7.45,0,null,1,7.45,null,null,7.45,0,0,"",null,"X"]
[null,"Field Tile",null,null,"16\" x 16\"",null,"Field",null,null,null,null,null,null,null,null,"13.77 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA67,AG67)","v":7.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.45,null,"",7.45,0,7.45,0,null,1,7.45,null,null,7.45,0,0,"",null,"X"]
[null,"Field Tile",null,null,"16\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"10.44 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA68,AG68)","v":7.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":7.45},null,"",7.45,{"$f":"+W68","v":0},{"$f":"+X68","v":7.45},{"$f":"(AG68-AC68)/AG68","v":0},null,1,{"$f":"SUM(AJ68:AL68)+AE68","v":7.45},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":7.45},{"$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,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA70,AG70)","v":20.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA70*(1-W70)+0.004999,2)","v":20.7},null,"",20.7,{"$f":"+W70","v":0},{"$f":"+X70","v":20.7},{"$f":"(AG70-AC70)/AG70","v":0},null,3,{"$f":"SUM(AJ70:AL70)+AE70","v":20.7},null,null,{"$f":"ROUND(AC70/(1-VLOOKUP(AF70,Group,2,FALSE)),2)","v":20.7},{"$f":"IF(VLOOKUP(AF70,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ70,1)-AJ70,2),Round,2,FALSE)+VLOOKUP(AF70,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF70,Group,7,FALSE)=\"\",0,ROUND(AJ70-0.04999,1)-AJ70+AM70)","v":0},{"$f":"IF(VLOOKUP(AF70,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF70,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Note:","Modular Pattern Percentages:",null,null,null,"8\" x 8\"",0.11]
[null,null,null,null,null,null,null,null,"8\" x 16\"",0.11]
[null,null,null,null,null,null,null,null,"16\" x 16\"",0.45]
[null,null,null,null,null,null,null,null,"16\" x 24\"",0.33]
[]
[]
[]
[]
[null,null,"SOAP STONE - Glazed Porcelain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","SRSS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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          Coffee          Grey          Ivory          White"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Matte / Rectified",null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA84,AG84)","v":7.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":7.65},null,"",7.65,{"$f":"+W84","v":0},{"$f":"+X84","v":7.65},{"$f":"(AG84-AC84)/AG84","v":0},null,1,{"$f":"SUM(AJ84:AL84)+AE84","v":7.65},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":7.65},{"$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 24\"",null,"Field",null,null,null,null,null,"Matte / Rectified",null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":7.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.95,null,"",7.95,0,7.95,0,null,1,7.95,null,null,7.95,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,"Matte / Rectified",null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA86,AG86)","v":9.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.1,null,"",9.1,0,9.1,0,null,1,9.1,null,null,9.1,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"Mosaic",null,"2\" x 2\"",null,null,null,"Matte / Rectified",null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",AA88,AG88)","v":20.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":20.350000000000001},null,"",20.350000000000001,{"$f":"+W88","v":0},{"$f":"+X88","v":20.350000000000001},{"$f":"(AG88-AC88)/AG88","v":0},null,3,{"$f":"SUM(AJ88:AL88)+AE88","v":20.350000000000001},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":20.350000000000001},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ88,1)-AJ88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AJ88-0.04999,1)-AJ88+AM88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Mosaic",null,"3D",null,null,null,"Matte / Rectified",null,null,"3.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":51.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":51.1},null,"",51.1,0,51.1,0,null,3,51.1,null,null,51.1,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"2-9/16\" x 24\"",null,"Bullnose",null,null,null,null,null,"Matte / Rectified",null,null,"12.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA91,AG91)","v":12.45},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":12.45},null,"",12.45,{"$f":"+W91","v":0},{"$f":"+X91","v":12.45},{"$f":"(AG91-AC91)/AG91","v":0},null,2,{"$f":"SUM(AJ91:AL91)+AE91","v":12.45},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":12.45},{"$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,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,null,null,"Satin / Rectified",null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA93,AG93)","v":8.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA93*(1-W93)+0.004999,2)","v":8.9499999999999993},null,"",8.9499999999999993,{"$f":"+W93","v":0},{"$f":"+X93","v":8.9499999999999993},{"$f":"(AG93-AC93)/AG93","v":0},null,1,{"$f":"SUM(AJ93:AL93)+AE93","v":8.9499999999999993},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":8.9499999999999993},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ93,1)-AJ93,2),Round,2,FALSE)+VLOOKUP(AF93,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",0,ROUND(AJ93-0.04999,1)-AJ93+AM93)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF93,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,null,null,"Satin / Rectified",null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA94,AG94)","v":9.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.4499999999999993,null,"",9.4499999999999993,0,9.4499999999999993,0,null,1,9.4499999999999993,null,null,9.4499999999999993,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,null,null,"Satin / Rectified",null,null,"15.49 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA95,AG95)","v":10.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.5,null,"",10.5,0,10.5,0,null,1,10.5,null,null,10.5,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Mix"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Decos",null,null,"12\" x 16\"",null,"Mosaic",null,"MIX",null,null,null,"Matte / Rectified",null,null,"5.00 EA/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA99,AG99)","v":39.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA99*(1-W99)+0.004999,2)","v":39.1},null,"",39.1,{"$f":"+W99","v":0},{"$f":"+X99","v":39.1},{"$f":"(AG99-AC99)/AG99","v":0},null,3,{"$f":"SUM(AJ99:AL99)+AE99","v":39.1},null,null,{"$f":"ROUND(AC99/(1-VLOOKUP(AF99,Group,2,FALSE)),2)","v":39.1},{"$f":"IF(VLOOKUP(AF99,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ99,1)-AJ99,2),Round,2,FALSE)+VLOOKUP(AF99,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",0,ROUND(AJ99-0.04999,1)-AJ99+AM99)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF99,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
[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,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing"]
[null,null,"department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom."]
[null,null,"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,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,-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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links",null," "]
[]
["ConestogaTile's Website","https://www.conestogatile.com/products/new/"]
[]
["Manufacturer's Home Page","https://www.serenissima.re.it/en/"]
[]
[]
["Product","Direct Website Link"]
["FOSSIL","https://www.serenissima.re.it/en/collections/fossil/"]
["SOAP STONE","https://www.cercomceramiche.it/en/collections/soap-stone/"]
[null,null,null,"  "]

{"sheet":"Changes","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
["Date",null,"Description"]
["Announced","Series"]
[]
["New Products"]
["2021-01-01","Fossil","Glazed Porcelain"]
["2021-01-01","Soap Stone","Glazed Porcelain"]
["2022-11-01","Fuoritono","Glazed Porcelain"]
["2022-11-01","Heritage","Glazed Porcelain"]
[]
[]
[]
["Discontinued Products"]
[]
[]
[]
["Changes"]
["2024-09-27","Soap Stone","2-9/16\" x 24\" Bullnose format is no longer being \"Stocked\" in any color."]