Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Journal of Water Resources and Architectural Engineering》 2013-02
Add to Favorite Get Latest Update

Realization for Calculation on Characteristical Depth of Open Channel by Excel

DING Li-ze1,OUYANG Ming2,ZHANG Qing-wen1(1.Jiaxing Vocational and Technical College,Jiaxing,Zhejiang 314036,China;2.College of Architectural Engineering,Zhejiang Polytechnical University,Hangzhou,Zhejiang 310014,China)  
The four kinds of characteristical depths of open channel,i.e.,normal water depth,critical water depth,contracted water depth and conjugate water depth,can be calculated by the four methods with Microsoft Excel such as filling handle,single goal seeking function,and iteration solving by circulating citation and programming solving function.Through the application examples and comparing with the reference results,it is shown that the depths in various kinds of sections can be obtained by Excel more quickly,precisely and conveniently compared with the general methods,such as manual calculation or computer programming.The process of calculation is simple and can be understood easily,the result of calculation is exact and reliable,and the good methods and new ways of thinking can be provided for teaching and design.
【CateGory Index】: TV133
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【Citations】
Chinese Journal Full-text Database 10 Hits
1 LU Hong?xing, BA Duo?duo,SONG Song?bai (College of Water Conservancy and Architecture Engineering of Northwest Science and Technology University of Agriculture & Forestry, Yangling 712100,China);Hydraulic calculation for free flow in circular section by iterative method[J];Journal of Yangtze River Scientific Research Institute;2003-05
2 ZHANG Kuan-di,LV Hong-xing,WANG Zheng-zhong,ZHAO Yan-feng(College of Water Resources and Architectural Engineering,Northwest A & F University,Yangling Shaanxi 712100,China);Application of Pattern Search Optimization in Calculation of Normal Depth in Trapezoidal Canal[J];Journal of Yangtze River Scientific Research Institute;2009-09
3 YANG Yan(Changjiang Engineering Vocational College,Wuhan 430212,China);Application of Excel in Teaching Hydraulics[J];Journal of Changjiang Engineering Vocational College;2011-03
4 LIU Gang1,TENG Kai2(1.Qiqihar City Flood Control Headquarters Office,Qiqihaer,Heilongjiang 161006,China;2.Qiqihar City Water Conservancy Affairs Bureau,Qiqihaer,Heilongjiang 161006,China);Simplified Approximate Calculation Method for Critical Water Depth of Circular Section[J];Journal of Water Resources and Architectural Engineering;2011-06
5 CAi De-suo1,2,TAO Jun-bo2,QIU Fei3,YANG Tai-qin2 (1.China Three Gorges University,Yichang 443002,China;2.College of Civil and Architectural Engineering,Guangxi University,Nanning 530004,China;3.Yulin Hydraulic Electric Power Reseach Institute,Yulin 537000,China);The new algorithm of nonlinear constrained optimization calculation of critical water depth problem's new algorithm[J];Journal of Guangxi University(Natural Science Edition);2007-03
6 GE Jie-zhong~1,WANG Cheng-xian~2(1.Hengyang Water Conservancy and Hydroelectric Power Planning and Design Institute,Hengyang 421008,China;2.North China Institute of Water Conservancy and Hydroelectric Power,Zhengzhou 450011,China);On Iteration Algorithms of Uniform Flow Depth and Critical Water Depth in Open Channels[J];Journal of North China Institute of Water Conservancy and Hydroelectric Power;2006-04
7 YANG Mao-song1;WANG Qing2;and MA Zi-pu3(1.Chinese Water Conservancy & Hydroelectric Power Engineering Bureau No.5 Limited Company,Chengdu 610066,China;2.Institute of Water Conservancy & Hydroelectric Power Engineering Affiliated to Hehai University,Nanjing 210098,China;3.Water Resources & Architectural Engineering Institute Affiliated to Northwest A&F University,Yangling 712100,China);Calculation Method of Contraction Water Depth for Common Cross-section Based on MATLAB Language[J];Heilongjiang Science and Technology of Water Conservancy;2012-01
8 ZHAO Yan-feng,WANG Zheng-zhong,XU Jing-hui,LU Qin(College of Water Resources and Architectural Engineering,Northwest A&F University,Yangling 712100,Shaanxi Province,china);Application of Matlab Language in Hydraulic Calculation of Open Trapezoidal Channel[J];Water Saving Irrigation;2008-04
9 Zheng Lihui Fan Guozhi Wei Yiliang Song Guangshen(Chemical Engineering &Environmental Enginering Department,Wuhan Polytechnic University,Wuhan,430023,Hubei,China);Iteration solving for non-linear equation by Excel[J];Computers and Applied Chemistry;2008-11
10 Yang Mingbo Lu Jianli Yang Min(College of Mathematics and Information Science,Henan Normal University,Xinxiang 453007,Henan,China);AUTOMATIC ITERATIVE COMPUTATIONS BASED ON CIRCULAR REFERENCE OF EXCEL[J];Computer Applications and Software;2008-12
【Co-citations】
Chinese Journal Full-text Database 10 Hits
1 ZHAO Yan-feng,SONG Songbai,MENG Qin-qian(College of Water Resources and Architectural Engineering,Northwest A&FUniversity,Yangling 712100,China);Approximate Method Calculating Critical Water Depth in Common City-opening Shaped Cross-section[J];Journal of Yangtze River Scientific Research Institute;2008-04
2 ZHANG Kuan-di,LV Hong-xing,WANG Zheng-zhong,ZHAO Yan-feng(College of Water Resources and Architectural Engineering,Northwest A & F University,Yangling Shaanxi 712100,China);Application of Pattern Search Optimization in Calculation of Normal Depth in Trapezoidal Canal[J];Journal of Yangtze River Scientific Research Institute;2009-09
3 L Hong-xing 1,YANG Cen 1,LU Ze-sheng 2,LUAN Wei-gong 2,BA Duo-duo 1,LI Jian-xiong 2 (1.College of Water Resources and Architectural Engineering,Northwest Sci-tech University of Agriculture and Forestry,Yangling 712100,China;2.Taohe River Water Transfer Project Water Resources and Hydropower Development Co.Ltd of Gansu Province,Lanzhou 730030,China);Prototype Observation on Roughness of Main Channel of Taohe River Water Transfer First-phase Project(1)——Research Method and Monitoring of Water-level and Discharge[J];Journal of Yangtze River Scientific Research Institute;2009-12
4 LV Hong-xing1,LU Ze-sheng2,LUAN Wei-gong2,BA Duo-duo1,LI Jian-xiong2,YANG Cen1(1.College of Water Resources and Architectural Engineering,Northwest Sci-tech University ofAgriculture and Forestry,Yangling 712100,China;2.Taohe River Water Transfer Project WaterResources and Hydropower Development Co.Ltd of Gansu Province,Lanzhou 730030,China);Prototype Observation Research on Roughness of Main Channel of Taohe River Water Transfer First-phase Project(2)——Result and Economic Benefit of Prototype Observation[J];Journal of Yangtze River Scientific Research Institute;2010-02
5 LENG Chang-jian,WANG Zheng-zhong(Research Center of Water Engineering Safety and Disaster Prevention, Northwest A & F University,Yangling Shaanxi712100,China);Formula for Calculating Contracted Water Depth of Channel with Cubic Parabola Cross Section[J];Journal of Yangtze River Scientific Research Institute;2011-04
6 YANG Min(Teaching Research Group of Mathematics,Xinxiang Medical University,Xinxiang 453003,China);The Calculation of All Eigenvalues and Eigenvectors of Real Symmetric Matrix by Excel[J];Computer Knowledge and Technology;2010-12
7 ZHU Ke-lin(College of Water Resources and Architectural Engineering,Northwest A & F University,Yangling,Shaanxi 712100,China);Solution Formula for Critical Water Depth of Semi-circular Section[J];Journal of Water Resources and Architectural Engineering;2010-01
8 YIN Yan-ping,LV Hong-xing,ZHANG Kuan-di(College of Water Resources and Architectural Engineering,Northwest A & F University,Yangling,Shaanxi 712100,China);A New Method for Solving Normal Depth of Circular Drainage Pipe Line[J];Journal of Water Resources and Architectural Engineering;2011-04
9 LIU Gang1,TENG Kai2(1.Qiqihar City Flood Control Headquarters Office,Qiqihaer,Heilongjiang 161006,China;2.Qiqihar City Water Conservancy Affairs Bureau,Qiqihaer,Heilongjiang 161006,China);Simplified Approximate Calculation Method for Critical Water Depth of Circular Section[J];Journal of Water Resources and Architectural Engineering;2011-06
10 LIU Gang1,TENG Kai2(1.Qiqihar City Flood Control Headquarters Office,Qiqihar,Heilongjiang 161006,China;2.Qiqihar City Water Conservancy Affairs Bureau,Qiqihar,Heilongjiang 161006,China);Approximate Calculation Formula for Uniform Flow Depth of Trapezoidal Cross-section[J];Journal of Water Resources and Architectural Engineering;2012-01
【Secondary Citations】
Chinese Journal Full-text Database 10 Hits
1 Liu Ling Liu Yisheng (College of Economics and Management, Northern Jiaotong University, Beijing 100044);Calculating Method for Conjugate Depth of Hydraulic Jump in Trapezoidal Channels[J];JOURNAL OF NORTHERN JIAOTONG UNIVERSITY;1999-03
2 Chen Feiyong (Yangtze River Scientific Research Institute, Wuhan 430010);A Method for Calculating Critical Water Depth of Open Channel with Trapezoid Section and Smooth Slope[J];Journal of Yangtze River Scientific Research Institute;1993-04
3 LU Hong xing,XIN Quan cai,HUA Li feng (College of Water Conservancy and Architectural Engineering, Northwest Sci Tech University of Agriculture and Forestry,Yangling 712100,China);Calculation on normal depth of horseshoe cross section by iterative method[J];Journal of Yangtze River Scientific Research Institute;2001-03
4 LV Hong-xing(College of Water Conservancy and Architectural Engineering,Northwest Sci-Tech University of Agriculture and Forestry, Yangling, 712100, China);Calculation on critical depth of horseshoe cross-section by iterative method[J];Journal of Yangtze River Scientific Research Institute;2002-03
5 LU Hong?xing, BA Duo?duo,SONG Song?bai (College of Water Conservancy and Architecture Engineering of Northwest Science and Technology University of Agriculture & Forestry, Yangling 712100,China);Hydraulic calculation for free flow in circular section by iterative method[J];Journal of Yangtze River Scientific Research Institute;2003-05
6 WANG Zheng-zhong~(1,2),CHEN Tao~1,WAN Bin~1,ZHANG Xin-min~3 (1.College of Water Conservancy and Architectural Engineering,Northwest Sci-tech University of Agriculture and Forestry, Yangling, 712100,China;;3.Lanzhou University, Lanzhou 730000, China);A new approximate formula to critical depth of round section canal[J];Journal of Yangtze River Scientific Research Institute;2004-02
7 WANG Zheng-zhong~1,SHEN Yong-kang~2,PENG Yuan-ping~3,CHEN Tao~1,ZhaoYing~4 (1.Water Conservancy and Construction Engineering Institute, Northwest Sci-Tech University of Agriculture and Forestry, Yangling712100, China; 2.Hohai Univ.,Nanjing210098, China; 3.Baoji City Water Conservancy and Hydrppower Engineering Planning Design Institution, Baoji721000,China; 4.Shangnan County Water Conservancy Bureau, Shangnan726306,China);Direct Formula Calculating Critical Depth for Open Trapezoidal Channel with Spherical Bed[J];Journal of Yangtze River Scientific Research Institute;2005-03
8 ZHAO Yan-feng,SONG Songbai,MENG Qin-qian(College of Water Resources and Architectural Engineering,Northwest A&FUniversity,Yangling 712100,China);Approximate Method Calculating Critical Water Depth in Common City-opening Shaped Cross-section[J];Journal of Yangtze River Scientific Research Institute;2008-04
9 WEN Hui,LI Feng-ling(Department of architecture Maoming University,Guangdong Maoming 525000,China);Analytical Solution of Water Depth in Parabolic-Shaped Channel with Contracted Section[J];Journal of Yangtze River Scientific Research Institute;2009-09
10 Wang Zhengzhong(College of Water Conservancy,North Western Agricultural University,Yang Ling, Shanxi,712100);Inquiry on a Formula for Calculating Critical Depth of Open-Channel Flow with Trapezoidal Cross-Section[J];JOURNAL OF YANGTZE RIVER SCIENTIFIC RESEARCH INSTITUTE;1995-02
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved