No, that's intentional.

You see, the weapons tech level is a special thing, where...

Oh, never mind.

You're right.

I'll release a "fixed" version in a day or two (just in case there are any other minor bugs to report). But for now, change as follows:

Cell J19: =ROUNDUP(J17*J18,0)
Cell J25: =ROUNDUP(J23*J24,0)
Cell J31: =ROUNDUP(J29*J30,0)

Yeah, yeah...

Change:

Cell H20: =IF(D16="",0,ROUND(J19/G13*(B11+D16)/D16*IF(D16=24,1.25,IF(D16=30,1.5,1)),1))
Cell H26: =IF(D22="",0,ROUND(J25/G13*(B11+D22)/D22*IF(D22=24,1.25,IF(D22=30,1.5,1)),1))
Cell H31: =IF(D28="",0,ROUND(J31/G13*(B11+D28)/D28*IF(D28=24,1.25,IF(D28=30,1.5,1)),1))

Yes.

I hate you.

My only issue is that I wish the XLT file had 5 weapons slots instead of three. It is going to be hard to convert some of the (secret project name related to googleplex's comment) designs to the new format due to spinal mounts  and antifighter batteries becoming true weapons. The fact that the XLT does not allow a spinal mount conversion "by the book" for ships larger than size 5 is not that big of a deal, because honestly I think maxing out the DMG and then raising the IMP (or visa versa) as needed works even better for spinal mounts. It also allows you to personalize spinal mounts for each nation/race which I really like. Who really wants to roll 20 dice when you could roll a set of 4 and then a set of 5 anyway?

I would also kindly request adding at least 4-5 weapon slots to the sheet, if at all possible. That would make life easier for me, too, as I won't have to go back and add that in later (and possibly break something else in the process!).

BJ: Read p.72 for spinal mounts and other X conversion notes. Believe me, with a japanese fleet, I gots to have my spinal mounts. P.72 game 'em back.

Cricket: Oh BTW for the shipbuilder sheet, Dan, if you can find it in your heart to specify a "text" type field for weapon accuracy, all OpenOffice users would be much obliged. At worst, if it isn't possible to retain field type across the file import, please stick "Change the Accuracy field type to 'Text' if using OpenOffice" in the notes somewhere. I remember I had a difficult time finding this little tidbit of information a while back and the sheet breaks without it in OO (it converts 4+ to just plain 4) .

Steph

PS: Thanks for the quick printer friendly version turnaround.

Uploaded version 1.1 to the web site: mj12games.com/starmada/shipbuilder.xlt

The stated revision is to fix the Tech Level bugs -- but I also cleaned up a few things and changed the "ACC" boxes to text values.

I'll see what it looks like...

You can imbed a graphic in the spreadsheet. I can't imagine it needing to be real big in bytes.....

Yeah, but that may break compatibility with Open Office.

I don't own excel, and won't.....

The places to put # of weapons of a certain arc is a pull down for batteries Y and Z, but not for X.

andy

Also how do I add a new option to the drop down I see column Q to V, but want to add another campaign specific Aux System. If I put it in row Q19 to V19 it does not seem to appear in the drop downs. Thanks for any assistance you can provide.

I think step 3 needs to read A34:A43, but please confirm. Also found an easier way to do it. If you highlight a Q:V line higher than row 18 and insert->shift Cells down, then add the item item to the newly inserted row, it seems to automagically do it.