Also please request if you want a certain value added to the table and I will do so.
The sheet explained:
The sheet only includes tier 3 modules. In formulas they are called P, S and E. The sheet does not take into account beacons requiring a lot of energy - this is because beacons need a flat value, no matter what and all values in the sheet are relative.
Modules: The amount of the stated module installed OR the amount of beacons affecting the machine (with the beacon having two modules of the type). If the beacon has only one module of the type the value is 0,5.
Productivity: (1 + P * 0,1)^steps
Energy Consumption: 1 + (P *0,8 + S * 0,7 - E * 0,5)
Crafting Speed: 1 + (-P * 0,15 + S * 0,5)
Energy Efficiency: Crafting Speed * Productivity / Energy Consumption
Crafting Efficiency: Productivity * Crafting Speed
Explanation of the chart: On the top we are using 4 productivity modules with increasing numbers of beacons. On the bottom we use 4 speed modules, that's why the numbers are 4 higher each.
Note: If we assume a machine with 2 module slots, this does not change! The breakpoint is still very close to 12.