Construction and Architecture Construction and Architecture Строительство и архитектура 2308-0191 2500-1477 6a84bbd494fbba14f78618d2 10.29039/2308-0191-2021-9-4-66-70 ИНФОРМАЦИОННЫЕ ТЕХНОЛОГИИ В СТРОИТЕЛЬНОЙ ОТРАСЛИ INFORMATION TECHNOLOGIES IN CIVIL ENGINEERING ИНФОРМАЦИОННЫЕ ТЕХНОЛОГИИ В СТРОИТЕЛЬНОЙ ОТРАСЛИ INTERFACE INTERACTION OF THE BIM SOFTWARE WITH MS OFFICE ИНТЕРФЕЙСНОЕ ВЗАИМОДЕЙСТВИЕ BIM ПРОГРАММЫ С MS OFFICE Суркова Людмила Евгеньевна Surkova Lyudmila Evgen'evna LSurkova2004@yandex.ru

кандидат технических наук;

candidate of technical sciences;

 Давыдов Денис Владимирович Davydov Denis Vladimirovich danx@mail.ru Московский государственный строительный университет Moscow State University of Civil Engineering ООО «Цифровые технологии» Москва Россия Digital technologies Moscow Russian Federation 66 70 04 12 2021 © Суркова Л.Е., Давыдов Д.В. © Surkova L.E., Davydov D.V. Суркова Людмила Евгеньевна, Давыдов Денис Владимирович Surkova Lyudmila Evgen'evna, Davydov Denis Vladimirovich https://build-pro.editorum.ru/en/nauka/publications/6a84bbd494fbba14f78618d2/view

В работе исследуются необходимость и возможность интерфейсного взаимодействия программы информационного моделирования Revit Autodesk с распространенной офисной программой MS Excel. Такое взаимодействие позволяет облегчить подготовку проектной документации согласно требованиям Российских стандартов, ГОСТ. Анализ возможностей встроенных инструментов Revit по созданию спецификаций и их оформлению по требованиям ГОСТ показал недостаточный уровень автоматизации этих процессов. Готовые зарубежные и российские решения в области плагинов Revit, реализующие взаимодействие с Excel, имеют ряд недостатков. Целью данной статьи является демонстрация возможностей интерфейса прикладного программирования (API) для создания приложений на примере разработанного программного решения по автоматизации выгрузки информации из BIM модели в табличный документ Excel, для приведения в соответствие стандартов представления данных по требованиям ГОСТ. Приложение разработано с использованием инструментальной среды: язык программирования C#, среда разработки MS Visual Studio, средство создания пользовательского интерфейса WPF, интерфейс прикладного программирования на стороне Revit.Net API, интерфейс взаимодействия с файлами Excel ClosedXML. В результате представлен интерфейс разработанного плагина. Программа позволяет экспортировать документы – ведомости и спецификации – в Excel, оформленные по требованиям ГОСТ. Удобный пользовательский интерфейс на основе вкладок, соответствие дизайна программы системе Revit и реализованный функционал дают программе преимущества перед аналогами. Приложение доступно для бесплатной загрузки любому пользователю Revit, что имеет практическую значимость.

The paper examines the necessity and possibility of interface interaction of the information modeling program Revit Autodesk with the common office program MS Excel. Such interaction makes it easier to prepare project documentation in accordance with the requirements of Russian standards, GOST. An analysis of the capabilities of the built-in Revit tools for creating specifications and their design according to GOST requirements showed an insufficient level of automation of these processes. Ready-made foreign and Russian solutions in the field of Revit plugins that implement interaction with Excel have a number of disadvantages. The purpose of this article is to demonstrate the capabilities of the application programming interface (API) for creating applications using the example of a developed software solution for automating the unloading of information from a BIM model into an Excel electronic document, in order to bring data presentation standards in line with GOST requirements. The application is developed using a tool environment: the C# programming language, the MS Visual Studio development environment, the WPF user interface creation tool, the Revit-side application programming interface .Net API, an interface for interacting with Excel ClosedXML files. As a result, the interface of the developed plugin is presented. The program allows you to export documents-statements and specifications - to Excel, designed according to the requirements of GOST. The user-friendly tab-based user interface, the compliance of the program design with the Revit system and the implemented functionality give the program advantages over its analogues. The application is available for free download to any Revit user, which is of practical importance.

 BIM моделирование плагин спецификация компьютерные программы ГОСТ BIM modeling plugin specification computer programs GOST

I.L. Kievsky, A.Yu. Krutyakov, O.A. Ivanova, A.Yu. Chitaev, I.P. Mykytiv, Experience in the use of domestic and imported BIM-products in the design of residential buildings, Industrial and civil construction, 2020, 11, DOI: 10.33622/0869-7019.2020.11.42-48 (2020) I.L. Kievsky, A.Yu. Krutyakov, O.A. Ivanova, A.Yu. Chitaev, I.P. Mykytiv, Experience in the use of domestic and imported BIM-products in the design of residential buildings, Industrial and civil construction, 2020, 11, DOI: 10.33622/0869-7019.2020.11.42-48 (2020) J. Zolotova, N. Vatin, Autodesk Revit - Key to successful training of highly qualified civil engineers, Applied mechanics and materials, 2015, 725-726 (2015) J. Zolotova, N. Vatin, Autodesk Revit - Key to successful training of highly qualified civil engineers, Applied mechanics and materials, 2015, 725-726 (2015) O. Javed, A. Javed, Y. Ali, M. Adil, Application of ICT and BIM in the implementation of Building Byelaws, Second International Sustainability and Resilience Conference: Technology and Innovation in Building Designs (51154), 2020, pp. 1-3, DOI: 10.1109/IEEECONF51154.2020.9319975 (2020) O. Javed, A. Javed, Y. Ali, M. Adil, Application of ICT and BIM in the implementation of Building Byelaws, Second International Sustainability and Resilience Conference: Technology and Innovation in Building Designs (51154), 2020, pp. 1-3, DOI: 10.1109/IEEECONF51154.2020.9319975 (2020) N.Q. Toan, N.T.T. Hang, L.H. Nam, D.H. Duyen, T.P. Nam, Application of Building Information Modeling (BIM) for automatic integration of construction costs management information into 3D models in consideration of Vietnamese regulations, International Scientific Conference on Advance in Civil Engineering: Construction - The Formation of Living Environment, FORM 2020, Hanoi, 2020, v 869, is 69, 06200723 (2020) N.Q. Toan, N.T.T. Hang, L.H. Nam, D.H. Duyen, T.P. Nam, Application of Building Information Modeling (BIM) for automatic integration of construction costs management information into 3D models in consideration of Vietnamese regulations, International Scientific Conference on Advance in Civil Engineering: Construction - The Formation of Living Environment, FORM 2020, Hanoi, 2020, v 869, is 69, 06200723 (2020) M. Dawood, BIM Based Bridge Management System. In: Şahin S. (eds) 8th International Conference on Engineering, Project, and Product Management (EPPM 2017). EPPM 2017. Lecture Notes in Mechanical Engineering. Springer, Cham. https://doi.org/10.1007/978-3-319-74123-9_17 (2018) M. Dawood, BIM Based Bridge Management System. In: Şahin S. (eds) 8th International Conference on Engineering, Project, and Product Management (EPPM 2017). EPPM 2017. Lecture Notes in Mechanical Engineering. Springer, Cham. https://doi.org/10.1007/978-3-319-74123-9_17 (2018) L.E. Surkova, D.V. Davydov, Analysis of the possibilities of integrating bim modeling software with an office application, Informationand Technological Bulletin, 2021, 2(28), https://elibrary.ru/item.asp?id=46376899 (2021) L.E. Surkova, D.V. Davydov, Analysis of the possibilities of integrating bim modeling software with an office application, Informationand Technological Bulletin, 2021, 2(28), https://elibrary.ru/item.asp?id=46376899 (2021) Export-Import Excel, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=6290726048826015851&appLang=en&os=Win64 (2021) Export-Import Excel, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=6290726048826015851&appLang=en&os=Win64 (2021) Tables, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=2349381363455444680&appLang=en&os=Win64 (2021) Tables, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=2349381363455444680&appLang=en&os=Win64 (2021) SheetLink Excel Import/Export, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=4089038677237188183&appLang=en&os=Win64 (2021) SheetLink Excel Import/Export, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=4089038677237188183&appLang=en&os=Win64 (2021) Specification according to GOST in one click, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=515154252762362011&appLang=ru&os=Win64 (2021) Specification according to GOST in one click, Autodesk App Store, https://apps.autodesk.com/RVT/ru/Detail/Index?id=515154252762362011&appLang=ru&os=Win64 (2021) M. Mason, Extending BIM Design Value Using the Revit Api, AUGI, The world’s largest CAD & BIM User Group, 2009, https://www.augi.com/articles/detail/extending-bim-design-value-using-the-revit-api#:~:text=An%20application%20programming%20interface%20(API,new%20functionality%20to%20the%20software.&text=Power%20users%20and%20software%20developers,create%20their%20own%20custom%20tools (2021) M. Mason, Extending BIM Design Value Using the Revit Api, AUGI, The world’s largest CAD & BIM User Group, 2009, https://www.augi.com/articles/detail/extending-bim-design-value-using-the-revit-api#:~:text=An%20application%20programming%20interface%20(API,new%20functionality%20to%20the%20software.&text=Power%20users%20and%20software%20developers,create%20their%20own%20custom%20tools (2021) T. Northrop, B. Ryan, S. Wildermus, Basics of developing applications on the Microsoft .NET Framework, Training course Microsoft, Russian Edition, SPb.: Peter (2007) T. Northrop, B. Ryan, S. Wildermus, Basics of developing applications on the Microsoft .NET Framework, Training course Microsoft, Russian Edition, SPb.: Peter (2007) R.M. Smakaev, T.A. Nizina, Application of dynamo visual programming environment in the development of a building project in Autodesk Revit, Basics of EUP, Publishing House of Mordovian University, Saransk, 2020, 2(21) (2020) R.M. Smakaev, T.A. Nizina, Application of dynamo visual programming environment in the development of a building project in Autodesk Revit, Basics of EUP, Publishing House of Mordovian University, Saransk, 2020, 2(21) (2020) D. Shishina, P. Sergeev, Revit Dynamo: designing objects of complex forms, Toolkit and process automation features, AEJ, 2019, 3 (2019) D. Shishina, P. Sergeev, Revit Dynamo: designing objects of complex forms, Toolkit and process automation features, AEJ, 2019, 3 (2019) Y. Weng, N.A.N. Mohamed, B.J.S. Lee, N.J.H. Gan, M. Li, M. Jen Tan, H. Li, S. Qian, Extracting BIM Information for Lattice Toolpath Planning in Digital Concrete Printing with Developed Dynamo, Journal of Computing in Civil Engineering, v 35, is 31 (2021) Y. Weng, N.A.N. Mohamed, B.J.S. Lee, N.J.H. Gan, M. Li, M. Jen Tan, H. Li, S. Qian, Extracting BIM Information for Lattice Toolpath Planning in Digital Concrete Printing with Developed Dynamo, Journal of Computing in Civil Engineering, v 35, is 31 (2021) Z. Jin, J. Gambatese, BIM for temporary structures: Development of a Revit API plug-in for concrete formwork, Proceedings, Annual Conference - Canadian Society for Civil Engineering, Canadian Society for Civil Engineering Annual Conference, CSCE 2019, Laval, 2019, v 153, pp 915-919 (2019) Z. Jin, J. Gambatese, BIM for temporary structures: Development of a Revit API plug-in for concrete formwork, Proceedings, Annual Conference - Canadian Society for Civil Engineering, Canadian Society for Civil Engineering Annual Conference, CSCE 2019, Laval, 2019, v 153, pp 915-919 (2019) S.P. Zotkin, E.V. Ignatova, I.A. Zotkina, The Organization of Autodesk Revit Software Interaction with Applications for Structural Analysis, v21, is2, pp244 - 258 (2021) https://doi.org/10.1016/j.proeng.2016.08.225,) S.P. Zotkin, E.V. Ignatova, I.A. Zotkina, The Organization of Autodesk Revit Software Interaction with Applications for Structural Analysis, v21, is2, pp244 - 258 (2021) https://doi.org/10.1016/j.proeng.2016.08.225,) F. Rodrigues, F. Antunes, R. Matos, Safety plugins for risks prevention through design resourcing BIM, DOI:10.1007/978-3-319-61645-2_9 (2018) F. Rodrigues, F. Antunes, R. Matos, Safety plugins for risks prevention through design resourcing BIM, DOI:10.1007/978-3-319-61645-2_9 (2018) N. Randolph, D. Gardner, M. Minutillo, Ch. Anderson, Professional Visual Studio 2010 (2011) N. Randolph, D. Gardner, M. Minutillo, Ch. Anderson, Professional Visual Studio 2010 (2011) DenisDavydov1/Excel Specification GOST, Github, URL: https://github.com/DenisDavydov1/ExcelSpecificationGOST (2021) DenisDavydov1/Excel Specification GOST, Github, URL: https://github.com/DenisDavydov1/ExcelSpecificationGOST (2021)