View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

I doubt it. I think he's looking for the plan view area of each region, i.e., each
colored band between defined limits.

I remember the good old days, pre-Excel. We had a fancy device called a planimeter
to measure these areas. A less elaborate procedure consisted of cutting out the
areas and weighing them, dividing by the total weight, and multiplying by the total
area.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tushar Mehta wrote:

Dunno if this will help, but see Bernard Liengme's
http://www.stfx.ca/people/bliengme/E...UnderCurve.htm and
http://www.stfx.ca/people/bliengme/E...olygonArea.htm