Hi, well done. It does seem to work. I do have some comments and a question though.
First, I don’t think that having previous group poses matters. Secondly, the pose cost does not matter. The first 3 have different pose values but all give the same EXP. You know that because you have allowed for it but for others the first 3 have a pose equivalent of 750, the next 2 1000 and the last 1250.
I tried to reproduce your formula in my spreadsheet but it said not enough arguments so I removed the Max and Roundup functions that really only tidy things up. I don’t understand where the numbers 101/3, 45 and 169/3 come from. The last numbers 113, 150 and 562/3 are the EXP given in a 2 way for equal levels at the above pose values.
So, my reduced formula: Average of the 3 players minus player level; multiply by the “unknown” number and add the equal level value. An example of an actual round.
Average 11 Diff 101/3 Diff x 101/3 Add 113 & Total
Level 8 3 33.66 101 214
Level 12 -1 33.66 -33.66 79.33
Level 13 -2 33.66 -67.33 45.66
My method using % gave values 213.75 78.75 45 so much the same.
But EXP actually gained was 122 45 26
I too thought that I had a formula then when I looked too many actual rounds did not fit.
I don’t know if this will help but putting in a pose value of 430 (it was Turn by the way) gives EXP as actually given.
First, I don’t think that having previous group poses matters. Secondly, the pose cost does not matter. The first 3 have different pose values but all give the same EXP. You know that because you have allowed for it but for others the first 3 have a pose equivalent of 750, the next 2 1000 and the last 1250.
I tried to reproduce your formula in my spreadsheet but it said not enough arguments so I removed the Max and Roundup functions that really only tidy things up. I don’t understand where the numbers 101/3, 45 and 169/3 come from. The last numbers 113, 150 and 562/3 are the EXP given in a 2 way for equal levels at the above pose values.
So, my reduced formula: Average of the 3 players minus player level; multiply by the “unknown” number and add the equal level value. An example of an actual round.
Average 11 Diff 101/3 Diff x 101/3 Add 113 & Total
Level 8 3 33.66 101 214
Level 12 -1 33.66 -33.66 79.33
Level 13 -2 33.66 -67.33 45.66
My method using % gave values 213.75 78.75 45 so much the same.
But EXP actually gained was 122 45 26
I too thought that I had a formula then when I looked too many actual rounds did not fit.
I don’t know if this will help but putting in a pose value of 430 (it was Turn by the way) gives EXP as actually given.