2018 r/Fantasy Bingo Card
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This workbook contains seven tabs:
2
3
How to Use
4
This tab. You are reading it right now!
5
6
Bingo Card
7
Here is where you will fill out your card to track your progress. Each square comes with a dropdown menu for you to select an appropriate book title.
8
9
Book Log
10
This is where you record the books that you have read. These titles and authors are what the Bingo Card uses to create the dropdown menus.
11
Optionally, to the right is an area you can use to categorize the books in your list into their possible bingo categories (useful if a book fits into multiple categories). If you use this area, books will only show up in the dropdown menu for the squares you have marked. If you do not do this, books will show up in all dropdown menus.
12
13
Visual Card
14
This is your no-hassle way to create a pretty visual bingo card full of book covers! To place a book cover in a cell, use the formula "=image("full url goes here",2). To indicate HARD MODE for a given square, use the dropdown list. To change the swag for your card, select something from the dropdown list. You can add more swag to the Card Swag sheet by typing in the name and providing a link.
15
If you wish to generate an image file for your card, follow these steps:
16
1) Select the entire visual card, which should be cells C3:M14.
17
2) File > Print (or keyboard shortcut)
18
3) In the top right corner of the print preview, change "Current Sheet" to "Current Selection"
19
4) Under "Scale", select "Fit to Page"
20
5) Click the "Next" option to proceed to printing
21
6) Select a PDF printer, which will vary by computer. Any PDF printer will work. The goal is to generate a PDF version of your bingo card.
22
7) Upload the PDF file to Imgur. It's automatically converted to an image format!
23
8) When sharing your visual bingo card through Imgur, make sure to use a direct link. You can get this by replacing the "www" in the link with "i" and adding the filetype to the end. For example: "https://imgur.com/UknVU09" becomes "https://i.imgur.com/UknVU09.jpg"
24
25
Card Swag
26
This sheet contains the optional personalization for the visual card. To add your own, simply type the name of your swag beneath the existing swag names and add a link to the image in the next cell. The optimal image size for no stretching to occur is 565 pixels wide by 42 pixels tall.
27
28
Rules
29
This is a transcription of the rules from the stickied post in /r/Fantasy, available here in its entirety:
30
https://www.reddit.com/r/Fantasy/comments/88rtlr/official_rfantasy_2018_book_bingo_challenge/
31
32
Filters
33
This is a hidden tab with formulas used to create the dropdown menus on the Bingo Card. Ignore this unless you are interested in seeing how the spreadsheet works.
34
35
36
Created by: /u/shift_shaper
37
Revision 1 by:/u/Dionysus_Eye
38
Revision 2 by:/u/CoffeeArchives
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
Loading...
 
 
 
How to Use
Book Log
Bingo Card
Filters
Visual Card
Card Swag
Rules
 
 
Main menu