I try to write a sheet for calculating the manufacturing cost for a given blueprint.
Example 1:
BP ME: 8%
Structure: 1%
Rigs: 4,2%
8 Units: 8 * 0.92 * 0.99 * 0.958 ~ 7 → is correct (shown by job cost within manufacturing window)
Example 2:
BP ME: 9%
Structure: 1%
Rigs: 4,2%
7 Units: 7 * 0.91 * 0.99 * 0.958 ~ 6 → not correct (still 7 is shown within the manufacturing window)
I also tried it with rounding errors (ceil >0.37 and floor <0.36666). This works for both examples but not exactly for larger numbers…
What I tried: round( round( round(7 * 0.91) * 0.99) * 0.958)
So, do you know the formular CCP uses? Would be awesome!
Thanks in advance!
Edit: The rounding boundaries do not work.
Example 3:
BP ME: 8%
Structure: 1%
Rigs: 4,2%
16 Units: round ( … ) ~ 15 → not correct (it shows 14)