ABCDEFGHIJKLMNOPQR
1
Hi! First of all, thanks for checking out and using this tracker.
​Creator:Xail#8547Missing one? Right click the relevant tab from the original sheet, press duplicate, and add it in! (You'll need to copy the data sheet too)
Several puzzles, on the same day, sharing a time?
2
While I don't benefit financially from creating and maintaining these,
Sadly, I can't auto format these (although I am investigating a way to do it!)
3
I really enjoy that I'm able to help out the community through this.
​Inspired by:BremSter#0200
Either, enter in just one time for all the puzzles (in just one of the time slots). Or, merge the relevant hat/animal
4
cells. See your GAS or GAPP sheet for an example. ( Select the cells, press Format, Merge, Merge All)
5
Want to provide your time data? DM Xail#8547 on
​Additional thanks to the below people
Alternatively, you can copy the full tracker, and copy your data across. This works for the checkboxes too!
The most recent GAS and GAPP formula to apply to the merged cell will be available below. Just remove the `.
6
Discord, and I will give you the easy steps to start contributing!
GAS CreatorsGAPP Creators
For older puzzles, either re-copy the tracker, or modify the formula for your purposes
7
MikoKisai#9531
Quenouille#3663
​GAS (June 11):
`=IFS(AND(ISBLANK($I396), ISBLANK($I397), ISBLANK($I398), ISBLANK($I399)),"",ISBLANK('GAS Data Import (Do Not Touch)'!$H392),"",SUM($I396:$I399)<='GAS Data Import (Do Not Touch)'!$H392,IF($R$1,"🎩🥳","2 hats"),SUM($I396:$I399)<='GAS Data Import (Do Not Touch)'!$I392,IF($R$1,"🥳","1 hat"),SUM($I396:$I399)>'GAS Data Import (Do Not Touch)'!$I392,IF($R$1,"🦕","dinosaur"))
8
Too many trackers that you aren't interested in? Just right click the
SudOX#0011
DreamLibrarian#0311
​GAPP (Dec 25):
`=IFS(AND(ISBLANK($H65), ISBLANK($H66), ISBLANK($H67), ISBLANK($H68), ISBLANK($H69)),"",ISBLANK('GAPP Data Import (Do Not Touch)'!$G61),"",SUM($H65:$H69)<='GAPP Data Import (Do Not Touch)'!$G61,"Sloth",SUM($H65:$H69)<='GAPP Data Import (Do Not Touch)'!$H61,"Crab",SUM($H65:$H69)>'GAPP Data Import (Do Not Touch)'!$H61,"Bird")
9
tab for that tracker, and press "hide sheet".
Katoa#0001Atroposhears
10
All contributors to the time data
11
And many others!
12
​Statistics
13
​GAS​GAPP​GAS Leak
​Most Recent Update
​Available Sheets:
​Other Links:
14
Contributors​​465510Date​​Name​​Note​​Name​​Link​​Author​​Name​​Link​​
15
Puzzle Count​​1626146524510 Jan 2024Most Recent​​Collection
https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing
BremSterGAS V2
https://docs.google.com/spreadsheets/d/1Ajs1VoO3bpq2fuPmJacnX4kjhy_7iSDQF5TP5hwPenI/edit?usp=sharing
16
# of Solves​​24,96822,37278310 Jan 2024Front Page
Added MikoKisai's Guest Puzzle Series Tracker
GAPP
https://docs.google.com/spreadsheets/d/1eBsUsmyhfWVsyUs3HVsGNsstqnnFszGvVhob-qOqaJs/edit?usp=sharing
Bakpao
CTC Archive Stats
https://docs.google.com/spreadsheets/d/1E05BphmqJNFKIqmfUA-aWOO4WLMfIhJkI0JqcOVDGV4/edit?usp=sharing
17
Average Time​​0:07:560:03:280:20:4310 Jan 2024GAPP
Fixed puzzle counting formula for >9 puzzle days
Mind The GAPP
https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing
SudOX
GAPP Genres Puzz.Link search
https://tinyurl.com/3acjkjbx
18
Total Time​​3589:22:181323:44:44250:56:0602 Mar 2022Mind The GAPP
Added hyperlink for puzzles to original post
GAPP Bonus Otters
https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing
MikoKisai
CTC Guest Puzzle Series Tracker
https://docs.google.com/spreadsheets/d/17IXJ7ThDNdHR9IgURzyigs_j-bV3dfTXYMYzeHjNXCc/edit#gid=0
19
Average Puzzles Solved​​
542.78406.7678.3010 Jun 2022GAS
Added two additional settings
GAS
https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing
20
02 Mar 2022GAS Leak
Grouped Volumes 1-10
GAS Leak
https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing
21
02 Mar 2022GAS Bonus Hats
Updated links for Sudoku-GP Hats
GAS Bonus Hats
https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing
22
9 May 2022
GAPP Bonus Otters
Newly created tracker!
CtC Archive
https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing
23
OngoingCtC Archive
Updating more puzzles. Thanks SudOX!
24
3 May 2022Other
Adding people to the team to help when I'm away
25
26
​Important Updates
27
GAS
June 7 puzzles have no time; bonus hat attached for completing all three
28
GAPP-
29
GAS Leak-
30
Mind The GAPP-
31
Bonus Hat List-
32
Bonus Otter List-
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100