Here is a tool that will allow you to select any ship from SAGA and modify it using the rules from Starships of the Galaxy. This tool updates the ship's stats and also tells you the EP cost and the cost in credits of each modification.
Download it here. (Latest version is CustomStarshipTool_v109.)
CustomStarshipTool_v109 is compatible with versions of Excel from 1993 - 2007.
CustomStarshipTool_v109_excel2007 is compatible with versions of Excel from 2007 - 2010.
This is the initial version of the tool, and as such, I've only allowed 10 modification slots at this time. I intend to allow up to 30 modifications, but I wanted any bugs to get worked out first. (I'd rather fix each bug 10 times instead of fixing each one 30 times.) The tool now allows up to 50 modifications.
So please take a look, try it out, and let me know if you find any bugs. This is a fairly complex tool (from a calculation point of view), so I suspect there may be bugs in there somewhere. Please help me find them before I release the more expansive version of the tool.
Right now, the tool handles all of the following:
Black market fees vs. legit lisencing fees
All types of modifications defined in any SAGA book
All ships defined in any SAGA book, including stock ship types
Increasing cost and EP if you define the mod to be "non-standard"
Ignoring the "non-standard" label if a Starship Designer does the modification
Allows a weapon to be upgraded (an optional houserule)
Allows user to select which interpretation of RAW they would like to use for cost multipliers and base costs of Tech Specialist and Superior Tech mods.
Allows application of Templates.
Allows crew selection and definition.
At this point, the tool has the following known deficiencies (but I intend to include this functionality in future releases):
The tool currently does not allow templates to be added to the ship.
The tool currently does not allow stock ship types.
The tool currently does not know whether the original version of a ship has a hyperdrive sled/ring.
The tool currently does not calculate the Mechanics DC for each modification.
The tool currently does not calculate the time needed to perform each modification.
The tool currently does not calculate whether a modification results in the ship being "used".
The tool currently does not calculate the installation cost of a modification if the work is done by an NPC.
The tool currently assumes that all concussion missile launchers are of the same type (light/medium/heavy) as specified in the stat blocks. Missile Payload is not currently tracked in this tool.
The tool currently has only partial error message functionality. It will inform you if you put a modification on a ship that is the wrong size for that mod. But it will not warn you that you are attempting to perform Tech Specialist upgrade on a system you don't have.
INSTRUCTIONS FOR EXPORTING THE STAT BLOCK TO WORD:
The ExportStarshipStatblock.docx Word file will automatically pull the current stat block when you open it (be sure to click "Yes" when you open the file).
The first time you do this, it will probably be unable to find the Excel file to pull the data from. If it asks you to find the source file, browse to wherever you saved the CustomStarshipTool and select it.
If for some reason this does not work, then you will need to update the ExportStarshipStatblock.docx file so that it knows where to look for the CustomStarshipTool.
You can do this by doing the following:
(Note: These instructions are for Word 2007. I do not know if the same procedure will work for any other version of Word.)
a. Open the ExportStarshipStatblock.docx file.
b. Click the "Mailings" tab.
c. Click "Start Mail Merge".
d. Click "Step by Step Mail Merge Wizard".
e. Click "Next" or "Previous" until you get to Step 3.
f. Click "Select a different list…" or "Browse".
g. Browse to wherever you saved the CustomStarshiptool, and select it.
h. When it asks which sheet contains the data, select 'StarshipStatBlock&Mods$'.
i. Be sure to put a checkmark in the box that says "First row of data contains column headers".
j. Click "OK".
k. When it asks to select Mail Merge Recipients, de-select all rows except for the first row (the row that has "Base Type of Starship" in column F1).
l. Click "OK".
m. Save your changes, then close and re-open ExportStarshipStatblock.docx