发明公开
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
- 专利标题(中): 系统和方法在电子表格环境中进行过一次统计
-
申请号: EP05111259.7申请日: 2005-11-24
-
公开(公告)号: EP1667032A3公开(公告)日: 2009-01-07
- 发明人: Bauchot, Frederic , Marmigere, Gerard
- 申请人: International Business Machines Corporation
- 申请人地址: New Orchard Road Armonk, NY 10504 US
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: New Orchard Road Armonk, NY 10504 US
- 代理机构: Etorre, Yves Nicolas
- 优先权: EP04300834 20041201
- 主分类号: G06F17/24
- IPC分类号: G06F17/24
摘要:
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.
• 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.
公开/授权文献
信息查询