Have a personal or library account? Click to login
An integration of spreadsheet and project management software for cost optimal time scheduling in construction Cover

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

Organization, Technology and Management in Construction: an International Journal
Volume 9 (2017): Issue 1 (January 2017)
By: Tadej Valenko and  Uroš Klanšek  
Open Access
|Dec 2017

References

  1. Adeli, H., & Karim, A. (1997). Scheduling/cost optimization and neural dynamics model for construction. Journal of Construction Engineering and Management, 123(4), pp. 450–458. doi: 10.1061/(ASCE)0733-9364(1997)123:4(450).
    Open DOISearch in Google ScholarBack to article
  2. Al Haj, R., & El-Sayegh, S. (2015). Time-cost optimization model considering float-consumption Impact. Journal of Construction Engineering and Management, 141(5), 04015001. doi: 10.1061/(ASCE)CO.1943-7862.0000966.
    Open DOISearch in Google ScholarBack to article
  3. Biafore, B. (2013). Microsoft Project 2013: The Missing Manual. O’Reilly Media, Sebastopol, CA.
    Search in Google ScholarBack to article
  4. Crnković, D., & Vukomanović, M. (2016). Comparison of trends in risk management theory and practices within the construction industry. E-GFOS, 7(13), pp. 1–11. doi: 10.13167/2016.13.1.
    Open DOISearch in Google ScholarBack to article
  5. Eshtehardian, E., Afshar, A., & Abbasnia, R. (2009). Fuzzy-based MOGA approach to stochastic time-cost trade-off problem. Automation in Construction, 18(5), pp. 692–701. doi: 10.1016/j.autcon.2009.02.001.
    Open DOISearch in Google ScholarBack to article
  6. Ezeldin, A. S., & Soliman, A. (2009). Hybrid time-cost optimization of nonserial repetitive construction projects. Journal of Construction Engineering and Management, 135(1), pp. 42–55. doi: 10.1061/(ASCE)0733-9364(2009)135:1(42).
    Open DOISearch in Google ScholarBack to article
  7. Frontline Systems. (2017). Frontline Solvers Optimization and Simulation User Guide. Available at https://www.solver.com/user-guides-frontline-systems-excel-solvers/on 07 November, 2017).
    Search in Google ScholarBack to article
  8. Galić, M., Završki, I., & Dolaček-Alduk, Z. (2016a). Scenario simulation model for optimized allocation of construction machinery. Građevinar, 68(2), pp. 105–112. doi: 10.14256/JCE.1462.2015.
    Open DOISearch in Google ScholarBack to article
  9. Galić, M., Završki, I., & Dolaček-Alduk, Z. (2016b). Methodology and algorithm for asphalt supply chain optimization. Tehnicki Vjesnik-Technical Gazette, 23(4), pp. 1193–1200. doi: 10.17559/TV-20150623140015.
    Open DOISearch in Google ScholarBack to article
  10. Galić, M., Barišić, I., & Ištoka Otković, I. (2017). Route reliability based simulation model for HMA delivery in urban areas. Procedia Engineering, 187, pp. 378–386. doi: 10.1016/j.proeng.2017.04.389.
    Open DOISearch in Google ScholarBack to article
  11. Geem, Z. W. (2010). Multiobjective optimization of time-cost trade-off using harmony search. Journal of Construction Engineering and Management, 136(6), pp. 711–716. doi: 10.1061/(ASCE)CO.1943-7862.0000167.
    Open DOISearch in Google ScholarBack to article
  12. Harris, P. E. (2016). Planning and Control Using Microsoft Project 2013 and 2016. Eastwood Harris Pty Ltd, Doncaster Heights, VIC.
    Search in Google ScholarBack to article
  13. Hazir, Ö., Haouari, M., & Erel, E. (2010). Robust scheduling and robustness measures for the discrete time/cost trade-off problem. European Journal of Operational Research, 207(2), pp. 633–643. doi: 10.1016/j.ejor.2010.05.046.
    Open DOISearch in Google ScholarBack to article
  14. Hazir, Ö., Erel, E., & Günalay, Y. (2011). Robust optimization models for the discrete time/cost trade-off problem. International Journal of Production Economics, 130(1), pp. 87–95. doi: 10.1016/j.ijpe.2010.11.018.
    Open DOISearch in Google ScholarBack to article
  15. He, Z., Wang, N., Jia, T., & Xu, Y. (2009). Simulated annealing and tabu search for multi-mode project payment scheduling. European Journal of Operational Research, 198(3), pp. 688–696. doi: 10.1016/j.ejor.2008.10.005.
    Open DOISearch in Google ScholarBack to article
  16. Hillier, F. S., & Lieberman, G. J. (2014). Introduction to Operations Research, 10th edn. McGraw-Hill Higher Education, New York, NY.
    Search in Google ScholarBack to article
  17. Kalhor, E., Khanzadi, M., Eshtehardian, E., & Afshar, A. (2011). Stochastic time-cost optimization using non-dominated archiving ant colony approach. Automation in Construction, 20(8), pp. 1193–1203. doi: 10.1016/j.autcon.2011.05.003.
    Open DOISearch in Google ScholarBack to article
  18. Kažović, D., & Valenčić, D. (2013, May). Using Microsoft Project for project management in non-governmental organisations. In: Information & Communication Technology Electronics & Microelectronics (MIPRO), 2013 36th International Convention on 20–24 May 2013, Opatija, Croatia. IEEE, pp. 681–684.
    Search in Google ScholarBack to article
  19. Klanšek, U. (2016). Mixed-Integer nonlinear programming model for nonlinear discrete optimization of project schedules under restricted costs. Journal of Construction Engineering and Management, 142(3), 04015088. doi: 10.1061/(ASCE)CO.1943-7862.0001074.
    Open DOISearch in Google ScholarBack to article
  20. Kostalova, J., & Tetrevova, L. (2014). Project management and its tools in practice in the Czech Republic. Procedia-Social and Behavioral Sciences, 150, pp. 678–689. doi: 10.1016/j.sbspro.2014.09.087.
    Open DOISearch in Google ScholarBack to article
  21. Marmel, E. (2013), Project 2010 Bible. John Wiley & Sons, Indianapolis, IN.
    Search in Google ScholarBack to article
  22. Mokhtari, H., Aghaie, A., Rahimi, J., & Mozdgir, A. (2010). Project time-cost trade-off scheduling: A hybrid optimization approach. International Journal of Advanced Manufacturing Technology, 50, 5–8(2010), pp. 811–822. doi: 10.1007/s00170-010-2543-4.
    Open DOISearch in Google ScholarBack to article
  23. Nearchou, A. C. (2010). Scheduling with controllable processing times and compression costs using population-based heuristics. International Journal of Production Research, 48(23), pp. 7043–7062. doi: 10.1080/00207540903433874.
    Open DOISearch in Google ScholarBack to article
  24. Petlíková, K., & Jarský, Č. (2017). Modeling of the time structure of construction processes using neural networks. Organization, Technology and Management in Construction: An International Journal, 9(1), pp. 1559–1564. doi: 10.1515/otmcj-2016-0018.
    Open DOISearch in Google ScholarBack to article
  25. Sakellaropoulos, S., & Chassiakos, A. P. (2004). Project time-cost analysis under generalised precedence relations. Advances in Engineering Software, 35(10–11), pp. 715–724. doi: 10.1016/j.advengsoft.2004.03.017.
    Open DOISearch in Google ScholarBack to article
  26. Silva Filho, O. S., Cezarino, W., & Ratto, J. (2010). Aggregate production planning: Modeling and solution via Excel spreadsheet and solver. IFAC Proceedings Volumes, 43(17), pp. 89–94. doi: 10.3182/20100908-3-PT-3007.00020.
    Open DOISearch in Google ScholarBack to article
  27. Sonmez, R., & Bettemir, Ö. H. (2012). A hybrid genetic algorithm for the discrete time-cost trade-off problem. Expert Systems with Applications. 39(13), pp. 11428–11434. doi: 10.1016/j.eswa.2012.04.019.
    Open DOISearch in Google ScholarBack to article
  28. Trautmann, N., & Gnägi, M. (2015, December). On an application of Microsoft Excel’s evolutionary solver to the resource-constrained project scheduling problem RCPSP. In: Industrial Engineering and Engineering Management (IEEM), 2015 IEEE International Conference on 6–9 Dec. 2015, Singapore. IEEE, pp. 646–650. doi: 10.1109/IEEM.2015.7385727.
    Open DOISearch in Google ScholarBack to article
  29. Valenko, T., & Klanšek, U. (2017, September). Cost optimal time scheduling integrating spreadsheet and project management software. In: 13th International Conference Organization, Technology and Management in Construction, 2017. Croatian Association for Construction Management: University of Zagreb, Faculty of Civil Engineering, pp. 42–53.
    Search in Google ScholarBack to article
  30. Vanhoucke, M. (2005). New computational results for the discrete time/cost trade-off problem with time-switch constraints. European Journal of Operational Research, 165(2), pp. 359–374. doi: 10.1016/j.ejor.2004.04.007.
    Open DOISearch in Google ScholarBack to article
  31. Von Laszewski, G., & Dilmanian, L. E. (2008, November). e-Science project and experiment management with Microsoft Project. In: Grid Computing Environments Workshop, 2008. GCE’08. IEEE, pp. 1–8. doi: 10.1109/GCE.2008.4738449.
    Open DOISearch in Google ScholarBack to article
  32. Yang, I.-T. (2007). Using elitist particle swarm optimization to facilitate bicriterion time-cost trade-off analysis. Journal of Construction Engineering and Management, 133(7), pp. 498–505. doi: 10.1061/(ASCE)0733-9364(2007)133:7(498).
    Open DOISearch in Google ScholarBack to article
DOI: https://doi.org/10.1515/otmcj-2016-0028 | Journal eISSN: 1847-6228 | Journal ISSN: 1847-5450
Journal RSS Feed
Language: English
Page range: 1627 - 1637
Submitted on: Nov 14, 2017
Accepted on: Nov 24, 2017
Published on: Dec 29, 2017
Published by: University of Zagreb
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year
Keywords:
optimization,
project scheduling,
spreadsheet application,
project management software
Related subjects:
Engineering,
Introductions and overviews,
Engineering, other

© 2017 Tadej Valenko, Uroš Klanšek, published by University of Zagreb
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License.

Previous articleVolume 9 (2017): Issue 1 (January 2017)Next article