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

[Boyd]

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.

 

[Boyd]

disregard..nm

disregard..