Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    411
    Thanks
    1
    Thanked 0 Times in 0 Posts

    calculating gradient and direction

    I need to do a series of 3-point problems. I have a series of 3 water level elevations taken on the same day over several years. I would like to know what is the water level gradient and direction of water travel toward the low point of the plane.; e.g., 0.0012 ft/ft toward 275o. For each date of measurement, example data are attached.

    Thanks.
    Attached Files Attached Files
    Last edited by jepalmer; 2016-04-01 at 14:23.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,730
    Thanks
    125
    Thanked 686 Times in 623 Posts
    Jepalmer,

    To find the angle, use this formula in E2 then copy down

    =DEGREES(ATAN(C2/B2))

    HTH,
    Maud

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,048
    Thanks
    145
    Thanked 543 Times in 518 Posts
    Hi Maud

    ..you got the answer before me. I went off at a tangent.

    zeddy

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,730
    Thanks
    125
    Thanked 686 Times in 623 Posts
    Its just a sine of your intelligence!

  5. #5
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,810
    Thanks
    151
    Thanked 168 Times in 161 Posts
    'Cos you two are too much
    Power corrupts. Absolute power is kinda neat though.

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,493
    Thanks
    33
    Thanked 63 Times in 59 Posts
    So far there was only sin2(x) + cos2(x) partial answer proposed. Next we'll have (O/H)-feld jokes.
    Last edited by kweaver; 2016-04-02 at 16:02.

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,048
    Thanks
    145
    Thanked 543 Times in 518 Posts
    ..that would be too square

  8. #8
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,730
    Thanks
    125
    Thanked 686 Times in 623 Posts
    ...only if you look at it from that angle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •