Random Platoon Generator for Troops, Weapons and Tactics Sunday, May 1 2011 


This spreadsheet will generate a random (British) platoon for Troops, Weapons and Tactics/Platoon Forward. Of course it can be used for any other platoon level wargame (NUTS etc) though you will have course have to tweak the stats. For reference TI is Tactical initiative, and runs from 1 (plodder) to 4 (heroic). The Big Man Bonus is the extra added when a leader is directing fire (Typically 3d6-3 for rifles up to 4d6+4 for MG42, the results table maxing at 36). Making the Big Man drop down YES shows the values for that man (TW&T is not normally interested in non leaders). I have defaulted the Lance Corporals, who lead the Bren gun group to BM, as they may well be called on to replace a killed section leader during a battle.

I suggest that you put ‘Workbook Calculation’ (found under Options/Formulas) to Manual, otherwise everything changes each time you change a cell. F9 is the manual update. Use Copy then “Paste Special –>; Values” to put the results you want to keep onto a fresh spreadsheet (this pastes results, rather then the formulae, so won’t keep getting updated).

Note – this is a Excel 2007 spreadsheet, so has the extension .xlsx (see below for a possible earlier version)

Random lists

This is the version saved as compatable with Excel 1997-2003. I can not guarantee which bits (if any) will work. If anybody wants to do a rewrite I’d be happy to work with them on it.

Random lists excel 97

Rights/IP stuff. I’m providing this free for personal non-commercial use, the basic work remains mine. I haven’t put anything malicious into it, but I can provide no warrenty etc etc yadda yadda yadda. Feel free to edit the names/platoon layout for other nations – I’ll happily upload it here or provide a link to where ever you host it: My Gmail address is (unsurprisingly) Last.Hussar@…

Project Xenocide – A XCOM style wargame campaign Sunday, Feb 28 2010 


Due to this thread on TMP:
I am putting the files to the Xcom inspired game I ran in the latter half of 2008. They use Two Hour Wargames “Chain Reaction” rules (the basic rules are FREE), with some modifications (the armour effect) from the supplement 5150. Scenario 3 is a fighter combat game- the simple rules are presented here. It was a intro to the actual game – scenario 4.

I also ran two others. Scenario 5 was an alien attack on a town, with civvies running about. This is where I used the chrysalids along side normal warriors. If they ‘killed’ a human hand to hand, the human became a zombie type, and if that was killed it hatched another chrysalid.

Scenario 6 was an attack on the Aliens base on earth, hidden in Aztec ruins. I used a model of a Games Workshop Dreadnaught during this.

There was also a flash back scenario after #2- early hours of 6 June 1944, where the human player was the Germans dealing with suspected paratroops.

I ran the game as more of a GM/Umpire rather than play the aliens competatively. This allowed me to adjust difficulty on the fly. Part of this I realised that aliens were too few in number to be able to give first aid, so I came up with blood borne nano-bots. These make a first aid roll as though the alien was healing himself- ie roll REP or under. See Chain Reaction for details

1- Players Brief

1- Umpires Brief

2- Players Brief

2- Umpires Brief

3- Players Brief

4- Players Brief

4- Umpires Brief

Aliens

Fighter combat

FightervsUFO

Title page

Weapon stats

Why the Bible isn’t an RPG Saturday, Oct 6 2007 


GM: “On Sunday evening you see your Master”

Matthew: “You all told me he was dead- I’ve joined this party under false pretences”

Thomas: “It’s a Zombie!  I try to ‘Turn’ it.”

Peter: “I draw my sword, +3 vs Ears”

Please feel free to add your own!

Irregular Webcomic Saturday, Oct 6 2007 


Found a great webcomic by an Aussie guy.

Go and check it out- RPG parodies, Indiana Jones parodies, discussion of physics in Star Wars, plus incompetent DEATHS.

The home page (where the link is to) is the latest post. Start at ‘1’ and read ’em all. (Though the various story lines are interleaved you can use the links under each strip to just navigate one story.)

Serenity the Roleplaying Game (RPG) Sunday, Sep 30 2007 


It’s must be 16 years since I last bought an RPG, and 11 since I last played. However recently I’ve been thinking about playing again.

Browsing through the RPG section of Waterstones in Milton Keynes I came across Serenity RPG, based on the Joss Whedon film (and, not credited, the SF series ‘Firefly’). As I love the series (I have watched approx half on DVD) I was drawn to it. I must say I was impressed. If you are into either Serenity or RPG it’s definately worth a look.

(Click on the fold for more)

(more…)