Working with NV5, we have found a way to automate our heat map diagramming in Revit with Dynamo. Revit with dynamo scripts is able to pull data from Excel and place it on the Revit model. We have been working to improve the process and increase the efficiency of our heat mapping. Below is an example of one of the floors I have produced.
