Guides

[center][emoji=crescent moon 1 size=1] [b]Night of the Nocturne 2022 (+Harpies)[/b] [emoji=crescent moon 1 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 everyone! I've added the new Harpy familiars and all 10 new familiars for NotN. You'll find them under the Regular Familiars tab. Happy holidays if you celebrate! If you don't, have a great rest of your week [emoji=skydancer laughing size=1] [b]Edit: I forgot to add the Baldwin familiars! They're on the sheet now.[/b] [emoji=firework size=1][emoji=wizard hat size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

@Leafalie Oops, totally did! Good catch. They're added now [emoji=skydancer happy size=1] Thank you!

[center][emoji=ice rune size=1] [b]Crystalline Gala 2023[/b] [emoji=ice 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] Hello! Happy Gala! I've added the new familiar, [b]Shardback Slink[/b], to the sheet. I've also made the following changes and corrections: [LIST] [*]Changed "Mesacliff Royal" to "Mesacliff Noble" in accordance with site updates [*]Extended the Baldwin Statistics page range to include the new NotN familiars [*]Added the NotN Baldwin familiars (added as of December, but after the initial post) [/LIST] [b][u]How to update your Statistics page:[/u][/b] The new row of Baldwin familiars begins on row 118, so we need to extend the range on the Statistics page to include it. All Baldwin counting data should be in row 6, starting at cell M6 (ending at R6 before 1/22); if this is different on your personal sheet, follow the steps using the cell and row numbers accurate to your sheet. [LIST=1] [*]Go to cell S6 on the Statistics tab. [*]Paste or type this formula into S6: [code]=COUNTIFS('Baldwins Brew'!118:118; "*")[/code] This will add the entire row! So no need to extend the range again until 118 is full. [*]Once pasted, go to the cell with the Baldwin count total, E11. The formula should look like this: [code]=SUM(M6:R6)[/code] [*]Replace R6 with S6, and hit enter. The total should now be accurate! [*]To hide any text, change the font color to match the cell color (white text for white background, etc) [/LIST] Have a great week! [emoji=skydancer happy size=1][emoji=snowflake size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

Very useful sheet! Just what I needed for a mass familiar shopping haha, thank you!

[center][emoji=shadow rune size=1] [b]Trickmurk Circus 2023[/b] [emoji=shadow 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] Hello! A bit of a delay due to illness [emoji=skydancer sad size=1] I've added the new familiar, [b]Brambleback Slink[/b], to the sheet. You'll find it under the usual Holiday & Retired Familiars tab. Have a great rest of your week! [emoji=skydancer laughing size=1][emoji=bramble size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

[center][emoji=wind rune size=1] [b]Mistral Jamboree 2023[/b] [emoji=wind 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] Hello! I've added the new familiar, [b]Breezeback Slink[/b], to the sheet. You'll find it under the usual Holiday & Retired Familiars tab. Have a great rest of your week! [emoji=skydancer tongue size=1][emoji=gust size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

[center][emoji=water rune size=1] [b]Wavecrest Saturnalia 2023[/b] [emoji=water 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] Hello! A bit delayed due to not wanting to wrestle with site lag. I've added the new familiar, [b]Shellback Slink[/b], to the sheet. You'll find it under the usual Holiday & Retired Familiars tab. [b]Edit 4/25: The Joxar familiars, Leo and Cancer, have been added. Sorry![/b] Have a great rest of your week! [emoji=skydancer happy size=1][emoji=seafood size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

@ElvenArtist As always, thank you for all your hard work! However, I think you may have overlooked Cancer, the newest Joxar recolour.