# 📋 Project Report Out Database

## What Is It?

The Project Report Out Database is the file where all Project Report Outs (PRO) are stored. It provides you a company level overview of the financial situation of all your projects based on their last received PRO.

## Key Concepts

<details id="bkmrk-lorem-ipsum-lorem-ip"><summary>Project Report Out</summary>

{{@47}}

</details>## Key Performance Indicators

<details id="bkmrk-labor---execution-ra"><summary>Labor - Execution Rate ⭐</summary>

{{@27}}

</details><details id="bkmrk-labor---execution-ef"><summary>Labor - Execution Efficiency ⭐</summary>

{{@28}}

</details><details id="bkmrk-expenses---accrued-m"><summary>Expenses - Accrued Margin</summary>

{{@21}}

</details><details id="bkmrk-expenses---margin-ac"><summary>Expenses - Margin Accrual Efficiency ⭐</summary>

{{@22}}

</details>## Using The Application

### Typical Workflow

1. You open the [PRO Database](#bkmrk-tab-1) tab and filter the list to [display only the last PRO](#bkmrk-show-last-pros-only). That gives an overview of the financials for all your projects.
2. You open the [Project Sheet](#bkmrk-tab-2) tab in order to dive deeper into a specific project and appreciate the trends of its KPIs.

### Structure &amp; Features

#### PRO Database

<p class="callout danger">This is a read-only (protected) tab. Do not modify it.</p>

This tab displays the main fields of a PRO. Some fields are hidden to make the table more readable. If you want to see the full details of a PRO use the menu [🐙 *Conduite &gt;* 📄 *View Full PRO*](#bkmrk-view-full-pro).

<table border="1" id="bkmrk-field-description-da" style="border-collapse: collapse; width: 100%; height: 386.705px;"><colgroup><col style="width: 50.0618%;"></col><col style="width: 50.0618%;"></col></colgroup><thead><tr style="height: 29.7869px;"><td style="height: 29.7869px;">Field</td><td style="height: 29.7869px;">Description</td></tr></thead><tbody><tr style="height: 35.2983px;"><td style="height: 35.2983px;">Date</td><td style="height: 35.2983px;">The date the PRO was sent and received.

</td></tr><tr style="height: 29.7017px;"><td style="height: 29.7017px;">Project Name</td><td style="height: 29.7017px;">The name of the project</td></tr><tr style="height: 29.7017px;"><td style="height: 29.7017px;">Status</td><td style="height: 29.7017px;">The status of the project at the time of the PRO.</td></tr><tr style="height: 35.2983px;"><td style="height: 35.2983px;">LB - %EX</td><td style="height: 35.2983px;">The [Execution Rate](https://help.conduite.app/books/glossary/page/labor-execution-rate "Labor - Execution Rate ⭐") of the project at the time of the PRO.</td></tr><tr style="height: 52.1023px;"><td style="height: 52.1023px;">LB - EE</td><td style="height: 52.1023px;">The [Execution Efficiency](https://help.conduite.app/books/glossary/page/labor-execution-efficiency "Labor - Execution Efficiency ⭐") of the project at the time of the PRO.</td></tr><tr style="height: 52.1023px;"><td style="height: 52.1023px;">EP - %AM</td><td style="height: 52.1023px;">The percentage of [Accrued Margin](https://help.conduite.app/books/glossary/page/expenses-accrued-margin "Expenses - Accrued Margin ($/%)") on expenses of the project at the time of the PRO.</td></tr><tr style="height: 46.5057px;"><td style="height: 46.5057px;">EP - MAE</td><td style="height: 46.5057px;">The Margin Accrual Efficiency on expenses of the project at the time of the PRO.</td></tr><tr style="height: 29.7017px;"><td style="height: 29.7017px;">Last PRO</td><td style="height: 29.7017px;">An "X" sign tags the last PRO of a project.</td></tr><tr style="height: 46.5057px;"><td style="height: 46.5057px;">PRO Age</td><td style="height: 46.5057px;">The age of the PRO in days. Ex: 21 means that the PRO was received 21 days ago.</td></tr></tbody></table>

#### Project Sheet

This tab allows you to deep dive into a project data over time. Use the *Project* dropdown to select the project of interest.

The tab is composed of several sections.

<table border="1" id="bkmrk-section-description-" style="border-collapse: collapse; width: 100%; height: 59.5938px;"><colgroup><col style="width: 50%;"></col><col style="width: 50%;"></col></colgroup><thead><tr style="height: 29.7969px;"><td style="height: 29.7969px;">Section</td><td style="height: 29.7969px;">Description</td></tr></thead><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">Last Project Report Out

</td><td style="height: 29.7969px;"> A table that displays the KPIs from the last PRO of a project.</td></tr><tr><td>Evolution of Project KPIs (Chart)

</td><td>A chart that show the evolution all project KPIs over time.

</td></tr><tr><td>All Project Report Outs

</td><td>A table that displays all PROs for a project ordered by ascending date. This is the source of the chart.</td></tr></tbody></table>

#### Configuration

<p class="callout danger">This is a hidden and read-only (protected tab). This tab should remain hidden. Do not modify it.</p>

This tab contains the ID of the Conduite configuration file and other computed configuration parameters.

### Conduite Menu

#### View Full PRO

This menu item opens a detailed view for a PRO in the sidebar. You need to be on the [PRO Database](#bkmrk-tab-1) tab to use this feature and to select any cell of an opportunity before triggering it. The sidebar will display the details for the selected PRO.

You can navigate to the previous and next opportunity by clicking the arrows located at the top of the sidebar.

#### Filter &gt; Show All PROs

This menu item shows all the PROs and orders them in descending order of date.

This view is useful if, on a specific occasion, you want to browse through all PROs.

#### Filter &gt; Show Last PROs Only

This menu item only shows the last PROs that were received for each project and orders them in descending order of date.

This is the most useful view for the day-to-day use of the PRO Database.

#### Help

This menu item opens the sidebar and loads this help page.