2013-04-02, 02:57 PM
Let's put it this way. You want to convert from degrees Fahrenheit to degrees Celsius. I can either give you the formula, or give you a conversion table. If you want the quick and dirty, you'll use the table; if you want precision, you'll use the formula. Both have their uses.
Your method works, but is not mathematically efficient. You're basically doing a contour plot of the function dA/dk = [4pA / (4p*(100+k) + s)], where p = primary stat, A = (magic) attack, and k is %stat, and with k (%stat) and A ((M)ATT) as the axes. In words, you're doing a plot to map out the amount of change of A for every unit change in k. This was derived from a simple division of the derivatives, (dD/dk) / (dD/dA). Just some intermediate calculus [I think...? My education is a tad different from everyone else I think...]. A pity WolframAlpha doesn't accept Mathematica commands anymore, else you can see for yourself what I'm talking about... But because linearity holds, your spreadsheet allows a user to directly multiply values with the multiple of %stat, so that one isn't merely confined to 1%stat, something that plots don't easily tell but tables of numbers do.
But with upcoming changes, you will eventually find that comparing %stat to (M)ATT will become even less valuable than what little value it holds right now.
Hadriel
Your method works, but is not mathematically efficient. You're basically doing a contour plot of the function dA/dk = [4pA / (4p*(100+k) + s)], where p = primary stat, A = (magic) attack, and k is %stat, and with k (%stat) and A ((M)ATT) as the axes. In words, you're doing a plot to map out the amount of change of A for every unit change in k. This was derived from a simple division of the derivatives, (dD/dk) / (dD/dA). Just some intermediate calculus [I think...? My education is a tad different from everyone else I think...]. A pity WolframAlpha doesn't accept Mathematica commands anymore, else you can see for yourself what I'm talking about... But because linearity holds, your spreadsheet allows a user to directly multiply values with the multiple of %stat, so that one isn't merely confined to 1%stat, something that plots don't easily tell but tables of numbers do.
But with upcoming changes, you will eventually find that comparing %stat to (M)ATT will become even less valuable than what little value it holds right now.
Hadriel