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?