Another XP Formula Thread

[jared96]

Starrted a new skill tree a few weeks ago and thought I'd track just what itv was going to require of me. Being Master HA, shields started at 50 and making a few shields over time had me up around 56. So I started digging and crafting and tracked with a spreadsheet just what it took to get there.

Well to go from 56 -> 250, I hadda earn 12,610,038 XP and craft 3,427 shields. From 56-100 they were the big ones, after that they were bucklers. Took 78 crafts (with cats) to get that last level.

With just a quick look, it seems, for shields anyway the required XP can be calculated with the following formula:

XP = F * Level * Level

The F is the "fudge factor" which seems to range a bit. At level:

151 = 2.27
175 = 2.11
200 = 2.43
225 = 2.55
250 = 2.56

So for example, earning level 250.....

2.6 * 250 * 250 = 160,000 XP (159,773 actually in my case)

[jared96]

Looking at another skill 1h spear, between 185 and 195 at least, formula appears to be the same with a different fudge factor somewhere between 3.4 and 3.6:

3.45 x level x level

At level 191 for example 3 x 191 x 191 = 125,859 (126,000 actual)

[sidusar]

Interesting. I'd expect all skills to be that way with just different Fs then. But it's very odd that F is actually lower for 175 than it is for 151.

Is there any pattern if you plot all the F values against their level?

[blaah]

Interesting. I'd expect all skills to be that way with just different Fs then. But it's very odd that F is actually lower for 175 than it is for 151.

out of game xp/level counting based log file (if xp is not nerfed on purpose) is very inaccurate , but
melee/range/magic/forage skills should have same "xp formula". craft has bit different.

the numbers in xp_graph.csv (link in sig) are from forage, but fight/magic numbers were "close enough" when i did the xp counting.
to get accurate xp/level values, it really depends how much xp is left for ding and how much xp did you got when you dinged (1xp left for ding and 3k xp for example)

Is there any pattern if you plot all the F values against their level?

fuzzy pattern

[jared96]

Interesting. I'd expect all skills to be that way with just different Fs then. But it's very odd that F is actually lower for 175 than it is for 151.

Is there any pattern if you plot all the F values against their level?

Well it's off cause remember if you have gained 59,999 xp and the trip is 60k, then I'm logging say 62,500 so my F's are always gonna be bigger. But it is add that it goes up and down.

[moyaku]

Congrats on doing the math I couldn't have done it myself

XP formulas are fun to find (I guess) but knowing it doesn't change the fact that you will still need to do the actions til the final 250th ding .

*hurries back to his craft table*

[sidusar]

But it's nice to know how many more mats you'll have to dig to make sure you'll get those 3 levels in crafting. Or how many levels those 5 stacks of cats will last you.

My experience with mastering a combat skill was that you'd use up about 800 cats per level at 230 and almost a full stack by 250. That seems to fit with that graph pretty well.

melee/range/magic/forage skills should have same "xp formula". craft has bit different.

Quite different from that graph. Craft looks like it could be quadratic, but fight/magic/forage seems to be 2 straight lines meeting at around level 125.

Did you happen to check afflictions specifically? I swear those take more experience than other combat skills.

[jared96]

OK it wont paste well (looks fine in preview though) but here's the spreadsheet output from Level 151 -> 250

Level - XP Needed - No. Crafts - No. Mats - F
151 51,027 10 110 2.24
152 51,945 11 121 2.25
153 52,678 11 121 2.25
154 52,453 12 132 2.21
155 52,928 11 121 2.20
156 53,877 11 121 2.21
157 54,233 11 121 2.20
158 55,094 11 121 2.21
159 57,264 12 132 2.27
160 59,319 12 132 2.32
161 54,827 12 132 2.12
162 58,121 11 121 2.21
163 57,745 11 121 2.17
164 58,624 11 121 2.18
165 57,055 11 121 2.10
166 62,062 12 132 2.25
167 62,072 12 132 2.23
168 62,260 15 165 2.21
169 64,901 13 143 2.27
170 62,823 13 143 2.17
171 64,810 15 165 2.22
172 62,421 18 198 2.11
173 63,536 12 132 2.12
174 64,633 13 143 2.13
175 64,676 16 176 2.11
176 63,995 14 154 2.07
177 66,200 16 176 2.11
178 68,326 13 143 2.16
179 68,394 14 154 2.13
180 69,117 19 209 2.13
181 71,916 13 143 2.22
182 74,130 15 165 2.24
183 74,575 14 154 2.23
184 75,374 14 154 2.23
185 76,138 20 220 2.22
186 81,784 16 176 2.36
187 83,460 13 143 2.39
188 80,865 16 176 2.29
189 85,583 17 187 2.40
190 83,559 20 220 2.31
191 85,041 23 253 2.33
192 87,399 18 198 2.37
193 87,580 18 198 2.35
194 88,175 21 231 2.34
195 90,346 18 198 2.38
196 90,253 17 187 2.35
197 94,321 19 209 2.43
198 94,822 20 220 2.42
199 95,831 20 220 2.42
200 97,096 21 231 2.43
201 96,591 17 187 2.39
202 100,288 17 187 2.46
203 101,618 29 319 2.47
204 102,498 19 209 2.46
205 105,324 22 242 2.51
206 104,319 20 220 2.46
207 108,972 21 231 2.54
208 110,089 21 231 2.54
209 111,117 24 264 2.54
210 111,926 22 242 2.54
211 111,963 24 264 2.51
212 113,386 23 253 2.55
213 115,865 34 374 2.55
214 113,449 25 275 2.48
215 115,528 24 264 2.50
216 115,481 37 407 2.48
217 119,011 26 286 2.53
218 122,303 28 308 2.57
219 120,631 28 308 2.52
220 124,541 28 308 2.57
221 123,023 28 308 2.52
222 126,328 29 319 2.56
223 125,242 30 330 2.52
224 128,915 32 352 2.57
225 128,889 32 352 2.55
226 130,572 32 352 2.56
227 130,647 33 363 2.54
228 131,471 30 330 2.53
229 131,904 35 385 2.52
230 134,736 36 396 2.55
231 136,421 38 418 2.56
232 135,084 38 418 2.51
233 138,051 40 440 2.54
234 138,745 41 451 2.53
235 139,897 42 462 2.53
236 141,368 44 484 2.54
237 143,143 51 561 2.55
238 140,868 46 506 2.49
239 145,979 48 528 2.56
240 145,899 50 550 2.53
241 150,181 54 594 2.61
242 151,501 56 616 2.61
243 152,073 57 627 2.60
244 152,998 58 638 2.59
245 153,754 60 660 2.58
246 154,239 61 671 2.57
247 156,660 67 737 2.59
248 158,029 67 737 2.59
249 159,215 73 803 2.59
250 159,773 78 858 2.56


Totals are 9,966,169 XP needed from 151 -> 250, making 2,611 crafts using 28,721 mats with an average Fudge Factor of 2.39. Note all crafting was done with cats (when I didn't forget to load them....that explains some high vraft numbers in above) and with an overcraft of 50 working down to 40 and then back up again. For example, crafted at level 240 when toon was level 190 .... when toon reached 200, switched to 250 craft. With no cats, figure on doubling the amount of mats and crafts for the most part.

[iphdrunk]

here's the spreadsheet output from Level 151 -> 250

Interesting work, thanks for the time and effort to come up with this