DEMAND SIDE MANAGEMENT

RENEWABLE ENERGY

SMART GRID

Question

how to extract previous week and month number of same hour?

I had load data of one year, half houly data of load (1*17520), I want to add a column having load data of previous week (same d...

ungefär ett år ago | 1 answer | 1

Question

filter data based on row value(text) ?

I had data similar to shown in image1 and want to exteract data for all data for first column for all rows like image2, image3.....

ungefär ett år ago | 0 answers | 0

Question

how to reduce error in ANN ? MAPE error

I am using 3 year load data of electricity and using NARX model for load prediciton for day ahead, one month , three month data ...

ungefär ett år ago | 0 answers | 0

Question

convert matrix data to cell array data

I had matrix data of size A(5*1536) and now i want to convert it into cell array in the form of B(1*1536) cell and each cell hav...

ungefär ett år ago | 1 answer | 0

Question

summation with for loop for all rows in another column

I had following data as attached h = 1; I_all size(3154*20) So hmax = 20; I1 = I_all(1,1) for first row and I1=I_all(2,1) ...

mer än ett år ago | 1 answer | 0

Question

how to model an electric vehicle and its charge discharge

Want to model electric vehicle (30kW battery capacity) and charge by 1C/2C/3C rates with 3kW/5kW/10kW charger and consumption 15...

mer än ett år ago | 3 answers | 1

Question

find area of curve and update it with given conditions?

I had a load curve (30 min interval 48 values) , and two different levels of curve(red, black horizontal line in pic), Now I wan...

mer än ett år ago | 1 answer | 0

Question

for loop execution error

i had a for loop like this for j=1:100 for i=1:48 F{j,1}(i,1)= some equations; end end this is running wel...

nästan 2 år ago | 1 answer | 0

Question

find maximum of data with some conditions

I had one year load data of a transformer hourly time interval, so load(365*24, 24) matrix. I want to find out the maximum of e...

nästan 2 år ago | 1 answer | 0

Question

how to generate time series data?

I calculated vector D(48*1) values for one day 30 min interval in .m file program. Now I want to use this D vector into simulink...

nästan 2 år ago | 0 answers | 0

Question

simple integration calculation to find the area ?

I had a 30 min time step vector T(48*1) values T=[30 60 90 ........1440], and another vector V(48*1) having some values. I want ...

nästan 2 år ago | 2 answers | 0

Question

large excel data into multiple excel file using xlswrite ?

I had excel sheet data havaing 1048576 rows and I want to split it into 12 excel files and save data in 12 different excel files...

nästan 2 år ago | 2 answers | 0

Question

nested if loop in for loop with different conditions?

this following code is OK n = 0.8; y = 1.6; % winding exponent y=1.6 K11 = 1; K21 = 1; K22 = 2; T0 = 180; Tw = 4; % H =...

nästan 2 år ago | 0 answers | 0

Question

Find area under and above the curve with horizontal line and its min/max values in a given range of line ?

I want to do following tasks, First generate a time series load data between 550-1000 for one day 30 min interval, so load(48*1...

nästan 2 år ago | 0 answers | 0

Question

Area under the curve with conditions?

I want to do following tasks, First generate a time series load data between 550-1000 for one day 30 min interval, so is load(4...

nästan 2 år ago | 1 answer | 0

Question

linear optimization without any constraint

I had following code: % data a = 30; b = 150; D = (b-a).*rand(100,1) + a; % threshold Th=110; Th=repmat(110,100,1); % di...

nästan 2 år ago | 0 answers | 0

Question

linear optimization using optimization toolbox and minimize array sum

I had dataset of load for 7 days, 1min time interval and I want to put a threshold value. Now claculate a difference D=(load-Thr...

nästan 2 år ago | 2 answers | 0

Question

Create a uniform empty cells between 2 data in excel file?

I had a excel file having data at 30min interval for a day , size (48*1). Now I want to create it at 1min time interval with sam...

mer än 2 år ago | 1 answer | 0

Question

How to fit same variance of data to another data ?

I have two data sets of energy consumption for full day with 30min(data size 48*1) and 1 min(data size 1440*1) time interval of...

mer än 2 år ago | 1 answer | 0

Question

remove weekends and holidays data from excel file

I had excel file ABC.xlsx, in which sheet A having data from date 01-04-2017 to 31-12-2018 and the sheet2 having the list dates ...

mer än 2 år ago | 1 answer | 0

Question

find the average of a vector with specific condition ?

I had A vector A=[1 0 0 2 3 2 3 5 0 0 0 0 1 2 1 0 0 0 0 3 4 0 0 0 0 0 0 1 2 3 2 0 0 0 0 2 0 0] like this. Now I want a ...

nästan 3 år ago | 1 answer | 0

Question

count number with continuous numbers of 1's ?

I had a matrix A=[0 0 1 1 1 1 0 0 0 1 1 0 0 1 0 0 1 0 0 0 1 1 1 0 0] like this , now I want a matrix B in which B(3)=1,next B(10...

nästan 3 år ago | 1 answer | 0

Question

create a array base on specific condition ?

I had a array like this A=[0 0 0 10 0 0 0 0 8 0 0 5 0 0 0 3 0 2 0 0 0 1 0 0 0]; and now I want to create a array B like ...

nästan 3 år ago | 2 answers | 0

Question

sum of array elements with specific condition?

lets say I had A=[1 0 1 1 0 1 0 1 0 0 1 1 1 1]; then I want B(1)=sum of all A elements, B(2)= sum all elements of A from A(2) ex...

nästan 3 år ago | 2 answers | 0

Question

Battery duty cycle at each instant ?

I have battery voltage Vi at each time instant(predefined before in simulink) and taking the reference voltage Vo (between 718-7...

nästan 3 år ago | 1 answer | 0

Question

convert date time to number ?

I had excel sheet having date format dd/mm/yyyy hh:mm:ss , So now I want to convert each value into number format. How can I do ...

nästan 3 år ago | 1 answer | 0

Question

calculate data based on previous values and replace it at negative and zeros values

there is different data in the column in excel (REACTIVE_Y_PH), which has some negative and zeros values also, these values shou...

nästan 3 år ago | 1 answer | 0

Question

Data interpolation problem for excel file

I had a excel file having 500 rows and 3 columns. In first column the data should be within the range of 200-250 but there are s...

nästan 3 år ago | 1 answer | 0

Question

move a row from a cell to another cell

I had a cell array Q like this Q=cell(5,1); Q{1,:}=[1 2 3 4;11 22 33 4;11 2 33 4]; Q{2,:}=[1 11 11 2;22 2 32 33]; ...

mer än 3 år ago | 2 answers | 0

Question

nested for loop with different variable name

S is cell array of size 994*1 and each cell size in it is 24*24, price3(size 1*24), Bita(size 1*24), CONS_T3(size 1*24), I want...

mer än 3 år ago | 1 answer | 0