test content
  • Games
  • Social
  • Arc News
  • Support
  • Zen
What is the Arc Client?
Install Arc
Forums > Home› PvE Discussion

Different look at the Diminishing Returns spreadsheet

kanczuznkanczuzn Member Posts: 0 Arc User
edited October 2013 in PvE Discussion
I like graphs. I do. But they're a pain to look at and say "Ah! I see exactly what the slope is and what sort of returns I should expect!"

So, what to do? I'm sure that there are some of you out there who can tell me the slope of a line just by looking at the graph and nail it within a few decimal places in only a couple seconds. Glad to hear it! However, I'd rather just make my own spreadsheet that breaks it down into an easier fashion for me. Hopefully it'll be of use to some of you as well.

Couple notes:
Yes, my math is on the messier side. I didn't feel like spending the time cleaning it up more.
No, I don't intend to convert the document to another form besides Google.

Without any further ado,

https://docs.google.com/file/d/0Bz83ep-iu5J2NV9QbFJfamJnaHc/edit?usp=sharing

Lastly, this spreadsheet was created using the equations from:
https://www.desmos.com/calculator/3dqpvhuavj

Which was probably derived from this source:
http://nw-forum.perfectworld.com/showthread.php?301761-Calculating-stats-and-their-effects

Without those equations, I wouldn't have been able to do what I have. Also if you reuse my spreadsheet or derive your work from, I'd appreciate a little hat tipping as well. Take it easy everyone. Good luck, have fun.
Post edited by kanczuzn on

Comments

  • kanczuznkanczuzn Member Posts: 0 Arc User
    edited September 2013
    And here's the Google Docs. Mind you, I just copied the numbers and imported it into the Google Spreadsheet. If you want to see the full calculations I used, the excel document is where you would want to look. Here's the Google Spreadsheet one:

    https://docs.google.com/spreadsheet/ccc?key=0Aj83ep-iu5J2dEt2bWlSRzJYTU9yRzJkSTFvTTNaVWc&usp=sharing
  • raptorskyfireraptorskyfire Member, Neverwinter Beta Users Posts: 120 Bounty Hunter
    edited September 2013
    Thank you very much for this. It's very helpful!
    Part of Storm-Shore, a RP/PvE guild. http://www.stormshore.com/

    I have many alts, I am a class and race rainbow.
  • bratzinatorbratzinator Member Posts: 68
    edited September 2013
    Thanks for this stuff, nice work.
  • kanczuznkanczuzn Member Posts: 0 Arc User
    edited September 2013
    No problem. By the way, if anyone has any suggestions or if someone has an equation they want me to change/add - just say. I'll do my best.
  • cheapjingcheapjing Member Posts: 113 Arc User
    edited September 2013
    you are mad! And I thank you for the work! :)
  • hwlrmnkyhwlrmnky Member Posts: 90
    edited September 2013
    Thank you, this is much easier for my brain to eat.
  • kanczuznkanczuzn Member Posts: 0 Arc User
    edited September 2013
    Daww... you guys are making me blush now! And that's just not smexy on a dude.

    No problem you two.
  • whistlingdixiewhistlingdixie Member Posts: 0 Arc User
    edited September 2013
    Something doesn't look right with Critical Strike. You sheets show way more benefit to Critical Chance than there should be. The rest looks right. I checked at 1000, 5000, and 10000 against the plots at the desmos link. I'm not sure how you got those numbers since the spreadsheet only have values and no formulas.

    I believe the formulas originally came from here:
    http://nw-forum.perfectworld.com/showthread.php?301761-Calculating-stats-and-their-effects
  • kanczuznkanczuzn Member Posts: 0 Arc User
    edited October 2013
    whistlingdixie wrote: »
    Something doesn't look right with Critical Strike. You sheets show way more benefit to Critical Chance than there should be. The rest looks right. I checked at 1000, 5000, and 10000 against the plots at the desmos link. I'm not sure how you got those numbers since the spreadsheet only have values and no formulas.

    I believe the formulas originally came from here:
    http://nw-forum.perfectworld.com/showthread.php?301761-Calculating-stats-and-their-effects

    I'll tell ya what, I'll double check the formula on Monday. But that was one of the interesting things I noticed too. It seems that Crit seems to last substantially longer above the .3%/100 points marker. However, it's a very shallow increase that borders it. Basically, from what I saw, it looks to increase a bit quickly, then evens out very quickly into a very shallow increase.

    Quick note: I'll check my characters after lunch and compare their crit values to the estimated ones I should have on the spreadsheet. Dragon is down or I would have already.

    Quick note #2: Looks like the numbers are off for crit. I thought I checked them, but apparently I didn't check it well enough. I'll fix that on Monday/Tuesday. But, as far as the equations, if you download the excel spreadsheet, the equations are in there.
  • kanczuznkanczuzn Member Posts: 0 Arc User
    edited October 2013
    Alright, so update. I looked over the math, and the equations, and it looks fine.

    =((((10186+A1^(1.2))*(34.56*A1^0.2))-((28.8*A1^(1.2))-(1.2*A1^0.2)))/((10186+A1^(1.2))^2))

    Like I said, messy, I'm not in the mood to reduce generally. :P

    But with the original equation being: (28.8*x^(1.2))/(10186+A1^(1.2))

    And I'm taking the derivative, it seems that the math is actually right. Both the places I'm looking at agree on the equation, so I can only assume that the crit % difference I'm seeing is based off of the ability score numbers rather than the crit stat numbers. Either way, yes, it seems that crit actually does stay above the .3%/100 line substantially longer than the rest of the statistics, however if you look closely it doesn't do it by much and it's far more of a steady burn than a rocket in numbers.
  • kanczuznkanczuzn Member Posts: 0 Arc User
    edited October 2013
    Can anyone think of any particular numbers that I should set up for changing the limits on where the diminishing returns should cut/turn to red? For instance, I think(can't remember) that Armor Pen has a soft cap somewhere because of PvE having a limit with boss mobs.
Sign In or Register to comment.