Excel Bootcamp 3a @LearnChemE

Uploaded October 2024 | Updated September 2026, 2 weeks ago

The first video in the third series on Excel. See the entire bootcamp here: learncheme.com/bootcamps/excel-bootcamp-1

0:00 Introduction
1:26 Solving single algebraic equations
3:11 Water-gas shift equilibrium
20:07 BiSection
40:03 Using VBA code
55:35 Solving sets of linear equations
1:02:29 Example - Six-stage absorber column
1:08:11 Solving sets of nonlinear algebraic equations
1:13:07 Example - Steam/water equilibrium

Made by David Clough, professor emeritus at the University of Colorado Boulder, Department of Chemical & Biological Engineering.

$Vapor Pressure of Binary Solutions (Interactive Simulation) Organized by textbook: https://learncheme.com/ Demonstrates how to use an interactive simulation that shows how the partial pressures of two components of a binary mixture change with mole fraction of component B. Both ideal and non-ideal behavior are shown. This simulation is located at https://learncheme.com/simulations/thermodynamics/thermo-2/vapor-pressure-of-binary-solutions/ Made by faculty at the University of Colorado Boulder, Department of Chemical & Biological Engineering.$

Lever Rule for a Solid-Liquid Phase Diagram (Interactive Simulation)

Definition of Number-averaged and Weight-averaged Molecular Weights of Polymers

Joule-Thomson Expansion (Interactive Simulation)

Cross-Flow Heat Exchanger Digital Experiment

$Reading a Psychrometric Chart (Interactive Simulation) Organized by textbook: https://learncheme.com/ Demonstrates how to use an interactive simulation for a psychrometric chart to determine dew points, bubble points, wet-bulb temperatures, enthalpies, volumes, and mass fractions of water in air. This simulation is located at https://learncheme.com/simulations/mass-energy-balances/reading-a-psychrometric-chart/ Made by faculty at the University of Colorado Boulder, Department of Chemical & Biological Engineering. Check out our Material and Energy Balances playlists: https://www.youtube.com/user/LearnChemE/playlists?view=50&sort=dd&shelf_id=8 Check out our website for screencasts organized by textbook: http://www.learncheme.com/screencasts/mass-energy-balances$

Enzyme Inhibition Kinetics (Interactive Simulation)