Tradeskill Skill Up Formula

[Bidoof]

You're right, there is a change in % between 10 and say 180 when leveling up, on both our formulas. The change is where I disagree.

I haven't messed around with the formula you posted and use in your spreadsheet, and if its giving you results like that, its significantly different from the linked one. The simple first formula in the link I posted is merely -after a simple reduction- this:

((STAT-x)/(Skill_Diff*y))/100

where x is 0 or 15 (depending on if its a INT/WIS skill or INT/WIS/other skill) and y is 1 or 2 (1 for succes, 2 for failure).

With this formula, successes increase your chance to skill up (obviously). Let's use those arbitrary numbers above. The best trivial to use at 10 is a theoretical 11, since you're most likely to succeed with it. At 200 INT, x=15 and Skill_Diff=2 (baking!), using the success equation for under 68 in the wiki gives us a success rate of 65%. If we do some ratio math and use just the above equation, we get a skill up chance of 76.31% overall.

Now, using the same INT, x and Skill_Diff, let's say our skill is 180 and our trivial is 181. Using the over 68 equation (what about equal to 68?!?), you shoot up to a success rate of 95%, hitting the 5% chance to fail cap. As would be expected from a higher chance to succeed, using *just* the formula above gives us a 90.19% chance to skill up. Obviously you might not be able to find a 181 trivial combine, so let's say 200 trivial. Then, your success rate is still 81.5% (higher than 65%), and your skill up chance is 83.94% (again higher than 76.31%).

If you add the second check- the one that actually directly uses your skill level- the 11 trivial with 10 skill barely drops to a 72.5% chance, while the 181 trivial with 180 skill drops drastically to 9.02%.

What I'm very lengthily trying to say is: either your formula (which I will admit I haven't done much with) is completely different from the first part of the one I'm asking about, or someone's math is off. I'd probably just say mine is wrong, as I like the appeal to authority fallacy, but feel free to take a look at it. This is more of a plunge back into math for me (even if its mostly just algebra), so I probably got something wrong.

Either way, I like this conversation. Its not often I get to talk math with anyone.