IGLC.net EXPORT DATE: 29 March 2024 @CONFERENCE{Ponz-Tienda2015, author={Ponz-Tienda, José L. and Pellicer, Eugenio and Alarcón3, Luis F. and Rojas-Quintero, Juan S. }, editor={Seppänen, Olli and González, Vicente A. and Arroyo, Paz }, title={Integrating Task Fragmentation and Earned Value Method Into the Last Planner System Using Spreadsheets}, journal={23rd Annual Conference of the International Group for Lean Construction}, booktitle={23rd Annual Conference of the International Group for Lean Construction}, year={2015}, pages={63-71}, url={http://www.iglc.net/papers/details/1200}, affiliation={Assistant Professor, Dep. of Civil and Environmental Engineering. Director of Construction Engineering and Management, Universidad de Los Andes, Bogotá, Colombia, (57-1) 3324312, jl.ponz@uniandes.edu.co ; Associate Professor, School of Civil Engineering, Universitat Politécnica de València, Valencia, Spain, (34) 963879562, pellicer@upv.es ; Professor, Dept. of Construction Engineering and Management, Universidad Católica de Chile, Escuela de Ingeniería, Santiago, Chile, (56-2) 2354 4201, lalarcon@ing.puc.cl ; Instructor, Department of Civil and Environmental Engineering. Universidad de Los Andes, Bogotá, Colombia, (57-1) 3324312, js.rojas128@uniandes.edu.co }, abstract={Construction schedulers make use of several tools as project management software of general purpose and spreadsheets for applying the Last Planner System of Production Control. This widespread practice has the disadvantage of working with questionable algorithms and models difficult to adapt to the construction industry, besides having to work with disconnected and complex information to manage data. In this paper a new layout and computation of multidimensional non-cyclic directed graphs based on its adjacency matrices is presented. All the precedence relationships are considered, in addition to the optimal and discretionary fragmentation of task in real conditions with work and feeding restrictions. This approach has been implemented with Visual Basic for Excel. A new approach for the representation and computation of projects for the Last Planner System of Production Control is presented. This approach is integrated with the management of the Earned Value and ad-hoc complex optimization. LPSTM, CPM, EVM and PPC are found to be complementary, and the Zaderenko´s algorithm modified and implemented in Excel can be used to integrate them. }, author_keywords={Lean construction, Last Planner System, Construction Scheduling with spreadsheets. }, address={Perth, Australia }, issn={2309-0979 }, publisher={ }, language={English}, document_type={Conference Paper}, source={IGLC}, }