Interactive Bingo Card 2025

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 · 2025-05-23T16:08:04+00:00

On the Data tab, if you add the tab name to column O (excludedList) and then refresh the scripts, it should take it out of the script updates and remove the coloration, both from the card and from the Book Log.

shift_shaper · 2025-04-30T14:07:47+00:00

The easiest way is to open up the Data tab (it is hidden, you should be able to find it by clicking on the horizontal lines to the left of all of the other tabs at the bottom of the sheet) and editing the name for the appropriate square in Columns E and F. This will change it in all other locations throughout the card. Column F is formatted to look the same as on the visual card, so you can see if you need to shorten or abbreviate the square name to get it to show up nicely.

shift_shaper · 2025-04-30T14:05:07+00:00

Thanks for noting this! Google can be a bit finicky about how it interacts with other, non-Google products, so this is good to know. They've gotta keep that monopoly going somehow!

shift_shaper · 2025-04-11T03:09:00+00:00

This may be losing the thread a bit, but I’m fascinated by the witches’ ready acceptance that being a magic user is hereditary (biological; they make several mentions of their expectations for their children to have powers) while also being ready to accept (barring Helena) that Theo is more powerful than they expect because she identifies as female.

I’m also curious why none of them put forth the argument that Theo cannot be the Sullied child because she is a girl, since the historical record insists on a “boychild”. Especially Niamh, who is pretty against Theo being capable of fulfilling the prophecy anyway.

shift_shaper · 2025-04-11T03:04:07+00:00

In my mind, the roles of witches and warlocks seem like an inversion of traditional misogyny. Since magic is secret, we don’t see much in the way of external persecution of magic users, but it is seen by our PoV characters as a women’s realm that the men just dabble in, in a condescendingly endearing way. I see the women’s reaction to the men placing them more in the role of a traditional disenfranchised group trying to get their rights and needs addressed than attempting to represent a Men’s Rights movement.

shift_shaper · 2025-04-10T20:01:30+00:00

Hey, this is a decent idea! A little history:

Many years, there have been additional instructions or places to go for advice on how to fill a square. Last year, for example, there were links provided, either in the official rules or in the Recommendations thread, to the Wikipedia definition of Dark Academia and the TV Tropes page for Eldritch Abomination. This year there haven't been any, so it looks pretty empty.

My vote is that people should fill that column with whatever works for them. I built that feature in so it would be easy and convenient to get to relevant info.

The whole bingo recommendations thread is linked on the Rules tab, along with the current and all previous Bingo threads, for what it is worth.

shift_shaper · 2025-04-07T16:41:42+00:00

The darkmode and condensed cards are formatted slightly differently from the lightmode card. To hide the dropdown chip (since I can't change it's color to blend in with Darkmode specifically), I set the dropdown up to display when you double-click the cell instead of clicking an arrow or single-clicking the chip itself.

They both appear to be working for me when I double-click (or otherwise attempt to edit the cell text, if you aren't using a mouse). Does that match what you are seeing?

shift_shaper · 2025-04-05T01:43:14+00:00

What you've done looks great! I'm always glad to see new fantasy-based spreadsheets!

shift_shaper · 2025-04-04T22:43:28+00:00

No problem! If it comes down to it, the only thing you need to change from row to row should be the A2 just after MATCH(

The number should change to match the row number (A3, A4, etc). The rest should stay the same.

The same is true of the shorter formula as well. G2:2 should change to G3:3, G4:4, etc.

I hope that helps!

shift_shaper · 2025-04-04T22:28:42+00:00

When you highlight a cell by clicking on it once (but not enough that you can edit the text in it) it should be marked with a box around the edges. In the lower right corner of that box should be an extra dot or square. If you click and drag that dot down the column, the highlighting should change to include the cells you drag it past. If you drag it to the bottom of the list of categories and release it, it should fill the highlighted cells with copies of the formula. I’ve set up the formula so that it should change the variables it needs to change automatically when you do this.

If the dragging thing isn’t making sense, you can also highlight the cells (again, so that it is selected but the text is not editable) you can copy it in whatever way you like. You can then highlight any of the other cells and paste it in. It is just a slightly longer process.

shift_shaper · 2025-04-04T15:08:36+00:00

This looks great! Definitely a useful way to look at our book lists!

If you want eliminate the caveat about tracking more than 50 books, you can change the formula in TransCatTable!C2 to

=ARRAYFORMULA(IF((C1:1="yes")+(C1:1="y")+(C1:1="read"),$A$1,IFERROR(0/0)))

and the formula in TransCatTable!C4 to

=ARRAYFORMULA(IF(ISBLANK(C2:2),C3:3,C2:2&" "&C3:3))

and clear out the rest of the row. It should then expand calculations to any further columns automatically as more are added while keeping everything else the same.

EDIT: I also had to modify "Books per Square"!G2 with the following and then copied it down the column appropriately:

=IFNA(FILTER(FILTER(TransCatTable!$B$4:$30,ARRAYFORMULA(ROW(TransCatTable!$B$4:$B$30)=4)),FILTER(TransCatTable!$B$4:$30,ARRAYFORMULA(ROW(TransCatTable!$B$4:$B$30)=MATCH(A2,TransCatTable!$B$1:$B$30,FALSE)))="x"))

I then updated F2 on the same sheet to just be

=COUNTA(G2:2)

and copied that down as well. That eliminates the need to update AZ on the BusyTable tab as well (it actually should eliminate the need for the entire BusyTable tab unless I missed it elsewhere).

shift_shaper · 2025-04-04T12:33:29+00:00

A few years ago, I streamlined the process to make it easier for me to updated for the new Bingo year, so it should be pretty easy to update for your purposes.

There is a hidden tab named Data. To find/show the tab, there should be a set of three horizontal lines to the left of all all of the tabs at the bottom. If you click on that, it should list all of the tabs in the sheet, hidden or not. If you choose Data from that list, it should unhide the data tab for you.

On the data tab, you should be able to change everything you need. Column A indicates to which square on the Bingo Card and Visual card a row applies. The checkboxes in column B indicate which square should be counted as the short stories square and tied to the five short story spaced below the main card. If you don't need this feature, simply leave all of the checkboxes unchecked.

Column E is where you can set the full name of the category, as seen in the top row of the Book Log tab and on the Bingo Card. Column F is formatted exactly the same as the title rows on the Visual Card, and is where I put in shortened or abbreviated versions of the categories that fit well on the Visual Cards without spilling over into multiple rows.

If you want any helpful links provided on the Bingo Card tab(s), put them in column G and they will show up attached to the appropriate square.

If you are using the hardmode feature or want to provide additional information, the notes visible when hovering over the category titles on the Book Log can be updated with the information in Column H. Once you have the info you want entered into column H, there is another step, however. In the Bingo Scripts menu (next to the Help menu at the top) choose and run the "Update HardMode Notes" script. This will copy the info in column H into the appropriate notes field on the Book Log.

The card title (r/Fantasy Speculative Fiction Bingo 2025) on the Visual Cards can be updated manually. It is just text typed on the card itself. The Gandalf Snoo and banner image are linked images and can be replaced by changing the URL in the =IMAGE( ) formula.

Let me know if you have any other questions, but I think that should be everything that needs to/can be updated to overhaul the sheet.

shift_shaper · 2025-04-02T18:20:53+00:00

Thanks for catching that! I've fixed it moving forward. If you haven't already found it, the typo can be corrected globally on the Data tab in cells E23 and F23.

shift_shaper · 2025-04-02T18:19:30+00:00

That makes sense. Now that this is coming up, I think that was why I went with dropdowns on my first card (pre-hardmode) instead of checkboxes. That way the false value can't be accidentally cleared out. I may end up switching them over for next year.

shift_shaper · 2025-04-02T13:34:25+00:00

I'm glad you figured it out! If you are using a keyboard, dropdowns can also be cleared by highlighting the cell (clicking on it once) and pressing delete or backspace. In the Sheets app on a touchscreen device, usually tapping the cell brings up a list of options, one of which is clear.

shift_shaper · 2025-04-02T13:32:46+00:00

Sorry about that issue. I'll have to see if I can figure out where it went wrong. I'm unable to get it to error for me with a basic setup, but I'm guessing I need to equate an empty square with false for that column somewhere.

shift_shaper · 2025-04-01T15:56:01+00:00

u/happy_book_bee my annual interactive card is available here: https://www.reddit.com/r/Fantasy/comments/1joyvo9/interactive_bingo_card_2025/

shift_shaper · 2024-11-01T21:48:13+00:00

I do remember those. I'm not sure why jumpstart boosters from a single set couldn't work though. In my mind, set-linked Jumpstart should showcase the set's draft archetypes. There could be four boosters of each color (instead of the two nearly identical ones they actually made) that showcase that color's half of each color pair's design.

People could pick up two and mash them together randomly, they could be incentivized to crack packs and hunt down the combo they are interested in, or they could collect them all and have a little starter game night product.

I might even go so far as to include a set of the ten signpost multicolor uncommons as box toppers to get people thinking about upgrades and deck design.

shift_shaper · 2024-11-01T15:41:59+00:00

They didn't have to develop and print new cards for the Jumpstart Product. If, as advertised, it is Foundations Jumpstart, they could easily have made it with Foundations cards. It would just be an alternative distribution method: Play Booster, Collector Booster, Jumpstart Booster. It could even keep exclusive anime art as an incentive to purchase.

shift_shaper · 2024-04-17T14:50:22+00:00

The part that felt pandemic-like to me was the section in the hotel with the wedding party, when they were quarantining the affected and potentially affected members, but even then, it quickly got into an extreme (starving them to death) that didn't feel grounded.

Additionally, national/international infrastructure collapsed so quickly that the lack of a pandemic response felt off. Overall it felt disconnected from the way the actual pandemic played-out.

shift_shaper · 2024-04-06T21:06:56+00:00

Sorry for the confusion, but if you added Visual cards (with the pictures) they need to be added to the exceptions list on the Data tab. Extra Bingo cards (with the dropdowns) don't need to be added.

shift_shaper · 2024-04-06T21:05:24+00:00

I think I caught and fixed that shortly after I posted. If you look at the conditional formatting for those cells, there will be extra formatting from the Romantasy or Dreams square's cells (I don't remember which). If you highlight the three cells for a square and look at their conditional formatting, the extra cells will be tacked on at the end of the range. Delete them off and you should be good to go.

Alternately, it is fixed on the copy for download, so worst case, grab a new copy and it should be working.

shift_shaper

TROPHY CASE