ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
25 October 2024Full(?) Instructions Coming Soon (maybe)
2
3
CAHSummary sheet, lots of info
4
5
ReleasesCheck off each release to add that product's cards to the Selected Deck. Duplicates between versions of the same pack will not add to the card count but duplicates with other packs (with the exception of the numbered expansions and the Red and Blue boxes) will. The current card count can be seen in the upper right corner (Column K). Highlighting is explained below.
6
Some cards in this product are optional - select them manually in the MCL sheet
7
Card list is known to be inaccurate but will still populate the deck
8
Bundle listing - product contians separate products that must be checked manually
9
No card list is available or the cards are not compatible - will not populate
10
11
MCLMaster Card List
Contains all Cards Against Humanity cards known to exist plus all unplayable cards included with them. Exceptions:
- Incompatible cards (different size, do not say "Cards Against Humanity" on one side, etc.)
- Third party cards
- Custom printed cards, even from CAH at events
- Online cards
- Multiple versions of procedurally-generated or other unique cards (only one of each type is listed)
12
Yellow highlighting in the checklist column indicates cards that are optional or had different versions included - Check (X) them manually to add them to the deck
13
Yellow highlighting in the card column indicates blank cards or procedurally generated cards. Blank cards may be filled in with the contents of your custom cards or ignored. Procedurally generated cards may be set on the PGC sheet. It may be necessary to change the formula for a PGC if multiples of the same type are needed. Or you can just enter the card in manually.
14
HoldTemporary space for marking cards to move into decks
15
Decks 1-12Space for building custom decks with whatever notation you want
16
17
MainAll cards found in any edition of the CAH base set, including conversion kits
18
MoreAll cards found in the six numbered expansions, three color boxes, and More CAH
19
PGCProcedurally Generated Card generator - requires named variables (see below)
20
PGC-DataKnown components of procedurally generated cards
21
LinesLine cards as introduced in Out of Line (not yet populated)
22
ErrorsNoted errors in the group spreadsheet (does not list all changes made here)
23
FakesCounterfeit identification guide - in work (scans still to come)
24
25
Known issues with Google Sheets
26
27
FiltersGoogle Sheets does not allow sorting and filtering on read-only files. To use the applied filters when viewing online, you will need to select Filter views from the Data menu and select Create new temporary filter view. Make sure you have all columns selected when adding filters.
28
29
FormattingSpreadsheets downloaded from Google Sheets will have all row heights set to the equivalent of a single line. You will need to autosize the row heights to get everything to display correctly.
30
31
CheckboxesGoogle Sheets does not support checkboxes. A checkbox is used to set the logic state of cell B1 on the CAH sheet to determine whether to include blank cards in card counts. To include blank cards, set cell B1 to TRUE. To exclude blank cards, set cell B1 to FALSE.
32
33
PGCsThe PGC sheet allows you to set the procedurally generated cards shown in the MCL sheet or build additional ones from the elements for each type of PGC. Google Sheets strips the named variables that make this functionality work. To fix this, you will need to download the spreadsheet and define the following Names:
34
35
NameRefers to:
36
BBBv2_1=OFFSET('PGC-Data'!$A$2,0,0,COUNTA('PGC-Data'!$A$2:'PGC-Data'!$A$101))
37
BBBv2_2=OFFSET('PGC-Data'!$B$2,0,0,COUNTA('PGC-Data'!$B$2:'PGC-Data'!$B$101))
38
BBBv2_3=OFFSET('PGC-Data'!$C$2,0,0,COUNTA('PGC-Data'!$C$2:'PGC-Data'!$C$101))
39
BBBv2_4=OFFSET('PGC-Data'!$D$2,0,0,COUNTA('PGC-Data'!$D$2:'PGC-Data'!$D$101))
40
Boks1_1=OFFSET('PGC-Data'!$E$2,0,0,COUNTA('PGC-Data'!$E$2:'PGC-Data'!$E$101))
41
Boks1_2=OFFSET('PGC-Data'!$F$2,0,0,COUNTA('PGC-Data'!$F$2:'PGC-Data'!$F$101))
42
Boks1_3=OFFSET('PGC-Data'!$G$2,0,0,COUNTA('PGC-Data'!$G$2:'PGC-Data'!$G$101))
43
Boks1_4=OFFSET('PGC-Data'!$H$2,0,0,COUNTA('PGC-Data'!$H$2:'PGC-Data'!$H$101))
44
Boks2_1=OFFSET('PGC-Data'!$I$2,0,0,COUNTA('PGC-Data'!$I$2:'PGC-Data'!$I$101))
45
Boks2_2=OFFSET('PGC-Data'!$J$2,0,0,COUNTA('PGC-Data'!$J$2:'PGC-Data'!$J$101))
46
Boks2_3=OFFSET('PGC-Data'!$K$2,0,0,COUNTA('PGC-Data'!$K$2:'PGC-Data'!$K$101))
47
Boks2_4=OFFSET('PGC-Data'!$L$2,0,0,COUNTA('PGC-Data'!$L$2:'PGC-Data'!$L$101))
48
Boks3_1=OFFSET('PGC-Data'!$M$2,0,0,COUNTA('PGC-Data'!$M$2:'PGC-Data'!$M$101))
49
Boks3_2=OFFSET('PGC-Data'!$N$2,0,0,COUNTA('PGC-Data'!$N$2:'PGC-Data'!$N$101))
50
Boks3_3=OFFSET('PGC-Data'!$O$2,0,0,COUNTA('PGC-Data'!$O$2:'PGC-Data'!$O$101))
51
Boks4_1=OFFSET('PGC-Data'!$P$2,0,0,COUNTA('PGC-Data'!$P$2:'PGC-Data'!$P$101))
52
Boks4_2=OFFSET('PGC-Data'!$Q$2,0,0,COUNTA('PGC-Data'!$Q$2:'PGC-Data'!$Q$101))
53
Boks4_3=OFFSET('PGC-Data'!$R$2,0,0,COUNTA('PGC-Data'!$R$2:'PGC-Data'!$R$101))
54
Boks5_1=OFFSET('PGC-Data'!$S$2,0,0,COUNTA('PGC-Data'!$S$2:'PGC-Data'!$S$101))
55
Boks5_2=OFFSET('PGC-Data'!$T$2,0,0,COUNTA('PGC-Data'!$T$2:'PGC-Data'!$T$101))
56
Boks5_3=OFFSET('PGC-Data'!$U$2,0,0,COUNTA('PGC-Data'!$U$2:'PGC-Data'!$U$101))
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