Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Allan Ahr
Vasta Enterprises
0
|
Posted - 2014.07.22 14:30:00 -
[1] - Quote
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
16
|
Posted - 2014.07.22 14:38:00 -
[2] - Quote
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 |
Chuck Dgrow
Sun Micro Systems
10
|
Posted - 2014.07.22 14:41:00 -
[3] - Quote
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
16
|
Posted - 2014.07.22 14:53:00 -
[4] - Quote
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/
|
Qoi
Exert Force
16
|
Posted - 2014.07.22 15:03:00 -
[5] - Quote
If anyone is looking for a version that can be imported into your spreadsheet application, i made a quick CSV version here. |
Chuck Dgrow
Sun Micro Systems
10
|
Posted - 2014.07.22 15:04:00 -
[6] - Quote
I tried that to, seem there is stuff missing in his industryblueprint tab.
The yaml data contain everything you need and his tab only show typeID and maxProductionLimit
Something i must not understand
|
Chuck Dgrow
Sun Micro Systems
10
|
Posted - 2014.07.22 15:05:00 -
[7] - Quote
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
Vasta Enterprises
0
|
Posted - 2014.07.22 15:06:00 -
[8] - Quote
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
16
|
Posted - 2014.07.22 15:46:00 -
[9] - Quote
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. |
Azarion Sinak
Apollo Technologies Inc
0
|
Posted - 2014.07.22 20:53:00 -
[10] - Quote
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
Sun Micro Systems
11
|
Posted - 2014.07.23 14:27:00 -
[11] - Quote
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
Sun Micro Systems
11
|
Posted - 2014.07.23 14:33:00 -
[12] - Quote
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
Apollo Technologies Inc
0
|
Posted - 2014.07.23 21:37:00 -
[13] - Quote
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
4148
|
Posted - 2014.10.03 15:58:00 -
[14] - Quote
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
3954
|
Posted - 2014.10.03 17:17:00 -
[15] - Quote
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 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |