• for

Courses:

Engineering Economy Module >> Content Detail


Table of Contents



Lecture Notes



Lecture Notes

Special software is required to use some of the files in this section: .xls.

This course is built around recitation-style sessions, in which lecture material alternates with students trying out the spreadsheet techniques they are learning. There are two versions of each spreadsheet, one set up before the class for the students to work in (session 1-1, for example), and one that reflects the completed work (session 1-2).

The material in this section will be updated periodically on Professor de Neufville's ESD.70J Web site.


DAY #TOPICSLECTURE NOTESSPREADSHEETS
1

NPV and sensitivity analysis


Objective: set up spreadsheet properly for efficiency, set up charts, and understand sensitivity analysis by Data Table

(PDF)

Session 1-1 (XLS)

Session 1-2 (XLS)

2

Simulation


Objective: random number generator (using simple even distribution), how to count, and simulate

(PDF)

Session 2-1 (XLS)

Session 2-2 (XLS)

3

Modeling uncertainties


Objective: generation of advanced distribution of random variables and the statistical package to analyze available data

(PDF)

Session 3-1, part 1 (XLS)

Session 3-1, part 2 (XLS)

Session 3-2, part 1 (XLS)

Session 3-2, part 2 (XLS)

4

Analyzing flexibility and other


Objective: what-if analysis and building contingency rules (flexibility) into the spreadsheet, and further

(PDF)

Session 4-1 (XLS)

Session 4-2 (XLS)


 








© 2010-2021 OpenCollege.com, All Rights Reserved.
Open College is a service mark of AmeriCareers LLC.