compare data and extract

[edwinb]

Hi,
I need help from the expert!!!

Is there a way compare data (text in a cell) from wrksheet1 to worksheet2 then extract the data from wrksheet2 and paste it on wrksheet1? Here's the dilema; the text (cell) in the two worksheets that needed to be compared (or verified) are somewhat different. What I mean is that there will be commonality. The sample below show the worksheet have a common text; that is "mydata" and "data"...etc.

For example:
wrksheet2:
(cellA1)mydata_R1|(cellB1)12345.66
(A2)mydata_R2|(B2)23456.77
...
(A10)data_C111|(B10)34567.88
...
(A300)sync|(B300)456789.11

wrksheet1:
(C4)mydata|(D4)_____|(E4)______
(C5)data|(D5)_____|
...
(C200)sync|(D200)_____

Note: mydata and data are the text
_R1, _R2..._C111 are the reference designators (ref_des)

the "_" will be included in the text (cell) if a reference designator is present. There will be instances where there will not be ref_des.

Here's what needs to happen;
Using wrksheet1 as the reference, use the common text "mydata" in wrk1 as a "comparator" to locate it in wrksheet2. Once located and verified, the values of the common text "mydata" which are in cells B1 and B2 are then extracted and entered (or pasted/inserted) back to worksheet1, in this case in cells D4 and E4. Once that's done it goes to the next text "data" and repeats the same process untill all the values are extracted and entered in to wk1.
Here's another curve ball, if a ref_des is present in the text then it will need to be included in the values also and an "_" is added for separation.

The result should be something like this:

Final wrksheet1:
(C4)mydata|(D4)R1_12345.66|(E4)R2_23456.77
(C5)data|(D5)C111_34567.88
...
(C200)sync|(D200)456789.11

Can this be done? Please let me know if further clarification or more data is needed.

Thanks in advance,
Edwin B

Here's a portion of the wrksheets

sample1.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	worksheet1:	.	.	.	.	.	.	.	.	.	.	.	.
2	.	.	.	.	.	.	.	.	.	.	.	.	.
3	.	.	NameTag	Value	Value	Value	Value	Value	Value	Value	Value	Value	Value
4	.	.	mydata	.	.	.	.	.	.	.	.	.	.
5	.	.	data	.	.	.	.	.	.	.	.	.	.
6	.	.		.	.	.	.	.	.	.	.	.	.
7	.	.	sync	.	.	.	.	.	.	.	.	.	.
8	.	.	clk	.	.	.	.	.	.	.	.	.	.
9	.	.	bus	.	.	.	.	.	.	.	.	.	.
Sheet1

sample1.xls
	A	B	C	D	E	F
1	mydata_R1	12345.660	.	.	.	.
2	mydata_R2	23456.770	.	.	.	.
3	mydata_R3	654.000	.	.	.	.
4	mydata_R4	56444.000	.	.	.	.
5	mydata_R5	4456.000	.	.	.	.
6	mydata_R6	466.220	.	.	.	.
7	mydata_R7	5465.200	.	.	.	.
8	mydata_R8	5555.230	.	.	.	.
9	mydata_R9	56483.200	.	.	.	.
10	data_C111	34567.880	.	.	.	.
11	data_C112	5645.326	.	.	.	.
12	data_C113	55454.200	.	.	.	.
13			.	.	.	.
14	sync	5465865.215	.	.	.	.
15	clk	524.230	.	.	.	.
16	bus	252.325	.	.	.	.
Sheet2

 

[NBVC]

Hi NBVC,
Quick question. Is there a different formula for B1? The formula listed on B1 is the same as A1.

Thanks,
Edwin B

Hi Edwin,

Sorry about that. You are correct, the formulas for A1 and B1 are not the same. You should be able to click on the hyperlinks on the Html sample sheets to view the formulas.

A1: =IF(ISERROR(FIND("_",Sheet2!$A1)),Sheet2!$A1,LEFT(Sheet2!$A1,FIND("_",Sheet2!$A1)-1))

B1: =IF(ISERROR(FIND("_",Sheet2!A1)),Sheet2!B1,RIGHT(Sheet2!A1,LEN(Sheet2!A1)-FIND("_",Sheet2!A1))&"_"&Sheet2!B1)

D4: =IF(ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1))))

The formula in D4 must be evaluated using CTRL+SHIFT+ENTER and then copied down as far as required and copied to the right as far as necessary.

 

[edwinb]

Thanks again NBVC!!!!

I will implement the latest formula and let you know the outcome!!


Edwin B

 

[edwinb]

Hi NBVC,
I ran the formulas and got expected results on column A and B, but when I copied down the third formula on columns D4 and beyond, it gave me different results as shown below. Am I doing something wrong? Please advice!

Thanks again.
P.S.
When I evalualted it by pressing CTRL+Shift+Enter, nothing happened.

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=14><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - sample2.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=14><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=14><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A1)),Sheet2!$A1,LEFT(Sheet2!$A1,FIND("_",Sheet2!$A1)-1))' selected>A1<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A1)),Sheet2!B1,RIGHT(Sheet2!A1,LEN(Sheet2!A1)-FIND("_",Sheet2!A1))&"_"&Sheet2!B1)'>B1<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A2)),Sheet2!$A2,LEFT(Sheet2!$A2,FIND("_",Sheet2!$A2)-1))'>A2<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A2)),Sheet2!B2,RIGHT(Sheet2!A2,LEN(Sheet2!A2)-FIND("_",Sheet2!A2))&"_"&Sheet2!B2)'>B2<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A3)),Sheet2!$A3,LEFT(Sheet2!$A3,FIND("_",Sheet2!$A3)-1))'>A3<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A3)),Sheet2!B3,RIGHT(Sheet2!A3,LEN(Sheet2!A3)-FIND("_",Sheet2!A3))&"_"&Sheet2!B3)'>B3<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A4)),Sheet2!$A4,LEFT(Sheet2!$A4,FIND("_",Sheet2!$A4)-1))'>A4<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A4)),Sheet2!B4,RIGHT(Sheet2!A4,LEN(Sheet2!A4)-FIND("_",Sheet2!A4))&"_"&Sheet2!B4)'>B4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B2)))-ROW($A$1))))'>D4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(C2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C2)))-ROW($A$1))))'>E4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(D2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D2)))-ROW($A$1))))'>F4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(E2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E2)))-ROW($A$1))))'>G4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(F2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F2)))-ROW($A$1))))'>H4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(G2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G2)))-ROW($A$1))))'>I4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(H2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H2)))-ROW($A$1))))'>J4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(I2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I2)))-ROW($A$1))))'>K4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(J2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J2)))-ROW($A$1))))'>L4<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(K2)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C4),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C4,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K2)))-ROW($A$1))))'>M4<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A5)),Sheet2!$A5,LEFT(Sheet2!$A5,FIND("_",Sheet2!$A5)-1))'>A5<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A5)),Sheet2!B5,RIGHT(Sheet2!A5,LEN(Sheet2!A5)-FIND("_",Sheet2!A5))&"_"&Sheet2!B5)'>B5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(B3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B3)))-ROW($A$1))))'>D5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(C3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C3)))-ROW($A$1))))'>E5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(D3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D3)))-ROW($A$1))))'>F5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(E3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E3)))-ROW($A$1))))'>G5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(F3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F3)))-ROW($A$1))))'>H5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(G3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G3)))-ROW($A$1))))'>I5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(H3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H3)))-ROW($A$1))))'>J5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(I3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I3)))-ROW($A$1))))'>K5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(J3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J3)))-ROW($A$1))))'>L5<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(K3)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C5),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C5,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K3)))-ROW($A$1))))'>M5<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A6)),Sheet2!$A6,LEFT(Sheet2!$A6,FIND("_",Sheet2!$A6)-1))'>A6<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A6)),Sheet2!B6,RIGHT(Sheet2!A6,LEN(Sheet2!A6)-FIND("_",Sheet2!A6))&"_"&Sheet2!B6)'>B6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(B4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B4)))-ROW($A$1))))'>D6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(C4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C4)))-ROW($A$1))))'>E6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(D4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D4)))-ROW($A$1))))'>F6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(E4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E4)))-ROW($A$1))))'>G6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(F4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F4)))-ROW($A$1))))'>H6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(G4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G4)))-ROW($A$1))))'>I6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(H4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H4)))-ROW($A$1))))'>J6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(I4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I4)))-ROW($A$1))))'>K6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(J4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J4)))-ROW($A$1))))'>L6<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(K4)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C6),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C6,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K4)))-ROW($A$1))))'>M6<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A7)),Sheet2!$A7,LEFT(Sheet2!$A7,FIND("_",Sheet2!$A7)-1))'>A7<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A7)),Sheet2!B7,RIGHT(Sheet2!A7,LEN(Sheet2!A7)-FIND("_",Sheet2!A7))&"_"&Sheet2!B7)'>B7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(B5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B5)))-ROW($A$1))))'>D7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(C5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C5)))-ROW($A$1))))'>E7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(D5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D5)))-ROW($A$1))))'>F7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(E5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E5)))-ROW($A$1))))'>G7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(F5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F5)))-ROW($A$1))))'>H7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(G5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G5)))-ROW($A$1))))'>I7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(H5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H5)))-ROW($A$1))))'>J7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(I5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I5)))-ROW($A$1))))'>K7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(J5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J5)))-ROW($A$1))))'>L7<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(K5)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C7),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C7,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K5)))-ROW($A$1))))'>M7<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A8)),Sheet2!$A8,LEFT(Sheet2!$A8,FIND("_",Sheet2!$A8)-1))'>A8<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A8)),Sheet2!B8,RIGHT(Sheet2!A8,LEN(Sheet2!A8)-FIND("_",Sheet2!A8))&"_"&Sheet2!B8)'>B8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(B6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(B6)))-ROW($A$1))))'>D8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(C6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(C6)))-ROW($A$1))))'>E8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(D6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(D6)))-ROW($A$1))))'>F8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(E6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(E6)))-ROW($A$1))))'>G8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(F6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(F6)))-ROW($A$1))))'>H8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(G6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(G6)))-ROW($A$1))))'>I8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(H6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(H6)))-ROW($A$1))))'>J8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(I6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(I6)))-ROW($A$1))))'>K8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(J6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(J6)))-ROW($A$1))))'>L8<OPTION value='=IF(ROW(INDIRECT("A"&COLUMN(K6)))-ROW($A$1)>COUNTIF($A$1:$A$100,$C8),"",INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C8,ROW($A$1:$A$100)),ROW(INDIRECT("A"&COLUMN(K6)))-ROW($A$1))))'>M8<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A9)),Sheet2!$A9,LEFT(Sheet2!$A9,FIND("_",Sheet2!$A9)-1))'>A9<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A9)),Sheet2!B9,RIGHT(Sheet2!A9,LEN(Sheet2!A9)-FIND("_",Sheet2!A9))&"_"&Sheet2!B9)'>B9<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A10)),Sheet2!$A10,LEFT(Sheet2!$A10,FIND("_",Sheet2!$A10)-1))'>A10<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A10)),Sheet2!B10,RIGHT(Sheet2!A10,LEN(Sheet2!A10)-FIND("_",Sheet2!A10))&"_"&Sheet2!B10)'>B10<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A11)),Sheet2!$A11,LEFT(Sheet2!$A11,FIND("_",Sheet2!$A11)-1))'>A11<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A11)),Sheet2!B11,RIGHT(Sheet2!A11,LEN(Sheet2!A11)-FIND("_",Sheet2!A11))&"_"&Sheet2!B11)'>B11<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A12)),Sheet2!$A12,LEFT(Sheet2!$A12,FIND("_",Sheet2!$A12)-1))'>A12<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A12)),Sheet2!B12,RIGHT(Sheet2!A12,LEN(Sheet2!A12)-FIND("_",Sheet2!A12))&"_"&Sheet2!B12)'>B12<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A13)),Sheet2!$A13,LEFT(Sheet2!$A13,FIND("_",Sheet2!$A13)-1))'>A13<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A13)),Sheet2!B13,RIGHT(Sheet2!A13,LEN(Sheet2!A13)-FIND("_",Sheet2!A13))&"_"&Sheet2!B13)'>B13<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A14)),Sheet2!$A14,LEFT(Sheet2!$A14,FIND("_",Sheet2!$A14)-1))'>A14<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A14)),Sheet2!B14,RIGHT(Sheet2!A14,LEN(Sheet2!A14)-FIND("_",Sheet2!A14))&"_"&Sheet2!B14)'>B14<OPTION value='=IF(ISERROR(FIND("_",Sheet2!$A15)),Sheet2!$A15,LEFT(Sheet2!$A15,FIND("_",Sheet2!$A15)-1))'>A15<OPTION value='=IF(ISERROR(FIND("_",Sheet2!A15)),Sheet2!B15,RIGHT(Sheet2!A15,LEN(Sheet2!A15)-FIND("_",Sheet2!A15))&"_"&Sheet2!B15)'>B15</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value='=IF(ISERROR(FIND("_",Sheet2!$A1)),Sheet2!$A1,LEFT(Sheet2!$A1,FIND("_",Sheet2!$A1)-1))' name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">
</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>A</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>F</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>G</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>H</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>I</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>J</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>K</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>L</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>M</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>1</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R1_12345.66</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>2</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R2_23456.77</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>3</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R3_654</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">NameTag</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Value</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>4</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R4_56444</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R1_12345.66</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[17].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>5</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R5_4456</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">data</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R5_4456</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">#NUM!</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[23].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[24].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[25].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[26].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[27].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[28].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[29].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>6</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R6_466.22</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">sync</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R6_466.22</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[33].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[34].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[35].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[36].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[37].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[38].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[39].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[40].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[41].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>7</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R7_5465.2</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">clk</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R7_5465.2</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[45].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[46].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[47].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[48].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[49].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[50].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[51].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[52].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[53].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>8</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R8_5555.23</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">bus</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R8_5555.23</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[57].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[58].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[59].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[60].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[61].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[62].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[63].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[64].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb078704.sltNb935705.options[65].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="#javascript:void(0);">
</FONT></A></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>9</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">mydata</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">R9_56483.2</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>10</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">data</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">C111_34567.88</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLO

 

[NBVC]

Go back to cell D4 and hit F2. The cursor should be at the end of the formula. Now Hold down CTRL and SHIFT keys and press ENTER. The formula should now be enclosed in curly brackets { }. Once this happens, you can copy the formula over and down.

I tested my formula again and it does work, and it seems like you used the correct formula because your first column results seem right.

Let me know the outcome of the above test.

 

[edwinb]

Hi NBVC,
Beautiful!! The formula works beautiful. Many thanks NVBC!
My co-workers are all smiles..

Regards,
Edwin B

I hope I'll be able to get in touch with U again if I face another mountain.

 

[NBVC]

Congratulations!

Sure I will try to help if the need arises.