Jump to content

Color code rooms based on room numbers


Recommended Posts



I'm wondering if CAD could be used to solve a very very tedious and error prone thing I do on occasion at work.

I guess this all hinges on the very premise of how .dwg files and cad work, does cad have any concept of a room and it's attributes &/ objects?
Let me quickly explain what I manually do, and hopefully someone can tell me if CAD is a path worth pursuing :)

I'm not afraid of learning new things, but I'd like to know if this is a feasable project for me to start on during christmas :)


What I do:

I have a PDF file with the layout of a building where each room has a room number, then I have a excel sheet with all the room numbers and some data which indicates a color the room should be.

I then have to use a paint program to color each room to the appropriate color based on it's room number. This is very tedious and naturally error prone.

I also have access to .dwg files of the building plan, when opened in CAD I can see that the room numbers are stored in a Block Attribute with the tag "ROOM_NUMBER" so the information exists in these files atleast.


Now the question:

Is it feasable to use cad to create a pdf or image file where it sets the background or fill color based on the room's attribute "ROOM_NUMBER"?

Link to comment
Share on other sites

Yes it exists maybe something close already using lisp to do what you want, the quickest way is to export out of excel a csv file of room Numb,colour. Its a simple match then to find the room number and hatch an area using a solid hatch with correct colour.


Post a sample dwg. Only need a couple of rooms and a csv file with roomnumb , colour.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...