Convert complicated excel calculator to be used in Odoo 15 to generate quotes
Budget: $30 – $250 USD
We have a relatively complicated xls that calculates the price of commercial cooler. We want to be able to convert that to be used with our odoo/frePPLe installation to help estimators save time and to better keep track of inventory/manufacturing/demand.
An example of the calculation:
Customer requests a cooler (box) that is 10 ft wide, 20 ft long, and 8 ft tall. Entry door is on the short wall in the center. Calculator determines how many 4ft x 8ft (standard panel) wall pieces are need to make the box. Corners, half sheets, roof panels, connectors, gaskets, and other components are calculated as well. Then cost and 5 tiers of pricing are calculated and estimator can add that price to a different sheet to be made into a PDF.
I don't know if or even how this would be accomplished. Sample document can be provided if a solution is possible.
An example of the calculation:
Customer requests a cooler (box) that is 10 ft wide, 20 ft long, and 8 ft tall. Entry door is on the short wall in the center. Calculator determines how many 4ft x 8ft (standard panel) wall pieces are need to make the box. Corners, half sheets, roof panels, connectors, gaskets, and other components are calculated as well. Then cost and 5 tiers of pricing are calculated and estimator can add that price to a different sheet to be made into a PDF.
I don't know if or even how this would be accomplished. Sample document can be provided if a solution is possible.