Excel Formula to Calculate Experience Modifier, is this it?

Excel experts, please check my formula. Monster levels are in Row 1, Player levels in Column A. This should give you a sheet of final experience modifiers:

B2=((($A2+5)/($A2+5+(MAX(0,ABS(B$1-$A2)-(3+ROUNDDOWN($A2/16,0))))^2.5))^1.5)

Shot of the results for the first 50 player levels/30 monster levels:

I thought there was 2.5%/ level penalty... not some exponential decay rape penalty... is this thing for real?

I based my formula on the information here:

http://en.pathofexilewiki.com/wiki/Experience

Which states that "safe range" = 3 + 1 for every 16 levels completed, and Effective Level Difference is any difference beyond the safe range, then gives the following formula:

Final Experience = [(PlayerLevel + 5) / (PlayerLevel + 5 + EffectiveDifference^2.5)]^1.5


Is the Wiki out of date in this regard? Where is your information coming from?

"

AintCare wrote:

I thought there was 2.5%/ level penalty... not some exponential decay rape penalty... is this thing for real?

the penalty you're thinking of is for currency drops, nothing else


To OP: It looks correct. could you upload this as a google doc?

I also wonder if it is possible for the OP to place this into a Google spreadsheet.

Somebody made a spreadsheet already but it only shows level 60 & above, you could cross check your formula with their formula

https://docs.google.com/a/zzzwebdev.com/spreadsheet/ccc?key=0Aj-4bMSBj95ddDRlOXJBRHloTkNoaWJoR1k4SGJ2RXc&usp=sharing#gid=0

"

RandallPOE wrote:

Somebody made a spreadsheet already but it only shows level 60 & above, you could cross check your formula with their formula

https://docs.google.com/a/zzzwebdev.com/spreadsheet/ccc?key=0Aj-4bMSBj95ddDRlOXJBRHloTkNoaWJoR1k4SGJ2RXc&usp=sharing#gid=0

Thank you for linking that!

I found this tool.

https://googledrive.com/host/0B28esAM-SVW5ZnRvTnFENmU0YmM/mlvl.html

I added all the player levels/mob levels.

https://docs.google.com/spreadsheet/ccc?key=0AnRg97ykoFMSdDFfaFo3eXdRcTBOakZfdmhzakZ5enc&usp=sharing

If someone is really good at formatting please tell me so you can make the columns equal sized so that they look nice. (I will add you as editor)

TODO: make it look nice (easier to look at)

EDIT: i added my version of the chart (with link to this thread to give credit) to beta general discussion.

http://www.pathofexile.com/forum/view-thread/306494