Room wise Data extraction of objects

[Anonymous]

This is my sample file in which i want to extract data in the form of excel.

I want to extract it in particular format like

Column A          Column B            Column C                            Column D (optional)

Room Name     Room Number    Layer Name of object       Count of objects

Example

Office                 L1-5471               Bulb                                      5

Office                 L1-5471               Light                                     1

Office                 L1-5474               Bulb                                      3

Is it possible to do in cad?

[pendean]

Are you actually using AutoCAD ARCHITECTURE? you are in the plain AutoCAD forum.

[JTBWorld]

If using regular vanilla AutoCAD take a look at this https://knowledge.autodesk.com/support/autocad/learn-explore/caas/sfdcarticles/sfdcarticles/Creating... 

[R_Tweed]

Provide something in common between the symbols to sort and filter, the more in common the more filter options. You could use layering but then your dwg might get bloated. I would think an attribute would work best in my opinion. I've attached a screen cast to explain. Please,Still working out how to use screencast

[Anonymous]

This is a sample I worked up using (invisible) attributes in blocks, and the data extraction wizard built into AutoCAD.

Without having your geometry, I just whipped these blocks together sorta close, but they should get the point across.

The dwg and dxe files must both be extracted from the zip file (apparently a dxe file extension is too close to a .exe for a direct upload, thus the zip file) for it to work. See >link< for further info on data extraction. It's a great tool, I use it all the time. I won't say you are limited only by your imagination, but close. (slight exaggeration)

Hope this helps

[R_Tweed]

Screencast attempt #2