Streamflow sequences for each of three drought scenarios developed to characterize plausible future drought conditions in the Colorado River Basin described by Salehabadi, Tarboton et al. (2020). 

Generated streamflow traces (Monthly and Annual) for each drought scenario are available as Excel files. 

      •   MillenniumDrought_2000-2018_Monthly.xlsx
      •   Mid20thCenturyDrought_1953-1977_Monthly.xlsx
      •   PaleoTreeRingDrought_1576-1600_Monthly.xlsx

      •   MillenniumDrought_2000-2018_AnnualWaterYear.xlsx
      •   Mid20thCenturyDrought_1953-1977_AnnualWaterYear.xlsx
      •   PaleoTreeRingDrought_1576-1600_AnnualWaterYear.xlsx

Each Excel file is comprised of 100 sheets, each containing a 42-year sequence (Trace) of monthly or annual streamflow at each of the 29 CRSS sites. USGS Gage Numbers (Streamflow Gaging site number) are used to identify each CRSS natural inflow site (ID = 1 to 29) for which flow is simulated. The corresponding USGS Gage Numbers and CRSS site IDs and a map of their locations are provided in an Excel file (USGSGages_CRSSSites_CorrespondingIDs.xlsx).

In the Excel files for the Millennium and Mid 20th Century droughts the first two columns (A and B) hold the water year and month selected from historic flows to simulate that year.  The remaining columns hold intervening natural flow for the corresponding site, in acre-ft.  Intervening natural flow is the streamflow originating in the subwatershed draining directly to that site without first flowing past any upstream site.  For the Paleo Tree-Ring drought the Excel file has three leading columns.  Column A (wy_TR) holds the tree-ring reconstruction year sampled for that trace year.  Columns B and C hold the water year and month selected from historic flows as being closest to the tree-ring flow at Lees Ferry.  The remaining columns hold intervening natural flow for the corresponding site, after adjustment by the ratio of paleo flow to closest historic flow. 

The files described above were produced using R code, the US Bureau of Reclamation Natural Flow Data Base Excel file, and Tree-Ring Reconstructed flow at Lees Ferry from the most skillful model of Meko et al., 2017.  For reproducibility the R scripts used, and the input data are saved in the Folder WYBlockDisagg that has the following files:
      •   WaterYearBlockDisaggregation_HistoricScenario.R.  R code to generate the monthly streamflow traces based on historic drought scenarios.
      •   WaterYearBlockDisaggregation_PaleoTreeRingScenario.R.  R code to generate the monthly streamflow traces based on tree ring drought scenarios.
      •   NaturalFlows1906-2018_20200110.xlsx.  Natural Flow Data Base, version 1/10/2020 from U.S. Bureau of Reclamation, (2020), https://www.usbr.gov/lc/region/g4000/NaturalFlow/current.html.
      •   TreeRingFlowLeesFerry.xlsx. Tree Ring Reconstructed Flow at Lees Ferry (Most skillful model of Meko et al., 2017) from https://www.treeflow.info/content/upper-colorado. 

-----------------------
References

Meko, D. M., C. A. Woodhouse and E. R. Bigio, (2017), "Southern California Tree-Ring Study," California Department of Water Resources, https://pdfs.semanticscholar.org/fbaf/487604e2537c8f51037035e59c13113edeeb.pdf.

Salehabadi, H., D. Tarboton, E. Kuhn, B. Udall, K. Wheeler, D. Rosenberg, S. Goeking and J. C. Schmidt, (2020), "The Future Hydrology of the Colorado River Basin," Center for Colorado River Studies, White Paper 4, Utah State University, https://qcnr.usu.edu/coloradoriver/files/WhitePaper4.pdf.

U.S. Bureau of Reclamation, (2020), Colorado River Basin Natural Flow and Salt Data, Colorado River Basin Natural Flow Database. Last modified January 10, 2020, https://www.usbr.gov/lc/region/g4000/NaturalFlow/current.html