CTC Catalogue

The Cracking the Cryptic Catalogue is a fan created catalogue of all puzzle content released by Cracking the Cryptic on its Youtube channel over the years.

Catalogue
The catalogue contains all kinds of data, among which video title, length, puzzle types, constraint types, host, solver, setter, source and collection information. The catalogue can be used to find information and statistics about puzzles released on the channel, and to find puzzles with any type of constraint, by any particular setter or from any particular collection.

The catalogue is maintained on a daily basis, meaning new uploads are usually catalogued at the latest 1 day after being uploaded. Asides from new content entries, all data in the catalogue is completely automated. Note that the catalogue is not optimized for mobile use.

On the catalogue sheet, new video entries are entered daily. Use this sheet for information on specific puzzles and for finding puzzles using specific filters. On the stats page, data is transformed into various statistics: Frequency of puzzle types, most appearing setters, video length and over-time development.

This catalogue was created and is being maintained by Bakpao.

Collaboration
The catalogue by default is protected from editing by visitors. However, it is open to collaboration. Those interested in helping out with maintaining the catalogue, are free to ping @bakpao#7340 in the CTC Fan Discord server, or to reach out in the channel #catalogue.

The following kinds of collaboration are possible:

• Access to the Catalogue sheets only, allowing for input of new data

• Access to the entire Catalogue, to build new grid tables, charts or other transformations of the data. No alterations of existing formulae / stats.

• Access to the entire Catalogue, to maintain or improve existing formulae or to improve spreadsheet functionality/automation in any other way.

Those interested in collaborating should write a private message in Discord detailing what kind of access you would like, how you intend to help, the extent of your spreadsheet / Apps Script / ... knowledge and how much time you plan to allocate to helping out.