[RC5] Another request

Blain Nelson blainn13 at earthlink.net
Mon Jan 8 12:35:04 EST 2001

Niels Teglsbo wrote:
> It's probably possible to make an average function in Excel, using some
> scripting, that will take care of the missing days.

What scripting?  Excel can think in dates, versus just counting the
number of entries (at least Quatro Pro can, and I'm sure the spreadsheet
of the anti-Christ would be able to do such a simple thing) so you can
have it just measure the days from the first (or first applicable) to
current date (or target date) and divide the total blocks by that time.

> Another solution would be to write some Perl script or whatever that
> would insert the missing days with zeros.

No need for zeroes either.  Just use date-based calculation.  *nix time
works just fine.

Take care,

Wanted:  Blain Nelson   aka   blain at blainn.cc   aka   Rahab the Tyrant 
aka  anon-20630 at anon.twwells.com   aka   My Kids' Dad  aka  not-Kristi
Subject is considered armed and legged.  Persecutors will be violated. 
http://www.blainn.cc/      ICQ:19857966       My hat says "It's Irony"
To unsubscribe, send 'unsubscribe rc5' to majordomo at lists.distributed.net
rc5-digest subscribers replace rc5 with rc5-digest

More information about the rc5 mailing list