Science & Industry

Greetings,

I'm having a bit of a difficulty getting my formula right for my spreadsheet

Using Adaptive Nano Plating I and II as an example

My understanding is when you're calculating material requirements for either positive ME or negative ME, you use the base material as found in the invTypeMaterial dump.

If we look at Tritanium

ANP I: 806
ANP II: 1116

I've checked both numbers against several ME calculator, base amount for ANP I is correct, but incorrect for ANP II as it is supposed to be 310

Material = ROUND(BaseMaterial*BaseWastage*(1-ME)) + BaseMaterial

Using the 310 base material in my negative ME formula, it comes out as correct when checked against other ME calculators
Using the 1116 base material is coming out as incorrect when checked against other ME calculator.

Is there a step that I'm missing?

basewaste = round(material*basewastefactor*(1/ME+1))
basewaste = round(1116*0.1*(1/0+1))
basewaste = 112

basematerial = round(material_on_ME_0_BPO / (1 + basewaste))
basematerial = round((1116+112) / (1 + 112))
basematerial = 11

totalmaterial = round(basematerial * basewastefactor * (1-ME))
totalmaterial = round(11 * 0.10 * 5)
totalmaterial = 6?

The database dump was pulled from https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/ which is the most recent dump

Ok I guess nobody's checking my math.

If the base tritanium for Adaptive Nano Plating II is 1116, with the formula as laid out in EVEDev, I've come up with a number that is nowhere near what other online calculators says which is 465. So what am I doing wrong??