Difference between revisions of "Effects Spreadsheet"
(→D) |
|||
| Line 45: | Line 45: | ||
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 <strong>Research Effects</strong> and <strong>Update</strong> tasks. You should also check the <strong>"COMMENTS For Editor"</strong> (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 <strong>"COMMENTS For Editor"</strong> (column Q) (e.g. “except sections 1, 13, 25 and Schedule 1”). | 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 <strong>Research Effects</strong> and <strong>Update</strong> tasks. You should also check the <strong>"COMMENTS For Editor"</strong> (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 <strong>"COMMENTS For Editor"</strong> (column Q) (e.g. “except sections 1, 13, 25 and Schedule 1”). | ||
| − | ===D=== | + | ===D - Type of Effect=== |
| + | |||
===F=== | ===F=== | ||
===G=== | ===G=== | ||
Revision as of 12:14, 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”).