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 classessome kind of GAS alternative to Excel shapesGoogle 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

Roadmapper in Google Apps Script

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

Transitioning is covered more comprehensively in my my book, Going Gas – from VBA to Apps script, available All formats are available now from O’Reilly, Amazon and all good bookshops. You can also read a preview on O’Reilly.