This video is outdated and doesn’t include many new features, but it explains the general purpose and spirit behind this tool.
This Excel Spreadsheet is a culmination of years of work on theorycrafting PlanetSide 2 weapon mechanics. It uses Visual Basic macros to pull weapon stats from DBG API, to calculate damage and recoil statistics and draw graphs to visualize them.
This toolbox arms you with all necessary tools for comprehensive weapon analysis.
Current version: v5b
Attention! When you first open the toolbox, you will see a yellow bar with a security warning about macros. Click “Enable content” to allow the use of macros, or the Toolbox will not function.
The Excel file has 8 pages:
They contain cells of different color:
Soft orange cells. When you double click or right click a weapon on the Stats page of the spreadsheet, weapon’s stats will be copied into soft orange cells on other pages. These cells also accept manual input. You can edit them without fear of breaking anything.
Light grey cells contain calculations and references to other cells, do not edit grey cells, or you will break the tool’s functionality.
Pale yellow cells store values for configuration, and you may need to edit them in specific situations.
Light green filling indicates that this cell’s value has been selected, likely by double clicking.
Small red triangles in the corner of a cell indicate a tooltip. Put your mouse over the cell to display the tooltip.
Note: Toolbox’s calculations always assume worst case scenario: weapon damage is rounded down and target health is rounded up.
This huge table has stats of all known infantry weapons.
Normally you don’t work with this table itself, and only use it to export stats into other pages:
Double click or right click on any weapon to copy its stats into soft orange cells on other pages.
Double click on Item ID of the weapon to open a JSON query for that weapon for your default browser.
The Toolbox is not perfect, and may sometimes pull wrong stats, or fail to pull stats at all. There is no substitute for looking at a query with your own eyes.
Select a weapon and click “Export 1” button. A window with exported weapon’s stats and attachment list will show.
Pulling stats and adding new weapons
The Pull Stats button will initiate a download of weapon stats from DBG API, using JSON queries for each Item ID in the first column. When a new weapon is released, simply insert its Item ID and Name to the end of the list, and its stats will be downloaded as well.
If you know weapon’s exact name, you can find out its Item ID this way, or you can simply copy-paste it from Attachments Page.
Keep in mind that “Name” column is not downloaded, and you will have to fill it manually for any new weapon releases.
The “Date” field near the “pull stats” button stores the date when stats were last downloaded. Normally, you should re-download stats only after a patch that changed something.
This page serves to analyze weapon damage at different ranges and/or with different attachments. You can compare two weapons at the same time.
On “Stats” page, double click on a weapon to export its stats for the first weapon, and right click for the second weapon.
You can add attachments to weapons by clicking corresponding buttons. If the weapon doesn’t have a certain attachment, you will be informed with a pop up window, but you can’t see whether weapon has access to an attachment on this page without clicking the Check Box.
The calculations for Minimum and Maximum damage ranges are self-explanatory.
To calculate weapon’s damage stats at certain range, enter it into soft orange Range cell.
Both weapons are simulated against the same target. You can specify target’s parameters on the middle left.
Below the Health block, there are reference tables for Health, Nanoweave Armor and Kinetic Armor.
Double click on Health or Damage Multiplier value to automatically apply it.
Both weapons have Headshot Damage Multiplier listed. You can double click on its value to apply it to the Damage Multiplier.
Since both weapons fire at the same target, and damage multiplier is tied to the target, it may be inconvenient to compare headshot properties of two weapons with different headshot multipliers.
The most common way to analyze a weapon is to look at its performance against the default target with 1000 HP and against a Full Nanoweave target with 1250 Effective HP, so these are the default parameters, and statistics for standard Full Nano target are calculated automatically.
The “Calculate Thresholds” button will calculate BTK Thresholds for both weapons.
For example, the results on the picture above read as:
Gauss Rifle kills in 6 shots at 0m to 10m, and in 7 shots at 11m+.
“Draw Graph” button will also recalculate Thresholds and then draw a comparative graph.
This page serves to analyze weapons’ recoil properties.
On the “Stats” page, double click on the weapon’s name will import its stats to the left position, and the right click to the right position.
Click Calculate Stability to calculate Average and Maximum horizontal Deviations and to update Probability Distribution Graph.
The Visual Basic macro fires a virtual gun in bursts with listed “Burst Length” for the amount of times, listed in “Simulations” cell, and then averages out the results.
“Average Deviation” is the average distance of the crosshair from the burst’s starting crosshair position. The lower it is, the better is the weapon’s horizontal recoil.
“Graph Scale H” refers to the maximum Horizontal Recoil value, visible on the graph. The default value of 0.7 is fine for most cases, but depending on how good / bad the weapon’s horizontal recoil is, you may need to increase or decrease this value.
Vertical Recoil module is self explanatory, you’re mostly interested in Vertical Recoil per Second.
For the purposes of vertical recoil, it’s better to have high RoF and low vertical recoil per shot, to ensure nice and soft, consistent pull.
FSRM value is listed mostly for your reference, it doesn’t participate in any calculations.
The Average Deviations listed in Recoil Angle block show how much a weapon is affected by Recoil Angle Variance. They basically show you the size of the yellow area:
Cone of Fire Page
This page displays weapon’s Cone of Fire in different stances and shows how it is affected by various attachments.
For now, this page has limited functionality due to Angular Size research fiasco. At this moment, the CoF Page will calculate weapon’s CoF Size after a certain amount of shots, necessary to kill the specified target at different ranges.
However, without a way to calculate weapon’s accuracy at that range, it is more or less pointless.
The CoF Page will also calculate a more useful statistic: Cone of Fire Bloom per Point of Damage Done. This statistic with an extra long name ties weapon’s damage output to accuracy loss, which allows you to objectively determine which weapon requires more burst firing, even with perfect accuracy, and regardless of weapon’s RoF or DPS.
You can combine weapon’s starting CoFs and CoF Bloom PPD to make an educated guess which weapon will be more accurate at range, and which weapon will require more burst firing.
This page allows you to calculate weapon damage against vehicles, taking into account their Health and Armor statistics, as well as their Resistances to specific damage types.
It also lets you apply some of the additional defensive certifications to the vehicle. The damage is calculated for all different directions.
This is one of the more complicated pages, and it requires a connection to the Internet in order to function. A video demonstration with a couple of examples.
First, you have to select the weapon category, and then the weapon from the lists on the upper right. Weapon’s stats for its default firemode will be automatically imported from the API. You can change the weapon’s firemode in the respective listbox. This can be necessary for some of the weapons, like the GODSAW.
Each weapon has fields for Direct and Indirect Damage. You can specify the distance to the target for Direct Damage, and distance to the explosion for Indirect Damage in the orange Range boxes on the lower left.
Select the target unit from the list in the middle by double clicking on its name. Unit’s Health will be copy pasted from the listed, and unit’s Armor and Resistance to the selected weapon will be imported from the API.
Each side of the vehicle has five values associated with it:
- Armor reduces all incoming damage from this direction by a certain percent. In game, only vehicle’s orientation relative to the damage source is important. It doesn’t matter where you are actually hitting the vehicle.
- Direct Damage is dealt on direct hits.
- Indirect Damage is dealt on direct and indirect hits, though most of armored vehicles are immune to most Indirect Damage sources.
- The amount of hits required to destroy the vehicle with specified Direct OR Indirect Damage is also listed. Keep in mind that these damage sources are not added together. So if the unit takes damage from both Direct and Indirect Damage, you will have to calculate the required amount of hits manually.
When you import the target unit by double clicking on its name, the list on the upper right will update with some of the vehicle’s defensive certifications. Double click on the certification name to add its bonus armor to the vehicle.
Keep in mind that when a certain certification, like Composite or Blockade Armor, adds bonus armor to several directions at once, you have to manually click on every list entry.
For example, to add Side Armor to the Lightning, first double click on the Lightning in the Unit List, then double click on the “Buff – Left” to add Side Armor to the left side. Similarly, double click on the “Buff – Right” to add Side Armor to the right side.
When a defensive certification has several ranks, you only have to click on the rank you wish to add. E.g. when you wish to make calculations for Composite Armor 4, you don’t have to double click on Composite Armor 1-2-3 before that.
Weapon-Target Resistance values will update from the API whenever you change the weapon or the target unit.
You can also manually edit all values in orange boxes to analyze theoretical scenarios. Do not edit the grey boxes, or you will break the tool’s functionality.
- Sometimes an error pops up when reaching out to the API. Just try again whatever you were doing.
- Toolbox assumes infantry has 0% Resistance to everything by default, which could be false.
- Resist Shield is broken.
- No support for additional ammo types, such as Typhoon Rocklets or Explosive Bolts.
- The tool does not fully support charge up weapons, such as Lancer. You have to manually multiply the damage.
- It will not calculate weapon’s TTK.
- It will not take into account rocket launcher indirect damage scaling.
- Weapons’ faction isn’t always determined correctly.
- Grenades and other explosives don’t work.
Some of these issues may never be resolved, as the necessary information is simply missing from the API.
This page stores a table with known effects of known attachments on all weapons. When you add attachments to weapons on other pages, this is where their effects are taken from.
To update the table, click “Pull Attachments“. A VBA Script will pull Names and Item IDs for all weapons from weapon categories on Categories Page, and then pull attachment data for them.
You can also double click on weapon’s name to open a JSON query for that weapon’s attachment list. This may be necessary if a weapon has access to atypical attachment, since the table is formatted only for known effects of known attachments.
This page has two functions. On the left, there is a list of weapon categories. The “Attachments” page will use this list to pull attachments for all weapons in these categories.
You can click “Pull Categories” to download a full list of Item Categories from the API, but then you will have to manually clean it up, and remove everything except infantry weapons, so the Attachments Page doesn’t get overloaded.
On the right, there is a similar list of weapon categories. For each weapon category there is a list of weapons in that category. This list is used by the “Resistances” page. To update this list, click “Pull Categories”, clean up the downloaded list, then copy paste it to the right and click “Pull Weapons”. Save, close and reopen the Toolbox so that changes take effect on the Resistances Page.
This is a temporary page for storing calculations results. You don’t need to interact with this page at all.
Changelog and To-Do
v1 – initial release.
v2 – added CoF import functionality and reworked Cone of Fire page. Special thanks to FISU. Weapon names also update when you add attachments.
v2a – added the ability to double click on weapon’s Item ID to open JSON queries.
v2b – Pull Stats will also pull Falling CoF (for flying / jumping with Carbines). Falling CoF will also be imported into Cone of Fire page. Also fixed a bug that any value of 1 character long was not pulled from the API.
v3 – The toolbox will now also pull ADS movespeed multiplier and other missing stats. Fixed several issues, minor improvements.
v3a – Fixed a Reload Time export.
v3b – Added the button to pull information about weapon’s projectiles.
v4a – Added functionality to download exact effects of weapon attachments and apply them to weapons.
v4c – Cleaned up unnecessary code in order for the Toolbox to work with 64 bit version of Excel. Also fixed a minor bug with HVA on Damage page.
v4d – Downloaded weapon and attachment stats for latest patch, including NSX Tanto.
v4c – Cleaned up unnecessary code in order for the Toolbox to work with 64 bit version of Excel. Again.
v4f – Stripped most of the functionality of the CoF Page, because it was based on the wrong Angular Size research. Added “CoF Bloom Per Point of Damage Done” instead. Also updated weapon stats for the latest patch.
v5 – Added a second weapon to the Recoil Page. Added brand new “Resistances” page to calculate weapon damage to vehicles.
v5a – Resistance Page will now correctly display and apply Composite Armor to air units.
v5b – added infantry and MAX defensive certifications.
Determine if BASR time between shots = chamber time. Done.
Overall weapon rating based on multigon square calculations.
CoF / RoF probability distribution to determine weapon consistency (done in alpha)
Reword the horizontal recoil probability distribution graph to be more accurate