Mac: As my final project for school, I created a beta version of something that sounds similar. Mine was set up so that you can do your initial data entry (scene breakdown, cast list, etc), then the locations and types of rehearsals (such as fight rehearsal for one scene and a blocking rehearsal for another scene, including wardrobe fittings). It could generate the schedule for you, as well as indicate when/where there was a conflict. I haven't looked at it in a couple of years, but I'd love to get updates on your project if you'd allow, and be happy to share what I've learned. However, since I'm not a programmer, mine was in Access - the idea being that since it comes with Office, anyone could use it.
kjdiehl: Okay, silly question. I have the hardest time calculating times in Excel. I've only recently begun working with macros, so my excel skills are still pretty basic. If you have any tips, I would love to hear them.
mikejones: My only hesitation with computerized blocking is how quickly can you make changes? I mean, if the first time around, the actor crosses all the way to the table, but then the next time, he/she only goes 3' towards the table, how easily could you change that if you're using animated blocking? And what if you miss a move? I'm not a video camera, so I'm glad that the actors have to do it several times to learn it, otherwise I'd never get it all in my book!
I've done the whole publishing to a password protected website thing for paperwork in the past too and it was a dream! Everyone loved it. But it only worked because everyone, including the actors, were able to get online regularly and with ease. In the past two years I've done one show where that was the case. Sigh. Would love to be able to do it again!