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.
 

Openoffice Calc Spreadsheet - import market prices?
Author
Previous Topic Next Topic
Kenrick Rashedwa
#1 - 2011-12-19 03:58:46 UTC
Hello!

So have a personal project I'm working on: it's an openoffice.org calc spreadsheet that calculates my profits based on the ongoing costs of things. But I've very rusty at spreadsheets and even rustier with code. Those of you who know openoffice calc and know how and where the data is please help!

1. Where is the best data to download from? eve-market?

2. How do I get openoffice to connect to the data source and show the specific data range. ie. cell a1=1.34 (price of x item)

3. How or what code do I use within openoffice calc say that it will automatically update this data eachtime I open the file....or just update that data when I push a button.

Many, MANY, thanks to anyone and everyone who can help. I've had this spreadsheet for the last 5 months and manually typing in the values is driving me crazy!
Louis Vitton
Viziam
Amarr Empire
#2 - 2011-12-19 06:42:28 UTC
I would suggest using goggle docs it is a simple matter in that.
Max Kolonko
Caldari Provisions
Caldari State
#3 - 2011-12-19 20:22:11 UTC
^this

in google docs you just need to make a list of item ID's
and then add one formula:

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

where $B2:$B88 is range where you put list of ID's

and thats all

link to premade spreadsheet i used for my WH loot calculations (only the price part :P)

https://docs.google.com/spreadsheet/ccc?key=0Ah-Ywx4kXYj_dEd4UzY0QVJKekdxQVFlY29HcDU4NVE

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?
Kenrick Rashedwa
#4 - 2011-12-19 20:46:03 UTC
I might go with google docs....

But surely openoffice calc has a function to do the same thing...

Does anyone know where to look for this? I've openoffice help forms, but apparently open source means, open to everyone who doesn't know how to write coherent instructions for this.

thanks again for the advice...but surely someone knows something about openoffice....
Max Kolonko
Caldari Provisions
Caldari State
#5 - 2011-12-19 21:37:58 UTC  |  Edited by: Max Kolonko
I generally like open source products.

I'm excel expert at my work, so i tried openoffice, to know if it is better or worse.

And even tough it have basic excel functionality, it still suck...

So after two days of playing, I dropped it altoghever and never got back

Now google docs is more or less MS Excel, so it have most MS Excel functions and functionalities.

Still, even Excell suck at getting remote data from XML's (interface is horrid, you can't use XPath as far as i know) - so for getting web data i go with Google Docs even over MS Excel. And open office is waaaay behind both

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?
Tonto Auri
Vhero' Multipurpose Corp
#6 - 2011-12-19 22:35:02 UTC
Max Kolonko wrote:
I generally like open source products.

I'm excel expert at my work, so i tried openoffice, to know if it is better or worse.

And even tough it have basic excel functionality, it still suck...

You just don't know how to cook it.
It can do much more than Excel, and more so - on many different platforms.
Do your belowed Excel runs on Windows, Linux and Mac at the same time, opening the smae documents?

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Max Kolonko
Caldari Provisions
Caldari State
#7 - 2011-12-19 22:45:21 UTC
Tonto Auri wrote:
Max Kolonko wrote:
I generally like open source products.

I'm excel expert at my work, so i tried openoffice, to know if it is better or worse.

And even tough it have basic excel functionality, it still suck...

You just don't know how to cook it.
It can do much more than Excel, and more so - on many different platforms.
Do your belowed Excel runs on Windows, Linux and Mac at the same time, opening the smae documents?


I dont care, my company runs exlusively on windows.

When You buy a car, do You consider if it can also ride on a desert, when You live in mountains?

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?
Kenrick Rashedwa
#8 - 2011-12-20 04:16:24 UTC
Alright, before this becomes a trolling flame war -

I appreciate the google docs input - this seems to be my most likely course of action...

BUT

Does anyone have experience at this stuff with openoffice?
Fubar
Eagle Eye Inc.
#9 - 2011-12-20 15:53:21 UTC
Kenrick Rashedwa
#10 - 2011-12-21 22:11:02 UTC
Fubar wrote:
See the EVE-Central Tips and Tricks


AH! Thanks Fubar!

Future views refer to another thread:
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1190856


-Ken