Excel spreadsheet files
Spreadsheet files are listed in dark blue. Corresponding screencasts are listed in light blue. Click the spreadsheet to download it. Click the screencast to view it on YouTube. Hover your mouse over each screencast to read a description.
- NLR for Enzyme Kinetics Using Solver and NLR for Enzyme Kinetics 2nd Method CL
Nonlinear Regression to Determine Michaelis-Menten Kinetics Parameters Using Excel Solver
Nonlinear Regression to Determine Confidence Limits for Michaelis-Menten Kinetics Parameters Using Excel
Nonlinear Regression for Enzyme Kinetics – Second Method for Confidence Limits - Activation Energy Calculation Using Solver
Determine Activation Energy Using Nonlinear Regression with Excel Solver
Calculate 95% Confidence Intervals for Nonlinear Regression in Excel, Part 1
Calculate 95% Confidence Intervals for Nonlinear Regression in Excel, Part 2 - NLR to Fit 2 Parameters from PFR Data
Determine Kinetic Parameters from Isothermal Plug Flow Reactor, Part 1: Overview
Determine Kinetic Parameters from Isothermal Plug Flow Reactor, Part 2: Excel Calculations
Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 3: Excel Spreadsheet
Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 4: Confidence Limits - NLR to Fit PFR Data – Change FA0/FB0/P
- Analyze VCRL Data
Analyze data from Virtual Catalytic Reactor Laboratory (VCRL)
- Determing Marules Parameters from VLE Data (Excel file only available to instructors)
- Gibbs Free Energy as a Function of Temperature
Calculate Gibbs Free Energy Change for a Reaction at Elevated Temperature
Gibbs Free Energy of Reaction Spreadsheet - Plot Gibbs Free Energy vs Reaction Extent
Gibbs Free Energy of a Chemical Reaction as a Function of Temperature
- WGS Chemical Equilibrium by Gibbs Minimization
- Multiple Reactions Chemical Equilibrium by Gibbs Minimization
Multi Reaction Chemical Equilibrium Using Gibbs Minimization Spreadsheet
- NH3 Formation – Chemical Equilibrium by Gibbs Minimization
Calculate NH3 Formation Equilibrium Using Gibbs Minimization Spreadsheet
How Accurate is the Shortcut Van’t Hoff Method for Chemical Equilibrium Calculations?
- Bumper cars – Beta and Power
- Burritos_ANOVA_starter
- Bus Tires
- FE Exam data
- HexaneStarter
- Hockey Sticks
- Natural Gas
- Natural Gas – F test
- Old Faithful
- Replicated 2^3 Design
Analyzing a Factorial Design in Minitab
Higher Order Full Factorial Design, Part 2 - Satisfaction Data – Confidence and Prediction Intervals
- Satisfaction Data – starter 1
- Satisfaction Data – starter 2
- T-Distribution Simulation
- Turbine_Data_starter
- UltraMembrane_Factorial_starter
- UltraMembrane_Statistical_starter
- Unreplicated 2^5 Design
- Variance Simulation
- Volvo and Bank Temperatures
- Zirconia Data
Simple Linear Regression Using Least Squares Estimators
Hypothesis Tests for Simple Linear Regression
- Solve a Nonlinear Equation in Excel
- Multiple Nonlinear Equations Using Solver
- Nonideal Osmotic Pressure
Calculate Molecular Weight from Osmotic Pressure for Nonideal Solution
- Ternary Flash
- Energy Balance on a Tank with Steam Feed
- Material Balances on a System with Purge and Recycle
Material Balances on a System with Purge
Material Balances on a System with Purge and Recycle – Spreadsheet
- Steam Tables
Introduction to Steam Tables 2
Properties of Liquid Water in Steam Tables
- Addition Polymerization in a CSTR