Got this idea from a user who made a very similar sheet over on Flightrising. I've been using it for multiple years to keep track of my dragons and thought it would be great to have a similar sheet for Lorwolf! If you have any suggestions for impovments or additions I can make to the sheet, feel free to share them!

>>> LINK TO SHEET <<<

To use the sheet

1. Open the above link
2. Go to File and click on “Make a Copy”
3. In your new copy delete all of my wolves info from the sheet and start entering your own!
   1. There are formulas in the “digits”, “age”, and “Synergies” columns. If you accidentally delete any of these, try using CTRL + Z to get it back, or message me and I can help you.
4. Once you've entered all your data, the Tables and Charts in the other tabs will update automatically!

╰┈➤ ❝ Explanations ❞

Most of the sheet should be self explainatory, but here is a run down of what some of the columns are for and what options you can use! If you have any questions or need help with a specific part of the sheet, feel free to ping me!

• Name and ID Number - Easy: Just input your Wolf's name and ID.
• ID Digits - This displays how many digits your wolf's ID has, So you can keep track of all your low ID finds. This column is filled in automatically!
• Gender - You can input anything you want for this but, I have made conditional formating exceptions for the following options:
  • Male
  • Female
  • Non-Binary (Can also just enter NB or Enby)
  • Trans (Can also use Trans Male or Trans Female if you want to be more specific)
  • Agender
  • Genderfluid (Can also just enter Fluid)
  • Intersex
• Pronouns - Can also enter anything you want here, but conditional formating exceptions are available for the following:
  • He/Him
  • She/Her
  • They/Them
  • Xe/Xem
  • It/Its
  • None
  • Any
• Age - You dont have to fill this out! Once you enter your wolf's Birth year, month and day this will be calculated automatically for you!
• Weight and Height - These are optional really, but there is conditional formating for various ranges of height and weight.
• Eye Color, Accent Color, Under Coat Color, Top Coat Color, Base Color
  • Just input your wolfs colors and they will be automatically changed to the correct Hex code to match!
  • (Yes, I had to sit and enter in 201 conditional formatting options individually. Yes my hand hurts.)
• Generation - This is to designate is a wolf is a first generation or later.
  • Starter wolves and Wild Wolves are Generation 1, while wolves you've bred would be generation 2, and so forth. For Generations one wolves you can use 1, WW, or Wild Wolf
  • You can choose to differentiate your starter wolves like I did by using Starter or Progen

╰┈➤ ❝ Update Pinglist ❞

@/tserin @/Panther @/bumblewhiskers @/naranciag @/Amancham

╰┈➤ ❝ How to Update Your Sheet ❞

Over time I will be making improvements and addition to this sheet. In the event that you want to update your copy you can do the following:

1. Revisit the link in the first post and go to file > Make a copy.
   • Save this copy under a new name you can easily identify as the new version.
2. On your old copy, highlight everything starting at cell B3 (The first wolf name) and select all your wolves information. Press CRTL + C to copy the cells.
3. On the new sheet, click on cell B3 and press CTRL + P to paste all the information into the new sheet.
   • In the event that new columns are added, you may need to shift some data around. All the formatting will still work once your data is in the correct columns.
   • You could also Copy/Paste each row individually into their correct position into the new sheet.

╰┈➤ ❝ Change Log ❞

June 4th, 2023

• Not a large update, but I added in all of the new companions from the Dev update to the companions sheet. They and their respective synergies are now options in the companion tracker.
• Also, mostly an unnoticable update: I've removed the Appscript code I used to extract the Hex color codes from the color references. The app script was slowing down the sheet and I realized I really only needed it to run once to get the hex values. The color reference sheet now has static hex code values instead of a formula that runs the script every time the sheet is opened. You should see slightly faster load times now.

╰┈➤ ❝ Need to Fix ❞

• Add new companions to companion list

╰┈➤ ❝ Possible Future Additions ❞

• Mate column to list a wolf's partner and “Link” them together
• Manual color entry for the color range checker

@VariantLoki

Hi, I'm noticing a problem with the sheet which I think is an easy fix! Currently, the gender field is not accepting anything other than male or female into the charts and tables, and I think you might have just forgotten to add all the extra options.

Hope you're doing OK and that this isn't a huge problem, but if it is, you could probably just specify it's for breeding stuff and leave the pronouns section as the gender identity identifier.

EDIT: The Color “Black” is also missing from conditional formatting.

@Heemi

Thanks for bringing that up! I think I have fixed this! The problem was that I set up the pivot Tables without having all the available options in the columns already. It should be working correctly now. You can either make a new copy from the link in the first post, or a way to fix it is this:

1. In the tables tab, hover over the gender table until you see the a pencil Icon pop up in the bottom corner (can also double click the table. Pretty sure)
2. In the side bar that pops up scroll down to the filter option and make sure all the options besides “blanks” and “gender” are selected with a check mark.

I realize now that the use of pivot tables makes this sheet not mobile friendly, so I may look into a different way to do the table/chart data.

@VariantLoki

This is awesome! I utilized it immediately!

Though, I found a couple things. Reed doesn't have a colour background for it, and Eggplant's is a blue, when the colour is a purple |D

@Heemi

Glad you like it! Ill take a look at the colors you mentioned when I get home from work today. If you find any more feel free to let me know :)

So cool, thank you! I really like the colored cells.

This is super cool and helpful, thank you!!

Just a heads up, I think there's a typo in the conditional formatting for the colour “fuchsia” <3

@Eeeviee

Thanks for the heads up! Thats one of those colors I always tend to mispell, lol.

UPDATE: Made some changes to the sheet! Details will be explained in the change log above!

UPDATE

May 16th 2023

• Added an ID digits column so you can keep track of your Low ID wolves. Currently is future proof up to 9 digit IDs (which shouldn't be for a LONG while. We're still at 8 digit IDs on Flightrising and it's been almost 10 years).
• This column will fill in automatically when you enter your Wolfs ID! Table data and corrosponding chart have been added as well!

@VariantLoki So I may just be Stoopid, but when I try to update the ID Digits tab (the third column over in the data input), it… erases itself? How do I fix that? Am I supposed to be putting data into Table Data? That doesn't SOUND right but I'm not sure what the problem is,,,