Motion of cranes of bridge type simulation in the MS Excel environment

Abstract

The idle times of the crane caused by need of replacement of wheels, can have critical value for functioning of a logistic chain. In article the task about the movement of the crane with a skew with the accounting of several mutually influencing processes having various nature is considered. The solution of this task has important applied value for increase in a resource of wheels. For the crane designs, more varied, a known problem is representation of results in a suitable form for engineering calculations, as a compromise between simplicity and quality of the results. Possible solution is modelling in the environment of MS Excel. This approach allows the best way to provide the necessary engineering calculations for simplicity, clarity and reliability of the submission and processing of a large number of heterogeneous data. As an example, modelling of an elastic skeleton of the crane in dynamics that represents complexity in view of lack of specialized mathematical apparatus is considered.