1 Reply by demster

(11 replies, posted in Starmada)

Hi,

I downloaded the Shipyard and really enjoy it.  While using it I found a couple of things I recommend.

First when using Ammo the OCR incorrect on Template tab, column AX.  It calculates the SU as if the weapon has no ammo.  I corrected the SU by taking the Final SU Cost/Tech Modifier in the formula.

On the Text Tab it doesn't show the total number of weapons.  To correct it I just linked to the cell in Template tab that shows all of the weapons.  Example for Battery X I link cell  A10 on the Text tab to cell C157 on the Template tab.

Regards,
Denby

Go to forum: Starmada

2 Reply by demster

(166 replies, posted in Starmada)

Hi,

Yesterday I was trying to create a hull size 2 ship with ammo.  When this happened the ORAT and CRAT when to N/A.  By investigating the formula I see that your hull sizes listed in M8:M12 are 3, 8, 15, 24, 35.  The vlookup you have in the formula currently rounds down so by using 3 as the lowest number hull size 1 and 2 ships error out.  Due to the rounding down I think you want to change the cells to 1, 4, 9 , 16, 25.  This should return the correct value that matches the ISS manual.

Regards,
Demster

Go to forum: Starmada