. /u/hsim/other/fax.data/scripts/setvars
cd $TMPDIR

# get what I need from db
  # remove comments
sed "/^#/d" $FAXDB |
  # remove links
sed "/<linked/d" > $$0
  # get file names
cut -c$FN_COLS $$0 > $$fn
  # get usage stats
cut -c$U4_0195_COLS $$0 > $$1
cut -c$U4_0295_COLS $$0 > $$2
cut -c$U4_0395_COLS $$0 > $$3
paste -d "!" $$fn $$3 $$2 $$1 |
# sed "/^ *[^ ][^ ]* *$/d" |
#sed "/^ *[^ ]* *$/d" |
sed "/^ [^ ]*[^0-9]*$/d" |
sort -t! -r +1 +1 |
sed "s/!/  /g" > $$0

# Calculate totals
sum1=0
sum2=0
sum3=0
for number in `cat $$1`
do
   sum1=`expr $sum1 + $number`
done
for number in `cat $$2`
do
   sum2=`expr $sum2 + $number`
done
for number in `cat $$3`
do
   sum3=`expr $sum3 + $number`
done
rm subhead.usage
echo " (Total)                   $sum3    $sum2    $sum1" > subhead.usage
echo " ----------------------- ------  ------  ------" >> subhead.usage


cat $EXECDIR/header.usage subhead.usage $$0 > $$99
cat $EXECDIR/header.usage.html subhead.usage $$0 $EXECDIR/footer.usage.html> $$100

vi $$99
echo "If usage.report should NOT be saved, press Ctrl-C."
echo "If usage.report SHOULD be saved (overwriting past version), press Enter."
read VAR
mv $$99 $DBDIR/usage.report
mv $$100 $DBDIR/html/usage.report
rm $$*