# US 2017/0255608 A1 · Dynamic disaggregation and aggregation of spreadsheet data

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2017/0255608 A1
- Document ID: US20170255608A1
- Status: Published application
- Kind: A1
- Application number: 15/057,355
- Filed: 2016-03-01
- Published: 2017-09-07
- Earliest claimed: 2016-03-01
- Assignees: Business Objects Software Ltd.
- Applicants: Business Objects Software, Ltd.
- Inventors: Florent MIGEON; Sebastien LAVOIGNAT
- Web page: https://patentgrep.com/patent/US20170255608A1

## CPC

- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A computer-implemented method for disaggregating data in a spreadsheet or other data structure hosted on a client computing device includes providing an analyzer module as a plug-in or add-in to a spreadsheet application on a client computing device. The analyzer module locally performs disaggregation and aggregation processes on data in the spreadsheet on the client computing device. The method includes parsing, by the analyzer module, content entered in a subject cell of the spreadsheet to determine if sets of special syntax characters corresponding to a disaggregation instruction or command precede an amount in the entered content, and accordingly disaggregating or aggregating data in the spreadsheet.

## Claims

### Claim 1

A computer-implemented method for disaggregating data in a spreadsheet or other data structure hosted on a client computing device, the method comprising:
providing an analyzer module as a plug-in or add-in to a spreadsheet application on a client computing device to perform disaggregation and aggregation processes on data in the spreadsheet; and
parsing, by the analyzer module, content entered in a subject cell of the spreadsheet to determine if sets of special syntax characters corresponding to a disaggregation instruction or command precede an amount in the entered content.

### Claim 2 (depends on 1)

The method of claim 1, wherein the sets of special syntax characters corresponding to a disaggregation instruction or command correspond to an instruction for even disaggregation, or an instruction for proportional disaggregation with proportions corresponding to a reference disaggregation of a reference node, which is existing in the spreadsheet.

### Claim 3 (depends on 1)

The method of claim 1 further comprising, when the content entered in the subject cell does not include the sets of special syntax characters corresponding to a disaggregation instruction or command, placing the amount as the value of the subject cell in the spreadsheet.

### Claim 4 (depends on 1)

The method of claim 1 further comprising, when the content entered in the subject cell includes a set of special syntax characters corresponding to a disaggregation instruction or command, initiating processes to disaggregate the amount in the content entered in the subject cell.

### Claim 5 (depends on 4)

The method of claim 4, wherein initiating processes to disaggregate the amount in the content entered in the subject cell includes:
determining if the subject cell in which the content is entered is a hierarchy node of the spreadsheet;
when the subject cell is determined not to be a hierarchy node of the spreadsheet, placing the amount in the subject cell;
when the subject cell is determined to be a hierarchy node of the spreadsheet, identifying child nodes of the hierarchy node which may be present in the spreadsheet; and
when no child nodes of the hierarchy node are present, placing the amount in the subject cell in which the content is entered with no disaggregation steps.

### Claim 6 (depends on 5)

The method of claim 5, wherein initiating processes to disaggregate the amount in the content entered in the subject cell further includes:
when one or more child nodes of the hierarchy node are present, identifying and obtaining a count of the number of rows of the spreadsheet in which the child nodes of the hierarchy node are present; and
when the special characters parsed by the analyzer module from the entered content are only the set of special characters corresponding to the instruction for even or uniform disaggregation, dividing the entered amount by the count of the number of rows of the spreadsheet in which the child nodes of the hierarchy node are present and placing the result in each of the child nodes of the hierarchy node.

### Claim 7 (depends on 6)

The method of claim 6 further including automatically generating and replacing the entered amount in the hierarchy node by formula.

### Claim 8 (depends on 6)

The method of claim 6, wherein initiating processes to disaggregate the amount in the content entered in the subject cell further includes:
when the special characters parsed by the analyzer module from the entered content include a set of special characters corresponding to an instruction for proportional disaggregation,
locating a reference node, child nodes of the reference node, and an existing disaggregation (“reference disaggregation”) of the reference node over child nodes of the reference node in the spreadsheet;
determining a ratio of each reference child node value to the reference node value for each reference child node in the existing disaggregation of the reference node; and
using the determined ratios for the reference child nodes in the reference disaggregation to determine weights for a proportional disaggregation of the entered amount over the identified child nodes of the hierarchy node.

### Claim 9 (depends on 6)

The method of claim 6 further comprising determining a value of each identified child node of the hierarchy node by multiplying the entered amount by the ratio determined for the corresponding child node in the existing disaggregation of the reference node.

### Claim 10 (depends on 6)

The method of claim 6 further including replacing the entered amount in the hierarchy node by an automatically generated formula; and inserting an automatically generated formula for each identified child node of the hierarchy node.

### Claim 11

A computing device comprising:
a memory and a semiconductor-based processor, the memory and the processor forming one or more logic circuits configured to:
host a spreadsheet application to process a spreadsheet or other data structures; and
an analyzer module coupled to spreadsheet,
the analyzer module parsing content entered in a subject cell of the spreadsheet to determine if sets of special syntax characters corresponding to a disaggregation instruction or command precede an amount in the entered content, and accordingly locally performing disaggregation and aggregation processes on data in the spreadsheet.

### Claim 12 (depends on 11)

The computing device of claim 11, wherein the sets of special syntax characters corresponding to a disaggregation instruction or command correspond to an instruction for even disaggregation, or an instruction for proportional disaggregation with proportions corresponding to a reference disaggregation of a reference node, which is existing in the spreadsheet.

### Claim 13 (depends on 11)

The computing device of claim 11, wherein the analyzer module, when the content entered in the subject cell does not include the sets of special syntax characters corresponding to a disaggregation instruction or command, place the amount as the value of the subject cell in the spreadsheet.

### Claim 14 (depends on 11)

The computing device of claim 11, wherein the analyzer module, when the content entered in the subject cell includes a set of special syntax characters corresponding to a disaggregation instruction or command, initiates processes to disaggregate the amount in the content entered in the subject cell.

### Claim 15 (depends on 14)

The computing device of claim 14, wherein the analyzer module:
determines if the subject cell in which the content is entered is a hierarchy node or cell of the spreadsheet;
when the subject cell is determined not to be a hierarchy node or cell of the spreadsheet, places the amount in the subject cell;
when the subject cell is determined to be a hierarchy node, identifies child nodes of the hierarchy node which may be present in the spreadsheet; and
when no child nodes of the hierarchy node are present, places the amount in the subject cell in which the content is entered with no disaggregation steps.

### Claim 16 (depends on 14)

The computing device of claim 14, wherein the analyzer module:
when one or more child nodes of the hierarchy node are present, identifies and obtains a count of the number of rows of the spreadsheet in which the child nodes of the hierarchy node are present; and
when the special characters parsed by the analyzer module from the entered content are only the set of special characters corresponding to the instruction for even or uniform disaggregation, divides the entered amount by the count of the number of rows of the spreadsheet in which the child nodes of the hierarchy node are present and places the result in each of the child nodes of the hierarchy node.

### Claim 17 (depends on 16)

The computing device of claim 16, wherein the analyzer module automatically generates and replaces the entered amount in the hierarchy node by a formula.

### Claim 18 (depends on 16)

The computing device of claim 16, wherein the analyzer module:
when the special characters parsed by the analyzer module from the entered content include a set of special characters corresponding to an instruction for proportional disaggregation,
locates a reference node, child nodes of the reference node, and an existing disaggregation (“reference disaggregation”) of the reference node over child nodes of the reference node in the spreadsheet;
determines a ratio of each reference child node value to the reference node value for each reference child node in the existing disaggregation of the reference node; and
uses the determined ratios for the reference child nodes in the reference disaggregation to determine weights for a proportional disaggregation of the entered amount over the identified child nodes of the hierarchy node.

### Claim 19 (depends on 16)

The computing device of claim 16, wherein the analyzer module when determining a value of each identified child node of the hierarchy node by multiplies the entered amount by the ratio determined for the corresponding child node in the existing disaggregation of the reference node.

### Claim 20 (depends on 16)

The computing device of claim 16, wherein the analyzer module:
replaces the entered amount in the hierarchy node by an automatically generated formula; and
inserts an automatically generated formula for each identified child node of the hierarchy node.
