View Single Post
  #9  
Old March 7th, 2011, 08:41 AM
Mobhack's Avatar

Mobhack Mobhack is offline
National Security Advisor
 
Join Date: Mar 2005
Location: Dundee
Posts: 5,994
Thanks: 488
Thanked 1,928 Times in 1,254 Posts
Mobhack is on a distinguished road
Default Re: Spreadsheet Of Statistics For Tanks

This is a quick SQL query of the MBT database for the "tank" classes (assuming I did not forget one or two !

There might be a change or 2 in the published OOBs in the patch - but not likely.

It is sorted by nation, and then by first year available.

(2384 "tanky" thingys in the MBT OOB set)

Quote:
Select U.NationID,N.NationName,U.name,U.slot, u.UnitClass, C.ClassName,u.YearAvailable, u.LastYearAvailable, SteelHullfront,U.SteelTurretFront,U.HEATHullFront, U.HEATTurretFront
from Units U, NationNames N, ClassNames C
where
( u.unitClass=12 OR u.unitClass=13 OR u.unitClass=14
OR u.unitClass=59 OR u.unitClass=15 OR u.unitClass=17
OR u.unitClass=102 OR u.unitClass=103 OR u.unitClass=104
OR u.unitClass=105 OR u.unitClass=106 OR u.unitClass=107
OR u.unitClass=131 OR u.unitClass=132 OR u.unitClass=135
OR u.unitClass=159 )
AND u.SteelHullFront>0
AND U.nationID=n.nationID
AND u.UnitClass=ClassNameID

order by u.NationID, u.YearAvailable
So
- find your opponent's block
- see what is available at that date
- check the armour

Only front hull and turret steel and HEAT armours listed, since most folk seem to worry about a head-on "duel". If you have no chance that way - you will have to go for flank shots.

Cheers
Andy
Attached Files
File Type: zip MBTTankArmour.zip (31.2 KB, 154 views)
Reply With Quote