Interactive Participation Tracker
We have put together our own official
The Bell Tree Fair 2022 Participation Tracker to help you stay on top of which events you have entered and received currency for.
NB: Three events—
Count Inside the Bottle, Out of the Woods, and The Wishing Well—have blank ticket quantities because they either (a) offer a varied amount of tickets or (b) it would spoil the nature of the event if we included it here. Please just enter the values in these cells yourself once you know how many tickets you have earned.
How it Works
For each item you complete simply check the box and the "Entered" (I4) and "Received" (L4) values will update automatically. You do not need to edit any other cells on the spreadsheet unless stated in the paragraph above.
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 "Entered" (I4) and "Received" (L4) 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 "Entered" (I4) and "Received" (L4) values will then update accordingly.
If you need any help with using the tracker please post in the
The Treehouse - For Your General TBT Fair Questions and tag
@Chris.
New Events Week One 
