An integration of spreadsheet and project management software for cost optimal time scheduling in construction

Valenko Tadej () and Klanšek Uroš ()
Additional contact information
Valenko Tadej: University of Maribor, Faculty of Civil Engineering, Transportation Engineering and Architecture, Smetanova ulica 17, 2000 Maribor, Slovenia
Klanšek Uroš: University of Maribor, Faculty of Civil Engineering, Transportation Engineering and Architecture, Smetanova ulica 17, 2000 Maribor, Slovenia

Organization, Technology and Management in Construction, 2017, vol. 9, issue 1, 1627-1637

Abstract: Successful performance and completion of construction projects highly depend on an adequate time scheduling of the project activities. On implementation of time scheduling, the execution modes of activities are most often required to be set in a manner that enables in achieving the minimum total project cost. This paper presents an approach to cost optimal time scheduling, which integrates a spreadsheet application and data transfer to project management software (PMS). At this point, the optimization problem of project time scheduling is modelled employing Microsoft Excel and solved to optimality using Solver while organization of data is dealt by macros. Thereupon, Microsoft Project software is utilized for further managing and presentation of optimized time scheduling solution. In this way, the data flow between programs is automated and possibilities of error occurrence during scheduling process are reduced to a minimum. Moreover, integration of spreadsheet and PMS for cost optimal time scheduling in construction is performed within well-known program environment that increases the possibilities of its wider use in practice. An application example is shown in this paper to demonstrate the advantages of proposed approach.

Keywords: optimization; project scheduling; spreadsheet application; project management software (search for similar items in EconPapers)
Date: 2017
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://doi.org/10.1515/otmcj-2016-0028 (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:vrs:otamic:v:9:y:2017:i:1:p:1627-1637:n:10

DOI: 10.1515/otmcj-2016-0028

Access Statistics for this article

Organization, Technology and Management in Construction is currently edited by Mladen Radujković

More articles in Organization, Technology and Management in Construction from Sciendo
Bibliographic data for series maintained by Peter Golla ().