@Alestrius First off I'd like to say that this sheet is wonderful, and that I really admire you for managing it. It's an amazing resource for so many users.
Secondly, I've been looking into and testing an option to make updates much easier for the users of the sheet, and potentially easier for you. From what I understand, most updates are focused on changes that affect data used in data validation and various formulas. With that in mind, I've been testing some options with the importrange function google sheets has. Forgive me if you've already considered this, and if you already know about the function, but basically it can pull data from a completely separate spreadsheet (not to be confused with the sheets within a spreadsheet) when given the url to it. So I figured that if everything that's usually updated (e.g. genes, breeds, rarity/percentages, etc.) were hosted on a separate spreadsheet that the main one simply referenced, users of the main spreadsheet wouldn't have to copy their data everytime there's an update to the gene list or something. They likely wouldn't even have to change their own spreadsheet at all, it would simply update automatically. And all you would have to do is add the new gene/breed/whatever to the appropriate column and you'd be good to go.
I've made a simple example sheet pulling data from the H-Lists sheet of the lair companion. Obviously the actual sheet that holds the data would have to be changed a bit so that the user-specific things such as dragons wouldn't be included on the source sheet, and would likely be located in the far-right/left column on the hidden sheets of the main spreadsheet, but I feel this gets the basic idea across.
I've tried testing and researching how long the delay usually is when you update the source sheet compared to when the changes appear on the main sheet, and it seems to range between instantly, and about a half hour. Nothing that seems to unreasonable for something like this.
Also, I completely understand about the depression and lack of motivation, and I don't at all expect you to implement this right away, if at all. It's simply a suggestion, and you can do whatever you feel comfortable with. If you'd like, I may even be able to make a copy of the main sheet and play around with it sometime so that it's formatted as it needs to be, and all you'd need to do is copy the necessary data to a source sheet that you'd own, and then paste the whole sheet over the current one as a new update. However it's late right now, and I need to sleep, so all I could manage was just the simple example I linked. Let me know if you'd like any help! Again, fantastic job on this spreadsheet!
Secondly, I've been looking into and testing an option to make updates much easier for the users of the sheet, and potentially easier for you. From what I understand, most updates are focused on changes that affect data used in data validation and various formulas. With that in mind, I've been testing some options with the importrange function google sheets has. Forgive me if you've already considered this, and if you already know about the function, but basically it can pull data from a completely separate spreadsheet (not to be confused with the sheets within a spreadsheet) when given the url to it. So I figured that if everything that's usually updated (e.g. genes, breeds, rarity/percentages, etc.) were hosted on a separate spreadsheet that the main one simply referenced, users of the main spreadsheet wouldn't have to copy their data everytime there's an update to the gene list or something. They likely wouldn't even have to change their own spreadsheet at all, it would simply update automatically. And all you would have to do is add the new gene/breed/whatever to the appropriate column and you'd be good to go.
I've made a simple example sheet pulling data from the H-Lists sheet of the lair companion. Obviously the actual sheet that holds the data would have to be changed a bit so that the user-specific things such as dragons wouldn't be included on the source sheet, and would likely be located in the far-right/left column on the hidden sheets of the main spreadsheet, but I feel this gets the basic idea across.
I've tried testing and researching how long the delay usually is when you update the source sheet compared to when the changes appear on the main sheet, and it seems to range between instantly, and about a half hour. Nothing that seems to unreasonable for something like this.
Also, I completely understand about the depression and lack of motivation, and I don't at all expect you to implement this right away, if at all. It's simply a suggestion, and you can do whatever you feel comfortable with. If you'd like, I may even be able to make a copy of the main sheet and play around with it sometime so that it's formatted as it needs to be, and all you'd need to do is copy the necessary data to a source sheet that you'd own, and then paste the whole sheet over the current one as a new update. However it's late right now, and I need to sleep, so all I could manage was just the simple example I linked. Let me know if you'd like any help! Again, fantastic job on this spreadsheet!
