{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Hydrodynamic Noise ABC","Calculation Method","Stop Cavitation Valve World"],"not_rendered":{"images":7,"defined_names":28},"read":"whole","date_system":"1900"}

{"sheet":"Hydrodynamic Noise ABC","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"merged":[[2,1,2,7],[3,4,3,7],[29,1,29,7],[30,1,30,10]]}
[null,"Control Valve Hydrodynamic Noise","Calculation method by Hans D. Baumann"]
[null,"ABC Method","Worksheet by Jon F. Monsen"]
[null,"USER INTERFACE"]
[{"$nulls":3},"Variable","User inputs"]
[null,null,"Unit","Name","Case 1","Case 2","Case 3","Case 4"]
[null,"Process Parameters"]
[null,"  Inlet pressurre, P1",{"$f":"IF(C24=1,\"psia\",IF(C24=2,\"bar(a)\",IF(C24=3,\"kPa(a)\",\"Undfined\")))","v":"psia"},"P_1_",100,100,100,100]
[null,"  Outlet pressure, P2",{"$f":"IF(C24=1,\"psia\",IF(C24=2,\"bar(a)\",IF(C24=3,\"kPa(a)\",\"Undfined\")))","v":"psia"},"P_2_",40,40,40,40]
[null,"  Liquid vapor pressure, Pv",{"$f":"IF(C24=1,\"psia\",IF(C24=2,\"bar(a)\",IF(C24=3,\"kPa(a)\",\"Undfined\")))","v":"psia"},"P_v_",0.5,0.5,0.5,0.5]
[]
[null,"Valve/Pipe Parameters"]
[null,"   Downstream pipe diameter",{"$f":"IF(C25=1,\"inch\",IF(C25=2,\"mm\",\"Undefined\"))","v":"inch"},"D_",6,6,6,6]
[null,"   Valve capacity, Cv",null,"C_v",85,85,85,85]
[null,"   Liquid pressure recovery factor, FL",null,"F_L",0.7,0.7,0.7,0.7]
[null,"   Diff press ratio of incipient cavitation noise, xFz",null,"x_Fz",0.28,0.28,0.28,0.28]
[]
[null,"Modifiers"]
[null,"   Downstream Pipe schedule (40=0, 80=4 160=8 )","dB","ps",0,0,0,0]
[null,"   Valve Style, rw (globe = 3, others = 0)","dB","rw",0,0,0,0]
[]
[null,"Calculated SPL (LpAe1m)","dB(A)","SPL",{"$f":"IFERROR(LpAe1m,\"\")","v":{"v":90.39869780103055,"d":"90.4"}},{"$f":"IFERROR(F49,””)","v":{"v":90.39869780103055,"d":"90.4"}},{"$f":"IFERROR(G49,””)","v":{"v":90.39869780103055,"d":"90.4"}},{"$f":"IFERROR(H49,””)","v":{"v":90.39869780103055,"d":"90.4"}}]
[{"$nulls":9},"                       "]
[null,"Units Selection"]
[null,"  Presssure: 1 = psia  2 = bar  3 = kPa",1]
[null,"  Size:  1 = inch  2 = mm",1]
[]
[]
[]
[]
[null,"NO USER INPUT IS REQUIRED IN THIS SECTION"]
[null,"WORKSHEET UNITS CONVERTED TO UNITS REQUIRED BY THE CALCULATIONS. ALL OTHER VARIABLES ARE INDEPENDENT OF UNITS"]
[{"$nulls":3},"Variable name"]
[null,"P_1(Calculation uses psia)",null,"P_1",{"$f":"IF($C24=1,P_1_*1,IF($C24=2,P_1_*14.5,IF($C24=3,P_1_*0.145,\"Undefined\")))","v":{"v":100,"d":"100.0"}},{"$f":"IF($C24=1,F7*1,IF($C24=2,F7*14.5,IF($C24=3,F7*0.145,\"Undefined\")))","v":{"v":100,"d":"100.0"}},{"$f":"IF($C24=1,G7*1,IF($C24=2,G7*14.5,IF($C24=3,G7*0.145,\"Undefined\")))","v":{"v":100,"d":"100.0"}},{"$f":"IF($C24=1,H7*1,IF($C24=2,H7*14.5,IF($C24=3,H7*0.145,\"Undefined\")))","v":{"v":100,"d":"100.0"}}]
[null,"P_2 (Calculation uses psia)",null,"P_2",{"$f":"IF($C24=1,P_2_*1,IF($C24=2,P_2_*14.5,IF($C24=3,P_2_*0.145,\"Undefined\")))","v":{"v":40,"d":"40.0"}},{"$f":"IF($C24=1,F8*1,IF($C24=2,F8*14.5,IF($C24=3,F8*0.145,\"Undefined\")))","v":{"v":40,"d":"40.0"}},{"$f":"IF($C24=1,G8*1,IF($C24=2,G8*14.5,IF($C24=3,G8*0.145,\"Undefined\")))","v":{"v":40,"d":"40.0"}},{"$f":"IF($C24=1,H8*1,IF($C24=2,H8*14.5,IF($C24=3,H8*0.145,\"Undefined\")))","v":{"v":40,"d":"40.0"}}]
[null,"P_v  (Calculation uses psia)",null,"p_v",{"$f":"IF($C24=1,P_v_*1,IF($C24=2,P_v_*14.5,IF($C24=3,P_v_*0.145,\"Undefined\")))","v":0.5},{"$f":"IF($C24=1,F9*1,IF($C24=2,F9*14.5,IF($C24=3,F9*0.145,\"Undefined\")))","v":0.5},{"$f":"IF($C24=1,G9*1,IF($C24=2,G9*14.5,IF($C24=3,G9*0.145,\"Undefined\")))","v":0.5},{"$f":"IF($C24=1,H9*1,IF($C24=2,H9*14.5,IF($C24=3,H9*0.145,\"Undefined\")))","v":0.5}]
[null,"D (Calculation uses inch)",null,"D",{"$f":"IF($C25=1,D_*1,IF($C25=2,D_*0.03937,\"Undefined\"))","v":{"v":6,"d":"6.0"}},{"$f":"IF($C25=1,F12*1,IF($C25=2,F12*0.03937,\"Undefined\"))","v":{"v":6,"d":"6.0"}},{"$f":"IF($C25=1,G12*1,IF($C25=2,G12*0.03937,\"Undefined\"))","v":{"v":6,"d":"6.0"}},{"$f":"IF($C25=1,H12*1,IF($C25=2,H12*0.03937,\"Undefined\"))","v":{"v":6,"d":"6.0"}}]
[]
[]
[null,"FINAL CALCULATIONS"]
[]
[null,"X,  Pressure ratio",null,"X",{"$f":"(P_1-P_2)/(P_1-p_v)","v":0.6030150753768844},{"$f":"(F33-F34)/(F33-F35)","v":0.6030150753768844},{"$f":"(G7-G8)/(G7-G9)","v":0.6030150753768844},{"$f":"(H7-H8)/(H7-H9)","v":0.6030150753768844}]
[null,"X at max cavitation, Xy",null,"Xy",{"$f":"(1+x_Fz)/2","v":0.64},{"$f":"(1+F15)/2","v":0.64},{"$f":"(1+G15)/2","v":0.64},{"$f":"(1+H15)/2","v":0.64}]
[null,"A ","dB","A",{"$f":"8*LOG10(D)+12*LOG10(C_v/D^2)+4","v":14.702607102433214},{"$f":"8*LOG10(F36)+12*LOG10(F13/F36^2)+4","v":14.702607102433214},{"$f":"8*LOG10(G36)+12*LOG10(G13/G36^2)+4","v":14.702607102433214},{"$f":"8*LOG10(H36)+12*LOG10(H13/H36^2)+4","v":14.702607102433214}]
[null,"B ","dB","B",{"$f":"35*LOG10(P_1)-35","v":35},{"$f":"35*LOG10(F33)-35","v":35},{"$f":"35*LOG10(G33)-35","v":35},{"$f":"35*LOG10(H33)-35","v":35}]
[null,"C1","dB","C_1",{"$f":"IF(X>=F_L^2,(30*LOG10(10*F_L^2)),30*LOG10(10*X))","v":20.70588240085541},{"$f":"IF(F41>=F14^2,(30*LOG10(10*F14^2)),30*LOG10(10*F41))","v":20.70588240085541},{"$f":"IF(G41>=G14^2,(30*LOG10(10*G14^2)),30*LOG10(10*G41))","v":20.70588240085541},{"$f":"IF(H41>=H14^2,(30*LOG10(10*H14^2)),30*LOG10(10*H41))","v":20.70588240085541}]
[null,"C2","dB","C_2",{"$f":"IF(X>Xy,60*LOG(Xy/x_Fz),IF(X>=x_Fz,60*LOG(X/x_Fz),0))","v":19.990208297741933},{"$f":"IF(F41>F42,60*LOG(F42/F15),IF(F41>=F15,60*LOG(F41/F15),0))","v":19.990208297741933},{"$f":"IF(G41>G42,60*LOG(G42/G15),IF(G41>=G15,60*LOG(G41/G15),0))","v":19.990208297741933},{"$f":"IF(H41>H42,60*LOG(H42/H15),IF(H41>=H15,60*LOG(H41/H15),0))","v":19.990208297741933}]
[null," C3 ","dB","C_3",{"$f":"IF(X>=Xy,120*LOG10(X/Xy),0)","v":0},{"$f":"IF(F41>= F42,120*LOG10(F41/F42), 0)","v":0},{"$f":"IF(G41>= G42,120*LOG10(G41/G42), 0)","v":0},0]
[null,"C = C1+C2-C3","dB(A)","C_",{"$f":"C_1+C_2-C_3","v":40.696090698597345},{"$f":"F45+F46-F47","v":40.696090698597345},{"$f":"G45+G46-G47","v":40.696090698597345},40.696090698597345]
[null,"LpAe1m = A+B+C-rw-ps","dB(A)","LpAe1m",{"$f":"A+B+C_-rw-ps","v":{"v":90.39869780103055,"d":"90.40"}},{"$f":"F43+F44+F48-F19-F18","v":{"v":90.39869780103055,"d":"90.40"}},{"$f":"G43+G44+G48-G19-G18","v":{"v":90.39869780103055,"d":"90.40"}},{"$f":"H43+H44+H48-H19-H18","v":{"v":90.39869780103055,"d":"90.40"}}]
[null,"(This calculated value of noise  is copied to the user interface.)"]

{"sheet":"Calculation Method","index":1,"n_rows":44,"n_cols":2,"rows_kept":44,"merged":[[0,1,0,9]]}
[null,"ABC Method for predicting control vavle hydrodynamic noise."]
[null,"Calculation method by Hans D. Baumann"]
[null,"Excel worksheet by Jon Monsen"]
[]
[]
[null,"P_1 upstram pressure (Calculation uses psia)"]
[null,"P_2 downstream pressure (Calculation uses psia)"]
[null,"P_v liquid vapor pressure (Calculation uses psia)"]
[null,"downstram pipe size (Calculation uses inch)"]
[]
[null,"The worksheet includes the capability to easily specify other units that are often used: "]
[null," Pressure: psia, bar, kPa(a), Pipe size inch, mm"]
[]
[]
[null,"Initial intermediate calculations:"]
[null," X = (P1 – P2)/(P1- Pv)"]
[null," Xy = (1.00+Xfz)/2"]
[null,"A = 8 log(D) + 12log(CV/D2) +4 in dB"]
[null,"B = 35 log(P1) – 35 "]
[null,"C1 = 30 log(10X), X maximim = FL2."]
[null,"C2 if X is larger than Xfz but below Xy then"]
[null,"C2 = 60 log(X/Xfz). if X is above Xy then"]
[null,"C2 = 60 log(Xy/Xfz); otherwise use zero."]
[null,"C3 if X is larger than Xy then c3 = 120 log(X/Xy), otherwise use zero"]
[null,"C = C1 + C2 - C3 in dB(A)."]
[null,"The final calculation combines the above intermediate calculations to obtain the estimated hydrodynamic noise,"]
[null," LpAe1m = A + B + C -  rw -  ps"]
[]
[null,"Nomenclature:"]
[null,"X: Pressure ratio"]
[null,"Xy: X at max. cavitation"]
[null,"A: SPL due to downstream pipe size and Cv"]
[null,"B: SPL due to upstream pressure"]
[null,"C1: Turbulent sound level"]
[null,"C2: Correction to C when X is larger than Xfz"]
[null,"C3: Decreasing sound level if X is greater than Xy"]
[null,"C:  C1 + C2 - C3"]
[null,"FL: Valve Liquid pressure recovery factor at operating valve travel"]
[null,"P1, P2: pressure upstream and downstream of valve (psia)"]
[null,"PV, vapor pressure of the liquid"]
[null,"D: Pipe size downstream of valve (inch)"]
[null,"Cv: Valve flow coefficient at operating valve travel"]
[null,"rw: SPL correction for globe valves, rw = 3. For all others rw = 0"]
[null,"ps: Correction for downstream pipe schedule. (40 = 0, 80 = 4, 160 = 8)"]

{"sheet":"Stop Cavitation Valve World","index":2,"n_rows":1,"n_cols":3,"rows_kept":1}
[null,null,"This is the December 2019 Valve World Magazine article that the worksheet is base on"]