Author Topic: Sexpert Shooting Range  (Read 6911 times)

BG Sexpert

  • Wastelander
  • **
  • Offline Offline
  • Posts: 191
    • View Profile
Sexpert Shooting Range
« on: April 19, 2016, 08:47:23 PM »

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=sharing
I 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.be
Cirn 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.
« Last Edit: April 20, 2016, 01:46:18 PM by BG Sexpert »
Logged

Smalltime

  • Global Moderator
  • Experienced Survivor
  • *********
  • Offline Offline
  • Posts: 457
    • View Profile
Re: Sexpert Shooting Range
« Reply #1 on: April 19, 2016, 11:50:27 PM »

A heroic amount of effort. I hope someone finds this useful.
Logged

S.T.A.L.K.E.R

  • Guest
Re: Sexpert Shooting Range
« Reply #2 on: April 19, 2016, 11:59:46 PM »

A heroic amount of effort. I hope someone finds this useful.

A player named Le Troll also makes spreadsheets like this but for Reloaded, so he'll probably jizz himself when he sees this :P

Good work BTW
Logged

Kurwier

  • Guest
Re: Sexpert Shooting Range
« Reply #3 on: April 20, 2016, 01:19:28 AM »

u still forgot the special factor named human
Logged

Teela

  • Wiki Editor
  • Experienced Survivor
  • ***
  • Offline Offline
  • Posts: 321
    • View Profile
Re: Sexpert Shooting Range
« Reply #4 on: April 20, 2016, 04:17:32 AM »

This is awesome. Someone is going to lose a lot of business over this though:

Logged
RazorRamon:
i literally have 卐TÜRKENJÄGER1488卐 tattooed on my back

Stem Sunders

  • Guest
Re: Sexpert Shooting Range
« Reply #5 on: April 20, 2016, 05:35:34 AM »

For people like me, this is great!

Thanks for the effort.
Logged

PusiteGA

  • Phoenix Contributor
  • Outdoorsman Veteran
  • ****
  • Offline Offline
  • Posts: 501
    • View Profile
Re: Sexpert Shooting Range
« Reply #6 on: April 20, 2016, 06:57:01 AM »

all make spears nonexist traitors xD

BG Sexpert

  • Wastelander
  • **
  • Offline Offline
  • Posts: 191
    • View Profile
Re: Sexpert Shooting Range
« Reply #7 on: April 20, 2016, 10:10:18 AM »

This is awesome. Someone is going to lose a lot of business over this though:



HtG is pretty good for most weapons. However, you'll find some magical things happen when weapons spread is reduced to around 3.  ;)
Logged

Lidae

  • No Name Yet Team
  • Outdoorsman Veteran
  • *********
  • Offline Offline
  • Posts: 644
  • Wasteland scientist
    • View Profile
Re: Sexpert Shooting Range
« Reply #8 on: April 20, 2016, 12:33:51 PM »

I see you really put a lot of effort into this. Good job! Looks like it would be a great complement for balancing certain weapons.
Logged

BG Sexpert

  • Wastelander
  • **
  • Offline Offline
  • Posts: 191
    • View Profile
Re: Sexpert Shooting Range
« Reply #9 on: April 22, 2016, 02:19:40 PM »

I see you really put a lot of effort into this. Good job! Looks like it would be a great complement for balancing certain weapons.

Thanks. I can't wait to see the tier system when its all set and ready. With that it should be easy to adjust each weapon to have it fit its intended roll.
Logged

Spore Plants

  • Wanderer
  • *
  • Offline Offline
  • Posts: 40
    • View Profile
Re: Sexpert Shooting Range
« Reply #10 on: April 24, 2016, 11:00:23 AM »

Good job Lackey.
Logged
It's the army, we got power in numbers
And that's .9s, .45s, .357s, and M500s
 



SMF 2.0.2 | SMF © 2011, Simple Machines
Simple Audio Video Embedder - Theme by Crip