Application of excel spreadsheets in the calculation of building structures for bending
- 1 — Student, research assistant G.V. Plekhanov Saint Petersburg Mining University
- 2 — Student, research assistant G.V. Plekhanov Saint Petersburg Mining University
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.