UPDATE: Project halted indefinitely. If someone wishes to take over or request this to be continued, please PM me as I am currently the sole organizer of this sheet and thread.
Due to the cooperative nature of the task, I propose the following solution to tracking the variety of creatures that can be raised, as well as an indirect tracker to check for existing genetic combinations for a certain species.
Edit: As of now, the Research Reference Repository has figured out a way to install a genetic predictor feature. It has been good that the database has been able to serve predicting purposes for people before that. I will still continue to work on it, as the goal of tracking the variety of existing creatures is still relevant. The consequence is that the labels will not be fully detailed, and you may have to either search through the database or use the installed predictor tool to see how a gene corresponds to a creature's appearance.
The solution is presented in the form of RESEARCH_FILES that makes use of the classical powerful Google Sheets.
As of now, I am the sole maintainer and worker of this sheet and the tracking activity. Feedback would be appreciated in improving presentability and usefulness of the work.
+ SPECIES is the Main Sheet. TEAM and RECORD are just extras. BREEDING_BASICS is a basic guide on predicting the offspring of two creatures. There are sheet links within the main sheet and there are return links for each sheet, located on the top rightmost part of sheet.
+ VARIATIONS refer to the parts of the body that may vary from the other parts when genetic changes occur.
+ Sortable Sheets for each species using the state-of-the-art filter views. To create a filter view, go to Data > Filter Views > Create New Temporary Filter. Select a column, open its Filter options (the three horizontal lines icon), Filter by Condition > Custom formula is > Use this formula to find the specific gene:
where A:A is the column (if the column label is B, use B:B instead) and AaBb is the genetic label being searched.
+ When genetic data is complete, their genetic labels will be used instead, with matching font colors. As for variations of markings, a legend will be provided on an extra column in the sheet.
+ If genetic data is incomplete, researchers may work together (including myself) to figure out the genetic variations until the respective Lab Notes are unlocked, which by then can be used to cross-check and validate genetic research. ZnowyOwl, a peer of mine, has helped in cooperation to identify the genes and their effects on variation of a creature so far. More of the work can be found in ZnowyOwl's sheet linked in credits below.
If you have one or more of a species that has not been recorded in the database, you can now help by submitting the creature's code using the link below.
Credits:
Znowy's Personal Sheet
Cabuso's Krizo spreadsheet
Due to the cooperative nature of the task, I propose the following solution to tracking the variety of creatures that can be raised, as well as an indirect tracker to check for existing genetic combinations for a certain species.
Edit: As of now, the Research Reference Repository has figured out a way to install a genetic predictor feature. It has been good that the database has been able to serve predicting purposes for people before that. I will still continue to work on it, as the goal of tracking the variety of existing creatures is still relevant. The consequence is that the labels will not be fully detailed, and you may have to either search through the database or use the installed predictor tool to see how a gene corresponds to a creature's appearance.
The solution is presented in the form of RESEARCH_FILES that makes use of the classical powerful Google Sheets.
As of now, I am the sole maintainer and worker of this sheet and the tracking activity. Feedback would be appreciated in improving presentability and usefulness of the work.
+ SPECIES is the Main Sheet. TEAM and RECORD are just extras. BREEDING_BASICS is a basic guide on predicting the offspring of two creatures. There are sheet links within the main sheet and there are return links for each sheet, located on the top rightmost part of sheet.
+ VARIATIONS refer to the parts of the body that may vary from the other parts when genetic changes occur.
+ Sortable Sheets for each species using the state-of-the-art filter views. To create a filter view, go to Data > Filter Views > Create New Temporary Filter. Select a column, open its Filter options (the three horizontal lines icon), Filter by Condition > Custom formula is > Use this formula to find the specific gene:
=EXACT(A:A, "AaBb")
where A:A is the column (if the column label is B, use B:B instead) and AaBb is the genetic label being searched.
+ When genetic data is complete, their genetic labels will be used instead, with matching font colors. As for variations of markings, a legend will be provided on an extra column in the sheet.
+ If genetic data is incomplete, researchers may work together (including myself) to figure out the genetic variations until the respective Lab Notes are unlocked, which by then can be used to cross-check and validate genetic research. ZnowyOwl, a peer of mine, has helped in cooperation to identify the genes and their effects on variation of a creature so far. More of the work can be found in ZnowyOwl's sheet linked in credits below.
If you have one or more of a species that has not been recorded in the database, you can now help by submitting the creature's code using the link below.
Credits:
Znowy's Personal Sheet
Cabuso's Krizo spreadsheet