Fun with Math for 1.21

Printable View

03-21-2012, 01:25 PM
tymora

Fun with Math for 1.21

Crafting Bonus EXP % from Quality:
QBonus% = 0.8 * (QDELTA - MOD(QDELTA,10))
where
QDELTA = Quality Gained
and MOD = modulus

In layman's terms, for every 10 quality, you get 8% bonus exp, no part thereofs.

E.g.
+500 quality = 400% exp bonus
+152 quality = 120% exp bonus

**************************************
Crafting EXP:
Rested Bonus (RBonus%) = +50%
Exp Gained = Base EXP * (100% + RBonus%)/100% * (100% + QBonus%)/100%
where QBonus% is % calculated above.

In layman's terms, apply the bonus from rested before applying the quality bonus.

E.g.
Equal rank synth with 200% exp bonus:
Exp Gained = 250 * 1.5 * 3 = 1125
(50% bonus => You get 150% of base exp.)

**************************************
BASE EXP Table:

This is used to reverse calculate the level of a recipe.

Odd Rows = Relative Level of recipe
Even Rows = Base EXP for that Relative Level

Code:

-20 -19 -18 -17 0 7 15 20 -16 -15 -14 -13 -12 -11 -10 25 30 35 40 45 50 62.5 -9 -8 -7 -6 -5 -4 -3 75 87.5 100 112.5 125 150 175 -2 -1 0 1 2 3 4 200 225 250 300 350 400 450 5 6 7 8 9 10 500 550 600 650 700 750

No info for -17 to -20.

**************************************
HQ% based on Quality
HQ% = 0 under Quality 300

Best Fit (Quality 300-799)
HQ% = CEILING(2.18E-15 * Q^5)
where Q is Total Quality
Accuracy of Fit (Exact) = 40.5%
Accuracy of Fit (Within 1%) = 92.7%
Accuracy of Fit (Within 2%) = 99.5%
Accuracy of Fit (Within 3%) = 100%

*I made sure the HQ% at 799 quality is calculated to be 71% when it is 69%. Not too far off...:p

Best Fit (Quality 800-1000)
HQ% = Q - MOD(Q, 10))/10 - ROUND((1000 - Q)/20, 0)
where Q is Total Quality
Accuracy of Fit (Exact) = 87%
Accuracy of Fit (Within 1%) = 100%
*****************************************************************
Starting Quality

Starting quality is weighted by optimal level of a material except when it is below 10. In that case, the optimal level is treated as 10 regardless of what it is.

Qs = FLOOR(500 * SumHQLevels / TotalLevels)

where SumHQLevels = Sum of HQ Material's Optimal Levels
TotalLevels = Sum of all Material's Optimal Levels

Known Recipes:
Steel Ingot - Iron Ore (18), Bomb Ash (27)
E.g.
4 HQ Iron Ore
Qs = FLOOR(500 * (4 * 18) / (5 * 18 + 3 * 27))
= FLOOR(500 * 4/9.5) = 210

Thunderstorm Axe - Steel Ore (30), Silver Ingot(25), Walnut Lumber(25)
E.g.
2 HQ Steel Ingot
Qs = FLOOR(500 * (30*2) / (30*2 + 25*2)) = 272

Karakul Fleece - Snurble Tuft (42), Karakul Fleece (39), Natron (3, treated as 10)
E.g.
All HQ except Natron
Qs = FLOOR(500 * 279/289) = 482

Bronze Ingot - Copper Ore (3 as 10), Tin Ore (7 as 10)
E.g.
Tin Ore HQ
Qs = FLOOR(500 * 20/80) = 125
03-21-2012, 01:34 PM
Sephrick

Makes it seem worth trying to raise quality. I really think 1.21 was an awesome fix for crafting as a whole. My only other request would be static access to leves for the purpose of leveling. This clearly makes performance while leveling a boon.
03-31-2012, 04:05 PM
tymora

Bumping. Updated the post with just about everything of interest.
Cheers.
03-31-2012, 08:22 PM
zaviermhigo

Too late for me to read this, (4am ish here PST), but I'm gonna bump for now, and post in it so I can find it later.
04-01-2012, 03:03 PM
Raldo

I can't understand half of what the OP has posted, but the base exp table is good to know, thanks.
04-01-2012, 05:26 PM
tymora

Quote:

Originally Posted by Raldo

I can't understand half of what the OP has posted, but the base exp table is good to know, thanks.

That table is just a re-post from a long time back.
04-02-2012, 07:49 PM
HoolieWho

Thank you, Tymora. The information on starting quality is especially interesting. Could you add a plot of HQ chance vs Quality? Since it's so nonlinear, a plot would be great to see.

Do you have information on the range of possible durability loss (and progress) for careful/rapid/standard? Does it depend on crafting stats at all?

Thanks again for the testing. Crafting sure has changed.
04-03-2012, 10:40 AM
tymora

Quote:

Originally Posted by HoolieWho

Thank you, Tymora. The information on starting quality is especially interesting. Could you add a plot of HQ chance vs Quality? Since it's so nonlinear, a plot would be great to see.

Do you have information on the range of possible durability loss (and progress) for careful/rapid/standard? Does it depend on crafting stats at all?

Thanks again for the testing. Crafting sure has changed.

http://static2.finalfantasyxiv.com/a...Q39h9GB3Jo.png
04-03-2012, 10:43 AM
tymora

Quote:

Do you have information on the range of possible durability loss (and progress) for careful/rapid/standard? Does it depend on crafting stats at all?

Standard - Max 25% Progress, Normal failure rate,
Rapid - Max 35% Progress, High failure rate, No quality gain, no durability loss if success, high durability loss if not
Careful - Max 5% Progress, Normal Failure rate (same as Standard), ~5x quality gain of Standard

Quality gain depends on other factors so I won't bother guessing the amount.
A value of around 30 is more or less normal for recipes around level using Careful. On low recipes, I have seen it hit 70+.

"Normal failure" is somewhere between Standard and Careful rates in previous patch.
i.e. Standard is nerfed with a higher failure rate.

Crafting stats should still do more or less same thing as before patch.
Craftsmanship affect progress, quality gained and success rate of an action.
Control affect instability though now with the crafting nerf, it is significantly less useful. Less explosions and no quality loss even if exploded.

It seems that stat enhancements on quality are now more noticeable, probably due more to the increase in quality gain from Careful than actual increase. E.g. 10% of 20 is less noticeable than 10% of 50.