{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Rough In","Finish","Labor","R Estimate","R Cost","F Cost","Furnace","Coil","Air Handler","Geothermal","Heater Pack","Misc","Dropdown Lists"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":1,"defined_names":17,"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":"1904"}

{"sheet":"Rough In","index":0,"n_rows":167,"n_cols":11,"rows_kept":167,"cut":false,"hidden":false,"merged":[[131,0,131,1],[144,0,144,1],[153,0,153,1],[157,0,157,1],[86,0,86,1],[95,0,95,1],[104,0,104,1],[111,0,111,1],[121,0,121,1],[21,0,21,1],[29,0,29,1],[56,0,56,1],[63,0,63,1],[66,0,66,1],[130,8,130,9],[158,4,158,5],[133,4,133,5],[143,4,143,5],[153,4,153,5],[146,8,146,9],[156,8,156,9],[111,8,111,9],[115,4,115,5],[119,4,119,5],[121,8,121,9],[125,8,125,9],[91,4,91,5],[100,4,100,5],[98,8,98,9],[92,8,92,9],[105,8,105,9],[69,8,69,9],[69,4,69,5],[74,4,74,5],[81,4,81,5],[80,8,80,9],[74,8,74,9],[54,8,54,9],[50,4,50,5],[58,4,58,5],[59,8,59,9],[64,8,64,9],[1,8,1,10],[1,3,1,5],[24,8,24,9],[28,8,28,9],[35,4,35,5],[181,4,181,6],[181,8,181,10],[6,0,6,1],[3,2,4,4],[2,3,2,10],[3,6,3,7],[4,6,4,7],[3,9,3,10],[4,9,4,10],[0,0,4,1],[7,4,7,5],[20,4,20,5],[7,8,7,9],[13,8,13,9],[0,2,0,10],[1,6,1,7]]}
[{"$error":"#VALUE!"},null,"New Construction Rough In - Costing Form"]
[null,null,"PO:",null,null,null,"Deliver On:"]
[null,null,"Notes:"]
[null,null,"Add following equipment previously purchased to delivery:",null,null,"Ticket #","Job PO",null,"Model","Serial #"]
[]
[]
[null,null,"#"]
["Furnace",null,null,null,"Transitional Takeoffs",null,"#",null,"Stick-On Flat 90’s ",null,"#"]
["Coil",null,null,null,"24x12","ST-1203-2412",null,null,"8\"","ST-306-08"]
["Air Handler",null,null,null,"24x10","ST-1203-2410",null,null,"7\"","ST-306-07"]
["Geothermal",null,null,null,"20x10","ST-1203-2010",null,null,"6\"","ST-306-06"]
["Heater Pack",null,null,null,"24x8","ST-1203-2408",null,null,"4\"","ST-306-04"]
["Bottom Box",{"$f":"_xlfn.LET(_xlpm.furn,B8,_xlpm.ah,B10,_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.aw,IFERROR(_xlfn.XLOOKUP(_xlpm.ah,'Air Handler'!$C:$C,'Air Handler'!$F:$F),\"\"),IF(_xlpm.furn<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.fw,Misc!$B$4:$B$7,Misc!$E$4:$E$7),\"width not matched\"),IF(_xlpm.ah<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.aw,Misc!$B$9:$B$12,Misc!$E$9:$E$12),\"width not matched\"),\"\")))","v":""},null,null,"22x8","ST-1203-2208"]
["Plenum",{"$f":"_xlfn.LET(_xlpm.coil,B9,_xlpm.furn,B8,_xlpm.ah,B10,_xlpm.cw,IFERROR(_xlfn.XLOOKUP(_xlpm.coil,Coil!$C:$C,Coil!$F:$F),\"\"),_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.aw,IFERROR(_xlfn.XLOOKUP(_xlpm.ah,'Air Handler'!$C:$C,'Air Handler'!$F:$F),\"\"),IF(_xlpm.coil<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.cw,Misc!$B$26:$B$29,Misc!$E$26:$E$29),\"width not matched\"),IF(_xlpm.furn<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.fw,Misc!$B$16:$B$19,Misc!$E$16:$E$19),\"width not matched\"),IF(_xlpm.ah<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.aw,Misc!$B$21:$B$24,Misc!$E$21:$E$24),\"width not matched\"),\"\"))))","v":""},null,null,"20x8","ST-1203-2008",null,null,"Round Pipe (5' Sections) 30GA "]
["Coil Adapter",{"$f":"_xlfn.LET(_xlpm.furn,B8,_xlpm.coil,B9,_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.cw,IFERROR(_xlfn.XLOOKUP(_xlpm.coil,Coil!$C:$C,Coil!$F:$F),\"\"),IF(OR(_xlpm.furn=\"\",_xlpm.coil=\"\",_xlpm.fw=\"\",_xlpm.cw=\"\"),\"\",IF(_xlpm.fw=_xlpm.cw,\"\",_xlfn.LET(_xlpm.lo,IF(_xlpm.fw<=_xlpm.cw,_xlpm.fw,_xlpm.cw),_xlpm.hi,IF(_xlpm.fw<=_xlpm.cw,_xlpm.cw,_xlpm.fw),IFERROR(_xlfn.XLOOKUP(1,(Misc!$B$33:$B$45=_xlpm.lo)*(Misc!$C$33:$C$45=_xlpm.hi),Misc!$E$33:$E$45),\"no adapter found\")))))","v":""},null,null,"18x8","ST-1203-1808",null,null,"3\"","ST-RDP-053003"]
["Coil Spacer",{"$f":"IF(D16<>TRUE,\"\",_xlfn.LET(_xlpm.furn,B8,_xlpm.coil,B9,_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.cw,IFERROR(_xlfn.XLOOKUP(_xlpm.coil,Coil!$C:$C,Coil!$F:$F),\"\"),IF(OR(_xlpm.furn=\"\",_xlpm.coil=\"\",_xlpm.fw=\"\",_xlpm.cw=\"\"),\"\",IF(_xlpm.fw<>_xlpm.cw,\"N/A-widths differ\",IFERROR(_xlfn.XLOOKUP(1,(Misc!$B$33:$B$45=_xlpm.fw)*(Misc!$C$33:$C$45=_xlpm.fw),Misc!$E$33:$E$45),\"spacer not found\")))))","v":""},{"$f":"IF(AND(D16=TRUE,LEFT(B16,3)=\"FAB\"),1,\"\")","v":""},false,"16x8","ST-1203-1608",null,null,"4\"","ST-RDP-053004"]
["Bricks","HO-619345",null,null,"14x8","ST-1203-1408",null,null,"6\"","ST-RDP-053006"]
["Adjustable Pump-Ups","DV-HPR6-2P",null,null,"12x8","ST-1203-1208",null,null,"7\"","ST-RDP-053007"]
["SMALL BYP. HUMIDIFIER","HUMCRSBP2412",null,null,"10x8","ST-1203-1008",null,null,"8\"","ST-RDP-053008"]
["LARGE BYP. HUMIDIFIER","HUMCRLBP2417",null,null,null,null,null,null,"10\"","ST-RDP-053010"]
[null,null,null,null,"Duct - 5' Sections",null,null,null,"12\"","ST-RDP-053012"]
["Media Cabinets",null,null,null,"25x10","ST-DT-602510",null,null,"14\"","ST-RDP-052614"]
["Core Media Cabinet - 16X25","EZXCABCR1016",null,null,"24x12","ST-DT-602412",null,null,"16\"","ST-RDP-052616"]
["Core Media Cabinet - 20X25","EZXCABCR1320",null,null,"24x10","ST-DT-602410"]
["Media Cabinet - 24X25","FILCABXL0024",null,null,"20x10","ST-DT-602010",null,null,"Boot Frames"]
["Honeywell Media Cab 16x20","HW-F100F1620",null,null,"24x8","ST-DT-602408",null,null,"H-4 Boot Frame","PT-H4"]
["Honeywell Media Cab 20x20","HW-F100F2020",null,null,"22x8","ST-DT-602208",null,null,"H-6 Boot Frame","PT-H6"]
["Honeywell Media Cab 20x25","HW-F100F2025",null,null,"20x8","ST-DT-602008"]
[null,null,null,null,"18x8","ST-DT-601808",null,null,"Boots"]
["Standard Items",null,null,null,"16x8","ST-DT-601608",null,null,"4x10x4 end boot","ST-1373-041004"]
["Tub 3/4\" screws","MA-HW8X3/4ZT",1,null,"14x8","ST-DT-601408",null,null,"4x10x4 L boot","ST-1374-041004"]
["Tub 1/2\" screws","MA-HW8X1/2ZT",1,null,"12x8","ST-DT-601208",null,null,"4x10x4 straight boot","ST-1370-041004"]
["Basset Hangers","BP-A125",null,null,"10x8","ST-DT-601008",null,null,"4x10x6 L boot","ST-1374-041006"]
["5' Drives","ST-213-60",null,null,"8x8","ST-DT-600808",null,null,"4x10x6 end boot","ST-1373-041006"]
["5' S-Locks","ST-209-60",null,null,null,null,null,null,"4x10x6 straight boot","ST-1370-041006"]
["Rolls of 3\" tape","DT-322F3",null,null,"End Caps",null,null,null,"4x12x6 end boot","ST-1373-041206"]
["Rolls of mastic tape","AFG-1404-181",null,null,"25x12","ST-1210-3012",null,null,"4x12x6 L boot","ST-1374-041206"]
["Duct Sealant Gallon Pail","HF-SDSWB",null,null,"24x12","ST-1210-2412",null,null,"4x12x6 straight boot","ST-1370-041206"]
["2\" brushes","DV-B503",null,null,"24x10","ST-1210-2410",null,null,"4x12x7 L boot","ST-1374-041207"]
["Tubes of Clear Silicone","BO-370C",null,null,"20x10","ST-1210-2010",null,null,"4x12x7 straight boot","ST-1370-041207"]
["10\" Section - 3/4\" PVC","BR-6106",1,null,"24x8","ST-1210-2408",null,null,"4x12x7 end boot","ST-1373-041207"]
["EZ-Trap Clear PVC Trap ","RC-83114",null,null,"22x8","ST-1210-2208",null,null,"6x10x7 end-boot","ST-1373-061007"]
["3/4\" PVC threaded male","BR-0342",1,null,"20x8","ST-1210-2008",null,null,"6x10x7 L boot","ST-1374-061007"]
["3/4\" PVC threaded female ","BR-0341",null,null,"18x8","ST-1210-1808",null,null,"6x10x7 straight boot","ST-1370-061007"]
["3/4\" PVC 90's","BR-0344",6,null,"16x8","ST-1210-1608",null,null,"6x12x7 end boot","ST-1373-061207"]
["3/4\" PVC T's","BR-0349",2,null,"14x8","ST-1210-1408",null,null,"6x12x7 L boot","ST-1374-061207"]
["3/4\" PVC 45’s","BR-0346",4,null,"12x8","ST-1210-1208",null,null,"6x12x7 straight boot","ST-1370-061207"]
["Glue","DV-510",1,null,"10x8","ST-1210-1008",null,null,"6x12x8 straight boot","ST-1370-061208"]
["Cleaner","DV-PPC16",1,null,"8x8","ST-1210-0808",null,null,"6x12x8 end boot","ST-1373-061208"]
["Rubber 3\"x3\" pads","DV-MP3E",5,null,null,null,null,null,"6x12x8 L boot","ST-1374-061208"]
["Bag 36\" Panduits","DV-7P36",null,null,"Supply Duct Reducers",null,null,null,"6x14x8 L Boot","ST-1374-061408"]
["Foil Back Fiberglass-2\" 75' ","KF-E24875FSKLKDW",null,null,"2\" reducer for 8\" duct","ST-187-02",null,null,"6x14x8 Straight Boot","ST-1370-061408"]
["Lineset Clips - Reg. Size ","TP-41125 (5 PER PACK)",1,null,"4\" reducer for 8\" duct","ST-187-04",null,null," 6X14X8 end boot","ST-1373-061408"]
["Roll of 3\" Webbing","DV-710102",null,null,"6\" reducer for 8\" duct","ST-187-06"]
["Aquaguard Float Switch","AG-1200",null,null,"8\" reducer for 8\" duct","ST-187-08",null,null,"Oval (100\" sections)"]
[null,null,null,null,"24x12 to 24x10 reduc.","ST-1251-24122410",null,null,"6\"","ST-4100-10006"]
["Temp Filters - Pleated 1\"",null,null,null,"24x10 to 24x8 reduc.","ST-1251-24102408",null,null,"7\"","ST-4100-10007"]
["16x25x1 temp filter","FI-16X25X1",null,null,null,null,null,null,"8\"","ST-4100-10008"]
["20x25x1 temp filter","FI-20X25X1",null,null,"Round Reducers"]
["24x25x1 temp filter","FI-24X25X1",{"$f":"IF(C25=1,6,\"\")","v":""},null,"4\"-3\"","ST-133-040326",null,null,"Oval to Round L-Boot"]
["16x20x1 temp filter","FI-16X20X1","",null,"6\"-4\"","ST-133-060426",null,null,"6\" oval to round L-Boot","ST-4244NC-06"]
["20x20x1 temp filter","FI-20X20X1","",null,"8\"-6\"","ST-133-080626",null,null,"7\" oval to round L-Boot","ST-4244NC-07"]
[null,null,null,null,"10\"-8\"","ST-133-100826",null,null,"8\" oval to round L-Boot","ST-4244NC-08"]
["Drywall Edging",null,null,null,"12\"-10\"","ST-133-121026"]
["5' sections","ST-210-60",null,null,"14\"-10\"","ST-133-141026",null,null,"Oval to Round End Boot"]
[null,null,null,null,"14\"-12\"","ST-133-141226",null,null,"6\" oval-round end boot","ST-4247NC-0606"]
["Duct Fittings",null,null,null,"16\"-12\"","ST-133-161226",null,null,"7\" oval-round end boot","ST-4247NC-0707"]
["10x8 SW 90","ST-1240-1008",null,null,"16\"-14\"","ST-133-161426",null,null,"8\" oval-round end boot","ST-4247NC-0808"]
["10x8 BW 90","ST-1246-1008"]
["12x8 SW 90","ST-1240-1208",null,null,"Y's",null,null,null,"Oval-Round Straight Boot"]
["12x8 BW 90","ST-1246-1208",null,null,"6X4X4 WITH REDUCER","ST-324-060404",null,null,"6\" oval-round straight boot","ST-4248NC-0606"]
["14x8 SW 90","ST-1240-1408",null,null,"7x5x3 WITH REDUCER","ST-324-070503",null,null,"7\" oval-round straight boot","ST-4248NC-0707"]
["14x8 BW 90","ST-1246-1408",null,null,"8X7X6 WITH REDUCER","ST-324-080706",null,null,"8\" oval-round straight boot","ST-4248NC-0808"]
["16x8 SW 90","ST-1240-1608"]
["16x8 BW 90","ST-1246-1608",null,null,"T's",null,null,null,"Oval Stackhead w/wings"]
["18x8 SW 90","ST-1240-1808",null,null,"4x4x4","ST-219-040404",null,null,"6\" oval stack head w/4x10","ST-4235-0941006"]
["18x8 BW 90","ST-1246-1808",null,null,"6x4x4W/reducers","ST-219-060606 ",null,null,"7” oval stackhead w/4x12","ST-4235-0941207"]
["20x8 SW 90","ST-1240-2008",null,null,"6x6x6","ST-219-060606",null,null,"7” oval stackhead w/6x12","ST-4235-0961207"]
["20x8 BW 90","ST-1246-2008",null,null,"7x7x7","ST-219-070707",null,null,"8\" oval stackhead w/6x14","ST-4235-0961408"]
["22x8 SW 90","ST-1240-2208",null,null,"18x16x16 W/reducers","ST-219-080808 "]
["22x8 BW 90","ST-1246-2208",null,null,null,null,null,null,"Stack (100\" sections)"]
["24x8 SW 90","ST-1240-2408",null,null,"Short Collars w/Crimp",null,null,null,"3.25x10","ST-WSBL-1000310"]
["24x8 BW 90","ST-1246-2408",null,null,"4\"","ST-172-04",null,null,"3.25x12","ST-WSBL-1000312"]
["24x10 SW 90","ST-1240-2410",null,null,"6\"","ST-172-06",null,null,"3.25x14","ST-WSBL-1000314"]
["24x10 BW 90","ST-1246-2410",null,null,"7\"","ST-172-07"]
[null,null,null,null,"8\"","ST-172-08",null,null,"Stack to Round L-Boot"]
["End Caps",null,null,null,"10\"","ST-172-10",null,null,"3x10x6","ST-1218-031006"]
["6\"","ST-152-06",null,null,"12\"","ST-172-12",null,null," 3x10x7","ST-1218-031007"]
["7\"","ST-152-07",null,null,"14\"","ST-172-14",null,null,"3x12x7","ST-1218-031207"]
["8\"","ST-152-08",null,null,"16\"","ST-172-16",null,null,"  3x12x8","ST-1218-031208"]
["10\"","ST-152-10",null,null,null,null,null,null,"3X14X8","ST-1218-031408"]
["12\"","ST-152-12",null,null,"Short Collars - No Crimp"]
["14\"","ST-152-14",null,null,"4\"","ST-171-04",null,null,"Stack to Round End Boots"]
["16\"","ST-152-16",null,null,"6\"","ST-171-06",null,null,"3x10x6","ST-1219-031006"]
[null,null,null,null,"7\"","ST-171-07",null,null,"3X12X6","ST-1219-031206"]
["Fans(Include Finish Kit w/order)",null,null,null,"8\"","ST-171-08",null,null,"3x12x7","ST-1219-031207"]
["50 CFM Fan","BF-1667EH",null,null,"10\"","ST-171-10",null,null,"3X14X7","ST-1219-031407"]
["50 CFM Fan","BF-2677H/2678F",null,null,"12\"","ST-171-12"]
["50 CFM LIGHT","BF-2678f",null,null,"14\"","ST-171-14",null,null,"Stack to Round Straight Boots"]
["80 CFM Fan","BF-AE80B",null,null,null,null,null,null,"3x10x6","ST-1214-031006"]
["80 CFM FAN","BF-A000HLNF",null,null,"PVC",null,null,null,"3x10x7","ST-1214-031007"]
["80 CFM Light","BF-AE80BF1",null,null,"2\" PVC - 10' Sections","BR-6082",null,null,"3x12x7","ST-1214-031207"]
["50 Finish Kit","BF-1688EF",null,null,"2\" PVC 90","BR-0389",null,null,"3x12x8","ST-1214-031208"]
[null,null,null,null,"2\" PVC 45","BR-0387DWV",null,null,"3x14x8","ST-1214-031408"]
["Panning",null,null,null,"2\" PVC Coupling","BR-0384"]
["Single Sheet","ST-20717",null,null,"2\" J-Hooks","DV-515J2000",null,null,"Deep Boxes"]
["Double Sheet","ST-20833",null,null,"2\" Concentric Kit","DV-CVENT2",null,null,"4x10","ST-1172-0410"]
["Thermopan Single","TP-1648",null,null,"3\" PVC - 10' Sections","BR-6081",null,null,"4x12","ST-1172-0412"]
["Thermopan Double","TP-3236",null,null,"3\" PVC 90","BR-0419",null,null,"6x14","ST-1172-0614"]
["Thermopan Header","TP-16013",null,null,"3\" PVC 45","BR-0417",null,null,"6x12","ST-1172-0612"]
[null,null,null,null,"3\" PVC Coupling","BR-0415"]
["FLEX R8",null,null,null,"3\" J-Hooks","DV-515J3000",null,null,"Stick-On Long Collars(w/dampers)"]
["4\"","FX-4KPR8",null,null,"3\"-2\" PVC reducer","BR-0414",null,null,"4\"","ST-302-04"]
["6\"","FX-6KPR8",null,null,"3\" Concentric Kit","DV-CVENT3",null,null,"6\"","ST-302-06"]
["7\"","FX-7KPR8",null,null,null,null,null,null,"7\"","ST-302-07"]
["8\"","FX-8KPR8",null,null,"Register Starting Collars",null,null,null,"8\"","ST-302-08"]
["10\"","FX-10KPR8",null,null,"4x10","ST-PH101-0410",null,null,"10\"","ST-302-10"]
["12\"","FX-12KPR8",null,null,"4x12","ST-PH101-0412",null,null,"12\"","ST-302-12"]
["14\"","FX-14KPR8",null,null,null,null,null,null,"14\"","ST-302-14"]
["16\"","FX-16KPR8",null,null,"Starting Collars",null,null,null,"18\"","ST-302-16"]
[null,null,null,null,"10X8","ST-1200-0808"]
["Elbows for Round Pipe",null,null,null,"10x8","ST-1200-1008",null,null,"Alum. Bath Flex (25')"]
["4\"","ST-ELV-3004",null,null,"12x8","ST-1200-1208",null,null,"4\"","FX-4MC"]
["6\"","ST-ELV-3006",null,null,"14x8","ST-1200-1408",null,null,"3\"","FX-3MC"]
["7\"","ST-ELV-3007",null,null,"16X8","ST-1200-1608"]
["8\"","ST-ELV-3008",null,null,"18x8","ST-1200-1808",null,null,"Roof Jack"]
["10\"","ST-ELV-3010",null,null,"20x8","ST-1200-2008",null,null,"Small ","BF-636"]
["12\"","ST-ELV-2612",null,null,"24x8","ST-1200-2208",null,null,"Large","BF-634"]
["14\"","ST-ELV-2614",null,null,"20x10","ST-1200-2408",null,null,"3\" Rubber Plumber Flashing","DV-5-11866"]
["16\"","ST-ELV-2616",null,null,"24x10","ST-1200-2410"]
[null,null,null,null,"24x12","ST-1200-2412",null,null,"Evolution Zone Dampers"]
["Return Air Frames",null,null,null,"30x12","ST-1200-3012",null,null,"6\"","DAMPRND06INC"]
["12x6","ST-31HC-0610",null,null,null,null,null,null,"8\"","DAMPRND08INC"]
["14x6","ST-31HC-0614",null,null,"Manual Damp. - Rnd Pipe",null,null,null,"10\"","DAMPRND10INC"]
["24x6","ST-33HC-0824",null,null,"4\"","ST-180-2-04",null,null,"12\"","DAMPRND12INC"]
["30x6","ST-33HC-0630",null,null,"6\"","ST-180-2-06",null,null,"14\"","DAMPRND14INC"]
["30x10","ST-33HC-3008",null,null,"7\"","ST-180-2-07",null,null,"16\"","DAMPRND16INC"]
["30x12","ST-33HC-3012",null,null,"8\"","ST-180-2-08",null,null,"8\" x 10\"","DAMPREC08X10"]
["30x8","ST-33HC-3008",null,null,"10\"","ST-180-2-10",null,null,"8\" x 14\"","DAMPREC08X14"]
["12x12","ST-33HC-1212",null,null,"12\"","ST-180-2-12",null,null,"8\" x 18\"","DAMPREC08X18"]
["14x14","ST-33HC-1414",null,null,"14\"","ST-180-2-14",null,null,"8\" x 24\"","DAMPREC08X24"]
["16x16","ST-33HC-1616",null,null,"16\"","ST-180-2-16",null,null,"10\" x 10\"","DAMPREC10X10"]
["20x20","ST-33HC-2020",null,null,null,null,null,null,"10\" x 14\"","DAMPREC10X14"]
[null,null,null,null,"Spiral Couplings/Accessories",null,null,null,"10\" x 18\"","DAMPREC10X18"]
["Stick-on Saddle Collars",null,null,null,"10\" spiral coupling","LSM-SC10",null,null,"10\" x 24\"","DAMPREC10X24"]
["4\"","ST-305-04",null,null,"12\" spiral coupling","LSM-SC12"]
["6\"","ST-305-06",null,null,"14\" spiral coupling","LSM-SC14",null,null,"Manual Dampers"]
["7\"","ST-305-07",null,null,"16\" spiral coupling","LSM-SC16",null,null,"24x8","ST-182-2408"]
["8\"","ST-305-08",null,null,"Clutchers (for steel cable)","DUR-30351",null,null,"22x8","ST-182-2208"]
["10\"","ST-305-10",null,null,"Roll of steel braided cable","DUR-30202",null,null,"20x8","ST-182-2008"]
["12\"","ST-305-12",null,null,"4x12 spiral register","TRU-SU2A12X4",null,null,"18x8","ST-182-1808"]
["14\"","ST-305-14",null,null,"6x12 spiral register","TRU-SU2A12X6",null,null,"16x8","ST-182-1608"]
[null,null,null,null,null,null,null,null,"14x8","ST-182-1408"]
["Dryer Vent Box",null,null,null,"Makeup Air Damper Kit",null,null,null,"12x8","ST-182-1208"]
["(2x4 wall box)","ST-DVB350",null,null,"Broan 6\"","NU-MD6TU",null,null,"10X8","ST-182-1008"]
["(2x6 wall box)","ST-DVB425",null,null,"Broan 8\"","NU-MD8TU"]
[null,null,null,null,"Broan 10\"","NU-MD10TU",null,null,"Standard Lineset - 3/4\" Insul"]
["Spiral Pipe",null,null,null,null,null,null,null,"5/8\" x 3/8\" x 40'","LS-583840-12"]
["4\"","LSM-SP04",null,null,"Minisplit Lineset",null,null,null,"5/8\" x 3/8\" x 50'","LS-583850-12"]
["6\"","LSM-SP06",null,null,"3/8\" x1/4\" x 25'","LS-MS381425-12EZ",null,null,"3/4\" x 3/8\" x 40'","LS-343840-12"]
["7\"","LSM-SP07",null,null,"3/8\" x1/4\" x 50'","LS-MS381450-12EZ",null,null,"3/4\" x 3/8\" x 50'","LS-343850-12"]
["8\"","LSM-SP08",null,null,"1/2\" x 1/4\" x 25'","LS-MS121425-12EZ",null,null,"7/8\" x 3/8\" x 40'","LS-783840-12"]
["10\"","LSM-SP10",null,null,"1/2\" x 1/4\" x 50'","LS-MS121450-12EZ",null,null,"7/8\" x 3/8\" x 50'","LS-783850-12"]
["12\"","LSM-SP12",null,null,"5/8\" x 3/8\" x 25'","LS-MS583825-12EZ",null,null,"2\" Lineset Clamps","TP-41125"]
["14\"","LSM-SP14",null,null,"5/8\" x 3/8\" x 50'","LS-MS583850-12EZ"]
["16\"","LSM-SP16",null,null,"3/4\" x 3/8\" x 35'","LS-MS343835-12EZ"]
[null,null,null,null,"3/4\" x 3/8\" x 50'","LS-MS343850-12EZ"]

{"sheet":"Finish","index":1,"n_rows":199,"n_cols":11,"rows_kept":199,"cut":false,"hidden":false,"merged":[[184,4,184,6],[184,8,184,9],[77,4,77,6],[107,4,107,6],[107,8,107,9],[142,8,142,9],[143,4,143,6],[161,8,161,9],[68,8,68,9],[73,8,73,9],[28,8,28,10],[30,4,30,6],[34,8,34,10],[7,4,7,5],[7,8,7,9],[37,0,37,2],[37,4,37,6],[66,4,66,6],[21,8,21,10],[0,0,4,1],[0,2,0,10],[1,3,1,5],[1,6,1,7],[1,8,1,10],[2,3,2,10],[3,2,4,4],[3,6,3,7],[3,9,3,10],[4,6,4,7],[4,9,4,10],[15,4,15,6],[15,8,15,10],[25,0,25,2],[25,8,25,10],[23,4,23,6]]}
[{"$error":"#VALUE!"},null,"New Construction Finish - Costing Form"]
[null,null,"PO:",null,null,null,"Deliver On:"]
[null,null,"Notes:"]
[null,null,"Add following equipment previously purchased to delivery:",null,null,"Ticket #","Job PO",null,"Model","Serial #"]
[]
[]
[]
[null,null,"#",null,"Side Wall Registers",null,"#",null,"Exterior Exhaust Caps",null,"#"]
["OUTDOOR UNIT",null,null,null,"4x10","LI-10V10X4",null,null,"4\" Brown Exhaust","DE-HS4B"]
["OUTDOOR UNIT",null,null,null,"4x12","LI-10V12X4",null,null,"4\" White Exhaust","DE-HS4W"]
["OUTDOOR UNIT",null,null,null,"4x14","LI-10V14X4",null,null,"6\" White Exhaust","DE-HS6W"]
["AC Poles:","SPS-2/POLE",null,null,"6x10","LI-10V10X6",null,null,"6\" Brown Exhuast","DE-HS6B"]
["Pole End Cap","SPS-2/CAP",null,null,"6x12","LI-10V12X6",null,null,"8\" Exhaust"]
["Locking Caps:","CD2290",null,null,"6x14","LI-10V14X6",null,null,"10\" Exhaust"]
["6' UV Armor Flex - 3/4\"","P809-T03434"]
["6' UV Armor Flex - 7/8\"",null,null,null,"Floor Registers",null,null,null,"Exterior Intake Caps"]
["Clear Silicone","BO-370C",null,null,"4x10","LI-414X10",null,null,"6\" White Intake","DE-HSM6W"]
["White Silicone","BO-370W",null,null,"4x12","LI-414x12",null,null,"6\" Brown Intake","DE-HSM6B"]
["Thumb Gum:","P904-0303",null,null,"4x14","LI-414x14",null,null,"8\" Intake"]
["Finish Filter 16x25x4:","HW-FC100A1029",null,null,"6x10","LI-416x10",null,null,"10\" Intake"]
["Finish Filter 20x25x4:","HW-FC100A1037",null,null,"6x12","LI-416x12"]
["Finish Filter 24x25x4:","FILXUMC112425",null,null,"6x14","LI-416x14",null,null,"Toe Kick Registers"]
["Finish Filter 16x20x4:","HW-FC100A1003",null,null,null,null,null,null,"2x10","LI-41F2X10"]
["Finish Filter 20x20x4:","HW-FC100A1011",null,null,"Floor Return Grates",null,null,null,"2x12","LI-41F2X12"]
[null,null,null,null,"6x12","LI-356x12"]
["Return Air Grills",null,null,null,"6x14","LI-356x14",null,null,"Soffit Caps"]
["12x6","LI-19H12X6",null,null,"30x10","LI-3510x30",null,null,"Under-eve Vents","DE-EVE"]
["14x6","LI-19H14X6",null,null,"30x12","LI-3512x30"]
["24x6","LI-19H24X6",null,null,"14X14","LI-3514X14",null,null,"2x2 Supply Lay-In"]
["30x6","LI-19H30X6",null,null,null,null,null,null,"2x2x6\"","KR-1450F2306"]
["12x12","LI-19H12X12",null,null,"Condenser Pads",null,null,null,"2x2x8\"","KR-1450F2306"]
["30x10","LI-19H30X10",null,null,"6\" Adjust Pump-Ups","DV-HPR6-2P",null,null,"2x2x10\"","KR-1450F2310"]
["30x12","LI-19H30x12",null,null,"24X24","P143-E2424",null,null,"2x2x12\"","KR-1450F2312"]
["14x14","LI-19H14x14",null,null,"30X30","P143-E3030"]
["16x16","LI-19H16x16",null,null,"32X32","P143-E3232",null,null,"2x2 Return Lay-In (Perforated one piece)"]
["20x20","LI-19H20x20",null,null,"36X36","P143-E3636",null,null,"2x2x6\"","KR-6690F2306"]
[null,null,null,null,null,null,null,null,"2x2x8\"","KR-6690F2308"]
["THERMOSTATS",null,null,null,"Wall Brackets",null,null,null,"2x2x10\"","KR-6690F2310"]
["ECOBEE 6","EB-STATE6IBR-01",null,null,"MiniSplit Wall Bracket","              QKS-QSWB2000",null,null,"2x2x12\"","KR-6690F2312"]
["T6 PRO, 2H/1C PROGRAMMABLE","HW-TH6210U2001",null,null,"Wall Bracket: ",null,null,null,"2x2x14\"","KR-6690F2314"]
["BRYANT SMART STAT","TSTATBBEWF-01",null,null,"36\"","DV-ACB36"]
["EVOLUTION CONTROL","SYSTXBBECC01-C",null,null,"42\"","DV-ACB42"]
["EVOLUTION SMART SENSOR","SYSTXZNSMS01",null,null,"48\"","DV-ACB48"]
["EVOLUTION ZONE BOARD","SYSTXBB4ZC01",null,null,"Minisplit Stand","QKS-QSMA1201"]
["24V Interface Kit 230v","KSAIC0501230",null,null,"18X38 Pad for Stand","P143-E1838"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2x2 Metal Return Box (for grid celing)",null,null,null,"Additional Items"]
["2x2 Supply Lay-in",null,null,null,"2x2 box (not insulated)",null,null,null,"Roll 1/8\"steel braided cable"]
["4\" neck",null,null,null,"2x2 box (insulated)",null,null,null,"Cable Locks for 1/8\" (Clutchers)"]
["6\" neck",null,null,null,"2x2 plastic egg crate",null,null,null,"10’- Unistrut-heavy guage "]
["7\" neck",null,null,null,null,null,null,null,"1 box 3/8th nuts"]
["8\" neck",null,null,null,null,null,null,null,"1 box 3/8ths washer"]
["10\" neck",null,null,null,null,null,null,null,"10’ - 3/8th threaded rod"]
["12\" neck"]
[]
["Radial Dampers for Lay-Ins"]
["PRN1006 - 6\""]
["PRN1008 - 8\""]
["PRN1010 - 10\""]
["PRN1012 - 12\""]
["PRN1014 - 14\""]

{"sheet":"Labor","index":2,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[[6,1,6,2],[50,1,50,2],[4,1,4,2]]}
[]
[null,null,"Sharif Riggen"]
[null,null,{"$f":"TODAY()","v":"2026-07-06"}]
[]
[null,"Residential Labor Estimate   "]
[]
[null,"For:"]
[null,"Systems on Job:",1]
[null,"Rough-In Labor:"]
[null,null,"Labor"]
[null,"Lower Level Left System:"]
[null," - Delivery/Cut-Out/Equip. Set/Config. Duct"]
[null," - Return Ductwork"]
[null," - Supply Ductwork"]
[null," - Venting (fans, dryer vent, hood vent)"]
[null," - Flues and Lineset"]
[]
[null,{"$f":"B11","v":"Lower Level Left System:"},{"$f":"SUM(C12:C16)","v":0}]
[]
[null,{"$f":"IF($C$8*1>=2,\"Lower Level Right System:\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=2,\" - Delivery/Cut-Out/Equip. Set/Config. Duct\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=2,\" - Return Ductwork\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=2,\" - Supply Ductwork\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=2,\" - Venting (fans) \",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=2,\" - Flues and Lineset\",\"\")","v":""}]
[]
[null,{"$f":"B20","v":""},{"$f":"IF($C$8*1>=2,SUM(C21:C25),0)","v":0}]
[]
[null,{"$f":"IF($C$8*1>=3,\"2nd Floor System:\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=3,\" - Delivery/Cut-Out/Equip. Set/Config. Duct\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=3,\" - Return Ductwork\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=3,\" - Supply Ductwork\",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=3,\" - Venting (fans to soffits) \",\"\")","v":""}]
[null,{"$f":"IF($C$8*1>=3,\" - Flues and Lineset\",\"\")","v":""}]
[]
[null,{"$f":"B29","v":""},{"$f":"IF($C$8*1>=3,SUM(C30:C34),0)","v":0}]
[]
[null,"Rough-In Labor:",{"$f":"SUM(C18+C27+C36)","v":0}]
[]
[null,"Finish Labor:  "]
[]
[null," - Grills/Registers/Fan Covers/Hood Vent"]
[null," - All low voltage wiring/job cleanup"]
[null,{"$f":"CHOOSE($C$8*1,\" - AC installation\",\" - AC installation (2 AC’s)\",\" - AC installation (3 AC’s)\")","v":" - AC installation"}]
[null," - Exterior Caps "]
[]
[null,"Finish Labor:",{"$f":"SUM(C41:C45)","v":0}]
[]
[null,"Total Job Labor:",{"$f":"SUM(C47+C38)","v":0}]
[]
[null,"Additional Costs"]
[null,"Fans"]
[null,"Fab Drain Pan"]
[null,"Fab Ductwork/Fittings"]
[null,"Subtotal:",{"$f":"SUM(C52:C54)","v":0}]
[null,"Total:",{"$f":"C55*(1+'R Estimate'!J178)","v":0}]

{"sheet":"R Estimate","index":3,"n_rows":179,"n_cols":11,"rows_kept":179,"cut":false,"hidden":false,"merged":[[176,4,176,5],[177,4,177,5],[178,4,179,5],[178,6,179,6],[174,0,174,1],[175,0,175,1],[176,0,176,1],[170,4,170,5],[170,0,170,1],[170,8,170,9],[115,4,115,5],[119,4,119,5],[133,4,133,5],[143,4,143,5],[146,8,146,9],[153,4,153,5],[159,0,159,1],[156,8,156,9],[158,4,158,5],[155,0,155,1],[100,4,100,5],[91,4,91,5],[81,4,81,5],[85,8,85,9],[92,8,92,9],[74,4,74,5],[69,8,69,9],[69,4,69,5],[74,8,74,9],[80,8,80,9],[7,4,7,5],[20,4,20,5],[13,8,13,9],[7,8,7,9],[24,8,24,9],[28,8,28,9],[111,8,111,9],[54,8,54,9],[59,8,59,9],[64,8,64,9],[98,8,98,9],[105,8,105,9],[31,0,31,1],[58,0,58,1],[65,0,65,1],[146,0,146,1],[123,0,123,1],[133,0,133,1],[106,0,106,1],[112,0,112,1],[113,0,113,1],[88,0,88,1],[97,0,97,1],[68,0,68,1],[58,4,58,5],[35,4,35,5],[50,4,50,5],[4,9,4,10],[6,0,6,1],[0,0,4,1],[0,2,0,10],[1,3,1,5],[1,6,1,7],[1,8,1,10],[2,3,2,10],[3,2,4,4],[3,6,3,7],[3,9,3,10],[4,6,4,7],[23,0,23,1]]}
[{"$error":"#VALUE!"},null,"New Construction Rough In - Costing Form"]
[null,null,"PO:",null,null,null,"Deliver On:"]
[null,null,"Notes:"]
[null,null,"Add following equipment previously purchased to delivery:",null,null,"Ticket #","Job PO",null,"Model","Serial #"]
[]
[]
[null,null,"#"]
["Furnace",null,{"$f":"IF('Rough In'!B8=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B8,Furnace!$C:$C,Furnace!$I:$I),\"\"))","v":""},null,"Transitional Takeoffs",null,"#",null,"Stick-On Flat 90’s ",null,"#"]
["Coil",null,{"$f":"IF('Rough In'!B9=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B9,Coil!$C:$C,Coil!$H:$H),\"\"))","v":""},null,"24x12","ST-1203-2412",{"$f":"'Rough In'!G9*'R Cost'!F8","v":0},null,"8\"","ST-306-08",{"$f":"IFERROR('Rough In'!K9*_xlfn.XLOOKUP($J9,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Air Handler",null,{"$f":"IF('Rough In'!B10=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B10,'Air Handler'!$C:$C,'Air Handler'!$J:$J),\"\"))","v":""},null,"24x10","ST-1203-2410",{"$f":"'Rough In'!G10*'R Cost'!F9","v":0},null,"7\"","ST-306-07",{"$f":"IFERROR('Rough In'!K10*_xlfn.XLOOKUP($J10,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Geothermal",null,{"$f":"IF('Rough In'!B11=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B11,Geothermal!$C:$C,Geothermal!$I:$I),\"\"))","v":""},null,"20x10","ST-1203-2010",{"$f":"'Rough In'!G11*'R Cost'!F10","v":0},null,"6\"","ST-306-06",{"$f":"IFERROR('Rough In'!K11*_xlfn.XLOOKUP($J11,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Heater Pack","",{"$f":"IF('Rough In'!B12=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B12,'Heater Pack'!$C:$C,'Heater Pack'!$F:$F),\"\"))","v":""},null,"24x8","ST-1203-2408",{"$f":"'Rough In'!G12*'R Cost'!F11","v":0},null,"4\"","ST-306-04",{"$f":"IFERROR('Rough In'!K12*_xlfn.XLOOKUP($J12,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Bottom Box",{"$f":"_xlfn.LET(_xlpm.furn,B8,_xlpm.ah,B10,_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.aw,IFERROR(_xlfn.XLOOKUP(_xlpm.ah,'Air Handler'!$C:$C,'Air Handler'!$F:$F),\"\"),IF(_xlpm.furn<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.fw,Misc!$B$4:$B$7,Misc!$E$4:$E$7),\"width not matched\"),IF(_xlpm.ah<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.aw,Misc!$B$9:$B$12,Misc!$E$9:$E$12),\"width not matched\"),\"\")))","v":""},{"$f":"IF('Rough In'!B13=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B13,Misc!$E:$E,Misc!$F:$F),\"\"))","v":""},null,"22x8","ST-1203-2208",{"$f":"'Rough In'!G13*'R Cost'!F12","v":0}]
["Plenum",{"$f":"_xlfn.LET(_xlpm.coil,B9,_xlpm.furn,B8,_xlpm.ah,B10,_xlpm.cw,IFERROR(_xlfn.XLOOKUP(_xlpm.coil,Coil!$C:$C,Coil!$F:$F),\"\"),_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.aw,IFERROR(_xlfn.XLOOKUP(_xlpm.ah,'Air Handler'!$C:$C,'Air Handler'!$F:$F),\"\"),IF(_xlpm.coil<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.cw,Misc!$B$26:$B$29,Misc!$E$26:$E$29),\"width not matched\"),IF(_xlpm.furn<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.fw,Misc!$B$16:$B$19,Misc!$E$16:$E$19),\"width not matched\"),IF(_xlpm.ah<>\"\",IFERROR(_xlfn.XLOOKUP(_xlpm.aw,Misc!$B$21:$B$24,Misc!$E$21:$E$24),\"width not matched\"),\"\"))))","v":""},{"$f":"IF('Rough In'!B14=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B14,Misc!$E:$E,Misc!$F:$F),\"\"))","v":""},null,"20x8","ST-1203-2008",{"$f":"'Rough In'!G14*'R Cost'!F13","v":0},null,"Round Pipe (5' Sections) 30GA "]
["Coil Adapter",{"$f":"_xlfn.LET(_xlpm.furn,B8,_xlpm.coil,B9,_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.cw,IFERROR(_xlfn.XLOOKUP(_xlpm.coil,Coil!$C:$C,Coil!$F:$F),\"\"),IF(OR(_xlpm.furn=\"\",_xlpm.coil=\"\",_xlpm.fw=\"\",_xlpm.cw=\"\"),\"\",IF(_xlpm.fw=_xlpm.cw,\"\",_xlfn.LET(_xlpm.lo,IF(_xlpm.fw<=_xlpm.cw,_xlpm.fw,_xlpm.cw),_xlpm.hi,IF(_xlpm.fw<=_xlpm.cw,_xlpm.cw,_xlpm.fw),IFERROR(_xlfn.XLOOKUP(1,(Misc!$B$33:$B$45=_xlpm.lo)*(Misc!$C$33:$C$45=_xlpm.hi),Misc!$E$33:$E$45),\"no adapter found\")))))","v":""},{"$f":"IF('Rough In'!B15=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B15,Misc!$E:$E,Misc!$F:$F),\"\"))","v":""},null,"18x8","ST-1203-1808",{"$f":"'Rough In'!G15*'R Cost'!F14","v":0},null,"3\"","ST-RDP-053003",{"$f":"IF('Rough In'!K15=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K15,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I14,\"\"))","v":0}]
["Coil Spacer",{"$f":"IF(D16<>TRUE,\"\",_xlfn.LET(_xlpm.furn,B8,_xlpm.coil,B9,_xlpm.fw,IFERROR(_xlfn.XLOOKUP(_xlpm.furn,Furnace!$C:$C,Furnace!$H:$H),\"\"),_xlpm.cw,IFERROR(_xlfn.XLOOKUP(_xlpm.coil,Coil!$C:$C,Coil!$F:$F),\"\"),IF(OR(_xlpm.furn=\"\",_xlpm.coil=\"\",_xlpm.fw=\"\",_xlpm.cw=\"\"),\"\",IF(_xlpm.fw<>_xlpm.cw,\"N/A-widths differ\",IFERROR(_xlfn.XLOOKUP(1,(Misc!$B$33:$B$45=_xlpm.fw)*(Misc!$C$33:$C$45=_xlpm.fw),Misc!$E$33:$E$45),\"spacer not found\")))))","v":""},{"$f":"IF('Rough In'!B16=\"\",\"\",IFERROR(_xlfn.XLOOKUP('Rough In'!B16,Misc!$E:$E,Misc!$F:$F),\"\"))","v":""},null,"16x8","ST-1203-1608",{"$f":"'Rough In'!G16*'R Cost'!F15","v":0},null,"4\"","ST-RDP-053004",{"$f":"IF('Rough In'!K16=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K16,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I15,\"\"))","v":0}]
["Bricks","HO-619345",{"$f":"'Rough In'!C17*'R Cost'!C15","v":0},null,"14x8","ST-1203-1408",{"$f":"'Rough In'!G17*'R Cost'!F16","v":0},null,"6\"","ST-RDP-053006",{"$f":"IF('Rough In'!K17=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K17,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I16,\"\"))","v":0}]
["Adjustable Pump-Ups","DV-HPR6-2P",{"$f":"'Rough In'!C18*'R Cost'!C16","v":0},null,"12x8","ST-1203-1208",{"$f":"'Rough In'!G18*'R Cost'!F17","v":0},null,"7\"","ST-RDP-053007",{"$f":"IF('Rough In'!K18=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K18,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I17,\"\"))","v":0}]
["SMALL BYP. HUMIDIFIER","HUMCRSBP2412",{"$f":"'Rough In'!C19*'R Cost'!C17","v":0},null,"10x8","ST-1203-1008",{"$f":"'Rough In'!G19*'R Cost'!F18","v":0},null,"8\"","ST-RDP-053008",{"$f":"IF('Rough In'!K19=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K19,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I18,\"\"))","v":0}]
["LARGE BYP. HUMIDIFIER","HUMCRLBP2417",{"$f":"'Rough In'!C20*'R Cost'!C18","v":0},null,null,null,null,null,"10\"","ST-RDP-053010",{"$f":"IF('Rough In'!K20=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K20,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I19,\"\"))","v":0}]
[null,"Equipment Subtotal:",{"$f":"SUM(C8:C20)","v":0},null,"Duct - 5' Sections",null,null,null,"12\"","ST-RDP-053012",{"$f":"IF('Rough In'!K21=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K21,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I20,\"\"))","v":0}]
[null,null,null,null,"25x10","ST-DT-602510",{"$f":"IF('Rough In'!G22=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G22,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F22,\"\"))","v":0},null,"14\"","ST-RDP-052614",{"$f":"IF('Rough In'!K22=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K22,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I21,\"\"))","v":0}]
[null,null,null,null,"24x12","ST-DT-602412",{"$f":"IF('Rough In'!G23=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G23,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F23,\"\"))","v":0},null,"16\"","ST-RDP-052616",{"$f":"IF('Rough In'!K23=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!K23,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!I22,\"\"))","v":0}]
["Media Cabinets",null,null,null,"24x10","ST-DT-602410",{"$f":"IF('Rough In'!G24=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G24,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F24,\"\"))","v":0}]
["Core Media Cabinet - 16X25","EZXCABCR1016",{"$f":"'Rough In'!C23*'R Cost'!C21","v":0},null,"20x10","ST-DT-602010",{"$f":"IF('Rough In'!G25=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G25,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F25,\"\"))","v":0},null,"Boot Frames"]
["Core Media Cabinet - 20X25","EZXCABCR1320",{"$f":"'Rough In'!C24*'R Cost'!C22","v":0},null,"24x8","ST-DT-602408",{"$f":"IF('Rough In'!G26=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G26,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F26,\"\"))","v":0},null,"H-4 Boot Frame","PT-H4",{"$f":"IFERROR('Rough In'!K26*_xlfn.XLOOKUP($J26,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Media Cabinet - 24X25","FILCABXL0024",{"$f":"'Rough In'!C25*'R Cost'!C23","v":0},null,"22x8","ST-DT-602208",{"$f":"IF('Rough In'!G27=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G27,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F27,\"\"))","v":0},null,"H-6 Boot Frame","PT-H6",{"$f":"IFERROR('Rough In'!K27*_xlfn.XLOOKUP($J27,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Honeywell Media Cab 16x20","HW-F100F1620",{"$f":"'Rough In'!C26*'R Cost'!C24","v":0},null,"20x8","ST-DT-602008",{"$f":"IF('Rough In'!G28=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G28,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F28,\"\"))","v":0}]
["Honeywell Media Cab 20x20","HW-F100F2020",{"$f":"'Rough In'!C27*'R Cost'!C25","v":0},null,"18x8","ST-DT-601808",{"$f":"IF('Rough In'!G29=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G29,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F29,\"\"))","v":0},null,"Boots"]
["Honeywell Media Cab 20x25","HW-F100F2025",{"$f":"'Rough In'!C28*'R Cost'!C26","v":0},null,"16x8","ST-DT-601608",{"$f":"IF('Rough In'!G30=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G30,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F30,\"\"))","v":0},null,"4x10x4 end boot","ST-1373-041004",{"$f":"IFERROR('Rough In'!K30*_xlfn.XLOOKUP($J30,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,"14x8","ST-DT-601408",{"$f":"IF('Rough In'!G31=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G31,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F31,\"\"))","v":0},null,"4x10x4 L boot","ST-1374-041004",{"$f":"IFERROR('Rough In'!K31*_xlfn.XLOOKUP($J31,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Standard Items",null,null,null,"12x8","ST-DT-601208",{"$f":"IF('Rough In'!G32=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G32,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F32,\"\"))","v":0},null,"4x10x4 straight boot","ST-1370-041004",{"$f":"IFERROR('Rough In'!K32*_xlfn.XLOOKUP($J32,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Tub 3/4\" screws","MA-HW8X3/4ZT",{"$f":"'Rough In'!C31*'R Cost'!C29","v":41.14},null,"10x8","ST-DT-601008",{"$f":"IF('Rough In'!G33=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G33,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F33,\"\"))","v":0},null,"4x10x6 L boot","ST-1374-041006",{"$f":"IFERROR('Rough In'!K33*_xlfn.XLOOKUP($J33,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Tub 1/2\" screws","MA-HW8X1/2ZT",{"$f":"'Rough In'!C32*'R Cost'!C30","v":31.64},null,"8x8","ST-DT-600808",{"$f":"IF('Rough In'!G34=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G34,\"'\",\"\"),\"\"\"\",\"\")/5*'R Cost'!F34,\"\"))","v":0},null,"4x10x6 end boot","ST-1373-041006",{"$f":"IFERROR('Rough In'!K34*_xlfn.XLOOKUP($J34,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Basset Hangers","BP-A125",{"$f":"'Rough In'!C33*'R Cost'!C31","v":0},null,null,null,null,null,"4x10x6 straight boot","ST-1370-041006",{"$f":"IFERROR('Rough In'!K35*_xlfn.XLOOKUP($J35,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["5' Drives","ST-213-60",{"$f":"'Rough In'!C34*'R Cost'!C32","v":0},null,"End Caps",null,null,null,"4x12x6 end boot","ST-1373-041206",{"$f":"IFERROR('Rough In'!K36*_xlfn.XLOOKUP($J36,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["5' S-Locks","ST-209-60",{"$f":"'Rough In'!C35*'R Cost'!C33","v":0},null,"25x12","ST-1210-3012",{"$f":"'Rough In'!G37*'R Cost'!F37","v":0},null,"4x12x6 L boot","ST-1374-041206",{"$f":"IFERROR('Rough In'!K37*_xlfn.XLOOKUP($J37,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Rolls of 3\" tape","DT-322F3",{"$f":"'Rough In'!C36*'R Cost'!C34","v":0},null,"24x12","ST-1210-2412",{"$f":"'Rough In'!G38*'R Cost'!F38","v":0},null,"4x12x6 straight boot","ST-1370-041206",{"$f":"IFERROR('Rough In'!K38*_xlfn.XLOOKUP($J38,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Rolls of mastic tape","AFG-1404-181",{"$f":"'Rough In'!C37*'R Cost'!C35","v":0},null,"24x10","ST-1210-2410",{"$f":"'Rough In'!G39*'R Cost'!F39","v":0},null,"4x12x7 L boot","ST-1374-041207",{"$f":"IFERROR('Rough In'!K39*_xlfn.XLOOKUP($J39,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Duct Sealant Gallon Pail","HF-SDSWB",{"$f":"'Rough In'!C38*'R Cost'!C36","v":0},null,"20x10","ST-1210-2010",{"$f":"'Rough In'!G40*'R Cost'!F40","v":0},null,"4x12x7 straight boot","ST-1370-041207",{"$f":"IFERROR('Rough In'!K40*_xlfn.XLOOKUP($J40,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["2\" brushes","DV-B503",{"$f":"'Rough In'!C39*'R Cost'!C37","v":0},null,"24x8","ST-1210-2408",{"$f":"'Rough In'!G41*'R Cost'!F41","v":0},null,"4x12x7 end boot","ST-1373-041207",{"$f":"IFERROR('Rough In'!K41*_xlfn.XLOOKUP($J41,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Tubes of Clear Silicone","BO-370C",{"$f":"'Rough In'!C40*'R Cost'!C38","v":0},null,"22x8","ST-1210-2208",{"$f":"'Rough In'!G42*'R Cost'!F42","v":0},null,"6x10x7 end-boot","ST-1373-061007",{"$f":"IFERROR('Rough In'!K42*_xlfn.XLOOKUP($J42,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["10\" Section - 3/4\" PVC","BR-6106",{"$f":"('Rough In'!C41*10)*'R Cost'!C39","v":101},null,"20x8","ST-1210-2008",{"$f":"'Rough In'!G43*'R Cost'!F43","v":0},null,"6x10x7 L boot","ST-1374-061007",{"$f":"IFERROR('Rough In'!K43*_xlfn.XLOOKUP($J43,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["EZ-Trap Clear PVC Trap ","RC-83114",{"$f":"'Rough In'!C42*'R Cost'!C40","v":0},null,"18x8","ST-1210-1808",{"$f":"'Rough In'!G44*'R Cost'!F44","v":0},null,"6x10x7 straight boot","ST-1370-061007",{"$f":"IFERROR('Rough In'!K44*_xlfn.XLOOKUP($J44,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["3/4\" PVC threaded male","BR-0342",{"$f":"'Rough In'!C43*'R Cost'!C41","v":0.51},null,"16x8","ST-1210-1608",{"$f":"'Rough In'!G45*'R Cost'!F45","v":0},null,"6x12x7 end boot","ST-1373-061207",{"$f":"IFERROR('Rough In'!K45*_xlfn.XLOOKUP($J45,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["3/4\" PVC threaded female ","BR-0341",{"$f":"'Rough In'!C44*'R Cost'!C42","v":0},null,"14x8","ST-1210-1408",{"$f":"'Rough In'!G46*'R Cost'!F46","v":0},null,"6x12x7 L boot","ST-1374-061207",{"$f":"IFERROR('Rough In'!K46*_xlfn.XLOOKUP($J46,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["3/4\" PVC 90's","BR-0344",{"$f":"'Rough In'!C45*'R Cost'!C43","v":3.3600000000000003},null,"12x8","ST-1210-1208",{"$f":"'Rough In'!G47*'R Cost'!F47","v":0},null,"6x12x7 straight boot","ST-1370-061207",{"$f":"IFERROR('Rough In'!K47*_xlfn.XLOOKUP($J47,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["3/4\" PVC T's","BR-0349",{"$f":"'Rough In'!C46*'R Cost'!C44","v":1.42},null,"10x8","ST-1210-1008",{"$f":"'Rough In'!G48*'R Cost'!F48","v":0},null,"6x12x8 straight boot","ST-1370-061208",{"$f":"IFERROR('Rough In'!K48*_xlfn.XLOOKUP($J48,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["3/4\" PVC 45’s","BR-0346",{"$f":"'Rough In'!C47*'R Cost'!C45","v":5.16},null,"8x8","ST-1210-0808",{"$f":"'Rough In'!G49*'R Cost'!F49","v":0},null,"6x12x8 end boot","ST-1373-061208",{"$f":"IFERROR('Rough In'!K49*_xlfn.XLOOKUP($J49,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Glue","DV-510",{"$f":"'Rough In'!C48*'R Cost'!C46","v":14.72},null,null,null,null,null,"6x12x8 L boot","ST-1374-061208",{"$f":"IFERROR('Rough In'!K50*_xlfn.XLOOKUP($J50,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Cleaner","DV-PPC16",{"$f":"'Rough In'!C49*'R Cost'!C47","v":14.23},null,"Supply Duct Reducers",null,null,null,"6x14x8 L Boot","ST-1374-061408",{"$f":"IFERROR('Rough In'!K51*_xlfn.XLOOKUP($J51,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Rubber 3\"x3\" pads","DV-MP3E",{"$f":"'Rough In'!C50*'R Cost'!C48","v":11.45},null,"2\" reducer for 8\" duct","ST-187-02",{"$f":"'Rough In'!G52*'R Cost'!F52","v":0},null,"6x14x8 Straight Boot","ST-1370-061408",{"$f":"IFERROR('Rough In'!K52*_xlfn.XLOOKUP($J52,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Bag 36\" Panduits","DV-7P36",{"$f":"'Rough In'!C51*'R Cost'!C49","v":0},null,"4\" reducer for 8\" duct","ST-187-04",{"$f":"'Rough In'!G53*'R Cost'!F53","v":0},null," 6X14X6 end boot","ST-1373-061408",{"$f":"IFERROR('Rough In'!K53*_xlfn.XLOOKUP($J53,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Foil Back Fiberglass-2\" 75' ","KF-E24875FSKLKDW",{"$f":"'Rough In'!C52*'R Cost'!C50","v":0},null,"6\" reducer for 8\" duct","ST-187-06",{"$f":"'Rough In'!G54*'R Cost'!F54","v":0}]
["Lineset Clips - Reg. Size ","TP-41125 (5 PER PACK)",{"$f":"'Rough In'!C53*'R Cost'!C51","v":6.8999999999999995},null,"8\" reducer for 8\" duct","ST-187-08",{"$f":"'Rough In'!G55*'R Cost'!F55","v":0},null,"Oval (100\" sections)"]
["Roll of 3\" Webbing","DV-710102",{"$f":"'Rough In'!C54*'R Cost'!C52","v":0},null,"24x12 to 24x10 reduc.","ST-1251-24122410",{"$f":"'Rough In'!G56*'R Cost'!F56","v":0},null,"6\"","ST-4100-10006",{"$f":"IFERROR('Rough In'!K56*_xlfn.XLOOKUP($J56,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Aquaguard Float Switch","AG-1200",{"$f":"'Rough In'!C55*'R Cost'!C53","v":0},null,"24x10 to 24x8 reduc.","ST-1251-24102408",{"$f":"'Rough In'!G57*'R Cost'!F57","v":0},null,"7\"","ST-4100-10007",{"$f":"IFERROR('Rough In'!K57*_xlfn.XLOOKUP($J57,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,null,null,null,null,"8\"","ST-4100-10008",{"$f":"IFERROR('Rough In'!K58*_xlfn.XLOOKUP($J58,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Temp Filters - Pleated 1\"",null,null,null,"Round Reducers"]
["16x25x1 temp filter","FI-16X25X1",{"$f":"'Rough In'!C58*'R Cost'!C56","v":0},null,"4\"-3\"","ST-133-040326",{"$f":"'Rough In'!G60*'R Cost'!F60","v":0},null,"Oval to Round L-Boot"]
["20x25x1 temp filter","FI-20X25X1",{"$f":"IFERROR('Rough In'!C59*_xlfn.XLOOKUP($B61,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6\"-4\"","ST-133-060426",{"$f":"'Rough In'!G61*'R Cost'!F61","v":0},null,"6\" oval to round L-Boot","ST-4244NC-06",{"$f":"IFERROR('Rough In'!K61*_xlfn.XLOOKUP($J61,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["24x25x1 temp filter","FI-24X25X1",{"$f":"IFERROR(N('Rough In'!C60)*_xlfn.XLOOKUP($B62,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"8\"-6\"","ST-133-080626",{"$f":"'Rough In'!G62*'R Cost'!F62","v":0},null,"7\" oval to round L-Boot","ST-4244NC-07",{"$f":"IFERROR('Rough In'!K62*_xlfn.XLOOKUP($J62,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["16x20x1 temp filter","FI-16X20X1",{"$f":"IFERROR(N('Rough In'!C61)*_xlfn.XLOOKUP($B63,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"10\"-8\"","ST-133-100826",{"$f":"'Rough In'!G63*'R Cost'!F63","v":0},null,"8\" oval to round L-Boot","ST-4244NC-08",{"$f":"IFERROR('Rough In'!K63*_xlfn.XLOOKUP($J63,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["20x20x1 temp filter","FI-20X20X1",{"$f":"IFERROR(N('Rough In'!C62)*_xlfn.XLOOKUP($B64,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"12\"-10\"","ST-133-121026",{"$f":"'Rough In'!G64*'R Cost'!F64","v":0}]
[null,null,null,null,"14\"-10\"","ST-133-141026",{"$f":"'Rough In'!G65*'R Cost'!F65","v":0},null,"Oval to Round End Boot"]
["Drywall Edging",null,null,null,"14\"-12\"","ST-133-141226",{"$f":"'Rough In'!G66*'R Cost'!F66","v":0},null,"6\" oval-round end boot","ST-4247NC-0606",{"$f":"IFERROR('Rough In'!K66*_xlfn.XLOOKUP($J66,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["5' sections","ST-210-60",{"$f":"IF('Rough In'!C65=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C65,\"'\",\"\"),\"\"\"\",\"\")/5*_xlfn.XLOOKUP($B67,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"16\"-12\"","ST-133-161226",{"$f":"'Rough In'!G67*'R Cost'!F67","v":0},null,"7\" oval-round end boot","ST-4247NC-0707",{"$f":"IFERROR('Rough In'!K67*_xlfn.XLOOKUP($J67,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,"16\"-14\"","ST-133-161426",{"$f":"'Rough In'!G68*'R Cost'!F68","v":0},null,"8\" oval-round end boot","ST-4247NC-0808",{"$f":"IFERROR('Rough In'!K68*_xlfn.XLOOKUP($J68,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Duct Fittings"]
["10x8 SW 90","ST-1240-1008",{"$f":"IFERROR('Rough In'!C68*_xlfn.XLOOKUP($B70,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Y's",null,null,null,"Oval-Round Straight Boot"]
["10x8 BW 90","ST-1246-1008",{"$f":"IFERROR('Rough In'!C69*_xlfn.XLOOKUP($B71,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6X4X4 WITH REDUCER","ST-324-060404",{"$f":"'Rough In'!G71*'R Cost'!F71","v":0},null,"6\" oval-round straight boot","ST-4248NC-0606",{"$f":"IFERROR('Rough In'!K71*_xlfn.XLOOKUP($J71,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["12x8 SW 90","ST-1240-1208",{"$f":"IFERROR('Rough In'!C70*_xlfn.XLOOKUP($B72,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"7x5x3 WITH REDUCER","ST-324-070503",{"$f":"'Rough In'!G72*'R Cost'!F72","v":0},null,"7\" oval-round straight boot","ST-4248NC-0707",{"$f":"IFERROR('Rough In'!K72*_xlfn.XLOOKUP($J72,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["12x8 BW 90","ST-1246-1208",{"$f":"IFERROR('Rough In'!C71*_xlfn.XLOOKUP($B73,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"8X7X6 WITH REDUCER","ST-324-080706",{"$f":"'Rough In'!G73*'R Cost'!F73","v":0},null,"8\" oval-round straight boot","ST-4248NC-0808",{"$f":"IFERROR('Rough In'!K73*_xlfn.XLOOKUP($J73,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["14x8 SW 90","ST-1240-1408",{"$f":"IFERROR('Rough In'!C72*_xlfn.XLOOKUP($B74,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
["14x8 BW 90","ST-1246-1408",{"$f":"IFERROR('Rough In'!C73*_xlfn.XLOOKUP($B75,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"T's",null,null,null,"Oval Stackhead w/wings"]
["16x8 SW 90","ST-1240-1608",{"$f":"IFERROR('Rough In'!C74*_xlfn.XLOOKUP($B76,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"4x4x4","ST-219-040404",{"$f":"'Rough In'!G76*'R Cost'!F76","v":0},null,"6\" oval stack head w/4x10","ST-4235-0941006",{"$f":"IFERROR('Rough In'!K76*_xlfn.XLOOKUP($J76,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["16x8 BW 90","ST-1246-1608",{"$f":"IFERROR('Rough In'!C75*_xlfn.XLOOKUP($B77,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6x4x4W/reducers","ST-219-060606 ",{"$f":"'Rough In'!G77*'R Cost'!F77","v":0},null,"7” oval stackhead w/4x12","ST-4235-0941207",{"$f":"IFERROR('Rough In'!K77*_xlfn.XLOOKUP($J77,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["18x8 SW 90","ST-1240-1808",{"$f":"IFERROR('Rough In'!C76*_xlfn.XLOOKUP($B78,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6x6x6","ST-219-060606",{"$f":"'Rough In'!G78*'R Cost'!F78","v":0},null,"7” oval stackhead w/6x12","ST-4235-0961207",{"$f":"IFERROR('Rough In'!K78*_xlfn.XLOOKUP($J78,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["18x8 BW 90","ST-1246-1808",{"$f":"IFERROR('Rough In'!C77*_xlfn.XLOOKUP($B79,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"7x7x7","ST-219-070707",{"$f":"'Rough In'!G79*'R Cost'!F79","v":0},null,"8\" oval stackhead w/6x14","ST-4235-0961408",{"$f":"IFERROR('Rough In'!K79*_xlfn.XLOOKUP($J79,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["20x8 SW 90","ST-1240-2008",{"$f":"IFERROR('Rough In'!C78*_xlfn.XLOOKUP($B80,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"18x16x16 W/reducers","ST-219-080808 ",{"$f":"'Rough In'!G80*'R Cost'!F80","v":0}]
["20x8 BW 90","ST-1246-2008",{"$f":"IFERROR('Rough In'!C79*_xlfn.XLOOKUP($B81,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"Stack (100\" sections)"]
["22x8 SW 90","ST-1240-2208",{"$f":"IFERROR('Rough In'!C80*_xlfn.XLOOKUP($B82,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Short Collars w/Crimp",null,null,null,"3.25x10","ST-WSBL-1000310",{"$f":"IFERROR('Rough In'!K82*_xlfn.XLOOKUP($J82,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["22x8 BW 90","ST-1246-2208",{"$f":"IFERROR('Rough In'!C81*_xlfn.XLOOKUP($B83,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"4\"","ST-172-04",{"$f":"'Rough In'!G83*'R Cost'!F83","v":0},null,"3.25x12","ST-WSBL-1000312",{"$f":"IFERROR('Rough In'!K83*_xlfn.XLOOKUP($J83,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["24x8 SW 90","ST-1240-2408",{"$f":"IFERROR('Rough In'!C82*_xlfn.XLOOKUP($B84,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6\"","ST-172-06",{"$f":"'Rough In'!G84*'R Cost'!F84","v":0},null,"3.25x14","ST-WSBL-1000314",{"$f":"IFERROR('Rough In'!K84*_xlfn.XLOOKUP($J84,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["24x8 BW 90","ST-1246-2408",{"$f":"IFERROR('Rough In'!C83*_xlfn.XLOOKUP($B85,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"7\"","ST-172-07",{"$f":"'Rough In'!G85*'R Cost'!F85","v":0}]
["24x10 SW 90","ST-1240-2410",{"$f":"IFERROR('Rough In'!C84*_xlfn.XLOOKUP($B86,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"8\"","ST-172-08",{"$f":"'Rough In'!G86*'R Cost'!F86","v":0},null,"Stack to Round L-Boot"]
["24x10 BW 90","ST-1246-2410",{"$f":"IFERROR('Rough In'!C85*_xlfn.XLOOKUP($B87,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"10\"","ST-172-10",{"$f":"'Rough In'!G87*'R Cost'!F87","v":0},null,"3x10x6","ST-1218-031006",{"$f":"IFERROR('Rough In'!K87*_xlfn.XLOOKUP($J87,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,"12\"","ST-172-12",{"$f":"'Rough In'!G88*'R Cost'!F88","v":0},null," 3x10x7","ST-1218-031007",{"$f":"IFERROR('Rough In'!K88*_xlfn.XLOOKUP($J88,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["End Caps",null,null,null,"14\"","ST-172-14",{"$f":"'Rough In'!G89*'R Cost'!F89","v":0},null,"3x12x7","ST-1218-031207",{"$f":"IFERROR('Rough In'!K89*_xlfn.XLOOKUP($J89,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["6\"","ST-152-06",{"$f":"IFERROR('Rough In'!C88*_xlfn.XLOOKUP($B90,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"16\"","ST-172-16",{"$f":"'Rough In'!G90*'R Cost'!F90","v":0},null,"  3x12x8","ST-1218-031208",{"$f":"IFERROR('Rough In'!K90*_xlfn.XLOOKUP($J90,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["7\"","ST-152-07",{"$f":"IFERROR('Rough In'!C89*_xlfn.XLOOKUP($B91,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"3X14X8","ST-1218-031408",{"$f":"IFERROR('Rough In'!K91*_xlfn.XLOOKUP($J91,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["8\"","ST-152-08",{"$f":"IFERROR('Rough In'!C90*_xlfn.XLOOKUP($B92,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Short Collars - No Crimp"]
["10\"","ST-152-10",{"$f":"IFERROR('Rough In'!C91*_xlfn.XLOOKUP($B93,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"4\"","ST-171-04",{"$f":"'Rough In'!G93*'R Cost'!F93","v":0},null,"Stack to Round End Boots"]
["12\"","ST-152-12",{"$f":"IFERROR('Rough In'!C92*_xlfn.XLOOKUP($B94,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6\"","ST-171-06",{"$f":"'Rough In'!G94*'R Cost'!F94","v":0},null,"3x10x6","ST-1219-031006",{"$f":"IFERROR('Rough In'!K94*_xlfn.XLOOKUP($J94,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["14\"","ST-152-14",{"$f":"IFERROR('Rough In'!C93*_xlfn.XLOOKUP($B95,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"7\"","ST-171-07",{"$f":"'Rough In'!G95*'R Cost'!F95","v":0},null,"3X12X6","ST-1219-031206",{"$f":"IFERROR('Rough In'!K95*_xlfn.XLOOKUP($J95,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["16\"","ST-152-16",{"$f":"IFERROR('Rough In'!C94*_xlfn.XLOOKUP($B96,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"8\"","ST-171-08",{"$f":"'Rough In'!G96*'R Cost'!F96","v":0},null,"3x12x7","ST-1219-031207",{"$f":"IFERROR('Rough In'!K96*_xlfn.XLOOKUP($J96,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,"10\"","ST-171-10",{"$f":"'Rough In'!G97*'R Cost'!F97","v":0},null,"3X14X7","ST-1219-031407",{"$f":"IFERROR('Rough In'!K97*_xlfn.XLOOKUP($J97,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Fans(Include Finish Kit w/order)",null,null,null,"12\"","ST-171-12",{"$f":"'Rough In'!G98*'R Cost'!F98","v":0}]
["50 CFM Fan","BF-1667EH",{"$f":"IFERROR('Rough In'!C97*_xlfn.XLOOKUP($B99,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"14\"","ST-171-14",{"$f":"'Rough In'!G99*'R Cost'!F99","v":0},null,"Stack to Round Straight Boots"]
["50 CFM Fan","BF-2677H/2678F",{"$f":"IFERROR('Rough In'!C98*_xlfn.XLOOKUP($B100,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"3x10x6","ST-1214-031006",{"$f":"IFERROR('Rough In'!K100*_xlfn.XLOOKUP($J100,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["50 CFM LIGHT","BF-2678f",{"$f":"IFERROR('Rough In'!C99*_xlfn.XLOOKUP($B101,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"PVC",null,null,null,"3x10x7","ST-1214-031007",{"$f":"IFERROR('Rough In'!K101*_xlfn.XLOOKUP($J101,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["80 CFM Fan","BF-AE80B",{"$f":"IFERROR('Rough In'!C100*_xlfn.XLOOKUP($B102,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"2\" PVC - 10' Sections","BR-6082",{"$f":"IF('Rough In'!G102=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G102,\"'\",\"\"),\"\"\"\",\"\")*'R Cost'!F102,\"\"))","v":0},null,"3x12x7","ST-1214-031207",{"$f":"IFERROR('Rough In'!K102*_xlfn.XLOOKUP($J102,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["80 CFM FAN","BF-A000HLNF",{"$f":"IFERROR('Rough In'!C101*_xlfn.XLOOKUP($B103,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"2\" PVC 90","BR-0389",{"$f":"'Rough In'!G103*'R Cost'!F103","v":0},null,"3x12x8","ST-1214-031208",{"$f":"IFERROR('Rough In'!K103*_xlfn.XLOOKUP($J103,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["80 CFM Light","BF-AE80BF1",{"$f":"IFERROR('Rough In'!C102*_xlfn.XLOOKUP($B104,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"2\" PVC 45","BR-0387DWV",{"$f":"'Rough In'!G104*'R Cost'!F104","v":0},null,"3x14x8","ST-1214-031408",{"$f":"IFERROR('Rough In'!K104*_xlfn.XLOOKUP($J104,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["50 Finish Kit","BF-1688EF",{"$f":"IFERROR('Rough In'!C103*_xlfn.XLOOKUP($B105,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"2\" PVC Coupling","BR-0384",{"$f":"'Rough In'!G105*'R Cost'!F105","v":0}]
[null,null,null,null,"2\" J-Hooks","DV-515J2000",{"$f":"'Rough In'!G106*'R Cost'!F106","v":0},null,"Deep Boxes"]
["Panning",null,null,null,"2\" Concentric Kit","DV-CVENT2",{"$f":"'Rough In'!G107*'R Cost'!F107","v":0},null,"4x10","ST-1172-0410",{"$f":"IFERROR('Rough In'!K107*_xlfn.XLOOKUP($J107,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Single Sheet","ST-20717",{"$f":"IFERROR('Rough In'!C106*_xlfn.XLOOKUP($B108,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"3\" PVC - 10' Sections","BR-6081",{"$f":"IF('Rough In'!G108=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!G108,\"'\",\"\"),\"\"\"\",\"\")*'R Cost'!F108,\"\"))","v":0},null,"4x12","ST-1172-0412",{"$f":"IFERROR('Rough In'!K108*_xlfn.XLOOKUP($J108,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Double Sheet","ST-20833",{"$f":"IFERROR('Rough In'!C107*_xlfn.XLOOKUP($B109,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"3\" PVC 90","BR-0419",{"$f":"'Rough In'!G109*'R Cost'!F109","v":0},null,"6x14","ST-1172-0614",{"$f":"IFERROR('Rough In'!K109*_xlfn.XLOOKUP($J109,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Thermopan Single","TP-1648",{"$f":"IFERROR('Rough In'!C108*_xlfn.XLOOKUP($B110,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"3\" PVC 45","BR-0417",{"$f":"'Rough In'!G110*'R Cost'!F110","v":0},null,"6x12","ST-1172-0612",{"$f":"IFERROR('Rough In'!K110*_xlfn.XLOOKUP($J110,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Thermopan Double","TP-3236",{"$f":"IFERROR('Rough In'!C109*_xlfn.XLOOKUP($B111,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"3\" PVC Coupling","BR-0415",{"$f":"'Rough In'!G111*'R Cost'!F111","v":0}]
["Thermopan Header","TP-16013",{"$f":"IFERROR('Rough In'!C110*_xlfn.XLOOKUP($B112,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"3\" J-Hooks","DV-515J3000",{"$f":"'Rough In'!G112*'R Cost'!F112","v":0},null,"Stick-On Long Collars(w/dampers)"]
[null,null,null,null,"3\"-2\" PVC reducer","BR-0414",{"$f":"'Rough In'!G113*'R Cost'!F113","v":0},null,"4\"","ST-302-04",{"$f":"IFERROR('Rough In'!K113*_xlfn.XLOOKUP($J113,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["FLEX R8",null,null,null,"3\" Concentric Kit","DV-CVENT3",{"$f":"'Rough In'!G114*'R Cost'!F114","v":0},null,"6\"","ST-302-06",{"$f":"IFERROR('Rough In'!K114*_xlfn.XLOOKUP($J114,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["4\"","FX-4KPR8",{"$f":"IFERROR('Rough In'!C113*_xlfn.XLOOKUP($B115,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"7\"","ST-302-07",{"$f":"IFERROR('Rough In'!K115*_xlfn.XLOOKUP($J115,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["6\"","FX-6KPR8",{"$f":"IFERROR('Rough In'!C114*_xlfn.XLOOKUP($B116,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Register Starting Collars",null,null,null,"8\"","ST-302-08",{"$f":"IFERROR('Rough In'!K116*_xlfn.XLOOKUP($J116,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["7\"","FX-7KPR8",{"$f":"IFERROR('Rough In'!C115*_xlfn.XLOOKUP($B117,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"4x10","ST-PH101-0410",{"$f":"'Rough In'!G117*'R Cost'!F117","v":0},null,"10\"","ST-302-10",{"$f":"IFERROR('Rough In'!K117*_xlfn.XLOOKUP($J117,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["8\"","FX-8KPR8",{"$f":"IFERROR('Rough In'!C116*_xlfn.XLOOKUP($B118,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"4x12","ST-PH101-0412",{"$f":"'Rough In'!G118*'R Cost'!F118","v":0},null,"12\"","ST-302-12",{"$f":"IFERROR('Rough In'!K118*_xlfn.XLOOKUP($J118,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["10\"","FX-10KPR8",{"$f":"IFERROR('Rough In'!C117*_xlfn.XLOOKUP($B119,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"14\"","ST-302-14",{"$f":"IFERROR('Rough In'!K119*_xlfn.XLOOKUP($J119,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["12\"","FX-12KPR8",{"$f":"IFERROR('Rough In'!C118*_xlfn.XLOOKUP($B120,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Starting Collars",null,null,null,"18\"","ST-302-16",{"$f":"IFERROR('Rough In'!K120*_xlfn.XLOOKUP($J120,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["14\"","FX-14KPR8",{"$f":"IFERROR('Rough In'!C119*_xlfn.XLOOKUP($B121,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"10X8","ST-1200-0808",{"$f":"'Rough In'!G121*'R Cost'!F121","v":0}]
["16\"","FX-16KPR8",{"$f":"IFERROR('Rough In'!C120*_xlfn.XLOOKUP($B122,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"10x8","ST-1200-1008",{"$f":"'Rough In'!G122*'R Cost'!F122","v":0},null,"Alum. Bath Flex (25')"]
[null,null,null,null,"12x8","ST-1200-1208",{"$f":"'Rough In'!G123*'R Cost'!F123","v":0},null,"4\"","FX-4MC",{"$f":"IFERROR('Rough In'!K123*_xlfn.XLOOKUP($J123,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Elbows for Round Pipe",null,null,null,"14x8","ST-1200-1408",{"$f":"'Rough In'!G124*'R Cost'!F124","v":0},null,"3\"","FX-3MC",{"$f":"IFERROR('Rough In'!K124*_xlfn.XLOOKUP($J124,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["4\"","ST-ELV-3004",{"$f":"IFERROR('Rough In'!C123*_xlfn.XLOOKUP($B125,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"16X8","ST-1200-1608",{"$f":"'Rough In'!G125*'R Cost'!F125","v":0}]
["6\"","ST-ELV-3006",{"$f":"IFERROR('Rough In'!C124*_xlfn.XLOOKUP($B126,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"18x8","ST-1200-1808",{"$f":"'Rough In'!G126*'R Cost'!F126","v":0},null,"Roof Jack"]
["7\"","ST-ELV-3007",{"$f":"IFERROR('Rough In'!C125*_xlfn.XLOOKUP($B127,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"20x8","ST-1200-2008",{"$f":"'Rough In'!G127*'R Cost'!F127","v":0},null,"Small ","BF-636",{"$f":"IFERROR('Rough In'!K127*_xlfn.XLOOKUP($J127,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["8\"","ST-ELV-3008",{"$f":"IFERROR('Rough In'!C126*_xlfn.XLOOKUP($B128,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"24x8","ST-1200-2208",{"$f":"'Rough In'!G128*'R Cost'!F128","v":0},null,"Large","BF-634",{"$f":"IFERROR('Rough In'!K128*_xlfn.XLOOKUP($J128,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["10\"","ST-ELV-3010",{"$f":"IFERROR('Rough In'!C127*_xlfn.XLOOKUP($B129,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"20x10","ST-1200-2408",{"$f":"'Rough In'!G129*'R Cost'!F129","v":0},null,"3\" Rubber Plumber Flashing","DV-5-11866",{"$f":"IFERROR('Rough In'!K129*_xlfn.XLOOKUP($J129,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["12\"","ST-ELV-2612",{"$f":"IFERROR('Rough In'!C128*_xlfn.XLOOKUP($B130,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"24x10","ST-1200-2410",{"$f":"'Rough In'!G130*'R Cost'!F130","v":0}]
["14\"","ST-ELV-2614",{"$f":"IFERROR('Rough In'!C129*_xlfn.XLOOKUP($B131,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"24x12","ST-1200-2412",{"$f":"'Rough In'!G131*'R Cost'!F131","v":0},null,"Evolution Zone Dampers"]
["16\"","ST-ELV-2616",{"$f":"IFERROR('Rough In'!C130*_xlfn.XLOOKUP($B132,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"30x12","ST-1200-3012",{"$f":"'Rough In'!G132*'R Cost'!F132","v":0},null,"6\"","DAMPRND06INC",{"$f":"IFERROR('Rough In'!K132*_xlfn.XLOOKUP($J132,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,null,null,null,null,"8\"","DAMPRND08INC",{"$f":"IFERROR('Rough In'!K133*_xlfn.XLOOKUP($J133,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Return Air Frames",null,null,null,"Manual Damp. - Rnd Pipe",null,null,null,"10\"","DAMPRND10INC",{"$f":"IFERROR('Rough In'!K134*_xlfn.XLOOKUP($J134,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["12x6","ST-31HC-0610",{"$f":"IFERROR('Rough In'!C133*_xlfn.XLOOKUP($B135,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"4\"","ST-180-2-04",{"$f":"'Rough In'!G135*'R Cost'!F135","v":0},null,"12\"","DAMPRND12INC",{"$f":"IFERROR('Rough In'!K135*_xlfn.XLOOKUP($J135,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["14x6","ST-31HC-0614",{"$f":"IFERROR('Rough In'!C134*_xlfn.XLOOKUP($B136,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6\"","ST-180-2-06",{"$f":"'Rough In'!G136*'R Cost'!F136","v":0},null,"14\"","DAMPRND14INC",{"$f":"IFERROR('Rough In'!K136*_xlfn.XLOOKUP($J136,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["24x6","ST-33HC-0824",{"$f":"IFERROR('Rough In'!C135*_xlfn.XLOOKUP($B137,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"7\"","ST-180-2-07",{"$f":"'Rough In'!G137*'R Cost'!F137","v":0},null,"16\"","DAMPRND16INC",{"$f":"IFERROR('Rough In'!K137*_xlfn.XLOOKUP($J137,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["30x6","ST-33HC-0630",{"$f":"IFERROR('Rough In'!C136*_xlfn.XLOOKUP($B138,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"8\"","ST-180-2-08",{"$f":"'Rough In'!G138*'R Cost'!F138","v":0},null,"8\" x 10\"","DAMPREC08X10",{"$f":"IFERROR('Rough In'!K138*_xlfn.XLOOKUP($J138,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["30x10","ST-33HC-3008",{"$f":"IFERROR('Rough In'!C137*_xlfn.XLOOKUP($B139,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"10\"","ST-180-2-10",{"$f":"'Rough In'!G139*'R Cost'!F139","v":0},null,"8\" x 14\"","DAMPREC08X14",{"$f":"IFERROR('Rough In'!K139*_xlfn.XLOOKUP($J139,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["30x12","ST-33HC-3012",{"$f":"IFERROR('Rough In'!C138*_xlfn.XLOOKUP($B140,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"12\"","ST-180-2-12",{"$f":"'Rough In'!G140*'R Cost'!F140","v":0},null,"8\" x 18\"","DAMPREC08X18",{"$f":"IFERROR('Rough In'!K140*_xlfn.XLOOKUP($J140,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["30x8","ST-33HC-3008",{"$f":"IFERROR('Rough In'!C139*_xlfn.XLOOKUP($B141,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"14\"","ST-180-2-14",{"$f":"'Rough In'!G141*'R Cost'!F141","v":0},null,"8\" x 24\"","DAMPREC08X24",{"$f":"IFERROR('Rough In'!K141*_xlfn.XLOOKUP($J141,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["12x12","ST-33HC-1212",{"$f":"IFERROR('Rough In'!C140*_xlfn.XLOOKUP($B142,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"16\"","ST-180-2-16",{"$f":"'Rough In'!G142*'R Cost'!F142","v":0},null,"10\" x 10\"","DAMPREC10X10",{"$f":"IFERROR('Rough In'!K142*_xlfn.XLOOKUP($J142,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["14x14","ST-33HC-1414",{"$f":"IFERROR('Rough In'!C141*_xlfn.XLOOKUP($B143,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"10\" x 14\"","DAMPREC10X14",{"$f":"IFERROR('Rough In'!K143*_xlfn.XLOOKUP($J143,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["16x16","ST-33HC-1616",{"$f":"IFERROR('Rough In'!C142*_xlfn.XLOOKUP($B144,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Spiral Couplings/Accessories",null,null,null,"10\" x 18\"","DAMPREC10X18",{"$f":"IFERROR('Rough In'!K144*_xlfn.XLOOKUP($J144,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["20x20","ST-33HC-2020",{"$f":"IFERROR('Rough In'!C143*_xlfn.XLOOKUP($B145,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"10\" spiral coupling","LSM-SC10",{"$f":"'Rough In'!G145*'R Cost'!F145","v":0},null,"10\" x 24\"","DAMPREC10X24",{"$f":"IFERROR('Rough In'!K145*_xlfn.XLOOKUP($J145,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,"12\" spiral coupling","LSM-SC12",{"$f":"'Rough In'!G146*'R Cost'!F146","v":0}]
["Stick-on Saddle Collars",null,null,null,"14\" spiral coupling","LSM-SC14",{"$f":"'Rough In'!G147*'R Cost'!F147","v":0},null,"Manual Dampers"]
["4\"","ST-305-04",{"$f":"IFERROR('Rough In'!C146*_xlfn.XLOOKUP($B148,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"16\" spiral coupling","LSM-SC16",{"$f":"'Rough In'!G148*'R Cost'!F148","v":0},null,"24x8","ST-182-2408",{"$f":"IFERROR('Rough In'!K148*_xlfn.XLOOKUP($J148,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["6\"","ST-305-06",{"$f":"IFERROR('Rough In'!C147*_xlfn.XLOOKUP($B149,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Clutchers (for steel cable)","DUR-30351",{"$f":"'Rough In'!G149*'R Cost'!F149","v":0},null,"22x8","ST-182-2208",{"$f":"IFERROR('Rough In'!K149*_xlfn.XLOOKUP($J149,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["7\"","ST-305-07",{"$f":"IFERROR('Rough In'!C148*_xlfn.XLOOKUP($B150,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Roll of steel braided cable","DUR-30202",{"$f":"'Rough In'!G150*'R Cost'!F150","v":0},null,"20x8","ST-182-2008",{"$f":"IFERROR('Rough In'!K150*_xlfn.XLOOKUP($J150,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["8\"","ST-305-08",{"$f":"IFERROR('Rough In'!C149*_xlfn.XLOOKUP($B151,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"4x12 spiral register","TRU-SU2A12X4",{"$f":"'Rough In'!G151*'R Cost'!F151","v":0},null,"18x8","ST-182-1808",{"$f":"IFERROR('Rough In'!K151*_xlfn.XLOOKUP($J151,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["10\"","ST-305-10",{"$f":"IFERROR('Rough In'!C150*_xlfn.XLOOKUP($B152,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"6x12 spiral register","TRU-SU2A12X6",{"$f":"'Rough In'!G152*'R Cost'!F152","v":0},null,"16x8","ST-182-1608",{"$f":"IFERROR('Rough In'!K152*_xlfn.XLOOKUP($J152,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["12\"","ST-305-12",{"$f":"IFERROR('Rough In'!C151*_xlfn.XLOOKUP($B153,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"14x8","ST-182-1408",{"$f":"IFERROR('Rough In'!K153*_xlfn.XLOOKUP($J153,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["14\"","ST-305-14",{"$f":"IFERROR('Rough In'!C152*_xlfn.XLOOKUP($B154,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Makeup Air Damper Kit",null,null,null,"12x8","ST-182-1208",{"$f":"IFERROR('Rough In'!K154*_xlfn.XLOOKUP($J154,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
[null,null,null,null,"Broan 6\"","NU-MD6TU",{"$f":"'Rough In'!G155*'R Cost'!F155","v":0},null,"10X8","ST-182-1008",{"$f":"IFERROR('Rough In'!K155*_xlfn.XLOOKUP($J155,'R Cost'!$H:$H,'R Cost'!$I:$I),\"\")","v":0}]
["Dryer Vent Box",null,null,null,"Broan 8\"","NU-MD8TU",{"$f":"'Rough In'!G156*'R Cost'!F156","v":0}]
["(2x4 wall box)","ST-DVB350",{"$f":"IFERROR('Rough In'!C155*_xlfn.XLOOKUP($B157,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,"Broan 10\"","NU-MD10TU",{"$f":"'Rough In'!G157*'R Cost'!F157","v":0},null,"Standard Lineset - 3/4\" Insul"]
["(2x6 wall box)","ST-DVB425",{"$f":"IFERROR('Rough In'!C156*_xlfn.XLOOKUP($B158,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0},null,null,null,null,null,"5/8\" x 3/8\" x 40'","LS-583840-12",{"$f":"IFERROR('Rough In'!K158*_xlfn.XLOOKUP($J158,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
[null,null,null,null,"Minisplit Lineset",null,null,null,"5/8\" x 3/8\" x 50'","LS-583850-12",{"$f":"IFERROR('Rough In'!K159*_xlfn.XLOOKUP($J159,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
["Spiral Pipe",null,null,null,"3/8\" x1/4\" x 25'","LS-MS381425-12EZ",{"$f":"'Rough In'!G160*'R Cost'!F160","v":0},null,"3/4\" x 3/8\" x 40'","LS-343840-12",{"$f":"IFERROR('Rough In'!K160*_xlfn.XLOOKUP($J160,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
["4\"","LSM-SP04",{"$f":"IF('Rough In'!C159=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C159,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B161,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"3/8\" x1/4\" x 50'","LS-MS381450-12EZ",{"$f":"'Rough In'!G161*'R Cost'!F161","v":0},null,"3/4\" x 3/8\" x 50'","LS-343850-12",{"$f":"IFERROR('Rough In'!K161*_xlfn.XLOOKUP($J161,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
["6\"","LSM-SP06",{"$f":"IF('Rough In'!C160=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C160,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B162,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"1/2\" x 1/4\" x 25'","LS-MS121425-12EZ",{"$f":"'Rough In'!G162*'R Cost'!F162","v":0},null,"7/8\" x 3/8\" x 40'","LS-783840-12",{"$f":"IFERROR('Rough In'!K162*_xlfn.XLOOKUP($J162,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
["7\"","LSM-SP07",{"$f":"IF('Rough In'!C161=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C161,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B163,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"1/2\" x 1/4\" x 50'","LS-MS121450-12EZ",{"$f":"'Rough In'!G163*'R Cost'!F163","v":0},null,"7/8\" x 3/8\" x 50'","LS-783850-12",{"$f":"IFERROR('Rough In'!K163*_xlfn.XLOOKUP($J163,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
["8\"","LSM-SP08",{"$f":"IF('Rough In'!C162=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C162,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B164,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"5/8\" x 3/8\" x 25'","LS-MS583825-12EZ",{"$f":"'Rough In'!G164*'R Cost'!F164","v":0},null,"2\" Lineset Clamps","TP-41125",{"$f":"IFERROR('Rough In'!K164*_xlfn.XLOOKUP($J164,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\")","v":0}]
["10\"","LSM-SP10",{"$f":"IF('Rough In'!C163=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C163,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B165,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"5/8\" x 3/8\" x 50'","LS-MS583850-12EZ",{"$f":"'Rough In'!G165*'R Cost'!F165","v":0}]
["12\"","LSM-SP12",{"$f":"IF('Rough In'!C164=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C164,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B166,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"3/4\" x 3/8\" x 35'","LS-MS343835-12EZ",{"$f":"'Rough In'!G166*'R Cost'!F166","v":0}]
["14\"","LSM-SP14",{"$f":"IF('Rough In'!C165=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C165,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B167,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0},null,"3/4\" x 3/8\" x 50'","LS-MS343850-12EZ",{"$f":"'Rough In'!G167*'R Cost'!F167","v":0}]
["16\"","LSM-SP16",{"$f":"IF('Rough In'!C166=\"\",0,IFERROR(SUBSTITUTE(SUBSTITUTE('Rough In'!C166,\"'\",\"\"),\"\"\"\",\"\")/10*_xlfn.XLOOKUP($B168,'R Cost'!$B:$B,'R Cost'!$C:$C),\"\"))","v":0}]
[]
[]
["Subtotal (Column 1):",null,{"$f":"SUM(C8:C169)-C21","v":231.52999999999997},null,"Subtotal (Column 2):",null,{"$f":"SUM(G9:G169)","v":0},null,"Subtotal (Column 3):",null,{"$f":"SUM(K9:K169)","v":0}]
[]
[]
[]
["Equipment Cost:",null,{"$f":"C21","v":0}]
["Material Cost:",null,{"$f":"G177-C175","v":231.52999999999997}]
["Grand Subtotal:",null,{"$f":"SUM(C175:C176)","v":231.52999999999997},"=","Grand Subtotal:",null,{"$f":"C171+G171+K171","v":231.52999999999997}]
[null,null,null,null,"Tax:",null,{"$f":"G177*$J$178","v":18.059339999999999},null,"Sales Tax Rate:",7.8E-2]
[null,null,null,null,"Grand Total (Rough In):",null,{"$f":"G177+G178","v":249.58933999999996}]

{"sheet":"R Cost","index":4,"n_rows":182,"n_cols":9,"rows_kept":182,"cut":false,"hidden":false,"merged":[[154,0,154,2],[150,0,150,2],[141,0,141,2],[96,6,96,8],[6,6,6,8],[12,6,12,8],[23,6,23,8],[27,6,27,8],[79,6,79,8],[90,6,90,8],[177,3,177,5],[177,6,177,8],[35,3,35,5],[19,3,19,5],[128,0,128,2],[118,0,118,2],[108,0,108,2],[84,0,84,2],[84,6,84,8],[93,0,93,2],[64,0,64,2],[61,0,61,2],[27,0,27,2],[19,0,19,2],[173,0,173,2],[164,0,164,2],[2,1,2,8],[0,0,0,8],[54,0,54,2],[1,3,1,4],[1,6,1,8],[3,0,4,0],[6,3,6,5]]}
["Rough Costing Form"]
[null,null,"PO:",null,null,"Deliver On:"]
["Notes:"]
["Add following equipment previously purchased to delivery:","Ticket #","Job PO","Model","Serial #"]
[]
[null,null,"COST",null,null,"COST",null,null,"COST"]
["FURNACE/AIR HANDLER",null,null,"Transitional Takeoffs",null,null,"Stick-On Flat 90’s "]
["COIL",null,null,"24x12","ST-1203-2412",64.63,"8\"","ST-306-08",14.19]
["HEAT PACK",null,null,"24x10","ST-1203-2410",78.09,"7\"","ST-306-07",11.63]
["Bottom Box","SEE SECOND SHEET",null,"20x10","ST-1203-2010",46.05,"6\"","ST-306-06",10.33]
["Plenum","SEE SECOND SHEET",null,"24x8","ST-1203-2408",39.450000000000003,"4\"","ST-306-04",9.8800000000000008]
["Coil Adapter/Spacer","SEE SECOND SHEET",null,"22x8","ST-1203-2208",37.590000000000003]
["Com. Wire(14-4 50FT)","14-4C",75.38,"20x8","ST-1203-2008",37.08,"Round Pipe (5' Sections) 30GA "]
["Com. Wire(14-4 250FT)","14-4C-250",598.38,"18x8","ST-1203-1808",34.21,"3\"","ST-RDP-053003",6.75]
["Bricks","HO-619345",1.48,"16x8","ST-1203-1608",32.71,"4\"","ST-RDP-053004",7.94]
["Adjustable Pump-Ups","DV-HPR6-2P",5.46,"14x8","ST-1203-1408",31.56,"6\"","ST-RDP-053006",8.34]
["SMALL BYP. HUMIDIFIER","HUMCRSBP2412",170,"12x8","ST-1203-1208",38.130000000000003,"7\"","ST-RDP-053007",11.09]
["LARGE BYP. HUMIDIFIER","HUMCRLBP2417",182,"10x8","ST-1203-1008",36.83,"8\"","ST-RDP-053008",13.7]
[null,null,null,null,null,null,"10\"","ST-RDP-053010",17.91]
["Media Cabinets",null,null,"Duct - 5' Sections",null,null,"12\"","ST-RDP-053012",21.46]
["Core Media Cabinet - 16X25","EZXCABCR1016",168,null,null,null,"14\"","ST-RDP-052614",32.36]
["Core Media Cabinet - 20X25","EZXCABCR1320",207.96,"25x10","ST-DT-602510",60.44,"16\"","ST-RDP-052616",47.98]
["Media Cabinet - 24X25","FILCABXL0024",45,"24x12","ST-DT-602412",57.82]
["Honeywell Media Cab 16x20","HW-F100F1620",138.19999999999999,"24x10","ST-DT-602410",52.56,"Boot Frames"]
["Honeywell Media Cab 20x20","HW-F100F2020",138.19999999999999,"20x10","ST-DT-602010",57.82,"H-4 Boot Frame","PT-H4",7.68]
["Honeywell Media Cab 20x25","HW-F100F2025",138.19999999999999,"24x8","ST-DT-602408",43.81,"H-6 Boot Frame","PT-H6",6.37]
[null,null,null,"22x8","ST-DT-602208",43.08]
["Standard Items",null,null,"20x8","ST-DT-602008",37.590000000000003,"Boots"]
["Tub 3/4\" screws","MA-HW8X3/4ZT",41.14,"18x8","ST-DT-601808",35.880000000000003,"4x10x4 end boot","ST-1373-041004",5.95]
["Tub 1/2\" screws","MA-HW8X1/2ZT",31.64,"16x8","ST-DT-601608",30,"4x10x4 L boot","ST-1374-041004",5.2]
["Basset Hangers","BP-A125",21.46,"14x8","ST-DT-601408",28.94,"4x10x4 straight boot","ST-1370-041004",5.13]
["5' Drives","ST-213-60",2.2400000000000002,"12x8","ST-DT-601208",25.53,"4x10x6 L boot","ST-1374-041006",5.13]
["5' S-Locks","ST-209-60",2.57,"10x8","ST-DT-601008",24.51,"4x10x6 end boot","ST-1373-041006",5.13]
["Rolls of 3\" tape","DT-322F3",18.27,"8x8","ST-DT-600808",22.9,"4x10x6 straight boot","ST-1370-041006",5.13]
["Rolls of mastic tape","AFG-1404-181",40.44,null,null,null,"4x12x6 end boot","ST-1373-041206",5.89]
["Duct Sealant Gallon Pail","HF-SDSWB",19.82,"End Caps",null,null,"4x12x6 L boot","ST-1374-041206",5.89]
["2\" brushes","DV-B503",0.8,"25x12","ST-1210-3012",14.06,"4x12x6 straight boot","ST-1370-041206",5.89]
["Tubes of Clear Silicone","BO-370C",7.41,"24x12","ST-1210-2412",10.44,"4x12x7 L boot","ST-1374-041207",5.89]
["10' Section - 3/4\" PVC","BR-6106",{"$f":"1.01*10","v":10.1},"24x10","ST-1210-2410",8.6199999999999992,"4x12x7 straight boot","ST-1370-041207",5.89]
["EZ-Trap Clear PVC Trap for AH ","RC-83114",20.86,"20x10","ST-1210-2010",7.65,"4x12x7 end boot","ST-1373-041207",5.89]
["3/4\" PVC threaded male","BR-0342",0.51,"24x8","ST-1210-2408",8.11,"6x10x7 end-boot","ST-1373-061007",8.83]
["3/4\" PVC threaded female ","BR-0341",0.71,"22x8","ST-1210-2208",7.65,"6x10x7 L boot","ST-1374-061007",7.24]
["3/4\" PVC 90's","BR-0344",0.56000000000000005,"20x8","ST-1210-2008",6.38,"6x10x7 straight boot","ST-1370-061007",6.61]
["3/4\" PVC T's","BR-0349",0.71,"18x8","ST-1210-1808",6.07,"6x12x7 end boot","ST-1373-061207",7.7]
["3/4\" PVC 45’s","BR-0346",1.29,"16x8","ST-1210-1608",5.57,"6x12x7 L boot","ST-1374-061207",7.93]
["Glue","DV-510",14.72,"14x8","ST-1210-1408",5.18,"6x12x7 straight boot","ST-1370-061207",7.09]
["Cleaner","DV-PPC16",14.23,"12x8","ST-1210-1208",4.99,"6x12x8 straight boot","ST-1370-061208",7.19]
["Rubber 3\"x3\" pads","DV-MP3E",2.29,"10x8","ST-1210-1008",4.8099999999999996,"6x12x8 end boot","ST-1373-061208",7.81]
["Bag 36\" Panduits","DV-7P36",10.83,"8x8","ST-1210-0808",4.88,"6x12x8 L boot","ST-1374-061208",7.38]
["Foil Back Fiberglass-2\" 75' ","KF-E24875FSKLKDW",174.63,null,null,null,"6x14x8 L Boot","ST-1374-061408",8.2200000000000006]
["Lineset Clips - Reg. Size ","TP-41125 (5 PER PACK)",{"$f":"1.38*5","v":6.8999999999999995},"Supply Duct Reducers",null,null,"6x14x8 Straight Boot","ST-1370-061408",8.08]
["Roll of 3\" Webbing","DV-710102",16.149999999999999,"2\" reducer for 8\" duct","ST-187-02",5.36," 6X14X8 end boot","ST-1373-061408",8.52]
["Aquaguard Float Switch","AG-1200",22.59,"4\" reducer for 8\" duct","ST-187-04",5.5]
[null,null,null,"6\" reducer for 8\" duct","ST-187-06",6.75,"Oval (100\" sections)"]
["TEMP FILTERS",null,null,"8\" reducer for 8\" duct","ST-187-08",8.44,"6\"","ST-4100-10006",15.82]
["16x25x1 temp filter","FI-16X25X1",3.26,"24x12 to 24x10 reduc.","ST-1251-24122410",31.23,"7\"","ST-4100-10007",18.57]
["20x25x1 temp filter","FI-20X25X1",3.6,"24x10 to 24x8 reduc.","ST-1251-24102408",63.09,"8\"","ST-4100-10008",23.18]
["24x25x1 temp filter","FI-24X25X1",10.34]
["16x20x1 temp filter","FI-16X20X1",3.2,"Round Reducers",null,null,"Oval to Round L-Boot"]
["20x20x1 temp filter","FI-20X20X1",3.37,"4\"-3\"","ST-133-040326",5.28,"6\" oval to round L-Boot","ST-4244NC-06",6.62]
[null,null,null,"6\"-4\"","ST-133-060426",6.67,"7\" oval to round L-Boot","ST-4244NC-07",8]
["Drywall Edging",null,null,"8\"-6\"","ST-133-080626",7.06,"8\" oval to round L-Boot","ST-4244NC-08",14.89]
["5' sections","ST-210-60",3.99,"10\"-8\"","ST-133-100826",10.23]
[null,null,null,"12\"-10\"","ST-133-121026",11.44,"Oval to Round End Boot"]
["Duct Fittings",null,null,"14\"-10\"","ST-133-141026",13.91,"6\" oval-round end boot","ST-4247NC-0606",8.6999999999999993]
["10x8 SW 90","ST-1240-1008",21.2,"14\"-12\"","ST-133-141226",14.73,"7\" oval-round end boot","ST-4247NC-0707",14.5]
["10x8 BW 90","ST-1246-1008",26.15,"16\"-12\"","ST-133-161226",19.39,"8\" oval-round end boot","ST-4247NC-0808",21.06]
["12x8 SW 90","ST-1240-1208",21.72,"16\"-14\"","ST-133-161426",17.89]
["12x8 BW 90","ST-1246-1208",26.59,null,null,null,"Oval-Round Straight Boot"]
["14x8 SW 90","ST-1240-1408",21.98,"Y's",null,null,"6\" oval-round straight boot","ST-4248NC-0606",7.57]
["14x8 BW 90","ST-1246-1408",30.83,"6X4X4 WITH REDUCER","ST-324-060404",23.96,"7\" oval-round straight boot","ST-4248NC-0707",11.88]
["16x8 SW 90","ST-1240-1608",22.39,"7x5x3 WITH REDUCER","ST-324-070503",31.57,"8\" oval-round straight boot","ST-4248NC-0808",18.440000000000001]
["16x8 BW 90","ST-1246-1608",31.09,"8X7X6 WITH REDUCER","ST-324-080706",29.2]
["18x8 SW 90","ST-1240-1808",28.55,null,null,null,"Oval Stackhead w/wings"]
["18x8 BW 90","ST-1246-1808",33.729999999999997,"T's",null,null,"6\" oval stack head w/4x10","ST-4235-0941006",7.98]
["20x8 SW 90","ST-1240-2008",26.31,"4x4x4","ST-219-040404",12.51,"7” oval stackhead w/4x12","ST-4235-0941207",11.27]
["20x8 BW 90","ST-1246-2008",40.340000000000003,"6x4x4W/reducers","ST-219-060606 ",12.93,"7” oval stackhead w/6x12","ST-4235-0961207",10.119999999999999]
["22x8 SW 90","ST-1240-2208",41.47,"6x6x6","ST-219-060606",14.77,"8\" oval stackhead w/6x14","ST-4235-0961408",12.8]
["22x8 BW 90","ST-1246-2208",51.06,"7x7x7","ST-219-070707",18.07]
["24x8 SW 90","ST-1240-2408",29.37,"8x8x8","ST-219-080808 ",18.07,"Stack (100\" sections)"]
["24x8 BW 90","ST-1246-2408",51.23,null,null,null,"3.25x10","ST-WSBL-1000310",43.66]
["24x10 SW 90","ST-1240-2410",46.61,"Short Collars w/Crimp",null,null,"3.25x12","ST-WSBL-1000312",46.8]
["24x10 BW 90","ST-1246-2410",66.97,"4\"","ST-172-04",1.63,"3.25x14","ST-WSBL-1000314",52.57]
[null,null,null,"6\"","ST-172-06",1.47]
["End Caps",null,null,"7\"","ST-172-07",1.87,"Stack to Round L-Boot"]
["6\"","ST-152-06",5.57,"8\"","ST-172-08",2.15,"3x10x6","ST-1218-031006",7.86]
["10\"","ST-152-07",6.07,"10\"","ST-172-10",3.07," 3x10x7","ST-1218-031007",11.88]
["10\"","ST-152-08",6.61,"12\"","ST-172-12",3.46,"3x12x7","ST-1218-031207",10.19]
["10\"","ST-152-10",8.99,"14\"","ST-172-14",5.29,"  3x12x8","ST-1218-031208",15.72]
["12\"","ST-152-12",9.4600000000000009,"16\"","ST-172-16",7.93,"3X14X8","ST-1218-031408",15.82]
["14\"","ST-152-14",13.19,null,null,null,"Stack to Round End Boots"]
["16\"","ST-152-16",16.12,"Short Collars - No Crimp",null,null,"3x10x6","ST-1219-031006",7.94]
[null,null,null,"4\"","ST-171-04",1.63,"3X12X6","ST-1219-031206",9.09]
["Fans(Include Finish Kit w/order)",null,null,"6\"","ST-171-06",1.75,"3x12x7","ST-1219-031207",12.93]
["50 CFM Fan","BF-1667EH",7.53,"7\"","ST-171-07",2.15,"3X14X7","ST-1219-031407",15.99]
["50 CFM Fan (select light below)","BF-2677H/2678F",12.34,"8\"","ST-171-08",2.15]
["50 CFM LIGHT","BF-2678f",37.18,"10\"","ST-171-10",3.34,"Stack to Round Straight Boots"]
["80 CFM Fan","BF-AE80B",63.37,"12\"","ST-171-12",3.46,"3x10x6","ST-1214-031006",7.94]
["80 CFM FAN (select light below)","BF-A000HLNF",12.98,"14\"","ST-171-14",5.29,"3x10x7","ST-1214-031007",11.88]
["80 CFM Light","BF-AE80BF1",66.58,null,null,null,"3x12x7","ST-1214-031207",10.44]
["50 Finish Kit","BF-1688EF",16.11,"PVC",null,null,"3x12x8","ST-1214-031208",12.97]
["Panning",null,null,"2\" PVC - 10' Sections","BR-6082",1.86,"3x14x8","ST-1214-031408",15.82]
["Single Sheet","ST-20717",5.07,"2\" PVC 90","BR-0389",4.25]
["Double Sheet","ST-20833",9.09,"2\" PVC 45","BR-0387DWV",2.29,"Deep Boxes"]
["Thermopan Single","TP-1648",3.54,"2\" PVC Coupling","BR-0384",1.8,"4x10","ST-1172-0410",11.88]
["Thermopan Double","TP-3236",5.49,"2\" J-Hooks","DV-515J2000",2,"4x12","ST-1172-0412",27.01]
["Thermopan Header","TP-16013",3.3,"2\" Concentric Kit","DV-CVENT2",43.55,"6x14","ST-1172-0614",27.01]
[null,null,null,"3\" PVC - 10' Sections","BR-6081",4.1900000000000004,"6x12","ST-1172-0612",27.01]
["FLEX",null,null,"3\" PVC 90","BR-0419",9.26]
["4\"","FX-4KPR8",46.6,"3\" PVC 45","BR-0417",6.45,"Stick-On Long Collars(w/dampers)"]
["6\"","FX-6KPR8",54.1,"3\" PVC Coupling","BR-0415",3.5,"4\"","ST-302-04",9.24]
["7\"","FX-7KPR8",59.59,"3\" J-Hooks","DV-515J3000",2.29,"6\"","ST-302-06",9]
["8\"","FX-8KPR8",66.37,"3\"-2\" PVC reducer","BR-0414",5.09,"7\"","ST-302-07",9.14]
["10\"","FX-10KPR8",80.59,"3\" Concentric Kit","DV-CVENT3",60.55,"8\"","ST-302-08",10.83]
["12\"","FX-12KPR8",95.68,null,null,null,"10\"","ST-302-10",15.13]
["14\"","FX-14KPR8",117.69,"Register Starting Collars",null,null,"12\"","ST-302-12",17.41]
["16\"","FX-16KPR8",141.12,"4x10","ST-PH101-0410",8.9600000000000009,"14\"","ST-302-14",20.170000000000002]
[null,null,null,"4x12","ST-PH101-0412",9.83,"16\"","ST-302-16",27.51]
["Elbows for Round Pipe"]
["4\"","ST-ELV-3004",2.36,"Starting Collars",null,null,"Alum. Bath Flex (25')"]
["6\"","ST-ELV-3006",2.41,"10X8","ST-1200-0808",9.51,"4\"","FX-4MC",18.760000000000002]
["7\"","ST-ELV-3007",3.2,"10x8","ST-1200-1008",9.7899999999999991,"3\"","FX-3MC",15.4]
["8\"","ST-ELV-3008",3.82,"12x8","ST-1200-1208",10.029999999999999]
["10\"","ST-ELV-3010",7.52,"14x8","ST-1200-1408",10.55,"Roof Jack"]
["12\"","ST-ELV-2612",12.24,"16X8","ST-1200-1608",10.7,"Small ","BF-636",21.69]
["14\"","ST-ELV-2614",15.8,"18x8","ST-1200-1808",12.69,"Large","BF-634",44.35]
["16\"","ST-ELV-2616",23,"20x8","ST-1200-2008",13.98,"3\" Rubber Plumber Flashing","DV-5-11866",13.9]
[null,null,null,"24x8","ST-1200-2208",15.27]
["Return Air Frames",null,null,"20x10","ST-1200-2408",15.56,"Evolution Zone Dampers"]
["12x6","ST-31HC-0610",6.99,"24x10","ST-1200-2410",17.13,"6\"","DAMPRND06INC",205]
["14x6","ST-31HC-0614",5.29,"24x12","ST-1200-2412",23.69,"8\"","DAMPRND08INC",205]
["24x6","ST-33HC-0824",7.05,"30x12","ST-1200-3012",36.83,"10\"","DAMPRND10INC",213]
["30x6","ST-33HC-0630",5.13,null,null,null,"12\"","DAMPRND12INC",213]
["30x10","ST-33HC-3008",6.69,"Manual Damp. - Rnd Pipe",null,null,"14\"","DAMPRND14INC",218]
["30x12","ST-33HC-3012",22.34,"4\"","ST-180-2-04",4.8099999999999996,"16\"","DAMPRND16INC",218]
["30x8","ST-33HC-3008",6.69,"6\"","ST-180-2-06",5.07,"8\" x 10\"","DAMPREC08X10",284]
["12x12","ST-33HC-1212",7.42,"7\"","ST-180-2-07",5.29,"8\" x 14\"","DAMPREC08X14",284]
["14x14","ST-33HC-1414",8.94,"8\"","ST-180-2-08",6.61,"8\" x 18\"","DAMPREC08X18",291]
["16x16","ST-33HC-1616",11.23,"10\"","ST-180-2-10",7.72,"8\" x 24\"","DAMPREC08X24",291]
["20x20","ST-33HC-2020",21.41,"12\"","ST-180-2-12",9.25,"10\" x 10\"","DAMPREC10X10",286.27]
[null,null,null,"14\"","ST-180-2-14",1.54,"10\" x 14\"","DAMPREC10X14",303]
["Stick-on Saddle Collars",null,null,"16\"","ST-180-2-16",13.19,"10\" x 18\"","DAMPREC10X18",311]
["4\"","ST-305-04",7.06,null,null,null,"10\" x 24\"","DAMPREC10X24",311]
["6\"","ST-305-06",7.42,"Spiral Couplings/Accessories"]
["7\"","ST-305-07",7.72,"10\" spiral coupling","LSM-SC10",10.130000000000001,"Manual Dampers"]
["8\"","ST-305-08",10.55,"12\" spiral coupling","LSM-SC12",10.91]
["10\"","ST-305-10",12.53,"14\" spiral coupling","LSM-SC14",18.559999999999999,"24x8","ST-182-2408",27.65]
["12\"","ST-305-12",15.89,"16\" spiral coupling","LSM-SC16",14.04,"22x8","ST-182-2208",26.31]
["14\"","ST-305-14",17.86,"Wire Clutchers","DUR-30351",5.58,"20x8","ST-182-2008",23.2]
[null,null,null,"Roll Steel Braided Cable","DUR-30202",177.83,"18x8","ST-182-1808",25.01]
["Dryer Vent Box",null,null,"4x12 spiral register","TRU-SU2A12X4",87.15,"16x8","ST-182-1608",21.72]
["(2x4 wall box)","ST-DVB350",36.29,"6x12 spiral register","TRU-SU2A12X6",139.01,"14x8","ST-182-1408",21.72]
["(2x6 wall box)","ST-DVB425",36.29,null,null,null,"12x8","ST-182-1208",21.05]
[null,null,null,"Makeup Air Damper Kit",null,null,"10X8","ST-182-1008",20.309999999999999]
["Spiral Pipe",null,null,"Broan 6\"","NU-MD6TU",200.97]
["4\"","LSM-SP04",23.28,"Broan 8\"","NU-MD8TU",204.28]
["6\"","LSM-SP06",34.01,"Broan 10\"","NU-MD10TU",262.39999999999998]
["7\"","LSM-SP07",42.23]
["8\"","LSM-SP08",70.8]
["10\"","LSM-SP10",55.62]
["12\"","LSM-SP12",63.33]
["14\"","LSM-SP14",75.33]
["16\"","LSM-SP16",100.99]
[]
["Standard Lineset - 3/4\" Insul"]
["5/8\"x3/8\"x40'","LS-583840-12",250.71]
["5/8\"x3/8\"x50'","LS-583850-12",328.44]
["3/4\"x3/8\"x40'","LS-343840-12",295.29000000000002]
["3/4\"x3/8\"x50'","LS-343850-12",388.19]
["7/8\"x3/8\"x40'","LS-783840-12",356.73]
["7/8\"x3/8\"x50'","LS-783850-12",479.51]
["2\" Lineset Clamps","TP-41125",1.49]
[]
["Minisplit Lineset"]
["3/8\"x1/4\"x25'","LS-MS381425-12EZ",180.44]
["3/8\"x1/4\"x50'","LS-MS381450-12EZ",329.49]
["1/2\"x1/4\"x25'","LS-MS121425-12EZ",185.8]
["1/2\"x1/4\"x50'","LS-MS121450-12EZ",350.39]
["5/8\"x3/8\"x25'","LS-MS583825-12EZ",228.24]
["5/8\"x3/8\"x50'","LS-MS583850-12EZ",385.13]
["3/4\"x3/8/35'","LS-MS343835-12EZ",227.86]
["3/4\"x3/8/50'","LS-MS343850-12EZ",451.39]

{"sheet":"F Cost","index":5,"n_rows":201,"n_cols":9,"rows_kept":201,"cut":false,"hidden":false,"merged":[[5,1,5,5],[0,0,0,8],[2,2,3,2],[2,3,3,4],[2,5,3,5],[2,6,3,8],[38,6,38,8],[6,0,7,0],[9,3,9,4],[9,6,9,7],[17,3,17,5],[17,6,17,8],[23,6,23,8],[25,3,25,5],[27,0,27,2],[29,6,29,8],[32,3,32,5],[32,6,32,8],[186,3,186,5],[186,6,186,7],[39,0,39,2],[39,3,39,5],[68,3,68,5],[70,6,70,7],[75,6,75,7],[79,3,79,5],[109,3,109,5],[109,6,109,7],[144,6,144,7],[145,3,145,5],[163,6,163,7]]}
["Finish Material Order"]
[]
[null,null,"PO:",null,null,"Deliver On:"]
[]
[]
["Notes:"]
["Add following equipment previously purchased to delivery:","Ticket #","Job PO","Qty","Model","Serial #"]
[]
[]
[null,null,"COST","Side Wall Registers",null,"COST","Exterior Exhaust Caps",null,"COST"]
["OUTDOOR UNIT",null,null,"4x10","LI-10V10X4",5.73,"4\" Brown Exhaust","DE-HS4B",2.82]
[null,null,null,"4x12","LI-10V12X4",6.19,"4\" White Exhaust","DE-HS4W",2.74]
[null,null,null,"4x14","LI-10V14X4",9.75,"6\" White Exhaust","DE-HS6W",4.72]
["AC Poles:","SPS-2/POLE",11.21,"6x10","LI-10V10X6",6.04,"6\" Brown Exhuast","DE-HS6B",4.72]
["Pole End Cap","SPS-2/CAP",3.85,"6x12","LI-10V12X6",7.42]
["Locking Caps:","CD2290",7.45,"6x14","LI-10V14X6",9.99]
["6' UV Armor Flex - 3/4\"","P809-T03434",18.55]
["6' UV Armor Flex - 7/8\"",null,20.22,"Floor Registers",null,null,"Exterior Intake Caps"]
["Clear Silicone","BO-370C",7.08,"4x10","LI-414X10",4.3600000000000003,"6\" White Intake","DE-HSM6W",6.76]
["White Silicone","BO-370W",7.08,"4x12","LI-414x12",5.59,"6\" Brown Intake","DE-HSM6B",6.97]
["Thumb Gum:","P904-0303",7.22,"4x14","LI-414x14",9.75]
["Finish Filter 16x25x4:","HW-FC100A1029",35.380000000000003,"6x10","LI-416x10",15.83]
["Finish Filter 20x25x4:","HW-FC100A1037",35.380000000000003,"6x12","LI-416x12",11.57]
["Finish Filter 24x25x4:","FILXUMC112425",38.47,"6x14","LI-416x14",11.33,"Toe Kick Registers"]
["Finish Filter 16x20x4:","HW-FC100A1003",34.69,null,null,null,"2x10","LI-41F2X10",6.54]
["Finish Filter 20x20x4:","HW-FC100A1011",35.380000000000003,"Floor Return Grates",null,null,"2x12","LI-41F2X12",6.69]
[null,null,null,"6x12","LI-356x12",21.12]
["Return Air Grills",null,null,"6x14","LI-356x14",22.24]
["12x6","LI-19H12X6",5.88,"30x10","LI-3510x30",50.84]
["14x6","LI-19H14X6",4.4800000000000004,"30x12","LI-3512x30",62.37,"Soffit Caps"]
["24x6","LI-19H24X6",9.1199999999999992,"14X14","LI-3514X14",47.03,"Under-eve Vents","DE-EVE",7.85]
["30x6","LI-19H30X6",9.99]
["12x12","LI-19H12X12",10.32,"Condenser Pads",null,null,"2x2 Supply Lay-In"]
["30x10","LI-19H30X10",18.96,"6\" Adjust Pump-Ups","DV-HPR6-2P",5.46,"2x2x6\"","KR-1450F2306",65.5]
["30x12","LI-19H30x12",21.1,"24X24","P143-E2424",17.66,"2x2x8\"","KR-1450F2306",65.5]
["14x14","LI-19H14x14",12.87,"30X30","P143-E3030",27.78,"2x2x10\"","KR-1450F2310",65.5]
["16x16","LI-19H16x16",18.41,"32X32","P143-E3232",29.3,"2x2x12\"","KR-1450F2312",65.5]
["20x20","LI-19H20x20",17.23,"36X36","P143-E3636",35.14]
[null,null,null,null,null,null,"Return Lay-In (Perforated one piece)"]
["THERMOSTATS",null,null,"Wall Brackets",null,null,"2x2x6\"","KR-6690F2306",49.41]
["EcoBee 6","EB-STATE6IBR-01",229,"MiniSplit Wall Bracket","              QKS-QSWB2000",194.9,"2x2x8\"","KR-6690F2308",49.41]
["T6 Pro","HW-TH6210U2001",84,"36\" wall bracket","DV-ACB36",53.97,"2x2x10\"","KR-6690F2310",49.41]
["Bryant Smart Stat","TSTATBBEWF-01",90,"42\" wall bracket","DV-ACB42",55.01,"2x2x12\"","KR-6690F2312",50.76]
["Evolution Thermostat","SYSTXBBECC01-C",566,"48\" wall bracket","DV-ACB48",71.150000000000006,"2x2x14\"","KR-6690F2314",50.76]
["Evolution Smart Sensor","SYSTXBB4ZC01",466,"Minisplit Stand","QKS-QSMA1201",244.86]
["Santa Fe Dehum Controller","UA-DEH3000R",300.19,"18X38 Pad for Stand","P143-E1838",20.86]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2x2 Metal Return Box (for grid celing)",null,null,"Additional Items"]
["2x2 Supply Lay-in",null,null,"2x2 box (not insulated)",null,null,"Roll 1/8\"steel braided cable"]
["4\" neck",null,null,"2x2 box (insulated)",null,null,"Cable Locks for 1/8\" (Clutchers)"]
["6\" neck",null,null,"2x2 plastic egg crate",null,null,"10’- Unistrut-heavy guage "]
["7\" neck",null,null,null,null,null,"1 box 3/8th nuts"]
["8\" neck",null,null,null,null,null,"1 box 3/8ths washer"]
["10\" neck",null,null,null,null,null,"10’ - 3/8th threaded rod"]
["12\" neck"]
[]
["Radial Dampers for Lay-Ins"]
["PRN1006 - 6\""]
["PRN1008 - 8\""]
["PRN1010 - 10\""]
["PRN1012 - 12\""]
["PRN1014 - 14\""]

{"sheet":"Furnace","index":6,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[8,1,13,1],[4,1,6,1],[4,9,13,10],[21,1,25,1],[15,1,19,1],[27,9,47,10],[15,9,25,10],[27,1,37,1],[39,1,47,1],[39,3,39,4],[40,3,40,4],[47,3,47,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[36,3,36,4],[37,3,37,4],[30,3,30,4],[62,3,62,5],[63,3,63,5],[64,3,64,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[58,3,58,5],[59,3,59,5],[60,3,60,5],[61,3,61,5],[1,2,1,8],[50,2,50,6],[51,3,51,5],[52,3,52,5],[53,3,53,5],[27,3,27,4],[28,3,28,4],[29,3,29,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4]]}
[]
[null,null,"Bryant Condensing 90+ Furnaces "]
[]
[null,null,"Model Number","BTU Out (High)","BTU Out (Low)","Height","Depth","Width","Price"]
[null,"Preferred - 96% - 2-Stage Variable Speed Constant Torque ECM","926TC30040V14",39000,25000,"35\"","29 1/2\"","14\"",1932]
[null,null,"926TC36040V17",39000,25000,"35\"","29 1/2\"","17\"",1966]
[null,null,"926TC36060V14",58000,38000,"35\"","29 1/2\"","14\"",1997]
[null,null,null,null,null,null,null,null," "]
[null,"Preferred - 97% - 2-Stage Variable Speed Constant Torque ECM","927TA48060V17",58000,38000,"35\"","29 1/2\"","17\"",2286]
[null,null,"927TA48080V17",78000,50000,"35\"","29 1/2\"","17\"",2315]
[null,null,"927TA60080V21",78000,50000,"35\"","29 1/2\"","21\"",2380]
[null,null,"927TA60100V21",97000,63000,"35\"","29 1/2\"","21\"",2446]
[null,null,"927TA66100V21",97000,63000,"35\"","29 1/2\"","21\"",2639]
[null,null,"927TA66120V24",117000,76000,"35\"","29 1/2\"","24\"",2642]
[]
[null,"Evolution - Modulating - Up to 98% AFUE Variable Speed Constant Airflow ECM","987MC42060C17",59000,24000,"35\"","29 1/2\"","17\"",2824]
[null,null,"987MC42080C17",78000,31000,"35\"","29 1/2\"","17\"",2861]
[null,null,"987MC60080C21",78000,31000,"35\"","29 1/2\"","21\"",3100]
[null,null,"987MC66100C21",98000,39000,"35\"","29 1/2\"","21\"",3358]
[null,null,"987MC66120C24",117000,47000,"35\"","29 1/2\"","24\"",3544]
[]
[null,"Evolution - 97% - 2-Stage Variable Speed Constant Airflow ECM","987TA48060C17",58000,38000,"35\"","29 1/2\"","17\"",2575]
[null,null,"987TA48080C17",78000,50000,"35\"","29 1/2\"","17\"",2807]
[null,null,"987TA60080C21",78000,51000,"35\"","29 1/2\"","21\"",2910]
[null,null,"987TA66100C21",98000,63000,"35\"","29 1/2\"","21\"",3042]
[null,null,"987TA66120C24",117000,76000,"35\"","29 1/2\"","24\"",3252]
[]
[null,"Legacy 96% Multipoise Single Stage 18 Speed Constant Torque ECM","916SA30026M14",25000,null,"35\"","29 1/2\"","14\"",1539]
[null,null,"916SA30040M14",39000,null,"35\"","29 1/2\"","14\"",1550]
[null,null,"916SA36040M17",39000,null,"35\"","29 1/2\"","14\"",1575]
[null,null,"916SA36060M14",56000,null,"35\"","29 1/2\"","14\"",1595]
[null,null,"916SA48060M17",58000,null,"35\"","29 1/2\"","17\"",1617]
[null,null,"916SA48080M17",78000,null,"35\"","29 1/2\"","17\"",1787]
[null,null,"916SA60080M21",78000,null,"35\"","29 1/2\"","21\"",1795]
[null,null,"916SA60100M21",97000,null,"35\"","29 1/2\"","21\"",2021]
[null,null,"916SA66100M21",97000,null,"35\"","29 1/2\"","21\"",2208]
[null,null,"916SA66120M24",116000,null,"35\"","29 1/2\"","24\"",2245]
[null,null,"916SA66140M24",135000,null,"35\"","29 1/2\"","24\"",2301]
[]
[null,"Legacy 92% Multipoise Single Stage 18 Speed Constant Torque ECM","912SE36040M14",37000,null,"35\"","29 1/2\"","14\"",1538]
[null,null,"912SE36040M17",37000,null,"35\"","29 1/2\"","17\"",1541]
[null,null,"912SE36060M14",56000,null,"35\"","29 1/2\"","14\"",1585]
[null,null,"912SE42060M17",56000,null,"35\"","29 1/2\"","17\"",1626]
[null,null,"912SE48080M17",75000,null,"35\"","29 1/2\"","17\"",1733]
[null,null,"912SE60080M21",75000,null,"35\"","29 1/2\"","21\"",1801]
[null,null,"912SE60100M21",93000,null,"35\"","29 1/2\"","21\"",2001]
[null,null,"912SE66100M21",93000,null,"35\"","29 1/2\"","21\"",2162]
[null,null,"912SE60120M24",112000,null,"35\"","29 1/2\"","24\"",2167]
[]
[]
[null,null,"Furnace - Coil Transition Adapters"]
[null,null,"Item Number","Description",null,null,"Price"]
[null,null,"FAB-CAT-SMALL5","14-3/6\" x 17-1/2\" x 5\" Centered Transition",null,null,28]
[null,null,"FAB-CAT-SMALL5-FOS","14-3/6\" x 17-1/2\" x 5\" Flat On One Side",null,null,28]
[null,null,"FAB-CAT-SMALL5-ST","14-3/6\" x 14 3/16\" x 5\" Straight",null,null,28]
[]
[null,null,"FAB-CAT-MEDIUM5","17-1/2\" x 21\" x 5\" Centered Transition",null,null,28]
[null,null,"FAB-CAT-MEDIUM5-FOS","17-1/2\" x 21\" x 5\" Flat On One Side",null,null,28]
[null,null,"FAB-CAT-MEDIUM5-ST","17-1/2\" x 17 1/2\" x 5\" Straight",null,null,28]
[]
[null,null,"FAB-CAT-LARGE5","21\" x 24-1/2\" x 5\" Centered Transition",null,null,28]
[null,null,"FAB-CAT-LARGE5-FOS","21\" x 24-1/2\" x 5\" Flat On One Side",null,null,28]
[null,null,"FAB-CAT-LARGE5-ST","21\" x 21\" x 5\" Straight",null,null,28]
[]
[null,null,"FAB-CAT-XLARGE5-FOS","24 1/2\" x 24-1/2\" x 5\" Straight",null,null,28]

{"sheet":"Coil","index":7,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[4,1,24,1],[26,1,40,1],[42,1,55,1],[57,1,62,1],[1,2,1,7]]}
[]
[null,null,"Bryant R454B Evaporator Coils"]
[]
[null,null,"Model Number","Ton","Height","Width","Depth","Price"]
[null,"Puron Advance R454B Vertical Cased Vertical \"V\" Aluminum Coil with TXV","CVAVA1814XMA",1.5,"14-11/16","14\"","20-5/8",545]
[null,null,"CVAVA2414XMA",2,"14-11/16","14\"","20-5/8",588]
[null,null,"CVAVA2417XMA",2,"14-11/16","17\"","20-5/8",602]
[null,null,"CVAVA2517XMA",2,"19-7/16","17\"","20-5/8",938]
[null,null,"CVAVA3014XMA",2.5,"17-1/16","14\"","20-5/8",642]
[null,null,"CVAVA3017XMA",2.5,"19-7/16","17\"","20-5/8",642]
[null,null,"CVAVA3117XMA",2.5,"25-13/16","17\"","20-5/8",999]
[null,null,"CVAVA3617XMA",3,"19-7/16","17\"","20-5/8",687]
[null,null,"CVAVA3621XMA",3,"19-1/16","21\"","20-5/8",717]
[null,null,"CVAVA3721XMA",3,"21-15/16","21\"","20-5/8",870]
[null,null,"CVAVA3817XMA",3,"29-3/4","17\"","20-5/8",887]
[null,null,"CVAVA4217XMA",3.5,"19-1/4","17\"","20-5/8",720]
[null,null,"CVAVA4221XMA",3.5,"19-1/6","21\"","20-5/8",748]
[null,null,"CVAVA4224XMA",3.5,"26-5/16","24\"","20-5/8",803]
[null,null,"CVAVA4821XMA",4,"21-15/16","21\"","20-5/8",854]
[null,null,"CVAVA4824XMA",4,"22-1/16","24\"","20-5/8",881]
[null,null,"CVAVA4924XMA",4,"26-5/16","24\"","20-5/8",1032]
[null,null,"CVAVA6021XMA",5,"29-3/4","21\"","20-5/8",998]
[null,null,"CVAVA6024XMA",5,"26-5/16","24\"","20-5/8",1011]
[null,null,"CVAVA6121XMA",5,35,"21\"","20-5/8",1201]
[null,null,"CVAVA6124XMA",5,35,"24\"","20-5/8",1214]
[]
[null,"Puron Advance R454B Multipoise Cased Multi-Poise \"V\" Aluminum Coil with TXV","CVAMA2414XMA",2,"14-11/16","14\"","20-5/8",717]
[null,null,"CVAMA2417XMA",2,"14-11/16","17\"","20-5/8",726]
[null,null,"CVAMA2517XMA",2,"19-7/16","17\"","20-5/8",737]
[null,null,"CVAMA3017XMA",2.5,"19-7/16","17\"","20-5/8",787]
[null,null,"CVAMA3117XMA",2.5,"25-13/16","17\"","20-5/8",795]
[null,null,"CVAMA3217XMA",2.5,"29-3/4","17\"","20-5/8",1046]
[null,null,"CVAMA3617XMA",3,"19-7/16","17\"","20-5/8",859]
[null,null,"CVAMA4221XMA",3.5,"19-1/16","21\"","20-5/8",1009]
[null,null,"CVAMA4321XMA",3.5,"21-15/16","21\"","20-5/8",1022]
[null,null,"CVAMA4421XMA",3.5,"29-3/4","21\"","20-5/8",1226]
[null,null,"CVAMA4821XMA",4,"21-15/16","21\"","20-5/8",1073]
[null,null,"CVAMA4921XMA",4,"29-3/4","21\"","20-5/8",1083]
[null,null,"CVAMA6021XMA",5,"29-3/4","24\"","20-5/8",1193]
[null,null,"CVAMA6024XMA",5,"26-5/16","24\"","20-5/8",1204]
[null,null,"CVAMA6124XMA",5,35,"24\"","20-5/8",1363]
[]
[null,"Puron Advance R454B Multipoise Cased Multi-Poise  \"A\" Aluminum Coil with TXV","CAAMP2414AMA",2,"25-13/16","14\"","20-5/8",825]
[null,null,"CAAMP2417AMA",2,"25-13/16","17\"","20-5/8",836]
[null,null,"CAAMP2517AMA",2,"29-3/4","17\"","20-5/8",1006]
[null,null,"CAAMP3014AMA",2.5,"25-13/16","14\"","20-5/8",947]
[null,null,"CAAMP3017AMA",2.5,"25-13/16","17\"","20-5/8",958]
[null,null,"CAAMP3617AMA",3,"29-3/4","17\"","20-5/8",978]
[null,null,"CAAMP3717AMA",3,"25-3/16","17\"","20-5/8",1061]
[null,null,"CAAMP3721AMA",3,"29-3/4","17\"","20-5/8",1088]
[null,null,"CAAMP4221AMA",3.5,"29-3/4","21\"","20-5/8",1087]
[null,null,"CAAMP4321AMA",3.5,"29-3/4","21\"","20-5/8",1200]
[null,null,"CAAMP4821AMA",4,"29-3/4","21\"","20-5/8",1113]
[null,null,"CAAMP6024AMA",5,35,"24\"","20-5/8",1096]
[null,null,"CAAMP6121AMA",5,35,"21\"","20-5/8",1357]
[null,null,"CAAMP6124AMA",5,35,"24\"","20-5/8",1369]
[]
[null,"Puron Advance R454B Horizontal Cased Slab Coil","CSAHP2412AMA",2,"28-3/8","11-3/4","24-1/16",780]
[null,null,"CSAHP3012AMA",2.5,"28-3/8","11-3/4","24-1/16",890]
[null,null,"CSAHP3612AMA",3,"28-3/8","11-3/4","28-13/16",922]
[null,null,"CSAHP4212AMA",3.5,"28-3/8","11-3/4","28-13/16",1037]
[null,null,"CSAHP4812AMA",4,"30-3/8","11-3/4","28-13/16",1084]
[null,null,"CSAHP6012AMA",5,"30-3/8","11-3/4","38-15/16",1204]

{"sheet":"Air Handler","index":8,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,1,35,1],[30,10,35,11],[27,1,28,1],[27,10,28,11],[4,1,7,1],[9,1,12,1],[14,1,20,1],[22,1,25,1],[9,13,10,14],[3,10,7,11],[9,10,12,11],[14,10,25,11],[1,2,1,9]]}
[]
[null,null,"Bryant Fan Coils"]
[]
[null,null,"Model Number","Capacity","Height","Width","Depth","Filter Size","Coil Type","Price"]
[null,"Evolution Variable Speed Fan Coils with TXV and Filter","FE5BNXB24L00",2,"43\"","17\"","22\"","16 x 20","A",1978]
[null,null,"FE5BNXC36L00",3,"53\"","21\"","22\"","20 x 20","Slope",2210]
[null,null,"FE5BNXC48L00",4,"53\"","21\"","22\"","20 x 20","A",2594]
[null,null,"FE5BNBD60L00",5,"59\"","24\"","22\"","24 x 20","A",2837]
[]
[null,"Preferred Series Variable Speed Fan Coils with TXV and Filter - InteliSense Technology","FT5ANXB24L00",2,43,"17\"","22\"","16 x 20","A",1884,null,null,null,"Note: These Fan Coils use the KFFEH or Tutco EC Series Electric Heaters Only"]
[null,null,"FT5ANXC36L00",3,54,"21\"","22\"","20 x 20","Slope",2112]
[null,null,"FT5ANXC48L00",4,54,"21\"","22\"","20 x 20","A",2413]
[null,null,"FT5ANBD60L00",5,59,"24\"","22\"","24 x 20","A",2812]
[]
[null,"Legacy Series Fan Coils with TXV and Filter ","FJ5ANXA18L00",1.5,"43\"","14\"","22\"","13 X 20","Slope",1120]
[null,null,"FJ5ANXB24L00",2,"50\"","17\"","22\"","16 X 20","Slope",1221]
[null,null,"FJ5ANXB30L00",2.5,"50\"","17\"","22\"","16 X 20","A",1269]
[null,null,"FJ5ANXB36L00",3,"50\"","17\"","22\"","16 X 20","A",1504]
[null,null,"FJ5ANXC42L00",3.5,"54\"","21\"","22\"","20 x 20","A",1713]
[null,null,"FJ5ANXC48L00",4,"54\"","21\"","22\"","20 x 20","A",1938]
[null,null,"FJ5ANXD60L00",5,"59\"","24\"","22\"","24 X 20","A",2320]
[]
[null,"Multifamily/Apartment Wall-Hung Fan Coil with TXV and Filter","FMA5X1800AL",1.5,"37\"","21\"","15\"","16 x 20","Slope",1289]
[null,null,"FMA5X2400AL",2,"37\"","21\"","15\"","16 x 20","Slope",1352]
[null,null,"FMA5X3000AL",2.5,"37\"",22,"19\"","20 x 20","Slope",1412]
[null,null,"FMA5X3600AL",3,"37\"",22,"19\"","20 x 20","Slope",1498]
[]
[null,"45MBAA Multi Position Air Handler","45MBAAQ18XB3",1.5,"45\"","17\"","21\"","16 x 20",null,1766,"Use with 37MAHA or Multi ODU"]
[null,null,"45MBAAQ24XB3",2,"45\"","17\"","21\"","16 x 20",null,1797]
[]
[null,"45MUAA Multi Position Air Handler (NextGen)","45MUAAQ18XX3 ",1.5,"45\"","17\"","21\"","16 x 20",null,1522,{"$error":"#VALUE!"}]
[null,null,"45MUAAQ24XX3 ",2,"45\"","17\"","21\"","16 x 20",null,1547]
[null,null,"45MUAAQ30XX3 ",2.5,"49\"","21\"","21\"","16 x 20",null,1691]
[null,null,"45MUAAQ36XX3 ",3,"49\"","21\"","21\"","20 x 20",null,1767]
[null,null,"45MUAAQ48XX3 ",4,"53\"","21\"","21\"","20 x 20",null,1718]
[null,null,"45MUAAQ60XX3",5,"53\"","24\"","21\"","20 x 20",null,1815]

{"sheet":"Geothermal","index":9,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,3,33,7],[35,1,36,1],[35,3,35,7],[36,3,36,7],[4,1,8,1],[10,1,13,1],[15,1,19,1],[21,1,24,1],[29,1,30,1],[29,3,29,7],[30,3,30,7],[27,2,27,7],[31,2,31,13],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[3,9,24,10],[17,4,17,5],[17,6,17,7],[18,4,18,5],[18,6,18,7],[19,4,19,5],[19,6,19,7],[15,4,15,5],[15,6,15,7],[16,4,16,5],[16,6,16,7],[11,4,11,5],[11,6,11,7],[12,4,12,5],[12,6,12,7],[13,4,13,5],[13,6,13,7],[1,2,1,8],[10,4,10,5],[10,6,10,7]]}
[]
[null,null,"Bryant R454B Geothermal Units"]
[]
[null,null,"Model Number","Tons","Cabinet","Discharge","COAX","Hot Water Generator","Price"]
[null,"Evolution Package Unit - 2 stage - Variable Speed w/ dissapation system","GCA24VTLCDET1DX1",2,"Vertical","Top","Copper","Yes",6455]
[null,null,"GCA36VTLCDET1DX1",3,"Vertical","Top","Copper","Yes",7202]
[null,null,"GCA48VTLCDET1DX1",4,"Vertical","Top","Copper","Yes",7834]
[null,null,"GCA60VTLCDET1DX1",5,"Vertical","Top","Copper","Yes",8672]
[null,null,"GCA72VTLCDET1DX1",6,"Vertical","Top","Copper","Yes",8880]
[]
[null,"Evolution Split Unit - 2 stage w/ dissapation system","GZ024SAXCDXX1DX1",2,"Copper",null,"Yes",null,5049]
[null,null,"GZ036SAXCDXX1DX2",3,"Copper",null,"Yes",null,5688]
[null,null,"GZ048SAXCDXX1DX1",4,"Copper",null,"Yes",null,6225]
[null,null,"GZ060SAXCDXX1DX1",5,"Copper",null,"Yes",null,6677]
[]
[null,"Evolution Split Unit - 2 stage w/ dissapation system","GZ024SAXNDXX1DX1",2,"Cupro-Nickel",null,"Yes",null,5337]
[null,null,"GZ036SAXNDXX1DX2",3,"Cupro-Nickel",null,"Yes",null,6071]
[null,null,"GZ048SAXNDXX1DX1",4,"Cupro-Nickel",null,"Yes",null,6739]
[null,null,"GZ060SAXNDXX1DX1",5,"Cupro-Nickel",null,"Yes",null,7185]
[null,null,"GZ072SAXNDXX1DX1",6,"Cupro-Nickel",null,"Yes",null,7196]
[]
[null,"Packaged Unit Electric Heaters","KWCEH0301N05","5 kw Electric Heater Non-fused - All Sizes",null,null,null,null,454]
[null,null,"KWCEH0301N10","10 kw Electric Heater Non fused - All Sizes",null,null,null,null,690]
[null,null,"KWCEH0301B15","15 kw Electric Heater w/circuit breaker - 36 thru 72 Sizes Only",null,null,null,null,693]
[null,null,"KWCEH0301B20","20 kw Electric Heater w/circuit breaker - 48 thru 72 sizes Only",null,null,null,null,737]
[]
[]
[null,null,"Geothermal Accessories"]
[]
[null,"Flow Centers","FCP11CD","1 pump flow center",null,null,null,null,746]
[null,null,"FCP21CD","2 pump flow center",null,null,null,null,1010]
[]
[]
[null,"Hose Kit","HK4DM","1-in Hose Kit (Flo-Link Double O-ring @ Flow Center; MPT @ HP)",null,null,null,null,221]
[]
[null,"Rubber Mounting Pad","ACMP2436","3/4-in. high density rubber equipment pad, 24-in. x 36-in.",null,null,null,null,105]
[null,null,"ACMP2836","3/4-in. high density rubber equipment pad, 28-in. x 36-in.",null,null,null,null,142]

{"sheet":"Heater Pack","index":10,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":false,"merged":[[30,1,35,1],[37,1,40,1],[4,1,7,1],[17,1,19,1],[21,1,24,1],[26,1,28,1],[11,1,15,1],[51,9,51,11],[52,9,52,11],[49,9,49,11],[50,9,50,11],[1,2,1,5],[47,9,47,11],[48,9,48,11],[19,2,19,5]]}
[]
[null,null,"ELECTRIC HEATERS FOR BRYANT FAN COIL UNITS"]
[]
[null,null,"Tutco Number","Factory Number","Description - Heaters to be used on FE5, FT5, FJ5 Units Only"]
[null,"FJ5DNXA18","TU-EC-03CKN","KFFEH8401N03","3kw Heater  230v-1ph *USED ON FJ5DNXA18 Only!*",124]
[null,null,"TU-EC-05CKB","KFFEH8401C05","5kw Heater w/ C/B Protection - 230v-1ph *USED ON FJ5DNXA18 Size Only!*",214]
[null,null,"TU-EC-08CKB","KFFEH8501C08","8kw Heater w/ C/B Protection - 230v-1ph *USED ON FJ5DNXA18 Size Only!*",238]
[null,null,"TU-EC-10CKB","KFFEH8601C10","10kw Heater w/ C/B Protection - 230v-1ph *USED ON FJ5DNXA18 Size Only!*",246]
[]
[null,"FJ5DNXA24 ONLY","TU-EC-03BKN","KFFEH0401N03","3kw Heater - 230v-1ph* Used on 24 Size Only*",110]
[]
[null,"24-60 Size Units    (FE5, FT5, FJ5) ","TU-EC-05BKB","KFFEH2401C05","5kw Heater w/ C/B Protection - 230v-1ph *Used on 24-60 Size units*",173]
[null,null,"TU-EC-08BKB","KFFEH2501C08","8kw Heater w/ C/B Protection - 230v-1ph *Used on 24-60 Size units*",204]
[null,null,"TU-EC-10BKB","KFFEH2601C10","10kw Heater w/ C/B Protection - 230v-1ph *Used on 24-60 Size units*",210]
[null,null,"TU-EC-15BKB","KFFEH3101C15","15kw Heater w/ C/B Protection -230v-1ph *Used on 24-60 Size Units*",353]
[null,null,"TU-EC-20BKB","KFFEH3301C20","20kw Heater w/ C/B Protection - 230v-1ph *Used on 30-60 Size Units*",446]
[]
[null,"36-60 Size Units       (FE5, FT5, FJ5)                3 PHASE","TU-EC-15BHN","KFFEH1601315","15kw Heater - 230v- 3 PHASE - *Used on 36-60 Size Units*",272]
[null,null,"TU-EC-18BHN","KFFEH2001318","15kw Heater - 230v- 3 PHASE - *Used on 42-60 Size Units*",467]
[null,null,"THE TWO LISTED ABOVE ARE -----****3 PHASE*****--------"]
[]
[null,"48-60 Size Units       (FE5, FT5, FJ5)           (Can be 1 or 3 phase)","TU-EC-25BHCF","KFFEH3401F24","24kw Heater w/ Fuse Protection -230v-3ph *Used on 48-60 Size Units*",674]
[null,null,null,null,"(Convertible  to 1 phase)"]
[null,null,"TU-EC-30BHCF","KFFEH3501F30","30kw Heater w/ Fuse Protection -230v-3ph )*Used on 48-60 Size Units*",698]
[null,null,null,null,"(Convertible  to 1 phase)"]
[]
[null,"FMA5 Units Only       MultiFamily Units","TU-HK2-05B","EHK2-05B ","5 kw Electric Heater w/circuit breaker",113]
[null,null,"TU-HK2-08B","EHK2-08B ","7.5 kw Electric Heater w/circuit breaker",126]
[null,null,"TU-HK2-10B","EHK2-10B ","10 kw Electric Heater w/circuit breaker",141]
[]
[null,"45MBAA and 45MUAA Only","EHKMC05KN","For 45MUAA or 45MBAA ONLY","5kw Electric Heater - Air Handler Sizes 18,24,30,36",{"$f":"VLOOKUP(C31,'[1]Cover Page'!$P$1:$Q304,2,FALSE)","v":178}]
[null,null,"EHKMC08KN","For 45MUAA or 45MBAA ONLY","8kw Electric Heater - Air Handler Sizes 18,24,30,36,48 ",{"$f":"VLOOKUP(C32,'[1]Cover Page'!$P$1:$Q305,2,FALSE)","v":228}]
[null,null,"EHKMC10KN","For 45MUAA or 45MBAA ONLY","10kw Electric Heater - Air Handler Sizes 18,24,30,36,48,60",{"$f":"VLOOKUP(C33,'[1]Cover Page'!$P$1:$Q306,2,FALSE)","v":251}]
[null,null,"EHKMC15KN","For 45MUAA or 45MBAA ONLY","15kw Electric Heater - Air Handler Size 24,30,36,48,60 ",{"$f":"VLOOKUP(C34,'[1]Cover Page'!$P$1:$Q307,2,FALSE)","v":388}]
[null,null,"EHKMC20KN","For 45MUAA or 45MBAA ONLY","20kw Electric Heater - Air Handler Size 36,48,60 ",{"$f":"VLOOKUP(C35,'[1]Cover Page'!$P$1:$Q308,2,FALSE)","v":458}]
[null,null,"EHKMC25KN","For 45MUAA or 45MBAA ONLY","25kw Electric Heater - Air Handler Size 60 ",{"$f":"VLOOKUP(C36,'[1]Cover Page'!$P$1:$Q309,2,FALSE)","v":556}]
[]
[null,"Geothermal Package Unit Only","KWCEH0301N05","GCA Units ONLY","5 kw Electric Heater Non-fused - All Sizes",454]
[null,null,"KWCEH0301N10","GCA Units ONLY","10 kw Electric Heater Non fused - All Sizes",690]
[null,null,"KWCEH0301B15","GCA Units ONLY","15 kw Electric Heater w/circuit breaker - 36 thru 72 Sizes Only",693]
[null,null,"KWCEH0301B20","GCA Units ONLY","20 kw Electric Heater w/circuit breaker - 48 thru 72 sizes Only",737]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Fan Coil Accessories"]
[null,null,"KFASP0101SPK",null,"Single Point Wiring Kit (Used on KFFEH 15kw & 20kw Fused Heaters Only)",33]
[]
[null,null,"KFADC0201SLP",null,"Downflow Conversion Kit (Slope Coil Units)",36]
[null,null,"KFADC0401ACL",null,"Downflow Conversion Kit (\"A\" Coil Units)",129]
[null,null,"KFAHD0101SLP",null,"Downflow/Horizontal Conversion Gasket Kit",12]
[]
[null,null,"AFAINTHWC01A",null,"Hydronic Relay Kit - FE4/5",161]
[]
[null,null,"KFACB0101CFB",null,"Downflow Base Kit, 14-5/16\" Wide Fan Coils",108]
[null,null,"KFACB0201CFB",null,"Downflow Base Kit, 17-5/8\" Wide Fan Coils",108]
[null,null,"KFACB0301CFB",null,"Downflow Base Kit, 21-1/8\" Wide Fan Coils",125]
[null,null,"KFACB0401CFB",null,"Downflow Base Kit, 24-11/16\" Wide Fan Coils",133]

{"sheet":"Misc","index":11,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[31,0,44,0],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[30,1,30,5],[14,0,28,0],[19,1,19,2],[20,1,20,2],[21,1,21,2],[23,1,23,2],[18,1,18,2],[22,1,22,2],[1,1,1,5],[2,0,11,0],[2,1,2,2],[7,1,7,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[11,1,11,2],[48,3,48,5],[13,1,13,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2]]}
[]
[]
["Bottom Boxes","FURNACE",null,"DESCRIPTION","ITEM NUMBER","COST"]
[null,"14\"",null,"Bottom Box for 14\" wide furnace","ST-96-142824",81.99]
[null,"17\"",null,"Bottom box for 17\" wide furnace","ST-96-172824",76.680000000000007]
[null,"21\"",null,"Bottom box for 21\" wide furnace","ST-96-212824",76.680000000000007]
[null,"24\"",null,"Bottom box for 24\" wide furnace","ST-96-242824",94.57]
[null,"AIR HANDLER"]
[null,"14\"",null,"Bottom box for 14\" wide x 22\" deep AH","ST-96-142224",80.16]
[null,"17\"",null,"Bottom box for 17\" wide x 22\" deep AH","ST-96-172224",83.75]
[null,"21\"",null,"Bottom box for 21\" wide x 22\" deep AH","ST-96-212224",69.67]
[null,"24\"",null,"Bottom box for 24\" wide x 22\" deep AH","ST-96-242224",81.489999999999995]
[]
[]
["Plenums","FURNACE",null,"DESCRIPTION","ITEM NUMBER","COST"]
[null,"14\"",null,"FURANCE 47\" PLENUM 14 IN","ST-95-121947",102.49]
[null,"17\"",null," FURNACE 47\" PLENUM 17 IN","ST-95-161947",107.05]
[null,"21\"",null," FURNACE 47\" PLENUM 21 IN","ST-95-191947",114.3]
[null,"24\"",null," FURNACE 47\" PLENUM 24 IN","ST-95-231947",123.48]
[null,"AIR HANDLER"]
[null,"14\"",null,"AH 47\" PLENUM 14 IN","ST-95-131147",78.849999999999994]
[null,"17\"",null," AH 47\" PLENUM 17 IN","ST-95-161147",89.34]
[null,"21\"",null," AH 47\" PLENUM 21 IN","ST-95-191147",99.22]
[null,"24\"",null,"AH 47\" PLENUM 24 IN","ST-95-231147",111.43]
[null,"COIL"]
[null,"14\"",null,"47\" PLENUM 14 IN","ST-95-121947",102.49]
[null,"17\"",null,"47\" PLENUM 17 IN","ST-95-161947",107.05]
[null,"21\"",null,"47\" PLENUM 21 IN","ST-95-191947",114.3]
[null,"24\"",null,"47\" PLENUM 24 IN","ST-95-231947",123.48]
[]
[]
["Coil Adapter/Spacer","FURNACE WIDTH","COIL WIDTH","DESCRIPTION","ITEM NUMBER","COST"]
[null,"14\"","17\"","14\" x 17\" x 5\" centered","FAB-CAT-SMALL5",28]
[null,"14\"","17\"","14\" x 17\" x 5\" flat one side","FAB-CAT-SMALL5-FOS",28]
[null,"14\"","14\"","14\" x 14\" x 5\" spacer","FAB-CAT-SMALL5-ST",28]
[]
[null,"17\"","21\"","17\" x 21\" x 5\" centered","FAB-CAT-MEDIUM5",28]
[null,"17\"","21\"","17\" x 21\" x 5\" flat one side","FAB-CAT-MEDIUM5-FOS",28]
[null,"17\"","17\"","17\" x 17\" x 5\" spacer","FAB-CAT-MEDIUM5-ST",28]
[]
[null,"21\"","24\"","21\" x 24\" x 5\" centered","FAB-CAT-LARGE5",28]
[null,"21\"","24\"","21\" x 24\" x 5\" flat one side","FAB-CAT-LARGE5-FOS",28]
[null,"21\"","21\"","21\" x 21\" x 5\" spacer","FAB-CAT-LARGE5-ST",28]
[]
[null,"24\"","24\"","24\" x 24\" x 5\" spacer","FAB-CAT-XLARGE5-FOS",28]
[]
[]
[]
[null,null,null,"BLACK IRON FITTINGS"]
[null,null,null,"1/2\" BLACK CAP","PF-CAP1/2",1.7]
[null,null,null,"1/2\" BLACK COUPLING","PF-COUP1/2",2.2999999999999998]
[null,null,null,"BLACK IRON NIPPLE 1/2\" X 12\" ","PF-NIPPLE1/2X12",5.34]
[null,null,null,"BLACK IRON NIPPLE 1/2\" X 8\"","PF-NIPPLE1/2X8",3.75]
[null,null,null,"1/2\" BLACK TEE","PF-T1/2",2.33]
[null,null,null,"1/2\" BLACK UNION","PF-UN1/2",7.52]
[null,null,null,"1/2\" BLACK ST 90","PF-90ST1/2",1.85]
[null,null,null,"1/2\" BLACK 90","PF-901/2",1.7]

{"sheet":"Dropdown Lists","index":12,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Family","Size From","Size To","Part Number","Description / Notes","Phase","DROPDOWN ENGINE  —  do not edit",null,null,"3-phase packs (red)"]
["FJ5",18,18,"TU-EC-03CKN","3kw 230v-1ph — FJ5 size 18 only","1PH",null,null,null,{"$f":"_xlfn._xlws.FILTER(HeaterPacks[Part Number],HeaterPacks[Phase]=\"3PH\")","v":"TU-EC-15BHN"}]
["FJ5",18,18,"TU-EC-05CKB","5kw w/CB 230v-1ph — FJ5 size 18 only","1PH","Air Handler tons (B10)",{"$f":"IFERROR(_xlfn.XLOOKUP('Rough In'!B10,'Air Handler'!$C:$C,'Air Handler'!$D:$D),\"\")","v":0},null,"TU-EC-18BHN"]
["FJ5",18,18,"TU-EC-08CKB","8kw w/CB 230v-1ph — FJ5 size 18 only","1PH","Geo unit tons (B11)",{"$f":"IFERROR(_xlfn.XLOOKUP('Rough In'!B11,Geothermal!$C:$C,Geothermal!$D:$D),\"\")","v":0},null,"TU-EC-25BHCF"]
["FJ5",18,18,"TU-EC-10CKB","10kw w/CB 230v-1ph — FJ5 size 18 only","1PH","Air handler family",{"$f":"IF(LEFT('Rough In'!B11,3)=\"GCA\",\"GCA\",_xlfn.IFS(LEFT('Rough In'!B10,4)=\"FMA5\",\"FMA5\",LEFT('Rough In'!B10,6)=\"45MBAA\",\"45MBAA\",LEFT('Rough In'!B10,6)=\"45MUAA\",\"45MUAA\",LEFT('Rough In'!B10,3)=\"FE5\",\"FE5\",LEFT('Rough In'!B10,3)=\"FT5\",\"FT5\",LEFT('Rough In'!B10,3)=\"FJ5\",\"FJ5\",TRUE,\"\"))","v":""},null,"TU-EC-30BHCF"]
["FJ5",24,24,"TU-EC-03BKN","3kw 230v-1ph — FJ5 size 24 only","1PH","Nominal size",{"$f":"IF(H5=\"GCA\",IFERROR(H4*12,\"\"),IFERROR(H3*12,\"\"))","v":0}]
["FE5,FT5,FJ5",24,60,"TU-EC-05BKB","5kw w/CB 230v-1ph — sizes 24-60","1PH"]
["FE5,FT5,FJ5",24,60,"TU-EC-08BKB","8kw w/CB 230v-1ph — sizes 24-60","1PH","Compatible packs ▼",{"$f":"IF(OR(H5=\"\",H6=\"\"),\"\",IFERROR(_xlfn._xlws.FILTER(HeaterPacks[Part Number],ISNUMBER(SEARCH(H5,HeaterPacks[Family]))*(HeaterPacks[Size From]<=H6)*(HeaterPacks[Size To]>=H6)),\"\"))","v":""}]
["FE5,FT5,FJ5",24,60,"TU-EC-10BKB","10kw w/CB 230v-1ph — sizes 24-60","1PH"]
["FE5,FT5,FJ5",24,60,"TU-EC-15BKB","15kw w/CB 230v-1ph — sizes 24-60","1PH"]
["FE5,FT5,FJ5",30,60,"TU-EC-20BKB","20kw w/CB 230v-1ph — sizes 30-60","1PH"]
["FE5,FT5,FJ5",36,60,"TU-EC-15BHN","15kw 230v-3ph — sizes 36-60","3PH"]
["FE5,FT5,FJ5",42,60,"TU-EC-18BHN","15kw 230v-3ph — sizes 42-60","3PH"]
["FE5,FT5,FJ5",48,60,"TU-EC-25BHCF","24kw 230v-3ph (convertible to 1ph) — sizes 48-60","3PH"]
["FE5,FT5,FJ5",48,60,"TU-EC-30BHCF","30kw 230v-3ph (convertible to 1ph) — sizes 48-60","3PH"]
["FMA5",18,36,"TU-HK2-05B","5kw w/CB — FMA5 units","1PH"]
["FMA5",18,36,"TU-HK2-08B","7.5kw w/CB — FMA5 units","1PH"]
["FMA5",18,36,"TU-HK2-10B","10kw w/CB — FMA5 units","1PH"]
["45MBAA,45MUAA",18,36,"EHKMC05KN","5kw — sizes 18,24,30,36","1PH"]
["45MBAA,45MUAA",18,48,"EHKMC08KN","8kw — sizes 18,24,30,36,48","1PH"]
["45MBAA,45MUAA",18,60,"EHKMC10KN","10kw — sizes 18,24,30,36,48,60","1PH"]
["45MBAA,45MUAA",24,60,"EHKMC15KN","15kw — sizes 24,30,36,48,60","1PH"]
["45MBAA,45MUAA",36,60,"EHKMC20KN","20kw — sizes 36,48,60","1PH"]
["45MBAA,45MUAA",60,60,"EHKMC25KN","25kw — size 60 only","1PH"]
["GCA",24,72,"KWCEH0301N05","5kw non-fused — all GCA sizes","1PH"]
["GCA",24,72,"KWCEH0301N10","10kw non-fused — all GCA sizes","1PH"]
["GCA",36,72,"KWCEH0301B15","15kw w/CB — sizes 36-72","1PH"]
["GCA",48,72,"KWCEH0301B20","20kw w/CB — sizes 48-72","1PH"]
[]
[]
[]
["Labor Estimate "]
["System Types Dropdown"]
["Lower Level Left System:"]
["Lower Level Middle System:"]
["Lower Level Right System:"]
["Lower Level System:"]
["2nd Floor System:"]
["Attic System:"]
["Crawl Space System:"]
["Horizontal System:"]
["1st Floor System:"]
["3rd Floor System:"]
["Zoned System:"]
["Mini Split System:"]