
Originally Posted by
Shunio
EDIT: With your help, I got it! Here's the formula in Google formula format (where $A2 = desynth skill level, and B$1 = craft level):
=min(IF(($A2+30-B$1)<0,0,IF(($A2+30-B$1)<20,(0.15*(19-min(ceiling(B$1/5),9)))*($A2+30-B$1),IF(($A2+30-B$1)<40,3*(19-min(ceiling(B$1/5),9))+(0.2*(19-min(ceiling(B$1/5),9))*(($A2+30-B$1)-20)),IF(($A2+30-B$1)<60,7*(19-min(ceiling(B$1/5),9))+(0.15*(19-min(ceiling(B$1/5),9))*(($A2+30-B$1)-40)),100)))),100)
In simpler terms:
Code:
{dScore} ::= {DesynthSkill} + 30 - {RecipeLevel}
{W} ::= (19-min(ceiling({RecipeLevel}/5),9))
(Essentially, for {RecipeLevel}s 1-5, {W}=18. Every five {RecipeLevel}s, {W} drops by 1, to a minimum of {W}=10 at {RecipeLevel} 41)
min([{dScore} <=0 = 0
{dScore} <20 = (0.15*{W})*{dScore}
{dScore} <40 = 3*{W}+(0.20*{W}*({dScore}-20))
{dScore} <60 = 7*{W}+(0.15*{W}*({dScore}-40))
{dScore}>=60 = 100],100)
Now I just need the materia and/or exp yields...