| Title | Author/Source | Excel Focus | Best For | |-------|---------------|-------------|-----------| | Engineering Economic Analysis (14th Ed.) – Excel Supplement | Newnan, Lavelle, Eschenbach | Detailed chapter-by-chapter Excel models | FE Exam prep | | Spreadsheet Modeling in Engineering Economy | Park (via Pearson) | Companion PDF to textbook | Graduate-level cases | | Using Excel for Engineering Economics Problems | University of Texas, Austin (free) | 50+ solved problems with files | Self-study | | Practical Engineering Economics: Excel Case Studies | Oregon State OER | Real projects (solar, pumps, conveyors) | Applied learning | | FE Reference Handbook (NCEES) – Economics section | NCEES (free PDF) | Summarized formulas | Review before exams |
Mastering these seven core functions allows engineers to solve nearly any standard equivalency problem: Engineering Economics Formulas Excel applied engineering economics using excel pdf
These functions allow you to avoid manual interpolation and error-prone tables. More importantly, they enable —changing one input (e.g., interest rate or maintenance cost) and instantly seeing the effect on NPV. | Title | Author/Source | Excel Focus |
Always identify multiple viable solutions to a problem. While hand calculations and interest tables were once
While hand calculations and interest tables were once standard, has become the industry standard for its ability to reduce computation errors and streamline complex "what-if" scenarios.
Applied engineering economics is the practical use of economic analysis to choose among alternative engineering projects. Unlike pure economics, which deals with broad market behaviors, applied engineering economics focuses on tangible decision-making for engineers. Key topics include: