Schedules are spreadsheets connected to the model and considered as one of the advanced BIM features. Our goal in this article is to create and place a wall schedule sorted by levels and thicknesses. In ARCHLine.XP schedules are linked to the elements of the model. Changes made in the project will be updated in schedules and vice versa.
CREATE SCHEDULE - TYPES AND PROPERTIES
The Create Schedule dialog is separated into three columns. The first column displays the disciplines such as Architectural elements, Interior, Site and MEP design. Select the type you are going to assign the new schedule to.
The second column displays the General properties, the Calculated values and BIM parameter groups. Select a property from the list and click on the right arrow button to add it to the schedule template. You can also add picture of the element to the schedule template.
The third column in the dialog displays the current schedule template.
HOW TO CREATE A SCHEDULE?
- Select the appropriate type of element to create a new schedule (such as a wall schedule).
- Select a category from the Group.
- Select a property from the list. Click on the right arrow to place it into the schedule.
- Repeat step no. 2 and 3 to add more properties to the schedule.
- Optionally, sort the schedule template with Up and Down button or Delete the property placed by mistake.
- Optionally, format the schedule with Calculate Total, Visible, Prefix, Postfix options.
HOW TO CREATE A SECOND SCHEDULE?
- In the Define Schedule dialog click on the New button.
- Specify the name of the new schedule
- Follow the preceding no. 2-6 points to fill the schedule template with properties.
HOW TO SELECT A SCHEDULE?
- Select the discipline and the appropriate type of element (e.g. wall schedule).
- Select a Schedule from the existing Groups.
- Optionally you can change the fields for schedule parameters: Calculate total, Visibility, Prefix and Suffix.
- Press Ok to close the dialog.
USE CALCULATED VALUES
You can choose calculated values and if you activate the Calculate total checkbox, the schedule will display the sum value of the grouped elements, e.g. the total wall surface on a floor.
USING IMAGES IN SCHEDULES
Some element types allow you to add an image to schedules, e.g. doors, windows, objects, cabinets.
Choose Image or Image with dimensions and add to the schedule template. Later in the formatting dialog you can specify the image size and dimension styles. Furthermore you can display doors, windows, cabinet opening directions with their color and linetype.
FORMATTING A SCHEDULE
The program offers the Formatting schedule dialog before placing.
- Check itemize every instance: by default every element will be visible in the schedule. This means if you create a wall schedule, all walls appear in the schedule.
- Group these walls. Go to Sort by and choose Floor. Walls will be grouped together by the selected Sort category. In this example, walls are grouped by Floor in ascending order.
- You may add another sorting criteria by wall thickness. Walls will be grouped within floors by wall thicknesses.
CALCULATE GRAND TOTALS
To calculate summary, make sure Grand Totals and Footer fields are activated in the Formatting dialog.
SEPARATE BY PHASES
You can filter elements by Phases to display only walls with Existing, Demolished or New phase properties.
USE TEXT STYLES IN SCHEDULES
You can assign different text styles to cell, header and column names. Different colors and fonts help to visualize better the long schedules.
HIGHLIGHT ELEMENT IN MODEL
Sometimes, it is hard to find where an element in the schedule is located in the model. Click on schedule then click on any magnifier icon.
A blue line points to the selected item.
CHANGES WITH SCHEDULE
You can edit some cells in a schedule by clicking in them. The properties of the elements (e.g. width, height, length, etc.), texts and materials (marked with paint bucket) can be edited. To finish editing in a cell, press Enter. The changes are applied to the connected element.
If you wish to change the Finish Face Exterior Material of a wall, click on the paint bucket and select a new material from the Material dialog.
EXPORT TO EXCEL TO GET PRICE
You can export the schedule to an Excel spreadsheet where you can assign price to each calculated value. Choose Save to Excel command and select a schedule or choose Save All to Excel to export all schedules into Excel in one step. Add Price Euro and Total Euro as new columns in Excel. Fill the price from your catalogue and go to Total field. Select the QTY and Price Euro field in the formula and put * between them.
Follow these tips and experiment. You may be soon the master of Schedules.