I had a plan going into work this morning: that before the morning was over, I would solve the problem of calculating email availability stats that has been plaguing me for the last severals months. After using some test data to test my data aggregation script, and then running it against real data, it looks like at last, it’s working correctly. The numbers my script is getting are very close to what is currently being collected manually.
Never mind the fact that I think there are numerous statistical problems with the model being used to calculate the availability of the email at my company. I am not a statistician enough to demonstrate that they may not be as accurate as they could be. But at least I’ve got this problem out of my hair and I can move onto other things.