Excel和Lotus等电子表格已经获得了巨大的成功 在水工业中很受欢迎。要增强电子表格功能，请使用外接程序或 补充程序由用户开发并集成到电子表格中 或者专业的第三方供应商。本文讨论了 南加州大都会水区（MWDSC）将合并 商用插件作为优化工具（线性规划， 非线性规划和遗传算法），电子表格模型用于 配电系统规划和调度。 包括3个参考文献。

Spreadsheets such as Excel and Lotus have enjoyed a tremendous amount of popularity in the water industry. To enhance spreadsheet capabilities, add-ins or supplemental programs are developed and integrated into the spreadsheets by users or specialized third-party vendors. This paper discusses the efforts of the Metropolitan Water District of Southern California (MWDSC) to incorporate commercially available add-ins as optimization tools (linear programming, non-linear programming and genetic algorithms), with spreadsheet models used for distribution system planning and scheduling. Includes 3 references.