I was able to get the original version to work, but I'm having a problem with the Open Office one.  I'm supposed to copy the Template sheet to a new sheet for each ship, right?

As soon as I copy the sheet, the new one as #NA for Used and Left.

What am I missing?

thanks
andy

Hmm, I'll take a look at that.  Seems maybe someone pointed me there before, and I don't think I ever did.  I must have forgotten.

Thanks, looking now.

andy

To limit the range to 12, I think what you really do is design all that fleet's weapons with ranges 12 or less.  Then when you design ships, those are all the choices you get.

andy

I suppose all the people that actually play Starmada are out playing while newbies like Uncle Joe and me fiddle with this.  I suppose we're in the same boat. 

Anyway, in case anyone is interested, here is a comparison between the standard rule, my suggestion, Uncle Joe's suggestion, and plain R*P*D.
Note that this is only the part of the formula for these values.  You multiply this with range, a to-hit factor, and special factors.

R is ROF
P is PEN
D is DMG

A is current rule (R+1)*P*D
B is R*P*D+R
C is R*P*D (just for the sake of comparison)
D is R*(P+.5)*(D+.5) (last column only because it isn't integer)

(The first time I put it up, it was wrong, and I've had to edit it.  If you looked at it soon after it came out, sorry, look again.  I think these get emailed out, too (I use the forum), and if so, sorry for the spam.)

R  P  D    A   B   C    D
1  1  1:   2,  2,  1,   2.25
1  1  2:   4,  3,  2,   3.75
1  1  3:   6,  4,  3,   5.25
1  2  1:   4,  3,  2,   3.75
1  2  2:   8,  5,  4,   6.25
1  2  3:  12,  7,  6,   8.75
1  3  1:   6,  4,  3,   5.25
1  3  2:  12,  7,  6,   8.75
1  3  3:  18, 10,  9,  12.25
2  1  1:   3,  4,  2,   4.5
2  1  2:   6,  6,  4,   7.5
2  1  3:   9,  8,  6,  10.5
2  2  1:   6,  6,  4,   7.5
2  2  2:  12, 10,  8,  12.5
2  2  3:  18, 14, 12,  17.5
2  3  1:   9,  8,  6,  10.5
2  3  2:  18, 14, 12,  17.5
2  3  3:  27, 20, 18,  24.5
3  1  1:   4,  6,  3,   6.75
3  1  2:   8,  9,  6,  11.25
3  1  3:  12, 12,  9,  15.75
3  2  1:   8,  9,  6,  11.25
3  2  2:  16, 15, 12,  18.75
3  2  3:  24, 21, 18,  26.25
3  3  1:  12, 12,  9,  15.75
3  3  2:  24, 21, 18,  26.25
3  3  3:  36, 30, 27,  36.75

With all the Excel sheets, I'm sure someone else here could have done this.  I've seen plenty of newbies step in and try to change things, and I'm not.  But in case you guys do want to consider these values, here you go.

andy

I know I'm just being a busybody, since I haven't yet played the game and am asking about stuff pretty basic to the point and space system, but I like this kind of thing.    (Note that I like it in point systems and stuff done before the game.  I like playing games to be really simple.)

Maybe the effect you were thinking of for:
(ROF+1) X PEN X DMG
Would be reasonably achieved with something more like:
ROF X PEN X DMG + ROF
?

Here are some sample numbers for this term of the equation.  S1 is current ((R+1)PD), and S2 is (RPD + R).  Done in my head, so maybe wrong. 

R P D S1  S2
1 1 1  2    2
1 2 1  4    3
1 2 2  8    5
2 1 1  3    3
2 1 2  6    5
2 2 2  12   8
1 1 3  6    4
3 1 1  4    6
3 1 3  12  12
3 1 2  8    9
3 2 2  16  15
1 2 3  12  7
2 2 3  18  14
3 3 3  36  30

And I'm not asking anybody to change the point and space systems for me, with all those published ships out there.  But if I'm reading right, it doesn't do what was expected.

Oh, and my son is reasonably interested in trying Starmada this weekend, especially after seeing the shipyard utility.  (It appeals to his tinkering instincts--he's 13 and related to me, so he likes stuff like that.)  I've got a hex mat made from printing out a bunch of hex sheets and taping them together (from when I was experimenting with vector navigation for fighters--I don't really care for vector movement for bigger ships).  All we need is time.

andy

Oh, you know, I was looking at space used, rather than points.  I was fiddling with the shipyard sheet and watching numbers, and wasn't thinking about what the numbers were.

OK, then.  2/1/1 has the advantage of taking less space than 1/1/2, right?
18 SU vs 24 SU.  3/1/1 is 24 SU, 1/1/3 is 36 SU.  [Andy goes and looks up SU costs for weapons in the rules.]  Oh, I see, you add 1 to ROF.

Does that have much of an effect on ship designs?  What's the rationale?

Thanks for pointing that out.

andy

How about typical ROF, PEN, and DMG numbers?  I see the point values go up quite a bit as you increase the numbers for later steps.  I've been looking around the Shipyard group, and some of the fleets in the Files directory use a lot of variety there.  I haven't seen as many instances of setting those over 1 so far skimming the Brigade stats in the book (I'm looking at the PDF, and maybe I haven't gotten to some that do yet).

I know--I won't really get it until I've played some.  Things are busy, and I can occasionally find time to fiddle around while online.  But setting aside space and time at home.  I've given my son warning we're going to try Starmada out soon.

andy

Thanks.  But what I meant by "use" was whether you spread them out across the table, or what?  The FT ship records are small enough to put a fleet on a page (with space for orders on another sheet).  The Starmada ones don't look like they'll shrink well.

andy