David Wood & DWA Energy Limited


One of our key strengths is that we develop and tailor solutions to solve client problems using spreadsheet models driven by VBA macros, where possible. 

Modelling capabilities include: standard and risked cash flow analysis, a wide range of international oil and gas fiscal terms, quantified risk evaluation, debt service, sensitivity, Monte Carlo simulation, genetic optimization and simplex optimization, dynamic decision tree and a range of real and financial options analysis.

Our experience suggests that such "self-build" numerical modeling solutions based on standard spreadsheet software supported by custom built Visual basic for Applications (VBA) macros offer cost effectiveness, algorithm transparency, and provide useful learning and evaluation tools for individual and corporate use. 

The models can be structured to use output from, or provide input to, a large range of software tools commonly used by the industry. We use them routinely in our ongoing research, consulting and training work.

We provide general training for building business models using spreadsheets and VBA macros. This training can be structured for small or large groups, and in some cases delivered on a one-to-one basis at a mutually acceptable location.


Contact us for further details at:
e-mail: info@dwasolutions.com