Guides

[center][b]NOTE: I am no longer actively updating this. I'll leave this resource available as is for now.[/b] [img]https://68.media.tumblr.com/2ad5fb5a044b9cda06716c98ef6f0383/tumblr_njvy7zfUKC1ttpumio1_500.png[/img] [url=https://docs.google.com/spreadsheets/d/1F-V1SSQm3BNz_NQbuV_8li-hDV4VJE1Wy5jg4ffgedM/edit?usp=sharing][b]Get a copy for yourself here! File -> Make a copy[/url] Fell free to modify the spreadsheet to better suit your needs. ----- [/center][indent] [i][B]So what does this do?[/i] You can list dragons'[LIST] [*]name & ID# [*]generation (gen 1-3, other/x*) [*]element (colour coded) [*]eye type [*]level [*]breed [*]genes & colours (latter colour coded) [*]there's also a column for additional notes [/LIST] The 'Statistics' sheet has the following:[LIST] [*]total dragon count (total & by sex) [*]count by breed & element (total & by sex) [*]count by level [*]numbers about genes & colours [/LIST] [/indent] [b]Some things to note/tips for use:[/b][LIST] [*]Total dragon count is based on ID numbers listed - this way you can leave the name blank for unnameds [*]From generation to tertiary colour, everything except level has a dropdown menu for ease of use [*]Regarding the mentioned above columns, the sheet will reject invalid input (impossible level, you typed in a colour and misspelled it, etc) [*]Everything on the Statistics sheet is calculated automatically, based on values you've given in corresponding columns on the Dragons sheet [*]You can sort your dragons by age using the ID# column (the smaller the ID, the older the dragon) [*]Sort dragons using the Sort sheet function under 'Data' [/LIST] ----- [indent] Ok so here's this thing I made primarily for myself but figured I'd share it with everybody, since this community seems to love spreadsheets :'D There are a couple of others I found [url=http://flightrising.com/main.php?p=mb&board=gde&id=1083533&page=1][1][/url] [url=http://flightrising.com/main.php?p=mb&board=gde&id=1086582&page=1][2][/url] but neither was quite what I was looking for, and they hadn't been updated in a while. [/indent] ----- [size=2]*) Since most don't care about generations beyond 2nd or 3rd, I only added so many.

16/06/21 - added new breed Obelisk
08/05/21 - added new eye types Bright & Pastel
20/03/21 - added new gene Koi
31/12/20 - added new ancient breed Veilspun & genes
10/09/20 - added new genes Stitched & Patchwork
19/06/20 - added new gene Braids
08/05/20 - added new gene Glowtail
09/04/20 - added new gene Keel
04/03/20 - added new genes Swirl & Marbled, fixed typos in gene statistics
13/12/19 - added new ancient breed Banescale & genes
22/11/19 - added new genes Fade & Blend
06/11/19 - added new gene Veined
30/09/19 - added new eye type Innocent
12/09/19 - added new genes Slime & Sludge
17/08/19 - added new genes Leopard & Clouded
17/07/19 - added new gene Blossom
08/06/19 - added new ancient breed Gaoler & genes
10/04/19 - added new genes Laced & Edged
22/03/19 - added new eye types Goat & Swirl
09/01/19 - added new gene Peacock
20/10/18 - added new genes Lionfish & Noxtide, and new eye type Dark Sclera
20/09/18 - added new gene Ringlets
09/08/18 - added new genes Starmap & Constellation
09/06/18 - added eye types as a new data column and statistics
25/05/18 - added new gene Firefly
05/05/18 - added new genes Python & Morph
23/03/18 - added new gene Filigree
14/02/18 - added new gene Ghost
23/01/18 - added new genes Pinstripe & Trail
17/12/17 - added new gene Smirch
01/10/17 - added new genes Wasp, Bee, Tapir, and Striation
01/09/17 - added new gene Capsule
16/07/17 - added new genes Jaguar and Rosette
21/05/17 - added new genes Savannah and Safari
13/04/17 - added new gene Opal
27/02/17 - added new gene Lace
30/12/16 - added new gene Alloy
10/12/16 - added new gene Scales
12/11/16 - added new gene Metallic
14/10/16 - added new gene Falcon
19/09/16 - added new breed Bogsneak
12/09/16 - added new gene Runes
07/08/16 - added new genes Skink & Spinner
06/07/16 - fixed Chartreuse & Raspberry typos in conditional formatting rules, fixed Spring conditional formatting range
29/06/16 - alphabetized breed and gene lists to match the site dropdown menus
24/06/16 - added new genes Jupiter and Saturn
23/06/16 - fixed Chartreuse typo
10/06/16 - fixed Raspberry typo
01/05/16 - added new gene Contour
28/04/16 - added missing colour Pearl to the colour drop down lists & did some minor tweaking on the conditional formatting text colours
28/04/16 - completed work for the colour update (colour coding, drop down menus, statistics)
15/04/16 - added new gene Petals
10/03/16 - fixed a typo in stats (Charcoal counts)
06/03/16 - added new genes Giraffe and Hex
17/02/16 - started the process of adding conditional formatting for new colours; I'll add these beforehand as much as I can to speed up the updating
31/01/16 - added new gene Stained; updated file link since there was an issue with the old version of the sheet (thanks Google...)
08/01/16 - added new gene Thylacine
02/12/15 - added new gene Butterfly
24/10/15 - added new genes Poison and Toxin
03/10/15 - added new gene Cherub
31/08/15 - added new gene Peregrine
08/08/15 - added new genes Piebald and Paint
18/07/15 - added new gene Glimmer
25/05/15 - corrected an error in the breed stat counters for skydancers
30/03/15 - added new genes Vipera and Hypnotic
17/02/14 - added missing spring colour coding

Whee! This looks amazing. Thank you so much for uploading it. I may even save a 2nd copy so I can use one for my clan and one for my exalted dragons. ^.^

@nightshade
bookmarking :)

Wow, thank you so much for this! It's very useful. I especially love the dropdown menus uvu

@mus
I was wondering if I could bum a copy of yours just for the color codes you used?
Unless they are coded in the spread sheet already. But I do love this concept and thanks for the info. ^_^

@Gwendolyn
The cells automatically change colour based on input (I'm assuming that's what you meant?) but yep, I'm fine with anyone modifying the sheet, using it/parts of it to create their own or whatever :)

@mus

Yes that is what meat. Thank you for answering my question. Just wanted to make sure that it was coded that way and I didn't have to play hunt for dragon color hex codes lol.