Amanda ’s Comments (group member since Feb 03, 2026)

Amanda ’s comments from the Spreadsheet Central group.

Ah sorryy!! I must have missed the notification for your last response. I saw you've made some more updates! Could you walk me through what you ended up doing/working on? Just so I can follow your thought process :)

I like how it looks!

Haha yes, I enjoy being busy but this has been really a fun hobby for me on the side. I feel like I get to express my creativity more though this which I don't get too do as much as a psychologist lol

Yay! It's going to be in Hooked on Books 😊 I think you're a member of that group right?

I have a few challenges I'm about to run there and a mini one I'm running now

Thank you ❤️🙏

Basically just changing them to be drop down an adding the words below validated with the sparkline (if it's not too complicated)

I also like how it shows all the ingredients stored on that page too so definitely keep that there :)

I hope you're feeling better! The sparkline's work great thank you! & thanks for sharing the tutorial

I think for the cauldron page it might be better to have the dropdown like how I had it on my original cauldron sheet and then I liked how it was set to say "keep adding ingredients" or "potion ready to brew" if all ingredients are added.

The reason for the dropdown answers your 3rd question bc people will just make however many potions they want based on what they read & they could even make a potion more than once if they wanted so they'll basically gather ingredients from books they read and decide how they want to use those ingredients (save them or use them for more simple potions, etc). So having the drop down makes it so they can just track their progress on whatever potion they're making at the time. I do like how you have it set up though were there's multiple potions being tracked at a time. I think you can keep it that way and just add the dropdown where the title of the potions are and then have it set so when they check off ingredients it will show up like the pics below but with the sparkling filling accordingly.

These are with the "dragonform elixir" selected:

with half of ingredients added. It says "keep adding ingredients:"


with all of ingredients added. It says "potion ready to brew:"

No rush at all! I just hadn't said gave any feedback in a while so wanted to let you know I like what you've done so far :)

Everything is looking good so far, Fredicka :)

Sorry, I know it's a little blurry but hopefully If you zoom in you can see it lol

Thank you!! Yes, I think it looks amazing! I requested edit access on that copy you sent bc I can't use the dropdown rn but it looks good! & thank you sm for sending those links. I'll take a look at them. I think the only need it needs now is the potion log and ingredient log validated the way I had it on the template page for the ingredients (including the simple potions that are used as ingredients in the legendary potions)

Here are screenshots:

Blank version:



& Here's an example where I checked a potion as brewed without having the required ingredients so I can see something was used that they didn't have (so ingredient/task list is empty)

Thank youu ❤️

& the YouTube names would be great!

Sorry, I didn't mean to overcomplicate things. I don't really know what your guys' different styles are & I don't really have a preference but since you were already working on it, Fredicka, we can just continue. I appreciate your input though, Izzy, for my own learning and it helped me think about how I want the SS to look so thank you sm 🫶

Also, as far as showing you how I want my spreedsheet working. I think I pretty much did that on the template page with the ingredient store and potion log. That's the basic skeleton of how I want it to work. For the cauldron thing, The image I have on there is how I want it to work (on the copy page). I just need to figure out how to make it look good lol if it's impossible I'll just throw that idea out. I got it to work how I want it to, it's just the visual part I'm struggling with.

But since my knowledge is lacking, if there are better ways to do what I'm essentially trying to do on the template page, thats what I would need help with. As well as it making it look appealing. I'm also happy to do a zoom call or phone call or something if you feel like it would be easier to understand over the phone but totally up to you. It's hard to explain things in text sometimes.

Also, I know we all have lives and things to do outside of this so there's no rush :) I planned to run this challenge in May so plenty of time. I had just wanted to explain things before you started working on anything else.

Thank you!! Yes, I like option 3 as far as layout because of the amount of books people might read within 3 months.

I do like option 2 as well but I'm guessing with that style it would be more work to put over 100 of those boxes right? (and harder for me to read all at once). Unless Fredicka was planning to do it another way?

I do obviously like the visual's of option 1 or 2 better but I'm sure it wouldn't be too difficult to make option 3 look pretty as well.

I see. That's helpful to know. Maybe Fredicka can make the book entry similar to the layout of the template or just adjust mine so that it incorporates your suggestions? Or whatever you guys think. I'll let ya'll do your thing lol but if there's something simple I can do to make it easier for you guys, lmk.

I wish there was a way for me to like see the steps you take on the sheet so I could kinda learn how to do things a bit more but even seeing different ways of setting it up is really helpful.

Ah okay. I think that was a page Fredrika added. Here is my master SS (before any additions were made). https://docs.google.com/spreadsheets/...

Does the same thing apply? Or are there other things you would change? The reason I ask is bc chatgpt guided me in making this. I don't know anything about SS really so I'm trying to learn lol

I also wanted to add, before anything further is worked on, that I do need the ingredient resource storage and potion log that is on the "template" page. Over to the right and, if you scroll down, you'll see the potion log. I have it set up now so that it shows how many ingredients were collected, used, and how many left remaining, based on the books/ingredients inputted from the log on the left, and potions brewed from the potion log. It automatically adds and subtracts them.

This is so that when people post completions, I can look at the SS and easily see how the ingredients were used without them having to explain it too much (especially for the more complicated potions). For example, if they used an ingredient they didn't have, it would show -1 in the remaining column.

I also have the simple potions that are used in the legendary potions listed as ingredients there. For example, the potion of power is listed as an ingredient.

That's why I have the "brewed" check box bc once that's checked is when the ingredients of that potion are subtracted from the ingredient store.

Does that make sense?

I might try to work on them too if Fredrika is busy!

Izzy wrote: "Since this is getting long and specific, I've created a thread for you to discuss it specifically. It's over here:
https://www.goodreads.com/topic/show/...
..."

Izzy, would you mind explaining your thinking for the spreadsheet? (In the dedicated thread) What changes would you make?