Credit to the names in the spreadsheet below. I've only made some updates.

https://docs.google.com/spreadsheets/d/1ITH6oNHsIlVHo2LJnR92wP5LEKiON0k2rZJ82YbYaB0/

I will update the spreadsheet based on comments and add opinions if you have something to add.

https://www.reddit.com/r/eu4/comments/ulm1m9/ive_created_an_updated_army_spreadsheet_for_the/

1.33 Combat Update

Fire and Shock pips now affect morale damage as well.

From testing, we know an attack pip does casualties in addition to doing the same morale damage the morale pip would.

Backrow troops now take 40% of the regular morale damage.

The morale change also buffs defensive pips since it means you are losing less morale as well as taking less damage. (Damage is attack pips minus defense pips)

Practical Example

Old spreadsheet prefers small cast cannon over the large cast cannon for tech 13 because it has one more offensive morale pip.

That makes sense before 1.33, now, the large variant will inflict more casualties on top of acting same otherwise. Same for the first western infantry and a few others across tech groups.

Ideal Army Composition

Ideal General (Damage source)

No cavalry units for nations that start with tech level 1. If custom, refer to modifiers on the tech screen.

From tech 13 onwards it can be worthwhile to start building artillery while not being cost effective, from tech 16 onwards they take over as the damage source.

Infantry gets 1.1x to fire and 1.15x to shock here. If you have cavalry bonuses or you still have too few artillery, prefer shock.

A western nation with no bonuses to cavalry can drop cavalry from this point on.

Closest numbers to fill the combat width, split with the S key in game for equal stacks.

Only use cannons in your combat stack(s), for the rest just keep enough cannons for siege bonuses. See the link for siege roll bonuses by fort level.

https://eu4.paradoxwikis.com/Land_warfare#Dice_roll

Artillery units are shared across all tech groups.

* https://i.imgur.com/qYJniJk.jpg

* Reformed also viable

No alternatives for cavalry units.

* North as the defensive choice is viable.

* Tech 26 unit has one more fire pip while the tech 30 unit gets an offensive and defensive morale pip. In 1.33 this leaves only defensive morale as an upgrade which isn't worth losing doing more damage in the fire phase.

* Now that the offensive shock does morale damage as well, there's no reason to switch to spearmen at tech 4.

Custom nation group with no unit choices.