Open Access

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


Cite

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).AdeliH.KarimA.1997Scheduling/cost optimization and neural dynamics model for constructionJournal of Construction Engineering and Management123445045810.1061/(ASCE)0733-9364(1997)123:4(450)Open DOISearch in Google Scholar

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.Al HajR.El-SayeghS.2015Time-cost optimization model considering float-consumption ImpactJournal of Construction Engineering and Management14150401500110.1061/(ASCE)CO.1943-7862.0000966Open DOISearch in Google Scholar

Biafore, B. (2013). Microsoft Project 2013: The Missing Manual. O’Reilly Media, Sebastopol, CA.BiaforeB.2013Microsoft Project 2013: The Missing ManualO’Reilly MediaSebastopol, CASearch in Google Scholar

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.CrnkovićD.VukomanovićM.2016Comparison of trends in risk management theory and practices within the construction industryE-GFOS71311110.13167/2016.13.1Open DOISearch in Google Scholar

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.EshtehardianE.AfsharA.AbbasniaR.2009Fuzzy-based MOGA approach to stochastic time-cost trade-off problemAutomation in Construction18569270110.1016/j.autcon.2009.02.001Open DOISearch in Google Scholar

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).EzeldinA. S.SolimanA.2009Hybrid time-cost optimization of nonserial repetitive construction projectsJournal of Construction Engineering and Management1351425510.1061/(ASCE)0733-9364(2009)135:1(42)Open DOISearch in Google Scholar

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).Frontline Systems2017Frontline Solvers Optimization and Simulation User GuideAvailable at https://www.solver.com/user-guides-frontline-systems-excel-solvers/on 07 November, 2017).Search in Google Scholar

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.GalićM.ZavrškiI.Dolaček-AldukZ.2016aScenario simulation model for optimized allocation of construction machineryGrađevinar68210511210.14256/JCE.1462.2015Open DOISearch in Google Scholar

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.GalićM.ZavrškiI.Dolaček-AldukZ.2016bMethodology and algorithm for asphalt supply chain optimizationTehnicki Vjesnik-Technical Gazette2341193120010.17559/TV-20150623140015Open DOISearch in Google Scholar

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.GalićM.BarišićI.Ištoka OtkovićI.2017Route reliability based simulation model for HMA delivery in urban areasProcedia Engineering18737838610.1016/j.proeng.2017.04.389Open DOISearch in Google Scholar

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.GeemZ. W.2010Multiobjective optimization of time-cost trade-off using harmony searchJournal of Construction Engineering and Management136671171610.1061/(ASCE)CO.1943-7862.0000167Open DOISearch in Google Scholar

Harris, P. E. (2016). Planning and Control Using Microsoft Project 2013 and 2016. Eastwood Harris Pty Ltd, Doncaster Heights, VIC.HarrisP. E.2016Planning and Control Using Microsoft Project 2013 and 2016Eastwood Harris Pty LtdDoncaster Heights, VICSearch in Google Scholar

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.HazirÖ.HaouariM.ErelE.2010Robust scheduling and robustness measures for the discrete time/cost trade-off problemEuropean Journal of Operational Research207263364310.1016/j.ejor.2010.05.046Open DOISearch in Google Scholar

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.HazirÖ.ErelE.GünalayY.2011Robust optimization models for the discrete time/cost trade-off problemInternational Journal of Production Economics1301879510.1016/j.ijpe.2010.11.018Open DOISearch in Google Scholar

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.HeZ.WangN.JiaT.XuY.2009Simulated annealing and tabu search for multi-mode project payment schedulingEuropean Journal of Operational Research198368869610.1016/j.ejor.2008.10.005Open DOISearch in Google Scholar

Hillier, F. S., & Lieberman, G. J. (2014). Introduction to Operations Research, 10th edn. McGraw-Hill Higher Education, New York, NY.HillierF. S.LiebermanG. J.2014Introduction to Operations Research10th ednMcGraw-Hill Higher EducationNew York, NYSearch in Google Scholar

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.KalhorE.KhanzadiM.EshtehardianE.AfsharA.2011Stochastic time-cost optimization using non-dominated archiving ant colony approachAutomation in Construction2081193120310.1016/j.autcon.2011.05.003Open DOISearch in Google Scholar

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.KažovićD.ValenčićD.2013MayUsing Microsoft Project for project management in non-governmental organisationsIn:Information & Communication Technology Electronics & Microelectronics (MIPRO), 2013 36th International Convention20–24 May 2013Opatija, CroatiaIEEE681684Search in Google Scholar

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.KlanšekU.2016Mixed-Integer nonlinear programming model for nonlinear discrete optimization of project schedules under restricted costsJournal of Construction Engineering and Management14230401508810.1061/(ASCE)CO.1943-7862.0001074Open DOISearch in Google Scholar

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.KostalovaJ.TetrevovaL.2014Project management and its tools in practice in the Czech RepublicProcedia-Social and Behavioral Sciences15067868910.1016/j.sbspro.2014.09.087Open DOISearch in Google Scholar

Marmel, E. (2013), Project 2010 Bible. John Wiley & Sons, Indianapolis, IN.MarmelE.2013Project 2010 BibleJohn Wiley & SonsIndianapolis, INSearch in Google Scholar

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.MokhtariH.AghaieA.RahimiJ.MozdgirA.2010Project time-cost trade-off scheduling: A hybrid optimization approachInternational Journal of Advanced Manufacturing Technology505–8(2010)81182210.1007/s00170-010-2543-4Open DOISearch in Google Scholar

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.NearchouA. C.2010Scheduling with controllable processing times and compression costs using population-based heuristicsInternational Journal of Production Research48237043706210.1080/00207540903433874Open DOISearch in Google Scholar

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.PetlíkováK.JarskýČ2017Modeling of the time structure of construction processes using neural networksOrganization, Technology and Management in Construction: An International Journal911559156410.1515/otmcj-2016-0018Open DOISearch in Google Scholar

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.SakellaropoulosS.ChassiakosA. P.2004Project time-cost analysis under generalised precedence relationsAdvances in Engineering Software3510–1171572410.1016/j.advengsoft.2004.03.017Open DOISearch in Google Scholar

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.Silva FilhoO. S.CezarinoW.RattoJ.2010Aggregate production planning: Modeling and solution via Excel spreadsheet and solverIFAC Proceedings Volumes4317899410.3182/20100908-3-PT-3007.00020Open DOISearch in Google Scholar

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.SonmezR.BettemirÖ. H.2012A hybrid genetic algorithm for the discrete time-cost trade-off problemExpert Systems with Applications3913114281143410.1016/j.eswa.2012.04.019Open DOISearch in Google Scholar

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.TrautmannN.GnägiM.2015DecemberOn an application of Microsoft Excel’s evolutionary solver to the resource-constrained project scheduling problem RCPSPIn:Industrial Engineering and Engineering Management (IEEM), 2015 IEEE International Conference6–9 Dec. 2015SingaporeIEEE64665010.1109/IEEM.2015.7385727Open DOISearch in Google Scholar

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.ValenkoT.KlanšekU.2017SeptemberCost optimal time scheduling integrating spreadsheet and project management softwareIn:13th International Conference Organization, Technology and Management in Construction, 2017Croatian Association for Construction Management: University of Zagreb, Faculty of Civil Engineering4253Search in Google Scholar

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.VanhouckeM.2005New computational results for the discrete time/cost trade-off problem with time-switch constraintsEuropean Journal of Operational Research165235937410.1016/j.ejor.2004.04.007Open DOISearch in Google Scholar

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.Von LaszewskiG.DilmanianL. E.2008Novembere-Science project and experiment management with Microsoft ProjectInGrid Computing Environments Workshop, 2008. GCE’08IEEE1810.1109/GCE.2008.4738449Open DOISearch in Google Scholar

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).YangI.-T.2007Using elitist particle swarm optimization to facilitate bicriterion time-cost trade-off analysisJournal of Construction Engineering and Management133749850510.1061/(ASCE)0733-9364(2007)133:7(498)Open DOISearch in Google Scholar

eISSN:
1847-6228
Language:
English
Publication timeframe:
Volume Open
Journal Subjects:
Engineering, Introductions and Overviews, other