Hatch lisp? problem

[aesoton]

I have a layout of a building in dwg format. I have analysed the building in Excel and have specific values to be applied in each room. What In want to do is colour each room depending on the number calculated in Excel. I know I can do this with a hatch but to do this manually for each room would take forever + the values may change as more information becomes available. I have thought about writing a macro or lisp but my experience of doing this in autoCAD is limited. Has anyone else had a similar requirement? If so do you have a sample piece of code you could give me?
Thanks in advance
Andrew299

 

[CarlB]

A script or lisp working off data in a csv file may be able to accomplish this. But there needs to be some connection between the room number and the location on the drawing to tell AutoCAD where to place the hatch. For example an x,y coordinate within each room. Or have a closed polyline for each room on a layer identified by room name, which the routine could find and apply hatch to. Or you could have each room pre-hatched on individual room hatch layers, and the routine/script would change the layer colors.