基于Excel的隧洞工程初期支护工程量参数化计算

The Parameterized Calculation of Initial Stage Supporting Works Construction Quantities of A Tunnel Based on Excel

隧洞工程初期支护计算是一项方法简单、过程繁琐的工程量计算。常规的圆拱直墙形、圆形和标准马蹄形隧洞,其扩挖断面均有关键几何参数的推导过程,较复杂,故实现参数化计算缺少理论依据。推导出各型隧洞关键几何参数的数学计算公式,结合Excel自身强大的数学计算能力,可轻松实现常规断面型式的隧洞工程初期支护的参数化计算,可大幅提高计算效率。

The initial stage support calculation of a Tunnel is calculation of its construction quantities,which requires a simple method but fussy process.The derivation process of the key geometric parameters of a conventional arch-straight wall-shaped tunnel or a circular tunnel or a U-shaped tunnel is rather complicated in terms of their excavation sections and so far no enough theoretical basis is available to implement parameterization.Derivation of the mathematical calculation equations of the key geometric parameters for different types of tunnel in combination with the the Excel powerful mathematical calculation capability can easily implement the parameterized calculation of the initial stage supporting works of the tunnel with a conventional cross-section and its calculation efficiency could be significantly improved.