our %worksheet;

#header
foreach my $criterion (@criteria) {
  $reportPath = "$report_loc/$criterion.xls";
  $reportHash{$criterion}{"all"}{"reportPath"} = $reportPath;
  local *REPORT_HANDLE;
  if (! open(REPORT_HANDLE, ">$reportPath")) {
    abort("Couldn't open $reportPath: $!");
  }
	binmode REPORT_HANDLE; # Always do this regardless of whether the platform requires it.

	$reportPath  = Spreadsheet::WriteExcel->new(\*REPORT_HANDLE);
	$worksheet{$criterion}   = $reportPath->add_worksheet($criterion);
	&outputHeader(*REPORT_HANDLE,$reportPath,"all",$criterion,$worksheet{$criterion});

	  $reportHash{$criterion}{"all"}{"reportHandle"} = *REPORT_HANDLE;

	  $reportHash{$criterion}{"all"}{"total"} = 0;

	foreach my $group (@groups) {
    $reportPath = "$report_loc_ts_groups/$group/$group" . "_" . "$criterion.xls";
    $reportHash{$criterion}{$group}{"reportPath"} = $reportPath;
    local *REPORT_HANDLE;
    if (! open(REPORT_HANDLE, ">$reportPath")) {
      abort("Couldn't open $reportPath: $!");
    }
	binmode REPORT_HANDLE; # Always do this regardless of whether the platform requires it.

		my $reportPath  = Spreadsheet::WriteExcel->new(\*REPORT_HANDLE);
		$worksheet{$group}   = $reportPath->add_worksheet($group); 
		&outputHeader(*REPORT_HANDLE,$reportPath,$group,$criterion,$worksheet{$group});
  
		$reportHash{$group}{$criterion}{$worksheet{$criterion}}{"reportHandle"} = *REPORT_HANDLE;
	  
		$reportHash{$group}{$criterion}{$worksheet{$criterion}}{"total"} = 0;
	}
}


# Print totals and close files!
foreach my $criterion (@criteria) {
(line 229)  wrapUp($reportHash{"all"}{$criterion}{$worksheet{$criterion}}{"reportHandle"},$reportHash{"all"}{$criterion}{$worksheet{$criterion}}{"total"});

  foreach my $group (@groups) {
    wrapUp($reportHash{$group}{$criterion}{$worksheet{$group}}{"reportHandle"},$reportHash{$group}{$criterion}{$worksheet{$group}}{"total"});

  } # End of foreach my $group (@groups) {

} # End of foreach my $criterion (@criteria) {

exit;


sub outputHeader {
  my $reportHandle = $_[0];
  my $reportPath = $_[1];
  my $group = $_[2];
  my $criterion = $_[3];
  my $worksheet = $_[4];

	my ($x,$y)=(0,0);
	
  my $groupOut = "";
  if ($groupOut ne "all") {
    $groupOut = "$group - ";
  } 
  
 my $criterionOut = "Files expire within current month ($current_y-$current_mth)";

 if ($criterion eq $criteria[1]) {
    $criterionOut = "Deleted (expired) Files";
  }
  elsif ($criterion eq $criteria[2]) {
    $criterionOut = "Files found with invalid expiry_date";
  }

#$worksheet->write($y++, $x, "$groupOut$criterionOut"				 , $format{bold}); # write_string()
$worksheet->write($y++, $x, "$groupOut$criterionOut"								); # write_string()
$worksheet->write($y++, $x, "Date Run: ".localtime().""								); # write_string()
$worksheet->write($y++, $x,															); # write_blank()
$worksheet->write($y++, $x, "Criteria:  today's date   : $tod_date"					); # write_string()
$worksheet->write($y++, $x, "           time interval  : on or before today's date"	); # write_string()

if ($group ne "all") {
	$worksheet->write($y++, $x, "           teamsite group : $group"					); # write_string()
}

$worksheet->write($y++, $x, "           workarea       : \$area"						); # write_string()
$worksheet->write($y++, $x, "           directories    : "							); # write_string()

$worksheet->write($y++, $x,															); # write_blank()
$worksheet->write($y++, $x,															); # write_blank()

$worksheet->write($y++, $x, uc($groupOut.$criterionOut)								); # write_string()
$worksheet->write($y++, $x,															); # write_blank()
  
	# Simple text
	$worksheet->write($y++, $x, "Files");
} # End of sub outputHeader {



sub wrapUp {
  my $reportHandle = $_[0];
  my $reportPath = $_[1];
  my $group = $_[2];
  my $criterion = $_[3];
  my $worksheet = $_[4];
  my $total = $_[5];

  my ($x,$y) = (0,16);

(line 314)	$worksheet->write($y++, $x, "total"); 
	close($reportHandle);
} # End of sub wrapUp {