laenavesse (
laenavesse) wrote in
efryndiel2021-04-27 07:44 pm
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png)
Entry tags:
[ code ] thread tracker: avalon reward points calculator and form generator
With this automated script, we can go from this:

To this!


This particular tracker is designed for
![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png)
Credit goes to
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png)
To save the spreadsheet, Make a Copy of the spreadsheet of your choice for your own use: Default (2021) | 2020
It's already "pre-filled" with random data so you can see how it works. You can even use just one sheet for all your years instead of separating them out.
I have included detailed instructions on how to do practically everything you could possibly do with the code with minimum risk. But if you have any questions or need help with modifications, just comment and I'll take a poke, even customize it for you if possible. However, I am not a professional, so my own abilities are limited. Otherwise, this is mostly working with the spreadsheet itself, so there's a lot of freedom to work with it.