A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calculating Area of Scanned Image



 
 
Thread Tools Display Modes
  #1  
Old July 22nd, 2004, 09:32 PM
ntegrat61
external usenet poster
 
Posts: n/a
Default Calculating Area of Scanned Image

Does anybody know of a windows program (maybe Excel) that would calculate the area (in pixels or any other unit) of a scanned image?

For example, if I were to draw circles on a sheet of paper, scan the paper into my computer, and then fill the circles with red paint in Microsoft Paint, is there a way to find out the area on the screen that the red paint occupies? I am hoping there may be a program that counts red pixels, for example.

I tried to relate file size (in bytes) to amount of red paint, but there doesn't seem to be a relationship. If the files are saved as a bitmap, for example, they are all the same size regardless of the amount of color the image contains. If the files are saved as *.jpg, the file with less color turned out surprisingly larger.

If I can quantify the amount of red color in any way, I will be able to convert into the units mm^2 because I can also scan a calibration square that is known to be 1 mm^2.

Thanks a lot.

Michael
  #2  
Old July 22nd, 2004, 11:09 PM
Phil Platt
external usenet poster
 
Posts: n/a
Default Calculating Area of Scanned Image

Hi Michael.

You need an image processing program, such as Photoshop. This will give you
a lot of information, for example the percentage of the image that is red.

In a bitmap, the fact that a pixel is red or any other colour doesn't affect
the file size - every pixel has the same amount of colour information and it
only varies according to the number of colours that can be assigned to a
pixel - eg 8, 16, 24 or 32 -bit. Also the resolution of the image affects
file size.

JPG assesses 8 x 8 pixel blocks in an image and assigns a single value to
the most common colours in the block, using an affiine cosine transfromation
algorithm. In short, it degrades the image by removing subtle colour tones.

The higher the quality you choose when saving the file, the less degradation
it does, and thus the best quality images are always larger files.
Incidentally you notice a lot less degradation with files that have a
majority of blue pixels 'cos the human eye can't detect as many shades of
blue as it can any other colour... thus highly-compressed seascapes look
better that the equivalently-compressd landscapes!

Anyway, try Photoshop's image calculation routines, they should provide you
with what you need.

(I think Paintshop Pro may offer similar functionality, and it's cheaper!)

HTH
Phil

"ntegrat61" wrote in message
...
Does anybody know of a windows program (maybe Excel) that would calculate

the area (in pixels or any other unit) of a scanned image?

For example, if I were to draw circles on a sheet of paper, scan the paper

into my computer, and then fill the circles with red paint in Microsoft
Paint, is there a way to find out the area on the screen that the red paint
occupies? I am hoping there may be a program that counts red pixels, for
example.

I tried to relate file size (in bytes) to amount of red paint, but there

doesn't seem to be a relationship. If the files are saved as a bitmap, for
example, they are all the same size regardless of the amount of color the
image contains. If the files are saved as *.jpg, the file with less color
turned out surprisingly larger.

If I can quantify the amount of red color in any way, I will be able to

convert into the units mm^2 because I can also scan a calibration square
that is known to be 1 mm^2.

Thanks a lot.

Michael



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Gripe about Word and image placement Harlan Messinger Page Layout 31 September 13th, 2004 04:16 PM
How to center an image exactly without calculating, etc.? StargateFanFromWork Powerpoint 4 July 9th, 2004 09:25 PM
external image files on a report (continuation) Veetold Setting Up & Running Reports 1 May 21st, 2004 12:52 PM


All times are GMT +1. The time now is 08:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.