• Registered: 2022-11-14
  • Posts: 86

Re: Drydock pre-release

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:

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

to this:

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

and copy down through AK101.

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Drydock pre-release

Thanks for catching those!

Download link updated to v1.02.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2022-11-17
  • Posts: 18

Re: Drydock pre-release

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

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Drydock pre-release

Grrr.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2022-11-17
  • Posts: 18

Re: Drydock pre-release

It happens to the best of us.

  • Registered: 2012-04-21
  • Posts: 99

Re: Drydock pre-release

So, changing some aspects of Drydock is pretty straightforward (TABLES tab).

Say I wanted to add more sheets (or change sheet names) . Because I'm not 100% familiar with some of the formulas used...

As long as I add/change the names of the new sheets to the data validation/drop down box on the DISPLAY tab, everything should still work out fine right?

  • Registered: 2022-11-14
  • Posts: 86

Re: Drydock pre-release

There is more to it than that. Some of the cells on the Tables tab have calculations that refer back to the Ship# tabs.

  • Registered: 2007-03-30
  • Posts: 39

Re: Drydock pre-release

Overall, changing the DryDock spreadsheet is easy, except when you get to the Tables sheet (component column) that references the Ship* sheets.  I experienced this when recently converting DryDock from Excel to OpenOffice.

  • Registered: 2005-03-29
  • Posts: 859

Re: Drydock pre-release

Right, as I was preparing my first SUE supplement, I discovered a few problems with the Drydock. I'm sorry I didn't find these earlier:

--Screens don't get the Shield tech modifier applied to them

--Dual-Mode weapons: Smaller figure is being divided by 3, not 2 (was able to fix this myself)

--DRat doesn't round up, just rounds normally (a hull 1 ship with Shields 1 has a DRat of 2.4, which should round to 3, but it doesn't)

--Anti-Fighter Batteries has an ORat component (was able to fix this myself)

  • Registered: 2007-03-30
  • Posts: 39

Re: Drydock pre-release

Would you mind indicating the sheet, row/column and how you fixed these?  I would like to update my Excel and OpenOffice versions, and I am concerned that I would miss an item or two while attempting to find the problems you noted.  Thank you in advance!

murtalianconfederacy wrote:

Right, as I was preparing my first SUE supplement, I discovered a few problems with the Drydock. I'm sorry I didn't find these earlier:

--Screens don't get the Shield tech modifier applied to them

--Dual-Mode weapons: Smaller figure is being divided by 3, not 2 (was able to fix this myself)

--DRat doesn't round up, just rounds normally (a hull 1 ship with Shields 1 has a DRat of 2.4, which should round to 3, but it doesn't)

--Anti-Fighter Batteries has an ORat component (was able to fix this myself)

  • Registered: 2012-04-21
  • Posts: 99

Re: Drydock pre-release

murtalianconfederacy wrote:

Right, as I was preparing my first SUE supplement, I discovered a few problems with the Drydock. I'm sorry I didn't find these earlier:

*looks at all the stuff he's done so far, weeps uncontrollably*

  • Registered: 2005-03-29
  • Posts: 859

Re: Drydock pre-release

TeknoMerk wrote:

Would you mind indicating the sheet, row/column and how you fixed these?  I would like to update my Excel and OpenOffice versions, and I am concerned that I would miss an item or two while attempting to find the problems you noted.  Thank you in advance!

murtalianconfederacy wrote:

Right, as I was preparing my first SUE supplement, I discovered a few problems with the Drydock. I'm sorry I didn't find these earlier:

--Screens don't get the Shield tech modifier applied to them

--Dual-Mode weapons: Smaller figure is being divided by 3, not 2 (was able to fix this myself)

--DRat doesn't round up, just rounds normally (a hull 1 ship with Shields 1 has a DRat of 2.4, which should round to 3, but it doesn't)

--Anti-Fighter Batteries has an ORat component (was able to fix this myself)

WRT the dual-mode weapons, I unprotected each sheet, then in the box where the base SU requirement is listed (with a red circle below):

[attachment=0]Drydock pre-release dual-mode weapons correction.png[/attachment]

The original formula reads (for the first weapon battery):

=ROUND(MAX(M14:M15)+MIN(M14:M15)/3,1)

Which I changed to:

=ROUND(MAX(M14:M15)+MIN(M14:M15)/2,1)

Which seemed to correct the problem.

As for the AFB, I simply entered a '0' figure into each AFB's ORat column on the Tables sheet. I think this was because initially AFBs were to be closer to their AE version--an 'active' weapon system. The screens and the CRat rounding--I don't have any clue as to how to fix those, I'm afraid

  • Registered: 2022-11-14
  • Posts: 86

Re: Drydock pre-release

murtalianconfederacy wrote:

The screens and the DRat rounding--I don't have any clue as to how to fix those, I'm afraid

The DRat rounding (Cell L) is actually just the displayed number. If you right click the cell, go to Format Cells and increase the decimal places displayed it shows the 2.4 for a Hull 1 Shield 1. So all you need to do is add ROUNDUP to the formula in L5.
Change from,

=((C8+Q8)*12/(6-R10)*PRODUCT(N34:N43))+SUM(M34:M43)

to,

=ROUNDUP(((C8+Q8)*12/(6-R10)*PRODUCT(N34:N43))+SUM(M34:M43),0)

The screens can be fixed by changing the formula in O11.
The current formula does all of the multiplication first then the addition (Order of Operations) so the tech multiplier is getting zeroed out.
You just need to change this,

=50*C11+30*SUM(E11:H11)*W10

to this.

=(50*C11+30*SUM(E11:H11))*W10
  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Drydock pre-release

Updated download to v1.03, fixing the identified issues, as well as fixing weapon ORATs so they round up, rather than to the nearest integer.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2007-03-30
  • Posts: 39

Re: Drydock pre-release

Thank you all!  I will update my DryDock OpenOffice conversion to reflect these changes.

Dan, the DryDock links are still showing v1.02 modified on May 11.  Did the v1.03 get put elsewhere?

  • Registered: 2009-04-14
  • Posts: 82

Re: Drydock pre-release

TeknoMerk wrote:

Thank you all!  I will update my DryDock OpenOffice conversion to reflect these changes.

Where is such wonders found!?

  • Registered: 2005-03-29
  • Posts: 859

Re: Drydock pre-release

Just checked and, although it is saying v1.02, the current Drydock is v1.03. I'll enter some of my ships through it and make sure they match my p+p designs

bekosh wrote:

Snip helpful post

Thanks for the help bekosh, I'd have no idea how to 'fix' it myself...:)

  • Registered: 2005-03-29
  • Posts: 859

Re: Drydock pre-release

Good news: after testing it, the drydock seems okay (although I only gave it a couple ships to work through). Bad news: I realised that I'm really bad at using Directional Shielding. After first miscalculating the SU requirement (by not following all the steps listed) I then, for the re-design of the DEFSATs, instead of dividing by 6-EqSR, I divided by the EqSR, thus making a colossal error that ended up costing them 5-11 CRat more than they should. This experience has taught me to be wary when doing Directional Shielding...

  • Registered: 2007-03-30
  • Posts: 39

Re: Drydock pre-release

Alex Knight wrote:
TeknoMerk wrote:

Thank you all!  I will update my DryDock OpenOffice conversion to reflect these changes.

Where is such wonders found!?

I have not released the OpenOffice version for two reasons.  First, I am not done testing it with multiple ship designs.  Second, I customized my DryDock, and do not have a "standard" version:

* Changed Tech Level 2 to 3
* Renamed "Screens" to "Armor"
* Added Penetrating weapon ability, like Piercing but against Armor/Screens
* Added ship primary systems for critical hit effects: Bridge, Reactor, Life Support

Once I test what I have, I plan to create the standard version.  If anyone is interested, please just be a bit more patient.

  • Registered: 2007-03-30
  • Posts: 39

Re: Drydock pre-release

murtalianconfederacy wrote:

Just checked and, although it is saying v1.02, the current Drydock is v1.03. I'll enter some of my ships through it and make sure they match my p+p designs

Thank you for confirming the DryDock version.

  • Registered: 2010-03-09
  • Posts: 630

Re: Drydock pre-release

I tried the drydock and had some problems. OK, the weapons are sorted in alpha order.
But, after filling the various items, the display result is quite disappointing. I have twice the boxes for the hull and weapons, for example, other lines I don't know why there are here (from #57 to #81)
Also, whatever the weapons I install, the SU used aren't modified.

Marc

  • Registered: 2012-04-21
  • Posts: 99

Re: Drydock pre-release

Drydock's been working fine for me; I must have cranked out a couple hundred ships by now.

I'd simply delete and redownload the file, start with a fresh copy, see what happens.

  • Registered: 2010-03-09
  • Posts: 630

Re: Drydock pre-release

Ok, will try, but my copy is fresh from this week. BTW, it seems you can't cut and paste the display to include the ship in an excel file.
(edit: Tried that and the result is identical)

I noticed that the display sheet is already wrong (two hull sections, etc.)

Marc

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Drydock pre-release

You need to hide the unused rows using the filter in cell S1. Make sure only the "1" value is selected, and all the duplicate rows will be hidden.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2010-03-09
  • Posts: 630

Re: Drydock pre-release

Did this. Thanks, it works!
In the end, I use the drydock to create ships (normal) and I more or less cut and paste the ressilt on another excel sheet. I sligthly improved the reading but very slighty.

Marc