CN102609447B - The computing method of pipeline inflection point coordinate - Google Patents
The computing method of pipeline inflection point coordinate Download PDFInfo
- Publication number
- CN102609447B CN102609447B CN201210002479.3A CN201210002479A CN102609447B CN 102609447 B CN102609447 B CN 102609447B CN 201210002479 A CN201210002479 A CN 201210002479A CN 102609447 B CN102609447 B CN 102609447B
- Authority
- CN
- China
- Prior art keywords
- row
- cell
- formula
- point
- coordinate
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of computing method of pipeline inflection point coordinate, belong to and mainly utilize electronic data sheet to pipeline, particularly the flex point coordinate of nuclear power pipeline carries out the technical field of the method calculated.Utilize data form EXCEL to set up by unalterable rules respectively and print page table, coordinate points table, intermediate node table, sequential node table, triangulation calculation device table, reference point counter table and reference point table seven form; According to being positioned at pipeline end points and middle flex point, different worksheets is selected automatically to calculate the coordinate of each flex point according to drawing situation respectively.The present invention can reach the computation process both having simplified coordinate points complexity, ensures that again calculating is accurate and method is simple and convenient, the effect of increasing work efficiency.
Description
Technical field
The present invention relates to a kind of computing method of pipeline inflection point coordinate, belong to the technical field utilizing electronic information technology to carry out processing the method calculated to data, 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 the method calculated.
Background technology
In nuclear island installation work, (so-called nuclear island is the general designation of nuclear reactor in nuclear power plant containment shell and each system relevant with reactor, i.e. nuclear steam supply system and auxiliary facility thereof and their place factory buildings.The major function of nuclear island utilizes nuclear fission energy to produce steam.Mainly comprise reactor building (RX), nuclear fuel factory building (KX), control auxiliary plant (NX), electrical building (LX) etc.), because of the design feature of RX factory building (containment) cylinder type, for ensureing the precision of installation and carrying out smoothly of installment work, Pipe installing must carry out coordinate points, especially the trust of flex point is measured, flex point is the common name of Nuclear piping industry to pipeline corner, the principal point namely on pipeline; And in design drawing, often only providing a reference point, a large amount of flex point coordinates of relative datum point cannot be obtained by simple computation, need through serial computing; Present stage, the method for coordinates computed point mainly contained two kinds: the first utilizes the application of band trigonometric function counter, and two is the application utilizing AutoCAD.
Citing: for a kind of situation the most often run into, (in this example, A, B, C, D are the code names represented a little, with flex point serial number A, B, C in computation sheet to ask tested point D to ask the coordinate of tested point D in Fig. 1 ... irrelevant) coordinate;
This problem, first to look into designing technique file " datum plate coordinate ", find the coordinate figure of reference point A (0.30.14), B (0.30.11), because of straight line AB in a coordinate system, not parallel with X, Y-axis, thus cannot by figure obtain to the direct plus-minus of size.
As adopted the application calculating band trigonometric function counter, first finding reference point A (0.30.14), the coordinate figure of B (0.30.11) is respectively A (X
1, Y
1), B (X
2, Y
2), then do the boost line of paralleled by X axis through A point, do the boost line of parallel Y-axis through B point, if two lines meet at a C (X
2, Y
1).According to exterior angle in triangle and theorem and Pythagorean theorem, draw D point coordinate; Above calculation procedure is many, and calculated amount is large, very easily makes mistakes.
Adopt CAD can reduce amount of calculation, increase work efficiency, but run into this kind of situation at every turn and all will thumb reference point handbook, and have requirement to computer software, the CAD operant level considering everyone is not etc., and, each flex point coordinate all will input excel Table Printing and entrust measurement after calculating, visible, adopts CAD coordinates computed point to have certain limitation.
By above computation process, can find out as adopted Traditional calculating methods, or process is loaded down with trivial details, calculated amount is made mistakes greatly, very easily, otherwise high to personnel requirement level of skill.Amount of calculation for these two kinds of methods is large, step is many, easily make mistakes, inefficiency, level of skill require high feature, and nuclear power installed rows needs in the industry a kind of easier method especially.
Summary of the invention
The invention provides a kind of EXCEL data form that utilizes to the computing method of pipeline inflection point coordinate, to realize the computation process both simplifying coordinate points complexity, ensure that again calculating is accurate and method is simple and convenient, the object of increasing work efficiency.
For reaching described object technical scheme of the present invention be:
Computing method for pipeline inflection point coordinate, comprise the steps:
(1) initially prepare; Data form EXCEL is utilized to set up seven forms by unalterable rules respectively:
Print page table, will the flex point coordinate data needing printout have been calculated in order to preserve;
Coordinate points table, in order to preserve the flex point coordinate data after having calculated;
Intermediate node table, in order to calculate when known flex point coordinate is non-line end first flex point other flex point coordinate datas on drawing;
Sequential node table, in order to calculate when known flex point coordinate is line end first flex point other flex point coordinate datas on drawing;
Triangulation calculation device table, in order to calculate the particular point coordinate data that on tested point to the X-axis, Y-axis of known point, increment does not directly provide;
Reference point counter table, needs the flex point coordinate data calculated by reference point;
Reference point table; Carrying out the datum plate coordinate raw data of value according to nuclear power design drawing nuclear island datum plane plate arrangenent diagram, is the data source of this reference point counter table;
(2) drawing is taken;
(3) flex point sequence number is compiled; Waiting axle figure to what need to calculate flex point, is first to comprise pipeline end points and all flex points of intersecting point from one end successively by English capitalization A, B, C, D, E, F, G, H ... numbering, this numbering is followed principle as far as possible forward for the flex point of known coordinate numbering;
(4) if known point is pipeline end points; Enter described sequential node table; Progressive rapid (six);
(5) if known point is pipeline intermediate point; Enter described intermediate node table, input the sequence number of known flex point;
(6) judge; Known point directly gives the X of coordinate, Y value; Progressive rapid (eight);
(7) coordinate of known point is calculated; If give the distance of known point to two blocks of reference coordinate plates, reference point counter table is used to calculate the coordinate of known flex point; Otherwise use triangulation calculation device table to calculate the coordinate of known flex point;
(8) coordinate of known flex point is inputted; Be that the difference of pipeline end points or intermediate point is by the coordinate of known flex point input sequence node table or intermediate node table respectively according to known flex point;
(9) variable of all the other flex point coordinates is inputted; The variable of all the other flex point coordinates in drawing is inputted in the sequential node table limited in step (eight) or intermediate node table;
(10) each flex point coordinate is obtained; Sequential node table or intermediate node table can calculate the coordinate of each flex point automatically, are copied by the coordinate of each for gained flex point to waiting axle drawing corresponding position;
(11) copy; The each flex point coordinate data calculated in sequential node table or intermediate node table being copied pastes in coordinate points table;
(12) have preserved; Data of having preserved in coordinate points table by printing page table printout.
This printing page table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges type style, in front two row input headers, sets and prints top header line and margin;
Second step, arranges sequence number, arranges the 3rd row begin to input formula=IF (B*=" " respectively, " ", ROW ()-2 eventually to the 100th row at A), wherein * representative unit lattice place line number;
3rd step, setting model form, has been arranged to data then data band frame by form; First entirely select all cells of worksheet, open conditional formats, input formula=IF (A1<> " " in rule, TRUE, FALSE), formatting becomes band frame.
This printing top title behavior second row, the field arranged from left to right is sequence number, drawing number, release, room number, coordinate sequence number, X, Y, Z.
This coordinate points table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input header, in front two row input headers, sets top header line;
Second step, arranges shortcut, and shortcut is defined as Ctrl+Shift+B; Open macro editor, arrange grand.
This top title behavior second row, the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, △ X, Y, △ Y, Z, region and remarks;
This arranges grand step and is followed successively by: select C to arrange to M row, copy data, open printing page table, selection unit lattice B1, clicks right button, PASTE SPECIAL, paste numerical value, delete C row, D row, delete G row, delete H row, arranging A row col width is 5, and arranging B row col width is 20, arranging C row col width is 5, arranging D row col width is 10, and arranging E, to arrange to H row col width be 9, and preservation completes.
This intermediate node table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Counting fourth line downwards from header line, to be set to initial row M capable, and rose is arranged in cell region C6: M6, J3: J11, L3: M11; I3: I5, I7: I11, K3: K5, K7: K11 is arranged to yellow;
Second step, input function;
First, formula=IF (J*=" " is inputted successively in the cell that C row are capable except numbering M, " ", C#), formula=IF (J*=" " is inputted successively in the cell that D row are capable except numbering M, " ", D#), formula=IF (J*=" " is inputted successively in the cell that E row are capable except numbering M, " ", E#), formula=IF (J*=" " is inputted successively in the cell that F row are capable except numbering M, " ", F#), formula=IF (J*=" " is inputted successively in the cell that G row are capable except numbering M, " ", G#), formula=IF (C*=" " is inputted successively in the cell of N row, " ", MID (C*, 6, 3)), in formula No. * be the line number at cell place and No. * be not less than 3, as cell above numbering M is capable then # be place line number+1, as cell in the capable below of numbering M then # be place line number-1,
Its two, in the capable upper unit lattice of H row M, input formula=IF (AND (H#=" D "), " C " successively, IF (AND (H#=" C "), " B ", IF (H#=" B ", " A ", " "))), in formula, No. # is the line number+1 at cell place; Formula is inputted successively in the capable lower unit lattice of H row M
＝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 ", " ")))), in formula, No. * is the line number at cell place, and No. # is cell place line number-1;
They are three years old, formula=IF (J*=" " is inputted successively except in the capable cell of numbering M at I row, " ", I#+J*), formula=IF (L*=" " is inputted successively, " " at K row except in the capable cell of numbering M, K#+L*), in formula, No. * is the line number at cell place, if cell is above numbering M is capable, No. # is cell place line number+1, if cell is in the capable below of numbering M, No. # is cell place line number-1;
3rd step, arranges shortcut Ctrl+Shift+Z, opens macro editor, arranges grand;
4th step, protection worksheet;
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, cancel locking, hide before selection marker, determine;
Select all cells except being coated with the cell of rose-red color in worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open protection worksheet check box; setting code under the password used when cancelling worksheet protection; carry out lower selection locked cell selected lattice, selected non-locking cell allowing all users of this worksheet, column format is set, row format is set determines, again input password, determine.
This title behavior second row, the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, △ X, Y, △ Y, Z, region and remarks, the A row respectively in 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;
This arranges grand step and is followed successively by: selection unit lattice J3: J11, clear data, and selection unit lattice L3: M11, clear data, and selection unit lattice H3: K6, clear data, and preservation completes, and exit.
This sequential node table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Rose is arranged in cell region C3: M3, J4: J10, L4: M10, yellow is arranged in cell region I4: I10, K4: K10, at H3 cell input capitalization A;
Second step, input function,
First, under this header line, several second row rises,
Time input formula=IF (J=" " of C leu, " ", C#),
Time input formula=IF (J=" " of D leu, " ", D#),
Time input formula=IF (J=" " of E leu, " ", E#),
Time input formula=IF (J=" " of F leu, " ", F#),
Time input formula=IF (J=" " of G leu, " ", G#),
Time input formula=IF (J=" " of I leu, " ", I#+J),
Time input formula=IF (J=" " of K leu, " ", K#+L);
Formula medium size is the line number at cell place, and No. # is place line number-1;
Its two, under this header line, several second row rises,
H leu time input formula=IF (J=" ", " ", " § "), formula medium size is the line number at cell place, No. § increase according to line number, be followed successively by capital B, C, D, E, F, G,
Its three, under this header line number the first row rise, in N column unit lattice, input formula=MID (C, 6,3) successively, formula medium size is the line number at cell place;
3rd step, arranges shortcut Ctrl+Shift+A, opens macro editor, arranges grand;
4th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area, click new buttons, under the check box precedents table entry ejected, choose rose unit lattice, click and determine, protection worksheet button is had in the lower left of the check box allowing user's editing area, click it, eject protection Sheet Options card, setting code under the password (P) used when cancelling worksheet protection, locked cell selected lattice are selected under allowing all users of this worksheet to carry out (O), selected non-locking cell, column format is set, determine after row format is set, again input password, determine.
This title behavior second row, the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate is in proper order number, X, △ X, Y, △ Y, Z, region and remarks, the A row respectively in 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;
This arranges grand step and is followed successively by: selection unit lattice I3: M3, clear data, and selection unit lattice J4: J11, clear data, and selection unit lattice L4: M11, clear data, and preservation completes, and exit.
This triangulation calculation device table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, respectively by asking intermediate point and asking end points to set up header line and related description and sign; Rose is arranged in cell region B4: D4, B5: C5, B9: D9, B10: C10, cell district F4: F5, F9: F10 is arranged to yellow;
Second step, input function,
Formula=SQRT ((C#*C#)+(C*C)) is inputted respectively in D5, D10 cell,
Formula=IF (D4=" " is inputted respectively, " ", C*D4/D5 in E4, E5 cell),
Formula=IF (D9=" " is inputted respectively, " " ,-C*D9/D10 in E9, E10 cell),
Formula=IF (D4=" " is inputted respectively, " ", B+E in F4, F5 cell),
Formula=IF (D9=" " is inputted respectively, " ", B+E in F9, F10 cell),
In formula, No. # is cell place line number-1, number is cell place line number;
3rd step, arranges shortcut Ctrl+Shift+Q grand; It is grand that shortcut Ctrl+Shift+S is set;
4th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area; click new buttons; under the check box precedents table entry ejected; choose RED sector cell; click and determine; protection worksheet button is had in the lower left of the check box allowing user's editing area; click it; eject protection Sheet Options card; setting code under the password used when cancelling worksheet protection, allowing all users of this worksheet to carry out lower selection locked cell selected lattice, selected non-locking cell, arrange column format, arrange row format, determines; again input password, determine.
This asks intermediate point to be that known point is called equilateral triangle when triangle angular vertex and asks intermediate point; This asks end points to be that known point makes anti-triangle ask end points in triangle edges;
Corresponding the second identical row of this title behavior field name and the 7th row, the field arranged from left to right from secondary series is known point A, and △ is known, and L, △ survey and tested point, the B row respectively in corresponding form, C row, D row, E row and F row;
This step arranging shortcut Ctrl+Shift+Q grand is followed successively by: selection unit lattice B4: C5, clear data, selection unit lattice D4, and clear data, preservation completes;
This step arranging shortcut Ctrl+Shift+S grand is followed successively by: selection unit lattice B9: C10, clear data, and selection unit lattice D9, clear data, preservation completes.
This reference point counter table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Rose is arranged in cell region B4: E4, yellow is arranged in cell region F5: F6, and by corresponding table cell col width, high setting of going;
Second step, input function,
At B5 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, a reference point! A:C, 2,0)),
At B6 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, a reference point! A:C, 3,0)),
At C5 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, a reference point! A:C, 2,0)),
At C6 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, a 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 G6 cell input formula=(B6-C6)/(B5-C5) * G5+B6-(B6-C6) * B5/ (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);
3rd step, arranges shortcut Ctrl+Shift+D, opens macro editor, arranges grand;
4th step, hides form, selected G row, H row, I row, J row, and a mouse click right button, selects to hide, then complete this step;
5th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area; click new buttons; under the check box precedents table entry ejected; choose RED sector cell; click and determine; protection worksheet button is had in the lower left of the check box allowing user's editing area; click it; eject protection Sheet Options card; setting code under the password used when cancelling worksheet protection; carry out lower selection locked cell selected lattice, selected non-locking cell allowing all users of this worksheet, column format is set, row format is set determines, again input password, determine.
This title behavior second row, the field arranged from left to right from secondary series is reference point A, reference point B, L, H and tested point D, the B row respectively in corresponding form, C row, D row, E row and F row;
This step arranging shortcut Ctrl+Shift+D grand is followed successively by: selection unit lattice B4: E4, clear data, and selection unit lattice B4, preservation completes.
This reference point table is set up by EXCEL blank form, and its establishment step is:
Input Back ground Information is set, input header row and related description and sign; This title behavior the first row, the field arranged from left to right is reference point numbering, X and Y, the A row respectively in corresponding form, B row and C row.
The method of technical solution of the present invention is adopted to use former method coordinates computed to entrust assessing the cost of measurement owing to adopting the form calculus flex point coordinate of EXCEL electrical form to reduce, utilize the former computing method on average defeated machine of calculating that can only complete less than 10 drawings per hour, after adopting the program, the minimum defeated machine of calculating completing 20 drawings per hour, efficiency improves greatly.In addition, when adopting former method to calculate, reckoner is necessary for pipe technology personnel, and is familiar with trigonometric function or AutoCAD, and after using this form, the calculating that general materials person can complete coordinate is entrusted, reduce the technical requirement to personnel, greatly reduce expense, reach the computation process both simplifying coordinate points complexity, ensure that again calculating is accurate and method is simple and convenient, the effect of increasing work efficiency.
Accompanying drawing explanation
Fig. 1 is design drawing pipeline inflection point position view;
Fig. 2 is the operational flowchart of coordinates computed of the present invention point;
Fig. 3 is type face list structure schematic diagram of the present invention;
Fig. 4 is coordinate points list structure schematic diagram of the present invention;
Fig. 5 is intermediate node list structure schematic diagram of the present invention;
Fig. 6 is sequential node list structure schematic diagram of the present invention;
Fig. 7 is triangulation calculation device list structure schematic diagram of the present invention;
Fig. 8 is reference point counter list structure schematic diagram of the present invention;
Fig. 9 is reference point list structure schematic diagram of the present invention;
Figure 10 is that Fig. 1 utilizes reference point counter table to calculate the schematic diagram of flex point.
Embodiment
The present invention mainly comprises the content of two aspects: 1, the defeated machine of the calculating of coordinate points is entrusted and measured; 2, the calculating of special coordinates point.Realized by the excel form of office office software.
Be described in detail as follows below in conjunction with the method for accompanying drawing to technical solution of the present invention.
As shown in Figure 2, a kind of computing method of pipeline inflection point coordinate, comprise the steps:
(1) initially prepare; Data form EXCEL is utilized to set up seven forms by unalterable rules respectively:
Print page table, will the flex point coordinate data needing printout have been calculated in order to preserve;
Coordinate points table, in order to preserve the flex point coordinate data after having calculated;
Intermediate node table, in order to calculate when known flex point coordinate is non-line end first flex point other flex point coordinate datas on drawing;
Sequential node table, in order to calculate when known flex point coordinate is line end first flex point other flex point coordinate datas on drawing;
Triangulation calculation device table, in order to calculate the particular point coordinate data that on tested point to the X-axis, Y-axis of known point, increment does not directly provide;
Reference point counter table, needs the flex point coordinate data calculated by reference point;
Reference point table; Carrying out the datum plate coordinate raw data of value according to nuclear power design drawing nuclear island datum plane plate arrangenent diagram, is the data source of this reference point counter table;
(2) drawing is taken;
(3) flex point sequence number is compiled; Waiting axle figure to what need to calculate flex point, is first to comprise pipeline end points and all flex points of intersecting point from one end successively by English capitalization A, B, C, D, E, F, G, H ... numbering, this numbering is followed principle as far as possible forward for the flex point of known coordinate numbering;
(4) if known point is pipeline end points; Enter described sequential node table; Progressive rapid (six);
(5) if known point is pipeline intermediate point; Enter described intermediate node table, input the sequence number of known flex point;
(6) judge; Known point directly gives the X of coordinate, Y value; Progressive rapid (eight);
(7) coordinate of known point is calculated; If give the distance of known point to two blocks of reference coordinate plates, reference point counter table is used to calculate the coordinate of known flex point; Otherwise use triangulation calculation device table to calculate the coordinate of known flex point;
(8) coordinate of known flex point is inputted; Be that the difference of pipeline end points or intermediate point is by the coordinate of known flex point input sequence node table or intermediate node table respectively according to known flex point;
(9) variable of all the other flex point coordinates is inputted; The variable of all the other flex point coordinates in drawing is inputted in the sequential node table limited in step (eight) or intermediate node table;
(10) each flex point coordinate is obtained; Sequential node table or intermediate node table can calculate the coordinate of each flex point automatically, are copied by the coordinate of each for gained flex point to waiting axle drawing corresponding position;
(11) copy; The each flex point coordinate data calculated in sequential node table or intermediate node table being copied pastes in coordinate points table;
(12) have preserved; Data of having preserved in coordinate points table by printing page table printout.
Introduce foundation rule and the process of establishing of seven forms below in detail:
As Fig. 3, print page table, this worksheet mainly provides a blank worksheet, is exported by the data-printing calculated to facilitate us; This table is that point three steps complete on common EXCEL blank form, and its establishment step is:
The first step, arranges type style, in front two row input headers, sees Fig. 3, sets and prints top header line and margin; This printing top title behavior second row, the field arranged from left to right is sequence number, drawing number, release, room number, coordinate sequence number, X, Y, Z.
Second step, arranges sequence number, arranges the 3rd row begin to input formula=IF (B*=" " respectively, " ", ROW ()-2 eventually to the 100th row at A), wherein * representative unit lattice place line number;
3rd step, setting model form, has been arranged to data then data band frame by form; First entirely select all cells of worksheet, open conditional formats, input formula=IF (A1<> " " in rule, TRUE, FALSE), formatting becomes band frame.
As Fig. 4, coordinate points table, this worksheet is the storage area of coordinate points data, be about to the data storing after having been calculated by " intermediate node table ", " sequential node table " so far, as certain region go into operation after need entrust measure time, can filter out the region needing to print in this table after, data can being exported to " printing page table " this coordinate points table by shortcut is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input header, and in front two row input headers, Fig. 4, sets top header line; This top title behavior second row, the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, △ X, Y, △ Y, Z, region and remarks;
Second step, arranges shortcut, and shortcut is defined as Ctrl+Shift+B, thereon defmacro; Open macro editor, arrange grand.This arranges grand step and is followed successively by: select C to arrange to M row, copy data, open printing page table, selection unit lattice B1, clicks right button, PASTE SPECIAL, paste numerical value, delete C row, D row, delete G row, delete H row, arranging A row col width is 5, and arranging B row col width is 20, arranging C row col width is 5, arranging D row col width is 10, and arranging E, to arrange to H row col width be 9, and preservation completes.
As Fig. 5, intermediate node table, form used when this table is the non-line end of flex point first flex point of known coordinate point, this intermediate node table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Counting fourth line downwards from header line, to be set to initial row M capable, and rose is arranged in cell region C6: M6, J3: J11, L3: M11; I3: I5, I7: I11, K3: K5, K7: K11 is arranged to yellow;
This title behavior second row, the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, △ X, Y, △ Y, Z, region and remarks, the A row respectively in 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;
Second step, input function;
First, formula=IF (J*=" " is inputted successively in the cell that C row are capable except numbering M, " ", C#), formula=IF (J*=" " is inputted successively in the cell that D row are capable except numbering M, " ", D#), formula=IF (J*=" " is inputted successively in the cell that E row are capable except numbering M, " ", E#), formula=IF (J*=" " is inputted successively in the cell that F row are capable except numbering M, " ", F#), formula=IF (J*=" " is inputted successively in the cell that G row are capable except numbering M, " ", G#), formula=IF (C*=" " is inputted successively in the cell of N row, " ", MID (C*, 6, 3)), in formula No. * be the line number at cell place and No. * be not less than 3, as cell above numbering M is capable then # be place line number+1, as cell in the capable below of numbering M then # be place line number-1,
Its two, in the capable upper unit lattice of H row M, input formula=IF (AND (H#=" D "), " C " successively, IF (AND (H#=" C "), " B ", IF (H#=" B ", " A ", " "))), in formula, No. # is the line number+1 at cell place; Formula is inputted successively in the capable lower unit lattice of H row M
＝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 ", " ")))), in formula, No. * is the line number at cell place, and No. # is cell place line number-1;
They are three years old, formula=IF (J*=" " is inputted successively except in the capable cell of numbering M at I row, " ", I#+J*), formula=IF (L*=" " is inputted successively, " " at K row except in the capable cell of numbering M, K#+L*), in formula, No. * is the line number at cell place, if cell is above numbering M is capable, No. # is cell place line number+1, if cell is in the capable below of numbering M, No. # is cell place line number-1;
3rd step, arranges shortcut Ctrl+Shift+Z, thereon defmacro; Open macro editor, arrange grand; This arranges grand step and is followed successively by: selection unit lattice J3: J11, clear data, and selection unit lattice L3: M11, clear data, and selection unit lattice H3: K6, clear data, and preservation completes, and exit.
4th step, protection worksheet;
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, cancel locking, hide before selection marker, determine;
Select all cells except being coated with the cell of rose-red color in worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open protection worksheet check box; setting code under the password used when cancelling worksheet protection; carry out lower selection locked cell selected lattice, selected non-locking cell allowing all users of this worksheet, column format is set, row format is set determines, again input password, determine.
In practical operation:
1. this form is applicable to the situation that known point is intermediate point, is first inputted by drawing information in corresponding rose frame, then determines that known point numbering inserts respective block;
2, Δ X is the variable in point-to-point transmission X-axis, and Δ Y is the variable in point-to-point transmission Y-axis, notices that differentiation is positive and negative;
3, after input, copy and paste in ' coordinate points ' worksheet;
4, respective value can only be inputted in rose frame during operation, after input, in yellow frame, be shown as the value of tested point.
5, emptying shortcut is Ctrl+Shift+Z.
As Fig. 6, sequential node table, this table is the flex point of known coordinate point form used when being line end first flex point, this sequential node table is set up by EXCEL blank form, and point four steps complete, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Rose is arranged in cell region C3: M3, J4: J10, L4: M10, yellow is arranged in cell region I4: I10, K4: K10, at H3 cell input capitalization A;
This sequential node table title behavior second row, the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate is in proper order number, X, △ X, Y, △ Y, Z, region and remarks, the A row respectively in 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;
Second step, input function,
First, under this header line, several second row rises,
Time input formula=IF (J=" " of C leu, " ", C#),
Time input formula=IF (J=" " of D leu, " ", D#),
Time input formula=IF (J=" " of E leu, " ", E#),
Time input formula=IF (J=" " of F leu, " ", F#),
Time input formula=IF (J=" " of G leu, " ", G#),
Time input formula=IF (J=" " of I leu, " ", I#+J),
Time input formula=IF (J=" " of K leu, " ", K#+L);
Formula medium size is the line number at cell place, and No. # is place line number-1;
Its two, under this header line, several second row rises,
H leu time input formula=IF (J=" ", " ", " § "), formula medium size is the line number at cell place, No. § increase according to line number, be followed successively by capital B, C, D, E, F, G,
Its three, under this header line number the first row rise, in N column unit lattice, input formula=MID (C, 6,3) successively, formula medium size is the line number at cell place;
3rd step, arranges shortcut Ctrl+Shift+A, arranges grand thereon; Open macro editor, arrange grand; This arranges grand step and is followed successively by: selection unit lattice I3: M3, clear data, and selection unit lattice J4: J11, clear data, and selection unit lattice L4: M11, clear data, and preservation completes, and exit.
4th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area, click new buttons, under the check box precedents table entry ejected, choose rose unit lattice, click and determine, protection worksheet button is had in the lower left of the check box allowing user's editing area, click it, eject protection Sheet Options card, setting code under the password (P) used when cancelling worksheet protection, locked cell selected lattice are selected under allowing all users of this worksheet to carry out (O), selected non-locking cell, column format is set, determine after row format is set, again input password, determine.
In practical operation:
1, Ben Biaoge is applicable to the situation that known point is starting point;
2, inputted by drawing information in corresponding rose frame, Δ X is the variable in point-to-point transmission X-axis, and Δ Y is the variable in point-to-point transmission Y-axis, notices that differentiation is positive and negative;
3, after input, copy and paste in ' coordinate points ' worksheet;
4, respective value can only be inputted in rose frame during operation, after input, in yellow frame, be shown as the value of tested point.
5, emptying shortcut is Ctrl+Shift+A.
As Fig. 7, triangulation calculation device table, this table mainly calculates the situation that on tested point to the X-axis, Y-axis of known point, increment does not directly provide, belong to the category that particular point coordinate calculates, it can be divided into two kinds of situations, known point is called equilateral triangle (asking intermediate point) when triangle angular vertex, known point is in triangle edges anti-triangle (asking end points); This triangulation calculation device table is set up by EXCEL blank form, and point four steps complete, and its establishment step is:
The first step, arranges input Back ground Information, respectively by asking intermediate point and asking end points to set up header line and related description and sign; Rose is arranged in cell region B4: D4, B5: C5, B9: D9, B10: C10, cell district F4: F5, F9: F10 is arranged to yellow;
This asks intermediate point to be that known point is called equilateral triangle when triangle angular vertex and asks intermediate point; This asks end points to be that known point makes anti-triangle ask end points in triangle edges;
Corresponding the second identical row of this title behavior field name and the 7th row, the field arranged from left to right from secondary series is known point A, and △ is known, and L, △ survey and tested point, the B row respectively in corresponding form, C row, D row, E row and F row;
Second step, input function,
Formula=SQRT ((C#*C#)+(C*C)) is inputted respectively in D5, D10 cell,
Formula=IF (D4=" " is inputted respectively, " ", C*D4/D5 in E4, E5 cell),
Formula=IF (D9=" " is inputted respectively, " " ,-C*D9/D10 in E9, E10 cell),
Formula=IF (D4=" " is inputted respectively, " ", B+E in F4, F5 cell),
Formula=IF (D9=" " is inputted respectively, " ", B+E in F9, F10 cell),
In formula, No. # is cell place line number-1, number is cell place line number;
3rd step, arranges shortcut Ctrl+Shift+Q grand; It is grand that shortcut Ctrl+Shift+S is set;
This step arranging shortcut Ctrl+Shift+Q grand is followed successively by: selection unit lattice B4: C5, clear data, selection unit lattice D4, and clear data, preservation completes;
This step arranging shortcut Ctrl+Shift+S grand is followed successively by: selection unit lattice B9: C10, clear data, and selection unit lattice D9, clear data, preservation completes.
4th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area; click new buttons; under the check box precedents table entry ejected; choose RED sector cell; click and determine; protection worksheet button is had in the lower left of the check box allowing user's editing area; click it; eject protection Sheet Options card; setting code under the password used when cancelling worksheet protection, allowing all users of this worksheet to carry out lower selection locked cell selected lattice, selected non-locking cell, arrange column format, arrange row format, determines; again input password, determine.
In practical operation:
1, known point coordinate is inserted in rose frame corresponding to known point, Δ
knownfor scheming upper known variables, distinguish positive and negative;
2, figure, L value as right in Fig. 7 is for known point is to the distance of tested point; Δ is surveyed as known point is to the variable of tested point;
3, respective value can only be inputted in rose frame during operation, after input, in yellow frame, be shown as the value of tested point.
4, asking intermediate computations device point to empty shortcut is Ctrl+Shift+Q, and asking end points counter to empty shortcut is Ctrl+Shift+S.
As Fig. 8, reference point counter table, this table be need by reference point just may the situation of coordinates computed point time used.This table is that point four steps complete on common excel blank form, and this reference point counter table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Rose is arranged in cell region B4: E4, yellow is arranged in cell region F5: F6, and by corresponding table cell col width, high setting of going;
This title behavior second row, the field arranged from left to right from secondary series is reference point A, reference point B, L, H and tested point D, the B row respectively in corresponding form, C row, D row, E row and F row;
Second step, input function,
At B5 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, a reference point! A:C, 2,0)),
At B6 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, a reference point! A:C, 3,0)),
At C5 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, a reference point! A:C, 2,0)),
At C6 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, a 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 G6 cell input formula=(B6-C6)/(B5-C5) * G5+B6-(B6-C6) * B5/ (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);
3rd step, arranges shortcut Ctrl+Shift+D, opens macro editor, arranges grand; This step arranging shortcut Ctrl+Shift+D grand is followed successively by: selection unit lattice B4: E4, clear data, and selection unit lattice B4, preservation completes.
4th step, hides form, selected G row, H row, I row, J row, and a mouse click right button, selects to hide, then complete this step;
5th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area; click new buttons; under the check box precedents table entry ejected; choose RED sector cell; click and determine; protection worksheet button is had in the lower left of the check box allowing user's editing area; click it; eject protection Sheet Options card; setting code under the password used when cancelling worksheet protection; carry out lower selection locked cell selected lattice, selected non-locking cell allowing all users of this worksheet, column format is set, row format is set determines, again input password, determine.
In practical operation:
1, insert in corresponding rose frame by reference point numbering, note distinguishing A, B point, the reference point of band dimensioning is A point, and another point is B point;
2, right figure, the L value as Fig. 8 is the known distance on the straight line determined by reference point, when C point relative to A point in X-axis positive dirction time, L value is just, otherwise is negative; Vertical range on the H value straight line that to be tested point determine to reference point, when D point relative to C point in X-axis positive dirction time, H value is just, otherwise is negative;
3, respective value can only be inputted in rose frame during operation, after input, in yellow frame, be shown as the value of tested point.
4, emptying shortcut is Ctrl+Shift+D.
As Fig. 9, reference point table, this table is the data source of " reference point counter table "; In this table, data carry out value according to nuclear power design drawing " nuclear island datum plane plate arrangenent diagram ", directly by this design document data input this by form shown in upper figure and show; This reference point table is set up by EXCEL blank form, and its establishment step is:
Input Back ground Information is set, input header row and related description and sign; This title behavior the first row, the field arranged from left to right is reference point numbering, X and Y, the A row respectively in corresponding form, B row and C row.
Equally, for the example that Fig. 1 mentions, calculate D point coordinate, use form, only data existing in figure directly need be inserted corresponding form, can results needed be obtained, as Figure 10:
1, insert in corresponding rose frame by reference point numbering, note distinguishing A, B point, the reference point of band dimensioning is A point, and another point is B point;
2, right figure, the L value as Figure 10 is the known distance on the straight line determined by reference point, when C point relative to A point in X-axis positive dirction time, L value is just, otherwise is negative; Vertical range on the H value straight line that to be tested point determine to reference point, when D point relative to C point in X-axis positive dirction time, H value is just, otherwise is negative;
3, respective value can only be inputted in rose frame during operation, after input, in yellow frame, be shown as the value of tested point.
4, emptying shortcut is Ctrl+Shift+D.
This form successful Application, in the nuclear island installation work of Liao Ling Australia second phase, and obtains good result.
In sum, after taking the axle such as portion figure, first be that all flex points (comprising pipeline end points and intersecting point) are numbered with A, B, C, D, E, F, G, H successively from one end ..., the principle will followed during numbering is exactly by as far as possible forward for the flex point of known coordinate numbering.Every part is waited the known point of axle figure nothing more than two classes, and one is at pipeline end points, and one is a certain flex point in the middle of pipeline, and two class situations are corresponding order node and intermediate node respectively, selects different worksheets according to drawing situation.
For known point coordinate again in two kinds of situation, one is the X directly giving coordinate, Y value, and this kind of situation directly calculates with corresponding order node or intermediate node; Two is give the distance of known point to two blocks of reference coordinate plates, and this kind of situation needs to use reference point counter, first calculates the coordinate of known point, then calculates with corresponding order node or intermediate node computation sheet.
Input known point coordinate and sequence number in corresponding form after, for asking each point coordinate, plus-minus need be carried out by the variable of X given in drawing, Y-coordinate to determine, in design drawing, given X, Y variable of great majority can be directly used in calculating, but still has part, the variable provided not is the variable to unknown point, needing to obtain this variable by calculating, at this moment can calculate with triangulation calculation device, obtaining the calculating of variable for corresponding form.
After this all flex point of drawing calculates, the coordinate of all flex points is copied to waiting on axle drawing, use in order to site operation, and by calculated data (order node or intermediate node computation sheet in result of calculation), copy and paste in coordinate points worksheet, preserve in a computer with excel data layout, measure in order to follow-up trust and use.
Claims (8)
1. computing method for pipeline inflection point coordinate, is characterized in that comprising the steps:
(1) initially prepare; Data form EXCEL is utilized to set up seven forms by unalterable rules respectively:
Print page table, will the flex point coordinate data needing printout have been calculated in order to preserve;
Coordinate points table, in order to preserve the flex point coordinate data after having calculated;
Intermediate node table, in order to calculate when known flex point coordinate is non-line end first flex point other flex point coordinate datas on drawing;
Sequential node table, in order to calculate when known flex point coordinate is line end first flex point other flex point coordinate datas on drawing;
Triangulation calculation device table, in order to calculate the particular point coordinate data that on tested point to the X-axis, Y-axis of known point, increment does not directly provide;
Reference point counter table, needs the flex point coordinate data calculated by reference point;
Reference point table; Carrying out the datum plate coordinate raw data of value according to nuclear power design drawing nuclear island datum plane plate arrangenent diagram, is the data source of this reference point counter table;
(2) drawing is taken;
(3) flex point sequence number is compiled; Waiting axle figure to what need to calculate flex point, is first to comprise pipeline end points and all flex points of intersecting point from one end successively by English capitalization A, B, C, D, E, F, G, H ... numbering, this numbering is followed principle as far as possible forward for the flex point of known coordinate numbering;
(4) if known point is pipeline end points; Enter described sequential node table; Progressive rapid (six);
(5) if known point is pipeline intermediate point; Enter described intermediate node table, input the sequence number of known flex point;
(6) judge; Known point directly gives the X of coordinate, Y value; Progressive rapid (eight);
(7) coordinate of known point is calculated; If give the distance of known point to two blocks of reference coordinate plates, reference point counter table is used to calculate the coordinate of known flex point; Otherwise use triangulation calculation device table to calculate the coordinate of known flex point;
(8) coordinate of known flex point is inputted; Be that the difference of pipeline end points or intermediate point is by the coordinate of known flex point input sequence node table or intermediate node table respectively according to known flex point;
(9) variable of all the other flex point coordinates is inputted; The variable of all the other flex point coordinates in drawing is inputted in the sequential node table limited in step (eight) or intermediate node table;
(10) each flex point coordinate is obtained; Sequential node table or intermediate node table can calculate the coordinate of each flex point automatically, are copied by the coordinate of each for gained flex point to waiting axle drawing corresponding position;
(11) copy; The each flex point coordinate data calculated in sequential node table or intermediate node table being copied pastes in coordinate points table;
(12) have preserved; Data of having preserved in coordinate points table by printing page table printout;
This printing page table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges type style, in front two row input headers, sets and prints top header line and margin;
Second step, arranges sequence number, arranges the 3rd row begin to input formula=IF (B*=" " respectively, " ", ROW ()-2 eventually to the 100th row at A), wherein * representative unit lattice place line number;
3rd step, setting model form, has been arranged to data then data band frame by form; First entirely select all cells of worksheet, open conditional formats, input formula=IF (A1<> " " in rule, TRUE, FALSE), formatting becomes band frame;
This coordinate points table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input header, in front two row input headers, sets top header line;
Second step, arranges shortcut, and shortcut is defined as Ctrl+Shift+B; Open macro editor, arrange grand;
This intermediate node table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Count fourth line downwards from header line and be set to initial row, rose is arranged in cell region C6: M6, J3: J11, L3: M11; I3: I5, I7: I11, K3: K5, K7: K11 is arranged to yellow;
Second step, input function;
First, formula=IF (J*=" " is inputted successively except in the cell of this initial row at C row, " ", C#), formula=IF (J*=" " is inputted successively except in the cell of this initial row at D row, " ", D#), formula=IF (J*=" " is inputted successively except in the cell of this initial row at E row, " ", E#), formula=IF (J*=" " is inputted successively except in the cell of this initial row at F row, " ", F#), formula=IF (J*=" " is inputted successively except in the cell of this initial row at G row, " ", G#), formula=IF (C*=" " is inputted successively in the cell of N row, " ", MID (C*, 6, 3)), in formula No. * be the line number at cell place and No. * be not less than 3, as cell above this initial row then # be place line number+1, as cell in the below of this initial row then # be place line number-1,
They are two years old, arrange in these initial row upper unit lattice at H and input formula=IF (AND (H#=" D ") successively, " C ", IF (AND (H#=" C "), " B ", IF (H#=" B ", " A ", " "))), in formula, No. # is the line number+1 at cell place; Arrange in these initial row lower unit lattice at H and input formula successively
＝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 ", " ")))), in formula, No. * is the line number at cell place, and No. # is cell place line number-1;
They are three years old, formula=IF (J*=" " is inputted successively except in this initial row cell at I row, " ", I#+J*), formula=IF (L*=" " is inputted successively, " " at K row except in this initial row cell, K#+L*), in formula, No. * is the line number at cell place, if cell is above this initial row, No. # is cell place line number+1, if cell is in the below of this initial row, No. # is cell place line number-1;
3rd step, arranges shortcut Ctrl+Shift+Z, opens macro editor, arranges grand;
4th step, protection worksheet;
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, cancel locking, hide before selection marker, determine;
Select all cells except being coated with the cell of rose-red color in worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open protection worksheet check box, setting code under the password used when cancelling worksheet protection, carry out lower selection locked cell selected lattice, selected non-locking cell allowing all users of this worksheet, column format is set, row format is set determines, again input password, determine;
This sequential node table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Rose is arranged in cell region C3: M3, J4: J10, L4: M10, yellow is arranged in cell region I4: I10, K4: K10, at H3 cell input capitalization A;
Second step, input function,
First, under this header line, several second row rises,
Time input formula=IF (J=" " of C leu, " ", C#),
Time input formula=IF (J=" " of D leu, " ", D#),
Time input formula=IF (J=" " of E leu, " ", E#),
Time input formula=IF (J=" " of F leu, " ", F#),
Time input formula=IF (J=" " of G leu, " ", G#),
Time input formula=IF (J=" " of I leu, " ", I#+J),
Time input formula=IF (J=" " of K leu, " ", K#+L);
Formula medium size is the line number at cell place, and No. # is place line number-1;
Its two, under this header line, several second row rises,
H leu time input formula=IF (J=" ", " ", " § "), formula medium size is the line number at cell place, No. § increase according to line number, be followed successively by capital B, C, D, E, F, G,
Its three, under this header line number the first row rise, in N column unit lattice, input formula=MID (C, 6,3) successively, formula medium size is the line number at cell place;
3rd step, arranges shortcut Ctrl+Shift+A, opens macro editor, arranges grand;
4th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area, click new buttons, under the check box precedents table entry ejected, choose rose unit lattice, click and determine, protection worksheet button is had in the lower left of the check box allowing user's editing area, click it, eject protection Sheet Options card, setting code under the password (P) used when cancelling worksheet protection, locked cell selected lattice are selected under allowing all users of this worksheet to carry out (O), selected non-locking cell, column format is set, determine after row format is set, again input password, determine,
This triangulation calculation device table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, respectively by asking intermediate point and asking end points to set up header line and related description and sign; Rose is arranged in cell region B4: D4, B5: C5, B9: D9, B10: C10, cell district F4: F5, F9: F10 is arranged to yellow;
Second step, input function,
Formula=SQRT ((C#*C#)+(C*C)) is inputted respectively in D5, D10 cell,
Formula=IF (D4=" " is inputted respectively, " ", C*D4/D5 in E4, E5 cell),
Formula=IF (D9=" " is inputted respectively, " " ,-C*D9/D10 in E9, E10 cell),
Formula=IF (D4=" " is inputted respectively, " ", B+E in F4, F5 cell),
Formula=IF (D9=" " is inputted respectively, " ", B+E in F9, F10 cell),
In formula, No. # is cell place line number-1, number is cell place line number;
3rd step, arranges shortcut Ctrl+Shift+Q grand; It is grand that shortcut Ctrl+Shift+S is set;
4th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area, click new buttons, under the check box precedents table entry ejected, choose RED sector cell, click and determine, protection worksheet button is had in the lower left of the check box allowing user's editing area, click it, eject protection Sheet Options card, setting code under the password used when cancelling worksheet protection, allowing all users of this worksheet to carry out lower selection locked cell selected lattice, selected non-locking cell, arrange column format, arrange row format, determines, again input password, determine;
This reference point counter table is set up by EXCEL blank form, and its establishment step is:
The first step, arranges input Back ground Information, input header row and related description and sign; Rose is arranged in cell region B4: E4, yellow is arranged in cell region F5: F6, and by corresponding table cell col width, high setting of going;
Second step, input function,
At B5 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, a reference point! A:C, 2,0)),
At B6 cell input formula=IF (B4=" ", " ", VLOOKUP (B4, a reference point! A:C, 3,0)),
At C5 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, a reference point! A:C, 2,0)),
At C6 cell input formula=IF (C4=" ", " ", VLOOKUP (C4, a 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 G6 cell input formula=(B6-C6)/(B5-C5) * G5+B6-(B6-C6) * B5/ (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);
3rd step, arranges shortcut Ctrl+Shift+D, opens macro editor, arranges grand;
4th step, hides form, selected G row, H row, I row, J row, and a mouse click right button, selects to hide, then complete this step;
5th step, protection worksheet,
Entirely select worksheet, open setting unit sound of laughing formula check box by right mouse button, select protection label, selected locking, hide before selection marker, determine;
Open and allow user's editing area; click new buttons; under the check box precedents table entry ejected; choose RED sector cell; click and determine; protection worksheet button is had in the lower left of the check box allowing user's editing area; click it; eject protection Sheet Options card; setting code under the password used when cancelling worksheet protection; carry out lower selection locked cell selected lattice, selected non-locking cell allowing all users of this worksheet, column format is set, row format is set determines, again input password, determine.
2. the computing method of pipeline inflection point coordinate as claimed in claim 1, it is characterized in that this printing page table sets up this printing top title behavior second row of the first step, the field arranged from left to right is sequence number, drawing number, release, room number, coordinate sequence number, X, Y, Z.
3. the computing method of pipeline inflection point coordinate as claimed in claim 1, is characterized in that this top title behavior second row of the first step set up by this coordinate points table, and the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, △ X, Y, △ Y, Z, region and remarks;
This arranges grand step and is followed successively by: select C to arrange to M row, copy data, open printing page table, selection unit lattice B1, clicks right button, PASTE SPECIAL, paste numerical value, delete C row, D row, delete G row, delete H row, arranging A row col width is 5, and arranging B row col width is 20, arranging C row col width is 5, arranging D row col width is 10, and arranging E, to arrange to H row col width be 9, and preservation completes.
4. the computing method of pipeline inflection point coordinate as claimed in claim 1, is characterized in that this title behavior second row of the first step set up by this intermediate node table, and the field arranged from left to right is numbering, sequence number, drawing number, system, state, release, room number, coordinate sequence number, X, △ X, Y, △ Y, Z, region and remarks, the A row respectively in 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;
This arranges grand step and is followed successively by: selection unit lattice J3: J11, clear data, and selection unit lattice L3: M11, clear data, and selection unit lattice H3: K6, clear data, and preservation completes, and exit.
5. the computing method of pipeline inflection point coordinate as claimed in claim 1, is characterized in that this title behavior second row of the first step set up by this sequential node table, and the field arranged 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, region and remarks, the A row respectively in 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;
This arranges grand step and is followed successively by: selection unit lattice I3: M3, clear data, and selection unit lattice J4: J11, clear data, and selection unit lattice L4: M11, clear data, and preservation completes, and exit.
6. the computing method of pipeline inflection point coordinate as claimed in claim 1, is characterized in that this triangulation calculation device table to be set up in the first step this and asked intermediate point to be that known point is called equilateral triangle when triangle angular vertex and asks intermediate point; This asks end points to be that known point makes anti-triangle ask end points in triangle edges;
Corresponding the second identical row of this title behavior field name and the 7th row, the field arranged from left to right from secondary series is known point A, and △ is known, and L, △ survey and tested point, the B row respectively in corresponding form, C row, D row, E row and F row;
This step arranging shortcut Ctrl+Shift+Q grand is followed successively by: selection unit lattice B4: C5, clear data, selection unit lattice D4, and clear data, preservation completes;
This step arranging shortcut Ctrl+Shift+S grand is followed successively by: selection unit lattice B9: C10, clear data, and selection unit lattice D9, clear data, preservation completes.
7. the computing method of pipeline inflection point coordinate as claimed in claim 1, it is characterized in that this title behavior second row of the first step set up by this reference point counter table, the field arranged from left to right from secondary series is reference point A, reference point B, L, H and tested point D, the B row respectively in corresponding form, C row, D row, E row and F row;
This step arranging shortcut Ctrl+Shift+D grand is followed successively by: selection unit lattice B4: E4, clear data, and selection unit lattice B4, preservation completes.
8. the computing method of pipeline inflection point coordinate as claimed in claim 1, it is characterized in that this reference point table is set up by EXCEL blank form, its establishment step is:
Input Back ground Information is set, input header row and related description and sign; This title behavior the first row, the field arranged from left to right is reference point numbering, X and Y, the A row respectively in corresponding form, B row and C row.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210002479.3A CN102609447B (en) | 2012-01-06 | 2012-01-06 | The computing method of pipeline inflection point coordinate |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210002479.3A CN102609447B (en) | 2012-01-06 | 2012-01-06 | The computing method of pipeline inflection point coordinate |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102609447A CN102609447A (en) | 2012-07-25 |
| CN102609447B true CN102609447B (en) | 2015-11-25 |
Family
ID=46526819
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210002479.3A Active CN102609447B (en) | 2012-01-06 | 2012-01-06 | The computing method of pipeline inflection point coordinate |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102609447B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103632020A (en) * | 2012-08-22 | 2014-03-12 | 昆达电脑科技(昆山)有限公司 | Excel budgeting system |
| CN113051210A (en) * | 2019-12-27 | 2021-06-29 | 张家界航空工业职业技术学院 | Special calculator for financial accounting |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101714181A (en) * | 2009-12-04 | 2010-05-26 | 煤炭科学研究总院西安研究院 | Method for designing and drawing directional drilling trace under coal mine |
| CN101719176A (en) * | 2009-12-04 | 2010-06-02 | 煤炭科学研究总院西安研究院 | Method for processing drilling trajectory parameters and drawing graphs by utilizing Excel |
| CN101825452A (en) * | 2010-04-20 | 2010-09-08 | 中国第一冶金建设有限责任公司 | Method for performing inter-conversion between survey coordinates and construction coordinates |
-
2012
- 2012-01-06 CN CN201210002479.3A patent/CN102609447B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101714181A (en) * | 2009-12-04 | 2010-05-26 | 煤炭科学研究总院西安研究院 | Method for designing and drawing directional drilling trace under coal mine |
| CN101719176A (en) * | 2009-12-04 | 2010-06-02 | 煤炭科学研究总院西安研究院 | Method for processing drilling trajectory parameters and drawing graphs by utilizing Excel |
| CN101825452A (en) * | 2010-04-20 | 2010-09-08 | 中国第一冶金建设有限责任公司 | Method for performing inter-conversion between survey coordinates and construction coordinates |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102609447A (en) | 2012-07-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Xue et al. | BIM integrated LCA for promoting circular economy towards sustainable construction: an analytical review | |
| CN109063235A (en) | A kind of coupling of multiple physics system and method for reactor simulation | |
| CN108830554B (en) | Task model-based intelligent detection method and system for data result information quality | |
| CN101493834A (en) | Method for generating evidence for keeping account by random service system document | |
| CN102609447B (en) | The computing method of pipeline inflection point coordinate | |
| CN105808808A (en) | Engineering quantity template calculation method | |
| CN109446372A (en) | The schema differences control methods in Process in Cooperative Design based on BIM model | |
| CN111507609A (en) | Material list generation method and device and electronic equipment | |
| CN111985034A (en) | Method and system for constructing school civil engineering Building Information Model (BIM) | |
| CN109992865A (en) | A method of handling absolute altitude in AutoCAD engineering drawing | |
| CN108170855A (en) | A kind of CityGML and IFC data unified query and data pick-up method | |
| CN108230446A (en) | A kind of high-precision three-dimensional curved surface modeling method | |
| CN100576220C (en) | The construction method of computer emulation coke oven masonry | |
| CN101515310B (en) | Random verifying method and system of microprocessor floating point unit | |
| CN115455738A (en) | Optimization problem solving method based on visual modeling | |
| JP2656923B2 (en) | Spreadsheet processor | |
| Bowman et al. | SCALE 5: Powerful new criticality safety analysis tools | |
| CN116302488B (en) | Multi-process automatic identification conversion method for topographic map data coordinates | |
| JP2007145009A (en) | Inspection chart used in construction work | |
| CN112184134A (en) | Network plan rationality evaluation dimension design method, evaluation method, system and device | |
| WO2022135347A1 (en) | Data center 3d modeling method and apparatus, electronic device, and storage medium | |
| CN107818161A (en) | A kind of data capture method and device | |
| WO2023008645A1 (en) | Method for automatically calculating bm of plant equipment and machinery | |
| KR100886657B1 (en) | System and Method for making Basic Document of Dimensional Accuracy Check Sheet for Block in Ship Production | |
| Isard et al. | Matching Conflict Situations and Conflict Management Procedures |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |