One of the most common examples, involving the need to display a calculated value within a tag, relates to Occupancy Load information that is often required to be placed on a floor plan view. This topic requires a sample dataset which Ideate BIMLink customers can request via our support staff: Please send Ideate BIMLink Occupancy Sample dataset
IMPORTANT: The example below is provided exclusively for the purposes of demonstrating the workflow. The sample data provided may not reflect your local code requirements, your projects shared parameter requirements or your company standards for tags.
Occupancy calculations are done with either Room or Area elements. The data provided covers both conditions. When using the Area elements, because they are Area Scheme specific, it is important to understand that the steps must be done before the Areas are placed.
Related: Occupancy video
Sample Dataset: Open the Revit file, "2014 Ideate Occupancy Dataset.rvt". This file already has a shared parameter created for the purpose of receiving the calculated values. The shared parameter is called "OL" for occupancy load.
Your own project: Use the Insert Views from File method to bring the Area and Room Schedule examples from the "2014 Ideate Occupancy Dataset.rvt" file into your own project. This will automatically create the required shared parameters referenced in the steps below. This steps below will not work unless the shared parameters in the sample file are used.
Sample Dataset: In 2014 Ideate Occupancy Dataset.rvt the links required for both Room and Area elements have already been loaded, as shown in the image.
Your own project: Use the Load Sample button to load the "Areas-Occupancy" or "Rooms-Occupancy" links as shown above. These are both found within the Architectural folder. For Room elements, the Preview will have data (assuming rooms elements are present in the Revit project). For Area elements the Preview may be empty, even if Areas are present, as new Area elements need to be made AFTER the Area Scheme has been define, per Step 1.
The link needs to include any parameters required in order to perform the calculation. In the example of occupancy load this would be the Area parameter and the Occupancy Load Factor parameter, both of included in the Sample Links. For the purposes of this exercise, it is recommended that you do not add any parameters so that Step 4 can work as expected.
If you have customized the list of parameters during Step 3, you will be manually setting up and copying the formula in Step 5. Export the data to any Excel file and select the option to open the Excel file, then proceed to step 5.
The sample template provided will automatically setup the occupancy formula and copy down the results in to all of your Rooms or Areas. You can only use this method if you have not altered the list of parameters during Step 3. Export the data by selecting a copy of the Excel template provided in the sample dataset. The sample Excel file is a macro-enabled file with a .XLSM extension, so be sure to change the File type to .xlsm. Select the option open the Excel file. The first time you use this file you will need to select the "Enable Editing" button. When you do this, the macro will run and update the Excel occupancy formula. Save the file and then proceed to Step 6.
After exporting the data to a regular Excel file (no macros), the last step before import would be to setup the proper formula in the shared parameter column. There are many ways to write this formula. In the sample template provided (.xlsm) we are using the formula:
This formula can be read as IF the occupancy load (Column F) is empty, then leave the cell blank, otherwise take the rounded value of the Area (Column E) and divide it by the occupancy load (Column F).
Whether you have used the Manual or Automatic Methods described in Step 4, the last step is to import the updated Excel file into Revit via Ideate BIMLink. Select the Import button and browse to the file. The calculated values are now transferred into the shared parameter. If you are using the sample Revit file, you will see the values as displayed in the Room and Area tags.
Thank you for taking time to inform us about a bug or feature request.
If you'd like to upload a file to help explain the issue, you can upload a file to Hightail.