This script will find all the enclosed rooms in your Revit model, calculate areas by asset name (e.g. Commons, Dorms, Corridor – you create the definition)
Confirmed working in Dynamo 1.3.0+ Make sure the names in the dynamo file match the room naming in the Revit file. i.e. “Student Room” in Dynamo need renamed, “Dorm Room”.
It will calculate the square footages and feed that back into your Excel document. The Option selection in the excel document will then update those asset types in accordance with the color/option selected AFTER hitting save and Dynamo is set to Automatic.