How to calculate 8760 data just in one process?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Mohammad Sulaiman Stanekzai
am 26 Feb. 2019
Kommentiert: Mohammad Sulaiman Stanekzai
am 27 Feb. 2019
Hello dear friends. Hope you all fine. I use Matlab for my thesis and i need help. I have Excel file that have 8760 different number in a column. I have to put each of this number ın a same formula but its difficult to put each number and have to repeat the process 8760 time.
Help me how to enter this excle file and how to code just one process instead of 8760 time process in matlab.
Thanks in advance.
2 Kommentare
Akzeptierte Antwort
Stephan
am 26 Feb. 2019
Hi,
this is easy:
1) Use xlsread to import the data to Matlab:
E = xlsread('PV.xlsx');
2) Define your constant values - for example:
I_ref_sc = 10;
E_ref = 1000;
mu_I_sc = 0.5;
T = 22.6;
T_ref = 20;
3) Write an anonymus function which is vectorized:
I_sc = @(E) I_ref_sc.*E./E_ref + mu_I_sc*(T-T_ref);
4. Calculate the result:
result = I_sc(E);
Thats all - the result is as big as E - in this case 8760x1
Best regards
Stephan
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Get Started with MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!