Guides

[center][url=https://docs.google.com/spreadsheets/d/1pYv9ivtMlpuKr1Uj91tXNFzYpnEI6RQx56OYih8VQOI/edit?usp=sharing][img]http://i.imgur.com/rfMiMSd.png[/img][/url][/center] [center][url=https://docs.google.com/spreadsheets/d/1pYv9ivtMlpuKr1Uj91tXNFzYpnEI6RQx56OYih8VQOI/edit?usp=sharing][u]Link[/u][/url][/center] I used Google Sheets to create a tool to predict all the possible gene and colour combinations for the offspring of two dragons. You can also use it to predict the chance of having offspring with specific gene/colour combinations, given the parent's information and to find the ideal mate for an existing dragon to produce specific offspring. If you find it useful, or find any bugs/errors please let me know. [b]Latest Update (14/09/2015): Added a dragon saving/loading feature[/b] Note: In order for the tool to work you need to have editting access to the file. You need to make a copy of the document or use a version that has open access. I haven't set totally open access to avoid it being deleted/changed too much but anyone with a Google Docs account is free to copy it. Banner created by [url=http://www1.flightrising.com/forums/art/1179417]VetinTraining[/url] If you would like to be pinged when new versions of the tool or bug fixes are released please let me know. Ping List for future updates:

@ProfRosier Most of the boxes say #REF and I hovered over them and they say Error Unresolved Sheet Name 'Data'.

@humanityxpeople Thank you for checking it out. It must be something to do with the sheet permissions since the problem doesn't appear on mine.
I've stopped hiding the sheets in question, so that may have sorted it out if I'm lucky.

@ProfRosier That didn't help. I haven't figured out how to fix it myself.

@ProfRosier I made a copy of it and it's working for me?

@paigyp01

@humanityxpeople Did you copy the entire file or just the single sheet? Please try copying the file again now that the other sheets are not hidden, if you did not all ready try that.
Sorry I cannot be of more help with this problem.

@ProfRosier I only copied the sheet. Copying the file worked, thank you! :)

Bump to see if anyone else is interested.

Please let me know if you have any ideas for additional features or bug fixes.
My current plan is to add the ability to calculate the optimum mate for a given dragon in order to reach a target set of genes/colours.

Another Bump to let everyone know that I have updated the sheet with new functionality and generally improved the coding. The link to the new sheet can be found in the original post.