Eionet
Conversion and Quality Assessment Service
View stylesheet
| XML schema |
http://dd.eionet.europa.eu/schemas/LCP-article_72_IED/LCP-IED.xsd
|
|---|---|
| Output type | EXCEL |
| Description | MS Excel |
| XSL file | lcp-ied-excel.xsl (Last modified: 26 Jan 2018 09:58 ) |
<?xml version="1.0" encoding="UTF-8"?>
<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:xs="http://www.w3.org/2001/XMLSchema">
<xsl:output method="xml"/>
<!--
$Id$
-->
<xsl:param name="xml_folder_uri"/>
<xsl:variable name="language">en</xsl:variable>
<xsl:variable name="labels" select="document('https://svn.eionet.europa.eu/repositories/Reportnet/Dataflows/LCP-v2/xml/lcp-labels-en.xml')/labels"/>
<xsl:variable name="codelists"
select="document('https://svn.eionet.europa.eu/repositories/Reportnet/Dataflows/LCP-v2/xml/lcp-codelists-en.xml')/LCPCodelists"/>
<!--<xsl:variable name="schema" select="document('https://svn.eionet.europa.eu/repositories/Reportnet/Dataflows/LCP-v2/schema/LCP-IED.xsd')/xs:schema"/>
-->
<xsl:variable name="heading" select="'Questionnaire on the implementation of LCP'"/>
<xsl:template match="/LCPQuestionnaire">
<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="row-height" style:family="table-cell">
<style:properties style:row-height="2cm"/>
</style:style>
<style:style style:name="string-cell" style:family="table-cell">
<style:properties fo:text-align="left"
fo:font-size="10pt" style:column-width="5cm"/>
</style:style>
<style:style style:name="long-string-cell" style:family="table-cell">
<style:properties fo:text-align="left"
fo:font-size="10pt" style:column-width="15cm"/>
</style:style>
<style:style style:name="number-cell" style:family="table-cell">
<style:properties fo:text-align="right"
fo:font-size="10pt" style:column-width="5cm"/>
</style:style>
<style:style style:name="long-number-cell" style:family="table-cell">
<style:properties fo:text-align="right"
fo:font-size="10pt" style:column-width="10cm"/>
</style:style>
<style:style style:name="total-number-cell" style:family="table-cell">
<style:properties fo:text-align="right" fo:font-weight="bold"
fo:font-size="10pt" style:column-width="5cm"/>
</style:style>
<style:style style:name="string-heading" style:family="table-cell">
<style:properties fo:text-align="left"
fo:font-size="10pt" style:column-width="5cm" fo:font-weight="bold"
style:row-height="2cm"/>
</style:style>
<style:style style:name="long-string-heading" style:family="table-cell">
<style:properties fo:text-align="left"
fo:font-size="10pt" style:column-width="10cm" fo:font-weight="bold"/>
</style:style>
<style:style style:name="cell1" style:family="table-cell">
<style:properties fo:text-align="left"
fo:font-size="10pt" style:column-width="5cm"/>
</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:column-width="5cm"/>
</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:column-width="5cm"
style:row-height="2cm"/>
</style:style>
<style:style style:name="long-Heading2" style:family="table-cell">
<style:properties fo:text-align="left"
fo:font-size="10pt" fo:font-weight="bold" style:column-width="10cm"
style:row-height="2cm"/>
</style:style>
<style:style style:name="Heading3" style:family="table-cell">
<style:properties fo:text-align="Right"
fo:font-size="10pt" fo:font-weight="bold" style:column-width="5cm"/>
</style:style>
<style:style style:name="Heading4" style:family="table-cell">
<style:properties fo:text-align="right"
fo:font-size="10pt" fo:font-weight="bold" style:column-width="10cm"/>
</style:style>
</office:automatic-styles>
<office:body>
<!-- BasicData -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'BasicData'"/>
</xsl:attribute>
<xsl:for-each select=".">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/basicData"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="basicData-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- DONE -->
<!-- List of Plants -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'List of Plants'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="number"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/listOfPlants"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/EPRTRNationalId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/city"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/region"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/postalCode"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/countryCode"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/buildingNumber"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/streetName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/longitude"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/latitude"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/facilityName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/comments"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="listOfPlants-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- DONE -->
<!-- Plant Details -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'Plant Details'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="number"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantDetails"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/MWth"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/dateOfStartOfOperation"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/refineries"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/otherSector"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/operatingHours"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/comments"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/typeOfCombustionPlant"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/typeOfCombustionPlantFurtherDetails"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/Derogation"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="plantDetails-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- DONE -->
<!-- Energy Input-->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'Energy Input'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="number"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/energyInput"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/Biomass"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/liquidFuels"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/naturalGas"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/Coal"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/Lignite"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/Peat"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="energyInput-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- Energy Input - Other solid fuels (TJ ) -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'Energy Input - Other solid fuels (TJ )'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/energyInputOtherSolidFuels"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/input"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/value"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="energyInput-other-solid-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- Energy Input - Other gases (TJ ) -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'Energy Input - Other gases (TJ )'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/energyInputOtherGases"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/input"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/value"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="energyInput-other-gases-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- DONE -->
<!-- Emissions -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'Emissions'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="number"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/energyInputAndTotalEmissionsToAir"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/SO2"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/NOx"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/dust"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="emissions-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- DONE -->
<!-- Desulphurisation -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'Desulphurisation'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="number"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/Desulphurisation"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/monthValue"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/DesulphurisationRate"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/SulphurContent"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/TechnicalJustification"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="desulphurisation-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
<!-- DONE -->
<!-- Useful Heat -->
<table:table>
<xsl:attribute name="table:name">
<xsl:value-of select="'Useful Heat'"/>
</xsl:attribute>
<xsl:for-each select="./ListOfPlants">
<table:table-columns>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="long-string-heading">
</table:table-column>
<table:table-column
table:default-cell-value-type="number"
table:default-cell-style-name="number-cell">
</table:table-column>
<table:table-column
table:default-cell-value-type="string"
table:default-cell-style-name="string-cell">
</table:table-column>
</table:table-columns>
<table:table-header-rows>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/proportionOfUsefulHeat"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/plantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="Heading2">
<text:p>
<xsl:value-of select="$labels/UsefulHeatProportion"/>
</text:p>
</table:table-cell>
</table:table-row>
</table:table-header-rows>
<table:table-rows>
<xsl:call-template name="usefulHeat-table"/>
</table:table-rows>
</xsl:for-each>
</table:table>
</office:body>
</office:document-content>
</xsl:template>
<!-- Same as OLD -->
<xsl:template name="basicData-table">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/memberState"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/MemberState"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/referenceYear"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./BasicData/ReferenceYear"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/numberOfPlants"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./BasicData/NumberOfPlants"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/organization"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/Organization"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/address1"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/Address1"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/city"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/City"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/state"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/State"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/postalCode"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/PostalCode"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/nameOfDepartmentContactPerson"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/NameOfDepartmentContactPerson"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/phone"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/Phone"/>
</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="Heading1">
<text:p>
<xsl:value-of select="$labels/eMail"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./BasicData/Email"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:template>
<!-- MODIFIED-->
<xsl:template name="listOfPlants-table">
<xsl:for-each select="Plant">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./EPRTRNationalId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./PlantLocation/City"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./PlantLocation/Region"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./PlantLocation/PostalCode"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./PlantLocation/CountryCode"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./PlantLocation/BuildingNumber"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./PlantLocation/StreetName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./GeographicalCoordinate/Longitude"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./GeographicalCoordinate/Latitude"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./FacilityName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./Comments"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
<!-- MODIFIED -->
<xsl:template name="plantDetails-table">
<xsl:for-each select="Plant/PlantDetails">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="../PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="../PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./MWth"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./DateOfStartOfOperation"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./Refineries"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./OtherSector"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./OperatingHours"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./Comments"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./TypeOfCombustionPlant"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./TypeOfCombustionPlantFurtherDetails"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./Derogation"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
<!-- MODIFIED -->
<xsl:template name="energyInput-table">
<xsl:for-each select="Plant/EnergyInputAndTotalEmissionsToAir">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="../PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="../PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./EnergyInput/Biomass"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./EnergyInput/LiquidFuels"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./EnergyInput/NaturalGas"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./EnergyInput/Coal"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./EnergyInput/Lignite"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./EnergyInput/Peat"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
<!-- MODIFIED -->
<xsl:template name="energyInput-other-solid-table">
<xsl:for-each select="Plant/EnergyInputAndTotalEmissionsToAir/EnergyInput/OtherSolidFuels/OtherSolidFuel">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="../../../../PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="../../../../PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./Category"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./Value"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
<!-- MODIFIED -->
<xsl:template name="energyInput-other-gases-table">
<xsl:for-each select="Plant/EnergyInputAndTotalEmissionsToAir/EnergyInput/OtherGases/OtherGas">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="../../../../PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="../../../../PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./Category"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./Value"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
<!-- MODIFIED -->
<xsl:template name="emissions-table">
<xsl:for-each select="Plant/EnergyInputAndTotalEmissionsToAir">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="../PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="../PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./TotalEmissionsToAir/SO2"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./TotalEmissionsToAir/NOx"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./TotalEmissionsToAir/TSP"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
<!-- MODIFIED -->
<xsl:template name="desulphurisation-table">
<xsl:for-each select="Plant/Desulphurisation/Months/Month">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="../../../PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="../../../PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./MonthValue"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./DesulphurisationRate"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./SulphurContent"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="./TechnicalJustification"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
<!-- MODIFIED -->
<xsl:template name="usefulHeat-table">
<xsl:for-each select="Plant/UsefulHeat">
<table:table-row table:default-cell-value-type="string">
<table:table-cell table:style-name="cell1">
<text:p>
<xsl:value-of select="../PlantName"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="../PlantId"/>
</text:p>
</table:table-cell>
<table:table-cell table:style-name="number-cell">
<text:p>
<xsl:value-of select="./UsefulHeatProportion"/>
</text:p>
</table:table-cell>
</table:table-row>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>