I have finished the Excel document that will make it easier. If you want to try it out, PM me and ill send you a link. If people like it I will post it for everyone.
I think there is an even simpler way to do it. I just simulate a 30 minute practice and call it a day. However I guess if you want realism then you would do the split.