{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Guidelines for Forms B-1 & B-2","Station ID Info Form B-1","WQ Bact Data Sheet Form B-2"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Guidelines for Forms B-1 & B-2","index":0,"n_rows":63,"n_cols":2,"rows_kept":63,"merged":[[0,0,0,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[15,0,15,1],[20,0,20,1],[27,0,27,3],[29,0,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[52,0,52,3],[53,1,53,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[62,1,62,3]],"flags":["formulas_cached_only"]}
["Guidelines for filling out Pathogen Monitoring Worksheet Forms                                           B-1 & B-2"]
[]
["For questions, please contact Linda Cartwright at 615-532-0704, or at Linda.Cartwright@state.tn.us. "]
["1. Pathogen stream sampling must be performed utilizing methods as identified in the Division’s Quality System Standard Operating Procedure for Chemical and Bacteriological Sampling of Surface Water, March 2004.  The SOP may be viewed at: "]
["http://state.tn.us/environment/wpc/publications/ChemSOP03QUAP.pdf"]
[" The procedure for flow measurement is in Protocol L and the pathogen procedure is in Protocol M."]
["2. Sampling shall include the collection of five samples and corresponding flow measurements, in a thirty-day period (to establish a geometric mean)."]
["3. Sampling must be performed within the months of June to September."]
["4. At least one pathogen sample per stream segment listed in the TMDL must be collected, with all segments in the MS4 jurisdiction sampled in a five-year period. "]
["5. Monitoring locations must be consistent with your previously approved monitoring plan and be generally comparable.  If these locations are not generally comparable, then alternate sites must be chosen.  "]
["6. All data must be submitted on this worksheet and submitted electronically to Linda Cartwright at:"]
["Linda.Cartwright@state.tn.us"]
["7. Please use the following unit specifications:"]
[]
["Test","Units"]
["Field Determinations:"]
["pH","pH units"]
["Conductivity","uMHO"]
["Dissolved Oxygen","mg/l"]
["Temperature","Celsius"]
["Env. Microbiology"]
["Total Coliform","CFU/100ml"]
["E. Coli","CFU/100ml"]
["Fecal Coliform","CFU/100ml"]
["Enterococcus","CFU/100ml"]
["Fecal Strep","CFU/100ml"]
[]
["Please enter the data electronically into the yellow highlighted columns in both Forms B-1 and B-2  provided with this workbook (see tabs along the bottom).  Please do not delete, rename, alter, or add any columns to these worksheets as the entire worksheet will be pasted directly into the division's database.  The Division’s Quality System Standard Operating Procedure for Chemical and Bacteriological Sampling of Surface Water, March 2004 describes the data formats.  Please fill out both the station ID info for each station and the WQ Bacteria Data Sheet info for each sample.  If you have additional comments, please submit as a separate attachment."]
[]
["FORM B-1 STATION ID INFO Column Definitions"]
["PROJECT NAME","Unique Project ID  (ex. MS4 PROJECT)"]
["STATION ID","Unique Station Designator  (ex: CLEAR008.6MG) ID can not be longer than 12 digits."]
["CURRENT FISCAL YEAR COLLECTED","State Fiscal Year - July 1 - June 30 (ex.  2007)"]
["RM","River Mile (ex. 8.6)"]
["NAME","Water Body Name (Ex. Clear Creek)"]
["STATION LOCATION","Description  (ex. Barnett Bridge at confl  with White Ck)"]
["COUNTYNAME","County Name"]
["STATE","TN"]
["STREAM ORDER","Stream Order (ex. 4)"]
["LATDECIDEG","In Decimal Degrees (ex. 36.1226)"]
["LONGDECIDEG","In Decimal Degrees (ex. -84.7954)"]
["HUC","HUC 8 Number (ex. 06010208)"]
["HUCNAME","HUC 8 Name (ex. Emory)"]
["USGSQUAD","Number - not Name (ex. 16SE)"]
["ECOIV","Ecoregion 4 (Ex. 68A)"]
["CHEMSAMPBY1","Actual Sampling Entity (ex. MS4 METRO)"]
["CHEMFREQ1","Ex. Once"]
["BACTFREQ1","Ex. Once"]
["BENSAMPBY1","Actual Sampling Entity (ex. MS4 METRO)"]
["BENTHFREQ1","Once"]
["BENTHMETH1","SQSH (Specifically SQKICK or SQBANK)"]
[]
["FORM B-2 WQ Bacteria Monitoring Data Sheet Column Definitions"]
["Station ID","Unique Station Designator (ex: CLEAR008.6MG)"]
["Activity ID","Unique log # assigned by lab. SOP states to put in a  P (ex. NP0801001 or METRP0801001.  ID can not be longer than 12 digits."]
["Date Format","00-00-0000"]
["Time Format","0000 - Military Time"]
["Project Name","Unique Project ID (MS4 Monitoring)"]
["Activity Type","Either a Sample or Trip QA/QC"]
["Activity Category","Routine Sample or a Field Replicate (Trip QC) every 10 samples."]
["Trip QC Type","Field or Trip Blank (if activity category is Trip QC)"]
["ChemSampBy","Sampling Organization Name (ex. MS4 Metro)"]
["Bact Analyzed By","Analyzing Organization Name"]

{"sheet":"Station ID Info Form B-1","index":1,"n_rows":5,"n_cols":42,"rows_kept":5,"merged":[[0,1,0,9],[1,1,1,9],[2,6,2,9]],"flags":["formulas_cached_only"]}
[null,"* Please do not delete, rename, alter, or add columns."]
[null,"** Please fill out only yellow highlighted columns."]
[null,"MS4 Name:"]
[]
["PROJECT ID:","PROJECT NAME:","PROJECT 1:","PROJECT 2:","PROJECT 3:","PROJECT 4 ANTID:","STATION ID:","OLD ID 1","OLD ID 2","CURRENT FISCAL YEAR COLLECTED","STATUS:","RM","NAME:","STATION LOCATION:","RESERVOIR:","PRIMARY TYPE:","COUNTYNAME","STATE:","STREAM ORDER:","LATDEG","LONGDEG","LATDECIDEG:","LONGDECIDEG:","HUC:","HUCNAME","WSGROUP","USGSQUAD","ECOIV:","EAC TRACK  NO","EAC","D1:","D2:","D3:","D4:","D5:","GRANT#:","CHEMSAMPBY1:","CHEMFREQ1:","BACTFREQ1:","BENSAMPBY1:","BENTHFREQ1:","BENTHMETH1:"]

{"sheet":"WQ Bact Data Sheet Form B-2","index":2,"n_rows":5,"n_cols":38,"rows_kept":5,"merged":[[0,1,0,6],[1,1,1,6],[2,2,2,6]],"flags":["formulas_cached_only"]}
[null,"* Please do not delete, rename, alter, or add columns."]
[null,"** Please fill out yellow highlighted columns."]
[null,"MS4 Name:"]
[]
["Project ID:","Station ID:","Activity ID:"," Date:","TIME","Project Name:","Activity Type:","Activity Category:","Trip QC Type:","Extra QC Info:","Replicate Number:","Medium:","Sample Coll Proced:","Cost Center:","ChemSampBy:","Bact Analyzed By:","pH  field:","pH units:","Field Conduct:","FC units:","DO  field:","DO units:","Flow:","Flow units:","Temp field:","Temp units:","Tot Col:","Tot Col units:","E Coli:","E Coil units:","E Coli-dilu:","E Coli-dilu units:","Fec Col:","Fec Col units:","Entero:","Entero units:","Fec Strep:","Fec Strep units:"]