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.
 

Manufacturing Calculations - What am I missing?

First post
Author
Previous Topic Next Topic
Cryten Jones
Advantage Inc
#1 - 2015-08-25 16:46:40 UTC  |  Edited by: Cryten Jones
I thought that I had this down in the past but something has slipped though the age gaps :-)

Taking a tristan as an example:

New Blueprint (In Game):

Trit: 23,333


10% ME Researched Blueprint (In Game):

Trit: 21,000


industryActivityMaterials sheet from Fuzzyworks.

Trit: 21,111



I can't get the numbers to work.. should the SDE number not be 23,333 ???
Ydnari
Estrale Frontiers
#2 - 2015-08-25 18:58:57 UTC
It is.

mysql> select quantity from industryActivityMaterials where typeID = 940 and activityID = 1 and materialTypeID = 34;
+----------+
| quantity |
+----------+
|    23333 |
+----------+
1 row in set (0.01 sec)



940 is Tristan Blueprint, activity ID 1 is manufacturing, type ID 34 is trit.

--
Cryten Jones
Advantage Inc
#3 - 2015-08-25 19:28:06 UTC
Ydnari wrote:
It is.

mysql> select quantity from industryActivityMaterials where typeID = 940 and activityID = 1 and materialTypeID = 34;
+----------+
| quantity |
+----------+
|    23333 |
+----------+
1 row in set (0.01 sec)



940 is Tristan Blueprint, activity ID 1 is manufacturing, type ID 34 is trit.




This is exactly what I expected.. I think that Fuzysteve's export has an error in the xls files...
Cryten Jones
Advantage Inc
#4 - 2015-08-25 23:54:16 UTC
Ignore me.. stupid type error !
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-08-26 02:18:36 UTC
Just as a quick note:

The xls file is just an export from the table Smile It's unlikely that they wouldn't match. (Yes, I know about a certain solar system name not working right. It's a hard one to fix without rewriting an export function. Which I may do, as I'm now far more comfortable with python and its csv handling.)

Not matching what's in game is more possible Smile As it's a conversion from the blueprint.yaml file, into multiple tables. I haven't come across any errors (since I wrote it and tested it. That was recently for this one, as I recently moved from php to python for the script) but it's very dependant on the data structure staying the same.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter