Activity scheduling through gantt charts in an ms excel spreadsheet
Keywords:Gantt’s charts, project management, scheduling, spreadsheet program, directed graphs
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.
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
Copyright (c) 2018 Revista Facultad de Ingeniería
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Revista Facultad de Ingeniería, Universidad de Antioquia is licensed under the Creative Commons Attribution BY-NC-SA 4.0 license. https://creativecommons.org/licenses/by-nc-sa/4.0/deed.en
You are free to:
Share — copy and redistribute the material in any medium or format
Adapt — remix, transform, and build upon the material
Under the following terms:
Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
NonCommercial — You may not use the material for commercial purposes.
ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.
The material published in the journal can be distributed, copied and exhibited by third parties if the respective credits are given to the journal. No commercial benefit can be obtained and derivative works must be under the same license terms as the original work.