Home » ProjectLibre Tutorial Part 5: Reports & Exporting to Excel

ProjectLibre Tutorial Part 5: Reports & Exporting to Excel

project-management.com content and product recommendations are editorially independent. We may make money when you click on links to our partners.

Featured Partners: Project Management Software

The last part of the tutorial is finally up. In this part of the tutorial, we are going to see the most important reports available for us and how to use the user interface for our favor. Most reports can be used often for checking the progress of your projects.

All tutorial parts:

Quick Reminder about resources

Since we are probably going to use data related to Gantt diagrams and resources. In order to remove a resource from a task, you cannot do it from the resource view. You must double click on the task, click on the resources tab, click on the icon for resources assignment and assign or remove resources as you wish.

screenshot-1-ProjectLibre-assign-resources-to-tasks

Ok, enough for the reviews for now. Let’s start with the reports. There are four reports available in ProjectLibre:

  • Project Details
  • Resource Information
  • Task Information
  • Who Does What

Each of the reports, except “Project Details ” have various versions available:

Resource Information

  • Default
  • Earned Value
  • Earned Value Cost
  • Earned Value Schedule
  • Name

Task Information

  • Baseline
  • Constraint Dates
  • Cost
  • Default
  • Earned Value
  • Earned Value Cost
  • Earned Value Schedule
  • Name
  • Schedule
  • Schedule (CPM)
  • Schedule Variance
  • Summary
  • Tracking
  • Work

Who Does What

  • Assigned Resources
  • Basic Report
  • Name and Id
  • Resource Usage
  • Tasks Assigned

The reports that are highlighted are the ones that we are going to describe later.

Project details report

The project details report, displays the following information:
Dates: Start, Finish, Actual Start and Actual Finish
Duration: Scheduled, Remaining, Actual and Percent Complete
Work: Scheduled, Remaining and Actual
Costs: Scheduled, Remaining, Actual and Variance
Along with notes.

In order to view the report click on View, then ‘Report’ and then Report: Project Details’

screenshot-2-ProjectLibre-view-report

Some notes about ProjectLibre reports

While the functions of the reports are limited, and at some reports, some filtering and sorting options might not work. You can always click on the little disk icon and export the report at an Excel file and do whatever you like with that. Also, you can zoom in, zoom out and move pages with the toolbar options.

screenshot-3-ProjectLibre-report-toolbar

Resource Information  – Default

The Resource Information – Default report displays in a simple list all your resources with the following columns:
Name, RBS, Type, E-mail Address, Material Label

screenshot-4-ProjectLibre-Resource-Information-Default

Resource Information—Earned Value

The Resource Information—Earned Value report, displays your resources along with various columns related to Earned Value (BCWS, BCWP, ACWP, CV, SV, EAC…)

Task Information

Constraint Dates

The Task Information — Constraint Dates report is very useful to check all the constraint dates at once as a checklist. You can use this report as a checklist regularly to check that everything is going according to plan.

screenshot-5-ProjectLibre-Task-Information-Constraint-Dates

Task Information — Cost

The Task Information — Cost report might be one of your favorites. At this report, you can have a quick glance at every task cost, actual cost and remaining cost. It might be a useful report to export at Excel for extra filtering.

screenshot-6-ProjectLibre-Task-Information-Cost

Task Information — Default

The Task Information — Default report displays all the tasks, along with the duration, start, finish, predecessors and resource names. Because of the format of this report, you can export it at Excel or CSV and import it maybe at your own company’s software.

screenshot-7-ProjectLibre-Task-Information-Default

Task Information — Earned Value

Similar to Resource Information—Earned Value report, with this report, you can check the Earned Value per task.

Task Information—Tracking

Very useful report, displaying all the tasks, along with the actual start, actual finish and percent complete. You can also filter the tasks to view Completed, Cost overbudget tasks, Critical tasks, In-progress tasks, Incomplete tasks, Late/overbudget tasks and Normal tasks.

screenshot-9-ProjectLibre-Task-Information-Tracking

Who Does What— Tasks Assigned

The Who Does What—Tasks Assigned report, is a checklist for your resources (either work or material) to check where they are allocated and how are they doing. You can also filter your resources by Material Resources, Work Resources, In-progress Assignments, Unstarted Assignments, Work Complete.

screenshot-10-ProjectLibre-Who-Does-What

Epilogue

That was it for the ProjectLibre tutorial. I hope that you have found all 5 five parts useful for your training. You can also check YouTube videos by various people describing various ProjectLibre functionalities.

If you have found a resource (manual and/or guide) you can add it as a comment below for other users to see it.

All tutorial parts:

Featured Partners: Project Management Software

Wrike

Visit website

Wrike is the most powerful work management platform on the market, enabling teams to plan projects and collaborate in real time. Our award-winning software is trusted by 20,000+ companies across the globe, including Sony, Estée Lauder, and Siemens.

Wrike’s customizable features include Gantt charts, request forms, dashboards, cross-tagging, time tracking, and proofing. Integrate with 400+ apps from the likes of Microsoft, Google, and Salesforce. Automate repetitive tasks and achieve 50% faster planning. Work from anywhere with 100% access to your files via our mobile and desktop apps.

Whether you’re a small startup or an established brand, Wrike has the solution for you. Paid plans start at $9.80/user/month. Join our community of 2.3 million — start your free two-week trial today.

Learn more about Wrike

monday.com

Visit website

monday.com Work OS is an award-winning no-code work management platform that helps teams manage projects and workflows more efficiently.

Used by 152,000+ customers worldwide, this fully customizable software lets you plan, manage, and track every project in one place. monday.com offers time-saving and easy-to-use features such as automations, time tracking, document sharing, and real-time collaboration. Multiple board views such as Gantt and Kanban help you structure and navigate tasks and projects the way you prefer, and dashboards give a high-level overview of your progress.

In addition, integrations with apps such as Outlook, Microsoft Teams, Gmail, and Excel, allow you to easily continue working with your favorite tools from within the platform. monday.com also offers dedicated solutions, such as monday dev and monday sales CRM, designed to answer the needs of specific industries.

Learn more about monday.com

Smartsheet

Visit website

Smartsheet is a leading work execution platform that has real-time work management features, collaboration and automation tools. Users are presented with a familiar and easy-to-use spreadsheet-like interface. However, it has enterprise-grade capabilities that even Fortune 500 companies like Cisco, Bayer, HP, and PayPal are confident to adopt in their business. Strong project management features enable teams to utilize different views of real-time data, and switch easily from Gantt, card, grid and calendar views. Smartsheet has automatic update requests, and can be used for waterfall and agile projects, product launch, sprint planning, and more. The resource management feature provides users the visibility who is busy, and who is not, in real-time. They can also attach files, share sheets, get notified, view the activity log, export, email, and print.

Learn more about Smartsheet

Share Article


Project-Management.com Avatar

Get the Free Newsletter!

Subscribe to Project Management Insider for best practices, reviews and resources.

Featured Partners


Check out our library of 60+ pm books