Analysis And Simulation On Water Consumption Law And Related Design Parameters In Residential Quarters

The rules of water use in residential quarters of different scales and construction standards are similar,but there are some differences.Existing design manuals,specifications,and textbooks have less elaboration on the design of water supply based on different scales,resulting in a blind zone in the design of water supply flow for living quarters of different sizes.The calculation formulas are inconsistent.The design results and actual water consumption sometimes deviate.Affecting the safe water supply in the community.Existing codes have large design parameters,and there is a large difference between the design requirements and operating conditions of the residential water supply network,which has caused some problems in the design of the residential water supply network.Due to the improvement of flow monitoring equipment and monitoring methods,many residential quarters water consumption data is relatively easy to obtain,which provides a solid data foundation for big data analysis of water consumption.However,the obtained data often has some deviations.In order to supplement the information on the water consumption and water use rules of residential quarters of different sizes,to provide more detailed design basis,to provide references for the revision and supplement of the specifications,and to provide a reference for the design of the residential water supply network,this project selected Thirty residential quarters ranging from 300 to 3,000 people were studied.The water consumption of each residential district has been continuously monitored online for a long time,and a large amount of water consumption data has been obtained.By combining the VBA program written in the Excel spreadsheet,a series of data automatic processing is realized from the data acquisition to the final water usage law fitting of the residential district water usage law with the scale change trend.This paper puts forward the automatic implementation scheme of VBA program in data interpolation,instantaneous flow distribution analysis and hypothesis test.After monitoring the data through mathematical statistical analysis,the differences in water use laws of different scale houses are compared,and the design parameters such as the maximum second flow,average daily flow,peak and valley values,and flow change points of residential quarters under the scale sequence are analyzed.The water consumption law of large-scale residential quarters was analyzed and studied.The research results have refined the differences in water use laws of large-scale residential quarters,and added some gaps in the code.Based on the results of the analysis,this paper proposes a scheme for fitting daily average water consumption curves and water feature points of different sizes of residential quarters through VBA program,and evaluates the scheme.The overall structure and specific code of the water law curve and the program for obtaining characteristic points are given.It provides reference opinions for the design and optimization of water supply pipe networks in different scales,and provides reference for the revision and supplement of the specifications.The research results are of great significance to the design of the overall water supply system in a residential quarters.