Project - Data Handling and Interpolation
%Data handling and interpolation of data
%Read measurement datan from excel sheet
data = xlsread("VI.xlsx", "Sheet1");
volt = data(:,1);
current = data(:,2);
%define the interpolated range
volt_q = -17.3:0.1:0.9;
%perform interpolation for the defined range
current_q = interp1(volt,current,volt_q);
%plot the interpolated data and compare with measurement data
figure()
plot(volt, current,'--'); hold on;grid;
plot(volt_q,current_q);
title('Interpolation of measured Data');
xlabel('Voltage (V)');
ylabel('Current (A)');
legend('measured data','Interpolated data','Location','east');
hold off;
%Read voltage from the excel sheet
VV = xlsread("VI.xlsx", "Sheet2");
%Interpolate the missing current data corresponds to the voltage VV and
%store to text file
fid = fopen('interpolate.txt','w');
IV = interp1(volt,current,VV);
fprintf(fid,'%0.3d ',IV);
fclose(fid);