How do I create a load duration curve for a wind turbine from a timeseries?

I modelled a WT system in Simulink, and now I want to model a load duration curve similar to the picture below:

The data is a timeseries extracted from Simulink. Can someone help me with this problem? To make it easier for you guys I added an excel file with a similar timeseries and a line of code that extracts the data.

Windspeed_hourly_mean = xlsread('Windspeed_hourly.xlsx','B2:B8763');

[dpb]

The file makes no sense and if whatever is in column B is the mean hourly windspeed, that's insufficient information from which to deduce power.

The first column looks like a sequence from 1:300-something, the second is a set of small integers the third is some floating point number but no idea what.

[Hans Wagener]

I understand the confusion. I already have a time series for the wind power. However, the wind power time series is exported from a simulink model. I added this windspeed time series so it would be easier for you to write an example code. In other words, just assume that windspeed = windpower. Don't worry about the other columns in the excel file.

Answer 1

[Nehemiae]

Hello,

To plot the timeseries data of windspeed, the “plot” function can be used. Since the exported data contains the windspeed for every hour in the year, it can be simply plot in the Y-axis, with the X-axis being the vector of all hours in the year. If you have data across multiple years, then take the average windspeed across all years and use the same commands below, but on the average data. The similar workflow can be done on your wind power data.

Windspeed_hourly_mean = readtable('Windspeed_hourly.xlsx', 'Range', 'B3:B8762'); 
plot(1 : length(Windspeed_hourly_mean.Var1), Windspeed_hourly_mean.Var1, 'LineStyle', '-', 'LineWidth', 3); 
title('Predicted Power/Duration Graph, Vesta 1650kW, North Sea'); 
xlabel('Hours / year'); 
ylabel('Power (kW)'); 

The documentation on the “plot” function (https://www.mathworks.com/help/matlab/ref/plot.html) can be helpful in this regard.