Using a second google sheet to pull the data from the 1st
Using a second google sheet to pull the data from the 1st allows us to apply functions on it to give more granular control over it, for example:
- Multiply their stats by their current user level
- Multiply stats which are more critical to growing the community
- Make a final column which works out their user score this month as a percentage of the total user points accumulated this month. This is important as there is a set amount of tokens released monthly and divided equally among users based on their contributions.