Finance_Percentage of working hours

Intro: This file sums the budgeted and actual hours for the projects, calculates the percentage of hours used, and shows write-ups and write-downs based on the project price.

In Kompass: Kompass offers an extensive analysis of project performance based on the worked hours with several filtering options. However, it does not offer them in a table format to compare among departments, managers and so on.

File Needed: The workbook can be exported directly from Kompass on the Projects page: open Actions, choose Reports, and select Percentage of working hours.xlsx.  

Updating method: If you update your data in Kompass, you will need to export the file again.

The File: There are two tabs on this spreadsheet, [Tables] 

and [Graphs].

Slicers can be used to limit the viewed information. They work exactly the same as the column filter buttons, but in a more user-friendly way. The [delivered] slicer is crucial and will filter between delivered and ongoing projects.

Further analysis: There are several ways of slicing and dicing the information. Whichever column can be found in the workbook can also be used for slicing.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us