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

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.

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

CTC BIM Project Suite White Paper Library –  CTC Software



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.

Using Meridian Portal to Streamline Cloud-based Reviews

By Daniel Isaac, Technical consultant – Document management

A typical scenario in today’s work from home reality needs a technical document package to be reviewed by a dedicated team of experts. A document controller accomplishes this by gathering the required hard copies and physically sending them to the appropriate stakeholders around the office using mail.

This traditional workflow presents some challenges:

  • A resource is required to keep the team on track and to ensure mail delays are controlled, which tends to extend the review process
  • Any feedback made in the late stages of reviews may require more mail transactions, causing delays
  • The team must clearly understand reviewer roles and sign off requirements, or the entire process may slow down due to some people thinking they need to approve things when it is not required.
  • Chasing the hard copies through the mailing process is tough, especially when critical resources are out of the office

The Digital Approach: Moving your review online for better efficiency

The Manufacturing sector is quickly moving to digital solutions, especially during this Pandemic. More and more tools are being pushed to the cloud to ensure maximum availability for a home-based workforce and resources in the field.

The power of cloud-based SaaS Software is coming to light during these challenging times. With less in-house hardware requirements for application, storage, and database management, these solutions allow for more uptime and increased efficiency. The flexibility granted by a fully integrated suite such as Meridian EDMS + Meridian Portal highlights the ease of use of going digital.

The Meridian suite will provide the following benefits:

  • Full role-based review control throughout the process (Lead Reviewer, Required Reviewer, Optional Reviewer) which will give precise requirements from the Review team
  • Automated workflow-based email notifications to all critical Reviewers to increase visibility and efficiency
  • Cloud-based markups and comments are made on the reviewed technical documents, which are visible to the entire team. Comments are instantly added using the standard conversation reply style and are fully tracked to reduce any bottlenecks

Engineering document management solutions like Accruent’s Meridian Portal assist engineering teams, and project managers streamline day to day operations by optimizing document reviews and the conversation around them. Online reviews provide instant access to a single source of truth without relying on traditional hard copy prints and packages.

To learn more about Meridian Portal and how it can help your team, please contact the SolidCAD Meridian team.

Autodesk Desktop Connector and Sheet Sets

By Matt Kolberg , Applications Specialist at SolidCAD


Autodesk Desktop Connector and Sheet Sets

An update to the Desktop Connector as made available on August 11, 2020.  Here is the relevant Autodesk document.


If you’re a Sheet Set user who also uses BIM 360, this update is for you.  In addition to other resolved issues, the main feature in this update is that Sheet Set DST files are now recognized.  When a DST file is uploaded via the Desktop Connector, any drawings contained therein and their references are all uploaded.  When a DST is opened in AutoCAD, drawings will be synchronized locally.

AutoCAD 2021.1 Update

By Matt Kolberg , Applications Specialist at SolidCAD


AutoCAD 2021.1 Update

Autodesk has released the first update for AutoCAD 2021.  Find official documentation here.  Here are some highlights:

  • Blocks palette:
    • There is a new Favorites tab.
    • Block can be copied from other tabs to the new Favorites tab.
    • Blocks sybchronized in the cloud can become accessible across multiple devices.
    • You can better manage your synchronization settings in the Blocks palette now.
    • Insert a DWG into the current file without it being added to the Libraries tab.
    • New variable and setting in Options: BLOCKSYNCFOLDER – Sets the path where the recent and favorite blocks are stored.
  • In the AutoCAD web app, click Open in Desktop to open the drawing in AutoCAD or AutoCAD LT desktop.  A plug-in must be installed.

Civil 3D 2021.1 Update

By Matt Kolberg , Applications Specialist at SolidCAD


Civil 3D 2021.1 Update

Autodesk has released the first update for Civil 3D 2021.  Find official documentation here.  Here are some highlights:

  • Feature Lines:
    • Easily insert elevation points or PIs on feature lines at their crossings with other feature lines.
    • Set grade or slope between multiple feature lines.  Use the previous new command to insert points first.
  • Pressure Networks:
    • Add/Move/Delete vertical bends from a pressure network.
    • Pipe run profile settings:
      • New overrides tab for specifying static or dynamic updates.
      • Profiles selection now includes a create from surface option.
    • You can now change a straight pipe to a curved pipe in profile view by grip editing, and change a curved pipe to a straight pipe.
  • BIM 360 Collaboration for Civil:  Support has been added for reference templates and sheet set data files.  You must install the latest update for the Desktop Connector.
  • ArcGIS:
    • You can add new objects that were created in Civil 3D to ArcGIS by moving them to an existing ArcGIS layer and then saving the layer back to ArcGIS. Changes to property set data are now saved back to ArcGIS along with the geometry.
    • Support has been added for exporting curves (instead of tessellated segments) to a file geodatabase.
  • Bridges
    • Support has been added for configuring layers for an existing bridge in a drawing.
    • Support has been added for assigning layers for bridge generic object subtypes.
  • Project Explorer: Autodesk Project Explorer for Civil 3D is an environment that allows you to review and analyze civil objects in the model. Here we will look at Alignments, Profiles, and Corridors.  See this YouTube playlist.  This is an extension which must be downloaded and  installed separately from 2021.1.

Infraworks 2021.1 Update

By Matt Kolberg , Applications Specialist at SolidCAD


Infraworks 2021.1 Update

Autodesk has released the first update for Infraworks 2021.  Find official documentation here.  As of the date of the release of this article, Autodesk has not yet added information about the 2021.1 update.  When they do, this link should be correct.


Here are some highlights:

  • New Home page.  More like AutoCAD and Civil 3D.
  • Import complex Civil 3D corridors with multiple baselines and offset baselines.
  • Customize lane and intersection markings.
  • Model builder allows the selection of a projected coordinate system before the model has been generated.
  • Refined bridge analysis.
  • Bridge cross frame improvements.

Boost the power of Meridian with Cloud API Integrations

By Daniel Isaac, Technical consultant – Document management

While Enterprise resource planning and maintenance management platforms are versatile tools that can up productivity and lower operating costs, they normally offer basic engineering document management capabilities. 

This can lead to users struggling to find the latest engineering documents related to assets. Without robust engineering document management tools, a business can see lower operating efficiency and ROI due to increased downtime, maintenance delays and safety incidents. 

Meridian Cloud API allows you to unify all your enterprise tools with Accruent’s industry-leading Meridian document management solution to have a complete and efficient solution.

Combining all these powerful systems will allow your business to better manage your assets and ensure that all your critical data is easily accessible, secure, a tracible throughout: 

  • Enterprise Resource Planning (ERP) 
  • Enterprise Asset Management (EAM) 
  • Computerized Maintenance Management system (CMMS) 
  • Enterprise Document Management (EDM) 

How can Meridian Cloud API help your team? 

The Meridian Cloud API enables integrations between your existing ERP, CMMS, or FM solutions and Accruent’s engineering document management solution, Meridian.  

Meridian supplies a secure, scalable, and accessible repository for all technical and asset related documentation. This solution not only creates a single source of truth for your technical documents, but also meets compliance needs with industry-specific regulations. 

Page Break 

With the Meridian Cloud API, you will be able to: 

  • Create traceability between technical documents, assets and emails stored in Meridian 
  • Keep asset information uniform across platforms, creating one single source of truth for data 
  • View a list of all associated documents/information related to an asset in a single space 
  • Reduce duplication of data across multiple systems 

Download the Meridian Cloud API brochure. 

How can Meridian Cloud API help your teams? 

Out of date information and data reduces operating efficiency. Meridian Cloud API will allow your teams to incorporate workflows and data synchronization across enterprise asset tools to maximize uptime and reduce data re-entry. 

Synchronize critical data across different systems 

  • The ability to synchronize your documentation and assets between all your different tools will allow for fully integrated workflows. Having your companies’ technical documentation tied to their respective assets will reduce downtime and lower the total cost of maintenance. 

Reduce duplication of data 

  • Utilizing multiple data repositories without sync capabilities will introduce the creation of duplicate entries which is both time-consuming and inefficient and may lead to increased opportunity for human error. This can lead to making costly decisions that rely on out of date information. 

Whenever maintenance and engineering teams work out of many separate systems, it can lead to work order delays and negatively affect the safety of personnel in the field. 

Meridian Cloud API integration will ensure your asset data and technical documents are up to date always to avoid these issues. 

Learn more about Accruent’s engineering document management solution, Meridian. 

Unify Your Engineering and Maintenance Departments with Meridian Cloud API 

Meridian Cloud API can link your ERP, CMMS or EAM platform with our document management solution Meridian allowing for an update to date, single source of truth, and complaint Enterprise solution for your teams. 

The SolidCAD Meridian team is available for your EDM implementation needs. 

Parameter Jammer using Revit MEP and CTC Tools

By Patrick Siemek, Technical Consultant AEC at SolidCAD


Parameter Jammer

Are you a Revit MEP user and frequently download Revit content from manufacturers or sources like BIM Object? Once that content is loaded into the project, is there a struggle to get the family properly to work with your schedules? Well than the CTC Parameter Jammer tool is the one to help solve these problems.

Downloading Revit family content regularly brings along shared parameters to your project that are different from your company’s standards. This will give inconsistent information within the schedules. Use Parameter Jammer to deal with those problems.

Here is a schedule with a family loaded into a project but does not have information populated because of the inconsistent parameters from the family to the project.

Run Parameter Jammer

With a simple user interface, there a couple steps needed to map the loaded family’s parameters to match the project.

  • Select your companies shared parameter file
  • Select the schedule that the family will be residing in
  • Select the family/families that the parameters need to be modified

In the next window, you will get a list of all the Shared Parameters from the selected schedule along with the family parameters. From the family parameter list, you will apply what needs to be done to the family. Parameter Jammer will also find same named parameters and automatically map them. When you select the drop-down list, you specify a family parameter to match the ones in your schedule. It will only show parameters that have the same units. You can also create a new instance or type parameter for the loaded family.

A final report will be displayed to show what has been done.

As you can see, downloadable content being used in a project does not need to have much modification for it to work properly in your current projects. Parameter Jammer gives you the ability to quickly grab information from the new loaded families and map those parameters to meet your company standards. Your schedules will be up to date and have no missing information in a matter of a few clicks using Parameter Jammer.

What’s new in Revit 2021

By Camila Lima Pires , Technical Consultant AEC at SolidCAD


Revit 2021 comes with many new features and improvements. I have highlighted some of the multidiscipline Revit features in this post.

User Interface feature

As soon we open Revit 2021 for the first time, we notice an improved Home screen with an User Interface Wizard to help us set up the ribbon based on our discipline and focus on the tools that matters to us. You can also modify the user interface in the Option menu.

Generative Design

Revit 2021 comes with a Generative Design tool designed to help us taking advantage of computing power and quickly generate and explore design alternatives which can helps us to solve design problems.

With this new tool, you will be able to specify constraints, set your goals and inputs and then automatically generates design iterations directly from the model.

Credit: Autodesk

Change the appearance of a Schedule

In Revit 2020 there is a tool called Stripe Rows but we can’t choose the color and it is not visible when placing the schedules on sheets.

In the Appearance properties of a schedule in Revit 2021, there is a new feature that allows us to add stripped rows and choose a color making it easier to visualize schedules. There is also a check box to turn on the stripe rows on sheets.

Enable View Filter

In the Visibility/Graphic Overrides dialog, under Filter tab, we can turn a View Filter on and off without needing to delete it from the list using the Enable Filter command. It differs from the Visibility command which turns on and off all the elements in a view.

Slanted Walls

When selecting the walls, there is a new parameter added called Cross-Section. This parameter allows us to change from Vertical to Slanted walls. When set to Slanted, the Angle from Vertical parameter becomes available. By default, the angle is set to 0 degrees. You can add a positive or negative angle which will slant the wall to exterior or interior.

The windows and doors hosted in slanted walls can be modified by changing the Orientation parameter from Vertical to Slanted.

Real-time realistic views

The new Realistic visual style provides a better visualization and better navigation. See image below.

PDF and image linking

In Revit 2021 allows us to link PDF files and images. With this new enhancement, the linked file can be reloaded when the referenced file is modified.

The Manage Links dialog has been updated as well and now includes a PDF and an Image tab. Now we can use this dialog to find the image/PDF in the file using the Show button, place an instance of an image/PDF using the Place Instance command and add a new image/PDF using the Add… tool.

Rotate Text in Tags Enhancement

The family parameter Rotate with Component in the family editor has been added to more tag categories including furniture and specialty equipment for example. For a full list of the categories check Rotate Tag with Component.

Get Autodesk Content

During the installation, Autodesk is not providing all content. Users can download the out-of-the-box content using the Get Autodesk Content tool on the Insert tab.


This is some of the new features in Revit 2021. To learn more about these features and much more, check the Autodesk website.