{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Calculate Discharge","Rating Curve","Discharge Event 1","Discharge Event 2","Discharge Event 3","Discharge Event 4","Discharge Event 5","Discharge Event 6","Blank Discharge Form"],"not_rendered":{"charts":2,"images":6,"macros":1,"external_links":0,"defined_names":302,"comments":9,"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":"Instructions","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Introduction:"]
[null,"This spreadsheet is designed to calculate discharge from individual measurements and to combine those measurements into what is called a discharge rating curve.  This rating curve is used to convert a continuously measured record of stream depth into a continuous record of stream discharge.  While it is relatively easy to measure stream depth continuously using an installed sensor station, the direct continuous measurement of discharge is much more complicated (and expensive).  The total discharge, however, is a much more important value in measuring stream quality and quantification of transport of pollutants and other substances."]
[null,"The rating curve calculated by this spreadsheet is a simple linear curve."]
[null,"To use this spreadsheet, you must use it in Microsoft Excel 2007 or later.  The calculations may not be correct in Microsoft Excel 2003 or earlier."]
[null,"The primary data this spreadsheet generates is the \"Rating Equation - Discharge to Stage\", which can be found in green in the \"Rating Curve\" sheet."]
[null,"After a rating curve has been developed, the discharge at any given stage can easily be calculated with the \"Calculate Discharge\" sheet."]
[null,"Detailed instructions on how to use each sheet are below and along with the worksheets you will be working in."]
[null,"Notes, identified as little red tabs in the worksheet, will help you to know what data to input. Equation comments, identified as little green tabs in the worksheet, will help you to know the equation being used to calculate the solution within that cell."]
[]
[null,"Starting-off by Adding New Discharge Data for Ratings:"]
[null,"1.  If you see a security warning, you must click that you trust this document to allow macros to run on this workbook.  Without macros, you will not be able to easily add new ratings."]
[null,"2.  Click on the \"Rating Curve\" sheet."]
[]
[null,"Explanations of Calculations:"]
[null,"Although they cannot be modified, you should be able to see the formulas for all calculations in each worksheet.  For the cross section and velocity profiles, a \"segment\" is defined as the space between two measurement points or between the first or last measurement point and the bank."]
[null,"* Stream Wetted Width - The distance between the REW and LEW.  This may be measured or, if measurements are not safely possible, looked up from the StageToAreaPredictor spreadsheet."]
[null,"* Wetted Cross Sectional Area - The total area of water in one cross section of the stream.  This may be measured or, if measurements are not safely possible, looked up from the StageToAreaPredictor spreadsheet."]
[null,"* Segment Width - The distance between two measurement points"]
[null,"* Segment Area - Half the distance to the next measurement point plus half the distance to the previous measurment point multiplied by the measured depth"]
[null,"* Segment Discharge - The segment area multiplied by the velocity measured in that segment, if velocity was measured"]
[null,"* Measured Wetted Cross Sectional Area - The sum of all segment areas"]
[null,"* Velocity/Area Total Discharge - The sum of all of the segment discharges"]
[null,"* Mean Travel Time - The average of all travel times for a neutrally buoyant object across the same distance."]
[null,"* Mean Transect Velocity - The average velocity through the whole transect, calculated as the distance traveled by a neutrally buoyant object going through the transect divided by its mean travel time."]
[null,"* Neutrally Buoyant Object Total Discharge - The mean transect velocity multiplied by the cross sectional area (either measured or looked-up)."]
[]
[null,"Other Notes:"]
[null,"Expect that there might be a LOT of variability in your rating curve."]
[null,"You must allow macros to run for everything to work correctly."]
[null,"The new discharge forms are created by copying a hidden sheet called \"Blank Discharge Form.\"  You should never change that worksheet."]
[null,"There is no password to unprotect sheets, but, PLEASE do not alter the formulas.  Do not alter the macros, either."]
[null,"The new discharge forms are created by copying a hidden sheet called \"Blank Discharge Form.\"  This is done via a VBA macro which also links the results from the new sheet to the \"Rating Curve\" sheet."]
[null,"If at any point your sensor moves (even by a very small amount), you MUST recalculate the \"Offset between Sensor Depth and Stage.\"  This can be calculated by taking a very careful measurement of the stage (staff gauge height) and checking the depth reading on the sensor at exactly the same time.  The stage minus the sensor depth is your new offset.  Enter this new value in the cell labeled \"Offset between Sensor Depth and Stage\" on the \"Rating Curve\" worksheet."]
[null,"If at any point your staff gauge moves, you MUST recalculate the offset between the current location of the staff gauge and the new location of the staff gauge.  If you do not carefully do this, any measurements taken prior to the movement of your staff gauge will be unusable!  You can get a good estimate of the offset between the old and new locations of the staff gauge by checking the \"Offset between Sensor Depth and Stage\" immediately before and after moving the staff gauge.  It would be better, however, to re-survey your transect.  After moving the staff gauge, you must apply the offset between the old staff gauge height and the new staff gauge height to every rating point taken before the movement.  That is, you must manually open every \"Discharge Day X\" sheet with data entered before the staff gauge was moved and subtract the offset between the old staff gauge location and the new staff gauge location from the measureed stage height on that \"Discharge Day X\" sheet.  Because this can be difficult, never move your staff gauge without a very serious reason to do so!"]

{"sheet":"Calculate Discharge","index":1,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,15,1,16],[2,15,3,16],[1,1,19,2],[19,3,31,13]]}
[null,"Discharge Calculator"]
[null,"After Rating Curve Development:\n1) Enter either your measured staff gauge height (stage) or the sensor depth recorded by an installed depth sensor.\n-- Note: If you use the depth recorded by an installed depth sensor, you must also enter the offset between the sensor depth and the official stage on the staff gauge.\n2) After entering data, the plot should show rating measurements you have taken in the past along with a star showing where the input stage falls on the line relative to those points.                                                                                         When Using:\n1) You can use the rating curve to infer discharge based on depth readings being provided by your sensor station.                                                                                  2) This data can be used for knowing discharge at distinct points in time or over a period of time based on the real-time sensor station data.\n3) Remember to do supplemental discharge event measurements from time-to-time to maintain an accurate curve.\n4) Monitor and check depth probe at sensor station when visiting to ensure accurate data collecting.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Discharge Calculator Data Input"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*NOTE: The sensor-to-stage offset value WILL change if the sensor is moved or the sensor drifts over time; the stage (or depth on staff gauge) should always be considered to be the primary depth to use for rating."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff Gauge Height (m):",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," --- OR ---"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recorded Sensor Depth (mm):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensor-to-Stage Offset (m):"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage Used (m):",{"$f":"IF(StaffGaugeHeight<>\"\",StaffGaugeHeight,SensorDepth/1000+SensorOffset)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated Discharge (m3)",{"$f":"RatingSlope*StageHeightForEstimate+RatingIntercept","v":0.64278052774855343}]
[]
[]
[null,null,null,"Note For Fixing Appearance of Graph: Sizing and Layout of the graph is left to auto since different sites will produce different discharges, heights and depths. However, by staying on this automatic growth pattern, the graph can sometimes become distorted where datapoints are clumped together while the rest of the graph is open. To fix this, follow these steps:\n1 - Unprotect the sheet via the \"Review\" tab and selecting \"Unprotect Sheet\".                                                                                                                 2 - Left-click on the x-axis where the number labels are to select the axis then right-click the axis.                                                                                  3 - In the dialog box, select \"Format Axis\".                                                                                                                                                                             4 - In the new window, take note of \"Minimum\" and \"Maximum\" where you can decide the extent of the x-axis being shown in the graph.\n5 - Choose the \"Fixed\" option under these categories and type in the desired range for each extent.                                                                              6 - Hit Close once you have the desired x-axis extent; repeat these steps for the y-axis.                                                                                                   7 - Once the graph displays the datapoints and trendline clearly, reprotect the sheet via the \"Review\" tab and selecting \"Protect Sheet\"."]

{"sheet":"Rating Curve","index":2,"n_rows":40,"n_cols":28,"rows_kept":40,"cut":false,"hidden":false,"merged":[[22,1,34,7],[34,8,38,19],[39,8,48,19],[0,1,0,6],[4,13,4,19],[7,13,7,19],[1,13,1,18],[1,1,21,7],[1,24,3,24],[1,21,3,21],[0,21,0,27],[1,25,3,25],[1,26,3,26],[1,27,3,27],[1,22,3,22],[1,23,3,23]]}
[null,"Discharge Event Entry & Rating Curve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating Curve Data"]
[null,"Starting-off Tutorial:                                                                              1)  Click the button to \"Add A New Discharge Measurement.\"\n2) After about a second, you will be directed to a new sheet named \"Discharge Event X.\"  (Where \"X\" is one number higher than the number of dishcarge measurements already recorded in this spreadsheet.)\n3)  9 Warning dialog boxes will come up saying how there are already existing worksheets using similar names, say yes to all of the warnings.\nAfter Data Entry Into \"Discharge Event X\":\n1) The new results should appear on your curve.\n2) If you see errors or strange values in this sheet, chances are very high you made a mistake in entering data OR you clicked the \"Add A New Discharge Measurement\" button too many times.\n3) Make sure that all results are entered correctly and that you do not have any extra un-used sheets.\n4) Data in the \"Discharge Event X\" sheets can be corrected easily by clicking on the tabs and checking all values in the WHITE boxes.\n5) There will need to be a minimum of 5 to 7 Discharge Events ranging from baseflow to peak storm-flow that provide different water depths and velocities.\n6) Once you have a functioning rating curve, you can then click on to the \"Calculate Discharge\" tab.                                                    ",null,null,null,null,null,null,null,null,null,null,null,"Average Offset between Sensor Depth and Stage:",null,null,null,null,null,{"$f":"AVERAGE(Z5:Z17)-AVERAGE(AA5:AA17)","v":0.11163333333333331},null,"Event Number","Date","Start Time","End Time","Measured Stream Stage (m)","Recorded Sensor Depth (m)","Total Discharge (m3/s)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating Equation - Discharge to Stage",null,null,null,null,null,null,null,"Discharge Event 1",{"$f":"'Discharge Event 1'!Date","v":"2017-07-13"},{"$f":"'Discharge Event 1'!StartTime","v":"10:30:00"},{"$f":"'Discharge Event 1'!StopTime","v":"11:00:00"},{"$f":"'Discharge Event 1'!StaffHeight","v":0.27500000000000002},{"$f":"'Discharge Event 1'!SensorDepth / 1000","v":0.15330000000000002},{"$f":"'Discharge Event 1'!Discharge","v":7.4500000000000009E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Discharge = ","(",{"$f":"SLOPE('Rating Curve'!RatingDischarges,'Rating Curve'!RatingStages)","v":0.84293290373487639},"x Stage",")",{"$f":"IF(T6>=0,\"+\",\"\")","v":""},{"$f":"INTERCEPT('Rating Curve'!RatingDischarges,'Rating Curve'!RatingStages)","v":-0.20015237598632296},null,"Discharge Event 2",{"$f":"'Discharge Event 2'!Date","v":"2017-08-21"},{"$f":"'Discharge Event 2'!StartTime","v":"14:25:00"},{"$f":"'Discharge Event 2'!StopTime","v":"14:53:00"},{"$f":"'Discharge Event 2'!StaffHeight","v":0.24},{"$f":"'Discharge Event 2'!SensorDepth / 1000","v":0.15730000000000002},{"$f":"'Discharge Event 2'!Discharge","v":5.3300000000000005E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discharge Event 3",{"$f":"'Discharge Event 3'!Date","v":"2018-01-23"},{"$f":"'Discharge Event 3'!StartTime","v":"09:50:00"},{"$f":"'Discharge Event 3'!StopTime","v":"10:23:00"},{"$f":"'Discharge Event 3'!StaffHeight","v":0.39},{"$f":"'Discharge Event 3'!SensorDepth / 1000","v":0.27729999999999999},{"$f":"'Discharge Event 3'!Discharge","v":0.13294599999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating Equation - Discharge to Stage plus Sensor Depth Offset",null,null,null,null,null,null,null,"Discharge Event 4",{"$f":"'Discharge Event 4'!Date","v":"2018-01-23"},{"$f":"'Discharge Event 4'!StartTime","v":"09:47:00"},{"$f":"'Discharge Event 4'!StopTime","v":"10:15:00"},{"$f":"'Discharge Event 4'!StaffHeight","v":0.39500000000000002},{"$f":"'Discharge Event 4'!SensorDepth / 1000","v":0.27729999999999999},{"$f":"'Discharge Event 4'!Discharge","v":0.16996250000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Discharge = ","(",{"$f":"SLOPE('Rating Curve'!RatingDischarges,'Rating Curve'!RatingStages)","v":0.84293290373487639},"x SensorDepth",")",{"$f":"IF(T9>=0,\"+\",\"\")","v":""},{"$f":"IF(T2=\"\",\"???\", INTERCEPT('Rating Curve'!RatingDischarges,'Rating Curve'!RatingStages) +T2)","v":-8.8519042652989655E-2},null,"Discharge Event 5",{"$f":"'Discharge Event 5'!Date","v":"2018-01-23"},{"$f":"'Discharge Event 5'!StartTime","v":"11:05:00"},{"$f":"'Discharge Event 5'!StopTime","v":"11:45:00"},{"$f":"'Discharge Event 5'!StaffHeight","v":0.45},{"$f":"'Discharge Event 5'!SensorDepth / 1000","v":0.33900000000000002},{"$f":"'Discharge Event 5'!Discharge","v":0.14289000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discharge Event 6",{"$f":"'Discharge Event 6'!Date","v":"2018-01-23"},{"$f":"'Discharge Event 6'!StartTime","v":"11:05:00"},{"$f":"'Discharge Event 6'!StopTime","v":"11:40:00"},{"$f":"'Discharge Event 6'!StaffHeight","v":0.37},{"$f":"'Discharge Event 6'!SensorDepth / 1000","v":0.246},{"$f":"'Discharge Event 6'!Discharge","v":0.127525}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note For Deleting Discharge Events: If you have made major errors and want to remove a discharge measurement sheet, you must do the following (this should be considered only as a last resort!)\n    1 - Delete the offending worksheet by right-clicking on the worksheet tab on the bottom and selecting \"delete.\"\n    2 - Unprotect the \"Rating Curve\" worksheet by clicking \"Review\" in the ribbon and then \"Unprotect Sheet.\"  There is no password.\n    3 - Delete the offending line in the rating table, which should now be filled with \"#REF\" by selecting those cells, right clicking, and selecting delete.  Select \"Shift cells UP\" when asked.\n    4 - REPROTECT the \"Rating Curve\" worksheet by clicking \"Review\" in the ribbon and then \"Protect Sheet.\"  Use the default options and do not set a password."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Note For Getting the Discharge Rating Curve Equation: When you are ready to fill out the Load Calculator:\n1 - Take note of the green equation under the title \"Rating Equation - Discharge to Stage\".\n2 - This will be the equation you will manually enter into the \"Load Calculator\" workbook to help calculate discharge.\n3 - Be sure to either fill out or delete any blank \"Discharge Event\" worksheets, otherwise the equation will not appear. \n4 - ALL Discharge Events require a staff guage height and a sensor depth in order for the offset to properly calculate.                          "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Note For Fixing Appearance of Graph: Sizing and Layout of the graph is left to auto since different sites will produce different discharges, heights and depths. However, by staying on this automatic growth pattern, the graph can sometimes become distorted where datapoints are clumped together while the rest of the graph is open. To fix this, follow these steps:\n1 - Unprotect the sheet via the \"Review\" tab and selecting \"Unprotect Sheet\".\n2 - Left-click on the x-axis where the number labels are to select the axis then right-click the axis.\n3 - In the dialog box, select \"Format Axis\".\n4 - In the new window, take note of \"Minimum\" and \"Maximum\" where you can decide the extent of the x-axis being shown in the graph.\n5 - Choose the \"Fixed\" option under these categories and type in the desired range for each extent.\n6 - Hit Close once you have the desired x-axis extent; repeat these steps for the y-axis.\n7 - Once the graph displays the datapoints and trendline clearly, reprotect the sheet via the \"Review\" tab and selecting \"Protect Sheet\"."]

{"sheet":"Discharge Event 1","index":3,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,7,0,11],[0,13,1,15],[0,18,0,20],[1,1,21,2],[1,6,3,6],[1,18,1,20],[4,13,4,16],[6,13,6,14],[22,1,44,2],[22,13,22,14],[24,13,24,15],[25,13,25,14],[26,13,26,14],[33,13,33,16],[7,13,7,14],[8,13,8,14],[10,13,18,13],[17,4,26,4],[21,13,21,14],[27,13,27,16],[28,3,28,4],[28,13,28,15],[29,13,29,14],[31,13,31,14],[64,3,65,5],[66,3,88,5],[34,13,34,16],[36,13,45,13],[47,13,47,14],[49,13,49,15],[50,13,50,14],[52,13,52,14]]}
[null,"Discharge Event Entry Form",null,"Basic Metadata",null,null,null,"Cross Section and Velocity Measurements",null,null,null,null,null,"Alternative Data Inputs to Cross Section and Velocity Measurements",null,null,null,null,"Segment Calculations"]
[null,"Starting-off Tutorial:\n1) In the new \"Discharge Day X\" sheet, enter as much data from the \"Stream Discharge Data\" sheet into the WHITE boxes.\n-- Note: You should not be able to modify any of the grey or blue boxes.\n_____\n2) Completely fill out the \"Basic Metadata\" section.\n-- Note: Be sure to enter all times in EASTERN STANDARD TIME (EST; UTC-5); if the time recorded on your \"Stream Discharge Data\" sheet was in Eastern Daylight Time (EDT; UTC-4), you should subtract one hour from that time.\n_____ \n3) Fill out the \"Cross Section and Velocity Measurments\" section with measurements only from right edge of water to left edge of water on your \"Stream Dischrage Data\" sheet.\n-- Note: Measurements between the water edges and the bank pins are not used to calculate discharge.\n_____\n4) If you measured a cross section, fill out [Points of Note], [Distance], [Water Depth] and [Comments] in the \"Cross Section and Velocity Measurements\" section.                                                                                      ",null,null,null,null,"Point ",null,null,null,null,null,null,null,null,null,null,null,"(Calculations from Cross Section and Velocity Measurements)"]
[null,null,null,"Measurement Completed By:","Bressler, Johnson, Hicks, Hachadoorian, Chambers"]
[null,null,null,null,null,null,null,"Points of note:","Distance (m)","Water Depth (m)","Velocity (m/s)","Comment",null,null,null,null,null,null,"Segment Width (m)","Segment Area (m2)","Segment Discharge (m3/s)",null,"Possible Notes"]
[null,null,null,"Stream Name:","Rocky Run",null,1,"LEW",3,0,0,null,null,"Neutral Buoyant Object Measurement",null,null,null,null,{"$f":"IF(I5=\"\",\"\",  IF( OR(H5=\"REW\",H5=\"LEW\"),     IF(I6=\"\", (I5-I4)/2, (I6-I5)/2),    ( (I5-I4)/2 + (I6-I5)/2) )  )","v":0.25},{"$f":"IF(I5=\"\",\"\",S5*J5)","v":0},{"$f":"IF(K5=\"\",\"\",T5*K5)","v":0},null,"REW"]
[null,null,null,"Location:","Upper Rocky, DS of Hwy 200",null,2,null,3.5,7.0000000000000007E-2,0,null,null,"1. Distance",null,null,null,null,{"$f":"IF(I6=\"\",\"\",  IF( OR(H6=\"REW\",H6=\"LEW\"),     IF(I7=\"\", (I6-I5)/2, (I7-I6)/2),    ( (I6-I5)/2 + (I7-I6)/2) )  )","v":0.44999999999999996},3.15E-2,0,null,"LEW"]
[null,null,null,"SiteID:","ROCK_US3",null,3,null,3.9,0.14000000000000001,0,null,null,"Start of float to Transect (m):",null,null,null,null,{"$f":"IF(I7=\"\",\"\",  IF( OR(H7=\"REW\",H7=\"LEW\"),     IF(I8=\"\", (I7-I6)/2, (I8-I7)/2),    ( (I7-I6)/2 + (I8-I7)/2) )  )","v":0.39999999999999991},5.5999999999999994E-2,0,null,"RPIN"]
[null,null,null,"Station Latitude / Longitude:","39.816792, -75.550789",null,4,null,4.3,0.24,0.01,"estimate",null,"Transect to End of float (m):",null,null,null,null,0.40000000000000013,9.600000000000003E-2,9.6000000000000035E-4,null,"LPIN"]
[null,null,null,"Date:","2017-07-13",null,5,null,4.7,0.21,0.01,"estimate",null,"TOTAL Float Distance (m):",null,{"$f":"P7+P8","v":0},null,null,0.30000000000000027,6.3000000000000056E-2,6.3000000000000057E-4,null,"RTOB"]
[null,null,null,"Start Time in EST:","10:30:00",null,6,null,4.9000000000000004,0.2,0.01,null,null,"2. Time",null,null,null,null,0.25,0.05,5.0000000000000001E-4,null,"LTOB"]
[null,null,null,"Stop Time in EST:","11:00:00",null,7,null,5.2,0.43,0.01,"estimate",null,"Travel Time (sec):\nMeasure at least 5 Times","Time 1:",null,null,null,0.34999999999999964,0.15049999999999986,1.5049999999999985E-3]
[null,null,null,"Staff Gauge Height (m):",0.27500000000000002,null,8,null,5.6,0.44,0.01,"estimate",null,null,"Time 2:",null,null,null,0.35000000000000009,0.15400000000000005,1.5400000000000006E-3]
[null,null,null,"Recorded Sensor Depth (mm):",153.30000000000001,null,9,null,5.9,0.44,0.01,null,null,null,"Time 3:",null,null,null,0.25,0.11,1.1000000000000001E-3]
[null,null,null,"Staff Gage/Sensor Offset (m):",0.1217,null,10,null,6.1,0.33,0.01,"estimate",null,null,"Time 4:",null,null,null,0.25,8.2500000000000004E-2,8.250000000000001E-4]
[null,null,null,"Velocity Meter (if applicable):","Marsh McBirney",null,11,null,6.4,0.13,0.01,null,null,null,"Time 5:",null,null,null,0.30000000000000027,3.9000000000000035E-2,3.9000000000000037E-4]
[null,null,null,"Calibration Date of Velocity Meter:",null,null,12,null,6.7,0.14000000000000001,0,null,null,null,"Time 6:",null,null,null,0.44999999999999973,6.2999999999999973E-2,0]
[null,null,null,null,null,null,13,null,7.3,0.12,0,null,null,null,"Time 7:",null,null,null,0.31000000000000005,3.7200000000000004E-2,0]
[null,null,null,"Other Notes:",null,null,14,"REW",7.32,0,0,null,null,null,"Time 8:",null,null,null,1.0000000000000231E-2,0,0]
[null,null,null,null,null,null,15,null,null,null,null,null,null,null,"Time 9:",null,null,null,"","",""]
[null,null,null,null,null,null,16,null,null,null,null,null,null,null,"Time 10:",null,null,null,"","",""]
[null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,18,null,null,null,null,null,null,"Mean Travel Time (sec):",null,{"$f":"IF(NumberTravelTimes > 0, AVERAGE(TravelTimes), 0)","v":0},null,null,"","",""]
[null,"_____\n5) If you measured velocities with a velocity meter, also fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.  \n______ \n6) If you used a neutrally buoyant object, instead, to measure velocity, fill out [Float Distance] and [Time] in the \"Neutral Buoyant Object Measurement\" section. \n______\n7) If you measured velocities with a hand-held flow meter, instead, fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.\n______\n8) If you did NOT measure any cross section data, fill out the [Predicted Stream Wetted Width] and [Predicted Wetted Cross Sectional Area] under the appropriate section where you took \"Alternative Data Inputs to Cross Section and Velocity Measurements\" \n-- Note: Data found on the*StageToAreaPredictor* spreadsheet\n______\n9) After you have finished entering your data, go back to the \"Rating Curve\" sheet.",null,null,null,null,19,null,null,null,null,null,null,"Mean Transect Velocity (m/sec):",null,{"$f":"FloatDistance/MeanTravelTime*0.76","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,20,null,null,null,null,null,null,"3. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,21,null,null,null,null,null,null,"Measured Values from Cross Section",null,null,null,null,"","",""]
[null,null,null,null,null,null,22,null,null,null,null,null,null,"Stream Wetted Width (m):",null,{"$f":"MeasuredWettedWidth","v":4.32},null,null,"","",""]
[null,null,null,null,null,null,23,null,null,null,null,null,null,"Cross Sectional Area (m2):",null,{"$f":"MeasuredCrossSectionalArea","v":0.93269999999999997},null,null,"","",""]
[null,null,null,null,null,null,24,null,null,null,null,null,null,"--- OR ---",null,null,null,null,"","",""]
[null,null,null,"Results",null,null,25,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,"Calculated Total Discharge (m3/s):",{"$f":"IF(HFMDischarge > 0, HFMDischarge, IF(AreaVelocityDischarge>0, AreaVelocityDischarge, NBODischarge))","v":7.4500000000000009E-3},null,26,null,null,null,null,null,null," Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,27,null,null,null,null,null,null,"4. Result",null,null,null,null,"","",""]
[null,null,null,"Stream Wetted Width (m):",{"$f":"IF(WettedWidthFromSAP > 0, WettedWidthFromSAP, IF(MeasuredWettedWidth > 0, MeasuredWettedWidth, WettedWidthFromStage))","v":4.32},null,28,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"IF(CrossSectionalAreaFromStage>0, CrossSectionalAreaFromStage*MeanVelocity, CrossSectionalArea*MeanVelocity)","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,"Stream Cross Sectional Area (m2):",{"$f":"IF(CrossSectionalAreaFromSAP > 0, CrossSectionalAreaFromSAP, IF(MeasuredCrossSectionalArea > 0, MeasuredCrossSectionalArea, CrossSectionalAreaFromStage))","v":0.93269999999999997},null,30,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,31,null,null,null,null,null,null,"Handheld Flow Meter Measurement",null,null,null,null,"","",""]
[null,null,null,null,null,null,32,null,null,null,null,null,null,"1. Velocity",null,null,null,null,"","",""]
[null,null,null,null,null,null,33,null,null,null,null,null,null,"Flow Velocity (m/sec):                         \nMeasure at least 5 Times","Velocity 1:",null,null,null,"","",""]
[null,null,null,null,null,null,34,null,null,null,null,null,null,null,"Velocity 2:",null,null,null,"","",""]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,"Velocity 3:",null,null,null,"","",""]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,"Velocity 4:",null,null,null,"","",""]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,"Velocity 5:",null,null,null,"","",""]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,"Velocity 6:",null,null,null,"","",""]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,"Velocity 7:",null,null,null,"","",""]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,"Velocity 8:",null,null,null,"","",""]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,"Velocity 9:",null,null,null,"","",""]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,"Velocity 10:",null,null,null,"","",""]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,44,null,null,null,null,null,null,"Mean Flow Meter Velocity (m/sec):",null,{"$f":"IF(NumberFlowTimes>0,AVERAGE(FlowTimes),0)","v":0},null,null,"","",""]
[null,null,null,null,null,null,45,null,null,null,null,null,null,"2. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,46,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,null,null,null,47,null,null,null,null,null,null,"Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,48,null,null,null,null,null,null,"3. Result",null,null,null,null,"","",""]
[null,null,null,null,null,null,49,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"MeanFlowMeterVelocity*CrossSectionalAreaFromSAP","v":0},null,null,"","",""]
[null,null,null,null,null,null,50,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,null,{"$f":"SUM(S$5:$S$54)","v":4.32},{"$f":"SUM(T$5:$T$54)","v":0.93269999999999997},{"$f":"SUM(U$5:$U$54)","v":7.4500000000000009E-3},"Total of Segments:"]

{"sheet":"Discharge Event 2","index":4,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,7,0,11],[0,13,1,15],[0,18,0,20],[1,1,21,2],[1,6,3,6],[1,18,1,20],[4,13,4,16],[6,13,6,14],[22,1,44,2],[22,13,22,14],[24,13,24,15],[25,13,25,14],[26,13,26,14],[33,13,33,16],[7,13,7,14],[8,13,8,14],[10,13,18,13],[17,4,26,4],[21,13,21,14],[27,13,27,16],[28,3,28,4],[28,13,28,15],[29,13,29,14],[31,13,31,14],[64,3,65,5],[66,3,88,5],[34,13,34,16],[36,13,45,13],[47,13,47,14],[49,13,49,15],[50,13,50,14],[52,13,52,14]]}
[null,"Discharge Event Entry Form",null,"Basic Metadata",null,null,null,"Cross Section and Velocity Measurements",null,null,null,null,null,"Alternative Data Inputs to Cross Section and Velocity Measurements",null,null,null,null,"Segment Calculations"]
[null,"Starting-off Tutorial:\n1) In the new \"Discharge Day X\" sheet, enter as much data from the \"Stream Discharge Data\" sheet into the WHITE boxes.\n-- Note: You should not be able to modify any of the grey or blue boxes.\n_____\n2) Completely fill out the \"Basic Metadata\" section.\n-- Note: Be sure to enter all times in EASTERN STANDARD TIME (EST; UTC-5); if the time recorded on your \"Stream Discharge Data\" sheet was in Eastern Daylight Time (EDT; UTC-4), you should subtract one hour from that time.\n_____ \n3) Fill out the \"Cross Section and Velocity Measurments\" section with measurements only from right edge of water to left edge of water on your \"Stream Dischrage Data\" sheet.\n-- Note: Measurements between the water edges and the bank pins are not used to calculate discharge.\n_____\n4) If you measured a cross section, fill out [Points of Note], [Distance], [Water Depth] and [Comments] in the \"Cross Section and Velocity Measurements\" section.                                                                                      ",null,null,null,null,"Point ",null,null,null,null,null,null,null,null,null,null,null,"(Calculations from Cross Section and Velocity Measurements)"]
[null,null,null,"Measurement Completed By:","Bressler, Chambers"]
[null,null,null,null,null,null,null,"Points of note:","Distance (m)","Water Depth (m)","Velocity (m/s)","Comment",null,null,null,null,null,null,"Segment Width (m)","Segment Area (m2)","Segment Discharge (m3/s)",null,"Possible Notes"]
[null,null,null,"Stream Name:","Rocky Run",null,1,"LEW",0,0,0,null,null,"Neutral Buoyant Object Measurement",null,null,null,null,{"$f":"IF(I5=\"\",\"\",  IF( OR(H5=\"REW\",H5=\"LEW\"),     IF(I6=\"\", (I5-I4)/2, (I6-I5)/2),    ( (I5-I4)/2 + (I6-I5)/2) )  )","v":0.1},{"$f":"IF(I5=\"\",\"\",S5*J5)","v":0},{"$f":"IF(K5=\"\",\"\",T5*K5)","v":0},null,"REW"]
[null,null,null,"Location:","Upper Rocky, DS of Hwy 200",null,2,null,0.2,0.03,0.01,null,null,"1. Distance",null,null,null,null,{"$f":"IF(I6=\"\",\"\",  IF( OR(H6=\"REW\",H6=\"LEW\"),     IF(I7=\"\", (I6-I5)/2, (I7-I6)/2),    ( (I6-I5)/2 + (I7-I6)/2) )  )","v":0.2},6.0000000000000001E-3,6.0000000000000002E-5,null,"LEW"]
[null,null,null,"SiteID:","ROCK_US3",null,3,null,0.4,0.05,0.01,null,null,"Start of float to Transect (m):",null,null,null,null,{"$f":"IF(I7=\"\",\"\",  IF( OR(H7=\"REW\",H7=\"LEW\"),     IF(I8=\"\", (I7-I6)/2, (I8-I7)/2),    ( (I7-I6)/2 + (I8-I7)/2) )  )","v":0.24999999999999997},1.2499999999999999E-2,1.25E-4,null,"RPIN"]
[null,null,null,"Station Latitude / Longitude:","39.816792, -75.550789",null,4,null,0.7,0.1,0.03,null,null,"Transect to End of float (m):",null,null,null,null,0.25,2.5000000000000001E-2,7.5000000000000002E-4,null,"LPIN"]
[null,null,null,"Date:","2017-08-21",null,5,null,0.9,0.13,0.09,null,null,"TOTAL Float Distance (m):",null,{"$f":"P7+P8","v":0},null,null,0.15000000000000002,1.9500000000000003E-2,1.7550000000000003E-3,null,"RTOB"]
[null,null,null,"Start Time in EST:","14:25:00",null,6,null,1,0.14000000000000001,0.08,null,null,"2. Time",null,null,null,null,0.14999999999999997,2.0999999999999998E-2,1.6799999999999999E-3,null,"LTOB"]
[null,null,null,"Stop Time in EST:","14:53:00",null,7,null,1.2,0.12,0.04,null,null,"Travel Time (sec):\nMeasure at least 5 Times","Time 1:",null,null,null,0.19999999999999996,2.3999999999999994E-2,9.5999999999999981E-4]
[null,null,null,"Staff Gauge Height (m):",0.24,null,8,"REW",1.4,0,0,null,null,null,"Time 2:",null,null,null,9.9999999999999978E-2,0,0]
[null,null,null,"Recorded Sensor Depth (mm):",157.30000000000001,null,9,null,null,null,null,null,null,null,"Time 3:",null,null,null,"","",""]
[null,null,null,"Staff Gage/Sensor Offset (m):",8.2699999999999968E-2,null,10,null,null,null,null,null,null,null,"Time 4:",null,null,null,"","",""]
[null,null,null,"Velocity Meter (if applicable):","Swoffer, Stroud #1",null,11,null,null,null,null,null,null,null,"Time 5:",null,null,null,"","",""]
[null,null,null,"Calibration Date of Velocity Meter:",null,null,12,null,null,null,null,null,null,null,"Time 6:",null,null,null,"","",""]
[null,null,null,null,null,null,13,null,null,null,null,null,null,null,"Time 7:",null,null,null,"","",""]
[null,null,null,"Other Notes:","Did discharge measurements ~15m upstream of bank pins - flow was too slow to do it at the established cross section - instead measrued in upstream riffle section. First visit since new CTD replaced 7/24/17 damaged one",null,14,null,null,null,null,null,null,null,"Time 8:",null,null,null,"","",""]
[null,null,null,null,null,null,15,null,null,null,null,null,null,null,"Time 9:",null,null,null,"","",""]
[null,null,null,null,null,null,16,null,null,null,null,null,null,null,"Time 10:",null,null,null,"","",""]
[null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,18,null,null,null,null,null,null,"Mean Travel Time (sec):",null,{"$f":"IF(NumberTravelTimes > 0, AVERAGE(TravelTimes), 0)","v":0},null,null,"","",""]
[null,"_____\n5) If you measured velocities with a velocity meter, also fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.  \n______ \n6) If you used a neutrally buoyant object, instead, to measure velocity, fill out [Float Distance] and [Time] in the \"Neutral Buoyant Object Measurement\" section. \n______\n7) If you measured velocities with a hand-held flow meter, instead, fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.\n______\n8) If you did NOT measure any cross section data, fill out the [Predicted Stream Wetted Width] and [Predicted Wetted Cross Sectional Area] under the appropriate section where you took \"Alternative Data Inputs to Cross Section and Velocity Measurements\" \n-- Note: Data found on the*StageToAreaPredictor* spreadsheet\n______\n9) After you have finished entering your data, go back to the \"Rating Curve\" sheet.",null,null,null,null,19,null,null,null,null,null,null,"Mean Transect Velocity (m/sec):",null,{"$f":"FloatDistance/MeanTravelTime*0.76","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,20,null,null,null,null,null,null,"3. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,21,null,null,null,null,null,null,"Measured Values from Cross Section",null,null,null,null,"","",""]
[null,null,null,null,null,null,22,null,null,null,null,null,null,"Stream Wetted Width (m):",null,{"$f":"MeasuredWettedWidth","v":1.4},null,null,"","",""]
[null,null,null,null,null,null,23,null,null,null,null,null,null,"Cross Sectional Area (m2):",null,{"$f":"MeasuredCrossSectionalArea","v":0.10799999999999998},null,null,"","",""]
[null,null,null,null,null,null,24,null,null,null,null,null,null,"--- OR ---",null,null,null,null,"","",""]
[null,null,null,"Results",null,null,25,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,"Calculated Total Discharge (m3/s):",{"$f":"IF(HFMDischarge > 0, HFMDischarge, IF(AreaVelocityDischarge>0, AreaVelocityDischarge, NBODischarge))","v":5.3300000000000005E-3},null,26,null,null,null,null,null,null," Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,27,null,null,null,null,null,null,"4. Result",null,null,null,null,"","",""]
[null,null,null,"Stream Wetted Width (m):",{"$f":"IF(WettedWidthFromSAP > 0, WettedWidthFromSAP, IF(MeasuredWettedWidth > 0, MeasuredWettedWidth, WettedWidthFromStage))","v":1.4},null,28,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"IF(CrossSectionalAreaFromStage>0, CrossSectionalAreaFromStage*MeanVelocity, CrossSectionalArea*MeanVelocity)","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,"Stream Cross Sectional Area (m2):",{"$f":"IF(CrossSectionalAreaFromSAP > 0, CrossSectionalAreaFromSAP, IF(MeasuredCrossSectionalArea > 0, MeasuredCrossSectionalArea, CrossSectionalAreaFromStage))","v":0.10799999999999998},null,30,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,31,null,null,null,null,null,null,"Handheld Flow Meter Measurement",null,null,null,null,"","",""]
[null,null,null,null,null,null,32,null,null,null,null,null,null,"1. Velocity",null,null,null,null,"","",""]
[null,null,null,null,null,null,33,null,null,null,null,null,null,"Flow Velocity (m/sec):                         \nMeasure at least 5 Times","Velocity 1:",null,null,null,"","",""]
[null,null,null,null,null,null,34,null,null,null,null,null,null,null,"Velocity 2:",null,null,null,"","",""]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,"Velocity 3:",null,null,null,"","",""]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,"Velocity 4:",null,null,null,"","",""]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,"Velocity 5:",null,null,null,"","",""]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,"Velocity 6:",null,null,null,"","",""]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,"Velocity 7:",null,null,null,"","",""]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,"Velocity 8:",null,null,null,"","",""]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,"Velocity 9:",null,null,null,"","",""]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,"Velocity 10:",null,null,null,"","",""]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,44,null,null,null,null,null,null,"Mean Flow Meter Velocity (m/sec):",null,{"$f":"IF(NumberFlowTimes>0,AVERAGE(FlowTimes),0)","v":0},null,null,"","",""]
[null,null,null,null,null,null,45,null,null,null,null,null,null,"2. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,46,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,null,null,null,47,null,null,null,null,null,null,"Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,48,null,null,null,null,null,null,"3. Result",null,null,null,null,"","",""]
[null,null,null,null,null,null,49,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"MeanFlowMeterVelocity*CrossSectionalAreaFromSAP","v":0},null,null,"","",""]
[null,null,null,null,null,null,50,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,null,{"$f":"SUM(S$5:$S$54)","v":1.4},{"$f":"SUM(T$5:$T$54)","v":0.10799999999999998},{"$f":"SUM(U$5:$U$54)","v":5.3300000000000005E-3},"Total of Segments:"]

{"sheet":"Discharge Event 3","index":5,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,7,0,11],[0,13,1,15],[0,18,0,20],[1,1,21,2],[1,6,3,6],[1,18,1,20],[4,13,4,16],[6,13,6,14],[22,1,44,2],[22,13,22,14],[24,13,24,15],[25,13,25,14],[26,13,26,14],[33,13,33,16],[7,13,7,14],[8,13,8,14],[10,13,18,13],[17,4,26,4],[21,13,21,14],[27,13,27,16],[28,3,28,4],[28,13,28,15],[29,13,29,14],[31,13,31,14],[64,3,65,5],[66,3,88,5],[34,13,34,16],[36,13,45,13],[47,13,47,14],[49,13,49,15],[50,13,50,14],[52,13,52,14]]}
[null,"Discharge Event Entry Form",null,"Basic Metadata",null,null,null,"Cross Section and Velocity Measurements",null,null,null,null,null,"Alternative Data Inputs to Cross Section and Velocity Measurements",null,null,null,null,"Segment Calculations"]
[null,"Starting-off Tutorial:\n1) In the new \"Discharge Day X\" sheet, enter as much data from the \"Stream Discharge Data\" sheet into the WHITE boxes.\n-- Note: You should not be able to modify any of the grey or blue boxes.\n_____\n2) Completely fill out the \"Basic Metadata\" section.\n-- Note: Be sure to enter all times in EASTERN STANDARD TIME (EST; UTC-5); if the time recorded on your \"Stream Discharge Data\" sheet was in Eastern Daylight Time (EDT; UTC-4), you should subtract one hour from that time.\n_____ \n3) Fill out the \"Cross Section and Velocity Measurments\" section with measurements only from right edge of water to left edge of water on your \"Stream Dischrage Data\" sheet.\n-- Note: Measurements between the water edges and the bank pins are not used to calculate discharge.\n_____\n4) If you measured a cross section, fill out [Points of Note], [Distance], [Water Depth] and [Comments] in the \"Cross Section and Velocity Measurements\" section.                                                                                      ",null,null,null,null,"Point ",null,null,null,null,null,null,null,null,null,null,null,"(Calculations from Cross Section and Velocity Measurements)"]
[null,null,null,"Measurement Completed By:","Jeff Chambers and Kim Hachadoorian"]
[null,null,null,null,null,null,null,"Points of note:","Distance (m)","Water Depth (m)","Velocity (m/s)","Comment",null,null,null,null,null,null,"Segment Width (m)","Segment Area (m2)","Segment Discharge (m3/s)",null,"Possible Notes"]
[null,null,null,"Stream Name:","Rocky Run",null,1,"LEW",2.8,0,0,null,null,"Neutral Buoyant Object Measurement",null,null,null,null,{"$f":"IF(I5=\"\",\"\",  IF( OR(H5=\"REW\",H5=\"LEW\"),     IF(I6=\"\", (I5-I4)/2, (I6-I5)/2),    ( (I5-I4)/2 + (I6-I5)/2) )  )","v":0.25},{"$f":"IF(I5=\"\",\"\",S5*J5)","v":0},{"$f":"IF(K5=\"\",\"\",T5*K5)","v":0},null,"REW"]
[null,null,null,"Location:","Upper Rocky, DS of Hwy 200",null,2,null,3.3,0.16,0.01,null,null,"1. Distance",null,null,null,null,{"$f":"IF(I6=\"\",\"\",  IF( OR(H6=\"REW\",H6=\"LEW\"),     IF(I7=\"\", (I6-I5)/2, (I7-I6)/2),    ( (I6-I5)/2 + (I7-I6)/2) )  )","v":0.45000000000000018},7.2000000000000036E-2,7.2000000000000037E-4,null,"LEW"]
[null,null,null,"SiteID:","ROCK_US3",null,3,null,3.7,0.24,0.1,null,null,"Start of float to Transect (m):",null,null,null,null,{"$f":"IF(I7=\"\",\"\",  IF( OR(H7=\"REW\",H7=\"LEW\"),     IF(I8=\"\", (I7-I6)/2, (I8-I7)/2),    ( (I7-I6)/2 + (I8-I7)/2) )  )","v":0.35000000000000009},8.4000000000000019E-2,8.400000000000003E-3,null,"RPIN"]
[null,null,null,"Station Latitude / Longitude:","39.816792, -75.550789",null,4,null,4,0.3,0.25,null,null,"Transect to End of float (m):",null,null,null,null,0.25,7.4999999999999997E-2,1.8749999999999999E-2,null,"LPIN"]
[null,null,null,"Date:","2018-01-23",null,5,null,4.2,0.3,0.1,null,null,"TOTAL Float Distance (m):",null,{"$f":"P7+P8","v":0},null,null,0.20000000000000018,6.0000000000000053E-2,6.0000000000000053E-3,null,"RTOB"]
[null,null,null,"Start Time in EST:","09:50:00",null,6,null,4.4000000000000004,0.47,0.12,null,null,"2. Time",null,null,null,null,0.19999999999999973,9.3999999999999875E-2,1.1279999999999984E-2,null,"LTOB"]
[null,null,null,"Stop Time in EST:","10:23:00",null,7,null,4.5999999999999996,0.36,0.3,null,null,"Travel Time (sec):\nMeasure at least 5 Times","Time 1:",null,null,null,0.19999999999999973,7.1999999999999897E-2,2.159999999999997E-2]
[null,null,null,"Staff Gauge Height (m):",0.39,null,8,null,4.8,0.38,0.3,null,null,null,"Time 2:",null,null,null,0.20000000000000018,7.6000000000000068E-2,2.2800000000000018E-2]
[null,null,null,"Recorded Sensor Depth (mm):",277.3,null,9,null,5,0.4,0.15,null,null,null,"Time 3:",null,null,null,0.20000000000000018,8.0000000000000071E-2,1.2000000000000011E-2]
[null,null,null,"Staff Gage/Sensor Offset (m):",0.11270000000000002,null,10,null,5.2,0.52,0.15,null,null,null,"Time 4:",null,null,null,0.20000000000000018,0.10400000000000009,1.5600000000000013E-2]
[null,null,null,"Velocity Meter (if applicable):","Swoffer #1",null,11,null,5.4,0.56999999999999995,0.06,null,null,null,"Time 5:",null,null,null,0.19999999999999973,0.11399999999999984,6.8399999999999902E-3]
[null,null,null,"Calibration Date of Velocity Meter:","Fall 2017",null,12,null,5.6,0.63,0.03,null,null,null,"Time 6:",null,null,null,0.19999999999999973,0.12599999999999983,3.7799999999999947E-3]
[null,null,null,null,null,null,13,null,5.8,0.57999999999999996,0.01,"Estimate",null,null,"Time 7:",null,null,null,0.20000000000000018,0.11600000000000009,1.1600000000000009E-3]
[null,null,null,"Other Notes:","Dave B & Matt G did an additional measurement at the same time with the MM #2 (Event 4)",null,14,null,6,0.65,0.01,null,null,null,"Time 8:",null,null,null,0.20000000000000018,0.13000000000000012,1.3000000000000012E-3]
[null,null,null,null,null,null,15,null,6.2,0.65,0,null,null,null,"Time 9:",null,null,null,0.20000000000000018,0.13000000000000012,0]
[null,null,null,null,null,null,16,null,6.4,0.37,0.01,"Estimate",null,null,"Time 10:",null,null,null,0.19999999999999973,7.3999999999999899E-2,7.3999999999999901E-4]
[null,null,null,null,null,null,17,null,6.6,0.38,0,null,null,null,null,null,null,null,0.19999999999999973,7.5999999999999901E-2,0]
[null,null,null,null,null,null,18,null,6.8,0.36,0,null,null,"Mean Travel Time (sec):",null,{"$f":"IF(NumberTravelTimes > 0, AVERAGE(TravelTimes), 0)","v":0},null,null,0.20000000000000018,7.2000000000000064E-2,0]
[null,"_____\n5) If you measured velocities with a velocity meter, also fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.  \n______ \n6) If you used a neutrally buoyant object, instead, to measure velocity, fill out [Float Distance] and [Time] in the \"Neutral Buoyant Object Measurement\" section. \n______\n7) If you measured velocities with a hand-held flow meter, instead, fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.\n______\n8) If you did NOT measure any cross section data, fill out the [Predicted Stream Wetted Width] and [Predicted Wetted Cross Sectional Area] under the appropriate section where you took \"Alternative Data Inputs to Cross Section and Velocity Measurements\" \n-- Note: Data found on the*StageToAreaPredictor* spreadsheet\n______\n9) After you have finished entering your data, go back to the \"Rating Curve\" sheet.",null,null,null,null,19,null,7,0.38,0.02,null,null,"Mean Transect Velocity (m/sec):",null,{"$f":"FloatDistance/MeanTravelTime*0.76","v":{"$error":"#DIV/0!"}},null,null,0.26000000000000023,9.8800000000000082E-2,1.9760000000000016E-3]
[null,null,null,null,null,null,20,"REW",7.32,0.34,0,null,null,"3. Area",null,null,null,null,0.16000000000000014,5.4400000000000052E-2,0]
[null,null,null,null,null,null,21,null,null,null,null,null,null,"Measured Values from Cross Section",null,null,null,null,"","",""]
[null,null,null,null,null,null,22,null,null,null,null,null,null,"Stream Wetted Width (m):",null,{"$f":"MeasuredWettedWidth","v":4.5199999999999996},null,null,"","",""]
[null,null,null,null,null,null,23,null,null,null,null,null,null,"Cross Sectional Area (m2):",null,{"$f":"MeasuredCrossSectionalArea","v":1.7081999999999999},null,null,"","",""]
[null,null,null,null,null,null,24,null,null,null,null,null,null,"--- OR ---",null,null,null,null,"","",""]
[null,null,null,"Results",null,null,25,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,"Calculated Total Discharge (m3/s):",{"$f":"IF(HFMDischarge > 0, HFMDischarge, IF(AreaVelocityDischarge>0, AreaVelocityDischarge, NBODischarge))","v":0.13294599999999998},null,26,null,null,null,null,null,null," Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,27,null,null,null,null,null,null,"4. Result",null,null,null,null,"","",""]
[null,null,null,"Stream Wetted Width (m):",{"$f":"IF(WettedWidthFromSAP > 0, WettedWidthFromSAP, IF(MeasuredWettedWidth > 0, MeasuredWettedWidth, WettedWidthFromStage))","v":4.5199999999999996},null,28,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"IF(CrossSectionalAreaFromStage>0, CrossSectionalAreaFromStage*MeanVelocity, CrossSectionalArea*MeanVelocity)","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,"Stream Cross Sectional Area (m2):",{"$f":"IF(CrossSectionalAreaFromSAP > 0, CrossSectionalAreaFromSAP, IF(MeasuredCrossSectionalArea > 0, MeasuredCrossSectionalArea, CrossSectionalAreaFromStage))","v":1.7081999999999999},null,30,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,31,null,null,null,null,null,null,"Handheld Flow Meter Measurement",null,null,null,null,"","",""]
[null,null,null,null,null,null,32,null,null,null,null,null,null,"1. Velocity",null,null,null,null,"","",""]
[null,null,null,null,null,null,33,null,null,null,null,null,null,"Flow Velocity (m/sec):                         \nMeasure at least 5 Times","Velocity 1:",null,null,null,"","",""]
[null,null,null,null,null,null,34,null,null,null,null,null,null,null,"Velocity 2:",null,null,null,"","",""]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,"Velocity 3:",null,null,null,"","",""]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,"Velocity 4:",null,null,null,"","",""]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,"Velocity 5:",null,null,null,"","",""]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,"Velocity 6:",null,null,null,"","",""]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,"Velocity 7:",null,null,null,"","",""]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,"Velocity 8:",null,null,null,"","",""]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,"Velocity 9:",null,null,null,"","",""]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,"Velocity 10:",null,null,null,"","",""]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,44,null,null,null,null,null,null,"Mean Flow Meter Velocity (m/sec):",null,{"$f":"IF(NumberFlowTimes>0,AVERAGE(FlowTimes),0)","v":0},null,null,"","",""]
[null,null,null,null,null,null,45,null,null,null,null,null,null,"2. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,46,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,null,null,null,47,null,null,null,null,null,null,"Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,48,null,null,null,null,null,null,"3. Result",null,null,null,null,"","",""]
[null,null,null,null,null,null,49,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"MeanFlowMeterVelocity*CrossSectionalAreaFromSAP","v":0},null,null,"","",""]
[null,null,null,null,null,null,50,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,null,{"$f":"SUM(S$5:$S$54)","v":4.5199999999999996},{"$f":"SUM(T$5:$T$54)","v":1.7081999999999999},{"$f":"SUM(U$5:$U$54)","v":0.13294599999999998},"Total of Segments:"]

{"sheet":"Discharge Event 4","index":6,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,7,0,11],[0,13,1,15],[0,18,0,20],[1,1,21,2],[1,6,3,6],[1,18,1,20],[4,13,4,16],[6,13,6,14],[22,1,44,2],[22,13,22,14],[24,13,24,15],[25,13,25,14],[26,13,26,14],[33,13,33,16],[7,13,7,14],[8,13,8,14],[10,13,18,13],[17,4,26,4],[21,13,21,14],[27,13,27,16],[28,3,28,4],[28,13,28,15],[29,13,29,14],[31,13,31,14],[64,3,65,5],[66,3,88,5],[34,13,34,16],[36,13,45,13],[47,13,47,14],[49,13,49,15],[50,13,50,14],[52,13,52,14]]}
[null,"Discharge Event Entry Form",null,"Basic Metadata",null,null,null,"Cross Section and Velocity Measurements",null,null,null,null,null,"Alternative Data Inputs to Cross Section and Velocity Measurements",null,null,null,null,"Segment Calculations"]
[null,"Starting-off Tutorial:\n1) In the new \"Discharge Day X\" sheet, enter as much data from the \"Stream Discharge Data\" sheet into the WHITE boxes.\n-- Note: You should not be able to modify any of the grey or blue boxes.\n_____\n2) Completely fill out the \"Basic Metadata\" section.\n-- Note: Be sure to enter all times in EASTERN STANDARD TIME (EST; UTC-5); if the time recorded on your \"Stream Discharge Data\" sheet was in Eastern Daylight Time (EDT; UTC-4), you should subtract one hour from that time.\n_____ \n3) Fill out the \"Cross Section and Velocity Measurments\" section with measurements only from right edge of water to left edge of water on your \"Stream Dischrage Data\" sheet.\n-- Note: Measurements between the water edges and the bank pins are not used to calculate discharge.\n_____\n4) If you measured a cross section, fill out [Points of Note], [Distance], [Water Depth] and [Comments] in the \"Cross Section and Velocity Measurements\" section.                                                                                      ",null,null,null,null,"Point ",null,null,null,null,null,null,null,null,null,null,null,"(Calculations from Cross Section and Velocity Measurements)"]
[null,null,null,"Measurement Completed By:","Matt Gisondi & Dave Bressler"]
[null,null,null,null,null,null,null,"Points of note:","Distance (m)","Water Depth (m)","Velocity (m/s)","Comment",null,null,null,null,null,null,"Segment Width (m)","Segment Area (m2)","Segment Discharge (m3/s)",null,"Possible Notes"]
[null,null,null,"Stream Name:","Rocky Run",null,1,"LEW",2.8,0,0,null,null,"Neutral Buoyant Object Measurement",null,null,null,null,{"$f":"IF(I5=\"\",\"\",  IF( OR(H5=\"REW\",H5=\"LEW\"),     IF(I6=\"\", (I5-I4)/2, (I6-I5)/2),    ( (I5-I4)/2 + (I6-I5)/2) )  )","v":0.25},{"$f":"IF(I5=\"\",\"\",S5*J5)","v":0},{"$f":"IF(K5=\"\",\"\",T5*K5)","v":0},null,"REW"]
[null,null,null,"Location:","Upper Rocky, DS of Hwy 200",null,2,null,3.3,0.16,0.06,null,null,"1. Distance",null,null,null,null,{"$f":"IF(I6=\"\",\"\",  IF( OR(H6=\"REW\",H6=\"LEW\"),     IF(I7=\"\", (I6-I5)/2, (I7-I6)/2),    ( (I6-I5)/2 + (I7-I6)/2) )  )","v":0.45000000000000018},7.2000000000000036E-2,4.3200000000000018E-3,null,"LEW"]
[null,null,null,"SiteID:","ROCK_US3",null,3,null,3.7,0.25,0.13,null,null,"Start of float to Transect (m):",null,null,null,null,{"$f":"IF(I7=\"\",\"\",  IF( OR(H7=\"REW\",H7=\"LEW\"),     IF(I8=\"\", (I7-I6)/2, (I8-I7)/2),    ( (I7-I6)/2 + (I8-I7)/2) )  )","v":0.35000000000000009},8.7500000000000022E-2,1.1375000000000003E-2,null,"RPIN"]
[null,null,null,"Station Latitude / Longitude:","39.816792, -75.550789",null,4,null,4,0.28999999999999998,0.18,null,null,"Transect to End of float (m):",null,null,null,null,0.25,7.2499999999999995E-2,1.3049999999999999E-2,null,"LPIN"]
[null,null,null,"Date:","2018-01-23",null,5,null,4.2,0.28000000000000003,0.24,null,null,"TOTAL Float Distance (m):",null,{"$f":"P7+P8","v":0},null,null,0.20000000000000018,5.6000000000000057E-2,1.3440000000000013E-2,null,"RTOB"]
[null,null,null,"Start Time in EST:","09:47:00",null,6,null,4.4000000000000004,0.37,0.2,null,null,"2. Time",null,null,null,null,0.19999999999999973,7.3999999999999899E-2,1.479999999999998E-2,null,"LTOB"]
[null,null,null,"Stop Time in EST:","10:15:00",null,7,null,4.5999999999999996,0.37,0.28999999999999998,null,null,"Travel Time (sec):\nMeasure at least 5 Times","Time 1:",null,null,null,0.19999999999999973,7.3999999999999899E-2,2.1459999999999969E-2]
[null,null,null,"Staff Gauge Height (m):",0.39500000000000002,null,8,null,4.8,0.39,0.33,null,null,null,"Time 2:",null,null,null,0.20000000000000018,7.8000000000000069E-2,2.5740000000000023E-2]
[null,null,null,"Recorded Sensor Depth (mm):",277.3,null,9,null,5,0.38,0.24,null,null,null,"Time 3:",null,null,null,0.20000000000000018,7.6000000000000068E-2,1.8240000000000017E-2]
[null,null,null,"Staff Gage/Sensor Offset (m):",0.11770000000000003,null,10,null,5.2,0.56000000000000005,0.19,null,null,null,"Time 4:",null,null,null,0.20000000000000018,0.11200000000000011,2.1280000000000021E-2]
[null,null,null,"Velocity Meter (if applicable):","Marsh-McBirney #2",null,11,null,5.4,0.6,0.13,null,null,null,"Time 5:",null,null,null,0.19999999999999973,0.11999999999999983,1.5599999999999978E-2]
[null,null,null,"Calibration Date of Velocity Meter:","Fall 2017",null,12,null,5.6,0.6,0.08,null,null,null,"Time 6:",null,null,null,0.19999999999999973,0.11999999999999983,9.599999999999987E-3]
[null,null,null,null,null,null,13,null,5.8,0.6,0.02,null,null,null,"Time 7:",null,null,null,0.20000000000000018,0.12000000000000011,2.4000000000000024E-3]
[null,null,null,"Other Notes:","Jeff C & Kim H did an additional measurement at the same time with the Swoffer #1 (Event 3)",null,14,null,6,0.6,0.04,null,null,null,"Time 8:",null,null,null,0.20000000000000018,0.12000000000000011,4.8000000000000048E-3]
[null,null,null,null,null,null,15,null,6.2,0.42,0.02,null,null,null,"Time 9:",null,null,null,0.20000000000000018,8.4000000000000075E-2,1.6800000000000016E-3]
[null,null,null,null,null,null,16,null,6.4,0.32,0.01,"Estimate",null,null,"Time 10:",null,null,null,0.19999999999999973,6.3999999999999918E-2,6.3999999999999918E-4]
[null,null,null,null,null,null,17,null,6.6,0.38,-0.02,"Swirling",null,null,null,null,null,null,0.19999999999999973,7.5999999999999901E-2,-1.5199999999999981E-3]
[null,null,null,null,null,null,18,null,6.8,0.36,-0.03,"Swirling",null,"Mean Travel Time (sec):",null,{"$f":"IF(NumberTravelTimes > 0, AVERAGE(TravelTimes), 0)","v":0},null,null,0.20000000000000018,7.2000000000000064E-2,-2.1600000000000018E-3]
[null,"_____\n5) If you measured velocities with a velocity meter, also fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.  \n______ \n6) If you used a neutrally buoyant object, instead, to measure velocity, fill out [Float Distance] and [Time] in the \"Neutral Buoyant Object Measurement\" section. \n______\n7) If you measured velocities with a hand-held flow meter, instead, fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.\n______\n8) If you did NOT measure any cross section data, fill out the [Predicted Stream Wetted Width] and [Predicted Wetted Cross Sectional Area] under the appropriate section where you took \"Alternative Data Inputs to Cross Section and Velocity Measurements\" \n-- Note: Data found on the*StageToAreaPredictor* spreadsheet\n______\n9) After you have finished entering your data, go back to the \"Rating Curve\" sheet.",null,null,null,null,19,null,7,0.34,-0.02,"Swirling",null,"Mean Transect Velocity (m/sec):",null,{"$f":"FloatDistance/MeanTravelTime*0.76","v":{"$error":"#DIV/0!"}},null,null,0.20000000000000018,6.800000000000006E-2,-1.3600000000000012E-3]
[null,null,null,null,null,null,20,null,7.2,0.37,-0.05,null,null,"3. Area",null,null,null,null,0.18500000000000005,6.8450000000000025E-2,-3.4225000000000015E-3]
[null,null,null,null,null,null,21,"REW",7.37,0.3,0,null,null,"Measured Values from Cross Section",null,null,null,null,8.4999999999999964E-2,2.5499999999999988E-2,0]
[null,null,null,null,null,null,22,null,null,null,null,null,null,"Stream Wetted Width (m):",null,{"$f":"MeasuredWettedWidth","v":4.5699999999999994},null,null,"","",""]
[null,null,null,null,null,null,23,null,null,null,null,null,null,"Cross Sectional Area (m2):",null,{"$f":"MeasuredCrossSectionalArea","v":1.6399500000000002},null,null,"","",""]
[null,null,null,null,null,null,24,null,null,null,null,null,null,"--- OR ---",null,null,null,null,"","",""]
[null,null,null,"Results",null,null,25,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,"Calculated Total Discharge (m3/s):",{"$f":"IF(HFMDischarge > 0, HFMDischarge, IF(AreaVelocityDischarge>0, AreaVelocityDischarge, NBODischarge))","v":0.16996250000000004},null,26,null,null,null,null,null,null," Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,27,null,null,null,null,null,null,"4. Result",null,null,null,null,"","",""]
[null,null,null,"Stream Wetted Width (m):",{"$f":"IF(WettedWidthFromSAP > 0, WettedWidthFromSAP, IF(MeasuredWettedWidth > 0, MeasuredWettedWidth, WettedWidthFromStage))","v":4.5699999999999994},null,28,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"IF(CrossSectionalAreaFromStage>0, CrossSectionalAreaFromStage*MeanVelocity, CrossSectionalArea*MeanVelocity)","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,"Stream Cross Sectional Area (m2):",{"$f":"IF(CrossSectionalAreaFromSAP > 0, CrossSectionalAreaFromSAP, IF(MeasuredCrossSectionalArea > 0, MeasuredCrossSectionalArea, CrossSectionalAreaFromStage))","v":1.6399500000000002},null,30,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,31,null,null,null,null,null,null,"Handheld Flow Meter Measurement",null,null,null,null,"","",""]
[null,null,null,null,null,null,32,null,null,null,null,null,null,"1. Velocity",null,null,null,null,"","",""]
[null,null,null,null,null,null,33,null,null,null,null,null,null,"Flow Velocity (m/sec):                         \nMeasure at least 5 Times","Velocity 1:",null,null,null,"","",""]
[null,null,null,null,null,null,34,null,null,null,null,null,null,null,"Velocity 2:",null,null,null,"","",""]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,"Velocity 3:",null,null,null,"","",""]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,"Velocity 4:",null,null,null,"","",""]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,"Velocity 5:",null,null,null,"","",""]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,"Velocity 6:",null,null,null,"","",""]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,"Velocity 7:",null,null,null,"","",""]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,"Velocity 8:",null,null,null,"","",""]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,"Velocity 9:",null,null,null,"","",""]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,"Velocity 10:",null,null,null,"","",""]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,44,null,null,null,null,null,null,"Mean Flow Meter Velocity (m/sec):",null,{"$f":"IF(NumberFlowTimes>0,AVERAGE(FlowTimes),0)","v":0},null,null,"","",""]
[null,null,null,null,null,null,45,null,null,null,null,null,null,"2. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,46,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,null,null,null,47,null,null,null,null,null,null,"Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,48,null,null,null,null,null,null,"3. Result",null,null,null,null,"","",""]
[null,null,null,null,null,null,49,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"MeanFlowMeterVelocity*CrossSectionalAreaFromSAP","v":0},null,null,"","",""]
[null,null,null,null,null,null,50,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,null,{"$f":"SUM(S$5:$S$54)","v":4.5699999999999994},{"$f":"SUM(T$5:$T$54)","v":1.6399500000000002},{"$f":"SUM(U$5:$U$54)","v":0.16996250000000004},"Total of Segments:"]

{"sheet":"Discharge Event 5","index":7,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,7,0,11],[0,13,1,15],[0,18,0,20],[1,1,21,2],[1,6,3,6],[1,18,1,20],[4,13,4,16],[6,13,6,14],[22,1,44,2],[22,13,22,14],[24,13,24,15],[25,13,25,14],[26,13,26,14],[33,13,33,16],[7,13,7,14],[8,13,8,14],[10,13,18,13],[17,4,26,4],[21,13,21,14],[27,13,27,16],[28,3,28,4],[28,13,28,15],[29,13,29,14],[31,13,31,14],[64,3,65,5],[66,3,88,5],[34,13,34,16],[36,13,45,13],[47,13,47,14],[49,13,49,15],[50,13,50,14],[52,13,52,14]]}
[null,"Discharge Event Entry Form",null,"Basic Metadata",null,null,null,"Cross Section and Velocity Measurements",null,null,null,null,null,"Alternative Data Inputs to Cross Section and Velocity Measurements",null,null,null,null,"Segment Calculations"]
[null,"Starting-off Tutorial:\n1) In the new \"Discharge Day X\" sheet, enter as much data from the \"Stream Discharge Data\" sheet into the WHITE boxes.\n-- Note: You should not be able to modify any of the grey or blue boxes.\n_____\n2) Completely fill out the \"Basic Metadata\" section.\n-- Note: Be sure to enter all times in EASTERN STANDARD TIME (EST; UTC-5); if the time recorded on your \"Stream Discharge Data\" sheet was in Eastern Daylight Time (EDT; UTC-4), you should subtract one hour from that time.\n_____ \n3) Fill out the \"Cross Section and Velocity Measurments\" section with measurements only from right edge of water to left edge of water on your \"Stream Dischrage Data\" sheet.\n-- Note: Measurements between the water edges and the bank pins are not used to calculate discharge.\n_____\n4) If you measured a cross section, fill out [Points of Note], [Distance], [Water Depth] and [Comments] in the \"Cross Section and Velocity Measurements\" section.                                                                                      ",null,null,null,null,"Point ",null,null,null,null,null,null,null,null,null,null,null,"(Calculations from Cross Section and Velocity Measurements)"]
[null,null,null,"Measurement Completed By:","Jeff C & Kim H"]
[null,null,null,null,null,null,null,"Points of note:","Distance (m)","Water Depth (m)","Velocity (m/s)","Comment",null,null,null,null,null,null,"Segment Width (m)","Segment Area (m2)","Segment Discharge (m3/s)",null,"Possible Notes"]
[null,null,null,"Stream Name:","Rocky Run",null,1,"LEW",2.8,0.17,0.02,null,null,"Neutral Buoyant Object Measurement",null,null,null,null,{"$f":"IF(I5=\"\",\"\",  IF( OR(H5=\"REW\",H5=\"LEW\"),     IF(I6=\"\", (I5-I4)/2, (I6-I5)/2),    ( (I5-I4)/2 + (I6-I5)/2) )  )","v":0.25},{"$f":"IF(I5=\"\",\"\",S5*J5)","v":4.2500000000000003E-2},{"$f":"IF(K5=\"\",\"\",T5*K5)","v":8.5000000000000006E-4},null,"REW"]
[null,null,null,"Location:","Upper Rocky, DS of Hwy 200",null,2,null,3.3,0.14000000000000001,0.02,null,null,"1. Distance",null,null,null,null,{"$f":"IF(I6=\"\",\"\",  IF( OR(H6=\"REW\",H6=\"LEW\"),     IF(I7=\"\", (I6-I5)/2, (I7-I6)/2),    ( (I6-I5)/2 + (I7-I6)/2) )  )","v":0.35000000000000009},4.9000000000000016E-2,9.800000000000004E-4,null,"LEW"]
[null,null,null,"SiteID:","ROCK_US3",null,3,null,3.5,0.22,0.15,null,null,"Start of float to Transect (m):",null,null,null,null,{"$f":"IF(I7=\"\",\"\",  IF( OR(H7=\"REW\",H7=\"LEW\"),     IF(I8=\"\", (I7-I6)/2, (I8-I7)/2),    ( (I7-I6)/2 + (I8-I7)/2) )  )","v":0.20000000000000018},4.4000000000000039E-2,6.600000000000006E-3,null,"RPIN"]
[null,null,null,"Station Latitude / Longitude:","39.816792, -75.550789",null,4,null,3.7,0.23,0.15,null,null,"Transect to End of float (m):",null,null,null,null,0.19999999999999996,4.5999999999999992E-2,6.899999999999999E-3,null,"LPIN"]
[null,null,null,"Date:","2018-01-23",null,5,null,3.9,0.38,0.17,null,null,"TOTAL Float Distance (m):",null,{"$f":"P7+P8","v":0},null,null,0.19999999999999973,7.5999999999999901E-2,1.2919999999999984E-2,null,"RTOB"]
[null,null,null,"Start Time in EST:","11:05:00",null,6,null,4.0999999999999996,0.31,0.15,null,null,"2. Time",null,null,null,null,0.19999999999999996,6.1999999999999986E-2,9.2999999999999975E-3,null,"LTOB"]
[null,null,null,"Stop Time in EST:","11:45:00",null,7,null,4.3,0.34,0.16,null,null,"Travel Time (sec):\nMeasure at least 5 Times","Time 1:",null,null,null,0.20000000000000018,6.800000000000006E-2,1.0880000000000009E-2]
[null,null,null,"Staff Gauge Height (m):",0.45,null,8,null,4.5,0.37,0.25,null,null,null,"Time 2:",null,null,null,0.20000000000000018,7.4000000000000066E-2,1.8500000000000016E-2]
[null,null,null,"Recorded Sensor Depth (mm):",339,null,9,null,4.7,0.38,0.15,null,null,null,"Time 3:",null,null,null,0.20000000000000018,7.6000000000000068E-2,1.1400000000000009E-2]
[null,null,null,"Staff Gage/Sensor Offset (m):",0.11099999999999999,null,10,null,4.9000000000000004,0.42,0.21,null,null,null,"Time 4:",null,null,null,0.19999999999999973,8.399999999999988E-2,1.7639999999999975E-2]
[null,null,null,"Velocity Meter (if applicable):","Swoffer #1",null,11,null,5.0999999999999996,0.49,0.12,null,null,null,"Time 5:",null,null,null,0.19999999999999973,9.7999999999999865E-2,1.1759999999999984E-2]
[null,null,null,"Calibration Date of Velocity Meter:","Fall 2017",null,12,null,5.3,0.55000000000000004,0.11,null,null,null,"Time 6:",null,null,null,0.20000000000000018,0.11000000000000011,1.2100000000000012E-2]
[null,null,null,null,null,null,13,null,5.5,0.6,0.06,null,null,null,"Time 7:",null,null,null,0.20000000000000018,0.12000000000000011,7.2000000000000059E-3]
[null,null,null,"Other Notes:","Dave B & Matt G did an additional measurement at the same time with the MM #2 (Event 6). Unsure of reliableness of data since water level rose towards end of measurements",null,14,null,5.7,0.64,0.05,null,null,null,"Time 8:",null,null,null,0.20000000000000018,0.12800000000000011,6.4000000000000064E-3]
[null,null,null,null,null,null,15,null,5.9,0.56000000000000005,0.03,null,null,null,"Time 9:",null,null,null,0.19999999999999973,0.11199999999999986,3.3599999999999958E-3]
[null,null,null,null,null,null,16,null,6.1,0.7,0.02,null,null,null,"Time 10:",null,null,null,0.19999999999999973,0.13999999999999979,2.7999999999999961E-3]
[null,null,null,null,null,null,17,null,6.3,0.41,0.01,null,null,null,null,null,null,null,0.20000000000000018,8.2000000000000073E-2,8.2000000000000074E-4]
[null,null,null,null,null,null,18,null,6.5,0.42,0.01,null,null,"Mean Travel Time (sec):",null,{"$f":"IF(NumberTravelTimes > 0, AVERAGE(TravelTimes), 0)","v":0},null,null,0.20000000000000018,8.4000000000000075E-2,8.4000000000000079E-4]
[null,"_____\n5) If you measured velocities with a velocity meter, also fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.  \n______ \n6) If you used a neutrally buoyant object, instead, to measure velocity, fill out [Float Distance] and [Time] in the \"Neutral Buoyant Object Measurement\" section. \n______\n7) If you measured velocities with a hand-held flow meter, instead, fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.\n______\n8) If you did NOT measure any cross section data, fill out the [Predicted Stream Wetted Width] and [Predicted Wetted Cross Sectional Area] under the appropriate section where you took \"Alternative Data Inputs to Cross Section and Velocity Measurements\" \n-- Note: Data found on the*StageToAreaPredictor* spreadsheet\n______\n9) After you have finished entering your data, go back to the \"Rating Curve\" sheet.",null,null,null,null,19,null,6.7,0.42,0,null,null,"Mean Transect Velocity (m/sec):",null,{"$f":"FloatDistance/MeanTravelTime*0.76","v":{"$error":"#DIV/0!"}},null,null,0.20000000000000018,8.4000000000000075E-2,0]
[null,null,null,null,null,null,20,null,6.9,0.41,0.02,null,null,"3. Area",null,null,null,null,0.19999999999999973,8.1999999999999892E-2,1.6399999999999978E-3]
[null,null,null,null,null,null,21,"REW",7.1,0.42,0,null,null,"Measured Values from Cross Section",null,null,null,null,9.9999999999999645E-2,4.199999999999985E-2,0]
[null,null,null,null,null,null,22,null,null,null,null,null,null,"Stream Wetted Width (m):",null,{"$f":"MeasuredWettedWidth","v":4.2999999999999989},null,null,"","",""]
[null,null,null,null,null,null,23,null,null,null,null,null,null,"Cross Sectional Area (m2):",null,{"$f":"MeasuredCrossSectionalArea","v":1.7034999999999998},null,null,"","",""]
[null,null,null,null,null,null,24,null,null,null,null,null,null,"--- OR ---",null,null,null,null,"","",""]
[null,null,null,"Results",null,null,25,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,"Calculated Total Discharge (m3/s):",{"$f":"IF(HFMDischarge > 0, HFMDischarge, IF(AreaVelocityDischarge>0, AreaVelocityDischarge, NBODischarge))","v":0.14289000000000002},null,26,null,null,null,null,null,null," Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,27,null,null,null,null,null,null,"4. Result",null,null,null,null,"","",""]
[null,null,null,"Stream Wetted Width (m):",{"$f":"IF(WettedWidthFromSAP > 0, WettedWidthFromSAP, IF(MeasuredWettedWidth > 0, MeasuredWettedWidth, WettedWidthFromStage))","v":4.2999999999999989},null,28,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"IF(CrossSectionalAreaFromStage>0, CrossSectionalAreaFromStage*MeanVelocity, CrossSectionalArea*MeanVelocity)","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,"Stream Cross Sectional Area (m2):",{"$f":"IF(CrossSectionalAreaFromSAP > 0, CrossSectionalAreaFromSAP, IF(MeasuredCrossSectionalArea > 0, MeasuredCrossSectionalArea, CrossSectionalAreaFromStage))","v":1.7034999999999998},null,30,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,31,null,null,null,null,null,null,"Handheld Flow Meter Measurement",null,null,null,null,"","",""]
[null,null,null,null,null,null,32,null,null,null,null,null,null,"1. Velocity",null,null,null,null,"","",""]
[null,null,null,null,null,null,33,null,null,null,null,null,null,"Flow Velocity (m/sec):                         \nMeasure at least 5 Times","Velocity 1:",null,null,null,"","",""]
[null,null,null,null,null,null,34,null,null,null,null,null,null,null,"Velocity 2:",null,null,null,"","",""]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,"Velocity 3:",null,null,null,"","",""]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,"Velocity 4:",null,null,null,"","",""]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,"Velocity 5:",null,null,null,"","",""]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,"Velocity 6:",null,null,null,"","",""]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,"Velocity 7:",null,null,null,"","",""]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,"Velocity 8:",null,null,null,"","",""]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,"Velocity 9:",null,null,null,"","",""]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,"Velocity 10:",null,null,null,"","",""]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,44,null,null,null,null,null,null,"Mean Flow Meter Velocity (m/sec):",null,{"$f":"IF(NumberFlowTimes>0,AVERAGE(FlowTimes),0)","v":0},null,null,"","",""]
[null,null,null,null,null,null,45,null,null,null,null,null,null,"2. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,46,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,null,null,null,47,null,null,null,null,null,null,"Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,48,null,null,null,null,null,null,"3. Result",null,null,null,null,"","",""]
[null,null,null,null,null,null,49,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"MeanFlowMeterVelocity*CrossSectionalAreaFromSAP","v":0},null,null,"","",""]
[null,null,null,null,null,null,50,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,null,{"$f":"SUM(S$5:$S$54)","v":4.2999999999999989},{"$f":"SUM(T$5:$T$54)","v":1.7034999999999998},{"$f":"SUM(U$5:$U$54)","v":0.14289000000000002},"Total of Segments:"]

{"sheet":"Discharge Event 6","index":8,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,7,0,11],[0,13,1,15],[0,18,0,20],[1,1,21,2],[1,6,3,6],[1,18,1,20],[4,13,4,16],[6,13,6,14],[22,1,44,2],[22,13,22,14],[24,13,24,15],[25,13,25,14],[26,13,26,14],[33,13,33,16],[7,13,7,14],[8,13,8,14],[10,13,18,13],[17,4,26,4],[21,13,21,14],[27,13,27,16],[28,3,28,4],[28,13,28,15],[29,13,29,14],[31,13,31,14],[64,3,65,5],[66,3,88,5],[34,13,34,16],[36,13,45,13],[47,13,47,14],[49,13,49,15],[50,13,50,14],[52,13,52,14]]}
[null,"Discharge Event Entry Form",null,"Basic Metadata",null,null,null,"Cross Section and Velocity Measurements",null,null,null,null,null,"Alternative Data Inputs to Cross Section and Velocity Measurements",null,null,null,null,"Segment Calculations"]
[null,"Starting-off Tutorial:\n1) In the new \"Discharge Day X\" sheet, enter as much data from the \"Stream Discharge Data\" sheet into the WHITE boxes.\n-- Note: You should not be able to modify any of the grey or blue boxes.\n_____\n2) Completely fill out the \"Basic Metadata\" section.\n-- Note: Be sure to enter all times in EASTERN STANDARD TIME (EST; UTC-5); if the time recorded on your \"Stream Discharge Data\" sheet was in Eastern Daylight Time (EDT; UTC-4), you should subtract one hour from that time.\n_____ \n3) Fill out the \"Cross Section and Velocity Measurments\" section with measurements only from right edge of water to left edge of water on your \"Stream Dischrage Data\" sheet.\n-- Note: Measurements between the water edges and the bank pins are not used to calculate discharge.\n_____\n4) If you measured a cross section, fill out [Points of Note], [Distance], [Water Depth] and [Comments] in the \"Cross Section and Velocity Measurements\" section.                                                                                      ",null,null,null,null,"Point ",null,null,null,null,null,null,null,null,null,null,null,"(Calculations from Cross Section and Velocity Measurements)"]
[null,null,null,"Measurement Completed By:","Matt G & Dave B"]
[null,null,null,null,null,null,null,"Points of note:","Distance (m)","Water Depth (m)","Velocity (m/s)","Comment",null,null,null,null,null,null,"Segment Width (m)","Segment Area (m2)","Segment Discharge (m3/s)",null,"Possible Notes"]
[null,null,null,"Stream Name:","Rocky Run",null,1,"LEW",2.8,0.11,-0.02,null,null,"Neutral Buoyant Object Measurement",null,null,null,null,{"$f":"IF(I5=\"\",\"\",  IF( OR(H5=\"REW\",H5=\"LEW\"),     IF(I6=\"\", (I5-I4)/2, (I6-I5)/2),    ( (I5-I4)/2 + (I6-I5)/2) )  )","v":0.25},{"$f":"IF(I5=\"\",\"\",S5*J5)","v":2.75E-2},{"$f":"IF(K5=\"\",\"\",T5*K5)","v":-5.5000000000000003E-4},null,"REW"]
[null,null,null,"Location:","Upper Rocky, DS of Hwy 200",null,2,null,3.3,0.14000000000000001,0.01,null,null,"1. Distance",null,null,null,null,{"$f":"IF(I6=\"\",\"\",  IF( OR(H6=\"REW\",H6=\"LEW\"),     IF(I7=\"\", (I6-I5)/2, (I7-I6)/2),    ( (I6-I5)/2 + (I7-I6)/2) )  )","v":0.35000000000000009},4.9000000000000016E-2,4.900000000000002E-4,null,"LEW"]
[null,null,null,"SiteID:","ROCK_US3",null,3,null,3.5,0.2,0.11,null,null,"Start of float to Transect (m):",null,null,null,null,{"$f":"IF(I7=\"\",\"\",  IF( OR(H7=\"REW\",H7=\"LEW\"),     IF(I8=\"\", (I7-I6)/2, (I8-I7)/2),    ( (I7-I6)/2 + (I8-I7)/2) )  )","v":0.20000000000000018},4.0000000000000036E-2,4.4000000000000037E-3,null,"RPIN"]
[null,null,null,"Station Latitude / Longitude:","39.816792, -75.550789",null,4,null,3.7,0.2,0.16,null,null,"Transect to End of float (m):",null,null,null,null,0.19999999999999996,3.9999999999999994E-2,6.3999999999999994E-3,null,"LPIN"]
[null,null,null,"Date:","2018-01-23",null,5,null,3.9,0.18,0.25,null,null,"TOTAL Float Distance (m):",null,{"$f":"P7+P8","v":0},null,null,0.19999999999999973,3.5999999999999949E-2,8.9999999999999872E-3,null,"RTOB"]
[null,null,null,"Start Time in EST:","11:05:00",null,6,null,4.0999999999999996,0.26,0.25,null,null,"2. Time",null,null,null,null,0.19999999999999996,5.1999999999999991E-2,1.2999999999999998E-2,null,"LTOB"]
[null,null,null,"Stop Time in EST:","11:40:00",null,7,null,4.3,0.35,0.13,null,null,"Travel Time (sec):\nMeasure at least 5 Times","Time 1:",null,null,null,0.20000000000000018,7.0000000000000062E-2,9.1000000000000091E-3]
[null,null,null,"Staff Gauge Height (m):",0.37,null,8,null,4.5,0.3,0.25,null,null,null,"Time 2:",null,null,null,0.20000000000000018,6.0000000000000053E-2,1.5000000000000013E-2]
[null,null,null,"Recorded Sensor Depth (mm):",246,null,9,null,4.7,0.35,0.3,null,null,null,"Time 3:",null,null,null,0.20000000000000018,7.0000000000000062E-2,2.1000000000000019E-2]
[null,null,null,"Staff Gage/Sensor Offset (m):",0.124,null,10,null,4.9000000000000004,0.38,0.25,null,null,null,"Time 4:",null,null,null,0.19999999999999973,7.5999999999999901E-2,1.8999999999999975E-2]
[null,null,null,"Velocity Meter (if applicable):","Marsh-McBirney #2",null,11,null,5.0999999999999996,0.52,0.16,null,null,null,"Time 5:",null,null,null,0.19999999999999973,0.10399999999999987,1.6639999999999981E-2]
[null,null,null,"Calibration Date of Velocity Meter:","Fall 2017",null,12,null,5.3,0.53,0.1,null,null,null,"Time 6:",null,null,null,0.20000000000000018,0.10600000000000009,1.060000000000001E-2]
[null,null,null,null,null,null,13,null,5.5,0.57999999999999996,0.06,null,null,null,"Time 7:",null,null,null,0.20000000000000018,0.11600000000000009,6.9600000000000052E-3]
[null,null,null,"Other Notes:","Jeff C & Kim H did an additional measurement at the same time with the Swoffer #1 (Event 5).Unsure of reliableness of data since water level rose towards end of measurements",null,14,null,5.7,0.57999999999999996,0.03,null,null,null,"Time 8:",null,null,null,0.20000000000000018,0.11600000000000009,3.4800000000000026E-3]
[null,null,null,null,null,null,15,null,5.9,0.57999999999999996,0.01,null,null,null,"Time 9:",null,null,null,0.19999999999999973,0.11599999999999984,1.1599999999999985E-3]
[null,null,null,null,null,null,16,null,6.1,0.63,0,null,null,null,"Time 10:",null,null,null,0.19999999999999973,0.12599999999999983,0]
[null,null,null,null,null,null,17,null,6.3,0.38,0,null,null,null,null,null,null,null,0.20000000000000018,7.6000000000000068E-2,0]
[null,null,null,null,null,null,18,null,6.5,0.34,-0.01,null,null,"Mean Travel Time (sec):",null,{"$f":"IF(NumberTravelTimes > 0, AVERAGE(TravelTimes), 0)","v":0},null,null,0.20000000000000018,6.800000000000006E-2,-6.8000000000000059E-4]
[null,"_____\n5) If you measured velocities with a velocity meter, also fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.  \n______ \n6) If you used a neutrally buoyant object, instead, to measure velocity, fill out [Float Distance] and [Time] in the \"Neutral Buoyant Object Measurement\" section. \n______\n7) If you measured velocities with a hand-held flow meter, instead, fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.\n______\n8) If you did NOT measure any cross section data, fill out the [Predicted Stream Wetted Width] and [Predicted Wetted Cross Sectional Area] under the appropriate section where you took \"Alternative Data Inputs to Cross Section and Velocity Measurements\" \n-- Note: Data found on the*StageToAreaPredictor* spreadsheet\n______\n9) After you have finished entering your data, go back to the \"Rating Curve\" sheet.",null,null,null,null,19,null,6.7,0.36,-0.02,null,null,"Mean Transect Velocity (m/sec):",null,{"$f":"FloatDistance/MeanTravelTime*0.76","v":{"$error":"#DIV/0!"}},null,null,0.20000000000000018,7.2000000000000064E-2,-1.4400000000000014E-3]
[null,null,null,null,null,null,20,null,6.9,0.32,-0.03,null,null,"3. Area",null,null,null,null,0.19999999999999973,6.3999999999999918E-2,-1.9199999999999974E-3]
[null,null,null,null,null,null,21,null,7.1,0.4,-0.02,null,null,"Measured Values from Cross Section",null,null,null,null,0.22999999999999998,9.1999999999999998E-2,-1.8400000000000001E-3]
[null,null,null,null,null,null,22,"REW",7.36,0.35,-0.05,null,null,"Stream Wetted Width (m):",null,{"$f":"MeasuredWettedWidth","v":4.5600000000000005},null,null,0.13000000000000034,4.5500000000000117E-2,-2.2750000000000058E-3]
[null,null,null,null,null,null,23,null,null,null,null,null,null,"Cross Sectional Area (m2):",null,{"$f":"MeasuredCrossSectionalArea","v":1.6220000000000001},null,null,"","",""]
[null,null,null,null,null,null,24,null,null,null,null,null,null,"--- OR ---",null,null,null,null,"","",""]
[null,null,null,"Results",null,null,25,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,"Calculated Total Discharge (m3/s):",{"$f":"IF(HFMDischarge > 0, HFMDischarge, IF(AreaVelocityDischarge>0, AreaVelocityDischarge, NBODischarge))","v":0.127525},null,26,null,null,null,null,null,null," Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,27,null,null,null,null,null,null,"4. Result",null,null,null,null,"","",""]
[null,null,null,"Stream Wetted Width (m):",{"$f":"IF(WettedWidthFromSAP > 0, WettedWidthFromSAP, IF(MeasuredWettedWidth > 0, MeasuredWettedWidth, WettedWidthFromStage))","v":4.5600000000000005},null,28,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"IF(CrossSectionalAreaFromStage>0, CrossSectionalAreaFromStage*MeanVelocity, CrossSectionalArea*MeanVelocity)","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,"Stream Cross Sectional Area (m2):",{"$f":"IF(CrossSectionalAreaFromSAP > 0, CrossSectionalAreaFromSAP, IF(MeasuredCrossSectionalArea > 0, MeasuredCrossSectionalArea, CrossSectionalAreaFromStage))","v":1.6220000000000001},null,30,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,31,null,null,null,null,null,null,"Handheld Flow Meter Measurement",null,null,null,null,"","",""]
[null,null,null,null,null,null,32,null,null,null,null,null,null,"1. Velocity",null,null,null,null,"","",""]
[null,null,null,null,null,null,33,null,null,null,null,null,null,"Flow Velocity (m/sec):                         \nMeasure at least 5 Times","Velocity 1:",null,null,null,"","",""]
[null,null,null,null,null,null,34,null,null,null,null,null,null,null,"Velocity 2:",null,null,null,"","",""]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,"Velocity 3:",null,null,null,"","",""]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,"Velocity 4:",null,null,null,"","",""]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,"Velocity 5:",null,null,null,"","",""]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,"Velocity 6:",null,null,null,"","",""]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,"Velocity 7:",null,null,null,"","",""]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,"Velocity 8:",null,null,null,"","",""]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,"Velocity 9:",null,null,null,"","",""]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,"Velocity 10:",null,null,null,"","",""]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,44,null,null,null,null,null,null,"Mean Flow Meter Velocity (m/sec):",null,{"$f":"IF(NumberFlowTimes>0,AVERAGE(FlowTimes),0)","v":0},null,null,"","",""]
[null,null,null,null,null,null,45,null,null,null,null,null,null,"2. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,46,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,null,null,null,47,null,null,null,null,null,null,"Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,48,null,null,null,null,null,null,"3. Result",null,null,null,null,"","",""]
[null,null,null,null,null,null,49,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"MeanFlowMeterVelocity*CrossSectionalAreaFromSAP","v":0},null,null,"","",""]
[null,null,null,null,null,null,50,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,null,{"$f":"SUM(S$5:$S$54)","v":4.5600000000000005},{"$f":"SUM(T$5:$T$54)","v":1.6220000000000001},{"$f":"SUM(U$5:$U$54)","v":0.127525},"Total of Segments:"]

{"sheet":"Blank Discharge Form","index":9,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,1,0,2],[64,3,65,5],[66,3,88,5],[0,3,0,4],[28,3,28,4],[17,4,26,4],[1,1,21,2],[22,1,44,2],[0,7,0,11],[0,13,1,15],[0,18,0,20],[1,6,3,6],[29,13,29,14],[21,13,21,14],[22,13,22,14],[28,13,28,15],[27,13,27,16],[1,18,1,20],[49,13,49,15],[52,13,52,14],[6,13,6,14],[4,13,4,16],[10,13,18,13],[33,13,33,16],[34,13,34,16],[8,13,8,14],[24,13,24,15],[25,13,25,14],[26,13,26,14],[7,13,7,14],[31,13,31,14],[50,13,50,14],[36,13,45,13],[47,13,47,14]]}
[null,"Discharge Event Entry Form",null,"Basic Metadata",null,null,null,"Cross Section and Velocity Measurements",null,null,null,null,null,"Alternative Data Inputs to Cross Section and Velocity Measurements",null,null,null,null,"Segment Calculations"]
[null,"Starting-off Tutorial:\n1) In the new \"Discharge Day X\" sheet, enter as much data from the \"Stream Discharge Data\" sheet into the WHITE boxes.\n-- Note: You should not be able to modify any of the grey or blue boxes.\n_____\n2) Completely fill out the \"Basic Metadata\" section.\n-- Note: Be sure to enter all times in EASTERN STANDARD TIME (EST; UTC-5); if the time recorded on your \"Stream Discharge Data\" sheet was in Eastern Daylight Time (EDT; UTC-4), you should subtract one hour from that time.\n_____ \n3) Fill out the \"Cross Section and Velocity Measurments\" section with measurements only from right edge of water to left edge of water on your \"Stream Dischrage Data\" sheet.\n-- Note: Measurements between the water edges and the bank pins are not used to calculate discharge.\n_____\n4) If you measured a cross section, fill out [Points of Note], [Distance], [Water Depth] and [Comments] in the \"Cross Section and Velocity Measurements\" section.                                                                                      ",null,null,null,null,"Point ",null,null,null,null,null,null,null,null,null,null,null,"(Calculations from Cross Section and Velocity Measurements)"]
[null,null,null,"Measurement Completed By:"]
[null,null,null,null,null,null,null,"Points of note:","Distance (m)","Water Depth (m)","Velocity (m/s)","Comment",null,null,null,null,null,null,"Segment Width (m)","Segment Area (m2)","Segment Discharge (m3/s)",null,"Possible Notes"]
[null,null,null,"Stream Name:",null,null,1,null,null,null,null,null,null,"Neutral Buoyant Object Measurement",null,null,null,null,{"$f":"IF(I5=\"\",\"\",  IF( OR(H5=\"REW\",H5=\"LEW\"),     IF(I6=\"\", (I5-I4)/2, (I6-I5)/2),    ( (I5-I4)/2 + (I6-I5)/2) )  )","v":""},{"$f":"IF(I5=\"\",\"\",S5*J5)","v":""},{"$f":"IF(K5=\"\",\"\",T5*K5)","v":""},null,"REW"]
[null,null,null,"Location:",null,null,2,null,null,null,null,null,null,"1. Distance",null,null,null,null,{"$f":"IF(I6=\"\",\"\",  IF( OR(H6=\"REW\",H6=\"LEW\"),     IF(I7=\"\", (I6-I5)/2, (I7-I6)/2),    ( (I6-I5)/2 + (I7-I6)/2) )  )","v":""},"","",null,"LEW"]
[null,null,null,"SiteID:",null,null,3,null,null,null,null,null,null,"Start of float to Transect (m):",null,null,null,null,{"$f":"IF(I7=\"\",\"\",  IF( OR(H7=\"REW\",H7=\"LEW\"),     IF(I8=\"\", (I7-I6)/2, (I8-I7)/2),    ( (I7-I6)/2 + (I8-I7)/2) )  )","v":""},"","",null,"RPIN"]
[null,null,null,"Station Latitude / Longitude:",null,null,4,null,null,null,null,null,null,"Transect to End of float (m):",null,null,null,null,"","","",null,"LPIN"]
[null,null,null,"Date:",null,null,5,null,null,null,null,null,null,"TOTAL Float Distance (m):",null,{"$f":"P7+P8","v":0},null,null,"","","",null,"RTOB"]
[null,null,null,"Start Time in EST:",null,null,6,null,null,null,null,null,null,"2. Time",null,null,null,null,"","","",null,"LTOB"]
[null,null,null,"Stop Time in EST:",null,null,7,null,null,null,null,null,null,"Travel Time (sec):\nMeasure at least 5 Times","Time 1:",null,null,null,"","",""]
[null,null,null,"Staff Gauge Height (m):",null,null,8,null,null,null,null,null,null,null,"Time 2:",null,null,null,"","",""]
[null,null,null,"Recorded Sensor Depth (mm):",null,null,9,null,null,null,null,null,null,null,"Time 3:",null,null,null,"","",""]
[null,null,null,"Staff Gage/Sensor Offset (m):",null,null,10,null,null,null,null,null,null,null,"Time 4:",null,null,null,"","",""]
[null,null,null,"Velocity Meter (if applicable):",null,null,11,null,null,null,null,null,null,null,"Time 5:",null,null,null,"","",""]
[null,null,null,"Calibration Date of Velocity Meter:",null,null,12,null,null,null,null,null,null,null,"Time 6:",null,null,null,"","",""]
[null,null,null,null,null,null,13,null,null,null,null,null,null,null,"Time 7:",null,null,null,"","",""]
[null,null,null,"Other Notes:",null,null,14,null,null,null,null,null,null,null,"Time 8:",null,null,null,"","",""]
[null,null,null,null,null,null,15,null,null,null,null,null,null,null,"Time 9:",null,null,null,"","",""]
[null,null,null,null,null,null,16,null,null,null,null,null,null,null,"Time 10:",null,null,null,"","",""]
[null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,18,null,null,null,null,null,null,"Mean Travel Time (sec):",null,{"$f":"IF(NumberTravelTimes > 0, AVERAGE(TravelTimes), 0)","v":0},null,null,"","",""]
[null,"_____\n5) If you measured velocities with a velocity meter, also fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.  \n______ \n6) If you used a neutrally buoyant object, instead, to measure velocity, fill out [Float Distance] and [Time] in the \"Neutral Buoyant Object Measurement\" section. \n______\n7) If you measured velocities with a hand-held flow meter, instead, fill out the [Velocity] in the \"Cross Section and Velocity Measurements\" section.\n______\n8) If you did NOT measure any cross section data, fill out the [Predicted Stream Wetted Width] and [Predicted Wetted Cross Sectional Area] under the appropriate section where you took \"Alternative Data Inputs to Cross Section and Velocity Measurements\" \n-- Note: Data found on the*StageToAreaPredictor* spreadsheet\n______\n9) After you have finished entering your data, go back to the \"Rating Curve\" sheet.",null,null,null,null,19,null,null,null,null,null,null,"Mean Transect Velocity (m/sec):",null,{"$f":"FloatDistance/MeanTravelTime*0.76","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,20,null,null,null,null,null,null,"3. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,21,null,null,null,null,null,null,"Measured Values from Cross Section",null,null,null,null,"","",""]
[null,null,null,null,null,null,22,null,null,null,null,null,null,"Stream Wetted Width (m):",null,{"$f":"MeasuredWettedWidth","v":0},null,null,"","",""]
[null,null,null,null,null,null,23,null,null,null,null,null,null,"Cross Sectional Area (m2):",null,{"$f":"MeasuredCrossSectionalArea","v":0},null,null,"","",""]
[null,null,null,null,null,null,24,null,null,null,null,null,null,"--- OR ---",null,null,null,null,"","",""]
[null,null,null,"Results",null,null,25,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,"Calculated Total Discharge (m3/s):",{"$f":"IF(HFMDischarge > 0, HFMDischarge, IF(AreaVelocityDischarge>0, AreaVelocityDischarge, NBODischarge))","v":{"$error":"#DIV/0!"}},null,26,null,null,null,null,null,null," Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,27,null,null,null,null,null,null,"4. Result",null,null,null,null,"","",""]
[null,null,null,"Stream Wetted Width (m):",{"$f":"IF(WettedWidthFromSAP > 0, WettedWidthFromSAP, IF(MeasuredWettedWidth > 0, MeasuredWettedWidth, WettedWidthFromStage))","v":0},null,28,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"IF(CrossSectionalAreaFromStage>0, CrossSectionalAreaFromStage*MeanVelocity, CrossSectionalArea*MeanVelocity)","v":{"$error":"#DIV/0!"}},null,null,"","",""]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,"Stream Cross Sectional Area (m2):",{"$f":"IF(CrossSectionalAreaFromSAP > 0, CrossSectionalAreaFromSAP, IF(MeasuredCrossSectionalArea > 0, MeasuredCrossSectionalArea, CrossSectionalAreaFromStage))","v":0},null,30,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,31,null,null,null,null,null,null,"Handheld Flow Meter Measurement",null,null,null,null,"","",""]
[null,null,null,null,null,null,32,null,null,null,null,null,null,"1. Velocity",null,null,null,null,"","",""]
[null,null,null,null,null,null,33,null,null,null,null,null,null,"Flow Velocity (m/sec):                         \nMeasure at least 5 Times","Velocity 1:",null,null,null,"",{"$f":"IF(I37=\"\",\"\",S37*J37)","v":""},{"$f":"IF(K37=\"\",\"\",T37*K37)","v":""}]
[null,null,null,null,null,null,34,null,null,null,null,null,null,null,"Velocity 2:",null,null,null,"","",""]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,"Velocity 3:",null,null,null,"","",""]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,"Velocity 4:",null,null,null,"","",""]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,"Velocity 5:",null,null,null,"","",""]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,"Velocity 6:",null,null,null,"","",""]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,"Velocity 7:",null,null,null,"","",""]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,"Velocity 8:",null,null,null,"","",""]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,"Velocity 9:",null,null,null,"","",""]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,"Velocity 10:",null,null,null,"","",""]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,44,null,null,null,null,null,null,"Mean Flow Meter Velocity (m/sec):",null,{"$f":"IF(NumberFlowTimes>0,AVERAGE(FlowTimes),0)","v":0},null,null,"","",""]
[null,null,null,null,null,null,45,null,null,null,null,null,null,"2. Area",null,null,null,null,"","",""]
[null,null,null,null,null,null,46,null,null,null,null,null,null,"Estimated Values from Stage to Area Predictor",null,null,null,null,"","",""]
[null,null,null,null,null,null,47,null,null,null,null,null,null,"Predicted Wetted Cross Sectional Area (m2):",null,null,null,null,"","",""]
[null,null,null,null,null,null,48,null,null,null,null,null,null,"3. Result",null,null,null,null,"","",""]
[null,null,null,null,null,null,49,null,null,null,null,null,null,"Total Discharge (m3/sec):",null,{"$f":"MeanFlowMeterVelocity*CrossSectionalAreaFromSAP","v":0},null,null,"","",""]
[null,null,null,null,null,null,50,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,null,{"$f":"SUM(S$5:$S$54)","v":0},{"$f":"SUM(T$5:$T$54)","v":0},{"$f":"SUM(U$5:$U$54)","v":0},"Total of Segments:"]