Kingbreakers’ Long Patrol and Standard Combat Landspeeders

kingbreakers-iconSome time ago, my buddy Matt gave me a half-complete conversion project. He’d taken a Landspeeder, cut up the cab, and added some bedrolls, smoke launchers, and a Storm Bolter type thing on an extra wing frame. His aim was to build some sort of IG recon vehicle, but he decided it wasn’t going anywhere and handed it over.

With all the bedrolls and such I started thinking of it as a Long Patrol Landspeeder. The fluff notion became that the Kingbreakers employed a number of these on extended solitary patrols around Forestway, their home planet, and later in other systems as well. ‘Speeders intended for this purpose were grafted with extra sensors, lights, small weapons, comms gear, and provisions stores in order to sustain themselves for long periods, detect anomalies and enemies, and report back. Given the small size of the chapter and the reconnaissance oriented mission, these were manned with semi-automated guns so that a single Marine could take up the duty and potentially be unavailable for a good period of time. That practice only became even more important when the chapter was decimated in the tragic undoing of Forestway, a tale for another time. After that, many such recon units were further converted to have an armored cab so that a Scout could undertake those long range patrols and recce flights with relatively assured survival, helping to free all full battle brothers for deployment in front line combat.

Back in reality, at the time I finished putting the model together I didn’t have a ton of extra Marines to convert into pilots, and Matt’s were largely missing. I also liked the idea of a lonely Marine out on patrol; it fit in with the somewhat outdoorsy, quiet, solitary background mood of the Kingbreakers. Given that Matt had already added some packs, searchlights, and so on, it also only made sense to add some more doo-dads and really push it in that direction. In the end, I built up a little cab out of clay, a gun turret out of a Devastator squad Multi-Melta and the cone of a dead laser pointer, a nose mounted Heavy Flamer from a bits bag Jason traded me for some magnets, and a bunch of gribblies from random bits.

Last week I finally got around to painting that Long Patrol Landspeeder:

Kingbreakers' Long Patrol Landspeeder

Kingbreakers' Long Patrol Landspeeder

long-frontlong-rightlong-rear

I’m pretty happy with how this turned out. For some reason it’s a little shinier than I expected, even after dull coating, but not too bad in real life. Most importantly, the cab fits in with the body and with the narrow vision slit is even vaguely reminiscent of the official Tempest model, so that worked out reasonably well.

On that note, sometime earlier this winter I also painted up a standard Landspeeder model:

Kingbreakers' Standard Combat Landspeeder

Kingbreakers' Standard Combat Landspeeder

std-rightOn the construction side of things, I like the Landspeeder models a lot as they’re fairly straightforward to assemble, and quick to paint. Between these two I didn’t find a huge difference in painting before versus after assembly, but would probably do the former in the future. Really the slowest parts are the two Marine pilots, but they’re not too bad if done before assembly. The Kingbreakers icons are done with custom decals I made up. Like all my vehicles, these were base coated with cheap black spray paint. The main paint components in the Kingbreakers’ scheme are Privateer Press Paints’ Hammerfall Khaki, Ordic Olive, and Exile Blue, respectively washed with GW Gryphon Sepia, Thraka Green, and Asurmen Blue. The washes highlight the shapes of the components and provide a little bit of a weathered look I like, with basically no effort. I’ve found so far that really edging the lines on vehicles takes a ton of time and doesn’t really stand out on the gaming table, so for both these models I skipped that step in favor of getting them done.

I’m also pretty happy with how the bases on both came out. Given the large size and relatively visible nature of these on Landspeeders, they’re definitely worth spending a minute or two on:

Standard Combat 'Speeder Base

Standard Combat 'Speeder Base

Long Patrol 'Speeder Base Front

Long Patrol 'Speeder Base Front

Long Patrol 'Speeder Base Rear

Long Patrol 'Speeder Base Rear

Both bases were done quickly and easily. I built up the Standard Combat base with some greystuff blobs to give it a little bit of a smoothed rock texture. The Long Patrol base is textured with some hacked up balsa wood and bits from a toy race car. Both were sprayed black with the rest of their model, then painted Scorched Brown. They were then drybrushed to a greater or lesser extent with Snakebite Leather. The Standard Combat base was then also drybrushed with Bronzed Flesh, and the metal bits on the Long Patrol picked out in Boltgun Metal. The Standard base was then washed in Devlan Mud and the Long base in Gryphon Sepia. On both bases I then glued on some green flock, fake wheat grass, and fake lichen. Those elements were then randomly brushed again with the same wash as the base to darken them, tie them into the base, and add some color variation.

Finally, both have been constructed to disassemble, enabling easier storage, representation of battle damage and destruction, and swappable nose weapons:

Disassembled Standard Combat 'Speeder

Disassembled Standard Combat 'Speeder

On the Standard Combat model I cut off the tip of the flight base and simply glued on a 1/8″ magnet, with a corresponding partner sunk into the hole the base usually inserts into, after it had been slightly enlarged. The standard ‘Speeder model is light enough that this basically works if set level—it swings around easily, but is super stable when picked up or set down on the table. The Heavy Flamer similarly has a 1/8″ magnet sunk into it, and a matching one in the nose gun mount.

I had no base for the Long Patrol speeder, so I used a wood dowel rod supported by a balsa chunk on a cutout piece of plasticard. With the extra weight of the cab, the model was too heavy to sit readily at the somewhat more dynamic angle I cut the support rod at with just the magnet holding it together. To counter that, I added a sheath around the magnet on the ‘Speeder body that the base dowel fits into. Between that and the magnets it’s rock solid, even when set to pretty crazy angles. The Heavy Flamer was done similarly as the Standard model, just offset to the side a bit on the body.

One note about magnetizing like this is that it’s really hard to bind magnets to most surfaces with glue, so I usually wind up using greystuff or greenstuff to set them in place.

In game terms I play both of these simply as standard Landspeeders, usually outfitted with a Multi-Melta and Heavy Flamer in an all-comers list. All in all, I’ve come to view Landspeeders as one of the bright stars in the Marines’ lineup, and one of their definite advantages on the battlefield. More thoughts on their tactics will have to await another day, but suffice to say it’s become pretty rare for me to leave home without these, even for very small games, and I expect to build more for this summer’s ‘Ard Boyz.

More and higher res pictures of both models are available in the Flickr gallery.

Combat Patrol Tournament/Campaign Design Notes (Part 2)

combat-patrol-smRecently, Pangloss and Equinox have been having a pretty good discussion about Combat Patrol in 5th Edition:

In an earlier post I talked a bit about some of the reasons I like Combat Patrol, namely accessibility, faster games, and reduced rock-paper-scissors effects, which can be dramatic in low points games. I’ve also talked a bit in the past about general issues in small 40k games. I thought I’d add on to my earlier points with some more thoughts on revising the rules to better accommodate the current codexes and rules.

The Zoanthrope says: "You best get good at rolling Leadership Tests!"

The Zoanthrope says: "You best get good at rolling Leadership Tests!"

As a case in point for why revisions are necessary, consider the new Tyranid codex. Due to the restrictions to 2 Wounds and 4+ Invulnerable saves, there are no Synapse Creatures permitted in Combat Patrol under the new book. For those unaware, without coverage from Synapse, almost every Tyranid unit has to pass a Leadership check. Otherwise it either storms toward the enemy or hides. That severely hampers playing the new book in Combat Patrol, unless you field purely hordes of Genestealers, who are not subject to Synapse, but have no ranged weapons. That also gets a little boring after a while. This essentially eliminates a very popular army from playing, a substantial problem.

Points Limits

I agree that 750pts is pushing the upper bound for Combat Patrol; beyond that it’s too constricting and should generally be played as a standard game. But I think a good set of rules could work well over ~250–750 pts, and create a game atmosphere that feels different from standard 40k but is similar enough to just sit down and go. Like Equinox said, that’s an important goal.

A major determinant in what points levels work depends on what armies are used. A friend and I regularly play 250pts. That’s probably the lower bound without true skirmish rules, but we have fun though pushing models around at lunchtime. It works because he’s running Chaos Marines and I run Space Marines, and that’s just enough points to both have some choices and field some variety. Other armies really struggle at even 400pts; Necrons are the classic example, Grey Knights are another. Viable points levels depends a lot on who’s playing.

I think the set points clearly depends on what people what to get out of it, and there isn’t a need to be too strict about what is “Combat Patrol” and what’s not. For example, one reason we’re running 750pts in our tournament is because it allows a good number of units, which in turn enables more varied mission scenarios. At 400pts a lot of armies basically field only two units, so it’d be hard to have objectives and other special scenario goals. Asymmetric scenarios, played with alternating roles, were also something we liked the sound of. But, we also wanted people to be able to play after work. The 750pt limit supports those competing goals, while also being a slightly longer match than 400pts. We have, however, applied the Combat Patrol rules rather than just limiting the points, largely in order to prevent rock-paper-scissors list making issues. Similarly, 400pts is very fast to play, very accessible, and a lot of fun in its own right. There’s clearly a place for both.

HQs

A great number of HQ units definitely seem potentially unbalanced at these point levels, or not in the spirit of the missions if you care about that sort of thing. I think you can keep out “crazy” HQs by keeping some sort of restriction against uniques, but let in the “regular” HQs by drifting the allowable wounds up to 3. That enables IG Company Commanders, Tyranid Warriors, Space Marine Captains, etc., all of which are reasonable to me, but cuts out Abaddon, Marneus, etc., whom I think present problems. More on “Uniques” later.

"Outflanked again, Sgt Jericho?  This never would have happened if Captain Angholan had been permitted to join the patrol!"

"Outflanked again, Sgt Jericho? This never would have happened if Captain Angholan had been permitted to join the patrol!"

In any case though, I don’t think HQs should be required. Too many are glass jaws to force them at this point level. For example, a Space Marine Captain is actually a tough sell. I wouldn’t say that they really bring in their 100+ pts on average; ditto Librarians—sometimes they come up huge, but a lot of times they don’t. Chaplains also essentially force a unit to lose Combat Tactics, which is unfortunate. All are solid selections in a full list with other units to synergize with and many other models on the table, but I wouldn’t want to be forced to take one with so few points available. Conversely, I wouldn’t want them disallowed either. For this week’s tournament mission, I would have strongly considered a Captain and Command Squad—the first time I’ve ever seriously thought of the latter—but the Captain is out due to the traditional 2 wounds restriction.

Heavy Supports

In my opinion, Armor Value restrictions keep out sufficient HS. I wouldn’t ban HS completely and eliminate Devastators or Havocs, they don’t seem out of line for the feel of the game.

I also don’t see the traditional restriction against Ordnance as being necessary. If someone wants to field a Basilisk, Predator, Whirlwind, or something, I’d be ok with it, and think it’s reasonably fluffy—a lone vehicle making its way to a new position with its escort or some such. Especially on a smaller table, they’ll be prone to assault or concentrated attack, and the armor value on this units is not particularly higher than the transports; I don’t think they’d be dominating choices.

At 750pts I’d actually lift the armor restriction a bit, maybe to 34 total points rather than 33. In that size army you can field enough options to have some reasonable anti-vehicle plan, and could work to take down more heavily armored vehicles. I would probably not say this at 400pts though; the environment is just very different. In particular, my experience has been that Dreadnoughts are devastating and frequently unstoppable at that point level.

Either way, even at 750pts I’d hesitate to let in a Land Raider, Monolith, or similar vehicle. It’s true that they would be a huge points risk that might be taken out relatively easily—I’ve had Sternguard take out even an entire Baneblade by themselves in the first round of shooting, and Landspeeders can regularly do the same for Land Raiders. But I think these are just too much of a rock-paper-scissors risk at these point levels for my taste. Those also have accessibility issues for newer players trying to compete.

One idea that came up in our group is to have a total limit for the army. Something like you can field any vehicles, but the combined armor across all of them must be less than 100 (or something). That would let you use one or two big vehicles, or a couple smaller vehicles, or a mix. It might be just as easy though to say “One vehicle with armor up to 34 (or 35, etc) and any number with armor up to 33.”

Elites and Fast Attack

Tight limits on FA and Elites are also problematic. I think a squad of Sternguard and a couple Landspeeders is fairly fluffy for combat patrol. Landspeeders, Rough Riders, and Sentinels all also provide for all-FA lists very much in keeping with the spirit of Combat Patrol. Appropriate mission rules probably counter any problems here. In our tournament, you could bring a ton of Elites, FA, etc., but many of the missions have objectives, so it behooves you to bring Troops, just like standard 40k.

General Unit Restrictions

Like Pangloss said, I also think Equinox’s proposed 200pt maximum per unit restriction is too tough, although the intent is good. As noted, a squad of Marines is 170pts. Add a Rhino or a Powerfist and a Plasmagun and they’re over that limit. The problem with saying they can just take five man squads is then they don’t have access to heavy and special weapons. Cheap weapons are one of the primary advantages for Space Marines compared to many races, and their main anti-horde and anti-vehicle counter abilities, so robbing them of that would really hinder them unfairly.

These Termagants haven't realized yet that they're supposed to be Lurking...

These Termagants haven't realized yet that they're supposed to be Lurking...

Lifting the permitted wounds to 3 is essentially required, if only to enable Tyranids a few viable Synapse Creatures. It also permits the generic Space Marine Captains and Chapter Masters (and consequently Command Squads), IG Company Commanders, and many other units that don’t seem unreasonable.

Not discussed so far is if the traditional Combat Patrol restriction to no better than 3+/4+ saves should be relaxed. I am torn on this. One argument I see for relaxing it are Zoanthropes, an important Synapse Creature option for Tyranids. However, if permitted wounds are bumped up—basically a requirement, I think—Tyranid players can cover Synapse via at least Warriors. I also don’t see a reason to cut out Techmarines. However, I have mixed feelings about Terminators. They’re admittedly super hard to take down and could cleave through another army, but even at 750pts they would be a significant fraction of a list to invest in just a few models. They also don’t generally score, so the mission scenarios will enforce some sort of natural balance. Including them would also enable Dark Angels players to use their preferred codex and existing units. One plausible option might be to allow 2+ armor saves, or 3+ invulnerables, but not both. This would permit Zoanthropes, Captains in Artificier Armor, Honor Guards, Techmarines, etc., but not Terminators.

Similar to Equinox, I also don’t have issues with upgrade characters like Telion or Harker. They just don’t seem that unbalancing; they’re useful, but they’re a bunch of points as well. The key here is the wording, enabling these guys but keeping out crazy HQs. Toward that end, I think the wording should be “No Unique Independent Characters, Unique Monstrous Creatures, or Special Characters.” The rationale behind this specific wording is based on:

  • Space Marines: Telion does not technically say Unique (he has a special rule limiting him to 1 squad), but Chronus does; neither are Independent Characters. The fancy HQ characters are of course all Unique Independent Characters.
  • Chaos Marines: All named characters are Unique Independent Characters.
  • Orks: Snikrot and Zagstruk are not Independent Character, nor technically Unique, and hence would be allowed. The few named HQs are Unique Independent Characters.
  • Tau: Aun’va, Farsight, and Shadowsun use the old terminology and are listed as Special Characters, not as Uniques.
  • IG: Yarrick is a Unique Independent Character; all the company commander characters and other upgrades are Unique, but not Independent Characters. Marbo is also Unique Infantry and would be allowed.
  • Chaos Demons: All the named demons are Unique Monstrous Creatures, not Independent Characters. Interestingly, Fateweaver is a Unique Monstrous Creature with only 3 wounds so it would not otherwise be covered by the rules without this wording.
  • Tyranid: Most of the named characters are Unique Monstrous Creatures, though Parasite of Mortex is Unique Jump Infantry and Deathleaper is Unique Infantry and would be allowed.

I think that wording strikes a reasonable balance, permitting these manageable, colorful upgrade characters and a few solos, but disallowing the real heavies.

Rules Suggestions

That makes my current thinking on revised Combat Patrol rules something like:

  • Missions should set army lists at no more than 250–750 points.
  • Armies must include 1 Troop unit and may have up to 2 HQ, 6 Troop, 2 Elite, 2 Fast Attack, and 2 Heavy Support units.
  • No Unique Independent Characters, Unique Monstrous Creatures, or Special Characters are permitted.
  • No model may have more than 3 wounds.
  • Any model with a 2+ Armor Save may not have an Invulnerable save.
  • Any model with a 3+ Armor Save may not have better than a 4+ Invulnerable Save.
  • In a 500pt or below game, no vehicle may have total armor value (Front+Side+Rear) greater than 33.
  • In a 501–750pt game, no vehicle may have total armor value (Front+Side+Rear) greater than 34.
  • Units which don’t occupy Force Organization slots, such as Dedicated Transports and Retinues, are permitted caveat the other rules.
  • Before deployment, each player must declare one model in their army to be their Patrol Leader. There must not be a model in the army with a higher Leadership value. Note that this implies the Patrol Leader is not a vehicle.
  • Missions should be played on 4’x4′ tables.

The Patrol Leader isn’t important for standard mission setups, but I think it’s a handy designation to have in writing custom scenarios given that there’s not necessarily an HQ in each list. For example, in our tournament preserving or killing Patrol Leaders has been worth Bonus Points on several occasions.

Glancing through the codexes I have and the main rulebook, these rules seem to disallow the following for 750pt games; in general, no named characters are permitted except as discussed above regarding “Uniques”:

  • Orks: No Battlewagons.
  • Chaos Marines: No Terminators, Oblits, Daemon Princes, Greater Demons, or Land Raider variants.
  • Chaos Demons: No Bloodthirsters, or Soul Grinders.
  • Daemonhunters: No Grand Masters, Brother Captains, Terminators, or Land Raider variants.
  • Tau: Broadsides, Crisis Shas’O Commander, Hammerheads, or Sky Rays.
  • Black Templars: No Emperor’s Champions, Terminators, Land Raider variants.
  • Space Marines: No Drop Pods, Terminators, or Land Raider variants.
  • Necrons: No Wraiths, or Monoliths.
  • Imperial Guard: No Leman Russ variants.
  • Tyranids: No Swarmlord, Hive Tyrants, Tervigons, Zoanthropes (3+ Inv), Doom of Malantai, Carnifexes, Old One Eye, Trygons, Mawlocs, or Tyrannofexes

Dropping the permitted vehicle armor values to 33 at 500pts further eliminates:

  • Orks: No Deff Dreads.
  • Chaos Marines: No Predators, Vindicators, Defilers, or Dreadnoughts.
  • Space Marines and other Imperials: No Dreadnoughts, Predators, Vindicators, or Dreadnoughts.
  • Imperial Guard: No Hellhound variants, Death Strikes, Valkyries or Vendettas,

Those rules also eliminate some wargear and combinations, such as Storm Shields combined with Artificer Armor. Interestingly, Mycetic Spores have only 3 wounds and a 4+ save, so Tyranids would always have their Drop Pod. For Synapse they would be able to choose from Tyranid Primes, the Parasite of Mortex, and Zoanthropes.

Conclusion

I had sort of thought the forthcoming 40k Missions Book from GW would have material along these lines, including revised Kill Team or Combat Patrol rules and missions. The part of me that refuses to accept that they don’t playtest or think about a lot of their design products nearly as much as the community does was actually hoping for that. However, that doesn’t seem to be the case.

Of the suggested rules above, I feel pretty comfortable with the vehicle restrictions. The armor and invulnerable save restrictions however might be too permissive however. I’ll have to think about them more. As always, comments are welcome!

Army Building via Spreadsheets: Tips

Recently there’s been a lot of hoopla about software used to construct army lists. I’ll (mostly) ignore for now the obvious irony in Lone Wolf attacking people for IP violations. As a case in point though, check out this graphic from their store page:

purchase_electronic

All that aside, I’ve never really seen the appeal. Admittedly, Lone Wolf’s Army Builder produces spiffy reports that would otherwise take a fair bit of time to do up—I know, I’ve spent a good bit of time LaTeXing fancy looking roster sheets myself. But for $40? A simple spreadsheet using software you already have or can get for free (e.g., OpenOffice), would seem to fill the bill nearly as well, as compared to shelling out basically the price of a whole squad or vehicle model.

I thought I’d note a couple tips on how I set up my spreadsheets. No rocket science, but maybe useful for people not as familiar with Excel or similar programs. I use OpenOffice Calc mostly, but everything should carry over directly to Excel, and I’ve noted differences of which I’m aware.

This is my basic format; note that I’ve sized the columns appropriately so it all fits in a portrait printout and I get as many units as possible onto one page:

army-spreadsheet2

First, note that I’ve got a ton of tabs. When I create a list for a “serious” game, I copy a previous similar list into a new worksheet tab in the file and work from there. That way I have one organized place with all the different lists I’ve used. There are two reasons for this: 1) It’s sometimes nice to go back and look up what list I used for a particular match. 2) It makes it easier to copy and paste different setups. For example, the next time I run Terminators in a list I can just tab over and copy their entry from one of my ‘Ard Boyz lists.

Another note is that I’ve set the header row to be in view no matter how I scroll down. This makes everything much easier to read. You can do this by selecting the row just below the one(s) you want visible, then hitting Window->Freeze Panes in the menu bar.

Somewhat unfortunately, frozen rows (or columns) aren’t put on each page of a print out. To do that you need to establish a repeating print range. In OpenOffice you can do that by going to Format->Print Ranges->Edit Print Range and entering the rows you want to repeat on each page. There are some notes on that here. In Excel you do that via File->Page Setup->Sheet->Print Titles and entering the rows you want. These let you tell the software to include the frozen header row on every page of your print out as well, not just the on-screen display.

Next, I have a bunch of different columns:

  • Type: The standard unit types—HQ, Troop, Transport (for non-FOC Dedicated Transports), Elite, Fast Attack, and Heavy Support. I abbreviate the latter as Attack and Heavy so the column can be smaller and have less whitespace in the other types.
  • Unit: The unit, with a designator when appropriate, e.g., “Tactical 3.”
  • Wargear: I use this column to itemize upgrades purchased for the unit. I could do this in the Unit column, but splitting it out makes for nice indentation and easier visual management.
  • Qty: How many of that item I am buying. This mostly applies to Wargear or Squadrons. A blank is assumed to be ‘1’.
  • Cost: How many points one item of that type costs, e.g., 90 for the initial 5 Marines in a Tactical Squad, or 5 for a Sternguard Combi-Melta.
  • Use: Whether or not I’m using the item in this list; an “X” mark here means yes. I’ll return to this in a second.
  • Total: How many points this item costs in total, i.e., quantity times cost.
  • Role: A place to put notes for myself on what I’m planning to do with that unit.

The Role column is obviously not critical, but can really help in working on and planning a list over time, e.g., for a big tournament. This is a simple addition that I’ve found has really helped focus my thinking about my units: What I want them to achieve, whether or not they’re worth it, and sticking to the plan in-game.

Somewhat similarly to the Role column, in working on a big list over time I frequently also add a column to track a unit’s status, i.e., purchased, assembled, painted, etc.

Now on to the slightly more interesting stuff…

I like making lists, and spend a decent amount of time before big games working out what I want to use. The Use column lets me experiment with that and quickly try out different combos. Basically, the Total column is only calculated if the item is marked as being used. This is done by filling the Total column with a formula like this:

=IF(F3="x";IF(D3=0;1;D3)*E3;0)

In that formula, F is the Use column, D the Qty column, and E the Cost. This is from the third row, hence F3, D3, E3. You can enter the equivalent formula into the first entry in your Total column, and then copy it down the page by selecting all the rows you want it in and then hitting Edit->Fill Down. The row numbers will be automatically appropriately increased for each one.

What that formula says is that if the Use column does not have an “X” then the item is not in use and the Total for it is set to 0 so that it’s not included in my army sum. If the item is in use, then the Total is set to be Qty times Cost. The inner IF in the formula says that if Qty is blank, then it should be assumed to be a 1. This makes the whole sheet much more visually appealing and easier to read than if it had a 1 in the Qty column for the vast majority of entries.

That may all sound like overkill, but what it lets me do is very quickly pop units and wargear in and out of my list to try out different combinations and see if I can come in under the points total for the match. Not sure you want that Assault Cannon? Uncheck it, and see what your new total is. Think you might actually need it? Mark it again and change the quantity on extra Devastator Marines to cover the points. Checking or deleting the Use column for the items makes that much, much easier to do than messing around with deleting rows, copying and pasting, etc. Once the whole list is set I’ll delete the rows for unused items, but while it’s in development this little trick makes it much easier to play around with and think about.

Note that to help this work better and make the list more appealing, I’ve also set zeros to not be displayed. In OpenOffice you can do this by selecting the cells, right clicking, and entering a ‘#’ (without quotes) in Format Cells…->Numbers->Format Code. In Excel you can do this over the whole spreadsheet by unchecking Tools->Options->View->Zero Values. You can also set it for groups of cells by selecting them and then selecting Format->Cells->Number->Category->Custom and entering “0;-0;;@” (without quotes) in the Type of that same dialog tab.

Of course, then I also have the sum total points for every unit and item in use in the list. This is just a simple sum over the Total column:

=SUM(G2:G65)

In this formula, column G is the Total column. Remember that the range entries will be adjusted appropriately as you insert or delete rows in the list.

Finally, as a sanity check to make sure I don’t break some basic rules—I’ve several times nearly included too many Elites!—my sheet also counts and displays the number of units I have of each type. You can do this with a formula like:

=COUNTIF(A2:A66;"HQ")

Where column A is Type. This sums up all the items that have “HQ” as their Type. I have similar entries for Troop, Transport, Elite, Attack, and Heavy, as shown in the screen above. This is just a nice quick check to make sure everything’s kosher.

And that about sums it up. You could do fancier things, like enforcing that Type be one of the four classes, or myriad other tasks, but this works pretty well for me. The only thing I would like that it doesn’t do, and which would be a little tricky to implement well, would be to sum up and present the total for each individual unit with its wargear. Obviously you could insert sums for each one to do so, but that’s a bit of a hassle. This feature isn’t critical, but it is something I’d be interested in figuring out if someone with more Excel/OpenOffice experience (I have very little) has an idea. All in all though this basic setup has worked well for me. Feel free to leave comments if there are any questions or suggestions.