Science & Industry

So been gone for a long long time.

now i am back and want keep doing what i did.

making t2 modules mainly.

any how i used to have excel sheets of everything, they sadly got deleted, as i never thought i would come back .
anyway, seems that alot of stuff have changed, and so has the way to get info on items required building materials, base refine values of t1 items.

as i can understand now, you need to have some basic programmer skills, use off api and some static data dumb to pull this information you want out now, then just look it up with a few clicks.

i used to use evewallet, to pull out info on adv cost and sell prices and use that for figureing out my profit,
as eve-central prices are useless to me, to figure out profit of the week.

so question is, have i over looked anything? or do i need to learn php, SQL or whatever it is, to pull out data to my sheets?

thanks for you time reading this even if you don´t respond.

The primary means of pulling data for most players is through XML, as mentioned above. This can be done in Google docs or in Excel; you could probably find good arguments for either one. I use Excel myself because I was already familiar with it.

I'd go into more detail, but you mention that eve-central prices are useless to you. I'm curious as to why that is?

Excel has VB scripting for macros and functions. It's extremely useful but somewhat difficult to learn. Official documentation is kind of garbage. It's weird about typing, and often difficult to debug. If you need to learn something specific, you just kind of hope someone has asked a similar question on a forum somewhere.

https://forums.eveonline.com/default.aspx?g=posts&t=8074

That will get you a spreadsheet. Best one on industry I've seen.

I used to use excel, and its basic commands and stuff to greate my overview of profit over the week, with numbers i got from evewallet, as to how many items i had sold and at what adv price. it was really good as i could get the data from set date 11/8 and 7 days forward.

I acturly tried an inportxml line in my excel, but it did not work. i got it from reddit it should be working, but it gets somekind of error.

=importxml("http://api.eve-central.com/api/marketstat?typeid=34&usesystem=30000142","//sell/min")

that was the line.

i look at the link and i get what it does, from viewing the data, and i assume i could do the same, to get basic material buildings req of items useing code as well.
eve tho i would think it would be easyer to just have a list and copy past it, like the old times :) .


as to why eve-central prices is useless to me?
I would sell or buy materials daily, i would use the adv price of materials for the week to figure out the building cost for t2 production, not some adv prices of some trade hub.
then i would have the adv build cost, of item i had sold. take that away from what it was sold for, and i would see how much i made. ofc i would take running costs pos tax and so on, into the calculations.
i wanted to know how much i made that week.

they would proberly be at use, for look at prices in other areas, then where i am.
but to use in my calculations for profit. i can´t use adv prices of items from every order that day.

eve-central would give you and idear of the price of an item, no?
if you are trying to get price what it would cost you to build something, you could get an idear of that.

but you can only get the corret cost price, by getting the price of what you acutrly bought the materials for.

The database is found here: http://community.eveonline.com/community/fansites/toolkit/

You can just upload it in SQL Express and then copy the data to excel.

The uploading part is pretty easy, but you'll need to know SQL to query the data in any meaningful form. Some tables you can just Select * from but most data isn't that simple. So to just get you the "data in Excel format" really isn't going to be that easy unless you know what data you want and someone can run a quick query for you.

You're already using the price data from a specific system, if you're using the example that you posted above. The "usesystem=30000142" part of the url you're using tells the eve-central api to give you data for that particular system only.

Check this out for more info:
http://dev.eve-central.com/evec-api/start

Also, I found this video to be useful in getting my own spreadsheet going.
https://www.youtube.com/watch?v=bLm0FQD_cN4

Though I can tell you that the type IDs in his sample spreadsheet are truncated, and you can simply delete the first column of numbers in the typeID sheet as it's not used for anything at all, and counts towards the number of cells that you're allowed to use in one spreadsheet.

You should replace those type IDs with this updated and full list of all type IDs:
http://www.fuzzwork.co.uk/resources/typeids.csv

Hopefully that'll be a bit of help!