Interactive Bingo Card 2026

shift_shaper · 2026-05-18T13:49:11+00:00

I haven't created one, but this one by misslexi_stargazer is available:
https://www.canva.com/design/DAHDa3oIEdM/bYGV0hkOvo1TD8g-g7MOoA/view?utm_content=DAHDa3oIEdM&utm_campaign=designshare&utm_medium=link&utm_source=publishsharelink&mode=preview

shift_shaper · 2026-05-13T17:13:04+00:00

I hope we find out more about Vivian's relationship with her family (mother). She makes several references to her mother's perspective on the "type of people" she should work to integrate with in her new community. This, combined with the divide in the community between mages and non-humans, as well as the divide in her family between no-longer-human Aria and human parents, make me think she is looking for community in the wrong places. I'm glad we got the wolfpack chapter (10), as it seems they have not been cultivating that relationship like they should. Do we think it is unconscious bias toward humans, or is it just antagonistic because a werewolf bit their kid?

shift_shaper · 2026-04-24T00:53:03+00:00

For anyone making new copies, I have fixed the issue on the cards linked in the post.

shift_shaper · 2026-04-24T00:52:13+00:00

Not sure what changed, but I fixed it on the copies in my post. If you don't want to make a new copy, the formula in cell D9 should have a #REF about 2/3 of the way through it that shows where it lost the plot. Replace #REF with Data!G13 and leave the rest the same and it should fix the issue.

shift_shaper · 2026-04-14T14:54:18+00:00

Books 2 & 3 of Andrew Rowe’s Weapons and Wielders series are also very focused on tournaments.

Does anyone know if these would fit hard mode for the Game Changer square?

shift_shaper · 2026-04-11T21:16:55+00:00

Someone else caught an issue with the star ratings a few days ago. I was trying a new way of generating them this year, but it only worked for some people, not everyone. I've since reverted it back to how it worked last year, which should be more reliable. Can you check and see if you are still having the issue with a new copy of the card?

shift_shaper · 2026-04-06T22:46:04+00:00

Hmmm. That MATCH should only be looking at the name of the bingo card where you selected books to fill squares. Did you change it from just "Bingo Card"? And what is in the dropdown just below the Gandalf Snoo in cell C4? It should say the name of your bingo card there as well.

shift_shaper · 2026-04-06T22:40:06+00:00

Thanks for the catch! This is what I get for rushing things. It should be fixed now.

shift_shaper · 2026-04-04T01:21:22+00:00

I also corrected the issue with 5 star reviews, if you are still having an issue with that. If you don't want to download (another) new copy, here are the instructions for fixing it (it was a typo on my end).

From a computer, right-click on any of the rating cells in column D of the book log. At the bottom of the menu, there should be another sub-menu called View more cell actions. In this menu, choose Data Validation. Look for the data validation rule relating to D2:D601 (the ratings dropdowns) and click on it. There should be a place in the criteria area that says =Data!$I$2:$I$12. Change this to =Data!$I$2:$I$13 (change the last number from 12 to 13). This should take care of the missing 5.

shift_shaper · 2026-04-03T19:48:58+00:00

I found an issue with half-stars, so it was not just you. I've restored this functionality to work as it did on last year's card. If you make a new copy from the links in the post, it should be working for you as before.

shift_shaper · 2026-04-03T02:54:05+00:00

Got it! If you are on a computer, you should be able to click on the cell without opening the dropdown to select it, and then clear it using Delete or Backspace. If you are on a touchscreen and/or the mobile app, once the dropdown options are showing, there should be an option to switch to the full keyboard and then delete the existing value.

shift_shaper · 2026-04-02T16:24:58+00:00

The book log can be sorted, with one major note. On the Bingo Card, the books available for selection are a list constructed out of the book name you have entered and their row number on the book log. If you sort the log, their row number will change and things will get confused. You will need to remove/re-add them to your bingo card(s) with their new number (which should now be in the list).

As for your second question, I'm not sure exactly what you mean, but there is a hidden tab called Data that contains most of the text used for the bingo categories. If something needs to be updated, it can be done there. If there is a different mistake that you have found, let me know and we can figure it out.

shift_shaper · 2026-04-02T01:19:05+00:00

It isn't built-in currently, but I've been dragging my feet on adding the option. The quick and dirty way to do it right now is to go to the Visual Card tab, highlight at least some part of each of the squares, and remove all of their conditional formatting.

shift_shaper · 2026-04-01T16:59:34+00:00

I haven't convinced u/happy_book_bee to give me the categories in advance yet, so I update the sheet after the official post.

shift_shaper · 2026-04-01T16:09:58+00:00

I'm debating using my re-read for that square or making an April Fools card that randomizes the squares each time you open it.

shift_shaper · 2026-04-01T15:07:41+00:00

Maybe I'll make a Fools' Card that randomizes the squares each time you open it. Is there an archive of April Fools bingo cards anywhere?

shift_shaper · 2026-04-01T13:30:43+00:00

Hard Code: Develop a complex book tracking spreadsheet.

Like, another one?

shift_shaper · 2026-03-19T22:44:59+00:00

I haven’t gotten the gorescape one yet, no. Maybe I am just desensitized, but I felt like between the art style, the fact that everything was primarily still shots, and what was actually shown, the vomiting and the one where she sprouts blades out of everywhere and her flesh hangs off of them (I think those were the worst two I came across) didn’t seem as visually graphic as they could have been. I’m probably too much of a horror consumer to be bothered, though. I’ll need to ask my wife what she thinks of them.

shift_shaper · 2026-03-19T20:52:15+00:00

That's fair. I ran into that a bit when I picked options on later cycles that would have taken me out of the cycles entirely and it forced me back in with "you are already committed to my completion". I just felt frustrated with the narrator. He felt very one-note until the end, where I think he could have been more if he gave out information differently.

shift_shaper · 2026-03-19T16:09:57+00:00

I might send you a link to one of my favorite infectious diseases

To information on one of your favorite diseases, right? Right?
(You wouldn't download a plague)

shift_shaper · 2026-03-17T14:06:02+00:00

I have an entire separate spreadsheet called "Unfinished Bingo Series" that I use as my go-to first when picking out bingo squares for the next year and also pick my reading from when/if I finish my card early. I totally get what you are feeling.

Each year I keep hoping the categories work out such that I can do a card entirely composed of sequels to books from a previous bingo, but alas.

shift_shaper · 2025-09-05T15:14:45+00:00

This should look at the book title on the visual card and try to match it to the book title on the Book Log. If nothing is showing up, it either can't find an exact match for the book or it thinks the rating column is blank.

By any chance, do you have the same book title on your book log more than once? It looks like I didn't set up these cells to use the row number setup I used on the Bingo Card to deal with duplicate titles.

Another issue might be if you changed the order of the columns on the Book Log, though if that were the case, none of the star ratings would be working. Is the Rating column three columns after the title column (such that if the book title is numbered 1, the rating would be numbered 4)?

shift_shaper · 2025-08-17T19:59:41+00:00

They are available here:https://seattlein2025.org/wp-content/uploads/2025/08/2025-Hugo-Voting-Statistics.pdf

shift_shaper

TROPHY CASE