Hi Folks! This is my first Dynamo post (a few simple questions) although I have read many of all yalls post and answers and have learned that I have much to learn. I look forward to when I’ll be able to contribute and help answer some question. But please for now know how grateful I am for any and all assistance getting myself up to speed.
Now for my questions, I have learned how to export and import information from Revit to Excel and Excel back to Revit thanks to you all! My question is this, When my information is dumped into Excel it is all lumped together. I would like to get the information better organized in Excel.
My Dynamo graph is for a finish schedule.
I’m grabbing the Room Number, Room Name, Floor, Base and Paint Finishes.
When the information is exported into Excel, the Room Numbers are not sequential. This makes me sad How would I get the data to hit Excel with the Room Numbers being in order (A101, A102, A103, B101, B102, B103, A201, A202, A203, B201, B202, B203)?
I would also like to to know if there is any way I can format certain lines using Dynamo? Our office finish schedule has project header and footer information and the “sheets” are set up, so I know I don’t need anything there, but I would like to have a line for each level saying “Level 1” with all the A101, B101, C101 rooms under that with another line for “Level 2” with all the A201, B201, C201 rooms under that etc., etc., etc., (said in King of Siam’s (Yul Brynner) voice).
I’ve attached some images of what I have so far. Please let me know if you need more details.
Revit 2018, Office 2016, Dynamo 126.96.36.19911