Il 13/09/2010 20:46, Andy Pugh ha scritto: > On 13 September 2010 11:55, Spiderdab<77...@tiscali.it> wrote: > > >>> I was about to start on a spreadsheet to generate ballistic >>> trajectories as G-code, then remembered that I am at work and paid to >>> do other stuff. When do you need this project working? >>> >>> >> you're a gentleman.. maybe i just need a little example to start, than >> i can improve that so i'm not going to take away time from your work. >> (but tell me truth, which is more interesting? :-) >> > Note that the ball stops instantaneously at the end of each arc, when > it hits the player, and before setting off in a new direction. > So, the path can be derived by pasting together a sequence of simple > ballistic arcs. > This does mean that each "hit" of the ball will appear to be equally > hard (and will be governed by the global accelleration values). > This spreadsheet just calculates a ballistic trajectory between points > in X,Y,Z space. > You need to enter starting X,Y,Z and finish X,Y. You will have to > fiddle the initial elevation angle and velocity to hit your final Z > position as this is a discrete step algorithm rather than an > analytical solution. (Sorry). > Air resistance is modelled as linear with velocity. This is probably > not true. If you want to use a more complex term then it is easy > enough to change the equations. > https://spreadsheets.google.com/ccc?key=0AhjJW1-T6n7CdDRTdWRvdnByRHEyTW1vZ2VYbWxDSVE&hl=en&authkey=CMP5ouIK > andy, thank you a lot for the file! now i'm not playing with the file much, 'cause in trouble with two burned transistors.. but i saw it worked! one OO question, if you have time to answer.. you used this formula for position: =A10+(($B$3-$B$2)/$B$8) what is the use of $? is it for incrementing the value of the cell? otherwise i don't know how you did it...(sorry for my ignorance..)
then i've to change something, because what you wrote is for real balistic, but what i have to move is something that can be real, or slowed down like matrix-stile, or, while flying the ball has to make a fantastic spiral as in a cartoon (do you remember Mimi Ayuara?) so the formula for the real balistic is very useful, but i have to add almost the initial and final acceleration, or my motor shaft/axle connector will die.. again thanks. Promotion: LET'S ADD AN ACC/DEC HAL PIN !!! ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Emc-users mailing list Emc-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/emc-users