Page 3 of 6

Re: Drydock pre-release

Posted: Fri Apr 21, 2017 1:35 pm
by mj12games
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.

Re: Drydock pre-release

Posted: Sat Apr 22, 2017 8:42 am
by murtalianconfederacy
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.

Re: Drydock pre-release

Posted: Fri Apr 28, 2017 9:10 am
by murtalianconfederacy
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...

Re: Drydock pre-release

Posted: Fri Apr 28, 2017 3:23 pm
by mj12games
Updated Drydock to v1.01 to fix errors identified by murtalianconfederacy.

Re: Drydock pre-release

Posted: Thu May 11, 2017 8:13 am
by murtalianconfederacy
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.

Re: Drydock pre-release

Posted: Thu May 11, 2017 1:23 pm
by bekosh
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.

Re: Drydock pre-release

Posted: Thu May 11, 2017 3:05 pm
by mj12games
Thanks for catching those!

Download link updated to v1.02.

Re: Drydock pre-release

Posted: Fri May 12, 2017 9:51 pm
by Doresh
The Hyperdrive and Overthrusters systems determine their Space Units with [Engine Factor x 0.5], when the book uses a x0.6 multiplicator.

Re: Drydock pre-release

Posted: Mon May 15, 2017 4:34 pm
by mj12games
Grrr.

Re: Drydock pre-release

Posted: Sat May 20, 2017 4:52 pm
by Doresh
It happens to the best of us.