ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This workbook contains nine tabs:
2
3
How to Use
4
This tab. You are reading it right now!
5
6
Visual Card, Visual Card (Darkmode)
7
This is your no-hassle way to create a pretty visual bingo card full of book covers! To add a book cover, simply place a direct link to an image of the cover in the 'Book Cover' column on the Book Log tab. You can choose only one cover at a time for the short stories. There is a drop down for this square on the Bingo Card tab just like the others. Pick the story you would like to showcase and the sheet will do the rest. If you enjoy the darkmode verision of the visual card, thank my wife. It was her request.
8
My favorite way to find cover images is to:
9
1) Locate the book on Goodreads
10
2) Hover over its cover picture
11
3) Click 'Enlarge Cover'
12
4) Right-click the image and choose 'Copy Image Address'. This is the link you will paste into the Book Log.
13
If you wish to generate an image file of your card, follow these steps:
14
1) Make sure you are on the Visual Card tab.
15
2) File > Print (or keyboard shortcut)
16
3) Make sure to select Portrait layout, not Landscape.
17
4) Under 'Scale', select 'Fit to Page'
18
5) Click the 'Next' option to proceed to printing
19
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.
20
7) Upload the PDF file to Imgur. It's automatically converted to an image format!
21
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://www.imgur.com/UknVU09" becomes "https://i.imgur.com/UknVU09.jpg"
22
23
Bingo Card
24
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.
25
26
Book Log
27
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.
28
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.
29
In the dropdown area, there is an option to track whether you meet the hard mode requirements for a specific category with a book. Select 'h' instead of 'x' to count a book toward hard mode.
30
31
Rules
32
This is a transcription of the rules from the stickied post in /r/Fantasy, available here in its entirety:
33
https://www.reddit.com/r/Fantasy/comments/mhz2tt/official_rfantasy_2021_book_bingo_challenge/
34
35
Data, ColorMap, Lists
36
These are hidden tabs with formulas used to create and automate the Bingo Cards. Ignore this unless you are interested in seeing how the spreadsheet works. Nearly all of the year-specific information can be updated directly on the Data tab, with the exception of the year in the Visual Card titles and the hard mode notes in the header of the Book Log tab.
37
38
39
Created by: /u/shift_shaper
40
Visual Card and Instructions Adapted from:
/u/CoffeeArchives
41
Banner art by:
Mariacristina Gugliotta
42
Hardmode Scrollwork by:Vecteezy.com
43
44
45
46
47
48
49
50