Activity scheduling through gantt charts in an ms excel spreadsheet


  • Juan P. Caballero-Villalobos Pontificia Universidad Javeriana
  • Sandra P. Jarro-Sanabria Pontificia Universidad Javeriana
  • Rafael G. García-Cáceres Escuela Colombiana de Ingenieria


Directed graphs, Gantt’s charts, project management, scheduling, spreadsheet program


Effective communication of task-resource assignment plans comprises several challenges in important fields such as production scheduling and/or project management. Said difficulties result from the cost and sophistication level of most project planning information tools, and from the pedagogic challenge implied in getting people with different educational levels to communicate through such tools. The present work introduces the implementation grounds of a simple information technology development for the construction of Gantt charts as decision making support tools for people or companies that have limited access to sophisticated information technology tools. The implementation and execution of the Visual Basic code with Excel applications are described in detail, as well as the correct use of the Excel solver add-in from VBA macros to solve the implemented mathematical models.

= 34 veces | PDF (ESPAÑOL (ESPAÑA))
= 20 veces|


Download data is not yet available.


J. Wilson. “Gantt Charts: A Centenary Appreciation”. European Journal of Operational Research. Vol. 149. 2003. pp. 430-437.

W. Clark. The Gantt Chart. Ed. The Ronald Press Co. New York (USA). 1925. pp. 84.

J. Herrmann. Handbook of Production Scheduling. International Series In Operation Research & Management. Science. Ed. Springer US. Maryland. 2006. pp. 5-7, 15-16.

H. Gantt. “A graphical daily balance in manufacture”. ASME Transactions. Vol. 24. 1903. pp. 1322–1336.

F. Taylor. “Shop Management”. ASME Transactions. Vol. 24. 1903. pp. 1337-1480.

W. Truscott, D. Cho. “Scheduling batch production with character graphics”. Industrial Engineering. Vol. 19. No. 2. 1987. pp. 17-22.

M. Wennink, M. Salvelsbergh. “Towards a planning board generator”. Decision Support Systems. Vol. 17. No. 3. 1996. pp. 199-226.

PM Network. “Project Management Software Survey”. PM Network. Vol.

1995. pp. 35-48. 9. J. Seyed. “Right on Schedule”. OR/MS Today. December. 1995. pp. 42-44.

B. Yen, M. Pinedo. On design and development of scheduling systems. Proceedings of the Fourth International Conference on Computer Integrated Manufacturing and Automation Technology. October. 1994. pp. 197-204.

C. Ortiz. “Implementation issues: a recipe for scheduling success”. IIE Solutions. March. 1996. pp. 29-32.

R. Ahuja, T. Magnanti, J. Orlin. Network Flows. Ed. Prentice Hall. New Jersey. 1993. pp. 193-154, 802-816.

M. Pinedo, X. Chao. Operations scheduling with applications in manufacturing and services. Ed. Mc Graw-Hill. New York. 1999. pp. 2.

ANSI. A Guide to the Project Management Body of Knowledge (PMBOK® Guide) – 2000. Ed. Project Management Institute. Pennsylvania. 2000. pp. 4-7.

E. Balas. “Disjunctive Programming, Discrete Optimization II”. P.L. Hammer, E.L. Johnson, B.H. Korte. (editors). Annals of Discrete Mathematics. Ed. Elsevier. New York (USA). Vol.5. 1979. pp. 3-51.

M. Pinedo. Scheduling: Theory, Algorithms, and Systems. Ed. Prentice-Hall. Englewood Cliffs, NJ. 1995. pp. 196, 197, 269-276.

J. Blazewicz, D. Kobler. “Review of properties of different precedence graphs for scheduling problems”. European Journal of Operational Research. Vol. 142. 2002. pp. 435-443.

F. Hillier, G. Lieberman. Introducción a la investigación de operaciones. Ed. McGraw-Hill Book Company, Inc. México. 1997. pp. 389-395.



How to Cite

Caballero-Villalobos, J. P., Jarro-Sanabria, S. P., & García-Cáceres, R. G. (2012). Activity scheduling through gantt charts in an ms excel spreadsheet. Revista Facultad De Ingeniería Universidad De Antioquia, (61), 132–145. Retrieved from