Good afternoon,
I'm a new QS and new to these forums and in order to price jobs easier as I obtain more costings I am trying to compile an ongoing costsheet.
I've attached an example as a reference point; a table in Master Cost Sheet which has been allocated a code, e.g,
Row 3 - Code = A0001 Desc = Facing Brick Qty = 10 Rate = 1.8
In budget test, I would like it to cross reference against the master cost sheet and choose the rate which is associated to the closest quantity equal to or lower than.
E.g, a quantity of 71 would be closest to Qty 50 thus show a rate of £1.6
Help/advise would be really appreciated.
Bookmarks