Posted by (2024) February Currency Spreadsheet

Terrinthia [G1] (#97101)

Famous
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)

Special Pants (#111603)

Total Chad
View Forum Posts


Posted on
2023-01-31 19:54:42
tysm for this! i love doing statistics and keeping track of things, this might enable me to record my own silly little stats for this event <3



Hrt Icon 0 players like this post! Like?

Terrinthia [G1] (#97101)

Famous
View Forum Posts


Posted on
2023-01-31 19:57:12
Rad! Hope you get to draw some awesome conclusions :D



Hrt Icon 0 players like this post! Like?

Kit in a Box
~⚙️~ (#61637)


View Forum Posts


Posted on
2023-01-31 21:40:06
Thank you for making this! :D



Hrt Icon 0 players like this post! Like?

🌌DarkSpaceNova
G1 3rosette (#334558)

Gorgeous
View Forum Posts


Posted on
2023-02-01 05:58:34
Awesome! TYSM!! ^^



Hrt Icon 0 players like this post! Like?

WIZZI 2 (#239648)

Amiable
View Forum Posts


Posted on
2023-02-01 08:34:51
The spreadsheet doesn't work for me ; - ;

All the calculations are in the negative and have scientific notations for how large they are : ' )




Hrt Icon 0 players like this post! Like?

Terrinthia [G1] (#97101)

Famous
View Forum Posts


Posted on
2023-02-01 08:36:57
Yeah, I can't get it to ignore blank cells, so it's gonna be negative in places until the whole month is finished unfortunately. You'll be able to see the daily increases as each day passes, but the average won't be fully fleshed out until all the days have data in them.



Hrt Icon 0 players like this post! Like?

Terrinthia [G1] (#97101)

Famous
View Forum Posts


Posted on
2023-02-03 17:21:22
Small tip if you guys care about how certain items used may affect your overall gains for each day, I've been recording the items I use each day by right clicking on the cell I want to add the information to, and selecting 'Insert note'. I personally like to write in bullet point format, which is essentially:
Used x1 Roasted Lamb
Used 1 Energy Boost
Leveled up once
etc.

It reads a little clearer to me than listing them with commas separating each item :) The cells I'm choosing to add these notes to is the Daily Increase columns, since it didn't seem to really fit in any others!

I also add notes on the Date column for days I have off vs days I have work (I have less days off than working days, so I just add notes to the OFF days as it's easier to decipher at a glance) in case any of you have significant differences in the amount of time you can spend on the game depending on the day ^^



Hrt Icon 0 players like this post! Like?


Edited on 01/03/23 @ 09:24:28 by Terrinthia [G1 Daedal] (#97101)

Terrinthia [G1] (#97101)

Famous
View Forum Posts


Posted on
2023-03-01 09:25:31
Did the spreadsheet work for everyone who used it? The numbers and calculations on mine look accurate now that the month is over, but if anyone has problems I'd love to know!



Hrt Icon 0 players like this post! Like?

🌻🌷☀️Celean
a🇹🇳🇵🇸
(#374387)

Impeccable
View Forum Posts


Posted on
2023-03-01 09:27:32
it did! tysm



Hrt Icon 0 players like this post! Like?

Arret Rea (#138617)

Interstellar
View Forum Posts


Posted on
2023-03-01 09:36:32
It did- thank you for the awesome spreadsheet!



Hrt Icon 0 players like this post! Like?

Special Pants (#111603)

Total Chad
View Forum Posts


Posted on
2023-03-01 11:21:49
worked perfect!



Hrt Icon 0 players like this post! Like?

Terrinthia [G1] (#97101)

Famous
View Forum Posts


Posted on
2023-03-01 11:29:59
Good to know! :D



Hrt Icon 0 players like this post! Like?

Kit in a Box
~⚙️~ (#61637)


View Forum Posts


Posted on
2023-03-01 13:03:19
Worked great, thanks again!



Hrt Icon 0 players like this post! Like?

Sunny [it/its] (#275256)

Total Chad
View Forum Posts


Posted on
2023-03-08 22:40:51
i had like 350 HS that were unaccounted for by the end. probably a mix of not recording right away and then going "oh shoot" and guessing, and maybe i bought a few more things and forgot to record them. or i added wrong.



Hrt Icon 0 players like this post! Like?

Jac 🍡 FROZEN! (#239481)

Heavenly
View Forum Posts


Posted on
2024-01-01 01:33:32
you're a literal lifesaver tysm<3



Hrt Icon 0 players like this post! Like?







Memory Used: 624.23 KB - Queries: 0 - Query Time: 0.00000 - Total Time: 0.00375s