Author: Rob van de Laar, Jacco Daalmans

Processing energy prices for the Consumer Price Index

About this publication

Up to the reporting month of May 2023, pricing data for the consumer price index was collected at Statistics Netherlands through monthly sample surveys of newly concluded energy contracts. For a long time, this method provided a good picture of the price trends in the energy market. Starting from the reporting month of June 2023, CBS started using new data sources and methods specifically designed for detailed data. These methods will be explained, and some results are discussed of the research that was conducted to arrive at this methodology.

1. Introduction

The consumer price index (CPI) and the European harmonised index of consumer prices (HICP) measure monthly price developments for goods and services purchased by consumers. The inflation rate is based on the year-on-year change in the CPI. Energy includes ECOICOP groups 4.5.1 (electricity), 4.5.2 (natural gas) and 4.5.5 (district heating). In 2022, electricity and natural gas accounted for 2.6% and 3.0% of the CPI, respectively. District heating will not be discussed here.

Up to the reporting month of May 2023, pricing data was obtained from the Netherlands Authority for Consumers and Markets (ACM) every month to calculate the CPI for energy.  The data in question was collected through monthly sample surveys of only newly concluded energy contracts. For a long time, this method provided a good picture of price trends in the energy market. Moreover, it was implicitly approved by Eurostat, the statistical office of the European Union, as shown by the organisation’s annual report for 2021: in the section on compliance monitoring, energy is not identified as an area of concern (2023). ACM’s data collection was efficient and, in accordance with government guidelines, no duplicate information requests were submitted.

However, with the large price increases for energy products from mid-2021, the price development of new contracts was less representative of the broader market, as about half of all consumers had long-term, fixed-rate contracts when the price hikes started. In addition, many consumers with existing older, variable-rate contracts paid lower rates than consumers with new contracts. As the method described above does not provide a complete picture of all transactions in a volatile market, additional data was sought. A number of energy companies agreed to submit overviews of consumer contract data to Statistics Netherlands (CBS). This data provides comprehensive insight into the rates paid by all customers of the companies concerned, which has significantly broadened CBS’s view of price trends in the energy market.

The availability of these new data sources has also made it possible to apply new methods specifically designed for detailed data. CBS started using these methods in the reporting month of June 2023. The same methodology is used for the CPI and the HICP. Below, references to the CPI include the HICP.
The purpose of this report is to explain the methodology used. Some results of the research that was conducted to arrive at this methodology are discussed as well. This report is structured as follows: Chapter 2 describes the new data, Chapter 3 explains the new methodology, and figures presenting outcomes have been included in the annex (Chapter 5).

2. Data submitted by energy suppliers

Data is currently made available by a number of energy suppliers. These respondents submit a monthly integral file with their rates and the number of connections they service by contract type. It is essential that the data supplied includes pricing details for all consumer contracts, so that CBS gets a comprehensive overview of the respondents’ customer base each month. However, different respondents use different file structures and coding, and the details provided vary as well. Some suppliers submit micro-level data for each customer, while others only provide aggregated information, such as their average price rates and the total number of customers per contract type. The data provided by each supplier goes back to at least January 2020 and continues until the current reporting month.

Besides data on energy rates and numbers of connections, data on contract types is also available. Distinctions are made based on: 

  • Single rate or double rate;
  • Green or grey energy;
  • Contract duration;
  • Brand.

Energy suppliers may offer multiple brands under different names.  If this is the case, the respondent in question supplies data for all its brands and specifies under which name each contract type is offered.

Whether a contract has a fixed or variable rate can also be considered a product characteristic, but this is not mentioned separately here because it is directly related to the duration of the agreement:  contracts with a duration of less than one year are classified as variable contracts, all other ones as fixed. For some suppliers, the effective starting month of the contract and the date of signing are also known.

The following rates are distinguished for electricity:

  • Variable rate, single meter (euros/kWh);
  • Variable rate, double meter, off-peak (euros/kWh);
  • Variable rate, double meter, standard (euros/kWh);
  • Standing charge for electricity (euros/year).

There are two rates for natural gas:

  • Variable rate (euros/m3);
  • Standing charge for natural gas (euros/year).

When the data is entered into the production system, a number of checks are done, and records with missing rates or rates equal to zero are deleted. Besides the above data, which is provided directly by the energy suppliers, additional data – for instance on average electricity consumption – is also used in the calculations. This is explained in more detail in the next chapter.

3. Method

3.1 Introduction

The new method consists of a number of steps, which are explained in this chapter. Figures with outcomes have been included in the annex. Section 3.2 explains how the calculation prices – the annual energy bill amounts on which the price index is based – are determined. Section 3.3.1 describes how transaction data is aggregated into homogeneous products, delineated by price-determining characteristics. Section 3.3.2 sets out how the calculation prices are determined for each product based on the calculation prices of the individual contracts. Section 3.4 provides insight into how products are aggregated into one index for each respondent for electricity and one index for each respondent for natural gas. How these are incorporated into the CPI is described in Section 3.5. A number of other aspects are discussed in Section 3.6.

3.2 Determining the calculation prices

This section explains what prices are measured in the price index.

3.2.1 Definition

A household’s energy bill consists of several components: rates for the consumption of electricity and natural gas, transport costs, charges and taxes. All these components are included in the CPI. The purpose of this section is to explain how the different energy bill components are combined.

All components are annualised to arrive at a total amount per year for each connection. Each month, the amount per year is calculated based on the applicable rates. The annual price can be broken down into variable charges, which are calculated per kilowatt-hour (kWh) or cubic metre (m3), and fixed charges, which are calculated per connection. Several components of the fixed costs are expressed per year, which is why the CPI is produced based on annual rather than monthly prices.

Below are the various components, which are calculated both inclusive and exclusive of VAT:

  • per kWh or m3:
    • The variable rate per kWh or m3;
    • Renewable energy tax (ODE);
    • Energy tax.
  • per year for each connection:
    • Standing charge;
    • Transport rate;
    • Tax credit (‘energy tax refund’).

Rates and components can change monthly due to government measures (ODE, energy tax and tax credit) or decisions made by the energy companies (variable rates and the standing charge). CBS uses sample surveys to determine the average transport rate, which is set by the grid operator. The tax credit is shown within the expression for the calculation price as a negative amount, constituting a tax rebate. All other amounts are positive.

The annual energy bill amount is also referred to as the calculation price, which is defined as follows:

\begin{align*} Calculation\:price & = \left(\frac{100 + VAT\:rate}{100}\right) *\\ \biggl\{ &\bigg[Average\:annual\:consumption\:(kWh\: or\: m^{3})\bigg]\: *\\ *\: &\bigg[ Variable\:Rate+ODE+Energy\:tax \bigg]\: +\\ +\: &Standing\:charge + Transport\:rate + Tax\:credit \biggl\} \end{align*}

Average consumption quantities for electricity and natural gas are used to weight consumption-dependent rates and non-consumption-dependent rates/components of energy. These quantities, which are fixed for one year, are forecasts of energy consumption during the reporting year, prepared by the Netherlands Environmental Assessment Agency (2023). Annual consumption does not differentiate by contract type or by contract duration. For 2023, the average annual consumption per household is 1,064 m3 for natural gas and 2,151 kWh for electricity.

Some of the households with an electricity rate have double meters. These either pay an off-peak or a standard rate, depending on the time of day. For households with double meters, a fixed ratio between off-peak and normal consumption is assumed annually, which is assumed to be the same across all contract types. This ratio is based on consumption and is fixed for one year. 

The above leads to the following relationship:

\begin{align*} Variable\:&rate\:(Double\:rate) = \\ & Off-peak\:rate\: *\: \big[ Share\:off-peak\:consumption\:in\:total\:consumption \big]\: + \\ &Normal\:rate * \big[ Share\:normal\:consumption\:in\:total\:consumption \big] \end{align*}

From 2021, off-peak and normal consumption both account for 50% of total consumption.

In the next two sections, two specific aspects of determining calculation prices are discussed. Section 3.2.2 explains how the price cap, which was introduced in 2023, is incorporated into the variable rates in the calculation above. Section 3.2.3 discusses the tax credit in more detail.

3.2.2 Incorporation of the price cap

The price cap for energy, which was introduced on 1 January 2023, is a discount on the variable rates for electricity and natural gas up to a certain consumption cap per connection. Under this new policy, households whose consumption stays below a certain limit never pay more than the cap rate. Households that use more energy pay the variable rate specified in their contract for their energy consumption above the limit. The price cap is not incorporated into the index calculation at the individual level. This is because the discount a household receives due to the price cap is linked to consumption, and the provided data does not include information on individual consumption per connection. Instead, a consumption profile is used to estimate a new variable rate including the price cap using the originally submitted variable rates. This adjusted rate is based on estimates of expected consumption above and below the limit.

The consumption profiles correspond to estimated deciles of the annual energy consumption of Dutch households. For example, the first decile shows the consumption of households in the first 10% on the scale from low to high consumption. The consumption profiles are used for one year and – in the absence of more detailed data – are the same for all contract types.

The use of decile groups ensures more accurate estimates of the effects of the price cap. If the average energy consumption per household were used instead, this could lead to an underestimation of price developments in the CPI. The average consumption is below the limit set by the price cap, but there are also households whose consumption exceeds that limit. For example, if all contract prices are above the price cap rate, using average consumption would reduce the rate to that of the price cap, while some households would have to pay more due to their higher consumption.

Using the original rates, the new rates are calculated as follows:

  • For each decile group, an annual amount equal to the decile turnover is calculated as the product of a variable rate and decile group-dependent consumption. This includes the price cap discount based on the decile group’s consumption;
  • This annual amount is summed across all decile groups and then divided by the total consumption of all decile groups;
  • The result is a new variable rate that includes the price cap.

The above method implies the following relationship:
\begin{align*}
Variable\:&Rate\:inclusive\:price\:cap = \\
    &\alpha\:*\:Original\:rate +  (1-\alpha) * Price\:cap\:rate
\end{align*}
The factor α is the fraction of total consumption above the consumption limit. It is calculated here by adding the surplus of expected consumption above the price cap limit for each of the ten percentile groups and then dividing the result by the total consumption of the ten decile groups. The a factors in 2023 are 0.18 and 0.15 for electricity and natural gas, respectively.

The price cap is thus directly applied to the variable rates in the transaction data. For electricity, the price cap is applied separately to the off-peak and standard rates for households with dual-meter contracts. This corresponds with how the price cap is applied in practice.

3.2.3 Incorporation of the tax credit

As the government considers a certain amount of energy consumption to be a basic need, households receive a refund of part of their energy tax, also known as the tax credit. The energy tax refund is paid per electricity connection.

CBS has chosen to deduct the energy tax refund partly from the price of electricity and partly from the price of natural gas from 2022 onwards. On the one hand, this is more in line with the aim of the scheme, which is to offer compensation for all taxes on electricity and natural gas. On the other hand, this avoids including negative electricity prices in the CPI.

From 2022, the energy tax refund will be divided between electricity and natural gas in proportion to the average tax paid on electricity and natural gas consumption.

This ratio is calculated as follows:

  • The consumption-based tax on electricity and natural gas is calculated as the sum of the renewable energy tax (ODE) and the energy tax;
  • This consumption-based tax is multiplied by the average annual household consumption of electricity and natural gas;
  • The ratio between electricity and natural gas in the above sum is then determined. This ratio is applied to the tax credit in the following year.

For 2022, this leads to more than one-third of the refund being offset against the electricity bill and almost two-thirds against the natural gas bill. The incorporation of the tax credit is explained in more detail in CBS (2022).

3.3 Aggregation

This section explains the aggregation level of the index calculation.

3.3.1 Product definition

A price index is an indicator of the price development of a set of products, which can be defined at different levels of aggregation. At lower levels of aggregation, detailed distinctions between products are made, while at higher levels broader categories are used. A disadvantage of using very narrowly defined products is that some products are not sold in every period, leading to discontinuities that can cause the price index to become unstable. A disadvantage of using very broadly defined products is that, over time, there may be discrepancies between the products that are compared, leading to an undesirable loss of homogeneity. In defining products, there is thus a trade-off between continuity and homogeneity.

The MARS method provides a statistical approach to determining a product definition (Chessa, 2021a). This method selects price-determining characteristics and ignores non-price-determining characteristics in order to obtain as much data as possible per homogeneous product.

As electricity and natural gas are purchased by households through contracts with energy companies, the contracts are viewed as the purchased products. These products have several characteristics (see Section 2.3). For fixed-rate contracts, the delivery rate remains the same for the duration of the contract. The duration of a fixed-rate contract has a clear effect on the rate and is therefore also a quality determinant. Other characteristics can also determine price. MARS was used to investigate which contract features have the most significant impact in this context. Brand and contract duration were found to be the most important product characteristics when it comes to defining products. Thus, other characteristics, such as for electricity single versus double rates, and green versus grey, are not included in the product definition.

Using MARS and the data available in the datasets, the following classification was made for contract duration:

  • 0: duration of less than one year or indefinite (i.e. variable);
  • 1-2: duration between 1 and 2 years;
  • 3: duration between 2 and 3 years;
  • 4-5: duration of more than 3 years (usually 4 or 5).

This classification can be applied for all respondents.

3.3.2 Unit value aggregation of prices

As described above, a product definition delineated by brand and contract duration was chosen. Multiple contract types with the same brand and contract duration occur in the standardised transaction data. Different contract types for the same brand and with the same contract duration must first be aggregated before price indices can be calculated. This section explains how calculation prices and numbers of connections are aggregated.

Calculation prices are aggregated using the unit-value method, which means that the calculation price is calculated as an average of the calculation prices of the underlying contract types. This average is weighted by the number of connections: contract types with many connections are given a greater weight than contract types with fewer connections. For each record corresponding to one brand and one contract duration, the number of connections is derived as the sum of the numbers of connections of the underlying contract types.

3.4 The Geary-Khamis index 

The previous sections explained how individual contracts are aggregated into homogeneous products and how the corresponding prices are defined. Next is the aggregation of price changes across products, which is done in two steps. In line with standard CBS practice, price indices are first calculated per energy company. This is explained below. Subsequently, the price indices by respondent are aggregated into one index for electricity and one index for natural gas. Section 3.5 sets out how this is done.

3.4.1 Motivation

Several methods are available for calculating price indices per respondent (see for example Balk, 2008). Various index methods were considered for electricity and natural gas. These were compared based on their theoretical properties, simplicity, flexibility and compliance with international standards, on how well they fit the data, and on other criteria. In the end, the Geary-Khamis index was chosen, mostly because this is CBS’s standard method for transaction data. A more detailed motivation can be found in CBS (2023a)

3.4.2 Method

Below, the calculation of the Geary-Khamis index is discussed in more detail. This index is calculated according to the following formulas:
\[
P_t=\frac{\left(\sum_{i}p_{it}q_{it}\right)/\left(\sum_{i}\nu_{i}q_{it}\right)}{\left(\sum_{i}p_{i0}q_{i0}\right)/\left(\sum_{i}\nu_{i}q_{i0}\right)}
\]
and
\[
\nu_{i}=\sum_{t}\left(\frac{q_{it}}{\sum_{Z}q_{iZ}}*\:\frac{p_{it}}{P_{t}}\right)
\]
The index calculation requires prices pit and quantities qit, where i represents a product and t represents the period. Price is defined here as the calculation price of a contract for a specific brand with a specific contract duration for a specific month. The quantities qit are the corresponding numbers of connections.

In addition to the index itself, the index calculation Pt produces the implicit prices, vi. which are meant to correct for quality differences. As these are derived from the index calculation, they do not need to be specified. This is called an implicit quality correction. For electricity and natural gas, it is important to consider differences in quality. Contracts from different suppliers and with different durations are clearly subject to different price trends and are therefore not directly comparable.

If all vi's were equal, the method would be identical to a unit-value index, which is a simple method without quality correction. As the Geary-Khamis index can be viewed as an extension of the unit-value method (one that includes a quality correction), the method belongs to the class of quality-adjusted unit-value (QAUV) methods (Von Auer, 2014).

The price index Pt is calculated as the ratio of a turnover change \((\sum_{i}p_{it}q_{it})/(\sum_{i}p_{i0}q_{i0})\) and a volume change \((\sum_{i}\nu_{i}q_{it})/(\sum_{i}\nu_{i}q_{i0})\). Implicit prices vi are calculated as the weighted average of a product’s deflated prices.

The above two formulas for Pt and vi are dependent. The calculation of Pt depends on vi, and conversely vi depends on Pt. Usually, an iterative method is used to calculate Pt and vi. For a more detailed explanation of the Geary-Khamis index and how it is calculated, see Chessa (2016).

3.4.3 Application

This section discusses some of the choices made in applying the Geary-Khamis method.

In general, a distinction can be made between price index methods that calculate an index for two periods (months) and methods that calculate an index for a longer period. The former are called bilateral methods, the latter multilateral methods. Multilateral methods, which are increasingly gaining traction, have the advantage that the outcomes do not depend on the choice of the starting period. The Geary-Khamis method described above is a multilateral method.

To apply a multilateral method, several questions must be answered first. These include:

  • How long should the index series that are derived using Geary-Khamis be?
  • How should consecutive index series be linked together?
  • How should current year index series be created?
  • How is the index defined? (This has an impact on calculation prices).

These questions are answered below.

Index series length
In choosing an index series length, there is a trade-off between including enough prices on the one hand and correctly measuring short-term price changes on the other hand.

A disadvantage of short index series is that relatively few prices are used to create the indices. The implicit quality correction that is applied when using the Geary-Khamis method improves if more prices are available per product. To make an adequate estimate, prices from several periods are needed, and more prices means a longer index. A disadvantage of using long series is that short-term price changes may not be measured as accurately. In a multilateral index, price changes between any two periods are affected by all the periods included in the index calculation. In other words, the change from January to February is also influenced by August. To effectively calculate short-term price movements, index series should not be too long.

For the energy price index, 13-month index series were chosen. These index series start in December of the previous year and continue until the end of the current year. This is in line with standard practice, but there are also practical reasons for choosing this period.

Many elements that are used in the index calculation are set per calendar year, such as tax rates, average consumption and the weights used to combine the index series of electricity and natural gas with those of other products. It therefore makes sense to use annual index series, as this simplifies the calculations.

Linking index series over time
As explained above, it was decided to use 13-month annual index series. To arrive at one long, continuous index series, these annual index series need to be linked. How this is done is explained below.

Short index series start in December of the preceding year and continue until December of the current year at the latest.  Two indices are produced for the base month, December: one for the current calendar year’s series and one for next year’s.

Linking the annual series to create a long multi-year index series is done by applying a multiplicative level correction in December. Suppose, for example, that the current calendar year’s index series ends in December at 1.25 (or 125), and the new index series for the next year starts with 1.00 (or 100). By multiplying the new index series in its entirety by 1.25, it is aligned with the level of the old series. This is how the two indices for December are made equal.

Calculation of the index during the current year
In a given year, the index is calculated starting in December of the preceding year and continues to the current reporting month. The fact that the figures for the preceding months have already been published at the time of calculation, and that these may not be adjusted, presents a complication. For example, if the current reporting period is March, the index is calculated from December to March. In this index, the outcomes for January and February will usually differ from those published earlier. However, as figures that have already been published may not be adjusted, only the new figure for March is published.

The method described above is called the Fixed-Base Expanding Window (FBEW) method, where ‘Fixed-Base’ refers to the fact that the index always starts in a pre-determined base month (December), and ‘Expanding Window’ pertains to the index series getting longer with each passing month. FBEW is an extension method for linking index series over time. FBEW is not the only extension method that can be used, but it is highly useful for processing annual series with annually adjustable parameters, such as average energy consumption. A detailed description of extension methods can be found in Chessa (2021b).

Determining the calculation prices for the base period
As explained above, annual index series comprise 13 months. The first month is December of the preceding year, which is used to link the current, new annual series to the previous index series. Along with the annual base shift, we also update annual consumption according to the latest estimates. This has the following implications for the calculation of the base month:

  • For all 13 months, including December of the preceding year, the current year’s ‘standard’ consumption is applied;
  • For households with dual electricity meters, the ratio between the off-peak and standard rates remains the same over the 13 months. The current year’s ratio is also used for December of the preceding year.

The calculation of the tax credit deserves special attention. For December of the preceding year, the total discount for that year is used, but for subsequent months the total discount is that of the current year. The distribution of the discount between electricity and natural gas is that of the current year for all 13 months. This means that the distribution of the tax credit in December of the preceding year is corrected to align with that of the current year.

This way, the change in the total tax credit is included in the price index, as this is a real change in households’ energy bills. However, as the distribution is kept the same for December- to- January, potential shifts in the distribution of the tax credit between electricity and natural gas will not affect the index.

3.5 Aggregation of energy companies and of electricity and natural gas in the CPI

As explained in the previous section, index series for electricity and natural gas are first created for each individual respondent. These series are then aggregated to arrive at indices for electricity and natural gas for all respondents, which can in turn be aggregated with the index series of the other COICOPs, for example to arrive at the total CPI for all household expenditures. This section explains how this is done.

Index series can be combined by applying weighting. This means that different indices are multiplied by weights to produce an aggregate index. The weights are set at the beginning of the year and remain fixed for twelve months, in accordance with the Laspeyres index.

The aggregation weights for the respondents’ indices are derived from the electricity and natural gas suppliers’ market shares in the base month. These turnover fractions are based on the calculation prices and the numbers of contracts listed in the transaction data. The aggregation weights for product groups are derived from the consumption shares (final expenditure) of the relevant product groups in the national accounts. Within the CPI, a weighting scheme is used for this, with weights adding up to 100,000. In this scheme, electricity and natural gas have weightings of 2,627 and 3,013, respectively (2022). For more information on this, see CBS (2023b) and Eurostat (2018).

As the weighting factors change annually, the weighting is performed on the short 13-month index series. The aggregation across products (using Geary-Khamis) and respondents (using Laspeyres) precedes linking the index series over time, as explained in Section 3.4.3 under ‘Linking index series over time’.

3.6 Other aspects

This section describes relevant aspects of the new method’s application that have not yet been discussed.

3.6.1 Index series by subpopulation: by respondent or by contract duration

Using Geary-Khamis, index series for specific subpopulations can be calculated – for instance by respondent or contract duration – based on the selected microdata.

In Section 5.1, the index series are specified by contract duration (see annex, Chapter 5). It shows that variable-rate contracts increased the most in price, while long-term fixed-rate contracts increased the least. The latter are mostly contracts signed before the major price increases from mid-2021. The index for long-term contracts actually fell slightly due to the government’s tax measures.

3.6.2 Derived series

In addition to the standard publications of consumer price indices, derived series are also published. These are price index series that exclude the effect of changes in the rates of product-related taxes (such as VAT and excise duties on alcohol and tobacco) and subsidies, and of consumption-related taxes (such as the motor vehicle tax). In the derived series for electricity and natural gas, taxes and charges remain constant throughout the year, equal to the values in December of the preceding year (as with consumption).

The following factors remain constant:

  • Renewable energy tax (ODE);
  • Energy tax;
  • Tax credit (‘energy tax refund’);
  • VAT.

The following factors are variable:

  • Rate per kWh or m3;
  • Transport rate;
  • Standing charge.

The derived series are created by making the above adjustments to the microdata when determining the calculation price, as explained in Section 3.2. As with the standard series, the price cap is also included in the derived series.

For the derived series, see Section 5.2. These show that the derived series for electricity and natural gas are higher than the standard series. This is mainly due to the increase in the tax credit in January 2022 compared to December 2021, which is reflected in the standard series but not in the derived series. In January 2023, the tax credit decreased, but the effect of this was less significant.

From July 2022 to December 2022, VAT on energy was reduced from 21% to 9%. This tax reduction has been included in the standard series but not in the derived series. However, the effect of omitting the tax reduction from the derived series turned out to be limited compared to the effect of the variable components that have been included.

3.6.3 Switching to the new method

In June 2023, there was a switch from the old method (using ACM data) to the new method (using transaction data).

The figures up to May 2023 have not been adjusted as part of the transition; they are the outcomes produced by the old method. Switching methods can be done in several ways. In this case, arriving at an accurate long-term level had top priority, which is why an annual-overlap method was chosen. This method ensures that the long-term price index will be at about the same level as if the new method had already been introduced in 2020, before energy prices started to rise.

As a result, price increases are not counted twice. As price developments for new contracts have a delayed impact on existing contracts, the old method is ahead of the new one. Price increases that have already been accounted for by the old method should not be included again after the switch to the new method.

The annual-overlap method is explained in more detail below. The indices that were published until May 2023 were created using the old method; the ones published from June 2023 are based on the new method. These new indices are multiplied by a correction factor to align them with the old index. This factor is calculated by dividing the average level of the old index over the 12 months of 2020 by the average level of the new index.

Figures in the annex Section 5.3 illustrate how the switching method would have been used if it had been applied from April 2023 (a hypothetical scenario). Until March 2023, the old method is used. After that, the index series mostly follows the new method.

3.6.4 Alternative index methods

Besides the Geary-Khamis index method, several alternative index methods for energy transaction data have been explored, including the unit-value index. This is a simple method that measures the development of the average calculation price weighted using the number of contracts. Unit-value indices were calculated for electricity and natural gas, without differentiating by contract type and respondent.

Figures in Section 5.4 show that these unit-value indices are higher than the Geary-Khamis indices for electricity, natural gas and all expenditures. This is reflected not only in the indices, but also in the year-on-year changes for those indices (see Figures in Section 5.5). There is a logical explanation for this. In 2022, many households saw their fixed-term contracts expire. As virtually no new fixed-term contracts were offered in 2022, these households were then forced to switch to new variable-rate contracts. While the associated price increases are included in the unit-value index, they are not directly reflected in the Geary-Khamis index. The unit-value index calculates the average price across all contracts, which increases when cheap fixed-term contracts are replaced by expensive variable-rate contracts. The effects of this are less significant in the Geary-Khamis indices because of the quality correction that is applied.

Geary-Khamis is applied in production because it is more sophisticated than the unit-value method. As the analysis above shows, comparing methods can provide new insights. The intention is therefore to calculate a unit-value index in addition to the Geary-Khamis index, for internal evaluation.

4. References

Balk, B.M. (2008) Price and Quantity Index Numbers. Cambridge University Press, New York. http://dx.doi.org/10.1017/CBO9780511720758.

CBS (2022). Wijziging van de behandeling van de teruggave energiebelasting in de CPI, web article, https://www.cbs.nl/nl-nl/longread/rapportages/2022/wijziging-van-de-behandeling-van-de-teruggave-energiebelasting-in-de-cpi.

CBS (2023a). Choice of an Index Method for Consumer Energy Prices, web article, https://www.cbs.nl/en-gb/longread/diversen/2023/choice-of-an-index-method-for-consumer-energy-prices?onepage=true.

CBS (2023b). Achtergronden bij de wegingen van 2023 (cbs.nl).

Chessa, A.G. (2016). A new methodology for processing scanner data in the Dutch CPI. Eurona, 1, pp. 49-69.

Chessa, A.G. (2021a). A Product Match Adjusted R Squared Method for Defining Products with Transaction Data, Journal of Official Statistics, 37, pp. 411-432.

Chessa, A.G. (2021b). Extension of multilateral index series over time: Analysis and comparison of methods. Paper presented at the Meeting of the Group of Experts on Consumer Price Indices, 2-10 June 2021 (online). https:// unece.org/sites/default/files/2021-05/Session_1_Netherlands_Paper.pdf.

Eurostat (2018). Harmonised Index of Consumer Prices (HICP) methodological manual — 2018 edition - Products Manuals and Guidelines - Eurostat (europa.eu) EUR-Lex - 31995R2494 - EN - EUR-Lex (europa.eu).

Eurostat (2023). Quality - Harmonised Indices of Consumer Prices (HICP) - Eurostat (europa.eu).

PBL Netherlands Environmental Assessment Agency (2023). Scenario gemiddeld energieverbruik per woning in 2022 en 2023 (www.pbl.nl).

Von Auer, L. (2014). The Generalized Unit-value Index Family. Review of Income and Wealth, 60, pp. 843-861. DOI: https://doi.org/10.1111/roiw.12042.

5. Annex: results

5.1 Index series by contract duration

Geary-Khamis index by contract duration for electricity
JaarmGK_FBEW_lpt0_ElekGK_FBEW_lpt1_2_ElekGK_FBEW_lpt3_ElekGK_FBEW_lpt4_5_Elek
2020January1111
2020February10.991.011
2020March10.991.011
2020April10.981.011
2020May0.990.971.021
2020June0.990.961.021
2020July0.960.951.021
2020August0.960.951.021
2020September0.960.941.021
2020Oktober0.960.931.021
2020November0.960.931.021
2020December0.960.931.021
2021January0.890.870.970.94
2021February0.880.860.970.95
2021March0.880.860.970.95
2021April0.880.870.980.95
2021May0.890.870.980.95
2021June0.890.890.980.96
2021July0.980.90.990.97
2021August0.980.9210.97
2021September0.990.9410.98
2021Oktober10.971.010.99
2021November1.061.021.021
2021December1.121.071.031
2022January0.960.730.640.62
2022February10.810.650.63
2022March10.890.650.63
2022April1.060.960.660.63
2022May1.11.010.660.63
2022June1.111.070.660.63
2022July1.141.030.60.57
2022August1.181.090.610.57
2022September1.281.140.620.57
2022Oktober1.541.180.620.57
2022November2.111.230.630.57
2022December2.111.471.010.65
2023January2.031.661.161.01
2023February21.691.161.01
2023March1.971.721.161.01
2023April1.841.681.171.01
2023May1.81.651.171.01

Explanation: the Geary-Khamis index by contract duration (0, 1-2, 3 or 4-5 years, see Section 3.3.1) for electricity, calculated using the Fixed-Base Expanding Window (FBEW) extension method (Jan 2020=1). The respondents have been aggregated by contract duration. The series for individual respondents are not shown here for privacy reasons.

Geary-Khamis index by contract duration for natural gas
JaarmGK_FBEW_lpt1_2_GasGK_FBEW_lpt0_GasGK_FBEW_lpt3_GasGK_FBEW_lpt4_5_Gas
2020January1111
2020February0.99111
2020March0.98111
2020April0.98111
2020May0.97111
2020June0.97111
2020July0.960.9511
2020August0.960.950.990.99
2020September0.950.950.990.99
2020Oktober0.950.950.990.99
2020November0.940.950.990.99
2020December0.940.950.990.99
2021January0.970.961.021.02
2021February0.960.961.021.02
2021March0.960.961.021.02
2021April0.960.961.021.02
2021May0.970.961.021.02
2021June0.970.971.021.02
2021July0.980.991.021.02
2021August0.990.991.021.02
2021September111.021.02
2021Oktober1.0111.021.02
2021November1.041.041.031.03
2021December1.071.081.031.03
2022January0.981.250.870.87
2022February1.081.310.880.88
2022March1.191.320.880.88
2022April1.291.430.890.88
2022May1.361.490.890.87
2022June1.451.510.890.88
2022July1.411.630.810.79
2022August1.51.660.820.79
2022September1.581.810.830.79
2022Oktober1.642.180.840.79
2022November1.712.860.850.79
2022December1.762.860.850.79
2023January1.862.061.311.27
2023February1.862.021.311.27
2023March1.851.991.311.27
2023April1.811.821.321.27
2023May1.761.751.321.27
  

Explanation: the Geary-Khamis index by contract duration (0, 1-2, 3 or 4-5 years, see Section 3.3.1) for natural gas, calculated using the Fixed-Base Expanding Window (FBEW) extension method (Jan 2020=1). The respondents have been aggregated by contract duration.

5.2 Derived series

Derived index series for electricity
JaarmGK_pb_Elek_afgGK_FBEW_ps_Elek_afgGK_pb_Elek
2020January111
2020February111
2020March111
2020April111
2020May111
2020June110.99
2020July0.990.990.98
2020August0.980.980.98
2020September0.980.980.97
2020Oktober0.980.980.97
2020November0.980.980.97
2020December0.980.980.97
2021January1.021.020.91
2021February1.021.020.91
2021March1.021.020.91
2021April1.021.020.91
2021May1.031.030.91
2021June1.031.030.92
2021July1.081.080.97
2021August1.091.090.98
2021September1.11.10.98
2021Oktober1.111.111
2021November1.151.151.04
2021December1.21.21.08
2022January1.361.360.82
2022February1.41.40.86
2022March1.411.410.87
2022April1.461.460.91
2022May1.491.490.94
2022June1.511.510.96
2022July1.631.630.95
2022August1.661.660.98
2022September1.741.741.05
2022Oktober1.961.951.22
2022November2.452.431.62
2022December2.542.531.69
2023January1.91.891.7
2023February1.871.861.68
2023March1.841.831.66
2023April1.721.721.58
2023May1.71.691.55

Explanation: the derived Geary-Khamis series for electricity with intermediate step per respondent (“GK_pb_Elek_afg”) and without intermediate step per respondent (“GK_FBEW_ps_Elek_afg”), and the standard (non-derived) Geary-Khamis series for electricity (“GK_pb_Elek”) (Jan 2020=1).

Derived index series for natural gas
JaarmGK_pb_GasGK_pb_Gas_afgGK_FBEW_ps_Gas_afg
2020January111
2020February111
2020March111
2020April10.990.99
2020May0.990.990.99
2020June0.990.990.99
2020July0.970.970.97
2020August0.970.960.96
2020September0.960.960.96
2020Oktober0.960.960.96
2020November0.960.960.96
2020December0.960.960.96
2021January0.980.950.95
2021February0.980.950.95
2021March0.980.950.95
2021April0.980.950.95
2021May0.980.950.95
2021June0.980.950.95
2021July10.970.97
2021August10.970.97
2021September1.010.970.97
2021Oktober1.010.980.98
2021November1.041.011.01
2021December1.061.031.03
2022January1.091.221.22
2022February1.141.261.27
2022March1.161.291.29
2022April1.231.361.36
2022May1.281.41.4
2022June1.31.421.42
2022July1.351.611.61
2022August1.381.641.64
2022September1.471.751.75
2022Oktober1.722.022.01
2022November2.192.532.5
2022December2.22.542.5
2023January1.751.531.51
2023February1.731.51.48
2023March1.71.481.46
2023April1.591.361.34
2023May1.541.31.28
 

Explanation: the derived Geary-Khamis series for natural gas with intermediate step per respondent (“GK_pb_Gas_afg”) and without intermediate step per respondent (“GK_FBEW_ps_Gas_afg”), and the standard (non-derived) Geary-Khamis series for natural gas (“GK_pb_Gas”) (Jan 2020=1).

Derived index series for all expenditures
JaarmGK_pb_All_afgGK_FBEW_ps_All_afgGK_pb_All
2020January1.0001.0001.000
2020February1.0071.0071.007
2020March1.0091.0091.009
2020April1.0141.0141.014
2020May1.0131.0131.013
2020June1.0161.0161.016
2020July1.0271.0271.027
2020August1.0211.0211.021
2020September1.0191.0191.019
2020Oktober1.0241.0241.024
2020November1.0161.0161.016
2020December1.0181.0181.018
2021January1.0161.0161.016
2021February1.0251.0241.025
2021March1.0271.0271.027
2021April1.0311.0311.031
2021May1.0321.0321.032
2021June1.0341.0331.034
2021July1.0381.0381.038
2021August1.0421.0421.042
2021September1.0411.0411.041
2021Oktober1.0501.0491.050
2021November1.0511.0511.051
2021December1.0541.0531.054
2022January1.0641.0481.064
2022February1.0761.0601.076
2022March1.0861.0701.086
2022April1.1001.0841.100
2022May1.1061.0901.106
2022June1.1131.0981.113
2022July1.1321.1091.132
2022August1.1381.1151.138
2022September1.1451.1211.145
2022Oktober1.1691.1441.170
2022November1.1911.1651.193
2022December1.1991.1731.201
2023January1.1831.1691.184
2023February1.1961.1821.197
2023March1.1991.1851.201
2023April1.2101.1951.211

Explanation: the derived Geary-Khamis series for all expenditures with intermediate step per respondent (“GK_pb_All_afg”) and without intermediate step per respondent (“GK_FBEW_ps_All_afg”), and the standard (non-derived) Geary-Khamis series for electricity (“GK_pb_All”) (Jan 2020=1).

5.3 Series including a method switch

The charts below show the annual-overlap results for a hypothetical switch in April 2023, along with the corresponding year-on-year changes. However, the actual switch happened in June 2023, so the charts look different in practice.

Method switch for electricity
JaarmPub_ElekGK_pb_ElekOv_ao_Elek
2020January111
2020February0.9910.99
2020March0.9810.98
2020April0.9610.96
2020May0.9510.95
2020June0.940.990.94
2020July0.940.980.94
2020August0.940.980.94
2020September0.950.970.95
2020Oktober0.950.970.95
2020November0.960.970.96
2020December0.960.970.96
2021January0.910.910.91
2021February0.940.910.94
2021March0.950.910.95
2021April0.970.910.97
2021May0.970.910.97
2021June10.921
2021July1.090.971.09
2021August1.10.981.1
2021September1.180.981.18
2021Oktober1.3311.33
2021November1.681.041.68
2021December1.951.081.95
2022January1.920.821.92
2022February1.830.861.83
2022March2.690.872.69
2022April2.470.912.47
2022May2.120.942.12
2022June20.962
2022July2.350.952.35
2022August2.740.982.74
2022September3.41.053.4
2022Oktober3.471.223.47
2022November2.851.622.85
2022December2.821.692.82
2023January2.171.72.17
2023February2.11.682.1
2023March2.031.662.03
2023April2.061.581.53
2023MayNA1.551.51
 

Explanation: switch with annual-overlap (“ao_”) for electricity. The switch series (“Ov_ao_Elek”) coincides with the published series (“Pub_Elek”) until the month of the switch. From that month onwards, the switch series (“Ov_ao_Elek”) roughly coincides with the transaction data index (“GK_pb_Elek”).

Method switch for natural gas
JaarmGK_pb_GasOv_ao_GasPub_Gas
2020January111
2020February10.990.99
2020March10.980.98
2020April10.970.97
2020May0.990.970.97
2020June0.990.960.96
2020July0.970.940.94
2020August0.970.940.94
2020September0.960.940.94
2020Oktober0.960.950.95
2020November0.960.950.95
2020December0.960.950.95
2021January0.980.980.98
2021February0.980.990.99
2021March0.9811
2021April0.9811
2021May0.9811
2021June0.981.011.01
2021July11.051.05
2021August11.071.07
2021September1.011.121.12
2021Oktober1.011.231.23
2021November1.041.451.45
2021December1.061.581.58
2022January1.091.821.82
2022February1.141.741.74
2022March1.162.62.6
2022April1.232.412.41
2022May1.282.12.1
2022June1.31.851.85
2022July1.352.262.26
2022August1.382.892.89
2022September1.473.673.67
2022Oktober1.723.693.69
2022November2.192.532.53
2022December2.22.532.53
2023January1.751.471.47
2023February1.731.391.39
2023March1.71.321.32
2023April1.591.561.27
2023May1.541.51NA

Explanation: switch with annual-overlap (“ao_”) for natural gas. Until the month of the switch, the published series (“Pub_Gas”) coincides with the switch series (“Ov_ao_Gas”). From that month onwards, the switch series (“Ov_ao_Gas”) roughly coincides with the transaction data index (“GK_pb_Gas”).

Method switch for all expenditures
JaarmGK_pb_AllOv_ao_AllPub_All
2020January111
2020February1.0071.0061.006
2020March1.0091.0081.008
2020April1.0141.0131.013
2020May1.0131.0111.011
2020June1.0161.0151.015
2020July1.0271.0261.026
2020August1.0211.0201.020
2020September1.0191.0181.018
2020Oktober1.0241.0241.024
2020November1.0161.0151.015
2020December1.0181.0181.018
2021January1.0161.0161.016
2021February1.0241.0251.025
2021March1.0271.0271.027
2021April1.0311.0321.032
2021May1.0321.0331.033
2021June1.0331.0351.035
2021July1.0381.0401.040
2021August1.0421.0451.045
2021September1.0411.0461.046
2021Oktober1.0491.0591.059
2021November1.0511.0681.068
2021December1.0531.0761.076
2022January1.0481.0811.081
2022February1.0601.0881.088
2022March1.0701.1271.127
2022April1.0841.1311.131
2022May1.0901.1231.123
2022June1.0981.1241.124
2022July1.1091.1471.147
2022August1.1151.1701.170
2022September1.1211.1971.197
2022Oktober1.1441.2101.210
2022November1.1651.1731.173
2022December1.1731.1791.179
2023January1.1691.1631.163
2023February1.1821.1741.174
2023March1.1851.1771.177
2023April1.1951.1941.189
2023May

Explanation: switch with annual-overlap (“ao_”) for all expenditures. Until the month of the switch, the published series (“Pub_All”) coincides with the switch series (“Ov_ao_All”). From that month onwards, the switch series (“Ov_ao_All”) roughly coincides with the transaction data index (“GK_pb_All”).

Year-on-year change with method switch for electricity
Jaarmjm_GK_pb_Elekjm_Pub_Elekjm_Ov_ao_Elek
2021January0.910.910.91
2021February0.910.950.95
2021March0.910.980.98
2021April0.911.011.01
2021May0.921.031.03
2021June0.921.061.06
2021July0.991.161.16
2021August11.161.16
2021September1.011.241.24
2021Oktober1.021.41.4
2021November1.071.751.75
2021December1.112.042.04
2022January0.92.112.11
2022February0.951.941.94
2022March0.962.822.82
2022April12.562.56
2022May1.032.182.18
2022June1.0422
2022July0.992.172.17
2022August1.012.52.5
2022September1.072.882.88
2022Oktober1.232.622.62
2022November1.561.71.7
2022December1.561.441.44
2023January2.071.131.13
2023February1.961.151.15
2023March1.910.760.76
2023April1.720.830.62
2023May1.65NA0.71

Explanation: the annual-overlap year-on-year changes (“jm_Ov_ao_Elek”) coincide with those of the published series (“jm_Pub_Elek”) until the month of the switch. From that month onwards, there is no clear interpretation for the year-on-year changes of the switch series (“jm_Ov_ao_Elek”). They clearly do not coincide with the year-on-year changes of the new transaction data index (“jm_GK_pb_Elek”), as the year-on-year changes of the switch series compare an index from the new method with a figure from the old method.

Year-on-year change with method switch for natural gas
jaarmjm_GK_pb_Gasjm_Ov_ao_Gasjm_Pub_Gas
2021January0.980.980.98
2021February0.980.990.99
2021March0.981.011.01
2021April0.991.031.03
2021May0.991.031.03
2021June0.991.051.05
2021July1.031.121.12
2021August1.041.131.13
2021September1.041.181.18
2021Oktober1.051.311.31
2021November1.081.531.53
2021December1.11.661.66
2022January1.111.861.86
2022February1.161.761.76
2022March1.182.612.61
2022April1.262.412.41
2022May1.32.092.09
2022June1.321.831.83
2022July1.352.142.14
2022August1.372.72.7
2022September1.473.293.29
2022Oktober1.72.992.99
2022November2.121.741.74
2022December2.081.61.6
2023January1.610.810.81
2023February1.520.80.8
2023March1.470.510.51
2023April1.280.650.53
2023May1.20.72NA

Explanation: the year-on-year changes of the switch series (“jm_Ov_ao_Gas”) coincide with those of the published series (“jm_Pub_Gas”) until the month of the switch.

From that month onwards, there is no clear interpretation for the year-on-year changes of the switch series (“jm_Ov_ao_Gas”). They clearly do not coincide with the year-on-year changes of the new transaction data index (“jm_GK_pb_Gas”), as the year-on-year changes of the switch series compare an index from the new method with a figure from the old method.

Method switch for all expenditures
JaarmGK_pb_AllOv_ao_AllPub_All
2020January111
2020February1.0071.0061.006
2020March1.0091.0081.008
2020April1.0141.0131.013
2020May1.0131.0111.011
2020June1.0161.0151.015
2020July1.0271.0261.026
2020August1.0211.0201.020
2020September1.0191.0181.018
2020Oktober1.0241.0241.024
2020November1.0161.0151.015
2020December1.0181.0181.018
2021January1.0161.0161.016
2021February1.0241.0251.025
2021March1.0271.0271.027
2021April1.0311.0321.032
2021May1.0321.0331.033
2021June1.0331.0351.035
2021July1.0381.0401.040
2021August1.0421.0451.045
2021September1.0411.0461.046
2021Oktober1.0491.0591.059
2021November1.0511.0681.068
2021December1.0531.0761.076
2022January1.0481.0811.081
2022February1.0601.0881.088
2022March1.0701.1271.127
2022April1.0841.1311.131
2022May1.0901.1231.123
2022June1.0981.1241.124
2022July1.1091.1471.147
2022August1.1151.1701.170
2022September1.1211.1971.197
2022Oktober1.1441.2101.210
2022November1.1651.1731.173
2022December1.1731.1791.179
2023January1.1691.1631.163
2023February1.1821.1741.174
2023March1.1851.1771.177
2023April1.1951.1941.189

Explanation: the year-on-year changes of the switch series (“jm_Ov_ao_All”) coincide with those of the published series (“jm_Pub_All”) until the month of the switch. From that month onwards, there is no clear interpretation for the year-on-year changes of the switch series (“jm_Ov_ao_All”). They clearly do not coincide with the year-on-year changes of the new transaction data index (“jm_GK_pb_All”), as the year-on-year changes of the switch series compare an index from the new method with a figure from the old method.

5.4 Geary-Khamis and unit-value indices

Geary-Khamis and unit-value indices for electricity
JaarmPub_Elekuv_index_ElekGK_pb_Elek
2020January111
2020February0.9911
2020March0.9811
2020April0.9611
2020May0.9511
2020June0.940.990.99
2020July0.940.980.98
2020August0.940.970.98
2020September0.950.970.97
2020Oktober0.950.970.97
2020November0.960.970.97
2020December0.960.970.97
2021January0.910.910.91
2021February0.940.910.91
2021March0.950.910.91
2021April0.970.910.91
2021May0.970.910.91
2021June10.920.92
2021July1.090.970.97
2021August1.10.980.98
2021September1.180.990.98
2021Oktober1.3311
2021November1.681.041.04
2021December1.951.091.08
2022January1.920.830.82
2022February1.830.880.86
2022March2.690.890.87
2022April2.470.940.91
2022May2.120.980.94
2022June210.96
2022July2.3510.95
2022August2.741.040.98
2022September3.41.121.05
2022Oktober3.471.31.22
2022November2.851.731.62
2022December2.821.821.69
2023January2.171.851.7
2023February2.11.831.68
2023March2.031.821.66
2023April2.061.731.58
2023MayNA1.71.55

Explanation: “Pub” is the published index for electricity based on ACM data, “uv” is the unit-value index based on transaction data, “GK_pb” is the Geary-Khamis index based on transaction data, with the series calculated by respondent (“pb”) as an intermediate step.

Geary-Khamis and unit-value indices for natural gas
Jaarmuv_index_GasGK_pb_GasPub_Gas
2020January111
2020February110.99
2020March110.98
2020April0.9910.97
2020May0.990.990.97
2020June0.990.990.96
2020July0.970.970.94
2020August0.960.970.94
2020September0.960.960.94
2020Oktober0.960.960.95
2020November0.960.960.95
2020December0.960.960.95
2021January0.980.980.98
2021February0.980.980.99
2021March0.980.981
2021April0.980.981
2021May0.980.981
2021June0.980.981.01
2021July111.05
2021August111.07
2021September11.011.12
2021Oktober1.011.011.23
2021November1.041.041.45
2021December1.061.061.58
2022January1.11.091.82
2022February1.161.141.74
2022March1.191.162.6
2022April1.271.232.41
2022May1.321.282.1
2022June1.351.31.85
2022July1.411.352.26
2022August1.441.382.89
2022September1.561.473.67
2022Oktober1.821.723.69
2022November2.332.192.53
2022December2.342.22.53
2023January1.891.751.47
2023February1.871.731.39
2023March1.851.71.32
2023April1.731.591.27
2023May1.671.54NA

Explanation: “Pub” is the published index for natural gas based on ACM data, “uv” is the unit-value index based on transaction data, “GK_pb” is the Geary-Khamis index based on transaction data, with the series calculated by respondent (“pb”) as an intermediate step.

Geary-Khamis and unit-value indices for all expenditures
Jaarmuv_index_AllGK_pb_AllPub_All
2020January111
2020February1.011.011.01
2020March1.011.011.01
2020April1.011.011.01
2020May1.011.011.01
2020June1.021.021.01
2020July1.031.031.03
2020August1.021.021.02
2020September1.021.021.02
2020Oktober1.021.021.02
2020November1.021.021.02
2020December1.021.021.02
2021January1.021.021.02
2021February1.021.021.02
2021March1.031.031.03
2021April1.031.031.03
2021May1.031.031.03
2021June1.031.031.03
2021July1.041.041.04
2021August1.041.041.04
2021September1.041.041.05
2021Oktober1.051.051.06
2021November1.051.051.07
2021December1.051.051.08
2022January1.051.051.08
2022February1.061.061.09
2022March1.071.071.13
2022April1.091.081.13
2022May1.091.091.12
2022June1.11.11.12
2022July1.111.111.15
2022August1.121.111.17
2022September1.131.121.2
2022Oktober1.151.141.21
2022November1.171.161.17
2022December1.181.171.18
2023January1.181.171.16
2023February1.191.181.17
2023March1.191.191.18
2023April1.21.191.19
2023May

Explanation: the unit-value and Geary-Khamis series of electricity and natural gas are combined here with the series of the other (non-energy) product groups within household spending, to create an index for all expenditures: the CPI. The unpublished series for the other product groups was derived from the published series for all expenditures, electricity and natural gas.

5.5 Geary-Khamis and unit-value: year-on-year changes

Year-on-year change Geary-Khamis and unit-value indices for electricity
Jaarmjm_uv_index_Elekjm_GK_pb_Elekjm_Pub_Elek
2021January0.910.910.91
2021February0.910.910.95
2021March0.910.910.98
2021April0.910.911.01
2021May0.920.921.03
2021June0.930.921.06
2021July0.990.991.16
2021August111.16
2021September1.011.011.24
2021Oktober1.031.021.4
2021November1.071.071.75
2021December1.121.112.04
2022January0.920.92.11
2022February0.970.951.94
2022March0.980.962.82
2022April1.0412.56
2022May1.071.032.18
2022June1.091.042
2022July1.030.992.17
2022August1.061.012.5
2022September1.131.072.88
2022Oktober1.31.232.62
2022November1.661.561.7
2022December1.671.561.44
2023January2.222.071.13
2023February2.081.961.15
2023March2.041.910.76
2023April1.831.720.83
2023May1.741.65NA

Explanation: the year-on-year changes (“jm_”) of the Geary-Khamis, unit-value and published (“Pub”) series for electricity.

Year-on-year change Geary-Khamis and unit-value indices for natural gas
Jaarmjm_uv_index_Gasjm_GK_pb_Gasjm_Pub_Gas
2021January0.980.980.98
2021February0.980.980.99
2021March0.980.981.01
2021April0.980.991.03
2021May0.990.991.03
2021June0.990.991.05
2021July1.031.031.12
2021August1.041.041.13
2021September1.041.041.18
2021Oktober1.051.051.31
2021November1.081.081.53
2021December1.11.11.66
2022January1.121.111.86
2022February1.181.161.76
2022March1.211.182.61
2022April1.291.262.41
2022May1.351.32.09
2022June1.371.321.83
2022July1.411.352.14
2022August1.441.372.7
2022September1.551.473.29
2022Oktober1.81.72.99
2022November2.252.121.74
2022December2.212.081.6
2023January1.721.610.81
2023February1.611.520.8
2023March1.561.470.51
2023April1.361.280.53
2023May1.261.2NA

Explanation: the year-on-year changes (“jm_”) of the Geary-Khamis, unit-value and published (“Pub”) series for natural gas.

Year-on-year change Geary-Khamis and unit-value indices for all expenditures
Jaarmjm_uv_index_Alljm_GK_pb_Alljm_Pub_All
2021January1.021.021.02
2021February1.021.021.02
2021March1.021.021.02
2021April1.021.021.02
2021May1.021.021.02
2021June1.021.021.02
2021July1.011.011.01
2021August1.021.021.02
2021September1.021.021.03
2021Oktober1.021.021.03
2021November1.031.031.05
2021December1.031.031.06
2022January1.031.031.06
2022February1.041.041.06
2022March1.041.041.1
2022April1.051.051.1
2022May1.061.061.09
2022June1.061.061.09
2022July1.071.071.1
2022August1.071.071.12
2022September1.081.081.15
2022Oktober1.11.091.14
2022November1.111.111.1
2022December1.121.111.1
2023January1.121.121.08
2023February1.121.111.08
2023March1.111.111.04
2023April1.111.11.05
2023May

Explanation: the year-on-year changes (“jm_”) of the Geary-Khamis, unit-value and published (“Pub”) series for all expenditures (CPI).