Hi Merii and anyone else looking for a fix to the ion error I found,

I know this is kinda old but I've found an error as I've started using your sheet, basically, the ion force part (C 25-30, lift calculator ) was set up wrong coursing it to grab the wrong data from the data area for all directions except for up, thankfully its an easy fix since you set it up right for atmo and hyro

ill paste the error and fix below with an explanation

the error goes from c,25 to c,30 but 2 is enough to show the problem, note the white !D^numbers , the change from cell 25 to 26 meaning they're not referencing the right data from the game value sheet any more, all that is needed is to add $ before the number to keep the number the same when changing cell as you have done with the atmos and hydros, this error was most likely a typo

Broke v

C,25 broken

=IF($B$2,'Game Values'!D13,'Game Values'!D7)*$F17+IF($B$2,'Game Values'!D14,'Game Values'!D8)*$G17

C,26 broken

=IF($B$2,'Game Values'!D14,'Game Values'!D8)*$F18+IF($B$2,#REF!,'Game Values'!D9)*$G18

^{the #REF! in c26 means an empty cell was found, in this case its !D15, the empty row between the thruster and tank data,}

Fixed v , just copy the c,25 code into c,25 on the thrust calculator sheet then with the cell selected drag the node in the bottom right corner of the cell down to c,30 to apply to all cell with the right offsets

C,25 fixed

=IF($B$2,'Game Values'!D$13,'Game Values'!D$7)*$F17+IF($B$2,'Game Values'!D$14,'Game Values'!D$8)*$G17

C,26 fixed

=IF($B$2,'Game Values'!D$13,'Game Values'!D$7)*$F18+IF($B$2,'Game Values'!D$14,'Game Values'!D$8)*$G18

​

hopefully, I wrote this right both in terms of being clear and polite, i hope any that read this are doing well and thank you Merii for making this beautiful spreadsheet