Table settings columns

EMDESK provides four main data table views: Workplan, Participants, Budget, and Expenses. Each table offers a rich set of columns that you can show, hide, and reorder to suit your workflow.

This article documents every available column across all four views, including what each column displays, how calculated values are derived, and which columns are hidden by default.

How to show or hide columns

Click the Table Settings icon (gear icon) in the top-right corner of any table. In the sidebar that opens, drag columns between the Active Columns and Available Columns lists. You can also reorder active columns by dragging them into the desired position.

Legend: In the tables below, the Default column indicates whether a column is visible (Shown) or Hidden when you first open the table. The currency symbol (e.g. €) in column headers adapts to your project's configured currency.

1. Workplan Columns

The Workplan table shows your project's activities, milestones, deliverables, and events in a hierarchical tree structure. Activities can be nested, and many numeric columns aggregate values from child elements.

1.1 Identity & Structure

1.2 Scheduling

1.3 Status & Progress

1.4 Participants & Assignees

1.5 Costs & Budget

Cost columns aggregate values from all budget and expense entries linked to each activity and its children. Click a value to open the corresponding cost entries.

1.6 Funding

1.7 Resources / Effort

Effort columns are available in three units: Person-Months (PM), Person-Days (PD), and Person-Hours (PH). Click a value to open the corresponding cost entries.

1.8 Share of Total

1.9 Other

2. Participants Columns

The Participants table lists all project partners and organisations. Participants can be nested into a hierarchy (parent/child), and numeric columns aggregate values from child participants.

2.1 Identity

2.2 Members & Activities

2.3 Contact Details

2.4 Description & Objectives

2.5 Personnel Cost Rates

These columns display the default personnel cost rate for each participant. If no default rate is set, the first configured rate is used. Values are blurred for users without edit permissions when "Hide Rates" is enabled.

2.6 Costs & Budget

Cost columns aggregate values from all budget and expense entries linked to each participant and its children. Click a value to open the corresponding cost entries.

Note: Values are blurred for users without edit permissions when "Hide Rates" is enabled for the participant.

2.7 Funding

2.8 Resources / Effort

Effort columns are available in three units: Person-Months (PM), Person-Days (PD), and Person-Hours (PH). Click a value to open the corresponding cost entries.

2.9 Share of Total

2.10 Other

3. Budget Columns

The Budget table shows individual planned cost entries. Each row represents a single budget line item assigned to a specific activity, participant, and cost category. Unlike the Workplan and Participants tables, this is a flat list (no hierarchy).

Note: Cost-related values may be blurred for users with restricted permissions.

3.1 Assignment

3.2 Time Period

3.3 Costs

3.4 Funding

3.5 Effort

3.6 Personnel Cost Rates

3.7 Other

4. Expenses Columns

The Expenses table shows individual actual cost entries. Each row represents a single expense line item. Expenses share many columns with the Budget table but also include report linking, foreign currency fields, and special flags.

Note: Cost-related values may be blurred for users with restricted permissions.

4.1 Assignment

4.2 Dates

4.3 Costs

4.4 Funding

Tip: Budget vs Expenses funding rates

In the Budget table, the Funding Rate column uses the planned funding rate. In the Expenses table, it uses the actual funding rate. These may differ if rates have been adjusted between budget planning and expense reporting.

4.5 Effort

4.6 Personnel Cost Rates

4.7 Reports

4.8 Foreign Currency

These columns are only relevant when an expense was originally incurred in a currency different from the project's main currency.

4.9 Flags

These boolean columns appear as checkboxes. They control how an expense is treated in cost and funding calculations.

4.10 Other

Tips & Notes

• Currency symbol: Column headers showing (€) adapt to your project's configured currency. If your project uses USD, they will show ($) instead.
• Progress rings: Percentage columns (Consumption %, Share of Total) display a small circular progress indicator for visual scanning.
• Aggregation: In the Workplan and Participants tables, numeric columns can aggregate values from child rows when cumulative aggregation is enabled.
• Restricted visibility: In the Participants table, cost-related columns are blurred for users without edit permissions when "Hide Rates" is enabled for a participant.
• Column settings are saved: Your column visibility and order preferences are saved per table and persist across sessions.
• Filtering: Most columns support filtering. Click the filter icon in the column header to filter by specific values or ranges.
• Sorting: Click any column header to sort by that column. Click again to reverse the sort order.
• Export: All visible columns are included when you export the table to Excel.