
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"
xmlns:office='http://openoffice.org/2000/office'
 	xmlns:table='http://openoffice.org/2000/table'
 xmlns:text='http://openoffice.org/2000/text'
    xmlns:dd614="https://dd.eionet.europa.eu/namespace.jsp?ns_id=614" xmlns:dd616="https://dd.eionet.europa.eu/namespace.jsp?ns_id=616">
    <xsl:template match="dd614:DF4_8_Agg_Air"> <office:document-content xmlns:office='http://openoffice.org/2000/office' xmlns:table='http://openoffice.org/2000/table' office:version='1.0' xmlns:xlink='http://www.w3.org/1999/xlink' xmlns:number='http://openoffice.org/2000/datastyle' xmlns:text='http://openoffice.org/2000/text' xmlns:fo='http://www.w3.org/1999/XSL/Format' xmlns:style='http://openoffice.org/2000/style'>	<office:automatic-styles>		<style:style style:name='cell1' style:family='table-cell' >			<style:properties fo:text-align='left' fo:font-size='10pt'/>		</style:style>		<style:style style:name='cell2' style:family='table-cell' >			<style:properties fo:text-align='center' fo:font-size='12pt' fo:font-style='italic'/>		</style:style>		<style:style style:name='Heading1' style:family='table-cell' >			<style:properties fo:text-align='left' fo:font-size='10pt' fo:font-style='italic' style:text-align-source='fix' fo:font-weight='bold'/>		</style:style>		<style:style style:name='Heading2' style:family='table-cell' >			<style:properties fo:text-align='center' fo:font-size='10pt' fo:font-weight='bold' />		</style:style>	</office:automatic-styles>	<office:body>		<table:table>			<xsl:attribute name="table:name">DF4_8_Agg_Air</xsl:attribute>			<table:table-columns>				<table:table-column table:default-cell-value-type='number' table:default-cell-style-name='cell1' >					<xsl:attribute name="table:number-columns-repeated"><xsl:value-of select="count($elementsMetadata/element)"/></xsl:attribute>				</table:table-column>			</table:table-columns>			<!-- create header rows -->			<table:table-rows>				<xsl:apply-templates select="dd614:Row"/>			</table:table-rows>		</table:table>		<xsl:call-template name="DD_Schema_sheet"/>	</office:body></office:document-content></xsl:template><xsl:template match="dd614:Row">		<xsl:if test="position()=1">			<xsl:call-template name="header"/>		</xsl:if>	<table:table-row><xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="row" select="."></xsl:variable>
<xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$elementsMetadata/element">
   <xsl:variable name="elemIdentifier">
      <xsl:value-of select="identifier"></xsl:value-of>
   </xsl:variable>
   <xsl:variable name="multiValueSeparator">
      <xsl:call-template name="getSeparator">
         <xsl:with-param name="element" select="$elemIdentifier"></xsl:with-param>
      </xsl:call-template>
   </xsl:variable>
   <table:table-cell xmlns:table="http://openoffice.org/2000/table">
      <text:p xmlns:text="http://openoffice.org/2000/text">
         <xsl:choose>
            <xsl:when test="count($row/*[local-name()= $elemIdentifier])=0 or string-join($row/*[local-name()= $elemIdentifier ],'')=''"></xsl:when>
            <xsl:otherwise>
               <xsl:value-of select="string-join($row/*[local-name()= $elemIdentifier ],$multiValueSeparator)"></xsl:value-of>
            </xsl:otherwise>
         </xsl:choose>
      </text:p>
   </table:table-cell>
</xsl:for-each>	</table:table-row></xsl:template><!--  a named template, which creates the table header row --><xsl:template name="header">	<table:table-header-rows>		<table:table-row  table:default-cell-value-type='string' table:default-cell-style-name='Heading2' >
<xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$elementsMetadata/element">				<table:table-cell><text:p><xsl:value-of select="identifier" /></text:p> 
				</table:table-cell></xsl:for-each>		</table:table-row>	</table:table-header-rows></xsl:template><!-- Creates a sheet with XML schema, as it is done in DataDcit. Then it's possible to convert Excel back to XML--><xsl:template name="DD_Schema_sheet">	<table:table>		<xsl:attribute name="table:name">DO_NOT_DELETE_THIS_SHEET</xsl:attribute>			<table:table-columns>				<table:table-column table:default-cell-value-type='text' table:default-cell-style-name='cell1' />			</table:table-columns>			<table:table-rows>				<table:table-row>					<table:table-cell>						<text:p>Please do not delete or modify this sheet!!!</text:p>					</table:table-cell>				</table:table-row>				<table:table-row>					<table:table-cell>						<text:p>It is used for converting this file back to XML!</text:p>					</table:table-cell>				</table:table-row>				<table:table-row>					<table:table-cell>						<text:p>Without this possibility your work cannot be used!</text:p>					</table:table-cell>				</table:table-row>				<table:table-row>					<table:table-cell>						<text:p>https://dd.eionet.europa.eu/GetSchema?id=TBL7148</text:p>					</table:table-cell>				</table:table-row>			</table:table-rows>		</table:table></xsl:template>
<xsl:template xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="getSeparator">
   <xsl:param name="element" select="''"></xsl:param>
   <xsl:value-of select="','"></xsl:value-of>
</xsl:template>
<xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="elementsMetadata">
   <element>
      <elementid>65979</elementid>
      <identifier>UniqueAgglomerationId</identifier>
      <parentNS>616</parentNS>
      <type>string</type>
      <length>14</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65709</elementid>
      <identifier>Lden5054</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66031</elementid>
      <identifier>Lden5559</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66047</elementid>
      <identifier>Lden6064</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65678</elementid>
      <identifier>Lden6569</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65872</elementid>
      <identifier>Lden7074</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65628</elementid>
      <identifier>Lden75</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65811</elementid>
      <identifier>Lden5054FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65834</elementid>
      <identifier>Lden5559FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65802</elementid>
      <identifier>Lden6064FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65640</elementid>
      <identifier>Lden6569FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65647</elementid>
      <identifier>Lden7074FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65915</elementid>
      <identifier>Lden75FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65978</elementid>
      <identifier>Lden5054WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65808</elementid>
      <identifier>Lden5559WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65728</elementid>
      <identifier>Lden6064WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65863</elementid>
      <identifier>Lden6569WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66000</elementid>
      <identifier>Lden7074WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65971</elementid>
      <identifier>Lden75WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65969</elementid>
      <identifier>Lden5054FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66016</elementid>
      <identifier>Lden5559FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65707</elementid>
      <identifier>Lden6064FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66029</elementid>
      <identifier>Lden6569FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65675</elementid>
      <identifier>Lden7074FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65916</elementid>
      <identifier>Lden75FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66112</elementid>
      <identifier>Lden5054WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65943</elementid>
      <identifier>Lden5559WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65693</elementid>
      <identifier>Lden6064WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65636</elementid>
      <identifier>Lden6569WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66065</elementid>
      <identifier>Lden7074WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65706</elementid>
      <identifier>Lden75WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66107</elementid>
      <identifier>Lden5054FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65922</elementid>
      <identifier>Lden5559FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65648</elementid>
      <identifier>Lden6064FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65896</elementid>
      <identifier>Lden6569FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66039</elementid>
      <identifier>Lden7074FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65631</elementid>
      <identifier>Lden75FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65672</elementid>
      <identifier>Lnight4044</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65961</elementid>
      <identifier>Lnight4549</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65868</elementid>
      <identifier>Lnight5054</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65701</elementid>
      <identifier>Lnight5559</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65681</elementid>
      <identifier>Lnight6064</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66023</elementid>
      <identifier>Lnight6569</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65879</elementid>
      <identifier>Lnight70</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65820</elementid>
      <identifier>Lnight4044FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65642</elementid>
      <identifier>Lnight4549FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66072</elementid>
      <identifier>Lnight5054FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65924</elementid>
      <identifier>Lnight5559FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65980</elementid>
      <identifier>Lnight6064FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65694</elementid>
      <identifier>Lnight6569FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65645</elementid>
      <identifier>Lnight70FromMajorSource</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65951</elementid>
      <identifier>Lnight4044WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65770</elementid>
      <identifier>Lnight4549WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66110</elementid>
      <identifier>Lnight5054WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66038</elementid>
      <identifier>Lnight5559WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65914</elementid>
      <identifier>Lnight6064WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66012</elementid>
      <identifier>Lnight6569WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65688</elementid>
      <identifier>Lnight70WithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65679</elementid>
      <identifier>Lnight4044FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65898</elementid>
      <identifier>Lnight4549FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65638</elementid>
      <identifier>Lnight5054FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65933</elementid>
      <identifier>Lnight5559FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65955</elementid>
      <identifier>Lnight6064FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66066</elementid>
      <identifier>Lnight6569FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65776</elementid>
      <identifier>Lnight70FromMajorSourceWithSpecialInsulation</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65651</elementid>
      <identifier>Lnight4044WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65852</elementid>
      <identifier>Lnight4549WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65781</elementid>
      <identifier>Lnight5054WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65803</elementid>
      <identifier>Lnight5559WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66101</elementid>
      <identifier>Lnight6064WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65668</elementid>
      <identifier>Lnight6569WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66077</elementid>
      <identifier>Lnight70WithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66040</elementid>
      <identifier>Lnight4044FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66037</elementid>
      <identifier>Lnight4549FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65937</elementid>
      <identifier>Lnight5054FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65919</elementid>
      <identifier>Lnight5559FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65920</elementid>
      <identifier>Lnight6064FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65954</elementid>
      <identifier>Lnight6569FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>66042</elementid>
      <identifier>Lnight70FromMajorSourceWithAQuietFacade</identifier>
      <parentNS>616</parentNS>
      <type>integer</type>
      <length>11</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65931</elementid>
      <identifier>ComputationAndMeasurementMethodsReportDetails</identifier>
      <parentNS>616</parentNS>
      <type>string</type>
      <length>255</length>
      <precision></precision>
   </element>
   <element>
      <elementid>65935</elementid>
      <identifier>ComputationMethodName</identifier>
      <parentNS>616</parentNS>
      <type>string</type>
      <length>255</length>
      <precision></precision>
   </element>
</xsl:variable></xsl:stylesheet>