Это видео недоступно.
Сожалеем об этом.
Create Excel Function to calculate pipe size using VBA
HTML-код
- Опубликовано: 1 авг 2024
- Let's write a function in Excel VBA to directly calculate the pipe sizing based on the fluid data, velocity and pressure drop criteria, and pipe standard sizes.
Excel VBA for Chemical Engineers
boostrand.com/excel-vba
Pipe Sizing Calculation for Proces Engineers
boostrand.com/pipe-sizing
Introduction to Process Engineering
boostrand.com/free-course
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Introduction
1:00 - Calculating Minimum Pipe Diameter
2:18 - Calculating Pressure Drop
2:57 - Defining Function Parameters
3:53 - Setting Default Parameters
5:38 - Calculating Preliminary Pipe Area
6:43 - Calculating Preliminary Diameter
7:44 - Output Preliminary Diameter
8:41 - Using XLOOKUP for Nominal Diameter
10:26 - Matching Schedule in Table
12:25 - Converting Column Number to Letter
14:16 - Finalizing Function with XLOOKUP
16:18 - Adjusting Range in Function
18:45 - Debugging and Corrections
20:45 - Calculating New Velocity and Pressure Drop
21:37 - Defining Pressure Drop Function
24:17 - Adjusting Criteria and Loop Implementation
26:41 - Implementing While Loop for Diameter Adjustment
28:31 - Final Function Check and Corrections
29:16 - Conclusion and Recap