Spreadsheet PokerSpreadsheet PokerThe Spreadsheet Poker is an Excel Add-In developed in Visual Basic for Applications (VBA) primarily for use in working with Argonne National Laboratory's GREET model. I developed the Poker specifically to streamline large-scale modifications to GREET such as those performed for California, New York, and other state governments to "regionalize" the national GREET model to their specific contexts. While there is some GREET-specific functionality in the Add-In, the core functionality can be used equally well with other spreadsheets. The Poker allows you to define, in a separate spreadsheet, a series of updates to apply to an external spreadsheet (e.g., GREET), thereby making these updates easily reproducible and self-documenting. The alternative, brute-force approach of directly modifying the GREET spreadsheet often results in multiple copies of modified versions of GREET in which modifications are very difficult to reproduce reliably. Downloads
|