Energy Data Management and Compilation Overview
6
t
h
O
S
L
O
G
r
o
u
p
M
e
e
t
i
n
g
E
n
e
r
g
y
B
a
l
a
n
c
e
s
C
o
m
p
i
l
a
t
i
o
n
(
S
A
)
R
o
b
e
r
t
K
w
i
n
d
a
S
u
b
-
D
i
r
:
E
n
e
r
g
y
D
a
t
a
Q
u
a
l
i
t
y
a
n
d
I
n
t
e
g
r
i
t
y
D
a
t
a
M
a
n
a
g
e
m
e
n
t
D
a
t
a
c
o
l
l
e
c
t
e
d
.
E
l
e
c
t
r
i
c
i
t
y
D
a
t
a
Local generation (ESKOM owned, IPP’s and Self Generating)
Imports and Exports (SARS)
Electricity used by refineries(Oil Companies) and coal mines(DMR)
Final consumption of Electricity by Sector (NERSA, ESKOM, IPP’s)
C
r
u
d
e
O
i
l
a
n
d
P
e
t
r
o
l
e
u
m
d
a
t
a
Importation and Exportation of Oil and petroleum products (SARS);
Oil used in refineries and transformation output (SAPIA, Oil Companies)
Final Consumption of Petroleum products by sector (SAPIA, Oil Companies, etc)
C
o
a
l
Local production (DMR)
Imports and Exports (SARS)
Transformation: Electricity Gen and liquefaction (ESKOM, Oil companies)
Final Consumption of coal by Sector (DMR, StatsSA, Research Studies, etc)
D
a
t
a
M
a
n
a
g
e
m
e
n
t
D
a
t
a
c
o
l
l
e
c
t
e
d
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
C
o
n
t
.
G
a
s
D
a
t
a
Local production (SASOL, PetroSA and Others)
Imports and Exports (SARS)
Transformation(Gas works Gas and Liquefaction) (Gas Refining companies)
Final consumption of Gas by Sector (Gas Refining companies, LPG
Association and other sector organisation)
N
u
c
l
e
a
r
,
H
y
d
r
o
,
S
o
l
a
r
a
n
d
R
e
n
e
w
a
b
l
e
s
D
a
t
a
Some data extracted from research studies and related papers.
More formal sources being identified.
D
a
t
a
M
a
n
a
g
e
m
e
n
t
D
a
t
a
c
o
l
l
e
c
t
i
o
n
m
e
t
h
o
d
s
.
Data provided to the Department via Email and fax and mostly on excel
format
Formal agreements with data providers entered into.
Data provided to the Department on pre-defined periodic basis.
Currently, there is scientific/ probability based data collection as all identified
data providers are requested to provide data to the Minister.
Regulations on the Provision of Energy Data (Driven from the National
Energy Act of 1998)
D
a
t
a
M
a
n
a
g
e
m
e
n
t
D
a
t
a
p
r
e
p
a
r
a
t
i
o
n
Data is received and captured in the commodity flow spreadsheet in native
units as well as in the Energy database.
The commodity flow spreadsheet is imported into the Energy Database and in
the process, the native units are converted into a single unit (TJ). This
becomes the Basic file
The aggregated and the disaggregated files are also created during the
importation process.
D
a
t
a
M
a
n
a
g
e
m
e
n
t
D
a
t
a
Q
u
a
l
i
t
y
C
o
n
t
r
o
l
C
o
m
p
u
t
e
r
S
y
s
t
e
m
b
a
s
e
d
.
.
.
Comparisons of current figures with historical data to identify obvious outliers.
Built-in conversion functionality in the database.
Built-in functionality to detect when a wrong is attached to a figure.
Built-in functionality to detect unrealistic statistical difference.
Final consumption of Gas by Sector (Gas Refining companies, LPG
Association and other sector organisation)
N
o
n
C
o
m
p
u
t
e
r
b
a
s
e
d
.
.
.
Internal Review by relevant sections within the Department.
Review by External stakeholders, including data providers and industry
experts.
The Minister to be requested to approve the revision of some of our data by the
IEA.
An Energy Statistics Review Team has been established to review the Energy
Balances from time tom time
.
P
u
b
l
i
c
a
t
i
o
n
The Basic, aggregated and disaggregated balances are published in the
website after approval by the Director-General
The Digest of South African Energy Statistics is produced out of these file and
published on approval by the Minister of Energy.
Local and Global reporting obligations ( UNSD, StatsSA and other organs of
state)
D
a
t
a
M
a
n
a
g
e
m
e
n
t
THANK YOU
•
C
o
n
t
a
c
t
d
e
t
a
i
l
s
:
D
e
p
a
r
t
m
e
n
t
o
f
E
n
e
r
g
y
•
B
u
i
l
d
i
n
g
2
A
,
4
t
h
f
l
o
o
r
•
0
1
2
-
4
4
4
-
4
0
9
7
•
M
a
l
u
t
a
.
K
w
i
n
d
a
@
e
n
e
r
g
y
.
g
o
v
.
z
a
This document provides insights into the data management processes related to energy balances compilation, covering aspects such as electricity generation, petroleum products, coal production, gas, and renewable energy data. It details data collection methods, quality control procedures, and preparation steps. The content emphasizes the importance of structured data collection and adherence to regulations for energy data provision.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
6thOSLO Group Meeting Energy Balances Compilation (SA) Robert Kwinda Sub-Dir: Energy Data Quality and Integrity
Data Management Data collected. Electricity Data Local generation (ESKOM owned, IPP s and Self Generating) Imports and Exports (SARS) Electricity used by refineries(Oil Companies) and coal mines(DMR) Final consumption of Electricity by Sector (NERSA, ESKOM, IPP s) Crude Oil and Petroleum data Importation and Exportation of Oil and petroleum products (SARS); Oil used in refineries and transformation output (SAPIA, Oil Companies) Final Consumption of Petroleum products by sector (SAPIA, Oil Companies, etc) Coal Local production (DMR) Imports and Exports (SARS) Transformation: Electricity Gen and liquefaction (ESKOM, Oil companies) Final Consumption of coal by Sector (DMR, StatsSA, Research Studies, etc)
Data Management Data collected...............................................................Cont. Gas Data Local production (SASOL, PetroSA and Others) Imports and Exports (SARS) Transformation(Gas works Gas and Liquefaction) (Gas Refining companies) Final consumption of Gas by Sector (Gas Refining companies, LPG Association and other sector organisation) Nuclear, Hydro, Solar and Renewables Data Some data extracted from research studies and related papers. More formal sources being identified.
Data Management Data collection methods. Data provided to the Department via Email and fax and mostly on excel format Formal agreements with data providers entered into. Data provided to the Department on pre-defined periodic basis. Currently, there is scientific/ probability based data collection as all identified data providers are requested to provide data to the Minister. Regulations on the Provision of Energy Data (Driven from the National Energy Act of 1998)
Data Management Data preparation Data is received and captured in the commodity flow spreadsheet in native units as well as in the Energy database. The commodity flow spreadsheet is imported into the Energy Database and in the process, the native units are converted into a single unit (TJ). This becomes the Basic file The aggregated and the disaggregated files are also created during the importation process.
Data Management Data Quality Control Computer System based... Comparisons of current figures with historical data to identify obvious outliers. Built-in conversion functionality in the database. Built-in functionality to detect when a wrong is attached to a figure. Built-in functionality to detect unrealistic statistical difference. Final consumption of Gas by Sector (Gas Refining companies, LPG Association and other sector organisation) Non Computer based... Internal Review by relevant sections within the Department. Review by External stakeholders, including data providers and industry experts. The Minister to be requested to approve the revision of some of our data by the IEA. An Energy Statistics Review Team has been established to review the Energy Balances from time tom time.
Data Management Publication The Basic, aggregated and disaggregated balances are published in the website after approval by the Director-General The Digest of South African Energy Statistics is produced out of these file and published on approval by the Minister of Energy. Local and Global reporting obligations ( UNSD, StatsSA and other organs of state)
THANK YOU Contact details: Department of Energy Building 2A, 4th floor 012-444-4097 Maluta.Kwinda@energy.gov.za
