Okay, I took a look at the excel file and I will make some further comments.
Do you think it is fully necessary to model the position, velocity and acceleration of the pendulum? All you are trying to figure out is how long it will take to lose all its energy.
Also, I think there is some confusion between the angular velocity of the pendulum and the angular velocity of its oscillation. The angular velocity will vary, reaching a maximum at the lowest point and zero at the endpoints. The angular velocity of the oscillation will be constant because the period (as I noticed you have calculated) is constant, since g and L are constant. The angular velocity of the oscillation is defined as;
\omega = \frac{2\pi}{T}
It is this quantity that is constant. To avoid confusion, I suggest using v rather than omega to denote the velocity, since by the small angle approximation these two quanities are nearly equal anyway.
Finally, as I mentioned in my previous post, the energy lost per collision does not necessarily have to be known. You could model a range of scenarios where the energy lost per collision varies, coming up with a range of time values. The key is relating the time taken to reach rest (call it t_r) with the energy lost per collision (call it E_c) the initial energy (call it E_0) and the frequency of the pendulum (call it \omega) so you get something like this;
t_r = f(E_c,E_0,\omega)
Claude.