Home

ProActive Training Manual (Single User Version)

1. How to Restore a Backed up Database Howto Create a Database cna 1 5 1 Contractor Bx ample eet or aon a RE ERR RM EEEERU 1 5 2 Pipeline Operator Owner Example Introduction 0 0 00 0 0 Page SECTION 4 HOW TO VIEW SURVEY DATA GRAPHICALLY VIA THE GATEWAY FOLDERS IN YOUR DATABASE TREE rodde 66 4 2 Viewing Survey Data via Line Segment Folders 68 4 3 Viewing Survey Data via Parent Folders 71 4 4 How to have Facility Icons Overlaid on Graphs 74 SECTION 5 HOW TO VIEW AND EDIT YOUR DATA USING THE PIPELINE SURVEY EDITOR 5 1 How to View Survey Data Graphically amp Textually via the PrpeHne Survey Eqn ehe qa 78 5 1 1 How to View Photographs Downloaded from the Cr D3ta IOS Cer TE adu MEE E cada rA 82 5 2 Survey Data Menu Options including CIS Exceptions Report generation amp relative re stationing using GPS data 95 5 3 How to Edit Survey Data via the Graph Mode the Pipetitie survey EGItOE uos ie bore 98 SECTION 6 HOW GENERATE GRAPHICAL REPORTS USING THE GRAPHICAL REPORTS DESIGNER CONSIGELANIONS apte o ER CEPI RC Uu ads wel 106 6 2 H
2. lt lt Back i 280 box labeled value displayed is the result of a formula is checked in the case since the Rectifier Amps reading 15 taken as a voltage reading across a shunt which means that the mV reading needs to be converted to an Amps value Clicking on the Next button pulls up the window shown below for this example Reading Configuration Wizard Configuration Settings for Target Meter Les Heading Style Single Value Meter Setting 400 mVDC 1 MOhm Meter Channel Options Help lt lt Back gt gt As indicated on the above window the Gx data logger was identified as the target meter and the voltmeter Range value Meter Setting value was selected as 400mV DC The range value change from the original 40mV value represents a modification to the reading template Clicking on the Next button pulls up the window shown below for this example 281 1 5 Configuration Settings for Survey Tupes v Annual Bi monthly Special lt lt Back Please see Section 5 2 above for a discussion on the relationship between Survey Types and a Reading Type Clicking on the Next button will pull up the window shown below for this example Reading Configuration Wizard Mil m Configuration Settings for Amps Adjustments to raw voltage for shunts and electrodes Before displaying
3. Fipe to sail Anode to sail Anode current Soil Resistance Complance DOT Rule UNASSIGNED Next Reading Due 4 4 How to Select Data Types for Visual Atmospheric Observations Some devices in ProActive have an Atmospherics page as well as a Readings page associated with their Details Forms Such devices can support both readings data and data associated with visual atmospheric observations Examples of such devices include a Valve a Span and a Flange Also some devices have an Atmospherics page only and do not have Readings page An Exposed Pipe device is an example of such a device What devices having an Atmospherics page associated with them have in common is that they all have an above ground aspect to them This above 252 ground aspect permits visual inspection of the corrosion condition status of the test site Consequently data can be recorded at such test sites relating to visual observations which are known as Atmospherics You can require such data to be recorded at a test site by selecting Atmospheric Types just like you selected Reading Types for devices with Readings pages Example A Valve is an example of a device type that has an Atmospherics page on its Details Form Here s how you would go about selecting Data Types for this example The window shown below was observed by double clicking on the Valve B2 node associate
4. Single Value Line X Cancel Right click on DCVG Data group and select Entity Next click on the menu button in the Survey Types field select DCVG and click on the hand icon to insert the entity Next left click on the newly created DCVG entity which will pull up the Report Entity Details field 122 l ry 3 Graphical Report Designer m Report Mame Bobs Report Format New Remove Report Details El E CIS Data Survey Data Report Entity Detail DCVG Survey Type Data Style You select a color for the DCVG data by checking off the Use Color box and choosing a color You can also select to display the DCVG data as a line graph or as a bar graph bar graph selected in this example by clicking on the menu button in the Style field and selecting Line or Bar The Data field can be left blank as there 1s only one value for this Data type 123 Graphical Report Designer Report Mame Bobs Report Format Fi New ti Remove Report Details El E CIS Data Survey Data Report Entity Detail DCVG Survey Type Data Style Note Right Axis has been selected for the DCVG survey data voltage scale see the above Report Entity Detail field whereas Left Axis was selected for the CIS data voltage scale This will help to disting
5. Coupon Size mp Current H DCVG Gradient Fl DEVG DEVG On Off On DCVG Max On Dit Of v DCVG Max On Off Remark Technician DEG On Off Technician a DEVG Percent IR m Y Drop ta Remate amp Dissolved CO2 H Data ltem Constrain Reading Columns Descending Show SOL query text 7 Click on the Save Template button highlighted on the window shown below 178 sere ae Coupon Size mp Current DCVG Gradient Fl DEVG DEVG On Off On DCVG Max On Dff DCVG Max On Off Remark Technician DEG On Off Technician a DEVG Percent IR m DCVG Y Drop ta Remate amp Dissolved CO2 Data ltem Constrain Reading Columns Descending Show SOL query text 8 Enter descriptive name for the report format as illustrated below 179 Hi F7 D ssalued H2GIPPHI Save Adhoc Criteria Sawe Report Format Enter Descnption Bobs Anomaly Report Format Save Cancel Show SOL query text 9 Click on the Save button on the above window after entering a descriptive name 10 Finally exit the Ad Hoc window click on the X button top right 7 4 How to Generate a Report using a Saved Report Format 1 Click on the Reports speed button
6. Reconnect 1 5pan Reconnect 1 Reconnect 1 Clone Reconnect MCM_1 Tower HERES MLM_1 G T vanic Anode r Single Test Statian_1 MCh 1 Intemal Corosia MLM 1 Exposed Fipe 1 Sbove Ground After dragging and dropping the highlighted facilities as described above the Route Manager window 15 as shown below 312 Haute Babs Route ni E 54 T setup Assign History Surveys Notes Graph Audit Trail Descriptors Devices BB MCM_1 Valve BE MCM_1 Rectifier FE Include Sub route MCM_1 Test Point 475 Exclude Item 1 Flange Single Test Station MCM_1 Test Point_230 22 MCM_1 Sleeve IE MCM_1 Landmark Reconnect lk MCM_1 Span Reconnect_1 ES Reconnect 1 Clone Reconnect LE MCM_1 Tower 1 Water Sampling ine Crossing Each of the above facilities has associated GPS location data For example the GPS lat long data for the rectifier named MCM 1 Rectifier second facility from the top can be viewed via the Details form shown below 313 Borse are TR e Location Fiectifier Readings Anodes Graph Time Chart Mates Audit Trail Mame MCM_1 Rectifier Milepost 19388 Pipeline MEM Ppeine 8 State series Wee Harvie Station 207487 Description Franks Site Dev Specific processed 02 DOT Class is Soil Type 2 Franks Coun
7. W Outline uA Facility Readings Visible iw Visible General Headings Cancel As can be seen by clicking on the menu button in the Overlay field there are a number of different overlay types whose properties with respect to how text is displayed can be modified to suit your style of presentation The various Overlay Types can be grouped into the following categories Simple Types Created during the process of posting pipeline survey data from data loggers These types simply overlay a text label on a graph Feature Geo Feature Flag Known Station Feature Skip Geo Feature Skip The Snap overlay type is also part of this category however Snap overlays are only generated should the Snap editing process be applied after posting survey data to the ProActive database see Section 5 2 Snap text 158 is overlaid to identify where snap data points were found and used useful for review of the snap process Complex Types Created during the process of posting pipeline survey data from data loggers In addition to overlaying a text label these types also overlay a Facility name and Facility icon as well as the readings data associated with the survey data presented on the graph Anomaly Data Collection Point Reconnect Extended Types Created during the process of posting pipeline survey data from data loggers if wave prints were recorded durin
8. WD Huis be i A x 2auuo3 4 av c13auuo38 aBDue J4 1 lt 2 ju0 sge Quod gal WC uoneis 891 Eg d pasodx3 L Wow 42 A CG 44E utodisal L WOW P C6 04 1 041581 WON a uomgaafu 10ygluul L 1015 PI dl CE B8E 4 gt WAN we em 1 04581 WOW 1a eAA mu m unu A s m A 13 6 3 Map Overlays The types of overlays as well as their appearance can be selected by the user via the Mapping tab window Pipeline The pipeline will be shown on the map if the box labeled pipeline 15 checked Thickness The relative thickness of an overlaid pipeline can be selected via the box labeled thickness 5 is the default value values larger than 5 will result in a thicker line and values small than 5 will result 1n a thinner line Color The color for the overlaid pipeline can be selected by clicking on the Color menu button and highlighting the color of choice Note If more than one database tree folder 15 highlighted and a different pipeline has been associated with each folder selecting the X option automatic color option from the color menu the top option in the menu will result in different colors being selected automatically by ProActive to represent each of the pipelines overlaid on the map 410 automatically selected
9. 118 Graphical Report Designer Report Mame bobs Report Format 373 New Report Details w Iw WebService dw CIS On lw LIS Off Survey Data PercentlA Data Report Group CIS Data Lett Axis From Date Automatic Fight Axis To Date Cancel If a red line is required on the CIS data graph to indicate the negative 0 85 Volt threshold an addition entity should be added to the CIS Group To do so first click on the View menu select Application settings select General and then click on the User Defined page tab on the Application Settings window Next enter negative threshold line or some similar text into the name field and 0 85 into the value field and click on the button At this point the Application Settings window will appear as shown below 119 Application Settings Company Details Mame Risk Averse Gas Company Lago S Graphing Pipeline Surveys Atmos Flags User Defined 54 100M Criteria 100 Acceleration due ta gravity ft s 2 3217 Compressibility Factor 0 93 Froude Humber 0 675 Gas Constant Pa m 3 mal E 8 3144 Liquid Density g cm 3 1 0 Lower Depth Treshhold 4 0 Lower Soil Threshhold 600 Valid Angle 90 Molecular v eight g g Negative Threshold Line 0 85 Upper DG Threshhald 0 02 MH ame Value
10. A Details Form has a number of pages associated with it the specific number of pages depends on the nature of the entity represented by the Details Form A Details Form is represented the database tree by an icon of some type not a folder style icon and each entity is represented by a different icon For example a Landmark 1s represented by a red flag icon see above database tree window One of the pages common to all Details Forms regardless of the type of entity 1s the location page which can be seen displayed in the above window Of critical importance on the location page are the pipeline name and the station number or milepost associated with the entity a Landmark in our example To select the pipeline name you would click on the menu button in the Pipeline field and highlight the name of the pipeline which in our example would be the North 1 Line 34 Next you would manually enter the station number or milepost for the Landmark to represent its location on the pipeline You can then apply the above procedures to use Landmarks to define the beginning of each line segment in your database tree Other uses for Landmark nodes Landmark nodes can also be used for other purposes Here are a couple of scenarios that you might encounter where Landmark nodes can be useful 1 No devices such as test stations are registered during the course of a pipeline survey If this is the case in the a
11. A window will be displayed labeled Add Rectifier Enter a name for the rectifier device in the field on this window For example you might use the name Rectifier B for the rectifier on the Section B line segment If you have more than one rectifier on a given line segment you would need to 236 have different names for each site For example if you had 3 rectifiers on the Section B line segment you might name them something like Rectifier Rectifier B2 and Rectifier B3 When you click on OK button on the Add Rectifier window the Rectifier device node would be inserted above the Compressor Station line node at the same hierarchical level To place the Rectifier node below the Compressor Station node in the database tree left click on the Compressor Station node and while holding down the mouse button drag and drop the Compressor Station node on top of the Rectifier node When you release the mouse button the Compressor Station node will be above the Rectifier node At this point the database tree window will appear as shown below Entire Database 3 gt North 1 Line 11 Section Rectifier A Mis Test Point 41 Bond 4 Galvanic Anode A Test Point 42 i f Section B z um Compressor Station vases Test Point B1 Bi Rectifier B Ca Section C 5 North 2 Line E South District Note You might take this opportuni
12. Cancel 164 SE EY St star isol 12728 1 1128 Bi TH Single Test St _ 25 Pipe Device readings in this example Test Point readings are overlaid as text as illustrated in the above graph assuming that device readings are created by ProActive during the data posting process that devices are created by ProActive during the data posting process and that devices populate the line segment in the database tree In cases where the Readings Visible control 15 activated box checked the default display formatting for the readings can be viewed via the Readings tab on the Graph Property Editor window highlighted below 165 Graph Property Editor Properties N ame Bobs Graphing Style EN s Remove Titles Anis Legend S eres Overlays Reading Pipe to So tt ttt to Sail Private Values 10 0000 General H sadin 0 0 4 Cancel The specific default formatting for each data type Pipe to Soil in the above example can be viewed by clicking on the menu button in the Reading field on the above window If required changes can be made to the default formats by checking off the Override Default box and making required modifications to the text in the three fields The Values field illustrates the format for how the reading values will be displayed on the graph as part of a Test Point Ov
13. setup Assign History Surveys Graph Audit Trail Description Devices M 1 1 Rectifier zi Include Sub route big 1 Test Point 1 Exclude Item a 1 Single Test Station MCM_1 Test Point_230 22 MCM_1 Sleeve MCM_1 Landmark Reconnect lk MCM_1 Span Reconnect_1 ES Reconnect 1 Clone Reconnect lE MCM 1 Tower 1 Water Sampling ine Crossing Rond Specifically the first 3 test sites devices have been highlighted on the above screen since as shown below these are the test sites that are viewable on the example spreadsheet generated by ProActive for this route data The remaining test sites would be viewable via the scroll bar associated with the spreadsheet 336 B D E F G H l J U Survey Rectifier Rectifier Pipe to Survey 1 Station Milepost Name amp Description Date Volts Amps Soil Other Remarks 2 2951 3 9331 MCI 1 3 T EM processed 1 23 1 0855 MUm Pipeline 5 207 87 3 3363 1 Rectifier Anode 1 5 Frisks m 5 processed 8245 13456 13 5 mv 3 845 38 4 MDE 31012005 7 Pipeline MCM_Fipelint Anode 2 8 5 545 38 4 mV MDE 301072005 g Anode 3 10 3 845 38 4 mv MDE 41102005 11 Coarse Tap 12 01845 13 Fine 14 01845 15 Line Current 16 0 3845 17 Power Mieter
14. Bl Ground Above Ground Condition Corrosion Coating Descriptions W You can repeat this process to select a Ground Level Atmospheric data type if you wish SECTION 5 HOW TO CONFIGURE THE READING TEMPLATE FOR EACH READING TYPE SELECTED 5 1 Introduction How ProActive processes the data collected at a particular test site depends critically on the nature of the reading template that is associated with each reading type for that particular test site 263 For example reading template can be configured such that the readings recorded on a route for a given reading type for example pipe to soil readings are flagged if they are out with a certain acceptable range Note Devices having flagged readings can be readily located via Summary Folders by clicking on the Flagging page tab or via the flagging indicator the triangle icon the database tree highlighted in the window shown below Entire Database E Risk Averse Gas A Test Area 2 Sample Data Also the availability of reading type data for inclusion in graphical reporting depends on the reading template configuration selected for each reading type You can also set up a formula to be used by ProActive in the case of a parameter whose value is a consequence of particular readings that are posted to the ProActive database For example Groundbed Resistance values can be calculated as Rectifier Volts Rectif
15. T E Ed BH 95 In order to have ProActive automatically re align one survey with respect to another proceed as follows Example Re aligning a Static survey with respect to a CIS Highlight the CIS the reference survey and the Static survey the target survey as indicated in the window below FMN Line CIS FMN HGFS 11 23 2009 CIS FMM_ICDA_CIS 4 10 2007 CIS IRC FMN NGFS 11 23 2009 Depth of Cover Depth 4 1 3 2007 GFS right of way 5 GPS 11 23 2009 Altitude FMM MGPS Altitude 11 23 2009 T cs MN CS JEER GFS right of way FMM_Towna B_CIS 5 1 3 2010 GPS right of way Towrd B Static 2 25 2010 aR FMM Townd B_Static 222572010 Altitude ICDA GPS 4 19 2007 GFS right of way FMN_ICOA_GPS 4 19 2007 North 1 Line _ Franks Line mr Next right click on the reference survey and select Snap Survey using GPS This will pull up the window shown below 96 Snap Survey using GPS Reference Survey Target Survey Type CIS Type Static Jab TownA B CIS Jab TownA B Static Date 5 13 2010 Date 2 25 2010 Mew ETTA Snap Parameters hi aximum Distance fram Target to Reference Paint feet haximum Perpendicular Distance fram Pipeline 20 feet basmam of Station Distance ta GPS Distance z Minimum Ratio of Station Distance ta GPS Distance Respect Position of Known Stations Add Snap to
16. The IR for the defect is 31 9356 The Total mV is 54 6 mV Total Voltage Gradient The Max mV is 18 8 mV This is the maximum DCVG voltage recorded at the defect site and it is also the first reading in the Total mV determination The Max mV value was calculated by the data logger s software by subtracting the maximum voltage recorded during the OFF part of the rectifier current cycle 3 1 mV from the maximum voltage recorded during the ON part of the cycle 21 9 mV As an aside since we know the IR and the Total mV we can calculate the IR drop value used by the data logger s software to be 171 mV 77 By clicking on Anomaly tab on the Details Form we can view specific information regarding the Anomaly as shown in the following window DCVG Defect 1 Details Form Location amp nomaly Readings Time Chart Mates Audit Trail Source Survey Investigation Pipe Description t Complete Yield t Not Required wi Passe Wall Thickness Spec Actual Remedial Item Dig Results Defect O Clock a Disposition ee gth Recoated Composite Sleeve 7 Steel Sleeve Replaced Depth Inspected E by Remark This is where you would enter information associated with direct inspection of the site of the anomaly if it was decided based on the reading values discussed above to conduct a dig at the defect site lo
17. ca North Distri C amp North 1 Line 3 Section Rectifier A Test Point 41 Bond fis Galvanic Anode Test Point 42 Ca Section B Section C e Morth 2 Line South District 232 Step 4 After populating the Section line segment you would then move on to populating the Section B line segment with its respective facilities starting with the Compressor Station which is a Device Station In our example the Device Station houses 2 devices namely a Valve and a Test Point First right click on the Section B node left click on Create Node and left click on Compressor Enter a name for the compressor station for example Compressor Station B and click on the OK button This will insert a Compressor Station node below the Section B line segment node but at the same hierarchical level Next drag and drop the compressor node on top of the line segment node This will result in the Compressor Station node being moved down a level At this point the database tree window will appear as shown below Entire Database E e Vero Beach Gas E North District North 1 Line 12 Section Rectifier A Test Point 1 Bond is Galvanic Anode Test Point 42 fu Section Compressor Station t Section C 2 North 2 Line South District 233 Co
18. 8 1 How to Use an Data Logger Once a route data file has been downloaded to a supported data logger a technician can respond to each prompt each data type turn at each device in turn 8 1 1 How to Download Route Data to Data Logger Step 1 Establish a connection between your data logger and your PC Note The details of the connection will depend on the data logger type and the operating system of your PC Step 2 Open the ProActive program on your PC by double clicking on the ProActive icon on your desktop screen and when the main menu bar is displayed on your desktop click on the Send Route button Download Route button highlighted on the window shown below M C Miller ProActive File Edit View Tools Ad d Window Help ALAR FA SPY Reports Route Bt Reads Surveys Srvy Editor Find Filter ListMgr Templates 324 This will pull up the Data Logger Send Route window as shown below depending on previous selections Data Logger Send Route Data Logger GATHERER ME Roue BobsRoute Survey Type Anud Technician P pCi Status READY Include Atmosphencs Curent Interruption w Go X Step 3 Make selections on the Data Logger Send Route window From the list of previously created Routes available to you for downloading which can be viewed by clicking on the menu button in the field sel
19. File Edit View m 2 L lene nove gend Route Get Reads Surveys Srvy Editor Find Filter List Templates Next select a Route name from the list available in the Route field Next click on the History page tab highlighted on the Route Manager window shown below 360 Route Franks s0101 ni E 54 T Setup Assig 3 urveys Hotes Graph Audit Trail Description a Devices Franks SU11 Segment ta g Include Sub raute 4 Exclude Item This will pull up a window containing a historical list of all test site surveys performed via the selected Route The test site surveys will be labeled with the survey names you gave them on the Get Readings window as discussed in Section 8 The window shown below illustrates the example of a Route named Franks SUIOI The route has had only one test site survey associated with 1t so far having MDE CS 11 2 2004 as its description 361 Besse Route Franks SL D BB 8 Setup Assign History Surveys Notes Graph Audit Trail Map Survey Report Survey Tyne Description Stat Date LastDate Status Technician Weather MDE CS 11 2 2004 11 2 2004 11 2 2004 Complete UNASSIGNED Clear Note You can drag and drop column headings in the History table to arrange the table display according to your p
20. Move Seres Change Series Data Delete Seres Data AX MIS Stretch Y Axis Translate if 5 9 42 4 327 100 Some examples of the various data editing options that are available via the Graph Mode are as follows Editing on a Single Data Point Basis To edit on a single data point basis select Change Series Data Point and Y axis for example on the Graph Mode window With these particular selections your data points can be moved up or down on the graph In order to zoom in on data points to be potentially edited check off the Points box on the Pipeline Survey Editor window and then left mouse click and hold on the graph and draw a box around the data points An example is illustrated in the window below ud Pipeline Survey Editor Survey Selection Graph Text Notes fst Graph alal d a gt Station z VB PL CIS On 3 30 2004 Voltage V VB PL CIS Off 3 30 2004 Voltage V 11 2011 10 39 09 AM To move a data point up or down with Y Axis selected left click and hold on the data point in question and move the data point to a more suitable location Release the hold when you are satisfied with the new location for the data point Note Rather than changing the value of a data point the data point can be deleted altogether Such a process may be appropriate for a contact spike scenario such as that il
21. Use Local Folder Copy To Local Folder C Users Bob Studio Documents D ata Filessa1 Survey Files Refresh Connection Version 2 6 3 0 Minimum atherer ne Version 1 0 0 To post the current readings and atmospherics if recorded to ProActive you would click on the Go button highlighted on the above Driver window Note A second option exists at the Driver stage which 1s to post current test site survey data to ProActive via a route data file that you received from the field perhaps via email as opposed to directly from a data logger connected to your PC In such a case you would check off the box labeled Use Local Folder on the Driver window and you would browse for the local folder on your hard drive that houses the route data file in question You would then click on the Go button highlighted on the above Driver window 8 2 How to Use the Manual Data Entry Capabilities of ProActive ProActive also gives you the option of manually entering data collected on a route as opposed to using a data logger 331 There two ways that you can handle the manual data entry process The first involves the generation by ProActive of an Excel spreadsheet method 1 and the second involves direct entry of data using the Get Readings function method 2 8 2 1 Excel Spreadsheet Generation Method If we assume that a Route has been created as described Section 7 the first step here woul
22. based sources and the line segment together with any facilities associated with the line segment can be presented relationship to the map 106 number of presentation style options are available to the ProActive user via the Mapping tab associated with User Preferences as accessed via the View menu View User Preferences Mapping User Preferences TenaServer BING ESRI Online Tst Aerial end Road Cache 9999 Files Onentation Fixed Bearing North Follow Pipeline in 0 Ex degree increments Overlays Pipeline E Thickness Color Pipe Color Facilities Adiust Icon Display Compass E Label Distance 280 Feet Separation x Cancel Map Data Sources The source of the data used to generate maps by ProActive is ESRI Online by default TerraServer and BING are also user selectable data sources The page tab that is currently selected determines the data source to which the ProActive application will point after the button is clicked Both the ESRI and the TerraServer data sources are available free of charge however the BING data source requires a subscription a username and password can be obtained via the following link www bingmapsportal com 107 The ESRI and BING sources provide worldwide map data however the TerraServer source only provides data for the Nort
23. Next check off the Include Atmospherics box if you plan to record visual observations data on your route If atmospheric types have been selected for a particular device on your route see Section 4 4 but you choose not to include atmospherics you will not see prompts for the atmospherics on your data logger screen Finally check off the Current Interruption box if the rectifier current on your route will be switched On and Off during your route otherwise leave this box unchecked After making your selections click on the Go button on the above window which will pull up a Data Logger Driver window Note The contents of the Driver window that you ll see at this point will depend on the specific data logger that you selected above This is because 326 each of supported data loggers has its own Driver software in ProActive The data logger Driver window shown below will be displayed for the example case of downloading route data to the G1 data logger GathererOne Driver Load Route Send Houte to Gatherer One To save your survey to the desktop computer instead of the data logger check Use Local Folder and select the folder to be used Use Local Folder C Users Bob Studio Documents D ata Files G1 Survey Files m Refresh Connection Version 2 6 3 0 Minimum athererD ne Version 1 0 0 At this point the route data you selected will have been transferred to the
24. On Off readings data posted to the ProActive database for this example anomaly device are accessible via the Readings page tab as highlighted on the above window As can be seen from the above Readings History field there are four rows of data associated with a DCVG Anomaly The data types are as follows with reference to the terms used on the data logger side see our DCVG Training Manual Percent IR Total mV divided by IR drop times 100 V Drop to Remote Total mV Max Gradient Max mV Max mV On Max mV Off Max On Off Max mV On and Max mV Off The data are displayed in milli volts 169 The Max Gradient Max mV value which in example is 21 4 mV is the difference between the Max mV On and the Max mV Off values 10 6 mV minus 10 8 mV since the Max mV On value 15 positive and the Max mV Off value is negative in this example the anomaly exhibited cathodic behavior with the CP current ON and anodic behavior with the CP current OFF These data are available for viewing by double clicking inside of the Max On Off double data field For our example the window shown below is displayed Off Reading 0 9 Cancel Remark Cathadic Anadic Survey Type UNASSIGNED Technician ae Iw Edit value s as displayed As can be seen from the above window the Cathodic Anodic notation 1s displayed in ProActive the Remark field associated with the Max On
25. y unu t 8 5 3 Overlays The types of overlays as well as their appearance be selected by the user via the Mapping tab window Pipeline The pipeline will be shown on the map if the box labeled pipeline is checked Thickness The relative thickness of an overlaid pipeline can be selected via the box labeled thickness 5 16 the default value values larger than 5 will result in a thicker line and values small than 5 will result in a thinner line Color The color for the overlaid pipeline can be selected by clicking on the Color menu button and highlighting the color of choice Note If more than one database tree folder 15 highlighted and a different pipeline has been associated with each folder selecting the X option automatic color option from the color menu the top option in the menu will result in different colors being selected automatically by ProActive to represent each of the pipelines overlaid on the map 193 automatically selected pipeline colors are Yellow Red Lime Blue Fuchsia Aqua and White Irientatian Fixed Bearing Ow Follow Pipeline in El degree increments Overlays Pipeline E Thickness Color Pine Color Made Facili Adjust Icon Display Compass Distance Label Distance 33333 Feet Max Separation The example below illustrates a case where two independent pipelines have been overlaid on a m
26. 13 4 Route Manager Option Facilities including test sites devices that have been associated with a route and that have associated GPS location data can be presented on an appropriate aerial topographical or road map By clicking on the Map page tab highlighted on the example Route Manager window shown below the facilities comprising the route each of which has associated GPS location data are overlaid on a map 401 Haute Babs Route ni E eM T Setup Assign History Surveys Notes Graph Audit Trail Map Description Devices MCM_1 Valve MCM_1 Rectifier MCM_1 Test Point MCM 1 Flange Single Test Station MCM_1 Test Point_230 22 MCM_1 Sleeve MCM_1 Landmark Reconnect lk MCM_1 Span Reconnect ES Reconnect 1 Clone Reconnect lE MCM_1 Tower 1 ater Sampling ine w Rond Example Maps shown below Include Sub route Exclude Item 402 0 a ram E a UR UD L 2 F FM ji tt T 1B gt a Lal SOE eI Ti d Dr d E d 1 MERS i BRL SE a aH Mell apo ILEUS Da 100 Aerial Map ge E FL m LI
27. Customer 2 gt Customer 3 gt Customer 4 Customer 5 Customer Step 5 Create nodes for the sections comprising both main pipelines The example here will be for the pipeline named Oil Line A similar procedure would be followed for the Gas Line pipeline Right click on the Oil Line node and left click on Create Node Left click on Line Segment since this node will be for a segment of a pipeline Enter the name of the line segment in the Add Line Segment window The first line segment name will be Section A A new node named Section A will have been inserted into the database tree and this node will be positioned underneath the Oil Line node at the same hierarchical level To position the Section node one level down from the Oil Line node left click and hold on the Section A node and drag and drop the node on top of the Oil Line node When you release the hold the Section A node will be positioned one level lower than the Oil Line node 15 Note icon for a Line Segment Summary Folder that appears in the database tree 1s different from that of a Regular Summary Folder see database tree window below Step 6 Associate the line segment Section A in our example with its pipeline the Oil Line our example You can do so by opening the line segment s Summary folder and clicking on the Information page tab Note You can open a Summary Folder either a Regular
28. Driver within ProActive and by clicking on the Go button on the Driver window above the route data will be downloaded to your data logger which in our example is a data logger You are referred to your data logger User s Manual for information on how to actually collect the required data on a route how to perform a test site survey Note A second option exists at the Driver stage which 15 to copy the route data file to a local folder on your hard drive rather than downloading the 327 route data directly to a data logger Such a procedure could be of use if you needed to transmit a route data file to a remote field technician for example who would then manually copy the file to the CompactFlash card on his data logger In such a case you would check off the box labeled Use Local Folder and you would browse for a suitable local folder target folder on your hard drive You could subsequently transmit the route data file to the technician 8 1 2 How to Post Test Site survey Data from your Data Logger to ProActive After completing a route you can post the test site survey data to ProActive where the current new data will be integrated with previously posted historical data To post your test site survey data to ProActive you would re establish a connection between your data logger and your PC and then open up the ProActive program on your PC You would then click on the Get Reads button
29. Help Show Audit Trail lt lt Back By hovering your mouse over the red triangle indicator the instructions entered the above field can be seen on the spreadsheet Note 2 If the Current Interruption box is checked off on the Data Logger Send Route window a double value cell will be presented on the spreadsheet for any template having associated On Off readings On Off Pair Reading Style selected for the template In order to enter data dates reading values or remarks you would double click on each highlighted cell in turn and type in the data As an example data have been entered for the Valve test site as indicated in the spreadsheet shown below 338 D E F G H l 1 u Survey Rectifier Rectifier Pipe to Survey 1 Station Milepost amp Description Date Volts Amps Soil Other Remarks 2 207 67 3 3331 1 Yalve 156 1 23 Eobs Remark Fraak Site Specific processed 3 Hert to 03125105 1 23 1 0555 4 Pipeline MCmM Pipeline 5 207T 5T 3 3353 1 Recrifier Anode 1 6 processed 3345 13 456 13 5 mV 3 845 38 4 mv 311012005 Fi Pipeline _MCH_Pipeline Anode 2 B 2 545 38 4 mv MOE 3 0 2005 g Anode 3 10 3 845 38 4 mv MOE 3110 2005 11 Coarze Tap 12 01845 13 14 01845 15 Line Current 16 0 3845 17 Power Mieter 18 01845 18
30. Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors CiS Templates Flagging Map Name YB PL9905 Segment Segment of Pipeline Pipeline D iS Sort Notes Next to MCM al Drag amp Drop File Organizer Folder Name Size Type Modified 185 Clicking the page tab results in the generation of an asset map The map generated for the example line segment is shown below PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors C15 Templates Compliance Flagging QQ _ 0 0 10d i581 L WOW FE WON puog L WOW E i Won E F Y a T 2 15 1 apelo uoneis 1891 8 8 6 WoW 1 0411581 een ZS 22E Mlodisal L WOW 6 02 1 WOW 3 uogaafuj 10 gtuul L E 3 E adig pasodx3 ji CE BBE 18lj283 WIW Fi Buijduues 181eAA 1 m i 4 we unu o gt 4 26 WUIOd 1581 L WOW above map is an example of 100 road map Map 0 please note the box labeled Map highlighted in the above window By changing the numerical value in the Map box to 100 the map is presented as a 100 aerial map as
31. Print Custom radio button in the Options field enter the starting and ending station numbers and the Feet Per Page that you d like to have printed By clicking in the Number of Pages field after 133 entering a Feet Per Page value the number of pages value will be automatically calculated Company Logo Inclusion A previously selected company logo can be applied to a printed graph with the Company Logo box checked on the above window To make available a company logo image use the following procedure First click on the View menu and then click on Application Settings and then General The window shown below will be displayed Company Details Mame Risk Averse Gas Company Loge General Graphing Pipeline Surveys Atma Unit Preference mperial Metric DOT Compliance Enable Compliance Testing Survey Settings Main Periadic Survey Type Annual Structure Sail Defaults Negative Voltages Instant Voltages Misc Settings Preferred Data Logger Next click on the highlighted by the red arrow icon on the above window This will result in the Image Selector window being displayed as shown below 134 m X Cancel IMIG MILLER co By clicking on the Load button on the above window a previously saved JPEG image file can be selected a company logo image file for future use in graph printing applications
32. and click on the hand icon located at the right hand side of the field Finally check off the box to switch on this group Graphical Report Designer Report Mame Bobs Report Format 352 New Report Details M ap WebService LIS Data Survey Data Percent lA Data Report Group Lett Axis From Date Automatic Fight Axis To Date Cancel b Right click on the CIS Data group name and select Entity Next click on the menu button in the Survey Types 115 field select CIS and click on the hand icon at the right hand side of the field to insert the entity in the group If you d like to use different colors to display the On and the Off potentials proceed as follows Left click on the CIS entity name This will pull up the Report Entity Detail field as shown below Graphical Report Designer Report Mame Bobs Report Format 3 3 New i Remove Report Details Iw WebService CIS Data cis Survey Data Percent lA Data Report Entity Detail CIS Survey Type Data Style f Left Axis C Right Axis Use Color Line X corea Next click on the menu button in the Data field and select On Value and via the Style menu select Line Check off the Use Color box and select a color
33. box These selections will allow us to have the database filtered with respect to a particular device type or device types on the basis of a particular folder level for example an area or a line segment within an area 305 The Filter Wizard allows you to display a tree containing only a subset of the ProActive database In the list below choose the filtering options you wish to use Drag and Drop from ProActive tree fiDevice Type Membership ocation Related Criteria EDOT Compliance Criteria Parent Folder Type BllFlagging 2507 148 1 108 Use a SQL script Al Caption ft Import Filter Description Next click on the Next button highlighted on the window shown above which would pull up the window shown below Seve eS Selection via the Database Tree Drag and drop folders from the ProActive database tree or another filter into the container window below 4 Exclude Item e Close 306 Next drag and drop a folder into the blank field on the above window If you would like to filter the database tree on device types that are local to a particular folder level say an area or a district or even a line segment it 1s that folder that you would drag and drop In our example the folder in question represents the District Filter Wizard Selection via the Database Tree Drag and drop folders from the ProActive database tree or another filter int
34. reading type button and then click the Reading Setup button highlighted on the above window This will pull up the Reading Configuration Wizard window 219 ad Reading Configuration Wizard I Configuration Settings for Amps Select Template to edit or enter new template name Rectifier Amps Fever to Non Unique Template Standard Reading Template DOT required reading Single Value 1 Omit range 40r OC Direct Current at Sing 400 Mahm impedence Current Settings gt gt As indicated above the reading template is summarized as a single value reading based a calculation 40mV Range for the voltmeter channel and designated as a DOT Required reading Next click on the Next button which will pull up the window shown below for this example Reading Configuration Wizard I Configuration Settings Amps Please select all the options below which apply to this value The basis for this value voltage taken by data logger or meter The value is manually entered into data logger meter This value should be flagged when not within an acceptable range This value normally a negative number Display this value in rmillarnips etc Display using Magnitude Direction notation This value required by the DOT Graph this value s history in the device folders Graph this value in the summary folders
35. rj MBE 3 ja 18 t al Im 2 PS augu L E zl fel TE Soll 1 15 m ae L Wu m a mu n er ne al 2 i i d uj 1 E B iul B 403 Route Bobs Route 4 i Setup Assign History Surveys Notes Graph Audit Trail Bue T A ph ao 7 uon alui WS E ml d v m EC iQ BALE L WEN 1 041581 eus 2 4 12auuna na 4545 a TE 2 3 Gr WOES Sat 3 ee X 2g 5 685 18 2 WO 226 ung 58 Dez TUOJA 8 BUNGLES 100 13 5 Overlaid Facility Types The particular facility types that are overlaid on an asset map are controlled via a User Preferences selection accessed via the View menu View User Preferences Graphing The facility types to be displayed will be those checked off in the Display Facilities field shown below 404 User Preferences Display 3D Display Station Mumbers Display Points Display Info Month Day Logic
36. zd NUN G EE WU 2 3 6 5 MS PTT Ig E bs scs LES 8 3 E 2 uu E UM r X 5 5 4 12 ert 0 25 5 7 x 2o M x amp 294 w 8 fy F ume EUR reo 00 E 5 Ph E FU HCH 1 aer Sam E E EIC 75 Burt n E z 8 N Lire Grango He n 3 3 Lue iT 4 Tork 55 amp Nw NIA Y 2 E 5 3 os 3 M I Tus m X 4 hg M Location Test Point Readings Atmospherics Graph Time Chart Nokes Audit Trail Mame MCM_1 Test Point Milepost 1481 Pipeline Pipeline State AL Series Area station 21 3402 Description Franks Site Dev Specific processed DOT Class 1 sull Type Cinders County or Franks County Parish Latitude 3 201 52283 Long 2709541 32 Town Franks Town Alignment nli 13 Altitude 1551832 Depth 6 123456 Sheet UNAS 3 Line List Installed 2172000 Em This Facility on other pipelines Retired Tech Direchons Next to 13 6 Asset Map Presentation Options A number of presentation style options are available to the user via the Mapping tab associated with User Preferences as accessed via the View menu View User Preferences Mapping 406 User Preferences TenaServer BING ESRI
37. Change button you will be changing the maximum value on the y axis scale from the automatically selected value of 27 9 based on the reading values This will pull up the window shown below Cancel For our example we have entered a maximum value of 50 replacing the 27 9 value Finally click on OK button on the above window and exist the Editing window The edited graph will be as shown below 389 Location Fiectifier Readings Anodes Graph Time Chart Mates Audit Trail e amp Points v Test Rectifier Readings Exitos on p He Pales dic co 1 1 i 1 i m L amp 12010 8 2010 10 2010 11 2010 12 2010 1 1 2011 TZT2011 10 11 45 AM Other aspects of the graph can be edited such as the titles using a similar process via the Editing feature Exporting To export the graph as a Windows Metafile 1mage file click on the highlighted button on the window shown below 390 8 Test Rectifier Details Form Location Rectifier Readings Anodes Grap
38. Click on the menu button in the Report Name field and select CIS Exception Report 6 Click on the menu button in the Pipeline Location field and select your pipeline name 7 Enter starting and ending station numbers for the section of pipeline upon which your report will be based 9 Click on the Graph button and click on the button on the What If confirm window if it appears Note If you do not want to have the What If confirm window appearing each time click on View on the main menu bar click on User Preferences click on 131 the Risk Modeling page tab and un check the Prompt for What If box 9 Examine your graphical report Note A map is part of the standard CIS Exception Report and you will need to be connected to the Internet in order to have the map generated An example CIS Exception Report is shown below Graphical Reports i into pm Model Genau Roper Re aphan Peper Sat Sores End ews Pipsline Location PMN Line v Stat Station 0400 End Station 908 62 cahi fr GO Sia Si into Facies Map 5 0 7 2 verme c 4 Sw 4 3 E a ay tt 2 amp por c z m er m Te e s 5 aM ga san M 6 4 How to Export your Graphical Report to an Image File an Enhanced Metafile 1 Following step 8 above click on the drop
39. Device field on the Information page You would then proceed to enter an action activity in the Message field for example Fix broken wire You could then click on the Assignment page tab to assign a technician to the repair job and to select a due date for the repair You would then click on the Post button to finish the process Note To Do List reports can easily be generated by exporting the table to an Excel Spreadsheet Simply click on the highlighted Export button on the window shown below and a report will be generated 23 Test Line Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors E Templates Compliance Flaggina Map Filter wo New To do Undone Month All Station t A a Assigned To Created By Device Message Field Caption Value Pipeline Milepost Due Date Done Created Arsigned SYSDBA Test Flange Repair Insulating Set Insulating Set Needs attention North 1 Line 0 3 25 2011 BENED 1 26 2011 359 SECTION 10 HOW REVIEW POSTED TEST SITE SURVEY DATA USING VIA ROUTE MANAGER You can review test site survey data that has been posted to the ProActive database via the Route Manager To do so you would click on the Route button highlighted on the main menu bar shown below M C Miller ProActive s Advanced Window Help
40. Double click on My Computer on your PC Double click on Mobile Device Double click on SystemCF Double click on Data Right click on the survey file you wish to amp select Paste the file into a local folder on your hard drive Create a compressed zipped version of the file G1 Data loggers Q100 model e Double click on My Computer on your PC Double click on Mobile Device Double click on Pocket PC Double click on CompactFlash Double click on My Documents Double click on G1 Data Right click on the survey file you wish to amp select Paste the file into a local folder on your hard drive Create a compressed zipped version of the file Q200 and MX5 models e Double click on My Computer on your PC Double click on Mobile Device Double click on System Double click on My Documents Double click on G1 Data Right click on the survey file you wish to amp select Paste the file into a local folder on your hard drive Create a compressed zipped version of the file 37 DA Meter Data logger Double click on My Computer on your PC Double click on Mobile Device Double click on My Handheld Double click on CompactFlash Double click on dameter_data Right click on the survey file you wish to copy amp select Copy Paste the file into a local fol
41. Returning to the Graph Printing window and clicking on the Preview button the window shown below is presented for the case of an example graphical report and example company logo 135 ES Bobs Report Format mies _MCM_Pipeline 1 13 2011 Note The positioning of the company logo image on the printed map be adjusted via the radio buttons in the Company Logo field on the Print Graph window The logo image in the above example top right location corresponded to the radio button selections indicated 1n the window shown below 136 5280 00 Margins 5 i Bae e b E Preview x Cancel 3 Click on the Print button and select a printer Note If you have Acrobat PDF Writer installed on your PC or Adobe Acrobat you can print to a PDF file Editing a Graph Prior to Printing As indicated on the example graphical report print preview shown above the left hand voltage scale for the CIS data is not ideal with regard to seeing details of the data This would be an example of a scenario for which graph editing prior to printing would be appropriate Each graph in a multi stack graphical report can be edited independently and addition the bottom axis can be edited as well 1f required Example Modify the left hand scale associated with the above CIS graph 137 1 After generating the graphical report as outlined in section 6 3 click on the menu button adjacent to
42. aGue 4 1 WOW cya jpauuooed Ee 5 s e A uogaefuj 10 WOW E L D n 71 o EY e co e h3 Bui duues WOW E i 7 ar 7 t 2 P m Clerk Ur pasodx3 Note The Compass icon see below shown on the above maps indicates the North direction which means that in the first map the positive Y axis 1s parallel to the North direction and in the second map the positive Y axis 15 at right angles to the North direction and 1s pointing due East as expected from our fixed bearing selections Follow Pipeline in Degree Increments Notice that the pipeline is not parallel to the X axis in either of the above fixed bearing map examples Should having the pipeline in a parallel orientation with the X axis be of interest a value of 0 can be entered in the Follow Pipeline Degree Increments field For the above example line segment the following map will be presented in this case 409 03 ad VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors El Templates Compliance Flagging Q A 0 H x x WOW WOW WOI 041581 WOW puog L WOW 8A EA L WON gt xueuipue WOW CC Ec 1 041 81 WOW t r
43. amp A zZ Route Mgr Send Route Get Reads ir emplates Reports Surveys Sry Editor Find Filte 2 Next select Survey Type from the Select List menu options and highlight a survey type Select List Survey Type Show Retired List Inert Annual Bi monthly Special Prompts r Retire Delete ri Replace Close Next click on the Prompts button highlighted on the above screen which will pull up the window shown below 2 survey Prompts Select Prompts for survey type Exclude these prompts Condition Corrosion Factor DEVIS Gradient DCVG On Off Percent IH DLVG Vv Drop to Remote Far Milepost Lett Side Drain Percent CF Pipe to Soil Alt Right Side Drain Soil Ph Soll Resistance Special Include these prompts Bicarbonates Bond Amps Calculated injection rate pint Casing to Soll Chloride MGL Corrosion Deposits Corrosion Rate Soil Resistivity Structure 5 Reading Telluric Baseline TFCandition You can then select all of the prompts reading types that you would like to apply to the highlighted Survey Type by moving those prompts into the Include these prompts field and moving the prompts that you do not want to apply into the Exclude these prompts field To move a prompt from one column to the other highlight the prompt and then click on the appropriate directi
44. main menu bar 2 Click on the Adhoc Reports radio button 3 Highlight your saved report format and click on the Next button 180 For example the window shown below highlights the example report format Bobs Anomaly Report Format created and saved in Section 7 3 above 22 Proactive Wind TT eS Select the report you want to use Bobs Anomaly Report Format Anomaly Report Pipeline Survey Report Site GPS Report Report Categories Standard Reports Graphical Reports C Design Edit Report gt gt 4 Click on the Devices from the Tree radio button and drag and drop the individual devices sites from your database tree that will form the basis of your report for example DCVG Anomaly devices Alternatively you can drag and drop a line segment folder containing devices as illustrated in the example window shown below 181 ProActive Report Wizard Bobs Anomaly Report Format Drag drop folders and or devices from t Franks ML Line the database tree to base this report r Single Test Station 2694 78 M2TK 2024 ME OCVG Defect 4 Defect 1 Defect_2 Report Based On WAG OCVG Defect_3 4 OCVG Defect_4 Mf OCVG Defect_5 ME DCvG Defect_6 CVG Defect 7 t Devices from the Tree f Devices in a Route Report sites in the order shown above f Miscellaneous lt lt Back Report 5 Click on the R
45. sub category Click on the Reading Columns sub category plus sign Check off the Survey Date box and click on the Survey Date name which will pull up the Data Item Constraint field Check off the Prompt when run box which will allow you to enter a date range for each report you generate when using this report format 175 Audi Trail m Dropped file directory Technician owner mp Data Logger Prompts H Reading Rows Ee Heading Columns Surrey Date Site Survey Type Consolidated Remarks m Atmospherics m Anode H Riearhanates Data Constrain ourvey Date Column z zd suit Descending Iw Enable Date Constraint ales From Date Until Date 28 Exclude Include Show SOL query text Scroll down to DCVG Percent IR and click on its plus sign Check off the DC VG Percent IR On box 176 E Corrosion Rate Corrosion Type Coupon Coupon Size Current DCVG Gradient Max On Off Percent IR DCVG Percent IR On DCVG Percent IR Off DEG Percent IR Remark Technician t TVG Percent IB Technician Data ltem Constrain Descending Reading Columns Show SOL query text f Scroll up to the DCVG Max On Off reading column sub category and click on the plus sign Check off the DCVG Max On Off Remark box 177
46. this step A node will have been inserted in the database tree underneath the North District node at the same hierarchical level To re position the North 1 Line node one hierarchical level below the North District node left click and hold on the North 1 Line node and drag it on top of the North District node When you release the hold the North 1 Line node will be re positioned Right click on the North 1 Line node and repeat the above procedure to create a node for the North 2 Line The North 2 Line 16 at the same hierarchical level as the North 1 Line so re positioning would not be necessary in this case At this point the database tree will appear as shown below 26 Entire Database h Gaz Co District 2 North 1 Line 2 North 2 Line South District Step 5 Create folders nodes for the two main pipelines in the South District South 1 Line and South 2 Line Right click on the South District node and left click on Create Node Left click on Folder and enter the folder node name South 1 Line A node will have been inserted the database tree underneath the South District node at the same hierarchical level To re position the South 1 Line node one hierarchical level below the South District node left click and hold on the South Line node and drag it on top of the South District node When you release the hold the South 1 Line node will be re positioned Right click on the South 1 L
47. 1 041581 WOW pauuosay BL i a ueld Pa zauuoIay 40 59 1 044691 WOW S Si E A SN X Mi din w wm 9 4 D 4 D 5 2 6 0 3ul0d 1581 L WOW ore 5 apelos We 2 d 3 adig pasodxg L7 uogefu 10191 1 WOW E modar WoW 0 89 jutogisa8l L WOW p gt 1 22 Pr SOC 1 Wow e CE 68E 4 WOW Qeon 9 5 9 gt 42 ae 8 4 Overlaid Facility Types The particular facility types that are overlaid on an asset map are controlled via a User Preferences selection accessed via the View menu View User Preferences Graphing The facility types to be displayed will be those checked off in the Display Facilities field shown below 187 User Preferences Display 3D Display Station Mumbers Display Points Display Info Month Day Logical ear Begins m T Auta Graph Pipeline Surveys w Display Line Cursor Gap Invalid Readings E Display Facilities v Anomaly Bond Coating Transition Compressor Flange Rectifier Sleeve Span Test Point hs Assets Right Click Menu By right clicking on an overlaid facility asset icon on an asset map the facility
48. 1 Line node left click and hold on the Section A node and drag it on top of the North 1 Line node When you release the hold the Section A node will be re positioned Note The icon for a Line Segment Summary Folder that appears in the database tree 1s different from that of a Regular Summary Folder see database tree window below 216 Step 7 Associate the section Section in our example with its pipeline the North 1 Line in our example You can do so by opening the line segment s Summary folder and clicking on the Information page tab Note You can open a Summary Folder either a Regular Summary Folder or a Line Segment Summary Folder by double clicking on the folder icon or on the folder name Next you would click on the menu button in the Segment of Pipeline field and highlight the pipeline with which the segment is associated If the pipeline with which you d like to associate the segment is not listed the drop down menu you can click on the page icon button at the far right of the Section of Pipeline field and enter the name of the pipeline of which the segment 15 a part the Create New Line window that appears The Summary Folders window for this example 1s shown below 217 ad Section Summary Folders Templates Compliance Flagging Information Remedial Items To do List Models Graph SUV ES Atmospheric Errors Sectio
49. 1581 1 WOW t gt 18 eAA yo Cro julodisal L CE BBE 4 ore el wer E b i 2 Left click on the Map Menu button and select the Print Map option The Print Header window shown below will be displayed This window provides an opportunity to name the asset map Enter a suitable name and then click on the button 414 Print Header i Ex vB PL33 5 5 egment x Cancel window shown below will be displayed x Company Logo e Print Current Margins Print All Pages f Print Custom Margins Feet Per Page Humber of Pages o qp Feet Per Label Divisions Per Label Start Series End Series wt Start Station End Station H 0 00 5250 00 A previously selected company logo can be applied to a printed asset map with the Company Logo box checked on the above window To make available a company logo image use the following procedure First click on the View menu and then click on Application Settings and then General The window shown below will be displayed 415 Company Details M arme Risk Avere Gas Company Logo S F General Graphing Pipeline Surveys AtmosJ Sas User D4 Unit Preference Imperial Metric DOT Compliance Enable Compliance Testing Survey Settings Penodic Survey Annual Structur
50. 18 01845 14 213 02 4 1451 1 Tezt Point Casing to Sail Frasks Site Der Specific processed 20 M EM 09123105 1 23 1 0855 21 Pipeline _ Pipeline 0 3845 23 Foreign PI 24 1 23 1 0855 25 HVAC 26 384 5 5 28 384 5 23 Copper 30 1 23 1 0855 P amp Silver 31 4 Manual Data Entry 2 As be seen from the above spreadsheet the test sites devices to be visited on our example route are listed in the order in which they appear in the Route Manager Devices field Also we have our fixed column headings representing the reading type templates in the requested order from left to right after the Survey Date column The highlighted cells are the cells into which you are being prompted to enter data Note 1 If a cell has a red triangle indicator in its top right hand corner it means that hook up help instructions were entered during the reading template configuration process For example the Pipe to Soil reading template cell in the case of the first Valve test site shown on the above window 1 Valve has the red triangle indicator As be seen 337 from the window below the Hook up Help instructions for this reading template are Use LC 4 Voltmeter Reading Configuration Wizard n Configuration Settings for Pipe to Sail Technician Instructions for Reading aka Hookup Help Use L 4 Voltmeter
51. 1s automatically associated with the survey data 1n ProActive Line field select the pipeline on which the survey was performed via the menu button in the Line field If the pipeline name 15 not available click on the page icon and create a new pipeline In our example the pipeline name would be the North 1 Line Alternatively you could drag and drop a line segment node from the database tree into the Line field to represent the pipeline question Note The line segment node must be associated with a pipeline via the line segment s Summary Folder see Section 1 5 2 Step 7 Series field Unless you had set up a station series type of system you would leave the series field the Survey Location field blank Distance Ref field If Feet Relative 1s selected via the menu button in the Distance field as 1s the case in our example the starting station number for the survey should be entered in the Station field and a selection of Downstream or Upstream should be made via the menu button the Direction field 1 does the stationing for the survey increase or decrease with walking direction respectively In this case ProActive will interpret the stationing as distances relative to the entered starting station see Station field below 62 On the other hand if either the Station Number Absolute or the Milepost Absolute option is selected
52. 2193 02 4 1481 1 Te zt Point Casing to Sail 20 Fraak a P processed 09 25 05 4 25 1 0555 21 Pipeline MCmM Pipeline Current 22 0 3545 23 Foreign PIS 24 14 23 1 0855 25 HY AIC 25 384 5 27 28 384 5 29 Copper 30 14 23 1 0855 31 PS Silver M 4 M Manual Data Entry 2 As a second example data have been entered for the first rectifier test site as indicated in the spreadsheet shown below B D E F 1 U Survey Rectifier Rectifier Pipe to Survey 1 Station Milepost Name amp Description Date Volts Amps Soil Other Remarks 2 3 9331 1 1 56 1 23 Bobs Remark Frasks Site Specific processed _ 2 Mara ERE 09125105 123 10855 Al Pipeline Pipeline E Frasks Site Specific processed 8 345 18 456 13 5 mV 3 845 38 4 302005 Hert to MCM 6 y Pipeline MCmM Pipeline Anode 2 3 845 38 4 mv MOE 3 2005 8 Anode 3 10 3 845 38 4 mv MOE 30 2005 11 Coarse As can be seen from the above spreadsheet a Rectifier Volts value of 10 25V was entered and a Rectifier Amps value of 0 021 V was entered 339 Note The entry the Rectifier Amps cell is a critical one since the value you should enter depends on the nature of the reading template Typically you would measure the voltage across a shunt for the Rectifier Amps reading a
53. 299 folder into the Devices field the Route Manager window see above window and drop it into the field by releasing your hold on the mouse button This is known as a drag and drop procedure An example Route Manager window would be as shown below in such a case Route Manager Haute Bobs Route D 55 setup Assign History Surveys Notes Graph Audit Trail Map Description Devices VB PL9905 5 egment ta g Include Sub route 4 Exclude Item Example 2 Let s say that the route is to contain only a selection of the devices that are associated with a line segment as opposed to all of the devices associated with the line segment as in the above case In such a case you can drag and drop via the database tree the specific devices into the Devices field as opposed to dragging and dropping a line segment folder The facilities associated with the VB PL9905 Segment line segment in our example can be viewed by expanding the line segment folder in our example 300 database tree the majority of the associated facilities can be seen in the database tree window shown below Entire Database Harrille f Harryyille South 2 Harrwveille North i t3 vB PL9905 5egment 1 Valve 1 Rectifier ES 1 Test Paint 1 Flange ES Single Test Station r 1 Test Point 230 1 Sleeve 1
54. 3 DV Defect 4 DV Defect 5 DEVI Defect DV Defect DV Defect 8 ES Single Test Station_1 ICDA Data 296 FMN Area 67 4 2 Viewing Survey Data Graphically via Line Segment Folders To view the pipeline survey data that have been associated with a line segment double click on the line segment folder the database tree This will open the appropriate Summary Folders as illustrated below 22 Franks 2 ne Summary Foes eee Templates Compliance Flagging Information Remedial Items To do List Risk Models Graph SLU ES Atmospheric Errors ES Franks 2 Line Segment of Fipeline Franks Line ni Gurt Mates Drag amp Drop File Organizer Folder RO Name Modified Next click on the Surveys page tab on the above window which will present the Surveys page as illustrated below 68 Templates Compliance Flagging Map Information Remedial Items To do List Models Graph Surveys Atmospheric Errors ES Fipeline Locatian Start Series End Series Franks Line Start Station 2694 78 End Station 2706 77 Depth of Cover Surveys A MZTK 2024 5 17 2003 Sail Resistivity Surveys Pig Surveys Polf Points Into LS Next check off the survey type CIS is the above example and check off the actual survey of interest the M2TK 2024
55. 5 5 2 Orientation Fixed Bearing If the Fixed Bearing option is selected the positive Y axis direction will correspond to the selected fixed bearing direction North South East West etc For example the follow asset maps were generated by selecting first a fixed bearing of North and second a fixed bearing of East ad VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors CUS Templates Compliance Flagging a 0415817 c13aLi 3 CC 0EC 1ulod sa Ns WO dues dajen Bul gt 5 2yghaalul 2 ined g Wu 23 x a 191 ad VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors ET Templates Compliance Flagging amp amp H Uu m 2 D ulod Sa1 1 Wie i aGue 4 1 WOW cya jpauuooed Ee 5 s e A uogaefuj 10 WOW E L D n 71 o EY e co e h3 Bui duues WOW E i 7 ar 7 t 2 P m Clerk Ur pasodx3 Note The Compass icon see below shown on the above maps indicates the North direction which means that in the f
56. Compass an orientation icon will be overlaid on the map to indicate the North direction Distance By checking off the box labeled Distance stationing will be shown on the overlaid pipeline at intervals matching those of the bottom graph axis stationing axis Feet Max Separation The manually entered value in the Feet Max Separation field will represent the maximum separation between pipeline data points for line joining purposes 6 2 How to Design and Save a Graphical Report Format 1 Click on Tools on the main menu bar and select Graphical Report Designer Alternatively click on the Reports speed button select the Graphical Reports category highlight Graphical Report Designer and click on the Report button Click on the New button and click on the No button on the confirm window that appears namely the Clone from current report window and enter a descriptive name for your new graphical report format Bobs Report Format in this example Decide on the design of your report format report template design and select the major groups for the format 2 4 3 For Example Let s design a format that will generate a set of stacked graphs with the individual groups in the stack representing 1 an aerial road map with the pipeline overlaid 2 a CIS data graph 3 a DCVG survey data graph and 4 a graph of IR values for marked DCVG
57. D CV Anomaly D DV Anomaly D CV Anomaly 02 703 OCVG Anomaly I2 7034 See Field Mates 02 703 Line Crossing D OVI Anomal DCVG Anomaly D CVs Anomaly D OVI Anomaly U2 704 See Field Mates 02 706 Anomaly 0206 DVG Anomaly ijui Dv Mas T otal Mas On Off MaxT otal DV On Off Dv otal DCVG Max On Off DCVG otal Dv On Off blan Total DV On Off DCYG Mas T otal DCVG Max On Off Mas Tatal DCVG Max On Off Dv Mas Tatal DCVG Max On Off DV MaxT otal DEG On Off 1 2798 0 0177 0 0216 0 0188 0 0219 0 0165 0 0174 0 0164 0 0144 0 0195 0 0117 0 0214 0 0106 0 0000 0 0000 0 0165 0 0096 0 0172 0 0169 0 0000 0 0130 0 0278 0 0000 33 5750 0 0000 31 3355 0 0000 24 3232 0 0000 25 7904 0 0000 24 2513 0 0000 51 0009 0 0000 0 0000 0 0000 22 1451 0 0000 30 9754 0 0000 0 0000 15 7253 0 0000 Cathodic Cathodic Cathodic Cathodic Cathodic Cathodic L athadic Anadic Cathodic 4 amp nodic Cathodic 4 nodic PCM indication MLSTE xing Cathodic 4 nodic Cathodic 4 nodic indication Cathodic Cathodic 35 78506 35 70924 35 70944 35 70533 35 70533 35 70971 35 7057 35 70606 35 9606 39 9624 39 9624 38 9707 35 70707 35 70707 3578723 35 70720 35 70720 35 70734 35 70734 35 70734 35 70709 35 70709 47 The above Device Readings window displays data for a n
58. Editor window is highlighted in the window below 82 Pipeline Survey Editor Survey Selection Graph mem Pipeline Start Series End Seres Franks Line Start Station 2694 78 End Station 2706 78 2 Pipeline 4 Te Start End _ FMN Line North 1 Line E Franks Line Altitude ML2 Alt b 28 2003 26 944 78 1544 78 EIS 2084 6 17 2003 269 Curent Wapper 2 1996 b 28 2003 269447 2 2024 DCYG 1 2534478 2705 78 Depth of Cover ML2TK 1996 b 28 2003 2594478 2705 78 GFS right of wap MZTK 2024 GPS B 2003 2594478 2705 78 Fig ML2TK 1996 b 20 2003 2534478 2705458 Soil Resistivity 1996 B 20 2003 2534478 2705 78 _ICDA Line 1 _ICDA Line 2 _ICDA Line 3 _ICDA Line 5 T t E Ed BH By clicking on the Notes page tab the image file icons associated with any photographs recorded using the Gx camera during the highlighted survey will be displayed in the Drag amp Drop File Organizer field on the Notes page Example The window shown below illustrates a Pipeline Survey Editor Notes page displaying 5 image file icons 93 BER cine Sure Editor i Survey Selection Graph Text Notes CIS SURVEY NOTES Drag amp Drop File Organizer Folder Attributes 05 10 2010 12 15 25 952KB JPEG Image 6 18 2010 11 0 PH p 05 10 2010 1
59. LI rj MBE 3 ja 18 t al Im 2 PS augu L E zl fel TE Soll 1 15 m ae L Wu m a mu n er ne al 2 i i d uj 1 E B iul B 316 5 i el Route Bobs Route a m pum m D 5 I ie m cm S 5 om T 2 I n eZ P mj gf a 4 41 MCM 1 Inhibitor Injection 100 Road Map Note Please see Section 13 for Asset Map presentation options information page tab which page by clicking on the Assign would pull up the window shown below 99 Once you have the devices in place that you d like to comprise a route you can display the Assign Step 4 317 S Route Manager Route Bobs Route ie 54 T e Setup Assign History Surveys Mates Graph Audit Trail Technician UNASSIGNED Compliance Criteria Compliance Date DOT Rule p Update all route devices to use rule above Via the Assign page you can assign a particular technician to the route using the List Manager function as described
60. Landmark ES Reconnect 1 Span ES Reconnect 1 ES Reconnect 1 Llane ES Reconnect FR ML T1 Tawer 1v ater Sampling ES Line Crossing w Bar 1 1 Inhibitor Injectior ES Reconnect 2 1 Band ES 1 Test Foint_317 ES Reconnect 3 1 Galvanic Anode ES Single Test Station_ en T Intemal 1 E posed Pipe 1 4bove Ground Ea MCM 1 Coating Transitic 1 Storage Well ES Single Test Station 2 ES 1 Test Foint_365 ES 1 Test Paint 3584 301 devices to comprise the route can be highlighted in the database tree as indicated in the example window shown below by utilizing the Ctrl key on your key pad Entire Database 2 Risk Averse Gas E Test Area 11 Test Line Segment Lie Test Rectifier E Sample Data ta MCM C5_ 9102005 METER 6 1 7 03 ta 5 9102005 4052 000 gt VB Diustricr3anib i amp Harry ville gt Harreville South Harryville Morth f VB PL9905 5 egment B ML 1 Valve MEM ES 1 Test Paint 1 Flange Test Station ES 1 Test Point 230 1 Sleeve T1 Landmark ES Reconnect kk 1 Span ES Reconnect 1 ES Reconnect 1 Llane ES Reconnect 1 _1 _1 Sampling ES Line Crossing w No Bar 1 Tank 1
61. Name RecifieA 0 0000025 0 Milepost Pipeline IMathlline State FL l NES o e Aces Morth District Station 0 00 Description Pn DOT Class 3 x soil Type Sees or ee Latitude Longitde amm Town age Alitude lgrment e Line List 00 Installed This facility on other pipelines Retired E Tech l Directions Site iz 500 yards South of the State Haad BU LIS1 intersection an the West side As can be seen from the above window the pipeline name the area name and the short form state name have been selected on the location page of the Rectifier A Details Form This location information is common to all of the other entities that will be added to the Section A line segment If other location data will be common to all entities on one of your line segments perhaps all entities will be located in the same county for example you would also enter such common data at this time This is so that when you add the other entities to your line segment the common information will not have to be entered on each entity s location page In such a case you will only need to enter the unique information pertaining to each entity such as station number How to use the Batch Update Location function Alternatively you can use the productivity tool known as the Batch Update Location feature to automatically enter common location information to the location pages of all
62. Negative Threshold Line 0 89 Replace Add Delete At this point the negative threshold line will be available as an entity selection in the Pref Constants lists To add this line as an entity return to your report format in the Graphical Report Designer right click on the CIS Data group name click on the menu list in the Pref Constants field highlight the new negative threshold line entity and click on the hand icon to insert the entity into the CIS Data group 120 Report Mame Bobs Report Format New Remove Report Details m v Map CIS Data DIS On fw CIS Off Negative Threshold Line OCVG Survey Data Percent Data Report Group CIS Data Lett Axis From Date Automatic Fight Axis Ta Date x Cancel Next left click on the negative threshold line entity and select a color for the line typically a red color in the Report Entity Detail field Also select Single Value in the Data field Finally check off the Negative Threshold Line box to switch on this entity 121 8 sna Report Mame Bobs Report Format New Remove Report Details Bl v Map if CIS Data fv CIS On v CIS Ot Negative Threshold Line OCVG Survey Data Percent Data Report Entity Detal Negative Threshold Line Pref Canstan Data Style v LeftAsis Right Aris Use
63. Note The positioning of the company logo image the printed map adjusted via the radio buttons in the Company Logo field on the Print Graph window The logo image in the above example top right location corresponded to the radio button selections indicated in the window shown below 417 Options Print Current C Print All Pages Print Custom Page Setup Feet Per Page Feet Per Label Stark Series Stark Station H Number of Pages Divisions Per Label End Series End Station 418
64. Online Tst Aerial end Map Road Cache 9999 Files Orientation Fixed Bearing North Follow Pipeline in 0 degree increments Overlays Pipeline Thickness Color Pipe Color Facilities Adjust Icon Display Compass Name Label Distance 280 Feet Max Separation 13 6 1 Map Data Sources The source of the data used to generate maps by ProActive is ESRI Online by default TerraServer and BING are also user selectable data sources The page tab that is selected determines the data source to which the ProActive application will point after the button is clicked Both the ESRI and the TerraServer data sources are available free of charge however the BING data source requires a subscription a username and password can be obtained via the following link www bingmapsportal com The ESRI and BING sources provide worldwide map data however the TerraServer source only provides data for the North America region 407 In all three cases the map data represent superposition blend of two maps types for example aerial and road and the percentage of each map type is user selectable via the parameter indicated on the map window see above for examples 100 for Map selection would represent 100 of the 1 Map selection and 0 of the 27 Map selection whereas a 0 selection for would
65. Route Mor Send Route Get Reads Surveys Srvy Editor Select List List Annual Bi monthly Special Frompts retire Delete Replace At this point you can add a new list item or you could remove an existing list item To remove a list item highlight the item and click on the Delete button To add a list item click on the highlighted Insert button and provide a name for the new survey type For example the screen shown below illustrates the addition of a Semi Annual survey type 271 _ cue IEEE Select List Survey Type Show Retired List 4 Insert Annual Bi monthly Special gl Prompts Retire x Delete Replace Once a new survey type option has been saved by clicking on the highlighted Save button you can elect to assign particular reading types associated with particular devices to the new survey type by checking off this survey type box when appropriate during the reading template setup process for each reading type Alternatively you can use a batch processing function to select all reading types that will apply to a particular survey type as follows Click on Tools on the main menu bar and select List Manager Alternatively you can click on the highlighted List Mgr button on the window shown below Miller ProActive File Edit View Tools Advanced Window Help E
66. Save Close Previous You have the option here of saving your filter criteria for possible future use or proceeding to apply the filter without saving the criteria To save your filter criteria click on the Save button on the above window and enter a name for the filter via the window shown below Filter Caption Cancel Note Saved filters are accessible via the Filters field located at the top of the database tree window and saved filters can be applied simply by 309 clicking on the menu button in the Filters field and highlighting a saved filter This means that filters can be re applied whenever required To apply the filter you would click on the Apply button on the above screen Bobs Filter Untfilter 8A 2 Filter Bobs Filter E Risk Averse Gas Sample Data 2 2 Harrwville South Risky Line Lie Rectifier Lie Rectifier 1 Riky 193 23 Fournile North t vB PL9905 5egment Lie 1 Rectifier 1 Rectifier 383 3 t Franks 5011 5 Lie SU11 Aectifier In our example as indicated on the above window only Rectifier devices are displayed in the database tree associated with only the Harryville District which was our filter At this point you could drag and drop the individual Rectifier devices into the Devices field on the Route Mana
67. The list items in the present database associated with the Atmospheric Corrosion list type are displayed in the List Manager window shown below 257 Select List Bw Show Retired List 4 Insert Blister Cracking D isbanded Discolored Good Peeling Severe Retire Delete Replace n Close These list item names can be replaced with other names by highlighting a list item name and clicking the Replace button and additional list item names can be added to the list by clicking on the Insert button Coating The list items in the present database associated with the Coating Transition list type are displayed in the List Manager window shown below 258 List Manager Select List EWE ER EE Shaw Retired List 4 Insert Coal Tar Enamel Coal Tar Epoxy Cold Applied T ape Poluke Cold amp pplied Tekrap Fusion Bond Epoxy Somastic These list item names can be replaced with other names by highlighting a list item name and clicking the Replace button and additional list item names can be added to the list by clicking on the Insert button When Atmospheric data are recorded at a test site and are posted to the ProActive database the data associated with each sub category data type are accessible via the Atmospherics page of the test point s Details Form As an example Above Ground and Grou
68. a a 2 cr 270 00 Station z VB PL CIS On 3 30 2004 Voltage V VB PL CIS Off 3 30 2004 Voltage V 1 11 2011 11 38 02 AM Next left click and hold on a data point and move the point to the left or right until you have achieved your desired result Finally click on the Clear Locked Points button on the Graph Mode window to clear the locked points remove the white vertical lines from the graph The Clear Locked Points button is highlighted the Graph Mode window shown below 105 Graph Mode MHormal Move Seres Change Series Data Delete Seres Data w X Anis Y Ass Translate Linear Point fu Snap Any 253 55 1 385 SECTION 6 HOW TO GENERATE GRAPHICAL REPORTS USING THE GRAPHICAL REPORT DESIGNER The Graphical Report Designer offers the ultimate in flexibility with regard to generating graphical reports including the ability to incorporate maps aerial topographical or road maps with the pipeline and associated facilities overlaid Once designed graphical report formats can be saved and selected for use whenever required The following sections describe the principal processes associated with report generation via the Graphical Reports Designer 6 1 Map Considerations Assuming that GPS Right of Way data have been associated with a line segment appropriate map data can be acquired by ProActive via Internet
69. ad Property Properties N ame Babs Graphing Style m EN Private 372 New 4 Remove Titles xs Legend Seres Uverlays Overlay Type BESTE n iw Visible Exclude Label Visible Destation e Position Angle t Top f Bottom f 270 90 45 Text W Outline uA Facility Readings iw Visible Wisible General Headings Cancel 163 4 4 Maece General Bobs Alepia Ferrea Etj Ar AA ee 9 saam Pool ing CIS Data ul Lira By modifying the control settings as indicated in the window shown below text originating from the bottom text orientated 90 from the horizontal font size increased and device readings visible the Test Point Overlay example becomes as illustrated in the graph presented below Properties Name Bobs Graphing Swe 7 B Private 373 New Remove Titles As Legend Senes Uverlays Overlay Type n Ru LU Visible Exclude Labe Visible Stations Position Top Bottom 2 060 90 f 45 Font Reading Visible Visible General Headings
70. columns plus all others you are given the opportunity to select the reading templates for which data will be reported in the main columns and in this case all other reading type data stored for your selected devices will be reported in an other column d After you ve made your selection click on the Next button Enter text 1f required to add to the title of your report in the Supplemental Text field and click on the Report button The specific Report Column Configuration window that ll come up will depend on your selection in step c above For example if you selected Fixed columns plus custom others you can drag and drop reading templates into and out of the Fixed Columns field and you can also drag and drop reading templates into and out of the Other Column field If you selected either of the other two options you will only be able to drag and drop reading templates into and out of the Fixed Columns field After you ve made your column selections click on the button which will generate your Excel Spreadsheet report 381 SECTION 12 HOW TO GRAPH TEST SITE READINGS DATA 12 1 Introduction Historical test site readings can be graphed on an individual device test site basis Details Form basis as a function of reading date and also on a line segment basis Summary Folders basis as a function of station number or milepost However in order for ProActive to be able to plo
71. customers It is suggested that you create folders to represent each one of your customers and to develop suitable sets of subordinate folders within each customer s folder depending on the nature of each customer s pipeline system Step 1 Assuming that you have backed up the As Received database see Section 1 3 you should retire all of the nodes up to the top node in the As Received database tree Alternatively you can leave the Sample Data folder in place and build parallel branches of the tree To retire a node right click on the name of the node or on the folder icon and left click on Retire Step 2 Rename the top folder top node You should rename the top folder node to be the name of your company in this example the contractor company name ABC ENERGY To rename a node right click on the name of the node or on the folder icon and left click on Rename Node Enter the desired folder node name Step 3 Create folders nodes to represent each of your customers To create a folder to represent Customer 1 you would right click on the top node left click on Create Node and left click on Folder Next you would enter the folder name Customer 1 in our example in the Add Folder window and click on the button This will result in a folder node being inserted into the database tree under and subordinate to the top node Next you would right click
72. down list arrow button located next to the Graph button and select Export Graph 2 Decide whether you d like to export the whole report multiple graphs or the individual graphs to individual files If the whole report is required click on the whole button 3 Click on the Yes button on the Ignore background color when exporting confirm window to have a white background for your report 132 4 Select a folder location your PC which to save the exported file for example your My Documents folder and enter a name for the file 5 Retrieve the file on your PC and examine its contents You can now email the file to a customer or to a manager for example 6 5 How to Print a Graphical Report including how to incorporate company logo amp how to edit graphs prior to printing 1 After generating a report as described in Section 6 3 click on the menu button adjacent to the Graph button and select Print Graph Graph Printing Options Company Logo fw t Print Current Margins t Print All Pages Print Custom oY Margins Page Setup Feet Per Page Number of Pages 12500 1 Feet Per Label Divisions Per Label End Seres End Station Start Series Start Station H 2594 78 Detail Screen 30 High Page Numbers Margins E 3 Blu E 2 E Preview X Cancel 2 To print your report over a number of pages click on the
73. entry in the Description field Note This is an important entry as you will be effectively naming your test site survey here Since you will build up a history of test site surveys done on a particular route over time vou might want to develop a naming system for surveys associated with a particular route As 1s discussed in Section 10 you will be able to review the details of historical test site surveys associated with a particular route using the Manager The start date the date that data were recorded at the first test site on the route and the last date the date that data were recorded at the last test site on the route will be posted automatically as read from the route data file Finally check off the Include Atmospherics box if you recorded visual observations data on your test site survey and check off the Current Interruption box 1f the rectifier current during your survey was switched On and Off otherwise leave this box unchecked When all of the above entries have been made you would click on the Go button on the above window which will pull up the Driver window for your specific data logger type The Driver window shown below relates to the G1 data logger 330 GathererOne Driver Get Readings Get Route from Gatherer One IF you have already moved your survey data to the desktop computer check Use Local Folder and select the folder where it
74. field based a knowledge of the shunt used This is because data entered directly into the Route Data Entry engine are not subject to reading templates in contrast to data coming in from data loggers or spreadsheets Note 2 You also have the option of saving your manually entered data on your laptop s hard drive in the form of an Excel spreadsheet by clicking on the Export button 354 SECTION 9 HOW TO POST REMEDIAL ITEMS AND REPAIRS TO DO ITEMS Certain devices that typically require to be periodically repaired such as Test Points and Insulating Flanges have been provided in ProActive with a facility that allows you to post remedial items and repairs to do items based on your findings during the course of a test site survey You would typically post such items after posting your test site survey data to ProActive see Section 8 If you have a laptop running during a route you could actually post these items as you encounter them at each test site by opening the appropriate device Details Form via the database tree and proceeding as described below By way of example let s imagine that during a test site survey you determined that the insulation had failed on one of your insulating flanges In this case you could add a repair to do item on the device specific page associated with the device in question and then have the item posted to the database Once posted a repairs to do item can be v
75. i Curent 40242 i VAC PipetoSol S 00 5 PipetoSolD S 00 5 Open Circuit Potential 000 Curent Foreign PAS 00000000 ingle Test Station PipeToSol 0 0 0 0000 0 0 0 MEM T TesPoint 230 22 Casing to Soll 0000 TTestPont 20 22 Foreign PAS T TesPomt 230420 0 0 TTesPont 22622 P S Copper 00000000000 0 Ca 21 2 2 lB S ww Wo 9 9 Tn TT 0 0 0 70 Ne a ene a 2 21212 5 2 5 2 Pipe to Soil On 1 56 Pipe to Soil Off 1 23 Remarks Bobs Remark Edit values in their normal display units Propose prior remarks for new readings Head Date 1 Update ProActive with Masam v Automatic Import Export 156 Readings Untaken The above window illustrates how ProActive will display our entered data Please note particular the Rectifier Amps value of 21 which 15 the result of the calculation discussed above Finally you would click on the Update ProActive button on the above window assuming that all data had been entered which will cause your current test site data to be posted to the ProActive database 345 You check to make sure that the current data were posted correctly to the database by accessing the readings history fields of the d
76. illustrated below PL9905 Segment Summary Folders l Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors Templates Compliance Flagging Q E Map 100 _ 028 it 1 70 Wr 5 P SE 212 Ee NUS Be 9 d P 2 9 E 9 ATA QUEEN W ETT Ag genet wn ae 4 4 oe i 1 e E A 2 M 2 4 j oe 7 M r F 7 _puigulestraye DT 7 NT mar 5 E a j 7 ui 2 mer id ul diao 4 e 9 NE RHE RSM 5 2 E o o ajn IH sc Jeu malg 1 3 nma SAER C aaas J E abe geg Wim gt La L s a JUS Y uel 186 8 3 Database Tree Folder Option Right click on a database tree line segment folder the VB PL9905 Segment folder in our example and left click on the Map Folder option on the right click menu An asset map for the selected folder will be generated automatically as indicated in the example below Folder Map VB PL9905 Segment gt puog L E p WOW 0
77. indicated on the above window all of the prompts that are associated with each test site device are listed and you can enter values for each prompt in the highlighted field Note The previous values for each reading are also presented The date that each reading was taken should be entered via the highlighted Read Date field via the calendar icon 351 The window shown below indicates that data have been entered response to the first 3 prompts Site Prompt n Max ff Min Date Technician_ Remarks MCM TReciier ms 5A UNASSIGNED MCM lReciier ____ 0144580 1 29 2011 UNASSIGNED MCM THeciier 0 2 MCM TReciier Coarse Tap 00000000020 MCM _____ 00 o 202 MCM PowerMeter S o0 o o o MCM1Rectfier MCM 0 lt MCM MCM_1 Test Point Casing to Soil 0 00 MCM_1TestPoint Foreign PAS TTetPont PXS Zine 0000 00 MCM_1 Test Point P SCoppr 000000000025 TTetPont PAS Silver 00 0 00000 000 MCM_1 Test Point Open Circuit Potential 0 00 MCM_1 Test Point Curent S S MCM_1 Test Point MCM_1Flange PipetoSolU S 00000045 MCM_1Flange Pipe to Soil D75 000000004 MCM_1Flange Open Circuit Potential OOOO 00 MCM_1Flange o o 0202 MCM_1Flange Foreign PAS Single Test Station Pipe To So MCM TTestPont 230 22 Casing to Soil 0000
78. logger has its own Driver software program within ProActive that allows survey data to be brought into ProActive directly from data loggers or from data logger survey files saved in your Local Folder Windows based data loggers only 3 2 How to Bring Survey Data into ProActive Directly from a Data Logger Step 1 Establish a connection between your data logger and your PC Note The details of the connection will depend on the data logger type and the operating system of your PC Step 2 Double click on the ProActive icon on your PC s desktop screen This will open up ProActive s menu window 42 E File Edit View Tools Advanced Window eports Route Mgr ES Route 46 Editor p Filter List Mgr Templates Step 3 Click on the Surveys button highlighted on the above window on the menu bar This will open a window labeled Data Logger Get Pipeline Survey Data Logger GATHERERONE Survey LE Status READY Click on the menu button in the Data Logger field and highlight the type of data logger from which you are copying the survey file 43 Next click on the menu button in the Survey Type field and highlight the Survey type Finally click on the button Note It may take a few seconds for the data logger Driver window to appear particularly if you are using a Serial connection Step 4 Select the survey file of interes
79. on the button this device node will be automatically inserted one level below the Compressor Station node in the database tree To add the second device to be housed inside the Compressor Station 1n our example a Test Point named Test Point B1 you would right click on the existing Valve BI device node left click on Create Node and then left click on Test Point Once you have entered a name for this device in our example the name would be Test Point B1 and clicked on the button this device node 235 will be inserted below the Valve device node the database tree at the same hierarchical level as the Valve B1 node At this point the database tree window will appear as shown below Entire Database North 1 Line 11 Section Rectifier A Test Point 1 Bond isi Galvanic Anode 2 Test Point 42 tu Section B um Compressor Station B vases Test Point 1 Ca Section C gt North 2 Line E South District How to proceed to add the first entity on the line segment that will be outside of the Compressor Station facility To add the first entity to the line segment outside of the compressor station facility which is a rectifier in our example Section B line segment you would proceed as follows Right click on the Section node left click on Create Node and left click on Rectifier
80. on the Customer 1 node left click on Create Node and left click on Folder You would then enter the folder name Customer 2 in our example the Add Folder window and click on the OK button This will result in a Customer 2 folder node being inserted into the database tree below the Customer 1 node You would repeat the above procedures to create nodes folders to represent each of your customers For example the database tree would be as shown below for the case of creating nodes to represent six customers Entire Database ABC ENERGY gt Customer 1 gt Customer 2 gt Customer 3 gt Customer 4 Customer 5 Customer 12 Step 4 Create nodes folders to represent the pipelines associated with each of your customers Our example here concerns Customer 1 Let s assume that Customer has two main pipelines that you will be surveying Oil Line and Gas Line Let s also assume that three sections have been identified for the Oil Line and 4 sections have been identified for the Gas Line Setting up a system of folders for Customer 1 to represent the physical layout of the pipelines you ll be surveying is an important step see the hierarchical diagram below Sec 5 Sec sec Sec C A B C D Physical Pipeline Layout 5tructure for Database Iree Creation 13 By right clicking on the Customer 1 node you can s
81. previously in this manual via the Technician Names list name and you can if you wish assign Compliance Criteria to the route including the next Compliance Date for the route by clicking on the calendar icon and selecting a date Regarding the DOT Rule selection once you ve created a route for example a route comprising only Rectifiers and Bonds perhaps created using the Filter function you could assign the route a bi monthly DOT Rule Your other current choices regarding DOT Rule can be viewed by clicking on the menu button in the DOT Rule field You could if you wish also have any DOT Rule you may have previously assigned on an individual device basis see the Readings page of each device s Details Form automatically changed to reflect the DOT Rule that you have selected for the route itself by clicking on the Update all route devices to use rule above button 318 You also modify existing DOT rules and you can create new rules to suit your Own requirements using the DOT Rule Editor To perform such functions you would click on the Advanced menu highlighted below on the main menu bar M C Miller ProActive File Edit View Advance Reports Route Mgr Send Route Get Reads Surveys Srvy PWindow Help AR OY ze Editor Find Fitter List Mgr Templates Next you would select the DOT Rule Editor option from the menu which will pull up the DOT Compliance Ru
82. range value of 400V DC having an associated 75MOhm input impedance 5 3 How to Modify Reading Templates on a Test Site Basis A reading template can be viewed and potentially modified via the Details Form associated with a particular test site device Should a reading template be modified by this means the template will become Unique to that particular reading type and to that particular test site device Note An option exists to have any modifications applied to the standard template associated with the reading type in question in which case the modifications would affect all reading types throughout the database that utilize that template This would be analogous to modifying a standard reading template as described above in Section 5 2 Example Let s modify a reading template the Rectifier Amps template associated with the test site device highlighted in the data base tree shown below 211 i E Risk Averse Gas i E Test Area O Test Line Segment Test Rectifier 2 Sample Data Double click on the device icon to open the Details Form and click on the Readings page highlighted on the window shown below 278 eas Location indes Graph Time Chart Mates Audit Trail Setup Descriptions es Amps zi S Reading Setup J Amps Volts zi l Compliance DOT Rule UNASSIGNED Nest Reading Due Next click on the Amps
83. reading type for which annual was not a Survey Types selection during the reading template set up process 332 Next check off the Include Atmospherics box if you plan to record visual observations data on your route If atmospheric types have been selected for a particular device on your route see Section 4 4 but you choose not to include atmospherics you will not see cells for atmospherics on your Excel spreadsheet Finally check off the Current Interruption box if the rectifier current on your test site survey will be switched On and Off during your survey otherwise leave this box unchecked Data Logger Send Route Data Logger Manual Data Entry Route Bobs Route Survey Type Annual Technician Frank Prior Type Annual Status READY After making your selections click on the Go button highlighted on the example window shown above which will pull up the Spreadsheet Column Configuration window shown below 333 Spreadsheet Column Configuration Customize the spreadsheet by dragging and dropping the Reading Templates to and from the Fired Columns The order of the Fired Columns will be reflected lett to night in the spreadsheet Any other Heading Templates will appear in the Other calumn Heading Templates Atmaspherics Bicarbonates Brand Calcium Fixed Columns Fipe ta Sail Casing to Sail Foreign Py S Current Rec
84. represent 100 of the 2 Map selection and 096 of the 1 Map selection Any value in between 100 and 0426 would correspond to a particular blend of the two selected map types The available map types for each data source aerial topographical road etc can be selected for both the 1 and 2 Maps by clicking on the menu buttons in the relevant fields and highlighting the choices 13 6 2 Orientation Fixed Bearing If the Fixed Bearing option 15 selected the positive Y axis direction will correspond to the selected fixed bearing direction North South East West etc For example the follow asset maps were generated by selecting first a fixed bearing of North and second a fixed bearing of East ad VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors CUS Templates Compliance Flagging a 0415817 c13aLi 3 CC 0EC 1ulod sa Ns WO dues dajen Bul gt 5 2yghaalul 2 ined g Wu 23 x a 408 ad VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors ET Templates Compliance Flagging amp amp H Uu m 2 D ulod Sa1 1 Wie i
85. review the details of historical test site surveys associated with a particular route using the Manager The start date the date that data were recorded at the first test site on the route and the last date the date that data were recorded at the last test site on the route will be posted automatically based on your Read Date entries on the Route Data Entry window see below Finally check off the Include Atmospherics box if you recorded visual observations data on your test site survey and check off the Current Interruption box if the rectifier current during your survey was switched On and Off otherwise leave this box unchecked When all of the above entries have been made you would click on the Go button highlighted on the example window shown below 349 Data Logger Manual Data Entry Haute Bobs Route Survey Type Annual Technician UNASSIGNED Override Logger Prior Type Weather Cloudy Descriptions Manual Data Entry Test Start Date Last Date Include Atmospherics Cove This will pull up the Route Data Entry window shown below for this example route 350 Site 1 of 26 Site MCM 1 Wale Pipeline Pipeline Milepost 3 3331 Station ZU 757 1 1 Prompt 1 af 1 Prompt Pipe to Soil Range 5b V dc Sing 400 Mahm impedence 7 Electrode Copper Sulfate Normally
86. right of way data have been associated with the line segment as indicated below 398 survey selection Graph Text Notes Pipeline Start Series LL End Seres MEM Pipeline Start Station 207467 End Station t 389 7 2 Pipeline Stat End _ Franks Line ICDA Line 1 _ICDA Line 2 ICDA Line 3 ICDA Line 5 Line ICDA Line _Marks Line _MCM CS_ 97102005 4052 000 _MCM CS_ 9102005 6 17 Pipeline CIS VB PL CIS 330 2004 2207 67 389 57 s GPS right of way VB PL CIS GPS 323022004 ote _Risky Line Hon Line 1 _Test Line Double clicking on the line segment folder in the database tree presents the Summary Folders for the line segment As indicated in the Summary Folders window shown below one of the page tabs is a Map tab Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors CiS Templates Flagging Map Name YB PL9905 Segment Segment of Pipeline Pipeline D iS Sort Notes Next to MCM al Drag amp Drop File Organizer Folder Name Size Type Modified 399 Clicking the page tab results in the generation of an asset map The map generated for the example line segment is shown below PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys A
87. second issue 1s the shunt factor calculation configured into the reading template An example configuration 1s shown below for the case of a I Amp mV shunt 340 288 Reading Configuration Wizard Configuration Settings for Amps Adjustments En raw voltage for shunts and electrodes Before displaying the reading take the millivolts and f volts Multiply bu 1 amps mw shunt Factor andor Add 0 m electrode offset Test your adjustment factors here Haw m becomes Help lt lt Back In the above example ProActive will assume that the entered value is in Volts and it will first convert the entered value to mV and then multiply that value by 1 The calculated value will then be displayed as an Amps value So for our example for an entered value of 0 021 Volts ProActive will display a value of 21 Amps 0 021x1000mV x1 At the completion of your test site survey after you have entered data into all of the highlighted cells you would save the spreadsheet to a hard drive location on your PC Next you would click on the Get Reads button highlighted on the main menu bar shown below M C Miller ProActive no File Edit View Tools Advanced Help A A A JE e Reports Route Mgr Send Ro Get Reads Surveys Srvy Editor Find Filter List Templates This will pull up the window shown below depending on previous settings 341 Data Log
88. seen from the Reading Configuration Window shown below we have selected the existing reading template named 5011 Resistance for our example per Shame Configuration Settings for 5011 Resistance Select Template to edit or enter a new template name Revert to Mon LInique Template Settings Current Settings Standard Reading Template Manual reading Single Value Help lt lt Back Next gt gt 250 This particular Soil Resistance reading template is a standard reading template as can be seen from the summary description in the grey shaded field shown in the window below Please refer to Section 5 for information on how to re configure an existing Reading Template or how to create a new Reading Template Reading Configuration Wizard Configuration Settings For Soll Resistance Select Template to edit or enter a new template name Current Settings Standard Reading Template Manual reading Single Value Help Once the Reading Template has been associated with the Reading Type the Readings page will be modified as indicated below Notice that the red shading has been removed from the newly created Soil Resistance reading type 251 Galvanic Anode Details Form Location Galvanic Readings Graph Time Chart Mates Audit Trail Setup Descriptions p Soil Resistance zi ij Fipe to sail Anode to sail Anode curent Soll Resistance History mul
89. the above field and clicking on the highlighted Delete Local button on the above window the template will be reverted back to the Standard template or to a higher folder level localized template should one exist Note In newer versions of ProActive the button may be labeled as Revert Local rather than Delete Local How to Revert Unique Templates back to Standard or Localized Templates If there are any Unique reading templates See Section 5 3 associated with any devices in a folder those devices can be highlighted via the Show Unique button on the Templates page of a Summary Folder see above window to locate the Show Unique button As indicated in the window shown below an additional field 1s created to display any devices having associated Unique reading templates 290 DIC NC Information Remedial Items To do List Risk Models Graph SU ES Atmospheric Errors ELS Templates Compliance Flagging Heading Templates Local to this Folder Unique Template Locations All Prompts Test Rectitie zi Add Local BE Edit Local at Delete Local GS Re Apply Local Revert Duplicates Checked E I By checking off the device in question located the new field and clicking on the Revert Checked button highlighted in the above window a Unique template 1s reverted back to either a Localized template or to S
90. the follow maps were generated by selecting first a fixed bearing of East and second a fixed bearing of West 108 Brera v Repar Fracks Repent Sai Series Podka Lecaten HCN Stat State 0747 Ered traen 58 52 Ez Bih r i p Eu jg T 3 zm 250 z m t 2 3 B in kh n D E a 2 Iai Zea o 58 s Praska Fieger Pedre E j Map E Ed E k 1 15 Du Eu m eroe 2 Tr 4 4 am 1 dE 58E ed NUM F was n es z Viens a nip aunq k EE S 1 pat puah i HIA ah f E ff po Dene hed Bal purger Una West Bearing selected Note The Compass icon see below shown on the above maps indicates the North direction which means that in the first map the positive Y axis 15 parallel to the East direction and in the second map the positive Y axis 1s at right angles to the North direction and is pointing due West as expected from our fixed bearing selections Follow Pipeline in Degree Increments Notice that the pipeline 1s not parallel to the X axis in either of the above fixed bearing map
91. the management of test site data Important concepts are introduced such as how to configure your ProActive database to best represent the physical layout of your pipeline system and how to select the data that you require to be collected at each of your test sites ProActive works in an integrated fashion with test site survey programs running on supported data loggers In addition ProActive supports manual entry of test site survey data either through the generation of Excel spreadsheets or through the use of a direct manual data entry feature Test site surveys are typically performed either on an annual basis or on a bi monthly basis and involve collecting data at specific test sites or devices associated with a pipeline system such as test points test Stations rectifiers bonds valves etc A test site survey route is created in ProActive by the selection of the specific devices test sites that will comprise the route and by setting up the order in which the devices should be tested on the route In addition the data to be collected at each type of device test site on a route are programmed in ProActive The procedures involved with creating routes including programming the actual data to be collected at each particular device are described in this training manual Once test site survey routes have been created route data can be downloaded to a data logger or ProActive can generate an Excel spreadsheet f
92. this example the minimum voltage value was entered on the above window as 1 8V since no CIS voltages were more negative than this value with regard to the data appearing on the graph Repeat the above process to select a maximum voltage value by selecting the Maximum tab and clicking on the Change button In this example a value of OV zero volts was entered since no CIS data value were more positive than zero on the displayed graph Maximum Voltage Cancel print preview of the graphical report based on these edits to the CIS Data graph scale is shown below 140 Gees ae Bobs Report Format MG MILLER ca _MCM_Pipeline 1 13 2011 As can be seen from the above graphical report by adjusting the scale on the CIS Data graph a higher level of detail is presented in this example Note Edits performed via the Edit Graph function only apply to the particular graphical report on display 6 6 How to Create amp Save Graphing Styles The ProActive application provides a Default set of graphing properties that result in a particular style of graphical report presentation A user however can create unique graphing properties that can be selected for application to the generation of a graphical report using any of the graphical report formats saved in the database Of particular concern with regard to Graphical Reports 1s how Titles both headers and f
93. via the Graph page on the Rectifier s Details Form see Section 12 to Generate Graphical Reports Also the reading 1s to be flagged if the current reading differs from the previous reading by more than 30 Clicking on the Next button will pull up the window shown below 267 288 Reading Configuration Wizard Configuration Settings for Rectifier Volts Reading Style Single Value Meter Range 200 Input Impedance 400 Current Type oc Direct Current Meter Channel Options Predominant Aif Synch Interruption Filter Coupon Help lt lt Back As indicated on the above window a Target Meter a target Data logger can be identified by clicking on the menu button in the highlighted field Selecting a particular data logger type for example a Gx Data logger will result in the various settings being restricted to only those pertinent to the selected data logger By clicking on the menu button in the Meter Setting field an appropriate Range value can be selected from the various options listed In this example case a 400V range was selected this channel on the Gx Data logger has an associated 75 MOhm input impedance as indicated on the window shown below 268 ad Reading Configuration Wizard Configuration Settings Far Rectifier Valls Target Mater 355 Heading Style Single Value Meter Setting 400 VDC 75 MOhm Meter
94. window this folder has been associated with the _MCM_ Pipeline line segment in the ProActive database From the point of view of graphing readings data this means that in this example we will be graphing reading values associated with test sites that populate the _MCM_ Pipeline line segment assuming that each relevant reading template has Graph this value in the Summary Folders selected as discussed in Section 12 1 To graph such readings you would click on the highlighted Graph page tab on the window shown below followed by clicking on the highlighted Graph button 393 ad VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models ES Surveys Atmospheric Errors 1 5 Templates Compliance Flagging Pipeline Location Start Series v EndSeries _MCM_Pipeline M Start Station 207 67 End Station 389 52 Voltage V o 5 250 00 300 00 350 00 Station Pipe to Soil ent Year over Year Diagnost Actual data points are displayed on the graph by checking off the highlighted Points box on the above window The above graph was generated using the Current data associated with the test sites that 1s the latest readings data as indicated by the highlighted Current page tap on the above window bottom left Also Pipe to Soil On Off data are shown on the graph f
95. with the line segment and it would not have a bearing on the locations of the facilities as overlaid items on the pipeline The particular facility types that are overlaid on a map are controlled via a User Preferences selection accessed via the View menu View User Preferences Graphing The facility types to be displayed will be those checked off in the Display Facilities field shown below 111 User Preferences Display 3D Display Station Mumbers Display Points Display Info Month Day Logical ear Begins m T Auta Graph Pipeline Surveys w Display Line Cursor Gap Invalid Readings E Display Facilities v Coating Transition Compressor v Flange v Rectifier Adjust Icon Display By checking off the box labeled Adjust Icon Display icons representing facilities that are at the same location or at closely spaced locations will be displaced on the map for clarity This prevents icons from being hidden behind other icons Label The type of labeling to be associated with an overlaid device icon on a map can be selected by clicking on the menu button in the Label field The menu options are as follows Name The name of the facility shown in the database tree will be used as the facility label Distance The station number of the facility will be used as the facility label None No facility labels will be shown on the map 112 Compass By checking off the box labeled
96. x Cancel window shown below will be displayed x Company Logo e Print Current Margins Print All Pages f Print Custom Margins Feet Per Page Humber of Pages o qp Feet Per Label Divisions Per Label Start Series End Series wt Start Station End Station H 0 00 5250 00 A previously selected company logo can be applied to a printed asset map with the Company Logo box checked on the above window To make available a company logo image use the following procedure First click on the View menu and then click on Application Settings and then General The window shown below will be displayed 198 Company Details M arme Risk Avere Gas Company Logo S F General Graphing Pipeline Surveys AtmosJ Sas User D4 Unit Preference Imperial Metric DOT Compliance Enable Compliance Testing Survey Settings Penodic Survey Annual Structure Sail Defaults Negative Voltages Instant Woltages Next click on the highlighted by the red arrow icon the above window This will result in the Image Selector window being displayed as shown below x Cancel By clicking on the Load button on the above window a previously saved JPEG image file can be selected a company logo image file for future use 199 in asset map printing applications or in any Gr
97. you d like to resite the pipeline of the Compressor Station to that of the line segment into which you dropped the Compressor Station Next you should enter a station number to represent the location of the facility the location of the Compressor Station You can also enter other relevant location information on this page that will describe the physical location of the facility In addition you can enter Driving Directions to the facility on this page which will be downloaded to a data logger or created on an Excel spreadsheet for any test sites devices that are housed in the facility Note Devices test sites that are housed within the facility see below will automatically be assigned the same location data as the facility which will appear on the location pages of their Details Forms One difference however 1s that the housed devices will not be assigned the station number entered for the facility Rather you will be given the opportunity to assign an ID number to each housed device on its location page How to House Devices in a Device Station To house a device test site inside the Compressor Station our example you would right click on the Compressor Station node left click on Create Node and then left click on the first Device you d like to house In our example the first device type 1s a Valve Once you have entered a name for this device in our example the name would be Valve BI and clicked
98. z 4 Remove Report Details w ke CIS Off W Negative Threshold Line W DCVG Survey Data iw DCG Percent Data Iw DCYG Percent Report Group CIS Data Left Axis Voltage From Automatic Fight Axis To Date x Cancel Vertical Sees From Date To Date Fields These fields can be used to restrict the date range for data to be included in a report for each Group Otherwise ProActive will use the most recent data of each selected type to generate a graphical report 5 Click on the OK button which will save the graphical report format that you ve designed 129 6 3 How to Generate a Report using a Saved Graphical Report Format including a standard CIS Exception Report 1 Click on the Reports speed button main menu bar 2 Click on the Graphical Reports radio button 3 Highlight the Generate Graphical Reports option 4 Click on the Report button 5 Click on the menu button in the Report Name field and select your report format name 6 Click on the menu button in the Pipeline Location field and select your pipeline name 7 Enter starting and ending station numbers for the section of pipeline upon which your report will be based 8 Click on the Graph button and click on the No button on the What If confirm window if it appears Note If you do not want to
99. 03 2584 78 2706 75 EMPLEO 6 17 2003 2694 79 2706 79 Curent Wapper MLZTK 1996 b 28 2003 2694 70 27 b5478 M2TK 2024 DCYG 6 17 2003 2584 78 2706478 Depth of Cover 2 1836 b 28 2003 2694 70 2705 78 GPS right of way M2TK 2024 GPS 6 17 2003 2694478 2706 78 2 1335 b 20 2003 2584 78 2706458 Sail Resistivity ML2TK 1996 b 20 2003 2584 78 2706478 _ICDA Line 1 _ICDA Line 2 _ICDA Line 3 _ICDA Line 5 T E Ed BH Next right click in the window select Group and select Join The CIS and GPS surveys will be grouped as indicated the window below 4 Pipeline Survey Editor Survey Selection Graph Pipeline Start Series End Series _ Franks Line E tart station nd station Franks Li Start Stati 2694 fo End Stati 2706 fo Pipeline Jo ate Start End _ FMM Line North 1 Line E Franks Line Altitude ML Alt b 28 2003 2584 78 2706 75 Curent Wapper 2 1996 b 28 2003 2694 70 2706 70 D CVs MaTK 2024 OCG 61772003 2584 78 2706478 Depth of Cover MLZTE 1996 b 28 2003 2584 78 2706478 Pig ML2TK_1996 b 20 2003 2584 78 2706458 Sail Hesistivity 1996 b 20 2003 2694 78 2706478 ES MeTE_2024 6 17 2003 2534 78 2706478 GFS right of way M2TK 2024 GPS B AU03 2584 78 2706478 _ICDA Line 1 ICDA Line 2 _ICDA Line 3 ICDA Line 5
100. 2 18 07 105KB JPEG Image 6 17 2010 9 53 Flo 05 10 2010 12 18 06 989KB JPEG Image 6 18 2010 11 0 05 10 2010 12 21 13jpg 1013KB JPEG Image 6 18 2010 11 0 05 10 2010 12 22 52 pa 893KB JPEG Image 5 10 2010 12 2 4 Camera icons corresponding to these image files shown below overlaid on a graphical presentation of the CIS data Survey Readings 1 17 DENEN T D EET IEEE Lifts 1 16 CIS DATA Z Ea EI 145 ES co 2 So S 1 i 1 CT mp cn m cn DE zie hal P D AM RA R3 H bo Ex RJ m cac ca c m c FF tus Is 2 1 12 tn lin li pe p tn p o n gE ES 18 2 L3 3 860 3490 4 00 As can be seen from the above graph one of the photographic images was recorded in association with a test point located at station number 4 05 and the 1mage file data 1s also accessible via the test point s Details Form as shown in the window below 84 4 05 Single Test Station Details Form Single Test Station DCP FRE rag rop File Organizer iri 1 D amp D File O Folder JPEG Image 5 2 Survey Data Menu Options including CIS Exceptions Report Generation amp Relative Re stationing using GPS Data A menu of useful functions is available in the Pipeline Survey Edit
101. 2 2 Oena O das 191 9 223 OVOF AVS ents 193 6 0 Prin nsan ASset ean e d OU 197 SECTION 1 HOW TO ORGANIZE YOUR PROACTIVE DATABASE 1 1 Database Tree Folder Types There are two gateway folder types that are used in the database tree The Regular Folder and the Line Segment Folder Regular Folders are typically used to represent your company as a whole as well as to represent any major divisions and or areas in your company You can also represent individual customers if you are a contractor for example with these types of folders In addition pipelines themselves can be represented by Regular Folders in cases where pipelines are sub divided into various line segments Line Segment Folders are typically used to represent sections of a pipeline but can also be used to represent whole pipelines At the line segment level various 1cons known as Facility 1cons are used to represent various entities that are associated with the line segment including Devices test sites at which data are collected such as Test Points Test stations Rectifiers Bonds Insulated Flanges Valves etc Database tree development see below is basically the process of creating folders and Facility icons in order to represent the physical layout of your pipeline system or systems Once your database 15 organized you can associate your pipeline surve
102. 6 17 2003 survey in the above example Next click on the Graph button which will present the window shown below 69 ad Franks ML2 Line Summary Folders Templates Compliance Flagging Information Remedial Items To do List Models Graph Surveys Atmospheric Errors ES Fipeline Locatian Start Series End Series Franks Line Start Station 2694 78 End Station 2706 77 Depth of Cover Surveys a hele 2024 6 17 2003 Soil Resistivity Surveys UE mem it Ix Graph CIS Surveys 2T 00 00 Station M2TK 2024 Voltage V 12 29 2010 10 40 58 AM Note If devices locate the starting and ending points of a survey 1 there was a Data Collection Point DCP at the start and at the end of a survey or you incorporated Landmarks in the database tree the starting and ending station numbers will be identified automatically on the above window By double clicking on Start Station or End Station you can view milepost values rather than station number values You can also restrict the station number range to only view a portion of the data by entering values for the start and end station numbers that are within the overall station number range At this point you can view the graph in a variety of ways For instance by checking the Info box you can view all of the Devices including DCVG Anomalies as well as all of the Geo Features that were designated dur
103. ATE FOR EACH READING TYPE SELECTED Including setting up Flagging criteria 263 5 2 How to Modify Standard Reading Templates 265 5 3 How to Modify Reading Templates on a Test Site Basis 278 Continued Over leaf 203 5 4 How to Modify Reading Templates via Summary Folders 286 SECTION 6 HOW TO MANUALLY INSERT HISTORICAL READINGS DATA 292 SECTION 7 HOW TO CREATE A ROUTE VIA ROUTE MANAGER Including use of Filter function amp application of DOT Compliance criteria 297 SECTION 8 HOW TO COLLECT DATA ON A ROUTE 8 1 How to Use an MCM Data Logger 324 8 1 1 How to Download Route Data to a Data Logger 324 8 1 2 How to Post Test Site Survey Data from your Data Logger to ProActive 328 9 2 How to Use the Manual Data Entry Capabilities of ProActive 331 8 2 1 Excel Spreadsheet Generation Method 332 02 2 Direct Data Entry Method se ERE FRU ES 347 SECTION 9 HOW TO POST REMEDIAL ITEMS AND REPAIRS TODOTTEMS rrecn a mia os o Fares 355 SECTION 10 HOW TO REVIEW POSTED TEST SITE SURVEY DATA VIA ROUTE MANAGER 360 SECTION 11 HOW TO GENERATE TEXTUAL REPORTS BASED ON TEST SITE DATA ILI IntfOGUCUOD tr bla
104. B1 3847 0 0106 0 hu 46 The above screen displays the first 22 sets of readings for the example DCVG survey The first column far left hand column lists the DCVG voltage data which were obtained by subtracting the delta V OFF values from the delta V ON values The delta V ON voltages are presented in the second column from the left which is labeled as DCVG Voltage ON data while the delta V OFF voltages are presented in the third column from the left which is labeled as DCVG Voltages OFF data An anomaly location is indicated in the above window at the number 18 data row and is labeled as a DC VG Anomaly This means that an anomaly was marked at this location as described in our DCVG Surveys Training Manual The DCVG Anomaly is noted in the column that also lists Devices and Geo Features More details on this anomaly and all other anomalies marked during this example DCVG survey can be viewed by clicking on the Device Readings page tab as shown below In addition voltages recorded at conventional Devices such as test stations are also shown in this window lll DA Meter Driver Pipeline Survey BEE Download Survey Settings Readings Readings PLS Graph Station DCP Feature DCVG Anomaly Latitude O2694 E Single Test Station Pipe To Sail D CV Anomaly D CV Anomal DCVG Anomaly D DV Anomaly D OVI Anomal D CV Anomal D DV Anomaly D CV Anomaly
105. Channel Options Help lt lt Back gt gt In addition the Reading Style can be selected by clicking on the menu button in the Reading Style field For our Rectifier Volts reading type example the Single Value option was selected as opposed to one of the On Off Pair options Clicking on the Next button will pull up the window shown below Reading Configuration Wizard Configuration Settings For F ectifier Vals Survey Types Annual Bi monthly Special lt lt Back 269 The above window allows you to assign the reading type which in our example is Rectifier Volts to particular test site survey types that you plan to conduct Typically you will perform Annual and Bi monthly site surveys and perhaps a Special survey which could be a semi annual test site survey every 6 months for example If you require that a particular type of reading be taken at a test site on all of your survey types Annual Bi monthly and Special you would check off all survey types in the above window However if you want a particular type of reading to be taken at a test site on Annual surveys only for example you would check off only the Annual option on the above window For instance you might want to record Rectifier Volts and Rectifier Amps at your rectifier test sites on annual bi monthly and special test site surveys but you might want to only recor
106. Co E North District 3 E Noth 1 Line 11 Section BE Rectifier Test Point 41 Bond 4 Galvanic Anode A Test Point 2 t3 Section B um Compressor Station B vases Test Point 1 Bi Rectifier B Bond B Ek span valve 82 Test Point B2 fu Section c i Station Test Point C1 Flange BE Rectifier Bond c Coating Transition C Test Point C2 e North 2 Line E South District 240 SECTION 4 HOW TO SELECT THE TYPE OF DATA YOU REQUIRE TO BE COLLECTED AT EACH TEST SITE 4 1 Introduction For each device test site your database tree 1 for each entity for which data are to be collected you can select the types of readings and the types of visual observations known as atmospherics in the case of above ground devices that you require to be collected on a route In the case of reading types an options list is provided ProActive for each device type based on our experience regarding the types of readings that are typically taken at each device type and you can make your selections from the options listed Alternatively you can create additional reading types and you can customize the specifics of the readings that are to be taken at your particular test sites The reading types and atmospherics 1f appropriate that you select or create for each device translate into Prompts for
107. Create New Route button white page icon which is the first button to the right of the Route field on the Route Manager window above The Create New Route window will be displayed and you should enter a name for your route in the field provided and then click on the OK button Create New Route I ri Enter new route name Bobs Foute X con For the example case of a route named Bobs Route the Route Manager window will be displayed as indicated below 298 Route Manager Route BosRos setup Assign History Surveys Notes Graph Audit Trail Description Devices z Include Sub route 4 Exclude Item Step 3 Select the devices test sites from your database tree that will comprise the route you are setting up You can take a number of different approaches here You can pick and choose individual devices from various line segments you can select all of the devices comprising a single line segment you can select all of the devices on a pipeline etc If you select a line segment or a pipeline you will be selecting all of the devices comprising that line segment or that pipeline Example 1 Let s say that Bobs Route is to comprise all of the devices associated with a particular line segment If this were the case you would click on the particular line segment folder in the database tree and hold down the mouse button You would then drag the
108. Include Cancel Next select the date range for the report via the calendar icons shown the above window and click on the button This will generate the report In our example line segment there are only two rectifier test sites devices as illustrated in the filtered database tree shown below 379 Bobs Filter E Filter Bobs Filter A Risk Avere Gas Sample Data South E North El vB PL9905 pu Franks SUIT SAT Using our example report format the report generated in this case was as shown in the spreadsheet below A B G D G H l 1 Name Description Pipeline Station Survey Date Rectifier Volts On Rectifier Volts Remark Rectifier Amps On Rectifier Amps Remark 2 MCM_1 Rectifier Franks Site Dev Specific processed _MCM_Pipeline 207 87 9 10 2004 9 234 Contacts good 19 123 Shunt OK 3 MCM_1 Rectifier Franks Site Dev Specific processed _MCM_Pipeline 207 87 9 23 2005 9 345 Cleaned Contacts 19 456 Shunt Replaced 4 MCM_1 Rectifier_389 32 Franks Site Dev Specific processed _MCM_Pipeline 389 32 9 10 2004 23 45 7 225 5 MCM_1 Rectifier_389 32 Franks Site Dev Specific processed _MCM_Pipeline 389 32 9 23 2005 23 456 7 234 6 11 4 How to Generate a Report using a Standard Report Format 1 Click on the Reports speed button main menu bar 2 Click on the Standard Reports radio but
109. MCM_1 Test Point 22022 6 MCM_1 TestPoint_230 22 PAS MCM_1Test Point 230522 Copper 000000000000 Ln 47H data entry process would be continued until you have entered data in response to all prompts At that point you would click on the Update ProActive button to have your data posted to the ProActive database You can check to make sure that the current data were posted correctly to the database by accessing the readings history fields of the device Details Forms For example the following two windows illustrate the Readings pages for the Valve and the Rectifier devices illustrating the updates to the readings histories 352 Location Valve Headings Atmospherics Graph Time Chart Mates Audit Trail S etu Descriptions zi ij Heading Setup Pipe to Sail i 11 1 0655 0 9555 Compliance DOT Rule EE Next Reading Due 4 25 2011 Valve Test Site 353 22 Rectifir Details Form e cmm Location Rectifier Headings Anodes Graph Time Chart Mates Audit Trail Setup Descriptions Amps Volks Line Current Coarse 3 345 T 20188 Puer Mater ITE Sm Compliance DOT Aule Rectifier Test Site Note In the case of the Rectifier Amps prompt we entered the calculated Amps value 21 Amps in our example into the Rectifier Amps prompt
110. Mode field will reveal a number of choices regarding the overlaid pipeline color relative to the map color A user can experiment with the various options in order to arrive at an optimum presentation An explanation of each option 1 as follows Pipe Color Pen color specified in Color property 110 Inverse Pipe color will be the inverse of the map color Pipe plus Map merge Combination of pipe color and map color Pipe plus Map common Combination of colors common to both pipe color and map Pipe plus Inverse Map merge Combination of pipe color and inverse of map Pipe plus Inverse Map common Combination of colors common to both pipe color and inverse of map Facilities Checking off the box labeled Facilities will allow ProActive to overlay facility icons for the facilities that have been associated with a line segment Note Facility icons are displayed according to the GPS right of way data associated with their line segment which matches their stationing GPS right of way data represent Lat Long values versus Station Number When a facility has a matching station number it is assumed that the facility will be located at the corresponding Lat Long values associated with the GPS right of way data What this means is that the facilities themselves could either have no associated GPS location data of their own or they could have different GPS data different from the right of way GPS data associated
111. Name The name of the facility shown in the database tree will be used as the facility label Distance The station number of the facility will be used as the facility label None No facility labels will be shown on the map 413 Compass By checking off the box labeled Compass an orientation icon will be overlaid on the map to indicate the North direction Distance By checking off the box labeled Distance stationing will be shown on the overlaid pipeline at intervals matching those of the bottom graph axis stationing axis Feet Max Separation The manually entered value in the Feet Max Separation field will represent the maximum separation between pipeline data points for line Joining purposes 13 7 Printing an Asset Map Asset Maps can be printed directly from the Asset Map window via the Map Menu button highlighted the window shown below 2 ie QA Mazi 7 Folder Map VB PL9905 Segment i WOW IN 2644 LE 1 04 1591 1 WO 20 59 1 041581 WON WOW adig pasodx3 6 0 1ulog1s8L L WOW ys WOW pauuosay 14109 591 WOW o ju g V Wow ES i 4 Pd p di gt A uod 1591 L WOW ER gt lt 4015 Wd W a uogaafu aoydiyul WOW E o a 23 ZO 89E 1ulod
112. Negative Site Promt Dff Min Date Technician Remarks MCM IVavwe S o o o MCM 00 0000 00 MCM TReciier 000 000 00000 9 MCM_1Rectiier Line Current 000000000002 MCM IReciier Coarse Tap 0 00 00 IReciier 1 00000 MCM Power Meter 0 0000000000 MCM LReiir MCM Anode2 o oS o o o MCM 0 MCM_1 Test Poit 1 Poit Foreign PS 00000000000 MCM_1 Test Poit PAS Zine S d 0 0 MCM_1 Test Poit PXS Copper 00 00 0000 MCM_tTestPoint PAS Silver MCM_1 Test Poit Open Circuit Potential 0 MCM_1 Test Point Comet HVAC _ 0 0 0 0 0 00 MCM1Flange Pipe to Sol U S 00 2 MCM_1Flange Pipe to Sol D75 OOOO _____ MCM_1Flange Open Circuit Potential O ooo MCM_1 Flange Curent Foreign P S Single Test Station PipeToSol 00 i 4 LJr LJ Dan e 8 Pipe to Soil Pipe to Soil Off Remarks Edit values in their normal display units Propose prior remarks for new readings Head Date pemi gi M Automatic Import e As
113. Off data Consequently for each DCVG Anomaly we have the following data available upon which we can report Max mV On Max mV Max mV On and Off Remark for example Cathodic Anodic Max mV Max mV On Max mV Off Total mV WIR The key to having column headings in an Excel spreadsheet report that would correspond to the above data types is to make appropriate selections in the Ad Hoc Report Designer as described below in Section 7 3 170 7 3 How to Design and Save a Textual Report Format The specific example that ll be used here is a DCVG Anomaly report format see Section 7 2 above for data type considerations designed to report IR values and the Cathodic Anodic state of each Anomaly The procedures are as follows 1 Click on the Reports speed button main menu bar AAA Route Mgr Send Route Get Reads Surveys Srvy Editor Find Filter Templates Select the report you want to use Design New Report DG Anomaly Report Pipeline Survey Report Site GPS Report Report L ategaries Standard Reports Adhoc Reports Graphical Reports lt lt Back gt gt 3 Highlight Design New Report and click on the Next button 171 u ProActive Report Wizard Design New Report Select a route or drag drop devices Defect 5 from the database tree to base this report on Alternatively check Miscellaneous to b
114. Section E E has Line 11 Section 11 Section t Section C 11 Section D 2 Customer 2 gt Customer 3 Customer 4 Customer 5 2 Customer Next double click on the Landmark node This will pull up the Details Form window 2 Start of Section A Details Form Location Notes Audit Trail Name Start of Section A 00000000000 Milepost bo Fipeline lOll C hate Seres Ace Station 0 00 Description Pn DIB alesse Sail Type Ey Dr Latitude anm Longitde amm Town Alitude PDepn Line Litt 00 0 Installed NEN E Retired E Tech Directions The Details Form allows you to provide relevant information about the Landmark including the pipeline with which it is associated and its area location etc The most important entries here are the pipeline name which you should select by clicking on the menu button in the field and the station number which you enter manually In our case the station number would correspond to the station number associated with the start of Section A on the Oil Line You can then apply the above procedures to use Landmarks to define the beginning of each line segment in your database tree Other uses for Landmark nodes Landmark nodes can also be used for other purposes Here are a couple of scenarios that you might encounter where Landmark nodes can be usefu
115. Setup Descriptions Fipe to sail Anode to sail Anode current History gm z 00 Fipe to sail Anode to sail Anode current Soil Resistance Complance DOT Rule UNASSIGNED Next Reading Que As indicated on the above window a Soil Resistance reading type has been added to the reading type list for our Galvanic Anode example Note As can be seen from the above window when you first create a new reading type in the above fashion the new reading type will be highlighted in red rather than in blue The red highlighting 15 to indicate that your new prompt is currently not pointing to a specific reading template see below for information on how to point the reading type to a specific reading template The next step would be to view the reading template currently associated with a Soil Resistance reading type to make sure that the template 15 suitable for your reading type You would initiate this process by clicking on the Reading Setup button highlighted on the above window This will pull up the Reading Configuration Wizard 249 Besos Wer Lait Configuration Settings for 5011 Resistance Select Template to edit or enter new template Revert ta Han LInique Template Settings Current Settings gt gt Click on the highlighted menu button to view the list of reading templates currently available in your version of ProActive As can be
116. Summary Folder or a Line Segment Summary Folder by double clicking on the folder icon or on the folder name Next you would click on the menu button in the Segment of Pipeline field and highlight the pipeline with which the segment is associated If the pipeline with which you d like to associate the segment 15 not listed in the drop down menu you can click on the page icon button at the far right of the Section of Pipeline field and enter the name of the pipeline of which the segment is a part in the Create New Line window that appears The Summary Folders window for this example 1s shown below d Section Summary Folders Templates Compliance Flagging Information Remedial Items To do List Models Graph SUV ES Atmospheric Errors Mame Section Segment of Pipeline Line ee Sort Hotes T Drag amp Drop File Organizer Folder Name Modified As indicated near the bottom of the above window you can also drag and drop files such as Word documents and CAD files into the information page of a Summary Folder which allows you to associate previously gathered information relevant to the line section in our example with this node in the database tree As pipeline survey data are associated with your various pipeline sections these data will also be available for viewing via any higher level Summary Folders since your database tree is c
117. Survey Info Test Overlay P OK As indicated above the CIS survey has been identified as the reference survey and the Static survey has been identified as the target survey Clicking on the bi directional arrows button will reverse these assignments The target survey name is automatically modified to be the original name plus Snap and the new name 15 associated with the re aligned survey once the re alignment process has occurred Should a different name be required to be applied to the re aligned survey that name can be entered in the New field on the above window For example Re aligned has been added to the original survey name in the window shown below 977 nap Survey using 4 Reference Survey Target Survey Type CIS Type Static Jab TownA B CIS Jab TownA B Static Date 5 13 2010 Date 2 25 2010 Mew Static Re aligned Snap Parameters 100 feet feet 200 x 30 Ea hi aximum Distance fram Target to Reference Paint 4 Maxinium Perpendicular Distance fram Pipeline aximum H atia of Station Distance to GPS Distance 4 Minimum RH atia of Station Distance to GPS Distance Respect Position of Known Stations d Add Snap to Survey Info Test Overlay P OK As indicated on the above window a number of parameter values have been selected by default These values can be changed based on user requirements The re alignment snap process 1
118. TRAINING MANUAL FOR THE SINGLE USER VERSION OF PROACTIVE January 2011 A MG MILLER Co M C Miller Co Inc 11640 U S Highway 1 Sebastian FL 32958 CONTENTS SUMMARY PART 1 HOW TO MANAGE PIPELINE SURVEY DATA Pages 3 201 PART 2 HOW TO MANAGE TEST SITE DATA Pages 202 418 1 HOW TO MANAGE PIPELINE SURVEY DATA PART 1 CONTENTS SECTION 1 HOW TO ORGANIZE YOUR PROACTIVE DATABASE pad B WN SECTION 2 HOW TO COPY SURVEY FILES FROM A DATA LOGGER TO A LOCAL FOLDER ON YOUR PC 2 1 2 2 Maniall 2 3 Using a Data logger Driver in ProActive SECTION 3 HOW TO BRING SURVEY DATA INTO THE PROACTIVE DATABASE 92 95 How to Bring Survey Data into ProActive directly from 3 3 to Bring Survey Data into ProActive from Data logger File saved in a Local Folder on your PC 3 4 Howto Import Survey Data from Excel Spreadsheet XLS WinCIS and XML Continued Over Database Tree The As Received How to Backup Database
119. Threshold 0 85 Date 1 28 2011 Upper Anomaly Threshold 2 34 lt lt Back gt gt By clicking on the Next button on the above window after having provided the required survey information the window shown below will be displayed The above window shows how the Import Wizard will interpret our PCM survey data 64 The data are shown in more detail in the window below 51 03750 2694 78 230 5 2595 78 226 1 2696 78 215 2697 76 219 2 2638 78 217 2633 78 211 4 2700 78 2117 2701 78 213 8 2702 78 185 2 2703 78 178 5 2704 78 177 3 2705 78 176 8 2706 78 177 By clicking on the Finish button at the bottom right hand corner of the above window our example PCM survey data will be imported to ProActive and will be associated with the North 1 Line pipeline Note Additional imports can be performed following the first import prior to the data being posted to the database In addition a group or batch of imports can be created and the imports can be processed by ProActive via a Batch Run which is a useful productivity tool To add an import to a batch click on the button located at the button of the import wizard window as opposed to clicking on the Finish button 65 Pipeline Survey Import Wizard Below is view of how the Import Wizard wall interpret your survey data Click Finish ta Integrate the data inta Proactive Click Back to change the survey
120. a j 7 ui 2 mer id ul diao 4 e 9 NE RHE RSM 5 2 E o o ajn IH sc Jeu malg 1 3 nma SAER C aaas J E abe geg Wim gt La L s a JUS Y uel 400 13 3 Database Tree Folder Option Right click on a database tree line segment folder the VB PL9905 Segment folder in our example and left click on the Map Folder option on the right click menu An asset map for the selected folder will be generated automatically as indicated in the example below Folder Map VB PL9905 Segment 3 Duis M uogaafuj AOWGIYUI L WOW E puog L WOW KON 7 2 ES adig pesodx3 WOW 0 1 041581 WOW o 2auuo28H WoW i abueJ E zauuoIay 40 59 1 044691 WOW 1 WOW Ee 5 1 al 8 Bow S e Q mu T 5 am afes WOW 0 iod won gt LA lt vL 222 6 04 1 041681 WOW te 0 89 1 041581 WOW p gt CE 68E 4 WOW we ul 4 e S Bui duues 1816 AA v A ag gt
121. abase illustrates the concept of a Database which is similar to a Family Tree The top node of the tree this example is a folder representing the Gas Company itself Risk Averse Gas Co The Gas Company has one main node branch coming from it namely a District called Harryville If there were other Districts assigned to the Risk Averse Gas Co there would be other nodes folders positioned at this same level The District of Harryville has 2 main Areas namely Harryville South and Harryville North and these are represented by folders nodes positioned one level down from the Harryville District node Finally the line segments Marks Line Risky Line and Test Harryville South Area and Franks ML2 Line Harryville North Area are represented by folders nodes positioned one level down from their respective Area nodes As be seen from the above window all nodes above line segment level are represented the database tree by regular folder icons while line segment nodes are represented by a special folder icon having a blue line step like line through it Prior to designing your own database tree to suit your own requirements see below it is highly recommended that you back up save the As Received database see Section 1 3 below By backing up this database you can at any time Restore 1t 1f you run into difficulties and you need to begin from scratch or if you would like t
122. aid on an asset map are controlled via a User Preferences selection accessed via the View menu View User Preferences Graphing The facility types to be displayed will be those checked off in the Display Facilities field shown below 195 User Preferences Display 3D Display Station Mumbers Display Points Display Info Month Day Logical ear Begins m T Auta Graph Pipeline Surveys w Display Line Cursor Gap Invalid Readings E Display Facilities v Coating Transition Compressor v Flange v Rectifier Adjust Icon Display By checking off the box labeled Adjust Icon Display icons for facilities that are at the same location or at closely spaced locations will be displaced on the map for clarity This prevents icons from being hidden behind other icons Label The type of labeling to be associated with an overlaid facility icon on a map can be selected by clicking on the menu button in the Label field The menu options are as follows Name The name of the facility shown in the database tree will be used as the facility label Distance The station number of the facility will be used as the facility label None No facility labels will be shown on the map 196 Compass By checking off the box labeled Compass an orientation icon will be overlaid on the map to indicate the North direction Distance By checking off the box labeled Distance sta
123. al ear Begins m T Auta Graph Pipeline Surveys w Display Line Cursor Gap Invalid Readings E Display Facilities v Anomaly Bond Coating Transition Compressor Flange Rectifier Sleeve Span Test Point hs Assets Right Click Menu By right clicking on an overlaid facility asset icon on an asset map the facility can be either located the database tree via the Locate option or can be opened via the Open option The Open option also locates the facility in the database tree addition to opening the facility s Details Form in the case of a device or the facility s Summary Folders in the case of an entity such as a compressor station for example For example by right clicking on the test point device labeled MCM_1 Test Point on the asset map shown below see red arrow and selecting the Locate option the device asset is highlighted in the database tree within its line segment folder By selecting the Open option the device s Details Form is presented as indicated below in addition to the device being located the database tree 405 vB PLTEP Segre X ry HEH 1 Roc 1 m HCM Dv ue edic ETT lli Sine Test Station Qn lili HEH T Ten Poen hod PN EE 7 a Br T Rz HE 59 PE E 1 m Er v Lom
124. all reading types throughout the database that utilize that template This would be analogous to modifying a standard reading template as described above Section 5 2 5 4 How to Modify Reading Templates via Summary Folders You can modify a reading template on the basis of Summary Folders For example if you had a number of rectifiers associated with a folder perhaps a regional folder or a divisional folder located in the database tree you could modify the Rectifier Volts reading template and have the modified template applied automatically to all Rectifier Volts reading types associated with the specific folder in question Such a modified reading template 15 known as a Localized reading template To do so you would first double click on the folder node in question located in the database tree which will pull up the Summary Folders window 286 Compliance Flagging Models Graph SUV ES Atmospheric Errors E Drag amp Drop File Organizer Folder RU Name Next click on the highlighted Templates page tab which will pull up the window shown below 287 Test Area Summary Folders Information Remedial Items To do List Risk Models Graph SLU ES Atmospheric Errors CS Compliance Flagging GS Re Apply Local Show Unique E Next you would click on the highlighted Add Local button and select the reading templ
125. anomalies Note A map can only be generated if GPS right of way data have been associated with the line segment a Right click in the empty Report Details field select Add Group and enter a name for the first group in the Create New Group window for example b Repeat step 3 a to create a CIS group and name it for example CIS Data 113 Repeat step 3 a to create a DCVG Survey group and name it for example DCVG Survey Data d Repeat step 3 a to create a DCVG anomaly size group and name it for example Percent IR Data Note You can arrange the top to bottom order of the stack by dragging and dropping the group names to produce your preferred order For the group top to bottom order indicated above the Report Details field will be as shown in the window below Graphical Report Designer Report Babs Report Format 373 New E Remove Report Details CIS Data DOG Survey Data Percent Data Report Group EE Lett Axis From D ate Automatic Fight Axis To Date x Cancel 114 4 The next step involves selecting entities for each group the specific entities being dependent on the nature of each group Continuing with the above example a Right click on the Map group name and select Add Entity Next click on the menu button the Pref Constants field select WebService
126. ap with one pipeline colored yellow and the other pipeline colored red Entire Database ME Folder Map wW mr Sn 00 4 84 2 2d f AES WD v E Laclede C2 2 4 gt gt 2 2 1 cm gt gt M 7 N 38 10 gt gt 12 Maile to Patterson 13 2 14 N 16 2 N 17 Brown ta Humes 22 N 18 2 18 west Spur 20 gt 24 880 Line ma Cd P id ror ail 1 m 194 Mode Clicking on the menu button in the Mode field will reveal a number of choices regarding the overlaid pipeline color relative to the map color A user can experiment with the various options in order to arrive at an optimum presentation An explanation of each option 1 as follows Pipe Color Pen color specified in Color property Inverse Map Pipe color will be the inverse of the map color Pipe plus Map merge Combination of pipe color and map color Pipe plus Map common Combination of colors common to both pipe color and map Pipe plus Inverse Map merge Combination of pipe color and inverse of map Pipe plus Inverse Map common Combination of colors common to both pipe color and inverse of map Facilities Checking off the box labeled Facilities will allow ProActive to overlay facility icons for the facilities that have been associated with a folder The particular facility types that are overl
127. aphical Report printing applications Returning to the Graph Printing window and clicking on the Preview button the window shown below is presented for the case of our example asset map and example company logo VB PL9905 Segment T 2 5 22 puo wow 1 ES F pelea 1 add pasodg 4 N bw a cs E TNAM V o LER 41e Wod BaL NO YI E J Won Bir X 222 121 1 Wo T WOW E ZU oW FE od 1581 1 z 1 041 Az 7 HEU PUET 04531 27 vt HOS 35 Di M V E TEHHSE 1 4 a em US M X gt 0 amp iuto 5 E N 22 5 aO em ras que Y s TM 22 Buydwes 1 ES N x Am zt b D eo E 2274 MR Note The positioning of the company logo image the printed map adjusted via the radio buttons in the Company Logo field on the Print Graph window The logo image in the above example top right location corresponded to the radio button selections indicated in the window shown below 200 Options Print Current C Print All Pages Print Custom Page Setup Feet Per Page Feet Per Label Stark Series Star
128. ase this report on other ProActive data such as a Pipeline Survey Report Based t Devices from the Tree f Devices in a Route Report sites in the order shown above C Miscellaneous lt lt gt gt 4 Click on the Devices from the Tree radio button and drag and drop any device site from your database tree into the empty field the specific device that you drag and drop doesn t matter as you are only designing a report format at this time you are not actually generating areport Next click on the Next button 172 u ProActive Report Wizard Design New Report Select a restricted date range if required Use Hestricted Date Range Fram oe EI To mi 5 You can select a data range for the report at this time however since you are creating a report format it makes more sense to be prompted to enter a date range when generating a specific report using a saved report format and consequently checking off the Use Restricted Date Range box 16 not required at this point Click on the Report button 173 ad Drag drop ad hoc Database ltem Information ree Dropdown List Contents Pipeline Survey Surveying Equations To do list information Remedial Item information Eror tem information Flag item information Folder Information DB Integrity Rules Data ltem Constraint Descen
129. at which data are collected Data could be voltages read directly by a data logger visual observations associated with above eround device atmospherics or parameters measured by special instruments such as water sampling instruments for example Device Stations Device Stations are entities that physically house Devices Compressor Stations and Meter amp Regulator M amp R Stations are examples of Device Stations 223 Special Feature Elements Special feature elements are entities that are important to your description of a line segment For example a Landmark can be used to describe right of way feature such as a fence or a railway crossing on a line segment Another example is a coating transition entity which allows you to note the location on a line segment of a transition between one type of coating and another type of coating Data are not collected at special feature elements however you might want to include such entities on your line segments in your database tree in order to assist with the overall description of your pipeline system 3 2 How to Populate Your Line Segments You can populate a line segment with facilities by first right clicking on the line segment node in question and then left clicking on Create You would then select by left clicking an entity from the list of currently offered entities shown in the column that appears on the far right hand side o
130. ate you d like to modify on a localized basis Next you would click on the Edit Local button and modify the template as described above in Section 5 2 via the Reading Configuration Wizard The Current Settings field for an example reading template Rectifier Amps that was localized 1s highlighted in the Template Configuration Wizard window shown below 288 Reading Configuration Wizard I Configuration Settings for Amps Select Template to edit or enter a new template name Rectifier Amps to Non niue Template Current Settings Localized 193 Test Area Heading Template DOT required reading Single Value 0 5 range 400m DC Direct Current at Sing 10 Mohm impedence gt gt How to Revert Localized Templates back to Standard Templates By clicking on the Templates page of a folder s Summary Folders any reading templates that have been established as Localized templates will be displayed in the field labeled Reading Templates Local to this Folder as illustrated below 289 ad Test Area Summary Folders Information Remedial Items To do List Risk Models Graph SLU ES Atmospheric Errors CS Templates Compliance Flagging Reading Templates Local to this Folder rs Edit Local i t Delete Local GS Local Show Unique E By highlighting a Localized reading template
131. atitude Longitde mm Town Atitude lgrment e 02 Installed NEN E This facility on other pipelines Retired Tech EE Directions Site iz 500 yards South of the State Haad BU LIS1 intersection on the West side The first step is to open the entity specific page of the Details Form which in this case is labeled as Rectifier by clicking on the Rectifier page tab The window shown below will be displayed 243 Rectifier A Details Form Location Rectifier Readings Anodes Graph Time Chart Mates Audit Trail Headings Line Current INC Pipe to Sail Copper Sulfate Coarse Silver Chloride Fine Amps Power Meter w Volts Manufacturer Serial Number Contact Phone Humber 00000 Rectifier Type Starck Rating Transformer Phase Coarse S Fine As can be seen from the above window the Readings field contains a number of different reading types from which you can select your choices The specific reading types that will be listed in this Readings field will depend on your particular version of ProActive Your specific selections of reading type made here should reflect the readings you plan to take at this particular rectifier Note 1 This would also be a good time to enter important information about the rectifier for your future reference on the Vendor Fuses Power Company Coordinatio
132. be highlighted as indicated in the window shown below 60 Drag each button onto t comenponding column Next when all the columns you wart have heodeg Dick Back to select a NS You must select s Dintance and Cunert column to proceed Dutence E Emen Ex nenas E mese En fV 7192 211 4 2117 71210 185 2 170 5 177 3 176A c lt lt Back gt gt By clicking on the Next button at bottom right of above window the window shown below will be displayed Survey Import Wizard Fill in the Job and Survey Information You can drag in a tree device to set Line and Location Click Nest to Preview the Wizard s interpretation Click Back to change the column headings Jab Surveu Informatio Distance Ret Line Create Curent Anomalies 7 Station Direction Lower Anomaly Threshold 0 85 Date Upper Anomaly Threshold 2 34 lt lt Back gt gt 61 data fields presented on the above window used to provide identity for the survey data and to allow ProActive to post the data to an appropriate line segment in the database Job field Enter a descriptive name for the survey in the Job field for example Section A 2011 Note It is not necessary to include the survey type for example PCM in the job name as the survey type
133. bsence of Landmark nodes it would not be possible to associate survey data with a line segment node in your database tree In such a case you could create Landmark nodes inside of a line segment node to represent the start and the ends points of the survey 2 Devices are not registered during a survey at the beginning and or at the end of the survey Ideally devices should be registered on the data logger at the beginning and at the end of a survey as well as at other data collection points alone the way for example at reconnection points However this might not always be possible For example a survey may be terminated at a location that is between test stations For this example you could create a Landmark in the tree to represent the end location of the survey Note In order to view all survey data covering the first station number through the last station number via a line segment or higher level summary folder you must have devices that represent the first and the last locations on the survey In other words devices must bracket the survey in order that the whole survey can be viewed via a summary folder see Section 4 35 SECTION 2 HOW TO COPY SURVEY FILES FROM A DATA LOGGER TO A LOCAL FOLDER ON YOUR PC 2 1 Introduction This section pertains to our Windows based data loggers only for example DA Meter Gl G7 and Gx data loggers survey data are stored independent files one file for each
134. can be either located the database tree via the Locate option or can be opened via the Open option The Open option also locates the facility in the database tree addition to opening the facility s Details Form in the case of a device or the facility s Summary Folders 1n the case of an entity such as a compressor station for example For example by right clicking on the test point device labeled MCM_1 Test Point on the asset map shown below see red arrow and selecting the Locate option the device asset is highlighted in the database tree within its line segment folder By selecting the Open option the device s Details Form is presented as indicated below in addition to the device being located in the database tree 188 vB PLTEP Segre gt 1 5 BC HEH 1 Roc 1 ACTAE GR E T e gut o T lik Sire Station m Qn lili HEH T Ten Poen hod PN T i EE ow eae I eee EA 5 2 3 OBIM fe zNSCE Cu 74 a 25 tir DE 2 EVI m zm LES 2 E ii EN gt 2 S RO o Wi 5 i E EY E 2 amp n za e F x E L3 amp 5 CES Do xm e a 8g z E SM e 75 45 is i M ME E oe X E g E S ger h er mon B o 4 B X rs ite Au E I a v
135. cation SECTION 5 HOW TO VIEW AND EDIT YOUR SURVEY DATA USING THE PIPELINE SURVEY EDITOR The Pipeline Survey Editor is an extremely useful tool that allows you to view and or edit your survey data As mentioned previously you can use the Pipeline Survey Editor to view survey data even in cases where data 78 were not recorded at DCPs during surveys and or Landmarks were not incorporated in the database tree 5 1 How to View Survey Data via the Pipeline Survey Editor First click on the Srvy Editor button highlighted below on the ProActive menu bar e M C Miller ProActive File Edit View Tools Advanced Window Help g Route Mgr Send Route Get Reads Survie Filter List Mgr Templates Reports A table such as that illustrated below will be presented The specific details of the table will depend on the pipelines comprising your database and the pipeline surveys that have been performed on those pipelines ud Pipeline Survey Editor Pipeline Start Series End Series Start Station End Station 3 Pipeline Date Start End Lire North 1 Line Franks Line ICDA Line 1 ICDA Line 2 ICDA Line 3 ICDA Line 5 ICDA Line ICDA Line Marks Line 5 9102005 4052 000 5 9102005 METK 6 17 MCM_ Pipeline Rizky Line Hon Line 1 l You can organize the above table to suit your own requiremen
136. clude Iw Prompt when run Show SOL query text f Click on the Rectifier Amps plus sign and check off the Rectifier Amps On and the Rectifier Amps Remark boxes 372 Son 000000 e ZEE Quantity Injected v Rectifier Amps Rectifier Amps On Rectifier Amps Off s w Heactifier Amps Remark Technician 3 Rectifier Amps Technician amp Rectifier P S E Rectifier Volts Rectifier Volts On Rectifier Volts Rectifier Wols Remark Taerhnician Data ltem Constrain survey Date Colurnn z EX suit Descending Enable Date Constraint MULL date From Date Ignore Until Date mnm ER Exclude Include Iw Prompt when run Show SOL query text 5 Click on the Save Template button highlighted on the window shown below 373 eee Elf Device Information H ie Location Information Notes Audit Trail H Dropped file directory Technician owner Data Logger Prompts Reading Rows A eading Columns Atmos Rows Rectifier ar Band specific Test Point specs lPiesnrintinn Data Item Constrain Reading Columns Descending Show SOL query text This will pull up the window shown below Web Page F 374 Zoro i siete namali Save Adhoc Cr
137. d Pipe to Soil readings annual site surveys In such a case you could set up a reading template as discussed above for a pipe to soil reading type associated with a rectifier device and only select Annual in the above window In this case you will be prompted to take readings for Rectifier Volts and Amps on all test site surveys but you will only be prompted to take Pipe to Soil readings at rectifiers on annual test site surveys As discussed in Section 6 the Send Route Download Route feature which allows you to download your route data file to a data logger or to generate an Excel spreadsheet in the case of the manual data entry option allows you to select the type of survey you ll be performing on a particular route annual bi monthly or special in our case When you make your survey type selection on the Send Route window ProActive will automatically filter out all of the prompts reading types that do not apply to your selected survey type and only prompts that do apply will be downloaded Note You can add a Survey Type to the options list indicated in the above window by using the List Manager function To do so click on 270 Tools the main menu bar and select List Manager Alternatively you can click on the highlighted List button on the window shown below EM M C Miller ProActive File Edit View Tools Advanced Window Help a MAA AR
138. d ER 1 1 2006 1848 zFranks DOT VBPL 3 23 2005 MCM Pipeline 314422 1 Flange 1 Galvanic amp node 1 Inhibitor Injection 1 Internal Corrosion MCM_1 Offshore Rig 1 Rectifier 1 Rectifier 388432 1 5 1 Storage Well 1 Test Point MCM_1 Test Point 230422 1 Test Point 317497 1 Test Point 355407 1 Test Point 3 8 02 1 Test Point 370 922 1 Test Point 377 52 MCM_1 Tnk Tank Details MCM_1 Tnk Valve As can be seen from the above window a number of devices have been identified as being non compliant based on the particular DOT Rule used in this example The specifics on each device can be viewed by clicking on the plus sign associated with each device In addition the location of a device the database tree can be highlighted by double clicking on the displayed device icon 323 SECTION 8 HOW TO COLLECT DATA ON A ROUTE Once a route has been created in ProActive see Section 7 you can download the route information to an MCM data logger for data collection purposes or you can have ProActive create an Excel spreadsheet if you ll be performing manual data entry You can also enter data manually into ProActive either as you take the readings if you have a laptop running or at the completion of your route without going through the step of generating an Excel spreadsheet
139. d be to click on the Send Route button on the main menu bar and to select the Route for which you ll be collecting data by clicking on the menu button in the field labeled Route and highlighting your Route name Next click on the menu button in the field labeled Data Logger on the Send Route window and highlight the Manual Data Entry option Next you can select the name of the technician who will be performing the test site survey via the route by clicking on the menu button in the Technician field and selecting an existing name on the list Note You can edit the technician name options using the List Manager via the Technician Names list name Next you can select the survey type by clicking on the menu button in the Survey Type field and making your choice from the list presented Note This is an important selection since your choice in this category will determine which reading types will appear as prompts for particular devices based on the selections that were made on the Survey Tvpes page of the Reading Configuration Wizard for each reading tvpe during the reading template set up process see Section 5 For instance since we have selected Annual for the Survey Type in our example below this would mean for this example route that prompts reading types would be downloaded for all reading types for which an annual survey type was selected Prompts would not be downloaded for any
140. d on a survey graph since there is no association of the survey data with such facilities An example graph is shown below for the case of selecting the DCVG survey type and particular survey data 74 ad Franks ML2 Line Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors Ej Templates Compliance Flagging Map Pipeline Location Start Series End Series v _Franks Line v Start Station 2694 79 End Station 2715 77 Pig Surveys MEALS DCVG 6 17 2003 CIS Surveys rire dmm right of way Surveys DCVG Surveys x x cJ qA uoneaip i Wod 55012 au 9 128J8Q 9A LETIA 5 9A 9Q SajoN 2 Paad Saj N plald aas Wod 1510 15a 1 8 paler 129 8 paag OAs o og Voltage V oAOQ 4 9 5458 2700 00 2702 50 2705 00 3 Station M2TK 2024 DCVG Voltage V 12 29 2010 12 24 14 PM The above graph has both Test Point and DCVG Anomaly facility icons as overlays By double clicking on a Facility on a graph all of the pertinent information about that particular Facility can be viewed In the case of DCVG surveys ProActive treats DCVG Anomalies as Devices since they represent sites at which data are collected which 15 why they are provide
141. d with the Section B line segment in our example database tree see Section 3 Valve B Details Form Location Valve Readings Atmospheric Graph Time Chart Notes Audit Trail Name Male BZ 0000000000000 Milepost Pipeline IMathlline 8 State FL l 3 BrIes Morth District Station 52 80 Description 355 ane Ele E Soil Type pe Dr 600865 Latitude anm Longitde Town 5555 Atitude 2 ime Line List 000 Installed E This Facility an other pipelines Retired E Tech Directions 299 The first step is to access the entity specific page of the Details Form which in this case 1s labeled as Valve by clicking on the Valve page tab The window shown below is displayed Valve B2 Details Form Sele Location Valve Readings Atmospheric Graph Time Chart Notes Audi Trail Valve Info Atmospherics T fe Above Ground Ground Level Size peratar Pasition Usage Main Line Block Valve Readings At this point you would make your Atmospheric Type Data Type selections to reflect the types of visual observations data you plan to record at the Valve test site As can be seen from the Atmospherics field in the above window you have two choices regarding data type which are Above Ground and Ground Level Note 1 This would also be a good time
142. d with their own icon and why they appear in the database tree as indicated 1n our example database tree above For example by double clicking on the second from the left DCVG Anomaly labeled DCVG Defect 1 the Details Form for the anomaly will be presented as illustrated below 75 DCVG Defect 1 Details Form Location Anomaly Readings Time Chart Notes Audit Trail Name Defect 1 Milepost 51 0583 Pipeline Franks Line State series Area Name Harryville station 8 2695 88 Description Survey 2 2024 DOT Class Sail T County or Parish Latitude 38 785334 Long 91 165395 Town Alignment wl line Altitude 261 286 Depth Sheet Line Litt Installed This facility on other pipelines Retired E Tech Directions As can be seen from the above window this anomaly is located at station number 2695 88 on the Franks Line pipeline By clicking on the Readings tab of the Details Form we can view the readings associated with this DCVG Anomaly as indicated below 76 DCVG Defect 1 Details Form Location Anomaly Readings Time Chart Mates Audit Trail Setup Descriptions zi i f Reading Setup Percent V Drop ta Remote Gradient On Off History pate mul o On Off The interpretation of the above readings is as follows see our DCVG Training Manual for details
143. de This folder will represent the North District and all lower level nodes associated with the North District will eventually be contained within this folder see above hierarchical diagram Next right click on the North District node and select Create Node by left clicking on it Select Folder and this time enter the name South District Again you will be creating a Regular Summary Folder You will see that a second folder node called South District has been inserted into the database tree underneath the North District node at the same hierarchical level This folder will represent the South District and all lower level nodes associated with the South District will eventually be contained within this folder see above hierarchical diagram At this point the database tree will be as shown below 22 Entire Database North District South District Step 4 Create folders nodes for the two main pipelines in the North District North 1 Line and North 2 Line Right click on the North District node and left click on Create Node Left click on Folder and enter the folder node name North 1 Line Note If you will not be identifying sections on your pipelines your pipelines themselves should be represented by Line Segment Summary Folders rather than by Regular Summary Folders If this is your situation you would left click on Line Segment rather than on Folder during
144. der on your hard drive Create a compressed zipped version of the file Field personnel would now be in a position to send the survey file to you via email for example You would then save the file to your Local Folder see Section 3 1 and you could proceed to bring the survey data into ProActive as described Section 3 3 How to bring survey data into ProActive from a data logger file saved in a local folder on your PC Note to Field Personnel and ProActive User Do not rename the survey file as the survey file must retain the same name as the survey itself Also it is recommended that a zipped compressed file be created for survey file transmittal as an email attachment since email programs such as Outlook tend to transmit the individual files that make up a regular folder each pipeline survey folder is made up of 13 individual files which would have to be reconstituted into a single folder at the recipient s end 2 3 Using a Data logger Driver in ProActive This process would pertain if you had access to the data logger Step 1 Create a folder on your PC s hard drive or on your network system that will be used to permanently save files copied from your data logger You might choose to name the folder something like Survey Files see Section 3a d Step 2 Establish a connection between your data logger and your PC 38 Note The details of the connection will depend the data logger type
145. ding Show SOL query text HERE 6 Highlight the Device Information category and select sub categories from the Device Information major category by clicking on the plus sign which will expand the major category Example Let s design an example format for a DCVG Anomaly Report constituting IR values and Cathodic Anodic Remarks a Click on the Location Information sub category plus sign and check off the following Name Description Pipeline and Station These selections will represent the first 4 column headings from left to right in the report format Click on the Pipeline name which will pull up the Data Item Constraint field for Pipeline Check off the Prompt 174 when run box which will allow you to select a pipeline or pipelines for each report you generate when using this report format 998 Drag drop ad hoc m Drag drop Database ltem Device Information Location Information Mame Device Description Pipeline Milepost Seres M SSID Station H Area Mame State Province Parish Data ltem Constraint Pipeline Select Items to Include Uncheck all Check all Prompt when ruri Se Line Franks Line Integrity Line ICDA Line 1 North 1 Line Ie ICDA Line 2 UNASSIGNED Iv ICDA Line 3 Show SQL query text Click on the Location Information minus sign to shrink this
146. dings page 384 Ga Test Rectifier Details Form 16 5 131 14 4 eu 245 As can be seen from the above History field we have four sets of data corresponding to four survey reading dates in this example In order to plot these readings graphically you would click on the Graph tab on the Details Form and check off the Points box which will pull up the window shown below 385 Test Rectifier Details Form alal ala Test Rectifier Readings amp 12010 8 2010 10 1 2010 11 2010 12 2010 1 2011 1 27 2011 10 11 45 AM Such graphs can be edited and either printed or exported to an image file Editing The Edit button 15 highlighted on the window shown below 386 MB Test Rectifier Details Form Location Fiectifier Readings Anodes Graph Time Chart Mates Audit Trail ks 1 Test Rectifier Readings Soe pe aa A s ba oa M 59 1 2010 8 2010 10 2010 11 2010 12 2010 1 2011 1 27 2011 10 11 45 AM Clicking on the Edit button will pull up the window shown below for our particular example fae Chart zum D ates 387 number of different edits be made using this Editing feature For example the y axis could be edited to make the variations shown on the above graph appear to be less significant as follows Click on the Axis page tab on the Editing wind
147. dow This will pull up the Confirm window shown below Click on the Yes button on the above window This will pull up the window shown below Enter graph properties name Bobs Graphing Style Cancel Enter a name for the new graphing style new set of graphing properties and click on the OK button This will pull up the window shown below 143 New 7 Remove Titles Axis Legend Series Overlays Til Visible DEFAULT Prompt Font Color 1 Transparent Frame Foote Visible DEFAULT Prompt Font Color Transparent Frame Cancel Modify Properties Next click on the Titles page tap highlighted in the window shown below 144 Properties N ame Babs Graphing Style EN Private Visible DEFAULT Prompt Font Color Transparent Frame Footer v Visible MDEFAULT Prompt Font Color iw Transparent Frame Cancel Title Field As indicated in the Title field the token currently selected for the cloned style for the main title is 7 DEFAULT in which case ProActive will supply text by default As indicated in the graphical report shown below the text supplied by ProActive is the name of the graphical report format used to generat
148. dragging and dropping the Reading Templates to and from the Fired Columns bos The order af the Fised Columna will be reflected left ta night in the spreadsheet Any other Reading Templates will appear in the Other column Heading Templates Fixed Columns Hectifier Volts Rectifier Amps Atmospherics Pipe to Sail Bicarbanates Brand Calcium 1 Calculated injection rate pints per Casing to Soll Chloride MG L Corrosion Deposits Corrosion Fate Corrosion Coupon Coupon Size Current Dissolved Dissolved H25 FFM EH Check EH Probe EH Probe t Far Ground Reading Far Milepost Feels Fe5 x Final weight Fareinn Options Add Hookup Help Hint ff OK sc M cu X Cancel Notice the top to bottom order of the Rectifier Volts Rectifier Amps and Pipe to Soil reading templates the fixed templates field This order will translate to a left to right column heading order in our example spreadsheet 335 Note If the Add Hookup Help Hints box is checked on the above window and you included hookup help instructions in a reading template during the configuration process an indicator will be presented on the Excel spreadsheet and the actual help text can be viewed via the spreadsheet such a case Example Returning to Bobs Route the window shown below illustrates the devices that constitute this example route Route Manager Route ni E P4
149. e Sail Defaults Negative Voltages Instant Woltages Next click on the highlighted by the red arrow icon on the above window This will result in the Image Selector window being displayed as shown below x Cancel By clicking on the Load button on the above window a previously saved JPEG image file can be selected a company logo image file for future use 416 in asset map printing applications or in any Graphical Report printing applications Returning to the Graph Printing window and clicking on the Preview button the window shown below is presented for the case of our example asset map and example company logo VB PL9905 Segment T 2 5 22 puo wow 1 ES F pelea 1 add pasodg 4 N bw a cs E TNAM V o LER 41e Wod BaL NO YI E J Won Bir X 222 121 1 Wo T WOW E ZU oW FE od 1581 1 z 1 041 Az 7 HEU PUET 04531 27 vt HOS 35 Di M V E TEHHSE 1 4 a em US M X gt 0 amp iuto 5 E N 22 5 aO em ras que Y s TM 22 Buydwes 1 ES N x Am zt b D eo E 2274 MR
150. e this example 15 folder representing the Gas Company itself Risk Averse Gas Co The Gas Company has one main node branch coming from it namely a District called Harryville If there were other Districts assigned to the Risk Averse Gas Co there would be other nodes folders positioned at this same level The District of Harryville has 2 main Areas namely Harryville South and Harryville North and these are represented by folders nodes positioned one level down from the Harryville District node Finally the line segments Marks Line Risky Line and Test Harryville South Area and Franks ML2 Line Harryville North Area are represented by folders nodes positioned one level down from their respective Area nodes As be seen from the above window all nodes above line segment level are represented in the database tree by regular folder icons while line segment nodes are represented by a special folder icon having a blue line step like line through it Prior to designing your own database tree to suit your own requirements see below it is highly recommended that you back up save the Received database see Section 1 3 below By backing up this database you can at any time Restore it 1f you run into difficulties and you need to begin from scratch or if you would like to view the example survey data again 1 3 Howto Backup a Database You can choose which folder location on your PC or y
151. e Devices in the database that are non compliant or that satisfy one of the other selectable standard compliance related criteria can be readily located via Summary Folders by clicking on the Compliance page tab or via the Compliance indicator the clock 1con in the database tree highlighted in the window shown below 320 Entire Database 2 Risk Averse Gas A Test Area Sample Data Note The entire database is queried in the case of utilizing the Compliance indicator icon highlighted in the above window This means that all devices in the database that are currently out of compliance or that satisfy one of the other selectable standard compliance related criteria will be located Example Locating devices that are non compliant via Summary Folders This will be an example of limiting the query to devices that are associated with a portion of the database as opposed to the entire database First double click on a folder icon in the database tree perhaps representing an area or sub area to open the Summary Folders Next click on the Compliance page tab highlighted on the example window shown below 321 a VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors 1 5 Templates agging Map A Name PL9905 Segment Segment of Pipeline MCM Pipeline od D EB Sort Notes Next t
152. e surveys holding down the Ctrl key and highlighting the second survey Next click on the Graph page tab and then open the Graph Mode window as described previously By making the above selections on the Graph Mode window you can re align translate one of your surveys with respect to the other one Data Compression Stretching To compress or stretch survey data with respect to the x axis station number axis select Change Series Data Stretch X Axis and Linear on the Graph Mode window 104 Compression or stretching is done with respect to a fixed location locked position or perhaps with respect to two bracketing fixed locations two locked positions To lock a position perhaps a known reference location hold down the Shift key and left click on the data point representing the reference location Repeat this process 1f a second bracketing locked position 15 required The window shown below represents an example in which two locked positions have been established Pipeline Survey Editor Survey Selection Graph Text Notes fst Graph alal Info w Survey Readings E 81 TE 2 f 5 juu Ray Sala ca wo 1 2 e a 4 Be 1 PUIS yauyu 02 sal an piaj Sapo pia fas la pung ap va Busso m C r a en en us
153. e Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors Els Templates Compliance Flagging Map Filter wo New To do Undone Month All Station t Assigned To _ Created By Field Caption Value Pipeline Milepost SYSDBA Test Flange Repair Insulating Set Insulating Se Needs attention North 1 Line 0 3 25 2011 1 26 2011 1 26 2011 As can be seen from the above window our posted repairs to do item 1s viewable via these Summary Folders The details of the item can be viewed by double clicking on the row highlighted above You can also add new Repairs to do items perhaps based on your analysis of the test site survey data via the Do List page of any summary Folders To do so you would click on the New To do button highlighted below on the do List page 358 Test Line Segment Summary Folders Information Remedial Items Risk Models Graph Surveys Atmospheric Errors ELS Templates Compliance Flagging Map Filter wo Station Pipeline Assigned Created Device Message Field Caption Value Milepost Due Date Done Created Assigned North 1 Line UNASSIGNE You can then drag and drop the device for which you d like to generate a repairs to do item into the
154. e change does not correspond to a modification of the template and if a shunt factor change were the only change made to the template the template would not be considered unique Clicking on the Next button will pull up the window shown below 283 ad Reading Configuration Wizard 1 Configuration Settings for Amps Technician Instructions For Reading aka Hookup Helpi Help Sanu Using the above window you can enter a set of instructions text regarding how the reading should actually be taken hook up instructions If an entry is made here the instructions will be downloaded to your data logger and they can be accessed by tapping on the Help G1 data logger or Hookup Help DA Meter buttons on the prompt screens see your data logger s User s Manual If hook up instructions have been downloaded for a particular prompt reading type the data logger button would be active on the prompt screen otherwise it will be inactive Note Currently Hookup Help instructions are not accessible on the Excel spreadsheet option Finally click on the Finish button on the above window This will pull up the Confirm window shown below 284 You have made modifications to reading template for a specific device and reading Previously this reading used a standard reading template Do you wish to create a unique configuration for this particular device s read
155. e the report Bobs Report Format in this example 145 eee te NC Wo o0 Bobs Report Format _MCM_Pipeline 1 13 2011 Other recognized tokens to be filled in by ProActive upon report generation are as follows Detault Text will be supplied by ProActive User ProActive User Name Company ProActive Company Name Date Current Date Time Current Time DateTime Current Date and Time For example by changing DEFAULT to COMPANY as the token as indicated in the window shown below the graphical report is as presented below 146 Properties M ame i Graphing Style I EN Private Font Color Transparent Frame Foote Visible DEFAULT Prompt Font Colar W Transparent Frame Cancel 147 4 rJ 6 Eze jus r1 ETT m 1 fa _ Pipeline 1 13 2011 Another option regarding the main title 1s to request to be prompted to enter a title by checking off the prompt box In this case you will be prompted to enter a title for the report prior to report printing Clicking on the Font button in the title field will pull up the window shown below allowing you to change the font font style size and color for the main title 148 This OpenType font This same font will be used on both your Finally the main title can be selected to be framed w
156. e to the North District and the South 1 Line and the South 2 Line are exclusive to the South District If these lines were common to both Districts the hierarchical structure would be different Here s how to set up a database tree for this example Step 1 Assuming that you have backed up the As Received database see Section 1 3 you should retire all of the nodes up to the top node in the As Received database tree Alternatively you can leave the Sample Data folder in place and build parallel branches of the tree 24 To a node right click the name of the node or on the folder icon and left click on Retire Node Step 2 Rename the top folder top node You should rename the top folder node to be the company name in this example Vero Beach Gas Co To rename a node right click on the name of the node or on the folder 1con and left click on Rename Node Enter the desired folder node name Step 3 Create folders nodes for the North District and the South District By right clicking on the top node Vero Beach Gas Co you can select Create Node by left clicking and then left click on Folder and enter the name North District the enter name window that appears selecting Folder you will be creating a Regular Summary Folder to represent the North District A folder node will be inserted into the database tree one hierarchical level below the top no
157. each test site when you download your route information to your data logger see your data logger User s Manual for more details regarding Prompts In the case of manual data entry a field will be made available on an Excel Spreadsheet for each reading type and each atmospheric type if appropriate that you select for each test site Note A reading type data type that 1s a calculation performed by ProActive using other posted reading type data for example Groundbed Resistance which 1s Rectifier Volts divided by Rectifier Amps will not be downloaded as a prompt but should be selected as a reading type if such a calculation 1s required If a Device test site in your database has a readings page and or an atmospherics page associated with its Details Form data can be posted to such a test site as opposed to a special feature element that does not have data support 241 For each Device your database tree you should first view its Details Form to see if reading types and or atmospherics are supported ie does the Details Form have a readings and or an atmospherics page You can view the Details Form by double clicking on a device node in your database tree 4 2 How to Select Reading Types for each Device in your Database having a Readings Page For each device in your database having a Readings page you should first examine the list of reading types offered as initial offerings your particular v
158. eadsheet with corresponding readings data Next you would browse for the survey file whose data you plan to import to ProActive by clicking on the Browse button In our case our PCM survey file is located inside our Local Folder a folder called Survey Files see Section 2 Once you have located the file whose data you plan to import highlight the file name and click on the Open button Next click on the Next button 58 at bottom right of the above window which will be active once a file has been opened The window below represents the data to be imported with regard to our example PCM survey file Pipeline Survey Import Wizard Drag each button onto its comesponding column Click Nest when all the columns want have headings Click Back to select a different import File MB must select a Distance and Current column to proceed Distance E Current Remarks Ez Info E Timestamp Ez E 1 Distance Feet Curent m 230 5 226 1 215 213 2 eli 211 4 211 7 There is only one readings tag associated with the Current Mapper pipeline survey type in the standard database which 1s a Current tag and hence the only readings header button in this example is the Current button The other header buttons are standard ProActive requires one column of distance information and at least one column of correspondin
159. ect the route you will be downloading In our case the example route is named Bobs 325 From the list of supported data loggers which be viewed by clicking on the menu button in the Data Logger field select the type of data logger to which you will be downloading the route data In our example case above we have selected the Gatherer One G1 data logger Next you can select the name of the technician who will be performing the route by clicking on the menu button in the Technician field and selecting an existing name on the list Next you can select the survey type by clicking on the menu button in the Survey Type field and making your choice from the list presented Note This is an important selection since your choice in this category will determine which reading types will appear as prompts for particular devices based on the selections that were made on the Survey Types page of the Reading Configuration Wizard for each reading type during the reading template set up process see Section 5 For instance since we have selected Annual for the Survey Type our example above this would mean for this example route that prompts reading types would be downloaded for all reading types for which an annual survey type was selected Prompts would not be downloaded for any reading type for which annual was not a Survey Types selection during the reading template set up process
160. ed to provide some means of identifying at least the starting location of each section A convenient way to do so is to insert a so called Landmark node inside of each line segment folder and to provide the Landmark node with an identifying station number A Landmark can be considered a type of Device in ProActive to which we can associate a station number and a pipeline If there 16 an actual Device physically located at the beginning of a line segment for example such as a test station and readings are collected at the Device a Landmark and the 219 Device can co exist in the database tree at the same location same station number The relationship between Landmarks designated ProActive and actual sections associated with a pipeline is illustrated the figure shown below Landmark Landmark Landmark Start of Start of Start of section A section B section C Use of Landmarks in ProActive to define Line Segments The following procedure can be applied to establish a node representing a Landmark inside of a Line Segment folder The example is for Section A on the North 1 Line Example Right click on the Line Segment node Section A and left click on Create New Node Next left click on Landmark from the far right hand entity options column Enter name for the Landmark for example Start of Section A and click on the OK button You might also consider using an actual station n
161. eforms Allows multiple waveforms associated with a pipeline survey in the ProActive database to be graphed as a batch rather than individually via device Details Forms Example Two waveforms associated with a CIS The two waveform icons are shown overlaid and highlighted on the CIS graph in the window below 90 eh Pipeline Survey Editor PEUX Survey Selection Graph Text Notes Es Graph al A 1 now E Survey Readings T1 to 70 12 23 2008 71 to 70 12 23 2008 117 M aui ifs 1044 22 Buag duaMog a 2 5 Z a a42 00 Ei a Dn uaa 4 dXE s 85 BLL d m u u e e m m e a iU 5 m ET ee Em m aur zr ed spen Voltage V MEZZO Mus d y z m 20 00 Station Generated 1 5 2011 11 07 08 AM By highlighting the CIS survey and selecting the Batch Print Waveform option via the right click menu or the Menu button the window shown below will be presented E Pipeline Survey Editor 81 Survey Selection Graph Text Notes Pipeline Start Series End Series 5 WR MH 71 to 70 Start Station 0 00 End Station 40400 at E APS WA MH 1 to 70 Altitude fl ta 7D Altitude 1222322008 0 00 38425 0 00 GPS right of way 70 GPS 12 23 2008 0 00 There 2 waveforms associated with the selec
162. elect Create Node by left clicking and then left click on Folder and enter the name Oil Line in the Add Folder window that appears A folder node will be created in the database tree positioned underneath the Customer 1 node at the same hierarchical level This folder will represent the Oil Line and all lower level nodes associated with the Oil Line will eventually be contained within this folder see above hierarchical diagram To position the Oil Line folder one level lower than the Customer 1 folder since the Oil Line is subordinate to Customer 1 you would left click and hold on the Oil Line node and drag and drop it on top of the Customer 1 node When you release the hold the Oil Line node will be positioned one level lower than the Customer 1 node Next right click on the Oil Line node and select Create Node by left clicking on it Again select Folder and this time enter the name Gas Line You will see that a folder node called Gas Line will have been inserted into the database tree underneath the Oil Line node at the same hierarchical level This folder will represent the Gas Line and all lower level nodes associated with the Gas Line will eventually be contained within this folder see above hierarchical diagram At this point the database tree will be as shown below Entire Database eae E Customer 1 2 Oil Line gt Line
163. em the window shown below 15 displayed Information Assignment Completion Message Repair Insulating Set ra Test Flange State Pipeline Milepost Field Insulating Set Value Needs attention 356 The Information page of the above ProActive ToDo folder indicates the message that will be posted Repair Insulating Set when the Post button 15 clicked By clicking on the Assignment page tab on the above window you can assign a technician to the repair task and also indicate a due date for the repair task you can also make these entries via a Summary Folder see below ProActive ToDo Information Assignment Completion Description The final step would be to click on the Post button on the above window You can check to see that the repairs to do was properly posted by double clicking on an appropriate folder in the database tree the flange s line segment folder or a parent folder and clicking on the To do List page tab highlighted on the window shown below on the Summary Folders 357 Segment of Pipeline North 1 Line D EAS Sort Notes Sl Drag amp Drop File Organizer Folder NEM Name Size Type For example the To do List page for our example line segment Test Line Segment which contains the Flange in question would be displayed as indicated below 23 Test Lin
164. eport button 6 Select a Pipeline for the report in response to the prompt and click on the OK button 7 Enter a Date Range for the report in response to the prompt click on the OK button 8 Examine your Excel Spreadsheet report 182 SECTION 8 HOW GENERATE ASSET MAPS VIA SUMMARY FOLDERS amp DATABASE TREE GATEWAY FOLDERS 8 1 Introduction If GPS right of way data have been posted to the ProActive database for a given line segment and or GPS location data have been posted for the facilities assets populating the line segment an asset map can be automatically generated by ProActive ProActive will overlay the asset icons onto an aerial topographic or road map of the relevant area and if GPS right of way data are available the pipeline or pipelines will be overlaid on the map as well Asset Maps can be generated via Summary Folders and also via folders in the database tree 8 2 Summary Folders Option By way of example the Sample Data folder in the as received database tree contains a line segment folder labeled VB PL9905 Segment as indicated below 183 Entire Database g Risk Avere Gas Company 2 Sample Data 5 9102005 2 6 17 03 5 9102005 4052 000 E VB Distictd605 E25 Harruville t 2 Harrwville S auth 2 Harrwville North 9905 5 B 1 1 Rectifi
165. er ih 1 Test Paint 1 Flange ES Single Test Station ES 1 Test Point 230 1 Sleeve 1 Landrmark ES Reconnect 1 Span ES Reconnect 1 ES Reconnect 1 Clone ES Reconnect 1 Tower Sampling ES Line Crossing w Bar sa MCM_1 T ank PCM 1 mhibitor Injectior _ Ill As indicated in the above window the highlighted line segment is populated by a number of facilities assets GPS location data are associated with each of these facilities In addition as can be seen via the Pipeline Survey Editor see Section 5 GPS right of way data have been associated with the line segment as indicated below 184 survey selection Graph Text Notes Pipeline Start Series LL End Seres MEM Pipeline Start Station 207467 End Station t 389 7 2 Pipeline Stat End _ Franks Line ICDA Line 1 _ICDA Line 2 ICDA Line 3 ICDA Line 5 Line ICDA Line _Marks Line _MCM CS_ 97102005 4052 000 _MCM CS_ 9102005 6 17 Pipeline CIS VB PL CIS 330 2004 2207 67 389 57 s GPS right of way VB PL CIS GPS 323022004 ote _Risky Line Hon Line 1 _Test Line Double clicking on the line segment folder in the database tree presents the Summary Folders for the line segment As indicated in the Summary Folders window shown below one of the page tabs is a Map tab
166. erlay Here are some examples accessible via the menu button in the Values field Blank as stored no formatting 0 0 format with 1 decimal place 0 0000 format with 4 decimal places format with 2 decimal places with no forced leading zero 166 SECTION 7 HOW GENERATE TEXTUAL REPORTS USING THE AD REPORT DESIGNER 7 1 Introduction As described in Section 5 2 ProActive offers as standard two textual report formats that can be applied to any given line segment to which pipeline survey data have been applied These report formats are named CIS Exception Report and CIS Details Report and are available via the Pipeline Survey Editor see Section 5 In addition to utilizing these standard report formats it is possible to design your own to suit specific needs The Ad Hoc Report Designer offers the ultimate flexibility with regard to creating textual report formats Once created and saved these report formats can be applied to any given line segment to which pipeline survey data have been applied The following sections describe the principal processes associated with creating report formats and the subsequent generation of textual reports 7 2 Data Type Considerations Before designing a textual report format it is important to know what type of data are available for reporting whether you are designing a pipeline survey report format or a report format associated wi
167. erms of survey type job name survey name survey date and the start and end station numbers for each survey To view particular survey data left click on the row in question For example to view the CIS data on Franks Line the CIS survey row would be highlighted as shown below 90 Boeeserue Nene survey Selection Graph Text Notes Pipeline Start Series End Series Franks Line Start Station 2694 78 End Station 2706 78 amp 2 Pipeline Type Jo Start End FMN Line North 1 Line D d E BH Franks Line Altitude 2 Alt b 28 20 3 2594478 27D5478 cls M2TE 2024 6 17 2003 2694479 2706 79 Curent Mapper 2 1996 b 28 2003 2694 78 2706 78 2 2024 OCYG 17 2 3 2594 78 2705478 Depth of Cover 2 1996 b 28 20 3 2694 78 27DB478 GPS right of way MZTE 2024 GPS b 1 2003 2594 78 2705478 Fig MLZTE 1996 b 20 2003 2694 75 2705458 Soil Resistivity ML2TK 1996 b 20 2003 2534 78 2705478 _ICDA Line 1 _ICDA Line 2 _ICDA Line 3 ICDA Line 5 re n E Ed EH d You can view the survey data either in graphical form or textual form by clicking on the Graph tab or the Text tab respectively For example the graph shown below was generated by clicking on the Graph page tab and checking off the Info box Boeeesesue 8000 eked Survey Selection Graph Text Notes gt H Pol Sta
168. ersion of ProActive and select the reading types that correspond to the readings that you will be taking at the test site the field You can view this reading type list by clicking on the entity specific page tab next to the location tab on the Details Form and examining the Readings field Again each reading type that you select with the exception of calculations will translate into a prompt on your data logger when route data are downloaded from ProActive to your data logger In the case of manual data entry when a data logger is not being used a field will be created on an Excel spreadsheet for each reading type that you select Note Prompts will only be generated for reading types if you make appropriate selections during the reading template configuration process see Section 5 Example A Rectifier is an example of a device that has a Readings page on its Details Form Here s how you would go about selecting reading types for this example The Details Form shown below was observed by double clicking on the Rectifier A node on our example database tree see Section 3 242 2 Rectifier A Details Form Location Rectifier Readings Anode Graph Time Chart Notes Audit Trail Rectifiers 0 0 000505 0 000 Milepost RN Pipeline Mathlline State FL NES o e Aces Morth District Station 0 00 Description DOT Class 3 I soil Type 55550865 Sees or age L
169. est Point inside Insulated Flange Rectifier Bond Coating Transition and Test Point In order to populate our three example line segments with their respective facilities listed above you would proceed as follows Step 1 Right click on the Section A node left click on Create Node and left click on Rectifier A window will be displayed labeled Add Rectifier Enter a name for the rectifier device in the field on this window For example you might use the name Rectifier A for the rectifier on the Section A line segment If you have more than one rectifier on a given line segment you would need to have different names for each site For example 1f you had 3 rectifiers on the Section A line segment you might name them something like Rectifier Al Rectifier A2 and Rectifier A3 Another naming convention would be to use the actual station number of the site in the name For example if the three rectifiers were located at station numbers 0 00 10 00 and 20 00 you could name them as 0 00 Rectifier 10 00 Rectifier and 20 00 Rectifier The Rectifier node will be positioned underneath the Section A node and automatically one hierarchical level down After performing this procedure the database tree window will appear as shown below 221 Entire Database e Vero Beach Gas E E North District 3 North 1 Line 12 Section E A 11 Section B 1 Sec
170. et s design an example format for a Rectifier Report a Click on the Location Information plus sign and check off the following Name Description Pipeline Series 1f appropriate and Station 4 These selections will represent the first 5 column headings from left to right in the report format 368 EEE H Iv Device Information Ee Location Information Name Device Type Description Station Area Name State Province Data ltem Constrain Device Information Show SOL query text Next click on highlight the Pipeline name which will pull up the Data Item Constraint field shown in the window below 369 ad Drag drop ad hoc Database Items Device Information 4 Location Information Device Type Description Pipeline Milepost SSID Station Area Mame State Province nu intu Parish Data ltem Constraint Pipeline Select Items to Include FMM Line Franks Line Integrity Line ICDA Line 1 North 1 Line ICDA Line 2 UNASSIGNED ICDA Line 3 4 Shaw SOL query text Next check off the Prompt when run box which will allow you to select a pipeline or pipelines prior to report generation Click on the Location Information minus sign to shrink this sub category Click on the Reading Co
171. evice Details Forms For example the following two windows illustrate the Readings pages for the Valve and the Rectifier devices illustrating the updates to the readings histories Location Valve Readings Atmospherics Graph Time Chart Notes Audi Trail S elu Descriptions zi i Reading Setup Pipe to Soil Compliance DOT Rule Valve Test Site 346 22 Rectifir Details Form e cmm Location Rectifier Headings Anodes Graph Time Chart Mates Audit Trail Setup Descriptions Amps Volks Line Current Coarse 3 345 T 20188 Puer Mater ITE Sm Compliance DOT Aule Rectifier Test Site 8 2 2 Direct Data Entry Method You can enter test site data directly into ProActive rather than going through the process of generating an Excel spreadsheet entering data into the spreadsheet and subsequently importing the data as was described above in Section 8 2 1 If you use a laptop in the field you could enter data as it s collected directly into ProActive In this method you would not use the Send Route function as described above in Section 8 2 1 but rather you would go straight to the Get Reads function 347 M C Miller ProActive First you would click the Get Reads button highlighted above the main menu bar which would pull up the wind
172. ew the data using the Pipeline Survey Editor see Section 5 For our example scenario above the Get Pipeline Survey window will appear as shown below 39 ad Data Logger Get Pipeline Survey Jab Section 2011 Survey Location Distance Ref T Line North 1 Line 0 0 NENNEN Create ON Anomalies Create OFF Anomalies Create DCF Devices Include Station fw Create DCP Readings Create Pipeline Features wv w Save Readings x Cancel Upon clicking on the Save Readings button on the Data Logger Get Pipeline Survey window the database tree node to which the survey data were directed will be populated with any Devices that were encountered and at which readings were taken during the pipeline survey And in the case of DCVG surveys any marked anomalies which are known as DCVG Anomalies in ProActive will be created and these anomalies will also populate the target node With our example DCVG survey data brought into ProActive as described above our Pipeline Operator Owner Example database tree will appear as shown below 54 Entire Database E Vero Beach Gas Co E North District 3 5 North 1 Line Start of Section Single Test Station Mf Anomaly M Anomaly_1 Mf DCvG Anomaly 2 DCVG amp nomaly 3 Mf Anomaly_4 M Anomaly 5 M A
173. examples Should having the pipeline in a parallel orientation with the X axis be of interest a value of 0 be entered in the Follow Pipeline in Degree Increments field For the above example line segment the following map will be presented for this case pipeline shown horizontally from left to right going downstream 109 Note The Follow Pipeline in 0 Degree Increments orientation selection is typically used when pipeline survey data are to be presented in a Map Survey Data integrated report as a function of stationing increasing from left to right in the positive X axis direction m aaa Ie a M I amp esl ee ay aoe Freaks Aisne Map Overlays The types of overlays as well as their appearance can be selected by the user via the Mapping tab window Pipeline The pipeline will be shown on the map if the box labeled pipeline is checked Thickness The relative thickness of an overlaid pipeline can be selected via the box labeled thickness 5 is the default value values larger than 5 will result in a thicker line and values small than 5 will result in a thinner line Color The color for the overlaid pipeline can be selected by clicking on the Color menu button and highlighting the color of choice Mode Clicking on the menu button in the
174. f the window illustrated below Note The specific entities that will be listed will depend on your particular version of ProActive 224 Entire Database 8 amp vero Beach Gas North District North 1 Line Create Node Anomaly Duplicate Node Bond Retire Node 000 Coating Transition Rename Node Transform Node 225 terms of the definitions detailed Section 3 1 the entities listed above can be grouped as follows Devices Test Sites Anomaly Bond Galvanic Anode Inhibitor Injection Insulating Flange Internal Corrosion Offshore Rig Rectifier Span Storage Well Test Point Tower Valve Water Sampling Above Ground Exposed Pipe Device Stations Compressor Compressor Station M amp R Meter amp Regulator Station Tank Farm Tank Special Feature Elements Coating Transition Landmark Sleeve In order to illustrate the process of populating line segments with Facilities let s imagine that the three line segments of our example North 1 Line pipeline have the following facilities associated with them Also the facilities are ordered according to their station numbers increasing in Station number as we head downstream Section A Rectifier Test Point Bond Galvanic Anode and Test Point 226 Section Compressor Station with Valve and Test Point inside Rectifier Bond Span Valve and Test Point Section C M amp R Station with T
175. ff in the box labeled Use Local Folder on the Driver window Next identify the Local Folder in question by clicking on the Browse For Folder button Next highlight the survey file in question from the list of files presented and click on the Go button At this point you would then follow the steps outlined Section 3 2 above starting at Step 5 3 4 How to Import Survey Data from Excel Spreadsheet XLS WinCIS and XML Files ProActive allows you to import survey data that are stored 1n Excel Spreadsheet WinCIS and XML files and to associate such data with the appropriate line segments in your database Examples of data that can be imported are Pipeline Current Mapper PCM data and Smart Pig anomaly data Separate import wizards are available for each file type Data to be imported must be in a format that 1s compatible with ProActive The importation process 15 basically one of creating an acceptable format for data import It is recommended that the data files be first saved in your Local Folder see Section 2 56 Excel Spreadsheet XLS example Let s assume that we have performed a PCM survey on the same line segment namely Section A of the North 1 Line from which we previously collected DCVG survey data see Section 3 2 Also let s assume that we have copied the PCM survey file Excel Spreadsheet file to our Local Folder To Import the PCM survey data the following proced
176. for the On potentials 116 Red in our example The CIS entity will now be labeled as the CIS On entity ad Graphical Report Designer Report Mame Bobs Report Format Zr New Remove Report Details w WebService CIS Data a Survey Data Percent Data Report Entity Detail CIS Survey Type Data Style f Lett Asis Right Axis iw Use Color On Value ni Line X conc Next right click on the CIS On entity and select Add Entity Click on the menu button in the Survey Types field select CIS and click on the hand icon to insert the entity into the group Next left click on the newly created CIS entity which will pull up the Report Entity Detail field Click on the menu button in the Data field and select Off Value and via the Style menu select Line Check off the Use Color box and select a color for the Off potentials Green in our 117 example The CIS entity will now be labeled as the CIS Off entity iz Graphical Report Designer Report Mame Bobs Report Format 4 Remove Report Details Map Iw WebService CIS Data Report Entity Detail CIS Survey Type Data Style LeltAxis Right Axis Use Color Ott Value v Line X cea Finally check off the CIS Data group box to switch on the CIS Data group
177. g a survey and or if photographic images were recorded in the case of the Gx Data logger In addition to overlaying a text label these types also overlay an icon Wave Print Photograph Other Types Remarks Remarks Comments associated with any pipeline survey or site survey readings are overlaid as text Survey Readings Data associated with a pipeline survey whose survey type has been configured in ProActive to be overlaid as text are overlaid as text rather than being plotted An example would be GPS right of way data Common Controls Text Controls The control elements that are common to all Overlay Types are accessed via the highlighted region below on the Graph Property Editor 159 Graph Property Editor Properties N ame Bobs Graphing Style EN Private New Legend Series Overlays Overlay Type iw Visible Exclude Label Position Angle t Top f Bottom f 270 90 45 Text Font iw Outline Data iw Visible General Headings Cancel These are the controls related to an Overlay s text These controls determine whether or not an Overlay s text is visible on a graph Visible control whether the text 1s originating from the top or from the bottom of a graph Position control what the orientation is of the text relative to the horizontal axis Angle control what the font type fon
178. g drop folders and or devices from vB PL9905 5 egment the database tree to base this report BB valve zn 1 1 Point MCM_1 Flange ES Single Test Station Report Based MCM_1 Test Point 230 22 MCM_1 Sleeve Devices from the Tree MCM_1 Landmark ES Reconnect lee T 5nan Report sites in the order shown above C Devices in a Haute f Miscellaneous 3 Click on the Devices from the Tree radio button and drag and drop the devices test sites from your database tree that will form the basis of your report Next click on the Report button on the above window This will pull up the window shown below for our example report format 3T Active Report Wizard Bobs Rectifier Report Format Enter the 4d Hoc Constraint for Pipeline Select Items to Include Uncheck all Check all Line One 5 9102005 ML2TK 6 17 03 Line Three mj Pipeline Line Two Pipeline MCM CS 9102005 4052 000 Marks Line 4 Cancel Next select the pipeline or pipelines of interest and click on the OK button This will pull up the window shown below for our example report format 378 S ProActive Report Wizard Bobs Rectifier Report Format Enter the 4d Hoc Constraint For Survey Date Enable Date Constraint NULL dates From Date ebr 203 re Ignore Until Date 11726 2006 f Exclude f
179. g readings data First establish the beginning row of data and the ending row of data for the data set to be imported This is particularly important if only a subset of the data is to be imported or if there are rows containing information that 15 not part of the data set for example Spreadsheet column header names as in the above example 59 Right click in the first row of readings data to be imported and then left click on Set Begin Row via the small right click menu ad Pipeline Survey Import Wizard Drag each button onto its correspanding column Click Nest when all the columns you want have headings Click Back to select a different import File MB must select a Distance and Current column to proceed Distance E Current Remarks Ez Info E Timestamp E E lt lt Back Next right click in the last row of readings data to be imported and then left click on Set End Row via the small right click menu Next associate the header buttons with their respective columns as follows Drag and drop the Distance button into the Distance column and drag and drop the Current button into the Current column Note A second option exist if the Spreadsheet header names match the header button names as in the above example In such cases the Auto Find option can be selected via the right click menu associated with each header button The data will
180. ger Get Readings Data Logger Manual Data Entry Haute Route Survey Type Annual Technician UNASSIGNED Override Logger Weather Cloudy Description 2011 Annual Start Date Last Date Status READY Include Atmospherncs You would then select Manual Data Entry the Data Logger field by clicking the menu button in the Data logger field Next you would select the name of your Route via the menu button in the Route field Once the route name 15 selected the Technician and Survey Type fields will be filled automatically based on the selections you made previously on the Send Route window when you created the spreadsheet Next you would enter the type of weather condition you encountered during your route by clicking on the menu button in the Weather field and making your selection from the list provided 342 Note The weather options list be edited using the List Manager via the Weather Encountered list name Next you would make an entry in the Description field Note This is an important entry as you will be effectively naming your test site survey here Since you will build up a history of test site surveys done on a particular route over time you might want to develop a naming system for surveys associated with a particular route As 18 discussed in Section 10 you will be able to review the details of historical test site
181. ger field or you could simply drag and drop the Harryville folder into the Route Manager field as indicated in the window shown below 310 S Route Manager Haute Bobs Route D 54 setup Assign History Surveys Notes Graph Audit Trail Map Description Devices 5 E E Harryville South E amp Risky Line 4 Exclude Item Rectifier BE Fiectifier 1 Risky A 193 23 Fourmile Harryyville Morth Ee VB PLY905 Segment BE MCM_1 Rlectifier BE 1 389432 E Ee Franks 5011 5 BE 5U11 Rectifier Example 4 Selecting Facilities Overlaid on a Map See Section 13 for information on Map generation via Tree Folders or Summary Folders Facilities can be selected for inclusion 1 a route by having Route Manager open with a route name selected right clicking on each facility to be included in the route and selecting the Add to Route menu option Map Option Facilities including devices that have been associated with a route and that have associated GPS location data can be presented on an appropriate aerial topographical or road map For example a route was built using the devices highlighted the example database tree shown below 311 Entire i Harryyville Morth El fa VB PL9905 5egment Recife AE M_1 Test Point
182. h Time Chart Mates Audit Trail Test Rectifier Readings amp 12010 8 2010 10 2010 11 2010 12 2010 1 1 2011 1 27 2011 10 11 45 AM Next on the Save Graph to Enhanced Metafile window that ll be displayed select a target folder on your hard drive enter a name for the image file and click on the Save button You can then access the 1mage file from your local folder target folder as required perhaps for reporting purposes Printing To print the graph click on the highlighted button on the window shown below 39 88 Test Rectifier Details Form amp 12010 8 2010 10 2010 11 2010 12 2010 1 1 2011 1 27 2011 10 11 45 AM You would then select your printer for printing in the normal way 12 3 How to Graph Readings on a Line Segment Basis Readings can be graphed on a line segment basis reading values versus stationing via Summary Folders For example double clicking on one of the line segment folders 1n our example database tree labeled VB PL9905 Segment will pull up the summary Folders window shown below 392 4 VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors Templates Compliance Flagging i Pipeline ni Segment re Sort Hotes Next ta Drag amp Drop File Organizer Folder Modified As can be seen from the above
183. h America region In all three cases the map data represent a superposition blend of two map types for example aerial and road and the percentage of each map type is user Selectable via the Map parameter indicated on the Graphical Reports window see window shown below s c mm Moda t Bema Pets Franka ua 4 T FA H E c _ a T j z rua a 2 rill I e x my E 5 8 D sh NE 2 E E NL en Ux E E n a z ci 5 E E us A 100 for Map selection would represent 100 of the 1 selection and 0 of the 27 Map selection whereas 0 selection for would represent 100 of the 27 Map selection and 0 of the 15 Map selection Any value in between 100 and 0 would correspond to a particular blend of the two selected map types The example above represents 100 road map 0 aerial The available map types for each data source aerial topographical road etc can be selected for both the 1 and 274 Maps by clicking on the menu buttons in the relevant fields and highlighting the choices Orientation Fixed Bearing If the Fixed Bearing option 15 selected the positive Y axis direction will correspond to the selected fixed bearing direction North South East West etc For example
184. have the What If confirm window appearing each time click on View on the main menu bar click on User Preferences click on the Risk Modeling page tab and un check the Prompt for What If box 9 Examine your graphical report Note If a map 15 part of your report you will need to be connected to the Internet order to have the map displayed An example graphical report is illustrated below which was generated using the example report format outlined the above section Bobs Report Format 130 DCVG Survey Data mum 5005 9 0 025 9 2 015 9 a inl 1 il ill I LIEN LIE IG m liens Ah li ll I l th 214 2 005 IR Data IR How to Generate a Standard CIS Exception Report The standard CIS Exception Report requires both CIS and Static survey data to have been associated with a given line segment If such data are available ProActive will highlight graphically the locations where the CIS data fall below the 0 85V threshold for both the On and the Off potentials and also where the calculated level of polarization values fall below 100mV 1 Click on the Reports speed button main menu bar 2 Click on the Graphical Reports radio button 3 Highlight the Generate Graphical Reports option 4 Click on the Report button 5
185. he Pipeline Survey Editor however the actual survey data readings station numbers etc are not deleted Selecting the Purge Deleted Surveys option will result in the deletion of actual survey data from the ProActive database 5 3 How to Edit Survey Data via the Graph Mode in Pipeline Survey Editor A number of data editing processes can be applied to pipeline survey data stored in the ProActive database using the Graph Mode inside the Pipeline survey Editor First select the survey data to be edited by highlighting the survey in Pipeline Survey Editor and clicking on the Graph page tab Next click on the Graph Mode button which is highlighted on the Pipeline Survey Editor window shown below Note Once editing changes have been Saved the edits will be incorporated in the database Consequently files containing raw un edited 99 survey data should be saved a hard drive location or backed up using some other means so that the raw un edited survey data will remain available for possible future use Pipeline Survey Editor Survey Selection Graph Text Notes st Graph al Pol Stat Points a inta Survey Readings 300 00 Station VB PL CIS On 3 30 2004 Voltage V VB PL CIS Off 3 30 2004 Voltage V 110 2011 4 43 24 PM The Mode window shown below will be displayed after clicking on the Graph Mode button Graph Mode
186. he Line Segment node Section A and left click on Create New Node Next left click on Landmark from the far right hand entity options column Enter a name for the Landmark for example Start of Section and click on the OK button You might also consider using an actual station number as part of the name 32 The Landmark node will now be located inside of the Line Segment folder At this point the database tree will appear as shown below Entire Database Vero Beach Gas 2 North District North 1 Line Section Start of Section Section B Section North 2 Line Section Section B Section C amp South District South 1 Line Section Section B Section South 2 Line Section Section B Section Next double click on the Landmark icon or on the Landmark name which will open the Details Form representing the Landmark device The window shown below will be displayed 33 22 Start of Section A Details Form Mame Start of Section A 000000000000 Milepost bo o Fipeline Noth 1 Line State 3 BrIes e Ace Station 0 00 Description Pn a Is Sail Type of Pag Latitude Longitde amm Town PDegn 4 000 Installed NE E Retired E Tech Be Directions
187. he database tree by double clicking on their icons which is a convenient way to isolate a potential trouble spot location based on the readings data presented graphically 395 2 gt Summer fone COTCT items Todo Lit Pick Model Graph Survey Amcapherc Eros CLS Templates Compliance legging Map Again though test site readings can also be incorporated into Graphical Reports by employing the Graphical Reports Designer feature please see Section 6 in Part of this manual for a review of this feature For instance test site readings can be presented in conjunction with pipeline survey data for example CIS and DCVG survey data in a multi graph stack presentation Also test site readings such as Pipe to Soil data for example can be presented in conjunction with an aerial map assuming that GPS Right of Way data have been associated with the line segment in the ProActive database SECTION 13 HOW TO GENERATE ASSET MAPS VIA SUMMARY FOLDERS DATABASE TREE FOLDERS amp ROUTE MANAGER 13 1 Introduction If GPS right of way data have been posted to the ProActive database for a given line segment and or GPS location data have been posted for the facilities assets populating the line segment an asset map can be automatically generated by ProActive 396 Asset Maps be generated via Summary Folders fo
188. heck both boxes for example with respect to a Pipe to Soil reading template however in other cases for example a Rectifier Volts reading template it may not be required to graph the readings on a line segment basis Test site readings can also be incorporated into Graphical Reports by employing the Graphical Reports Designer feature please see Section 6 in Part 1 of this manual for a review of this feature For instance test site readings can be presented in conjunction with pipeline survey data for example CIS data in a multi graph stack presentation Also test site readings such as Pipe to Soil data for example can be presented in conjunction with an aerial map as illustrated below assuming that GPS Right of Way data have been associated with the line segment in the ProActive database 383 GEU Te gt oe a zi un T MD an om kien i bt i A m lac Maso a i i i ice i rr Iu gt he TEE Fipe to Sail On aas DIT head line 21444 1 1 EI tort 250406 m 712 2007 12 2 How to Graph Readings on a Test Site Device Basis Example Let s say we had a Rectifier at which we recorded Rectifier Volts and Rectifier Amps data on a bi monthly basis The data recorded are shown below in the History field of the device s Rea
189. heric data types since the Details Form for a Flange has Atmospherics page associated with it The process would be as follows Double click on the Flange node in your database tree which will pull up the Details Form for the device and click on the Atmospherics page tab For our example Flange namely Flange on the Section line segment the Atmospherics page will be as shown below Flange Details Form Location Flange Readings Atmospherics Graph Time Chart Notes Audit Trail Setup Descriptions P zi History Date As be seen from the above window we do not presently have Atmospheric types selected for this Flange since the Flange page on the Details Form does not have an Atmospherics field in which to make our selections 261 You can add Above Ground data type for example however by entering Above Ground in the Descriptions field and clicking on the Create Atmospheric button highlighted in the window shown below Flange Details Location Flange Readings Atmospherics Graph Time Chart Mates Audit Trail Setup Descriptions 2 The Atmospherics page will be as shown below 262 4 Flange C Details Form Location Flange Readings Stmospherics Graph Time Chart Mates Audit Trail Setup Above Ground zi
190. highlight the Design New Report option Next click on the Next button which will pull up the window shown below 366 S ProActive Report Wizard Design New Report Select a route or drag drop devices Lie 1 Haectifier from the database tree to base this report on Alternatively check Miscellaneous to base this report on other ProActive data such as a Pipeline Survey i Devices fram the Tree A f Devices in a Route Report sites in the order shown above f Miscellaneous ____ 3 Click on the Devices from the Tree radio button highlighted on the above window and drag and drop any device test site from your database tree into the empty field the specific device that you drag and drop doesn t matter as you are only designing a report format at this time you are not actually generating a report Next click on the highlighted Next button which will pull up the window shown below 367 ad Drag drop ad hoc Database Items Bl Levice Information ree Dropdown List Contents Pipeline Survey Surveying Equations To do list information Remedial ltem information Eror tem information Flag item information Folder Information DB Integrity Rules Data ltem Constraint Descending Show SOL query text HERD 4 Select sub categories from the Device Information major category by clicking on the plus sign which will expand the major category Example L
191. highlighted below on ProActive s main menu bar M C Miller ProActive File Edit View Tools Advanced Help Reports Route Mgr Send Row Get Reads Surveys Srwy Editor Find Filter List Mgr Templates The window shown below will be displayed again based on previous selections 328 Data Logger Get Readings Data Logger Route 5 Survey Type Anud Technician UNASSIGNED Overnde Logger 0000 Wy eather UNASSIGNED Description Start Date Last Date Status READY Atmosphercs Curent Interruption Go x Exit You would select your data logger type GATHERERONE for G1 Data Logger our example by clicking on the menu button the Data Logger field You would then select the name of the our example the route name 15 Bobs Route Once the route name 15 selected the Technician and Survey Type fields will be filled in automatically based on the selections you made on the Send Route window when you downloaded the route data Next you would enter the type of weather condition you encountered during your test site survey by clicking on the menu button in the Weather field and making your selection from the list provided 329 Note The weather options list be edited using the List Manager via the Weather Encountered list name Next you would make an
192. highlighted devices with the click of one button 229 To do so you would click on Advanced the tool bar and then click on Batch Update Location which will appear as a selection option on the drop down menu This will pull up the window shown below Batch Location Updater Area Mame State Pipeline E Description DOT Class Latitude Longitude County Altitude Pipe Depth Town Alignment Sheet Line List Sail Type X cance When you click on the Update button any information that you enter on this batch location updater window will be added to the location page of all entities that are highlighted in your database tree You can highlight multiple devices by clicking on the first device and then clicking on the subsequent devices while holding down the shift key Alternatively if you wanted to update location information for all of the devices on a line segment you could highlight the line segment node rather than highlighting each device on the line segment individually Note You can provide driving directions to a test site device on the location page as indicated the above Details Form window The driving directions will be downloaded to your data logger with the other location related information that you enter on a location page If you enter driving directions the information will be accessible via a Driving Direc
193. hion For instance a route could comprise all of the devices on a number of line segments or it could comprise all of the rectifiers and bonds on a pipeline ignoring all other device types The possibilities for route design are endless and you can tailor your routes to suit you Own requirements The order in which the test sites are listed in a route 15 transferred to a data logger when route data are downloaded and the test sites appear in the same listed order on the site survey information screen of the data logger see your data logger s user s manual In the case of Excel spreadsheet generation when manual data entry is being used the various test sites comprising a route appear on the spreadsheet in the same listed order as prescribed during route creation The steps involved building a route are as follows Step 1 Click on the Route Mgr Route Manager button on the main menu bar M C Miller ProActive File Edit View mms Advanced Window Help LS nal DEPTTTTM Lai Reports Route Mgr wend Route Get Reads Surveys Srvy Editor Find Filter List Mgr Templates This will pull up the Route Manager window shown below 297 S Route Manager Foute GIE setup Assign History Surveys Notes Graph Audit Trail escription Devices VB PL9905 5egment ta 9 Include Sub route 4 Exclude Item Step 2 Click on the highlighted
194. ield the Survey Location field blank Distance Ref field If Feet Relative is selected via the menu button the Distance field the starting station number for the survey should be entered in the Station field and a selection of Downstream or Upstream should be made via the menu button in the Direction field 1 e does the stationing for the survey on the data logger increase or decrease with walking direction respectively In this case ProActive will interpret the data logger stationing as distances relative to the entered starting station see Station field below 51 On the other hand if either the Station Number Absolute or the Milepost Absolute option is selected rather than Feet Relative starting Station Number entry does not have to be made as ProActive will interpret the actual stationing from the data logger as the appropriate stationing for the survey data Station field The Station entry must be made with regard to your selection in the Distance Ref field see above An entry in this field would only be made in conjunction with the selection of the Feet Relative option in the Distance Ref field see above An entry in this field would represent the starting station and the data logger distances would be shown in ProActive relative to that starting station Data Logger Considerations It is important to examine the starting sta
195. ier Amps For this example when Rectifier Volts and Rectifier Amps data are posted to the database the Groundbed Resistance parameter can be determined from those data assuming that a Groundbed Resistance data type reading type has been created for the rectifier with an associated Reading Template that has the appropriate calculation included Consequently how reading templates are set up in ProActive has important ramifications for data processing and subsequent reporting Initially your database will have been set up with Standard reading templates The term Standard implies that the reading template with 264 which reading type is associated is a global template meaning that the particular template will apply to all readings of that type on a company wide basis You have the option of modifying the Standard reading template associated with any reading type and you can modify reading templates on a Summary Folders basis localized basis or on a test site specific basis unique basis 5 2 How to Modify Standard Reading Templates To view and possibly modify a Standard Reading Template click on the highlighted Templates button shown below on the main menu bar M C Miller ProActive File Edit View Tools Advanced Window Help Th Reports Route Mgr Send Route Get Reads Surveys ao Find Filter This will pull up the Reading Template Configuration Wizard wind
196. iewed via the To do List page of the line segment s Summary Folders and also via the To do List pages of any parent Summary Folders such as pipeline district and company folders The process is as follows First pull up the device specific page for the flange 1n question for example Test Flange by double clicking on the device node and clicking on the Flange page tab The window shown below will be displayed 355 23 Test Flange Details Form Location Flange Readings Atmospherics Graph Time Chart Notes Audit Trail Readings Line Side 5 Flange Type Pipe to Soil 1 5 Up Stream C Inline pe S s Down Stream C Tap Open Circuit Potential M R Inlet Current Foreign 5 C M R Outlet UNASSIGNED Point of Ownership Condition Remedial RepairsT o do Internal Short Arrestor Insulating Set Cables Iv Insulating Set As can be seen from the above window a number of different options are available for selection in the Condition field for both remedial items and Repairs to do items The next step would be to check off the item that is in need of repair in the Repairs To Do field In our example the insulation has failed and so the box labeled Insulating Set has been checked see highlighted option on above window Upon checking off this it
197. ine node and repeat the above procedure to create a node for the South 2 Line The South 2 Line 16 at the same hierarchical level as the South 1 Line so re positioning would not be necessary in this case At this point the database tree will appear as shown below 21 Entire Database 2 North District gt gt North 1 Line North 2 Line E South District 2 South 1 Line 2 South Z Line Step 6 Create folders nodes to represent the sections comprising each of the four main pipelines The example below illustrates the process of adding a section Section A to the North 1 Line pipeline Right click on the North 1 Line node and left click on Create Node Left click on Line Segment since this node will be for a segment of a pipeline By selecting Line Segment rather than Folder you will be creating a Line Segment Summary Folder this time Enter the name of the section in the Add Line Segment window The first section name in our example will be Section A A new node named Section A will have been inserted into the database tree underneath the North 1 Line node at the same hierarchical level To re position the Section A node one hierarchical level below the North 1 Line node left click and hold on the Section A node and drag it on top of the North 1 Line node When you release the hold the Section A node will be re positioned Note The icon for a Line Segment Summa
198. ing Answer Yes to create a configuration unique to this device reading Answer to modify the standard reading template for all readings using this template Press to return to the Wizard without saving the configuration Clicking on the Yes button will result in the template being considered to be unique template unique to the reading type Rectifier Amps in this example and unique to this particular Rectifier device As indicated the window below the Current Settings field summarizes the nature of the Unique Reading Template In our example the modification we made was the change to the voltmeter range setting from the original value of 40mV to the new value of 400mV Note We also changed the shunt factor value however this modification alone would not have resulted in a template change 285 Reading Configuration Wizard Configuration Settings for Amps Select Template to edit or enter a new template name Amps Revert ta Man LInique Template Settings Unique Reading Template DOT required reading Single Value 0 5 range 400m Direct Current at Sing 10 Mohm impedence Current Settings Note Clicking on the No button on the Confirm window would result any modifications made being applied to the standard template associated with the reading type in question In this case the modifications would affect
199. ing the survey as overlays on the graph see Section 4 4 below By checking the Points box you can view all of the data points on the graph and by un checking the Stat box the x axis will be labeled as milepost as opposed to station number 70 Since there various survey types associated with this line segment a number of different survey types can be selected simultaneously up to a maximum of 3 survey types For example the window shown below illustrates the case where both the CIS and DCVG survey types have been selected Note Particular survey data must be selected for graphing as each survey type 15 selected Franks ML2 Line Summary Folders Templates Compliance Flagging Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors ES Fipeline Location Start Series End Series Franks Line Start Station 2694478 End Station 2706 77 Pig Surveys 2 2024 DDVI 6777 2005 v CIS Surveys GPS right of way Surveys DCY G Surveys Graph al 5 amp Points Into DCVG Surveys MERITI ES M2TK 2024 DCVG Voltage V CIS Surveys 2700 00 Station 2 2024 Voltage V 12 29 2010 10 41 52 4 3 Viewing Survey Data Graphically via Parent Folders Pipeline survey data that has been associated with a line segment can also be viewed via the Summary Folders associated with the pare
200. ins Ao 1 z a as mires He p eh Z 8 2 amp ae m d xh Mie J 1 s i qo i 1 as i Ney P ES La i p Location Test Point Readings Atmospherics Graph Time Chart Hotes Audit Trail Name Milepost Pipsine Pipeline State AL 4 Name Hamvile Station 21 4 02 Description Franks Site Dev Specific processed 0 0 DOT Class i Soil Type Cinders ced or Franks County Latitude B 20152283 Long P 70954132 Town Franks Ton Alitude B amp T581832 Depth 8123468 11 UNaSSI Line List i3 Installed 2172000 Em This Facility on other pipelines Retired Tech Direchons Next to 8 5 Asset Map Presentation Options A number of presentation style options are available to the user via the Mapping tab associated with User Preferences as accessed via the View menu View User Preferences Mapping 189 User Preferences TenaServer BING ESRI Online Tst Aerial end Map Road Cache 9999 Files Orientation Fixed Bearing North Follow Pipeline in 0 degree increments Overlays Pipeline Thickness Color Pipe Color Facilities Adjust Icon Display Compass Name Label Distance 280 Feet Max Separation 8 5 1 Data Sources The so
201. inside the cell associated with the reading type for which you would like to provide historical data For example double clicking inside the highlighted cell on the above window will pull up the Edit Amps window Edit Rectifier Amps window shown below 293 Edit Amps 1 21 2011 Reading Value Cancel Remark 2 SO I Technician W Edit value s as displayed You can then enter the Rectifier Amps reading value measured on 1 21 2011 1n the Reading Value field on the above window similarly you can enter the Rectifier Volts data measured on the same day At this point the Readings page will be displayed as shown below for the particular reading values entered in this example 204 A Test Rectifier Details Form Location Rectifier Headings Anodes Graph Time Chart Mates Audit Trail Reading Setup Histor Compliance DOT Rule UNASSIGNED M ext Reading Que Additionally Remarks be entered in association with the reading values via the Edit Reading Type window if required For example the remark Shunt replaced was entered in association with the Rectifier Amps reading as indicated in the Edit window below Edit Amps 1 21 2011 1 9 Heading Value 18 5 Cancel Remark Shunt replaced Survey Type Technician Edit value s as displayed 295 As indicated on the Readings page
202. irm window the highlighted survey data will remain in the ProActive database but will not be used in the generation of reports and maps for example out of date GPS data or out of date Static data could be excluded Snap Survey Using GPS In order to utilize this feature two surveys are required on the same line with each of the two surveys having its own associated GPS data Application of the feature results in one survey the target survey being re stationed using the stationing and associated GPS of another survey the reference survey Once the reference and the target surveys have been highlighted ProActive will search automatically for appropriate GPS data in the database A survey is associated with its GPS data for snap purposes either by grouping if any exists or by having the same date as the survey data itself Grouping As an example the following indicates how a CIS and a GPS survey can be grouped together Left click on the CIS survey and while holding down the Ctrl key left click on the GPS survey Both surveys will be highlighted as indicated in the Pipeline Survey Editor window shown below 94 Pipeline Survey Editor Survey Selection Graph Pipeline Start Series End Seres Franks Line Start Station 2694 78 End Station 2706 78 Pipeline 2121 Start End FMN Line North 1 Line E Franks Line Altitude ML Alt b 28 20
203. irst map the positive Y axis 1s parallel to the North direction and in the second map the positive Y axis 15 at right angles to the North direction and 1s pointing due East as expected from our fixed bearing selections Follow Pipeline in Degree Increments Notice that the pipeline 1s not parallel to the X axis in either of the above fixed bearing map examples Should having the pipeline in a parallel orientation with the X axis be of interest a value of 0 can be entered in the Follow Pipeline Degree Increments field For the above example line segment the following map will be presented in this case 192 ad VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors El Templates Compliance Flagging Q A 0 H a s 041581 WOW 8A EA L WON gt WON CC Ec 1 041 81 WOW Wo Huis puog l WOW j WOW E WoW ET P pauuo3 Be ae 2 zpauuoJay 0 9 gal WC d pasodxa L Wo uoneis Eg 42 A CG 44E utodisal L WOW C6 04 1 041581 WON 3 1015 d edi WO B lod i58 1 L WOW 2 AOPGIYU 18 eAA mu A 7
204. iteria Report Format Enter Description Bobs Rectifier Report Format Save Cancel Show SOL query text Word Web Page 6 Enter a descriptive name for the report format and click on the Save button highlighted on the window shown above In our example the report format name is Bobs Rectifier Report Format 7 Finally exit the Ad Hoc window click on the X button top right The saved report format will be available as an Ad Hoc report format 11 3 How to Generate a Report using a Saved Report Format 1 Click on the Reports speed button main menu bar 375 SS ot View Tools Advanced Window Help pyiz Find List Mgr Templates AAA Filter Te This will pull up the window shown below Route Send Route GetReads Surveys Srvy Editor Select the repart you want to use Bobs Anomaly Report Format Bobs Rectifier Report Format D CV Anomaly Report Pipeline Survey Report Site GPS Report Report Categories C Standard Reports NR Adhac Reports Graphical Reports Design Edit Report lt lt Back gt gt 2 Click on the highlighted Adhoc Reports radio button and highlight your report format name as indicated on the window shown above Next click on the Next button This will pull up the window shown below 376 ProActive Report Wizard Bobs Rectifier Report Format Dra
205. ith a selected background color inside the frame For example by making the selections highlighted in the window shown below the example graphical report becomes as shown below 149 Graph Property Editor 5 Sm Properties Name Bobs Graphing Style EN Private 7 Remove Titles Ais Legend Series Overlays Title v Visible COMPANY 7s Prompt Font Color Transparent v Frame Foote Visible DEFAULT Prompt Font Color Transparent Frame Cancel 150 jis due Y S Force JL Ee 3 uc M Esas Ay I y PN Pim _ Pipeline 1 13 2011 Footer Field The focus here is on properties associated with the Footer title selectable via the Footer field highlighted in the window shown below 151 Graph Editor raph Property im Properties M ame Bobs Graphing Style EN Private Remove Titles Axis Legend Series Overlays Title Visible COMPANY i Prompt Font Color Ei Transparent Frame 7 DEFAULT Prompt Font Color Transparent Frame Cancel As indicated in the Footer field the token associated with the cloned style for the footer title is 7 DEFAULT in which case ProActive will supply text by default As indicated in the graphical repo
206. ition Angle E Top f Bottom u 2fOt 45 Dat Visible General Headings Cancel CE E tC 3 one Hepes Habs Flepest Farra Atari End Genes Stat Stake m SET Ei Ar QA ee Bon Foii H CIS Bata mEn 14 m on mu ye Y es JU p PA d IN MER f 12 wf gu M pu gt 12 ati ye Eo mcd ts EU ae i hen al ME oa C ks CM 21 1 D i ET B 1 4s 26 5 5 Additional Controls for Complex Type Overlays There are additional controls associated with facility type overlays which relate to whether or not a facility icon is displayed on the graph and whether or not device readings are displayed on the graph Please see the highlighted region in the Graph Property Editor window shown below 162 Example Test Point Overlay A Test Point Overlay is an example of a Data Collection Point Overlay other examples would be Rectifiers Valves Bonds etc For the control settings indicated the Graph Property Editor window shown below visible overlay text originating from the top text orientated 270 with respect to the horizontal and Facility icon visible Readings not visible the graph shown below illustrates a Test Point overlay Graph Property Editon
207. k Station H Number of Pages Divisions Per Label End Series End Station 201 2 HOW TO MANAGE TEST SITE DATA 202 PART 2 CONTENTS Page SECTION I 206 SECTION 2 HOW TO ORGANIZE YOUR PROACTIVE DATABASE 2 1 Database Tree Folder 207 2 2 The As Received Database nu 208 2 3 How to Back up the As Received Database 209 2 4 How to Restore a Backed up Database 210 2 5 How to Create a Database Tree 210 SECTION 3 HOW TO POPULATE YOUR LINE SEGMENTS WITH FACILITIES 3 1 Definitions Facility 2 0 02 22 225 3 2 How to Populate your Line Segments 224 SECTION 4 HOW TO SELECT THE TYPE OF DATA YOU REQUIRE TO BE COLLECTED AT EACH TEST SITE lt 241 4 2 How to Select Reading Types for each Device your Database having a Readings 242 4 3 How to Add a non selectable Reading Type 246 4 4 How to Select Data Types for Visual Atmospheric eec TETTE 252 4 5 How to Add a non selectable Atmospheric Data Type 260 SECTION 5 HOW TO CONFIGURE THE READING TEMPL
208. k and the 18 Device co exist in the database tree at the same location same station number The relationship between Landmarks designated in ProActive and actual sections associated with a pipeline 16 illustrated in the figure shown below Landmark Landmark Landmark Start of Start of Start of section A section B section C Use of Landmarks in ProActive to define Line Segments If we perform a pipeline survey on Section A of the Oil Line for example we would like the survey data to be associated with the appropriate line segment folder in the above database tree 1 the Section A folder The following procedure can be applied to establish a node representing a Landmark inside of a Line Segment folder The example is for Section A on the Oil Line Example Right click on the Line Segment node Section A and left click on Create New Node Next left click on Landmark from the far right hand entity options column Enter a name for the Landmark for example Start of Section A and click on the OK button You might also consider using an actual station number as part of the name The Landmark node will be inserted into the database tree one hierarchical level lower than the Section A node At this point the database tree will appear as shown below 19 Entire Database ee ABC ENERGY 3 amp Customer 1 E amp OilLine 5 fia Section Start of Section 11 Section t
209. l For example a multiplication factor of 0 001 would convert mV values to V values 97 Generate Anomalies Provides an opportunity to have ProActive create anomaly devices in the database tree based on manually entered threshold levels Remove Anomalies Provides an opportunity to have ProActive remove threshold based anomaly devices sites from the database tree that were previously created Synch Device Locations Automatically synchronizes the locations of embedded referenced devices in a pipeline survey with the survey data For example if a survey is re located either upstream or downstream via an editing function any referenced devices would be re located accordingly to stay synchronized with the survey data CIS Exception Report Automatically generates an Excel Spreadsheet report highlighting data falling below the 850mV value by default on one sheet data falling within the 650 750mV range by default on a second sheet and level of polarization data falling below 100mV by default on a third sheet assuming static survey data are available for the line segment The beginning and ending locations of the targeted data are presented as are the reading value and location of the lowest reading recorded within each identified range An opportunity is provided via the window shown below to change the default threshold values 88 CIS Exception Report Polarization Threshold AUY Stress Corro
210. l 21 1 No devices such as test stations are registered during the course of a pipeline survey If this 1s the case 1n the absence of Landmark nodes 1t would not be possible to associate survey data with a line segment node in your database tree In such a case you could create Landmark nodes inside of a line segment folder to represent the start and the ends points of the survey 2 Devices are not registered during a survey at the beginning and or at the end of the survey Ideally devices should be registered on the data logger at the beginning and at the end of a survey as well as at other data collection points along the way for example at reconnection points However this might not always be possible For example a survey may be terminated at a location that 1s between test stations For this example you could create a Landmark node inside the line segment folder to represent the end location of the survey Note In order to view all survey data covering the first station number through the last station number via a line segment or higher level summary folder you must have devices that represent the first and the last locations on the survey In other words devices must bracket the survey in order that the whole survey can be viewed via a summary folder see Section 4 1 5 2 Pipeline Operator Owner Example Let s imaging that the name of your company is Vero Beach Gas Co and that your company 15 res
211. lders in the database tree and also via the Route Manager ProActive will overlay the asset icons onto an aerial topographic or road map of the relevant area Also if GPS right of way data are available the pipeline or pipelines will be overlaid on the map as well except if using Route Manager 13 2 Summary Folders Option By way of example the Sample Data folder in the as received database tree contains a line segment folder labeled VB PL9905 Segment as indicated below 397 Entire Database g Risk Avere Gas Company 2 Sample Data 5 9102005 2 6 17 03 5 9102005 4052 000 E VB Distictd605 E25 Harruville t 2 Harrwville S auth 2 Harrwville North 9905 5 B 1 1 Rectifier ih 1 Test Paint 1 Flange ES Single Test Station ES 1 Test Point 230 1 Sleeve 1 Landrmark ES Reconnect 1 Span ES Reconnect 1 ES Reconnect 1 Clone ES Reconnect 1 Tower Sampling ES Line Crossing w Bar sa MCM_1 T ank PCM 1 mhibitor Injectior _ Ill As indicated in the above window the highlighted line segment is populated by a number of facilities assets GPS location data are associated with each of these facilities In addition as can be seen via the Pipeline Survey Editor see Section 5 of part 1 of this manual GPS
212. les window shown below This window allows you to make modifications to existing rules such as the Annual rule displayed in the example window shown below or you can create new DOT rules that will be available for selection on the Assign page of the Route Manager To make settings changes to any of the existing Rule types you would click on the menu button in the Rule Name field on the window shown below and then highlight the rule name in question Rule Name Annual 373 New Reading periodicity calendar vear s per reading aximium time between readings n5 2 Lead Time m 2 Dayle m X Cancel 319 You could also click on the Update Next Date button which is the button highlighted in the window shown below By doing so whichever Next Reading Due dates you may have entered on the Details Form Readings page of the various devices from your database tree that are now comprising this route will be changed automatically to reflect the Compliance Date you enter here in the Route Manager For such a case each device in a route would assume the compliance date assigned to the route Route Manager Haute Bobs Route ni 54 Setup Assign History Surveys Notes Graph Audit Trail Technician UNASSIGNED Compliance Criteria Compliance D ate E DOT Rule WEEE pu Update all route devices to use rule above Not
213. low 2 Valve B Details Form Location Valve Readings Atmospherics Graph Time Chart Notes Audi Trail Setup Descriptions K Above Ground zi i 4 Above Ground n around Level e History Date Above Ground Condition Corrosion Coating Ground Level Both the Above Ground and the Ground Level atmospheric data types have 3 sub categories of data types associated with them Condition Corrosion and Coating These 3 sub categories actually represent list types and the list items associated with each list type can be viewed via List Manager as discussed above Condition The list items in the present database associated with the Atmospheric Condition list type are displayed in the List Manager window shown below 256 List Manager Select List Shaw Retired List 4 Insert Bad As can be seen from the above window the list item names are Bad Fair and Good These list item names can be replaced with other names by highlighting a list item name and clicking the Replace button and additional list item names can be added to the list by clicking on the Insert button Note The list items displayed under the list type will be presented as selection options via a menu on a data logger screen or on an Excel spreadsheet in the case of manual data entry for the particular sub category data type in question Corrosion
214. lumns plus sign Check off the Survey Date box and click on the Survey Date name which will pull up the Data Item Constraint field shown in the window below 370 eE Database tems J Audit Trail m Dropped file directory Technician owner H Data Logger Prompts mp Reading Rows Ee Heading Columns Site Survey Type Consolidated Remarks m Atmospherics amp Anode 9 Data ltem Constrain ourvey Date cending Enable Date Constraint NULL date From Date gnare Exclude Until D ate C Include Show SOL query text Word g Web Page Check off the Prompt when run box which will allow you to enter a date range for each report you generate when using this report format Scroll down to Rectifier Volts and click on its plus sign Check off the Rectifier Volts On and the Rectifier Volts Remark boxes 371 Database Items Rectifier Amps Rectifier P S Er v Rectifier Volts fw Rectifier Volts Rectifier Volts Off Rectifier Volts Remark Technician Rectifier Volts Technician mp Removal Date Residuals Right Side Drain amp SCI E F1 Sr v Data ltem Constrain survey Date Colurnn z EX suit Descending Enable Date Constraint NULL date From Date Until Date Hal Exclude In
215. lustrated in the above window for example To do 101 so select Delete Series Data rather than Change Series Data This will alter the Graph Mode window as indicated below Graph Mode Normal Move Seres f Change Seres Data 259 56 1 822 The button highlighted in the above window is the Delete Marked Points button and this button is used to delete any points that have been marked for deletion In order to mark a data point for deletion left click on the data point while holding down the Shift key This will result in a line being drawn on the graph as illustrated below for the case of both On and Off data being associated with a station In this case both the Off and the On data points would be deleted Pipeline Survey Editor Survey Selection Graph Text Notes fst Graph alal Station 3 PL CIS On 3 30 2004 Voltage VB PL CIS Off 3 30 2004 Voltage V 1 11 2011 10 29 09 AM 102 After accepting the deletion of points a confirmation window will be presented as indicated below Typically the response to the above question would be No assuming that the stationing was valid and it was just that the data collected at a particular location was not representative of the pipe to soil potential such as contact spike data for example By answering to the above question the offending data p
216. maining downstream facilities to the line segment which in the case of our example line segment are a Span a Valve and a Test Point With these facilities added the database tree window will be as shown below 238 Entire Database E North 1 Line 2 11 Section Rectifier 4 Test Point Bond Galvanic Anode Test Point 42 12 Section B um Compressor Station B valve Bt Test Point B1 Rectifier Bond B Span 2 Test Point B2 a Section C e North 2 Line E South District Step 5 After populating the Section B line segment you would then move on to populating the final line segment in our example which is the Section C line segment with its respective facilities starting with the Meter amp Regulator M amp R Station which 1s another Device Station In our example the Device Station houses 1 Device namely a Test Point You would set up the M amp R facility the same way we set up the Compressor station Facility as described Step 4 You would then proceed to add the facilities that pertain to the Section C line segment and that exist outside of the M amp R facility which in our example are an Insulated Flange a Rectifier a Bond a Coating Transition and a Test Point At this final point the database tree for our example will appear as shown below 239 Entire Database Vero Beach Gas
217. mpressor Station is an example of a Device Station which will typically house a number of Devices from which data will be collected on a route This type of facility has a special hybrid type of folder associated with it which is actually a Regular Summary Folder with an embedded Details Form As shown below one of the pages a facility s Summary Folder is a facility page in our case a Compressor page which itself contains a location page similar to the location page of a Details Form Compressor Station B Summary Folders E Surveys Flags Atmospheric Errors Templates Compressor Remedial Item To do List Farms Risk Models Graph ee Sort Location Notes Audit Trail Mame Compressor Station B Milepost URN Pipeline North 1 Line State FL w eres Area Mame Morth District l Station 52501 Description DOT Class a Soil Type EM Dr BEEN Latitude am Longitde amm Town a Alude Line List 00 0 Installed EE E Retired Tech 55555 Directions As with a line segment it is important to associate the facility with a pipeline You can do so by clicking on the menu button the Pipeline field and highlighting the name of the pipeline In our example the 234 Compressor Station is associated with the North Line The pipeline name will automatically be inserted if you clicked on the Yes button on the confirm window which asked if
218. n Segment of Pipeline North 1 Line ee Gort Hotes T Drag amp Drop File Organizer Folder Name Modified As indicated near the bottom of the above window you can also drag and drop files such as Word documents and CAD files into the information page of a Summary Folder which allows you to associate previously gathered information relevant to the section of pipeline in our example with this node in the database tree Step 8 Repeat the above procedures to create nodes inside of the North 1 Line node to represent its other two sections namely Section B and Section Also repeat the above procedures to add sections to the other three pipeline nodes The database tree will then be as shown below corresponding to the physical pipeline layout structure depicted in the above diagram 218 Entire Database North District E North 1 Line Section Section B Section E North 2 Line Section t Section B Section South District i Ee South 1 Line Section Section B Section e South 2 Line Section Section B Section The above database tree represents our example pipeline company down to the pipeline segment level Step 9 Create Landmarks If you have created line segment folders to represent sections of a pipeline as indicated in the above database tree you ne
219. n button ProActive will restore your backed up database You can then modify the restored database for example by importing new survey data 1 5 Howto Create a Database Tree The starting point in creating a customized database tree 1s to retire the nodes folders associated with the As Received database tree once you ve backed up the As Received database see Section 1 3 above Note An alternative approach would be to leave the Sample Data folder in place and build your database tree as a parallel branch All of the nodes can be retired except the top node However the top node Risk Averse Gas Co can be renamed to suit your own organization see below It is recommended that a database tree be a physical representation of pipeline system which makes associating survey data with certain line segments within the pipeline system a convenient process A major consideration regarding the specific design of your database tree is whether you are a pipeline operator owner or a contractor Both of these scenarios are considered below by way of examples 1 5 1 Contractor Example Let s assume that you have a number of customers pipeline owners who have hired you to perform various survey types such as CIS and DCVG surveys on their pipelines Your customer names in our example would be Customer 1 Customer 2 Customer 3 etc You of course would use the actual company names to identify your
220. n Committee Physical and Maintenance pages Click on each page tab in turn and enter or select the appropriate information Note 2 If the list item that you d like to select for entry into a field having a menu button does not currently exist you can add an item to a list by clicking on Tools on the main menu bar and selecting List Manager Alternatively the List Manager feature can be accessed via the List Mgr speed button highlighted on the menu bar shown below 244 444 Miller ProActive File Edit View Tools Advanced Window Help Reports Route Mgr Send Route Get Reads Surveys SrmyE Find Next click on the menu button in the List Name field and scroll down until you locate the list name that describes the list to which you would like to add an item For example the list items currently available for Rectifier selection in the present database are as indicated in the window shown below Select List Show Retired E za List 4 Insert Air Cooled Current Controlled Dual Rectifier Explosion Proot Oil Immersed Potentially Controlled Retire Delete Replace n Close To add an additional list item click on the Insert button enter a list item name and click on the Save button Rectifier Amps and Rectifier Volts are checked off automatically and cannot be unchecked as these are required readings at rectifiers Yo
221. nation of colors common to both pipe color and map Pipe plus Inverse Map merge Combination of pipe color and inverse of map Pipe plus Inverse Map common Combination of colors common to both pipe color and inverse of map Facilities Checking off the box labeled Facilities will allow ProActive to overlay facility icons for the facilities that have been associated with a folder The particular facility types that are overlaid on an asset map are controlled via a User Preferences selection accessed via the View menu View User Preferences Graphing The facility types to be displayed will be those checked off in the Display Facilities field shown below 412 User Preferences Display 3D Display Station Mumbers Display Points Display Info Month Day Logical ear Begins m T Auta Graph Pipeline Surveys w Display Line Cursor Gap Invalid Readings E Display Facilities v Coating Transition Compressor v Flange v Rectifier Adjust Icon Display By checking off the box labeled Adjust Icon Display icons for facilities that are at the same location or at closely spaced locations will be displaced on the map for clarity This prevents icons from being hidden behind other icons Label The type of labeling to be associated with an overlaid facility icon on a map can be selected by clicking on the menu button in the Label field The menu options are as follows
222. nd typically this value would be in milli volts mV If a shunt factor calculation has been included in the reading template ProActive will calculate the Amps value from the value entered in the spreadsheet based on the shunt factor during the data importation process There are two critical issues with regard to the reading template The first is whether or not the Display this value in mV mA box was checked on the window shown below during the template configuration process Reading Configuration Wizard nm Configuration Settings For Amps Please select all the options below which apply to this value The basis for this value a voltage taken by a data logger or meter The value manually entered into data logger or meter The value displayed the result of formula This value should be flagged when not within an acceptable range This value i normally a negative number Display this value ini Millivolts milliamps etc Display using Magnitude Direction notation This value is required by the DOT Graph this value s history in the device folders Graph this value in the summary folders rJ a rJ rJ Help Nes If this box is not checked as indicated in the above example the reading value entered into the cell should be a Volts value not a mV value This means that if the reading across the shunt is for example 21mV you would enter 0 021 Volts into the cell The
223. nd Level data recorded from a Valve on a particular date 7 1 2004 are illustrated the window shown below 259 22 5SU11 Valve Details Form Location Valve Readings Atmospherics Graph Time Chart Notes Audi Trail Setup Descriptions E Ground Level zi d Above Ground History O A Above Ground Condition F air Corrosion Average Coating Coal Tar Enamel Ground Level Coal Tar Enamel Note When new data are posted for these Atmospheric data types from data loggers or are entered manually a new column of data will appear in the History field under the date the data were recorded Previously recorded data will be moved to the right and the most recently recorded data will appear as the furthest left column of data the History field 4 5 How to Add a non selectable Atmospheric Data Type It should be noted that some devices that have an Atmospherics page associated with their Details Forms do not have an Atmospherics field on their Entity Specific page for Atmospheric data types selection An example of such a device is an Insulating Flange If you have an above ground insulating flange test site you might require Atmospherics data to be recorded at the test site in addition to any readings you may require If this is the case even though the Flange device does not have an Atmospherics field on its Entity Specific page you can still 260 create Atmosp
224. ng Configuration Wizard Configuration Settings for Rectifier Volts Please select all the options below which apply to this value The basis for this value a voltage taken by a data logger or meter The value manually entered into data logger or meter The value displayed the result of formula This value should be flagged when not within an acceptable range This value i normally a negative number Display this value Millrealts milliamps etc Display using Magnitude Directien natation This value iz required by the DOT Graph this value s history in the device folders Graph this value the summary folders This Non value Help lt lt Back fa Note If you want to be prompted to take a reading at a test site of the top two selection options listed on the above window must be checked off If neither of the top two options is selected a prompt for the reading type will not appear on your data logger nor will a field be created in your Excel spreadsheet if you are using manual data entry as opposed to a data logger to record data In this example the top item is checked since the Rectifier Volts reading will be recorded via data logger The box labeled Graph this value s history in the device folder is also checked This means that it will be possible to generate a graphical report of Rectifier Volts data versus reading date
225. nge the survey type for example you could re classify a CIS survey as a static survey for the purposes of having the data used a polarization calculation Reverse Provides an opportunity to reverse the survey data in terms of stationing with respect to various pivot points This function can be used for example if a downstream survey selection was made on the data logger station numbers increasing whereas an upstream survey selection should have been made decreasing station numbers Re date Provides an opportunity to change the survey date 86 Rename Provides an opportunity to change the job name the name given to identify the survey upon importation to the ProActive database Modity Readings Provides an opportunity to apply an arithmetic operation to the survey data The arithmetic operations available are selectable via the window shown below Reading Part Both On C Df Subtract Multiply Divide For example the Invert operation applies a 1 multiplication factor to the survey data which inverts the data turning positive pipe to soil data to negative pipe to soil data for example The other operations require additional information to be provided such as a multiplication factor for example which is entered via a new window shown below for the Multiply selection Modify Readings Action Reading Part Invert f Both t On t Dff Add Subtract C Divide ok Cance
226. nhibitor Injectior ES Reconnect 2 1 Band ES 1 Test Point 3174 r Reconnect 3 1 Galvanic Anode 302 Next you would drag and drop the highlighted devices into the Devices field Haute Bobs Route tts ni E 54 e setup Assign History Surveys Notes Graph Audit Trail escription Devices MCM_1 Rectifier Soe ES Single Test Station include Sub raute LEE 1 Tower ER MCM_1 Bond FN Single Test Station 1 An advantage to having the individual devices in the Devices field 15 that you can exclude any of the devices from a route if required To exclude a device or multiple devices highlight the device s and click on the Exclude Item button highlighted in the window below 303 Route Manager Route BobsRoute o setup Assign History Surveys Notes Graph Audit Trail Description In Devices MCM_1 Rectifier Single Test Station m ur MCM_1 Bond ES Single Test Station_1 Note Devices can be dragged and dropped into the Devices field from any number of database tree line segment folders to build a route Also the top to bottom order of the devices as displayed in the Devices field will be the order that the devices test sites will be presented on a data logger in the test site survey application or on an Excel spreadsheet in the case
227. nomaly Mf Anomaly 7 DCVG amp nomaly 8 Single Test Station 1 Section B Ca North 1 Line Section C North 2 Line E South District As can be seen from the above database tree a total of nine DCVG Anomalies are identified from the survey data This means that nine coating anomalies were marked during the survey the marking process is described in our DCVG Training Manual It can also be seen that the survey began at a test station and ended at another test station This is an ideal scenario with regard to associating data with a line segment folder in a database tree At this point since we have associated the survey data with a line segment we can view the survey data by means of the line segment s Summary Folder Remember if you do not associate any devices with a line segment including landmarks you would have to view your survey data using the Pipeline Survey Editor see Section 5 55 3 3 How to Bring Survey Data into ProActive from Data logger File saved in a Local Folder Assuming that you have copied a survey file to your Local Folder as described in Section 2 you can post the survey data to the ProActive database using the following procedures On the main menu bar click on the Surveys button select the type of Window based data logger that was used to record the data select the survey type and click on the Go button Check o
228. nt Margins t Prnt All Pages t Print Custom fe Margins Page Setup Number of Pages Page Interval 10 020 secs Stark Time End Time 10 020 Detail Margins Screen D e 53h 5 E Preview x Cancel If using a PDF printer driver all printed pages will be associated with a single file as opposed to multiple individual files Find in Tree Conveniently locates the line segment folder in the database tree that represents the line segment with which the highlighted survey has been associated in the ProActive database Note At least one device including a Landmark device is required to have been associated with the line segment folder in the database tree for the Find in Tree feature to be utilized Landmark in Tree Allows ProActive to create Landmark devices the database tree to represent the start and the end of the highlighted survey Align Graphical Report Opens the Graphical Report Function see Section 6 and presents the window aligned with the Pipeline Survey Editor window on the screen The Graphical Report Function will have the pipeline with which the survey is associated pre selected and will have the station number range of the highlighted survey also pre selected 93 Update Report Exclusion Allows a highlighted survey to be excluded from use in the generation of future graphical reports and maps By clicking on the Yes button on the above Conf
229. nt folders of the line segment folder For example in our example the pipeline survey data can be viewed via the folder representing the Harryville North area 71 Harryville North Summary Folders presented by double clicking on the Harryville North folder in the database tree Templates Compliance Flagging Information Remedial Items To do List Models Graph SUV ES Atmospheric Errors CS Mame Drag amp Drop File Organizer Folder RO Name 0 0 0 Modified Next click on the Surveys page tab on the above window and select the appropriate pipeline _Franks Line pipeline in our example case by clicking on the menu button in the Pipeline Location field and highlighting the name of the pipeline The Surveys page will be presented as illustrated below 12 Harryiille North Summary Folders Templates Compliance Flagging Information Remedial Items To do List Models Graph Surveys Atmospheric Errors Fipeline Locatian Start Series End Series _ Franks Line Start Station 2694 78 End Station 2706 77 Curent Mapper Surveys Depth of Cover Surveys Soil Resistivity Surveys Pig Surveys alaj Polf Points LS Next check off the survey types and the actual survey data to be graphed in each case as described above Next click on the Graph button
230. o MCM Drag amp Drop File Organizer Folder NEM Size Type Modified Attributes This will pull up the window shown below for this example ve PL9905 Segment Summary Folders Information Remedial Ite Style Non compliant test sites Override Lead Time ation 9 bas z Next click on the menu button in the Query Style field highlighted in the above window and select the Non compliant test sites option Note The other options in the menu represent other query options the basis of which would depend on the settings associated with 322 the particular DOT Rules that would be in effect for the devices that are associated with the selected folder Next click on the highlighted Refresh button the Green colored button on the above window This will result in a display of all devices test sites that are currently non compliant for this example query option and that are associated with the selected folder For our example the window shown below is displayed VB PL9905 Segment Summary Folders Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors E Templates Compliance Flagging Query Style Non compliant test sites Y Ini From Show Query SOL Station 0 Day s cs 9 Non Compliant Date Non Compliant Days DOT Rule Reading Pipeline Station MCM_1 Bon
231. o the container window below Harville e Close Previous gt Next Next click on the Next button on the above screen which will pull up the window shown below 307 Filter Wizard Selection via Device Type Check the types of facilities and devices to include in the filter tree n Lie Rectifiers ES Test Points n LE Flanges n B Valves n m Bands EB Sleeves ER Spans BE Towers E Anomalies Coating Transitions m Im Compressors e Close For example if we would like to filter the database on Rectifier devices only we would check off the Rectifier box as shown below Filter Wizard Selection via Device Type Check the types of facilities and devices to include in the filter tree Test Points ES Flanges Valves m Bands n Sleeves het Spans BE Towers Anomalies n Ea Coating Transitions Bf Compressor 308 Note Multiple device type selections can be made the above window if you would like to filter the database on multiple device types Clicking on the Next button on the above window will pull up the window shown below 288 Filter Wizard Ready to Run Query Your filter criteria is now all setup and ready to run If you desire to export this filter to disk press the Export Filter button below Then press the Apply button to create your filter Export Filter Private Owner
232. o view the example survey data again 2 3 Howto Backup a Database You can choose which folder location on your PC or your network system to use to store your database backups A database backup 1s created using the following procedure Click on the File menu top left hand corner of the screen Click on Archive from the drop down menu and select Backup A window will be displayed labeled Select ProActive Archive 209 Select a folder in which to save the copy of the database by identifying folder in the Save field perhaps a newly created ProActive Backups folder inside your My Documents folder for example Next provide a file name for the backup and click on the Save button Your file name might include the date of the backup for example which would be a useful identifier ProActive will generate a copy of your database a paz file which is similar to a zip file compressed file which you can restore at anytime using the procedure outlined in Section 1 4 below 2 4 How to Restore a Backed Up Database You can restore backed up database including the As Received database or any of your own creations by performing the following procedures Click on the File menu top left hand corner of the screen Click on Archive from the drop down menu and select Restore A window labeled Select ProActive Archive to Restore window will be displayed Identify the folder in which y
233. ocation on your hard drive or network system in the field underneath The example window shown below 16 for the GathererOne G1 data logger GathererOne Driver Pipeline Survey PRISES Get Pipeline Survey from Gatherer Une IF vau have already moved your survey data to the desktop computer check Use Local Folder and select the folder where it is located Use Local Folder iw Copy To Local Folder CAS Refresh Connection Select the survey to upload then click on Go ate 30 Version 2 02 2 Minimum GathererOne Version 1 0 0 Also if you used the metric system on the data logger check off the box labeled Use Metric Click on the Go button 41 You can now post the survey data to the ProActive database as described in Section 3 2 or you can do so at any time via the survey file now saved in your local folder as described Section 3 3 SECTION 3 HOW TO BRING SURVEY DATA INTO THE PROACTIVE DATABASE 3 1 Introduction It is suggested that you set up a folder on your PC s hard drive or network system in which to permanently save survey files that are either directly copied via a driver from a data logger connected to your PC or that you receive from your field personnel Windows based data loggers only It is suggested that you call this folder something like Survey Files ProActive refers to this folder as your Local Folder Each supported data
234. ociated with in your database and whether or not Devices including Anomalies in the case of DCVG surveys will be created in your database tree By way of illustration let s return to our Pipeline Operator Owner Example see Section 1 5 2 50 Now let s assume that the pipeline survey was DCVG survey performed on the Section A line segment of the North 1 Line pipeline In this example our objective 15 to associate the survey data that we bringing into ProActive with Section A of the North 1 Line Job field Enter a descriptive name for the survey in the Job field for example Section A 2011 Note It is not necessary to include the survey type for example CIS in the Job name as the survey type is associated with the survey data ProActive Line field select the pipeline on which the survey was performed via the menu button in the Line field If the pipeline name 1s not available click on the page icon and create a new pipeline In our example the pipeline name would be the North 1 Line Alternatively you could drag and drop a line segment node from the database tree into the Line field to represent the pipeline in question Note The line segment node must be associated with a pipeline via the line segment s Summary Folder see Section 1 5 2 Step 7 Series field Unless you had set up a station series type of system you would leave the series f
235. of manual data entry The order presented in the devices field can be rearranged if required via the drag and drop procedure Example 3 Use of the Filter Function Another approach to building routes is to utilize the Filter function that allows you to have the database tree filtered such that only the device types you are interested in for the creation of a particular route will be displayed in the filtered tree all other devices will be filtered out To use this method you would first click on the Filter button the main menu bar highlighted on the window shown below 304 File Edit View Tools Advanced Window Help A A A A Route Mgr Send Route Get Reads Surveys Sry Editor Find ListMor Templates This will pull up the Filter Wizard window shown below The Filter Wizard allows you to display a tree containing only a subset of the ProActive database In the list below choose the filtering options you wish to use and Drop from ProActive tree BiDevice Type Route Membership ocation Related Criteria EDOT Compliance Criteria Folder Type BlFlagging PowerUser Use a SQL script Al Caption fit Import Filter Description As can be seen from the above window you can apply various filter criteria to your database tree In our example we would check off the Drag and Drop from ProActive tree box and the Device Type
236. oints would be removed and the stationing would not be altered This result is illustrated in the window shown below for the above example Pipeline Survey Editor Survey Selection Graph Text Notes fet Graph alal 2 e z Station a VB PL CIS 3 30 2004 Voltage V VB PL CIS Of 3 30 2004 Voltage V 11 2011 11 38 02 AM Data points that have been marked for deletion can be cleared by clicking on the Clear Marked Points button which is highlighted in the window shown below 103 Graph Mode Normal Move Seres Change Seres Data 353 53 1 783 Data Translation To translate survey data en mass select Change Series Data Translate and 15 on the Graph Mode window With these particular selections your data can be translated with respect to the x axis station number axis To translate survey data left click and hold on any data point and move the data point to a new station location Release the hold when you are satisfied with the new location It might be useful to perform a data re alignment operation with respect to another survey data set For example a survey data set may contain a known reference location and you may wish to re locate a second survey data set in order to match up to that reference location To do so select both surveys on the Survey Selection page by highlighting one of th
237. onal arrow button Finally you would click on the Update button which would update the highlighted Survey Type with respect to applicable reading types prompts Returning to the Reading Configuration Wizard After assigning survey types to your reading type you would click on the Next button on the Reading Configuration Wizard window which will pull up the window shown below 274 288 Reading Configuration Wizard Configuration Settings for Rectifier Volts Results outside the Acceptable Range will generate a flag which will be displayed in the enclosing Summary Folders Flag criteria Masimum ha rico aximum difference 30 sy from previous value P Edit values in millivolts milliampa etc Help The above window is used to set up a flagging criterion for reading values In the above case a Maximum difference from previous value has been entered in the highlighted field of 30 What this means in this example 1s that a flag will be associated with a Rectifier Volts reading value that differs from the previous value recorded at this rectifier by more than 30 Next click on the Next button which will pull up the window shown below 219 288 Reading Configuration Wizard Configuration Settings for Rectifier Volts Technician Instructions For Reading aka Hookup Helpi Help Show Audit Trail lt lt Back Using the above window you can enter a set of ins
238. onfigured as a system of folders within folders see Section 5 Step 7 Repeat the above procedures to create nodes inside of the Oil Line node for its other two line segments namely Section B and Section C Also repeat the above procedures to create four line segment nodes for the Gas Line 17 database tree will then be as shown below corresponding to the physical pipeline layout structure depicted in the above diagram Entire Database OBL ENERGY Customer 1 amp Line Section Section B Section C Gas Line Section Section Section Section D Customer 2 Customer 3 Customer 4 Customer 5 Customer Step 8 Create Landmarks If you have created line segment nodes folders to represent sections of a pipeline as indicated in the above database tree you need to provide some means of identifying at least the starting location of each section A convenient way to do so 15 to insert a so called Landmark node inside of each line segment folder and to provide the Landmark node with an identifying station number A Landmark can be considered a type of Device in ProActive to which we can associate a station number and a pipeline If there is an actual Device physically located at the beginning of a line segment for example such as a test station and readings are collected at the Device a Landmar
239. ooters and Overlays are handled since other properties such as the colors used to graph particular data types series and 141 control of axes scales pre established during the design process for each graphical report format created see Section 6 3 Our focus in this section then will be on Titles and Overlays Graph Property Editor In the case of Graphical Reports the Property Editor is accessed via Reports Generate Graphical Reports Report Click on the menu button adjacent to the Graph button on the Graphical Reports window and select Property Editor Graph Property Editor Properties Mame cls WIOOMY shift exceptions EN Private New Remove Titles Axis Legend Series Overlays oDEFAULT Prompt Fant Color Transparent Frame Footer v visible DEFAULT o Prompt Font Color uA Transparent Frame Cancel To create a new graphing style option a new set of graph properties it is recommended that you first clone one of the pre existing graph properties and then edit the cloned properties under a new properties name In such a 142 case you would be cloning which ever set of properties are currently displayed and identified in the Properties Name field Example Creation of Bobs Graphing Style as a new set of graphing properties Click on the New button on the Graph Property Editor win
240. or The menu items are displayed by either right clicking on a highlighted survey or by left clicking on the Menu button with a survey highlighted The Menu button 15 highlighted on the Pipeline Survey Editor window shown below 85 Pipeline Survey Editor Survey Selection Graph T ext Mates Pipeline Start Series End Series Franks Line Start Station 2694 78 End Station tt E 05 78 c 5 Wwe E Bas FMA Line North 1 Line Franks Linie Altitude ML2 Alt b 28 20 03 2544 78 b 1z7 2003 2694 78 Curent Wapper MLZTK 1385 b 28 2003 2594 78 2 2024 DCYG 6 17 2003 2584 78 27056478 Depth of Cover 2 1836 b 2B SU 3 2594 78 2706 78 GFS right of way 2024 GPS b 2003 3584 78 2706478 Fig ML2TK 1335 b 20 2003 2584 78 2706458 Sail Resistivity ML2TK 1396 B 20 20 3 2594478 2705478 _ICDA Line 1 _ICDA Line 2 _ICDA Line 3 _ICDA Line 5 T A brief description of each menu item follows View Graph View Text Same result as clicking on the Graph and Text page tabs as described above Delete Deletes the highlighted head record job date pipeline from the database See the Purge option for actual survey data deletion Relocate Provides an opportunity to 1 change the starting station number for the survey data 2 relocate the survey data to a different pipeline and 3 cha
241. or example a Landmark 1s represented by a red flag icon see above database tree window One of the pages common to all Details Forms regardless of the type of entity 1s the location page which can be seen displayed in the above window Of critical importance on the location page are the pipeline name and the station number or milepost associated with the entity a Landmark in our example To select the pipeline name you would click on the menu button in the Pipeline field and highlight the name of the pipeline which in our example would be the North 1 Line 222 Next you would manually enter the station number or milepost for the Landmark to represent its location on the pipeline You can then apply the above procedures to use Landmarks to define the beginning of each line segment in your database tree SECTION 3 HOW TO POPULATE YOUR LINE SEGMENTS WITH FACILITIES Having set up your database tree to represent your pipeline system using the procedures described above you are ready to populate your line segments with Facilities depending on which entities are of significance on each of your particular line segments As defined below there are 3 classes of Facilities Devices Device Stations and Special Feature Elements Before discussing the procedures involved with populating your line segments here are some definitions 3 1 Definitions Facility Types Devices Devices are test sites
242. or manual data entry purposes Having done so a technician would be directed to each device test site 1n turn on a route in a prescribed order and would be prompted to collect the appropriate data either readings or visual observations at each test site on the route 206 When current data collected route are posted to the ProActive database the current test site data are integrated with previously posted historical data Consequently a historical record is built up over time making reporting and management of cathodically protected pipeline systems an efficient and accurate process SECTION 2 HOW TO ORGANIZE YOUR PROACTIVE DATABASE 2 1 Database Tree Folder Types There are two gateway folder types that are used in the database tree The Regular Folder and the Line Segment Folder Regular Folders are typically used to represent your company as a whole as well as to represent any major divisions and or areas in your company In addition pipelines themselves can be represented by Regular Folders in cases where pipelines are sub divided into various line segments Line Segment Folders are typically used to represent sections of a pipeline but can also be used to represent whole pipelines At the line segment level various icons known as Facility icons are used to represent various entities that are associated with the line segment including Devices test sites at which data are collected such a
243. or new readings Read Date 27204 Automatic Next Import Export wf Send to ProActive data collected on the test site survey can be viewed via the Route Data Entry window In addition the data can be edited as required Should the data be edited the database can be updated by clicking on the Send to ProActive button on the above window after any editing 1s performed 364 SECTION 11 HOW TO GENERATE TEXTUAL REPORTS BASED ON TEST SITE DATA 11 1 Introduction ProActive 15 delivered with a number of textual report formats that have been included as standard formats from which you can make your selection or you can design and save your own textual report formats using the Ad Hoc feature 11 2 How to Design and Save a Textual Report Format 1 Click on the Reports speed button main menu bar M C Miller ProActive View Tools Advanced Window Help m DY l Find Route Mgr Send Route Get Reads surveys Srvy Editor Filter Listhigr Templates This will pull up the window shown below 365 Select the report you want to use Design Mew Report Bobs Anomaly Report Format D CV Anomaly Report Pipeline Survey Report Site GPS Report Report L ategaries Standard Reports Adhoc Reports Graphical Reports lt lt Back gt gt 2 Click on the highlighted Design Edit Report radio button on the above window and
244. or the above example Data types Series can be restricted if required in the case of test sites on a line segment having multiple data types multiple reading types associated with them Series restriction can be achieved via an Editing feature To access the Editing feature click on the menu button associated with the Graph button on the above window and select the Edit Graph option This will pull up the window shown below 394 Editing gphChart Chart Series ata Tools Esport Prnt eres General Bs Titles Legend Fanel Paging Walls lt gt ees Pipe to Soil i m Pipe to Soil Franks Franks P58 Casing to Sal Tile Casing to Sail Clone Change For our particular example all series were un checked with the exception of the Pipe to Soil On and Off series As discussed above in Section 12 2 other edits can be made via the Editing feature such as axis scaling titles etc Should CIS data be associated with the line segment a graph such as that illustrated below can be generated by clicking on the highlighted Diagnostic page tab and clicking again on the Graph button This will result in the presentation of a CIS graph in addition to the test site readings graph Also shown are the facilities populating the line segment Facilities such as test sites can be located t
245. ou have saved your database backups in the Look in field click on highlight the database you d like to restore and click on the Open button ProActive will restore your backed up database 2 5 How to Create a Database Tree The starting point in creating a customized database tree 1s to retire the nodes folders associated with the As Received database tree once you ve backed up the As Received database see Section 2 3 above All of the nodes can be retired except the top node However the top node Risk Averse Gas Co can be renamed to suit your own organization see below 210 Example Let s imaging that the name of your company is Vero Beach Gas Co and your company is responsible for pipelines in 2 main districts the North District and the South District Let s also imagine that within the North District you have two main pipelines the North 1 Line and the North 2 Line and that within the South District you have two main pipelines the South 1 Line and the South 2 Line Finally let s imagine that each of the four main pipelines is made up of three pipeline sections named Section A Section B and Section in each case Note If you do not have a pipeline that is divided up into sections you would treat your entire pipeline as a Line Segment But if you do have identifiable sections associated with a pipeline each section of the pipeline would be considered a Line Segment of
246. our network system to use to store your database backups A database backup is created using the following procedure Click on the File menu top left hand corner of the screen Click on Archive from the drop down menu and select Backup A window will be displayed labeled Select ProActive Archive Select a folder in which to save the copy of the database by identifying a folder in the Save in field perhaps a newly created ProActive Backups folder inside your My Documents folder for example Next provide a name for the backup click on the Save button Your file name might include the date of the backup for example which would be a useful identifier ProActive will generate a copy of your database a paz file which is similar to a zip file compressed file which you can restore at anytime using the procedure outlined in Section 1 4 below 1 4 How to Restore a Backed Up Database You can restore a backed up database including the As Received database or any of your own creations by performing the following procedures Click on the File menu top left hand corner of the screen Click on Archive from the drop down menu and select Restore A window labeled Select ProActive Archive to Restore will be displayed Identify the folder in which you have saved your database backups in the Look in field click on highlight the database you d like to restore and click on the Ope
247. ow Reading Configuration Wizard Configuration Settings for none selected Select Template to edit or enter a new template A Revet to Non Unique Template Curent Settings 265 Example Rectifier Volts Reading Template To view the Rectifier Volts reading template click on the highlighted menu button on the above window and scroll down to the desired reading template name Reading Configuration Wizard Configuration Settings for none selected Select Template to edit or enter a new template name Curent Settings Standard Reading Template DOT required reading Single Value range 200M Direct Current at Sine 400 impedence Flagged if differs by Help gt gt The nature of the reading template for a given reading type whether it be a standard or a localized template is summarized in the grey shaded field of the first page of the Reading Configuration Wizard As indicated on the above window the Standard reading template for the Rectifier Volts reading type 1s a single value with a voltage range setting of 200V DC Also the reading 1s to be flagged if the current value differs from the previous value by more than 30 The reading 1s also indicated as a DOT Required reading Click on the Next button on the above window to step through the various configuration settings for this standard reading template 266 ad Readi
248. ow shown above This will pull up the window shown below ffi Editing Chart Series Data Tools Export Print Series General Titles Legend Panel Paging Walls Visible Scales Title Labels Ticks Minor Position Eehnd M Automatic Visible Inverted Axes Change Desired Increment 1 Right Axis Logarithmic Log 10 E Bottam Axis Depth Axis M aeimum Ako 16 4 Offset 0 et Next click on the highlighted Minimum page tab and click on the highlighted Change button you will be changing the minimum value on the y axis scale from the automatically selected value of 16 4 based on the reading values This will pull up the window shown below Minimum Left Axis Value E Cancel For our example we have entered a minimum value of O replacing the 16 4 value 388 Clicking the button the above window will pull up the window shown below Edi Editing 11 Chart Series Data Tools Export Print Series General Axis Titles Legend Panel Paging Walls lt gt Visible Scales Title Labels Ticks Minor Position Behind 7 Automatic vw Visible Inverted Change Desired Increment 1 Logarnthmic Log Base 10 m Minimum M asimum 27 9 Led Offset 0 Next click on the highlighted Maximum page tab and click on the highlighted
249. ow shown below depending on previous settings Data Logger Manual Data Entry Roue Bobs Route Survey Type mud ex Technician UNASSIGNED Override Logger Prior Type m Weather UNASSIGNED Description Start Date Last Date Status READY Include Atmospherics Current Interruption As was the case for the Excel spreadsheet generation method you would then select Manual Data Entry in the Data Logger field by clicking on the menu button and making this selection 348 Next you would select the Route name by clicking the menu button in the Route field and the Survey Type You can also select a Technician name if required via the menu button in the Technician field Next you would enter the type of weather condition you are encountering during your route by clicking on the menu button in the Weather field and making your selection from the list provided Note The weather options list can be edited using the List Manager via the Weather Encountered list name Next you would make an entry in the Description field Note This is an important entry as you will be effectively naming your test site survey here Since you will build up a history of test site surveys done on a particular route over time you might want to develop a naming system for surveys associated with a particular route As 15 discussed in Section 10 you will be able to
250. ow to Design and Save a Graphical Report Format 113 6 3 How to Generate a Report using a Saved Graphical Report Format including a standard CIS Exception Report 130 6 4 How to Export a Graphical Report to a File an Enhanced RERO EET tant 132 6 5 How to Print a Graphical Report including how to incorporate a company logo amp how to edit graphs prior to printing 133 6 6 How to Create amp Save Graphing Styles 141 Continued Over SECTION 7 HOW GENERATE TEXTUAL REPORTS USING THE AD REPORT DESIGNER dad 167 7 2 Data Type Considerations 4 4 167 7 3 How to Design and Save Textual Report Format 171 7 4 How to Generate Report using a Saved Textual Repon POLIUS V Eod pie x Od Ser 180 SECTION 8 HOW TO GENERATE ASSET MAPS VIA SUMMARY FOLDERS amp DATABASE TREE GATEWAY FOLDERS Sl ioco se wana nta d 183 8 2 Summary Folders Option 183 6 3 Database Tree Folder OPUON ass eotr rer eter EE EET ES 187 els orae 187 8 5 Asset Map Presentation Options 189 0 2 Map Data SOUTCES 190 5
251. pears selecting Folder you will be creating a Regular Summary Folder to represent the North District A folder node will be inserted into the database tree one hierarchical level below the top node This folder will represent the North District and all lower level nodes associated with the North District will eventually be contained within this folder see above hierarchical diagram Next right click on the North District node and select Create Node by left clicking on it Select Folder and this time enter the name South District Again you will be creating a Regular Summary Folder You will see that a second folder node called South District has been inserted into the database tree underneath the North District node at the same hierarchical level This folder will represent the South District and all lower level nodes associated with the South District will eventually be contained within this folder see above hierarchical diagram At this point the database tree will be as shown below 213 Entire Database North District South District Step 4 Create folders nodes for the two main pipelines in the North District North 1 Line and North 2 Line Right click on the North District node and left click on Create Node Left click on Folder and enter the folder node name North 1 Line Note If you will not be identifying sections on your pipelines your pipelines themselve
252. pipeline colors are Yellow Red Lime Blue Fuchsia Aqua and White Irientatian Fixed Bearing Ow Follow Pipeline in El degree increments Overlays Pipeline E Thickness Color Pine Color Made Facili Adjust Icon Display Compass Distance Label Distance 33333 Feet Max Separation The example below illustrates a case where two independent pipelines have been overlaid on a map with one pipeline colored yellow and the other pipeline colored red Entire Database ME Folder Map wW mr Sn 00 4 84 2 2d f AES WD v E Laclede C2 2 4 gt gt 2 2 1 cm gt gt M 7 N 38 10 gt gt 12 Maile to Patterson 13 2 14 N 16 2 N 17 Brown ta Humes 22 N 18 2 18 west Spur 20 gt 24 880 Line ma Cd P id ror ail 1 m 41 Mode Clicking on the menu button in the Mode field will reveal a number of choices regarding the overlaid pipeline color relative to the map color A user can experiment with the various options in order to arrive at an optimum presentation An explanation of each option 1 as follows Pipe Color Pen color specified Color property Inverse Map Pipe color will be the inverse of the map color Pipe plus Map merge Combination of pipe color and map color Pipe plus Map common Combi
253. ponsible for pipelines 2 main districts the North District and the South District Let s also 1magine that within the North District you have two main pipelines the North 1 Line and the North 2 Line and that within the South District you have two main pipelines the South 1 Line and the South 2 Line 22 Finally let s imagine that each of the four main pipelines 15 made up of three pipeline sections named Section A Section and Section in each case Note If you do not have a pipeline that is divided up into sections you would treat your entire pipeline as a Line Segment But 1f you do have identifiable sections associated with a pipeline each section of the pipeline would be considered a Line Segment of that pipeline Pipeline surveys such as CIS and DCVG surveys are to be performed on each of the sections of pipeline and we need to associate survey data once collected with the appropriate database tree nodes line segment nodes The company s hierarchical structure which will be reflected in our example database tree representation 1s illustrated below 23 Vero Beach Gas Co South District North 1 Line North 2 Line South 1 Line South 2 Line SEC Sec Sec 5 Sec sec Sec Sec Sec Sec Sec gt C A B C A B C Physical Pipeline Layout Structure for Database Tree Creation Note In the above example the North 1 Line and the North 2 Line are exclusiv
254. reference To review the data collected on a particular test site survey you would double click on the survey in question in the above history field which will pull up the Data Logger Get Readings window shown below Note The field entries will depend on your route specifics 362 Data Logger Get Readings iin Data Logger Manual Data Entry Survey Type anual Technician UNASSIGNED Override Logger rome VW eather Clear Description MDE CS 11 2 2004 Start Date 12222004 Last Date 1 12222004 Next check off the Include Atmospherics and the Current Interruption boxes located in the highlighted area on the above window if you would like to view atmospherics data if any such data were collected and if On Off pair reading values were recorded 1 the rectifier current was interrupted during the test site survey By clicking on the Go button on the above window the Route Data Entry window shown below 16 displayed for our example test site survey 363 Sitelof17 Site SU11 Rectifier 4 14 Prompt 1 of 3 Prompt Amps 4 On Max Off Min Technician Remarks Condition Corrosion Coating SU11 Rectifier 384 5 000001000000 M 2 7200 MDE 11 2 2004 SU11 Rectifier Previous Amps 1384 5 Em Remarks MDE 11 2 2004 Edit values in their normal display units Propose prior remarks f
255. rict node left click and hold on the South Line node and drag it on top of the South District node When you release the hold the South 1 Line node will be re positioned Right click on the South 1 Line node and repeat the above procedure to create a node for the South 2 Line The South 2 Line 16 at the same hierarchical level as the South 1 Line so re positioning would not be necessary in this case At this point the database tree will appear as shown below 215 Entire Database 2 North District gt gt North 1 Line North 2 Line E South District 2 South 1 Line 2 South Z Line Step 6 Create folders nodes to represent the sections comprising each of the four main pipelines The example below illustrates the process of adding a section Section A to the North 1 Line pipeline Right click on the North 1 Line node and left click on Create Node Left click on Line Segment since this node will be for a segment of a pipeline By selecting Line Segment rather than Folder you will be creating a Line Segment Summary Folder this time Enter the name of the section in the Add Line Segment window The first section name in our example will be Section A A new node named Section A will have been inserted into the database tree underneath the North 1 Line node at the same hierarchical level To re position the Section A node one hierarchical level below the North
256. rt shown below the text supplied by ProActive by default is the name of the pipeline selected for the report and the current date which is positioned underneath the pipeline name 152 sce X 00 FENE ala us Jpn L J F p Eze jus r1 ETT APS wea rens SES UGE S Store Be deese ms Coq sea A war Pipeline 1 13 2011 For the example selections made as indicated in the window shown below in the Footer field Frame the footer yellow color for the frame background and the example graphical report becomes as shown below Note By selecting to be prompted to enter footer text prior to printing you have the opportunity to change the text from the default selected text In this example case the name of the pipeline was changed for illustrative purposes only to Bobs Pipeline 153 Titles Axis Legend Series Overlays Titl Visible COMPANY Prompt Font malar Transparent Frame Transparent Cancel 154 W a 4 aare Jus J oc HUI AIA 53 15 sao rs Eze jus r1 ETT 3 uF SES UGE S Store Be As was the case with the Title by clicking on the Font button in the footer field the window shown below will be pulled
257. ry Folder that appears the database tree 1s different from that of a Regular Summary Folder see database tree window below 28 Step 7 Associate the section Section A in example with its pipeline the North Line in our example You can do so by opening the line segment s Summary folder and clicking on the Information page tab Note You can open a Summary Folder either a Regular Summary Folder or a Line Segment Summary Folder by double clicking on the folder icon or on the folder name Next you would click on the menu button in the Segment of Pipeline field and highlight the pipeline with which the segment is associated If the pipeline with which you d like to associate the segment 16 not listed in the drop down menu you can click on the page icon button at the far right of the Section of Pipeline field and enter the name of the pipeline of which the segment 15 a part in the Create New Line window that appears The Summary Folders window for this example is shown below 29 ad Section Summary Folders Templates Compliance Flagging Information Remedial Items To do List Models Graph SUV ES Atmospheric Errors Section Segment of Pipeline North 1 Line ee Gort Hotes T Drag amp Drop File Organizer Folder Name Modified As indicated near the bottom of the above window
258. s Report Format 3 3 New s s Remove Report Details fw CIS Data Er v DEVI Survey Data Report Entity Detal Percent Reading Data Style You also select to display the Percent data as a line graph or as a bar graph bar graph chosen in this example by clicking on the menu button in the Style field and selecting Line or Bar 127 Finally check off the Percent Data group box to switch on the Percent IR Data group At this point in our example report format creation the Report Details field will be as shown below Graphical Report Designer Report Mame bobs Report Format 373 New Report Details w WebService Iw CIS Data iw CIS On if LIS Off Negatrve Threshold Line iw DCVG Survey Data lw DCG Iw Percent lA Data Iv Percent Report Group Percent Data Lett Axis From Date Automatic Fight Axis To Date x Cancel Left amp Right Axis Fields These fields can be used to enter axis label names for each axis for each Group To do so click on the Group name and then enter an axis label name in the appropriate field For example the label Voltage has been 128 entered for the left hand axis in the case of the CIS Data Group as shown in the window below Graphical Report Designer Report Mame Bobs Report Format New
259. s Test Points Test stations Rectifiers Bonds Insulated Flanges Valves etc Database tree development see below is basically the process of creating folders and Facility icons in order to represent the physical layout of your pipeline system or systems Once your database 15 organized you access the posted data via the Device icons in the database tree which act as gateways or portals to the stored test site data 207 2 2 The As Received Database When you first install ProActive and you open the program by double clicking on the ProActive icon a window labeled Entire Database will be displayed on your desktop This window displays your As Received database starter database and illustrates the folder types discussed above Note Your As Received database may not appear exactly as shown below but may be a variation of this example Entire Database Se Fisk Avere Gas Company E Haryyville 2 Harrpville South Marks Line 135 Risky Line Test Harryyville North Franks 2 Line The example line segment names are Marks Line Risky Line and Test which are part of the Harryville South Area and Franks ML2 Line which is part of the Harryville North Area Both the Harryville North and the Harryville South Areas are part of the Harryville District and the Harryville District is a region covered by the Risk Averse Gas Company 208 This example dat
260. s initiated by clicking on the button on the above window For the above example the Pipeline Survey Editor window will be displayed as indicated below 98 Line He FMN HGFS 11 23 2003 0 00 00 CIS FMM_ICDA_CIS 410 200 55 11 CIS IRC FMN MGPS 11 23 2003 0 00 00 Depth of Cover Depth 413 200 55411 P3438 GFS right of way 5 GPS 11 23 2003 0 00 00 Altitude FMMN MGPS Altitude 11 23 2009 0 00 00 CIS FMM Town amp B CIS S 3 2010 4595 08 4308 61 GFS right of way Tewn amp B CIS S 3 2010 4595 08 4308 61 5PZ ughtabaay Tome Stats ABB 4535 08 4306462 Static Tot Satis ABB 4535 08 4306462 Altitude GPS 4 19 2007 56 11 P 3 38 GFS right of way ICD GPS 4 19 2007 56 11 3 39 GPS right of way Static Re aligned 2252010 4535408 4308452 Static FMM Towrnd B Static He aligned 2252010 4535408 4308452 As indicated in the above window the name assigned to the re aligned survey the static survey 1s the name that was entered the New field on the Snap Survey using GPS window Also the original Static survey information 15 still displayed however a line has been drawn through the survey and its associated GPS survey Purge Deleted Surveys When a survey is deleted using the Delete menu item described above the head record job date pipeline is deleted and removed from view in t
261. s should be represented by Line Segment Summary Folders rather than by Regular Summary Folders If this is your situation you would left click on Line Segment rather than on Folder during this step A node will have been inserted in the database tree underneath the North District node at the same hierarchical level To re position the North 1 Line node one hierarchical level below the North District node left click and hold on the North 1 Line node and drag it on top of the North District node When you release the hold the North 1 Line node will be re positioned Right click on the North 1 Line node and repeat the above procedure to create a node for the North 2 Line The North 2 Line 16 at the same hierarchical level as the North 1 Line so re positioning would not be necessary in this case At this point the database tree will appear as shown below 214 Entire Database h Gaz Co District 2 North 1 Line 2 North 2 Line South District Step 5 Create folders nodes for the two main pipelines in the South District South 1 Line and South 2 Line Right click on the South District node and left click on Create Node Left click on Folder and enter the folder node name South 1 Line A node will have been inserted in the database tree underneath the South District node at the same hierarchical level To re position the South 1 Line node one hierarchical level below the South Dist
262. sections of a pipeline as indicated in the above database tree you need to provide some means of identifying at least the starting location of each section A convenient way to do so 15 to insert a so called Landmark node inside of each line segment folder and to provide the Landmark node with an identifying station number 31 Landmark be considered a type of Device in ProActive to which we can associate a station number and a pipeline If there 1s an actual Device physically located at the beginning of a line segment for example such as a test station and readings are logged at the Device a Landmark and the Device can co exist the database tree at the same location same station number The relationship between Landmarks designated ProActive and actual sections associated with a pipeline is illustrated the figure shown below Landmark Landmark Landmark Start of Start of Start of section section B section C Use of Landmarks in ProActive to define Line Segments If we perform a pipeline survey on Section A of the North 1 Line for example we would like the survey data to be associated with the appropriate line segment node folder in the above database tree ie the Section A node The following procedure can be applied to establish a node representing a Landmark inside of a Line Segment node The example is for Section A on the North 1 Line Example Right click on t
263. setup information O 00 0 01894 1400 0 03788 2400 0 05682 3 00 ee Anomales lt lt Back Finish Finally when all imports have been added to the batch click on the active Batch Run button The x button can be used to remove an import from the batch prior to having ProActive perform the Batch Run SECTION 4 HOW TO VIEW SURVEY DATA GRAPHICALLY VIA THE GATEWAY FOLDERS IN YOUR DATABASE TREE 4 1 Introduction Pipeline survey data that have been associated with line segments in the ProActive database can be viewed via the folders in the database tree that represent the line segments or their parent folders see Section 1 5 As an example in the Sample Data in your as received database pipeline survey data have been associated with a segment of the _Franks Line 66 pipeline called Franks ML2 Line which is associated with the Harryville North area of the Harryville district The line segment folder Franks ML2 Line is highlighted in the database tree shown below Entire Database Risk Avere Gas Company amp Sample Data MCM CS_ 9102005 1 6 17 03 m MCM CS_ 9102005 4052 000 e VB DistrictS805 i Harry ville 25 Harpvile South Harryville North PL9905 5egment Franks SL 1 Segment 2 Franks SUI 14 Sige Franks ML2 Line ih Single Test Station DLV Detect DEVI Defect 1 Mf DV Defect 2 Defect
264. shown below page icon 15 inserted into the cell when a Remark is associated with a reading The remark can be viewed by double clicking on the page icon or by hovering your mouse over the page icon Test Rectifier Details Form Location Rectifier Readings Anodes Graph Time Chart Mates Audit Trail Setup Descriptions Amps zi ij Reading Setup History Date 1 21 2011 28 zi Compliance DOT Rule UNASSIGNED Nest Reading Que Note When current data new data are posted to the database for these reading types by downloading from data loggers or Excel spreadsheets for this particular rectifier a new column of data will be displayed in the History field under the date the data were recorded Previously recorded data will be moved to the right and the most recently recorded data will appear as the furthest left column of data in the History field 296 SECTION 7 HOW TO CREATE A ROUTE USING THE ROUTE MANAGER FUNCTION including the use of the Filter Function amp Application of DOT Compliance criteria Now that you have set up your database tree populated your tree with various test sites devices and selected the reading types and atmospheric types if appropriate for each of your device types as well as the reading templates for each reading type you are in a position to create routes A route is a grouping of devices test sites from which data are to be collected in a coordinated fas
265. sion Cracking Range 650 Low Potential Threshold 850 Negative Voltages w Report Voltage Units fe C Woks Survey Data Units C Milivalts Volts The CIS Exception Report is generated by clicking on the button on the above window CIS Detail Report Rather than having an exceptions report generated as above all pipeline survey readings be presented in a CIS Details report including device readings such as those collected at reconnects and regular test stations during a CIS This report also presents Static data 1f available for the line segment and calculated level of polarization data There are a number of parameters having certain default settings that relate to which data Static and GPS can be utilized 1n association with CIS data the CIS data represents the driving force with respect to the use of other data calculations etc The default settings can be changes via the window shown below which is displayed prior to a CIS Details report being generated 99 CIS Detail Report Close Interval Survey Data interpolate Values Maximum Match Distance Static Survey Data Interpalate Values Maxinum Match Distance 5 feet Match Time 9999 days GPS Survey Data Interpalate M alues Li Maximum Match Distance 1 feet Maximum Match Time 1 days Report Voltage Units Survey Data Units Milliealts f Volts x Cancel Batch Print Wav
266. st dad 365 11 2 How to Design and Save a Textual Report Format 365 11 3 How to Generate a Report using a Saved Report Format 375 11 4 How to Generate a Report using a Standard Report Format 380 SECTION 12 HOW TO GRAPH TEST SITE READINGS DATA I2 IrtfOGUGUOllss iot eue 382 12 2 How to Graph Readings on a Test Site Basis 384 12 3 How to Graph Readings on a Line Segment Basis 392 Continued Over leaf 204 SECTION 13 HOW GENERATE ASSET MAPS VIA 13 1 152 13 3 13 4 13 5 13 6 13 7 SUMMARY FOLDERS DATABASE TREE FOLDERS amp ROUTE MANAGER E Satis 396 summary Folders Option 397 Database Tree Folder Option 401 Manager ERAS 401 Overlatd cues evoca 404 Asset Map Presentation Options 406 15 021 Map Data 407 122022 bed 408 Overlay 410 Printme an Asset MD sooo SER OU 414 205 SECTION 1 INTRODUCTION This part of the training manual Part 2 provides an introduction to the use of ProActive for
267. stance traveled The locations on the survey where anomalies were marked and the anomaly parameters determined are indicated on the graph as DCVG Anomalies As can be seen from the above window a graphical representation of the survey data is extremely useful with regard to immediately identifying potential problem areas Excel Spreadsheet Option An option exists at this point particularly if you do not plan to post the data to the ProActive database which 15 to export the survey data out of the Driver in the form of spreadsheets This can be done by clicking on the Export to Excel button on the Driver window and selecting a folder on your hard drive in which to save the exported file The name of this file 1s what you would enter in the Save As window 49 How to Post the Survey Data to Your ProActive Database Close the Driver window which will reveal the Data Logger Get Pipeline Survey window as shown below Data Logger Get Pipeline Survey Job Survey Location Distance Ref Feet relative Line ni Station H Direction Create ON Anomalies Create OFF Anomalies 155 Create DCP Devices Include Station Create DCP Readings _ _ Create Pipeline Features This window is very important as the information you provide here will determine which line segment your survey data will be ass
268. survey on the CompactFlash memory card on the data logger and you can copy survey files to your PC using one of two approaches manually or via the data logger driver in the ProActive program If you have the ProActive software program installed on your PC and you have access to the data logger you can use ProActive to automatically access survey files on the data logger In this case you would proceed to Section 2 3 If you do not have access to the data logger you can have field personnel copy survey files to their PCs and they can send you a copy of the files via email for example If this 1s the case you would have the field personnel follow the steps outlined Section 2 2 Note In order to copy survey files from a data logger to a PC either manually or via ProActive the Microsoft ActiveSync software program is required on your PC for Windows XP or earlier operating systems or Windows Mobile Device Center for Windows Vista or later operating systems 2 2 Manual Approach This process would pertain primarily to field personnel who are responsible for sending survey files to a recipient who has ProActive installed on their pc 36 Step 1 Establish a connection between your data logger and your PC Note The details of the connection will depend on the data logger type and the operating system of your PC Step 2 Follow the procedures detailed below for your particular data logger Gx Data logger
269. surveys associated with a particular route using the Manager The start date the date that data were recorded at the first test site on the route and the last date the date that data were recorded at the last test site on the route will be posted automatically as read from the spreadsheet file Finally check off the Include Atmospherics box if you recorded visual observations data on your test site survey and check off the Current Interruption box 1f the rectifier current during your survey was switched On and Off otherwise leave this box unchecked When all of the above entries have been made you would click on the Go button on the above window which will pull up the Route Data Entry window shown below 343 IB Bobs Route Route Dota Site 1 of 26 Site 1 Wale Pipeline Pipeline Milepost 3 8331 Station 2D 7 5 gt Franks Site Dey Specific processed hbdr hd Prompt 1 of 1 Prompt Pipe ta Sail Range 5 V dc Sing 400 impedence 4 gt l Electrode Copper Sulfate Normally Negative Site Prmt On MaOFf MiqDate Technici Remarks 1Vave Pipe to Soil MCM VMBeciier Amps 0 0 0 o MCM TBeciier ___ 1 Aertfier line Current MCM_1 Valve Pipe to Soil On 4 Pipe to Soil Off Remarks Tech UNASSIGNED Iw Edit values in their normal displa
270. t The Surveys field the Data logger Driver window will list all of the pipeline survey files currently stored on your particular data logger s CompactFlash memory card Highlight the survey file that contains the data you would like to post to the ProActive database Also place a tick in the box labeled to Local Folder and identify the folder s location on your hard drive or network system in the field underneath The example window shown below is for the GathererOne G1 data logger 44 GathererOne Driver Pipeline Survey Get Pipeline Survey fram Gatherer Une IF vau have already moved your survey data to the desktop computer check Use Local Folder and select the folder where itis located Use Local Folder iw Copy To Local Folder CAS Refresh Connection Select the survey ta upload then click on Go ate 30 Version 2 0 2 2 Minimum GathererOne Version 1 0 0 Also if you used the metric system on the data logger check off the box labeled Use Metric Click on the Go button You can now post the survey data to the ProActive database as described in Section 3 2 or you can do so at any time via the survey file now saved in your local folder as described in Section 3 3 Step 5 Examine your survey data prior to posting the data to the ProActive database It is recommended that you examine your survey data prior to posting the da
271. t w Points n Survey Readings Jj aur BUCH LET BH Plal4 aas r ungeapul i7 B sajo _UONELS 158 1 uis o 2910 4 aas WOE IU pd i e 2700 00 Station M2TK_2024 6 17 2003 Voltage V M2TK 2024 6 17 2003 Voltage V 1 5 2011 12 00 23 PM 81 Also by clicking on the Text page tab the data can be presented textual form as illustrated below Pipeline Survey Editor Survey Selection Graph Test Notes Export zi Show Station Hs 2694 78 1 2705 Single Test Station 2694483 1 2843 2694 58 1 2036 2694 93 1 2796 2694 95 1 2792 2695 03 1 2777 2695 08 1 2704 2695 13 1 2608 2695 185 1 2773 2695 23 1 2704 2695 285 1 2637 9695 31 212525 4 If desired the data can be exported to an Excel file by clicking on the Export button on the above window 5 1 1 How to View Photographs Downloaded from the Gx Data logger Photographs taken using the integrated camera on the Gx data logger at random locations during a pipeline survey and in association with designated geo features can be viewed via the Notes page in the Pipeline Survey Editor while photographs recorded in association with devices such as test points can be viewed via the Notes page on the devices Details Forms and via the Notes page in the Pipeline Survey Editor The Notes page tab on the Pipeline Survey
272. t readings data graphically the Graph this value option or options must be selected via the reading template configuration wizard for each reading type you might want to graph see Section 5 for information on the reading template configuration process As highlighted in the window shown below there are two check boxes having to do with graphing readings data Graph this value s history in the device folders and Graph this value in the summary folders Reading Configuration Wizard Configuration Settings For Fipe to Soil Please select all the options below which apply to this value The basis for this value a voltage taken by a data logger or meter The value manually entered into data logger or meter The value displayed the result of a formula This value should be flagged when not within an acceptable range This value is normally a negative number Display this value Millrealts milliamps etc Display using Magnitude Directien natation This value is required by the DOT Graph this value s history in the device folders Graph this value in the summary folders 382 With both of these boxes checked it will be possible for ProActive to graph the reading type data associated with this particular reading template on both a test site basis reading value versus reading date and a line segment basis reading value versus stationing In some instances in may make sense to c
273. t size and font color 15 and whether or not the text letters are outlined a particular color control Note Specific text can be excluded by entering that text in the Exclude field Text items entered singularly or in a delimited list will not be displayed Example The text elements associated with the Remark Overlays shown on the graph below were controlled by the settings indicated on the above window 160 visible text originating from the top angled at 270 with the letters outlined in black ink The font selections were as indicated below This is an OpenType font This same font will be used on both your Genera Bobs Reput Format Senes Ppeline Locahon Pipeline Saat Station 3 2650 67 End Station 2 155 52 Stat Ece 9 9 St Poets into Fine CIS Data C19 14 crs Line 135 pF NK i dd codec 4 i LUNA FAR By changing the control settings to those indicated in the window shown below visible text originating from the bottom angled at 90 with no letter outline and the Font color changed to RED the text appears as indicated in the graph shown below 161 Properties M ame E Graphing Style Remove Titles As Legend Seres Uverlays Private Overlay Type Remarks Visible Exclude Labe Remarks 0 Pos
274. ta to the ProActive database currently you are in the data logger Driver section of ProActive 45 do so click the Driver window currently positioned behind the Data Logger Get Pipeline Survey window The Driver window will present a selection of page tabs labeled as follows Survey Settings Readings Device Readings and Graph By clicking on these page tabs you can view information on the survey conditions settings or you can view actual survey readings either in spreadsheet form or displayed graphically By clicking on the Survey Settings page tab on the Driver window you can view a listing of all the selections that were made for the survey during the data logger s set up process By clicking on the Readings page tab a window showing the recorded survey data will be displayed For instance the window shown below shows example DCVG survey data downloaded from a DA Meter data logger Ell DA Meter Driver Pipeline Survey Survey Settings Readings Device Readings PLS CVG Voltage DCVG Voltage On Voltage Off Comments DCP Feature DCvG L Longitude Altitude 0 0052 Single Test Station 35 76506 91 16557 261 0256 0 0007 0 0050 0 0061 0 0111 0 0085 0 0000 0 0031 0 0050 0 0057 0 0061 0 0078 0 0063 0 0127 0 0160 0 0174 0 0249 0 0357 Anomaly 35 70524 91 16545 261 679 0 0327 0 0202 0 0106 Ll Flag 35 70029 91 16542 2
275. tandard template depending on which template is the next higher level template 291 SECTION 6 HOW TO MANUALLY INSERT HISTORICAL READINGS DATA You can manually insert historical readings data 1f available the History field of a Readings page to establish reference data to which newly acquired readings data can be compared for flagging purposes for example For example if you have Rectifier Volts and Rectifier Amps data for a rectifier that you collected previously on a certain date you can enter these data the history field to establish benchmarks for these values using the following procedure First you would double click on the Rectifier node in the database tree which would open the Details Form for that particular rectifier You would then click on the Readings page tab Next you would click on the calendar icon in the History field located to the immediate right of the Date field and you d select the date on which your historical data were recorded in our example this date 1s January 21 2011 Next click on the Insert Reading button which 1s the button located to the right of the calendar icon This will pull up the window shown below 202 22 Test Rectifier Det Form o E ene Location Rectifier Headings Anodes Graph Time Chart Mates Audit Trail Histor Date 1 21 2011 5 RMU id DOT Rule Next Reading Que To enter data double click
276. ted survey s Do you want to open them for printing As indicated the above window the number of waveforms that are associated with the selected CIS survey is indicated By clicking on the Yes button on the Confirm window each waveform graph will be presented one window for each In our example waveforms were recorded at test stations named Manhole 70 and Manhole 71 Test Station w AC 91 amp Manhole 70 amp Manhole 71Test Station w Points Rematks Abe Times Manhole 71Test Station w AC Channel 1 5s 12 23 2008 16 36 13 16 36 23 020 Offset Generated 1 5 2011 11 08 21 AM As indicated below a Print Batch option 15 available via the menu button associated with the Graph button when Print Batch Waveforms has been selected 5 Manhole 70 ns __ x J amp Manhole 71Test Station w iH Points E Remarks Abs Time Print Batch iole 71Test Station w AC Print Graph Channel 1 Export Image Export Text Edit Graph Property Editor i Default Clicking on the Print Batch option will bring up the Graph Printing dialog and its settings will apply to all prints that will be printed in order 92 Graph Printing Options Company Logo D f Print Curre
277. th site specific data By way of an example let s consider the case of designing a DCVG Anomaly textual report This is an example of reporting on site device specific data First let s examine the data that are created by ProActive for DCVG Anomalies marked during a DCVG survey These data are accessible via Anomaly gateway 1cons in the database tree assuming that ProActive created such anomaly devices and anomaly readings during the process of posting DCVG survey data to the database see Section 3 2 167 Example A particular DCVG Anomaly device icon is highlighted in the database tree illustrated in the window shown below Entire Database VB Distict605 i 25 Harrvville South i e North tu vB PL33Us5 Segment Franks 5011 5 gt Franks 51114 tu Franks ML Line Single Test Station 2694 78 2 2024 DLVG Detect Defect 1 Defect 2 DV Defect 3 DLVG Defect 4 Defect 5 Defect DV Defect DLVG Defect 8 ES Single Test Statian 1 2r 06 r8 MZTK 2024 Double clicking on the device icon opens the Details Form for the anomaly as illustrated below 168 Location Anamal Setup Descriptions E Percent V Drop ta Remote Gradient On Off r History Date JA l C V Diop to Remar
278. that pipeline The company s hierarchical structure which will be reflected in our example database tree representation 1s illustrated below 211 Vero Beach Gas Co South District North 1 Line North 2 Line South 1 Line South 2 Line SEC Sec Sec 5 Sec sec Sec Sec Sec Sec Sec gt C A B C A B C Physical Pipeline Layout Structure for Database Creation Here s how to set up a database tree for this example Step 1 Assuming that you have backed up the As Received database see Section 2 3 you should retire all of the nodes up to the top node in the As Received database tree Alternatively you can leave the Sample Data folder in place and build parallel branches of the tree To retire a node right click on the name of the node or on the folder icon and left click on Retire Node Step 2 Rename the top folder top node You should rename the top folder node to be the company name in this example Vero Beach Gas Co 212 rename node right click on the name of the node or on the folder icon and left click on Rename Node Enter the desired folder node name Step 3 Create folders nodes for the North District and the South District By right clicking on the top node Vero Beach Gas Co you can select Create Node by left clicking and then left click on Folder and enter the name North District the enter name window that ap
279. the Graph button and select the Edit Graph option The window shown below will be displayed Since we do not need to edit the Bottom Axis in this example click on the No button This will pull up the window shown below Since we plan to edit the CIS Data graph we would click on the Yes button on this window This will pull up the Editing window as shown below 138 Chart Series Da Ep Print Seres Genera L CIS On Labels Add bx Iw CIS Ot Negative Threshold Line Delete Padding Title Mu jw Clone Change 2 Click on the Axis page tab the above window This will pull up the Axis page as shown below Chart Series Data Tools Export Print Series General xis Titles Legend Paging WW alls Visible Scales Title Labels Ticks Minor Position Behind Automatic Visible Inverted Axes Change Desired Increment 0 2 Right Asis Top Axis Battam ysis 5 Lag Base 10 Depth Offset E 3 Highlight the Left Axis option click on the Minimum tab highlighted above and click on the Change button This will 139 4 provide the opportunity to change the minimum voltage value for the scale from the default value Minimum Voltage In
280. the operating system of your PC Step 3 Double click on the ProActive icon on your PC s desktop screen This will open up ProActive s menu window M C Miller ProActive File Edit View Tools Advanced Window mm Find Filter Reports Route Mgr Send Route GetR List Mgr Step 4 Click on the Surveys button highlighted on the above window the menu bar This will open a window labeled Data Logger Get Pipeline Survey as indicated below 39 Data Logger Get Pipeline Survey Data Logger Survey Type Status READY Click on the menu button in the Data Logger field and highlight the type of data logger from which you are copying the survey file Next click on the menu button in the Survey Type field and highlight the survey type Finally click on the Go button Note It may take a few seconds for the data logger Driver window to appear particularly if you are using a serial connection Step 5 select the Survey File to be copied to your PC 40 The Surveys field the Data logger Driver window will list all of the pipeline survey files currently stored on your data logger s CompactFlash memory card Highlight the survey file that you would like to be copied to your PC Also place a tick in the box labeled to Local Folder and identify the folder s l
281. the reading take the millivolts volts Multiply by fi ampsz mw shunt Factor andor Add electrode offset Test your adjustment factors her Haw mv becomes Help x Back 262 As indicated on the Current Settings field for our Rectifier Amps reading template the value displayed 15 the result of a calculation As indicated in the highlighted area on the above window the current setting takes the mV value read across the shunt and multiplies that value by 1 Amp mV What this means is that if the voltage reading across the shunt was 25mV the displayed Amps value would be 25 Amps If the shunt on the rectifier is not a 50 50 shunt shunt the shunt factor the multiplication factor in the above window would need to be changed For example the window below illustrates changing the shunt factor to 0 5Amps mV ad Reading Configuration Wizard Configuration Settings for Amps Adjustments to raw voltage for shunts and electrodes Before displaying the reading take the millivolts and volts Multiply by 10 4 shunt factor andor Add n m electrode offset Test your adjustment factors here Haw becomes Help lt lt Back gt gt In the above case the same 25mV reading across the shunt will result in a displayed value of 12 5 Amps rather than 25Amps Note The abov
282. tifier Amps P S Calculated injection rate pints per Rectifier volts D hlande MG L Corrosion Deposits Corrosion Fate Corrosion Coupon Coupon Size Dissolved LU Dissolved EH Check Probe ER Probe H Far Ground Reading Far Milepost Fe2L3 x Final Weight Franks P58 Franks Tare amp nnde tn Snil Include Driving Directions Add Hookup Help Hints u OK x Lancel The reading type templates that are listed in the field labeled Fixed Columns will represent the headings of the columns that will appear in your spreadsheet and these headings will appear in a left to right order as they are listed top to bottom in this field You can add column headings to the Fixed Columns field by dragging and dropping items from the Reading Templates field and you can remove headings from the Fixed Columns field by dragging and dropping them into the Reading Templates field 334 Example Let s say that you wanted ProActive to generate an Excel spreadsheet having 3 column headings corresponding to the 3 reading types that will be involved with your test site survey namely Rectifier Volts Rectifier Amps and Pipe to Soil In this case you would clean up the Fixed Columns field leaving only the required types The result of such a clean up selection process would be as shown below Customize the spreadsheet by
283. tion C North 2 Line South District Step 2 Double click on the Rectifier A node This will open the Details Form for this entity which contains a number of different pages including a location page The specific pages that will be associated with a Details Form will depend on the nature of the entity itself For example entities for which data are to be collected in the field known as devices can have a readings page or an atmospherics page or they can have both a readings page and atmospherics page in addition to the pages that are common to all facilities other than Device Stations which are treated separately In contrast entities identified on a line segment for which data are not to be collected in the field do not have either a readings page or an atmospherics page associated with their Details Form Examples of such entities would be Sleeves and Coating Transitions If you ll be adding a number of facilities to a line segment that will share common information on their location pages it is a time saving measure to on the location page of the first entity you create fill out whatever information will be common to each of the entities on the line segment For example the Details Form for the Rectifier A device is shown below 228 2 Rectifier A Details Form Location Rectifier Readings Anode Graph Time Chart Notes Audit Trail
284. tion number that was used on your data logger to represent the start of a survey You can do so by examining the readings data in the Driver section of ProActive see above If you see that the starting station number that was entered on the data logger 15 the actual starting station number on the pipeline for example 524 80 you would select the Station Number Absolute option via the menu button in the Distance Ref field On the other hand if you see that a starting station number of 0 00 was entered on the data logger to represent the start of the survey which actually started at station number 524 80 you would select the Feet Relative option in the Distance Ref field and you would enter 524 80 the Station field You can do so by typing in 524 80 or you drag and drop a Landmark having a station number of 524 80 into the Station field Create Anomalies Devices Etc Finally since we are bringing in DCVG survey data in this example we are not interested 1n CIS related anomalies and so the top 4 check boxes in the Get Pipeline Survey window should be un checked 52 We however interested having ProActive create DCP Data Collection Point Devices in the database tree if they currently do not exist and appropriate DCP reading prompts to support DCP readings data if they currently don t exist for each Device type that we encountered and for which we took readings on o
285. tioning will be shown on the overlaid pipeline at intervals matching those of the bottom graph axis stationing axis Feet Max Separation The manually entered value in the Feet Max Separation field will represent the maximum separation between pipeline data points for line Joining purposes 8 6 Printing an Asset Map Asset Maps can be printed directly from the Asset Map window via the Map Menu button highlighted the window shown below 2 ie QA Mazi 7 Folder Map VB PL9905 Segment i WOW IN 2644 LE 1 04 1591 1 WO WOW adig pasodx3 6 0 1ulog1s8L L WOW 0 89 jutodis8l L WOW ys WOW pauuosay 14109 591 WOW o ju g Wow B i 4 Pd p di gt FANE A 40596 1 0414681 WOW uod 181 L WoW EE oes 4015 Wd W a uogaafu aoydiyul WOW E Li E E 18 eAA gt wo Cro julodisal L CE BBE 4 ant e set E b i 2 Left click on the Map Menu button and select the Print Map option The Print Header window shown below will be displayed This window provides an opportunity to name the asset map Enter a suitable name and then click on the button 197 Print Header i Ex VB FPL9905 5 egment
286. tions button on the Site Information window that will appear on your data logger s screen Driving directions will also appear on the Excel spreadsheet in the case where a spreadsheet 15 created for manual data entry 230 purposes assuming that the Driving Directions option is selected during the spreadsheet creation process Step 3 Right click on the Rectifier A node left click on Create Node and left click on the facility name that describes the next facility on the line segment which in our example is a Test Point A window will be displayed labeled Test Point Enter a name for the test point device in the field on this window For example you might use the name Test Point A1 for the first test point on the Section A line segment since we have two test points on this line segment we need to have different names for these sites For example we could name this first one Test Point AI and the second one located more downstream Test Point A2 As before in the Rectifier example we could elect to use the actual station number of each Test Point in our naming convention So for example if the Test Points were located at station numbers 1542 00 and 304 00 we could name them 15 00 Test Point and 304 00 Test Point The Test Point Al device node would be inserted below the Rectifier node in the database tree at the same hierarchical level You can leave the facility nodes
287. tmospheric Errors C15 Templates Compliance Flagging QQ _ 0 0 10d i581 L WOW FE WON puog L WOW E i Won E F Y a T 2 15 1 apelo uoneis 1891 8 8 6 WoW 1 0411581 een ZS 22E Mlodisal L WOW 6 02 1 WOW 3 uogaafuj 10 gtuul L E 3 E adig pasodx3 ji CE BBE 18lj283 WIW Fi Buijduues 181eAA 1 m i 4 we unu o gt 4 26 WUIOd 1581 L WOW above map is an example of 100 road map Map 0 please note the box labeled Map highlighted in the above window By changing the numerical value in the Map box to 100 the map is presented as a 100 aerial map as illustrated below PL9905 Segment Summary Folders l Information Remedial Items To do List Risk Models Graph Surveys Atmospheric Errors Templates Compliance Flagging Q E Map 100 _ 028 it 1 70 Wr 5 P SE 212 Ee NUS Be 9 d P 2 9 E 9 ATA QUEEN W ETT Ag genet wn ae 4 4 oe i 1 e E A 2 M 2 4 j oe 7 M r F 7 _puigulestraye DT 7 NT mar 5 E
288. to enter important information about the valve for your future reference in the Valve Info field 254 Note 2 If the list item that you d like to select for entry into a field having a menu button does not currently exist you can add an item to a list by clicking on Tools on the main menu bar and selecting List Manager Alternatively the List Manager feature can be accessed via the List Mgr speed button highlighted on the menu bar shown below ff M C Miller ProActive File Edit View Tools Advanced Window Help 4 Reports Route Mor Send Route Get Reads Surveys Srvy Editor p Find Next click on the menu button the List Name field and scroll down until you locate the list name that describes the list to which you would like to add an item For example the list items currently available for Valve selection in the present database are as indicated in the window shown below Select List List B all Gate Plug Retire Delete Replace ff Close 255 add an additional list item click on the Insert button highlighted above enter a list item name and click on the Save button If you select both the Above Ground and Ground Level Atmospheric data types the Atmospherics page accessible by clicking on the Atmospherics page tab on the above Details Form will be as shown be
289. ton and highlight one of the standard report formats in the list for example Latest Readings or Readings History 3 Click on the Next button 4 The next screen will depend on the particular standard report format that you selected For example if you selected Latest Readings you would be asked to select devices from the database tree upon which to base your report or to select the route and hence the route devices upon which you d like to base your report 380 For example Let s report the latest readings associated with selected devices test sites in the database tree Drag and drop devices from your database tree into the open field and click on the Next button select a restricted date range if required Also select pipeline restriction if required and then click on the Next button select one of the following options Fixed columns only Fixed columns plus custom others or Fixed columns plus all others With Fixed columns only you are given the opportunity to select the reading templates for which data will be reported and in this case no other data will be reported With Fixed columns plus custom others you are given the opportunity to select the reading templates for which data will be reported in the main columns and you can also select the additional reading templates that you d like to have included in an other column With Fixed
290. tructions text regarding how the reading should actually be taken hook up instructions If an entry is made here the instructions will be downloaded to your data logger and they can be accessed by tapping on the Help G1 data logger or Hookup Help DA Meter buttons on the prompt screens see your data logger s User s Manual If hook up instructions have been downloaded for a particular prompt reading type the data logger button would be active on the prompt screen otherwise it will be inactive Note Currently Hookup Help instructions are not accessible on the Excel spreadsheet option Finally click on the Finish button The window shown below will be viewed by re opening the Reading Configuration Wizard via the Templates button and selecting the Rectifier Volts reading type via the menu button 276 ad Reading Configuration Wizard Configuration Settings for Rectifier Volts Select Template to edit or enter a new template name Hectifier vals Fever to Non Une Template Standard Reading Template DOT required reading Single Value range 400 Direct Current at 75 MOhri impedence Flagged if differs by 30 Current Settings As can be seen from the above window in the highlighted Current Settings field the only change from the original settings is that we identified a particular target data logger we selected a voltmeter channel
291. ts by dragging and dropping the column headings For example you could present the survey database in terms of survey type rather than in terms of pipeline as shown above by dragging the heading and dropping it on top of the Pipeline heading 79 With the survey database presented as shown above you can view the surveys that have been associated with a particular pipeline by clicking on the plus sign associated with that pipeline name For example the surveys that have been associated with the _Franks Line pipeline are indicated in the window below 288 Pipeline Survey Editor Survey Selection End Series Pipeline Start Series Start Station End Station 271 Pipeline Tye Job Stat End xj xj Line Marth 1 Line Franks Line Altitude ML2 Alt CIS M2TK 2024 MLZTK 1895 2 2024 Depth of Cover 2 1385 GPS night of way 2 2024 GPS Fig 2 1996 2 1835 5 28 2003 671772003 6 28 2003 7 2003 5 25 2003 671772003 5 20 2003 b 20 2003 Current Mapper Sail Resistivity 2694 75 2694 75 2534 8 2694 78 2694 75 2694 75 2534 78 2694 75 2r b 78 2 578 2 b 8 2r b 78 2r b 78 2r b 78 2 5458 2 54 78 ICDA Line 1 ICDA Line 2 ICDA Line 3 ICDA Line 5 Icom 1 As can be seen from the above window the surveys are presented in t
292. ty e Parish Bltude D 20433911 Long 32708068 FranksTown ow Alitude 633081488 Depth 8 123456 UNASSI Line List 13 Installed E This Facility on other pipelines Retired f E Directions Next to By clicking on the Map page tab highlighted on the Route Manager window shown below the facilities comprising the route each of which has associated GPS location data are overlaid on a map 314 Haute Babs Route ni E eM T Setup Assign History Surveys Notes Graph Audit Trail Map Description Devices MCM_1 Valve MCM_1 Rectifier MCM_1 Test Point MCM 1 Flange Single Test Station MCM_1 Test Point_230 22 MCM_1 Sleeve MCM_1 Landmark Reconnect lk MCM_1 Span Reconnect ES Reconnect 1 Clone Reconnect lE MCM_1 Tower 1 ater Sampling ine w Rond Example Maps shown below Include Sub route Exclude Item 315 0 a ram E a UR UD L 2 F FM ji tt T 1B gt a Lal SOE eI Ti d Dr d E d 1 MERS i BRL SE a aH Mell apo ILEUS Da 100 Aerial Map ge E FL m
293. ty to enter location information on the Details Form location page of Rectifier B that will be common to the subsequent entities that will be added to the line segment downstream of Rectifier This is a time saving measure as the common information will be entered automatically on the location pages of the subsequently added 231 facilities and you will only have to add any unique information such as station number for each subsequently added facility Alternatively you could use the Batch Update Location function as described above once you have all facilities added to the line segment You would then add the next downstream facility to the line segment which in our example is a Bond by right clicking on the Rectifier node left clicking on Create Node and left clicking on Bond A window will be displayed labeled Add Bond Enter a name for the bond device in the box on this window For example you might use the name Bond B for the bond on the Section B line segment If you have more than one bond on a given line segment you would need to have different names for each site For example if you had 3 bonds on the Section B line segment you might name them something like Bond B1 Bond B2 and Bond B3 When you click on the OK button on the Add Bond window the Bond B device node would be inserted below the Rectifier B node the database tree You would then proceed to add the re
294. u can if you wish check off any of the other boxes reading type selections in the 245 Readings field or you can create additional reading types to suit your own requirements see Section 4 3 With only the Amps and Volts reading types selected automatically selected in this case you would have two prompts for this test site In this case the Readings page accessed by clicking on the Readings page tab of the Details Form would be as shown below 2 Rectifier A Details Form Location Rectifier Readings Anode Graph Time Chart Notes Audit Trail Setup Descriptions p Volts zi ij E Reading Setup History Date Amps Volks Compliance DOT Rule UNASSIGNED gt Next Reading Que E Note You can reverse the reading type order to be prompted to record Rectifier Volts first and then Rectifier Amps by clicking on the red arrow buttons located in the Setup field shown on the above window 4 3 How to Add a non selectable Reading Type If a particular reading type that you require for a particular device 15 not offered in the reading type options list supplied with your version of ProActive the reading type offerings for a given device are presented on 246 the device specific page of the Details Form you can add a reading type to the setup field on the device s readings page The procedure to add a reading type would be as follows with reference to the Gal
295. uish between the stacked graphs particularly since the scales are so different in the CIS and DCVG data cases Finally check off the DCVG Data group box to switch on the DCVG Data group 124 Report Mame Bobs Report Format Remove Report Details lI Map E ve CIS Data E rAOCWG Survey Data Report Group DV Survey Data Lett Axis From Date Automatic Fight Axis Ta Date x Cancel d Right click the Percent Data group and select Add Entity Next click on the left side menu button in the Site Reading field select Latest then click on the right side menu button and select DCVG Percent IR and click on the hand icon to insert the entity 125 Survey Types oea tt Actual Surveys gt Site Readings Latest Calculations 3 Features 2 Fref Constants Report Name Bobs Report Format 3 3 New s Remove Report Details uar Gl fw CIS Data Er v DV Survey Data Report Group Percent lA Data Lett Axis From Date E Automatic Fight Axis Ta Date E X Cancel 126 Next left click on the newly created DCVG Percent IR entity which will pull up the Report Entity Details field You can select a color for the Percent IR data by checking off the Use Color box and choosing a color ad Graphical Report Designer Report Hame Bob
296. umber as part of the name The Landmark node will now be located inside of the Line Segment folder At this point the database tree will appear as shown below 220 Entire Database p Vero Beach Gas i 2 North District I C North 1 Line O Section A Start of Section Section Section Ee North 2 Line Section Section B Section i f South District e South 1 Line Section Section B Section 9 South 2 Line Section section Section Next double click on the Landmark icon or on the Landmark name which will open the Details Form representing the Landmark device The window shown below will be displayed 22 22 Start of Section A Details Form Mame Start of Section A 000000000000 Milepost bo o Fipeline Noth 1 Line State 3 BrIes e Ace Station 0 00 Description Pn a Is Sail Type of Pag Latitude Longitde amm Town PDegn 4 000 Installed NE E Retired E Tech Be Directions A Details Form has a number of pages associated with it the specific number of pages depends on the nature of the entity represented by the Details Form A Details Form is represented the database tree by an icon of some type not a folder style icon and each entity is represented by a different icon F
297. umber of different defects that were marked during this example survey The data presented for each defect occupies 2 rows and is as follows Row 1 Max mV Total mV IR Row 2 Max mV ON Max mV OFF 0 0000 In addition based on the polarities of Max mV ON mV OFF the corrosion states of the defect both with CP current ON and with CP current OFF are presented in row 2 in the comment column as shown above For example for the defect located at station number 2699 the data are as follows Row 1 19 3mV 44 24 25 Row 2 11 7mV 7 7mV 0 0000 Also the corrosion states Cathodic Anodic which means that the CP current is protecting the defect site however in the absence of CP current the defect site would be a corrosive site in this example Finally by clicking on the Graph page tab the window shown below 15 displayed for this example DCVG survey data 48 Ell DA Meter Driver Pipeline Survey Download Survey Settings Readings Device Readings PLS Graph E S alal gt Stat w Points C 3 m Ca r e tn en ic Voltage V Voltage V A EL o Uy ere ere ere zr annt 2702 50 Station Z DCG 5 20 2004 12 35 14 PM The above window shows a graphical representation of the DCVG survey data for our example survey Since this was a Perpendicular DCVG survey the anomaly locations show as peaks in a plot of DCVG voltage versus di
298. up allowing you to change the font font style size and color for the footer 155 This OpenType font This same font will be used on both your printer and your screen Click on the OK button on the above window to save font changes Finally click on the highlighted button on the window shown below to save all of the edits made via the Titles page 156 Graph Property Editor bE Properties N ame Bobs Graphing Style EN Private New 7 s Remove Titles Axis Legend Series Overlays Title Visible COMPANY iw Prompt Font Color i Transparent Frame Footer v visible DEFAULT o iw Prompt Fort Color i Transparent Frame Modify Overlays Properties The properties associated with any text that 1s overlaid on graphs can be modified via the Overlays page in the Graph Property Editor for a given set of graphing properties given graphing style To do so click on the Overlays page tap highlighted in the window shown below Note Text 1s overlaid on a graph by checking off the box labeled Info on the Graphical Reports window 157 Properties N ame Bobs Graphing Style EN Private 273 New Titles Legend Serie Overlays Overlay Type Anomaly iw Visible Exclude Label Visible Anomaly Position Angle Top f Bottom f 270 90 45 Text
299. ur DCVG survey Consequently the Create DCP Devices and Create DCP Readings boxes would be checked in our case Note By checking off the box labeled Include Station ProActive will include the station number in the device name when each device 15 created The Create Pipeline Features box should also be checked as this represents the geo features data that was registered on the survey Had our example survey type been a CIS we could have elected to create On and Off anomalies and provided threshold values for these anomalies In addition we would have selected to have DCP Devices and Readings Prompts created as well as Pipeline Features Note It is also possible via the Pipeline Survey Editor to have CIS anomalies created following editing of the survey data If the editing process involves the removal of contact spikes for example real anomalies can be identified as opposed to false anomalies that might be associated with the raw data Note Although pipeline survey data can be brought into ProActive without electing to have DCP Devices created it is not possible in such a case to view the survey data via a Summary Folder in the database tree see Section 4 since Devices are required to associate survey data with a line segment Summary Folder However if device readings were not logged at DCPs on a survey and you have not created Landmarks you could still bring the data into ProActive and you could vi
300. urce of the data used to generate maps by ProActive is ESRI Online by default TerraServer and BING are also user selectable data sources The page tab that is selected determines the data source to which the ProActive application will point after the button is clicked Both the ESRI and the TerraServer data sources are available free of charge however the BING data source requires a subscription a username and password can be obtained via the following link www bingmapsportal com The ESRI and BING sources provide worldwide map data however the TerraServer source only provides data for the North America region 190 In all three cases the map data represent a superposition blend of two maps types for example aerial and road and the percentage of each map type is user selectable via the parameter indicated on the map window see above for examples A 100 for Map selection would represent 100 of the 1 Map selection and 0 of the 27 Map selection whereas a 0 selection for would represent 100 of the 2 Map selection and 096 of the 1 Map selection Any 96 value in between 100 and 0426 would correspond to a particular blend of the two selected map types The available map types for each data source aerial topographical road etc can be selected for both the 1 and 2 Maps by clicking on the menu buttons in the relevant fields and highlighting the choices
301. ures would be followed Click on File at top left hand corner of the ProActive menu bar Click on Import Click on Pipeline Survey for XLS files The Pipeline Survey Import Wizard window will appear as shown below Pipeline Survey Import Wizard Use this wizard to import Pipeline Survey data inta Proactive Select the survey types and the file to import Click Nest to continue Survey Type CIS Secondary Survey Type TS Impart File Browse 57 By clicking on the menu button in the Survey field you can select the survey type associated with the survey data that you are importing In our case the survey type 1s Current Mapper Pipeline Survey Import Wizard Use this wizard to import Pipeline Survey data inta Proactive Select the survey types and the file to import Click Next to continue Survey Type Current Mapper Secondary Survey Type SOS Import File E Browse Note If the Spreadsheet file contains data associated with a second survey type for example GPS data a Secondary Survey Type selection can be made using the menu button in the Secondary Survey field Note Only two columns maximum of readings data can be imported per survey type addition to two columns maximum of remarks For example CIS On and Off readings can be imported in addition to two sets of remarks Also a column containing distance data must be available in the Spr
302. vanic Anode A device on our Section A line segment of our example database tree see Section 3 The three reading type choices available for a Galvanic Anode in the particular version of ProActive that was used for the purpose of writing this manual namely Pipe to soil Anode to soil and Anode current are illustrated in the readings page shown below Galvanic Anode A Details Form Location Galvanic Readings Graph Time Chart Mates Audit Trail Setup Descriptions Pipe to soil zi i f Reading Setup Anode to sail Anode current History pate Pipe to sail Anode to soil Anode curent Compliance DOT Rule UNASSIGNED Next Reading Due Example Addition of a Soil Resistance reading type First mouse click inside the Descriptions field and replace the current text Pipe to Soil with Soil Resistance as indicated in the window below 247 Galvanic Anode Details Form Location Galvanic Readings Graph Time Chart Mates Audit Trail S elu Descriptions 1111501 Resistance 4 Pipe to sail Anode to sail Anode current Anode to sail Anode current Complance DOT Rule UNASSIGNED Nest Reading Due Next click on the highlighted Create Reading Type button on the above window which will result in the Readings page being modified as indicated below 248 Galvanic Anode Details Form
303. where they fall in the tree as you create them and use the Sort By Location button on the information page of the line segment summary folder Once you have added all of your facilities to your line segment you can enter the station number for each entity by pulling up the location page of each entity and entering the information double click on the entity node to pull up its Details Form and click on the location page tab to enter its station number Once you ve assigned a station number to each entity in a line segment you would open the line segment s Summary Folder and access its information page by clicking on the information page tab You would then click on the Sort button which will cause ProActive to order your facilities 1n the database tree according to station number with respect to a given pipeline 231 With a Rectifier and a Test Point created on the Section A line segment at this point the database tree window will appear as shown below Entire Database Vera Beach Gas E North District G amp North 1 Line 11 Section Rectifier A Test Point 41 a Section B 1 Section C North 2 Line E South District You would then continue adding the remaining facilities to the Section A line segment in the same manner Once all of the entities have been added to our Section A line segment example the database tree will appear as shown below Entire Database ach
304. which will present the window shown below for the case of selecting CIS and DCVG data 73 ad Harryville North Summary Folders Templates Compliance Flagging Information Remedial Items To do List Models Graph Surveys Atmospheric Errors Fipeline Locatian Start Series End Series Franks Line Start Station 2694 78 End Station 2706 77 Pig Surveys MI MATE 2024 6 17 2003 CIS Surveys GPS right of way Surveys ital OCG Surveys EZ Graph gt Polf Statit v Points Infa LS DCVG Surveys BIENVENUE M2TK 2024 DCVG Voltage V CIS Surveys ux NU CR c gt gt 2700 00 Station M2TK 2024 Voltage V 12 29 2010 10 44 30 AM 4 4 How to have Facility Icons Overlaid on Graphs As mentioned above by checking off the Info box on the Surveys page facility icons representing facilities that populate the line segment in the database tree are overlaid on a graph including icons that represent DCVG anomalies Note The facilities devices that are overlaid on a survey graph are required to have been created by ProActive during the process of posting the survey data to the ProActive database The devices and device readings are then associated with the actual survey data in the database Other facilities that have been associated with the line segment by other means for example by manual creation will not be overlai
305. which would be the case if the Distance data in the Spreadsheet were in Station Number or Milepost format starting Station Number entry does not have to be made as ProActive will interpret the actual stationing from the Spreadsheet as the appropriate stationing for the survey data Station field The Station entry must be made with regard to your selection in the Distance Ref field see above An entry in this field would only be made in conjunction with the selection of the Feet Relative option in the Distance Ref field see above An entry in this field would represent the starting station and distances would be shown in ProActive relative to that starting station Date field Enter the date that the survey was performed For our example the window will be as shown below In this example the starting station was indicated as 2694 78 and a Downstream survey was indicated This means that the PCM reading distances presented in the Spreadsheet will be added to 2694 78 63 Been Fill in the Job and Survey Information Tou can drag in a tree device to set Line and Location Click Nest to Preview the Wizard s interpretation Click Back ta change the column headings Jab Section 2011 Surveu Informatio Distance Ref Feet relative Line Morth 1 Line Series Create Current Anomalies 7 Station H 2694 78 Direction Lower Anomaly
306. y data with the appropriate line segments and you can access the posted data via the folders and Device icons in the database tree which act as gateways or portals to the stored data 1 2 The As Received Database When you first install ProActive and you open the program by double clicking on the ProActive icon a window labeled Entire Database will be displayed on your desktop This window displays your As Received database starter database illustrates the folder types discussed above Note Your As Received database may not appear exactly as shown below but may be a variation of this example Entire Database E Aik Avere Gas Company E Harrylle E Harpvile South Marks Line Risky Line Test E Morth Franks 2 Line Your starter database will contain some examples of real world survey data that have been associated with various fictitious line segments The example line segment names are Marks Line Risky Line and Test which are part of the Harryville South Area and Franks ML2 Line which is part of the Harryville North Area Both the Harryville North and the Harryville South Areas are part of the Harryville District and the Harryville District 1s a region covered by the Risk Averse Gas Company This example database illustrates the concept of a Database Tree which is similar to a Family Tree The top node of the tre
307. y units Propose prior remarks for new readings Read Date Update Proactive with 153 Readings Untaken 1225 2011 Automatic At this point you would click on the highlighted Import button on the above window and target the saved spreadsheet file containing your current test site survey data For our example test site survey in which we entered limited data for the first two test sites only the route the window shown below 15 displayed 344 ad Bobs Route Route Data Entry Site 1 of 26 Site MCM_1 Valve Pipeline Pipeline Milepost 3 9331 Station 2U7 57 _ Franks Site Dey Specific processed Miele Lim Prompt 1 of 1 Prompt Pipe to Sail Range 5 Sine 400 Mehm impedence 5 y Electrode Copper Sulfate Normally Negative Prompt ff Min Date Technician Remarks MCM_1 Valve PipetoSol B12 1 25 2001 UNASSIGNED Bobs Remark MCM_1 Rectiier Amps BOTT UNASSIGNED O MCM_1 Rectiier Vols 2011 UNASSIGNED MCM MCM Coarse Tap 0000000 00 0 MCM TReciie PowerMeter 0000004 1 00 02 MCM1Reotfier _ 0 002 9 MCM IReciie Anode3 00 00 i Casing to Sol i Foreign PAS 0000000 0 i P SZime S 2 PS Copper 00 00000 0 Open Circuit Potential 0
308. you can also drag and drop files such as Word documents and CAD files into the information page of a Summary Folder which allows you to associate previously gathered information relevant to the section of pipeline in our example with this node in the database tree As pipeline survey data are associated with your various pipeline sections these data will also be available for viewing via any higher level Summary Folders since your database tree is configured as a system of folders within folders see Section 5 Step 8 Repeat the above procedures to create nodes inside of the North 1 Line node to represent its other two sections namely Section B and Section C Also repeat the above procedures to add sections to the other three pipeline nodes 30 database tree will then be as shown below corresponding to the physical pipeline layout structure depicted in the above diagram Entire Database reach Gas District Es North 1 Line Section Section B Section 2 North 2 Line Section Section B Section South District E South 1 Line Section Section B Section e South 2 Line Section Section B Section The above database tree represents our example pipeline company down to the pipeline segment level Step 9 Create Landmarks If you have created line segment folders to represent

ProActive Training Manual (Single User Version)

Contents

Download Pdf Manuals

Related Search

Related Contents