Excel Bootcamp 4a @LearnChemE

Uploaded October 2024 | Updated September 2026, 1 week ago

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

0:00 Introduction
3:00 Ammonia synthesis
3:51 Modeling - simplified model
19:03 Simplified model spreadsheet
28:03 Using VBA
37:23 Full model introduction
40:40 Full model spreadsheet
46:55 Using VBA

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

Adiabatic, Reversible Compression of an Ideal Gas with Temperature-Dependent Heat Capacity: Example

Viscous Flow in Two Connected Pipes Digital Experiment

Measure Vapor Liquid Equilibrium Virtual Laboratory

Fugacity Dependence on Temperature in an Ideal Binary Mixture (Interactive Simulation)

Adiabatic Reversible Expansion and Compression (Interactive Simulation)

Forces on a Completely-Submerged Gate (Interactive Simulation)

$How Accurate is the Shortcut Vant Hoff Method for Chemical Equilibrium? Organized by textbook: https://learncheme.com/ Uses a spreadsheet (https://learncheme.com/student-resources/excel-files/) that uses Gibbs minimization to compare the equilibrium mole fractions for the reaction 0.5N2 + 1.5H2 to NH3 for two approaches: (1) a temperature-dependent heat of reaction, and (2) a constant heat of reaction. Made by faculty at the University of Colorado Boulder, Department of Chemical & Biological Engineering. Check out our Thermodynamics playlists here: https://www.youtube.com/user/LearnChemE/playlists?view=50&sort=dd&shelf_id=11 Also see our website for screencasts organized by textbook: http://www.learncheme.com/screencasts/thermodynamics Interactive Thermodynamics simulations are here: https://learncheme.com/simulations/thermodynamics/thermo-1/$

T-x-y Phase Diagram Explanation for Immiscible Liquids

Addition Polymerization in CSTR: Spreadsheet