{"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":211,"n_cols":7,"rows_kept":211,"cut":false,"hidden":false,"merged":[[35,0,35,2],[36,1,36,2],[33,1,33,2]]}
["PBM Part Number Configurator"]
["For 2-way Industrial SP Series 6 API-607 Valves",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,1)&MID(C13,1,1)&MID(C14,1,1)&MID(C15,1,2)&MID(C16,1,1)&MID(C17,1,1)","v":"SP6"},null,null,{"$f":"MID(C30,1,1)","v":""}]
[null,null,null,null,null,{"$f":"MID(C30,5,1)","v":""}]
["Position","Description","Click in field and select from menu"]
["1-2","Product Series","SP = Industrial 2-way 3-piece ball valve, 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","TF = V-TEF™"]
["6","Series","6 = PBM Series 6 Design API-607 Firesafe w/ int & ext grounding, graphite secondary seals (Non-Adjust-O-Seal®)",null,null,"E- = Carbon Steel Body and Ends, 316/316L S/S Ball and Stem","HT = S-TEF®"]
["7-8","End Connections",null,null,null,"C- = C-276 Hastelloy Body, Ends, Ball, and Stem","UT = UHMWPE"]
["9","Seat / Filler Material",null,null,null,"Y- = C-22 Hastelloy Body, Ends, Ball, and Stem","PK = PEEK"]
["10","Purge Ports",null,null,null,"HC = Alloy 20 Body, Ends, Ball, and Stem","CG = Carbon Graphite"]
["11","Ball Flats, Purge Holes, V-Ball",null,null,null,"22 = Duplex 2205 Body, Ends, Ball, and Stem","TF = VTFE Cavity Fillers Only"]
["12","Ball / Stem Options",null,null,null,"76 = Super Duplex 32760 Body, Ends, Ball, and Stem"]
["13-14","Operator"]
["15","Polish"]
["16","LOX Cleaning"]
[null,null,null,null,null,null,"C = 1/4, 3/8, 1/2 inch"]
[null,null,null,null,null,"A = 1/4 inch","D = 3/4 inch"]
["PBM Repair Kit Part Number Configurator",null,null,null,null,"B = 3/8 inch","E = 1 inch"]
["For 2-way Industrial SP Series 6 API-607",null,null,null,null,"C = 1/2 inch","G = 1-1/2 inch"]
[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":"SP  ----1"},null,null,"D = 3/4 inch","H = 2 inch"]
[null,null,null,null,null,"E = 1 inch","J = 2-1/2 inch"]
["Position","Description","Click in field and select from menu (Material Code and Size Only)",null,null,"G = 1-1/2 inch","K = 3 inch"]
["1-2","Product Series","SP = Industrial 2-way 3-piece ball valve, live loaded stem packing",null,null,"H = 2 inch"]
["3-4","Material",{"$f":"IF(F4=\"V\",G8,IF(F4=\"S\",G9,IF(F4=\"U\",G10,IF(F4=\"P\",G11,IF(F4=\"C\",G12,IF(F4=\" \",G13,\" \"))))))","v":" "},null,null,"J = 2-1/2 inch"]
["5","Size",null,null,null,"K = 3 inch","G = V-TEF™ seats and graphite seals, FKM o-rings"]
["6","Series",{"$f":"IF(F4=\"V\",G39,IF(F4=\"S\",G39,IF(F4=\"U\",G39,IF(F4=\"J\",G38,IF(F4=\"C\",G39,IF(F4=\" \",G38,\" \"))))))","v":" "},null,null,null,"Z = V-TEF™ seats and graphite seals, EPR o-rings"]
["7-8"," - -","-- = dashes only, no options to select",null,null,null,"H = S-TEF® seats and graphite seals, FKM o-rings"]
["9","Material Code",null,null,null,null,"0 = S-TEF® seats and graphite seals, EPR o-rings"]
["10-11"," - - ","-- = dashes only, no options to select",null,null,"B- = Extended Butt weld for pipe - Schedule 40","9 = V-TEF™ seats and graphite seals, FEP Encaps. FKM o-ring"]
["12","Kit Code",{"$f":"IF(F3=\"J\",G36,IF(F3=\"M\",G36,IF(F3=\"P\",G36,G35)))","v":"1 = (1) complete repair kit"},null,null,"D- = Extended Butt weld for pipe - Schedule 10","J =  VTFE cavity fillers"]
["R0",null,null,null,null,"J = Extended Socket Weld for Pipe"]
["2018-11-18","Note:  Two different end connections can be used on these valves including sanitary connections.  Contact PBM with your requirements.",null,null,null,"L- = 150# RF Flange"]
[null,null,null,null,null,"M- = 300# RF Flange","1 = (1) complete repair kit"]
["“All Carbon Steel Valves will be coated internally and externally with a rust inhibitor. Information on the rust inhibitor and/or an MSDS is available upon request.  If the rust inhibitor is not acceptable, customer to advise specific coating required.  Alternate coatings may impact price & delivery time.  As an alternative to the rust inhibitor on external surfaces, Carbon steel cast products may be painted (black in color) as a rust inhibitor.”",null,null,null,null,"P- = Male NPT","3 = (3) complete filler kit"]
[null,null,null,null,null,"Q- = Female NPT"]
[null,null,null,null,null,"U- = Socket Weld for Pipe","5 = Series 5 Design"]
[null,null,null,null,null,null,"6 = PBM Series 6 Design API-607 Firesafe w/ int & ext grounding, graphite secondary seals (Non-Adjust-O-Seal®)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"G = V-TEF™ seats and graphite seals, no cavity filler, FKM o-rings"]
[null,null,null,null,null,"J = V-TEF™ seats and graphite seals, VTFE cavity filler, FKM o-rings"]
[null,null,null,null,null,"Z = V-TEF™ seats and graphite seals, no cavity filler, EPR o-rings"]
[null,null,null,null,null,"2 = V-TEF™ seats and graphite seals, VTFE cavity filler, EPR o-rings"]
[null,null,null,null,null,"9 = V-TEF™ seats and graphite seals, no cavity filler, FEP Encaps. FKM o-rings"]
[null,null,null,null,null,"H = S-TEF® seats and graphite seals, no cavity filler, FKM o-rings"]
[null,null,null,null,null,"I = S-TEF® seats and graphite seals, VTFE cavity filler, FKM o-rings"]
[null,null,null,null,null,"0 = S-TEF® seats and graphite seals, no cavity filler, EPR o-rings"]
[null,null,null,null,null,"1 = S-TEF® seats and graphite seals, VTFE cavity filler, EPR o-rings"]
[]
[]
[]
[null,null,null,null,null,"- = no purge ports required"]
[null,null,null,null,null,"A = (1) 1/2\" sanitary clamp on center, 90 degrees from stem"]
[null,null,null,null,null,"B = (1) 1/2\" sanitary clamp on center, opposite stem"]
[null,null,null,null,null,"C = (1) 1/2\" sanitary clamp upstream, 90 degrees from stem"]
[null,null,null,null,null,"D = (1) 1/2\" sanitary clamp downstream opposite stem"]
[null,null,null,null,null,"E = (2) 1/2\" sanitary clamps on center 90 deg from & opposite stem"]
[null,null,null,null,null,"F = (2) 1/2\" sanitary clamps upstream 90 deg from & downstream opp stem"]
[null,null,null,null,null,"G = (1) 1/2\" BWTE stub on center, 90 degrees from stem"]
[null,null,null,null,null,"H = (1) 1/2\" BWTE stub on center, opposite stem"]
[null,null,null,null,null,"I = (1) 1/2\" BWTE stub upstream, 90 degrees from stem"]
[null,null,null,null,null,"J = (1) 1/2\" BWTE stub downstream opposite stem"]
[null,null,null,null,null,"K = (2) 1/2\" BWTE stubs on center 90 deg from & opposite stem"]
[null,null,null,null,null,"L = (2) 1/2\" BWTE stubs upstream 90 deg from & downstream opp stem"]
[null,null,null,null,null,"M = (1) 1/4\" FNPT on center, 90 degrees from stem"]
[null,null,null,null,null,"N = (1) 1/4\" FNPT on center, opposite stem"]
[null,null,null,null,null,"O = (1) 1/4\" FNPT upstream, 90 degrees from stem"]
[null,null,null,null,null,"P = (1) 1/4\" FNPT downstream opposite stem"]
[null,null,null,null,null,"Q = (2) 1/4\" FNPT on center 90 degrees from & opposite stem"]
[null,null,null,null,null,"R = (2) 1/4\" FNPT upstream 90 deg from & downstream opp stem"]
[]
[]
[]
[null,null,null,null,null,"- = no ball flats, ball purge holes, or V ball required"]
[null,null,null,null,null,"A = ball flats facing downstream in ball - closed position"]
[null,null,null,null,null,"B = ball flats facing upstream in ball - closed position"]
[null,null,null,null,null,"C = ball flats facing upstream in ball - open position"]
[null,null,null,null,null,"D = ball flats facing downstream in ball - open position"]
[null,null,null,null,null,"E = ball flats up & downstream in ball - open position"]
[null,null,null,null,null,"F = ball holes facing downstream in ball - closed position"]
[null,null,null,null,null,"G = ball holes facing upstream in ball - closed positon"]
[null,null,null,null,null,"H = ball holes facing upstream in ball -  open positon"]
[null,null,null,null,null,"I = ball holes facing downstream in ball - open position"]
[null,null,null,null,null,"J = ball holes up & downsteam in ball - open position"]
[null,null,null,null,null,"K = Ball with vent hole (downstream)"]
[null,null,null,null,null,"V = standard width slotted ball for flow control"]
[null,null,null,null,null,"W = 30 degree V ball"]
[null,null,null,null,null,"X = 45 degree V ball"]
[null,null,null,null,null,"Y = 60 degree V ball"]
[null,null,null,null,null,"Z = 90 degree V ball"]
[null,null,null,null,null,"1 = 120 degree V ball"]
[null,null,null,null,null,"7 = Self-flushing ball with flats closed downstream"]
[null,null,null,null,null,"8 = Self-flushing ball"]
[null,null,null,null,null,"9 = Ball with vent hole (upstream)"]
[]
[]
[null,null,null,null,null,"- = Standard ball and stem"]
[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,"-- = Manual lever handle (For 1/2\" through 3\" Valves Only)"]
[null,null,null,null,null,"00 = manual locking oval handwheel  (For 1/2\" through 2\" 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/2\" through 3\" Valves Only)"]
[null,null,null,null,null,"04 = manual locking lever handle  (For 1/2\" through 3\" Valves Only)"]
[null,null,null,null,null,"05 = oval handwheel  (For 1/2\" through 2\" Valves Only)"]
[null,null,null,null,null,"07 = 45 degree handle  (For 1/2\" through 3\" Valves Only)"]
[null,null,null,null,null,"08 = gear operator"]
[null,null,null,null,null,"10 = Manual Spring Return Handle  (For 1/2\" through 1-1/2\" Valves Only)"]
[null,null,null,null,null,"11 = Fusible Link Spring Return Handle (temp rating required)  (For 1/2\" 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,"17 = extended locking oval handwheel  (For 1/2\" through 2\" Valves Only)"]
[null,null,null,null,null,"18 = extended locking lever handle  (For 1/2\" through 3\" Valves Only)"]
[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":[]}