Forums >> Revit Systems >> Technical Support >> Creating Room Data Sheets

archie456

active

Joined: Mon, May 17, 2010
181 Posts

 Hi,

I’ve been looking at creating room data sheets from Revit. The method I’ve thought of is this:

1. Create Room Data parameters in Revit for the room object which will hold all of the room data information.

2. Create a schedule which lists all the required Room Data information from the room space

3. Export this schedule as an Excel Document

4. In Word, create the desired room data sheet layout for one room.

5. Use Mail Merge to create take information from the Excel document and create a load of room data sheets for all rooms.

Is this a good method of doing this – is there something better which I’m missing?

Cheers.

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Revit has a built in process for this.  Look into using schedule keys.  You could set up a schedule key that has all (or some) of the room data defined by a category you select or add.  For instance using the Room parameter Name, you might set up a schedule key for all finishes for rooms named CLASSROOM.  For any room not having a schedule key (or any parameter that a schedule key doesn't address), you can still individually add those values.

Be careful with these and thoroughly understand them before using.  If a schedule key assigns all finishes but you want to change one item, like the floor, then you can't do it without modifying the key for that room.  This is why using room name might be a poor schedule key "key" and maybe an added parameter like "Finish Type" might be better.  You could have Finish Type - "All" be all finishes and finish Type - "Walls" might just be walls and with no Finish Type assigned, all values would be unique..

This user is offline

archie456

active

Joined: Mon, May 17, 2010
181 Posts

Thanks - I'll look at schedule keys.

But my post was more about actually outputting room data sheets.

The only way I know about displaying room data information in revit would be via a schedule - whereas we want to have a one page per room document with all the particular rooms info on the page.

I don't think this can be done in Revit (can it??) - which is why I proposed the method above?

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Sorry, I guess I didn't understand and still don't.  If you are wanting to add additional data that is not in your schedule, or if you want to format it in a way that Revit can not, then what you are doing will work.  But if the data is in a Revit schedule, then why not do that one page per room as you want?

This user is offline

archie456

active

Joined: Mon, May 17, 2010
181 Posts

Basically, I'm trying to create sheets like the one attached, the data being held in the Revit model in the Rooms.

I don't think I can create sheet like this in Revit, only a schedule ? And so to create this sheet I'll have to output the scheduel as an Excel file and then use Word / Excel to create the sheets - I'd use the method I detailled in post 1 above.

Or am I wrong on this?

Attached Images

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

I wish you had posted this at the beginning. 

Because of the special formatting, this has to be done in another program but you could export your Revit information by room and set up your excel file to read the data from each export automatically.

This user is offline

archie456

active

Joined: Mon, May 17, 2010
181 Posts

Thanks!

This user is offline

Room Data Sheet (inc furniture and doors) using a Room Tag

2

Program Data Sheets

4

Creating a content checking within each space created

3

Room Data Sheets & Schedules

1

Work around for sheets and new project

3