Hey there! I found this really useful, but I needed one more functionality that I added. I wanted it to automatically generate links to search through my horde, so I added that!
Here's a link to the sheet with that change!
It's based off midnight mage's sheet, and I'll leave that copy of the sheet frozen if you wanna add a link to it.
The changes I made:
Added another column in Items Needed titled "Hoard Search", changed "Familiar" to "Familiars" in ITEM INFO to make the links work. Then wrote the code in hoard search to generate the URLs. I think that's it :)
Hey there! I found this really useful, but I needed one more functionality that I added. I wanted it to automatically generate links to search through my horde, so I added that!
Here's a link to the sheet with that change!
It's based off midnight mage's sheet, and I'll leave that copy of the sheet frozen if you wanna add a link to it.
The changes I made:
Added another column in Items Needed titled "Hoard Search", changed "Familiar" to "Familiars" in ITEM INFO to make the links work. Then wrote the code in hoard search to generate the URLs. I think that's it :)
[center]thanks @VolatileMatter! i added it to the front page
[emoji=spiral laughing size=2]
-
I really love this spreadsheet! :D
I might look into making a master version with the changes and fixes I made to mine as well, though rn this inspired me to work on a familiar collecting sheet! ^u^
I really love this spreadsheet! :D
I might look into making a master version with the changes and fixes I made to mine as well, though rn this inspired me to work on a familiar collecting sheet! ^u^
[center]so awesome to hear @lizwyrm! i'm excited to see your additions
[emoji=banescale laughing size=2]
so awesome to hear @
lizwyrm! i'm excited to see your additions
-
I've got a lot of good use out of this Spreadsheet! I've had a lot of fun figuring out how it works and making tweaks of my own. Here's a link to the master of version I use. ^u^
[center][url=https://docs.google.com/spreadsheets/d/1th6311gp5RGUDqS1N7uptTdIQ89PnbI6JBWhdzfCkuQ/edit?usp=sharing][size=5][u][Master Link][/u][/size][/url][/center]
[quote=Main Changes]
[size=4][u]Quality of Life:[/u][/size]
[LIST]
[*]Changed the drop down menus to checkboxes (conditional formatting and dependent formulas altered to account for the change)
[*]Minor changes in coloration to make editable cells more obvious.
[*]Added hoard and vault links (indicated by [emoji=treasure chest size=1] and [emoji=gear size=1]) accordingly.
[*]Resized the rows and columns for a more compact appearance (esp aiming to make "Items Needed" fit in screen without having to scroll horizontally)
[*]Added quicklink to the hybernal den upgrade page.
[/LIST]
[size=4][u]Misc:[/u][/size]
[LIST]
[*]Added numbered column to "Items Needed" in order to allow for the safe use of the filter Sort feature.
[*]Minor fixes to coloration on ITEM_INFO.
[/LIST]
Thank you again for making this spreadsheet! :D It's an awesome tool and has helped me a lot!
I've got a lot of good use out of this Spreadsheet! I've had a lot of fun figuring out how it works and making tweaks of my own. Here's a link to the master of version I use. ^u^
Main Changes wrote:
Quality of Life:
- Changed the drop down menus to checkboxes (conditional formatting and dependent formulas altered to account for the change)
- Minor changes in coloration to make editable cells more obvious.
- Added hoard and vault links (indicated by
and 
) accordingly.
- Resized the rows and columns for a more compact appearance (esp aiming to make "Items Needed" fit in screen without having to scroll horizontally)
- Added quicklink to the hybernal den upgrade page.
Misc:
- Added numbered column to "Items Needed" in order to allow for the safe use of the filter Sort feature.
- Minor fixes to coloration on ITEM_INFO.
Thank you again for making this spreadsheet! :D It's an awesome tool and has helped me a lot!
[center]thanks for your addition @lizwyrm!
[emoji=coatl laughing size=2]
-
Before I go through doing it myself, has anyone already updated any of the master copies and just not updated the 'last update date' on the info tabs? There are a fair number of newer den slot unlocks, between Arlo sites and coli venue updates, and if I can skip repeat work I'm all for that, hah.
Before I go through doing it myself, has anyone already updated any of the master copies and just not updated the 'last update date' on the info tabs? There are a fair number of newer den slot unlocks, between Arlo sites and coli venue updates, and if I can skip repeat work I'm all for that, hah.
@
Gryphonlady no, its been quite a bit since i updated it!! im not super active here anymore aside from keeping my dragons fed
@
Gryphonlady no, its been quite a bit since i updated it!! im not super active here anymore aside from keeping my dragons fed
Alrighty, I'll go through and make some updates, then. I did Lizwyrm's yesterday since I needed one for a project ^.^
https://docs.google.com/spreadsheets/d/1NtJpZjDaRdhqBlO1jUVkYh1HQisyPy8sYBbxQSGtGsA/
^ Lizwyrm variant updated with Arlo (both stages) and the Woodland Path update.
