【JST-201】One-on-one assistance office for EXL spreadsheet issues
Thread Content
Technical discussant: waaabc. My areas of expertise include process calculations, etc. Online time per day or week: over 8 hours. Work experience: 10 years or less. Here is the link to my index of calculation tables:Pipelines series: 1 – Pipe diameter calculation table; 2 – Pipe pressure drop calculation table; 3 – Pipe wall thickness calculation table; 4 – Calculation table for reinforcing pipes with openings; 5 – Pipe span calculation table; 6 – Pipe thermal compensation calculation table; 7 – Pipe flexibility analysis table; 8 – Safety valve diameter calculation table; 9 – Valve Kv value calculation table; 10 – Orifice plate calculation table; 11 – Calculation table for two-phase flow of steam condensate; 12 – Query table for allowable stress of steel pipes according to GB50316; 13 – Breather valve calculation table; 14 – Connection fitting load calculation table; 15 – Steam pipe diameter calculation table; 16 – Welding material selection table.
Containers series: I – Design table for thin-walled steel containers; II – Design table for plastic containers; III – Design table for tube sheet heat exchangers; IV – Heat transfer design table for mixing containers; V – Heat transfer calculation table for plate heat exchangers; VI – Heat transfer calculation table for storage tank coils; VII – Oil tank wall thickness calculation table.
Semi-original series: 1 – HG pipe flange size query table; 2 – Saturated steam pressure calculation table; 3 – Specification and dimension table for chemical equipment. If you have any questions about my calculation tables or suggestions for additional tables, feel free to post below, and I will try to respond to everyone as soon as possible~~~
:) A powerhouse, a strong person, a passionate person.
EXCEL spreadsheet update ⒃ — Welding material selection table; feel free to download it~~~
☆Haichuan waaabc☆Container Series☆Ⅰ —— Design tables for thin-walled steel containers, now officially available~~~ Although a fee is charged, this amount is trivial for experienced Haiyu users, right?:P
Original poster, I’m working on a device to stabilize airflow under conditions of excessive pressure, and I was hoping to get your help with it
If you have any questions, feel free to post them in the comments.
My laboratory needs to design a limit flow orifice plate. The basic requirements are as follows: under normal atmospheric conditions and at room temperature, a negative pressure greater than the maximum allowable differential pressure should be created behind the orifice plate, so that an air flow rate of 17.5 ml/s is achieved in front of it. I have no idea how to carry out the calculations and the design; I hope you can help me by determining the parameters of the orifice plate as well as those of its connecting components
Don’t you have my orifice plate calculation sheet? You can control the gas flow velocity at 20–30 m/s; you already know the flow rate, so you can calculate all the other parameters using that sheet
Is the concept of a limit flow control orifice plate such that it responds to changes in differential pressure only when the gas velocity exceeds the speed of sound? I have two concerns: 1. How to determine what that limit differential pressure is, and what negative pressure value should be applied behind the orifice plate (I cannot control the negative pressure precisely, but I can ensure that a negative pressure greater than a certain value is applied). 2. In this case, how should I determine the manufacturing parameters (orifice diameter, thickness, and requirements for the associated piping)?
Thanks for sharing~! ~! ~! ~