Have a personal or library account? Click to login
An integration of spreadsheet and project management software for cost optimal time scheduling in construction
 Cover

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

By: Tadej Valenko and  Uroš Klanšek  
Open Access
|Dec 2017

Figures & Tables

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
DOI: https://doi.org/10.1515/otmcj-2016-0028 | Journal eISSN: 1847-6228 | Journal ISSN: 1847-5450
Language: English
Page range: 1627 - 1637
Submitted on: Nov 14, 2017
Accepted on: Nov 24, 2017
Published on: Dec 29, 2017
Published by: University of Zagreb
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year

© 2017 Tadej Valenko, Uroš Klanšek, published by University of Zagreb
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License.