Home > categories > Hydraulic & Pneumatic > Other Valves > How do you calculate the valve wall thickness, pressure, and other valve design calculations in a spreadsheet?
Question:

How do you calculate the valve wall thickness, pressure, and other valve design calculations in a spreadsheet?

How do you calculate the valve wall thickness, pressure, and other valve design calculations in a spreadsheet?

Answer:

Which standard does the wall thickness refer to? ASME B16.34?Design and calculation depends on what standard you chooseOr have you found the standard yourself and read it yourself?You choose what standards, design parameters reference, interpolation or fitting, how to fit, are their own sayI wrote a excel series of valve calculations, it does not take long to writeFor long-term useIn order to improve efficiencyOr write your own database program is better
The valve wall thickness is the standard valve check directly in the relevant standard, for insert grade valves need to use interpolation method to calculate the valve wall thickness, actually don't need what difficult to complete in EXCEL software.
For you to introduce the spreadsheet calculation, application basis, you according to this principle for valve correlation calculation:When A1 and B1 cells are used as parameters, the amount of computation is calculated by C1. If the formula is X+Y=? In the A1 cell, fill in the X; fill the Y in the B1 cell; fill in the C1 cell with "=A1+B1"; enter the carriage, and then calculate the corresponding value in the C1 cell. For example: fill in 5 in the A1 cell; fill in 8 in the B1 cell; enter the carriage, and then appear in the C1 cell 13. Other calculations are the same, you will calculate the valve formula, such as the above fill in, given the corresponding parameters, the same can be calculated.

Share to: