Spreadsheet: 525527d1498760510-output-a-number-based-on-depth-and-date-when-there-are-overlapping-dates-and-depths-bhaslideexample-bw2
Sheet: Slide Sheet

 |  | start date | end date |  |  |  |  |  |  |  | curent output(formula) |  | Desired output (manually entered)
2017-05-11 03:15:11 | 0 |  |  | depth in | depth out | BHA #
2017-05-11 03:46:11 | 114.02 |  |  | 109 | 723 | 1
2017-05-11 04:01:05 | 123.37 |  |  | 723 | 2390 | 2
2017-05-11 04:15:23 | 132.69 |  |  | 878 | 1668 | 3
2017-05-11 04:25:46 | 141.86 |  |  | 1668 | 2111 | 4
2017-05-11 04:34:57 | 151.32 |  |  | 816 | 2161 | 5
2017-05-11 04:43:02 | 160.92 |  |  | 778 | 2455 | 6
2017-05-11 04:54:46 | 170.27
2017-05-11 05:03:07 | 179.59
2017-05-11 05:13:59 | 188.83
2017-05-11 05:25:59 | 198.13
2017-05-11 05:36:06 | 207.81
2017-05-11 05:42:22 | 217.15
2017-05-11 05:51:11 | 226.54
2017-05-11 05:56:59 | 236
2017-05-11 06:09:00 | 245.39
2017-05-11 06:18:34 | 254.81
2017-05-11 06:26:07 | 264.28
2017-05-11 06:35:48 | 273.71
2017-05-11 08:46:32 | 283.06
2017-05-11 08:46:34 | 292.39
2017-05-11 08:46:36 | 301.64
2017-05-11 08:46:38 | 311.07
2017-05-11 08:46:44 | 320.4
2017-05-11 08:46:50 | 329.75
2017-05-11 08:46:52 | 339.2
2017-05-11 08:46:54 | 348.67
2017-05-11 08:46:58 | 357.93
2017-05-11 09:45:39 | 367.1
2017-05-11 09:45:42 | 376.42
2017-05-11 09:45:46 | 386
2017-05-11 09:45:49 | 395.18
2017-05-11 09:45:52 | 404.52
2017-05-11 10:41:28 | 413.77
2017-05-11 10:41:38 | 423.19
2017-05-11 10:41:46 | 432.42
2017-05-11 10:41:53 | 441.77
2017-05-11 11:48:08 | 451.11
2017-05-11 11:48:18 | 460.42
2017-05-11 11:48:30 | 469.79
2017-05-11 11:48:41 | 479.12
2017-05-11 13:31:48 | 488.66
2017-05-11 13:32:05 | 497.99
2017-05-11 14:32:56 | 507.3099999999999
2017-05-11 14:32:59 | 516.63
2017-05-11 14:33:01 | 525.95
2017-05-11 15:15:02 | 535.32
2017-05-11 20:20:38 | 544.46
2017-05-11 20:33:52 | 553.78
2017-05-11 20:50:21 | 563.18
2017-05-11 21:06:03 | 572.17
2017-05-11 21:17:37 | 581.52
2017-05-11 21:31:12 | 590.83
2017-05-11 21:45:53 | 603.72
2017-05-11 22:06:42 | 616.62
2017-05-11 22:22:03 | 629.48
2017-05-11 22:37:31 | 642.36
2017-05-11 22:53:25 | 655.23
2017-05-11 23:11:37 | 668.09
2017-05-11 23:29:30 | 680.98
2017-05-11 23:47:34 | 693.93
2017-05-12 00:11:06 | 706
2017-05-12 00:24:12 | 729
2017-05-13 04:44:55 | 738.55
2017-05-13 05:13:12 | 751.44
2017-05-13 05:32:52 | 764.35
2017-05-13 05:49:59 | 777.24
2017-05-13 06:03:49 | 790.06
2017-05-13 09:53:43 | 808.14
2017-05-13 09:53:58 | 821.07
2017-05-13 09:54:11 | 833.96
2017-05-13 09:54:25 | 846.87
2017-05-13 09:59:36 | 859.79
2017-05-13 10:37:26 | 872.65
2017-05-13 10:37:47 | 885.52
2017-05-13 10:47:54 | 898.4
2017-05-13 11:14:10 | 911.27
2017-05-13 11:14:16 | 924.14
2017-05-13 11:32:17 | 937.03
2017-05-13 12:20:08 | 946.3
2017-05-13 12:20:15 | 955.67
2017-05-13 12:20:27 | 965.01
2017-05-13 12:26:08 | 974.21
2017-05-13 12:38:41 | 983.58
2017-05-13 12:53:46 | 992.92
2017-05-13 13:04:53 | 1002.22
2017-05-13 13:20:10 | 1011.53
2017-05-13 13:28:43 | 1020.85
2017-05-13 14:20:22 | 1030.2
2017-05-13 14:20:35 | 1039.52
2017-05-13 14:20:41 | 1048.69
2017-05-13 14:30:06 | 1058.15
2017-05-13 14:40:26 | 1067.75
2017-05-13 14:55:11 | 1077.1
2017-05-13 15:09:06 | 1086.42
2017-05-13 15:25:18 | 1095.66
2017-05-13 15:40:55 | 1104.96
2017-05-13 15:59:41 | 1114.64
2017-05-13 16:14:29 | 1123.98
2017-05-13 16:30:11 | 1133.37
2017-05-13 17:22:05 | 1142.83
2017-05-13 17:22:19 | 1152.22
2017-05-13 17:22:29 | 1161.64
2017-05-13 17:33:46 | 1171.11
2017-05-13 17:49:00 | 1180.54
2017-05-13 18:05:03 | 1189.89
2017-05-13 18:26:17 | 1199.22
2017-05-13 18:36:04 | 1208.47
2017-05-13 18:49:38 | 1217.9
2017-05-13 18:59:41 | 1227.23
2017-05-13 19:14:09 | 1236.58
2017-05-13 19:24:21 | 1246.03
2017-05-13 19:33:38 | 1255.5
2017-05-13 19:43:33 | 1264.76
2017-05-13 19:59:33 | 1273.93
2017-05-13 20:09:37 | 1283.25
2017-05-13 20:20:11 | 1292.83
2017-05-13 20:31:38 | 1302.01
2017-05-13 20:47:44 | 1311.35
2017-05-13 20:57:23 | 1320.6
2017-05-13 21:07:29 | 1330.02
2017-05-13 21:17:26 | 1339.25
2017-05-13 21:28:31 | 1348.6
2017-05-13 21:39:59 | 1357.94
2017-05-13 21:51:07 | 1367.25
2017-05-13 22:07:28 | 1376.62
2017-05-13 22:20:14 | 1385.95
2017-05-13 22:29:59 | 1395.49
2017-05-13 22:40:27 | 1404.82
2017-05-13 22:51:00 | 1414.14
2017-05-13 23:04:26 | 1423.46
2017-05-13 23:17:39 | 1432.78
2017-05-13 23:32:24 | 1442.15
2017-05-13 23:45:25 | 1451.29
2017-05-13 23:55:20 | 1460.61
2017-05-14 00:07:25 | 1470.01
2017-05-14 00:22:46 | 1479
2017-05-14 00:40:14 | 1488.35
2017-05-14 00:52:05 | 1497.66
2017-05-14 01:19:35 | 1510.57
2017-05-14 01:32:23 | 1523.45
2017-05-14 01:47:30 | 1536.35
2017-05-14 02:16:00 | 1549.17
2017-05-14 02:22:03 | 1562.04
2017-05-14 02:36:10 | 1574.91
2017-05-14 03:54:59 | 1587
2017-05-14 09:23:35 | 1599.75
2017-05-14 09:30:24 | 1609.09
2017-05-14 09:58:32 | 1618.29
2017-05-14 10:03:14 | 1627.66
2017-05-14 10:58:07 | 1637
2017-05-14 10:58:24 | 1646.3
2017-05-14 10:58:32 | 1655.61
2017-05-14 11:06:45 | 1664.93
2017-05-14 11:26:30 | 1674.28
2017-05-14 11:30:44 | 1683.6
2017-05-14 11:41:02 | 1692.77
2017-05-14 12:02:29 | 1702.23
2017-05-14 12:18:04 | 1711.83
2017-05-14 12:34:41 | 1721.18
2017-05-14 12:50:42 | 1730.5
2017-05-14 12:59:34 | 1739.74
2017-05-14 13:09:13 | 1749.04
2017-05-14 13:24:03 | 1758.72
2017-05-14 14:48:03 | 1768.06
2017-05-14 14:48:11 | 1777.45
2017-05-14 14:48:50 | 1786.91
2017-05-14 14:48:58 | 1796.3
2017-05-14 14:49:10 | 1805.72
2017-05-14 14:49:25 | 1815.19
2017-05-14 15:01:27 | 1824.62
2017-05-14 15:23:28 | 1833.97
2017-05-14 16:07:27 | 1843.3
2017-05-14 16:07:34 | 1852.55
2017-05-14 16:07:41 | 1861.98
2017-05-14 17:19:46 | 1871.31
2017-05-14 17:19:53 | 1880.66
2017-05-14 17:20:12 | 1890.11
2017-05-14 17:20:21 | 1899.58
2017-05-14 17:36:54 | 1908.84
2017-05-14 17:47:44 | 1918.01
2017-05-14 17:58:10 | 1927.33
2017-05-14 18:42:59 | 1936.91
2017-05-14 18:43:06 | 1946.09
2017-05-14 18:47:51 | 1955.43
2017-05-14 18:59:49 | 1964.68
2017-05-14 19:10:33 | 1974.1
2017-05-14 19:23:16 | 1983.33
2017-05-14 19:35:53 | 1992.68
2017-05-14 20:08:34 | 2002.02
2017-05-14 20:10:33 | 2011.33
2017-05-14 20:37:30 | 2020.7
2017-05-14 20:48:46 | 2030.03
2017-05-14 20:59:33 | 2039.57
2017-05-14 21:10:52 | 2048.9
2017-05-14 21:22:03 | 2058.22
2017-05-14 21:46:13 | 2067.54
2017-05-14 21:57:28 | 2076.86
2017-05-14 22:08:11 | 2086.23
2017-05-14 22:20:35 | 2095.37
2017-05-14 22:51:11 | 2104.69
2017-05-14 23:02:26 | 2114.09
2017-05-14 23:25:51 | 2123.08
2017-05-14 23:40:33 | 2132.43
2017-05-14 23:56:00 | 2141.74
2017-05-15 00:11:11 | 2154.62
2017-05-15 00:25:57 | 2167.5
2017-05-15 00:53:07 | 2180.36
2017-05-15 01:17:56 | 2193.25
2017-05-15 01:37:35 | 2206.11
2017-05-15 01:57:17 | 2218.98
2017-05-15 02:15:28 | 2231.87
2017-05-15 02:39:54 | 2244.75
2017-05-15 03:21:38 | 2257.62
2017-05-15 03:36:11 | 2270.49
2017-05-15 04:16:56 | 2283.37
2017-05-15 04:33:31 | 2296.6
2017-05-15 04:47:43 | 2309.48
2017-05-15 05:10:36 | 2322.29
2017-05-15 05:34:56 | 2335.15
2017-05-15 05:51:25 | 2348.42
2017-05-15 06:10:14 | 2361.31
2017-05-15 12:00:00 | 2373