ABCDEFGHIJ
1
2
3
The Division 2 - Builder
4
5
Version 2.0.4
6
This version is out of date. Updates are posted on the Reddit link below.
7
Questions/Feedback message Tandcrumpets#3293 on Discord or u/tand86 on Reddit.
8
Updates will be posted on the Reddit page here.
9
10
11
Data Based on Ahmad#0001's Gear Attribute Sheet.

12
Link to Master Data
13
DISCLAIMER: The data used by this tool is based off datamined values and may not be fully accurate.
14
15
Download Instructions:
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.

Known Discrepancies:
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.

Credits:
Dixyth#0642: testing, writing the headshot DPS formulas, theme design

User Tips:

If no value is available for a field, the field will grey out and the pulldown will be blank. To update, you must select and delete these values. Any values left in greyed out fields will still 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.
16
Rev. History
17
1.03/25/2019Baseline
18
1.13/26/2019Added talent validation funcionality. Bug fixes.
19
1.23/27/2019Added weapon talent stat calculations. Added Weapons. Added headshot modifiers.
20
1.33/28/2019Fixed skill power % calculations. Added Talent sidearm damage. added set bonus on builder page. Added weapon damage/DPS/reload time/mag size/rpm
21
1.43/29/2019Added crit adj. DPS.
22
1.53/29/2019Added dynamic weapon talents, dynamic gear talents, and dynamic attribute types.
23
1.63/31/2019Fixed reload speed error, added weapon damage baseline calculators.
24
2.04/3/2019Major 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.
25
2.0.14/8/2019Added Dark Zone. Added type icons. Updated data for 4/5/2019 WT5 content release. Added most master data links. Added version checker.
26
2.0.24/8/2019Minor bug fixes.
27
2.0.34/10/2019Updated for Ongoing Directive 3rd attributes. Corrected Headshot DPS formulas. Minor bug fixes. Added Strained/Beserk Armor% Threshold. Added Unstoppable Force uptime.
28
2.0.44/10/2019Bug Fixes.