Household Water consumption dataset

Data is collected from a house.There are two tanks. Sump is underground, from which the water is pumped to the overhead tanks Tank1 and Tank2. An Ultrasonic distance sensor is mounted near the top of each tank that monitors and logs the distance of the water surface from the sensor at fixed intervals. There are 13 sets of data for Tank 1 and 16 sets of data for Tank 2. The description reg. these datasets are given in Tank 1-Data Description.xlsx and Tank 2-Data Description.xlsx, respectively. The data logged is the vertical distance of the water surface in the tank from the sensor's location. The minimum reading of sensor is 19 cm which indicates full tank and the maximum reading is 88cm which indicates an empty tank. So to calculate the percentage of tank that has been filled as of now, we use the formula: percent_full=100-(100*(data-19)/(88-19))) The data logged is the one adjusted with calibration equation. The equation found is as follows: Sensor calibration results: f(x) = p1*x + p2 Coefficients (with 95% confidence bounds): p1 = 1.033 (1.024, 1.042) p2 = 1.187 (0.7033, 1.67) Goodness of fit: SSE: 7.109 R-square: 0.9995 Adjusted R-square: 0.9995 RMSE: 0.4951 Note Reg. consumption: The experimental setup was installed in a house with a Solar water heater (capacity 300 Liters) that gets filled every midnight at 12.00 onwards from Tank 1. Hence, the level changes logged for tank 1 during the hours 00.00 to 03.00 am are high. During the rest of the day, the consumption is that of a regular household. The household has four adult occupants, with three occupants leaving the house by 10.00 am every weekday and returning by 4.00 pm. Tank 1 is used for supplying all household needs. Tank 2 is used only for gardening purposes.

本数据集采集自一处住宅，内含两台水箱。地下集水井（Sump）内的水经泵送至高位置水箱Tank1与Tank2。每个水箱顶部附近均安装有一台超声波距离传感器（Ultrasonic distance sensor），以固定间隔监测并记录水面与传感器之间的垂直距离。其中Tank1共包含13组数据，Tank2共包含16组数据。上述数据集的详细说明分别见于《Tank 1-Data Description.xlsx》与《Tank 2-Data Description.xlsx》。本次记录的数据为水箱内水面至传感器安装位置的垂直距离。该传感器的最小读数为19cm，对应水箱满水状态；最大读数为88cm，对应水箱空置状态。据此可通过以下公式计算当前水箱的蓄水百分比：percent_full=100-(100*(data-19)/(88-19)))。所有记录数据均已通过校准方程进行修正，校准方程如下：传感器校准结果：f(x) = p1*x + p2；系数（含95%置信区间）：p1 = 1.033 (1.024, 1.042)，p2 = 1.187 (0.7033, 1.67)。拟合优度指标如下：SSE：7.109，决定系数（R-square）：0.9995，调整决定系数（Adjusted R-square）：0.9995，均方根误差（RMSE）：0.4951。用水量相关说明：本实验装置安装于一台配备300升太阳能热水器的住宅内，该热水器每日午夜12:00起从Tank1取水补水。因此，Tank1在每日00:00至03:00时段内的水位变化幅度较大。其余时段的用水量符合普通家庭的常规使用规律。该住宅共有四名成年常住居民，工作日期间三名居民每日10:00离家、16:00返家。Tank1用于满足家庭所有日常用水需求，Tank2仅用于园艺灌溉。

搜集汇总

背景与挑战

背景概述

该数据集记录了家庭用水消耗情况，包含两个水箱的水位监测数据，通过传感器记录并校准，用于分析家庭日常和园艺用水模式。