Pressure assignment to roof structure diagram - database linked

Hi

I have a drawing of a roof (circular) with various pressure readings at various locations (see attached file - capture 1 for overall idea, capture 2 and 3 for naming convention and locations). Each location will have a value assigned and is in an excel file (Ie A1-10, B1-10, etc) and I'd like to ideally plot contours over the surface of the roof to indicate the different pressures. However, it may be more beneficial to simply shade the localised area of the location on the diagram and the 'range' assigned will dictate a different shade of colour that the value falls into - similar to the 'conditional formatting' function in excel.

So at the end of it, I'd like to have the same drawing that is shown in Capture 1, that is completely shaded with various shades that correspond to the value that are linked to an excel file for the various locations, and can be tailored depending on the 'range' assigned (ie smaller or larger ranges eg 0.1 to 0.2 or 0.1 - 0.4).

I have added Capture 4 which gives and indication of what I am after. I have drawn (by hand) the contour lines on the overall drawing and interpolated between pressure points. This is the ideal method, however I suspect it could be difficult to have a program that triangulates contours based on certain ranges. The alternative is to shade the data points (slightly larger boundaries than highlighted manually on the drawing) and assign a different shading based on the range that the data point falls into.
The drawing output would be linked back to the data that would be in an excel file (and each data point on the drawing have a reference location - eg A1-10, etc) as per the naming convention above.

AutoCAD Database Programming Matlab and Mathematica Microsoft Office Software Architecture

Project ID: #6747950

About the project