Submit an Article
Become a reviewer
K. M. Pavlenko
K. M. Pavlenko
Student, research assistant
G.V. Plekhanov Saint Petersburg Mining University
Student, research assistant
G.V. Plekhanov Saint Petersburg Mining University

Co-authors

Articles

Development of underground space
  • Date submitted
    2001-06-29
  • Date accepted
    2001-07-13
  • Date published
    2002-01-01

Application of excel spreadsheets in the calculation of building structures for bending

Article preview

The main mechanical characteristics of building structures are generally recognized as a way to visualize the distribution of these characteristics in the structure. When studying the course of structural mechanics the tasks of calculating various structures for bending are performed. One of the well-known modern Windows applications are different versions of Microsoft Excel, implemented in the Microsoft Office software package, which is studied in the first year. A wide range of mathematical functions contained in Microsoft Excel, the implementation of the processes "Autofill", "Autosummary" allows you to significantly increase the speed of the calculation and avoid accidental computational errors. The tables with the calculations of the bending moment, longitudinal and cutting forces of the curvilinear arch, a typical shape of mine workings of underground structures, loaded with the uniformly distributed vertical and horizontal loads, have been made by means of the Microsoft Excel file. The software package MatLab has been used for the construction of diagrams of the calculated quantities; it gives an opportunity to represent an arbitrary number of dependences on the given sets of arguments and functions in one diagram. The auxiliary calculations for converting the obtained values of the diagrams into the coordinate system of the package were performed and the diagrams of the bending moment, transverse and overcrossing forces were obtained.

How to cite: Nikitin M.A., Pavlenko K.M. Application of excel spreadsheets in the calculation of building structures for bending // Journal of Mining Institute. 2002. Vol. № 1 150. p. 75-78.