Go to: [Rare GURPS Items]

GURPS Excel Macros

© by Douglas H Cole (dhcole@nwu.edu)

These two Excel spreadsheets have been designed to speed up play. Weapon Designer simplifies the process of designing weapons using the rules from GURPS Vehicles, 2nd edition, while the FireFight quickly calculates hits ad damage of firearms, which is very useful in combats involving several combatants with automatic weapons.

Here are a few notes from Douglas:

The Weapon Designer has two macros in it. One for guns, "GunCreator", and one for beam weapons, "BeamCreator." To run them, click on the sheet with the proper name, and flip the little "light switch" button to run the macro. There are some quirks to the program, like electromags must use "Regular" ammo, not any of the special types, but it seems to work pretty well for me. I think the way it calculates ammo modifiers might be a little off, and the cost of some weapons is probably wrong, since cost is based on weight, some mods that affect weight probably affect cost, too. But at least it's consistent. Oh, one final rule on that one... hit "update" and "recalc" alot.

The FireFight macro is to simplify firearms combat dice rolls. You'll have to replace the character list with one of your own, and in order to do this, you'll need to know how to use the Insert:Name:Create command. Once that's done, you can add your characters.
That program is not by best piece of work. It's slow (very) on a slow PC. My computer (MacOS PowerBase) does an adequate job, but on slower machines it's pretty ugly.

Note: These programs are for Excel 5.0. Microsoft introduced some changes in Excel 6+ that make the Visual Basic code run differently. If I ever "upgrade" to Office 97+ for Mac I'll rewrite them, but I don't see that happening until I have a real salary.

You can download the macros here, as follows: