Computer system for generation of table data applicable to management of enterprises
First Claim
1. A computer system for generating tabular data, the tabular data comprising:
- cell data sij (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 yti (where i=1,2, . . . , and n) for the m cell values in each row and totaled values xtj (where j=1,2, . . . , and m) for the n cell values in each column; and
one-dimensional data for basic units Pj (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 xtj and their basic units Pj are compiled based on company attributes determined in-house, while the totaled values yti 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 xtj, Pj, and yti are known quantities and the cell data sij 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 P1 to the basic units Pj of the totaled value xtj in the selected column, and generating two basic units P(0) and P(2) having the same differential with P1, but one being less than P1 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 yt1′
in the first row of a P(0) table to the value of yti in the selected row, setting a totaled value yt2′
in the second row to the total of all values yt2-ytn of rows not selected;
setting a totaled value xt1′
in the first column of the P(0) table to the value of xtj in the selected row, setting a totaled value xt2′
in the second column to a value found from the expression P(0)(xt2/P2+xt3/P3+ . . . +xtm−
1/Pm−
1) using the totaled values xt2, xt3, xt4, . . . for all columns not selected, but excluding the totaled value xtm in the final column, and setting a totaled value xt3′
in the third column to a value found the expression (P2−
P(0))(xt2/P2)+(P3−
P(0))(xt3/P3)+ . . . +(Pm−
1−
P(0))(xt,m−
1/Pm−
1)+xtm 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 xij (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
β
;
x11=−
2(a+b+c)+3d+α
x21=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α
+β
;
n12 generating means for generating a unit quantity n12 for the cells s12′ and
s12″
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 s12 in the first row and the second column to the cell s1,m−
1 in the first row and (m−
1)th column but excluding the cell s1m in the final column, according to the equation n12=s12/P2+s13/P3+ . . . +s1,m−
1/Pm−
1;
first n12 solution sequence calculating means for finding solutions of cell unit quantities n12 based on the P1 setting by calculating the residue class of the cell unit quantities n12 mod P1 based on the totaled values for each of the 2-row, 3-column condensed P(0) and P(2) tables and the basic units P1, P(0), and P(2), and calculating and displaying a sequence that can be used as solutions for n12;
second n12 solution sequence calculating means for calculating the cell unit quantities n12 based on a P1′
setting by setting P1′
to include factors relatively prime with P1, generating two basic units P′
(0) and P′
(2) having the same differential with P1′
, with one less than P1′ and
the other greater, using the same means used for P1, generating P′
(0) and P′
(2) tables condensed to two rows and three columns, calculating the residue class of n12 mod P1′
based on the totaled values in the P′
(0) and P′
(2) tables and the basic units P1′
, 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 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 P1 setting and the solution sequence for n12 based on the P1′
setting found by the first and second solution n12 sequence calculating means, respectively, 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 column and repeating the steps 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.
0 Assignments
0 Petitions
Accused Products
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.
-
Citations
15 Claims
-
1. A computer system for generating tabular data, the tabular data comprising:
-
cell data sij (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 yti (where i=1,2, . . . , and n) for the m cell values in each row and totaled values xtj (where j=1,2, . . . , and m) for the n cell values in each column; and
one-dimensional data for basic units Pj (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 xtj and their basic units Pj are compiled based on company attributes determined in-house, while the totaled values yti 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 xtj, Pj, and yti are known quantities and the cell data sij 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 P1 to the basic units Pj of the totaled value xtj in the selected column, and generating two basic units P(0) and P(2) having the same differential with P1, but one being less than P1 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 yt1′
in the first row of a P(0) table to the value of yti in the selected row, setting a totaled value yt2′
in the second row to the total of all values yt2-ytn of rows not selected;
setting a totaled value xt1′
in the first column of the P(0) table to the value of xtj in the selected row, setting a totaled value xt2′
in the second column to a value found from the expression P(0)(xt2/P2+xt3/P3+ . . . +xtm−
1/Pm−
1) using the totaled values xt2, xt3, xt4, . . . for all columns not selected, but excluding the totaled value xtm in the final column, and setting a totaled value xt3′
in the third column to a value found the expression (P2−
P(0))(xt2/P2)+(P3−
P(0))(xt3/P3)+ . . . +(Pm−
1−
P(0))(xt,m−
1/Pm−
1)+xtm 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 xij (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
β
;
x11=−
2(a+b+c)+3d+α
x21=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α
+β
;
n12 generating means for generating a unit quantity n12 for the cells s12′ and
s12″
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 s12 in the first row and the second column to the cell s1,m−
1 in the first row and (m−
1)th column but excluding the cell s1m in the final column, according to the equation n12=s12/P2+s13/P3+ . . . +s1,m−
1/Pm−
1;
first n12 solution sequence calculating means for finding solutions of cell unit quantities n12 based on the P1 setting by calculating the residue class of the cell unit quantities n12 mod P1 based on the totaled values for each of the 2-row, 3-column condensed P(0) and P(2) tables and the basic units P1, P(0), and P(2), and calculating and displaying a sequence that can be used as solutions for n12;
second n12 solution sequence calculating means for calculating the cell unit quantities n12 based on a P1′
setting by setting P1′
to include factors relatively prime with P1, generating two basic units P′
(0) and P′
(2) having the same differential with P1′
, with one less than P1′ and
the other greater, using the same means used for P1, generating P′
(0) and P′
(2) tables condensed to two rows and three columns, calculating the residue class of n12 mod P1′
based on the totaled values in the P′
(0) and P′
(2) tables and the basic units P1′
, 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 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 P1 setting and the solution sequence for n12 based on the P1′
setting found by the first and second solution n12 sequence calculating means, respectively, 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 column and repeating the steps 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. - View Dependent Claims (2, 3, 4, 13)
-
-
5. A computer system configured to generate tabular 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, cause said processor to generate tabular data by causing the processor to perform the steps of;
finding partial data, wherein the values xtj, Pj, and yti are known quantities and the cell data sij 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 means, setting P1 to the basic units Pj of the totaled value xtj in the selected column, and generating two basic units P(0) and P(2) having the same differential with P1, but one being less than P1 and the other greater;
creating a 2-row, 3-column condensed table using P(0) by setting a totaled value yt1′
in the first row of a P(0) table to the value of yti in the selected row, setting a totaled value yt2′
in the second row to the total of all values yt2-ytn of rows not selected;
setting a totaled value xt1′
in the first column of the P(0) table to the value of xtj in the selected row, setting a totaled value xt2′
in the second column to a value found from the expression P(0)(xt2/P2+xt3/P3+ . . . +xtm−
1/Pm−
1) using the totaled values xt2, xt3, xt4, . . . for all columns not selected, but excluding the totaled value xtm in the final column, and setting a totaled value xt3′
in the third column to a value found the expression (P2−
P(0))(xt2/P2)+(P3−
P(0))(xt3/P3)+ . . . +(Pm−
1−
P(0))(xt,m−
1/Pm−
1)+xtm 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 means described above, but using P(2) in place of P(0);
displaying the six cell values xij (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
β
;
x11=−
2(a+b+c)+3d+α
x21=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 s12′ and
s12″
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 s12 in the first row and the second column to the cell s1,m−
1 in the first row and (m−
1)th column but excluding the cell s1m in the final column, according to the equation n12=s12/P2+s13/P3+ . . . +s1,m−
1/Pm−
1;
finding solutions of cell unit quantities n12 based on the P1 setting by calculating the residue class of the cell unit quantities n12 mod P1 based on the totaled values for each of the 2-row, 3-column condensed P(0) and P(2) tables and the basic units P1, 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 P1′
setting by setting P1′
to include factors relatively prime with P1, generating two basic units P′
(0) and P′
(2) having the same differential with P1′
, with one less than P1′ and
the other greater, using the same means used for P1, generating P′
(0) and P′
(2) tables condensed to two rows and three columns, calculating the residue class of n12 mod P1′
based on the totaled values in the P′
(0) and P′
(2) tables and the basic units P1′
, 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 means if a unique solution exists in the overlapping area between the solution sequence for n12 based on the P1 setting and the solution sequence for n12 based on the P1′
setting found by the first and second solution n12 sequence calculating steps, respectively, 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 column and repeating the means 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. - View Dependent Claims (6, 7, 8)
-
-
9. (canceled)
-
10. A method for generating tabular data, comprising the steps of:
-
finding partial data, wherein the values xtj, Pj, and yti are known quantities and the cell data sij 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 means, setting P1 to the basic units Pj of the totaled value xtj in the selected column, and generating two basic units P(0) and P(2) having the same differential with P1, but one being less than P1 and the other greater;
creating a 2-row, 3-column condensed table using P(0) by setting a totaled value yt1′
in the first row of a P(0) table to the value of yti in the selected row, setting a totaled value yt2′
in the second row to the total of all values yt2-ytn of rows not selected;
setting a totaled value xt1′
in the first column of the P(0) table to the value of xtj in the selected row, setting a totaled value xt2′
in the second column to a value found from the expression P(0)(xt2/P2+xt3/P3+ . . . +xtm−
1/Pm−
1) using the totaled values xt2, xt3, xt4, . . . for all columns not selected, but excluding the totaled value xtm in the final column, and setting a totaled value xt3′
in the third column to a value found the expression (P2−
P(0))(xt2/P2)+(P3−
P(0))(xt3/P3)+ . . . +(Pm−
1−
P(0))(xt,m−
1/Pm−
1)+xtm 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 means described above, but using P(2) in place of P(0);
displaying the six cell values xij (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
β
;
x11=−
2(a+b+c)+3d+α
x21=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 s12′ and
s12″
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 s12 in the first row and the second column to the cell s1,m−
1 in the first row and (m−
1)th column but excluding the cell s1m in the final column, according to the equation n12=s12/P2+s13/P3+ . . . +s1,m−
1/Pm−
1;
finding solutions of cell unit quantities n12 based on the P1 setting by calculating the residue class of the cell unit quantities n12 mod P1 based on the totaled values for each of the 2-row, 3-column condensed P(0) and P(2) tables and the basic units P1, 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 P1′
setting by setting P1′
to include factors relatively prime with P1, generating two basic units P′
(0) and P′
(2) having the same differential with P1′
, with one less than P1′ and
the other greater, using the same means used for P1, generating P′
(0) and P′
(2) tables condensed to two rows and three columns, calculating the residue class of n12 mod P1′
based on the totaled values in the P′
(0) and P′
(2) tables and the basic units P1′
, 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 means if a unique solution exists in the overlapping area between the solution sequence for n12 based on the P1 setting and the solution sequence for n12 based on the P1′
setting found by the first and second solution n12 sequence calculating steps, respectively, 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 column and repeating the means 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. - View Dependent Claims (11, 12, 14)
-
-
15. (canceled)
Specification