a link would make it perfect

Hello Paul,

I like your SAE Ship designer spreadsheet.  It could be useful.  I am able to use the small craft calculation part to calculate the cost of drones & fighters I use.   Unfortunately, I am unable to make the ship designer work completely.  I can save weapons in the blue area on the Nation tab.  I can design a ship, but its combat value is not calculated.  Where I think it should be, I get  #N/A  in the box.  I tried to print out the design, but got several sheets, all with  #N/A  where the point value probably should be.   :shock:

Is there a place in the program where directions are posted?  I have it stored & running thru Micorsoft Excell. 
I hope that this is not the problem. 
Any help you could give would be appreciated.  I am trying to make SAE versions of Battlefleet Gothic ships. 8)

Steven Gilchrist; Jacksonville, Fla, USA

Steve-

i suspect that the lack of a CR calculation is due to a formatting error that Excel somehow inserts when it opens from Paul's OpenCalc version of the spreadsheet. The SU calculation obviously requires numbers, but some important cells get formatted as text, and the program cannot add "abc" to "1.34" for example.

The symptom of this problem can be seen on the Nations sheet- look for little green triangles in the upper left cells, particularly in the ACC column (this is where I found them), which indicate a number that is formatted as text. These are text because they are input from a number table that is also formatted as text.

That table can be found on the "Tables" sheet as the To HIT table. Cells B19 through B25 may also show the green triangles. If so, simply highlight those cells, punch "Format Cells" as "Number"- all SU are then correctly calculated- at least this is what occurred in my case.

If you version of Excel has a different affected site, the principle is the same- trace the green triangle cells back to their source data, re-format those data to numbers-- should work

lamont

This is seriously weird, I checked back to version 1.2 and the ACC is formatted as numbers as is the section that they come from, Is Excel changing it? I have read that the latest Excel is not even compatible with some earlier Excel spreadsheets. I can not comment as I do not have Excel, not had the money for it (Excel is quite expensive here.)
I have gone over these tables again in v1.8 to see if it will help.
It is not easy to see where these problems are caused when I can not duplicate them.
Of course if everyone had a free copy of Open Office calc (Vista version now available)........
Paul

Paul,

I downloaded the Version 1.9 and noticed little triangles in the corners nearly everywhere.  I cannot make it calculate the cost, and still get  #N/A as the cost.  :oops: 
But the small craft part works so what I will continue doing is to use your program's small craft tab to calculate the SU requirements of customized seekers, etc, then transfer the info to the other SAE shipmaker 2.0 version.

I have downloaded Open Office, but do not know how to make the Shipmaker1.9 go into it.
PCs can be so &$%$ing frustrating!!!  Obviously our world is "-5" Tech in PCs...  :shock: <LOL>

Steven Gilchrist; Jacksonville, Fla, USA

Hello Paul,

My roommate is much more skilled with computers than I am.  With his help, I was able to run your fine program thru Open Office.  I have not had time to fiddle with it, but the 4 Hull, 4 Speed, 1 shield ship U left on there had its SUs calculated and its CR calculated instead of getting a #N/A. 
I am going to replicate a ship of mine and compare them.
Using the 2.0, I get a cost of 1261 for this ship of mine, which is a standard Battleship of mine
I view it as an Eleven Hull ship with Reinforced Hull, Compendium style.  It is effective in battle 8)   

(1261)  USS Mississippi             
             
Hull: 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1               
Engines: 8 8 8 7 7 7 6 6 6 5 5 4 4 4 3 3 3 2 2 2 1 1               
Screens: 9 9 9 8 8 7 7 7 6 6 5 5 5 4 4 3 3 3 2 2 1 1               
Weapons:             
1:X 2:X 3:X 4:X 5:Y 6:Y             
             
X: 14 Inch Guns: 10/20/30, 1/2+/1/3             
Piercing             
[GHIJK][GHIJK][GHIJK][GHIJK][GHIJK][GHIJK]
[HIJKL][HIJKL][HIJKL][HIJKL][HIJKL][HIJKL]             
             
Y: 5 Inch Guns: 6/12/18, 1/2+/1/1             
[HIJK][HIJK][HIJK][HIJK]             
             
Special: Hyperdrive; Armor Plating; Marines (5); Teleporters (2); Science (100); Hospital (100); Cargo (800); Repair (100); Transport (100)             

I am going to try replicating this ship using the v1.9 and will let you know how it goes and what the CR is ...

Steven Gilchrist; Jacksonville, Fla, USA

Playing around with the shipyard I noticed that the more weapons I added to a given battery, the less SUs were beiung "used". I think it is a problem with the "Ammo" function. I put in weapon arcs and the counter shows a drop in SUs, but then I add in the number of weapons in that arc, and the counter goes UP! I did the same weapon set up with and without Ammo and it seems to work ok without the ammo option. I am using Open Office Calc. I have Excel as well, but the sheet does get very wonky with multiple formats for the lookups, and I too end up with lots of green triangles and N/As. Error tracing shows they are fixable and probably an artifact of Excel converting the data. I started out fixing the formatting, but as each version has come out I have slowly just stopped bothering. Sorry for rambling, I'm still working on my first cup of coffee.
Erik

Hi Paul,
The engine and weapons tech for USS Mississippi design are both set at +3, and the general tech is set at +1. There are actually 44 SU left.  :shock:
I designed this ship using the most recent SAE Shipdesigner version 2.0 from the website.  The CR is actually 1229. I typed in the CR of a slightly larger ship b4 (100%blond here)<LOL>

Steven Gilchrist; Jacksonville, Fla, USA
PS:  On version 1.9, when I put in 9 for screens, I get 36 of them (!)

The weapon SU calculations seem to very messed up.  :?
It seems like the only battery that is correctly figuring SUs is the X battery. I don't think it's me this time    The X Battery seems to be doing everything as it should when double checked with a calculator, but the other batteres are giving me yuck.
Erik

the weapon had Extra Hull Damage as well-

The CR is off by one (shipyard vs shipbuilder)on 2nd and 3rd batteries

regards to SU

adding batteries Y and Z to X, with single arc, single weapons, show 2 and then 4 less SU respectively in shipyard relative to shipbuilder

if i add a second weapon of same type to each battery, shipyard SU now equals 557 vs shipbuilder SU of 569, difference of 12

third weapon addition: shipyard SU left = 305, shipbuilder SU left = 323, difference of 18

looks like a simple math thing here that is multiplied by multiple arcs and weapons

lamont

I downloaded Version 2.2 and after a quick run through it seems to be working. The earlier version I was using is going to the recycle bin  I'll let you know if I notice any inconsistancies. Thanks!
Erik