Flow of Fluids Excel Workbook Video Tutorials Courses by udemy simulates 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.

What you’ll 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

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

Who this course is for:

• Chemical, Process, Petroleum Engineers
• Design Engineers
• Piping Engineers
• Plant Engineers
• Facility Managers
• Maintenance Technicians
• Mechanics
• Plant Operators
• Safety Engineers

### Course content

• 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
• 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
• 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

Course Detail

• Movie quality: MP4 | Video: h264, 1280 × 720
• Audio quality: Audio: AAC, 44.1 KHz, 2 Ch
• Movie duration: 1h 5 m
• Number of lessons:  18 lectures
• Language: English
• Compressed file size: 800 MB