Years ago when I worked for an engineering consulting company we had to work with a similarly complex, opaque Excel spreadsheet from General Electric modeling the operation of a nuclear power plant in exacting detail.

Same deal there -- the original author was a genius and was the only person who knew how it was set up or how it worked.