As requested, OP delivers. Uploaded to the improved excel:
http://www.chiefdelphi.com/media/papers/3218
This version also calculates at which height may your shooter be mounted such that it will be impossible to block your shot, even by a max height opponent.
example, the closed you shoot, the more steep the balls trajectory will be, and so harder to block. This is also effected by the distance the shooter is mounted from the robot's leading edge.
Note the parameters sheet for some parameters to play with, and calculations sheet for accurate numbers. Be sure to double check all the maths before relying on this for your robot design! I don't give any guarantees for exactness
Bottom line: if it confuses my mom, it is bad for FIRST. - Joe Johnson [more] 
15-01-2016, 16:58
Threaded Mode