Returning the smallest difference

geologist

New Member
Joined
Sep 22, 2011
Messages
2
Hi I have the following data:

<table border="0" cellpadding="0" cellspacing="0" width="745"><colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="width:48pt" span="6" width="64"> <col style="mso-width-source:userset;mso-width-alt:5376;width:110pt" width="147"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:93pt;font-size:11.0pt; color:white;font-weight:700;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border-top:.5pt solid black; border-right:none;border-bottom:none;border-left:.5pt solid black;background: black;mso-pattern:black none" height="20" width="124">Sample Number</td> <td style="width:48pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none;background:black;mso-pattern:black none" width="64">Hole Number</td> <td style="width:48pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none;background:black;mso-pattern:black none" width="64">From</td> <td style="width:48pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none;background:black;mso-pattern:black none" width="64">To</td> <td style="width:48pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none;background:black;mso-pattern:black none" width="64">Thickness</td> <td style="width:48pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none;background:black;mso-pattern:black none" width="64">Core Loss</td> <td style="width:48pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none;background:black;mso-pattern:black none" width="64">% Recovery</td> <td style="width:110pt;font-size:11.0pt;color:white;font-weight: 700;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none;background:black;mso-pattern:black none" width="147">Seam Name and Ply</td> <td style="width:68pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:.5pt solid black; border-bottom:none;border-left:none;background:black;mso-pattern:black none" width="90">COLUMN 1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_GT001</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">42.5</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">42.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.22</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_GT002</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">45.27</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">45.42</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.15</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_GT003</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">52.09</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">52.34</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.25</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_CR001</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">52.34</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">52.59</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.25</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20">SAMPLE_QP001</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">52.59</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">52.67</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.08</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D Upper</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP002</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">52.67</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">53.23</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.56</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D Upper</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP003</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">53.23</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">54.15</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.92</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D Upper</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP003</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">54.15</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">54.42</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.27</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> DU</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_CF001</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">54.42</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">54.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.3</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_GT004</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">54.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">55.03</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.31</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_GT005</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">60.18</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">60.42</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.24</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_CR002</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">60.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">60.77</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.05</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP004</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">60.77</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">61.04</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.27</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower middle</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP005</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">61.04</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">61.69</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.65</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower middle</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP006</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">61.69</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">61.82</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.13</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower middle</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP007</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">61.82</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">62.25</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.43</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower middle</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP008</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">62.25</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">62.38</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.13</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower middle</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP009</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">62.38</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">62.58</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.2</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP010</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">62.58</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.31</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.73</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower 1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP010</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.31</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.34</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.03</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> DL1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP011</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.34</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.63</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.29</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower 1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP012</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.63</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.09</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower 1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_QP013</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">63.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">64.44</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none"> D lower 2</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:.5pt solid black" height="20"> SAMPLE_CF002</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">64.44</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">64.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0.28</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: none;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:none;border-left: none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:none; border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: .5pt solid black;border-left:.5pt solid black" height="20"> SAMPLE_GT006</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:.5pt solid black; border-left:none">SAMPLECORR_raw</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: .5pt solid black;border-left:none" align="right">64.72</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: .5pt solid black;border-left:none" align="right">65.19</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: .5pt solid black;border-left:none" align="right">0.47</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: .5pt solid black;border-left:none" align="right">0</td> <td style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid black;border-right:none;border-bottom: .5pt solid black;border-left:none" align="right">100</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:none;border-bottom:.5pt solid black; border-left:none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:.5pt solid black;border-right:.5pt solid black;border-bottom:.5pt solid black; border-left:none">
</td> </tr> </tbody></table>
In column 1 I want (for the samples that don't have a seam name) the distance from the bottom of the sample to the top/bottom of the nearest sample with a seam name. I want to be able to do this without the need to keep on retyping the seam names!

i.e. for the first 3, the results would be:

Thanks in advanced

<table border="0" cellpadding="0" cellspacing="0" width="90"><colgroup><col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:68pt; font-size:11.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Calibri;border-top:.5pt solid black; border-right:.5pt solid black;border-bottom:none;border-left:none" align="right" height="20" width="90">9.87</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:.5pt solid black;border-right:.5pt solid black; border-bottom:none;border-left:none" align="right" height="20">7.25</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:.5pt solid black;border-right:.5pt solid black; border-bottom:none;border-left:none" align="right" height="20">0.89
</td> </tr> </tbody></table>
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Can you provide some clarity.

None of the samples have the same name.

Could you provide the equation you used including the real measurements for the result you gave of SAMPLE_GT001 = 9.87

I cannot see were that came from.
I am assuming it is core length and ''from'' is the start and ''to'' is the end.

Also are these cores only a few mm long or cm? What are your units, just so myself and others can grasp what you are trying to achieve.
 
Last edited:
Upvote 0
Hi,

to put it simply I want to get the distance between the bottom of a sample and the top of the nearest sample that also has a seam name.

I got 9.87 by minusing the top of sample_QP001 (which is the first sample beneath GT001 which has a seam name) with the bottom depth of GT001.

If the sample is closer to a seam above it, than it is to the seam below it, I want that value in stead.

The units are meters

Thanks
 
Upvote 0
Hi,

to put it simply I want to get the distance between the bottom of a sample and the top of the nearest sample that also has a seam name.

I got 9.87 by minusing the top of sample_QP001 (which is the first sample beneath GT001 which has a seam name) with the bottom depth of GT001.

If the sample is closer to a seam above it, than it is to the seam below it, I want that value in stead.

The units are meters

Thanks

Try to make it more simpler...

The contents of which cells have you used?
 
Upvote 0
I think you should try this formula, considering your data table starts from A1 as per the above example, insert the below formula in cell J2 and drag the formula down.

=VLOOKUP(SUBSTITUTE(A2,"GT","QP"),$A:$I,3,0)-D2
 
Upvote 0

Forum statistics

Threads
1,214,819
Messages
6,121,749
Members
449,050
Latest member
excelknuckles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top