{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Aerodynamic Noise ABC","About the worksheet","Calculation Method","Gas Sonic Vel Calculator"],"not_rendered":{"images":1,"defined_names":31},"read":"whole","date_system":"1900"}

{"sheet":"Aerodynamic Noise ABC","index":0,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[2,1,2,7],[3,4,3,7],[31,1,31,7],[32,1,32,10],[49,1,49,4]]}
[null,"Control Valve Aerodynamic 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 pressure",{"$f":"IF(C25=1,\"psia\",IF(C25=2,\"bar(a)\",IF(C25=3,\"kPa(a)\",\"Undfined\")))","v":"psia"},"P_1_",116,116,116,116]
[null,"  Outlet pressure",{"$f":"IF(C25=1,\"psia\",IF(C25=2,\"bar(a)\",IF(C25=3,\"kPa(a)\",\"Undfined\")))","v":"psia"},"P_2_",58,58,58,58]
[null,"  Molecular mass (Air = 28.97)","AMU","M",28.97,28.97,28.97,28.97]
[null,{"$f":"IF(C26=1,\"  Sonic velocity of the gas (air = 1126 ft/sec)\",IF(C26=2,\" Sonic velocity of the gas (air = 343 m/sec)\",\"Undefined\"))","v":"  Sonic velocity of the gas (air = 1126 ft/sec)"},{"$f":"IF(C26=1,\"ft/sec\",IF(C26=2,\"m/sec\",\"Undefined\"))","v":"ft/sec"},"ci_",1126,1126,1126,1126]
[]
[null,"Valve/Pipe Parameters"]
[null,"  Downstream pipe diameter",{"$f":"IF(C27=1,\"inch\",IF(C27=2,\"mm\",\"Undefined\"))","v":"inch"},"D_2_",2,2,2,2]
[null,"  Valve capacity, CV",null,"C_v",54.5,54.5,54.5,54.5]
[null,"  Pressure recovery factor, FL",null,"F_L",0.82,0.82,0.82,0.82]
[null,"  Valve style modifier, Fd",null,"F_d",0.25,0.25,0.25,0.25]
[]
[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",3,3,3,3]
[]
[null,"Calculated SPL (LpAe1m)","dB(A)","SPL",{"$f":"IFERROR(LpAe1m,\"\")","v":{"v":92.45788440812038,"d":"92.5"}},{"$f":"IFERROR(F49,\"\")","v":{"v":92.45788440812038,"d":"92.5"}},{"$f":"IFERROR(G49,\"\")","v":{"v":92.45788440812038,"d":"92.5"}},{"$f":"IFERROR(H49,\"\")","v":{"v":92.45788440812038,"d":"92.5"}}]
[]
[null,"Units Selection"]
[null,"Presssure: 1 = psia  2 = bar  3 = kPa",1,null,"  "]
[null,"Sonic Velocity:  1 = ft/sec. 2 = m/sec.",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($C25=1,P_1_*1,IF($C25=2,P_1_*14.5,IF($C25=3,P_1_*0.145,\"Undefined\")))","v":{"v":116,"d":"116.0"}},{"$f":"IF($C25=1,F7*1,IF($C25=2,F7*14.5,IF($C25=3,F7*0.145,\"Undefined\")))","v":{"v":116,"d":"116.0"}},{"$f":"IF($C25=1,G7*1,IF($C25=2,G7*14.5,IF($C25=3,G7*0.145,\"Undefined\")))","v":{"v":116,"d":"116.0"}},{"$f":"IF($C25=1,H7*1,IF($C25=2,H7*14.5,IF($C25=3,H7*0.145,\"Undefined\")))","v":{"v":116,"d":"116.0"}}]
[null,"P_2 (Calculation uses psia)",null,"P_2",{"$f":"IF($C25=1,P_2_*1,IF($C25=2,P_2_*14.5,IF($C25=3,P_2_*0.145,\"Undefined\")))","v":{"v":58,"d":"58.0"}},{"$f":"IF($C25=1,F8*1,IF($C25=2,F8*14.5,IF($C25=3,F8*0.145,\"Undefined\")))","v":{"v":58,"d":"58.0"}},{"$f":"IF($C25=1,G8*1,IF($C25=2,G8*14.5,IF($C25=3,G8*0.145,\"Undefined\")))","v":{"v":58,"d":"58.0"}},{"$f":"IF($C25=1,H8*1,IF($C25=2,H8*14.5,IF($C25=3,H8*0.145,\"Undefined\")))","v":{"v":58,"d":"58.0"}}]
[null,"ci (Calculation uses ft/sec)",null,"ci",{"$f":"IF($C26=1,ci_*1,IF($C26=2,ci_*3.2808,\"Undefined\"))","v":{"v":1126,"d":"1126.0"}},{"$f":"IF($C26=1,F10*1,IF($C26=2,F10*3.2808,\"Undefined\"))","v":{"v":1126,"d":"1126.0"}},{"$f":"IF($C26=1,G10*1,IF($C26=2,G10*3.2808,\"Undefined\"))","v":{"v":1126,"d":"1126.0"}},{"$f":"IF($C26=1,H10*1,IF($C26=2,H10*3.2808,\"Undefined\"))","v":{"v":1126,"d":"1126.0"}}]
[null,"D_2 (Calculation uses inch)",null,"D_2",{"$f":"IF($C27=1,D_2_*1,IF($C27=2,D_2_*0.03937,\"Undefined\"))","v":{"v":2,"d":"2.0"}},{"$f":"IF($C27=1,F13*1,IF($C27=2,F13*0.03937,\"Undefined\"))","v":{"v":2,"d":"2.0"}},{"$f":"IF($C27=1,G13*1,IF($C27=2,G13*0.03937,\"Undefined\"))","v":{"v":2,"d":"2.0"}},{"$f":"IF($C27=1,H13*1,IF($C27=2,H13*0.03937,\"Undefined\"))","v":{"v":2,"d":"2.0"}}]
[]
[{"$nulls":6},"`"]
[]
[null,"FINAL CALCULATIONS"]
[null,"x, Pressure ratio",null,"X",{"$f":"(P_1-P_2)/P_1","v":{"v":0.5,"d":"0.50"}},{"$f":"(F35-F36)/F35","v":{"v":0.5,"d":"0.50"}},{"$f":"(G35-G36)/G35","v":{"v":0.5,"d":"0.50"}},{"$f":"(H35-H36)/H35","v":{"v":0.5,"d":"0.50"}}]
[null,"DFL",null,"DELTA F_L",{"$f":"IF(F_L<0.7,30*LOG10(0.7/F_L),30*LOG10(F_L/0.7))","v":{"v":2.0614743710837966,"d":"2.06"}},{"$f":"IF(F15<0.7,30*LOG10(0.7/F15),30*LOG10(F15/0.7))","v":{"v":2.0614743710837966,"d":"2.06"}},{"$f":"IF(G15<0.7,30*LOG10(0.7/G15),30*LOG10(G15/0.7))","v":{"v":2.0614743710837966,"d":"2.06"}},{"$f":"IF(H15<0.7,30*LOG10(0.7/H15),30*LOG10(H15/0.7))","v":{"v":2.0614743710837966,"d":"2.06"}}]
[null,"A","dB","A",{"$f":"25*LOG10(D_2)-10+20*LOG10(C_v/D_2^2)","v":{"v":20.212480110573132,"d":"20.21"}},{"$f":"25*LOG10(F38)-10+20*LOG10(F14/F38^2)","v":{"v":20.212480110573132,"d":"20.21"}},{"$f":"25*LOG10(G38)-10+20*LOG10(G14/G38^2)","v":{"v":20.212480110573132,"d":"20.21"}},{"$f":"25*LOG10(H38)-10+20*LOG10(H14/H38^2)","v":{"v":20.212480110573132,"d":"20.21"}}]
[null,"B","dB","B",{"$f":"35*LOG(P_1)-35","v":{"v":37.25602962294215,"d":"37.26"}},{"$f":"35*LOG(F35)-35","v":{"v":37.25602962294215,"d":"37.26"}},{"$f":"35*LOG(G35)-35","v":{"v":37.25602962294215,"d":"37.26"}},{"$f":"35*LOG(H35)-35","v":{"v":37.25602962294215,"d":"37.26"}}]
[null,"C","dB","C_",{"$f":"27+30+30*LOG(X)+20*LOG(F_d)","v":{"v":35.92790030352131,"d":"35.93"}},{"$f":"27+30+30*LOG(F43)+20*LOG(F16)","v":{"v":35.92790030352131,"d":"35.93"}},{"$f":"27+30+30*LOG(G43)+20*LOG(G16)","v":{"v":35.92790030352131,"d":"35.93"}},{"$f":"27+30+30*LOG(H43)+20*LOG(H16)","v":{"v":35.92790030352131,"d":"35.93"}}]
[null,"G, correction for gasses other than air",null,"G",{"$f":"20*LOG(ci/1126)+15*LOG(M/28.97)","v":{"v":0,"d":"0.00"}},{"$f":"20*LOG(F37/1126)+15*LOG(F9/28.97)","v":{"v":0,"d":"0.00"}},{"$f":"20*LOG(G37/1126)+15*LOG(G9/28.97)","v":{"v":0,"d":"0.00"}},{"$f":"20*LOG(H37/1126)+15*LOG(H9/28.97)","v":{"v":0,"d":"0.00"}}]
[null,"LpAe1m = A+B+C+DFL+G-rw-ps","dB(A)","LpAe1m",{"$f":"A+B+C_+DELTA_F_L+G-rw-ps","v":{"v":92.45788440812038,"d":"92.46"}},{"$f":"F45+F46+F47+F44+F48-F20-F19","v":{"v":92.45788440812038,"d":"92.46"}},{"$f":"G45+G46+G47+G44+G48-G20-G19","v":{"v":92.45788440812038,"d":"92.46"}},{"$f":"H45+H46+H47+H44+H48-H20-H19","v":{"v":92.45788440812038,"d":"92.46"}}]
[null,"(This calculated value of noise  is copied to the user interface.)"]

{"sheet":"About the worksheet","index":1,"n_rows":18,"n_cols":2,"rows_kept":18}
[]
[]
[null,"Simple Excel worksheet predicts control valve aerodynamic noise. "]
[]
[null,"Recently an article was published that presented an easily constructed Excel sheet that estimates hydrodynamic noise in control valves1. A number of people have asked me if there is something similar for aerodynamic noise. It turns out that Hans D. Baumann, an internationally recognized control valve expert who has spent many years investigating control valve noise mechanisms and theory and who developed the method in Reference 1 also has a similar simplified method for estimating control valve aerodynamic noise. He has kindly given me permission to use it as a basis for an Excel worksheet which is the subject of this paper."]
[]
[null,"IEC 60534-8-3 is nearly universally recognized as the preferred method for predicting control valve aerodynamic noise and most control valve manufacturers include it in their control valve sizing and selection applications. For the user who wants to make quick noise predictions or who wants to construct their own valve sizing application, programming the IEC noise standard can be a daunting task. For example, I have constructed an Excel sheet that exactly implements the IEC standard. That Excel sheet consists of 261 lines of formulas, a task that many would not have the time or enthusiasm for. Thus the justification for a simplified noise prediction method."]
[]
[null,"Reliable valve noise test data is difficult to find unless you are a valve manufacturer and then you tend not to share it. I did find 10 noise tests that I believe to be reliable and using this simplified noise prediction method the average absolute error was 3.3 dB(A). Control valve noise prediction methods normally claim accuracy of plus or minus 5 dB(A)."]
[]
[null,"The calculation method is shown on the Calculation Method tab  The method presented here is simple enough to be implemented with a pocket calculator or one of the many calculator apps available for cell phones, but using the Excel sheet in this file, the calculations can be done even more quickly. We refer to this as the ABC method, partly because the term “ABC” is often recognized as something that is simple, and also because the main noise calculation is divided into three parts, named A, B and C.    "]
[]
[null,"The worksheet requires the sonic velocity of the gas as a process parameter. If the sonic velocity is not known, I have included a tab that has a worksheet that can calculate the sonic velocity of a gas."]
[]
[null,"Reference 1. Excel-worksheet predicts control valve hydrodynamic noise, Valve World, July 2020 pp 44 – 45"]
[]
[null,"Reference 1 can be viewed at: "]
[null,"https://www.valin.com/resources/articles/excel-worksheet-predicts-control-valve-hydrodynamic-noise"]

{"sheet":"Calculation Method","index":2,"n_rows":40,"n_cols":2,"rows_kept":40}
[null,"ABC Method for predicting control vavle aerodynamic noise."]
[null,"Calculation method by Hans D. Baumann"]
[null,"Excel worksheet by Jon Monsen"]
[]
[null,"`"]
[null,"P_1 upstram pressure (Calculation uses psia)"]
[null,"P_2 downstream pressure (Calculation uses psia)"]
[null,"ci, gas sonic velocity (Calculation uses ft/sec)"]
[null,"downstram pipe size (Calculation uses inch)"]
[]
[null,"The worksheet includes the capability to easily specify other units that are often used: "]
[null," Pressure: bar, kPa(a), Velocity, m/sec, Pipe size, mm"]
[]
[]
[null,"Initial intermediate calculations:"]
[null,"Pressure ratio, X = (P1 - P2) / P1 "]
[null,"A = 25 log(D2) - 10 + 20 log(Cv / D22)"]
[null,"B = 35 log(P1) - 35"]
[null,"C = 27 + 30 +30 log(X) + 20 log(Fd)"]
[null,"DFL:  if FL < 0.7 then DFL = 30 log(0.7 / FL) otherwise, "]
[null,"DFL=30 log(FL / 0.7)"]
[null,"G = 20 log(ci / 1125 ) + 15 log(M / 28.97)"]
[null,"The final calculation combines the above intermediate calculations to obtain the estimated aerodynamic noise, "]
[null,"LpAe1m = A + B + C + DFL + G – rw – ps "]
[]
[null,"Nomenclature:"]
[null,"A: SPL due to valve size and Cv"]
[null,"B: SPL due to upstream pressure"]
[null,"C: SPL due to pressure ratio and Fd"]
[null,"DFL: SPL correction for FL greater or less than 0.7"]
[null,"FL: Valve Liquid pressure recovery factor at operating valve travel"]
[null,"G: Correction for gasses other than air based on sonic velocity and molecular mass of the gas relative to air. G = 0 for air"]
[null,"P_1, P_2: pressure upstream and downstream of valve (psia)"]
[null,"D2: Pipe size downstream of valve (inch)"]
[null,"Cv: Valve flow coefficient at operating valve travel"]
[null,"Fd: Valve style modifier at operating valve travel "]
[null,"ci: Sonic velocity of the gas in feet per second. Air = 1125"]
[null,"M: Molecular mass of the gas. Air = 28.97"]
[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":"Gas Sonic Vel Calculator","index":3,"n_rows":49,"n_cols":7,"rows_kept":49,"merged":[[0,0,0,5],[0,6,0,8],[2,1,2,2],[2,4,2,5],[4,0,4,1]]}
["Gas Sonic Velocity",{"$nulls":5},"J. Monsen"]
[]
["GAS:","Air",null,"TAG:"]
[]
["Temperature units (F, C or K)",null,"F"]
[]
[{"$f":"IF(TEMP_UNITS=\"F\",\"TEMP. (F)\",IF(TEMP_UNITS=\"C\", \"TEMP. (C)\",\"TEMP. (K)\"))","v":"TEMP. (F)"}]
[68,{"$nulls":4},"Data input"]
[{"$nulls":5},"Final result"]
["Molecular Mass, M",{"$nulls":4},"Intermediate "]
[28.97,{"$nulls":4},"calculation"]
[]
["Spec. Heat Ratio, GAMMA"]
[1.4]
[]
["SONIC VELOCITY, m/s"]
[{"$f":"SQRT(8314*Temp._converted_to_K*GAMMA/M)","v":{"v":343.1940340063664,"d":"343"}}]
[]
["SONIC VELOCITY, ft/s"]
[{"$f":"SONIC_VELOCITY__m_s*3.281","v":{"v":1126.019625574888,"d":"1126"}}]
[]
["Temp. converted to K "]
[{"$f":"IF(TEMP_UNITS=\"F\",((TEMP-32)/1.8)+273.15,IF(TEMP_UNITS=\"C\",TEMP+273.15,TEMP))","v":293.15}]
[]
[]
["This worksheet is distributed at no charge on an as-is basis. The author does not assume any liability for its use.   "]
["It is the user’s responsibility to determine its applicability to their application."]
[]
["INSTRUCTIONS"]
[]
["Enter the temperature unis you want to use. Valid entries  are F, C or K."]
["Enter the given temperature (in the units you have selected) the molecular mass of the"]
["gas and its specific heat ratio."]
[]
["The equation for gas sonic velocitay is:"]
[]
[]
[]
[]
[]
["Where c is the speed of sound in the gas, meters per second"]
["g is the ratio of specific heats of the gas"]
["T is the temperature in Kelvin"]
["M is the molecular mass"]
["R is the universal gas constant, 8314"]
[]
["The worksheet is protected to prevent accidental changes. If you want to make changes,"]
["there is no password. Select REVIEW  then UNPROTECT SHEET, but you do so at"]
["your own risk."]