TY - CONF TI - Integrating Task Fragmentation and Earned Value Method Into the Last Planner System Using Spreadsheets C1 - Perth, Australia C3 - 23rd Annual Conference of the International Group for Lean Construction SP - 63 EP - 71 PY - 2015 AU - Ponz-Tienda, José L. AU - Pellicer, Eugenio AU - Alarcón3, Luis F. AU - Rojas-Quintero, Juan S. AD - 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 AD - Associate Professor, School of Civil Engineering, Universitat Politécnica de València, Valencia, Spain, (34) 963879562, pellicer@upv.es AD - 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 AD - Instructor, Department of Civil and Environmental Engineering. Universidad de Los Andes, Bogotá, Colombia, (57-1) 3324312, js.rojas128@uniandes.edu.co ED - Seppänen, Olli ED - González, Vicente A. ED - Arroyo, Paz AB - 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. KW - Lean construction KW - Last Planner System KW - Construction Scheduling with spreadsheets. PB - T2 - 23rd Annual Conference of the International Group for Lean Construction DA - 2015/07/29 CY - Perth, Australia L1 - http://iglc.net/Papers/Details/1200/pdf L2 - http://iglc.net/Papers/Details/1200 N1 - Export Date: 28 March 2024 DB - IGLC.net DP - IGLC LA - English ER -