Spreadsheet with weapon damage vs terrain armour

[bladum]

Folks,

I made a simple spreadsheet with damage vs terrain matrix. It shows which weapon will break which terrain with percentage value of success. Data i input are not vanilla ones and are partly from my mod and partly random one. But anyway i just wanted to share idea of this tool as it could help to design mods better as all data is shown on single screen. For example human made wooden structures have 20 armour, stone ones 30 and metal ones 40.

https://docs.google.com/spreadsheets/d/1t3XNLoZd2gavBZfX8GOx4Ez3vFPaPYVDWlUNJwTHO8o/edit?usp=sharing

[jackstraw2323]

Thanks was just thinking I needed something like this for my mod!

[Meridian]

At the very end of this video: https://www.youtube.com/watch?v=x2-VQPeYF6I ... there is an explosion inside an xcom craft (the explosive has damage of 250).

According to the spreadsheet above already damage 240 (Elerium bomb) should penetrate it... but that didn't happen... does anyone know why?

[bladum]

because this is data from my mod, i just shown the general idea

[Meridian]

Oh, I see, should have read it more carefully before jumping to the spreadsheet ;-) Now I look like an idiot...