Guides
Community created guides, helpful strategies, and more.
TOPIC | [Starfall] Sheets Familiar Tracker
1 2 3 4 5 6 7 ... 16 17
[center][img]https://i.imgur.com/PbTEhvI.png[/img] [rule] [center][b]Main Page[/b] | [url=https://www1.flightrising.com/forums/gde/2876351/1#post_43732088]Bug Report/Tutorials+FAQ[/url] | [url=https://www1.flightrising.com/forums/gde/2876351/1#post_43732091]Art + Graphic Submissions[/url] [url=https://www1.flightrising.com/forums/gde/2876351/17#post_52319902]Most Recent Update[/url][/center] [rule] [size=2]Hey everyone! I'd like to thank Ravenmoon for creating this sheet years ago, and users like Flurry who have updated it up until 2018. I don't take ownership of the original sheet, and thus will not change the core aesthetics, functionality, and structure of it. If at any time Flurry returns to Flight Rising and would like to take over the sheet, I will be handing full control over to them. In order to introduce new features and aesthetic updates, I've created a streamlined, visually cohesive version of the sheet that will be available in replacement of Ravenmoon's original sheet. Both can be updated using the original update sheet. Thank you![/size] [rule] [url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]UPDATE 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] I've used this tracker for a couple of years now, and it's still one of my favorites to-date! So when updates came to a halt around July 2018, I stepped in and continued updating it for everyone who used it. Eventually, updating via the old thread got confusing and cluttered, especially for newer users, who had trouble finding the updated sheets I was producing. In order to combat that, I've decided to make a new thread to keep things a bit more accurate, organized, and up-to-date! Here you'll find the update sheet and my newer version of the sheet! I've also added navigational links at the top of this post, which will take you to tutorials, the bug/error submission form, the art/graphics submission form, and my most recent post (which will list the specific changes or additions I've made to the sheet). Due to not having full permission from the previous owner, I will not be providing the classic Ravenmoon sheet on this thread. Under certain circumstances/upon request I can provide a link to the fully-updated classic sheet to those who need it; otherwise, please see the original thread [url=https://www1.flightrising.com/forums/gde/1435146/1#post_1435146]here[/url]. [center][b]Note: I will no longer be providing cosmetic and feature upgrades to the classic Ravenmoon sheet. For full access to new features and upgrades, please use the new sheet.[/b][/center] [center][url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]BLANK TEMPLATE SHEET[/url][/center] [center][url=https://docs.google.com/spreadsheets/d/148ZssVtaiK93M-Z2VuxgkmpZNTHxgn4K-h6GSkGhU7k/edit?usp=sharing]BLANK TEMPLATE SHEET (DARK VERSION)[/url][/center] [center]To create your own copy of this template, simply: 1. Follow the link 2. Go to "File --> Make a Copy" 3. Rename your sheet and save it to your drive [/center] I will be posting updates to the "Update Sheet", linked near the top of this post! Directions to update your sheet will be on the very first page/tab of your tracker; if you need additional aid, please refer to my tutorials section! [center]Update Sheet tab color guide: [color=orange][b]Current[/b][/color] | [color=blue][b]Classic[/b][/color] | [color=green][b]Both[/b][/color][/center]
PbTEhvI.png


Hey everyone!

I'd like to thank Ravenmoon for creating this sheet years ago, and users like Flurry who have updated it up until 2018. I don't take ownership of the original sheet, and thus will not change the core aesthetics, functionality, and structure of it. If at any time Flurry returns to Flight Rising and would like to take over the sheet, I will be handing full control over to them.

In order to introduce new features and aesthetic updates, I've created a streamlined, visually cohesive version of the sheet that will be available in replacement of Ravenmoon's original sheet. Both can be updated using the original update sheet.

Thank you!


UPDATE SHEET

PINGLIST

PINGLIST REMOVAL

I've used this tracker for a couple of years now, and it's still one of my favorites to-date! So when updates came to a halt around July 2018, I stepped in and continued updating it for everyone who used it. Eventually, updating via the old thread got confusing and cluttered, especially for newer users, who had trouble finding the updated sheets I was producing. In order to combat that, I've decided to make a new thread to keep things a bit more accurate, organized, and up-to-date!

Here you'll find the update sheet and my newer version of the sheet! I've also added navigational links at the top of this post, which will take you to tutorials, the bug/error submission form, the art/graphics submission form, and my most recent post (which will list the specific changes or additions I've made to the sheet).

Due to not having full permission from the previous owner, I will not be providing the classic Ravenmoon sheet on this thread. Under certain circumstances/upon request I can provide a link to the fully-updated classic sheet to those who need it; otherwise, please see the original thread here.
Note: I will no longer be providing cosmetic and feature upgrades to the classic Ravenmoon sheet. For full access to new features and upgrades, please use the new sheet.


To create your own copy of this template, simply:

1. Follow the link
2. Go to "File --> Make a Copy"
3. Rename your sheet and save it to your drive

I will be posting updates to the "Update Sheet", linked near the top of this post! Directions to update your sheet will be on the very first page/tab of your tracker; if you need additional aid, please refer to my tutorials section!
Update Sheet tab color guide:
Current | Classic | Both
3 hours ahead of FR time
BUG AND ERROR REPORTS

Main Page | Bug Report/Tutorials+FAQ | Art + Graphic Submissions


So, you've come across a bug? Or maybe you've noticed an error like spelling mistakes or incorrect information? Please fill out this form so that I can get a better idea of what you've found!


For general questions about the sheets, please refer to the Tutorials section or check out the FAQ! It might also help to google your question!

Does your problem require a little more TLC? Fear not! Send me a PM and we can get to the bottom of this together!


TUTORIALS AND FAQ


Are you stuck on something and require some visual aid? There will be a collection of Youtube tutorials available here soon! In the meantime, Google offers some great resources for working with the various tools and features offered by Sheets. If you are unable to find the answer you need, feel free to PM me or reach out here for help!

How To Update: Fiona Feats Tab (DOC)
Adding Rows and Fixing Borders (VIDEO) --Note: This is the old sheet, but the steps are still the same!
How To Update: Coliseum Tab (DOC)

Just want a quick answer to a simple question? Here's the FAQ!

FAQ
Note/Disclaimer: some of these are from the FAQ section of Flurry's thread!
What is the difference between Undiscovered, Discovered, and Acquired?

These are the distinctions for Ownership Status! Currently, the definitions for each are as follows:
  • Undiscovered - Neither awakened nor owned. This refers to any familiars you have never owned or no longer own that have bonding progress below Awakened; typically, familiars bonded with at Fiona's fall under this category.
  • Discovered - Awakened, but not owned. This refers to familiars you have Awakened at Fiona's that you don't own, or Awakened familiars you no longer own.
  • Acquired - Owned, regardless of bond status. You must own a copy of a familiar for it to be considered Acquired.

These are based on how entries are now counted in the Bestiary; familiars you own copies of appear automatically, while familiars you don't physically own but have bonded with appear when they reach Awakened. Ownership status is different from bonding progress, which changes regardless of Bestiary ownership status.

New familiars are missing the dropdown list(s) on my spreadsheet.

Data validation doesn't transfer over when you copy from one sheet to another, so you'll need to copy them from other entries in your sheet. Pre-pasting them may mess with the Statistics page, so try to add them only as you copy over new entries.

For larger batches, you can extend the drop-down list formatting by hovering over the bottom right corner of a properly formatted cell until your cursor turns into a +. Then, click and drag to extend this formatting into other cells.

The dropdown lists stay gray when they're not on "Locked"/words aren't changing color when they're supposed to

Looks like the conditional formatting isn't working properly!

The easiest way to fix this is to:
  1. Go to the blank template for your version of the sheet
  2. Copy the specific cells you're having problems with from the blank sheet
  3. Paste over the old problematic cells on your own sheet
  4. Check and see if it works!

If this doesn't work, you might have to manually change the conditional formatting. I'll have a tutorial made for this soon.

A new familiar is out, but it's not on the update sheet. Why?

I try to update as frequently as I can, but sometimes life gets in the way. Schoolwork, illness, and mental health may all be potential reasons for a late update. If you notice that I haven't added the new familiar the day of its release, don't worry; it will be added within 48 hours of the update or I will make a quick post explaining why it's late.

There was a change made to a familiar's source/obtaining requirements/name/etc, but you haven't reflected this on the sheet!

Sometimes I miss little changes like this, as they are often shoved in with a larger update. Just submit an error report or ping me here and I'll fix it ASAP.

Help! The auto-update features of (tab name) aren't working anymore!

This might happen for a few reasons, but the main two tend to be:
  • The familiar name in the main tracking tab doesn't match with the one on the tab in question
  • The formula's latching onto the wrong cell

Make sure to check these before sending in a PM!

There's no more room on (tab name/section) for familiars!

This is bound to happen at some point, but luckily it's an easy fix!

To add one or multiple rows/columns in-between other entries:
  • Right-click on the label of the row/column you wish to add a new one next to.
  • To add multiple, shift-click the number of rows/columns you wish to add.
  • Click "insert one above"/"insert one below" to add a new row, or "insert one left"/"insert one right" for columns. For multiple entries, the options will include the number of rows you've selected.
  • The new row(s)/column(s) should be added where you want them!

This process works for all tabs, but there's another method for adding rows to the Regular Familiars tab that is less complicated. At the bottom of the page, there's an option with a number input box to add more rows! Click it to automatically add the number of rows specified from the last current row. This option isn't available for columns.
BUG AND ERROR REPORTS

Main Page | Bug Report/Tutorials+FAQ | Art + Graphic Submissions


So, you've come across a bug? Or maybe you've noticed an error like spelling mistakes or incorrect information? Please fill out this form so that I can get a better idea of what you've found!


For general questions about the sheets, please refer to the Tutorials section or check out the FAQ! It might also help to google your question!

Does your problem require a little more TLC? Fear not! Send me a PM and we can get to the bottom of this together!


TUTORIALS AND FAQ


Are you stuck on something and require some visual aid? There will be a collection of Youtube tutorials available here soon! In the meantime, Google offers some great resources for working with the various tools and features offered by Sheets. If you are unable to find the answer you need, feel free to PM me or reach out here for help!

How To Update: Fiona Feats Tab (DOC)
Adding Rows and Fixing Borders (VIDEO) --Note: This is the old sheet, but the steps are still the same!
How To Update: Coliseum Tab (DOC)

Just want a quick answer to a simple question? Here's the FAQ!

FAQ
Note/Disclaimer: some of these are from the FAQ section of Flurry's thread!
What is the difference between Undiscovered, Discovered, and Acquired?

These are the distinctions for Ownership Status! Currently, the definitions for each are as follows:
  • Undiscovered - Neither awakened nor owned. This refers to any familiars you have never owned or no longer own that have bonding progress below Awakened; typically, familiars bonded with at Fiona's fall under this category.
  • Discovered - Awakened, but not owned. This refers to familiars you have Awakened at Fiona's that you don't own, or Awakened familiars you no longer own.
  • Acquired - Owned, regardless of bond status. You must own a copy of a familiar for it to be considered Acquired.

These are based on how entries are now counted in the Bestiary; familiars you own copies of appear automatically, while familiars you don't physically own but have bonded with appear when they reach Awakened. Ownership status is different from bonding progress, which changes regardless of Bestiary ownership status.

New familiars are missing the dropdown list(s) on my spreadsheet.

Data validation doesn't transfer over when you copy from one sheet to another, so you'll need to copy them from other entries in your sheet. Pre-pasting them may mess with the Statistics page, so try to add them only as you copy over new entries.

For larger batches, you can extend the drop-down list formatting by hovering over the bottom right corner of a properly formatted cell until your cursor turns into a +. Then, click and drag to extend this formatting into other cells.

The dropdown lists stay gray when they're not on "Locked"/words aren't changing color when they're supposed to

Looks like the conditional formatting isn't working properly!

The easiest way to fix this is to:
  1. Go to the blank template for your version of the sheet
  2. Copy the specific cells you're having problems with from the blank sheet
  3. Paste over the old problematic cells on your own sheet
  4. Check and see if it works!

If this doesn't work, you might have to manually change the conditional formatting. I'll have a tutorial made for this soon.

A new familiar is out, but it's not on the update sheet. Why?

I try to update as frequently as I can, but sometimes life gets in the way. Schoolwork, illness, and mental health may all be potential reasons for a late update. If you notice that I haven't added the new familiar the day of its release, don't worry; it will be added within 48 hours of the update or I will make a quick post explaining why it's late.

There was a change made to a familiar's source/obtaining requirements/name/etc, but you haven't reflected this on the sheet!

Sometimes I miss little changes like this, as they are often shoved in with a larger update. Just submit an error report or ping me here and I'll fix it ASAP.

Help! The auto-update features of (tab name) aren't working anymore!

This might happen for a few reasons, but the main two tend to be:
  • The familiar name in the main tracking tab doesn't match with the one on the tab in question
  • The formula's latching onto the wrong cell

Make sure to check these before sending in a PM!

There's no more room on (tab name/section) for familiars!

This is bound to happen at some point, but luckily it's an easy fix!

To add one or multiple rows/columns in-between other entries:
  • Right-click on the label of the row/column you wish to add a new one next to.
  • To add multiple, shift-click the number of rows/columns you wish to add.
  • Click "insert one above"/"insert one below" to add a new row, or "insert one left"/"insert one right" for columns. For multiple entries, the options will include the number of rows you've selected.
  • The new row(s)/column(s) should be added where you want them!

This process works for all tabs, but there's another method for adding rows to the Regular Familiars tab that is less complicated. At the bottom of the page, there's an option with a number input box to add more rows! Click it to automatically add the number of rows specified from the last current row. This option isn't available for columns.
3 hours ahead of FR time
ART + GRAPHICS SUBMISSIONS

Main Page | Bug Report/Tutorials+FAQ | Art + Graphic Submissions


Most updates are released with a header image; sometimes it's a cute cat gif, and others it's a piece of artwork.

As an artist, I want to give the opportunity to other artists to have their art shared! If you're interested in having your artwork displayed for an update, just fill out the form below!


Acceptable submissions include:
  • illustrations and spot illustrations
  • gifs/animations (in gif format)
  • pixel art
  • FR-related character/dragon art (gijinkas, OCs, fanart, etc)

Make sure to keep entry sizes between 300px and 500px and at 72dpi.

Adoptables, non-FR artwork, and artwork that violates FR rules will not be accepted. If you have a piece of art that isn't inherently FR-based but is close in nature, however, feel free to submit it anyway! I just don't want to feature fanart of an unrelated franchise on a Flight Rising tracker. Artwork of fandragons is okay as long as it's clear that it's the fandragon being depicted and not the actual character.

Please submit ORIGINAL works. If you didn't make it, don't submit it.
ART + GRAPHICS SUBMISSIONS

Main Page | Bug Report/Tutorials+FAQ | Art + Graphic Submissions


Most updates are released with a header image; sometimes it's a cute cat gif, and others it's a piece of artwork.

As an artist, I want to give the opportunity to other artists to have their art shared! If you're interested in having your artwork displayed for an update, just fill out the form below!


Acceptable submissions include:
  • illustrations and spot illustrations
  • gifs/animations (in gif format)
  • pixel art
  • FR-related character/dragon art (gijinkas, OCs, fanart, etc)

Make sure to keep entry sizes between 300px and 500px and at 72dpi.

Adoptables, non-FR artwork, and artwork that violates FR rules will not be accepted. If you have a piece of art that isn't inherently FR-based but is close in nature, however, feel free to submit it anyway! I just don't want to feature fanart of an unrelated franchise on a Flight Rising tracker. Artwork of fandragons is okay as long as it's clear that it's the fandragon being depicted and not the actual character.

Please submit ORIGINAL works. If you didn't make it, don't submit it.
3 hours ahead of FR time
[center][img]https://media.giphy.com/media/achoDiZFxZvdm/giphy.gif[/img] [emoji=firework size=1] [b]New Thread + Fiona Feats 5![/b] [emoji=firework 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] It's the big day! The thread move is complete, and all updates will be here from now on. Feel free to leave some feedback on the thread, the sheet, or both! [center][b]Fiona Feats 5[/b][/center] The [b]new Fiona Feats familiars[/b] have been added! You can find the entries on the "Fiona Feats" tab on the update sheet as well as the blank. The entries don't have their formulas or conditional formatting (they wouldn't copy over correctly during experimentation), so you'll need to copy them from other entries on your sheet. The completion status formula is different for each tier, so be sure to copy-paste them to the correct ones. Here's the general layout for each formula, so you can double-check. 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 ='"&CELLHERE&"'";-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] If you have any issues updating this section of the sheet, please let me know! It sounds super complicated but I promise it's a quick adjustment. [center][b]The thread + the new sheet[/b][/center] You may notice right away that I've only linked the new sheet. This is intentional! I've decided to not offer the original sheet for use unless requested. My reasons behind this decision are as follows: [LIST] [*]I lack full permission from Flurry, who never returned to give me the go-ahead, or Ravenmoon, who seems to also no longer play, to distribute the original sheet. [*]The original sheet and new sheet are the same, functionally, so I don't see a reason to include an outdated version alongside its updated version for new sheet users. [*]I plan on releasing versions of the sheet that are more accessible to those with old computers, visual impairments, or migraines (dark mode, large text, text only, etc), so whatever beneficial cosmetic features the old sheet has will inevitably be offered by other versions of the updated one. [*]It's easier for me to focus on major issues pertaining to one sheet. [/LIST] Classic sheet users: I will still be updating the old sheet using the current update sheet! I will still be offering the fully-updated classic sheet to those who ask, especially those who return and need an overhaul of their outdated personal sheets. I just won't be linking the main sheet on the main post. The Update Sheet now offers updates for the classic sheet (blue) and the current sheet (orange)! The Coliseum and Gathering Guide update tabs should work for both versions (green). Some fixes to the new sheet: [LIST] [*]Adjusted the number figures for the drop-down lists for each bonding tier; Wary (0) is now Wary (1), and so on. This was done to remain consistent with the site bonding tiers, which were changed with Fiona's release. [*]Adjusted the formulas for the Fiona Feats tab to account for the changes above. [*]Adjusted the formulas for the Fiona Feats "Relaxed" completion status box, which counted when hitting "Tolerant". This should no longer happen. [/LIST] I'll be rolling out a survey with the BSJ update in regards to the new sheet. I want to know what things you all like, and what things aren't working quite as well, so I can make these adjustments early in the sheet's lifespan! [center][b]Fixes to the classic sheet[/b][/center] I've made some additional fixes to the old sheet, mainly in regards to the Fiona Feats tab. [LIST] [*]Added missing Fiona-exclusive familiars -- this affected all Feats from Swallowtail Jumper to Aragonite Haunt, including the Feats for said familiars. [*]Fixed the formulas for the Slight Eyewing Feats, which accounted for two familiars when there was only one. [*]Adjusted the treasure/gem rewards for Feats relating to the Slight Eyewing and Coliseum Bosses. [/LIST] If you catch anything else, let me know! Thanks for sticking with me! Happy tracking! [emoji=coatl tongue size=1][emoji=bestiary size=1] [rule] [center][size=1][emoji=scroll size=1] [/size][/center]
giphy.gif

New Thread + Fiona Feats 5!


It's the big day! The thread move is complete, and all updates will be here from now on. Feel free to leave some feedback on the thread, the sheet, or both!
Fiona Feats 5

The new Fiona Feats familiars have been added! You can find the entries on the "Fiona Feats" tab on the update sheet as well as the blank. The entries don't have their formulas or conditional formatting (they wouldn't copy over correctly during experimentation), so you'll need to copy them from other entries on your sheet. The completion status formula is different for each tier, so be sure to copy-paste them to the correct ones.

Here's the general layout for each formula, so you can double-check. CELL = column letter + row number. Note: Wary (1) is Wary (0) on the classic sheet.
Bonding Level Indicator wrote:
Code:
=INDEX(QUERY('Regular Familiars'!$C:$D;"select D where C ='"&CELLHERE&"'";-1))
Relaxed Tier Completion wrote:
Code:
=IF(OR(CELL1="Locked";CELL1="Wary (1)";CELL1="Tolerant (2)";CELL2="Locked";CELL2="Wary (1)";CELL2="Tolerant (2)"); "Incomplete"; "Complete")
Companion Tier Completion wrote:
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")
Awakened Tier Completion wrote:
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")

If you have any issues updating this section of the sheet, please let me know! It sounds super complicated but I promise it's a quick adjustment.
The thread + the new sheet

You may notice right away that I've only linked the new sheet. This is intentional! I've decided to not offer the original sheet for use unless requested. My reasons behind this decision are as follows:
  • I lack full permission from Flurry, who never returned to give me the go-ahead, or Ravenmoon, who seems to also no longer play, to distribute the original sheet.
  • The original sheet and new sheet are the same, functionally, so I don't see a reason to include an outdated version alongside its updated version for new sheet users.
  • I plan on releasing versions of the sheet that are more accessible to those with old computers, visual impairments, or migraines (dark mode, large text, text only, etc), so whatever beneficial cosmetic features the old sheet has will inevitably be offered by other versions of the updated one.
  • It's easier for me to focus on major issues pertaining to one sheet.
Classic sheet users: I will still be updating the old sheet using the current update sheet! I will still be offering the fully-updated classic sheet to those who ask, especially those who return and need an overhaul of their outdated personal sheets. I just won't be linking the main sheet on the main post.

The Update Sheet now offers updates for the classic sheet (blue) and the current sheet (orange)! The Coliseum and Gathering Guide update tabs should work for both versions (green).

Some fixes to the new sheet:
  • Adjusted the number figures for the drop-down lists for each bonding tier; Wary (0) is now Wary (1), and so on. This was done to remain consistent with the site bonding tiers, which were changed with Fiona's release.
  • Adjusted the formulas for the Fiona Feats tab to account for the changes above.
  • Adjusted the formulas for the Fiona Feats "Relaxed" completion status box, which counted when hitting "Tolerant". This should no longer happen.

I'll be rolling out a survey with the BSJ update in regards to the new sheet. I want to know what things you all like, and what things aren't working quite as well, so I can make these adjustments early in the sheet's lifespan!
Fixes to the classic sheet

I've made some additional fixes to the old sheet, mainly in regards to the Fiona Feats tab.
  • Added missing Fiona-exclusive familiars -- this affected all Feats from Swallowtail Jumper to Aragonite Haunt, including the Feats for said familiars.
  • Fixed the formulas for the Slight Eyewing Feats, which accounted for two familiars when there was only one.
  • Adjusted the treasure/gem rewards for Feats relating to the Slight Eyewing and Coliseum Bosses.
If you catch anything else, let me know!

Thanks for sticking with me! Happy tracking!



3 hours ahead of FR time
Thank you so much!
Thank you so much!
Sweeeeet
Sweeeeet
Namesake Dragon
92n1dwB.pngeswSnrS.pngDa1cz0f.png2VCdrqz.png
UuKod4C.pnglSkSEUZ.png0HBKL8H.pngYMPbu9R.png
Oh a dark mode would be lovely, I have severe chronic migraines and I saw you mentioned that as something that could be coming. Thank you for maintaining this!
Oh a dark mode would be lovely, I have severe chronic migraines and I saw you mentioned that as something that could be coming. Thank you for maintaining this!
X6Uoodf.png
xey/xem/xyr, fae/faen/faer, or they/them/their - FR+3
thank you so much!
thank you so much!
vCPT6OV.png 12.png 13.png 19.png
@ElvenArtist

I've been meaning to mention this, but I've added a column to keep track of Familiars placed in the Vault to my original sheet, inserted to the right of the 'In Hoard' column. I haven't bothered with updating the summary tab yet to update the formulas there to account for that part, but I think it might be a good addition to make to the new sheet as well.

Really excited & looking forward to that dark mode, that will help me SO MUCH.

Thanks so much!

EDIT: I also noticed the Unfinished rows in Baldwin's & Swipp's tabs don't have the drop down option to change them to Finished.
@ElvenArtist

I've been meaning to mention this, but I've added a column to keep track of Familiars placed in the Vault to my original sheet, inserted to the right of the 'In Hoard' column. I haven't bothered with updating the summary tab yet to update the formulas there to account for that part, but I think it might be a good addition to make to the new sheet as well.

Really excited & looking forward to that dark mode, that will help me SO MUCH.

Thanks so much!

EDIT: I also noticed the Unfinished rows in Baldwin's & Swipp's tabs don't have the drop down option to change them to Finished.
MRMeAKr.png
[center][img]https://i.imgur.com/dkl7XOr.png[/img] [emoji=light rune size=1] [b]Brightshine Jubilee 2020[/b] [emoji=light 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] Happy BSJ 2020! Seems we'll have an interesting cycle of familiars, apparel, and scenes this season. The Brightshine banner has returned, but I'm looking to roll out a new style for the rest of the festival cycle as I draw closer to finishing all the leftover graphics. I've added the new familiar, [b]Shining Cancer[/b], to the update and blank sheets. For those using the new sheet, check the orange tabs.. Those who use the original sheet, you'll find your version under the blue tab. If you came from the old thread and have been using the new sheet since its initial release, feel free to start filling out this survey! If you just recently started using it, you're welcome to fill this out as well; I'll be leaving it open until Thundercrack! I'm using this survey as a general gauge of what to prioritize when moving forward with updates, fixes, and additions; if you have additional feedback that you weren't able to put on the form, don't hesitate to leave it here or in my PMs! [center][b][url=https://docs.google.com/forms/d/e/1FAIpQLScXgJq3yKGNuzIt6F6vHJIIkDstOM2KZ2hUMrt3pWfOill1mw/viewform?usp=sf_link]Sheets Familiar Tracker 1.0 SURVEY[/url][/b][/center] As far as alternative versions of the sheet, the Dark theme will be rolling out soon! I need to wrap up formatting and do some testing with Chrome's Dark browser theme before a full release, but it should be all ready-to-go by the next familiar release. Best of luck with grinding, and I hope you all have a great festival! [emoji=coatl star size=1][emoji=gold star size=1] [rule] [center][size=1][emoji=scroll size=1] [/size][/center]
dkl7XOr.png

Brightshine Jubilee 2020


Happy BSJ 2020! Seems we'll have an interesting cycle of familiars, apparel, and scenes this season. The Brightshine banner has returned, but I'm looking to roll out a new style for the rest of the festival cycle as I draw closer to finishing all the leftover graphics.

I've added the new familiar, Shining Cancer, to the update and blank sheets. For those using the new sheet, check the orange tabs.. Those who use the original sheet, you'll find your version under the blue tab.

If you came from the old thread and have been using the new sheet since its initial release, feel free to start filling out this survey! If you just recently started using it, you're welcome to fill this out as well; I'll be leaving it open until Thundercrack! I'm using this survey as a general gauge of what to prioritize when moving forward with updates, fixes, and additions; if you have additional feedback that you weren't able to put on the form, don't hesitate to leave it here or in my PMs!

As far as alternative versions of the sheet, the Dark theme will be rolling out soon! I need to wrap up formatting and do some testing with Chrome's Dark browser theme before a full release, but it should be all ready-to-go by the next familiar release.

Best of luck with grinding, and I hope you all have a great festival!



3 hours ahead of FR time
1 2 3 4 5 6 7 ... 16 17