Reports

Get the results of TWRI-funded research through technical and special reports. Find abstracts and full-text online for our reports.

TR-339

Goal Seek Pamphlet II for VIDRA© - HCID#1 (version 2.6 / December 18, 2008)

A. Sturdivant, M. Rister, R. Lacewell, C. Rogers

About VIDRA© - HCID#1:

VIDRA© (Valley Irrigation District Rate Analyzer) is a work-in-process and is being (has been) developed with collaboration from Hidalgo County Irrigation District No. 1 (HCID#1) and other Lower Rio Grande Valley irrigation districts. The primary function of VIDRA© is to provide an irrigation district (ID) a means of 'what-if' analysis for analyzing an upcoming year's potential estimated financial data with simultaneous changes in rates, expenses, or other water-delivery related parameters for the irrigation district. In addition, one can make a separate VIDRA© worksheet copy and then input actual, end-of-the-year data for a post-year analysis. That is, both 'budgeted' and 'historical' versions of analysis are possible. Though robust, VIDRA©s purpose is to provide a focal point for conversation, information, and insights only, not provide absolute authority over the decision making of rates and/or other ID policies.

Though careful efforts to insure complete formulae accuracy have been incorporated, no expressed or implied guarantees are provided with regards to VIDRA© - HCID#1. All responsibility lies with the user. Analyses using VIDRA© require accurate, complete, and correctly-placed data input, as well as proper interpretive skills of the user. Substantial Microsoft® Excel® spreadsheeting skills are also a must. VIDRA© - HCID#1 is customized for HCID#1 (“the District”) and meant for limited distribution. Providing copies to others separate from the District is prohibited.

Back to Top