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.
 

n00b: Open Office spreadsheet with Api
Author
Previous Topic Next Topic
Mynutor
Myn Industries
#1 - 2014-01-30 18:09:25 UTC
I would like to create a very basic open office spreadsheet with the basic high sec mineral and ore prices.

I managed to find the typeids (I need 34, 35, 36, 37, 38 etc.)

I guess that would be something like this

http://api.eve-central.com/api/marketstat?typeid=34

I would like to have only Jita rpices

I guess that would be something like this:

http://api.eve-central.com/api/marketstat?typeid=34&regionlimit=10000002

-

I couldn't figure out how to import this to open office. I know it can be done with excel quite easily.

Could anyone help me out, or is there a guide/tutorial for this somewhere?

Objective sighted. Target locked. Lasers activated. Pew-pew-pew. Die roid..., DIE!

Mynutor
Myn Industries
#2 - 2014-01-30 18:19:17 UTC
I did some google search, a google docs version would be also fine.

I have found this line:

=ImportXML("http://eve-marketdata.com/api/item_prices_jita.xml?type_ids="&JOIN(",",$B2:$B88), "/eve/price")

where I don't understand the last part, but I guess

=ImportXML("http://eve-marketdata.com/api/item_prices_jita.xml?type_ids=34

should work?

Objective sighted. Target locked. Lasers activated. Pew-pew-pew. Die roid..., DIE!

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2014-01-31 10:29:00 UTC
Admiral Gray Beard
Hedion University
Amarr Empire
#4 - 2014-02-01 22:50:26 UTC
Sounds like you might be setting up a spreadsheet system.

Check this out: https://sourceforge.net/projects/evemanufacturing/?source=directory

Might make it easy for you?
Mynutor
Myn Industries
#5 - 2014-02-01 23:35:47 UTC
Thank you guys.

Objective sighted. Target locked. Lasers activated. Pew-pew-pew. Die roid..., DIE!

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2014-02-02 17:48:48 UTC
Admiral Gray Beard wrote:
Sounds like you might be setting up a spreadsheet system.

Check this out: https://sourceforge.net/projects/evemanufacturing/?source=directory

Might make it easy for you?



I've not looked at that.

Does it handle Material Efficiency (skill basedm as they've renamed the skill) waste properly, for extra materials?

It's a common failing.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter