A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | This workbook contains sixteen tabs: | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | How to Use | |||||||||||||||||||||||||
4 | This tab. You are reading it right now! | |||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||
6 | Book Log | |||||||||||||||||||||||||
7 | 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. | |||||||||||||||||||||||||
8 | 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. | |||||||||||||||||||||||||
9 | 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. | |||||||||||||||||||||||||
10 | In cells AF1 through AJ1 (the upper right) you can note potential themes for your bingo card(s). Change the text "Theme #" to the name of your theme. You can note which books fit the theme using the grid below the theme name. | |||||||||||||||||||||||||
11 | ||||||||||||||||||||||||||
12 | Bingo Card | |||||||||||||||||||||||||
13 | 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. | |||||||||||||||||||||||||
14 | In cell F23 (below the short story squares; it has a small gray triangle in it by default) you can select a theme for the card from among those entered on the Book Log. Doing so will limit your choices of books on this card to only those marked for the specific theme. To go back to full book lists, delete the theme from this cell. | |||||||||||||||||||||||||
15 | ||||||||||||||||||||||||||
16 | Extra Bingo Cards | |||||||||||||||||||||||||
17 | If you would like to track multiple Bingo Cards using the same books, you can do so by duplicating the existing card and changing your book selections. After duplicating a bingo card or changing the name of a bingo card, you will need to come back here and check or uncheck the checkbox below (It doesn't matter whether box is checked or unchecked, just that its status changes). | |||||||||||||||||||||||||
18 | To duplicate a sheet, click the arrow next to the sheet name and choose Duplicate from the list of options. If you add a sheet to this workbook other than a bingo card, you will also need to add its name to the exclusions list in Column O of the Data tab (currently hidden). | |||||||||||||||||||||||||
19 | Check or uncheck this box to refresh data after adding, deleting, or renaming Bingo Cards: | |||||||||||||||||||||||||
20 | ||||||||||||||||||||||||||
21 | Visual Card, Visual Card (Darkmode) | |||||||||||||||||||||||||
22 | 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. If you are tracking multiple bingo cards, you may choose which to display on by choosing its tab name from the dropdown below the picture of Gandalf Snoo in the upper left. | |||||||||||||||||||||||||
23 | My favorite way to find cover images is to: | |||||||||||||||||||||||||
24 | 1) Locate the book on Goodreads | |||||||||||||||||||||||||
25 | 2) Hover over its cover picture | |||||||||||||||||||||||||
26 | 3) Right-click the image and choose 'Copy Image Address'. This is the link you will paste into the Book Log. | |||||||||||||||||||||||||
27 | If you wish to generate an image file of your card, follow these steps: | |||||||||||||||||||||||||
28 | 1) Make sure you are on the Visual Card tab. | |||||||||||||||||||||||||
29 | 2) File > Print (or keyboard shortcut) | |||||||||||||||||||||||||
30 | 3) Make sure to select Portrait layout, not Landscape. | |||||||||||||||||||||||||
31 | 4) Under 'Scale', select 'Fit to Page' | |||||||||||||||||||||||||
32 | 5) Click the 'Next' option to proceed to printing | |||||||||||||||||||||||||
33 | 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. | |||||||||||||||||||||||||
34 | 7) Convert the PDF to a JPG/PNG image. Adobe offers a free tool to do this, available at https://www.adobe.com/acrobat/online/pdf-to-jpg.html | |||||||||||||||||||||||||
35 | 8) Upload the image to a hosting site or include it in your reddit post as desired. | |||||||||||||||||||||||||
36 | ||||||||||||||||||||||||||
37 | Rules | |||||||||||||||||||||||||
38 | This is a transcription of the rules from the stickied post in r/Fantasy, available here in its entirety: | |||||||||||||||||||||||||
39 | https://www.reddit.com/r/Fantasy/comments/1bt4iqf/official_rfantasy_2024_book_bingo_challenge/ | |||||||||||||||||||||||||
40 | ||||||||||||||||||||||||||
41 | Data, Other Hidden Tabs | |||||||||||||||||||||||||
42 | 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. | |||||||||||||||||||||||||
43 | ||||||||||||||||||||||||||
44 | ||||||||||||||||||||||||||
45 | Created by: | /u/shift_shaper | ||||||||||||||||||||||||
46 | Visual Card and Instructions Adapted from: | /u/CoffeeArchives | ||||||||||||||||||||||||
47 | Banner art by: | Mariacristina Gugliotta | ||||||||||||||||||||||||
48 | Hardmode Scrollwork by: | Vecteezy.com | ||||||||||||||||||||||||
49 | ||||||||||||||||||||||||||
50 | ||||||||||||||||||||||||||
51 | ||||||||||||||||||||||||||
52 | ||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||
54 | ||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 |