预应力筋张拉伸长值计算与Excel VBA

Calculation of the stretching length of prestressed bar and Excel VBA

针对后张法预应力筋伸长值计算中的应力损失与两端张拉中平衡点位置的求解问题,探讨了后张法伸长值的计算方法,研究了运用上述计算方法结合VBA对平衡点的求解,阐述了Excel VBA编程的优点,从而提高工程张拉计算速度。

According to the prestress loss in the calculation of the stretching length of prestressed bar by post-tensioning method, and the solution of balancing point location in stretching the two sides, it discusses the calculation method of the stretching length by post-tensioniNg method, makes a research on the solution of balancing point by the above method and VBA, and illustrates the advantages of Excel VBA programming, so as to speed the calculation of project stretching.