I have data like below:
IDENTIFIER DATE Job TOP BOTTOM
X 1983-10-27 Perf 655.2 658.2
X 1983-10-31 Perf 624.5 625
X 1983-10-31 Cement 654 662
X 1983-11-30 Perf 625 626
X 1984-04-13 Cement 624.5 626
X 1984-04-19 Perf 625.5 626
X 1984-04-26 Perf 625 625.5
X 1984-05-15 Cement 625 626
X 1984-05-17 Perf 655.2 658.2
X 1984-05-29 Perf 644 646
Y 1988-12-28 Perf 621.5 622
Y 1994-03-25 Perf 621 625
Y 2001-02-10 Cement 618 618
Visually this would be represented as (for identifier X):
Capture.PNG
Here green refers to Perf jobs and red refers to Cement jobs. Perfs would open the interval and cementing over a previously perfd interval would close it.
I was hoping to be able to get a new list with current OPEN perfs for each of the identifiers. This is ensuring only unique values for perfs for a given well are shown taking into account any previous cement jobs that have closed the interval.
New Table would have:
IDENTIFIER DATE Job TOP BOTTOM
X 1984-05-17 Perf 655.2 658.2
X 1984-05-29 Perf 644 646
Y 1994-03-25 Perf 621 625
Thanks in advance!
(Edited post with excel attachment)
Bookmarks