Column Compare

rabalam

New Member
Joined
Aug 9, 2010
Messages
9
So I will try and explain to my best ability as to what I am trying to acomplish.

U have two sepreate spreadsheet for name sake we'll call them SheetA and SheetB.

I have information in Column a, b, C, and D in sheetA
I have information in Column a, B, c in sheetB

The format of information on sheetA column A 1901234 unsorted

The format of the information on sheet be column A abcdefg1901234 unsorted

I am tryin to compare the two documents and the columns and actully try and match them up so that they can appear in one document side by side.

I am curently going line by line from sheet A doing a search and find and the equivalent last 7 digits and adding the information maually. Well I have over 500 devices I have to this for. I knwo there got to be a short cut. Any help would be greatly appreciated.

Thanks,
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

rconverse

Well-known Member
Joined
Nov 29, 2007
Messages
1,185
If you're always looking to match the last x numbers in your second column, you can use the right formula in column C. This takes the length of column A, and pulls that number of digits from B1.

=RIGHT(B1, LEN(A1))

Then you can create a VLOOKUP and just use that to find matches.

HTH,
Roger
 

tc200505

New Member
Joined
Mar 7, 2010
Messages
28
First the Assumptions:
1. Sheet from which the data will be extracted is named "SheetB"
2. SheetB contains the data in column A and upto row 500.
3. SheetA needs to be populated, column A already contains values and column B will be populated based on these values.

On SheetA, enter the following array formula:

=INDEX(SheetB!$A$1:$A$500,MATCH(VLOOKUP(A1,(RIGHT(SheetB!$A$1:$A$500,7)*1),1,FALSE),(RIGHT(SheetB!$A$1:$A$500,7)*1),0),1)

Make sure that after entering this formula,you do not hit just enter but Ctrl+Shift+Enter together since this is an array formula.

Cheers,
tc
 

tc200505

New Member
Joined
Mar 7, 2010
Messages
28
Also, if you only want to return the corresponding values then the formula would be:

=VLOOKUP(A3,(RIGHT(SheetB!$A$2:$C$27,7)*1),2,0)

Kindly note, as per my previous post, that this too is an array formula and therefore enter the formula with Ctrl+Shift+Enter

tc
 

mgirvin

Well-known Member
Joined
Dec 15, 2005
Messages
1,213

ADVERTISEMENT

If you had the values:
Excel Workbook
A
11901234
21010109
31587336
SheetA


and the values:
Excel Workbook
A
1dssddsd1010109
2ssqewq1587336
3abcdefg1901234
SheetB


and you wanted to take the items on SheetA as the lookup values that would allow you to find a value from SheetB and return them to SheetA, maybe this will work:
Excel Workbook
AB
11901234abcdefg1901234
21010109dssddsd1010109
31587336ssqewq1587336
SheetA
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

That is, put this formula in cell B1 with the keystrokes Ctrl + Shift + Enter, then copy down:

=INDEX(SheetB!$A$1:$A$3,MATCH(A1&"",RIGHT(SheetB!$A$1:$A$3,7),0))
 
Last edited:

rabalam

New Member
Joined
Aug 9, 2010
Messages
9
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=&quot]Room #[/FONT][FONT=&quot]<o:p></o:p>[/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=&quot]Cube #[/FONT][FONT=&quot]<o:p></o:p>[/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=&quot]Old jack #[/FONT][FONT=&quot]<o:p></o:p>[/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=&quot]X-con Y/N[/FONT][FONT=&quot]<o:p></o:p>[/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=&quot]Switch ID / port[/FONT][FONT=&quot]<o:p></o:p>[/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=&quot]Device ID (NWAM#)[/FONT][FONT=&quot]<o:p></o:p>[/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=&quot]415<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]6235<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1905803<o:p></o:p>[/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=&quot]415<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]6236<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]416<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]6287<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1056562<o:p></o:p>[/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=&quot]417<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]6288<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1056202<o:p></o:p>[/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=&quot]418<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]6286<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1056349<o:p></o:p>[/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=&quot]420<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]6289<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1056563<o:p></o:p>[/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=&quot]421<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]6290<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1093103<o:p></o:p>[/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=&quot]425<o:p></o:p>[/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=&quot]1<o:p></o:p>[/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=&quot]6246<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1092895<o:p></o:p>[/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=&quot]425<o:p></o:p>[/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=&quot]2<o:p></o:p>[/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=&quot]6245<o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot] <o:p></o:p>[/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=&quot]1905835[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> </tr> </tbody></table> <o:p> </o:p>
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=&quot]Current NTWK Drop<o:p></o:p>[/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=&quot]Current DNS Name<o:p></o:p>[/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=&quot]Room #<o:p></o:p>[/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=&quot]Cube #<o:p></o:p>[/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:p></o:p>
</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:p></o:p>​
</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=&quot]112<o:p></o:p>[/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=&quot]4<o:p></o:p>[/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:p></o:p>​
</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:p></o:p>​
</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:p></o:p>
</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:p></o:p>​
</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=&quot]013<o:p></o:p>[/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=&quot]2<o:p></o:p>[/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:p></o:p>​
</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:p></o:p>
</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:p></o:p>​
</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=&quot]013<o:p></o:p>[/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=&quot]2<o:p></o:p>[/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:p></o:p>
</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:p></o:p>​
</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=&quot]135a<o:p></o:p>[/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=&quot]2<o:p></o:p>[/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:p></o:p>
</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:p></o:p>​
</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=&quot]112<o:p></o:p>[/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=&quot]3<o:p></o:p>[/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:p></o:p>
</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:p></o:p>​
</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=&quot]108<o:p></o:p>[/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=&quot]2<o:p></o:p>[/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:p></o:p>
</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:p></o:p>​
</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=&quot]013<o:p></o:p>[/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=&quot]2<o:p></o:p>[/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:p></o:p>
</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:p></o:p>​
</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=&quot]012<o:p></o:p>[/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=&quot]1<o:p></o:p>[/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:p></o:p>
</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:p></o:p>​
</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=&quot]135<o:p></o:p>[/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=&quot]3<o:p></o:p>[/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">
nwlvkam1905835.some.domain.com<o:p></o:p>​
</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:p> </o:p>
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:p></o:p>
</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:p></o:p>​
</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=&quot]425<o:p></o:p>[/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=&quot]2<o:p></o:p>[/FONT]
</td> </tr> </tbody></table> <o:p> </o:p>
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:p> </o:p>
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
 
Last edited:

mgirvin

Well-known Member
Joined
Dec 15, 2005
Messages
1,213

ADVERTISEMENT

Perhaps this:
Excel Workbook
ABCDEF
1Room #Cube #Old jack #X-con Y/NSwitch ID / portDevice ID (NWAM#)
2425262451905835
34303621115874
SheetA



Green cells have formulas:
Excel Workbook
ABCD
1NTWK DropCurrent DNS NameRoom #Cube #
26245nwlvkam1905835.some.domain.com4252
36211ddsdsds15874.some.com4303
SheetB


Enter formula in cell A2 with Ctrl + Shift + Enter then copy down:

=INDEX(SheetA!$C$2:$C$3,MATCH(MID(B2,MATCH(TRUE,ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),0),COUNT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)))+0,SheetA!$F$2:$F$3,0))


Enter formula in cell C2 with Ctrl + Shift + Enter then copy down:

=INDEX(SheetA!$A$2:$A$3,MATCH(MID(B2,MATCH(TRUE,ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),0),COUNT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)))+0,SheetA!$F$2:$F$3,0))



Enter formula in cell D2 with Ctrl + Shift + Enter then copy down:

=INDEX(SheetA!$B$2:$B$3,MATCH(MID(B2,MATCH(TRUE,ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),0),COUNT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)))+0,SheetA!$F$2:$F$3,0))

This assumes that there will only be one number in the text string like this:

ddsdsds15874.some.com

not like this:

ddsdsds15874.some.com434523

Maybe that will work?
 

rabalam

New Member
Joined
Aug 9, 2010
Messages
9
Hmm interesting .. every time I copy and paste the formula in teh appropriate cells I get the open file window pop up as to want me to open a file. I hit cancel and I get the #N/A in teh cell in which I pasted the formula.

and BTW way thank you fro taking the time to help me through this.

G
 

mgirvin

Well-known Member
Joined
Dec 15, 2005
Messages
1,213
It may be because you do not have a sheet named "SheetA". Try copying the small data set that I posted to a workbook and name the sheet "SheetA". Then copy the data from post for "SheetB", name a sheet "SheetB", then try the formulas. If they seem to work you can try to adapt them to your data sets.
 

rabalam

New Member
Joined
Aug 9, 2010
Messages
9
well creating the sheetA and B respectfully worked as far as not getting a popup window. I'm still getting the #N/A int cell where I pasted the formula. I did not try to enter the formula by hand I cut and pasted it directly from your post.

Did you test this and it worked? if so I'll tinker with it more to see if I'm missing something.

thx,

-r

 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,413
Messages
5,511,186
Members
408,829
Latest member
sheshe123

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top