JP2021128621A - Data processing support device and data processing support system - Google Patents

Abstract

To simplify data processing of a database.SOLUTION: A data processing support device 20 uses a spreadsheet file 250 to support the processing of data managed in a database 11. The data processing support device 20 includes a control unit 24 and an output unit 22. The control unit 24 generates storage position information indicating the storage position of data extracted from the database 11 in the spreadsheet file 250, and stores the data based on the generated storage position information. The control unit 24 generates the storage position information based on a start position of a storage area defined in advance in the spreadsheet file 250 and a final position where the data is stored in the storage area of the spreadsheet file 250. The output unit 22 outputs the spreadsheet file 250 in which the data is stored.SELECTED DRAWING: Figure 3

Description

The present disclosure relates to a data processing support device and a data processing support system.

When creating a document such as a product specification or a SPEC table, the specification value of the product may be extracted from the database and posted to the document. However, the posting work often takes time due to the occurrence of rework due to the occurrence of a posting error, the check work after posting, and the like. In addition, database operations are often difficult for general users who do not have knowledge of databases. In order to deal with this problem, a technique has been proposed that supports the input / output work of database data by using a spreadsheet system. For example, Patent Document 1 discloses a data input / output device that inputs / outputs data between a database and a form of spreadsheet software using a template of spreadsheet software created by a user. This data input / output device transfers the database data to the template created by the user according to the input / output definition created by the user, and when the template data is modified, it is based on the template data. Update the database.

According to the data input / output device disclosed in Patent Document 1, the data managed in the database is taken into spreadsheet software that general users are accustomed to operating, and operations such as editing and writing back are performed. It becomes possible.

Japanese Unexamined Patent Publication No. 2012-123607

In the technique disclosed in Patent Document 1, it is necessary to create a template and an input / output definition when inputting / outputting data. However, the creation and operation of templates and input / output definitions is burdensome and inconvenient for general users who are not familiar with the structure and operation of databases.

The present disclosure has been made in view of the above problems, and an object of the present disclosure is to simplify the processing of database data.

In order to achieve the above object, the data processing support device of the present disclosure uses a spreadsheet file to support the processing of data managed in a database. The data processing support device includes a control unit and an output unit. The control unit generates storage position information indicating the storage position of the data extracted from the database in the spreadsheet file, and stores the data based on the generated storage position information. Here, the control unit generates storage position information based on the start position of the storage area defined in the spreadsheet file and the final position in which the data in the storage area of the spreadsheet file is stored. do. The output unit outputs a spreadsheet file in which the data is stored.

According to the present disclosure, storage position information indicating a position for storing data managed in a database is generated, and the data is stored in a spreadsheet file. Therefore, processing the data in the database becomes easier.

Block diagram showing the configuration of the data processing support system according to the first embodiment The figure which shows the structure of the database which concerns on Embodiment 1. A block diagram of a data processing support system showing the configuration of the data processing support device shown in FIG. 1 in detail. A flowchart showing a data extraction process according to the first embodiment. The figure which shows an example of the data file which concerns on Embodiment 1. The figure which shows an example of the template which concerns on Embodiment 1. The figure which shows an example of the template which concerns on Embodiment 1. The figure which shows the template which incorporated the product-related value group into the template shown in FIG. 6B. A flowchart showing a data acquisition process according to the first embodiment. A flowchart showing a storage position information acquisition process according to the first embodiment. A flowchart showing a modified example of the storage position information acquisition process according to the first embodiment. Block diagram showing the configuration of the data processing support system according to the second embodiment The figure which shows an example of the rule setting screen which concerns on Embodiment 2. The figure which shows an example of the data sheet which concerns on Embodiment 2. Block diagram of the data processing support system according to the third embodiment The figure which shows an example of the filtering definition sheet which concerns on Embodiment 3. The figure which shows an example of the data sheet which concerns on Embodiment 3. A flowchart showing a filtering preparation process according to the third embodiment. The figure which shows an example of the group designation screen which concerns on Embodiment 3. The figure which shows the data sheet after the filtering preparation process is executed with respect to the data sheet of FIG. The figure which shows the data sheet after the filtering function which concerns on Embodiment 3 is executed. The figure which shows an example of the data sheet which concerns on Embodiment 4. A flowchart showing a DB update process according to the fourth embodiment. Flow chart showing data output processing according to the fourth embodiment The figure which shows the modification of the data sheet which concerns on Embodiment 4. A flowchart showing a modified example of the data output process according to the fourth embodiment. Block diagram showing the configuration of the data processing support system according to the fifth embodiment The figure which shows an example of the product sheet which concerns on Embodiment 5.

Hereinafter, embodiments of the data processing support device and the data processing support system according to the present disclosure will be described with reference to the drawings.

[Embodiment 1]
Hereinafter, the data processing support system 100 according to the first embodiment will be described. The data processing support system 100 is a system that uses spreadsheet software to support processing such as reference, editing, and updating of data managed in the database 11. Hereinafter, the database is simply referred to as "DB". The data registered in the DB 11 is arbitrary, but here, it is assumed that the data is related to a plurality of products to be developed. The product to be developed is optional, but in the following description, it is assumed that it is a refrigerator, a washing machine, and the like. Hereinafter, the product to be developed is simply referred to as "product". Information about a product includes specification values that specify specifications such as product external dimensions and product weight, and values related to product specifications. The values related to the specifications include, for example, the development specification number, the revision number, and the like.

As shown in FIG. 1, the data processing support system 100 uses the DB server 10 that stores the DB 11 and spreadsheet software to develop the data managed by the DB 11 into a form and perform processing such as editing. A data processing support device 20 is provided.

The DB server 10 includes a DB storage unit 12 that stores the DB 11, and a DB management unit 13 that performs processing such as search, extraction, and update, and communication with an external device for the data stored in the DB 11.

As illustrated in FIG. 2, the DB 11 manages the value V1 relating to a plurality of products and the identification name S1 indicating the item name of each value V1 in association with each other.

The DB 11 manages the values V1 of a plurality of products on a record-by-record basis. Hereinafter, the value V1 may be generically described as "product-related value group 111".

The identification name S1 is a label for identifying the value V1 of each field of the record. For the identification name S1, a combination of alphabets, numbers, and the like is used according to the specifications of DB11.

In the example shown in FIG. 2, the identification name S1 is "UniKey" indicating the identification symbol of the record, "DDN" meaning the identification number of the specification, "DDR" meaning the revision number of the specification, and the model name of the product. "MODEL" which means "MODEL", "SERIES" which means the series name of the product, "PF1" and "PF2" which means the frequency of the power supply used by the product, "PV1" which means the voltage of the power supply, and the height of the product. "HEIGHT" which means size, "WIDE" which means width size of product, "DEPTH" which means depth of product, "WEIGHT" which means weight of product, "COLOR" which means color of product, and Product color Mansell No. Includes "MUMSELL" which means. The identification names S1 are arranged in this order in the direction in which the rows extend. Hereinafter, the information indicating the plurality of identification names S1 will be referred to as "identification name information 112".

Therefore, for example, in the record of "UniKey" = 15, the identification number of the specification is "XX-1000", the revision number is "B", the model name of the product is "XXXXX-1", and the series name of the product is "S". -18-001 ", power supply frequency" 50Hz or 60Hz ", voltage" 100V ", height size" 200mm ", width size" 400mm ", product depth" 300mm ", product weight" "4 kg", the product color is "ivory", and the product color Mansell No. Is "3Y7.8 / 1.1".

On the other hand, as shown in FIG. 3, the data processing support device 20 described with reference to FIG. 1 communicates between the operation unit 21 that accepts operations, the display unit 22 that displays images, and the DB server 10. It includes a communication unit 23 for performing data processing, a control unit 24 for controlling the operation of the data processing support device 20, and a storage unit 25 for storing data. The display unit 22 and the communication unit 23 are examples of output units.

The operation unit 21 includes, for example, a keyboard, a mouse, and the like.

The display unit 22 is composed of a liquid crystal display, an organic EL (Organic Electroluminescence) display, and the like, and displays an image based on the image data.

The communication unit 23 includes, for example, a network adapter, and communicates with the DB management unit 13 via the network.

The control unit 24 executes a data processing operation by executing a program stored in the storage unit 25, including a processor.

The storage unit 25 stores programs, files, and the like executed by the control unit 24. The program includes a spreadsheet program, a data processing support program for supporting data processing, and the like. The data processing support program is added to the spreadsheet software in order to extend the functions of the spreadsheet software.

The file is referenced, generated, or edited when the control unit 24 executes the program. The file includes a form file 250 used in spreadsheet software. The form file 250 is an example of a spreadsheet file.

The form file 250 includes a template 251 designed in advance for importing and editing the data registered in the DB 11.

As shown in FIG. 6A, the template 251 is composed of forms used in spreadsheet software, and is arranged in the row direction DR, which is the direction in which rows are arranged, and in the column direction DC, which is the direction in which columns are arranged. Contains multiple cells that have been created.

The template 251 includes a DB item column 251d, a commentary item column 251b, and a value storage column 251a. The value storage field 251a is an example of a storage area.

The value storage field 251a is an area in which the data extracted from the DB 11, that is, the value V1 is expanded in the storage direction in record units. In the present embodiment, the storage direction is the row direction DR. Each value V1 is stored in a corresponding label, that is, a cell in the same column as the cell in which the identification name S1 is stored.

In the DB item column 251d, a label indicating an item having a value V1 registered in DB 11, that is, an identification name S1, is sequentially stored in each cell in the row direction DR.

The commentary item column 251b is an area for inputting a value for explaining the identification name S1 which is difficult for a user who is not good at knowledge of the DB to grasp, and is designed for each DB 11. The explanatory item column 251b includes a classification column 251e, an item column 251f, and a unit column 251g.

The classification column 251e is an area for specifying whether the value V1 specified by the identification name S1 stored in the cells of the same column is a required item or an optional item. The blank means that the value V1 specified by the identification name S1 in the same column is an optional item.

The item column 251f is for explaining what kind of value V1 the value V1 specified by the identification name S1 stored in the cells of the same column means by dividing it into a large item, a medium item, and a small item. The explanatory information K1 for explaining the identification name S1 is input as a value in the area of. That is, the explanatory information K1 is associated with the identification name S1. The explanatory information K1 is expression information that is easier for the user to understand than the identification name S1.

The unit column 251g is an area indicating the unit of the numerical value when the value V1 specified by the identification name S1 stored in the cells of the same column is a numerical value.

Further, the template 251 further includes an import button 251c for instructing the import of the record registered in the DB 11.

FIG. 6B shows an example of the template 251 customized according to the table structure of the DB 11 described with reference to FIG.

In the example shown in FIG. 6B, labels indicating data items registered in DB 11, that is, identification names S1 "UniKey" to "MUMSELL" are expanded in the row direction DR of the DB item column 251d.

In the classification column 251e of the commentary item column 251b, the values V1 specified by the identification names S1 "UniKey", "DDN", and "DDR" are indispensable, and the identification names S1 "UniKey", "DDN", and "DDR" are required. A value V1 other than the value V1 specified by "" is arbitrary.

The item column 251f of the explanatory item column 251b indicates, for example, that the identification name S1 "DDN" is the identification number of the specification. Further, the identification name S1 "HIGHT" indicates a height which is one of the external dimensions of the product. Further, the unit column 251 g indicates that the unit of the identification name S1 “HIGHHT” is “mm”. By referring to the explanation item column 251b, even a user who is not good at the structure of the DB 11 can easily grasp the meaning of the value V1 indicated by each identification name S1.

Further, the value storage field 251a is defined in the 7th to 20th lines in which the identification name S1 is set. However, the upper limit of the size of the column direction DC is set in advance.

Next, a process of extracting the records registered in the DB 11 from the DB 11 and importing the records into the template 251 for editing by using the data processing support device 20 having the above configuration will be described.

First, with reference to FIG. 4, a data extraction process for extracting the data to be imported into the template 251 from the DB 11 will be described. When the control unit 24 of the data processing support device 20 receives a data extraction instruction from the user via the operation unit 21, the control unit 24 starts the data extraction process shown in the flowchart of FIG.

When the control unit 24 starts the data extraction process, the control unit 24 accepts the input of the search condition (step S101). The data extraction device 30 causes the display unit 22 to display a search condition input screen including, for example, a search keyword input field, an excluded keyword input field, a condition selection field, and a search start button. The user inputs keywords such as a model number and a development specification number as search conditions on the search condition input screen.

The control unit 24 notifies the DB management unit 13 of the DB server 10 of the received search condition via the communication unit 23 (step S102). The DB management unit 13 detects a record that matches the search condition by searching for the corresponding record from the records registered in the DB 11 based on the search condition notified from the control unit 24. Specifically, when the user inputs, for example, the keyword "DDN = XX-1000" as a search condition, the DB management unit 13 searches the DB 11 shown in FIG. 2, and "DDN" is "XX-1000". , That is, "Unikey" is "15", "102", "103", "104". .. .. Detect records.

The DB management unit 13 transmits the detected result record, that is, the data of the record matching the search condition to the control unit 24. Specifically, "Unikey" is "15", "102", "103", "104". .. .. The record data of is transmitted to the control unit 24.

The control unit 24 presents a record matching the search condition to the user by displaying a list of records on the display unit 22 based on the data received from the DB management unit 13 (step S103). Specifically, "Unikey" is "15", "102", "103", "104". .. .. Is displayed on the display unit 22 and presented to the user.

When the user specifies a record to be imported from the presented records, the control unit 24 notifies the DB management unit 13 of the record designation by the user (step S104). The DB management unit 13 creates a data file DF including a record specified by the user based on the notification from the control unit 24, and transmits the data of the data file DF to the control unit 24. When the control unit 24 receives the data of the data file DF, the control unit 24 saves the data file DF by storing it in the storage unit 25 (step S105). Specifically, when the user specifies four records in which "Unikey" is "15", "102", "103", and "104" from the presented records, the DB management unit 13 will perform. , As shown in FIG. 5, a data file DF containing the specified four records is generated. The DB management unit 13 transmits the generated data of the data file DF to the control unit 24, and the control unit 24 stores the received data of the data file DF in the storage unit 25.

In this embodiment, a comma may be used as the value V1. Therefore, in the data file DF, a tab is used as a delimiter between adjacent fields, for example, between "MODEL" and "SERIES". As a result, it is possible to prevent the comma included in the value V1 from being erroneously determined as a delimiter. If there is a possibility that tabs are included in a part of the value V1, a comma-separated format may be adopted as the delimiter format.

Next, the process of importing each record output to the data file DF into the template 251 will be described with reference to FIGS. 8 to 10. In the examples shown in FIGS. 8 to 10, the user opens the template 251 by operating the operation unit 21 of the data processing support device 20. Here, the user opens the template 251 customized for DB 11 described with reference to FIG. 6B in order to fetch the record registered in DB 11. When the user opens the template 251 and operates the import button 251c included in the template 251. In response to this pressing operation, the control unit 24 starts the data acquisition process shown in the flowchart shown in FIG.

When the control unit 24 starts the data acquisition process, the control unit 24 displays a list of at least one data file DF stored in the storage unit 25 on the display unit 22, and accepts the designation of any of the data file DFs (step S201). ..

When any of the data file DFs is specified, the control unit 24 extracts a record from the designated data file DF and stores it in the first storage area of the internal memory (step S202).

Next, the control unit 24 specifies an empty string in the value storage field 251a of the template 251 in order to specify the storage destination of each record (step S203). In order to specify the empty string, the control unit 24 extracts the data in the value storage field 251a of the template 251 and stores it in the second storage area of the internal memory.

Next, the control unit 24 acquires the record storage position indicating the record storage position (step S204). The control unit 24 acquires by generating record storage position information indicating a record storage position based on the information stored in the storage unit 25. The record storage position is an example of the storage position, and the record storage information is an example of the storage position information. In the present embodiment, first, as shown in FIG. 9, the control unit 24 is a value obtained by aggregating the values of the cells arranged in the storage direction, that is, the row direction DR, sequentially from the start column PS. Find the value of the aggregate expression. The start column PS is defined in the template 251 and is the I column in the template 251 of FIG. 6B. The start row PS is an example of the start position.

Therefore, the control unit 24 obtains the aggregated value of the values of all the cells in the value storage column 251a of the I column, that is, the sum total when the data of each cell is viewed as a numerical value (step S301). If the value of the aggregation formula is other than "0", the control unit 24 sets the columns to be aggregated by J, K, L. .. .. The aggregated value is sequentially obtained while moving to, and the column in which the value of the aggregated expression is "0" is acquired.

The control unit 24 specifies the column immediately before the column in which the value of the aggregation formula becomes “0” as the final column PE in which the data is stored (step S302). In other words, the control unit 24 acquires the final column PE based on the value obtained by aggregating the values of the cells arranged in the storage direction. The final row PE is an example of the final position. In the example shown in FIG. 6B, the position where the aggregated value is "0" is "column I", so the control unit 24 specifies "column H" as the final column PE.

When the last column PE is acquired, the control unit 24 determines whether or not the last column PE is before the first column, which is the first column of the value storage column 251a. If the last column PE <third column, it means that the value V1 is not stored in the value storage column 251a. On the other hand, if the last column PE> = column I, it means that the value V1 is stored in the value storage column 251a.

Subsequently, the control unit 24 determines whether or not the record to be imported is the first record (step S303). The first record is the first record stored in the template 251. When the control unit 24 determines that the record to be imported is the first record (step S303; Yes), the control unit 24 determines the start column PS as the record storage position (step S304), that is, the seventh row of the I column. The cell of is determined as the head, the process returns to the process shown in FIG. 8, and the value V1 of the record is sequentially stored in the row direction DR (step S205). On the other hand, when the control unit 24 determines that the record to be imported is not the first record (step S303; No), the control unit 24 determines the next column of the last column PE as the record storage position (step S305), that is, (step S305). Last column PE + 1) The cell in the 7th row of the column is determined as the head, the process returns to the process shown in FIG. 8, and the record value V1 is sequentially stored in the row direction DR (step S205).

Next, the control unit 24 determines whether or not all the records stored in the first storage area from the designated data file DF are stored in the value storage field 251a of the template 251 (step S206). When the control unit 24 determines that unstored records remain (step S206; No), the process returns to step S204. On the other hand, when the control unit 24 determines that all the records are stored in the template 251 (step S206; Yes), the control unit 24 ends the data acquisition process. As a result, as shown in FIG. 7, the values V1 of the plurality of records, that is, the product-related value group 111 are incorporated into the template 251.

The template 251 after the product-related value group 111 is imported can be processed as a data sheet or a form of spreadsheet software. Hereinafter, the template 251 after the product-related value group 111 is incorporated may be referred to as a data sheet 251.

The user can store the template 251 in the storage unit 25 by giving it a desired name. In addition, the user can edit, refer to, and the like the product-related value group 111 on the template 251.

The first embodiment has been described above. Spreadsheet software is widely used, and many users are accustomed to operating spreadsheet software. On the other hand, the operation on the DB 11 requires specialized knowledge. Therefore, in order to perform an operation on the DB 11, it is necessary to acquire knowledge about the DB 11. The data processing support system 100 of the present embodiment incorporates the product-related value group 111 managed by the DB 11 into the template 251 of the form file 250 using spreadsheet software. Therefore, the user can easily view and edit the product-related value group 111. As a result, the processing of data for the DB 11 becomes easy, and the convenience of the user is improved.

Further, in the DB 11, the simplified identification name S1 tends to be used for each field of the record due to the specifications, the limitation of the storage area, and the like. Therefore, the user needs to memorize what the identification name S1 represents, that is, the meaning of the identification name S1. On the other hand, in the present embodiment, since the template 251 includes explanatory information K1 for explaining each identification name S1, the meaning of each identification name S1 and the value V1 can be easily grasped.

In the present embodiment, the DB 11 is stored in the DB server 10, but the DB 11 may be stored in the storage unit 25 included in the data processing support device 20.

Further, in the present embodiment, the DB management unit 13 generates the data file DF, but the control unit 24 may generate the data file DF. For example, the template 251 further has a button for generating the data file DF, and the data file DF may be generated by the user pressing the button for generating the data file DF. When the control unit 24 generates the data file DF, the DB server 10 can omit the DB management unit 13, and the configuration of the data processing support system 100 is simplified.

Further, in the present embodiment, the record extracted from the DB 11 is stored in the data file DF and then transmitted to the data processing support device 20, but it is sufficient if the extracted record can be transmitted to the data processing support device 20, and the means thereof is arbitrary. be.

Further, in the present embodiment, the configuration in which one DB 11 is provided has been described, but the number of DB 11 is not limited to one and may be plural. The plurality of DB 11s may be provided for each product having a different type of value V1, such as a refrigerator, an air conditioner, and a TV, that is, a product having a different type as a specification value.

(Modification example)
The records extracted from the DB 11 may be duplicated in the first storage area of the internal memory. When records are duplicated in the first storage area of the internal memory, the same record is stored in the value storage field 251a according to the flowcharts shown in FIGS. 8 and 9. Expanding two identical records in template 251 causes an error. Therefore, when the same record is duplicated, it is desirable to overwrite the previous record and leave only the latest record in the template 251.

Hereinafter, the processing of the modified example that enables such selective expansion processing will be described with reference to FIG.

In this example, as shown in FIG. 10, when the control unit 24 determines in step S303 that the record to be fetched is not the first record (step S303; No), the same record as the record fetched this time is obtained. , It is determined whether or not the value is already stored in the value storage field 251a of the template 251 (step S401). Whether or not the records are the same is determined by whether or not the UniKye of the records match.

When the control unit 24 determines that a record having the same UniKey as the UniKey of the record to be expanded this time is stored in the value storage field 251a of the template 251 (step S401; Yes), the storage position is set to the template 251. The column of records determined to be the same is determined (step S402). As a result, the new record is overwritten with the old code in the process of step S205 of FIG.

On the other hand, when the control unit 24 determines that the same record does not exist (step S401; No), the control unit 24 determines the next row of the last row PE as the storage position (step S305).

According to the storage position acquisition process shown in FIG. 10, when a plurality of substantially the same records exist, the latest record is overwritten with the old record. Therefore, the value V1 stored in the template 251 can be set to the latest value V1.

[Embodiment 2]
Next, the data processing support system 100 according to the second embodiment will be described with reference to FIGS. 11 to 13. The second embodiment is different from the first embodiment in that the location where the value V1 is changed is notified in the data sheet 251. Hereinafter, the second embodiment will be described focusing on the differences from the first embodiment.

As shown in FIG. 11, in the data processing support system 100 according to the second embodiment, the form file 250 further includes an unedited data sheet 252 which is a duplicate of the unedited data sheet 251. The product-related value group 111 included in the unedited data sheet 252 is updated every time the product-related value group 111 is incorporated into the data sheet 251 described in the first embodiment. The data that matches the product-related value group 111 that is imported into the data sheet 251 is imported into the unedited data sheet 252.

The control unit 24 notifies the user of the changed part based on the difference between the unedited data sheet 252 and the data sheet 251. Specifically, the control unit 24 acquires the difference between the first cell and the second cell, and based on the difference between the first cell and the second cell, determines the position of the cell whose value V1 is changed. Acquires the changed part information of the indicated changed part, and notifies the user of the changed part based on the changed part information. The first cell is a cell of the data sheet 251 and the second cell is a cell of the unedited data sheet 252 at the same position as the cell of the data sheet 251. The control unit 24 notifies the user of the changed part by changing the color of the cell which is the changed part to a color different from the color of the cell before the change.

The control unit 24 notifies the user of the changed part by using the "conditional formatting rule" function. The conditional formatting rule can be set on the rule setting screen G1 described with reference to FIG.

FIG. 12 is a diagram showing an example of the rule setting screen G1 according to the second embodiment. As shown in FIG. 12, the rule setting screen G1 has an application destination specification field F11 for designating the application destination of the conditional format rule, a condition setting field F12 for setting the application condition of the conditional format rule, and a conditional format rule. Includes a formatting button B11 for formatting cells to which is applied.

In the application destination designation field F11, the range of the value storage field 251a in which the value V1 in the data sheet 251 is stored is set. In the condition setting field F12, a conditional statement as to whether or not the value of the first cell is equal to the value of the second cell is set as an applicable condition. In the present embodiment, the cell color change is set as the format of the cell to which the conditional formatting rule is applied. The user sets the color of the cell before the value is changed to, for example, "white", and the color of the cell whose value is changed is a color that is easy for the user to identify, such as "yellow". Can be set to. This makes it easier to understand the changed part.

FIG. 13 is a diagram showing an example of the data sheet 251 according to the second embodiment. Note that the hatching shown in FIG. 13 indicates that the color of the cell has been changed to the color of the changed cell, that is, it is different from the color of other cells. In the data sheet 251 shown in FIG. 13, the value V1 described with reference to FIG. 7 has been changed. Specifically, the value of the cell in row 14 and column J has been changed from "100" to "200".

Conditional formatting rules described with reference to FIG. 12 are set in each cell of the value storage field 251a of the data sheet 251. In the conditional formatting rule, a formatting rule is set to change the color of the cell when the value of the cell in the data sheet 251 is different from the value of the cell at the same position in the unedited data sheet 252. As a result, as shown in FIG. 13, the value of the cell in the 14th row and J column is changed to a color different from the color of the cell before the change, and the user is notified of the changed part.

The second embodiment has been described above. In a configuration in which the changed part is not notified to the user when the value V1 is changed, the user needs to check whether or not all the values V1 in the data sheet 251 are correct. However, according to the present embodiment, since the changed part is notified to the user, the user only needs to check the notified changed part, and the time required for the user's check is shortened. In addition, the burden of checking by the user is reduced. Therefore, the convenience of the user is improved.

[Embodiment 3]
Subsequently, the data processing support device 20 according to the third embodiment will be described with reference to FIGS. 14 to 20. In the third embodiment, in order to narrow down and display the data on the data sheet 251 by using the filtering function of the spreadsheet software, the data sheet 251 is prepared for filtering based on the filtering definition sheet 253. Is different from the first and second embodiments. Hereinafter, the third embodiment will be described focusing on the differences from the first and second embodiments.

As shown in FIG. 14, in the data processing support system 100 according to the third embodiment, the form file 250 further includes a filtering definition sheet 253 in which the relationship between the identification name S1 and the filtering group is defined. The user defines in the filtering definition sheet 253 the association between the identification name S1 of the value V1 filtered by the template 251 when the filtering function is used and the filtering group.

The filtering definition sheet 253 according to the third embodiment will be described with reference to FIG.

As shown in FIG. 15, the filtering definition sheet 253 includes an identification commentary display field 253a in which the identification name S1 and the commentary information K1 are displayed, and a group setting field 253b for defining the relationship between the filtering group and the identification name S1. And include. The identification commentary display field 253a includes an identification display field 253c in which the identification name S1 is displayed and a commentary display field 253d in which the commentary information K1 is displayed. In FIG. 15, the range of the identification display column 253c is indicated by a one-dot chain line, and the range of the explanation display column 253d is indicated by a two-dot chain line.

The group setting field 253b includes a group display field 253e in which the filtering group name FG1 that can be arbitrarily determined by the user is displayed, and a definition field 253f for defining the relationship between the identification name S1 and the filtering group. In FIG. 15, the range of the group display column 253e is indicated by the alternate long and short dash line, and the range of the definition column 253f is indicated by the alternate long and short dash line.

The filtering group name FG1 is the name of the filtering group that is filtered by the filtering function of the form file 250. The user can create a plurality of filtering groups, and can define the relationship with the identification name S1 for each filtering group. For example, in the example shown in FIG. 15, in the filtering groups FG1 “DB all items”, “specification items (domestic)”, and “specification items (overseas)”, the values V1 of all the identification names S1 are displayed on the data sheet 251. The filtering group FG1 "power source" is defined so that the value V1 of the identifier S1 relating to the power source is displayed in the data sheet 251.

The definition column 253f is provided for each filtering group name FG1. In the definition field 253f, a blank or "○" is arbitrarily entered by the user depending on whether or not the value V1 of the identification name S1 is displayed in the data sheet 251. In the present embodiment, it is assumed that the blank identification name S1 value V1 is not displayed on the data sheet 251 and the value V1 of the identification name S1 in which "○" is input as a value is displayed on the data sheet 251. do. For example, in the definition field 253f in which the filtering group name FG1 is "power supply", the cell whose identification name S1 is in the same row as "Unikey", "DDN", "DDR", "PF1", "PF2", and "PV1". Since the value "○" is input to, when the filtering function is executed, only these values V1 are displayed on the data sheet 251.

Next, the data sheet 251 according to the third embodiment will be described with reference to FIG.

As shown in FIG. 16, the data sheet 251 includes a filtering button 251h for instructing the execution of the filtering preparation process, a filtering setting field 251k in which a value is input when the filtering preparation process is executed, and a filtering setting field 251k for canceling the filtering. The reset button 251j of the above is further included. The filtering button 251h, the filtering setting field 251k, and the reset button 251j are included in the template 251 in advance.

When the filtering button 251h is pressed, the control unit 24 executes the filtering preparation process based on the filtering definition sheet 253. The filtering preparation process will be described later with reference to FIG.

The filtering setting field 251k is provided for each DB item field 251d. In the present embodiment, the filtering setting field 251k is provided on the same line as the corresponding DB item field 251d.

When the reset button 251j is pressed, the filtering is canceled.

Subsequently, the filtering preparation process according to the third embodiment will be described with reference to FIGS. 17 to 19. FIG. 17 is a flowchart showing a filtering preparation process according to the third embodiment. When the filtering button 251h described with reference to FIG. 16 is pressed, the filtering preparation process is started.

As shown in FIG. 17, when the filtering preparation process is started, the control unit 24 accepts the designation of the filtering group (step S501). Specifically, the control unit 24 causes the display unit 22 to display the group designation screen G2 shown in FIG.

FIG. 18 is a diagram showing an example of the group designation screen G2 according to the third embodiment. As shown in FIG. 18, the group designation screen G2 causes the control unit 24 to accept the group designation field S21 in which the filtering group name FG1 acquired from the filtering definition sheet 253 is displayed in a list and the designation of the filtering group. Includes execute button B21 for. The broken line shown in FIG. 18 indicates that the "power supply" group is selected. When the filtering group is selected in the group designation field S21 and the execution button B21 is pressed, the control unit 24 accepts the designation of the filtering group.

When the control unit 24 receives the designation of the filtering group, the control unit 24 stores the value in the filtering setting field 251k of the data sheet 251 described with reference to FIG. 16 (step S502 in FIG. 17), and ends the filtering preparation process.

FIG. 19 is a diagram showing a data sheet 251 after the filtering preparation process is executed on the data sheet 251 of FIG. The data sheet 251 shown in FIG. 19 shows the data sheet 251 when the "power supply" group is designated as the filtering group to be filtered.

When the "power supply" group is designated as the filtering group to be filtered, the control unit 24 sets a value in the filtering setting field 251k corresponding to the identification name S1 defined in the designated filtering group, as shown in FIG. Store "○". Specifically, the value "○" is in the filtering setting field 251k associated with the identification name S1 "Unikey", "DDN", "DDR", "PF1", "PF2", and "PV1". Stored. On the other hand, the filtering setting field 251k corresponding to the identification name S1 not defined in the designated filtering group remains blank.

The value stored in the filtering setting field 251k is not limited to "○" and may be a character, a character string, or the like that can be filtered by spreadsheet software. The value stored in the filtering setting field 251k may or may not match the value in the identification explanation display field 253a of the filtering definition sheet 253. When the control unit 24 stores the value in the filtering setting field 251k, the control unit 24 ends the filtering preparation process.

FIG. 20 is a diagram showing a data sheet 251 after the filtering function according to the third embodiment is executed. Note that FIG. 20 shows the data sheet 251 after the filtering function is executed in the data sheet 251 shown in FIG.

As shown in FIG. 20, when the filtering function is executed, the product-related value group 111 is filtered based on the values stored in the filtering setting field 251k. The value specified as the target of filtering in the filtering function is arbitrary, but in the present embodiment, the user specifies the cell in which the value of the filtering setting field 251k is "○" as the target of filtering. When the user specifies a cell whose value in the filtering setting field 251k is "○" as a filtering target, only the value V1 in which the value "○" is stored in the filtering setting field 251k is displayed in the data sheet 251. NS. That is, the value V1 of the identification name S1 in which the value "○" is input in the definition field 253f described with reference to FIG. 15 is the data sheet 251 when the defined filtering group is specified and the filtering function is executed. Is displayed in. On the other hand, the value V1 of the identification name S1 in which the value of the definition column 253f is blank is not displayed in the data sheet 251 when the defined filtering group is specified and the filtering function is executed.

The third embodiment has been described above. According to this embodiment, even if the value V1 is large, only the value V1 required by the user can be displayed on the data sheet 251. This improves user convenience.

Further, in a configuration in which the filtering definition sheet 253 is not provided, in order to provide a plurality of filtering groups, filtering setting fields are required for the number of filtering groups, and the number of columns in the data sheet 251 increases. As the number of columns in the data sheet 251 increases, it takes time and effort to search for necessary information. However, according to the present embodiment, a plurality of filtering groups can be provided only by providing one filtering setting field 251k in the data sheet 251. The user can select a desired filtering group from the plurality of filtering groups. You can choose. Therefore, the convenience of the user is improved.

[Embodiment 4]
Subsequently, the data processing support system 100 according to the fourth embodiment will be described with reference to FIGS. 21 to 23. The fourth embodiment is different from the first to third embodiments in that the DB 11 can be updated by changing the value V1 stored in the value storage field 251a of the data sheet 251. Hereinafter, the differences between the fourth embodiment and the first to third embodiments will be described.

In the present embodiment, the control unit 24 updates the DB 11 based on the product-related value group 111 included in the data sheet 251, that is, the change with respect to the value V1. Hereinafter, the process of updating the DB 11 will be referred to as a “DB update process”.

In the DB update process, when the value V1 of the data sheet 251 is changed and the output button 251 m shown in FIG. 21 is pressed, the control unit 24 has the changed value V1 among the values V1 managed by the DB 11. Update to the changed value. Further, when a new value is added to the data sheet 251 as a value V1, the control unit 24 adds the added value V1 to the DB 11 as a new record.

FIG. 21 is a diagram showing an example of the data sheet 251 according to the fourth embodiment. As shown in FIG. 21, the data sheet 251 according to the fourth embodiment further includes an output button 251 m for instructing output to the data file DF using the product-related value group 111 included in the data sheet 251 as data. The output button 251m is included in the template 251 in advance. When the output button 251m is pressed by the user, the control unit 24 updates the changed value V1 managed by the DB 11 to the changed value, or adds the added value V1 to the DB 11 as a new record. The DB update process is started as the process to be performed.

FIG. 22 is a flowchart showing the DB update process according to the fourth embodiment. As shown in FIG. 22, when the DB update process is started, the control unit 24 executes a data output process of outputting the product-related value group 111 included in the data sheet 251 to the data file DF as data (step S601). Details of the data output process will be described later with reference to FIG. 23. In the present embodiment, in the data output process, all the values of the product-related value group 111 included in the data sheet 251, that is, the data of all the values V1 are output to the data file DF. The value V1 related to one product is output to the data file DF as one record.

Next, the control unit 24 determines whether or not the record to be overwritten exists in the DB 11 (step S602). The control unit 24 determines whether or not the record to be overwritten exists by searching the DB 11 for a record whose Unikey value matches the Unikye value of the record output to the data file DF. When the control unit 24 detects from the DB 11 a record whose value matches the value of Unikye is Unikye, it determines that a record to be overwritten exists, and sets a record whose value matches the value of Unikye to Unikye in DB11. If it cannot be detected from the inside, it is determined that the record to be overwritten does not exist.

When the control unit 24 determines that the record to be overwritten exists (step S602; Yes), the control unit 24 overwrites the value V1 of the record to be overwritten with the value V1 of the record output to the data file DF (step S603). On the other hand, when the control unit 24 determines that the record to be overwritten does not exist (step S602; No), the control unit 24 adds a new record to the DB 11 (step S604). Specifically, the control unit 24 adds the value V1 of the record output from the data file DF to the DB 11 as the value V1 of the new record.

When the control unit 24 executes the process of overwriting the value V1 of the record to be overwritten (step S603) or adding a new record (step S604), the value V1 of all the records output to the data file DF is reflected in the DB 11. It is determined whether or not it has been done (step S605). When the control unit 24 determines that the reflection of the values V1 of all the records output to the data file DF in the DB 11 is incomplete (step S605; No), the DB update process returns to step S602. On the other hand, when the control unit 24 determines that the values V1 of all the records output to the data file DF are reflected in the DB 11 (step S605; Yes), the control unit 24 ends the DB update process.

Subsequently, the data output process according to the fourth embodiment will be described with reference to FIG. 23.

As shown in FIG. 23, the control unit 24 acquires the value storage field 251a that stores the output target value V1, that is, the output target position information indicating the position where the output target value V1 is stored (). Step S701). The output target position information is information indicating the output target position, and the output target position indicates the position where the output target value V1 is stored. The control unit 24 acquires output target position information from the range determined by the start row PS and the last row PE described in the first embodiment. In the example shown in FIG. 21, the output target position is indicated by any column number from the I column, which is the start column PS, to the L column, which is the last column PE.

When the control unit 24 acquires the output target position information, the control unit 24 outputs the value V1 of the output target position indicated by the output target position information to the data file DF (step S702). Specifically, the control unit 24 acquires the range in which the value of one record is stored and outputs one record to the data file DF. The control unit 24 outputs the end position of the value V1 at the output target position, the value up to 18 lines in the example shown in FIG. 21, as one record to the data file DF. The information indicating the end position is defined in advance in, for example, the form file 250.

Next, the control unit 24 determines whether or not all the data of the value V1 included in the data sheet 251 has been output to the data file DF (step S703). Specifically, the control unit 24 determines whether or not all the data of the value V1 included in the data sheet 251 has been output by determining whether or not the output target position matches the final column PE.

When the control unit 24 determines that the output of all the data having the value V1 included in the data sheet 251 is incomplete (step S703; No), the output target is set to the next position, and in the example shown in FIG. 21, the following After moving to the column (step S704), the data output process returns to step S701.

On the other hand, when the control unit 24 determines that all the data of the value V1 included in the data sheet 251 has been output (step S703; Yes), the data output process ends.

The fourth embodiment has been described above. According to the fourth embodiment, the DB 11 can be easily updated only by changing the value V1 or adding the value V1 in the data sheet 251 which is the form file 250. Therefore, the processing of the data managed by the DB 11 becomes easy, and the convenience of the user is improved.

In the fourth embodiment, all the values V1 included in the data sheet 251 are reflected in the DB 11, but the control unit 24 reflects only a part of the data of the value V1 included in the data sheet 251 in the DB 11. You may.

For example, as shown in FIG. 24, the data sheet 251 may further include a reference item designation field 251n for designating whether or not to update with the product-related value group 111 included in the data sheet 251. FIG. 24 is a diagram showing a modified example of the data sheet 251 according to the fourth embodiment.

As shown in FIG. 24, the reference item designation field 251n specifies whether or not the product-related value group 111 managed by the DB 11 is to be updated with the data of the DB 11 by the product-related value group 111 included in the data sheet 251. It is a column for. The reference item designation field 251n includes a plurality of cells in the column direction DC, and each cell of the reference item designation field 251n is associated with one product, that is, one record. In each cell of the reference item designation field 251n, a value indicating whether or not the value V1 of the record in the same column is reflected in the DB 11 is input in the reference item designation field 251n. In the present embodiment, the reference item designation field 251n displays a value of "blank" or "YES" as a pull-down menu when the cell provided with the reference item designation field 251n is clicked. In FIG. 24, cells in rows 5 and columns K are selected, and a pull-down menu is displayed. The user can input the value in the reference item designation field 251n by selecting the value displayed as the pull-down menu.

The control unit 24 updates the DB 11 based on the value specified in the reference item designation field 251n. The control unit 24 reflects the value V1 of the record in the same column as the reference item designation field 251n of the “blank” in DB11, and the value V1 of the record in the same column as the reference item designation field 251n in which the value of “YES” is specified. Is not reflected in DB11. That is, as shown in FIG. 25, the control unit 24 further executes the process of step S801 in the data output process.

FIG. 25 is a flowchart showing a modified example of the data output process according to the fourth embodiment. As shown in FIG. 25, the control unit 24 acquires the value of the reference item designation field 251n associated with the record, and determines whether or not the value of the reference item designation field 251n is blank (step S801).

When the control unit 24 determines that the reference item designation field 251n is blank (step S801; Yes), the control unit 24 proceeds to the process of step S702 and outputs the value V1 of the record associated with the reference item designation field 251n to the data file DF. do. On the other hand, when the control unit 24 determines that the value of the reference item designation field 251n is not blank (step S801; No), the control unit 24 skips step S702 and proceeds to step S703.

As described in the first embodiment, the value V1 of the data sheet 251 can be changed by the user. Therefore, when the user changes the value V1 of the data sheet 251 there is a possibility that the DB 11 is unintentionally updated. However, by providing the reference item designation field 251n in the data sheet 251 it is possible to prevent the DB 11 from being unintentionally updated. Further, it is possible to prevent unnecessary data such as a value added only for reference by the user from being added to the DB 11, and the storage capacity of the DB 11 can be saved.

Further, in the present embodiment, the data output process is started by pressing the output button 251 m, but the method of starting the data output process is not limited to the press operation of the output button 251 m. The data output process may be output from the data sheet 251 to the data file DF by, for example, the user operating a dedicated system for operating the DB 11 such as a workflow. In this case, the user selects the data sheet 251 that outputs the product-related value group 111 in the dedicated system.

[Embodiment 5]
Subsequently, the data processing support system 100 according to the fifth embodiment will be described with reference to FIGS. 26 and 27. The fifth embodiment is different from the first to fourth embodiments in that the product-related value group 111 captured in the template 251 is reflected in the deliverable. Hereinafter, the differences between the fifth embodiment and the first to fourth embodiments will be described.

FIG. 26 is a block diagram showing a configuration of the data processing support system 100 according to the fifth embodiment. As shown in FIG. 26, the data processing support system 100 further includes a printing device 40 that prints based on image data. The printing device 40 is, for example, a multifunction device, a printer, or the like.

The printing device 40 is communicably connected to the communication unit 23 included in the data processing support device 20. The printing device 40 receives a printing instruction from the control unit 24 via the communication unit 23. The control unit 24 transmits the image data to be printed via the communication unit 23 when instructing printing. When the printing device 40 receives a printing instruction, it prints on a sheet such as paper based on the image data transmitted from the control unit 24.

In the present embodiment, the form file 250 further includes a deliverable sheet 254 provided according to the type of deliverable. In the deliverable sheet 254, the value V1 stored in the template 251 is referred to. The deliverable sheet 254 is created in advance.

FIG. 27 is a diagram showing an example of the deliverable sheet 254 according to the fifth embodiment. As shown in FIG. 27, the deliverable sheet 254 includes a plurality of cells in the column direction DC and the row direction DR, and the heading column 254a indicating the contents of the value display column 254b and the value V1 stored in the template 251 are referenced. The value display field 254b to be displayed is included.

The heading column 254a includes a plurality of cells, and character strings such as a large item name, a medium item name, and a unit corresponding to the value V1 displayed in the value display field 254b are input in advance in each cell.

The value display field 254b includes a non-editable field 254c in which the value cannot be edited and an editable field 254d in which the value can be edited.

The non-editable column 254c includes a plurality of cells in the column direction DC and the row direction DR, and each cell is set with, for example, a lock which is a function of spreadsheet software.

A link formula, which is a function of spreadsheet software, is stored in each cell of the non-editable field 254c, and in the link formula, a value storage field 251a in which the value V1 of the data sheet 251 is stored is set as a reference destination. ing. For example, in the 10th row and E column of the deliverable sheet 254, the cell of the 14th row and I column of the data sheet 251 described with reference to FIG. 7 is designated as a reference destination. Further, in the 11th row E column of the deliverable sheet 254, the 12th row I column cell and the 13th row I column cell of the data sheet 251 are designated as reference destinations, and the 12th row I column cell of the data sheet 251 is specified. A link formula is set in which the value "50" of the value "50" and the value "60" of the cell in the 13th row and the I column are combined via "/".

The link formula set in the selected cell is displayed in the formula bar E1 of the spreadsheet software. In the example shown in FIG. 27, 11 rows and E columns are selected, and the formula stored in 11 rows and E columns is displayed in the formula bar E1. The link expression is created in advance by the developer, for example. When the product-related value group 111 is imported into the template 251, the control unit 24 stores the template 251 in which the value V1 indicated by the heading column 254a is stored based on the value input in the heading column 254a, that is, the data. The record storage position information on the sheet 251 may be acquired, and a link expression may be created based on the record storage position information.

In the editable field 254d, for example, items such as tables and figures that are not managed by DB 11 are input by the user.

The user can print the deliverable by the printing device 40 by instructing the control unit 24 to print the deliverable sheet 254.

The fifth embodiment has been described above. According to the present embodiment, the product-related value group 111 stored in the template 251 by using the link formula, that is, the product-related value group 111 managed by the DB 11 by referring to the value V1, is the deliverable sheet. It is displayed at 254. Therefore, as compared with the case where the data of the product-related value group 111 is extracted from the DB 11 and the deliverable sheet is created, the work load on the user is reduced and the convenience of the user is improved.

Further, in the system for operating the DB 11, it is often impossible to change the output format of the data output from the DB 11. However, in the present embodiment, the value V1 stored in the template 251 can be referred to in the deliverable sheet 254 by using the link formula. In the link formula, the values V1 stored in a plurality of cells of the template 251 can be combined. Therefore, the display format of the value V1 stored in the template 251 can be displayed in conformity with the format of the deliverable sheet 254. Further, by using the link type, it is possible to flexibly respond even when the style of the deliverable sheet 254 is changed to, for example, a style for internal use, a style for external use, or the like. Therefore, the convenience of the user is improved.

Further, in the present embodiment, the user can visually confirm the product as a product by printing the product sheet 254. Therefore, for example, it is suppressed that a deliverable in which some characters are not printed is suppressed, and the convenience of the user is improved.

The present disclosure is not limited to the examples of the above-described embodiments, and can be implemented in other embodiments by making appropriate changes.

For example, in the present embodiment, the storage direction is the row direction DR, but the storage direction is not limited to the row direction DR and may be the column direction DC. In the aggregation direction, the row direction DR and the column direction DC are switched according to the storage direction. Further, the positions where the DB item column 251d, the classification column 251e, the item column 251f, the unit column 251g, and the like are provided are changed according to the storage direction.

In addition, the items described in the first to fifth embodiments can be combined as appropriate. Specifically, the form file 250 includes the pre-editing data sheet 252 described in the second embodiment, the filtering definition sheet 253 described in the third embodiment, and the deliverable sheet 254 described in the fifth embodiment. It may be included. Further, the control unit 24 may execute the DB update process described in the fourth embodiment in addition to the filtering preparation process described in the third embodiment.

In the above embodiment, an example of processing the product-related values related to the development target product stored in the DB has been described. In this disclosure, the data and DB to be processed are not limited thereto. The data stored in the DB is arbitrary, and may be a product-related value related to a developed product or a product-related value related to a discontinued product. Furthermore, the product is not limited to products, and may be related to primary industries such as agriculture, fisheries, and forestry, tertiary industries such as commerce, distribution, and service industries, academics, and religion. According to the present disclosure, various data stored in the DB can be easily referred to and edited.

11 ... DB (database), 20 ... data processing support device, 21 ... operation unit, 22 ... display unit, 23 ... communication unit, 24 ... control unit, 25 ... storage unit, 40 ... printing device, 100 ... data processing support system , 111 ... Product-related value group, 112 ... Identification name information, 250 ... Form file, 251 ... Template (data sheet), 251n ... Reference item specification field, 252 ... Unedited data sheet, 253 ... Filtering definition sheet, 254 ... Results Material sheet, DF ... Data file.

Claims (10)

A data processing support device that uses spreadsheet files to support the processing of data managed in a database.
A control unit that generates storage position information indicating a storage position of the data extracted from the database in the spreadsheet file and stores the data based on the generated storage position information.
It is provided with an output unit that outputs the spreadsheet file in which the data is stored.
The control unit stores the data based on a start position of a storage area defined in the spreadsheet file and a final position in the storage area of the spreadsheet file in which the data is stored. Generate location information,
Data processing support device. The data processing support device according to claim 1, wherein the control unit acquires the final position based on a value obtained by aggregating the values of cells arranged in a storage direction in which the data is stored. The data processing support device according to claim 1 or 2, wherein the control unit acquires the data to be stored in the spreadsheet file from a data file generated based on the data extracted from the database. The data processing support device according to any one of claims 1 to 3, wherein the control unit determines and notifies a location where the data stored in the spreadsheet file has been changed. The spreadsheet file is
A data sheet in which the data is stored and
Includes a filtering definition sheet that associates the distinguished name of the data stored in the data sheet with the filtering group.
The data sheet includes a filtering setting field associated with the distinguished name.
The control unit
When one of the filtering groups defined in the filtering definition sheet is specified, a value is set in the filtering setting field associated with the identification name associated with the specified filtering group.
The data processing support device according to any one of claims 1 to 4, wherein the data stored in the data sheet is filtered based on the value stored in the filtering setting field. The data processing support device according to any one of claims 1 to 5, wherein the control unit updates the database based on a change in the data stored in the spreadsheet file. The spreadsheet file includes a reference item specification field in which it is possible to specify whether or not to update the database.
The data processing support device according to claim 6, wherein the control unit updates the database based on the setting of the reference item designation field. The output unit includes a communication unit capable of communicating with an external device.
The external device includes a printing device.
The data processing support device according to any one of claims 1 to 7. The database manages product-related values related to a plurality of products in association with a distinguished name that identifies the product-related values.
The spreadsheet file further contains explanatory information explaining the distinguished name.
The control unit associates the identification name with the explanatory information in the spreadsheet file.
The data processing support device according to any one of claims 1 to 4. The data processing support device according to any one of claims 1 to 9.
With the above database
Equipped with a printing device
The spreadsheet file contains a deliverable sheet containing the data.
The control unit causes the printing device to print the product sheet.
Data processing support system.

Images