Science & Industry

The "Material amount" is the BASE - the amount you would need under PERFECT ME - NOT the amount you would need under 0 ME (which has the base waste of 10% attached).

So, for a Devoter, your BASE material amount for ARUs is 35 - NOT 39.

So the waste amount, then, is 35 * .1 * 2 = 7

Base of 35 + 7 waste = 42.

I have to say that is a really good job you've done; however, what I often see missing is reactions impact. I am putting a spreadsheet together that takes into account simple and complex reactions in the form of cost. So I have tab that takes my inputs, breaks them down to how much I need to react to make each component and factor that in as a function of profit.

Er... Steve already did. :)

There are other resources as well, of course. I'm not really sure what's up to date anymore.

You can also just input a ludicrously high ME number into a blueprint calculator, or just divide the ME-0 requirement by 1 + baseWaste (e.g., for your devoter, 39/1.1 = 35.45, iirc the rounding on these values is standard).

Althogh that website is phenominal, I cannot make sense of the mysql data. I don't have any knowledge of mysql. I was hoping the numbers were static or easily calculated to enter into a spreadsheet. I see there are fomulas available, but I dont know what "perfect" means.

I'm not looking for a quick and easy way to get something for nothing, but I am trying to stay within my skill set.

If perhaps someone could help me within the lense of excel. I have no sql experience. I do have a need to put together a spreadsheet, but don't have the time to dive deep into sql (working on my CCIE).

Thanks in advance.

Out standing mate. Anyway to convince you to include a simple/complex reactions itemized comparison on that already awesome website?

I often find the need to know what the cost differintials are between buy, buy for complex to build, and buy for simple reactions build up to cmplx.

again, thanks for your help.

Steve, i am not finding the components in the ivntypematerials sheet. for instance, plasma thruster in invTypes is TYPEID = 11530, GROUPID = 334. That combination is not in the invTypeMaterials.

if you look at lines 7588, 7589 and 7590, you'll find the materials used for making a plasma thruster.

Specifically 16673,16680 and 16683

To make things easier for your vlookups, I'd suggest creating a sheet that's just the typeid, typename, typeid, taken from invTypes. That way, you can use the same sheet for lookups going from name to typeid, and vice versa.

The material being made is in the first column, the material used to make it is in the second, and the quantity is in the third. With multiple entries per thing being made (One per material)

I've always used a database for this, because pivot tables annoy me.



https://forums.eveonline.com/default.aspx?g=posts&m=2784214#post2784214 /might/ be of interest. If you're willing to have a poke at a mysql database. The SQL needed for getting manufacturing data is in my previous post. If you're using Excel, you can hook it up to mysql pretty easily, as the server install now comes with a connector (as long as it's not excel 2013. Then you'd need to just use ODBC)

Good luck with the CCIE btw. I've heard there's a lot to it.