Laserfiche WebLink
tabs into rows that represent diversion record water classes, which DWR staff can <br /> upload to create official diversion records. When appropriate, DWR staff will develop <br /> this tab or work with plan owners to develop this tab, and ensure it follows the <br /> format shown in the "Diversion Record Spreadsheet User Guide" and utilizes water <br /> classes according to the Diversion Records Standard. This format is necessary to allow <br /> the records to be imported directly 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. <br /> This calculates pumping totals in compliance with well rules or to meet other <br /> Division-specific requirements. In order for this tab to be bulk uploaded into <br /> Hydrobase, the columns in this tab must be formatted as shown in the "User Guide - <br /> 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 <br /> determine the resulting impact on the river. Accounting must therefore include <br /> a functional spreadsheet (ie no pdfs) showing all operations, formulas, etc. to <br /> clearly show calculations. <br /> b. The use of a water year of November 1 through October 31 is required unless <br /> specifically decreed otherwise. When a different water year is required by <br /> decree, DWR may request additional months of data in the accounting to include <br /> the November 1 through October 31 time period, resulting in more than 12 <br /> months of data being reported. <br /> c. For all tabs other than the Summary tab, include running accounting for the <br /> entire water year without monthly subtotals. Monthly subtotals commonly result <br /> in errors in the spreadsheet. The Summary tab can be used as a place to show <br /> monthly totals. <br /> d. Date fields should be complete dates (month, day, and year, recognized as a <br /> date value by the spreadsheet software) but may be formatted to display as <br /> desired. <br /> e. Use consistent cell color shading to clearly identify the different types of <br /> information, such as manual input cells and formula cells (provide a legend for <br /> data types, see example below) <br /> f. Enter "0" in cells to document no diversion or use, rather than blanks, hyphens, <br /> or another character. <br /> g. When a formula is overwritten with a manual entry, the cell should be <br />