Planned Works Report

This report is generated to display a list of all Works in the system that are in the planned phase. The data that is exported from the PMS database is classed as coming from the before data fields in the system; i.e. estimated costs, dimensions, before PSCI etc. It is also known as “FORM D”.

The “Enable Content” and “Enable Macros” options must be clicked for the charts to be populated.

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

Note where PMS has two values - an “auto-calculated” value, and a manually entered value, the manually entered value will take precedence. If no value has been entered manually the auto-calculated value will be used.

For example in the image below the 3,000m length will be used, as the user has overridden the 2,998.51m value calculated by taking the geometry length. The manually entered width of 5.5m will be used, but the system-calculated Area of 17,991.08m2 will be used as this has not been overridden.

../../../_images/works_manual_entry.png

The Excel worksheet has a number of individual tabs. These are described below.

../../../_images/works_tabs.png

Works Data

This sheet contains a data dump of all planned works in PMS. It is used to populate the tables and charts in the other sheets.

../../../_images/works_data.png

Works Summary by Year

This sheet provides a summary of Works types (Surface Restoration, Road Reconstruction etc.), with summary values for length, area, and estimated cost. The data can be filtered by year using the drop-down box.

../../../_images/works_year_summary.png

Regional and Local Roads Grants

This sheet provides a summary of works type (Surface Restoration, Road Reconstruction etc.), broken down by local and regional roads, with summary values for length, area, and estimated cost. The data can be filtered by year using the drop-down box.

../../../_images/grants_by_year.png

Summary of Projects to be Funded

This sheet provides a summary of estimated costs broken down by works types (Surface Restoration, Road Reconstruction etc.) and year.

../../../_images/project_summary.png

FAQs

Q:

Why are some Municipal Districts missing?

A:

There is no geometry for these Works. Segments may have been redigitised.

Q:

Why are there duplicated rows for funding?

A:

Length and Area not duplicated for these. See % of Total Estimated Cost

Q:

Why are Length and Area sometimes missing in `GrantsbyRoadClassbyYear?

A:

As splitting by Funding Source - and these are blank. They are always correct for majority funding category.