Program Validation with Spreadsheet Link and Room Family Manager – Part 1

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 Issue 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. 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.

Solution 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.

Subscribe to SolidCHAT blog for part 2.