Excel-Visual Basic Assignments

(This page contains the assignment readings and spreadsheets for most of your work in Eciv 201)

Introduction

You may want to also use the companion page on Using Excel-VBA.

1. Beam Parametric Analysis

Using spreadsheets for Parametric analyses html  pdf

This is the companion spreadsheet that I used in the assignment

Beamdeflectionvalues.xls  Right-click and save-as

This is the spreadsheet we will use in class

BeamDeflectionExercise.xlsm Right-click and save-as

If you are unfamiliar with using Visual Basic in Excel, take a look a the little tutorial on the Using Excel and VBA Page. It shows how to construct a Visual Basic Function that the user can call from Excel as a User Defined Function. It's a good starting point

 2. Contaminant Transport

Here is a short discussion on Contaminant Transport Modeling

Here is a start of your PDF file, right-click, save-as, Problem Statement for Contaminant Transport

Here is your Contaminant Transport Spreadsheet

3. Matrix Multiply Spreadsheet

Listed below is the matrix multiply spreadsheet we worked on in class, give it a try.

Matrix Multiply   

Use these spreadsheets to start with. Finish it by performing matrix addition in a routine and write out the answer back to the spreadsheet

Then perform matrix multiplication in another routine and write out the answer

4. Gauss Elimination Assignment and Spreadsheet

Gauss Elimination Spreadsheet              Gauss Assignment

5. Beam on Elastic Foundation

Beam Elastic Spreadsheet

6. Here is where the Bisection Spreadsheet is

Bisection Spreadsheet    Spreadsheet Assignment Discussion

7. Integration Assignment is Here

Integration Spreadsheet and Assignment

7. VBA Programming Assignment is Here

VBA Programming Assignment

8. Truss Problem Spreadsheet

Download this bad boy for work on Friday....try it out a little.

Truss Spreadsheet 2009

9. Shapes and stiffnesses Exercise

ShapesSpreadsheet     Beam Matrix Handout

Some Trusses for your viewing pleasure (courtesy US Military Academy)

http://www.eecs.usma.edu/bridgecontest/pdfs/appendb.pdf

Here is where the Gauss Quadrature Spreadsheet is

Gauss Quadrature Spreadsheet

Here is where the Beam on Elastic Foundation Spreadsheet is

Here is where the Linear Regression Spreadsheet is

Linear Regression Spreadsheet

Here is the final project spreadsheet with instructions

Final Project Spreadsheet