Spreadsheet: mike_swerzbin__27945__DallesStreamHistory
Sheet: Data

Historical Streamflow  (Average of the daily values)    Columbia River at The Dalles, Oregon
 |  | October 1, 19XX - - September 30, 19YY
 | 1900-1999 |  |  | 1900-1999 |  |  | 1936-1999
 | Water Year Ranking |  |  | Date |  |  | Date |  |  | Streamflow Risk Mitigation Proposal (Financial Settlement)
 | year | Avg kcfs |  | year | Avg kcfs |  | 1936-1937 | 128.7167123287671
 | 1996-1997 | 263.7117808219178 |  | 1900-1901 | 218.687397260274 |  | 1937-1938 | 190.1531506849315
 | 1995-1996 | 251.8713114754099 |  | 1901-1902 | 197.4227397260274 |  | 1938-1939 | 149.7241095890411
 | 1971-1972 | 244.1401639344262 |  | 1902-1903 | 210.9413698630137 |  | 1939-1940 | 148.4532786885246 |  | Location: | The Columbia River at the Dalles, OR (USGS Station#14105700)
 | 1955-1956 | 243.3901639344262 |  | 1903-1904 | 242.0792349726776 |  | 1940-1941 | 130.025205479452
 | 1903-1904 | 242.0792349726776 |  | 1904-1905 | 139.908493150685 |  | 1941-1942 | 178.5810958904109 |  | Index: | Cumulative Stream Flow (mean kcfs per day as reported by
 | 1915-1916 | 238.0877049180328 |  | 1905-1906 | 156.7145205479452 |  | 1942-1943 | 207.3035616438356 |  |  | USGS)
 | 1973-1974 | 237.74 |  | 1906-1907 | 229.1284931506849 |  | 1943-1944 | 119.6046448087432
 | 1947-1948 | 235.468306010929 |  | 1907-1908 | 196.2188524590164 |  | 1944-1945 | 150.812602739726 |  | Term Start: |  | 2001-10-01 00:00:00
 | 1927-1928 | 231.212568306011 |  | 1908-1909 | 189.6553424657534 |  | 1945-1946 | 196.0983561643835 |  | Term End: |  | 2002-09-30 00:00:00
 | 1920-1921 | 230.0865753424658 |  | 1909-1910 | 212.7778082191782 |  | 1946-1947 | 193.6723287671233 |  | Structure: |  | Swap
 | 1906-1907 | 229.1284931506849 |  | 1910-1911 | 187.6813698630137 |  | 1947-1948 | 235.468306010929 |  | [NAME]: |  | 30000
 | 1981-1982 | 228.9043835616438 |  | 1911-1912 | 182.8319672131148 |  | 1948-1949 | 180.1416438356165 |  | Maximum: |  | 3000000
 | 1950-1951 | 226.4312328767123 |  | 1912-1913 | 213.0093150684931 |  | 1949-1950 | 217.1408219178082
 | 1970-1971 | 226.3616438356165 |  | 1913-1914 | 186.8654794520548 |  | 1950-1951 | 226.4312328767123
 | 1964-1965 | 224.4515068493151 |  | 1914-1915 | 146.7846575342465 |  | 1951-1952 | 198.1685792349728
 | 1975-1976 | 220.272131147541 |  | 1915-1916 | 238.0877049180328 |  | 1952-1953 | 179.3358904109589 |  | Site Home page
 | 1900-1901 | 218.687397260274 |  | 1916-1917 | 208.5035616438356 |  | 1953-1954 | 209.0539726027397 |  | http://water.usgs.gov/nwis/nwisman/?site_no=14105700&agency_cd=USGS
 | 1949-1950 | 217.1408219178082 |  | 1917-1918 | 204.6591780821918 |  | 1954-1955 | 178.9728767123288
 | 1982-1983 | 216.6304109589041 |  | 1918-1919 | 172.0027397260274 |  | 1955-1956 | 243.3901639344262
 | 1998-1999 | 215.3693150684932 |  | 1919-1920 | 156.7948087431694 |  | 1956-1957 | 194.1191780821918
 | 1912-1913 | 213.0093150684931 |  | 1920-1921 | 230.0865753424658 |  | 1957-1958 | 180.7452054794521
 | 1909-1910 | 212.7778082191782 |  | 1921-1922 | 183.1953424657534 |  | 1958-1959 | 211.5879452054795
 | 1958-1959 | 211.5879452054795 |  | 1922-1923 | 179.4380821917808 |  | 1959-1960 | 195.3467213114754
 | 1983-1984 | 211.5319672131147 |  | 1923-1924 | 136.7950819672131 |  | 1960-1961 | 189.0312328767123
 | 1933-1934 | 211.48 |  | 1924-1925 | 201.3830136986302 |  | 1961-1962 | 169.3224657534246
 | 1902-1903 | 210.9413698630137 |  | 1925-1926 | 118.1065753424658 |  | 1962-1963 | 174.1476712328767
 | 1953-1954 | 209.0539726027397 |  | 1926-1927 | 206.0556164383562 |  | 1963-1964 | 184.1928961748633
 | 1916-1917 | 208.5035616438356 |  | 1927-1928 | 231.212568306011 |  | 1964-1965 | 224.4515068493151
 | 1942-1943 | 207.3035616438356 |  | 1928-1929 | 132.7704109589041 |  | 1965-1966 | 162.0224657534247
 | 1926-1927 | 206.0556164383562 |  | 1929-1930 | 131.3928767123288 |  | 1966-1967 | 191.2912328767123
 | 1968-1969 | 205.8271232876713 |  | 1930-1931 | 121.9219178082191 |  | 1967-1968 | 165.7016393442623
 | 1917-1918 | 204.6591780821918 |  | 1931-1932 | 185.5177595628416 |  | 1968-1969 | 205.8271232876713
 | 1990-1991 | 203.445205479452 |  | 1932-1933 | 197.9950684931507 |  | 1969-1970 | 166.4783561643836
 | 1924-1925 | 201.3830136986302 |  | 1933-1934 | 211.48 |  | 1970-1971 | 226.3616438356165
 | 1951-1952 | 198.1685792349728 |  | 1934-1935 | 170.22 |  | 1971-1972 | 244.1401639344262
 | 1932-1933 | 197.9950684931507 |  | 1935-1936 | 158.9193989071038 |  | 1972-1973 | 136.1347945205479
 | 1901-1902 | 197.4227397260274 |  | 1936-1937 | 128.7167123287671 |  | 1973-1974 | 237.74
 | 1907-1908 | 196.2188524590164 |  | 1937-1938 | 190.1531506849315 |  | 1974-1975 | 187.0139726027398
 | 1945-1946 | 196.0983561643835 |  | 1938-1939 | 149.7241095890411 |  | 1975-1976 | 220.272131147541
 | 1959-1960 | 195.3467213114754 |  | 1939-1940 | 148.4532786885246 |  | 1976-1977 | 120.4402739726027
 | 1997-1998 | 194.4693150684932 |  | 1940-1941 | 130.025205479452 |  | 1977-1978 | 170.5304109589041
 | 1956-1957 | 194.1191780821918 |  | 1941-1942 | 178.5810958904109 |  | 1978-1979 | 152.4808219178082
 | 1946-1947 | 193.6723287671233 |  | 1942-1943 | 207.3035616438356 |  | 1979-1980 | 159.0363387978142
 | 1966-1967 | 191.2912328767123 |  | 1943-1944 | 119.6046448087432 |  | 1980-1981 | 187.4115068493151
 | 1937-1938 | 190.1531506849315 |  | 1944-1945 | 150.812602739726 |  | 1981-1982 | 228.9043835616438
 | 1985-1986 | 190.0564383561644 |  | 1945-1946 | 196.0983561643835 |  | 1982-1983 | 216.6304109589041
 | 1908-1909 | 189.6553424657534 |  | 1946-1947 | 193.6723287671233 |  | 1983-1984 | 211.5319672131147
 | 1960-1961 | 189.0312328767123 |  | 1947-1948 | 235.468306010929 |  | 1984-1985 | 165.0619178082192
 | 1910-1911 | 187.6813698630137 |  | 1948-1949 | 180.1416438356165 |  | 1985-1986 | 190.0564383561644
 | 1980-1981 | 187.4115068493151 |  | 1949-1950 | 217.1408219178082 |  | 1986-1987 | 145.0893150684932
 | 1974-1975 | 187.0139726027398 |  | 1950-1951 | 226.4312328767123 |  | 1987-1988 | 135.8073770491803
 | 1913-1914 | 186.8654794520548 |  | 1951-1952 | 198.1685792349728 |  | 1988-1989 | 155.9273972602739
 | 1931-1932 | 185.5177595628416 |  | 1952-1953 | 179.3358904109589 |  | 1989-1990 | 177.0043835616438
 | 1963-1964 | 184.1928961748633 |  | 1953-1954 | 209.0539726027397 |  | 1990-1991 | 203.445205479452
 | 1921-1922 | 183.1953424657534 |  | 1954-1955 | 178.9728767123288 |  | 1991-1992 | 143.4300546448087
 | 1911-1912 | 182.8319672131148 |  | 1955-1956 | 243.3901639344262 |  | 1992-1993 | 155.2479452054795
 | 1957-1958 | 180.7452054794521 |  | 1956-1957 | 194.1191780821918 |  | 1993-1994 | 132.713698630137
 | 1948-1949 | 180.1416438356165 |  | 1957-1958 | 180.7452054794521 |  | 1994-1995 | 167.2101369863013
 | 1922-1923 | 179.4380821917808 |  | 1958-1959 | 211.5879452054795 |  | 1995-1996 | 251.8713114754099
 | 1952-1953 | 179.3358904109589 |  | 1959-1960 | 195.3467213114754 |  | 1996-1997 | 263.7117808219178
 | 1954-1955 | 178.9728767123288 |  | 1960-1961 | 189.0312328767123 |  | 1997-1998 | 194.4693150684932
 | 1941-1942 | 178.5810958904109 |  | 1961-1962 | 169.3224657534246 |  | 1998-1999 | 215.3693150684932
 | 1989-1990 | 177.0043835616438 |  | 1962-1963 | 174.1476712328767
 | 1962-1963 | 174.1476712328767 |  | 1963-1964 | 184.1928961748633 |  | [NAME]
 | 1918-1919 | 172.0027397260274 |  | 1964-1965 | 224.4515068493151 |  | [NAME]
 | 1977-1978 | 170.5304109589041 |  | 1965-1966 | 162.0224657534247 |  | Min
 | 1934-1935 | 170.22 |  | 1966-1967 | 191.2912328767123 |  | [NAME]
 | 1961-1962 | 169.3224657534246 |  | 1967-1968 | 165.7016393442623 |  | Median
 | 1994-1995 | 167.2101369863013 |  | 1968-1969 | 205.8271232876713
 | 1969-1970 | 166.4783561643836 |  | 1969-1970 | 166.4783561643836
 | 1967-1968 | 165.7016393442623 |  | 1970-1971 | 226.3616438356165 |  | Since1965
 | 1984-1985 | 165.0619178082192 |  | 1971-1972 | 244.1401639344262
 | 1965-1966 | 162.0224657534247 |  | 1972-1973 | 136.1347945205479 |  | [NAME]
 | 1979-1980 | 159.0363387978142 |  | 1973-1974 | 237.74 |  | [NAME]
 | 1935-1936 | 158.9193989071038 |  | 1974-1975 | 187.0139726027398 |  | Min
 | 1919-1920 | 156.7948087431694 |  | 1975-1976 | 220.272131147541 |  | [NAME]
 | 1905-1906 | 156.7145205479452 |  | 1976-1977 | 120.4402739726027 |  | Median
 | 1988-1989 | 155.9273972602739 |  | 1977-1978 | 170.5304109589041
 | 1992-1993 | 155.2479452054795 |  | 1978-1979 | 152.4808219178082
 | 1978-1979 | 152.4808219178082 |  | 1979-1980 | 159.0363387978142
 | 1944-1945 | 150.812602739726 |  | 1980-1981 | 187.4115068493151
 | 1938-1939 | 149.7241095890411 |  | 1981-1982 | 228.9043835616438
 | 1939-1940 | 148.4532786885246 |  | 1982-1983 | 216.6304109589041
 | 1914-1915 | 146.7846575342465 |  | 1983-1984 | 211.5319672131147
 | 1986-1987 | 145.0893150684932 |  | 1984-1985 | 165.0619178082192
 | 1991-1992 | 143.4300546448087 |  | 1985-1986 | 190.0564383561644
 | 1904-1905 | 139.908493150685 |  | 1986-1987 | 145.0893150684932
 | 1923-1924 | 136.7950819672131 |  | 1987-1988 | 135.8073770491803
 | 1972-1973 | 136.1347945205479 |  | 1988-1989 | 155.9273972602739
 | 1987-1988 | 135.8073770491803 |  | 1989-1990 | 177.0043835616438
 | 1928-1929 | 132.7704109589041 |  | 1990-1991 | 203.445205479452
 | 1993-1994 | 132.713698630137 |  | 1991-1992 | 143.4300546448087
 | 1929-1930 | 131.3928767123288 |  | 1992-1993 | 155.2479452054795
 | 1940-1941 | 130.025205479452 |  | 1993-1994 | 132.713698630137
 | 1936-1937 | 128.7167123287671 |  | 1994-1995 | 167.2101369863013
 | 1930-1931 | 121.9219178082191 |  | 1995-1996 | 251.8713114754099
 | 1976-1977 | 120.4402739726027 |  | 1996-1997 | 263.7117808219178
 | 1943-1944 | 119.6046448087432 |  | 1997-1998 | 194.4693150684932
 | 1925-1926 | 118.1065753424658 |  | 1998-1999 | 215.3693150684932
 | [NAME] | 185.4360823031597 |  | [NAME] | 185.4360823031597
 | [NAME] |  |  | [NAME]
 | Min |  |  | Min
 | [NAME] |  |  | [NAME]