Mr Engineer
New Member
- Joined
- Jan 7, 2015
- Messages
- 1
Hi there
Context of problem: I am trying to quantify lengths of fencing along a road into excel. I type the extents of the fencing into Table 1.
Note that Start & End represents the location on the road. So for example, a fencing which starts at location "90" and runs to location "95" is 5 meters long.
I have a data table, which represents the area in 20 meter blocks.
Problem: I am trying to auto populate the total lengths of fencing into Column G. In the picture, I have manually entered these in, but I need a formula which can automate this.
Note I need to account for the overlap in the fencing between locations "80" to "100".
Can anybody give me a hand?
Thanks
Mr. Engineer
Context of problem: I am trying to quantify lengths of fencing along a road into excel. I type the extents of the fencing into Table 1.
Note that Start & End represents the location on the road. So for example, a fencing which starts at location "90" and runs to location "95" is 5 meters long.
I have a data table, which represents the area in 20 meter blocks.
Problem: I am trying to auto populate the total lengths of fencing into Column G. In the picture, I have manually entered these in, but I need a formula which can automate this.
Note I need to account for the overlap in the fencing between locations "80" to "100".
Can anybody give me a hand?
Thanks
Mr. Engineer