Myshipbuilder v6 by Paul Polter

[bekosh]

I think I have all the bugs worked out of this. Please let me know if you find anything that I missed.
(So much for that theory.)

Myshipbuilder v6.0 updated for Klingon Armada.

*Edit*-v6.0a Updated with Drake Notation.
*Edit*-v6.0b Corrected ORAT rounding.
*Edit*-v6.0c Corrected formula for Tractor Beam ORAT & added Probe DRAT.
*Edit*-v6.0d Corrected the Weapons TL modifier, was not effecting the battery SU value.
*Edit*-v6.0e Removed the Probe DRAT, Corrected Tractor Beam ORAT rounding and Station ACC divisors .
*Edit*-v6.0f Corrected the Flotilla sheet display. Corrected rounding for weapons with ammo. Added weapons hit chart to Drake notation.
*Edit*-v6.0g Corrected another rounding problem for weapons with ammo. Changed the way KLA Shuttle trigger, added a Y/N dialog box. Added fighter flights with sizes less than 4 to allow for fleets like the SFB Hydrans with 1-2 fighters on almost every ship.
*Edit*-v6.0h Shields on the flotilla sheet were not being adjusted for tech level. Dual mode weapons were only calculating correctly if the larger of the 2 SU values was in the second slot. It will now work both ways.
*Edit*-v6.1 There was an error in the SU calculation for each battery. I fixed a rounding error in the battery ORAT calculation in v6.0g and didn't fix it in the SU calculation. Also, the CRAT was rounding up instead of rounding to the nearest whole number.
*Edit*-v6.1a Resorted Weapons Traits on Weapon build sheet and all three templates.
*Edit*-v6.1b Added Ammo to the Drake notation.
*Edit*-v6.1c Changed the cell format on the Fighter Build sheet to 'Text" because Open Office wasn't automaticaly updating the Capacity. Also added Notes for Critical Damage Save, number of Damage Control Dice and Launch/Recovery maximums.
*Edit*-v6.1d Fixed weapon display for Drake notation.
*Edit*-v6.1e Fixed cloaking device DRat mod of x2.

[Blacklancer99]

Any possibility of adding a text/Drake Notation sheet? I think it could hold people back from using the sheet if it is more difficult to post things to the Basin or in my case, import a text-based ship data sheet into Vassal. Sure, I can type the data out myself, but being the average lazy American that I am I am more likely to use a design sheet that does it for me, and all I have to do is copy and paste. Just a thought.
Erik

[Only Warlock]

Am I doing something wrong? On the Ship Template section I cannot enter any weapon data (The Drop-down only has "0" as an option.

[bekosh]

Any possibility of adding a text/Drake Notation sheet?
Erik

Here you go Eric. Updated file added to OP.

Am I doing something wrong? On the Ship Template section I cannot enter any weapon data (The Drop-down only has "0" as an option.

The Workbook is setup so you can build an entire fleet.

Design your weapons on the "Weapons" Tab & Fighters on the "Fighters Build" tab.
For multi mode weapons, design each mode in a different slot. Also note that each weapon must have it's own unique name. For ex. you would need to name the Range 12 Disrupter as "Mk1" or something to tell the difference between it and the Range 18 Disrupter.

Then copy the "Ship Template" and design your ship. You can do this for as many ships/flotillas/stations as you want.

[Only Warlock]

Ahh Ok, I grok that! thanks!

[Blacklancer99]

Any possibility of adding a text/Drake Notation sheet?
Erik

Here you go Eric. Updated file added to OP.

Very cool thanks! I can not get down to business

[kjncindy]

I am messing with your shipbuilder and I like it a lot. Very easy to use and handy.

I tried duplicating the Klingon D7 from Klingon Armada but am getting a slightly different point value. Has anyone else tried this? I am not sure which stat I have wrong but the PV in KA is 282 and I am getting 294 with the shipbuilder.

Thanks!

Ken

[bekosh]

Sorry I wasn't able to get at this today. We're getting hit with a major cold snap with freezing temps overnight tonight, so I had to take care of winterizing my boat today. (Whatever happened to that 'Global Warming' everyone was talking about?)

I will take a look the sheet tomorrow and do some manual calculations to compare. I already see that there is a rounding issue in the ORAT calculation that I will have to fix.

[bekosh]

Here is the D7 calculated with shipbuilder v6.0b. The red text are the detailed numbers. I also calculated this with pencil, paper & calculator, and matched this exactly.

Maybe Dan or one of the other experts can point out where my calculations are going wrong vs the published 282 CRAT.

Type: D7, Battlecruiser, Klingon (275)
Hull: 9 8 7 6 5 4 3 2 1
Engines: [TL0] 6 6 5 4 4 3 2 2 1
Faceted: [TL0] 14 13 11 10 8 7 5 4 2
Facets: (3,2,2,2,2,3) Base DRAT: 33.75
Weapons: [TL0]
Battery V: Phaser-1, 5/10/15, 1/4+/1/1, Range-Based ROF
[abcd] [abcd] [abcd]
Base SU: 15, Total SU: 225, ORAT: 315
Battery W: Phaser-2, 4/8/12, 1/5+/1/1, Range-Based ROF
[acf] [bde] [ce] [ce] [df] [df]
Base SU: 8, Total SU: 160, ORAT: 240
Battery X: Mode1: Disrupter LR, 6/12/18, 1/4+/2/1
Mode2: Disrupter LR (OL), 6/12/18, 1/5+/4/1, Carronade
[ab] [ab] [ab] [ab]
Base SU: 24, Total SU: 288, ORAT: 384

Special: [TL0] Drone Rack (3) ORAT: 180 DRAT: 7.2; Marines (14) DRAT: 14; Probe (5) ORAT: 60; Science (100); Shuttle (2) ORAT: 30 DRAT: 1.2; Tractor Beam (3) Base SU: 2, Total SU: 42, ORAT: 84; Teleporters (5) ORAT: 50

Fighters: [TL0]
3xDrone, 4/8/0, (Seeker/4+)
2xShuttle, 1/4/0, (Boarding Pod/5+)(Seeker/4+)

Total ORAT: 1343
Total DRAT: 56.2
Total CRAT: 275

[kjncindy]

I downloaded the new shipbuilder and also found my error. Although I had entered the values for the faceted shields I had not selected facet for the shield type. I now get 275 for the PV, as well.

Thanks!

Ken

[cricket]

You appear to have an ORAT of 28 for each tractor beam: they should be 22, which would bring your ORAT total to 1325.

You're missing a DRAT of 4 for the probes (0.8 each), which would bring your total to 60.2

1325 x 60.2 = 79765^.5 = 282.4

[bekosh]

Thanks Dan.
I forgot the .78 multiplier for the Anti-fighter & Fighter Exclusive traits.

Spreadsheet in the OP updated to v6.0c with correct formula for Tractor Beam ORAT & Probe DRAT.

[kjncindy]

Are the KA ships designed with tech levels other than 0? I am using version c of the ship builder and am 321 space units over for the Klingon D7 if I am reading the numbers correctly. Am I doing something wrong?

Thanks,

Ken

[bekosh]

Are the KA ships designed with tech levels other than 0? I am using version c of the ship builder and am 321 space units over for the Klingon D7 if I am reading the numbers correctly. Am I doing something wrong?

Thanks,

Ken

No you're fine. I asked the same question. Here is Dan's reply.

2) The official ships appear to use more SU's than their hull size would indicate. Were they designed using Tech levels greater than 0? Or were they designed ignoring the overage?

They were designed to match their capabilities in SFB/FC.

[bekosh]

I was checking the tech levels and found an error in the weapons formula. TL weren't effecting them at all. Corrected in v6.0d in OP.