Is anyone here mad about AOS numbers?

Discussion in 'Vehicle Names and Census Numbers' started by Chris C, Nov 17, 2023.

  1. Chris C

    Chris C Canadian

    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)

    Wg Cdr Luddite likes this.
  2. I'm in !

    Chris C likes this.
  3. KevinT

    KevinT Senior Member

    I'm in too.


    Chris C likes this.
  4. idler

    idler GeneralList

    'Mad about', or 'mad because of'?

    Time will tell...
  5. Chris C

    Chris C Canadian

    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?
  6. Chris C

    Chris C Canadian

    What would be the best way to send you each the file? I can use DropBox or WeTransfer.
  7. Chris C

    Chris C Canadian

    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.

  8. Wg Cdr Luddite

    Wg Cdr Luddite Well-Known Member

    Amazing stuff, looking forwards to the results.
    Will they be on squire Bev's site ?
    Chris C likes this.
  9. Chris C

    Chris C Canadian

    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. :)

Share This Page