{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Guidelines for Forms A-1 & A-2","Station ID Form A-1","Macroinvertabrate Data Form A-2","SQSH Habitat Form A-3"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Guidelines for Forms A-1 & A-2","index":0,"n_rows":60,"n_cols":2,"rows_kept":60,"merged":[[0,0,0,3],[2,0,2,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],[13,0,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[36,0,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],[49,0,49,3],[50,1,50,3],[51,1,51,3],[52,1,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]],"flags":["formulas_cached_only"]}
["Guidelines for filling out Macroinvertebrate Monitoring Worksheet Forms                A-1, A-2 & A-3"]
[]
["For questions, please contact Debbie Arnwine at 615-532-0703, or at Debbie.Arnwine@state.tn.us."]
[]
["1. Benthic sampling must be performed utilizing methods as identified in the Division’s Quality System Standard Operating Procedure for MACROINVERTEBRATE STREAM SURVEYS, October 2006.  The SOP may be viewed at: "]
["http://state.tn.us/environment/wpc/publications/bugsop06.pdf"]
["2. Biological stream monitoring utilizing the Semi-Quantitative Single Habitat (SQSH) Method must be conducted by a qualified biologist.  "]
["3. You must notify the appropriate Environmental Field Office at least two weeks prior to conducting the survey."]
["4. Monitoring locations must be consistent with your previously approved monitoring plan and provide appropriate habitat and be generally comparable.  If these locations do not have appropriate habitat, and are not generally comparable, then alternate sites must be chosen.  Prior to sampling at these alternate sites, they must be identified on a topographical map, and submitted to the EFO for approval."]
["5. All data must be submitted on this worksheet and submitted electronically to Debbie Arnwine at:"]
["Debbie.Arnwine@state.tn.us"]
["Please enter the data electronically into the yellow highlighted columns in the three worksheets (Forms A-1, A-s, and A-3) provided with this workbook (see tabs along the bottom).  The three forms are Station ID informations, Macroinvertebrate data, and SQSH Habitat information.  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 MACROINVERTEBRATE STREAM SURVEYS, October 2006 describes the data formats.  Please fill out the Station ID Form A-1 for each station, as well as the Macroinvertebrate Data Sheet Form A-2 and the SQSH Habitat Form A-3 info for each sample.  If you have additional comments, please submit as a separate attachment with your submittal."]
[]
["FORM A-1 STATION ID INFO  Column Definitions"]
["PROJECT NAME","Unique Project ID (ex. MS4 PROJECT)"]
["STATION ID","Unique Station Designator (ex: CLEAR008.6MG)"]
["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","Ex. Once"]
["BENTHMETH1","SQSH, specifically SQKICK or SQBANK "]
[]
["FORM A-2 MACROINVERTEBRATE DATA Column Definitions"]
["Station ID","Unique Station Designator (ex: CLEAR008.6MG)"]
["Log Number","Unique log # assigned by lab (ex: N0801001)"]
["HUC 8","Number (ex. 06010208)"]
["HUC 12","Number (ex. 060102080101)"]
["Sampler","Sampler Name"]
["Taxonomist","Taxonomist Name"]
["Number of Individuals in Subsample","Number of Individuals in Subsample"]
["Sample Date Format","00-00-0000"]
["Sample Type","SQSH, specifically SQKICK or SQBANK "]
["ECOREGION","Ecoregion 4 (Ex. 68A)"]
["Project Name","Unique Project ID (MS4 Monitoring)"]
[]
["FORM A-3 SQSH HABITAT Column Definitions"]
["MS4 Permittee Name:","ex. MS4 METRO"]
["Assessment Lab/Organization:","Actual Sampling Entity (ex. MS4 METRO)"]
["Stream type:","Riffle/Run or Glide/Pool"]
["HUC 12:","Number (ex. 060102080101)"]
["Ecoregion:","Ecoregion 4 (Ex. 68A)"]
["Station Id:","Unique Station Designator (ex: CLEAR008.6MG)"]
["Stream Name:","Stream Name"]
["Location:","Description  (ex. Barnett Bridge at confl  with White Ck)"]
["Assessor:","Assessor's name"]
["Date:","00-00-0000"]

{"sheet":"Station ID Form A-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":"Macroinvertabrate Data Form A-2","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"flags":["formulas_cached_only"]}
["MS4 Permittee Name:",null,"Station Id:"]
["Collection Lab/Organization:",null,"Log Number:"]
["ID Lab/Organization:",null,"Stream Name:"]
["Weather Conditions:",null,"Location:"]
["Ecoregion:",null,"Sample Type (SQKICK or SQBANK):"]
["Stream order:",null,"Sample Date:"]
["Sampler:",null,"Taxonomist:"]
["HUC 12:",null,"Number of individuals in sample:"]
[]
["Order","Family","Genus","Number"]

{"sheet":"SQSH Habitat Form A-3","index":3,"n_rows":20,"n_cols":4,"rows_kept":20,"flags":["formulas_cached_only"]}
["MS4 Permittee Name:",null,"Station Id:"]
["Assessment Lab/Organization:",null,"Stream Name:"]
["Stream type (Riffle/Run or Glide/Pool):",null,"Location:"]
["HUC 12:",null,"Assessor:"]
["Ecoregion:",null,"Date:"]
[]
["High Gradient Habitat Parameter","Score","Low Gradient Habitat Parameter","Score"]
["Epifaunal Substrate/Available Cover",null,"Epifaunal Substrate/Available Cover"]
["Embeddedness",null,"Pool Substrate Characterization"]
["Velocity/Depth Regime",null,"Pool Variability"]
["Sediment Deposition",null,"Sediment Deposition"]
["Channel Flow Status",null,"Channel Flow Status"]
["Channel Alteration",null,"Channel Alteration"]
["Frequency of Riffles",null,"Channel Sinuosity"]
["Bank Stability - Left Descending Bank",null,"Bank Stability - Left Descending Bank"]
["Bank Stability - Right Descending Bank",null,"Bank Stability - Right Descending Bank"]
["Vegetative Protection Left Descending Bank",null,"Vegetative Protection Left Descending Bank"]
["Vegetative Protection - Right Descending Bank",null,"Vegetative Protection - Right Descending Bank"]
["Riparion Vegetative Zone Width - Left Descending Bank",null,"Riparion Vegetative Zone Width - Left Descending Bank"]
["Riparion Vegetative Zone Width - Right Descending Bank",null,"Riparion Vegetative Zone Width - Right Descending Bank"]