Guides

@ElvenArtist All of the stuff you mentioned could make for a good start in terms of tutorials, so maybe going through the more difficult stuff to change would be easier for people who might want to implement things?

Personally not super picky in terms of what comes first or last, just being able to learn how stuff can be done is useful in my book!

[center] [emoji=fire rune size=1] [b]Flameforger's Festival! +Fiona Update[/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]Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] Seems a banner wasn't in the cards for this month's update, unfortunately. Decided to compile both updates into one, since they were so close together. I've added the new festival familiar, [b]Burning Virgo[/b], as well as the new Fiona Feats familiars and entry additions! [b]Edit: Seems I've missed an entry. I've now added the Glittering Jeweler familiar as well![/b] The Fiona familiars can be found on the Regular update tab, as usual, and the Feats tab entries can be found under the "Fiona Feats" update tab. These can be copy-pasted into your sheet, but I highly recommend copying the entire tab from the blank sheets, as adding the formulas can be a bit time-consuming. If you prefer to copy these entries into the tab you currently have, you may copy-paste the formulas from existing entries; do keep in mind, however, that the formulas for feat tiers 1-3 are all different. I've included the basic formulas at the bottom of this post. I'm currently working on tutorials for the changes made in the previous update as well as the Fiona additions here, so if the past couple of updates have seemed daunting, have no fear! I expect to roll those out within the next week or so. Happy grinding! [emoji=coatl laughing size=1][emoji=firework size=1] CELL = column letter + row number. Note: Wary (1) is Wary (0) on the classic sheet. [quote=Bonding Level Indicator][code]=INDEX(QUERY('Regular Familiars'!$C:$D;"select D where C ='"&CELL&"'";-1))[/code][/quote] [quote=Relaxed Tier Completion][code]=IF(OR(CELL1="Locked";CELL1="Wary (1)";CELL1="Tolerant (2)";CELL2="Locked";CELL2="Wary (1)";CELL2="Tolerant (2)"); "Incomplete"; "Complete")[/code][/quote] [quote=Companion Tier Completion][code]=IF(OR(CELL1="Locked";CELL1="Wary (1)";CELL1="Tolerant (2)";CELL1="Relaxed (3)";CELL1="Inquisitive (4)";CELL2="Locked";CELL2="Wary (1)";CELL2="Tolerant (2)";CELL2="Relaxed (3)";CELL2="Inquisitive (4)"); "Incomplete"; "Complete")[/code][/quote] [quote=Awakened Tier Completion][code]=IF(OR(CELL1="Locked";CELL1="Wary (1)";CELL1="Tolerant (2)";CELL1="Relaxed (3)";CELL1="Inquisitive (4)";CELL1="Companion (5)";CELL1="Loyal (6)";CELL2="Locked";CELL2="Wary (1)";CELL2="Tolerant (2)";CELL2="Relaxed (3)";CELL2="Inquisitive (4)";CELL2="Companion (5)";CELL2="Loyal (6)"); "Incomplete"; "Complete")[/code][/quote] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

tysm! [emoji=familiar heart size=1]

[center][img]https://www.cheapflights.co.za/news/wp-content/uploads/sites/140/2019/04/search-cat-flights-09.gif[/img] [emoji=gear size=1][emoji=arcane rune size=1] [b]Mega-Update! +Starfall![/b] [emoji=arcane rune size=1][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]Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center] [rule] College started three weeks ago in full force, so I had to delay this release by quite a bit. I've added the [b]Redrock Cove expansion[/b], the new [b]Pirate Day familiars[/b], the [b]new Fiona Feats[/b], and the [b]Enchanted Libra[/b]! Edit: I've just added the new Joxar familiar recolors! I've also added a new tutorial and linked an older video tutorial. I was hoping to have more completed, but the timing with school and the frequency of updates just wasn't in my favor. The tutorial released is text+image only for the time being, but I'm looking to release video versions for this and other tutorials in the future as well for those who would prefer a more visual approach. As classes grow more time-intensive, updates will likely be slow. I'm planning to condense minor updates together to release fewer-but-larger updates. If you prefer updating your sheet closer to a release, I recommend checking the update sheet within 24-48 hours from a release to see if I've added stuff without posting here -- oftentimes I add updates way before making an official post! Have a great week! [emoji=coatl tongue size=1][emoji=planet size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]

Thanks for the updates and extra cats! Wishing you well with college ofc and personally I totally understand delays due to that. xD

Thank you for the update!

[center][img]https://i.pinimg.com/originals/43/be/4a/43be4a1990f2c7c033b00d5f7e4640d3.gif[/img] [emoji=plague rune size=1][emoji=coliseum team size=1] [b]Riot of Rot! + Forgotten Cave Expansion[/b] [emoji=coliseum team size=1][emoji=plague 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]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 hope you've been having a great October so far, despite current circumstances. Mine's been busy as usual, but I've also been preparing for Halloween! Decorated my dorm with my roommates, and we're carving pumpkins + baking cookies today. If you would like to share, I'd love to hear from y'all about what your end-of-month plans are, whether you celebrate Halloween or not [emoji=coatl happy size=1] Decided to change things up a bit with a cute Halloween-themed dog gif (spider, since I couldn't find a scorpion costume gif) in spirit of the holiday and the new familiar. I've added the [b]Spoiling Scorpio[/b], as well as the new [b]Forgotten Cave familiars[/b] to the sheets! Regular entries and Coliseum tab entries. You will need to add a new row to accommodate them, so if you need any help, let me know! [u]EDIT: I added the new Joxar familiar as well, but forgot to mention it! You can find the [b]Vibrant Jeweler[/b] on the Regular familiars tab. Goldenbeast's ID has been changed from 10223 to 10233![/u] In the meantime I'll be working on getting some more tutorials out, time allowing. Seems whenever I get a break it's immediately cut short with tons more work [emoji=coatl deadpan size=1] Have a great week! [emoji=coatl star size=1][emoji=firework size=1] [rule] [center][size=1] [emoji=scroll size=1] [/size][/center]