{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Menu","Window"],"not_rendered":{"images":1,"macros":1,"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Menu","index":1,"n_rows":131,"n_cols":9,"rows_kept":131,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["Onondaga Lake Long-Term Water Quality Database"]
["View Output from Time Series Analysis & Load Calculations"]
["Onondaga County Department of Water Environment Protection"]
["amp_database_output_viewer_2011.xlsm",{"$nulls":4},"W. Walker",null,null,"Version: June 24, 2011"]
[]
["Select Chart:",null,"Select Site:",{"$nulls":3},"Select Variable:"]
{"$rows_empty":23}
["Linked to Output from the OLMP Water Quality Database"]
["Load Calculations are for 2010"]
["Time Series Analyses are for 2001-2010"]
["Files are stored at --->",{"$f":"outputdirectory","v":"http://www.wwwalker.net/onondaga/2010_database_output"}]
[]
[]
[{"$f":"TODAY()","v":"2011-07-01"}]
{"$rows_empty":8}
["Index"]
["File Directory","http://www.wwwalker.net/onondaga/2010_database_output"]
["Current Sheet",2,{"$f":"INDEX(B57:B74,sheet_no+1,1)","v":"timeseries"},null,{"$f":"INDEX(A57:A71,sheet_no+1)","v":"Time Series"}]
["Current Site",6,{"$f":"INDEX(A114:A133,site_no,1)","v":"METRO"}]
["Current Variable",8,{"$f":"INDEX(A77:A111,var_no,1)","v":"FCOLI"}]
["View GIf",true]
[]
[]
["Current Output File","c:\\0jobs\\onondaga_database\\2010_database_output\\histos\\byvar\\TP.gif"]
[]
[]
[{"$f":"INDEX(A57:A71,sheet_no+1,1)","v":"Time Series"},{"$f":"INDEX(B57:B71,sheet_no+1,1)","v":"timeseries"},{"$f":"INDEX(C57:C71,sheet_no+1,1)","v":1},{"$f":"INDEX(D57:D71,sheet_no+1,1)","v":1}]
["Title","Directory","Sites","Vars"]
["Load Calculations","loadcalcs",1,1,"loadcalcs"]
["Time Series","timeseries",1,1,"timeseries"]
["Samples - All Sites","samples/byvar",null,1,"samples\\byvar"]
["Samples - All Variables","samples/bysite",1,null,"samples\\bysite"]
["Trends - All Sites","trends/byvar",null,1,"trends\\byvar"]
["Trends - All Variables","trends/bysite",1,null,"trends\\bysite"]
["Seasonally Adjusted Trends - All Sites","adjtrends/byvar",null,1,"adjtrends\\byvar"]
["Seasonally Adjusted Trends - All Variables","adjtrends/bysite",1,null,"adjtrends\\bysite"]
["Outliers - All Sites","outliers/byvar",null,1,"outliers\\byvar"]
["Outliers - All Variables","outliers/bysite",1,null,"outliers\\bysite"]
["Histograms - All Sites","histos/byvar",null,1,"histos\\byvar"]
["Histograms - All Variables","histos/bysite",1,null,"histos\\bysite"]
[]
[]
[]
[]
[]
[]
["Variables","Description",null,null,"Menu"]
["ALK","alkalinity to pH 4.5 ( mg/l)",null,null,{"$f":"LEFT(A77&\"       \",10)&\" - \"&B77","v":"ALK        - alkalinity to pH 4.5 ( mg/l)"}]
["BOD5","5-day biochemical oxygen demand ( mg/l)",null,null,"BOD5       - 5-day biochemical oxygen demand ( mg/l)"]
["CA","calcium ( mg/l)",null,null,"CA        - calcium ( mg/l)"]
["CHLA","chlorophyll-a ( ug/l)",null,null,"CHLA       - chlorophyll-a ( ug/l)"]
["CL","chloride ( mg/l)",null,null,"CL        - chloride ( mg/l)"]
["COND","conductivity  (field) ( umHos/cm)",null,null,"COND       - conductivity  (field) ( umHos/cm)"]
["DO_F","dissolved oxygen - meter (field) ( mg/l)",null,null,"DO_F       - dissolved oxygen - meter (field) ( mg/l)"]
["FCOLI","fecal coliform (MF method) ( #/100 ml)",null,null,"FCOLI      - fecal coliform (MF method) ( #/100 ml)"]
["FE","total iron ( mg/l)",null,null,"FE        - total iron ( mg/l)"]
["HARD","hardness ( mg/l)",null,null,"HARD       - hardness ( mg/l)"]
["MG","magnesium ( mg/l)",null,null,"MG        - magnesium ( mg/l)"]
["MN","manganese ( mg/l)",null,null,"MN        - manganese ( mg/l)"]
["NA","sodium ( mg/l)",null,null,"NA        - sodium ( mg/l)"]
["NH3N","ammonia nitrogen as n ( mg/l)",null,null,"NH3N       - ammonia nitrogen as n ( mg/l)"]
["NO2N","nitrite nitrogen as n ( mg/l)",null,null,"NO2N       - nitrite nitrogen as n ( mg/l)"]
["NO3N","nitrate nitrogen as n ( mg/l)",null,null,"NO3N       - nitrate nitrogen as n ( mg/l)"]
["ORGN","organic nitrogen as n ( mg/l)",null,null,"ORGN       - organic nitrogen as n ( mg/l)"]
["PH_F","pH measured in field ( -log [h])",null,null,"PH_F       - pH measured in field ( -log [h])"]
["PHAEO","phaeophytin pigments ( ug/l)",null,null,"PHAEO      - phaeophytin pigments ( ug/l)"]
["SECCHI","secchi depth ( meters)",null,null,"SECCHI     - secchi depth ( meters)"]
["SIO2","silicon dioxide ( mg/l)",null,null,"SIO2       - silicon dioxide ( mg/l)"]
["SO4","sulfate ( mg/l)",null,null,"SO4        - sulfate ( mg/l)"]
["SRP","soluble reactive p (mg/l)",null,null,"SRP        - soluble reactive p (mg/l)"]
["TDS","total dissolved solids (180 C) ( mg/l)",null,null,"TDS        - total dissolved solids (180 C) ( mg/l)"]
["TEMP","water temperature ( deg C)",null,null,"TEMP       - water temperature ( deg C)"]
["TIC","total inorganic carbon ( mg/l)",null,null,"TIC        - total inorganic carbon ( mg/l)"]
["TKN","total kjeldahl nitrogen ( mg/l)",null,null,"TKN        - total kjeldahl nitrogen ( mg/l)"]
["TOC","total organic carbon ( mg/l)",null,null,"TOC        - total organic carbon ( mg/l)"]
["TOC_F","filtered total organic carbon ( mg/l)",null,null,"TOC_F      - filtered total organic carbon ( mg/l)"]
["TP","total phosphorus as p ( mg/l)",null,null,"TP        - total phosphorus as p ( mg/l)"]
["TS","total solids ( mg/l)",null,null,"TS        - total solids ( mg/l)"]
["TSS","total suspended solids ( mg/l)",null,null,"TSS        - total suspended solids ( mg/l)"]
["VSS","volatile suspended solids ( mg/l)",null,null,"VSS        - volatile suspended solids ( mg/l)"]
["ZN","Zinc (mg/l)",null,null,"ZN        - Zinc (mg/l)"]
[]
[]
["Sites","Description",null,null,"Menu"]
["BYPASS","Metro STP Bypass",null,null,{"$f":"LEFT(A114&\"       \",10)&\" - \"&B114","v":"BYPASS     - Metro STP Bypass"}]
["DORWIN","Onondaga Ck @ Dorwin",null,null,"DORWIN     - Onondaga Ck @ Dorwin"]
["EFLUME","Allied Chemical Discharge",null,null,"EFLUME     - Allied Chemical Discharge"]
["HIAWATHA","Harbor Brook @ Hiawatha",null,null,"HIAWATHA   - Harbor Brook @ Hiawatha"]
["KIRKPAT","Onondaga Creek @ Kirkpatrick",null,null,"KIRKPAT    - Onondaga Creek @ Kirkpatrick"]
["METRO","Metro STP Effluent",null,null,"METRO      - Metro STP Effluent"]
["NORTH_L","Lake North",null,null,"NORTH_L    - Lake North"]
["NORTH_U","Lake North",null,null,"NORTH_U    - Lake North"]
["OUTLET_U","Lake Outlet Load/ South UL",null,null,"OUTLET_U   - Lake Outlet Load/ South UL"]
["OUTLET12","Lake Outlet 12 Ft Depth",null,null,"OUTLET12   - Lake Outlet 12 Ft Depth"]
["OUTLET2","Lake Outlet 2 Ft Depth",null,null,"OUTLET2    - Lake Outlet 2 Ft Depth"]
["PARK","Ley Creek @ Park",null,null,"PARK       - Ley Creek @ Park"]
["RT48","Ninemile Creek @ RT48",null,null,"RT48       - Ninemile Creek @ RT48"]
["SOUTH_L","Lake South",null,null,"SOUTH_L    - Lake South"]
["SOUTH_U","Lake South",null,null,"SOUTH_U    - Lake South"]
["SPENCER","Onondaga Ck @ Spencer",null,null,"SPENCER    - Onondaga Ck @ Spencer"]
["TRIB5A","Crucible Steel / Trib 5A",null,null,"TRIB5A     - Crucible Steel / Trib 5A"]
["VELASKO","Harbor Brook @ Velasko",null,null,"VELASKO    - Harbor Brook @ Velasko"]

{"sheet":"Window","index":2,"n_rows":2,"n_cols":14,"rows_kept":2,"hidden":true}
[]
[null,null,"Format:",{"$f":"Menu!E47","v":"Time Series"},{"$nulls":3},"Site:",{"$f":"sitename","v":"METRO"},null,"Var:",{"$f":"variablename","v":"FCOLI"},"File:",{"$f":"+LOWER(outfile)","v":"c:\\0jobs\\onondaga_database\\2010_database_output\\histos\\byvar\\tp.gif"}]