How Can I Make a Rubber Ball Bounce in an Excel Simulation?

  • Thread starter Thread starter Boyd
  • Start date Start date
  • Tags Tags
    Excel Graphing
Click For Summary
SUMMARY

The discussion focuses on creating an Excel simulation of a rubber ball's bounce using specific variables such as kinetic energy loss, acceleration due to gravity, and initial height. The user aims to visualize the ball's movement by pressing the F9 key to progress time. Key equations mentioned include Newton's Second Law and the position formula Yf=Yi + (Vi)(delta_t) + 0.5(g)(delta_t)^2. The user successfully simulates the fall but struggles with implementing the bounce mechanics.

PREREQUISITES
  • Understanding of Newton's Second Law
  • Familiarity with Excel formulas and graphing
  • Knowledge of basic physics concepts related to motion
  • Ability to manipulate variables in Excel
NEXT STEPS
  • Research how to implement conditional formulas in Excel for bounce calculations
  • Learn about energy conservation principles in physics
  • Explore Excel's graphing capabilities for dynamic simulations
  • Investigate the use of VBA in Excel for more complex animations
USEFUL FOR

Students in physics or engineering courses, educators creating interactive simulations, and Excel users interested in dynamic modeling of physical phenomena.

Boyd
Messages
2
Reaction score
0

Homework Statement


My goal is to create a graph in excel that moves as I hold the F9 key(and progressing the time). The concept is of a 'rubber ball' bouncing after it is dropped from an initial height. The variables that must be left in separate cells (to easily change) are kinetic energy lost on each bounce (max 100%, min 0%), acceleration of gravity, and initial height. (max 50 meters). The mass of the ball is neither given nor is it specified that it is necessary.


Homework Equations



Newton's Second Law
Yf=Yi + (Vi)(delta_t) + .5(g)(delta_t)^2
Momentum Equation?

The Attempt at a Solution


I can get my 'rubber ball' to fall, but I can't figure out what I need to do to make it bounce back up. Any insight would be greatly appreciated.
 
Physics news on Phys.org
disregard..nm

disregard..
 

Similar threads

High School How to characterize a rubber ball moving horizontally and bouncing off of a vertical wall?
  • · Replies 8 ·
Replies
8
Views
2K
Graduate Simulating an elastic bouncy ball
  • · Replies 10 ·
Replies
10
Views
3K
Undergrad Function for the velocity of a bouncing ball
  • · Replies 8 ·
Replies
8
Views
3K
Matlab Simulink: Simulate the height of ball thrown upward
  • · Replies 1 ·
Replies
1
Views
3K
Accounting for Air Resistance in Conservation of Energy Lab with Bouncing Ball
  • · Replies 13 ·
Replies
13
Views
4K
Displacement-Time Graph of a bouncing ball
  • · Replies 14 ·
Replies
14
Views
6K
Modelling Diesel Cycle in Excel.
  • · Replies 3 ·
Replies
3
Views
6K
How Can You Model Car Oscillations Over a Speed Bump Using Excel?
  • · Replies 3 ·
Replies
3
Views
4K
What Determines the Decreasing Height of a Bouncing Ball?
  • · Replies 9 ·
Replies
9
Views
3K
Undergrad Initial height of a bouncing ball and energy lost
  • · Replies 3 ·
Replies
3
Views
4K