| Autor: |
Uroš Klanšek, Borna Dasović |
| Rok vydání: |
2021 |
| Předmět: |
|
| Zdroj: |
New Technologies, Development and Application IV ISBN: 9783030752743 |
| DOI: |
10.1007/978-3-030-75275-0_116 |
| Popis: |
Successful completion of a construction project depends to a large extent on the appropriate scheduling of its activities. When planning the execution of a construction project, some of the activities critical to the project must be compressed in order to meet the construction deadline. The aim of cost-optimal scheduling is therefore to accelerate the activities so that only minimal costs are incurred. In this paper, a spreadsheet solution for cost-optimal construction scheduling by using internet-based solvers is presented. The basic idea is to develop an optimization model within a spreadsheet, arrange all input parameters and run the optimization process on a web-based service for solving numerical optimization problems. To demonstrate the benefits of the proposed approach, an example is given. The problem of cost-optimal project scheduling is modeled in MS Excel and then solved by MS Excel add-in, called OpenSolver. The add-in converts the optimization problem into an algebraic modeling language formulation and forwards the model to NEOS (Network-Enabled Optimization System). The optimization results are automatically returned to MS Excel and presented in a form of a Gantt chart. The paper shows the advantages of the proposed approach, along with the conclusions and recommendations for further research. |
| Databáze: |
OpenAIRE |
| Externí odkaz: |
|
