| Anchor | ||||
|---|---|---|---|---|
|
The Table and Chart Wizards enable you to create ad-hoc tables and charts. After you create the charts and reports in an Excel workbook, you can save the report locally on your PC.
You can refresh the data in the workbook to see the latest up-to-date information from Accolade.
...
- Select Action
- Select Subject
- Select Columns
- Filter Data
- Summarize Data
- Sort Table
- Order Columns
- Table Location
| Anchor | ||||
|---|---|---|---|---|
|
Select Action (Top)
1.On the Accolade menu of the Excel workbook, point to Accolade Wizards, and then click Table Wizard.
2.Accolade Server URL :
- WEGO production System : http://wego.solvay.com:80/
- SBS production System : http://biarritz.solvay.com:80/
3.Click New.
Anchor SelectSubject SelectSubject
| SelectSubject | |
| SelectSubject |
Select Subject (Top)
1. Click the Projects option.
2.Click Next.
Anchor SelectColumns SelectColumns
Select Columns (Top)
In this step you can select the columns that will be used to create the table and determine how they will be used. (list of the Metrics)
1.Before you begin selecting columns, experiment with the
and
buttons in the lower left corner. These buttons allow you to quickly locate the group of columns you are looking for without scrolling through the entire list.
...
5.Select the Hide Unused Columns check box if you want to see only those columns that will be used to create the table.
6.Click Next.
Filter Data (Top)
...
In this step you can choose whether and how to combine values in this table. To summarize values is to calculate a value, such as a sum or average, for the values in one column that are associated with a single item in a different column.
1.Click Next.
Anchor SortTable SortTable
| SortTable | |
| SortTable |
...
c. System Current Phase ID
4.Click Next.
Anchor OrderColumns OrderColumns
| OrderColumns | |
| OrderColumns |
...
1.Select a place where to create the table. You can select a new or an existing worksheet. In this case, create a new worksheet named Data.
An existing worksheet will be cleared of all contents when the table is created. Do not create a table on a worksheet that contains data that you want to save.
...
(i) Select Highlight Cells Rules and Equal To…
(ii) Type [EMPTY]
...
| Content by Label | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|