In part, The PASI Status (TPS) report includes information exported from Hansoft. To prepare the information for the TPS report complete the following steps.

• From within the Quality Assurance tab of the PASI Project, select the TPS Feature Listing report.

• From the More menu, select Export and import –> Export ALL items as spreadsheet (.xlsx).

• Save the export as: http://engage/pasi/team/Team Documents/PMT Meetings/Hansoft Exports/Hansoft Feature Listing.xlsx

• From within the Task list of the PASI Project, select the TPS Remaining Tasks report.

• From the More menu, select Export and import –> Export ALL items as spreadsheet (.xlsx).
• Save the export as: http://engage/pasi/team/Team Documents/PMT Meetings/Hansoft Exports/Hansoft Remaining Tasks.xlsx

• From within the Schedule tab of the Time Reporting project, select the TPS Timesheets report.

• From the More menu, select Export and import –> Export ALL items as spreadsheet (.xlsx).
• Save the export as: http://engage/pasi/team/Team Documents/PMT Meetings/Hansoft Exports/Hansoft Timesheets.xlsx

• Open the PASI Status Tracking spreadsheet from http://engage/pasi/team/Team Documents/PMT Meetings/ ¹⁾
• Run the Hansoft Import macro by clicking on the icon in the title bar.

• Wait for the 'Finished Importing Hansoft Exports' dialog and click OK.
• Save the updated version of the spreadsheet.

• Open the TPS from http://engage/pasi/team/Team Documents/PMT Meetings/

• Delete the Deliverable Progress - Last Week chart
• Move the Deliverable Progress - This Week chart to be the Deliverable Progress - Last Week chart
• Copy the Project Deliverables % Complete chart from the Dashboard tab of the PASI Status Tracking spreadsheet.
• Paste the chart as the Deliverable Process - This Week chart (make sure to paste the chart as an image)

• Delete the Remaining Capacity - Last Week chart
• Move the Remaining Capacity - This Week chart to be the Remaining Capacity - Last Week chart
• Copy the Capacity chart from the Dashboard tab of the PASI Status Tracking spreadsheet.
• Paste the chart as the Remaining Capacity - This Week chart (make sure to paste the chart as an image)

• From the Deliverables tab of the PASI Status Tracking spreadsheet, select and copy the Grand Totals for the deliverables ²⁾
• In the TPS report, select the corresponding cells in the Progress By Deliverable table
• Paste the updated information into these cells (make sure to paste the information as plain text)

• Delete the Release Capacity - Last Week chart
• Move the Release Capacity - This Week chart to be the Release Capacity - Last Week chart
• Copy the Release Capacity by Team chart from the Dashboard tab of the PASI Status Tracking spreadsheet.
• Paste the chart as the Release Capacity - This Week chart (make sure to paste the chart as an image)

• Features pending approval by PAT
  • In Hansoft, from the Quality Assurance tab of the PASI Project, select the Features Pending Approval report.

• This report identies the features Pending Approval.
• Update the number of features pending approval by PAT based on the number of features in this report.

• Features not yet assigned a release
  • In Hansoft, from the Quality Assurance tab of the PASI Project, select the No Release report.

• This report identies the features that have been approved, but have not been scheduled within a release.
• Update the number of features that have not yet been scheduled for a release based on the number of features in this report.

• Deferred Features
  • In Hansoft, from the Quality Assurance tab of the PASI Project, use the Browse through statuses and more… functionality.

• In this drop-down, find the number of features identified as Status Feature - 07 Deferred

• Update the number of features that have been deferred based on the number of features in this status.

General, this report will include the next 3 releases to go to production. The information for each release can be updated in the same manner. The overall status of the release can be updated based by determining which phase the release is in based on the release schedule.

This information is best updated by using the Release by Status report from the Quality Assurance tab of the PASI Project in Hansoft. This report groups features based on the release and the status of the feature.

This information is best updated by using the Release by Deliverable report from the Quality Assurance tab of the PASI Project in Hansoft. This report groups features based on the release and the project deliverable. Any feature with a project deliverable of Operational Update should be included in the TPS report.

This information can be updated by using the Release by Deliverable report from the Quality Assurance tab of the PASI Project in Hansoft. Any feature with a system in the Integration Impacts column should be included in the TPS report.

This information typically doesn't need to be updated unless the schedule for the release changes. Generally, the only update done is to change future tense to past tense and to remove historical schedule information that no longer matters.