Jump to content



Photo

Starship Construction Utility RTSU v1.41 Published


  • Please log in to reply
289 replies to this topic

#1 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 30 March 2010 - 05:31 AM

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:

Example Character Sheet



#2 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 30 March 2010 - 07:11 AM

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.



#3 Scrow

Scrow

    Member

  • Members
  • 30 posts

Posted 30 March 2010 - 11:32 AM

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



#4 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 30 March 2010 - 01:03 PM

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



#5 Scrow

Scrow

    Member

  • Members
  • 30 posts

Posted 30 March 2010 - 07:45 PM

 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!



#6 Gokerz

Gokerz

    Member

  • Members
  • 155 posts

Posted 31 March 2010 - 04:19 AM

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



#7 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 31 March 2010 - 04:30 AM

Gokerz said:

 

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

 

 

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.



#8 Sister Callidia

Sister Callidia

    Member

  • Members
  • 459 posts

Posted 31 March 2010 - 04:38 AM

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



#9 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 31 March 2010 - 04:42 AM

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.



#10 Gokerz

Gokerz

    Member

  • Members
  • 155 posts

Posted 31 March 2010 - 06:09 AM

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.



#11 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 31 March 2010 - 07:55 AM

Gokerz said:

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.

 

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.



#12 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 31 March 2010 - 08:36 AM

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).



#13 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 31 March 2010 - 11:30 AM

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

 

 



#14 Scrow

Scrow

    Member

  • Members
  • 30 posts

Posted 31 March 2010 - 12:04 PM

 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!



#15 freelancerbob

freelancerbob

    Member

  • Members
  • 5 posts

Posted 31 March 2010 - 10:23 PM

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



#16 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 31 March 2010 - 10:47 PM

freelancerbob said:

 

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

 

 

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)

 

 



#17 Cyric313

Cyric313

    Member

  • Members
  • 43 posts

Posted 31 March 2010 - 11:38 PM

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. :)



#18 bobh

bobh

    Member

  • Members
  • 602 posts

Posted 31 March 2010 - 11:46 PM

Cyric313 said:

 

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. :)

 

 

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 :)



#19 Cyric313

Cyric313

    Member

  • Members
  • 43 posts

Posted 31 March 2010 - 11:50 PM

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?? ;)



#20 Cyric313

Cyric313

    Member

  • Members
  • 43 posts

Posted 01 April 2010 - 12:02 AM

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.






© 2013 Fantasy Flight Publishing, Inc. Fantasy Flight Games and the FFG logo are ® of Fantasy Flight Publishing, Inc.  All rights reserved.
Privacy Policy | Terms of Use | Contact | User Support | Rules Questions | Help | RSS