ABCDEFGHIJKLMNOPQRSTU
1
2
General Information
3
4
PLEASE CREATE A COPY OF THIS SPREADSHEET
5
Otherwise you can't edit anything useful!
6
7
With this spreadsheet, you can calculate your character's DPS for a large variety of different skill, build and equipment combinations.
You can set up more than one skill but DPS can only be calculated for one of those skills at any given time. Switching out gear or passive nodes to test different build combinations is also not directly supported, i.e. you need to clear the respective values and put in new ones.

DPS calculations are very accurate in general but also see the Known Issues section below.

The sheets use some values that are not directly related to DPS like mana regeneration, maximum mana, the Clarity aura etc. Those are values for calculating the uptime of skills. It didn't completely make it into this version though. So those values are not used right now.
8
9
Sheet OverviewLegend
10
Edit Me! This is a cell you can and should edit
11
Calculated value. Do not edit unless you really know what you're doing!
12
StatsResult value. Same as above but usually some important result
13
On this sheet you can see and edit some basic information about your character. Note that this sheet will likely see some changes or completely go away in the future since it doesn't contain a lot of useful information right now.

When you've entered all required information, the strength, dexterity and intelligence values listed here should be the same as in your character panel though!
14
15
Passives
16
This is where you enter your bonuses from the passive tree. All values are integers, i.e. you don't enter any fractions here. So for 74% increased damage, you enter 74.

Not all possible passive bonuses are included here yet and it's likely that not all will be. So far I've concentrated on the most important DPS nodes
17
18
Items
19
Enter your equipment bonuses here. The columns are just for convenience, you can actually put all values into one column but it might be easier to switch out gear when you enter them where they belong.

DO NOT enter bonuses that are local to a weapon here (accuracy, crit chance, crit multiplier, elemental damage etc.). Those are usually already reflected in the weapon base stats. Only global modifiers should be entered here.

There are some modifiers missing yet, e.g. conversion modifiers. They will probably come at a later stage
20
21
Skill Setup
22
This is where you set up your skills. Choose a skill gem together with level and quality and up to five support gems.

For skill gems, support gems and auras, if you don't enter a level of at least 1, the slot will be ignored in DPS calculation.

The sheet DOES NOT check for invalid skill combinations! You have to make sure you use valid skill gems.
23
24
DPS
25
This is the heart of this spreadsheet. Here you can actually see the resulting DPS values.

For attack skills, enter your weapon stats in the top area. Use the final base stats of the weapon, i.e. with included local modifiers. As a rule of thumb, those are the values above the first dividing line in the weapon's tooltip. When no physical damage is entered for a weapon, it is not used.

You need to enter your chance to hit from your character tab! Unfortunately, we don't know exact evasion ratings for enemies, so we can't calculate the chance to hit reliably from the accuracy rating. Therefore, the accuracy rating can be ignored for DPS calculations.

For spells, you don't need to enter any weapon stats.

Finally, choose one of your configured skills and you'll see the resulting DPS for your current chance to hit, that chance + 1, 95% and 100% with Resolute Technique. Also, below you see the skill stats as should be displayed in your character panel.
26
27
CalcDPS, DamageSources, Classes
28
Those are internal sheets used to calculate the DPS. You won't need to edit anything here but you can have a look if you are interested in the inner workings of the game.

Note that this spreadsheet also makes extensive use of scripting. So if you wonder where some values come from because they have no formula attached, they are likely written out by a script.
29
30
Skill Data
31
Base data for all the skill gems supported in this spreadsheet. That data was taken from the Path of Exile Wiki. Unfortunately, that Wiki is out of date. So if you know some missing or corrected values, please feel free to enter them here! This is the only sheet that is actually writable in the shared version, so please make use of this!
32
33
Known Issues
34
35
The final damage values at the bottom of the DPS sheet are sometimes off by one. I guess the game does some additional rounding somewhere which I haven't figured out yet. This will obviously lead to a deviating DPS value, but in practice that difference should be very small.
36
Even when the damage values are correct, the DPS can sometimes be off by 0.1. This also applies to Attack Speed, Crit Chance etc. I hope someone knows where I have the rounding error!
37
I don't account for things like Ground Slam Dual Wield yet. The game shows wrong values, so this sheet does the same. There's no point in trying to correct the game when you can't actually test this
38
I haven't figured out the correct attack speed for Double Strike yet, so Double Strike will always show wrong DPS values!
39
Skills with base attack speed overrides like Sweep or Leap Slam might also show incorrect values. I have to look at those again
40
There are a couple of skills missing as of now:
All Traps
Arc
Maybe some more I have forgotten now
41
For most gems, there is no data on quality included yet. Right now only Power Siphon and LMP have quality values attached to them. More will come later
42
Firestorm, Cold Snap have wrong data on the SkillData sheet. A lot of other gems probably too. I need your help to fix them!
43
44
Things (maybe) to come
45
46
NOTE: None of those are guaranteed to be included in the future but they are just some ideas I came up with
47
Uptime calculation for skills, i.e. how long can you sustain a given skill until your mana pool is depleted. (This is almost done and will be added soon)
Maybe in conjunction with Blood Magic as well
48
Life Regeneration display
49
DPS calculation with projectile counts, i.e. how much DPS will you likely have when a given percentage of all your projectiles hit
50
DPS calculation for elemental hit taking those probabilities into account
51
Some planning features, e.g. showing the required attributes for selected gems etc.
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100