Announcement

Collapse
No announcement yet.

Land Area spreadsheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Land Area spreadsheet

    Here is a spreadsheet (pending link approval) for finding the area of a region bounded by a curve. The method used is Gaussian quadrature. It may seem strange to anyone who hasn't studied calculus, but it does work.

    It is for regions bounded by smooth curves.


    You measure the length all the way across, and the spreadsheet tells you where to measure the heights. You then measure those 7 heights, and the spreadsheet gives you the area.

    The accuracy is incredible. I tried this on a circle whose area is pi, and got 3.146. That's a 0.2% with only 7 measurements.

    https://docs.google.com/leaf?id=0B54...2ZTBk&hl=en_US
    Last edited by Robert Fogt; 08-16-2011, 05:26 AM. Reason: Added link for user

  • #2
    Re: Land Area spreadsheet

    Spreadsheet is no longer accessible.

    I used SketchAndCalc.com a free irregular area calculator for this sort of thing.

    Being able to calculate curves would be very handy, and I understand this will be possible soon, but not sure if that will be free?

    Comment

    Working...
    X