Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

Conditional Insert of <TR>'s and </TR>'s

I need to display a table with two columns with a list in column one of LastName/FirstName, and a list in column 2 of LastName/FirstName.

The list is extracted from the XML Below.  I'm making a report of conditional parts of the below xml.

The xsl below is partial working.  In the first section "Class1" I'm selecting all employees who have MORE than one test.  Then there is another filter on those, I'm need to display only the employees who LAST test has an "STS" attribute value of "No STS".

I currently have this xslt displaying the employee names I want but I can't come up with a suitable way to break the names into two columns.

I am also using a script section to increment a counter to keep track of how many employees I have output.

You should be able to save the xml/xslt below and view what I'm doing now.


"SO THE QUESTION IS:"
Given the xsl/xml below how can I break the table into two columns.  I have marked the table section with the comment "HERE IS WHERE I NEED HELP!!!!": I want to conditionaly insert the TR's and /TR's:

Please email me with any question as this is very high priority on my list:  bllwatkins@mindspring.com

I'll also give a bonus 500 points to anyone willing to go into detail with me and get this working to my satisfaction.

Thanks Brad.

HERE IS MY XSL:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="http://mycompany.com/mynamespace">

    <msxsl:script implements-prefix="user" language="VBScript">
        <![CDATA[
                Dim empCount

                  Function setParamID()
                    empCount = 0
                  end function

                  Function CheckTRBegin()
                    if (empCount mod 2) = 1 then
                      'CheckTRBegin = "TR"
                      document.write ("<TR>")
                    end if
                  end function

                  Function CheckTREnd()
                    if (empCount mod 2) = 0 then
                      'CheckTRBegin = '</TR>'
                      document.write ("</TR>")
                    end if
                  end function

                  Function GetCount(Increment)
                    if Increment = "true" then
                      empCount = empCount + 1
                      GetCount = empCount
                     else
                      'empCount = empCount
                      GetCount = empCount
                    end if
                  End Function
                ]]>
    </msxsl:script>
   
<xsl:template match="/">
        <html>
            <head>
<STYLE type="text/css">
 A {text-decoration:none}
 A IMG {border-style:none; border-width:0;}
.fontColor10 {FONT-SIZE:10PT; ; FONT-FAMILY:Times New Roman; FONT-WEIGHT:BOLD; }
.fontColor11 {FONT-SIZE:9PT; ; FONT-FAMILY:Times New Roman; }
.fontColor12 {FONT-SIZE:8PT; ; FONT-FAMILY:Times New Roman; }
.fontColor13 {FONT-SIZE:8PT; ; FONT-FAMILY:Times New Roman; FONT-WEIGHT:BOLD; }
.fontColor14 {FONT-SIZE:9PT; ; FONT-FAMILY:Times New Roman; }
.fontColor15 {FONT-SIZE:6PT; ; FONT-FAMILY:Times New Roman; }
.fontColor16 {FONT-SIZE:6PT; ; FONT-FAMILY:LinePrinter; }
.fontColor17 {FONT-SIZE:7PT; ; FONT-FAMILY:Times New Roman; }
.fontColor18 {FONT-SIZE:7PT; ; FONT-FAMILY:LinePrinter; }
.adornment10 {border-color:000000; border-style:none; border-bottom-width:0PX; border-left-width:0PX; border-top-width:0PX; border-right-width:0PX; }
.adornment11 {border-color:000000; border-style:none; border-bottom-width:0PX; border-left-width:0PX; border-top-style:solid; border-top-color:000000; border-top-width:1PX; border-right-width:0PX; }
.adornment12 {border-color:000000; border-style:none; border-bottom-width:0PX; border-left-style:solid; border-left-color:000000; border-left-width:1PX; border-top-width:0PX; border-right-width:0PX; }
.adornment13 {border-color:000000; border-style:none; border-bottom-width:0PX; border-left-width:0PX; border-top-style:solid; border-top-color:000000; border-top-width:1PX; border-right-width:0PX; }
.adornment14 {border-color:000000; border-style:none; border-bottom-style:solid; border-bottom-color:000000; border-bottom-width:1PX; border-left-style:solid; border-left-color:000000; border-left-width:1PX; border-top-style:solid; border-top-color:000000; border-top-width:1PX; border-right-style:solid; border-right-color:000000; border-right-width:1PX; }
.rightSingle {border-color:000000; border-style:none; border-bottom-style:none; border-bottom-color:000000; border-bottom-width:0PX; border-left-style:none; border-left-color:000000; border-left-width:0PX; border-top-style:none; border-top-color:000000; border-top-width:0PX; border-right-style:solid; border-right-color:000000; border-right-width:1PX; }
.noBorder {border-color:000000; border-style:none; border-bottom-style:none; border-bottom-color:000000; border-bottom-width:0PX; border-left-style:none; border-left-color:000000; border-left-width:0PX; border-top-style:none; border-top-color:000000; border-top-width:0PX; border-right-style:none; border-right-color:000000; border-right-width:0PX; }
.topSingle {border-color:000000; border-style:none; border-bottom-style:none; border-bottom-color:000000; border-bottom-width:0PX; border-left-style:none; border-left-color:000000; border-left-width:0PX; border-top-style:single; border-top-color:000000; border-top-width:1PX; border-right-style:none; border-right-color:000000; border-right-width:1PX; }
.top_Bot_Single {border-color:000000; border-style:none; border-bottom-style:single; border-bottom-color:000000; border-bottom-width:1PX; border-left-style:none; border-left-color:000000; border-left-width:0PX; border-top-style:single; border-top-color:000000; border-top-width:1PX; border-right-style:none; border-right-color:000000; border-right-width:1PX; }

</STYLE>

            <title>WebAudi Reports - Audiometric Test Report</title>
            </head>

            <BODY LEFTMARGIN="0" TOPMARGIN="0" BOTTOMMARGIN="0" RIGHTMARGIN="0">

                <xsl:value-of select="user:setParamID" />

                <xsl:call-template name="Header1" />

                <xsl:call-template name="CompanyINFO" />
                <xsl:call-template name="Class1"/>
                <xsl:call-template name="Classification2" />

                <xsl:call-template name="Classification3" />

                <P class="paragraph" align="Center"> </P>
            </BODY>
        </html>
    </xsl:template>


<xsl:template name="Class1" match="WA_Report/employees/employee/emp_test_data/@numtest[.> 1]">
  <xsl:call-template name="Classification1" />
  <xsl:call-template name="EmpNoSTS"/>
</xsl:template>

<xsl:template name="EmpNoSTS">
   <xsl:variable name="btr" select="'<TR>'"/>
   <xsl:variable  name="etr" select="'</TR>'"/>

     
   <p align="center">
     <table width="680px" border="0px" bordercolor="white" cellpadding="0" cellspacing="0">
       <xsl:for-each select="WA_Report/employees/employee">
         <xsl:sort select="emp_details/name_last" data-type="text" order="ascending" />
         <xsl:choose>
            <xsl:when test="emp_test_data/@numtest > 1">
            <xsl:for-each select="emp_test_data/test_record">
              <xsl:choose>
                 <xsl:when test="@lasttest='1' and @sts='No STS'">
                    <!--HERE IS WHERE I NEED HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1-->
                    <!--<TR NEED TO Conditionaly insert TR here every other emp that is selected.>-->
                    <!--Have tried something like "<xsl:if test="(user:GetCount('false') mod 2) = 1"><xsl:value-of disable-output-escaping="yes" select="$btr"/></xsl:if>" -->
                    <!--    This will give me an error "Function 'GetCount' did not return a value, or it returned a value that cannot be converted to an XSL data type."-->
                    <xsl:value-of disable-output-escaping="yes" select="$btr"/>
                      <td align="center">
                        <xsl:value-of select="user:GetCount('true')" />
                         - 
                        <xsl:value-of select="../../emp_details/name_last" />
                        , 
                        <xsl:value-of select="../../emp_details/name_first" />
                      </td>
                    <!--</tr>-->
                    <xsl:value-of disable-output-escaping="yes" select="$etr"/>
                  </xsl:when>
                </xsl:choose>
              </xsl:for-each>
            </xsl:when>
          </xsl:choose>
        </xsl:for-each>
      </table>
      <!--TOTAL-->
      <HR align="center" width="680px" />
      <table width="680px">
        <tr>
          <td align="center">Total employees in this classification: 
            <strong>
              <xsl:value-of select="user:GetCount('false')" />
            </strong>
          </td>
        </tr>
      </table>
   </p>
</xsl:template>

<xsl:template name="Header1">
<!--Report Page Header  1st Page only...... -->
<P class="paragraph" align="Center">
  <table border="0" width="680px">
    <TR>
      <TD> </TD>
    </TR>
    <tr>
      <td class="fontColor10" align="center">AUDIOMETRIC CLASSIFICATION REPORT (Annual)</td>
    </tr>
    <tr>
      <TD class="fontColor11" align="center">Audiological Services</TD>
    </tr>
  </table>
</P>
</xsl:template>

<xsl:template name="CompanyINFO">
<!--CompanyINFO grid used at top of the report. -->
  <P class="paragraph" align="Center">
    <table width="680px">
      <TR>
        <TD align="left" class="fontColor12"> Company Information</TD>
      </TR>
    </table>
    <table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="120">
      <tr bordercolor="white">
        <TD valign="top" width="90" class="fontColor13">Company:
          <BR />Address:
        </TD>
        <td valign="top" width="300" class="fontColor14">
          <xsl:value-of select="WA_Report/CompanyINFO/CompanyName" />
          <BR />
          <xsl:value-of select="WA_Report/CompanyINFO/Address1" />
          <br />
          <xsl:value-of select="WA_Report/CompanyINFO/Address2" />
          <br />
          <xsl:value-of select="WA_Report/CompanyINFO/City" />
          , 
          <xsl:value-of select="WA_Report/CompanyINFO/State" />
            
          <xsl:value-of select="WA_Report/CompanyINFO/ZipCode" />
        </td>
        <td valign="top" width="290">
          <span class="fontColor13">Report Date: </span>
          <span class="fontColor12">
            <xsl:value-of select="WA_Report/ReportSpecs/@dategenerated" />
          </span>
          <BR />
          <br />
          <span class="fontColor13">Number of Employees on this Report:</span>
            
          <span class="fontColor12">
            <xsl:value-of select="count(WA_Report/employees/employee)" />
          </span>
        </td>
      </tr>
      <tr bordercolor="white">
        <TD Colspan="3" width="680" class="fontColor12">This report includes employees tested from
          <xsl:value-of select="WA_Report/ReportSpecs/ReportDates/DateBegin" />
          <span> to </span>
          <xsl:value-of select="WA_Report/ReportSpecs/ReportDates/DateEnd" />
        </TD>
      </tr>
    </table>
  </P>
</xsl:template>

<xsl:template name="Classification1">
<!--Classification1. -->
  <P class="paragraph" align="Center">
    <table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
      <tr bordercolor="white">
        <TD>STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95 - April 18, 1983, is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative to the baseline audiograms in either ear. The annual or monitored audiometric exams for the following employees showed NO STANDARD THRESHOLD SHIFT</TD>
      </tr>
    </table>
  </P>
</xsl:template>

<xsl:template name="Classification2">
<!--Classification2 -->
  <P class="paragraph" align="Center">
    <table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
      <tr bordercolor="white">
        <TD>
          <Table>
            <TR>
              <TD colspan="2">STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95 - April 18, 1983, is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative to the baseline audiograms in either ear. The annual or monitored audiometric exams for the following employees showed a
                <STRONG>
                  <u>STANDARD THRESHOLDS SHIFT HAS OCCURRED</u>
                </STRONG>
                . As required by OSHA and recommended by our office, these employees have had a follow-up audiogram within 30 days to establish the validity of the actual current hearing threshold levels. Thusly, the establishment of new thresholds have been recorded at this time. Again, as defined by OSHA, these employees:
              </TD>
            </TR>
            <TR>
              <TD width="20"></TD>
              <TD>(1) must be re-informed and re-educated concerning the importance of hearing conservation both on and off the job:</TD>
            </TR>
            <TR>
              <TD width="20"></TD>
              <TD>(2) must be re-instructed on proper use and insertion of hearing protectors;</TD>
            </TR>
            <TR>
              <TD width="20"></TD>
              <TD>(3) if current hearing protection is being utilized properly, the reissuance of new hearing protection devices with a greater NRR is advised;</TD>
            </TR>
            <TR>
              <TD width="20"></TD>
              <TD>(4) if for some reason all these measures are unobtainable, the relocation of the employee to a reduced noise area must be considered.</TD>
            </TR>
          </Table>
        </TD>
      </tr>
    </table>
  </P>
</xsl:template>

<xsl:template name="Classification3">
<!--Classification3. -->
  <P class="paragraph" align="Center">
    <table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
      <tr bordercolor="white">
        <TD>STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95 - April 18, 1983, is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative to the baseline audiograms in either ear. The annual or monitored audiometric exams for the following employees showed an
        <STRONG>
          <u>UN-CONFIRMED STANDARD THRESHOLD SHIFT HAS OCCURRED</u>
        </STRONG>
        . It is required by OSHA and recommended by our office that these employees have a follow-up audiogram within 30 days to validate the monitored audiometric examination. Please advise the physician's office to send Audiological Services a copy of the test data for comparative study.</TD>
      </tr>
    </table>
  </P>

</xsl:template>
</xsl:stylesheet>



HERE IS MY XML:
<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="WA_Report4.3.xsl" ?>
<WA_Report>
    <CompanyINFO>
        <CompanyID>2</CompanyID>
        <CompanyName>Brad Papers, inc.</CompanyName>
        <Active>True</Active>
        <Address1>BW PO Box 633</Address1>
        <Address2>Thermal Paper Division2</Address2>
        <City>JonesTown</City>
        <State>NW</State>
        <ZipCode>29633</ZipCode>
        <PrimaryContactFirstName>Debbie</PrimaryContactFirstName>
        <PrimaryContactLastName>Daniels</PrimaryContactLastName>
        <PrimaryContactPhoneNumber>555-847-7205</PrimaryContactPhoneNumber>
        <EmergencyContactFirstName>John</EmergencyContactFirstName>
        <EmergencyContactLastName>SMITH</EmergencyContactLastName>
        <EmergencyContactPhoneNumber>555-718-8735</EmergencyContactPhoneNumber>
        <AddInfo />
        <DontUseACF>False</DontUseACF>
        <MedicalOffice />
        <AcceptNo8K>False</AcceptNo8K>
        <EmailNotify />
        <EmailForNotify />
    </CompanyINFO>
    <ReportSpecs dategenerated="3/21/02">
        <ReportDates>
            <DateBegin>3/19/02 12:00:01 AM</DateBegin>
            <DateEnd>3/19/02 11:59:59 PM</DateEnd>
            <TestingYear>2002</TestingYear>
        </ReportDates>
        <report_summary>
            <num_of_baseline>0</num_of_baseline>
            <num_of_monitored>3</num_of_monitored>
            <num_of_blnormal>0</num_of_blnormal>
            <num_of_blslight>0</num_of_blslight>
            <num_of_blmild>0</num_of_blmild>
            <num_of_blmoderate>0</num_of_blmoderate>
            <num_of_blsevere>0</num_of_blsevere>
            <num_of_blprofound>0</num_of_blprofound>
            <num_of_blunclassified>0</num_of_blunclassified>
            <num_of_mosts>0</num_of_mosts>
            <num_of_monosts>3</num_of_monosts>
        </report_summary>
    </ReportSpecs>
    <employees emps_tested="12">
        <employee emp_id="10603">
            <emp_details>
                <emp_id>10603</emp_id>
                <name_first>1DAVID T.</name_first>
                <name_last>1FIDDFEARRIS</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>10/20/55</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>9/14/00</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>555-55-6897</ssn>
            </emp_details>
            <emp_test_data numtest="6">
                <test_record lasttest="0" currentbaseline="1" testid="55783" emp_id="10603" baseline="True" date="10/20/83" rt500="5" rt1k="10" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="5" lt1k="0" lt2k="0" lt3k="0" lt4k="5" lt6k="5" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="55682" emp_id="10603" baseline="False" date="11/23/98" rt500="15" rt1k="15" rt2k="5" rt3k="5" rt4k="10" rt6k="10" rt8k="20" lt500="5" lt1k="5" lt2k="0" lt3k="0" lt4k="10" lt6k="20" lt8k="30" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="55327" emp_id="10603" baseline="False" date="10/8/99" rt500="15" rt1k="15" rt2k="5" rt3k="5" rt4k="10" rt6k="10" rt8k="25" lt500="10" lt1k="10" lt2k="5" lt3k="5" lt4k="10" lt6k="25" lt8k="30" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="491" emp_id="10603" baseline="False" date="9/14/00 9:06:00 AM" rt500="15" rt1k="20" rt2k="5" rt3k="5" rt4k="5" rt6k="10" rt8k="30" lt500="15" lt1k="10" lt2k="5" lt3k="5" lt4k="20" lt6k="25" lt8k="40" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="01" hpd_name="MAX LITE CORDED" hpd_type="2" rating="1 - Normal" sts="" hearing_loss="Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="30" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="649" emp_id="10603" baseline="False" date="9/14/00 9:06:00 AM" rt500="15" rt1k="20" rt2k="5" rt3k="5" rt4k="5" rt6k="10" rt8k="30" lt500="15" lt1k="10" lt2k="5" lt3k="5" lt4k="20" lt6k="25" lt8k="40" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="01" hpd_name="MAX LITE CORDED" hpd_type="2" rating="1 - Normal" sts="" hearing_loss="Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="30" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84193" emp_id="10603" baseline="False" date="3/19/02 11:32:00 AM" rt500="15" rt1k="15" rt2k="15" rt3k="15" rt4k="15" rt6k="15" rt8k="15" lt500="15" lt1k="15" lt2k="15" lt3k="15" lt4k="15" lt6k="15" lt8k="15" tech="Brad Watkins" cert_no="123643" audio_sn="1122343" audio_com="test" hpd_code="00" hpd_name="NO PROTECTION WORN" hpd_type="0" rating="1 - Normal" sts="No STS" hearing_loss="Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="0" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="10784">
            <emp_details>
                <emp_id>10784</emp_id>
                <name_first>2ARTHUR</name_first>
                <name_last>2BFFIELDS</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>3/29/41</birthdate>
                <twa>155</twa>
                <doe />
                <lasthearingtest>9/14/00</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>444-34-4422</ssn>
            </emp_details>
            <emp_test_data numtest="7">
                <test_record lasttest="0" currentbaseline="0" testid="54091" emp_id="10784" baseline="True" date="10/13/83" rt500="5" rt1k="10" rt2k="5" rt3k="5" rt4k="5" rt6k="15" rt8k="10" lt500="10" lt1k="15" lt2k="5" lt3k="15" lt4k="25" lt6k="15" lt8k="10" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="0" archived="False" eval="True" dev_nrr="" est_dne="155" need_dev_nrr="77" />
                <test_record lasttest="0" currentbaseline="1" testid="54124" emp_id="10784" baseline="True" date="7/19/93" rt500="10" rt1k="15" rt2k="10" rt3k="15" rt4k="30" rt6k="25" rt8k="20" lt500="25" lt1k="30" lt2k="35" lt3k="60" lt4k="60" lt6k="50" lt8k="35" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="7 - UNCLASSIFIED" sts="C" hearing_loss="SIG CHANGE" medical_referal="Y" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="155" need_dev_nrr="77" />
                <test_record lasttest="0" currentbaseline="0" testid="54092" emp_id="10784" baseline="False" date="10/16/98" rt500="10" rt1k="10" rt2k="10" rt3k="10" rt4k="30" rt6k="40" rt8k="40" lt500="20" lt1k="25" lt2k="55" lt3k="55" lt4k="60" lt6k="55" lt8k="60" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="7 - UNCLASSIFIED" sts="" hearing_loss="NO SIG CHANGE" medical_referal="Y" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="155" need_dev_nrr="77" />
                <test_record lasttest="0" currentbaseline="0" testid="54361" emp_id="10784" baseline="False" date="10/15/99" rt500="10" rt1k="10" rt2k="15" rt3k="15" rt4k="30" rt6k="40" rt8k="40" lt500="25" lt1k="30" lt2k="55" lt3k="50" lt4k="60" lt6k="60" lt8k="60" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="7 - UNCLASSIFIED" sts="" hearing_loss="NO SIG CHANGE" medical_referal="Y" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="155" need_dev_nrr="77" />
                <test_record lasttest="0" currentbaseline="0" testid="555" emp_id="10784" baseline="False" date="9/14/00 7:45:00 AM" rt500="10" rt1k="10" rt2k="10" rt3k="15" rt4k="40" rt6k="40" rt8k="35" lt500="25" lt1k="30" lt2k="55" lt3k="55" lt4k="60" lt6k="60" lt8k="60" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="01" hpd_name="MAX LITE CORDED" hpd_type="2" rating="7 - Unclassified" sts="" hearing_loss="Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="30" est_dne="132" need_dev_nrr="77" />
                <test_record lasttest="0" currentbaseline="0" testid="635" emp_id="10784" baseline="False" date="9/14/00 7:45:00 AM" rt500="10" rt1k="10" rt2k="10" rt3k="15" rt4k="40" rt6k="40" rt8k="35" lt500="25" lt1k="30" lt2k="55" lt3k="55" lt4k="60" lt6k="60" lt8k="60" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="01" hpd_name="MAX LITE CORDED" hpd_type="2" rating="7 - Unclassified" sts="" hearing_loss="Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="30" est_dne="132" need_dev_nrr="77" />
                <test_record lasttest="1" currentbaseline="0" testid="84192" emp_id="10784" baseline="False" date="3/19/02 11:29:00 AM" rt500="10" rt1k="10" rt2k="10" rt3k="15" rt4k="15" rt6k="10" rt8k="10" lt500="5" lt1k="15" lt2k="10" lt3k="20" lt4k="25" lt6k="30" lt8k="35" tech="Brad Watkins" cert_no="123643" audio_sn="1122343" audio_com="test" hpd_code="04" hpd_name="EAR TAPER FIT II" hpd_type="1" rating="2 - Slight" sts="No STS" hearing_loss="Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="32" est_dne="130" need_dev_nrr="77" />
            </emp_test_data>
        </employee>
        <employee emp_id="10785">
            <emp_details>
                <emp_id>10785</emp_id>
                <name_first>3WILLIAM S.</name_first>
                <name_last>3FCSELA</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>333-66-9333</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="No STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="20785">
            <emp_details>
                <emp_id>20785</emp_id>
                <name_first>4WILLIAM S.</name_first>
                <name_last>4JANDS</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>555-66-9662</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="No STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="30785">
            <emp_details>
                <emp_id>30785</emp_id>
                <name_first>5WILLIAM S.</name_first>
                <name_last>5James</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>555-66-1344</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="Unconfirmed STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="40785">
            <emp_details>
                <emp_id>40785</emp_id>
                <name_first>6WILLIAM S.</name_first>
                <name_last>6JONES</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>777-66-7777</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="No STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="50785">
            <emp_details>
                <emp_id>50785</emp_id>
                <name_first>7WILLIAM S.</name_first>
                <name_last>7Bates</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>888-66-9999</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="Unconfirmed STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="60785">
            <emp_details>
                <emp_id>60785</emp_id>
                <name_first>8WILLIAM S.</name_first>
                <name_last>8BRIAN</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>999-66-2332</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="No STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="70785">
            <emp_details>
                <emp_id>70785</emp_id>
                <name_first>9WILLIAM S.</name_first>
                <name_last>9BRIANT</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>383-66-1111</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="Unconfirmed STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="80785">
            <emp_details>
                <emp_id>80785</emp_id>
                <name_first>10WILLIAM S.</name_first>
                <name_last>10BURNS</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>111-66-1111</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="Confirmed STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="90785">
            <emp_details>
                <emp_id>90785</emp_id>
                <name_first>11WILLIAM S.</name_first>
                <name_last>BIFFF</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>111-66-1111</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="Confirmed STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
        <employee emp_id="00785">
            <emp_details>
                <emp_id>00785</emp_id>
                <name_first>12WILLIAM S.</name_first>
                <name_last>12LOST</name_last>
                <active>True</active>
                <male>True</male>
                <female>False</female>
                <birthdate>9/26/65</birthdate>
                <twa>0</twa>
                <doe />
                <lasthearingtest>11/4/99</lasthearingtest>
                <shift />
                <department>Thermal Paper</department>
                <bldg />
                <plant>West Carrollton Mill</plant>
                <clocknumber />
                <companyid>2</companyid>
                <ssn>222-66-2222</ssn>
            </emp_details>
            <emp_test_data numtest="4">
                <test_record lasttest="0" currentbaseline="1" testid="54182" emp_id="10785" baseline="True" date="3/8/85" rt500="0" rt1k="0" rt2k="-5" rt3k="0" rt4k="0" rt6k="0" rt8k="5" lt500="0" lt1k="0" lt2k="-5" lt3k="-5" lt4k="0" lt6k="0" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="BASELINE" medical_referal="" hp_needed="" test_type="1" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54541" emp_id="10785" baseline="False" date="11/3/98" rt500="10" rt1k="5" rt2k="0" rt3k="0" rt4k="0" rt6k="0" rt8k="15" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="5" lt6k="10" lt8k="0" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="2" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="0" currentbaseline="0" testid="54125" emp_id="10785" baseline="False" date="11/4/99" rt500="10" rt1k="5" rt2k="5" rt3k="0" rt4k="0" rt6k="5" rt8k="10" lt500="10" lt1k="5" lt2k="5" lt3k="5" lt4k="5" lt6k="10" lt8k="5" tech="" cert_no="" audio_sn="" audio_com="" hpd_code="" hpd_name="" hpd_type="" rating="1 - NORMAL" sts="" hearing_loss="NO SIG CHANGE" medical_referal="" hp_needed="" test_type="3" archived="False" eval="True" dev_nrr="" est_dne="0" need_dev_nrr="0" />
                <test_record lasttest="1" currentbaseline="0" testid="84194" emp_id="10785" baseline="False" date="3/19/02 11:33:00 AM" rt500="5" rt1k="5" rt2k="5" rt3k="5" rt4k="0" rt6k="0" rt8k="10" lt500="10" lt1k="5" lt2k="0" lt3k="5" lt4k="15" lt6k="10" lt8k="0" tech="Brad Watkins" cert_no="123643" audio_sn="33243" audio_com="test" hpd_code="02" hpd_name="PURA FIT W/CORD" hpd_type="2" rating="1 - Normal" sts="No STS" hearing_loss="No Significant Change" medical_referal="No" hp_needed="No - Current is adequate" test_type="" archived="False" eval="True" dev_nrr="31" est_dne="0" need_dev_nrr="0" />
            </emp_test_data>
        </employee>
    </employees>
</WA_Report>
0
bllwatkins
Asked:
bllwatkins
  • 4
1 Solution
 
b1xml2Commented:
Firstly, I am onto the problem.

Next, you really do not need to use the script extension. It slows down transformation. A pure XSLT solution is achievable.
0
 
b1xml2Commented:
XSLT Document
=============
<?xml version="1.0" encoding="iso-8859-1"?>
<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="html" indent="yes" encoding="iso-8859-1" />
<xsl:template match="/">
<html>
<head>
<title>WebAudi Reports - Audiometric Test Report</title>
<style>
<![CDATA[
body {margin:0px;}
a {text-decoration:none;}
a img {border-style:none;border-width:0px;}
.fontColor10 {font-size:10pt;font-family:Times New Roman;font-weight:bold;}
.fontColor11 {font-size:9pt;font-family:Times New Roman;}
.fontColor12 {font-size:8pt;font-family:Times New Roman;}
.fontColor13 {font-size:8pt;font-family:Times New Roman;font-weight:bold;}
.fontColor14 {font-size:9pt;font-family:Times New Roman;}
.fontColor15 {font-size:6pt;font-family:Times New Roman;}
.fontColor16 {font-size:6pt;font-family:LinePrinter;}
.fontColor17 {font-size:7pt;font-family:Times New Roman;}
.fontColor18 {font-size:7pt;font-family:LinePrinter;}
.adornment10 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-width:0px;border-top-width:0px;border-right-width:0px;}
.adornment11 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-width:0px;border-top-style:solid;border-top-color:#000000;border-top-width:1px;border-right-width:0px;}
.adornment12 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-style:solid;border-left-color:#000000;border-left-width:1px;border-top-width:0px;border-right-width:0px;}
.adornment13 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-width:0px;border-top-style:solid;border-top-color:#000000;border-top-width:1px;border-right-width:0px;}
.adornment14 {border-color:#000000;border-style:none;border-bottom-style:solid;border-bottom-color:#000000;border-bottom-width:1px;border-left-style:solid;border-left-color:#000000;border-left-width:1px;border-top-style:solid;border-top-color:#000000;border-top-width:1px;border-right-style:solid;border-right-color:#000000;border-right-width:1px;}
.rightSingle {border-color:#000000;border-style:none;border-bottom-style:none;border-bottom-color:#000000;border-bottom-width:0px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:none;border-top-color:#000000;border-top-width:0px;border-right-style:solid;border-right-color:#000000;border-right-width:1px;}
.noBorder {border-color:#000000;border-style:none;border-bottom-style:none;border-bottom-color:#000000;border-bottom-width:0px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:none;border-top-color:#000000;border-top-width:0px;border-right-style:none;border-right-color:#000000;border-right-width:0px;}
.topSingle {border-color:#000000;border-style:none;border-bottom-style:none;border-bottom-color:#000000;border-bottom-width:0px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:single;border-top-color:#000000;border-top-width:1px;border-right-style:none;border-right-color:#000000;border-right-width:1px;}
.top_Bot_Single {border-color:#000000;border-style:none;border-bottom-style:single;border-bottom-color:#000000;border-bottom-width:1px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:single;border-top-color:#000000;border-top-width:1px;border-right-style:none;border-right-color:#000000;border-right-width:1px;}
]]>
</style>
</head>
<body>
<xsl:call-template name="header" />
<xsl:call-template name="company" />
<xsl:apply-templates
 select="WA_Report/employees[employee/emp_test_data/@numtest[. &gt; 1]]"
 mode="classification1" />
<xsl:call-template name="classification2" />
<xsl:call-template name="classification3" />
</body>
</html>
</xsl:template>

<xsl:template name="header">
<p class="paragraph" align="Center">
<table border="0" width="680px">
<tr><td class="fontColor10" align="center">AUDIOMETRIC CLASSIFICATION REPORT (Annual)</td></tr>
<tr><td class="fontColor11" align="center">Audiological Services</td></tr>
</table>
</p>
</xsl:template>

<xsl:template match="employees" mode="classification1">
<xsl:call-template name="classification1" />
<!--create new document fragment-->
<xsl:variable name="employees-class1">
      <xsl:for-each select="employee[emp_test_data/test_record[last()][@lasttest='1' and @sts='No STS']]">
      <xsl:sort select="emp_details/name_last" />
      <xsl:copy-of select="." />
      </xsl:for-each>
</xsl:variable>
<p align="center">
<table width="680px" border="0px" bordercolor="white" cellpadding="0" cellspacing="0">
<xsl:for-each select="msxsl:node-set($employees-class1)/employee[position() mod 2 = 1]">
<xsl:variable name="pos" select="position() * 2 - 1" />
      <tr>
            <td><xsl:value-of select="concat($pos,' - ',emp_details/name_last,', ',emp_details/name_first)" /></td>
            <td>
            <xsl:choose>
            <xsl:when test="following-sibling::employee[1]">
            <xsl:value-of select="concat($pos + 1,' - ',following-sibling::employee[1]/emp_details/name_last,', ',following-sibling::employee[1]/emp_details/name_first)" />
            </xsl:when>
            <xsl:otherwise>&#160;</xsl:otherwise>
            </xsl:choose>
            </td>
      </tr>
</xsl:for-each>
</table>
<hr align="center" width="680px" />
<table width="680px">
<tr>
<td align="center">Total employees in this classification:
<strong><xsl:value-of select="count(msxsl:node-set($employees-class1)/employee)" /></strong>
</td>
</tr>
</table>
</p>
</xsl:template>

<!--classification templates-->
<xsl:template name="classification1">
<p class="paragraph" align="Center">
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
<tr bordercolor="white">
<td>
STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95 - April 18, 1983,
is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative to the baseline
audiograms in either ear. The annual or monitored audiometric exams for the following employees showed
NO STANDARD THRESHOLD SHIFT
</td>
</tr>
</table>
</p>
</xsl:template>

<xsl:template name="classification2">
<p class="paragraph" align="Center">
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
<tr bordercolor="white">
      <td>
      <table>
            <tr>
                  <td colspan="2">STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95
                  - April 18, 1983, is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative
                  to the baseline audiograms in either ear. The annual or monitored audiometric exams for the following
                  employees showed a <strong><u>STANDARD THRESHOLDS SHIFT HAS OCCURRED</u></strong>.
                  As required by OSHA and recommended by our office, these employees have had a follow-up
                  audiogram within 30 days to establish the validity of the actual current hearing threshold levels. Thusly,
                  the establishment of new thresholds have been recorded at this time. Again, as defined by OSHA, these
                  employees:
                  </td>
            </tr>
            <tr>
                  <td width="20"></td>
                  <td>(1) must be re-informed and re-educated concerning the importance of hearing conservation
                  both on and off the job:</td>
            </tr>
            <tr>
                  <td width="20"></td>
                  <td>(2) must be re-instructed on proper use and insertion of hearing protectors;</td>
            </tr>
            <tr>
                  <td width="20"></td>
                  <td>(3) if current hearing protection is being utilized properly, the reissuance of new
                  hearing protection devices with a greater NRR is advised;</td>
            </tr>
            <tr>
                  <td width="20"></td>
                  <td>(4) if for some reason all these measures are unobtainable, the relocation of the
                  employee to a reduced noise area must be considered.</td>
            </tr>
            </table>
      </td>
</tr>
</table>
</p>
</xsl:template>

<xsl:template name="classification3">
<p class="paragraph" align="Center">
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
<tr bordercolor="white">
<td>STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95 - April 18, 1983,
is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative to the baseline
audiograms in either ear. The annual or monitored audiometric exams for the following employees showed
an <strong><u>UN-CONFIRMED STANDARD THRESHOLD SHIFT HAS OCCURRED</u></strong>.
It is required by OSHA and recommended by our office that these employees have a follow-up
audiogram within 30 days to validate the monitored audiometric examination. Please advise the physician's
office to send Audiological Services a copy of the test data for comparative study.
</td>
</tr>
</table>
</p>
</xsl:template>
<!--end of classification templates-->


<!--start of templates providing company information-->
<xsl:template name="company">
<p class="paragraph" align="Center">
<table width="680px">
<tr><td align="left" class="fontColor12">Company Information</td></tr>
</table>
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="120">
<tr bordercolor="white">
      <td valign="top" width="90" class="fontColor13">Company:<br />Address:</td>
      <xsl:apply-templates select="WA_Report/CompanyINFO" />
      <xsl:apply-templates select="WA_Report" mode="first-header" />
</tr>
<tr bordercolor="white">
      <xsl:apply-templates select="WA_Report/ReportSpecs/ReportDates" />
</tr>
</table>
</p>
</xsl:template>

<xsl:template match="CompanyINFO">
<td valign="top" width="300" class="fontColor14">
<xsl:value-of select="CompanyName" /><br />
<xsl:value-of select="Address1" /><br />
<xsl:value-of select="Address2" /><br />
<xsl:value-of select="concat(City,', ',State,' ',ZipCode)" />  
</td>
</xsl:template>

<xsl:template match="WA_Report" mode="first-header">
<td valign="top" width="290">
<span class="fontColor13">Report Date: </span>
<span class="fontColor12"><xsl:value-of select="ReportSpecs/@dategenerated" /></span>
<br />
<br />
<span class="fontColor13">Number of Employees on this Report:</span>
<span class="fontColor12"><xsl:value-of select="count(employees/employee)" /></span>
</td>
</xsl:template>

<xsl:template match="ReportDates">
<td colspan="3" width="680" class="fontColor12">
This report includes employees tested from
<xsl:value-of select="concat(DateBegin,' to ',DateEnd)" />
</td>
</xsl:template>
<!--end of templates providing company information-->

</xsl:stylesheet>
0
 
b1xml2Commented:
The HTML Output
===============
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>WebAudi Reports - Audiometric Test Report</title>
<style>
body {margin:0px;}
a {text-decoration:none;}
a img {border-style:none;border-width:0px;}
.fontColor10 {font-size:10pt;font-family:Times New Roman;font-weight:bold;}
.fontColor11 {font-size:9pt;font-family:Times New Roman;}
.fontColor12 {font-size:8pt;font-family:Times New Roman;}
.fontColor13 {font-size:8pt;font-family:Times New Roman;font-weight:bold;}
.fontColor14 {font-size:9pt;font-family:Times New Roman;}
.fontColor15 {font-size:6pt;font-family:Times New Roman;}
.fontColor16 {font-size:6pt;font-family:LinePrinter;}
.fontColor17 {font-size:7pt;font-family:Times New Roman;}
.fontColor18 {font-size:7pt;font-family:LinePrinter;}
.adornment10 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-width:0px;border-top-width:0px;border-right-width:0px;}
.adornment11 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-width:0px;border-top-style:solid;border-top-color:#000000;border-top-width:1px;border-right-width:0px;}
.adornment12 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-style:solid;border-left-color:#000000;border-left-width:1px;border-top-width:0px;border-right-width:0px;}
.adornment13 {border-color:#000000;border-style:none;border-bottom-width:0px;border-left-width:0px;border-top-style:solid;border-top-color:#000000;border-top-width:1px;border-right-width:0px;}
.adornment14 {border-color:#000000;border-style:none;border-bottom-style:solid;border-bottom-color:#000000;border-bottom-width:1px;border-left-style:solid;border-left-color:#000000;border-left-width:1px;border-top-style:solid;border-top-color:#000000;border-top-width:1px;border-right-style:solid;border-right-color:#000000;border-right-width:1px;}
.rightSingle {border-color:#000000;border-style:none;border-bottom-style:none;border-bottom-color:#000000;border-bottom-width:0px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:none;border-top-color:#000000;border-top-width:0px;border-right-style:solid;border-right-color:#000000;border-right-width:1px;}
.noBorder {border-color:#000000;border-style:none;border-bottom-style:none;border-bottom-color:#000000;border-bottom-width:0px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:none;border-top-color:#000000;border-top-width:0px;border-right-style:none;border-right-color:#000000;border-right-width:0px;}
.topSingle {border-color:#000000;border-style:none;border-bottom-style:none;border-bottom-color:#000000;border-bottom-width:0px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:single;border-top-color:#000000;border-top-width:1px;border-right-style:none;border-right-color:#000000;border-right-width:1px;}
.top_Bot_Single {border-color:#000000;border-style:none;border-bottom-style:single;border-bottom-color:#000000;border-bottom-width:1px;border-left-style:none;border-left-color:#000000;border-left-width:0px;border-top-style:single;border-top-color:#000000;border-top-width:1px;border-right-style:none;border-right-color:#000000;border-right-width:1px;}
 </style>
</head>
<body>
<p class="paragraph" align="Center">
<table border="0" width="680px">
<tr><td class="fontColor10" align="center">AUDIOMETRIC CLASSIFICATION REPORT (Annual)</td></tr>
<tr><td class="fontColor11" align="center">Audiological Services</td></tr>
</table>
</p>
<p class="paragraph" align="Center">
<table width="680px">
<tr><td align="left" class="fontColor12">Company Information</td></tr>
</table>
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="120">
<tr bordercolor="white">
<td valign="top" width="90" class="fontColor13">Company:<br>Address:</td>
<td valign="top" width="300" class="fontColor14">Brad Papers, inc.<br>BW PO Box 633<br>Thermal Paper Division2<br>JonesTown, NW 29633</td>
<td valign="top" width="290"><span class="fontColor13">Report Date: </span><span class="fontColor12">3/21/02</span><br><br><span class="fontColor13">Number of Employees on this Report:</span><span class="fontColor12">12</span></td>
</tr>
<tr bordercolor="white">
<td colspan="3" width="680" class="fontColor12">
This report includes employees tested from
3/19/02 12:00:01 AM to 3/19/02 11:59:59 PM</td>
</tr>
</table>
</p>
<p class="paragraph" align="Center">
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
<tr bordercolor="white">
<td>
STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95 - April 18, 1983,
is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative to the baseline
audiograms in either ear. The annual or monitored audiometric exams for the following employees showed
NO STANDARD THRESHOLD SHIFT
</td>
</tr>
</table>
</p>
<p align="center">
<table width="680px" border="0px" bordercolor="white" cellpadding="0" cellspacing="0">
<tr>
<td>1 - 12LOST, 12WILLIAM S.</td>
<td>2 - 1FIDDFEARRIS, 1DAVID T.</td>
</tr>
<tr>
<td>3 - 2BFFIELDS, 2ARTHUR</td>
<td>4 - 3FCSELA, 3WILLIAM S.</td>
</tr>
<tr>
<td>5 - 4JANDS, 4WILLIAM S.</td>
<td>6 - 6JONES, 6WILLIAM S.</td>
</tr>
<tr>
<td>7 - 8BRIAN, 8WILLIAM S.</td>
<td> </td>
</tr>
</table>
<hr align="center" width="680px">
<table width="680px">
<tr>
<td align="center">Total employees in this classification:
<strong>7</strong></td>
</tr>
</table>
</p>
<p class="paragraph" align="Center">
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
<tr bordercolor="white">
<td>
<table>
<tr>
<td colspan="2">STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95
                  - April 18, 1983, is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative
                  to the baseline audiograms in either ear. The annual or monitored audiometric exams for the following
                  employees showed a <strong><u>STANDARD THRESHOLDS SHIFT HAS OCCURRED</u></strong>.
                  As required by OSHA and recommended by our office, these employees have had a follow-up
                  audiogram within 30 days to establish the validity of the actual current hearing threshold levels. Thusly,
                  the establishment of new thresholds have been recorded at this time. Again, as defined by OSHA, these
                  employees:
                  </td>
</tr>
<tr>
<td width="20"></td>
<td>(1) must be re-informed and re-educated concerning the importance of hearing conservation
                  both on and off the job:</td>
</tr>
<tr>
<td width="20"></td>
<td>(2) must be re-instructed on proper use and insertion of hearing protectors;</td>
</tr>
<tr>
<td width="20"></td>
<td>(3) if current hearing protection is being utilized properly, the reissuance of new
                  hearing protection devices with a greater NRR is advised;</td>
</tr>
<tr>
<td width="20"></td>
<td>(4) if for some reason all these measures are unobtainable, the relocation of the
                  employee to a reduced noise area must be considered.</td>
</tr>
</table>
</td>
</tr>
</table>
</p>
<p class="paragraph" align="Center">
<table cellpadding="6" cellspacing="1" bordercolor="black" border="1" width="680px" height="50">
<tr bordercolor="white">
<td>STANDARD THRESHOLD SHIFT, as defined by OSHA Proposal 29 CFR, Part 1910.95 - April 18, 1983,
is an average shift of more than 10dB at frequencies of 2000, 3000, and 4000 Hz relative to the baseline
audiograms in either ear. The annual or monitored audiometric exams for the following employees showed
an <strong><u>UN-CONFIRMED STANDARD THRESHOLD SHIFT HAS OCCURRED</u></strong>.
It is required by OSHA and recommended by our office that these employees have a follow-up
audiogram within 30 days to validate the monitored audiometric examination. Please advise the physician's
office to send Audiological Services a copy of the test data for comparative study.
</td>
</tr>
</table>
</p>
</body>
</html>
0
 
b1xml2Commented:
Notes
=====
1. Templates have been broken into smaller components for easier maintenance and readability.

2. casing of all elements are lower-case. It is really bad practice to vary the casing of the HTML elements.

3.

>>
The xsl below is partial working.  In the first section "Class1" I'm selecting all employees who have
MORE than one test.  Then there is another filter on those, I'm need to display only the employees who
LAST test has an "STS" attribute value of "No STS".
<<

There are 7 employees that have more than one test and the LAST test having an STS attribute value of "No STS"

Regards,

Brandon Driesen
0
 
bllwatkinsAuthor Commented:
Brandon did an excellent job redefining my layout to provide the format I needed.  Thanks Again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now