{"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":12,"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","10/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,null,null,null,"  "]
[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 - 10/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":286,"n_cols":41,"rows_kept":286,"cut":false,"hidden":false,"merged":[[275,3,275,4],[20,2,20,19],[19,14,19,15],[272,2,272,19],[11,25,11,32],[270,2,270,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]]}
[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,{"$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":"10/1/24"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-08-30"},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,"",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.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":12.05},null,"YES",12.05,0,12.05,0,null,4,12.05,null,null,12.05,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.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":14.3},null,"YES",14.3,{"$f":"+W31","v":0},{"$f":"+X31","v":14.3},{"$f":"(AG31-AC31)/AG31","v":0},null,4,{"$f":"SUM(AJ31:AL31)+AE31","v":14.3},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":14.3},{"$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.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":14.85},null,"YES",14.85,{"$f":"+W32","v":0},{"$f":"+X32","v":14.85},{"$f":"(AG32-AC32)/AG32","v":0},null,4,{"$f":"SUM(AJ32:AL32)+AE32","v":14.85},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":14.85},{"$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.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,{"$f":"+W36","v":0},8.8000000000000007,{"$f":"(AG36-AC36)/AG36","v":0},null,4,{"$f":"SUM(AJ36:AL36)+AE36","v":8.8000000000000007},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":8.8000000000000007},{"$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.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA37*(1-W37)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,0,8.8000000000000007,{"$f":"(AG37-AC37)/AG37","v":0},null,4,{"$f":"SUM(AJ37:AL37)+AE37","v":8.8000000000000007},null,null,{"$f":"ROUND(AC37/(1-VLOOKUP(AF37,Group,2,FALSE)),2)","v":8.8000000000000007},{"$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.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":10.6},null,"YES",10.6,0,10.6,{"$f":"(AG38-AC38)/AG38","v":0},null,4,{"$f":"SUM(AJ38:AL38)+AE38","v":10.6},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":10.6},{"$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.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":14.25},null,"YES",14.25,{"$f":"+W40","v":0},{"$f":"+X40","v":14.25},{"$f":"(AG40-AC40)/AG40","v":0},null,4,{"$f":"SUM(AJ40:AL40)+AE40","v":14.25},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":14.25},{"$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.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":15.65},null,"YES",15.65,{"$f":"+W42","v":0},{"$f":"+X42","v":15.65},{"$f":"(AG42-AC42)/AG42","v":0},null,6,{"$f":"SUM(AJ42:AL42)+AE42","v":15.65},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":15.65},{"$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.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA43*(1-W43)+0.004999,2)","v":18.100000000000001},null,"YES",18.100000000000001,{"$f":"+W43","v":0},{"$f":"+X43","v":18.100000000000001},{"$f":"(AG43-AC43)/AG43","v":0},null,6,{"$f":"SUM(AJ43:AL43)+AE43","v":18.100000000000001},null,null,{"$f":"ROUND(AC43/(1-VLOOKUP(AF43,Group,2,FALSE)),2)","v":18.100000000000001},{"$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.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":12.4},null,"YES",12.4,{"$f":"+W45","v":0},{"$f":"+X45","v":12.4},{"$f":"(AG45-AC45)/AG45","v":0},null,5,{"$f":"SUM(AJ45:AL45)+AE45","v":12.4},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":12.4},{"$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,"",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,"",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.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA49*(1-W49)+0.004999,2)","v":11.5},null,"YES",11.5,0,11.5,{"$f":"(AG49-AC49)/AG49","v":0},null,4,{"$f":"SUM(AJ49:AL49)+AE49","v":11.5},null,null,{"$f":"ROUND(AC49/(1-VLOOKUP(AF49,Group,2,FALSE)),2)","v":11.5},{"$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,"",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,"",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.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":11.5},null,"YES",11.5,0,11.5,{"$f":"(AG53-AC53)/AG53","v":0},null,4,{"$f":"SUM(AJ53:AL53)+AE53","v":11.5},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":11.5},{"$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.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA55*(1-W55)+0.004999,2)","v":30.15},null,"YES",30.15,{"$f":"+W55","v":0},{"$f":"+X55","v":30.15},{"$f":"(AG55-AC55)/AG55","v":0},null,6,{"$f":"SUM(AJ55:AL55)+AE55","v":30.15},null,null,{"$f":"ROUND(AC55/(1-VLOOKUP(AF55,Group,2,FALSE)),2)","v":30.15},{"$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.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":15.85},null,"YES",15.85,{"$f":"+W59","v":0},{"$f":"+X59","v":15.85},{"$f":"(AG59-AC59)/AG59","v":0},null,4,{"$f":"SUM(AJ59:AL59)+AE59","v":15.85},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":15.85},{"$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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA71*(1-W71)+0.004999,2)","v":9.9499999999999993},null,"YES",9.9499999999999993,{"$f":"+W71","v":0},9.9499999999999993,{"$f":"(AG71-AC71)/AG71","v":0},null,4,{"$f":"SUM(AJ71:AL71)+AE71","v":9.9499999999999993},null,null,{"$f":"ROUND(AC71/(1-VLOOKUP(AF71,Group,2,FALSE)),2)","v":9.9499999999999993},{"$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":10},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA72*(1-W72)+0.004999,2)","v":10},null,"YES",10,0,10,{"$f":"(AG72-AC72)/AG72","v":0},null,4,{"$f":"SUM(AJ72:AL72)+AE72","v":10},null,null,{"$f":"ROUND(AC72/(1-VLOOKUP(AF72,Group,2,FALSE)),2)","v":10},{"$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.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA73*(1-W73)+0.004999,2)","v":11.35},null,"YES",11.35,0,11.35,{"$f":"(AG73-AC73)/AG73","v":0},null,4,{"$f":"SUM(AJ73:AL73)+AE73","v":11.35},null,null,{"$f":"ROUND(AC73/(1-VLOOKUP(AF73,Group,2,FALSE)),2)","v":11.35},{"$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.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA74*(1-W74)+0.004999,2)","v":11.75},null,"YES",11.75,0,11.75,{"$f":"(AG74-AC74)/AG74","v":0},null,4,{"$f":"SUM(AJ74:AL74)+AE74","v":11.75},null,null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":11.75},{"$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.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA76*(1-W76)+0.004999,2)","v":42.4},null,"YES",42.4,{"$f":"+W76","v":0},{"$f":"+X76","v":42.4},{"$f":"(AG76-AC76)/AG76","v":0},null,6,{"$f":"SUM(AJ76:AL76)+AE76","v":42.4},null,null,{"$f":"ROUND(AC76/(1-VLOOKUP(AF76,Group,2,FALSE)),2)","v":42.4},{"$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,"",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.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+W82","v":0},8.75,{"$f":"(AG82-AC82)/AG82","v":0},null,4,{"$f":"SUM(AJ82:AL82)+AE82","v":8.75},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":8.75},{"$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.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA83*(1-W83)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,0,8.8000000000000007,{"$f":"(AG83-AC83)/AG83","v":0},null,4,{"$f":"SUM(AJ83:AL83)+AE83","v":8.8000000000000007},null,null,{"$f":"ROUND(AC83/(1-VLOOKUP(AF83,Group,2,FALSE)),2)","v":8.8000000000000007},{"$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.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":10.6},null,"YES",10.6,0,10.6,{"$f":"(AG84-AC84)/AG84","v":0},null,4,{"$f":"SUM(AJ84:AL84)+AE84","v":10.6},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":10.6},{"$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.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA85*(1-W85)+0.004999,2)","v":11.05},null,"YES",11.05,0,11.05,{"$f":"(AG85-AC85)/AG85","v":0},null,4,{"$f":"SUM(AJ85:AL85)+AE85","v":11.05},null,null,{"$f":"ROUND(AC85/(1-VLOOKUP(AF85,Group,2,FALSE)),2)","v":11.05},{"$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":17},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA87*(1-W87)+0.004999,2)","v":17},null,"YES",17,{"$f":"+W87","v":0},{"$f":"+X87","v":17},{"$f":"(AG87-AC87)/AG87","v":0},null,6,{"$f":"SUM(AJ87:AL87)+AE87","v":17},null,null,{"$f":"ROUND(AC87/(1-VLOOKUP(AF87,Group,2,FALSE)),2)","v":17},{"$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,"",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.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA91*(1-W91)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,{"$f":"+W91","v":0},{"$f":"+X91","v":8.8000000000000007},{"$f":"(AG91-AC91)/AG91","v":0},null,4,{"$f":"SUM(AJ91:AL91)+AE91","v":8.8000000000000007},null,null,{"$f":"ROUND(AC91/(1-VLOOKUP(AF91,Group,2,FALSE)),2)","v":8.8000000000000007},{"$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.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":10.6},null,"YES",10.6,{"$f":"+W92","v":0},{"$f":"+X92","v":10.6},{"$f":"(AG92-AC92)/AG92","v":0},null,4,{"$f":"SUM(AJ92:AL92)+AE92","v":10.6},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":10.6},{"$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.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA98*(1-W98)+0.004999,2)","v":15.85},null,"YES",15.85,{"$f":"+W98","v":0},{"$f":"+X98","v":15.85},{"$f":"(AG98-AC98)/AG98","v":0},null,4,{"$f":"SUM(AJ98:AL98)+AE98","v":15.85},null,null,{"$f":"ROUND(AC98/(1-VLOOKUP(AF98,Group,2,FALSE)),2)","v":15.85},{"$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  (Non-Stock Minimum 6-8 Week Delivery)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LESS",null,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.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA111*(1-W111)+0.004999,2)","v":14.85},null,"YES",14.85,{"$f":"+W111","v":0},{"$f":"+X111","v":14.85},{"$f":"(AG111-AC111)/AG111","v":0},null,4,{"$f":"SUM(AJ111:AL111)+AE111","v":14.85},null,null,{"$f":"ROUND(AC111/(1-VLOOKUP(AF111,Group,2,FALSE)),2)","v":14.85},{"$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,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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA117,AG117)","v":7.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":7.95},null,"YES",7.95,{"$f":"+W117","v":0},{"$f":"+X117","v":7.95},{"$f":"(AG117-AC117)/AG117","v":0},null,4,{"$f":"SUM(AJ117:AL117)+AE117","v":7.95},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":7.95},{"$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,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN","Stock",null,7.95,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA118*(1-W118)+0.004999,2)","v":7.95},null,"YES",7.95,0,7.95,0,null,4,7.95,null,null,7.95,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\",AA119,AG119)","v":10.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":10.6},null,"YES",10.6,{"$f":"+W119","v":0},{"$f":"+X119","v":10.6},{"$f":"(AG119-AC119)/AG119","v":0},null,4,{"$f":"SUM(AJ119:AL119)+AE119","v":10.6},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":10.6},{"$f":"IF(VLOOKUP(AF119,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ119,1)-AJ119,2),Round,2,FALSE)+VLOOKUP(AF119,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",0,ROUND(AJ119-0.04999,1)-AJ119+AM119)","v":0},{"$f":"IF(VLOOKUP(AF119,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF119,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\",AA120,AG120)","v":11.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA120*(1-W120)+0.004999,2)","v":11.05},null,"YES",11.05,{"$f":"+W120","v":0},{"$f":"+X120","v":11.05},{"$f":"(AG120-AC120)/AG120","v":0},null,4,{"$f":"SUM(AJ120:AL120)+AE120","v":11.05},null,null,{"$f":"ROUND(AC120/(1-VLOOKUP(AF120,Group,2,FALSE)),2)","v":11.05},{"$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 - 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\",AA122,AG122)","v":14.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA122*(1-W122)+0.004999,2)","v":14.25},null,"YES",14.25,{"$f":"+W122","v":0},{"$f":"+X122","v":14.25},{"$f":"(AG122-AC122)/AG122","v":0},null,4,{"$f":"SUM(AJ122:AL122)+AE122","v":14.25},null,null,{"$f":"ROUND(AC122/(1-VLOOKUP(AF122,Group,2,FALSE)),2)","v":14.25},{"$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,"2\" x 2\" Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA124,AG124)","v":17},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA124*(1-W124)+0.004999,2)","v":17},null,"YES",17,{"$f":"+W124","v":0},{"$f":"+X124","v":17},{"$f":"(AG124-AC124)/AG124","v":0},null,6,{"$f":"SUM(AJ124:AL124)+AE124","v":17},null,null,{"$f":"ROUND(AC124/(1-VLOOKUP(AF124,Group,2,FALSE)),2)","v":17},{"$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 - 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\",AA126,AG126)","v":12.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA126*(1-W126)+0.004999,2)","v":12.1},null,"",12.1,{"$f":"+W126","v":0},{"$f":"+X126","v":12.1},{"$f":"(AG126-AC126)/AG126","v":0},null,5,{"$f":"SUM(AJ126:AL126)+AE126","v":12.1},null,null,{"$f":"ROUND(AC126/(1-VLOOKUP(AF126,Group,2,FALSE)),2)","v":12.1},{"$f":"IF(VLOOKUP(AF126,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ126,1)-AJ126,2),Round,2,FALSE)+VLOOKUP(AF126,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",0,ROUND(AJ126-0.04999,1)-AJ126+AM126)","v":0},{"$f":"IF(VLOOKUP(AF126,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF126,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"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\",AA128,AG128)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA128*(1-W128)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,{"$f":"+W128","v":0},{"$f":"+X128","v":8.8000000000000007},{"$f":"(AG128-AC128)/AG128","v":0},null,4,{"$f":"SUM(AJ128:AL128)+AE128","v":8.8000000000000007},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":8.8000000000000007},{"$f":"IF(VLOOKUP(AF128,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ128,1)-AJ128,2),Round,2,FALSE)+VLOOKUP(AF128,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",0,ROUND(AJ128-0.04999,1)-AJ128+AM128)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF128,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA129,AG129)","v":10.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":10.6},null,"YES",10.6,{"$f":"+W129","v":0},{"$f":"+X129","v":10.6},{"$f":"(AG129-AC129)/AG129","v":0},null,4,{"$f":"SUM(AJ129:AL129)+AE129","v":10.6},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":10.6},{"$f":"IF(VLOOKUP(AF129,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ129,1)-AJ129,2),Round,2,FALSE)+VLOOKUP(AF129,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",0,ROUND(AJ129-0.04999,1)-AJ129+AM129)","v":0},{"$f":"IF(VLOOKUP(AF129,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF129,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Mix Cluster (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,"Import I - Decos",null,null,"12\" x 12\"",null,"Macro Mosaic",null,null,null,"Natural",null,null,null,null,"4.85 SF/CTN","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA133,AG133)","v":35.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA133*(1-W133)+0.004999,2)","v":35.4},null,"YES",35.4,{"$f":"+W133","v":0},{"$f":"+X133","v":35.4},{"$f":"(AG133-AC133)/AG133","v":0},null,6,{"$f":"SUM(AJ133:AL133)+AE133","v":35.4},null,null,{"$f":"ROUND(AC133/(1-VLOOKUP(AF133,Group,2,FALSE)),2)","v":35.4},{"$f":"IF(VLOOKUP(AF133,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ133,1)-AJ133,2),Round,2,FALSE)+VLOOKUP(AF133,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",0,ROUND(AJ133-0.04999,1)-AJ133+AM133)","v":0},{"$f":"IF(VLOOKUP(AF133,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF133,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"Mega Mosaic",null,null,null,"Natural",null,null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA134,AG134)","v":26.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA134*(1-W134)+0.004999,2)","v":26.45},null,"YES",26.45,{"$f":"+W134","v":0},{"$f":"+X134","v":26.45},{"$f":"(AG134-AC134)/AG134","v":0},null,6,{"$f":"SUM(AJ134:AL134)+AE134","v":26.45},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":26.45},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ134,1)-AJ134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AJ134-0.04999,1)-AJ134+AM134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 12\"",null,"Micro Mosaic",null,null,null,"Natural",null,null,null,null,"0.97 SF/Sheet","Stock",null,{"$f":"IF(Suggested=\"Yes\",AA135,AG135)","v":47.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA135*(1-W135)+0.004999,2)","v":47.35},null,"YES",47.35,{"$f":"+W135","v":0},{"$f":"+X135","v":47.35},{"$f":"(AG135-AC135)/AG135","v":0},null,6,{"$f":"SUM(AJ135:AL135)+AE135","v":47.35},null,null,{"$f":"ROUND(AC135/(1-VLOOKUP(AF135,Group,2,FALSE)),2)","v":47.35},{"$f":"IF(VLOOKUP(AF135,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ135,1)-AJ135,2),Round,2,FALSE)+VLOOKUP(AF135,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",0,ROUND(AJ135-0.04999,1)-AJ135+AM135)","v":0},{"$f":"IF(VLOOKUP(AF135,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF135,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","Hidden Dark          Hidden Light          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,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\",AA139,AG139)","v":8.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA139*(1-W139)+0.004999,2)","v":8.75},null,"YES",8.75,{"$f":"+W139","v":0},{"$f":"+X139","v":8.75},{"$f":"(AG139-AC139)/AG139","v":0},null,4,{"$f":"SUM(AJ139:AL139)+AE139","v":8.75},null,null,{"$f":"ROUND(AC139/(1-VLOOKUP(AF139,Group,2,FALSE)),2)","v":8.75},{"$f":"IF(VLOOKUP(AF139,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ139,1)-AJ139,2),Round,2,FALSE)+VLOOKUP(AF139,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",0,ROUND(AJ139-0.04999,1)-AJ139+AM139)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF139,Group,7,FALSE))","v":""},null,"X"]
[null,"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.8000000000000007,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,0,8.8000000000000007,0,null,4,8.8000000000000007,null,null,8.8000000000000007,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,10.6,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA141*(1-W141)+0.004999,2)","v":10.6},null,"YES",10.6,0,10.6,0,null,4,10.6,null,null,10.6,0,0,"",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,11.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA142*(1-W142)+0.004999,2)","v":11.05},null,"YES",11.05,0,11.05,0,null,4,11.05,null,null,11.05,0,0,"",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.85 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA144,AG144)","v":17},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA144*(1-W144)+0.004999,2)","v":17},null,"YES",17,{"$f":"+W144","v":0},{"$f":"+X144","v":17},{"$f":"(AG144-AC144)/AG144","v":0},null,6,{"$f":"SUM(AJ144:AL144)+AE144","v":17},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":17},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",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\",AA146,AG146)","v":12.1},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA146*(1-W146)+0.004999,2)","v":12.1},null,"",12.1,{"$f":"+W146","v":0},{"$f":"+X146","v":12.1},{"$f":"(AG146-AC146)/AG146","v":0},null,5,{"$f":"SUM(AJ146:AL146)+AE146","v":12.1},null,null,{"$f":"ROUND(AC146/(1-VLOOKUP(AF146,Group,2,FALSE)),2)","v":12.1},{"$f":"IF(VLOOKUP(AF146,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ146,1)-AJ146,2),Round,2,FALSE)+VLOOKUP(AF146,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",0,ROUND(AJ146-0.04999,1)-AJ146+AM146)","v":0},{"$f":"IF(VLOOKUP(AF146,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF146,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",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\",AA148,AG148)","v":8.8000000000000007},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":8.8000000000000007},null,"YES",8.8000000000000007,{"$f":"+W148","v":0},{"$f":"+X148","v":8.8000000000000007},{"$f":"(AG148-AC148)/AG148","v":0},null,4,{"$f":"SUM(AJ148:AL148)+AE148","v":8.8000000000000007},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":8.8000000000000007},{"$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,"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\",AA149,AG149)","v":10.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA149*(1-W149)+0.004999,2)","v":10.6},null,"YES",10.6,{"$f":"+W149","v":0},{"$f":"+X149","v":10.6},{"$f":"(AG149-AC149)/AG149","v":0},null,4,{"$f":"SUM(AJ149:AL149)+AE149","v":10.6},null,null,{"$f":"ROUND(AC149/(1-VLOOKUP(AF149,Group,2,FALSE)),2)","v":10.6},{"$f":"IF(VLOOKUP(AF149,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ149,1)-AJ149,2),Round,2,FALSE)+VLOOKUP(AF149,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",0,ROUND(AJ149-0.04999,1)-AJ149+AM149)","v":0},{"$f":"IF(VLOOKUP(AF149,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF149,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA155,AG155)","v":15.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA155*(1-W155)+0.004999,2)","v":15.85},null,"YES",15.85,{"$f":"+W155","v":0},{"$f":"+X155","v":15.85},{"$f":"(AG155-AC155)/AG155","v":0},null,4,{"$f":"SUM(AJ155:AL155)+AE155","v":15.85},null,null,{"$f":"ROUND(AC155/(1-VLOOKUP(AF155,Group,2,FALSE)),2)","v":15.85},{"$f":"IF(VLOOKUP(AF155,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ155,1)-AJ155,2),Round,2,FALSE)+VLOOKUP(AF155,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF155,Group,7,FALSE)=\"\",0,ROUND(AJ155-0.04999,1)-AJ155+AM155)","v":0},{"$f":"IF(VLOOKUP(AF155,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF155,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,"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\",AA164,AG164)","v":6.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":6.6},null,"YES",6.6,{"$f":"+W164","v":0},{"$f":"+X164","v":6.6},{"$f":"(AG164-AC164)/AG164","v":0},null,1,{"$f":"SUM(AJ164:AL164)+AE164","v":6.6},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":6.6},{"$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,"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\",AA165,AG165)","v":6.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":6.6},null,"YES",6.6,{"$f":"+W165","v":0},{"$f":"+X165","v":6.6},{"$f":"(AG165-AC165)/AG165","v":0},null,1,{"$f":"SUM(AJ165:AL165)+AE165","v":6.6},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":6.6},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA167,AG167)","v":22.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA167*(1-W167)+0.004999,2)","v":22.8},null,"YES",22.8,{"$f":"+W167","v":0},{"$f":"+X167","v":22.8},{"$f":"(AG167-AC167)/AG167","v":0},null,3,{"$f":"SUM(AJ167:AL167)+AE167","v":22.8},null,null,{"$f":"ROUND(AC167/(1-VLOOKUP(AF167,Group,2,FALSE)),2)","v":22.8},{"$f":"IF(VLOOKUP(AF167,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ167,1)-AJ167,2),Round,2,FALSE)+VLOOKUP(AF167,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",0,ROUND(AJ167-0.04999,1)-AJ167+AM167)","v":0},{"$f":"IF(VLOOKUP(AF167,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF167,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA168,AG168)","v":22.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA168*(1-W168)+0.004999,2)","v":22.8},null,"YES",22.8,{"$f":"+W168","v":0},{"$f":"+X168","v":22.8},{"$f":"(AG168-AC168)/AG168","v":0},null,3,{"$f":"SUM(AJ168:AL168)+AE168","v":22.8},null,null,{"$f":"ROUND(AC168/(1-VLOOKUP(AF168,Group,2,FALSE)),2)","v":22.8},{"$f":"IF(VLOOKUP(AF168,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ168,1)-AJ168,2),Round,2,FALSE)+VLOOKUP(AF168,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",0,ROUND(AJ168-0.04999,1)-AJ168+AM168)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF168,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA170,AG170)","v":10.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA170*(1-W170)+0.004999,2)","v":10.3},null,"",10.3,{"$f":"+W170","v":0},{"$f":"+X170","v":10.3},{"$f":"(AG170-AC170)/AG170","v":0},null,2,{"$f":"SUM(AJ170:AL170)+AE170","v":10.3},null,null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":10.3},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ170,1)-AJ170,2),Round,2,FALSE)+VLOOKUP(AF170,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",0,ROUND(AJ170-0.04999,1)-AJ170+AM170)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF170,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA181,AG181)","v":12.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA181*(1-W181)+0.004999,2)","v":12.75},null,"YES",12.75,{"$f":"+W181","v":0},12.75,{"$f":"(AG181-AC181)/AG181","v":0},null,4,{"$f":"SUM(AJ181:AL181)+AE181","v":12.75},null,null,{"$f":"ROUND(AC181/(1-VLOOKUP(AF181,Group,2,FALSE)),2)","v":12.75},{"$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,"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\",AA182,AG182)","v":13.65},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA182*(1-W182)+0.004999,2)","v":13.65},null,"",13.65,0,13.65,{"$f":"(AG182-AC182)/AG182","v":0},null,4,{"$f":"SUM(AJ182:AL182)+AE182","v":13.65},null,null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":13.65},{"$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,"39\" x 118\" x 5.5mm",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"32.29 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":17.649999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":17.649999999999999},null,"",17.649999999999999,0,17.649999999999999,{"$f":"(AG183-AC183)/AG183","v":0},null,4,{"$f":"SUM(AJ183:AL183)+AE183","v":17.649999999999999},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":17.649999999999999},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA192,AG192)","v":8.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA192*(1-W192)+0.004999,2)","v":8.85},null,"YES",8.85,{"$f":"+W192","v":0},8.85,{"$f":"(AG192-AC192)/AG192","v":0},null,4,{"$f":"SUM(AJ192:AL192)+AE192","v":8.85},null,null,{"$f":"ROUND(AC192/(1-VLOOKUP(AF192,Group,2,FALSE)),2)","v":8.85},{"$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,"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\",AA193,AG193)","v":8.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA193*(1-W193)+0.004999,2)","v":8.85},null,"YES",8.85,0,8.85,{"$f":"(AG193-AC193)/AG193","v":0},null,4,{"$f":"SUM(AJ193:AL193)+AE193","v":8.85},null,null,{"$f":"ROUND(AC193/(1-VLOOKUP(AF193,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF193,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ193,1)-AJ193,2),Round,2,FALSE)+VLOOKUP(AF193,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",0,ROUND(AJ193-0.04999,1)-AJ193+AM193)","v":0},{"$f":"IF(VLOOKUP(AF193,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF193,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\",AA194,AG194)","v":9.4499999999999993},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA194*(1-W194)+0.004999,2)","v":9.4499999999999993},null,"YES",9.4499999999999993,0,9.4499999999999993,{"$f":"(AG194-AC194)/AG194","v":0},null,4,{"$f":"SUM(AJ194:AL194)+AE194","v":9.4499999999999993},null,null,{"$f":"ROUND(AC194/(1-VLOOKUP(AF194,Group,2,FALSE)),2)","v":9.4499999999999993},{"$f":"IF(VLOOKUP(AF194,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ194,1)-AJ194,2),Round,2,FALSE)+VLOOKUP(AF194,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",0,ROUND(AJ194-0.04999,1)-AJ194+AM194)","v":0},{"$f":"IF(VLOOKUP(AF194,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF194,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\",AA195,AG195)","v":11.15},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA195*(1-W195)+0.004999,2)","v":11.15},null,"YES",11.15,0,11.15,{"$f":"(AG195-AC195)/AG195","v":0},null,4,{"$f":"SUM(AJ195:AL195)+AE195","v":11.15},null,null,{"$f":"ROUND(AC195/(1-VLOOKUP(AF195,Group,2,FALSE)),2)","v":11.15},{"$f":"IF(VLOOKUP(AF195,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ195,1)-AJ195,2),Round,2,FALSE)+VLOOKUP(AF195,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF195,Group,7,FALSE)=\"\",0,ROUND(AJ195-0.04999,1)-AJ195+AM195)","v":0},{"$f":"IF(VLOOKUP(AF195,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF195,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\",AA196,AG196)","v":10.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA196*(1-W196)+0.004999,2)","v":10.9},null,"YES",10.9,0,10.9,{"$f":"(AG196-AC196)/AG196","v":0},null,4,{"$f":"SUM(AJ196:AL196)+AE196","v":10.9},null,null,{"$f":"ROUND(AC196/(1-VLOOKUP(AF196,Group,2,FALSE)),2)","v":10.9},{"$f":"IF(VLOOKUP(AF196,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ196,1)-AJ196,2),Round,2,FALSE)+VLOOKUP(AF196,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF196,Group,7,FALSE)=\"\",0,ROUND(AJ196-0.04999,1)-AJ196+AM196)","v":0},{"$f":"IF(VLOOKUP(AF196,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF196,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,"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\",AA203,AG203)","v":14.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA203*(1-W203)+0.004999,2)","v":14.3},null,"",14.3,{"$f":"+W203","v":0},14.3,{"$f":"(AG203-AC203)/AG203","v":0},null,4,{"$f":"SUM(AJ203:AL203)+AE203","v":14.3},null,null,{"$f":"ROUND(AC203/(1-VLOOKUP(AF203,Group,2,FALSE)),2)","v":14.3},{"$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 - 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\",AA204,AG204)","v":17.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA204*(1-W204)+0.004999,2)","v":17.5},null,"YES",17.5,0,17.5,{"$f":"(AG204-AC204)/AG204","v":0},null,4,{"$f":"SUM(AJ204:AL204)+AE204","v":17.5},null,null,{"$f":"ROUND(AC204/(1-VLOOKUP(AF204,Group,2,FALSE)),2)","v":17.5},{"$f":"IF(VLOOKUP(AF204,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ204,1)-AJ204,2),Round,2,FALSE)+VLOOKUP(AF204,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",0,ROUND(AJ204-0.04999,1)-AJ204+AM204)","v":0},{"$f":"IF(VLOOKUP(AF204,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF204,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\",AA205,AG205)","v":17.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA205*(1-W205)+0.004999,2)","v":17.5},null,"YES",17.5,0,17.5,{"$f":"(AG205-AC205)/AG205","v":0},null,4,{"$f":"SUM(AJ205:AL205)+AE205","v":17.5},null,null,{"$f":"ROUND(AC205/(1-VLOOKUP(AF205,Group,2,FALSE)),2)","v":17.5},{"$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 - 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\",AA206,AG206)","v":21.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA206*(1-W206)+0.004999,2)","v":21.45},null,"YES",21.45,0,21.45,{"$f":"(AG206-AC206)/AG206","v":0},null,4,{"$f":"SUM(AJ206:AL206)+AE206","v":21.45},null,null,{"$f":"ROUND(AC206/(1-VLOOKUP(AF206,Group,2,FALSE)),2)","v":21.45},{"$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 - 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\",AA207,AG207)","v":21.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA207*(1-W207)+0.004999,2)","v":21.45},null,"YES",21.45,0,21.45,{"$f":"(AG207-AC207)/AG207","v":0},null,4,{"$f":"SUM(AJ207:AL207)+AE207","v":21.45},null,null,{"$f":"ROUND(AC207/(1-VLOOKUP(AF207,Group,2,FALSE)),2)","v":21.45},{"$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 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\",AA209,AG209)","v":15.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA209*(1-W209)+0.004999,2)","v":15.85},null,"YES",15.85,{"$f":"+W209","v":0},15.85,{"$f":"(AG209-AC209)/AG209","v":0},null,6,{"$f":"SUM(AJ209:AL209)+AE209","v":15.85},null,null,{"$f":"ROUND(AC209/(1-VLOOKUP(AF209,Group,2,FALSE)),2)","v":15.85},{"$f":"IF(VLOOKUP(AF209,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ209,1)-AJ209,2),Round,2,FALSE)+VLOOKUP(AF209,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",0,ROUND(AJ209-0.04999,1)-AJ209+AM209)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF209,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\",AA210,AG210)","v":16.850000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA210*(1-W210)+0.004999,2)","v":16.850000000000001},null,"YES",16.850000000000001,0,16.850000000000001,{"$f":"(AG210-AC210)/AG210","v":0},null,6,{"$f":"SUM(AJ210:AL210)+AE210","v":16.850000000000001},null,null,{"$f":"ROUND(AC210/(1-VLOOKUP(AF210,Group,2,FALSE)),2)","v":16.850000000000001},{"$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,"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\",AA211,AG211)","v":18.100000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA211*(1-W211)+0.004999,2)","v":18.100000000000001},null,"YES",18.100000000000001,0,18.100000000000001,{"$f":"(AG211-AC211)/AG211","v":0},null,6,{"$f":"SUM(AJ211:AL211)+AE211","v":18.100000000000001},null,null,{"$f":"ROUND(AC211/(1-VLOOKUP(AF211,Group,2,FALSE)),2)","v":18.100000000000001},{"$f":"IF(VLOOKUP(AF211,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ211,1)-AJ211,2),Round,2,FALSE)+VLOOKUP(AF211,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",0,ROUND(AJ211-0.04999,1)-AJ211+AM211)","v":0},{"$f":"IF(VLOOKUP(AF211,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF211,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"11-1/2\" x 23-1/4\"",null,"Muretto 3D Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"7.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA212,AG212)","v":39.700000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":39.700000000000003},null,"YES",39.700000000000003,0,39.700000000000003,{"$f":"(AG212-AC212)/AG212","v":0},null,6,{"$f":"SUM(AJ212:AL212)+AE212","v":39.700000000000003},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":39.700000000000003},{"$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,"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\",AA214,AG214)","v":17.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA214*(1-W214)+0.004999,2)","v":17.25},null,"YES",17.25,{"$f":"+W214","v":0},{"$f":"+X214","v":17.25},{"$f":"(AG214-AC214)/AG214","v":0},null,5,{"$f":"SUM(AJ214:AL214)+AE214","v":17.25},null,null,{"$f":"ROUND(AC214/(1-VLOOKUP(AF214,Group,2,FALSE)),2)","v":17.25},{"$f":"IF(VLOOKUP(AF214,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ214,1)-AJ214,2),Round,2,FALSE)+VLOOKUP(AF214,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",0,ROUND(AJ214-0.04999,1)-AJ214+AM214)","v":0},{"$f":"IF(VLOOKUP(AF214,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF214,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,"Semi-Polished/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA216,AG216)","v":9.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":9.5},null,"YES",9.5,{"$f":"+W216","v":0},9.5,{"$f":"(AG216-AC216)/AG216","v":0},null,4,{"$f":"SUM(AJ216:AL216)+AE216","v":9.5},null,null,{"$f":"ROUND(AC216/(1-VLOOKUP(AF216,Group,2,FALSE)),2)","v":9.5},{"$f":"IF(VLOOKUP(AF216,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ216,1)-AJ216,2),Round,2,FALSE)+VLOOKUP(AF216,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",0,ROUND(AJ216-0.04999,1)-AJ216+AM216)","v":0},{"$f":"IF(VLOOKUP(AF216,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF216,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\",AA217,AG217)","v":9.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA217*(1-W217)+0.004999,2)","v":9.5},null,"YES",9.5,0,9.5,{"$f":"(AG217-AC217)/AG217","v":0},null,4,{"$f":"SUM(AJ217:AL217)+AE217","v":9.5},null,null,{"$f":"ROUND(AC217/(1-VLOOKUP(AF217,Group,2,FALSE)),2)","v":9.5},{"$f":"IF(VLOOKUP(AF217,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ217,1)-AJ217,2),Round,2,FALSE)+VLOOKUP(AF217,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF217,Group,7,FALSE)=\"\",0,ROUND(AJ217-0.04999,1)-AJ217+AM217)","v":0},{"$f":"IF(VLOOKUP(AF217,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF217,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\",AA218,AG218)","v":10.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA218*(1-W218)+0.004999,2)","v":10.4},null,"YES",10.4,{"$f":"+W218","v":0},{"$f":"+X218","v":10.4},{"$f":"(AG218-AC218)/AG218","v":0},null,4,{"$f":"SUM(AJ218:AL218)+AE218","v":10.4},null,null,{"$f":"ROUND(AC218/(1-VLOOKUP(AF218,Group,2,FALSE)),2)","v":10.4},{"$f":"IF(VLOOKUP(AF218,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ218,1)-AJ218,2),Round,2,FALSE)+VLOOKUP(AF218,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",0,ROUND(AJ218-0.04999,1)-AJ218+AM218)","v":0},{"$f":"IF(VLOOKUP(AF218,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF218,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\",AA219,AG219)","v":12.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA219*(1-W219)+0.004999,2)","v":12.2},null,"YES",12.2,{"$f":"+W219","v":0},{"$f":"+X219","v":12.2},{"$f":"(AG219-AC219)/AG219","v":0},null,4,{"$f":"SUM(AJ219:AL219)+AE219","v":12.2},null,null,{"$f":"ROUND(AC219/(1-VLOOKUP(AF219,Group,2,FALSE)),2)","v":12.2},{"$f":"IF(VLOOKUP(AF219,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ219,1)-AJ219,2),Round,2,FALSE)+VLOOKUP(AF219,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",0,ROUND(AJ219-0.04999,1)-AJ219+AM219)","v":0},{"$f":"IF(VLOOKUP(AF219,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF219,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\",AA220,AG220)","v":11.8},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA220*(1-W220)+0.004999,2)","v":11.8},null,"YES",11.8,0,11.8,{"$f":"(AG220-AC220)/AG220","v":0},null,4,{"$f":"SUM(AJ220:AL220)+AE220","v":11.8},null,null,{"$f":"ROUND(AC220/(1-VLOOKUP(AF220,Group,2,FALSE)),2)","v":11.8},{"$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 - 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\",AA222,AG222)","v":16.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA222*(1-W222)+0.004999,2)","v":16.75},null,"",16.75,{"$f":"+W222","v":0},16.75,{"$f":"(AG222-AC222)/AG222","v":0},null,6,{"$f":"SUM(AJ222:AL222)+AE222","v":16.75},null,null,{"$f":"ROUND(AC222/(1-VLOOKUP(AF222,Group,2,FALSE)),2)","v":16.75},{"$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,"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\",AA223,AG223)","v":17.600000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA223*(1-W223)+0.004999,2)","v":17.600000000000001},null,"YES",17.600000000000001,0,17.600000000000001,{"$f":"(AG223-AC223)/AG223","v":0},null,6,{"$f":"SUM(AJ223:AL223)+AE223","v":17.600000000000001},null,null,{"$f":"ROUND(AC223/(1-VLOOKUP(AF223,Group,2,FALSE)),2)","v":17.600000000000001},{"$f":"IF(VLOOKUP(AF223,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ223,1)-AJ223,2),Round,2,FALSE)+VLOOKUP(AF223,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,7,FALSE)=\"\",0,ROUND(AJ223-0.04999,1)-AJ223+AM223)","v":0},{"$f":"IF(VLOOKUP(AF223,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF223,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\",AA224,AG224)","v":18.399999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA224*(1-W224)+0.004999,2)","v":18.399999999999999},null,"YES",18.399999999999999,0,18.399999999999999,{"$f":"(AG224-AC224)/AG224","v":0},null,6,{"$f":"SUM(AJ224:AL224)+AE224","v":18.399999999999999},null,null,{"$f":"ROUND(AC224/(1-VLOOKUP(AF224,Group,2,FALSE)),2)","v":18.399999999999999},{"$f":"IF(VLOOKUP(AF224,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ224,1)-AJ224,2),Round,2,FALSE)+VLOOKUP(AF224,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",0,ROUND(AJ224-0.04999,1)-AJ224+AM224)","v":0},{"$f":"IF(VLOOKUP(AF224,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF224,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"11-1/2\" x 23-1/4\"",null,"Muretto 3D Mosaic",null,null,null,"Semi-Polished",null,null,"(Mesh-Mounted)",null,"7.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA225,AG225)","v":40.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA225*(1-W225)+0.004999,2)","v":40.75},null,"YES",40.75,0,40.75,{"$f":"(AG225-AC225)/AG225","v":0},null,6,{"$f":"SUM(AJ225:AL225)+AE225","v":40.75},null,null,{"$f":"ROUND(AC225/(1-VLOOKUP(AF225,Group,2,FALSE)),2)","v":40.75},{"$f":"IF(VLOOKUP(AF225,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ225,1)-AJ225,2),Round,2,FALSE)+VLOOKUP(AF225,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",0,ROUND(AJ225-0.04999,1)-AJ225+AM225)","v":0},{"$f":"IF(VLOOKUP(AF225,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF225,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\",AA227,AG227)","v":18.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA227*(1-W227)+0.004999,2)","v":18.7},null,"YES",18.7,{"$f":"+W227","v":0},{"$f":"+X227","v":18.7},{"$f":"(AG227-AC227)/AG227","v":0},null,5,{"$f":"SUM(AJ227:AL227)+AE227","v":18.7},null,null,{"$f":"ROUND(AC227/(1-VLOOKUP(AF227,Group,2,FALSE)),2)","v":18.7},{"$f":"IF(VLOOKUP(AF227,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ227,1)-AJ227,2),Round,2,FALSE)+VLOOKUP(AF227,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF227,Group,7,FALSE)=\"\",0,ROUND(AJ227-0.04999,1)-AJ227+AM227)","v":0},{"$f":"IF(VLOOKUP(AF227,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF227,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\",AA229,AG229)","v":8.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA229*(1-W229)+0.004999,2)","v":8.85},null,"",8.85,{"$f":"+W229","v":0},{"$f":"+X229","v":8.85},{"$f":"(AG229-AC229)/AG229","v":0},null,4,{"$f":"SUM(AJ229:AL229)+AE229","v":8.85},null,null,{"$f":"ROUND(AC229/(1-VLOOKUP(AF229,Group,2,FALSE)),2)","v":8.85},{"$f":"IF(VLOOKUP(AF229,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ229,1)-AJ229,2),Round,2,FALSE)+VLOOKUP(AF229,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",0,ROUND(AJ229-0.04999,1)-AJ229+AM229)","v":0},{"$f":"IF(VLOOKUP(AF229,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF229,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\",AA237,AG237)","v":14.35},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA237*(1-W237)+0.004999,2)","v":14.35},null,"YES",14.35,{"$f":"+W237","v":0},14.35,{"$f":"(AG237-AC237)/AG237","v":0},null,4,{"$f":"SUM(AJ237:AL237)+AE237","v":14.35},null,null,{"$f":"ROUND(AC237/(1-VLOOKUP(AF237,Group,2,FALSE)),2)","v":14.35},{"$f":"IF(VLOOKUP(AF237,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ237,1)-AJ237,2),Round,2,FALSE)+VLOOKUP(AF237,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",0,ROUND(AJ237-0.04999,1)-AJ237+AM237)","v":0},{"$f":"IF(VLOOKUP(AF237,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF237,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\",AA238,AG238)","v":14.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA238*(1-W238)+0.004999,2)","v":14.3},null,"YES",14.3,0,14.3,{"$f":"(AG238-AC238)/AG238","v":0},null,4,{"$f":"SUM(AJ238:AL238)+AE238","v":14.3},null,null,{"$f":"ROUND(AC238/(1-VLOOKUP(AF238,Group,2,FALSE)),2)","v":14.3},{"$f":"IF(VLOOKUP(AF238,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ238,1)-AJ238,2),Round,2,FALSE)+VLOOKUP(AF238,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF238,Group,7,FALSE)=\"\",0,ROUND(AJ238-0.04999,1)-AJ238+AM238)","v":0},{"$f":"IF(VLOOKUP(AF238,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF238,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\",AA239,AG239)","v":16.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA239*(1-W239)+0.004999,2)","v":16.55},null,"YES",16.55,0,16.55,{"$f":"(AG239-AC239)/AG239","v":0},null,4,{"$f":"SUM(AJ239:AL239)+AE239","v":16.55},null,null,{"$f":"ROUND(AC239/(1-VLOOKUP(AF239,Group,2,FALSE)),2)","v":16.55},{"$f":"IF(VLOOKUP(AF239,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ239,1)-AJ239,2),Round,2,FALSE)+VLOOKUP(AF239,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF239,Group,7,FALSE)=\"\",0,ROUND(AJ239-0.04999,1)-AJ239+AM239)","v":0},{"$f":"IF(VLOOKUP(AF239,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF239,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,"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":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","www.conestogatile.com"]
[]
["Manufacturer's Home Page","http://www.leausa.us/"]
[]
[]
["Product","Direct Website Link"]
["Anthology","https://www.leaceramiche.com/collection/anthology"]
["Masterpiece","https://www.leausa.us/collection/masterpiece"]
["Side Stone","https://www.leaceramiche.com/collection/sidestone"]
["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"]
["2024-10-01","Side Stone","Full-Body Porcelain / Anti-Microbial"]
[]
[]
["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:"]