[attachment=290]A couple months ago, Andrew posted the file that shows the interdependencies between PG games and supplements. I took that file and created what I hope is a useful spreadsheet. The sheet allows the user to add the games and supplements that they own and see how many of the scenarios are playable.
The sheet requires one to enter on the top row (from column G on to the right) a "yes" for those games you own in the appropriate column. It then automatically calculates the total number of playable scenarios you have, how many senarios depend on a given game/supplement and how many scenarios of a given game/supplement you can play given the inventory you have entered.
One thing I've not figured out how to do is the "what if" of which supplement increases the playable scenarios the most. I have an idea on how to do it, but would like to gauge interest in such a tool first. NEW! The Macro-enabled version of the sheet will now calculate the number of scenarios you can play if you were to add each of the games not already owned.
The big downside to this is that the file is big (over 6MB Ver 1-1 is over 7.9MB). I created it using Excel '10, and while I didn't use macros, I cannot guarantee the conditional formatting will work in other spreadsheets.
NEW for Version 1-1: All scenarios are now hyperlinked to PG-HQ. If you click on the scenario hyperlink (Column B) it will take you to the corresponding page. If you click on the Game Hyperlink (row 6) it will take you to the corresponding Game page. ENJOY!
NEW for Version 2: xlsx file has Saipan 1944 added. The xlsm file calculates using a macro how many more scenarios you can play if you add any game you don't currently own.
[color=#32CD32]
