Pattern Progression: regression for video-game Price progession from data

Rospokadu

New member
Joined
Feb 27, 2018
Messages
1
Hello everyone

Im working on a spreadsheet that i will use to calculate every possible item that can be generated in a video game which im currently playing. The problem is, i cant figure out the item Price progression. For example, i know that Armors value is based on the Armor Rating of each item, because an item with say, 15 armor, will always have the same value, regardless of level requirement or item type (helm, gloves, chest, boots...).

So here is the list i compiled by searching in the Game

Armor RatingItem Value
11
23
37
413
520
629
739
851
964
1079
1195
12113
13132
14152
15174
16198
17223
18249
19277
20306
21336
22368
23402
24437
25473
26510
27549
28590
29632
30675
31719
32765
33813
34861
35912
36
371016
381070
391126
401183
411241
421301
431362
441425
451488
46
471620
481688
491757
501828
511900
521973
53
542124
552202
56
572360
582442
592525
602609

As Armor Rating can get as high as 540, finding and taking notes of such a high number of itens would take foverer.
 
Last edited:

lev888

Junior Member
Joined
Jan 16, 2018
Messages
211
Excel chart trendline option suggests:

y = 0.8714x1.9553 (power) or

y = 0.698x2 + 1.7804x - 7.1679 (polynomial)
 
Top