[FT] Fleet Book ship construction sheet v0.4

FYI, To anyone who is using the Fleet Book ship construction sheet v0.4 (Excel
spreadsheet) by Jared Noble: I have found an error in the spreadsheet. On any
weapon with a choice of
number of arcs (Class 2+, Pulse Torpedo, etc.), the spreadsheet does not
multiply the mass for extra arcs by the number of weapons.

For example the Class-3 beam formula for mass is:
  4*B20+C20 (4*No of Weapons+no of extra arcs)
  Produces: 2 Class-3 beam weapons with 2 arcs of fire shows a mass of 9
(should be 10).

Due to presidence in operators (*,/,+,-...), the multiplication occurs
before the addition.

It should read:
  B20*(4+C20)  [No of weapons * (4 + no of extra arcs)

The problem is the same on the solve for mass page.

I have not checked the other versions of this spreadsheet.

---

> FYI,

I believe you're supposed to put in the _total_ number of extra arcs,
e.g. 2
Beam-3's with 1 extra arc each means you put in 2, not 1.  I grant you,
it's not obvious.

Ahhh. Usage error on my part.

---
Brian Bell bkb@beol.net <mailto:bkb@beol.net>
http://members.xoom.com/rlyehable/
---

[quoted original message omitted]

Jared Noble confirmed today (in a very gracious way) that Laserlight was
correct.
He sends greetings to the GZG-L list and looks forward to the time that
he can rejoin the list.

---
Brian Bell bkb@beol.net <mailto:bkb@beol.net>
http://members.xoom.com/rlyehable/
---

[quoted original message omitted]

> FYI,

Actually, as I designed the original, it was intentional. That way you could
buy "sets" of extra arcs, and assign them to the weapon you wanted. Otherwise
all your Class 3 batteries would have to have the same arcs.