Random Armies For The War Of Spanish Succession

In the comments on a previous post I was asked if I was looking at doing a simple campaign for the Great Northern War using 'Dominion of Marlborough and Peter The Great'. I have been considering it and have a couple of ideas I'm working on, but this morning I came up with an idea for doing a very simple mapless campaign for the War of Spanish Succession. This is all the more remarkable because I know next to nothing about the War of Spanish Succession. However I've never let my lack of knowledge of an era stop me pottering about with wargames-related stuff for it. It's how we learn.

Anyway, I am working through the mechanics of the campaign itself, and if it seems workable I will post it here. But what the campaign also needs is a way of generating armies for battles similar to the system I used for my English Civil War campaign.

I have looked at the armies in the various scenarios in 'Dominion of Marlborough and Peter The Great' and come up with the following, which I think reflects those armies plus what little I do know about the conflict.

The two sides are Bourbons (France and Allies) and the Grand Alliance (Austrian, British, Dutch etc). Precisely which nations or combination of nations are fighting is  irrelevant. That's up to the players to decide.

Roll for how many units, upgrades and downgrades the army has. Determine which army is the attacker in the battle.

1 - 6 units
2 - 6 units, 1 upgrade, 1 unreliable
3 - 6 units, 2 upgrades, 2 unreliable
4 - 5 units, 2 upgrades
5 - 5 units, 3 upgrades, 1 unreliable
6 - 4 units, 4 upgrades

Roll for the type of each unit.

1-2 - Line Infantry
3 - Horse (Dice for which type below)
4-5 - Line Infantry or Horse (Balance existing numbers if possible, or dice for it if even)
6 - Dragoons/Artillery (Dice for which below)

Only count the first two rolls of 6. Treat any other rolls of 6 a roll of 5

Roll for each Horse unit:

0-3 - Sabres
4+ - Pistoliers
+2 if Bourbon, -1 if Alliance

Roll for each Dragoons/Artillery result:

0-4 - Artillery
5+ - Dragoons
-1 if Alliance

Roll for each Upgrade the army has:

0-3 - Elite
4-6 - Disciplined/Defences
-1 if Attacker +1 if Defender

Randomly assign the upgrades to units. Artillery cannot be Elite. 

Finally allocate the Unreliable statuses to units. The first Unreliable must be assigned to either an Artillery or Dragoons unit if the army has one. Otherwise it, and any others are assigned to random units.

The defender sets up first, followed by the attacker.

Notes
Bourbon forces seem to generally have Pistoliers as their main cavalry type. Their +2 on the Horse table will ensure this. Drop it to a +1 if you feel it's too much. Alliance armies seem to have fewer troops classed as Dragoons, however, so I've made it less likely they will be present. Artillery and Dragoons are often Unreliable in the scenarios. In terms of upgrades, I have assumed that attacking armies are more likely to have troops with a strong offensive spirit, whereas the defending army is more likely to have field defences or a terrain advantage. Elite and Defended/Discipline can represent a range of things, however, and it's up to the players to decide what. In the same way, Unreliable troops can simply be those on flank marches or late-arriving reinforcements.

In terms of individual theatres of the war - Spain, the Low Countries, Germany or Italy - feel free to tweak modifiers to better reflect armies there if you have a better understanding of the era than I do. I won't know unless you tell me.