Invention Grant
- Patent Title: System and method for performing over time statistics in an electronic spreadsheet environment
- Patent Title (中): 在电子表格环境中执行统计时间的系统和方法
-
Application No.: US11225424Application Date: 2005-09-13
-
Publication No.: US07810032B2Publication Date: 2010-10-05
- Inventor: Frederic Bauchot , Gerard Marmigere
- Applicant: Frederic Bauchot , Gerard Marmigere
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts
- Agent William H. Steinberg
- Priority: EP04300834 20041201
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F9/45

Abstract:
A method and system for computing statistical parameters for sets of data items, by executing instructions of a computer program that is coded within a spreadsheet. Each set is generated in a time sequence that is specific to each set. For each time sequence, each data item is one data value or a pair of data values. The data items appears one-at-a-time in only one cell structure of the spreadsheet at each time in the time sequence. The one cell structure is a single cell or two cells. A loop of iterations is performed for each set. In each iteration, a command is responded to by updating the statistical parameters based on the latest data item in the one cell structure in the spreadsheet. The updated statistical parameter are stored in a parameter field of the spreadsheet assigned to each statistical parameter.
Public/Granted literature
- US20060117246A1 System and method for performing over time statistics in an electronic spreadsheet environment Public/Granted day:2006-06-01
Information query