bz dd 3

bz dd 1

bz dd 2

bz dd 4

bz dd 5

bz dd 6

bz dd 7

bz dd 8

bz dd 9

bz dd 10

The New Hotness

Okay, so I got to messing around with the Battletech Roster Builder spreadsheet and decided to add some more features. The bad news is, I had to start using Macros. As long as this is the only place you get my spreadsheet, you can be reasonably sure the macros contain no malicious code.

So the new features are:

  • You can now field five Units per line item. This means you can use one line item to field up to an entire star of units.
  • Event Macros on the four Battalion tabs that will automatically rename the tab to the Battalion name. So if you put "Erandi Light Horse" into the Battalion name on one of the Battalion tabs, the tab will rename itself "Erandi Light Horse TO&E."
  • Button Macros on the List builder tab. You can sort your list by tonnage then Name, Tonnage and Battalion, Tonnage and Type of Unit (infantry, Vehicle, Battlemech, etc.), by the Type of unit only, and most importantly, Clear All Pilots. This will wipe all of the Pilot Gunnery/Piloting, If C3 is active and any external ordinance (in case of Aerospace) for all Unit groups. My contact email is in the spreadsheet if you want to suggest other sorting methods.
  • On the Print Roster, if you had multiple units from one line item, they would appear in different parts of the list. So with a lot of restructuring of cells, I got everyone together and in order.

Here is the link to the article.

Related Articles

Wisdoms of War

Feline Battletech

All material this website © 2012-2023 The Battletech Zone. Any pictures,
descriptions and opinions unless otherwise noted are those of the site's owner.
Permission to quote or copy sections is allowed if attribution is given
and linked back to this website.

Free Joomla! templates by Engine Templates