Posted by: amram
« on: May 14, 2020, 10:10:23 AM »Finally had some time to sit down in Aurora and play a game, so I was actively using the sheet again.
Found I had horribly broken the ship engine calculation before when I added the helper cell, so it typically suggested only that you max out the engine multiplier since it was ignoring fuel due to looking at an empty cell. Hadn't realised until I used the sheet in a game again and it gave me nonsense suggestions.
V13 changes
Main post updated.
Found I had horribly broken the ship engine calculation before when I added the helper cell, so it typically suggested only that you max out the engine multiplier since it was ignoring fuel due to looking at an empty cell. Hadn't realised until I used the sheet in a game again and it gave me nonsense suggestions.
V13 changes
- Fixed a minor formatting issue in the PD Turret Calculator when the estimated PD active Search sensor would exceed HS 50: a value of 75.76 would end up as 575 as a consequence. Fixed that.
- Forgot to make the PD Turret Calculator section for determining an appropriate active sensor also use 15 tons as MCR when set for C#, fixed.
- Stopped Missile Velocity from showing when there is negative fuel, just as range and endurance do not show in such case.
- Found and fixed a flaw in Missile Data where the ENG/AGI calc's could end up referencing the text MR instead of a number, and become unhappy about that.
- Stopped the boost increase/decrease indicators from seeing "" as a value that could be greater than any actual number.
- Fixed a math error in the MSP required estimate for PD Turret Calculator, because I am a derp.
- Added more notes to PD Turret Calculator for the results section.
- Changed formatting to flag a failure to obtain the requested bonus, rather than max bonus.
- Pushed some values out to helper cells in missile data, to facilitate better matching aurora's rounding of values, and so better match C#'s missile results.
- Missile engines in c# now change step sizes as happens in C#, with 0.01 until 3.0, 0.1 from there until 10.0, 0.5 from there until 50
- Had managed to break the engine calcs when I last altered them to use the new helper columns, a cell reference didn't adjust correctly, they were ignoring fuel quantity, fixed.
Main post updated.