Naslov
A Spreadsheet Application for the Planning and Tracking of Project Labor Hours and Expenditures

Autori
Logožar, Robert ; Havaš, Ladislav

Izvornik
Tehnički glasnik (1846-6168) 5 (2011), 1; 22-29

Vrsta, podvrsta i kategorija rada
Radovi u časopisima, članak, znanstveni

Ključne riječi
project planning; project tracking; spreadsheet application; selectable data form entry cells

Sažetak
The paper briefly outlines a comprehensive spreadsheet application for the planning and tracking of project labor hours and costs, including the material and outsourcing expenditures. Some specifics of the use of table-calculators for this sort of problems are depicted. The application is aimed for the projects in the international business environment, with many variable parameters. It consists of the versatile and easily expandable tables with selectable data form entry cells (e.g. the cost price can be entered in a selected currency). Where applied, this sort of input leads to the explicit separation of the entry cells from the calculation (presentation) cells, and improves the overall consistency of the tables. The spreadsheets give a wide range of project information, from the subtle details up to the general and summarizing facts. The conditional color-formatting of the cells is consistently used for better visualization of the data. The application is designed to serve a manager in planning, running, supervising and concluding the project.

Izvorni jezik
Engleski

Znanstvena područja
Računarstvo

POVEZANOST RADA