An interesting problem

[Paul Orrock]

Paul Orrock wrote:

> It works but it is incredibly slow, like over a hour for 650,000 ranges 
> on a P4. I'm sure the Spreadsheet::Perl range sum calculation is taking 
> the time so I'll rip it out and write one myself. For the attached sheet 
> my code makes AH34 to AP32 the most positive range at 97.57.

Sorry mistype, it's been pointed out that I meant AP52 not 32.

regards,

Paul