<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:rs="urn:schemas-microsoft-com:rowset" 
xmlns:z="#RowsetSchema">
<xsl:template match="rs:data">

<xsl:param name="fullyadressed" select="z:row[@ows_ICAO_x0020_CAP_x0020_Comments='Fully addresses']"/>
<xsl:param name="notfullyadressed" select="z:row[@ows_ICAO_x0020_CAP_x0020_Comments!='Fully addresses']"/>
<xsl:param name="notdone" select="z:row[@ows_Status!='Completed' and @ows_Status!='75%' and @ows_Status!='50%']"/>
<xsl:param name="faandcomp" select="$fullyadressed[not(@ows_Title=$notdone/@ows_Title)]"/>
<xsl:param name="faandnotcomp" select="$fullyadressed[@ows_Title=$notdone/@ows_Title]"/>


<chart plotFillRatio='0' showlabels='1' rotateLabels='1' showlegend='0'
  showValues='0'  showYAxisValues='0' bgcolor='FFFFFF' showSum='1' showBorder='0'
  seriesNameInToolTip='1'>
<xsl:attribute name="caption">
<xsl:value-of select="z:row/@ows_State[1]"/>
</xsl:attribute>


<categories>
<category label="LEG"/>
<category label="ORG"/>
<category label="PEL"/>
<category label="OPS"/>
<category label="AIR"/>
<category label="AIG"/>
<category label="ANS"/>
<category label="AGA"/>
</categories>

<dataset seriesName='Fully adressed and completed' color="00FF00">

	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='1. LEG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='2. ORG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='3. PEL'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='4. OPS'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='5. AIR'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='6. AIG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='7. ANS'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandcomp[@ows_Area='8. AGA'])"/>
	</xsl:attribute>
	</set>	
</dataset>

<dataset seriesName='Fully adressed but not completed' color="00FF00" alpha='50'>

	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='1. LEG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='2. ORG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='3. PEL'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='4. OPS'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='5. AIR'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='6. AIG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='7. ANS'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($faandnotcomp[@ows_Area='8. AGA'])"/>
	</xsl:attribute>
	</set>	
</dataset>

<dataset seriesName='Not fully adressed' color="FF0000" alpha='50'>

	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='1. LEG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='2. ORG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='3. PEL'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='4. OPS'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='5. AIR'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='6. AIG'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='7. ANS'])"/>
	</xsl:attribute>
	</set>	
	<set>
	<xsl:attribute name="value">
	<xsl:value-of select="count($notfullyadressed[@ows_Area='8. AGA'])"/>
	</xsl:attribute>
	</set>	
</dataset>

</chart>
</xsl:template>

</xsl:stylesheet>