Thanks for your suggestion. I work with CATIA (a CAD program) and I am
not sure how to capture data when reading this drawing. Since I have
the sensor layout in excel, i was hoping i could use macros to perform
some function. But i think this scanning process is highly
complicated. Even CATIA too have macros functionality but i dont know
how to use them. what do you mean by putting design in some vector
format?

On Mar 22, 12:50 am, "NickHK" wrote:
So you mean that from a picture, you have to calculate the position of a
certain element of that picture, some kind of graphic pattern matching ?
Whilst VBA with the GDI/GDI+/DirectX API can do it, you would need to read
on the concepts behind the techniques.

As such, it is not an Excel question until you have some aspect of the code
that is giving you trouble.
Maybe some of these will helphttp://www.google.co.uk/search?q=image+processing+VB+-net&btnG=Search...

If you know the coordinates to examine, the process will be more easier, but
by no means simple.

Unless I have missed the point, which is quite possible...

If you can get the designs in some vector format (AutoCAD, Illustrator etc),
it would be much easier, as then the locations of the elements is exposed.

NickHK

wrote in message

oups.com...



There are two layouts. One layout is the sensor layout where the
sensors are oriented in a circle and the other layout is the part
layout which consists of some big and small circles. The part layout
is going to be placed on top of this sensor layout. From there, all
the 32 sensors has to read the part pattern properly and each sensor
has to give an output such as 0, 1, and X. 0 means the part is not
covering the sensor, 1 means the part is covering the sensor, and X
means the part is partially covering the sensor.

Excel may not be the right environment to do this but how can I solve
this problem? This requires creating some decision logic to scan the
layouts and decide. Please let me know if you have any more questions.
Thanks

Swamy

On Mar 21, 10:22 pm, "NickHK" wrote:
If you are talking about comparing regions/pixels in graphics, then
Excel is
probably not the right environment as such.
Do you mean something like OCR - Optical Character Recognition ?
I really do not understand what you mean by "produce a significant
output
stating where the sensors should go on or off and then assign values to
the
sensor".

NickHK

wrote in message

oups.com...

I have been assigned a task where there is picture (blue print of
sensor patterns) in excel and when a blue print of a part is placed
on top of this picture, it should produce a significant output stating
where the sensors should go on or off and then assign values to the
sensor. Is there a way to capture data from scanning this image?
Thanks in advance

Swamy- Hide quoted text -

- Show quoted text -