This is where you might want to create an administrative id of "queryid" (or
something similar) with no authority, this will allow it to perform queries
and you won't have to worry about an id being in scripts with its password.

OK, I'll assume you have a Unix box somewhere that has access to the tsm
server.

#!/bin/ksh
dsmadmc -id=queryid -pass=querypass query actlog begindate=today-1
begintime=20:00 enddate=today endtime=now search=ANE4961I originator=client
>> client.transfer.data
exit

one can also pipe the information into mail... say to send misc info to
someone...
#!/bin/ksh
dsmadmc -id=queryid -pass=querypass q db f=d | mail -s db_info
someid AT somehost DOT com
exit

I can't really share many specifics because of the legality issues of
working for a private company but believe me, you can do a whole lot with
simple little shell scripts... and if you use the output of a "date" command
to say pull in the name of the day of the week... you can have info saved in
files for a weeks worth of time and automatically over write it (weekly)
ie. blah > $(date +%A%I%p)
puts the info into a file named Thursday09AM (or what ever hour it happens
to be) kind of a good way to dump volhist into to a remote box somewhere...

the getting it into a spread sheet would probably be a manual operation
still...
unless you did some web application to pull the info from the output file
and list it in some tabular fashion.

hope this helps...
Dwight