Do you know of any tool that helps to make Excel better? Tools like this https://www.formulaboost.com/parse?f=%3DIF(A1%3C10%2CSUM(B2%3AB10)%2C100-MAX(10%2CB11))

This seems like a great way to harvest ideas for a spreadsheet-like product 😄

kind of, I was thinking that maybe starting where people are at and apply "future of coding ideas" from there may be more productive. At the same time I get the feeling that there should be many obvious ones already solved, but I can't find many. The trigger was trying to help someone with a complex spreadsheet with zero knowledge of excel myself, I wanted some sort of visualization/debugger for it to be able to see the structure underneath the sea of cells

I know people using excel commercially for operations research (think deciding where to build a new power station) and there are a few different pieces of software to support that use case (there is an inbuilt solver too). E.g. https://opensolver.org/

also somewhat related, PowerFX is the extension of the excel formula language to a more general use across power platform, and is open source: https://github.com/microsoft/Power-Fx