Variant Analysis: A request

Hello everybody. I've spent the past... oh gods... I've spent 15~ hours across the past five days building an excel sheet to automate the entire process of comparing stats between units once you've filled in the basic numbers. You know. Like in my analyses, but it takes 10 minutes of data entry and interpretation instead of 5 hours of calculations!

But I find myself at an impasse. Because I have a question I just don't know the answer to! Not for sure, anyway.

The question is: What is the order of operations for resistances?

I have seen claims that it is entirely additive (Physical+Missile+Ward, for example) as well as claims that Ward Save's effect gets calculated first and THEN the remaining applicable resistances are additive (Ward first, then Physical+Missile, for example).

So, does anyone have proof? Does anyone have a source, a CA employee quote, a table from the game files, *anything*, that they can point to and say, "this is how it works"?

Also, follow-up question:

Does Collision Damage get affected by resistances?

Yes. The sheet accounts for Collision Damage. Heck, it accounts for 4 different kinds of Collision Damage, depending on the state of the charged unit!

I intend to make the sheet publicly available to everyone once I'm sure it's all working, and I've had time to test it thoroughly.