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.
 

[Q] Steve's manufacturing spreadsheet
Author
Previous Topic Next Topic
Courtoisie
Doomheim
#1 - 2015-11-12 17:11:54 UTC
Hi,

I have am using one of Steve's spreadsheets to calculate manufacturing cost. It is the one with TYPEID, ACTIVITYI, MATERIALTYPEID, QUANTITY and CONSUME. It is working fine, but when I get the build cost, I get the total job cost, not the price per unit (or item unit price). Is there an easy way of finding out how many items are made from each blueprint?
Songwhistle
School of Applied Knowledge
Caldari State
#2 - 2015-11-12 17:45:25 UTC
A link to the sheet would help considerably.
Courtoisie
Doomheim
#3 - 2015-11-12 18:05:37 UTC  |  Edited by: Courtoisie
I will try to link it when I get home from work. Essentially, I am wondering whether there is a sheet available with blueprint information showing how many units each blueprint job produces.

Is it found in industryActivityProducts https://docs.google.com/spreadsheets/d/1WAWD3coAAhu6ztLOP_LnEIyTl1Eiitiie071D_dBi2M/edit#gid=1726699289

If so, my numbers seem to be off.
Courtoisie
Doomheim
#4 - 2015-11-12 19:04:03 UTC  |  Edited by: Courtoisie
Nevermind. Found it. Thanks!