+ Reply to Thread
Page 1 of 6 1 2 3 4 5 ... LastLast
Results 1 to 15 of 82
Like Tree4Likes

Thread: The Comprehensive Warrior Spreadsheet

  1. #1
    RIFT Guide Writer Darkranger's Avatar
    Join Date
    Aug 2013
    Posts
    211

    Default The Comprehensive Warrior Spreadsheet

    I've transferred the Warrior Spreadsheet into the New Google Doc format, which provides more headroom and overall faster performance and responsiveness. Quite noticeable improvement from the older format.

    http://tinyurl.com/TheWarriorSpreadsheet

    Also improved energy and server lag calculations.

    As usual, comments / bug reports / new items either post here, PM me or contact me in game Darkranger@Gelidra.
    The seeing, the true seeing, that is the heart of sword-play.

  2. #2
    Ascendant Sedvick's Avatar
    Join Date
    Feb 2011
    Posts
    3,378

    Default

    When trying to update the gear on the spreadsheet, getting a lot of "The data you entered in cell XXX violates the data validation rules set on this cell. Mainly happening on cells C8-12 (Chest/Hands/Belt/Legs/Feet).

  3. #3
    RIFT Guide Writer Darkranger's Avatar
    Join Date
    Aug 2013
    Posts
    211

    Default

    Fixed thanks.
    The seeing, the true seeing, that is the heart of sword-play.

  4. #4
    Ascendant Sedvick's Avatar
    Join Date
    Feb 2011
    Posts
    3,378

    Default

    One more thing. On the weapons tab, the Mythical Kraken's Spine only shows proc as 300 AP when it should be 500. Or is that just the calculated dps of the proc? Regardless, the proc on the Mythical Sylvan Greatblade is way too high and over-inflates the calculation on the dps calc to over 70k. I'd move the default down to ~350-400 dps.

  5. #5
    RIFT Guide Writer Darkranger's Avatar
    Join Date
    Aug 2013
    Posts
    211

    Default

    300 AP comes from 60% calculated uptime (approx). Mythical Sylvan Greatblade's proc fixed.
    The seeing, the true seeing, that is the heart of sword-play.

  6. #6
    Ascendant Sedvick's Avatar
    Join Date
    Feb 2011
    Posts
    3,378

    Default

    Quote Originally Posted by Darkranger View Post
    300 AP comes from 60% calculated uptime (approx). Mythical Sylvan Greatblade's proc fixed.
    Alright cool. Just wanted to point out that I've gone over various logs from our raids (all of t3 so far) where we have a few Kraken's Spines and the uptime is more in the range of 70% average. With a 1s gcd (people who played Para) the uptime was averaging out at 78-80%, while with a 1.5s gcd (Tempest/Warpest) I am seeing 68-75% uptime.

  7. #7
    RIFT Guide Writer Darkranger's Avatar
    Join Date
    Aug 2013
    Posts
    211

    Default

    Changed the uptime of Kraken Spine's proc to 70%.
    The seeing, the true seeing, that is the heart of sword-play.

  8. #8
    Plane Touched the unknonw's Avatar
    Join Date
    Jun 2011
    Posts
    289

    Default

    I love the new features, especially the actual duration in the calculations tab
    Last edited by the unknonw; 07-13-2014 at 01:13 AM.
    Scurch

  9. #9
    Plane Touched the unknonw's Avatar
    Join Date
    Jun 2011
    Posts
    289

    Default

    Just noticed you were missing a few Laethys items. 1 2 3. There are some more items rogue items you could include but I assume you left those out on purpose.
    Last edited by the unknonw; 07-13-2014 at 01:46 AM.
    Scurch

  10. #10
    RIFT Guide Writer Darkranger's Avatar
    Join Date
    Aug 2013
    Posts
    211

    Default

    Quote Originally Posted by the unknonw View Post
    Just noticed you were missing a few Laethys items. 1 2 3. There are some more items rogue items you could include but I assume you left those out on purpose.
    Added. I assume the 500ap bow proc shares a buff slot with the 500ap from the 2handers. Adjusted sheet gear configuration to use The Mythical Avarice bow and The Mythical Sylvan Greatblade 2hander. Also added proc calculation for the Sylvan Greatblade which behaves more like an ability than a conventional proc, it scales with AP and certain damage debuff and buffs. The only problem is it seems to do so in a weird way. For example it doesn't benefit from Enhanced Conductivity, but benefits from Mired.
    The seeing, the true seeing, that is the heart of sword-play.

  11. #11
    Rift Master
    Join Date
    Apr 2011
    Posts
    614

    Default

    I'm unable to change it from 2h to DW, doing so results in almost everything in the evaulation section just showing #NAME? and something about unknown range name "DPSWEAPON1"

  12. #12
    Ascendant Sedvick's Avatar
    Join Date
    Feb 2011
    Posts
    3,378

    Default

    Mythical Avarice 500AP proc will not stack with other 500AP procs and will eventually be converted to rogue-only, or so I've heard. Verdant is still the better stat-stick.
    Last edited by Sedvick; 07-13-2014 at 10:28 AM.

  13. #13
    RIFT Guide Writer Darkranger's Avatar
    Join Date
    Aug 2013
    Posts
    211

    Default

    Quote Originally Posted by Sedvick View Post
    Mythical Avarice 500AP proc will not stack with other 500AP procs and will eventually be converted to rogue-only, or so I've heard. Verdant is still the better stat-stick.
    That makes me both sad and happy. Those 500AP procs are nuts..

    Fixed 1handers selection.
    The seeing, the true seeing, that is the heart of sword-play.

  14. #14
    Prophet of Telara Seranov's Avatar
    Join Date
    Jun 2013
    Posts
    1,045

    Default

    Quote Originally Posted by Darkranger View Post
    That makes me both sad and happy. Those 500AP procs are nuts..

    Fixed 1handers selection.
    I'm still getting spammed with #NAME when I set it to my weapons (Eternal Despoiler's Blade + Dreamslaughter).
    Seranii@Greybriar - 60 Eth Warrior
    | SL: 11/12 T2, 5/8 T3 | NT: X/X T1 |
    < Dirty Casual until 3.0 >
    "One day you'll hang your head as you realize,
    You've heard it all but didn't listen to a word."

  15. #15
    RIFT Guide Writer Darkranger's Avatar
    Join Date
    Aug 2013
    Posts
    211

    Default

    Can't replicate, be sure you've created a new copy from the public one.
    The seeing, the true seeing, that is the heart of sword-play.

+ Reply to Thread
Page 1 of 6 1 2 3 4 5 ... LastLast

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