Laserfiche WebLink
drying diversion for each plan. The RESULTS page has a Summary Table for printing <br />which lists these amounts and the resulting lease payments by SPWRAP to each of the <br />plans. <br />There is also a page of the spreadsheet for the computation of credits for Tamarack 1 and <br />CPFD for the recharge activities at the CDOW Tamarack Ranch SWA where SPWRAP <br />does not lease any water but pays the O &M (i.e., electricity). This page sets up the input <br />for the two AWAS models for the Tamarack Ranch SWA activities. Accretion results <br />from these two models are copied to the top of the Results page so the Summary Table <br />then includes all credited waters for Colorado's PRRIP obligations. <br />The Analysis Steps are as follows stating the basis of formulas: <br />Step 1: Copy in data to blue block on Setup page. On the Setup page, the Section A data <br />for excess at Grand Island is auto copied to each Plan's page in range R2..AC6 (Block 3). <br />Section B and C data is used in Step 3 below. Section D, E, and F data is auto copied to <br />the RESULTS page for computation of final credit for Tam 1 and CPFD below the last <br />diversion in Colorado that diverts the entire river and when no SP Compact call. <br />Step 2: Copy in data (net recharge by plan and by each structure of plan - -from each <br />plans original AWAS) into Columns A through N on page for each plan including <br />TamSWA. <br />Step 3: Computation in Block 1 (Row 40 on Setup) computes remaining CPFD <br />accretions after deduction for evaporation and net recharge diversions at TamSWA. <br />Step 4: Computation in Block 2 (Row 48 on Setup) computes % of net recharge by the 4 <br />plans below Harmony #1 Ditch by first totaling net recharge for the 4 plans and then <br />compute the % of the total for each plan- -this % is used on each plan's page for LSP, <br />SCWU, Dinsdale, and Condon. <br />Step 5: Computation in Block 4 (Range AF1..AR6) on each plan page computes the % of <br />remaining CPFD accretions (after evap and Tamarack SWA net diversions) in Setup, <br />Block 1 attributable to each of the plans. These % values for the 4 plans below the <br />Harmony #1 Ditch are the lesser of Setup, Block 1 multiplied by Setup, Block 2 for each <br />plan OR a plan's total net recharge with the lesser amount divided by the plan's total <br />monthly net recharge. For LLWU which is the farthest plan upstream, the remaining <br />CPFD after distribution to TamSWA and the other 4 plans is attributable to LLWU <br />capped to the total LLWU net recharge expressed as a % of LLWU total net recharge. <br />Step 6: The data rows below Block 3 for Tam 1 and Block 4 for CPFD on each plan's <br />page are auto copied to the page "AWAS input _5 plans ". As explained on the top of that <br />page, each of the blocks of data on this page is copied to a newly opened spreadsheet as <br />values then formats. This new sheet is the saved as a tab - delimited text file for import <br />(Add to Project) to the 5 Plan AWAS model -one model for Tam 1 and one model for <br />CPFD. The Tamarack SWA has separate AWAS models for Tam 1 and CPFD and the <br />data rows below Block 3 and 4 on the TamSWA page are saved to tab delimited files for <br />import to AWAS. <br />Step 7: After the AWAS models are run, then the accretion/spreadsheet output from <br />AWAS is copied to the top of the RESULTS page. This page then computes the credits <br />attributable to each of the plans and the resulting lease payments by SPWRAP to each of <br />the 5 plans. A Summary Table is ready to print from this page. <br />