Topic: Shipbuilder help

If I attempt to input any data that results in an overstuffed hull, the values for Points, HVP, and Space Remaining are displayed at "#N/A", as stated in the hidden calcs at the sides and below the builder box.

Is this correct, or am I missing something to make this all work correctly?

A help file might help me here. Or a more cadet friendly version that puts a negative value for space remaining when I muss things up. Whenever I see "#N/A", I think my spreadsheet can't read a forumula.

If it matters, I'm running Bye Designs' Spred32. It's a quarter sized Excel clone that understands all the relevant formula. The numbers and results work for a while, but if I try to change too much data, I get the unbudgable "#N/A" results.

Perhaps the thing is getting stuck on values of "   " instead of "0" for empty cells, as for Special Equipment, for instance. Hmm, maybe I'll try that....

Hmm, it seems my help post is turning to ponderings.

I am certainly glad that the pencil and paper math is easy to do.

Re: Shipbuilder help

frigatesfan wrote:

If it matters, I'm running Bye Designs' Spred32. It's a quarter sized Excel clone that understands all the relevant formula. The numbers and results work for a while, but if I try to change too much data, I get the unbudgable "#N/A" results.

The spreadsheet has been tested in Excel, and none of the problems you report occur in that program. Unfortunately, I am not literate enough in other programs (like Spred32) to tell you what is happening there... sad

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com