Laserfiche WebLink
time period, resulting in more than 12 months of data being reported. <br /> c. For all tabs other than the Summary tab, include running accounting for the entire water year <br /> without monthly subtotals. Monthly subtotals commonly result in errors in the spreadsheet. <br /> The Summary tab can be used as a place to show monthly totals. <br /> d. Date fields should be complete dates (month, day, and year, recognized as a date value by the <br /> spreadsheet software) but may be formatted to display as desired. <br /> e. Use consistent cell color shading to clearly identify the different types of information, such as <br /> manual input cells and formula cells (provide a legend for data types, see example below) <br /> f. Enter "0" in cells to document no diversion or use, rather than blanks, hyphens, or another <br /> character. <br /> g. When a formula is overwritten with a manual entry, the cell should be highlighted and a <br /> comment added for the reasoning. <br /> h. When there are multiple stream reaches involved, organize accounting from upstream to <br /> downstream. <br /> i. Footnotes should be utilized, as necessary, to describe the basis for formulas, calculations <br /> imposed on the raw input data, and column descriptions. <br /> 6. Example, Screenshots, and Spreadsheet Templates <br /> Water users may request spreadsheet templates from their local division office for use as examples of how <br /> accounting may be assembled, but are responsible for developing their own functional accounting <br /> customized for their own Plan requirements. Note that example and actual accounting may have slightly <br /> different organization than what is described above. <br /> a. (List of relevant tabs) <br /> A B C D E F G H I <br /> 1 <br /> 2 Example Aug Plan <br /> 3 Case No.12CW3456 <br /> 4 - Plan WDID:o101234 At the bottom of the workbook you will see tabs for <br /> 6 <br /> 6 - Watervear all the pertinent information. <br /> 7 - zDz1 <br /> 9 In this example, the complexity warrants separating <br /> 9 _ � p p Y p g <br /> 1° them into different tabs: i.e. Contact and Plan <br /> 12 (Nason me of ontac'ef°"A"°°"t'"R Information, Well and Meter Information, Depletions <br /> 13 (Name of Contact) <br /> 14 (Address) and Obligations, Example Pond Replacements, <br /> 1e - (Email) g p p , <br /> 16 (Phone)if Summary, DWR and Version tabs. <br /> 18 Aug Plan Contact: <br /> 19 (Name of Contact) <br /> ddressl <br /> Contact&Plan Info Depletions&Obligations I Replacements Example Pond Summary DWR Version <br /> Questions can be submitted to Ask DWR by visiting the DWR homepage at: dwncolorado.eov/ Page 9/15 <br />