Upgrade your account to a Community Supporter account and remove most of the site ads.

Reply to thread

Message: <blockquote data-quote="Truename" data-source="post: 4603893" data-attributes="member: 78255">I was working on a spreadsheet to track magic items today and I had to figure out a formula to convert magic item levels to prices. It was a bit tricky, so I thought I'd share it with you.First, the formula. "$A1" is the item's level. I'll explain it below.[code]=360*POWER(5,INT((-1)/5))+((360*POWER(5,INT((-1)/5))/2.25)*((MOD(-1,5))))[/code]Now, how it works.Magic items are divided into "half-tiers." Items of levels 1-5 are in a half-tier, levels 6-10 are in another half-tier, and so forth. We'll number those tiers starting with zero, so levels 1-5 are in tier 0, levels 6-11 are in tier 1, and so on.[code]half_tier = int((level - 1) / 5)[/code]There's a big jump in price between half-tiers.  Each half-tier has its own "base price," which is the same as the price of the first item in the half-tier.  So the base price of half-tier 0 (levels 1-5) is 360 gold, the base price of half-tier 1 (levels 6-11) is 1800 gold, and so on.[code]base_price = 360 * (5 ^ half_tier)[/code]Within a tier, the price increases more slowly. It increases differently in each tier, but always by the same amount. For example, in tier 1 (levels 6-10), level 7 items are 800 gold more expensive than level 6 items, and level 8 items are 800 gold more expensive than level 7 items.  In tier 0 (levels 1-5), the price increases by 160 gold each time. We'll call this the "per-level increase."[code]per_level = base_price / 2.25[/code]To calculate the price of an item, we need to know the level relative to its tier. We'll count from zero again.  For example, a level 6 item is level 0 relative to its tier (which starts at 6), and a level 18 item is level 2 relative to its tier (which starts at 16). This is the "relative level."[code]rel_level = (level - 1) % 5[/code]Given an item's relative level and how much the price increases every level, it's easy to calculate the price increase within the tier.  For example, an item of level 8 is in tier 1, which has a per-level increase of 800.  It has a level of 2 relative to its tier (which starts at level 6), so the item is 1600 gold more than a level 6 item.  We'll call this the "relative price."[code]rel_price = per_level * rel_level[/code]Once we have the relative price, we just add in the base price for the tier, and we're done![code]price = base_price + rel_price[/code]Now, to put it all together...[code]price = (360 * (5 ^ (int((level - 1) / 5)))) + (((360 * (5 ^ (int((level - 1) / 5)))) / 2.25) * ((level - 1) % 5))[/code]Simple. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=";)" title="Wink    ;)"  data-smilie="2"data-shortname=";)" /></blockquote>

Verification