These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

PI spreadsheet for tracking materials
Author
Previous Topic Next Topic
Sir Constantin
#1 - 2016-05-09 12:31:26 UTC
So i want to see the materials and their quantity in the storage and in the launchpad, is there a free spreadsheet that shows this or can someone tell me what API do i need to use to pull that data into a excel spreadsheet?

I know Evemon has this but i want to put it in excel for a better overall view.

Thanks! :)
Sir Constantin
#2 - 2016-05-10 19:20:31 UTC
So no one can help me with the formula?

This is what i want: http://imgur.com/VGQOuZ9

I did some research and I think this is a piece of the formula but i don't know what should i use for the last part. Tried several things but it gave me a parse error and I failed to pull the data into google spreadsheet, filter it and get the amount of materials stored in the storage and launchpad.

=importxml(https://api.eveonline.com/char/PlanetaryPins.xml.aspx?keyID=xxxxx&vCode=xxxxxxx&characterID=xxxxx&planetID=xxxxx", "???????")

Also, if i want to do this for 5 planets do i need to use this formula every time or there is a way to add all the planetID's and stuff into one?

Here is the api documentation for the Planetary Pins.
http://eveonline-third-party-documentation.readthedocs.io/en/latest/xmlapi/character/char_planetarypins.html
Tau Cabalander
Retirement Retreat
Working Stiffs
#3 - 2016-05-10 19:46:38 UTC
You are way more OCD than I.

I didn't think that was possible.

Bear
Shiloh Templeton
Cheyenne HET Co
#4 - 2016-05-13 23:24:03 UTC
I did not think it was possible to pull data for PI still on the planet or even POCO, either.

You might try posting your questions down in the "Eve Technology" subforum where there are people familiar with the API.