@AoDude
Yewnock
said
:
Let's take an example: say someone only does rune dragons and gargoyles tasks, and that for this person rune dragons have 60% weighting and gargoyles 40% (it's not relevant if that's possible or not). Simply calculating the xp/h on those percentages, it would yield 0.6 * 83k + 0.4 * 153k = 111k slayer xp/h. Let's assume you get on average 200 gargoyles/task (= 39k xp/task) and 60 runes dragons/task (= 59k xp/task), equating to (respectively) ~16 minutes/task and ~42 minutes/task. So the average time per task is 0.6 * 42 + 0.4 * 16 = 32 minutes/task, and the average xp per task is 0.6 * 59k + 0.4 * 39k = 51k slayer xp/task. With these new calculations, we would have the new average of (51k xp/task) / (32 minutes/task) = 1.6k xp/minute = 96k xp/h.
Looking at our xp/h columns in the Experience Table in the first sheet. We replace them with xp/task (data is already provided in the detailed table.)
Leave the contribution columns alone, it should calculate the contribution of xp/task correctly, and the overall exp rate totals will be correct.
Unfortunately, unless we can somehow split a selected range of columns into two to fit in more data without adding new columns, we need to add 2 more columns for time/task.
The first column would be "Time per Task" and the second column would be "Contribution"
which is % of total weight * average time (this will be in minutes.)
Sum all the time contributions together, that'd be our overall average time of all tasks selected together.
Now we have both overall average xp rates and overall average time.
Then we do this formula:
(overall average xp)/(overall average time) = average xp / minute * 60 = overall xp / hour