4E: The magic item table formula - revealed!
The secret THEY didn't want you to know!
OK, I'm being a tad overdramatic. Anyway, there's a table in the PHB that lists magic item prices by item level (page 223). There's a definite pattern there, so I sat down and figured out what the formula was. Can it be useful? Eh...hard to say. It was a fun puzzle for me, so I thought I'd share it:
160*POWER(5,TRUNC((Level-1)/5))*(2.25+MOD(Level-1,5))
It's in an Excel format, but it should be easy enough to decipher. Obviously, "Level" is the item level. "TRUNC" means to truncate (drop the decimal) of "(Level-1)/5". POWER means take the first value ("5") to the power of the second value "(TRUNC((Level-1)/5)"). And "MOD" is the modulus formula; take the remainder of "Level-1" divided by 5 (so "3" would be "2", "12" would be "1", "21" would be "0", etc.).
Like I said, not necessarily very useful. But I figured I did the work so I'd share it.
OK, I'm being a tad overdramatic. Anyway, there's a table in the PHB that lists magic item prices by item level (page 223). There's a definite pattern there, so I sat down and figured out what the formula was. Can it be useful? Eh...hard to say. It was a fun puzzle for me, so I thought I'd share it:
160*POWER(5,TRUNC((Level-1)/5))*(2.25+MOD(Level-1,5))
It's in an Excel format, but it should be easy enough to decipher. Obviously, "Level" is the item level. "TRUNC" means to truncate (drop the decimal) of "(Level-1)/5". POWER means take the first value ("5") to the power of the second value "(TRUNC((Level-1)/5)"). And "MOD" is the modulus formula; take the remainder of "Level-1" divided by 5 (so "3" would be "2", "12" would be "1", "21" would be "0", etc.).
Like I said, not necessarily very useful. But I figured I did the work so I'd share it.
posted by MythosaAkira | 11:17 PM
0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home