Hello!

I am building a sheet to manage production of various items, but am having some trouble with the material efficiency formula.

I have been using this formula on Google Sheets:

=MAX(1,CEILING(ROUND(1*[Base Material Requirement]*[Material Efficiency],2)))

Which works for some but not all items.

For example, when building a Fortizar with ME4 in a citadel with an additional 5.04% ME (T2 rig) and the structure’s base 1% ME, which gives me a total ME of 0.902016, it reads as requiring 37 Structure Market Network (this is correct) but asks for 5 Structure Advertisement Nexus (this is not correct as it requires 4).

Oddly, in-game at this ME it requires 4 of all components that would normally require 5, but all components that require 10 are not reduced. This is reflected properly at https://eve-industry.org/ (seen here: https://i.imgur.com/ZhlWSWt.png) but the formula it provides does not.

What am I missing?