Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPIPE
  • Product Communities
  • More
AutoPIPE
AutoPIPE Wiki 01. How to export a custom report for harmonic displacements with regards to velocity (Vx Vy Vz Vr) using Report Manager in AutoPIPE?
    • Sign in
    • -Pipe and Vessel Stress Analysis - Wiki
      • ADL PIPE
      • -Bentley AutoPIPE
        • ++Table Of Contents - AutoPIPE Wiki page
        • - General Information about AutoPIPE
        • +-NEW User Guide - TIPs - FAQ - RSS Newsfeed - AutoPIPE
        • +ATS and Batch Processing - AutoPIPE
        • AutoPIPE QA&R program
        • +Download - Install - Release Notes - AutoPIPE
        • +File / Model Management using AutoPIPE
        • +General - AutoPIPE
        • +Graphics - AutoPIPE
        • +Grids (Input & Results) - AutoPIPE
        • +Import and Export - AutoPIPE
        • +Known Issues in AutoPIPE (Enhancements, defects, etc..)
        • +Libraries - AutoPIPE
        • +License AutoPIPE -
        • +Loads and Load Sets - AutoPIPE
        • +Localization (Non-English Language) - AutoPIPE
        • +Modeling Approaches in AutoPIPE
        • +Modules (i.e. Flange Analysis, Spring Hanger Selection, Rotating Equip, TTA) in AutoPIPE
        • +Piping codes - AutoPIPE
        • +Post Processing - AutoPIPE
        • +Printing - AutoPIPE
        • -Reports - AutoPIPE
          • +01. Reports - Results Interpretation in AutoPIPE
          • +02. Analysis Sub-reports FAQ in AutoPIPE
          • +03. Component Data Listing (Model Input Listing) FAQ in AutoPIPE
          • -04. Report Manager reports FAQ in AutoPIPE
            • 01. How to export a custom report for harmonic displacements with regards to velocity (Vx Vy Vz Vr) using Report Manager in AutoPIPE?
          • +05. Typical Comments, Questions, and Answers about AutoPIPE's Reports
        • +Settings - AutoPIPE
        • +Stress Isometrics - AutoPIPE
        • +Technology Productivity Capabilities
        • +Warnings, Errors, Crashed, Confirm, etc.. messages in AutoPIPE
        • +~ Attend a live meeting with an AutoPIPE Analyst
        • +~ Technical Support - AutoPIPE
      • +Bentley AutoPIPE Nozzle (WinNOZL)
      • +Bentley AutoPIPE Vessel (powered by Microprotol)
      • +Bentley PlantFLOW
      • +Bentley PULS
    • Multi-lingual announcement from BENTLEY TECHNICAL SUPPORT.
    • +Training - Webinar - Help

     
     Questions about this article, topic, or product? Click here. 

    01. How to export a custom report for harmonic displacements with regards to velocity (Vx Vy Vz Vr) using Report Manager in AutoPIPE?

    Applies To
    Product(s): AutoPIPE
    Version(s): 2004, XM, V8i, CONNECT;
    Area: Report
    Original Author: Bentley Technical Support Group
    Date Logged
    & Current Version
    June. 2016
    10.01.00.09

    Problem:

    How to export a custom report for harmonic displacements with regards to velocity (Vx Vy Vz Vr) using Report Manager in AutoPIPE?

    Example:

    Currently we have the ability to sort harmonic displacements in the output grids which is very helpful, however can velocity columns be added in addition. This would be a huge benefit as field vibration readings and limits are in velocity per API 618. I believe this would just be adding columns for the Vx Vy Vz for those displacements.

    Solution:

     Complete this task by using AutoPIPE's Report Manager, see details below for example:

    1. Open example model HRMEXP.dat


    2. Go to combinations dialog > Non-Code Combinations and create the following two non-code combinations:

    a. HARMON 1 (with H1 as load case)
    b. HARMON 2 (with H2 as load case)

    3. On the Non-Code Comb. tab under the combination column of the grid, change the name "HARMON 1" to " Harmon 1" and "HARMON 2" to "Harmon 2" (this is required so that acceleration reports load case name is same as displacement report non-code combination name for Joins to work properly in report manager)

    4. Analyze the model and take out Displacement and Accelerations output reports:

    5. Invoke Export > SQLITE Database (*.db) [Make sure you have the SQLite Tech Preview enabled]

    6. Select Output only and keep "Open Database in AutoPIPE Report Manager

    7. On Report Manager, Select Displacement_Data table first and send to the right, followed by Acceleration table

    8. Expand both tables, and create a Join. Send Point_Name from both Displacement Data, and Point_Name from Accelerations table to Join 1

    9. Create a second join, and send Load_Combination from both tables to that join:

    10. Click on Generate Report, and click on Open generated Report. On the generated excel file, hide Point_Name, Soil_Point, and Load_Combination columns (J, K, and L which are duplicates) and you have your final report:

    See Video here of procedure mentioned above:

    Click here to play this video

    See Also

    Report Manager reports FAQ

    Bentley AutoPIPE

    • output
    • video
    • Report Manager
    • results
    • AutoPIPE
    • Custom Report
    • Output report
    • Report
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Tue, Jun 14 2016 12:31 PM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Tue, Aug 28 2018 11:55 AM
    • Revisions: 5
    • Comments: 0
    Anonymous
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • User Management
    • Licensing Manager
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2019 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies