|
|
---|---|
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) ![]() 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 |
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 ![]() |