{"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":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Imola"]
["File as","I"]
["Product Code","B"]
["CCTD Effective Date","1/1/24"]
[]
[]
[]
["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,3,null,"Decos",null,"No",0]
[null,4,null,"Field Tile-Miami",null,"No",0]
[null,5,null,"Trim - Miami",null,"No",0]
[null,6,null,"Decos - Miami",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 'I' - Imola"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 1/1/24"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[1,null,"CONCRETE PROJECT",null,"Full Body Porcelain"]
[1,null,"KOSHI",null,"Full Body Porcelain"]
["1-2",null,"MICRON 2.0",null,"Full Body Porcelain"]
[2,null,"THE ROOM",null,"Full Body Porcelain"]
[2,null,"VIBES",null,"Color Body Porcelain"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":205,"n_cols":41,"rows_kept":205,"cut":false,"hidden":false,"merged":[[17,13,18,19],[194,3,194,4],[21,2,21,19],[20,14,20,15],[22,2,22,19],[190,2,190,19],[191,2,191,19],[12,25,12,32],[15,22,15,23],[12,22,12,23],[16,30,16,32],[15,14,15,19],[13,14,13,15],[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,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,"Field Tile-Miami",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,{"$f":"+W4","v":0},0.05,{"$f":"(AG4-AC4)/AG4","v":0},null,1,{"$f":"SUM(AJ4:AL4)+AE4","v":0.05},null,null,{"$f":"ROUND(AC4/(1-VLOOKUP(AF4,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF4,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ4,1)-AJ4,2),Round,2,FALSE)+VLOOKUP(AF4,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF4,Group,7,FALSE)=\"\",0,ROUND(AJ4-0.04999,1)-AJ4+AM4)","v":0},{"$f":"IF(VLOOKUP(AF4,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF4,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim - Miami",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,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,{"$f":"(AG5-AC5)/AG5","v":0},null,2,{"$f":"SUM(AJ5:AL5)+AE5","v":0.05},null,null,{"$f":"ROUND(AC5/(1-VLOOKUP(AF5,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF5,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ5,1)-AJ5,2),Round,2,FALSE)+VLOOKUP(AF5,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF5,Group,7,FALSE)=\"\",0,ROUND(AJ5-0.04999,1)-AJ5+AM5)","v":0},{"$f":"IF(VLOOKUP(AF5,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF5,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos - Miami",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,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,{"$f":"(AG6-AC6)/AG6","v":0},null,3,{"$f":"SUM(AJ6:AL6)+AE6","v":0.05},null,null,{"$f":"ROUND(AC6/(1-VLOOKUP(AF6,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF6,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ6,1)-AJ6,2),Round,2,FALSE)+VLOOKUP(AF6,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF6,Group,7,FALSE)=\"\",0,ROUND(AJ6-0.04999,1)-AJ6+AM6)","v":0},{"$f":"IF(VLOOKUP(AF6,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF6,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile-Miami",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},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,"Trim - Miami",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,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,5,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos - Miami",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,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,6,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\",AA10,AG10)","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\",AA14,AG14)","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 'I' - Imola"},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":"1/1/24"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-12-13"},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$14","v":"List Price"},"U/M",{"$f":"+U$14","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$14","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$14","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 UNLESS AVAILABLE AT IMOLA INDIANA WAREHOUSE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"CONCRETE PROJECT - Full Body Porcelain",null,null,null,null,null,null,null,null," ",null,null,null,null,null,"Item # Lookup:","IMCP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","A (Almond)"," DG (Dark Gray)",null,null,null,"   N (Black)"]
[null,null,null,null,"B (Beige)"," G (Gray)",null,null,null,"   W (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 36",null,null,"Natural",null,null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+W30","v":0},{"$f":"+X30","v":8.75},{"$f":"(AG30-AC30)/AG30","v":0},null,1,{"$f":"SUM(AJ30:AL30)+AE30","v":8.75},null,null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":8.75},{"$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,"24\" x 24\"",null,"Field 60",null,null,"Natural",null,null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":9.4},null,"YES",9.4,{"$f":"+W31","v":0},9.4,{"$f":"(AG31-AC31)/AG31","v":0},null,1,{"$f":"SUM(AJ31:AL31)+AE31","v":9.4},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":9.4},{"$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 48\"",null,"Field 12",null,null,"Natural",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":11.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":11.2},null,"YES",11.2,0,11.2,{"$f":"(AG32-AC32)/AG32","v":0},null,1,{"$f":"SUM(AJ32:AL32)+AE32","v":11.2},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":11.2},{"$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,"48\" x 48\"",null,"Field 120",null,null,"Natural",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA33,AG33)","v":13.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":13.25},null,"YES",13.25,0,13.25,{"$f":"(AG33-AC33)/AG33","v":0},null,1,{"$f":"SUM(AJ33:AL33)+AE33","v":13.25},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":13.25},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 MK 30",null,null,"Natural",null,null,null,null,null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA35,AG35)","v":22.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":22.25},null,"YES",22.25,{"$f":"+W35","v":0},{"$f":"+X35","v":22.25},{"$f":"(AG35-AC35)/AG35","v":0},null,3,{"$f":"SUM(AJ35:AL35)+AE35","v":22.25},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":22.25},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ35,1)-AJ35,2),Round,2,FALSE)+VLOOKUP(AF35,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",0,ROUND(AJ35-0.04999,1)-AJ35+AM35)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF35,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Mosaic MU 36",null,null,"Natural",null,null,null,null,null,"3 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA36,AG36)","v":96.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":96.75},null,"YES",96.75,{"$f":"+W36","v":0},{"$f":"+X36","v":96.75},{"$f":"(AG36-AC36)/AG36","v":0},null,3,{"$f":"SUM(AJ36:AL36)+AE36","v":96.75},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":96.75},{"$f":"IF(VLOOKUP(AF36,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ36,1)-AJ36,2),Round,2,FALSE)+VLOOKUP(AF36,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",0,ROUND(AJ36-0.04999,1)-AJ36+AM36)","v":0},{"$f":"IF(VLOOKUP(AF36,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF36,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,"3.7\" x 24\"",null,"Bullnose BT 60",null,null,"Natural",null,null,null,null,null,"13 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA38,AG38)","v":16.600000000000001},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":16.600000000000001},null,"YES",16.600000000000001,{"$f":"+W38","v":0},{"$f":"+X38","v":16.600000000000001},{"$f":"(AG38-AC38)/AG38","v":0},null,2,{"$f":"SUM(AJ38:AL38)+AE38","v":16.600000000000001},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":16.600000000000001},{"$f":"IF(VLOOKUP(AF38,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ38,1)-AJ38,2),Round,2,FALSE)+VLOOKUP(AF38,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",0,ROUND(AJ38-0.04999,1)-AJ38+AM38)","v":0},{"$f":"IF(VLOOKUP(AF38,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF38,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,"13.1\" x 48\"",null,"Step G120",null,null,"Natural",null,null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":293.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":293.3},null,"YES",293.3,{"$f":"+W40","v":0},{"$f":"+X40","v":293.3},{"$f":"(AG40-AC40)/AG40","v":0},null,2,{"$f":"SUM(AJ40:AL40)+AE40","v":293.3},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":293.3},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 60",null,null,"Honed (LP)",null,null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":10.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":10.6},null,"YES",10.6,{"$f":"+W42","v":0},10.6,{"$f":"(AG42-AC42)/AG42","v":0},null,1,{"$f":"SUM(AJ42:AL42)+AE42","v":10.6},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":10.6},{"$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,"Field Tile",null,null,"24\" x 48\"",null,"Field 12",null,null,"Honed (LP)",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA43,AG43)","v":12.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA43*(1-W43)+0.004999,2)","v":12.45},null,"YES",12.45,0,12.45,{"$f":"(AG43-AC43)/AG43","v":0},null,1,{"$f":"SUM(AJ43:AL43)+AE43","v":12.45},null,null,{"$f":"ROUND(AC43/(1-VLOOKUP(AF43,Group,2,FALSE)),2)","v":12.45},{"$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,"Field Tile",null,null,"48\" x 48\"",null,"Field 120",null,null,"Honed (LP)",null,null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA44,AG44)","v":14.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA44*(1-W44)+0.004999,2)","v":14.45},null,"YES",14.45,0,14.45,{"$f":"(AG44-AC44)/AG44","v":0},null,1,{"$f":"SUM(AJ44:AL44)+AE44","v":14.45},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":14.45},{"$f":"IF(VLOOKUP(AF44,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ44,1)-AJ44,2),Round,2,FALSE)+VLOOKUP(AF44,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",0,ROUND(AJ44-0.04999,1)-AJ44+AM44)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF44,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 RB36",null,null,"Rustic (Bush Hammered)",null,null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA46,AG46)","v":9.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":9.15},null,"YES",9.15,{"$f":"+W46","v":0},{"$f":"+X46","v":9.15},{"$f":"(AG46-AC46)/AG46","v":0},null,1,{"$f":"SUM(AJ46:AL46)+AE46","v":9.15},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":9.15},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ46,1)-AJ46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",0,ROUND(AJ46-0.04999,1)-AJ46+AM46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF46,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field RB60",null,null,"Rustic (Bush Hammered)",null,null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":9.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":9.8000000000000007},null,"YES",9.8000000000000007,{"$f":"+W47","v":0},{"$f":"+X47","v":9.8000000000000007},{"$f":"(AG47-AC47)/AG47","v":0},null,1,{"$f":"SUM(AJ47:AL47)+AE47","v":9.8000000000000007},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":9.8000000000000007},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"KOSHI - Full Body Porcelain",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Item # Lookup:","IMKO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","A (Almond)",null,"   CE (Cement)",null,null,null,"G (Gray)",null,"  T (Brown)",null,null," "]
[null,null,null,null,"B (Beige)",null,"   DG (Dark Gray)",null,null,null,"N (Black)",null,"  W (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 36",null,null,"Natural",null,null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA54,AG54)","v":7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":7},null,"YES",7,{"$f":"+W54","v":0},7,{"$f":"(AG54-AC54)/AG54","v":0},null,1,{"$f":"SUM(AJ54:AL54)+AE54","v":7},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":7},{"$f":"IF(VLOOKUP(AF54,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ54,1)-AJ54,2),Round,2,FALSE)+VLOOKUP(AF54,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",0,ROUND(AJ54-0.04999,1)-AJ54+AM54)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF54,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field 36",null,null,"Natural Rectified",null,null,null,null,null,"11.63 SF/CTN","Stock",null,7.5,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.5,null,"YES",7.5,0,7.5,0,null,1,7.5,null,null,7.5,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field 60",null,null,"Natural Rectified",null,null,null,null,null,"11.63 SF/CTN",null,null,8.0500000000000007,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.0500000000000007,null,"YES",8.0500000000000007,{"$f":"+W56","v":0},8.0500000000000007,0,null,1,8.0500000000000007,null,null,8.0500000000000007,0,0,"",null,"X"]
[null,"Field Tile",null,null,"30\" x 30\"",null,"Field 75",null,null,"Natural Rectified",null,null," ",null,null,"12.11 SF/CTN",null,null,8.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},8.9,null,"YES",8.9,0,8.9,0,null,1,8.9,null,null,8.9,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field 12",null,null,"Natural Rectified",null,null," ",null,null,"15.50 SF/CTN",null,null,9.9,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.9,null,"YES",9.9,0,9.9,0,null,1,9.9,null,null,9.9,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 MK 30",null,null,"Natural Rectified",null,null,null,null,null,"3.88 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",AA60,AG60)","v":21.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA60*(1-W60)+0.004999,2)","v":21.85},null,"YES",21.85,{"$f":"+W60","v":0},{"$f":"+X60","v":21.85},{"$f":"(AG60-AC60)/AG60","v":0},null,3,{"$f":"SUM(AJ60:AL60)+AE60","v":21.85},null,null,{"$f":"ROUND(AC60/(1-VLOOKUP(AF60,Group,2,FALSE)),2)","v":21.85},{"$f":"IF(VLOOKUP(AF60,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ60,1)-AJ60,2),Round,2,FALSE)+VLOOKUP(AF60,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",0,ROUND(AJ60-0.04999,1)-AJ60+AM60)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF60,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 24\"",null,"Mosaic MU 36",null,null,"Natural Rectified",null,null,null,null,null,"4 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA61,AG61)","v":56.15},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA61*(1-W61)+0.004999,2)","v":56.15},null,"YES",56.15,{"$f":"+W61","v":0},{"$f":"+X61","v":56.15},{"$f":"(AG61-AC61)/AG61","v":0},null,3,{"$f":"SUM(AJ61:AL61)+AE61","v":56.15},null,null,{"$f":"ROUND(AC61/(1-VLOOKUP(AF61,Group,2,FALSE)),2)","v":56.15},{"$f":"IF(VLOOKUP(AF61,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ61,1)-AJ61,2),Round,2,FALSE)+VLOOKUP(AF61,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF61,Group,7,FALSE)=\"\",0,ROUND(AJ61-0.04999,1)-AJ61+AM61)","v":0},{"$f":"IF(VLOOKUP(AF61,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF61,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,"24\" x 24\"",null,"Décor  1",null,null,"Natural Rectified",null,null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA63,AG63)","v":140.69999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA63*(1-W63)+0.004999,2)","v":140.69999999999999},null,"YES",140.69999999999999,{"$f":"+W63","v":0},{"$f":"+X63","v":140.69999999999999},{"$f":"(AG63-AC63)/AG63","v":0},null,3,{"$f":"SUM(AJ63:AL63)+AE63","v":140.69999999999999},null,null,{"$f":"ROUND(AC63/(1-VLOOKUP(AF63,Group,2,FALSE)),2)","v":140.69999999999999},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3.7\" x 24\"",null,"Bullnose BT60",null,null,"Natural Rectified",null,null,null,null,null,"13 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA65,AG65)","v":16.350000000000001},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA65*(1-W65)+0.004999,2)","v":16.350000000000001},null,"YES",16.350000000000001,{"$f":"+W65","v":0},16.350000000000001,{"$f":"(AG65-AC65)/AG65","v":0},null,2,{"$f":"SUM(AJ65:AL65)+AE65","v":16.350000000000001},null,null,{"$f":"ROUND(AC65/(1-VLOOKUP(AF65,Group,2,FALSE)),2)","v":16.350000000000001},{"$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,"Trim",null,null,"3.7\" x 30\"",null,"Bullnose BT75",null,null,"Natural Rectified",null,null,null,null,null,"10 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":20.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":20.5},null,"YES",20.5,0,20.5,{"$f":"(AG66-AC66)/AG66","v":0},null,2,{"$f":"SUM(AJ66:AL66)+AE66","v":20.5},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":20.5},{"$f":"IF(VLOOKUP(AF66,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ66,1)-AJ66,2),Round,2,FALSE)+VLOOKUP(AF66,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",0,ROUND(AJ66-0.04999,1)-AJ66+AM66)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF66,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,"Step S60",null,null,"Natural Rectified",null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA68,AG68)","v":39.450000000000003},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":39.450000000000003},null,"YES",39.450000000000003,{"$f":"+W68","v":0},{"$f":"+X68","v":39.450000000000003},{"$f":"(AG68-AC68)/AG68","v":0},null,2,{"$f":"SUM(AJ68:AL68)+AE68","v":39.450000000000003},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":39.450000000000003},{"$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,"Note:","a) Stocked in color W (White) 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,"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,"MICRON - COMMERCIAL QUOTES AVAILABLE UPON REQUEST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"MICRON 2.0 - Full Body Porcelain (Rectified)",null,null,null,null,null,null,null,null," ",null," ",null,null,null,"Item # Lookup:","IMM2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","A (Almond)",null,"  DG (Dark Grey)",null,null,"         GH (Ghiaccio)",null,null,"     T (Brown)"]
[null,null,null,null,"B (Beige)",null,"  G (Grey)",null,null,"         N (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,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field 36",null,null,null,"Natural",null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA79,AG79)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA79*(1-W79)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+W79","v":0},{"$f":"+X79","v":8.75},{"$f":"(AG79-AC79)/AG79","v":0},null,1,{"$f":"SUM(AJ79:AL79)+AE79","v":8.75},null,null,{"$f":"ROUND(AC79/(1-VLOOKUP(AF79,Group,2,FALSE)),2)","v":8.75},{"$f":"IF(VLOOKUP(AF79,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ79,1)-AJ79,2),Round,2,FALSE)+VLOOKUP(AF79,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",0,ROUND(AJ79-0.04999,1)-AJ79+AM79)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF79,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field 60",null,null,null,"Natural",null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA80,AG80)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":9.4},null,"YES",9.4,{"$f":"+W80","v":0},9.4,{"$f":"(AG80-AC80)/AG80","v":0},null,1,{"$f":"SUM(AJ80:AL80)+AE80","v":9.4},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":9.4},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ80,1)-AJ80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AJ80-0.04999,1)-AJ80+AM80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field 12",null,null,null,"Natural",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA81,AG81)","v":11.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA81*(1-W81)+0.004999,2)","v":11.2},null,"YES",11.2,0,11.2,{"$f":"(AG81-AC81)/AG81","v":0},null,1,{"$f":"SUM(AJ81:AL81)+AE81","v":11.2},null,null,{"$f":"ROUND(AC81/(1-VLOOKUP(AF81,Group,2,FALSE)),2)","v":11.2},{"$f":"IF(VLOOKUP(AF81,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ81,1)-AJ81,2),Round,2,FALSE)+VLOOKUP(AF81,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",0,ROUND(AJ81-0.04999,1)-AJ81+AM81)","v":0},{"$f":"IF(VLOOKUP(AF81,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF81,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"48\" x 48\"",null,"Field 120",null,null,null,"Natural",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":13.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":13.25},null,"YES",13.25,0,13.25,{"$f":"(AG82-AC82)/AG82","v":0},null,1,{"$f":"SUM(AJ82:AL82)+AE82","v":13.25},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":13.25},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ82,1)-AJ82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AJ82-0.04999,1)-AJ82+AM82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,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:","W (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 36",null,null,null,"Natural",null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA86,AG86)","v":9.5500000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":9.5500000000000007},null,"YES",9.5500000000000007,{"$f":"+W86","v":0},{"$f":"+X86","v":9.5500000000000007},{"$f":"(AG86-AC86)/AG86","v":0},null,1,{"$f":"SUM(AJ86:AL86)+AE86","v":9.5500000000000007},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":9.5500000000000007},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field 60",null,null,null,"Natural",null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA87,AG87)","v":10.199999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA87*(1-W87)+0.004999,2)","v":10.199999999999999},null,"YES",10.199999999999999,{"$f":"+W87","v":0},10.199999999999999,{"$f":"(AG87-AC87)/AG87","v":0},null,1,{"$f":"SUM(AJ87:AL87)+AE87","v":10.199999999999999},null,null,{"$f":"ROUND(AC87/(1-VLOOKUP(AF87,Group,2,FALSE)),2)","v":10.199999999999999},{"$f":"IF(VLOOKUP(AF87,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ87,1)-AJ87,2),Round,2,FALSE)+VLOOKUP(AF87,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",0,ROUND(AJ87-0.04999,1)-AJ87+AM87)","v":0},{"$f":"IF(VLOOKUP(AF87,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF87,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field 12",null,null,null,"Natural",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA88,AG88)","v":12},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":12},null,"YES",12,0,12,{"$f":"(AG88-AC88)/AG88","v":0},null,1,{"$f":"SUM(AJ88:AL88)+AE88","v":12},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":12},{"$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,"Field Tile",null,null,"48\" x 48\"",null,"Field 120",null,null,null,"Natural",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":14.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":14.15},null,"YES",14.15,0,14.15,{"$f":"(AG89-AC89)/AG89","v":0},null,1,{"$f":"SUM(AJ89:AL89)+AE89","v":14.15},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":14.15},{"$f":"IF(VLOOKUP(AF89,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ89,1)-AJ89,2),Round,2,FALSE)+VLOOKUP(AF89,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",0,ROUND(AJ89-0.04999,1)-AJ89+AM89)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF89,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:","A (Almond)",null,"  DG (Dark Grey)",null,null,"         GH (Ghiaccio)",null,null,"     T (Brown)"]
[null,null,null,null,"B (Beige)",null,"  G (Grey)",null,null,"         N (Black)",null,null,"     W (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,"Decos",null,null,"12\" X 12\"",null,"Mosaic MK 30",null,null,null,"Natural",null,null,null,null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA94,AG94)","v":25.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":25.75},null,"YES",25.75,{"$f":"+W94","v":0},{"$f":"+X94","v":25.75},{"$f":"(AG94-AC94)/AG94","v":0},null,3,{"$f":"SUM(AJ94:AL94)+AE94","v":25.75},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":25.75},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ94,1)-AJ94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AJ94-0.04999,1)-AJ94+AM94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,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,"4\" x 24\"",null,"Bullnose BT60",null,null,null,"Natural",null," ",null,null,"13 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA96,AG96)","v":16.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA96*(1-W96)+0.004999,2)","v":16.8},null,"YES",16.8,{"$f":"+W96","v":0},{"$f":"+X96","v":16.8},{"$f":"(AG96-AC96)/AG96","v":0},null,2,{"$f":"SUM(AJ96:AL96)+AE96","v":16.8},null,null,{"$f":"ROUND(AC96/(1-VLOOKUP(AF96,Group,2,FALSE)),2)","v":16.8},{"$f":"IF(VLOOKUP(AF96,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ96,1)-AJ96,2),Round,2,FALSE)+VLOOKUP(AF96,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",0,ROUND(AJ96-0.04999,1)-AJ96+AM96)","v":0},{"$f":"IF(VLOOKUP(AF96,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF96,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,"13.1\" x 48\"",null,"Step G120",null,null,null,"Natural",null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA98,AG98)","v":287.10000000000002},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":287.10000000000002},null,"YES",287.10000000000002,{"$f":"+W98","v":0},{"$f":"+X98","v":287.10000000000002},{"$f":"(AG98-AC98)/AG98","v":0},null,2,{"$f":"SUM(AJ98:AL98)+AE98","v":287.10000000000002},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":287.10000000000002},{"$f":"IF(VLOOKUP(AF98,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ98,1)-AJ98,2),Round,2,FALSE)+VLOOKUP(AF98,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",0,ROUND(AJ98-0.04999,1)-AJ98+AM98)","v":0},{"$f":"IF(VLOOKUP(AF98,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF98,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:","A (Almond)",null,"  DG (Dark Grey)",null,null,"         GH (Ghiaccio)",null,null,"     T (Brown)"]
[null,null,null,null,"B (Beige)",null,"  G (Grey)",null,null,"         N (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,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field 36",null,null,null,"Polished (L)",null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA103,AG103)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA103*(1-W103)+0.004999,2)","v":11.6},null,"YES",11.6,{"$f":"+W103","v":0},11.6,{"$f":"(AG103-AC103)/AG103","v":0},null,1,{"$f":"SUM(AJ103:AL103)+AE103","v":11.6},null,null,{"$f":"ROUND(AC103/(1-VLOOKUP(AF103,Group,2,FALSE)),2)","v":11.6},{"$f":"IF(VLOOKUP(AF103,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ103,1)-AJ103,2),Round,2,FALSE)+VLOOKUP(AF103,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",0,ROUND(AJ103-0.04999,1)-AJ103+AM103)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF103,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile"," ",null,"24\" x 24\"",null,"Field 60",null,null,null,"Polished (L)",null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA104,AG104)","v":12.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA104*(1-W104)+0.004999,2)","v":12.25},null,"YES",12.25,0,12.25,{"$f":"(AG104-AC104)/AG104","v":0},null,1,{"$f":"SUM(AJ104:AL104)+AE104","v":12.25},null,null,{"$f":"ROUND(AC104/(1-VLOOKUP(AF104,Group,2,FALSE)),2)","v":12.25},{"$f":"IF(VLOOKUP(AF104,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ104,1)-AJ104,2),Round,2,FALSE)+VLOOKUP(AF104,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",0,ROUND(AJ104-0.04999,1)-AJ104+AM104)","v":0},{"$f":"IF(VLOOKUP(AF104,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF104,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field 12",null,null,null,"Polished (L)",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA105,AG105)","v":14.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":14.1},null,"YES",14.1,0,14.1,{"$f":"(AG105-AC105)/AG105","v":0},null,1,{"$f":"SUM(AJ105:AL105)+AE105","v":14.1},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":14.1},{"$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,"48\" x 48\"",null,"Field 120",null,null,null,"Polished (L)",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA106,AG106)","v":16.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":16.100000000000001},null,"YES",16.100000000000001,0,16.100000000000001,{"$f":"(AG106-AC106)/AG106","v":0},null,1,{"$f":"SUM(AJ106:AL106)+AE106","v":16.100000000000001},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":16.100000000000001},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"continued on next page"]
[null,null,"MICRON 2.0 - Full Body Porcelain (Rectified) - continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","IMM2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","W (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 36",null,null,null,"Polished (L)",null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA113,AG113)","v":12.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA113*(1-W113)+0.004999,2)","v":12.35},null,"YES",12.35,{"$f":"+W113","v":0},12.35,{"$f":"(AG113-AC113)/AG113","v":0},null,1,{"$f":"SUM(AJ113:AL113)+AE113","v":12.35},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":12.35},{"$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 60",null,null,null,"Polished (L)",null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA114,AG114)","v":13.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA114*(1-W114)+0.004999,2)","v":13.05},null,"YES",13.05,0,13.05,{"$f":"(AG114-AC114)/AG114","v":0},null,1,{"$f":"SUM(AJ114:AL114)+AE114","v":13.05},null,null,{"$f":"ROUND(AC114/(1-VLOOKUP(AF114,Group,2,FALSE)),2)","v":13.05},{"$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,"Field Tile",null,null,"24\" x 48\"",null,"Field 12",null,null,null,"Polished (L)",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA115,AG115)","v":14.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA115*(1-W115)+0.004999,2)","v":14.85},null,"YES",14.85,0,14.85,{"$f":"(AG115-AC115)/AG115","v":0},null,1,{"$f":"SUM(AJ115:AL115)+AE115","v":14.85},null,null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":14.85},{"$f":"IF(VLOOKUP(AF115,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ115,1)-AJ115,2),Round,2,FALSE)+VLOOKUP(AF115,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",0,ROUND(AJ115-0.04999,1)-AJ115+AM115)","v":0},{"$f":"IF(VLOOKUP(AF115,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF115,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"48\" x 48\"",null,"Field 120",null,null,null,"Polished (L)",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA116,AG116)","v":17},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA116*(1-W116)+0.004999,2)","v":17},null,"YES",17,0,17,{"$f":"(AG116-AC116)/AG116","v":0},null,1,{"$f":"SUM(AJ116:AL116)+AE116","v":17},null,null,{"$f":"ROUND(AC116/(1-VLOOKUP(AF116,Group,2,FALSE)),2)","v":17},{"$f":"IF(VLOOKUP(AF116,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ116,1)-AJ116,2),Round,2,FALSE)+VLOOKUP(AF116,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",0,ROUND(AJ116-0.04999,1)-AJ116+AM116)","v":0},{"$f":"IF(VLOOKUP(AF116,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF116,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:","A (Almond)",null,"  DG (Dark Grey)",null,null,"         GH (Ghiaccio)",null,null,"     T (Brown)"]
[null,null,null,null,"B (Beige)",null,"  G (Grey)",null,null,"         N (Black)",null,null,"     W (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,"Decos",null,null,"12\" X 12\"",null,"Mosaic MK 30",null,null,null,"Polished (L)",null,null,null,null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA121,AG121)","v":29.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA121*(1-W121)+0.004999,2)","v":29.9},null,"YES",29.9,{"$f":"+W121","v":0},{"$f":"+X121","v":29.9},{"$f":"(AG121-AC121)/AG121","v":0},null,3,{"$f":"SUM(AJ121:AL121)+AE121","v":29.9},null,null,{"$f":"ROUND(AC121/(1-VLOOKUP(AF121,Group,2,FALSE)),2)","v":29.9},{"$f":"IF(VLOOKUP(AF121,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ121,1)-AJ121,2),Round,2,FALSE)+VLOOKUP(AF121,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",0,ROUND(AJ121-0.04999,1)-AJ121+AM121)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF121,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,"4\" x 24\"",null,"Bullnose BT60",null,null,null,"Polished (L)",null," ",null,null,"13 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA123,AG123)","v":22.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA123*(1-W123)+0.004999,2)","v":22.4},null,"YES",22.4,{"$f":"+W123","v":0},{"$f":"+X123","v":22.4},{"$f":"(AG123-AC123)/AG123","v":0},null,2,{"$f":"SUM(AJ123:AL123)+AE123","v":22.4},null,null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":22.4},{"$f":"IF(VLOOKUP(AF123,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ123,1)-AJ123,2),Round,2,FALSE)+VLOOKUP(AF123,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",0,ROUND(AJ123-0.04999,1)-AJ123+AM123)","v":0},{"$f":"IF(VLOOKUP(AF123,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF123,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:","A (Almond)",null,"  DG (Dark Grey)",null,null,"         GH (Ghiaccio)",null,null,"     T (Brown)"]
[null,null,null,null,"B (Beige)",null,"  G (Grey)",null,null,"         N (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,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field RB36",null,null,null,"Bush Hammered",null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA128,AG128)","v":9.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA128*(1-W128)+0.004999,2)","v":9.15},null,"YES",9.15,{"$f":"+W128","v":0},{"$f":"+X128","v":9.15},{"$f":"(AG128-AC128)/AG128","v":0},null,1,{"$f":"SUM(AJ128:AL128)+AE128","v":9.15},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":9.15},{"$f":"IF(VLOOKUP(AF128,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ128,1)-AJ128,2),Round,2,FALSE)+VLOOKUP(AF128,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",0,ROUND(AJ128-0.04999,1)-AJ128+AM128)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF128,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field RB60",null,null,null,"Bush Hammered",null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":9.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":9.8000000000000007},null,"YES",9.8000000000000007,{"$f":"+W129","v":0},{"$f":"+X129","v":9.8000000000000007},{"$f":"(AG129-AC129)/AG129","v":0},null,1,{"$f":"SUM(AJ129:AL129)+AE129","v":9.8000000000000007},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":9.8000000000000007},{"$f":"IF(VLOOKUP(AF129,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ129,1)-AJ129,2),Round,2,FALSE)+VLOOKUP(AF129,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",0,ROUND(AJ129-0.04999,1)-AJ129+AM129)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF129,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:","W (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 RB36",null,null,null,"Bush Hammered",null,null,null,null,"9.69 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA133,AG133)","v":9.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":9.9},null,"YES",9.9,{"$f":"+W133","v":0},{"$f":"+X133","v":9.9},{"$f":"(AG133-AC133)/AG133","v":0},null,1,{"$f":"SUM(AJ133:AL133)+AE133","v":9.9},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":9.9},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field RB60",null,null,null,"Bush Hammered",null,null,null,null,"11.63 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":10.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA134*(1-W134)+0.004999,2)","v":10.6},null,"YES",10.6,{"$f":"+W134","v":0},{"$f":"+X134","v":10.6},{"$f":"(AG134-AC134)/AG134","v":0},null,1,{"$f":"SUM(AJ134:AL134)+AE134","v":10.6},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":10.6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 ROOM - Full Body Porcelain (Rectified)",null,null,null,null,null,null,null,null," ",null," ",null,null,null,"Item # Lookup:","IMTH",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:","INF BR6",null,"  SAN PE6",null,null,null,null,null,null,null,null," ",null,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,"RM - Matte",null,null,null,null,null,null,"19.37 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",AA140,AG140)","v":7.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":7.75},null,"YES",7.75,{"$f":"+W140","v":0},{"$f":"+X140","v":7.75},{"$f":"(AG140-AC140)/AG140","v":0},null,1,{"$f":"SUM(AJ140:AL140)+AE140","v":7.75},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":7.75},{"$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,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"30.99 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA141,AG141)","v":9.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},9.4499999999999993,null,"YES",9.4499999999999993,0,9.4499999999999993,0,null,1,9.4499999999999993,null,null,9.4499999999999993,0,0,"",null,"X"]
[null,"Field Tile",null,null,"48\" x 48\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"30.99 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA142,AG142)","v":11.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},11.2,null,"YES",11.2,0,11.2,0,null,1,11.2,null,null,11.2,0,0,"",null,"X"]
[null,"Field Tile",null,null,"48\" x 103\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"33.57 SF/Slab",null,"c",{"$f":"IF(Suggested=\"Yes\",AA143,AG143)","v":15.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},15.1,null,"YES",15.1,0,15.1,0,null,1,15.1,null,null,15.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,"2\" x 2\" Mosaic",null,null,"Matte",null,null,null,null,null,"0.97 SF/SHEET","Stock","a,b",{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":18.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA145*(1-W145)+0.004999,2)","v":18.149999999999999},null,"YES",18.149999999999999,{"$f":"+W145","v":0},{"$f":"+X145","v":18.149999999999999},{"$f":"(AG145-AC145)/AG145","v":0},null,3,{"$f":"SUM(AJ145:AL145)+AE145","v":18.149999999999999},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":18.149999999999999},{"$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,"2.4\" x 48\"",null,"Bullnose",null,"RM - Matte",null,null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA147,AG147)","v":29.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA147*(1-W147)+0.004999,2)","v":29.4},null,"YES",29.4,{"$f":"+W147","v":0},{"$f":"+X147","v":29.4},{"$f":"(AG147-AC147)/AG147","v":0},null,2,{"$f":"SUM(AJ147:AL147)+AE147","v":29.4},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":29.4},{"$f":"IF(VLOOKUP(AF147,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ147,1)-AJ147,2),Round,2,FALSE)+VLOOKUP(AF147,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",0,ROUND(AJ147-0.04999,1)-AJ147+AM147)","v":0},{"$f":"IF(VLOOKUP(AF147,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF147,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"19.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA149,AG149)","v":10.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},10.45,null,"YES",10.45,0,10.45,0,null,1,10.45,null,null,10.45,0,0,"",null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"30.99 SF/CTN","Stock","a",{"$f":"IF(Suggested=\"Yes\",AA150,AG150)","v":12.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},12.15,null,"YES",12.15,0,12.15,0,null,1,12.15,null,null,12.15,0,0,"",null,"X"]
[null,"Field Tile",null,null,"48\" x 48\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"30.99 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA151,AG151)","v":13.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},13.85,null,"YES",13.85,0,13.85,0,null,1,13.85,null,null,13.85,0,0,"",null,"X"]
[null,"Field Tile",null,null,"48\" x 103\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"33.57 SF/Slab",null,"c",{"$f":"IF(Suggested=\"Yes\",AA152,AG152)","v":18.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA152*(1-W152)+0.004999,2)","v":18.8},null,"YES",18.8,{"$f":"+W152","v":0},{"$f":"+X152","v":18.8},{"$f":"(AG152-AC152)/AG152","v":0},null,1,{"$f":"SUM(AJ152:AL152)+AE152","v":18.8},null,null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":18.8},{"$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,"Trim",null,null,"2.4\" x 48\"",null,"Bullnose",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA154,AG154)","v":35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":35},null,"YES",35,{"$f":"+W154","v":0},{"$f":"+X154","v":35},{"$f":"(AG154-AC154)/AG154","v":0},null,2,{"$f":"SUM(AJ154:AL154)+AE154","v":35},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":35},{"$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,"Colors:","CRE DL6",null,"  STA VP6",null,null,null,null,null,null,null,null," ",null,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,"RM - Matte",null,null,null,null,null,null,"19.37 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA158,AG158)","v":8.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":8.4499999999999993},null,"YES",8.4499999999999993,{"$f":"+W158","v":0},8.4499999999999993,{"$f":"(AG158-AC158)/AG158","v":0},null,1,{"$f":"SUM(AJ158:AL158)+AE158","v":8.4499999999999993},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":8.4499999999999993},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"30.99 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA159,AG159)","v":10.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA159*(1-W159)+0.004999,2)","v":10.15},null,"YES",10.15,0,10.15,{"$f":"(AG159-AC159)/AG159","v":0},null,1,{"$f":"SUM(AJ159:AL159)+AE159","v":10.15},null,null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":10.15},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"48\" x 48\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"30.99 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA160,AG160)","v":12},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA160*(1-W160)+0.004999,2)","v":12},null,"YES",12,0,12,{"$f":"(AG160-AC160)/AG160","v":0},null,1,{"$f":"SUM(AJ160:AL160)+AE160","v":12},null,null,{"$f":"ROUND(AC160/(1-VLOOKUP(AF160,Group,2,FALSE)),2)","v":12},{"$f":"IF(VLOOKUP(AF160,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ160,1)-AJ160,2),Round,2,FALSE)+VLOOKUP(AF160,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF160,Group,7,FALSE)=\"\",0,ROUND(AJ160-0.04999,1)-AJ160+AM160)","v":0},{"$f":"IF(VLOOKUP(AF160,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF160,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"48\" x 103\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"33.57 SF/Slab",null,"c",{"$f":"IF(Suggested=\"Yes\",AA161,AG161)","v":15.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA161*(1-W161)+0.004999,2)","v":15.9},null,"YES",15.9,0,15.9,{"$f":"(AG161-AC161)/AG161","v":0},null,1,{"$f":"SUM(AJ161:AL161)+AE161","v":15.9},null,null,{"$f":"ROUND(AC161/(1-VLOOKUP(AF161,Group,2,FALSE)),2)","v":15.9},{"$f":"IF(VLOOKUP(AF161,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ161,1)-AJ161,2),Round,2,FALSE)+VLOOKUP(AF161,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",0,ROUND(AJ161-0.04999,1)-AJ161+AM161)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF161,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,"2\" x 2\" Mosaic",null,null,"Matte",null,null,null,null,null,"0.97 SF/SHEET","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA163,AG163)","v":18.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA163*(1-W163)+0.004999,2)","v":18.149999999999999},null,"YES",18.149999999999999,{"$f":"+W163","v":0},{"$f":"+X163","v":18.149999999999999},{"$f":"(AG163-AC163)/AG163","v":0},null,3,{"$f":"SUM(AJ163:AL163)+AE163","v":18.149999999999999},null,null,{"$f":"ROUND(AC163/(1-VLOOKUP(AF163,Group,2,FALSE)),2)","v":18.149999999999999},{"$f":"IF(VLOOKUP(AF163,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ163,1)-AJ163,2),Round,2,FALSE)+VLOOKUP(AF163,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",0,ROUND(AJ163-0.04999,1)-AJ163+AM163)","v":0},{"$f":"IF(VLOOKUP(AF163,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF163,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Trim",null,null,"2.4\" x 48\"",null,"Bullnose",null,"RM - Matte",null,null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA165,AG165)","v":29.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":29.4},null,"YES",29.4,{"$f":"+W165","v":0},{"$f":"+X165","v":29.4},{"$f":"(AG165-AC165)/AG165","v":0},null,2,{"$f":"SUM(AJ165:AL165)+AE165","v":29.4},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":29.4},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ165,1)-AJ165,2),Round,2,FALSE)+VLOOKUP(AF165,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",0,ROUND(AJ165-0.04999,1)-AJ165+AM165)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF165,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"19.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA167,AG167)","v":11.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA167*(1-W167)+0.004999,2)","v":11.15},null,"YES",11.15,{"$f":"+W167","v":0},11.15,{"$f":"(AG167-AC167)/AG167","v":0},null,1,{"$f":"SUM(AJ167:AL167)+AE167","v":11.15},null,null,{"$f":"ROUND(AC167/(1-VLOOKUP(AF167,Group,2,FALSE)),2)","v":11.15},{"$f":"IF(VLOOKUP(AF167,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ167,1)-AJ167,2),Round,2,FALSE)+VLOOKUP(AF167,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",0,ROUND(AJ167-0.04999,1)-AJ167+AM167)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF167,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 48\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"30.99 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA168,AG168)","v":12.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA168*(1-W168)+0.004999,2)","v":12.85},null,"YES",12.85,0,12.85,{"$f":"(AG168-AC168)/AG168","v":0},null,1,{"$f":"SUM(AJ168:AL168)+AE168","v":12.85},null,null,{"$f":"ROUND(AC168/(1-VLOOKUP(AF168,Group,2,FALSE)),2)","v":12.85},{"$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,"Field Tile",null,null,"48\" x 48\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"30.99 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA169,AG169)","v":14.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA169*(1-W169)+0.004999,2)","v":14.7},null,"YES",14.7,0,14.7,{"$f":"(AG169-AC169)/AG169","v":0},null,1,{"$f":"SUM(AJ169:AL169)+AE169","v":14.7},null,null,{"$f":"ROUND(AC169/(1-VLOOKUP(AF169,Group,2,FALSE)),2)","v":14.7},{"$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,"Field Tile",null,null,"48\" x 103\"",null,"Field",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"33.57 SF/Slab",null,"c",{"$f":"IF(Suggested=\"Yes\",AA170,AG170)","v":19.600000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA170*(1-W170)+0.004999,2)","v":19.600000000000001},null,"YES",19.600000000000001,0,19.600000000000001,{"$f":"(AG170-AC170)/AG170","v":0},null,1,{"$f":"SUM(AJ170:AL170)+AE170","v":19.600000000000001},null,null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":19.600000000000001},{"$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,"Trim",null,null,"2.4\" x 48\"",null,"Bullnose",null,"LP - Lappato (Polished)",null,null,null,null,null,null,"8 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA172,AG172)","v":35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA172*(1-W172)+0.004999,2)","v":35},null,"YES",35,{"$f":"+W172","v":0},{"$f":"+X172","v":35},{"$f":"(AG172-AC172)/AG172","v":0},null,2,{"$f":"SUM(AJ172:AL172)+AE172","v":35},null,null,{"$f":"ROUND(AC172/(1-VLOOKUP(AF172,Group,2,FALSE)),2)","v":35},{"$f":"IF(VLOOKUP(AF172,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ172,1)-AJ172,2),Round,2,FALSE)+VLOOKUP(AF172,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",0,ROUND(AJ172-0.04999,1)-AJ172+AM172)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF172,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) Not stocked in color INF BR6.",null,null,null,null,"b) Color INF BR6 is sold in full cartons only of 5.82 SF/CTN.",null,null,null,null,null,null,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,"c) Size is changing from 48\" x 103\" to 48\" x 110\" as inventories of the old size is depleted.  The 48\" x 110\" format is 35.90 SF/Slab.",null,null,null,null,null,null,null,null,null,null,null,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,"VIBES - Color Body Porcelain (Rectified)",null,null,null,null,null,null,null,null," ",null," ",null,null,null,"Item # Lookup:","IMVI",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:","B (Beige)",null,"  DG (Dark Grey)",null,null,"         W (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,"X"]
[null,null,null,null,"BS (Dark Beige)",null,"  G (Grey)"]
[]
[null,"Field Tile",null,null,"12\" x 24\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA182,AG182)","v":7.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA182*(1-W182)+0.004999,2)","v":7.3},null,"YES",7.3,{"$f":"+W182","v":0},{"$f":"+X182","v":7.3},{"$f":"(AG182-AC182)/AG182","v":0},null,1,{"$f":"SUM(AJ182:AL182)+AE182","v":7.3},null,null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":7.3},{"$f":"IF(VLOOKUP(AF182,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ182,1)-AJ182,2),Round,2,FALSE)+VLOOKUP(AF182,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",0,ROUND(AJ182-0.04999,1)-AJ182+AM182)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF182,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,"RM - Matte",null,null,null,null,null,null,"11.62 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":7.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},7.75,null,"YES",7.75,0,7.75,0,null,1,7.75,null,null,7.75,0,0,"",null,"X"]
[]
[null,"Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,"Matte",null,null,null,null,null,"0.97 SF/SHEET","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA185,AG185)","v":15.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA185*(1-W185)+0.004999,2)","v":15.3},null,"YES",15.3,{"$f":"+W185","v":0},{"$f":"+X185","v":15.3},{"$f":"(AG185-AC185)/AG185","v":0},null,3,{"$f":"SUM(AJ185:AL185)+AE185","v":15.3},null,null,{"$f":"ROUND(AC185/(1-VLOOKUP(AF185,Group,2,FALSE)),2)","v":15.3},{"$f":"IF(VLOOKUP(AF185,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ185,1)-AJ185,2),Round,2,FALSE)+VLOOKUP(AF185,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",0,ROUND(AJ185-0.04999,1)-AJ185+AM185)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF185,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,"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."]
["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":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","http://www.ccimola.net/en/northamerica"]
[]
[]
["Product","Direct Website Link"]
["Concrete Project","http://www.imolaceramica.com/en/imolaceramica/products/tiles/concrete-project"]
["Koshi","http://www.imolaceramica.com/en/imolaceramica/products/tiles/koshi"]
["Micron 2.0","http://www.imolaceramica.com/en/products/collection/micron-2-0/"]
["The Room","https://www.imolaceramica.com/en/collections/the-room"]
["Vibes","https://imolaceramica.com/en/collections/vibes"]

{"sheet":"Changes","index":4,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2008-12-01","ROCHELLE","Glazed Porcelain"]
["2012-05-14","BEESTONE","Full Body Porcelain"]
["2012-05-14","BILDER","Full Body Porcelain"]
["2012-05-14","CONCRETE PROJECT","Full Body Porcelain"]
["2012-05-14","KOSHI","Full Body Porcelain"]
["2012-05-14","MAGMA","Full Body Porcelain"]
["2013-07-18","VEIN","Full Body Porcelain"]
["2015-04-17","Cento per cento","Glazed Ceramic Wall Tile"]
["2015-04-17","Imola 1874","Glazed Ceramic Wall Tile"]
["2015-04-17","Micron 2.0","Full Body Porcelain"]
["2019-08-21","The Room","Full Body Porcelain"]
["2020-04-10","Let It Bee","Glazed Ceramic Wall Tile."]
["2020-11-23","Koshi","12\" x 12\" Rectified Natural Field 30 format added and is available in all colors."]
["2023-02-03","Vibes","Color Body Porcelain"]
[]
[]
["Discontinued Products"]
["2009-04-27","JULIA","Colors 35R & 35V "]
["2009-08-05","Pietre D'Italia","(disc. by CCTD; Still available special order from Imola)"]
["2010-03-08","Etnea","Color Grey not available in 17\" x 17\" field tile."]
["2010-08-31","Cotto Del Casale","Bullnose Corners not available in colors R (Red) and T (Brown)."]
["2011-04-12","JULIA","Entire Line"]
["2011-07-07","ROCHELLE","Entire Line"]
["2012-03-12","Cotto Del Casale","Entire Series.  (Discontinued by Imola 2/14/14.)"]
["2012-05-14","Saloon","6\" x 6\" Bullnose Corner in all colors."]
["2014-02-14","Altair","Entire Series.  (Discontinued by Imola 2/14/14.)"]
["2014-02-14","Bilder","Entire Series.  (Discontinued by Imola 2/14/14.)"]
["2014-02-14","Domus Aurea","Entire Series.  (Discontinued by Imola 2/14/14.)"]
["2014-02-14","Midtown","Entire Series.  (Discontinued by Imola 2/14/14.)"]
["2015-04-17","Etnea","Entire Series.  (Discontinued by Conestoga.)"]
["2015-04-17","Saloon","Entire Series.  (Discontinued by Conestoga.)"]
["2015-10-26","Beestone","5.6\" x 5.6\" Natural Tumbled Field BR15, 3.7\" x 18\" Natural Bullnose BT45 and 12.8\" x 36\" Natural Step A90 Left (SX) & Right (DX) only in all colors.  (Discontinued by Imola)"]
["2015-10-26","Magma","Entire Series.  (Discontinued by Imola)"]
["2016-10-11","Beestone","Entire Series.  (Discontinued by Imola)"]
["2016-10-11","Micron","All formats and finishes in Colors DL, DV, L, M, R, & T.  All formats in the Bush-Hammered Rustic, (RB) and Slate Cut, (RR) finishes.  The following Field Tile formats in all colors:  4\" x 4\", 6\" x 6\", 4\" x 12\", 2\" x 24\", 4\" x 24\" & 6\" x 24\".  (Discontinued by Imola)"]
["2016-10-11","Micron 2.0","12\" x 24\" Natural MUD 36 Mosaic in all colors.  (Discontinued by Imola)"]
["2017-09-15","Antares","The following Field Tile formats in all colors:  4\" x 4\", 6-1/2\" x 6-1/2\" & 13.1\" x 13.1\".  (Discontinued by Imola)"]
["2017-09-15","Concrete Project","12\" x 24\" Honed (LP) Field 36 format in all colors.  (Discontinued by Imola)"]
["2017-09-15","Kuni","6\" x 24\" Field Tile format in all colors.  (Discontinued by Imola)"]
["2017-09-15","Micron","12\" x 12\" and 18\" x 18\" Polished (L) Field Tile formats in all colors.  4\" x 12\" and 4\" x 18\" Polished (L) Bullnose formats in all colors.  *Note:  This is the original Micron, NOT Micron 2.0*  (Discontinued by Imola)"]
["2017-09-15","Opificio Delle Pietre","Entire Series.  (Discontinued by Imola)"]
["2017-09-15","Pietre D'Italia","Entire Series.  (Discontinued by Imola)"]
["2018-02-26","Vein","Entire Series.  (Discontinued by CCTD)"]
["2018-06-19","Concrete Project","Colors MU (Brown) and R (Red) in all formats.  4\" x 48\" Décor L 10, 8\" x 48\" Décor L 20, 12\" x 48\" Décor L 30 and 12\" x 48\" Décor L 3D 30 in all colors.  12\" x 24\" Field R36 Rustic (Milled) and 24\" x 48\" Field R12 Rustic (Milled) formats in all colors.  (Discontinued by Imola)"]
["2018-06-19","Imola 1874","0.8\" x 0.8\" A.Imola 2 Liner Corner and 2\" x 0.6\" A.Imola 5 Chair Rail Corner in all colors."]
["2018-06-19","Koshi","18\" x 36\" Field 49 Natural Rectified in all colors."]
["2018-06-19","Micron 2.0","24\" x 48\" Step Kit 12 Polished (L) in all colors."]
["2018-06-19","Vein","3.7\" x 18\" VEIN A BT45 and VEIN B BT45 Natural Bullnose in all colors."]
["2018-08-31","Imola 1874","Entire Series.  (Discontinued by Imola)"]
["2018-08-31","Vein","All 24\" x 24\" Field Tile in Vein A and Vein B, Natural and Polished formats.  All MU 12\" x 24\" Linear Mosaics in Vein A and Vein B, Natural and Polished formats.  (Discontinued by Imola)"]
["2020-01-02","Vein","Entire Series.  (Discontinued by Imola)"]
["2020-04-01","Cento per Cento","Entire Series.  (Discontinued by CCTD)"]
["2020-11-19","Antares","Entire Series.  (Discontinued by Imola)"]
["2020-11-23","Concrete Project","13.1\" x 48\" Left (SX) Step A120 Natural and 13.1\" x 48\" Right (DX) Step A120 Natural Stair Treads only in all colors.  (Discontinued by Imola)"]
["2020-11-23","Koshi","12\" x 12\" Natural Field 30 and 3.7\" x 12\" Natural BT30 Bullonse in all colors.  (Discontinued by Imola)"]
["2020-11-23","Micron 2.0","13.1\" x 48\" Left (SX) Step A120 Natural Stair Tread, 13.1\" x 48\" Right (DX) Step A120 Natural Stair Tread and the 4\" x 24\"  BT RB60 Bush Hammered Bullnose in all colors.  (Discontinued by Imola)"]
["2022-05-27","Koshi","12\" x 24\" Non-Rectified Field Tile format in all colors."]
["2023-11-14","Concrete Project","24\" x 48\" Natural Step Kit 12 format only in all colors.  ",null,null,"(Discontinued by Imola)"]
["2023-11-14","Koshi","18\" x 18\" Natural Field Tile and 3.7\" x 18\" Natural Bullnose formats only in all colors.  ",null,null,"(Discontinued by Imola)"]
["2023-11-14","Micron 2.0","12\" x 24\" Bush Hammered Step S RB60 and the 6\" x 12\" x 1/2\" Bush Hammered \"L\" Shaped E RB30 only in all colors.",null,null,"(Discontinued by Imola)"]
["2023-11-14","The Room","The GHEPARD6 and ZEBRA6 Polished Decorative in the sizes 24\" x 48\", 48\" x 48\" and 48\" x 103\" only.",null,null,"(Discontinued by Imola)"]
[]
[]
[]
["Changes"]
["2022-06-08","Koshi","Was informed that the 18\" x 18\" Field Tile is only available in the Non-Rectified format in all colors."]
["2023-11-14","The Room","Size is changing from 48\" x 103\" to 48\" x 110\" as inventories of the old size is depleted.  The 48\" x 110\" format is 35.90 SF/Slab."]