Hacker News new | ask | show | jobs
by jgorn 478 days ago
I have a question about calculator building, if anyone has a suggestion. My industry revolves around quite complicated calculators, with anywhere from 10 to 50 data inputs - and the result are large projection tables and charts.

These still live in excel, but I would love to move then into a web app.

Is there a best practice way to go about this? I've tried basic html forms that pass to python for the number crunching (there are optimisations and Monte Carlos). But it gets so messy as the number of input fields increase. Does a tool exist to simplify this process?

2 comments

unless you want to dumb down the interface so it's more like a wizard, the best you can do is make a framework so the complexity is separate. ie, the business logic is separate from the application logic. without more details it's impossible to say how I'd simplify it but there's gonna be a lot of having to learn your specific use case before suggesting how to simplify it.

unfortunately the complexity has to live somewhere, the only question is how best to manage it.

Something like Dash or Streamlit might be useful to manage an App like this.