An integration of spreadsheet and project management software for cost optimal time scheduling in construction
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 pro...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Sciendo
2017-12-01
|
| Series: | Organization, Technology and Management in Construction: An International Journal |
| Subjects: | |
| Online Access: | https://doi.org/10.1515/otmcj-2016-0028 |
| _version_ | 1797862002061737984 |
|---|---|
| author | Valenko Tadej Klanšek Uroš |
| author_facet | Valenko Tadej Klanšek Uroš |
| author_sort | Valenko Tadej |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-04-09T22:12:18Z |
| format | Article |
| id | doaj.art-e9b6e093e1e54d969f77f1f5cc5e8653 |
| institution | Directory Open Access Journal |
| issn | 1847-6228 |
| language | English |
| last_indexed | 2024-04-09T22:12:18Z |
| publishDate | 2017-12-01 |
| publisher | Sciendo |
| record_format | Article |
| series | Organization, Technology and Management in Construction: An International Journal |
| spelling | doaj.art-e9b6e093e1e54d969f77f1f5cc5e86532023-03-23T07:45:45ZengSciendoOrganization, Technology and Management in Construction: An International Journal1847-62282017-12-01911627163710.1515/otmcj-2016-0028otmcj-2016-0028An integration of spreadsheet and project management software for cost optimal time scheduling in constructionValenko Tadej0Klanšek Uroš1University of Maribor, Faculty of Civil Engineering, Transportation Engineering and Architecture, Smetanova ulica 17, 2000 Maribor, SloveniaUniversity of Maribor, Faculty of Civil Engineering, Transportation Engineering and Architecture, Smetanova ulica 17, 2000 Maribor, SloveniaSuccessful 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.https://doi.org/10.1515/otmcj-2016-0028optimizationproject schedulingspreadsheet applicationproject management software |
| spellingShingle | Valenko Tadej Klanšek Uroš An integration of spreadsheet and project management software for cost optimal time scheduling in construction Organization, Technology and Management in Construction: An International Journal optimization project scheduling spreadsheet application project management software |
| title | An integration of spreadsheet and project management software for cost optimal time scheduling in construction |
| title_full | An integration of spreadsheet and project management software for cost optimal time scheduling in construction |
| title_fullStr | An integration of spreadsheet and project management software for cost optimal time scheduling in construction |
| title_full_unstemmed | An integration of spreadsheet and project management software for cost optimal time scheduling in construction |
| title_short | An integration of spreadsheet and project management software for cost optimal time scheduling in construction |
| title_sort | integration of spreadsheet and project management software for cost optimal time scheduling in construction |
| topic | optimization project scheduling spreadsheet application project management software |
| url | https://doi.org/10.1515/otmcj-2016-0028 |
| work_keys_str_mv | AT valenkotadej anintegrationofspreadsheetandprojectmanagementsoftwareforcostoptimaltimeschedulinginconstruction AT klansekuros anintegrationofspreadsheetandprojectmanagementsoftwareforcostoptimaltimeschedulinginconstruction AT valenkotadej integrationofspreadsheetandprojectmanagementsoftwareforcostoptimaltimeschedulinginconstruction AT klansekuros integrationofspreadsheetandprojectmanagementsoftwareforcostoptimaltimeschedulinginconstruction |