Hi all, My friend and researcher Brad photographed a document for me which turned out to contain what appears to be a complete list of the AOS numbers and backgrounds used in First Canadian Army plus some in 21st Army Group. I would like to put this information into a spreadsheet and make it available the way that KevinT has made spreadsheets of tank names. I'd rather not do all of this data entry myself. Would anyone be interested in working on this with me? (We could use a Google Doc, I think) Cheers, Chris
SquireBev Who doesn't frequent the forums much, but is on BlueSky, has also offered to help. So that's good, it wouldn't just be one of us slaving away in the dark. I figure next steps are to send you each a copy of the file and to set up a spreadsheet. SquireBev also has a book by Bellis(?) which may cover the same ground or overlapping. I'd like to set up the spreadsheet so that selecting the background colours/arm of service is a dropdown, as well as the bar (if any). I guess we can put all the formations in the same page, unless you think it would make sense to have separate pages for 21 Army Group, 1st Canadian Army, corps?
I had a go at setting up columns and entered a few numbers. I'm sure it's not clear at first glance, but picking Background will fill in Arm of Service, and picking Parent Unit will fill in White Bar, and you'll get a warning if you try to fill in one of those columns manually. Hopefully there aren't any errors in the setup I made, but of course it should be expandable if need be. You can see here: Arm of Service Markings (NWE) Also here is what the first page has, for instance.
I'd say he should be free to do that, and we should also make a spreadsheet or PDF available in the Resources section here too.
