Hi. I need someone who can enter some values into a schedule of door hardware.
There is a number of sets and for each set there is unique products.
There are 136 hardware sets. In tab 2 is the unit rates for each product.
The BOQ of products needs populating with prices. For each hardware set i require a total value per set.
Please note the quantities of each product in a set. For example 3no Hinges. So value multiple by 3.
The value of each set needs to be linked to the summary at the start of the spread sheet which indicates how many doors there are for each hardware set.
It is more clear when you take a look at the spreadsheet!
Any questions please let me know.