Falling head calculation spreadsheet

MS Excel spreadsheet based on an automated formula with a solver. It serves for hydraulic conductivity calcuclation and error estimation by fitting the parameters of the theoretical formula (Darcy Equation) to the field data. The spreadsheet was developed to analize data collected by the falling head method in permeability investigation of riverbed sediments.本数据集为基于搭载求解器的自动化公式构建的微软Excel（MS Excel）电子表格。该电子表格可通过将理论公式（达西公式（Darcy Equation））的参数与野外实测数据进行拟合，实现渗透系数（hydraulic conductivity）的计算与误差估计。本电子表格专为分析河床沉积物渗透性勘察中采用变水头法（falling head method）采集的试验数据而开发。