Spent yesterday afternoon trying to extract the logic from a VBA macro written by civil engineers so that we can encode the same logic in the applications we're writing.

Sweet Jesus.

500 lines of meaningless variable names and loops reading values from various spreadsheets into a 3 dimensional array(!).

On top of that, now that I kind of understand what it's doing, I don't think it's ever worked properly.