ADLG: Help Wanted Beta Testers V4 List Writer

Update Fri 14 May, 2021
Thanks to everyone's help the beta testing phase ended today with the release of v4.01.00.  Details & links can be found on the new ADLG tools page.  All links to the beta version have been removed from what follows.

Original post
Do you have a Google account and know how to use Google Sheets?  Do you play Art de la Guerre (ADLG) and would you like to help me test an online list writing sheet?  If the answers to both questions is yes read on. ^{1, 2}

Since March, when the first version was released, I have improved a few things and trapped even more errors.  The most important thing is the new writer uses all the new initiative rules, points values and army lists from ADLG V4.  This is why it needs testing.

In use the writer is basically the same as that for V3 in that you can create a list whilst viewing all the basic information before printing out a fully formatted list on paper or as a pdf.  

You need a Google Drive, and access to Google Sheets, because there will never be a downloadable version.  The writer uses a couple of powerful spreadsheet functions that are unique to Google Sheets and aren't in the likes of Excel.

Still interested?  Then use this link to create a copy of (final) beta version V4.00.06 on your own Google Drive and start writing your very first list for ADLG V4.

What help am I looking for?

• Missing troop types & wrong points values.   Version 4 introduced many new options & combinations; especially for medium foot.  I think I've captured them all but I can't be sure.  If you find one leave a comment here.  A page reference to an example in a list would be really helpful.
• Contentious list splits.  To make the database work many lists have had to be split in to two or more sub-lists.  You may disagree with the way I've split lists or simply spot an error.  As before, please leave a comment outlining anything you find odd or wrong.

• Test the search function.  To find a particular list just enter the list number in cell A2 on the "List Search" worksheet.  Try 258 to see it in action.  Also please test the other filtering options.
• Spreadsheet protection. Once copied to your Google Drive, all the sheet & cell protection I've put in place will not work.  I would like to know if this is a problem.  If you end up deleting an important cell by accident just make another copy and try again.
• Other spreadsheet errors.  If you get anything unusual please leave a comment.  A link to a screenshot of the problem would be ideal.

Finally a word about updates. Having created a copy you will need to repeat the process to get the latest beta version.  I will correct errors & omissions quickly.  I plan to update the beta version for a few weeks before releasing the first public version.  I will routinely post update announcements on both twitter and in the comments section below.

Follow up points:

1. I have received some feedback from the beta testers along the lines of why write another sheet when there's now a simpler, and downloadable, version for Excel on the ADLG web site?  The answer is two fold.  Firstly, this sheet does far more automated testing and uses a list database that contains a full list of allies & dates.   Secondly, in 2021 the Excel version for V3 had outstanding errors dating from 2018.   I wanted to ensure I wasn't reliant on others.   ↩

2. One tester found the layout intimidating at first so I'd be interested in other's views.   ↩