Computer system for generation of table data applicable to management of enterprises

• US 7,356,520 B2
• Filed: 09/05/2002
• Issued: 04/08/2008
• Est. Priority Date: 09/21/2001
• Status: Active Grant

• Current Assignee: Fukuzo Noji
• Original Assignee: Fukuzo Noji
• Inventors: Noji, Fukuzo
• Primary Examiner(s): Hirl; Joseph P
• Application Number:
  US10/490,279
• Publication Number:
  US 20040243594A1
• Time in Patent Office: 2,042 Days
• Field of Search: 706/46, 706/12, 706/14, 707/101
• US Class Current: 706/46
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Due to differences in the economic environment and other circumstances in a company, individual businesses create data with various attributes and the like. For this reason, companies have not always been able to make full use of their corporate data in association with various corporate data provided from external organizations. Therefore, the present invention provides a system facilitating the analysis of company data while incorporating external data. Using n-row by m-column two-dimensional tabular data, the system sets totaled values for columns to internal data and totaled values for rows to external data and calculates the values of cells, while performing analyses associated with the external data. The system calculates values in six cells from two sets of tabular data condensed to two rows and three columns and calculates the values in each cell of the n-row, n-column original table.

Claims

1. A computer system for generating tabular data,

the tabular data comprising:

cell data s_ij (where i=1, 2, . . . , and n; and

j=1, 2, . . . , and m) arranged two-dimensionally in n rows and m columns and including numerical data used in corporate management that has been compiled and sorted based on attributes for the rows and columns;

two sets of one-dimensional data having different attributes that include totaled values y_ti (where i=1, 2, . . . , and n) for the m cell values in each row and totaled values x_tj (where j=1, 2, . . . , and m) for the n cell values in each column; and

one-dimensional data for basic units P_j (where j=1, 2, . . . , and m), which are constant quantities shared in the respective columns such that the values in the n cells of each column are multiples of the constant quantity and the prime factors of the constant quantities in each column differ at least partially;

wherein the totaled values x_tj and their basic units P_j are compiled based on company attributes determined in-house, while the totaled values y_ti are set to one-dimensional data compiled according to attributes set outside of the company;

the computer system comprising various means for finding partial data, wherein the values x_tj, P_j, and y_ti are known quantities and the cell data s_ij for each of the n×

m cells are unknown quantities;

the computer system further comprising;

initializing means for setting internal data and modified data for external data, displaying a settings input window for inputting rows and columns indicating a range of the cells for which a solution is to be found and the order for selecting rows and columns within that range, and storing the inputted data in an initial settings table;

basic units plus/minus differential generating means for selecting one column from the initial settings table according to the selection order set by the initializing means, setting P₁ to the basic units P_j of the totaled value x_tj in the selected column, and generating two basic units P(0) and P(2) having the same differential with P₁, but one being less than P₁ and the other greater;

P(0) table generating means for creating a 2-row, 3-column condensed table using P(0) by setting a totaled value y_t1′

in the first row of a P(0) table to the value of y_ti in the selected row, setting a totaled value y_t2′

in the second row to the total of all values y_t2-y_tn of rows not selected;

setting a totaled value x_t1′

in the first column of the P(0) table to the value of x_tj in the selected row, setting a totaled value x_t2′

in the second column to a value found from the expression P(0)(x_t2/P₂+x_t3/P₃+ . . . +x<sub>tm−

1</sub>/P<sub>m−

1</sub>) using the totaled values x_t2, x_t3, x_t4, . . . for all columns not selected, but excluding the totaled value x_tm in the final column, and setting a totaled value x_t3′

in the third column to a value found the expression (P₂−

P(0))(x_t2/P₂)+(P₃−

P(0))(x_t3/P₃)+ . . . +(P<sub>m−

1</sub>−

P(0))(x<sub>t,m−

1</sub>/P<sub>m−

1</sub>)+x_tm to condense the original table to three columns;

P(2) table generating means for generating a 2-row, 3-column condensed table according to the same method as the P(0) table generating means described above, but using P(2) in place of P(0);

2-row, 3-column condensed table cell value displaying means that expresses the six cell values x_ij (for line numbers i=1 and 2 and column numbers j=1, 2, and

     3) according to the following equations, using known quantities a, b, and c as the totaled values for the first, second, and third columns in the 2-row by 3-column condensed table and known quantities d and e as the totaled values in the first and second rows, and employing unknown quantities α and

β

;

x₁₁=−

2(a+b+c)+3d+α

x₂₁=3a+2(b+c)−

3d−

α

x₁₂=6a+4(b+c)−

6d−

3α

+β

x₂₂=−

6a−

3b−

4c+6d+3α

−

β

x<sub>13=−

4</sub>a−

2(b+c)+4d+2α

−

β

x₂₃=4a+2b+3c−

4d−

2α

+β

;

n12 generating means for generating a unit quantity n12 for the cells s₁₂′ and

s₁₂″

in the corresponding P(0) and P(2) tables by totaling the unit quantities for all cells of the original tabular data prior to condensing the data, from the cell s₁₂ in the first row and the second column to the cell s<sub>1,m−

1</sub> in the first row and (m−

1)^th column but excluding the cell s_1m in the final column, according to the equation n12=s₁₂/P₂+s₁₃/P₃+ . . . +s<sub>1,m−

1</sub>/P<sub>m−

1</sub>;

n12 solution sequence calculating means for finding solutions of cell unit quantities n12 based on the P₁ setting by calculating the residue class of the cell unit quantities n12 mod P₁ based on the totaled values for each of the 2-row, 3-column condensed P(0) and P(2) tables and the basic units P₁, P(0), and P(2), and calculating and displaying a sequence that can be used as solutions for n12; and

selected n12 unit quantity sequential calculating means for setting P₁′

to include factors relatively prime with P₁, generating two basic units P′

(0) and P′

(2) having the same differential with P₁′

, with one less than P₁′ and

the other greater, using the same means used for P₁, generating P′

(0) and P′

(2) tables condensed to two rows and three columns, calculating the residue class of n12 mod P₁′

based on the totaled values in the P′

(0) and P′

(2) tables and the basic units P₁′

, P′

(0), and P′

(2), and calculating a sequence that can be used as solutions for n12, fixing a unit quantity for the n12 of the current column selected by the initializing means if a unique solution exists in the overlapping area between the solution sequence for n12 based on the P₁ setting and the solution sequence for n12 based on the P₁′

setting found by said solution n12 sequence calculating means, setting a P₁″

having factors relatively prime with P₁ and P₁′

, repeating the process to calculate the n12 solution sequence if the n12 solution sequence according to the P₁ setting and the n12 solution sequence according to the P1′

setting include a plurality of overlapping solutions, fixing a unit quantity for the n12 of the current column selected by the initializing means, storing this quantity in a total results table, searching the initial settings table and reading the next column that should be selected in the order of calculation, moving the selected column to the first column and repeating each of the means described above to determine the unit quantity of n12;

reading the selected column for the next row from the initial settings table if all unit quantities n12 have been determined for that row and repeating the steps described above for determining the n12 unit quantity; and

stopping data recording to the total results table after finding all unit quantities n12 in the cell range set in the initial settings table.

2. The computer system for generating tabular data according to claim 1, wherein the totaled values x_tj, one-dimensional data compiled in-house, indicate total sales for products sold to a plurality of retailers;

the basic units p_j indicate the unit costs of the sold products; and

the totaled values y_tj, one-dimensional data determined and compiled externally, indicate total sales by end-user that have been recategorized and ordered according to data received from each retailer.

3. A computer system configured to generate tubular data, comprising:

a processor; and

a memory coupled to said processor;

the memory having stored therein sequences of instructions which, when executed by said processor, cause said processor to generate tabular data by causing the processor to perform the steps of;

finding partial data, wherein the values x_tj, P_j, and y_ti are known quantities and the cell data s_ij for each of the n*m cells are unknown quantities;

setting internal data and modified data for external data, displaying a settings input window for inputting rows and columns indicating a range of the cells for which a solution is to be found and the order for selecting rows and columns within that range, and storing the inputted data in an initial settings table;

selecting one column from the initial settings table according to the selection order set by the initializing steps, setting P₁ to the basic unit P_j of the totaled value x_tj in the selected column, and generating two basic units P(0) and P(2) having the same differential with P₁, but one being less than P₁ and the other greater;

creating a 2-row, 3-column condensed table using P(0) by setting a totaled value y_t1′

in the first row of a P(0) table to the value of y_ti in the selected row, setting a totaled value y_t2′

in the second row to the total of all values y_t2-y_tn of rows not selected;

setting a totaled value x_t1′

in the first column of the P(0) table to the value of x_tj in the selected row, setting a totaled value x_t2′

in the second column to a value found from the expression P(0)(x_t2/P₂+x_t3/P₃+ . . . +X<sub>tm−

1</sub>/P<sub>m−

1</sub>) using the totaled values x_t2, x_t3, x_t4, . . . for all columns not selected, but excluding the totaled value x_tm in the final column, and setting a totaled value x_t3′

in the third column to a value found the expression (P₂−

P(0))(x_t2/P₂)+(P₃−

P(0))(x_t3/P₃)+ . . . +(P<sub>m−

1</sub>−

P(0))(x<sub>t,m−

1</sub>/P<sub>m−

1</sub>)+x_tm to condense the original table to three columns;

generating a 2-row, 3-column condensed table according to the same method as the P(0) table generating step described above, but using P(2) in place of P(0);

displaying the six cell values x_ij (for line numbers i=1 and 2 and column numbers j=1, 2, and

     3) according to the following equations, using known quantities a, b, and c as the totaled values for the first, second, and third columns in the 2-row by 3-column condensed table and known quantities d and e as the totaled values in the first and second rows, and employing unknown quantities α and

β

;

x₁₁=−

2(a+b+c)+3d+α

x₂₁=3a+2(b+c)−

3d−

α

x₁₂=6a+4(b+c)−

6d−

3α

+β

x22=−

6a−

3b−

4c+6d+3α

−

β

x13=−

4a−

2(b+c)+4d+2α

−

β

x23=4a+2b+3c−

4d−

2α

+β

;

generating a unit quantity n12 for the cells s₁₂′ and

s₁₂″

in the corresponding P(0) and P(2) tables by totaling the unit quantities for all cells of the original tabular data prior to condensing the data, from the cell s₁₂ in the first row and the second column to the cell s<sub>1,m−

1</sub> in the first row and (m −

1)^th column but excluding the cell s_1m in the final column, according to the equation n12=s₁₂/P₂+s₁₃/P₃+ . . . +s<sub>1,m−

1</sub>/P<sub>m−

1</sub>;

finding solutions of cell unit quantities n12 based on the P₁ setting by calculating the residue class of the cell unit quantities n12 mod P₁ based on the totaled values for each of the 2-row, 3-column condensed P(0) and P(2) tables and the basic units P₁, P(0), and P(2), and calculating and displaying a sequence that can be used as solutions for n12;

calculating the cell unit quantities n12 based on a P₁′

setting by setting P₁′

to include factors relatively prime with P₁, generating two basic units P′

(0) and P′

(2) having the same differential with P₁′

, with one less than P₁′ and

the other greater, using the same step used for P₁, generating P′

(0) and P′

(2) tables condensed to two rows and three columns, calculating the residue class of n12 mod P₁′

based on the totaled values in the P′

(0) and P′

(2) tables and the basic units P₁′

, P′

(0), and P′

(2), and calculating and displaying a sequence that can be used as solutions for n12; and

fixing a unit quantity for the n12 of the current column selected by the initializing step if a unique solution exists in the overlapping area between the solution sequence for n12 based on the P₁ setting and the solution sequence for n12 based on the P₁′

setting found by the solution n12 sequence calculating step setting a P₁″

having factors relatively prime with P₁ and P₁′

, repeating the process to calculate the n12 solution sequence if the n12 solution sequence according to the P₁ setting and the n12 solution sequence according to the P₁′

setting include a plurality of overlapping solutions, fixing a unit quantity for the n12 of the current column selected by the initializing step, storing this quantity in a total results table, searching the initial settings table and reading the next column that should be selected in the order of calculation, moving the selected column to the first column and repeating each of the steps described above to determine the unit quantity of n12;

reading the selected column for the next row from the initial settings table if all unit quantities n12 have been determined for that row and repeating the steps described above for determining the n12 unit quantity; and

stopping data recording to the total results table after finding all unit quantities n12 in the cell range set in the initial settings table.

4. The computer system configured to generate tabular data according to claim 3, wherein the tabular data used for cooperate management comprise;

cell data s_ij (where i=1, 2, . . . , and n; and

j=1, 2, . . . , and m) arranged two-dimensionally in n rows and m columns and including numerical data used in corporate management that has been compiled and sorted based on attributes for the rows and columns;

two sets of one-dimensional data having different attributes that include totaled values y_ti (where i=1, 2, . . . , and n) for the m cell values in each row and totaled values x_tj (where j=1, 2, . . . , and m) for the n cell values in each column; and

one-dimensional data for basic units P_j (where j=1, 2, . . . , and m), which are constant quantities shared in the respective columns such that the values in the n cells of each column are multiples of the constant quantity and the prime factors of the constant quantities in each column differ at least partially;

wherein the totaled values x_tj and their basic units P_j are compiled based on company attributes determined in-house, while the totaled values y_ti are set to one-dimensional data compiled according to attributes set outside of the company.

5. The computer system configured to generate tabular data according to claim 3, wherein the totaled values x_tj, one-dimensional data compiled in-house, indicate total sales for products sold to a plurality of retailers;

the basic units p_j indicate the unit costs of the sold products; and

the totaled values y_tj, one-dimensional data determined and compiled externally, indicate total sales by end-user that have been recategorized and ordered according to data received from each retailer.

6. A method for generating tabular data, comprising the steps of:

finding partial data, wherein the values x_tj, P_j, and y_ti are known quantities and the cell data s_ij for each of the n*m cells are unknown quantities;

setting internal data and modified data for external data, displaying a settings input window for inputting rows and columns indicating a range of the cells for which a solution is to be found and the order for selecting rows and columns within that range, and storing the inputted data in an initial settings table;

selecting one column from the initial settings table according to the selection order set by the initializing steps, setting P₁ to the basic unit P_j of the totaled value x_tj in the selected column, and generating two basic units P(0) and P(2) having the same differential with P₁, but one being less than P₁ and the other greater;

creating a 2-row, 3-column condensed table using P(0) by setting a totaled value y_t1′

in the first row of a P(0) table to the value of y_ti in the selected row, setting a totaled value y_t2′

in the second row to the total of all values y_t2-y_tn of rows not selected;

setting a totaled value x_t1′

in the first column of the P(0) table to the value of x_tj in the selected row, setting a totaled value x_t2′

in the second column to a value found from the expression P(0)(x_t2/P₂+x_t3/P₃+ . . . +x<sub>tm−

1</sub>/P<sub>m−

1</sub>) using the totaled values x_t2, x_t3, x_t4, . . . for all columns not selected, but excluding the totaled value x_tm in the final column, and setting a totaled value x_t3′

in the third column to a value found the expression (P₂−

P(0))(x_t2/P₂)+(P₃−

P(0))(x_t3/P₃)+ . . . +(P<sub>m−

1</sub>−

P(0))(x<sub>t,m−

1</sub>/P<sub>m−

1</sub>)+x_tm to condense the original table to three columns;

generating a 2-row, 3-column condensed table according to the same method as the P(0) table generating step described above, but using P(2) in place of P(0);

displaying the six cell values x_ij (for line numbers i=1 and 2 and column numbers j=1, 2, and

     3) according to the following equations, using known quantities a, b, and c as the totaled values for the first, second, and third columns in the 2-row by 3-column condensed table and known quantities d and e as the totaled values in the first and second rows, and employing unknown quantities α and

β

;

x₁₁=−

2(a+b+c)+3d+α

x₂₁=3a+2(b+c)−

3d−

α

x12=6a+4(b+c)−

6d−

3α

+β

x22=−

6a−

3b−

4c+6d+3α

−

β

x13=−

4a−

2(b+c)+4d+2α

−

β

x23=4a+2b+3c−

4d−

2α

+β

;

generating a unit quantity n12 for the cells s₁₂′ and

s₁₂″

in the corresponding P(0) and P(2) tables by totaling the unit quantities for all cells of the original tabular data prior to condensing the data, from the cell s₁₂ in the first row and the second column to the cell s<sub>1,m−

1</sub> in the first row and (m−

1)^th column but excluding the cell s_1m in the final column, according to the equation n12=s₁₂/P₂+s₁₃/P₃+ . . . +s<sub>1,m−

1</sub>/P<sub>m−

1</sub>;

finding solutions of cell unit quantities n12 based on the P₁ setting by calculating the residue class of the cell unit quantities n12 mod P₁ based on the totaled values for each of the 2-row, 3-column condensed P(0) and P(2) tables and the basic units P₁, P(0), and P(2), and calculating and displaying a sequence that can be used as solutions for n12;

calculating the cell unit quantities n12 based on a P₁′

setting by setting P₁′

to include factors relatively prime with P₁, generating two basic units P′

(0) and P′

(2) having the same differential with P₁′

, with one less than P₁′ and

the other greater, using the same step used for P₁, generating P′

(0) and P′

(2) tables condensed to two rows and three columns, calculating the residue class of n12 mod P₁′

based on the totaled values in the P′

(0) and P′

(2) tables and the basic units P₁′

, P′

(0), and P′

(2), and calculating and displaying a sequence that can be used as solutions for n12; and

fixing a unit quantity for the n12 of the current column selected by the initializing step if a unique solution exists in the overlapping area between the solution sequence for n12 based on the P₁ setting and the solution sequence for n12 based on the P₁′

setting found by the solution n12 sequence calculating step, setting a P₁″

having factors relatively prime with P₁ and P₁′

, repeating the process to calculate the n12 solution sequence if the n12 solution sequence according to the P₁ setting and the n12 solution sequence according to the P₁′

setting include a plurality of overlapping solutions, fixing a unit quantity for the n12 of the current column selected by the initializing step, storing this quantity in a total results table, searching the initial settings table and reading the next column that should be selected in the order of calculation, moving the selected column to the first column and repeating each of the steps described above to determine the unit quantity of n12;

reading the selected column for the next row from the initial settings table if all unit quantities n12 have been determined for that row and repeating the steps described above for determining the n12 unit quantity; and

stopping data recording to the total results table after finding all unit quantities n12 in the cell range set in the initial settings table.

7. The method for generating tabular data according to claim 6, wherein the tabular data used for cooperate management comprise:

cell data s_ij (where i=1, 2, . . . , and n; and

j=˜

1, 2, . . . , and m) arranged two-dimensionally in n rows and m columns and including numerical data used in corporate management that has been compiled and sorted based on attributes for the rows and columns;

two sets of one-dimensional data having different attributes that include totaled values y_ti (where i=1, 2, . . . , and n) for the m cell values in each row and totaled values x_tj (where j=1, 2, . . . , and m) for the n cell values in each column; and

one-dimensional data for basic units P_j (where j=1, 2, . . . , and m), which are constant quantities shared in the respective columns such that the values in the n cells of each column are multiples of the constant quantity and the prime factors of the constant quantities in each column differ at least partially;

wherein the totaled values x_tj and their basic units P_j are compiled based on company attributes determined in-house, while the totaled values y_ti are set to one-dimensional data compiled according to attributes set outside of the company.

8. The method for generating tabular data according to claim 6, wherein the totaled values x_tj, one-dimensional data compiled in-house, indicate total sales for products sold to a plurality of retailers;

the basic units p_j indicate the unit costs of the sold products; and

the totaled values y_tj, one-dimensional data determined and compiled externally, indicate total sales by end-user that have been recategorized and ordered according to data received from each retailer.