Snowflake Tracker

Chris

Staff
Moderator
Senior Moderator
Joined
Jun 11, 2013
Posts
22,477
Bells
763
Eggs
1
Island
Vylbrand
Fishbowl Easter Egg
Seashore Easter Egg
Mt. Fuji Easter Egg
Starry Night Easter Egg
Blue Pikmin Easter Egg
Here is your official snowflake tracker for TBT’s Season of Giving. With this interactive spreadsheet you can conveniently keep track of when new event rounds are due to launch, each activity you have completed, and how many snowflakes you will receive for your efforts. This should help you to plan your time and spending accordingly and minimise your chances of missing out on any precious snowflakes!


Snowflake Tracker Preview.png

Please note that in order to avoid spoilers this spreadsheet does not record the amount of snowflakes received through the Advent Calendar.

How it Works


For each item you complete simply check the box and the "Snowflakes Entered For" and "Snowflakes Received" values will update automatically. You do not need to edit any other cells on the spreadsheet. However, if you do wish to record notes we have included a designated space for you to do so.

onlinever110.png

How to Access


You can access the spreadsheet by clicking here. When you first open the file you will see that you are unable to edit it. This is because the version you are looking at is intended as a blank template. You will first need to make a copy of the file before you are able to use it. The first option requires you to have a Google account, and is the option we would recommend, but options two and three do not require having a Google account.


(1) How to make a copy on your own Google Drive:


Go to File > Make a copy.

This will then create a copy of the whole spreadsheet on your own Google Drive that you will be able to edit yourself.


(2) How to print a physical copy:


Go to File > Print.

Tip: if you follow Option 1 first then you will be able to clear the "Snowflakes Entered For" and "Snowflakes Received" values in the spreadsheet before printing. That way you could fill in these fields yourself with a pencil. If you only care about having something you can physically tick off then you can disregard this advice.


(3) How to download a copy to your device:


Go to File > Download > Microsoft Excel (.xlsx).

We do not recommend this option because it is less visually appealing and requires a little more work on your end. However, if you still wish to do this then we would recommend downloading the Microsoft Excel (.xlsx) file. This file format has been tested in both Microsoft Excel and Apple Numbers and this spreadsheet's formulae are confirmed to be working as intended in both of these programmes.

When you open up the file in Excel or Numbers you will see that all of the checkboxes have been replaced with the word “FALSE”. This is not an error. To mark off the activity you will need to select the cell, delete the word "FALSE", type in “TRUE”, and then hit enter. The 'Snowflakes Entered For' and 'Snowflakes Received' values will then update accordingly.


excelver100.png




Hopefully this will help you all to stay on top of everything we have to offer in TBT's Season of Giving! 🎄
If you have any questions or run into problems feel free to ask below.
 
Thank you so very much for making this! I definitely plan on putting it to good use.
 
Not possible on a mobile and I don't understand any of it. LOL
 
Last edited:
Looks like there's a typo for the Ugly Christmas Signature. You get 10 snowflakes for that event
That's actually an error in the event thread; it is worth 30 snowflakes! I'll make sure this is corrected over there if it hasn't been already. :)

Not possible on a mobile and I don't understand any of it. LOL
The spreadsheet is compatible with mobile, it's just a little trickier to use!
 
Why does the 12 days of Christmas start on the 13th? I thought the first day was the 14th?
The entry period for that day's raffle begins at 7pm the day before. 🎅

If people think it would be easier to follow if the date the drawing takes place, rather than the date you can first purchase a ticket, is listed then I can update it to reflect this.

edit: done!
 
Last edited:
The entry period for that day's raffle begins at 7pm the day before. 🎅

If people think it would be easier to follow if the date the drawing takes place, rather than the date you can first purchase a ticket, is listed then I can update it to reflect this.

edit: done!
Ahh that makes sense! I was just confused because timezones! Also the ticket said 14th, so I thought I had missed one!
 
Thank you very much, this is super useful and i love how organized and easy it is to follow ☃ 💙
 
The Winter holidays are some of my favourite of the entire year, and the events look so fun! Thanks staff for putting this all together 😊

Edit: I definitely posted this in the wrong thread 😹
 
So useful!
But I'm already wondering how some people have 4 snowflakes already? I just have the two from the Calender haha. 🤯
 
Did something happen to the snowflakes ? there are so many ❄ :love:. May i start buying gifts for pp ? pretty please💙
 
Back
Top