<?xml version='1.0' ?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:saxon="http://icl.com/saxon" xmlns:a="http://www.plmxml.org/Schemas/PLMXMLSchema" exclude-result-prefixes="a saxon">
  <xsl:template match="/">
		<Document><!-- ======================================================================================== --><!-- Set the PLMXML file as a variable                                                        --><!-- ======================================================================================== -->
			<xsl:variable name="WSForm" select="a:PLMXML/a:Form"/>
			<xsl:variable name="WSHSTForm" select="'HST Form'"/>
			<xsl:variable name="WSUnitForm" select="'Unit Form'"/>
			<xsl:variable name="WSHSTLoop" select="a:PLMXML/a:Form[@subType = 'HST Form']/a:UserData/a:UserValue"/>
			<xsl:variable name="WSHSTLoop2" select="a:PLMXML/a:Form[@subType = 'HST Form']/a:UserData/a:UserValue[@title='H_hsttotaltime']"/>
			<xsl:variable name="MSWordIcon" select="'//Icons//MSWord.jpg'"/>
			<xsl:variable name="MSExcelIcon" select="'//Icons//MSExcel.jpg'"/>
			<xsl:variable name="MSDrawingIcon" select="'/nas02/ECRF/scripts/Icons/PDF.jpg'"/><!-- ======================================================================================================== --><!-- ==  Header 1                                                                                            == --><!-- ======================================================================================================== -->
			<Row>
				<ColumnA>Process Net, Loss, Total Time Report</ColumnA>
				<ColumnB/>
				<ColumnC/>
				<ColumnD/>
				<ColumnE/>
				<ColumnF/>
				<ColumnG/>
				<ColumnH>
					<xsl:value-of select="'Report Date: '"/>
				</ColumnH>
				<ColumnI>
					<xsl:value-of select="a:PLMXML/@date"/>
				</ColumnI>
			</Row><!-- ======================================================================================================== --><!-- ==  Header 2                                                                                            == --><!-- ======================================================================================================== -->
			<Row>
				<ColumnA/>
				<ColumnB/>
				<ColumnC/>
				<ColumnD/>
				<ColumnE/>
				<ColumnF/>
				<ColumnG/>
				<ColumnH>
					<xsl:value-of select="'Configured Date: '"/>
				</ColumnH>
				<ColumnI>
					<xsl:value-of select="a:PLMXML/@date"/>
				</ColumnI>
			</Row><!-- ======================================================================================================== --><!-- ==  Header 3                                                                                            == --><!-- ======================================================================================================== -->
			<Row>
				<ColumnA/>
				<ColumnB/>
				<ColumnC/>
				<ColumnD/>
				<ColumnE/>
				<ColumnF/>
				<ColumnG/>
				<ColumnH>
					<xsl:value-of select="'Current Rev Rule: '"/>
				</ColumnH>
				<ColumnI>
					<xsl:value-of select="a:PLMXML/@date"/>
				</ColumnI>
			</Row><!-- ======================================================================================================== --><!-- ==  Header 4                                                                                            == --><!-- ======================================================================================================== -->
			<Row>
				<ColumnA/>
				<ColumnB/>
				<ColumnC/>
				<ColumnD/>
				<ColumnE/>
				<ColumnF/>
				<ColumnG/>
				<ColumnH/>
				<ColumnI/>
			</Row><!-- ======================================================================================================== --><!-- ==  Header 5                                                                                            == --><!-- ======================================================================================================== -->
			<Row>
				<ColumnA>
					<xsl:value-of select="'Project'"/>
				</ColumnA>
				<ColumnB>
					<xsl:value-of select="'Team/Zone'"/>
				</ColumnB>
				<ColumnC>
					<xsl:value-of select="'Process Number'"/>
				</ColumnC>
				<ColumnD>
					<xsl:value-of select="'Process Name'"/>
				</ColumnD>
				<ColumnE>
					<xsl:value-of select="'Model'"/>
				</ColumnE>
				<ColumnF>
					<xsl:value-of select="'Model Type'"/>
				</ColumnF>
				<ColumnG>
					<xsl:value-of select="'Non-Walking Time'"/>
				</ColumnG>
				<ColumnH>
					<xsl:value-of select="'Walking Time'"/>
				</ColumnH>
				<ColumnI>
					<xsl:value-of select="'Total Time'"/>
				</ColumnI>
			</Row><!-- ======================================================================================================== --><!-- ==  Detail                                                                                            == --><!-- ======================================================================================================== -->
			<xsl:for-each select="$WSForm">
				<xsl:if test="@subType = 'Project Revision Master'">
					<xsl:variable name="WSProject" select="@name"/><!-- ======================================================================================================== -->
					<xsl:for-each select="$WSForm">
						<xsl:if test="@subType = 'Team_Zone Form'">
							<xsl:variable name="WSTeam" select="@name"/><!-- ======================================================================================================== -->
							<xsl:for-each select="$WSForm">
								<xsl:if test="@subType = 'Process Form'">
									<xsl:variable name="WSProcessName" select="@name"/>
									<xsl:variable name="WSProcessNumber" select="a:UserData/a:UserValue[@title = 'H_manpower']/@value"/><!-- ======================================================================================================== --><!-- ======================================================================================================== -->
									<xsl:for-each select="$WSForm">
										<xsl:if test="$WSUnitForm">
											<xsl:choose>
												<xsl:when test="@subType = 'Unit Form'">
													<Row>
														<ColumnA><xsl:value-of select="$WSProject"/></ColumnA>
														<ColumnB><xsl:value-of select="$WSTeam"/></ColumnB>
														<ColumnC><xsl:value-of select="$WSProcessNumber"/></ColumnC>
														<ColumnD><xsl:value-of select="$WSProcessName"/></ColumnD>
														<xsl:variable name="WSUnit" select="@name"/>
														<xsl:choose>
															<xsl:when test="$WSUnit = 'Unit Form'">
																<ColumnE><xsl:value-of select="'READ BONNET SHEET.'"/></ColumnE>
																<ColumnF><xsl:value-of select="'Model Type'"/></ColumnF>
															</xsl:when>
															<xsl:otherwise>
																<ColumnE><xsl:value-of select="$WSUnit"/></ColumnE>
																<ColumnF><xsl:value-of select="'Model Type'"/></ColumnF>
															</xsl:otherwise>
														</xsl:choose>
														<xsl:for-each select="$WSHSTLoop2">
                              <xsl:call-template name="TemplateA"></xsl:call-template>
														</xsl:for-each>
													</Row>
												</xsl:when>
											</xsl:choose>
										</xsl:if>
									</xsl:for-each>
								</xsl:if>
							</xsl:for-each>
						</xsl:if>
					</xsl:for-each>
				</xsl:if>
			</xsl:for-each>
		</Document>
	</xsl:template>

  <xsl:template name="TemplateA">
        <xsl:variable name="WSTotalCntr" select="preceding-sibling::value[1]"/>
        <ColumnG><xsl:value-of select="@value"/></ColumnG>
        <ColumnH><xsl:value-of select="$WSTotalCntr" /></ColumnH>
        <ColumnI><xsl:value-of select="sum(preceding-sibling::value)"/></ColumnI>
  </xsl:template>

</xsl:stylesheet><!-- Stylus Studio meta-information - (c) 2004-2007. Progress Software Corporation. All rights reserved.

<metaInformation>
  <scenarios>
    <scenario default="yes" name="Scenario1" userelativepaths="yes" externalpreview="no" url="TcMSEOut_1103-b.xml" htmlbaseurl="" outputurl="converter:CSV:root=Document:row=Row?PNTLL.csv" processortype="saxon8" useresolver="yes" profilemode="0"
              profiledepth="" profilelength="" urlprofilexml="" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext="" validateoutput="no"
              validator="internal" customvalidator=""/>
  </scenarios>
  <MapperMetaTag>
    <MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="converter:CSV:root=Document:row=Row?PNTLL.csv" destSchemaRoot="Document" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no">
      <SourceSchema srcSchemaPath="TcMSEOut_1103-b.xml" srcSchemaRoot="PLMXML" AssociatedInstance="" loaderFunction="document" loaderFunctionUsesURI="no"/>
    </MapperInfo>
    <MapperBlockPosition>
      <template match="/">
        <block path="Document/Row/ColumnH/xsl:value-of" x="287" y="107"/>
        <block path="Document/Row[1]/ColumnH/xsl:value-of" x="247" y="107"/>
        <block path="Document/Row[2]/ColumnH/xsl:value-of" x="207" y="107"/>
        <block path="Document/Row[4]/ColumnA/xsl:value-of" x="167" y="107"/>
        <block path="Document/Row[4]/ColumnB/xsl:value-of" x="127" y="107"/>
        <block path="Document/Row[4]/ColumnC/xsl:value-of" x="87" y="107"/>
        <block path="Document/Row[4]/ColumnD/xsl:value-of" x="47" y="107"/>
        <block path="Document/Row[4]/ColumnE/xsl:value-of" x="327" y="67"/>
        <block path="Document/Row[4]/ColumnF/xsl:value-of" x="207" y="67"/>
        <block path="Document/Row[4]/ColumnG/xsl:value-of" x="167" y="67"/>
        <block path="Document/Row[4]/ColumnH/xsl:value-of" x="127" y="67"/>
        <block path="Document/Row[4]/ColumnI/xsl:value-of" x="87" y="67"/>
        <block path="Document/xsl:for-each" x="87" y="0"/>
        <block path="Document/xsl:for-each/xsl:if/=[0]" x="311" y="0"/>
        <block path="Document/xsl:for-each/xsl:if" x="357" y="0"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each" x="147" y="0"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/=[0]" x="211" y="0"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if" x="257" y="0"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each" x="207" y="0"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/=[0]" x="271" y="15"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if" x="317" y="17"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each" x="267" y="47"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if" x="377" y="77"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose" x="308" y="128"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/=[0]" x="281" y="105"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/ColumnA/xsl:value-of" x="47" y="67"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/ColumnB/xsl:value-of" x="47" y="27"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/ColumnC/xsl:value-of" x="327" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/ColumnD/xsl:value-of" x="321" y="97"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:choose" x="247" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:choose/=[0]" x="201" y="141"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:choose/xsl:when/ColumnE/xsl:value-of" x="287" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:choose/xsl:when/ColumnF/xsl:value-of" x="207" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:choose/xsl:otherwise/ColumnE/xsl:value-of" x="167" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:choose/xsl:otherwise/ColumnF/xsl:value-of" x="127" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:for-each" x="377" y="37"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:for-each/xsl:if/=[0]" x="1" y="145"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:for-each/xsl:if" x="47" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:for-each/xsl:if/ColumnG/xsl:value-of" x="87" y="147"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:for-each/ColumnH/xsl:value-of" x="233" y="125"/>
        <block path="Document/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:for-each/xsl:if/xsl:choose/xsl:when/Row/xsl:for-each/ColumnI/xsl:value-of" x="91" y="191"/>
      </template>
    </MapperBlockPosition>
    <TemplateContext></TemplateContext>
    <MapperFilter side="source"></MapperFilter>
  </MapperMetaTag>
</metaInformation>
-->