{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Index","Price List","Websites","Changes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,2,7,7],[36,3,36,4]]}
["Manufacturer","Cotto d'Este"]
["File as","C"]
["Product Code","D"]
["CCTD Effective Date","1/1/25 (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":"D"}]
[]
[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,null,"  "]
[null,4,null,"Italy",null,"No",0]
[null,5,null,0,null,"No",0]
[null,6,null,0,null,"No",0]
[null,7,null,0,null,"No",0]
[]
["If you want to manually adjust your price list, hit \"F5\" and go to \"Customer_Cost\" to manually adjust pricing."]
["You can enter a value in the column labeled \"Adj.\" to change your price manually."]
[]
[null,"Click on \"Your Price Calculation\" to set the print area for your personal cost calculation report."]
[null,"Then you can send it to print"]
[]
[]
[null,"Click on \"Your Price List\" to set the print area for your personal price list."]
[null,"Then you can send it to print"]
[null,null,null,null,null,null,null,"Yes"]
[]
["If you have any questions on how to best use this spreadsheet, please feel free to contact"]
["Jim Vogel at (800) 422-6860, ext. 4201 or via e-mail at jimvogel@cctd.com"]

{"sheet":"Index","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,5,10],[48,0,48,10],[50,0,50,10],[2,5,2,10],[3,4,3,7]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'C' - Cotto d'Este"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 1/1/25 (Updated)"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type"]
[1,null,"Black-White",null,"Laminated Porcelain Stoneware"]
[1,null,"Cement Project",null,"Laminated Porcelain Stoneware"]
[1,null,"Grunge",null,"Laminated Porcelain Stoneware"]
[1,null,"Kerlite Easy",null,"Dry Installation System"]
[1,null,"Limestone",null,"Laminated Porcelain Stoneware"]
[1,null,"Lithos",null,"Laminated Porcelain Stoneware",null,null,null,null,null," "]
[1,null,"Metal",null,"Laminated Porcelain Stoneware"]
[1,null,"Pietra D'Iseo",null,"Laminated Porcelain Stoneware"]
["1-2",null,"Vanity",null,"Laminated Porcelain Stoneware"]
[2,null,"Wonderwall",null,"Laminated Porcelain Stoneware"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
["The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference."]

{"sheet":"Price List","index":2,"n_rows":236,"n_cols":41,"rows_kept":236,"cut":false,"hidden":false,"merged":[[14,13,15,19],[13,30,13,32],[12,22,12,23],[12,14,12,19],[225,3,225,4],[18,2,18,19],[17,14,17,15],[221,2,221,19],[10,14,10,15],[9,14,9,19],[9,22,9,23],[9,25,9,32]]}
[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":"D"},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":"D"},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":"D"},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,"Italy",null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,0.05,"EA",{"$f":"+Instructions!$B$3","v":"D"},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,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$error":"#REF!"},null,"new",{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,5,{"$error":"#REF!"},null,null,{"$error":"#REF!"},0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$error":"#REF!"},null,"new",{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,6,{"$error":"#REF!"},null,null,{"$error":"#REF!"},0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,"Description",null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$error":"#REF!"},null,"new",{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},null,7,{"$error":"#REF!"},null,null,{"$error":"#REF!"},0,0,"",null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","a",1000,"ABC",null,null,0.1,1000,null,"ABC",1000,0.1,1000,0.1,10,null,1000,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price List",null,null,null,null,null,null,null,"Cust. Cost",null,null,"Customer Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AA11,AG11)","v":"List Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","List Price","Disc","Act. Cost","GP%","Adj.","Group","Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'C' - Cotto d'Este"},null,null,null,null,null,null,null,"Cost",null,null,null,null,null,null,null,null,null,"Retail Price Calculations",null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"1/1/25 (Updated)"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-01-14"},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 'D'"},null,null,null,null,null,null," ","  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$C$8=\"\",\"\",Instructions!$C$8)","v":""},null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+S$11","v":"List Price"},"U/M",{"$f":"+U$11","v":"Code"},null,"Disc.","Net",null,"Chg","List Price",{"$f":"+AB$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AF$11","v":"Group"},"Price",null,null,"Calc Price",".05 Round","Cents","Round to",null,"X"]
[null,null,"ALL ITEMS MARKED WITH PACKAGING QUANTITY ARE SOLD IN MULTIPLES OF THAT QUANTITY ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"BLACK-WHITE",null,null,null," ",null,null," ",null,null,null,null,null,null,null,"Item # Lookup:","CDBW",null,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,"Color:","Black",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Glossy / Rectified",null,null,null,null,"32.29 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA25,AG25)","v":28},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA25*(1-W25)+0.004999,2)","v":28},null,"",28,{"$f":"+W25","v":0},28,{"$f":"(AG25-AC25)/AG25","v":0},null,1,{"$f":"SUM(AJ25:AL25)+AE25","v":28},null,null,{"$f":"ROUND(AC25/(1-VLOOKUP(AF25,Group,2,FALSE)),2)","v":28},{"$f":"IF(VLOOKUP(AF25,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ25,1)-AJ25,2),Round,2,FALSE)+VLOOKUP(AF25,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",0,ROUND(AJ25-0.04999,1)-AJ25+AM25)","v":0},{"$f":"IF(VLOOKUP(AF25,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF25,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Silk / Rectified",null,null,null,null,"32.29 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA27,AG27)","v":22.1},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA27*(1-W27)+0.004999,2)","v":22.1},null,"",22.1,{"$f":"+W27","v":0},22.1,{"$f":"(AG27-AC27)/AG27","v":0},null,1,{"$f":"SUM(AJ27:AL27)+AE27","v":22.1},null,null,{"$f":"ROUND(AC27/(1-VLOOKUP(AF27,Group,2,FALSE)),2)","v":22.1},{"$f":"IF(VLOOKUP(AF27,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ27,1)-AJ27,2),Round,2,FALSE)+VLOOKUP(AF27,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF27,Group,7,FALSE)=\"\",0,ROUND(AJ27-0.04999,1)-AJ27+AM27)","v":0},{"$f":"IF(VLOOKUP(AF27,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF27,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Ultrawhite",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 39\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Glossy / Rectified",null,null,null,null,"21.53 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA31,AG31)","v":30.65},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA31*(1-W31)+0.004999,2)","v":30.65},null,"",30.65,{"$f":"+W31","v":0},30.65,{"$f":"(AG31-AC31)/AG31","v":0},null,1,{"$f":"SUM(AJ31:AL31)+AE31","v":30.65},null,null,{"$f":"ROUND(AC31/(1-VLOOKUP(AF31,Group,2,FALSE)),2)","v":30.65},{"$f":"IF(VLOOKUP(AF31,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ31,1)-AJ31,2),Round,2,FALSE)+VLOOKUP(AF31,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",0,ROUND(AJ31-0.04999,1)-AJ31+AM31)","v":0},{"$f":"IF(VLOOKUP(AF31,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF31,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Glossy / Rectified",null,null,null,null,"32.29 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA32,AG32)","v":32.15},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA32*(1-W32)+0.004999,2)","v":32.15},null,"",32.15,0,32.15,{"$f":"(AG32-AC32)/AG32","v":0},null,1,{"$f":"SUM(AJ32:AL32)+AE32","v":32.15},null,null,{"$f":"ROUND(AC32/(1-VLOOKUP(AF32,Group,2,FALSE)),2)","v":32.15},{"$f":"IF(VLOOKUP(AF32,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ32,1)-AJ32,2),Round,2,FALSE)+VLOOKUP(AF32,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",0,ROUND(AJ32-0.04999,1)-AJ32+AM32)","v":0},{"$f":"IF(VLOOKUP(AF32,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF32,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Silk / Rectified",null,null,null,null,"32.29 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA34,AG34)","v":26.25},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA34*(1-W34)+0.004999,2)","v":26.25},null,"",26.25,{"$f":"+W34","v":0},26.25,{"$f":"(AG34-AC34)/AG34","v":0},null,1,{"$f":"SUM(AJ34:AL34)+AE34","v":26.25},null,null,{"$f":"ROUND(AC34/(1-VLOOKUP(AF34,Group,2,FALSE)),2)","v":26.25},{"$f":"IF(VLOOKUP(AF34,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ34,1)-AJ34,2),Round,2,FALSE)+VLOOKUP(AF34,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",0,ROUND(AJ34-0.04999,1)-AJ34+AM34)","v":0},{"$f":"IF(VLOOKUP(AF34,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF34,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) There is an additional crate charge of $474.50 for each crate used for shipment.  There is 419.77 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,"CEMENT PROJECT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDCP",null,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:","Color-10 Cem          Color-20 Cem          Color-30 Cem",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 39\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"21.53 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA42,AG42)","v":20.55},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA42*(1-W42)+0.004999,2)","v":20.55},null,"",20.55,{"$f":"+W42","v":0},{"$f":"+X42","v":20.55},{"$f":"(AG42-AC42)/AG42","v":0},null,1,{"$f":"SUM(AJ42:AL42)+AE42","v":20.55},null,null,{"$f":"ROUND(AC42/(1-VLOOKUP(AF42,Group,2,FALSE)),2)","v":20.55},{"$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,null,null,"Colors:","Color-10 Work          Color-20 Work          Color-30 Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"32.29 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA46,AG46)","v":26.55},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA46*(1-W46)+0.004999,2)","v":26.55},null,"",26.55,{"$f":"+W46","v":0},{"$f":"+X46","v":26.55},{"$f":"(AG46-AC46)/AG46","v":0},null,1,{"$f":"SUM(AJ46:AL46)+AE46","v":26.55},null,null,{"$f":"ROUND(AC46/(1-VLOOKUP(AF46,Group,2,FALSE)),2)","v":26.55},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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) There is an additional crate charge of $474.50 for each crate used for shipment.  There is 419.77 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,"GRUNGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDGR",null,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:","Musk          Storm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA54,AG54)","v":27.95},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA54*(1-W54)+0.004999,2)","v":27.95},null,"",27.95,{"$f":"+W54","v":0},27.95,{"$f":"(AG54-AC54)/AG54","v":0},null,1,{"$f":"SUM(AJ54:AL54)+AE54","v":27.95},null,null,{"$f":"ROUND(AC54/(1-VLOOKUP(AF54,Group,2,FALSE)),2)","v":27.95},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"KERLITE EASY - Dry Installation System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDKE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"3.28' x 32.81'",null,"Roll",null,null,null,"Kerlite Easy Mat Roll",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA58,AG58)","v":327.45},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA58*(1-W58)+0.004999,2)","v":327.45},null,"new",327.45,{"$f":"+W58","v":0},{"$f":"+X58","v":327.45},{"$f":"(AG58-AC58)/AG58","v":0},null,1,{"$f":"SUM(AJ58:AL58)+AE58","v":327.45},null,null,{"$f":"ROUND(AC58/(1-VLOOKUP(AF58,Group,2,FALSE)),2)","v":327.45},{"$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,"Field Tile",null,null,"10.50 oz",null,"Tube",null,"Cement Grey",null,"Kerlite Easy Filler",null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA59,AG59)","v":37.65},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA59*(1-W59)+0.004999,2)","v":37.65},null,"new",37.65,{"$f":"+W59","v":0},{"$f":"+X59","v":37.65},{"$f":"(AG59-AC59)/AG59","v":0},null,1,{"$f":"SUM(AJ59:AL59)+AE59","v":37.65},null,null,{"$f":"ROUND(AC59/(1-VLOOKUP(AF59,Group,2,FALSE)),2)","v":37.65},{"$f":"IF(VLOOKUP(AF59,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ59,1)-AJ59,2),Round,2,FALSE)+VLOOKUP(AF59,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",0,ROUND(AJ59-0.04999,1)-AJ59+AM59)","v":0},{"$f":"IF(VLOOKUP(AF59,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF59,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","Kerlite Easy is a simple-to-use dry-installation system created by Cotto d'Este.  This system features a sound-absorbing mat on which Kerlite",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"5.5mm or 6.5mm tiles are installed and grouted with a special filler that makes the surfaces stable, immediately walkable, and water-resistant.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"LIMESTONE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDLS",null,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:","Amber          Clay          Oyster          Slate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 39\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"21.53 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA68,AG68)","v":21},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA68*(1-W68)+0.004999,2)","v":21},null,"",21,{"$f":"+W68","v":0},21,{"$f":"(AG68-AC68)/AG68","v":0},null,1,{"$f":"SUM(AJ68:AL68)+AE68","v":21},null,null,{"$f":"ROUND(AC68/(1-VLOOKUP(AF68,Group,2,FALSE)),2)","v":21},{"$f":"IF(VLOOKUP(AF68,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ68,1)-AJ68,2),Round,2,FALSE)+VLOOKUP(AF68,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",0,ROUND(AJ68-0.04999,1)-AJ68+AM68)","v":0},{"$f":"IF(VLOOKUP(AF68,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF68,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"LITHOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDLI",null,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,"Color:","Carbon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA74,AG74)","v":21.75},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA74*(1-W74)+0.004999,2)","v":21.75},null,"",21.75,{"$f":"+W74","v":0},21.75,{"$f":"(AG74-AC74)/AG74","v":0},null,1,{"$f":"SUM(AJ74:AL74)+AE74","v":21.75},null,null,{"$f":"ROUND(AC74/(1-VLOOKUP(AF74,Group,2,FALSE)),2)","v":21.75},{"$f":"IF(VLOOKUP(AF74,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ74,1)-AJ74,2),Round,2,FALSE)+VLOOKUP(AF74,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",0,ROUND(AJ74-0.04999,1)-AJ74+AM74)","v":0},{"$f":"IF(VLOOKUP(AF74,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF74,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Desert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA78,AG78)","v":22.6},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA78*(1-W78)+0.004999,2)","v":22.6},null,"",22.6,{"$f":"+W78","v":0},{"$f":"+X78","v":22.6},{"$f":"(AG78-AC78)/AG78","v":0},null,1,{"$f":"SUM(AJ78:AL78)+AE78","v":22.6},null,null,{"$f":"ROUND(AC78/(1-VLOOKUP(AF78,Group,2,FALSE)),2)","v":22.6},{"$f":"IF(VLOOKUP(AF78,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ78,1)-AJ78,2),Round,2,FALSE)+VLOOKUP(AF78,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",0,ROUND(AJ78-0.04999,1)-AJ78+AM78)","v":0},{"$f":"IF(VLOOKUP(AF78,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF78,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Moon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA82,AG82)","v":22.75},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA82*(1-W82)+0.004999,2)","v":22.75},null,"",22.75,{"$f":"+W82","v":0},{"$f":"+X82","v":22.75},{"$f":"(AG82-AC82)/AG82","v":0},null,1,{"$f":"SUM(AJ82:AL82)+AE82","v":22.75},null,null,{"$f":"ROUND(AC82/(1-VLOOKUP(AF82,Group,2,FALSE)),2)","v":22.75},{"$f":"IF(VLOOKUP(AF82,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ82,1)-AJ82,2),Round,2,FALSE)+VLOOKUP(AF82,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",0,ROUND(AJ82-0.04999,1)-AJ82+AM82)","v":0},{"$f":"IF(VLOOKUP(AF82,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF82,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"METAL",null," ",null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDME",null,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:","Corten          Iron",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"39\" x 39\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"21.53 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA88,AG88)","v":21.55},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA88*(1-W88)+0.004999,2)","v":21.55},null,"",21.55,{"$f":"+W88","v":0},{"$f":"+X88","v":21.55},{"$f":"(AG88-AC88)/AG88","v":0},null,1,{"$f":"SUM(AJ88:AL88)+AE88","v":21.55},null,null,{"$f":"ROUND(AC88/(1-VLOOKUP(AF88,Group,2,FALSE)),2)","v":21.55},{"$f":"IF(VLOOKUP(AF88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ88,1)-AJ88,2),Round,2,FALSE)+VLOOKUP(AF88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",0,ROUND(AJ88-0.04999,1)-AJ88+AM88)","v":0},{"$f":"IF(VLOOKUP(AF88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF88,Group,7,FALSE))","v":""},null,"X"]
[null,"Field Tile",null,null,"39\" x 118\" x 5.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"32.29 SF/SLAB",null,"a",{"$f":"IF(Suggested=\"Yes\",AA89,AG89)","v":27.3},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA89*(1-W89)+0.004999,2)","v":27.3},null,"",27.3,{"$f":"+W89","v":0},{"$f":"+X89","v":27.3},{"$f":"(AG89-AC89)/AG89","v":0},null,1,{"$f":"SUM(AJ89:AL89)+AE89","v":27.3},null,null,{"$f":"ROUND(AC89/(1-VLOOKUP(AF89,Group,2,FALSE)),2)","v":27.3},{"$f":"IF(VLOOKUP(AF89,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ89,1)-AJ89,2),Round,2,FALSE)+VLOOKUP(AF89,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",0,ROUND(AJ89-0.04999,1)-AJ89+AM89)","v":0},{"$f":"IF(VLOOKUP(AF89,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF89,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","a) There is an additional crate charge of $474.50 for each crate used for shipment.  There is 419.77 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,"PIETRA D'ISEO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDPD",null,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,"Color:","Ceppo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,"Naturale / Rectified",null,null,null,null,"31.00 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA97,AG97)","v":24.45},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA97*(1-W97)+0.004999,2)","v":24.45},null,"",24.45,{"$f":"+W97","v":0},24.45,{"$f":"(AG97-AC97)/AG97","v":0},null,1,{"$f":"SUM(AJ97:AL97)+AE97","v":24.45},null,null,{"$f":"ROUND(AC97/(1-VLOOKUP(AF97,Group,2,FALSE)),2)","v":24.45},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","a) Packaging is changing from 31.00 SF/CTN to 23.25 SF/CTN as inventory with old packaging is depleted.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"VANITY",null," ",null,null,null,null," ",null,null," ",null,null,null,null,"Item # Lookup:","CDVA",null,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:","Bianco Statuario          Onice Royal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,null,"Glossy / Rectified",null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA105,AG105)","v":28.35},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA105*(1-W105)+0.004999,2)","v":28.35},null,"",28.35,{"$f":"+W105","v":0},28.35,{"$f":"(AG105-AC105)/AG105","v":0},null,1,{"$f":"SUM(AJ105:AL105)+AE105","v":28.35},null,null,{"$f":"ROUND(AC105/(1-VLOOKUP(AF105,Group,2,FALSE)),2)","v":28.35},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Bianco Statuario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"48\" x 102\" x 6.5mm",null,"Field / Kerlite",null,null,null,null,"Glossy / Rectified",null,null,null,"33.58 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA109,AG109)","v":29.8},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA109*(1-W109)+0.004999,2)","v":29.8},null,"",29.8,0,29.8,{"$f":"(AG109-AC109)/AG109","v":0},null,1,{"$f":"SUM(AJ109:AL109)+AE109","v":29.8},null,null,{"$f":"ROUND(AC109/(1-VLOOKUP(AF109,Group,2,FALSE)),2)","v":29.8},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Dark Brown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"48\" x 102\" x 6.5mm",null,"Field / Kerlite",null,null,null,null,"Glossy / Rectified",null,null,null,"33.58 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA113,AG113)","v":30.15},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA113*(1-W113)+0.004999,2)","v":30.15},null,"",30.15,{"$f":"+W113","v":0},{"$f":"+X113","v":30.15},{"$f":"(AG113-AC113)/AG113","v":0},null,1,{"$f":"SUM(AJ113:AL113)+AE113","v":30.15},null,null,{"$f":"ROUND(AC113/(1-VLOOKUP(AF113,Group,2,FALSE)),2)","v":30.15},{"$f":"IF(VLOOKUP(AF113,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ113,1)-AJ113,2),Round,2,FALSE)+VLOOKUP(AF113,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",0,ROUND(AJ113-0.04999,1)-AJ113+AM113)","v":0},{"$f":"IF(VLOOKUP(AF113,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF113,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Bianco Luce",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,null,"Touch / Rectified",null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA117,AG117)","v":28.9},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA117*(1-W117)+0.004999,2)","v":28.9},null,"",28.9,{"$f":"+W117","v":0},28.9,{"$f":"(AG117-AC117)/AG117","v":0},null,1,{"$f":"SUM(AJ117:AL117)+AE117","v":28.9},null,null,{"$f":"ROUND(AC117/(1-VLOOKUP(AF117,Group,2,FALSE)),2)","v":28.9},{"$f":"IF(VLOOKUP(AF117,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ117,1)-AJ117,2),Round,2,FALSE)+VLOOKUP(AF117,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",0,ROUND(AJ117-0.04999,1)-AJ117+AM117)","v":0},{"$f":"IF(VLOOKUP(AF117,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF117,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Pietra Grey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"24\" x 48\" x 6.5mm",null,"Field / Kerlite",null,null,null,null,"Touch / Rectified",null,null,null,"23.25 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA121,AG121)","v":28.35},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA121*(1-W121)+0.004999,2)","v":28.35},null,"",28.35,{"$f":"+W121","v":0},{"$f":"+X121","v":28.35},{"$f":"(AG121-AC121)/AG121","v":0},null,1,{"$f":"SUM(AJ121:AL121)+AE121","v":28.35},null,null,{"$f":"ROUND(AC121/(1-VLOOKUP(AF121,Group,2,FALSE)),2)","v":28.35},{"$f":"IF(VLOOKUP(AF121,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ121,1)-AJ121,2),Round,2,FALSE)+VLOOKUP(AF121,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",0,ROUND(AJ121-0.04999,1)-AJ121+AM121)","v":0},{"$f":"IF(VLOOKUP(AF121,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF121,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Color:","Bianco Statuario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"48\" x 102\" x 6.5mm",null,"Field / Kerlite",null,null,null,null,"Touch / Rectified",null,null,null,"33.58 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA125,AG125)","v":29.8},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA125*(1-W125)+0.004999,2)","v":29.8},null,"",29.8,0,29.8,{"$f":"(AG125-AC125)/AG125","v":0},null,1,{"$f":"SUM(AJ125:AL125)+AE125","v":29.8},null,null,{"$f":"ROUND(AC125/(1-VLOOKUP(AF125,Group,2,FALSE)),2)","v":29.8},{"$f":"IF(VLOOKUP(AF125,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ125,1)-AJ125,2),Round,2,FALSE)+VLOOKUP(AF125,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",0,ROUND(AJ125-0.04999,1)-AJ125+AM125)","v":0},{"$f":"IF(VLOOKUP(AF125,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF125,Group,7,FALSE))","v":""},null,"X"]
[null,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,"VANITY - continued",null,null,null,null,null,null," ",null,null," ",null,null,null,null,"Item # Lookup:","CDVA",null,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,"Color:","Dark Brown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Field Tile",null,null,"48\" x 102\" x 6.5mm",null,"Field / Kerlite",null,null,null,null,"Touch / Rectified",null,null,null,"33.58 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA131,AG131)","v":30.15},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA131*(1-W131)+0.004999,2)","v":30.15},null,"",30.15,{"$f":"+W131","v":0},{"$f":"+X131","v":30.15},{"$f":"(AG131-AC131)/AG131","v":0},null,1,{"$f":"SUM(AJ131:AL131)+AE131","v":30.15},null,null,{"$f":"ROUND(AC131/(1-VLOOKUP(AF131,Group,2,FALSE)),2)","v":30.15},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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) There is an additional crate charge of $474.50 for each crate used for shipment for colors Bianco Statuario and Dark Brown.  There is 604.44 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,"WONDERWALL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item # Lookup:","CDWW",null,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,"Color:","Blanc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Field Motif / Kerlite",null,null,null,"Blanc / Rectified",null,null,null,null,"10.76 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA139,AG139)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA139*(1-W139)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W139","v":0},{"$f":"+X139","v":58.85},{"$f":"(AG139-AC139)/AG139","v":0},null,4,{"$f":"SUM(AJ139:AL139)+AE139","v":58.85},null,null,{"$f":"ROUND(AC139/(1-VLOOKUP(AF139,Group,2,FALSE)),2)","v":58.85},{"$f":"IF(VLOOKUP(AF139,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ139,1)-AJ139,2),Round,2,FALSE)+VLOOKUP(AF139,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",0,ROUND(AJ139-0.04999,1)-AJ139+AM139)","v":0},{"$f":"IF(VLOOKUP(AF139,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF139,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Field Motif / Kerlite",null,null,null,"Blanc / Rectified",null,null,null,null,null,null,"a",{"$f":"IF(Suggested=\"Yes\",AA140,AG140)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA140*(1-W140)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W140","v":0},{"$f":"+X140","v":1243.8},{"$f":"(AG140-AC140)/AG140","v":0},null,4,{"$f":"SUM(AJ140:AL140)+AE140","v":1243.8},null,null,{"$f":"ROUND(AC140/(1-VLOOKUP(AF140,Group,2,FALSE)),2)","v":1243.8},{"$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,null,null,"Color:","Freestyle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Field Motif / Kerlite",null,null,null,"Freestyle / Rectified",null,null,null,null,null,null,"b",{"$f":"IF(Suggested=\"Yes\",AA144,AG144)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA144*(1-W144)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W144","v":0},{"$f":"+X144","v":1243.8},{"$f":"(AG144-AC144)/AG144","v":0},null,4,{"$f":"SUM(AJ144:AL144)+AE144","v":1243.8},null,null,{"$f":"ROUND(AC144/(1-VLOOKUP(AF144,Group,2,FALSE)),2)","v":1243.8},{"$f":"IF(VLOOKUP(AF144,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ144,1)-AJ144,2),Round,2,FALSE)+VLOOKUP(AF144,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",0,ROUND(AJ144-0.04999,1)-AJ144+AM144)","v":0},{"$f":"IF(VLOOKUP(AF144,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF144,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," Decorative Motifs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Bamboo A",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA148,AG148)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA148*(1-W148)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W148","v":0},{"$f":"+X148","v":1243.8},{"$f":"(AG148-AC148)/AG148","v":0},null,4,{"$f":"SUM(AJ148:AL148)+AE148","v":1243.8},null,null,{"$f":"ROUND(AC148/(1-VLOOKUP(AF148,Group,2,FALSE)),2)","v":1243.8},{"$f":"IF(VLOOKUP(AF148,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ148,1)-AJ148,2),Round,2,FALSE)+VLOOKUP(AF148,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",0,ROUND(AJ148-0.04999,1)-AJ148+AM148)","v":0},{"$f":"IF(VLOOKUP(AF148,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF148,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Bamboo B",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Bamboo C",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Botany A & B",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA152,AG152)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA152*(1-W152)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W152","v":0},{"$f":"+X152","v":58.85},{"$f":"(AG152-AC152)/AG152","v":0},null,4,{"$f":"SUM(AJ152:AL152)+AE152","v":58.85},null,null,{"$f":"ROUND(AC152/(1-VLOOKUP(AF152,Group,2,FALSE)),2)","v":58.85},{"$f":"IF(VLOOKUP(AF152,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ152,1)-AJ152,2),Round,2,FALSE)+VLOOKUP(AF152,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",0,ROUND(AJ152-0.04999,1)-AJ152+AM152)","v":0},{"$f":"IF(VLOOKUP(AF152,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF152,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Botany A",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA153,AG153)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA153*(1-W153)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W153","v":0},{"$f":"+X153","v":1243.8},{"$f":"(AG153-AC153)/AG153","v":0},null,4,{"$f":"SUM(AJ153:AL153)+AE153","v":1243.8},null,null,{"$f":"ROUND(AC153/(1-VLOOKUP(AF153,Group,2,FALSE)),2)","v":1243.8},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Botany B",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Botany C",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Color Ballet A",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA157,AG157)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA157*(1-W157)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W157","v":0},1243.8,{"$f":"(AG157-AC157)/AG157","v":0},null,4,{"$f":"SUM(AJ157:AL157)+AE157","v":1243.8},null,null,{"$f":"ROUND(AC157/(1-VLOOKUP(AF157,Group,2,FALSE)),2)","v":1243.8},{"$f":"IF(VLOOKUP(AF157,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ157,1)-AJ157,2),Round,2,FALSE)+VLOOKUP(AF157,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",0,ROUND(AJ157-0.04999,1)-AJ157+AM157)","v":0},{"$f":"IF(VLOOKUP(AF157,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF157,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Color Ballet B",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA158,AG158)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA158*(1-W158)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W158","v":0},{"$f":"+X158","v":1243.8},{"$f":"(AG158-AC158)/AG158","v":0},null,4,{"$f":"SUM(AJ158:AL158)+AE158","v":1243.8},null,null,{"$f":"ROUND(AC158/(1-VLOOKUP(AF158,Group,2,FALSE)),2)","v":1243.8},{"$f":"IF(VLOOKUP(AF158,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ158,1)-AJ158,2),Round,2,FALSE)+VLOOKUP(AF158,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",0,ROUND(AJ158-0.04999,1)-AJ158+AM158)","v":0},{"$f":"IF(VLOOKUP(AF158,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF158,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Color Ballet C",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA159,AG159)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA159*(1-W159)+0.004999,2)","v":1243.8},null,"",1243.8,0,1243.8,{"$f":"(AG159-AC159)/AG159","v":0},null,4,{"$f":"SUM(AJ159:AL159)+AE159","v":1243.8},null,null,{"$f":"ROUND(AC159/(1-VLOOKUP(AF159,Group,2,FALSE)),2)","v":1243.8},{"$f":"IF(VLOOKUP(AF159,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ159,1)-AJ159,2),Round,2,FALSE)+VLOOKUP(AF159,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",0,ROUND(AJ159-0.04999,1)-AJ159+AM159)","v":0},{"$f":"IF(VLOOKUP(AF159,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF159,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Dream A",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA161,AG161)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA161*(1-W161)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W161","v":0},1243.8,{"$f":"(AG161-AC161)/AG161","v":0},null,4,{"$f":"SUM(AJ161:AL161)+AE161","v":1243.8},null,null,{"$f":"ROUND(AC161/(1-VLOOKUP(AF161,Group,2,FALSE)),2)","v":1243.8},{"$f":"IF(VLOOKUP(AF161,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ161,1)-AJ161,2),Round,2,FALSE)+VLOOKUP(AF161,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",0,ROUND(AJ161-0.04999,1)-AJ161+AM161)","v":0},{"$f":"IF(VLOOKUP(AF161,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF161,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Dream B",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Dream C",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Fleur A",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA165,AG165)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA165*(1-W165)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W165","v":0},{"$f":"+X165","v":58.85},{"$f":"(AG165-AC165)/AG165","v":0},null,4,{"$f":"SUM(AJ165:AL165)+AE165","v":58.85},null,null,{"$f":"ROUND(AC165/(1-VLOOKUP(AF165,Group,2,FALSE)),2)","v":58.85},{"$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,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Fleur B",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA166,AG166)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA166*(1-W166)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W166","v":0},58.85,{"$f":"(AG166-AC166)/AG166","v":0},null,4,{"$f":"SUM(AJ166:AL166)+AE166","v":58.85},null,null,{"$f":"ROUND(AC166/(1-VLOOKUP(AF166,Group,2,FALSE)),2)","v":58.85},{"$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,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Fleur C",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"a",58.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},58.85,null,"",58.85,{"$f":"+W167","v":0},{"$f":"+X167","v":58.85},0,null,4,58.85,null,null,58.85,0,0,"",null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Fleur D",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA168,AG168)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA168*(1-W168)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W168","v":0},{"$f":"+X168","v":58.85},{"$f":"(AG168-AC168)/AG168","v":0},null,4,{"$f":"SUM(AJ168:AL168)+AE168","v":58.85},null,null,{"$f":"ROUND(AC168/(1-VLOOKUP(AF168,Group,2,FALSE)),2)","v":58.85},{"$f":"IF(VLOOKUP(AF168,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ168,1)-AJ168,2),Round,2,FALSE)+VLOOKUP(AF168,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",0,ROUND(AJ168-0.04999,1)-AJ168+AM168)","v":0},{"$f":"IF(VLOOKUP(AF168,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF168,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Fleur E",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",AA169,AG169)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA169*(1-W169)+0.004999,2)","v":58.85},null,"",58.85,0,58.85,{"$f":"(AG169-AC169)/AG169","v":0},null,4,{"$f":"SUM(AJ169:AL169)+AE169","v":58.85},null,null,{"$f":"ROUND(AC169/(1-VLOOKUP(AF169,Group,2,FALSE)),2)","v":58.85},{"$f":"IF(VLOOKUP(AF169,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ169,1)-AJ169,2),Round,2,FALSE)+VLOOKUP(AF169,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",0,ROUND(AJ169-0.04999,1)-AJ169+AM169)","v":0},{"$f":"IF(VLOOKUP(AF169,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF169,Group,7,FALSE))","v":""},null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Foliage A & B",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA171,AG171)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA171*(1-W171)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W171","v":0},{"$f":"+X171","v":58.85},{"$f":"(AG171-AC171)/AG171","v":0},null,4,{"$f":"SUM(AJ171:AL171)+AE171","v":58.85},null,null,{"$f":"ROUND(AC171/(1-VLOOKUP(AF171,Group,2,FALSE)),2)","v":58.85},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Foliage A",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Jungle A",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA174,AG174)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA174*(1-W174)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W174","v":0},1243.8,{"$f":"(AG174-AC174)/AG174","v":0},null,4,{"$f":"SUM(AJ174:AL174)+AE174","v":1243.8},null,null,{"$f":"ROUND(AC174/(1-VLOOKUP(AF174,Group,2,FALSE)),2)","v":1243.8},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Jungle B",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Jungle C",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Lotus A",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA178,AG178)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA178*(1-W178)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W178","v":0},1243.8,{"$f":"(AG178-AC178)/AG178","v":0},null,4,{"$f":"SUM(AJ178:AL178)+AE178","v":1243.8},null,null,{"$f":"ROUND(AC178/(1-VLOOKUP(AF178,Group,2,FALSE)),2)","v":1243.8},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Lotus B",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Lotus C",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Plume A",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA182,AG182)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA182*(1-W182)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W182","v":0},58.85,{"$f":"(AG182-AC182)/AG182","v":0},null,4,{"$f":"SUM(AJ182:AL182)+AE182","v":58.85},null,null,{"$f":"ROUND(AC182/(1-VLOOKUP(AF182,Group,2,FALSE)),2)","v":58.85},{"$f":"IF(VLOOKUP(AF182,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ182,1)-AJ182,2),Round,2,FALSE)+VLOOKUP(AF182,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",0,ROUND(AJ182-0.04999,1)-AJ182+AM182)","v":0},{"$f":"IF(VLOOKUP(AF182,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF182,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Plume B",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,null,58.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},58.85,null,"",58.85,0,58.85,0,null,4,58.85,null,null,58.85,0,0,"",null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Plume C",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,null,58.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},58.85,null,"",58.85,0,58.85,0,null,4,58.85,null,null,58.85,0,0,"",null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Plume D",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,null,58.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},58.85,null,"",58.85,0,58.85,0,null,4,58.85,null,null,58.85,0,0,"",null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Plume E",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,null,58.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},58.85,null,"",58.85,0,58.85,0,null,4,58.85,null,null,58.85,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Printemps A & B",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA188,AG188)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA188*(1-W188)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W188","v":0},{"$f":"+X188","v":58.85},{"$f":"(AG188-AC188)/AG188","v":0},null,4,{"$f":"SUM(AJ188:AL188)+AE188","v":58.85},null,null,{"$f":"ROUND(AC188/(1-VLOOKUP(AF188,Group,2,FALSE)),2)","v":58.85},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Printemps A",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Ritmi 01",null,"    Naturale / Rectified",null,null,null,null,null,"a",{"$f":"IF(Suggested=\"Yes\",AA191,AG191)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA191*(1-W191)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W191","v":0},1243.8,{"$f":"(AG191-AC191)/AG191","v":0},null,4,{"$f":"SUM(AJ191:AL191)+AE191","v":1243.8},null,null,{"$f":"ROUND(AC191/(1-VLOOKUP(AF191,Group,2,FALSE)),2)","v":1243.8},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Ritmi 02",null,"    Naturale / Rectified",null,null,null,null,null,"a",1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Ritmi 03",null,"    Naturale / Rectified",null,null,null,null,null,"a",1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Sketch A",null,"    Naturale / Rectified",null,null,null,null,null,"b",{"$f":"IF(Suggested=\"Yes\",AA195,AG195)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA195*(1-W195)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W195","v":0},{"$f":"+X195","v":1243.8},{"$f":"(AG195-AC195)/AG195","v":0},null,4,{"$f":"SUM(AJ195:AL195)+AE195","v":1243.8},null,null,{"$f":"ROUND(AC195/(1-VLOOKUP(AF195,Group,2,FALSE)),2)","v":1243.8},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Sketch A-SX",null,"    Naturale / Rectified",null,null,null,null,null,"b",1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Sketch B",null,"    Naturale / Rectified",null,null,null,null,null,"b",{"$f":"IF(Suggested=\"Yes\",AA197,AG197)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA197*(1-W197)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W197","v":0},1243.8,{"$f":"(AG197-AC197)/AG197","v":0},null,4,{"$f":"SUM(AJ197:AL197)+AE197","v":1243.8},null,null,{"$f":"ROUND(AC197/(1-VLOOKUP(AF197,Group,2,FALSE)),2)","v":1243.8},{"$f":"IF(VLOOKUP(AF197,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ197,1)-AJ197,2),Round,2,FALSE)+VLOOKUP(AF197,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",0,ROUND(AJ197-0.04999,1)-AJ197+AM197)","v":0},{"$f":"IF(VLOOKUP(AF197,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF197,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Sketch B-DX",null,"    Naturale / Rectified",null,null,null,null,null,"b",1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Venice A",null,"    Naturale / Rectified",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",AA200,AG200)","v":1243.8},"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA200*(1-W200)+0.004999,2)","v":1243.8},null,"",1243.8,{"$f":"+W200","v":0},{"$f":"+X200","v":1243.8},{"$f":"(AG200-AC200)/AG200","v":0},null,4,{"$f":"SUM(AJ200:AL200)+AE200","v":1243.8},null,null,{"$f":"ROUND(AC200/(1-VLOOKUP(AF200,Group,2,FALSE)),2)","v":1243.8},{"$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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Venice B",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Venice C",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null," Precious Decorative Motifs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Golden Leaf A&B",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA206,AG206)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA206*(1-W206)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W206","v":0},{"$f":"+X206","v":58.85},{"$f":"(AG206-AC206)/AG206","v":0},null,4,{"$f":"SUM(AJ206:AL206)+AE206","v":58.85},null,null,{"$f":"ROUND(AC206/(1-VLOOKUP(AF206,Group,2,FALSE)),2)","v":58.85},{"$f":"IF(VLOOKUP(AF206,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ206,1)-AJ206,2),Round,2,FALSE)+VLOOKUP(AF206,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",0,ROUND(AJ206-0.04999,1)-AJ206+AM206)","v":0},{"$f":"IF(VLOOKUP(AF206,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF206,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Golden Leaf A",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Golden Slab",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",AA209,AG209)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA209*(1-W209)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W209","v":0},{"$f":"+X209","v":58.85},{"$f":"(AG209-AC209)/AG209","v":0},null,4,{"$f":"SUM(AJ209:AL209)+AE209","v":58.85},null,null,{"$f":"ROUND(AC209/(1-VLOOKUP(AF209,Group,2,FALSE)),2)","v":58.85},{"$f":"IF(VLOOKUP(AF209,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AJ209,1)-AJ209,2),Round,2,FALSE)+VLOOKUP(AF209,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",0,ROUND(AJ209-0.04999,1)-AJ209+AM209)","v":0},{"$f":"IF(VLOOKUP(AF209,Group,7,FALSE)=\"\",\"\",VLOOKUP(AF209,Group,7,FALSE))","v":""},null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Golden Slab",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA210*(1-W210)+0.004999,2)","v":1243.8},null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Silver Leaf A&B",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,"c",{"$f":"IF(Suggested=\"Yes\",AA212,AG212)","v":58.85},"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA212*(1-W212)+0.004999,2)","v":58.85},null,"",58.85,{"$f":"+W212","v":0},{"$f":"+X212","v":58.85},{"$f":"(AG212-AC212)/AG212","v":0},null,4,{"$f":"SUM(AJ212:AL212)+AE212","v":58.85},null,null,{"$f":"ROUND(AC212/(1-VLOOKUP(AF212,Group,2,FALSE)),2)","v":58.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,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Silver Leaf A",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},1243.8,null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"Italy",null,null,"19-1/2\" x 39\" x 3.5mm",null,"Motif / Kerlite",null,null,"Silver Slab",null,"    Naturale / Rectified",null,null,null,"10.76 SF/CTN",null,null,58.85,"SF",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},58.85,null,"",58.85,0,58.85,0,null,4,58.85,null,null,58.85,0,0,"",null,"X"]
[null,"Italy",null,null,"39\" x 118\" x 3.5mm",null,"Motif / Kerlite",null,null,"Silver Slab",null,"    Naturale / Rectified",null,null,null,null,null,null,1243.8,"EA",{"$f":"+Instructions!$B$3","v":"D"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AA216*(1-W216)+0.004999,2)","v":1243.8},null,"",1243.8,0,1243.8,0,null,4,1243.8,null,null,1243.8,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Note:","Extended Lead Time - approximately 8-10 weeks.",null,null,null,null,null,null,"a) Blanc color/surface is the base for the decorative motifs \"Fleur\" and \"Ritmi.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null," ",null,"b) Freestyle color/surface is the base for the decorative motif \"Sketch\".    ",null,null,null,null,null,null,null,"c) Each carton contains 1 piece of Motif \"A\" and 1 piece of Motif \"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,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null," "]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","http://www.conestogatile.com/"]
[]
["Manufacturer's Home Page","https://www.cottodeste.us/"]
[]
[]
["Product","Direct Website Link"]
["BLACK-WHITE","https://www.cottodeste.us/collection/black-white"]
["CEMENT PROJECT","https://www.cottodeste.us/collection/cement-project"]
["GRUNGE","https://www.cottodeste.us/collection/grunge"]
["KERLITE EASY","https://www.cottodeste.us/solutions/kerlite-easy"]
["LIMESTONE","https://www.cottodeste.us/collection/limestone"]
["LITHOS","https://www.cottodeste.us/collection/lithos"]
["METAL","https://www.cottodeste.us/collection/metal"]
["PIETRA D'ISEO","https://www.cottodeste.us/collection/pietra-d-iseo"]
["VANITY","https://www.cottodeste.us/collection/vanity"]
["WONDERWALL","https://www.cottodeste.us/collection/wonderwall"]

{"sheet":"Changes","index":4,"n_rows":122,"n_cols":11,"rows_kept":122,"cut":false,"hidden":false,"merged":[[5,0,17,0],[5,1,17,1]]}
["Date"]
["Announced","Series","Description"]
[]
["New Products"]
[]
["2024-12-01","Wonderwall","The following formats have been added: "]
[null,null,"39\" x 118\" x 3.5mm Blanc / Rectified Field Motif."]
[null,null,"19-1/2\" x 39\" x 3.5mm Botany A & B Motif."]
[null,null,"39\" x 118\" x 3.5mm Foliage A Motif."]
[null,null,"39\" x 118\" x 3.5mm Printemps A Motif."]
[null,null,"19-1/2\" x 39\" x 3.5mm Golden Leaf A&B Motif."]
[null,null,"39\" x 118\" x 3.5mm Golden Leaf A Motif."]
[null,null,"19-1/2\" x 39\" x 3.5mm Golden Slab Motif.",null,null,null,null,null,null,null,{"$f":"D13&\" \"&I13","v":" "}]
[null,null,"39\" x 118\" x 3.5mm Golden Slab Motif."]
[null,null,"19-1/2\" x 39\" x 3.5mm Silver Leaf A&B Motif."]
[null,null,"39\" x 118\" x 3.5mm Silver Leaf A Motif.",null,null,null,null,null,null,null," "]
[null,null,"19-1/2\" x 39\" x 3.5mm Silver Slab Motif."]
[null,null,"39\" x 118\" x 3.5mm Silver Slab Motif."]
["2025-01-14","Kerlite Easy","Kerlite Easy Mat Roll and Kerlite Easy Filler.",null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Discontinued Products"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Changes"]