+ Reply to Thread
Page 1 of 24 1 2 3 4 5 11 ... LastLast
Results 1 to 15 of 358
Like Tree29Likes

Thread: Warrior BIS List

  1. #1
    RIFT Guide Writer
    Join Date
    Feb 2013
    Posts
    388

    Default Warrior BIS List

    Hey Warriors,

    Finally we can share the newest version of the spreadsheet:

    Spreadsheet - Warrior 3.0


    Special thanks to:
    - Jotunn (he invested a lot of time)
    - Ordien
    - ttlyevil


    As always
    - nobody is perfect so if you find an error please let us know and the error will be corrected!
    - if you got or saw loot that is not yet in the list let us know!


    Last but not least I would like to thank all players that have contributed to the list over the years and I already thank all others that will contribute to the list.


    Cheers,
    RePyH
    Last edited by RePyH; 02-14-2016 at 10:11 PM.

  2. #2
    Rift Master
    Join Date
    Dec 2013
    Posts
    657

    Default

    Have been messing around with CP today. By the looks of it you don't have to change much to get it adapted to the new values, well at least for the 40% softcap. I don't know how it scales afterwards so sadly can't help you there.

    From the testing i could do on live the 40% softcap should be at approx 3130 (+/- 1). The 40% mark is what i found on the forums that its how it works now.

    Note: for now i guess this is just temporary adjustments, although if the gain past 40% is really as low as i've read here, its pointless to o past. The changes listed below should simply swap the old 50% cap with the 40% and adjust the calculations for it.

    To change the spreadsheet you only have to modify a few values:
    ||>DPS tab:
    - change M50 to 3130 (the soft cap),
    - change the equation in L18 to
    =1.5+IF(N18<$M$50,N18*0.0001278,0.4)
    - chnage the equation in N18 and M18 to
    =1.5+IF(N18<$M$50,N18*0.0001278,0.4)+'DPS Buff'!G44
    Calculations tab:
    - change the equation of G100 to
    =1.5 + MIN('||> DPS'!N18*0.0001278,0.5+'Calc Base'!AK4*0.000357)
    If i didn't foget about anything, this should be about it. Again, it is not a complete change because it will max out CP at the 40% bonus softcap and discard all CP you might have over that number.

    Also Crit chance has to adjusted as well.

    Thank you for keeping updating the spreadsheet.

  3. #3
    Rift Master
    Join Date
    Dec 2013
    Posts
    657

    Default

    Was too late to edit my post. Changing Crit Chance is even simpler. If the cap is still 60%, then that translates to 17550 Physical Crit.

    Changes are only needed in the ||>DPS tab:

    - change M49 to 17550
    - change the equation of L10 to
    =L9*0.000034188
    - change the equation of M10 to
    =M9*0.000034188+'DPS Buff'!F44
    - change the equation of N10 to
    =(N9*0.000034188)+$V$63+'DPS Buff'!F44
    This should be all.

  4. #4
    RIFT Guide Writer
    Join Date
    Feb 2013
    Posts
    388

    Default

    Thanks for your input much appriciated!

    - CP & Crit calc changed (i just was a bit more into the detail - so cp is 3133 :P )
    - consumables are added

    next step:
    - adding the seal

    If you find something else post it here or shoot me a pm. :P
    Last edited by RePyH; 11-29-2014 at 06:40 AM.

  5. #5
    Rift Master
    Join Date
    Dec 2013
    Posts
    657

    Default

    You really made me curious with this now so went and gathered more data. the best i can get to is 3131 (+/- 1), am runing out of combinations for equiped items. Which is not far from what i got before, not that it actually matters .

  6. #6
    Ascendant Bloodbourne's Avatar
    Join Date
    Jun 2010
    Location
    Michigan
    Posts
    2,263

    Default

    Quote Originally Posted by Jotunn View Post
    You really made me curious with this now so went and gathered more data. the best i can get to is 3131 (+/- 1), am runing out of combinations for equiped items. Which is not far from what i got before, not that it actually matters .
    I came to to 3020 (accounting for feast and banner) CP as 40% soft cap. Anything above that will be dipping into the vast unknown of "why would you do this"? Basically, get 3k CP, stack AP.

    I'm at 3k, so I've been mixing in some AP as well.
    Last edited by Bloodbourne; 11-29-2014 at 12:53 PM.
    Misterwar <-Virus-> 5/11 Warborne <Yakisoba> 5/11 Warborne <Apotheosys> 0/11

  7. #7
    Rift Master
    Join Date
    Dec 2013
    Posts
    657

    Default

    @Bloodbourne: sounds good, yeah. The difference is because of the rounding on the char screen, the same reason for the small discrepancies in the end number . Didn't know its already rechable that fast. Any idea perhaps how it goes/scales past that?

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

    Default

    I can confirm the CP soft cap to be 3120 (not 3130), so 3015 without raid buffs or feast. Once you reach the soft cap you want to start going after something else as the hard cap of 50% lies @7020 CP, which is a completely unreachable and worthless goal to strive for.

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

    Default

    One quick fix as well. The Scorched Gauntlets have 161 CP, not 150.

  10. #10
    RIFT Guide Writer
    Join Date
    Feb 2013
    Posts
    388

    Default

    Quote Originally Posted by Sedvick View Post
    I can confirm the CP soft cap to be 3120 (not 3130), so 3015 without raid buffs or feast. Once you reach the soft cap you want to start going after something else as the hard cap of 50% lies @7020 CP, which is a completely unreachable and worthless goal to strive for.
    Maybe I'm mistaken, but why would be the soft cap at 3,120?
    Per point of CP you get 0.012764405543399 % and if the cap is at 40% it equals out 3,133ish and not 3,120 .

    Quote Originally Posted by Sedvick View Post
    One quick fix as well. The Scorched Gauntlets have 161 CP, not 150.
    The list only had the basic version of the gauntlets in but i added the upgrade.


    EDIT:
    Seal is added to the equipment - due to the fact that the seal has 29 upgrades with the same name I changed a bit the way of selcting the correct version. As long as the name of the seal remains to be "Rage of the Feral" (till 190 Str) you choose the name as usual and right next to it the str you get from yours. If you have the basc version with 152 str pls choose 0 at D25.

    after you have upgarded it one more time the name is "Furor of the Untamed" which can be selected and the 205 str are going to shown without selecting the str bonus from the item.

    hope thats not too confusing. :P
    Last edited by RePyH; 11-30-2014 at 12:24 AM.

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

    Default

    Quote Originally Posted by RePyH View Post
    Maybe I'm mistaken, but why would be the soft cap at 3,120?
    Per point of CP you get 0.012764405543399 % and if the cap is at 40% it equals out 3,133ish and not 3,120.
    Did the math earlier today. Once I can log back on tomorrow I'll break it down again to confirm my earlier findings. For now, gotta sleep.

  12. #12
    RIFT Guide Writer
    Join Date
    Feb 2013
    Posts
    388

    Default

    Quote Originally Posted by Sedvick View Post
    Did the math earlier today. Once I can log back on tomorrow I'll break it down again to confirm my earlier findings. For now, gotta sleep.
    gn8 Sedvick

  13. #13
    Rift Master
    Join Date
    Dec 2013
    Posts
    657

    Default

    I've noticed that i have missed some of the CP changes in the spreadsheet. Under the Calculations tab there are two fields: G100 and J100 that have to be adjusted.

    G100
    =1.5 + MIN('||> DPS'!N18* X ,0.4+'Calc Base'!AK4* X )
    J100
    =MIN(G100+(N104* X ),1.9+'Calc Base'!AK4* X )+H100+I100
    ... where X is the koeficient

    I rather put X in above examples so you can add any number you want. Though copy pasting in a number with 10+ decimal places is pointless so might be worth proprely rounding it up (the later half of the decimal numbers don't do anything and are incorrect as well as your estimate is just that, an estimate). Also the cap of 3133 curretly on the spreadsheet does not coincide with the koeficient value you have put in the formulas, the differences are insignificant though.

    This change shouldn't do anything below the CP cap implemented, but can perhaps have an affect past it as the spreadsheet is still calculating the weigths and changing the 'Calc Base'!AK4 number ( which seems to be the CP value when clacluating, 0 or +1, if i'm reading this right).

  14. #14
    RIFT Guide Writer
    Join Date
    Feb 2013
    Posts
    388

    Default

    I would need someone that can confirm that my math and thought is correct: )

    I'm working on implementing the dps procc from the weapons that depend on critical hits. Because of the fact it depends on the crits and therefore also on how many attacks you can perform durhing a set timeframe the speccs with 1.0 GCD's will benefit more from it than for example temp. Further for me the DPS of the procc is roughly 1.3k dps but for someone with the same specc but higher crit rating it will be more dps within the same time.

    Therefore I would calc the DPS as follows:
    ability hits x overall cirt rate x procc chance x average dmg of the procc / duration

    My testing is showing with para that the procc can only be triggered by 1 GCD Skills + Power Manipulation, so Way of the Wind, Deadly Parity, OTS Bleeds and auto attacks do not trigger it even if they can crit.

    In numbers it would be:
    65 x 51.67% x 23.8% x 11,200 / 60 = 1,379 dps for the para as it is currently in the spreadsheet
    Spoiler!




    Regards,
    RePyH
    Last edited by RePyH; 11-30-2014 at 07:43 AM.

  15. #15
    RIFT Guide Writer
    Join Date
    Feb 2013
    Posts
    388

    Default

    Thanks I'll take a look at it.

    Quote Originally Posted by Jotunn View Post
    ...Also the cap of 3133 curretly on the spreadsheet does not coincide with the koeficient value you have put in the formulas...
    Why does it not?
    3.133 x 0.00012764405543399 = 0,3999... which is in the end 40%

    But i agree - i will put the number to 0.0001276

+ Reply to Thread
Page 1 of 24 1 2 3 4 5 11 ... 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