An attempt at the definitive aircraft efficiency spreadsheet

AE Aircraft Efficiency Spreadsheet (Fabulous Ver.)
AE Aircraft Efficiency Spreadsheet (Boring Ver.)

Greetings all.

Posting a spread as my first post will probably mark myself as a meta-gamer. But hey, real airlines have experts in the field calculating profitability in a far greater scale than this. I applaud those who role-play as real airlines, but this is necessary for airlines to make an informed choice on their aircraft rather than just out of familiarity with popular aircrafts. We can't have Boeing and Airbus monopolise the market when Comac offers great price and fuel efficiency, just because of protectionism, could we?

It is currently still far from complete and would greatly benefit from any contributions. It is very possible that my formulas are incorrect, do PM me or post here if that is the case. Instructions and descriptions are included in the notes of the sheet.

~~I hope that, with the help of the community, this could truly become the definitive aircraft efficiency reference sheet.~~

With 355 aircraft in the spreadsheet. The spreadsheet is now considered complete. It might still contain input errors and incorrect formulas, but I have taken every effort to reduce that to a minimum. Special thanks to a kind AE user who gave their valuable feedback that contributed to the correction of a core formula.

As of March 10, the spreadsheet is fully protected. If you wish to sort or otherwise edit the spreadsheet, make a copy by going File>Make a copy...

Considerations:

The efficiency does not account for turn time, which can be huge on short hauls.
Supposedly, aircraft have varying speed and fuel flow throughout the flight during ascent and descent. This is not calculated.
Depreciation can affect the cost by varying degrees. Because of this, I have no plans to make a rate of return calculation for purchased planes. I welcome anyone to take up the challenge though.
Costly planes with large passenger capacity can be useful due to limited gates and its leasing cost.

Solvable unsolved Issues: