Topic: Drydock 1.04 critical error

Ok, so I just downloaded the v1.04 drydock and started to make my first ship and it looks like all of the weapon trait lookups are completely broken. The first thing I did is make a list of different weapons to choose from, but when I started to add them to the ship from the dropdowns it was showing the name right, but picking a different row from the weapons tab altogether. I thought maybe I did something to screw up the sheet so I went and got a fresh copy but it's still doing the same thing.

I'm not terrible at Excel so I unprotected it and unhide all the calculation rows and it looks like row Q of the ship tab and all the ones on the weapons tab have the approximate match clause in the vlookup left blank, meaning they find the first thing that's close, instead of the correct one.

Re: Drydock 1.04 critical error

Couple things:

1) Are you using v1.04a of the Drydock?

2) Did you sort the entries on the WEAPONS tab alphabetically?

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

Re: Drydock 1.04 critical error

I am using the newest version of it. I am not sorting the weapons tab alphabetically.

In an unrelated note, is anyone interested in a copy of the drydock that has been laboriously edited so you don't have to sort weapons alphabetically?

Re: Drydock 1.04 critical error

I actually had no idea VLOOKUP would work on a non-sorted list until your post, so that's something. smile

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com