clear all;
clc;
%% 导入excel文件
niuju=xlsread('E:\研二\2021.8\8.27\Torque_throttle.xls','B2:L18');
jieqimen=xlsread('E:\研二\2021.8\8.27\Torque_throttle.xls','B1:L1');
zhuansu=xlsread('E:\研二\2021.8\8.27\Torque_throttle.xls','A2:A18');
%%
thr=0;
for i=1:11
Torque(:,i)=niuju(:,i);
speed(:,i)=zhuansu;
Throttle(:,i)=ones(length(zhuansu),1)*thr;
thr=thr+0.1;
end
%合并
To=Torque(:,1)';
s=speed(:,1)';
Th=Throttle(:,1)';
for i=2:11
To=[To,Torque(:,i)'];
Th=[Th,Throttle(:,i)'];
s=[s,speed(:,i)'];
end
F=scatteredInterpolant(To',s',Th');
Tu=0:10:705;
su=400:100:3150;
table=zeros(length(Tu),length(su));
for i=1:length(Tu)
for j=1:length(su)
table(i,j)=F(Tu(i),su(j));
end
end