close all; clear all; clc
% [arrD_I,txt1,arrD_I1] = xlsread('data1.xlsx',1,'E2:E306')
% [leaveD_I,txt2,leaveD_I1] = xlsread('data1.xlsx',1,'J2:J306')
% [aGateD_I,txt3,aGateD_I1] = xlsread('data1.xlsx',2,'D2:D70')
% [lGateD_I,txt4,lGateD_I1] = xlsread('data1.xlsx',2,'E2:E70')
% [GateType,txt5,GateType1] = xlsread('data1.xlsx',2,'F2:F70')
% [PlaneType,txt6,PlaneType1] = xlsread('data1.xlsx',1,'F2:F306')
% trueVal = zeros(305,69)
% for i=1:305
% for j=1:69
% if arrD_I(i) + aGateD_I(j) ~= 1
% A = 1
% else A = 0
% end
% if leaveD_I(i) + lGateD_I(j) ~= 1
% B = 1
% else B = 0
% end
% if PlaneType(i) ~= GateType(j)
% C = 0
% else C = 1
% end
%
% trueVal(i,j) = A*B*C
% end
% end
% 变量说明：
% （sheet1）： record：飞机转场记录号 A1：飞机到达航班 L1：飞机出发航班 AT1：到达日期 LT1：出发日期
% （sheet3)： A2：飞机到达航班 L2：飞机出发航班 ARecd：到达航班转场号 LRecd：出发航班转场号 AT2：到达日期 LT2：出发日期
[r,txt1,record] = xlsread('data1.xlsx',1,'R2:R306')
[a1,txt2,A1] = xlsread('data1.xlsx',1,'D2:D306')
[l1,txt3,L1] = xlsread('data1.xlsx',1,'I2:I306')
[a2,txt4,A2] = xlsread('data1.xlsx',3,'C2:C1733')
[l2,txt5,L2] = xlsread('data1.xlsx',3,'E2:E1733')
[at1,txt6,AT1] = xlsread('data1.xlsx',1,'B2:B306')
[lt1,txt7,LT1] = xlsread('data1.xlsx',1,'G2:G306')
[at2,txt4,AT2] = xlsread('data1.xlsx',3,'D2:D1733')
[lt2,txt5,LT2] = xlsread('data1.xlsx',3,'F2:F1733')
ARecd = cell(1732,1)
LRecd = cell(1732,1)
for i=1:1732
for j=1:305
if strcmp(A2(i),A1(j)) & strcmp(AT2(i),AT1(j))
ARecd(i)=record(j)
end
if strcmp(L2(i),L1(j)) & strcmp(LT2(i),LT1(j))
LRecd(i)=record(j)
end
end
end
xlswrite('data1.xlsx',ARecd,3,'G2:G1733')
xlswrite('data1.xlsx',LRecd,3,'H2:H1733')
