awesome :D! I’ll leave some tips here for you and anyone else thinking about creating lineage projects
1:
Chazza’s Lineage Builder is extremely helpful for visualizing in the early stages! I don’t use it much now that i have enough experience to intuit what most of my lineages should look like, but when i’m doing some complicated patterns I’ll use this to double check that everything lines up :]
2: There’s this
helpful guide on the DC forums! I use even-gens as a template for my lineages so I often come back here and check how many gens I’ll need to fit all the lyrics
3: Google Sheets is extremely useful and versatile here. I use it to lay out all my needed information at a quick glance, to count how many characters are in a line (to easily make sure I don’t go over the 32 limit per dragon name), to track how many CBs I have and how many I still need, and so on and so forth. I taught myself some very simple coding to achieve this, and I’m going to break it down for anyone interested in doing the same!
- Sheet Layout
- 56260611-3776-4707-9D7A-CF0073DEB129.jpeg (352.95 KiB) Viewed 501 times
This is an example of an evengen. I lay out all my lineages like this, though they’ll look a little different if I don’t have enough lines to fill out the whole 1st gen. The bits that are not important for coding are gender and parents. I use the parents column to make sure I’ve lined things up correctly when I’m breeding and naming the actual dragons. The colours are only for readability and aesthetics lol
Every lineage has its own tab within the same document. It’s important to name these tabs!
~
- Name-Counter Code
- A684EAC8-4535-4D4F-8F6F-BB6ACD89C168.jpeg (136.94 KiB) Viewed 501 times
^ And this here is how I can automatically count the letters/numbers/spaces in a name! ‘=LEN’ is the command. ‘A’ tells it to look in the column ‘A’, where my names are. ‘2’ tells it to look in row 2. If you click on the box with the command and then drag down through the rest of the column, there’s an option to autofill and the commands will update for each new row ‘=LEN (A3)’, ‘=LEN (A4)’, etc :]! To input a command like this, you just type it in like you would regular text
~
- CB-Tracker Code
- 9F26A081-90B2-4A9E-A384-CB741DB918FE.jpeg (325.12 KiB) Viewed 501 times
Last but not least! This is where most of the magic (coding) happens! The CBs Tracker tab, providing a quick lookup for egg hunting and how many i still need to find.
Our example is ‘=COUNTIFS(
'Fae Wather Way'!C1:C83, "Temple Wyrm",
'Fae Wather Way'!E1:E83, "n",
'Fae Wather Way'!F1:F83, "1")’. All the punctuation within the code is important so the sheet can parse the segments within and how to use this information
• ‘=COUNTIFS’ is the command (I’m asking it to Count, If certain criteria are met)
• ‘Fae Wather Way’ is the name of the song and thus the name of the tab! So this part tells it what tab to look at
Now let’s look at each coloured segment:
• 'Fae Wather Way'!C1:C83, "Temple Wyrm": this is only relevant if you have more than one breed used in your lineage. In ‘Fear for the Storm’, the entire lineage was Aeria Gloris so I excluded this bit. ‘C1:C83’ here is telling the command to look at Column C (where I keep breed info) and everything from Row 1 to Row 83 (this lineage takes up 83 Rows, if your lineage is longer or shorter you’ll adjust this number). Temple Wyrm is the breed that this particular code is tracking; note that the spelling must be exactly the same in this code and in the lineage sheet! I believe it is also case-sensitive
• 'Fae Wather Way'!E1:E83, "n": in the same way as above, ‘E1:E83’ is telling this part of the command to look at Column E (where I track what dragons I have and don’t yet have), and between rows 1-83. The "n" here means it will only count rows I have marked with an "n", for Not Obtained :)
• 'Fae Wather Way'!F1:F83, "1": again, ‘F1:F83’ tells this command to look at Column F (which tracks generation), between rows 1-83. The "1" here means it will only count rows that are marked with "1", for firstgens! You could also use "CB" instead
So in summary: ‘
=COUNTIFS('Fae Wather Way'!C1:C83, "Temple Wyrm", 'Fae Wather Way'!E1:E83, "n",'Fae Wather Way'!F1:F83, "1")’ is a command that tells this box to count Only Temple Wyrms, Only ‘Not Obtained’, Only Firstgens, in the tab ‘Fae Wather Way’ and in the relevant columns and rows. And all I have to do to update this count is go to the tab for the lineage and replace an ‘n’ with a ‘y’ when I’ve obtained the next CB :]
