Spreadsheet: 866293d1713262241-weighted-average-calculation-weighted-average-calcs
Sheet: Sheet1

Date | M\C | Total M\C Run Hrs | M\C HRS Avail | Daily Total Hrs Accum | %  M\C [NAME] | Total KWH Elec | Plant [NAME] | Flat KW Per Day | Machine Size | [NAME] Pday
2024-01-02 00:00:00 | 1 | 0:08:00 | 16:00:00 | 0:08:00 | 0.001203532367498608 | 4800 | 4320 |  | 1650
2024-01-02 00:00:00 | 2 | 0:00:00 | 16:00:00 | 0:08:00 | 0 | 4800 | 4320 |  | 1510
2024-01-02 00:00:00 | 3 | 15:20:25 | 16:00:00 | 15:28:25 | 0.1384689062398139 | 4800 | 4320 |  | 1510
2024-01-02 00:00:00 | 4 | 0:00:00 | 16:00:00 | 15:28:25 | 0 | 4800 | 4320 |  | 1070
2024-01-02 00:00:00 | 5 | 0:00:00 | 16:00:00 | 15:28:25 | 0 | 4800 | 4320 |  | 1510
2024-01-02 00:00:00 | 6 | 0:05:54 | 16:00:00 | 15:34:19 | 0.0008876051210302238 | 4800 | 4320 |  | 870
2024-01-02 00:00:00 | 7 | 15:24:49 | 16:00:00 | 1 day, 6:59:08 | 0.1391308490419381 | 4800 | 4320 |  | 870
2024-01-02 00:00:00 | 8 | 14:05:32 | 16:00:00 | 1 day, 21:04:40 | 0.1272033418082071 | 4800 | 4320 |  | 670
2024-01-02 00:00:00 | 9 | 0:00:00 | 16:00:00 | 1 day, 21:04:40 | 0 | 4800 | 4320 |  | 1450
2024-01-02 00:00:00 | 10 | 0:00:00 | 16:00:00 | 1 day, 21:04:40 | 0 | 4800 | 4320 |  | 1510
2024-01-02 00:00:00 | 11 | 13:34:45 | 16:00:00 | 2 days, 10:39:25 | 0.1225722495524364 | 4800 | 4320 |  | 1510
2024-01-02 00:00:00 | 12 | 6:57:22 | 16:00:00 | 2 days, 17:36:47 | 0.06278928655604199 | 4800 | 4320 |  | 1070
2024-01-02 00:00:00 | 13 | 13:22:11 | 16:00:00 | 3 days, 6:58:58 | 0.120681700791824 | 4800 | 4320 |  | 1395
2024-01-02 00:00:00 | 14 | 6:57:22 | 16:00:00 | 3 days, 13:56:20 | 0.06278928655604199 | 4800 | 4320 |  | 1070
2024-01-02 00:00:00 | 15 | 13:06:14 | 16:00:00 | 4 days, 3:02:34 | 0.1182821581341237 | 4800 | 4320 |  | 1070
2024-01-02 00:00:00 | 16 | 11:44:32 | 16:00:00 | 4 days, 14:47:06 | 0.1059910838310441 | 4800 | 4320 |  | 1395
2024-01-03 00:00:00 | 1 | 5:49:26 | 16:00:00 | 5:49:26 | 0.04416581878237495 | 5150 | 4635 |  | 1650
2024-01-03 00:00:00 | 2 | 0:00:00 | 16:00:00 | 5:49:26 | 0 | 5150 | 4635 |  | 1510
2024-01-03 00:00:00 | 3 | 5:06:41 | 16:00:00 | 10:56:07 | 0.03876253130852244 | 5150 | 4635 |  | 1510
2024-01-03 00:00:00 | 4 | 7:36:07 | 16:00:00 | 18:32:14 | 0.05764981220152892 | 5150 | 4635 |  | 1070
2024-01-03 00:00:00 | 5 | 0:00:00 | 16:00:00 | 18:32:14 | 0 | 5150 | 4635 |  | 1510
2024-01-03 00:00:00 | 6 | 7:57:23 | 16:00:00 | 1 day, 2:29:37 | 0.06033776339709843 | 5150 | 4635 |  | 870
2024-01-03 00:00:00 | 7 | 15:40:24 | 16:00:00 | 1 day, 18:10:01 | 0.1188596851558106 | 5150 | 4635 |  | 870
2024-01-03 00:00:00 | 8 | 15:41:15 | 16:00:00 | 2 days, 9:51:16 | 0.1189671189418404 | 5150 | 4635 |  | 670
2024-01-03 00:00:00 | 9 | 0:12:53 | 16:00:00 | 2 days, 10:04:09 | 0.001628359149040152 | 5150 | 4635 |  | 1450
2024-01-03 00:00:00 | 10 | 0:00:00 | 16:00:00 | 2 days, 10:04:09 | 0 | 5150 | 4635 |  | 1510
2024-01-03 00:00:00 | 11 | 7:30:38 | 16:00:00 | 2 days, 17:34:47 | 0.0569567589543954 | 5150 | 4635 |  | 1510
2024-01-03 00:00:00 | 12 | 11:31:13 | 16:00:00 | 3 days, 5:06:00 | 0.08736473349048156 | 5150 | 4635 |  | 1070
2024-01-03 00:00:00 | 13 | 10:29:06 | 16:00:00 | 3 days, 15:35:06 | 0.07951364093100853 | 5150 | 4635 |  | 1395
2024-01-03 00:00:00 | 14 | 13:32:05 | 16:00:00 | 4 days, 5:07:11 | 0.1026413965549566 | 5150 | 4635 |  | 1070
2024-01-03 00:00:00 | 15 | 14:59:10 | 16:00:00 | 4 days, 20:06:21 | 0.1136480932609524 | 5150 | 4635 |  | 1070
2024-01-03 00:00:00 | 16 | 15:45:30 | 16:00:00 | 5 days, 11:51:51 | 0.1195042878719895 | 5150 | 4635 |  | 1395
 |  |  |  |  |  | Total