Power Kite Forum
Not logged in [Login ]
Go To Bottom

Printable Version  
Author: Subject: Who's good at math?
rtz


Avatar


Posts: 1090
Registered: 10-12-2010
Location: Edmond, OK
Member Is Offline


[*] posted on 7-16-2019 at 10:21 AM
Who's good at math?


What's the easiest way to run these projections out too see what the level will be in September and October based on this rate of decline short of doing it manually?




https://nwis.waterdata.usgs.gov/nwis/uv?site_no=07159550




Sting 1.7 - Flow 2, 3, 4, 5 - Reactor 2.2, 2.8, 3.5, 4.4, 5.5 - Yakuza 2.2, 2.7 - JOJO 9
View user's profile View All Posts By User
indigo_wolf


Avatar


Posts: 5100
Registered: 12-25-2008
Location: Washington, DC area
Member Is Offline

Mood: Weaned by leopards, raised by wolves...

[*] posted on 7-16-2019 at 12:06 PM


If you have MS Office...

TREND function and other ways to do trend analysis in Excel
https://www.ablebits.com/office-addins-blog/2019/03/27/excel-trend-function/

ATB,
Sam




"I never had any friends later on like the ones I had when I was 12 - Jesus, does anyone?" - The Body by Stephen King
View user's profile View All Posts By User
Prussik




Posts: 148
Registered: 12-5-2011
Member Is Offline


[*] posted on 7-16-2019 at 01:15 PM


L=1200.34-0.08d where L is the level and d is the number of days from July 1.
View user's profile View All Posts By User
Randy


Avatar


Posts: 1792
Registered: 5-20-2014
Member Is Offline


[*] posted on 7-16-2019 at 06:31 PM


Might be easier to look around that website for some historical data. Here is the 2017 water year. I assume this is a lake where they manage the water levels so it is going be driven by rainfall, the decisions made, more than just following a trend. Looking at last year it trended down in July only to come back up in August and September. (This is storage but it is going to be related to water level.)

https://waterdata.usgs.gov/nwis/wys_rpt?dv_ts_ids=111115&...





USGS.07159550.111115.00054.30800.20161001.20170930..0..PURL.png - 5kB




NPW Test Pilot -US99
View user's profile View All Posts By User
nate76




Posts: 320
Registered: 9-9-2015
Location: Colorado Springs, CO
Member Is Offline

Mood: Lets roast some coffee

[*] posted on 7-16-2019 at 08:19 PM


Ya, I would have to agree with Randy - water level rates are very seasonal. The best way to predict levels would be to take a look at a one-year chart, then add or subtract some to your months of interest, based on whether you're having a wetter than normal or drier-than-normal year.

We have a similar problem here at Lake McConaughy. Water levels are crazy high this year from the record snowpack in the mountains. Unfortunately, that means most of the kite launch areas are underwater at the moment. Hoping things start to recede a bit for our family vacation at the end of July...




Founder/Owner Colorado Kite Sports
Specializing in Gin, Little Cloud & HQ4 foils.
http://coloradokitesports.com
Most used Kites: LC Pelican, Gin Shaman
Skis: Something w/ Marker Baron or Duke Bindings
Boards: Litewave Wing, Naish Jet 2000, OR Mako 140
View user's profile Visit user's homepage View All Posts By User

  Go To Top

Hosted by: Mad Moose Studio