Importance

Loading Importance Indicators...

Abstract

A spreadsheet application includes functions and data structures for transforming real time data items individually received over time from a real time data source into time series data globally available within the spreadsheet environment. The spreadsheet application includes a tape function operating in conjunction with a plurality of tape data structures, to store real time data items received over individually over time from a real time data source into one of the tape data structures, thereby persistently storing a set of previously received real time data items in a manner that is accessible to other functions of the spreadsheet. A plurality of filter functions and filter data structures enable computation of various statistical measures on real time data items by storing in globally accessible filter data structures information derived from a sequence of real time data items, such as a previously computed filter output, latency information describing the time intervals between real time data items, and other data, to allow the computation of a current filter output without storing all previously received real time data items. The filter and tape functions allow for various uses of real time data items without the need to provide complex macro programming.

Loading the Abstract Image...

First Claim