Page 1 of 1

Shipyard help?

Posted: Wed Jun 21, 2017 3:59 pm
by Weirdo
I've been trying to edit my shipyard file, in order to print out Starfleet Armada ships on sheets that have the firing arc diagrams and other data missing from the book sheets. However...I think I broke something, as it doesn't seem to be calculating the CRAT properly anymore. Can anyone tell me what I broke, please?


(Note: I'd like to stick to this version of the spreadsheet, so that the point values are consistent with all of my other conversions.) ... A.xls?dl=0

Re: Shipyard help?

Posted: Sun Jun 25, 2017 10:30 am
by OldnGrey
Try sending a PM to bekosh, he probably has not noticed since you put shipyard in the subject.
This is "Myshipbuilder v9.x by Paul Polter"


Re: Shipyard help?

Posted: Mon Jun 26, 2017 1:30 pm
by bekosh
Sorry, I didn't realize this was mine.
It looks like the problem is in the equipment list on the ship sheet. The list needs to be in alphabetical order and the Tractor Beam and Probe are missing the ORAT/CRAT info.

The latest version v9.0c of the spreadsheet is in the Starmada/Files section. You could look through the change log and see if the changes will affect your ships. Most of the changes after v5 were for the Klingon Armada additions which you might want anyway.

If you want to stick with the v5.0b it is also still in the Files section. I tried downloading it but the file seems to be corrupted.

Re: Shipyard help?

Posted: Mon Jun 26, 2017 3:28 pm
by Weirdo
Thanks! Aside from the formula for calculating the ORAT of probes(I've managed to figure that part out with some outside help), how should their lines look?

Re: Shipyard help?

Posted: Mon Jun 26, 2017 4:47 pm
by bekosh
Make sure that the Probe and Tractor Beam ORAT multiplier (Column BS) and the DRAT multiplier (Column BU) have a value of 1. If it is blank or a 0 then the calculation will zero out. Red below.

Probe (BR)=5, (BS)=1, (BT)=Your calculated ORAT number, (BU)=1, (BV)=0
Tractor Beam (BR)=14, (BS)=1, (BT)=ROUNDUP((14*(6+AV9)/6),0) AV9 is the Engines value, (BU)=1, (BV)=0

Hopefully that makes sense.

Re: Shipyard help?

Posted: Tue Jun 27, 2017 7:12 pm
by Weirdo
That did it, thanks! My values are a little off from the published ones(311 vs the published 279), but I figure that's due to some setting-specific stuff they did behind the scenes. As long as these are consistent with each other and with other ships I've made with this sheet, I'm happy.

Thanks again!