What tools can be used to create an engineering calculation program?

Question

Automation

Hello!
Due to the complexity and volume of engineering calculations by the nature of professional activity, the idea arose of writing a sufficient number of algorithms that would reduce the calculation time, turning the engineer into a software user who skillfully enters data at the necessary stages of calculation.
Initially, Excel was used, only for the sake of formulas.
Then macros for Excel were written, which significantly accelerated the process of selecting initial data according to certain criteria.
And only after that the idea was born of itself to automate absolutely the entire calculation process with all sorts of conditions and taking into account the "pitfalls" inherent in our specialization.
Actually, it is required to be able to create/edit a conditional "calculation project", which will contain a number of nested files/documents. Attached files will contain initial data (which will need to be entered), various calculations; moreover, they should be created at the will of the user (for example, if necessary, make an alternative calculation). It is also planned that there will be a common database for all created / existing "calculation projects" with the characteristics or properties of standard objects. And as a result, reporting forms should be printed (however, I would like to be able to print at any stage of the calculation)
And now, in fact, the essence of the question: what kind of software can be considered to create such a program so that it satisfies the listed requirements? I am not familiar with either Access or Infopath, and therefore I am not sure that these are the right programs. At the moment, there are only basic programming skills, so there is a desire to use as many ready-made solutions as possible without writing a large amount of code. Please tell me what software you can rely on and what to pay attention to?
Thanks in advance

Answer 1

If I understood correctly, you need a computer algebra system .
The most famous are: MATLAB , Mathcad , Mathematica but there are others .

Answer 2

Have you dug deeper than macros? VBA is the same. Allows you to make a full-fledged softina according to your taste from Excel. The speed of work is not the highest, but as I understand it, this is not the bottleneck.
I do not advise climbing into Access, it is crooked. If there is not enough Excel at all and you are already familiar with VBA, then try to do something in a full-fledged Visual Studio. There are endless possibilities for this.
Introduction to relational databases IMHO should start with SQLite, but then go from needs.

Answer 3

You can write a frontend in C#, all the "bad" mathematical calculations in lower-level c++ into a library that you can connect to the C# frontend and make it cross-platform.
You can do the same in pearl/python/java, you will also get a cross-platform solution.