Room Schedules

[mitch.cornelius]

I've seen some discussion about this in the API group, but I wanted to see if anyone has tried it. I have a program with room numbers, room names, wall-base-floor-ceiling finishes, and a couple other parameters. All the information is stored in excel and I'd like to somehow import that into a revit room schedule (or at least be able to copy information between). Has anyone tried this and been successful? Have you seen a step-by-step instruction?

My project is has over 1000 rooms in it and I don't want to manually enter all of that information...

Any help is appreciated. Thanks!

[sfaust]

If you know any programming or have someone in your organization that does this can be done through the API. You could make a "quick and dirty" application for this pretty quickly I think.

If you don't have rooms in your project yet, you can make a program to just create a new unplaced room for each line, then you can place them with the room tool.

If you have rooms already in your project, you will have to have some field for Revit to match between the Revit and Excel, i.e. the room numbers will have to be the same or something..

Outside of the API, I don't think you can import the info, you'd have to type it manually.

[mitch.cornelius]

That is what I was afraid of. An extension akin to the "excel based model generation" would be greatly welcomed. I suppose this functionality is already on the wish list anyway...

[twiceroadsfool]

Not that its a great help if all 1000 rooms are different, but might i suggest a Schedule Key, if a lot of the fields are the same for a lot of the rooms? (If its 1000 rooms, i have to believe its a repetitive storey building, but i may be wrong...).

The Key Parameter would still have to be selected, but between the Key Schedule and Groups, you could have them all filled out in a matter of minutes...

If all 1000 rooms are different...... I hope youre hourly. :)

[sfaust]

Yeah, would definitely be a welcome addition. If I have some extra time I'll see if I can work something up, but probably wouldn't be for a while...

[mitch.cornelius]

might i suggest a Schedule Key, if a lot of the fields are the same for a lot of the rooms? (If its 1000 rooms, i have to believe its a repetitive storey building, but i may be wrong...).
Right you are, it is a 10 story building. However of the 10 stories, only 2 are identical (the layouts are identical, but the finishes aren't...aye aye aye). Each floor does share the same core which ends up being about 10 rooms. I did do a schedule key for those core areas, but it didn't help a whole lot.


If all 1000 rooms are different...... I hope youre hourly. :smile:Since a majority of the rooms are different, I wish I was hourly...

By the way, I finished adding the rooms and all information up to the 7th floor, with room numbers all the way up. It turns out there are 1053 rooms...good guess :)

[mitch.cornelius]

Yeah, would definitely be a welcome addition. If I have some extra time I'll see if I can work something up, but probably wouldn't be for a while...

If and when you get time, I'd be very appreciative. This problem happens on most projects I work on...

Even if I had to click the "new" button for each room in Revit and assign a room number then bring in the schedule, I would still be much better off...

[sfaust]

Ok, I'll see what I can do. Could you send me a personal message with an example of what the excel sheet looks like?

[Andre Carvalho]

Ok, I'll see what I can do. Could you send me a personal message with an example of what the excel sheet looks like?

Now that's another thing I like about AUGI. People really doing their best to help each other.

Thanks Steve! :beer:

Andre Carvalho

[DaveP]

Check out www.ReviTTools.com . They have a tool that does pretty much what you're looking for. You can get a singe license for about $350. That's about your hourly rate, isn't it?;)

[Andre Carvalho]

Just a correction: The website Dave mentioned is http://www.revittools.info/

Andre Carvalho

[sfaust]

hm... that would probably be more robust than I would do. Let me know if you decide to go with that, otherwise I'll get to it when I can...

Thanks,
Steve

[mitch.cornelius]

I think that tool is going to work perfectly, thanks for the link!