I have a number of test results from road works that I need to extract the result from, but I can't puzzle out how to do it.

The test result (a compaction percentage) covers a stretch of road from a point (chainage) to a point e.g. from chainage 0+500 to chainage 0+700 (meaning from 500m to 700m). The test result covers that entire stretch.

I need to transfer the test result into a summary sheet which shows the entire road split up in 20 meter sections.

In the example above the test result would cover the ten 20 meter sections between 0+500 and 0+700.

How do I do that?

In the attached I have entered the data manually and highlighted the data used with red.



/Møller

Attached Files

ARZ, TMH1 A Series Test Summary.xlsx (36.6 KB, 22 views)