A great illustration of the usage of data validation fall-down lists combined with dynamic named ranges to produce those lists easily editable.
You can even assess the full total used on the construction project in https://agnescdgq002648.theblogfairy.com/27815479/facts-about-excel-template-revealed