Pixels

Hi I know this is nothing to do with Excel but I also know there are
a lot of intelligent people out there.

My daughter has a uni project and she needs to count the number of
changes in a cancer cell slide - before and after treatment. There
a 20 before and after slides in all.

Basically the treated cells turn different shades of brown and she
needs to count the number of cells that changed colour (shades of
brown)

Note there are a lot of pixels ! per slide.

Help – point me to a group etc that can help her or maybe one of you
Excel experts know how to...

Johnnyboy

On Feb 21, 12:30*pm, Johnnyboy5 wrote:
Pixels

Hi *I know this is nothing to do with Excel but I also know there are
a lot of intelligent people out there.

My daughter has a uni project and she needs to count the number of
changes in a cancer cell slide *- before and after treatment. * There
a 20 before and after slides in all.

Basically the treated cells turn different shades of brown and she
needs to count the number of cells that changed colour (shades of
brown)

Note there are a lot of pixels ! per slide.

Help – point me to a group etc that can help her or maybe one of you
Excel experts know how to...

Johnnyboy



Are all the slides of exactly the same area? In other words, can you
stack the slides and produce a time-laps of cells?

Is each cell exactly a pixel or can it be a group of pixels? Do the
cells need to be "detected" in the image?

Are the slides taken using the same lighting condition or do they need
to be adjusted in some way before colour changes are detected?

/reza

On Feb 22, 2:39*am, reza wrote:
On Feb 21, 12:30*pm, Johnnyboy5 wrote:





Pixels

Hi *I know this is nothing to do with Excel but I also know there are
a lot of intelligent people out there.

My daughter has a uni project and she needs to count the number of
changes in a cancer cell slide *- before and after treatment. * There
a 20 before and after slides in all.

Basically the treated cells turn different shades of brown and she
needs to count the number of cells that changed colour (shades of
brown)

Note there are a lot of pixels ! per slide.

Help – point me to a group etc that can help her or maybe one of you
Excel experts know how to...

Johnnyboy

Are all the slides of exactly the same area? In other words, can you
stack the slides and produce a time-laps of cells?

Is each cell exactly a pixel or can it be a group of pixels? Do the
cells need to be "detected" in the image?

Are the slides taken using the same lighting condition or do they need
to be adjusted in some way before colour changes are detected?

/reza- Hide quoted text -

- Show quoted text -

Only in pairs - before after - different pairs
A group of pixels - no they dont need to be detected - just counted
+/- a few
No the pairs can be in different lighting / cameras etc. No
adjustements needed - they are just before and after - and its quite
clear what areas have turned to shades of brown on the 2nd slide
(cells which reacted to treatment)

thanks

Johnnyboy

From the get go, I have absolutlely no idea about said subject, although
from my limited logic processing:

These Slides would be photographed in what format...????

Said format would have to be able to be converted to a wireframe format of
sorts thus placing each pixel in columns and rows so they are
seperated/isolated from each other so as to individually count pixel shade
variations, importable into an Excel spreadsheet.

Lets assume for the sake of the exercise that it was possible:

Sheet1 has the before and sheet2 has the after, you could look at a Case
Select argument whereby you would have something like

Case Select True

=CountIf(MyRange.BackColor: = Brown)
=CountIf(MyRange.BackColor: = Black)

Etc

Just to give a hazy insight to what maybe plausible given the above
conditions....

The exercise of comparing between before and after slides will be somewhat
moot if you can't at least go some way to seperate each pixel shade. (using
excel as a platform at least)

Having said that, once each Sheet is compared, you will have the difference,
then again, I may be totally wrong and get shot down in flames by someone
who has clearer insight as there are several Demi-god MVP Guru's who may
have a better analagy and understanding who can bring alternatives to the
table.


Good luck

HTH
Mick.