PS. Spreadsheet Report
- iarmstrong
Overview
Inside APS it is possible to create Spreadsheet reports similar to what you would find in Microsoft Excel. Navigating and generating reports should be relatively straightforward if you are familiar with Excel. A high-level overview of the report and the key functionality is provided below.
Report Layout
When a Spreadsheet Report is created, it creates a basic version of Excel. There should be no problems navigating and using the report if you are familiar with Excel. A high-level summary of the layout is detailed below. If more detail is required, more information can be found by searching the internet as the function should be well documented for Excel.
Component | Description |
|---|---|
Max Calculation Seconds | The maximum time allowed to perform calculations. Once exceeded, any values yet to be calculated will be left unpopulated. |
Ribbon Tabs | Tabs that allows you to quickly find, understand and use commands for completing a certain task. |
Ribbon Controls | Contains multiple command buttons logically sub-divided into groups. Command buttons are clicked to perform the action. |
Formulae Bar | Special tool bar that lets you enter or view information in a cell. |
Cells | A box that contains data. A cell exists at the intersection of a horizontal row, labelled with alphabetical values, and vertical column which is labelled with numeric values. A collection of cells is called a worksheet. |
Sheet Tabs | A tab that contains a single worksheet. Multiple tabs can be created each containing its own worksheet. |
Creating a Spreadsheet Report
The process for creating a Spreadsheet report is the same as other Alastri Report types.
Navigate to the Reporting tab.
Select the Add Report.
Select “Spreadsheet Report”.
Rename the Report.
Converting an Existing Report
All existing reports found in APS projects can be converted to a Spreadsheet Report where the data can be further manipulated and utilised. When a report is converted, the values are not copied; instead, the formulae used to obtain the value are copied into the worksheet cell. This helps understand how to use Alastri Functions and build reports which have not been converted from an existing report.
The following procedure outlines how to convert an existing report.
Create a new Spreadsheet Report to house the converted report.
Select the report that is required to be converted.
Select the To Spreadsheet .
The converted report will appear in the Spreadsheet as a new Worksheet tab.
Alastri Functions
There are a number of Functions that can be used to pull in data from the schedule. These functions are found under the Formulas Ribbon Tab in the Alastri Functions Ribbon Control.
Alastri Function | Description |
|---|---|
Misc | Returns Information about the version number and product being used. |
Periods | Returns information surrounding the scheduling periods. |
Pivot Data Sources | Meta - Returns meta information about the available Pivot data sources. Values - Returns a numeric value from a selected data field. PeriodSet Values - Returns a numeric value from a selected data field for a specified period set. |
Chrono Data Sources | Meta - Returns meta information about the available Chrono data sources. Values - Returns a numeric value from a selected data field. PeriodSet Values - Returns a numeric value from a selected data field for a specified period set. |
Example NPV Report
An example of how to create a simple Spreadsheet report is provided below.