Building a Parametric Excel Spreadsheet (from scratch) for Easy Scenario Analysis

So, what is a parametric spreadsheet?

Valid question. In comparison to a static/base case/deterministic spreadsheet, a parametric spreadsheet is set up in such a way that key parameters and assumptions can be changed without invalidating the underlying calculations. So if you've found that your project is delayed by a year or that CAPEX is higher than anticipated -- you can incorporate these changes into your spreadsheet without breaking everything and instantly see how they affect value.

Lights, Camera, Action! Watch Syncopation's DPL, DPMX, and Decision Analysis Video Tutorials

We've always championed a "model in DPL as you learn" approach within our software documentation, resources, and training courses. A couple of years ago Syncopation took this to another level by creating our own YouTube channel so we could offer tutorial-style, screencast videos (narrated, recorded, and edited by your's truly) for those who prefer this mode of learning over traditional paper/PDF user guides. We've built up quite a collection -- so if you haven't checked Syncopation's YouTube channel, I'd encourage you to do so.

Subscribe to Videos