Guides

@ChibiFluffy I noticed an error in the Census tab. The "Most Common" section is in the way of average sizes for the Undertide and Aether breeds. I fixed my copy by shifting "Most Common," "Odds and Ends," "Color Ranges," and "Color Patterns" two cells down, and then copying over the averages formulas in the newly cleared spaces. It auto changed which cell was being referenced at the very start of the formula for me which made it super easy (no brain damage necessary). Nor does this seem to have broken anything.

@FredTheCloud thank you for noticing!!

I've made the update to the sheets, now version 5.7.3

@ChibiFluffy Um so when I try and use the Projects and Pairings tab nothing works. I've tried re inputting data and refreshing the sheet but nothing seems to be working. All the data is inputted correctly as far as I know but nothing is working.

Any help would be appreciated.

[quote name="ThePoliceQueen" date="2023-05-22 20:32:03" ] Um so when I try and use the Projects and Pairings tab nothing works. I've tried re inputting data and refreshing the sheet but nothing seems to be working. All the data is inputted correctly as far as I know but nothing is working. Any help would be appreciated. [/quote] i had this issue i think, have you tried changing the ID column format to plain text? @thepolicequeen

@kyeran nothing happened, the tabs still don't work.

@ThePoliceQueen can you send me a pm with a copy of your sheet ?
Preferably editable :)

@ChibiFluffy I noticed an error with the food calculator. For the column showing how many of each breed are in lair and not denned, it’s referencing column AE of ref_code which is eye type, instead of column V which is Den.

@FredTheCloud thanks for the info :D Sheet updated to 5.7.4 Note to myself to rememeber to do it [url=https://www1.flightrising.com/forums/ann/3241367]Banescale genes uipdate[/url] [center][item=Primary Gene: Bar (Banescale)][item=Primary Gene: Crystal (Banescale)][item=Primary Gene: Ribbon (Banescale)][item=Primary Gene: Tide (Banescale)][item=Primary Gene: Pharaoh (Banescale)] [item=Secondary Gene: Daub (Banescale)][item=Secondary Gene: Facet (Banescale)][item=Secondary Gene: Eel (Banescale)][item=Secondary Gene: Foam (Banescale)][item=Secondary Gene: Sarcophagus (Banescale)] [item=Tertiary Gene: Monarch (Banescale)][item=Tertiary Gene: Soap (Banescale)][item=Tertiary Gene: Spines (Banescale)][/center]

[center]new genes again~ [item=tertiary gene: firebreather] [item=tertiary gene: carnivore (aberration)][item=tertiary gene: carnivore (aether)][item=tertiary gene: carnivore (banescale)][item=tertiary gene: carnivore (gaoler)] [item=tertiary gene: carnivore (undertide)][item=tertiary gene: carnivore (veilspun)][/center]