Guides

[indent][size=2]OUGGH thank you so much for your spreadsheets, this is perfect to track my own long drop challenge!!! i did notice a small thing; with the quotes you can kinda get away with having spaces in your quote names if you don't include the "name=" part of it[/indent] [code][quote=Example Text Here][/code] [quote=Example Text Here]yay yippe spacing[/quote] [indent][size=2]will let you have spacing w/o needing the dashes!! that's just a small visual code thing tho :] otherwise thank u sm for this and your toolkit spreadsheet which has been a godsend for my hatchery now + tracking my projects

Minor error in the coding on the Woodland Path page! This is on the Everything + Festivals sheet. The top box with the count in it, the 'Scrolls & Vials' is counting the rows of 'Skins' (line 108) M2 should read "=SUM(B101:O104)" not "=SUM(B101:O108)" I fixed it on mine, very easily, but thought I'd mention it! I am unsure if any of the other sheets have an error; I'm doing an egg challenge and I'm still stuck in the stupid Woodland Path. Look at these numbers: [img]https://imgur.com/xzmbce3.png[/img] Why does it hate me? IDK. Maybe it loves me and never wants me to leave? Who knows, but I am so over it LOL. Its been so many days ;-; I got food for days. So much food. (1547 insect, 4305 meat, 2882 seafood, 2745 plants lmao I don't even know how many points they all add up to. But like. a lot. Many lots.)

@ThistleProse Fixed! This was an error on all sheets, must have fat-fingered it when putting together that top row. Also good luck with your own Egg challenge! I'm doing the same (taking a brief hiatus right now), and I remember the Woodland Path being an absolute [b]drag[/b] to sludge through. My final count was: [list][*]Familiars - 161 [*]Apparel - 40 [*]Battle Items - 352 [*]Scenes and Vistas - 8 [*]Scrolls and Vials - 15 [*]Skins - 1 [*]Runestones - 5 [*]Eggs - 1 (obviously)[/list] I deeply hope your luck improves by the time you reach the Scorched Forest. That one took me FOREVER. My count of items in that venue: [list][*]Familiars - 303 [*]Apparel - 95 [*]Battle Items - 995 [*]Scenes and Vistas - 21 [*]Scrolls and Vials - 37 [*]Skins - 17 [*]Runestones - 6 [*]Eggs - 1[/list]

Oof! @.@ I'm closing in on your numbers. Just updated before I head to bed lmao;

Familiars: 154
Apparel: 36
Battle: 379
Scenes & Vistas: 5
Scrolls & Vials: 12
Skins: 1
Runestones: 2

Insect Items: 1930
Meat items: 5412
Seafood Items: 3561
Plant Items: 3511

Eggos: 0 ;-;

This is so perfect thank you!

I have updated my quote with my misery XD [quote name="ThistleProse" date="2025-01-23 09:36:38" ] Oof! @.@ I'm closing in on your numbers. Just updated before I head to bed lmao; Familiars: [s]154[/s] 228 Apparel: [s]36[/s] 55 Battle: [s]379[/s] 556 Scenes & Vistas: [s]5[/s] 10 Scrolls & Vials: [s]12[/s] 14 Skins: [s]1[/s] 5 Runestones: [s]2[/s] 4 Insect Items: [s]1,930[/s] 2,793 Meat items: [s]5,412[/s] 7,804 Seafood Items: [s]3,561[/s] 5,034 Plant Items: [s]3,511[/s] 5,044 Eggos: 0 ;-; x-x [/quote] I have also gotten 8 chests; though only 4 individuals :eye roll of doom: RNG is hating on me something fierce hahaha

*sobs* I was finally successful! Even got an [i]ice[/i] egg lmao [center][img]https://imgur.com/fLIXjDV.png[/img][/center]

I have a suggestion, but it might be more effort than it is worth, I'm not sure, so don't feel at all obligated to even consider it if the idea makes you wanna take a spork lol

But... what if there was a consolidation sheet? Like, similar to the Festivals, I guess, but on it, you could check mark which Venue you wanted to include and it would consolidate all the info from those sheets into code for a single post?

Liiiike, I'm currently being tortured by the Boneyard, but I also just spent a couple hours grinding fodder in the Mire, and so I have loot from both places, yeah? And in this hypothetical, I could fill out the loot drops on both sheets, and then go to the Consolidate page, and check box for Boneyard and Mire, and it would condense all the items into shared posts. So like, it would add up duplicate items from location A and B (eg, apparel that drops from both places, if I got a piece in Boneyard, and a piece in Mire, it would write x2 for that piece, not x1 and x1) and would pull in the items from each category together, so it wasn't all duplicated up, which is what happens presently when I post from grinding in two locations.




Not sure how much sense that makes lmao. But again, feel no obligations. If you feel inclined, it would be epic. If not, that's cool! Posting multiple pages isn't a big issue!


I'd love it if we could have multiple Festivals counting at the same time, too. I know they don't overlap much at all (I think only one? Pirate Day overlaps with Starfall for 7 days) but because of the egg drop challenge I'm doing, I have both counts for Love active, and also Trick which mostly just means not deleting my Love quote when I update that post xD

@ThistleProse Honestly that's not as big of an effort as you'd imagine! I can definitely look into it, and really the hardest part would just be figuring out how I'd like to organize the page!

And yeahhhhh I totally missed overlapping festivals when updating the sheet to include all festival drops. Just... completely whiffed my brain. I may go back and split the festival into 2 separate rows (for major fests and minor fests) to adjust that, but first I need to figure out how I'd pick apart and reformat the code for that!

[quote name="BassetBites" date="2025-02-27 06:26:25" ] @/ThistleProse Honestly that's not as big of an effort as you'd imagine! I can definitely look into it, and really the hardest part would just be figuring out how I'd like to organize the page! And yeahhhhh I totally missed overlapping festivals when updating the sheet to include all festival drops. Just... completely whiffed my brain. I may go back and split the festival into 2 separate rows (for major fests and minor fests) to adjust that, but first I need to figure out how I'd pick apart and reformat the code for that! [/quote] :D awesome! Re the second part... I can't help with the coding haha. It frightens me XD But... Maybe make NotN separate again, so we can hide the rows that it impacts outside of the event? So there would be three sections if it was all visible at once (Festival, Mini Fest, NotN) and we could just hide the NotN rows if we don't want the empty space there? Probably asking too much of Google Sheets to have like, a check-box to show or hide the appropriate rows lmao. edit; lol tagged myself like a dweeb