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.