Name (Value) replacement in XL 2003 VBA

M

MassSpecGuru

Board Regular
Joined
Feb 23, 2010
Messages
55
I would like to develop some VBA code for the evaluation, and if "improperly entered"the replacement, of certain values in the first column of a worksheet.

Ultimately, I would like to test for four different situations, however, if pointed in the right direction, I could probably expand upon the one-case scenario myself (fingers crossed), but an example of what I would like to accomlish is this:

If the value in a cell is a number then return that number, otherwise check to see if it is, say, "QL"* (case sensitive). If it is only "QX" both capital letters), then return that value, too.

The "problem" comes in where I want to evaluate other possible entries such as: "Q l" (or q l) "Qlow", "QCL", "QCLOW", "qc_low", "QC-low" (or in this instance, any other variations/combinations you can dream up using the letters, both upper and lower case, q, c, b, l, a, n, k, as well as any "space-type" characters like <SPACE>, hyphen, dash.)

Basically, what I see as the key to this task is whether or not there is a "b", "l" (el), "m" or "h" somwhere in the cell. The "difficulty" increases though because the possibility if a cell containing, say, (ignoring case and just focusing on the letters involved) "qc blank", or "qcblk" or "qcbl" versus a cell containing "qcl" or "qc low" of just "q low". I guess you could check for the "b" first here and then move on, so maybe a Case construction would be in order?

Can anybody come up with some suggestions, or code :-D , to getting this going?

Thanks for your input!


* where "X" would be either "B", "L", "M" or "H", thus the other three instances we're checking for are: "QB", "QM" and "QH".
 
Sort by date Sort by votes
shg4421 said:
How would you know to change "blk" to "QL"?
Click to expand...

Hopefully, my previous post answered your question regarding the "rationale" behind the request, but if not, hopefully the table below will help.

Last night I sat down and wrote out what I expect to be the bulk, if not all, of the possibilities that we could expect to encounter, and then developed an Excel spreadsheet formula to do the replacements.

Using the following formula within Excel itself (i.e., not using VBA), I was able to get the correct output, if only for the four lower case letters. I could not figure out a way to add in the test for whether or not the four letters were capitalized, though. (In case you can't tell, I'm (a chemist) not a programmer.)

So, with the values in cells in column A, with the below formula in teh adjacent cell in column B, I got the desired results.


=IF(ISNUMBER(FIND("b",A1)),"QB",IF(ISNUMBER(FIND("l",A1)),"QL",IF(ISNUMBER(FIND("m",A1)),"QM",IF(ISNUMBER(FIND("h",A1)),"QH",A1))))


(Fortunately, testing them in this order precluded the necessity of testing the " 'l' case" for the absence of a "b" :), so that's one less thing to worry about... I hope. :( )

Now, I would like to transfer this formaula to VBA and expand upon it to include cases where the "b", "l", "m" and "h" in column A are capitalized. (That is, the output should be identical when testing either a "b" or "B" in column A.)

That should do exactly what I need.

Thanks!


Input: Output:
<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=128 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>b</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64 x:fmla='=IF(ISNUMBER(FIND("b",A1)),"QB",IF(ISNUMBER(FIND("l",A1)),"QL",IF(ISNUMBER(FIND("m",A1)),"QM",IF(ISNUMBER(FIND("h",A1)),"QH",A1))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>bl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A2)),"QB",IF(ISNUMBER(FIND("l",A2)),"QL",IF(ISNUMBER(FIND("m",A2)),"QM",IF(ISNUMBER(FIND("h",A2)),"QH",A2))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>blk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A3)),"QB",IF(ISNUMBER(FIND("l",A3)),"QL",IF(ISNUMBER(FIND("m",A3)),"QM",IF(ISNUMBER(FIND("h",A3)),"QH",A3))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>blank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A4)),"QB",IF(ISNUMBER(FIND("l",A4)),"QL",IF(ISNUMBER(FIND("m",A4)),"QM",IF(ISNUMBER(FIND("h",A4)),"QH",A4))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcb</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A5)),"QB",IF(ISNUMBER(FIND("l",A5)),"QL",IF(ISNUMBER(FIND("m",A5)),"QM",IF(ISNUMBER(FIND("h",A5)),"QH",A5))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcbl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A6)),"QB",IF(ISNUMBER(FIND("l",A6)),"QL",IF(ISNUMBER(FIND("m",A6)),"QM",IF(ISNUMBER(FIND("h",A6)),"QH",A6))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcblk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A7)),"QB",IF(ISNUMBER(FIND("l",A7)),"QL",IF(ISNUMBER(FIND("m",A7)),"QM",IF(ISNUMBER(FIND("h",A7)),"QH",A7))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcblnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A8)),"QB",IF(ISNUMBER(FIND("l",A8)),"QL",IF(ISNUMBER(FIND("m",A8)),"QM",IF(ISNUMBER(FIND("h",A8)),"QH",A8))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcblank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A9)),"QB",IF(ISNUMBER(FIND("l",A9)),"QL",IF(ISNUMBER(FIND("m",A9)),"QM",IF(ISNUMBER(FIND("h",A9)),"QH",A9))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc b</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A10)),"QB",IF(ISNUMBER(FIND("l",A10)),"QL",IF(ISNUMBER(FIND("m",A10)),"QM",IF(ISNUMBER(FIND("h",A10)),"QH",A10))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc bl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A11)),"QB",IF(ISNUMBER(FIND("l",A11)),"QL",IF(ISNUMBER(FIND("m",A11)),"QM",IF(ISNUMBER(FIND("h",A11)),"QH",A11))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc blk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A12)),"QB",IF(ISNUMBER(FIND("l",A12)),"QL",IF(ISNUMBER(FIND("m",A12)),"QM",IF(ISNUMBER(FIND("h",A12)),"QH",A12))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc blnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A13)),"QB",IF(ISNUMBER(FIND("l",A13)),"QL",IF(ISNUMBER(FIND("m",A13)),"QM",IF(ISNUMBER(FIND("h",A13)),"QH",A13))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc blank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A14)),"QB",IF(ISNUMBER(FIND("l",A14)),"QL",IF(ISNUMBER(FIND("m",A14)),"QM",IF(ISNUMBER(FIND("h",A14)),"QH",A14))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-b</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A15)),"QB",IF(ISNUMBER(FIND("l",A15)),"QL",IF(ISNUMBER(FIND("m",A15)),"QM",IF(ISNUMBER(FIND("h",A15)),"QH",A15))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-bl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A16)),"QB",IF(ISNUMBER(FIND("l",A16)),"QL",IF(ISNUMBER(FIND("m",A16)),"QM",IF(ISNUMBER(FIND("h",A16)),"QH",A16))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-blk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A17)),"QB",IF(ISNUMBER(FIND("l",A17)),"QL",IF(ISNUMBER(FIND("m",A17)),"QM",IF(ISNUMBER(FIND("h",A17)),"QH",A17))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-blnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A18)),"QB",IF(ISNUMBER(FIND("l",A18)),"QL",IF(ISNUMBER(FIND("m",A18)),"QM",IF(ISNUMBER(FIND("h",A18)),"QH",A18))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-blank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A19)),"QB",IF(ISNUMBER(FIND("l",A19)),"QL",IF(ISNUMBER(FIND("m",A19)),"QM",IF(ISNUMBER(FIND("h",A19)),"QH",A19))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_b</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A20)),"QB",IF(ISNUMBER(FIND("l",A20)),"QL",IF(ISNUMBER(FIND("m",A20)),"QM",IF(ISNUMBER(FIND("h",A20)),"QH",A20))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_bl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A21)),"QB",IF(ISNUMBER(FIND("l",A21)),"QL",IF(ISNUMBER(FIND("m",A21)),"QM",IF(ISNUMBER(FIND("h",A21)),"QH",A21))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_blk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A22)),"QB",IF(ISNUMBER(FIND("l",A22)),"QL",IF(ISNUMBER(FIND("m",A22)),"QM",IF(ISNUMBER(FIND("h",A22)),"QH",A22))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_blnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A23)),"QB",IF(ISNUMBER(FIND("l",A23)),"QL",IF(ISNUMBER(FIND("m",A23)),"QM",IF(ISNUMBER(FIND("h",A23)),"QH",A23))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_blank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A24)),"QB",IF(ISNUMBER(FIND("l",A24)),"QL",IF(ISNUMBER(FIND("m",A24)),"QM",IF(ISNUMBER(FIND("h",A24)),"QH",A24))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qb</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A25)),"QB",IF(ISNUMBER(FIND("l",A25)),"QL",IF(ISNUMBER(FIND("m",A25)),"QM",IF(ISNUMBER(FIND("h",A25)),"QH",A25))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qbl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A26)),"QB",IF(ISNUMBER(FIND("l",A26)),"QL",IF(ISNUMBER(FIND("m",A26)),"QM",IF(ISNUMBER(FIND("h",A26)),"QH",A26))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qblk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A27)),"QB",IF(ISNUMBER(FIND("l",A27)),"QL",IF(ISNUMBER(FIND("m",A27)),"QM",IF(ISNUMBER(FIND("h",A27)),"QH",A27))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qblnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A28)),"QB",IF(ISNUMBER(FIND("l",A28)),"QL",IF(ISNUMBER(FIND("m",A28)),"QM",IF(ISNUMBER(FIND("h",A28)),"QH",A28))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qblank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A29)),"QB",IF(ISNUMBER(FIND("l",A29)),"QL",IF(ISNUMBER(FIND("m",A29)),"QM",IF(ISNUMBER(FIND("h",A29)),"QH",A29))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q b</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A30)),"QB",IF(ISNUMBER(FIND("l",A30)),"QL",IF(ISNUMBER(FIND("m",A30)),"QM",IF(ISNUMBER(FIND("h",A30)),"QH",A30))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q bl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A31)),"QB",IF(ISNUMBER(FIND("l",A31)),"QL",IF(ISNUMBER(FIND("m",A31)),"QM",IF(ISNUMBER(FIND("h",A31)),"QH",A31))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q blk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A32)),"QB",IF(ISNUMBER(FIND("l",A32)),"QL",IF(ISNUMBER(FIND("m",A32)),"QM",IF(ISNUMBER(FIND("h",A32)),"QH",A32))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q blnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A33)),"QB",IF(ISNUMBER(FIND("l",A33)),"QL",IF(ISNUMBER(FIND("m",A33)),"QM",IF(ISNUMBER(FIND("h",A33)),"QH",A33))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q blank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A34)),"QB",IF(ISNUMBER(FIND("l",A34)),"QL",IF(ISNUMBER(FIND("m",A34)),"QM",IF(ISNUMBER(FIND("h",A34)),"QH",A34))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-b</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A35)),"QB",IF(ISNUMBER(FIND("l",A35)),"QL",IF(ISNUMBER(FIND("m",A35)),"QM",IF(ISNUMBER(FIND("h",A35)),"QH",A35))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-bl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A36)),"QB",IF(ISNUMBER(FIND("l",A36)),"QL",IF(ISNUMBER(FIND("m",A36)),"QM",IF(ISNUMBER(FIND("h",A36)),"QH",A36))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-blk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A37)),"QB",IF(ISNUMBER(FIND("l",A37)),"QL",IF(ISNUMBER(FIND("m",A37)),"QM",IF(ISNUMBER(FIND("h",A37)),"QH",A37))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-blnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A38)),"QB",IF(ISNUMBER(FIND("l",A38)),"QL",IF(ISNUMBER(FIND("m",A38)),"QM",IF(ISNUMBER(FIND("h",A38)),"QH",A38))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-blank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A39)),"QB",IF(ISNUMBER(FIND("l",A39)),"QL",IF(ISNUMBER(FIND("m",A39)),"QM",IF(ISNUMBER(FIND("h",A39)),"QH",A39))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_b</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A40)),"QB",IF(ISNUMBER(FIND("l",A40)),"QL",IF(ISNUMBER(FIND("m",A40)),"QM",IF(ISNUMBER(FIND("h",A40)),"QH",A40))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_bl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A41)),"QB",IF(ISNUMBER(FIND("l",A41)),"QL",IF(ISNUMBER(FIND("m",A41)),"QM",IF(ISNUMBER(FIND("h",A41)),"QH",A41))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_blk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A42)),"QB",IF(ISNUMBER(FIND("l",A42)),"QL",IF(ISNUMBER(FIND("m",A42)),"QM",IF(ISNUMBER(FIND("h",A42)),"QH",A42))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_blnk</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A43)),"QB",IF(ISNUMBER(FIND("l",A43)),"QL",IF(ISNUMBER(FIND("m",A43)),"QM",IF(ISNUMBER(FIND("h",A43)),"QH",A43))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_blank</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A44)),"QB",IF(ISNUMBER(FIND("l",A44)),"QL",IF(ISNUMBER(FIND("m",A44)),"QM",IF(ISNUMBER(FIND("h",A44)),"QH",A44))))'>QB</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>ql</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A45)),"QB",IF(ISNUMBER(FIND("l",A45)),"QL",IF(ISNUMBER(FIND("m",A45)),"QM",IF(ISNUMBER(FIND("h",A45)),"QH",A45))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qlo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A46)),"QB",IF(ISNUMBER(FIND("l",A46)),"QL",IF(ISNUMBER(FIND("m",A46)),"QM",IF(ISNUMBER(FIND("h",A46)),"QH",A46))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qlow</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A47)),"QB",IF(ISNUMBER(FIND("l",A47)),"QL",IF(ISNUMBER(FIND("m",A47)),"QM",IF(ISNUMBER(FIND("h",A47)),"QH",A47))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q l</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A48)),"QB",IF(ISNUMBER(FIND("l",A48)),"QL",IF(ISNUMBER(FIND("m",A48)),"QM",IF(ISNUMBER(FIND("h",A48)),"QH",A48))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q lo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A49)),"QB",IF(ISNUMBER(FIND("l",A49)),"QL",IF(ISNUMBER(FIND("m",A49)),"QM",IF(ISNUMBER(FIND("h",A49)),"QH",A49))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q low</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A50)),"QB",IF(ISNUMBER(FIND("l",A50)),"QL",IF(ISNUMBER(FIND("m",A50)),"QM",IF(ISNUMBER(FIND("h",A50)),"QH",A50))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-l</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A51)),"QB",IF(ISNUMBER(FIND("l",A51)),"QL",IF(ISNUMBER(FIND("m",A51)),"QM",IF(ISNUMBER(FIND("h",A51)),"QH",A51))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-lo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A52)),"QB",IF(ISNUMBER(FIND("l",A52)),"QL",IF(ISNUMBER(FIND("m",A52)),"QM",IF(ISNUMBER(FIND("h",A52)),"QH",A52))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-low</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A53)),"QB",IF(ISNUMBER(FIND("l",A53)),"QL",IF(ISNUMBER(FIND("m",A53)),"QM",IF(ISNUMBER(FIND("h",A53)),"QH",A53))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_l</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A54)),"QB",IF(ISNUMBER(FIND("l",A54)),"QL",IF(ISNUMBER(FIND("m",A54)),"QM",IF(ISNUMBER(FIND("h",A54)),"QH",A54))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_lo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A55)),"QB",IF(ISNUMBER(FIND("l",A55)),"QL",IF(ISNUMBER(FIND("m",A55)),"QM",IF(ISNUMBER(FIND("h",A55)),"QH",A55))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_low</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A56)),"QB",IF(ISNUMBER(FIND("l",A56)),"QL",IF(ISNUMBER(FIND("m",A56)),"QM",IF(ISNUMBER(FIND("h",A56)),"QH",A56))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>l</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A57)),"QB",IF(ISNUMBER(FIND("l",A57)),"QL",IF(ISNUMBER(FIND("m",A57)),"QM",IF(ISNUMBER(FIND("h",A57)),"QH",A57))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>lo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A58)),"QB",IF(ISNUMBER(FIND("l",A58)),"QL",IF(ISNUMBER(FIND("m",A58)),"QM",IF(ISNUMBER(FIND("h",A58)),"QH",A58))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>low</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A59)),"QB",IF(ISNUMBER(FIND("l",A59)),"QL",IF(ISNUMBER(FIND("m",A59)),"QM",IF(ISNUMBER(FIND("h",A59)),"QH",A59))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcl</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A60)),"QB",IF(ISNUMBER(FIND("l",A60)),"QL",IF(ISNUMBER(FIND("m",A60)),"QM",IF(ISNUMBER(FIND("h",A60)),"QH",A60))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qclo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A61)),"QB",IF(ISNUMBER(FIND("l",A61)),"QL",IF(ISNUMBER(FIND("m",A61)),"QM",IF(ISNUMBER(FIND("h",A61)),"QH",A61))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qclow</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A62)),"QB",IF(ISNUMBER(FIND("l",A62)),"QL",IF(ISNUMBER(FIND("m",A62)),"QM",IF(ISNUMBER(FIND("h",A62)),"QH",A62))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc l</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A63)),"QB",IF(ISNUMBER(FIND("l",A63)),"QL",IF(ISNUMBER(FIND("m",A63)),"QM",IF(ISNUMBER(FIND("h",A63)),"QH",A63))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc lo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A64)),"QB",IF(ISNUMBER(FIND("l",A64)),"QL",IF(ISNUMBER(FIND("m",A64)),"QM",IF(ISNUMBER(FIND("h",A64)),"QH",A64))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc low</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A65)),"QB",IF(ISNUMBER(FIND("l",A65)),"QL",IF(ISNUMBER(FIND("m",A65)),"QM",IF(ISNUMBER(FIND("h",A65)),"QH",A65))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-l</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A66)),"QB",IF(ISNUMBER(FIND("l",A66)),"QL",IF(ISNUMBER(FIND("m",A66)),"QM",IF(ISNUMBER(FIND("h",A66)),"QH",A66))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-lo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A67)),"QB",IF(ISNUMBER(FIND("l",A67)),"QL",IF(ISNUMBER(FIND("m",A67)),"QM",IF(ISNUMBER(FIND("h",A67)),"QH",A67))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-low</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A68)),"QB",IF(ISNUMBER(FIND("l",A68)),"QL",IF(ISNUMBER(FIND("m",A68)),"QM",IF(ISNUMBER(FIND("h",A68)),"QH",A68))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_l</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A69)),"QB",IF(ISNUMBER(FIND("l",A69)),"QL",IF(ISNUMBER(FIND("m",A69)),"QM",IF(ISNUMBER(FIND("h",A69)),"QH",A69))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_lo</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A70)),"QB",IF(ISNUMBER(FIND("l",A70)),"QL",IF(ISNUMBER(FIND("m",A70)),"QM",IF(ISNUMBER(FIND("h",A70)),"QH",A70))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_low</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A71)),"QB",IF(ISNUMBER(FIND("l",A71)),"QL",IF(ISNUMBER(FIND("m",A71)),"QM",IF(ISNUMBER(FIND("h",A71)),"QH",A71))))'>QL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>m</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A72)),"QB",IF(ISNUMBER(FIND("l",A72)),"QL",IF(ISNUMBER(FIND("m",A72)),"QM",IF(ISNUMBER(FIND("h",A72)),"QH",A72))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>med</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A73)),"QB",IF(ISNUMBER(FIND("l",A73)),"QL",IF(ISNUMBER(FIND("m",A73)),"QM",IF(ISNUMBER(FIND("h",A73)),"QH",A73))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>medium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A74)),"QB",IF(ISNUMBER(FIND("l",A74)),"QL",IF(ISNUMBER(FIND("m",A74)),"QM",IF(ISNUMBER(FIND("h",A74)),"QH",A74))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcm</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A75)),"QB",IF(ISNUMBER(FIND("l",A75)),"QL",IF(ISNUMBER(FIND("m",A75)),"QM",IF(ISNUMBER(FIND("h",A75)),"QH",A75))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcmed</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A76)),"QB",IF(ISNUMBER(FIND("l",A76)),"QL",IF(ISNUMBER(FIND("m",A76)),"QM",IF(ISNUMBER(FIND("h",A76)),"QH",A76))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qcmedium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A77)),"QB",IF(ISNUMBER(FIND("l",A77)),"QL",IF(ISNUMBER(FIND("m",A77)),"QM",IF(ISNUMBER(FIND("h",A77)),"QH",A77))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc m</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A78)),"QB",IF(ISNUMBER(FIND("l",A78)),"QL",IF(ISNUMBER(FIND("m",A78)),"QM",IF(ISNUMBER(FIND("h",A78)),"QH",A78))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc med</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A79)),"QB",IF(ISNUMBER(FIND("l",A79)),"QL",IF(ISNUMBER(FIND("m",A79)),"QM",IF(ISNUMBER(FIND("h",A79)),"QH",A79))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc medium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A80)),"QB",IF(ISNUMBER(FIND("l",A80)),"QL",IF(ISNUMBER(FIND("m",A80)),"QM",IF(ISNUMBER(FIND("h",A80)),"QH",A80))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-m</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A81)),"QB",IF(ISNUMBER(FIND("l",A81)),"QL",IF(ISNUMBER(FIND("m",A81)),"QM",IF(ISNUMBER(FIND("h",A81)),"QH",A81))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-med</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A82)),"QB",IF(ISNUMBER(FIND("l",A82)),"QL",IF(ISNUMBER(FIND("m",A82)),"QM",IF(ISNUMBER(FIND("h",A82)),"QH",A82))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-medium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A83)),"QB",IF(ISNUMBER(FIND("l",A83)),"QL",IF(ISNUMBER(FIND("m",A83)),"QM",IF(ISNUMBER(FIND("h",A83)),"QH",A83))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_m</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A84)),"QB",IF(ISNUMBER(FIND("l",A84)),"QL",IF(ISNUMBER(FIND("m",A84)),"QM",IF(ISNUMBER(FIND("h",A84)),"QH",A84))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_med</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A85)),"QB",IF(ISNUMBER(FIND("l",A85)),"QL",IF(ISNUMBER(FIND("m",A85)),"QM",IF(ISNUMBER(FIND("h",A85)),"QH",A85))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_medium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A86)),"QB",IF(ISNUMBER(FIND("l",A86)),"QL",IF(ISNUMBER(FIND("m",A86)),"QM",IF(ISNUMBER(FIND("h",A86)),"QH",A86))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qm</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A87)),"QB",IF(ISNUMBER(FIND("l",A87)),"QL",IF(ISNUMBER(FIND("m",A87)),"QM",IF(ISNUMBER(FIND("h",A87)),"QH",A87))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qmed</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A88)),"QB",IF(ISNUMBER(FIND("l",A88)),"QL",IF(ISNUMBER(FIND("m",A88)),"QM",IF(ISNUMBER(FIND("h",A88)),"QH",A88))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qmedium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A89)),"QB",IF(ISNUMBER(FIND("l",A89)),"QL",IF(ISNUMBER(FIND("m",A89)),"QM",IF(ISNUMBER(FIND("h",A89)),"QH",A89))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q m</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A90)),"QB",IF(ISNUMBER(FIND("l",A90)),"QL",IF(ISNUMBER(FIND("m",A90)),"QM",IF(ISNUMBER(FIND("h",A90)),"QH",A90))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q med</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A91)),"QB",IF(ISNUMBER(FIND("l",A91)),"QL",IF(ISNUMBER(FIND("m",A91)),"QM",IF(ISNUMBER(FIND("h",A91)),"QH",A91))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q medium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A92)),"QB",IF(ISNUMBER(FIND("l",A92)),"QL",IF(ISNUMBER(FIND("m",A92)),"QM",IF(ISNUMBER(FIND("h",A92)),"QH",A92))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-m</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A93)),"QB",IF(ISNUMBER(FIND("l",A93)),"QL",IF(ISNUMBER(FIND("m",A93)),"QM",IF(ISNUMBER(FIND("h",A93)),"QH",A93))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-med</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A94)),"QB",IF(ISNUMBER(FIND("l",A94)),"QL",IF(ISNUMBER(FIND("m",A94)),"QM",IF(ISNUMBER(FIND("h",A94)),"QH",A94))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-medium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A95)),"QB",IF(ISNUMBER(FIND("l",A95)),"QL",IF(ISNUMBER(FIND("m",A95)),"QM",IF(ISNUMBER(FIND("h",A95)),"QH",A95))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_m</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A96)),"QB",IF(ISNUMBER(FIND("l",A96)),"QL",IF(ISNUMBER(FIND("m",A96)),"QM",IF(ISNUMBER(FIND("h",A96)),"QH",A96))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_med</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A97)),"QB",IF(ISNUMBER(FIND("l",A97)),"QL",IF(ISNUMBER(FIND("m",A97)),"QM",IF(ISNUMBER(FIND("h",A97)),"QH",A97))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_medium</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A98)),"QB",IF(ISNUMBER(FIND("l",A98)),"QL",IF(ISNUMBER(FIND("m",A98)),"QM",IF(ISNUMBER(FIND("h",A98)),"QH",A98))))'>QM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>h</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A99)),"QB",IF(ISNUMBER(FIND("l",A99)),"QL",IF(ISNUMBER(FIND("m",A99)),"QM",IF(ISNUMBER(FIND("h",A99)),"QH",A99))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>hi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A100)),"QB",IF(ISNUMBER(FIND("l",A100)),"QL",IF(ISNUMBER(FIND("m",A100)),"QM",IF(ISNUMBER(FIND("h",A100)),"QH",A100))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>high</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A101)),"QB",IF(ISNUMBER(FIND("l",A101)),"QL",IF(ISNUMBER(FIND("m",A101)),"QM",IF(ISNUMBER(FIND("h",A101)),"QH",A101))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qch</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A102)),"QB",IF(ISNUMBER(FIND("l",A102)),"QL",IF(ISNUMBER(FIND("m",A102)),"QM",IF(ISNUMBER(FIND("h",A102)),"QH",A102))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qchi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A103)),"QB",IF(ISNUMBER(FIND("l",A103)),"QL",IF(ISNUMBER(FIND("m",A103)),"QM",IF(ISNUMBER(FIND("h",A103)),"QH",A103))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qchigh</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A104)),"QB",IF(ISNUMBER(FIND("l",A104)),"QL",IF(ISNUMBER(FIND("m",A104)),"QM",IF(ISNUMBER(FIND("h",A104)),"QH",A104))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc h</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A105)),"QB",IF(ISNUMBER(FIND("l",A105)),"QL",IF(ISNUMBER(FIND("m",A105)),"QM",IF(ISNUMBER(FIND("h",A105)),"QH",A105))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc hi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A106)),"QB",IF(ISNUMBER(FIND("l",A106)),"QL",IF(ISNUMBER(FIND("m",A106)),"QM",IF(ISNUMBER(FIND("h",A106)),"QH",A106))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc high</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A107)),"QB",IF(ISNUMBER(FIND("l",A107)),"QL",IF(ISNUMBER(FIND("m",A107)),"QM",IF(ISNUMBER(FIND("h",A107)),"QH",A107))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-h</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A108)),"QB",IF(ISNUMBER(FIND("l",A108)),"QL",IF(ISNUMBER(FIND("m",A108)),"QM",IF(ISNUMBER(FIND("h",A108)),"QH",A108))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-hi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A109)),"QB",IF(ISNUMBER(FIND("l",A109)),"QL",IF(ISNUMBER(FIND("m",A109)),"QM",IF(ISNUMBER(FIND("h",A109)),"QH",A109))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc-high</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A110)),"QB",IF(ISNUMBER(FIND("l",A110)),"QL",IF(ISNUMBER(FIND("m",A110)),"QM",IF(ISNUMBER(FIND("h",A110)),"QH",A110))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_h</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A111)),"QB",IF(ISNUMBER(FIND("l",A111)),"QL",IF(ISNUMBER(FIND("m",A111)),"QM",IF(ISNUMBER(FIND("h",A111)),"QH",A111))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_hi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A112)),"QB",IF(ISNUMBER(FIND("l",A112)),"QL",IF(ISNUMBER(FIND("m",A112)),"QM",IF(ISNUMBER(FIND("h",A112)),"QH",A112))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qc_high</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A113)),"QB",IF(ISNUMBER(FIND("l",A113)),"QL",IF(ISNUMBER(FIND("m",A113)),"QM",IF(ISNUMBER(FIND("h",A113)),"QH",A113))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qh</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A114)),"QB",IF(ISNUMBER(FIND("l",A114)),"QL",IF(ISNUMBER(FIND("m",A114)),"QM",IF(ISNUMBER(FIND("h",A114)),"QH",A114))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qhi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A115)),"QB",IF(ISNUMBER(FIND("l",A115)),"QL",IF(ISNUMBER(FIND("m",A115)),"QM",IF(ISNUMBER(FIND("h",A115)),"QH",A115))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>qhigh</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A116)),"QB",IF(ISNUMBER(FIND("l",A116)),"QL",IF(ISNUMBER(FIND("m",A116)),"QM",IF(ISNUMBER(FIND("h",A116)),"QH",A116))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q h</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A117)),"QB",IF(ISNUMBER(FIND("l",A117)),"QL",IF(ISNUMBER(FIND("m",A117)),"QM",IF(ISNUMBER(FIND("h",A117)),"QH",A117))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q hi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A118)),"QB",IF(ISNUMBER(FIND("l",A118)),"QL",IF(ISNUMBER(FIND("m",A118)),"QM",IF(ISNUMBER(FIND("h",A118)),"QH",A118))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q high</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A119)),"QB",IF(ISNUMBER(FIND("l",A119)),"QL",IF(ISNUMBER(FIND("m",A119)),"QM",IF(ISNUMBER(FIND("h",A119)),"QH",A119))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-h</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A120)),"QB",IF(ISNUMBER(FIND("l",A120)),"QL",IF(ISNUMBER(FIND("m",A120)),"QM",IF(ISNUMBER(FIND("h",A120)),"QH",A120))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-hi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A121)),"QB",IF(ISNUMBER(FIND("l",A121)),"QL",IF(ISNUMBER(FIND("m",A121)),"QM",IF(ISNUMBER(FIND("h",A121)),"QH",A121))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q-high</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A122)),"QB",IF(ISNUMBER(FIND("l",A122)),"QL",IF(ISNUMBER(FIND("m",A122)),"QM",IF(ISNUMBER(FIND("h",A122)),"QH",A122))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_h</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A123)),"QB",IF(ISNUMBER(FIND("l",A123)),"QL",IF(ISNUMBER(FIND("m",A123)),"QM",IF(ISNUMBER(FIND("h",A123)),"QH",A123))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_hi</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A124)),"QB",IF(ISNUMBER(FIND("l",A124)),"QL",IF(ISNUMBER(FIND("m",A124)),"QM",IF(ISNUMBER(FIND("h",A124)),"QH",A124))))'>QH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>q_high</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:fmla='=IF(ISNUMBER(FIND("b",A125)),"QB",IF(ISNUMBER(FIND("l",A125)),"QL",IF(ISNUMBER(FIND("m",A125)),"QM",IF(ISNUMBER(FIND("h",A125)),"QH",A125))))'>QH</TD></TR></TBODY></TABLE>
 
Upvote 0

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
xenou said:
I'm afraid I have not tested this so it probably has some error in it.
I tried to set this up to be a "stringent" test. We won't assign a QH if there is an M in the string, and vice versa. We will assign a "B" if there is an "L", but an "L" only if there is no "B".

The output is to a new workbook to prevent any problems with your original data (I don't know if there's more on the spreadsheet. Presumably, you can just copy it back if it looks right.

There's is a line to set the range to process, which you must adjust for your actual range:
Code: 
    '//Set the range to be processed
    a = .[COLOR=blue]Range("A1:A10000")[/COLOR].Value

Fingers crossed! (one suspects that you'll find more "exceptions" once you run through all the data. If it works, I would then sort or filter the results for anything not QB,QL,QM,QH and see what didn't make it).

Code: 
Sub Foo()
Dim sTemp As String
Dim i As Long
Dim a, b
Dim ws As Worksheet
Dim wbOutput As Workbook
 
Set ws = ActiveSheet
 
With ws
    '//Set the range to be processed
    a = .Range("A1:A10000").Value
 
    Redim b(1 to Ubound(a,1),1)
 
    For i = 1 to Ubound(a,1)
 
        '-------------------------------------
        If IsNumeric(a(i,1)) Then
 
            b(i,1) = a(i,1)
 
        Else
 
            b(i,1) = UCase(a(i,1))
 
            '--------------------------------------------------------
            '//Attempt to match: (L can exist with B)
            If InStr(1,b(i,1),"B") > 0 Then
                b(i,1) = "QB"
            ElseIf InStr(1,b(i,1),"L") > 0 Then
                 b(i,1) = "QL"
            End If
 
            '//M cannot exist with H and vice versa
        If b(i,1) <> "QB" And b(i,1) <> "QL" Then
                If InStr(1,b(i,1),"M") > 0 XOr InStr(1,b(i,1),"H") > 0 Then
                        If Instr(1, b(i,1), "M") > 0 Then
                            b(i, 1) = "QM"
            Else
                b(i, 1) = "QH"
                End If
        End If
        End If
 
        End If
 
    Next i
 
End With
 
'//Output processed values
Set wbOutput = Workbooks.Add
wbOutput.Worksheets(1).Cells(1,1).Resize(Ubound(a,1)).Value = a
wbOutput.Worksheets(1).Cells(1,2).Resize(Ubound(a,1)).Value = b
 
'//Warning
Msgbox "Values for codes are blank where no match or more than one match was found.  Please scan/sort for blanks and correct these codes."
 
End Sub
Click to expand...


Thanks, xenou, I'll give it a try.
 
Upvote 0
A problem clearly stated is half solved.

So, you could use a formula:

=INDEX({"QB";"QL";"QM";"QH"}, MATCH(TRUE, ISNUMBER(SEARCH({"B","L","M","H"}, A1)), 0))

Or this will put corrected codes in col B:

Code: 
Sub x()
    Dim wks         As Worksheet
    Dim cell        As Range

    Set wks = ActiveSheet
    With wks
        For Each cell In Intersect(.UsedRange, .Columns("A"))
            cell.Offset(, 1).Value = Evaluate("INDEX({""QB"";""QL"";""QM"";""QH""}, " & _
                                             "MATCH(TRUE, ISNUMBER(SEARCH({""B"",""L"",""M"",""H""}, " & cell.Address & ")), 0))")
        Next cell
    End With
End Sub
 
Upvote 0
=IF(ISNUMBER(FIND("b",A1)),"QB",IF(ISNUMBER(FIND("l",A1)),"QL",IF(ISNUMBER(FIND("m",A1)),"QM",IF(ISNUMBER(FIND("h",A1)),"QH",A1))))
Click to expand...

This may be fine - you can use SEARCH() instead of FIND() and it is not case sensitive. Probably easier than all the VBA. I was trying to be more rigorous with the code by excluding any results that could fit two or more categories (such as an H and an M). But I realized you could end up with a B and an H/M or an L and an H/M so its not really meeting that goal anyway. The formula will be progressively more rigorous (so the order of the IF's matters, as with the L's) - B can exist with L/H/M, L can exist with H/M, and H can exist with M.

Edit:
Code: 
=INDEX({"QB";"QL";"QM";"QH"}, MATCH(TRUE, ISNUMBER(SEARCH({"B","L","M","H"}, A1)), 0))
Excellent.
 
Last edited:
Upvote 0
xenou said:
This may be fine - you can use SEARCH() instead of FIND() and it is not case sensitive. Probably easier than all the VBA. I was trying to be more rigorous with the code by excluding any results that could fit two or more categories (such as an H and an M). But I realized you could end up with a B and an H/M or an L and an H/M so its not really meeting that goal anyway. The formula will be progressively more rigorous (so the order of the IF's matters, as with the L's) - B can exist with L/H/M, L can exist with H/M, and H can exist with M.

Edit:
Code: 
=INDEX({"QB";"QL";"QM";"QH"}, MATCH(TRUE, ISNUMBER(SEARCH({"B","L","M","H"}, A1)), 0))
Excellent.
Click to expand...


Thanks, xenou, however, "m" and "h" can only ever exist alone; "b" may exist with "l", but it doesn't have to. It can never exist with "m" or "h". Conversely, "l" may exist with "b", but likewie, it can never exist with "m" or "h".

So, just to test my hypothesis about how to go about solving this, I defaulted to constructing an Excel formula since I am way, WAY more comfortable with building formulas than using VBA and writing code.

Anyway, I want to use VBA because I just want it to automatically loop through all files (i.e. workbooks) in a folder without requiring me to open each one (hundreds) and pasting in the Excel formula. This would be especially problematic since the values I'm looking to test are not in contiguous/successive cells in the results files. There is a repetition factor, I think every 39 rows or such, so I just wanted the logic to test the results once extracted; I didn't want to have to go through all those workbooks and paste the formula in column B of every 39th row. (Heck, if I had to go through the effort of doing it that way (i.e., manually copying/pasting the formula then copying/pasting the result, I might as well just look at each and every value myself and change them all by hand, right? :confused: )

Thanks!
 
Upvote 0
shg4421 said:
A problem clearly stated is half solved.

So, you could use a formula:

=INDEX({"QB";"QL";"QM";"QH"}, MATCH(TRUE, ISNUMBER(SEARCH({"B","L","M","H"}, A1)), 0))

Or this will put corrected codes in col B:

Code: 
Sub x()
    Dim wks         As Worksheet
    Dim cell        As Range
 
    Set wks = ActiveSheet
    With wks
        For Each cell In Intersect(.UsedRange, .Columns("A"))
            cell.Offset(, 1).Value = Evaluate("INDEX({""QB"";""QL"";""QM"";""QH""}, " & _
                                             "MATCH(TRUE, ISNUMBER(SEARCH({""B"",""L"",""M"",""H""}, " & cell.Address & ")), 0))")
        Next cell
    End With
End Sub
Click to expand...

Outstanding SHG! Although I don't understand its construction just yet, your Excel formula works like a charm. :) If I'm ever in TX, I'll have to look you up and buy you a beer... or two.

I'll give the VBA code a shot. I'll wager anything you've nailed it, and that is what I'm after. As described in my reply to Xenou, VBA is the route since I want to do this process without having to manually open the hundreds of files and manually paste any worksheet formulas since it's not time effective. I just want to tell it to search through all files in a folder and make the necessary replacements. And while I don't understand the nuaces of the VBA code, too, I think I can get it to do that, but I might have to enlist your assistance again. ;)

Thanks!
 
Upvote 0
It's pretty much the same formula as yours, just a little more compact.

The MATCH part returns 1, 2, 3, or 4, corresponding to the first character (B, L, M, or H) found in the string. The INDEX part chooses the answer based on that.

If fairness, yours is probably faster, since it quits as soon as it's got what it needs. Mine looks for all the characters, whether it needs to or not.
 
Upvote 0
shg4421 said:
It's pretty much the same formula as yours, just a little more compact.

The MATCH part returns 1, 2, 3, or 4, corresponding to the first character (B, L, M, or H) found in the string. The INDEX part chooses the answer based on that.

If fairness, yours is probably faster, since it quits as soon as it's got what it needs. Mine looks for all the characters, whether it needs to or not.
Click to expand...

I spent a little time with your formula last night and deconstructed it so as to understand it better. It's very slick! I was unaware of the MATCH function (or the differences between SEARCH and FIND) and thus I had to use a bunch of nested IFs. As it was, mine only did half of the job and it was "ugly" to look at. Yours is like a work of art! :cool:

And I tested your VBA code last night, as well. Works like a charm! Again - many, many thanks! :biggrin:

MSG
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
convert .wq1 to .xlsm
Replies
5
Views
1K
mole999
mole999

Forum statistics

Threads
1,223,264
Messages
6,171,081
Members
452,377
Latest member
bradfordsam

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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