Spreadsheet View Format of the Assignments Page of the Resources Section

Overview

Use the Spreadsheet format to view time distributed usage data in spreadsheet format.

Screen Elements

Right-clicking on the timescale will display:

Timescale list

The Gantt chart time interval options. Select from one of the following intervals:

Week/Day: The Gantt View is divided into weeks which are then divided into days.

Month/Week: The Gantt View is divided into months which are then divided into weeks.

Quarter/Month: The Gantt View is divided into quarters which are then divided into months.

Year/Month: The Gantt View is divided into years which are then divided into months.

Year/Quarter: The Gantt View is divided into years which are then divided into quarters.

Financial Period: The Gantt chart is divided into years which are then divided into financial periods.

Spreadsheet columns

Only the default fields that appear as columns in Assignments Spreadsheet are described below.

Remaining Early Units field

The units remaining to complete the assignment distributed between the Early Start and Early Finish of the assignment.

Calculated as Remaining Duration multiplied by Remaining Units per Time.

Getting Here

  1. Click Resources.
  2. On the Resources navigation bar, click Assignments.
  3. Click Spreadsheet View.

Last Published Wednesday, July 10, 2024