Mileage weighted score

[RitaJ]

Checked Tesla blog but didn’t find the detail explanation of so called mileage weighted score.
I can see a very detailed formula on how to calculate the daily score but don’t know how they calculate the aggregate score. Is that simple average the daily score?

 

[n.one.one]

In Google Sheets the actual formula in my sheet looks like this.
=AVERAGE.WEIGHTED($V$3:V9,$T$3:T9)

Translated to words it looks like this.
=AVERAGE.WEIGHTED(First rounded score:Last rounded score,First miles entry:Last miles entry)
Note that the $ sign before the V3 and T3 ($V$3:V9,$T$3:T9) is to indicate that as always being the beginning of the range.

 

[Dan D.]

Checked Tesla blog but didn’t find the detail explanation of so called mileage weighted score.
I can see a very detailed formula on how to calculate the daily score but don’t know how they calculate the aggregate score. Is that simple average the daily score?

Weighted average is found by taking a score and multiplying by the mileage, then do this for all the other results & mileages. Add those numbers together and divide by the total mileage.