Don't think anything has been posted on this topic yet so here it is.
Before I start, I must emphasize that things are far from complete.
Crafting:
This should be more or less the finalized formula for calculating recipe rank from physical exp.
EXPGAINED = Ceiling( BASEEXP * (0.001 * QUALITYGAINED + 1) )
where EXPGAINED = what you see on screen
QUALITYGAINED = Self-explanatory
Ceiling = Round up to nearest whole number
BASEEXP can be referred from the table below. Note the oddity at -13 to -11 and the change to a drop of 10 exp per level at -16.
Base EXP Table (Feb 2 2011):
Base EXP Table (Pre-Feb 2 Patch - For reference only)Code:-21 -20 -19 -18 -17 -16 -15 -14 -13 -12 -11 ??? ??? ??? ??? ??? 40? ??? 80 ??? 150 200 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 250 350 450 550 650 750 800 850 900 950 0 1 2 3 4 5 6 7 8 9 10 1000 1200 1400 1600 1800 2000 2200 2400 2600 2800 3000
In short, you no longer get exp 21 ranks above recipe, can't try recipe over 10 ranks and can calculate the recipe rank by just looking at a single value of experience gained.Code:-21 -20 -19 -18 -17 -16 -15 -14 -13 -12 -11 0 10 20 30 40 50 100 150 200 300 400 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 500 550 600 650 700 750 800 850 900 950 0 1 2 3 4 5 6 7 8 9 10 1000 1050 1100 1150 1200 1250 1300 1350 1400 1450 1500
The impact of quality is small if you only spam Standard, so it is possible to do a quick estimate by down-rounding to nearest 50 for most levels.
For Leves, multiply the BASEEXP by 1.5. so there are no issues with using Leves to calculate recipe rank either.
SKILL:
AVGSP = BASEEXP / 4
Range of SP = 0.75 AVGSP < SP < 1.25 AVGSP
(Covers most of the hits, may go up to 0.5).
=> No correlation with durability, quality or actions taken.
Exact formula unknown but average SP varies linearly with level. Gradient is about 12.75 SP per level.
It almost feels like it is a linear BASESP + random(1 to BASESP/2).
I don't see any meaningful correlation between SP, durability, quality or even actions taken.
#############################
# Equipment Stat Scaling: #
#############################
- There is a sharp drop at 1 level under optimal equipment rank before it starts to follow a linear scaling trend.
- Between 2 consecutive equips of the same type, the time you can upgrade is when you hit the rank in the middle and rounded up of the 2 optimal ranks.
E.g. Rank 10 if deciding between Rank 7 and Rank 12 crafting tool.
- The stat loss is capped at the lower rank equip's stats.
=> As a result of this, every type of equip will differ in the exact formula to calculate equipment scaling.
=> As a result of this, different stats will scale differently depending on the exact difference between stat values on different equips.
*Note that the numbers I give here fit my limited data, it may(and should) be slightly off with a larger data set.
- Note that the modifier is 1 at x = 0, so it means that there is a sharp drop at 1 level under optimal equipment rank before it starts to follow a linear scaling trend.
- Yes, they all follow different linear lines...pretty certain of this.
- Feel proud wearing gear 10 levels above your level? Might want to reconsider practicality against coolness, otherwise you will be a pimp gimp.
- I believe some other forum placed the penalty to non-optimal job at 40% reduction. Do you die a lot being a robed pugilist or a chain mail conjurer?
***These formulas work for only specific items***
Tool:
Modifier for all stats = 0.0335x + 0.80.0396x + 0.85 where x = -1, -2, -3... (level from optimal)
0.0335 is about 1/30 so it could be that as well.
Armor:
Def/MDef Modifier = 0.04x + 0.84 (a.k.a 16.4% drop 1st level and 4% drop thereafter)
0.04 = 1/25
Eva Modifier = 0.02x + 0.94 (a.k.a 6.2% drop 1st level and 2% drop thereafter)
0.02 = 1/50
Other Stat Modifier (e.g. Control, Gathering) = 0.04x + 0.75 (a.k.a 25.4% drop 1st level and 4% drop thereafter)
0.04 = 1/25
- What do you do with the modifiers?
ACTUALSTAT = Ceiling(MODIFIER*STAT)
----------------------------------------------------
Feel free to verify these formulas and refine them more - And update the recipes on YG and Zam...etc with them
Cheers.
Edit: Updated recipe rank calculation with a BASEEXP table.
Edit: Feb 2 Formula update and added Crafting AVGSP formula.
XI Wiki



