#### 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 F
_{A0}/F_{B0}/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

- NH
_{3}Formation – Chemical Equilibrium by Gibbs MinimizationCalculate NH

_{3}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