System.out.println("Passed Check 4");
c++;
workBook.setText(r,c,tempName);
r++;
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Rev Pax per Dept");
workBook.setText(r,c,"Rev Pax per Dept");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Avg Conx Pax");
workBook.setText(r,c,"Avg Conx Pax");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Avg Local Pax");
workBook.setText(r,c,"Avg Local Pax");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Total Depts");
workBook.setText(r,c,"Total Depts");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Depts per Day");
workBook.setText(r,c,"Depts per Day");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Total Revenue");
workBook.setText(r,c,"Total Revenue");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Revenue per Dept");
workBook.setText(r,c,"Revenue per Dept");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Yield");
workBook.setText(r,c,"Yield");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"RASM");
workBook.setText(r,c,"RASM");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Avg Fare");
workBook.setText(r,c,"Avg Fare");
r++;
}
for(int y=0;y<7;y++)
{
if(y==0)
workBook.setText(r,c+1,"Load Factor");
workBook.setText(r,c,"Load Factor");
r++;
}
workBook.setColWidthAutoSize(c,true);
workBook.setColWidthAutoSize(c+1,true);
System.out.println("Passed Check 5");