Hello guys,
I’m building a spreadsheet to help me manage my planets but I can’t find a way to match a specific pin (like the launchpad or storage) to check the contents. I’m trying to do that using this formula: =FILTER(F1#; ISNUMBER(SEARCH(“Launchpad”; F1#)); “No Match”) but it never matches anything. Column F is where I’m extracting the “pins” information ( =EVEONLINE.CHARACTER_PLANET(EVEONLINE.ACTIVE_CHARACTER(); A1.id).pins).
Thanks in advance
I’d try using the pins type field (.type) as what you want to filter against.
fx. for launchpads that are group_id 1030 (Spaceports, includes all launchpad variants)
you could do a
=FILTER(J4#,J4#.type.group_id = 1030)
And just an extra tip: for your .CHARACTER_PLANET() call you can simplify by using the owner_id that comes from the planets results.
=EVEONLINE.CHARACTER_PLANET(E4.owner_id,E4.id)
Tonight, I ventured into trying to find volumes of materials actually on the planet for a factory planet.
The results of content showed the correct materials, but not the correct amounts. After doing my normal PI duties of import and export and move to market, the planet’s amounts never changed. I kept trying to cycle the entry and it resulted in the same amounts,
Is there a method to at least getting the name EVE uses for things… Like an LP hu-123? I made my own lookup table of those things I could identify using the ID.
The update interval is sadly very hard to guess at, we have the normal ESI cache on the data, but it’s very iffy to say exactly what triggers a new update and for how long it takes to reach ESI.
Not really sure what you mean for the name, LP hu-123 not really returning much for me. Is it from the PI recipe itself?
Thank you for the reply
For example:
A factory colony Lava Launchpad QE-K4X which I see when in planet view mode or using the POCO drop down menu.
That specific Launchpad has an ID number 1013025681175.
I know this by placing unique products in the LP cargo space and wait for an update and build a table converting the ID to that label.
While I have your attention: 
When I do a eveonline.character_assets(charcterID, ‘robotics’) EXCEL tells me I have Qty 2,256 at location ID 1020331882005.
That ID returns me an error, and in-game searching shows nothing of that quantity of robotics – does show others – in my inventory, contracts, sell orders, etc. Nothing. Any ideas?
It is obvious I am doing something wrong.
Ah the LP is for launchpad, yeah the ESI doesn’t return us with those kind of names, so its probably hard to differentiate between multiple launchpads.
afaik the characters_assets shouldn’t return you PI contents, as my own PI doesn’t get returned there, so it’s probably not that, unless its reporting something in a customs office maybe?
1020331882005 does look like a structure id, but I can’t be too sure, since querying them requires ACL to get a reply. Strange the ingame search didn’t return it, since its the same data source (minus ingame can resolve structures w/o ACL)
The addin has logic to show that known cargo containers/parent nodes, so location_id being a number is usually just for the parent that’s usually a station/structure.
Sorry that I can’t think of anything useful.
a customs office…? That would be it since the personal assets and the corps assets does not show the contents in a customs office. But your stuff does. Thanks… now to go search the 100,000’s (?) of POCOs.
You’ve been very helpful, Thank you.
Incorporating the new templates? Is that on the horizon?
Edit: speltin’ errors
Time has been a luxury asset lately, and since I also need to setup things in eve personally to get data its hard.
Maybe we could do a poll of what template is most in demand? I’m sure some community members could help set it up 
I do,
EVEONLINE.CHARACTER_ASSETS(Characters!$B$2,$B$25,$L$37)
B2 = m ID
B25 = the PI product ID
L37 = the station in question ID
A couple of things happen but the question I have is when it returns a N/A? I always maintain some of the product in a station hanger.
#value seems to go away when I refresh my ID on the main page
#spill I know to be multiple stacks of the product
#n/a No idea
and of course correct information. Most of the time.
The #N/A is almost always used when we do some sort of a filter and it ends up as an empty array. N/A is what I’ve used to denote empty results.
Not sure what the cause if in your case, since you always have some product, maybe it just didn’t find that specific product is the only thing that’d make sense for the N/A
Thank you for the reply
Sadly, I am having EXCEL issues at the moment, so this is going on memory
I have a stion hanger with a container containing PI products, I use this to tell me the amounts I need. So, it always has an amount of 1,2, or 3 units. It is part of “my system”.
Then in the item hanger of that station will be the quantities I am gathering to transfer to the POCO during my weekly PI session. could ~100,000 at most.
Third, will be various products in the corporate delivery, occasionally from a buy order, vast majority of the time it is courier contract deliveries to that station. Stacks of 50 to 100 thousand in size.
I use a SUM(Xnn.quantity) to get a total amount.
The station
Xnn = EVEONLINE_CHARACTER.ASSSET(ME.ID, PIPRODUCT.ID, STATION.ID)
SUM(Xnn.quantity)
Highlight this cell red <100,000, green >=100,000
Now since I like try things out:
Another one is a corporation office and one of the hangers is Material Planetary Products
In the corporation hanger I have the containers, the gathering materials, and the corporation delivery, and some personal courier contracts in my item hanger. Four stacks are possible.
Corporation_asset formula used instead.
The whole point is so I can look at this array/table/box and things that are red, I place a buy order to bring the amount to green.
Hopefully, this week Microsoft and I will come to an agreement on my payments, and I will have access shortly.
I wanted this to be separate since I am not there yet.
I do ‘Factory Colonies’ and I adjust their product(s) based upon the market.
I do a weekly PI session, import/export, and place the market orders, buy and sells.
Once a month, I evaluate my positions and alter my colonies as needed.
If the EXCEL can read those factories and pass back that information to various buy/sell formulas to know what I will be buying this week.
The buy/sells work, eventually. It is not an open the spreadsheet, get an updated inventory within 5 minutes routine.
I just started trying to get the colony inventory when my issues arose. What little I got was wildly inaccurate. You gotta luv EVE! 