Integrating task fragmentation and earned value method into the last planner system using spreadsheets

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 Zaderenkós algorithm modified and implemented in Excel can be used to integrate them.