I wish someone built a tool to extract any model from Excel and help annotation and conversion to code with clean separation of input, logic, output. The amount of creepy legacy Excel is killing my organization.
It takes some getting used to, but you can pretty easily create a named range for an individual cell by modifying the value immediately left of the formula bar. You can also setup a table to hold data (insert -> table).
Tables can be renamed and allow formulas like =sum(tbl_salaries[salary]).
With named ranges, your formula can look like =purchase_price*sales_tax
Power Apps are pushing into AI direction. And it does use AI to parse excel file. Moreover Power Apps on itself has PowerFx engine that uses Excel formulas for app + more.
Not to mention the courage to recommend an app to replace the workbook.