ESO Trials Scoring Calculator Updated for Wrathstone

asneakybanana

Trial Calculator(Based on @LZH spreadsheet from Summerset)(Make a copy of the sheet or download to use in Excel):
https://docs.google.com/spreadsheets/d/1j0QS47Dg73gpftAjDjVYIXmgX6GcDupFYQB7QlZ8pn0/edit?usp=sharing

A few notes if you have used the old scoring calculator: The time is now represented by a datetime object in Excel making it much easier to read. However it means you need to put the time in specifically as HH:MM:SS and you cannot leave off the hour field. An example for a 2 hour 8 minute 18s run would be 2:8:18 and an example of a 9 minute 31 second run would be 0:9:31. Notice how you always have to have the hour field even if it is 0. This should make time calculating easier than needing to figure the seconds in a run.

Trial Information:
Trial | Target Time (In Seconds) | Vitality | Base Score | HM Base Score
AA | 900 | 24 | 84300 | 124300
HRC | 900 | 24 | 93100 | 133100
SO | 1500 | 24 | 102700 | 142700
MoL | 2700 | 36 | 68150 | 108150
HoF | 2700 | 36 | 120100 | 160100
AS | 1200 | 36 | 15000 | 30000 (+1) | 70000 (+2)
CR | 1200 | 36 | 18000 | 32250 (+1) | 46500 (+2) | 85750 (+3) | 88000 (+3 & Trash)
DSA | 3600 | 24 | 20000
vMA | 5400 | 15 | 426000 | -750 per Sigil
BRP | 2400 | 24 | 75000 | -750 per Sigil

Trial and Arena Formulas
Trial Score = (Base Score + Vitality * 1000) * (1 + (Target Time - Your Time) / 10000)

Arena Score = (Base Score + Vitality * 1000 - Sigils Used * 750) * (1 + (Target Time - Your Time) / 10000)

Pulled from @LZH original thread: From Code65536 in the comments: "Also note that the time adjustment (i.e., 1 + time diff/10000) has a floor of 0.001, which means that if you take more than 2h46m30s beyond the par time, your score will not drop any further. E.g., if you see someone clearing vHoF with a score of 120, that means they took at least 3h31m30s".

Future Updates
Let me know if there's anything you are interested in seeing related to calculating scores in the future. One thing I have made up a formula for personal use is being able to plug in a score and vitality and have it give you what time you would need to get to achieve that score. If this is something you would be interested in seeing definitely let me know.

asneakybanana

Whoops, permissions were not set correct on the sheet. Should be fixed up now.

Veles

@asneakybanana Hello! Does the fact that all trash packs are killed affect the final score? For example, all Dwemer spiders in the HOF or the meat achievement with trolls room in the SO.

Danksta

Veles wrote: »

@asneakybanana Hello! Does the fact that all trash packs are killed affect the final score? For example, all Dwemer spiders in the HOF or the meat achievement with trolls room in the SO.

Yes, adds add to the score. I've seen sub 200k TTT because they skip the adds before first boss.