Download Flow of Fluids Excel Workbook Video Tutorials Courses

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

Course details

  • 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
4.7/5 - (25 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *