Thanks for the help but as I am not a excel guru I need a little more help.
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="Preview" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_preview.wmf"><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Version>12.00</o:Version> </o:DocumentProperties> </xml><![endif]--><link rel="themeData" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-536870145 1107305727 0 0 415 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:478117107; mso-list-type:hybrid; mso-list-template-ids:207919820 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;} @list l0:level1 {mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> Sheet A
<table class="MsoNormalTable" style="width: 518pt; margin-left: 4.4pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="691"> <tbody><tr style="height: 39.75pt;"> <td style="width: 74pt; border: 1pt solid windowtext; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="99">
[FONT="]Room #[/FONT][FONT="]<o></o>[/FONT]
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="111">
[FONT="]Cube #[/FONT][FONT="]<o></o>[/FONT]
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="111">
[FONT="]Old jack #[/FONT][FONT="]<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="80">
[FONT="]X-con Y/N[/FONT][FONT="]<o></o>[/FONT]
</td> <td style="width: 98pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="131">
[FONT="]Switch ID / port[/FONT][FONT="]<o></o>[/FONT]
</td> <td style="width: 120pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="160">
[FONT="]Device ID (NWAM#)[/FONT][FONT="]<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]415<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT="] <o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6235<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1905803<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]415<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT="] <o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6236<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="] <o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]416<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT="] <o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6287<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1056562<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]417<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT="] <o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6288<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1056202<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]418<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT="] <o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6286<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1056349<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]420<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT="] <o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6289<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1056563<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]421<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT="] <o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6290<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1093103<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]425<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]1<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6246<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1092895<o></o>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]425<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]2<o
></o
>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]6245<o></o>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT="] <o></o>[/FONT]
</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT="]1905835[/FONT][FONT="]<o></o>[/FONT]
</td> </tr> </tbody></table> <o
> </o
>
Sheet B
<table class="MsoNormalTable" style="width: 370.4pt; margin-left: 4.85pt; border-collapse: collapse; border: medium none;" border="1" cellpadding="0" cellspacing="0" width="494"> <tbody><tr style="height: 51.8pt;"> <td style="width: 74.25pt; border: 1pt solid windowtext; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="99">
[FONT="]Current NTWK Drop<o></o>[/FONT]
</td> <td style="width: 147.65pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="197">
[FONT="]Current DNS Name<o></o>[/FONT]
</td> <td style="width: 74.25pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="99">
[FONT="]Room #<o></o>[/FONT]
</td> <td style="width: 74.25pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="99">
[FONT="]Cube #<o></o>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6126<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwks133.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]112<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]4<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
lvkbarbercoleman.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvk01la-03.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6062<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
lvkmedrpt1.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]013<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]2<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvk01la-04.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6177<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
lvkmedrpt2.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]013<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]2<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6200<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1817046.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]135a<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]2<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6057<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1847576.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]112<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]3<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6036<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1850699.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]108<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]2<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6176<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1901674.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]013<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]2<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6031<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1036158.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]012<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]1<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6198<o></o>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1905849.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]135<o
></o
>[/FONT]
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT="]3<o
></o
>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam
1905835.some.domain.com<o
></o
>
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> </tbody></table> <o
> </o
>
The End result would then look like the below:
<table class="MsoNormalTable" style="width: 5.75in; margin-left: 4.4pt; border-collapse: collapse; border: medium none;" border="1" cellpadding="0" cellspacing="0" width="552"> <tbody><tr style="height: 15pt;"> <td style="width: 83pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="111">
6245
<o></o>
</td> <td style="width: 165pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="220">
nwlvkam1905835.some.domain.com<o
></o
>
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]425<o></o>[/FONT]
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT="]2<o></o>[/FONT]
</td> </tr> </tbody></table> <o
> </o
>
Here is an example of my data that I have to work with. So from SheetA we have column “Devicename” in SheetB we have “Current DNS Name”.
<o
> </o
>
From SheetA you have columns “cube” and “old jack” both of these are important information that I would like to keep.
So I am trying to do a few things:
<!--[if !supportLists]-->1. <!--[endif]-->I am trying to compare and match SheetA “Devicename” column with SheetB “Current DNS Name” and finding matches for the numbers only and ignoring the text.
<!--[if !supportLists]-->2. <!--[endif]-->Once find the match fill out the corresponding cells.
So lets say we key on
1905835match on and I do a search in SheetB I would then manually fill in the “Current NTWK Drop” with the corresponding “Old Jack#” as well “Cube” and “Room”.
So I would like to bring both documents up I already have a macro that I can merge the two spreadsheets creating two separate workbooks so as to just work from one file. But the main goal is to automate that manual process I just described. I have over 500 device I have to line by doing a find and then manually entering the data in the appropriate columns.. as you can see this can lead to multiple input errors as well as time consuming?
I want this process to be a repeatable process because I have about 11 more sites that will go through this same rework each site having 500 or more devices each.
I hope this make it a bit clearer as to what I am trying to accomplish.
Thank you in advance for any assistance anyone can give.
R