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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Confused as how 'Total Job Cost' is Calculated, please help.

First post
Author
Previous Topic Next Topic
Izaac Klark
State Protectorate
Caldari State
#1 - 2017-02-21 12:18:44 UTC
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
#2 - 2017-02-21 12:29:22 UTC  |  Edited by: Steve Ronuken
it's based off the 'adjusted price' from one of the market endpoints.

https://esi.tech.ccp.is/latest/Market/get_markets_prices

And based off an ME 0 build.

edit: added a missing j

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Izaac Klark
State Protectorate
Caldari State
#3 - 2017-02-21 12:39:44 UTC
Ok thanks. Helped me out of a bind there.
Cy4n1d
Doomheim
#4 - 2017-02-22 21:50:31 UTC
Steve Ronuken wrote:
it's based off the 'adjusted price' from one of the market endpoints.

https://esi.tech.ccp.is/latest/Market/get_markets_prices

And based off an ME 0 build.

edit: added a missing j


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
#5 - 2017-03-28 21:46:31 UTC
https://esi.tech.ccp.is/latest/markets/prices/

is working now. Took me long enough to find out …
guigui lechat
the no fock given
#6 - 2017-03-28 23:41:38 UTC
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
Rapid Mouse Tracking
#7 - 2017-03-29 16:33:47 UTC
guigui lechat wrote:
https://esi.tech.ccp.is/latest/markets/prices/

is working now. Took me long enough to find out …


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
#8 - 2017-03-29 16:56:56 UTC
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
Rapid Mouse Tracking
#9 - 2017-03-30 06:25:40 UTC
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
#10 - 2017-03-30 06:33:38 UTC
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.