Excel sheet for NPC groups

[Skunk]

Hi all, I've created a NPC group spreadsheet in Excel that I thought I'd share.
It lets you create NPC templates and then generate up to 20 NPCs in a group for managing during combat.


Templates can be created with some random choice by including more than one value in a column separated by a colon (
In the Marauder template below Melee would have equal chance of being D, C, or B, reloads for primary weapon will have a 50% chance of being 2.


There are sheets with details for personal weapons, support weapons, and vehicles that can be added to.
There are also some lists of names to randomly name the NPCs created. My apologies if the names are odd I just grabbed them from some online sources so I can't vouch for their accuracy and my knowledge of European name structure is non existent.
If you spot something off let me know and I'll fix it up.


Any of the orange cells can be edited once the lines are filled in but it won't update Hits and Stress Cap automatically or add any new weapon details into the list under the characters.
Since not everyone fights to the death if you fill in the % values for Withdraw and Rout it will pop up a reminder when the limits are passed.


The sheet contains macros and you don't know me from a bar of soap, which, as has been pointed out here recently, is a security issue. Maybe someone who knows something about Excel and macros could risk it and then expose me if required.
T2K_NPC_Group.zip

Finally is you use it and like it let me know of anything else that could be a good addition, also if you create some more templates consider sharing them as my laziness overwhelmed me by the time I got to that point.