RTSU is a utility spreadsheet Compatible with Excel and Open Office .

You can download the new version at the bottom of the following page: Rogue Trader Ship Utilities

You select the ship hull, components and weapons and it spits out a complete Character Sheet for the ship that you can print or use on the fly (assuming you have a computer handy).

• The utility is fully functional.
• On the Player Info Input Sheet Morale, Disposition and Population can be entered & tracked in real time.
• All Morale and Crew effects are built into the Character Sheet and tabulated automatically.
• All Achievement Bonuses and Skill test bonuses/penalties are built into the sheet and appear on the Character Sheet automatically.
• You can now add multiple components for Barracks, luxury Quarters, Augmented Retros, and Reinforced Bulkheads. Also Main Cargo Holds for Transports (max 5) and multiples of Compartmentalized and Cargo Hold&Lighter Bay Components, up to FIVE each.
• Custom Hull support added. Now you can add a custom hull of your own and the Character Sheet will integrate it automatically.

• Custom Component: Stowage Bays
• Custom Component: Colonist Quarters by Jenk, On the fly conversion of Barracks to Colonist Quarters.
• Implemented IRONCLAD Ship Subtype & System Ship / Monitor Class Ship Subtype
• Conjectural Plasma Drive Types from Ships of the Imperial navy by BuckX to support >Cruiser Class/Hulls in CUSTOM Hull slot
• Dragon's Breath Lance Weapon (from LotE), Excess Void Armour & (conjectural) Excess Void Armour >Cruiser Sized Class/Hulls, Gilded Hull & (conjectural) Gilded Hull for >Cruiser sized hulls, Starcannon Cluster Battery (5/3/3, note no SP$ was given in LotE so I assigned 3 SP$ per battery, this is conjecture),
• Custom Components: Podded Components (Barracks and Cargo Holds) by Argus Van het and The Mimic Engine by BaronIveagh

v1-41 is PUBLISHED!

• Many bug fixes and omissions from BFK added.

v1-40r73 is FINISHED!

• All components, hulls and weapons added.
• Craftsmanship is not yet included.
• Please help me error check. There is a NOTES page to give you an idea of how some things were done and why.

v1-40r09 is finished.

This version adds everything for ships from the Into the Storm Supplement, some fixes and cleanup of the sheets.

• New Hulls: LOKI, ORION, COBRA, FIRESTORM (cleared up my guesses), SECUTOR, LATHE, TYRANT.
• Background Packages: Thulian Explorator Vessel, Reaver of the Unbeholden Reaches, Veteran of the Angevin Crusade, Vessel of the Fleet, Planet-bound for Millennia.
• Essential Components: Plasma Drives : Jovian Pattern, 'Warcruiser' Drive, Jovian Pattern, 'Warcruiser' Drive, Lathe Pattern, 2a Drive, Lathe Pattern, 2b 'Escort' Drive. Warp Engines: Markov 1 and Markov 2. Gellar Fields: Emergency Field. Void Shields: Repulsor Shield, Repulsor Shield Array. Ship's Bridge: Exploration Bridge. Crew Quarters: Clan-Kin Quarters, Cold Quarters.
• Supplemental Components: Macrobatteries: Jovian Pattern Missile Battery, Lathe Pattern Grav-Culverin Broadside, Mezoa Pattern Macrocannons, Pyros Melta-Cannons, Sunsear Las-Broadside. Lances: Sunhammer Lance, Sunhammer Lance Battery. Cargo & Passenger Compartments: Shadowblind Bays, Xenos Habitats, Augments & Enhancements: Auxiliary Plasma Banks, "Storm" Drop Pod Launch Bays, Empyrean Mantle, Reinforced Prow, Additional Facilities: Arboretum, Asteroid Mining Facility, Astropathic Choir Chambers, Broadband Hymn-Casters.
• Archeotech Components: Castellan Shield, Castellan Shield Array, Cogitator Interlink, Energistic Conversion Matrix, Gyro-Stabilization Matrix, Staravar Laser Macrobattery, Star-Flare Lance.
• Ship Upgrades: Atomics, Cherubim Aerie, Crew Improvements, Ostentatious Displays of Wealth, Servitor Crew, Starchart Collection, Stormtrooper Detachment, Turbo Weapon Batteries, Vaulted Ceilings.
• Reworked the sheet to allow for more drives in the future, included the four in ItS
• Added conjectural Castellan Triple (BC+) and Quad (BB+) Void Shield Arrays
• Added conjectural Repulsor Triple (BC+) and Quad (BB+) Void Shield Arrays
• Consolidated Bridge of Antiquity under Ships Bridge Drop down on BUILD page.
• Removed Check Box under Archeotech for Bridge of Antiquity.
• Completely reworked the logic and BUILD sheet down for bridge selection.
• Conjectural Clan-Kin Quarters for BC+ and BB+ vessels added.
• Conjectural Cold Quarters for BC+ and BB+ vessels added.
• Added Logic to Change Title from Machine Spirit Oddity/Past History to Background Package on Character Sheet depending on which type is chosen. If a BP is chosen only Background Package title will appear on the Character Sheet. If a Background Package and MSO/PH are chosen only the BP should appear on the Character Sheet.
• Added KEEL Mounts for weapons and on the fly display on character sheet when chosen.
• Removed many home brew weapons to make room for canon weapons (you can still use the custom weapon slot to add a favored weapon of choice).
• Regarding Servitor Crew: I set it up to where Morale always ='s 100 if Servitor Crew is chosen so components that would raise or lower morale simply don't work to that end. Crew quality numbers change and are maxed depending on what the servitor quality is as well as if there are cogitator interlinks installed.
• Regarding "Storm" Drop Pod Launch bays: Added ability to have multiple STORM Drop pod Launch Bays. Character sheet now automatically calculates pod total and strategic turn launch total of multiple Drop Pod Launch Bays.
  

v1-38 adds:

• FIRESTORM Hull Base Stats updated.
• Added all weapons from Ships of the Imperium version 1.2 ( Battleship Grade Weapons, Torpedoes, Nova Cannon and Launch Bays )
• Added THREE weapon slots for a total of EIGHT. This will accommodate nearly all large ships including Imperial Battleships.
• Several Bug Fixes

v1-39 adds:

RTSU Version 1-39 is up and ready for use at MakeWarNotLove

Update June 4 to 6 - version 1-39 is up

• Added: Forbidden Lore (Xenos) modifiers appear on character sheet when Xeno tech chosen for ship
• Fixed Augmented Retro Thrusters Calculations for Custom Ship Hull
• Added a CUSTOM weapon slot as requested in the 2nd RTSU Custom Component Thread on FFG
• Added fluff about each CUSTOM Component to ENTER PLAYER INFO page
• Added FIVE Custom Components from the 2nd RTSU Component Contest.

Thanks again to all the contributors in the Component Contest for the following custom Components now integrated into the RTSU:

• Drop Pod Bays by Alasseo
• Manufactorium by Quicksilver (Archeotech)
• Fission Genarium by Konrad von Richtmark
• Kass Immaterium Navigation Cogitator or Kass INC by Jenk (Xenotech)
• Apothecarium by Konrad von Richtmark

Coming soon: The THIRD COMPONENT CONTEST. Enter and maybe you can have your home brew component entered into the RTSU's next version!

Comments and criticism wanted

Example of Character Sheet Output:

The weapons were easier to finish than I originally thought (all hail copy/paste), so i'll have a file ready by this evening or earlier.

I need a password. It says I cannot edit this without removing the protection.

Sorry, thats an old habit. I've uploaded a unprotected file under the same link, just ditch the file you downloaded earlier.

Looks great, but where is the option to upgrade the crew?

Edit: Can you also add a box for the bonuses to morale and/or crew? I have a couple items that give bonuses and penalties to my morale and it would be awesome if the system auto-calculated them.

Thanks for the great work though!

Looks great, but in my version it doesn't seem to factor in the weapons in slots 3 to 5.

Gokerz said:

I can see that too. I'll check it and fix it.

On the crew, morale and population...its not implemented yet. I do intend to implement that. And thanks for reminding me about crew upgrades, i'll have to add that.

UPDATE: It was an easy fix. Version 1-2 is up for download at the link above. Weapon slots 3 through 5 work now.

This looks to be a useful utility. Thanks for creating it!

Happy to help. It was the first thing I wanted to have after cracking open the RT book but i haven't had the time to try making one until last week. Salut.

I think you gave the Warpsbane hull a cost of one extra power over a basic Gellar Field. As I understand it, the Warpsbane hull is bought instead of a normal Gellar field with the basic one included in the cost, not as an upgrade with a cumulative cost in power.

Gokerz said:

After re-reading the item I agree with you. I've added Geller Field as a checkbox under Essential Components so that you can choose to have one or both.

version 1-21 is up.

Added Crew and Morale max numbers (calculated) and a slot for actual numbers (user entry) to the build sheet.

version 1-22 is up (link in first post above).

added crew quality in version 1-23 (follow link in first post to get file).

Excellent work. I have already built my ship in the utility, which is awesome for tracking how much of everything you have spent. I am anxiously awaiting the character sheet addition so I can complete this thing!

Thanks a ton for all your hard work! Greatly appreciate it!

Loving it! This is perfect, and functional.

Minor bug: needs an option for no normal sensor array for when you take the archeotech autostabilized logis-targeter, unless that's already accounted for in the calculations?

Also, Observation Dome needs to add +50 to exploration endeavours

freelancerbob said:

Quite right, I added a 'Auger Array' selection in the down box that zeroes out the power/space/SP$ if you want only the 'Auto Stabilized Logis Targeter'. Thanks for that suggestion/correction freelancerbob

The incorrect math on Observation Dome is fixed, now when it is de-selected/selected its 50 bonus appears/disappears as it should. Thanks for that error report freelancerbob

version 1-25 is up (link do download page is in original thread post above)

Also the Archeotech "Bridge of Antiquity" replaces the need for a normal Bridge. would be nice to have a No Bridge or Bridge of Antiquity on the dropdown.

Cyric313 said:

That one I actually did think of but its not obvious; just click on the drop down menu and "Ships bridge" so it'll zero out the totals for normal bridges. Then hit the check box for 'Bridge of Antiquity' and your set

i Did that for my Group's ship but i still ent up with -1 power... hmm i might need to go over their ship myself and check.

Has my RT been trying to pull the wool over my eyes??

Found the error.

Seems like there is a Difference in the power rating on Ryza Pattern Plasma Battery in tables 8-4 and 8-5. one says 7 and the other says 8. hmm wonder which one is the correct one.

Good catch. In Drydock it only has the one table that says 8 power, not 7.

I'll check the errata on this message board. (ah, looks like scrow asked about it already).

Update April 1 -

working on version 1-26, character sheet; you can see some of the Essential Components pop up on the character sheet now (its automatic depending on what is selected).

caught a bug...Pressed Crew Quarters and Voidsmen Crew Quarters not adding to space/power/sp$ calcs; FIXED in version 1-26

version 1-26 is up and available for download (see first post in this thread for the link to the page).

This is looking better and better, really great work

If you want to make the sheet even more luxurious, you might include descriptions of all important modifiers ship's components give. For example:

+10BS to crew on Bridge (Shipmaster's bridge)

+10 command defending from Boarding actions and Hit and Run (Tenebro-Maze)

and so on. It's just too easy to forget these modifiers

What me and my group have just begun recording on our ship's summary sheet is the crew's disposition (from p.293 of RT). Doesn't come up that often, but is a nice bit of extra info in just eight words and gives a feel for how the Crew interacts with the Players and what kind of characer traits they tend to show.

Gokerz said:

Its definitely planned for the output on the Character Sheet for the ship.

Gokerz said:

I'll add this to the 'features list' i've been making up for the Character Sheet. Sounds like a good idea to me.

Ok, I can't seem to see anything on the Character Sheet tab. What am I doing wrong?

Thanks for an awesome tool that makes creating starships so much easier!