Spreadsheet Central discussion
Shared Spreadsheets
date
newest »
newest »
message 1:
by
Kelly (Maybedog)
(last edited Jan 28, 2026 08:22PM)
(new)
Jan 27, 2026 12:04AM
Mod
reply
|
flag
Mod
MM Spell
(view spoiler)
MM Scavenger Hunt
(view spoiler)
Other Spreadsheets
(view spoiler)
Mod
https://docs.google.com/spreadsheets/...
This is the same spell database, I just mucked about with how data entry and lookups worked.https://docs.google.com/spreadsheets/...
I've been working on a "master" tracking spreadsheet for the spell competition, but it's still a work in progress, even if I did include instructions for use.https://docs.google.com/spreadsheets/...
Mod
Mod
https://docs.google.com/spreadsheets/...**From the Spell Chat.
Insomnia struck and instead of sleeping, I made a spreadsheet. 💤➡️📊🤪
I put together a spreadsheet for Spell that automates a ton based on the code assigned to each book — including handling titles with or without articles (A / An / The). If you fill in the details, it can also generate your completion post for you. ✨🧙♀️
🧮 Contains formulas
😴 Fueled by lack of sleep
🗂️ Accidentally very organized
📈 May inspire additional spreadsheets
Made at 3am. Standing by it. 😌☕
If anyone wants the spreadsheet chaos, I’m happy to share! 🙋♀️📊
Getting Set Up
Start by adding your teammates’ names to Column A on the Members tab.
Adding New Words
When a word is announced, type it IN ALL CAPS on the Words tab.
Don’t worry about the rest — the sheet will automatically fill it in wherever it’s needed.
Updating the Round Tab
Head to the Round tab when a new word starts.
Copy the Header row (Row 10) and paste it at the end of the previous word.
Copy Cell B11 to begin the next word section.
Repeat this each time a new word is needed.
Tracking Your Books
The Books tab is where everyone logs their reads, including the broken link.
Column AA will automatically create a completion post for you (totally optional).
Once you add the Message # to "Done" (Column H), the completion post will hide itself.
What the Colors Mean
Maroon in Column A: You’ve added a completion date, but the “Checked” box (Column A) isn’t marked yet.
Red row: A completion date is entered, but the completion post hasn’t been made.
Yellow row: The book has been read but not used yet.
Green row: The book has been used and fully checked off. 🎉
For the new spell database:*Articles do not have to be entered separately. That is handled under the hood.
*There isn't a separate sheet for every letter, but a very short questionnaire on the "START HERE" sheet that asks what the user is looking for (rows 18, 19). There's just 3 cells for the user to fill in and 2 of them have drop down choices. The results are then on the "Query Results" sheet. Instructions are in rows 14-16.
*There's a dynamically (on the fly) built query on a hidden sheet called "Query" if you want to see some of the backend stuff, but please hide that sheet again when you're done. Users don't need to see my spaghetti code.
Mod
--I love that you included how many options there are for letters and the scripts you and Lisa wrote for automatic completion posts and not having to do articles separately. I have some ideas/issues with the completion posts and making it accessible for different spell challenges but I'm still thinking about it. (I use the database for spell outs in challenges outside the MM Romance Group. I don't share it, just use it. So completion posts are different.)
--The field for choosing a letter needs to be near the top. No one is going to scroll through all our instructions to get there. Personally I think we should have an instructions page and an entry page and the instructions need to be much, much shorter. I lost on that argument last time.
--Having people specify what field they want the letter to be in just makes it harder to use. For spell outs, people use whatever is available. It doesn't matter whether it's an author or a series. Having to look through each category is unnecessary and tedious. If there's something that isn't allowed the particular challenge they're doing, like they can't include narrators, that's what sort is for.
--Now that I know that we don't get notifications for comments on our profile page, as long as we don't open this up to all of GR, I'm okay with putting my email under contact info.
Mod
One thing I'd like to see added to the spell tracking sheet is rating. I and someone else from our team add a rating and I think others would to. It would be optional of course and we could just let people know that at the beginning of the challenge when we're explaining the spreadsheet.
I put the spreadsheet YonnoMaus and I created from Lisa's because she made the summary page really cool. It would be awesome to get something like that in the most recent version of the spreadsheet, Izzy's.
I have spreadsheets for Scavenger Hunt, too, for tracking possible book and their points and one for individual tracking. But I need to find time to get those together. The sheet above from me and YonnoMaus needs cleaning up. There's a template page but it was made at the end and I didn't have the time or inclination to make it pretty.
I hope Fredicka joins this conversation because she has spreadsheets, too. I would love to find a way to integrate her master database sheet for the Scavenger Hunt because she has to manually add everyone's books to it and that's a lot of work for her.
Addressing some of the comments:--For other spell challenges, let me know the format of the completion posts and I'll look into letting that be something more selectable.
--I think you're right that the instructions needs to be shorter. I mostly just worked with what I had. Again, let me think about this and see what I can do. For data entry, I think acting more like a database with a form entry would be better.
--There's a "any use" choice that is for just picking everything in the database that has that letter. It's the first one on the list. I wonder if I can make it the default when opening for the first time...
--I should change the contact information and add people to it now that I'm sharing. Also, make a decent name for the file.
--spell tracking sheet: rating added. We'll see this reflected when we start round 4.
--The summary page looks like it combines the summary and team info pages in a really nice way. Yeah, I can make that work.
For anyone working with the book database: I've linked it to a data entry form, but would like to see how that works! If you've got any books you want to add, feel free to try it with a form:https://docs.google.com/forms/d/e/1FA...
This is what I us for my them during the MM Scavenger Hunt. Not sure if I'm going to captain this year or not. But this is a blank copy of what I normally use for my team. I tend to adjust things as needed.https://docs.google.com/spreadsheets/...
Mod
(view spoiler)
Mod
Mod
(view spoiler)
Kelly, please make things look pretty! Aesthetics are not my strongest skill.I've updated the link in post 13. Please try again! There was something weird at the end, and I don't know if that was what was causing the error. I just copied the link they game me!
Mod
I'm assuming it populates the "master" sheet. Is that going to be hidden? If someone has a lot of books to add, is there a way for them to enter books directly into the sheet? It would probably be mostly me but there might be someone else. I'd love to get rid of that message about editing and the message going away for five minutes. It's annoying.
Excellent! The form populates the "Form Responses 1" sheet. I'm basically assuming two types of data entry: one offs from the form, and bulk entries by copy and paste. I've been trying to make both of those easier, but I haven't touched the original version. Mostly because I don't want to break what I can't fix. Feel free to make it pretty.In terms of making it easier, the goodreads link is basically anything where the longest number is that number in the edition URL. Other than that, I don't care.
Mod
Yeah, don't mess up the original version of the database. YonnoMaus put a ton of work into it and it's their baby. I helped but it's mostly theirs.
I didn't put "longest #" anywhere on the form, because I thought it would confuse people. I just said I'd be happy with the link in any format. What I'm really looking for is the number in the URL after the word "show", which is the same as the number in any GR link of the form [*book:...]. I take what I'm given, programmatically ignore everything except that number, and recreate the links in whatever format from the number.
Mod
Kelly, if you want to reformat or rephrase the descriptive text, please feel free. You're welcome to leave it as a comment somewhere, email it to me, or edit the form if you're able. I've given you editor access to the form, but I don't know if that extends to the attached form. If it does, that's under Tools->Manage Form.
Mod
Here is what I use when I captain MM Team Spell. It is based off of Lisa MN's sheet. There are a few differences. I made comments on most of the formatting changes that I have made.https://docs.google.com/spreadsheets/...
Mod
I did a thing.https://docs.google.com/spreadsheets/...
So, this is an all books spell database. It makes use of my copy of the MM spell database, but keeps it separate, and allows others to create other genre specific spell databases, if desired, that can also be added.
I'm working on a tie in individual spell challenge helper sheet to make adding to spell databases more useful, but I'm not quite ready to share that.
Mod
Sorry, I still need to look at it but this week is really bad.
The way this works is there is still a M/M only database, and any M/M updates can and should be made to that database. The all books database imports that database, and any other genre specific databases that are created, smashes them all together with what is unclassified and says "these are the books". If books are added to a genre specific database, there is no need to add them to any other database.I realized I had the perfect field to put genre in, so that was an easy addition.
As I said above, I'm working on this individual spell challenge helper sheet.https://docs.google.com/spreadsheets/...
There are extensive instructions here. Most have to do with starting challenges. Roughly, how this works is:
*Has books in the spell database as a backbone.
*All the books you read get recorded on the "Books" sheet. They're pulled from the database by a code, so if someone else already read that book, saves data entry time.
*Can have multiple spell challenges running simultaneously
*Dropdowns on "Challenge Spell" sheets to select books that match that letter. (Read after a date selected per challenge)
*An area to copy/paste book/author information into forums (please let me know if this can be improved!)
