{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Menu","Data","Hydro1","Hydro2","Exceed1","FlowDur","SampleConc","Summary","MonthSummary","ConcFlow","TwoVariable","TwoRiver","LoadingRate","LoadCumul","Report","MonthReport"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":14,"comments":12,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"1900"}

{"sheet":"Menu","index":0,"n_rows":114,"n_cols":42,"rows_kept":114,"cut":false,"hidden":false,"merged":[[2,3,2,7],[4,3,4,7],[3,3,3,7],[5,3,5,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart1"]
[null,null,null,"Ohio Tributary Loading Data:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=41730"]
[null,null,null,"Access, Analysis & Interpretation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<=41822"]
[null,null,null,"Data Analysis Template",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanchard","7/9/2007 - 12/31/2015",346]
[null,null,null,"Version 6.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beaver Creek","10/02/2013 - 12/31/2015",113]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chickasaw","9/29/2008 - 12/31/2015",16.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coldwater Creek","11/14/2011 - 12/31/2015",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuyahoga","11/4/1981 - 12/31/2015",708]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand","2/16/1988 - 8/10/2006",686]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Great Miami","4/22/1996 - 12/31/2015",2685]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Honey Creek","1/28/1976 - 12/31/2015",149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lost Creek","8/6/2007 - 12/31/2015",4.2300000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maumee","1/10/1975 - 12/31/2015",6330]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Muskingum","4/11/1994 - 12/31/2015",7420]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Woman Creek - Berlin","11/9/1987 - 12/31/2015",22.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Woman Creek - Lake","11/6/1987 - 12/31/2015",26.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage","8/30/2010 - 12/31/2015",494]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin","3/6/1982 - 12/31/2015",1042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek","10/11/1982 - 12/31/2015",34.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky","10/2/1974 - 12/31/2015",1253]
[null,"Last Update:",null,null,"Project supported by the ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto","4/23/1996 - 12/31/2015",3854]
[null,"2016-04-04",null,null,"Ohio Lake Erie Commission - ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin","7/9/2007 - 12/31/2015",410]
[null,null,null,null,"Lake Erie Protection Fund and ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion","10/2/2000 - 7/21/2008",262]
[null,null,null,null,"the National Machinery Foundation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W38","v":true},{"$f":"W39","v":true},{"$f":"W40","v":true},{"$f":"W41","v":true},{"$f":"W42","v":true},{"$f":"W43","v":true},{"$f":"W44","v":true},{"$f":"W45","v":true},{"$f":"W46","v":true},{"$f":"W47","v":true},{"$f":"W48","v":true},{"$f":"W49","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,"Jan","Feb","Mar","April","May","June","July","Aug","Sept","Oct.","Nov","Dec."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"Datetime (date and time of sample collection)","Datetime (date and time of sample collection)","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","NO23, mg/L as N","Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,1,null,null,{"$f":"AA3","v":">=41730"},{"$f":"AA4","v":"<=41822"},{"$f":"IF(AC35,\"<>13\",\"<>1\")","v":"<>13"},{"$f":"IF(AD35,\"<>13\",\"<>2\")","v":"<>13"},{"$f":"IF(AE35,\"<>13\",\"<>3\")","v":"<>13"},{"$f":"IF(AF35,\"<>13\",\"<>4\")","v":"<>13"},{"$f":"IF(AG35,\"<>13\",\"<>5\")","v":"<>13"},{"$f":"IF(AH35,\"<>13\",\"<>6\")","v":"<>13"},{"$f":"IF(AI35,\"<>13\",\"<>7\")","v":"<>13"},{"$f":"IF(AJ35,\"<>13\",\"<>8\")","v":"<>13"},{"$f":"IF(AK35,\"<>13\",\"<>9\")","v":"<>13"},{"$f":"IF(AL35,\"<>13\",\"<>10\")","v":"<>13"},{"$f":"IF(AM35,\"<>13\",\"<>11\")","v":"<>13"},{"$f":"IF(AN35,\"<>13\",\"<>12\")","v":"<>13"},">-1",">-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W103","v":true},{"$f":"W104","v":true},{"$f":"W105","v":true},{"$f":"W106","v":true},{"$f":"W107","v":true},{"$f":"W108","v":true},{"$f":"W109","v":true},{"$f":"W110","v":true},{"$f":"W111","v":true},{"$f":"W112","v":true},{"$f":"W113","v":true},{"$f":"W114","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,"Jan","Feb","Mar","April","May","June","July","Aug","Sept","Oct.","Nov","Dec."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"Datetime (date and time of sample collection)","Datetime (date and time of sample collection)","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,1,null,null,{"$f":"TwoRiver!R2","v":">=27668"},{"$f":"TwoRiver!R3","v":"<=40452"},{"$f":"IF(AC100,\"<>13\",\"<>1\")","v":"<>13"},{"$f":"IF(AD100,\"<>13\",\"<>2\")","v":"<>13"},{"$f":"IF(AE100,\"<>13\",\"<>3\")","v":"<>13"},{"$f":"IF(AF100,\"<>13\",\"<>4\")","v":"<>13"},{"$f":"IF(AG100,\"<>13\",\"<>5\")","v":"<>13"},{"$f":"IF(AH100,\"<>13\",\"<>6\")","v":"<>13"},{"$f":"IF(AI100,\"<>13\",\"<>7\")","v":"<>13"},{"$f":"IF(AJ100,\"<>13\",\"<>8\")","v":"<>13"},{"$f":"IF(AK100,\"<>13\",\"<>9\")","v":"<>13"},{"$f":"IF(AL100,\"<>13\",\"<>10\")","v":"<>13"},{"$f":"IF(AM100,\"<>13\",\"<>11\")","v":"<>13"},{"$f":"IF(AN100,\"<>13\",\"<>12\")","v":"<>13"},">-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,12]

{"sheet":"Data","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hydro1","index":2,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":false,"merged":[[10,6,10,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5]]}
["Hydrograph / Chemographs Plots",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart1"]
["One Variable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=41730"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"H:H"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=41822"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A1:B\",TEXT(T14,\"#\"))","v":"A1:B1"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     4/1/2014 - 7/1/2014"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ylabel",null,{"$f":"CONCATENATE(AA8,\"  \",AA9)","v":"NO23  (mg/l)"}]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,true]
[null,null,null,null,"2014-04-01",null,"2014-07-01",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},null,{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"NO23"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"4/1/2014"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"7/1/2014"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,5,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D"]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},null,null,2,"SS","(mg/l)","E:E"]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},null,3,"TP","(mg/l)","F:F"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,null,4,"SRP","(mg/l)","G:G"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,null,5,"NO23","(mg/l)","H:H"]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,null,8,"Sulfate","(mg/l)","K:K"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,null,9,"Silica","(mg/l)","L:L"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"NO23, mg/L as N"},{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"NO23, mg/L as N"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"Hydro2","index":3,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[10,6,10,8],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5]]}
["Hydrograph / Chemographs Plots",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart12"]
["Two Variables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=40801"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,$V$12:$Y$22,4)","v":"H:H"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=40885"},"DateEnd",null,"Parameter2",null,{"$f":"VLOOKUP(M11,$V$12:$Y$22,4)","v":"M:M"}]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A1:C\",TEXT(T14,\"#\"))","v":"A1:C1"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     9/15/2011 - 12/7/2011"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ylabel",null,{"$f":"CONCATENATE(AA8,\"  \",AA9)","v":"NO23  (mg/l)"}]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,false,null,null,null,null,"Ylabel2",null,{"$f":"CONCATENATE(Z8,\"  \",Z9)","v":"Conductivity  (μmho)"}]
[null,null,null,null,"2011-09-15",null,"2011-12-07",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},null,{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,{"$f":"VLOOKUP(M11,V12:X22,2)","v":"Conductivity"},{"$f":"VLOOKUP(L11,V12:X22,2)","v":"NO23"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"9/15/2011"},null,null,{"$f":"VLOOKUP(M11,V12:X22,3)","v":"(μmho)"},{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"12/7/2011"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,5,10,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow","Flow","Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D"]
[null,null,null,null,null,null,null,null,null,null,null,"SS","SS","Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},null,{"$f":"TEXT(T14,\"#\")","v":"1"},2,"SS","(mg/l)","E:E"]
[null,null,null,null,null,null,null,null,null,null,null,"TP","TP","Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},{"$f":"CONCATENATE(\"=Data!R2C1:R\",U$13,\"C1\")","v":"=Data!R2C1:R1C1"},3,"TP","(mg/l)","F:F"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP","SRP","Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C2:R\",U$13,\"C2\")","v":"=Data!R2C2:R1C2"},4,"SRP","(mg/l)","G:G"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23","NO23","Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,{"$f":"U14","v":"=Data!R2C1:R1C1"},5,"NO23","(mg/l)","H:H"]
[null,null,null,null,null,null,null,null,null,null,null,"TKN","TKN","Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,{"$f":"CONCATENATE(\"=Data!R2C3:R\",U$13,\"C3\")","v":"=Data!R2C3:R1C3"},6,"TKN","(mg/l)","I:I"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride","Chloride","Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate","Sulfate","Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,null,8,"Sulfate","(mg/l)","K:K"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica","Silica","Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,null,9,"Silica","(mg/l)","L:L"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity","Conductivity","Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M"]
[null,null,null,null,null,null,null,null,null,null,null,"Future","Future","Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"NO23, mg/L as N"},{"$f":"VLOOKUP(M11,Z25:AA35,2)","v":"Conductivity, μmho"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",{"$f":"COUNT(INDIRECT(T61))","v":0},{"$f":"CONCATENATE(P61,\"A:A\")","v":"[BeaverCreekData.xlsx]Data!A:A"},{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"Exceed1","index":4,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[10,6,10,8],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5]]}
["Concentration Exceedency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart1"]
["One Variable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=37165"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"G:G"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=40452"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A1:C\",TEXT(T14,\"#\"))","v":"A1:C1"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"H4:H\",TEXT(T14,\"#\"))","v":"H4:H1"},"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     10/1/2001 - 9/30/2010"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"I3:I\",TEXT(T14,\"#\"))","v":"I3:I1"},"Ylabel",null,{"$f":"CONCATENATE(AA8,\"  \",AA9)","v":"SRP  (mg/l)"}]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,false,null,null,null,{"$f":"CONCATENATE(\"=RC[-1]/R\",TEXT(T14,\"#\"),\"C8\")","v":"=RC[-1]/R1C8"}]
[null,null,null,null,"2001-10-01",null,"2010-09-30",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},null,{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"SRP"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"10/1/2001"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"9/30/2010"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,4,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},null,null,2,"SS","(mg/l)","E:E",5]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},{"$f":"CONCATENATE(\"=Data!R2C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R2C9:R1C9"},3,"TP","(mg/l)","F:F",6]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R1C7"},4,"SRP","(mg/l)","G:G",7]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,null,5,"NO23","(mg/l)","H:H",8]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,null,8,"Sulfate","(mg/l)","K:K",11]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,null,9,"Silica","(mg/l)","L:L",12]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"SRP, mg/L, as P"},{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"SRP, mg/L, as P"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"FlowDur","index":5,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[10,6,10,8],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5]]}
["Flow Duration &",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart7"]
["Cumulative Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=34608"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"E:E"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=39356"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A3:D\",TEXT(T14,\"#\"))","v":"A3:D3"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"H4:H\",TEXT(T14,\"#\"))","v":"H4:H3"},"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     10/1/1994 - 9/30/2007"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"I3:I\",TEXT(T14,\"#\"))","v":"I3:I3"},"Ylabel",null,"Flow   (cfs)"]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,true,null,null,null,{"$f":"CONCATENATE(\"=RC[-1]/R\",TEXT(T14,\"#\"),\"C8\")","v":"=RC[-1]/R3C8"},null,null,{"$f":"CONCATENATE(\"Percent of total \",AA8,\" load\")","v":"Percent of total SS load"},{"$f":"VLOOKUP(L11,V12:AA22,6)","v":"Suspended Solids"},{"$f":"VLOOKUP(N11,O12:S31,5)*2.59","v":678.57999999999993}]
[null,null,null,null,"1994-10-01",null,"2007-09-30",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},"Percent of time flow is exceeded",{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"SS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"10/1/1994"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"9/30/2007"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,2,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4,"Flow"]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},{"$f":"T14-3","v":0},null,2,"SS","(mg/l)","E:E",5,"Suspended Solids"]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+3","v":3},{"$f":"CONCATENATE(\"=Data!R2C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R2C9:R3C9"},3,"TP","(mg/l)","F:F",6,"Total Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R3C7"},4,"SRP","(mg/l)","G:G",7,"Soluble Reactive Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,null,5,"NO23","(mg/l)","H:H",8,"Nitrate "]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9,"Total Kjeldahl Nitrogen"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10,"Chloride"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,0,8,"Sulfate","(mg/l)","K:K",11,"Sulfate"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,1,9,"Silica","(mg/l)","L:L",12,"Silica"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13,"Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14,"Future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"SS, mg/L (suspended solids)"},{"$f":"VLOOKUP(1,Z25:AA35,2)","v":"Flow, CFS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$j$5:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$5:$j$3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$c$4:$c$\",TEXT(T14,\"#\"))","v":"Data!$c$4:$c$3"},null,null,null,{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$3"},{"$f":"CONCATENATE(\"=Data!R4C8:R\",TEXT(T14,\"#\"),\"C8\")","v":"=Data!R4C8:R3C8"},{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$3"},{"$f":"CONCATENATE(\"Data!$j$4:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$4:$j$3"},{"$f":"CONCATENATE(\"=Data!R4C11:R\",TEXT(T14,\"#\"),\"C11\")","v":"=Data!R4C11:R3C11"},{"$f":"CONCATENATE(\"Data!$L$4:$L$\",TEXT(T14,\"#\"))","v":"Data!$L$4:$L$3"},null,{"$f":"CONCATENATE(\"=Data!R4C14:R\",TEXT(T14,\"#\"),\"C14\")","v":"=Data!R4C14:R3C14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total time",{"$f":"SUM(INDIRECT(FlowDur!$U$45))","v":0},null,null,null,"Total Load",{"$f":"SUM(INDIRECT(FlowDur!$Z$45))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datetime","Time Window","Flow",{"$f":"FlowDur!$AA$8","v":"SS"},null,"Datetime","Sample Time Window","Flow",{"$f":"FlowDur!$AA$8","v":"SS"},"Cum time","% Time","Load (kg)","cum Load","Perc Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T04:00:00",0.33333333333212067,24538,11.9,{"$f":"U49","v":0.33333333333212067},{"$f":"X49/FlowDur!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U49*V49*W49*2.44512","v":237993.47308713422},{"$f":"Z49","v":237993.47308713422},{"$f":"AA49/FlowDur!$Z$46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T12:00:00",0.33333333333575865,24538,10.88,{"$f":"U50+X49","v":0.66666666666787933},{"$f":"X50/FlowDur!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U50*V50*W50*2.44512","v":217594.03253918324},{"$f":"Z50+AA49","v":455587.50562631746},{"$f":"AA50/FlowDur!$Z$46","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"SampleConc","index":6,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[10,6,10,8],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5]]}
["Flow Duration &",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart3"]
["Sample Concentration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=37530"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"F:F"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=39356"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A3:D\",TEXT(T14,\"#\"))","v":"A3:D3"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"H4:H\",TEXT(T14,\"#\"))","v":"H4:H3"},"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     10/1/2002 - 9/30/2007"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"I3:I\",TEXT(T14,\"#\"))","v":"I3:I3"},"Ylabel",null,"Flow   (cfs)"]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,false,null,null,null,{"$f":"CONCATENATE(\"=RC[-1]/R\",TEXT(T14,\"#\"),\"C8\")","v":"=RC[-1]/R3C8"},null,null,{"$f":"CONCATENATE(AA8,\"   \",AA9)","v":"TP   (mg/l)"},{"$f":"VLOOKUP(L11,V12:AA22,6)","v":"Total Phosphorus"},{"$f":"VLOOKUP(N11,O12:S31,5)*2.59","v":678.57999999999993}]
[null,null,null,null,"2002-10-01",null,"2007-09-30",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},"Percent of time flow is exceeded",{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"TP"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"10/1/2002"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"9/30/2007"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,3,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4,"Flow"]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},{"$f":"T14-3","v":0},null,2,"SS","(mg/l)","E:E",5,"Suspended Solids"]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+3","v":3},{"$f":"CONCATENATE(\"=Data!R2C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R2C9:R3C9"},3,"TP","(mg/l)","F:F",6,"Total Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R3C7"},4,"SRP","(mg/l)","G:G",7,"Soluble Reactive Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,null,5,"NO23","(mg/l)","H:H",8,"Nitrate "]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9,"Total Kjeldahl Nitrogen"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10,"Chloride"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,0,8,"Sulfate","(mg/l)","K:K",11,"Sulfate"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,1,9,"Silica","(mg/l)","L:L",12,"Silica"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13,"Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14,"Future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"TP, mg/L as P"},{"$f":"VLOOKUP(1,Z25:AA35,2)","v":"Flow, CFS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$j$5:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$5:$j$3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$c$4:$c$\",TEXT(T14,\"#\"))","v":"Data!$c$4:$c$3"},null,null,null,{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$3"},{"$f":"CONCATENATE(\"=Data!R4C8:R\",TEXT(T14,\"#\"),\"C8\")","v":"=Data!R4C8:R3C8"},{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$3"},{"$f":"CONCATENATE(\"Data!$j$4:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$4:$j$3"},{"$f":"CONCATENATE(\"=Data!R4C11:R\",TEXT(T14,\"#\"),\"C11\")","v":"=Data!R4C11:R3C11"},{"$f":"CONCATENATE(\"Data!$L$4:$L$\",TEXT(T14,\"#\"))","v":"Data!$L$4:$L$3"},null,{"$f":"CONCATENATE(\"=Data!R4C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R4C9:R3C9"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total time",{"$f":"SUM(INDIRECT(SampleConc!$U$45))","v":0},null,null,null,"Total Load",{"$f":"SUM(INDIRECT(SampleConc!$Z$45))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datetime","Time Window","Flow",{"$f":"SampleConc!$AA$8","v":"TP"},null,"Datetime","Sample Time Window","Flow",{"$f":"SampleConc!$AA$8","v":"TP"},"Cum time","% Time","Load (kg)","cum Load","Perc Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T04:00:00",0.33333333333212067,24538,11.9,{"$f":"U49","v":0.33333333333212067},{"$f":"X49/SampleConc!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U49*V49*W49*2.44512","v":237993.47308713422},{"$f":"Z49","v":237993.47308713422},{"$f":"AA49/SampleConc!$Z$46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T12:00:00",0.33333333333575865,24538,10.88,{"$f":"U50+X49","v":0.66666666666787933},{"$f":"X50/SampleConc!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U50*V50*W50*2.44512","v":217594.03253918324},{"$f":"Z50+AA49","v":455587.50562631746},{"$f":"AA50/SampleConc!$Z$46","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"Summary","index":7,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[10,6,10,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5]]}
["Summary Report of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart3"]
["Loads & Concentrations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=35339"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"F:F"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=39448"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A1:C\",TEXT(T14,\"#\"))","v":"A1:C3"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"H4:H\",TEXT(T14,\"#\"))","v":"H4:H3"},"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     10/1/1996 - 12/31/2007"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"I3:I\",TEXT(T14,\"#\"))","v":"I3:I3"},"Ylabel",null,{"$f":"CONCATENATE(AA8,\"  \",AA9)","v":"TP  (mg/l)"}]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,false,null,null,null,{"$f":"CONCATENATE(\"=RC[-1]/R\",TEXT(T14,\"#\"),\"C8\")","v":"=RC[-1]/R3C8"},null,null,null,{"$f":"VLOOKUP(L11,V12:AA22,6)","v":"Total Phosphorus"},{"$f":"VLOOKUP(N11,O12:S31,5)*2.59","v":678.57999999999993}]
[null,null,null,null,"1996-10-01",null,"2007-12-31",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},null,{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"TP"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"10/1/1996"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"12/31/2007"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,3,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4,"Flow"]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},{"$f":"T14-3","v":0},null,2,"SS","(mg/l)","E:E",5,"Suspended Solids"]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+3","v":3},{"$f":"CONCATENATE(\"=Data!R2C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R2C9:R3C9"},3,"TP","(mg/l)","F:F",6,"Total Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R3C7"},4,"SRP","(mg/l)","G:G",7,"Soluble Reactive Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,null,5,"NO23","(mg/l)","H:H",8,"Nitrate "]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9,"Total Kjeldahl Nitrogen"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10,"Chloride"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,null,8,"Sulfate","(mg/l)","K:K",11,"Sulfate"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,null,9,"Silica","(mg/l)","L:L",12,"Silica"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13,"Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14,"Future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"TP, mg/L as P"},{"$f":"VLOOKUP(1,Z25:AA35,2)","v":"Flow, CFS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$b$4:$b$\",TEXT(T14,\"#\"))","v":"Data!$b$4:$b$3"},{"$f":"CONCATENATE(\"Data!$c$4:$c$\",TEXT(T14,\"#\"))","v":"Data!$c$4:$c$3"},null,null,{"$f":"CONCATENATE(\"Data!$f$4:$f$\",TEXT(T14,\"#\"))","v":"Data!$f$4:$f$3"},{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$3"},{"$f":"CONCATENATE(\"Data!$h$4:$h$\",TEXT(T14,\"#\"))","v":"Data!$h$4:$h$3"},{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T47/P47","v":{"$error":"#DIV/0!"}},"Volume",{"$f":"V47/U47","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(Summary!$P$45))","v":0},{"$f":"SUM(INDIRECT(Summary!$Q$45))","v":0},null,null,{"$f":"SUM(INDIRECT(Summary!$T$45))","v":0},{"$f":"SUM(INDIRECT(Summary!$U$45))","v":0},{"$f":"SUM(INDIRECT(Summary!$V$45))","v":0},{"$f":"SUM(INDIRECT(Summary!$W$45))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datetime","Time Window","Flow",{"$f":"Summary!$AA$8","v":"TP"},null,"Time*Conc","Flow*Time","Flow*Time*Conc","kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P49*R49","v":0},{"$f":"P49*Q49","v":0},{"$f":"U49*R49","v":0},{"$f":"V49*2.44512","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"MonthSummary","index":8,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[7,4,7,5],[7,6,7,7],[10,6,10,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[6,4,6,5],[6,6,6,7]]}
["Monthly Summary Report of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart3"]
["Loads & Concentrations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=38259"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"E:E"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=39634"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A1:C\",TEXT(T14,\"#\"))","v":"A1:C3"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"H4:H\",TEXT(T14,\"#\"))","v":"H4:H3"},"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     9/29/2004 - 7/4/2008"},null,null,null,"Sandusky River     9/29/2004 - 7/4/2008"]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"I3:I\",TEXT(T14,\"#\"))","v":"I3:I3"},"Ylabel",null,{"$f":"CONCATENATE(AA8,\"  \",AA9)","v":"SS  (mg/l)"},null,null,null,"SS  (mg/l)"]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,true,null,null,null,{"$f":"CONCATENATE(\"=RC[-1]/R\",TEXT(T14,\"#\"),\"C8\")","v":"=RC[-1]/R3C8"},null,null,null,{"$f":"VLOOKUP(L11,V12:AA22,6)","v":"Suspended Solids"},{"$f":"VLOOKUP(N11,O12:S31,5)*2.59","v":678.57999999999993}]
[null,null,null,null,"2004-09-29",null,"2008-07-04",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O65:S84,5)","v":0},null,{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"SS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"9/29/2004"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"7/4/2008"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O65:U84,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,2,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4,"Flow"]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},{"$f":"T14-3","v":0},null,2,"SS","(mg/l)","E:E",5,"Suspended Solids"]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+3","v":3},{"$f":"CONCATENATE(\"=Data!R2C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R2C9:R3C9"},3,"TP","(mg/l)","F:F",6,"Total Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R3C7"},4,"SRP","(mg/l)","G:G",7,"Soluble Reactive Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,null,5,"NO23","(mg/l)","H:H",8,"Nitrate "]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9,"Total Kjeldahl Nitrogen"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10,"Chloride"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,null,8,"Sulfate","(mg/l)","K:K",11,"Sulfate"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,null,9,"Silica","(mg/l)","L:L",12,"Silica"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13,"Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14,"Future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"SS, mg/L (suspended solids)"},{"$f":"VLOOKUP(1,Z25:AA35,2)","v":"Flow, CFS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$b$4:$b$\",TEXT(T14,\"#\"))","v":"Data!$b$4:$b$3"},{"$f":"CONCATENATE(\"Data!$c$4:$c$\",TEXT(T14,\"#\"))","v":"Data!$c$4:$c$3"},null,null,{"$f":"CONCATENATE(\"Data!$f$4:$f$\",TEXT(T14,\"#\"))","v":"Data!$f$4:$f$3"},{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$3"},{"$f":"CONCATENATE(\"Data!$h$4:$h$\",TEXT(T14,\"#\"))","v":"Data!$h$4:$h$3"},{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T47/P47","v":{"$error":"#DIV/0!"}},"Volume",{"$f":"V47/U47","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(MonthSummary!$P$45))","v":0},{"$f":"SUM(INDIRECT(MonthSummary!$Q$45))","v":0},null,null,{"$f":"SUM(INDIRECT(MonthSummary!$T$45))","v":0},{"$f":"SUM(INDIRECT(MonthSummary!$U$45))","v":0},{"$f":"SUM(INDIRECT(MonthSummary!$V$45))","v":0},{"$f":"SUM(INDIRECT(MonthSummary!$W$45))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datetime","Time Window","Flow",{"$f":"MonthSummary!$AA$8","v":"SS"},null,"Time*Conc","Flow*Time","Flow*Time*Conc","kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P49*R49","v":0},{"$f":"P49*Q49","v":0},{"$f":"U49*R49","v":0},{"$f":"V49*2.44512","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=2"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$e$4:$e$\",TEXT(T14,\"#\"))","v":"Data!$e$4:$e$3"},null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$b$4:$b$\",TEXT(T14,\"#\"))","v":"Data!$b$4:$b$3"},"Time",{"$f":"SUMIF(INDIRECT($M$52),\"=1\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=2\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=3\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=4\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=5\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=6\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=7\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=8\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=9\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=10\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=11\",INDIRECT($M53))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=12\",INDIRECT($M53))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$3"},"Flow",{"$f":"SUMIF(INDIRECT($M$52),\"=1\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=2\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=3\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=4\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=5\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=6\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=7\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=8\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=9\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=10\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=11\",INDIRECT($M54))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=12\",INDIRECT($M54))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$f$4:$f$\",TEXT(T14,\"#\"))","v":"Data!$f$4:$f$3"},"Time*Conc",{"$f":"SUMIF(INDIRECT($M$52),\"=1\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=2\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=3\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=4\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=5\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=6\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=7\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=8\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=9\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=10\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=11\",INDIRECT($M55))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=12\",INDIRECT($M55))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$h$4:$h$\",TEXT(T14,\"#\"))","v":"Data!$h$4:$h$3"},"Time*Conc*Flow",{"$f":"SUMIF(INDIRECT($M$52),\"=1\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=2\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=3\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=4\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=5\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=6\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=7\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=8\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=9\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=10\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=11\",INDIRECT($M56))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=12\",INDIRECT($M56))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$b$4:$b$\",TEXT(T14,\"#\"))","v":"Data!$b$4:$b$3"},"# of Samples",{"$f":"COUNTIF(INDIRECT($M$52),\"=1\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=2\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=3\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=4\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=5\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=6\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=7\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=8\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=9\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=10\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=11\")","v":0},{"$f":"COUNTIF(INDIRECT($M$52),\"=12\")","v":0},{"$f":"SUM(O57:Z57)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Weighted Mean",{"$f":"O56/O54","v":{"$error":"#DIV/0!"}},{"$f":"P56/P54","v":{"$error":"#DIV/0!"}},{"$f":"Q56/Q54","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time Weighted Mean",{"$f":"O55/O53","v":{"$error":"#DIV/0!"}},{"$f":"P55/P53","v":{"$error":"#DIV/0!"}},{"$f":"Q55/Q53","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$3"},"Total Load",{"$f":"SUMIF(INDIRECT($M$52),\"=1\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=2\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=3\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=4\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=5\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=6\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=7\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=8\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=9\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=10\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=11\",INDIRECT($M60))","v":0},{"$f":"SUMIF(INDIRECT($M$52),\"=12\",INDIRECT($M60))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Discharge",{"$f":"O54","v":0},{"$f":"P54","v":0},{"$f":"Q54","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T65))","v":0},{"$f":"CONCATENATE(P65,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"ConcFlow","index":9,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[10,6,10,8],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5]]}
["Concentration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart1"]
["Vrs. Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=40589"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"F:F"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=40679"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"B1:C\",TEXT(T14,\"#\"))","v":"B1:C1"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!B:B",null,null,"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     2/15/2011 - 5/15/2011"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,"Data!C:C",null,null,"Ylabel",null,{"$f":"CONCATENATE(AA8,\"  \",AA9)","v":"TP  (mg/l)"}]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,true,null,null,null,null,"Xlabel",null,"Flow (cfs)"]
[null,null,null,null,"2011-02-15",null,"2011-05-15",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},null,{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"TP"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"2/15/2011"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"5/15/2011"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,3,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},null,null,2,"SS","(mg/l)","E:E",5]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},null,3,"TP","(mg/l)","F:F",6]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},{"$f":"MIN(INDIRECT(Q5))","v":0},{"$f":"MIN(INDIRECT(Q6))","v":0},4,"SRP","(mg/l)","G:G",7]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},{"$f":"IF(T15<1,0.1,ROUNDDOWN(LOG(T15),0))","v":0.1},{"$f":"IF(U15<1,0.1,ROUNDDOWN(LOG(U15),0))","v":0.1},5,"NO23","(mg/l)","H:H",8]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},{"$f":"IF(T15<0.01,0.001,IF(T15<0.1, 0.01,IF(T15<1,0.1,POWER(10,T16))))","v":1E-3},{"$f":"IF(U15<0.01,0.001,IF(U15<0.1, 0.01,IF(U15<1,0.1,POWER(10,U16))))","v":1E-3},7,"Chloride","(mg/l)","J:J",10]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,null,8,"Sulfate","(mg/l)","K:K",11]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,null,9,"Silica","(mg/l)","L:L",12]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"TP, mg/L as P"},{"$f":"VLOOKUP(1,Z25:AA35,2)","v":"Flow, CFS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"TwoVariable","index":10,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[6,6,6,7],[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[6,4,6,5],[10,6,10,8],[16,0,16,1],[12,0,12,1],[7,4,7,5],[7,6,7,7]]}
["Two Variable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart2"]
["Comparison",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=33147"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,$V$12:$Y$22,4)","v":"F:F"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=33512"},"DateEnd",null,"Parameter2",null,{"$f":"VLOOKUP(M11,$V$12:$Y$22,4)","v":"I:I"},{"$f":"VLOOKUP(M11,V12:Z22,5)","v":9}]
["Data Selection",null,null,null,null,null,null,null,null,null,null,"x - axis","Y - axis",null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"B1:C\",TEXT(T14,\"#\"))","v":"B1:C1"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,2,1,null,null,null,"Data!B:B",null,null,"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     10/1/1990 - 9/30/1991"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,"Linear","Linear",null,null,null,"Data!C:C",null,null,"Xlabel",null,{"$f":"CONCATENATE(AA8,\"  \",AA9)","v":"TP  (mg/l)"}]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,"Logarithmic","Logarithmic",null,false,null,null,null,null,"Ylabel",null,{"$f":"CONCATENATE(Z8,\"  \",Z9)","v":"TKN  (mg/l)"}]
[null,null,null,"x","1990-10-01",null,"1991-09-30",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},null,{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,{"$f":"VLOOKUP(M11,V12:X22,2)","v":"TKN"},{"$f":"VLOOKUP(L11,V12:X22,2)","v":"TP"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"10/1/1990"},null,null,{"$f":"VLOOKUP(M11,V12:X22,3)","v":"(mg/l)"},{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,"y",null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"9/30/1991"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,3,6,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow","Flow","Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4]
["X - axis scale",null,null,null,null,null,null,null,null,null,null,"SS","SS","Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},null,{"$f":"TEXT(T14,\"#\")","v":"1"},2,"SS","(mg/l)","E:E",5]
[null,null,null,null,null,null,null,null,null,null,null,"TP","TP","Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},null,3,"TP","(mg/l)","F:F",6]
[null,null,null,null,null,null,null,null,null,null,null,"SRP","SRP","Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},{"$f":"MIN(INDIRECT(Q5))","v":0},{"$f":"MIN(INDIRECT(Q6))","v":0},4,"SRP","(mg/l)","G:G",7]
[null,null,null,null,null,null,null,null,null,null,null,"NO23","NO23","Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},{"$f":"IF(T15<1,0.1,ROUNDDOWN(LOG(T15),0))","v":0.1},{"$f":"IF(U15<1,0.1,ROUNDDOWN(LOG(U15),0))","v":0.1},5,"NO23","(mg/l)","H:H",8]
["Y - axis scale",null,null,null,null,null,null,null,null,null,null,"TKN","TKN","Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride","Chloride","Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},{"$f":"IF(T15<0.01,0.001,IF(T15<0.1, 0.01,IF(T15<1,0.1,POWER(10,T16))))","v":1E-3},{"$f":"IF(U15<0.01,0.001,IF(U15<0.1, 0.01,IF(U15<1,0.1,POWER(10,U16))))","v":1E-3},7,"Chloride","(mg/l)","J:J",10]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate","Sulfate","Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,null,8,"Sulfate","(mg/l)","K:K",11]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica","Silica","Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,null,9,"Silica","(mg/l)","L:L",12]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity","Conductivity","Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13]
[null,null,null,null,null,null,null,null,null,null,null,"Future","Future","Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"TP, mg/L as P"},{"$f":"VLOOKUP(M11,Z25:AA35,2)","v":"TKN, mg/L (Total Kjeldahl nitrogen)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"TwoRiver","index":11,"n_rows":116,"n_cols":29,"rows_kept":116,"cut":false,"hidden":true,"merged":[[16,6,16,8],[13,6,13,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[7,4,7,5],[7,6,7,7],[6,6,6,7],[6,4,6,5],[8,4,8,7],[9,4,9,5],[9,6,9,7],[10,4,10,5],[10,6,10,7]]}
["Two River",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart6"]
["Comparison",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DateBegin2",{"$f":"CONCATENATE(\">=\",E11)","v":">=27668"},{"$f":"CONCATENATE(\">=\",E8)","v":">=27668"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"H:H"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DateEnd2",{"$f":"CONCATENATE(\"<=\",G11+1)","v":"<=40452"},{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=40452"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",null,{"$f":"CONCATENATE(\"A1:C\",TEXT(T13,\"#\"))","v":"A1:C3"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!D:D",null,{"$f":"CONCATENATE(\"D1:F\",TEXT(T15,\"#\"))","v":"D1:F3"},"DataRange2",null,{"$f":"CONCATENATE(W8,\" & \",X8,\"     \",W9,\" - \",W10)","v":"Vermilion River & Old Women Creek - Lake     10/1/1975 - 9/30/2010"}]
["      Select River 1",null,"Select Parameter",null,"River 1 Date",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"n5:o\",TEXT(T13,\"#\"))","v":"n5:o3"},"PasteRange",null,{"$f":"CONCATENATE(AA8,\" \",AA9)","v":"NO23 (mg/l)"}]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,true,null,null,null,{"$f":"CONCATENATE(\"p5:q\",TEXT(T15,\"#\"))","v":"p5:q3"},"PasteRange2",null,{"$f":"CONCATENATE(\"Percent of total \",AA8,\" load\")","v":"Percent of total NO23 load"},{"$f":"VLOOKUP(L11,V12:AA22,6)","v":"Nitrate "},{"$f":"VLOOKUP(N11,O12:S31,5)*2.59","v":678.57999999999993}]
[null,null,null,null,"1975-10-01",null,"2010-09-30",null,null,null,null,null,null,null,true,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},{"$f":"CONCATENATE(\"a4:o\",U10+4)","v":"a4:o4"},null,null,"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},"Percent of time concentration is exceeded",{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},{"$f":"VLOOKUP(O11,O12:R31,4)","v":"Old Women Creek - Lake"},null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"NO23"}]
[null,null,null,null,"River 2 Date",null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"10/1/1975"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
["      Select River 2",null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,"River 1","River 2",{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,"#records = ",{"$f":"VLOOKUP(O11,O60:S79,5)","v":0},null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"9/30/2010"}]
[null,null,null,null,"1975-10-01",null,"2010-09-30",null,null,null,null,5,null,20,13,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"},{"$f":"VLOOKUP(O11,O12:Q31,3)","v":"LakeOWCData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4,"Flow"]
[null,null,null,null,null,null,"Dates Available for River 1",null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},{"$f":"T14+2","v":3},null,2,"SS","(mg/l)","E:E",5,"Suspended Solids"]
[null,null,null,null,null,null,{"$f":"VLOOKUP($N$11,$O$60:$U$79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},{"$f":"CONCATENATE(\"=Data!R2C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R2C9:R1C9"},3,"TP","(mg/l)","F:F",6,"Total Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},{"$f":"T16+2","v":3},{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R1C7"},4,"SRP","(mg/l)","G:G",7,"Soluble Reactive Phosphorus"]
[null,null,null,null,null,null,"Dates Available for River 2",null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},{"$f":"COUNT(INDIRECT(Q5))+1","v":1},null,5,"NO23","(mg/l)","H:H",8,"Nitrate "]
[null,null,null,null,null,null,{"$f":"VLOOKUP($O$11,$O$60:$U$79,7)","v":"11/6/1987 - 12/31/2015"},null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9,"Total Kjeldahl Nitrogen"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10,"Chloride"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,0,8,"Sulfate","(mg/l)","K:K",11,"Sulfate"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,1,9,"Silica","(mg/l)","L:L",12,"Silica"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13,"Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14,"Future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"NO23, mg/L as N"},{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"NO23, mg/L as N"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$j$5:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$5:$j$1"},{"$f":"CONCATENATE(\"=Data!R4C10:R\",TEXT(T13,\"#\"),\"C10\")","v":"=Data!R4C10:R3C10"},null,null,{"$f":"CONCATENATE(\"=Data!R4C13:R\",TEXT(T15,\"#\"),\"C13\")","v":"=Data!R4C13:R3C13"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$c$4:$c$\",TEXT(T14,\"#\"))","v":"Data!$c$4:$c$1"},null,null,null,{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$1"},{"$f":"CONCATENATE(\"=Data!R4C8:R\",TEXT(T14,\"#\"),\"C8\")","v":"=Data!R4C8:R1C8"},{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$1"},{"$f":"CONCATENATE(\"Data!$j$4:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$4:$j$1"},{"$f":"CONCATENATE(\"=Data!R4C15:R\",TEXT(T13,\"#\"),\"C15\")","v":"=Data!R4C15:R3C15"},{"$f":"CONCATENATE(\"Data!$b$2:$b$\",TEXT(T13,\"#\"))","v":"Data!$b$2:$b$3"},{"$f":"CONCATENATE(\"Data!$e$2:$e$\",TEXT(T15,\"#\"))","v":"Data!$e$2:$e$3"},{"$f":"CONCATENATE(\"=Data!R4C17:R\",TEXT(T15,\"#\"),\"C17\")","v":"=Data!R4C17:R3C17"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(TwoRiver!$Z$45))","v":0},{"$f":"SUM(INDIRECT(TwoRiver!$AA$45))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"River 1","River 1 ","River 2","River 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datetime","Time Window",{"$f":"VLOOKUP(N11,O60:R79,4)","v":"Vermilion River"},{"$f":"VLOOKUP(O11,O60:R79,4)","v":"Old Woman Creek - Lake"},null,"Datetime","Sample Time Window","NO23","Datetime","Sample time window","NO23","Cum Time","Perc. Time","Cum Time","Perc. Time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1994-10-01T12:00:00",1,0.01,"1994-10-01T04:00:00",0.33333333333212067,3.06,{"$f":"U49","v":1},{"$f":"Z49/TwoRiver!$Z$46","v":{"$error":"#DIV/0!"}},{"$f":"X49","v":0.33333333333212067},{"$f":"AB49/TwoRiver!$AA$46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1994-10-02T12:00:00",0.83333333333212067,0.01,"1994-10-01T12:00:00",0.33333333333575865,2.44,{"$f":"U50+Z49","v":1.8333333333321207},{"$f":"Z50/TwoRiver!$Z$46","v":{"$error":"#DIV/0!"}},{"$f":"AB49+X50","v":0.66666666666787933},{"$f":"AB50/TwoRiver!$AA$46","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"LoadingRate","index":12,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[7,4,7,5],[7,6,7,7],[10,6,10,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[6,4,6,5],[6,6,6,7]]}
["Loading Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart9"]
["vrs. Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=38626"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"E:E"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=38991"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A1:A\",TEXT(T14,\"#\"))","v":"A1:A1"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"e4:H\",TEXT(T14,\"#\"))","v":"e4:H1"},"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     10/1/2005 - 9/30/2006"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"e3:e\",TEXT(T14,\"#\"))","v":"e3:e1"},"Ylabel",null,"Date"]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,false,null,null,null,{"$f":"CONCATENATE(\"=RC[-1]/R\",TEXT(T14,\"#\"),\"C8\")","v":"=RC[-1]/R1C8"},null,null,{"$f":"CONCATENATE(\"Loading Rate, \",AA8,\"   Kg/day\")","v":"Loading Rate, SS   Kg/day"},{"$f":"VLOOKUP(L11,V12:AA22,6)","v":"Suspended Solids"},{"$f":"VLOOKUP(N11,O12:S31,5)*2.59","v":678.57999999999993}]
[null,null,null,null,"2005-10-01",null,"2006-09-30",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,{"$f":"CONCATENATE(\"d2:e\",TEXT(T14,\"#\"))","v":"d2:e1"},"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},"Percent of time flow is exceeded",{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"SS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"10/1/2005"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"9/30/2006"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,2,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4,"Flow"]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},{"$f":"T14-3","v":-2},null,2,"SS","(mg/l)","E:E",5,"Suspended Solids"]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},{"$f":"CONCATENATE(\"=Data!R2C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R2C9:R1C9"},3,"TP","(mg/l)","F:F",6,"Total Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R1C7"},4,"SRP","(mg/l)","G:G",7,"Soluble Reactive Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,null,5,"NO23","(mg/l)","H:H",8,"Nitrate "]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,null,6,"TKN","(mg/l)","I:I",9,"Total Kjeldahl Nitrogen"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10,"Chloride"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,0,8,"Sulfate","(mg/l)","K:K",11,"Sulfate"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,1,9,"Silica","(mg/l)","L:L",12,"Silica"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13,"Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14,"Future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"SS, mg/L (suspended solids)"},{"$f":"VLOOKUP(1,Z25:AA35,2)","v":"Flow, CFS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$j$5:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$5:$j$1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$c$4:$c$\",TEXT(T14,\"#\"))","v":"Data!$c$4:$c$1"},null,null,null,{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$1"},{"$f":"CONCATENATE(\"=Data!R4C8:R\",TEXT(T14,\"#\"),\"C8\")","v":"=Data!R4C8:R1C8"},{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$1"},{"$f":"CONCATENATE(\"Data!$j$4:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$4:$j$1"},{"$f":"CONCATENATE(\"=Data!R4C11:R\",TEXT(T14,\"#\"),\"C11\")","v":"=Data!R4C11:R1C11"},{"$f":"CONCATENATE(\"Data!$L$4:$L$\",TEXT(T14,\"#\"))","v":"Data!$L$4:$L$1"},null,{"$f":"CONCATENATE(\"=Data!R4C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R4C9:R1C9"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total time",{"$f":"SUM(INDIRECT(LoadingRate!$U$45))","v":0},null,null,null,"Total Load",{"$f":"SUM(INDIRECT(LoadingRate!$Z$45))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datetime","Time Window","Flow",{"$f":"LoadingRate!$AA$8","v":"SS"},null,"Datetime","Sample Time Window","Flow",{"$f":"LoadingRate!$AA$8","v":"SS"},"Cum time","% Time","Load (kg)","cum Load","Perc Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T04:00:00",0.33333333333212067,24538,11.9,{"$f":"U49","v":0.33333333333212067},{"$f":"X49/LoadingRate!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U49*V49*W49*2.44512","v":237993.47308713422},{"$f":"Z49","v":237993.47308713422},{"$f":"AA49/LoadingRate!$Z$46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T12:00:00",0.33333333333575865,24538,10.88,{"$f":"U50+X49","v":0.66666666666787933},{"$f":"X50/LoadingRate!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U50*V50*W50*2.44512","v":217594.03253918324},{"$f":"Z50+AA49","v":455587.50562631746},{"$f":"AA50/LoadingRate!$Z$46","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"LoadCumul","index":13,"n_rows":116,"n_cols":28,"rows_kept":116,"cut":false,"hidden":true,"merged":[[7,4,7,5],[7,6,7,7],[10,6,10,8],[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,4,5,7],[6,4,6,5],[6,6,6,7]]}
["Loading Rate &",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Selection Criteria",null,null,"Most Recent Chart",null,"Chart4"]
["Cumulative Loads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",E8)","v":">=40787"},"DateBegin",null,"Parameter1",null,{"$f":"VLOOKUP(L11,V12:Y22,4)","v":"G:G"},{"$f":"VLOOKUP(L11,V12:Z22,5)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"<=\",G8+1)","v":"<=40940"},"DateEnd",null,"Parameter2",null,"Not Used"]
["Data Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data!A:A",{"$f":"COUNT(#REF!)+1","v":1},{"$f":"CONCATENATE(\"A1:A\",TEXT(T14,\"#\"))","v":"A1:A1"},"DataRange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"e4:H\",TEXT(T14,\"#\"))","v":"e4:H1"},"Graph Title",null,{"$f":"CONCATENATE(W8,\"     \",W9,\" - \",W10)","v":"Vermilion River     9/1/2011 - 1/31/2012"}]
["Select River/Tributary",null,"Select Parameter",null,"Select Date Range",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"e3:e\",TEXT(T14,\"#\"))","v":"e3:e1"},"Ylabel",null,"Total Load, Kg"]
[null,null,null,null,"Beginning Date",null,"Ending Date",null,null,null,null,null,null,null,true,null,null,null,{"$f":"CONCATENATE(\"=RC[-1]/R\",TEXT(T14,\"#\"),\"C8\")","v":"=RC[-1]/R1C8"},null,null,{"$f":"CONCATENATE(\"Loading Rate, \",AA8,\"   Kg/day\")","v":"Loading Rate, SRP   Kg/day"},{"$f":"VLOOKUP(L11,V12:AA22,6)","v":"Soluble Reactive Phosphorus"},{"$f":"VLOOKUP(N11,O12:S31,5)*2.59","v":678.57999999999993}]
[null,null,null,null,"2011-09-01",null,"2012-01-31",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a4:o\",U8+4)","v":"a4:o4"},null,null,{"$f":"CONCATENATE(\"d2:e\",TEXT(T14,\"#\"))","v":"d2:e1"},"#records = ",{"$f":"VLOOKUP(N11,O60:S79,5)","v":0},"Percent of time flow is exceeded",{"$f":"VLOOKUP(N11,O12:R31,4)","v":"Vermilion River"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,2)","v":"SRP"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"a2:o\",U8)","v":"[VermilionData.xlsx]Data!a2:o0"},null,null,null,null,{"$f":"TEXT(U8,\"#\")","v":""},null,{"$f":"TEXT(E8,\"m/d/yyyy\")","v":"9/1/2011"},null,null,null,{"$f":"VLOOKUP(L11,V12:X22,3)","v":"(mg/l)"}]
[null,null,null,null,null,null,"Dates Available for River Data",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(P11,\"A:A\",U9)","v":"[VermilionData.xlsx]Data!A:A"},null,null,null,null,null,null,{"$f":"TEXT(G8,\"m/d/yyyy\")","v":"1/31/2012"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(N11,O60:U79,7)","v":"10/2/2000 - 7/21/2008"},null,null,null,null,4,null,20,null,{"$f":"VLOOKUP(N11,O12:P31,2)","v":"[VermilionData.xlsx]Data!"},{"$f":"VLOOKUP(N11,O12:Q31,3)","v":"VermilionData.xlsx"}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow",null,"Blanchard",1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"Menu!AC5","v":346},null,null,1,"Flow","(cfs)","D:D",4,"Flow"]
[null,null,null,null,null,null,null,null,null,null,null,"SS",null,"Beaver Creek",2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx",{"$f":"N13","v":"Beaver Creek"},{"$f":"Menu!AC6","v":113},{"$f":"T14-3","v":-2},null,2,"SS","(mg/l)","E:E",5,"Suspended Solids"]
[null,null,null,null,null,null,null,null,null,null,null,"TP",null,"Chickasaw",3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",{"$f":"Menu!AC7","v":16.399999999999999},{"$f":"COUNT(INDIRECT(Q4))+1","v":1},{"$f":"CONCATENATE(\"=Data!R2C1:R\",TEXT(T14,\"#\"),\"C1\")","v":"=Data!R2C1:R1C1"},3,"TP","(mg/l)","F:F",6,"Total Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"SRP",null,"Coldwater Creek",4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",{"$f":"Menu!AC8","v":0},null,{"$f":"CONCATENATE(\"=Data!R2C5:R\",TEXT(T14,\"#\"),\"C5\")","v":"=Data!R2C5:R1C5"},4,"SRP","(mg/l)","G:G",7,"Soluble Reactive Phosphorus"]
[null,null,null,null,null,null,null,null,null,null,null,"NO23",null,"Cuyahoga",5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",{"$f":"Menu!AC9","v":708},null,{"$f":"U14","v":"=Data!R2C1:R1C1"},5,"NO23","(mg/l)","H:H",8,"Nitrate "]
[null,null,null,null,null,null,null,null,null,null,null,"TKN",null,"Grand",6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",{"$f":"Menu!AC10","v":686},null,{"$f":"CONCATENATE(\"=Data!R2C7:R\",TEXT(T14,\"#\"),\"C7\")","v":"=Data!R2C7:R1C7"},6,"TKN","(mg/l)","I:I",9,"Total Kjeldahl Nitrogen"]
[null,null,null,null,null,null,null,null,null,null,null,"Chloride",null,"Great Miami",7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",{"$f":"Menu!AC11","v":2685},null,null,7,"Chloride","(mg/l)","J:J",10,"Chloride"]
[null,null,null,null,null,null,null,null,null,null,null,"Sulfate",null,"Honey Creek",8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",{"$f":"Menu!AC12","v":149},null,0,8,"Sulfate","(mg/l)","K:K",11,"Sulfate"]
[null,null,null,null,null,null,null,"Program supported by the ",null,null,null,"Silica",null,"Lost Creek",9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",{"$f":"Menu!AC13","v":4.2300000000000004},null,1,9,"Silica","(mg/l)","L:L",12,"Silica"]
[null,null,null,null,null,null,null,"Lake Erie Protection Fund",null,null,null,"Conductivity",null,"Maumee",10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",{"$f":"Menu!AC14","v":6330},null,null,10,"Conductivity","(μmho)","M:M",13,"Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,"Future",null,"Muskingum",11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",{"$f":"Menu!AC15","v":7420},null,null,11,"Future","N/A","N:N",14,"Future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Berlin",12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx",{"$f":"N23","v":"Old Women Creek - Berlin"},{"$f":"Menu!AC16","v":22.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Women Creek - Lake",13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx",{"$f":"N24","v":"Old Women Creek - Lake"},{"$f":"Menu!AC17","v":26.5},null,null,null,null,null,null,null,{"$f":"VLOOKUP(L11,Z25:AA35,2)","v":"SRP, mg/L, as P"},{"$f":"VLOOKUP(1,Z25:AA35,2)","v":"Flow, CFS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage",14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",{"$f":"Menu!AC18","v":494},null,null,null,null,null,null,1,"Flow, CFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Raisin",15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",{"$f":"Menu!AC19","v":1042},null,null,null,null,null,null,2,"SS, mg/L (suspended solids)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Creek",16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",{"$f":"Menu!AC20","v":34.6},null,null,null,null,null,null,3,"TP, mg/L as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky",17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",{"$f":"Menu!AC21","v":1253},null,null,null,null,null,null,4,"SRP, mg/L, as P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scioto",18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",{"$f":"Menu!AC22","v":3854},null,null,null,null,null,null,5,"NO23, mg/L as N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiffin",19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",{"$f":"Menu!AC23","v":410},null,null,null,null,null,null,6,"TKN, mg/L (Total Kjeldahl nitrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermilion",20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",{"$f":"Menu!AC24","v":262},null,null,null,null,null,null,7,"Chloride, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Sulfate, mg/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Silica, mg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Conductivity, μmho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Future, NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$j$5:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$5:$j$1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Data!$c$4:$c$\",TEXT(T14,\"#\"))","v":"Data!$c$4:$c$1"},null,null,null,{"$f":"CONCATENATE(\"Data!$g$4:$g$\",TEXT(T14,\"#\"))","v":"Data!$g$4:$g$1"},{"$f":"CONCATENATE(\"=Data!R4C8:R\",TEXT(T14,\"#\"),\"C8\")","v":"=Data!R4C8:R1C8"},{"$f":"CONCATENATE(\"Data!$i$4:$i$\",TEXT(T14,\"#\"))","v":"Data!$i$4:$i$1"},{"$f":"CONCATENATE(\"Data!$j$4:$j$\",TEXT(T14,\"#\"))","v":"Data!$j$4:$j$1"},{"$f":"CONCATENATE(\"=Data!R4C11:R\",TEXT(T14,\"#\"),\"C11\")","v":"=Data!R4C11:R1C11"},{"$f":"CONCATENATE(\"Data!$L$4:$L$\",TEXT(T14,\"#\"))","v":"Data!$L$4:$L$1"},null,{"$f":"CONCATENATE(\"=Data!R4C9:R\",TEXT(T14,\"#\"),\"C9\")","v":"=Data!R4C9:R1C9"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total time",{"$f":"SUM(INDIRECT(LoadCumul!$U$45))","v":0},null,null,null,"Total Load",{"$f":"SUM(INDIRECT(LoadCumul!$Z$45))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datetime","Time Window","Flow",{"$f":"LoadCumul!$AA$8","v":"SRP"},null,"Datetime","Sample Time Window","Flow",{"$f":"LoadCumul!$AA$8","v":"SRP"},"Cum time","% Time","Load (kg)","cum Load","Perc Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T04:00:00",0.33333333333212067,24538,11.9,{"$f":"U49","v":0.33333333333212067},{"$f":"X49/LoadCumul!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U49*V49*W49*2.44512","v":237993.47308713422},{"$f":"Z49","v":237993.47308713422},{"$f":"AA49/LoadCumul!$Z$46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001-05-28T12:00:00",0.33333333333575865,24538,10.88,{"$f":"U50+X49","v":0.66666666666787933},{"$f":"X50/LoadCumul!$U$46","v":{"$error":"#DIV/0!"}},{"$f":"U50*V50*W50*2.44512","v":217594.03253918324},{"$f":"Z50+AA49","v":455587.50562631746},{"$f":"AA50/LoadCumul!$Z$46","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"[BlanchardData.xlsx]Data!","BlanchardData.xlsx","Blanchard River",{"$f":"COUNT(INDIRECT(T60))","v":0},{"$f":"CONCATENATE(P60,\"A:A\")","v":"[BlanchardData.xlsx]Data!A:A"},{"$f":"Menu!AB5","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"[BeaverCreekData.xlsx]Data!","BeaverCreekData.xlsx","Beaver Creek",0,"[BeaverCreekData.xlsx]Data!A:A",{"$f":"Menu!AB6","v":"10/02/2013 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"[ChickasawData.xlsx]Data!","ChickasawData.xlsx","Chickasaw River",0,"[ChickasawData.xlsx]Data!A:A",{"$f":"Menu!AB7","v":"9/29/2008 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"[ColdwaterCreekData.xlsx]Data!","ColdwaterCreekData.xlsx","Coldwater Creek",0,"[ColdwaterCreekData.xlsx]Data!A:A",{"$f":"Menu!AB8","v":"11/14/2011 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"[CuyahogaData.xlsx]Data!","CuyahogaData.xlsx","Cuyahoga River",0,"[CuyahogaData.xlsx]Data!A:A",{"$f":"Menu!AB9","v":"11/4/1981 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"[GrandData.xlsx]Data!","GrandData.xlsx","Grand River",0,"[GrandData.xlsx]Data!A:A",{"$f":"Menu!AB10","v":"2/16/1988 - 8/10/2006"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"[GreatMiamiData.xlsx]Data!","GreatMiamiData.xlsx","Great Miami River",0,"[GreatMiamiData.xlsx]Data!A:A",{"$f":"Menu!AB11","v":"4/22/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"[HoneyCreekData.xlsx]Data!","HoneyCreekData.xlsx","Honey Creek",0,"[HoneyCreekData.xlsx]Data!A:A",{"$f":"Menu!AB12","v":"1/28/1976 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"[LostCreekData.xlsx]Data!","LostCreekData.xlsx","Lost Creek",0,"[LostCreekData.xlsx]Data!A:A",{"$f":"Menu!AB13","v":"8/6/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"[MaumeeData.xlsx]Data!","MaumeeData.xlsx","Maumee River",0,"[MaumeeData.xlsx]Data!A:A",{"$f":"Menu!AB14","v":"1/10/1975 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"[MuskingumData.xlsx]Data!","MuskingumData.xlsx","Muskingum River",0,"[MuskingumData.xlsx]Data!A:A",{"$f":"Menu!AB15","v":"4/11/1994 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"[BerlinOWCData.xlsx]Data!","BerlinOWCData.xlsx","Old Woman Creek - Berlin",0,"[BerlinOWCData.xlsx]Data!A:A",{"$f":"Menu!AB16","v":"11/9/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"[LakeOWCData.xlsx]Data!","LakeOWCData.xlsx","Old Woman Creek - Lake",0,"[LakeOWCData.xlsx]Data!A:A",{"$f":"Menu!AB17","v":"11/6/1987 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"[PortageData.xlsx]Data!","PortageData.xlsx","Portage River",0,"[PortageData.xlsx]Data!A:A",{"$f":"Menu!AB18","v":"8/30/2010 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"[RaisinData.xlsx]Data!","RaisinData.xlsx","River Raisin",0,"[RaisinData.xlsx]Data!A:A",{"$f":"Menu!AB19","v":"3/6/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"[RockCreekData.xlsx]Data!","RockCreekData.xlsx","Rock Creek",0,"[RockCreekData.xlsx]Data!A:A",{"$f":"Menu!AB20","v":"10/11/1982 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"[SanduskyData.xlsx]Data!","SanduskyData.xlsx","Sandusky River",0,"[SanduskyData.xlsx]Data!A:A",{"$f":"Menu!AB21","v":"10/2/1974 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"[SciotoData.xlsx]Data!","SciotoData.xlsx","Scioto River",0,"[SciotoData.xlsx]Data!A:A",{"$f":"Menu!AB22","v":"4/23/1996 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"[TiffinData.xlsx]Data!","TiffinData.xlsx","Tiffin River",0,"[TiffinData.xlsx]Data!A:A",{"$f":"Menu!AB23","v":"7/9/2007 - 12/31/2015"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"[VermilionData.xlsx]Data!","VermilionData.xlsx","Vermilion River",0,"[VermilionData.xlsx]Data!A:A",{"$f":"Menu!AB24","v":"10/2/2000 - 7/21/2008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph Title"]
["Could this be a title?"]
[]
[]
["X axis Label"]
[]
[]
[]
["Y axis Label"]

{"sheet":"Report","index":14,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Summary Loading and Concentration Report"]
[]
["River:",null,{"$f":"Summary!W8","v":"Vermilion River"}]
["Parameter:",null,{"$f":"Summary!W7","v":"Total Phosphorus"}]
["Starting Date:",null,{"$f":"Summary!E8","v":"1996-10-01"}]
["Final Date:",null,{"$f":"Summary!G8","v":"2007-12-31"}]
[]
["Number of Samples:",null,{"$f":"Summary!T13","v":0}]
[]
["Total Load:",{"$f":"INDIRECT(H10)","v":0},"kg",{"$f":"B10*2.205","v":0},"lbs",null,null,"Data!I2"]
[null,{"$f":"B10/1000","v":0},"metric tons",{"$f":"D10/2000","v":0},"short tons"]
[]
["Unit area load:",{"$f":"B10/Summary!X7/100","v":0},"kg/ha",{"$f":"B13*2.205/2.471","v":0},"lbs/acre"]
["Annualized Unit"]
["        Area Load",{"$f":"B13*365/$D$21","v":{"$error":"#DIV/0!"}},"kg/ha",{"$f":"D13*365/$D$21","v":{"$error":"#DIV/0!"}},"lbs/acre"]
[]
["Flow weighted mean concentration:",null,null,{"$f":"INDIRECT(H17)","v":0},"mg/L",null,null,"Data!H1"]
["Time weighted mean concentration:",null,null,{"$f":"INDIRECT(H18)","v":0},"mg/L",null,null,"Data!F1"]
[]
["Time interval between beginning and ending date:",null,null,{"$f":"C6-C5+1","v":4109},"days"]
["Time interval covered by sample time windows:",null,null,{"$f":"INDIRECT(H21)","v":0},"days",null,null,"Data!B2"]
["Percent of time covered by sample time windows:",null,null,{"$f":"D21/D20","v":0}]
[]
[]
[]
[]
[]
["Observed discharge volume:",null,null,{"$f":"D29*2447/1000","v":0},"thousand m3"]
[null,null,null,{"$f":"INDIRECT(H29)","v":0},"cfs-days",null,null,"Data!G2"]

{"sheet":"MonthReport","index":15,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,0,0,12],[1,0,1,12]]}
[{"$f":"MonthSummary!V5","v":"Vermilion River     9/29/2004 - 7/4/2008"}]
[{"$f":"MonthSummary!Z6","v":"SS  (mg/l)"}]
[null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["# of Samples",184,157,200,191,197,205,163,108,133,148,164,131]
["Time Samples Represent (days)",97.604166666663019,89.499999999992724,112.37861111110706,118.60937499999636,120.83333333333212,121.11631944444525,95.503469555554773,85.177083333346673,86.271097222222622,112.27951388889414,111.66666666666424,95.712847222221171]
["Flow Weighted Mean Concentration (mg/l)",172.88523333515994,181.12115482782127,206.13652934393161,152.84187136714348,135.72964668661041,257.33657022899564,135.15514679136805,147.70476056544555,120.48743076563377,94.310944256425657,78.354062450419519,108.55485282044525]
["Time Weighted Mean Concentration (mg/l)",89.725236406971192,73.883704581747367,95.514630324567563,74.840115311984931,68.652785344832921,121.13684313174237,63.285135866131213,42.869901981204791,46.519573090738085,28.028134675996952,32.800955812496873,70.8724404885822]
["Total Load (kg)",195351989.53105536,137267380.66043004,205505102.79390103,80555725.592237592,45401377.364038102,77267269.052319422,17909147.278728701,27445292.948376846,12238772.866216753,12449791.092581457,20340109.348442931,88173069.528217182]
["Total Discharge          (cfs-days)",462125.31559026492,309954.53142352786,407725.12298611843,215552.90954859811,136802.53083334005,122798.73029165485,54192.868750412541,75992.931784960514,41542.818027780035,53988.317458363883,106167.49904859977,332189.98810413253]