Laserfiche WebLink
<br />2.2.Review Existing CRA Spreadsheet The existing CRA Spreadsheet maintained by the USBR <br />will be reviewed and evaluated. An understanding of accounting principles associated with this <br />spreadsheet will be developed. <br /> <br />2.3.Existing Division 5 Administration Water Division 5 procedures for accounting and <br />administration of the Colorado River will be reviewed with the Division Engineer. Applicable <br />computer programs and spreadsheets will be obtained and evaluated (expect between 4-6). The <br />current and historic methods of determining the quantity of Green Mountain Reservoir <br />replacement water releases will be evaluated. <br /> <br />2.4.Water User Accounting Information Water user spreadsheets and other accounting <br />information currently provided by water users to Division 5 will be reviewed. Material to be <br />reviewed will include spreadsheets maintained by Denver Water, the Northern Colorado Water <br />Conservancy District and other major water users listed in Table I. <br /> <br />2.5.CRDSS Planning Model Data Water facility descriptions developed as part of the CRDSS <br />planning models will be reviewed and evaluated. These include descriptions of major systems <br />on the Colorado River Basin such as the Colorado Big Thompson, Denver Water Board, <br />Frying Pan Arkansas, etc, <br /> <br />2,6.Draft Review A memorandum will be prepared which summarizes how the reviews <br />conducted in the subtasks above are relevant to the Division 5 Worksheet. <br /> <br />2,7.Final Review Memo Incorporate State comments into a Final Review memorandum. <br /> <br />De/iverables: <br /> <br />I. Draft Review memorandum <br />2, Final Review memorandum <br /> <br />Task 3 - Preliminary and Draft Conceptual Design <br /> <br />Responsibility: Boyle <br /> <br />Objective: Develop a Preliminary and Draft Conceptual design for the Division 5 Worksheet. <br /> <br />Approach: <br /> <br />3,1.Preliminary Conceptual System Design A Preliminary Conceptual Design for a Division 5 <br />Worksheet will be developed based on local knowledge and the information developed in <br />previous Tasks. The conceptual design will be coordinated with the Division 5 Engineer, <br />CRDSS project manager and CWCB representatives. It will be documented in a memorandum <br />containing approximately 15 pages of text and distributed to the State for review. Expected to <br />look similar to Figure 1 and Table 1, this preliminary conceptual design will identify program <br />specifications such as: <br /> <br />· Excel operating under Windows 95 is the recommended software and operating system. <br />. Summary Worksheet content. <br />· Number of Backup Spreadsheets to be broken out from the existing CRA Spreadsheet. <br />. Number of New Backup Spreadsheets to be developed. <br /> <br />C:I w\crdss\scopelboy III blcrdss3 .doc <br /> <br />, <br />0769 <br /> <br />5/30/97 - Page 6 <br />