Decision support within design-oriented organizational management by means of VBA

• Date: 2015
• Main Authors: Dodonov, O. G., Kuzmichov, A. I., Bocharov, V. V.
• Format: Article
• Language: Ukrainian
• Published: Інститут проблем реєстрації інформації НАН України 2015
• Subjects: рroject management; net model of a project; schedule of a project; time-cost problem; method CPM/PERT; spreadsheet model of a project
• Online Access: http://drsp.ipri.kiev.ua/article/view/100331
• Journal Title: Data Recording, Storage & Processing

For rapid response of information system managing a project realized within Excel and changes of the original data one should reduce the number of main and subsidiary operations being performed manually. To do this, by means of embedded programming language VBA, it has been performed a service software module that automates the execution of these transactions in the form of multifunctional macros. Developed for practical use, the workbook template is built for project managers without programming experience. The size of the network model «works-hubs» with an expanded set of precedence relations is not limited. It is planned solving the problem of planning and scheduling of the project by critical path method (CPM) and simulation (PERT) reducing the duration of the project tasks in the «time-cost» construction time schedule and resource demand of the circuit network model. Fig.: 3. Refs: 5 titles.