CN102609447A

CN102609447A - Pipeline inflection point coordinate calculator

Info

Publication number: CN102609447A
Application number: CN2012100024793A
Authority: CN
Inventors: 刘朝珂
Original assignee: China Nuclear Industry 23 Construction Co Ltd
Current assignee: China Nuclear Industry 23 Construction Co Ltd
Priority date: 2012-01-06
Filing date: 2012-01-06
Publication date: 2012-07-25
Anticipated expiration: 2032-01-06
Also published as: CN102609447B

Abstract

The invention discloses a pipeline inflection point coordinate calculating method, which belongs to the technical field of methods for calculating coordinates of inflection points of pipelines, especially nuclear power pipelines by means of Excel sheets. The pipeline inflection point coordinate calculating method includes: building seven sheets including a print page sheet, a coordinate point sheet, an intermediate node sheet, a sequence node sheet, a trigonometry calculator sheet, a reference point calculator sheet and a reference point sheet by the EXCEL according to fixed rules; and automatically calculating coordinates of different inflection points by selecting different worksheets through the inflection points at ends and in the middles of pipelines according to drawings respectively. By the pipeline inflection point coordinate calculating method which is simple and convenient, complicated calculation of coordinates can be simplified, calculation is accurate, and accordingly work efficiency is improved.

Description

Pipeline flex point coordinate calculator

Technical field

The present invention relates to a kind of pipeline flex point Coordinate Calculation method; Belong to the technical field of utilizing electronic information technology data to be handled Calculation Method; Belong to specifically and mainly utilize electronic data sheet to pipeline, particularly the flex point coordinate of nuclear power pipeline carries out the technical field of Calculation Method.

Background technology

(so-called nuclear island is the general designation that the nuclear reactor in the nuclear power plant containment shell reaches each system relevant with reactor, i.e. nuclear steam supply system and auxiliary facility thereof and their place factory buildings in the nuclear island installation work.The major function of nuclear island is to utilize nuclear fission can produce steam.Mainly comprise reactor building (RX), nuclear fuel factory building (KX), control auxiliary plant (NX), electrical building (LX) etc.); Design feature because of RX factory building (containment) cylinder type; Be the precision of assurance installation and carrying out smoothly of installment work, piping erection must be carried out the trust of coordinate points, especially flex point and measure; Flex point is the common name of nuclear power pipeline industry to the pipeline corner, i.e. principal point on the pipeline; And often only providing a reference point in the design drawing, a large amount of flex point coordinates of relative datum point can't obtain through simple computation, need through serial computing; Present stage, the method for coordinates computed point mainly contained two kinds: the application of first utilization band trigonometric function counter, and the 2nd, utilize the application of AutoCAD.

For example:, be the coordinate that example is asked tested point D (A, B, C, D are the code names of expression point in this example, have nothing to do with flex point serial number A, B, C... in the computation sheet) with the coordinate of asking tested point D among Fig. 1 to a kind of situation that the most often runs into;

This problem at first will be looked into designing technique file " datum plate coordinate ", finds the coordinate figure of reference point A (0.30.14), B (0.30.11), because of straight line AB in coordinate system, not parallel with X, Y axle, so can't obtain through the direct plus-minus of the size of giving among the figure.

As adopting the application of calculating band trigonometric function counter, the coordinate figure of at first finding reference point A (0.30.14), B (0.30.11) is respectively A (X ₁, Y ₁), B (X ₂, Y ₂), do the boost line of paralleled by X axis then through the A point, do the boost line of parallel Y axle through the B point, establish two lines and meet at a C (X ₂, Y ₁).According to exterior angle in the triangle and theorem and Pythagorean theorem, draw the D point coordinate; Above calculation procedure is many, and calculated amount is big, very easily makes mistakes.

Adopt CAD can reduce amount of calculation, increase work efficiency; All to thumb the reference point handbook but run into this kind situation at every turn, and computer software is had requirement, consider that everyone CAD operant level does not wait; And; All to import the excel form after each flex point coordinate Calculation finishes and print the trust measurement, visible, adopt CAD coordinates computed point to have certain limitation.

Through above computation process, can find out as adopting Traditional calculating methods, or process is loaded down with trivial details, calculated amount greatly, very easily make mistakes, or require level of skill high to personnel.Amount of calculation to these two kinds of methods is big, step is many, easy error, inefficiency, the demanding characteristics of level of skill, and nuclear power is installed needs a kind of easier method especially in the industry.

Summary of the invention

The invention provides a kind of EXCEL of utilization data form to pipeline flex point Coordinate Calculation method,, guarantee that again calculating is accurate and method is simple and convenient, the purpose of increasing work efficiency to realize both having simplified the complicated computation process of coordinate points.

For reaching described purpose technical scheme of the present invention be:

A kind of pipeline flex point coordinate calculator comprises the steps:

(1) the initial preparation; Utilize data form EXCEL to set up seven forms by unalterable rules respectively:

Print page table, accomplish the flex point coordinate data that needs printout in order to preserve to calculate;

The coordinate points table is in order to preserve the flex point coordinate data of calculating after accomplishing;

The intermediate node table, other flex point coordinate datas on the drawing when being first flex point of non-line end in order to calculate known flex point coordinate;

The order node table, other flex point coordinate datas on the drawing when being first flex point of line end in order to calculate known flex point coordinate;

Triangulation calculation device table is in order to calculate the particular point coordinate data that tested point increment on the X axle of known point, the Y axle does not directly provide;

Reference point counter table needs the flex point coordinate data of calculating through reference point;

The reference point table; Carry out the datum plate coordinate raw data of value according to nuclear power design drawing nuclear island datum plane plate arrangenent diagram, be the data source of this reference point counter table;

(2) take drawing;

(3) compile the flex point sequence number; Wait axle figure to what needs calculated flex point, at first be with comprise all flex points of pipeline end points and intersecting point from an end successively by English capitalization A, B, C, D, E, F, G, H... numbering, this numbering is followed the flex point of known coordinate is numbered the forward principle of trying one's best;

(4) if known point is the pipeline end points; Get into described order node table; Progressive rapid (six);

(5) if known point is the pipeline intermediate point; Get into described intermediate node table, import the sequence number of known flex point;

(6) judge; Known point has directly provided the X of coordinate, the Y value; Progressive rapid (eight);

(7) coordinate of calculating known point; If provided the distance of known point to two block reference coordinate plate, utilization reference point counter table calculates the coordinate of known flex point; Otherwise utilization triangulation calculation device table calculates the coordinate of known flex point;

(8) coordinate of the known flex point of input; According to known flex point is coordinate difference input sequence node table or the intermediate node table of the difference of pipeline end points or intermediate point with known flex point;

(9) import the variable of all the other flex point coordinates; The variable of all the other flex point coordinates in the input drawing in order node table that step (eight) limits or intermediate node table;

(10) obtain each flex point coordinate; Order node table or intermediate node table can calculate the coordinate of each flex point automatically, and the coordinate of each flex point of gained is copied to waiting axle drawing corresponding position;

Duplicate (11); Each flex point coordinate data of calculate accomplishing in order node table or the intermediate node table duplicated paste in the coordinate points table;

(12) are preserved and are accomplished; In the coordinate points table, preserve the data of accomplishing and can pass through to print the page table printout.

This printing page table is to be set up by the EXCEL blank form, and its establishment step is:

The first step is provided with type style, in preceding two row input headers, sets and prints top header line and margin;

Second step; Sequence number is set; Be listed as the 3rd row beginning to the 100th row at A and import formula=IF (B

=" " eventually respectively; " "; ROW ()-2), wherein

number representative unit lattice belong to line number;

The 3rd step was provided with conditional formats, and form has been arranged to then data tape frame of data; Select all cells of worksheet at first entirely, open conditional formats, (FALSE), formatting becomes the band edge frame to input formula=IF for A1 <>" ", TRUE in rule.

This prints top title behavior second row, and the field that is provided with from left to right is a sequence number, drawing number, release, room number, coordinate sequence number, X, Y, Z.

This coordinate points table is to be set up by the EXCEL blank form, and its establishment step is:

The first step is provided with input header, in preceding two row input headers, sets the top header line;

Second step was provided with shortcut, and shortcut is defined as Ctrl+Shift+B; Open macro editor, be provided with grand.

This top title behavior second row, the field that is provided with from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, Δ X, Y, Δ Y, Z, zone and remarks;

This is provided with grand steps in sequence: select C to be listed as the row to M, copy data is opened the printing page table, selected cell lattice B1; Click right button, PASTE SPECIAL is pasted numerical value, deletion C row, D row; Deletion G row, deletion H row, it is 5 that A row col width is set, it is 20 that B row col width is set; It is 5 that C row col width is set, and it is 10 that D row col width is set, be provided with E be listed as to H row col width be 9, preserve to accomplish.

This intermediate node table is to be set up by the EXCEL blank form, and its establishment step is:

The first step is provided with the input Back ground Information, input header row and related description and sign; Counting fourth lines downwards from header line, to be made as initial row M capable, and cell zone C 6:M6, J3:J11, L3:M11 are arranged to rose; I3:I5, I7:I11, K3:K5, K7:K11 are arranged to yellow;

Second step, input function;

At first;, the C row import formula=IF (J =" " successively in removing the capable cell of numbering M; " "; C#);, the D row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; D#);, the E row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; E#); In F row remove the capable cell of numbering M, import successively formula=IF (J =" ", " ", F#);, the G row import formula=IF (J =" " successively in removing the capable cell of numbering M; " " G#), imported formula=IF (C

=" " successively in the cell of N row; " "; MID (C , 6,3));

number is not less than 3 for the row at cell place number and

number in the formula; As cell numbering M capable above then # be the number of being expert at+1, as cell number M capable below then # be the number of being expert at-1;

Its two, above H row M is capable, import formula=IF (AND (H#=" D "), " C ", IF (AND (H#=" C "), " B ", IF (H#=" B ", " A ", " "))) in the cell successively, be the row at cell place number+1 # number in the formula; Below H row M is capable, import formula successively in the cell

＝IF(AND(J

＝″″)，″″，IF(AND(H#＝″D″)，″E″，IF(AND(H#＝″C″)，″D″，IF(H#＝″B″，″C″，″″))))，

＝IF(AND(J

＝″″)，″″，IF(AND(H#＝″E″)，″F″，IF(AND(H#＝″D″)，″E″，IF(H#＝″C″，″D″，″″))))，

＝IF(AND(J

＝″″)，″″，IF(AND(H#＝″F″)，″G″，IF(AND(H#＝″E″)，″F″，IF(H#＝″D″，″E″，″″))))，

＝IF(AND(J

＝″″)，″″，IF(AND(H#＝″G″)，″H″，IF(AND(H#＝″F″)，″G″，IF(H#＝″E″，″F″，″″))))，

=IF (AND (J

=" "); " "; IF (AND (H#=" H "), " I ", IF (AND (H#=" G "); " H "; IF (H#=" F ", " G ", " "))));

number is the row at cell place number in the formula, is the cell number of being expert at-1 # number;

They are three years old;, the I row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; I#+J

);, the K row import formula=IF (L

=" " successively in removing the capable cell of numbering M; " "; K#+L

);

number is the row at cell place number in the formula; If cell numbering M capable above be the cell number of being expert at+1 # number, if cell number M capable below be the cell number of being expert at-1 # number;

The 3rd step was provided with shortcut Ctrl+Shift+Z, opened macro editor, was provided with grand;

The 4th step, the protection worksheet;

Select worksheet entirely, by right mouse button opening the cell formats check box is set, select the protection label, the selection marker before cancellation locks, hides is confirmed;

Select all cells except that the cell that is coated with rose-red color in the worksheet, the cell formats check box is set, select the protection label, select the selection marker before locking, hiding, confirm by right mouse button opening;

Open protection worksheet check box; Setting code under the password that when the protection of cancellation worksheet, uses; Select locked cell selected lattice, selected non-locking cell down all users that allow this worksheet, column format is set, row format is set confirms, input password once more, definite.

This title behavior second row, the field that is provided with from left to right is numbering, sequence number, drawing number; System, state, release, room number; The coordinate sequence number, X, Δ X, Y; Δ Y, Z, zone and remarks, the A row in the corresponding form, B row, C row, D row, E row, F row, G row, H row, I row, J row, K row, L row, M row, N row and O row respectively;

This is provided with grand steps in sequence: selected cell lattice J3:J11, clear data, and selected cell lattice L3:M11 clears data, and selected cell lattice H3:K6 clears data, and preserves and accomplishes, and withdraws from.

This order node table is to be set up by the EXCEL blank form, and its establishment step is:

The first step is provided with the input Back ground Information, input header row and related description and sign; Cell zone C 3:M3, J4:J10, L4:M10 are arranged to rose, cell area I 4:I10, K4:K10 are arranged to yellow, at H 3 cells input capitalization A;

Second step, input function,

At first, several second goes under this header line,

C leu time input formula=IF (J=" ", " ", C#),

D leu time input formula=IF (J=" ", " ", D#),

E leu time input formula=IF (J=" ", " ", E#),

F leu time input formula=IF (J=" ", " ", F#),

G leu time input formula=IF (J=" ", " ", G#),

I leu time input formula=IF (J=" ", " ", I#+J),

K leu time input formula=IF (J=" ", " ", K#+L);

The formula medium size is the row number at cell place, is the number of being expert at-1 # number;

Its two, several second goes under this header line,

H leu time input formula=IF (J=" ", " ", " § "), the formula medium size is the row number at cell place, § number increase according to line number, be followed successively by capital B, C, D, E, F, G ...;

Its three, several first goes under this header line, in N column unit lattice, imports formula=MID (C, 6,3) successively, the formula medium size is the row number at cell place;

The 3rd step was provided with shortcut Ctrl+Shift+A, opened macro editor, was provided with grand;

The 4th step, the protection worksheet,

Select worksheet entirely, the cell formats check box is set, select the protection label, select the selection marker before locking, hiding, confirm by right mouse button opening;

Open and allow user's editing area, click newly-built button, under the check box precedents table entry that ejects; Choose rose part cell, click definitely, protection worksheet button is arranged in the lower left of the check box that allows user's editing area; Click it; Eject protection Sheet Options card, the password (P) that when the protection of cancellation worksheet, uses is setting code down, carries out (O) all users that allow this worksheet and selects locked cell selected lattice, selected non-locking cell down, column format is set, confirms after row format is set; Input password once more, confirm.

This title behavior second row, the field that is provided with from left to right is numbering, sequence number, drawing number; System, state, release, room number; Coordinate in proper order number, X, Δ X, Y; Δ Y, Z, zone and remarks, the A row in the corresponding form, B row, C row, D row, E row, F row, G row, H row, I row, J row, K row, L row, M row, N row and O row respectively;

This is provided with grand steps in sequence: selected cell lattice I3:M3, clear data, and selected cell lattice J4:J11 clears data, and selected cell lattice L4:M11 clears data, and preserves and accomplishes, and withdraws from.

This triangulation calculation device table is to be set up by the EXCEL blank form, and its establishment step is:

The first step is provided with the input Back ground Information, respectively by asking intermediate point and asking end points to set up header line and related description and sign; Cell area B 4:D4, B5:C5, B9:D9, B10:C10 are arranged to rose, cell district F4:F5, F9:F10 are arranged to yellow;

Second step, input function,

In D5, D10 cell, import formula=SQRT ((C#*C#)+(C*C)) respectively,

In E4, E5 cell, import formula=IF (D4=" " respectively, " ", C*D4/D5),

In E9, E10 cell, import formula=IF (D9=" " respectively, " " ,-C*D9/D10),

In F4, F5 cell, import formula=IF (D4=" " respectively, " ", B+E),

In F9, F10 cell, import formula=IF (D9=" " respectively, " ", B+E),

Be the cell number of being expert at-1 # number in the formula, number be the cell number of being expert at;

In the 3rd step, it is grand that shortcut Ctrl+Shift+Q is set; It is grand that shortcut Ctrl+Shift+S is set;

The 4th step, the protection worksheet,

Open and allow user's editing area, click newly-built button, under the check box precedents table entry that ejects; Choose red part cell, click definitely, protection worksheet button is arranged in the lower left of the check box that allows user's editing area; Click it, eject protection Sheet Options card, setting code under the password that when the protection of cancellation worksheet, uses; Under all users that allow this worksheet, select locked cell selected lattice, selected non-locking cell, column format is set, row format is set; Confirm, input password once more, confirm.

This asks intermediate point is that known point is called equilateral triangle and asks intermediate point when the triangle angular vertex; This asks end points is that known point makes anti-triangle ask end points on triangle edges;

This title behavior field name is claimed second corresponding identical row and the 7th row, and the field that is provided with from left to right from secondary series is known point A, and Δ is known, L, and Δ is surveyed and tested point, respectively the B row in the corresponding form, C row, D row, E row and F row;

This is provided with the grand steps in sequence of shortcut Ctrl+Shift+Q: selected cell lattice B4:C5, clear data, and selected cell lattice D4 clears data, and preserves and accomplishes;

This is provided with the grand steps in sequence of shortcut Ctrl+Shift+S: selected cell lattice B9:C10, clear data, and selected cell lattice D9 clears data, and preserves and accomplishes.

This reference point counter table is to be set up by the EXCEL blank form, and its establishment step is:

The first step is provided with the input Back ground Information, input header row and related description and sign; 4:E4 is arranged to rose with the cell area B, and F5:F6 is arranged to yellow with the cell zone, and corresponding table cell col width, row height are set;

Second step, input function,

At B5 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, reference point! A:C, 2,0)),

At B6 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, reference point! A:C, 3,0)),

At C5 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, reference point! A:C, 2,0)),

At C6 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, reference point! A:C, 3,0)),

At D6 cell input formula=IF (E4=" ", " ", IF (D5=" ", IF (D4＜0 ,-1,1), IF ((J5*D5)＜0 ,-1,1))),

At E6 cell input formula=IF (E4=" ", " ", IF (E5=" ", IF (E4＜0 ,-1,1), IF ((J6*E5)＜0 ,-1,1))),

At F5 cell input formula=IF (E4=" ", " ", IF (B5=C5, B5+E4, IF (C6=B6, B5+D4, I5*E6+G5))),

At F6 cell input formula=IF (E4=" ", " ", IF (B5=C5, B6+D4, IF (C6=B6, B6+E4, (C5-B5) * F5/ (B6-C6)+G6-(C5-B5) * G5/ (B6-C6)))),

At G5 cell input formula=H5*D6+B5,

At * G5+B6-(B6-C6) the * B5/ (B5-C5) of G6 cell input formula=(B6-C6)/(B5-C5),

At H5 cell input formula=SQRT (D4*D4/ (1+ (B6-C6)/(B5-C5) * (B6-C6)/(B5-C5))),

At H6 cell input formula=(C6-B6)/(C5-B5),

At I 5 cells input formula=SQRT (E4*E4/ (1+ (C5-B5)/(B6-C6) * (C5-B5)/(B6-C6))),

At I 6 cells inputs formula=(C5-B5)/(B6-C6),

At J 5 cells inputs formula=(C6-B6)/(C5-B5),

At J6 cell input formula=(B5-C5)/(C6-B6);

The 3rd step was provided with shortcut Ctrl+Shift+D, opened macro editor, was provided with grand;

The 4th step, hide form, selected G row, H row, I row, J row, a mouse click right button is selected to hide, and then accomplishes this step;

The 5th step, the protection worksheet,

Open and allow user's editing area, click newly-built button, under the check box precedents table entry that ejects; Choose red part cell, click definitely, protection worksheet button is arranged in the lower left of the check box that allows user's editing area; Click it; Eject protection Sheet Options card, setting code under the password that when the protection of cancellation worksheet, uses is selected locked cell selected lattice, selected non-locking cell down all users that allow this worksheet, column format is set, that row format is set is definite; Input password once more, confirm.

This title behavior second row, the field that is provided with from left to right from secondary series is reference point A, reference point B, L, H and tested point D, the B row in the corresponding form, C row, D row, E row and F row respectively;

This is provided with the grand steps in sequence of shortcut Ctrl+Shift+D: selected cell lattice B4:E4, clear data, and selected cell lattice B4 preserves and accomplishes.

This reference point table is to be set up by the EXCEL blank form, and its establishment step is:

The input Back ground Information is set, input header row and related description and sign; This title behavior first row, the field that is provided with from left to right is the reference point numbering, X and Y, the A row in the corresponding form, B row and C row respectively.

Adopt the method for technical scheme of the present invention and use former method coordinates computed to entrust assessing the cost of measuring owing to adopt the form calculating flex point coordinate of EXCEL electrical form to reduce; Utilize former computing method on average per hour can only accomplish less than the defeated machine of the calculating of 10 drawings; After adopting this scheme; The per hour minimum defeated machine of calculating of accomplishing 20 drawings, efficiency improves greatly.In addition, when adopting former method to calculate, the reckoner is necessary for the pipe technology personnel; And be familiar with trigonometric function or Auto CAD, and after using this form, common documenter can accomplish Coordinate Calculation and entrust; Reduced technical requirement, greatly reduced expense, reached and both simplify the complicated computation process of coordinate points personnel; Guarantee that again calculating is accurate and method is simple and convenient, the effect of increasing work efficiency.

Description of drawings

Fig. 1 is a design drawing pipeline corner position synoptic diagram;

Fig. 2 is the operational flowchart of coordinates computed point of the present invention;

Fig. 3 is a type face list structure synoptic diagram of the present invention;

Fig. 4 is a coordinate points list structure synoptic diagram of the present invention;

Fig. 5 is an intermediate node list structure synoptic diagram of the present invention;

Fig. 6 is an order node table structural representation of the present invention;

Fig. 7 is a triangulation calculation device list structure synoptic diagram of the present invention;

Fig. 8 is a reference point counter list structure synoptic diagram of the present invention;

Fig. 9 is a reference point list structure synoptic diagram of the present invention;

Figure 10 calculates the synoptic diagram of flex point for Fig. 1 utilizes reference point counter table.

Embodiment

The present invention mainly comprises the content of two aspects: 1, the defeated machine of the calculating of coordinate points is entrusted and is measured; 2, the calculating of special coordinates point.Excel form through the office office software is realized.

Below in conjunction with accompanying drawing the method for technical scheme of the present invention is described in detail as follows.

As shown in Figure 2, a kind of pipeline flex point coordinate calculator comprises the steps:

(2) take drawing;

Introduce the foundation rule of seven forms below in detail and set up process:

Like Fig. 3, print page table, this worksheet mainly provides a blank worksheet, will calculate the data printout of accomplishing to make things convenient for us; This table is on common EXCEL blank form, to divide for three steps completed, and its establishment step is:

The first step is provided with type style, in preceding two row input headers, sees Fig. 3, sets and prints top header line and margin; This prints top title behavior second row, and the field that is provided with from left to right is a sequence number, drawing number, release, room number, coordinate sequence number, X, Y, Z.

=" " eventually respectively; " "; ROW ()-2), wherein

number representative unit lattice belong to line number;

Like Fig. 4; Coordinate points table, this worksheet are the storage areas of coordinate points data, are about to through " intermediate node table ", " order node table " data storing after calculating is accomplished so far; Need after going into operation like certain zone to entrust when measuring; After can in this table, filtering out the zone that needs to print, can data being exported to " printing page table " this coordinate points table by shortcut is to be set up by the EXCEL blank form, and its establishment step is:

The first step is provided with input header, and in preceding two row input headers, Fig. 4 sets the top header line; This top title behavior second row, the field that is provided with from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, Δ X, Y, Δ Y, Z, zone and remarks;

Second step was provided with shortcut, shortcut was defined as Ctrl+Shift+B, above that defmacro; Open macro editor, be provided with grand.This is provided with grand steps in sequence: select C to be listed as the row to M, copy data is opened the printing page table, selected cell lattice B1; Click right button, PASTE SPECIAL is pasted numerical value, deletion C row, D row; Deletion G row, deletion H row, it is 5 that A row col width is set, it is 20 that B row col width is set; It is 5 that C row col width is set, and it is 10 that D row col width is set, be provided with E be listed as to H row col width be 9, preserve to accomplish.

Like Fig. 5, used form when intermediate node table, this table are first flex point of the non-line end of the flex point of known coordinate point, this intermediate node table are to be set up by the EXCEL blank form, and its establishment step is:

Second step, input function;

At first;, the C row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; C#);, the D row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; E#); In F row remove the capable cell of numbering M, import successively formula=IF (J

=" ", " ", F#t);, the G row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " " G#), imported formula=IF (C

=" " successively in the cell of N row; " "; MID (C , 6,3));

number is not less than 3 for the row at cell place number and

＝IF(AND(J

＝IF(AND(J

＝IF(AND(J

＝IF(AND(J

=IF (AND (J

=" "); " ", IF (AND (H#=" H "), " I "; IF (AND (H#=" G "); " H ", IF (H#=" F ", " G "; " ")))), in the formula

Number be the row at cell place number, be the cell number of being expert at-1 # number;

They are three years old;, the I row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; I#+J

);, the K row import formula=IF (L

=" " successively in removing the capable cell of numbering M; " "; K#+L

);

In the 3rd step, shortcut Ctrl+Shift+Z is set, above that defmacro; Open macro editor, be provided with grand; This is provided with grand steps in sequence: selected cell lattice J3:J11, clear data, and selected cell lattice L3:M11 clears data, and selected cell lattice H3:K6 clears data, and preserves and accomplishes, and withdraws from.

The 4th step, the protection worksheet;

In practical operation:

1. this form is applicable to that known point is the situation of intermediate point, at first drawing information is imported in the corresponding rose frame, and definite then known point numbering is inserted respective blocks;

2, Δ X is the variable on the point-to-point transmission X axle, and Δ Y is the variable on the point-to-point transmission Y axle, notes distinguishing positive and negative;

3, after input finishes, duplicate to paste in ' coordinate points ' worksheet and get final product;

Can only in the rose frame, import respective value when 4, operating, after input finishes, be shown as the value of tested point in the yellow frame.

5, emptying shortcut is Ctrl+Shift+Z.

Like Fig. 6, order node table, this table are the flex point of known coordinate point used forms when being first flex point of line end, and this order node table is to be set up by the EXCEL blank form, and branch four goes on foot and completes, and its establishment step is:

The first step is provided with the input Back ground Information, input header row and related description and sign; Cell zone C 3:M3, J4:J10, L4:M10 are arranged to rose, cell area I 4:I10, K4:K10 are arranged to yellow, at H3 cell input capitalization A;

This order node table title behavior second row, the field that is provided with from left to right is numbering, sequence number, drawing number; System, state, release, room number; Coordinate in proper order number, X, Δ X, Y; Δ Y, Z, zone and remarks, the A row in the corresponding form, B row, C row, D row, E row, F row, G row, H row, I row, J row, K row, L row, M row, N row and O row respectively;

Second step, input function,

At first, several second goes under this header line,

C leu time input formula=IF (J=" ", " ", C#),

D leu time input formula=IF (J=" ", " ", D#),

E leu time input formula=IF (J=" ", " ", E#),

F leu time input formula=IF (J=" ", " ", F#),

G leu time input formula=IF (J=" ", " ", G#),

I leu time input formula=IF (J=" ", " ", I#+J),

K leu time input formula=IF (J=" ", " ", K#+L);

Its two, several second goes under this header line,

The 3rd step was provided with shortcut Ctrl+Shif t+A, was provided with grand above that; Open macro editor, be provided with grand; This is provided with grand steps in sequence: selected cell lattice I3:M3, clear data, and selected cell lattice J4:J11 clears data, and selected cell lattice L4:M11 clears data, and preserves and accomplishes, and withdraws from.

The 4th step, the protection worksheet,

In practical operation:

1, Ben Biaoge is applicable to that known point is the situation of starting point;

2, drawing information is imported in the corresponding rose frame, Δ X is the variable on the point-to-point transmission X axle, and Δ Y is the variable on the point-to-point transmission Y axle, notes distinguishing positive and negative;

5, emptying shortcut is Ctrl+Shift+A.

Like Fig. 7; Triangulation calculation device table; This table is main to calculate the situation that tested point increment on the X axle of known point, the Y axle does not directly provide, and belongs to the category of particular point coordinate Calculation, and it can be divided into two kinds of situations; Be called equilateral triangle (asking intermediate point) to known point when the triangle angular vertex, on triangle edges, be anti-triangle (asking end points) known point; This triangulation calculation device table is to be set up by the EXCEL blank form, divides for four steps completed, and its establishment step is:

Second step, input function,

In D5, D10 cell, import formula=SQRT ((C#*C#)+(C*C)) respectively,

In E4, E5 cell, import formula=IF (D4=" " respectively, " ", C*D4/D5),

In E9, E10 cell, import formula=IF (D9=" " respectively, " " ,-C*D9/D10),

In F4, F5 cell, import formula=IF (D4=" " respectively, " ", B+E),

In F9, F10 cell, import formula=IF (D9=" " respectively, " ", B+E),

The 4th step, the protection worksheet,

In practical operation:

1, the known point coordinate is inserted in the corresponding rose frame of known point, Δ is known as known variables on the figure, distinguishes positive and negative;

2, like the right figure of Fig. 7, the L value is the distance of known point to tested point; Δ is surveyed and is the variable of known point to tested point;

Can only in the rose frame, import respective value when 3, operating, after input finishes, be shown as the value of tested point in the yellow frame.

4, asking intermediate computations device point to empty shortcut is Ctrl+Shift+Q, and asking the end points counter to empty shortcut is Ctrl+Shift+S.

Like Fig. 8, reference point counter table, this table be need through reference point just used during the situation of possible coordinates computed point.This table is on common excel blank form, to divide for four steps completed, and this reference point counter table is to be set up by the EXCEL blank form, and its establishment step is:

Second step, input function,

At D6 cell input formula=IF (E4=" ", " ", IF (D5=" ", IF (D4＜0 ,-1,1), IF ((J 5*D5)＜0 ,-1,1))),

At G5 cell input formula=H5*D6+B5,

At * G5+B6-(B6-C6) the * B5/ (B5-C5) of G6 cell input formula=(B6-C6)/(B5-C5),

At H5 cell input formula=SQRT (D4*D4/ (1+ (B6-C6)/(B5-C5) * (B6-C6)/(B5-C5))),

At H6 cell input formula=(C6-B6)/(C5-B5),

At I5 cell input formula=SQRT (E4*E4/ (1+ (C5-B5)/(B6-C6) * (C5-B5)/(B6-C6))),

At I6 cell input formula=(C5-B5)/(B6-C6),

At J5 cell input formula=(C6-B6)/(C5-B5),

At J6 cell input formula=(B5-C5)/(C6-B6);

The 3rd step was provided with shortcut Ctrl+Shift+D, opened macro editor, was provided with grand; This is provided with the grand steps in sequence of shortcut Ctrl+Shift+D: selected cell lattice B4:E4, clear data, and selected cell lattice B4 preserves and accomplishes.

The 5th step, the protection worksheet,

In practical operation:

1, the reference point numbering is inserted in the corresponding rose frame, noted distinguishing A, B point, the reference point of band dimensioning is the A point, and another point is the B point;

2, like the right figure of Fig. 8, the L value is the known distance on the straight line of being confirmed by reference point, when C point with respect to A point during in X axle positive dirction, the L value is being for just, otherwise is to bear; Vertical range on the H value straight line that to be tested point confirm to reference point, when D point with respect to C point during in X axle positive dirction, the H value is being for just, otherwise is to bear;

4, emptying shortcut is Ctrl+Shift+D.

Like Fig. 9, reference point table, this table are the data sources of " reference point counter table "; Data based nuclear power design drawing in this table " nuclear island datum plane plate arrangenent diagram " carries out value, directly gets final product by this table of the input of form shown in the last figure getting data in this design document; This reference point table is to be set up by the EXCEL blank form, and its establishment step is:

Equally, the example of mentioning to Fig. 1 calculates the D point coordinate, the utilization form, and existing data are directly inserted corresponding form in only needing to scheme, and can obtain required result, like Figure 10:

2, like the right figure of Figure 10, the L value is the known distance on the straight line of being confirmed by reference point, when C point with respect to A point during in X axle positive dirction, the L value is being for just, otherwise is to bear; Vertical range on the H value straight line that to be tested point confirm to reference point, when D point with respect to C point during in X axle positive dirction, the H value is being for just, otherwise is to bear;

4, emptying shortcut is Ctrl+Shift+D.

This form successful Application and is obtained good result in the nuclear island installation work of mountain range Australia second phase.

In sum; After axles such as taking portion is schemed; At first be that all flex points (comprising pipeline end points and intersecting point) are compiled A, B, C, D, E, F, G, H... successively from an end, a principle will following during numbering is exactly that the flex point numbering of known coordinate is forward as far as possible.Every part is waited the known point of figure nothing more than two types, and the one, at the pipeline end points, the one, a certain flex point in the middle of pipeline, two types of situation corresponding respectively node and intermediate nodes are in proper order selected the different working table according to the drawing situation.

Divide two kinds of situation again to the known point coordinate, the one, directly given the X of coordinate, Y value, this type situation are directly calculated with corresponding order node or intermediate node and are got final product; The 2nd, provided the distance of known point to two block reference coordinate plate, this type situation need be used the reference point counter, calculates the coordinate of known point earlier, calculates with corresponding order node or intermediate node computation sheet again.

In corresponding form, after input known point coordinate and the sequence number,, need to add and subtract definite through the variable of X given in the drawing, Y coordinate for asking each point coordinate; In the design drawing, the given X of great majority, Y variable can directly be used for calculating, but still have part; The variable that provides not is to the variable of waiting to ask a little; Need to obtain this variable through calculating, at this moment available triangulation calculation device calculates, and obtains the calculating that variable is used for corresponding form.

After this all flex points of drawing are calculated and are finished; The coordinate of all flex points is copied to waiting on the axle drawing; Use in order to site operation, and will calculate the data of accomplishing (result of calculation that order node or intermediate node computation sheet are interior), duplicate and paste in the coordinate points worksheet; Be kept in the computing machine with the excel data layout, measure in order to follow-up trust and use.

Claims

1. a pipeline flex point coordinate calculator is characterized in that comprising the steps:

(2) take drawing;

2. pipeline flex point coordinate calculator as claimed in claim 1 is characterized in that this printing page table is to be set up by the EXCEL blank form, and its establishment step is:

=" " eventually respectively; " "; ROW ()-2), wherein number representative unit lattice belong to line number;

3. pipeline flex point coordinate calculator as claimed in claim 2 is characterized in that this printing top title behavior second row, and the field that is provided with from left to right is a sequence number, drawing number, release, room number, coordinate sequence number, X, Y, Z.

4. pipeline flex point coordinate calculator as claimed in claim 1 is characterized in that this coordinate points table is to be set up by the EXCEL blank form, and its establishment step is:

5. pipeline flex point coordinate calculator as claimed in claim 4 is characterized in that this top title behavior second row, and the field that is provided with from left to right is numbering, sequence number, drawing number, system; State, release, room number, coordinate sequence number, X; Δ X, Y, Δ Y, Z, zone and remarks;

6. pipeline flex point coordinate calculator as claimed in claim 1 is characterized in that this intermediate node table is to be set up by the EXCEL blank form, and its establishment step is:

Second step, input function;

At first;, the C row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; C#);, the D row import formula=IF (J =" " successively in removing the capable cell of numbering M; " "; D#);, the E row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; E#);, the F row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; F#); In G row remove the capable cell of numbering M, import successively formula=IF (J =" ", " ", G#); In the cell of N row, import formula=IF (C =" " successively; " ", MID (C

6,3));

number is not less than 3 for the row at cell place number and

＝IF(AND(J

＝IF(AND(J

＝IF(AND(J

＝IF(AND(J

=IF (AND (J

=" "); " "; I F (AND (H#=" H "), " I ", IF (AND (H#=" G "); " H "; IF (H#=" F ", " G ", " "))));

They are three years old;, the I row import formula=IF (J

=" " successively in removing the capable cell of numbering M; " "; I#+J

);, the K row import formula=IF (L

=" " successively in removing the capable cell of numbering M; " "; K#+L

);

The 4th step, the protection worksheet;

7. pipeline flex point coordinate calculator as claimed in claim 6 is characterized in that this title behavior second row, and the field that is provided with from left to right is numbering, sequence number, drawing number; System, state, release, room number; The coordinate sequence number, X, Δ X, Y; Δ Y, Z, zone and remarks, the A row in the corresponding form, B row, C row, D row, E row, F row, G row, H row, I row, J row, K row, L row, M row, N row and O row respectively;

This is provided with grand steps in sequence: selected cell lattice J3:J11, clear data, and selected cell lattice L3:M11 clears data, and selected cell lattice H 3:K6 clears data, and preserves and accomplishes, and withdraws from.

8. pipeline flex point coordinate calculator as claimed in claim 1 is characterized in that this order node table is to be set up by the EXCEL blank form, and its establishment step is:

Second step, input function,

At first, several second goes under this header line,

C leu time input formula=IF (J=" ", " ", C#),

D leu time input formula=IF (J=" ", " ", D#),

E leu time input formula=IF (J=" ", " ", E#),

F leu time input formula=IF (J=" ", " ", F#),

G leu time input formula=IF (J=" ", " ", G#),

I leu time input formula=IF (J=" ", " ", I#+J),

K leu time input formula=IF (J=" ", " ", K#+L);

Its two, several second goes under this header line,

The 4th step, the protection worksheet,

9. pipeline flex point coordinate calculator as claimed in claim 8 is characterized in that this title behavior second row, and the field that is provided with from left to right is numbering, sequence number, drawing number; System, state, release, room number; Coordinate in proper order number, X, Δ X, Y; Δ Y, Z, zone and remarks, the A row in the corresponding form, B row, C row, D row, E row, F row, G row, H row, I row, J row, K row, L row, M row, N row and O row respectively;

This is provided with grand steps in sequence: selected cell lattice I 3:M3, clear data, and selected cell lattice J4:J11 clears data, and selected cell lattice L4:M11 clears data, and preserves and accomplishes, and withdraws from.

10. pipeline flex point coordinate calculator as claimed in claim 1 is characterized in that this triangulation calculation device table is to be set up by the EXCEL blank form, and its establishment step is:

Second step, input function,

In D5, D10 cell, import formula=SQRT ((C#*C#)+(C*C)) respectively,

In E4, E5 cell, import formula=IF (D4=" " respectively, " ", C*D4/D5),

In E9, E10 cell, import formula=IF (D9=" " respectively, " " ,-C*D9/D10),

In F4, F5 cell, import formula=IF (D4=" " respectively, " ", B+E),

In F9, F10 cell, import formula=IF (D9=" " respectively, " ", B+E),

The 4th step, the protection worksheet,

11. pipeline flex point coordinate calculator as claimed in claim 10 is characterized in that this asks intermediate point is that known point is called equilateral triangle and asks intermediate point when the triangle angular vertex; This asks end points is that known point makes anti-triangle ask end points on triangle edges;

12. pipeline flex point coordinate calculator as claimed in claim 1 is characterized in that this reference point counter table is to be set up by the EXCEL blank form, its establishment step is:

Second step, input function,

At G5 cell input formula=H5*D6+B5,

At * G5+B6-(B6-C6) the * B5/ (B5-C5) of G6 cell input formula=(B6-C6)/(B5-C5),

At H5 cell input formula=SQRT (D4*D4/ (1+ (B6-C6)/(B5-C5) * (B6-C6)/(B5-C5))),

At H6 cell input formula=(C6-B6)/(C5-B5),

At I5 cell input formula=SQRT (E4*E4/ (1+ (C5-B5)/(B6-C6) * (C5-B5)/(B6-C6))),

At I6 cell input formula=(C5-B5)/(B6-C6),

At J5 cell input formula=(C6-B6)/(C5-B5),

At J6 cell input formula=(B5-C5)/(C6-B6);

The 5th step, the protection worksheet,

13. pipeline flex point coordinate calculator as claimed in claim 12 is characterized in that this title behavior second row, the field that is provided with from left to right from secondary series is reference point A; Reference point B; L, H and tested point D, the B row in the corresponding form, C row, D row, E row and F row respectively;

14. pipeline flex point coordinate calculator as claimed in claim 1 is characterized in that this reference point table is to be set up by the EXCEL blank form, its establishment step is: