清空筛选条件
清空筛选条件

Summation for every hour from a timetable

1 次查看（过去 30 天）
Dora de Jong
Dora de Jong 2021-9-28
评论： Dora de Jong 2021-9-28
This is a part of the timetable I'am working with.
I want to know for every hour the sum of the values, for that hour, which are located in colum 3.
So for the first hour ( Date(1:6) ) I want to know the Energy_kwh sommation from 1 to 6 (Sum(Energy_kwh(1:6))
for the second hour ( Date(7:12) ) I want to know the Energy_kwh sommation from 7 to 12 (Sum(Energy_kwh(7:12))
....
The time stamps are not equal, this make it difficult.
Who has an idea for this problem?

请先登录，再回答此问题。

采纳的回答

Steven Lord
Steven Lord 2021-9-28
retime your timetable, either using the "Retime Timetable" Live Editor Task (see the Aggregate Data section of the example, you'd need to change the time step and the general rule) or the retime function (adapt the Aggregate Timetable Data and Calculate Mean Values example.)
  1 个评论
Dora de Jong
Dora de Jong 2021-9-28
Thank you!
I used the following:
TT2 = retime(Tilted_sailing.solar,'hourly','sum');
And it works perfectly.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Timetables 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by