SPACE TOOL/Space Planning

[HEengineering]

Ok so I already have recived some great feedback on this board and Im looking for a bit more. Im curretly working in 2011. I have a a building with multiple rooms. I have used the space tool under the SPACE PLANNING toolset. I was able to trace each room to generate each space. Then I placed lights in each space. From there I tried to create a report that would show me how many lights are in each space. The issue Im having is it seems I can only generate a report for all lights and another for all rooms. I cannot figure out how to create a report that will tell me HOW MANY LIGHTS are in EACH room. Right now I can only get a seperate count on lights and a seperate count on rooms. Ive attached a picture for clarification.

[michaelk]

Someone may correct me on this, but I don't think you can use space objects as locations. At least, I've never been able to get that to work.

It does work well with polygons, however.

I'll attach a simplified example. I usually just add an invisible location layer.

hth

mk

[HEengineering]

Im not following? I see where you have the spaces on the seperate design layer. I guess Im asking is it possible to create a report that will tell me for example

room 1 has 3 lights with 6 bulbs.

Room 2 has 4 lights with 8 bulbs.

I was under the impression you could create a report that would tell you what items are in what spaces?

[HEengineering]

Whoops ok my classes were acting silly. I do see the report....let me see if i can figure this out! A little more guidence would be great.

[HEengineering]

I guess my question is how did you select the different lights in the report? I only am able to use the default selection in the report? Also I see in the report you named the rooms but I dont see that in the drawing? It would be great if you could post some general steps. But this is exactly what we are looking for.

[michaelk]

After creating the location geometry click the Data tab of the OIP.

Enter the name of the room in the top field.

That name will work for a location call of anything inside the boundary of that object.

for example =COUNT(LOC='room name') will return the number of objects inside the room.

=COUNT((S='fixture symbol name') & (LOC='room name')) will return all the fixture symbols called "fixture symbol name" within the boundary of the "room name" object.

You can add a nested symbol for the lamps and count those or simply multiply the fixture count to get the lamp count ...

Let me know if that doesn't answer your questions.

hth

mk

[michaelk]

Wow, Petri.

I'm going to have to spend this evening taking that apart ...

Thanks for posting it.