Wishlist: Spreadsheet Of Statistics For Tanks

[Mobhack]

Originally Posted by jeffreywilens

I was wondering if there is an existing spreadsheet that lists the major weapons systems (primarily tanks and IFVs) used inthe game that can be used as a ready references to compare the Russian tanks versus the American tanks on the various capabilities. For example, one could scan through and see what systems are capable of punching the front armor on an M1A2 for example by noting the armor values for steel and heat and comparing that to the penetration values for various weapons.

You could run through each OOB in mobhack and export as .csv then read the csvs into a spreadsheet and then play with the data.

Or do the same with a database that can eat csv (I think the one that comes with openoffice for free can). A database would be the best solution, since importing more than a select few OOBs would probably choke a simple spreadsheet programme (too much data).

Which is what we have internally for our own checking - a Builder C++ app that eats all the OOB data, and we can then run SQL queries on the 32+ megabytes of table data for MBT...

Like this one I did some time ago, when trying to make sense of centurions armour suites:

Select U.NationID,N.NationName,U.name,U.slot,u.SteelHullf ront,u.steelhullside,u.steelhullrear,u.steelturret front,u.steelturretside,u.steelturretrear,u.steelt op
from Units U, NationNames N
where ( ( LOWER(U.name) like "%centurion%") OR (LOWER(U.name) like "%semel%")
OR (LOWER(U.name) like "%olifant%") OR (LOWER(U.name) like "%sh'ot%")
OR (LOWER(U.name) like "%pz%%55%") OR (LOWER(U.name) like "%pz%%57%")
OR (LOWER(U.name) like "%strv%%81%") OR (LOWER(U.name) like "%strv%%101%") OR (LOWER(U.name) like "%strv%%102%") OR (LOWER(U.name) like "%strv%%104%")
OR (LOWER(U.name) like "%tariq%"))
AND U.nationID=n.nationID
order by u.steelhullfront

And then the app can save the result set to a csv file for spreadsheet examination. Example of the result set for that old query - which probably misses some darned cent variant or other I bet! ! - attached.

And no - we are not releasing that to end users since the app is quite kludgey, and also involves the installation of the Paradox database engine etc.

And also - remember to reload all your data whever a patch is released !

Cheers
Andy