MATLAB: How to calculate 8760 data just in one process

i need urgent help

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.

Best Answer

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

Related Solutions

MATLAB: 5 equations with 5 unknowns

Run this and check if the equations are those that should be...

clearvars 
syms  Vmp  Voc  Isc  mp  k  q  T Rp0 Rs0 Imp
syms I0 IL n Rs Rp 
eq1 =  Rp==Voc/(IL-I0*(exp(q/(n*k*T)*Voc)-1)) 
eq2 =  Isc==IL-I0*(exp(q/(n*k*T)*Rs*Isc)-1)-Rs*Isc/Rp
eq3 =  Imp==IL-I0*(exp(q/(n*k*T)*(Vmp+Imp*Rs))-1)-(Vmp+Imp*Rs)/Rp
eq4 =  Rs0==-(q/(n*k*T)*I0*exp(q/(n*k*T)*Voc)+1/Rs)/(1+Rs*(q/(n*k*T)*I0*exp(q/(n*k*T)*Voc)+1/Rs))
eq5 =  Rp0==-(q/(n*k*T)*I0*exp(q/(n*k*T)*Rs*Isc)+1/Rs)/(1+Rs*(q/(n*k*T)*I0*exp(q/(n*k*T)*Rs*Isc)+1/Rs))
Vmp=0.57
Voc=0.66
Isc=0.0067  
Imp=0.0062
k=1.38e-23
q=1.6e-19
T=300
Rp0=-0.0032
Rs0=-0.1535
eq1=subs(eq1); eq2=subs(eq2); eq3=subs(eq3); eq4=subs(eq4); eq5=subs(eq5);
[I0,IL,n,Rs,Rp]=vpasolve( [eq1, eq2, eq3, eq4, eq5], [I0,IL,n,Rs,Rp])

I replaced solve by vpasolve and a I filled in two multiplication signs on equations 4 and 5

You will get these results:

MATLAB: How do you import a .log file and put the information into various columns with headers

>> [~,t]=xlsread('shem.csv');  % about the most easiest way to read csv with mixed data
>> t=t(2:end,:).';             % get rid of header line; transpose to column orientation
>> t(1,:)=strrep(t(1,:),'$','');  % turn names into allowable table names
>> cell2table(t(2:end,:),'VariableNames',t(1,:))  % and make a table
Error using cell2table (line 57)
Duplicate variable name: 'GPGSV'. 
>>

OOOpsies!!! There are multiple columns with same name; can't turn into a table directly using those as names.

>> cell2table(t)  % just make a table with default column names, then...
ans = 
      t1         t2         t3          t4         t5         t6         t7         t8         t9         t10        t11        t12  
    _______    _______    _______    ________    _______    _______    _______    _______    _______    _______    _______    _______
    'GPRMC'    'GPRMB'    'GPGGA'    'GPGSA'     'GPGSV'    'GPGSV'    'GPGSV'    'GPGLL'    'GPBOD'    'GPVTG'    'HCHDG'    'GPRTE'
    ''         'A'        ''         'A'         ''         ''         ''         ''         ''         ''         ''         ''     
    'A'        ''         ''         ''          ''         ''         ''         'N'        'T'        'T'        ''         ''     
    ''         ''         'N'        ''          ''         ''         ''         ''         ''         ''         ''         'c'    
    'N'        ''         ''         ''          ''         ''         ''         'W'        'M'        'M'        ''         '*37'  
    ''         ''         'W'        ''          ''         ''         ''         ''         ''         ''         'W*33'     ''     
    'W'        ''         ''         ''          ''         ''         ''         'A'        '*47'      'N'        ''         ''     
    ''         ''         ''         ''          ''         ''         ''         'A*5D'     ''         ''         ''         ''     
    ''         ''         ''         ''          ''         ''         ''         ''         ''         'K'        ''         ''     
    ''         ''         ''         ''          ''         ''         ''         ''         ''         'A*2A'     ''         ''     
    ''         ''         'M'        ''          ''         ''         ''         ''         ''         ''         ''         ''     
    'W'        ''         ''         ''          ''         ''         ''         ''         ''         ''         ''         ''     
    'A*13'     ''         'M'        ''          ''         ''         ''         ''         ''         ''         ''         ''     
    ''         'V'        ''         ''          ''         ''         ''         ''         ''         ''         ''         ''     
    ''         'A*1C'     '*62'      ''          ''         ''         ''         ''         ''         ''         ''         ''     
    ''         ''         ''         ''          ''         ''         ''         ''         ''         ''         ''         ''     
    ''         ''         ''         ''          ''         ''         ''         ''         ''         ''         ''         ''     
    ''         ''         ''         '0.8*35'    ''         ''         ''         ''         ''         ''         ''         ''     
    ''         ''         ''         ''          ''         ''         ''         ''         ''         ''         ''         ''     
    ''         ''         ''         ''          '26*70'    '34*77'    '41*74'    ''         ''         ''         ''         ''     
>>

You'll have to decide what to do about the names depending on what need to do with the data; there's also a question as to what the stars mean in the data fields themselves as far as interpretation, but there's the data in an addressable format.

Best Answer

Related Solutions

MATLAB: 5 equations with 5 unknowns

MATLAB: How do you import a .log file and put the information into various columns with headers

Related Question