Researching Transformation of Analytical Data Obtained from Visual Programming System «Dynamo» into Microsoft Excel Worksheets

Construction companies face barriers and challenges in adopting BIM, as there are no guidelines or best practices they could study and use in their activities. One of the most difficult and time-consu­ming tasks in designing construction projects is calculating the volume of earthworks, which sometimes has to be done in difficult climatic conditions. The article presents a study of using BIM technology and the development of a script in the visual programming environment «Dynamo», which will simplify this labour intensive process without losing its quality and saving time for other design tasks. The deve­loped script can be used when calculating earthworks and studying their fill diagram in order to cut costs of performing initial construction works by designing marks on the Earth’s surface. It can be used in road building when plotting the most economically feasible route in terms of construction costs. The use of the developed script will significantly reduce the time of performing a big amount of same type repetitive operations when developing representative units or creating complex parametric geometry.