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.

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)