View Single Post
Old 06-24-2016, 05:47 PM   #5
Join Date: Aug 2004
Location: Buffalo, New York
Default Re: Adventure Guns equipment

Originally Posted by ericbsmith View Post
I'm curious, a macro? Assuming you're using a spreadsheet (which I think you mentioned to me in e-mail), once you have a table with data rows and columns layout you can simply use CONCATENATE to piece together tags. If you go beyond the limit of CONCATENATE simply stop, move one column to the right, include the previous column in the CONCATENATE and keep going. I've done this with numerous data files including GURPS Magic and all of the guns all of the High-Tech and Ultra-Tech series.
I finally got it working of sorts, and I'll send it to you via an attachment.

The goal of the macro is for people to be able to use it to create their own equipment lists for guns (whether home brewed rules or official sources). The intent is for the person to be able to name the file as they desire, have it set up the category tags (like High Tech - Adventure Guns) etc. without having to do too much manual editing. In addition, What I'd sort of like to be able to do with the Macro is to set it up so that if the weapon uses the skill "Guns (Pistol)" as the primary skill, that it handles all of the default skills and automatically fills in the data for you. So if using guns (Shotgun) as a skill, it automatically fails to put in SK: guns (shotgun), but instead, puts in SK: Guns (pistol)-2, etc.

By putting it in excel and making it a macro - one should be able to simple enter data, double check it, and then hit the publish button or hot key - and it creates the file and names it as you want it named. Right now, it puts in the system date from the PC when I run the macro, puts in the variable file name for the header information within the file, and even puts in the copyright date in the right spot for the publication of the source - without having to type it in manually in the file.

Little things like that that make it worth my while to create the macro.

Somewhere along the way, I'd like to create an "Old West" data file that contains ONLY the quirks, perks, advantages, disadvantages etc required for a GURPS OLD WEST campaign - and then lists the weapons by decade (ie 1840's, 1850's, 1860's etc on up to about 1900's).

What irks me so is for GURPS CHARACTERS and/or CAMPAIGNS to list TL 6 as 1880, and to have guns from the 1860's or 1870's be listed as TL 6 weapons.

Ah well. At least I got past the block I was running into! At one point I discovered that using as part of the gun description/name the " in lieu of Inches, was causing problems. Once I figured that out, I used the word inch instead, and the file worked as expected.


I'm a happy guy at the moment for my own needs at least. Now I simply have to polish it up so it is usable for anyone - even if only the inner circle crew of your own group. Of course, I could simply post the macro code here in the forums, you put a stickie on it so that it is always available for anyone who wants to try their hand at it, and possibly learn how to code in VBA (essentially VB.NET with the VBA being the dumb cousin sort of thing).
hal is offline   Reply With Quote