Hi everyone, I’m a complete beginner in Dynamo and need some help. Please excuse my Dynamo ignorance as I’ve only ever used it within Revit and not done any actual script writing.
So here’s what I’d like to create using Dynamo:
A Room Data Sheet within Revit for a Min. Room Requirement’s in a Hospital, I’d like Dynamo to take info from a Excel spreadsheet and then turn it into a RDS in a revit sheet. I have an example of what I’m looking for here:
Any help or direction to where I could start/how to do it would be greatly appreciated.
The approach we use where i work is we have users enter their data into a massive excel table where the first column will identify the room in revit by number which our routine searches for in active and linked document rooms. It draws on live area and name to avoid double handling.
From there each column is a data field that we map into a generic annotation family where various parameters in that family receive matching column data from excel, displaying it to the user in label fields. That is then placed on a sheet (usually rooms have 3-4 A4 pages each.
We separate graphical/nongraphical entirely, so any views are instead put together as a room layout sheet (plan, elevations, 3d, rcp, revit equipment list), which we have developed a separate toolkit to produce altogether.
Both are very complex but dynamo could technically handle both. We switched both over to c# a while ago for better flow control/error handling as giving users an excel file is always dangerous unless it is significantly locked down in layout.
We follow the ahfg RLS look and feel typically for reference:
I have a free example of how dynamo can produce rds’ from revit key scheduling systems as well here (no excel, just revit data > rds):
1 Like
