发明公开
EP1667032A3 System and method for performing over time statistics in an electronic spreadsheet environment 审中-公开
系统和方法在电子表格环境中进行过一次统计

System and method for performing over time statistics in an electronic spreadsheet environment
摘要:
The present invention is directed to a system, method and computer program in a multi-dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, for computing statistical data based on a set of successive values taken by a given cell or by a given pair of cells over a time period. The method comprises the steps of:
• receiving a command for computing statistical data based on successive values of a first cell over a time period, said command comprising :
• means for identifying said first cell;
• means for determining the beginning and the end of the time period;
• a reference to a statistical function for computing statistical data based on the successive values of said first cell over said time period;

• computing statistical data based on the successive values of said first cell over said time period, said step comprising the further steps of, each time the value of said first cell is updated :
• computing said statistical data by means of said statistical function, based on :
• the current value of said first cell, and
• the previously computed statistical data based on the successive values taken by the first cell from the beginning of the time period;

• storing the computed statistical data in place of the previously computed statistical data.
信息查询
0/0