In referance to the spread sheet being used in inventor. This is how cmoplex animations are being created. making multiple constraints occur at the same time and even haveing them start and stop......and then start again is made thanks to the spread sheets and through calc mathematics. If you would like a small view of what I'm talking about see
www.cybersonics.org and look under inventor. See the animations and the one where the robot is at a 45 degree angle. you will see a robot drive, stop, turn, and then drive off screen to the right. This is only the beginning of what we have been able to do via complicated animation.