Laserfiche WebLink
iv. Total transit loss (%) <br /> v. Volume released (acre-feet) <br /> vi. Transit loss volume (acre-feet) <br /> vii. Volume delivered (acre-feet) - equal to volume released minus transit loss volume <br /> viii. Return flow obligations (acre-feet): Depending on decree language as described above, these <br /> may be included here instead of in the depletion tab. See description under section 4.d. above. <br /> f. Summary Tab <br /> The Summary Tab is used to calculate the Net Effect of the Plan on each impacted stream reach. <br /> The summary should reference back to information and formulas in the other spreadsheet tabs. The <br /> summary tab compares obligations, replacements and that replacements equal or exceed <br /> obligations in time, place, and amount. The Summary tab should only summarize data and <br /> calculations located in other tabs of the accounting. It should not contain manual entries, input <br /> data, or make calculations that are used in other tabs. <br /> The Summary Tab should contain the following for each impacted stream reach (typically on a <br /> daily basis or as required by the division office): <br /> i. Total depletions and obligations <br /> ii. Total replacement <br /> iii. Balance - Total replacement minus total depletions and obligations, which may be negative <br /> when the diversions resulting in the depletions are in priority. <br /> iv. Net Effect - Total replacement minus out-of-priority depletions and obligations. If the net <br /> effect is negative, the Plan resulted in injury. <br /> g. DWR tab for Diversion Record Data Import <br /> A tab titled "DWR" can be used to convert data input or numbers calculated in other tabs into rows <br /> that represent diversion record water classes, which DWR staff can upload to create official <br /> diversion records. When appropriate, DWR staff will develop this tab or work with plan owners to <br /> develop this tab, ensure it follows DWR's standard format and utilizes water classes according to the <br /> Diversion Records Standard. This format is necessary to allow the records to be imported directly <br /> into Hydrobase. <br /> h. DWR Meters tab for Meter Reading Data Import <br /> A tab titled "DWR Meters" can be included for use in bulk uploading meter readings. This calculates <br /> pumping totals in compliance with well rules or to meet other Division-specific requirements. In <br /> order for this tab to be bulk uploaded into Hydrobase, the columns in this tab must be formatted as <br /> shown in the "User Guide - How to Bulk Upload Meter Readings". <br /> i. Version/Notes tab <br /> A tab to document changes in accounting formulas and the date of those changes. <br /> 5. Requirements and recommendations for all tabs <br /> a. Accounting should show how raw input data is manipulated using formulas to determine the <br /> resulting impact on the river. Accounting must therefore include a functional spreadsheet (ie <br /> no pdfs) showing all operations, formulas, etc. to clearly show calculations. <br /> b. The use of a water year of November 1 through October 31 is required unless specifically <br /> decreed otherwise. When a different water year is required by decree, DWR may request <br /> additional months of data in the accounting to include the November 1 through October 31 <br /> Questions can be submitted to Ask DWR by visiting the DWR homepage at: dwr.colorado.2ov/ Page 8/15 <br />