I once was contracted to speed an excel-based material requirements planning (MRP) tool that took 3-hours to run. It was an extreme example of “spaghetti code.” I quickly decided I should not even try to fix the code. Instead, I salvaged some of the logic and did a re-write in far less time than fixing it. If I recall correctly, I got the calculation time down to 10 minutes
Glad that you can do this. For me it would be like translating Klingon.