Spreadsheet: 681683d1591700885-proportion-values-by-dates-sample-mb-v2-strip-allocation-
Sheet: All Data

 |  |  |  | Waste Stripping
 |  |  | Period Starting ---> | 2020-06-01 00:00:00
 |  |  | Day of week
 |  |  | No. days ---> | 1 | 1 | 1 | 1 | 1 | 1 | Check
Grand Total | Grand Total | Grand Total
Start Date | End Date | Total Stripping |  | Ensure leave column M blank for formula to calculate correctly
2020-06-01 00:00:00 | 2020-06-02 23:28:30.053000 | 6811.622574388399
2020-06-02 23:28:30.053000 | 2020-06-04 22:19:51.674000 | 6628.269106194901
2020-06-04 22:19:51.674000 | 2020-06-06 00:00:00 | 3682.935136949893
2020-06-01 01:15:50.746000 | 2020-06-01 17:41:02.394000 | 2985.999166666666
2020-06-01 17:41:02.394000 | 2020-06-02 06:59:29.270000 | 6653.732781574193
2020-06-01 05:04:34.821000 | 2020-06-01 11:27:10.653000 | 3188.31
2020-06-03 01:00:06.762000 | 2020-06-03 02:35:58.481000 | 798.849861111111
2020-06-03 02:35:58.481000 | 2020-06-03 06:03:49.572000 | 1732.095972222222
2020-06-03 06:03:49.572000 | 2020-06-03 06:09:51.022000 | 50.20138888888889
2020-06-03 06:09:51.022000 | 2020-06-03 12:57:32.241000 | 3397.391527777777
2020-06-02 14:05:17.382000 | 2020-06-02 22:28:33.650000 | 4193.926111111111
2020-06-02 22:28:33.650000 | 2020-06-03 00:04:07.502000 | 796.3683333333332
2020-06-03 00:04:07.502000 | 2020-06-03 01:00:06.762000 | 466.5638888888888
2020-06-01 11:27:10.671000 | 2020-06-01 11:30:06.315000 | 0
2020-06-01 11:30:06.315000 | 2020-06-01 11:42:34.582000 | 103.926
2020-06-01 00:00:00 | 2020-06-01 00:13:48.070000 | 83.81896131619509
2020-06-01 00:54:29.853000 | 2020-06-01 17:41:02.394000 | 6113.058353532557
2020-06-01 17:41:02.394000 | 2020-06-02 10:05:41.421000 | 5980.101787077317
2020-06-01 00:13:48.070000 | 2020-06-01 00:54:29.853000 | 247.162346706
2020-06-03 01:00:06.762000 | 2020-06-03 02:35:58.481000 | 582.2009403268128
2020-06-03 02:35:58.481000 | 2020-06-03 06:03:49.572000 | 1262.349726594997
2020-06-03 06:03:49.572000 | 2020-06-03 06:09:51.022000 | 36.58671953221749
2020-06-03 06:09:51.022000 | 2020-06-03 19:04:45.956000 | 4706.313763804023
2020-06-03 19:04:45.956000 | 2020-06-05 00:33:05.987000 | 10739.66544904297
2020-06-02 10:05:41.421000 | 2020-06-02 11:39:53.567000 | 572.1219545086318
2020-06-02 11:39:53.567000 | 2020-06-02 22:28:33.650000 | 3939.571620506866
2020-06-02 22:28:33.650000 | 2020-06-03 00:04:07.502000 | 580.3924054869121
2020-06-03 00:04:07.502000 | 2020-06-03 01:00:06.762000 | 340.0312725295254
2020-06-01 00:00:00 | 2020-06-01 02:07:01.386000 | 631.5388289008829
2020-06-01 02:07:01.386000 | 2020-06-01 02:07:03.162000 | 0.1471365231081081
2020-06-01 02:07:03.162000 | 2020-06-01 02:07:19.768000 | 1.376033014459459
2020-06-01 02:07:19.768000 | 2020-06-01 02:42:53.751000 | 176.8304008743657
2020-06-01 02:42:53.751000 | 2020-06-01 17:41:02.394000 | 4465.430664095824
2020-06-01 17:41:02.394000 | 2020-06-02 08:02:44.728000 | 4284.264291062187
2020-06-03 01:00:06.762000 | 2020-06-03 02:35:58.481000 | 476.6106746776269
2020-06-03 02:35:58.481000 | 2020-06-03 04:35:46.182000 | 595.6019446555957
2020-06-02 08:02:44.728000 | 2020-06-02 11:39:53.567000 | 1079.622251519216
2020-06-02 11:39:53.567000 | 2020-06-02 22:28:33.650000 | 3225.075323940415
2020-06-02 22:28:33.650000 | 2020-06-03 00:04:07.502000 | 475.1301428706202
2020-06-03 00:04:07.502000 | 2020-06-03 01:00:06.762000 | 278.3618558238963
2020-06-03 04:35:46.182000 | 2020-06-03 06:03:49.572000 | 437.8030168804929
2020-06-03 06:03:49.572000 | 2020-06-03 06:09:51.022000 | 29.95120734553066
2020-06-03 06:09:51.022000 | 2020-06-03 19:00:07.647000 | 3335.94720314197
2020-06-03 19:00:07.647000 | 2020-06-03 19:04:45.956000 | 23.06180817575679
2020-06-03 19:04:45.956000 | 2020-06-04 04:04:48.701000 | 2528.982388528309
2020-06-04 04:04:48.701000 | 2020-06-04 12:36:18 | 212.883768216
2020-06-03 15:52:23.327000 | 2020-06-03 17:31:41.871000 | 493.7490139719357
2020-06-04 03:10:22.701000 | 2020-06-04 04:45:24.668000 | 336.2804221922567
2020-06-04 04:45:24.668000 | 2020-06-05 00:33:05.987000 | 5713.730563836778
2020-06-03 03:48:44.109000 | 2020-06-03 03:57:17.049000 | 62.339628219
2020-06-03 03:57:17.049000 | 2020-06-03 05:47:50.487000 | 806.1877697279999
2020-06-03 05:47:50.487000 | 2020-06-03 06:03:49.572000 | 116.5613400501324
2020-06-03 06:03:49.572000 | 2020-06-03 06:09:51.022000 | 43.92843744011163
2020-06-03 06:09:51.022000 | 2020-06-03 06:13:22.415000 | 25.69137924036616
2020-06-03 06:13:22.415000 | 2020-06-03 06:13:43.073000 | 2.51067729
2020-06-03 06:13:43.073000 | 2020-06-03 07:35:37.707000 | 597.294818712
2020-06-03 07:35:37.707000 | 2020-06-03 07:36:00.932000 | 2.822720103
2020-06-03 07:36:00.932000 | 2020-06-03 07:43:46.561000 | 56.589758049
2020-06-03 07:44:55.762000 | 2020-06-03 18:27:18.823000 | 11.672824461
2020-06-03 07:43:46.561000 | 2020-06-03 07:44:55.762000 | 8.41033962
2020-06-03 07:45:09.927000 | 2020-06-03 19:04:45.956000 | 554.0581161811679
2020-06-03 19:04:45.956000 | 2020-06-03 22:50:04.909000 | 1643.011471834471
2020-06-03 22:50:04.909000 | 2020-06-03 22:50:14.282000 | 1.1391003
2020-06-03 08:23:41.670000 | 2020-06-03 08:56:32.122000 | 239.476752
2020-06-03 22:50:14.282000 | 2020-06-04 02:34:12.764000 | 1633.23144864
2020-06-04 02:34:12.764000 | 2020-06-04 04:36:30.008000 | 891.7240180169999
2020-06-04 04:36:30.008000 | 2020-06-04 05:38:38.299000 | 453.113803362
2020-06-04 05:38:38.299000 | 2020-06-04 07:19:41.911000 | 736.9345192229999
2020-06-03 08:56:32.122000 | 2020-06-03 09:58:04.821000 | 448.788149139
2020-06-03 09:58:04.821000 | 2020-06-03 16:21:24.221000 | 2795.207230074
2020-06-04 07:19:41.911000 | 2020-06-04 09:01:10.540000 | 739.9749481590001
2020-06-04 09:01:10.540000 | 2020-06-04 10:21:09.148000 | 583.193563755
2020-06-04 10:21:09.148000 | 2020-06-04 17:03:44.918000 | 2935.745529717
2020-06-03 16:21:24.221000 | 2020-06-03 18:05:12.502000 | 756.947400759
2020-06-03 18:05:12.502000 | 2020-06-03 18:25:56.943000 | 151.2418213532612
2020-06-04 17:03:44.918000 | 2020-06-05 00:33:05.987000 | 3276.684556328767
2020-06-02 08:02:44.728000 | 2020-06-02 10:50:48.649000 | 1225.538512803
2020-06-02 10:50:48.649000 | 2020-06-02 11:01:09.141000 | 75.410874557
2020-06-02 15:21:16.011000 | 2020-06-02 16:21:02.672000 | 435.901009
2020-06-02 16:21:02.672000 | 2020-06-02 16:22:11.470000 | 8.361264819
2020-06-01 00:00:00 | 2020-06-01 02:07:01.386000 | 926.2569490546281
2020-06-01 02:07:01.386000 | 2020-06-01 02:07:03.162000 | 0.2158002338918919
2020-06-01 02:07:03.162000 | 2020-06-01 02:07:19.768000 | 2.01818175454054
2020-06-01 02:07:19.768000 | 2020-06-01 02:42:53.751000 | 259.3512569781509
2020-06-01 02:42:53.751000 | 2020-06-01 17:41:02.394000 | 6549.298307340544
2020-06-01 17:41:02.394000 | 2020-06-02 08:02:44.728000 | 6283.587626891207
2020-06-02 11:01:09.141000 | 2020-06-02 11:39:53.567000 | 282.4965880315925
2020-06-02 11:39:53.567000 | 2020-06-02 18:49:37.359000 | 2689.343166074618
2020-06-02 18:49:37.359000 | 2020-06-02 18:59:33.475000 | 72.448165566
2020-06-02 18:59:33.475000 | 2020-06-02 22:28:33.650000 | 1524.056698834163
2020-06-02 22:28:33.650000 | 2020-06-03 00:04:07.502000 | 696.8575428769096
2020-06-03 00:04:07.502000 | 2020-06-03 00:59:50.744000 | 406.3172825214003
2020-06-03 01:00:06.762000 | 2020-06-03 01:07:32.945000 | 54.22639977833554
2020-06-03 00:59:50.744000 | 2020-06-03 01:00:06.762000 | 1.946683315923552
2020-06-03 01:07:32.945000 | 2020-06-03 02:35:58.481000 | 644.8026596650844
2020-06-03 02:35:58.481000 | 2020-06-03 03:48:44.109000 | 530.5718765927629