I’d like to be somewhat vague because my job is somewhat niche. For my job I made custom products that are made up of subcomponents that cost me either by the foot, by the pair, or individually. So a particular product may include 5 feet of X, Y and Z, a pair of V and 1 of T and U. Then I add a bit for profit.
Right now I have a somewhat simple spreadsheet that has all my components and their costs listed which are then referenced on other sheets. The problem is adding or removing components is a real pain in the ass because I’d have to edit each and every sheet.
I’d like a better system where I can create a new product then from a drop down or something pick all the relevant components and enter how many of that component I need. Then create a quote that I can email to a client that lists the final cost of a bunch of products.
I’d prefer this to be a, open source web app but it can be a desktop application.
That sounds like the kind of stuff we make at $dayjob (that’s for the building trade, where they often have complex spreadsheets and going to an app that calculates everything down to the number of screws for them is a huge benefit).
You could probably still do it with a spreadsheet, just have parts list add/remove fan out into the cutting list and update automatically. I imagine it’d get quite ugly, but doable. If you want to do optimisation (buy 1 5 foot length and cut rather than 2 2 foot lengths, because it’s cheaper, for example) it gets even uglier and at that point a bespoke app becomes more sensible.
I’ve considered making a bespoke app myself either using C# or with Python and QT but I don’t have much experience with the later even though it would be more cross platform friendly.