PSCI Report

This is a summary PSCI Excel workbook that contains all PSCI ratings for every road in the local authority. Note the “Enable Content” option must be clicked for the Year and Month columns to be filled (these are calculated from the Timestamp), and for the charts to be populated.

../../../_images/enable_editing.png

The workbook contains a number of sheets, listed below.

../../../_images/form_a_tabs.png

Data

The first sheet in the workbook has a dump of all PSCI data in the system. This is used to populate the charts and graphs in the other sheets.

../../../_images/form_a_1.png

Weighted Average

This sheet calculates a weighted average for a road segment based on the length of each PSCI value.

../../../_images/form_a_wght_ave.png

Class by Rating

This sheet contains three charts, displaying PSCI lengths and percentages split into road classes (Local Primary, Local Secondary etc.)

  • Rating Sum of Length by Road Class

  • Rating Percentage by Road Class

  • Sum of Length by Road Class and Rating

../../../_images/form_a_class_rating.png

Rating by Class

This sheet contains three charts, displaying road class lengths and percentages split into PSCI ratings (1-10).

  • Road Class Sum of Length by Rating

  • Road Class Percentage by Rating

  • Sum of Length by Rating and Road Class

../../../_images/form_a_rating_class.png

Backlog Cost

../../../_images/form_a_backlog_cost.png

Maintenance Backlog Cost

../../../_images/form_a_mtce_backlog.png