Acceso abierto

An integration of spreadsheet and project management software for cost optimal time scheduling in construction

Tadej Valenko

Tadej Valenko

University of Maribor, Faculty of Civil Engineering, Transportation Engineering and ArchitectureMaribor, Slovenia
Buscar este autor en
Sciendo|Google Scholar
Valenko, Tadej
 y 
Uroš Klanšek

Uroš Klanšek

University of Maribor, Faculty of Civil Engineering, Transportation Engineering and ArchitectureMaribor, Slovenia
Buscar este autor en
Sciendo|Google Scholar
Klanšek, Uroš
  
29 dic 2017
An integration of spreadsheet and project management software for cost optimal time scheduling in construction's Cover Image
Acerca de este artículo
Artículo anterior
Artículo siguiente
Cite
Descargar portada
Categoría del artículo: Research Article
Publicado en línea: 29 dic 2017
Páginas: 1627 - 1637
Recibido: 14 nov 2017
Aceptado: 24 nov 2017
DOI: https://doi.org/10.1515/otmcj-2016-0028
Palabras clave
© 2017 Tadej Valenko et al., published by Sciendo
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License.

Fig. 1:

Project options.
Project options.

Fig. 2:

Import wizard.
Import wizard.

Fig. 3:

Usage steps of proposed integration of spreadsheet and PMS.
Usage steps of proposed integration of spreadsheet and PMS.

Fig. 4:

Input data in Microsoft Excel.
Input data in Microsoft Excel.

Fig. 5:

Array of activities.
Array of activities.

Fig. 6:

Changing cells.
Changing cells.

Fig. 7:

Settings in Solver.
Settings in Solver.

Fig. 8:

Output file.
Output file.

Fig. 9:

Optimal time schedule for example project.
Optimal time schedule for example project.

Fig. 10:

Updated optimal solution for example project.
Updated optimal solution for example project.

Figure 11:

Updated time schedule for example project.
Updated time schedule for example project.

Duration and direct costs of activities_

Activity IDDuration [weeks]Direct costDirect cost–duration function
Option 1Option 2Option 1Option 2
A12280000180000(380–100TA) × 103
B24420000320000(520–50TB) × 103
C710860000620000(1420–80TC) × 103
D46340000260000(500–40TD) × 103
E34570000410000(1050–160TE) × 103
F35260000180000(380–40TF) × 103
G471020000900000(1180–40TG) × 103
H69380000200000(740–60TH) × 103
I57270000210000(420–8300TL) × 103
J68490000430000(670–30TJ) × 103
K34200000160000(320–40TK) × 103
L35350000250000(500–50TL) × 103
M12200000100000(300–100TM) × 103
N36510000330000(690–60TN) × 103
Idioma:
Inglés
Calendario de la edición:
1 veces al año
Temas de la revista:
Ingeniería, Introducciones y reseñas, Ingeniería, otros
RSS Feed de revista