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

• Дата: 2015
• Автори: Dodonov, O. G., Kuzmichov, A. I., Bocharov, V. V.
• Формат: Стаття
• Мова: Ukrainian
• Опубліковано: Інститут проблем реєстрації інформації НАН України 2015
• Теми: рroject management; net model of a project; schedule of a project; time-cost problem; method CPM/PERT; spreadsheet model of a project; управление проектом; сетевая модель проекта; расписание (календарный план; schedule) проекта; задача «время-стоимость» (time-cost problem); метод CPM / PERT; табличная модель проекта (project spreadsheet model); управління проектом; мережева модель проекту; розклад (календарний план; schedule) проекту; задача «час-вартість» (time-cost problem); метод CPM/PERT; таблична модель проекту (project spreadsheet model)
• Онлайн доступ: http://drsp.ipri.kiev.ua/article/view/100331
• Назва журналу: 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.