Shipyard Latest

A home for player-submitted files related to Starmada
csragamaster
Sub-Lieutenant
Sub-Lieutenant
Posts: 75
Joined: Thu Oct 21, 2010 2:09 am
Location: Savannah GA
Contact:

Re: Shipyard Latest

Postby csragamaster » Wed Sep 07, 2011 2:28 am

As always, thanks for your work Paul.
http://gnomecon.org/
Gnomecon
Savannah Georgia's Newest Convention
April 20-23, 2012

netWilk
Midshipman
Midshipman
Posts: 32
Joined: Sat Mar 07, 2009 4:26 am

Re: Shipyard Latest

Postby netWilk » Fri Feb 03, 2012 4:34 am

Found a bug in weapon calculations for dual mode weapons for Fleet Ops.

In cells R137-R151 you calculate the dual mode weapon multiplier. But this multiplier is calculated as = dualmode/mode2, so it is only valid for calculating mode 2 attack dice. For mode 1 you'll need to divide by mode 1 SUs, ie ($BB$48/$AZ$48). So bug fix will either require an if statement, or a second DMode column.

Was wondering why my Klingon Armada conversions were off... :)

OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Re: Shipyard Latest

Postby OldnGrey » Fri Feb 03, 2012 12:34 pm

netWilk wrote:Found a bug in weapon calculations for dual mode weapons for Fleet Ops.

In cells R137-R151 you calculate the dual mode weapon multiplier. But this multiplier is calculated as = dualmode/mode2, so it is only valid for calculating mode 2 attack dice. For mode 1 you'll need to divide by mode 1 SUs, ie ($BB$48/$AZ$48). So bug fix will either require an if statement, or a second DMode column.

Was wondering why my Klingon Armada conversions were off... :)

Thanks, I have made a correction. :oops:
Please test version 64, this should have fixed it but confirmation would be welcome.

Paul

netWilk
Midshipman
Midshipman
Posts: 32
Joined: Sat Mar 07, 2009 4:26 am

Re: Shipyard Latest

Postby netWilk » Fri Feb 03, 2012 3:49 pm

Looks like it is working great now.

Thanks,

Lucas

evanmiller70
Midshipman
Midshipman
Posts: 17
Joined: Wed Dec 22, 2010 2:36 pm

Re: Shipyard Latest

Postby evanmiller70 » Sat Jun 02, 2012 2:59 pm

thank you for your hardv work. i do have a question. the shield and weapons on my forms always comes out in letters. i am not the most computer literat is there a font in supposed to download and how would i d that?
your friend evan

OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Re: Shipyard Latest

Postby OldnGrey » Sat Jun 02, 2012 5:21 pm

evanmiller70 wrote:thank you for your hardv work. i do have a question. the shield and weapons on my forms always comes out in letters. i am not the most computer literat is there a font in supposed to download and how would i d that?
your friend evan

The shipyard does not need any special font so could you please give me a cell reference.
Do you mean those in shipyard nova?
If so, there is a font which I made and put in with the spreadsheet. OnGsheet1.ttf font.
Right click on the font and choose install from the list.

Edit, I see what has happened. " - copy" got tagged onto the font. It should read as above. I will repost the file meantime please edit the name and install.

Paul

OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Re: Shipyard Latest

Postby OldnGrey » Thu Aug 09, 2012 6:33 pm

There has been a slight change in the figures for converting weapons for SFO, see thread:
viewtopic.php?f=58&t=5103

I have updated the shipyard with the new figures. Now Version VFv65 20120809.

Paul

bkjohns96
Posts: 7
Joined: Sun Jan 18, 2009 6:54 am

Re: Shipyard Latest

Postby bkjohns96 » Tue Jun 24, 2014 5:02 pm

First off, I love this program. I am having a hard time trying to give my weapons the "accurate" trait. How do I give them this trait in the designer? Any help appreciated.

OldnGrey
Admiral
Admiral
Posts: 1230
Joined: Wed Jun 08, 2005 1:29 pm

Re: Shipyard Latest

Postby OldnGrey » Tue Jun 24, 2014 7:10 pm

bkjohns96 wrote:First off, I love this program. I am having a hard time trying to give my weapons the "accurate" trait. How do I give them this trait in the designer? Any help appreciated.

Thanks, glad it gets used.
This thread is the Admiralty shipyard and weapons do not have an Accurate trait, if you mean Fire Control it is on the Template sheet.
Shipyard AE Fire Control.png
Shipyard AE Fire Control.png (6.89 KiB) Viewed 1291 times

If you mean Accurate in Nova it can be chosen from the second traits column onwards (drop down menu).
Shipyard Nova Accurate.png
Shipyard Nova Accurate.png (7.8 KiB) Viewed 1291 times


Paul

ecs05norway
Posts: 7
Joined: Wed Oct 21, 2009 1:54 pm

Re: Shipyard Latest

Postby ecs05norway » Sat Jan 17, 2015 3:49 am

Tested this today in Excel 2013 and I'm getting repeated errors about an object named BBI1 conflicting with something else. I'll try to get the exact error message when I have another chance at my windows box.


Return to “Files”

Who is online

Users browsing this forum: No registered users and 1 guest