Battle Armor Designers or Spreadsheets?

[Cowdragon]

Non-missile weapons get the first 'clip' of ammunition included within the mass of the weapon itself, in addition they pay only mass to add additional ammunition, although ammunition use is not tracked on the BT scale.

One-shot missile launchers include their single shot within the mass of the weapon, cannot add extra shots and their use is tracked at both the BT and RPG scales.

Standard missile launchers do not get any shots included within the mass and space of the launcher itself, and must pay both mass and space for all ammunition, with ammunition usage tracked at both the BT and RPG scales.

that's fantastic news! That means I can have one variant with a LRR, 2 vibro claws, ECM, and improved stealth armor while the next variant simply trades out for a Magshot. A "fire support" version to augment squads of the more standard one. Cool! Thanks :)

[worktroll]

I made this spreadsheet for my own use, but you're welcome to use it. It's not as refined as it could be, but it works :)

Just found this now - many thanks! Works well.

W

[Sabelkatten]

I did some work on the sheet since SSWMs weren't working (as far as I could see). Not sure how cost and BV works, thought. :-\

[Adgar76]

Glad to see that people are finding it useful  O0

Hey Sabelkatten, actually Squad Support Weapons ARE in.. i just forgot to name the field on the spreadsheet  ::)
Squad support weapons should go in that single field tucked in between the Weapons & Equipment fields and the Infantry weapons on the bottom of the sheet. I did test it, and it works fine as far as i can see, but i guess that i'll have to put in some explanatory notes sooner or later.
PA Weasley was kind enough to point out a few bugs, and considering that i made a few small improvements on the spreadsheet since i posted the original version, i think it's time for an update.
Please post here, or PM me, any bugs you find so i can fix them; in particular there might be a few in BV calculations, but i haven't been able to pinpoint them yet.

[Cowdragon]

thanks for the new stuff guys! Very nice :)

[Freihändler]

Hello!

A very neat BA sheet! Thank you for this very useful "Mini-Tool"!

[Adgar76]

Updated the spreadsheet with the new stuff from the TacOps Errata. Have fun  >:D

P.S. the new items seem to work just fine, but please look out for any errors.

[Pa Weasley]

Thank you sir!

[Ratwedge]

Updated the spreadsheet with the new stuff from the TacOps Errata. Have fun  >:D

P.S. the new items seem to work just fine, but please look out for any errors.

You are a gentleman and a scholar.

[worktroll]

Thanks again!

[Dragon Cat]

Been playing around with this all night glad I found it

thanks for creating

[Flashhawk]

Great stuff! Just am about to design a real big bunch of BA!
Would it be possible to work in a record sheet page, if only for one squad? We could copy and paste them to a different page then to have regular recsheets. Especially the weapon stats would be nice to have as in the HMBA rec-sheets you know?
Thanks in advance
Flashhaw

[Colt Ward]

Thanks to WT for coaching me through using this tool.  And thank the maker!

Too used to making my own limited spreadsheets without using anyone else's work.