{"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":169,"n_cols":7,"rows_kept":169,"cut":false,"hidden":false,"merged":[[34,1,34,2]]}
["PBM Part Number Configurator"]
["For 2-way Industrial AF Series 1",null,null,null,null,{"$f":"MID(C7,1,2)","v":""}]
[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,2)&MID(C13,1,1)&MID(C14,1,2)&MID(C15,1,1)&MID(C16,1,1)","v":"AF1"},null,null,{"$f":"MID(C29,1,1)","v":""}]
[null,null,null,null,null,{"$f":"MID(C29,5,1)","v":""}]
["Position","Description","Click in field and select from menu"]
["1-2","Product Series","AF = Angle Stem Flush Tank ball valve w/integral outlet connection, live loaded stem packing"]
["3-4","Material",null,null,null,"H- = 316/316L Stainless Steel Body, Ends, Ball, and Stem"]
["5","Size",null,null,null,"HL = 316L Stainless Steel Body, Ends, Ball, and Stem (Sanitary Clamp Only)","RT = RTFE"]
["6","Series","1 = PBM Series 1 Design",null,null,"C- = C-276 Hastelloy Body, Ends, Ball, and Stem","VT = VTFE"]
["7-8","End Connections",null,null,null,"Y- = C-22 Hastelloy Body, Ends, Ball, and Stem","TF = V-TEF™"]
["9","Seat / Filler Material",null,null,null,"HC = Alloy 20 Body, Ends, Ball, and Stem","HT = S-TEF®"]
["10-11","Weld Pad / Ball Options",null,null,null,"22 = Duplex 2205 Body, Ends, Ball, and Stem","UT = UHMWPE"]
["12","Ball / Stem Options",null,null,null,"76 = Super Duplex 32760 Body, Ends, Ball, and Stem","PK = PEEK"]
["13-14","Operator",null,null,null,null,"CG = Carbon Graphite"]
["15","Polish",null,null,null,null,"TF = VTFE Cavity Fillers Only"]
["16","LOX Cleaning"]
[]
[null,null,null,null,null,"E = 1 inch"]
["PBM Repair Kit Part Number Configurator",null,null,null,null,"G = 1-1/2 inch"]
["For 2-way Industrial AF Series 1",null,null,null,null,"H = 2 inch","E = 1 inch"]
[null,"    Repair Kit Part Number:",{"$f":"MID(C24,1,2)&MID(C25,1,2)&MID(C26,1,1)&MID(C27,1,1)&MID(C28,1,2)&MID(C29,1,1)&MID(C30,1,2)&MID(C31,1,1)","v":"AF 1----1"},null,null,"K = 3 inch","G = 1-1/2 inch"]
[null,null,null,null,null,"L = 4 inch","H = 2 inch"]
["Position","Description","Click in field and select from menu (Material Code Only)",null,null,"M = 6 inch","K = 3 inch"]
["1-2","Product Series","AF = Angle Stem Flush Tank ball valve w/integral outlet connection, live loaded stem packing",null,null,null,"L = 4 inch"]
["3-4","Material",{"$f":"IF(F4=\"V\",G10,IF(F4=\"S\",G11,IF(F4=\"U\",G12,IF(F4=\"R\",G8,IF(F4=\"T\",G9,IF(F4=\" \",G15,\" \"))))))","v":" "},null,null,null,"M = 6 inch"]
["5","Size",{"$f":"LEFT(C8,25)","v":""}]
["6","Series","1 = PBM Series 1",null,null,"L- = 150# RF Flange"]
["7-8"," - -","-- = dashes only, no options to select",null,null,"Q- = Female NPT","A = RTFE seats and seals, Adjust-O-Seal®"]
["9","Material Code",null,null,null,"X- = Sanitary Clamp","C =VTFE seats and seals, Adjust-O-Seal®"]
["10-11"," - - ","-- = dashes only, no options to select",null,null,null,"G = V-TEF™ seats and seals, Adjust-O-Seal®"]
["12","Kit Code",{"$f":"IF(F3=\"J\",G38,IF(F3=\"M\",G38,IF(F3=\"P\",G38,G37)))","v":"1 = (1) complete repair kit"},null,null,null,"H = S-TEF® seats and seals, Adjust-O-Seal®"]
["R0",null,null,null,null,null,"K = UHMWPE seats and seals, Adjust-O-Seal®"]
["2018-11-18","Note:  PBM recommends a Gear Operator or Actuator for 6\" Valves.",null,null,null,null,"J =  VTFE cavity fillers"]
[null,null,null,null,null,null,"M = UHMWPE cavity fillers"]
[]
[null,null,null,null,null,"A = RTFE seats and seals, no cavity filler, Adjust-O-Seal® (Standard for Industrial)"]
[null,null,null,null,null,"B = RTFE seats and seals, VTFE cavity filler, Adjust-O-Seal® (Standard for Industrial)","1 = (1) complete repair kit"]
[null,null,null,null,null,"C = VTFE seats and seals, no cavity filler, Adjust-O-Seal® (Standard for Sanitary)","3 = (3) complete filler kit"]
[null,null,null,null,null,"D = VTFE seats and seals, VTFE cavity filler, Adjust-O-Seal® (Standard for Sanitary)"]
[null,null,null,null,null,"G = V-TEF™ seats and seals, no cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"J = V-TEF™ seats and seals, VTFE cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"H = S-TEF® seats and seals, no cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"I = S-TEF® seats and seals, VTFE cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"K = UHMWPE seats and seals, no cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"L = UHMWPE seats and seals, VTFE cavity filler, Adjust-O-Seal®"]
[]
[]
[]
[null,null,null,null,null,"-- = Standard flush tank pad"]
[null,null,null,null,null,"02 = less weld pad with shipping pad (Shipping pad on 2\" and larger)"]
[null,null,null,null,null,"05 = 1 inch bolt on 150# RF flat pad (1\" size only)"]
[null,null,null,null,null,"06 = 1-1/2 inch bolt on 150# RF flat pad (1\" thru 1-1/2\" size only)"]
[null,null,null,null,null,"07 = 2 inch bolt on 150# RF flat pad (1\" thru 2\" size only)"]
[null,null,null,null,null,"08 = 3 inch bolt on 150# RF flat pad (1\" thru 2\" size only)"]
[null,null,null,null,null,"09 = 4 inch bolt on 150# RF flat pad (1\" thru 4\" size only)"]
[null,null,null,null,null,"10 = 6 inch bolt on 150# RF flat pad (1\" thru 4\" size only)"]
[null,null,null,null,null,"11 = 8 inch bolt on 150# RF flat pad (1\" thru 6\" size only)"]
[null,null,null,null,null,"-K = Ball with vent hole (downstream) with standard weld pad"]
[null,null,null,null,null,"-8 = Self-flushing ball with standard weld pad"]
[null,null,null,null,null,"-9 = Ball with vent hole (upstream) with standard weld pad"]
[]
[]
[null,null,null,null,null,"- = Standard ball and stem"]
[null,null,null,null,null,"F = internal & external grounding"]
[null,null,null,null,null,"G = 17-4 PH stem"]
[]
[]
[]
[null,null,null,null,null,"- = No additional polish"]
[null,null,null,null,null,"A = 20 RA ID polish"]
[null,null,null,null,null,"B = 32 RA OD polish"]
[null,null,null,null,null,"C = 20 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"D = 15 RA ID polish"]
[null,null,null,null,null,"E = 10 RA ID polish"]
[null,null,null,null,null,"F = 20 RA ID polish after electropolish"]
[null,null,null,null,null,"G = 15 RA ID polish after electropolish"]
[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 (ID & OD)"]
[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"]
[null,null,null,null,null,"M = LOX cleaning per PBM procedure and CRN Bolting (not for Sanitary)"]
[null,null,null,null,null,"Z = CRN Bolting (Not for Sanitary)"]
[]
[]
[null,null,null,null,null,"-- = Manual lever handle (For 1\" through 4\" Valves Only)"]
[null,null,null,null,null,"02 = less handle (stem ready for future automation)"]
[null,null,null,null,null,"03 = manual lever handle (stem ready for future automation)  (For 1\" through 4\" Valves Only)"]
[null,null,null,null,null,"08 = gear operator (Required for 6\" Manual Valves)"]
[null,null,null,null,null,"10 = Manual Spring Return Handle  (For 1\" through 1-1/2\" Valves Only)"]
[null,null,null,null,null,"11 = Fusible Link Spring Return Handle (temp rating required)  (For 1\" through 3\" Valves Only)"]
[null,null,null,null,null,"12 = Vane Actuator"]
[null,null,null,null,null,"13 = GP Electric Actuator"]
[null,null,null,null,null,"14 = XP Electric Actuator"]
[null,null,null,null,null,"20 = 80 PSIG DA PBM Actuator"]
[null,null,null,null,null,"21 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"22 = 80 PSIG DA PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"23 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"24 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"25 = 80 PSIG DA PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"26 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"27 = 60 PSIG DA PBM Actuator"]
[null,null,null,null,null,"28 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"29 = 60 PSIG DA PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"30 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"31 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"32 = 60 PSIG DA PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"33 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"34 = 80 PSIG SR PBM Actuator"]
[null,null,null,null,null,"35 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"36 = 80 PSIG SR PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"37 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"38 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"39 = 80 PSIG SR PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"40 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"41 = 60 PSIG SR PBM Actuator"]
[null,null,null,null,null,"42 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"43 = 60 PSIG SR PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"44 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"45 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"46 = 60 PSIG SR PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"47 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"51 = 80 PSIG DA PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"52 = 60 PSIG DA PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"53 = 80 PSIG SR PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"54 = 60 PSIG SR PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"55 = 80 PSIG DA PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"56 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"57 = 80 PSIG DA PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"58 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"59 = 60 PSIG DA PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"60 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"61 = 60 PSIG DA PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"62 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"63 = 80 PSIG SR PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"64 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"65 = 80 PSIG SR PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"66 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"67 = 60 PSIG SR PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"68 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"69 = 60 PSIG SR PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"70 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"73 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"74 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"75 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"76 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"77 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"78 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"79 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"80 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"81 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"82 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch"]
[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,"84 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"85 = 80 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"86 = 80 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"87 = 60 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"88 = 60 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"89 = 80 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"90 = 80 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"91 = 60 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"92 = 60 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]

{"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":[]}