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.
 

Crius data

First post
Author
Allan Ahr
Connexion Found
Trans - Porc
#1 - 2014-07-22 14:30:56 UTC
Hello i'm looking for the following information :

- Does crius change the ME/PE equations.
(http://wiki.eve-id.net/Equations <- these equations)
- Where can I find the new base materials for BPOs
(http://games.chruker.dk/eve_online/item.php?type_id=684 <- Like this)

Thank you very much.
Qoi
Exert Force
#2 - 2014-07-22 14:38:55 UTC  |  Edited by: Qoi
PE is now called TE and it reduces the time by a percentage, the percentage is displayed in the client.

ME is slightly more involved,

required material amount = MAX( number of runs, CEIL( number of runs * (1 - ME/100) * facility modifier * base material amount))

The base materials are in the static data export as always, if you want a website, you can use my calculator here: http://1tau.de/684

http://eve-industry.org

Chuck Dgrow
The Scope
Gallente Federation
#3 - 2014-07-22 14:41:57 UTC  |  Edited by: Chuck Dgrow
Quote:

Qoi wrote:
required = MAX(Number of Runs, CEIL( baseAmount * Number of Runs * MaterialModifier))


Quote:

CCP Nullarbor wrote :

Confirming this is the correct formula with MaterialModifier = 1 - (ME / 100)

Any additional modifiers due to teams / facility bonuses / whatever would be multiplied by the base amount and runs BEFORE doing a CEIL to round it out to an integer. This is a significant difference from the previous industry system, where more runs may decrease your required materials per run by a noticeable amount.

The new UI will show you all of this information live by scrolling the runs up and down, or switching between facilities / teams etc.

Or you can calculate it all yourself with a spreadsheet of course


from : https://forums.eveonline.com/default.aspx?g=posts&t=358921&p=2

As for the static data, im trying to find some way to either put back the yaml data into a SQL or excel table ... but no success so far
Qoi
Exert Force
#4 - 2014-07-22 14:53:04 UTC  |  Edited by: Qoi
Chuck Dgrow wrote:

As for the static data, im trying to find some way to either put back the yaml data into a SQL or excel table ... but no success so far


That's what fuzzysteve has already done here:

https://www.fuzzwork.co.uk/dump/

(Specifically, https://www.fuzzwork.co.uk/dump/crius-1.0-100038/industryActivityMaterials.sql.bz2 for base material amounts)

http://eve-industry.org

Qoi
Exert Force
#5 - 2014-07-22 15:03:24 UTC
If anyone is looking for a version that can be imported into your spreadsheet application, i made a quick CSV version here.

http://eve-industry.org

Chuck Dgrow
The Scope
Gallente Federation
#6 - 2014-07-22 15:04:16 UTC  |  Edited by: Chuck Dgrow
nm
Chuck Dgrow
The Scope
Gallente Federation
#7 - 2014-07-22 15:05:29 UTC
Qoi wrote:
If anyone is looking for a version that can be imported into your spreadsheet application, i made a quick CSV version here.



Nice ! Thank you. Mind to let me know how you did that ?
Allan Ahr
Connexion Found
Trans - Porc
#8 - 2014-07-22 15:06:52 UTC
Tell me if i'm doing it wrong, but using google doc the function for CEIL is CEILING() and it requires 2 arguments.

I'm trying to do it for a harpy blueprint (me -8% run 8)

=MAX(8, CEILING(BASEMATERIAL*8*(1-(8/100)),1))

The 1 being the 2nd argument of the CEILING() function in google spreadsheet.
Qoi
Exert Force
#9 - 2014-07-22 15:46:07 UTC  |  Edited by: Qoi
Chuck Dgrow wrote:
Qoi wrote:
If anyone is looking for a version that can be imported into your spreadsheet application, i made a quick CSV version here.



Nice ! Thank you. Mind to let me know how you did that ?


On the postgresql prompt (psql):

Quote:

eve=> \copy (
SELECT
t1."typeID" AS "blueprintID",
t1."typeName" AS "blueprint",
t2."typeID" AS "materialID",
t2."typeName" AS "material",
m.quantity,
m.consume
FROM "industryActivityMaterials" m
JOIN "invTypes" t1 ON (m."typeID" = t1."typeID")
JOIN "invTypes" t2 ON (m."materialTypeID" = t2."typeID")
WHERE "activityID" = 1 ORDER BY t1."typeName")
TO materials.csv WITH CSV HEADER;


PS: If these forums were not.. lets say.. ridiculously bad, that would even be properly indented.

http://eve-industry.org

Azarion Sinak
Imperial Shipment
Amarr Empire
#10 - 2014-07-22 20:53:47 UTC
Qoi wrote:
Chuck Dgrow wrote:
Qoi wrote:
If anyone is looking for a version that can be imported into your spreadsheet application, i made a quick CSV version here.



Nice ! Thank you. Mind to let me know how you did that ?


On the postgresql prompt (psql):

Quote:

eve=> \copy (
SELECT
t1."typeID" AS "blueprintID",
t1."typeName" AS "blueprint",
t2."typeID" AS "materialID",
t2."typeName" AS "material",
m.quantity,
m.consume
FROM "industryActivityMaterials" m
JOIN "invTypes" t1 ON (m."typeID" = t1."typeID")
JOIN "invTypes" t2 ON (m."materialTypeID" = t2."typeID")
WHERE "activityID" = 1 ORDER BY t1."typeName")
TO materials.csv WITH CSV HEADER;


PS: If these forums were not.. lets say.. ridiculously bad, that would even be properly indented.


Would be really great to have the productID and quantity produced per run in there as well. Only things missing that would make this perfect.
Chuck Dgrow
The Scope
Gallente Federation
#11 - 2014-07-23 14:27:58 UTC
Azarion Sinak wrote:
Qoi wrote:
Chuck Dgrow wrote:
Qoi wrote:
If anyone is looking for a version that can be imported into your spreadsheet application, i made a quick CSV version here.



Nice ! Thank you. Mind to let me know how you did that ?


On the postgresql prompt (psql):

Quote:

eve=> \copy (
SELECT
t1."typeID" AS "blueprintID",
t1."typeName" AS "blueprint",
t2."typeID" AS "materialID",
t2."typeName" AS "material",
m.quantity,
m.consume
FROM "industryActivityMaterials" m
JOIN "invTypes" t1 ON (m."typeID" = t1."typeID")
JOIN "invTypes" t2 ON (m."materialTypeID" = t2."typeID")
WHERE "activityID" = 1 ORDER BY t1."typeName")
TO materials.csv WITH CSV HEADER;


PS: If these forums were not.. lets say.. ridiculously bad, that would even be properly indented.


Would be really great to have the productID and quantity produced per run in there as well. Only things missing that would make this perfect.


Run this query, taht should give you what you need :


SELECT
t4.typeName AS "Product",
t3.quantity AS "produced",
t1.typeID AS "blueprintID",
t1.typeName AS "blueprint",
t5.maxProductionLimit AS "production limit",
t2.typeID AS "materialID",
t2.typeName AS "material",
m.quantity,
m.consume
FROM industryActivityMaterials m
JOIN invTypes t1 ON (m.typeID = t1.typeID)
JOIN invTypes t2 ON (m.materialTypeID = t2.typeID)
JOIN industryactivityproducts t3 ON (m.typeID = t3.typeID)
JOIN invTypes t4 ON (t3.productTypeID = t4.typeID)
JOIN industryblueprints t5 ON (m.typeID = t5.typeID)
WHERE m.activityID = 1 ORDER BY t1.typeName
Chuck Dgrow
The Scope
Gallente Federation
#12 - 2014-07-23 14:33:53 UTC
Qoi wrote:
PE is now called TE and it reduces the time by a percentage, the percentage is displayed in the client.

ME is slightly more involved,

required material amount = MAX( number of runs, CEIL( number of runs * (1 - ME/100) * facility modifier * base material amount))

The base materials are in the static data export as always, if you want a website, you can use my calculator here: http://1tau.de/684



Something that i dont get from the equation though, the MAX fucntion return you the maxium value between 2 numbers and in this case, its the Number of run or the CEILING function. If the ceiling function = 0 i would get 1 as value instead of the 0

Lets say im doing the equation for a punisher BPO who is at ME 10 and for only 1 run. The equation would be :

MAX(1,CEIL(1*(10/100)*facility*base material))

If the base material is 0 like for Megacyte, the number returned would be 1 since the MAX is made with the Number of run as 1st value.

Anyone can explain that ?

Ty
Azarion Sinak
Imperial Shipment
Amarr Empire
#13 - 2014-07-23 21:37:20 UTC
Chuck Dgrow wrote:
Azarion Sinak wrote:
Qoi wrote:
[quote=Chuck Dgrow][quote=Qoi]If anyone is looking for a version that can be imported into your spreadsheet application, i made a quick CSV version here.



Nice ! Thank you. Mind to let me know how you did that ?


On the postgresql prompt (psql):


Run this query, taht should give you what you need :


SELECT
t4.typeName AS "Product",
t3.quantity AS "produced",
t1.typeID AS "blueprintID",
t1.typeName AS "blueprint",
t5.maxProductionLimit AS "production limit",
t2.typeID AS "materialID",
t2.typeName AS "material",
m.quantity,
m.consume
FROM industryActivityMaterials m
JOIN invTypes t1 ON (m.typeID = t1.typeID)
JOIN invTypes t2 ON (m.materialTypeID = t2.typeID)
JOIN industryactivityproducts t3 ON (m.typeID = t3.typeID)
JOIN invTypes t4 ON (t3.productTypeID = t4.typeID)
JOIN industryblueprints t5 ON (m.typeID = t5.typeID)
WHERE m.activityID = 1 ORDER BY t1.typeName


I would but I don't run cant afford to pollute my development machine with MySQL, PostGres or SQLLite. That's my beef. I shouldn't have to change my programming skills to play a game. The table should have been in the MSSQL dump.
Gizznitt Malikite
Agony Unleashed
Agony Empire
#14 - 2014-10-03 15:58:33 UTC

Where is the industryActivityMaterials and industryblueprints blueprints table coming from.

Does anyone have the query to create these tables (I'm using a SQL server 2012 db created from the datadump)?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#15 - 2014-10-03 17:17:04 UTC
They're coming from my conversion of the database.

Specifically, I'm taking the blueprints.yaml file, and reworking it into around 7 tables.

If you're wanting to import it, I'd suggest:

install an sqlite ODBC driver
grab the sqlite version from my site
import the tables with import/export wizard.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter