Spreadsheet Solution for Cost-Optimal Construction Scheduling Through Utilization of Internet-Based Solvers

2021 ◽  
pp. 1055-1062
Author(s):  
Borna Dasović ◽  
Uroš Klanšek
Keyword(s):  
Construction Scheduling ◽  
Optimal Construction

scholarly journals Integration of Mixed-Integer Nonlinear Program and Project Management Tool to Support Sustainable Cost-Optimal Construction Scheduling

2021 ◽  
Vol 13 (21) ◽  
pp. 12173
Author(s):  
Borna Dasović ◽  
Uroš Klanšek
Keyword(s):  
Project Management ◽  
Optimal Schedule ◽  
Indirect Costs ◽  
Management Tool ◽  
Mixed Integer ◽  
Task Completion ◽  
Nonlinear Program ◽  
Project Schedule ◽  
Construction Scheduling ◽  
Optimal Construction

This paper presents the integration of mixed-integer nonlinear program (MINLP) and project management tool (PMT) to support sustainable cost-optimal construction scheduling. An integrated structure of a high-level system for exact optimization and PMT was created. To ensure data compatibility between the optimization system and PMT and to automate the process of obtaining a cost-optimal schedule, a data transformation tool (DTT) was developed within a spreadsheet application. The suggested system can determine: (i) an optimal project schedule with associated network diagram and Gantt chart in continuous or discrete time units; (ii) optimal critical and non-critical activities, including their early start, late start, early finish, late finish along with total and free slack times; and (iii) minimum total project cost along with the allocation of direct and indirect costs. The system provides functionalities such as: (i) MINLP can be updated, and schedules can be re-optimized; (ii) the optimal schedule can be saved as a baseline to track changes; (iii) different optimization algorithms can be engaged whereby switching between them does not require model changes; (iv) PMT can be used to track task completion in the optimized schedule; (v) calendar settings can be changed; and (vi) visual reports can be generated to support efficient project management. Results of cost-optimal project scheduling are given in a conventional PMT environment, which raises the possibility that the proposed system will be more widely used in practice. Integration of MINLP and PMT allows each software to be used for what it was initially designed. Their combination leads to additional information and features of optimized construction schedules that would be significantly more difficult to achieve if used separately. Application examples are given in the paper to show the advantages of the proposed approach.

scholarly journals Scheduling Construction Projects Under Fuzzy Modelling of Resource Constraints

2018 ◽  
Vol 196 ◽  
pp. 04045
Author(s):  
Janusz Kulejewski ◽  
Nabi Ibadov ◽  
Michał Krzemiński
Keyword(s):  
Construction Projects ◽  
Resource Constraints ◽  
Original Method ◽  
Fuzzy Modelling ◽  
Construction Scheduling ◽  
Customer Preferences ◽  
Level Of Use ◽  
Construction Schedule ◽  
Sets Theory ◽  
Optimal Construction

Paper presents the original method of construction scheduling using fuzzy sets theory. The essence of the method is to obtain an optimal construction schedule based on the solution of the fuzzy RCPS problem with flexible restrictions. The article introduces two important modifications of the considered issue. These modifications are: maximization of the degree of fulfillment of customer preferences regarding the time span of the project implementation and the contractor's preference regarding the level of use of renewable resources, for example - the level of employment of workers. The article also contains a numerical example showing the procedure for applying the described method.

DEVELOPMENT OF INTEGRATED MONITORING NETWORK FOR MEASURING SALINITY OF SEA WATER

2018 ◽  
pp. 18-26
Author(s):  
Sima Ajdar qizi Askerova
Keyword(s):  
Surface Waters ◽  
Sea Water ◽  
Water Environment ◽  
Monitoring Network ◽  
Monitoring Networks ◽  
The Caspian Sea ◽  
Integrated Monitoring ◽  
Ecological Control ◽  
Different Depths ◽  
Optimal Construction

Monitoring of sea water condition is one of major requirements for carrying out the reliable ecological control of water environment. Monitoring networks contain such elements as sea buoys, beacons, etc. and are designated for measuringvarious hydrophysical parameters, including salinity of sea water. Development of specialized network and a separate buoy system for measuring thesea water salinity at different depths makes it possible to determine major regularities of processes of pollution and self-recovery of the sea waters. The article describes the scientific and methodological basics for development of this specialized network and questions of its optimal construction. It is well-known that at a depth of 30-45 m of the Caspian Sea salinity decreases and then at a depth of 45-60 m salinity is fully recovered. The mentioned changes of salinity at the relatively upper layer of sea waters is of special interest for studying the effect of ocean-going processes on the climate forming in the Caspian area. In terms of informativeness of measurements of surface waters salinity, the most informative is a layer ata 30-60 m depth, where inversion and recovery of salinity take place. It is shown that in most informative subrange of measurements, i. e. at a depth of 30-60 m optimization of regime of measurements complex should be carried out in order to increase the effectiveness of held researches. It is shown that at a depth of 35-50 m choice of the optimum regime of measurements makes it possible to obtain the maximum amount of information.

A novel construction scheduling framework for a mixed construction process of precast components and cast-in-place parts in prefabricated buildings

2021 ◽  
Vol 43 ◽  
pp. 103181
Author(s):  
Bin Yang ◽  
Boda Liu ◽  
Jianzhuang Xiao ◽  
Binghan Zhang ◽  
Zhichen Wang ◽  
...  
Keyword(s):  
Construction Process ◽  
Construction Scheduling

scholarly journals Acceptance of Construction Scheduling Visualizations: Bar-charts, Flowline-charts, Or Perhaps BIM?

2016 ◽  
Vol 164 ◽  
pp. 558-566 ◽  
Author(s):  
Christian Nordahl Rolfsen ◽  
Christoph Merschbrock
Keyword(s):  
Construction Scheduling

scholarly journals AN EXACT SOLUTION FOR THE RESOURCE-CONSTRAINED CONSTRUCTION SCHEDULING PROBLEM

2016 ◽  
Vol 8 (2) ◽  
pp. 71-78
Author(s):  
Bartłomiej Sroka ◽  
Elżbieta Radziszewska-Zielina
Keyword(s):  
Execution Time ◽  
Critical Path ◽  
Scheduling Problem ◽  
Resource Constrained ◽  
Building Projects ◽  
Construction Scheduling ◽  
Program Sample ◽  
Resource Constrained Scheduling Problem ◽  
The Cost ◽  
Exponential Complexity

Reduced time and, by the same token, the cost of the project is a crucial factor in contemporary construction. This article presents a method for the exact optimisation of a resource-constrained scheduling problem. Based on the Critical Path Method, graph theory and linear programming, an algorithm was developed and the FROPT program was written in Matlab to minimise the execution time of the task. By using the newly-created program, sample networks were calculated and the results were compared with results obtained by using the MS Project scheduling program (using approximation algorithm). The execution time obtained by using FROPT were on average 10% shorter than those obtained using MS Project. In selected cases the improvement in execution time reached 25%. A deterministic approach to the problem may shorten planned project times and bring financial benefits. Due to the exponential complexity of the algorithm, it is most useful in solving small or highly coherent networks. The algorithm and program may result in benefits not offered by commercial software for planners of building projects.

Sign in / Sign up

Export Citation Format

Share Document