Spreadsheets Pathway

Author

DOFPro group

Spreadsheets

Spreadsheets quietly power much of modern engineering, and they show up everywhere in DOFPro. This pathway collects the tools that turn spreadsheets from glorified calculators into serious problem-solving engines.

You’ll see basic statistics, linear regression, error propagation, nonlinear regression—and finally three videos introducing DWSIM, an open-source flowsheet simulator that does many of the same jobs, just with more industrial flair.

If you’ve ever thought, “It’s just Excel,” this pathway may respectfully change your mind.

  • Video links go directly to the YouTube video.
  • JTF (Just the Facts) videos are the streamlined versions: greenscreen LaTeX equations, clean graphics, minimal narrative. Think efficient and to the point. Each has a companion TFS video.
  • TFS (The Full Story) videos include interviews, additional explanation, and equations written on whiteboards. Same math, more context, more personality. Each has a matching JTF version.
  • Info Page links lead to definitions, expanded explanations, and related material—because sometimes you really do need to explain it.
  • Visuals links contain the greenscreen or whiteboard materials used in the video, for those who like to see the scaffolding.
  • Wondering about the titles? See Appendix B: If you have to explain it, it’s no longer funny.
  • Videos marked This is NOT a DOFPro video were not produced by DOFPro but are included because they are relevant to the topic. They are shown in red so no one calls the academic integrity police.

Introduction

From Mole to Megawatt: The Full Journey Through Chemical and Thermal Engineering
Intro to DOFPro CTP
Video, Info Page, Visuals

Introduction to Spreadsheets

The Unauthorized Guide to Using Spreadsheets in Chemical Engineering
Spreadsheet Basics
Video, Info Page, Visuals

How to Have a Quickie with Your Data Part 1
\(\bar{x}\), \(S_{\bar{x}}\), Linear Least Squares
Video, Info Page, Visuals

How to Have a Quickie with Your Data Part 2
Nonlinear least squares
Video, Info Page, Visuals

Solving Nonlinear Equations with Spreadsheets
See Title
Video, Info Page, Visuals

Interpol Is Late to a Mind-Blowing Math Hack, Just the Facts
Linear Interpolation
Video, Info Page, Visuals

Interpol Is Late to a Mind-Blowing Math Hack, The Full Story
Linear Interpolation
Video, Info Page, Visuals

No Clear Interpretation a Mind-Blowing Math Hack
Nonlinear Interpolation
Video, Info Page, Visuals

Spreadsheets for Statistics

How Deviant and Mean Are Your Data? Intro and Basics Part 1, Just the Facts
Mean (\(\mu,\ \bar{x}\)) and Standard Deviation (\(\sigma,\ S\))
Video, Info Page, Visuals

How Deviant and Mean Are Your Data? Intro and Basics Part 1, The Full Story
Mean (\(\mu,\ \bar{x}\)) and Standard Deviation (\(\sigma,\ S\))
Video, Info Page, Visuals

How Deviant and Mean Are Your Data? Part 2
Standard Error (\(S_{\bar{x}}\)) and Confidence Interval (\(2\lambda\))
Video, Info Page, Visuals

Basic Statistics on a Spreadsheet
\(\bar{x}\), \(S\), \(S_{\bar{x}}\), \(\lambda\) with a spreadsheet
Video, Info Page, Visuals

This is NOT a DOFPro video.
Linear Regression
Derivation of the equations for linear regression
Video, Info Page

This is NOT a DOFPro video.
Linear Regression Spreadsheet
Performing linear regression with a spreadsheet
Video, Info Page

This is NOT a DOFPro video.
Error Propagation
Propagating errors or uncertainties through equations and calculations
Video, Info Page

This is NOT a DOFPro video.
Integrals and Derivatives Part 1
Propagating errors or uncertainties through numerical integrals and derivatives
Video, Info Page

This is NOT a DOFPro video.
Integrals and Derivatives Part 2
More propagating errors or uncertainties through numerical integrals and derivatives
Video, Info Page

Nonlinear Regression
Derivation/explanation of nonlinear regression
Video, Info Page

DWSIM

Using DWSIM to Create Binary Phase Diagrams
DWSIM, Binary Phase Diagrams
Video, Info Page

Modeling the Rankine Cycle in DWSIM
Modeling the Rankine Cycle in DWSIM
Video, Info Page

Modeling the Vapor Compression Cycle in DWSIM
Modeling the Vapor Compression Cycle in DWSIM
Video, Info Page