{"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":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Lea Ceramiche"]
["File as","L"]
["Product Code","B"]
["CCTD Effective Date","4/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,"Import I - Field Tile",null,"No",0]
[null,5,null,"Import I - Trim",null,"No",0]
[null,6,null,"Import I - Decos",null,"No",0]
[null,7,null,0,null,"No",0]
[null,8,null,0,null,"No",0]
[null,9,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":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,0,5,10],[46,0,46,10],[48,0,48,10],[2,5,2,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'L' - Lea Ceramiche"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 4/1/24"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type"]
[1,null,"Anthology",null,"Full-Body Porcelain"]
[1,null,"Masterpiece",null,"Full-Body Porcelain"]
[2,null,"Side Stone",null,"Full-Body Porcelain"]
[2,null,"The Rock",null,"Full-Body Porcelain"]
["2-3",null,"Waterfall",null,"Full-Body Porcelain"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":277,"n_cols":41,"rows_kept":277,"cut":false,"hidden":false,"merged":[[11,25,11,32],[261,2,261,19],[14,14,14,19],[16,13,17,19],[15,30,15,32],[14,22,14,23],[12,14,12,15],[11,14,11,19],[11,22,11,23],[266,3,266,4],[20,2,20,19],[19,14,19,15],[263,2,263,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,"Import I - Field Tile",null,null,"Size",null,"Field",null,"Description",null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"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,"Import I - Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"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,"Import I - Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"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,{"$error":"#VALUE!"},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$error":"#VALUE!"},null,"new",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},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\",AA8,AG8)","v":{"$error":"#VALUE!"}},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA8*(1-W8)+0.004999,2)","v":{"$error":"#VALUE!"}},null,"new",{"$error":"#VALUE!"},{"$f":"+W8","v":0},{"$f":"+X8","v":{"$error":"#VALUE!"}},{"$f":"(AG8-AC8)/AG8","v":{"$error":"#VALUE!"}},null,8,{"$f":"SUM(AJ8:AL8)+AE8","v":{"$error":"#VALUE!"}},null,null,{"$f":"ROUND(AC8/(1-VLOOKUP(AF8,Group,2,FALSE)),2)","v":{"$error":"#VALUE!"}},{"$f":"IF(VLOOKUP(AF8,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ8,1)-AJ8,2),Round,2,FALSE)+VLOOKUP(AF8,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",0,ROUND(AJ8-0.04999,1)-AJ8+AM8)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF8,Group,7,FALSE))","v":""},null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA9,AG9)","v":{"$error":"#VALUE!"}},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA9*(1-W9)+0.004999,2)","v":{"$error":"#VALUE!"}},null,"new",{"$error":"#VALUE!"},{"$f":"+W9","v":0},{"$f":"+X9","v":{"$error":"#VALUE!"}},{"$f":"(AG9-AC9)/AG9","v":{"$error":"#VALUE!"}},null,9,{"$f":"SUM(AJ9:AL9)+AE9","v":{"$error":"#VALUE!"}},null,null,{"$f":"ROUND(AC9/(1-VLOOKUP(AF9,Group,2,FALSE)),2)","v":{"$error":"#VALUE!"}},{"$f":"IF(VLOOKUP(AF9,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ9,1)-AJ9,2),Round,2,FALSE)+VLOOKUP(AF9,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF9,Group,7,FALSE)=\"\",0,ROUND(AJ9-0.04999,1)-AJ9+AM9)","v":0},{"$f":"IF(VLOOKUP(AF9,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF9,Group,7,FALSE))","v":""},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\",AA13,AG13)","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 'L' - Lea Ceramiche"},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":"4/1/24"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-03-11"},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$13","v":"List Price"},"U/M",{"$f":"+U$13","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$13","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$13","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"ALL ITEMS MARKED WITH PACKAGING QUANTITY ARE SOLD IN MULTIPLES OF THAT QUANTITY ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"ANTHOLOGY - Full-Body Porcelain  (Minimum 6-8 Week Delivery)",null,null,null,null,null,null,null,null,null,null,"    ","  ",null,null,"Item # Lookup:","LEAN",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:","Dark          Desert          Earth          Gray          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,"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,"Slimtech 6mm Thickness:",null,null,null,null,null,null,"   ",null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA29,AG29)","v":11.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA29*(1-W29)+0.004999,2)","v":11.05},null,"new",11.05,{"$f":"+W29","v":0},{"$f":"+X29","v":11.05},{"$f":"(AG29-AC29)/AG29","v":0},null,4,{"$f":"SUM(AJ29:AL29)+AE29","v":11.05},null,null,{"$f":"ROUND(AC29/(1-VLOOKUP(AF29,Group,2,FALSE)),2)","v":11.05},{"$f":"IF(VLOOKUP(AF29,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ29,1)-AJ29,2),Round,2,FALSE)+VLOOKUP(AF29,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF29,Group,7,FALSE)=\"\",0,ROUND(AJ29-0.04999,1)-AJ29+AM29)","v":0},{"$f":"IF(VLOOKUP(AF29,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF29,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"48\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"31.00 SF/CTN",null,null,12,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":12},null,"new",12,0,12,0,null,4,12,null,null,12,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"48\" x 48\" Plus",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"31.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":14.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":14.25},null,"new",14.25,{"$f":"+W31","v":0},{"$f":"+X31","v":14.25},{"$f":"(AG31-AC31)/AG31","v":0},null,4,{"$f":"SUM(AJ31:AL31)+AE31","v":14.25},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":14.25},{"$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,"Import I - Field Tile",null,null,"48\" x 109-1/2\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"35.95 SF/SLAB",null,"b",{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":14.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":14.8},null,"new",14.8,{"$f":"+W32","v":0},{"$f":"+X32","v":14.8},{"$f":"(AG32-AC32)/AG32","v":0},null,4,{"$f":"SUM(AJ32:AL32)+AE32","v":14.8},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":14.8},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"9mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA36,AG36)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+W36","v":0},8.75,{"$f":"(AG36-AC36)/AG36","v":0},null,4,{"$f":"SUM(AJ36:AL36)+AE36","v":8.75},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":8.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,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA37,AG37)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":8.75},null,"YES",8.75,0,8.75,{"$f":"(AG37-AC37)/AG37","v":0},null,4,{"$f":"SUM(AJ37:AL37)+AE37","v":8.75},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":8.75},{"$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,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA38,AG38)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":10.55},null,"YES",10.55,0,10.55,{"$f":"(AG38-AC38)/AG38","v":0},null,4,{"$f":"SUM(AJ38:AL38)+AE38","v":10.55},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":10.55},{"$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,"Import I - Field Tile",null,null,"5-3/4\" x 19-1/2\"",null,"Field - Gramma 72",null,null,null,"Natural/Rectified",null,null,null,null,"10.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":14.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":14.2},null,"YES",14.2,{"$f":"+W40","v":0},{"$f":"+X40","v":14.2},{"$f":"(AG40-AC40)/AG40","v":0},null,4,{"$f":"SUM(AJ40:AL40)+AE40","v":14.2},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":14.2},{"$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,"Import I - Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":15.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":15.6},null,"YES",15.6,{"$f":"+W42","v":0},{"$f":"+X42","v":15.6},{"$f":"(AG42-AC42)/AG42","v":0},null,6,{"$f":"SUM(AJ42:AL42)+AE42","v":15.6},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":15.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,"Import I - Decos",null,null,"12\" x 24\"",null,"Muretto Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA43,AG43)","v":18.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA43*(1-W43)+0.004999,2)","v":18.05},null,"YES",18.05,{"$f":"+W43","v":0},{"$f":"+X43","v":18.05},{"$f":"(AG43-AC43)/AG43","v":0},null,6,{"$f":"SUM(AJ43:AL43)+AE43","v":18.05},null,null,{"$f":"ROUND(AC43/(1-VLOOKUP(AF43,Group,2,FALSE)),2)","v":18.05},{"$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,"Import I - Trim",null,null,"3\" x 24\"",null,"Bullnose",null,null,null,"Natural",null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA45,AG45)","v":12.35},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":12.35},null,"YES",12.35,{"$f":"+W45","v":0},{"$f":"+X45","v":12.35},{"$f":"(AG45-AC45)/AG45","v":0},null,5,{"$f":"SUM(AJ45:AL45)+AE45","v":12.35},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":12.35},{"$f":"IF(VLOOKUP(AF45,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ45,1)-AJ45,2),Round,2,FALSE)+VLOOKUP(AF45,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",0,ROUND(AJ45-0.04999,1)-AJ45+AM45)","v":0},{"$f":"IF(VLOOKUP(AF45,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF45,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Rough/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA47,AG47)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA47*(1-W47)+0.004999,2)","v":9.4},null,"YES",9.4,{"$f":"+W47","v":0},9.4,{"$f":"(AG47-AC47)/AG47","v":0},null,4,{"$f":"SUM(AJ47:AL47)+AE47","v":9.4},null,null,{"$f":"ROUND(AC47/(1-VLOOKUP(AF47,Group,2,FALSE)),2)","v":9.4},{"$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,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Rough/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA48,AG48)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA48*(1-W48)+0.004999,2)","v":9.4},null,"YES",9.4,0,9.4,{"$f":"(AG48-AC48)/AG48","v":0},null,4,{"$f":"SUM(AJ48:AL48)+AE48","v":9.4},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":9.4},{"$f":"IF(VLOOKUP(AF48,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ48,1)-AJ48,2),Round,2,FALSE)+VLOOKUP(AF48,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",0,ROUND(AJ48-0.04999,1)-AJ48+AM48)","v":0},{"$f":"IF(VLOOKUP(AF48,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF48,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Rough/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA49,AG49)","v":11.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA49*(1-W49)+0.004999,2)","v":11.45},null,"YES",11.45,0,11.45,{"$f":"(AG49-AC49)/AG49","v":0},null,4,{"$f":"SUM(AJ49:AL49)+AE49","v":11.45},null,null,{"$f":"ROUND(AC49/(1-VLOOKUP(AF49,Group,2,FALSE)),2)","v":11.45},{"$f":"IF(VLOOKUP(AF49,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ49,1)-AJ49,2),Round,2,FALSE)+VLOOKUP(AF49,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,7,FALSE)=\"\",0,ROUND(AJ49-0.04999,1)-AJ49+AM49)","v":0},{"$f":"IF(VLOOKUP(AF49,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF49,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Worn/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA51,AG51)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA51*(1-W51)+0.004999,2)","v":9.4},null,"YES",9.4,{"$f":"+W51","v":0},9.4,{"$f":"(AG51-AC51)/AG51","v":0},null,4,{"$f":"SUM(AJ51:AL51)+AE51","v":9.4},null,null,{"$f":"ROUND(AC51/(1-VLOOKUP(AF51,Group,2,FALSE)),2)","v":9.4},{"$f":"IF(VLOOKUP(AF51,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ51,1)-AJ51,2),Round,2,FALSE)+VLOOKUP(AF51,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",0,ROUND(AJ51-0.04999,1)-AJ51+AM51)","v":0},{"$f":"IF(VLOOKUP(AF51,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF51,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Worn/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA52,AG52)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA52*(1-W52)+0.004999,2)","v":9.4},null,"YES",9.4,0,9.4,{"$f":"(AG52-AC52)/AG52","v":0},null,4,{"$f":"SUM(AJ52:AL52)+AE52","v":9.4},null,null,{"$f":"ROUND(AC52/(1-VLOOKUP(AF52,Group,2,FALSE)),2)","v":9.4},{"$f":"IF(VLOOKUP(AF52,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ52,1)-AJ52,2),Round,2,FALSE)+VLOOKUP(AF52,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",0,ROUND(AJ52-0.04999,1)-AJ52+AM52)","v":0},{"$f":"IF(VLOOKUP(AF52,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF52,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Worn/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA53,AG53)","v":11.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":11.45},null,"YES",11.45,0,11.45,{"$f":"(AG53-AC53)/AG53","v":0},null,4,{"$f":"SUM(AJ53:AL53)+AE53","v":11.45},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":11.45},{"$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,"Import I - Decos",null,null,"11-1/2\" x 12-1/4\"",null,"Break Mosaic",null,null,null,"Worn",null,null,"(Mesh-Mounted)",null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA55,AG55)","v":30.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":30.1},null,"YES",30.1,{"$f":"+W55","v":0},{"$f":"+X55","v":30.1},{"$f":"(AG55-AC55)/AG55","v":0},null,6,{"$f":"SUM(AJ55:AL55)+AE55","v":30.1},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":30.1},{"$f":"IF(VLOOKUP(AF55,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ55,1)-AJ55,2),Round,2,FALSE)+VLOOKUP(AF55,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",0,ROUND(AJ55-0.04999,1)-AJ55+AM55)","v":0},{"$f":"IF(VLOOKUP(AF55,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF55,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,"System L2 20mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"24\" x 48\" x 20mm",null,"Field",null,null,null,"Rough/Rectified",null,null,null,null,"7.75 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":15.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":15.75},null,"YES",15.75,{"$f":"+W59","v":0},{"$f":"+X59","v":15.75},{"$f":"(AG59-AC59)/AG59","v":0},null,4,{"$f":"SUM(AJ59:AL59)+AE59","v":15.75},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":15.75},{"$f":"IF(VLOOKUP(AF59,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ59,1)-AJ59,2),Round,2,FALSE)+VLOOKUP(AF59,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",0,ROUND(AJ59-0.04999,1)-AJ59+AM59)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF59,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,"Notes:","Specially treated with Microban antimicrobial protection that is incorporated into the tile surface.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"a) Reinforced w/fiberglass, 6.5mm thick.",null,null,null,null,null,"b) Crate charges may apply.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"c) Not specially treated with Microban antimicrobial protection that is incorporated into the tile surface.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"MASTERPIECE - Full-Body Porcelain  (Minimum 6-8 Week Delivery)",null,null,null,null,null,null,null,null,null,null,null," ",null,null,"Item # Lookup:","LEMA",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:","Alpi          Dark          Light          Moka          Siena",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"9mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA71,AG71)","v":9.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":9.9},null,"YES",9.9,{"$f":"+W71","v":0},9.9,{"$f":"(AG71-AC71)/AG71","v":0},null,4,{"$f":"SUM(AJ71:AL71)+AE71","v":9.9},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":9.9},{"$f":"IF(VLOOKUP(AF71,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ71,1)-AJ71,2),Round,2,FALSE)+VLOOKUP(AF71,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",0,ROUND(AJ71-0.04999,1)-AJ71+AM71)","v":0},{"$f":"IF(VLOOKUP(AF71,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF71,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA72,AG72)","v":9.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":9.9499999999999993},null,"YES",9.9499999999999993,0,9.9499999999999993,{"$f":"(AG72-AC72)/AG72","v":0},null,4,{"$f":"SUM(AJ72:AL72)+AE72","v":9.9499999999999993},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":9.9499999999999993},{"$f":"IF(VLOOKUP(AF72,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ72,1)-AJ72,2),Round,2,FALSE)+VLOOKUP(AF72,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",0,ROUND(AJ72-0.04999,1)-AJ72+AM72)","v":0},{"$f":"IF(VLOOKUP(AF72,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF72,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA73,AG73)","v":11.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA73*(1-W73)+0.004999,2)","v":11.3},null,"YES",11.3,0,11.3,{"$f":"(AG73-AC73)/AG73","v":0},null,4,{"$f":"SUM(AJ73:AL73)+AE73","v":11.3},null,null,{"$f":"ROUND(AC73/(1-VLOOKUP(AF73,Group,2,FALSE)),2)","v":11.3},{"$f":"IF(VLOOKUP(AF73,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ73,1)-AJ73,2),Round,2,FALSE)+VLOOKUP(AF73,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",0,ROUND(AJ73-0.04999,1)-AJ73+AM73)","v":0},{"$f":"IF(VLOOKUP(AF73,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF73,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"48\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA74,AG74)","v":11.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA74*(1-W74)+0.004999,2)","v":11.7},null,"YES",11.7,0,11.7,{"$f":"(AG74-AC74)/AG74","v":0},null,4,{"$f":"SUM(AJ74:AL74)+AE74","v":11.7},null,null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":11.7},{"$f":"IF(VLOOKUP(AF74,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ74,1)-AJ74,2),Round,2,FALSE)+VLOOKUP(AF74,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",0,ROUND(AJ74-0.04999,1)-AJ74+AM74)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF74,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"1\" x 1\" Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA76,AG76)","v":42.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":42.35},null,"YES",42.35,{"$f":"+W76","v":0},{"$f":"+X76","v":42.35},{"$f":"(AG76-AC76)/AG76","v":0},null,6,{"$f":"SUM(AJ76:AL76)+AE76","v":42.35},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":42.35},{"$f":"IF(VLOOKUP(AF76,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ76,1)-AJ76,2),Round,2,FALSE)+VLOOKUP(AF76,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",0,ROUND(AJ76-0.04999,1)-AJ76+AM76)","v":0},{"$f":"IF(VLOOKUP(AF76,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF76,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"2-1/8\" x 24\"",null,"Bullnose",null,null,null,"Natural",null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":7.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":7.65},null,"YES",7.65,{"$f":"+W78","v":0},{"$f":"+X78","v":7.65},{"$f":"(AG78-AC78)/AG78","v":0},null,5,{"$f":"SUM(AJ78:AL78)+AE78","v":7.65},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":7.65},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Brown          Coal          Gray          Sand          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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":8.6999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":8.6999999999999993},null,"YES",8.6999999999999993,{"$f":"+W82","v":0},8.6999999999999993,{"$f":"(AG82-AC82)/AG82","v":0},null,4,{"$f":"SUM(AJ82:AL82)+AE82","v":8.6999999999999993},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":8.6999999999999993},{"$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,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA83,AG83)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA83*(1-W83)+0.004999,2)","v":8.75},null,"YES",8.75,0,8.75,{"$f":"(AG83-AC83)/AG83","v":0},null,4,{"$f":"SUM(AJ83:AL83)+AE83","v":8.75},null,null,{"$f":"ROUND(AC83/(1-VLOOKUP(AF83,Group,2,FALSE)),2)","v":8.75},{"$f":"IF(VLOOKUP(AF83,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ83,1)-AJ83,2),Round,2,FALSE)+VLOOKUP(AF83,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",0,ROUND(AJ83-0.04999,1)-AJ83+AM83)","v":0},{"$f":"IF(VLOOKUP(AF83,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF83,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA84,AG84)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":10.55},null,"YES",10.55,0,10.55,{"$f":"(AG84-AC84)/AG84","v":0},null,4,{"$f":"SUM(AJ84:AL84)+AE84","v":10.55},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":10.55},{"$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,"Import I - Field Tile",null,null,"48\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA85,AG85)","v":11},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA85*(1-W85)+0.004999,2)","v":11},null,"YES",11,0,11,{"$f":"(AG85-AC85)/AG85","v":0},null,4,{"$f":"SUM(AJ85:AL85)+AE85","v":11},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":11},{"$f":"IF(VLOOKUP(AF85,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ85,1)-AJ85,2),Round,2,FALSE)+VLOOKUP(AF85,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",0,ROUND(AJ85-0.04999,1)-AJ85+AM85)","v":0},{"$f":"IF(VLOOKUP(AF85,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF85,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA87,AG87)","v":16.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA87*(1-W87)+0.004999,2)","v":16.95},null,"YES",16.95,{"$f":"+W87","v":0},{"$f":"+X87","v":16.95},{"$f":"(AG87-AC87)/AG87","v":0},null,6,{"$f":"SUM(AJ87:AL87)+AE87","v":16.95},null,null,{"$f":"ROUND(AC87/(1-VLOOKUP(AF87,Group,2,FALSE)),2)","v":16.95},{"$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,"Import I - Trim",null,null,"2-1/8\" x 24\"",null,"Bullnose",null,null,null,"Natural",null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":6.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":6.9},null,"YES",6.9,{"$f":"+W89","v":0},{"$f":"+X89","v":6.9},{"$f":"(AG89-AC89)/AG89","v":0},null,5,{"$f":"SUM(AJ89:AL89)+AE89","v":6.9},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":6.9},{"$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,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"15.50 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA91,AG91)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+W91","v":0},{"$f":"+X91","v":8.75},{"$f":"(AG91-AC91)/AG91","v":0},null,4,{"$f":"SUM(AJ91:AL91)+AE91","v":8.75},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":8.75},{"$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,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"15.50 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA92,AG92)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":10.55},null,"YES",10.55,{"$f":"+W92","v":0},{"$f":"+X92","v":10.55},{"$f":"(AG92-AC92)/AG92","v":0},null,4,{"$f":"SUM(AJ92:AL92)+AE92","v":10.55},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF92,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ92,1)-AJ92,2),Round,2,FALSE)+VLOOKUP(AF92,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",0,ROUND(AJ92-0.04999,1)-AJ92+AM92)","v":0},{"$f":"IF(VLOOKUP(AF92,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF92,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,"System L2 20mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Brown          Coal          Gray          Sand          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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\" x 20mm",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"7.75 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA98,AG98)","v":15.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":15.75},null,"YES",15.75,{"$f":"+W98","v":0},{"$f":"+X98","v":15.75},{"$f":"(AG98-AC98)/AG98","v":0},null,4,{"$f":"SUM(AJ98:AL98)+AE98","v":15.75},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":15.75},{"$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,"Notes:","Specially treated with Microban antimicrobial protection that is incorporated into the tile surface.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"a) Not available in color Brown.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"b) Not specially treated with Microban antimicrobial protection that is incorporated into the tile surface.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"SIDE STONE - Full-Body Porcelain  (Minimum 6-8 Week Delivery)",null,null,null,null,null,null,null,null,null,null," "," ",null,null,"Item # Lookup:","LESI",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:","Cluster Dark",null,"  Cluster Mid",null,null,"  Hidden Light",null,null,null,null,null,null,null,null,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,"Cluster Light",null,"  Hidden Dark",null,null,"  Hidden Mid",null,null,null,null,null,null,null,null,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,"Slimtech 6mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"48\" x 109-1/2\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"35.95 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA111,AG111)","v":14.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":14.8},null,"new",14.8,{"$f":"+W111","v":0},{"$f":"+X111","v":14.8},{"$f":"(AG111-AC111)/AG111","v":0},null,4,{"$f":"SUM(AJ111:AL111)+AE111","v":14.8},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":14.8},{"$f":"IF(VLOOKUP(AF111,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ111,1)-AJ111,2),Round,2,FALSE)+VLOOKUP(AF111,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",0,ROUND(AJ111-0.04999,1)-AJ111+AM111)","v":0},{"$f":"IF(VLOOKUP(AF111,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF111,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,"9mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA115,AG115)","v":8.6999999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA115*(1-W115)+0.004999,2)","v":8.6999999999999993},null,"new",8.6999999999999993,{"$f":"+W115","v":0},{"$f":"+X115","v":8.6999999999999993},{"$f":"(AG115-AC115)/AG115","v":0},null,4,{"$f":"SUM(AJ115:AL115)+AE115","v":8.6999999999999993},null,null,{"$f":"ROUND(AC115/(1-VLOOKUP(AF115,Group,2,FALSE)),2)","v":8.6999999999999993},{"$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,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,8.75,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA116*(1-W116)+0.004999,2)","v":8.75},null,"new",8.75,0,8.75,0,null,4,8.75,null,null,8.75,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA117,AG117)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":10.55},null,"new",10.55,{"$f":"+W117","v":0},{"$f":"+X117","v":10.55},{"$f":"(AG117-AC117)/AG117","v":0},null,4,{"$f":"SUM(AJ117:AL117)+AE117","v":10.55},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ117,1)-AJ117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AJ117-0.04999,1)-AJ117+AM117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"48\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA118,AG118)","v":11},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA118*(1-W118)+0.004999,2)","v":11},null,"new",11,{"$f":"+W118","v":0},{"$f":"+X118","v":11},{"$f":"(AG118-AC118)/AG118","v":0},null,4,{"$f":"SUM(AJ118:AL118)+AE118","v":11},null,null,{"$f":"ROUND(AC118/(1-VLOOKUP(AF118,Group,2,FALSE)),2)","v":11},{"$f":"IF(VLOOKUP(AF118,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ118,1)-AJ118,2),Round,2,FALSE)+VLOOKUP(AF118,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",0,ROUND(AJ118-0.04999,1)-AJ118+AM118)","v":0},{"$f":"IF(VLOOKUP(AF118,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF118,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Field Tile",null,null,"5-3/4\" x 19-1/2\"",null,"Field - Gramma 72",null,null,null,"Natural/Rectified",null,null,null,null,"10.85 SF/CTN",null,"b",{"$f":"IF(Suggested=\"Yes\",AA120,AG120)","v":14.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":14.2},null,"new",14.2,{"$f":"+W120","v":0},{"$f":"+X120","v":14.2},{"$f":"(AG120-AC120)/AG120","v":0},null,4,{"$f":"SUM(AJ120:AL120)+AE120","v":14.2},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":14.2},{"$f":"IF(VLOOKUP(AF120,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ120,1)-AJ120,2),Round,2,FALSE)+VLOOKUP(AF120,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",0,ROUND(AJ120-0.04999,1)-AJ120+AM120)","v":0},{"$f":"IF(VLOOKUP(AF120,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF120,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"Macro Mosaic",null,null,null,"Natural",null,null,null,null,"4.84 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA122,AG122)","v":37.049999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA122*(1-W122)+0.004999,2)","v":37.049999999999997},null,"new",37.049999999999997,{"$f":"+W122","v":0},{"$f":"+X122","v":37.049999999999997},{"$f":"(AG122-AC122)/AG122","v":0},null,6,{"$f":"SUM(AJ122:AL122)+AE122","v":37.049999999999997},null,null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":37.049999999999997},{"$f":"IF(VLOOKUP(AF122,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ122,1)-AJ122,2),Round,2,FALSE)+VLOOKUP(AF122,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",0,ROUND(AJ122-0.04999,1)-AJ122+AM122)","v":0},{"$f":"IF(VLOOKUP(AF122,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF122,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"Mega Mosaic",null,null,null,"Natural",null,null,null,null,"4.84 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA123,AG123)","v":27.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA123*(1-W123)+0.004999,2)","v":27.7},null,"new",27.7,{"$f":"+W123","v":0},{"$f":"+X123","v":27.7},{"$f":"(AG123-AC123)/AG123","v":0},null,6,{"$f":"SUM(AJ123:AL123)+AE123","v":27.7},null,null,{"$f":"ROUND(AC123/(1-VLOOKUP(AF123,Group,2,FALSE)),2)","v":27.7},{"$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,"Import I - Decos",null,null,"12\" x 12\"",null,"Micro Mosaic",null,null,null,"Natural",null,null,null,null,"4.84 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA124,AG124)","v":49.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA124*(1-W124)+0.004999,2)","v":49.65},null,"new",49.65,{"$f":"+W124","v":0},{"$f":"+X124","v":49.65},{"$f":"(AG124-AC124)/AG124","v":0},null,6,{"$f":"SUM(AJ124:AL124)+AE124","v":49.65},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":49.65},{"$f":"IF(VLOOKUP(AF124,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ124,1)-AJ124,2),Round,2,FALSE)+VLOOKUP(AF124,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",0,ROUND(AJ124-0.04999,1)-AJ124+AM124)","v":0},{"$f":"IF(VLOOKUP(AF124,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF124,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA125,AG125)","v":16.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":16.95},null,"new",16.95,{"$f":"+W125","v":0},{"$f":"+X125","v":16.95},{"$f":"(AG125-AC125)/AG125","v":0},null,6,{"$f":"SUM(AJ125:AL125)+AE125","v":16.95},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":16.95},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"3-1/8\" x 24\"",null,"Bullnose",null,null,null,"Natural",null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA127,AG127)","v":12.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA127*(1-W127)+0.004999,2)","v":12.1},null,"new",12.1,{"$f":"+W127","v":0},{"$f":"+X127","v":12.1},{"$f":"(AG127-AC127)/AG127","v":0},null,5,{"$f":"SUM(AJ127:AL127)+AE127","v":12.1},null,null,{"$f":"ROUND(AC127/(1-VLOOKUP(AF127,Group,2,FALSE)),2)","v":12.1},{"$f":"IF(VLOOKUP(AF127,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ127,1)-AJ127,2),Round,2,FALSE)+VLOOKUP(AF127,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",0,ROUND(AJ127-0.04999,1)-AJ127+AM127)","v":0},{"$f":"IF(VLOOKUP(AF127,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF127,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":8.75},null,"new",8.75,{"$f":"+W129","v":0},{"$f":"+X129","v":8.75},{"$f":"(AG129-AC129)/AG129","v":0},null,4,{"$f":"SUM(AJ129:AL129)+AE129","v":8.75},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":8.75},{"$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,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA130,AG130)","v":10.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA130*(1-W130)+0.004999,2)","v":10.55},null,"new",10.55,{"$f":"+W130","v":0},{"$f":"+X130","v":10.55},{"$f":"(AG130-AC130)/AG130","v":0},null,4,{"$f":"SUM(AJ130:AL130)+AE130","v":10.55},null,null,{"$f":"ROUND(AC130/(1-VLOOKUP(AF130,Group,2,FALSE)),2)","v":10.55},{"$f":"IF(VLOOKUP(AF130,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ130,1)-AJ130,2),Round,2,FALSE)+VLOOKUP(AF130,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",0,ROUND(AJ130-0.04999,1)-AJ130+AM130)","v":0},{"$f":"IF(VLOOKUP(AF130,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF130,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"System L2 20mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Cluster Dark          Cluster Light          Cluster Mid",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"24\" x 48\" x 20mm",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA136,AG136)","v":15.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA136*(1-W136)+0.004999,2)","v":15.75},null,"YES",15.75,{"$f":"+W136","v":0},{"$f":"+X136","v":15.75},{"$f":"(AG136-AC136)/AG136","v":0},null,4,{"$f":"SUM(AJ136:AL136)+AE136","v":15.75},null,null,{"$f":"ROUND(AC136/(1-VLOOKUP(AF136,Group,2,FALSE)),2)","v":15.75},{"$f":"IF(VLOOKUP(AF136,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ136,1)-AJ136,2),Round,2,FALSE)+VLOOKUP(AF136,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",0,ROUND(AJ136-0.04999,1)-AJ136+AM136)","v":0},{"$f":"IF(VLOOKUP(AF136,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF136,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","Specially treated with Microban antimicrobial protection that is incorporated into the tile surface.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"a) Crate charges may apply.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,"b) Available in colors Cluster Dark, Cluster Light and Cluster Mid 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,"X"]
[null,null,null,null,"c) Each mosaic is a mix of several fixed colors.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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 ROCK - Full-Body Porcelain",null,null,null,null,null,null,null,null," "," "," "," ",null,null,"Item # Lookup:","LETH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Black Rock          Grey Rock          Ivory Rock          Taupe Rock",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"12\" x 24\"",null,"Field",null,null,null,"Rectified",null,null,null,null,"13.67 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA147,AG147)","v":6.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA147*(1-W147)+0.004999,2)","v":6.55},null,"YES",6.55,{"$f":"+W147","v":0},{"$f":"+X147","v":6.55},{"$f":"(AG147-AC147)/AG147","v":0},null,1,{"$f":"SUM(AJ147:AL147)+AE147","v":6.55},null,null,{"$f":"ROUND(AC147/(1-VLOOKUP(AF147,Group,2,FALSE)),2)","v":6.55},{"$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,null,null,"Rectified",null,null,null,null,"15.61 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA148,AG148)","v":6.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":6.55},null,"YES",6.55,{"$f":"+W148","v":0},{"$f":"+X148","v":6.55},{"$f":"(AG148-AC148)/AG148","v":0},null,1,{"$f":"SUM(AJ148:AL148)+AE148","v":6.55},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":6.55},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,"(Mesh-Mounted)",null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA150,AG150)","v":22.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA150*(1-W150)+0.004999,2)","v":22.75},null,"YES",22.75,{"$f":"+W150","v":0},{"$f":"+X150","v":22.75},{"$f":"(AG150-AC150)/AG150","v":0},null,3,{"$f":"SUM(AJ150:AL150)+AE150","v":22.75},null,null,{"$f":"ROUND(AC150/(1-VLOOKUP(AF150,Group,2,FALSE)),2)","v":22.75},{"$f":"IF(VLOOKUP(AF150,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ150,1)-AJ150,2),Round,2,FALSE)+VLOOKUP(AF150,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",0,ROUND(AJ150-0.04999,1)-AJ150+AM150)","v":0},{"$f":"IF(VLOOKUP(AF150,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF150,Group,7,FALSE))","v":""},null,"X"]
[null,"Decos",null,null,"12\" x 12\"",null,"3\" x 6\" Brick Mosaic",null,null,null,null,null,null,"(Mesh-Mounted)",null,"3.88 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA151,AG151)","v":22.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA151*(1-W151)+0.004999,2)","v":22.75},null,"YES",22.75,{"$f":"+W151","v":0},{"$f":"+X151","v":22.75},{"$f":"(AG151-AC151)/AG151","v":0},null,3,{"$f":"SUM(AJ151:AL151)+AE151","v":22.75},null,null,{"$f":"ROUND(AC151/(1-VLOOKUP(AF151,Group,2,FALSE)),2)","v":22.75},{"$f":"IF(VLOOKUP(AF151,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ151,1)-AJ151,2),Round,2,FALSE)+VLOOKUP(AF151,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",0,ROUND(AJ151-0.04999,1)-AJ151+AM151)","v":0},{"$f":"IF(VLOOKUP(AF151,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF151,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",null,null,null,null,null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA153,AG153)","v":10.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA153*(1-W153)+0.004999,2)","v":10.3},null,"",10.3,{"$f":"+W153","v":0},{"$f":"+X153","v":10.3},{"$f":"(AG153-AC153)/AG153","v":0},null,2,{"$f":"SUM(AJ153:AL153)+AE153","v":10.3},null,null,{"$f":"ROUND(AC153/(1-VLOOKUP(AF153,Group,2,FALSE)),2)","v":10.3},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ153,1)-AJ153,2),Round,2,FALSE)+VLOOKUP(AF153,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",0,ROUND(AJ153-0.04999,1)-AJ153+AM153)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF153,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,"Note:","Packaging is changing from 13.67 SF/CTN to 15.61 SF/CTN as inventories of the old packaging is depleted.  Check with",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Customer Service to be sure which SF/CTN packaging you will be receiving.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"WATERFALL - Full-Body Porcelain  (Minimum 6-8 Week Delivery)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LEWA",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,"Slimtech 5.5mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Dark Flow          Gray Flow          Ivory Flow          Silver Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"19-1/2\" x 39\" x 5.5mm",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"16.15 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA164,AG164)","v":12.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":12.7},null,"YES",12.7,{"$f":"+W164","v":0},12.7,{"$f":"(AG164-AC164)/AG164","v":0},null,4,{"$f":"SUM(AJ164:AL164)+AE164","v":12.7},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":12.7},{"$f":"IF(VLOOKUP(AF164,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ164,1)-AJ164,2),Round,2,FALSE)+VLOOKUP(AF164,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",0,ROUND(AJ164-0.04999,1)-AJ164+AM164)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF164,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"39\" x 39\" x 5.5mm",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"21.53 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA165,AG165)","v":13.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":13.65},null,"YES",13.65,0,13.65,{"$f":"(AG165-AC165)/AG165","v":0},null,4,{"$f":"SUM(AJ165:AL165)+AE165","v":13.65},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":13.65},{"$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,"Import I - Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"32.29 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":17.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":17.649999999999999},null,"YES",17.649999999999999,0,17.649999999999999,{"$f":"(AG166-AC166)/AG166","v":0},null,4,{"$f":"SUM(AJ166:AL166)+AE166","v":17.649999999999999},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":17.649999999999999},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Notes:","Specially treated with Microban antimicrobial protection that is incorporated into the tile surface.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"a) Crate charges may apply.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"9.5mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Dark Flow          Gray Flow          Ivory Flow          Silver Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA175,AG175)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA175*(1-W175)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,{"$f":"+W175","v":0},8.8000000000000007,{"$f":"(AG175-AC175)/AG175","v":0},null,4,{"$f":"SUM(AJ175:AL175)+AE175","v":8.8000000000000007},null,null,{"$f":"ROUND(AC175/(1-VLOOKUP(AF175,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF175,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ175,1)-AJ175,2),Round,2,FALSE)+VLOOKUP(AF175,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF175,Group,7,FALSE)=\"\",0,ROUND(AJ175-0.04999,1)-AJ175+AM175)","v":0},{"$f":"IF(VLOOKUP(AF175,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF175,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA176,AG176)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA176*(1-W176)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,0,8.8000000000000007,{"$f":"(AG176-AC176)/AG176","v":0},null,4,{"$f":"SUM(AJ176:AL176)+AE176","v":8.8000000000000007},null,null,{"$f":"ROUND(AC176/(1-VLOOKUP(AF176,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF176,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ176,1)-AJ176,2),Round,2,FALSE)+VLOOKUP(AF176,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",0,ROUND(AJ176-0.04999,1)-AJ176+AM176)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF176,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"18\" x 36\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"13.13 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA177,AG177)","v":9.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA177*(1-W177)+0.004999,2)","v":9.4},null,"YES",9.4,0,9.4,{"$f":"(AG177-AC177)/AG177","v":0},null,4,{"$f":"SUM(AJ177:AL177)+AE177","v":9.4},null,null,{"$f":"ROUND(AC177/(1-VLOOKUP(AF177,Group,2,FALSE)),2)","v":9.4},{"$f":"IF(VLOOKUP(AF177,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ177,1)-AJ177,2),Round,2,FALSE)+VLOOKUP(AF177,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",0,ROUND(AJ177-0.04999,1)-AJ177+AM177)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF177,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA178,AG178)","v":11.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA178*(1-W178)+0.004999,2)","v":11.1},null,"YES",11.1,0,11.1,{"$f":"(AG178-AC178)/AG178","v":0},null,4,{"$f":"SUM(AJ178:AL178)+AE178","v":11.1},null,null,{"$f":"ROUND(AC178/(1-VLOOKUP(AF178,Group,2,FALSE)),2)","v":11.1},{"$f":"IF(VLOOKUP(AF178,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ178,1)-AJ178,2),Round,2,FALSE)+VLOOKUP(AF178,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",0,ROUND(AJ178-0.04999,1)-AJ178+AM178)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF178,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA179,AG179)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA179*(1-W179)+0.004999,2)","v":10.85},null,"YES",10.85,0,10.85,{"$f":"(AG179-AC179)/AG179","v":0},null,4,{"$f":"SUM(AJ179:AL179)+AE179","v":10.85},null,null,{"$f":"ROUND(AC179/(1-VLOOKUP(AF179,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF179,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ179,1)-AJ179,2),Round,2,FALSE)+VLOOKUP(AF179,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",0,ROUND(AJ179-0.04999,1)-AJ179+AM179)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF179,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Field Tile",null,null,"5-3/4\" x 19-1/2\"",null,"Field - Gramma 72",null,null,null,"Natural/Rectified",null,null,null,null,"10.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA181,AG181)","v":14.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA181*(1-W181)+0.004999,2)","v":14.3},null,"YES",14.3,{"$f":"+W181","v":0},14.3,{"$f":"(AG181-AC181)/AG181","v":0},null,4,{"$f":"SUM(AJ181:AL181)+AE181","v":14.3},null,null,{"$f":"ROUND(AC181/(1-VLOOKUP(AF181,Group,2,FALSE)),2)","v":14.3},{"$f":"IF(VLOOKUP(AF181,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ181,1)-AJ181,2),Round,2,FALSE)+VLOOKUP(AF181,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF181,Group,7,FALSE)=\"\",0,ROUND(AJ181-0.04999,1)-AJ181+AM181)","v":0},{"$f":"IF(VLOOKUP(AF181,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF181,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"6-5/8\" x 15-3/8\"",null,"Field - Gramma 66 (Left)",null,null,null,"Natural/Rectified",null,null,null,null,"7.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA182,AG182)","v":17.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA182*(1-W182)+0.004999,2)","v":17.45},null,"YES",17.45,0,17.45,{"$f":"(AG182-AC182)/AG182","v":0},null,4,{"$f":"SUM(AJ182:AL182)+AE182","v":17.45},null,null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":17.45},{"$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,"Import I - Field Tile",null,null,"6-5/8\" x 15-3/8\"",null,"Field - Gramma 66 (Right)",null,null,null,"Natural/Rectified",null,null,null,null,"7.10 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":17.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":17.45},null,"YES",17.45,0,17.45,{"$f":"(AG183-AC183)/AG183","v":0},null,4,{"$f":"SUM(AJ183:AL183)+AE183","v":17.45},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":17.45},{"$f":"IF(VLOOKUP(AF183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ183,1)-AJ183,2),Round,2,FALSE)+VLOOKUP(AF183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",0,ROUND(AJ183-0.04999,1)-AJ183+AM183)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF183,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"3-1/4\" x 7-5/8\"",null,"Field - Gramma 16 (Left)",null,null,null,"Natural/Rectified",null,null,null,null,"2.41 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":21.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":21.4},null,"YES",21.4,0,21.4,{"$f":"(AG184-AC184)/AG184","v":0},null,4,{"$f":"SUM(AJ184:AL184)+AE184","v":21.4},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":21.4},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ184,1)-AJ184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AJ184-0.04999,1)-AJ184+AM184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"3-1/4\" x 7-5/8\"",null,"Field - Gramma 16 (Right)",null,null,null,"Natural/Rectified",null,null,null,null,"2.41 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA185,AG185)","v":21.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA185*(1-W185)+0.004999,2)","v":21.4},null,"YES",21.4,0,21.4,{"$f":"(AG185-AC185)/AG185","v":0},null,4,{"$f":"SUM(AJ185:AL185)+AE185","v":21.4},null,null,{"$f":"ROUND(AC185/(1-VLOOKUP(AF185,Group,2,FALSE)),2)","v":21.4},{"$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,"Import I - Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA187,AG187)","v":15.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA187*(1-W187)+0.004999,2)","v":15.8},null,"YES",15.8,{"$f":"+W187","v":0},15.8,{"$f":"(AG187-AC187)/AG187","v":0},null,6,{"$f":"SUM(AJ187:AL187)+AE187","v":15.8},null,null,{"$f":"ROUND(AC187/(1-VLOOKUP(AF187,Group,2,FALSE)),2)","v":15.8},{"$f":"IF(VLOOKUP(AF187,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ187,1)-AJ187,2),Round,2,FALSE)+VLOOKUP(AF187,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",0,ROUND(AJ187-0.04999,1)-AJ187+AM187)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF187,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 24\"",null,"3\" x 12\" Brick Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA188,AG188)","v":16.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA188*(1-W188)+0.004999,2)","v":16.8},null,"YES",16.8,0,16.8,{"$f":"(AG188-AC188)/AG188","v":0},null,6,{"$f":"SUM(AJ188:AL188)+AE188","v":16.8},null,null,{"$f":"ROUND(AC188/(1-VLOOKUP(AF188,Group,2,FALSE)),2)","v":16.8},{"$f":"IF(VLOOKUP(AF188,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ188,1)-AJ188,2),Round,2,FALSE)+VLOOKUP(AF188,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",0,ROUND(AJ188-0.04999,1)-AJ188+AM188)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF188,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 24\"",null,"Muretto Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA189,AG189)","v":18.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA189*(1-W189)+0.004999,2)","v":18.05},null,"YES",18.05,0,18.05,{"$f":"(AG189-AC189)/AG189","v":0},null,6,{"$f":"SUM(AJ189:AL189)+AE189","v":18.05},null,null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":18.05},{"$f":"IF(VLOOKUP(AF189,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ189,1)-AJ189,2),Round,2,FALSE)+VLOOKUP(AF189,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",0,ROUND(AJ189-0.04999,1)-AJ189+AM189)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF189,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 24\"",null,"Muretto 3D Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"7.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA190,AG190)","v":39.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA190*(1-W190)+0.004999,2)","v":39.65},null,"YES",39.65,0,39.65,{"$f":"(AG190-AC190)/AG190","v":0},null,6,{"$f":"SUM(AJ190:AL190)+AE190","v":39.65},null,null,{"$f":"ROUND(AC190/(1-VLOOKUP(AF190,Group,2,FALSE)),2)","v":39.65},{"$f":"IF(VLOOKUP(AF190,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ190,1)-AJ190,2),Round,2,FALSE)+VLOOKUP(AF190,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",0,ROUND(AJ190-0.04999,1)-AJ190+AM190)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF190,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"4\" x 24\"",null,"Bullnose",null,null,null,"Natural",null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA192,AG192)","v":17.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA192*(1-W192)+0.004999,2)","v":17.2},null,"YES",17.2,{"$f":"+W192","v":0},{"$f":"+X192","v":17.2},{"$f":"(AG192-AC192)/AG192","v":0},null,5,{"$f":"SUM(AJ192:AL192)+AE192","v":17.2},null,null,{"$f":"ROUND(AC192/(1-VLOOKUP(AF192,Group,2,FALSE)),2)","v":17.2},{"$f":"IF(VLOOKUP(AF192,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ192,1)-AJ192,2),Round,2,FALSE)+VLOOKUP(AF192,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF192,Group,7,FALSE)=\"\",0,ROUND(AJ192-0.04999,1)-AJ192+AM192)","v":0},{"$f":"IF(VLOOKUP(AF192,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF192,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,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"WATERFALL - Full-Body Porcelain  (Minimum 6-8 Week Delivery) continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LEWA",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:","Dark Flow          Gray Flow          Ivory Flow          Silver Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"12\" x 24\"",null,"Field",null,null,null,"Semi-Polished/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA199,AG199)","v":9.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA199*(1-W199)+0.004999,2)","v":9.4499999999999993},null,"YES",9.4499999999999993,{"$f":"+W199","v":0},9.4499999999999993,{"$f":"(AG199-AC199)/AG199","v":0},null,4,{"$f":"SUM(AJ199:AL199)+AE199","v":9.4499999999999993},null,null,{"$f":"ROUND(AC199/(1-VLOOKUP(AF199,Group,2,FALSE)),2)","v":9.4499999999999993},{"$f":"IF(VLOOKUP(AF199,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ199,1)-AJ199,2),Round,2,FALSE)+VLOOKUP(AF199,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",0,ROUND(AJ199-0.04999,1)-AJ199+AM199)","v":0},{"$f":"IF(VLOOKUP(AF199,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF199,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Semi-Polished/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA200,AG200)","v":9.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA200*(1-W200)+0.004999,2)","v":9.4499999999999993},null,"YES",9.4499999999999993,0,9.4499999999999993,{"$f":"(AG200-AC200)/AG200","v":0},null,4,{"$f":"SUM(AJ200:AL200)+AE200","v":9.4499999999999993},null,null,{"$f":"ROUND(AC200/(1-VLOOKUP(AF200,Group,2,FALSE)),2)","v":9.4499999999999993},{"$f":"IF(VLOOKUP(AF200,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ200,1)-AJ200,2),Round,2,FALSE)+VLOOKUP(AF200,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",0,ROUND(AJ200-0.04999,1)-AJ200+AM200)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF200,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"18\" x 36\"",null,"Field",null,null,null,"Semi-Polished/Rectified",null,null,null,null,"13.13 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA201,AG201)","v":10.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA201*(1-W201)+0.004999,2)","v":10.35},null,"YES",10.35,{"$f":"+W201","v":0},{"$f":"+X201","v":10.35},{"$f":"(AG201-AC201)/AG201","v":0},null,4,{"$f":"SUM(AJ201:AL201)+AE201","v":10.35},null,null,{"$f":"ROUND(AC201/(1-VLOOKUP(AF201,Group,2,FALSE)),2)","v":10.35},{"$f":"IF(VLOOKUP(AF201,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ201,1)-AJ201,2),Round,2,FALSE)+VLOOKUP(AF201,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",0,ROUND(AJ201-0.04999,1)-AJ201+AM201)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF201,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"36\" x 36\"",null,"Field",null,null,null,"Semi-Polished/Rectified",null,null,null,null,"17.44 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA202,AG202)","v":12.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA202*(1-W202)+0.004999,2)","v":12.15},null,"YES",12.15,{"$f":"+W202","v":0},{"$f":"+X202","v":12.15},{"$f":"(AG202-AC202)/AG202","v":0},null,4,{"$f":"SUM(AJ202:AL202)+AE202","v":12.15},null,null,{"$f":"ROUND(AC202/(1-VLOOKUP(AF202,Group,2,FALSE)),2)","v":12.15},{"$f":"IF(VLOOKUP(AF202,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ202,1)-AJ202,2),Round,2,FALSE)+VLOOKUP(AF202,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF202,Group,7,FALSE)=\"\",0,ROUND(AJ202-0.04999,1)-AJ202+AM202)","v":0},{"$f":"IF(VLOOKUP(AF202,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF202,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 48\"",null,"Field",null,null,null,"Semi-Polished/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA203,AG203)","v":11.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA203*(1-W203)+0.004999,2)","v":11.75},null,"YES",11.75,0,11.75,{"$f":"(AG203-AC203)/AG203","v":0},null,4,{"$f":"SUM(AJ203:AL203)+AE203","v":11.75},null,null,{"$f":"ROUND(AC203/(1-VLOOKUP(AF203,Group,2,FALSE)),2)","v":11.75},{"$f":"IF(VLOOKUP(AF203,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ203,1)-AJ203,2),Round,2,FALSE)+VLOOKUP(AF203,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",0,ROUND(AJ203-0.04999,1)-AJ203+AM203)","v":0},{"$f":"IF(VLOOKUP(AF203,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF203,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"2\" x 2\" Mosaic",null,null,null,"Semi-Polished",null,null,"(Mesh-Mounted)",null,"4.84 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA205,AG205)","v":16.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA205*(1-W205)+0.004999,2)","v":16.75},null,"YES",16.75,{"$f":"+W205","v":0},16.75,{"$f":"(AG205-AC205)/AG205","v":0},null,6,{"$f":"SUM(AJ205:AL205)+AE205","v":16.75},null,null,{"$f":"ROUND(AC205/(1-VLOOKUP(AF205,Group,2,FALSE)),2)","v":16.75},{"$f":"IF(VLOOKUP(AF205,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ205,1)-AJ205,2),Round,2,FALSE)+VLOOKUP(AF205,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF205,Group,7,FALSE)=\"\",0,ROUND(AJ205-0.04999,1)-AJ205+AM205)","v":0},{"$f":"IF(VLOOKUP(AF205,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF205,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 24\"",null,"3\" x 12\" Brick Mosaic",null,null,null,"Semi-Polished",null,null,"(Mesh-Mounted)",null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA206,AG206)","v":17.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA206*(1-W206)+0.004999,2)","v":17.55},null,"YES",17.55,0,17.55,{"$f":"(AG206-AC206)/AG206","v":0},null,6,{"$f":"SUM(AJ206:AL206)+AE206","v":17.55},null,null,{"$f":"ROUND(AC206/(1-VLOOKUP(AF206,Group,2,FALSE)),2)","v":17.55},{"$f":"IF(VLOOKUP(AF206,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ206,1)-AJ206,2),Round,2,FALSE)+VLOOKUP(AF206,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",0,ROUND(AJ206-0.04999,1)-AJ206+AM206)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF206,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 24\"",null,"Muretto Mosaic",null,null,null,"Semi-Polished",null,null,"(Mesh-Mounted)",null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA207,AG207)","v":18.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA207*(1-W207)+0.004999,2)","v":18.350000000000001},null,"YES",18.350000000000001,0,18.350000000000001,{"$f":"(AG207-AC207)/AG207","v":0},null,6,{"$f":"SUM(AJ207:AL207)+AE207","v":18.350000000000001},null,null,{"$f":"ROUND(AC207/(1-VLOOKUP(AF207,Group,2,FALSE)),2)","v":18.350000000000001},{"$f":"IF(VLOOKUP(AF207,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ207,1)-AJ207,2),Round,2,FALSE)+VLOOKUP(AF207,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",0,ROUND(AJ207-0.04999,1)-AJ207+AM207)","v":0},{"$f":"IF(VLOOKUP(AF207,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF207,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 24\"",null,"Muretto 3D Mosaic",null,null,null,"Semi-Polished",null,null,"(Mesh-Mounted)",null,"7.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA208,AG208)","v":40.700000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA208*(1-W208)+0.004999,2)","v":40.700000000000003},null,"YES",40.700000000000003,0,40.700000000000003,{"$f":"(AG208-AC208)/AG208","v":0},null,6,{"$f":"SUM(AJ208:AL208)+AE208","v":40.700000000000003},null,null,{"$f":"ROUND(AC208/(1-VLOOKUP(AF208,Group,2,FALSE)),2)","v":40.700000000000003},{"$f":"IF(VLOOKUP(AF208,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ208,1)-AJ208,2),Round,2,FALSE)+VLOOKUP(AF208,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",0,ROUND(AJ208-0.04999,1)-AJ208+AM208)","v":0},{"$f":"IF(VLOOKUP(AF208,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF208,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"4\" x 24\"",null,"Bullnose",null,null,null,"Semi-Polished",null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA210,AG210)","v":18.649999999999999},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA210*(1-W210)+0.004999,2)","v":18.649999999999999},null,"YES",18.649999999999999,{"$f":"+W210","v":0},{"$f":"+X210","v":18.649999999999999},{"$f":"(AG210-AC210)/AG210","v":0},null,5,{"$f":"SUM(AJ210:AL210)+AE210","v":18.649999999999999},null,null,{"$f":"ROUND(AC210/(1-VLOOKUP(AF210,Group,2,FALSE)),2)","v":18.649999999999999},{"$f":"IF(VLOOKUP(AF210,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ210,1)-AJ210,2),Round,2,FALSE)+VLOOKUP(AF210,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",0,ROUND(AJ210-0.04999,1)-AJ210+AM210)","v":0},{"$f":"IF(VLOOKUP(AF210,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF210,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA212,AG212)","v":8.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":8.85},null,"YES",8.85,{"$f":"+W212","v":0},{"$f":"+X212","v":8.85},{"$f":"(AG212-AC212)/AG212","v":0},null,4,{"$f":"SUM(AJ212:AL212)+AE212","v":8.85},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF212,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ212,1)-AJ212,2),Round,2,FALSE)+VLOOKUP(AF212,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",0,ROUND(AJ212-0.04999,1)-AJ212+AM212)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF212,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,"Note:","Specially treated with Microban antimicrobial protection that is incorporated into the tile surface.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"System L2 20mm Thickness:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Dark Flow          Gray Flow          Ivory Flow          Silver Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Import I - Field Tile",null,null,"24\" x 24\" x 20mm",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"7.75 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA220,AG220)","v":14.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA220*(1-W220)+0.004999,2)","v":14.25},null,"YES",14.25,{"$f":"+W220","v":0},14.25,{"$f":"(AG220-AC220)/AG220","v":0},null,4,{"$f":"SUM(AJ220:AL220)+AE220","v":14.25},null,null,{"$f":"ROUND(AC220/(1-VLOOKUP(AF220,Group,2,FALSE)),2)","v":14.25},{"$f":"IF(VLOOKUP(AF220,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ220,1)-AJ220,2),Round,2,FALSE)+VLOOKUP(AF220,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF220,Group,7,FALSE)=\"\",0,ROUND(AJ220-0.04999,1)-AJ220+AM220)","v":0},{"$f":"IF(VLOOKUP(AF220,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF220,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"18\" x 36\" x 20mm",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"8.72 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA221,AG221)","v":14.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA221*(1-W221)+0.004999,2)","v":14.2},null,"YES",14.2,0,14.2,{"$f":"(AG221-AC221)/AG221","v":0},null,4,{"$f":"SUM(AJ221:AL221)+AE221","v":14.2},null,null,{"$f":"ROUND(AC221/(1-VLOOKUP(AF221,Group,2,FALSE)),2)","v":14.2},{"$f":"IF(VLOOKUP(AF221,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ221,1)-AJ221,2),Round,2,FALSE)+VLOOKUP(AF221,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",0,ROUND(AJ221-0.04999,1)-AJ221+AM221)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF221,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"36\" x 36\" x 20mm",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"8.72 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA222,AG222)","v":16.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA222*(1-W222)+0.004999,2)","v":16.45},null,"YES",16.45,0,16.45,{"$f":"(AG222-AC222)/AG222","v":0},null,4,{"$f":"SUM(AJ222:AL222)+AE222","v":16.45},null,null,{"$f":"ROUND(AC222/(1-VLOOKUP(AF222,Group,2,FALSE)),2)","v":16.45},{"$f":"IF(VLOOKUP(AF222,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ222,1)-AJ222,2),Round,2,FALSE)+VLOOKUP(AF222,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF222,Group,7,FALSE)=\"\",0,ROUND(AJ222-0.04999,1)-AJ222+AM222)","v":0},{"$f":"IF(VLOOKUP(AF222,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF222,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01,null,null,null,null,null," "]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","http://www.leausa.us/"]
[]
[]
["Product","Direct Website Link"]
["Anthology","https://www.leaceramiche.com/collection/anthology"]
["Masterpiece","https://www.leausa.us/collection/masterpiece"]
["The Rock","https://www.leausa.us/collection/the-rock"]
["Waterfall","https://www.leausa.us/collection/waterfall"]

{"sheet":"Changes","index":4,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
["2017-12-01","The Rock","Full-Body Porcelain"]
["2017-12-01","Travel","Full-Body Porcelain"]
["2017-12-01","Waterfall","Full-Body Porcelain"]
["2022-05-06","Anthology","Full-Body Porcelain"]
["2022-05-06","Masterpiece","Full-Body Porcelain"]
[]
[]
[]
["Discontinued Products"]
["2021-09-28","The Rock","The 9\" x 36\" and 18\" x 36\" Field Tile formats only in all colors."]
["2021-09-28","Travel","The 9\" x 36\" and 18\" x 36\" Field Tile formats only in all colors."]
["2022-08-22","Travel","Entire Series.  (Discontinued by CCTD)"]
[]
[]
[]
[]
[]
["Changes:"]