{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Conversion","Sheet2","Weights","Sheet2 (2)","Sheet 3","Sheet1","Instructions"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Conversion","index":0,"n_rows":45,"n_cols":48,"rows_kept":45,"cut":false,"hidden":true,"merged":[[8,2,8,3],[8,4,8,6],[8,7,8,8],[8,16,8,19],[8,23,8,26],[8,40,8,43],[8,44,8,47],[25,28,25,29],[8,27,8,30],[8,31,8,34],[8,36,8,38]]}
["Product Family","Type","Application","Nominal Capacity","Cabinet Size","Controls","Unit Voltage","Model Vintage","Airflow Orientation","Supply Blower/Size Type","Supply Blower Options","Supply Motor Size","Supply Motor Type","Cooling Coil","Compressor Type","Refrigerant Pressure Switch","Refrigeration Controls/Options","Heating Type","Electric Heating Capacity","Gas Heating Capacity","Heater Control","Heating Gas Safety Controls","Energy Recovery","Energy Recovery Options","Ventilation","Exhaust Blower Size","Exhaust Blower Options","Exhaust Motor Size","Exhaust Motor Type","Corrosion Protection","Maintenance Options","Power Options","Control Options","Safety Controls","Pre-Filter","Final Filter"]
["1-2","3","4","5-6-7","8-9","10","11","12","13","14-15","16","17","18","19","20","21","22-23","24","25","26-27","28","29","30","31","32","33-34","35","36","37","38-39","40-41","42-43","44-45","46-47","48","49"]
[{"$f":"IF(B5&C5=\"62X\",\"PR\",\"\")","v":"PR"},{"$f":"IF(B5&C5=\"62X\",\"O\",\"\")","v":"O"},{"$f":"IF(B5&C5=\"62X\",\"A\",\"\")","v":"A"},{"$f":"12*E5","v":240},{"$f":"IF(VLOOKUP($G$5,$Q$10:$U$45,5,FALSE)=\"B\",VLOOKUP($D$5,$E$10:$G$39,2,FALSE),VLOOKUP($D$5,$E$10:$G$39,3,FALSE))&INDEX($L$27:$O$31,MATCH(VLOOKUP(D5,$E$10:$F$39,2,FALSE),$K$27:$K$31,0),MATCH(VLOOKUP($K$5,$H$10:$I$41,2,FALSE),$L$26:$O$26,0))","v":"D4"},"*",{"$f":"VLOOKUP($K$5,$H$10:$J$41,3,FALSE)","v":2},"*","*",{"$f":"VLOOKUP($M$5,$X$10:$AA$39,4,FALSE)","v":"BF"},"*",{"$f":"VLOOKUP($I$5,$AB$10:$AE$26,4,FALSE)","v":"B"},"*",{"$f":"VLOOKUP($H$5,$AF$10:$AI$39,3,FALSE)","v":"A"},"*","*",{"$f":"VLOOKUP($H$5,$AF$10:$AI$39,4,FALSE)","v":"AL"},{"$f":"VLOOKUP($G$5,$Q$10:$V$45,6,FALSE)","v":"B"},{"$f":"VLOOKUP($G$5,$Q$10:$W$45,7,FALSE)","v":0},{"$f":"VLOOKUP($G$5,$Q$10:$T$45,4,FALSE)","v":0},"*","*",{"$f":"VLOOKUP($F$5,$AK$10:$AM$34,3,FALSE)","v":"E"},"*","E",{"$f":"VLOOKUP($O$5,$AS$10:$AV$40,4,FALSE)","v":"BF"},"*",{"$f":"VLOOKUP($N$5,$AO$10:$AR$27,4,FALSE)","v":"B"},"*","**","**","**","**","**","*",0]
[null,12,3,4,56,7,8,9,10,11,12,13,14,15,16,17,18]
[null,{"$f":"Sheet2!A4","v":"62"},{"$f":"Sheet2!B4","v":"X"},{"$f":"Sheet2!C4","v":"D"},{"$f":"Sheet2!D4","v":"20"},{"$f":"Sheet2!E4","v":"E"},{"$f":"Sheet2!F4","v":"-"},{"$f":"Sheet2!G4","v":"A"},{"$f":"Sheet2!H4","v":"B"},{"$f":"Sheet2!I4","v":"-"},{"$f":"Sheet2!J4","v":"A"},{"$f":"Sheet2!K4","v":"F"},{"$f":"Sheet2!L4","v":"T"},{"$f":"Sheet2!M4","v":"B"},{"$f":"Sheet2!N4","v":"T"},{"$f":"Sheet2!O4","v":"-"},{"$f":"Sheet2!P4","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT(A3,\"00\"),B3,C3,TEXT(D3,\"000\"),TEXT(E3,\"00\"),F3,G3,H3,I3,TEXT(J3,\"00\"),K3,L3,M3,N3,O3,P3,TEXT(Q3,\"00\"),R3,S3,TEXT(T3,\"00\"),U3,V3,W3,X3,Y3,TEXT(Z3,\"00\"),AA3,AB3,AC3,AD3,AE3,AF3,AG3,AH3,AI3,AJ3)","v":"PROA240D4*2**BF*B*A**ALB000**E*EBF*B************0"},null,null,null,{"$f":"LEN(T6)","v":49}]
[]
[]
[null,null,"Size (5,6)",null,"CABINET (4)",null,null,"Condenser (12)",null,"Voltage",null,null,null,null,null,null,"Furnace",null,null,null,"Cabinet Trigger",24,25,"SUPPLY FAN",null,null,null,"SUPPLY FAN MOTOR",null,null,null,"EVAP AND RHSC",null,null,null,null,"ECW",null,null,null,"Exhaust FAN MOTOR",null,null,null,"Exhaust Fan"]
[null,null,"03",36,"A","A","A","A","min",2,null,null,null,null,null,null,"-",null,null,0,"B","B",0,"A","280 mm","BI","CA","A",1,"ODP","A","A",4,"A","AL",null,"-",0,0,null,"-",0,0,0,"-",0,0,0]
[null,null,"04",48,"B","B","F","B","min",2,null,null,null,null,null,null,"A",75,"Standard","A1","B","B",0,"B","315 mm","BI","CC","B",1.5,"ODP","B","B",4,"A","AM",null,"A",244,"A",null,"A",1,"ODP","A","A","280 mm","BI","CA"]
[null,null,"05",60,"C","C","G","C","low",2,null,null,null,null,null,null,"B",100,"Standard","B1","B","B",0,"C","355 mm small ","BI","CD","C",2,"ODP","C","C",4,"A","AL",null,"B",324,"B",null,"B",1.5,"ODP","B","B","315 mm","BI","CC"]
[null,null,"06",72,"D","D","H","D","low",2,null,null,null,null,null,null,"C",150,"Standard","C1","B","B",0,"D","355 mm medium ","BI","CE","D",3,"ODP","D","D",4,"A","AM",null,"C",364,"C",null,"C",2,"ODP","C","C","355 mm small ","BI","CD"]
[null,null,"07",84,"F","E","J","E","medium",2,null,null,null,null,null,null,"D",200,"Standard","D1","B","B",0,"E","355 mm  large ","BI","CF","E",5,"ODP","E","E",4,"A","DC",null,"D",424,"D",null,"D",3,"ODP","D","D","355 mm medium ","BI","CE"]
[null,null,"08",96,"G","A","A","F","medium",2,null,null,null,null,null,null,"E",250,"Standard","E1","B","B",0,"F","400 mm small ","BI","CG","F",7.5,"ODP","F","F",6,"B","AL",null,"E",484,"E",null,"E",5,"ODP","E","E","355 mm  large ","BI","CF"]
[null,null,10,120,"H","B","F","G","high",2,null,null,null,null,null,null,"F",300,"Standard","F1","B","B",0,"G","400 mm medium ","BI","CH","G",10,"ODP","G","G",6,"B","AM",null,"F",486,"F",null,"F",7.5,"ODP","F","F","400 mm small ","BI","CG"]
[null,null,12,150,"I","C","G","H","high",2,null,null,null,null,null,null,"G",350,"Standard","G1","B","B",0,"H","400 mm large ","BI","CJ","H",15,"ODP","H","H",6,"B","AL",null,"G",544,"G",null,"G",10,"ODP","G","G","400 mm medium ","BI","CH"]
[null,null,15,180,"J","D","H","I","min",3,null,null,null,null,null,null,"H",400,"Standard","H1","B","B",0,"I","450 mm small ","BI","CK","I",1,"TEFC","A","I",6,"B","AM",null,"H",604,"H",null,"H",15,"ODP","H","H","400 mm large ","BI","CJ"]
[null,null,18,210,"K","E","J","J","min",3,null,null,null,null,null,null,"I",200,"High (XL)","A2","C","C",0,"J","450 mm  medium ","BI","CL","J",1.5,"TEFC","B","J",6,"B","DC",null,"I",606,"J",null,"I",1,"TEFC","A","I","450 mm small ","BI","CK"]
[null,null,20,240,"L","A","A","K","low",3,null,null,null,null,null,null,"J",400,"High (XL)","B2","C","C",0,"K","450 mm large ","BI","CM","K",2,"TEFC","C","K",4,"A","AL",null,"J",664,"K",null,"J",1.5,"TEFC","B","J","450 mm  medium ","BI","CL"]
[null,null,25,300,"M","B","F","L","low",3,null,null,null,null,null,null,"K",500,"High (XL)","C2","C","C",0,"L","500 mm small ","BI","CN","L",3,"TEFC","D","L",4,"A","AM",null,"K",666,"L",null,"K",2,"TEFC","C","K","450 mm large ","BI","CM"]
[null,null,30,360,"N","C","G","M","medium",3,null,null,null,null,null,null,"L",600,"High (XL)","D2","C","C",0,"M","500 mm large ","BI","CP","M",5,"TEFC","E","M",4,"A","AL",null,"L",706,"M",null,"L",3,"TEFC","D","L","500 mm small ","BI","CN"]
[null,null,35,420,"O","D","H","N","medium",3,null,null,null,null,null,null,"M",700,"High (XL)","F2","C","C",0,"N","560 mm","BI","CQ","N",7.5,"TEFC","F","N",4,"A","AM",null,"M",244,"A",null,"M",5,"TEFC","E","M","500 mm large ","BI","CP"]
[null,null,40,480,"P","E","J","O","high",3,null,null,null,null,null,null,"N",800,"High (XL)","E2","C","C",0,"O","10 in","BI","BA","O",10,"TEFC","G","O",4,"A","DC",null,"N",324,"B",null,"N",7.5,"TEFC","F","N","560 mm","BI","CQ"]
[null,null,45,540,"Q","A","A","P","high",3,null,null,null,null,null,null,8,1000,"High (XL)","B4","C","C",0,"P","11 in","BI","BB","P",15,"TEFC","H","P",6,"B","AL",null,"O",364,"C",null,"O",10,"TEFC","G","O","10 in","BI","BA"]
[null,null,50,600,"R","B","F","Q","min",4,null,"min","low","medium","high",null,9,1200,"High (XL)","C4","C","C",0,"Q","12 in","BI","BC","Q","ECM",null,"M","Q",6,"B","AM",null,"P",424,"D",null,"P",15,"TEFC","H","P","11 in","BI","BB"]
[null,null,55,660,"S","C","G","R","min",4,"A",1,"n/a","n/a",2,null,"O",1400,"High (XL)","D4","C","C",0,"R","14 in","BI","BD",null,null,null,null,"R",6,"B","AL",null,"Q",484,"E",null,"Q","ECM",null,"M","Q","12 in","BI","BC"]
[null,null,60,720,"T","D","H","S","low",4,"B",1,2,3,4,null,"P",1600,"High (XL)","E4","C","C",0,"S","16 in","BI","BE",null,null,null,null,"S",6,"B","AM",null,"R",486,"F",null,null,null,null,null,"R","14 in","BI","BD"]
[null,null,65,780,"U","E","J","T","low",4,"C",2,3,4,6,null,"Q",5,"n/a",0,"B","A","A","T","18 in","BI","BF",null,null,null,null,"T",6,"B","DC",null,"S",544,"G",null,null,null,null,null,"S","16 in","BI","BE"]
[null,null,70,840,"V","A","A","U","medium",4,"D",4,"n/a",6,8,null,"R",10,"n/a",0,"B","A","B","U","20 in","BI","BG",null,null,null,null,"U",4,"A","AL",null,"T",604,"H",null,null,null,null,null,"T","18 in","BI","BF"]
[null,null,null,null,"W","B","F","V","medium",4,"E",4,"n/a",6,8,null,"S",15,"n/a",0,"B","A","C","V","22 in","BI","BH",null,null,null,null,"V",4,"A","AM",null,"U",606,"J",null,null,null,null,null,"U","20 in","BI","BG"]
[null,null,null,null,"X","C","G","W","high",4,null,null,null,null,null,null,"T",20,"n/a",0,"B","A","D","W","25 in","BI","BJ",null,null,null,null,"W",4,"A","AL",null,"V",664,"K",null,null,null,null,null,"V","22 in","BI","BH"]
[null,null,null,null,"Y","D","H","X","high",4,null,null,null,null,null,null,"U",25,"n/a",0,"B","A","E","X","12 in","AF","AC",null,null,null,null,"X",4,"A","AM",null,"W",666,"L",null,null,null,null,null,"W","25 in","BI","BJ"]
[null,null,null,null,"Z","E","J","Y","min",5,null,null,null,null,null,null,"V",30,"n/a",0,"B","A","F","Y","14 in","AF","AD",null,null,null,null,"Y",4,"A","DC",null,"X",706,"M",null,null,null,null,null,"X","12 in","AF","AC"]
[null,null,null,null,1,"A","A","Z","min",5,null,null,null,null,null,null,"W",35,"n/a",0,"B","A","G","Z","16 in","AF","AE",null,null,null,null,"Z",6,"B","AL",null,null,null,null,null,null,null,null,null,"Y","14 in","AF","AD"]
[null,null,null,null,2,"B","F",1,"low",5,null,null,null,null,null,null,"X",40,"n/a",0,"B","A","H",1,"18 in","AF","AF",null,null,null,null,1,6,"B","AM",null,null,null,null,null,null,null,null,null,"Z","16 in","AF","AE"]
[null,null,null,null,3,"C","G",2,"low",5,null,null,null,null,null,null,"Y",50,"n/a",0,"B","A","K",2,"20 in","AF","AG",null,null,null,null,2,6,"B","AL",null,null,null,null,null,null,null,null,null,1,"18 in","AF","AF"]
[null,null,null,null,4,"D","H",3,"medium",5,null,null,null,null,null,null,"Z",60,"n/a",0,"B","A","M",3,"22 in","AF","AH",null,null,null,null,3,6,"B","AM",null,null,null,null,null,null,null,null,null,2,"20 in","AF","AG"]
[null,null,null,null,5,"E","J",4,"medium",5,null,null,null,null,null,null,1,70,"n/a",0,"B","A","N",4,"25 in","AF","AJ",null,null,null,null,4,6,"B","DC",null,null,null,null,null,null,null,null,null,3,"22 in","AF","AH"]
[null,null,null,null,null,null,null,5,"high",5,null,null,null,null,null,null,2,80,"n/a",0,"B","A","P",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"25 in","AF","AJ"]
[null,null,null,null,null,null,null,6,"high",5,null,null,null,null,null,null,3,100,"n/a",0,"B","A","R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,110,"n/a",0,"B","A","S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,120,"n/a",0,"B","A","T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Steam Coil",null,0,"B","F",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Hot Water Coil",null,0,"B","F",0]

{"sheet":"Sheet2","index":1,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["62XD20E-AB-AFTBT--"]
[null,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18]
[{"$f":"MID(A2,1,2)","v":"62"},{"$f":"MID($A$2,B3,1)","v":"X"},{"$f":"MID($A$2,C3,1)","v":"D"},{"$f":"MID($A$2,D3,2)","v":"20"},"E","-","A","B","-","A","F","T","B","T","-","-"]

{"sheet":"Weights","index":2,"n_rows":73,"n_cols":83,"rows_kept":73,"cut":false,"hidden":false,"merged":[[25,8,25,15],[27,7,27,16],[37,9,38,9],[28,7,29,7],[28,13,28,16],[28,10,28,12],[30,7,31,7],[37,12,38,16],[34,8,34,15]]}
["CODE","Description","Select Code from DROPDOWN below",null,null,null,null,{"$f":"LEN(I26)","v":49},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit","TYPE","APPLICATION","CAPACITY","CABINET","CNTLS","VOLTAGE","VINTAGE","AF ORIENT","SUPPLY","S. OPTS","S. MOTOR","S MTR. TYPE","4/6 ROW","COMP","Ref. P.Sw","RFG. CNTLS","HEAT TYPE","ELEC. HEAT","GAS FURN","HTR CNTL","GAS SAFETY","ECW","ECW OPTS","VENTILN","EXHAUST BWLR","E. BWLR OPTS","E. MOTOR","E. MTR TYPE","CORROSN","MAINTN OPTS","POWER OPTS","CNTL OPTS","SAFETY OPTS","FLTR","FINAL FLTR"]
["1-2","UNIT","LC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C2,2)","v":"LC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-2",3,4,"5-6-7","8-9","10","11","12","13","14-15","16","17","18","19","20",21,"22-23",24,25,"26-27",28,29,30,31,32,"33-34",35,36,37,"38-39","40-41","42-43","44-45","46-47",48,49]
[3,"TYPE","O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C3,1)","v":"O"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR","O","A",36,"A0","*","2","A","*","AA= 10” DD, Airfoil","*","A = 1HP","*","A = 4-Row Evap.","*","*","0",0,0,0,"*","*",0,"*",0,0,"*",0,"*","*","*","*","*","*","*",0]
[4,"APPLICATION","A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C4,1)","v":"A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LC","R","W",48,"B0",null,"3",null,null,"AB= 11” DD, Airfoil",null,"B = 1.5HP",null,"B = 6-Row Evap",null,null,"AL = RHX1","A = Electric","A = 5kW","A1 = 75 MBH ",null,null,"A = ECW244",null,"A = OA Damper ONLY","AA= 10” DD, Airfoil",null,"A = 1HP",null,null,null,null,null,null,null,"A"]
["5-6-7","CAPACITY",240,"Select appropriate Cabinet and fans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C5","v":240},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","H",60,"C0",null,"4",null,null,"AC= 12” DD, Airfoil",null,"C = 2HP",null,"C = 4-Row CWC",null,null,"AM = RHx2","B = N. Gas x1","B = 10kW","B1 = 100 MBH ",null,null,"B = ECW324",null,"B = OA Damper ONLY","AB= 11” DD, Airfoil",null,"B = 1.5HP",null,null,null,null,null,null,null,"B"]
["8-9","CABINET","K4",{"$f":"IF(OR($C$4=\"F\",$C$4=\"W\"), \"Change to '0' fans\",\"Select # fans\")","v":"Select # fans"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C6,2)","v":"K4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",72,"D0",null,"5",null,null,"AD= 14” DD, Airfoil",null,"D = 3HP",null,"D = 6-Row CWC",null,null,"AN = SCx1","C = N. Gas x 2","C = 15kW","C1 = 150 MBH ",null,null,"C = ECW364",null,"C = OA Damper ONLY","AC= 12” DD, Airfoil",null,"C = 2HP",null,null,null,null,null,null,null,"C"]
["10","CNTLS","*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C7","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,"E0",null,"6",null,null,"AE= 16” DD, Airfoil",null,"E = 5HP",null,"X",null,null,"BC = RHx1","D = P. Gas x1","D = 20kW","D1 = 200 MBH ",null,null,"D = ECW424",null,"D = OA & RA Dampers","AD= 14” DD, Airfoil",null,"D = 3HP",null,null,null,null,null,null,null,"D"]
["11","VOLTAGE","2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C8,1)","v":"2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,"A1",null,"7",null,null,"AF= 18” DD, Airfoil",null,"F = 7.5HP",null,null,null,null,"BD = SCx1","E = P. Gas x2","E = 25kW","E1 = 250 MBH ",null,null,"E = ECW484",null,"E = OA & RA Dampers","AE= 16” DD, Airfoil",null,"E = 5HP",null,null,null,null,null,null,null,"E"]
["12","VINTAGE","A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C9","v":"A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"A2",null,"X",null,null,"AG= 20” DD, Airfoil",null,"G = 10HP",null,null,null,null,"BG = RHx1","F = HWC","F = 30kW","F1 = 300 MBH ",null,null,"F = ECW486",null,"F = OA & RA Dampers","AF= 18” DD, Airfoil",null,"F = 7.5HP",null,null,null,null,null,null,null,"F"]
["13","SUP. ORIENTATION","*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C10","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,"B1",null,null,null,null,"AH= 22” DD, Airfoil",null,"H = 15HP",null,null,null,null,"BH = SCx1","X","G = 35kW","G1 = 350 MBH ",null,null,"G = ECW544",null,"G = OA & RA Dampers","AG= 20” DD, Airfoil",null,"G = 10HP",null,null,null,null,null,null,null,"G"]
["14-15","SUPPLY","BF= 18” DD, BI",{"$f":"IF(OR(LEFT(C11,1)=\"A\",LEFT(C11,1)=\"B\"), \"Select Motor HP (Code 17)\", \"Code 17=M\")","v":"Select Motor HP (Code 17)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C11,2)","v":"BF"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRF300C4**A*BG*F*D*AMF000**0*G00*0************0",null,null,null,null,180,"B2",null,null,null,null,"AJ= 25” DD, Airfoil",null,"J = 20HP",null,null,null,null,"CC = RHx2",null,"H = 40kW","H1 = 400 MBH ",null,null,"H = ECW604",null,"H = OA & RA Dampers","AH= 22” DD, Airfoil",null,"H = 15HP",null,null,null,null,null,null,null,"H"]
["16","S. OPTS","*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"B3",null,null,null,null,"AK= 28” DD, Airfoil",null,"K = 25HP",null,null,null,null,"CD = SCx1",null,"J = 45kW","J1 = 500 MBH",null,null,"J = ECW606",null,"X","AJ= 25” DD, Airfoil",null,"J = 20HP",null,null,null,null,null,null,null,"X"]
["17","S. MOTOR","E = 5HP",{"$f":"IF(OR(LEFT(C11,1)=\"C\",LEFT(C11,1)=\"D\"),\"Code 17=M\",\"Select Motor\")","v":"Select Motor"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C13,1)","v":"E"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(AT17)","v":49},null,null,null,null,240,"B4",null,null,null,null,"BA= 10” DD, BI",null,"L = 30HP",null,null,null,null,"CH = RHx2",null,"K = 50kW","K1 = 600 MBH",null,null,"K = ECW664",null,null,"AK= 28” DD, Airfoil",null,"K = 25HP"]
["18","S MTR. TYPE","*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C14","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,"C2",null,null,null,null,"BB= 11” DD, BI",null,"M = ECM",null,null,null,null,"CJ = SCx1",null,"L = 55kW","A2 = 100+100 MBH",null,null,"L = ECW666",null,null,"BA= 10” DD, BI",null,"L = 30HP"]
["19","4/6 ROW","B = 6-Row Evap",{"$f":"IF(OR(C4=\"A\",C4=\"H\",C4=\"W\"),\"Select Evaporator\",\"Select Remote Evap or Water Coil\")","v":"Select Evaporator"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C15,1)","v":"B"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,360,"C3",null,null,null,null,"BC= 12” DD, BI",null,"X",null,null,null,null,"DA = SCx1",null,"M = 60kW","G2 = 150+150 MBH",null,null,"M = ECW706",null,null,"BB= 11” DD, BI",null,"M = ECM"]
["20","COMP","*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C16,1)","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,420,"C4",null,null,null,null,"BD= 14” DD, BI",null,null,null,null,null,null,"DB = SCx1",null,"N = 70kW","B2 = 200+200 MBH",null,null,"N = ECW724",null,null,"BC= 12” DD, BI",null,"X"]
[21,"Ref. Pr. Sw","*",{"$f":"IF(OR(LEFT(C15,1)=\"C\",LEFT(C15,1)=\"D\"),\"RH/SC NOT POSSIBLE\",\"Dehumidication option available\")","v":"Dehumidication option available"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA2&AA3&AA4&TEXT(AA5,\"000\")&AA6&AA7&AA8&AA9&AA10&AA11&AA12&AA13&AA14&AA15&AA16&AA17&TEXT(AA18,\"00\")&AA19&AA20&TEXT(AA21,\"00\")&AA22&AA23&AA24&AA25&AA26&TEXT(AA27,\"00\")&AA28&AA29&AA30&AA31&AA32&AA33&AA34&AA35&AA36&AA37","v":"LCOA240K4*2A*BF*E*B**DC0000**0*B00*0************0"},null,null,null,null,480,"C6",null,null,null,null,"BE= 16” DD, BI",null,null,null,null,null,null,"DC = RHSC",null,"P = 80kW","C2 = 250+250 MBH",null,null,"P = ECW726",null,null,"BD= 14” DD, BI"]
["22-23","RFG. CNTLS","DC = RHSC",{"$f":"IF(C19=0,\"\",IF(LEFT(C19,1)=\"F\",\"Code 24 & 25-26 = 0\",\"Select Gas or Elec.HeatCap.\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C18,2)","v":"DC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,540,"K5",null,null,null,null,"BF= 18” DD, BI",null,null,null,null,null,null,"DD = SCx1",null,"Q = 90kW","D2 = 300+300 MBH",null,null,"Q = ECW784",null,null,"BE= 16” DD, BI"]
[24,"HEAT TYPE",0,{"$f":"IF(C20=0,\"\",\"Code 23 = Elec. Heat\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C19,1)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,"K4",null,null,null,null,"BG= 20” DD, BI",null,null,null,null,null,null,"DE = SCx1",null,"R = 100kW","F2 = 350+350 MBH",null,null,"R = ECW786",null,null,"BF= 18” DD, BI"]
[25,"ELEC. HEAT",0,{"$f":"IF(C21=0,\"\",\"Code 23 = Gas. Heat\")","v":""},null,null,null,"* Unit Shown: PR A1 Cabinet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C20,1)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,660,"D4",null,null,null,null,"BH= 22” DD, BI",null,null,null,null,null,null,"DF = SCx1",null,"S = 110kW","E2 = 400+400 MBH",null,null,"S = ECW7812",null,null,"BG= 20” DD, BI"]
["26-27","GAS FURN",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C21,2)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,720,"D6",null,null,null,null,"BJ= 25” DD, BI",null,null,null,null,null,null,"DG = SCx1",null,"T = 120kW","H2 = 500+500MBH",null,null,"T = ECW844",null,null,"BH= 22” DD, BI"]
[28,"HTR CNTL","*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C22,1)","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,780,"D8",null,null,null,null,"BK= 28” DD, BI",null,null,null,null,null,null,"DH = RHSC",null,"U = 130kW","J2 = 600+600MBH",null,null,"U = ECW846",null,null,"BJ= 25” DD, BI"]
[29,"GAS SAFETY","*",{"$f":"IF(LEFT(C24,1)=\"0\",\"\",\"Select Exhaust Fan\")","v":""},null,null,null,"Quote/Job#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C23,1)","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,840,"D9",null,null,null,null,"CA= 280mm Single ECM (CIW.087.5FA)",null,null,null,null,null,null,"DJ = SCx1",null,"V = 140kW","A4 = (4) 200 MBH",null,null,"V = ECW8412",null,null,"BK= 28” DD, BI"]
[30,"ECW",0,null,null,null,null,"Customer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C24,1)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E6",null,null,null,null,"CB= 315mm Single ECM (CIW.098.5FA)",null,null,null,null,null,null,"DK = SCx1",null,"W = 150kW","B4 = (4) 250 MBH",null,null,"X = Special",null,null,"CA= 280mm Single ECM (CIW.087.5FA)"]
[31,"ECW OPTS","*",null,null,null,null,null,null,null,null,null,{"$f":"IF(H1<48,\"Check Code\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C25,1)","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E8",null,null,null,null,"CC= 315mm Single ECM (CIW.080.5FA)",null,null,null,null,null,null,"XX",null,"X","C4 = (4) 300 MBH",null,null,null,null,null,"CB= 315mm Single ECM (CIW.098.5FA)"]
[32,"VENTILN","B = OA Damper ONLY",{"$f":"IF(C27=0,\"\",IF(OR(LEFT(C27,1)=\"A\",LEFT(C27,1)=\"B\"), \"Select Motor HP (Code 35)\", \"Code 35=M\"))","v":""},null,null,null,null,"LCOA360D9*2A*BF*E*B**DC0000**0*B00*0************0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C26,1)","v":"B"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E9",null,null,null,null,"CD= 355mm Single ECM (CIW.110.5HF)",null,null,null,null,null,null,null,null,null,"D4 = (4) 350 MBH",null,null,null,null,null,"CC= 315mm Single ECM (CIW.080.5FA)"]
["33-34","EXHAUST BWLR",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C27,2)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F1",null,null,null,null,"CE= 355mm Single ECM (CIW.110.6FF)",null,null,null,null,null,null,null,null,null,"E4 = (4) 400 MBH",null,null,null,null,null,"CD= 355mm Single ECM (CIW.110.5HF)"]
[35,"E. BWLR OPTS","*",{"$f":"IF(C29=0,\"\",IF(OR(LEFT(C27,1)=\"C\",LEFT(C27,1)=\"D\"),\"=M\",\"Select Motor\"))","v":""},null,null,null,{"$f":"I23&\": \"&'Sheet 3'!B56","v":":  RH/SC 6-Row Evap. 18 inch FAN; 5HP    D6 Cab"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C28","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F2",null,null,null,null,"CF= 355mm Single ECM (CIB.112.5HF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CE= 355mm Single ECM (CIW.110.6FF)"]
[36,"E. MOTOR",0,null,null,null,null,{"$f":"'Sheet 3'!B57","v":"LCOA"},{"$f":"'Sheet 3'!C57","v":"Shipping Weight"},{"$f":"'Sheet 3'!D57","v":"Operating Weight"},{"$f":"'Sheet 3'!E57","v":"Center of Gravity "},null,null,{"$f":"'Sheet 3'!H57","v":"Corner Weights"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(C29,1)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F3",null,null,null,null,"CG= 400mm Single ECM (CIW.123.5HF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CF= 355mm Single ECM (CIB.112.5HF)"]
[37,"E. MTR TYPE","*",null,null,null,null,null,{"$f":"'Sheet 3'!C58","v":"lbs (kg)"},{"$f":"'Sheet 3'!D58","v":"lbs (kg)"},{"$f":"'Sheet 3'!E58","v":"X"},{"$f":"'Sheet 3'!F58","v":"Y"},{"$f":"'Sheet 3'!G58","v":"Z"},{"$f":"'Sheet 3'!H58","v":"LF"},{"$f":"'Sheet 3'!I58","v":"LB"},{"$f":"'Sheet 3'!J58","v":"RF"},{"$f":"'Sheet 3'!K58","v":"RB"},null,null,null,null,null,null,null,null,null,{"$f":"C30","v":"*"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F4",null,null,null,null,"CH= 400mm Single ECM (CIW.123.6FF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CG= 400mm Single ECM (CIW.123.5HF)"]
["38-39","CORROSN","**",null,null,null,null,{"$f":"'Sheet 3'!B59","v":360},{"$f":"'Sheet 3'!C59","v":5170},{"$f":"'Sheet 3'!D59","v":5170},{"$f":"'Sheet 3'!E59","v":97.661035564127602},{"$f":"'Sheet 3'!F59","v":39.6669462791223},{"$f":"'Sheet 3'!G59","v":62.268865826234311},{"$f":"'Sheet 3'!H59/('Sheet 3'!H59+'Sheet 3'!J59)*('Sheet2 (2)'!L41+'Sheet2 (2)'!L45+'Sheet2 (2)'!L42)","v":699.98722316922544},{"$f":"'Sheet 3'!I59/('Sheet 3'!I59+'Sheet 3'!K59)*('Sheet2 (2)'!L44+'Sheet2 (2)'!L46+'Sheet2 (2)'!L43)","v":648.15748581692026},{"$f":"'Sheet 3'!J59/('Sheet 3'!H59+'Sheet 3'!J59)*('Sheet2 (2)'!L41+'Sheet2 (2)'!L45+'Sheet2 (2)'!L42)","v":1986.4502279126671},{"$f":"'Sheet 3'!K59/('Sheet 3'!I59+'Sheet 3'!K59)*('Sheet2 (2)'!L44+'Sheet2 (2)'!L46+'Sheet2 (2)'!L43)","v":1838.2171319070035},null,null,null,null,null,null,null,null,null,"**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G2",null,null,null,null,"CJ= 400mm Single ECM (CIB.125.6FF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH= 400mm Single ECM (CIW.123.6FF)"]
["40-41","MAINTN OPTS","**",null,null,null,null,null,{"$f":"'Sheet 3'!C60","v":-2342.0100000000002},{"$f":"'Sheet 3'!D60","v":-2342.0100000000002},{"$f":"'Sheet 3'!E60","v":-2480.5903033288409},{"$f":"'Sheet 3'!F60","v":-1007.5404354897064},{"$f":"'Sheet 3'!G60","v":-1581.6291919863513},{"$f":"'Sheet 3'!H60","v":-335.22},{"$f":"'Sheet 3'!I60","v":-276.33},{"$f":"'Sheet 3'!J60","v":-951.30000000000007},{"$f":"'Sheet 3'!K60","v":-783.69},null,null,null,null,null,null,null,null,null,"**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G3",null,null,null,null,"CK= 450mm Single ECM (CIW.138.5HF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CJ= 400mm Single ECM (CIB.125.6FF)"]
["42-43","POWER OPTS","**",null,null,null,null,{"$f":"'Sheet 3'!F61","v":"Approx. Main Cabinet LXW: 135 X 88"},null,null,null,null,null,null,null,null,{"$f":"'Sheet 3'!K61","v":"2017-07-07"},null,null,null,null,null,null,null,null,null,"**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G4",null,null,null,null,"CL= 450mm Single ECM (CIW.138.6FF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CK= 450mm Single ECM (CIW.138.5HF)"]
["44-45","CNTL OPTS","**",null,null,null,null,{"$f":"'[1]Sheet 3'!B61","v":"* Corner weights along the main cabinet (Including Condenser section)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G6",null,null,null,null,"CM= 450mm Single ECM (CIB.140.6IF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CL= 450mm Single ECM (CIW.138.6FF)"]
["46-47","SAFETY OPTS","**",null,null,null,null,null,"TOP VIEW",null,null,null,null,null,null,null,{"$f":"IF('Sheet2 (2)'!S13=0,\"ERROR\",\"\")","v":""},{"$f":"MROUND('Sheet2 (2)'!L47,10)","v":5170},null,null,null,null,null,null,null,null,"**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H4",null,null,null,null,"CN= 500mm Single ECM (CIW.155.6IF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CM= 450mm Single ECM (CIB.140.6IF)"]
[48,"FLTR","*",null,null,null,null,{"$f":"'Sheet2 (2)'!J44&\" = \"&ROUND('Sheet2 (2)'!L44,0)&\" lb\"","v":"M4 = 706 lb"},null,null,null,{"$f":"'Sheet2 (2)'!J46&\" = \"&ROUND('Sheet2 (2)'!L46,0)&\" lb\"","v":"M3 = 1298 lb"},null,null,null,null,{"$f":"'Sheet2 (2)'!J43&\" = \"&ROUND('Sheet2 (2)'!L43,0)&\" lb\"","v":"M6 = 482 lb"},null,null,null,null,null,null,null,null,null,"*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H6",null,null,null,null,"CP= 500mm Single ECM (CIB.160.6IF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CN= 500mm Single ECM (CIW.155.6IF)"]
[49,"FINAL FLTR",0,"Future",null,null,null,{"$f":"\"(\"&'Sheet2 (2)'!$D$6&\",\"&'Sheet2 (2)'!$E$6&\")\"","v":"(0,88)"},null,null,null,{"$f":"\"(\"&'Sheet2 (2)'!$H$6&\",\"&'Sheet2 (2)'!$I$6&\")\"","v":"(132,88)"},null,null,null,null,{"$f":"\"(\"&'Sheet2 (2)'!$M$6&\",\"&'Sheet2 (2)'!$N$6&\")\"","v":"(250,88)"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H8",null,null,null,null,"CQ= 560mm Single ECM (CIW.174.6IF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CP= 500mm Single ECM (CIB.160.6IF)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CONDENSING SECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H9",null,null,null,null,"DA= 280mm Dual ECM (CIW.087.5FA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CQ= 560mm Single ECM (CIW.174.6IF)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J6",null,null,null,null,"DB= 315mm Dual ECM (CIW.098.5FA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DA= 280mm Dual ECM (CIW.087.5FA)"]
[null,null,null,null,null,null,null,{"$f":"\"(\"&'Sheet2 (2)'!$D$21&\",\"&'Sheet2 (2)'!$E$21&\")\"","v":"(0,0)"},null,null,null,{"$f":"\"(\"&'Sheet2 (2)'!$H$21&\",\"&'Sheet2 (2)'!$I$21&\")\"","v":"(132,0)"},null,null,null,null,{"$f":"\"(\"&'Sheet2 (2)'!$M$21&\",\"&'Sheet2 (2)'!$N$21&\")\"","v":"(250,0)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J8",null,null,null,null,"DC= 315mm Dual ECM (CIW.080.5FA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DB= 315mm Dual ECM (CIW.098.5FA)"]
[null,null,null,null,null,null,null,{"$f":"'Sheet2 (2)'!J41&\" = \"&ROUND('Sheet2 (2)'!L41,0)&\" lb\"","v":"M1 = 730 lb"},null,null,null,{"$f":"'Sheet2 (2)'!J45&\" = \"&ROUND('Sheet2 (2)'!L45,0)&\" lb\"","v":"M2 = 1467 lb"},null,null,null,null,{"$f":"'Sheet2 (2)'!J42&\" = \"&ROUND('Sheet2 (2)'!L42,0)&\" lb\"","v":"M5 = 489 lb"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J9",null,null,null,null,"DD= 355mm Dual ECM (CIW.110.5HF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC= 315mm Dual ECM (CIW.080.5FA)"]
[null,null,null,null,null,null,"ANILSARMA7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F0",null,null,null,null,"DE= 355mm Dual ECM (CIW.110.6FF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD= 355mm Dual ECM (CIW.110.5HF)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G0",null,null,null,null,"DF= 355mm Dual ECM (CIB.112.5HF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE= 355mm Dual ECM (CIW.110.6FF)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H0",null,null,null,null,"DG= 400mm Dual ECM (CIW.123.5HF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DF= 355mm Dual ECM (CIB.112.5HF)"]
[null,null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J0",null,null,null,null,"DH= 400mm Dual ECM (CIW.123.6FF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DG= 400mm Dual ECM (CIW.123.5HF)"]
[null,null,null,null,null,null,"1. Follow cabinet CFM limits for each component.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJ= 400mm Dual ECM (CIB.125.6FF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DH= 400mm Dual ECM (CIW.123.6FF)"]
[null,null,null,null,null,null,"2. Refer to PR Code String for additional details.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EA= Dual 14\" DD, BI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJ= 400mm Dual ECM (CIB.125.6FF)"]
[null,null,null,null,null,null,"3. Double furnace will select an \"XL\" cabinet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB= Dual 14\" DD, AF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EA= Dual 14\" DD, BI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EC= Dual 16\" DD, BI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB= Dual 14\" DD, AF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ED= Dual 16\" DD, AF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EC= Dual 16\" DD, BI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE= Dual 18\" DD, BI",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"ED= Dual 16\" DD, AF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF= Dual 18\" DD, AF",null,null,null,null,null,null,"AL = RHX1",null,null,null,null,null,null,null,null,"EE= Dual 18\" DD, BI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EG= Dual 20\" DD, BI",null,null,null,null,null,null,"AM = RHx2",null,null,null,null,null,null,null,null,"EF= Dual 18\" DD, AF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EH= Dual 20\" DD, AF",null,null,null,null,null,null,"AN = SCx1",null,null,null,null,null,null,null,null,"EG= Dual 20\" DD, BI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XX = Applied Special",null,null,null,null,null,null,"BC = RHx1",null,null,null,null,null,null,null,null,"EH= Dual 20\" DD, AF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BD = SCx1",null,null,null,null,null,null,null,null,"XX = Applied Special"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BG = RHx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BH = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC = RHx2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH = RHx2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CJ = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DA = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DB = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC = RHSC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DF = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DG = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DH = RHSC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJ = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DK = SCx1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XX"]

{"sheet":"Sheet2 (2)","index":3,"n_rows":59,"n_cols":27,"rows_kept":59,"cut":false,"hidden":true,"merged":[[39,9,39,11],[49,14,49,16],[20,23,20,24],[21,3,21,12],[27,4,28,4],[27,5,27,6],[12,0,15,0],[12,1,15,1],[31,4,31,6],[12,18,15,18],[17,2,18,2],[18,3,18,7],[20,2,21,2],[23,2,24,2],[24,3,24,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Enter Length (X) and Width (Y) of unit"]
[null,null,"8 POINT",10,{"$f":"$B$13","v":88},null,null,{"$f":"D3+$D$25/3","v":105.33333333333333},{"$f":"$B$13","v":88},null,null,null,{"$f":"H3+$D$25/3","v":200.66666666666666},{"$f":"$B$13","v":88},null,null,{"$f":"$D$25-10","v":276},{"$f":"$B$13","v":88},null,2,"Enter unit Weight in lbs and C.G information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Select number of isolators"]
[null,null,"Product Code"," =",{"$f":"Weights!I26","v":"LCOA360D9*2A*BF*E*B**DC0000**0*B00*0************0"}]
[null,null,"6 POINT",{"$f":"D21","v":0},{"$f":"B13","v":88},null,null,{"$f":"H21","v":132},{"$f":"B13","v":88},null,null,null,{"$f":"M21","v":250},{"$f":"B13/2+S13/2","v":88}]
[]
[]
[]
[null,null,"4 POINT",0,{"$f":"$B$13","v":88},null,null,{"$f":"D19","v":79},{"$f":"$B$13","v":88},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From actual weights"]
[]
[null,null,null,"M4",null,null,null,"M3",null,null,null,null,"M6",null,null,null,"M8",null,null,{"$f":"Weights!O31+Weights!Q31","v":2486.3746177239236},{"$f":"L44+L46+L43","v":2486.3746177239236},null,null,"M4",null,null,"M3"]
["USER INPUT",{"$f":"ROUND('Sheet 3'!F43,0)","v":88},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(VLOOKUP('Sheet 3'!B5,'Sheet 3'!E121:G166,'Sheet 3'!G121,FALSE),0)","v":88}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M4",578,10,112]
[null,null,null,"(0,0)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5",713,86,0]
[null,null,null,"M1",null,null,null,"M2",null,null,null,null,"M5",null,null,null,"M7",null,null,null,null,null,null,"M6",596,86,112]
[null,null,"4 POINT",0,0,null,null,{"$f":"D19","v":79},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M7"]
[null,null,null,79,null,null,null,null,null,"USER INPUT",null,null,null,null,null,null,null,null,null,null,null,null,null,"M8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y15:Y19)","v":1887},{"$f":"SUMPRODUCT((Y15:Y19),(Z15:Z19))/SUM(Y15:Y19)","v":62.72072072072072},{"$f":"SUMPRODUCT((Y15:Y19),(AA15:AA19))/SUM(Y15:Y19)","v":69.6809750927398}]
[null,null,"6 POINT",0,0,null,null,{"$f":"'Sheet 3'!D43","v":132},0,null,null,null,{"$f":"D22","v":250},{"$f":"B13/2-S13/2","v":0},null,null,null,null,null,{"$f":"Weights!N31+Weights!P31","v":2686.4374510818925},{"$f":"L41+L45+L42","v":2686.4374510818925},null,null,"Estimated C.G",null,"X","Y"]
[null,null,null,{"$f":"H21+VLOOKUP('Sheet 3'!B5,'Sheet 3'!E121:G166,'Sheet 3'!F121,FALSE)","v":250},null,null,null,null,null,null,null,null,null,null,"USER INPUT"]
[]
[null,null,"8 POINT",10,0,null,null,{"$f":"D24+$D$25/3","v":105.33333333333333},0,null,null,null,{"$f":"H24+$D$25/3","v":200.66666666666666},0,null,null,{"$f":"$D$25-10","v":276},0]
[null,null,null,286,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USER INPUT"]
[]
[]
[null,null,null,null,"Operating Weight (lb)","C.G"]
[null,null,null,null,null,"X","Y"]
[null,null,null,null,{"$f":"'Sheet 3'!C42","v":5172.8120688058161},{"$f":"Weights!K31","v":97.661035564127602},{"$f":"Weights!L31","v":39.6669462791223},"USER INPUT"]
[]
[null,null,null,null,"4 Point Load Distribution"]
[null,null,null,null,{"$f":"D17","v":"M1"},{"$f":"$E$30/(($F$30-$D$18)^2+($G$30-$E$18)^2)^0.5","v":49.073530415372232},{"$f":"$E$30*F33/$F$37","v":807.439343851074}]
[null,null,null,null,{"$f":"H17","v":"M2"},{"$f":"$E$30/(($F$30-$H$18)^2+($G$30-$I$18)^2)^0.5","v":118.00048886148272},{"$f":"$E$30*F34/$F$37","v":1941.5403068407684}]
[null,null,null,null,{"$f":"H12","v":"M3"},{"$f":"$E$30/(($F$30-$H$10)^2+($G$30-$I$10)^2)^0.5","v":99.84117696802862},{"$f":"$E$30*F35/$F$37","v":1642.753104128233}]
[null,null,null,null,{"$f":"D12","v":"M4"},{"$f":"$E$30/(($F$30-$D$10)^2+($G$30-$E$10)^2)^0.5","v":47.471453755128202},{"$f":"$E$30*F36/$F$37","v":781.07931398574067}]
[null,null,null,null,"Total",{"$f":"SUM(F33:F36)","v":314.3866500000118},{"$f":"SUM(G33:G36)","v":5172.8120688058161},{"$f":"IF($G$37=$E$30,\"Check\",\"\")","v":"Check"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"6 Point Load Distribution"]
[null,null,null,null,null,null,null,null,null,{"$f":"D17","v":"M1"},{"$f":"$E$30/(('Sheet2 (2)'!$F$30-'Sheet2 (2)'!$D$21)^2+('Sheet2 (2)'!$G$30-'Sheet2 (2)'!$E$21)^2)^0.5","v":49.073530415372232},{"$f":"$E$30*K41/$K$47","v":730.26223766112298}]
[null,null,null,null,null,null,null,null,null,{"$f":"M17","v":"M5"},{"$f":"$E$30/(('Sheet2 (2)'!$F$30-'Sheet2 (2)'!$M$21)^2+('Sheet2 (2)'!$G$30-'Sheet2 (2)'!$N$21)^2)^0.5","v":32.860226883479676},{"$f":"$E$30*K42/$K$47","v":488.99238776725861}]
[null,null,null,null,null,null,null,null,null,{"$f":"M12","v":"M6"},{"$f":"$E$30/(('Sheet2 (2)'!$F$30-'Sheet2 (2)'!$M$6)^2+('Sheet2 (2)'!$G$30-'Sheet2 (2)'!$N$6)^2)^0.5","v":32.365973419203804},481.63741171929945]
[null,null,null,null,null,null,null,null,null,{"$f":"D12","v":"M4"},{"$f":"$E$30/(('Sheet2 (2)'!$F$30-'Sheet2 (2)'!$D$6)^2+('Sheet2 (2)'!$G$30-'Sheet2 (2)'!$E$6)^2)^0.5","v":47.471453755128202},706.42176649648923]
[null,null,null,null,null,null,null,null,null,{"$f":"H17","v":"M2"},{"$f":"$E$30/(('Sheet2 (2)'!$F$30-'Sheet2 (2)'!$H$21)^2+('Sheet2 (2)'!$G$30-'Sheet2 (2)'!$I$21)^2)^0.5","v":98.59450113457838},1467.1828256535109]
[null,null,null,null,null,null,null,null,null,{"$f":"H12","v":"M3"},{"$f":"$E$30/(('Sheet2 (2)'!$F$30-'Sheet2 (2)'!$H$6)^2+('Sheet2 (2)'!$G$30-'Sheet2 (2)'!$I$6)^2)^0.5","v":87.246634049583307},1298.3154395081349]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(K41:K46)","v":347.61231965734561},{"$f":"SUM(L41:L46)","v":5172.8120688058161},{"$f":"IF($L$47=$E$30,\"Check\",\"\")","v":"Check"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 Point Load Distribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D17","v":"M1"},{"$f":"$E$30/(($F$30-$D$24)^2+(G30-E24)^2)^0.5","v":53.761317102023618},{"$f":"$E$30*P51/$P$59","v":570.09769287828738}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H17","v":"M2"},{"$f":"$E$30/((F30-H24)^2+(G30-I24)^2)^0.5","v":128.03320452621077},1357.6943134352489]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H12","v":"M3"},{"$f":"$E$30/(($F$30-$H$3)^2+($G$30-$I$3)^2)^0.5","v":105.70088780919184},1120.8771570988674]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D12","v":"M4"},{"$f":"$E$30/(($F$30-$D$3)^2+($G$30-$E$3)^2)^0.5","v":51.675074414461513},547.9746831181975]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M17","v":"M5"},{"$f":"$E$30/(($F$30-$M$24)^2+($G$30-$N$24)^2)^0.5","v":46.863898006582197},496.95583317154689]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M12","v":"M6"},{"$f":"$E$30/(($F$30-$M$3)^2+($G$30-$N$3)^2)^0.5","v":45.46265602271724},482.09673251652339]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q17","v":"M7"},{"$f":"$E$30/(($F$30-$Q$24)^2+($G$30-$R$24)^2)^0.5","v":28.313587485445581},300.24396299532805]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q12","v":"M8"},{"$f":"$E$30/(($F$30-$Q$3)^2+($G$30-$R$3)^2)^0.5","v":27.995575946335016},296.87169359181706]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P51:P58)","v":487.80620131296774},{"$f":"SUM(Q51:Q58)","v":5172.8120688058161},{"$f":"IF($Q$59=$E$30,\"Check\",\"\")","v":"Check"}]

{"sheet":"Sheet 3","index":4,"n_rows":166,"n_cols":90,"rows_kept":166,"cut":false,"hidden":true,"merged":[[58,1,59,1],[56,1,57,1],[56,4,56,6],[56,7,56,10]]}
[null,{"$f":"LEN(A3)","v":48},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO/RW","Total coils' lbs","lb of water",null,null,null,null,"Condenser"]
[null,{"$f":"Weights!I26","v":"LCOA360D9*2A*BF*E*B**DC0000**0*B00*0************0"},null,null,null,"Voltage",{"$f":"MID(B2,11,1)","v":"2"},null,null,null,null,null,null,null,null,"Evap",36,48,60,72,84,96,120,150,180,210,240,300,360,420,480,540,600,660,720,780,840,null,"Comp",36,48,60,72,84,96,120,150,180,210,240,300,360,420,480,540,600,660,720,780,840,null,36,20,3.4,null,null,null,null,"PRO",36,48,60,72,84,96,120,150,180,210,240,300,360,420,480,540,600,660,720,780,840]
["PROA240D4*2**BF*B*A**ALB00**E*EBF*B************0",null,null,"Cabinet","Fans","Evap","WC/Evap","RH/SC","Supply","Exhaust","ECW",null,null,null,null,"PRO",24,24,24,37,37,37,55,55,55,80,80,94,127,127,226,226,226,226,500,500,550,null,"PRO","ZP34","ZP42","ZP51","ZP54","ZP72","ZP83","ZP51","ZP61","ZP72","ZP91","ZP103","ZP120","ZP137","ZP182","ZPt206","ZPT240","ZPT274","ZPT364","ZPT240","ZPT274","ZPT364",null,48,36,5,null,null,null,null,"A1",463,463,463,463,463,463,"#","#","#","#","#","#","#","#","#","#","#","#","#","#","#"]
[null,{"$f":"IF(MID(B2,3,1)=\"M\",\"PRR\"&MID(B2,4,1),LEFT(B2,4))","v":"LCOA"},{"$f":"ABS(MID(B2,5,3))","v":360},{"$f":"IF(MID($B$2,8,1)=\"K\",\"C\",MID($B$2,8,1))","v":"D"},{"$f":"MID(B2,9,1)","v":"9"},{"$f":"IF(OR(MID($B$2,19,1)=\"A\",MID($B$2,19,1)=\"B\"),MID($B$2,19,1),\"\")","v":"B"},{"$f":"IF(OR(MID($B$2,19,1)=\"C\",MID($B$2,19,1)=\"D\"),MID($B$2,19,1),\"\")","v":""},"DC",{"$f":"MID(B2,14,2)&MID(B2,17,1)","v":"BFE"},{"$f":"MID(B2,33,2)&MID(B2,36,1)","v":"000"},{"$f":"MID($B$2,30,1)","v":"0"},null,null,null,null,"PRR",83,83,83,80,80,80,94,94,127,127,127,226,226,226,500,500,500,550,500,500,550,null,"PRR","ZP29","ZP39","ZP51","ZP61","ZP72","ZP83","ZP51","ZP67","ZP83","ZP90","ZP103","ZP137","ZP154","ZP182","ZPT206","ZPT240","ZPT274","ZPT364","ZPT240","ZPT274","ZPT308",null,60,40,6,null,null,null,null,"A2","#","#","#","#",626,626,680,680,680,680,"#","#","#","#","#","#","#","#","#","#","#"]
[null,{"$f":"MID($B$2,8,2)","v":"D9"},"HWC",{"$f":"MID($B$2,24,1)","v":"0"},"ELEC",{"$f":"MID($B$2,25,1)","v":"0"},"FUR",{"$f":"MID($B$2,26,2)","v":"00"},"Damper",{"$f":"MID($B$2,32,1)","v":"B"},null,null,null,null,null,"LCO",null,null,null,null,null,null,"#",null,"#",null,"#",null,null,null,null,null,null,null,null,null,null,null,"PRO",48,67,75.8,75.599999999999994,88,87,75.8,88.8,88,95,135,136,138,146,283,289,276,292,289,276,292,null,72,40,6,null,null,null,null,"B1",463,463,463,436,463,463,"#","#","#","#","#","#","#","#","#","#","#","#","#","#","#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-row",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRR",48,67,75.8,88.8,88,87,75.8,88,87,127,135,138,146,146,283,289,276,292,289,276,292,null,84,61,10,null,null,null,null,"B2","#","#","#","#",626,626,680,680,680,680,"#","#","#","#","#","#","#","#","#","#","#"]
["Component","Description","Wi","X","Y","Z","Y/N"," +/- weight",null,null,null,null,null,null,null,"PRO",35,35,35,57,57,57,83,83,83,120,120,145,190,190,340,340,340,340,675,675,750,null,"LCO",null,null,null,null,null,null,40,null,{"$f":"(AT7+AV5)/2","v":64},null,{"$f":"(AT7+AZ6)/2","v":93},127,127,null,null,null,null,null,null,null,null,null,96,61,10,null,null,null,null,"B3","#","#","#","#","#","#","#","#",1050,1050,1050,1050,"#","#","#","#","#","#","#","#","#"]
["Evaporator",{"$f":"IF(F4=\"\",\"\",VLOOKUP($F$4,$Z$15:$AA$17,2,FALSE))","v":"6-Row Evap."},{"$f":"IF($F$4=\"\",\"\",IF($K$4=\"0\",IF(F4=\"A\",IF(G8=\"y\",INDEX(Q3:AK4,MATCH(LEFT(B4,3),P3:P4,0),MATCH(C4,Q2:AK2,0))+H8,\"\"),IF(G8=\"y\",INDEX(Q7:AK9,MATCH(LEFT(B4,3),P7:P9,0),MATCH(C4,Q2:AK2,0))+H8,\"\")),IF(F4=\"A\",IF(G8=\"y\",HLOOKUP(C4,$Q$2:$AK$9,3,FALSE)+H8,\"\"),IF(G8=\"y\",HLOOKUP(C4,$Q$2:$AK$9,7,FALSE)+H8,\"\"))))","v":460},{"$f":"IF($J$4=\"000\",INDEX($Q$16:$S$25,MATCH($D$4,$P$16:$P$25,0),MATCH(D7,$Q$15:$S$15,0)),INDEX($V$16:$X$25,MATCH($D$4,$P$16:$P$25,0),MATCH(D7,$Q$15:$S$15,0)))","v":32},{"$f":"IF($J$4=\"000\",INDEX($Q$16:$S$25,MATCH($D$4,$P$16:$P$25,0),MATCH(E7,$Q$15:$S$15,0)),INDEX($V$16:$X$25,MATCH($D$4,$P$16:$P$25,0),MATCH(E7,$Q$15:$S$15,0)))","v":48},{"$f":"IF($J$4=\"000\",INDEX($Q$16:$S$25,MATCH($D$4,$P$16:$P$25,0),MATCH(F7,$Q$15:$S$15,0)),INDEX($V$16:$X$25,MATCH($D$4,$P$16:$P$25,0),MATCH(F7,$Q$15:$S$15,0)))","v":63},"y",0,null,null,null,null,null,null,null,"PRR",83,83,83,120,120,120,145,145,190,190,190,340,340,340,675,675,675,750,675,675,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,80,12,null,null,null,null,"B4","#","#","#","#","#","#","#","#",987,987,950,"#","#","#","#","#","#","#","#","#","#"]
["Supply Blower",{"$f":"IF(RIGHT($I$4,1)=\"M\",\"ECM\",VLOOKUP(LEFT(I4,2),Z27:AB80,2,FALSE)&\" inch FAN\"&\"; \"&VLOOKUP(RIGHT(I4,1),AF27:AH40,2,FALSE)&\"HP\")","v":"18 inch FAN; 5HP"},{"$f":"IF(LEFT(I4,1)=\"E\",VLOOKUP(LEFT(I4,2),Z27:AB80,3,FALSE)+2*VLOOKUP(RIGHT(I4,1),AF27:AH40,3,FALSE),VLOOKUP(LEFT(I4,2),Z27:AB80,3,FALSE)+VLOOKUP(RIGHT(I4,1),AF27:AH40,3,FALSE))","v":146.92000000000002},{"$f":"IF($J$4=\"000\",INDEX($Q$29:$S$38,MATCH($D$4,$P$29:$P$38,0),MATCH(D$7,$Q$28:$S$28,0)),INDEX($V$29:$X$38,MATCH($D$4,$U$29:$U$38,0),MATCH(D$7,$V$28:$X$28,0)))","v":101},{"$f":"IF($J$4=\"000\",INDEX($Q$29:$S$38,MATCH($D$4,$P$29:$P$38,0),MATCH(E$7,$Q$28:$S$28,0)),INDEX($V$29:$X$38,MATCH($D$4,$U$29:$U$38,0),MATCH(E$7,$V$28:$X$28,0)))","v":48},{"$f":"IF($J$4=\"000\",INDEX($Q$29:$S$38,MATCH($D$4,$P$29:$P$38,0),MATCH(F$7,$Q$28:$S$28,0)),INDEX($V$29:$X$38,MATCH($D$4,$U$29:$U$38,0),MATCH(F$7,$V$28:$X$28,0)))","v":46},"y",0,null,null,null,null,null,null,null,"LCO",null,null,null,null,null,null,283,null,283,null,320,460,460,null,null,null,null,null,null,null,null,null,"PRO/PRR",36,48,60,72,84,96,120,150,180,210,240,300,360,420,480,540,600,660,720,780,840,null,150,80,12,null,null,null,null,"C2","#","#","#","#",626,626,700,700,700,700,838,"#","#","#","#","#","#","#","#","#","#"]
["Comp 1",{"$f":"IF($F$4=\"\",\"\",IF($K$4=\"0\",IF(G10=\"y\",INDEX($AN$3:$BH$7,MATCH(LEFT(B4,3),AM3:AM7,0),MATCH(C4,AN2:BH2,0)),\"\"),IF(G10=\"y\",HLOOKUP(C4,$AN$2:$BH$7,3,FALSE),\"\")))","v":127},{"$f":"IF($F$4=\"\",\"\",IF($K$4=\"0\",IF(G10=\"y\",INDEX($AN$5:$BH$7,MATCH(LEFT(B4,3),AM5:AM7,0),MATCH(C4,AN2:BH2,0))+H10,\"\"),IF(G10=\"y\",HLOOKUP(C4,$AN$2:$BH$7,5,FALSE)+H10,\"\")))","v":127},{"$f":"IF($J$4=\"000\",INDEX($Q$68:$S$77,MATCH($D$4,$P$68:$P$77,0),MATCH(D$7,$Q$67:$S$67,0)),INDEX($V$68:$X$77,MATCH($D$4,$U$68:$U$77,0),MATCH(D$7,$V$67:$X$67,0)))","v":97},{"$f":"IF($J$4=\"000\",INDEX($Q$68:$S$77,MATCH($D$4,$P$68:$P$77,0),MATCH(E$7,$Q$67:$S$67,0)),INDEX($V$68:$X$77,MATCH($D$4,$U$68:$U$77,0),MATCH(E$7,$V$67:$X$67,0)))","v":12},{"$f":"IF($J$4=\"000\",INDEX($Q$68:$S$77,MATCH($D$4,$P$68:$P$77,0),MATCH(F$7,$Q$67:$S$67,0)),INDEX($V$68:$X$77,MATCH($D$4,$U$68:$U$77,0),MATCH(F$7,$V$67:$X$67,0)))","v":32},{"$f":"IF(RIGHT(B4,1)=\"F\",\"n\",\"y\")","v":"y"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper Parts",182.4,186.048,189.76895999999999,193.56433920000001,197.43562598400001,201.38433850368003,205.41202527375364,209.52026577922871,213.71067109481328,217.98488451670954,222.34458220704374,231.32730332820833,235.9538493947725,240.67292638266795,245.48638491032131,250.39611260852774,255.40403486069832,260.5121155579123,{"$f":"$BE10*1.15","v":299.58893289159914},{"$f":"$BE10*1.15","v":299.58893289159914},299.58893289159914,null,180,122,20,null,null,null,null,"C3","#","#","#","#","#","#","#","#",1050,1050,1050,1050,"#","#","#","#","#","#","#","#","#"]
["Comp 2",{"$f":"IF($C$4>96,B10,\"\")","v":127},{"$f":"IF($C$4>96,C10,\"\")","v":127},{"$f":"IF($J$4=\"000\",INDEX($Q$81:$S$90,MATCH($D$4,$P$81:$P$90,0),MATCH(D$7,$Q$80:$S$80,0)),INDEX($V$81:$X$90,MATCH($D$4,$U$81:$U$90,0),MATCH(D$7,$V$80:$X$80,0)))","v":113},{"$f":"IF($J$4=\"000\",INDEX($Q$81:$S$90,MATCH($D$4,$P$81:$P$90,0),MATCH(E$7,$Q$80:$S$80,0)),INDEX($V$81:$X$90,MATCH($D$4,$U$81:$U$90,0),MATCH(E$7,$V$80:$X$80,0)))","v":12},{"$f":"IF($J$4=\"000\",INDEX($Q$81:$S$90,MATCH($D$4,$P$81:$P$90,0),MATCH(F$7,$Q$80:$S$80,0)),INDEX($V$81:$X$90,MATCH($D$4,$U$81:$U$90,0),MATCH(F$7,$V$80:$X$80,0)))","v":32},"y",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accum1",11.3,11.3,11.3,14.5,14.5,14.5,11.3,14.5,14.5,14.5,14.5,18,18,18,20.5,20.5,20.5,20.5,{"$f":"$BE11*1.15","v":23.574999999999999},23.574999999999999,23.574999999999999,null,210,144,20,null,null,null,null,"C4","#","#","#","#","#","#","#","#",1114,1114,1114,1114,1114,1114,"#","#","#","#","#","#","#"]
["A/S Condenser Section",null,{"$f":"IF($F$4=\"\",\"\",IF(OR(RIGHT($B$4,1)=\"A\",RIGHT($B$4,1)=\"H\"),IF($G$12=\"y\",INDEX($BR$3:$CL$39,MATCH($B$5,$BQ$3:$BQ$39,0),MATCH($C$4,$BR$2:$CL$2,0))+$H$12,\"\")))","v":1271},{"$f":"IF($J$4=\"000\",INDEX($BK$46:$BM$89,MATCH($B$5,$BJ$46:$BJ$89,0),MATCH(D$7,$BK$45:$BM$45,0)),INDEX($BN$46:$BP$89,MATCH($B$5,$BJ$46:$BJ$89,0),MATCH(D$7,$BN$45:$BP$45,0)))","v":191},{"$f":"IF($J$4=\"000\",INDEX($BK$46:$BM$89,MATCH($B$5,$BJ$46:$BJ$89,0),MATCH(E$7,$BK$45:$BM$45,0)),INDEX($BN$46:$BP$89,MATCH($B$5,$BJ$46:$BJ$89,0),MATCH(E$7,$BN$45:$BP$45,0)))","v":44},{"$f":"IF($J$4=\"000\",INDEX($BK$46:$BM$89,MATCH($B$5,$BJ$46:$BJ$89,0),MATCH(F$7,$BK$45:$BM$45,0)),INDEX($BN$46:$BP$89,MATCH($B$5,$BJ$46:$BJ$89,0),MATCH(F$7,$BN$45:$BP$45,0)))","v":75},"y",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil Sep 1",6,6,6,6,6,6,12,12,12,12,14,14,14,16,16,16,16,16,18.399999999999999,18.399999999999999,18.399999999999999,null,240,160,24,null,null,null,null,"C6","#","#","#","#","#","#","#","#","#","#","#",1316,1316,1316,"#","#","#","#","#","#","#"]
["W/S Condenser",{"$f":"IF(OR(RIGHT($B$4,1)=\"W\",RIGHT($B$4,1)=\"G\"),\"Water Source\",\"\")","v":""},{"$f":"IF($F$4=\"\",\"\",IF(OR(RIGHT($B$4,1)=\"W\",RIGHT($B$4,1)=\"G\"),VLOOKUP($C$4,$BJ$1:$BL$22,2,FALSE)+H13,\"\"))","v":""},{"$f":"IF($J$4=\"000\",INDEX($Q$94:$S$103,MATCH($D$4,$P$94:$P$103,0),MATCH(D$7,$Q$93:$S$93,0)),INDEX($V$94:$X$103,MATCH($D$4,$U$94:$U$103,0),MATCH(D$7,$V$93:$X$93,0)))","v":148},{"$f":"IF($J$4=\"000\",INDEX($Q$94:$S$103,MATCH($D$4,$P$94:$P$103,0),MATCH(E$7,$Q$93:$S$93,0)),INDEX($V$94:$X$103,MATCH($D$4,$U$94:$U$103,0),MATCH(E$7,$V$93:$X$93,0)))","v":44},{"$f":"IF($J$4=\"000\",INDEX($Q$94:$S$103,MATCH($D$4,$P$94:$P$103,0),MATCH(F$7,$Q$93:$S$93,0)),INDEX($V$94:$X$103,MATCH($D$4,$U$94:$U$103,0),MATCH(F$7,$V$93:$X$93,0)))","v":45},"y",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Receiver 1",11.3,11.3,11.3,14.5,14.5,14.5,11.3,14.5,14.5,14.5,14.5,18,18,18,20.5,20.5,20.5,20.5,23.574999999999999,23.574999999999999,23.574999999999999,null,300,216,30,null,null,null,null,"K5","#","#","#","#","#","#","#","#",{"$f":"BZ10-200","v":850},"#","#","#","#","#","#","#","#","#","#","#","#"]
["Copper Parts",null,{"$f":"INDEX($AN$10:$BH$12,MATCH($A14,$AM$10:$AM$12,0),MATCH($C$4,$AN$9:$BH$9,0))","v":235.9538493947725},{"$f":"D10+5","v":102},{"$f":"E10","v":12},{"$f":"F10","v":32},"y",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Pump",10,10,10,10,12,12,20,20,24,24,36,36,36,36,36,36,54,54,62.099999999999994,62.099999999999994,62.099999999999994,null,360,240,36,null,null,null,null,"K4","#","#","#","#","#","#","#","#","#","#",{"$f":"CB11-540","v":574},"#","#","#","#","#","#","#","#","#","#"]
["Accum1",null,{"$f":"IF($C$10=\"\",\"\",IF(OR(LEFT($B$4,3)=\"PRO\",RIGHT($B$4,1)=\"H\"),INDEX($AN$10:$BH$12,MATCH($A15,$AM$10:$AM$12,0),MATCH($C$4,$AN$9:$BH$9,0)),\"\"))","v":""},{"$f":"D10-5","v":92},20,12,"y",0,null,null,null,null,null,null,null,"Evap","x","y","z",null,"Evap","x","y","z",null,"A","4-Row Evap.",null,null,null,null,null,null,null,null,null,null,null,"Elec. Box",150,153,156.06,159.18120000000002,162.36482400000003,165.61212048000004,168.92436288960005,172.30285014739206,175.7489071503399,179.2638852933467,182.84916299921363,190.23626918438188,194.04099456806952,197.92181445943092,201.88025074861955,205.91785576359194,210.03621287886378,214.23693713644107,246.3724777069072,246.3724777069072,246.3724777069072,null,420,240,36,null,null,null,null,"K6","#","#","#","#","#","#","#","#","#","#","#",1316,1316,1316,"#","#","#","#","#","#","#"]
["Accum2",null,{"$f":"IF($C$4>96,C15,\"\")","v":""},{"$f":"IF(C16=\"\",\"-\",D11+5)","v":"-"},20,12,"y",0,null,null,null,null,null,null,null,"A",24,38,40,null,"A",60,38,40,null,"B","6-Row Evap.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,480,288,40,null,null,null,null,"D4","#","#","#","#","#","#","#","#","#","#",1114,1114,1114,1114,1114,"#","#","#","#","#","#"]
["Oil Sep 1",null,{"$f":"IF($C$10=\"\",\"\",IF(OR(LEFT($B$4,3)=\"PRO\",RIGHT($B$4,1)=\"H\"),INDEX($AN$10:$BH$12,MATCH($A17,$AM$10:$AM$12,0),MATCH($C$4,$AN$9:$BH$9,0)),\"\"))","v":""},{"$f":"D10+5","v":102},10,8,"y",0,null,null,null,null,null,null,null,"B",22.5,38,43,null,"B",62,38,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,540,320,48,null,null,null,null,"D6","#","#","#","#","#","#","#","#","#","#","#",1316,1316,1316,1472,"#","#","#","#","#","#"]
["Oil Sep 2",null,{"$f":"IF($C$4>96,C17,\"\")","v":""},{"$f":"IF(C18=\"\",\"-\",D14+5)","v":"-"},10,8,"y",0,null,null,null,null,null,null,null,"C",26,38,43,null,"C",72,38,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,384,56,null,null,null,null,"D8","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#"]
["Elec. Box",null,{"$f":"IF($G$2=\"4\",INDEX($AN$10:$BH$18,MATCH($A19,$AM$10:$AM$18,0),MATCH($C$4,$AN$9:$BH$9,0))*1.2+H19,INDEX($AN$10:$BH$18,MATCH($A19,$AM$10:$AM$18,0),MATCH($C$4,$AN$9:$BH$9,0))*1.2*1.5+H19)","v":349.27379022252512},{"$f":"D10+5","v":102},{"$f":"E10+5","v":17},{"$f":"F9","v":46},"y",0,null,null,null,null,null,null,null,"K",46,38,43,null,"C",92,38,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CWC",36,48,60,72,84,96,120,150,180,210,240,300,360,420,480,540,600,660,720,780,840,null,660,488,80,null,null,null,null,"D9","#","#","#","#","#","#","#","#","#","#","#",{"$f":"CC16+CC16/2-400","v":1271},{"$f":"CD16+CD16/2-400","v":1271},"#","#","#","#","#","#","#","#"]
["Sheet Metal",{"$f":"B5","v":"D9"},{"$f":"IF($J$4=\"000\",H20+INDEX($BT$46:$BV$89,MATCH($B$5,$BS$46:$BS$89,0),MATCH(C$7,$BT$45:$BV$45,0)),INDEX($BW$46:$BY$89,MATCH($B$5,$BS$46:$BS$89,0),MATCH(C$7,$BW$45:$BY$45,0)))","v":1950},{"$f":"IF($J$4=\"000\",INDEX($Q$107:$S$116,MATCH($D$4,$P$107:$P$116,0),MATCH(D$7,$Q$106:$S$106,0)),INDEX($V$107:$X$116,MATCH($D$4,$U$107:$U$116,0),MATCH(D$7,$V$106:$X$106,0)))","v":55},{"$f":"IF($J$4=\"000\",INDEX($Q$107:$S$116,MATCH($D$4,$P$107:$P$116,0),MATCH(E$7,$Q$106:$S$106,0)),INDEX($V$107:$X$116,MATCH($D$4,$U$107:$U$116,0),MATCH(E$7,$V$106:$X$106,0)))","v":44},{"$f":"IF($J$4=\"000\",INDEX($Q$107:$S$116,MATCH($D$4,$P$107:$P$116,0),MATCH(F$7,$Q$106:$S$106,0)),INDEX($V$107:$X$116,MATCH($D$4,$U$107:$U$116,0),MATCH(F$7,$V$106:$X$106,0)))","v":65},"y",0,null,null,null,null,null,null,null,"D",32,48,63,null,"D",100,48,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO",46,46,46,65,65,65,92,92,92,122,122,135,176,176,294,294,294,294,467,467,526,null,720,540,120,null,null,null,null,"E4","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#"]
["ECW Wheel",{"$f":"IF($K$4=\"0\",\"\",\"ECW\"&VLOOKUP($K$4,$AZ$33:$BB$54,2,FALSE))","v":""},{"$f":"IF($K$4=\"0\",\"\",VLOOKUP($K$4,$AZ$33:$BB$54,3,FALSE)+H21)","v":""},{"$f":"IF($K$4=\"0\",0,INDEX($V$55:$X$64,MATCH($D$4,$U$55:$U$64,0),MATCH(D$7,$V$54:$X$54,0)))","v":0},{"$f":"IF($K$4=\"0\",0,INDEX($V$55:$X$64,MATCH($D$4,$U$55:$U$64,0),MATCH(E$7,$V$54:$X$54,0)))","v":0},{"$f":"IF($K$4=\"0\",0,INDEX($V$55:$X$64,MATCH($D$4,$U$55:$U$64,0),MATCH(F$7,$V$54:$X$54,0)))","v":0},"y",0,null,null,null,null,null,null,null,"E",31,55,54,null,"E",125,55,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRR",92,92,92,122,122,122,135,135,176,176,176,294,294,294,467,467,467,526,661,661,746,null,780,600,150,null,null,null,null,"E6","#","#","#","#","#","#","#","#","#","#","#","#","#","#",1754,1754,1754,1754,1754,1754,1754]
["Exhaust Blower",{"$f":"IF(RIGHT($J$4,1)=\"M\",\"ECM\",IF($J$4=\"000\",\"\",VLOOKUP(LEFT(J4,2),AC27:AE80,2,FALSE)&\" inch FAN\"&\"; \"&VLOOKUP(RIGHT(J4,1),AF27:AH40,2,FALSE)&\"HP\"))","v":""},{"$f":"IF($J$4=\"000\",\"\",IF(LEFT(J4,1)=\"E\",VLOOKUP(LEFT(J4,2),AC27:AE80,3,FALSE)+2*VLOOKUP(RIGHT(J4,1),AF27:AH40,3,FALSE),VLOOKUP(LEFT(J4,2),AC27:AE80,3,FALSE)+VLOOKUP(RIGHT(J4,1),AF27:AH40,3,FALSE)))","v":""},{"$f":"IF($J$4=\"000\",\"\",INDEX($V$42:$X$51,MATCH($D$4,$U$42:$U$51,0),MATCH(D$7,$V$41:$X$41,0)))","v":""},{"$f":"IF($J$4=\"000\",\"\",INDEX($V$42:$X$51,MATCH($D$4,$U$42:$U$51,0),MATCH(E$7,$V$41:$X$41,0)))","v":""},{"$f":"IF($J$4=\"000\",\"\",INDEX($V$42:$X$51,MATCH($D$4,$U$42:$U$51,0),MATCH(F$7,$V$41:$X$41,0)))","v":""},"y",0,null,null,null,null,null,null,null,"F",22.5,38,43,null,"F",62,38,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,840,600,150,null,null,null,null,"E8","#","#","#","#","#","#","#","#","#","#","#","#","#","#",2000,2000,2000,2000,2000,2000,2000]
["Receiver 1",null,{"$f":"IF($C$10=\"\",\"\",IF(OR(LEFT($B$4,3)=\"PRO\",RIGHT($B$4,1)=\"H\"),INDEX($AN$10:$BH$18,MATCH($A23,$AM$10:$AM$18,0),MATCH($C$4,$AN$9:$BH$9,0)),\"\"))","v":""},{"$f":"D10+5","v":102},{"$f":"E15-3","v":17},{"$f":"F15-3","v":9},"y",0,null,null,null,null,null,null,null,"G",26,38,43,null,"G",72,38,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-row",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E9","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#"]
["Receiver 2",null,{"$f":"IF($C$4>96,C23,\"\")","v":""},{"$f":"IF(C24=\"\",\"-\",D23+5)","v":"-"},{"$f":"IF(C24=\"\",\"-\",E20+5)","v":"-"},{"$f":"IF(C24=\"\",\"-\",F20+5)","v":"-"},"y",0,null,null,null,null,null,null,null,"H",32,48,63,null,"H",100,48,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO",59,59,59,86,86,86,124,124,124,165,165,182,240,240,408,408,408,408,661,661,746,null,null,null,null,null,null,null,null,"F1",463,463,463,436,463,463,"#","#","#","#","#","#","#","#","#","#","#","#","#","#","#"]
[null,null,null,null,null,null,"n",0,null,null,null,null,null,null,null,"J",60,55,54,null,"J",125,55,54,null,"SUPPLY",null,null,"EXHAUST BWLR",null,null,"S. MOTOR",null,null,null,null,null,null,"PRR",124,124,124,165,165,165,182,182,240,240,240,408,408,408,484,661,661,746,661,661,746,null,null,null,null,null,null,null,null,"F2","#","#","#","#",626,626,680,680,680,680,"#","#","#","#","#","#","#","#","#","#","#"]
["CWC",{"$f":"IF($G$4=\"\",\"\",IF($G$4=\"C\",\"4-Row CWC\",\"6-Row CWC\"))","v":""},{"$f":"IF($G$4=\"\",\"\",IF($K$4=\"0\",IF(G4=\"C\",IF(G26=\"y\",INDEX(AN20:BH21,MATCH(LEFT(B4,3),AM20:AM21,0),MATCH(C4,AN19:BH19,0))+H26,\"\"),IF(G26=\"y\",INDEX(AN24:BH25,MATCH(LEFT(B4,3),AM24:AM25,0),MATCH(C4,AN19:BH19,0))+H26,\"\")),IF(G4=\"C\",IF(G26=\"y\",HLOOKUP(C4,$AN$19:$BH$25,3,FALSE)+H26,\"\"),IF(G26=\"y\",HLOOKUP(C4,$AN$19:$BH$25,7,FALSE)+H26,\"\"))))","v":""},{"$f":"D8","v":32},{"$f":"E8","v":48},{"$f":"F8","v":63},"y",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14-15","TYPE","Wt","32-33","TYPE","Wt","17","HP","Wt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F3","#","#","#","#","#","#","#","#",1050,1050,1050,1050,"#","#","#","#","#","#","#","#","#"]
["HWC",{"$f":"IF($C$27=\"\",\"\",\"2-ROW HWC\")","v":""},{"$f":"IF($D$5=\"F\",IF($K$4=\"0\",IF($G$27=\"y\",INDEX($AN$28:$BH$29,MATCH(LEFT(B4,3),$AM$28:$AM$29,0),MATCH($C$4,$AN$27:$BH$27,0)+$H$27),\"\"),HLOOKUP($C$4,$AN$27:$BE$29,3)),\"\")","v":""},{"$f":"D8-5","v":27},{"$f":"E8","v":48},{"$f":"F8","v":63},"y",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,"HWC",36,48,60,72,84,96,120,150,180,210,240,300,360,420,480,540,600,660,720,780,840,null,null,null,null,null,null,null,null,"F4","#","#","#","#","#","#","#","#",987,987,950,"#","#","#","#","#","#","#","#","#","#"]
["Heat Pump",null,{"$f":"IF($F$4=\"\",\"\",IF(OR(RIGHT($B$4,1)=\"W\",RIGHT($B$4,1)=\"H\"),INDEX($AN$10:$BH$18,MATCH($A28,$AM$10:$AM$18,0),MATCH($C$4,$AN$9:$BH$9,0)),\"\"))","v":""},{"$f":"D14+5","v":107},{"$f":"E14","v":12},{"$f":"F14","v":32},"y",0,null,null,null,null,null,null,null,"Supply","x","y","z",null,"Supply","x","y","z",null,"AA",10,29.040000000000006,"AA",10,29.040000000000006,"A",1,34,null,null,null,null,"PRO",32,32,32,43,43,43,59,59,59,76,76,84,108,108,170,170,170,170,255,255,286,null,null,null,null,null,null,null,null,"G2","#","#","#","#",626,626,700,700,700,700,838,"#","#","#","#","#","#","#","#","#","#"]
["Reheat/SC",{"$f":"IF(C29=\"\",\"\",VLOOKUP($H$4,$E$65:$F$85,2,FALSE))","v":" RH/SC"},{"$f":"IF($H$4=\"00\",\"\",IF($C$8=\"\",\"\",IF(G29=\"y\",IF(OR($H$4=\"am\",$H$4=\"cc\",$H$4=\"ch\",$H$4=\"dc\",$H$4=\"dh\",$H$4=\"cd\"),C8/2,C8/4)+H29,\"NA\")))","v":230},{"$f":"D8+15","v":47},{"$f":"E8","v":48},{"$f":"F8","v":63},"y",0,null,null,null,null,null,null,null,"A",51,38,43,null,"A",87,38,40,null,"AB",11,29.040000000000006,"AB",11,29.040000000000006,"B",1.5,37.5,null,null,null,null,"PRR",59,59,59,76,76,76,84,84,108,108,108,170,170,170,212,255,255,286,661,661,746,null,"SheetMetal Short Weight",null,null,null,null,null,null,"G3","#","#","#","#","#","#","#","#",1050,1050,1050,1050,"#","#","#","#","#","#","#","#","#"]
[null,null,null,null,null,null,"y",0,null,null,null,null,null,null,null,"B",53,38,43,null,"B",95,38,43,null,"AC",12,29.040000000000006,"AC",12,29.040000000000006,"C",2,40,null,null,null,null,"LCO",null,null,null,null,null,null,84,null,109,null,180,220,220,null,null,null,null,null,null,null,null,null,"A",135,3.3,{"$f":"BK30*BL30","v":445.5},null,null,null,"G4","#","#","#","#","#","#","#","#",1114,1114,1114,1114,1114,1114,"#","#","#","#","#","#","#"]
["Sup Damper",null,{"$f":"IF(OR($J$5=\"0\",$J$5=\"X\"),\"\",IF($D$4=\"D\",50,30)+H31)","v":50},3,{"$f":"IF(OR($D$4=\"D\",$D$4=\"E\"),44,32)","v":44},61,"y",0,null,null,null,null,null,null,null,"C",65,38,43,null,"C",110,38,43,null,"AD",14,43.56,"AD",14,43.56,"D",3,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",180,3.8,{"$f":"BK31*BL31","v":684},null,null,null,"G6","#","#","#","#","#","#","#","#","#","#","#",1316,1316,1316,"#","#","#","#","#","#","#"]
["Ret Damp",null,{"$f":"IF(OR($J$5=\"A\",$J$5=\"B\",$J$5=\"C\",$J$5=\"0\",$J$5=\"X\"),\"\",IF($D$4=\"D\",50,30)+H32)","v":""},{"$f":"D21+10","v":10},{"$f":"IF(OR($D$4=\"D\",$D$4=\"E\"),44,32)","v":44},15,"y",0,null,null,null,null,null,null,null,"K",85,38,43,null,"C",130,38,43,null,"AE",16,53.240000000000009,"AE",16,53.240000000000009,"E",5,84,null,null,null,null,"ELEC","kW",null,null,"Furnace",null,null,null,null,null,null,null,null,"ECW",null,null,null,null,null,null,null,null,null,"C",250,4.7,{"$f":"BK32*BL32","v":1175},null,null,null,"H4","#","#","#","#","#","#","#","#","#","#",1114,1114,1114,1114,1316,"#","#","#","#","#","#"]
["Furnace",{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),\"\",IF($H$5=\"00\",\"\",IF(D4=\"e\",VLOOKUP($H$5,$AQ$34:$AS$51,2,FALSE)&\"MBH\",VLOOKUP($H$5,$AQ$34:$AS$43,2,FALSE)&\"MBH\")))","v":""},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),\"\",IF($H$5=\"00\",\"\",IF(D4=\"E\",VLOOKUP($H$5,$AQ$34:$AS$51,3,FALSE)+H33,VLOOKUP($H$5,$AQ$34:$AS$43,3,FALSE))+H33))","v":""},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),\"\",IF($J$4=\"000\",INDEX($Q$120:$S$125,MATCH($D$4,$P$120:$P$125,0),MATCH(D$7,$Q$119:$S$119,0)),INDEX($V$120:$X$125,MATCH($D$4,$U$120:$U$125,0),MATCH(D$7,$V$119:$X$119,0))))","v":101},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),\"\",IF($J$4=\"000\",INDEX($Q$120:$S$125,MATCH($D$4,$P$120:$P$125,0),MATCH(E$7,$Q$119:$S$119,0)),INDEX($V$120:$X$125,MATCH($D$4,$U$120:$U$125,0),MATCH(E$7,$V$119:$X$119,0))))","v":48},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),\"\",IF($J$4=\"000\",INDEX($Q$120:$S$125,MATCH($D$4,$P$120:$P$125,0),MATCH(F$7,$Q$119:$S$119,0)),INDEX($V$120:$X$125,MATCH($D$4,$U$120:$U$125,0),MATCH(F$7,$V$119:$X$119,0))))","v":46},"y",null,null,null,null,null,null,null,null,"D",101,48,46,null,"D",171,48,46,null,"AF",18,62.920000000000009,"AF",18,62.920000000000009,"F",7.5,115,null,null,null,null,0,0,0,null,0,0,0,null,0,0,0,null,null,0,0,0,null,null,null,null,null,null,null,"D",541,3.5,{"$f":"BK33*BL33","v":1893.5},null,null,null,"H6","#","#","#","#","#","#","#","#","#","#","#",1316,1316,1316,1472,1472,1472,1472,"#","#","#"]
["XL Furnace",{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),IF($H$5=\"00\",\"\",VLOOKUP($H$5,$AQ$34:$AS$57,2,FALSE)&\"MBH\"),\"\")","v":""},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),IF($H$5=\"00\",\"\",VLOOKUP($H$5,$AQ$34:$AS$57,3,FALSE)+H35),\"\")","v":""},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),IF($J$4=\"000\",INDEX($Q$126:$S$129,MATCH($D$4,$P$126:$P$129,0),MATCH(D$7,$Q$119:$S$119,0)),INDEX($V$126:$X$129,MATCH($D$4,$U$126:$U$129,0),MATCH(D$7,$V$119:$X$119,0))),\"\")","v":""},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),IF($J$4=\"000\",INDEX($Q$126:$S$129,MATCH($D$4,$P$126:$P$129,0),MATCH(E$7,$Q$119:$S$119,0)),INDEX($V$126:$X$129,MATCH($D$4,$U$126:$U$129,0),MATCH(E$7,$V$119:$X$119,0))),\"\")","v":""},{"$f":"IF(OR($D$4=\"F\",$D$4=\"G\",,$D$4=\"H\",$D$4=\"J\"),IF($J$4=\"000\",INDEX($Q$126:$S$129,MATCH($D$4,$P$126:$P$129,0),MATCH(F$7,$Q$119:$S$119,0)),INDEX($V$126:$X$129,MATCH($D$4,$U$126:$U$129,0),MATCH(F$7,$V$119:$X$119,0))),\"\")","v":""},"y",0,null,null,null,null,null,null,null,"E",100,54,54,null,"E",244,54,54,null,"AG",20,82.280000000000015,"AG",20,82.280000000000015,"G",10,128,null,null,null,null,"A",5,10,null,"A1",75,65,null,"A1","NA",0,null,null,"A",244,70,null,null,null,null,null,null,null,"E",1450,3.5,{"$f":"BK34*BL34","v":5075},null,"232x100x108",null,"H8","#","#","#","#","#","#","#","#","#","#","#","#","#","#",1754,1754,1754,1754,"#","#","#"]
["Elec Heater",{"$f":"IF($F$5=\"0\",\"\",VLOOKUP($F$5,$AM$33:$AO$54,2,FALSE)&\"kW\")","v":""},{"$f":"IF($F$5=\"0\",\"\",VLOOKUP($F$5,$AM$34:$AO$54,3,FALSE)+H35)","v":""},{"$f":"D9","v":101},{"$f":"E9","v":48},{"$f":"F9-20","v":26},"y",0,null,null,null,null,null,null,null,"F",53,38,43,null,"F",95,38,43,null,"AH",22,106.48000000000002,"AH",22,106.48000000000002,"H",15,211,null,null,null,null,"B",10,15,null,"B1",100,75,null,"B1","NA",0,null,null,"B",324,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H9","#","#","#","#","#","#","#","#","#","#","#",{"$f":"CC32+CC32/2-400","v":1271},{"$f":"CD32+CD32/2-400","v":1271},"#","#","#","#","#","#","#","#"]
["Refrigerant",null,{"$f":"IF($F$4=\"\",\"\",$C$4/12*2.5)","v":75},{"$f":"IF($E$4=\"0\",D13-5,D12-10)","v":181},{"$f":"E12","v":44},{"$f":"F12","v":75},null,0,null,null,null,null,null,null,null,"G",65,38,43,null,"G",110,38,43,null,"AJ",25,145.20000000000002,"AJ",25,145.20000000000002,"J",20,425,null,null,null,null,"C",15,20,null,"C1",150,103,null,"C1","NA",0,null,null,"C",364,200,null,null,null,null,null,null,null,"SheetMetal Long Weight",null,null,null,null,null,null,"j4","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#"]
["Condenser Water",null,{"$f":"IF(OR(RIGHT($B$4,1)=\"W\",RIGHT($B$4,1)=\"G\"),VLOOKUP($C$4,$BJ$1:$BL$22,3,FALSE)+H37,\"\")","v":""},{"$f":"D13","v":148},{"$f":"E13","v":44},{"$f":"F13","v":45},null,0,null,null,null,null,null,null,null,"H",101,48,46,null,"H",171,48,46,null,"AK",28,242.00000000000006,"AK",28,242.00000000000006,"K",25,450,null,null,null,null,"D",20,25,null,"D1",200,123,null,"D1","NA",0,null,null,"D",424,210,null,null,null,null,null,null,null,"A",193,3.3,{"$f":"BK37*BL37","v":636.9},null,null,null,"J6","#","#","#","#","#","#","#","#","#","#","#","#","#","#",1754,1754,1754,1754,1754,1754,1754]
["CWC Water/Rfg. ",null,{"$f":"IF(C26=\"\",\"\",VLOOKUP($C$4,$AM$58:$AN$78,2,FALSE)*2)","v":""},{"$f":"D26","v":32},48,63,null,0,null,null,null,null,null,null,null,"J",162,54,54,null,"J",244,54,54,null,"BA",10,29.040000000000006,"BA",10,29.040000000000006,"L",30,500,null,null,null,null,"E",25,30,null,"E1",250,158,null,"E1","NA",0,null,null,"E",484,280,null,null,null,null,null,null,null,"B",241,3.8,{"$f":"BK38*BL38","v":915.8},null,null,null,"J8","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#",2000,2000,2000,2000,2000,2000]
["HWC Water",null,{"$f":"IF(C27=\"\",\"\",VLOOKUP($C$4,$AM$58:$AN$78,2,FALSE))","v":""},27,48,63,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BB",11,29.040000000000006,"BB",11,29.040000000000006,"M","ECM",0,null,null,null,null,"F",30,35,null,"F1",300,179,null,"F1","NA",0,null,null,"F",486,310,null,null,null,null,null,null,null,"C",330,4.7,{"$f":"BK39*BL39","v":1551},null,null,null,"J9","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#","#",2000]
[null,null,null,"X","Y","Z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BC",12,29.040000000000006,"BC",12,29.040000000000006,"X",0,0,null,null,null,null,"G",35,40,null,"G1",350,209,null,"G1","NA",0,null,null,"G",544,330,null,null,null,null,null,null,null,"D",841,3.5,{"$f":"BK40*BL40","v":2943.5}]
["Shipping Unit",null,{"$f":"SUM(C8:C36)*1.03+H41","v":5172.8120688058161},{"$f":"(SUMPRODUCT((C8:C36),(D8:D36))/SUM(C8:C36))-D44","v":97.661035564127602},{"$f":"(SUMPRODUCT((C8:C36),(E8:E36))/SUM(C8:C36))-E44","v":39.6669462791223},{"$f":"(SUMPRODUCT((C8:C36),(F8:F36))/SUM(C8:C36))-F44","v":62.268865826234311},null,0,null,null,null,null,null,null,null,null,null,null,null,null,"Exhaust","x","y","z",null,"BD",14,43.56,"BD",14,43.56,null,null,null,null,null,null,null,"H",40,45,null,"H1",400,222,null,"H1","NA",0,null,null,"H",604,460,null,null,null,null,null,null,null,"E",1800,3.5,{"$f":"BK41*BL41","v":6300},null,"284x100x108"]
["Operating Unit",null,{"$f":"C41+SUM(C37:C39)","v":5172.8120688058161},{"$f":"((SUMPRODUCT((C8:C36),(D8:D36))+SUMPRODUCT((C37:C39),(D37:D39)))/(SUM(C8:C36)+SUM(C37:C39)))-D44","v":97.661035564127602},{"$f":"((SUMPRODUCT((C8:C36),(E8:E36))+SUMPRODUCT((C37:C39),(E37:E39)))/(SUM(C8:C36)+SUM(C37:C39)))-E44","v":39.6669462791223},{"$f":"((SUMPRODUCT((C8:C36),(F8:F36))+SUMPRODUCT((C37:C39),(F37:F39)))/(SUM(C8:C36)+SUM(C37:C39)))-F44","v":62.268865826234311},null,0,null,null,null,null,null,null,null,null,null,null,null,null,"A",15,38,18,null,"BE",16,53.240000000000009,"BE",16,53.240000000000009,null,"FAN","Wt","MTR","Wt",null,null,"J",45,50,null,"J1",500,235,null,"A2",200,0,null,null,"J",606,540]
[null,null,"Length = ",{"$f":"IF($J$4=\"000\",INDEX($BT$46:$BU$89,MATCH($B$5,BS46:BS89,0),MATCH($D$40,$BT$45:$BU$45,0)),INDEX($BW$46:$BX$89,MATCH($B$5,BS46:BS89,0),MATCH($D$40,$BW$45:$BX$45,0)))","v":132},"Width = ",{"$f":"IF($J$4=\"000\",H43+INDEX($BT$46:$BV$89,MATCH($B$5,BS46:BS89,0),MATCH($E$40,$BT$45:$BV$45,0)),INDEX($BW$46:$BY$89,MATCH($B$5,BS46:BS89,0),MATCH($E$40,$BW$45:$BY$45,0)))","v":88},null,0,null,null,null,null,null,null,null,null,null,null,null,null,"B",18,38,20,null,"BF",18,62.920000000000009,"BF",18,62.920000000000009,null,10,6,1,34,null,null,"K",50,55,null,"K1",600,255,null,"B2",400,0,null,null,"K",664,540,null,null,null,null,null,null,null,"Cond. Dims",null,null,null,null,null,null,null,null,"Cabinet Outside Dims"]
["Unit Type","Unit Size","Move XYZ-->",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",17.75,38,20,null,"BG",20,82.280000000000015,"BG",20,82.280000000000015,null,11,6,1.5,37.5,null,null,"L",55,60,null,"A2","2x100",150,null,"C2",500,0,null,null,"L",666,650,null,null,null,null,null,null,null,null,"Short",null,null,"Long",null,null,null,null,null,"Short",null,null,"Long"]
[{"$f":"A6","v":0},{"$f":"B6","v":0},"Move L-->",0,"Move W-->",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",17.75,38,20,null,"BH",22,106.48000000000002,"BH",22,106.48000000000002,null,12,6,2,40,null,null,"M",60,70,null,"B2","2x200",246,null,"D2",600,0,null,null,"M",706,700,null,null,null,null,null,null,null,null,"X","Y","Z","X","Y","Z",null,null,null,"X","Y","Wi","X","Y","Wi"]
["Shipping Corner Weight",null,null,"Operating Corner Weight",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",36,48,25,null,"BJ",25,145.20000000000002,"BJ",25,145.20000000000002,null,14,9,3,69,null,null,"N",70,80,null,"C2","2x250",500,null,"E2",800,0,null,null,"N",724,670,null,null,null,null,null,null,null,"a0",0,0,0,0,0,0,null,null,"a0",65,64,446,100,64,637]
[null,"lbs","(kg)",null,"lbs","(kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",25,60,30,null,"BK",28,242.00000000000006,"BK",28,242.00000000000006,null,16,11,5,84,null,null,"P",80,90,null,"D2","2x300",600,null,"XX",0,0,null,null,"P",726,700,null,null,null,null,null,null,null,"b0",0,0,0,0,0,0,null,null,"b0",76,64,684,114,64,916]
["LF",{"$f":"C41*(D43-D41)/D43*(F43-E41)/F43","v":739.09714759683618},{"$f":"-B48/2.2046","v":-335.25226689505405},"LF",{"$f":"C42*(D43-D42)/D43*(F43-E42)/F43","v":739.09714759683618},{"$f":"-E48/2.2046","v":-335.25226689505405},{"$f":"B48/$C$41","v":0.14288111336073775},null,null,null,null,null,null,null,null,null,null,null,null,null,"F",18,38,20,null,"CA","ECM",242.00000000000006,"CA","ECM",242.00000000000006,null,18,13,7.5,115,null,null,"Q",90,100,null,"E2","2x400",800,null,null,null,null,null,null,"Q",784,720,null,null,null,null,null,null,null,"c0",0,0,0,0,0,0,null,null,"c0",90,64,1175,135,64,1551]
["LB",{"$f":"C41*(D43-D41)/D43*E41/F43","v":606.57716804084919},{"$f":"-B49/2.2046","v":-275.14159849444303},"LB",{"$f":"C42*(D43-D42)/D43*E42/F43","v":606.57716804084919},{"$f":"-E49/2.2046","v":-275.14159849444303},{"$f":"B49/$C$41","v":0.11726255660799258},null,null,null,null,null,null,null,null,null,null,null,null,null,"G",17.75,38,20,null,"CB","ECM",242.00000000000006,"CB","ECM",242.00000000000006,null,20,17,10,128,null,null,"R",100,110,null,"F2","2x350",750,null,null,null,null,null,null,"R",786,880,null,null,null,null,null,null,null,"d0",0,0,0,0,0,0,null,null,"d0",132,88,1950,200,88,2944]
["RF",{"$f":"C41*D41/D43*(F43-E41)/F43","v":2102.0142570576641},{"$f":"-B50/2.2046","v":-953.46741225513199},"RF",{"$f":"C42*D42/D43*(F43-E42)/F43","v":2102.0142570576641},{"$f":"-E50/2.2046","v":-953.46741225513199},{"$f":"B50/$C$41","v":0.40635813346741795},null,null,null,null,null,null,null,null,null,null,null,null,null,"H",36,48,25,null,"CR","ECM",242.00000000000006,"CR","ECM",242.00000000000006,null,22,22,15,211,null,null,"S",110,120,null,"G2","2x150",225,null,null,null,null,null,null,"S",7812,1900,null,null,null,null,null,null,null,"e0",0,0,0,0,0,0,null,null,"e0",150,100,4095,232,100,4950]
["RB",{"$f":"C41*D41/D43*E41/F43","v":1725.1234961104667},{"$f":"-B51/2.2046","v":-782.51088456430489},"RB",{"$f":"C42*D42/D43*E42/F43","v":1725.1234961104667},{"$f":"-E51/2.2046","v":-782.51088456430489},{"$f":"B51/$C$41","v":0.33349819656385177},null,null,null,null,null,null,null,null,null,null,null,null,null,"J",25,60,30,null,"CD","ECM",242.00000000000006,"CD","ECM",242.00000000000006,null,25,30,20,225,null,null,"T",120,130,null,"H2","2x500",1000,null,null,null,null,null,null,"T",844,810,null,null,null,null,null,null,null,"a1",{"$f":"BT51+BQ51","v":81},38,52,{"$f":"BW51+BQ51","v":116},38,52,16,null,"a1",65,64,446,100,64,637,null,{"$f":"BQ51*2","v":32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CE","ECM",242.00000000000006,"CE","ECM",242.00000000000006,null,28,50,25,250,null,null,"U",130,140,null,"A4","4x200",1000,null,null,null,null,null,null,"U",846,1050,null,null,null,null,null,null,null,"a2",{"$f":"BT52+BQ52","v":90},38,52,125,38,52,25,null,"a2",65,64,446,100,64,637,null,{"$f":"BQ52*2","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CF","ECM",242.00000000000006,"CF","ECM",242.00000000000006,null,32,59,30,300,null,null,"V",140,150,null,"B4","4x250",1200,null,null,null,null,null,null,"V",8412,2250,null,null,null,null,null,null,null,"b1",{"$f":"BT53+BQ53","v":92},38,52,130,38,52,16,null,"b1",76,64,684,114,64,916,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECW","X","Y","Z",null,"CG","ECM",242.00000000000006,"CG","ECM",242.00000000000006,null,36,74,"ECM",1,null,null,"W",150,160,null,"C4","4x300",1350,null,null,null,null,null,null,"X",0,0,null,null,null,null,null,null,null,"b2",101,38,52,139,38,52,25,null,"b2",76,64,684,114,64,916,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",31,29,32,null,"CH","ECM",242.00000000000006,"CH","ECM",242.00000000000006,null,40,114,null,null,null,null,"X",0,0,null,"D4","4x350",1450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b3",124,32,52,162,32,52,48,null,"b3",76,64,684,114,64,916,null,96]
[null,{"$f":"B29&\" \"&B8&B26&\" \"&B9&\" \"&B22&\" \"&B21&\" \"&B33&B34&B35&B27&\" \"&VLOOKUP($B$5,$C$65:$D$108,2,FALSE)&\" Cab\"","v":" RH/SC 6-Row Evap. 18 inch FAN; 5HP    D6 Cab"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",34,33,32,null,"CJ","ECM",242.00000000000006,"CJ","ECM",242.00000000000006,null,null,null,null,null,null,null,null,null,null,null,"E4","4x400",1600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b4",112,32,75,150,32,75,36,null,"b4",76,64,684,114,64,916,null,72]
[null,{"$f":"B4","v":"LCOA"},"Shipping Weight","Operating Weight","Center of Gravity ",null,null,"Corner Weights",null,null,null,null,null,null,null,null,null,null,null,null,"C",40,33,33,null,"CK","ECM",242.00000000000006,"CK","ECM",242.00000000000006,null,null,null,null,null,null,null,"HWC H2O",null,null,null,"J2","2x600",1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c2",109,38,60,154,38,60,19,null,"c2",90,64,1175,135,64,1551,null,38]
[null,null,"lbs (kg)","lbs (kg)","X","Y","Z","LF","LB","RF","RB",null,null,null,null,null,null,null,null,null,"K",40,33,33,null,"CL","ECM",242.00000000000006,"CL","ECM",242.00000000000006,null,null,null,null,null,null,null,36,19.28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c3",138,32,60,183,32,60,48,null,"c3",90,64,1175,135,64,1551,null,96]
[null,{"$f":"IF(C4>96,C4,\"0\"&C4)","v":360},{"$f":"MROUND(C41,10)","v":5170},{"$f":"MROUND(C42,10)","v":5170},{"$f":"D41","v":97.661035564127602},{"$f":"E41","v":39.6669462791223},{"$f":"F41","v":62.268865826234311},{"$f":"MROUND(E48,10)","v":740},{"$f":"MROUND(E49,10)","v":610},{"$f":"MROUND(E50,10)","v":2100},{"$f":"MROUND(E51,10)","v":1730},{"$f":"SUM(H59:K59)","v":5180},null,null,null,null,null,null,null,null,"D",60,44,45,null,"CM","ECM",242.00000000000006,"CM","ECM",242.00000000000006,null,null,null,null,null,null,null,48,19.28,null,null,"A1 = 75 MBH ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c4",126,32,75,171,32,75,36,null,"c4",90,64,1175,135,64,1551,null,72]
[null,null,{"$f":"C59*0.453*-1","v":-2342.0100000000002},{"$f":"-D59*0.453","v":-2342.0100000000002},{"$f":"-E59*25.4","v":-2480.5903033288409},{"$f":"-F59*25.4","v":-1007.5404354897064},{"$f":"-G59*25.4","v":-1581.6291919863513},{"$f":"-H59*0.453","v":-335.22},{"$f":"-I59*0.453","v":-276.33},{"$f":"-J59*0.453","v":-951.30000000000007},{"$f":"-K59*0.453","v":-783.69},null,null,null,null,null,null,null,null,null,"E",75,60,54,null,"CN","ECM",242.00000000000006,"CN","ECM",242.00000000000006,null,null,null,null,null,null,null,60,19.28,null,null,"B1 = 100 MBH ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c6",139,32,75,184,32,75,49,null,"c6",90,64,1175,135,64,1551,null,98]
[null,"* Corner weights along the main cabinet.",null,null,null,{"$f":"\"Approx. Main Cabinet LXW:\"&\" \"&CEILING(D43,5)&\" X \"&F43","v":"Approx. Main Cabinet LXW: 135 X 88"},null,null,null,null,{"$f":"TODAY()","v":"2017-07-07"},null,null,null,null,null,null,null,null,null,"F",34,33,32,null,"CP","ECM",242.00000000000006,"CP","ECM",242.00000000000006,null,null,null,null,null,null,null,72,22.76,null,null,"C1 = 150 MBH ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k5",{"$f":"BT61+BQ61","v":146},32,75,{"$f":"BW61+BQ61","v":189},32,75,36,null,"k5",110,64,1375,{"$f":"BW58+18","v":153},64,1775,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G",40,33,33,null,"CQ","ECM",242.00000000000006,"CQ","ECM",242.00000000000006,null,null,null,null,null,null,null,84,26,null,null,"D1 = 200 MBH ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k4",{"$f":"BT62+BQ62","v":146},32,75,{"$f":"BW62+BQ62","v":189},32,75,36,null,"k4",110,64,1375,153,64,1775,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",60,44,45,null,"DA","Dual ECM",484.00000000000011,"DA","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,96,30.44,null,null,"E1 = 250 MBH ",null,null,null,null,null,null,null,null,"0= None",null,null,null,null,null,null,null,null,null,"k6",{"$f":"BT63+BQ63","v":159},32,75,{"$f":"BW62+BQ62","v":189},32,75,49,null,"k6",110,64,1375,153,64,1775,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",75,60,54,null,"DB","Dual ECM",484.00000000000011,"DB","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,120,31.88,null,null,"F1 = 300 MBH ",null,null,null,null,null,null,null,null,"A= ECW 244 w/2\" filters",null,null,null,null,null,null,null,null,null,"d4",168,44,75,{"$f":"BW64+BQ64","v":236},44,75,36,null,"d4",132,88,1950,200,88,2944,null,72]
[null,null,"A0","A0","AL"," RHX1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC","Dual ECM",484.00000000000011,"DC","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,150,36.92,null,null,"G1 = 350 MBH ",null,null,null,null,null,null,null,null,"B= ECW 324 w/2\" filters",null,null,null,null,null,null,null,null,null,"d6",181,44,75,{"$f":"BW65+BQ65","v":249},44,75,49,null,"d6",132,88,1950,200,88,2944,null,98]
[null,null,"B0","B0","AM"," RHx2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD","Dual ECM",484.00000000000011,"DD","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,180,48.52,null,null,"H1 = 400 MBH ",null,null,null,null,null,null,null,null,"C= ECW 364 w/2\" filters",null,null,null,null,null,null,null,null,null,"d8",191,44,75,{"$f":"BW66+BQ66","v":259},44,75,59,null,"d8",132,88,1950,200,88,2944,null,118]
[null,null,"C0","C0","AN"," SCx1",null,null,null,null,null,null,null,null,null,"Comp1","X","Y","Z",null,"Comp1","X","Y","Z",null,"DE","Dual ECM",484.00000000000011,"DE","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,210,52.28,null,null,"J1 = 500 MBH",null,null,null,null,null,null,null,null,"D= ECW 424 w/2\" filters",null,null,null,null,null,null,null,null,null,"d9",191,44,75,{"$f":"BW67+BQ67","v":259},44,75,59,null,"d9",132,88,1950,200,88,2944,null,118]
[null,null,"D0","D0","BC"," RHx1",null,null,null,null,null,null,null,null,null,"A",52,9,17,null,"A",88,9,17,null,"DF","Dual ECM",484.00000000000011,"DF","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,240,57.48,null,null,"K1 = 600 MBH",null,null,null,null,null,null,null,null,"E= ECW 484 w/2\" filters",null,null,null,null,null,null,null,null,null,"e6",199,"50","90",{"$f":"BW68+BQ68","v":281},50,90,49,null,"e6",150,100,5000,232,100,6300,null,98]
[null,null,"E0","E0","BD"," SCx1",null,null,null,null,null,null,null,null,null,"B",53,9.5,17,null,"B",91,9,17,null,"DG","Dual ECM",484.00000000000011,"DG","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,300,76.56,null,null,"A2 = 100+100 MBH",null,null,null,null,null,null,null,null,"F= ECW 486 w/2\" filters",null,null,null,null,null,null,null,null,null,"e8",209,"50","90",291,50,90,59,null,"e8",150,100,5000,232,100,6300,null,118]
[null,null,"A1","A1","BG"," RHx1",null,null,null,null,null,null,null,null,null,"C",65,9,17,null,"C",104,9,17,null,"DH","Dual ECM",484.00000000000011,"DH","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,360,76.56,null,null,"G2 = 150+150 MBH",null,null,null,null,null,null,null,null,"G= ECW 544 w/2\" filters",null,null,null,null,null,null,null,null,null,"e9",209,"50","90",{"$f":"BW70+BQ70","v":291},50,90,59,null,"e9",150,100,"#",232,100,"#",null,118]
[null,null,"A2","A2","BH"," SCx1",null,null,null,null,null,null,null,null,null,"K",85,9,17,null,"C",124,9,17,null,"DK","Dual ECM",484.00000000000011,"DK","Dual ECM",484.00000000000011,null,null,null,null,null,null,null,420,81.760000000000005,null,null,"B2 = 200+200 MBH",null,null,null,null,null,null,null,null,"H= ECW 604 w/2\" filters",null,null,null,null,null,null,null,null,null,"f1",126,38,52,{"$f":"BW71+BQ71","v":163},38,52,16,null,"f1",110,64,958,147,64,1190,null,32]
[null,null,"B1","B1","CC"," RHx2",null,null,null,null,null,null,null,null,null,"D",97,12,32,null,"D",164,12,32,null,"EA","2x14\"",39.6,"EA","2x14\"",87.12,null,null,null,null,null,null,null,480,91,null,null,"C2 = 250+250 MBH",null,null,null,null,null,null,null,null,"J= ECW 606 w/2\" filters",null,null,null,null,null,null,null,null,null,"f2",135,38,52,172,38,52,25,null,"f2",110,64,958,147,64,1190,null,50]
[null,null,"B2","B2","CD"," SCx1",null,null,null,null,null,null,null,null,null,"E",93,40,32,null,"E",185,20,32,null,"EB","2x14\"",39.6,"EB","2x14\"",87.12,null,null,null,null,null,null,null,540,101,null,null,"D2 = 300+300 MBH",null,null,null,null,null,null,null,null,"K= ECW 664 w/2\" filters",null,null,null,null,null,null,null,null,null,"f3",158,32,52,195,32,52,48,null,"f3",110,64,958,147,64,1190,null,96]
[null,null,"B3","B3","CH"," RHx2",null,null,null,null,null,null,null,null,null,"F",53,9.5,17,null,"F",91,9,17,null,"EC","2x16\"",48.400000000000006,"EC","2x16\"",106.48000000000002,null,null,null,null,null,null,null,600,111,null,null,"F2 = 350+350 MBH",null,null,null,null,null,null,null,null,"L= ECW 666 w/2\" filters",null,null,null,null,null,null,null,null,null,"f4",146,32,75,183,32,75,36,null,"f4",110,64,958,147,64,1190,null,72]
[null,null,"B4","B4","CJ"," SCx1",null,null,null,null,null,null,null,null,null,"G",65,9,17,null,"G",104,9,17,null,"ED","2x16\"",48.400000000000006,"ED","2x16\"",106.48000000000002,null,null,null,null,null,null,null,660,121,null,null,"E2 = 400+400 MBH",null,null,null,null,null,null,null,null,"M= ECW 706 w/2\" filters",null,null,null,null,null,null,null,null,null,"g2",161,38,60,206,38,60,19,null,"g2",142,64,1582,187,64,1958,null,38]
[null,null,"C2","C2","DA"," SCx1",null,null,null,null,null,null,null,null,null,"H",97,12,32,null,"H",164,12,32,null,"EE","2x18\"",57.2,"EE","2x18\"",125.84000000000002,null,null,null,null,null,null,null,720,{"$f":"4057*0.04","v":162.28},null,null,"H2 = 500+500MBH",null,null,null,null,null,null,null,null,"N= ECW 724 w/2\" filters",null,null,null,null,null,null,null,null,null,"g3",190,32,60,235,32,60,48,null,"g3",142,64,1582,187,64,1958,null,96]
[null,null,"C3","C3","DB"," SCx1",null,null,null,null,null,null,null,null,null,"J",100,20,32,null,"J",185,20,32,null,"EF","2x18\"",57.2,"EF","2x18\"",125.84000000000002,null,null,null,null,null,null,null,780,162,null,null,"J2 = 600+600MBH",null,null,null,null,null,null,null,null,"P= ECW 702 w/2\" filters",null,null,null,null,null,null,null,null,null,"g4",178,32,75,223,32,75,36,null,"g4",142,64,1582,187,64,1958,null,72]
[null,null,"C4","C4","DC"," RH/SC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EG","2x20\"",74.800000000000011,"EG","2x20\"",164.56000000000003,null,null,null,null,null,null,null,840,162,null,null,"A4 = (4) 200 MBH",null,null,null,null,null,null,null,null,"Q= ECW 784 w/2\" filters",null,null,null,null,null,null,null,null,null,"g6",191,32,75,236,32,75,49,null,"g6",142,64,1582,187,64,1958,null,98]
[null,null,"C6","C6","DD"," SCx1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EH","2x20\"",74.800000000000011,"EH","2x20\"",164.56000000000003,null,null,null,null,null,null,null,null,null,null,null,"B4 = (4) 250 MBH",null,null,null,null,null,null,null,null,"R= ECW 786 w/2\" filters",null,null,null,null,null,null,null,null,null,"h4",238,44,75,305,44,75,36,null,"h4",202,88,3017,269,88,4067,null,72]
[null,null,"K5","C+2OS","DE"," SCx1",null,null,null,null,null,null,null,null,null,"Comp2","X","Y","Z",null,"Comp2","X","Y","Z",null,"XX",0,0,"XX",0,0,null,null,null,null,null,null,null,null,null,null,null,"C4 = (4) 300 MBH",null,null,null,null,null,null,null,null,"S= ECW 7812 w/2\" filters",null,null,null,null,null,null,null,null,null,"h6",251,44,75,318,44,75,49,null,"h6",202,88,3017,269,88,4067,null,98]
[null,null,"K4","C+4","DF"," SCx1",null,null,null,null,null,null,null,null,null,"A",0,0,0,null,"A",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D4 = (4) 350 MBH",null,null,null,null,null,null,null,null,"T= ECW 844 w/2\" filters",null,null,null,null,null,null,null,null,null,"h8",261,44,75,328,44,75,59,null,"h8",202,88,3017,269,88,4067,null,118]
[null,null,"K6","C+6","DG"," SCx1",null,null,null,null,null,null,null,null,null,"B",63,9.5,17,null,"B",101,9,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E4 = (4) 400 MBH",null,null,null,null,null,null,null,null,"U= ECW 846 w/2\" filters",null,null,null,null,null,null,null,null,null,"h9",261,44,75,{"$f":"BW82+BQ82","v":328},44,75,59,null,"h9",202,88,3017,269,88,4067,null,118]
[null,null,"D4","D4","DH"," RH/SC",null,null,null,null,null,null,null,null,null,"C",78,9,17,null,"C",120,9,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V= ECW 8412 w/2\" filters",null,null,null,null,null,null,null,null,null,"j6",250,"50","90",{"$f":"BW83+BQ83","v":333},50,90,49,null,"j6",201,100,5000,284,100,6300,null,98]
[null,null,"D6","D6","DJ"," SCx1",null,null,null,null,null,null,null,null,null,"K",98,9,17,null,"C",140,9,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X= Applied Special",null,null,null,null,null,null,null,null,null,"j8",260,"50","90",{"$f":"BW84+BQ84","v":343},50,90,59,null,"j8",201,100,5000,284,100,6300,null,118]
[null,null,"D8","D8","DK"," SCx1",null,null,null,null,null,null,null,null,null,"D",113,12,32,null,"D",180,12,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"j9",260,"50","90",{"$f":"BW85+BQ85","v":343},50,90,59,null,"j9",201,100,5150,284,100,6450,null,118]
[null,null,"D9","D6",null,null,null,null,null,null,null,null,null,null,null,"E",130,40,32,null,"E",185,20,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F0",0,0,0,0,0,0,null,null,"F0",110,64,958,147,64,1190]
[null,null,"E6","E6",null,null,null,null,null,null,null,null,null,null,null,"F",{"$f":"Q82+12","v":75},9.5,17,null,"F",{"$f":"V82+12","v":113},9,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G0",0,0,0,0,0,0,null,null,"G0",142,64,1582,187,64,1958]
[null,null,"E8","E8",null,null,null,null,null,null,null,null,null,null,null,"G",{"$f":"Q83+18","v":96},9,17,null,"G",{"$f":"V83+18","v":138},9,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H0",0,0,0,0,0,0,null,null,"H0",202,88,3017,269,88,4067]
[null,null,"E9","E6",null,null,null,null,null,null,null,null,null,null,null,"H",{"$f":"Q85+24","v":137},12,32,null,"H",{"$f":"V85+24","v":204},12,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J0",0,0,0,0,0,0,null,null,"J0",201,100,5000,284,100,6300]
[null,null,"F1"," B1XL ",null,null,null,null,null,null,null,null,null,null,null,"J",180,20,32,null,"J",260,20,32]
[null,null,"F2"," B2XL "]
[null,null,"F3"," B3XL "]
[null,null,"F4"," B4XL ",null,null,null,null,null,null,null,null,null,null,null,"WC","X","Y","Z",null,"WC","X","Y","Z"]
[null,null,"G2","C2XL",null,null,null,null,null,null,null,null,null,null,null,"A",70,14,35,null,"A",105,14,37]
[null,null,"G3","C3XL",null,null,null,null,null,null,null,null,null,null,null,"B",82,13,43,null,"B",119,13,43]
[null,null,"G4","C4XL",null,null,null,null,null,null,null,null,null,null,null,"C",96.25,21.5,44.5,null,"C",140.5,21,45]
[null,null,"G6","C6XL",null,null,null,null,null,null,null,null,null,null,null,"K",106.25,21.5,44.5,null,"C",161,21,45]
[null,null,"H4"," D4XL ",null,null,null,null,null,null,null,null,null,null,null,"D",148,44,45,null,"D",215,44,45]
[null,null,"H6"," D6XL ",null,null,null,null,null,null,null,null,null,null,null,"E",182,64,45,null,"E",268,64,45]
[null,null,"H8"," D8XL ",null,null,null,null,null,null,null,null,null,null,null,"F",{"$f":"Q94+34","v":104},13,43,null,"F",{"$f":"V95+34","v":153},13,43]
[null,null,"H9","D6XL",null,null,null,null,null,null,null,null,null,null,null,"G",{"$f":"Q96+52","v":148.25},21.5,44.5,null,"G",{"$f":"V96+52","v":192.5},21,45]
[null,null,"J6"," E6XL ",null,null,null,null,null,null,null,null,null,null,null,"H",{"$f":"Q98+60","v":208},44,45,null,"H",{"$f":"V98+60","v":275},44,45]
[null,null,"J8"," E8XL ",null,null,null,null,null,null,null,null,null,null,null,"J",240,64,45,null,"J",320,64,45]
[null,null,"J9","E6XL"]
[null,null,"F0","BXL "]
[null,null,"G0","CXL",null,null,null,null,null,null,null,null,null,null,null,"SheetMetal Short","X","Y","Z",null,"SheetMetal Long","X","Y","Z"]
[null,null,"H0","DXL ",null,null,null,null,null,null,null,null,null,null,null,"A",36,32,45,null,"A",60,32,45]
[null,null,"J0","EXL",null,null,null,null,null,null,null,null,null,null,null,"B",38,32,45,null,"B",70,32,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",38,32,45,null,"C",80,32,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",58,32,45,null,"C",100,32,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",55,44,65,null,"D",118,44,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",75,65,77,null,"E",100,65,77,null,null,null,"XL Dims from DAVE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",55,32,45,null,"F",87,32,45,null,null,null,"XL Furnace","X","Y","Z",null,"LBS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G",64,32,45,null,"G",106,32,45,null,null,null,"A","#","#","#",null,"#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",86,44,45,null,"H",153,44,45,null,null,null,"B",35,64,64,3.3,{"$f":"AC115*AD115*AE115/1728*AF115","v":273.77777777777777}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",102,65,77,null,"J",160,65,77,null,null,null,"C",52,64,64,3.3,{"$f":"AC116*AD116*AE116/1728*AF116","v":406.75555555555553}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",68.5,88,92,3.5,{"$f":"AC117*AD117*AE117/1728*AF117","v":1123.273148148148}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",72,100,108,3.5,{"$f":"AC118*AD118*AE118/1728*AF118","v":1575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Furnace Short","X","Y","Z",null,"Furnace Long","X","Y","Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",51,45,43,null,"A",87,45,40]
[null,null,null,null,1,2,3,null,null,null,null,null,null,null,null,"B",53,45,43,null,"B",95,45,43]
[null,null,null,null,null,"X","Y",null,null,null,null,null,null,null,null,"C",65,45,43,null,"C",110,45,43]
[null,null,null,null,"a0",0,0,null,null,null,null,null,null,null,null,"K",85,45,43,null,"C",130,45,43]
[null,null,null,null,"b0",0,0,null,null,null,null,null,null,null,null,"D",101,48,46,null,"D",171,48,46]
[null,null,null,null,"c0",0,0,null,null,null,null,null,null,null,null,"E",100,25,54,null,"E",185,58,54]
[null,null,null,null,"d0",0,0,null,null,null,null,null,null,null,null,"F",{"$f":"Q120+AC115/2","v":68.5},45,45,null,"F",{"$f":"V121+AC115/2","v":112.5},45,45]
[null,null,null,null,"e0",0,0,null,null,null,null,null,null,null,null,"G",{"$f":"Q121+AC116/2","v":79},45,45,null,"G",{"$f":"V122+AC116/2","v":136},45,45]
[null,null,null,null,"a1",32,"64",null,null,null,null,null,null,null,null,"H",{"$f":"Q122+AC117/2","v":99.25},55,45,null,"H",{"$f":"V124+AC117/2","v":205.25},55,45]
[null,null,null,null,"a2",50,"64",null,null,null,null,null,null,null,null,"J",163,55,54,null,"J",245,55,54]
[null,null,null,null,"b1",32,"64"]
[null,null,null,null,"b2",50,"64"]
[null,null,null,null,"b3",96,64]
[null,null,null,null,"b4",72,64]
[null,null,null,null,"c2",38,"64"]
[null,null,null,null,"c3",96,64]
[null,null,null,null,"c4",72,"88"]
[null,null,null,null,"c6",98,"88"]
[null,null,null,null,"k5",72,"88"]
[null,null,null,null,"k4",72,"88"]
[null,null,null,null,"k6",98,"88"]
[null,null,null,null,"d4",72,88]
[null,null,null,null,"d6",98,88]
[null,null,null,null,"d8",118,88]
[null,null,null,null,"d9",118,88]
[null,null,null,null,"e6",98,100]
[null,null,null,null,"e8",118,100]
[null,null,null,null,"e9",118,100]
[null,null,null,null,"f1",32,"64"]
[null,null,null,null,"f2",50,"64"]
[null,null,null,null,"f3",96,64]
[null,null,null,null,"f4",72,64]
[null,null,null,null,"g2",38,"64"]
[null,null,null,null,"g3",96,64]
[null,null,null,null,"g4",72,"88"]
[null,null,null,null,"g6",98,"88"]
[null,null,null,null,"h4",72,88]
[null,null,null,null,"h6",98,88]
[null,null,null,null,"h8",118,88]
[null,null,null,null,"h9",118,88]
[null,null,null,null,"j6",98,100]
[null,null,null,null,"j8",118,100]
[null,null,null,null,"j9",118,100]
[null,null,null,null,"F0",0,0]
[null,null,null,null,"G0",0,0]
[null,null,null,null,"H0",0,0]
[null,null,null,null,"J0",0,0]

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instructions","index":6,"n_rows":81,"n_cols":1,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
["1. Get codestring from YOUR ACE PROJECT Schedule OR PRICING SCREEN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2. Double click the yellow cell."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. Paste codestring and press ENTER"]