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

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
ups.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

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

ups.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

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 help
http://www.google.co.uk/search?q=ima...G=Search&hl=en

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

ups.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

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 -

Please confirm that initially you were thinking of working with pictures (as
in bmp, jpg etc) to match the positions ?
If so, this is difficult for the reason I explained.

If you have the coordinates in some numerical form, then Excel is an option.

I don't use CAD app much, but I know you can automate AutoCAD (and it has
VBA ?), so access the positions, properties etc of the elements.
No idea about CATIA, but according to http://en.wikipedia.org/wiki/CATIA
<Quote
The application programming interfaces supported are as follows:
The Fortran and C programming languages for version 4 (V4).
The Visual Basic and C++ programming languages for version 5 (V5).

These APIs are referred to as CAA for V4 and CAA2 (or CAA V5) for V5. The
CAA2 are component object model (COM) based interfaces. They provide
integration for products developed on the CATIA suite of software."
</Quote

Maybe you should look at that.

NickHK

wrote in message
ups.com...
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 -