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.
12Next page
 

EVE Industry XML API for spreadsheet users

First post
Author
Previous Topic Next Topic
Qoi
Exert Force
#1 - 2014-08-01 15:35:01 UTC
I noticed that some people were unhappy about the process of importing the CREST industry data required for industry calculations into their spreadsheets, so i made an API for the system cost indices as well as the base job installation costs of blueprints.

I also included an API for my Compressed Ore calculator since Spreadsheets are probably not the right place for solving quadratic/linear optimization problems.

http://api.eve-industry.org

http://eve-industry.org
Richard Strohker
Aliastra
Gallente Federation
#2 - 2014-08-02 05:12:00 UTC  |  Edited by: Richard Strohker
I'm very new to this spreadsheet stuff, so bear with my noobishness. I'm attempting to test pulling from your Mineral Compression API by simply copying your example URL into an importxml function, but I'm getting an "Import Internal Error" when using the xpath "//highsec-compression". Am I just being a noob and using the wrong xpath?

EDIT: Nevermind, my friend corrected me on proper xpath usage (I could've just looked it up myself I guess). Got it working using "//eve-industry-api".
Qoi
Exert Force
#3 - 2014-08-02 09:36:02 UTC
Richard Strohker wrote:
I'm very new to this spreadsheet stuff, so bear with my noobishness. I'm attempting to test pulling from your Mineral Compression API by simply copying your example URL into an importxml function, but I'm getting an "Import Internal Error" when using the xpath "//highsec-compression". Am I just being a noob and using the wrong xpath?

EDIT: Nevermind, my friend corrected me on proper xpath usage (I could've just looked it up myself I guess). Got it working using "//eve-industry-api".

Thank you very much for your feedback, i added that as an example usage box.

http://eve-industry.org
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-08-02 17:05:14 UTC
muhahahah! tread hijack Blink

https://www.fuzzwork.co.uk/blueprint/api/xml.php?typeid=1320
https://www.fuzzwork.co.uk/blueprint/api/xml.php?typeid=1320&type=attribute (this link works, but the forum screws it up. C&P it.)


Away!

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Richard Strohker
Aliastra
Gallente Federation
#5 - 2014-08-02 17:27:48 UTC  |  Edited by: Richard Strohker
The Compressed Ore calculator is quite nice to have in my spreadsheet (I'd been trying to figure out how to do the math myself, but you're probably right in that a spreadsheet isn't a great place to be attempting optimization solutions).

I am curious if you're planning on adding new features to it, though? Perhaps expanding it to include low/null ores, or the ability to take into account different specific ore reprocessing skill levels?

Either way, I thank you for the tool as it exists currently. It saves me a lot of time and headache trying to manually input different compressed ore quantities into a table to figure out the optimal combination for my blueprints.
Qoi
Exert Force
#6 - 2014-08-02 20:02:03 UTC  |  Edited by: Qoi
Steve Ronuken wrote:
muhahahah! tread hijack Blink

https://www.fuzzwork.co.uk/blueprint/api/xml.php?typeid=1320
https://www.fuzzwork.co.uk/blueprint/api/xml.php?typeid=1320&type=attribute (this link works, but the forum screws it up. C&P it.)


Away!

Grrrrr!!

Didn't even link to a documentation, you must be working for CCP! Shocked

Richard Strohker wrote:
The Compressed Ore calculator is quite nice to have in my spreadsheet (I'd been trying to figure out how to do the math myself, but you're probably right in that a spreadsheet isn't a great place to be attempting optimization solutions).

I am curious if you're planning on adding new features to it, though? Perhaps expanding it to include low/null ores, or the ability to take into account different specific ore reprocessing skill levels?

Either way, I thank you for the tool as it exists currently. It saves me a lot of time and headache trying to manually input different compressed ore quantities into a table to figure out the optimal combination for my blueprints.

I'm more comfortable keeping it as simple as possible. I don't think there is a big reason to add compressed high-end minerals, the volumes involves are fairly negligible compared to the low-ends and you are probably much better off buying the minerals themselves that someone reprocessed for you in a shiny 60% outpost.

If you have already imported it into your spreadsheet you can retroactively account for different skill levels and even the +5% and +10% versions. You can probably just set the rate to 100% and then divide the results you get by the actual reprocessing rates.

Basically every time i think about adding all these options i go to https://www.fuzzwork.co.uk/compression/ and click on "Things affecting reprocessing" and i end up having many unhappy thoughts.

http://eve-industry.org
Angie Chatter
#7 - 2014-08-02 20:47:37 UTC
Qoi wrote:
so i made an API for the system cost indices as well as the base job installation costs of blueprints.

http://api.eve-industry.org


Any plans to add T3 support? I don't get any numbers for any of the T3 BPC or components.
Qoi
Exert Force
#8 - 2014-08-02 21:38:44 UTC
Angie Chatter wrote:
Qoi wrote:
so i made an API for the system cost indices as well as the base job installation costs of blueprints.

http://api.eve-industry.org


Any plans to add T3 support? I don't get any numbers for any of the T3 BPC or components.


Hmm, the API is currently case-sensitive, so searching for tengu instead of Tengu would not work, but apart from that i'm not sure what is wrong. What URL are you requesting?

It works fine for me: https://c.1tau.de/public.php?service=files&t=1194e93b3a9c44b22c7e5afebc1597f7

http://eve-industry.org
Angie Chatter
#9 - 2014-08-02 21:55:54 UTC  |  Edited by: Angie Chatter
Qoi wrote:

Hmm, the API is currently case-sensitive, so searching for tengu instead of Tengu would not work, but apart from that i'm not sure what is wrong. What URL are you requesting?

It works fine for me: https://c.1tau.de/public.php?service=files&t=1194e93b3a9c44b22c7e5afebc1597f7


Silly me i used the final product typeID's instead of the BPC id's. Just tested again and its working, i can also confirm that the results match my own calculated adjPrice based values.

Btw thx for the xml Api, all the new crest stuff with nested json tables is a nightmare to import/work with excel, so this helps a lot.
Richard Strohker
Aliastra
Gallente Federation
#10 - 2014-08-02 23:20:43 UTC
Qoi wrote:
I'm more comfortable keeping it as simple as possible. I don't think there is a big reason to add compressed high-end minerals, the volumes involves are fairly negligible compared to the low-ends and you are probably much better off buying the minerals themselves that someone reprocessed for you in a shiny 60% outpost.

If you have already imported it into your spreadsheet you can retroactively account for different skill levels and even the +5% and +10% versions. You can probably just set the rate to 100% and then divide the results you get by the actual reprocessing rates.

Basically every time i think about adding all these options i go to https://www.fuzzwork.co.uk/compression/ and click on "Things affecting reprocessing" and i end up having many unhappy thoughts.


I suppose you're right on both counts. Honestly it's working just fine for me in its current iteration, so thanks again for making the API for it.
minx1
Salamander Researches And Industries
#11 - 2014-08-10 10:57:12 UTC
Firstly thnks very much for ure XML notes on ure site :)

Got a few question for you or anyone

RE calculations or more specific job cost,

Currently Trying these lines

IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost")
( can't get this one to work )

IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost[@name='Aeon Blueprint']")

( this one works for me )

What am I not doing correctly to get the first one to work ?

2nd question :)

I'm using google docs so with the 50 XML clamp down how do I add multiples to the formula to auto fill the colum?
I use the "&" after each item usualy for pricing ect?

Last one honestly

The job price for RE work how do you now pull the job based cost for example intact hull ?

Thank you in advance for any replys
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#12 - 2014-08-10 18:03:31 UTC
Qoi wrote:
Basically every time i think about adding all these options i go to https://www.fuzzwork.co.uk/compression/ and click on "Things affecting reprocessing" and i end up having many unhappy thoughts.


One option:

With the CORS header now added on TQ, you could have a 'load character sheet into a cookie' option.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Qoi
Exert Force
#13 - 2014-08-10 22:41:21 UTC
minx1 wrote:
Firstly thnks very much for ure XML notes on ure site :)

Got a few question for you or anyone

RE calculations or more specific job cost,

Currently Trying these lines

IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost")
( can't get this one to work )

IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost[@name='Aeon Blueprint']")

( this one works for me )

What am I not doing correctly to get the first one to work ?

2nd question :)

I'm using google docs so with the 50 XML clamp down how do I add multiples to the formula to auto fill the colum?
I use the "&" after each item usualy for pricing ect?

Last one honestly

The job price for RE work how do you now pull the job based cost for example intact hull ?

Thank you in advance for any replys


1. The first one definitely worked for me before, but google docs has been rather broken for me when i tested my API. I find spreadsheets too hard to use so i don't really have much experience here.

2. You can use comma separated names, like ?names=Avatar,Aeon,Expanded Cargohold II

3. The job base cost for invention and reverse engineering is linked to the blueprint you are producing, so if you are trying to reverse engineeer a defensive subsystem you can probably just use the job base cost from any defensive subsystem blueprint, i think they are all the same because they require the same materials to build.

If they should be different, you have to request the job base cost for all potential outcomes and calculate their arithmetic mean.


http://eve-industry.org
Katla Mikla
Doomheim
#14 - 2014-09-08 02:22:45 UTC
Is the site down, and if so, will it be back up?
Qoi
Exert Force
#15 - 2014-09-09 12:00:24 UTC
There had been some hardware issues yesterday during the night, it should be working normally now.

http://eve-industry.org
Angie Chatter
#16 - 2014-10-03 13:22:46 UTC  |  Edited by: Angie Chatter
Hi,

for some reason i don't see updated indexes? If i compare your returned values to Fuzzworks or in-game, they are off by quite a bit, are u sure your server is still updating?
Sheri Angela
#17 - 2014-10-03 20:29:25 UTC
It was off last night and this morning (US CST) both on Index and Adjusted Price.

TIDI = Increasing profit while decreasing service level to the customer disguised a nicely marketed benefit. What would Amazon have done here.
Angie Chatter
#18 - 2014-10-05 11:09:54 UTC  |  Edited by: Angie Chatter
The cost index database is still out of date and seems to display values from 2-4 days ago?
Would be great to get this fixed, so i can import instead of manually editing my sheet.

thx
Nalha Saldana
Aliastra
Gallente Federation
#19 - 2014-10-06 13:53:17 UTC
I don't got how i get the invention cost for a item, is that just supposed to be the base job installation cost of the t1 item multiplied by the invention system cost index?
Angie Chatter
#20 - 2014-10-06 14:04:09 UTC
Nalha Saldana wrote:
I don't got how i get the invention cost for a item, is that just supposed to be the base job installation cost of the t1 item multiplied by the invention system cost index?


Basically yes, but multiplied also by 0.02. Just check this pdf: IndustryFormulas.pdf
12Next page