Hi
I have many files with various outputs (.AVI, .PDF, etc). I want the hyperlink to only show if the file has the specific file located in the folder.
FOR example below the 105208-001 only has associated docs of 2d and 3d so I only want to show those. It does not have a proceudre or datasheet so I do not want to see that link to avoid confusion.
I have tried various solutions with no success. I don't know if this needs a true/flalse Macro statement or not.
=HYPERLINK("\\File\Scarlet\DOCUMENTATION\PROCEDURE\"&G2&".PDF","PROCEDURE")
=IF(G2="\\File\Scarlet\DOCUMENTATION\PDF\"&G2&".PDF",HYPERLINK("\\File\Scarlet\DOCUMENTATION\PDF\"&G2&".PDF","2D DWG"),"")
<TABLE style="WIDTH: 665pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=886><COLGROUP><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><COL style="WIDTH: 12pt; mso-width-source: userset; mso-width-alt: 585" width=16><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 7pt; mso-width-source: userset; mso-width-alt: 329" span=2 width=9><COL style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 658" width=18><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" width=40><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4388" width=120><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" width=28><COL style="WIDTH: 3pt; mso-width-source: userset; mso-width-alt: 146" width=4><TBODY><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; WIDTH: 41pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl82 height=21 width=55> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 42pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" id=td_post_1369987 class=xl83 width=56> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 22pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=29> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 12pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=16> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 38pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=51> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=65> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 80pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl84 width=107> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 7pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=9> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 7pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=9> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 14pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=18> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 50pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=67> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=40> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 90pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl85 width=120> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #ddd9c3; WIDTH: 183pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl116 rowSpan=2 width=244 colSpan=5>ASSOCIATED DOCUMENTS</TD></TR><TR style="HEIGHT: 29.25pt; mso-height-source: userset" height=39><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; HEIGHT: 29.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl86 height=39></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl66> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl66>TYPE IN PART # REQUIRED:</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #fcd5b4; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl122 colSpan=2>105208-001</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl124 colSpan=5>105208-001</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl86 height=20 colSpan=13>.</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl90> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl91> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl91> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl94 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl95 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" class=xl67 height=40 colSpan=3>Item Description:</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" class=xl72 colSpan=3>Front Panel Assy W/ Display, VR725, Rev D</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl74> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>PROCEDURE</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl96 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl97 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; HEIGHT: 30pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl87 height=40> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl88> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>2D DWG</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl96 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl97 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Revision:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl76> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl78>D</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Qty On Hand:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>1</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>3D ASSEMBLED MODEL</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl96 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl97 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Product Category:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl78>06R</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Qty On Order:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>5</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>3D ASSEMBLY MOVIE</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Serialized:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl78>N</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Qty Allocated:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>5</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; WIDTH: 26pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl93 width=35> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>DATASHEET</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Stocked:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl78>Y</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Location:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>0</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Controlled:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl81>Y</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl69 colSpan=7> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl106 width=177 colSpan=2> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>UPC:</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl77> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl113 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl103 colSpan=7> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl100> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl126 width=177 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl101> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl102> </TD></TR></TBODY></TABLE>
I have many files with various outputs (.AVI, .PDF, etc). I want the hyperlink to only show if the file has the specific file located in the folder.
FOR example below the 105208-001 only has associated docs of 2d and 3d so I only want to show those. It does not have a proceudre or datasheet so I do not want to see that link to avoid confusion.
I have tried various solutions with no success. I don't know if this needs a true/flalse Macro statement or not.
=HYPERLINK("\\File\Scarlet\DOCUMENTATION\PROCEDURE\"&G2&".PDF","PROCEDURE")
=IF(G2="\\File\Scarlet\DOCUMENTATION\PDF\"&G2&".PDF",HYPERLINK("\\File\Scarlet\DOCUMENTATION\PDF\"&G2&".PDF","2D DWG"),"")
<TABLE style="WIDTH: 665pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=886><COLGROUP><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><COL style="WIDTH: 12pt; mso-width-source: userset; mso-width-alt: 585" width=16><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 7pt; mso-width-source: userset; mso-width-alt: 329" span=2 width=9><COL style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 658" width=18><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" width=40><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4388" width=120><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" width=28><COL style="WIDTH: 3pt; mso-width-source: userset; mso-width-alt: 146" width=4><TBODY><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; WIDTH: 41pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl82 height=21 width=55> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 42pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" id=td_post_1369987 class=xl83 width=56> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 22pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=29> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 12pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=16> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 38pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=51> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 49pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=65> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 80pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl84 width=107> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 7pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=9> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 7pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=9> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 14pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=18> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 50pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=67> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl83 width=40> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; WIDTH: 90pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl85 width=120> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #ddd9c3; WIDTH: 183pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl116 rowSpan=2 width=244 colSpan=5>ASSOCIATED DOCUMENTS</TD></TR><TR style="HEIGHT: 29.25pt; mso-height-source: userset" height=39><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; HEIGHT: 29.25pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl86 height=39></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl66> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl66>TYPE IN PART # REQUIRED:</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #fcd5b4; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl122 colSpan=2>105208-001</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl124 colSpan=5>105208-001</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl86 height=20 colSpan=13>.</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl90> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl91> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl91> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl94 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl95 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" class=xl67 height=40 colSpan=3>Item Description:</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan" class=xl72 colSpan=3>Front Panel Assy W/ Display, VR725, Rev D</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #d4d0c8" class=xl73> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl74> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>PROCEDURE</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl96 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl97 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #a5a5a5; HEIGHT: 30pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl87 height=40> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl88> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>2D DWG</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl96 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl97 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Revision:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl76> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl78>D</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl69> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Qty On Hand:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>1</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>3D ASSEMBLED MODEL</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 21pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl96 width=28> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 3pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl97 width=4> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Product Category:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl78>06R</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Qty On Order:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>5</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>3D ASSEMBLY MOVIE</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Serialized:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl78>N</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Qty Allocated:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>5</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; WIDTH: 26pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl93 width=35> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2>DATASHEET</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Stocked:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl78>Y</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl75>Location:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl109 colSpan=2>0</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl89> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl127 width=177 colSpan=2> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>Controlled:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl79> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl81>Y</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl80> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl69 colSpan=7> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl92> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl106 width=177 colSpan=2> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl98> </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl99> </TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; HEIGHT: 30pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl67 height=40 colSpan=3>UPC:</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl77> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #538ed5; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl113 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 1pt solid" class=xl103 colSpan=7> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl100> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; WIDTH: 133pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl126 width=177 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl101> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl102> </TD></TR></TBODY></TABLE>
