About Fields in Treatment Summary Reports
To view the results of a Works Plan, you can download a CSV report of all Sections, with Treatment quantities broken down by financial year. The report includes all subsections, even if no treatment is recommended. The information in this report is the same as the Treatment Summary (CSV) run for a Treatment Set, but includes the recommended treatments for each financial year defined in the Works Plan based on the Works Plan strategies (including the budget) and priorities. See also Viewing Treatment Set Reports and About Works Plan Reports.
Treatment Summary reports include fields with details providing an in-depth explanation of how Horizons selected and prioritised treatments for the given scenario. Horizons also includes these fields when you export a Treatment Set or Works Plan layer. See also Exporting Layers.
Treatment Summary reports include the following fields:
| Treatment Summary Label | Exported Layer Label | Description |
|---|---|---|
| Scheme_Priority | sch_prio | Scheme Priority is the order of schemes based on specific criteria that vary by scenario type as follows: Worst First: * future Works done * whether the scheme meets the minimum length * condition score (largest first) * treatment cost (smallest first) Other Scenarios: * future works done * whether the scheme meets the minimum length * whether a more severe scheme will be needed next year (asset sweating) * Benefit Cost Ratio (largest first) * treatment cost (smallest first) |
| Condition Priority | con_prio | Condition Priority is the priority ranking based on the treatment Benefit Cost Ratio. To determine the treatment BCR, Horizons first calculates the benefit of the effects of a treatment on each condition parameter within a subsection and then calculates the mean benefit for the subsection. Horizons sums the mean benefit of each subsection within the scheme and divides the total by the scheme cost, then multiplies it by the treatment BCR Scaling Factor. Horizons then orders the schemes by the treatment BCR to determine the Condition Priority. Where two schemes have the same treatment BCR, the least costly scheme takes higher priority. There is an exception for future works done, which always take the highest priority. |
| Condition Score | con_score | Condition Score is a value between 0 and 1 that indicates the mean rated value of all condition parameters within a given length. Each condition parameter value for a subsection is rated using its defined rating curve. The Condition Score of a subsection is the mean rated value of all its condition parameters. The Condition Score of a scheme is the mean rated value of the subsections that it spans. |
| Overlay Priority | ov_prio | The Overlay Priority is the order of schemes based on the overlay Benefit Cost Ratio (BCR). To determine the overlay BCR, Horizons first finds the prioritisation benefit for the scheme by calculating the prioritisation benefit for each subsection within the scheme, and multiplying the sum by lambda (λ), then dividing it by the scheme cost. Lambda is derived from the *Conditions vs Priorities* setting within the Works Plan configuration. See [Running a Works Plan](/analysis/works-plans/running-works-plans.html). Horizons then orders schemes by the overlay BCR, determining the overlay priority. Where two schemes have the same overlay BCR, the least costly scheme takes higher priority. There is an exception for future works done, which always take the highest priority. Overlay Priority is not included as a field in the Treatment Summary, however it influences the Scheme Priority results. You can view the Overlay Priority in Treatment Set or Works Plan exported layers. See [Exporting Layers](/explorer/layers/exporting-layers.html). |
To export a Treatment Summary CSV file
- In the Layers folder, select the required Works Plan or Treatment Set layer.
- Click the Reports icon.
The list of Layers to report on drops down. The Treatment Summary report is identified with the following icon:
- Click the Treatment Summary report.
The CSV file automatically downloads to your downloads folder.