Posted by (2024) February Currency Spreadsheet

Terrinthia [G1] (#97101)


View Forum Posts


Posted on
2023-01-31 12:18:18
I made a spreadsheet on Google Sheets that y'all can copy and use for your own tracking purposes if you're curious about how much you earn per day. It also provides a total for the whole month! ^^

To edit the spreadsheet, you'll have to make a copy. On PC, click "File" at the top left corner, and then click the 4th option "Make a copy". You are free to make any changes, stylistic or otherwise, that you want to your spreadsheet at that point!

It's very easy to use; simply input the amount of HS you have in the "Amount at Rollover" column when you roll your account over for each day. For the case of February 29, since there's no day after, just put in the amount you have at the end of the day (where it is labeled on the left) when you're done doing all the event activities. Remember to log the total amount of any purchases you make under the "Purchases" column and the spreadsheet will adjust its values as necessary.

There are columns for your main account data as well as your side account! Leave the side account blank if you only use one account. I color-coded the columns to make it easier to see the distinction, so hopefully that helps!

The link is here: LINK

Currently the functionalities include:
- Tracks the total HS gained per day
- Calculates the average amount gained over the course of the whole month
- Totals the amount gained in the entire month
- Plus a fun little bar chart to visually see the amount gained each day :)

I'm not a spreadsheet expert so there's probably something suboptimal about it, lol, but it seemed to work when I inputted fake data!

The averages and daily gain WILL be wrong until the entire month is finished and every cell has data, since I can't get it to ignore blank cells. Stupid monkey brain can't comprehend the solution to that so we are ignoring the issue x)



Hrt Icon 3 players like this post! Like?

Edited on 20/12/23 @ 12:45:27 by Terrinthia [G1 Shreds] (#97101)

vertigoat 🦬 |
19BO outlaw (#114297)


View Forum Posts


Posted on
2024-02-01 16:50:50
marking for later! <3 thanks



Hrt Icon 0 players like this post! Like?

Terrinthia [G1] (#97101)


View Forum Posts


Posted on
2024-02-07 17:44:00
It has come to my attention that two cells (at least what I noticed) are incorrect. Sorry guys! Didn't realize it at the time since they were blank, haha.

To fix it, you can either make another copy of the now-updated spreadsheet and re-input your values as they have been recorded currently, or you can edit the cell formulas directly (copy and paste the following, fully replacing what is currently in these two cells):

Cell G29 formula:
=C30-C29+E29

Cell G30 formula:
=C31-C30+E30



Hrt Icon 0 players like this post! Like?







Memory Used: 545.90 KB - Queries: 2 - Query Time: 0.00047 - Total Time: 0.00403s