This is written for Troops Weapons and Tactics and Platoon Forward, but could obviously be used for other low level games where you want men a bit more personalised fpr a campaign.
Please note the caveat re Excel versions. I suggest you turn auto calculation off, and use F9.
http://lasthussar.wordpress.com/2011/05/01/random-platoon-generator-for-troops-weapons-and-tactics/
Interesting.
IanS