| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||
2 | Welcome to the Cracking the Cryptic Catalogue! | ||||||||||
3 | |||||||||||
4 | This is a fan-created catalogue of all video content released by Cracking the Cryptic on its Youtube channel over the years. | ||||||||||
5 | |||||||||||
6 | It contains all kinds of data, including video title, length, puzzle types, constraint types, host, puzzle title, setter, source and collection. | ||||||||||
7 | Use it to find information and statistics about your favourite puzzles, and to find puzzles you haven’t tried yet with your favourite constraint type, by your favourite setter or from your favourite collection. | ||||||||||
8 | Asides from new content entries, all data in the catalogue is completely automated. Note that the catalogue is not optimized for mobile use. | ||||||||||
9 | |||||||||||
10 | On the Catalogue sheet, new video entries are entered on a nearly daily basis. | ||||||||||
11 | On the Stats sheet, data is transformed into various statistics: frequency of puzzle types, most appearing setters, video length, over-time development etc. | ||||||||||
12 | Please read the FAQ for any questions about the catalogue and visit the Notes and Definitions sheets to get acquainted with information on how data is entered and terminology used. | ||||||||||
13 | This catalogue was created by bakpao and is being maintained by Vebby. Feel free to reach out on Discord (Vebby#2134) or email (vebbyyyy@gmail.com) for any queries, suggestions or corrections. | ||||||||||
14 | |||||||||||
15 | Updates | ||||||||||
16 | 22 August 2023: • CTC Catalogue data filtering app available at: https://ctc-catalogue.com/. Thanks Mike! | ||||||||||
17 | 2 December 2022: • Personal catalogue solve tracker available; check FAQ sheet for details. Thanks 'J.C. It's'! | ||||||||||
18 | 1 December 2022: • Added timestamps to YT links of videos with extra puzzles. | ||||||||||
19 | 15-23 November 2022: • bakpao handed over editorial duties to Vebby. • Reversed row order of the Catalogue sheet with newest entries appearing on top. Users can retrieve the old-on-top order by sorting through the new 'Sr. No.' column. • Increased row size of the Catalogue sheet to a comfortable view allowing more data to be seen. • Removed Latest Content box from Landing sheet. • Co-setter names are now also displayed in the 'Setter' column of the Catalogue sheet. • New date format to avoid confusion between UK/US formats. • Added 'GAS/GAPP Date' column in the Catalogue sheet. • Merged 'Nature' and 'Constraints' columns and re-ordered some columns in the Catalogue sheet. • Several content and aesthetic updates to the Stats sheet. | ||||||||||
20 | 31 May 2022: • Some modifications to the Catalogue sheet: 'Puzzle Title' column has been added; 'Collection' column has been moved to the end. | ||||||||||
21 | 30 May 2020: • Spreadsheet is now accessible for everyone! | ||||||||||
22 | |||||||||||
23 | Connect with Cracking the Cryptic: | ||||||||||
24 |  | Youtube | |||||||||
25 |  | ||||||||||
26 |  | Patreon | |||||||||
27 |  | ||||||||||
28 |  | ||||||||||
29 |  | CTC Fan Discord | |||||||||
30 | |||||||||||