A water resource allocation method based on configuration relationship matrix and Excel

Kuang Li; Lili Liang; Hou Yu; Fuxin Chai

doi:10.1117/12.2642793

28 July 2022 A water resource allocation method based on configuration relationship matrix and Excel

Kuang Li, Lili Liang, Hou Yu, Fuxin Chai

Proceedings Volume 12303, International Conference on Cloud Computing, Internet of Things, and Computer Applications (CICA 2022); 123030C (2022) https://doi.org/10.1117/12.2642793
Event: International Conference on Cloud Computing, Internet of Things, and Computer Applications, 2022, Luoyang, China

Abstract

In this study, a water resource allocation method based on configuration relationship matrix and Excel was proposed. First, the relationship between water sources and configuration units was described using a configuration relationship matrix, where matrix X denotes the sequence of water supply to configuration units receiving the water source, matrix Y represents the sequence of water supply to configuration units from the water source, and matrix Z is the water supply coefficient to the configuration units from the water source. Next, the detailed steps and flowcharts of available water supply, water demand calculation of configuration units and reservoir water balance calculation were given. Afterwards, the corresponding worksheets were set in Excel for the sake of data storage, configuration calculation and outcome statistics. Finally, this method was applied to the water resource allocation of the 13th Division of Xinjiang Production and Construction Corps. Characterized by clear logical structure, high intuition and easy operation, the proposed method is applicable to small-scale long-series water resource allocation calculation with simple configuration relationships.

Citation Download Citation

Kuang Li, Lili Liang, Hou Yu, and Fuxin Chai "A water resource allocation method based on configuration relationship matrix and Excel", Proc. SPIE 12303, International Conference on Cloud Computing, Internet of Things, and Computer Applications (CICA 2022), 123030C (28 July 2022); https://doi.org/10.1117/12.2642793

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available

Members: $17.00

Non-members: $21.00 ADD TO CART

PROCEEDINGS
11 PAGES

DOWNLOAD PAPER SAVE TO MY LIBRARY

GET CITATION

RIGHTS & PERMISSIONS

Get copyright permission Get copyright permission on Copyright Marketplace

KEYWORDS

Excel

Data storage

Matrices

Neodymium

Data modeling

Picosecond phenomena

Computer programming

Show All Keywords

Keywords/Phrases

Search In:

Publication Years