Original scientific paper

A spreadsheet application for the planning and tracking of project labor hours and expenditures

Robert Logožar orcid.org/0000-0003-3303-2271 ; Veleučilište u Varaždinu, Varaždin, Hrvatska
Ladislav Havaš orcid.org/0000-0002-5051-4486 ; Veleučilište u Varaždinu, Varaždin, Hrvatska

Abstract

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 interna-tional 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-for¬matting 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.

Keywords

project planning; project tracking; spreadsheet application; selectable data form entry cells

Hrčak ID:

85794

URI

https://hrcak.srce.hr/85794

Publication date:

1.7.2011.

Visits: 1.791 *