Text-based data files

ConcentrationData.txt – text file, set of concentration data
FurnaceData.txt – text file, set of furnace fuel rate and flue gas CO₂ vs. time 

Excel Workbook files

AnalyticalFunctionStarter.xlsx – starter spreadsheet for creating plots of analytical function
BlockData.xlsx – set of data for illustrating use of names for blocks of data
H2SO4VaporPressureStarter.xlsx – vapor pressure of concentrated sulfuric acid vs. temperature
HaalandMoodyStarter.xlsx – starter spreadsheet for table of Moody friction factors
NaClDensityStarter.xlsx -density of NaCl aqueous solutions vs. wt% and temperature
SelectionPractice.xlsx – blocks of numbers

ArrayExamples.xlsm – arrays illustrating base zero and base one indexing
FindMaxLocation.xlsm – function to find the location of the maximum value in an array
ForNextCaseStudy1.xlsm– Sub to illustrate For-Next loop index count up
ForNextCaseStudy2.xlsm – Sub to illustrate For-Next loop index count down
Sqrt1Function.xlsm – user-defined function to compute the square root 

TemperatureStandardAtmosphere.xlsm – user-defined function for atmospheric temperature given altitude
TempOut.xlsm – temperature conversion Sub with menu-based Select Case structure

Absorber.xlsx – solution of linear equations
AntoineFinished.xlsx – nonlinear regression of H2SO4 data to fit Antoine equation
AntoineStarter.xlsx – starter file for Antoine equation nonlinear regression
BatchReactorSingleEqnStarter.xlsx – starter spreadsheet for solving single ODE – simple batch reactor
CounterCurrentHeatExchanger.xlsm – solution of multiple ODEs with split boundary conditions – countercurrent heat exchanger

EulerMethod.xlsx – use of Euler method to solve single ODE – simple batch reactor
GrainBin.xlsx – optimization of grain bin design
HumpsOptimizationStarter.xlsx – starter file for humps function optimization
LinearEquationsStarter.xlsx – starter spreadsheet for solution of a set of linear algebraic equations
MethanolWaterDensity.xlsx – polynomial regression of methanol-water data

MethanolWaterDensityStarter.xlsx – starter file for density of methanol-water solutions vs. wt% methanol at 20 degC
MultipleReactionsEulerMehod.xlsx – use of Euler method to solve multiple ODEs – isothermal batch reactor
MultipleReactionsEulerMethodStarter.xlsx – starter spreadsheet for solving multiple ODEs – isothermal batch reactor
NaClDensityDataAnalysisRegression.xlsx – Data Analysis Regression tool applied to NaCl data
NaClDensityRegressionFinished.xlsx – on-sheet matrix-based regression applied to NaCl data

NaClDensityRegressionStarter.xlsx – starter spreadsheet for regression of NaCl data
SecondOrderODE.xlsx – solution of second-order ODE with split boundary conditions
SecondOrderODEStarter.xlsx – starter file for second-order ODE with split boundary conditions
SteamEquilibriumSolverFinish.xlsx – solution of steam/water equilibrium nonlinear equations using the Solver
SteamEquilibriumStarter.xlsx – starter spreadsheet for steam/water equilibrium nonlinear equations

water-gas_bisectiontable.xlsx – on-sheet implementation of bisection method for water-gas equilibrium
water-gas_bisectionUDF.xlsm – user-defined function of bisection method and solution of water-gas equilibrium
water-gas_starter.xlsx – starter spreadsheet for water-gas equilibrium calculation

AcetonePFRFullModel.xlsm – Full model of acetone-cracking plug flow reactor with countercurrent heat exchange
AcetonePFRSimplifiedModel.xlsm – Simplified model of acetone-cracking plug flow reactor with countercurrent heat exchange
AmmoniaSimulationFullModel.xlsm – Full model of ammonia synthesis packed-bed reactor
AmmoniaSimulationSimplifiedModel.xlsm – Simplified model of ammonia synthesis packed-bed reactor