|The Division 2 - Builder|
|This version is out of date. Updates are posted on the Reddit link below.|
|Questions/Feedback message Tandcrumpets#3293 on Discord or u/tand86 on Reddit.|
|Updates will be posted on the Reddit page here.|
|Data Based on Ahmad#0001's Gear Attribute Sheet.|
|Link to Master Data|
|DISCLAIMER: The data used by this tool is based off datamined values and may not be fully accurate.|
1. Log into your Google account.
2. In the Google Sheets toolbar: File > Make a Copy
3. If you do not see the Google Sheets toolbar try the alternate link on the reddit page.
4. This tool must be used in Google Sheets. It will not convert to .xlsx for use in excel due to syntax differences.
Total Armor, Health, and DPS calculations will vary due to rounding.
Accuracy is currently bugged in game and will match Stability.
"Sidearm Damage" is currently bugged in game and only affecting Pistol Damage.
Dixyth#0642: testing, writing the headshot DPS formulas, theme design
If no value is available for a field, the field will grey out and the pulldown will be blank. To update, you can select and delete these values. Any values left in greyed out fields will NOT factor into your stat sheet on the right.
DO NOT enter values with % signs. i.e. "1.5%" in game should be written as "1.5" in the builder.
Baselining Weapon DPS: In game, damage displayed on your weapon already reflects any weapon damage modifier stats. In order to correct for this and allow you to swap pieces, after entering your current build, enter the in game weapon damage in the field above the blue box. The blue box will then calculate the baseline value for that specific weapon. Enter this blue value into the box to the right of the weapon name. Once the baseline value is entered, any changes to gear or stats will be accurately reflected. If using the Beserk talent, set the threshold to 100% when baselining.
Recal Check Boxes: Recalibration check boxes unlock the full list of possible talents that can be swapped onto a piece of gear.
Beserk/Strained Threshold is the player's average armor % during combat.
I find the easiest way to compare 2 weapons you are deciding between is to put them both into the same build tab as the secondary you plan to run rarely effects your primary.
You can create more build tabs by right clicking on Build 1 > Duplicate. Be cautious this will not carry permissions so you can accidentally delete things that shouldnt be deleted.
|1.1||3/26/2019||Added talent validation funcionality. Bug fixes.|
|1.2||3/27/2019||Added weapon talent stat calculations. Added Weapons. Added headshot modifiers.|
|1.3||3/28/2019||Fixed skill power % calculations. Added Talent sidearm damage. added set bonus on builder page. Added weapon damage/DPS/reload time/mag size/rpm|
|1.4||3/29/2019||Added crit adj. DPS.|
|1.5||3/29/2019||Added dynamic weapon talents, dynamic gear talents, and dynamic attribute types.|
|1.6||3/31/2019||Fixed reload speed error, added weapon damage baseline calculators.|
|2.0||4/3/2019||Major overhaul to back-end. Added dynamic gear mods. Added dynamic conditional formatting. Added second build tab. Added recal check boxes to unlock un-rollable talents. Added more damage types. Added Crit and HS adjusted DPS calculations.|
|2.0.1||4/8/2019||Added Dark Zone. Added type icons. Updated data for 4/5/2019 WT5 content release. Added most master data links. Added version checker.|
|2.0.2||4/8/2019||Minor bug fixes.|
|2.0.3||4/10/2019||Updated for Ongoing Directive 3rd attributes. Corrected Headshot DPS formulas. Minor bug fixes. Added Strained/Beserk Armor% Threshold. Added Unstoppable Force uptime.|
|2.0.5||4/19/2019||Bug Fixes. Added Gear Mod Type above the icons. Inactive fields with values no longer contribute to stats. Back-end Enhancements.|