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 the data 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
TOES column details
| Column heading | Column contents | Example |
|---|---|---|
| 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. |
key-aa80308b15749172e262d381ea071e0a |
| Affected Legislation | The affected legislation is the item of legislation to which an amendment will be applied.
The affected legislation column is populated with the legislation identifying number, which is made up of the year, number and type of legislation, examples of which are shown in bold for each type of legislation in the column to the right. Also included in brackets after the legislation number is the Affected Provision recorded in TOES where whole document is the affected provision. The preparation task Record Effects guidance on Affected and Affecting Legislation gives more detail about the different types of legislation and corresponding formatting that you should expect to see in this column. |
Acts of the Westminster Parliament (or Public General Acts): 2009 c. 022 (Act)
Acts of the Scottish Parliament: 2009 asp002 (Act) Measures of the National Assembly of Wales: 2009 nawn002 (Measure) Acts of the National Assembly of Wales: 2012 anaw002 (Act) Local acts of the Westminster Parliament: 1877 c. cxxi (Act) Measures of the Church Assembly or General Synod: 1988 gsm002 (Measure) Acts of the Northern Ireland Assembly: 2001 c. 002 (N.I.) (Act) Northern Ireland Orders in Council (1974 onwards): 1978 SI0039 (N.I.) (Order) United Kingdom and Welsh Statutory Instruments: 1999 SI0119 (Regulations, Order or Rules) NB 1999 WSI0119 (online generated) acceptable for Welsh SIs Scottish Statutory Instruments: 1999 SSI0195 (Regulations, Order or Rules) Also: Acts of Adjournal and Acts of Sederunt (Instrument) Northern Ireland Statutory Rules: 2000 SR0001 (Rules) Archbishops’ Instruments: 2000 AI0001 (Instrument) Statutory Rules and Orders: 1927 SRO0813 EU Regulations: 2017 EUR0371 (Regulation) EU Decisions: 2003 EUDN0033 (Decision) EU Directives: 2012 EUDR0003 (Directive) |
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 - Effects.
Affected Extent
The Affected Extent column will be populated with a letter or letters denoting 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 a letter or letters denoting 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 a letter or letters denoting 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