DPS Excel calculator for Sorcerer / Sage

[lostdummy]

This is excel DPS calculator that was made based on info available on this and other sites.
It can be used both by Empire side Sorcerers and Republic side Sages.

(Ver 1.51 - 21.03.2012)

  swtor_sorc_151.xlsx (Size: 167.14 KB / Downloads: 1516)

There is explanation inside excel on how to use it, but here is some short summary of what it was intended for:

- calculate DPS of sorcerer on boss fight, for any selected build (madness, lightning, hybrid, custom)
- compare DPS of different builds, and find which skill talents are best for different builds
- compare DPS between different gear sets (Current vs BiS for example)
- find relative values of stats ( to answer "what is better, 5 will or 10 crit" ) - for each build
- quick item value comparison calculator , using above stat values
- find value of different skills/talents on DPS (for each build)
- automatically select spells to use in rotation for selected build (based on skill availability and DPCT) - but can be finetuned by user
- also can calculate stat value for sorcerer companion tank (to maximize survivability, not DPS- useful to see if defense is better than endurance etc )
- can select Empire/Republic names for talents, spells, companions

All above DPS and all other calculation can be based on actual player stats (that can be entered on excel, usually in 'Current' gear set), and player defined builds (existing presets in exel can be changed, or just change 'Custom' preset).


Tested to work on Excel 2007 and later. Circular references are used in excel, and they are enabled in document by default at: Options -> Formulas -> Calculation Options -> Enable iterative calculations