SciELO - Scientific Electronic Library Online

 
 issue61Description of execution time dynamics for a set of concurrent real-time tasksUnknown objects drawing using image retrieval author indexsubject indexarticles search
Home Pagealphabetic serial listing  

Services on Demand

Article

Indicators

Related links

  • On index processCited by Google
  • Have no similar articlesSimilars in SciELO
  • On index processSimilars in Google

Share


Revista Facultad de Ingeniería Universidad de Antioquia

Print version ISSN 0120-6230

Abstract

CABALLERO VILLALOBOS, Juan P; JARRO SANABRIA, Sandra P  and  GARCIA CACERES, Rafael G. Activity scheduling through gantt charts in an ms excel spreadsheet. Rev.fac.ing.univ. Antioquia [online]. 2011, n.61, pp.132-145. ISSN 0120-6230.

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.

Keywords : Directed graphs; Gantt's charts; project management; scheduling; spreadsheet program.

        · abstract in Spanish     · text in English     · English ( pdf )

 

Creative Commons License All the contents of this journal, except where otherwise noted, is licensed under a Creative Commons Attribution License