{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","1. Project Details","2. Heat Loss Calculator","IR System Selection","Tube Htr Kits","X-Ref Tubes- Straight","X-Ref Tubes -\"U\"","X-Ref High Intensity","1","2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":62,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"InfraSave Tools"]
[]
[null,"We are providing these tools to help you select the best InfraSave product solution for your application."]
[]
[null,"Heat Loss Calculator Tool: (2 parts)","This tool helps select gas-fired radiant heaters for your customer's project. "]
[null,"1. Enter Project Details","FIRST: Go to the Project Details sheet and enter required project information as the first step in calculating Heat Loss"]
[null,"                              click here:"]
[null,"2. Calculate Heat Loss","SECOND: Go to the Heat Loss sheet (InfraCalc©) and select the proper building material"]
[null,"                              click here:","THIRD: Continue on to the Heater & Model Selection Tools below"]
[]
[null,"Heater & Model Selection Tools"]
[null,"To select an IR System, ","CONTRACTOR knows the total input of current equipment to be replaced --> the required input of radiant heaters is calculated"]
[null,"                              click here:","If the customer's fuel cost rate is known, the relative operating cost of each system can also be calculated"]
[null,"To select Tube Heater Kits:  ","Based upon the application and model selected: provides the proper Burner Kits, Tube Kits and their part numbers"]
[null,"                        click here:","Optional & recommended accessories are also indicated"]
[]
[null,"Cross References of Competitive Heater Systems"]
[null,"Tubes - Straight:","A cross reference of 'Straight' tube heater systems on the market"]
[null,"Tubes - 'U':","A cross reference of 'U'-tube style tube heater models on the market"]
[null,"High Intensity:","A cross reference of high intensity ceramic burner heater models on the market"]

{"sheet":"1. Project Details","index":1,"n_rows":226,"n_cols":18,"rows_kept":226,"cut":false,"hidden":false,"merged":[[17,2,17,5],[52,2,52,3],[16,2,16,5],[5,2,5,3],[13,2,13,5],[14,2,14,5],[15,2,15,5],[53,2,53,3],[54,2,54,3],[55,2,55,3],[60,8,62,13],[40,8,40,9],[48,8,50,10],[51,8,51,9],[57,5,58,6],[56,2,56,3],[57,2,57,3]]}
[]
[]
[null,"Heat Loss Calculator - Step 1: Project Details"]
[]
[]
[null,"Project Country*","USA"]
[]
[]
[null,"PROJECT PROFILE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metric Units"]
[]
[null,"Quote / Project File # / Date",{"$f":"NOW()","v":"2015-09-08T08:45:20.630"}]
[null,"Main Project Name*   "]
[null,"Project Sub-Name  ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C57=\"\",C22,C57)","v":68},"Natural Gas",{"$f":"IF(K39=\"-\",\"-\",IF(K39=\"1000 cu ft\",1000000,IF(K39=\"Therm\",100000,35310)))","v":35310}]
[null,"City*  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Propane",{"$f":"IF(K39=\"-\",\"-\",IF(K39=\"Gallon\",91523,IF(K39=\"litre\",24180,0)))","v":0}]
[null,{"$f":"IF(C6=\"USA\",\"State*  \",\"Prov*\")","v":"State*  "}]
[]
[null,"DESIGN PARAMETERS - Information required to calculate a heat loss"]
[null,"Design temperatures: Outside",0,"°F",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C53=\"\",C25,C53)","v":0},"-"]
[null,"Inside",68,"°F",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C54=\"scroll to select\",C54=\"\",C54=\" \"\"\"),C26,C54)","v":"SELECT"},{"$f":"IF(C6=\"CANADA\",IF(O35=1,\"cu m\",\"litre\"),IF(O35=1,\"Therm\",\"Gallon\"))","v":"Gallon"},"Mr."]
[null,{"$f":"IF(C23=0,\"Length of area to heat\",\"Length\")","v":"Length of area to heat"},0," ft",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"CANADA\",\"\",IF(O35=1,\"1000 cu ft\",\"\"))","v":""},"Mrs."]
[null,{"$f":"IF(C24=0,\"Width of area to heat\",\"Width\")","v":"Width of area to heat"},0," ft",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G51=1,\"57°F\",\"14°C (57°F)\")","v":"57°F"},null,"Ms."]
[null,"Avg. building height",0," ft",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G51=1,\"55°F\",\"13°C (55°F)\")","v":"55°F"}]
[null,"Infiltration tightness  ","SELECT",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$51=1,\"65°F\",\"18°C (65°F)\")","v":"65°F"}]
[null,"Air change/hr  ",{"$f":"C77","v":0}," x bldg vol.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$51=1,\"60°F\",\"15°C (60°F)\")","v":"60°F"},"USA"]
[null,"Gross building volume  ",{"$f":"C23*C24*O21","v":0},{"$f":"I36","v":" ft³"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$51=1,\"50°F\",\"10°C (50°F)\")","v":"50°F"},"CANADA"]
[null,"Other heat gain?  ",0," Btuh",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$51=1,\"45°F\",\"7°C (45°F)\")","v":"45°F"}]
[]
[null,"PROCESS FANS and COLD STUFF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$51=1,\"40°F\",\"4°C (40°F)\")","v":"40°F"}]
[null,"Process Ventilation  ",0," cfm"]
[null,"Fan duration  ",0," min/hr",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K38=\"Natural Gas\",1,3)","v":3}]
[null,"Mech'l Vent =  ",{"$f":"C34*C35","v":0}," cfh",null,null,null,null," ft³"," m³",null,null,null,null,{"$f":"IF(K38=\"Natural Gas\",\"NG\",\"LP\")","v":"LP"}]
[null,"Cold materials  ",0," lb/hr",null,null,null,null,{"$f":"IF($C$6=\"CANADA\",\"0\",\" \")","v":" "}]
[null,"Specific heat of material  ",0]
[null,"Cold vehicle losses  ",0," Btuh",null,null,{"$f":"IF($C$6=\"CANADA\",0,\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"ISNUMBER(C55)","v":false}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Air Change:",null,{"$f":"LEN(B71)","v":1},{"$f":"IF(D71<5,5,IF(D70=4,D71,IF(D70=5,D72,IF(D70=6,D73,IF(D70>=7,D76)))))","v":5},null,null,null,"-",null," "]
[null,{"$f":"ROUND(C28,0)","v":0},"cu ft",{"$f":"ROUND($B$71/1000,0)","v":0}]
[null,"SELECT",null,{"$f":"ROUND($B$71/10000,0)*10","v":0},null,null,null,null,null,null,null,null,null," - Well exceeds 35% minimum ANSI standard and any competitors",null,null,null," - High IR coefficient allows calculated heat loss reduction from 16 to 20%"]
[null,"TIGHT",null,{"$f":"IF(B71>500000,D75,IF(B71>200000,D74,ROUND($B$71/2000,-1)*2))","v":0},null,null,null,null,null,null,null,null,null," - Well exceeds 35% minimum ANSI standard and any competitors",null,null,null," - Higher IR coefficient allows calculated heat loss reduction from 25 to 30%"]
[null,"AVERAGE",null,{"$f":"ROUND($B$71/5000,-1)*5","v":0},null,null,null,null,null,null,null,null,null," - Well exceeds 35% minimum ANSI standard and any competitors",null,null,null," - Highest IR coefficient allows calculated heat loss reduction from 35 to 41.5%"]
[null,"LOOSE",null,{"$f":"ROUND($B$71/1000,-2)","v":0}]
[null,null,null,{"$f":"IF(B71>5000000,5000,IF(B71>2000000,D77,ROUND($B$71/2000,-2)*2))","v":0}]
[null,{"$f":"O22&E70","v":"SELECT5"},{"$f":"IF(C26=\"SELECT\",0,VLOOKUP(B77,B79:C226,2,FALSE))","v":0},{"$f":"ROUND($B$71/5000,-2)*5","v":0},null,null,null,null,null,null,null,null,null," - Highest radiant heat output allows up to 27% reduction of calculated heat loss",null,null,null," - Direct vented; 4\" dia. vent; can be paired using 4\" x 4\" x 6\" Vent Tee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," - Higher radiant heat output allows up to 20% reduction of calculated heat loss",null,null,null," - Direct vented; 4\" dia. vent; can be paired using 4\" x 4\" x 6\" Vent Tee"]
[null,null," ",null,null,null,null,null,null,null,null,null,null," - Good radiant heat output allows up to 18% reduction of calculated heat loss",null,null,null," - Direct vented; 4\" dia. vent; can be paired using 4\" x 4\" x 6\" Vent Tee"]
[null,{"$f":"B$75&5","v":"LOOSE5"},1.7,null,null,null,null,null,null,null,null,null,null," - Good radiant heat output allows up to 18% reduction of calculated heat loss",null,null,null," - Direct vented; 4\" dia. vent; can be paired using 4\" x 4\" x 6\" Vent Tee"]
[null,{"$f":"B$75&6","v":"LOOSE6"},1.68,null,null,null,null,null,null,null,null,null,null," - Good radiant heat output allows up to 18% reduction of calculated heat loss"," - Good radiant heat output allows up to 18% reduction of calculated heat loss",null,null," - Many features and same ceramic burner as Premier model"]
[null,{"$f":"B$75&7","v":"LOOSE7"},1.66,null,null,null,null,null,null,null,null,null,null," - Good radiant heat output allows up to 18% reduction of calculated heat loss"," - Good radiant heat output allows up to 18% reduction of calculated heat loss",null,null," - Many features and same ceramic burner as Premier model"]
[null,{"$f":"B$75&8","v":"LOOSE8"},1.64,null,null,null,null,null,null,null,null,null,null,"       - Also available with all Stainless Steel tube & reflector system",null,null,null," - Ceramic burner produces longest flame = most uniform heat output"]
[null,{"$f":"B$75&9","v":"LOOSE9"},1.62,null,null,null,null,null,null,null,null,null,null," - Ceramic burner produces longest flame = most uniform heat output",null,null,null," - Direct vented; 4\" dia. vent; can be paired using 4\" x 4\" x 6\" Vent Tee"]
[null,{"$f":"B$75&10","v":"LOOSE10"},1.6]
[null,{"$f":"B$75&12","v":"LOOSE12"},1.575]
[null,{"$f":"B$75&14","v":"LOOSE14"},1.55]
[null,{"$f":"B$75&16","v":"LOOSE16"},1.52]
[null,{"$f":"B$75&18","v":"LOOSE18"},1.4950000000000001]
[null,{"$f":"B$75&20","v":"LOOSE20"},1.47]
[null,{"$f":"B$75&25","v":"LOOSE25"},1.4550000000000001]
[null,{"$f":"B$75&30","v":"LOOSE30"},1.42]
[null,{"$f":"B$75&35","v":"LOOSE35"},1.385]
[null,{"$f":"B$75&40","v":"LOOSE40"},1.35]
[null,{"$f":"B$75&45","v":"LOOSE45"},1.3149999999999999]
[null,{"$f":"B$75&50","v":"LOOSE50"},1.28]
[null,{"$f":"B$75&60","v":"LOOSE60"},1.24]
[null,{"$f":"B$75&70","v":"LOOSE70"},1.21]
[null,{"$f":"B$75&80","v":"LOOSE80"},1.17]
[null,{"$f":"B$75&90","v":"LOOSE90"},1.1499999999999999]
[null,{"$f":"B$75&100","v":"LOOSE100"},1.1299999999999999]
[null,{"$f":"B$75&120","v":"LOOSE120"},1.1000000000000001]
[null,{"$f":"B$75&140","v":"LOOSE140"},1.08]
[null,{"$f":"B$75&160","v":"LOOSE160"},1.06]
[null,{"$f":"B$75&180","v":"LOOSE180"},1.04]
[null,{"$f":"B$75&200","v":"LOOSE200"},1.02]
[null,{"$f":"B$75&250","v":"LOOSE250"},1.0049999999999999]
[null,{"$f":"B$75&300","v":"LOOSE300"},0.97]
[null,{"$f":"B$75&350","v":"LOOSE350"},0.93500000000000005]
[null,{"$f":"B$75&400","v":"LOOSE400"},0.9]
[null,{"$f":"B$75&450","v":"LOOSE450"},0.86499999999999999]
[null,{"$f":"B$75&500","v":"LOOSE500"},0.83]
[null,{"$f":"B$75&600","v":"LOOSE600"},0.8]
[null,{"$f":"B$75&700","v":"LOOSE700"},0.77500000000000002]
[null,{"$f":"B$75&800","v":"LOOSE800"},0.75]
[null,{"$f":"B$75&900","v":"LOOSE900"},0.72499999999999998]
[null,{"$f":"B$75&1000","v":"LOOSE1000"},0.7]
[null,{"$f":"B$75&1200","v":"LOOSE1200"},0.68]
[null,{"$f":"B$75&1400","v":"LOOSE1400"},0.66]
[null,{"$f":"B$75&1600","v":"LOOSE1600"},0.64]
[null,{"$f":"B$75&1800","v":"LOOSE1800"},0.62]
[null,{"$f":"B$75&2000","v":"LOOSE2000"},0.6]
[null,{"$f":"B$75&2500","v":"LOOSE2500"},0.57499999999999996]
[null,{"$f":"B$75&3000","v":"LOOSE3000"},0.54]
[null,{"$f":"B$75&3500","v":"LOOSE3500"},0.505]
[null,{"$f":"B$75&4000","v":"LOOSE4000"},0.47]
[null,{"$f":"B$75&4500","v":"LOOSE4500"},0.435]
[null,{"$f":"B$75&5000","v":"LOOSE5000"},0.4]
[null,{"$f":"B$74&5","v":"AVERAGE5"},1.25]
[null,{"$f":"B$74&6","v":"AVERAGE6"},1.23]
[null,{"$f":"B$74&7","v":"AVERAGE7"},1.21]
[null,{"$f":"B$74&8","v":"AVERAGE8"},1.19]
[null,{"$f":"B$74&9","v":"AVERAGE9"},1.17]
[null,{"$f":"B$74&10","v":"AVERAGE10"},1.1499999999999999]
[null,{"$f":"B$74&12","v":"AVERAGE12"},1.1299999999999999]
[null,{"$f":"B$74&14","v":"AVERAGE14"},1.1100000000000001]
[null,{"$f":"B$74&16","v":"AVERAGE16"},1.0900000000000001]
[null,{"$f":"B$74&18","v":"AVERAGE18"},1.07]
[null,{"$f":"B$74&20","v":"AVERAGE20"},1.05]
[null,{"$f":"B$74&25","v":"AVERAGE25"},1.4]
[null,{"$f":"B$74&30","v":"AVERAGE30"},1.3]
[null,{"$f":"B$74&35","v":"AVERAGE35"},1.2]
[null,{"$f":"B$74&40","v":"AVERAGE40"},1.1000000000000001]
[null,{"$f":"B$74&45","v":"AVERAGE45"},1]
[null,{"$f":"B$74&50","v":"AVERAGE50"},0.9]
[null,{"$f":"B$74&60","v":"AVERAGE60"},0.876]
[null,{"$f":"B$74&70","v":"AVERAGE70"},0.85199999999999998]
[null,{"$f":"B$74&80","v":"AVERAGE80"},0.82799999999999996]
[null,{"$f":"B$74&90","v":"AVERAGE90"},0.80400000000000005]
[null,{"$f":"B$74&100","v":"AVERAGE100"},0.78]
[null,{"$f":"B$74&120","v":"AVERAGE120"},0.76]
[null,{"$f":"B$74&140","v":"AVERAGE140"},0.74]
[null,{"$f":"B$74&160","v":"AVERAGE160"},0.72]
[null,{"$f":"B$74&180","v":"AVERAGE180"},0.7]
[null,{"$f":"B$74&200","v":"AVERAGE200"},0.68]
[null,{"$f":"B$74&250","v":"AVERAGE250"},0.65349999999999997]
[null,{"$f":"B$74&300","v":"AVERAGE300"},0.62680000000000002]
[null,{"$f":"B$74&350","v":"AVERAGE350"},0.60009999999999997]
[null,{"$f":"B$74&400","v":"AVERAGE400"},0.57340000000000002]
[null,{"$f":"B$74&450","v":"AVERAGE450"},0.54669999999999996]
[null,{"$f":"B$74&500","v":"AVERAGE500"},0.52]
[null,{"$f":"B$74&600","v":"AVERAGE600"},0.5]
[null,{"$f":"B$74&700","v":"AVERAGE700"},0.48]
[null,{"$f":"B$74&800","v":"AVERAGE800"},0.46]
[null,{"$f":"B$74&900","v":"AVERAGE900"},0.44]
[null,{"$f":"B$74&1000","v":"AVERAGE1000"},0.42]
[null,{"$f":"B$74&1200","v":"AVERAGE1200"},0.4]
[null,{"$f":"B$74&1400","v":"AVERAGE1400"},0.38]
[null,{"$f":"B$74&1600","v":"AVERAGE1600"},0.36]
[null,{"$f":"B$74&1800","v":"AVERAGE1800"},0.34]
[null,{"$f":"B$74&2000","v":"AVERAGE2000"},0.32]
[null,{"$f":"B$74&2500","v":"AVERAGE2500"},0.29499999999999998]
[null,{"$f":"B$74&3000","v":"AVERAGE3000"},0.26800000000000002]
[null,{"$f":"B$74&3500","v":"AVERAGE3500"},0.24099999999999999]
[null,{"$f":"B$74&4000","v":"AVERAGE4000"},0.214]
[null,{"$f":"B$74&4500","v":"AVERAGE4500"},0.187]
[null,{"$f":"B$74&5000","v":"AVERAGE5000"},0.16]
[null,{"$f":"B$73&5","v":"TIGHT5"},0.98]
[null,{"$f":"B$73&6","v":"TIGHT6"},0.96400000000000008]
[null,{"$f":"B$73&7","v":"TIGHT7"},0.94800000000000006]
[null,{"$f":"B$73&8","v":"TIGHT8"},0.93200000000000005]
[null,{"$f":"B$73&9","v":"TIGHT9"},0.91600000000000004]
[null,{"$f":"B$73&10","v":"TIGHT10"},0.9]
[null,{"$f":"B$73&12","v":"TIGHT12"},0.88400000000000001]
[null,{"$f":"B$73&14","v":"TIGHT14"},0.86799999999999999]
[null,{"$f":"B$73&16","v":"TIGHT16"},0.85199999999999998]
[null,{"$f":"B$73&18","v":"TIGHT18"},0.83599999999999997]
[null,{"$f":"B$73&20","v":"TIGHT20"},0.82]
[null,{"$f":"B$73&25","v":"TIGHT25"},0.79664999999999986]
[null,{"$f":"B$73&30","v":"TIGHT30"},0.7733199999999999]
[null,{"$f":"B$73&35","v":"TIGHT35"},0.74998999999999993]
[null,{"$f":"B$73&40","v":"TIGHT40"},0.72665999999999997]
[null,{"$f":"B$73&45","v":"TIGHT45"},0.70333000000000001]
[null,{"$f":"B$73&50","v":"TIGHT50"},0.68]
[null,{"$f":"B$73&60","v":"TIGHT60"},0.66200000000000003]
[null,{"$f":"B$73&70","v":"TIGHT70"},0.64400000000000002]
[null,{"$f":"B$73&80","v":"TIGHT80"},0.626]
[null,{"$f":"B$73&90","v":"TIGHT90"},0.60799999999999998]
[null,{"$f":"B$73&100","v":"TIGHT100"},0.59]
[null,{"$f":"B$73&120","v":"TIGHT120"},0.57600000000000007]
[null,{"$f":"B$73&140","v":"TIGHT140"},0.56200000000000006]
[null,{"$f":"B$73&160","v":"TIGHT160"},0.54800000000000004]
[null,{"$f":"B$73&180","v":"TIGHT180"},0.53400000000000003]
[null,{"$f":"B$73&200","v":"TIGHT200"},0.52]
[null,{"$f":"B$73&250","v":"TIGHT250"},0.49666499999999997]
[null,{"$f":"B$73&300","v":"TIGHT300"},0.47333199999999997]
[null,{"$f":"B$73&350","v":"TIGHT350"},0.44999899999999998]
[null,{"$f":"B$73&400","v":"TIGHT400"},0.42666599999999999]
[null,{"$f":"B$73&450","v":"TIGHT450"},0.403333]
[null,{"$f":"B$73&500","v":"TIGHT500"},0.38]
[null,{"$f":"B$73&600","v":"TIGHT600"},0.36600000000000005]
[null,{"$f":"B$73&700","v":"TIGHT700"},0.35200000000000004]
[null,{"$f":"B$73&800","v":"TIGHT800"},0.33800000000000002]
[null,{"$f":"B$73&900","v":"TIGHT900"},0.32400000000000001]
[null,{"$f":"B$73&1000","v":"TIGHT1000"},0.31]
[null,{"$f":"B$73&1200","v":"TIGHT1200"},0.29400000000000004]
[null,{"$f":"B$73&1400","v":"TIGHT1400"},0.27800000000000002]
[null,{"$f":"B$73&1600","v":"TIGHT1600"},0.26200000000000001]
[null,{"$f":"B$73&1800","v":"TIGHT1800"},0.246]
[null,{"$f":"B$73&2000","v":"TIGHT2000"},0.23]
[null,{"$f":"B$73&2500","v":"TIGHT2500"},0.20833300000000005]
[null,{"$f":"B$73&3000","v":"TIGHT3000"},0.18666640000000004]
[null,{"$f":"B$73&3500","v":"TIGHT3500"},0.16499980000000003]
[null,{"$f":"B$73&4000","v":"TIGHT4000"},0.14333320000000002]
[null,{"$f":"B$73&4500","v":"TIGHT4500"},0.12166660000000001]
[null,{"$f":"B$73&5000","v":"TIGHT5000"},0.1]

{"sheet":"2. Heat Loss Calculator","index":2,"n_rows":79,"n_cols":34,"rows_kept":79,"cut":false,"hidden":false,"merged":[[23,2,23,3],[5,14,9,14],[9,0,17,0],[16,14,16,15],[18,2,18,3],[19,2,19,3],[20,4,20,11],[21,2,21,3],[22,2,22,3],[35,2,35,3],[24,2,24,3],[29,2,29,3],[30,2,30,3],[31,4,31,11],[32,2,32,3],[33,2,33,3],[34,2,34,3],[25,4,25,11],[26,2,26,3],[27,2,27,3],[28,2,28,3],[47,2,47,3],[36,2,36,3],[37,4,37,11],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,4,43,11],[44,2,44,3],[45,2,45,3],[46,2,46,3],[57,2,57,3],[48,2,48,3],[50,2,50,3],[51,2,51,3],[53,2,53,3],[54,2,54,3],[56,2,56,3]]}
[]
[]
[null,null,"Heat Loss Calculator - Step 2: Calculations"]
[]
[null,null,"PROJECT DETAILS  (summary from the Project Details sheet)",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-09-08"}]
[null,null,{"$f":"'1. Project Details'!C15&\", \"&PROPER('1. Project Details'!C17)&\", \"&IF('1. Project Details'!C6=\"USA\",UPPER('1. Project Details'!C18),UPPER('1. Project Details'!C18))","v":", , "}]
[null,null,{"$f":"IF('1. Project Details'!C16=\"\",\"\",'1. Project Details'!C16)","v":""},null,null,null,null,null,null,null,null,null,null,"Hide"]
[null,null,{"$f":"IF('1. Project Details'!$C$14=\"\",\"\",'1. Project Details'!C14)","v":"2015-09-08T08:45:20.630"},null,null,null,null,null,null,null,null,null,null,"This "]
[]
[null,null,"construction/infiltration 'tightness' ",{"$f":"IF('1. Project Details'!O22=\"SCROLL to SELECT\",\"Select a value in 'Project Details' cell B9 or K10\",'1. Project Details'!O22)","v":"SELECT"},null,null,null,null,null,null,null,null,null,"column"]
[null,null,"air change/hr allowance ",{"$f":"'1. Project Details'!C27","v":0},"  x bldg volume",null,null,null,"outside temperature ",{"$f":"'1. Project Details'!C21","v":0},{"$f":"'1. Project Details'!D21","v":"°F"}]
[null,null,"building length ",{"$f":"'1. Project Details'!C23","v":0},{"$f":"'1. Project Details'!D23","v":" ft"},null,null,null,"inside temperature ",{"$f":"'1. Project Details'!C22","v":68},{"$f":"'1. Project Details'!D22","v":"°F"}]
[null,null,"building width ",{"$f":"'1. Project Details'!C24","v":0},{"$f":"'1. Project Details'!D24","v":" ft"},null,null,null,"design temp. diff. DT  ",{"$f":"IF(OR(J11=\"Not Indicated\",J12=\"\"),\"\",J12-J11)","v":68}," F°"]
[null,null,"avg. building height ",{"$f":"'1. Project Details'!O21","v":0},{"$f":"'1. Project Details'!D25","v":" ft"},null,null,null,"floor area to heat ",{"$f":"D12*D13","v":0},{"$f":"N15","v":" ft²"},null,null,"m²"]
[null,null,"heated volume not in this design ",0,{"$f":"LEFT('1. Project Details'!$D$28,3)","v":" ft"},null,null,null,"volume to condition ",{"$f":"D12*D13*D14-D15","v":0},{"$f":"E15","v":" ft"},null,null," ft²"]
[]
[null,null,"Building Component","Orientation","Qty",{"$f":"IF('1. Project Details'!$G$39=0,\"U-Value\",\"U-Value (1/R)\")","v":"U-Value (1/R)"},"Length","Height/ Width","Less adjacent heated area","Area","DT","Transmission Loss",null,{"$f":"'1. Project Details'!$G$39","v":" "}]
[null,null,null,null,null,null,"ft","ft",{"$f":"N15","v":" ft²"},{"$f":"N15","v":" ft²"},"F°","Btuh",null,null,null,null,null,null,null,"Floor Edge","-","Floor Edge - Other","-"]
[null,null,"Floor Edge",null,null,{"$f":"VLOOKUP(C19,T18:U20,2,FALSE)","v":"-"},{"$f":"2*D12+2*D13-G20","v":0},null,0,null,{"$f":"IF(F19=\"-\",0,J13)","v":0},{"$f":"IF(F19=\"-\",0,ROUND(F19*(G19-I19),-1))","v":0},null,null,null,null,null,null,null,"Uninsulated Floor Edge",0.81,"Uninsulated Floor Edge",0.81]
[null,null,"Floor Edge - Other",null,null,{"$f":"VLOOKUP(C20,V18:W20,2,FALSE)","v":"-"},0,null,0,null,{"$f":"IF(F20=\"-\",0,$J$13)","v":0},{"$f":"IF(F20=\"-\",\"\",ROUND(F20*(G20-I20),-1))","v":""},null,null,null,null,null,null,null,"Insulated Floor Edge",0.55000000000000004,"Insulated Floor Edge",0.55000000000000004]
[null,null,"ROOF:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROOF CONSTRUCTION MATERIAL",0]
[null,null,"ROOF CONSTRUCTION MATERIAL",null,null,{"$f":"VLOOKUP(C22,$T$21:$U$54,2,FALSE)","v":0},{"$f":"D12","v":0},{"$f":"D13","v":0},0,{"$f":"IF(F22=0,0,(G22*H22)-I22-J24-J25)","v":0},{"$f":"IF(OR(F22=\"-\",F22=0),0,$J$13)","v":0},{"$f":"IF(G22=0,0,IF(AND(G22=0,H22=0),0,IF(F22=\"-\",\"U-VALUE?\",IF(G22=0,\"LENGTH?\",IF(H22=0,\"WIDTH?\",ROUND(F22*J22*K22,-1))))))","v":0},null,null,null,null,null,null,null,"OTHER ROOF CONSTRUCTION MATERIAL",0,null,null,null,"ENTIRE WALL or LOWER PORTION",0,"UPPER WALL (if applicable)",0,null,"DOOR","-",null,"WINDOW","-"]
[null,null,"OTHER ROOF CONSTRUCTION MATERIAL",null,null,{"$f":"VLOOKUP(C23,$T$22:$U$54,2,FALSE)","v":0},0,0,0,{"$f":"IF(F23=\"\",\"\",(G23*H23)-I23)","v":0},{"$f":"IF(F23=0,0,$J$13)","v":0},{"$f":"IF(F23=0,0,IF(G23=0,\"LENGTH?\",IF(H23=0,\"WIDTH?\",ROUND(F23*J23*K23,-1))))","v":0},null,null,null,null,null,null,null,"Project specific 'U'-Value","??","SKYLIGHT","-",null,"THIS WALL IS WARM",0,"WARM",0,null,"DOOR - Project specific 'U'-Value","??",null,"WINDOW - Project specific 'U'-Value","??"]
[null,null,"SKYLIGHT",null,0,{"$f":"VLOOKUP(C24,$V$23:$W$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(E24=\"\",0,E24*(G24*H24))","v":0},{"$f":"IF(OR(F24=\"-\",G24=0,H24=0),0,$J$13)","v":0},{"$f":"IF(C24=\"SKYLIGHT\",0,IF(AND(E24=0,F24=\"-\",G24=0,H24=0),0,IF(E24=0,\"QUANTITY?\",IF(F24=\"-\",\"U-VALUE?\",IF(G24=0,\"LENGTH?\",IF(H24=0,\"HEIGHT?\",ROUND(F24*J24*K24,-1)))))))","v":0},null,null,null,null,null,null,null,"R-2",{"$f":"1/2","v":0.5},"SKYLIGHT: Glass - Single pane",1.23,null,"Project Specific 'U'-Value","??","Project Specific 'U'-Value","??",null,"DOOR - METAL",1.2,null,"WINDOW - SINGLE",1.06]
[null,null,"SKYLIGHT",null,0,{"$f":"VLOOKUP(C25,$V$23:$W$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(E25=\"\",0,E25*(G25*H25))","v":0},{"$f":"IF(OR(F25=\"-\",G25=0,H25=0),0,$J$13)","v":0},{"$f":"IF(C25=\"SKYLIGHT\",0,IF(AND(E25=0,F25=\"-\",G25=0,H25=0),0,IF(E25=0,\"QUANTITY?\",IF(F25=\"-\",\"U-VALUE?\",IF(G25=0,\"LENGTH?\",IF(H25=0,\"HEIGHT?\",ROUND(F25*J25*K25,-1)))))))","v":0},null,null,null,null,null,null,null,"R-4",{"$f":"1/4","v":0.25},"SKYLIGHT: Glass - Double 1/8\" Air Space",0.7,null,"R-4",{"$f":"1/4","v":0.25},"R-4",{"$f":"1/4","v":0.25},null,"DOOR - WOOD",0.64,null,"WINDOW - DOUBLE 1/8\"",0.62]
[null,null,{"$f":"\"WALL 1:      \"&G27&\" ft x \"&H27+H28&\" ft\"","v":"WALL 1:      0 ft x 0 ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-8",{"$f":"1/8","v":0.125},"SKYLIGHT: Glass - Double 1/4\" Air Space",0.65,null,"R-5",{"$f":"1/5","v":0.2},"R-5",{"$f":"1/5","v":0.2},null,"DOOR - GLASS",1.06,null,"WINDOW - DOUBLE 1/4\"",0.57999999999999996]
[null,null,"ENTIRE WALL or LOWER PORTION",null,null,{"$f":"VLOOKUP(C27,$Y$22:$Z$46,2,FALSE)","v":0},{"$f":"$D$12","v":0},{"$f":"IF(OR(H28=0,H28=\"\",H28=\" \"),D14,D14-H28)","v":0},0,{"$f":"IF(OR(C27=\"THIS WALL IS WARM\",N27=0),0,N27)","v":0},{"$f":"IF(OR(F27=\"-\",F27=0),0,$J$13)","v":0},{"$f":"IF(F27=0,0,IF(OR(F27=\"-\",F27=\"??\"),\"U-VALUE?\",IF(G27=0,\"LENGTH?\",IF(H27=0,\"HEIGHT?\",ROUND(F27*J27*K27,-1)))))","v":0},null,{"$f":"IF($F27=\"\",0,($G27*$H27)-$I27-($P27+P29))","v":0},null,{"$f":"IF(H29=0,0,IF(H27<H29,H27,H29)*G29*E29)","v":0},null,null,null,"R-10",{"$f":"1/10","v":0.1},"SKYLIGHT: Glass - Double 1/2\" Air Space",0.59,null,"R-8",{"$f":"1/8","v":0.125},"R-8",{"$f":"1/8","v":0.125},null,"DOOR - INSUL-1\"",0.23,null,"WINDOW - DOUBLE 1/2\"",0.49]
[null,null,"UPPER WALL (if applicable)",null,null,{"$f":"VLOOKUP(C28,$AA$22:$AB$46,2,FALSE)","v":0},{"$f":"IF(F28=0,0,G27)","v":0},null,0,{"$f":"IF(OR(C28=\"THIS WALL IS WARM\",N28=0),0,N28)","v":0},{"$f":"IF(OR(F28=\"-\",F28=0),0,$J$13)","v":0},{"$f":"IF(C28=\"THIS WALL IS WARM\",0,IF(AND(F28=0,G28=0,H28=0),0,IF(F28=\"-\",\"U-VALUE?\",IF(G28=0,\"LENGTH?\",IF(H28=0,\"HEIGHT?\",ROUND(F28*J28*K28,-1))))))","v":0},null,{"$f":"IF($F28=\"\",0,($G28*$H28)-$I28-(P28+P30))","v":0},null,{"$f":"IF(H29=0,0,N29-P27)","v":0},null,null,null,"R-11",{"$f":"1/11","v":9.0909090909090912E-2},"SKYLIGHT: Plastic Dome - Single",1.5,null,"R-10",{"$f":"1/10","v":0.1},"R-10",{"$f":"1/10","v":0.1},null,"DOOR - INSUL-1.5\"",0.18]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C29,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N29=0,0,N29)","v":0},{"$f":"IF(OR(F29=\"-\",F29=0),0,$J$13)","v":0},{"$f":"IF(C29=\"DOOR\",0,IF(AND(E29=0,F29=\"-\",G29=0,H29=0),0,IF(E29=0,\"QUANTITY?\",IF(F29=\"-\",\"U-VALUE?\",IF(G29=0,\"LENGTH?\",IF(H29=0,\"HEIGHT?\",ROUND(F29*J29*K29,-1)))))))","v":0},null,{"$f":"IF($E29=0,0,$E29*($G29*$H29))","v":0},null,{"$f":"IF(H30=0,0,IF(H27<H30,H27,H30)*G30*E30)","v":0},null,null,null,"R-12",{"$f":"1/12","v":8.3333333333333329E-2},"SKYLIGHT: Plastic Dome - Double",0.7,null,"R-11",{"$f":"1/11","v":9.0909090909090912E-2},"R-11",{"$f":"1/11","v":9.0909090909090912E-2},null,"DOOR - INSUL-2\"",0.13]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C30,$AD$22:$AE$29,2,FALSE)","v":"-"},null,null,null,{"$f":"IF(N30=0,0,N30)","v":0},{"$f":"IF(OR(F30=\"-\",F30=0),0,$J$13)","v":0},{"$f":"IF(C30=\"DOOR\",0,IF(AND(E30=0,F30=\"-\",G30=0,H30=0),0,IF(E30=0,\"QUANTITY?\",IF(F30=\"-\",\"U-VALUE?\",IF(G30=0,\"LENGTH?\",IF(H30=0,\"HEIGHT?\",ROUND(F30*J30*K30,-1)))))))","v":0},null,{"$f":"IF($E30=0,0,$E30*($G30*$H30))","v":0},null,{"$f":"IF(H30=0,0,N30-P29)","v":0},null,null,null,"R-13",{"$f":"1/13","v":7.6923076923076927E-2},null,null,null,"R-12",{"$f":"1/12","v":8.3333333333333329E-2},"R-12",{"$f":"1/12","v":8.3333333333333329E-2}]
[null,null,"WINDOW",null,0,{"$f":"VLOOKUP(C31,$AG$22:$AH$27,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N31=0,0,N31)","v":0},{"$f":"IF(OR(F31=\"-\",F31=0),0,$J$13)","v":0},{"$f":"IF(C31=\"WINDOW\",0,IF(AND(E31=0,F31=\"-\",G31=0,H31=0),0,IF(E31=0,\"QUANTITY?\",IF(F31=\"-\",\"U-VALUE?\",IF(G31=0,\"LENGTH?\",IF(H31=0,\"HEIGHT?\",ROUND(F31*J31*K31,-1)))))))","v":0},null,{"$f":"IF($E31=0,0,$E31*($G31*$H31))","v":0},null,null,null,null,null,"R-14",{"$f":"1/14","v":7.1428571428571425E-2},null,null,null,"R-13",{"$f":"1/14","v":7.1428571428571425E-2},"R-13",{"$f":"1/14","v":7.1428571428571425E-2}]
[null,null,{"$f":"\"WALL 2:      \"&G33&\" ft x \"&H33+H34&\" ft\"","v":"WALL 2:      0 ft x 0 ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-16",{"$f":"1/16","v":6.25E-2},null,null,null,"R-15",{"$f":"1/16","v":6.25E-2},"R-15",{"$f":"1/16","v":6.25E-2}]
[null,null,{"$f":"IF(C27=\"THIS WALL IS WARM\",\"ENTIRE WALL or LOWER PORTION\",C27)","v":"ENTIRE WALL or LOWER PORTION"},null,null,{"$f":"VLOOKUP(C33,$Y$22:$Z$46,2,FALSE)","v":0},{"$f":"$D$13","v":0},{"$f":"IF(OR(H34=0,H34=\"\",H34=\" \"),D14,D14-H34)","v":0},0,{"$f":"IF(OR(C33=\"THIS WALL IS WARM\",N33=0),0,N33)","v":0},{"$f":"IF(OR(F33=\"-\",F33=0),0,$J$13)","v":0},{"$f":"IF(F33=0,0,IF(OR(F33=\"-\",F33=\"??\"),\"U-VALUE?\",IF(G33=0,\"LENGTH?\",IF(H33=0,\"HEIGHT?\",ROUND(F33*J33*K33,-1)))))","v":0},null,{"$f":"IF($F33=\"\",0,($G33*$H33)-$I33-($P33+P35))","v":0},null,{"$f":"IF(H35=0,0,IF(H33<H35,H33,H35)*G35*E35)","v":0},null,null,null,"R-18",{"$f":"1/18","v":5.5555555555555552E-2},null,null,null,"R-18",{"$f":"1/18","v":5.5555555555555552E-2},"R-18",{"$f":"1/18","v":5.5555555555555552E-2}]
[null,null,{"$f":"C28","v":"UPPER WALL (if applicable)"},null,null,{"$f":"VLOOKUP(C34,$AA$22:$AB$46,2,FALSE)","v":0},{"$f":"IF(F34=0,0,G33)","v":0},{"$f":"H28","v":0},0,{"$f":"IF(OR(C34=\"THIS WALL IS WARM\",N34=0),0,N34)","v":0},{"$f":"IF(OR(F34=\"-\",F34=0),0,$J$13)","v":0},{"$f":"IF(C34=\"THIS WALL IS WARM\",0,IF(AND(F34=0,G34=0,H34=0),0,IF(F34=\"-\",\"U-VALUE?\",IF(G34=0,\"LENGTH?\",IF(H34=0,\"HEIGHT?\",ROUND(F34*J34*K34,-1))))))","v":0},null,{"$f":"IF($F34=\"\",0,($G34*$H34)-$I34-(P34+P36))","v":0},null,{"$f":"IF(H35=0,0,N35-P33)","v":0},null,null,null,"R-19",{"$f":"1/19","v":5.2631578947368418E-2},null,null,null,"R-19",{"$f":"1/19","v":5.2631578947368418E-2},"R-19",{"$f":"1/19","v":5.2631578947368418E-2}]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C35,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N35=0,0,N35)","v":0},{"$f":"IF(OR(F35=\"-\",F35=0),0,$J$13)","v":0},{"$f":"IF(C35=\"DOOR\",0,IF(AND(E35=0,F35=\"-\",G35=0,H35=0),0,IF(E35=0,\"QUANTITY?\",IF(F35=\"-\",\"U-VALUE?\",IF(G35=0,\"LENGTH?\",IF(H35=0,\"HEIGHT?\",ROUND(F35*J35*K35,-1)))))))","v":0},null,{"$f":"IF($E35=0,0,$E35*($G35*$H35))","v":0},null,{"$f":"IF(H36=0,0,IF(H33<H36,H33,H36)*G36*E36)","v":0},null,null,null,"R-20",{"$f":"1/20","v":0.05},null,null,null,"R-20",{"$f":"1/20","v":0.05},"R-20",{"$f":"1/20","v":0.05}]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C36,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N36=0,0,N36)","v":0},{"$f":"IF(OR(F36=\"-\",F36=0),0,$J$13)","v":0},{"$f":"IF(C36=\"DOOR\",0,IF(AND(E36=0,F36=\"-\",G36=0,H36=0),0,IF(E36=0,\"QUANTITY?\",IF(F36=\"-\",\"U-VALUE?\",IF(G36=0,\"LENGTH?\",IF(H36=0,\"HEIGHT?\",ROUND(F36*J36*K36,-1)))))))","v":0},null,{"$f":"IF($E36=0,0,$E36*($G36*$H36))","v":0},null,{"$f":"IF(H36=0,0,N36-P35)","v":0},null,null,null,"R-28",{"$f":"1/28","v":3.5714285714285712E-2},null,null,null,"R-28",{"$f":"1/28","v":3.5714285714285712E-2},"R-28",{"$f":"1/28","v":3.5714285714285712E-2}]
[null,null,"WINDOW",null,0,{"$f":"VLOOKUP(C37,$AG$22:$AH$27,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N37=0,0,N37)","v":0},{"$f":"IF(OR(F37=\"-\",F37=0),0,$J$13)","v":0},{"$f":"IF(C37=\"WINDOW\",0,IF(AND(E37=0,F37=\"-\",G37=0,H37=0),0,IF(E37=0,\"QUANTITY?\",IF(F37=\"-\",\"U-VALUE?\",IF(G37=0,\"LENGTH?\",IF(H37=0,\"HEIGHT?\",ROUND(F37*J37*K37,-1)))))))","v":0},null,{"$f":"IF($E37=0,0,$E37*($G37*$H37))","v":0},null,null,null,null,null,"R-30",{"$f":"1/30","v":3.3333333333333333E-2},null,null,null,"R-30",{"$f":"1/30","v":3.3333333333333333E-2},"R-30",{"$f":"1/30","v":3.3333333333333333E-2}]
[null,null,{"$f":"\"WALL 3:      \"&G39&\" ft x \"&H39+H40&\" ft\"","v":"WALL 3:      0 ft x 0 ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-32",{"$f":"1/32","v":3.125E-2},null,null,null,"R-32",{"$f":"1/32","v":3.125E-2},"R-32",{"$f":"1/32","v":3.125E-2}]
[null,null,{"$f":"IF(C27=\"THIS WALL IS WARM\",\"ENTIRE WALL or LOWER PORTION\",C27)","v":"ENTIRE WALL or LOWER PORTION"},null,null,{"$f":"VLOOKUP(C39,$Y$22:$Z$46,2,FALSE)","v":0},{"$f":"D12","v":0},{"$f":"IF(OR(H40=0,H40=\"\",H40=\" \"),D14,D14-H40)","v":0},0,{"$f":"IF(OR(C39=\"THIS WALL IS WARM\",N39=0),0,N39)","v":0},{"$f":"IF(OR(F39=\"-\",F39=0),0,$J$13)","v":0},{"$f":"IF(F39=0,0,IF(OR(F39=\"-\",F39=\"??\"),\"U-VALUE?\",IF(G39=0,\"LENGTH?\",IF(H39=0,\"HEIGHT?\",ROUND(F39*J39*K39,-1)))))","v":0},null,{"$f":"IF($F39=\"\",0,($G39*$H39)-$I39-($P39+P41))","v":0},null,{"$f":"IF(H41=0,0,IF(H39<H41,H39,H41)*G41*E41)","v":0},null,null,null,"R-40",{"$f":"1/40","v":2.5000000000000001E-2},null,null,null,"R-40",{"$f":"1/40","v":2.5000000000000001E-2},"R-40",{"$f":"1/40","v":2.5000000000000001E-2}]
[null,null,{"$f":"C28","v":"UPPER WALL (if applicable)"},null,null,{"$f":"VLOOKUP(C40,$AA$22:$AB$46,2,FALSE)","v":0},{"$f":"IF(G28=\"\",\"\",G28)","v":0},{"$f":"IF(H28=\"\",0,H28)","v":0},0,{"$f":"IF(OR(C40=\"THIS WALL IS WARM\",N40=0),0,N40)","v":0},{"$f":"IF(OR(F40=\"-\",F40=0),0,$J$13)","v":0},{"$f":"IF(C40=\"THIS WALL IS WARM\",0,IF(AND(F40=0,G40=0,H40=0),0,IF(F40=\"-\",\"U-VALUE?\",IF(G40=0,\"LENGTH?\",IF(H40=0,\"HEIGHT?\",ROUND(F40*J40*K40,-1))))))","v":0},null,{"$f":"IF($F40=0,0,($G40*$H40)-$I40-(P40+P42))","v":0},null,{"$f":"IF(H41=0,0,N41-P39)","v":0},null,null,null,"R-50",{"$f":"1/50","v":0.02},null,null,null,"Concrete Block - 8\"",0.51,"Concrete Block - 8\"",0.51]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C41,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N41=0,0,N41)","v":0},{"$f":"IF(OR(F41=\"-\",F41=0),0,$J$13)","v":0},{"$f":"IF(C41=\"DOOR\",0,IF(AND(E41=0,F41=\"-\",G41=0,H41=0),0,IF(E41=0,\"QUANTITY?\",IF(F41=\"-\",\"U-VALUE?\",IF(G41=0,\"LENGTH?\",IF(H41=0,\"HEIGHT?\",ROUND(F41*J41*K41,-1)))))))","v":0},null,{"$f":"IF($E41=0,0,$E41*($G41*$H41))","v":0},null,{"$f":"IF(H42=0,0,IF(H39<H42,H39,H42)*G42*E42)","v":0},null,null,null,null,null,null,null,null,"Concrete Block - 10\"",0.49,"Concrete Block - 10\"",0.49]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C42,$AD$22:$AE$29,2,FALSE)","v":"-"},0,null,null,{"$f":"IF(N42=0,0,N42)","v":0},{"$f":"IF(OR(F42=\"-\",F42=0),0,$J$13)","v":0},{"$f":"IF(C42=\"DOOR\",0,IF(AND(E42=0,F42=\"-\",G42=0,H42=0),0,IF(E42=0,\"QUANTITY?\",IF(F42=\"-\",\"U-VALUE?\",IF(G42=0,\"LENGTH?\",IF(H42=0,\"HEIGHT?\",ROUND(F42*J42*K42,-1)))))))","v":0},null,{"$f":"IF($E42=0,0,$E42*($G42*$H42))","v":0},null,{"$f":"IF(H42=0,0,N42-P41)","v":0},null,null,null,"Metal Built Up + 0\" Fiber Board",0.88,null,null,null,"Concrete Block - 12\"",0.47,"Concrete Block - 12\"",0.47]
[null,null,"WINDOW",null,0,{"$f":"VLOOKUP(C43,$AG$22:$AH$27,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N43=0,\"\",N43)","v":""},{"$f":"IF(OR(F43=\"-\",F43=0),0,$J$13)","v":0},{"$f":"IF(C43=\"WINDOW\",0,IF(AND(E43=0,F43=\"-\",G43=0,H43=0),0,IF(E43=0,\"QUANTITY?\",IF(F43=\"-\",\"U-VALUE?\",IF(G43=0,\"LENGTH?\",IF(H43=0,\"HEIGHT?\",ROUND(F43*J43*K43,-1)))))))","v":0},null,{"$f":"IF($E43=0,0,$E43*($G43*$H43))","v":0},null,null,null,null,null,"Metal Built Up + 0.5\" Fiber Board",0.37,null,null,null,"Poured Concrete - 6\"",0.31,"Poured Concrete - 6\"",0.31]
[null,null,{"$f":"\"WALL 4:      \"&G45&\" ft x \"&H45+H46&\" ft\"","v":"WALL 4:      0 ft x 0 ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Built Up + 1.0\" Fiber Board",0.24,null,null,null,"Poured Concrete - 8\"",0.25,"Poured Concrete - 8\"",0.25]
[null,null,{"$f":"IF(C27=\"THIS WALL IS WARM\",\"ENTIRE WALL or LOWER PORTION\",C27)","v":"ENTIRE WALL or LOWER PORTION"},null,null,{"$f":"VLOOKUP(C45,$Y$22:$Z$46,2,FALSE)","v":0},{"$f":"$D$13","v":0},{"$f":"H33","v":0},0,{"$f":"IF(OR(C45=\"THIS WALL IS WARM\",N45=0),0,N45)","v":0},{"$f":"IF(OR(F45=\"-\",F45=0),0,$J$13)","v":0},{"$f":"IF(F45=0,0,IF(OR(F45=\"-\",F45=\"??\"),\"U-VALUE?\",IF(G45=0,\"LENGTH?\",IF(H45=0,\"HEIGHT?\",ROUND(F45*J45*K45,-1)))))","v":0},null,{"$f":"IF($F45=\"\",0,($G45*$H45)-$I45-($P45+P47))","v":0},null,{"$f":"IF(H47=0,0,IF(H45<H47,H45,H47)*G47*E47)","v":0},null,null,null,"Metal Built Up + 1.5\" Fiber Board",0.18,null,null,null,"Poured Concrete - 10\"",0.21,"Poured Concrete - 10\"",0.21]
[null,null,{"$f":"C28","v":"UPPER WALL (if applicable)"},null,null,{"$f":"VLOOKUP(C46,$AA$22:$AB$46,2,FALSE)","v":0},{"$f":"IF(G34=\"\",\"\",G34)","v":0},{"$f":"H34","v":0},0,{"$f":"IF(OR(C46=\"THIS WALL IS WARM\",N46=0),0,N46)","v":0},0,{"$f":"IF(C46=\"THIS WALL IS WARM\",0,IF(AND(F46=0,G46=0,H46=0),0,IF(F46=\"-\",\"U-VALUE?\",IF(G46=0,\"LENGTH?\",IF(H46=0,\"HEIGHT?\",ROUND(F46*J46*K46,-1))))))","v":0},null,{"$f":"IF($F46=\"\",0,($G46*$H46)-$I46-(P46+P48))","v":0},null,{"$f":"IF(H47=0,0,N47-P45)","v":0},null,null,null,"Metal Built Up + 2.0\" Fiber Board",0.14000000000000001,null,null,null,"Poured Concrete - 12\"",0.18,"Poured Concrete - 12\"",0.18]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C47,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N47=0,0,N47)","v":0},0,{"$f":"IF(C47=\"DOOR\",0,IF(AND(E47=0,F47=\"-\",G47=0,H47=0),0,IF(E47=0,\"QUANTITY?\",IF(F47=\"-\",\"U-VALUE?\",IF(G47=0,\"LENGTH?\",IF(H47=0,\"HEIGHT?\",ROUND(F47*J47*K47,-1)))))))","v":0},null,{"$f":"IF($E47=0,0,$E47*($G47*$H47))","v":0},null,{"$f":"IF(H48=0,0,IF(H45<H48,H45,H48)*G48*E48)","v":0},null,null,null,"Metal Built Up + 3.0\" Fiber Board",9.7000000000000003E-2]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C48,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N48=0,0,N48)","v":0},0,{"$f":"IF(C48=\"DOOR\",0,IF(AND(E48=0,F48=\"-\",G48=0,H48=0),0,IF(E48=0,\"QUANTITY?\",IF(F48=\"-\",\"U-VALUE?\",IF(G48=0,\"LENGTH?\",IF(H48=0,\"HEIGHT?\",ROUND(F48*J48*K48,-1)))))))","v":0},null,{"$f":"IF($E48=0,0,$E48*($G48*$H48))","v":0},null,{"$f":"IF(H48=0,0,N48-P47)","v":0},null,null,null,null,null,null,null,null,"ADDITIONAL WALL",0,"ADDITIONAL WALL",0]
[null,null,"WINDOW",null,0,{"$f":"VLOOKUP(C49,$AG$22:$AH$27,2,FALSE)","v":"-"},0,0,null,{"$f":"IF(N49=0,\"\",N49)","v":""},0,{"$f":"IF(C49=\"WINDOW\",0,IF(AND(E49=0,F49=\"-\",G49=0,H49=0),0,IF(E49=0,\"QUANTITY?\",IF(F49=\"-\",\"U-VALUE?\",IF(G49=0,\"LENGTH?\",IF(H49=0,\"HEIGHT?\",ROUND(F49*J49*K49,-1)))))))","v":0},null,{"$f":"IF($E49=0,0,$E49*($G49*$H49))","v":0},null,null,null,null,null,"Wood Built Up + 0\" Fiber Board",0.48,null,null,null,"ADDITIONAL WALL 'U'-Value","??","WALL - OTHER - Enter 'U'-Value","??"]
[null,null,"ADDITIONAL WALL",null,null,{"$f":"VLOOKUP(C50,$Y$48:$Z$71,2,FALSE)","v":0},0,0,0,"",0,{"$f":"IF(F50=0,0,IF(OR(F50=\"-\",F50=\"??\"),\"U-VALUE?\",IF(G50=0,\"LENGTH?\",IF(H50=0,\"HEIGHT?\",ROUND(F50*J50*K50,-1)))))","v":0},null,{"$f":"IF($F50=0,0,$G50*$H50-N51-N52)","v":0},null,null,null,null,null,"Wood Built Up + 0.5\" Fiber Board",0.28999999999999998,null,null,null,"ADDITIONAL WALL: R-4",{"$f":"1/4","v":0.25},"    R-4",{"$f":"1/4","v":0.25}]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C51,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,"",0,{"$f":"IF(C51=\"DOOR\",0,IF(AND(E51=0,F51=\"-\",G51=0,H51=0),0,IF(E51=0,\"QUANTITY?\",IF(F51=\"-\",\"U-VALUE?\",IF(G51=0,\"LENGTH?\",IF(H51=0,\"HEIGHT?\",ROUND(F51*J51*K51,-1)))))))","v":0},null,{"$f":"IF($E51=\"\",0,$E51*($G51*$H51))","v":0},null,null,null,null,null,"Wood Built Up + 1.0\" Fiber Board",0.21,null,null,null,"ADDITIONAL WALL: R-5",{"$f":"1/5","v":0.2},"    R-5",{"$f":"1/5","v":0.2}]
[null,null,"WINDOW",null,0,{"$f":"VLOOKUP(C52,$AG$22:$AH$27,2,FALSE)","v":"-"},0,0,null,"",0,{"$f":"IF(C52=\"WINDOW\",0,IF(AND(E52=0,F52=\"-\",G52=0,H52=0),0,IF(E52=0,\"QUANTITY?\",IF(F52=\"-\",\"U-VALUE?\",IF(G52=0,\"LENGTH?\",IF(H52=0,\"HEIGHT?\",ROUND(F52*J52*K52,-1)))))))","v":0},null,{"$f":"IF($E52=\"\",0,$E52*($G52*$H52))","v":0},null,null,null,null,null,"Wood Built Up + 1.5\" Fiber Board",0.16,null,null,null,"ADDITIONAL WALL: R-8",{"$f":"1/8","v":0.125},"    R-8",{"$f":"1/8","v":0.125}]
[null,null,"ADDITIONAL WALL",null,null,{"$f":"VLOOKUP(C53,$Y$48:$Z$71,2,FALSE)","v":0},0,0,0,"",0,{"$f":"IF(F53=0,0,IF(OR(F53=\"-\",F53=\"??\"),\"U-VALUE?\",IF(G53=0,\"LENGTH?\",IF(H53=0,\"HEIGHT?\",ROUND(F53*J53*K53,-1)))))","v":0},null,{"$f":"IF($F53=0,0,$G53*$H53-N54-N55)","v":0},null,null,null,null,null,"Wood Built Up + 2.0\" Fiber Board",0.14000000000000001,null,null,null,"ADDITIONAL WALL: R-10",{"$f":"1/10","v":0.1},"    R-10",{"$f":"1/10","v":0.1}]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C54,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,"",0,{"$f":"IF(C54=\"DOOR\",0,IF(AND(E54=0,F54=\"-\",G54=0,H54=0),0,IF(E54=0,\"QUANTITY?\",IF(F54=\"-\",\"U-VALUE?\",IF(G54=0,\"LENGTH?\",IF(H54=0,\"HEIGHT?\",ROUND(F54*J54*K54,-1)))))))","v":0},null,{"$f":"IF($E54=\"\",0,$E54*($G54*$H54))","v":0},null,null,null,null,null,"Wood Built Up + 3.0\" Fiber Board",0.1,null,null,null,"ADDITIONAL WALL: R-11",{"$f":"1/11","v":9.0909090909090912E-2},"    R-11",{"$f":"1/11","v":9.0909090909090912E-2}]
[null,null,"WINDOW",null,0,{"$f":"VLOOKUP(C55,$AG$22:$AH$27,2,FALSE)","v":"-"},0,0,null,"",0,{"$f":"IF(C55=\"WINDOW\",0,IF(AND(E55=0,F55=\"-\",G55=0,H55=0),0,IF(E55=0,\"QUANTITY?\",IF(F55=\"-\",\"U-VALUE?\",IF(G55=0,\"LENGTH?\",IF(H55=0,\"HEIGHT?\",ROUND(F55*J55*K55,-1)))))))","v":0},null,{"$f":"IF($E55=\"\",0,$E55*($G55*$H55))","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-12",{"$f":"1/12","v":8.3333333333333329E-2},"    R-12",{"$f":"1/12","v":8.3333333333333329E-2}]
[null,null,"ADDITIONAL WALL",null,null,{"$f":"VLOOKUP(C56,$Y$48:$Z$71,2,FALSE)","v":0},0,0,0,"",0,{"$f":"IF(F56=0,0,IF(OR(F56=\"-\",F56=\"??\"),\"U-VALUE?\",IF(G56=0,\"LENGTH?\",IF(H56=0,\"HEIGHT?\",ROUND(F56*J56*K56,-1)))))","v":0},null,{"$f":"IF($F56=0,0,$G56*$H56-N57-N58)","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-13",{"$f":"1/14","v":7.1428571428571425E-2},"    R-13",{"$f":"1/14","v":7.1428571428571425E-2}]
[null,null,"DOOR",null,0,{"$f":"VLOOKUP(C57,$AD$22:$AE$29,2,FALSE)","v":"-"},0,0,null,"",0,{"$f":"IF(C57=\"DOOR\",0,IF(AND(E57=0,F57=\"-\",G57=0,H57=0),0,IF(E57=0,\"QUANTITY?\",IF(F57=\"-\",\"U-VALUE?\",IF(G57=0,\"LENGTH?\",IF(H57=0,\"HEIGHT?\",ROUND(F57*J57*K57,-1)))))))","v":0},null,{"$f":"IF($E57=\"\",0,$E57*($G57*$H57))","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-15",{"$f":"1/16","v":6.25E-2},"    R-15",{"$f":"1/16","v":6.25E-2}]
[null,null,"WINDOW",null,0,{"$f":"VLOOKUP(C58,$AG$22:$AH$27,2,FALSE)","v":"-"},0,0,null,"",0,{"$f":"IF(C58=\"WINDOW\",0,IF(AND(E58=0,F58=\"-\",G58=0,H58=0),0,IF(E58=0,\"QUANTITY?\",IF(F58=\"-\",\"U-VALUE?\",IF(G58=0,\"LENGTH?\",IF(H58=0,\"HEIGHT?\",ROUND(F58*J58*K58,-1)))))))","v":0},null,{"$f":"IF($E58=\"\",0,$E58*($G58*$H58))","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-18",{"$f":"1/18","v":5.5555555555555552E-2},"    R-18",{"$f":"1/18","v":5.5555555555555552E-2}]
[null,null,null,null,null,null,"Infiltration Loss, QA= ",1.7999999999999999E-2,"x VAC  x DT",{"$f":"IF(N59>J60,N59,0)","v":0}," Btuh",null,null,{"$f":"IF(OR(D11=0,D11=\" \",D11=\"\"),0,D11*H59*$J$13*C65)","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-19",{"$f":"1/19","v":5.2631578947368418E-2},"    R-19",{"$f":"1/19","v":5.2631578947368418E-2}]
[null,null,null,null,null,null,null,null,{"$f":"\"Mechanical Ventilation = \"&TEXT('1. Project Details'!C36,\"0,000\")&\" cfh \"","v":"Mechanical Ventilation = 0,000 cfh "},{"$f":"IF('1. Project Details'!$C$34=\"\",0,IF('1. Project Details'!$G$39=0,$C$66*$J$13*$H$59/1000,'1. Project Details'!C36*$J$13*$H$59))","v":0}," Btuh",null,null,null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-20",{"$f":"1/20","v":0.05},"    R-20",{"$f":"1/20","v":0.05}]
[null,null,null,null,null,null,null,null,"Transmission Loss, QT = S(U x A x DT)",{"$f":"IF(SUM(L19:L58)=0,0,SUM(L19:L58))","v":0}," Btuh",null,null,{"$f":"'1. Project Details'!C27","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-28",{"$f":"1/28","v":3.5714285714285712E-2},"    R-28",{"$f":"1/28","v":3.5714285714285712E-2}]
[null,null,null,null,null,null,null,null,"Cold Material + Vehicle Loss, QM",{"$f":"N61*N62*J13+N63","v":0}," Btuh",null,null,{"$f":"'1. Project Details'!C37","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-30",{"$f":"1/30","v":3.3333333333333333E-2},"    R-30",{"$f":"1/30","v":3.3333333333333333E-2}]
[null,null,null,"Building Summary",null,null,null,null,"Sources of Heat Gain ",{"$f":"'1. Project Details'!$C$29*-1","v":0}," Btuh deducted",null,null,{"$f":"'1. Project Details'!C38","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-32",{"$f":"1/32","v":3.125E-2},"    R-32",{"$f":"1/32","v":3.125E-2}]
[null,null,{"$f":"J14","v":0},{"$f":"$N$15&\" floor area\"","v":" ft² floor area"},null,null,null,null," Total Heat Loss, QN = QA + QT + QM  ",{"$f":"IF('1. Project Details'!$C$45=\"\",J61+J59+J60+J62+J63,'1. Project Details'!$C$45)","v":0}," Btuh",null,null,{"$f":"'1. Project Details'!C39","v":0},null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WALL: R-40",{"$f":"1/40","v":2.5000000000000001E-2},"    R-40",{"$f":"1/40","v":2.5000000000000001E-2}]
[null,null,{"$f":"IF(J14=0,0,J14*D14-D15)","v":0},{"$f":"LEFT('1. Project Details'!$D$28,3)&\" building volume\"","v":" ft building volume"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALL - Concrete Block - 8\"",0.51,"WALL - Concrete Block - 8\"",0.51]
[null,null,{"$f":"IF(J14=0,0,C65*D11)","v":0},{"$f":"LEFT('1. Project Details'!$I$36,4)&\"/hr air change\"","v":" ft³/hr air change"},null,null,null,null,"floor area specific loss ",{"$f":"J64/C64","v":{"$error":"#DIV/0!"}},{"$f":"\" Btuh/\"&$N$15","v":" Btuh/ ft²"},null,null,null,null,null,null,null,null,null,null,null,null,null,"WALL - Concrete Block - 10\"",0.49,"WALL - Concrete Block - 10\"",0.49]
[null,null,{"$f":"SUM(J22:J58)","v":0},{"$f":"$N$15&\" total building surface\"","v":" ft² total building surface"},null,null,null,null,"volume specific loss ",{"$f":"J64/C65","v":{"$error":"#DIV/0!"}},{"$f":"\" Btuh/\"&LEFT('1. Project Details'!$D$28,4)","v":" Btuh/ ft³"},null,null,null,null,null,null,null,null,null,null,null,null,null,"WALL - Concrete Block - 12\"",0.47,"WALL - Concrete Block - 12\"",0.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALL - Poured Concrete - 6\"",0.31,"WALL - Poured Concrete - 6\"",0.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALL - Poured Concrete - 8\"",0.25,"WALL - Poured Concrete - 8\"",0.25]
[null,"Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALL - Poured Concrete - 10\"",0.21,"WALL - Poured Concrete - 10\"",0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALL - Poured Concrete - 12\"",0.18,"WALL - Poured Concrete - 12\"",0.18]
[null,"Project Details - Enter data on the 1. Project Details sheet"]
[]
[null,"Information needed for input into this section of the tool:"]
[null,"1.  Enter the heated volume not in this design to complete the project information needed for the calculations"]
[]
[null,"Calculations Section"]
[null,"1.  Use the dropdowns to select material or insulation value of each building component in the Building Component column. "]
[null,"2.  Enter or revise project specific 'U'-Values, Length, Width, etc. for each building component "]

{"sheet":"IR System Selection","index":3,"n_rows":95,"n_cols":29,"rows_kept":95,"cut":false,"hidden":false,"merged":[[47,6,47,8],[48,6,48,7],[33,6,33,7],[46,6,46,7],[39,6,39,7],[40,6,40,7],[41,6,41,8],[42,6,42,7],[43,6,43,7],[45,1,45,2],[45,6,45,7],[32,6,32,7],[34,6,34,8],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,8],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7]]}
[]
[null,"IR System Selection"]
[]
[null,null,null,"Project Country*",{"$f":"'1. Project Details'!C6","v":"USA"},null,null,null,null,null,null,null,null,null,"USA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CANADA"]
[null,"CURRENT CONVENTIONAL HEATING SYSTEM INPUT ",null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-09-08"}]
[]
[null,null,null,"Calculated Heat Loss",{"$f":"IF('2. Heat Loss Calculator'!$J$64>0,'2. Heat Loss Calculator'!$J$64,\"None\")","v":"None"},"Btuh"]
[null,null,null,"(Results from the compuSchwank II© heat loss calculator)"]
[null,null,{"$f":"IF(E8=\"None\",\"TOTAL INPUT OF HEATERS TO BE REPLACED\",\"TOTAL INPUT REQUIRED TO SATISFY HEAT LOSS\")","v":"TOTAL INPUT OF HEATERS TO BE REPLACED"}]
[null,null,null,"Current System","Input (Btuh)","Efficiency",{"$f":"IF(E24=\"?\",\"\",\"Cost / Hour   Operation\")","v":"Cost / Hour   Operation"}]
[null,null,null,"Unit Heaters",80000,0.8,{"$f":"IF(OR($E$24=\"?\",E12=0),\"\",E12/$F$23*$E$24)","v":1.0434782608695652}]
[null,null,null,"Roof Top",null,0.8,{"$f":"IF(OR($E$24=\"?\",E13=0),\"\",E13/$F$23*$E$24)","v":""}]
[null,null,null,"Boiler",null,0.8,{"$f":"IF(OR($E$24=\"?\",E14=0),\"\",E14/$F$23*$E$24)","v":""}]
[null,null,null,"Other Infrared",null,null,{"$f":"IF(OR($E$24=\"?\",E15=0),\"\",E15/$F$23*$E$24)","v":""}]
[]
[null,null,null,"Total current heat input to be replaced is",{"$f":"SUM(E12:E15)","v":80000},{"$f":"IF(OR($E$24=\"?\",E17=0),\"Btuh\",\"Btuh: Operation fuel costs \"&TEXT(R17,\"$0.00\")&\" / Hour \")","v":"Btuh: Operation fuel costs $1.04 / Hour "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G12:H15)","v":1.0434782608695652}]
[null,null,null,"The current input satisfies a Heat Loss1of",{"$f":"(E12*F12)+(E13*F13)+(E14*F14)+(E15/0.85)","v":64000},{"$f":"\"Btuh  \"&\"(input x system efficiency)\"","v":"Btuh  (input x system efficiency)"}]
[]
[null,"FUEL COST INFORMATION (if available)"]
[]
[null,null,null,"Fuel Type ","Natural Gas","  ",null,null,null,null,null,null,null,null,"Canada","Natural Gas",null,{"$f":"IF(AND(E4=\"USA\",E22=\"Natural Gas\"),\"Therm\",IF(AND(E4=\"Canada\",E22=\"Natural Gas\"),\"cu. meter\",IF(E4=\"USA\",\"gallon\",\"liter\")))","v":"Therm"},null,{"$f":"IF(E23=\"Therm\",100000,IF(E23=\"1000 cu ft\",1000000,IF(E23=\"cu. Meter\",34500,IF(AND(E22=\"Propane\",E4=\"USA\"),91523,IF(AND(E22=\"Propane\",E4=\"Canada\"),24180,IF(AND(E22=\"Oil\",E4=\"USA\"),138800,IF(AND(E22=\"Oil\",E4=\"Canada\"),36500,\"\")))))))","v":34500}]
[null,null,null,"Fuel Units ","cu. meter",{"$f":"IF(OR(E23=\"\",E23=\" \",E23=0,E23=\"?\"),\"\",T22)","v":34500},{"$f":"\"Btuh / \"&E23","v":"Btuh / cu. meter"},null,null,null,null,null,null,null,null,"Propane",null,{"$f":"IF(AND(E4=\"USA\",E22=\"Natural Gas\"),\"1000 cu ft\",\"\")","v":"1000 cu ft"},null,{"$f":"IF(E23=\"Therm\",100000,IF(E23=\"1000 cu ft\",1000000,IF(E23=\"cu. Meter\",34500,IF(AND(E22=\"Propane\",E4=\"USA\"),91523,IF(AND(E22=\"Propane\",E4=\"Canada\"),24180,IF(AND(E22=\"Oil\",E4=\"USA\"),138800,IF(AND(E22=\"Oil\",E4=\"Canada\"),36500,\"\")))))))","v":34500}]
[null,null,null,"Customer's Unit Fuel Cost ",0.45,{"$f":"IF(OR(E24=0,E24=\"?\"),\"\",\" /\"&E23)","v":" /cu. meter"},null,null,null,null,null,null,null,null,null,"?",null,"?"]
[]
[null,"IR HEATING SYSTEM RECOMMENDATIONS"]
[]
[null,null,null,{"$f":"IF(E28=\"?\", \"HEIGHT ABOVE FLOOR IR heaters mounted?\",\"IR heaters are to be mounted*\")","v":"IR heaters are to be mounted*"},15,{"$f":"IF(AND(E17+E15>0,OR(E28=0,E28=\"?\")),\" ft \"&\"<-- MOUNTING HEIGHT NEEDED TO SELECT CORRECT HEATER INPUT\",IF($E$4=\"CANADA\",(IF(E28<2.5,\"MIN. MOUNTING HEIGHT = 2.5 M ABOVE FLOOR\",\" ft above floor\")),(IF(E28<8,\"MIN. MOUNTING HEIGHT = 8 FT ABOVE FLOOR\",\" ft above floor\"))))","v":" ft above floor"}]
[null,{"$f":"\"Current heating system input of \"&(TEXT(E17,\"0,000\"))&\" Btuh satisfies a heat loss of \"&(TEXT(E18,\"0,000\"))&\" Btuh\"&IF(E24=\"?\",\"\",\" and costs \"&TEXT(G12,\"$0.00\")&\"/hour to operate\")","v":"Current heating system input of 80,000 Btuh satisfies a heat loss of 64,000 Btuh and costs $1.04/hour to operate"}]
[]
[null,"RECOMMENDED HEATERS"]
[]
[null,"  Tube Heaters","Model","Qty","System Input 3","Reduced Heat Loss 2",{"$f":"IF(E24=\"?\",\"\",\"Cost / 60 min. Operation\")","v":"Cost / 60 min. Operation"},null,{"$f":"IF(E24=\"?\",\"\",\"Reduction of Cost & Carbon\")","v":"Reduction of Cost & Carbon"},null,null,null,null,null,null,"Final","1st","Len","2nd",{"$f":"\"Qty @ \"&Q36","v":"Qty @ 110"},{"$f":"\"RndUp @ \"&Q36","v":"RndUp @ 110"},"DRndUp",{"$f":"\"RndDn @ \"&Q36","v":"RndDn @ 110"},"RndDn %",{"$f":"\"Qty @ \"&S36","v":"Qty @ 80"},{"$f":"\"RndUp @ \"&S36","v":"RndUp @ 80"},"DRndUp",{"$f":"\"RndDn @ \"&S36","v":"RndDn @ 80"},"RndDn %"]
[null,null,null,null,"(Btuh)","(Btuh)"]
[null,"Commercial / Industrial Application"]
[null,"Premier Model",{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"IQ\",IF(P36=\"40\",\"P40U-I\",\"IQ-\"&$P$36&\"-\"&$R$36))","v":"IQ-60-20"},{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"\",E36/(P36*1000))","v":1},{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"\",O36*P36*1000)","v":60000},{"$f":"$E$18*0.8","v":51200},{"$f":"IF(OR($E$24=\"?\",F36=0),\"\",F36/$F$23*$E$24)","v":0.66782608695652179},null,{"$f":"IF(OR($E$24=\"?\",F36=0),\"\",($R$17-G36)/$R$17)","v":0.35999999999999993},null,null,null,null,null,{"$f":"IF(X36>=0.98,W36,IF(AC36>=0.98,AB36,U36))","v":1},{"$f":"VLOOKUP(P39,R39:S43,2,FALSE)","v":"60"},{"$f":"IF($E28<8,\"\",IF($E28<10,\"40\",IF($E28<12,\"60\",IF($E28<14,\"80\",IF($E28<16,\"110\",IF($E28<18,\"130\",IF($E28<20,\"155\",IF($E28<22,\"175\",\"200\"))))))))","v":"110"},{"$f":"IF($E28<8,\"\",IF($P36=\"40\",\"\",IF($P36=\"60\",\"20\",IF($P36=\"80\",\"20\",IF($P36=\"110\",\"30\",IF($P36=\"130\",\"30\",IF($P36=\"155\",\"40\",IF($P36=\"175\",\"50\",\"50\"))))))))","v":"20"},{"$f":"IF($Q36=\"40\",\"40\",IF($Q36=\"60\",\"40\",IF($Q36=\"80\",\"60\",IF($Q36=\"110\",\"80\",IF($Q36=\"130\",\"110\",IF($Q36=\"155\",\"130\",IF($Q36=\"175\",\"155\",\"175\")))))))","v":"80"},{"$f":"F36/(Q36*1000)","v":0.46545454545454545},{"$f":"ROUNDUP(T36,0)","v":1},{"$f":"U36-T36","v":0.53454545454545455},{"$f":"ROUNDDOWN(T36,0)","v":0},{"$f":"W36/T36","v":0},{"$f":"F36/(S36*1000)","v":0.64},{"$f":"ROUNDUP(Y36,0)","v":1},{"$f":"Z36-Y36","v":0.36},{"$f":"ROUNDDOWN(Y36,0)","v":0},{"$f":"AB36/Y36","v":0}]
[null,"Builder Model",{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"ITB\",IF(P36=\"40\",\"P40U-I\",\"ITB-\"&$P$37&\"-\"&$R$37))","v":"ITB-60-20"},{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"\",E37/(P37*1000))","v":1},{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"\",O37*P37*1000)","v":60000},{"$f":"$E$18*0.85","v":54400},{"$f":"IF(OR($E$24=\"?\",F37=0),\"\",F37/$F$23*$E$24)","v":0.7095652173913044},null,{"$f":"IF(OR($E$24=\"?\",F37=0),\"\",($R$17-G37)/$R$17)","v":0.31999999999999995},null,null,null,null,null,{"$f":"IF(X37>=0.98,W37,IF(AC37>=0.98,AB37,U37))","v":1},{"$f":"VLOOKUP(W39,Y39:Z43,2,FALSE)","v":"60"},{"$f":"IF($E28<8,\"\",IF($E28<10,\"40\",IF($E28<12,\"60\",IF($E28<14,\"80\",IF($E28<16,\"110\",IF($E28<18,\"130\",IF($E28<20,\"155\",IF($E28<22,\"175\",\"200\"))))))))","v":"110"},{"$f":"IF($E28<8,\"\",IF($P37=\"40\",\"\",IF($P37=\"60\",\"20\",IF($P37=\"80\",\"20\",IF($P37=\"110\",\"30\",IF($P37=\"130\",\"30\",IF($P37=\"155\",\"40\",IF($P37=\"175\",\"50\",\"50\"))))))))","v":"20"},{"$f":"IF($Q37=\"40\",\"40\",IF($Q37=\"60\",\"40\",IF($Q37=\"80\",\"60\",IF($Q37=\"110\",\"80\",IF($Q37=\"130\",\"110\",IF($Q37=\"155\",\"130\",IF($Q37=\"175\",\"155\",\"175\")))))))","v":"80"},{"$f":"F37/(Q37*1000)","v":0.49454545454545457},{"$f":"ROUNDUP(T37,0)","v":1},{"$f":"U37-T37","v":0.50545454545454538},{"$f":"ROUNDDOWN(T37,0)","v":0},{"$f":"W37/T37","v":0},{"$f":"F37/(S37*1000)","v":0.68},{"$f":"ROUNDUP(Y37,0)","v":1},{"$f":"Z37-Y37","v":0.31999999999999995},{"$f":"ROUNDDOWN(Y37,0)","v":0},{"$f":"AB37/Y37","v":0}]
[null,"Builder Model 'U'-tube",{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"ITBU\",IF(P36=\"40\",\"P40U-I\",\"ITBU-\"&$P$37&\"-\"&$R$38))","v":"ITBU-60-10"},{"$f":"D37","v":1},{"$f":"E37","v":60000},{"$f":"$E$18*0.85","v":54400},{"$f":"IF(OR($E$24=\"?\",F38=0),\"\",F38/$F$23*$E$24)","v":0.7095652173913044},null,{"$f":"IF(OR($E$24=\"?\",F38=0),\"\",($R$17-G38)/$R$17)","v":0.31999999999999995},null,null,null,null,null,null,null,null,{"$f":"IF($E28<8,\"\",IF($P37=\"60\",\"10\",IF($P37=\"80\",\"10\",IF($P37=\"110\",\"20\",IF($P37=\"130\",\"20\",IF($P37=\"155\",\"20\",IF($P37=\"175\",\"30\",\"30\")))))))","v":"10"}]
[null,"Two Stage Operation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P39,R39:S43,2,FALSE)","v":"60"},{"$f":"MIN(R39:R43)","v":8.7999999999999972},{"$f":"$F$36/1000","v":51.2},{"$f":"T39-Q39","v":28.799999999999997},{"$f":"IF(X36>=0.98,Q36,IF(AC36>=0.98,S36,IF(U36<Z36,Q36,IF(AA36<V36,S36,S36))))","v":"80"},{"$f":"S39*$O$36","v":80},null,{"$f":"VLOOKUP(W39,Y39:Z43,2,FALSE)","v":"60"},{"$f":"MIN(Y39:Y43)","v":5.6000000000000014},{"$f":"$F$37/1000","v":54.4},{"$f":"AA39-X39","v":25.6},{"$f":"IF(E28=\"?\",\"\",IF(X37>=0.98,Q37,IF(AC37>=0.98,S37,IF(U37<Z37,Q37,IF(AA37<V37,S37,S37)))))","v":"80"},{"$f":"Z39*$O$36","v":80}]
[null,"Two Stage",{"$f":"IF(OR(E28=0,E28=\"?\",E18=0,P37=\"40\"),\"ITT\",\"ITT-\"&$P$37&\"-\"&$R$37)","v":"ITT-60-20"},{"$f":"IF(OR(P37=\"40\",P37=\"60\"),\"\",D37)","v":""},{"$f":"IF(P37=\"40\",\"\",E37)","v":60000},{"$f":"$E$18*0.85","v":54400},{"$f":"IF(OR($E$24=\"?\",F40=0),\"\",F40/$F$23*$E$24)","v":0.7095652173913044},null,{"$f":"IF(OR($E$24=\"?\",F40=0),\"\",($R$17-G40)/$R$17)","v":0.31999999999999995},null,null,null,null,null,null,null,{"$f":"$F$36/1000","v":51.2},{"$f":"IF(T40-Q40<0,R39+1,T40-Q40)","v":8.7999999999999972},{"$f":"IF($S39=\"40\",\"40\",IF($S39=\"60\",\"40\",IF($S39=\"80\",\"60\",IF($S39=\"110\",\"80\",IF($S39=\"130\",\"110\",IF($S39=\"155\",\"130\",IF($S39=\"175\",\"155\",\"175\")))))))","v":"60"},{"$f":"S40*$O$36","v":60},null,null,null,{"$f":"$F$37/1000","v":54.4},{"$f":"IF(AA40-X40<0,Y39+1,AA40-X40)","v":5.6000000000000014},{"$f":"IF($S39=\"40\",\"40\",IF($S39=\"60\",\"40\",IF($S39=\"80\",\"60\",IF($S39=\"110\",\"80\",IF($S39=\"130\",\"110\",IF($S39=\"155\",\"130\",IF($S39=\"175\",\"155\",\"175\")))))))","v":"60"},{"$f":"Z40*$O$36","v":60}]
[null,"Two Stage 'U'-tube",{"$f":"IF(OR(E28=0,E28=\"?\",E18=0,P37=\"40\"),\"ITTU\",\"ITTU-\"&$P$37&\"-\"&$R$38)","v":"ITTU-60-10"},{"$f":"IF(OR(P37=\"40\",P37=\"60\"),\"\",D37)","v":""},{"$f":"IF(P37=\"40\",\"\",E37)","v":60000},{"$f":"F37","v":54400},{"$f":"IF(OR($E$24=\"?\",F41=0),\"\",F41/$F$23*$E$24)","v":0.7095652173913044},null,{"$f":"IF(OR($E$24=\"?\",F41=0),\"\",($R$17-G41)/$R$17)","v":0.31999999999999995},null,null,null,null,null,null,null,{"$f":"$F$36/1000","v":51.2},{"$f":"IF(T41-Q41<0,R40+1,T41-Q41)","v":9.7999999999999972},{"$f":"IF($S40=\"40\",\"40\",IF($S40=\"60\",\"40\",IF($S40=\"80\",\"60\",IF($S40=\"110\",\"80\",IF($S40=\"130\",\"110\",IF($S40=\"155\",\"130\",IF($S40=\"175\",\"155\",\"175\")))))))","v":"40"},{"$f":"S41*$O$36","v":40},null,null,null,{"$f":"$F$37/1000","v":54.4},{"$f":"IF(AA41-X41<0,Y40+1,AA41-X41)","v":6.6000000000000014},{"$f":"IF($S40=\"40\",\"40\",IF($S40=\"60\",\"40\",IF($S40=\"80\",\"60\",IF($S40=\"110\",\"80\",IF($S40=\"130\",\"110\",IF($S40=\"155\",\"130\",IF($S40=\"175\",\"155\",\"175\")))))))","v":"40"},{"$f":"Z41*$O$36","v":40}]
[null,"Car Wash, Outdoor & Harsh Environment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$36/1000","v":51.2},{"$f":"IF(T42-Q42<0,R41+1,T42-Q42)","v":10.799999999999997},{"$f":"IF($S41=\"40\",\"40\",IF($S41=\"60\",\"40\",IF($S41=\"80\",\"60\",IF($S41=\"110\",\"80\",IF($S41=\"130\",\"110\",IF($S41=\"155\",\"130\",IF($S41=\"175\",\"155\",\"175\")))))))","v":"40"},{"$f":"S42*$O$36","v":40},null,null,null,{"$f":"$F$37/1000","v":54.4},{"$f":"IF(AA42-X42<0,Y41+1,AA42-X42)","v":7.6000000000000014},{"$f":"IF($S41=\"40\",\"40\",IF($S41=\"60\",\"40\",IF($S41=\"80\",\"60\",IF($S41=\"110\",\"80\",IF($S41=\"130\",\"110\",IF($S41=\"155\",\"130\",IF($S41=\"175\",\"155\",\"175\")))))))","v":"40"},{"$f":"Z42*$O$36","v":40}]
[null,"Harsh Environment",{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"IW\",IF(P36=\"40\",\"P40U-IW\",\"IW-\"&$P$37&\"-\"&$R$37))","v":"IW-60-20"},{"$f":"D37","v":1},{"$f":"E37","v":60000},{"$f":"F37","v":54400},{"$f":"G37","v":0.7095652173913044},null,{"$f":"IF(OR($E$24=\"?\",F43=0),\"\",($R$17-G43)/$R$17)","v":0.31999999999999995},null,null,null,null,null,null,null,{"$f":"$F$36/1000","v":51.2},{"$f":"IF(T43-Q43<0,R42+1,T43-Q43)","v":11.799999999999997},{"$f":"IF($S42=\"40\",\"40\",IF($S42=\"60\",\"40\",IF($S42=\"80\",\"60\",IF($S42=\"110\",\"80\",IF($S42=\"130\",\"110\",IF($S42=\"155\",\"130\",IF($S42=\"175\",\"155\",\"175\")))))))","v":"40"},{"$f":"S43*$O$36","v":40},null,null,null,{"$f":"$F$37/1000","v":54.4},{"$f":"IF(AA43-X43<0,Y42+1,AA43-X43)","v":8.6000000000000014},{"$f":"IF($S42=\"40\",\"40\",IF($S42=\"60\",\"40\",IF($S42=\"80\",\"60\",IF($S42=\"110\",\"80\",IF($S42=\"130\",\"110\",IF($S42=\"155\",\"130\",IF($S42=\"175\",\"155\",\"175\")))))))","v":"40"},{"$f":"Z43*$O$36","v":40}]
[null,"Outdoor/Car Wash",{"$f":"IF(OR(E28=0,E28=\"?\",E18=0),\"IWP\",IF(P36=\"40\",\"P40U-IP\",\"IWP-\"&$P$37&\"-\"&$R$37))","v":"IWP-60-20"},{"$f":"D37","v":1},{"$f":"E37","v":60000},{"$f":"F37","v":54400},{"$f":"G37","v":0.7095652173913044},null,{"$f":"IF(OR($E$24=\"?\",F44=0),\"\",($R$17-G44)/$R$17)","v":0.31999999999999995}]
[]
[null,"  High Intensity Heater Model ",null,"Qty","System Input 3","Reduced Heat Loss 2",{"$f":"IF(E24=\"?\",\"\",\"Cost / 60 min. Operation\")","v":"Cost / 60 min. Operation"},null,{"$f":"IF(E24=\"?\",\"\",\"Minimum Savings\")","v":"Minimum Savings"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Qty @ \"&Q49","v":"Qty @  10"},{"$f":"\"RndUp @ \"&Q49","v":"RndUp @  10"},"DRndUp",{"$f":"\"RndDn @ \"&Q49","v":"RndDn @  10"},"RndDn %",{"$f":"\"Qty @ \"&S49","v":"Qty @  6"},{"$f":"\"RndUp @ \"&S49","v":"RndUp @  6"},"DRndUp",{"$f":"\"RndDn @ \"&S49","v":"RndDn @  6"},"RndDn %"]
[null,null,null,null,"(Btuh)","(Btuh)"]
[null,"Commercial / Industrial Application"]
[null,"IL",{"$f":"IF(OR(E28=0,E18=0),\"\",P50)","v":" 10"},{"$f":"IF(OR(E28=0,E18=0),\"\",E49/R50)","v":2},{"$f":"IF(OR(E28=0,E18=0),\"\",U50*R50)","v":70000},{"$f":"$E$18*0.8","v":51200},{"$f":"IF(OR($E$24=\"?\",F49=0),\"\",F49/$F$23*$E$24)","v":0.66782608695652179},null,{"$f":"IF(OR($E$24=\"?\",F49=0),\"\",($R$17-G49)/$R$17)","v":0.35999999999999993},null,null,null,null,null,null,null,{"$f":"IF($E28<10,\"\",\" \"&IF($E28<13,\"6\",IF($E28<15.5,\"10\",IF($E28<18.5,\"13\",IF($E28<21.5,\"18\",IF($E28<32,\"26\",IF($E28<34,\"36\",\"52\")))))))","v":" 10"},{"$f":"IF(Q49=\" 6\",21500,IF(Q49=\" 10\",35000,IF(Q49=\" 13\",50000,IF(Q49=\" 18\",71500,IF(Q49=\" 26\",100000,IF(Q49=\" 36\",150000,IF(Q49=\" 52\",200000,0)))))))","v":35000},{"$f":"IF(Q49=\" 6\",0,IF(Q49=\" 10\",\" 6\",IF(Q49=\" 13\",\" 10\",IF(Q49=\" 18\",\" 13\",IF(Q49=\" 26\",\" 18\",IF(Q49=\" 36\",\" 26\",IF(Q49=\" 52\",\" 36\",\"\")))))))","v":" 6"},{"$f":"IF(S49=0,1,IF(S49=\" 6\",21500,IF(S49=\" 10\",35000,IF(S49=\" 13\",50000,IF(S49=\" 18\",71500,IF(S49=\" 26\",100000,IF(S49=\" 36\",150000,IF(S49=\" 52\",200000,0))))))))","v":21500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC50<0.021,S49,IF(U50<Z50,Q49,IF(AA50<V50,S49)))","v":" 10"},null,{"$f":"IF(P50=Q49,R49,T49)","v":35000},null,{"$f":"F49/(R49)","v":1.4628571428571429},{"$f":"ROUNDUP(T50,0)","v":2},{"$f":"U50-T50","v":0.53714285714285714},{"$f":"ROUNDDOWN(T50,0)","v":1},{"$f":"W50/T50","v":0.68359375},{"$f":"F49/T49","v":2.3813953488372093},{"$f":"ROUNDUP(Y50,0)","v":3},{"$f":"Z50-Y50","v":0.61860465116279073},{"$f":"ROUNDDOWN(Y50,0)","v":2},{"$f":"AB50/Y50","v":0.83984375}]
[null,"NOTES:"]
[null,"1 'Heat Loss Satisfied' is calculated by multiplying System Input by System Efficiency"]
[null,"e.g.: 125,000 Btuh unit heater that is 80% efficient will satisfy a heat loss of 125,000 x 0.8 = 100,000 Btuh"]
[null,"2 'Reduced Heat Loss': All radiant systems reduce heat loss. The 'reduction factor' depends upon the radiant efficiency of the radiant "]
[null,"heater - the greater the radiant efficiency, the larger the reduction factor. 'Operating Input' is calculated by multiplying the heat loss "]
[null,"to be satisfied by one minus the radiant reduction factor."]
[null,"e.g.: Using a radiant heater that has a reduction factor of 15%, a heat loss of 100,000 Btuh will be satisfied "]
[null," input of 100,000 x (1 - 0.15) = 100,000 x 0.85 = 85,000 Btuh"]
[null,"3 'Radiant System Input' is the nominal input of the system based on the number of heaters required multiplied by the unit input"]
[null," of each heater.  In operation,the radiant heating system will only consume the amount of fuel required to satisfy the "]
[null,"heat loss ( = 'Operating Input')"]
[]
[]
[null,"Instructions"]
[]
[1,"Current Conventional Heating System Input:   "]
[]
[null,"Information needed for input into this section of the tool:"]
[null,"1.  The total input of the current heaters being considered for replacement "]
[null,"2.  The efficiency for the type of heater: "]
[null," - 80% is the default value (2008 Standard for Unit Heaters and Boilers)"]
[null," - You can revise these values as required - for 'Older' Systems:  Forced Air - use 70%; Boiler - use 65%"]
[]
[null,"The Tool calculates the following:"]
[null,"a)  The Total Current Input to be replaced "]
[null,"b)  A 'satisfied heat loss'  based on the heater efficiencies"]
[null," - for example: at 80% efficiency, 1.25 million Btuh input unit heaters will satisfy a heat loss of 1 million"]
[]
[2,"Fuel Cost:"]
[]
[null,"Information needed for input into this section of the tool - base on 60 mins continuous operation of various system inputs:"]
[null,"1.   The Fuel Type of the project - Natural Gas, Propane or Oil"]
[null,"2.   The Fuel Units of the project - Therm, 1000 cu ft, cubic meters, gallons, liters"]
[null,"3.   The customer's Unit Fuel Price"]
[]
[3,"Radiant Heating System Recommendations: "]
[]
[null,"Information needed for input into this section of the tool - height of heaters determines proper heater input"]
[null,"1.  The height above the floor that the IR heaters will be mounted "]
[]
[null,"The Tool calculates the following:"]
[null,"a)  The quantities and sizes of radiant tube heaters, and high-intensity heaters "]
[]
[null,"IF, information was completed in Section 1:"]
[null,"b)  Comparative 60 mins operation costs for all heaters"]

{"sheet":"Tube Htr Kits","index":4,"n_rows":173,"n_cols":22,"rows_kept":173,"cut":false,"hidden":false,"merged":[[36,1,39,1],[17,3,17,5],[19,3,19,5],[19,7,19,8],[19,9,19,14],[18,3,18,5],[19,16,19,17],[20,3,20,5],[20,7,20,8],[20,9,20,14],[13,9,13,11],[17,7,17,8],[17,9,17,14],[17,16,17,17],[18,7,18,8],[18,9,18,14],[4,9,4,10],[9,9,9,13],[10,9,10,13],[12,9,12,11],[11,9,11,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J12=\"Btuh x Tube Length\",0,1)","v":1}]
[]
[null,"Tube Heater Kit & Accessory Selection Guide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(J11,FIND(\" \",J11)-1)","v":"Now"},null,"Now",null,null,{"$f":"AND(U7=40,U8=\"STW-JZ\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USA"]
[null,null,null,null,null,null,null,"Select your Country*",null,{"$f":"'1. Project Details'!C6","v":"USA"},null," - Selects proper gas connector",null,null,null,null,null,{"$f":"IF(ISERR(U7),U10,U7)","v":{"$error":"#VALUE!"}},null,null,"CANADA",",IF(AND(U7=\"40\",U8=\"SPW-JZ\"),\"P40U-P\""]
[]
[null,"TUBE HEATER REQUIREMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-09-08"},null,null,{"$f":"IF(V1=0,\"\",VALUE(LEFT(J12,FIND(\",\",J12)-1)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(J11,FIND(\" \",J11)-1)","v":"Now"},{"$f":"IF(U8=\"P40R\",U8,IF(AND(U7=40,U8=\"IW\"),\"P40U-IW\",IF(AND(U7=40,U8=\"IWP\"),\"P40U-IP\",\"P40U-I\")))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,"1.  Application*",null,"Select APPLICATION Here",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(FIND(\"/\",J12)=3,VALUE(LEFT(J12,2)),VALUE(LEFT(J12,3)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"2.  Heater Series*",null,"Now Select Tube Heater Series Here",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U7=40,V8,LEFT(U12,LEN(U12)-3))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"3.  Input & Length*",null,"SELECT Btuh x Tube Length",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U7=40,V8,LEFT(J11,FIND(\" \",J11)-1)&\"-\"&VLOOKUP(J12,K67:L89,2,FALSE))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"4.  Quantity Required*",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(RIGHT(U12,2)/10,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"Chain length required at each hanger",null,null,null,null,{"$f":"\"ft  (a value here will calculate the required Suspension Hardware)\"","v":"ft  (a value here will calculate the required Suspension Hardware)"},null,null,null,null,null,null,null,{"$f":"IF(U7=40,V8,LEFT(U11,3))","v":{"$error":"#VALUE!"}}]
[]
[null,"TUBE HEATER KIT ORDER"]
[]
[null,null,null,"KITS:",null,null,"Qty","Part #",null,"Description",null,null,null,null,null,null,null,null,null,null,{"$f":"MID(U11,FIND(\"-\",U11)-1,1)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(V1=0,\"Burner Kit\",IF(U7=40, \"Complete Packaged Heater\",\"Burner Kit \"))","v":{"$error":"#VALUE!"}},null,null,{"$f":"$J$13","v":0},{"$f":"IF($J$12=\"Btuh x Tube Length\",\"\",VLOOKUP($U$11,'1'!$A:$C,3,FALSE))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($J$12=\"Btuh x Tube Length\",\"\",VLOOKUP($U$11,'1'!$A:$D,4,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"'U' Tube"]
[null,null,null,{"$f":"IF(U7=40,\"\",IF(H21=\" \",\"Tube Kit \",\"Primary Tube Kit \"))","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(U7=40,\"\",IF($J$13=\"?\",\"?\",VLOOKUP($U$12,'2'!$A:$B,2,FALSE)*$J$13))","v":{"$error":"#VALUE!"}},{"$f":"IF(U7=40,\"\",IF($J$12=\"Btuh x Tube Length\",\"\",VLOOKUP($U$12,'2'!$A:$C,3,FALSE)))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Q3=\"p40r\",\"This heater is approved as a 'Vented Room Heater'\",IF(U7=40,\"\",IF($J$12=\"Btuh x Tube Length\",\"\",VLOOKUP($U$12,'2'!$A:$D,4,FALSE))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U18=\"U\",(U13*4+1),0)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(U7=40, \"\",IF(J12=\"Btuh x Tube Length \",\"\",IF(G21=\" \",\" \",\"And Secondary Tube Kit \")))","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(U7=40,\"\",IF($J$13=\"?\",\"\",IF($H$21=\" \",\" \",VLOOKUP($U$12,'2'!$A:$F,5,FALSE)*$J$13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(U7=40,\"\",IF($J$12=\"Btuh x Tube Length\",\"\",IF(VLOOKUP($U$12,'2'!$A:$F,6,FALSE)=0,\" \",VLOOKUP(U12,'2'!$A:$F,6,FALSE))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(U7=40,\"\",IF($J$12=\"Btuh x Tube Length\",\"\",IF(VLOOKUP($U$12,'2'!$A:$H,7,FALSE)=0,\" \",VLOOKUP($U$12,'2'!$A:$H,7,FALSE))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Suspension Points / Htr"]
[null,null,null,null,null,"NG to LP Conversion Kit ",{"$f":"$G$19","v":0},{"$f":"IF($J$12=\"Btuh x Tube Length\",\"\",VLOOKUP($U$11,'1'!$A:$E,5,FALSE))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Gas Connection ",{"$f":"IF(OR($J$12=\"Btuh x Tube Length\",U8=\"p40r\"),\"\",$J$13)","v":0},{"$f":"IF($J$12=\"Btuh x Tube Length\",\"\",IF($J$5=\"USA\",VLOOKUP($H$19,'1'!$C:$G,5,FALSE),VLOOKUP($H$19,'1'!$C:$G,4,FALSE)))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U7=40,4,IF(U20=0,IF(OR(U14=\"SET\",U14=\"S10\"),2*U13+1,U13+2),U20))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($H$23=\"\",U8=\"p40r\"),\"\",\"(MANDATORY BY CODE)\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chain Length"]
[null,null,"OPTIONAL ACCESSORIES:  ",null,null,null,"Qty","Part #",null,"Refer to Price List for other Accessories not listed below",null,null,null,null,null,null,null,null,null,null,{"$f":"U23*J13*J14","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Suspension Hardware ",{"$f":"IF(ISNUMBER(J14),U29,\"?\")","v":"?"},{"$f":"IF(J14=\"?\",\"Requires\",\"JL-0800-XX\")","v":"JL-0800-XX"},null,{"$f":"IF(J14=\"?\",\"a value in cell I7 above\",\"#2 Lion Chain - 115 lb work load - 200 ft roll\")","v":"#2 Lion Chain - 115 lb work load - 200 ft roll"},null,null,null,null,{"$f":"IF(J12=\"Btuh x Tube Length\",\"\",U23&\" suspension points per heater\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Chain Boxes"]
[null,null,null,null,null,{"$f":"IF(J14=\"?\",\"\",\"and \")","v":"and "},{"$f":"IF(ISNUMBER(J14),U33,\"\")","v":""},{"$f":"IF(J14=\"?\",\"\",\"JL-0798-SH\")","v":"JL-0798-SH"},null,{"$f":"IF(J14=\"?\",\"\",U35)","v":"S' Hooks - 1-7/8\" - Package of 25"},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(U27/200,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Vent Terminals ",{"$f":"J13","v":0},"JA-0528-XX",null,"4\" Horizontal Vent Terminal",null,null,"or if vent through roof -  use 'B' vent cap from vent manufacturer"]
[null,null,null,null,null,"Combustion Air ",{"$f":"IF(OR(Q3=\"SPW-JZ\",Q3=\"STW-JZ\",Q3=\"STR-JZ\",U8=\"p40r\"),\"\",J13)","v":0},{"$f":"IF(Q3=\"P40R\",\"-->\",IF(OR(Q3=\"SPW-JZ\",Q3=\"STW-JZ\",),\"\",\"JS-0532-VC\"))","v":"JS-0532-VC"},null,{"$f":"IF(Q3=\"P40R\",\"Outside air duct not allowed; This heater is approved as a 'Vented Room Heater'; \",IF(OR(Q3=\"SPW-JZ\",Q3=\"STW-JZ\"),\"INCLUDED: Fresh Air Intake: 4\"\" Wall Cap\",\"Fresh Air Intake - 4\"\" Wall Cap\"))","v":"Fresh Air Intake - 4\" Wall Cap"},null,null,null,null,null,null,null,null,null,null,"'S' Hooks"]
[null,null,null,null,null,{"$f":"IF(Q3=\"P40R\",\"\",\"or \")","v":"or "},{"$f":"IF(Q3=\"P40R\",\"\",J13)","v":0},{"$f":"IF(Q3=\"P40R\",\"\",\"JA-0530-XX\")","v":"JA-0530-XX"},null,{"$f":"IF(Q3=\"P40R\",\"Provide combustion air to space per national & local code requirements\",\"OPTION: Fresh Air Intake - 4\"\" Roof Cap\")","v":"OPTION: Fresh Air Intake - 4\" Roof Cap"}]
[null,null,null,null,null,{"$f":"IF(J12=\"Btuh x Tube Length\",\"\",IF(OR($Q$3=\"S100 \",$Q$3=\"S100U \",Q3=\"SET \",Q3=\"SETU \"),\"plus either cap requires \",\"\"))","v":""},{"$f":"IF(OR($Q$3=\"S100\",$Q$3=\"S100U\",Q3=\"SET\",Q3=\"SETU\"),J13,\"\")","v":""},{"$f":"IF(Q3=\"p40r\",\"\",IF(OR(Q3=\"SPW-JZ\",Q3=\"STS-JZ\",Q3=\"STW-JZ\",Q3=\"STR-JZ\"),\"\",\"JS-0532-SE\"))","v":"JS-0532-SE"},null,{"$f":"IF(Q3=\"p40r\",\"\",IF(OR($Q$3=\"S100\",$Q$3=\"S100U\",Q3=\"SET\",Q3=\"SETU\"),\"Fresh Air Intake Adapter 4\"\" - Field Installs on Burner Cabinet\",\"INCLUDED: Fresh Air Intake Adapter 4in. Factory )Installed on Burner\"))","v":"INCLUDED: Fresh Air Intake Adapter 4in. Factory )Installed on Burner"},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(2*U23*J13/25,0)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"THERMOSTATS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S' Hooks - 1-7/8\" - Package of 25"]
[null,null,{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",$Q$3=\"STW-JZ\",$Q$3=\"SPW-JZ\"),\"\",\"NOTE: Thermostat Quantity & voltage depends on the control logic used on site\")","v":"NOTE: Thermostat Quantity & voltage depends on the control logic used on site"}]
[null,"       24 V        T-STATS",null,null,null,null,{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\"),J13,\"\")","v":""},{"$f":"IF(Q3=\"P40R\",\"\",IF(OR($Q$3=\"SET\",$Q$3=\"SETU\"),\"JS-0569-DT\",IF(OR(Q3=\"STW-JZ\",Q3=\"SPW-JZ\"),\"JS-0570-XX\",\"JM-0150-XX\")))","v":"JM-0150-XX"},null,{"$f":"IF(Q3=\"P40R\",\"\",VLOOKUP(H37,D79:E81,2,FALSE))","v":"24V TruTemp Infrared Setback Thermostat"},null,null,null,null,{"$f":"IF(H37=\"JS-0569-DT\",\"REQUIRED THERMOSTAT for 2 STAGE\",IF(H37=\"JM-0150-XX\",\"RECOMMENDED FOR COMFORT & FUEL SAVINGS\",\"\"))","v":"RECOMMENDED FOR COMFORT & FUEL SAVINGS"}]
[null,null,null,null,null,{"$f":"IF(Q3=\"P40R\",\"P40R Includes\",IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\"),\"\",\"or\"))","v":"or"},null,{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\"),\"\",\"JS-0569-WR\")","v":"JS-0569-WR"},null,{"$f":"IF(Q3=\"STR-JZ\",\"24V Digital Thermostat with 20 ft Thermostat Wire\",IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\"),\"\",\"24V Digital Thermostat\"))","v":"24V Digital Thermostat"}]
[null,null,null,null,null,null,{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"str-jz\"),\"\",IF(OR($Q$3=\"S100\",$Q$3=\"S100U\",Q3=\"STR-JZ\"),\"a Single Heater per 24V T-stat Requires: \",\"\"))","v":""},{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"str-jz\"),\"\",IF(OR($Q$3=\"S100\",$Q$3=\"S100U\",Q3=\"STR-JZ\"),\"JS-0568-KT\",\"\"))","v":""},null,{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"str-jz\"),\"\",IF(OR($Q$3=\"S100\",$Q$3=\"S100U\",Q3=\"STR-JZ\"),\"24V Thermostat Control Relay Kit - Field Mounts inside Burner\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(J13=1,$Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\",Q3=\"str-jz\"),\"\",\"Multiple heaters per 24V T-stat require: \")","v":"Multiple heaters per 24V T-stat require: "},{"$f":"IF(OR(J13=1,$Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\",Q3=\"str-jz\"),\"\",\"JM-0303-KT\")","v":"JM-0303-KT"},null,{"$f":"IF(OR(J13=1,$Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\",Q3=\"str-jz\"),\"\",\"Control Center Kit for 24V Thermostat - Field Mounts in Zone\")","v":"Control Center Kit for 24V Thermostat - Field Mounts in Zone"}]
[null,"120 V",null,null,null,null,{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",Q3=\"STW-JZ\",Q3=\"SPW-JZ\",Q3=\"P40R\"),\"\",\"or use a line voltage thermostat \")","v":"or use a line voltage thermostat "},{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",$Q$3=\"STW-JZ\",$Q$3=\"SPW-JZ\",Q3=\"P40R\"),\"\",\"JL-0772-XX\")","v":"JL-0772-XX"},null,{"$f":"IF(OR($Q$3=\"SET\",$Q$3=\"SETU\",$Q$3=\"STW-JZ\",$Q$3=\"SPW-JZ\",Q3=\"P40R\"),\"\",\"Line Voltage Thermostat (control 1 to 12 heaters)\")","v":"Line Voltage Thermostat (control 1 to 12 heaters)"}]
[]
[null,"Instructions"]
[null,1,"Select YOUR Country in the 'drop down menu' = different gas connectors are required in North America depending on the Country"]
[null,2,"Select the general heating application from the 'drop down menu' = determines the heater models available for the application"]
[null,3,"Select the desired heater model from the 'drop down menu' = models available to suit the application or budget"]
[null,4,"Select the desired firing rate and heater length from the 'drop down menu' = determines correct burner and tube kits with part numbers"]
[null,5,"Enter the quantity of heaters required"]
[null,6,"Enter the number of feet that the heater will be suspended below the mounting point to the structure = determines mounting hardware "]
[null,null,"- required based on model, quantity of heaters and the length of chain at each hanger"]
[null,null,"NOTE: Recommended accessories are indicated below the heater kits: "]
[null,null,"- Suspension chain 7 'S'-hooks; Vent Terminals; Outside combustion air components"]
[null,null,"NOTE:  Thermostat Control options are listed - quantity and type depend upon requirements at the project site."]
[]
[]
[null,null,null,"IQ - Premier Commercial / Industrial"]
[null,null,null,"ITB - Builder Market Straight Tube"]
[null,null,null,"ITBU - Builder Market 'U' Tube"]
[null,null,null,"ITT - Two Stage Straight Tube"]
[null,null,null,"ITTU - Two Stage 'U' Tube"]
[null,null,null,"IW - Car Wash & Harsh Environment"]
[null,null,null,"IWP - Outdoor & Damp Environment"]
[null,null,null,"P40R - Residential Garage / Shop"]
[]
[null,null,null,{"$f":"IF(J10=D90,\"SELECT 'APPLICATION' ABOVE 1ST\",\"Now Select Tube Heater Series Here\")","v":"SELECT 'APPLICATION' ABOVE 1ST"}]
[null,null,null,{"$f":"IF(J10=D90,\"SELECT 'APPLICATION' ABOVE 1ST\",IF(J10=\"Residential Garage / Shop Heater\",D63,IF(J10=\"Car Wash / Outdoor\",D61,IF(J10=\"Commercial / Industrial\",D56,IF(J10=\"2 STAGE Commercial / Industrial\",D59,\"Select Tube Heater Series Here\")))))","v":"SELECT 'APPLICATION' ABOVE 1ST"},null,null,null,null,null,null,"SELECT Btuh x Tube Length"]
[null,null,null,{"$f":"IF(J10=D90,\"\",IF(J10=\"Residential Garage / Shop Heater\",\"\",IF(J10=\"Car Wash / Outdoor\",D62,IF(J10=\"2 STAGE Commercial / Industrial\",D60,D57))))","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,N67:O74,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N67:P74,3,FALSE)","v":{"$error":"#N/A"}},null,"P40R","40,000 x 10'U","40-10U"]
[null,null,null,{"$f":"IF(J10=D90,\"\",IF(J$10=\"Residential Garage / Shop Heater\",\"\",IF(J$10=\"Car Wash / Outdoor\",\"\",IF(J10=\"2 STAGE Commercial / Industrial\",\"\",D58))))","v":""},null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,N76:O82,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N76:P82,3,FALSE)","v":{"$error":"#N/A"}},null,"P40R","40,000 x 10'U","40-10U"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($Q$3,$N$84:$O$90,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($Q$3,$N$84:$P$90,3,FALSE)","v":{"$error":"#N/A"}},null,"P40R","40,000 x 10'U","40-10U"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($Q$3,$N$92:O98,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($Q$3,$N$92:P98,3,FALSE)","v":{"$error":"#N/A"}},null,"P40R","40,000 x 10'U","40-10U"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,N100:P106,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N100:P106,3,FALSE)","v":{"$error":"#N/A"}},null,"P40U-I","40,000 x 10'U","40-10U"]
[null,null,null,null,null,null,null,null,null,6,{"$f":"VLOOKUP(Q3,N108:O114,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N108:P114,3,FALSE)","v":{"$error":"#N/A"}},null,"ITBU","60,000 x 10'U","60-10"]
[null,null,null,null,null,null,null,null,null,7,{"$f":"VLOOKUP(Q3,N116:O122,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N116:P122,3,FALSE)","v":{"$error":"#N/A"}},null,"ITT","80,000/60,000 x 20'","80/60-20"]
[null,null,null,"JL-0771-RC","Type 1 Hose Connector 1/2\" x 36\": inputs 45 to 110 Mbh - CANADA",null,null,null,null,8,{"$f":"VLOOKUP(Q3,N124:O130,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N124:P130,3,FALSE)","v":{"$error":"#N/A"}},null,"ITTU","80,000/60,000 x 10'U","80/60-10"]
[null,null,null,"JL-0771-RB","Type 1 Hose Connector 3/4\" x 36\": inputs 130 to 200 Mbh - CANADA",null,null,null,null,9,{"$f":"VLOOKUP(Q3,N132:O138,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N132:P138,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"JL-0771-XX","Flexible Gas Connector 1/2\" x 24\": inputs 45 to 130 Mbh - USA ONLY",null,null,null,null,null,{"$f":"VLOOKUP(Q3,N140:O146,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N140:P146,3,FALSE)","v":{"$error":"#N/A"}},null,"IQ","45,000 x 20'","45-20"]
[null,null,null,"JL-0771-YY","Flexible Gas Connector 3/4\" x 36\": inputs 155 to 200 Mbh - USA ONLY",null,null,null,null,null,{"$f":"VLOOKUP(Q3,N148:O153,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N148:P153,3,FALSE)","v":{"$error":"#N/A"}},null,"ITB","45,000 x 20'","45-20"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,N156:O162,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,N156:P162,3,FALSE)","v":{"$error":"#N/A"}},null,"IW","45,000 x 20'","45-20"]
[null,null,null,"JS-0569-DT","Two Stage 24V Digital Thermostat",null,null,null,null,null,{"$f":"VLOOKUP(Q3,R85:T91,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R85:T91,3,FALSE)","v":{"$error":"#N/A"}},null,"IWP","45,000 x 20'","45-20"]
[null,null,null,"JM-0150-XX","24V TruTemp Infrared Setback Thermostat",null,null,null,null,null,{"$f":"VLOOKUP(Q3,R94:T100,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R94:T100,3,FALSE)","v":{"$error":"#N/A"}},null,"ITBU","80,000 x 10'U","80-10"]
[null,null,null,"JS-0570-XX","Moisture Proof Thermostat (NEMA 4X Enclosure)",null,null,null,null,null,{"$f":"VLOOKUP(Q3,R103:S109,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R103:T109,3,FALSE)","v":{"$error":"#N/A"}},null,"ITT","80,000/60,000 x 30'","80/60-30"]
[null,null,null,"TG-0010-KT","Tuxedo Grille 10 ft Kit for STS-JZ Series",null,null,null,null,null,{"$f":"VLOOKUP(Q3,R111:S117,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R111:T117,3,FALSE)","v":{"$error":"#N/A"}},null,"ITTU","80,000/60,000 x 15'U","80/60-15"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,R119:S125,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R119:T125,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,R127:S133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R127:T133,3,FALSE)","v":{"$error":"#N/A"}},null,"IQ","60,000 x 20'","60-20"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,R135:S141,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R135:T141,3,FALSE)","v":{"$error":"#N/A"}},null,"ITB","60,000 x 20'","60-20",null,"IQ","130,000 x 40'","130-40"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,R143:S149,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R143:T149,3,FALSE)","v":{"$error":"#N/A"}},null,"IW","60,000 x 20'","60-20",null,"ITB","130,000 x 40'","130-40"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,R151:S157,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R151:T157,3,FALSE)","v":{"$error":"#N/A"}},null,"IWP","60,000 x 20'","60-20",null,"IW","130,000 x 50'","130-50"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,R159:S165,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R159:T165,3,FALSE)","v":{"$error":"#N/A"}},null,"ITBU","80,000 x 15'U","80-15",null,"IWP","130,000 x 50'","130-50"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q3,R167:S173,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q3,R167:T173,3,FALSE)","v":{"$error":"#N/A"}},null,"ITT","110,000/75,000 x 30'","110/75-30",null,"ITT"]
[null,null,null,"Select APPLICATION Here",null,null,null,null,null,null,null,null,null,"ITTU","110,000/75,000 x 15'U","110/75-15",null,"ITBU"]
[null,null,null,"Commercial / Industrial",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU"]
[null,null,null,"2 STAGE Commercial / Industrial",null,null,null,null,null,null,null,null,null,"IQ","60,000 x 30'","60-30"]
[null,null,null,"Car Wash / Outdoor",null,null,null,null,null,null,null,null,null,"ITB","60,000 x 30'","60-30"]
[null,null,null,"Residential Garage / Shop Heater",null,null,null,null,null,null,null,null,null,"IW","60,000 x 30'","60-30",null,"IQ","130,000 x 50'","130-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","60,000 x 30'","60-30",null,"ITB","130,000 x 50'","130-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","110,000 x 15'U","110-15",null,"IW","155,000 x 40'","155-40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","110,000/75,000 x 40'","110/75-40",null,"IWP","155,000 x 40'","155-40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU","110,000/75,000 x 20'U","110/75-20",null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","80,000 x 20'","80-20",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","80,000 x 20'","80-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","80,000 x 20'","80-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","80,000 x 20'","80-20",null,"IQ","155,000 x 40'","155-40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","110,000 x 20'U","110-20",null,"ITB","155,000 x 40'","155-40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","130,000/90,000 x 30'","130/90-30",null,"IW","155,000 x 50'","155-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU","130,000/90,000 x 15'U","130/90-15",null,"IWP","155,000 x 50'","155-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","80,000 x 30'","80-30",null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","80,000 x 30'","80-30",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","80,000 x 30'","80-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","80,000 x 30'","80-30",null,"IQ","155,000 x 50'","155-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","130,000 x 15'U","130-15",null,"ITB","155,000 x 50'","155-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","130,000/90,000 x 40'","130/90-40",null,"IW","155,000 x 60'","155-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU","130,000/90,000 x 20'U","130/90-20",null,"IWP","155,000 x 60'","155-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","80,000 x 40'","80-40",null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","80,000 x 40'","80-40",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","80,000 x 40'","80-40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","80,000 x 40'","80-40",null,"IQ","155,000 x 60'","155-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","130,000 x 20'U","130-20",null,"ITB","155,000 x 60'","155-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","155,000/110,000 x 40'","155/110-40",null,"IW","175,000 x 50'","175-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU","155,000/110,000 x 20'U","155/110-20",null,"IWP","175,000 x 50'","175-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","100,000 x 20'","100-20",null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","100,000 x 20'","100-20",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","110,000 x 30'","110-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","110,000 x 30'","110-30",null,"IQ","175,000 x 50'","175-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","155,000 x 20'U","155-20",null,"ITB","175,000 x 50'","175-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","155,000/110,000 x 50'","155/110-50",null,"IW","175,000 x 60'","175-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU","155,000/110,000 x 30'U","155/110-30",null,"IWP","175,000 x 60'","175-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","110,000 x 30'","110-30",null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","110,000 x 30'","110-30",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","110,000 x 40'","110-40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","110,000 x 40'","110-40",null,"IQ","175,000 x 60'","175-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","155,000 x 30'U","155-30",null,"ITB","175,000 x 60'","175-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","175,000/125,000 x 50'","175/125-50",null,"IW","175,000 x 70'","175-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU","175,000/125,000 x 30'U","175/125-30",null,"IWP","175,000 x 70'","175-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","110,000 x 40'","110-40",null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","110,000 x 40'","110-40",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","110,000 x 50'","110-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","110,000 x 50'","110-50",null,"IQ","175,000 x 70'","175-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","175,000 x 30'U","175-30",null,"ITB","175,000 x 70'","175-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","175,000/125,000 x 60'","175/125-60",null,"IW","200,000 x 50'","200-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU","200,000/140,000 x 30'U","200/140-30",null,"IWP","200,000 x 50'","200-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","110,000 x 50'","110-50",null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","110,000 x 50'","110-50",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","130,000 x 30'","130-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","130,000 x 30'","130-30",null,"IQ","200,000 x 50'","200-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU","200,000 x 30'U","200-30",null,"ITB","200,000 x 50'","200-50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","200,000/140,000 x 50'","200/140-50",null,"IW","200,000 x 60'","200-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU",null,null,null,"IWP","200,000 x 60'","200-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","130,000 x 30'","130-30",null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","130,000 x 30'","130-30",null,"ITTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IW","130,000 x 40'","130-40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP","130,000 x 40'","130-40",null,"IQ","200,000 x 60'","200-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT","200,000/140,000 x 60'","200/140-60",null,"ITB","200,000 x 60'","200-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU",null,null,null,"IW","200,000 x 70'","200-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU",null,null,null,"IWP","200,000 x 70'","200-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","200,000 x 70'","200-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITB","200,000 x 70'","200-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IWP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITBU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITTU"]

{"sheet":"X-Ref Tubes- Straight","index":5,"n_rows":186,"n_cols":28,"rows_kept":186,"cut":false,"hidden":false,"merged":[[2,13,2,14],[0,2,0,4],[2,2,2,3],[2,6,2,8],[2,9,2,10],[2,11,2,12],[2,4,2,5],[2,18,2,19],[2,20,2,21],[2,26,2,27],[185,16,185,17],[2,15,2,17]]}
[null,null,"Click here to go to Instructions"]
["TUBES - STRAIGHT COMPARISONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vacuum systems 'suck'"]
["BTU/hr ","Tube","InfraSave",null,"Schwank",null,"Detroit Radiant (Reverberay)",null,null,"Roberts Gordon",null,"Superior Radiant",null,"Solaronics",null,"Space Ray",null,null,"Reznor",null,"Modine",null,"Sterling","Enerco","Calcana","AmbiRad","Easy Radiant"]
[null,null,"PREMIER","BUILDER","PREMIER","BUILDER",null,null,null,null,null,"Economy",null,null,null,null,"Vacuum","Vacuum"]
["Input","Length","IQ ","ITB ","STS-JZ ","S100 ","DX-2 Series","XTS Series","DES Series","Gordonray BH","Vantage II","UA / UX Series","LA / LX Series","Suntube IV","GQ Series","PTS","LTS Series","ETS","VR Series","TR Series","TLP Series","LF / HF Series","SLR Series","ERXL Series","SR Series","PT Series","EZ Series","SH Series"]
[30000,30,null,null,null,null,null,null,null,null,null,null,"LA (X)-40 30"]
[40000,10,"P40U-I","P40U-I","P40U","P40U",null,null,null,"BH40  10","CTH2-40  10","UA (X) 04  10",null,"STG40   10","GCG40   10","PTS40-10",null,null,null,null,null,"LF40  20","SLR40  10",null,"SR-40  10","PT40  10"]
[null,15,null,null,null,null,null,null,null,null,null,null,null,"STG40   15","GCG40   15",null,"LTS40-15","ETS40-15",null,null,null,"LF40  30","SLR40  15",null,"SR-40  15"]
[null,20,null,null,null,null,null,null,null,null,null,"UA (X) 04  20",null,"STG40   20","GCG40   20","PTS40-20","LTS40-20","ETS40-20",null,null,null,null,"SLR40  20",null,"SR-40  20"]
[null,30,null,null,null,null,null,null,null,null,null,null,"LA (X)-40 40"]
[null,40]
[45000,20,"IQ 45   20","ITB 45 20","STS-JZ 45   20","S100-45-20",null,null,null,null,null,null,null,"STG45   20","GCG45   20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LA (X)-60 30"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LA (X)-60 40"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LA (X)-60 50"]
[50000,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS50-15","ETS50-15",null,null,null,null,"SLR50  15",null,"SR-50  15"]
[null,20,"IQ 45   20","ITB 45 20","STS-JZ 45   20","S100-45-20","DX2-20-50","XTS-20-50","DES-20-50",null,null,null,null,"STG50   20","GCG50   20","PTS50-20","LTS50-20","ETS50-20","VR50    20","TR50  20","TLP50    20","LF50  20","SLR50  20",null,"SR-15  20"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS50-25"]
[null,30,null,null,null,null,"DX2-30-50","XTS-30-50","DES-30-50",null,null,null,null,null,null,"PTS50-30","LTS50-30","ETS50-30","VR50    30","TR50  30","TLP50    30","LF50  30"]
[null,40,null,null,null,null,"DX2-40-50","XTS-40-50","DES-40-50",null,null,null,null,null,null,null,null,null,"VR50    40"]
[55000,20,null,null,null,null,null,null,null,null,null,null,null,"STG55   20","GCG55   20"]
[60000,20,"IQ60    20","ITB 60    20","STS-JZ 60    20","S100 60    20","DX2-20-60","XTS-20-60","DES-20-60","BH60  20","CTH2-60  20","UA (X) 06  20",null,"STG60   20","GCG60   20",null,"LTS60-20","ETS60-20",null,null,"TLP60    20","LF60  20","SLR60  20","ERXL60  20","SR-60  20","PT60  20","EZ-60-20","SH-60-20"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS60-25"]
[null,30,"IQ60    30","ITB 60    30","STS-JZ 60    30","S100 60    30","DX2-30-60","XTS-30-60","DES-30-60",null,null,"UA (X) 06  30","LA (X)-60 30",null,null,null,"LTS60-30","ETS60-30",null,null,"TLP60    30","LF60  30","SLR60  30",null,"SR-60  30","PT60  30"]
[null,40,null,null,null,null,"DX2-40-60","XTS-40-60","DES-40-60",null,null,null,"LA (X)-60 40",null,null,null,null,null,null,null,"TLP60    40","LF60  40","SLR60  40",null,"SR-60  40","PT60  40"]
[null,50,null,null,null,null,null,null,null,null,null,null,"LA (X)-60 50"]
[65000,20,null,null,null,null,null,null,null,null,null,null,null,"  STG65   20*","  GCG65   20*"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,"  STG65   25*","  GCG65   25*"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,"STG65   30","GCG65   30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG65   35","GCG65   35"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"STG65   40","GCG65   40"]
[70000,20,null,null,null,null,null,null,null,null,null,null,null,"  STG70   20*","  GCG70   20*"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,"  STG70   25*","  GCG70   25*"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,"STG70   30","GCG70   30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG70   35","GCG70   35"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"STG70   40","GCG70   40"]
[75000,20,null,null,null,null,"DX2-20-75","XTS-20-75","DES-20-75",null,null,null,null,"  STG75   20*","  GCG75   20*","PTS75-20","LTS75-20","ETS75-20","VR75   20","TR75  20",null,"LF75  20 ","SLR75  20",null,"SR-75  20",null,"EZ-75-20","SH-75-20"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,"  STG75   25*","  GCG75   25*",null,"LTS75-25"]
[null,30,null,null,null,null,"DX2-30-75","XTS-30-75","DES-30-75",null,null,null,null,"STG75   30","GCG75   30","PTS75-30","LTS75-30","ETS75-30","VR75   30","TR75  30","TLP75    30","LF75  30 ","SLR75  30",null,"SR-75  30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG75   35","GCG75   35"]
[null,40,null,null,null,null,"DX2-40-75","XTS-40-75","DES-40-75",null,null,null,null,"STG75   40","GCG75   40",null,null,null,"VR75   40","TR75  40","TLP75    40","LF75  40 ","SLR75  40",null,"SR-75  40"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TLP75    50"]
[80000,20,"IQ80    20","ITB 80    20","STS-JZ 80    20","S100 80    20",null,null,null,"BH80  20","CTH2-80  20","UA (X) 08  20",null,"  STG80   20*","  GCG80   20*",null,null,null,null,null,null,null,"SLR80  20","ERXL80  20","SR-80  20","PT80  20"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,"  STG80   25*","  GCG80   25*"]
[null,30,"IQ80    30","ITB 80    30","STS-JZ 80    30","S100 80    30",null,null,null,"BH80  30","CTH2-80  30","UA (X) 08  30",null,"STG80   30","GCG80   30",null,"LTS80-30","ETS80-30",null,null,null,null,"SLR80  30","ERXL80  30","SR-80  30","PT80  30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG80   35","GCG80   35",null,"LTS80-35"]
[null,40,"IQ80    40","ITB 80    40","STS-JZ 80    40","S100 80    40",null,null,null,null,null,"UA (X) 08  40","LA (X)-80 40","STG80   40","GCG80   40",null,"LTS80-40","ETS80-40",null,null,null,null,"SLR80  40",null,"SR-80  40","PT80  40"]
[null,50,null,null,null,null,null,null,null,null,null,null,"LA (X)-80 50"]
[85000,20,null,null,null,null,null,null,null,null,null,null,null,"  STG85   20*","  GCG85   20*"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,"  STG85   25*","  GCG85   25*"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,"STG85   30","GCG85   30",null,null,null,null,null," ","LF85  30",null,null,null,null,"EZ-85-30","SH-85-30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG85   35","GCG85   35"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"STG85   40","GCG85   40",null,null,null,null,null,"TLP85    40","LF85  40"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TLP85    50","LF85  50"]
[90000,30,null,null,null,null,null,null,null,null,null,null,null,"STG90    30","GCG90    30",null,"LTS90-30","ETS90-30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG90    35","GCG90    35",null,"LTS90-35"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"STG90    40","GCG90    40",null,"LTS90-40","ETS90-40"]
[95000,30,null,null,null,null,null,null,null,null,null,null,null,"STG95    30","GCG95    30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG95    35","GCG95    35"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"STG95    40","GCG95    40"]
[96000,20,null,null,null,null,"DX2-20-100"]
[100000,20,"IQ 100 20","ITB 100 20","STS-JZ 100 20","S100 100 20",null,null,null,null,null,"UA (X) 10  20"]
[null,30,null,null,null,null,"DX2-30-100","XTS-30-100","DES-30-100","BH100  30","CTH2-100  30","UA (X) 10  30",null,"STG100  30","GCG100  30","PTS100-30","LTS100-30","ETS100-30","VR100 30","TR100  30","TLP100  30",null,"SLR100  30","ERXL100  30","SR-100  30","PT100  30","EZ-100-30","SH-100-30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"STG100  35","GCG100  35",null,"LTS100-35"]
[null,40,null,null,null,null,"DX2-40-100","XTS-40-100","DES-40-100","BH100  40","CTH2-100  40","UA (X) 10  40",null,"STG100  40","GCG100  40","PTS100-40","LTS100-40","ETS100-40","VR100 40","TR100  40","TLP100  40",null,"SLR100  40","ERXL100  40","SR-100  40","PT100  40","EZ-100-40","SH-100-40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG100  45","GCG100  45"]
[null,50,null,null,null,null,"DX2-50-100","XTS-50-100","DES-50-100",null,null,null,null,"STG100  50","GCG100  50",null,null,null,"VR100 50","TR100  50"," TLP100  50*",null,"SLR100  50",null,"SR-100  50","PT100  50"]
[105000,40,null,null,null,null,null,null,null,null,null,null,null,"STG105  40","GCG105  40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG105  45","GCG105  45"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,"STG105  50","GCG105  50"]
[110000,30,"IQ110   30","ITB 110  30","STS-JZ 110   30","S100 110  30",null,null,null,null,null,null,null,null,null,null,"LTS110-30","ETS110-30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS110-35"]
[null,40,"IQ110   40","ITB 110  40","STS-JZ 110   40","S100 110  40",null,null,null,null,null,null,null,"STG110  40","GCG110  40",null,"LTS110-40","ETS110-40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG110  45","GCG110  45"]
[null,50,"IQ110   50","ITB 110  50","STS-JZ 110   50","S100 110  50",null,null,null,null,null,null,null,"STG110  50","GCG110  50"]
[115000,30,null,null,null,null,null,null,null,"BH115  30"]
[null,40,null,null,null,null,null,null,null,"BH115  40",null,null,null,"STG115  40","GCG115  40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG115  45","GCG115  45"]
[null,50,null,null,null,null,null,null,null,"BH115  50",null,null,null,"STG115  50","GCG115  50"]
[120000,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS120-30","ETS120-30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS120-35"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"STG120  40","GCG120  40",null,"LTS120-40","ETS120-40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG120  45","GCG120  45"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,"STG120  50","GCG120  50"]
[125000,30,null,null,null,null,"DX2-30-125",null,null,null,null,"UA (X) 12  30",null,null,null,"PTS125-30","LTS125-30","ETS125-30","VR125  30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS125-35"]
[null,40,null,null,null,null,"DX2-40-125","XTS-40-125","DES-40-125","BH125  40","CTH2-125  40","UA (X) 12  40",null,"STG125  40","GCG125  40","PTS125-40","LTS125-40","ETS125-40","VR125  40","TR125  40","TLP125  40","HF125  40","SLR125  40","ERXL125  40","SR-125 40","PT125  40","EZ-125-40","SH-125-40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG125  45","GCG125  45",null,"LTS125-45"]
[null,50,null,null,null,null,"DX2-50-125","XTS-50-125","DES-50-125","BH125  50","CTH2-125  50","UA (X) 12  50",null,"STG125  50","GCG125  50","PTS125-50","LTS125-50","ETS125-50","VR125  50","TR125  50","TLP125  50","HF125  50","SLR125  50","ERXL125  50","SR-125  50","PT125  50","EZ-125-50","SH-125-50"]
[null,60,null,null,null,null,"DX2-60-125","XTS-60-125","DES-60-125",null,null,null,null,null,null,null,null,null,"VR125  60",null,"TLP125  60","HF125  60",null,null,null,"PT125  60"]
[130000,30,"IQ130  30","ITB 130  30","STS-JZ 130  30","S100 130  30",null,null,null,null,null,null,null,null,null,null,"LTS130-30","ETS130-30"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS130-35"]
[null,40,"IQ130  40","ITB 130  40","STS-JZ 130  40","S100 130  40",null,null,null,null,null,null,null,"STG130  40","GCG130  40",null,"LTS130-40","ETS130-40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG130  45","GCG130  45",null,"LTS130-45"]
[null,50,"IQ130  50","ITB 130  50","STS-JZ 130  50","S100 130  50",null,null,null,null,null,null,null,"STG130  50","GCG130  50",null,"LTS130-50","ETS130-50"]
[135000,40,null,null,null,null,null,null,null,null,null,null,null,"STG135  40","GCG135  40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG135  45","GCG135  45",null,null,null,null,null,null,null,null,null,null,null,"EZ-135-50","SH-135-50"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,"STG135  50","GCG135  50"]
[140000,40,null,null,null,null,null,null,null,"BH140  40",null,null,null,"STG140  40","GCG140  40",null,"LTS140-40","ETS140-40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG140  45","GCG140  45",null,"LTS140-45"]
[null,50,null,null,null,null,null,null,null,"BH140  50",null,null,null,"STG140  50","GCG140  50",null,"LTS140-50","ETS140-50"]
[null,60,null,null,null,null,null,null,null,"BH140  60"]
[145000,40,null,null,null,null,null,null,null,null,null,null,null,"STG145  40","GCG145  40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG145  45","GCG145  45"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,"STG145  50","GCG145  50"]
[150000,40,null,null,null,null,"DX2-40-150","XTS-40-150","DES-40-150",null,null,"UA (X) 15  40",null,"STG150  40","GCG150  40","PTS150-40","LTS150-40","ETS150-40","VR150  40","TR150  40",null,"HF150  40","SLR150  40",null,"SR-150  40","PT150  40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"STG150  45","GCG150  45",null,"LTS150-45"]
[null,50,null,null,null,null,"DX2-50-150","XTS-50-150","DES-50-150","BH150  50","CTH2-150  50","UA (X) 15  50",null,"STG150  50","GCG150  50","PTS150-50","LTS150-50","ETS150-50","VR150  50","TR150  50","TLP150  50","HF150  50","SLR150  50","ERXL150  50","SR-150  50","PT150  50","EZ-150-50","SH-150-50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG150  55","GCG150  55"]
[null,60,null,null,null,null,"DX2-60-150","XTS-60-150","DES-60-150","BH150  60","CTH2-150  60","UA (X) 15 60",null,"STG150  60","GCG150  60","PTS150-60",null,null,"VR150  60","TR150  60","TLP150  60","HF150  60","SLR150  60","ERXL150  60","SR-150  60","PT150  60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG150  65","GCG150  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG150  70","GCG150  70",null,null,null,null,null,"  TLP150  70*","HF150  70",null,null,null,"PT150  70"]
[155000,40,"IQ155  40","ITB 155  40","STS-JZ 155  40","S100 155  40"]
[null,50,"IQ155  50","ITB 155  50","STS-JZ 155  50","S100 155  50",null,null,null,null,null,null,null,"STG155  50","GCG155  50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG155  55","GCG155  55"]
[null,60,"IQ155  60","ITB 155  60","STS-JZ 155  60","S100 155  60",null,null,null,null,null,null,null,"STG155  60","GCG155  60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG155  65","GCG155  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG155  70","GCG155  70"]
[160000,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS160-40","ETS160-40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS160-45"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,"STG160  50","GCG160  50",null,"LTS160-50","ETS160-50",null,null,null,null,null,null,null,null,"EZ-165-50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG160  55","GCG160  55"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,"STG160  60","GCG160  60",null,null,null,null,null,null,null,null,null,null,null,"EZ-165-60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG160  65","GCG160  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG160  70","GCG160  70"]
[165000,50,null,null,null,null,null,null,null,null,null,null,null,"STG165  50","GCG165  50",null,null,null,null,null,null,null,null,null,null,null,null,"SH165-50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG165  55","GCG165  55"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,"STG165  60","GCG165  60",null,null,null,null,null,null,null,null,null,null,null,null,"SH-165-60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG165  65","GCG165  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG165  70","GCG165  70"]
[170000,50,null,null,null,null,null,null,null,null,null,null,null,"STG170  50","GCG170  50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG170  55","GCG170  55"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,"STG170  60","GCG170  60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG170  65","GCG170  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG170  70","GCG170  70"]
[175000,40,null,null,null,null,"DX2-40-175",null,null,null,null,null,null,null,null,"PTS175-40","LTS175-40","ETS175-40","VR175  40"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS175-45"]
[null,50,"IQ175  50","ITB 175  50","STS-JZ 175  50","S100 175  50","DX2-50-175","XTS-50-175","DES-50-175","BH175  50",null,"UA (X) 17  50",null,"SRG175  50","GCG175  50","PTS175-50","LTS175-50","ETS175-50","VR175  50","TR175  50",null,"HF175  50","SLR175  50","ERXL175  50","SR-175  50","PT175  50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG175  55","GCG175  55"]
[null,60,"IQ175  60","ITB 175  60","STS-JZ 175  60","S100 175  60","DX2-60-175","XTS-60-175","DES-60-175","BH175  60","CTH2-175  60","UA (X) 17  60",null,"STG175  60","GCG175  60","PTS175-60",null,null,"VR175  60","TR175  60",null,"HF175  60","SLR175  60","ERXL175  60","SR-175  60","PT175  60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG175  65","GVG175  65"]
[null,70,"IQ175  70","ITB 175  70","STS-JZ 175  70","S100 175  70","DX2-70-175",null,null,"NH175  70","CTH2-175  70",null,null,"STG175  70","GCG175  70","PTS175-70",null,null,"VR175  70","TR175  70",null,"HF175  70","SLR175  70",null,"SR-175  70","PT175  70"]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT175  80"]
[180000,50,null,null,null,null,null,null,null,null,null,null,null,"STG180  50 ","GCG180  50",null,"LTS180-50","ETS180-50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG180  55 ","GCG180  55"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,"STG180  60 ","GCG180  60",null,"LTS180-60","ETS180-60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG180  65 ","GCG180  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG180  70 ","GCG180  70",null,"LTS180-70","ETS180-70"]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS180-80","ETS180-80"]
[185000,50,null,null,null,null,null,null,null,null,null,null,null,"STG185  50","GCG185  50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG185  55","GCG185  55"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,"STG185  60","GCG185  60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG185  65","GCG185  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG185  70","GCG185  70"]
[190000,50,null,null,null,null,null,null,null,null,null,null,null,"STG190  50","GCG190  50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG190  55","GCG190  55"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,"STG190  60","GCG190  60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG190  65","GCG190  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG190  70","GCG190  70"]
[195000,50,null,null,null,null,null,null,null,null,null,null,null,"STG195  50","GCG195  50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG195  55","GCG195  55"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,"STG195  60","GCG195  60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG196  65","GCG195  65"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,"STG195  70","GCG195  70"]
[200000,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HF200  40"]
[null,50,"IQ200  50","ITB 200  50","STS-JZ 200  50","S100 200  50","DX2-50-200","XTS-50-200","DES-50-200",null,null,null,null,"STG200  50","GCG200  50","PTS200-50","LTS200-50","ETS200-50","VR200  50","TR200  50","TLP200  50","HF200  50",null,null,null,"PT200  50"]
[null,55,null,null,null,null,null,null,null,null,null,null,null,"STG200  55","GCG200  55"]
[null,60,"IQ200  60","ITB 200  60","STS-JZ 200  60","S100 200  60","DX2-60-200","XTS-60-200","DES-60-200","BH200  60",null,null,null,"STG200  60","GCG200  60","PTS200-60","LTS200-60","ETS200-60","VR200  60","TR200  60","TLP200  60","HF200  60","SLR200  60",null,"SR-200-60","PT200  60","EZ-200-60","SH-200-60"]
[null,65,null,null,null,null,null,null,null,null,null,null,null,"STG200  65","GCG200  65"]
[null,70,"IQ200  70","ITB 200  70","STS-JZ 200  70","S100 200  70","DX2-70-200",null,null,"BH200  70",null,null,null,"STG200  70","GCG200  70","PTS200-70","LTS200-70","ETS200-70","VR200  70","TR200  70"," TLP200  70*","HF200  70","SLR200  70",null,"SR-200-70","PT200  70","EZ-200-70","SH-200-70"]
[null,80,null,null,null,null,"DX2-80-200",null,null,"BH200  80",null,null,null,null,null,null,"LTS200-80","ETS200-80",null,null,null,null,"SLR200  80",null,"SR-200-80","PT200  80",null,"SH-200-80"]
[205000,50,null,null,null,null,null,null,null,null,null,"UA (X) 20  50"]
[null,60,null,null,null,null,null,null,null,null,null,"UA (X) 20  60"]
[null,70,null,null,null,null,null,null,null,null,null,"UA (X) 20  70"]
[null,80]
[220000,60,null,null,null,null,null,null,null,null,null,"UA (X) 22  60"]
[null,70,null,null,null,null,null,null,null,null,null,"UA (X) 22  70"]
[225000,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS225-50","ETS225-50"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS225-60","ETS225-60"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS225-70","ETS225-70"]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS225-80","ETS225-80"]
[250000,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS250-50*","ETS250-50*"]
[null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS250-60","ETS250-60"]
[null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTS250-70","ETS250-70"]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ETS250-80"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* unvented use"]

{"sheet":"X-Ref Tubes -\"U\"","index":6,"n_rows":115,"n_cols":18,"rows_kept":115,"cut":false,"hidden":false,"merged":[[1,12,1,13],[4,7,4,9],[4,10,4,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Click here to go to Instructions"]
[]
["TUBES - U COMPARISONS"]
["BTU/hr ","Heater","InfraSave","Schwank","Reznor","Modine","Sterling","Space Ray",null,null,"Solaronics",null,"Detroit Radiant","Roberts Gordon","Enerco","Easy Radiant","Calca na","Ambi-Rad"]
["Input","Length","ITBU Series","S100U Series","TRP Series","NONE","NONE","LTU","ETU","PTU","Suntube IV","GQ Series","NONE","NONE","NONE","EZ-U Series","NONE","NONE"]
[30000,10,null,null,"TRP30"]
[40000,10,"P40U-I","P40U",null,null,null,null,"ETU40-20","PTS/U 40","STU40 15A","GQU40 20A"]
[null,15,null,null,null,null,null,"LTU40-30",null,null,"STU40 20A"]
[null,20,null,null,null,null,null,null,null,null,"STU40 20A"]
[45000,10,null,null,null,null,null,null,null,null,null,"GQU45 20A"]
[null,15,null,null,null,null,null,null,null,null,"STU45 20A"]
[null,20]
[50000,10,null,null,null,null,null,null,"ETU50-20","PTS/U 50",null,"GQU50 20A"]
[null,15,null,null,"TRP50",null,null,"LTU50-30","ETU50-30",null,"STU50 20A"]
[null,20]
[55000,10,null,null,null,null,null,null,null,null,null,"GQU55 20A"]
[null,15,null,null,null,null,null,null,null,null,"STU55 20A"]
[60000,10,"ITBU60 10","S100U 60  10","TRP60",null,null,null,"ETU60-20",null,null,"GQU60 20A/MB*",null,null,null,"EZU-60-10"]
[null,15,null,null,null,null,null,"LTU60-30","ETU60-30",null,"STU60 20A"]
[null,20]
[65000,10,null,null,null,null,null,null,null,null,null," GQU65 20MB*"]
[null,15,null,null,null,null,null,null,null,null,"STU65 20MB*","GQU65 20B"]
[null,20,null,null,null,null,null,null,null,null,"STU65 40B","GQU65 40B"]
[70000,10,null,null,null,null,null,null,null,null,null," GQU70 20MB*"]
[null,15,null,null,null,null,null,null,null,null,"STU70 20MB*","GQU70 20B"]
[null,20,null,null,null,null,null,null,null,null,"STU70 40B","GQU70 40B"]
[75000,10,null,null,null,null,null,null,"ETU75-20","PTS/U 75",null," GQU75  20MB*",null,null,null,"EZU-75-10"]
[null,15,null,null,null,null,null,"LTU75-30","ETU75-30",null,"STU75 20MB*","GQU75 20B"]
[null,20,null,null,null,null,null,null,null,null,"STU75 40B","GQU75 40B"]
[80000,10,"ITBU80 10","S100U 80  10",null,null,null,null,null,null,null," GQU80 20MB*"]
[null,15,"ITBU80 15","S100U 80  15",null,null,null,"LTU80-30","ETU80-30",null,null,"GQU80 20B"]
[null,20,null,null,null,null,null,null,"ETU80-40",null,"STU80 40B","GQU80 40B"]
[85000,10,null,null,null,null,null,null,null,null,null," GQU85 20MB*"]
[null,15,null,null,null,null,null,null,null,null,null,"GQU85 20B",null,null,null,"EZU-85-15"]
[null,20,null,null,null,null,null,null,null,null,"STU80  40B","GQU85 40B"]
[90000,15,null,null,null,null,null,"LTU90-30","ETU90-30",null,null,"GQU90 20B"]
[null,20,null,null,null,null,null,null,"ETU90-40",null,"STU90  40B","GQU90 40B"]
[95000,15,null,null,null,null,null,null,null,null,null,"GQU90 20B"]
[null,20,null,null,null,null,null,null,null,null,"STU95 40B","GQU90 40B"]
[100000,15,null,null,"TRP100",null,null,"LTU100-30","ETU100-30","PTS/U 100",null,"GQU100  20B",null,null,null,"EZ-100-15"]
[null,20,null,null,null,null,null,null,"ETU100-40",null,"STU100 40B","GQU100  40B",null,null,null,"EZ-100-20"]
[null,25,null,null,null,null,null,null,null,null,"STU100 50B","GQU100  50B"]
[105000,20,null,null,null,null,null,null,null,null,"STU105 40B","GQU105  40B"]
[null,25,null,null,null,null,null,null,null,null,"STU105 50B","GQU105  50B"]
[110000,15,"ITBU110 15","S100U 110 15",null,null,null,"LTU110-30","ETU110-30"]
[null,20,"ITBU110  20","S100U 110 20",null,null,null,null,"ETU110-40",null,"STU110 40B","GQU110  20B"]
[null,25,null,null,null,null,null,null,null,null,"STU110 50B","GQU110  50B"]
[115000,20,null,null,null,null,null,null,null,null,"STU115 40B","GQU115  40B"]
[null,25,null,null,null,null,null,null,null,null,"STU115 50B","GQU115  50B"]
[120000,15,null,null,null,null,null,"LTU120-30","ETU120-30"]
[null,20,null,null,null,null,null,null,"ETU120-40",null,"STU120 40B","GQU120  40B"]
[null,25,null,null,null,null,null,null,null,null,"STU120 50B","GQU120  50B"]
[125000,15,null,null,null,null,null,"LTU125-30","ETU125-30","PTS/U 125"]
[null,20,null,null,null,null,null,"LTU125-40","ETU125-40",null,"STU125 40B","GQU125  40B*/C**",null,null,null,"EZ-125-20"]
[null,25,null,null,null,null,null,null,"ETU125-50",null,"STU125 50B","GQU125  50C**"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,"EZ-125-30"]
[130000,15,"ITBU130 15","S100U 130 15",null,null,null,"LTU130-30","ETU130-30"]
[null,20,"ITBU130 20","S100U 130 20",null,null,null,"LTU130-40","ETU130-40",null,"STU130 40C","GQU130  40C"]
[null,25,null,null,null,null,null,null,"ETU130-50",null,null,"GQU130  50C"]
[135000,20,null,null,null,null,null,null,null,null,"STU135 40C","GQU135  40C"]
[null,25,null,null,null,null,null,null,null,null,null,"GQU135  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU135 40C",null,null,null,null,"EZ-135-30"]
[null,35,null,null,null,null,null,null,null,null,"STU135 45C"]
[140000,20,null,null,null,null,null,"LTU140-40","ETU140-40",null,"STU140 40C","GQU140  40C"]
[null,25,null,null,null,null,null,null,"ETU140-50",null,null,"GQU140  50C"]
[145000,20,null,null,null,null,null,null,null,null,"STU145 40C","GQU145  40C"]
[null,25,null,null,null,null,null,null,null,null,null,"GQU145  50C"]
[150000,20,null,null,null,null,null,"LTU150-40","ETU150-40","PTS/U 150","STU150 40C","GQU150  40C"]
[null,25,null,null,null,null,null,null,"ETU150-50",null,"STU150 50C","GQU150  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU150 60C","GQU150  60C",null,null,null,"EZ-150-30"]
[null,35,null,null,null,null,null,null,null,null,"STU150 70C","GQU150  70C"]
[155000,20,"ITBU155 20","S100U 155 20"]
[null,25,null,null,null,null,null,null,null,null,"STU155 50C","GQU155  50C"]
[null,30,"ITBU155 30","S100U 155 30",null,null,null,null,null,null,"STU155 60C","GQU155  60C"]
[null,35,null,null,null,null,null,null,null,null,"STU155 70C","GQU155  70C"]
[160000,20,null,null,null,null,null,"LTU160-40","ETU160-40"]
[null,25,null,null,null,null,null,null,"ETU160-50",null,"STU160 50C","GQU160  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU160 60C","GQU160  60C"]
[null,35,null,null,null,null,null,null,null,null,"STU160 70C","GQU160  70C"]
[165000,25,null,null,null,null,null,null,null,null,"STU165 50C","GQU165  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU165 60C","GQU165  60C",null,null,null,"EZ-165-30"]
[null,35,null,null,null,null,null,null,null,null,"STU165 70C","GQU165  70C"]
[170000,25,null,null,null,null,null,null,null,null,"STU170 50C","GQU170  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU170 60C","GQU170  60C"]
[null,35,null,null,null,null,null,null,null,null,"STU170 70C","GQU170  70C"]
[175000,20,null,null,null,null,null,"LTU175-40","ETU175-40","PTS/U 175"]
[null,25,null,null,null,null,null,null,"ETU175-50",null,"STU175 50C","GQU175  50C"]
[null,30,"ITBU175 30","S100U 175 30",null,null,null,null,null,null,"STU175 60C","GQU175  60C"]
[null,35,null,null,null,null,null,null,null,null,"STU175 70C","GQU175  70C"]
[180000,25,null,null,null,null,null,"LTU180-50","ETU180-50",null,"STU180 50C","GQU180  50C"]
[null,30,null,null,null,null,null,null,"ETU180-60",null,"STU180 60C","GQU180  60C"]
[null,35,null,null,null,null,null,null,"ETU180-70",null,"STU180 70C","GQU180  70C"]
[null,40,null,null,null,null,null,null,"ETU180-80"]
[185000,25,null,null,null,null,null,null,null,null,"STU185 50C","GQU185  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU185 60C","GQU185  60C"]
[null,35,null,null,null,null,null,null,null,null,"STU185 70C","GQU185  70C"]
[190000,25,null,null,null,null,null,null,null,null,"STU190 50C","GQU190  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU190 60C","GQU190  60C"]
[null,35,null,null,null,null,null,null,null,null,"STU190 70C","GQU190  70C"]
[195000,25,null,null,null,null,null,null,null,null,"STU195 50C","GQU195  50C"]
[null,30,null,null,null,null,null,null,null,null,"STU195 60C","GQU195  60C"]
[null,35,null,null,null,null,null,null,null,null,"STU195 70C","GQU195  70C"]
[200000,25,null,null,null,null,null,"LTU200-50","ETU200-50","PTS/U 200","STU200 50C","GQU200  50C"]
[null,30,"ITBU200 30","S100U 200 30",null,null,null,null,"ETU200-60",null,"STU200 60C","GQU200  60C",null,null,null,"EZ-200-30"]
[null,35,null,null,null,null,null,null,"ETU200-70",null,"STU200 70C","GQU200  70C"]
[null,40,null,null,null,null,null,null,"ETU200-80",null,null,null,null,null,null,"EZ-200-40"]
[225000,25,null,null,null,null,null,"LTU225-50","ETU225-50"]
[null,30,null,null,null,null,null,null,"ETU225-60"]
[null,35,null,null,null,null,null,null,"ETU225-70"]
[null,40,null,null,null,null,null,null,"ETU225-80"]
[250000,25,null,null,null,null,null,"LTU250-50","ETU250-50"]
[null,30,null,null,null,null,null,null,"ETU250-60"]
[null,35,null,null,null,null,null,null,"ETU250-70"]
[null,40,null,null,null,null,null,null,"ETU250-80"]

{"sheet":"X-Ref High Intensity","index":7,"n_rows":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,8,4,9],[3,2,3,4],[1,10,1,11],[3,8,3,9],[3,13,3,14]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Click here to go to Instructions"]
["HIGH INTENSITY COMPARISONS"]
[null,null,"InfraSave",null,null,"Schwank","Solaronics","Detroit Radiant","Space-Ray",null,"Superior Radiant","Roberts Gordon","Reznor","Modine",null,"Sterling","Enerco","Easy Radiant","Sun Technology"]
["KW","BTU ","Standard Model","81% Radiant ","67% Radiant","Standard Model",null,"(Re-Verber-Ray)","     Gas Fired Products",null,null,"Gordon Glow",null,null,null,null,null,null,"Ray-Tech"]
["INPUT","INPUT","IL Series","supraSchwank (1)","primoSchwank (1)","ecoSchwank","K Series","DR Series","RSCA Series","DK Series","HD Series","GG Series","RIH Series","MT Series","GR Series","SHR Series","EnerRadiant","RA Series","RT Series"]
[{"$f":"B7/3413","v":6.2994433050102545},21500,null,null,null,"ecoSchwank 6"]
[7.3249340755933199,25000,null,null,null,null,null,null,null,null,null,"DISCONTINUED",null,null,null,null,null,null,"RT25"]
[7.6179314386170525,26000,null,null,null,null,null,null," RSCA3"]
[8.0574274831526509,27500,null,null,null,null,null,null,null,null,null,null,null,"MT 28",null,null,null,null," RT28"]
[8.6434222092001178,29500,null,"supraSchwank10"]
[8.7899208907119828,30000,null,null,null,null,"   K-30 *","DR 30 / DR 30 (S)",null,"DK30 *","HD3","GG-30","RIHN 30*","MT 30",null,null,4030,null," RT30"]
[9.6689129797831814,33000,null,null,null,null,null,null,null,"  DK33 **",null,null,null,null,null,null,null,"RA-30"]
[9.8154116612950482,33500,null,null,null,null,null,null,null,null,null,null,null,"MT 33",null,null,null,null," RT33"]
[10.254907705830648,35000,"IL 37",null,null,"ecoSchwank 10","   K-35 *",null,null,"DK35 *",null,null,null,null,null,"SHR35",null,"RA-35"]
[10.98740111338998,37500,null,null,"primoSchwank 10"]
[11.133899794901845,38000,null,null,null,null,null,null,null,null,null,null,null,null,"GR-38"]
[11.719894520949312,40000,null,null,null,null,"   K-40 *",null,null,"DK40*",null,null,null,null,null,null,4040,"RA-40"]
[12.891883973044242,44000,null,"supraSchwank15"]
[13.184881336067976,45000,null,null,null,null,"   K-45 *","DR 45"]
[14.64986815118664,50000,"IL 50",null,null,"ecoSchwank 13","K-50","DR 50",null,null,null,null,"RIHL50**",null,"GR-50","SHR50",8050,"RA-50","        RT50   "]
[15.235862877234105,52000,null,null,null,null,null,null," RSCA6"]
[16.114854966305302,55000,null,null,null,null,"  K-55 *","DR 55",null,null,null,null,null,"MT 55",null,null,null,null," RT56"]
[16.407852329329035,56000,null,null,"primoSchwank 15"]
[17.286844418400236,59000,null,"supraSchwank20"]
[17.579841781423966,60000,null,null,null,null,"   K-60 *","DR 60",null,"DK60*","HD6","GG-60","RIHN 60*","MT 60",null,null,8060,"RA-60"," RT60"]
[19.337825959566363,66000,null,null,null,null,null,null,null,"   DK66 **"]
[19.630823322590096,67000,null,null,null,null,null,null,null,null,null,null,null,"MT 66",null,null,null,null,"    RT66* "]
[20.509815411661297,70000,null,null,null,null," K-70",null,null,null,null,null,null,null,null,null,8070,"RA-70"]
[20.949311456196895,71500,"IL 75",null,null,"ecoSchwank 18"]
[21.974802226779961,75000,null,null,"primoSchwank 20",null," K-75","DR 75",null,null,null,null,null,null,"GR-75","SHR75",null,null,"  RT75"]
[23.439789041898624,80000,null,null,null,null,"  K-80 ","DR 80",null,null,null,null,null,null,null,null,9080,"RA-80"]
[24.172282449457956,82500,null,null,null,null,null,null,null,null,null,null,null,"MT 84",null,null,null,null," RT84"]
[24.904775857017288,85000,null,null,null,null,"  K-85","DR 85"]
[25.93026662760035,88500,null,"supraSchwank30"]
[26.369762672135952,90000,null,null,null,null,"  K-90","DR 90",null,null,"HD9","GG-90","RIHVL 90**","MT 90",null,null,9090,"RA-90"," RT90"]
[27.834749487254616,95000,null,null,null,null,"     K-95 *","   DR 95 *"]
[29.006738939349546,99000,null,null,null,null,null,null,null,"  DK100 **"]
[29.29973630237328,100000,"IL 100",null,null,"ecoSchwank 26","       K-100 *","  DR 100 *",null,"DK100 *",null,"GG-100","RIHVN 100*",null,"GR-100","SHR100","9100/9100SS","RA-100"]
[29.446234983885144,100500,null,null,null,null,null,null,null,null,null,null,null,"MT 99",null,null,null,null,"    RT99*   "]
[30.47172575446821,104000,null,null,null,null,null,null," RSCA10"]
[30.764723117491943,105000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RA-105"]
[32.229709932610604,110000,null,null,null,null,"       K-110 *",null,null,null,null,null,null,"MT 112",null,null,null,null," RT112"]
[33.108702021681808,113000,null,null,"primoSchwank 30"]
[34.573688836800471,118000,null,"supraSchwank40"]
[35.159683562847931,120000,null,null,null,null,"    K-120","   DR 130 **",null,"DK120 *","HD12","GG-120","RIHVL 120**","MT 120",null,null,9120,"RA-120"," RT120"]
[36.624670377966595,125000]
[38.089657193085259,130000,null,null,null,null,"       K-130 *"," DR 130 *",null,null,null,"GG-130"]
[38.675651919132726,132000,null,null,null,null,null,null,null,"  DK132 **"]
[39.261646645180193,134000,null,null,null,null,null,null,null,null,null,null,null,"   MT 132 *",null,null,null,null,"    RT132*  "]
[39.55464400820393,135000,null,null,null,null,"       K-135 *",null,null,null,null,null,null,null,null,null,null,"RA-135"]
[41.019630823322593,140000,null,null,null,null,null,null,null,"DK140 *",null,null,null,null,null,null,"9140*"]
[42.484617638441257,145000,null,null,null,null,null,"   DR 160 **"]
[43.949604453559921,150000,"IL 150",null,"primoSchwank 40","ecoSchwank 36","       K-150 *",null,null,null,null,null,"RIHVN 150*",null,null,"SHR150",null,"RA-150"]
[46.879578083797249,160000,null,null,null,null,"    K-160"," DR 160 * ",null,"DK160 *",null,"GG-160","RIHVN 160*","MT 160"]
[51.27453852915324,175000,null,null,null,null,"      K-175 *"]
[52.739525344271904,180000]
[58.599472604746559,200000,"IL 200",null,null,"ecoSchwank 52","      K-200 *",null,null,null,null,null,"RIHVN 200 *",null,null,"SHR200"]

{"sheet":"1","index":8,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["BURNER KITS"]
[null,null,null,null,"NG -> LP"]
[null,"QTY","PART #","Description","Conv. Kit"]
["P40U-I",1,{"$f":"\"PU-I040-\"&IF('Tube Htr Kits'!J5=\"USA\",\"AN\",\"CN\")","v":"PU-I040-AN"},"P40U-I Factory Assembled Heater 10' x 40,000 Btuh NG ","JS-0555XA","Type 1 Hose Connector 1/2\" x 36\" INCLUDED with heater","Flexible Gas Connector 1/2\" x 24\" INCLUDED with heater"]
["IQ-45",1,{"$f":"\"JJ-S045\"&IF('1. Project Details'!$C$6=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S045-AN"},"IQ BURNER KIT 45,000 Btuh NG","JS-0556-XC","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IQ-60",1,{"$f":"\"JJ-S060\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S060-AN"},"IQ BURNER KIT 60,000 Btuh NG","JS-0557-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IQ-80",1,{"$f":"\"JJ-S080\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S080-AN"},"IQ BURNER KIT 80,000 Btuh NG","JS-0559-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IQ-100",1,{"$f":"\"JJ-S100\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S100-AN"},"IQ BURNER KIT 100,000 Btuh NG","JS-0561-XA","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IQ-110",1,{"$f":"\"JJ-S110\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S110-AN"},"IQ BURNER KIT 110,000 Btuh NG","JS-0561-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IQ-130",1,{"$f":"\"JJ-S130\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S130-AN"},"IQ BURNER KIT 130,000 Btuh NG","JS-0563-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IQ-155",1,{"$f":"\"JJ-S155\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S155-AN"},"IQ BURNER KIT 155,000 Btuh NG","JS-0565-XX","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["IQ-175",1,{"$f":"\"JJ-S175\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S175-AN"},"IQ BURNER KIT 175,000 Btuh NG","JS-0567-AA","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["IQ-200",1,{"$f":"\"JJ-S200\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-AN\",\"-CN\")","v":"JJ-S200-AN"},"IQ BURNER KIT 200,000 Btuh NG","JS-0567-CC","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["P40R",1,"PU-R040-BN","P40R Factory Assembled Workshop Heater 10' x 40,000 Btuh NG ","JS-0555XA","Can be connected directly to gas supply piping; Check Local Codes & Requirements","Can be connected directly to gas supply piping; Check Local Codes & Requirements"]
["ITB-45",1,{"$f":"\"JJ-E045\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E045-BN"},"ITB BURNER KIT  45,000 Btuh NG","JS-0556-XE","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITB-60",1,{"$f":"\"JJ-E060\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E060-BN"},"ITB BURNER KIT  60,000 Btuh NG","JS-0557-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITB-80",1,{"$f":"\"JJ-E080\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E080-BN"},"ITB BURNER KIT  80,000 Btuh NG","JS-0559-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITB-100",1,{"$f":"\"JJ-E100\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E100-BN"},"ITB BURNER KIT 100,000 Btuh NG","JS-0561-XA","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITB-110",1,{"$f":"\"JJ-E110\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E110-BN"},"ITB BURNER KIT 110,000 Btuh NG","JS-0561-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITB-130",1,{"$f":"\"JJ-E130\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E130-BN"},"ITB BURNER KIT 130,000 Btuh NG","JS-0563-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITB-155",1,{"$f":"\"JJ-E155\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E155-BN"},"ITB BURNER KIT 155,000 Btuh NG","JS-0565-XX","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITB-175",1,{"$f":"\"JJ-E175\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E175-BN"},"ITB BURNER KIT 175,000 Btuh NG","JS-0567-AA","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITB-200",1,{"$f":"\"JJ-E200\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E200-BN"},"ITB BURNER KIT 200,000 Btuh NG","JS-0567-CC","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITBU-60",1,{"$f":"\"JJ-E060\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E060-BN"},"ITB BURNER KIT  60,000 Btuh NG","JS-0557-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITBU-80",1,{"$f":"\"JJ-E080\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E080-BN"},"ITB BURNER KIT  80,000 Btuh NG","JS-0559-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITBU-100",1,{"$f":"\"JJ-E100\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E100-BN"},"ITB BURNER KIT 100,000 Btuh NG","JS-0561-XA","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITBU-110",1,{"$f":"\"JJ-E110\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E110-BN"},"ITB BURNER KIT 110,000 Btuh NG","JS-0561-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITBU-130",1,{"$f":"\"JJ-E130\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E130-BN"},"ITB BURNER KIT 130,000 Btuh NG","JS-0563-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITBU-155",1,{"$f":"\"JJ-E155\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E155-BN"},"ITB BURNER KIT 155,000 Btuh NG","JS-0565-XX","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITBU-175",1,{"$f":"\"JJ-E175\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E175-BN"},"ITB BURNER KIT 175,000 Btuh NG","JS-0567-AA","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITBU-200",1,{"$f":"\"JJ-E200\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-E200-BN"},"ITB BURNER KIT 200,000 Btuh NG","JS-0567-CC","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["P40U-IW",1,{"$f":"\"PU-IW40-\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"AN\",\"CN\")","v":"PU-IW40-AN"},"P40U-IW Factory Assembled Car Wash Heater 10' x 40,000 Btuh NG ","JS-0555XA","Type 1 Hose Connector 1/2\" x 36\" INCLUDED with heater","Flexible Gas Connector 1/2\" x 24\" INCLUDED with heater"]
["IW-45",1,{"$f":"\"JJ-P045\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P045-BN"},"IW BURNER KIT 45,000 Btuh NG","JS-0556-XC","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IW-60",1,{"$f":"\"JJ-P060\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P060-BN"},"IW BURNER KIT 60,000 Btuh NG","JS-0557-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IW-80",1,{"$f":"\"JJ-P080\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P080-BN"},"IW BURNER KIT 80,000 Btuh NG","JS-0559-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IW-110",1,{"$f":"\"JJ-P110\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P110-BN"},"IW BURNER KIT 110,000 Btuh NG","JS-0561-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IW-130",1,{"$f":"\"JJ-P130\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P130-BN"},"IW BURNER KIT 130,000 Btuh NG","JS-0563-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IW-155",1,{"$f":"\"JJ-P155\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P155-BN"},"IW BURNER KIT 155,000 Btuh NG","JS-0565-XX","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["IW-175",1,{"$f":"\"JJ-P175\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P175-BN"},"IW BURNER KIT 175,000 Btuh NG","JS-0567-AA","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["IW-200",1,{"$f":"\"JJ-P200\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-P200-BN"},"IW BURNER KIT 200,000 Btuh NG","JS-0567-CC","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["P40U-IP",1,{"$f":"\"PU-IP40-\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"AN\",\"CN\")","v":"PU-IP40-AN"},"P40U-IP Factory Assembled Outdoor Heater 10' x 40,000 Btuh NG ","JS-0555XA","Type 1 Hose Connector 1/2\" x 36\" INCLUDED with heater","Flexible Gas Connector 1/2\" x 24\" INCLUDED with heater"]
["IWP-45",1,{"$f":"\"JJ-045W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-045W-BN"},"IWP BURNER KIT 45,000 Btuh NG","JS-0556-XC","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IWP-60",1,{"$f":"\"JJ-060W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-060W-BN"},"IWP BURNER KIT 60,000 Btuh NG","JS-0557-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IWP-80",1,{"$f":"\"JJ-080W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-080W-BN"},"IWP BURNER KIT 80,000 Btuh NG","JS-0559-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IWP-110",1,{"$f":"\"JJ-110W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-110W-BN"},"IWP BURNER KIT 110,000 Btuh NG","JS-0561-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IWP-130",1,{"$f":"\"JJ-130W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-130W-BN"},"IWP BURNER KIT 130,000 Btuh NG","JS-0563-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["IWP-155",1,{"$f":"\"JJ-155W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-155W-BN"},"IWP BURNER KIT 155,000 Btuh NG","JS-0565-XX","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["IWP-175",1,{"$f":"\"JJ-175W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-175W-BN"},"IWP BURNER KIT 175,000 Btuh NG","JS-0567-AA","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["IWP-200",1,{"$f":"\"JJ-200W\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-200W-BN"},"IWP BURNER KIT 200,000 Btuh NG","JS-0567-CC","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITT-80/60",1,{"$f":"\"JJ-080T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-080T-BN"},"ITT- BURNER KIT 80/60 TWO STAGE NG","JS-0559-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITT-110/75",1,{"$f":"\"JJ-110T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-110T-BN"},"ITT- BURNER KIT 110/75 TWO STAGE NG","JS-0561-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITT-130/90",1,{"$f":"\"JJ-130T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-130T-BN"},"ITT- BURNER KIT 130/90 TWO STAGE NG","JS-0563-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITT-155/110",1,{"$f":"\"JJ-155T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-155T-BN"},"ITT-BURNER KIT 155/110 TWO STAGE NG","JS-0565-XX","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITT-175/125",1,{"$f":"\"JJ-175T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-175T-BN"},"ITT-BURNER KIT 175/120 TWO STAGE NG","NG ONLY","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITT-200/140",1,{"$f":"\"JJ-200T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-200T-BN"},"ITT-BURNER KIT 200/140 TWO STAGE NG","NG ONLY","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITTU-80/60",1,{"$f":"\"JJ-080T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-080T-BN"},"ITT- BURNER KIT 80/60 TWO STAGE NG","JS-0559-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITTU-110/75",1,{"$f":"\"JJ-110T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-110T-BN"},"ITT- BURNER KIT 110/75 TWO STAGE NG","JS-0561-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITTU-130/90",1,{"$f":"\"JJ-130T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-130T-BN"},"ITT- BURNER KIT 130/90 TWO STAGE NG","JS-0563-XX","Type 1 Hose Connector 1/2\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 1/2\" x 24\" INCLUDED in Burner Kit"]
["ITTU-155/110",1,{"$f":"\"JJ-155T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-155T-BN"},"ITT-BURNER KIT 155/110 TWO STAGE NG","JS-0565-XX","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITTU-175/125",1,{"$f":"\"JJ-175T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-175T-BN"},"ITT-BURNER KIT 175/120 TWO STAGE NG","NG ONLY","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]
["ITTU-200/140",1,{"$f":"\"JJ-200T\"&IF('Tube Htr Kits'!$J$5=\"USA\",\"-BN\",\"-CN\")","v":"JJ-200T-BN"},"ITT-BURNER KIT 200/140 TWO STAGE NG","NG ONLY","Type 1 Hose Connector 3/4\" x 36\" INCLUDED in Burner Kit","Flexible Gas Connector 3/4\" x 36\" INCLUDED in Burner Kit"]

{"sheet":"2","index":9,"n_rows":123,"n_cols":7,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
["IQ-45-10",1,"TS-4510-JZ","IQ 10' TUBE KIT 45,000 BTU ONLY"]
["IQ-45-20",1,"TS-1420-JZ","IQ 20' TUBE KIT STAND ALONE"]
["IQ-60-20",1,"TS-1420-JZ","IQ 20' TUBE KIT STAND ALONE"]
["IQ-60-30",1,"TS-1430-JZ","IQ 30' TUBE KIT STAND ALONE"]
["IQ-80-20",1,"TS-1420-JZ","IQ 20' TUBE KIT STAND ALONE"]
["IQ-80-30",1,"TS-1430-JZ","IQ 30' TUBE KIT STAND ALONE"]
["IQ-80-40",1,"TS-1040-JZ","IQ 40' TUBE KIT STAND ALONE"]
["IQ-100-20",1,"TS-1020-JZ","IQ TUBE KIT 20' STAND ALONE 100MBH"]
["IQ-110-30",1,"TS-1430-JZ","IQ 30' TUBE KIT STAND ALONE"]
["IQ-110-40",1,"TS-1040-JZ","IQ 40' TUBE KIT STAND ALONE"]
["IQ-110-50",1,"TS-F030-JZ","IQ TUBE KIT 30' PRIMARY 110-155",1,"TS-0020-JZ","IQ - TUBE KIT SECONDARY  20'"]
["IQ-130-30",1,"TS-1430-JZ","IQ 30' TUBE KIT STAND ALONE"]
["IQ-130-40",1,"TS-1040-JZ","IQ 40' TUBE KIT STAND ALONE"]
["IQ-130-50",1,"TS-F030-JZ","IQ TUBE KIT 30' PRIMARY 110-155",1,"TS-0020-JZ","IQ TUBE KIT SECONDARY  20'"]
["IQ-155-40",1,"TS-1040-JZ","IQ 40' TUBE KIT STAND ALONE"]
["IQ-155-50",1,"TS-F030-JZ","IQ TUBE KIT 30' PRIMARY 110-155",1,"TS-0020-JZ","IQ TUBE KIT SECONDARY  20'"]
["IQ-155-60",1,"TS-F030-JZ","IQ TUBE KIT 30' PRIMARY 110-155",1,"TS-0030-JZ","IQ TUBE KIT SECONDARY  30'"]
["IQ-175-50",1,"TS-1030-JZ","IQ TUBE KIT 30' PRIMARY 175/200",1,"TS-0020-JZ","IQ TUBE KIT SECONDARY  20'"]
["IQ-175-60",1,"TS-1030-JZ","IQ TUBE KIT 30' PRIMARY 175/200",1,"TS-0030-JZ","IQ TUBE KIT SECONDARY  30'"]
["IQ-175-70",1,"TS-1030-JZ","IQ TUBE KIT 30' PRIMARY 175/200",1,"TS-0040-JZ","IQ TUBE KIT SECONDARY  40'"]
["IQ-200-50",1,"TS-1030-JZ","IQ TUBE KIT 30' PRIMARY 175/200",1,"TS-0020-JZ","IQ TUBE KIT SECONDARY  20'"]
["IQ-200-60",1,"TS-1030-JZ","IQ TUBE KIT 30' PRIMARY 175/200",1,"TS-0030-JZ","IQ TUBE KIT SECONDARY  30'"]
["IQ-200-70",1,"TS-1030-JZ","IQ TUBE KIT 30' PRIMARY 175/200",1,"TS-0040-JZ","IQ TUBE KIT SECONDARY  40'"]
["ITB-45-10",1,"TM-4510-SX","ITB TUBE KIT 10'  STAND ALONE 45,000"]
["ITB-45-20",1,"TM-1420-SX","ITB TUBE KIT 20'  STAND ALONE"]
["ITB-60-20",1,"TM-1420-SX","ITB TUBE KIT 20'  STAND ALONE"]
["ITB-60-30",1,"TM-1430-SX","ITB TUBE KIT 30'  STAND ALONE"]
["ITB-80-20",1,"TM-1420-SX","ITB TUBE KIT 20'  STAND ALONE"]
["ITB-80-30",1,"TM-1430-SX","ITB TUBE KIT 30'  STAND ALONE"]
["ITB-80-40",1,"TM-1040-SX","ITB  TUBE KIT 40' STAND ALONE"]
["ITB-100-20",1,"TM-1020-SX","ITB TUBE KIT 20'x100Mbh STAND ALONE"]
["ITB-110-30",1,"TM-1430-SX","ITB TUBE KIT 30'  STAND ALONE"]
["ITB-110-40",1,"TM-1040-SX","ITB  TUBE KIT 40' STAND ALONE"]
["ITB-110-50",1,"TM-F030-SX","ITB TUBE KIT 30' PRIMARY 80->155",1,"TM-0020-SX","ITB TUBE KIT 20' SECONDARY"]
["ITB-130-30",1,"TM-1430-SX","ITB TUBE KIT 30'  STAND ALONE"]
["ITB-130-40",1,"TM-1040-SX","ITB  TUBE KIT 40' STAND ALONE"]
["ITB-130-50",1,"TM-F030-SX","ITB TUBE KIT 30' PRIMARY 80->155",1,"TM-0020-SX","ITB TUBE KIT 20' SECONDARY"]
["ITB-155-40",1,"TM-1040-SX","ITB  TUBE KIT 40' STAND ALONE"]
["ITB-155-50",1,"TM-F030-SX","ITB TUBE KIT 30' PRIMARY 80->155",1,"TM-0020-SX","ITB TUBE KIT 20' SECONDARY"]
["ITB-155-60",1,"TM-F030-SX","ITB TUBE KIT 30' PRIMARY 80->155",1,"TM-0030-SX","ITB TUBE KIT 30' SECONDARY"]
["ITB-175-50",1,"TM-1030-SX","ITB  TUBE KIT 30' PRIMARY 175->200",1,"TM-0020-SX","ITB TUBE KIT 20' SECONDARY"]
["ITB-175-60",1,"TM-1030-SX","ITB  TUBE KIT 30' PRIMARY 175->200",1,"TM-0030-SX","ITB TUBE KIT 30' SECONDARY"]
["ITB-175-70",1,"TM-1030-SX","ITB  TUBE KIT 30' PRIMARY 175->200",1,"TM-0040-SX","ITB TUBE KIT 40' SECONDARY"]
["ITB-200-50",1,"TM-1030-SX","ITB  TUBE KIT 30' PRIMARY 175->200",1,"TM-0020-SX","ITB TUBE KIT 20' SECONDARY"]
["ITB-200-60",1,"TM-1030-SX","ITB  TUBE KIT 30' PRIMARY 175->200",1,"TM-0030-SX","ITB TUBE KIT 30' SECONDARY"]
["ITB-200-70",1,"TM-1030-SX","ITB  TUBE KIT 30' PRIMARY 175->200",1,"TM-0040-SX","ITB TUBE KIT 40' SECONDARY"]
["ITBU-60-10",1,"TM-1410-SU","ITBU TUBE KIT 10'U STAND ALONE"]
["ITBU-80-10",1,"TM-1410-SU","ITBU TUBE KIT 10'U STAND ALONE"]
["ITBU-80-15",1,"TM-1415-SU","ITBU TUBE KIT 15'U STAND ALONE"]
["ITBU-110-15",1,"TM-1415-SU","ITBU TUBE KIT 15'U STAND ALONE"]
["ITBU-110-20",1,"TM-1020-SU","ITBU TUBE KIT 20'U STAND ALONE"]
["ITBU-130-15",1,"TM-1415-SU","ITBU TUBE KIT 15'U STAND ALONE"]
["ITBU-130-20",1,"TM-1020-SU","ITBU TUBE KIT 20'U STAND ALONE"]
["ITBU-155-20",1,"TM-1020-SU","ITBU TUBE KIT 20'U STAND ALONE"]
["ITBU-155-30",1,"TM-0020-SU","ITBU TUBE KIT 20'U PRIMARY 155",1,"TM-0010-SU","S100U & ITBU TUBE KIT 10' SECONDARY"]
["ITBU-175-30",1,"TM-A120-SU","ITBU TUBE KIT 20'U PRIMARY 175-200",1,"TM-0010-SU","S100U & ITBU TUBE KIT 10' SECONDARY"]
["ITBU-200-30",1,"TM-A120-SU","ITBU TUBE KIT 20'U PRIMARY 175-201",1,"TM-0010-SU","S100U & ITBU TUBE KIT 10' SECONDARY"]
["IW-45-10",1,"TS-4510-JZ","IW 10' TUBE KIT 45,000 BTUH STAND ALONE"]
["IW-45-20",1,"TW-1420-JZ","IW 20' TUBE KIT STAND ALONE"]
["IW-60-20",1,"TW-1420-JZ","IW 20' TUBE KIT STAND ALONE"]
["IW-60-30",1,"TW-1430-JZ","IW 30' TUBE KIT STAND ALONE"]
["IW-80-20",1,"TW-1420-JZ","IW 20' TUBE KIT STAND ALONE"]
["IW-80-30",1,"TW-1430-JZ","IW 30' TUBE KIT STAND ALONE"]
["IW-80-40",1,"TW-1040-JZ","IW 40' TUBE KIT STAND ALONE"]
["IW-110-30",1,"TW-1430-JZ","IW 30' TUBE KIT STAND ALONE"]
["IW-110-40",1,"TW-1040-JZ","IW 40' TUBE KIT STAND ALONE"]
["IW-110-50",1,"TW-F030-JZ","IW TUBE KIT 30 PRIMARY 110-155",1,"TW-0020-JZ","IW TUBE KIT SECONDARY  20'"]
["IW-130-30",1,"TW-1430-JZ","IW 30' TUBE KIT STAND ALONE"]
["IW-130-40",1,"TW-1040-JZ","IW 40' TUBE KIT STAND ALONE"]
["IW-130-50",1,"TW-F030-JZ","IW TUBE KIT 30 PRIMARY 110-155",1,"TW-0020-JZ","IW TUBE KIT SECONDARY  20'"]
["IW-155-40",1,"TW-1040-JZ","IW 40' TUBE KIT STAND ALONE"]
["IW-155-50",1,"TW-F030-JZ","IW TUBE KIT 30 PRIMARY 110-155",1,"TW-0020-JZ","IW TUBE KIT SECONDARY  20'"]
["IW-155-60",1,"TW-F030-JZ","IW TUBE KIT 30 PRIMARY 110-156",1,"TW-0030-JZ","IW TUBE KIT SECONDARY  30'"]
["IW-175-50",1,"TW-1030-JZ","IW TUBE KIT 30 PRIMARY 175-200",1,"TW-0020-JZ","IW TUBE KIT SECONDARY  20'"]
["IW-175-60",1,"TW-1030-JZ","IW TUBE KIT 30 PRIMARY 175-200",1,"TW-0030-JZ","IW TUBE KIT SECONDARY  30'"]
["IW-175-70",1,"TW-1030-JZ","IW TUBE KIT 30 PRIMARY 175-200",1,"TW-0040-JZ","IW TUBE KIT SECONDARY  40'"]
["IW-200-50",1,"TW-1030-JZ","IW TUBE KIT 30 PRIMARY 175-200",1,"TW-0020-JZ","IW TUBE KIT SECONDARY  20'"]
["IW-200-60",1,"TW-1030-JZ","IW TUBE KIT 30 PRIMARY 175-200",1,"TW-0030-JZ","IW TUBE KIT SECONDARY  30'"]
["IW-200-70",1,"TW-1030-JZ","IW TUBE KIT 30 PRIMARY 175-200",2,"TW-0020-JZ","IW TUBE KIT SECONDARY  20'"]
["IWP-45-10",1,"TS-4510-JZ","IWP 10' TUBE KIT 45,000 BTUH STAND ALONE"]
["IWP-45-20",1,"TW-1420-JZ","IWP 20' TUBE KIT STAND ALONE"]
["IWP-60-20",1,"TW-1420-JZ","IWP 20' TUBE KIT STAND ALONE"]
["IWP-60-30",1,"TW-1430-JZ","IWP 30' TUBE KIT STAND ALONE"]
["IWP-80-20",1,"TW-1420-JZ","IWP 20' TUBE KIT STAND ALONE"]
["IWP-80-30",1,"TW-1430-JZ","IWP 30' TUBE KIT STAND ALONE"]
["IWP-80-40",1,"TW-1040-JZ","IWP 40' TUBE KIT STAND ALONE"]
["IWP-110-30",1,"TW-1430-JZ","IWP 30' TUBE KIT STAND ALONE"]
["IWP-110-40",1,"TW-1040-JZ","IWP 40' TUBE KIT STAND ALONE"]
["IWP-110-50",1,"TW-F030-JZ","IWP TUBE KIT 30 PRIMARY 110-155",1,"TW-0020-JZ","IWP TUBE KIT SECONDARY  20'"]
["IWP-130-30",1,"TW-1430-JZ","IWP 30' TUBE KIT STAND ALONE"]
["IWP-130-40",1,"TW-1040-JZ","IWP 40' TUBE KIT STAND ALONE"]
["IWP-130-50",1,"TW-F030-JZ","IWP TUBE KIT 30 PRIMARY 110-155",1,"TW-0020-JZ","IWP TUBE KIT SECONDARY  20'"]
["IWP-155-40",1,"TW-1040-JZ","IWP 40' TUBE KIT STAND ALONE"]
["IWP-155-50",1,"TW-F030-JZ","IWP TUBE KIT 30 PRIMARY 110-155",1,"TW-0020-JZ","IWP TUBE KIT SECONDARY  20'"]
["IWP-155-60",1,"TW-F030-JZ","IWP TUBE KIT 30 PRIMARY 110-156",1,"TW-0030-JZ","IWP TUBE KIT SECONDARY  30'"]
["IWP-175-50",1,"TW-1030-JZ","IWP TUBE KIT 30 PRIMARY 175-200",1,"TW-0020-JZ","IWP TUBE KIT SECONDARY  20'"]
["IWP-175-60",1,"TW-1030-JZ","IWP TUBE KIT 30 PRIMARY 175-200",1,"TW-0030-JZ","IWP TUBE KIT SECONDARY  30'"]
["IWP-175-70",1,"TW-1030-JZ","IWP TUBE KIT 30 PRIMARY 175-200",2,"TW-0020-JZ","IWP TUBE KIT SECONDARY  20'"]
["IWP-200-50",1,"TW-1030-JZ","IWP TUBE KIT 30 PRIMARY 175-200",1,"TW-0020-JZ","IWP TUBE KIT SECONDARY  20'"]
["IWP-200-60",1,"TW-1030-JZ","IWP TUBE KIT 30 PRIMARY 175-200",1,"TW-0030-JZ","IWP TUBE KIT SECONDARY  30'"]
["IWP-200-70",1,"TW-1030-JZ","IWP TUBE KIT 30 PRIMARY 175-200",2,"TW-0020-JZ","IWP TUBE KIT SECONDARY  20'"]
["ITT-80/60-20",1,"TM-1420-SX","ITT TUBE KIT 20'  STAND ALONE"]
["ITT-80/60-30",1,"TM-1430-SX","ITT TUBE KIT 30'  STAND ALONE"]
["ITT-110/75-30",1,"TM-1430-SX","ITT TUBE KIT 30'  STAND ALONE"]
["ITT-110/75-40",1,"TM-1040-SX","ITT TUBE KIT 40' STAND ALONE"]
["ITT-130/90-30",1,"TM-1430-SX","ITT TUBE KIT 30'  STAND ALONE"]
["ITT-130/90-40",1,"TM-1040-SX","ITT TUBE KIT 40' STAND ALONE"]
["ITT-155/110-40",1,"TM-1040-SX","ITT TUBE KIT 40' STAND ALONE"]
["ITT-155/110-50",1,"TM-F030-SX","ITT TUBE KIT 30' PRIMARY 80->155",1,"TM-0020-SX","ITT TUBE KIT 20' SECONDARY"]
["ITT-175/125-50",1,"TM-1030-SX","ITT TUBE KIT 30' PRIMARY 175->200",1,"TM-0020-SX","ITT TUBE KIT 20' SECONDARY"]
["ITT-175/125-60",1,"TM-1030-SX","ITT TUBE KIT 30' PRIMARY 175->200",1,"TM-0030-SX","ITT TUBE KIT 30' SECONDARY"]
["ITT-200/140-50",1,"TM-1030-SX","ITT TUBE KIT 30' PRIMARY 175->200",1,"TM-0020-SX","ITT TUBE KIT 20' SECONDARY"]
["ITT-200/140-60",1,"TM-1030-SX","ITT TUBE KIT 30' PRIMARY 175->200",1,"TM-0030-SX","ITT TUBE KIT 30' SECONDARY"]
["ITTU-80/60-10",1,"TM-1410-SU","ITTU TUBE KIT 10'U STAND ALONE"]
["ITTU-80/60-15",1,"TM-1415-SU","ITTU TUBE KIT 15'U STAND ALONE"]
["ITTU-110/75-15",1,"TM-1415-SU","ITTU TUBE KIT 15'U STAND ALONE"]
["ITTU-110/75-20",1,"TM-1020-SU","ITTU TUBE KIT 20'U STAND ALONE"]
["ITTU-130/90-15",1,"TM-1415-SU","ITTU TUBE KIT 15'U STAND ALONE"]
["ITTU-130/90-20",1,"TM-1020-SU","ITTU TUBE KIT 20'U STAND ALONE"]
["ITTU-155/110-20",1,"TM-1020-SU","ITTU TUBE KIT 20'U STAND ALONE"]
["ITTU-155/110-30",1,"TM-0020-SU","ITTU TUBE KIT 20'U PRIMARY 155",1,"TM-0010-SU","ITTU TUBE KIT 10' SECONDARY"]
["ITTU-175/125-30",1,"TM-A120-SU","ITTU TUBE KIT 20'U PRIMARY 175-200",1,"TM-0010-SU","ITTU TUBE KIT 10' SECONDARY"]
["ITTU-200/140-30",1,"TM-A120-SU","ITTU TUBE KIT 20'U PRIMARY 175-201",1,"TM-0010-SU","ITTU TUBE KIT 10' SECONDARY"]