Exp split in groups, when chars are at different levels - what data do we need to figure it out?

[jak3676]

In your function above, you have base XP, group bonus XP and Mob type bonus all based on the individual char's level, and then only "Difficulty Mod" tied to party average level.

Like this:

XP = ((((Your Char Level * 5) + 45) + (Difficulty Mod for Avg Group Level) + Group Bonus + Mob Type bonus) / Chars in Party)

But this doesn't work. If you're party size is 1, you'll see that you need to have the difficulty mod applied to both the base XP and Mob type bonus.

In your above example, how would you handle a negative Difficulty Mod (i.e. where your individual or party average level is above the target mob level)?

*edit*
I did make 1 change to the spreadsheet to match what I'm seeing on the in-game combat log. Where combat log says, "<name> dies. You gain XXX experience. (+YY Rested bonus. +ZZ group bonus)". I'm listing XXX as the "Reported XP". So we'll have to subtract out Rested and Group bonus to get base XP later. This just makes data collection easier.

I'm filling in some numbers here:
https://docs.google.com/spreadsheets...it?usp=sharing