JP2002366382A - Data input device, program generator using it, data input method, and program generation method using it - Google Patents

Abstract

PROBLEM TO BE SOLVED: To realize a data input device which inputs data to a general table by a table for exclusive use, a program generator using this device, a data input method, and a program generation method using this method. SOLUTION: The data input device which inputs data to the general table is provided with the table for exclusive use to which data corresponding to the general table is inputted, a reflecting macro program which describes reflection processing of data in the table for exclusive use on the general table, and a spreadsheet processing means which reflects data of the table for exclusive use on the general table on the basis of this reflecting macro program. A program is generated from the general table of the data input device.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention
Regarding a data input device used for creating a test program of an IC tester for testing SI or the like, a program creating device using the same, a data input method, and a program creating method using the same, a dedicated table for inputting data can be provided. The present invention relates to a data input device.

[0002]

2. Description of the Related Art In order to judge the quality of an IC, LSI, or the like, an IC tester applies a voltage or current, measures the current or voltage, and determines whether or not the value is within a standard value.
A test program for performing this determination is, for example, as described in Japanese Patent No. 2591071 or the like.
It is automatically created from a table called a test standard table. Such an apparatus is shown in FIG. 22 and described.

In FIG. 22, a test condition table 1
Consists of a test number (column A), determination conditions (columns B to D), setting conditions (columns E and F), pin numbers (column G), and the like. As the judgment conditions, a minimum value (column B), a maximum value (column C), and a measurement target (column D) for current measurement (im) and voltage measurement (vm) are set. For the setting conditions, the measurement conditions are set, and the measurement mode (E column) and the set value (F column) are set. Here, the measurement mode is set to voltage supply current measurement (vfim) and current supply voltage measurement (ifvm). As the set value, a value to be supplied is set. The pin number indicates a target pin of an IC or an LSI to be tested.

The generator 2 has a test condition table 1
, And generates a program. The test program file 3 includes a group of programs generated by the generator 2.

The operation of such a device will be described below.
The generator 2 reads data from the test condition table 1 and creates a test program. For example, in the second row of the test condition table 1, the test number "
1 ", determination condition" 0.5 uA, 0.7 uA, im ", setting condition" vfim, 5 V ", and pin number" 1 ", a program is generated as follows: tno (1); ) {vfim = 5V; judge (im, 0.5uA, 0.7uA);}

For inputting test conditions, a test condition table 1 is created using spreadsheet software such as Microsoft Excel or the like, and then a test program file 3 is created using a generator 2.

[0007]

In such a device,
In the test condition table 1, a test program is created based on the determined cell positions. Therefore, every time the position of the cell in the test condition table 1 is different, the generator 2
Had to be provided.

Further, since the items for setting the test conditions differ depending on the type of the object to be tested such as an IC and an LSI, if a general-purpose test condition table 1 that can correspond to all the objects to be tested is created, the table becomes redundant. However, there is a problem in that it is difficult to input and that the user does not know what data is necessary.

It is an object of the present invention to realize a data input device capable of inputting to a general-purpose table using a dedicated table, a program creation device using the same, a data input method, and a program creation method using the same.

[0010]

According to a first aspect of the present invention, there is provided a data input device for inputting data to a general-purpose table, comprising: a special-purpose table for inputting data corresponding to the general-purpose table; The present invention is characterized by having a reflection macro program for describing a reflection process on a general-purpose table, and a spreadsheet processing means for reflecting data of the dedicated table on the general-purpose table based on the reflection macro program.

According to a second aspect of the present invention, a program is created from a general-purpose table of the data input device according to the first aspect of the present invention.

According to a third aspect of the present invention, there is provided a data input method for providing a general-purpose table for inputting data and a dedicated table for inputting data corresponding to the general-purpose table, and inputting the data. However, the data of the dedicated table is reflected in the general-purpose table.

A fourth aspect of the present invention is characterized in that a program is created from a general-purpose table of the data input method according to the third aspect of the present invention.

[0014]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a configuration diagram showing one embodiment of the present invention.

In FIG. 1, file 4 is, for example, C
It is recorded on a recording medium such as a D-ROM, a hard disk, or an FD, and includes a general-purpose sheet 41, a dedicated sheet 42, and a definition sheet 4.
3, a corresponding sheet 44, a creation macro program 45, and a reflection macro program 46.

The general-purpose sheet 41 is a general-purpose table, in which test conditions (program conditions) are described in cells, and have redundant parameters covering all test programs, and are configured as shown in FIG. 2, for example. In FIG. 2, column A is a test algorithm (test name), column B is a test number, column C is a category, column D is a setting level of setting conditions,
The rows are the target pins to be tested, the F rows are the variables of the measurement results,
The columns are arithmetic expressions, the H column is the minimum value of the determination condition, the I column is the maximum value of the determination condition, and the J column is the waiting time. Here, the specific content of each item is not a main part of the present invention, and thus the description is omitted.

The dedicated sheet 42 is a dedicated table in which test conditions (program conditions) corresponding to the general-purpose sheet 41 are described in cells, and is configured, for example, as shown in FIGS. The definition sheet 43 is a definition table, which is a sheet setting indicating a sheet setting of the dedicated sheet 41, a cell position of each input field, a correspondence with the general-purpose sheet 41, designation of a display character string, a fixed value writing to the general-purpose sheet 41, and the like. Are described, for example, as shown in FIGS. Here, FIGS. 6 to 8 are the definition sheets 43 of FIGS. 3 to 5, respectively, a is a sheet setting,
b is a cell setting, and c is a description line that is not actually included.
The correspondence sheet 44 is a correspondence table that describes the cell relationship between the general-purpose sheet 41 and the dedicated sheet 42, and is configured, for example, as shown in FIG.

The creation macro program 45 describes, based on the definition sheet 43, the creation process of the dedicated sheet 42 and the creation process of the cell relation in the corresponding sheet 44. The reflection macro program 46 describes, based on the corresponding sheet 44, a reflection process for both the dedicated sheet 42 and the general-purpose sheet 41.

The spreadsheet processing means 5 is, for example, Excel or the like.
It is installed in a computer (not shown), reads the file 4, creates the dedicated sheet 42 based on the creation macro program 45, and reflects both the general-purpose sheet 41 and the dedicated sheet 42 based on the reflection macro program 46. .

The operation of such a device will be described below.
First, the operation of creating the dedicated sheet 42 will be described. FIGS. 10 to 12 are flowcharts showing the operation of the spreadsheet processing unit 5 by the creation macro program 45, which are an overall operation, a sheet setting operation, and a cell setting operation, respectively. Here, the dedicated sheet 42 is a definition sheet 43 using FIG.
Will be described with reference to FIG.

The spreadsheet processing means 5 reads one row from the sheet setting a of the definition sheet 43 by the creation macro program 45 (S1) and determines whether or not the first column is "#" (S2).

Since the spreadsheet processing means 5 is "#algo:", it performs a sheet setting process (S3). Specifically, the dedicated sheet 42 is created with the parameter “IIH” as a name (S 11, S 12). Since “display adrs” is “A 1”, the first character in column A, “prefix” "None", "Parameter""IIH","Postfix""-t
est "," IIH-test "is written (S
13). Then, the spreadsheet processing means 5 outputs the corresponding sheet 44
Then, a new column A is secured, and the parameter "IIH" is written in the row of "#algo:" (S14).

Since all of the operations have not been completed, the spreadsheet processing means 5 returns to the sheet setting a of the definition sheet 43 from the sheet setting a.
Line reading (S5, S1), it is determined whether the first column is "#" (S2).

Since the table calculation processing means 5 is "#num:", a sheet setting process is performed (S3). More specifically, the parameter “3” is set in the column “#num” of the corresponding sheet 44.
(S11, S15), and the corresponding row range “2: 4 (4 from the second row)
(Which means the line number) is written (S16).

[0025] Again, since not all the processing has been completed, the spreadsheet processing means 5 determines from the cell setting b of the definition sheet 43 that 1
Line reading (S5, S1) It is determined whether the first column is "#" (S2).

Since the spreadsheet processing means 5 is "tno",
A cell setting process is performed (S4). Specifically, "title ad
rs "" A3 "," title "" tn
o ”is written in the third row of column A of the dedicated sheet 42 (S2
1, S22). Then, it is determined whether or not “input adrs” is present (S23), and “input adrs” ”A4: r (r
Indicates expansion of the column in the row direction). ”Therefore, the“ # 4: ”parameter“ #num: ”
3 "," A4: A6 (indicating a row range from column A, fourth row to column A, sixth row) "is set as an input cell (S24, S2).
7). In the "#type" row of column a of the corresponding sheet 44, "
r () "is written and the address of the input cell is stored (S28). Then, the cell name" tn "of the corresponding sheet 44 is written.
The cell address “A4: A6” of the dedicated sheet 42 in the row “o”
Is entered (S31). It is determined whether or not "fixed character" is specified. Since there is no specification, the process proceeds to the next process (S3).
2).

[0027] Again, since not all the processing has been completed, the spreadsheet processing means 5 determines from the cell setting b of the definition sheet 43 that 1
Line reading (S5, S1) It is determined whether the first column is "#" (S2).

Since the spreadsheet processing means 5 is "cat",
A cell setting process is performed (S4). Specifically, "title ad
rs "" A2 "," title "" ca
t ”is written in the second row of column A of the dedicated sheet 42 (S2
1, S22). Then, it is determined whether or not "input adrs" is present (S23). Since "input adrs""<B2>","fixedcharacter""3" is only displayed on the second row of column B (S24 to S26). Here, “<>” is “fixed character”
The display only indicates an instruction. Then, the cell address "<B2>" of the dedicated sheet 42 is written in the corresponding sheet 44 (S31). It is determined whether or not “fixed character” is specified (S32), and from the corresponding row “second row” of the corresponding column “column C” of the general-purpose sheet 41, from the parameter “3” of “#num:” on the definition sheet 43. , "Fixed character""
3 "(S33), and the fixed character" 3 "is written in the cell name" cat "line of the corresponding sheet 44 (S3).
4).

The same processing is repeated, and when "pauseT" in the cell setting b of the definition sheet 43, the spreadsheet processing means 5 performs the cell setting processing (S1, S2, S
4). Specifically, since there is no designation of “title adrs”, it is determined whether or not “input adrs” is designated (S21, S23). Since there is no designation, it is determined whether or not "fixed character" is designated (S32).
From the corresponding row “second row” of the corresponding column “column J”, “fixed character” “1 ms” is written in three rows in the definition sheet 43 from “#num:” parameter “3” (S3).
3) The fixed character "1 ms" is added to the cell name "PauseT" line of the corresponding sheet 44 (S34).

Then, since all the operations are completed, the spreadsheet processing means 5 determines whether or not "#block" is designated (S6). Since there is no designation, in (S28), the information ""
The column range "A: E" of the input cell of the dedicated sheet 42 is written in r () of the "type" row, and is set to "r (A: E)" (S8).

Next, the exclusive sheet 42 will be described with reference to FIG. 4, and the definition sheet 43 will be described with reference to FIG. The description of the same operation as above will be omitted.

The spreadsheet processing means 5 reads one row from the sheet setting a of the definition sheet 43 by the creation macro program 45 (S1) and determines whether the first column is "#" (S2).

The spreadsheet processing means 5 performs sheet setting processing (S3). Since all the processing has not been completed, the spreadsheet processing means 5 reads one row again from the sheet setting a (S3).
5, S1) It is determined whether the first column is “#” (S
2).

Similarly, the spreadsheet processing means 5 performs sheet setting processing (S3). Since all the processing is not completed, the spreadsheet processing means 5 reads one row from the cell setting b (S5, S1), It is determined whether one column name is "#" (S2).

Since the spreadsheet processing means 5 is "tno",
A cell setting process is performed (S4). Specifically, "title ad
rs "" A3 "," title "" tn
o ”is written in the third row of column A of the dedicated sheet 42 (S2
1, S22). Then, it is determined whether or not “input adrs” is present (S23), and “input adrs” ”B3: c (c
Indicates the development of the row in the column direction)), so the “#num:” parameter of the definition sheet 43 from the “B3” address
3 "," B3: D3 (indicating a column range from the third row of the B column to the third row of the D column) "is set as an input cell (S24, S2).
9). In the “#type” row in the column B of the corresponding sheet 44,
c () "is written and the address of the input cell is stored (S30). Then, the cell name" tn "of the corresponding sheet 44 is written.
Cell address “B3: D3” of dedicated sheet 42 in row “o”
Is entered (S31). It is determined whether or not "fixed character" is specified. Since there is no specification, the process proceeds to the next process (S3).
2).

Since not all of them have been completed, the spreadsheet processing means 5 determines from the cell setting b of the definition sheet 43 that 1
Line reading (S5, S1) It is determined whether the first column is "#" (S2).

Since the spreadsheet processing means 5 is "cat",
A cell setting process is performed (S4). Specifically, "title ad
rs "" A2 "," title "" ca
t ”is written in the second row of column A of the dedicated sheet 42 (S2
1, S22). Then, it is determined whether or not there is "input adrs" (S23). Since "input adrs" is "B2", "fixed character""3" is displayed in the second row of column B and is set as an input cell (S24 to S26). ). Then, the corresponding sheet 44
The cell address "B2" of the dedicated sheet 42 is entered in the field (S31). It is determined whether or not "fixed character" is specified, and the process proceeds to the next processing since there is no specification (S32).

The same process is repeated, and when all processes are completed, the spreadsheet processing means 5 determines whether or not "#block" is specified (S6). Since there is no designation
In (S30), from the stored information, the row range “3: 7” of the input cells of the dedicated sheet 42 is written into c () of the “## type” row of the corresponding sheet 44, and “c” is written.
(3: 7) "(S8).

Also, the exclusive sheet 42 will be described with reference to FIG. 5, and the definition sheet 43 will be described with reference to FIG. The description of the same operation as above is omitted.

The spreadsheet processing means 5 reads one row from the sheet setting a of the definition sheet 43 by the creation macro program 45 (S1) and determines whether the first column is "#" (S2).

The spreadsheet processing means 5 performs sheet setting processing (S3). Since all the processing has not been completed, the spreadsheet processing means 5 reads one row again from the sheet setting a (S3).
5, S1) It is determined whether the first column is “#” (S
2).

The spreadsheet processing means 5 outputs “#block:”.
Therefore, a sheet setting process is performed (S3). In particular,
The parameter “2: 6” is written in the row “#block” of the column C of the corresponding sheet 44 (S11, S17), and “## t”
"b" is written in the "type" row (S18).

Since all the operations have not been completed, the spreadsheet processing means 5 returns from the sheet setting a of the definition sheet 43 to 1
Line reading (S5, S1), it is determined whether the first column is "#" (S2).

Similarly, the spreadsheet processing means 5 performs sheet setting processing (S3). Since all the processing has not been completed, the spreadsheet processing means 5 reads one row from the cell setting b (S5, S1), It is determined whether one column name is "#" (S2).

Since the spreadsheet processing means 5 is "tno",
A cell setting process is performed (S4). Specifically, "title ad
If there is a designation of “rs” “A3: b (b means block designation)”, the “title character” “tno” is written in the third row of column A of the dedicated sheet 42 (S21, S22). Then, it is determined whether or not “input adrs” exists (S2).
3) Since "input adrs""B3:b","B3"
The address is set as the input cell (S24 to S26). Then, the cell address “B3: b” of the dedicated sheet 42 is written in the cell name “tno” row of the corresponding sheet 44 (S3).
1). It is determined whether or not "fixed character" is specified, and the process proceeds to the next processing since there is no specification (S32).

The same process is repeated, and when all processes are completed, the spreadsheet processing means 5 determines whether or not "#block" is specified (S6). Because there is designation,
The designated range “2: 6” of #block ”, that is, the second to sixth rows of each column are copied, and“
#Num: ", that is, one paste is made so as to become" 2 "(S7).

Next, the data reflection operation of the general-purpose sheet 41 and the dedicated sheet 42 will be described. 13 and 14 are flow charts showing the operation of the spreadsheet processing means 5 by the reflection macro program 46. FIG. 13 shows the data reflection operation from the dedicated sheet 42 to the general-purpose sheet 41, and FIG. This shows the data reflection operation.

When data is written on the dedicated sheet 42 in an input area surrounded by a thick line shown in FIG. 3 by a keyboard or the like as input means (not shown), the spreadsheet processing means 5 operates the reflection macro program 46. . And
The spreadsheet processing means 5 acquires the sheet name of the dedicated sheet 42, that is, "IIH" which is "algo" (S4).
1). In the corresponding sheet 44, in the column "IIH", the cell address of the general-purpose sheet 41 is searched from the input cell address (S42). For example, when “3.6V” is input in the fourth row of column B of the dedicated sheet 42, the corresponding sheet 44
The “cell name” “level” and the “general-purpose sheet” “D” are searched, and the cell address “D2” of the general-purpose sheet 41 is searched from “2: 4” of “## row”. And
The data “3.6V” written on the dedicated sheet 42 is
The cell address of the search result of the general-purpose sheet 41, that is, D
The data is written in the second row of the column (S43).

Next, when data is written on the general-purpose sheet 41 by a keyboard or the like in the input area shown by the bold line shown in FIG. 2, the spreadsheet processing means 5 operates the reflection macro program 46. Then, the spreadsheet processing unit 5 searches the corresponding sheet 44 for the cell address of the dedicated sheet 42 from the input cell address of the general-purpose sheet 41 (S51). For example, the third row of column I “2” of the general-purpose sheet 41
When “μA” is input, “## r
“ow” is searched for “3”, “general table” is searched for “I”, and the name “IIH” and cell address “D5” of the dedicated sheet 42 are searched. When the search is completed and the search is completed, the data “2 μA” written in the general-purpose sheet 41 is written in the cell address of the search result of the dedicated sheet 42, that is, the fifth row of the D column (S52, S53).

Then, the general-purpose sheet 41 and the dedicated sheet 42
Will be described. Figures 15-18
Is a flowchart showing the operation of the spreadsheet processing means 5 by the reflection macro program 46. FIGS. 15 and 16 show operations of inserting and deleting a data column from the dedicated sheet 42 to the general-purpose sheet 41, respectively, and FIGS. 17 and 18 show operations of inserting and deleting a data column from the general-purpose sheet 41 to the dedicated sheet 42, respectively. Here, the exclusive sheet 42 will be described with reference to FIG.

First, from the dedicated sheet 42 to the general-purpose sheet 41
The operation of inserting a data column into the data column will be described. By selecting a cell of the dedicated sheet 42 with a mouse or the like as an input means (not shown) and pressing an insert button (not shown) with a mouse or the like, the spreadsheet processing means 5 causes the reflection macro program 46
To work. Then, the spreadsheet processing unit 5 finds a cell range for one test including the selected cell on the dedicated sheet 42 and inserts the cell (S61). Sheet name, "#alg
o ”of“ IIH ”, the corresponding sheet 44“ ## r ”
The corresponding line on the general-purpose sheet 41 is obtained from “ow:” “2: 4” (S62).

The spreadsheet processing means 5 inserts one row in the corresponding row of the general-purpose sheet 41 (S63). And corresponding sheet 4
4 is updated ("Snum", "#row") (S
64). That is, “#num” in column A is “4”, “##
row "is" 2: 5 "and column row is"## row "is" 6:
8 "and"#row"of the column C are changed to" 9:10 "etc. The corresponding"#algo:"column of the corresponding sheet 44 is updated (S65). tno "
Is changed to "A4: A7" and "level" is changed to "B4: B7". The corresponding sheet is searched for "#algo:" fixed character designation in column A "" and its value is written in the corresponding field of the general-purpose sheet 41 (S66). That is, the corresponding sheet 44
"Cat" of "3", "pauseT" of "1ms"
Is written in the corresponding field of the general-purpose sheet 41.

Next, from the dedicated sheet 42 to the general-purpose sheet 41
The operation of deleting a data column from the data column will be described. By selecting a cell of the dedicated sheet 42 with a mouse or the like and pressing a delete button (not shown) with a mouse or the like, the spreadsheet processing means 5
Causes the reflection macro program 46 to operate. And
The spreadsheet processing unit 5 obtains a cell range for one test including the selected cell on the dedicated sheet 42 and deletes the cell (S7).
1). From the sheet name “IIH” which is “#algo”, “2: 4” which is “## row” of the corresponding sheet 44
From the general-purpose sheet 41 (S72).

The spreadsheet processing means 5 deletes one line from the corresponding line of the general-purpose sheet 41 (S73). And corresponding sheet 4
4 is updated ("Snum", "#row") (S
74). That is, “#num” in column A is “2” and “#num” is “#num”.
“#Row” is “2: 3”, and “#row” of column B is “4:
6 "and"#row"in column C are changed to" 7: 8 "or the like.
The cell range in the corresponding column “#algo:” of the corresponding sheet 44 is updated (S75). That is, “tno” in column a is “
A4: A5 "and" level "are changed to" B4: B5 "and the like.

Further, from the general-purpose sheet 41 to the dedicated sheet 42
The operation of inserting a data column into the data column will be described. By selecting a cell of the general-purpose sheet 41 with a mouse or the like and pressing an insert button (not shown) with a mouse or the like, the spreadsheet processing means 5 is selected.
Causes the reflection macro program 46 to operate.

Then, the spreadsheet processing means 5 obtains "#algo" of the corresponding row from the corresponding sheet 44, that is, "IIH" which is the sheet name of the dedicated sheet 42 (S81).
One row is inserted into the selected row on the general-purpose sheet 41 (S82), and the “#num” and “## row” rows of the corresponding sheet 44 are updated (S83). That is, “#num” in column a is “
4 ”and“ ## row ”are“ 2: 5 ”, and“ ## ro ”in column B
“w” is “6: 8”, and “## row” in column C is “9: 1”.
0 ”etc. The corresponding“ #alg ”of the corresponding sheet 41
o: Search for "fixed character designation in column A" and write the value in the corresponding field of the general-purpose sheet 41 (S84), that is, "3" and "pauseT" of "cat" in the corresponding sheet 44.
Is written in the corresponding field of the general-purpose sheet 41. 1 on the dedicated sheet 42 corresponding to the inserted row of the general-purpose sheet 41
The cell range for the test is obtained and the cell is inserted (S85).

Then, from the general-purpose sheet 41 to the exclusive sheet 4
The operation of deleting the data column for No. 2 will be described. By selecting a cell of the general-purpose sheet 41 with a mouse or the like and pressing a delete button (not shown) with a mouse or the like, the spreadsheet processing means 5 is selected.
Causes the reflection macro program 46 to operate.

Then, the spreadsheet processing means 5 obtains "#algo" of the corresponding row from the corresponding sheet 44, that is, the sheet name "IIH" of the dedicated sheet 42 (S91). One selected line on the general-purpose sheet 41 is deleted (S92), and the “#num” and “## row” lines of the corresponding sheet 44 are updated (S93). That is, “#num” in column A is “2”
"## row" is "2: 3", and "#row" in column B is
Is changed to "4: 6", and "#row" in column C is changed to "7: 8". The cell range for one test on the dedicated sheet 42 corresponding to the inserted row of the general-purpose sheet 41 is obtained and deleted (S94).

The test program file 3 is created by the generator 2 shown in FIG. 22 using the general-purpose sheet 41 created by the above data input as the test condition table 1.

As described above, the spreadsheet processing means 5 can reflect the data of the dedicated sheet 42 on the general-purpose sheet 41 by the reflection macro program 46, and can easily input the data. Further, it is not necessary to modify a program creating device for creating a test program. Even if the number of dedicated sheets 42 increases, only the general-purpose sheet 41 can be considered as a management target, and data management becomes easy.

In the dedicated sheet 42, only data that is normally changed is input, and in the case of fixed values or special data, if the data is input in the general-purpose sheet 41, there are not many input fields in a normal state. Input errors can be prevented.

Further, since the spreadsheet processing means 5 creates the dedicated sheet 42 based on the definition sheet 43 by the creation macro program 45, the relation between the general-purpose sheet 41 and the dedicated sheet 42 can be easily defined. Can be.

The spreadsheet processing means 5 uses the reflection macro program 46 to execute the general-purpose sheet 41 and the special-purpose sheet 4.
Since the cell 2 is reflected, it can be reflected by either cell change. Thus, data can be easily input.

The present invention is not limited to this, but may be as follows.

(1) An apparatus for generating a test program program for an IC tester has been described. However, a general-purpose table for defining a setting state in each sequence in various automatic control devices and automatic measuring devices is prepared, and the control program is prepared. May be automatically generated.

(2) Even when one test is performed by a test of a plurality of rows on the general-purpose sheet 41, it can be handled as one test by using the dedicated sheet 42.

That is, when the general-purpose sheet 41 is, for example, as shown in FIG.
Have performed one test. That is, test number 100
0 and a level of 5 V are applied to the pin number pin1 of the device under test, and the measured current value is substituted for M1. Next, level 4V
Is applied to the pin number pin1 of the test object, and the measured current value is substituted for M2, and the calculation result of “M1-M2” is 0.
It is determined whether or not from 4 to 0.6. Such a setting is performed.

Then, as shown in FIG. 20, a dedicated sheet 42 is provided, and the parameters of the tenth and eleventh rows of the general-purpose sheet 41 are set as in the fourth row. In other words, general-purpose sheet 4
What is expressed in two rows by 1 is expressed by one row of the dedicated sheet 42.

The definition sheet 43 is shown in FIG. 21. As in FIGS. 6 to 8, a is a sheet setting, b is a cell setting, and c is a description line that is not actually included. In FIG. 21, "#seq:" indicates that one line of the dedicated sheet 42 is composed of a plurality of lines of the general-purpose sheet 41, and FIG.
In the special sheet 42 shown in FIG. And "s
The “eq correspondence” column indicates which of the plural rows of the general-purpose sheet 41 corresponds to the “cell name” column in the first row of the dedicated sheet 42. That is, “(1)” is the first line, “
“(2)” indicates the row, and “(1: 2)” indicates the first and second rows.
"#String" is a designation for displaying a fixed character string at an arbitrary cell position on the dedicated sheet 42, and an explanatory sentence, a heading, and the like can be appropriately added.

(3) Although the configuration in which the corresponding sheet 44 is provided has been described, the configuration may be such that the relationship between the general-purpose sheet 41 and the dedicated sheet 42 is determined and reflected each time.

(4) Although the configuration in which the general-purpose sheet 41, the dedicated sheet 42, the definition sheet 43, and the corresponding sheet 44 are provided in the file 4 is shown, separate files may be used. That is, any table may be used. Similarly, the creation macro program 45 and the reflection macro program 46 may be separate files.

[0072]

According to the present invention, the following effects can be obtained. According to the first, second, sixth, and seventh aspects, the spreadsheet processing means can reflect the data of the dedicated table on the general-purpose table, and can easily input the data. Even if the number of dedicated tables increases, only general-purpose tables can be considered as management targets, and data management becomes easy.

In the dedicated table, only data that is usually changed are input, and in the case of fixed values or special data, if data is input in the general-purpose table, there are usually no many input fields, and there is no input error. Can be prevented.

According to the third and eighth aspects, the spreadsheet processing means reflects the cells in the general-purpose table and the dedicated table, so that the cell change can be reflected. Thus, data can be easily input.

According to the fourth and ninth aspects, since the spreadsheet processing means creates the dedicated table based on the definition table, it is possible to easily define the relationship between the general-purpose table and the dedicated table.

According to the fifth and tenth aspects, since the program is created from the general-purpose table, it is not necessary to modify the program creating device even if the dedicated table is increased / changed.

[Brief description of the drawings]

FIG. 1 is a configuration diagram showing one embodiment of the present invention.

FIG. 2 is a diagram showing a specific example of a general-purpose sheet 41.

FIG. 3 is a view showing a specific example of a dedicated sheet 42 in a row direction development type.

FIG. 4 is a view showing a specific example of a row-type development type of a dedicated sheet 42;

FIG. 5 is a diagram showing a specific example of a block development type of a dedicated sheet 42.

6 is a definition sheet 4 corresponding to the dedicated sheet 42 in FIG.
FIG. 3 is a diagram showing a specific example of No. 3;

FIG. 7 is a definition sheet 4 corresponding to the dedicated sheet 42 in FIG.
FIG. 3 is a diagram showing a specific example of No. 3;

8 is a definition sheet 4 corresponding to the dedicated sheet 42 in FIG.
FIG. 3 is a diagram showing a specific example of No. 3;

FIG. 9 is a diagram showing a specific example of a corresponding sheet 44.

FIG. 10 is a flowchart showing the entire operation of the spreadsheet processing unit 5 by the creation macro program 45.

11 is a flowchart showing a sheet setting operation of the spreadsheet processing unit 5 by the creation macro program 45. FIG.

12 is a flowchart showing a cell setting operation of the spreadsheet processing unit 5 by the creation macro program 45. FIG.

FIG. 13 is a flowchart showing a data reflection operation of the spreadsheet processing means 5 by the reflection macro program 46.

FIG. 14 is a flowchart showing a data reflection operation of the spreadsheet processing means 5 by the reflection macro program 46;

FIG. 15 is a flowchart showing a cell reflection operation of the spreadsheet processing means 5 by the reflection macro program 46;

FIG. 16 is a flowchart showing a cell reflection operation of the spreadsheet processing means 5 by the reflection macro program 46;

17 is a flowchart showing a cell reflection operation of the spreadsheet processing means 5 by the reflection macro program 46. FIG.

18 is a flowchart showing a cell reflection operation of the spreadsheet processing means 5 by the reflection macro program 46. FIG.

FIG. 19 is a diagram showing another specific example of the general-purpose sheet 41.

FIG. 20 is a diagram showing a specific example of a sequence support example of a dedicated sheet 42.

21 is a diagram showing a specific example of a definition sheet 43 corresponding to the dedicated sheet 42 in FIG.

FIG. 22 is a diagram showing a configuration of a conventional test program creation device.

[Explanation of symbols]

 5 Spreadsheet processing means 41 General-purpose sheet 42 Dedicated sheet 43 Definition sheet 44 Corresponding sheet 45 Creation macro program 46 Reflection macro program

Claims (10)

[Claims] 1. A data input device for inputting data to a general-purpose table, comprising: a special-purpose table to which data corresponding to the general-purpose table is input; and a reflection macro describing a process of reflecting the data of the special-purpose table to the general-purpose table. A data input device comprising: a program; and a spreadsheet processing means for reflecting data of the dedicated table in a general-purpose table based on the reflection macro program. 2. The reflecting macro program also describes a process of reflecting the data of the general-purpose table into the special-purpose table, and the spreadsheet processing means reflects the data of the general-purpose table into the special-purpose table based on the reflecting macro program. The data input device according to claim 1, wherein: 3. A reflection macro program describes processing for reflecting at least one of cell insertion and deletion between a general-purpose table and a special-purpose table. 3. The data input device according to claim 1, wherein the cell is reflected in the dedicated table. 4. A definition table in which a definition of a dedicated table is described, and a creation macro program for describing a creation process of the dedicated table based on the definition table, wherein the spreadsheet processing means includes: 4. The data input device according to claim 1, wherein a dedicated table is created based on the data. 5. A program creating device for creating a program from the general-purpose table of the data input device according to claim 1. 6. A data input method for providing a general-purpose table for inputting data and a special-purpose table for inputting data corresponding to the general-purpose table, wherein the spreadsheet processing means comprises: A data input method, wherein the data is reflected in the general-purpose table. 7. The spreadsheet processing means reflects data of a general-purpose table in a dedicated table.
Data entry method described. 8. The data input method according to claim 6, wherein the spreadsheet processing means reflects cells in the general-purpose table and the dedicated table. 9. The table according to claim 6, wherein a definition table in which the definition of the dedicated table is described is provided, and the spreadsheet processing means creates the dedicated table based on the definition table. Data entry method described. 10. A method for creating a program, comprising creating a program from the general-purpose table of the data input method according to claim 6.