What would be nice...

[Dean_P]

Shad, I took a shot at the "entire game" stat, using Excel. I've attached the sheet where I have the data for 3 supplements (AFDx, SeWp and PaLe, assume that they're not any errors as I had to enter the dependencies by hand).

If you expand the groups, you can see that the key cells are the ones in column S. I have the dependencies shown by inserting the number 1. Column S checks each column to see if 1) the dependency exists and if it does exist, 2) do you have the game. Note, this doesn't differentiate between maps or counters, but assumes you own the complete game. The code that's repeated for each column is

IF(B4=1,IF($B$2=1,1,0),1)

For each column, that will either return a 1 if you have the game or a 0 if its needed and you don't. It also returns a 1 if the game is not needed. By multiplying the values of all the columns together, you either get a 1 if the scenario is playable or a 0 if it is not (unlike you're example, it doesn't tell you why it isn't playable, but just that it isn't). Then simply summing up column S for each game tells you the number of playable scenarios. Dividing by the number of scenarios gives you the percentage.

The entire equation in cell s4, for example, is
=IF(B4=1,IF($B$2=1,1,0),1)*IF(C4=1,IF($C$2=1,1,0),1)*IF(D4=1,IF($D$2=1,1,0),1)
*IF(E4=1,IF($E$2=1,1,0),1)*IF(F4=1,IF($F$2=1,1,0),1)*IF(G4=1,IF($G$2=1,1,0),1)
*IF(H4=1,IF($H$2=1,1,0),1)*IF(I4=1,IF($I$2=1,1,0),1)*IF(J4=1,IF($J$2=1,1,0),1)
*IF(K4=1,IF($K$2=1,1,0),1)*IF(L4=1,IF($L$2=1,1,0),1)*IF(M4=1,IF($M$2=1,1,0),1)
*IF(N4=1,IF($N$2=1,1,0),1)*IF(O4=1,IF($O$2=1,1,0),1)*IF(P4=1,IF($P$2=1,1,0),1)
*IF(Q4=1,IF($Q$2=1,1,0),1)*IF(R4=1,IF($R$2=1,1,0),1)

I didn't say it wasn't messy... :-)

The nice thing about this is that to check the effect of adding a game to your collection can be instantly realized. For example, for the listed supplements, I can play 65%, 39% and 93% of the scenarios respectively. If I add Cassino to my collection, it only affects PaLe (adding 2 scenarios and taking it to 100%). If I add IrCu, however, the percentage jump for SeWp goes from 39 to 71% (adds 10 playable scenarios).

The big drawback to this is that the dependency data isn't readily available in tabular form and would have to be input. :-(