Difference between revisions of "Effects Spreadsheet"
| Line 46: | Line 46: | ||
===D - Type of Effect=== | ===D - Type of Effect=== | ||
| + | The type of effect describes what 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 affected provision column will be populated with the lowest, numbered (or lettered as the case may be) affected provision/sub-provision as stated in the affecting legislation. The preparation task <strong>Record Effects'</strong> guidance on [[Preparation_Tasks/Record_Effects/Affected_and_Affecting_Provisions|Affected and Affecting Provisions]] sets out the different levels of provisions and their corresponding formatting that you should expect to see in this column. | ||
| − | |||
The tables show the marginal abbreviations the editorial team use to mark effects in the legislation during the Identify Effects task. These will be available to the editor doing the Record Effects task either in hard copy or via a link on the online system to a scanned electronic version of the hard copy. | The tables show the marginal abbreviations the editorial team use to mark effects in the legislation during the Identify Effects task. These will be available to the editor doing the Record Effects task either in hard copy or via a link on the online system to a scanned electronic version of the hard copy. | ||
| Line 57: | Line 58: | ||
| + | When citing legislation or provisions in the Type of Effect column you do not need to follow the rigid formatting instructions set out in the Affected and Affecting Legislation and Affected and Affecting Provisions pages, regarding numbers of digits and leading zeros. So although when entering values in the Affected Legislation and Affected Provision you might put, for example, 2003 c. 014, s. 0005(07), when entering the same legislation and provision in the Type of Effect column you would say something like “amendment to earlier affecting provision 2003 c. 14, s. 5(7)”. (Also see Knock On Effects) | ||
| + | Secondary legislation is also cited differently in the Type of Effect column from the way it would be cited in the affected and affecting legislation columns on Extended TOES. In the Type of Effect column we move away from the rigid formatting rules set out in the Affected and Affecting Provisions page and revert to the standard forms used by the legislative drafters. For example, a UK Statutory Instrument would be cited as follows: S.I. 1997/473; a Scottish Statutory Instrument thus: S.S.I. 1999/5; and Northern Ireland Statutory Rules like this: S.R. 2006/33. (Also see Knock On Effects) | ||
| − | |||
| − | |||
When completing the <strong>Record Effects</strong> task, the affected provision will be 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 be entered as the affected provision. There will be 1 affected provision per row, with the exception of affected unbroken consecutive ranges of provisions/sub-provisions for example (e.g. s. 0010-0015). | When completing the <strong>Record Effects</strong> task, the affected provision will be 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 be entered as the affected provision. There will be 1 affected provision per row, with the exception of affected unbroken consecutive ranges of provisions/sub-provisions for example (e.g. s. 0010-0015). | ||
Revision as of 13:29, 25 June 2019
To update
Column Groupings
Extent
Columns E-J
Amending
Commencement
Additional PiTs
Columns Z onward:
Explain the first set - talk through and then put they are all the same after that.
Notes for Editor
Column
Column overview
A - Effect ID
The Effect 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 effect 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.
B - Affected Legislation
The affected legislation is the primary or secondary piece 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 their corresponding formatting that you should expect to see in this column.
When completing the Record Effects task, there may be several different pieces of legislation in this column as the spreadsheet records every piece of legislation affected by the legislation whose effects have been identified in the prior preparation task, Identify Effects task.
In contrast, when completing the Research Effects and Update tasks, there will only be one piece of legislation in this column as the spreadsheet only contains the effects information which affect the piece of legislation you are researching/updating.
C - Affected Provision(s)
The affected provision(s) is the provision of the affected legislation to which an amendment will be applied.
The affected provision column will be populated with the lowest, numbered (or lettered as the case may be) affected provision/sub-provision as stated in the affecting legislation. The preparation task Record Effects' guidance on Affected and Affecting Provisions sets out the different levels of provisions and their corresponding formatting that you should expect to see in this column.
When completing the Record Effects task, the affected provision will be 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 be entered as the affected provision. There will be 1 affected provision per row, with the exception of affected unbroken consecutive ranges of provisions/sub-provisions for example (e.g. s. 0010-0015).
You will use this column to determine which part of the primary or secondary legislation you will be applying the amendment to when completing the Research Effects and Update tasks. You should also check the "COMMENTS For Editor" (column Q) for any exceptions to the provision entered in column C. 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" (column Q) (e.g. “except sections 1, 13, 25 and Schedule 1”).
D - Type of Effect
The type of effect describes what 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 affected provision column will be populated with the lowest, numbered (or lettered as the case may be) affected provision/sub-provision as stated in the affecting legislation. The preparation task Record Effects' guidance on Affected and Affecting Provisions sets out the different levels of provisions and their corresponding formatting that you should expect to see in this column.
The tables show the marginal abbreviations the editorial team use to mark effects in the legislation during the Identify Effects task. These will be available to the editor doing the Record Effects task either in hard copy or via a link on the online system to a scanned electronic version of the hard copy.
The editor should translate the marginal mark up abbreviation shown in the second column of the tables into the appropriate Extended TOES Type of Effect shown in the third column. In order to help you do this quickly please make use of the AutoCorrect facility in Excel (MS Excel Autocorrect). A list of example Autocorrect codes is provided in the fourth column.
Remember that the tables contain only the most common types of effect. There may be instances where the mark up editor has had to construct an unusual type of effect in order to reflect truly the result of the drafter’s wording. This will be spelled out in the margin of the legislation and you should follow this suggestion when inputting. If you are in any doubt about the type of effect to use, please contact a member of the TNA editorial review team.
When citing legislation or provisions in the Type of Effect column you do not need to follow the rigid formatting instructions set out in the Affected and Affecting Legislation and Affected and Affecting Provisions pages, regarding numbers of digits and leading zeros. So although when entering values in the Affected Legislation and Affected Provision you might put, for example, 2003 c. 014, s. 0005(07), when entering the same legislation and provision in the Type of Effect column you would say something like “amendment to earlier affecting provision 2003 c. 14, s. 5(7)”. (Also see Knock On Effects)
Secondary legislation is also cited differently in the Type of Effect column from the way it would be cited in the affected and affecting legislation columns on Extended TOES. In the Type of Effect column we move away from the rigid formatting rules set out in the Affected and Affecting Provisions page and revert to the standard forms used by the legislative drafters. For example, a UK Statutory Instrument would be cited as follows: S.I. 1997/473; a Scottish Statutory Instrument thus: S.S.I. 1999/5; and Northern Ireland Statutory Rules like this: S.R. 2006/33. (Also see Knock On Effects)
When completing the Record Effects task, the affected provision will be 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 be entered as the affected provision. There will be 1 affected provision per row, with the exception of affected unbroken consecutive ranges of provisions/sub-provisions for example (e.g. s. 0010-0015).
You will use this column to determine which part of the primary or secondary legislation you will be applying the amendment to when completing the Research Effects and Update tasks. You should also check the "COMMENTS For Editor" (column Q) for any exceptions to the provision entered in column C. 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" (column Q) (e.g. “except sections 1, 13, 25 and Schedule 1”).