A spreadsheet model for soccer ball flight mechanics simulation

A mathematical model implemented in a spreadsheet environment is presented for a soccer ball in flight. The simulation is used as part of a project designed to introduce students to basic concepts in the field of flight mechanics. Results are presented for a free kick under various conditions and are consistent to previous studies and to the physical principles governing soccer ball motion in the air. It is concluded that a relatively simple model can be used in order to simulate key aspects of a game of great popularity thus providing students with increased motivation. © 2009 Wiley Periodicals, Inc. Comput Appl Eng Educ 19: 508–513, 2011

[1]  R. Mehta.  Aerodynamics of Sports Balls , 1985 .

[2]  P. Bearman,et al.  Golf Ball Aerodynamics , 1976 .

[3]  Rabindra D. Mehta,et al.  SPORTS BALL AERODYNAMICS: EFFECTS OF VELOCITY, SPIN AND SURFACE ROUGHNESS , 2001 .

[4]  Robert G. Watts,et al.  The lateral force on a spinning sphere: Aerodynamics of a curveball , 1987 .

[5]  Steve Haake,et al.  The curve kick of a football , 2002 .

[6]  Adrian Spencer,et al.  Experimental studies of the aerodynamics of spinning and stationary footballs , 2008 .

[7]  Tait.  XXI.— On the Path of a Rotating Spherical Projectile , 1895 .

[8]  Steve Haake,et al.  Understanding the Effect of Seams on the Aerodynamics of an Association Football , 2005 .

[9]  Steve Haake,et al.  The curve kick of a football II: flight through the air , 2002 .

[10]  Steve Haake,et al.  Engineering tennis – slowing the game down , 2000 .

[11]  M Hubbard,et al.  Experimental determination of baseball spin and lift , 2001, Journal of sports sciences.

[12]  D. Kerwin,et al.  Modelling the flight of a soccer ball in a direct free kick , 2003, Journal of sports sciences.

[13]  I. Griffiths,et al.  Tracking the flight of a spinning football in three dimensions , 2005 .

[14]  A. Štěpánek,et al.  The aerodynamics of tennis balls-The topspin lob , 1988 .

[15]  Ronald B. Guenther,et al.  An Introduction to Numerical Methods , 2018 .

[16]  T. Asai,et al.  Fundamental aerodynamics of the soccer ball , 2007 .

[17]  Sir Thomson,et al.  The Dynamics of a Golf Ball , 1910, Nature.

[18]  Andrew Foskett,et al.  Science in soccer , 2008 .

[19]  J. M. Davies,et al.  The Aerodynamics of Golf Balls , 1949 .