A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Hi! First of all, thanks for checking out and using this tracker. | Creator: | Xail#8547 | Missing 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 Creators | GAPP 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#0001 | Atroposhears | |||||||||||||||
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 | 46 | 55 | 10 | Date | Name | Note | Name | Link | Author | Name | Link | ||||||
15 | Puzzle Count | 1626 | 1465 | 245 | 10 Jan 2024 | Most Recent | Collection | https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing | BremSter | GAS V2 | https://docs.google.com/spreadsheets/d/1Ajs1VoO3bpq2fuPmJacnX4kjhy_7iSDQF5TP5hwPenI/edit?usp=sharing | |||||||
16 | # of Solves | 24,968 | 22,372 | 783 | 10 Jan 2024 | Front 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:56 | 0:03:28 | 0:20:43 | 10 Jan 2024 | GAPP | 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:18 | 1323:44:44 | 250:56:06 | 02 Mar 2022 | Mind 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.78 | 406.76 | 78.30 | 10 Jun 2022 | GAS | Added two additional settings | GAS | https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing | |||||||||
20 | 02 Mar 2022 | GAS Leak | Grouped Volumes 1-10 | GAS Leak | https://docs.google.com/spreadsheets/d/1eFc-khH4InTgSBb59i2g7-Fkp9HLMwrYQwlHs-mSJm4/edit?usp=sharing | |||||||||||||
21 | 02 Mar 2022 | GAS 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 | Ongoing | CtC Archive | Updating more puzzles. Thanks SudOX! | |||||||||||||||
24 | 3 May 2022 | Other | 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 |