edwardzbrown
New Member
- Joined
- Jun 12, 2017
- Messages
- 20
Hello,
My power company exports my energy use by hour. I want to arrange years worth of data by day with all the hours of a day to the right of that day's row. That way I can compare energy use by hour and even by day of the week. What would be the best way to go about organizing this?
This is what I want:
<colgroup><col><col><col span="8"></colgroup><tbody>
</tbody>
This is what I have:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
My power company exports my energy use by hour. I want to arrange years worth of data by day with all the hours of a day to the right of that day's row. That way I can compare energy use by hour and even by day of the week. What would be the best way to go about organizing this?
This is what I want:
Weekday | Date | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM |
Friday | 1/5/2018 | 0.87 | 1.18 | 0.91 | 0.67 | 0.71 | 1.07 | 0.62 | 4.81 |
Saturday | 1/6/2018 | 0.69 | 0.64 | 1.02 | 0.9 | 0.56 | 0.6 | 1.29 | 0.99 |
<colgroup><col><col><col span="8"></colgroup><tbody>
</tbody>
This is what I have:
1/6/2018 | 11:00 | 0.61 |
1/6/2018 | 12:00 | 1.5 |
1/6/2018 | 13:00 | 3.94 |
1/6/2018 | 14:00 | 6.48 |
1/6/2018 | 15:00 | 5.11 |
1/6/2018 | 16:00 | 5.21 |
1/6/2018 | 17:00 | 3.06 |
1/6/2018 | 18:00 | 7.26 |
1/6/2018 | 19:00 | 2.48 |
1/6/2018 | 20:00 | 1.3 |
1/6/2018 | 21:00 | 0.94 |
1/6/2018 | 22:00 | 1.2 |
1/6/2018 | 23:00 | 0.88 |
1/7/2018 | 0:00 | 0.65 |
1/7/2018 | 1:00 | 1.93 |
1/7/2018 | 2:00 | 5.01 |
1/7/2018 | 3:00 | 0.82 |
1/7/2018 | 4:00 | 0.75 |
1/7/2018 | 5:00 | 0.73 |
1/7/2018 | 6:00 | 1.13 |
1/7/2018 | 7:00 | 0.65 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>