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

Thanks for the feed back.
I should check the shipyard at times other than Midnight or later. It has grown into a bit of a beast and I miss things at times. It still has some things from Starmada X just waiting to be re activated (like ablative armor, which could be used as strengthened hull integrity etc.)

The Text sheet should have been linked, as you say, to the Template sheet in this manner (Much easier). Note though that it is Two lines for each battery. You need Template.$C$157&Template.$C$158 for X battery.

Would have posted the corrected shipyard earlier, been having trouble getting onto the files page at yahoo (Two HOURS later.)

Version 4c posted

Link:http://games.groups.yahoo.com/group/mj12games/files/Shipyard%20for%20Starmada%20AE/

Paul

You did nothing wrong, Microsoft did. I use Open Office calc and save the shipyard as .xls (Excel 97/2000/XP compatible.) This has worked fine until Excel was re-written recently. For some reason the new Excel changes how some of the calculations are handled. I understand that these are indicated by small triangles. See earlier threads, changing numbers back from being "Text" sometimes works.

Due to this some people use Open Office for the shipyard. It is free from openoffice.org or if you are in the UK, Computer Shopper has version 2.4 on the DVD. It is a complete package, Calc (Spreadsheet), Writer, draw, a database and presentation.

You should have no problems using it with open office, I have been updating the shipyard with it for a few years now.
If you spot anything which is confusing or looks wrong just let me know.

Hope that you like the shipyard, it can look a bit busy as all of the workings are visible. Have you had a look at the pdf for the shipyard yet?

Paul

Thanks, Glad you like the shipyard.
Ship design should be fun and if this makes it easier, all the better.

You have probably spotted that there are bits left over from Starmada X and no longer do anything. There are a few things which could be linked back in if Dan changes anything in the future ( the way some things moved over from earlier versions into Starmada X, they did not go, just took a break.)

If you spot anything I do not mind you sending an email although I tend to put any little corrections on the forum as well as updating the spreadsheet. Some groups have altered the shipyard to suit and it saves them having to start over.

The re-write for AE/ISS/HAC changed how some things were done and as demster found, I can forget to update the odd bit.

Paul