Guides

[center]Greetings, people of Sornieth! After months of work I am proud to be able to finally bring you [b][size=7][url=https://docs.google.com/spreadsheets/d/1UyJDLe2Yxd4RFqzBBsHfasXGeNOosQGnR7MEVQjHgHc/edit?usp=sharing]The Ultimate Flight Rising Breeding Project Calculator [V1.3*][/url][/size][/b] Simply enter the details of the dragon you're trying to breed for and the dragons you've got, and let the math run itself to find the most promising parent combinations![/center] ----- [center][b]HOW TO USE[/b][/center] [b]FIRSTLY:[/b] Set your target breed, colours, and genes on the [font=Courier][b]TARGET[/b][/font] Sheet. The calculator is set up for five different "save" slots, so you can work multiple projects at a time if you like (I don't recommend it, but I do it anyway because I have ADHD and cannot be stopped). [img]https://i.imgur.com/k2C7oCU.png[/img] [b]SECONDLY:[/b] Input your prospective parent dragons in the [font=Courier][b]Males[/b][/font] and [font=Courier][b]Females[/b][/font] sheets respectively! Their breeds, genes, colours, the number of the project slot they're assigned to, and the names of their parents. They will need a [b]unique name[/b], but this can just be their ID number, and can always be changed later. What matters is that they don't share it with any other dragon on the [b]same project[/b]. [img]https://imgur.com/FX8pO7P.png[/img] [b]THIRDLY:[/b] Trace your dragons' ancestry back by four generations and fill in their ancestors' names in the respective cells. By default these cells have formulae in them that pull the names from the ancestries of the individual's parents, but that isn't going to work unless those parents have their ancestries filled out, and far enough up that will inevitably mean some manual entry, in which case you can clear those cells from its row (despite permission warnings) and enter the names yourself. [img]https://i.imgur.com/OigFZc5.png[/img] [b]LASTLY:[/b] View offspring possibilities on the [font=Courier][b]VERDICT[/b][/font] sheet! Filter for all input parameters, relatedness, and compare total success likelihood for obtaining that perfect hatchling. [img]https://i.imgur.com/eG1nv3k.png[/img] ----- [center][b]TIPS:[/b][/center] [LIST] [*]There are a lot of hidden sheets running calculations behind the scenes. I'd recommend leaving them alone unless absolutely necessary. I'm happy to answer questions about the purpose they each serve and elaborate on what they do. [*]The sheet is already pretty chunky as it is, and the more dragons you add to it, the longer it will take to compute. It's currently set up with enough space to hold a hundred or so males and females each, but whether or not it can actually chug through that many on a single project remains to be seen. It is optimised to run calculations for only one project at a time, though. [*]If you need more rows on the Verdict sheet, just copy and paste the last one and the array should take care of it. [*]The logic calculation for relatedness may be incorrect if the potential pair have a set of shared great-great-grandparents, and if any of those ancestor dragons are too closely related to any of the parents of the present candidates that aren't their direct descendants. Writing around this would require every seed dragon to list over sixty ancestors, which would make the sheet gruelling to use and likely much slower. Given then how rare this circumstance is (I wrote the dang thing and it took me over three months and thousands of potential pairings to notice it at all), I am leaving the scope of the ancestry calculation as it is. [/LIST] ----- [center][size=5]To update from one version to another, copy the cells containing each dragon's information (A-K, and additionally S-AT for those with manually input ancestry - [i]do not copy entire rows[/i]) on the Males and Females sheets and paste them into the respective sheets on the new version![/size=5][/center] ----- [center]... Okay, Dorian, what is this?[/center] I've been orchestrating dragon breeding projects for years... mostly very badly. I like to use a [i]lot[/i] of dragons and check every single possible pair's viability, which meant spending hours every day manually filling tables and crunching numbers - and the tools available to me then were invaluable, but still required a great deal of my effort and time. After my last project reached fruition, I decided things had to improve. I once again checked the forums, and no one seemed to have already made anything that quite covered all the bases I was looking for. So I buckled down and (somehow) did it myself. This is really the first time I've built a spreadsheet remotely as complex and it was a huge learning experience. [b]I'd love to improve, and I'm very much open to suggestions and fixes! This was all designed with my own needs and preferences in mind, but I would like it to be as useable as possible for anyone else who wants to.[/b] There is also more troubleshooting I'd like to do on it as it is, but I wanted to get it cleaned up and make it available for further feedback and testing (and, of course, community use)! I'd also like to acknowledge and thank the creators of [url=http://fr.fintastic.net/]this colour predictor[/url], @Peixes, and [url=https://www1.flightrising.com/forums/gde/2300706#post_2300706]this pair finder[/url], @Avis, without whom I'm sure this tool could never have existed. Special thanks also to @AHumanBean, who gave me the code solutions that the 1.3 update is built on, for making everyone’s user experience (not to mention my job as developer) ten times smoother and thoroughly more enjoyable. I also apologise if the formatting of this post is a mess, as I'm pretty new to this too. I will be updating and editing it as necessary!

[1.0]
- Initial release

[1.1]
- Added Ancient Breed support
- Split Relatedness calculation to its own dedicated sheet (for both optimisation and ease of access & understanding)
- Added Family Tree sheet - you can input dragons here to display their ancestry more visually and check individual combinations.
- Added potential offspring colour average calculation and expanded comparison options (+C, +D)
- Removed protection of ranges within sheets - I added these initially as a safety measure but then found myself running into warning popups at every turn, even on the simplest tweaks and typo fixes. No longer.
- Optimisation and bug fixes
- Aesthetic cleanup and reorganisation


[1.2]
- Implemented a better 1st Gen ancestry solution
- Relatedness sheet's Issue column now functions as intended (clumsily, but at last)
- Lookup/Males/Females sheets hotfix
- Arbitrary ancestry row limit removed


[1.3.0]
- VAST optimisation overhaul across sheets Males, Females, Relatedness, Family Tree and Verdict (thank you infinitely @AHumanBean I owe you my life)
- Verdict sheet can now be filtered and sorted thanks to the addition of the hidden VerdictListing sheet (also thanks to @AHumanBean!)
- (Thanks also to my brother @LeviGames30 for letting me use his laptop to do all of that away from home, you can go back to playing Minecraft now)

This looks insanely helpful and I cannot imagine how long it took to make. I'll definitely be bookmarking to use this in the future, and I hope others do too [emoji=auraboa star size=2]

[quote name="Auraboas" date="2024-03-25 02:01:45" ] This looks insanely helpful and I cannot imagine how long it took to make. I'll definitely be bookmarking to use this in the future, and I hope others do too [emoji=auraboa star size=2] [/quote] @Auraboas That means the absolute world to me! Thank you so much, let me know how you get on with it!

bookmarking this for later, i think it'll be a great help for my projects! thank you for your hard work!

[quote name="anthologia" date="2024-04-24 19:03:03" ] bookmarking this for later, i think it'll be a great help for my projects! thank you for your hard work! [/quote] @anthologia Thank you so much for your interest, let me know how you find it! :D

you've saved my life oh my god. thank you for this!! would love to see this updated for Ancients!!

[quote name="ceruleansky" date="2024-05-07 12:03:12" ] you've saved my life oh my god. thank you for this!! would love to see this updated for Ancients!! [/quote] Ah I’m so glad!!!!! Ancient update is already significantly underway, just a little more work to do until I’m confident in releasing it! :D Let me know how you find using it!

yay!! super looking forward to it, Ancients have really been growing on me and it's hard finding spreadsheets that have all their genes updated and whatnot.

also the spreadsheet is AWESOME. I've tried so many (even commissioned somebody at one point to make one for me) and this one is my favorite so far. it has what I need and ONLY what I need. it's broken down into tabs that make sense and there's not so many tabs I get lost clicking back and forth. the percent chances for genes AND colors!!

no other spreadsheet has had the exact level of ADHD specificity I need!

I love that I can filter the columns on the verdict sheet to exclude certain dragons. it's such a pain with other tools I've used where it's hard to tell what the second-best pair would be if I'm intentionally saving a certain dragon for the very end of the project.

I haven't tried out the "compare potential offspring" tool yet but it seems like it would be super helpful, like when trying to get a rare color combo and you're at a higher risk of inbreeding (like I am constantly lmao) Also it's incredible that I can input a dragon's family tree to have it auto-check for relatives through the generations, that is SO helpful!!

the only part of the sheet I don't quite grasp is the "breed/gene/color drawback" percent on the verdict sheet. is that just how far off the closest possible color would be?