I am trying to get revit to autogenerate BOMA values from area plans in a model, and export them to a spreadsheet. I also need it to be as automated as possible.
The way I have it running now, I am able to sort the areas based on an area number that I give them in a schedule. I found that if I give all Building Common Area the designation “1”, the Office Areas as “2” and the Unrentable as “3”, I am able to get them into separate lists that I can then run through a python script to perform the necessary calculations and send it to excel.
I can’t find any way to automate the sorting of areas in to lists based on their types. Right now, I need to manually enter a number designation to each new area that I create, which leaves too much room for human error. Is there a way to either sort based off of the text parameter of “Building Common Area” or similar? Or if not, is there a way to automatically coordinate the number designation when I select the area type?
I tried to upload the BOMA file as well, but I am a new user, so it won’t let me. Hopefully my description is enough to get the message across.