• Program Validation with Spreadsheet Link and Room Family Manager – Part 2

    CTC Software

    Posted CTC BIM Project Suite White Paper Library –  CTC Software

    End Result

    When the workflow is developed and implemented, the entire special program can be added to the Revit project in a matter of minutes. Design area versus actual modeled area can be compared and analyzed ondemand. Content for each space can be placed per room specifications, whether the families are loaded or not. If layouts change, or if equipment needs to be replaced, the process ca be completed in minutes instead of hours. Any user can utilize this workflow to import the program requirements into their projects, update the models, import the content and finish the design. This process speeds up a task that takes lots of time and removes lots of potential user error.


    Time savings can be applied to several different aspects of the project. Planners can continue to use Excel to generate the lists needed for the room import, pulling from defined lists of data instead of guessing or looking up the data themselves. They never have to open Revit if they do not want to. The manual, error prone process of reading data from one source, and entering it into another source can be eliminated. This allows the designers and Revit users to focus more on the actual design and layout of the project more than focusing on the data they have been retyping.

    Conclusion Spreadsheet Link and Room Family Manager from the CTC BIM Project Suite can help import the building program and assist with data comparison and with design changes. The process above is intended to be the starting point of a template that can be expanded upon to include additional information, making the process fit the needs of the project and the team. If taken a few steps further, most of the data and content needed can be managed with just a couple of Excel files. Both Revit users and non-Revit users can take part in this process, and still have their designs imprinted on the project.