There is a tremendous amount of complaining about weapon balance/imbalance and I felt that was coming from 2 main problems:
1. The players don't have the tools at hand to see how each weapon is working. Without this understanding it becomes possible for situations to feel unfair.
2. When balance changes are made, they are made without tools that allow the developers to see how a weapon is effected as a whole, and how it compares to the rest of the weapons of its archetype. This leads to "feels" fixes in which changes are made that 'feel' like they should fix the problem. While a lot of these fixes are GOOD, this allows for accidental over nerfs.
I asked if there was any dev tool available that would allow the devs to see how each weapon functions. I was surprised when I found out no tool existed; so I decided to make one (for SG for now, I'll do other weapon types eventually).
This is that tool:
https://docs.google.com/spreadsheets/d/1D54LLX7h5jVEDEzmaunEvchCH0CIbTmtNDCDo0rLSMU/edit?usp=sharingI realize that the sheet can be daunting and a bit cumbersome, so I have uploaded a video explaining how to use it here:
https://www.youtube.com/watch?v=B5PmUtg9np4&feature=youtu.beCirn was courteous enough to give me the files that the game runs off to get weapon information. Lidae, Cirn, and John Porno were nice enough to provide me the exact formulas the game uses. These formulas are used in the spreadsheet. The results *SHOULD* represent the exact numbers you will see in game. I say should because there is always rounding errors that will result in very minor discrepancies.
I have validated the information on the sheet (with great effort) and have found it to be accurate. That being said, I began this project a month ago and a few weapons have changed. I would be more than happy for anyone to notify me of any inaccuracies.
Why?
I felt that it would provide a useful tool for quickly determining weapon effectiveness and allow for easy balance and design decisions.
Why should you care?
This provides you with a tremendous amount of meta knowledge if you take the time to use it. You can see in ANY scenario, which weapon will be the objective best. As well, if you make a weapon legendary, you can use this sheet to see which upgrade will result in the greatest damage increases.
Why am I sharing this?
While creating the spreadsheet I realized that it was making me privy to a tremendous amount of meta game knowledge that most players simply didn't have available. I've played other FOnlines where being an English speaker was a genuine detriment (TLA) where the devs and players went out of their way to keep game information unavailable to English speaking players. In the name of competitive spirit, I have made this information available to everyone.
*note*
- The sheet by default is using AP equivalent ammo. I'd found that the AP equivalent ammo yields more damage and more bleed in nearly EVERY situation across almost all armors.
- The damage represented is averaged for every weapon
- 250 skill is assumed. All weapon perks are represented
- I have deliberately locked the sheet. You should be able to download it yourself. If you want to unlock it the password is BenisBenisBenis
**Disclaimer**
This sheet is intended to supplement your understanding of the game. It is
NOT meant to be used as a means to argue a weapon needs buffing/nerfing. You can use the sheet to try and understand why a weapon needs work, but the arguments you make should be supported with IN GAME data and not the sheet alone.