I am working in making door and window company. Is it possible to make an app using powerapps, based on excel sheets
input
1. door/window series
2. name of door/window
3. size of door/window
4. configuration like color of frame, infilled material, door/window hardware.
calculation
using those input to calculate the cost of each material in DB,
1. aluminium frame for each component (kg)->$
2. Glass/solid panel as infilled material (W*H*cost in sqm) -> $
3. Hardware -> $
4. Labour cost -> $
Total will be cost per 1 set of door/window * quantity of door/window -> Total Cost
Total Cost * Profit -> Price
Output for client -> Price of the whole project (could be multiple item)-> send quotation to client email.
Output for backoffice -> Price of the whole project (could be multiple item) and Bill of Material for further action
Thanks guys