Spreadsheet: 879156d1726600645-pickup-the-last-value-in-a-row-and-paste-it-into-a-specific-cell-just-energy-sample
Sheet: 2nd Set

Billing Start date MM/DD/YYYY |  | 2024-09-01 00:00:00
Start Time | End Time | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export
12:00 am | 12:15 am | 1.036 | 0 | 0.541 | 0 | 0.561 | 0 | 0.42 | 0 | 0.895 | 0 | 1.002 | 0 | 0.69 | 0 | 0.599 | 0 | 0.561 | 0 | 1.047 | 0 | 0.898 | 0
12:15 am | 12:30 am | 1.161 | 0 | 0.522 | 0 | 0.5 | 0 | 0.4 | 0 | 0.891 | 0 | 1.002 | 0 | 0.681 | 0 | 0.579 | 0 | 0.561 | 0 | 1.068 | 0 | 0.912 | 0
12:30 am | 12:45 am | 0.799 | 0 | 0.523 | 0 | 0.501 | 0 | 0.424 | 0 | 0.862 | 0 | 1.009 | 0 | 0.661 | 0 | 0.51 | 0 | 0.563 | 0 | 1.076 | 0 | 0.905 | 0
12:45 am | 01:00 am | 1.269 | 0 | 0.553 | 0 | 0.492 | 0 | 0.375 | 0 | 0.888 | 0 | 1.021 | 0 | 0.633 | 0 | 0.562 | 0 | 0.558 | 0 | 1.105 | 0 | 0.901 | 0
01:00 am | 01:15 am | 0.867 | 0 | 0.459 | 0 | 0.493 | 0 | 0.39 | 0 | 0.874 | 0 | 1.017 | 0 | 0.656 | 0 | 0.565 | 0 | 0.557 | 0 | 1.073 | 0 | 0.897 | 0
01:15 am | 01:30 am | 0.762 | 0 | 0.449 | 0 | 0.492 | 0 | 0.427 | 0 | 0.87 | 0 | 1.02 | 0 | 0.662 | 0 | 0.578 | 0 | 0.566 | 0 | 1.063 | 0 | 0.942 | 0
01:30 am | 01:45 am | 1.418 | 0 | 0.442 | 0 | 0.484 | 0 | 0.369 | 0 | 0.863 | 0 | 0.98 | 0 | 0.654 | 0 | 0.532 | 0 | 0.525 | 0 | 1.052 | 0 | 0.929 | 0
01:45 am | 02:00 am | 0.725 | 0 | 0.435 | 0 | 0.474 | 0 | 0.396 | 0 | 0.853 | 0 | 1.011 | 0 | 0.651 | 0 | 0.577 | 0 | 0.54 | 0 | 0.998 | 0 | 0.934 | 0
02:00 am | 02:15 am | 0.801 | 0 | 0.442 | 0 | 0.464 | 0 | 0.394 | 0 | 0.855 | 0 | 1 | 0 | 0.647 | 0 | 0.573 | 0 | 0.57 | 0 | 1.051 | 0 | 0.937 | 0
02:15 am | 02:30 am | 1.27 | 0 | 0.475 | 0 | 0.438 | 0 | 0.382 | 0 | 0.848 | 0 | 0.979 | 0 | 0.649 | 0 | 0.548 | 0 | 0.571 | 0 | 1.035 | 0 | 0.921 | 0
02:30 am | 02:45 am | 0.742 | 0 | 0.456 | 0 | 0.41 | 0 | 0.361 | 0 | 0.843 | 0 | 0.981 | 0 | 0.619 | 0 | 0.535 | 0 | 0.57 | 0 | 1.025 | 0 | 0.871 | 0
02:45 am | 03:00 am | 0.676 | 0 | 0.433 | 0 | 0.401 | 0 | 0.412 | 0 | 0.847 | 0 | 0.98 | 0 | 0.672 | 0 | 0.534 | 0 | 0.576 | 0 | 0.998 | 0 | 0.906 | 0
03:00 am | 03:15 am | 1.101 | 0 | 0.408 | 0 | 0.417 | 0 | 0.381 | 0 | 0.846 | 0 | 0.951 | 0 | 0.68 | 0 | 0.547 | 0 | 0.522 | 0 | 1.048 | 0 | 0.904 | 0
03:15 am | 03:30 am | 0.901 | 0 | 0.421 | 0 | 0.416 | 0 | 0.375 | 0 | 0.84 | 0 | 0.974 | 0 | 0.678 | 0 | 0.543 | 0 | 0.562 | 0 | 1.013 | 0 | 0.915 | 0
03:30 am | 03:45 am | 0.722 | 0 | 0.438 | 0 | 0.423 | 0 | 0.391 | 0 | 0.839 | 0 | 0.985 | 0 | 0.667 | 0 | 0.543 | 0 | 0.544 | 0 | 0.996 | 0 | 0.918 | 0
03:45 am | 04:00 am | 0.693 | 0 | 0.432 | 0 | 0.418 | 0 | 0.353 | 0 | 1.338 | 0 | 0.985 | 0 | 0.625 | 0 | 0.482 | 0 | 0.547 | 0 | 0.994 | 0 | 0.906 | 0
04:00 am | 04:15 am | 1.287 | 0 | 0.436 | 0 | 0.403 | 0 | 0.369 | 0 | 1.93 | 0 | 0.988 | 0 | 0.645 | 0 | 0.513 | 0 | 0.483 | 0 | 0.937 | 0 | 0.892 | 0
04:15 am | 04:30 am | 0.642 | 0 | 0.433 | 0 | 0.409 | 0 | 0.379 | 0 | 1.496 | 0 | 0.985 | 0 | 0.643 | 0 | 0.515 | 0 | 0.529 | 0 | 0.973 | 0 | 0.92 | 0
04:30 am | 04:45 am | 0.714 | 0 | 0.433 | 0 | 0.39 | 0 | 0.319 | 0 | 0.897 | 0 | 0.991 | 0 | 0.642 | 0 | 0.529 | 0 | 0.495 | 0 | 0.982 | 0 | 0.927 | 0
04:45 am | 05:00 am | 0.691 | 0 | 0.432 | 0 | 0.387 | 0 | 0.377 | 0 | 1.012 | 0 | 0.943 | 0 | 0.648 | 0 | 0.542 | 0 | 0.525 | 0 | 0.856 | 0 | 0.936 | 0
05:00 am | 05:15 am | 1.169 | 0 | 0.43 | 0 | 0.382 | 0 | 0.382 | 0 | 1.111 | 0 | 0.985 | 0 | 0.635 | 0 | 0.613 | 0 | 0.527 | 0 | 0.97 | 0 | 0.937 | 0
05:15 am | 05:30 am | 0.691 | 0 | 0.438 | 0 | 0.396 | 0 | 0.318 | 0 | 1.168 | 0 | 0.986 | 0 | 0.597 | 0 | 0.534 | 0 | 0.48 | 0 | 0.933 | 0 | 0.895 | 0
05:30 am | 05:45 am | 0.647 | 0 | 0.411 | 0 | 0.394 | 0 | 0.383 | 0 | 1.126 | 0 | 0.983 | 0 | 0.633 | 0 | 0.522 | 0 | 0.538 | 0 | 0.918 | 0 | 0.906 | 0
05:45 am | 06:00 am | 0.722 | 0 | 0.405 | 0 | 0.465 | 0 | 0.363 | 0 | 1.132 | 0 | 0.968 | 0 | 0.631 | 0 | 0.47 | 0 | 0.493 | 0 | 0.976 | 0 | 0.916 | 0
06:00 am | 06:15 am | 1.163 | 0 | 0.397 | 0 | 0.439 | 0 | 0.303 | 0 | 1.135 | 0 | 0.955 | 0 | 0.641 | 0 | 0.505 | 0 | 0.539 | 0 | 0.924 | 0 | 0.917 | 0
06:15 am | 06:30 am | 0.625 | 0 | 0.42 | 0 | 0.437 | 0 | 0.307 | 0 | 1.164 | 0 | 0.93 | 0 | 0.606 | 0 | 0.537 | 0 | 0.493 | 0 | 0.99 | 0 | 0.876 | 0
06:30 am | 06:45 am | 0.679 | 0 | 0.413 | 0 | 0.401 | 0 | 0.306 | 0 | 1.137 | 0 | 0.938 | 0 | 0.402 | 0 | 0.367 | 0 | 0.392 | 0 | 0.45 | 0 | 0.422 | 0
06:45 am | 07:00 am | 0.666 | 0 | 0.405 | 0 | 0.397 | 0 | 0.403 | 0 | 1.233 | 0 | 1.012 | 0 | 0.426 | 0 | 0.389 | 0 | 0.345 | 0 | 0.393 | 0 | 0.426 | 0
07:00 am | 07:15 am | 0.775 | 0 | 0.411 | 0 | 0.394 | 0 | 0.333 | 0 | 1.22 | 0 | 1.018 | 0 | 0.487 | 0 | 0.396 | 0 | 0.373 | 0 | 0.316 | 0 | 0.435 | 0
07:15 am | 07:30 am | 1.069 | 0 | 0.384 | 0 | 0.393 | 0 | 0.324 | 0 | 1.134 | 0 | 0.91 | 0 | 0.403 | 0 | 0.465 | 0 | 0.32 | 0 | 0.369 | 0 | 0.445 | 0
07:30 am | 07:45 am | 0.594 | 0 | 0.28 | 0 | 0.357 | 0 | 0.277 | 0 | 1.06 | 0 | 0.977 | 0 | 0.441 | 0 | 0.432 | 0 | 0.325 | 0 | 0.289 | 0 | 0.379 | 0
07:45 am | 08:00 am | 0.634 | 0 | 0.204 | 0 | 0.311 | 0 | 0.221 | 0 | 0.973 | 0 | 0.829 | 0 | 0.244 | 0 | 0.452 | 0 | 0.297 | 0 | 0.278 | 0 | 0.306 | 0
08:00 am | 08:15 am | 0.802 | 0 | 0.164 | 0 | 0.226 | 0 | 0.16 | 0 | 0.916 | 0 | 0.772 | 0 | 0.247 | 0 | 0.402 | 0 | 0.273 | 0 | 0.243 | 0 | 0.312 | 0
08:15 am | 08:30 am | 1.434 | 0 | 0.071 | 0.004 | 0.161 | 0 | 0.094 | 0 | 0.83 | 0 | 0.307 | 0 | 0.093 | 0.003 | 0.323 | 0 | 0.154 | 0 | 0.199 | 0 | 0.345 | 0
08:30 am | 08:45 am | 1.492 | 0 | 0.081 | 0.05 | 0.129 | 0 | 0.012 | 0.015 | 0.891 | 0 | 0.248 | 0 | 0.084 | 0.04 | 0.298 | 0 | 0.102 | 0.02 | 0.19 | 0 | 0.234 | 0
08:45 am | 09:00 am | 1.33 | 0 | 0.022 | 0.136 | 0.183 | 0 | 0.015 | 0.058 | 0.856 | 0 | 0.139 | 0.007 | 0.015 | 0.143 | 0.229 | 0.003 | 0.03 | 0.095 | 0.164 | 0 | 0.146 | 0
09:00 am | 09:15 am | 1.039 | 0 | 0.015 | 0.099 | 0.083 | 0.007 | 0 | 0.215 | 0.834 | 0 | 0.16 | 0.007 | 0.009 | 0.301 | 0.239 | 0.006 | 0.03 | 0.19 | 0.229 | 0 | 0.084 | 0.023
09:15 am | 09:30 am | 0.994 | 0 | 0.001 | 0.204 | 0.057 | 0.023 | 0 | 0.121 | 0.768 | 0 | 0.148 | 0.008 | 0 | 0.211 | 0.334 | 0 | 0 | 0.293 | 0.162 | 0.009 | 0.04 | 0.033
09:30 am | 09:45 am | 1.359 | 0 | 0.001 | 0.272 | 0.026 | 0.093 | 0.019 | 0.339 | 0.65 | 0 | 0.008 | 0.201 | 0.104 | 0.054 | 0.3 | 0 | 0 | 0.474 | 0.165 | 0.007 | 0 | 0.238
09:45 am | 10:00 am | 0.591 | 0 | 0 | 0.331 | 0.005 | 0.238 | 0 | 0.491 | 0.659 | 0 | 0 | 0.172 | 0.105 | 0.081 | 0.283 | 0 | 0 | 0.548 | 0.144 | 0.006 | 0 | 0.516
10:00 am | 10:15 am | 0.464 | 0 | 0.022 | 0.196 | 0.007 | 0.267 | 0 | 0.543 | 0.613 | 0 | 0.153 | 0.023 | 0.177 | 0.046 | 0.287 | 0.019 | 0 | 0.564 | 0.492 | 0.004 | 0.031 | 0.178
10:15 am | 10:30 am | 0.592 | 0 | 0.018 | 0.208 | 0.031 | 0.427 | 0.106 | 0.329 | 0.571 | 0 | 0.116 | 0.01 | 0.127 | 0.033 | 0.002 | 0.196 | 0 | 0.766 | 0.487 | 0 | 0.031 | 0.082
10:30 am | 10:45 am | 0.193 | 0.019 | 0 | 0.738 | 0 | 0.729 | 0.062 | 0.547 | 0.392 | 0 | 0.19 | 0.003 | 0.03 | 0.117 | 0 | 0.844 | 0.019 | 0.781 | 0.456 | 0 | 0.087 | 0.187
10:45 am | 11:00 am | 0.064 | 0.121 | 0 | 0.87 | 0.019 | 0.696 | 0.013 | 0.808 | 0.241 | 0 | 0.06 | 0.151 | 0.056 | 0.073 | 0.003 | 0.693 | 0.004 | 1.078 | 0.49 | 0 | 0.015 | 0.624
11:00 am | 11:15 am | 1.463 | 0.072 | 0 | 0.81 | 0.044 | 0.619 | 0.305 | 0.008 | 0.183 | 0 | 0 | 0.262 | 0.279 | 0 | 0 | 0.459 | 0.022 | 0.574 | 0.547 | 0 | 0.034 | 0.433
11:15 am | 11:30 am | 0 | 0.508 | 0.012 | 0.799 | 0.006 | 0.706 | 0.205 | 0.264 | 0.137 | 0 | 0.001 | 0.277 | 0.218 | 0.012 | 0 | 0.802 | 0.002 | 1.005 | 0.639 | 0 | 0.323 | 0
11:30 am | 11:45 am | 0.145 | 0.402 | 0.009 | 0.978 | 0.2 | 0.613 | 0.065 | 0.772 | 0.128 | 0 | 0 | 0.694 | 0.159 | 0.006 | 0.007 | 1.21 | 0 | 1.328 | 0.619 | 0 | 0.295 | 0
11:45 am | 12:00 pm | 0.109 | 0.499 | 0.045 | 0.063 | 0.263 | 0.457 | 0.037 | 0.736 | 0.076 | 0.068 | 0 | 0.688 | 0.072 | 0.064 | 0.006 | 1.486 | 0 | 1.644 | 0.575 | 0 | 0.399 | 0
12:00 pm | 12:15 pm | 0.888 | 0.172 | 0.004 | 0.237 | 0.207 | 0.697 | 0.069 | 0.161 | 0.063 | 0.093 | 0.021 | 0.52 | 0.025 | 0.138 | 0.018 | 1.11 | 0 | 1.572 | 0.219 | 0.026 | 0.457 | 0
12:15 pm | 12:30 pm | 0.859 | 0.456 | 0 | 0.657 | 0.311 | 0.091 | 0.05 | 0.492 | 0.058 | 0.052 | 0 | 0.333 | 0.055 | 0.23 | 0 | 1.582 | 0.019 | 0.59 | 0.15 | 0.01 | 0.317 | 0
12:30 pm | 12:45 pm | 0.017 | 0.744 | 0 | 0.505 | 0 | 1.135 | 0 | 1.668 | 0.001 | 0.229 | 0 | 0.565 | 0.052 | 0.271 | 0.004 | 0.718 | 0.27 | 0.162 | 0.383 | 0 | 0.255 | 0.076
12:45 pm | 01:00 pm | 0.413 | 0.336 | 0 | 1.081 | 0 | 0.669 | 0 | 1.55 | 0.007 | 0.285 | 0 | 1.38 | 0.091 | 0.277 | 0 | 1.324 | 0.166 | 0.269 | 0.38 | 0 | 0.121 | 0.132
01:00 pm | 01:15 pm | 0.087 | 0.72 | 0.037 | 1.165 | 0.127 | 0.484 | 0 | 0.955 | 0.117 | 0.227 | 0 | 1.524 | 0.053 | 0.238 | 0 | 1.366 | 0.205 | 0.313 | 0.472 | 0 | 0.102 | 0.105
01:15 pm | 01:30 pm | 0.717 | 0.27 | 0.001 | 1.309 | 0.029 | 0.673 | 0 | 1.546 | 0.017 | 0.786 | 0 | 1.225 | 0.091 | 0.091 | 0.006 | 1.312 | 0.116 | 0.336 | 0.479 | 0 | 0 | 0.908
01:30 pm | 01:45 pm | 0.328 | 0.364 | 0.132 | 0.831 | 0.036 | 1.027 | 0.03 | 1.205 | 0.007 | 0.395 | 0.001 | 0.504 | 0 | 0.307 | 0.04 | 1.258 | 0.078 | 0.726 | 0.487 | 0 | 0.004 | 0.964
01:45 pm | 02:00 pm | 0.234 | 0.453 | 0.019 | 1.165 | 0 | 1.457 | 0.042 | 0.6 | 0.099 | 0.176 | 0 | 0.471 | 0.082 | 0.126 | 0.019 | 1.261 | 0.184 | 0.581 | 0.475 | 0 | 0 | 1.777
02:00 pm | 02:15 pm | 0.141 | 0.154 | 0.171 | 0.955 | 0.106 | 1.285 | 0.03 | 0.948 | 0.033 | 0.539 | 0.016 | 0.307 | 0.002 | 0.438 | 0.031 | 0.878 | 0.118 | 0.663 | 0.484 | 0 | 0 | 0.801
02:15 pm | 02:30 pm | 0.117 | 0.026 | 0.063 | 1.192 | 0.236 | 0.737 | 0.149 | 0.259 | 0.091 | 0.288 | 0.025 | 0.586 | 0 | 0.744 | 0.02 | 0.683 | 0.077 | 0.971 | 0.438 | 0 | 0 | 0.626
02:30 pm | 02:45 pm | 0.034 | 0.241 | 0.017 | 0.993 | 0 | 1.549 | 0.27 | 0 | 0.086 | 0.439 | 0.079 | 0.111 | 0.006 | 0.317 | 0.064 | 0.954 | 0.457 | 0.235 | 0.225 | 0.015 | 0.012 | 0.371
02:45 pm | 03:00 pm | 0.609 | 0.006 | 0.255 | 0.148 | 0.007 | 1.291 | 0.091 | 0.183 | 0.226 | 0.105 | 0.028 | 0.214 | 0.003 | 0.283 | 0.049 | 1.486 | 0.216 | 0.877 | 0.329 | 0.017 | 0 | 0.671
03:00 pm | 03:15 pm | 0.751 | 0 | 0.07 | 1.3 | 0.506 | 0 | 0.591 | 0 | 0.193 | 0.006 | 0.143 | 0.056 | 0.105 | 0.061 | 0.109 | 1.183 | 0.007 | 1.169 | 0.51 | 0 | 0 | 1.318
03:15 pm | 03:30 pm | 0.271 | 0.176 | 0.495 | 0 | 0.495 | 0 | 0.848 | 0 | 0.346 | 0 | 0.368 | 0.001 | 0.095 | 0.199 | 0.054 | 1.51 | 0.083 | 0.155 | 0.499 | 0 | 0 | 0.925
03:30 pm | 03:45 pm | 0.13 | 0.498 | 0.057 | 1.027 | 0.48 | 0 | 0.655 | 0 | 0.064 | 0.986 | 0.196 | 0.151 | 0.006 | 0.349 | 0.011 | 1.435 | 0.419 | 0.021 | 0.3 | 0 | 0.007 | 0.52
03:45 pm | 04:00 pm | 0.053 | 0.642 | 0.002 | 1.189 | 0.508 | 0 | 0.624 | 0 | 0.058 | 1.002 | 0.021 | 0.138 | 0 | 0.688 | 0.189 | 0.762 | 0.346 | 0 | 0.46 | 0 | 0 | 0.426
04:00 pm | 04:15 pm | 0.528 | 0 | 0.071 | 0.432 | 0.373 | 0.015 | 0.334 | 0 | 0.126 | 0.565 | 0.001 | 0.464 | 0.006 | 1.687 | 0.063 | 1.185 | 0.021 | 0.223 | 0.051 | 0.092 | 0 | 1.211
04:15 pm | 04:30 pm | 0.227 | 0.301 | 0 | 1.455 | 0.309 | 0 | 0.327 | 0 | 0.03 | 0.664 | 0.105 | 0.373 | 0 | 1.414 | 0 | 1.573 | 0 | 0.517 | 0.004 | 0.135 | 0.032 | 1.434
04:30 pm | 04:45 pm | 0.435 | 0.15 | 0.015 | 0.787 | 0.642 | 0 | 0.294 | 0 | 0.315 | 0.013 | 0.004 | 0.453 | 0.005 | 1.026 | 0 | 1.501 | 0 | 0.602 | 0 | 0.348 | 0 | 1.449
04:45 pm | 05:00 pm | 0.483 | 0.236 | 0.06 | 0.459 | 0.586 | 0 | 0.228 | 0 | 0.549 | 0.162 | 0.145 | 0.235 | 0 | 1.114 | 0.035 | 1.281 | 0 | 0.412 | 0.315 | 0.051 | 0.074 | 0.267
05:00 pm | 05:15 pm | 0.828 | 0.102 | 0 | 0.716 | 0.656 | 0 | 0.144 | 0 | 1.19 | 0 | 0.064 | 0.177 | 0.015 | 0.383 | 0.004 | 1.158 | 0.006 | 0.219 | 0.252 | 0.05 | 0 | 0.625
05:15 pm | 05:30 pm | 1.129 | 0.006 | 0 | 0.821 | 0.619 | 0 | 0.23 | 0 | 0.42 | 0.288 | 0.213 | 0.32 | 0.012 | 1.076 | 0.009 | 1.061 | 0.103 | 0.028 | 0.392 | 0 | 0.282 | 0.109
05:30 pm | 05:45 pm | 0.916 | 0 | 0 | 0.448 | 0.534 | 0 | 0.643 | 0 | 0.778 | 0 | 0.236 | 0.001 | 0 | 0.595 | 0 | 1.042 | 0.283 | 0 | 0.496 | 0 | 0.582 | 0
05:45 pm | 06:00 pm | 0.661 | 0.028 | 0.333 | 0.009 | 0.607 | 0 | 0.86 | 0 | 0.629 | 0 | 0.211 | 0 | 0.029 | 0.319 | 0 | 0.882 | 0.309 | 0 | 0.427 | 0 | 0.058 | 0.473
06:00 pm | 06:15 pm | 0.481 | 0 | 0.364 | 0 | 0.61 | 0 | 0.877 | 0 | 0.759 | 0 | 0.354 | 0 | 0.343 | 0.002 | 0 | 0.675 | 0.42 | 0 | 0.414 | 0 | 0.094 | 0.178
06:15 pm | 06:30 pm | 0.595 | 0 | 0.396 | 0 | 0.535 | 0 | 0.952 | 0 | 0.724 | 0 | 0.479 | 0 | 0.465 | 0 | 0 | 0.508 | 0.352 | 0 | 0.68 | 0 | 0.096 | 0.308
06:30 pm | 06:45 pm | 0.954 | 0 | 0.482 | 0 | 0.595 | 0 | 1.126 | 0 | 0.73 | 0 | 0.697 | 0 | 0.425 | 0.023 | 0.01 | 0.214 | 0.412 | 0 | 0.863 | 0 | 0.253 | 0
06:45 pm | 07:00 pm | 0.616 | 0 | 0.519 | 0 | 0.525 | 0 | 1.135 | 0 | 1.425 | 0 | 0.363 | 0 | 0.972 | 0 | 0.02 | 0.063 | 0.435 | 0 | 0.707 | 0 | 0.398 | 0
07:00 pm | 07:15 pm | 0.865 | 0 | 0.549 | 0 | 0.456 | 0 | 1.099 | 0 | 1.588 | 0 | 0.314 | 0 | 0.954 | 0 | 0.254 | 0.007 | 0.496 | 0 | 0.553 | 0 | 0.484 | 0
07:15 pm | 07:30 pm | 1.129 | 0 | 0.573 | 0 | 0.513 | 0 | 1.057 | 0 | 1.496 | 0 | 0.572 | 0 | 1.24 | 0 | 0.432 | 0 | 0.56 | 0 | 0.556 | 0 | 0.486 | 0
07:30 pm | 07:45 pm | 1.146 | 0 | 0.585 | 0 | 0.491 | 0 | 1.075 | 0 | 1.391 | 0 | 0.627 | 0 | 1.387 | 0 | 0.466 | 0 | 0.586 | 0 | 0.844 | 0 | 0.521 | 0
07:45 pm | 08:00 pm | 1.16 | 0 | 0.593 | 0 | 0.457 | 0 | 1.076 | 0 | 1.515 | 0 | 0.642 | 0 | 1.475 | 0 | 0.537 | 0 | 0.697 | 0 | 0.844 | 0 | 0.593 | 0
08:00 pm | 08:15 pm | 1.131 | 0 | 0.59 | 0 | 0.512 | 0 | 1.11 | 0 | 1.456 | 0 | 0.619 | 0 | 0.819 | 0 | 0.534 | 0 | 0.725 | 0 | 0.628 | 0 | 1.101 | 0
08:15 pm | 08:30 pm | 1.064 | 0 | 0.58 | 0 | 0.575 | 0 | 1.106 | 0 | 1.27 | 0 | 0.616 | 0 | 0.685 | 0 | 0.468 | 0 | 0.694 | 0 | 0.568 | 0 | 0.785 | 0
08:30 pm | 08:45 pm | 1.013 | 0 | 0.58 | 0 | 0.625 | 0 | 1.164 | 0 | 1.199 | 0 | 0.516 | 0 | 0.701 | 0 | 0.488 | 0 | 0.673 | 0 | 0.546 | 0 | 0.73 | 0
08:45 pm | 09:00 pm | 0.999 | 0 | 0.626 | 0 | 0.615 | 0 | 1.212 | 0 | 1.228 | 0 | 0.49 | 0 | 0.757 | 0 | 0.487 | 0 | 0.643 | 0 | 0.627 | 0 | 0.6 | 0
09:00 pm | 09:15 pm | 0.998 | 0 | 0.778 | 0 | 0.606 | 0 | 1.096 | 0 | 1.179 | 0 | 0.462 | 0 | 0.772 | 0 | 0.493 | 0 | 0.639 | 0 | 0.459 | 0 | 0.721 | 0
09:15 pm | 09:30 pm | 0.938 | 0 | 0.968 | 0 | 0.621 | 0 | 1.093 | 0 | 1.183 | 0 | 0.455 | 0 | 0.624 | 0 | 0.556 | 0 | 0.639 | 0 | 0.433 | 0 | 1.002 | 0
09:30 pm | 09:45 pm | 0.889 | 0 | 0.942 | 0 | 0.538 | 0 | 1.06 | 0 | 1.178 | 0 | 0.657 | 0 | 0.643 | 0 | 0.667 | 0 | 1.027 | 0 | 0.862 | 0 | 1.251 | 0
09:45 pm | 10:00 pm | 0.843 | 0 | 0.847 | 0 | 0.514 | 0 | 1.069 | 0 | 1.158 | 0 | 0.679 | 0 | 0.655 | 0 | 0.698 | 0 | 1.087 | 0 | 0.921 | 0 | 1.239 | 0
10:00 pm | 10:15 pm | 0.846 | 0 | 0.823 | 0 | 0.497 | 0 | 0.982 | 0 | 1.119 | 0 | 0.691 | 0 | 0.639 | 0 | 0.699 | 0 | 1.051 | 0 | 0.898 | 0 | 1.188 | 0
10:15 pm | 10:30 pm | 0.852 | 0 | 0.736 | 0 | 0.469 | 0 | 0.918 | 0 | 1.081 | 0 | 0.679 | 0 | 0.626 | 0 | 0.687 | 0 | 1.054 | 0 | 0.916 | 0 | 1.115 | 0
10:30 pm | 10:45 pm | 0.825 | 0 | 0.742 | 0 | 0.468 | 0 | 0.916 | 0 | 1.045 | 0 | 0.681 | 0 | 0.62 | 0 | 0.664 | 0 | 1.036 | 0 | 0.897 | 0 | 1.132 | 0
10:45 pm | 11:00 pm | 0.823 | 0 | 0.618 | 0 | 0.448 | 0 | 0.939 | 0 | 1.024 | 0 | 0.691 | 0 | 0.627 | 0 | 0.66 | 0 | 1.054 | 0 | 0.895 | 0 | 1.095 | 0
11:00 pm | 11:15 pm | 0.824 | 0 | 0.583 | 0 | 0.438 | 0 | 0.972 | 0 | 1.035 | 0 | 0.705 | 0 | 0.62 | 0 | 0.656 | 0 | 1.046 | 0 | 0.893 | 0 | 1.099 | 0
11:15 pm | 11:30 pm | 0.801 | 0 | 0.612 | 0 | 0.412 | 0 | 0.913 | 0 | 1.006 | 0 | 0.688 | 0 | 0.618 | 0 | 0.643 | 0 | 1.086 | 0 | 0.894 | 0 | 1.078 | 0
11:30 pm | 11:45 pm | 0.913 | 0 | 0.508 | 0 | 0.425 | 0 | 0.913 | 0 | 1.006 | 0 | 0.684 | 0 | 0.601 | 0 | 0.626 | 0 | 1.041 | 0 | 0.873 | 0 | 1.09 | 0
11:45 pm | 12:00 am | 0.708 | 0 | 0.505 | 0 | 0.445 | 0 | 0.898 | 0 | 1.006 | 0 | 0.684 | 0 | 0.552 | 0 | 0.562 | 0 | 1.048 | 0 | 0.897 | 0 | 1.097 | 0
Consumption |  | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD
00:00:00 | 07:00:00
07:00:00 | 21:00:00
21:00:00 | 00:00:00
Total Consumption per Smart Meter
Consumption per System
7am - 9pm Consumption
[NAME] kWh/day (7am-9pm)
Night Usage (9pm-7am)
Exported
Production per System
Exported to Grid per Smart Meter
Exported to Grid per System
Exported to grid per Provider
Start Time | End Time | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export
12:00 am | 12:15 am | 1.143 | 0 | 1.184 | 0 | 1.188 | 0 | 1.32 | 0
12:15 am | 12:30 am | 1.134 | 0 | 1.158 | 0 | 1.18 | 0 | 1.27 | 0
12:30 am | 12:45 am | 1.113 | 0 | 1.156 | 0 | 1.2 | 0 | 1.256 | 0
12:45 am | 01:00 am | 1.1 | 0 | 1.171 | 0 | 1.216 | 0 | 1.236 | 0
01:00 am | 01:15 am | 1.021 | 0 | 1.165 | 0 | 1.211 | 0 | 1.221 | 0
01:15 am | 01:30 am | 1.076 | 0 | 1.167 | 0 | 1.192 | 0 | 1.241 | 0
01:30 am | 01:45 am | 1.065 | 0 | 1.152 | 0 | 1.177 | 0 | 1.266 | 0
01:45 am | 02:00 am | 1.045 | 0 | 1.137 | 0 | 1.153 | 0 | 1.318 | 0
02:00 am | 02:15 am | 1.084 | 0 | 1.118 | 0 | 1.164 | 0 | 1.239 | 0
02:15 am | 02:30 am | 1.092 | 0 | 1.138 | 0 | 1.161 | 0 | 1.223 | 0
02:30 am | 02:45 am | 1.073 | 0 | 1.129 | 0 | 1.159 | 0 | 1.167 | 0
02:45 am | 03:00 am | 1.069 | 0 | 1.099 | 0 | 1.159 | 0 | 1.183 | 0
03:00 am | 03:15 am | 1.086 | 0 | 1.085 | 0 | 1.158 | 0 | 1.182 | 0
03:15 am | 03:30 am | 1.051 | 0 | 1.086 | 0 | 1.155 | 0 | 1.178 | 0
03:30 am | 03:45 am | 1.038 | 0 | 1.078 | 0 | 1.162 | 0 | 1.179 | 0
03:45 am | 04:00 am | 1.031 | 0 | 1.087 | 0 | 1.163 | 0 | 1.171 | 0
04:00 am | 04:15 am | 0.986 | 0 | 1.059 | 0 | 1.152 | 0 | 1.156 | 0
04:15 am | 04:30 am | 1.03 | 0 | 1.057 | 0 | 1.152 | 0 | 1.155 | 0
04:30 am | 04:45 am | 1.029 | 0 | 1.053 | 0 | 1.174 | 0 | 1.157 | 0
04:45 am | 05:00 am | 1.026 | 0 | 1.057 | 0 | 1.183 | 0 | 1.153 | 0
05:00 am | 05:15 am | 1.013 | 0 | 1.06 | 0 | 1.166 | 0 | 1.153 | 0
05:15 am | 05:30 am | 0.975 | 0 | 1.083 | 0 | 1.144 | 0 | 1.151 | 0
05:30 am | 05:45 am | 1.01 | 0 | 1.045 | 0 | 1.141 | 0 | 1.151 | 0
05:45 am | 06:00 am | 1.01 | 0 | 1.085 | 0 | 1.111 | 0 | 1.141 | 0
06:00 am | 06:15 am | 0.992 | 0 | 1.081 | 0 | 1.099 | 0 | 1.129 | 0
06:15 am | 06:30 am | 1 | 0 | 1.082 | 0 | 1.128 | 0 | 1.123 | 0
06:30 am | 06:45 am | 0.459 | 0 | 0.495 | 0 | 0.575 | 0 | 0.577 | 0
06:45 am | 07:00 am | 0.45 | 0 | 0.544 | 0 | 0.549 | 0 | 0.548 | 0
07:00 am | 07:15 am | 0.56 | 0 | 0.513 | 0 | 0.512 | 0 | 0.55 | 0
07:15 am | 07:30 am | 0.471 | 0 | 0.421 | 0 | 0.544 | 0 | 0.523 | 0
07:30 am | 07:45 am | 0.443 | 0 | 0.42 | 0 | 0.509 | 0 | 0.544 | 0
07:45 am | 08:00 am | 0.289 | 0 | 0.376 | 0 | 0.433 | 0 | 0.548 | 0
08:00 am | 08:15 am | 0.276 | 0 | 0.281 | 0 | 0.37 | 0 | 0.546 | 0
08:15 am | 08:30 am | 0.192 | 0 | 0.255 | 0 | 0.295 | 0 | 0.557 | 0
08:30 am | 08:45 am | 0.105 | 0.061 | 0.136 | 0.019 | 0.207 | 0.001 | 0.592 | 0
08:45 am | 09:00 am | 0.03 | 0.105 | 0.121 | 0.076 | 0.252 | 0.004 | 0.522 | 0
09:00 am | 09:15 am | 0.007 | 0.171 | 0.006 | 0.114 | 0.229 | 0.019 | 0.493 | 0
09:15 am | 09:30 am | 0 | 0.286 | 0.007 | 0.318 | 0.085 | 0.079 | 0.444 | 0
09:30 am | 09:45 am | 0 | 0.421 | 0.022 | 0.259 | 0.052 | 0.125 | 0.412 | 0
09:45 am | 10:00 am | 0 | 0.497 | 0.036 | 0.239 | 0.093 | 0.123 | 0.38 | 0
10:00 am | 10:15 am | 0 | 0.611 | 0 | 0.752 | 0.016 | 0.411 | 0.304 | 0
10:15 am | 10:30 am | 0 | 0.688 | 0.008 | 0.66 | 0.06 | 0.616 | 0.175 | 0.027
10:30 am | 10:45 am | 0 | 0.916 | 0.001 | 0.966 | 0.009 | 0.664 | 0.003 | 0.098
10:45 am | 11:00 am | 0 | 1.068 | 0 | 1.214 | 0 | 1.102 | 0 | 0.238
11:00 am | 11:15 am | 0 | 1.13 | 0.028 | 0.912 | 0.033 | 0.682 | 0 | 0.374
11:15 am | 11:30 am | 0 | 1.265 | 0.015 | 1.057 | 0.312 | 0.153 | 0 | 0.483
11:30 am | 11:45 am | 0 | 1.347 | 0.045 | 1.135 | 0.021 | 0.639 | 0 | 0.345
11:45 am | 12:00 pm | 0 | 1.561 | 0.001 | 1.517 | 0 | 0.97 | 0 | 0.521
12:00 pm | 12:15 pm | 0.003 | 1.331 | 0 | 1.299 | 0.008 | 0.839 | 0 | 0.732
12:15 pm | 12:30 pm | 0.072 | 0.774 | 0 | 1.797 | 0.031 | 0.753 | 0 | 1.212
12:30 pm | 12:45 pm | 0 | 1.816 | 0.006 | 1.654 | 0.006 | 1.128 | 0 | 1.216
12:45 pm | 01:00 pm | 0.03 | 1.23 | 0 | 1.394 | 0.007 | 0.684 | 0 | 0.862
01:00 pm | 01:15 pm | 0 | 1.482 | 0 | 1.734 | 0.153 | 0.372 | 0 | 0.559
01:15 pm | 01:30 pm | 0.071 | 0.54 | 0.009 | 1.369 | 0.128 | 0.519 | 0 | 0.478
01:30 pm | 01:45 pm | 0.017 | 1.201 | 0.017 | 1.69 | 0.063 | 0.891 | 0 | 1.044
01:45 pm | 02:00 pm | 0.006 | 1.205 | 0.043 | 1.701 | 0.002 | 1.42 | 0 | 0.925
02:00 pm | 02:15 pm | 0.002 | 1.388 | 0.015 | 1.615 | 0.043 | 0.799 | 0.001 | 0.334
02:15 pm | 02:30 pm | 0.084 | 0.947 | 0.001 | 1.173 | 0.002 | 0.985 | 0 | 0.597
02:30 pm | 02:45 pm | 0.111 | 0.636 | 0.01 | 1.578 | 0 | 1.515 | 0 | 1.145
02:45 pm | 03:00 pm | 0.081 | 0.339 | 0.009 | 1.473 | 0 | 1.602 | 0 | 1.219
03:00 pm | 03:15 pm | 0 | 0.669 | 0 | 1.843 | 0.005 | 1.351 | 0.002 | 0.405
03:15 pm | 03:30 pm | 0.007 | 0.676 | 0.066 | 1.365 | 0.001 | 1.432 | 0.321 | 0
03:30 pm | 03:45 pm | 0.22 | 0.127 | 0 | 1.665 | 0.303 | 0.306 | 0.29 | 0.043
03:45 pm | 04:00 pm | 0.223 | 0.439 | 0.015 | 1.342 | 0.06 | 0.661 | 0.456 | 0
04:00 pm | 04:15 pm | 0.013 | 1.447 | 0.048 | 1.213 | 0.025 | 1.062 | 0.27 | 0.003
04:15 pm | 04:30 pm | 0 | 1.251 | 0.097 | 1.075 | 0.141 | 0.729 | 0.062 | 0.082
04:30 pm | 04:45 pm | 0 | 1.167 | 0.033 | 0.943 | 0.485 | 0 | 0.279 | 0
04:45 pm | 05:00 pm | 0.006 | 0.601 | 0 | 1.066 | 0.162 | 0.508 | 0.211 | 0.011
05:00 pm | 05:15 pm | 0 | 0.738 | 0.04 | 0.77 | 0.202 | 0.423 | 0.12 | 0.025
05:15 pm | 05:30 pm | 0 | 0.81 | 0 | 0.771 | 0.459 | 0.045 | 0.357 | 0
05:30 pm | 05:45 pm | 0 | 0.663 | 0 | 0.619 | 0.196 | 0.305 | 0.405 | 0
05:45 pm | 06:00 pm | 0 | 0.503 | 0 | 0.336 | 0.388 | 0.084 | 0.448 | 0
06:00 pm | 06:15 pm | 0.117 | 0.289 | 0.017 | 0.193 | 0.464 | 0.011 | 0.48 | 0
06:15 pm | 06:30 pm | 0.477 | 0.036 | 0.036 | 0.051 | 0.348 | 0 | 0.584 | 0
06:30 pm | 06:45 pm | 0.536 | 0 | 0.222 | 0.001 | 0.609 | 0 | 0.62 | 0
06:45 pm | 07:00 pm | 0.477 | 0 | 0.385 | 0.006 | 0.829 | 0 | 0.652 | 0
07:00 pm | 07:15 pm | 0.747 | 0 | 0.477 | 0 | 0.801 | 0 | 0.638 | 0
07:15 pm | 07:30 pm | 0.877 | 0 | 0.76 | 0 | 0.865 | 0 | 0.586 | 0
07:30 pm | 07:45 pm | 0.936 | 0 | 0.76 | 0 | 0.888 | 0 | 0.625 | 0
07:45 pm | 08:00 pm | 0.813 | 0 | 0.776 | 0 | 0.861 | 0 | 0.635 | 0
08:00 pm | 08:15 pm | 0.854 | 0 | 0.69 | 0 | 0.894 | 0 | 0.603 | 0
08:15 pm | 08:30 pm | 0.874 | 0 | 0.717 | 0 | 0.777 | 0 | 0.57 | 0
08:30 pm | 08:45 pm | 0.848 | 0 | 0.697 | 0 | 0.997 | 0 | 0.58 | 0
08:45 pm | 09:00 pm | 0.78 | 0 | 0.706 | 0 | 0.974 | 0 | 0.793 | 0
09:00 pm | 09:15 pm | 0.794 | 0 | 0.696 | 0 | 0.868 | 0 | 0.688 | 0
09:15 pm | 09:30 pm | 0.984 | 0 | 1.067 | 0 | 1.072 | 0 | 1.042 | 0
09:30 pm | 09:45 pm | 1.279 | 0 | 1.308 | 0 | 1.339 | 0 | 1.168 | 0
09:45 pm | 10:00 pm | 1.3 | 0 | 1.308 | 0 | 1.279 | 0 | 1.116 | 0
10:00 pm | 10:15 pm | 1.244 | 0 | 1.373 | 0 | 1.306 | 0 | 1.128 | 0
10:15 pm | 10:30 pm | 1.233 | 0 | 1.284 | 0 | 1.3 | 0 | 1.078 | 0
10:30 pm | 10:45 pm | 1.263 | 0 | 1.245 | 0 | 1.277 | 0 | 1.051 | 0
10:45 pm | 11:00 pm | 1.285 | 0 | 1.209 | 0 | 1.296 | 0 | 1.023 | 0
11:00 pm | 11:15 pm | 1.227 | 0 | 1.207 | 0 | 1.356 | 0 | 1.037 | 0
11:15 pm | 11:30 pm | 1.246 | 0 | 1.215 | 0 | 1.285 | 0 | 1.034 | 0
11:30 pm | 11:45 pm | 1.214 | 0 | 1.222 | 0 | 1.285 | 0 | 1.053 | 0
11:45 pm | 12:00 am | 1.186 | 0 | 1.183 | 0 | 1.283 | 0 | 1.044 | 0
Consumption |  | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD
00:00:00 | 07:00:00
07:00:00 | 21:00:00
21:00:00 | 00:00:00
Total Consumption per Smart Meter
Consumption per System
7am - 9pm Consumption
[NAME] kWh/day (7am-9pm)
Night Usage (9pm-7am)
Exported
Production per System
Exported to Grid per Smart Meter
Exported to Grid per System
Exported to grid per Provider
Start Time | End Time | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export
12:00 am | 12:15 am
12:15 am | 12:30 am
12:30 am | 12:45 am
12:45 am | 01:00 am
01:00 am | 01:15 am
01:15 am | 01:30 am
01:30 am | 01:45 am
01:45 am | 02:00 am
02:00 am | 02:15 am
02:15 am | 02:30 am
02:30 am | 02:45 am
02:45 am | 03:00 am
03:00 am | 03:15 am
03:15 am | 03:30 am
03:30 am | 03:45 am
03:45 am | 04:00 am
04:00 am | 04:15 am
04:15 am | 04:30 am
04:30 am | 04:45 am
04:45 am | 05:00 am
05:00 am | 05:15 am
05:15 am | 05:30 am
05:30 am | 05:45 am
05:45 am | 06:00 am
06:00 am | 06:15 am
06:15 am | 06:30 am
06:30 am | 06:45 am
06:45 am | 07:00 am
07:00 am | 07:15 am
07:15 am | 07:30 am
07:30 am | 07:45 am
07:45 am | 08:00 am
08:00 am | 08:15 am
08:15 am | 08:30 am
08:30 am | 08:45 am
08:45 am | 09:00 am
09:00 am | 09:15 am
09:15 am | 09:30 am
09:30 am | 09:45 am
09:45 am | 10:00 am
10:00 am | 10:15 am
10:15 am | 10:30 am
10:30 am | 10:45 am
10:45 am | 11:00 am
11:00 am | 11:15 am
11:15 am | 11:30 am
11:30 am | 11:45 am
11:45 am | 12:00 pm
12:00 pm | 12:15 pm
12:15 pm | 12:30 pm
12:30 pm | 12:45 pm
12:45 pm | 01:00 pm
01:00 pm | 01:15 pm
01:15 pm | 01:30 pm
01:30 pm | 01:45 pm
01:45 pm | 02:00 pm
02:00 pm | 02:15 pm
02:15 pm | 02:30 pm
02:30 pm | 02:45 pm
02:45 pm | 03:00 pm
03:00 pm | 03:15 pm
03:15 pm | 03:30 pm
03:30 pm | 03:45 pm
03:45 pm | 04:00 pm
04:00 pm | 04:15 pm
04:15 pm | 04:30 pm
04:30 pm | 04:45 pm
04:45 pm | 05:00 pm
05:00 pm | 05:15 pm
05:15 pm | 05:30 pm
05:30 pm | 05:45 pm
05:45 pm | 06:00 pm
06:00 pm | 06:15 pm
06:15 pm | 06:30 pm
06:30 pm | 06:45 pm
06:45 pm | 07:00 pm
07:00 pm | 07:15 pm
07:15 pm | 07:30 pm
07:30 pm | 07:45 pm
07:45 pm | 08:00 pm
08:00 pm | 08:15 pm
08:15 pm | 08:30 pm
08:30 pm | 08:45 pm
08:45 pm | 09:00 pm
09:00 pm | 09:15 pm
09:15 pm | 09:30 pm
09:30 pm | 09:45 pm
09:45 pm | 10:00 pm
10:00 pm | 10:15 pm
10:15 pm | 10:30 pm
10:30 pm | 10:45 pm
10:45 pm | 11:00 pm
11:00 pm | 11:15 pm
11:15 pm | 11:30 pm
11:30 pm | 11:45 pm
11:45 pm | 12:00 am
Consumption |  | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD
00:00:00 | 07:00:00
07:00:00 | 21:00:00
21:00:00 | 00:00:00
Consumption per Smart Meter
Consumption per System
7am - 9pm Consumption |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Charges kWh
[NAME] kWh/day (7am-9pm)
Night Usage (9pm-7am) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nights Free Energy Credit kWh
Exported
Production per System
Exported to Grid per Smart Meter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | kWh that you will be credited for
Exported to Grid per System
Exported to grid per Provider