Excel Costo in to Revit Families

Hi there, im trying to map cost from an excel sheet to the family cost parameter.

right know i have created a parameter for Coding the elements in revit (exp: SKU: 277620-0), in Excel i have one column with the codes and another with the corresponding price of the item.

im almost done with the script but i dont know how to map the cost to the corresponding code

for example i have to assign the same cost (24990) to the chairs that have this code(SKU: 266670-7) how can i do this?

Excel

 

 

 

5D

5D

Hi Ricardo,

I’ve made my thesis about cost to a project. I created a parameter “Identification cost” and then I filter elements with the same parameter and set the value.

1 Like

Hi man! wow this was a lot of time ago! when i didn’t know that much about list and dictionaries.
the most effective way i found was using Dictionaries
here is the link on how those works just in case you didnt use it

It’s very good. I was finding out about your thesis and it sounds interesting. Is there any way to access and read it?