Useful stuff for Excel and VBA are listed below....

I rearranged things so that tutorials are first, assignments second, miscellaneous stuff last

 

Discussions and Tutorials About Excel and VBA (right-click and "save target as")

A. Introductions to Different Features in Excel, Word

Functions in Excel : A tutorial on using VBA from Excel to write a function

Working With Figures in Microsoft Word: A little tutorial I wrote to help you bring in your screen captures for any assignment. 

Using Equations in Word: A little tutorial on using the Equation Editor in Word 

Using spreadsheets for Parametric analyses : A Word document discussing the use of spreadsheets for analyzing simple analytical models

B. Specific Topics Covered in the Course

Contaminant Transport Modeling : A Word document discussing contaminant transport equations and their application

Gauss elimination process : A Word document short discussion of Gauss elimination.

gelimdisplay.xls : A spreadsheet to help display the Gauss elimination process

VBA userform demo.xls : A VBA program using userforms, you can use this as a skeleton for doing your own forms 

listbox.xls : Another VBA userforms demo showing combo boxes, command buttons etc....

C. General Information and Suggestions

Comments on Contaminant Transport Homework: A short message 

Some Suggestions About Writing Your Discussions : A little help with your assignment discussions, some things for you to consider 

D. Review Questions for Exams

 

Excel-VBA Assignments (right-click and "save target as")

1.  beamdeflection.xls : The spreadsheet needed for analyzing beam deflection

2.  Contaminant Transport Problem : The assignment for the Contaminant Transport spreadsheet. (You will only need 3 out of the 6 equations we discussed in class)

3 Matrix Multiply.xls : A simple VBA matrix multiplication example. Used for matrix assignment

4 newtonexample.xls : Application of  Newton-Raphson  and Bisection to non-linear equations

5  301Truss.xls  The Real Deal. This is the working copy of Truss analysis. Please download and follow the instructions outlined on the "Assignment" worksheet. Assignment won't be due for a while, but get to work on it, because the dookie will pile up on you soon! Due November 1.

6 Trapezoid .xls : Here is the start of the trapezoid assignment. Due November 1.

 

Message Box Assign.xls : Here is a spreadsheet discussing your message box assignment. 

VBAfancyloop.xls : This is the same example as above, but with some nice color to show the process of matrix multiplication (sort of an animation, but not really)

VBAuserforms.xls This is the userform demo we did in class

Soil Stress-strain.xls : Soil stress-strain spreadsheet

equations.htm : This is where you can copy the greek formula for stress-strain

gelim.xls : Gauss elimination spreadsheet, Used for truss assignment

bef1.xls: Beam on elatic foundation assignment, complete with instructions 

Excel-VBA Programming Examples of Varying Difficulty

newtonexample.xls : Application of  Newton-Raphson  and Bisection to non-linear equations

Resonant Column.xls : Example of using N-R in a real data sheet. I use this for testing in my lab.

Contaminant Transport.xls :1,2-d contaminant transport, not using VBA