{"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":11,"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","7/1/22 (Updated)"]
[]
[]
[]
["Enter your Company Name"]
[]
[null,"Click on \"Index\" to set the print area for the price list index"]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Suggested Price List\" to set the print area for Conestoga Tile's suggested price list."]
[null,"Then you can send it to print"]
[]
[]
[null,"Enter your discount codes if you want a personal net cost sheet."]
[]
[null,"Product"]
[null,"Code","Disc. %"]
[null,{"$f":"+B3","v":"B"}]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,"Import I - Field Tile",null,"No",0,null,null,null," "]
[null,5,null,"Import I - Trim",null,"No",0]
[null,6,null,"Import I - Decos",null,"No",0]
[null,7,null,0,null,"No",0]
[null,8,null,0,null,"No",0]
[null,9,null,0,null,"No",0]
[]
["If you want to manually adjust your price list, hit \"F5\" and go to \"Customer_Cost\" to manually adjust pricing."]
["You can enter a value in the column labeled \"Adj.\" to change your price manually."]
[]
[null,"Click on \"Your Price Calculation\" to set the print area for your personal cost calculation report."]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Your Price List\" to set the print area for your personal price list."]
[null,"Then you can send it to print"]
[null,null,null,null,null,null,null,"Yes"]
[]
["If you have any questions on how to best use this spreadsheet, please feel free to contact"]
["Jim Vogel at (800) 422-6860, ext. 4201 or via e-mail at jimvogel@cctd.com"]

{"sheet":"Index","index":1,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,0,5,10],[46,0,46,10],[48,0,48,10],[2,5,2,10]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'L' - Lea Ceramiche"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 7/1/22 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type"]
["1",null,"Anthology",null,"Full-Body Porcelain"]
["1-2",null,"Masterpiece",null,"Full-Body Porcelain"]
[2,null,"The Rock",null,"Full-Body Porcelain"]
[2,null,"Travel - DISC. 8/22/22 by CCTD",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.  If you would like to obtain a copy, please email Conestoga Tile at service@cctd.com."]
[]
["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":289,"n_cols":41,"rows_kept":289,"cut":false,"hidden":false,"merged":[[11,14,11,19],[11,22,11,23],[11,25,11,32],[273,2,273,19],[14,14,14,19],[16,13,17,19],[15,30,15,32],[14,22,14,23],[278,3,278,4],[20,2,20,19],[19,14,19,15],[275,2,275,19],[12,14,12,15]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA1,AG1)","v":0.05},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA1*(1-W1)+0.004999,2)","v":0.05},null,"new",0.05,{"$f":"+W1","v":0},0.05,{"$f":"(AG1-AC1)/AG1","v":0},null,1,{"$f":"SUM(AJ1:AL1)+AE1","v":0.05},null,null,{"$f":"ROUND(AC1/(1-VLOOKUP(AF1,Group,2,FALSE)),2)","v":0.05},{"$f":"IF(VLOOKUP(AF1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ1,1)-AJ1,2),Round,2,FALSE)+VLOOKUP(AF1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",0,ROUND(AJ1-0.04999,1)-AJ1+AM1)","v":0},{"$f":"IF(VLOOKUP(AF1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF1,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA2,AG2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,2,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,3,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Field Tile",null,null,"Size",null,"Field",null,"Description",null,null,null,null,null,null,"SF/CTN",null,null,0.05,"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,4,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,5,0.05,null,null,0.05,0,0,"",null,"X"]
[null,"Import I - Decos",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},0.05,null,"new",0.05,0,0.05,0,null,6,0.05,null,null,0.05,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$error":"#VALUE!"},null,"new",{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA8,AG8)","v":{"$error":"#VALUE!"}},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA8*(1-W8)+0.004999,2)","v":{"$error":"#VALUE!"}},null,"new",{"$error":"#VALUE!"},{"$f":"+W8","v":0},{"$f":"+X8","v":{"$error":"#VALUE!"}},{"$f":"(AG8-AC8)/AG8","v":{"$error":"#VALUE!"}},null,8,{"$f":"SUM(AJ8:AL8)+AE8","v":{"$error":"#VALUE!"}},null,null,{"$f":"ROUND(AC8/(1-VLOOKUP(AF8,Group,2,FALSE)),2)","v":{"$error":"#VALUE!"}},{"$f":"IF(VLOOKUP(AF8,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ8,1)-AJ8,2),Round,2,FALSE)+VLOOKUP(AF8,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",0,ROUND(AJ8-0.04999,1)-AJ8+AM8)","v":0},{"$f":"IF(VLOOKUP(AF8,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF8,Group,7,FALSE))","v":""},null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA9,AG9)","v":{"$error":"#VALUE!"}},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA9*(1-W9)+0.004999,2)","v":{"$error":"#VALUE!"}},null,"new",{"$error":"#VALUE!"},{"$f":"+W9","v":0},{"$f":"+X9","v":{"$error":"#VALUE!"}},{"$f":"(AG9-AC9)/AG9","v":{"$error":"#VALUE!"}},null,9,{"$f":"SUM(AJ9:AL9)+AE9","v":{"$error":"#VALUE!"}},null,null,{"$f":"ROUND(AC9/(1-VLOOKUP(AF9,Group,2,FALSE)),2)","v":{"$error":"#VALUE!"}},{"$f":"IF(VLOOKUP(AF9,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ9,1)-AJ9,2),Round,2,FALSE)+VLOOKUP(AF9,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF9,Group,7,FALSE)=\"\",0,ROUND(AJ9-0.04999,1)-AJ9+AM9)","v":0},{"$f":"IF(VLOOKUP(AF9,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF9,Group,7,FALSE))","v":""},null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA13,AG13)","v":"List Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","List Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'L' - Lea Ceramiche"},null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"7/1/22 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-07-19"},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,"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          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,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA29,AG29)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA29*(1-W29)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W29","v":0},10.85,{"$f":"(AG29-AC29)/AG29","v":0},null,4,{"$f":"SUM(AJ29:AL29)+AE29","v":10.85},null,null,{"$f":"ROUND(AC29/(1-VLOOKUP(AF29,Group,2,FALSE)),2)","v":10.85},{"$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,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA30,AG30)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA30*(1-W30)+0.004999,2)","v":10.85},null,"",10.85,0,10.85,{"$f":"(AG30-AC30)/AG30","v":0},null,4,{"$f":"SUM(AJ30:AL30)+AE30","v":10.85},null,null,{"$f":"ROUND(AC30/(1-VLOOKUP(AF30,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF30,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ30,1)-AJ30,2),Round,2,FALSE)+VLOOKUP(AF30,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",0,ROUND(AJ30-0.04999,1)-AJ30+AM30)","v":0},{"$f":"IF(VLOOKUP(AF30,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF30,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA31,AG31)","v":12.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":12.85},null,"",12.85,0,12.85,{"$f":"(AG31-AC31)/AG31","v":0},null,4,{"$f":"SUM(AJ31:AL31)+AE31","v":12.85},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":12.85},{"$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,"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\",AA33,AG33)","v":15.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA33*(1-W33)+0.004999,2)","v":15.6},null,"",15.6,{"$f":"+W33","v":0},{"$f":"+X33","v":15.6},{"$f":"(AG33-AC33)/AG33","v":0},null,4,{"$f":"SUM(AJ33:AL33)+AE33","v":15.6},null,null,{"$f":"ROUND(AC33/(1-VLOOKUP(AF33,Group,2,FALSE)),2)","v":15.6},{"$f":"IF(VLOOKUP(AF33,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ33,1)-AJ33,2),Round,2,FALSE)+VLOOKUP(AF33,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",0,ROUND(AJ33-0.04999,1)-AJ33+AM33)","v":0},{"$f":"IF(VLOOKUP(AF33,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF33,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA35,AG35)","v":20.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA35*(1-W35)+0.004999,2)","v":20.45},null,"",20.45,{"$f":"+W35","v":0},{"$f":"+X35","v":20.45},{"$f":"(AG35-AC35)/AG35","v":0},null,6,{"$f":"SUM(AJ35:AL35)+AE35","v":20.45},null,null,{"$f":"ROUND(AC35/(1-VLOOKUP(AF35,Group,2,FALSE)),2)","v":20.45},{"$f":"IF(VLOOKUP(AF35,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ35,1)-AJ35,2),Round,2,FALSE)+VLOOKUP(AF35,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",0,ROUND(AJ35-0.04999,1)-AJ35+AM35)","v":0},{"$f":"IF(VLOOKUP(AF35,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF35,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA36,AG36)","v":22.9},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA36*(1-W36)+0.004999,2)","v":22.9},null,"",22.9,{"$f":"+W36","v":0},{"$f":"+X36","v":22.9},{"$f":"(AG36-AC36)/AG36","v":0},null,6,{"$f":"SUM(AJ36:AL36)+AE36","v":22.9},null,null,{"$f":"ROUND(AC36/(1-VLOOKUP(AF36,Group,2,FALSE)),2)","v":22.9},{"$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 - 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\",AA38,AG38)","v":13.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA38*(1-W38)+0.004999,2)","v":13.75},null,"",13.75,{"$f":"+W38","v":0},{"$f":"+X38","v":13.75},{"$f":"(AG38-AC38)/AG38","v":0},null,5,{"$f":"SUM(AJ38:AL38)+AE38","v":13.75},null,null,{"$f":"ROUND(AC38/(1-VLOOKUP(AF38,Group,2,FALSE)),2)","v":13.75},{"$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 - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Natural",null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA40,AG40)","v":364.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA40*(1-W40)+0.004999,2)","v":364.65},null,"",364.65,{"$f":"+W40","v":0},364.65,{"$f":"(AG40-AC40)/AG40","v":0},null,5,{"$f":"SUM(AJ40:AL40)+AE40","v":364.65},null,null,{"$f":"ROUND(AC40/(1-VLOOKUP(AF40,Group,2,FALSE)),2)","v":364.65},{"$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 - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA41,AG41)","v":495.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA41*(1-W41)+0.004999,2)","v":495.65},null,"",495.65,0,495.65,{"$f":"(AG41-AC41)/AG41","v":0},null,5,{"$f":"SUM(AJ41:AL41)+AE41","v":495.65},null,null,{"$f":"ROUND(AC41/(1-VLOOKUP(AF41,Group,2,FALSE)),2)","v":495.65},{"$f":"IF(VLOOKUP(AF41,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ41,1)-AJ41,2),Round,2,FALSE)+VLOOKUP(AF41,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",0,ROUND(AJ41-0.04999,1)-AJ41+AM41)","v":0},{"$f":"IF(VLOOKUP(AF41,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF41,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":495.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":495.65},null,"",495.65,0,495.65,{"$f":"(AG42-AC42)/AG42","v":0},null,5,{"$f":"SUM(AJ42:AL42)+AE42","v":495.65},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":495.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA44,AG44)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA44*(1-W44)+0.004999,2)","v":11.6},null,"",11.6,{"$f":"+W44","v":0},11.6,{"$f":"(AG44-AC44)/AG44","v":0},null,4,{"$f":"SUM(AJ44:AL44)+AE44","v":11.6},null,null,{"$f":"ROUND(AC44/(1-VLOOKUP(AF44,Group,2,FALSE)),2)","v":11.6},{"$f":"IF(VLOOKUP(AF44,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ44,1)-AJ44,2),Round,2,FALSE)+VLOOKUP(AF44,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",0,ROUND(AJ44-0.04999,1)-AJ44+AM44)","v":0},{"$f":"IF(VLOOKUP(AF44,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF44,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA45,AG45)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA45*(1-W45)+0.004999,2)","v":11.6},null,"",11.6,0,11.6,{"$f":"(AG45-AC45)/AG45","v":0},null,4,{"$f":"SUM(AJ45:AL45)+AE45","v":11.6},null,null,{"$f":"ROUND(AC45/(1-VLOOKUP(AF45,Group,2,FALSE)),2)","v":11.6},{"$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,"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\",AA46,AG46)","v":13.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":13.85},null,"",13.85,0,13.85,{"$f":"(AG46-AC46)/AG46","v":0},null,4,{"$f":"SUM(AJ46:AL46)+AE46","v":13.85},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":13.85},{"$f":"IF(VLOOKUP(AF46,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ46,1)-AJ46,2),Round,2,FALSE)+VLOOKUP(AF46,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",0,ROUND(AJ46-0.04999,1)-AJ46+AM46)","v":0},{"$f":"IF(VLOOKUP(AF46,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF46,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Rough",null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA48,AG48)","v":366.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA48*(1-W48)+0.004999,2)","v":366.7},null,"",366.7,{"$f":"+W48","v":0},366.7,{"$f":"(AG48-AC48)/AG48","v":0},null,5,{"$f":"SUM(AJ48:AL48)+AE48","v":366.7},null,null,{"$f":"ROUND(AC48/(1-VLOOKUP(AF48,Group,2,FALSE)),2)","v":366.7},{"$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 - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Rough",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA49,AG49)","v":498.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA49*(1-W49)+0.004999,2)","v":498.25},null,"",498.25,0,498.25,{"$f":"(AG49-AC49)/AG49","v":0},null,5,{"$f":"SUM(AJ49:AL49)+AE49","v":498.25},null,null,{"$f":"ROUND(AC49/(1-VLOOKUP(AF49,Group,2,FALSE)),2)","v":498.25},{"$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,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Rough",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA50,AG50)","v":498.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA50*(1-W50)+0.004999,2)","v":498.25},null,"",498.25,0,498.25,{"$f":"(AG50-AC50)/AG50","v":0},null,5,{"$f":"SUM(AJ50:AL50)+AE50","v":498.25},null,null,{"$f":"ROUND(AC50/(1-VLOOKUP(AF50,Group,2,FALSE)),2)","v":498.25},{"$f":"IF(VLOOKUP(AF50,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ50,1)-AJ50,2),Round,2,FALSE)+VLOOKUP(AF50,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",0,ROUND(AJ50-0.04999,1)-AJ50+AM50)","v":0},{"$f":"IF(VLOOKUP(AF50,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF50,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"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\",AA52,AG52)","v":11.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA52*(1-W52)+0.004999,2)","v":11.6},null,"",11.6,{"$f":"+W52","v":0},11.6,{"$f":"(AG52-AC52)/AG52","v":0},null,4,{"$f":"SUM(AJ52:AL52)+AE52","v":11.6},null,null,{"$f":"ROUND(AC52/(1-VLOOKUP(AF52,Group,2,FALSE)),2)","v":11.6},{"$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 24\"",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.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA53*(1-W53)+0.004999,2)","v":11.6},null,"",11.6,0,11.6,{"$f":"(AG53-AC53)/AG53","v":0},null,4,{"$f":"SUM(AJ53:AL53)+AE53","v":11.6},null,null,{"$f":"ROUND(AC53/(1-VLOOKUP(AF53,Group,2,FALSE)),2)","v":11.6},{"$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 - 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\",AA54,AG54)","v":13.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":13.85},null,"",13.85,0,13.85,{"$f":"(AG54-AC54)/AG54","v":0},null,4,{"$f":"SUM(AJ54:AL54)+AE54","v":13.85},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":13.85},{"$f":"IF(VLOOKUP(AF54,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ54,1)-AJ54,2),Round,2,FALSE)+VLOOKUP(AF54,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",0,ROUND(AJ54-0.04999,1)-AJ54+AM54)","v":0},{"$f":"IF(VLOOKUP(AF54,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF54,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA56,AG56)","v":36.299999999999997},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA56*(1-W56)+0.004999,2)","v":36.299999999999997},null,"",36.299999999999997,{"$f":"+W56","v":0},{"$f":"+X56","v":36.299999999999997},{"$f":"(AG56-AC56)/AG56","v":0},null,6,{"$f":"SUM(AJ56:AL56)+AE56","v":36.299999999999997},null,null,{"$f":"ROUND(AC56/(1-VLOOKUP(AF56,Group,2,FALSE)),2)","v":36.299999999999997},{"$f":"IF(VLOOKUP(AF56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ56,1)-AJ56,2),Round,2,FALSE)+VLOOKUP(AF56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",0,ROUND(AJ56-0.04999,1)-AJ56+AM56)","v":0},{"$f":"IF(VLOOKUP(AF56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF56,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Worn",null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA58,AG58)","v":366.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA58*(1-W58)+0.004999,2)","v":366.7},null,"",366.7,{"$f":"+W58","v":0},366.7,{"$f":"(AG58-AC58)/AG58","v":0},null,5,{"$f":"SUM(AJ58:AL58)+AE58","v":366.7},null,null,{"$f":"ROUND(AC58/(1-VLOOKUP(AF58,Group,2,FALSE)),2)","v":366.7},{"$f":"IF(VLOOKUP(AF58,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ58,1)-AJ58,2),Round,2,FALSE)+VLOOKUP(AF58,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF58,Group,7,FALSE)=\"\",0,ROUND(AJ58-0.04999,1)-AJ58+AM58)","v":0},{"$f":"IF(VLOOKUP(AF58,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF58,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Worn",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":498.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":498.25},null,"",498.25,0,498.25,{"$f":"(AG59-AC59)/AG59","v":0},null,5,{"$f":"SUM(AJ59:AL59)+AE59","v":498.25},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":498.25},{"$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,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Worn",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA60,AG60)","v":498.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA60*(1-W60)+0.004999,2)","v":498.25},null,"",498.25,0,498.25,{"$f":"(AG60-AC60)/AG60","v":0},null,5,{"$f":"SUM(AJ60:AL60)+AE60","v":498.25},null,null,{"$f":"ROUND(AC60/(1-VLOOKUP(AF60,Group,2,FALSE)),2)","v":498.25},{"$f":"IF(VLOOKUP(AF60,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ60,1)-AJ60,2),Round,2,FALSE)+VLOOKUP(AF60,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",0,ROUND(AJ60-0.04999,1)-AJ60+AM60)","v":0},{"$f":"IF(VLOOKUP(AF60,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF60,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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          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,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"a",{"$f":"IF(Suggested=\"Yes\",AA66,AG66)","v":19.850000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA66*(1-W66)+0.004999,2)","v":19.850000000000001},null,"",19.850000000000001,{"$f":"+W66","v":0},{"$f":"+X66","v":19.850000000000001},{"$f":"(AG66-AC66)/AG66","v":0},null,4,{"$f":"SUM(AJ66:AL66)+AE66","v":19.850000000000001},null,null,{"$f":"ROUND(AC66/(1-VLOOKUP(AF66,Group,2,FALSE)),2)","v":19.850000000000001},{"$f":"IF(VLOOKUP(AF66,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ66,1)-AJ66,2),Round,2,FALSE)+VLOOKUP(AF66,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",0,ROUND(AJ66-0.04999,1)-AJ66+AM66)","v":0},{"$f":"IF(VLOOKUP(AF66,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF66,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,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 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,"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:","Alpi          Dark          Light          Moka          Siena",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"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\",AA77,AG77)","v":12.1},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA77*(1-W77)+0.004999,2)","v":12.1},null,"",12.1,{"$f":"+W77","v":0},12.1,{"$f":"(AG77-AC77)/AG77","v":0},null,4,{"$f":"SUM(AJ77:AL77)+AE77","v":12.1},null,null,{"$f":"ROUND(AC77/(1-VLOOKUP(AF77,Group,2,FALSE)),2)","v":12.1},{"$f":"IF(VLOOKUP(AF77,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ77,1)-AJ77,2),Round,2,FALSE)+VLOOKUP(AF77,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",0,ROUND(AJ77-0.04999,1)-AJ77+AM77)","v":0},{"$f":"IF(VLOOKUP(AF77,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF77,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA78,AG78)","v":12.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":12.2},null,"",12.2,0,12.2,{"$f":"(AG78-AC78)/AG78","v":0},null,4,{"$f":"SUM(AJ78:AL78)+AE78","v":12.2},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":12.2},{"$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,"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\",AA79,AG79)","v":13.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA79*(1-W79)+0.004999,2)","v":13.75},null,"",13.75,0,13.75,{"$f":"(AG79-AC79)/AG79","v":0},null,4,{"$f":"SUM(AJ79:AL79)+AE79","v":13.75},null,null,{"$f":"ROUND(AC79/(1-VLOOKUP(AF79,Group,2,FALSE)),2)","v":13.75},{"$f":"IF(VLOOKUP(AF79,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ79,1)-AJ79,2),Round,2,FALSE)+VLOOKUP(AF79,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",0,ROUND(AJ79-0.04999,1)-AJ79+AM79)","v":0},{"$f":"IF(VLOOKUP(AF79,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF79,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA80,AG80)","v":14.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA80*(1-W80)+0.004999,2)","v":14.25},null,"",14.25,0,14.25,{"$f":"(AG80-AC80)/AG80","v":0},null,4,{"$f":"SUM(AJ80:AL80)+AE80","v":14.25},null,null,{"$f":"ROUND(AC80/(1-VLOOKUP(AF80,Group,2,FALSE)),2)","v":14.25},{"$f":"IF(VLOOKUP(AF80,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ80,1)-AJ80,2),Round,2,FALSE)+VLOOKUP(AF80,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",0,ROUND(AJ80-0.04999,1)-AJ80+AM80)","v":0},{"$f":"IF(VLOOKUP(AF80,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF80,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA82,AG82)","v":43.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":43.6},null,"",43.6,{"$f":"+W82","v":0},{"$f":"+X82","v":43.6},{"$f":"(AG82-AC82)/AG82","v":0},null,6,{"$f":"SUM(AJ82:AL82)+AE82","v":43.6},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":43.6},{"$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 - 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\",AA84,AG84)","v":8.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA84*(1-W84)+0.004999,2)","v":8.4},null,"",8.4,{"$f":"+W84","v":0},{"$f":"+X84","v":8.4},{"$f":"(AG84-AC84)/AG84","v":0},null,5,{"$f":"SUM(AJ84:AL84)+AE84","v":8.4},null,null,{"$f":"ROUND(AC84/(1-VLOOKUP(AF84,Group,2,FALSE)),2)","v":8.4},{"$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 - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Natural",null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA86,AG86)","v":378.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA86*(1-W86)+0.004999,2)","v":378.85},null,"",378.85,{"$f":"+W86","v":0},378.85,{"$f":"(AG86-AC86)/AG86","v":0},null,5,{"$f":"SUM(AJ86:AL86)+AE86","v":378.85},null,null,{"$f":"ROUND(AC86/(1-VLOOKUP(AF86,Group,2,FALSE)),2)","v":378.85},{"$f":"IF(VLOOKUP(AF86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ86,1)-AJ86,2),Round,2,FALSE)+VLOOKUP(AF86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",0,ROUND(AJ86-0.04999,1)-AJ86+AM86)","v":0},{"$f":"IF(VLOOKUP(AF86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF86,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA87,AG87)","v":508.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA87*(1-W87)+0.004999,2)","v":508.9},null,"",508.9,0,508.9,{"$f":"(AG87-AC87)/AG87","v":0},null,5,{"$f":"SUM(AJ87:AL87)+AE87","v":508.9},null,null,{"$f":"ROUND(AC87/(1-VLOOKUP(AF87,Group,2,FALSE)),2)","v":508.9},{"$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,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA88,AG88)","v":508.9},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":508.9},null,"",508.9,0,508.9,{"$f":"(AG88-AC88)/AG88","v":0},null,5,{"$f":"SUM(AJ88:AL88)+AE88","v":508.9},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":508.9},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ88,1)-AJ88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AJ88-0.04999,1)-AJ88+AM88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA92,AG92)","v":10.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA92*(1-W92)+0.004999,2)","v":10.75},null,"",10.75,{"$f":"+W92","v":0},10.75,{"$f":"(AG92-AC92)/AG92","v":0},null,4,{"$f":"SUM(AJ92:AL92)+AE92","v":10.75},null,null,{"$f":"ROUND(AC92/(1-VLOOKUP(AF92,Group,2,FALSE)),2)","v":10.75},{"$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,"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\",AA93,AG93)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA93*(1-W93)+0.004999,2)","v":10.85},null,"",10.85,0,10.85,{"$f":"(AG93-AC93)/AG93","v":0},null,4,{"$f":"SUM(AJ93:AL93)+AE93","v":10.85},null,null,{"$f":"ROUND(AC93/(1-VLOOKUP(AF93,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF93,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ93,1)-AJ93,2),Round,2,FALSE)+VLOOKUP(AF93,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",0,ROUND(AJ93-0.04999,1)-AJ93+AM93)","v":0},{"$f":"IF(VLOOKUP(AF93,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF93,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA94,AG94)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA94*(1-W94)+0.004999,2)","v":12.95},null,"",12.95,0,12.95,{"$f":"(AG94-AC94)/AG94","v":0},null,4,{"$f":"SUM(AJ94:AL94)+AE94","v":12.95},null,null,{"$f":"ROUND(AC94/(1-VLOOKUP(AF94,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF94,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ94,1)-AJ94,2),Round,2,FALSE)+VLOOKUP(AF94,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",0,ROUND(AJ94-0.04999,1)-AJ94+AM94)","v":0},{"$f":"IF(VLOOKUP(AF94,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF94,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA95,AG95)","v":13.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA95*(1-W95)+0.004999,2)","v":13.4},null,"",13.4,0,13.4,{"$f":"(AG95-AC95)/AG95","v":0},null,4,{"$f":"SUM(AJ95:AL95)+AE95","v":13.4},null,null,{"$f":"ROUND(AC95/(1-VLOOKUP(AF95,Group,2,FALSE)),2)","v":13.4},{"$f":"IF(VLOOKUP(AF95,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ95,1)-AJ95,2),Round,2,FALSE)+VLOOKUP(AF95,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",0,ROUND(AJ95-0.04999,1)-AJ95+AM95)","v":0},{"$f":"IF(VLOOKUP(AF95,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF95,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"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\",AA97,AG97)","v":18.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA97*(1-W97)+0.004999,2)","v":18.25},null,"",18.25,{"$f":"+W97","v":0},{"$f":"+X97","v":18.25},{"$f":"(AG97-AC97)/AG97","v":0},null,6,{"$f":"SUM(AJ97:AL97)+AE97","v":18.25},null,null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":18.25},{"$f":"IF(VLOOKUP(AF97,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ97,1)-AJ97,2),Round,2,FALSE)+VLOOKUP(AF97,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",0,ROUND(AJ97-0.04999,1)-AJ97+AM97)","v":0},{"$f":"IF(VLOOKUP(AF97,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF97,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\",AA99,AG99)","v":7.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA99*(1-W99)+0.004999,2)","v":7.6},null,"",7.6,{"$f":"+W99","v":0},{"$f":"+X99","v":7.6},{"$f":"(AG99-AC99)/AG99","v":0},null,5,{"$f":"SUM(AJ99:AL99)+AE99","v":7.6},null,null,{"$f":"ROUND(AC99/(1-VLOOKUP(AF99,Group,2,FALSE)),2)","v":7.6},{"$f":"IF(VLOOKUP(AF99,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ99,1)-AJ99,2),Round,2,FALSE)+VLOOKUP(AF99,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",0,ROUND(AJ99-0.04999,1)-AJ99+AM99)","v":0},{"$f":"IF(VLOOKUP(AF99,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF99,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Natural",null,null,null,null,"2 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA101,AG101)","v":376.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA101*(1-W101)+0.004999,2)","v":376.8},null,"",376.8,{"$f":"+W101","v":0},376.8,{"$f":"(AG101-AC101)/AG101","v":0},null,5,{"$f":"SUM(AJ101:AL101)+AE101","v":376.8},null,null,{"$f":"ROUND(AC101/(1-VLOOKUP(AF101,Group,2,FALSE)),2)","v":376.8},{"$f":"IF(VLOOKUP(AF101,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ101,1)-AJ101,2),Round,2,FALSE)+VLOOKUP(AF101,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",0,ROUND(AJ101-0.04999,1)-AJ101+AM101)","v":0},{"$f":"IF(VLOOKUP(AF101,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF101,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA102,AG102)","v":507.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA102*(1-W102)+0.004999,2)","v":507.2},null,"",507.2,0,507.2,{"$f":"(AG102-AC102)/AG102","v":0},null,5,{"$f":"SUM(AJ102:AL102)+AE102","v":507.2},null,null,{"$f":"ROUND(AC102/(1-VLOOKUP(AF102,Group,2,FALSE)),2)","v":507.2},{"$f":"IF(VLOOKUP(AF102,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ102,1)-AJ102,2),Round,2,FALSE)+VLOOKUP(AF102,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",0,ROUND(AJ102-0.04999,1)-AJ102+AM102)","v":0},{"$f":"IF(VLOOKUP(AF102,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF102,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA103,AG103)","v":507.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA103*(1-W103)+0.004999,2)","v":507.2},null,"",507.2,0,507.2,{"$f":"(AG103-AC103)/AG103","v":0},null,5,{"$f":"SUM(AJ103:AL103)+AE103","v":507.2},null,null,{"$f":"ROUND(AC103/(1-VLOOKUP(AF103,Group,2,FALSE)),2)","v":507.2},{"$f":"IF(VLOOKUP(AF103,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ103,1)-AJ103,2),Round,2,FALSE)+VLOOKUP(AF103,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",0,ROUND(AJ103-0.04999,1)-AJ103+AM103)","v":0},{"$f":"IF(VLOOKUP(AF103,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF103,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA105,AG105)","v":10.85},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":10.85},null,"",10.85,{"$f":"+W105","v":0},{"$f":"+X105","v":10.85},{"$f":"(AG105-AC105)/AG105","v":0},null,4,{"$f":"SUM(AJ105:AL105)+AE105","v":10.85},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":10.85},{"$f":"IF(VLOOKUP(AF105,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ105,1)-AJ105,2),Round,2,FALSE)+VLOOKUP(AF105,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",0,ROUND(AJ105-0.04999,1)-AJ105+AM105)","v":0},{"$f":"IF(VLOOKUP(AF105,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF105,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA106,AG106)","v":12.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA106*(1-W106)+0.004999,2)","v":12.95},null,"",12.95,{"$f":"+W106","v":0},{"$f":"+X106","v":12.95},{"$f":"(AG106-AC106)/AG106","v":0},null,4,{"$f":"SUM(AJ106:AL106)+AE106","v":12.95},null,null,{"$f":"ROUND(AC106/(1-VLOOKUP(AF106,Group,2,FALSE)),2)","v":12.95},{"$f":"IF(VLOOKUP(AF106,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ106,1)-AJ106,2),Round,2,FALSE)+VLOOKUP(AF106,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",0,ROUND(AJ106-0.04999,1)-AJ106+AM106)","v":0},{"$f":"IF(VLOOKUP(AF106,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF106,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Natural",null,null,null,null,"2 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA108,AG108)","v":376.8},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA108*(1-W108)+0.004999,2)","v":376.8},null,"",376.8,{"$f":"+W108","v":0},376.8,{"$f":"(AG108-AC108)/AG108","v":0},null,5,{"$f":"SUM(AJ108:AL108)+AE108","v":376.8},null,null,{"$f":"ROUND(AC108/(1-VLOOKUP(AF108,Group,2,FALSE)),2)","v":376.8},{"$f":"IF(VLOOKUP(AF108,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ108,1)-AJ108,2),Round,2,FALSE)+VLOOKUP(AF108,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",0,ROUND(AJ108-0.04999,1)-AJ108+AM108)","v":0},{"$f":"IF(VLOOKUP(AF108,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF108,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA109,AG109)","v":507.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA109*(1-W109)+0.004999,2)","v":507.2},null,"",507.2,0,507.2,{"$f":"(AG109-AC109)/AG109","v":0},null,5,{"$f":"SUM(AJ109:AL109)+AE109","v":507.2},null,null,{"$f":"ROUND(AC109/(1-VLOOKUP(AF109,Group,2,FALSE)),2)","v":507.2},{"$f":"IF(VLOOKUP(AF109,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ109,1)-AJ109,2),Round,2,FALSE)+VLOOKUP(AF109,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",0,ROUND(AJ109-0.04999,1)-AJ109+AM109)","v":0},{"$f":"IF(VLOOKUP(AF109,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF109,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA110,AG110)","v":507.2},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA110*(1-W110)+0.004999,2)","v":507.2},null,"",507.2,0,507.2,{"$f":"(AG110-AC110)/AG110","v":0},null,5,{"$f":"SUM(AJ110:AL110)+AE110","v":507.2},null,null,{"$f":"ROUND(AC110/(1-VLOOKUP(AF110,Group,2,FALSE)),2)","v":507.2},{"$f":"IF(VLOOKUP(AF110,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ110,1)-AJ110,2),Round,2,FALSE)+VLOOKUP(AF110,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",0,ROUND(AJ110-0.04999,1)-AJ110+AM110)","v":0},{"$f":"IF(VLOOKUP(AF110,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF110,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,"MASTERPIECE - 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:","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,"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\",AA119,AG119)","v":19.850000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA119*(1-W119)+0.004999,2)","v":19.850000000000001},null,"",19.850000000000001,{"$f":"+W119","v":0},{"$f":"+X119","v":19.850000000000001},{"$f":"(AG119-AC119)/AG119","v":0},null,4,{"$f":"SUM(AJ119:AL119)+AE119","v":19.850000000000001},null,null,{"$f":"ROUND(AC119/(1-VLOOKUP(AF119,Group,2,FALSE)),2)","v":19.850000000000001},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,{"$f":"IF(Suggested=\"Yes\",AA128,AG128)","v":6.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA128*(1-W128)+0.004999,2)","v":6.2},null,"",6.2,{"$f":"+W128","v":0},{"$f":"+X128","v":6.2},{"$f":"(AG128-AC128)/AG128","v":0},null,1,{"$f":"SUM(AJ128:AL128)+AE128","v":6.2},null,null,{"$f":"ROUND(AC128/(1-VLOOKUP(AF128,Group,2,FALSE)),2)","v":6.2},{"$f":"IF(VLOOKUP(AF128,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ128,1)-AJ128,2),Round,2,FALSE)+VLOOKUP(AF128,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",0,ROUND(AJ128-0.04999,1)-AJ128+AM128)","v":0},{"$f":"IF(VLOOKUP(AF128,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF128,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Rectified",null,null,null,null,"15.61 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA129,AG129)","v":6.2},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA129*(1-W129)+0.004999,2)","v":6.2},null,"",6.2,{"$f":"+W129","v":0},{"$f":"+X129","v":6.2},{"$f":"(AG129-AC129)/AG129","v":0},null,1,{"$f":"SUM(AJ129:AL129)+AE129","v":6.2},null,null,{"$f":"ROUND(AC129/(1-VLOOKUP(AF129,Group,2,FALSE)),2)","v":6.2},{"$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,"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\",AA131,AG131)","v":20},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA131*(1-W131)+0.004999,2)","v":20},null,"",20,{"$f":"+W131","v":0},{"$f":"+X131","v":20},{"$f":"(AG131-AC131)/AG131","v":0},null,3,{"$f":"SUM(AJ131:AL131)+AE131","v":20},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":20},{"$f":"IF(VLOOKUP(AF131,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ131,1)-AJ131,2),Round,2,FALSE)+VLOOKUP(AF131,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",0,ROUND(AJ131-0.04999,1)-AJ131+AM131)","v":0},{"$f":"IF(VLOOKUP(AF131,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF131,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\",AA132,AG132)","v":20.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA132*(1-W132)+0.004999,2)","v":20.55},null,"",20.55,{"$f":"+W132","v":0},{"$f":"+X132","v":20.55},{"$f":"(AG132-AC132)/AG132","v":0},null,3,{"$f":"SUM(AJ132:AL132)+AE132","v":20.55},null,null,{"$f":"ROUND(AC132/(1-VLOOKUP(AF132,Group,2,FALSE)),2)","v":20.55},{"$f":"IF(VLOOKUP(AF132,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ132,1)-AJ132,2),Round,2,FALSE)+VLOOKUP(AF132,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",0,ROUND(AJ132-0.04999,1)-AJ132+AM132)","v":0},{"$f":"IF(VLOOKUP(AF132,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF132,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\",AA134,AG134)","v":10.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA134*(1-W134)+0.004999,2)","v":10.3},null,"",10.3,{"$f":"+W134","v":0},{"$f":"+X134","v":10.3},{"$f":"(AG134-AC134)/AG134","v":0},null,2,{"$f":"SUM(AJ134:AL134)+AE134","v":10.3},null,null,{"$f":"ROUND(AC134/(1-VLOOKUP(AF134,Group,2,FALSE)),2)","v":10.3},{"$f":"IF(VLOOKUP(AF134,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ134,1)-AJ134,2),Round,2,FALSE)+VLOOKUP(AF134,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",0,ROUND(AJ134-0.04999,1)-AJ134+AM134)","v":0},{"$f":"IF(VLOOKUP(AF134,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF134,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"TRAVEL - Full-Body Porcelain",null,null,null,null,null,"DISCONTINUED 8/22/22 by CCTD",null,null,null,null,null,null,null,null,"Item # Lookup:","LETR",null,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:","Amazonian Bark          Desert Rope          Indian Ash          Polar 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,"Field Tile"," ",null,"12\" x 24\"",null,"Field",null,null,null,null,null,null,null,null,"15.82 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA140,AG140)","v":5.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":5.25},null,"",5.25,{"$f":"+W140","v":0},{"$f":"+X140","v":5.25},{"$f":"(AG140-AC140)/AG140","v":0},null,1,{"$f":"SUM(AJ140:AL140)+AE140","v":5.25},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":5.25},{"$f":"IF(VLOOKUP(AF140,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ140,1)-AJ140,2),Round,2,FALSE)+VLOOKUP(AF140,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",0,ROUND(AJ140-0.04999,1)-AJ140+AM140)","v":0},{"$f":"IF(VLOOKUP(AF140,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF140,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA142,AG142)","v":20},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA142*(1-W142)+0.004999,2)","v":20},null,"",20,{"$f":"+W142","v":0},{"$f":"+X142","v":20},{"$f":"(AG142-AC142)/AG142","v":0},null,3,{"$f":"SUM(AJ142:AL142)+AE142","v":20},null,null,{"$f":"ROUND(AC142/(1-VLOOKUP(AF142,Group,2,FALSE)),2)","v":20},{"$f":"IF(VLOOKUP(AF142,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ142,1)-AJ142,2),Round,2,FALSE)+VLOOKUP(AF142,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",0,ROUND(AJ142-0.04999,1)-AJ142+AM142)","v":0},{"$f":"IF(VLOOKUP(AF142,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF142,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA143,AG143)","v":20.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA143*(1-W143)+0.004999,2)","v":20.55},null,"",20.55,{"$f":"+W143","v":0},{"$f":"+X143","v":20.55},{"$f":"(AG143-AC143)/AG143","v":0},null,3,{"$f":"SUM(AJ143:AL143)+AE143","v":20.55},null,null,{"$f":"ROUND(AC143/(1-VLOOKUP(AF143,Group,2,FALSE)),2)","v":20.55},{"$f":"IF(VLOOKUP(AF143,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ143,1)-AJ143,2),Round,2,FALSE)+VLOOKUP(AF143,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",0,ROUND(AJ143-0.04999,1)-AJ143+AM143)","v":0},{"$f":"IF(VLOOKUP(AF143,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF143,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"3\" x 12\"",null,"Bullnose",null,null,null,null,null,null,null,null," 20 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA145,AG145)","v":6.4},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA145*(1-W145)+0.004999,2)","v":6.4},null,"",6.4,{"$f":"+W145","v":0},{"$f":"+X145","v":6.4},{"$f":"(AG145-AC145)/AG145","v":0},null,2,{"$f":"SUM(AJ145:AL145)+AE145","v":6.4},null,null,{"$f":"ROUND(AC145/(1-VLOOKUP(AF145,Group,2,FALSE)),2)","v":6.4},{"$f":"IF(VLOOKUP(AF145,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ145,1)-AJ145,2),Round,2,FALSE)+VLOOKUP(AF145,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",0,ROUND(AJ145-0.04999,1)-AJ145+AM145)","v":0},{"$f":"IF(VLOOKUP(AF145,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF145,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA153,AG153)","v":15.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA153*(1-W153)+0.004999,2)","v":15.4},null,"",15.4,{"$f":"+W153","v":0},15.4,{"$f":"(AG153-AC153)/AG153","v":0},null,4,{"$f":"SUM(AJ153:AL153)+AE153","v":15.4},null,null,{"$f":"ROUND(AC153/(1-VLOOKUP(AF153,Group,2,FALSE)),2)","v":15.4},{"$f":"IF(VLOOKUP(AF153,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ153,1)-AJ153,2),Round,2,FALSE)+VLOOKUP(AF153,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",0,ROUND(AJ153-0.04999,1)-AJ153+AM153)","v":0},{"$f":"IF(VLOOKUP(AF153,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF153,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA154,AG154)","v":16.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA154*(1-W154)+0.004999,2)","v":16.350000000000001},null,"",16.350000000000001,0,16.350000000000001,{"$f":"(AG154-AC154)/AG154","v":0},null,4,{"$f":"SUM(AJ154:AL154)+AE154","v":16.350000000000001},null,null,{"$f":"ROUND(AC154/(1-VLOOKUP(AF154,Group,2,FALSE)),2)","v":16.350000000000001},{"$f":"IF(VLOOKUP(AF154,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ154,1)-AJ154,2),Round,2,FALSE)+VLOOKUP(AF154,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",0,ROUND(AJ154-0.04999,1)-AJ154+AM154)","v":0},{"$f":"IF(VLOOKUP(AF154,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF154,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"32.29 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA155,AG155)","v":20.45},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA155*(1-W155)+0.004999,2)","v":20.45},null,"",20.45,0,20.45,{"$f":"(AG155-AC155)/AG155","v":0},null,4,{"$f":"SUM(AJ155:AL155)+AE155","v":20.45},null,null,{"$f":"ROUND(AC155/(1-VLOOKUP(AF155,Group,2,FALSE)),2)","v":20.45},{"$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) There is an additional crate charge of $50 for each crate used for shipment.  There is 419.64 sf per crate.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA164,AG164)","v":10.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA164*(1-W164)+0.004999,2)","v":10.95},null,"",10.95,{"$f":"+W164","v":0},10.95,{"$f":"(AG164-AC164)/AG164","v":0},null,4,{"$f":"SUM(AJ164:AL164)+AE164","v":10.95},null,null,{"$f":"ROUND(AC164/(1-VLOOKUP(AF164,Group,2,FALSE)),2)","v":10.95},{"$f":"IF(VLOOKUP(AF164,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ164,1)-AJ164,2),Round,2,FALSE)+VLOOKUP(AF164,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",0,ROUND(AJ164-0.04999,1)-AJ164+AM164)","v":0},{"$f":"IF(VLOOKUP(AF164,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF164,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA165,AG165)","v":10.95},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":10.95},null,"",10.95,0,10.95,{"$f":"(AG165-AC165)/AG165","v":0},null,4,{"$f":"SUM(AJ165:AL165)+AE165","v":10.95},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":10.95},{"$f":"IF(VLOOKUP(AF165,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ165,1)-AJ165,2),Round,2,FALSE)+VLOOKUP(AF165,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",0,ROUND(AJ165-0.04999,1)-AJ165+AM165)","v":0},{"$f":"IF(VLOOKUP(AF165,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF165,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"18\" x 36\"",null,"Field",null,null,null,"Natural/Rectified",null,null,null,null,"13.08 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":11.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":11.7},null,"",11.7,0,11.7,{"$f":"(AG166-AC166)/AG166","v":0},null,4,{"$f":"SUM(AJ166:AL166)+AE166","v":11.7},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":11.7},{"$f":"IF(VLOOKUP(AF166,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ166,1)-AJ166,2),Round,2,FALSE)+VLOOKUP(AF166,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",0,ROUND(AJ166-0.04999,1)-AJ166+AM166)","v":0},{"$f":"IF(VLOOKUP(AF166,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF166,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA167,AG167)","v":13.6},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA167*(1-W167)+0.004999,2)","v":13.6},null,"",13.6,0,13.6,{"$f":"(AG167-AC167)/AG167","v":0},null,4,{"$f":"SUM(AJ167:AL167)+AE167","v":13.6},null,null,{"$f":"ROUND(AC167/(1-VLOOKUP(AF167,Group,2,FALSE)),2)","v":13.6},{"$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,"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\",AA168,AG168)","v":13.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA168*(1-W168)+0.004999,2)","v":13.25},null,"",13.25,0,13.25,{"$f":"(AG168-AC168)/AG168","v":0},null,4,{"$f":"SUM(AJ168:AL168)+AE168","v":13.25},null,null,{"$f":"ROUND(AC168/(1-VLOOKUP(AF168,Group,2,FALSE)),2)","v":13.25},{"$f":"IF(VLOOKUP(AF168,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ168,1)-AJ168,2),Round,2,FALSE)+VLOOKUP(AF168,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",0,ROUND(AJ168-0.04999,1)-AJ168+AM168)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF168,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - 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\",AA170,AG170)","v":15.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA170*(1-W170)+0.004999,2)","v":15.75},null,"",15.75,{"$f":"+W170","v":0},15.75,{"$f":"(AG170-AC170)/AG170","v":0},null,4,{"$f":"SUM(AJ170:AL170)+AE170","v":15.75},null,null,{"$f":"ROUND(AC170/(1-VLOOKUP(AF170,Group,2,FALSE)),2)","v":15.75},{"$f":"IF(VLOOKUP(AF170,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ170,1)-AJ170,2),Round,2,FALSE)+VLOOKUP(AF170,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",0,ROUND(AJ170-0.04999,1)-AJ170+AM170)","v":0},{"$f":"IF(VLOOKUP(AF170,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF170,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - 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\",AA171,AG171)","v":18.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA171*(1-W171)+0.004999,2)","v":18.75},null,"",18.75,0,18.75,{"$f":"(AG171-AC171)/AG171","v":0},null,4,{"$f":"SUM(AJ171:AL171)+AE171","v":18.75},null,null,{"$f":"ROUND(AC171/(1-VLOOKUP(AF171,Group,2,FALSE)),2)","v":18.75},{"$f":"IF(VLOOKUP(AF171,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ171,1)-AJ171,2),Round,2,FALSE)+VLOOKUP(AF171,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF171,Group,7,FALSE)=\"\",0,ROUND(AJ171-0.04999,1)-AJ171+AM171)","v":0},{"$f":"IF(VLOOKUP(AF171,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF171,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\",AA172,AG172)","v":18.75},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA172*(1-W172)+0.004999,2)","v":18.75},null,"",18.75,0,18.75,{"$f":"(AG172-AC172)/AG172","v":0},null,4,{"$f":"SUM(AJ172:AL172)+AE172","v":18.75},null,null,{"$f":"ROUND(AC172/(1-VLOOKUP(AF172,Group,2,FALSE)),2)","v":18.75},{"$f":"IF(VLOOKUP(AF172,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ172,1)-AJ172,2),Round,2,FALSE)+VLOOKUP(AF172,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",0,ROUND(AJ172-0.04999,1)-AJ172+AM172)","v":0},{"$f":"IF(VLOOKUP(AF172,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF172,Group,7,FALSE))","v":""},null,"X"]
[null,"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\",AA173,AG173)","v":23.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA173*(1-W173)+0.004999,2)","v":23.4},null,"",23.4,0,23.4,{"$f":"(AG173-AC173)/AG173","v":0},null,4,{"$f":"SUM(AJ173:AL173)+AE173","v":23.4},null,null,{"$f":"ROUND(AC173/(1-VLOOKUP(AF173,Group,2,FALSE)),2)","v":23.4},{"$f":"IF(VLOOKUP(AF173,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ173,1)-AJ173,2),Round,2,FALSE)+VLOOKUP(AF173,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF173,Group,7,FALSE)=\"\",0,ROUND(AJ173-0.04999,1)-AJ173+AM173)","v":0},{"$f":"IF(VLOOKUP(AF173,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF173,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\",AA174,AG174)","v":23.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA174*(1-W174)+0.004999,2)","v":23.4},null,"",23.4,0,23.4,{"$f":"(AG174-AC174)/AG174","v":0},null,4,{"$f":"SUM(AJ174:AL174)+AE174","v":23.4},null,null,{"$f":"ROUND(AC174/(1-VLOOKUP(AF174,Group,2,FALSE)),2)","v":23.4},{"$f":"IF(VLOOKUP(AF174,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ174,1)-AJ174,2),Round,2,FALSE)+VLOOKUP(AF174,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",0,ROUND(AJ174-0.04999,1)-AJ174+AM174)","v":0},{"$f":"IF(VLOOKUP(AF174,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF174,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\",AA176,AG176)","v":19.399999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA176*(1-W176)+0.004999,2)","v":19.399999999999999},null,"",19.399999999999999,{"$f":"+W176","v":0},19.399999999999999,{"$f":"(AG176-AC176)/AG176","v":0},null,6,{"$f":"SUM(AJ176:AL176)+AE176","v":19.399999999999999},null,null,{"$f":"ROUND(AC176/(1-VLOOKUP(AF176,Group,2,FALSE)),2)","v":19.399999999999999},{"$f":"IF(VLOOKUP(AF176,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ176,1)-AJ176,2),Round,2,FALSE)+VLOOKUP(AF176,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",0,ROUND(AJ176-0.04999,1)-AJ176+AM176)","v":0},{"$f":"IF(VLOOKUP(AF176,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF176,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - 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\",AA177,AG177)","v":18.5},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA177*(1-W177)+0.004999,2)","v":18.5},null,"",18.5,0,18.5,{"$f":"(AG177-AC177)/AG177","v":0},null,6,{"$f":"SUM(AJ177:AL177)+AE177","v":18.5},null,null,{"$f":"ROUND(AC177/(1-VLOOKUP(AF177,Group,2,FALSE)),2)","v":18.5},{"$f":"IF(VLOOKUP(AF177,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ177,1)-AJ177,2),Round,2,FALSE)+VLOOKUP(AF177,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",0,ROUND(AJ177-0.04999,1)-AJ177+AM177)","v":0},{"$f":"IF(VLOOKUP(AF177,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF177,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - 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\",AA178,AG178)","v":21.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA178*(1-W178)+0.004999,2)","v":21.4},null,"",21.4,0,21.4,{"$f":"(AG178-AC178)/AG178","v":0},null,6,{"$f":"SUM(AJ178:AL178)+AE178","v":21.4},null,null,{"$f":"ROUND(AC178/(1-VLOOKUP(AF178,Group,2,FALSE)),2)","v":21.4},{"$f":"IF(VLOOKUP(AF178,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ178,1)-AJ178,2),Round,2,FALSE)+VLOOKUP(AF178,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",0,ROUND(AJ178-0.04999,1)-AJ178+AM178)","v":0},{"$f":"IF(VLOOKUP(AF178,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF178,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Decos",null,null,"12\" x 24\"",null,"Muretto 3D Mosaic",null,null,null,"Natural",null,null,"(Mesh-Mounted)",null,"7.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA179,AG179)","v":40.200000000000003},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA179*(1-W179)+0.004999,2)","v":40.200000000000003},null,"",40.200000000000003,0,40.200000000000003,{"$f":"(AG179-AC179)/AG179","v":0},null,6,{"$f":"SUM(AJ179:AL179)+AE179","v":40.200000000000003},null,null,{"$f":"ROUND(AC179/(1-VLOOKUP(AF179,Group,2,FALSE)),2)","v":40.200000000000003},{"$f":"IF(VLOOKUP(AF179,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ179,1)-AJ179,2),Round,2,FALSE)+VLOOKUP(AF179,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",0,ROUND(AJ179-0.04999,1)-AJ179+AM179)","v":0},{"$f":"IF(VLOOKUP(AF179,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF179,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"4\" x 24\"",null,"Bullnose",null,null,null,"Natural",null,null,null,null," 12 PCS/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA181,AG181)","v":18.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA181*(1-W181)+0.004999,2)","v":18.75},null,"",18.75,{"$f":"+W181","v":0},{"$f":"+X181","v":18.75},{"$f":"(AG181-AC181)/AG181","v":0},null,5,{"$f":"SUM(AJ181:AL181)+AE181","v":18.75},null,null,{"$f":"ROUND(AC181/(1-VLOOKUP(AF181,Group,2,FALSE)),2)","v":18.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 - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Natural",null,null,null,null,"2 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA183,AG183)","v":366.7},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA183*(1-W183)+0.004999,2)","v":366.7},null,"",366.7,{"$f":"+W183","v":0},366.7,{"$f":"(AG183-AC183)/AG183","v":0},null,5,{"$f":"SUM(AJ183:AL183)+AE183","v":366.7},null,null,{"$f":"ROUND(AC183/(1-VLOOKUP(AF183,Group,2,FALSE)),2)","v":366.7},{"$f":"IF(VLOOKUP(AF183,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ183,1)-AJ183,2),Round,2,FALSE)+VLOOKUP(AF183,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",0,ROUND(AJ183-0.04999,1)-AJ183+AM183)","v":0},{"$f":"IF(VLOOKUP(AF183,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF183,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA184,AG184)","v":498.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA184*(1-W184)+0.004999,2)","v":498.6},null,"",498.6,0,498.6,{"$f":"(AG184-AC184)/AG184","v":0},null,5,{"$f":"SUM(AJ184:AL184)+AE184","v":498.6},null,null,{"$f":"ROUND(AC184/(1-VLOOKUP(AF184,Group,2,FALSE)),2)","v":498.6},{"$f":"IF(VLOOKUP(AF184,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ184,1)-AJ184,2),Round,2,FALSE)+VLOOKUP(AF184,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",0,ROUND(AJ184-0.04999,1)-AJ184+AM184)","v":0},{"$f":"IF(VLOOKUP(AF184,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF184,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Natural",null,null,null,null," 1 PC/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA185,AG185)","v":498.6},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA185*(1-W185)+0.004999,2)","v":498.6},null,"",498.6,0,498.6,{"$f":"(AG185-AC185)/AG185","v":0},null,5,{"$f":"SUM(AJ185:AL185)+AE185","v":498.6},null,null,{"$f":"ROUND(AC185/(1-VLOOKUP(AF185,Group,2,FALSE)),2)","v":498.6},{"$f":"IF(VLOOKUP(AF185,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ185,1)-AJ185,2),Round,2,FALSE)+VLOOKUP(AF185,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",0,ROUND(AJ185-0.04999,1)-AJ185+AM185)","v":0},{"$f":"IF(VLOOKUP(AF185,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF185,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"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\",AA187,AG187)","v":11.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA187*(1-W187)+0.004999,2)","v":11.7},null,"",11.7,{"$f":"+W187","v":0},11.7,{"$f":"(AG187-AC187)/AG187","v":0},null,4,{"$f":"SUM(AJ187:AL187)+AE187","v":11.7},null,null,{"$f":"ROUND(AC187/(1-VLOOKUP(AF187,Group,2,FALSE)),2)","v":11.7},{"$f":"IF(VLOOKUP(AF187,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ187,1)-AJ187,2),Round,2,FALSE)+VLOOKUP(AF187,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",0,ROUND(AJ187-0.04999,1)-AJ187+AM187)","v":0},{"$f":"IF(VLOOKUP(AF187,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF187,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - 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\",AA188,AG188)","v":11.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA188*(1-W188)+0.004999,2)","v":11.7},null,"",11.7,0,11.7,{"$f":"(AG188-AC188)/AG188","v":0},null,4,{"$f":"SUM(AJ188:AL188)+AE188","v":11.7},null,null,{"$f":"ROUND(AC188/(1-VLOOKUP(AF188,Group,2,FALSE)),2)","v":11.7},{"$f":"IF(VLOOKUP(AF188,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ188,1)-AJ188,2),Round,2,FALSE)+VLOOKUP(AF188,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",0,ROUND(AJ188-0.04999,1)-AJ188+AM188)","v":0},{"$f":"IF(VLOOKUP(AF188,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF188,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"18\" x 36\"",null,"Field",null,null,null,"Semi-Polished/Rectified",null,null,null,null,"13.08 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA189,AG189)","v":12.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA189*(1-W189)+0.004999,2)","v":12.7},null,"",12.7,{"$f":"+W189","v":0},{"$f":"+X189","v":12.7},{"$f":"(AG189-AC189)/AG189","v":0},null,4,{"$f":"SUM(AJ189:AL189)+AE189","v":12.7},null,null,{"$f":"ROUND(AC189/(1-VLOOKUP(AF189,Group,2,FALSE)),2)","v":12.7},{"$f":"IF(VLOOKUP(AF189,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ189,1)-AJ189,2),Round,2,FALSE)+VLOOKUP(AF189,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",0,ROUND(AJ189-0.04999,1)-AJ189+AM189)","v":0},{"$f":"IF(VLOOKUP(AF189,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF189,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - 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\",AA190,AG190)","v":14.7},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA190*(1-W190)+0.004999,2)","v":14.7},null,"",14.7,{"$f":"+W190","v":0},{"$f":"+X190","v":14.7},{"$f":"(AG190-AC190)/AG190","v":0},null,4,{"$f":"SUM(AJ190:AL190)+AE190","v":14.7},null,null,{"$f":"ROUND(AC190/(1-VLOOKUP(AF190,Group,2,FALSE)),2)","v":14.7},{"$f":"IF(VLOOKUP(AF190,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ190,1)-AJ190,2),Round,2,FALSE)+VLOOKUP(AF190,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",0,ROUND(AJ190-0.04999,1)-AJ190+AM190)","v":0},{"$f":"IF(VLOOKUP(AF190,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF190,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - 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\",AA191,AG191)","v":14.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA191*(1-W191)+0.004999,2)","v":14.3},null,"",14.3,0,14.3,{"$f":"(AG191-AC191)/AG191","v":0},null,4,{"$f":"SUM(AJ191:AL191)+AE191","v":14.3},null,null,{"$f":"ROUND(AC191/(1-VLOOKUP(AF191,Group,2,FALSE)),2)","v":14.3},{"$f":"IF(VLOOKUP(AF191,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ191,1)-AJ191,2),Round,2,FALSE)+VLOOKUP(AF191,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",0,ROUND(AJ191-0.04999,1)-AJ191+AM191)","v":0},{"$f":"IF(VLOOKUP(AF191,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF191,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\",AA193,AG193)","v":20.55},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA193*(1-W193)+0.004999,2)","v":20.55},null,"",20.55,{"$f":"+W193","v":0},20.55,{"$f":"(AG193-AC193)/AG193","v":0},null,6,{"$f":"SUM(AJ193:AL193)+AE193","v":20.55},null,null,{"$f":"ROUND(AC193/(1-VLOOKUP(AF193,Group,2,FALSE)),2)","v":20.55},{"$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 - 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\",AA194,AG194)","v":19.350000000000001},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA194*(1-W194)+0.004999,2)","v":19.350000000000001},null,"",19.350000000000001,0,19.350000000000001,{"$f":"(AG194-AC194)/AG194","v":0},null,6,{"$f":"SUM(AJ194:AL194)+AE194","v":19.350000000000001},null,null,{"$f":"ROUND(AC194/(1-VLOOKUP(AF194,Group,2,FALSE)),2)","v":19.350000000000001},{"$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 - 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\",AA195,AG195)","v":22.4},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA195*(1-W195)+0.004999,2)","v":22.4},null,"",22.4,0,22.4,{"$f":"(AG195-AC195)/AG195","v":0},null,6,{"$f":"SUM(AJ195:AL195)+AE195","v":22.4},null,null,{"$f":"ROUND(AC195/(1-VLOOKUP(AF195,Group,2,FALSE)),2)","v":22.4},{"$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 - Decos",null,null,"12\" x 24\"",null,"Muretto 3D Mosaic",null,null,null,"Semi-Polished",null,null,"(Mesh-Mounted)",null,"7.37 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA196,AG196)","v":41.3},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA196*(1-W196)+0.004999,2)","v":41.3},null,"",41.3,0,41.3,{"$f":"(AG196-AC196)/AG196","v":0},null,6,{"$f":"SUM(AJ196:AL196)+AE196","v":41.3},null,null,{"$f":"ROUND(AC196/(1-VLOOKUP(AF196,Group,2,FALSE)),2)","v":41.3},{"$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,"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\",AA198,AG198)","v":20.25},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA198*(1-W198)+0.004999,2)","v":20.25},null,"",20.25,{"$f":"+W198","v":0},{"$f":"+X198","v":20.25},{"$f":"(AG198-AC198)/AG198","v":0},null,5,{"$f":"SUM(AJ198:AL198)+AE198","v":20.25},null,null,{"$f":"ROUND(AC198/(1-VLOOKUP(AF198,Group,2,FALSE)),2)","v":20.25},{"$f":"IF(VLOOKUP(AF198,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ198,1)-AJ198,2),Round,2,FALSE)+VLOOKUP(AF198,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF198,Group,7,FALSE)=\"\",0,ROUND(AJ198-0.04999,1)-AJ198+AM198)","v":0},{"$f":"IF(VLOOKUP(AF198,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF198,Group,7,FALSE))","v":""},null,"X"]
[]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose",null,null,null,"Semi-Polished",null,null,null,null,"2 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA200,AG200)","v":368.75},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA200*(1-W200)+0.004999,2)","v":368.75},null,"",368.75,{"$f":"+W200","v":0},368.75,{"$f":"(AG200-AC200)/AG200","v":0},null,5,{"$f":"SUM(AJ200:AL200)+AE200","v":368.75},null,null,{"$f":"ROUND(AC200/(1-VLOOKUP(AF200,Group,2,FALSE)),2)","v":368.75},{"$f":"IF(VLOOKUP(AF200,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ200,1)-AJ200,2),Round,2,FALSE)+VLOOKUP(AF200,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",0,ROUND(AJ200-0.04999,1)-AJ200+AM200)","v":0},{"$f":"IF(VLOOKUP(AF200,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF200,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Left)",null,null,null,"Semi-Polished",null,null,null,null," 1 PC/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA201,AG201)","v":500.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA201*(1-W201)+0.004999,2)","v":500.3},null,"",500.3,0,500.3,{"$f":"(AG201-AC201)/AG201","v":0},null,5,{"$f":"SUM(AJ201:AL201)+AE201","v":500.3},null,null,{"$f":"ROUND(AC201/(1-VLOOKUP(AF201,Group,2,FALSE)),2)","v":500.3},{"$f":"IF(VLOOKUP(AF201,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ201,1)-AJ201,2),Round,2,FALSE)+VLOOKUP(AF201,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",0,ROUND(AJ201-0.04999,1)-AJ201+AM201)","v":0},{"$f":"IF(VLOOKUP(AF201,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF201,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"13-3/4\" x 48\"",null,"Stair Nose Corner (Right)",null,null,null,"Semi-Polished",null,null,null,null," 1 PC/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA202,AG202)","v":500.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA202*(1-W202)+0.004999,2)","v":500.3},null,"",500.3,0,500.3,{"$f":"(AG202-AC202)/AG202","v":0},null,5,{"$f":"SUM(AJ202:AL202)+AE202","v":500.3},null,null,{"$f":"ROUND(AC202/(1-VLOOKUP(AF202,Group,2,FALSE)),2)","v":500.3},{"$f":"IF(VLOOKUP(AF202,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ202,1)-AJ202,2),Round,2,FALSE)+VLOOKUP(AF202,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF202,Group,7,FALSE)=\"\",0,ROUND(AJ202-0.04999,1)-AJ202+AM202)","v":0},{"$f":"IF(VLOOKUP(AF202,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF202,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"continued on next page",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"WATERFALL - Full-Body Porcelain  (Minimum 6-8 Week Delivery) continued",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","LEWA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Colors:","Dark Flow          Gray Flow          Ivory Flow          Silver Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Import I - Field Tile",null,null,"24\" x 24\"",null,"Field",null,null,null,"Grip/Rectified",null,null,null,null,"15.50 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA209,AG209)","v":11},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA209*(1-W209)+0.004999,2)","v":11},null,"",11,{"$f":"+W209","v":0},{"$f":"+X209","v":11},{"$f":"(AG209-AC209)/AG209","v":0},null,4,{"$f":"SUM(AJ209:AL209)+AE209","v":11},null,null,{"$f":"ROUND(AC209/(1-VLOOKUP(AF209,Group,2,FALSE)),2)","v":11},{"$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 - Trim",null,null,"13-3/4\" x 24\"",null,"Stair Nose",null,null,null,"Grip",null,null,null,null,"4 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA211,AG211)","v":168.55},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA211*(1-W211)+0.004999,2)","v":168.55},null,"",168.55,{"$f":"+W211","v":0},{"$f":"+X211","v":168.55},{"$f":"(AG211-AC211)/AG211","v":0},null,5,{"$f":"SUM(AJ211:AL211)+AE211","v":168.55},null,null,{"$f":"ROUND(AC211/(1-VLOOKUP(AF211,Group,2,FALSE)),2)","v":168.55},{"$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 - Trim",null,null,"13-3/4\" x 13-3/4\"",null,"Stair Nose Corner",null,null,null,"Grip",null,null,null,null,"2 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA212,AG212)","v":231.85},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":231.85},null,"",231.85,{"$f":"+W212","v":0},{"$f":"+X212","v":231.85},{"$f":"(AG212-AC212)/AG212","v":0},null,5,{"$f":"SUM(AJ212:AL212)+AE212","v":231.85},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":231.85},{"$f":"IF(VLOOKUP(AF212,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ212,1)-AJ212,2),Round,2,FALSE)+VLOOKUP(AF212,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",0,ROUND(AJ212-0.04999,1)-AJ212+AM212)","v":0},{"$f":"IF(VLOOKUP(AF212,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF212,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"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) For information about minimum quantities and delivery times please contact Customer Service.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\",AA221,AG221)","v":18.25},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA221*(1-W221)+0.004999,2)","v":18.25},null,"",18.25,{"$f":"+W221","v":0},18.25,{"$f":"(AG221-AC221)/AG221","v":0},null,4,{"$f":"SUM(AJ221:AL221)+AE221","v":18.25},null,null,{"$f":"ROUND(AC221/(1-VLOOKUP(AF221,Group,2,FALSE)),2)","v":18.25},{"$f":"IF(VLOOKUP(AF221,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ221,1)-AJ221,2),Round,2,FALSE)+VLOOKUP(AF221,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",0,ROUND(AJ221-0.04999,1)-AJ221+AM221)","v":0},{"$f":"IF(VLOOKUP(AF221,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF221,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Field Tile",null,null,"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\",AA222,AG222)","v":18.149999999999999},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA222*(1-W222)+0.004999,2)","v":18.149999999999999},null,"",18.149999999999999,0,18.149999999999999,{"$f":"(AG222-AC222)/AG222","v":0},null,4,{"$f":"SUM(AJ222:AL222)+AE222","v":18.149999999999999},null,null,{"$f":"ROUND(AC222/(1-VLOOKUP(AF222,Group,2,FALSE)),2)","v":18.149999999999999},{"$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 - 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\",AA223,AG223)","v":21},"SF",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA223*(1-W223)+0.004999,2)","v":21},null,"",21,0,21,{"$f":"(AG223-AC223)/AG223","v":0},null,4,{"$f":"SUM(AJ223:AL223)+AE223","v":21},null,null,{"$f":"ROUND(AC223/(1-VLOOKUP(AF223,Group,2,FALSE)),2)","v":21},{"$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 - Trim",null,null,"12\" x 36\" x 20mm",null,"Step Tread w/Bullnose Edge",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA225,AG225)","v":204.3},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA225*(1-W225)+0.004999,2)","v":204.3},null,"",204.3,{"$f":"+W225","v":0},204.3,{"$f":"(AG225-AC225)/AG225","v":0},null,5,{"$f":"SUM(AJ225:AL225)+AE225","v":204.3},null,null,{"$f":"ROUND(AC225/(1-VLOOKUP(AF225,Group,2,FALSE)),2)","v":204.3},{"$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,"12\" x 36\" x 20mm",null,"Step Tread Corner w/Bullnose Edge (Left)",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",237.2,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},237.2,null,"",237.2,0,237.2,0,null,5,237.2,null,null,237.2,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"12\" x 36\" x 20mm",null,"Step Tread Corner w/Bullnose Edge (Right)",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",237.2,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},237.2,null,"",237.2,0,237.2,0,null,5,237.2,null,null,237.2,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"12\" x 36\" x 20mm",null,"Step Tread w/Square Edge",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",198.35,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},198.35,null,"",198.35,0,198.35,0,null,5,198.35,null,null,198.35,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"12\" x 36\" x 20mm",null,"Step Tread Corner w/Square Edge (Left)",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",216.75,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},216.75,null,"",216.75,0,216.75,0,null,5,216.75,null,null,216.75,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"12\" x 36\" x 20mm",null,"Step Tread Corner w/Square Edge (Right)",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",216.75,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},216.75,null,"",216.75,0,216.75,0,null,5,216.75,null,null,216.75,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"12\" x 36\" x 20mm",null,"Step Tread w/Bullnose Edge, Grooves",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",234.8,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},234.8,null,"",234.8,0,234.8,0,null,5,234.8,null,null,234.8,0,0,"",null,"X"]
[null,"Import I - Trim",null,null,"12\" x 36\" x 20mm",null,"Step Tread w/Straight Edge, Grooves",null,null,null,null,null,"Grip",null,null," 1 PC/CTN",null,"a",227.3,"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},227.3,null,"",227.3,0,227.3,0,null,5,227.3,null,null,227.3,0,0,"",null,"X"]
[]
[null,"Import I - Trim",null,null,"6\" x 18\" x 20mm",null,"Grill",null,null,null,null,null,"Grip",null,null,"4 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA234,AG234)","v":179.5},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA234*(1-W234)+0.004999,2)","v":179.5},null,"",179.5,{"$f":"+W234","v":0},179.5,{"$f":"(AG234-AC234)/AG234","v":0},null,5,{"$f":"SUM(AJ234:AL234)+AE234","v":179.5},null,null,{"$f":"ROUND(AC234/(1-VLOOKUP(AF234,Group,2,FALSE)),2)","v":179.5},{"$f":"IF(VLOOKUP(AF234,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ234,1)-AJ234,2),Round,2,FALSE)+VLOOKUP(AF234,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF234,Group,7,FALSE)=\"\",0,ROUND(AJ234-0.04999,1)-AJ234+AM234)","v":0},{"$f":"IF(VLOOKUP(AF234,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF234,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"6\" x 18\" x 20mm",null,"Grill Corner (Left)",null,null,null,null,null,"Grip",null,null,"4 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA235,AG235)","v":201.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA235*(1-W235)+0.004999,2)","v":201.65},null,"",201.65,0,201.65,{"$f":"(AG235-AC235)/AG235","v":0},null,5,{"$f":"SUM(AJ235:AL235)+AE235","v":201.65},null,null,{"$f":"ROUND(AC235/(1-VLOOKUP(AF235,Group,2,FALSE)),2)","v":201.65},{"$f":"IF(VLOOKUP(AF235,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ235,1)-AJ235,2),Round,2,FALSE)+VLOOKUP(AF235,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",0,ROUND(AJ235-0.04999,1)-AJ235+AM235)","v":0},{"$f":"IF(VLOOKUP(AF235,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF235,Group,7,FALSE))","v":""},null,"X"]
[null,"Import I - Trim",null,null,"6\" x 18\" x 20mm",null,"Grill Corner (Right)",null,null,null,null,null,"Grip",null,null,"4 PCS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA236,AG236)","v":201.65},"EA",{"$f":"+Instructions!$B$3","v":"B"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA236*(1-W236)+0.004999,2)","v":201.65},null,"",201.65,0,201.65,{"$f":"(AG236-AC236)/AG236","v":0},null,5,{"$f":"SUM(AJ236:AL236)+AE236","v":201.65},null,null,{"$f":"ROUND(AC236/(1-VLOOKUP(AF236,Group,2,FALSE)),2)","v":201.65},{"$f":"IF(VLOOKUP(AF236,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ236,1)-AJ236,2),Round,2,FALSE)+VLOOKUP(AF236,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",0,ROUND(AJ236-0.04999,1)-AJ236+AM236)","v":0},{"$f":"IF(VLOOKUP(AF236,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF236,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:","a) For information about minimum quantities and delivery times please contact Customer Service.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01,null,null,null,null,null," "]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":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"]
["The Rock","https://www.leausa.us/collection/the-rock"]
["Travel","https://www.leausa.us/collection/travel"]
["Waterfall","https://www.leausa.us/collection/waterfall"]

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