Results 1 to 20 of 20

Thread: Sorcerer dps calculator

  1. #1
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default Sorcerer dps calculator

    I love playing my Sorcerer and i wanted to know what would maximize my dps, so i built this DPS estimator to show dps when prioritizing your skills in different ways.
    Assumptions in the calculator:

    • Crit Dam % I have tested and it seems to just be around 125% for skills/weapons.
    • Curse is not supported in the calculator because i don't know how long the de-buff lasts, sorry
    • Global Cool down seems to be 0.5 seconds for all Sorcerer spells. After testing it appears there may be a couple spells that allow you to AA during the GCD. Since i tested with all 3 classes it seems that you should not be allowed to AA during GCD. so that is how the calculator works.
    • it does appear that you can AA then cast a spell with no delay. so I allowed a skill to be cast 1/10 of a sec after AA. I understand that you may not be perfect on
    • I did a 300 second calculator because the data tends to level off over a longer period. I know most fights don't go that long, but this is meant to show your average dps and to try to help you become more efficient. if you took a 60 second window you may see much larger swings in the data.


    What i wanted to use it for was to see whether

    • should I use crit items or +dam items
    • should i charge a skill like Time shift for Countdown of Pain or not
    • etc.


    So you can download the calculator and then adjust the data in the Orange cells as desired. You can adjust the priority of spells, but i can tell you that you cut your DPS in half almost by not making your weapon the 1st priority. Then it is fun to see a breakdown of what skills/weapon contribute to your overall DPS. The file also adds in the +damage from Pets if you select that pet. If you don't have a +Damage% pet then just select "Other" because all the stats will be rolled into the Damage/Crit% numbers that you type in

    The file is an Excel file in 2007-2011 (mac) format.
    google doc - calculator

    Name:  DPS Calc view.jpg
Views: 2438
Size:  126.4 KB
    Last edited by CosmoxKramer; 01-10-2013 at 09:21 PM.

  2. The Following 6 Users Say Thank You to CosmoxKramer For This Useful Post:


  3. #2
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    i forgot to column the Priority column in Orange as well, but you can plug in your skills and then play with the priority of spells and such.

  4. #3
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    Once PVP comes out I'll add in the ability to test curse. Plus ill try to add in arcane abilities for some of the popular Sorcerer pets, like Koko, Colten, ribbit, etc

  5. #4
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    Anyone know the duration of curse and can tell me if it is including increased duration or not?

  6. #5
    Junior Member Mohd Nabil Fikri's Avatar
    Join Date
    Dec 2012
    Posts
    42
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    3
    Thanked in
    3 Posts

    Default

    CosmoxKramer what is your ign?

  7. #6
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    Iwantbeer, see the Sig

    Mohd Nabil Kikri - what is your IGN? I don't accept random friend invites, so if you aren't in my guild or we weren't chatting in game then i click no on invites. So knowing your name will help if you ever wanted to catch me in game
    Last edited by CosmoxKramer; 01-23-2013 at 10:14 AM.

  8. #7
    Junior Member
    Join Date
    Feb 2013
    Posts
    11
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Hi I hope you can Help me About the Best Skills For mage In " PVE" I'd love to become a pure PVE Mage

  9. #8
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    I would definitely recommend
    4 offensive skills if you are going for max damage and are good at avoiding damage when needed and aren't afraid of using potions

    Frost Bolt 4/5 (upgrades 1,2,3)
    Time Shift 3/5 (upgrades 2,3)
    Lightning Bolt 2/5 (upgrades 1)
    Fireball 5/5
    1/5 Damage
    5/5 int passive
    all int for your stat points, and Colten

    Or drop Fireball Upgrade 4 (-25% hit) for 2% damage

    I hope this helps, i hope you enjoy it. Note, i think with the 4/5 frostbolt the DoT damage is very high and may be the #1 priority spell to cast over time shift (on a boss).

  10. #9
    Junior Member
    Join Date
    Feb 2013
    Posts
    11
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Thanks A lot thats really helpfull but how about the snare root in Timeshift

  11. #10
    Junior Member
    Join Date
    Feb 2013
    Posts
    11
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    And if i put a stun in lightning Can lightning stun jarl also?

  12. #11
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    I don't see it happen enough, plus both of those upgrades require you to charge the spell
    I never charge my spells on bosses for max DPS. For aoe packs charging is great for the Time Sift DoT, frostbolt aoe, and for fireball -25% hit and knockdown. Rooting doesn't seem too helpful in PVE because its mostly the archers/mages that hurt bad. -25% hit can help for Jarl, but it seems that even on elite his hits are as if he is still ll 16 so he misses and doesn't hit too hard now that our armor is lvl 20-21.

  13. #12
    Senior Member
    Join Date
    May 2011
    Posts
    1,204
    Thanks Thanks Given 
    16
    Thanks Thanks Received 
    100
    Thanked in
    69 Posts

    Default

    I can't seem to get this to work, if I try with Google Sheets it fails (complains about formula's). If I download it complains that it has links to something else (which I don't have apparently) and fails to work (errors all over the place)...

  14. #13
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    hmm, sorry to hear that. I've never downloaded it off google drive. I'll try to do that today and see if i get those errors and can fix.

    There shouldn't be any external links, only links to another tab within the same workbook. But i am fixing some formulas in it right now. I believe i have it right. So i will test downloading to another computer shortly.

  15. #14
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    hi Valsacar,
    I was able to successfully download and run on my other computer

    Here is what i did
    Follow this link to the google doc - https://docs.google.com/open?id=0B04...21oRFp4OVFoMzA
    I signed into my wife's google account (so that it was even a different account than the one i shared the file one)
    click File > Download to save the file to your computer
    If you are using Excel 2010+ then you will probably get the "Protected View" at the top. I checked the file and there are no external links and it is not a XLSB Macro workbook so no bugs/worms/etc. Just a crap load of calculations.

    Once you have Enabled Editing from the Protected View you should be able to change any value in the orange cells.

    As seen on Avatar page you use Damage and Crit%
    Damage Reduction%, Pet, Skill list, Priority, Charge (yes/no), CritDam%
    Also, in column S you can adjust your Skill Upgrades (yes/no) and passive damage%.

    if you don't see a pet in the list that has a damage% please let me know. If the pet you chose doesn't have a damage% then you can choose Other, because the passive bonuses will be added into the other orange stats above.

    I'm usually on the game randomly between 7-4pm CST, IGN - Iwantbeer, Ilovebeer, Lager, StArnolds

  16. #15
    Senior Member
    Join Date
    May 2011
    Posts
    1,204
    Thanks Thanks Given 
    16
    Thanks Thanks Received 
    100
    Thanked in
    69 Posts

    Default

    Works now with MS Office on download (still doesn't work with LibreOffice, but I have MS at work).

    Played with it a bit, would be nice if there was an option to NOT have the random and just calculate min/avg/max in a perfect world (always hits, crits come out at exactly the correct %, etc). Would make it easier to see how much a small change makes to the overall.

  17. #16
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    What I did is built a macro in my Personal.xlsb file that did basically the following:
    It would recalculate the page and copy/paste the total DPS (armor reduced) over to column v or x (green box) 100x and then I could take an average of those 100 calculations to get a normalized total DPS.

    Do you no how to create macros or if I pasted code into here, would you know what to do with it?

  18. #17
    Senior Member
    Join Date
    May 2011
    Posts
    1,204
    Thanks Thanks Given 
    16
    Thanks Thanks Received 
    100
    Thanked in
    69 Posts

    Default

    Quote Originally Posted by CosmoxKramer View Post
    What I did is built a macro in my Personal.xlsb file that did basically the following:
    It would recalculate the page and copy/paste the total DPS (armor reduced) over to column v or x (green box) 100x and then I could take an average of those 100 calculations to get a normalized total DPS.

    Do you no how to create macros or if I pasted code into here, would you know what to do with it?
    Definitely, I was a programmer before I moved into IT security. It'll probably need to be adjusted since I use Linux (and therefore libre office), but that wouldn't be an issue. Just easier to adjust someone else work (that does what you need) than create it yourself. Wish I had more time to play with ideas, but full time job and about to start my thesis on my masters... the choice is beer or AL many nights :P

  19. #18
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    haha i hear ya. I only get to play for maybe an hour a day, but i like to troll the forums or to work on the spreadsheet. My baby steals my ipad/phone if she sees me on it during the day, The only thing she won't steal is my work laptop so i play around with my spreadsheets. I have to get the macro my from other computer, i'll do it in a bit.

  20. #19
    Senior Member CosmoxKramer's Avatar
    Join Date
    Feb 2011
    Location
    Katy, TX
    Posts
    529
    Thanks Thanks Given 
    40
    Thanks Thanks Received 
    97
    Thanked in
    54 Posts

    Default

    Here is the simple macro i made to run through 100 recalculations
    Sub Test_Cases()
    '
    ' Test_Cases Macro
    '
    Dim RowCount As Integer
    '
    Range("v2:v101").ClearContents
    For RowCount = 1 To 100
    Calculate
    Range("F11").Select
    Selection.Copy
    Cells(RowCount + 1, 22).Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    Next RowCount
    Beep
    Range("a1").Select

    MsgBox "Testing Complete"
    End Sub


    The "Beep" and "msgbox" lines are just used so that i know know when it was done running (1-2 minutes). i was often multi-tasking while getting the numbers for the other DPS vs. Damage thread

  21. #20
    Member Arief Adhie M's Avatar
    Join Date
    Apr 2013
    Location
    Di depan komputer :p
    Posts
    148
    Thanks Thanks Given 
    18
    Thanks Thanks Received 
    44
    Thanked in
    18 Posts

    Default

    Thank's a lot. This is very helpfull
    Sometimes i got error in my excel. But already upgrade to 2010. And everything was fine now.

Similar Threads

  1. [Elite Sorcerer] / [Dungeon Sorcerer]
    By Sh4rKô in forum Sorcerer Class Discussion
    Replies: 6
    Last Post: 12-26-2012, 03:56 PM
  2. Calculator Play!!!
    By Zolum in forum Off-Topic Discussion
    Replies: 12
    Last Post: 04-01-2012, 12:35 AM
  3. Stat Calculator β4.1
    By DanielRH in forum PL General Discussion
    Replies: 10
    Last Post: 02-23-2012, 10:53 AM
  4. Dmg Calculator and Stat Calculator
    By nmyxspaceship in forum PL General Discussion
    Replies: 2
    Last Post: 07-19-2011, 01:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •