{"text_format":"2","workbook":"xls","n_sheets":8,"sheets":["Q vs. R, Mankato","Q vs. Stage, Mankato","Mankato","Q vs. R, Jordan","Q vs. Stage, Jordan","Jordan","topo profile","topo data"],"not_rendered":{"charts":5,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Q vs. R, Mankato","index":0,"reason":"not_a_worksheet"},{"sheet":"Q vs. Stage, Mankato","index":1,"reason":"not_a_worksheet"},{"sheet":"Q vs. R, Jordan","index":3,"reason":"not_a_worksheet"},{"sheet":"Q vs. Stage, Jordan","index":4,"reason":"not_a_worksheet"},{"sheet":"topo profile","index":6,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904","formulas":"cached_only"}

{"sheet":"Mankato","index":2,"n_rows":109,"n_cols":9,"rows_kept":109,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MAXIMUM ANNUAL FLOOD DISCHARGES  RECORDED AT MANKATO, MINNESOTA Station # 05325000"]
["Number of years on record (N) = ",null,null,104]
["Year","Date","Flow (cfs)","Stage (ft asl)","Gage Height (ft)","Rank","Recurrence Interval"]
[2006,"2006-04-10",33900,766.79,18.87,16,6.5625,"y = 19001Ln(x) + 3107.5"]
[2005,"2005-05-15",23900,763.4,15.48,33,3.1818181818181817,"Q100 =",90610.33870395973]
[2004,"2004-06-15",23700,763.39,15.47,35,3,"Stage100 =","776 ft"]
[2003,"2003-05-15",15000,759.75,11.83,61,1.721311475409836]
[2002,"2002-06-24",13000,758.66,10.74,67,1.5671641791044777]
[2001,"2001-04-16",73700,774.88,26.96,5,21]
[2000,"2000-06-04",16900,760.97,13.05,54,1.9444444444444444]
[1999,"1999-04-12",24200,764.08,16.16,31,3.3870967741935485]
[1998,"1998-04-04",28400,765.29,17.37,23,4.565217391304348]
[1997,"1997-04-10",79800,775.53,27.61,2,52.5]
[1996,"1996-06-20",28000,766.66,18.74,24,4.375]
[1995,"1995-04-24",27600,766.8,18.88,25,4.2]
[1994,"1994-04-28",21800,763.7,15.78,39,2.6923076923076925]
[1993,"1993-06-21",75600,778.03,30.11,4,26.25]
[1992,"1992-03-11",23900,765.88,17.96,34,3.088235294117647]
[1991,"1991-06-09",33100,769.29,21.37,18,5.833333333333333]
[1990,"1990-07-30",17100,762.97,15.05,53,1.9811320754716981]
[1989,"1989-03-27",15800,762.32,14.4,55,1.9090909090909092]
[1988,"1988-04-06",5520,755.99,8.07,92,1.141304347826087]
[1987,"1987-03-29",8170,758.45,10.53,87,1.206896551724138]
[1986,"1986-05-02",36300,770.57,22.65,14,7.5]
[1985,"1985-03-17",29700,768.12,20.2,22,4.7727272727272725]
[1984,"1984-06-26",41000,772.47,24.55,11,9.545454545454545]
[1983,"1983-04-18",33300,770.05,22.13,17,6.176470588235294]
[1982,"1982-03-24",15500,762.94,15.02,59,1.7796610169491525]
[1981,"1981-06-27",14200,762.21,14.29,63,1.6666666666666667]
[1980,"1980-06-08",15700,763.04,15.12,57,1.8421052631578947]
[1979,"1979-04-03",30000,768.78,20.86,21,5]
[1978,"1978-04-08",13300,761.67,13.75,65,1.6153846153846154]
[1977,"1977-06-18",7850,757.13,9.21,88,1.1931818181818181]
[1976,"1976-04-02",5130,755.25,7.33,94,1.1170212765957446]
[1975,"1975-05-01",24100,765.12,17.2,32,3.28125]
[1974,"1974-06-11",12500,760.8,12.88,68,1.5441176470588236]
[1973,"1973-03-17",19700,764.44,16.52,46,2.282608695652174]
[1972,"1972-06-09",20200,764.99,17.07,44,2.3863636363636362]
[1971,"1971-03-22",21400,765.04,17.12,40,2.625]
[1970,"1970-04-25",8680,757.56,9.64,82,1.2804878048780488]
[1969,"1969-04-12",76700,774.99,27.07,3,35]
[1968,"1968-07-27",15800,762.57,14.65,56,1.875]
[1967,"1967-06-18",18700,763.96,16.04,48,2.1875]
[1966,"1966-04-02",15400,762.36,14.44,60,1.75]
[1965,"1965-04-10",94100,777.01,29.09,1,105]
[1964,"1964-05-15",12400,760.22,12.3,69,1.5217391304347827]
[1963,"1963-07-24",15600,762.5,14.58,58,1.8103448275862069]
[1962,"1962-04-02",39800,769.54,21.62,12,8.75]
[1961,"1961-03-29",17600,763.53,15.61,52,2.019230769230769]
[1960,"1960-05-23",34300,768.33,20.41,15,7]
[1959,"1959-06-03",4850,755.14,7.22,98,1.0714285714285714]
[1958,"1958-04-13",7570,757.44,9.52,89,1.1797752808988764]
[1957,"1957-06-24",41700,770.5,22.58,10,10.5]
[1956,"1956-06-26",11600,760.61,12.69,72,1.4583333333333333]
[1955,"1955-03-12",8200,758.16,10.24,86,1.2209302325581395]
[1954,"1954-06-23",10000,759.54,11.62,77,1.3636363636363635]
[1953,"1953-06-10",25100,766.76,18.84,28,3.75]
[1952,"1952-04-14",53500,772.54,24.62,8,13.125]
[1951,"1951-04-09",66600,774.12,26.2,6,17.5]
[1950,"1950-03-31",12200,761.82,13.9,70,1.5]
[1949,"1949-04-03",26600,767.8,19.88,27,3.888888888888889]
[1948,"1948-03-24",17900,764.84,16.92,51,2.0588235294117645]
[1947,"1947-07-10",20400,765.89,17.97,43,2.441860465116279]
[1946,"1946-03-18",13300,763.04,15.12,66,1.5909090909090908]
[1945,"1945-03-16",18000,765.34,17.42,50,2.1]
[1944,"1944-05-23",25100,768.33,20.41,29,3.6206896551724137]
[1943,"1943-06-18",19800,767.21,19.29,45,2.3333333333333335]
[1942,"1942-06-07",7280,759.32,11.4,91,1.1538461538461537]
[1941,"1941-03-31",11400,762.71,14.79,73,1.4383561643835616]
[1940,"1940-04-11",3930,755.51,7.59,99,1.0606060606060606]
[1939,"1939-03-24",9350,761.31,13.39,79,1.3291139240506329]
[1938,"1938-09-19",11200,763.6,15.68,75,1.4]
[1937,"1937-06-17",8400,760.83,12.91,85,1.2352941176470589]
[1936,"1936-03-23",25100,767.95,20.03,30,3.5]
[1935,"1935-03-16",5100,756.77,8.85,95,1.105263157894737]
[1934,"1934-04-07",2170,753.43,5.51,101,1.0396039603960396]
[1933,"1933-04-03",13400,762.94,15.02,64,1.640625]
[1932,"1932-03-30",7400,760.8,12.88,90,1.1666666666666667]
[1931,"1931-06-22",1350,752.42,4.5,103,1.0194174757281553]
[1930,"1930-02-25",9260,760.12,12.2,80,1.3125]
[1929,"1929-03-18",23200,766.92,19,36,2.9166666666666665]
[1928,"1928-03-20",11400,761.77,13.85,74,1.4189189189189189]
[1927,"1927-03-14",12100,762.42,14.5,71,1.4788732394366197]
[1926,"1926-03-23",4990,756.79,8.87,96,1.09375]
[1925,"1925-06-17",8640,761.02,13.1,83,1.2650602409638554]
[1924,"1924-07-02",3540,755.72,7.8,100,1.05]
[1923,"1923-05-04",1630,753.41,5.49,102,1.0294117647058822]
[1922,"1922-03-16",9040,761.42,13.5,81,1.2962962962962963]
[1921,"1921-05-30",4910,null,null,97,1.0824742268041236]
[1920,"1920-07-18",19600,null,null,47,2.234042553191489]
[1919,"1919-06-21",38800,null,null,13,8.076923076923077]
[1918,"1918-08-23",15000,null,null,62,1.6935483870967742]
[1917,"1917-04-05",26900,null,null,26,4.038461538461538]
[1916,"1916-03-28",30500,null,null,20,5.25]
[1915,"1915-03-28",23100,null,null,37,2.8378378378378377]
[1914,"1914-06-17",11000,null,null,76,1.381578947368421]
[1913,"1913-04-15",5460,null,null,93,1.1290322580645162]
[1912,"1912-04-02",8530,null,null,84,1.25]
[1911,"1911-03-13",905,null,null,104,1.0096153846153846]
[1910,"1910-03-12",20700,null,null,41,2.5609756097560976]
[1909,"1909-03-29",31700,null,null,19,5.526315789473684]
[1908,"1908-06-26",54500,null,null,7,15]
[1907,"1907-06-21",22100,null,null,38,2.763157894736842]
[1906,"1906-06-10",9940,null,null,78,1.3461538461538463]
[1905,"1905-07-09",18600,null,null,49,2.142857142857143]
[1904,"10/29/1903",20500,null,null,42,2.5]
[1903,"5/29/1903",43500,null,null,9,11.666666666666666]
[]
["*Data from http://nwis.waterdata.usgs.gov/nwis/peak?site_no=05325000&agency_cd=USGS&format=rdb"]

{"sheet":"Jordan","index":5,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MAXIMUM ANNUAL FLOOD DISCHARGES  RECORDED AT JORDAN, MINNESOTA Station # 05330000"]
["Number of years on record (N) = ",null,null,72]
["Year","Date","Flow (cfs)","Stage (ft asl)","Gage Height (ft)","Rank","Recurrence Interval"]
[2006,"2006-04-12",37400,716.4,26.4,11,6.636363636363637,"y = 23860Ln(x) + 2672.6"]
[2005,"2005-05-19",24500,713.65,23.65,27,2.7037037037037037,"Q100 =",112551.96063767587]
[2004,"2004-06-14",28500,715.17,25.17,22,3.3181818181818183,"Stage100 =",725.5]
[2003,"2003-05-17",15900,709.1,19.1,44,1.6590909090909092]
[2002,"2002-06-26",18300,710.62,20.62,37,1.972972972972973]
[2001,"2001-04-18",87100,723.11,33.11,3,24.333333333333332]
[2000,"2000-06-07",16900,709.54,19.54,41,1.7804878048780488]
[1999,"1999-04-17",25200,714.28,24.28,25,2.92]
[1998,"1998-04-05",32300,715.5,25.5,18,4.055555555555555]
[1997,"1997-04-12",82300,722.24,32.24,5,14.6]
[1996,"1996-06-23",31500,714.99,24.99,20,3.65]
[1995,"1995-04-26",29700,714.99,24.99,21,3.4761904761904763]
[1994,"1994-05-02",22400,713.05,23.05,32,2.28125]
[1993,"1993-06-24",92200,723.52,33.52,2,36.5]
[1992,"1992-03-10",26200,714.11,24.11,23,3.1739130434782608]
[1991,"1991-06-11",33300,715.63,25.63,15,4.866666666666666]
[1990,"1990-08-02",17000,710.23,20.23,40,1.825]
[1989,"1989-03-27",14800,708.49,18.49,47,1.553191489361702]
[1988,"1988-04-07",5560,700.85,10.85,68,1.0735294117647058]
[1987,"1987-04-01",9270,704.28,14.28,60,1.2166666666666666]
[1986,"1986-05-04",36700,716.3,26.3,12,6.083333333333333]
[1985,"1985-03-20",32300,715.05,25.05,19,3.8421052631578947]
[1984,"1984-06-28",45300,717.54,27.54,8,9.125]
[1983,"1983-04-19",33700,716.14,26.14,14,5.214285714285714]
[1982,"1982-03-27",17300,711.49,21.49,39,1.8717948717948718]
[1981,"1981-06-30",12400,707.17,17.17,56,1.3035714285714286]
[1980,"1980-06-12",14200,709.4,19.4,49,1.489795918367347]
[1979,"1979-04-05",32600,715.92,25.92,16,4.5625]
[1978,"1978-04-13",13800,709.07,19.07,52,1.4038461538461537]
[1977,"1977-06-20",6610,702.29,12.29,67,1.0895522388059702]
[1976,"1976-04-03",5490,701.19,11.19,69,1.0579710144927537]
[1975,"1975-05-03",22900,713.77,23.77,31,2.3548387096774195]
[1974,"1974-06-14",13900,709.13,19.13,50,1.46]
[1973,"1973-03-18",21900,713.09,23.09,34,2.1470588235294117]
[1972,"1972-06-14",16800,711.48,21.48,42,1.7380952380952381]
[1971,"1971-03-24",24100,null,null,28,2.607142857142857]
[1970,"1970-04-25",9510,705.09,15.09,59,1.2372881355932204]
[1969,"1969-04-14",84600,722.85,32.85,4,18.25]
[1968,"1968-08-11",15700,null,null,45,1.6222222222222222]
[1967,"1967-04-08",19400,712.75,22.75,36,2.0277777777777777]
[1966,"1966-04-06",16200,null,null,43,1.697674418604651]
[1965,"1965-04-11",117000,null,null,1,73]
[1964,"1964-05-18",12900,706.15,16.15,54,1.3518518518518519]
[1963,"1963-07-28",14400,706.66,16.66,48,1.5208333333333333]
[1962,"1962-04-04",39700,null,null,10,7.3]
[1961,"1961-04-01",15700,708.57,18.57,46,1.5869565217391304]
[1960,"1960-05-25",36400,714.87,24.87,13,5.615384615384615]
[1959,"1959-06-05",3880,698.37,8.37,71,1.028169014084507]
[1958,"1958-04-15",7640,702.3,12.3,66,1.106060606060606]
[1957,"1957-06-26",40800,715.82,25.82,9,8.11111111111111]
[1956,"1956-06-20",12800,706.72,16.72,55,1.3272727272727274]
[1955,"1955-03-17",7650,704.02,14.02,65,1.123076923076923]
[1954,"1954-06-27",10300,703.77,13.77,58,1.2586206896551724]
[1953,"1953-06-14",23000,711.47,21.47,30,2.433333333333333]
[1952,"1952-04-16",60600,718.31,28.31,7,10.428571428571429]
[1951,"1951-04-11",64100,718,28,6,12.166666666666666]
[1950,"1950-04-01",13300,708.1,18.1,53,1.3773584905660377]
[1949,"1949-04-05",32600,713.59,23.59,17,4.294117647058823]
[1948,"1948-03-24",22000,712.41,22.41,33,2.212121212121212]
[1947,"1947-05-03",20400,711.31,21.31,35,2.085714285714286]
[1946,"1946-03-30",13900,708.22,18.22,51,1.4313725490196079]
[1945,"1945-06-18",18200,710.98,20.98,38,1.9210526315789473]
[1944,"1944-05-25",25100,712.82,22.82,26,2.8076923076923075]
[1943,"1943-06-20",25900,712.64,22.64,24,3.0416666666666665]
[1942,"1942-09-19",8400,704.36,14.36,63,1.1587301587301588]
[1941,"1941-04-05",12300,707.56,17.56,57,1.280701754385965]
[1940,"1940-04-14",3560,697.74,7.74,72,1.0138888888888888]
[1939,"1939-03-25",8500,704.5,14.5,62,1.1774193548387097]
[1938,"1938-09-23",8760,703.14,13.14,61,1.1967213114754098]
[1937,"1937-06-22",8310,702.73,12.73,64,1.140625]
[1936,"1936-03-25",23200,712.43,22.43,29,2.5172413793103448]
[1935,"1935-03-19",4010,697.62,7.62,70,1.042857142857143]
[]
["*data from http://nwis.waterdata.usgs.gov/mn/nwis/peak?site_no=05330000&agency_cd=USGS&format=rdb"]

{"sheet":"topo data","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Distance (miles)","Elevation (ft asl)"]
["Mankato",0,759]
[null,3.83,749]
[null,9.5,746]
[null,13,742]
["St. Peter",18.1,740]
[null,25.26,738]
[null,30.45,730]
[null,38.2,713]
[null,46,710]
[null,54.332,707]
[null,68.6,703]
[null,72,700]