Is there any way that I can copy the pattern of a location heirachy for example Main buidling>Floor>Room. Is there a way of copying the amount of rooms and its names from maybe floor 1 for another 15 floors, rather than inputing the information manually?
I know I can define it one by one and set the location and define whats in side that location, and so forth, but can I repeat the pattern somehow?
Solved! Go to Solution.
Solved by a.schear. Go to Solution.
Do you have a Revit model you can export room locations from? That can be really helpful. If not there is a way to use Excel functions to do this.
Here is where I have the attachment I use to explain exporting from Revit. Some people prefer this way finding it much quicker and some aren't comfortable with functions and end up typing it up.
This takes some time to muddle out for the first run but will save you MUCH MORE time down the road, because you can use the same process to assign locations to anything that has it's room number as a property or as part of a data set.
i.e. B4=concatenate(B3,">",B2,">",B1) = Building X>Level1>XYZ-123
I can tell you have struggled through this more than once.
I too find that using formulas in excel similar to what you described can make this process much more efficient and agree that the effort is worth the downstream efficiency that is created.