Rainwater harvesting (RWH) is a necessary technology to supplement and/or replace insufficient ground and surface water resources for domestic water supplies, especially under changing climate conditions. An accessible and flexible Excel-based RWH simulation tool is developed and applied to investigate the utility of RWH in two regional case studies, under both present conditions and future climate scenarios, through examination of relationships between tank volumes, roof areas, rainfall patterns, and yield. The conversion of complex mathematical formula into a tool with a simple data entry form for infinite combinations of the critical variables enables non-experts to manipulate and optimize designs at the level of RWH implementation. The results clearly show that RWH can augment problematic or insufficient water supplies. Roof area and rainfall distribution have the greatest impact on the ability of a RWH system to meet demand; tank size has a minimal effect, providing a buffer during short dry periods within any given month. Demand met improves in both geographies under future scenarios. Thus, while RWH is insufficient as the sole source of domestic water now and in the future, it is a low-cost supply augmentation solution even in cold climates. RWH solutions are made more accessible through planning tools such as the Tank Simulation Model presented here, which is sufficiently flexible to incorporate climate change scenario planning.

中文翻译：

---

水箱模拟模型 (TSM) 的设计与应用：评估雨水收集满足生活用水需求的能力

雨水收集 (RWH) 是补充和/或替代不足的地下水和地表水资源用于家庭供水的必要技术，尤其是在气候条件变化的情况下。开发并应用了一种可访问且灵活的基于 Excel 的 RWH 模拟工具，通过检查储罐容积、屋顶面积、降雨模式和屈服。将复杂的数学公式转换为具有简单数据输入表格的工具，用于无限组合关键变量，使非专家能够在 RWH 实施级别上操纵和优化设计。结果清楚地表明，RWH 可以增加有问题或不足的供水。屋顶面积和降雨分布对 RWH 系统满足需求的能力影响最大；水箱大小的影响很小，在任何给定月份内的短暂干燥期间提供缓冲。在未来情景下，两个地区的需求得到改善。因此，尽管 RWH 作为现在和未来生活用水的唯一来源是不够的，但即使在寒冷气候下，它也是一种低成本的补充供应解决方案。RWH 解决方案通过此处介绍的坦克模拟模型等规划工具变得更容易获得，该模型足够灵活，可以纳入气候变化情景规划。在未来情景下，两个地区的需求得到改善。因此，尽管 RWH 作为现在和未来生活用水的唯一来源是不够的，但即使在寒冷气候下，它也是一种低成本的补充供应解决方案。RWH 解决方案通过此处介绍的坦克模拟模型等规划工具变得更容易获得，该模型足够灵活，可以纳入气候变化情景规划。在未来情景下，两个地区的需求得到改善。因此，尽管 RWH 作为现在和未来生活用水的唯一来源是不够的，但即使在寒冷气候下，它也是一种低成本的补充供应解决方案。RWH 解决方案通过此处介绍的坦克模拟模型等规划工具变得更容易获得，该模型足够灵活，可以纳入气候变化情景规划。