Excel files
Download these files to follow along with the screencasts or just for your use.
Bootcamp 1
Bootcamp 2
Bootcamp 3
Bootcamp 4
Bootcamp 1
Text-based data files
ConcentrationData.txt – text file, set of concentration data
FurnaceData.txt – text file, set of furnace fuel rate and flue gas CO2 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
Bootcamp 2
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
Bootcamp 3
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
Bootcamp 4