Text size adjustment
Hold down the Ctrl key (PC) or Cmd key (MAC) and press "+" to enlarge or "-" to reduce the text size.
The person responsible for the operator's reporting shall ensure:
Quality implies that the reporting is in accordance with the requirements listed in the General Guidelines and in the Reporting file.
As previously mentioned in the guidelines, it is essential that no changes are made to the structure of the file. An automatic control whether there are reference errors are executed when saving the file. You should not be able to save the file if reference errors occur, it is recommended to undo actions that have affected formula references.
As part of the quality control, several consistency checks are included in the spreadsheet, below the profile collection. Mainly these checks control the consistency between information reported various places in the spreadsheets. When a consistency check gives a result, there are two alternatives:
To help secure that this is accomplished, a check is incorporated in the reporting file. If there are unclarified consistency checks, a warning will show up after 1 October indicating which profile sheet this relates to when closing the file.
Control that the same quantity is reported in the sheet ”Månedsdata”, as in the actual profile collection, as sales forecasts for the next year. A margin of 0.001 is granted for rounding off numbers. It is important that these numbers are correct, since they should be consistent with the production application.
Control that the resources reported in the profile collection equals the numbers reported in the project overview in the profile collection. A deviation of respectively 0.1 and 0.01 for “large” and “small” deposits is allowed.
Control that the different contributions to CO2- and NOx-emissions respectively, add up to the total emissions reported.
Control that there are CO2- and NOx-emissions every year with production. These checks are not active for profile collections containing reserves in fields without emission from fuel and flare. If there are consistency on a file level (Profil_Total) no comments are given, else there will be comments in the individual profile sheets with deviations between production and emissions.
Control that there is no production after shut down costs have been reported. A feedback will be given in the consistency check area in Profile 1 if the production continues after the reporting of the shut-down costs across the various projects in the file (the figures are taken from the Profil_Total, which sums the figures across the profile collections in the reporting file).
Is only shown in Profile 1 and is based on a summation of all profile collections in the file (Profil_Total). Control that annual cash flow are positive. The intention is to check sales data versus cost data to reveal significant errors (for instance in units) in the report. In this connection, firm prices have been assumed for all petroleum products:
It is emphasized that these assumptions do not reflect the authorities' assumptions, but are merely intended for use to reveal significant reporting errors.
New check to control the succession of reported decision gates. The assumption is that DG0 will be passed before or in the same year as DG1, DG1 before DG2 etc.
These checks are used for qualitative checking of the gas profiles; 16 checking the balance, and 17 checking the consistency between sales and environmental profiles. The checks are qualitative because they are comparing gas flows with different calorific values, and comparing gas sales profiles from the field/discovery with profiles of gas delivered from the facility.
The checks are activated if the balance (check 16) is off by 0.3 billion Sm³, and if the consistency (check 17) is off by 0.2 billion Sm³.
If the checks are activated due to errors in the input, the input must be fixed, or if the checks has a reasonable explanation, this has to be included.
Control if comment boxes are used. It will be more useful to make comments in the text boxes prepared for this, than to comment in the space next to the response from the consistency check.
New check to control the coherence between resource class/sub-class and decision gates reported. Resource class/sub-class shall be reported according to expected status at the end of the reporting year.
Control the consistency between the sum of sales gas profiles per calendar year and gas year. Will also check whether input of gas purchase is complete, with both volume and cost.
Control of drilling costs. This check will give a result when unit costs per well or unallocated well costs are outside the stated thresholds. The well number can be expressed as a decimal figure to correspond with accrued investments within the same year.
Is only shown in Profil_1. Control that operation costs are reported in the profile collection for the same period as for income. A feedback will be given in the consistency check area in Profile 1 if the condition mentioned above is not fulfilled for the file in total (the figures are taken from the Profil_Total, which sums the figures across the profile collections in the reporting file).
Control that removal and cessation costs are reported for projects in operation or projects containing investments in new infrastructure.
Control whether the table for uncertainty regarding production start-up for projects in RC 2-5 is filled in and that the timing of respectively early, basis and late is consistent. From RNB2019 there will also be feedback if production profiles start in a different year than stated in the table.
Control whether the table showing the project attributes is filled in. This table should be filled in for all projects with resources in RC 3-5.
Control whether there is a correlation between the development concept in the table of attributes and the development investment shown in the profile collections.
The control checks for investment numbers in the columns of floating or fixed facilities when these are selected as development solution, and that there are no investment numbers in these columns when subsea development is selected.
Control whether subsea facilities in RC 3-5 have reported associated pipeline investment and that necessary investments at the host platform are placed in the correct column.
Control whether discoveries have reported costs for concept studies. It also controls whether development projects have reported number of wells.
New check to verify input of the assumed general price increase (GPI). A feedback will be given in the consistency check area in Profile 1 if there are cost elements beyond the reporting year and GPI is lacking.
This check only appears in Profil 1 and controls whether there are negative values in the forecasted period in the total of all profiles in the reporting file (appears in Profil_Total).
Normally there should not be any negative figures in the total value for a field, discovery or facility. Negative costs should be recognized as income, negative production as injection etc.
Control that service provider are stated when tariffs are entered.
The input in this sheet is the operator’s assumptions for general price increase, if not this is a constant value. In such cases input should be provided in cell AC28 in the sheet Profil_1. In addition, the sheet contains two visual consistency checks linked to the sheet ”Profil_Total”, which give a total of all the profile collections.
General price increase should be the operator's general assumption when converting nominal NOK to real NOK. For example, figures for 2019 apply to the general price increase from 2018 to 2019. This price increase must be used when converting the budget figures in nominal NOK to the reference year in real NOK. We expect the same general price increase to be used for all projects reported by the same operator. We recommend that data are entered into the spreadsheet by a coordinator before internal distribution to the projects.
The visual consistency checks below give a sum across all profile collections. Calculated net cash flow and costs per well are plotted against year. Any profile collections containing data outside a defined threshold value will be listed. Any comments, if the data is considered valid, should be made in the consistency check table for the relevant profile collections, checks 21-25.