I pretty much started here. Since the objective was to migrate from a VBA project to a Google Apps script version of the same, my approach was to write the skeleton, and emulate the underlying classes, modules and libraries. If I was writing this in Apps Script from scratch, I would have written this differently, but using the converted classes from VBA shows just how similar you can make VBA and Apps Script in structure.
The main things I needed to implement in google script to get this going were the data abstraction classes, some kind of GAS alternative to Excel shapes, Google charts, various roadmap specific classes, and of course the finished roadmapper script.
The roadmapper module is implemented in the mcpher library. You can find a workbook with test data in VBA to Google Apps Script Roadmapper project download
The calling script - this would be in your workbook, is just a one liner specifying where to find your parameters and your data.
The rest is implemented in mcpher library in the roadmapper module and looks like this ( or at least it did when I wrote it - latest code will be in mcpher library
Take a look at how the From VBA to Google Apps Script to follow along with the Roadmap Generation migration project. Why not join our forum,follow the blog or follow me on twitter to ensure you get updates when they are available. You can find the code and test data in the VBA to Google Apps Script Roadmapper project download.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > From VBA to Google Apps Script >