 Rank: Journeyman Groups: FFXIV Player, Moderator
Joined: 9/11/2010(UTC)
Posts: 115
Location: MO, USA
Was thanked: 20 time(s) in 17 post(s)
|
EDIT 10-10-2010: Re-did fix for squares new recipe xp formula, had it wrong.
To calculate XP we need a few numbers, first the starting quality of the craft. This is a little random, but also changes with +1/+2/+3 items. We subtract the starting quality from the ending quality to get the second part of the XP amount. Then add to the first part of XP amount, which is always 1000.
Then we take off 5% for each rank above the recipe rank, and add 5% for each rank below the recipe rank. This is the XP you recieve, unless it's a levequest recipe. If it is a levequest recipe, you then multiply by 1.5.
Unfortunatly, fishing/logging/mining doesn't work this way. It seems the XP gained is based on your rank and the grade of the node. Fish seem to have different ranks, but this method doesn't work to find the rank the catch is.
TL;DR
Simple spreadsheet. Please only change yellow cells. Feel free to copy. http://bit.ly/di9GKd Edited by user Sunday, October 10, 2010 10:07:56 PM(UTC)
| Reason: Fixed spreadsheet
|
 3 users thanked Fearsyth for this useful post.
|
|
|
|
|
|
|
|
 Rank: Administration Groups: Administrators
Joined: 7/15/2010(UTC)
Posts: 1,174
Location: Copenhagen, Denmark
Thanks: 290 times
Was thanked: 349 time(s) in 224 post(s)
|
Great information... thanks for sharing. |
|
|
|
|
|
|
Rank: Journeyman Groups: FFXIV Player, Moderator
Joined: 9/11/2010(UTC)
Posts: 115
Location: MO, USA
Was thanked: 20 time(s) in 17 post(s)
|
I think I have this working again. Square and their adding randomness to their XP. Also, they changed the formula a bit. Still testing a bit, but looks good. Edited by user Friday, September 24, 2010 10:40:00 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Journeyman Groups: FFXIV Player, Moderator
Joined: 9/11/2010(UTC)
Posts: 115
Location: MO, USA
Was thanked: 20 time(s) in 17 post(s)
|
Fixed again, hopefully for last time. Although will require an update to re-add lower ranks later if it's still working correctly after more testing.
Now allows for entering:
levequest synths, as long as you divide XP by 1.5 (for instance if you recieved 1660 XP, enter "=1660/1.5", without the double quotes, in the XP cell).
synths that ranked you up, enter your rank after the synth and rank up.
+1/+2/+3 items, starting quality isn't counted.
|
|
|
|
|
|
 Rank: Amateur Groups: FFXIV Player
Joined: 9/3/2010(UTC)
Posts: 7
Location: Essex
Thanks: 1 times
|
Do you have an alias over at Zam?
I would like to link this in my sig over there, theres alot of people wondering about recipie ranks.
Also is there no direct corelation between skill points and the exp you recieve?
|
|
|
|
|
|
Rank: Journeyman Groups: FFXIV Player, Moderator
Joined: 9/11/2010(UTC)
Posts: 115
Location: MO, USA
Was thanked: 20 time(s) in 17 post(s)
|
Sorry for late reply, must have missed thread update...
No zam account, sorry.
As for skill points, it accounts for more than just the ranks. For instance, I believe letting a recipe go unstable, then restablizing gives extra SP. And since I've figured out how to tell from physical XP, I haven't bothered looking at SP anymore. Edited by user Tuesday, October 26, 2010 7:57:58 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
| Users browsing this topic |
|
Guest
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.