ES Calculation Help

I am trying to build a spreadsheet for personal use to calculate how much additional ES I would get from upgrades. However I cannot get the formula to line up between my calculations and what is displayed in game.

In Game ES (no Discipline) - 566
In Game ES (with Discipline) - 1089

Int from Character Pane - 334
Additional ES from Discipline Tooltip - 260

Passive Tree:

http://www.pathofexile.com/passive-skill-tree/AAAAAgMAAecEBwdjDkgRUBGWEuEZLhoyGlUdFB6BHwIn7Si1KMUtHzbFNug74UCgRwZLjUw1TLNPfVFgVw1XK1nzXhNhIWSjZp5tGXB9cLtyqXzZfll_xoBWhO-PRo_6nrmezZ_LoLSio6LqpwinK6cwpzSplayqrK-71sAawcXB88Lsw4bSIdgk2WHb5-L35oHnkewY707zvve--tL7qv8c


Gear:



By my calculations I have the following numbers

Base Local ES from gear - 257
Pct Increased ES from Int - 66.8%
Pct Increased ES from Skills - 34%
Pct Increased ES from Jewelery - 0%
Pct More ES from Skills - 0%

So using the following equation my calculated ES is not matching in-game values for both with aura and without.

Without Aura:
Gear ES * (1 + Pct ES Int + Pct Es Skill + Pct ES Jewelery) * (1 + Pct More ES)
257 * (1 + .668 + .34 + 0) * (1 + 0) = 516.056

With Aura:
(Gear ES + Aura ES) * (1 + Pct ES Int + Pct Es Skill + Pct ES Jewelery) * (1 + Pct More ES)
(257 + 260) * (1 + .668 + .34 + 0) * (1 + 0) = 1038.136

Please explain what I am missing to make the calculation come out to the proper numbers. I'm sure it is going to be something super simple that I missed but would appreciate the assistance.

Do the two +20% Increased Defenses from Shield nodes you have affect the ES on the shield?

"

mark1030 wrote:

Do the two +20% Increased Defenses from Shield nodes you have affect the ES on the shield?

I did not think they did because there is a node that explicitly states "30% increased Energy Shield from equipped Shield".

"

Vipermagi wrote:

Shield Defenses applies to ES, Armour and Evasion Rating from your Shield.

Wow, cannot believe I missed that. You are completely correct. As soon as I factored in the additional 95% shield defense my numbers came out exactly correct.

Thanks for the help!

For anyone that searches and finds this thread, here is the corrected equation.

Without Aura:
(Gear [excluding shield] ES * (1 + Pct ES Int + Pct Es Skill + Pct ES Jewelery) * (1 + Pct More ES))
+ (Shield ES * (1 + Pct ES Int + Pct Es Skill + Pct ES Jewelery + Shield Defense + Pct Extra Shield ES) * (1 + Pct More ES))

(205 * (1 + .67 + .34 + 0) * (1 + 0))
+ (52 * (1 + .67 + .34 + 0 + .95 + 0) * (1 + 0))
= 565.97

With Aura:
(Gear [excluding shield] ES * (1 + Pct ES Int + Pct Es Skill + Pct ES Jewelery) * (1 + Pct More ES))
+ (Shield ES * (1 + Pct ES Int + Pct Es Skill + Pct ES Jewelery + Shield Defense + Pct Extra Shield ES) * (1 + Pct More ES))
+ ((Aura * (1 + Aura Effect)) * (1 + Pct ES Int + Pct Es Skill + Pct ES Jewelery) * (1 + Pct More ES))

(205 * (1 + .67 + .34 + 0) * (1 + 0))
+ (52 * (1 + .67 + .34 + 0 + .95 + 0) * (1 + 0))
+ ((260 * (1 + 0)) * (1 + .67 + .34 + 0) * (1 + 0))
= 1088.57