Function - BuzzHeartbeat()

Description:

Gives a visual signal that the BuzzCalc engine and Excel are talking to each other. A heartbeat is sent to Excel every few seconds.

If no argument is given, the last time a Heartbeat was recieved is displayed. Otherwise it counts up between zero and [CountUpTo], incrementing with each Heartbeat received.

Arguments:

  1. CountUpTo: The top number to reach after which the count resets to zero and starts over. (optional value)

Example:

=BuzzHeartbeat()

To make an animated rotating display, try this formula:

=IF(BuzzHeartbeat(3)=0,"|",IF(BuzzHeartbeat(3)=1,"/",IF(BuzzHeartbeat(3)=2,"-","\")))