Drydock pre-release

The Universal Game of Starship Combat
mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3635
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: Drydock pre-release

Postby mj12games » Fri Apr 21, 2017 1:35 pm

MRCAcct wrote:Question: Why does Drydock round to the nearest multiple of 5? I ask because it doesn't state that in the rules.

Because I wanted to round to the nearest multiple of 5 for all the published ships, and forgot to put it back in the public release. :)

If you want to round to the nearest integer, unprotect the "Display" tab, select cell Q2, and alter the formula to read:

=MROUND(INDIRECT(T1&"!M5"),1)

Don't forget to protect the tab again when you're finished.
Daniel Kast
Majestic Twelve Games
www.mj12games.com

murtalianconfederacy
Admiral
Admiral
Posts: 1269
Joined: Tue Mar 29, 2005 8:56 am

Re: Drydock pre-release

Postby murtalianconfederacy » Sat Apr 22, 2017 8:42 am

EDIT: I AM A THICKO. A THICKY THICKO, KING OF THICKONIA.

/sighs

For some reason, I thought you had to enter the greater-than sign in front of the whole weapon name, not just the secondary mode 'name'. I can only blame it on the cold, my blithely skimming over the important part of the instructions and being used to the Shipyard.
Staff Door at my local Waterstones:

"This door is alarmed"

:) :)

murtalianconfederacy
Admiral
Admiral
Posts: 1269
Joined: Tue Mar 29, 2005 8:56 am

Re: Drydock pre-release

Postby murtalianconfederacy » Fri Apr 28, 2017 9:10 am

Now without a gonging head, I've noticed a couple of minor issues with Drydock. I had a look at the Tables sheet and discovered two 'typos':

1) the dual weapon mount modifier is listed as 1.7, when it should be 1.8 (according to the rulebook)

2) the TR arc is listed as having an arc modifier (number of arcs+1) of 7, when it should be 6.

What that means is that my King Thicko-class battleship is incorrectly pointed. Argghhh...
Staff Door at my local Waterstones:

"This door is alarmed"

:) :)

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3635
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: Drydock pre-release

Postby mj12games » Fri Apr 28, 2017 3:23 pm

Updated Drydock to v1.01 to fix errors identified by murtalianconfederacy.
Daniel Kast
Majestic Twelve Games
www.mj12games.com

murtalianconfederacy
Admiral
Admiral
Posts: 1269
Joined: Tue Mar 29, 2005 8:56 am

Re: Drydock pre-release

Postby murtalianconfederacy » Thu May 11, 2017 8:13 am

I had sent mj12games a PM about this, but as he hasn't been on for a week (thanks KDLadage for pointing it out), I'll post this up.

I found another couple mistakes. Two are easy fixes, one not so much (for my limited Excel-fu)

Slow weapon modifier is 0.7, should be 0.6

Guided+Telescopic shows as red--due to the range-based weapon trait column having a figure of 82, when it should be 80.

Selecting Piercing 1/2 and Proximity reads as an invalid combination.
Staff Door at my local Waterstones:

"This door is alarmed"

:) :)

bekosh
Lieutenant
Lieutenant
Posts: 153
Joined: Tue Mar 29, 2005 12:42 am
Location: West Bend WI

Re: Drydock pre-release

Postby bekosh » Thu May 11, 2017 1:23 pm

murtalianconfederacy wrote:I had sent mj12games a PM about this, but as he hasn't been on for a week (thanks KDLadage for pointing it out), I'll post this up.

I found another couple mistakes. Two are easy fixes, one not so much (for my limited Excel-fu)

Slow weapon modifier is 0.7, should be 0.6

Guided+Telescopic shows as red--due to the range-based weapon trait column having a figure of 82, when it should be 80.

Selecting Piercing 1/2 and Proximity reads as an invalid combination.

For the Piercing 1/2 (Pr1/Pr2) and Proximity (Prx) invalid combo, the problem is that Pr* in the formula in Weapons! AK2:AK101 just looks at the first 2 characters so Pr1 & Prx end up the same.
To fix it, in Weapons!AK2 change this:

Code: Select all

IF((COUNTIF(G2:K2,"NPr")+COUNTIF(G2:K2,"Pr*"))>1,1,0)

to this:

Code: Select all

IF((COUNTIF(G2:K2,"NPr")+COUNTIF(G2:K2,"Pr1")+COUNTIF(G2:K2,"Pr2"))>1,1,0)

and copy down through AK101.
Paul
Carpe Dementia!

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3635
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: Drydock pre-release

Postby mj12games » Thu May 11, 2017 3:05 pm

Thanks for catching those!

Download link updated to v1.02.
Daniel Kast
Majestic Twelve Games
www.mj12games.com

Doresh
Midshipman
Midshipman
Posts: 37
Joined: Sun Apr 24, 2011 12:23 pm

Re: Drydock pre-release

Postby Doresh » Fri May 12, 2017 9:51 pm

The Hyperdrive and Overthrusters systems determine their Space Units with [Engine Factor x 0.5], when the book uses a x0.6 multiplicator.

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3635
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: Drydock pre-release

Postby mj12games » Mon May 15, 2017 4:34 pm

Grrr.
Daniel Kast
Majestic Twelve Games
www.mj12games.com

Doresh
Midshipman
Midshipman
Posts: 37
Joined: Sun Apr 24, 2011 12:23 pm

Re: Drydock pre-release

Postby Doresh » Sat May 20, 2017 4:52 pm

It happens to the best of us.


Return to “Starmada”

Who is online

Users browsing this forum: No registered users and 3 guests