Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Izaac Klark
School of Applied Knowledge Caldari State
0
|
Posted - 2017.02.21 12:18:44 -
[1] - Quote
So I'm trying to set up a spreadsheet relating to Industry and I need to factor Job Cost into my calculations to find out whether something is profitable to manufacture. But I have absolutely no idea where the 'Estimated Item Value (EIV)' is derived from. It seems to be completely random; it's not universal average price of the product, not relating to the cost of the materials required or anything.
Does anyone know how this EIV value is calculated? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6492
|
Posted - 2017.02.21 12:29:22 -
[2] - Quote
it's based off the 'adusted price' from one of the market endpoints.
https://esi.tech.ccp.is/latest/Market/get_markets_prices
And based off an ME 0 build.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Izaac Klark
School of Applied Knowledge Caldari State
0
|
Posted - 2017.02.21 12:39:44 -
[3] - Quote
Ok thanks. Helped me out of a bind there. |
Cy4n1d
Ice Labs Inc.
0
|
Posted - 2017.02.22 21:50:31 -
[4] - Quote
Do you have maybe a Guide/Tutorial how i can implant this to a Google Docs Spreadsheet? For example for Capital Armor Plates? |
guigui lechat
the no fock given
19
|
Posted - 2017.03.28 21:46:31 -
[5] - Quote
https://esi.tech.ccp.is/latest/markets/prices/
is working now. Took me long enough to find out GǪ |
guigui lechat
the no fock given
19
|
Posted - 2017.03.28 23:41:38 -
[6] - Quote
ok so it's the sum of all component prices, taken from the market esi, multiplied by the required number of run.
it actually does NOT consider the output of the BP, only the used materials, and as stated, with ME=0. |
Nadejda Volkov
Hedion University Amarr Empire
0
|
Posted - 2017.03.29 16:33:47 -
[7] - Quote
guigui lechat wrote:https://esi.tech.ccp.is/latest/markets/prices/
is working now. Took me long enough to find out GǪ
Does this update on itself? I'm also looking for something like that but it needs to be reliable in a few months or longer down the road. |
Zarek Kree
Lunatic Legion Holdings
76
|
Posted - 2017.03.29 16:56:56 -
[8] - Quote
I use an XML to pull it from eve-industry.org. I just plug this code I plug into my spreadsheet:
=IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Photon Microprocessor","//job-base-cost")
Simply replace "Photon Microprocessor" with the name of whatever component you're using. It's never more than a few hours behind the EIV used in-game and I've never seen it go down. |
Nadejda Volkov
Hedion University Amarr Empire
0
|
Posted - 2017.03.30 06:25:40 -
[9] - Quote
Thank you, I got it working. The original link you posted didn't work for me but at http://api.eve-industry.org/ arethe URL examples that work for excel. |
Zarek Kree
Lunatic Legion Holdings
92
|
Posted - 2017.03.30 06:33:38 -
[10] - Quote
Nadejda Volkov wrote:Thank you, I got it working. The original link you posted didn't work for me but at http://api.eve-industry.org/ arethe URL examples that work for excel.
Ah, yeah, sorry. I forget that not everybody uses Google Sheets. I've always preferred Excel as well but it doesn't play as nice with some of the EVE API pulls. |
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |