Blog: Program Creation and Validation


When working on medium to large buildings, how are you managing your program requirements? How are you checking the intended design area? In what way do you capture the number of required elements in a specific space? How can you assist the designer with room layouts and making sure the required equipment is used in the correct space? What happens when the design or the requirements change? Is there a way to compare data and assist with these changes? This session will demonstrate a process that will answer these questions, using tools you may already have at your fingertips: Spreadsheet Link and Room Family Manager. These tools can be powerful assets when establishing building programs.

Typical Workflow

In manual workflows, many architectural firms will use an Excel® spreadsheet containing all the special requirements needed for the building. Occasionally, some firms will have a process to export the data from Revit® and linked directly into this spreadsheet. Most firms will export the room data from their Revit design models, and manually enter the data in their spreadsheets. But what happens on the return side? How this data gets back into Revit almost always is another manual process.

There are a handful of Dynamo workflows and paid Revit plugins that are meant for this process specifically, but they either take dedicated professionals to create and maintain, or they cost a lot of money to purchase. Unfortunately, these tools are not commonly used. Then what about the content required to be placed in each space? Often, a designer is reading from the spreadsheet, browsing through their Revit library and manually placing the content into their projects. If the design changes, or the requirements change, it all becomes a manual process, updating both the spreadsheets in Excel, and updating the models in Revit.


This entire workflow can be simplified by using a couple of tools that many firms already have: Spreadsheet Link and Room Family Manager, both from the CTC BIM Project Suite. A template can be created for the type of project and spaces that are being used, to assist with populating special data obtained in the building program. This data can be pushed into the Revit models, and a back-and-forth design process can begin. For the content to be placed within the rooms, Room Family Manager will help with defining the list of equipment required by each space, and help with populating each space with the defined list, and again another back-and-forth design process can begin.

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 on-demand. 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.


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.

Blog originally published by CTC Software. Find it in the White Paper Library.

BIM Project Suite™ is a trademark of CTC Software in the USA and other countries. © 2020 CTC Software. All other brand names, product names or trademarks belong to their respective holders.

Contact Us

Drop us a note. We love notes.

    I'd Like More Info On:


    Events | See All

    Wed 25

    CTC Webinar: New features in Civil 3D Corridor Mapper

    November 25 @ 12:00 PM - 1:00 PM CST

    Workflows & Solutions | See All

    News  | See All

    Our Latest
    Success Stories

    See All


    Providing Solutions to Grow a Long-Standing Relationship

    Customer ChallengeButler Design Group is an architectural firm in Phoenix, AZ dedicated to creating design solutions for their client’s functional, aesthetic and budgetary needs. Through partnership with ATG, BDG realized the...

    Eliminating Repetitive Tasks to Accelerate Workflows

    Customer ChallengeTyson Foods, Inc., based in Springdale, Arkansas, was founded in 1935 with a goal to deliver quality chicken and build strong relationships with independent farms across America. The drafting team at Tyson...
    Success Story: BIMBOX

    Success Story: Groundbreaking ROI With BIMBOX

    Success Story Overview Formerly known as Collaboration for Revit or C4R, BIM360 Design allows multiple stakeholders to contribute to a central model, or aggregation of models, in the cloud. Many people experience poor...

    Specialized Workflows

    Overview JB Henderson Construction, Inc., commemorated its 60th year in business in May 2019. Based in Albuquerque, the company has an extensive list of customers including national laboratories, universities, hospitals, and...

    Saving a Historic Landmark

    Overview Old Hattiesburg High School was constructed in 1911, and was substantially enlarged during a second phase of construction 10 years later. It served as the main high school for Hattiesburg, Miss., until 1959. Since then,...

    BIM Batch Suite

    Projects & Families Upgrader Upgrade multiple projects and templates at once with this tool. Automatically adjust linked Revit® and CAD file paths to new locations. Easily select files in an intuitive user interface. Migrate...


    Overview Ball Architects is a company devoted to housing for the greater good, with housing development projects across 10 states. Ball Architects had differing levels of experience with Autodesk Revit and needed an assessment...

    BIM 360

    Overview ATG had the opportunity to work with Bernhard TME, and assist their team with completing a new campus for Arkansas Children’s Northwest. One of the primary takeaways for ATG was ensuring the success of the combined...

    Investing in Hardware

    Overview McKinstry is a national leader in designing, constructing, operating and maintaining high-performing buildings. From new construction and ongoing operations, to adaptive reuse, energy retrofits and advanced renewable...

    Maintenance to Subscription

    Customer ChallengeM3 Engineering has projects all over the world that require leveraging an extensive portfolio of Autodesk software. ATG worked in conjunction with M3’s IT and leadership teams to ensure that M3 had the tools...