when you should use a dictionary as opposed to when you should use a dictionar
I feel as though arrays would be faster as even though you have to load the entire array and read through it, it is done in memory. I would imagine it may minimise interactions with the worksheet, which is what slows down spreadsheets.