Solved

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

Posted on 2002-04-09
5
270 Views
Last Modified: 2006-11-17
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
Comment
Question by:bllwatkins
  • 4
5 Comments
 
LVL 23

Expert Comment

by:b1xml2
ID: 6930509
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
 
LVL 23

Expert Comment

by:b1xml2
ID: 6930577
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
 
LVL 23

Expert Comment

by:b1xml2
ID: 6930582
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
 
LVL 23

Accepted Solution

by:
b1xml2 earned 300 total points
ID: 6930670
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
 

Author Comment

by:bllwatkins
ID: 6932163
Brandon did an excellent job redefining my layout to provide the format I needed.  Thanks Again.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now