Steve by:
Maximum Engine Power Modifier x1
Maximum Engine Power Modifier x1.25
Maximum Engine Power Modifier x1.5
Maximum Engine Power Modifier x1.75
Maximum Engine Power Modifier x2
Maximum Engine Power Modifier x2.5
Maximum Engine Power Modifier x3
do you mean:
Maximum Engine Power Modifier +100%/fuel modifier x4
Maximum Engine Power Modifier +125%/fuel modifier x5.66
Maximum Engine Power Modifier +150%/fuel modifier x8
Maximum Engine Power Modifier +175%/fuel modifier x11.31
Maximum Engine Power Modifier +200%/fuel modifier x16
Maximum Engine Power Modifier +250%/fuel modifier x32
Maximum Engine Power Modifier +300%/fuel modifier x64
It appears in the Create Research Project dropdown as:
Maximum Engine Power Modifier +0% Fuel Consumption per EPH +0%
Maximum Engine Power Modifier +25% Fuel Consumption per EPH +41%
Maximum Engine Power Modifier +50% Fuel Consumption per EPH +100%
Maximum Engine Power Modifier +75% Fuel Consumption per EPH +183%
Maximum Engine Power Modifier +100% Fuel Consumption per EPH +300%
Maximum Engine Power Modifier +150% Fuel Consumption per EPH +700%
Maximum Engine Power Modifier +200% Fuel Consumption per EPH +1500%
Also, Missile engines can use up to double the current tech in terms of power boost, so 1.75 tech allows 3.50 boost for missile engines, which would be the following:
Maximum Engine Power Modifier +250% Fuel Consumption per EPH +3100%
I do run into issues trying to reverse engineer your Crusade missiles though. From what I can determine it appears that the int() function has been dropped from the missile engine modifier calculation and the /4 has been dropped from the Fuel Efficiency Modifier.
I’m still not matching your missile ranges, but I suspect that has to do with the difference between VB6’s calculations and Excel’s.
What are the missile engine designs for both the Gladius ASM and the Dagger AMM. Plus what engine tech, fuel consumption tech, and Max Engine Power Modifier tech were being used. That will tell me a lot about what I’m doing from with my modeling.
Engine tech is Ion. Max Engine Power Modifier was 1.75, which is 3.50 for missiles. I think fuel consumption is 0.6, although I'm not sure if I have researched that since the design so it might have been 0.7.
Gladius has 1.8 MSP warhead, 0.2 Fuel, 0.105 reactor, 0.395 thermal sensor, 2.5 engine. Engine has 5.25 Engine Power and Fuel Use Per Hour = 161.83 Litres
Dagger has 0.2 MSP warhead, 0.01 Fuel, 0.09 agility, 0.7 engine. Engine has 1.47 Engine Power and Fuel Use Per Hour = 108.1 Litres
Don't forget to account for fuel consumption changes based on missile engine size: +282% for Dagger and +60% for Gladius.
Steve