Unless I'm mistaken, shouldn't my static energy be 882 not 875, or am I messing up the calculation?
I was making an app so I don't need to manually update all my scores, and using a linear interpolation gave the energy I expect for everything apart from advanced static, and I'm not sure why.
#S5 Spreadsheet bug
1 messages · Page 1 of 1 (latest)
Looks like you’re using the wrong calculation method. It takes some time to deconstruct the sheets formula, understand and rewrite it properly. I can share some pieces later
Or you can just wait for the kvks support on the app
i can wait, its just weird that all my novice and intermediate energy values line up
actually looking at some more stuff i think it is an issue with my calculation, it looks like energy below the minimum rank does not increase linearly
i think i figured it out, there is essentially a hidden rank below the lowest rank in each difficulty level that is used in the energy calculation.
@late bane just made this
https://github.com/VoltaicHQ/energy-calculation
should help with your issue
Thanks, I already managed to get it to work, but I the code is very spaghetti, so I will need to refactor everything at some point when i have some more time, so this will still be useful then. https://github.com/Dylan-B-D/VT-S5-Benchmark-Tracker
this is sick 🔥
is it intentional that the energy only goes 99 above the max rank instead of 100?
the only feedback i would have for this atm is that the switching between novice/intermediate/advanced is quite slow due to the kovaaks api, and it seems to re-fetch every time i switch
is intentional yes
is quite slow
yes
seems to re-fetch
yes but i don't wanna block switching while loading scores, will remove that later
btw @late bane lmk if you are familiar with ts/vue/nuxt and want to collaborate
im drowning in backlog
ive only really used react and typescript, but i like learning new stuff. i have a lot of coursework and some exams coming up, but i should have a lot more free in 2-3 weeks