I gave a talk to London Business Analytics Group on “Using R And Excel To Explore “What If” Scenarios” recently.
The slide deck from the talk is here.
A zip file of the R sample code for the 2050 project example is here. This include the R code and also a RData object that holds the 2010 emissions data, loaded by the code
I showed the Global Calculator, a model of the world’s energy and food systems implemented as an Excel spreadsheet and also accessible through a web page. To download the spreadsheet or use the web application, start at the Global Calculator landing page.
The spreadsheet that explains and demonstrates the Excel formulae used in the calculator, SUMIFS, INDEX, MATCH and INDIRECT is here.