In MS Office 97-2003, the level of macro security should be set to "Medium" (before asking to open the workbook, you will be asked "Does the user agree to the macros within the workbook?") Or "Low" (macros will be initiated automatically) if it has not already been done.
If you are using the 2007 Office suite or later, the macro settings should be set as follows: "Disable all macros and display the notification" or "Enable all macros".
The publication contains workbooks in MS Excel format, in which data from various fields were presented. The names of the spreadsheets use abbreviations corresponding to territorial ranges, division titles and data type, e.g.:
- WOJ_Ś_B means: Mazowieckie voivodship, environment, absolute numbers,
- WOF_Ś_W means: Warsaw Functional Area, environment, indicators.
The exception is the sheet "Complementary data for powiats" (DP_B_W), in which both absolute numbers and indicators are included.
The full name of the division and type of data is on the first row of the sheet.
The data are presented in accordance with the Internal Order No. 22 of the President of the Statistics Poland of 24 August 2017 on the introduction of the Coding System for Territorial and Statistical Units. The KTS system is a unified list of codes and names of basic units of the three-tier territorial division of the state and territorial units adopted for statistical purposes (NUTS classification) adopted for the needs of databases and IT systems of official statistics. The territorial levels of the KTS system include: level KTS 0 - Poland; level KTS 1 - macroregions (i.e. NUTS 1 units); level KTS 2 - voivodships; level KTS 3 - regions (i.e. NUTS 2 units); level KTS 4 - subregions (i.e. NUTS 3 units); level KTS 5 - powiats; level KTS 6 - gminas.
Five levels of data aggregation were applied to the sheets. The symbols: 1, 2, 3, 4, 5, +, – are used to display or hide the detail levels of the data presentation. To view the rows of a given level, just click its appropriate number:
level 1 - enables the presentation of data for Poland, the macroregion Mazowieckie voivodship and the Mazowieckie voivodship,
level 2 - enables the presentation of data from level 1 and for the regional level,
level 3 - enables the presentation of data from level 1 and 2 and for the subregional level,
level 4 - enables presentation of data from level 1, 2 and 3 and for the powiat level,
level 5 - enables presentation of data from level 1, 2, 3 and 4 and for the gmina level.
Clicking on the + or – symbol gives the opportunity to display or hide rows, respectively, within individual levels.
A quick selection of a specific territorial unit is available in the Search Engine; the selection of the unit should be accepted with the "Search" button. If the entered string corresponds to several units (number of results> 1), then the "Next result" button is activated.
The data were presented in each administrative division of the country. Underlining and highlighting the records with a blue font:
- in the header of the table — means that additional explanations were provided,
- in the first column of the table — header means that elements of the territorial system of the unit were modified.
Symbols
(—) |
— |
magnitude zero. |
(0) |
— |
magnitude not zero, but less than 0.5 of a unit; |
(0,0) |
— |
magnitude not zero, but less than 0.5 of a unit. |
( . ) |
— |
data not available or not reliable. |
x |
— |
not applicable. |
# |
— |
data should not be published due to the necessity of maintaining statistical confidentiallity in accordance with the Law on Official Statistics. |
"Of which" |
— |
indicates that not all elements of the sum are given. |
Abbreviations
PLN |
= Polish zloty |
pcs |
= pieces |
vol. |
= volume |
kg |
= kilogram |
t |
= tonne |
km |
= kilometre |
m2 |
= square metre |
ha |
= hectare |
km2 |
= square kilometre |
m3 |
= cubic metre |
dam3 |
= cubic decametre |
kWh |
= kilowatt.hour |
In this publication, a MS Excel workbook was used as a tool of presenting statistical data, which contain information in the form of absolute and relative numbers (indicators).
Statistics most often and most commonly uses figures to describe the population or phenomena surveyed. The description may be aimed at presenting the size, structure or dynamics of the populations or phenomena.
The collective numerical characteristics of the statistical population are indicators.
The indicator is the quotient of two quantities corresponding to the constituent parts of a given population or representing the features of two different populations, or concerning the same population, but at different times or periods.
We distinguish three main types of indicators:
- indicators of structure,
- intensity indicators,
- indicators of dynamics.
Indicators of structure, also called structural numbers, determine the ratio of a certain size of a part of the statistical population to that of the total population.
The indicator or measure of intensity determines the ratio of the values characterizing two different populations or statistical phenomena related to each other in a certain causal or logical manner.
Indicators of dynamics express the ratio between numbers characterizing a certain size in two different periods or moments of time. They are used to study dynamic series, and so changes that occur in statistical populations over a period of time.
There are two basic measures of the dynamics of statistical population: absolute increase and relative increase.
The absolute increase is the difference between the values of the variable in consecutive periods (e.g. in consecutive years, months or days).
The relative increase is the ratio of the absolute increase to the value of the variable from the previous period. If this relative increase is multiplied by 100, we will get a percentage increase.
The absolute increase and relative increase may be positive, negative or may be equal to zero.
Indexes are the most commonly used measure of dynamics. The index is the ratio of the variable value from different periods to the value of the same variable from the determined comparative period.
Indices are the most commonly used measure of dynamics. The index is the ratio of the variable value from different periods to the value of the same variable from the determined comparative period.
Relative numbers were usually calculated based on absolute data expressed with greater accuracy than those given in the spreadsheets.
When calculating data per capita (1000 population, etc.) as of the end of the year (e.g. employment, public library collection), the population was assumed as of 31 XII, and when calculating data characterizing the size of the phenomenon during the year (e.g. vital statistics, dwellings completed) - as of 30 VI.
Automatic rounding of numbers in some cases could cause minor differences in sums of data at higher level of aggregation.
Methods for calculating the indicators included in the publication.