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

Hi guys, I wanted to share with you all Armor Calcualator 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/45i5gvu7gj761.jpg?width=1920&format=pjpg&auto=webp&s=9812661eb51f70ea3164813b20eecc7f0b05d2a6

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/gs31ijx8gj761.jpg?width=1920&format=pjpg&auto=webp&s=57b3c2a336e6440f017ca9b5a48250e7d7d1354d

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

https://preview.redd.it/8a3wc9gagj761.jpg?width=1920&format=pjpg&auto=webp&s=e4978ad11da79e30c0b8792648f39fc5134a5dfb

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/z8cm244bgj761.jpg?width=1920&format=pjpg&auto=webp&s=4d46e88554a33790da2fd0c9cb6487226cbbf2c6

Have fun testing some stuff!

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…

5 months ago

My interesting and unfortunate Gwent life

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

5 months 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…

5 months ago

This games balance is confusing

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

5 months 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…

5 months ago

Why is my crew at 135%?

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

5 months ago