Activity scheduling through gantt charts in an ms excel spreadsheet
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 chal...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Universidad de Antioquia
2012-11-01
|
| Series: | Revista Facultad de Ingeniería Universidad de Antioquia |
| Subjects: | |
| Online Access: | https://revistas.udea.edu.co/index.php/ingenieria/article/view/13545 |
| _version_ | 1797861657677922304 |
|---|---|
| author | Juan P. Caballero Villalobos Sandra P. Jarro Sanabria Rafael G. García Cáceres |
| author_facet | Juan P. Caballero Villalobos Sandra P. Jarro Sanabria Rafael G. García Cáceres |
| author_sort | Juan P. Caballero Villalobos |
| collection | DOAJ |
| description |
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.
|
| first_indexed | 2024-04-09T22:06:45Z |
| format | Article |
| id | doaj.art-f6c4e6a09c814bea82fb6548fcc6cd1d |
| institution | Directory Open Access Journal |
| issn | 0120-6230 2422-2844 |
| language | English |
| last_indexed | 2024-04-09T22:06:45Z |
| publishDate | 2012-11-01 |
| publisher | Universidad de Antioquia |
| record_format | Article |
| series | Revista Facultad de Ingeniería Universidad de Antioquia |
| spelling | doaj.art-f6c4e6a09c814bea82fb6548fcc6cd1d2023-03-23T12:37:13ZengUniversidad de AntioquiaRevista Facultad de Ingeniería Universidad de Antioquia0120-62302422-28442012-11-016110.17533/udea.redin.13545Activity scheduling through gantt charts in an ms excel spreadsheetJuan P. Caballero Villalobos0Sandra P. Jarro Sanabria1Rafael G. García Cáceres2Pontifical Xavierian UniversityPontifical Xavierian UniversityColombian School of Engineering 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. https://revistas.udea.edu.co/index.php/ingenieria/article/view/13545Gantt’s chartsproject managementschedulingspreadsheet programdirected graphs |
| spellingShingle | Juan P. Caballero Villalobos Sandra P. Jarro Sanabria Rafael G. García Cáceres Activity scheduling through gantt charts in an ms excel spreadsheet Revista Facultad de Ingeniería Universidad de Antioquia Gantt’s charts project management scheduling spreadsheet program directed graphs |
| title | Activity scheduling through gantt charts in an ms excel spreadsheet |
| title_full | Activity scheduling through gantt charts in an ms excel spreadsheet |
| title_fullStr | Activity scheduling through gantt charts in an ms excel spreadsheet |
| title_full_unstemmed | Activity scheduling through gantt charts in an ms excel spreadsheet |
| title_short | Activity scheduling through gantt charts in an ms excel spreadsheet |
| title_sort | activity scheduling through gantt charts in an ms excel spreadsheet |
| topic | Gantt’s charts project management scheduling spreadsheet program directed graphs |
| url | https://revistas.udea.edu.co/index.php/ingenieria/article/view/13545 |
| work_keys_str_mv | AT juanpcaballerovillalobos activityschedulingthroughganttchartsinanmsexcelspreadsheet AT sandrapjarrosanabria activityschedulingthroughganttchartsinanmsexcelspreadsheet AT rafaelggarciacaceres activityschedulingthroughganttchartsinanmsexcelspreadsheet |