﻿<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">

    <xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>


    <xsl:template match="/">
        <xsl:variable name="ExtendedLeaderboard" select="LeaderBoardXML/ExtendedLeaderboard/."></xsl:variable>
        <xsl:variable name="ExtendedPeriodRange" select="LeaderBoardXML/ExtendedLeaderboardPeriodRange/."></xsl:variable>

        <xsl:variable name="CountRec" select="count($ExtendedLeaderboard/Record)"></xsl:variable>

        <sst count="{$CountRec}" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

            <si>
                <t>Team Member</t>
            </si>
            <si>
                <t>Amount</t>
            </si>
            <xsl:for-each select="$ExtendedPeriodRange/Period">
                <si>
                    <t>
                        <xsl:value-of select="DisplayPeriodKey"/>
                    </t>
                </si>
            </xsl:for-each>
            
            <xsl:for-each select="$ExtendedLeaderboard/Record">
                <si>
                    <t>
                        <xsl:value-of select="DisplayName"/>
                    </t>
                </si>
            </xsl:for-each>
        </sst>
    </xsl:template>
</xsl:stylesheet>
