ADLG: V4 Army List Writer - Major Update

Introduction
In March 2021 I delved into the delights of Google Sheets and created a spreadsheet based list writer for Art de la Guerre (ADLG) V3.   In the following May I released a version for ADLG V4.

In the intervening years I have used the writer extensively.  I've also fixed the odd bug and updated the released version.  However, behind the scenes I've been tweaking a few things, adding more features, and writing app scripts (Google speak for macros) to automate various processes.

It's now time to release an updated and much streamlined version

15 mm Later Thracians (Essex Miniatures)

With this post my 2024 Hellenistic project reaches an important milestone.  The units pictured are the last I must paint before the KITN competition in October.  Their completion means that anything I paint after this is a bonus.

Once again they are venerable Essex sculpts (MPA3 Thracian: Peltast with Rhomphaia & shield).  Well up to their usual standard with few, if any, defects and a more detailed figure review isn't necessary.  However, one rhomphaia was miscast but a call to Essex sorted that out very quickly.

DBA 3.0 Army Design Tool - Update

Late last year I released the first version of this tool.  It was a nice data project that I thought would fill a rainy afternoon and be of benefit to others.   Earlier this month Chris Laudermilk left a comment that lead to a significantly improved v1.0.

Via email, Chris contributed a couple of neat formulae.  One parsed the options text removing the need for users to enter the number of elements.   The other selected the troop type where there was only one option; once again reducing user input.  Very efficient.

What's new and what's changed?
Unfortunately, there's a drawback with the second formula.  When a user selects an army and enters an option it overwrites the formula.  Repeated use would remove more of the formulae eventually removing them altogether.

28 mm Commanders (Essex Miniatures)

When I placed my last order with Essex I decided to buy a few extra figures to add some variety to the long slog of painting a 15 mm Hellenistic army.  I ended up with commanders for three of my Art de la Guerre (ADLG) collections: Hellenistic, Arab Empire, & Ilkhanid Mongol.

The figure is based on a magnetised 40 mm plywood base which is the same size as my 15 mm ADLG command bases. My plan is to use them as CinCs during competitions. Afterwards they will be retired and placed in my display cabinet.

Revisiting The ADLG Mega Table: Redux

In April last year I posted a second article about the Art de la Guerre (ADLG) Mega Table (or the table on page 22 as it's otherwise known).  In it I described my reverse engineering of the combat factors in an attempt to hammer them into my head.

This afternoon I was musing on how complex the first round of combat is compared to the subsequent rounds.  Whilst using my reworked table of combat factors to check a few things I spotted something amiss.