Spreadsheet: 60059d1260562572-calculating-flow-of-a-reservoir-710274-flow
Sheet: Sheet1

Data & Time | % [NAME] | Period | Delta |  | Time | Period | Pumped | Released | Total Flow
2009-09-13 00:04:00 | 0.81 | Off-Peak |  |  | 1900-01-01 00:00:00 | Off-Peak | 0.3899999999999999 | -0.06000000000000005 | 0.45
2009-09-13 00:14:00 | 0.82 | Off-Peak | 0.009999999999999898 |  | 07:00:00 | Shoulder | 0.1600000000000001 | -0.49 | 0.6500000000000001
2009-09-13 00:24:00 | 0.82 | Off-Peak | 0 |  | 14:00:00 | Peak | 0.1200000000000001 | -0.1300000000000001 | 0.2500000000000002
2009-09-13 00:34:00 | 0.83 | Off-Peak | 0.01000000000000001 |  | 20:00:00 | Shoulder
2009-09-13 00:45:00 | 0.84 | Off-Peak | 0.01000000000000001
2009-09-13 00:55:00 | 0.85 | Off-Peak | 0.01000000000000001
2009-09-13 01:04:00 | 0.86 | Off-Peak | 0.01000000000000001
2009-09-13 01:14:00 | 0.86 | Off-Peak | 0
2009-09-13 01:24:00 | 0.87 | Off-Peak | 0.01000000000000001
2009-09-13 01:33:00 | 0.88 | Off-Peak | 0.01000000000000001
2009-09-13 01:43:00 | 0.89 | Off-Peak | 0.01000000000000001
2009-09-13 01:49:00 | 0.89 | Off-Peak | 0
2009-09-13 01:52:00 | 0.89 | Off-Peak | 0
2009-09-13 02:02:00 | 0.9 | Off-Peak | 0.01000000000000001
2009-09-13 02:11:00 | 0.91 | Off-Peak | 0.01000000000000001
2009-09-13 02:21:00 | 0.92 | Off-Peak | 0.01000000000000001
2009-09-13 02:30:00 | 0.93 | Off-Peak | 0.01000000000000001
2009-09-13 02:40:00 | 0.93 | Off-Peak | 0
2009-09-13 02:49:00 | 0.94 | Off-Peak | 0.009999999999999898
2009-09-13 02:58:00 | 0.95 | Off-Peak | 0.01000000000000001
2009-09-13 03:07:00 | 0.96 | Off-Peak | 0.01000000000000001
2009-09-13 03:17:00 | 0.97 | Off-Peak | 0.01000000000000001
2009-09-13 03:26:00 | 0.97 | Off-Peak | 0
2009-09-13 03:36:00 | 0.98 | Off-Peak | 0.01000000000000001
2009-09-13 04:06:00 | 0.98 | Off-Peak | 0
2009-09-13 04:31:00 | 0.97 | Off-Peak | -0.01000000000000001
2009-09-13 05:02:00 | 0.97 | Off-Peak | 0
2009-09-13 05:23:00 | 0.97 | Off-Peak | 0
2009-09-13 05:53:00 | 0.96 | Off-Peak | -0.01000000000000001
2009-09-13 06:14:00 | 0.96 | Off-Peak | 0
2009-09-13 06:45:00 | 0.95 | Off-Peak | -0.01000000000000001
2009-09-13 06:47:00 | 0.95 | Off-Peak | 0
2009-09-13 07:11:00 | 0.94 | Shoulder | -0.01000000000000001
2009-09-13 07:30:00 | 0.93 | Shoulder | -0.009999999999999898
2009-09-13 07:47:00 | 0.93 | Shoulder | 0
2009-09-13 08:02:00 | 0.92 | Shoulder | -0.01000000000000001
2009-09-13 08:03:00 | 0.92 | Shoulder | 0
2009-09-13 08:15:00 | 0.91 | Shoulder | -0.01000000000000001
2009-09-13 08:27:00 | 0.9 | Shoulder | -0.01000000000000001
2009-09-13 08:38:00 | 0.9 | Shoulder | 0
2009-09-13 08:50:00 | 0.89 | Shoulder | -0.01000000000000001
2009-09-13 09:01:00 | 0.88 | Shoulder | -0.01000000000000001
2009-09-13 09:09:00 | 0.87 | Shoulder | -0.01000000000000001
2009-09-13 09:12:00 | 0.87 | Shoulder | 0
2009-09-13 09:22:00 | 0.86 | Shoulder | -0.01000000000000001
2009-09-13 09:32:00 | 0.86 | Shoulder | 0
2009-09-13 09:43:00 | 0.85 | Shoulder | -0.01000000000000001
2009-09-13 09:54:00 | 0.84 | Shoulder | -0.01000000000000001
2009-09-13 10:04:00 | 0.83 | Shoulder | -0.01000000000000001
2009-09-13 10:15:00 | 0.82 | Shoulder | -0.01000000000000001
2009-09-13 10:25:00 | 0.82 | Shoulder | 0
2009-09-13 10:36:00 | 0.81 | Shoulder | -0.009999999999999898
2009-09-13 10:47:00 | 0.8 | Shoulder | -0.01000000000000001
2009-09-13 10:59:00 | 0.79 | Shoulder | -0.01000000000000001
2009-09-13 11:10:00 | 0.78 | Shoulder | -0.01000000000000001
2009-09-13 11:22:00 | 0.78 | Shoulder | 0
2009-09-13 11:35:00 | 0.77 | Shoulder | -0.01000000000000001
2009-09-13 11:48:00 | 0.76 | Shoulder | -0.01000000000000001
2009-09-13 12:02:00 | 0.75 | Shoulder | -0.01000000000000001
2009-09-13 12:16:00 | 0.75 | Shoulder | 0
2009-09-13 12:32:00 | 0.74 | Shoulder | -0.01000000000000001
2009-09-13 12:46:00 | 0.73 | Shoulder | -0.01000000000000001
2009-09-13 13:02:00 | 0.72 | Shoulder | -0.01000000000000001
2009-09-13 13:10:00 | 0.72 | Shoulder | 0
2009-09-13 13:17:00 | 0.71 | Shoulder | -0.01000000000000001
2009-09-13 13:33:00 | 0.71 | Shoulder | 0
2009-09-13 14:33:00 | 0.71 | Peak | 0
2009-09-13 14:57:00 | 0.72 | Peak | 0.01000000000000001
2009-09-13 15:28:00 | 0.73 | Peak | 0.01000000000000001
2009-09-13 15:29:00 | 0.73 | Peak | 0
2009-09-13 16:00:00 | 0.74 | Peak | 0.01000000000000001
2009-09-13 16:06:00 | 0.74 | Peak | 0
2009-09-13 16:28:00 | 0.74 | Peak | 0
2009-09-13 16:36:00 | 0.75 | Peak | 0.01000000000000001
2009-09-13 17:05:00 | 0.74 | Peak | -0.01000000000000001
2009-09-13 17:15:00 | 0.73 | Peak | -0.01000000000000001
2009-09-13 17:25:00 | 0.72 | Peak | -0.01000000000000001
2009-09-13 17:34:00 | 0.71 | Peak | -0.01000000000000001
2009-09-13 17:44:00 | 0.71 | Peak | 0
2009-09-13 17:54:00 | 0.7 | Peak | -0.01000000000000001
2009-09-13 18:12:00 | 0.71 | Peak | 0.01000000000000001
2009-09-13 18:28:00 | 0.71 | Peak | 0
2009-09-13 18:30:00 | 0.71 | Peak | 0
2009-09-13 18:47:00 | 0.72 | Peak | 0.01000000000000001
2009-09-13 19:00:00 | 0.73 | Peak | 0.01000000000000001
2009-09-13 19:01:00 | 0.73 | Peak | 0
2009-09-13 19:10:00 | 0.74 | Peak | 0.01000000000000001
2009-09-13 19:19:00 | 0.74 | Peak | 0
2009-09-13 19:28:00 | 0.75 | Peak | 0.01000000000000001
2009-09-13 19:42:00 | 0.74 | Peak | -0.01000000000000001
2009-09-13 20:00:00 | 0.74 | Shoulder | 0
2009-09-13 20:20:00 | 0.73 | Shoulder | -0.01000000000000001
2009-09-13 20:41:00 | 0.72 | Shoulder | -0.01000000000000001
2009-09-13 21:02:00 | 0.71 | Shoulder | -0.01000000000000001
2009-09-13 21:31:00 | 0.71 | Shoulder | 0
2009-09-13 22:01:00 | 0.7 | Shoulder | -0.01000000000000001
2009-09-13 22:28:00 | 0.71 | Shoulder | 0.01000000000000001
2009-09-13 22:43:00 | 0.72 | Shoulder | 0.01000000000000001
2009-09-13 22:57:00 | 0.73 | Shoulder | 0.01000000000000001
2009-09-13 23:11:00 | 0.74 | Shoulder | 0.01000000000000001
2009-09-13 23:24:00 | 0.74 | Shoulder | 0
2009-09-13 23:36:00 | 0.75 | Shoulder | 0.01000000000000001
2009-09-13 23:49:00 | 0.76 | Shoulder | 0.01000000000000001
2009-09-14 00:02:00 | 0.77 | Off-Peak | 0.01000000000000001
2009-09-14 00:15:00 | 0.78 | Off-Peak | 0.01000000000000001
2009-09-14 00:28:00 | 0.78 | Off-Peak | 0
2009-09-14 00:40:00 | 0.79 | Off-Peak | 0.01000000000000001
2009-09-14 00:52:00 | 0.8 | Off-Peak | 0.01000000000000001
2009-09-14 01:04:00 | 0.81 | Off-Peak | 0.01000000000000001
2009-09-14 01:15:00 | 0.82 | Off-Peak | 0.009999999999999898
2009-09-14 01:26:00 | 0.82 | Off-Peak | 0
2009-09-14 01:38:00 | 0.83 | Off-Peak | 0.01000000000000001
2009-09-14 01:50:00 | 0.84 | Off-Peak | 0.01000000000000001
2009-09-14 02:01:00 | 0.85 | Off-Peak | 0.01000000000000001
2009-09-14 02:03:00 | 0.85 | Off-Peak | 0
2009-09-14 02:12:00 | 0.86 | Off-Peak | 0.01000000000000001
2009-09-14 02:24:00 | 0.86 | Off-Peak | 0
2009-09-14 02:35:00 | 0.87 | Off-Peak | 0.01000000000000001
2009-09-14 02:47:00 | 0.88 | Off-Peak | 0.01000000000000001
2009-09-14 02:59:00 | 0.89 | Off-Peak | 0.01000000000000001
2009-09-14 03:10:00 | 0.89 | Off-Peak | 0
2009-09-14 03:22:00 | 0.9 | Off-Peak | 0.01000000000000001
2009-09-14 03:34:00 | 0.91 | Off-Peak | 0.01000000000000001
2009-09-14 03:46:00 | 0.92 | Off-Peak | 0.01000000000000001
2009-09-14 03:58:00 | 0.93 | Off-Peak | 0.01000000000000001
2009-09-14 04:11:00 | 0.93 | Off-Peak | 0
2009-09-14 04:23:00 | 0.94 | Off-Peak | 0.009999999999999898
2009-09-14 04:36:00 | 0.95 | Off-Peak | 0.01000000000000001
2009-09-14 04:49:00 | 0.96 | Off-Peak | 0.01000000000000001
2009-09-14 05:02:00 | 0.97 | Off-Peak | 0.01000000000000001
2009-09-14 05:14:00 | 0.97 | Off-Peak | 0
2009-09-14 05:27:00 | 0.98 | Off-Peak | 0.01000000000000001
2009-09-14 05:57:00 | 0.98 | Off-Peak | 0
2009-09-14 05:59:00 | 0.97 | Off-Peak | -0.01000000000000001
2009-09-14 06:22:00 | 0.97 | Off-Peak | 0
2009-09-14 06:29:00 | 0.96 | Off-Peak | -0.01000000000000001
2009-09-14 06:39:00 | 0.96 | Off-Peak | 0
2009-09-14 06:53:00 | 0.95 | Off-Peak | -0.01000000000000001
2009-09-14 07:05:00 | 0.94 | Shoulder | -0.01000000000000001
2009-09-14 07:17:00 | 0.93 | Shoulder | -0.009999999999999898
2009-09-14 07:27:00 | 0.93 | Shoulder | 0
2009-09-14 07:38:00 | 0.92 | Shoulder | -0.01000000000000001
2009-09-14 07:50:00 | 0.91 | Shoulder | -0.01000000000000001
2009-09-14 08:03:00 | 0.9 | Shoulder | -0.01000000000000001
2009-09-14 08:16:00 | 0.9 | Shoulder | 0
2009-09-14 08:28:00 | 0.89 | Shoulder | -0.01000000000000001
2009-09-14 08:42:00 | 0.88 | Shoulder | -0.01000000000000001
2009-09-14 08:56:00 | 0.87 | Shoulder | -0.01000000000000001
2009-09-14 09:10:00 | 0.86 | Shoulder | -0.01000000000000001
2009-09-14 09:26:00 | 0.86 | Shoulder | 0
2009-09-14 09:43:00 | 0.85 | Shoulder | -0.01000000000000001
2009-09-14 10:01:00 | 0.84 | Shoulder | -0.01000000000000001
2009-09-14 10:20:00 | 0.83 | Shoulder | -0.01000000000000001
2009-09-14 10:30:00 | 0.83 | Shoulder | 0
2009-09-14 10:38:00 | 0.82 | Shoulder | -0.01000000000000001
2009-09-14 10:58:00 | 0.82 | Shoulder | 0
2009-09-14 11:21:00 | 0.81 | Shoulder | -0.009999999999999898
2009-09-14 11:28:00 | 0.81 | Shoulder | 0
2009-09-14 11:45:00 | 0.8 | Shoulder | -0.01000000000000001
2009-09-14 12:12:00 | 0.79 | Shoulder | -0.01000000000000001
2009-09-14 12:38:00 | 0.78 | Shoulder | -0.01000000000000001
2009-09-14 13:05:00 | 0.78 | Shoulder | 0
2009-09-14 13:30:00 | 0.77 | Shoulder | -0.01000000000000001
2009-09-14 13:58:00 | 0.76 | Shoulder | -0.01000000000000001
2009-09-14 14:24:00 | 0.75 | Peak | -0.01000000000000001
2009-09-14 14:52:00 | 0.75 | Peak | 0
2009-09-14 15:19:00 | 0.74 | Peak | -0.01000000000000001
2009-09-14 15:29:00 | 0.74 | Peak | 0
2009-09-14 15:45:00 | 0.73 | Peak | -0.01000000000000001
2009-09-14 16:10:00 | 0.72 | Peak | -0.01000000000000001
2009-09-14 16:31:00 | 0.71 | Peak | -0.01000000000000001
2009-09-14 16:51:00 | 0.71 | Peak | 0
2009-09-14 17:22:00 | 0.71 | Peak | 0
2009-09-14 17:33:00 | 0.71 | Peak | 0
2009-09-14 17:47:00 | 0.72 | Peak | 0.01000000000000001
2009-09-14 18:02:00 | 0.73 | Peak | 0.01000000000000001
2009-09-14 18:16:00 | 0.74 | Peak | 0.01000000000000001
2009-09-14 18:29:00 | 0.74 | Peak | 0
2009-09-14 18:59:00 | 0.74 | Peak | 0
2009-09-14 19:07:00 | 0.74 | Peak | 0
2009-09-14 19:27:00 | 0.73 | Peak | -0.01000000000000001
2009-09-14 19:46:00 | 0.72 | Peak | -0.01000000000000001
2009-09-14 20:05:00 | 0.71 | Shoulder | -0.01000000000000001
2009-09-14 20:30:00 | 0.71 | Shoulder | 0
2009-09-14 20:54:00 | 0.7 | Shoulder | -0.01000000000000001
2009-09-14 21:09:00 | 0.71 | Shoulder | 0.01000000000000001
2009-09-14 21:24:00 | 0.71 | Shoulder | 0
2009-09-14 21:39:00 | 0.72 | Shoulder | 0.01000000000000001
2009-09-14 21:55:00 | 0.73 | Shoulder | 0.01000000000000001
2009-09-14 21:56:00 | 0.73 | Shoulder | 0
2009-09-14 22:09:00 | 0.74 | Shoulder | 0.01000000000000001
2009-09-14 22:22:00 | 0.74 | Shoulder | 0
2009-09-14 22:36:00 | 0.75 | Shoulder | 0.01000000000000001
2009-09-14 22:51:00 | 0.76 | Shoulder | 0.01000000000000001
2009-09-14 23:04:00 | 0.77 | Shoulder | 0.01000000000000001
2009-09-14 23:17:00 | 0.78 | Shoulder | 0.01000000000000001
2009-09-14 23:29:00 | 0.78 | Shoulder | 0
2009-09-14 23:41:00 | 0.79 | Shoulder | 0.01000000000000001
2009-09-14 23:53:00 | 0.8 | Shoulder | 0.01000000000000001