Excel Bootcamp 3c @LearnChemE

Uploaded October 2024 | Updated September 2026, 2 weeks ago

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

0:00 Optimization example
12:45 Golden Section search
27:25 Minimum from VBA
33:21 Example - Optimal grain bin design
41:58 Curve-fitting - polynomial regression
1:01:20 Curve-fitting - multilinear regression
1:29:03 Curve-fitting - nonlinear regression

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

Temperature Changes in an Ideal Gas (Interactive Simulation)

$Henrys Law for Gases Dissolved in Water (Interactive Simulation) Organized by textbook: https://learncheme.com/ Demonstrates how to use an interactive simulation that calculates the mole fractions of gas adsorbed in water as a function of temperature and pressure. The simulation is located at: https://learncheme.com/simulations/thermodynamics/thermo-2/henry-s-law-for-gases-dissolved-in-water/ Made by faculty at the University of Colorado Boulder, Department of Chemical & Biological Engineering. Check out our Thermodynamics playlists: https://www.youtube.com/user/LearnChemE/playlists?shelf_id=11&view=50&sort=dd Check out our website for interactive Thermodynamics simulations: http://www.learncheme.com/simulations/thermodyanmics$

Heating Vapor Liquid Mixtures in Closed Container

T-x-y Diagram for Immiscible Liquids (Interactive Simulation)

Physical Chemistry Interactive Simulations

Phase Diagrams from van der Waals Equation of State (Interactive Simulation)

Compressibility Factor Charts (Interactive Simulation)

Determine Antoine Constants Digital Experiment