I want to take a series of floor plans, currently in .dwg format, and have individual rooms coloured to match the conditional format in an excel spreadsheet which contains data about those rooms.
I'd like to be able to re-use the software so that I can create a heat map of different buildings with different spreadsheets.