I would like to propose the following solution to achieve this:
Add formulas to calculate the total cost of each product and color combination based on the area to lay, the rate per square meter, and the quantity. You can use the SUMPRODUCT function to achieve this.
Add drop-down lists to each line to allow the user to select the product and color combination easily.
Add formulas to calculate the total cost of each category, including wear layer pallets, cushion pallets, binder pallets, freight, removal of old softfall, removal of sand and lawn, excavation, DINGO, crusher dust, roadbase, base in relevel, shape and compact, skip bin, fencing, security, flights, accommodation, allowance/meal, truck/ute hire, travel time, travel vehicle, and buffer/admin/extra labor/induction. You can use basic arithmetic operations like addition, multiplication, and division to achieve this.
Create a separate sheet to display the profit estimate based on the cost and the possible profit. You can use formulas to calculate the profit estimate based on the cost and the profit percentage.
Add further SMART advancements to make the spreadsheet more user-friendly, such as error messages, data validation, conditional formatting, and macros.
Overall, the proposed solution will automate the process of calculating small project costs and quantities, improve accuracy and efficiency, and enhance the user experience.
I can create the spreadsheet for you.
Regards,