Armor Calculator (Google Sheets) – It will calculate penetration chance, drop durability of armor and then calculate penenetration chance again until armor is zeroed

Hi guys, I wanted to share with you all Armor Calcualtor I made in Google Sheets: https://docs.google.com/spreadsheets/d/1Nd_-auN4sEG3WViGXYevnMhOwjdSum5Yf_MwfCE1nxc/

It will calculate penetration chance based on bullet and armor used. It works as a simple simulation: it will calcule penetration chance for the 1st shot based on your initial data input, then it will substract durability lost when hit by the bullet and it will calculate penetration chance again for new durability etc.

https://preview.redd.it/u5an2hrlww661.jpg?width=1920&format=pjpg&auto=webp&s=6841541778c5dcbdd4656686640abb7cdfa5d24d

To make it very easy to use I spent a lot of time to make sure you can pick all the armors and bullets from drop-down lists. First you have to pick armor class level, then armors will be filtered to that class only. After picking armor all other fields will be auto-filtered to show you the stats that match your selection (you still have to pick them from drop-down list, but it will show you only one value). Then you just input current durability. Same stuff for bullets. You pick caliber then ammo and all the stats will auto-filter for you.

https://preview.redd.it/xgb2svepww661.jpg?width=1920&format=pjpg&auto=webp&s=2eb6af6c9a4c76e1e610880964588f2d89f7a3cb

IMPORTANT:

Sadly if you want to use it you have to make a copy using Google account. Sorry, but there is no other way. You have to go to File –> Make a copy and save it for your personal use.

https://preview.redd.it/exw1078rww661.jpg?width=1920&format=pjpg&auto=webp&s=ceb91f465636ce24b3a090f9e92bda10128b8c30

I also included detailed simulation that will calculate penetration chance for each point of durability lost on armor.

https://preview.redd.it/ypz1yq9xww661.jpg?width=1920&format=pjpg&auto=webp&s=e30fc87ae774ec4d3041c6ae25d349db42cc3fc2

I hope you guys will find this tool helpful. Have fun with the simulations!

Gamer

Share
Published by
Gamer

Recent Posts

Ledx have been so hard for me this wipe

Not being able to craft them sucks. Especially when everyone I talk to about it…

1 year ago

My interesting and unfortunate Gwent life

First I'd like to say I absolutely love this game it's quality. Basically I first…

1 year ago

Teacher Tuesday 12/Dec/2023 – ask your questions here!

Welcome to Teacher Tuesday, a thread where anyone can ask any type of question without…

1 year ago

This games balance is confusing

I’m kind of new/returning to gwent I played beta and obviously it’s a lot lot…

1 year ago

Summary of 10 Days of Draws from Chaffee’s Bundles

Level 1 Bag (Free with Atmosphere Level 2) 6 small consumable (First Aid, Repair, Fire…

1 year ago

Why is my crew at 135%?

Here's my crew - T34-85M - for the life of me I cant figure out…

1 year ago