I don’t see how these files are in categories relative to the specific coalition.
Nato needs to be with nato
Britian needs to be with British
Warsaw pact with their own kind… etc
And can you put this file on either Microsoft office or Microsoft word? Excel is not aesthetically readable or enjoyable for anything but numbers and accounting junk.
Also, is this based loosely on the east/west setup? Its important because the map has many of its territories with the same foundation as that map so the setup is transfered correctly will already be perfect. This is what it was designed to do.
A great starting point would be to keep the same total counts of pieces and allocate the setup just like in that game. The anomalies of the new territories are just a few additional hot spots that need few pieces added.