{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":118,"n_cols":7,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
["PBM Part Number Configurator"]
["For ANSI 2-way ball valves, Series 1 Bronze Only"]
[null,"Valve Part Number:",{"$f":"MID(C6,1,2)&MID(C7,1,2)&MID(C8,1,1)&MID(C9,1,1)&MID(C10,1,2)&MID(C11,1,1)&MID(C12,1,1)&MID(C13,1,1)&MID(C14,1,1)&MID(C15,1,2)&MID(C16,1,1)&MID(C17,1,1)","v":"AN1-"},null,null,null,"A = RTFE seats and seals, FKM o-ring, Adjust-O-Seal®"]
[null,null,null,null,null,null,"V = RTFE seats and seals, EPR o-ring, Adjust-O-Seal®"]
["Position","Description","Click in field and select from menu",null,null,"B- = 836 Bronze Body and End, 316/316L S/S Ball and Stem","H = S-TEF® seats and seals, FKM o-ring, Adjust-O-Seal®"]
["1-2","Product Series","AN = ASME B16.10 ANSI ball valve, 2-way 2-piece, live loaded stem packing",null,null,"N- = 922 Bronze Body and End, 316/316L S/S Ball and Stem","0 = S-TEF® seats and seals, EPR o-ring, Adjust-O-Seal®"]
["3-4","Material",null,null,null,"R- = 955 Nickel Aluminum Bronze Body, End, and Ball, 316/316L S/S Stem","C = VTFE seats and seals, FKM o-ring, Adjust-O-Seal®"]
["5","Size",null,null,null,"S- = 953 Aluminum Bronze Body, End, and Ball, 316/316L S/S Stem","T = VTFE seats and seals, EPR o-ring, Adjust-O-Seal®"]
["6","Series","1 = PBM Series 1 Design",null,null,"X- = 958 Nickel Aluminum Bronze Body, End, and Ball, 316/316L S/S Stem","D = VTFE cavity fillers"]
["7-8","End Connections",null,null,null,"9- = 954 Aluminum Bronze Body, End, and Ball, 316/316L S/S Stem"]
["9","Seat / Filler / O-Ring Material"]
["10","Purge Ports","- = no purge ports required",null,null,null,"RT = RTFE"]
["11","Ball Flats, Purge Holes, V-Ball",null,null,null,null,"HT = S-TEF®"]
["12","Ball / Stem Options",null,null,null,"C = 1/2 inch","VT = VTFE"]
["13-14","Operator",null,null,null,"D = 3/4 inch"]
["15","Polish",null,null,null,"E = 1 inch"]
["16","LOX Cleaning",null,null,null,"G = 1-1/2 inch"]
[null,null,null,null,null,"H = 2 inch","1 = (1) complete repair kit"]
[null,null,null,null,null,"J = 2-1/2 inch","3 = (3) cavity filler kit"]
["PBM Repair Kit Part Number Configurator (size filled in when valve above is built)",null,null,null,null,"K = 3 inch"]
["For ANSI 2-way ball valves, Series 1 Bronze Only",null,null,null,null,"L = 4 inch",{"$f":"MID(C30,5,1)","v":""}]
[null,"    Repair Kit Part Number:",{"$f":"MID(C25,1,2)&MID(C26,1,2)&MID(C27,1,1)&MID(C28,1,1)&MID(C29,1,2)&MID(C30,1,1)&MID(C31,1,2)&MID(C32,1,1)","v":"AN 1----1"},null,null,"M = 6 inch",{"$f":"MID(C30,1,1)","v":""}]
[]
["Position","Description","Click in field and select from menu (Material Code Only)"]
["1-2","Product Series","AN = ASME B16.10 ANSI ball valve, 2-way 2-piece, live loaded stem packing"]
["3-4","Material",{"$f":"IF(G21=\"R\",G12,IF(G21=\"S\",G13,IF(G21=\"V\",G14,\" \")))","v":" "},null,{"$f":"MID(C30,5,1)","v":""},null,"-- = Manual lever handle (For 1/2\" through 4\" Valves Only)"]
["5","Size",{"$f":"LEFT(C8,25)","v":""},null,null,null,"02 = less handle (stem ready for future automation)"]
["6","Series","1 = PBM Series 1 Design",null,null,null,"03 = manual lever handle (stem ready for future automation)  (For 1/2\" through 4\" Valves Only)"]
["7-8"," - -","-- = dashes only, no options to select",null,null,null,"04 = manual locking lever handle  (For 1/2\" through 4\" Valves Only)"]
["9","Material Code",null,null,null,null,"05 = oval handwheel  (For 1/2\" through 2\" Valves Only)"]
["10-11"," - - ","-- = dashes only, no options to select",null,null,"L- = 150# Flat Face Flange with Adjust-O-Seal®","07 = 45 degree handle  (For 1/2\" through 4\" Valves Only)"]
["12","Kit Code",{"$f":"IF(G22=\"B\",G19,IF(G22=\"I\",G19,IF(G22=\"D\",G19,IF(G22=\"U\",G19,IF(G22=\"W\",G19,IF(G22=\"1\",G19,G18))))))","v":"1 = (1) complete repair kit"},null,null,"L3 = 150# Flat Face Flange Non Adjust-O-Seal®","08 = gear operator (Required for 6\" Manual Valves)"]
["R0",null,null,null,null,"M- = 300# Flat Face Flange with Adjust-O-Seal®","10 = Manual Spring Return Handle  (For 1/2\" through 1-1/2\" Valves Only)"]
["11/18","Note:  All bronze valves except for 836 Bronze are supplied with CUSI body bolting.",null,null,null,"M3 = 300# Flat Face Flange Non Adjust-O-Seal®","12 = Vane Actuator"]
[null,"Note:  PBM recommends a Gear Operator or Actuator for 6\" Valves.",null,null,null,null,"13 = GP Electric Actuator"]
[null,null,null,null,null,null,"14 = XP Electric Actuator"]
[null,null,null,null,null,"A = RTFE seats and seals, no cavity filler, FKM o-ring","20 = 80 PSIG DA PBM Actuator"]
[null,null,null,null,null,"B = RTFE seats and seals, VTFE cavity filler, FKM o-ring","21 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"V = RTFE seats and seals, no cavity filler, EPR o-ring","22 = 80 PSIG DA PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"W = RTFE seats and seals, VTFE cavity filler, EPR o-ring","23 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"H = S-TEF® seats and seals, no cavity filler, FKM o-ring","24 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"I = S-TEF® seats and seals, VTFE cavity filler, FKM o-ring ","25 = 80 PSIG DA PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"0 = S-TEF® seats and seals, no cavity filler, EPR o-ring","26 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"1 = S-TEF® seats and seals, VTFE cavity filler, EPR o-ring","27 = 60 PSIG DA PBM Actuator"]
[null,null,null,null,null,"C = VTFE seats and seals, no cavity filler, FKM o-ring","28 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"D = VTFE seats and seals, VTFE cavity filler, FKM o-ring ","29 = 60 PSIG DA PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"T = VTFE seats and seals, no cavity filler, FKM o-ring ","30 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"U = VTFE seats and seals, VTFE cavity filler, EPR o-ring","31 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"7 = RTFE seats and seals, VTFE cavity filler, FEP Encaps. FKM o-ring","32 = 60 PSIG DA PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"8 = VTFE seats and seals, VTFE cavity filler, FEP Encaps. FKM o-ring","33 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,null,"34 = 80 PSIG SR PBM Actuator"]
[null,null,null,null,null,null,"35 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,null,"36 = 80 PSIG SR PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,null,"37 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,null,"38 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"- = no ball flats, ball purge holes, or V ball required","39 = 80 PSIG SR PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"A = ball flats facing downstream in ball - closed position","40 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"B = ball flats facing upstream in ball - closed position","41 = 60 PSIG SR PBM Actuator"]
[null,null,null,null,null,"C = ball flats facing upstream in ball - open position","42 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"D = ball flats facing downstream in ball - open position","43 = 60 PSIG SR PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"E = ball flats up & downstream in ball - open position","44 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"F = ball holes facing downstream in ball - closed position","45 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"G = ball holes facing upstream in ball - closed positon","46 = 60 PSIG SR PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"H = ball holes facing upstream in ball -  open positon","47 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"I = ball holes facing downstream in ball - open position","51 = 80 PSIG DA PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"J = ball holes up & downsteam in ball - open position","52 = 60 PSIG DA PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"K = Ball with vent hole (downstream)","53 = 80 PSIG SR PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"V = standard width slotted ball for flow control","54 = 60 PSIG SR PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"W = 30 degree V ball","55 = 80 PSIG DA PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"X = 45 degree V ball","56 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"Y = 60 degree V ball","57 = 80 PSIG DA PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"Z = 90 degree V ball","58 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"1 = 120 degree V ball","59 = 60 PSIG DA PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"7 = Self-flushing ball with flats closed downstream","60 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"8 = Self-flushing ball","61 = 60 PSIG DA PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"9 = Ball with vent hole (upstream)","62 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,null,"63 = 80 PSIG SR PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,null,"64 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"- = Standard ball and stem","65 = 80 PSIG SR PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"F = internal & external grounding","66 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"G = 17-4 PH stem","67 = 60 PSIG SR PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"I = Monel ball","68 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"J = 932 Bronze Ball","69 = 60 PSIG SR PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"K = Monel stem and followers","70 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"L = Monel ball, stem, and follower","73 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"N = 922 Bronze ball","74 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"O = Hastelloy C-276 ball","75 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"P = Hastelloy C-276 ball, stem, and follower","76 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"Q = 922 Bronze ball and Monel stem","77 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"R = Monel stem, follower, and bolting","78 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"R = Monel ball, stem, follower, and bolting","79 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"T = 922 Bronze ball, Monel stem and follower, CuSi bolting","80 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"U = 922 Bronze ball, Monel stem and follower","81 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,null,"82 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,null,"83 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,null,"84 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"- = no polish","85 = 80 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"A = 20 RA ID polish","86 = 80 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"B = 32 RA OD polish","87 = 60 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"C = 20 RA ID & 32 RA OD polish","88 = 60 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"D = 15 RA ID polish","89 = 80 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"E = 10 RA ID polish","90 = 80 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"F = 20 RA ID polish after electropolish","91 = 60 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"G = 15 RA ID polish after electropolish","92 = 60 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"H = 10 RA ID polish after electropolish"]
[null,null,null,null,null,"I = 5 RA ID polish"]
[null,null,null,null,null,"K = 5 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"L = 20 RA ID & 32 RA OD polish after electropolish"]
[null,null,null,null,null,"M = Electropolish only"]
[null,null,null,null,null,"N = 10 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"O = 15 RA ID & 32 RA OD polish after electropolish"]
[null,null,null,null,null,"Q = 15 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"S = 10 RA ID & 32 RA OD polish after electropolish"]
[]
[]
[]
[]
[null,null,null,null,null,"L = LOX Cleaning per PBM Procedure"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}