Hi all,
Using the fabulous list builder created by Scorch as a spring board, I have made a customizable army roster in Excel. Like Scorch's, it will calculate army cost, SWC, regular/irregular, and impetuous orders, and you will have to manually enter the skills and weapons manually. However, there are drop-down lists incorporated with the unit entry so the unit type (LI, MI, etc.), Cube, Instruction (Regular/Irregular), Fury (Impetuous & Extreme, Frenzy) and Hackable statuses are also shown. From those menus, the roster will automatically tally each order type for the respective combat group. The roster will also let you know if you have over-spent on SWC by turing the cell red.
https://www.dropbox.com/s/m9vps635mf21d66/Army%20Roster.xlsx?dl=0
Instructions:
Use the drop-down menus on the left-hand side of the unit profile to select the proper information for that unit. The drop-down menus follow the same order as in the .pdfs (unit type, cube, instruction, fury, hackable). The points and SWC for the unit are entered on the top right of the profile, with Cost and then SWC listed (the SWC cells also have a decimal place - i.e., 0.0 - while the cost cells do not). The running army tally is on the top right corner of the first page. As a sample, I have filled out the roster with a 100 pt list I will be fielding Sunday. Deleting empty profile spaces will not affect the coding within the file (use the delete cells command, and ignore any errors). To make more army rosters, simply create more worksheets, and then copy/paste the original into the new ones. WARNING: Do not delete the first worksheet 'Codes', unless you want to FUBAR the drop-down menus.