Yes but spreadsheets can't observe why while having good stat the IS2 is barely used. So maybe its because other unit's stats, maybe because of the meta, or build order, or cost etc...
I take again the Sherman example, it has on paper good AT stat, but once you compare it with armor it faces they suddenly don't look like so powerful.
Let's think about the parallel between Tiger and IS2. On paper they have the same AI DPS according to MMX, but both tanks don't have the same speed, could it be possible that the Tiger being able to close the distance faster and disengage faster is used more aggressively and thus regularly at medium range while the IS2 being slower is more likely to shot at max range making the difference people are seeing. Or that a good part of IS2 AI dps comes from the dushka which is modified by the constant late game yellow cover all around the map.
My point was only there, Stats are indeed a good 1st point to take in account but you can't stop by it and say everything is fine or broken because stats are ok or not.
This is not contradicting anything that calculatuons can tell you.
If other units can fill the gap/role of the IS2, then the calculations might actually tell you why. The calculations will also give you a pretty decent picture of the Sherman's performance against other vehicles. If there is e.. a Brummbar meta, stats will tell you what units perform worse or better at countering it.
And if MMX's calculations about the Tigers's and IS-2's AI say they are pretty close, but you in game think they are, it'll at least tell you that it is because of other factors like moving too much etc. He doesn't overstate the explanatory power of his sim, he clearly explained them for what they are: artificial, standardized setups with very defined parameters that come close to the in game situation. No one claimed they will tell you every aspect of the AI of these units. And I fully agree, theydon't give you the full picture of a unit. But single posts of a hand full of usera do not either. And doing the calculations also prohibit anyone from critical reasoning and adding other information. But they give comparable numbers that - if done well - reasonably represent what you should see in game if you try to replicate the setup.