Laserfiche WebLink
<br />'OOlU23 <br /> <br />CROSS ADMINISTRATION TOOL <br />COLORADO RIVER <br />SPECIAL PROJECT TASK <br /> <br />Backl!round <br /> <br />The U.S. Bureau of Reclamation currently maintains the, "Colorado River <br />Accounting Spreadsheet" (CRA Spreadsheet) required by Senate 80 and the "Blue River <br />Decrees." The Division Engineer also uses information required by the spreadsheet to <br />help administer the Colorado River and in particular to help determine the replacement <br />releases from the Green Mountain Reservoir Historic Users Pool. Presently, the CRA <br />spreadsheet is in need of revision to include new projects that need to be considered in the <br />accounting. Also, we would like to automate the process more. Finally, we would like <br />the information to feed directly into the process that the Division Engineer uses to <br />administer the Colorado River and determine the Green Mountain Reservoir Historic <br />User Pool releases. <br /> <br />Vision <br /> <br />The vision is to have each of the following water users feed thcir respective <br />project operation accounting spreadsheets directly into the CRDSS Administrative Tool. <br />The CRDSS Administrative Tool would then take key data from these accounting <br />spreadsheets, all of which will be done in "excel", into the CRA spreadsheet. The CRA <br />spreadsheet would then automatically complete itself and provide a real time pictu[e of <br />overall river operations. Additionally, key information from the project operation <br />spreadsheets would also be taken into a, "Colorado River Administration" spreadsheet <br />which mayor may not be part of the new CRA spreadsheet, for river administration <br />purposes. Finally, the new eRA spreadsheet and Colorado River Administration <br />spreadsheet would contain some fairly simple MACRO's that would move data into <br />diversion records etc. and allow key reports to be generated for use in annual reports to <br />the State Engineer, LegislalLJre and others. The water user organizations and projects are <br />as follows: <br /> <br />Denver Water <br /> <br />U.S. Bureau of Reclamation -- Green Mountain Reservoir Operations <br />Blue River Accounting <br />Fryingpan-Arkansas Operations <br />Colorado Big Thompson Project <br />-- Dillon Reservoir and Roberts Tunnel Operations <br />Moffat Collection System Operations <br />Williams Fork Reservoir and Collection System <br />-- Wolford Mountain Reservoir Operations <br /> <br />Colorado River Water <br />Conservation District <br />Colorado Springs <br />Colorado Springs and <br />Aurora <br /> <br />-- Blue River Collection System <br />-- Homestake Reservoir and Collection System <br />