Issues with the instrument layout diagram
Thread Content
I recently received the piping diagram specifications from the piping department; I set out to create a diagram showing the locations of the instruments, only to find that the information provided was extremely chaotic. For example, there were repeated instrument identifiers, many missing locations, and some incorrect entries (probably because they were copied without any changes made). I would like to ask the seniors, what is usually done when faced with such conditions? I’m currently checking and correcting each item in the data table one by one; the progress is so slow. . . I wonder if anyone else has this problem? :'(
Our cable list is in Excel format, so it can be verified using the company’s software; the verification takes less than a minute. The items that are checked include missing points, duplicate points, and extra points! ;P
I wonder if the piping diagrams for your processes are drawn by hand or generated using software? It seems to be hand-drawn from the look of it. . It’s good enough to be drawn like this. . Go and give your suggestions to the people in charge of their craftsmanship. . Then they can’t do it, so they have to draw it again. If there’s one or two mistakes, it’s still acceptable; but with so many mistakes, it’s a problem with their work. . The instrumentation department has no responsibility for providing the process review drawings. .
Reply 2# talklion: It’s drawn by hand, but it seems that to find those 2 missing points, each one will need to be checked individually, right?:L
This kind of problem is quite common (someone in the piping field who is new to drawing must be the culprit; an experienced professional would never make such a basic mistake). The pipeline layout diagram was not reviewed; it’s a systemic issue. ), let me tell you my experience. First, they get angry, refuse to accept the terms, refuse to sign, and go to their supervisors. Second, match them one by one using the PID and instrument index. It’s as if the review work related to piping has been done by the instrumentation team (it is not recommended; it’s very demanding). Finally, the best approach is to identify the errors, make a list of them, and give it to the piping specialist to make the necessary changes, as he is familiar with the piping drawings and can make the adjustments quickly, after all, he is the one who drew them.
Do I need to use the company’s software for working with EXCEL? Just use the “countIF” function. If the original poster is not familiar with this function, learn about it first.
No, we need to figure out exactly which one is missing!
This post was last edited by talklion on 2011-12-2 at 13:19. This shows the results of the operation: Column B contains the cable numbers that were not found, Column A shows the corresponding tag numbers; Column K lists the tag numbers that were not found, while Column L shows those tag numbers that were found. Column M indicates the number of times each tag number appears – if this value is greater than 1, it means there is a repetition. Column N contains the tag numbers that are extra in the wiring diagram. Of course, in some special cases manual adjustments may be necessary!
Upstairs, your function is just the COUNTIF function, which is built into EXCEL
Procedure description: 1.2.1 Checking the wiring diagram – The “Checking the wiring diagram” procedure allows for the verification of the wiring diagram and the cable list. It checks whether there are any missing instrument tag numbers or cables in the wiring diagram, as well as whether there are any extra tag numbers or cables, and outputs the results to Excel. a) Click on \"Instrument Extensions\" in the CAD menu and select \"Verify Cables\"; there are four options available: verifying the instrument tag numbers in the wiring diagram based on the cable list, verifying the cable numbers in the wiring diagram based on the cable list, verifying the instrument tag numbers in the cable list based on the wiring diagram, and verifying the cable numbers in the cable list based on the wiring diagram. It is possible to select one or more of these options. b) Select the area that needs to be checked; if the entire graphic is to be checked, select all elements. c) Output the result. In the output Excel file, columns 1 to 9 show the frequency of occurrence of cable numbers, columns 11 to 13 show the frequency of occurrence of instrument tags, while columns 14 to 16 list those instrument tags and cable numbers that appear on the wiring diagram but not in the cable list.
Reply to 10# talklion: Is this a CAD plugin? I’ve never heard of it. Could you introduce it? What is this feature?