I cobbled the spreadsheet together from other card spreadsheets on the Gods Unchained Discord and Blog a while ago when Divine Order came out. Gudecks is more useful for searching up cards, so I don't use the spreadsheet often. The card descriptions are manually updated when there are balance changes. There might be a way to automate the spreadsheet with the GU card api.
Spreadsheet
https://docs.google.com/spreadsheets/d/e/2PACX-1vQGk6jZqtqdNHzyOtZPTOqbPBs5p1endWr9-6mo-IjgAjSi7K9w_OMSiI1bU1QfGL5Vz7NiHSOb7Y8A/pubhtml
You can make a copy of the spreadsheet to make your own changes.
The spreadsheet has the card proto id, name, rarity, type, faction, god, mana, strength, health, description, set, and collectible. Most of the headers are self-explanatory.
Proto id is the unique identifier of the card. I don't find it useful outside of looking up card images on card.godsunchained.
Collectible and Non-collectible
Collectible means it is a card you can own. Non-collectible cards are those generated by other cards like the Walking Plant from Staff of Roots. The non-collectible cards are in a separate tab from the collectible cards. God Powers are also stored in GU as non-collectible cards.
Highlight Cards within a Filter
The spreadsheet can be useful for some cases like searching multiple keywords at a time e.g. filter the card description for frontline then ctrl+F roar to highlight all the frontline creatures with a roar.
Stat and Keyword Count
The card stats and keywords can be aggregated to see how many cards have a specific stat or keyword.
Faction Synergy
The faction synergy tab lists all the cards who have a faction/tribe in the card description e.g. The Sky Weaver says "After an Aether attacks, draw a card.". It can help to see the tribal support each god has but you're usually better off using gudecks to search.
Core Set Refresh New Cards
I also put in the new cards from the Core Set Refresh so I could see how many new cards each tribe is getting.
The rewards earned on this comment will go directly to the person sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.
I'll have to spend some time digging through this, but I always love me some spreadsheets!
Excellent work compiling this information :D
this is a lot of work, thanks for doing it. you are right this could be automated.
Yes, there's definitely a way to automate the process. I assume you're familiar with at least some basic data processing; all card data can be found by querying this URL: https://api.godsunchained.com/v0/proto?format=flat , which is what I used for GUListCreator.
To automate the process, something like this might work:
Of course, this will probably only cover cards that are available in-game now and will not be able to cover things like cards in the upcoming Core Set refresh. Hope this helped!
Interesting, I have zero experience in this kind of thing but I'll look into it.
This is what I do for my get GU card list app and well as grab the users inventory JSON as well.
Congratulations @meltysquid! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s):
Your next target is to reach 2500 upvotes.
You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPCheck out the last post from @hivebuzz:
Support the HiveBuzz project. Vote for our proposal!