{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Request","Data","Lists","Nomenclature"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":106,"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":"Request","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,4,0,5],[1,4,1,5],[2,4,2,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[9,3,9,5],[8,3,8,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5]]}
[null,null,"Rep Name:","Job Name:"]
[null,null,"Rep Firm Name:  ","Quote Number:"]
["   Add Quantity, then select the drop-down arrow in \"B4\" and work your way left to right --------->",null,null,"Date:"]
["Quantity","Model","Unit","Nominal CFM","Coils","Motor","Handing","Valve Package","Control Options"]
[null,"--Please Select Model Type--","--Please Select Unit Type--","--Please Select Nominal CFM--","--Please Select Coil Type--","--Please Select Motor Type--","--Please Select Handing--","--Please Select Valve Package--","--Please Select Control Option--"]
[null,null,"--Prior to selecting Electric Heat kW the Unit Size and Motor Type must be selected--",null,"--Please Select Coil Position 2, Belt Drive Double Wall H Air Handler Only--"]
[]
["Press the \"Paste Next Selection\" button when you have completed the selection in Row 4 "]
["Line Item","Qty","Nomenclature","Optional Pricing Items and Notes"]
["Current Selection",{"$f":"A5","v":0},{"$f":"Nomenclature!B5","v":""},"Please add any items needed that are not included in the items above, such as filters or expedited ship dates (how fast is it needed)."]
[1,0,""]
[2,0,""]
[3,0,""]
[4,0,""]
[5,0,""]
[6,0,""]
[7,0,""]
[8,0,""]
[9,0,""]
[10,0,""]
["Total",{"$f":"SUM(B11,B12,B13,B14,B15,B16,B17,B18,B19,B20)","v":0}]

{"sheet":"Data","index":1,"n_rows":103,"n_cols":13,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,"--Please Select Model Type--","--Please Select Unit Type--","--Please Select Nominal CFM--","--Please Select Coil Type--","--Please Select Motor Type--","--Please Select Handing--","--Please Select Valve Package--","--Please Select Control Option--","--Please Select Electric Heat kW--"]
[null,null,null,"Ceiling Fan Coils (300-1200 CFM)","WHBC (Concealed)",300,"2-Pipe, 3 Row Coil CW/HW","120/1/60","Right Hand (RH) Coil Connection Side","NV  -  2P/4P, NO VALVES","NC  -  NO CONTROL","0 kW"]
[null,null,null,"Ceiling Fan Coils (1200-2000 CFM)","WPHBC (RA Plenum)",400,"2-Pipe, 4 Row Coil CW/HW","240/1/60 ","Left Hand (LH) Coil Connection Side","BV  -  2P/4P, BALL VALVES ONLY","A1  -  2P, H-O-C, UNIT, MANUAL","1 kW"]
[null,null,null,"Floor / Wall Fan Coils","WRHBC (Recessed, Telescoping Panel)",600,"4-Pipe, Preheat, 1HW/3CW Row Coil","220/1/50 ",null,"2  -  2P/4P, 2WAY VALVE","A2  -  2P, H-O-C, WALL, MANUAL","2 kW"]
[null,null,null,"Direct Drive Wall/Closet Air Handlers (400-1200 CFM)","WCHBC (Cabinet Exposed)",800,"4-Pipe, Reheat, 3CW/1HW Row Coil","277/1/60",null,"3  -  2P/4P, 3WAY VALVE","A3  -  2P, H-O-C, TP, MANUAL","3 kW"]
[null,null,null,"Direct Drive Multi-Position Air Handlers (600-2000 CFM)","WHH (Concealed, Electric Heat)",1000,"4-Pipe, Preheat, 1HW/4CW Row Coil","120/1/60 ECM",null,"2B  -  2P/4P, 2WAY, BVALVES","B1  -  2P, ON-OFF, UNIT, AUTO, W/A.STAT","4 kW"]
[null,null,null,"Variable Speed Multi-Position Air Handlers (600-2000 CFM)","WPHH (RA Plenum, Electric Heat)",1200,"4-Pipe, Reheat, 4CW/1HW Row Coil",null,null,"2C  -  2P/4P, 2WAY, BVALVE & CIRCUIT SETTER","B2  -  2P, ON-OFF,WALL,AUTO,W/A.STAT","--Please Select Electric Heat kW--"]
[null,null,null,"Belt Drive Single Wall H/V Air Handler","WCHH (Cabinet Exposed, Electric Heat)","--Please Select Nominal CFM--","4-Pipe, Reheat, 3CW/2HW Row Coil","--Please Select Motor Type--",null,"3B  -  2P/4P, 3WAY, BVALVES","B3  -  2P, ON-OFF,TP,AUTO,W/A.STAT","0 kW"]
[null,null,null,"Belt Drive Double Wall H Air Handler","WRHH (Recessed, Telescoping Panel, Electric Heat)",1200,"4-Pipe, Preheat, 2HW/3CW Row Coil","120/1/60",null,"3C  -  2P/4P, 3WAY, BVALVE & CIRCUIT SETTER","C1  -  2P, ON-OFF,UNIT,AUTO","2 kW"]
[null,null,null,null,"--Please Select Unit Type--",1600,"4-Pipe, Reheat, 4CW/2HW Row Coil","277/1/60",null,"3D  -  2P, 3WAY, BVALVES, W/A.STAT","C2  -  2P, ON-OFF,WALL,AUTO","3 kW"]
[null,null,null,null,"WVSB (Cabinet Exposed, Slope Top)",2000,"4-Pipe, Preheat, 2HW/4CW Row Coil","120/1/60 ECM ",null,"--Please Select Valve Package--","C3  -  2P, ON-OFF,TP,AUTO","4 kW"]
[null,null,null,null,"WVFB (Cabinet Exposed, Flat Top)","--Please Select Nominal CFM--","2-Pipe, 6 Row Coil CW/HW","--Please Select Motor Type--",null,"2P, 2 HAND VALVES","D1  -  2PCO, ON-OFF, UNIT","5 kW"]
[null,null,null,null,"WVCB (Concealed)",400,"--Please Select Coil Type--","240/1/60 ECM",null,"2P, 1 HAND VALVE & CIRCUIT SETTER","D2  -  2PCO. ON-OFF WALL","6 kW"]
[null,null,null,null,"WWCB (Recessed)",600,"2-Pipe, 4 Row Coil CW/HW","240/1/60 ",null,"2P, 2 WAY, 2 HAND VALVES","D3  -  2PCO, ON-OFF, TAMPER PROOF","--Please Select Electric Heat kW--"]
[null,null,null,null,"--Please Select Unit Type--",800,"--Please Select Coil Type--","--Please Select Motor Type--",null,"2P, 2 WAY, 1 HAND VALVE & CIRCUIT SETTER","E1  -  2PHO, ON-OFF, UNIT","0 kW"]
[null,null,null,null,"WHYB (Lo-Boy Hydronic)",1000,"2-Pipe, 4 Row Coil CW/Electric Heat","120/1/60",null,"2P, 3 WAY, 2 HAND VALVES ","E2  -  2PHO, ON-OFF WALL","3 kW"]
[null,null,null,null,"WPHYB (Lo-Boy Hydronic, RA Plenum)",1200,"--Please Select Coil Type--","--Please Select Motor Type--",null,"2P, 3 WAY, 2 HAND VALVES w/A.STAT","E3  -  2PHO, ON-OFF, TAMPER PROOF","4 kW"]
[null,null,null,null,"--Please Select Unit Type--","--Please Select Nominal CFM--","4-Pipe, Reheat, 4CW/2HW Row Coil","240/1/60",null,"2P, 3 WAY, 1 HAND VALVE & CIRCUIT SETTER","M1  -  4P, H-O-C, UNIT, MANUAL","5 kW"]
[null,null,null,null,"WCW (Closet or Recessed, 2-PIPE ONLY)",800,"4-Pipe, Reheat, 4CW/3HW Row Coil","277/1/60",null,"2P, 3 WAY, 3 HAND VALVES","M2  -  4P, H-O-C, WALL, MANUAL","6 kW"]
[null,null,null,null,"WCW-HW (Closet or Recessed, 4-PIPE ONLY)",1200,"4-Pipe, Reheat, 4CW/4HW Row Coil","--Please Select Motor Type--",null,"2P, 3 WAY, 3 HAND VALVES W/A.STAT","M3  -  4P, H-O-C, TP, MANUAL","8 kW"]
[null,null,null,null,"WCWE (Closet or Recessed, Electric Heat, 2-PIPE ONLY)",1600,"--Please Select Coil Type--","120/1/60 ECM",null,"4P, 4 HAND VALVES","N1  -  4P, ON-OFF, UNIT, AUTO","--Please Select Electric Heat kW--"]
[null,null,null,null,"--Please Select Unit Type--",2000,"2-Pipe, 4 Row Coil CW/HW","277/1/60 ECM",null,"4P, 2 WAY, 4 HAND VALVES","N2  -  4P, ON-OFF, WALL, AUTO","0 kW"]
[null,null,null,null,"WMB (Horizontal/Vertical, 2-PIPE ONLY)","--Please Select Nominal CFM--","4-Pipe, Preheat, 2HW/4CW Row Coil","208-230/1/60 ECM",null,"4P, 2 WAY, 2 HAND VALVES, 2 CIRCUIT SETTERS","N3  -  4P, ON-OFF, TP, AUTO","3 kW"]
[null,null,null,null,"WMB-HW (Horizontal/Vertical, 4-PIPE ONLY)",800,"4-Pipe, Reheat, 4CW/2HW Row Coil","--Please Select Motor Type--",null,"4P, 3 WAY, 4 HAND VALVES","L1  -  3 sp fan swt only, UNIT MOUNT","5 kW"]
[null,null,null,null,"WMBE (Horizontal/Vertical, Electric, 2-PIPE ONLY)",1200,"2-Pipe, 6 Row Coil CW/HW","240/1/60 ECM",null,"4P, 3 WAY, 6 HAND VALVES","L2  -  3 sp fan swt only, WALL MOUNT","6 kW"]
[null,null,null,null,"--Please Select Unit Type--",1600,"4-Pipe, Preheat, 2HW/6CW Row Coil","277/1/60 ECM",null,null,"L3  -  3 sp fan swt only, TAMPER PROOF","8 kW"]
[null,null,null,null,"WVMB (Horizontal/Vertical, 2-PIPE ONLY)",2000,"4-Pipe, Reheat, 6CW/2HW Row Coil","--Please Select Motor Type--",null,null,"Multi-24  -  120/24V 3-spd ctrls instl","10 kW"]
[null,null,null,null,"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)",3000,"--Please Select Coil Type--","208-240/1/60",null,null,"--Please Select Control Option--","--Please Select Electric Heat kW--"]
[null,null,null,null,"WVMBE (Horizontal/Vertical, Electric, 2-PIPE ONLY)",4000,"4H 4 row - half circuit","--Please Select Motor Type--",null,null,"NC  -  NO CONTROL","3 kW"]
[null,null,null,null,"--Please Select Unit Type--",6000,"4Q 4 row - quarter circuit","120/1/60",null,null,"A1  -  2P, H-O-C, UNIT, MANUAL","4 kW"]
[null,null,null,null,"WSHX (Horizontal, Direct Expansion, Electric Heat)",8000,"6H 6 row - half circuit","208/1/60",null,null,"A2  -  2P, H-O-C, WALL, MANUAL","5 kW"]
[null,null,null,null,"WSVX  (Vertical, Direct Expansion, Electric Heat)",null,"6Q 6 row - quarter circuit","230/1/60",null,null,"B1  -  2P, ON-OFF, UNIT, AUTO, W/A.STAT","6 kW"]
[null,null,null,null,"WSHW (Horizontal, Valve Control, Electric Heat)",null,"--Please Select Coil Type--","277/1/60",null,null,"B2  -  2P, ON-OFF,WALL,AUTO,W/A.STAT","8 kW"]
[null,null,null,null,"WSVW (Vertical, Valve Control, Electric Heat)",null,"4A 4 row - STD DX coil-R22","110/1/50",null,null,"C1  -  2P, ON-OFF,UNIT,AUTO","10 kW"]
[null,null,null,null,"--Please Select Unit Type--",null,"4B 4 row - STD DX coil-R410A","220/1/50",null,null,"C2  -  2P, ON-OFF,WALL,AUTO","--Please Select Electric Heat kW--"]
[null,null,null,null,"WWH (CW/HW, Water, Electric Heat)",null,"6A 6 row - STD DX coil-R22","208/3/60",null,null,"D1  -  2PCO, ON-OFF, UNIT","5 kW"]
[null,null,null,null,"WXH (CW/HW, Direct Expansion, Electric Heat)",null,"6B 6 row - STD DX coil-R410A","230/3/60",null,null,"D2  -  2PCO. ON-OFF WALL","8 kW"]
[null,null,null,null,null,null,"--Please Select Coil Position 2, Belt Drive Double Wall H Air Handler Only--","460/3/60",null,null,"E1  -  2PHO, ON-OFF, UNIT","10 kW"]
[null,null,null,null,null,null,"4-pipe, 1 row - quarter circuit","575/3/60",null,null,"E2  -  2PHO, ON-OFF WALL","15 kW"]
[null,null,null,null,null,null,"4-pipe, 2 row - full circuit","220/3/50",null,null,"M1  -  4P, H-O-C, UNIT, MANUAL","--Please Select Electric Heat kW--"]
[null,null,null,null,null,null,"4-pipe, 2 row - half circuit","380/3/50",null,null,"M2  -  4P, H-O-C, WALL, MANUAL","5 kW"]
[null,null,null,null,null,null,"4-pipe, 4 row - half circuit","440/3/50",null,null,"N1  -  4P, ON-OFF, UNIT, AUTO","8 kW"]
[null,null,null,null,null,null,"4-pipe, 4 row - quarter circuit","277/1/60 ",null,null,"N2  -  4P, ON-OFF, WALL, AUTO","10 kW"]
[null,null,null,null,null,null,"6H 6 row - half circuit","240/1/60",null,null,"L1  -  3 sp fan swt only, UNIT MOUNT","15 kW"]
[null,null,null,null,null,null,"6Q 6 row - quarter circuit","--Please Select Motor Type--",null,null,"L2  -  3 sp fan swt only, WALL MOUNT","20 kW"]
[null,null,null,null,null,null,"4A 4 row - STD DX coil-R22","120/1/60",null,null,null,"25 kW"]
[null,null,null,null,null,null,"4B 4 row - STD DX coil-R410A","220/1/50",null,null,null,"--Please Select Electric Heat kW--"]
[null,null,null,null,null,null,"--Please Select Coil Position 3, Belt Drive Double Wall H Air Handler Only--","--Please Select Motor Type--",null,null,null,"0 kW"]
[null,null,null,null,null,null,"1Q 1 row - quarter circuit","240/1/60 ECM",null,null,null,"5 kW"]
[null,null,null,null,null,null,"2F 2 row - full circuit","240/1/60 ",null,null,null,"8 kW"]
[null,null,null,null,null,null,"2H 2 row - half circuit","277/1/60",null,null,null,"10 kW"]
[null,null,null,null,null,null,"4H 4 row - half circuit","--Please Select Motor Type--",null,null,1,"--Please Select Electric Heat kW--","--Please Select Electric Heat kW--"]
[null,null,null,null,null,null,"4Q 4 row - quarter circuit","208/3/60",null,null,null,"2 kW","1 kW"]
[null,null,null,null,null,null,"6H 6 row - half circuit","230/3/60",null,null,null,"3 kW","2 kW"]
[null,null,null,null,null,null,"6Q 6 row - quarter circuit","460/3/60",null,null,null,"4 kW","3 kW"]
[null,null,null,null,null,null,"4A 4 row - STD DX coil-R22","575/3/60",null,null,null,"5 kW","4 kW"]
[null,null,null,null,null,null,"4B 4 row - STD DX coil-R410A","220/3/50",null,null,null,"--Please Select Electric Heat kW--","5 kW"]
[null,null,null,null,null,null,null,"380/3/60",null,null,null,"2 kW","6 kW"]
[null,null,null,null,null,null,"2-Pipe, 3 Row Coil CW/Electric Heat","440/3/60",null,null,null,"3 kW","8 kW"]
[null,null,null,null,null,null,"2-Pipe, 4 Row Coil CW/Electric Heat",null,null,null,null,"5 kW","--Please Select Electric Heat kW--"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"6 kW","2 kW"]
[null,null,null,null,null,null,"2-Pipe, 3 Row Coil CW/HW",null,null,null,null,"8 kW","3 kW"]
[null,null,null,null,null,null,"2-Pipe, 4 Row Coil CW/HW",null,null,null,null,"--Please Select Electric Heat kW--","4 kW"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"3 kW","5 kW"]
[null,null,null,null,null,null,"4-Pipe, 2CW/3HW Row Coil",null,null,null,null,"4 kW","6 kW"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"5 kW","8 kW"]
[null,null,null,null,null,null,"4-Pipe, 3CW/3HW Row Coil",null,null,null,null,"6 kW","10 kW"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"8 kW"]
[null,null,null,null,null,null,"4-Pipe, Reheat, 4CW/3HW Row Coil",null,null,null,null,"10 kW"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"--Please Select Electric Heat kW--"]
[null,null,null,null,null,null,"2-Pipe, Reheat, 2CW/2HW Row Coil",null,null,null,null,"3 kW"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"5 kW"]
[null,null,null,null,null,null,"2-Pipe, Reheat, 3CW/3HW Row Coil",null,null,null,null,"6 kW"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"8 kW"]
[null,null,null,null,null,null,"2-Pipe, Reheat, 4CW/4HW Row Coil",null,null,null,null,"10 kW"]
[null,null,null,null,null,null,"--Please Select Coil Type--",null,null,null,null,"12 kW"]
[null,null,null,null,null,null,"2-Pipe, Reheat, 2CW/Electric Heat"]
[null,null,null,null,null,null,"--Please Select Coil Type--"]
[null,null,null,null,null,null,"2-Pipe, Reheat, 3CW/Electric Heat"]
[null,null,null,null,null,null,"--Please Select Coil Type--"]
[null,null,null,null,null,null,"2-Pipe, Reheat, 4CW/Electric Heat"]
[null,null,null,null,null,null,"--Please Select Coil Type--"]
[null,null,null,null,null,null,"2-Pipe, 3 Row Coil CW/Electric Heat"]
[null,null,null,null,null,null,"2-Pipe, 4 Row Coil CW/Electric Heat"]
[null,null,null,null,null,null,"--Please Select Coil Type--"]
[null,null,null,null,null,null,"4-Pipe, Reheat, 4CW/2HW Row Coil"]
[null,null,null,null,null,null,"--Please Select Coil Type--"]
[null,null,null,null,null,null,"4-Pipe, Reheat, 4CW/3HW Row Coil"]
[null,null,null,null,null,null,"--Please Select Coil Type--"]
[null,null,null,null,null,null,"4-Pipe, Reheat, 4CW/4HW Row Coil"]
[null,null,null,null,null,null,"--Please Select Coil Type--"]
[null,null,null,null,null,null,"2-pipe, 4 row - half circuit"]
[null,null,null,null,null,null,"2-pipe, 4 row - quarter circuit"]
[null,null,null,null,null,null,"2-pipe, 6 row - half circuit"]
[null,null,null,null,null,null,"2-pipe, 6 row - quarter circuit"]
[null,null,null,null,null,null,"4-pipe, 4 row - half circuit"]
[null,null,null,null,null,null,"4-pipe, 4 row - quarter circuit"]
[null,null,null,null,null,null,"4-pipe, 6 row - half circuit"]
[null,null,null,null,null,null,"4-pipe, 6 row - quarter circuit"]

{"sheet":"Lists","index":2,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Ceiling Fan Coils (300-1200 CFM)","Unit1","_Nom1",{"$f":"IF(OR(Request!$C$5=Data!E6,OR(Request!$C$5=Data!E7,OR(Request!$C$5=Data!E8,Request!$C$5=Data!E9))),\"Coil001\",IF(OR(Request!$C$5=Data!E10,OR(Request!$C$5=Data!E11,OR(Request!$C$5=Data!E12,Request!$C$5=Data!E13))),\"Coil0012\",\"\"))","v":""},{"$f":"IF(OR(AND(OR(Request!$C$5=Data!E6,OR(Request!$C$5=Data!E7,OR(Request!$C$5=Data!E8,Request!$C$5=Data!E9))),Request!$D$5=Data!$F$6)),\"Motor02\",IF(OR(Request!$C$5=Data!E6,OR(Request!$C$5=Data!E7,OR(Request!$C$5=Data!E8,Request!$C$5=Data!E9))),\"Motor1\",IF(OR(Request!$C$5=Data!E10,OR(Request!$C$5=Data!E11,OR(Request!$C$5=Data!E12,Request!$C$5=Data!E13))),\"Motor8\",\"\")))","v":""},"Handing","VPack1","ConOp2"]
[null,null,null,null,"Ceiling Fan Coils (1200-2000 CFM)","Unit3","_Nom02","Coil3","Motor9","Handing","VPack2","ConOp2"]
[null,null,null,null,"Floor / Wall Fan Coils","Unit2","_Nom1","Coil02","Motor02","Handing","VPack1","ConOp1"]
[null,null,null,null,"Direct Drive Wall/Closet Air Handlers (400-1200 CFM)","Unit4","_Nom3",{"$f":"IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F17),\"Coil2.11\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F18),\"Coil2.12\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F19),\"Coil2.12\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F20),\"Coil2.12\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F21),\"Coil2.13\",IF(AND(Request!$C$5=Data!E23,Request!$D$5=Data!F17),\"Coil2.21\",IF(AND(Request!$C$5=Data!E23,Request!$D$5=Data!F18),\"Coil2.22\",IF(AND(Request!$C$5=Data!E23,Request!$D$5=Data!F19),\"Coil2.22\",IF(AND(Request!$C$5=Data!E23,Request!$D$5=Data!F20),\"Coil2.22\",IF(AND(Request!$C$5=Data!E23,Request!$D$5=Data!F21),\"Coil2.23\",IF(AND(Request!$C$5=Data!E24,Request!$D$5=Data!F17),\"Coil2.4\",IF(AND(Request!$C$5=Data!E24,Request!$D$5=Data!F18),\"Coil2.5\",IF(AND(Request!$C$5=Data!E24,Request!$D$5=Data!F19),\"Coil2.5\",IF(AND(Request!$C$5=Data!E24,Request!$D$5=Data!F20),\"Coil2.5\",IF(AND(Request!$C$5=Data!E24,Request!$D$5=Data!F21),\"Coil2.6\",\"\")))))))))))))))","v":""},{"$f":"IF(OR(Request!$C$5=Data!E23,Request!$C$5=Data!E24),\"Motor3.1\",IF(Request!$C$5=Data!E25,\"Motor3.3\",\"\"))","v":""},"Handing","VPack2","ConOp2"]
[null,null,null,null,"Direct Drive Multi-Position Air Handlers (600-2000 CFM)","Unit5","_Nom4",{"$f":"IF(Request!$C$5=Data!E27,\"Coil4.1\",IF(AND(Request!$C$5=Data!E28,Request!$D$5=Data!F23),\"Coil4.34\",IF(AND(Request!$C$5=Data!E28,Request!$D$5=Data!F24),\"Coil4.32\",IF(AND(Request!$C$5=Data!E28,Request!$D$5=Data!F25),\"Coil4.32\",IF(AND(Request!$C$5=Data!E28,Request!$D$5=Data!F26),\"Coil4.33\",IF(Request!$C$5=Data!E29,\"Coil4.2\",\"\"))))))","v":""},{"$f":"IF(OR(Request!$C$5=Data!E27,Request!$C$5=Data!E28),\"Motor4.1\",IF(Request!$C$5=Data!E29,\"Motor4.2\",\"\"))","v":""},"Handing","VPack2","ConOp2"]
[null,null,null,null,"Variable Speed Multi-Position Air Handlers (600-2000 CFM)","Unit6","_Nom4",{"$f":"IF(Request!$C$5=Data!E31,\"Coil4.1\",IF(AND(Request!$C$5=Data!E32,Request!$D$5=Data!F23),\"Coil4.34\",IF(AND(Request!$C$5=Data!E32,Request!$D$5=Data!F24),\"Coil4.32\",IF(AND(Request!$C$5=Data!E32,Request!$D$5=Data!F25),\"Coil4.32\",IF(AND(Request!$C$5=Data!E32,Request!$D$5=Data!F26),\"Coil4.33\",IF(Request!$C$5=Data!E33,\"Coil4.2\",\"\"))))))","v":""},{"$f":"IF(Request!$C$5=Data!E31,\"Motor5.4\",IF(Request!$C$5=Data!E32,\"Motor5.2\",IF(Request!$C$5=Data!E33,\"Motor5.3\",\"\")))","v":""},"Handing","VPack2","ConOp2"]
[null,null,null,null,"Belt Drive Single Wall H/V Air Handler","Unit7","_Nom5",{"$f":"IF(OR(Request!$C$5=Data!E37,Request!$C$5=Data!E38),\"Coil5\",IF(OR(Request!$C$5=Data!E36,Request!$C$5=Data!E35),\"Coil5.1\",\"\"))","v":""},{"$f":"IF(Request!$D$5=Data!F35,\"Motor10\",\"Motor7\")","v":"Motor7"},"Handing"]
[null,null,null,null,"Belt Drive Double Wall H Air Handler","Unit8","_Nom5",{"$f":"IF(Request!$C$5=Data!E40,\"Coil6.3\",IF(Request!$C$5=Data!E41,\"Coil6.2\",\"\"))","v":""},"Motor7","Handing"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"17-21"]
[]
[null,null,null,null,"Belt Drive Double Wall H Air Handler",null,null,{"$f":"IF(OR(Request!$E$5=Data!G100,Request!$E$5=Data!G101,Request!$E$5=Data!G102,Request!$E$5=Data!G103),\"Coil6.4\",\"\")","v":""}]
[]
[null,null,null,null,"Belt Drive Double Wall H Air Handler",null,null,"Coil8"]
[]
[]
[]
[null,null,null,null,"WCWE (Closet or Recessed, Electric Heat, 2-PIPE ONLY)",{"$f":"IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F17),\"ELEC1\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F18),\"ELEC2\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F19),\"ELEC3\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F20),\"ELEC5\",IF(AND(Request!$C$5=Data!E25,Request!$D$5=Data!F21),\"ELEC5\",\"\")))))","v":""}]
[null,null,null,null,"WMBE (Horizontal/Vertical, Electric, 2-PIPE ONLY)",{"$f":"IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F23,Request!$F$5=Data!H23),\"ELEC5\",IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F24,Request!$F$5=Data!H23),\"ELEC9\",IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F25,Request!$F$5=Data!H23),\"ELEC9\",IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F26,Request!$F$5=Data!H23),\"ELEC9\",IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F23),\"ELEC6\",IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F24),\"ELEC7\",IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F25),\"ELEC8\",IF(AND(Request!$C$5=Data!E29,Request!$D$5=Data!F26),\"ELEC8\",\"\"))))))))","v":""}]
[null,null,null,null,"WVMBE (Horizontal/Vertical, Electric, 2-PIPE ONLY)",{"$f":"IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F23,Request!$F$5=Data!H30),\"ELEC5\",IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F24,Request!$F$5=Data!H30),\"ELEC9\",IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F25,Request!$F$5=Data!H30),\"ELEC9\",IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F26,Request!$F$5=Data!H30),\"ELEC9\",IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F23),\"ELEC6\",IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F24),\"ELEC7\",IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F25),\"ELEC8\",IF(AND(Request!$C$5=Data!E33,Request!$D$5=Data!F26),\"ELEC8\",\"\"))))))))","v":""}]
[null,null,null,null,"WHH (Concealed, Electric Heat)",{"$f":"IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H48),\"ELEC10\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H48),\"ELEC11\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H48),\"ELEC13\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H47),\"ELEC14\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H47),\"ELEC15\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H47),\"ELEC16\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H47),\"ELEC18\",\"\"))))))))))))","v":""}]
[null,null,null,null,"WPHH (RA Plenum, Electric Heat)",{"$f":"IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H48),\"ELEC10\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H48),\"ELEC11\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H48),\"ELEC13\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H47),\"ELEC14\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H47),\"ELEC15\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H47),\"ELEC16\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H47),\"ELEC18\",\"\"))))))))))))","v":""}]
[null,null,null,null,"WCHH (Cabinet Exposed, Electric Heat)",{"$f":"IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H48),\"ELEC10\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H48),\"ELEC11\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H48),\"ELEC13\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H47),\"ELEC14\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H47),\"ELEC15\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H47),\"ELEC16\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H47),\"ELEC18\",\"\"))))))))))))","v":""}]
[null,null,null,null,"WRHH (Recessed, Telescoping Panel, Electric Heat)",{"$f":"IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H48),\"ELEC10\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H48),\"ELEC11\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H48),\"ELEC12\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H48),\"ELEC13\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F6,Request!$F$5=Data!H47),\"ELEC14\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F7,Request!$F$5=Data!H47),\"ELEC15\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F8,Request!$F$5=Data!H47),\"ELEC16\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F9,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F10,Request!$F$5=Data!H47),\"ELEC17\",IF(AND(OR(Request!$C$5=Data!E10,Request!$C$5=Data!E11,Request!$C$5=Data!E12,Request!$C$5=Data!E13),Request!$D$5=Data!F11,Request!$F$5=Data!H47),\"ELEC18\",\"\"))))))))))))","v":""}]

{"sheet":"Nomenclature","index":3,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,{"$f":"IF(Request!$B$5=Data!D8,(CONCATENATE(C7,D7,E7,F7,G7,H7,I7,J7,K7,L7,M7)),IF(OR(Request!$B$5=Data!D6,Request!$B$5=Data!D7),(CONCATENATE(C8,D8,E8,F8,G8,H8,I8,J8,K8,L8,M8,N8)),IF(Request!$B$5=Data!D9,(CONCATENATE(C9,D9,E9,F9,G9,H9,I9,J9,K9,L9,M9,N9)),IF(Request!$B$5=Data!D10,(CONCATENATE(C10,D10,E10,F10,G10,H10,I10,J10,K10,L10,M10,N10)),IF(Request!$B$5=Data!D11,(CONCATENATE(C11,D11,E11,F11,G11,H11,I11,J11,K11,L11,M11,N11,O11)),IF(Request!$B$5=Data!D12,(CONCATENATE(C12,D12,E12,F12,G12,H12,I12,J12,K12,L12,M12)),IF(Request!$B$5=Data!D13,(CONCATENATE(C13,D13,E13,F13,G13,H13,I13,J13,K13,L13,M13,N13)),\"\")))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage Key"]
[null,"Floor / Wall Fan Coils:",{"$f":"IF(Request!$B$5=Data!D8,IF(Request!$D$5=300,3,IF(Request!$D$5=400,4,IF(Request!$D$5=600,6,IF(Request!$D$5=800,8,IF(Request!$D$5=1000,10,IF(Request!$D$5=1200,12,\"\")))))),\"\")","v":""},{"$f":"IF(Request!$C$5=\"WVSB (Cabinet Exposed, Slope Top)\",\"WVSB\",IF(Request!$C$5=\"WVFB (Cabinet Exposed, Flat Top)\",\"WVFB\",IF(Request!$C$5=\"WVCB (Concealed)\",\"WVCB\",IF(Request!$C$5=\"WWCB (Recessed)\",\"WWCB\",\"\"))))","v":""},"-",{"$f":"IF(Request!$B$5=Data!D8,IF(Request!$F$5=Data!H6,126,IF(Request!$F$5=Data!H7,246,IF(Request!$F$5=Data!H8,225,IF(Request!$F$5=Data!H9,271,\"\")))),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D8,IF(Request!$E$5=Data!G6,3,IF(Request!$E$5=Data!G7,4,IF(Request!$E$5=Data!G8,31,IF(Request!$E$5=Data!G9,31,IF(Request!$E$5=Data!G10,41,IF(Request!$E$5=Data!G11,41,\"\")))))),\"\")","v":""},{"$f":"IF(Request!$B$5=Data!D8,IF(Request!$G$5=\"Right Hand (RH) Coil Connection Side\",\"R\",IF(Request!$G$5=\"Left Hand (LH) Coil Connection Side\",\"L\",\"\")),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D8,IF(Request!$H$5=Data!J6,\"NV\",IF(Request!$H$5=Data!J7,\"BV\",IF(Request!$H$5=Data!J8,2,IF(Request!$H$5=Data!J9,3,IF(Request!$H$5=Data!J10,\"2B\",IF(Request!$H$5=Data!J11,\"2C\",IF(Request!$H$5=Data!J12,\"3B\",IF(Request!$H$5=Data!J13,\"3C\",IF(Request!$H$5=Data!J14,\"3D\",\"\"))))))))),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D8,IF(Request!$I$5=Data!K6,\"NC\",IF(Request!$I$5=Data!K7,\"A1\",IF(Request!$I$5=Data!K8,\"A2\",IF(Request!$I$5=Data!K9,\"A3\",IF(Request!$I$5=Data!K10,\"B1\",IF(Request!$I$5=Data!K11,\"B2\",IF(Request!$I$5=Data!K12,\"B3\",IF(Request!$I$5=Data!K13,\"C1\",IF(Request!$I$5=Data!K14,\"C2\",IF(Request!$I$5=Data!K15,\"C3\",IF(Request!$I$5=Data!K16,\"D1\",IF(Request!$I$5=Data!K17,\"D2\",IF(Request!$I$5=Data!K18,\"D3\",IF(Request!$I$5=Data!K19,\"E1\",IF(Request!$I$5=Data!K20,\"E2\",IF(Request!$I$5=Data!K21,\"E3\",IF(Request!$I$5=Data!K22,\"M1\",IF(Request!$I$5=Data!K23,\"M2\",IF(Request!$I$5=Data!K24,\"M3\",IF(Request!$I$5=Data!K25,\"N1\",IF(Request!$I$5=Data!K26,\"N2\",IF(Request!$I$5=Data!K27,\"N3\",IF(Request!$I$5=Data!K28,\"L1\",IF(Request!$I$5=Data!K29,\"L2\",IF(Request!$I$5=Data!K30,\"L3\",IF(Request!$I$5=Data!K31,\"Multi24\",\"\")))))))))))))))))))))))))),\"\")","v":""},null,null,null,"151 115V-1Ph-60Hz"]
[null,"Ceiling Fan Coils:",{"$f":"IF(OR(Request!$B$5=Data!D6,Request!$B$5=Data!D7),IF(Request!$D$5=300,3,IF(Request!$D$5=400,4,IF(Request!$D$5=600,6,IF(Request!$D$5=800,8,IF(Request!$D$5=1000,10,IF(Request!$D$5=1200,12,IF(Request!$D$5=16,16,IF(Request!$D$5=20,20,\"\")))))))),\"\")","v":""},{"$f":"IF(AND(Request!$C$5=\"WHBC (Concealed)\",Request!$F$5=Data!H10),\"WHBCX\",IF(AND(Request!$C$5=\"WPHBC (RA Plenum)\",Request!$F$5=Data!H10),\"WPHBCX\",IF(AND(Request!$C$5=\"WRHBC (Recessed, Telescoping Panel)\",Request!$F$5=Data!H10),\"WRHBCX\",IF(AND(Request!$C$5=\"WCHBC (Cabinet Exposed)\",Request!$F$5=Data!H10),\"WCHBCX\",IF(Request!$C$5=\"WHBC (Concealed)\",\"WHBC\",IF(Request!$C$5=\"WPHBC (RA Plenum)\",\"WPHBC\",IF(Request!$C$5=\"WRHBC (Recessed, Telescoping Panel)\",\"WRHBC\",IF(Request!$C$5=\"WCHBC (Cabinet Exposed)\",\"WCHBC\",IF(Request!$C$5=\"WHH (Concealed, Electric Heat)\",\"WHH\",IF(Request!$C$5=\"WPHH (RA Plenum, Electric Heat)\",\"WPHH\",IF(Request!$C$5=\"WCHH (Cabinet Exposed, Electric Heat)\",\"WCHH\",IF(Request!$C$5=\"WRHH (Recessed, Telescoping Panel, Electric Heat)\",\"WRHH\",IF(Request!$C$5=\"WHYB (Lo-Boy Hydronic)\",\"WHYB\",IF(Request!$C$5=\"WPHYB (Lo-Boy Hydronic, RA Plenum)\",\"WPHYB\",\"\"))))))))))))))","v":""},{"$f":"IF(Request!$C$6=\"0 kW\",0,IF(Request!$C$6=\"1 kW\",1,IF(Request!$C$6=\"2 kW\",2,IF(Request!$C$6=\"3 kW\",3,IF(Request!$C$6=\"4 kW\",4,IF(Request!$C$6=\"5 kW\",5,IF(Request!$C$6=\"6 kW\",6,IF(Request!$C$6=\"8 kW\",8,IF(Request!$C$6=\"9 kW\",9,IF(Request!$C$6=\"10 kW\",10,IF(Request!$C$6=\"12 kW\",12,\"\")))))))))))","v":""},"-",{"$f":"IF(OR(Request!$B$5=Data!D6,Request!$B$5=Data!D7),IF(Request!$E$5=Data!G6,3,IF(Request!$E$5=Data!G87,3,IF(Request!$E$5=Data!G88,4,IF(Request!$E$5=Data!G7,4,IF(Request!$E$5=Data!G8,13,IF(Request!$E$5=Data!G9,31,IF(Request!$E$5=Data!G10,14,IF(Request!$E$5=Data!G11,41,IF(Request!$E$5=Data!G12,32,IF(Request!$E$5=Data!G13,23,IF(Request!$E$5=Data!G14,42,IF(Request!$E$5=Data!G15,24,IF(Request!$E$5=Data!G16,6,\"\"))))))))))))),\"\")","v":""},{"$f":"IF(OR(Request!$B$5=Data!D6,Request!$B$5=Data!D7),IF(Request!$G$5=\"Right Hand (RH) Coil Connection Side\",\"RH\",IF(Request!$G$5=\"Left Hand (LH) Coil Connection Side\",\"LH\",\"\")),\"\")","v":""},"-",{"$f":"IF(OR(Request!$C$5=Data!E6,OR(Request!$C$5=Data!E7,OR(Request!$C$5=Data!E8,OR(Request!$C$5=Data!E9,OR(Request!$C$5=Data!E20,Request!$C$5=Data!E21))))),IF(Request!$F$5=Data!H6,126,IF(Request!$F$5=Data!H7,246,IF(Request!$F$5=Data!H8,225,IF(Request!$F$5=Data!H47,271,IF(Request!$F$5=Data!H50,126,IF(Request!$F$5=Data!H51,225,\"\")))))),IF(OR(Request!$C$5=Data!E10,OR(Request!$C$5=Data!E11,OR(Request!$C$5=Data!E12,Request!$C$5=Data!E13))),IF(Request!$F$5=Data!H48,240,IF(Request!$F$5=Data!H47,271,\"\")),\"\"))","v":""},"----------",{"$f":"IF(OR(Request!$B$5=Data!D6,Request!$B$5=Data!D7),IF(Request!$H$5=Data!J6,\"NV\",IF(Request!$H$5=Data!J7,\"BV\",IF(Request!$H$5=Data!J8,2,IF(Request!$H$5=Data!J9,3,IF(Request!$H$5=Data!J10,\"2B\",IF(Request!$H$5=Data!J11,\"2C\",IF(Request!$H$5=Data!J12,\"3B\",IF(Request!$H$5=Data!J13,\"3C\",IF(Request!$H$5=Data!J14,\"3D\",IF(Request!$H$5=Data!J16,\"2P,2HVal\",IF(Request!$H$5=Data!J17,\"2P,1HVal,C.S.\",IF(Request!$H$5=Data!J18,\"2P,2WAY,2HVal\",IF(Request!$H$5=Data!J19,\"2P,2WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J20,\"2P,3WAY,2HVal\",IF(Request!$H$5=Data!J21,\"2P,3WAY,2HVal,ASTAT\",IF(Request!$H$5=Data!J22,\"2P,3WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J23,\"2P,3WAY,3HVal\",IF(Request!$H$5=Data!J24,\"2P,3WAY,3HVal,ASTAT\",IF(Request!$H$5=Data!J25,\"4P,4HVal\",IF(Request!$H$5=Data!J26,\"4P,2WAY,4HVal\",IF(Request!$H$5=Data!J27,\"4P,2WAY,2HVal,2C.S.\",IF(Request!$H$5=Data!J28,\"4P,3WAY,4HVal\",IF(Request!$H$5=Data!J29,\"4P,3WAY,6HVal\",\"\"))))))))))))))))))))))),\"\")","v":""},"-",{"$f":"IF(OR(Request!$B$5=Data!D6,Request!$B$5=Data!D7),IF(Request!$I$5=Data!K6,\"NC\",IF(Request!$I$5=Data!K7,\"A1\",IF(Request!$I$5=Data!K8,\"A2\",IF(Request!$I$5=Data!K9,\"A3\",IF(Request!$I$5=Data!K10,\"B1\",IF(Request!$I$5=Data!K11,\"B2\",IF(Request!$I$5=Data!K12,\"B3\",IF(Request!$I$5=Data!K13,\"C1\",IF(Request!$I$5=Data!K14,\"C2\",IF(Request!$I$5=Data!K15,\"C3\",IF(Request!$I$5=Data!K16,\"D1\",IF(Request!$I$5=Data!K17,\"D2\",IF(Request!$I$5=Data!K18,\"D3\",IF(Request!$I$5=Data!K19,\"E1\",IF(Request!$I$5=Data!K20,\"E2\",IF(Request!$I$5=Data!K21,\"E3\",IF(Request!$I$5=Data!K22,\"M1\",IF(Request!$I$5=Data!K23,\"M2\",IF(Request!$I$5=Data!K24,\"M3\",IF(Request!$I$5=Data!K25,\"N1\",IF(Request!$I$5=Data!K26,\"N2\",IF(Request!$I$5=Data!K27,\"N3\",IF(Request!$I$5=Data!K28,\"L1\",IF(Request!$I$5=Data!K29,\"L2\",IF(Request!$I$5=Data!K30,\"L3\",IF(Request!$I$5=Data!K31,\"Multi24\",\"\")))))))))))))))))))))))))),\"\")","v":""},null,null,"201 208V-1Ph-60Hz"]
[null,"Direct Drive Wall/Closet Air Handlers (400-1200 CFM)",{"$f":"IF(Request!$B$5=Data!D9,IF(Request!$D$5=400,4,IF(Request!$D$5=600,6,IF(Request!$D$5=800,8,IF(Request!$D$5=1000,10,IF(Request!$D$5=1200,12,\"\"))))),\"\")","v":""},{"$f":"IF(AND(Request!$C$5=\"WCW (Closet or Recessed, 2-PIPE ONLY)\",Request!$F$5=Data!H15),\"WCWX\",IF(AND(Request!$C$5=\"WCW-HW (Closet or Recessed, 4-PIPE ONLY)\",Request!$F$5=Data!H15),\"WCW-HWX\",IF(AND(Request!$C$5=\"WCWE (Closet or Recessed, Electric Heat, 2-PIPE ONLY)\",Request!$F$5=Data!H53),\"WCWEX\",IF(Request!$C$5=\"WCW (Closet or Recessed, 2-PIPE ONLY)\",\"WCW\",IF(Request!$C$5=\"WCW-HW (Closet or Recessed, 4-PIPE ONLY)\",\"WCW-HW\",IF(Request!$C$5=\"WCWE (Closet or Recessed, Electric Heat, 2-PIPE ONLY)\",\"WCWE\",\"\"))))))","v":""},{"$f":"IF(Request!$C$6=\"0 kW\",0,IF(Request!$C$6=\"1 kW\",1,IF(Request!$C$6=\"2 kW\",2,IF(Request!$C$6=\"3 kW\",3,IF(Request!$C$6=\"4 kW\",4,IF(Request!$C$6=\"5 kW\",5,IF(Request!$C$6=\"6 kW\",6,IF(Request!$C$6=\"8 kW\",8,IF(Request!$C$6=\"9 kW\",9,IF(Request!$C$6=\"10 kW\",10,\"\"))))))))))","v":""},"----------",{"$f":"IF(Request!$B$5=Data!D9,IF(Request!$E$5=Data!G63,\"3\",IF(Request!$E$5=Data!G64,\"4\",IF(Request!$E$5=Data!G66,3,IF(Request!$E$5=Data!G67,4,\"\")))),\"\")","v":""},{"$f":"IF(Request!$B$5=Data!D9,IF(Request!$G$5=\"Right Hand (RH) Coil Connection Side\",\"RH\",IF(Request!$G$5=\"Left Hand (LH) Coil Connection Side\",\"LH\",\"\")),\"\")","v":""},"-",{"$f":"IF(OR(Request!$C$5=Data!$E$23,Request!$C$5=Data!$E$24),IF(Request!$F$5=Data!H13,126,IF(Request!$F$5=Data!H14,271,\"\")),IF(Request!$C$5=Data!$E$25,IF(Request!$F$5=Data!H55,271,IF(Request!$F$5=Data!H54,241,\"\")),\"\"))","v":""},"-",{"$f":"IF(Request!$B$5=Data!D9,IF(Request!$H$5=Data!J16,\"2P,2HVal\",IF(Request!$H$5=Data!J17,\"2P,1HVal,C.S.\",IF(Request!$H$5=Data!J18,\"2P,2WAY,2HVal\",IF(Request!$H$5=Data!J19,\"2P,2WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J20,\"2P,3WAY,2HVal\",IF(Request!$H$5=Data!J21,\"2P,3WAY,2HVal,ASTAT\",IF(Request!$H$5=Data!J22,\"2P,3WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J23,\"2P,3WAY,3HVal\",IF(Request!$H$5=Data!J24,\"2P,3WAY,3HVal,ASTAT\",IF(Request!$H$5=Data!J25,\"4P,4HVal\",IF(Request!$H$5=Data!J26,\"4P,2WAY,4HVal\",IF(Request!$H$5=Data!J27,\"4P,2WAY,2HVal,2C.S.\",IF(Request!$H$5=Data!J28,\"4P,3WAY,4HVal\",IF(Request!$H$5=Data!J29,\"4P,3WAY,6HVal\",\"\")))))))))))))),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D9,IF(Request!$I$5=Data!K6,\"NC\",IF(Request!$I$5=Data!K7,\"A1\",IF(Request!$I$5=Data!K8,\"A2\",IF(Request!$I$5=Data!K9,\"A3\",IF(Request!$I$5=Data!K10,\"B1\",IF(Request!$I$5=Data!K11,\"B2\",IF(Request!$I$5=Data!K12,\"B3\",IF(Request!$I$5=Data!K13,\"C1\",IF(Request!$I$5=Data!K14,\"C2\",IF(Request!$I$5=Data!K15,\"C3\",IF(Request!$I$5=Data!K16,\"D1\",IF(Request!$I$5=Data!K17,\"D2\",IF(Request!$I$5=Data!K18,\"D3\",IF(Request!$I$5=Data!K19,\"E1\",IF(Request!$I$5=Data!K20,\"E2\",IF(Request!$I$5=Data!K21,\"E3\",IF(Request!$I$5=Data!K22,\"M1\",IF(Request!$I$5=Data!K23,\"M2\",IF(Request!$I$5=Data!K24,\"M3\",IF(Request!$I$5=Data!K25,\"N1\",IF(Request!$I$5=Data!K26,\"N2\",IF(Request!$I$5=Data!K27,\"N3\",IF(Request!$I$5=Data!K28,\"L1\",IF(Request!$I$5=Data!K29,\"L2\",IF(Request!$I$5=Data!K30,\"L3\",IF(Request!$I$5=Data!K31,\"Multi24\",\"\")))))))))))))))))))))))))),\"\")","v":""},null,null,"231 230V-1Ph-60Hz"]
[null,"Direct Drive Multi-Position Air Handlers (600-2000 CFM)",{"$f":"IF(Request!$B$5=Data!D10,IF(Request!$D$5=600,6,IF(Request!$D$5=800,8,IF(Request!$D$5=1200,12,IF(Request!$D$5=1600,16,IF(Request!$D$5=2000,20,\"\"))))),\"\")","v":""},{"$f":"IF(Request!$C$5=\"WMB (Horizontal/Vertical, 2-PIPE ONLY)\",\"WMB\",IF(AND(Request!$C$5=\"WMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G22),\"WMB-2HW\",IF(AND(Request!$C$5=\"WMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G23),\"WMB-3HW\",IF(AND(Request!$C$5=\"WMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G24),\"WMB-4HW\",IF(Request!$C$5=\"WMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",\"WMB-HW\",IF(Request!$C$5=\"WMBE (Horizontal/Vertical, Electric, 2-PIPE ONLY)\",\"WMBE\",\"\"))))))","v":""},{"$f":"IF(Request!$C$6=\"0 kW\",0,IF(Request!$C$6=\"1 kW\",1,IF(Request!$C$6=\"2 kW\",2,IF(Request!$C$6=\"3 kW\",3,IF(Request!$C$6=\"4 kW\",4,IF(Request!$C$6=\"5 kW\",5,IF(Request!$C$6=\"6 kW\",6,IF(Request!$C$6=\"8 kW\",8,IF(Request!$C$6=\"9 kW\",9,IF(Request!$C$6=\"10 kW\",10,IF(Request!$C$6=\"15 kW\",15,IF(Request!$C$6=\"20 kW\",20,IF(Request!$C$6=\"25 kW\",25,\"\")))))))))))))","v":""},"----------",{"$f":"IF(Request!$B$5=Data!D10,IF(Request!$E$5=Data!G18,4,IF(Request!$E$5=Data!G20,4,\"\")),\"\")","v":""},{"$f":"IF(Request!$B$5=Data!D10,IF(Request!$G$5=\"Right Hand (RH) Coil Connection Side\",\"RH\",IF(Request!$G$5=\"Left Hand (LH) Coil Connection Side\",\"LH\",\"\")),\"\")","v":""},"-",{"$f":"IF(OR(Request!$C$5=Data!$E$27,Request!$C$5=Data!$E$28),IF(Request!$F$5=Data!H20,126,\"\"),IF(Request!$C$5=Data!$E$29,IF(Request!$F$5=Data!H22,241,IF(Request!$F$5=Data!H23,271,\"\")),\"\"))","v":""},"-",{"$f":"IF(Request!$B$5=Data!D10,IF(Request!$H$5=Data!J16,\"2P,2HVal\",IF(Request!$H$5=Data!J17,\"2P,1HVal,C.S.\",IF(Request!$H$5=Data!J18,\"2P,2WAY,2HVal\",IF(Request!$H$5=Data!J19,\"2P,2WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J20,\"2P,3WAY,2HVal\",IF(Request!$H$5=Data!J21,\"2P,3WAY,2HVal,ASTAT\",IF(Request!$H$5=Data!J22,\"2P,3WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J23,\"2P,3WAY,3HVal\",IF(Request!$H$5=Data!J24,\"2P,3WAY,3HVal,ASTAT\",IF(Request!$H$5=Data!J25,\"4P,4HVal\",IF(Request!$H$5=Data!J26,\"4P,2WAY,4HVal\",IF(Request!$H$5=Data!J27,\"4P,2WAY,2HVal,2C.S.\",IF(Request!$H$5=Data!J28,\"4P,3WAY,4HVal\",IF(Request!$H$5=Data!J29,\"4P,3WAY,6HVal\",\"\")))))))))))))),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D10,IF(Request!$I$5=Data!K6,\"NC\",IF(Request!$I$5=Data!K7,\"A1\",IF(Request!$I$5=Data!K8,\"A2\",IF(Request!$I$5=Data!K9,\"A3\",IF(Request!$I$5=Data!K10,\"B1\",IF(Request!$I$5=Data!K11,\"B2\",IF(Request!$I$5=Data!K12,\"B3\",IF(Request!$I$5=Data!K13,\"C1\",IF(Request!$I$5=Data!K14,\"C2\",IF(Request!$I$5=Data!K15,\"C3\",IF(Request!$I$5=Data!K16,\"D1\",IF(Request!$I$5=Data!K17,\"D2\",IF(Request!$I$5=Data!K18,\"D3\",IF(Request!$I$5=Data!K19,\"E1\",IF(Request!$I$5=Data!K20,\"E2\",IF(Request!$I$5=Data!K21,\"E3\",IF(Request!$I$5=Data!K22,\"M1\",IF(Request!$I$5=Data!K23,\"M2\",IF(Request!$I$5=Data!K24,\"M3\",IF(Request!$I$5=Data!K25,\"N1\",IF(Request!$I$5=Data!K26,\"N2\",IF(Request!$I$5=Data!K27,\"N3\",IF(Request!$I$5=Data!K28,\"L1\",IF(Request!$I$5=Data!K29,\"L2\",IF(Request!$I$5=Data!K30,\"L3\",IF(Request!$I$5=Data!K31,\"Multi24\",\"\")))))))))))))))))))))))))),\"\")","v":""},null,null,"271 277V-1Ph-60Hz"]
[null,"Variable Speed Multi-Position Air Handlers (600-2000 CFM)",{"$f":"IF(Request!$B$5=Data!D11,IF(Request!$D$5=600,6,IF(Request!$D$5=800,8,IF(Request!$D$5=1200,12,IF(Request!$D$5=1600,16,IF(Request!$D$5=2000,20,\"\"))))),\"\")","v":""},{"$f":"IF(Request!$C$5=\"WVMB (Horizontal/Vertical, 2-PIPE ONLY)\",\"WVMB\",IF(AND(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G22),\"WVMB-2HW\",IF(AND(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G23),\"WVMB-3HW\",IF(AND(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G24),\"WVMB-4HW\",IF(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",\"WVMB-HW\",IF(Request!$C$5=\"WVMBE (Horizontal/Vertical, Electric, 2-PIPE ONLY)\",\"WVMBE\",\"\"))))))","v":""},{"$f":"IF(Request!$C$6=\"0 kW\",0,IF(Request!$C$6=\"1 kW\",1,IF(Request!$C$6=\"2 kW\",2,IF(Request!$C$6=\"3 kW\",3,IF(Request!$C$6=\"4 kW\",4,IF(Request!$C$6=\"5 kW\",5,IF(Request!$C$6=\"6 kW\",6,IF(Request!$C$6=\"8 kW\",8,IF(Request!$C$6=\"9 kW\",9,IF(Request!$C$6=\"10 kW\",10,IF(Request!$C$6=\"15 kW\",15,IF(Request!$C$6=\"20 kW\",20,IF(Request!$C$6=\"25 kW\",25,\"\")))))))))))))","v":""},{"$f":"IF(Request!$F$5=Data!H30,\"-277\",\"\")","v":""},"----------",{"$f":"IF(Request!$B$5=Data!D11,IF(Request!$E$5=Data!G18,4,IF(Request!$E$5=Data!G20,4,\"\")),\"\")","v":""},{"$f":"IF(Request!$B$5=Data!D11,IF(Request!$G$5=\"Right Hand (RH) Coil Connection Side\",\"RH\",IF(Request!$G$5=\"Left Hand (LH) Coil Connection Side\",\"LH\",\"\")),\"\")","v":""},"-",{"$f":"IF(AND(Request!$C$5=Data!$E$31,Request!$F$5=Data!H25),126,IF(AND(Request!$C$5=Data!$E$32,Request!$F$5=Data!H25),126,IF(AND(Request!$C$5=Data!$E$32,Request!$F$5=Data!H27),231,IF(AND(Request!$C$5=Data!$E$32,Request!$F$5=Data!H26),271,IF(AND(Request!$C$5=Data!$E$33,Request!$F$5=Data!H29),241,\"\")))))","v":""},"-",{"$f":"IF(Request!$B$5=Data!D11,IF(Request!$H$5=Data!J16,\"2P,2HVal\",IF(Request!$H$5=Data!J17,\"2P,1HVal,C.S.\",IF(Request!$H$5=Data!J18,\"2P,2WAY,2HVal\",IF(Request!$H$5=Data!J19,\"2P,2WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J20,\"2P,3WAY,2HVal\",IF(Request!$H$5=Data!J21,\"2P,3WAY,2HVal,ASTAT\",IF(Request!$H$5=Data!J22,\"2P,3WAY,1HVal,C.S.\",IF(Request!$H$5=Data!J23,\"2P,3WAY,3HVal\",IF(Request!$H$5=Data!J24,\"2P,3WAY,3HVal,ASTAT\",IF(Request!$H$5=Data!J25,\"4P,4HVal\",IF(Request!$H$5=Data!J26,\"4P,2WAY,4HVal\",IF(Request!$H$5=Data!J27,\"4P,2WAY,2HVal,2C.S.\",IF(Request!$H$5=Data!J28,\"4P,3WAY,4HVal\",IF(Request!$H$5=Data!J29,\"4P,3WAY,6HVal\",\"\")))))))))))))),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D11,IF(Request!$I$5=Data!K6,\"NC\",IF(Request!$I$5=Data!K7,\"A1\",IF(Request!$I$5=Data!K8,\"A2\",IF(Request!$I$5=Data!K9,\"A3\",IF(Request!$I$5=Data!K10,\"B1\",IF(Request!$I$5=Data!K11,\"B2\",IF(Request!$I$5=Data!K12,\"B3\",IF(Request!$I$5=Data!K13,\"C1\",IF(Request!$I$5=Data!K14,\"C2\",IF(Request!$I$5=Data!K15,\"C3\",IF(Request!$I$5=Data!K16,\"D1\",IF(Request!$I$5=Data!K17,\"D2\",IF(Request!$I$5=Data!K18,\"D3\",IF(Request!$I$5=Data!K19,\"E1\",IF(Request!$I$5=Data!K20,\"E2\",IF(Request!$I$5=Data!K21,\"E3\",IF(Request!$I$5=Data!K22,\"M1\",IF(Request!$I$5=Data!K23,\"M2\",IF(Request!$I$5=Data!K24,\"M3\",IF(Request!$I$5=Data!K25,\"N1\",IF(Request!$I$5=Data!K26,\"N2\",IF(Request!$I$5=Data!K27,\"N3\",IF(Request!$I$5=Data!K28,\"L1\",IF(Request!$I$5=Data!K29,\"L2\",IF(Request!$I$5=Data!K30,\"L3\",IF(Request!$I$5=Data!K31,\"Multi24\",\"\")))))))))))))))))))))))))),\"\")","v":""},null,"111 110V-1Ph-50Hz"]
[null,"Belt Drive Single Wall H/V Air Handler",{"$f":"IF(Request!$B$5=Data!D12,IF(Request!$D$5=Data!F28,24,IF(Request!$D$5=Data!F29,36,IF(Request!$D$5=Data!F30,48,IF(Request!$D$5=Data!F31,60,IF(Request!$D$5=Data!F32,90,IF(Request!$D$5=Data!F33,120,IF(Request!$D$5=Data!F34,180,IF(Request!$D$5=Data!F35,240,\"\")))))))),\"\")","v":""},{"$f":"IF(Request!$C$5=\"WSHW (Horizontal, Valve Control, Electric Heat)\",\"WSHW\",IF(Request!$C$5=\"WSVW (Vertical, Valve Control, Electric Heat)\",\"WSVW\",IF(Request!$C$5=\"WSHX (Horizontal, Direct Expansion, Electric Heat)\",\"WSHX\",IF(Request!$C$5=\"WSVX  (Vertical, Direct Expansion, Electric Heat)\",\"WSVX\",\"\"))))","v":""},{"$f":"IF(Request!$B$5=Data!D12,IF(Request!$E$5=Data!G26,4,IF(Request!$E$5=Data!G29,6,IF(Request!$E$5=Data!G27,\"4-HWK\",IF(Request!$E$5=Data!G28,\"4-HWK\",IF(Request!$E$5=Data!G30,\"6-HWK\",IF(Request!$E$5=Data!G31,\"6-HWK\",\"\")))))),\"\")","v":""},{"$f":"IF(Request!$B$5=Data!D12,IF(Request!$G$5=\"Right Hand (RH) Coil Connection Side\",\"RH\",IF(Request!$G$5=\"Left Hand (LH) Coil Connection Side\",\"LH\",\"\")),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D12,IF(Request!$F$5=Data!H34,126,IF(Request!$F$5=Data!H35,201,IF(Request!$F$5=Data!H36,231,IF(Request!$F$5=Data!H37,271,IF(Request!$F$5=Data!H38,111,IF(Request!$F$5=Data!H39,221,IF(Request!$F$5=Data!H40,203,IF(Request!$F$5=Data!H41,233,IF(Request!$F$5=Data!H42,463,IF(Request!$F$5=Data!H43,573,IF(Request!$F$5=Data!H44,223,IF(Request!$F$5=Data!H45,383,IF(Request!$F$5=Data!H46,443,\"\"))))))))))))),\"\")","v":""},null,null,null,null,null,null,null,null,"221 220V-1Ph-50Hz"]
[null,"Belt Drive Double Wall H Air Handler",{"$f":"IF(Request!$B$5=Data!D13,IF(Request!$D$5=Data!F28,8,IF(Request!$D$5=Data!F29,12,IF(Request!$D$5=Data!F30,16,IF(Request!$D$5=Data!F31,20,IF(Request!$D$5=Data!F32,30,IF(Request!$D$5=Data!F33,40,IF(Request!$D$5=Data!F34,60,IF(Request!$D$5=Data!F35,80,\"\")))))))),\"\")","v":""},{"$f":"IF(Request!$C$5=\"WWH (CW/HW, Water, Electric Heat)\",\"WWHD\",IF(Request!$C$5=\"WXH (CW/HW, Direct Expansion, Electric Heat)\",\"WXHD\",\"\"))","v":""},"-",{"$f":"IF(Request!$B$5=Data!D13,IF(Request!$E$5=Data!G96,\"4H\",IF(Request!$E$5=Data!G97,\"4Q\",IF(Request!$E$5=Data!G98,\"6H\",IF(Request!$E$5=Data!G99,\"6Q\",IF(Request!$E$5=Data!G100,\"4H\",IF(Request!$E$5=Data!G101,\"4Q\",IF(Request!$E$5=Data!G102,\"6H\",IF(Request!$E$5=Data!G103,\"6Q\",IF(Request!$E$5=Data!G38,\"4A\",IF(Request!$E$5=Data!G39,\"4B\",IF(Request!$E$5=Data!G40,\"6A\",IF(Request!$E$5=Data!G41,\"6B\",\"\")))))))))))),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D13,IF(Request!$E$6=Data!G43,\"1Q\",IF(Request!$E$6=Data!G44,\"2F\",IF(Request!$E$6=Data!G45,\"2H\",IF(Request!$E$6=Data!G46,\"4H\",IF(Request!$E$6=Data!G47,\"4Q\",IF(Request!$B$5=Data!D13,IF(Request!$E$5=Data!G96,\"4H\",IF(Request!$E$5=Data!G97,\"4Q\",IF(Request!$E$5=Data!G98,\"6H\",IF(Request!$E$5=Data!G99,\"6Q\",IF(Request!$E$5=Data!G38,\"4A\",IF(Request!$E$5=Data!G39,\"4B\",IF(Request!$E$5=Data!G40,\"6A\",IF(Request!$E$5=Data!G41,\"6B\",\"\")))))))))))))),\"\")","v":""},"-",null,null,{"$f":"IF(Request!$B$5=Data!D13,IF(Request!$G$5=\"Right Hand (RH) Coil Connection Side\",\"RH\",IF(Request!$G$5=\"Left Hand (LH) Coil Connection Side\",\"LH\",\"\")),\"\")","v":""},"-",{"$f":"IF(Request!$B$5=Data!D13,IF(Request!$F$5=Data!H34,126,IF(Request!$F$5=Data!H35,201,IF(Request!$F$5=Data!H36,231,IF(Request!$F$5=Data!H37,271,IF(Request!$F$5=Data!H38,111,IF(Request!$F$5=Data!H39,221,IF(Request!$F$5=Data!H40,203,IF(Request!$F$5=Data!H41,233,IF(Request!$F$5=Data!H42,463,IF(Request!$F$5=Data!H43,573,IF(Request!$F$5=Data!H44,223,IF(Request!$F$5=Data!H45,383,IF(Request!$F$5=Data!H46,443,\"\"))))))))))))),\"\")","v":""},null,null,"203 208V-3Ph-60Hz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"233 230V-3Ph-60Hz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"463 460V-3Ph-60Hz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"573 575V-3Ph-60Hz"]
[null,null,{"$f":"IF(Request!$C$5=\"WVMB (Horizontal/Vertical, 2-PIPE ONLY)\",\"WVMB\",IF(AND(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G22),\"WVMB-2HW\",IF(AND(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G23),\"WVMB-3HW\",IF(AND(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",Request!$E$5=Data!G24),\"WVMB-4HW\",IF(Request!$C$5=\"WVMB-HW (Horizontal/Vertical, 4-PIPE ONLY)\",\"WVMB-HW\",IF(Request!$C$5=\"WVMBE (Horizontal/Vertical, Electric, 2-PIPE ONLY)\",\"WVMBE\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"223 220V-3Ph-50Hz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"383 380V-3Ph-50Hz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"443 440V-3Ph-50Hz"]