Engineering Economics

MIT OpenCourseWare http://ocw.mit.edu ESD.70J / 1.145J Engineering Economy Module
Fall 2009

For information about citing these materials or our Terms of Use, visit: http://ocw.mit.edu/terms.

ESD.70J Engineering Economy
Fall 2009
Session Zero
Michel-Alexandre Cardin
Prof. Richard de Neufville

ESD.70J Engineering Economy Module - Session 0

1

Class outline
1. Objective: get you up to speed for
Session 1!
•
•
•
•

Excel versions and languages
Excel basics for ESD.70
Few tricks to speed up analysis
More learning material

ESD.70J Engineering Economy Module - Session 0

2

Excel versions
• Versions currently “in use”
– PC: 2000, XP or 2003, 2007
– Mac: 2004, 2008
– Open source: Open Office Calc (see website)

• Many, many languages
– Chinese, English, French, Japanese, Spanish…
– Obviously cannot support all (see website for handy tips in French and Spanish)
ESD.70J Engineering Economy Module - Session 0

3

Recommended versions
• Class supported in Excel 2007 for PC, and Excel
2004 for Mac
• Why?
– Excel 2007 widely used on PC
– Excel 2008 for Mac does not support Solver and other functionalities required for class

• Make sure you have one of those installed!
• Ask your department for a free copy of software
ESD.70J Engineering Economy Module - Session 0

4

Course Materials
•

Excel spreadsheets
– ESD70session# –1.xls : setup before the class
– ESD70session# –2.xls : reflects all the work done in class
– Do the exercises with me the only way to learn
•

Cells marked as

are for you to fill

– Refer to the ESD70session# –2.xls to validate your work •

Lecture in PDF on course website

ESD.70J Engineering Economy Module - Session 0

5

Excel basics

Open ESD70session0-1.xls

ESD.70J Engineering Economy Module - Session 0

6

Excel basics
• Entering numbers and formulas
• Working with multiple sheets
• Manual vs. automatic calculations

ESD.70J Engineering