1. #1
    Deleted

    Is there a list of HPS numbers for disc per spell?

    I'd like to see a simple list of the type:

    PW:S: xxxx Healing per cast or HPS
    CoW: xxxx HPS

    etc.

    I guess it will have to be based on current character stats.

    But I don't see anything online for 6.0.3.

  2. #2
    Use the spell in the game
    Extrapolate the numbers
    ???
    win

    Or use the spreadsheet in the disc stat priority thread.

  3. #3
    Deleted
    Quote Originally Posted by Aparthia View Post
    use the spreadsheet in the disc stat priority thread.

    What would that do? It doesn't do spells individually.


    Wait, what spreadsheet file?

  4. #4
    Quote Originally Posted by fateswarm View Post
    Wait, what spreadsheet file?
    These: https://docs.google.com/spreadsheets...gid=1207425635?

    Third post in that thread.
    Last edited by Noradin; 2014-12-01 at 02:04 PM.

  5. #5
    Twistedmind's spreadsheet is an excellent one; its presentation, breakdown of various spell components and its ability to account for various buffs make it very informative.

    It's a little out of date, but I think it only needs a handful of changes to the "Disc Spells" sheet to bring it back up to speed,

    1. Change Grace to 30% (i.e. cell H3 to 1.3).
    2. Change to Holy Nova coefficient (cell H9) to 56.25%.
    3. Change the defensive Penance coefficient (cell H18) to 264%.
    4. Change the Power Word: Shield coefficient (cell H19) to 600%.
    5. DA produced by Saving Grace is no longer reduced by the debuff of the cast that triggered it, so the 0.9 factors need to be removed from cells J24 and M24.
    6. Flash Heal and Heal have an additional 10% modifier when cast outside Spirit Shell, so cells I7 and I8 need to be modified to include this. This is done by modifying the second expression in the IF function. For example, cell I8 should read (modification bolded for emphasis):

    =if(L$3="Off",((H8*'Character Stats'!D$7)*D$3*G$3*H$3*I$3*J3*K3*1.1),((H8*'Character Stats'!D$7*J3)*I$3*D$3*H$3*(1+('Character Stats'!B13/100*E3))*(1+('Character Stats'!B17/100*0.6))*G$3))

    With these changes, there are still minor (~1%) differences between this spreadsheet and my own. I'll investigate what the cause is later today.
    Last edited by Myllior; 2014-12-01 at 10:20 PM.

  6. #6
    Deleted
    So basically CoW is WORSE than pw:s if you have no time to spam one. Interetesting.

    Also flash heal is identical to heal but tons higher on HPS, the latter is expected.

    It seems intuition is enough for most of them.

Posting Permissions

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