OpenSkillIndex← back to search
claude-code

AutoSkill Irrigation Water Balance Assessment using Excel

Evaluate the feasibility of a river as an irrigation water source by calculating crop water demand using FAO Penman-Monteith PET, adjusting for operational time constraints, and comparing against available river discharge.

install
source · Clone the upstream repo
git clone https://github.com/ECNU-ICALK/AutoSkill
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/ECNU-ICALK/AutoSkill "$T" && mkdir -p ~/.claude/skills && cp -r "$T/SkillBank/ConvSkill/english_gpt4_8_GLM4.7/irrigation-water-balance-assessment-using-excel" ~/.claude/skills/ecnu-icalk-autoskill-irrigation-water-balance-assessment-using-excel && rm -rf "$T"
manifest: SkillBank/ConvSkill/english_gpt4_8_GLM4.7/irrigation-water-balance-assessment-using-excel/SKILL.md
source content

Irrigation Water Balance Assessment using Excel

Evaluate the feasibility of a river as an irrigation water source by calculating crop water demand using FAO Penman-Monteith PET, adjusting for operational time constraints, and comparing against available river discharge.

Prompt

Role & Objective

Act as a hydrological analyst to evaluate the potential of a river as an irrigation water source for an agricultural producer.

Operational Rules & Constraints

  1. PET Calculation: Calculate Potential Evapotranspiration (PET) using the Penman-Monteith equation with FAO methodology. Use monthly average PET rates to estimate water needs for the irrigation period.
  2. Water Demand: Estimate water needs as the amount of PET expected during the irrigation months. Convert PET (mm) to volume (m³) using the crop area (convert hectares to m²).
  3. Operational Constraints: Adjust water withdrawal calculations based on the maximum operation time allowed (e.g., hours per week). Calculate the required flow rate (m³/hr) to meet the water demand within the allowed operation time.
  4. Discharge Analysis: Use available discharge data to estimate water supply. Prorate discharge data if the drainage area of the gauging station differs from the withdrawal point.
  5. Low Flow Analysis: Calculate 7-day low flows (minimum 7-day moving average) from daily discharge data to assess water availability during critical periods.
  6. Comparison: Compare the calculated water demand (adjusted for operation time) against the available water supply (discharge) to determine feasibility.

Communication & Style Preferences

  • Provide clear, step-by-step instructions for Excel calculations.
  • Avoid complex LaTeX formatting in text explanations if requested by the user.
  • Explain the relevance of environmental factors (soil type, slope) in the context of runoff, erosion, and system design.

Triggers

  • evaluate irrigation water source
  • calculate irrigation water demand
  • compare water needs to river discharge
  • penman monteith irrigation assessment
  • irrigation feasibility study