Submit an Article
Become a reviewer
Vol 150 No 1
Pages:
75-78
Download volume:
RUS

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

Authors:
M. A. Nikitin1
K. M. Pavlenko2
About authors
  • 1 — Student, research assistant G.V. Plekhanov Saint Petersburg Mining University
  • 2 — Student, research assistant G.V. Plekhanov Saint Petersburg Mining University
Date submitted:
2001-06-29
Date accepted:
2001-07-13
Date published:
2002-03-14

Abstract

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.

Go to volume 150

Similar articles

Improvement of mine drainage management system by means of short-term forecast of water inflows
2002 A. V. Lisitskii
Mineralogical and geochemical features and staging of Au-Sb-W mineralization of Verkhne-Yenashiminskoye ore cluster deposits (Yenisei Ridge, Siberia)
2002 A. A. Savichev, S. P. Nagaeva
Computer presentation of the report "Application of Excel Spreadsheets in Calculation of Beams for Strength and Stiffness" by means of Powerpoint
2002 T. A. Yakovleva
Application of georadiolocation method for nondestructive control of the condition of hard-type roads
2002 A. I. Kulikov
Simulation of a vertical hydraulic transport system with a submerged capsule
2002 I. A. Chilikin
Selection of settings of digital overhead line protection devices with insulated wires
2002 Yu. M. Borodyanskii