Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenBuildings | AECOsim | Speedikon
  • Product Communities
  • Building
  • OpenBuildings | AECOsim | Speedikon
  • Cancel
OpenBuildings | AECOsim | Speedikon
OpenBuildings | AECOsim | Speedikon Wiki Creating Custom Schedule Report
    • Building Design - Wiki
    • +OpenBuildings Designer
    • +OpenBuildings Energy Simulator
    • +GenerativeComponents
    • OpenBuildings Station Designer
    • +OpenBuildings Speedikon + Bentley Speedikon V8i
    • +Bentley Facilities Space Planner CONNECT Edition
    • -AECOsim Building Designer
      • +Annotation - AECOsim Building Designer
      • +Architectural Design - AECOsim Building Designer
      • +ASM (Analytical Space Model)
      • +Configuration - AECOsim Building Designer
      • +DataGroup System - AECOsim Building Designer
      • +Dataset and Content - AECOsim Building Designer
      • +Drawing Extraction - AECOsim Building Designer
      • +Drawing Views - AECOsim Building Designer
      • +Electrical Annotation and Design - AECOsim Building Designer
      • +Floors - AECOsim Building Designer
      • +Form Modeling - AECOsim Building Designer
      • +General - AECOsim Building Designer
      • +Grid Systems - AECOsim Building Designer
      • +HVAC Design - AECOsim Building Designer
      • +i-model - AECOsim Building Designer
      • -Import/Export - AECOsim Building Designer
        • 'Runtime error 9' Creating Structural Report Spreadsheet
        • Cadworx object enabler for AECOsim Building Designer
        • Can MicroStation solids be included when generating ISM files?
        • CONNECT Edition - Modify CIS/2 File in AECOSim Building Designer
        • Creating Custom Schedule Report
        • Export 2D to 3D or 3D to 2D for multiple files
        • Export Selected Elements to DWG
        • Export to ISM of a File with multiple References
        • Exporting to Step Format
        • Horizontal Braces import from STAAD.Pro as Beams
        • How to show area and volume in the schedule after attaching instance data to MicroStation element
        • +IFC - Import/Export - AECOsim Building Designer
        • Importing STAAD.Pro files with correct placement point orientation
        • Integration with external Mechanical & Electrical applications
        • List Type ID instead of Mark in Structural Report Spreadsheet
        • MagiCAD object enabler for AECOsim Building Designer
        • Methods to import ABD files into Revit
        • +Other - Import/Export - AECOsim Building Designer
        • Sketchup Files Will Not Open or Display
        • Steps needed to create a Structural Report Spreadsheet
        • STP File Exported From SAP 2000 is Empty
        • Structural export options in AECOsim Building Designer SELECTseries6
        • Version Error in ISM import/Structural Synchronizer
        • When a DGN file is exported to DWG the colors change
      • +Installation - AECOsim Building Designer
      • +Modify - AECOsim Building Designer
      • +Platform Tools - AECOsim Building Designer
      • +Plumbing Design - AECOsim Building Designer
      • +Print/Plot - AECOsim Building Designer
      • +ProjectWise Integration - AECOsim Building Designer
      • +Settings/Attributes - AECOsim Building Designer
      • +Space Planner - AECOsim Building Designer
      • +Structural Design - AECOsim Building Designer
      • +Utilities - AECOsim Building Designer
      • +Workspace - AECOsim Building Designer
    • +iModel Plugin for Revit
    • +Social Distance Assessments
    • Working from home with OpenBuildings products
    • Working from home with Speedikon
    • +Special Interest Group (SIG) FAQs
    • +Structural Modeler_PS
    • +Configuration Explorer
    • +Legacy Products
    • +OpenBuildings Speedikon

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

    Creating Custom Schedule Report

    Applies To
    Product(s): AECOsim Building Designer
    Version(s): 08.11.09.747
    Environment: N\A
    Area: Import/Export
    Subarea: DataGroup Schedule
    Original Author: Gerard Torres, Bentley Technical Support Group

    Problem Description

    How to create a custom Schedule report and also how to add several catalog types into one report?

    Steps to Resolve

    Including several Catalog Types in one schedule report is available from AECOsim SS5 onwards, see help topic 'Revised Interface for Creating and Modifying Reports' for more details. For instance, in previous versions Concrete and Steel Piles would have been in separate schedules. In SS5 a schedule can be created that contains both.

    Here is an example:

    Open DataGroup Explorer and click the Create New Schedule icon:

    Give your new schedule a name and either select an existing Destination file or create a new one:

    Click Edit Schedule Options.

    In this example we don't need to see the Architectural Catalog Types so click the arrow to the left of Architectural to collapse that group.

    The two Pile types are highlighted in bold as both have instances in the active file.

    Select both then click the upper single arrow:

    to move them to the right:

    Click the Properties tab, then select the properties that you wish to include in your schedule using the left/right arrows:

    The order of the properties in the schedule can be changed using the up/down arrow on the right.

    Further options to refine the contents and appearance of the schedule are offered by the following three tabs. The Formatting tab for instance allows column headings to be changed from the default of the property name listed to a name that fits in with project or owner standards.

    For instance, I don't want to the see the '(Alternate)' after the ID | Name property so I can double click it to edit:

    Click OK when complete.

    In SS5 the unique properties for each item, Asset Tag , Name, etc., have to be edited interactively. SS6 offers the ability to edit multiple properties via the Edit in Excel feature where the schedule can be exported to an Excel file, have properties such as Asset Tags added using Excel Fill Series tools, then be imported back into the model.

    If required the Excel export can be set up to use a company template, inserting the output from ABD at a specified starting cell as described in the help topic 'DataGroup Explorer Excel Export Properties dialog box' (search help with this phrase).

    Note: In this example as the first column begins with ID (in Caps) Excel will think the CSV file is a SYLK file, just click OK to continue. To avoid this message in SS5 move a property whose name does not begin with 'ID' to be first or edit the Field Setting > Heading as shown above to remove the 'ID'. We have amended the CSV output in SS6 to avoid this problem.

    The link below covers the SS4 process, including making your own custom Schedule:

    http://communities.bentley.com/products/building/building_analysis___design/w/building_analysis_and_design__wiki/creating-a-customized-space-schedule

    • Import/Export
    • AECOsim
    • 08.11.09.747
    • DataGroup Schedule
    • en
    • AECOsim Building Designer
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Gerard Torres Created by Gerard Torres
    • When: Mon, Apr 27 2015 6:09 PM
    • Gerard Torres Last revision by Gerard Torres
    • When: Wed, Aug 23 2017 12:38 PM
    • Revisions: 5
    • 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