Trying to make a lighting schedule with room names or numbers

[ben_yusman]

Hi,

     I am working on a project that has varying mounting heights for the same fixtures throughout many rooms, so I figured I would make a schedule to show the type mark, the elevation, and then either the room number or name that the light is placed in. I have the first two, but I am having trouble finding a way to get the room information as well from the linked architecture model. This schedule is just going to be reference material to help me along with finding the lights that need sheet note references quicker, so not a big deal if this is not possible. Any help would be greatly appreciated.

[iainsavage]

It seems that light fixtures don't know what room they are in, there's no parameter for that?

So it would probably need to be a Dynamo solution to check for coordinates of each light versus coordinates of each room.

I'm sure this has been asked before so there's probably an existing script out there which would do this for you.

[iainsavage]

Actually I did a bit of research (I don't do electrical) and it seems that it should be possible to schedule the room that the light is in but there are posts in which the behaviour doesn't work and I can't get it to work in the Autodesk MEP sample file which I have opened. 

Maybe someone electrical can contribute to this post.

[RobDraw]

I can't remember exactly what it's called but there's something like a room point that can be added to families. 

[sragan]

yes, there is a room point you can move if you edit the family.

I think you may also have more luck using spaces.   They can be automatically populated from the rooms in the linked file.

Also, make sure your link is set to "Room Bounding"

[iainsavage]

To help the OP I tried this in the Autodesk RMEbasic sample project and there was no option to include rooms or spaces in the lighting schedule, with or without the Room Calculation Point enabled. The rooms and spaces are in the project, not in a link. There is no "Room" or "Space" parameter available in the list of schedule fields and there is no Room or Space parameter listed in the light fixture properties.

I found this post on Revitforum:

https://www.revitforum.org/node/38954

[sragan]

Did you try using the Drop Down at the top of the Properties window and picking Space or Rooms?

Of course, then you also have to sort by Space or Room Name or Number.

[ben_yusman]

I did try that, but no luck.

[sragan]

So you have the fields in the schedule, and it looks like you have "every instance itemized", which is good.

it looks like the lights just aren't in the room.  I think the spaces default to an 8' height, and your fixtures are higher.  So you either need to make sure the rooms and spaces are maybe 13' or 14' tall, or you need to edit the light fixture family, and select the "Room Calculation Point", and drag it about 5' lower than the light.  (This can be tricky sometimes because sometimes the lights get inverted so they are inserted upside down, so make sure you drag the point the right direction.

[ben_yusman]

I tried each mentioned step, but neither ended up working and I also cannot find the linked room boundary that you showed in the second image.

[ben_yusman]

I do have the room calculation point turned on and I even dragged it way down as you suggested, but still no change in the schedule.

[sragan]

If your rooms are from a linked file, to get the linked room boundary, go to any view and select the link so its highlighted, and then go to the properties window.   Hit the "Edit Type" button in the properties window, and its the first item listed.

If it still doesn't work, maybe try to make a new project with just a couple of rooms in that project, and see if you can get it to work.  Then try linking a file and see if that will work.  

[ben_yusman]

I was able to find the room boundary check box, but still no change to the schedule.

[sragan]

I do know it is possible:  Try scheduling the spaces and see what you have.

 

[ben_yusman]

I have tried that already with no results, unfortunately.

[ToanDN]

You cannot reference Rooms in the linked model in your lighting schedule.  Make the link Room Bounding and create Spaces in your own model to match the linked Rooms then you can show Spaces in the schedule.  

[HVAC-Novice]

Works for me with space names and numbers (my current project doesn't have rooms, so I didn't try rooms).

I'm on R2024, but don't think that matters here. 

[iainsavage]

---

@sragan  schrieb:

Did you try using the Drop Down at the top of the Properties window and picking Space or Rooms?

Of course, then you also have to sort by Space or Room Name or Number.

---

That worked for me now, as I said I'm not electrical so don't usually use lighting schedules:

[motaz_moshed]

Thanks ❤️

[tkbim]

The rooms may not be placed with the top height to fill the space.

I see this all the time with our architects.

I usually have to fix the limits on the rooms.

Check and see if you can tag the rooms in the links.

If the link has Room Bounding checked, you can create spaces in your model and fix the limits.