[ARCHIVE] 1.1.5 Madness/Balance Sorcerer DPS Compendium

[Spren]

(03-05-2012 04:42 PM)Kor Wrote:  That was probably supposed to be a Crit/Surge one. As far as I know, there are no modifications in the game with both Power and Crit on them.

Yeah my bad - I meant surge/crit.

[Welkin]

Is anyone aware of a google docs version for a stat weight calculator? I saw a link posted for an excel version but the cyclic formulas did not seem to work properly on my mac.

[frmorrison]

I tried uploading the excel calculator to Google Docs and it didn't like the cyclic formulas either. Have you tried Office for Mac? That version of Excel may work.

[Welkin]

Yes I am using Office for Mac. If anyone else was able to get this to work on a Mac or Google Docs please send me a PM.

Edit: I was finally able to get this to work on my Mac. I am not sure what all changed but I did not get an error when I opened it this morning. I also went in and changed the Maximim Iterations to 1,000 (Preferences > Calculation > Maximim iterations)

[TheDarkness]

(03-05-2012 04:42 PM)Kor Wrote:  As far as I know, there are no modifications in the game with both Power and Crit on them.

There's a craftable enhancement with both power and crit though.

[frmorrison]

(03-06-2012 05:06 AM)TheDarkness Wrote:  

(03-05-2012 04:42 PM)Kor Wrote:  As far as I know, there are no modifications in the game with both Power and Crit on them.

There's a craftable enhancement with both power and crit though.

Reflective Enhancements are made by Artificers. It has 27 crit/power with a bunch of shield rating. That does appear better than the crafted level 50 crit/surge and power/surge even with wasted budget on shield rating. It is not better than the level 56 power/surge enhancements though.

[TheDarkness]

While we're on the mod subject, are the big Willpower/little Power enhancements ever worth it over some of each ones?

[Kaedis]

(03-06-2012 02:27 PM)TheDarkness Wrote:  While we're on the mod subject, are the big Willpower/little Power enhancements ever worth it over some of each ones?

Well, in terms of Willpower/Power mods, we have:

Advanced Aptitude 25: 29 End, 38 WP, 37 Pow
Advanced Aptitude 25A: 37 End, 61 WP, 11 Pow
Advanced Aptitude 25B: 48 End, 37 WP, 29 Pow

Now, assuming an EP value for Power of 0.9 (Willpower defined as 1.0), which is relatively accurate over most gear levels, gives us the following weights:

Advanced Aptitude 25: 71.3
Advanced Aptitude 25A: 70.9
Advanced Aptitude 25B: 63.1

They are very close in value. However, the crossover point is fairly close. At a Power EP of 0.88462, the 25 and 25A mods are identical in value. I've yet to find a gearset in which Power drops under 0.9 EP (in fact, as your gear gets better, Power tends to grow slightly in EP, since Willpower has a slight DR to it), but it's conceivable that it could exist. For now, though, I'd say that the 25's are slightly superior. The only ones to really avoid are the B's.

[Kyress]

I think there is a mistake in your values for WP (sorry)
aktually Advanced Aptitude Mod 25 got 48WP, which gives us a weights of 81.3
and now the
Advanced Aptitude Mod 24: 27 End, 45 WP, 34 Pow = 75.6
is even better than the Advanced Aptitude Mod 25A

[Ra'ath]

Quote:I think there is a mistake in your values for WP (sorry)
aktually Advanced Aptitude Mod 25 got 48WP, which gives us a weights of 81.3
and now the
Advanced Aptitude Mod 24: 27 End, 45 WP, 34 Pow = 75.6
is even better than the Advanced Aptitude Mod 25A

I have also found this to be true, in terms of absolute DPS increases. However, it may be worth considering your guilds needs before throwing these in all of your gear, for example, my guild is currently struggling with Soa NM so we're trying to ensure everyone has plenty of endurance for those pesky lightning orbs. Because of this I went for the compromise of 25A rather than full on DPS or endurance.