JPWO2005031278A1 - Graph creation program - Google Patents

Abstract

A graph for extracting pressure value data and flow value data of a specific model number from a database constructed based on the pressure value and flow value described in the catalog, and displaying the relationship between the pressure value and flow value as a graph A creation program, an approximate curve calculation process for obtaining approximate curve data based on a data set including pressure value data and flow rate value data, a correlation degree calculation process for obtaining a correlation degree of the obtained approximate curve data, and a correlation Correlation degree determination processing for determining whether or not the degree is greater than the set correlation degree, and when the correlation degree is less than the set correlation degree, one data set out of a plurality of data sets is removed and approximated When the recalculation processing to obtain curve data and the correlation of the obtained approximate curve data becomes larger than the set correlation, the approximate curve is displayed together with the data set, thereby including the abnormal value. It is a graph creation program capable of obtaining an accurate approximate curve even though it is possible to provide.

Description

  The present invention relates to a graph creation program for displaying a graph of the relationship between first data (pressure value) and second data (flow rate value).

  An example of the graph creation program is one used when creating a graph based on the pressure value and flow rate value described in the nozzle catalog. The inventor of the present application has already filed an application for a nozzle information retrieval system capable of constructing a database based on a nozzle catalog and retrieving a nozzle model number of a nozzle desired by a nozzle user (Japanese Patent Laid-Open No. 2003-22386). When the user searches for a nozzle, one of the important nozzle information is the relationship between the pressure value and the flow rate value, and the numerical data is described in the nozzle catalog. The nozzle catalog describes combinations of pressure values and flow rates, which can be plotted on a graph. When a nozzle of a certain model number can be searched, the pressure / flow rate characteristics of the nozzle can be plotted on a graph and displayed on the screen.

  However, the pressure value and the flow rate value described in the catalog are numerical data, and even if this is plotted on a graph, it is only a set of points, so that it is difficult to grasp the nozzle characteristics. Although the nozzle catalog describes the flow value for a specific pressure value, the nozzle user often wants to know the flow value for a pressure value not listed in the catalog. In such a case, simply plotting the points makes it difficult to immediately grasp the characteristics desired by the user.

  Therefore, for example, in addition to plotting points on two-dimensional coordinates with the x axis as pressure and the y axis as flow rate, an approximate curve is obtained from a plurality of points (x, y) by calculation, and this approximate curve is also graphed. A method of displaying the above is conceivable. By displaying such an approximate curve, the user can easily know the flow value corresponding to an arbitrary pressure value.

  However, when creating an approximate curve based on the pressure value and flow rate value described in the catalog, there are problems as described below. For example, FIG. 22 is a graph created based on catalog description values. Although a plurality of points are plotted, the data of the pressure value and the flow rate value are obtained by actual measurement, so that a measurement error occurs. Therefore, depending on the degree of measurement error, a curve may not be drawn with a single function equation as shown in FIG.

  Next, when the data described in the catalog is plotted, there may be data that seems to be an abnormal value as shown in FIG. 23 (the fourth point from the left in FIG. 23). Although this abnormal value can be determined to be due to a measurement error or due to an entry (or printing) error, an accurate approximate curve cannot be drawn due to this abnormal value. Furthermore, as shown in FIG. 24, an obvious abnormal value may be described in the catalog. The first and fourth points from the right in FIG. 24 are clearly considered to be entry (printing) mistakes, and thus an appropriate approximate curve cannot be drawn.

  When a database is constructed based on the nozzle catalog created by the nozzle manufacturer and the numerical values described in the catalog are displayed, even if there is a numerical value that seems to be an abnormal value, the numerical value cannot be changed without permission. Therefore, an approximate curve will be created in a form that includes data that seems to be abnormal values, but the obtained approximate curve is an approximate curve that is far from the point that seems to be normal, and has no value. It becomes.

  The present invention has been made in view of the above circumstances, and the problem is that when an approximate curve is calculated based on data consisting of a combination of first data (pressure value) and second data (flow rate value). Another object of the present invention is to provide a graph creation program capable of obtaining an accurate approximate curve even if abnormal values are included.

The pressure value data and flow value data for a specific nozzle model number are extracted from the nozzle catalog database constructed based on the nozzle information including the relationship between the pressure value and the flow value described in the nozzle catalog. A graph creation program for displaying a graph of the relationship with the flow rate value,
When there are a plurality of data sets composed of pressure value data and flow rate value data, approximate curve calculation processing for obtaining approximate curve data based on the plurality of data sets;
Correlation calculation processing for calculating the degree of correlation of the approximate curve from the obtained approximate curve data and the data set,
Correlation degree determination processing for determining whether or not the obtained correlation degree is greater than a preset correlation degree;
When the obtained correlation degree is smaller than the set correlation degree, a recalculation process for obtaining the approximate curve data again in a form in which an appropriate number of data sets are removed from the plurality of data sets;
When the correlation degree of the approximate curve data obtained again is larger than the set correlation degree, the computer is caused to execute display processing for displaying the approximate curve together with the data set.

  The operations and effects of the graph creation program with this configuration are as follows. This printing system can extract pressure value data and flow rate value data for a specific nozzle model number from a nozzle catalog database and display them in a graph. A pair of data consisting of pressure value data and flow rate value data will be referred to as a data set. When there are a plurality of data sets, approximate curve data can be obtained by calculation based on the data sets. The degree of correlation between the obtained approximate curve data and the original data set is obtained. When the obtained correlation degree is smaller than the preset correlation degree, some (one or more) of the plurality of data sets are removed, and approximate curve data is obtained again. Then, when the degree of correlation of the obtained approximate curve data becomes larger than the set correlation degree, the approximate curve is displayed in a graph together with the data set. By performing the arithmetic processing as described above, even if there is an abnormal value in the catalog description data, it is possible to obtain an approximate curve in a form that removes the abnormal value. Whether or not it is an abnormal value can be determined based on the degree of correlation. As a result, when calculating an approximate curve based on data consisting of a combination of pressure value data and flow rate value data, a graph creation program that can obtain an accurate approximate curve even if an abnormal value is included. Can be provided.

In order to solve the above problem, another graph creation program according to the present invention is a graph creation program for displaying a graph of the relationship between the first data and the second data,
When there are a plurality of data sets composed of the first data and the second data, approximate curve calculation processing for obtaining approximate curve data based on the plurality of data sets;
Correlation calculation processing for calculating the degree of correlation of the approximate curve from the obtained approximate curve data and the data set,
Correlation degree determination processing for determining whether or not the obtained correlation degree is greater than a preset correlation degree;
When the obtained correlation degree is smaller than the set correlation degree, a recalculation process for obtaining the approximate curve data again in a form in which an appropriate number of data sets are removed from the plurality of data sets;
When the correlation degree of the approximate curve data obtained again is larger than the set correlation degree, the computer is caused to execute display processing for displaying the approximate curve together with the data set.

As described above, the relationship between the pressure value and the flow rate value described in the nozzle catalog has been described. However, the present invention is not limited to this. Generally, there are a plurality of data sets including first data and second data. This technique can also be applied when an approximate curve is to be created based on this. That is,
When there are a plurality of data sets of the first data and the second data, even if an abnormal value is included in the data set, accurate approximate curve data can be obtained by calculation. As a result, when calculating an approximate curve based on data consisting of a combination of the first data and the second data, a graph creation program capable of obtaining an accurate approximate curve even if an abnormal value is included Can be provided.

  As a preferred embodiment of the present invention, when the number of data sets is n, the recalculation process recalculates n types of approximate curve data for n types obtained by removing one of the n sets, Among them, when the approximate curve data having the highest correlation degree becomes larger than the set correlation degree, the display process includes a process for displaying the approximate curve.

  The recalculation process can be performed as follows, for example. Assuming that there are 5 data sets (corresponding to n sets), the approximate curve data is recalculated for combinations (there are 5 patterns in total) excluding 1 set out of the 5 sets. Approximate curve data is obtained for five patterns. Of the approximate curve data obtained again, attention is given to the data having the highest degree of correlation. If the degree of correlation of the approximate curve data having the highest degree of correlation is greater than the set correlation degree, the approximate curve can be displayed on the monitor using the approximate curve data.

  As another preferred embodiment of the present invention, when n approximate curve data calculated again are smaller than the set correlation degree for any approximate curve, the recalculation process performs the n approximate curve data. Of the approximate curve data having the highest degree of correlation is set as a selected data set, and (n-1) combinations obtained by removing two sets including the selected data set are: (N-1) kinds of approximate curve data are calculated again, and when the approximate curve data having the highest correlation degree becomes larger than the set correlation degree, the display process displays the approximate curve. What to do.

  The case where there are five data sets described above will be described as an example. When five types of approximate curve data excluding one set out of the five sets are obtained, the degree of correlation is calculated again for these five types of approximate curve data. When the degree of correlation of five types of approximate curve data is obtained, at least one of them should be larger than the set correlation degree, but it may still be smaller than the set correlation degree. In that case, arithmetic processing is performed as follows. It is assumed that the approximate curve data obtained by A, C, D, and E excluding B has the highest degree of correlation among the five sets of A, B, C, D, and E. Next, the approximate curve data and the degree of correlation thereof are obtained again for four ways (corresponding to (n-1) ways) excluding the two sets including B. Specifically, approximate curve data is obtained based on four data sets obtained by removing (A, B) (B, C) (B, D) (B, E) from the five sets. The degree of correlation for each obtained approximate curve data is obtained, and when the degree of correlation of the approximate curve data having the highest degree of correlation is greater than the set correlation degree, graph display is performed using the approximate curve data.

  As yet another preferred embodiment of the present invention, when the number of remaining sets obtained by removing some data sets from a plurality of data sets is 2 or less, the process of calculating approximate curve data is not performed. In the display process, only the data set described in the catalog is displayed as a graph.

  As described above, when the correlation degree is smaller than the set correlation degree, the arithmetic processing is performed except for some data sets. In this case, when the number of remaining data sets that have been removed becomes 2 or less, there is no point in obtaining the approximate curve, and the process of obtaining approximate curve data is stopped at that time. When displaying the graph, only the data set is plotted, and the approximate curve is not displayed.

  In still another preferred embodiment of the present invention, the obtained approximate curve is displayed by an xy coordinate system, and when an arbitrary point in the xy coordinate plane is selected, a guide line is drawn based on that point, and a guide line is drawn. There is one that performs a process of calculating a pressure value and a flow rate value at the intersection of a line and an approximate curve and displaying them on a screen.

  When an approximate curve is displayed on the monitor screen, a flow value for an arbitrary pressure value (or a pressure value for an arbitrary flow value) can be read from the graph by the approximate curve. However, reading a specific numerical value from the scale of the graph requires some effort. Therefore, when an arbitrary point in the xy coordinate plane where the graph is displayed is selected, a process of drawing a guide line (display process) is performed based on that point. A process of obtaining an intersection of the guide line and the approximate curve, calculating a pressure value and a flow rate value at the intersection, and displaying on the screen is performed. Thereby, when the user wants to know the flow rate value for an arbitrary pressure value, it is only necessary to select an arbitrary point in the xy coordinates. Thereby, the effort which reads a numerical value from a graph can be reduced.

As yet another preferred embodiment of the present invention, a process for starting another window for inputting either pressure value data or flow rate value data;
Processing for calculating flow rate data or pressure value data corresponding to the input pressure value data or flow rate data based on the approximate curve data of the displayed approximate curve;
There is one that performs a process of drawing a lead line corresponding to the pressure value data and the flow rate value data that are input and calculated, and displaying the pressure value data and the flow rate value data together with the screen.

  The method for selecting an arbitrary point in the xy coordinate plane has been described above. With this method, it is difficult to select a good value. For example, even if the user tries to select a numerical value of 100, it becomes 100.1 or 99.8. Therefore, another window for inputting either the pressure value or the flow rate value is activated. A specific numerical value can be input in this separate window. For example, a good value such as pressure value = 100 can be input. Based on the input numerical value, a flow rate value (pressure value) with respect to the input pressure value (flow rate value) is obtained by calculation processing by drawing a lead wire. The obtained numerical value is displayed on the screen as before.

As still another preferred embodiment of the present invention, in the display process, as a unit of the pressure value and the flow rate value displayed in the graph, a graph is created using the unit described in the catalog,
For example, when a unit other than the unit described in the catalog is selected, a process of re-creating the graph so that the scale line and scale value of the graph become a good delimiter value can be mentioned.

  Units for pressure values and flow rate values described in the nozzle catalog are not uniform among manufacturers, but are scattered. Further, the unit of pressure value and flow rate value used by nozzle users on a daily basis is not uniform among users. Therefore, the graph display is basically created based on the unit described in the catalog. However, a different unit can be selected by the user, and the graph creation is performed again based on the selected unit. The scale value displayed on the graph is a well-cut numerical value, but if the unit is changed, the well-cut numerical value becomes a halfway numerical value. For example, if the pressure value displayed as 100 psi is displayed as 0.690 MPa, it becomes a halfway numerical value, and the graph becomes difficult to see. Therefore, when another unit is selected, the graph is re-created so that the scale line and the scale value of the graph are numerical values with good separation. Thereby, it can be set as the graph which is easy to read a numerical value.

Conceptual diagram showing the overall configuration of the nozzle information search system Diagram showing server system configuration The figure which shows the example of a display structure of the page for selecting a search method The figure which shows the structural example of the search screen of step 1 in a standard search The figure which shows the structural example of the search screen of step 2 in a standard search The figure which shows the structural example of the search screen of step 3 in a standard search The figure which shows the structural example of the screen which displays the list of the search result in standard search The figure which shows the structural example of the screen of the search result detailed display in standard search The figure which shows the structural example of the screen of the search result detailed display in standard search Block diagram explaining the functions of the graph creation program The figure which shows the general | schematic flowchart in the case of performing a graph preparation process A graph showing the result of obtaining an approximate curve (Example 1) (without data deletion) A graph showing the result of obtaining an approximate curve (Example 2) (without data deletion) A graph showing the result of obtaining an approximate curve (example 2) (one set of data deleted) A graph showing the result of obtaining an approximate curve (Example 3) (without data deletion) A graph showing the result of obtaining an approximate curve (example 3) (one set of data deleted) A graph showing the result of obtaining an approximate curve (Example 3) (deleted two sets of data) The figure explaining the function which can draw a lead line on the graph Diagram explaining the function that allows you to draw a lead line on the graph by directly entering the characteristic value Illustration explaining the concept of unit conversion The figure which shows the graph which converted the graph of FIG. 20 into the unit Example 1 of creating a graph using the catalog values as they are Example 2 of creating a graph using the catalog values as they are Example 3 of creating a graph using catalog values as they are

Explanation of symbols

1 Client device 2 Server system 20 Database 26 CGI system 27 Graph creation program

  A preferred embodiment of a nozzle information retrieval system in which a graph creation program according to the present invention is used will be described with reference to the drawings. FIG. 1 is a conceptual diagram showing the configuration of the entire system.

<Overall system configuration>
This system includes a server system 2 managed by a general nozzle consultant company C (hereinafter abbreviated as a consultant company and also a server administrator) that provides nozzle information built in a database, and a nozzle user A (hereinafter referred to as a server administrator). The client device 1 is simply connected to the Internet B (corresponding to a network). As the client device 1, a personal computer is generally used, and a browser for browsing a homepage by connecting to the Internet is installed. It is also connected to the system of nozzle manufacturer D.

  The server system 2 is configured with a so-called Web server as a core, and various pages (sites) are prepared in order to use the nozzle information search system. The page is stored on the hard disk in, for example, an HTML file format. In the server system 2, an OS and various applications are installed as software necessary for system operation. In addition, a nozzle information database 20 is constructed based on a nozzle catalog 21 provided by nozzle manufacturers around the world. The outline of the database 20 is also disclosed in the above-mentioned Patent Document 1 by the present applicant.

  As described above, the database 20 stores nozzle information in a database based on the nozzle catalog. For example, nozzle specification information and nozzle model number information are associated with each other and registered in the database. Also, nozzle model number information and specification information such as pressure, flow rate, spray angle, spray angle (spray angle), material, etc. corresponding to the model number are registered. Therefore, the database 20 can be searched using the numerical values of the pressure, flow rate, and spray angle desired by the user as keywords. In addition, catalog image data 21 of each company is also inputted, and when a nozzle model number of a certain manufacturer is designated, it becomes possible to search a corresponding page of the catalog in which the nozzle of that model number is posted. Yes. Thereby, the user can acquire the catalog information of the worldwide nozzle manufacturers by using the database 20.

<Server system configuration>
Next, the control block configuration of the server system 2 will be described with reference to FIG. The transmission / reception unit 22 transmits Web page (homepage) data (HTML data) and an electronic mail in response to an access request from a personal computer (hereinafter sometimes referred to as an external personal computer) such as a user or a consulting company. It also receives data, e-mails, etc. input from an external personal computer. The transmission / reception unit 22 can be configured by a program (OS or the like) installed in a computer constituting the server system 2 or a communication interface.

  The web page storage unit 23 stores web page data in an HTML file format. The web page processing unit 24 causes the web page data stored in the web page storage unit 23 to be transmitted via the transmission / reception unit 22 in response to an access request from an external personal computer. In addition, the processing result by the CGI program and the search result of the database 20 are processed in the form of a Web page (HTML data is generated) and transmitted to the external personal computer.

  The e-mail processing unit 25 processes an e-mail transmitted from an external personal computer, for example, analyzes data written in the e-mail. Based on the analysis result, the CGI program is started. It also automatically creates e-mails that should be sent to external PCs. The CGI system 26 refers to a function that a server calls and executes an external program (CGI program). A large number of CGI programs forming the core of the CGI system 26 are stored. The CGI program includes a graph creation program 27 and is a computer program having a function of creating a graph based on pressure value data and flow rate value data stored in the database 20. Details will be described later.

  The database control unit 29 searches the database 20 based on the keyword information transmitted from the user's personal computer. The search result is returned to the user's personal computer in the form of a Web page by the function of the CGI system 26.

  The web page storage unit 23 stores a large number of web page data. The search system provides four search methods, specifically, standard search, expert search, nozzle specification search, and similar nozzle search. A search page is provided for this purpose.

<Search system>
Next, an outline of the search system and a search procedure will be described. FIG. 3 shows a display configuration example of a page for selecting a search method. As shown here, the search system provides four search methods. That is,
The nozzle model number search includes standard search, expert search, nozzle specification search, and similar nozzle search. The outline of each search method is as described in FIG. If a button 40 written as “to search screen” is clicked on the screen, each search screen is displayed. In the present invention, only the standard search will be described. The graph creation program according to the present invention can be used in any search method.

  The standard search is a method of searching a large number of nozzle model numbers by inputting a rough search condition. A large number of nozzle model numbers can be searched in a wide range. In the standard search, search conditions can be input in three stages. When the standard search is selected on the screen shown in FIG. 3, first, the screen shifts to the search screen (input form) in step 1 as shown in FIG.

  In the upper part of the screen, a display area 41 for displaying input search conditions is provided. In step 1, nozzle classification is input as a search condition. The classification is made in advance such as “nozzle for liquid”, “nozzle for gas”,..., And one of the classifications can be selected by clicking a radio button. When the selection is completed, if the “Next Page” button at the bottom of the screen is clicked, the process proceeds to Step 2.

  FIG. 5 is a diagram showing a search screen (input form) in the second step of standard search. Similar to step 1, a display area 41 is provided. In this display area 41, “steam nozzle” is displayed as the classification of the nozzles already input in step 1. As a result, the search conditions input in the past (in another step) can be confirmed. If the user wants to change the condition of step 1, the user can return to the search screen shown in FIG. 4 by clicking on the place where “Step 1” is displayed in the display area 41.

  In step 2, an example in which a spray pattern is selected is shown. The spray pattern is an ejection pattern when fluid is ejected from the tip of the nozzle to the outside. The expression of the spray pattern is not uniform among nozzle manufacturers, and it is difficult to express it in words. Therefore, when the user inputs a spray pattern as a search condition, it is important how to input the spray pattern. It must be in a form that is easy for the user to input. Therefore, the spray pattern is displayed as an illustration. The inventor of the present application examined nozzle catalogs in various countries around the world, and classified all the nozzles by the spray pattern illustrated as shown in FIG. Each spray pattern is also given a shape ID. In addition, even if the spray pattern cross section is the same, if the direction of fluid ejection is different, it is treated as a different classification. In addition to verbal explanations, the spray pattern is illustrated, so the user can select the nozzle spray pattern he wants without hesitation. Selection can be made by clicking any one radio button. When the input in step 2 is completed, the “next page” button is clicked and the process proceeds to step 3.

  FIG. 6 is a diagram illustrating a configuration example of the search screen (input form) in step 3. In step 3, an approximate nozzle specification is input as a search condition. A display area 41 is provided as in the other screens of steps 1 and 2. An illustration of the nozzle classification and spray pattern already entered is displayed. The function of the display area 41 is the same as already described.

  An input form for entering nozzle specifications is shown at the bottom of the screen. Specifically, fluid pressure (pressure value), jet fluid flow rate (flow value), and spray angle can be input. An input field 43 for inputting a fluid pressure and an input field 45 for selecting a unit are provided. In the input field 43, a numerical value is input. About the unit, since the unit handled by the manufacturer and the user is different, it was made possible to select. Note that even if the unit selected by the user is different from the unit described in the manufacturer's catalog, the search results are different depending on the selected unit because the unit conversion operation is performed. I don't want to. The unit can also be selected for the flow rate of the jet fluid. When a button 42 described as a unit conversion table is clicked, a page for unit conversion is displayed in a separate window. Unit conversion can be performed on this page, so the user can use it as needed.

In addition, an input field 44 is also provided for allowing an allowable range to be entered for the jet fluid flow rate and the spray angle. This is because if the allowable range is not entered, there is a high possibility that a nozzle having a jet fluid flow rate and a spray angle corresponding to the input fluid pressure is not searched. In other words, in the search for the numerical value of the pinpoint, there is a possibility that the search result is not extracted even though there is a nozzle having the characteristics desired by the user.
Therefore, in this search system, an allowable range is also input so that the search can be performed reliably.

When the search conditions in step 3 have been entered, the search is performed by clicking the search start button. When the search condition that has already been input is to be redone, click on the corresponding location in the display area 41 to return to the search screen of the selected step. Further, when executing the search, Step 1 and Step 2 are indispensable items, but the nozzle specification in Step 3 can be searched without inputting. Alternatively, only a part of the nozzle specifications may be input. That is,
Search conditions may be entered for all items of pressure, flow rate, and spray angle, but not all of them need to be entered. Thereby, a nozzle can be searched over a wide range.

  FIG. 7 is a configuration example of a screen that displays a list of search results in the standard search. Although not shown, a display area for displaying the search condition is similarly provided. The function is the same.

  SGS code, manufacturer, nationality, catalog language, manufacturer model number, pressure value, flow rate value, spray angle, material, screw standard / size / male / female discrimination, valve, strainer are provided as the table items in the list (however, Some are shown for the sake of illustration). In this way, the search result can be extracted as the nozzle model number (manufacturer model number). When the number of searches is large, a list is created over a plurality of pages. If the user wants to input a new search condition by looking at the search result, the user can click on the button labeled “Search method” at the bottom of the screen. If you want to narrow down the search results, you can go to expert search.

If you want to know in detail about the nozzles of a specific nozzle model number among the nozzles of each company displayed in the list, within the frame of the manufacturer model number in the list (for example, the location shown in Figure 46)
Just click. As a result, the screen shifts to the search result detail display screen shown in FIGS. If the screen of FIG. 8 is scrolled downward, the screen of FIG. 9 is obtained.

  In the screen of FIG. 8, a display area 41 is provided at the top. The function is as described above. A click button 42 for the unit conversion table is also provided.

  A detailed display of the selected nozzle model number is displayed as a list 48. The URL of the manufacturer of the nozzle is also displayed, and the manufacturer's homepage can be viewed immediately. As shown in FIG. 9, a pressure-flow rate characteristic table 49 and a pressure-spray angle characteristic table 50 are displayed, and the unit can also be selected. When a different unit is selected, an arithmetic process is performed and converted to a numerical value corresponding to the selected unit. This table displays the data described in the catalog as it is. The actual catalog value can be confirmed from this table. Further, a pressure / flow rate graph display button 60 is provided, and when this button 60 is clicked, the relationship between the pressure and the flow rate can be displayed in a graph. This graph display function will be described later.

  Below the list 48, a nozzle catalog page 51 related to the searched nozzle is displayed as a thumbnail image. Click on the page to enlarge the image and view the catalog image in its normal size. As a result, the actual data can be confirmed while viewing the catalog. Therefore, the actual catalog contents can be confirmed for the nozzles for which notes are displayed in the search result list.

  In the lower part of the screen, a button 52 described as “Attached mailer activation” is provided. The user can click this button 52 to make an inquiry to the manufacturer. As a result, the e-mail software is automatically activated. In addition, the e-mail address of the manufacturer is already input at the destination.

  Similarly to the previous case, when a new search condition is to be input, the button 53 described as “Selection of“ search method ”may be clicked.

<Graph creation function>
FIG. 10 is a block diagram illustrating the function of the graph creation program. As already described, the relationship between the pressure value and flow rate value of a specific nozzle model number (shown in the pressure-flow rate characteristic table 49 shown in FIG. 9) can be displayed as a graph. In the graph, not only the pressure value and the flow rate value are plotted, but also the relationship between the pressure value and the flow rate value can be displayed by an approximate curve. Obtaining this approximate curve is one of the main functions of the graph creation program. The database 20 stores pressure value data and flow value data for each nozzle based on the catalog description of each nozzle manufacturer. Speaking of a nozzle of a certain model number, flow rate value data with respect to pressure value data is uniquely determined. Therefore, a combination of pressure value data and flow rate data is referred to as a data set. If there are a plurality of data sets, an approximate curve representing the pressure / flow rate characteristic can be obtained for the nozzle and displayed in a graph.

  As shown in FIG. 10, when the pressure value data and the flow value data 61 are acquired, the approximate curve calculation processing unit 62 has a function of calculating and obtaining approximate curve data. Various methods for obtaining the approximate curve are conceivable. Here, the approximate curve data is obtained by the least square method. The obtained approximate curve data can be stored in the approximate curve data storage unit 65. The correlation degree calculation processing unit 63 has a function of calculating the degree of correlation of the obtained approximate curve data. As the degree of correlation, a statistical quantity called a regression coefficient determination coefficient (R-square value) is used. The closer the degree of correlation is to 1, the higher the approximation accuracy of the approximate curve.

  The correlation degree determination processing unit 64 determines whether or not the correlation degree calculated by the correlation degree calculation processing unit 63 is greater than the set correlation degree by comparing with the preset set correlation degree. The set correlation degree data is stored in the set correlation degree storage unit 66. The numerical value of the set correlation can be arbitrarily determined by setting on the program.

  The display processing unit 67 has a function of performing processing for drawing display data obtained by plotting a data set composed of pressure value data and flow rate data on a graph, drawing approximate curve data on the graph, and the like. Data processed by the display processing unit 67 is transferred to the monitor control unit 68 and visually displayed on the screen of the monitor 69.

  As will be described in detail later, when arbitrary coordinates (point data 70) on the coordinates of the graph displayed on the monitor screen are selected (designated), a lead line is drawn in the graph based on this point (coordinate). The coordinates of the intersection between the guide line and the approximate curve are obtained by calculation. This is based on the function of the intersection calculation processing unit 71. The unit data 72 can be selected. The pressure value and flow rate value displayed in the graph are based on the units described in the catalog, but can be converted into different units.

<Graph creation procedure>
Next, a procedure for creating a graph will be specifically described. FIG. 11 is a diagram illustrating a schematic flowchart when the graph creation process is performed. On the screen shown in FIG. 9, the graph display button 60 is clicked (# 1). As a result, a graph creation request signal is transmitted to the server system 2 and the graph creation program 27 is started. The following processing shown in the flowchart is mainly executed by the server system 2.

  Next, it is determined how many data sets of the pressure value data and the flow rate data exist for the nozzle for which a graph is to be created (# 2). There may be only one or two data sets described in the catalog. In such a case, since there is no meaning to obtain an approximate curve, graph display processing is performed based on the function of the display processing unit 67 (# 7). In this case, only plotting the data set is performed on the graph.

If there are three or more data sets, a process for calculating approximate curve data is executed. The approximate curve data is obtained based on the least square method. Here is the relational expression between flow value and pressure value,
Flow rate value = constant x (pressure value) ⁿ
It is represented by Usually, n = 0.5 (that is, the square root), but depending on the internal structure of the nozzle, a numerical value other than 0.5 may be taken. Based on this relational expression, approximate curve data is obtained. If there is a constant and n data in the above formula, an approximate curve can be drawn on the graph. Therefore, the constant and n data correspond to approximate curve data.

  As already described with reference to FIGS. 22 to 24, the pressure value and the flow rate value described in the nozzle catalog may include a numerical value that seems to be an abnormal value. The inventor of the present application scrutinized the nozzle catalogs of nozzle manufacturers around the world, and out of about 100,000 liquid nozzles, about 1600 to 3400 cases contain abnormal values due to measurement errors, entry errors, etc. I discovered that. If an approximate curve is obtained in a form including such abnormal value data, an approximate curve with poor accuracy is obtained. Therefore, it is programmed so that approximate curve data can be obtained in a form from which abnormal values are removed.

  FIG. 12 is a graph showing the result of obtaining approximate curve data for a nozzle of a certain model number. In the graph, the horizontal axis (x axis) is the pressure value, and the vertical axis (y axis) is the flow value. This is an example of five data sets for obtaining approximate curves. The function expression of the obtained approximate curve is displayed on the upper right of the graph. Moreover, Table 1 is a table | surface which shows the relationship between the pressure value and flow volume value of the graph of FIG. Table 1 also shows that the obtained degree of correlation is 0.9989. The closer the correlation is to 1, the better. As shown in FIG. 12, in the example of Table 1, the points are almost on the approximate curve.

  Therefore, in the case as shown in FIG. 12, there is no abnormal value data, and it can be evaluated that it is an accurate approximate curve. In order to perform such evaluation, the degree of correlation is calculated, and it is determined whether or not this is greater than a preset set degree of correlation (# 4, # 5). The set correlation value can be set as appropriate, and is set to 0.98, for example. This numerical value can be determined in consideration of the accuracy of the approximate curve displayed in a graph.

  Next, processing when the correlation degree is less than the set correlation degree in step # 5 will be described. Table 2 shows the relationship between the pressure value and the flow rate value for another example nozzle.

  FIG. 13 is a graph showing the relationship shown in Table 2. There are 5 data sets. When the degree of correlation is obtained, it is 0.9736 as shown in Table 2, which is smaller than 0.98. The reason is that, as can be seen from FIG. 13, the fourth data set from the left is considered an abnormal value. In this case, approximate curve data is obtained again in a form excluding one of the five sets (# 6).

  As shown in Table 2, there are five ways to remove one set. Table 2 shows the five types. The data set excluding those marked with a cross. Approximate curve data is obtained again for the remaining four sets, and the degree of correlation is also obtained for each obtained approximate curve data. Of the five approximate curve data obtained in Table 2, attention is focused on the data having the highest degree of correlation. That is, no. When the calculation is performed except for the data set of 4, the correlation degree is 0.9991, which is the largest and larger than the set correlation degree. The appearance of the approximate curve obtained at this time is shown in FIG. It is understood that the points marked with x are excluded points, and the remaining four points are almost on the approximate curve. If FIG. 13 and FIG. 14 are compared, it is clear that FIG. 14 is more accurate. What is actually displayed on the monitor screen is the result shown in FIG. 14, and FIG. 13 is not displayed on the monitor. Further, in FIG. 14, the removed points are marked with x for convenience, but this is for easy understanding of the description. Actually, all points including the removed points are displayed as black circles.

  Next, an example in which there are two abnormal values will be described. This example is shown in Table 3. In Table 3, the number of data sets is five. When an approximate curve is obtained using all the five sets of data, a graph as shown in FIG. 15 is obtained. As can be inferred from this graph, the second point from the left and the fourth point from the left are considered to be abnormal value data. As shown in Table 3, the degree of correlation when calculating the approximate curve data using all the five sets of data is 0.9579. The correlation degree is smaller than the set correlation degree of 0.98. Therefore, the calculation process is performed again with one set removed.

  Table 3 and FIG. 16 show the results of calculation with one set removed. In Table 3, as in the case of Table 2, the calculation results of the degree of correlation are shown for five types of approximate curve data. Among these, the highest correlation is No. This is a case where the data set 2 is removed, and the degree of correlation is 0.9762. Even if one set is excluded, the largest correlation degree is smaller than the set correlation degree.

  Therefore, another set (two sets in total) of data is removed, and approximate curve data is calculated again. In the case of removing two sets from five sets of data, it is always necessary to remove one set that has obtained a result that maximizes the degree of correlation when one set is removed. That is, no. The data of 2 must be removed, and in addition to this, another set is removed. In other words, in the example of Table 3, (No. 1, No. 2) (No. 2, No. 3) (No. 2, No. 4) (No. 2, No. 5) are removed for calculation ( 4 ways in all). Thereby, arithmetic processing can be performed efficiently. The result of the calculation is shown in Table 3 and FIG. When the two sets are removed, the correlation becomes the largest when No. 2 and No. This is the time when the data set of 4 is excluded, and the degree of correlation is 0.9999. Moreover, since the obtained correlation degree is larger than the set correlation degree, an approximate curve can be displayed. Actually, what is displayed on the user's monitor screen is the graph of the approximate curve shown in FIG.

  According to the flowchart of FIG. 11, when the degree of correlation is less than the set degree of correlation, the process of calculating approximate curve data by removing one set from n sets of data is repeated. When the degree of correlation becomes larger than the set degree of correlation, approximate curve data to be displayed in a graph can be obtained. In the flowchart, the process returns from step # 6 to step # 2. However, if one set is removed and the remaining number of sets is 2, there is no significance in obtaining an approximate curve, so step # 7. The approximate curve is not displayed, and a graph in which only n sets of points are plotted is displayed.

<Other functions of graph display>
Next, other functions related to graph display will be described. FIG. 18 is a diagram illustrating a function that can draw a lead line on a graph. FIG. 18 is a graph showing the pressure / flow rate characteristics of a nozzle of a certain model number. Specific values of the pressure value and the flow rate value described in the catalog are shown in the upper table of FIG. Each point of the data set is displayed as a black circle, and an approximate curve is also displayed. The nozzle user can check whether the nozzle has the characteristics desired by viewing the graph on the monitor screen. However, as a user, in order to confirm how much the flow rate value for a certain pressure value is, it is necessary to follow the scale on the graph, which is cumbersome.

Therefore, a function is added that allows the user to more easily determine what the flow value (pressure value) is for a certain pressure value (flow value). For example, if the user wants to know the specific value of the flow rate when the pressure is 0.6 MPa, P1 on the graph
Click. Point P1 is a coordinate where x = 0.6. Click here to automatically draw the lead lines Lx1 and Ly1. The lead line Lx1 is a vertical straight line passing through the point P1. Point A is the intersection of the lead line Lx1 and the approximate curve. The lead line Ly1 is a horizontal straight line passing through the intersection A. Furthermore, the coordinate value of the intersection A is displayed on the side closer to the coordinate axis of the lead lines Lx1 and Ly1. Accordingly, the user can immediately know that the flow rate value = 80.309 with respect to the pressure value = 0.6.

  When the point P2 above the approximate curve is clicked, a lead line Ly2 is drawn, and further, an intersection point B and a lead line Lx2 are obtained. As described above, by clicking an arbitrary point in the xy coordinate plane, a guiding line can be drawn and a numerical value is also displayed. As a result, the user can easily obtain characteristic data that the user wants to know.

  Another method for drawing a lead line will be described with reference to FIG. As described with reference to FIG. 18, when clicking in the coordinate plane, it is not always possible to click on a numerical value with good separation, and an incomplete numerical value is selected. For example, even if an attempt is made to select pressure value = 0.6, 0.59 or 0.61 may be selected depending on the error of the click position. As a user, you may want to select a good number.

  In that case, click the location C on the screen where “Please enter the characteristic value directly here” is clicked. When this is clicked, another window for inputting characteristic values is activated as shown in FIG. The pressure value or the flow rate value can be directly input via this separate window. When inputting pressure directly, if the radio button displayed as pressure is selected and a specific numerical value is input, a lead line corresponding to the input value can be displayed on the graph. In addition, since the graph becomes difficult to see when the number of lead lines increases on the graph, it is possible to display up to five places (this number can be appropriately set on the program). In addition, in order to delete the guide line displayed on the graph, the display can be cleared by clicking the guide line. The display color of the lead line can be made conspicuous by making it red, for example.

<About unit conversion function>
Next, a unit conversion function for graph display will be described. When the graph is displayed based on the characteristic values described in the nozzle catalog, the unit of the pressure value and flow rate value is basically the unit used in the catalog. However, the units used by nozzle manufacturers vary and are not unified. For users who use nozzles, there are times when they want to check the characteristics of the nozzles in the units they normally use. Therefore, it is programmed so that the graph can be displayed in a unit-converted form.

  FIG. 20 is a graph showing the pressure / flow rate characteristics of a nozzle of a certain model number. The unit of pressure is psi. Thick graticule lines are used every 20 psi to make the graph easier to see. Consider converting the unit of pressure from psi to MPa. Then, as shown at the bottom of FIG. 20, from the relationship between psi and MPa, for example, numerical conversion is performed from 100 to 0.690. If only the unit is converted using the scale line of the original graph, halfway numerical values are displayed, and the graph becomes difficult to see.

  Therefore, when unit conversion is performed, as shown in FIG. 21, conversion processing is performed so that scale lines can be displayed with numerical values with good separation. In FIG. 21, the scale of the graph is also converted so that a thick scale line is obtained every 0.2 MPa. As a result, the graph is easy to see, and a user-friendly system can be obtained.

<Another embodiment>
(1) In the present embodiment, the case where a graph is created based on pressure value data and flow rate data stored in a database used in the nozzle information search system has been described. However, the graph creation program according to the present invention is It is not limited to. When there are a plurality of data sets of the first data and the second data, they can also be used for graphing. In the present embodiment, the matters described regarding the pressure value data and the flow rate value data can be generally applied when creating a graph of the first data and the second data. In terms of nozzle characteristic values, the present invention can also be applied to graphing the relationship between the pressure value and the spray angle.
(2) The graph creation program may be operated while being placed on the server, or may be downloaded from the server and operated on the client personal computer. It is also possible to install this graph creation program on a stand-alone personal computer.
(3) In Table 3, the example in which two sets of data are deleted for calculation has been described. Even if the two sets are deleted, if the correlation is lower than the set correlation, the three sets are deleted and the approximate curve data is recalculated. It goes without saying that two of the three sets are selected so as to have the highest correlation in the previous calculation. In this way, when the set correlation is not reached, the calculation is performed by deleting the data sets one by one in order. Of course, when there are two remaining data sets, the calculation processing of the approximate curve data is terminated. This concept can also be applied when creating a graph from the first data and the second data.
(4) In the nozzle information retrieval system, it is possible to appropriately select whether the server system is composed of one server device or plural servers. By distributing the functions with a plurality of units, the burden on each server device can be reduced. For example, it can be distributed like a Web server or a database server. In the case of configuring with a plurality of servers, the locations where the servers are installed may be distributed.

Claims (8)

The pressure value data and flow value data for a specific nozzle model number are extracted from the nozzle catalog database constructed based on the nozzle information including the relationship between the pressure value and the flow value described in the nozzle catalog. A graph creation program for displaying a graph of the relationship with the flow rate value,
When there are a plurality of data sets composed of pressure value data and flow rate value data, approximate curve calculation processing for obtaining approximate curve data based on the plurality of data sets;
Correlation calculation processing for calculating the degree of correlation of the approximate curve from the obtained approximate curve data and the data set,
Correlation degree determination processing for determining whether or not the obtained correlation degree is greater than a preset correlation degree;
When the obtained correlation degree is smaller than the set correlation degree, a recalculation process for obtaining the approximate curve data again in a form in which an appropriate number of data sets are removed from the plurality of data sets;
A graph creation program for causing a computer to execute display processing for displaying an approximate curve together with a data set when the degree of correlation of approximate curve data obtained again is larger than a set correlation degree. A graph creation program for displaying a graph of the relationship between first data and second data,
When there are a plurality of data sets composed of the first data and the second data, approximate curve calculation processing for obtaining approximate curve data based on the plurality of data sets;
Correlation calculation processing for calculating the degree of correlation of the approximate curve from the obtained approximate curve data and the data set,
Correlation degree determination processing for determining whether or not the obtained correlation degree is greater than a preset correlation degree;
When the obtained correlation degree is smaller than the set correlation degree, a recalculation process for obtaining the approximate curve data again in a form in which an appropriate number of data sets are removed from the plurality of data sets;
A graph creation program for causing a computer to execute display processing for displaying an approximate curve together with a data set when the degree of correlation of approximate curve data obtained again is larger than a set correlation degree. When the data set is n sets, in the recalculation process, n types of approximate curve data are calculated again for n types obtained by removing one set out of the n sets, and the approximate curve having the highest degree of correlation is obtained. 3. The graph creation program according to claim 1, wherein when the data becomes larger than a set correlation, the display process performs a process of displaying the approximate curve. 4. If n approximate curve data calculated again are smaller than the set correlation degree for any of the approximate curves, the recalculation process results in the approximate curve data having the largest correlation among the n approximate curve data. A data set removed when it is obtained is set as a selected data set, and (n-1) different approximate curve data are obtained for (n-1) combinations obtained by removing two sets including the selected data set. 4. The calculation is performed again, and when the approximate curve data having the highest correlation degree becomes larger than the set correlation degree, a process for displaying the approximate curve is performed in the display process. Graphing program. When the remaining number of sets obtained by removing some data sets from the plurality of data sets is 2 or less, the process of calculating the approximate curve data is not performed, and the data set described in the catalog is not displayed in the display process. The graph creation program according to any one of claims 1 to 4, wherein only a graph is displayed. The obtained approximate curve is displayed in the xy coordinate system. When an arbitrary point in the xy coordinate plane is selected, a lead line is drawn based on that point, and the pressure value and the flow rate value at the intersection of the guide line and the approximate curve. The graph creation program according to any one of claims 1 to 5, which performs a process of calculating and displaying on a screen. Processing for starting another window for inputting either pressure value data or flow rate value data;
Processing for calculating flow rate data or pressure value data corresponding to the input pressure value data or flow rate data based on the approximate curve data of the displayed approximate curve;
The graph according to any one of claims 1 to 3, wherein a process is performed for drawing a lead line corresponding to the input and calculated pressure value data and the flow rate value data and displaying the screen together with the pressure value data and the flow rate value data. Creation program. In the display process, as a unit of the pressure value and flow rate value displayed in the graph, the graph is created using the unit described in the catalog,
When the unit other than the unit described in the catalog is selected, the process of re-creating the graph so that the scale line and the scale value of the graph become a good delimiter is performed. The graph creation program according to any one of 3 to 7.

Images