What are possible alternatives to spreadsheets for creating complex calculators - price lists?

Question

Software and Internet Services

I work for a company that has a boundless love for Excel and only uses it for price lists used by a variety of managers to calculate orders. The problem is that the product is very complex, made to order, with a bunch of possible variations (models, sizes, materials, decorations, etc.) with the ensuing difficulties in calculations, where there are a bunch of IF (), VLOOKUP () and other relationships, not to mention simple mathematics. Excel takes all this out, slows down, but takes it out, but why? Features of working in Excel impose many restrictions and conventions, even the slightest upgrade of the price list or some necessary changes take a lot of time and easily bring errors that may not come up immediately.

Adequate people will say that for such cases it would be necessary to cut your own software and I agree, but an effective guide is against hiring programmers, spending money and time on "it is not clear what with an unknown result", when "you can put it in Excel in a week and it will work and carry money."

So, the question is, are there any alternatives to tables for creating this kind of calculators? There are several requirements: only an offline application (many managers do not have constant access to the Internet on their computer); the ability to change the interface, select buttons, selectors, display pictures, data entry cells, i.e. everything on the visible part of the calculator that managers will work with; the configs of the calculations themselves and the just mentioned interface should be understandable for writing to people who are far from full-fledged programming, but capable of compiling complex formulas in the same Excel; the ability to work with databases (for good, there is a lot of data that can be sorted, for example, prices by article); the ability to display certain data for export (in the same tabular version, xml, etc.).

Answer 1

with such inputs, no. Your office is working optimally.
The only option for you is CRM + website integration.
Then all this garbage will be in the database, and the site will have a configurator that pulls up prices from your well, let's say 1C