New Publication Demonstrates Excel’s Role in Solving Optimal Groundwater Management

A recent publication titled “Solving Optimal Groundwater Problems with Excel” introduces an accessible solution approach using Excel Solver to address complex coastal groundwater management challenges. The study emphasizes the inadequacy of conventional sustainable yield approaches and instead proposes a comprehensive method for achieving welfare-maximizing groundwater management. Applied to the Pearl Harbor Aquifer in Hawaii, the study demonstrates the Excel-based framework’s effectiveness in determining optimal transition paths for pumping, price, and head level, along with their long-term solutions. The research offers a clear step-by-step process, paving the way for replicable results and discussing potential extensions, including ecosystem protection and multi-aquifer management.

Wada, Christopher A., et al. “Solving Optimal Groundwater Problems with Excel.” Applied Economics Teaching Resources (AETR) 5.2 (2023).

Leave a Comment

Your email address will not be published. Required fields are marked *

The University of Hawaii Economic Research Organization (UHERO) welcomes online comments to stories that are posted on our website or social media pages. Comments are intended to be a forum for open, respectful, and family-friendly discussion. UHERO reserves the right to remove anything posted on our website or social media pages that is deemed inappropriate. All comments are moderated and will therefore have a delayed post time.
Some guidelines (not an exhaustive list) we use when moderating/approving comments include:

  • Do not bully, intimidate, or harass any user.
  • Do not post content that is hateful, threatening or wildly off-topic; or do anything unlawful, malicious, discriminatory or defamatory.
  • Observe confidentiality laws at all times.
  • Do not post spam or advertisements.
  • Observe fair use, copyright and disclosure laws.
  • Do not use vulgar language or profanity.

UHERO may amend this policy from time to time.