Engineering Economy Module
Lecture Notes
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.
|
SES # |
TOPICS |
LECTURE NOTES |
SPREADSHEETS |
|
0 |
Introduction for Excel beginners (optional) |
(PDF) |
Session 0-1 (XLS) Session 0-2 (XLS) |
|
1 |
NPV and sensitivity analysis |
(PDF) |
Session 1-1 (XLS) Session 1-2 (XLS) |
|
2 |
Simulation |
(PDF) |
Session 2-1 (XLS) Session 2-2 (XLS) |
|
3 |
Modeling uncertainties |
(PDF) |
Session 3-1 Part 1 (XLS) Part 2 (XLS) Session 3-2 Part 1 (XLS) Part 2 (XLS) |
|
4 |
Analyzing flexibility and other topics |
(PDF) |
Session 4-1 (XLS) Session 4-2 (XLS) |
Assignments
This section contains a self-assessment exercise that students could use to judge whether they needed to take the course, and an assignment that was due after the end of the course.
The self-assessment exercise was prepared in part by Tao Wang, and is used with permission.
|
ASSIGNMENTS |
|
Excel self-assessment exercise (PDF) |
|
End-of-course assignment (PDF) |
Related Resources
The following resources were prepared by ESD.70J students in past years. Each is courtesy of the student named, and is used with permission.
|
RESOURCES |
|
Tips for using OpenOffice Calc, by Nathan Fleming (PDF) |
|
Excel: Some English to French translations, by Blandine Laurenty (PDF) |