My inclination would be to print the whole thing out and munge it with a Perl script. Then import it back into Excel for the graphing.
Doing the monthly totals in Perl would be trivial; doing the weeklies might be simpler if you convert the dates into Unix time_t (seconds since 1970-01-01), which Perl cn do pretty easliy.
no subject
Date: 2005-03-23 04:04 am (UTC)Doing the monthly totals in Perl would be trivial; doing the weeklies might be simpler if you convert the dates into Unix time_t (seconds since 1970-01-01), which Perl cn do pretty easliy.