Custom Starship & Modification Tool

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

Hi Old Ben!!

I am still checking this new version.

But for the moment, I think is a awesome work.

Very thk's Old Ben.

For now, I have to figure out how to use it properly.

Before I was looking to modify a YT-2400, and well, I must admit that is a bit more complicated than I thought. lol.

Also, thank you for your work, it had been great.

Thanks again.
Lebaraz, thanks for taking a look. 

I'd recommend reading the instructions on the Intro tab first.  If anything is still unclear, please let me know and I'll try to make the instructions clearer, or make changes to the tool to make it more intuitive.
Hi Old Benn,

Sorry, I have so busy the last 4 days and I cant che'k this version again, yet.

Well, about if there is something unclear in the sheet, I don'k now.

But, I think with a little of time I find the answers, although, I have not very clear truth.

Hehe.

See you again.

ZBL
Thanks Ben. This is great. A few things though.

Can you add more modifications than just 10?

Is it possible to make the sheet make changes to the vehicle's CL if a certain amount of modifications are made?

Is there a way to make the sheet able to copy a stat block of the customized ship to word perfect?
Thanks Ben. This is great. A few things though.

Can you add more modifications than just 10?

Is it possible to make the sheet make changes to the vehicle's CL if a certain amount of modifications are made?

Is there a way to make the sheet able to copy a stat block of the customized ship to word perfect?



I'll address these one at a time:

Can you add more modifications than just 10?
Yes, I intend to have more than 10 mod slots.  I intend to have 30.   I left it at 10 for now, however, in order to give people a chance to look it over and report any bugs first.  I'd rather fix each bug 10 times rather than 30 times.

But so far, nobody has reported any bugs.  Is that a result of a lack of bugs, or a lack of interest?  I seriously doubt that there is a lack of bugs....


Is it possible to make the sheet make changes to the vehicle's CL if a certain amount of modifications are made?
I would prefer to leave the CL alone, simply because I have no idea what the CL should become and what should affect the CL.  For example, I don't think that the CL can be solely based upon # of mods made, because what if the mods are:

Add transponder
Subtract escape pods
Add holotranceiver
Add cargo pods
etc.

Even though lots of mods have been done, it wouldn't make the ship any more difficult to fight in battle.

And are all "combat" mods equal?  If I max out the SR, is that the same CL increase as increasing the range of a pre-existing ion cannon?

Since there is no guidance regarding CL changes as a result of mods, I'd prefer to leave CL alone.  The GM will have to use his/her best judgment to determine CL.


Is there a way to make the sheet able to copy a stat block of the customized ship to word perfect?
I have no idea.  I suspect that would require a macro or something.  I have no experience with macros, and I have no idea what they can or cannot do.  If somebody more knowledgeable would like to help me out to provide that functionality, I would welcome it!  Just let me know!
A new version of the tool is up.  See the link in the first post.  The latest version is CustomStarshipTool_v101


This new version 1.01 contains the following updates:


  • Added ability to make up to 30 modifications (instead of just 10).

  • Tool now calculates the Mechanics DC for each modification.

  • Tool now calculates the time needed to complete each modification. 

  • Tool now calculates the labor costs involved with each modification.


Please let me know if you find any bugs, and please tell me if you have any ideas for functionality improvements!

Thanks,
Old Benn

Old Benn, is there anyway you can add a "Carried Craft" section?  I'd prefer it to be pre-filled for ships that normally carry something, but that's not necessary. 
WINNER OF YOU BUILD THE CHARACTER #6 - Qui-Gon Jinn "For 300 years we prepared, we grew stronger. While you rested in your cradle of power." -Lord Malgus, The Old Republic Trailer "Am I the only one that saw the film and thought Obi-Wan was expressing an opinion of moral superiority/ideological victory with his statement? Y'know, instead of stating to the highly experienced combatant in front of him the obvious fact that he stood a few meters below him on the vertical axis?" -d20 Radio regarding Obi-Wan's comment to Anakin "It's over Anakin. I have the high ground."
Old Benn, is there anyway you can add a "Carried Craft" section?  I'd prefer it to be pre-filled for ships that normally carry something, but that's not necessary. 



I will certainly look into it.  I haven't had time to give it a ton of thought yet, but I think the feasibility depends upon what exactly it is you're looking for. 


For example, I could go back through all of the books and add a field that contains text that describes the carried craft.  So for an ISD2, it would be: 

"72 TIE fighters (any variant), 8 Lambda-class shuttles, 20 AT-ATs, 20 AT-STs, various support vehicles"

That would be time consuming, but not terribly complex. 

But then what would you like to see happen when a modification is done involving adding/removing a Hangar Bay?  That adds/subtracts a certain # of units of hangar space, which can be occupied by any type of vehicle.  If you removed space, the tool has no idea whether you intended to remove 1 Lambda shuttle, or remove 2 AT-STs, for example.  If you added space, it has no idea whether you intend to add 2 more TIEs, or maybe add an ETA-2 Interceptor and a speeder bike.

Here's my intial thought.  How about if I add a field as described above so that the Carried Craft shows up on the ship's stat block, but it only shows what the ship originally carried (reflecting the book's stat block).  The tool will still continue to keep track of added/removed hangar space (it already does this), and the user would just have to use the "notes" box below the stat block to keep track of any added/subtracted craft.

Does that provide the type of functionality you were looking for?  Or were you looking for something a bit "smarter"?  If you want more that what my suggestion entails, let's discuss exactly what you'd like to see, and maybe brainstorm some ideas to accomplish it.

Thanks for the suggestion!
Old Benn
Old Benn, is there anyway you can add a "Carried Craft" section?  I'd prefer it to be pre-filled for ships that normally carry something, but that's not necessary. 

I think the feasibility depends upon what exactly it is you're looking for. 

For example, I could go back through all of the books and add a field that contains text that describes the carried craft.  So for an ISD2, it would be: 

"72 TIE fighters (any variant), 8 Lambda-class shuttles, 20 AT-ATs, 20 AT-STs, various support vehicles"

That would be time consuming, but not terribly complex. 

But then what would you like to see happen when a modification is done involving adding/removing a Hangar Bay?  That adds/subtracts a certain # of units of hangar space, which can be occupied by any type of vehicle.  If you removed space, the tool has no idea whether you intended to remove 1 Lambda shuttle, or remove 2 AT-STs, for example.  If you added space, it has no idea whether you intend to add 2 more TIEs, or maybe add an ETA-2 Interceptor and a speeder bike.

Here's my intial thought.  How about if I add a field as described above so that the Carried Craft shows up on the ship's stat block, but it only shows what the ship originally carried (reflecting the book's stat block).  The tool will still continue to keep track of added/removed hangar space (it already does this), and the user would just have to use the "notes" box below the stat block to keep track of any added/subtracted craft.

Does that provide the type of functionality you were looking for?  Or were you looking for something a bit "smarter"?  If you want more that what my suggestion entails, let's discuss exactly what you'd like to see, and maybe brainstorm some ideas to accomplish it.


Benn, I am mostly looking for what you first described: a field that contains text that describes the carried craft.  But maybe make the field editable so it can be changed manually.  I'm wondering if we should even make it more generic than stats in the book describe.  Using your example above, instead of listing out specific starships/vehicles, maybe the entry would be:
"72 Huge starfighters, 8 Colossal shuttles, 20 Colossal walkers (or even ground vehicles), 20 Huge walkers, various support vehicles"
WINNER OF YOU BUILD THE CHARACTER #6 - Qui-Gon Jinn "For 300 years we prepared, we grew stronger. While you rested in your cradle of power." -Lord Malgus, The Old Republic Trailer "Am I the only one that saw the film and thought Obi-Wan was expressing an opinion of moral superiority/ideological victory with his statement? Y'know, instead of stating to the highly experienced combatant in front of him the obvious fact that he stood a few meters below him on the vertical axis?" -d20 Radio regarding Obi-Wan's comment to Anakin "It's over Anakin. I have the high ground."

Benn, I am mostly looking for what you first described: a field that contains text that describes the carried craft.  But maybe make the field editable so it can be changed manually. 



Hmm, I think I can pretty much do that.  I can't have a cell be both automated and still allow manual input.  But what I can do is add a spot to add a manual override outside of the statblock, and then the statblock will read the text in the manual override first, and if it's empty, then it will read the "original" text.  So I think that's definately doable.

 I'm wondering if we should even make it more generic than stats in the book describe.  Using your example above, instead of listing out specific starships/vehicles, maybe the entry would be: "72 Huge starfighters, 8 Colossal shuttles, 20 Colossal walkers (or even ground vehicles), 20 Huge walkers, various support vehicles"



I see where you're going with that, and it has its usefulness.  But I think it might be more useful for a greater percentage of users if it listed specifically what it carries ("TIEs" instead of "Huge starfighters").  It's easy for a user to figure out on his own how to go from specific "TIE" to general "Huge starfighter".  It's pretty much impossible for a user to go from general "Huge starfighter" to specific "TIE" unless he is already very familiar with the ship in question.   So I'll probably list the specific craft that is carried.


Hey Benn, thanks for your continued contributions.

In the Statblocks tab, why do the AT-AT and AT-ST show a speed of "fly 4 squares" and "fly 6 squares"? These vehicles can't fly.

JOIN US AT THE NEW STAR WARS SAGA EDITION COMMUNITY: THE SAGA CONTINUES!

 

Compiled files of all Star Wars Saga Edition resource documents & reference tools - NPCs, character sheets, Dawn of Defiance, Force and lightsaber form power cards, Jedi Counseling articles, NPC statblocks, Saga Index to all feats, talents, species, weapons, etc, Star Wars articles and web enhancements

These vehicles can't fly.




Well, they do when my Jedi is around. ;)


In all seriousness, thanks for bringing that to my attention.  The problem stems from the fact that this application is derived from my Character/Combat/Starship tool, and that tool was originally built for starships only.  Vehicles were added later (at your suggestion, I believe ), and I missed the fact that the "fly" text is not actually applicable to all vehicles.

I'll make the fix in both tools.

Thanks for letting me know!

Old Benn
A new version of the tool is up.  See the link in the first post.  The latest version is CustomStarshipTool_v102


This new version 1.02 contains the following updates:


  • Added a Carried Craft field, and allow user to override the field.

  • Added error message to warn the user when the ship is too big/small for a selected modification.

  • Added support for Stock Ship types.

  • Fixed bug: Corrected the text for vehicle speed.  Ground vehicles no longer have "fly" for the speed.


Please let me know if you find any bugs, and please tell me if you have any ideas for functionality improvements!

Thanks,
Old Benn

This new version 1.02 contains the following updates:


  • Added a Carried Craft field, and allow user to override the field.



Thanks for that!

WINNER OF YOU BUILD THE CHARACTER #6 - Qui-Gon Jinn "For 300 years we prepared, we grew stronger. While you rested in your cradle of power." -Lord Malgus, The Old Republic Trailer "Am I the only one that saw the film and thought Obi-Wan was expressing an opinion of moral superiority/ideological victory with his statement? Y'know, instead of stating to the highly experienced combatant in front of him the obvious fact that he stood a few meters below him on the vertical axis?" -d20 Radio regarding Obi-Wan's comment to Anakin "It's over Anakin. I have the high ground."
You're welcome!  And please let me know if you have any more suggestions for improvement!
I have been looking for a tool like this for ages, so first let me say thank you very much for making the effort. One minor problem I am having, is that I cannot do modifications in Office 2010. I can select a ship and I can use the first modification box, but thereafter all of the modification entries are data for other headings. Like weapon modifications or cannon enhancements listed where a modification type should be.

Is there any help for this? I have been trying to find this exact tool for so long, I cant even tell you. I am hoping there is a fix for this.
I have been looking for a tool like this for ages, so first let me say thank you very much for making the effort. One minor problem I am having, is that I cannot do modifications in Office 2010. I can select a ship and I can use the first modification box, but thereafter all of the modification entries are data for other headings. Like weapon modifications or cannon enhancements listed where a modification type should be.

Is there any help for this? I have been trying to find this exact tool for so long, I cant even tell you. I am hoping there is a fix for this.




I'm glad this tool is helpful for you!  I have just made an update that should take care of the problem you're seeing.  Download version 1.03 (see the link in the first post).  Since I don't have Office 2010, I can't test it out myself.  So please let me know whether the new version works for you or not.  If it still doesn't work, I'll try to investigate further.

Thanks,
Old Benn
I'm glad this tool is helpful for you!  I have just made an update that should take care of the problem you're seeing.  Download version 1.03 (see the link in the first post).  Since I don't have Office 2010, I can't test it out myself.  So please let me know whether the new version works for you or not.  If it still doesn't work, I'll try to investigate further.

Thanks,
Old Benn



Downloaded and, so far at least, it is working wonderfully! I am absolutely thrilled with this tool! Starships are one of my favorite parts of the SWSE game, and this spreadsheet makes it all that much more enjoyable to design and experiment.

Thank you so very much!
Okay, I have to say that I find this sheet amazing and so very helpful I cant even express it.

I dont know if it is appropriate to ask for additions to the sheet's functionality, but I thought I would do so just in case it is possible. For those of us who like to design a starship from the ground up, as though it were built from scratch, there are a couple of minor changes I would like to ask about.

The first is if it is possible to add about 20 more modification sections to the sheet, so that there is room to design a ship from the hull upward. I have found that in doing so, 30 modifications cant account for all of the changes that must be made.

Secondly, I wonder if it is possible to allow the removal of the existing sublight engines before adding new ones, to account for increased spatial movement for a design, without it removing the character-scale movement value? Or add something to put in the atmospheric movement speed when a new sublight drive is added? At present if you remove the sublight drive in preparation for installing a more powerful engine, the vessel loses it's atmospheric flight speed, but does not get a new one when you install the new drive.

Thirdly, is it possible to add a box to the modification sections to account for the number of times that modification appears in the ship? This is primarily useful in the design of larger capital ships that may have multiple occurances of a single weapon system. As it stands now, you have to enter each individual weapon system to account for all of the EP used.

Finally, is it possible to have a tab for a final stat block like the one generated by the SagaSheet, to show the complete text form with all of the systems listed? I had thought that there would be such a thing already, but I am not finding it and there was nothing in the instructions tab to indicate how to generate it.

This is a wonderful tool, and as I said before I cannot even say how incredible it is to finally find one after searching for so long. I want to add how much I appreciate the fact that you have created it and that you took the time to make it work in Office 2010, and I am going to refer everyone I know to this thread.

Thank you again, so very much, from the whole Star Wars starship nerd community. :D
Okay, I have to say that I find this sheet amazing and so very helpful I cant even express it.



Thanks!

I dont know if it is appropriate to ask for additions to the sheet's functionality, but I thought I would do so just in case it is possible.



Any suggestions are always welcome.  I can't promise that I'll always be able to implement them, but they are certainly welcome!

For those of us who like to design a starship from the ground up, as though it were built from scratch, there are a couple of minor changes I would like to ask about.

The first is if it is possible to add about 20 more modification sections to the sheet, so that there is room to design a ship from the hull upward. I have found that in doing so, 30 modifications cant account for all of the changes that must be made.



Hmm, yes I can certainly do that.  There is a slight problem in that anytime I need to make a change (fix a bug, add some functionality, etc.), I have to do it for every single mod slot.  So right now, I'd have to do the same fix 30 times.  Adding another 20 slots means that every fix would have to be done 50 times.  That's some significant work.  I don't mind doing it, but I want to be smart about it.  I will most likely wait and add the extra 20 slots after other updates have already been made.  That way, I'm minimizing my work.  But the bottom line is, yes, I will add 20 more slots for you at some point.

Secondly, I wonder if it is possible to allow the removal of the existing sublight engines before adding new ones, to account for increased spatial movement for a design, without it removing the character-scale movement value? Or add something to put in the atmospheric movement speed when a new sublight drive is added? At present if you remove the sublight drive in preparation for installing a more powerful engine, the vessel loses it's atmospheric flight speed, but does not get a new one when you install the new drive.



Yes, I could do something to allow the user to define the atmospheric speed and the character scale speed.  The reason it currently goes blank is because the rules don't say what those values should actually be for any given sublight drive.  But I can add some user-interface to allow the user to define it themselves.

Thirdly, is it possible to add a box to the modification sections to account for the number of times that modification appears in the ship? This is primarily useful in the design of larger capital ships that may have multiple occurances of a single weapon system. As it stands now, you have to enter each individual weapon system to account for all of the EP used.



I guess I'd like a bit more information about this one.  The tool already allows you to define a single weapon system as being a battery (up to 6 identical weapons working together).  You can already replicate any pre-made stat block weapon system with a single mod slot. 

Are you talking about adding 60 turbolasers to a capital ship because that's what it actually has in "reality"?  The rules are designed to be a bit abstract with respect to actual number of guns on capital ships.  I believe there really isn't a need to add "realistic" numbers of weapons to capital ships.  But, as I said before, I'd like to get some more info on this issue.  Maybe I'm misunderstanding what you're wanting to do.  Or maybe I'm missing a possible reason to add that many weapons.

Finally, is it possible to have a tab for a final stat block like the one generated by the SagaSheet, to show the complete text form with all of the systems listed? I had thought that there would be such a thing already, but I am not finding it and there was nothing in the instructions tab to indicate how to generate it.



Someone else has previously requested the ability to export a full statblock to Word.  I am all for the idea, but sadly, I do not know how to do that.  If you or anybody else knows how to achieve this, I will be happy to try to integrate that into the tool.

This is a wonderful tool, and as I said before I cannot even say how incredible it is to finally find one after searching for so long. I want to add how much I appreciate the fact that you have created it and that you took the time to make it work in Office 2010, and I am going to refer everyone I know to this thread.

Thank you again, so very much, from the whole Star Wars starship nerd community. :D



Thank you for your support!  It is much appreciated!
Ok, so this might be one of the most helpful tools I've ever found for an RPG. Thanks so much for your hard work on this!

I don't know if this has come up, but there is a glitch or something for the Eta-2 and all of it's variants. When you chose this class of fighter from the drop-down menu, everything in the Results of Mod table goes "NA".

This is in the 2007 version, I haven't tried it on the other version.

Thanks!
Ok, so this might be one of the most helpful tools I've ever found for an RPG. Thanks so much for your hard work on this!

I don't know if this has come up, but there is a glitch or something for the Eta-2 and all of it's variants. When you chose this class of fighter from the drop-down menu, everything in the Results of Mod table goes "NA".

This is in the 2007 version, I haven't tried it on the other version.

Thanks!



Thank you for the kind words, and thank you for bringing this to my attention.  I've investigated it a bit, and I found that this error will happen with any ship that has a hyperdrive ring.

I will make sure that the next version of the tool can properly handle these types of ships.  But in the meantime, if you have this error then here is a short-cut fix:

1) Go to the "StarshipInfo" tab.
2) Find the starship you are interested in in column D.
3) Go to column AD and change "x1 (with booster ring)" to "x1".

The tool should work just fine, except for the fact that it will believe that the ship has a standard x1 hyperdrive.  As long as you don't perform any modifications that involve the hyperdrive, the tool should work for these ships just fine.

As I said, the next version of the tool should be able to handle ships with hyperdrive rings properly. 

Sorry for the inconvenience!
First of all, thanks for responding so quickly, the fix you gave me will work perfectly for what I am trying to do.

Secondly, as far as I am concerned, you never need to apologize for inconveniences. You are doing this for free and I appreciate all of the hard work you've put into it.

Thanks again!
A couple issues I've found in the character sheet tab. 
In both the 2007 & 2003/XP versions, I can't seem to get Force-using traditions talents to be recognized as legitimate, e.g. Matukai Adept talents with Soldier or Jedi levels. It just says, !!!ERROR:THIS IS A Force-Using Traditions TALENT!!! I've given my character in quesion the Force Sensitivity talent and it's trained in Use The Force. Am I missing a setting or something?

In the 2007 version, only the first PC in the character sheets has all languages available to him. The second one has all languages that start with "K" and down, the third only languages that start with "T" and below, and then the 4th - 8th characters don't have any languages available to select or type.

Thanks for such a great spreadsheet! This is by far the most comprehensive tool I've found for Saga. I'm looking forward to using it in my next DoD session.
I never listen to the Order 66 Podcast. Winner of You Build the Character #27 - Cad Bane

Sorry for the delay in my reply, business has kept me extremely busy of late.

Hmm, yes I can certainly do that.  There is a slight problem in that anytime I need to make a change (fix a bug, add some functionality, etc.), I have to do it for every single mod slot.  So right now, I'd have to do the same fix 30 times.  Adding another 20 slots means that every fix would have to be done 50 times.  That's some significant work.  I don't mind doing it, but I want to be smart about it.  I will most likely wait and add the extra 20 slots after other updates have already been made.  That way, I'm minimizing my work.  But the bottom line is, yes, I will add 20 more slots for you at some point.



Thank you immensely for the consideration. For those of us who like to create a new starship design from scratch, rather than customizing something, this spreadsheet tool is an amazing utility. The addition of the other 20 modules will provide enough room to do a complete design by my calculations.

Yes, I could do something to allow the user to define the atmospheric speed and the character scale speed.  The reason it currently goes blank is because the rules don't say what those values should actually be for any given sublight drive.  But I can add some user-interface to allow the user to define it themselves.



I have been thinking on this notion, and I wonder if it might give a decent value to base a formulae on if all of the ships in SotG were charted with their atmospheric speed compared to their sublight speed? Would this give a mean value which could then be rounded to a constant that would approcimate how much each level of tactical speed amounted to in atmosphere?

I guess I'd like a bit more information about this one.  The tool already allows you to define a single weapon system as being a battery (up to 6 identical weapons working together).  You can already replicate any pre-made stat block weapon system with a single mod slot. 

Are you talking about adding 60 turbolasers to a capital ship because that's what it actually has in "reality"?  The rules are designed to be a bit abstract with respect to actual number of guns on capital ships.  I believe there really isn't a need to add "realistic" numbers of weapons to capital ships.  But, as I said before, I'd like to get some more info on this issue.  Maybe I'm misunderstanding what you're wanting to do.  Or maybe I'm missing a possible reason to add that many weapons.



Where I ran into the problem was in designing a ship with a variety of different weapon systems for different purposes. For example, designing a pirate vessel that specializes in capturing targets, I tried to implement different weapons NOT in batteries and I didnt have enough entries for the weapons as designed. For example, the design I was working on carried 4 independently-fired ion cannons and two dual-torpedo launchers, one set fore and the other aft. That is six systems alone, without even taking into acount the point-defense weapons, mines or lasers.

Someone else has previously requested the ability to export a full statblock to Word.  I am all for the idea, but sadly, I do not know how to do that.  If you or anybody else knows how to achieve this, I will be happy to try to integrate that into the tool.



Perhaps you could sample the code from the SagaSheet to determine how to do it? Or even check into the thread for the sheet to ask for help from the folks working on it, which is linked in the sheet on the first tab. It would be outstanding to be able to have a stat block output.

Thank you again for all of the help!

A couple issues I've found in the character sheet tab. 
In both the 2007 & 2003/XP versions, I can't seem to get Force-using traditions talents to be recognized as legitimate, e.g. Matukai Adept talents with Soldier or Jedi levels. It just says, !!!ERROR:THIS IS A Force-Using Traditions TALENT!!! I've given my character in quesion the Force Sensitivity talent and it's trained in Use The Force. Am I missing a setting or something?

In the 2007 version, only the first PC in the character sheets has all languages available to him. The second one has all languages that start with "K" and down, the third only languages that start with "T" and below, and then the 4th - 8th characters don't have any languages available to select or type.

Thanks for such a great spreadsheet! This is by far the most comprehensive tool I've found for Saga. I'm looking forward to using it in my next DoD session.



I think you meant to post this in the 3-in-1 tool thread.  I'll address your post there.

I have been thinking on this notion, and I wonder if it might give a decent value to base a formulae on if all of the ships in SotG were charted with their atmospheric speed compared to their sublight speed? Would this give a mean value which could then be rounded to a constant that would approcimate how much each level of tactical speed amounted to in atmosphere?



The values can vary quite a bit, so it's possible that the user would still want to be able to choose his/her own values.  So I'll go ahead and add the user interface to do so.  I will also include a note that describes what the approximate value should be for character scale speed, based on the selected sublight drive.  The max velocity values vary wildly, so I don't think calculating an approximate value will be very helpful, so I won't include such information for that one.  But the max velocity value isn't nearly as important as the character scale speed value, so I think that will be okay.



Where I ran into the problem was in designing a ship with a variety of different weapon systems for different purposes. For example, designing a pirate vessel that specializes in capturing targets, I tried to implement different weapons NOT in batteries and I didnt have enough entries for the weapons as designed. For example, the design I was working on carried 4 independently-fired ion cannons and two dual-torpedo launchers, one set fore and the other aft. That is six systems alone, without even taking into acount the point-defense weapons, mines or lasers.



I see.  Well, as much as I'd like to accommodate your request, that kind of update would be a major overhaul of how the weapons data is currently calculated.  Or else I would have to add additional weapon slots (beyond 8), and that would be quite a large amount of work to do too.  I'm afraid I'm going to have to veto that one.  Sorry!

Perhaps you could sample the code from the SagaSheet to determine how to do it? Or even check into the thread for the sheet to ask for help from the folks working on it, which is linked in the sheet on the first tab. It would be outstanding to be able to have a stat block output.



I will look into it.  I suspect it would require the use of a macro, which I have thus far avoided.  But I will look into it nonetheless.  No promises, but I'll see what I can do.
A new version of the tool is up.  See the link in the first post.  The latest version is CustomStarshipTool_v104


This new version 1.04 contains the following updates:


  • Added ability to override starting available EP.

  • Added ability to apply a template (prototype, junker, etc.) to a ship/vehicle.

  • Added ability to specify the ship's character scale speed and the maximum velocity when a new sublight drive is added.

  • Added an indication of each mod's availability (C, L, R, M, or I).

  • Added ability to override each mod's availability.

  • Added ability to select crew quality, including a custom crew.

  • Fixed bug: Corrected hyperdrive entries so that all ships with hyperdrive booster rings no longer result in "N/A" for modification info.

  • Fixed bug: Ships with hyperdrive booster rings no longer have -4 DEX. (You must apply the -4 penalty yourself if the ship is currently docked with the ring.)

  • Fixed bug: Ships with unique weapons (that are not listed in the equipment section of SOTG) in weapons slots 2 through 8 were always shown as the name of weapon system 1.

  • Fixed bug: Mod slots #10 through #30 now correctly display the description of the original weapon system when a Modify Existing Weapon is performed.

  • Fixed bug: Error for hyperdrive mod no longer considers ring/sled input unless a hyperdrive has actually been added in that mod.


Thank you to Treluminary and Arryn for the bug reports and suggestions. 

As always, please let me know if you find any more bugs, and please tell me if you have any ideas for functionality improvements!

Thanks,
Old Benn

Benn? Heyas. Not to mock the awesome work you've done with this tool in anyway but have you given a looksee at Kenad_Boki's Ship_Sheet? Is there any chance you could spare some time to possibly work on that as well (aka update and fix it)? It's just that Boki's Ship_Sheet is alot less complicating and thus easier for me to use at times and it'd be great if someone could fix it up and update it.
...have you given a looksee at Kenad_Boki's Ship_Sheet? Is there any chance you could spare some time to possibly work on that as well (aka update and fix it)?



Nope, I can't do that.  Even if I had the time to work on a 3rd tool (which I really don't), his sheet uses macros to do everything.  I don't know anything about using macros, so I'd have no chance of making any headway with that thing.

On an another note, I know that some time ago, you had asked me to find a way to port my tool's stat block into Word.  I believe I may have found a way to do that.  I'm still investigating that possibility, but with any luck, I might have that feature available in the next release.

Thirdly, is it possible to add a box to the modification sections to account for the number of times that modification appears in the ship? This is primarily useful in the design of larger capital ships that may have multiple occurances of a single weapon system. As it stands now, you have to enter each individual weapon system to account for all of the EP used.



Treluminary,

I owe you a retraction.  I initially turned down this suggestion because it was going to be a large amount of work for what I saw as not much benefit.  But I have made a pretty big mistake there.  I've looked primarily at smaller ships, not the capital ships.  I assumed that the weapon stat blocks in grey (in the books) contained all the weapon info needed.  But now I notice that this is not the case.  I now see that many capital ships do have multiples of the same weapon system (4 heavy turbolaser batteries of 6 gunners each, for instance). 

I will definitely update the tool to be able to handle these cases so that the stat block is correct.  And I will also add a user interface to be able to specify weapon quantity for modifications.

Sorry I misunderstood the situation earlier.
Ok, you can now export the ship's statblock to Word!  The instructions are in row 104 of the Intro tab, or you can see below for specific instructions.

A new version of the tool is up.  See the link in the first post.  The latest version is CustomStarshipTool_v105


This new version 1.05 contains the following updates: [EDIT: corrected the list of updates made]


  • Added ability to populate a Word document with the ship's stat block (using ExportStarshipStatblock.docx)

  • Added ability to select multiples of the same weapon system.

  • Fixed bug: Ships from books now have the correct number of each weapon system.


Thank you to Treluminary for the functionality suggestions. 

As always, please let me know if you find any more bugs, and please tell me if you have any ideas for functionality improvements!

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


Thanks,
Old Benn

Old Benn, I am finally at the moment in which my group needs to purchase their own ship. This tool is amazing, it covers more than I could hope for. Thank you VERY much for your work on this one.
Is there any way to find out the total cost for the starship given most of the mods and the ship is black market?
Is there any way to find out the total cost for the starship given most of the mods and the ship is black market?



Well, it depends on what you mean by "total cost".  I'll try to explain what I mean.

The original cost of the ship (with no Black Market and no Availability costs included) is in cell M22.

The current market value of the ship, after all mods have been added, is in cell M23.  But, it should be noted that this number does NOT include Black Market costs, nor Availability costs, nor Labor costs.  It includes only the base value of the ship, plus the base value of the parts that were added, plus the value added by Tech Specialist or Superior Tech upgrades (per the feat descriptions).  This is because labor costs can vary widely, and therefore should not be included in the cost of the ship.  Similarly, an upgrade that is considered Illegal in one system might only be considered Restricted in another system.  The only way to reliably discuss a ship's current market value is to disregard Black Market, Availability, and Labor costs in such a discussion.  Once the current market value (without all these multipliers included) is known, then the Black Market or Availability multipliers can then be applied at that point to determine what a buyer/seller could actually expect to get for it in any given system.

The complete total number of credits it would take to complete all 30 modifications is not directly given anywhere in the tool.  You could manually calculate this by adding the cost of Parts (Cell AJ17, which includes Black Market and Availability costs) and the cost of Labor (Cell AJ18) and adding all of these Parts & Labor costs for each and every mod.  

So, if you're looking for the original cost or the current market value, then yes, the tool provides this.

If you're looking for the complete total number of credits to perform all mods, then no, the tool does not directly compute this.  But you can compute it yourself by adding all of costs given for each mod (see AJ17 and AJ18 for examples of these).

I hope this answers your question.  If not, or if something I said doesn't make sense, just let me know.
Ok. I believe I will implement a quick & dirty formula that simply adds everything together. Reason being that my group is going to construct, equip and pay for their YT-1300 next session. They have 600k to spend and 6 months to build it, so what I need is to simply sum up how much they spent in one single bill.

I would also like to ask, do you include anything that isn't in the index? We were thinking about adding starship support in our GM Utility and it would be awesome to simply grab the templates from the file.
Do I include anything not in the index? Yes, although I'm not really sure exactly what the differences are. I have added many columns worth of data that the index did not have. But are there also rows that are not in the index? I don't know. I started using the index as a source of data for my tools well before the last few soucebooks came out. So I added new soucebook data on my own. I have no idea if our data is organized in the same order, or contains all the same entries.
Your data is way more detailed than the index. Would it be ok with you if we used it as a database for our utility?
Sure, no problem. Just be sure to mention where you got it from, will you? I'm happy to share with anybody who wants it. After all, my tool started out using the Index's data!
Sure, no problem. Just be sure to mention where you got it from, will you? I'm happy to share with anybody who wants it. After all, my tool started out using the Index's data!


Of course. If we make an official release... Last time we tried we were ignored.