Effects Spreadsheet
Overview
The effects spreadsheet (also known as Table of Effects Spreadsheet or TOES) is a record of the effects that a newly made item of legislation has on existing legislation.
You can read more on the background to TOES (Table of Effects Spreadsheet) in the Introduction to Record Effects.
The columns within the effects spreadsheet are populated during the record effects task with data as described below.
You can view the effects spreadsheet for an item of legislation that has had its effects researched by typing the following links in you browser (replacing <type> (e.g. ukpga, uksi, ssi, etc.), <year> and <number> with the appropriate values):
Affected document
https://editorial.legislation.gov.uk/changes/affected/<type>/<year>/<number>/data.xls?extended=full-with-co&sort=affecting-year-number
Affecting document
https://editorial.legislation.gov.uk/changes/affecting/<type>/<year>/<number>/data.xls?extended=full-with-co&sort=affecting-year-number
Column details relevant to Editorial Update
Id
The Id is automatically generated and is a protected column in the spreadsheet. If you try to enter data in this column, a pop-up will state "Do not change effect IDs. When you create a new effect, leave the ID blank. A new ID will be automatically created for it." Select cancel in this pop-up.
The Id is the unique group of numbers and letters that you normally see in XMetaL after the opening "ukl:Commentary" tag of an amendment's annotation.
You do not need to do anything with this column.
Affected Legislation
The affected legislation is the item of legislation to which an amendment will be applied.
The affected legislation column will be populated with the year, number and type of legislation. The preparation task Record Effects guidance on Affected and Affecting Legislation lists the different types of legislation and corresponding formatting that you should expect to see in this column.
Affected Provision(s)
The affected provision(s) is the provision of the affected legislation to which an amendment will be applied.
The preparation task Record Effects guidance on Affected and Affecting Provisions sets out the different levels of provision and the corresponding formatting that you should expect to see in this column.
The affected provision will have been entered from the point of view of the result of the effect, for example where a provision is to be renumbered (e.g. where s. 12 is being renumbered as s. 12(1)) then the result of the renumbering (s. 0012(01)) will have been entered as the affected provision. There will be one affected provision per row, with the exception of affected unbroken consecutive ranges of provisions/sub-provisions for example (e.g. s. 0010-0015).
When carrying out your Update task, you should also check the "Comments For Editor" column for any exceptions to the provision entered in the Affected Provision column. For example, where the affected provision has been drafted in the legislation as an Act or Part or even a range of provisions, but excluding certain provisions (for example, an “Act (except sections 1, 13, 25 and Schedule 1)” is repealed), the affected provision as drafted e.g. “Act” will be entered into column C and the provisions excluded from the amendment will be in "Comments For Editor" (e.g. “except sections 1, 13, 25 and Schedule 1”).
Type of Effect
The type of effect describes what an amendment contained within an affecting provision does to an affected provision. Effects are either textual (altering the text of the provision) or non-textual (modifying the provision’s scope or application without actually changing its text).
The type of effect column will be populated with a very brief description of the type of textual or non-textual effect to be applied to the affected provision, as described in the affecting legislation. The preparation task Record Effects guidance on Type of Effect lists out the different types of effects and the corresponding formatting that you should expect to see in this column. Note, any numbers in this column, whether referring to legislation or provisions, will not be formatted with leading zeros as they are in other columns in the spreadsheet such as Affected Legislation. For example, an Act would be entered as "2003 c. 14" in the Type of Effect column, compared to "2003 c. 014" in the Affected Legislation column.
When completing the Update task, this column will alert you to the type of textual amendment you will need to carry out in XMetaL, or the type of non-textual effect that you will need to check has had an auto-annotation correctly generated. Note that to determine if the effect will be carried out in XMetaL either wholly or be restricted by either the geographical extent or commencement dates of the affecting legislation, you will also need to check the "Affected Extent", "Affecting Territorial Application" and the "IF Date1" columns.
See more on types of effect in Editorial Principles - Types of Effect.
Affected Extent
The Affected Extent column will be populated with the initial of the provision's jurisdiction, chosen from one of the pre-set options in the drop-down list. This can range from UK: "E+W+S+NI" to the separate jurisdiction of Scotland or Northern Ireland: "S" or "NI", with various combinations in between. You can see a list of these combinations and further information in the preparation task Record Effects guidance on Affecting Extent and Affecting Territorial Application.
When completing the Research Affected Extent task, you will identify the affected legislation's extent provisions (in the latest version of the legislation) and populate this column with the precise extent of the lowest sub-provision that is affected.
When completing the Update task, the relationship between the entry in this column and the Affecting Extent and the Affecting Territorial Application columns will determine if the amendment carried out in XMetaL will be whole or limited extent. Limited extent amendments occur when the amendment to be applied has a narrower geographical extent (or territorial application) than that of the affected provision. We have to make sure that we don’t remove or replace text that still applies in other jurisdictions. Further information can be found on the Limited Extent Amendments page.
See more on extent in Editorial Principles - Extent and Territorial Application.
Affected Effects Extent
The Affected Effects Extent will be populated during the Research Affected Extent task if the extent of the effects within an affected provision is different from that of the affected provision itself. For example, a provision may extend to E+W+S (the Affected Extent value), but it may contain amendments to other legislation which are said to extend only to E+W or to have the same extent as the provisions they amend (i.e. 'Same as affected'). This is its Affected Effects Extent value.
See more on extent in Editorial Principles - Extent and Territorial Application.
Affected Territorial Application
The Affected Territorial Application column will be populated with the initial of the provision's territorial application (if there is one), chosen from one of the pre-set options in the drop-down list. For example, "E", "W", "S" or "NI", or a combination of these (or 'No' if there isn't one). You can see a list of the combinations and further information in the preparation task Record Effects guidance on Affecting Extent and Affecting Territorial Application.
When completing the Research Affected Extent task, you will identify the affected legislation's extent provisions (in the latest version of the legislation) and populate this column with the precise territorial appliation of the lowest sub-provision that is affected (if territorial application is specified).
When completing the Update task, the relationship between the entry in this column and the Affecting Extent and the Affecting Territorial Application columns will determine if the amendment carried out in XMetaL will be whole or limited extent. Limited extent amendments occur when the amendment to be applied has a narrower geographical extent (or territorial application) than that of the affected provision. We have to make sure that we don’t remove or replace text that still applies in other jurisdictions. Further information can be found on the Limited Extent Amendments page.
See more on territorial application in Editorial Principles - Extent and Territorial Application.
Affecting Provision Extent
The Affecting Provision Extent column will be populated with the initial of the provision's jurisdiction, chosen from one of the pre-set options in the drop-down list. This can range from UK: "E+W+S+NI" to the separate jurisdiction of Scotland or Northern Ireland: "S" or "NI", with various combinations in between. You can see a list of these combinations and further information in the preparation task Record Effects guidance on Affecting Extent and Affecting Territorial Application.
See more on extent in Editorial Principles - Extent and Territorial Application.
Affecting Extent
The Affecting Extent column will be populated with the initial of the provision's jurisdiction, chosen from one of the pre-set options in the drop-down list. This can range from UK: "E+W+S+NI" to the separate jurisdiction of Scotland or Northern Ireland: "S" or "NI", with various combinations in between. You can see a list of these combinations and further information in the preparation task Record Effects guidance on Affecting Extent and Affecting Territorial Application.
When completing the Research Affected Extent task, the contents of this column and the Affecting Territorial Application column will determine if this task can be skipped. If the affecting extent is marked as 'UK' or 'same as affected' and the Affecting Territorial Application column is either empty or matches the affecting extent then this task can be skipped.
When completing the Update task, the relationship between the entry in this column and the Affected Extent and the Affected Territorial Application columns will determine if the amendment carried out in XMetaL will be whole or limited extent. Limited extent amendments occur when the amendment to be applied has a narrower geographical extent (or territorial application) than that of the affected provision. We have to make sure that we don’t remove or replace text that still applies in other jurisdictions. Further information can be found on the Limited Extent Amendments page of the wiki.
See more on extent in Editorial Principles - Extent and Territorial Application.
Affecting Territorial Application
The affecting Territorial Application column will be populated with the initial of the provision's territorial application (if there is one), chosen from one of the pre-set options in the drop-down list. For example, "E", "W", "S" or "NI", or a combination of these (or 'No' if there isn't one). You can see a list of the combinations and further information in the preparation task Record Effects guidance on [[Preparation_Tasks/Record_Effects#Affecting_Extent_and_Affecting_Territorial_Application|Affecting Extent and Affecting Territorial Applicatio