This thread is a follow up to the one I started previously about Eldar and Blast weapons (
https://www.reddit.com/r/WarhammerCompetitive/comments/htb9qp/eldar_vs_blasts/ ).
Long story short so you don't need to read the old thread: some things were pointed out about the math which have been corrected (as was my oversight on Wyverns re-rolling wounds), and I've expanded the target units to include
MSU Ork Boyz and Grots as well as both units maxed out to cover some more horde profiles so people can get a look at how this impacts units who don't live with a T3 profile.
The shooting profiles have also been expanded, plasma cannon devastators are now a whole unit to illustrate D3 weapons being employed in a more realistic manner against units of all sizes, and I've also added in 6 new shooting units: Tactical Marines with bolters, Primaris with Bolt Rifles, Guardsman. The Marines come in both
MSU and 10 Astartes sized units, and the Guard will be shooting normally, and while buffed with
FRFSRF (the points cost for the buffing officer being added in for the bottom chart). This is to highlight the efficeincy of regular units shooting hordes vs blasts to give a better picture of where blasts fall into the mix.
I do want to say that all math was done using an 8th edition calculator (
http://40k.ghostlords.com/dice/ ) as no 9th edition ones currently exist, and I'll be honest I'm not going to spend weeks trying to make one in excel to get an idea about this topic, so all average attack numbers with
D6 weapons were done manually for 6-10 man units (as well as the Basalisk due to it's "roll
2D6 and take the highest" rule for attacks), and the Dire Avengers saves are all done on the basis of the worst save to smooth things out when dealing with the mixed profile nature of the unit.
Finally the updated data:
https://docs.google.com/spreadsheets/d/1uSQOcXYIyX7xh1Bzpf2zQRZSrvpOaI2rpcG2JN6hH1o/edit?usp=sharing
So, after crunching, and re-crunching all the numbers, what do I think?
Well a couple of things: First there was only one instance of a single blast weapon wiping out half a squad on average, and it was against an
MSU squad of Dire Avengers. To be fair, it was a Wyvern which averages 12 shots, so that's probably not too much of a shock.
Second, multiple blast weapons being fired at a target (such as the Devastators) was -far- more effective than any single blast weapon (or at least the ones I've seen touted more as the ones to be concerned about), and units like Marines and Guard were far more effective at dealing out wounds just by getting into rapid fire range than blast weapons against most targets. I could probably test out a no-rapid fire option for the units as well, but even if they're not as good we still have unbuffed squads doing more damage by getting close, something to be concerned about with smaller tables since that becomes far easier for them to do.
In actual game play I'd likely combine options (for example, a Whirlwind and an Intercessor squad at half range) to inflict the most casualties. Blasts to soften hordes (or even mid-sized units) first, followed by regular small arms to finish the job. This is because blasts are more effective against undamaged units, while the small arms don't care as much and can finish the job more efficiently.
As for list building, I'd have to say in most cases large units actually benefit you more. You become more resistant to any single shooting attack, and your buffs become more effective (especially important if your army doesn't rely on auras for your buffs, like Craftworlds who get most of their buffs via psychic powers and stratagems). The downside of course is debuffs are more efficient, and you give up slightly more casualties to any single blast weapon, or a whole lot more against units with multiple D3 blast weapons as they can keep getting the max number of attacks for a lot longer.
Long and short of it is that no individual blast weapon is going to break a horde, just give up slightly more casualties on average, and if your army leans into hordes get some games in with them before you decide to shelf the horde and go
MSU, or even mid-sized units.