Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | [spreadsheet] lair census!
1 2 3 4 5 6 7 ... 11 12
[center][img]https://i.imgur.com/4MNxk6z.png[/img] hello there! [emoji=pink star size=1][/center] after thinking to myself "surely i don't have [i]that[/i] many gene projects left", i decided i would find out just how many i had! and as someone who loves to make spreadsheets to visualize all sorts of data, i turned to google sheets... and from there, the dragon lair census came into being! currently, the spreadsheet is used for keeping track of info about your lair including dragons names, id #s, colours, genes, birthdays, flight, and more! and with that info, it'll conveniently make colourful graphs for you to enjoy~ there are instructions for how to start your own lair census on the first tab of the sheet below! if you have any questions or experience any issues, please don't hesitate to let me know! i'm always thinking of new graphs and data that can be included, so if you have any suggestions, please share them with me~ :3 [center][url=https://docs.google.com/spreadsheets/d/1IRY04vjcBbgOqEmKQOXy--qAJo3uOs7inY08j-VS3Vc/edit?usp=sharing][b][size=4]lair census spreadsheet template[/size][/b][/url] to see a live example, my own lair census is [url=https://docs.google.com/spreadsheets/d/1u2FOFI3d3fzQuYpgF2CWuZqkD0547n9vb_RajqAqtCc/edit?usp=sharing]here[/url]! [url=https://i.imgur.com/eMm7ydn.png][img]https://i.imgur.com/eMm7ydn.png[/img][/url][/center] ----- [center][size=4][b]recent updates[/b][/size][/center] [b]04.25 -- [url=https://www1.flightrising.com/forums/gde/3104245/12#post_56669364]add dusthides, new genes, new eye types, colour graph[/url][/b] [size=2]02.18 -- [url=https://www1.flightrising.com/forums/gde/3104245/11#post_56211682][color=#777]add new genes[/color][/url] 01.28 -- [url=https://www1.flightrising.com/forums/gde/3104245/10#post_55141045][color=#777]add new genes, sandsurges, 2024 birth year[/color][/url] 09.25 -- [url=https://www1.flightrising.com/forums/gde/3104245/10#post_55141045][color=#777]add new genes & sandsurges[/color][/url] 06.16 -- [url=https://www1.flightrising.com/forums/gde/3104245/10#post_54400465][color=#777]add new genes[/color][/url] 04.26 -- [url=https://www1.flightrising.com/forums/gde/3104245/7#post_54050175][color=#777]add new genes, track eye types, size, sex/gender dispersion[/color][/url] 03.22 -- [url=https://www1.flightrising.com/forums/gde/3104245/6#post_53737981][color=#777]add new genes, track most & least fav colours[/url] 10.15 -- [url=https://www1.flightrising.com/forums/gde/3104245/5#post_52479315][color=#777]add points tert[/url] 09.04 -- [url=https://www1.flightrising.com/forums/gde/3104245/5#post_52151801][color=#777]add soap tert[/url] 05.21 -- [url=https://www1.flightrising.com/forums/gde/3104245/4#post_51309259][color=#777]add new genes, g1 tracking[/url] 04.09 -- [url=https://www1.flightrising.com/forums/gde/3104245/4#post_50910087][color=#777]bug fix: breeds graph data range too short[/url] 03.26 -- [url=https://www1.flightrising.com/forums/gde/3104245/3#post_50762845][color=#777]permababy and silhouette tracking, light flight formula fix[/url] 03.20 -- [url=https://www1.flightrising.com/forums/gde/3104245/2#post_50706768][color=#777]highlight shared birthdays, birth year graph, double/triple tracking, typo fixes[/url] 03.04 -- [url=https://www1.flightrising.com/forums/gde/3104245/1#post_50522338][color=#777]aberration genes, typo fix, levels[/url] 02.14 -- [url=https://www1.flightrising.com/forums/gde/3104245#post_50351711][color=#777]add more gender identities[/url][/size] ----- [center][size=4][b]updates pinglist[/b][/size] [pinglist=20216] [size=4][b]special thanks[/b][/size] felwinter for the g1 tracking suggestion! galactina for the [url=https://www1.flightrising.com/forums/gde/3104245/2#post_50690860]birth year tracking suggestion[/url]! cantrip for the [url=https://www1.flightrising.com/forums/gde/3104245/3#post_50755899]permababy tracking suggestion[/url]! laetificat for the [url=https://www1.flightrising.com/forums/gde/3104245/3#post_50770599]colour tracking suggestion[/url]! cadaver for the [url=https://www1.flightrising.com/forums/gde/3104245/6#post_53999193]eye type, size, and sex/gender dispersion tracking suggestion[/url]! bailysis for the [url=https://www1.flightrising.com/forums/gde/3104245/11#post_56667042]colour graph[/url]! [url=https://www1.flightrising.com/forums/gde/3104245#post_50519126]plaguer0dent[/url], [url=https://www1.flightrising.com/forums/gde/3104245/2#post_50525905]ghostrobots[/url], [url=https://www1.flightrising.com/forums/gde/3104245/2#post_50536919]fluteloops0329[/url], [url=https://www1.flightrising.com/forums/gde/3104245/2#post_50697005]redware[/url], [url=https://www1.flightrising.com/forums/gde/3104245/3#post_50755899]cantrip[/url], [url=https://www1.flightrising.com/forums/gde/3104245/6#post_53738941]finlandia[/url], [url=https://www1.flightrising.com/forums/gde/3104245/10#post_55188279]aspencrow[/url], and [url=https://www1.flightrising.com/forums/gde/3104245/12#post_56669289]drshadowc[/url] for detecting typos and bugs!
4MNxk6z.png

hello there!
after thinking to myself "surely i don't have that many gene projects left", i decided i would find out just how many i had! and as someone who loves to make spreadsheets to visualize all sorts of data, i turned to google sheets...

and from there, the dragon lair census came into being!

currently, the spreadsheet is used for keeping track of info about your lair including dragons names, id #s, colours, genes, birthdays, flight, and more! and with that info, it'll conveniently make colourful graphs for you to enjoy~

there are instructions for how to start your own lair census on the first tab of the sheet below! if you have any questions or experience any issues, please don't hesitate to let me know! i'm always thinking of new graphs and data that can be included, so if you have any suggestions, please share them with me~ :3
lair census spreadsheet template

to see a live example, my own lair census is here!

eMm7ydn.png

recent updates
04.25 -- add dusthides, new genes, new eye types, colour graph
02.18 -- add new genes
01.28 -- add new genes, sandsurges, 2024 birth year
09.25 -- add new genes & sandsurges
06.16 -- add new genes
04.26 -- add new genes, track eye types, size, sex/gender dispersion
03.22 -- add new genes, track most & least fav colours
10.15 -- add points tert
09.04 -- add soap tert
05.21 -- add new genes, g1 tracking
04.09 -- bug fix: breeds graph data range too short
03.26 -- permababy and silhouette tracking, light flight formula fix
03.20 -- highlight shared birthdays, birth year graph, double/triple tracking, typo fixes
03.04 -- aberration genes, typo fix, levels
02.14 -- add more gender identities


updates pinglist


special thanks
felwinter for the g1 tracking suggestion!
galactina for the birth year tracking suggestion!
cantrip for the permababy tracking suggestion!
laetificat for the colour tracking suggestion!
cadaver for the eye type, size, and sex/gender dispersion tracking suggestion!
bailysis for the colour graph!

plaguer0dent, ghostrobots, fluteloops0329, redware, cantrip, finlandia, aspencrow, and drshadowc for detecting typos and bugs!
2P6JHiP.png
Love it! It was really fun to watch you create this from the ground up!
Love it! It was really fun to watch you create this from the ground up!
@xefine
thank you!!!! n thank you for always giving me the best ideas to include!!
♥ ♥ ♥ ♥
@xefine
thank you!!!! n thank you for always giving me the best ideas to include!!
♥ ♥ ♥ ♥
2P6JHiP.png
update -- 2/14/2022

added in an update to allow for tracking gender as opposed to biological sex, as well as the option to account for transman/transwoman, non-binary, and other gender identities! the main sheet is updated to reflect this, but here's an update sheet to update your own:

update sheet

(this is the first spreadsheet i've released publicly, so please let me know if you have any issues with updating your sheet! "orz)
update -- 2/14/2022

added in an update to allow for tracking gender as opposed to biological sex, as well as the option to account for transman/transwoman, non-binary, and other gender identities! the main sheet is updated to reflect this, but here's an update sheet to update your own:

update sheet

(this is the first spreadsheet i've released publicly, so please let me know if you have any issues with updating your sheet! "orz)
2P6JHiP.png
Oh wow this is so neat! big props for adding extra genders :D I cant wait to do this >:3c
Oh wow this is so neat! big props for adding extra genders :D I cant wait to do this >:3c
HglzBbg.png
oh this looks really neat, i used to have a spreadsheet with all my dragons but that's hella outdated (and didnt have any charts or anything) i might try this one out!
oh this looks really neat, i used to have a spreadsheet with all my dragons but that's hella outdated (and didnt have any charts or anything) i might try this one out!
Stix | he/him | FR+3 | Avatar
This looks fun! I'll havta use it
This looks fun! I'll havta use it
This is super cool! Thank you!!
This is super cool! Thank you!!
.................. envy.pngshadowbinder.png xion.png
nenim.png
genderfaun.png
androsexual.png
autistic.png
skyrim.png
daayujd-30971d57-311d-4b66-aac9-dcd49a699727.gifkuro.png
I have 2 things, My spreadsheet doesnt seem to be counting my sphinxmoth genes! I have several dragons with the trait but the raw data still has 0
Also, maybe add a graph for dragon breeds too? And maybe top 10-15 most colors too!!
I have 2 things, My spreadsheet doesnt seem to be counting my sphinxmoth genes! I have several dragons with the trait but the raw data still has 0
Also, maybe add a graph for dragon breeds too? And maybe top 10-15 most colors too!!
.................. envy.pngshadowbinder.png xion.png
nenim.png
genderfaun.png
androsexual.png
autistic.png
skyrim.png
daayujd-30971d57-311d-4b66-aac9-dcd49a699727.gifkuro.png
update -- mar. 04, 2022

- added aberration genes
- fixed a typo for the veilspun "sphinxmoth" gene
- added the ability to track dragon levels (currently # of level 25 dragons and <=7)

update sheet


@plaguer0dent
hello hello!
thank you for letting me know about the issues with sphinxmoth; turns out there was a typo in the formula, which i've added a fix for in the update that includes the new abberation genes above! there should already be a graph that tracks dragon breeds, but please let me know if for some reason it's not cooperating for you!
adding in most colours might be a bit difficult due to how the data is currently organized, but i'll play around with it and see if i can get something working! :D
update -- mar. 04, 2022

- added aberration genes
- fixed a typo for the veilspun "sphinxmoth" gene
- added the ability to track dragon levels (currently # of level 25 dragons and <=7)

update sheet


@plaguer0dent
hello hello!
thank you for letting me know about the issues with sphinxmoth; turns out there was a typo in the formula, which i've added a fix for in the update that includes the new abberation genes above! there should already be a graph that tracks dragon breeds, but please let me know if for some reason it's not cooperating for you!
adding in most colours might be a bit difficult due to how the data is currently organized, but i'll play around with it and see if i can get something working! :D
2P6JHiP.png
1 2 3 4 5 6 7 ... 11 12