I am trying to find the missing link on writing data from excel to Revit parameters, in this case parameters for Revit MEP spaces.

My ultimate end goal is to populate each space in an HVAC model with a parameter for the supply airflow required to the space which we calculate in an excel spreadsheet.

I effectively end up with two lists from excel (one of the space names and one of the supply airflow rates corresponding to each one of those spaces) The order of these lists correspond. In other words, the first item (space name) in list 1 corresponds to the first airflow in list 2 and so on down the line.

My question is, how do I write this script to make sure the association of the lists holds correctly and does not scramble the airflow for one space and overwrite the parameter for an incorrect space in revit?

It seems like the space names in the excel file must match that of Revit exactly and I should then be able to query for space name line-by-line down the dynamo list and overwrite the airflow parameter sequentially line-by-line using the rates from the second list but I am not sure how to accomplish that.

Any input on if this is heading down the correct path?

Supply Airflow from Excel to Revit_MSW.dyn (51.6 KB)

Thanks folks!