ESO Trial Scoring Calculator Updated for Greymoor

asneakybanana

Hi all,
Here is the trial scoring calculator spreadsheet updated for Greymoor to include the new Kyne's Aegis Trial
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
SS | 1800 | 36 | 87250 | +40000 for each HM completed
KA | 1800 | 36 | 85950 | +40000 for each HM completed

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.