{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["INSTRUCTIONS","Index to output","SETTINGS","SCENARIOS","EFLOWS","SUMMARY","YEAR","QMAX","QMEAN","QMIN","Q50","Q90","Q10","NO_FLOW_DAYS","HIGH_NUM","HIGH_DUR","LOW_NUM","LOW_DUR","PDC50","BFR","SFR","CV_LOG_DAILY","MONTH_MAX","MONTH_MIN","VAR_MONTH","MONTHQ","MONTH_EVENTS","MONTHLY_QMEAN","BIOPERIODS","100_DAY_STATS","QDAILY","TEMP"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":4,"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":8,"n_cols":26,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"INSTRUCTIONS"]
["1.","Enter conversion factor for units (if any), minimum number of years and days for processing, and the first month of low-flow years in SETTINGS worksheet."]
["2.","Specify SCENARIOS, confirm environmental flow option (either 0 or 1)."]
["3.","Verify that files names listed in SCENARIOS are correct and in the current directory. "]
["4.","Specify appropriations, environmental flow standards, and additional allocations in EFLOWS worksheet for environmental flow option if selected for any scenario."]
["5.","Run macro from menus or use ctrl+e"]
[]
[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":"360*24/43560","v":0.19834710743801653}]

{"sheet":"Index to output","index":1,"n_rows":84,"n_cols":3,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Sheet","Variable","Description with units [ ]"]
["SUMMARY","Years","Number of years in the period of analysis"]
[null,"Mean streamflow","Mean streamflow for the period of analysis [L3/T]"]
[null,"Q01","Streamflow exceeded 1 percent of the time [L3/T]"]
[null,"Q10","Streamflow exceeded 10 percent of the time [L3/T]"]
[null,"Q25","Streamflow exceeded 25 percent of the time [L3/T]"]
[null,"Q50","Streamflow exceeded 50 percent of the time [L3/T]"]
[null,"Q75","Streamflow exceeded 75 percent of the time [L3/T]"]
[null,"Q90","Streamflow exceeded 90 percent of the time [L3/T]"]
[null,"Q99","Streamflow exceeded 99 percent of the time [L3/T]"]
[null,"50th percentile of absolute value of percent daily change","Median absolute value of percent daily change in streamflow for the period of record [fraction of daily streamflow]"]
[null,"Coefficient of variation of daily flows","Standard deviation of daily streamflow divided by mean streamflow [multiples of mean streamflow]"]
[null,"Coefficient of variation of log-transformed daily flows","Coefficient of variation of log transformed daily streamflow"]
[null,"Coefficient of variation of log-transformed annual maximum flow","Coefficient of variation of log transformed annual maximum daily streamflow"]
[null,"Median annual maximum streamflow","Median annual maximum daily streamflow [L3/T]"]
[null,"Qmax/Q50","Median annual maximum daily streamflow divided by median streamflow"]
[null,"Median annual number of high-flow events","Median annual number of times that streamflow exceeds the specified high-flow threshold [events per year]"]
[null,"Median duration of the annual longest high-flow event","Median annual duration of the longest high flow period [days]"]
[null,"Number of months with annual probability >0.5 of having a high-flow event","Number of months with daily flow exceeding the high-flow threshold in more than half of the years in the period for analysis [number of months, maximum of 12]"]
[null,"Mode of highest streamflow month","Most common month of maximum monthly mean flow"]
[null,"Median annual minimum streamflow","Median annual miniimum daily streamflow [L3/T]"]
[null,"Qmin/Q50","Median annual miniimum daily streamflow divided by median streamflow"]
[null,"Coefficient of variation of annual minimum streamflow","Coefficient of variation of annual minimum daily streamflow"]
[null,"Median annual number of low-flow periods","Median annual number of times that streamflow is less the specified low-flow threshold [events per year]"]
[null,"Median duration of the annual longest low-flow period","Median annual duration of the longest low-flow period [days]"]
[null,"Number of months with annual probability >0.5 of having a low-flow period","Number of months with daily flows less than the low-flow threshold in more than half of the years in the period for analysis [number of months,maximum of 12]"]
[null,"Mode of lowest flow month","Most common month of minimum monthly mean flow"]
[null,"Fraction of years with no-flow days","Fraction of years in the period of record with one or more days when flow was equal to zero"]
[null,"Mean number of no-flow days in years with no-flow days","Mean number of days when flow was equal to zero for years with no-flow days"]
[null,"Coefficient of variation of annual mean streamflow","Standard deviation of annual mean streamflow divided  by mean streamflow [multiples of mean streamflow]"]
[null,"Storm-flow recession coefficient (SFR)","Median annual value of the 10th percentile of percent daily change for days when change in flow was less than or equal to zero"]
[null,"Base-flow recession coefficient (BFR)","Median annual value of the 50th percentile of percent daily change for days when change in flow as less than or equal to zero"]
[null,"Maximum monthly streamflow","Maximum of monthly mean streamflow"]
[null,"Minimum monthly streamflow","Minimum of monthly mean streamflow"]
[null,"Maximum CV of monthly streamflow","Maximum coefficient of varation of annual monthly mean streamflow (e.g., annual values of October mean streamflow)"]
[null,"Minimum CV of monthly streamflow","Minimum coefficient of varation of annual monthly mean streamflow (e.g., annual values of October mean streamflow)"]
[null,"Normalized range of monthly streamflow","Median annual difference between maximum monthly mean flow and minimum monthly mean flow divided by mean flow"]
[null,"LOG(Q10/Q90)","Logarthim (base 10) of Q10/Q90"]
[null,"Hydroperiod","Fraction of days with flow greater than zero"]
[]
["Sheets with annual values of each streamflow statistic",null,"All of these are annual values, corresponding year can be found on the same line in the sheet \"YEAR\""]
["YEAR",null,"Water year index, the row and column of annual statistics on other sheets reference the water year in the same row and column on this sheet [WATER YEAR]"]
["QMAX",null,"Maximum streamflow [L3/T]"]
["QMEAN",null,"Mean streamflow [L3/T]"]
["QMIN",null,"Minimum daily streamflow [L3/T]"]
["NO_FLOW_DAYS",null,"Number of days with no flow [days]"]
["HIGH_NUM",null,"Number of high streamflow events (continuous periods exceeding high flow threshold) [number of events per year]"]
["HIGH_DUR",null,"Longest duration of a high flow  [days]"]
["LOW_NUM",null,"Number of low flow periods"]
["LOW_DUR",null,"Longest duration of a low flow period [days]"]
["PDC50",null,"Median percent daily change in streamflow [fraction]"]
["SFR",null,"10th percentile of percent daily change for days when change in flow was less than or equal to zero"]
["BFR",null,"50tyh percentile of percent daily change for days when change in flow as less than or equal to zero"]
["CV_LOG_DAILY",null,"Coefficient of variation calculated from log transformed values [dimensionless]"]
["MONTH MAX",null,"Month of maximum daily flow"]
["MONTH MIN",null,"Month of minimum daily flow"]
["VAR_MONTH",null,"Range of log-transformed mean monthly flow [log(L3/T)]"]
[]
["Sheets with monthly summary statistics"]
["MONTHQ",null,"Monthly mean streamflows (e.g., mean of all daily streamflow in October ) [L3/T]"]
[null,null,"Coefficient of variation of annual monthly mean streamflow (e.g., cv of annual values of October mean streamflow)"]
[null,null,"Median of monthly streamflow (e.g., the median of the annual values of mean streamflow for each October in the period of analysis) [L3/T]"]
["MONTH_EVENTS","MEDHIGHDUR","The median annual total duration of high flows in each month"]
[null,"FRACTION OF YEARSWITHHIGHFLOWEVENTS","The fraction of years with high flow events in each month"]
[null,"MEDLOWDUR","The median annual total duration of low flows in each month"]
[null,"FRACTION OF YEARSWITHLOWFLOWEVENTS","The fraction of years with low flow events in each month"]
["MONTHLY QMEAN",null,"A time series of monthly mean flows for each month in the period of analysis."]
[]
["Other sheets"]
["BIOPERIODS","Environmental flow standard by bioperiod","Maximum flow rate that is protected in each bioperiod (does not apply to standards based on a percent of daily flow)"]
[null,"Additional allocation by bioperiod","Flow rate that is allocated to out-of-stream use after protection in each bioperiod."]
["100_DAY_STATS",null,"Mean, maximum, and minimum daily flows, duration of high flows, duration of low flows,and mean percent daily change for 100 days prior to the date specified on SCENARIOS"]
["QDAILY",null,"Daily streamflow"]
[]
["Output files"]
["[Station ID]_MONTH.CSV",null,"A time series of monthly flow statistics for each month in the period of analysis"]
[null,"Column 1","Minimum daily streamflow for each month in the period of analysis  [L3/T]"]
[null,"Column 2","Median daily streamflow for each month in the period of analysis  [L3/T]"]
[null,"Column 3","Mean daily streamflow for each month in the period of analysis [L3/T]"]
[null,"Column 4","Maximum daily streamflow for each month in the period of analysis [L3/T]"]
[null,"Column 5","Number of high streamflow events in the month [number of events]"]
[null,"Column 6","Duration of low streamflow during the month [days]"]
[]
["[Station ID]_FLOWDUR.CSV",null,"Streamflow equalled or exceeded for the specified fraction of time from 0.001 to 1 [L3/T]"]

{"sheet":"SETTINGS","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Settings: enter a value into blue cells, B2:B5","Specify option","Default"]
["Units conversion factor: use 0.02832 to convert from cubic feet per second to cubic meters per second; use 1 to keep output units the same as input units",{"$f":"1/35.31","v":2.8320589068252619E-2},{"$f":"1/35.31","v":2.8320589068252619E-2}]
["Minimum number of years in the period of analysis required for each site. Note that if the period of analysis on the settings sheet is less than the minimum number of years, statistics will not be calculated for the site.",1,10,"years"]
["Minimum number of days in each water years for that water year to be included in calculations. For example, if the user wants to include years with up to 10 missing days, then 355 would be entered in B4.",360,365,"days"]
["First month for of year for calculating low flow statistics. Annual low-flow statistics should be calculated for over 12 months beginning with a month unlikely to have low flows. Low flow statistics are commonly calculated based on  climate years starting in April (4), water years starting in October (10), or calendar years starting in January (1); values other than 10 will result in one less annual low flow statistic that the period of analysis.",1,4,"4-April, 10-October, 1-January"]

{"sheet":"SCENARIOS","index":3,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["SCENARIO","FILE NAME FOR STREAMFLOW DATA","START YEAR","END YEAR","NWIS FILE (0-No, 1-Yes)","QMEAN COLUMN NUMBER (6-NWIS daily mean flow, 10-NWIS daily max, min, mean flow)","YEAR COLUMN NUMBER","MONTH COLUMN NUMBER","DAY COLUMN NUMBER","NUMBER OF HEADER LINES","TYPE OF THRESHOLD FOR HIGH FLOW EVENTS (1 - streamflow rate, 2 - exceedence duration expressed as fraction of time that flow is exceeded)","HIGH FLOW THRESHOLD (enter units of streamflow after any conversion or fraction of time exceeded such as 0.1)","TYPE OF THRESHOLD FOR LOW FLOW EVENTS (1 - streamflow rate, 2 - exceedence duration expressed as fraction of time that flow is exceeded)","LOW FLOW THRESHOLD (enter units of streamflow after any conversion or fraction of time exceeded such as 0.9)","ENVIRONMENTAL FLOW CALCULATIONS (0 - No, 1 - Yes; specify details on EFLOWS worksheet)","Bioperiod 1: the starting day of the year for each bioperiod that can represent months, times of the year associated with distinct life stages for biota , irrigation seasons, or other intra-annual patterns; if January, enter 1","Bioperiod 2: if February, then enter 32","Bioperiod 3: if March, then enter 60","Bioperiod 4: if April, then enter 91","Bioperiod 5: if May then enter 121","Bioperiod 6: if June, then enter 152","Bioperiod 7: if July, then enter 182","Bioperd 8: if August, then enter 213","Bioperiod 9: if September, then enter 244","Bioperiod 10: if October, then enter 274","Bioperiod 11: if November, then enter 305","Bioperiod 12: if December, then enter 335","Write daily streamflow to Daily Output worksheet? (0-No, 1-Yes)","Write monthly time series and flow duration files? (0-No, 1-Yes)","START DATE FOR 100-DAY STATISTICS (YYYY-MM-DD)"]
[null,null,null,null,"Enter 0 or 1","Enter column number","Not needed for NWIS files",null,null,null,"Enter 1 or 2",null,"Enter 1 or 2","Enter magnitude or duration","Enter 0 or 1",1,32,60,91,121,152,182,213,244,274,305,335,"Enter 0 or 1","Enter 0 or 1","Optional, enter date (YYYY-MM-DD)"]

{"sheet":"EFLOWS","index":4,"n_rows":2,"n_cols":43,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["SCENARIO","FILE NAME FOR STREAMFLOW DATA","START YEAR","END YEAR","PRIORITY ALLOCATION BASIS:  an integer code corresponding to a streamflow statistic that provides a basis for environmental flow standard:  \n0 - no priority allocation; \n1 - daily streamflow; \n2 - mean streamflow; \n3 - streamflow exceeded for specified fraction of period of analysis; \n4 - flow exceeded for specified fraction of each bioperiod; \n5 - mean streamflow for bioperiod; \n6 -10th percentile of the annual series of 7-day minimum streamflow (estimate of 10-year, 7-day low flow or \"7Q10\"); or \n7 - fixed amount to be entered into each month.","PRIORITY ALLOCATION IN BIOPERIOD 1: Fraction of the streamflow statistic specified in previous column or fixed rate for the priority allocation for bioperiod 1","Priority allocation in bioperiod 2","Priority allocation in bioperiod 3","Priority allocation in bioperiod 4","Priority allocation in bioperiod 5","Priority allocation in bioperiod 6","Priority allocation in bioperiod 7","Priority allocation in bioperiod 8","Priority allocation in bioperiod 9","Priority allocation in bioperiod 10","Priority allocation in bioperiod 11","Priority allocation in bioperiod 12","ENVIRONMENTAL FLOW BASIS:  an integer code corresponding to a streamflow statistic that provides a basis for environmental flow standard:  \n0 - no environmental flow standard; \n1 - daily streamflow; \n2 - mean streamflow; \n3 - streamflow exceeded for specified fraction of period of analysis; \n4 - flow exceeded for specified fraction of each bioperiod;\n5 - mean streamflow for bioperiod; \n6 -10th percentile of the annual series of 7-day minimum streamflow (estimate of 10-year, 7-day low flow or \"7Q10\"); or \n7 - fixed amount to be entered into each bioperiod.","ENVIRONMENTAL FLOW STANDARD IN BIOPERIOD 1: Fraction of the streamflow statistic specified in previous column or fixed rate for the environmental flow standard for bioperiod 1","Environmental flow standard in bioperiod 2","Environmental flow standard in bioperiod 3","Environmental flow standard in bioperiod 4","Environmental flow standard in bioperiod 5","Environmental flow standard in bioperiod 6","Environmental flow standard in bioperiod 7","Environmental flow standard in bioperiod 8","Environmental flow standard in bioperiod 9","Environmental flow standard in bioperiod 10","Environmental flow standard in bioperiod 11","Environmental flow standard in bioperiod 12","ADDITIONAL ALLOCATION BASIS: an integer code corresponding to a statistic used for additional allocation above prior appropriation:  \n0 - no additional allocation; \n1 - daily streamflow; \n2 - mean streamflow; \n3 - streamflow exceeded for specified fraction of period of analysis; \n4 - flow exceeded for specified fraction of each bioperiod; \n5 - mean streamflow for bioperiod; \n6 -10th percentile of the annual series of 7-day minimum streamflow (estimate of 10-year, 7-day low flow or \"7Q10\"); or \n7 - fixed amount to be entered into each bioperiod.","ADDITIONAL ALLOCATION: Fraction of statistic used for additional out-of-stream allocation or fixed amount of out-stream allocation for each bioperiod.","Additional allocation in bioperiod 2","Additional allocation in bioperiod 3","Additional allocation in bioperiod 4","Additional allocation in bioperiod 5","Additional allocation in bioperiod 6","Additional allocation in bioperiod 7","Additional allocation in bioperiod 8","Additional allocation in bioperiod 9","Additional allocation in bioperiod 10","Additional allocation in bioperiod 11","Additional allocation in bioperiod 12"]
[{"$f":"SCENARIOS!A2","v":0},{"$f":"SCENARIOS!B2","v":0},{"$f":"SCENARIOS!C2","v":0},{"$f":"SCENARIOS!D2","v":0},"Enter 0, 1, 2, 3, 4, 5, 6, or 7","Enter fraction or fixed rate",null,null,null,null,null,null,null,null,null,null,null,"Enter 0, 1, 2, 3, 4, 5, 6, or 7","Enter fraction or fixed rate",null,null,null,null,null,null,null,null,null,null,null,"Enter 0, 1, 2, 3, 4, 5, 6, or 7","Enter fraction or fixed rate"]

{"sheet":"SUMMARY","index":5,"n_rows":2,"n_cols":39,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["SCENARIO","Years","Mean streamflow","Q01","Q10","Q25","Q50","Q75","Q90","Q99","50th percentile of absolute value of percent daily change","Coefficient of variation of daily flows","Coefficient of variation of log-transformed daily flows","Coefficient of variation of log-transformed annual maximum flow","Median annual maximum streamflow","Qmax/Q50","Median annual number of high-flow events","Median duration of the annual longest high-flow event","Number of months with annual probability >0.5 of having a high-flow event","Mode of highest streamflow month","Median annual minimum streamflow","Qmin/Q50","Coefficient of variation of annual minimum streamflow","Median annual number of low-flow periods","Median duration of the annual longest low-flow period","Number of months with annual probability >0.5 of having a low-flow period","Mode of lowest flow month","Fraction of years with no-flow days","Mean number of no-flow days in years with no-flow days","Coefficient of variation of annual mean streamflow","Storm-flow recession coefficient (SFR)","Base-flow recession coefficient (BFR)","Maximum monthly streamflow","Minimum monthly streamflow","Maximum CV of monthly streamflow","Minimum CV of monthly streamflow","Normalized range of monthly streamflow","LOG(Q10/Q90)","Hydroperiod"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(QMAX!B2:GS2)>0,MEDIAN(QMAX!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(G2>0,O2/G2,\"NA\")","v":"NA"},{"$f":"IF(COUNT(HIGH_NUM!B2:GS2)>0,MEDIAN(HIGH_NUM!$B2:$GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(HIGH_DUR!B2:GS2)>0,MEDIAN(HIGH_DUR!$B2:$GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTH_EVENTS!O2:Z2)>0,COUNTIF(MONTH_EVENTS!O2:Z2,\">0.5\"),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTH_MAX!B2:GS2)>1,MODE(MONTH_MAX!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(QMIN!B2:GS2)>0,MEDIAN(QMIN!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(G2>0,U2/G2,\"NA\")","v":"NA"},{"$f":"IF(COUNT(QMIN!B2:GS2)>1,STDEV(QMIN!B2:GS2)/AVERAGE(QMIN!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(LOW_NUM!B2:GS2)>0,MEDIAN(LOW_NUM!$B2:$GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(LOW_DUR!B2:G2)>0,MEDIAN(LOW_DUR!$B2:$GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTH_EVENTS!A2:AZ2)>0,COUNTIF(MONTH_EVENTS!AO2:AZ2,\">0.5\"),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTH_MIN!B2:GS2)>1,MODE(MONTH_MIN!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(NO_FLOW_DAYS!B2:GS2)>0,COUNTIF(NO_FLOW_DAYS!B2:GS2,\">0\")/B2,\"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(SUMMARY!AB2),IF(AB2>0,SUM(NO_FLOW_DAYS!B2:GS2)/COUNTIF(NO_FLOW_DAYS!B2:GS2,\">0\"),0),\"NA\")","v":"NA"},{"$f":"IF(COUNT(QMEAN!B2:GS2)>1,STDEV(QMEAN!B2:GS2)/SUMMARY!C2,\"NA\")","v":"NA"},{"$f":"IF(COUNT(SFR!B2:GS2)>0,MEDIAN(SFR!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(BFR!B2:GS2)>0,MEDIAN(BFR!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTHQ!B2:M2)>0,MAX(MONTHQ!B2:M2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTHQ!B2:M2)>0,MIN(MONTHQ!B2:M2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTHQ!O2:Z2)>0,MAX(MONTHQ!O2:Z2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(MONTHQ!O2:Z2)>0,MIN(MONTHQ!O2:Z2),\"NA\")","v":"NA"},{"$f":"IF(COUNT(VAR_MONTH!B2:GS2)>0,MEDIAN(VAR_MONTH!B2:GS2),\"NA\")","v":"NA"},{"$f":"IF(I2>0,LOG(E2/I2),\"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(AB2),1-AB2*AC2/365,\"NA\")","v":"NA"}]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{"sheet":"MONTHQ","index":25,"n_rows":2,"n_cols":39,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Mean monthly streamflow",null,null,null,null,null,null,null,null,null,null,null,null,"CV annual monthly mean streamflow",null,null,null,null,null,null,null,null,null,null,null,null,"Median annual monthly mean streamflow"]
[null,"October","November","December","January","February","March","April","May","June","July","August","September",null,"October","November","December","January","February","March","April","May","June","July","August","September",null,"October","November","December","January","February","March","April","May","June","July","August","September"]

{"sheet":"MONTH_EVENTS","index":26,"n_rows":2,"n_cols":52,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"MEDHIGHDUR",null,null,null,null,null,null,null,null,null,null,null,null,"FRACTION OF YEARSWITHHIGHFLOWEVENTS",null,null,null,null,null,null,null,null,null,null,null,null,"MEDLOWDUR",null,null,null,null,null,null,null,null,null,null,null,null,"FRACTION OF YEARSWITHLOWFLOWEVENTS"]
[null,"October","November","December","January","February","March","April","May","June","July","August","September",null,"October","November","December","January","February","March","April","May","June","July","August","September",null,"October","November","December","January","February","March","April","May","June","July","August","September",null,"October","November","December","January","February","March","April","May","June","July","August","September"]

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

{"sheet":"BIOPERIODS","index":28,"n_rows":2,"n_cols":28,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Priority allocation",null,null,null,null,null,null,null,null,null,null,null,null,"Environmental flow standard",null,null,null,null,null,null,null,null,null,null,null,null,"Additional allocation allowed"]
["Bioperiod",1,2,3,4,5,6,7,8,9,10,11,12,null,1,2,3,4,5,6,7,8,9,10,11,12]

{"sheet":"100_DAY_STATS","index":29,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Streamflow statistics for 100 days prior to date listed on scenario sheet","Mean streamflow","Maximum streamflow","Minimum streamflow","Duration of high flows","Duration of low flows","Percent daily change"]

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

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