Compare Space Name in Revit lookup excel add adjacent properties from Excel to Revit

Hi Arun,

Used dictionaries to match the space name in revit to excel space names and now how do I push other meta data information (Space information such as Load, Occupancy, Energy, etc) from excel to Revit?

I need these parameter you see below to be updated from excel.
so I should make my dictionaries match these ?

You only need one dictionary. The dictionary should be structured so that the space name is the key, and the list of parameters as the value.
So if we look at the values from Excel:
image
The dict should be structured something like this:
{'Space 1':[3, 10, 240], 'Space 2':[4, 3, 75], 'Space 3':[5, 4, 120]}

When this is out of the way, it will be about list management to get the right values into the right parameters :slight_smile:.

Here’s my attempt:

I’ve attached the dyn so you can have a go and see if it works for you.

Good luck.
SpaceInfo_Dict.dyn (55.8 KB)