Solved PI Storage Levels

Anyone managed to pull out storage levels I can pull all the pin detail including time it expires but not stock levels

Can you please explain what you are attempting to do in more detail?

If it’s something like this:

Here are the key functions you’ll need:

=EVEONLINE.CHARACTER_PLANETS([character_id_or_entity])

=EVEONLINE.CHARACTER_PLANET([character_id_or_entity], [planet_id])

Digging down the CHARACTER_PLANET() object to get the array facilities on a planet you’d need to add this function:

.pins

Adding the following function, onto the .pins, will give the array of Content(s) of each facility, depending on your planet’s setup you may encounter errors here if one facility has more than 1 type of items in storage:

.contents

Other useful functions to get your desired results may include:

.amount
.type
.volume
.capacity

2 Likes

Sorry a failure of mind to keyboard issue but that graphic is exactly what I needed, thanks so I don’t have to cycle clients to check storage

=EVEONLINE.CHARACTER_PLANET(B67, C67).contents comes up with #FIELD error
If I replace .contents with .pins I get what I already have.

All my extractor planets have storage and a launcher where factory planets have multiple launchers

Actually think I am getting there

My first reply was to give you the tools to figure out a solution based on the knowledge of those functions I mentioned. If given the solution you would not learn how to utilise the Add-in to it’s potential - sometimes you’re required to be creative to make a solution out of the tools available.

I appreciate that I have as you can see gotten quite far by myself but I am not getting correct data out of .contents as the Launchpad has items in it and the other factories all have items in it which means the code is flawed or I have done something wrong

the content updates can be quite delayed, maybe that’s what going on, as you expect different data? (Wish I could be more helpful, hope you find your solution!)

Really dont know but I see I have the correct formula least I think I do it always shows none even tho there are items in it. It only shows items in one pin factory and that number never changes out of 8 factories as well.

Started working now so can now show the launchpad. I use =INDEX(EVEONLINE.CHARACTER_PLANET(B2, C2).pins, 8) to only provide one line. I am sure I could do this faster with a match or something but I just did it manually to find the correct launcher.

Gui wise a lot to do to make this better the idea is to look at tab and know what needs to be worked on.

2 Likes

I hope you don’t expect to receive data about your planets remotely, because there is a limitation that without a physical flight to the planet you won’t have new data in your table, it’s a completely useless thing, I spent the whole night making an ideal table and it was a failure…

What do you mean my main is in Jita and I did a refresh and still getting updates least the pins update. I have to update the formula for storage when I change the planet so haven’t had a chance to see if storage levels update yet

Currently working on Reactions but happy to help contribute as I find its the best way to learn more and to keep the knowledge in my head