#this isn't really code, just my thoughts
#!/usr/bin/perl -w

use strict;
use FindBin;
use Data::Dumper;
use DBI;
use Storable qw(nstore retrieve);

#something that looks for the scratch directory in the current directory
#something that looks for any files matching the pattern thing1_(ABC-def1g234567).foo__bar_ar
#something that cycles through each file one at a time, pulling all of the rows for [5] and pushing them in order into an excel file matching the report format