%script for reading and plotting the excel results

%results=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls',
%'sheet1','b7:bf35');


%Extracting results from the excel worksheet:
reflux=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls','sheet1','b7:b35');
heatduty=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls','sheet1','as7:as35');
prodstreamD=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls','sheet1','at7:aw35');
prodstreamS1=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls','sheet1','ax7:ba35');
prodstreamS2=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls','sheet1','bb7:be35');
prodstreamB=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls','sheet1','bf7:bi35');
prodstream_frac_sum=xlsread('M:\Diplom\kaibel_test_results_working_prefrac_split.xls','sheet1','bu7:bu35');

scale=0;

if scale==1;
    heatduty = heatduty./1e6;
end
    

figure
hold on;
plot(reflux,heatduty,'b'),xlabel('Reflux (L/D)'),ylabel('Heat duty ( V ) [Watt]');
%plot(reflux,prodstreamD,'.b');
%plot(reflux,prodstreamS1,'.bl');
%plot(reflux,prodstreamS2,'.g');
%plot(reflux,prodstreamB,'.r');
%plot(reflux,prodstream_frac_sum,'b'), xlabel('Reflux (L/D)'), ylabel('Sum x');%of product components in respective product streams'); 
hold off;


