search

masterplane8 / F1-League-Management

F1 League Management is an Excel template designed to help F1 2021 league owners track points, penalties, and other league statistics.
26 stars 3 forks source link

Avg. pos. change is inaccurate #30

Open FINDarkside opened 2 months ago

FINDarkside commented 2 months ago

I'm not exactly sure how it's calculated at the moment, but for the following data: 7557f176e25dc5ed5887cbae009c4a48 9ce4ad90c10d49a2e27f9c587bf9df8b

My Avg. pos. change is -9 according to league race statistics. I think the real value should be (1-19)/5=-3.6

Additionally my teammate has -7,4 avg position change, yet somehow the team stats show -2,8 avg for our team.

FINDarkside commented 2 months ago

Note: I've inserted the data in desktop app but the same happens in OneDrive if I open it there. I haven't tried inserting the same data to fresh web version. Feel free to close if necessary. Everything else seems to work apart from this though.

masterplane8 commented 1 month ago

I think I've found the fix for it, can you send me a copy of your sheet so I can verify you end up getting the right numbers?