#S5 Spreadsheet bug

1 messages · Page 1 of 1 (latest)

late bane
#

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.

desert aurora
#

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

late bane
late bane
#

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

late bane
#

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.

desert aurora
#

should help with your issue

late bane
# desert aurora <@252190261734670336> just made this https://github.com/VoltaicHQ/energy-calcula...

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

GitHub

A local benchmark tracker for Voltaic Season 5, built with Rust and Node.js. - Dylan-B-D/VT-S5-Benchmark-Tracker

median orbit
#

ayo rust gamer

#

🦀

late bane
# desert aurora https://beta.voltaic.gg

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

desert aurora
#

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

late bane