Is there anyway to separate things like “ships” or “ore” or even more fine grain like “Scordite” that encompasses all the variations of scordite in my assets?
I was thinking that I could use a wildcard character to essentially filter it out so I could just have the variations of Scordite, or is this something that I would have to do like some nesting of group ids?
Part of the reason I am back in eve is to extend my spreadsheet skills and the add in is going to be helpful, I just have to learn how to manipulate it.
The function _ASSETS(char_id, searchstring) has a second optional parameter to filter out by type_id, exact name, or a substring search, (and more complex, group_id or multiple type_id)
So the “easiest” way to do that is by doing =EVEONLINE.CHARACTER_ASSETS([char_id], “group_id: 460”)
(Note the quoation marks around group_id, it needs to be a string for the internal logic to function. The char_id is also optiona, if it’s just empty i.e. (,“group_id:460”) it will fetch from all characters. )
For a FILTER on every single asset in a list, like your screenshot has, you could do instead.
=FILTER(A2#,A2#.type.group_id = 460)
Assuming you have the CHARACTER_ASSETS() inside the A2 cell, like in the screenshot. It also reuses the info and doesn’t need to resolve the function, so it’s a bit snappier in resolving it.
if you wanna use VLOOKUP, I recommend looking at XLOOKUP, it’s a bit more modern version of the function that performs better. But doesn’t take the exact same parameters, so google-fu is a bit less strong in that regard, since so many guides/websites explain VLOOKUP already
This is such a useful tip that it should be part of the additional documentation. It isn’t obvious that it should work. And knowing this tip significantly improves the functionality of the plugin.
I plan to add more to the functions site, have linked articles to the functions for samples so we can do a more verbose sample. Especially for newer features like these group_id thing recently added. But even just doing a good FILTER sample can really help with a lot of scenarios many usecases end up having, that are attempted to be solved with SUMIFS and bunch of helper cells.
All for having good documentation and tutorials <3
