Still would like to see some test data with expected results.
This sounds very similar to a problem I worked out not too long ago. And for that I had a pretty fast solution. I'd just prefer to get it right the first time.
Waiting for my connecting flight to Port Moresby in Brisbane at the moment. I'll check back later.
Thanks bud, I will try to get some test data up for a couple of Pools asap.