Guides

@ElvenArtist thank you! two things: no worries - a) there's another Joxar fam! [item=vibrant jeweler] b) made a new dark sheet and noticed the Goldenbeast's item ID is wrong - 10223 instead of the correct 10233. idk if it's on all sheets this way or

@dd2900 Seems I forgot to mention the Joxar familiar in my update, but it was added alongside the new festival familiar this morning. Whoops! The Goldenbeast's ID should now be fixed on both sheets. Looks like I mixed up the first 3 for a 2! I've edited my update post accordingly. Thank you! [emoji=coatl laughing size=1]

[center][img]https://i.redd.it/nwkrpinjlmx11.gif[/img] [emoji=bestiary size=1] [b]Fiona Expansion[/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] Hey! I've added the new Fiona Feats and familiars. You'll find them on their usual tabs! If you missed the last update, there are a few corrections I made post-release: [LIST] [*]The Vibrant Jeweler [i]was[/i] released w/the RoR familiar, but I failed to mention it in my post. If you missed it, you'll find it on the Regular familiars tab. [*]The Goldenbeast's ID has been corrected from [u]102[b]23[/b][/u] to [u]102[b]33[/b][/u]. [/LIST] Have a great week! [emoji=coatl happy size=1][emoji=star size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

thank you so much for the update!

[center][emoji=gear size=1] [b]Quick Update: Deerlings, Error Corrections[/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] Looks like I'm back sooner than I thought I'd be! Usually I'd give some time between updates, but due to the limited nature of this new familiar I wanted to get this out ASAP. [i][b]The Willowmane Deerling [u]RETIRES[/u] on November 19, 2020 @/9:00 server time. Be sure to pick up Galore's gift + brew extra copies, if desired![/b][/i] I've added the new familiars, [b]Willowmane Deerling[/b] and [b]Swarmsprite Deerling[/b], as well as their corresponding Fiona entries: [LIST] [*][b]Willowmane Deerling[/b]: Holiday and Retired Familiars [*][b]Swarmsprite Deerling[/b]: Regular Familiars [/LIST] You may put these familiars anywhere you so choose, but if you keep the Willowmane Deerling in the retired tab, then keep in mind that the Fiona entries will pull from a different tab. So, instead of using the normal formula for the bond level cell, use this one: [code]=INDEX(QUERY('Holiday and Retired Familiars'!$C:$D;"select D where C ='"&CELL&"'";-1))[/code] Running into trouble? Make sure your formula info matches this: [quote name="ElvenArtist" date="2020-11-12 18:19:07" ] Where the formula says 'CELL', put the row number + column letter of the familiar's name box! So for the blank sheet, the cells would be as follows: [LIST] [*]Lost in the Woods: [b]E481[/b] [*]Finding the Path: [b]E484[/b] [*]Deerly Beloved: [b]E487[/b] [/LIST] This is the full code for the first one: [code]=INDEX(QUERY('Holiday and Retired Familiars'!$C:$D;"select D where C ='"&E481&"'";-1))[/code] [/quote] Note: The Willowmane Deerling is listed as being obtained through Baldwin, rather than through Galore. That's intentional! Feel free to add Galore if you think it'd be helpful for your personal tracking. I've also made some corrections: [LIST] [*]The Hippojay entry on the Gathering Guide has been corrected to reflect accurate fishing locations. These locations are: Earth, Ice, Light, Nature. [*]The Harlequin Stagwing's ID has been corrected from [b]#162[u]36[/u][/b] to [b]162[u]63[/u][/b]. [/LIST] Thanks to the individuals who caught these errors! Enjoy the new ancient breed, and I'll see you guys again for Rockbreaker's! [emoji=veilspun happy size=1][emoji=pink star size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]