Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
AutoPIPE
  • Product Communities
AutoPIPE
AutoPIPE Wiki 04. Compare AutoPIPE Input Grids with Caesar Spreadsheets
    • Sign In
    • -Pipe and Vessel Stress Analysis - Wiki
      • -.Bentley AutoPIPE
        • +a. General Information about AutoPIPE
        • +b. NEW User Guide for AutoPIPE
        • +c. Technical Support - AutoPIPE
        • +d. Download - Install - Release Notes - AutoPIPE
        • +e. Features and Bugs in AutoPIPE
        • +f. License AutoPIPE -
        • +g. System Messages: Warnings, Errors, Crashed, Confirm, etc.. in AutoPIPE
        • h. QA&R program for AutoPIPE
        • i. Security
        • -❤︎ Support Solutions and FAQ's in AutoPIPE
          • +Batch Processing, ITS, and ATS using AutoPIPE
          • +File / Model Management using AutoPIPE
          • +General - AutoPIPE
          • +Graphics - AutoPIPE
          • +Grids (Input & Results) - AutoPIPE
          • -Import and Export - AutoPIPE
            • +01: What file formats can AutoPIPE Import/Export?
            • -02. Imported related issues in AutoPIPE
              • +02-01.a: Import AutoPIPE DAT model
              • +02-01.b: Issues with Importing *.NTL file into AutoPIPE
              • +02-02. AutoPIPE Translators
              • +02-02.d Import ISM files into AutoPIPE
              • 02-03.a1: Example 1 - After import, how to fix piping that are not all connected?
              • 02-03.a2: Example 2 - After import, how to fix piping that are not all connected?
              • +02-03.b: Import MS Excel or AutoCAD DWG / DXF into AutoPIPE?
              • 02-03.c: AutoDesk REVIT into AutoPIPE
              • 02-03.d: Aveva E3D PSI (XML) into AutoPIPE import issues
              • 02-03.e.i: PXF Import : CADAP.MAP Options
              • +02-03.e: Troubleshooting - Import AutoPlant / OpenPLANT PXF file into AutoPIPE
              • 02-03.f: Can AutoPIPE Import Bentley Microstation model information?
              • 02-03.f: Can AutoPIPE V8i Import / Export Bentley HAMMER loads?
              • +02-03.h: Import PlantSPACE model into AutoPIPE
              • 02-03.i: Import ProStructures into AutoPIPE
              • +02-03.j: Insert> Model From Bentley SACS using PipeLink or ISM
              • +02-03.k: Insert> Model From STAAD Using PipeLink
              • 02-03.l: CAD To AutoPIPE Integration
              • 02-03.m: Import CIMSteel Integration Standards (CIS/2) or STP file information into AutoPIPE
              • -02-03.n: Import / Export caesar (cii) or Areva PDMS (cii) with AutoPIPE
                • +01. Import / Export CAESAR (cii) file - AutoPIPE
                • 02. AutoPIPE vs CAESAR load combinations
                • 03. C-Node or Connecting Nodes in Caesar
                • 04. Compare AutoPIPE Input Grids with Caesar Spreadsheets
                • 07. Where are similar caesar settings in AutoPIPE?
                • 08. AutoPIPE vs Caesar Benchmark
                • 09. Piping codes availability between AutoPIPE and caesar
              • 02-03.o: Import CAE Pipe or Kpipe into AutoPIPE
              • 02-03.r: Import OpenBIM data exchange (IFC) information into AutoPIPE
              • 02-03.s: Import Pipe Net into AutoPIPE
              • 02-03.t: Import PDMS using I-Sketch, I-Run or Spoolgen into AutoPIPE
              • 02-03.u: Import PTC Creo into AutoPIPE
              • 02-03.v: Can AutoPIPE Import SAP 2000 model file?
              • 02-03.w: Import TRIMBLE PIPEDESIGNER 3D into AutoPIPE
              • 04-001: While importing or copy paste into AutoPIPE model, the node numbers are renaming automatically. How to import / copy geometry without changing the node numbers?
            • +03. Exported related issues in AutoPIPE
          • +Libraries - 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
          • +Settings - AutoPIPE
          • +Stress Isometrics - AutoPIPE
          • +Technology Productivity Capabilities
      • +.Bentley AutoPIPE Vessel (powered by Microprotol)
      • +ADL PIPE
      • +Bentley AutoPIPE Nozzle
      • +Bentley PlantFLOW
      • +Bentley PULS
    • +AutoPIPE Brand Learning Resources
    • +Attend a live meeting with an AutoPIPE Analyst
    • +Q. How to install a patch sent by Bentley AutoPIPE development team?

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

    04. Compare AutoPIPE Input Grids with Caesar Spreadsheets

    Applies To
    Product(s): AutoPIPE
    Version(s): ALL
    Environment: N/A
    Area: Import
    Original Author: Bentley Technical Support Group

    Make Global Changes e.g. changing coefficient of frictions for pipe supports, global changes to pressures, temperatures, materials, etc can be done in both applications. See the following comparison between the applications:

    Caesar:

      • Not like Microsoft Excel - No multiple Copy/Paste, no column sort
      • Only modify one cell at a time
      • 'Ripple Effect' can cause a lot of checking and rework

    AutoPIPE

      • Bi-directionally synchronized with the plot
      • Make global changes across multiple cells of like data
      • Sort any column into logical data groups
      • Select multiple ranges of components with graphical highlight
      • Real time graphical plot update with multi-level undo & redo
      • Customized printing
      • Behaves like Microsoft Excel unlike Caesar List spreadsheet

     

    1. Change Support Friction

    Caesar

    You mush change friction values one by one:

    AutoPIPE

    1. In the Support Grid, double click column heading in order to sore the data.

    2. Select multiple cells you wish to change or Select the complete column and then select one cell while holding down the CTRL key.

    Enter new value in first cell and then press CTRL + Enter.

    NOTE: One CTRL + Z step will undo the complete change.

    2. Change Temperature in Model

    Caesar

     Use List spreadsheet

    Change RED value e.g. 482 to 555. This change ‘Ripples‘ down to next RED value. Difficult to identify which part(s) of the model has changed. Need to keep switching on the color temperature plot. Maybe other parts of model to change to 555 also, need to find them.

    This change cannot be seen in legend nor on the color temperature plot unless the plot is reset.

    AutoPIPE

    Make Global changes to pressure, temperature. Option A is best for performing global changes across the whole model. Option C allows best method to check all values being changed point by point.

    Option A -

    1. Select Operating Load by Value from the Modify menu.

    2. Select the existing temperature and enter the replacement value. This will replace all temperatures in the whole model (482 with 555, in this example).


    Option B -

    1. Select the range in the model to change temperature

    2. Select Pressure & Temperature from the Modify menu.

    3. Enter new temperature (555 for this example). The new temperature is shown in blue to indicate which values have changed.


    Click OK. The color plot and legend are updated immediately with the new value.


    Option C - Use Input Grids

    1. Select View > Show > Temperature to see color temperature plot.

    2. Double click Case 1 Temp column to sort it.

    3. Select the cells with this temperature.

    4. Enter new value (e.g. - 555) and press CTRL + Enter.

    Note:

    a. Drag down or copy down commands using right click menu, are also available for making global changes like Excel.

    b. The selected cells immediately highlight RED on the plot to see which parts of the model are to be changed.

     

    See Also

    Bentley AutoPIPE

    • import
    • Caesar
    • Export
    • AutoPIPE
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Thu, Aug 22 2013 11:57 AM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Tue, Nov 28 2017 10:46 AM
    • Revisions: 15
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

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