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.
 

Spreadsheet Help

First post
Author
Previous Topic Next Topic
Bronn Blackwood
Ephemeris Industries
#1 - 2016-03-24 17:50:26 UTC
I’m starting to get back into industry and have a pile of BPOs. I’m trying to streamline my spreadsheets and have them do more of the calculating for me.
The first thing I’m trying to do is use an API key to get my BPO list into excel with ME and TE values. I was able to figure out how to get a complete asset list (including the BPOs) but it didn’t have ME & TE info. It also didn’t have the BPOs that were in use, is there a way to get or include this info?

Is there a way to get ONLY BPOs and/or BPCs with ME/TE values?
Regnar Avastum
#2 - 2016-03-24 18:49:05 UTC
Hi,

I'll try to answer in order:
- To get items in use you also need to pull through the API the research/manufacture jobs in progress

- As far as I know ME/PE data is not saved in the asset list; The way the tool ISKperHour gets these values is by looking at the jobs in the past and assuming the values derived from there

If that fails you can always make your own list and just enter these details manually.

♔ ℜegnar's High-End Spreadsheets ♔™
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2016-03-24 22:39:36 UTC
Regnar Avastum
#4 - 2016-03-25 01:56:04 UTC
Steve Ronuken wrote:
https://eveonline-third-party-documentation.readthedocs.org/en/latest/xmlapi/char_blueprints/


Nice! Thank you for the clarification, link bookmarked :)

♔ ℜegnar's High-End Spreadsheets ♔™
Bronn Blackwood
Ephemeris Industries
#5 - 2016-03-25 03:56:14 UTC
excellent info and much appreciated.....I finally got it to work.

Is it possible to query mats for BPOs or am i going to have to find that online somewhere?
Regnar Avastum
#6 - 2016-03-25 06:53:05 UTC
Bronn Blackwood wrote:
excellent info and much appreciated.....I finally got it to work.

Is it possible to query mats for BPOs or am i going to have to find that online somewhere?


industryActivityMaterials

You can find the answer to a lot of questions in the link above.

♔ ℜegnar's High-End Spreadsheets ♔™
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2016-03-25 10:23:42 UTC
You'll probably want industryActivityProducts too.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter