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.

本数据集所收集之数据源自一住宅环境。其中设有两个储水罐，地下储水罐（集水井）中的水通过泵浦输送到位于上方的储水罐 Tank1 及 Tank2。每个储水罐顶部均安装有一超声波距离传感器，该传感器以固定的时间间隔监测并记录水面距离传感器的距离。

Tank1 共有 13 组数据，而 Tank2 则有 16 组数据。关于这些数据集的详细描述分别收录于 Tank1-数据描述.xlsx 和 Tank2-数据描述.xlsx 文件中。

记录的数据为储水罐中水面距离传感器位置的垂直距离。传感器的最小读数为 19 厘米，表示储水罐满载；最大读数为 88 厘米，表示储水罐空载。

因此，为计算当前储水罐的填充百分比，我们采用以下公式：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
调整 R-square: 0.9995
RMSE: 0.4951

关于消耗量备注：

实验装置安装在配备 300 升容量的太阳能热水器（Microsoft）的住宅中，每晚 12:00 开始从 Tank1 充水。因此，Tank1 在 00:00 至 03:00 之间的水位变化记录较高。其余时间段的消耗量则代表常规家庭消耗。

该住宅有四位成年人居住，其中三名居民在每周工作日的 10:00 离开住所，并于 16:00 返回。
Tank1 供全家用水需求。
Tank2 仅用于园艺用途。