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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Need help with spreadsheet and API content
Author
Previous Topic Next Topic
Iris Bravemount
Golden Grinding Gears
#1 - 2012-09-26 14:52:28 UTC
First of all, I'd like to know if the following things are possible:

1) Fetch the average price of a given item in a given station. (I am pretty sure you can do this, just want to be sure).

2) Fetch the required materials and the production time for a given BPO/BPC in my corp hangar.

3) Put the above two in an Excel or Google doc spreadsheet.

4) Being able to refresh the data in one (or just a few) click(s), without it refreshing automatically so as not to spam the API server needlessly.

Simple answers please, just YES/NO, maybe a link to a tutorial. I'll figure the rest out by myself.

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-09-26 15:06:51 UTC  |  Edited by: Steve Ronuken
1: Not from the Eve API. It has no market functionality. But there are sites like eve central, eve market data and eve marketeer which provide an api you can use. Consider using the percentile price, rather than the average. It's an average from a simulated buy/sell of 5% of the market. weeds out the highs and lows.

2: No api for this. The details are all in the database extract. There are a bunch of caveats you have to take into account with them. However, check out the blueprint calculator on the site in my sig. the bare tables or xml option would likely be of interest to you.

3: Entirely doable. Excel is easier, as it handles XML better.

4: Again, easily doable. You'd be using the import from web option which embeds the results as a datasource you can reload.




You'll probably also want to grab the typeid export from the front page of my site. most api stuff works on typeids, rather than typenames, so I dumped a csv of them in a form useful for vlookups (typeid, typename, typeid for bidirectional lookups)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Iris Bravemount
Golden Grinding Gears
#3 - 2012-09-26 16:20:22 UTC
Steve Ronuken wrote:
1: Not from the Eve API. It has no market functionality. But there are sites like eve central, eve market data and eve marketeer which provide an api you can use. Consider using the percentile price, rather than the average. It's an average from a simulated buy/sell of 5% of the market. weeds out the highs and lows.


Ok, that's what I thought. Thanks.

Quote:
2: No api for this. The details are all in the database extract. There are a bunch of caveats you have to take into account with them. However, check out the blueprint calculator on the site in my sig. the bare tables or xml option would likely be of interest to you.


If I can't fetch the ME and PE levels of my BPs somehow, I would still have to enter them all manually, which somewhat ruins the whole point of making my spreadsheet.

Quote:
3: Entirely doable. Excel is easier, as it handles XML better.


I copied the example form the EvE central tutorial in Excel 2010 and got an error. Copied it into google docs and it worked. Got an idea for this one ?

Quote:
4: Again, easily doable. You'd be using the import from web option which embeds the results as a datasource you can reload.


Good, thanks.

Quote:
You'll probably also want to grab the typeid export from the front page of my site. most api stuff works on typeids, rather than typenames, so I dumped a csv of them in a form useful for vlookups (typeid, typename, typeid for bidirectional lookups)


Nice site. Will definately bookmark it. Big smile

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-09-26 17:34:50 UTC
ME and PE for blueprints are /kinda/ retrievable from the API. I was talking about the actual material requirements.

When I say kinda retrievable, you can pull the details from the industry api for the last bunch of jobs you've run. Which will include the numbers.

Everything else is manual, I'm afraid. The assets API doesn't hold it.


For excel:

Take your eve central api url
http://api.eve-central.com/api/marketstat?typeid=34&typeid=35&regionlimit=10000002
for example.
Then go to the data tab and hit 'import from web' (iirc).
Paste in the url. It should ask a few questions then add it to the specified worksheet as a table.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Iris Bravemount
Golden Grinding Gears
#5 - 2012-09-26 19:53:42 UTC
Thank you very much, you really helped me a lot!

So, if I enter the ME and PE levels manually, can I use your web based BPO calculator to send my input to it and get the required materials sent to my spreadsheet?

This way I could only put in the ME and PE levels and get all the calculations done with formulas and web imports for prices.

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-09-26 20:35:34 UTC
Yup. Smile


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Iris Bravemount
Golden Grinding Gears
#7 - 2012-09-26 20:39:05 UTC
Steve Ronuken wrote:
Yup. Smile




Awesome!Big smile

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Iris Bravemount
Golden Grinding Gears
#8 - 2012-09-26 22:04:36 UTC
Ok, I got this far:

http://www.fuzzwork.co.uk/blueprints/xml/12056/20/5

How can I also set my PE and Industry skill levels in the request?

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#9 - 2012-09-27 09:37:23 UTC
Iris Bravemount wrote:
Ok, I got this far:

http://www.fuzzwork.co.uk/blueprints/xml/12056/20/5

How can I also set my PE and Industry skill levels in the request?



Your ME and Production efficiency is handled there. (just to make sure we're talking about the right PE.)


I didn't implement the times on it, though those are simple enough for you to add locally.

If the BP PE is less than 0


time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE-1)));

if it's higher:

time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE/(1+Blueprint PE))));


Where time is the blueprints inherent times.

To get the time with your industry included:

time * (1 - (.04 * Your industry))



I may go and add the time calculations in to the xml output, but that'll be a while. (I'm at work)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Iris Bravemount
Golden Grinding Gears
#10 - 2012-09-27 10:22:16 UTC
Steve Ronuken wrote:
Iris Bravemount wrote:
Ok, I got this far:

http://www.fuzzwork.co.uk/blueprints/xml/12056/20/5

How can I also set my PE and Industry skill levels in the request?



Your ME and Production efficiency is handled there. (just to make sure we're talking about the right PE.)


I didn't implement the times on it, though those are simple enough for you to add locally.

If the BP PE is less than 0


time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE-1)));

if it's higher:

time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE/(1+Blueprint PE))));


Where time is the blueprints inherent times.

To get the time with your industry included:

time * (1 - (.04 * Your industry))



I may go and add the time calculations in to the xml output, but that'll be a while. (I'm at work)


Oh, yeah, I may just as well put the formula in the spreadsheet, that should do.

Now I'm running into a completely different problem. When I manually type in something like this:

http://www.fuzzwork.co.uk/blueprints/xml/21038/50/5

I get an empty xml file. The map is there, but the content isn't, although it recognizes the TypeID correctly. Is there something else I need to put in the request URL ?

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2012-09-27 11:43:13 UTC
It works by the id of what you're making, rather than the ID of the blueprint that you're using.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Iris Bravemount
Golden Grinding Gears
#12 - 2012-09-27 11:45:31 UTC
Steve Ronuken wrote:
It works by the id of what you're making, rather than the ID of the blueprint that you're using.


Oh, ok !

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Iris Bravemount
Golden Grinding Gears
#13 - 2012-09-27 13:19:56 UTC
Hmm, your XML map spits out the mineral amounts in lines instead of columns because the various minerals are attributes of the "material" element, resulting in somthing like this:

< totalamount >
< material type="tritanium" id="34" amount="123" >
< material type="pyerite" id="35" amount="123" >
< /totalamount >

Is there a way (or another site) to get something more like this?

< totalamount >
< tritanium id="34" > 123 < /tritanium >
< pyerite id="35" > 123 < /pyerite >
< /totalamount >

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#14 - 2012-09-27 14:17:39 UTC
Iris Bravemount wrote:
Hmm, your XML map spits out the mineral amounts in lines instead of columns because the various minerals are attributes of the "material" element, resulting in somthing like this:

< totalamount >
< material type="tritanium" id="34" amount="123" >
< material type="pyerite" id="35" amount="123" >
< /totalamount >

Is there a way (or another site) to get something more like this?

< totalamount >
< tritanium id="34" > 123 < /tritanium >
< pyerite id="35" > 123 < /pyerite >
< /totalamount >




http://www.fuzzwork.co.uk/blueprints/xml2/12056/20/5/0/5

Type id, ME, Production efficiency skill, Blueprint PE, Industry

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Iris Bravemount
Golden Grinding Gears
#15 - 2012-09-27 14:21:19 UTC
Steve Ronuken wrote:
Iris Bravemount wrote:
Hmm, your XML map spits out the mineral amounts in lines instead of columns because the various minerals are attributes of the "material" element, resulting in somthing like this:

< totalamount >
< material type="tritanium" id="34" amount="123" >
< material type="pyerite" id="35" amount="123" >
< /totalamount >

Is there a way (or another site) to get something more like this?

< totalamount >
< tritanium id="34" > 123 < /tritanium >
< pyerite id="35" > 123 < /pyerite >
< /totalamount >




http://www.fuzzwork.co.uk/blueprints/xml2/12056/20/5/0/5

Type id, ME, Production efficiency skill, Blueprint PE, Industry


You rock :)

"I will not hesitate when the test of Faith finds me, for only the strongest conviction will open the gates of paradise. My Faith in you is absolute; my sword is Yours, My God, and Your will guides me now and for all eternity." - Paladin's Creed