Interactive Participation Tracker
We have put together our own official
Season of Giving 2022 Participation Tracker to help you stay on top of which events you have entered and received currency for.
NB: The prizes in this table purposely omit the Advent Calendar so as not to spoil the event, so you may end up with more snowflake currency than the spreadsheet advertises.
How it Works
For each item you complete simply check the box and the "Snowflakes Received" (H20) and "Chocolate Coins Received" (H21) values will update automatically.
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 obtain a physical copy:
Go to
File >
Print.
Make sure you are on a device connected to a printer.
Tip: if you follow Option 1 first then you will be able to clear the "Snowflakes Received" (H20) and "Chocolate Coins Received" (H21) 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 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 Received" (H20) and "Chocolate Coins Received" (H21) values will then update accordingly.
If you need any help with using the tracker please post in
TBT's Season of Giving - Information Centre thread and tag
@Chris.
