Guides

[center][emoji=bestiary size=1] [b]New Fiona Familiars[/b] [emoji=bestiary size=1] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] Hello again! I've added the new Fiona familiars, [b]Watermelon Puffer[/b] and [b]False Eye Depin[/b], to the sheet. Please refer to the FAQ+Tutorials post for instructions on how to update, if you need help! In order to make releasing update posts easier on myself and less notification-intensive for y'all, I'm considering consolidating all minor familiar updates into the Festival update. I'd like to get your thoughts on this, so if you're able please let me know! [emoji=brown gem size=1][u]These once-a-month updates would include:[/u] [LIST] [*]Joxar recolors [*]small Fiona updates [*]festival familiars (of course) [*]small marketplace updates [*]minor updates to existing entries (name changes, location changes, etc) [/LIST] [emoji=brown gem size=1][u]These would NOT include:[/u] [LIST] [*]large Coliseum venue additions [*]large marketplace additions [*]new GE shops [*]Anniversary updates [*]new sheet features or important bug fixes [/LIST] These will get their own posts. Note: I will still add familiars to the update sheet as they are released; this is just for the notice of said updates. Have a great weekend! [emoji=skydancer tongue size=1][emoji=wing size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

[quote name="QueenQueso" date="2023-07-13 09:27:35" ] This is so handy, especially the Swipp tab. Do you know if there's any similar visual guides for all the Swipp items? [/quote] Hey! I'm glad the sheet's been helpful for your Swipp tracking [emoji=skydancer laughing size=1] I'm not sure off the top of my head, but you might find one floating around this forum. I'll keep an eye out! If not, the format should be easy enough to modify for your own personal use! I believe you should be able to export the Swipp tab as its own sheet by right-clicking on the tab and selecting Copy To > New Spreadsheet, then you can make changes or additions from there!

[center][emoji=lightning rune size=1] [b]Thundercrack Carnivale 2023[/b] [emoji=lightning rune size=1] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] Hey everyone! I've added the new festival and Joxar familiars, [b]Larkspur of Thundercrack[/b] and [b]Scorpio[/b], to the sheet. I've also made a correction to [b]Libra[/b], whose entry incorrectly states it can be collected from the AAA. This has been changed to Joxar. In the last update, I asked if y'all would prefer frequent small updates per familiar release, or one large update with all minor familiar releases. I've decided to continue posting as I have in the past, but if life gets too hectic I'll use the second option to fall back on! Happy Thundercrack! [emoji=skydancer winking size=1][emoji=gear size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

[center][emoji=sword and shield size=1] [b]Warrior's Way 2023[/b] [emoji=sword and shield size=1] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] Hey everyone! The new familiars for Warrior's Way have been added to the sheet! Sorry it took a little bit. Edit: Also added the now-retired Sandskink! You'll find it under Holiday and Retired familiars. Have a great week! [emoji=skydancer happy size=1][emoji=sword size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

@ElvenArtist Thanks for the updates! There is also a new familiar released with Sandsurges that is retired now. [item=Sandskink] It's given by Galore and could be brewed at Baldwin's for a week after the release. Didn't see it in any of the updates unless I missed it somewhere so just thought I'd let you know. Cheers!

@Shizukuchan

You're absolutely right! Definitely missed it, and have now added it. Thanks!

[center][emoji=gear size=1] [b]Fiona and Marketplace Additions[/b] [emoji=gear size=1] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] Hey everyone! I've added the new Marketplace familiars, [b]Roseate Gryph[/b] and [b]Crowned Gryph[/b], as well as the new Fiona familiar - [b]Shorn Cerdae[/b] - and its related feats to the sheet. A note: I forgot to add the Sandskink familiar initially, but it has since been added to Holiday and Retired Familiars. Have a great weekend! [emoji=skydancer happy size=1][emoji=firework size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

[center][emoji=fire rune size=1] [b]Flameforger's Festival 2023[/b] [emoji=fire rune size=1] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] Hey there! Totally forgot I hadn't posted this yet [emoji=skydancer scared size=1] I've added the new festival and Joxar familiars, [b]Poppy of Flameforger[/b] and [b]Sagittarius[/b], to the sheet. Happy Flameforger's! [emoji=skydancer laughing size=1][emoji=gold star size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

[center][emoji=coliseum team size=1] [b]Coliseum Update: Silk-Strewn Wreckage[/b] [emoji=coliseum team size=1] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] Well, it seems we're back quite soon with a new Coliseum venue! I've added all [b]26 new familiars[/b] to the sheet, as well as a new venue section in the Coliseum tab. I've also removed [b]Crowned Bonepriest[/b] from Sandswept Delta on the blank sheets, as it's been removed from the venue. [u][b]Updating the Coliseum tab[/b][/u] [emoji=brown gem size=1]Manually Updating your Coliseum Guide tab: For help with manually updating your Coliseum tab, please refer to [url=https://docs.google.com/document/d/1O8tXOTXkRj6omMH0aREL5-6gG_8zhCYO5lm1DT_t-TE/edit?usp=sharing]this tutorial[/url] (it's also located in the FAQ post). Even though we're adding a whole new section rather than just a row, the steps are practically the same. If you need additional clarification, let me know and I'll update the tutorial doc with steps for this specific update! I've placed Silk-Strewn Wreckage between Sandswept Delta and Blooming Grove on the blank sheets to better match the official venue order. If you aren't familiar with working in Sheets and placing the new entry between existing ones seems daunting, adding it below the bottommost venue entry (Forbidden Portal, most likely) will work just the same. [emoji=brown gem size=1]Copying over the updated Coliseum Guide tab: You may also find deleting the old Coliseum tab and copying the new one from the blank sheets more approachable. I only recommend this if you've made no customizations or modifications to your sheet! To do so, follow these steps: [LIST=1] [*]Delete the old Coliseum Guide tab from your sheet [*]Go to the blank sheet that corresponds with your sheet type (i.e. regular or dark version) and right click on the Coliseum Guide tab [*]Click "Copy to..">"Existing Spreadsheet" and when prompted, select your personal sheet [*]Return to your personal sheet and verify that the new tab copied over correctly; it should be named "Kopie von Coliseum Guide". Rename it to "Coliseum Guide". [*]Go to your Statistics tab and check cells C12 and E12. You might see #REF - that's okay! Just click on the formula in the formula bar and press "Enter" for each cell, and it should register the new tab. [/LIST] If you find things keep breaking while trying this method, using CTRL+Z a few times or restoring to a previous autosave version should restore your old tab, and you can safely delete the new copied one. As usual, let me know if you catch any mistakes! Have a great rest of your week! [emoji=skydancer star size=1][emoji=butterfly size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]