{"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","Laticrete Strata Heat"]
["File as","L"]
["Product Code","N"]
["CCTD Effective Date","6/1/25"]
[]
[]
[]
["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":"N"},0,"  This is a \"NET\" price list.  0% is the discount for this spreadsheet"]
[]
[null,"Click on \"Your Cost\" to set the print area for your personal cost report."]
[null,"Then you can send it to print"]
[]
[]
["Discount: ","To help establish your price list, enter the gross profit percent for each type of product."]
[null,"If you want to use Conestoga Tile's list price, leave them blank."]
[]
["Round Nickel: ","If you always want your price to round to the nearest nickel, enter \"YES\"."]
[null,"If you enter \"NO\", it will NOT round to the nearest nickel."]
[]
["Ending Cents: ","If you always want your price to end with a certain cents, enter that cent value."]
[null,"If you leave it \"blank\" will NOT round to this cent value."]
[]
[null,"Group","GP Margin","GP Margin % for",null,"Round Nickel","add/subtract","Ending Cents"]
[null,1,null,"Field Tile",null,"No",0]
[null,2,null,"Trim",null,"No",0]
[null,3,null,"Decos",null,"No",0]
[null,4,null,0,null,"No",0,null,null,"  "]
[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]]}
[]
[]
[null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'L' - Laticrete Strata Heat"}]
[]
[]
[{"$f":"\"Price List Index - \"&Instructions!B4","v":"Price List Index - 6/1/25"}]
[]
[]
[]
[]
["Page",null,"Series",null,"Product Type",null,"Page",null,"Series",null,"Product Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":114,"n_cols":47,"rows_kept":114,"cut":false,"hidden":false,"merged":[[99,2,99,25],[20,2,20,25],[36,2,36,4],[52,2,52,4],[35,2,35,4],[52,9,52,14],[35,9,35,11],[58,9,58,11],[59,9,59,11],[42,15,42,17],[43,15,43,17],[39,18,39,20],[40,18,40,20],[41,18,41,20],[42,18,42,20],[43,18,43,20],[46,18,46,20],[47,18,47,20],[48,18,48,20],[49,18,49,20],[50,18,50,20],[46,9,46,11],[41,12,41,14],[103,3,103,4],[18,2,18,25],[9,20,9,25],[97,2,97,25],[14,19,15,25],[10,20,10,21],[49,12,49,14],[48,9,48,11],[49,9,49,11],[44,15,44,17],[45,15,45,17],[46,15,46,17],[44,12,44,14],[45,12,45,14],[46,12,46,14],[48,15,48,17],[44,18,44,20],[45,18,45,20],[39,15,39,17],[40,15,40,17],[41,15,41,17],[42,12,42,14],[43,12,43,14],[47,12,47,14],[48,12,48,14],[67,9,67,11],[68,9,68,11],[54,9,54,11],[39,9,39,11],[40,9,40,11],[39,12,39,14],[40,12,40,14],[41,9,41,11],[42,9,42,11],[43,9,43,11],[44,9,44,11],[45,9,45,11],[65,12,65,14],[66,12,66,14],[60,9,60,11],[61,9,61,11],[62,9,62,11],[63,9,63,11],[64,9,64,11],[65,9,65,11],[9,31,9,38],[12,28,12,29],[9,28,9,29],[13,36,13,38],[35,15,35,17],[35,18,35,20],[38,9,38,11],[35,12,35,14],[38,12,38,14],[38,15,38,17],[38,18,38,20],[12,18,12,25],[17,20,17,21],[36,15,36,20],[36,9,36,14],[50,15,50,17],[47,15,47,17],[47,9,47,11],[55,9,55,11],[56,9,56,11],[57,9,57,11],[52,15,52,20],[50,12,50,14],[50,9,50,11],[54,12,54,14],[55,12,55,14],[56,12,56,14],[57,12,57,14],[54,18,54,20],[55,18,55,20],[56,18,56,20],[57,18,57,20],[53,13,53,15],[49,15,49,17],[66,9,66,11],[67,12,67,14],[68,12,68,14],[54,15,54,17],[55,15,55,17],[56,15,56,17],[57,15,57,17],[58,15,58,17],[59,15,59,17],[60,15,60,17],[61,15,61,17],[62,15,62,17],[63,15,63,17],[64,15,64,17],[65,15,65,17],[66,15,66,17],[67,15,67,17],[68,15,68,17],[58,12,58,14],[59,12,59,14],[60,12,60,14],[61,12,61,14],[62,12,62,14],[63,12,63,14],[64,12,64,14],[67,18,67,20],[68,18,68,20],[58,18,58,20],[59,18,59,20],[60,18,60,20],[61,18,61,20],[62,18,62,20],[63,18,63,20],[64,18,64,20],[65,18,65,20],[66,18,66,20]]}
[null,"Field Tile",null,null,"Size",null,"Field",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG1,'Price List'!AM1)","v":0},"SF",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG1*(1-AC1)+0.004999,2)","v":0},null,"new",0,{"$f":"+AC1","v":0},0,{"$f":"(AM1-AI1)/AM1","v":{"$error":"#DIV/0!"}},null,1,{"$f":"SUM(AP1:AR1)+AK1","v":0},null,null,{"$f":"ROUND(AI1/(1-VLOOKUP(AL1,Group,2,FALSE)),2)","v":0},{"$f":"IF(VLOOKUP(AL1,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP1,1)-AP1,2),Round,2,FALSE)+VLOOKUP(AL1,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL1,Group,7,FALSE)=\"\",0,ROUND(AP1-0.04999,1)-AP1+AS1)","v":0},{"$f":"IF(VLOOKUP(AL1,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL1,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"Size",null,"Shape",null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG2,'Price List'!AM2)","v":0.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},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,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG3,'Price List'!AM3)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,3,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG4,'Price List'!AM4)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,4,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG5,'Price List'!AM5)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,5,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG6,'Price List'!AM6)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,6,0,null,null,0,0,0,"",null,"X"]
[null,0,null,null,"Size",null,"Shape",null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG7,'Price List'!AM7)","v":0},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},0,null,"new",0,0,0,{"$error":"#DIV/0!"},null,7,0,null,null,0,0,0,"",null,"X"]
[null,"Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,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,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"IF(Suggested=\"Yes\",AG11,AM11)","v":"Net Price"},"U/M","Code",null,"Disc.","Net",null,"Chg","Net 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,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"File '\"&Instructions!B2&\"' - \"&Instructions!B1","v":"File 'L' - Laticrete Strata Heat"},null,null,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,null,null,null,null,null,null,{"$f":"+Instructions!B4","v":"6/1/25"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-05-16"},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,{"$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," ",{"$f":"\"Product Code '\"&Instructions!B3&\"'\"","v":"Product Code 'N'"},null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,null,"Sizes & Shapes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Carton",null,"Stock","Note",{"$f":"+Y$11","v":"Net Price"},"U/M",{"$f":"+AA$11","v":"Code"},null,"Disc.","Net",null,"Chg","Net Price",{"$f":"+AH$11","v":"Disc"},"Act. Cost","GP%","Adj.",{"$f":"+AL$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,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"PRICING LISTED IS NET PRICING. TRADE DISCOUNTS DO NOT APPLY."]
[]
[null,null,"STRATA HEAT MAT",null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,"Item # Lookup:","LTSH0M",null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"3' 3\" x 49' 6\" x 1/4\"",null,"0179-0161-H",null,null,null,null,null,null,"161 SF/Roll",null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG25,'Price List'!AM25)","v":439.4},"Roll",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG25*(1-AC25)+0.004999,2)","v":439.4},null,"YES",439.4,{"$f":"+AC25","v":0},{"$f":"+AD25","v":439.4},{"$f":"(AM25-AI25)/AM25","v":0},null,2,{"$f":"SUM(AP25:AR25)+AK25","v":439.4},null,null,{"$f":"ROUND(AI25/(1-VLOOKUP(AL25,Group,2,FALSE)),2)","v":439.4},{"$f":"IF(VLOOKUP(AL25,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP25,1)-AP25,2),Round,2,FALSE)+VLOOKUP(AL25,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL25,Group,7,FALSE)=\"\",0,ROUND(AP25-0.04999,1)-AP25+AS25)","v":0},{"$f":"IF(VLOOKUP(AL25,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL25,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"3' 3\" x 2' 6.3\" x 1/4\"",null,"0179-1082-H",null,null,null,null,null,null,"8.60 SF/Sheet",null,null,null,null,null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG26,'Price List'!AM26)","v":28.25},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG26*(1-AC26)+0.004999,2)","v":28.25},null,"YES",28.25,{"$f":"+AC26","v":0},{"$f":"+AD26","v":28.25},{"$f":"(AM26-AI26)/AM26","v":0},null,2,{"$f":"SUM(AP26:AR26)+AK26","v":28.25},null,null,{"$f":"ROUND(AI26/(1-VLOOKUP(AL26,Group,2,FALSE)),2)","v":28.25},{"$f":"IF(VLOOKUP(AL26,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP26,1)-AP26,2),Round,2,FALSE)+VLOOKUP(AL26,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL26,Group,7,FALSE)=\"\",0,ROUND(AP26-0.04999,1)-AP26+AS26)","v":0},{"$f":"IF(VLOOKUP(AL26,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL26,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"3' 3\" x 2' 6.3\" x 1/4\"",null,"0179-5082-H",null,null,null,null,null,null,"8.60 SF/Sheet",null,null,null,null,null,null,null,"50 Sheets/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG27,'Price List'!AM27)","v":26.65},"Sheet",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG27*(1-AC27)+0.004999,2)","v":26.65},null,"YES",26.65,{"$f":"+AC27","v":0},{"$f":"+AD27","v":26.65},{"$f":"(AM27-AI27)/AM27","v":0},null,2,{"$f":"SUM(AP27:AR27)+AK27","v":26.65},null,null,{"$f":"ROUND(AI27/(1-VLOOKUP(AL27,Group,2,FALSE)),2)","v":26.65},{"$f":"IF(VLOOKUP(AL27,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP27,1)-AP27,2),Round,2,FALSE)+VLOOKUP(AL27,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL27,Group,7,FALSE)=\"\",0,ROUND(AP27-0.04999,1)-AP27+AS27)","v":0},{"$f":"IF(VLOOKUP(AL27,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL27,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","a) STRATA HEAT Mat combines the comfort of floor heating wire with the advantages associated with an uncoupling membrane."]
[null,null,null,null,"STRATA HEAT Mat will provide faster drying of the mortar while allowing for shorter time to grout.  At the same time it will easily"]
[null,null,null,null,"hold the STRATA HEAT Wire in 2, 3 or 4 peg positions for floor heating or warming installations.  It is specifically designed for use"]
[null,null,null,null,"with both modified and unmodified mortars, you can use the appropriate mortar for the installation."]
[]
[null,null,"STRATA HEAT  WIRE 120 V & 240 V",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,"Item # Lookup:","LTSH",null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,"Linear Feet per Spool",null,null,"Total SF           3 Pegs 13 Watts /SF",null,null,"Total SF           4 Pegs 10 Watts /SF",null,null,"Total SF          3\" Spacing 16 Watts /SF",null,null,"Total SF          4\" Spacing 12 Watts /SF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"STRATA HEAT Wire 120 V",null,null,null,null,null,null,"Uncoupling Systems",null,null,null,null,null,"Spacing Strips",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"0804-0050-2",null,50,null,null,15,null,null,20,null,null,12,null,null,17,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG39,'Price List'!AM39)","v":209.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG39*(1-AC39)+0.004999,2)","v":209.7},null,"YES",209.7,{"$f":"+AC39","v":0},{"$f":"+AD39","v":209.7},{"$f":"(AM39-AI39)/AM39","v":0},null,2,{"$f":"SUM(AP39:AR39)+AK39","v":209.7},null,null,{"$f":"ROUND(AI39/(1-VLOOKUP(AL39,Group,2,FALSE)),2)","v":209.7},{"$f":"IF(VLOOKUP(AL39,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP39,1)-AP39,2),Round,2,FALSE)+VLOOKUP(AL39,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL39,Group,7,FALSE)=\"\",0,ROUND(AP39-0.04999,1)-AP39+AS39)","v":0},{"$f":"IF(VLOOKUP(AL39,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL39,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"0804-0067-2",null,67,null,null,20,null,null,27,null,null,17,null,null,22,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG40,'Price List'!AM40)","v":237.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},237.45,null,"YES",237.45,0,237.45,0,null,2,237.45,null,null,237.45,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0084-2",null,84,null,null,25,null,null,33,null,null,21,null,null,28,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG41,'Price List'!AM41)","v":261.10000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},261.10000000000002,null,"YES",261.10000000000002,0,261.10000000000002,0,null,2,261.10000000000002,null,null,261.10000000000002,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0100-2",null,100,null,null,30,null,null,40,null,null,25,null,null,33,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG42,'Price List'!AM42)","v":270.35000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},270.35000000000002,null,"YES",270.35000000000002,0,270.35000000000002,0,null,2,270.35000000000002,null,null,270.35000000000002,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0133-2",null,133,null,null,40,null,null,53,null,null,33,null,null,44,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG43,'Price List'!AM43)","v":317.60000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},317.60000000000002,null,"YES",317.60000000000002,0,317.60000000000002,0,null,2,317.60000000000002,null,null,317.60000000000002,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0166-2",null,166,null,null,50,null,null,67,null,null,42,null,null,55,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG44,'Price List'!AM44)","v":365},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},365,null,"YES",365,0,365,0,null,2,365,null,null,365,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0200-2",null,200,null,null,60,null,null,80,null,null,50,null,null,66,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG45,'Price List'!AM45)","v":410.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},410.2,null,"YES",410.2,0,410.2,0,null,2,410.2,null,null,410.2,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0233-2",null,233,null,null,70,null,null,93,null,null,58,null,null,77,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG46,'Price List'!AM46)","v":456.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},456.5,null,"YES",456.5,0,456.5,0,null,2,456.5,null,null,456.5,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0266-2",null,266,null,null,80,null,null,107,null,null,66,null,null,88,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG47,'Price List'!AM47)","v":504.8},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},504.8,null,"YES",504.8,0,504.8,0,null,2,504.8,null,null,504.8,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0299-2",null,299,null,null,90,null,null,120,null,null,75,null,null,100,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG48,'Price List'!AM48)","v":553.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},553.1,null,"YES",553.1,0,553.1,0,null,2,553.1,null,null,553.1,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0332-2",null,332,null,null,100,null,null,133,null,null,83,null,null,111,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG49,'Price List'!AM49)","v":598.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},598.35,null,"YES",598.35,0,598.35,0,null,2,598.35,null,null,598.35,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0365-2",null,365,null,null,110,null,null,147,null,null,91,null,null,122,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG50,'Price List'!AM50)","v":645.70000000000005},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},645.70000000000005,null,"YES",645.70000000000005,0,645.70000000000005,0,null,2,645.70000000000005,null,null,645.70000000000005,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0398-2",null,398,null,null,120,null,null,160,null,null,99,null,null,133,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG51,'Price List'!AM51)","v":694.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},694.1,null,"YES",694.1,0,694.1,0,null,2,694.1,null,null,694.1,0,0,"",null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"STRATA HEAT Wire 240 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,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"0804-0083-4",null,83,null,null,25,null,null,33,null,null,21,null,null,28,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG55,'Price List'!AM55)","v":261.10000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG55*(1-AC55)+0.004999,2)","v":261.10000000000002},null,"YES",261.10000000000002,{"$f":"+AC55","v":0},{"$f":"+AD55","v":261.10000000000002},{"$f":"(AM55-AI55)/AM55","v":0},null,2,{"$f":"SUM(AP55:AR55)+AK55","v":261.10000000000002},null,null,{"$f":"ROUND(AI55/(1-VLOOKUP(AL55,Group,2,FALSE)),2)","v":261.10000000000002},{"$f":"IF(VLOOKUP(AL55,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP55,1)-AP55,2),Round,2,FALSE)+VLOOKUP(AL55,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL55,Group,7,FALSE)=\"\",0,ROUND(AP55-0.04999,1)-AP55+AS55)","v":0},{"$f":"IF(VLOOKUP(AL55,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL55,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"0804-0100-4",null,100,null,null,30,null,null,40,null,null,25,null,null,33,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG56,'Price List'!AM56)","v":270.35000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG56*(1-AC56)+0.004999,2)","v":270.35000000000002},null,"YES",270.35000000000002,{"$f":"+AC56","v":0},{"$f":"+AD56","v":270.35000000000002},{"$f":"(AM56-AI56)/AM56","v":0},null,2,{"$f":"SUM(AP56:AR56)+AK56","v":270.35000000000002},null,null,{"$f":"ROUND(AI56/(1-VLOOKUP(AL56,Group,2,FALSE)),2)","v":270.35000000000002},{"$f":"IF(VLOOKUP(AL56,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP56,1)-AP56,2),Round,2,FALSE)+VLOOKUP(AL56,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL56,Group,7,FALSE)=\"\",0,ROUND(AP56-0.04999,1)-AP56+AS56)","v":0},{"$f":"IF(VLOOKUP(AL56,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL56,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"0804-0133-4",null,133,null,null,40,null,null,53,null,null,33,null,null,44,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG57,'Price List'!AM57)","v":317.60000000000002},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},317.60000000000002,null,"YES",317.60000000000002,0,317.60000000000002,0,null,2,317.60000000000002,null,null,317.60000000000002,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0166-4",null,166,null,null,50,null,null,67,null,null,42,null,null,55,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG58,'Price List'!AM58)","v":365},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},365,null,"YES",365,0,365,0,null,2,365,null,null,365,0,0,"",null,"X"]
[null,"Trim",null," ","0804-0200-4",null,200,null,null,60,null,null,80,null,null,50,null,null,66,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG59,'Price List'!AM59)","v":410.2},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},410.2,null,"YES",410.2,0,410.2,0,null,2,410.2,null,null,410.2,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0233-4",null,233,null,null,70,null,null,93,null,null,58,null,null,77,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG60,'Price List'!AM60)","v":456.45},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},456.45,null,"YES",456.45,0,456.45,0,null,2,456.45,null,null,456.45,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0266-4",null,266,null,null,80,null,null,107,null,null,66,null,null,88,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG61,'Price List'!AM61)","v":504.75},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},504.75,null,"YES",504.75,0,504.75,0,null,2,504.75,null,null,504.75,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0299-4",null,299,null,null,90,null,null,120,null,null,75,null,null,100,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG62,'Price List'!AM62)","v":553.1},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},553.1,null,"YES",553.1,0,553.1,0,null,2,553.1,null,null,553.1,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0332-4",null,332,null,null,100,null,null,133,null,null,83,null,null,111,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG63,'Price List'!AM63)","v":598.29999999999995},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},598.29999999999995,null,"YES",598.29999999999995,0,598.29999999999995,0,null,2,598.29999999999995,null,null,598.29999999999995,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0415-4",null,415,null,null,125,null,null,167,null,null,104,null,null,138,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG64,'Price List'!AM64)","v":714.5},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG64*(1-AC64)+0.004999,2)","v":714.5},null,"YES",714.5,{"$f":"+AC64","v":0},714.5,{"$f":"(AM64-AI64)/AM64","v":0},null,2,{"$f":"SUM(AP64:AR64)+AK64","v":714.5},null,null,{"$f":"ROUND(AI64/(1-VLOOKUP(AL64,Group,2,FALSE)),2)","v":714.5},{"$f":"IF(VLOOKUP(AL64,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP64,1)-AP64,2),Round,2,FALSE)+VLOOKUP(AL64,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL64,Group,7,FALSE)=\"\",0,ROUND(AP64-0.04999,1)-AP64+AS64)","v":0},{"$f":"IF(VLOOKUP(AL64,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL64,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"0804-0498-4",null,498,null,null,150,null,null,200,null,null,124,null,null,166,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG65,'Price List'!AM65)","v":895.35},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},895.35,null,"YES",895.35,0,895.35,0,null,2,895.35,null,null,895.35,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0581-4",null,581,null,null,175,null,null,233,null,null,145,null,null,194,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG66,'Price List'!AM66)","v":985.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},985.05,null,"YES",985.05,0,985.05,0,null,2,985.05,null,null,985.05,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0664-4",null,664,null,null,200,null,null,266,null,null,166,null,null,221,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG67,'Price List'!AM67)","v":1022.05},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1022.05,null,"YES",1022.05,0,1022.05,0,null,2,1022.05,null,null,1022.05,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0747-4",null,747,null,null,225,null,null,300,null,null,187,null,null,249,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG68,'Price List'!AM68)","v":1094.0999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1094.0999999999999,null,"YES",1094.0999999999999,0,1094.0999999999999,0,null,2,1094.0999999999999,null,null,1094.0999999999999,0,0,"",null,"X"]
[null,"Trim",null,null,"0804-0830-4",null,830,null,null,250,null,null,333,null,null,207,null,null,276,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG69,'Price List'!AM69)","v":1203.0999999999999},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},1203.0999999999999,null,"YES",1203.0999999999999,0,1203.0999999999999,0,null,2,1203.0999999999999,null,null,1203.0999999999999,0,0,"",null,"X"]
[]
[null,null,null,"Notes:","STRATA HEAT WIRE is a versatile floor heating wire designed for use under tile and stone to provide luxury and comfort.  STRATA"]
[null,null,null,null,"HEAT WIRE can be used with the STRATA HEAT Mat or STRATA HEAT Spacing Strips to meet all of your floor heating needs."]
[null,null,null,null,"System allows for combination of 2 and 3 peg spacing if desired.  With STRATA HEAT Wire there isn't any need to dig out the mat to"]
[null,null,null,null,"burry splices between the cold lead and the heating portion of the wire or the heated wire termination.  These splice-less junctions have"]
[null,null,null,null,"a uniform diameter and easily fit into the STRATA HEAT Mat castellations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"STRATA HEAT WIRE SPACING STRIPS",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,"Item # Lookup:","LTSHSPACE",null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"0802-4012-1",null,"STRATA HEAT Wire Spacing Strip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 LF/CTN",null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG79,'Price List'!AM79)","v":45.4},"CTN",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG79*(1-AC79)+0.004999,2)","v":45.4},null,"YES",45.4,{"$f":"+AC79","v":0},{"$f":"+AD79","v":45.4},{"$f":"(AM79-AI79)/AM79","v":0},null,2,{"$f":"SUM(AP79:AR79)+AK79","v":45.4},null,null,{"$f":"ROUND(AI79/(1-VLOOKUP(AL79,Group,2,FALSE)),2)","v":45.4},{"$f":"IF(VLOOKUP(AL79,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP79,1)-AP79,2),Round,2,FALSE)+VLOOKUP(AL79,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL79,Group,7,FALSE)=\"\",0,ROUND(AP79-0.04999,1)-AP79+AS79)","v":0},{"$f":"IF(VLOOKUP(AL79,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL79,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","STRATA HEAT WIRE SPACING STRIPS are a 12” long interlocking plastic strip to hold the STRATA HEAT WIRE."]
[null,null,null,null,"The spacing strips can be adhered to any subfloor to provide the correct wire spacing for the STRATA HEAT WIRE."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"STRATA HEAT THERMOSTATS",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,"Item # Lookup:","LTSH",null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"0804-0404-TW",null,"Smart LCD WiFi Thermostat w/LCD Touch Screen",null,null,null,null,null,null,null,null,null,null,"120V/240V Dual Voltage",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG86,'Price List'!AM86)","v":378},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG86*(1-AC86)+0.004999,2)","v":378},null,"YES",378,{"$f":"+AC86","v":0},{"$f":"+AD86","v":378},{"$f":"(AM86-AI86)/AM86","v":0},null,2,{"$f":"SUM(AP86:AR86)+AK86","v":378},null,null,{"$f":"ROUND(AI86/(1-VLOOKUP(AL86,Group,2,FALSE)),2)","v":378},{"$f":"IF(VLOOKUP(AL86,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP86,1)-AP86,2),Round,2,FALSE)+VLOOKUP(AL86,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL86,Group,7,FALSE)=\"\",0,ROUND(AP86-0.04999,1)-AP86+AS86)","v":0},{"$f":"IF(VLOOKUP(AL86,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL86,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"0804-0403-TW",null,"Wi-Fi Thermostat w/Touch Panel LCD Display",null,null,null,null,null,null,null,null,null,null,"120V/240V Dual Voltage",null,null,null,null,"Stock",null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG87,'Price List'!AM87)","v":291.7},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG87*(1-AC87)+0.004999,2)","v":291.7},null,"YES",291.7,{"$f":"+AC87","v":0},{"$f":"+AD87","v":291.7},{"$f":"(AM87-AI87)/AM87","v":0},null,2,{"$f":"SUM(AP87:AR87)+AK87","v":291.7},null,null,{"$f":"ROUND(AI87/(1-VLOOKUP(AL87,Group,2,FALSE)),2)","v":291.7},{"$f":"IF(VLOOKUP(AL87,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP87,1)-AP87,2),Round,2,FALSE)+VLOOKUP(AL87,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL87,Group,7,FALSE)=\"\",0,ROUND(AP87-0.04999,1)-AP87+AS87)","v":0},{"$f":"IF(VLOOKUP(AL87,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL87,Group,7,FALSE))","v":""},null,"X"]
[null,"Trim",null,null,"0804-0402-TW",null,"Programmable LCD Thermostat w/Touch Screen",null,null,null,null,null,null,null,null,null,null,"120V/240V Dual Voltage",null,null,null,null,null,null,{"$f":"IF(Suggested=\"Yes\",'Price List'!AG88,'Price List'!AM88)","v":211},"EA",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG88*(1-AC88)+0.004999,2)","v":211},null,"YES",211,{"$f":"+AC88","v":0},{"$f":"+AD88","v":211},{"$f":"(AM88-AI88)/AM88","v":0},null,2,{"$f":"SUM(AP88:AR88)+AK88","v":211},null,null,{"$f":"ROUND(AI88/(1-VLOOKUP(AL88,Group,2,FALSE)),2)","v":211},{"$f":"IF(VLOOKUP(AL88,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP88,1)-AP88,2),Round,2,FALSE)+VLOOKUP(AL88,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL88,Group,7,FALSE)=\"\",0,ROUND(AP88-0.04999,1)-AP88+AS88)","v":0},{"$f":"IF(VLOOKUP(AL88,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL88,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,null,null,null,null,null,null,"X"]
[null,null,"STRATA HEAT THERMAL PACKS",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,"Item # Lookup:","LTSH0T0003",null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"X"]
[null,"Trim",null,null,"0802-0003-2",null,"STRATA HEAT Thermal Pack Additive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 PACKS/CTN",null,"a",{"$f":"IF(Suggested=\"Yes\",'Price List'!AG92,'Price List'!AM92)","v":36.85},"BAG",{"$f":"+Instructions!$B$3","v":"N"},null,{"$f":"+Instructions!$C$22","v":0},{"$f":"ROUND($AG92*(1-AC92)+0.004999,2)","v":36.85},null,"YES",36.85,{"$f":"+AC92","v":0},{"$f":"+AD92","v":36.85},{"$f":"(AM92-AI92)/AM92","v":0},null,2,{"$f":"SUM(AP92:AR92)+AK92","v":36.85},null,null,{"$f":"ROUND(AI92/(1-VLOOKUP(AL92,Group,2,FALSE)),2)","v":36.85},{"$f":"IF(VLOOKUP(AL92,Group,5,FALSE)=\"YES\",VLOOKUP(ROUND(ROUND(AP92,1)-AP92,2),Round,2,FALSE)+VLOOKUP(AL92,Group,6,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(AL92,Group,7,FALSE)=\"\",0,ROUND(AP92-0.04999,1)-AP92+AS92)","v":0},{"$f":"IF(VLOOKUP(AL92,Group,7,FALSE)=\"\",\"\",VLOOKUP(AL92,Group,7,FALSE))","v":""},null,"X"]
[]
[null,null,null,"Notes:","The world’s first patent pending additive designed exclusively for use in LATICRETE 253 Gold, 254 Platinum & 4-XLT adhesives."]
[null,null,null,null,"Utilizing Thermal Diffusion Technology™ heat from the STRATA HEAT Wire, is uniformly distributed throughout the adhesive"]
[null,null,null,null,"providing faster floor heat-up and a more comfortable and energy efficient installation.",null,null,null,null,null,null,null,null,null,null,null,null,"  a) Mix 2 PACKS per each 50 lb. of Thinset."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"This price list is available electronically on an Excel spreadsheet at www.conestogatile.com/pricelists."]
[]
[null,null,"The spreadsheet has many special features to assist you.  Apply your discount to generate your net costs for your purchasing department.  Apply your standard gross margin percentage or custom prices to generate your own custom price list for your showroom.  Print out individual price list for each series that can be attached to the back of your sample boards for easy reference."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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",null,"X",null,"X",null,"X",null,"X",null,"X",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"]
[]
[null,null,null,"$.05 Round Matrix"]
[null,null,null,-0.04,0.01]
[null,null,null,-0.03,0.02]
[null,null,null,-0.02,0.03]
[null,null,null,-0.01,-0.01]
[null,null,null,0,0]
[null,null,null,0.01,1.0000000000005116E-2]
[null,null,null,0.02,2.0000000000003126E-2]
[null,null,null,0.03,3.0000000000001137E-2]
[null,null,null,0.04,-0.01]
[null,null,null,0.05,0]

{"sheet":"Websites","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Easy Access Website links"]
[]
["ConestogaTile's Website","http://www.cctd.com/"]
[]
["Manufacturer's Home Page","http://www.laticrete.com/"]
[]
[]
["Product","Direct Website Link"]
["Strata Heat","https://laticrete.com/en/our-products/tile-and-stone-installation/strata_heat"]

{"sheet":"Changes","index":4,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Announced","Series","Description"]
[null,null," "]
["New Products"]
["2008-01-01","Renaming \"Floor Heat\""]
["2014-04-21","Floor HEAT Wire"]
["2018-03-02","Strata Heat Mat","Floor Heating uncoupling mat."]
["2018-03-02","Strata Heat Wire 120 V & 240 V","Floor Heating wire."]
["2018-03-02","Strata Heat Wire Spacing Strips","Plastic strip to hold the Strata Heat Wire."]
["2018-03-02","Strata Heat Thermostats","Specifically designed thermostats to work with floor heating systems."]
["2018-03-02","Strata Heat Thermal Packs","Distributes heat throughout the adhesive."]
["2021-03-03","STRATA HEAT MAT","Newly improved versions of the old Mat added.  New pattern with same hydration vents, larger rolls & sheets:  LTSH0M161, #0179-0161-H 161 SF/Roll (3' 3\" x 49' 6\") and LTSH0M009, #0179-1082-H 8.60 SF/Sheet (3' 3\" x 2' 6.3\")."]
["2021-03-03","STRATA HEAT  WIRE 120 V & 240 V","The newly improved wires now have a spliceless design and single diameter throughout the length of the wire which allows for an easier installation process.  No need to cut out the mat and/or the sub-floor to bury the cold lead."]
["2022-01-05","Strata Heat Thermostats","0804-0404-TW Smart LCD WiFi Thermostat w/LCD Touch Screen and 0804-0403-TW Wi-Fi Thermostat w/Touch Panel LCD Display.  Both are 120V/240V Dual Voltage."]
["2024-02-07","Strata Heat Mat","0179-5082-H added that contains 50 Sheets/CTN.  Each sheet is 8.60 SF/Sheet (3' 3\" x 2' 6.3\")."]
["2024-10-15","Strata Heat Thermostats","0804-0402-TW Programmable LCD Thermostat w/Touch Screen, 120V/240V Dual Voltage."]
[]
[]
[]
["Discontinued Products"]
["2009-01-01","0800-0005-2","15mA Thermostat, 120 VAC"]
["2009-01-01","0800-0009-4","15mA Thermostat, 240 VAC"]
["2018-03-02","Floor HEAT 120 VAC Standard Mat","All 120 VAC Standard Mats, 0800-0002-2S Wire Eye, 0800-0001-2 Floor Warming Temperature Sensor & 0800-0003-2 120V/240V Dual Voltage Programmable Thermostat."]
["2018-03-02","Floor HEAT 240 VAC Standard Mat","All 240 VAC Standard Mats, 0800-0002-2S Wire Eye, 0800-0001-2 Floor Warming Temperature Sensor & 0800-0003-2 120V/240V Dual Voltage Programmable Thermostat."]
["2018-03-02","LATICRETE Floor HEAT Kit 120 VAC","All 120 VAC Floor Heat Kits."]
["2018-03-02","Floor HEAT Wire 120 VAC","All sizes."]
["2018-03-02","Floor HEAT Wire 240 VAC","All sizes."]
["2021-03-03","STRATA HEAT MAT","LTSH0M150, #0177-0150-H 150 SF/Roll (3' 3\" x 46' 2\") and LTSH0M008, #0177-1084-H 8.20 SF/Sheet ( 3' 3\" x 2' 5\").  They will be replaced with the improved versions; see above New Product section."]
["2021-03-03","STRATA HEAT Wire 120 V","#0802-0017-2, 17 Linear Foot Wire and #0802-0034-2, 34 Linear Foot Wire."]
["2022-01-05","Strata Heat Thermostats","0802-0403-T Programmable Thermostat and 0802-0404-T  Wi-Fi Compatible Thermostat."]
[]
[]
[]
["Changes"]
["2018-01-16","Floor Heat","Renamed Strata Heat."]