Excel VBA is very powerful tool akin to pml in PDMS. And it needs some work before you can do something meaningful out of it. It was just that I was working on this and your example came across. I'm posting the file herewith.
1. In Excel, Go To Tools >> Macros >> Security and set it to Medium. Exit Excel.
2. Then open the file that I've posted on this forum. I've written the steps in the file.
And Yes, you can see the edited by pressing ALT + F11 (Visual Basic Editor). And should that increase your curiosity then there are forums for this. One of the best is VBAX.
To start with you need to become a premium member to access all the pml section of this web site...
There is a excellant section for collections under it...
When you have collections mastered you need to use evaluations (to manipulate the collections)...a bit of maths and know how to write to a text file....