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 A Customized Space Schedule
    • Building Design - Wiki
    • +OpenBuildings Designer
    • +OpenBuildings Energy Simulator
    • +GenerativeComponents
    • OpenBuildings Station Designer
    • +OpenBuildings Speedikon
    • +OpenBuildings Speedikon + Bentley Speedikon V8i
    • +Bentley Facilities Space Planner CONNECT Edition
    • +AECOsim Building Designer
    • +iModel Plugin for Revit
    • +Social Distance Assessments
    • Working from home with OpenBuildings products
    • +Special Interest Group (SIG) FAQs
    • +Structural Modeler_PS
    • +Configuration Explorer
    • -Legacy Products
      • 2D Or 3D Choice For Design [CS]
      • FM Handover Aquarium and COBie2 Challenge
      • +General BIM Information
      • -Legacy Product Tips And Tricks
        • -Bentley Architecture Tips And Tricks
          • -Bentley Architecture Space Tools
            • Creating A Customized Space Schedule
            • Creating A Datagroup Space Catalog That Matches Your Project Program
            • Using Space Tools ToTrack Floor Areas In Block Models
        • +Bentley Building Electrical Systems Tips And Tricks
        • +Bentley Building Mechanical Systems Tips And Tricks
      • +TechNotes And FAQs
      • +Tips and Tricks
    • Learning Content for OpenBuildings Designer

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

    Creating A Customized Space Schedule

    I am going to show a very simple Space Schedule for tracking floor areas in a block model, but the same method could be used to create your own office standard Room Finish Schedule or Door and Window Schedules.

    Create a Datagroup Schedule Layout


    After using the Create Space tool to place some spaces in your model open the Datagroup Explorer (Architectual Task > Schedules and Reports > Datagroup Explorer).


    Under the Space tab, click on Sample Space Schedule. A list of your Spaces along with many of their Attributes will show up in the right dialog window. You can begin to adjust which Attributes you want to display in your schedule by right clicking on the top menu bar and choosing Remove (to remove attributes) and Field Chooser (to add attributes from a pick list). You can also reorder the attributes by clicking and dragging the field.

    Once you have set the Attributes the way you want them in your schedule you will want to save this schedule as a standard Schedule Layout. Go to Schedules > Save As, a dialog will pop up and you can input the layout name, click OK.

    Creating a Template


    Once you have created the Layout, you will want to open the Properties, so that you can create an Excel Template to match this Schedule Layout. Right click on the Layout you have just created and select Properties.

    In the Properties Dialog select the Template tab. Click on the ... button to find a template. (We are actually going to create a new one by copying the delivered Space Tamplate). The Find Template dialog will pop up in the default folder for Datagroup Layouts. The location of this folder is controlled by the variable DG_SCHEDULE_LAYOUT_PATH. Right click on the SampleSpaceSchedulTemplate.xls and select Copy. Now Paste the file in the same folder and Rename it whatever you would like. Now select this file as the Template by clicking the Open button.


    Now, in the Properties Dialog, select the Edit button, this will open the Excel Template file you just created. Change the headings so that they match the fields in your Schedule Layout (you may want to remove the Bentley logo, as well). When you have finished editing the template, Save it. Be sure to note the row and column number of the first blank cell where your data will go (A:4 in the delivered template). You will input this information in the Properties Dialog under Insertion Start Cell:.

    Close the Properties Dialog. Click on your new Schedule Layout so that you see it in the right window. Go to Data > Export > Excel.

    The data in your Schedule Layout will now populate your Excel Template and you can save it out an Excel Worksheet where you can continue to format the data as necessary, or if you're good at Excel, link the data to another formatted worksheet.

    • schedule
    • Architecture
    • Datagroups
    • Space Tools
    • Create Space
    • Bentley Architecture
    • Share
    • History
    • More
    • Cancel
    • Mary Chib Created by Bentley Colleague Mary Chib
    • When: Wed, Jul 29 2009 4:51 PM
    • Noel Page Last revision by Noel Page
    • When: Fri, Apr 22 2011 3:05 PM
    • Revisions: 9
    • Comments: 1
    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