Laserfiche WebLink
Sandstone Ranch Accounting Forms <br /> Case No.09CW271 <br /> 4/27/2010 Edition <br /> Table 1. Daily Measured Deliveries Input <br /> Column Title Source <br /> A Call Affecting St.Vrain Creek below Dry Creek Enter call date or"Free River" <br /> B Sandstone Depletion Replacement Required? If Col A Z 10/26/2004 then no,else yes <br /> C Coffin Davis Sherwood Enlargement In-Priority? If Col A 2 12/22/2009 then yes,else no <br /> D Coffin Davis Return Flow Replacements Required? If Col A 2 12/31/2009 then no,else yes <br /> E Total Diversions Through Coffin Davis Headgate Measured Value <br /> F Sherwood Enlargement Diversions at Coffin Davis Headgate Measured Value <br /> G Coffin Davis Ditch River Headgate Diversions Col E-Col F <br /> H Coffin Davis Ditch Delivery to Augmentation Station Measured Value <br /> I Coffin Davis Ditch Delivery to Sandstone Ranch Measured Value <br /> J Delivery of Longmont Fully Consumable Water Measured Value <br /> K Source of Longmont Fully Consumable Replacement Water Enter Source of Water <br /> L Pond Ice Cover Visual Inspection <br /> Table 2. Daily Plan Obligations <br /> Column Title Source <br /> A Evaporative Depletions Ponds 1-8&Stream Area x Evap Rate unless Table 1 Col L="Yes",then=0 <br /> B Wetlands CU Depletions Zone 1 Zone 1 Area x Zone 1 Rate <br /> C Wetlands CU Depletions Zone 2 Zone 2 Area x Zone 2 Rate <br /> D Wetlands CU Depletions Zone 3 Zone 3 Area x Zone 3 Rate <br /> E Wetlands CU Depletions Zone 4 Zone 4 Area x Zone 4 Rate <br /> F Total Wetlands CU Depletions Col B+Col C+Col D+Col E <br /> G Total Project Depletions If Table 1 Col B=yes then Col A+Col F else 0 <br /> Table 3. Daily Plan Operations <br /> Column Title Source <br /> A Coffin Davis to Irrigation Table 1 Col G-Table 1 Col H-Table 1 Col I <br /> B Coffin Davis Changed Water Table 1 Col H+Table 1 Col I <br /> C Coffin Davis Augmentation Credits If Table 1 Col D=yes then Col B x Depletion Factors,else Col B <br /> D Coffin Davis Return Flow Obligation If Table 1 Col D=yes then Col B x Return Flow Factors,else 0 <br /> E Project Depletions Table 2 Col G <br /> F Coffin Davis Water to Project Table 1 Col I <br /> G Project Depletions Unmet by Coffin Davis to Project Max(Col E-Col F,0) <br /> H Coffin Davis Aug Credits through Aug Station to Dry Creek Min(if(Col F>Col C,0,Col C-Col F),Table 1 Col H) <br /> I Coffin Davis Return Flow Repl through Aug Station to Dry Creek Table 1 Col H-Col H <br /> J Unmet Return Flow Requirement Max(Col D-Col I,0) <br /> K Coffin Davis Aug Credits to Meet Unmet Proj.Depl.&RF If(Col H>Col G+Col J,Col G+Col J,Col H) <br /> L Longmont Fully Consumable Replacement Water Table 1 Col J <br /> M Source of Longmont Fully Consumable Replacement Water Table 1 Col K <br /> N Unmet Obligations Max(Col G+Col J-Col K-Col L,0) <br /> O Excess Coffin Davis Credits in River Col H-Col K <br /> Table 4. Monthly Summary <br /> Column Title Source <br /> A Coffin Davis to Irrigation Monthly sum of Table 3 Col A <br /> B Coffin Davis to Augmentation Monthly sum of Table 3 Col B <br /> C Coffin Davis Augmentation Credits Monthly sum of Table 3 Col C <br /> D Coffin Davis Return Flow Obligation Monthly sum of Table 3 Col D <br /> E Project Depletions Monthly sum of Table 3 Cd E <br /> F Coffin Davis Water to Project Monthly sum of Table 3 Col F <br /> G Project Depletions Unmet by Coffin Davis to Project Monthly sum of Table 3 Col G <br /> H Coffin Davis Aug Credits through Aug Station Monthly sum of Table 3 Col H <br /> I Coffin Davis Return Flow Water through Aug Station Monthly sum of Table 3 Col I <br /> J Unmet Return Flow Requirement Monthly sum of Table 3 Col J <br /> K Coffin Davis Aug Credits to Meet Unmet Proj.Depl.&RF Monthly sum of Table 3 Col K <br /> L Fully Consumable Replacement Water Monthly sum of Table 3 Col L <br /> M Unmet Obligations Monthly sum of Table 3 Col N <br /> N Excess Coffin Davis Credits in River Monthly sum of Table 3 Col 0 <br /> Table 5. Volumetric Limits <br /> Column Title Source <br /> A Total Coffin Davis Water Table 4 Col A+Table 4 Col B <br /> B Monthly Volumetric Limits Decreed Limits <br /> C Annual Coffin Davis Water Decree Exhibit C values,update with actual annual values as plan progresses <br /> D 40-Year Cumulative Diversions Sum Col C for 40 years <br /> E Available Under Limit 38,880-Col D <br />