Flow of Fluids Excel Workbook
Flow of Fluids Excel Workbook, available at $34.99, has an average rating of 4.5, with 18 lectures, based on 147 reviews, and has 1517 subscribers.
You will learn about Determine the main physical properties of fluids (viscosity, vapor pressure, specific gravity, weight density…) Assess the theory of flow in pipe : Laminar vs Turbulent flow Use the Bernoulli Theorem to calculate pressure drop, head loss or flow velocity Calculate the pressure drop "dP" and the head loss "hL" through any piping system Determine the friction factor "f" of any piping system Calculate the flow of compressible and incompressible fluids in pipe Calculate the resistance coefficient "K" of any piping component (pipes, valves, bends, reducers, Tees, Wyes…) Calculate the flow coefficient "Cv" of a control valve and use it in assessing flows and pressure drops Size and select a control valve when designing and operating any piping system for both gases and liquids Calculate the flow of compressible and incompressible fluids through Orifice Plates, Flow Nozzles and Venturi Meters Size and select a flow meter when designing and operating any piping system for both gases and liquids This course is ideal for individuals who are Chemical, Process, Petroleum Engineers or Design Engineers or Piping Engineers or Plant Engineers or Facility Managers or Maintenance Technicians or Mechanics or Plant Operators or Safety Engineers or Recent College Graduates It is particularly useful for Chemical, Process, Petroleum Engineers or Design Engineers or Piping Engineers or Plant Engineers or Facility Managers or Maintenance Technicians or Mechanics or Plant Operators or Safety Engineers or Recent College Graduates.
Enroll now: Flow of Fluids Excel Workbook
Summary
Title: Flow of Fluids Excel Workbook
Price: $34.99
Average Rating: 4.5
Number of Lectures: 18
Number of Published Lectures: 18
Number of Curriculum Items: 18
Number of Published Curriculum Objects: 18
Original Price: €119.99
Quality Status: approved
Status: Live
What You Will Learn
- Determine the main physical properties of fluids (viscosity, vapor pressure, specific gravity, weight density…)
- Assess the theory of flow in pipe : Laminar vs Turbulent flow
- Use the Bernoulli Theorem to calculate pressure drop, head loss or flow velocity
- Calculate the pressure drop "dP" and the head loss "hL" through any piping system
- Determine the friction factor "f" of any piping system
- Calculate the flow of compressible and incompressible fluids in pipe
- Calculate the resistance coefficient "K" of any piping component (pipes, valves, bends, reducers, Tees, Wyes…)
- Calculate the flow coefficient "Cv" of a control valve and use it in assessing flows and pressure drops
- Size and select a control valve when designing and operating any piping system for both gases and liquids
- Calculate the flow of compressible and incompressible fluids through Orifice Plates, Flow Nozzles and Venturi Meters
- Size and select a flow meter when designing and operating any piping system for both gases and liquids
Who Should Attend
- Chemical, Process, Petroleum Engineers
- Design Engineers
- Piping Engineers
- Plant Engineers
- Facility Managers
- Maintenance Technicians
- Mechanics
- Plant Operators
- Safety Engineers
- Recent College Graduates
Target Audiences
- Chemical, Process, Petroleum Engineers
- Design Engineers
- Piping Engineers
- Plant Engineers
- Facility Managers
- Maintenance Technicians
- Mechanics
- Plant Operators
- Safety Engineers
- Recent College Graduates
Dear students,
To accompany our course on Flow of fluids through pipe, fittings, valves and pumps and help you assess flow of liquids and gases, calculate pressure drops, size pipes, control valves and flow meter devices, we have developed an Excel VBA based engineering tool :
Flow of Fluids Excel Workbook
Flow of Fluids Excel Workbooksimulates the operation of small piping systems transporting liquids and industrial gases under a variety of operating conditions.
Flow of Fluids Excel Workbook is based on industry recognized principles and standards from ASME, HI, IEC, AWWA, ISA, and ANSI…
Flow of Fluids Excel Workbookis easy-to-use and has a highly intuitive user interface.
Flow of Fluids Excel Workbook presents formulas and data for :
1.Physical properties determination for a variety of fluids (specific gravity, viscosity, vapor pressure…)
2. Pressure drop and head loss calculations through pipes, fittings and valves
3. Flow calculations for incompressible and compressible fluids through pipes, fittings, valves and pumps
4. Sizing piping systems for incompressible and compressible fluids
5.Flow resistance coefficients calculations for pipes, fittings and valves
6.Flow calculations for incompressible and compressible fluids through flow meters (Orifice Plates, Nozzles and Venturi meters)
7. Centrifugal pump calculation (Pump head, NPSH, Specific speed, affinity laws…)
8. Converting variables and process parameters to a numerious alternative units of measurement
INSTRUCTION TO DOWNLOAD FLOW OF FLUIDS EXCEL WORKBOOK :
1. Upon enrolling in, expand the first section “ABOUT THE FLOW OF FLUIDS”
2. Under the lecture “Presentation”, click on the folder “resources” => A list of 3 downloadable files will appear
3. Click on “Flow of Fluids Excel Workbook”
4. A download window will open. Select the location where you want to save the Excel file
5. Once downloaded and saved on your computer, you can start using the file
IMPORTANT NOTE :
The video lectures included in this materiel are quick tutorials to show you how to use the Flow of Fluids Excel Workbook.
Please watch these videos and follow the instructions provided. In case of any problem, feel free to ask us for help in the Q&A section.
This Excel workbook includes Visual Basic for Application function subroutines. Macros must be enabled for them to work
ENJOY THIS AMAZING TOOL 🙂
—————————————————————————————————————————
FLOW OF FLUIDS EXCEL WORKBOOK : TABLE OF CONTENT
An Excel VBA based engineering tool by WR Training
A. PHYSICAL PROPERTIES OF FLUIDS
1 PROPERTIES OF WATER AND STEAM
a. SATURATION PROPERTIES WITH TEMPERATURE
b. SATURATION PROPERTIES WITH PRESSURE
c. PROPERTIES GIVEN PRESSURE AND TEMPERATURE
d. PROPERTIES GIVEN PRESSURE AND ENTHALPY
2 DYNAMIC VISCOSITY OF GASES
3 KINEMATIC VISCOSITY
4 WEIGHT DENSITY OF LIQUIDS
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
5 SPECIFIC GRAVITY OF LIQUIDS
a. FORMULA 1
b. FORMULA 2
6 SPECIFIC GRAVITY – DEG API
7 SPECIFIC GRAVITY – DEG BEAUME
8 SPECIFIC VOLUME
9 WEIGHT DENSITY OF IDEAL GASES
10 WEIGHT DENSITY OF REAL GASES
11 GAS COMPRESSIBILITY FACTOR
12 SPECIFIC GRAVITY OF GASES
13 BOILING POINT PURE COMPONENT
14 VAPOR PRESSURE : PURE COMPONENT
15 VAPOR PRESSURE : MIXTURE
B. NATURE OF FLOW IN PIPE
1 RATE OF FLOW AT FLOWING CONDITION
a. FORMULA 1
b. FORMULA 2
2 RATE OF FLOW (gpm)
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
3 MEAN VELOCITY OF FLOW IN PIPE
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
4 REYNOLDS NUMBER
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
d. FORMULA 4
e. FORMULA 5
f. FORMULA 6
g. FORMULA 7
C. BERNOULLI’S THEOREM
1 TOTAL HEAD OR FLUID ENERGY
2 LOSS OF STATIC PRESSURE HEAD (hL) DUE TO FLUID FLOW
D. HEAD LOSS, PRESSURE DROP AND FRICTION FACTOR THROUGH PIPE
1 LOSS OF STATIC PRESSURE HEAD
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
d. FORMULA 4
e. FORMULA 5
f. FORMULA 6
2 PIPE PRESSURE DROP
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
d. FORMULA 4
e. FORMULA 5
f. FORMULA 6
g. FORMULA 7
3 PRESSURE DROP FOR LAMINAR FLOW ACCORDING TO POISEUILLE’S LAW
4 PRESSURE DROP FOR TURBULENT FLOW ACCORDING TO HAZEN-WILLIAMS FORMULA
5 FRICTION FACTOR FOR LAMINAR FLOW
6 FRICTION FACTOR FOR TURBULENT FLOW
a. COLEBROOK EQUATION
b. SERGHIDE EQUATION
c. SWAMEE-JAIN EQUATION
E. GAS CALCULATIONS
1 PERFECT GAS LAW
a. DETERMINING THE NUMBER OF MOLES OF A PERFECT GAS
b. DETERMINING THE PRESSURE OF A PERFECT GAS
c. DETERMINING THE TEMPERATURE OF A PERFECT GAS
d. DETERMINING THE VOLUME OF A PERFECT GAS
2 NON-IDEAL GAS LAW
a. DETERMINING THE NUMBER OF MOLES OF A NON-IDEAL GAS
b. DETERMINING THE PRESSURE OF A NON-IDEAL GAS
c. DETERMINING THE TEMPERATURE OF A NON-IDEAL GAS
d. DETERMINING THE VOLUME OF A NON-IDEAL GAS
3 STANDARD ◄►ACTUAL GAS FLOW
F. COMPRESSIBLE FLOW IN STRAIGHT HORIZONTAL PIPELINE
1 COMPLETE ISOTHERMAL EQUATION
G. GAS PIPELINES : MASS FLOW RATE EQUATION
H. HORIZONTAL GAS PIPELINES : STANDARD VOLUMETRIC FLOW RATE EQUATIONS
1 GENERAL STANDARD VOLUMETRIC FLOW RATE
2 WEYMOUTH STANDARD VOLUMETRIC FLOW RATE EQUATION FOR SIZING HORIZONTAL GAS PIPELINES IN FULLY TURBULENT FLOW
3 PANHANDLE “A” STANDARD VOLUMETRIC FLOW RATE EQUATION FOR SIZING HORIZONTAL GAS PIPELINES IN PARTIALLY TURBULENT FLOW
4 PANHANDLE “B” STANDARD VOLUMETRIC FLOW RATE EQUATION FOR SIZING HORIZONTAL GAS PIPELINES IN FULLY TURBULENT FLOW
I. ELEVATED GAS PIPELINES : STANDARD VOLUMETRIC FLOW RATE EQUATION
J. LIQUID FLOW THROUGH ORIFICES
K. LIQUID FLOW THROUGH ISA 1932 NOZZLES
L. LIQUID FLOW THROUGH LONG RADIUS NOZZLES
M. LIQUID FLOW THROUGH VENTURI NOZZLES
N. LIQUID FLOW THROUGH VENTURI METERS
O. GAS FLOW THROUGH ORIFICES
P. GAS FLOW THROUGH ISA 1932 NOZZLES
Q. GAS FLOW THROUGH LONG RADIUS NOZZLES
R. GAS FLOW THROUGH VENTURI NOZZLES
S. GAS FLOW THROUGH VENTURI METERS
T. RESISTANCE COEFFICIENT FOR PIPES, VALVES AND FITTINGS
1 CONTRACTION
2 ENLARGEMENT
3 GATE VALVES
4 GLOBE AND ANGLE VALVES
5 SWING CHECK VALVES
6 LIFT CHECK VALVES
7 TILTING DISC CHECK VALVES
8 STOP CHECK VALVES
9 FOOT VALVES WITH STRAINER
10 BALL VALVES
11 BUTTERFLY VALVES
12 DIAPHRAGM VALVES
13 PLUG VALVES
14 MITRE BENDS
15 90° PIPE BEND AND FLANGED OR BW 90° ELBOWS
16 MULTIPLE 90° PIPE BENDS
17 CLOSE PATTERN RETURN BENDS
18 STANDARD ELBOWS
19 PIPE ENTRANCE
20 PIPE EXIT
21 TEES AND WYES – CONVERGING FLOW
22 TEES AND WYES – DIVERGING FLOW
23 ORIFICES, NOZZLES AND VENTURIS
U. HEAD LOSS AND PRESSURE DROP THROUGH VALVES AND FITTINGS
1 LOSS OF STATIC PRESSURE HEAD
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
2 PIPE PRESSURE DROP
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
V. FLOW OF FLUIDS THROUGH VALVES, FITTINGS AND PIPE
1 LIQUID FLOW THROUGH A VALVE, FITTINGS AND PIPE
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
d. FORMULA 4
e. FORMULA 5
f. FORMULA 6
g. FORMULA 7
2 GAS FLOW THROUGH A VALVE; FITTINGS AND PIPE
a. FORMULA 1
b. FORMULA 2
c. FORMULA 3
3 VALVE FLOW COEFFICIENT “Cv”
a. FORMULA 1
b. FORMULA 2
4 VALVE RESISTANCE COEFFICIENT “K”
W. CALCULATIONS FOR CENTRIFUGAL PUMP
1 PUMP HEAD
a. HEAD FORMULA
b. PUMP IN SUCTION HEAD
c. PUMP IN SUCTION LIFT
2 PUMP DISCHARGE PRESSURE
3 NET POSITIVE SUCTION HEAD REQUIRED
4 NET POSITIVE SUCTION HEAD AVAILABLE
5 TOTAL DYNAMIC HEAD
6 SUCTION SPECIFIC SPEED (Nss)
7 SPECIFIC SPEED (Ns)
X. PUMP AFFINITY LAWS
1 IMPACT OF SPEED ON FLOW
2 IMPACT OF SPEED ON HEAD
3 IMPACT OF SPEED ON BHP
4 IMPACT OF IMPELLER DIAMETER ON FLOW
5 IMPACT OF IMPELLER DIAMETER ON HEAD
6 IMPACT OF IMPELLER DIAMETER ON BHP
7 PUMP BRAKE HORSPOWER
8 PUMP EFFICIENCY
Y. FLOW OF WATER THROUGH SCHEDULE 40 STEEL PIPE
1 CALCULATIONS FOR PIPE OTHER THAN SCHEDULE 40
Z. FLOW OF AIR THROUGH SCHEDULE 40 STEEL PIPE
1 CALCULATIONS FOR PIPE OTHER THAN SCHEDULE 40
2 CALCULATIONS FOR OTHER SET OF TEMPERATURE AND PRESSURE
3 FROM STANDARD TO ACTUAL VOLUME FLOW
ZZ. CONVERSION TABLES
1 LENGTH
2 AREA
3 VOLUME
4 VELOCITY
5 MASS
6 MASS FLOW RATE
7 VOLUMETRIC FLOW RATE
8 FORCE
9 PRESSURE AND LIQUID HEAD
10 ENERGY, WORK AND HEAT
11 POWER
12 WEIGHT DENSITY
13 TEMPERATURE
14 DYNAMIC VISCOSITY
15 KINEMATIC VISCOSITY
DISCLAIMER
This software is provided by WR Training “as is” and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the Copyright owner or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services, loss of use, data, or profits, or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this software, even if advised of the possibility of such damage.
Course Curriculum
Chapter 1: ABOUT THE FLOW OF FLUIDS
Lecture 1: Presentation
Chapter 2: USING THE FLOW OF FLUIDS
Lecture 1: Determining fluid viscosity
Lecture 2: Determining the weight density of liquids
Lecture 3: Determining the weight density of gases
Lecture 4: Determining the specific gravity
Lecture 5: Determining the vapor pressure
Lecture 6: Determining the velocity of flow
Lecture 7: Determining the Reynolds number
Lecture 8: Determining the friction factor
Lecture 9: Determining the expansion factor "Y" & ∆P
Lecture 10: Determining the resistance coefficient for contraction & enlargement
Lecture 11: Determining the resistance coefficient of valves
Lecture 12: Determining the resistance of bends
Lecture 13: Determining the resistance of "Tees" and "Wyes"
Lecture 14: Determining the discharge coef. "Cd" of orifice plates, flow nozzles & Venturi
Lecture 15: More charts and diagrams… The Chemical Engineer's Reference Folder 1
Lecture 16: More charts and diagrams… The Chemical Engineer's Reference Folder 2
Lecture 17: Bonus
Instructors
-
WR Training
Petroleum Petrochemical & Chemical Engineering
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 8 votes
- 3 stars: 17 votes
- 4 stars: 52 votes
- 5 stars: 68 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024