Skilled Macro: Find columns by name and highlight them certain colors based on text in another column

VBAProIWish · Jul 9, 2009

Hello all,

I have a worksheet with 20+ columns. For this macro, I only need to focus on 4 of them. However, none of these columns are ever in a fixed position so the macro would need to find them by name and NOT by column position. Here they are...

1. Vacation Type (will only have a text value of either "Cold" or "Warm")

2. Vacation Started (will always have a date *x/xx/xxxx)

3. Vacation Ended (sometimes it will have a date '*x/xx/xxxx' and sometimes it will NOT have a date and will be truly blank)

4. Number of Days (currently has ALL truly blank cells)

THIS WHOLE MACRO SHOULD NOT BE CASE SENSITIVE ANYWHERE

Here's what I would like the macro to do...

Scenario 1 - for "Cold" values
Find "Cold" text values in the "Vacation Type" column

"Cold" values WITH a date in the "Vacation Ended" column

IF there IS a date in the "Vacation Ended" column in the same row, put the number of days difference between the "Vacation Started" column and "Vacation Ended" column in the "Number of Days" column.

The amount of days in the "Number of Days" column will determine whether these cells should be highlighted GREY or RED.

A) IF the number of days difference is 7 days or less, highlight the cells in the "Vacation Ended" column and "Number of Days" column RED.

OR...

B) IF the number of days difference is MORE than 7 days, highlight the cells in the "Vacation Ended" column and "Number of Days" column GREY.

AGAIN, A & B above are ONLY if the text value in the "Vacation Type" column says "Cold" with some date in the "Vacation Ended" column.

Scenario 2 - for "Cold" values
Find "Cold" text values in the "Vacation Type" column

"Cold" values WITHOUT a date in the "Vacation Ended" column

C) If there is NOT a date in the "Vacation Ended" column in the same row, put a "-" in the "Number of Days" column and highlight the cells in the "Vacation Ended" column and the "Number of Days" column GREY.

AGAIN, C) Above Is ONLY if the text value in the "Vacation Type" column says "Cold" and has NO date in the "Vacation Ended" column.

Scenario 1 - for "Warm" values
Find "Warm" text values in the "Vacation Type" column

"Warm" values WITH a date in the "Vacation Ended" column

D) If there IS ANY date in the "Vacation Ended" column in the same row, put the number of days difference in the "Number of Days" column and highlight the cells in the "Vacation Ended" column and the "Number of Days" column GREY.

AGAIN, D) above is ONLY if the text value in the "Vacation Type" column says "Warm" with some date in the "Vacation Ended" column.

Scenario 2 - for "Warm" values
Find "Warm" text values in the "Vacation Type" column

"Warm" values WITHOUT a date in the "Vacation Ended" column

E) If there is NOT a date in the "Vacation Ended" column in the same row, put a "-" in the "Number of Days" column and highlight the cells in the "Vacation Ended" column and the "Number of Days" RED.

AGAIN, E) Above Is ONLY if the text value in the "Vacation Type" column says "Warm" and has NO date in the "Vacation Ended" column.

Wow, It'll be very interesting to see how all you pros come up with this code. I feel like a kid waiting to open up presents!

Thanks now and thanks later!

VBAProIWish · Jul 10, 2009

WANT TO UPDATE: Skilled Macro: Find columns by name and highlight them certain colors based on text in another column

Hello,

I have a sample spreadsheet I'd like to attach that will make this macro WAY easier to understand, but I can't see where to upload it? Is this possible?

Thanks

Sandeep Warrier · Jul 10, 2009

Re: WANT TO UPDATE: Skilled Macro: Find columns by name and highlight them certain colors based on text in another column

VBAProIWish said:
Hello,

I have a sample spreadsheet I'd like to attach that will make this macro WAY easier to understand, but I can't see where to upload it? Is this possible?

Thanks

You could try to post your data using Excel Jeanie. Steps on how to use it are given on the website.
<input id="gwProxy" type="hidden"><input *******="jsCall();" id="jsProxy" type="hidden">

VBAProIWish · Jul 11, 2009

sandeep,

Thanks for the info, I'll try that sometime, it looks challenging.

Tom Urtis · Jul 11, 2009

Then just select and copy a reasonable sized range on your worksheet, and paste it directly into the message section of your next post.

VBAProIWish · Jul 11, 2009

Updated with sample>>Skilled Macro: Find columns by name and highlight them certain colors based on text in another column

Okay thanks,

I'll give that a shot. There are 2 separate sets of data to show. Note that I have changed the "Scenario numbering and lettering" a little in the worksheet, but you should get the idea...

The 2 sets of data below should clarify a bit further what I need...
I would disregard my intial post to this thread as the "Scenario" letters and numbers have changed a bit. This post has ALL that is needed to understand what I need.

Here's the first one...

<TABLE style="WIDTH: 650pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=866 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><TBODY><TR style="HEIGHT: 36pt; mso-height-source: userset" height=48><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: yellow; WIDTH: 265pt; HEIGHT: 36pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 1.5pt solid; mso-ignore: colspan" class=xl31 height=48 width=353 colSpan=5 align=middle>Current Data and appearance</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; WIDTH: 120pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 1.5pt solid; mso-ignore: colspan" class=xl29 width=160 colSpan=2 align=middle>What Scenario does it match?</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: yellow; WIDTH: 265pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 1.5pt solid; mso-ignore: colspan" class=xl76 width=353 colSpan=5 align=middle>Post-Macro Data and appearance</TD></TR><TR style="HEIGHT: 42.75pt; mso-height-source: userset" height=57><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: black; WIDTH: 48pt; HEIGHT: 42.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl38 height=57 width=64>Row 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #993366; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 width=63>Vacation Type</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: aqua; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl72 width=76>Vacation Started</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: aqua; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 width=77 x:str="Vacation Ended ">Vacation Ended </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: blue; WIDTH: 55pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl69 width=73>Number of Days</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: green; WIDTH: 56pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl28 width=75>Scenario #</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: green; WIDTH: 64pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl55 width=85>Letter #</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: black; WIDTH: 48pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl51 width=64>Row 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #993366; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: #e0dfe3" class=xl74 width=63>Vacation Type</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: aqua; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl72 width=76>Vacation Started</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: aqua; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: white 0.5pt solid" class=xl75 width=77 x:str="Vacation Ended ">Vacation Ended </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: blue; WIDTH: 55pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl70 width=73>Number of Days</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39855">2/11/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39855">2/11/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39855">2/11/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl61 width=77 align=right x:num="39855">2/11/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl62 width=73 x:num x:fmla="=K3-J3">0</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>COLD</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39855">2/11/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>C</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>COLD</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39855">2/11/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 4</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39856">2/12/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39928">4/25/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 4</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39856">2/12/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39928">4/25/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num x:fmla="=K5-J5">72</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 5</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39856">2/12/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>C</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 5</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39856">2/12/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 6</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>COLD</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39856">2/12/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39857">2/13/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 6</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>COLD</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39856">2/12/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl61 width=77 align=right x:num="39857">2/13/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl62 width=73 x:num x:fmla="=K7-J7">1</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 7</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39934">5/1/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 7</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39934">5/1/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num x:fmla="=K8-J8">74</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 8</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>C</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 8</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 9</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 9</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl61 width=77 align=right x:num="39860">2/16/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl62 width=73 x:num x:fmla="=K10-J10">0</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39862">2/18/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>C</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39862">2/18/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 11</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39862">2/18/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>C</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 11</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=63>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39862">2/18/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl46 height=16>Row 12</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl47 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl48 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl48 width=77 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl49 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl50 x:num>3</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl57>D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl53>Row 12</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl47 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl48 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=77 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl66 width=73 x:num x:fmla="=K13-J13">0</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 13</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39822">1/9/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>3</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 1.5pt solid" class=xl58>D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 13</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39822">1/9/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num x:fmla="=K14-J14">3</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 14</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>WARM</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 1.5pt solid" class=xl56>D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 14</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>WARM</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num x:fmla="=K15-J15">0</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 15</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>4</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>E</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 15</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl61 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl62 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 16</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 16</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39819">1/6/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num x:fmla="=K17-J17">0</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 17</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39821">1/8/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>4</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>E</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 17</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39821">1/8/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl61 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl62 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 18</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39826">1/13/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>4</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>E</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 18</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39826">1/13/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl61 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl62 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 19</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39828">1/15/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39831">1/18/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 19</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39828">1/15/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39831">1/18/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num x:fmla="=K20-J20">3</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 20</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39833">1/20/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39833">1/20/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 20</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39833">1/20/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39833">1/20/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num>0</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 21</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39835">1/22/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77 align=right x:num="39835">1/22/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl56>D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 21</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39835">1/22/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=77 align=right x:num="39835">1/22/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl64 width=73 x:num>0</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl39 height=16>Row 22</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39840">1/27/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl40 width=73></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 x:num>4</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl59>E</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl52>Row 22</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=76 align=right x:num="39840">1/27/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl61 width=77></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: red; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl62 width=73>-</TD></TR><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl41 height=16>Row 23</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl42 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl43 width=76 align=right x:num="39850">2/6/2009</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl43 width=77 align=right x:num="39983">6/19/2009</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl45 width=73></TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl44 x:num>3</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl60>D</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl54>Row 23</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl42 width=63>Warm</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 57pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl43 width=76 align=right x:num="39850">2/6/2009</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 58pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=77 align=right x:num="39983">6/19/2009</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 55pt; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl68 width=73 x:num x:fmla="=K24-J24">133</TD></TR></TBODY></TABLE>

And the second one...

<TABLE style="WIDTH: 668pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=890 x:str><COLGROUP><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 72pt; mso-width-source: userset; mso-width-alt: 3510" width=96><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5083" width=139><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4754" width=130><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5449" width=149><TBODY><TR style="HEIGHT: 65.25pt" height=87><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: red; WIDTH: 100pt; HEIGHT: 65.25pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl47 height=87 width=133>Scenario #</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: aqua; WIDTH: 65pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl48 width=87>Vacation Type</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: aqua; WIDTH: 72pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl48 width=96>Vacation Started</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: aqua; WIDTH: 104pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl49 width=139>Is there a date in the Vacation Ended Column?</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: aqua; WIDTH: 98pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 1.5pt solid" class=xl50 width=130>Is Number of Days
> 7 Days or less
> More than 7 Days
> No Date
> Any Date

</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: aqua; WIDTH: 117pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl51 width=156>Should the cells in the Vacation Ended and Number of Days column be highlighted GREY OR RED?</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: aqua; WIDTH: 112pt; BORDER-TOP: black 1.5pt solid; BORDER-RIGHT: black 1.5pt solid" class=xl50 width=149>Should a number or a "-" be put in the Vacation Ended Column?</TD></TR><TR style="HEIGHT: 14.1pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 14.1pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl31 height=18>Cold Scenario 1A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl42 width=87>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 72pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl32 width=96 align=right x:num="39814">1/1/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl43 width=139>YES</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 98pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl44 width=130>7 Days or Less</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: red; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 0.5pt solid" class=xl45></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: #e0dfe3; BORDER-RIGHT: black 1.5pt solid" class=xl46>number</TD></TR><TR style="HEIGHT: 14.1pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 14.1pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 height=18>Cold Scenario 1B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=87>COLD</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 72pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=96 align=right x:num="39814">1/1/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl33 width=139>YES</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 98pt; BORDER-TOP: black; BORDER-RIGHT: #e0dfe3" class=xl35 width=130>More than 7 Days</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: silver; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl36></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl37>number</TD></TR><TR style="HEIGHT: 14.1pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 14.1pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 height=18>Cold Scenario 2C</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=87>Cold</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 72pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=96 align=right x:num="39814">1/1/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl33 width=139>NO</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 98pt; BORDER-TOP: black; BORDER-RIGHT: #e0dfe3" class=xl35 width=130>No Date</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: silver; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl36></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl37>-</TD></TR><TR style="HEIGHT: 14.1pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 14.1pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl27 height=18>Warm Scenario 3D</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl26 width=87>WARM</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 72pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl24 width=96 align=right x:num="39814">1/1/2009</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl33 width=139>YES</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 98pt; BORDER-TOP: black; BORDER-RIGHT: #e0dfe3" class=xl35 width=130>Any Date</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: silver; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl36></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl37>number</TD></TR><TR style="HEIGHT: 14.1pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 14.1pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl28 height=18>Warm Scenario 4E</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl29 width=87>warm</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 72pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl30 width=96 align=right x:num="39814">1/1/2009</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl38 width=139>NO</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 98pt; BORDER-TOP: black; BORDER-RIGHT: #e0dfe3" class=xl39 width=130>No Date</TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: red; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl40></TD><TD style="BORDER-BOTTOM: black 1.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: black; BORDER-RIGHT: black 1.5pt solid" class=xl41>-</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 13.5pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" height=18></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3"></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3"></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl34></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl34></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3"></TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3"></TD></TR><TR style="HEIGHT: 33pt; mso-height-source: userset" height=44><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 33pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3; mso-ignore: colspan" class=xl53 height=44 colSpan=7 align=middle>CAN SOMEONE WORK THEIR MAGIC TO GET THIS MACRO WORKING ?</TD></TR></TBODY></TABLE>

All scenario information below matches to both data sets above

1. Vacation Type (will only have a text value of either "Cold" or "Warm")

2. Vacation Started (will always have a date *x/xx/xxxx)

3. Vacation Ended (sometimes it will have a date '*x/xx/xxxx' and sometimes it will NOT have a date and will be truly blank)

4. Number of Days (currently has ALL truly blank cells)

THIS WHOLE MACRO SHOULD NOT BE CASE SENSITIVE ANYWHERE

Here's what I would like the macro to do...

Scenario 1 - for "Cold" values
Find "Cold" text values in the "Vacation Type" column

"Cold" values WITH a date in the "Vacation Ended" column

IF there IS a date in the "Vacation Ended" column in the same row, put the number of days difference between the "Vacation Started" column and "Vacation Ended" column in the "Number of Days" column.

The amount of days in the "Number of Days" column will determine whether these cells should be highlighted GREY or RED.

Scenario 1-A

IF the number of days difference is 7 days or less, highlight the cells in the "Vacation Ended" column and "Number of Days" column RED.

OR…

Scenario 1-B

IF the number of days difference is MORE than 7 days, highlight the cells in the "Vacation Ended" column and "Number of Days" column GREY.

AGAIN, 1-A & 1-B above are ONLY if the text value in the "Vacation Type" column says "Cold" with some date in the "Vacation Ended" column.

See both worksheets in the attached spreadsheet for more clarification on this macro...

Scenario 2 - for "Cold" values
Find "Cold" text values in the "Vacation Type" column

"Cold" values WITHOUT a date in the "Vacation Ended" column

Scenario 2-C

If there is NOT a date in the "Vacation Ended" column in the same row, put a "-" in the "Number of Days" column and highlight the cells in the "Vacation Ended" column and the "Number of Days" column GREY.

AGAIN, 2-C Above Is ONLY if the text value in the "Vacation Type" column says "Cold" and has NO date in the "Vacation Ended" column.

Scenario 3 - for "Warm" values
Find "Warm" text values in the "Vacation Type" column

"Warm" values WITH a date in the "Vacation Ended" column

Scenario 3-D

If there IS ANY date in the "Vacation Ended" column in the same row, put the number of days difference in the "Number of Days" column and highlight the cells in the "Vacation Ended" column and the "Number of Days" column GREY.

AGAIN, 3-D above is ONLY if the text value in the "Vacation Type" column says "Warm" with some date in the "Vacation Ended" column.

Scenario 4 - for "Warm" values
Find "Warm" text values in the "Vacation Type" column

"Warm" values WITHOUT a date in the "Vacation Ended" column

Scenario 4-E

If there is NOT a date in the "Vacation Ended" column in the same row, put a "-" in the "Number of Days" column and highlight the cells in the "Vacation Ended" column and the "Number of Days" RED.

AGAIN, 4-E Above Is ONLY if the text value in the "Vacation Type" column says "Warm" and has NO date in the "Vacation Ended" column.

I forgot to mention earlier that I have a slightly altered version of this posted at another forum as well. I figured this would be a tough one. No responses there either. Below is the link.

http://www.excelforum.com/excel-pro...t-data-in-columns-based-on-other-columns.html

thanks a bunch

Sandeep Warrier · Jul 12, 2009

Hello,

This should work. Change Range("D2").Select to your actual number of days column.

You would also need to change the (0,[-1,-2,-3]) values to match the columns End Date, Start Date and Vacation Type columns respectively.

Code:

ActiveCell.Offset(0, -3).Value
ActiveCell.Offset(0, -2).Value
ActiveCell.Offset(0, -1).Value

Code:

Sub SkilledMacro()

    Dim stScenario As String
    Dim lStartDate As Long
    Dim lEndDate As Long
    
    Range("D2").Select
    
    While ActiveCell.Offset(0, -3).Value <> ""
    
        stScenario = ActiveCell.Offset(0, -3).Value
        lStartDate = ActiveCell.Offset(0, -2).Value
        lEndDate = ActiveCell.Offset(0, -1).Value
        
        Select Case stScenario
        
        Case "Cold", "COLD", "cold"
            If lEndDate <> 0 Then
                ActiveCell.Value = lEndDate - lStartDate
                If ActiveCell.Value > 7 Then Range(ActiveCell, ActiveCell.Offset(0, -1)).Interior.ColorIndex = 15
                If ActiveCell.Value <= 7 Then Range(ActiveCell, ActiveCell.Offset(0, -1)).Interior.ColorIndex = 3
            Else
                ActiveCell.Value = "-"
                Range(ActiveCell, ActiveCell.Offset(0, -1)).Interior.ColorIndex = 15
            End If
            
        Case "Warm", "WARM", "warm"
            If lEndDate <> 0 Then
                ActiveCell.Value = lEndDate - lStartDate
                Range(ActiveCell, ActiveCell.Offset(0, -1)).Interior.ColorIndex = 15
            Else
                ActiveCell.Value = "-"
                Range(ActiveCell, ActiveCell.Offset(0, -1)).Interior.ColorIndex = 3
            End If
        
        End Select
        
        ActiveCell.Offset(1, 0).Select
        
    Wend
    

End Sub

Excel Workbook

A

B

C

D

1

Vacation Type

Vacation Started

Vacation Ended

Number of Days

2

Cold

02/11/09

0

3

COLD

02/11/09

-

4

Cold

02/12/09

04/25/09

72

5

Cold

02/12/09

-

6

COLD

02/12/09

02/13/09

1

7

Cold

02/16/09

05/01/09

74

8

cold

02/16/09

-

9

Cold

02/16/09

0

10

Cold

02/18/09

-

11

Cold

02/18/09

-

12

Warm

01/06/09

0

13

Warm

01/06/09

01/09/09

3

14

WARM

01/06/09

0

15

Warm

01/06/09

-

16

Warm

01/06/09

0

17

warm

01/08/09

-

18

Warm

01/13/09

-

19

Warm

01/15/09

01/18/09

3

20

warm

01/20/09

0

21

Warm

01/22/09

0

22

Warm

01/27/09

-

23

Warm

02/06/09

06/19/09

133

Sheet1

VBAProIWish · Jul 12, 2009

sandeep,

This is VERY GOOD STUFF! Thanks much!

And the code wasn't even that long, which was really surprising.

Although my column headers will ALWAYS be in row 1, my column headers are never in a fixed column position.

Is there ANY way you would be able to modify this AWESOME macro to search for the 4 column headers in row 1 by NAME INSTEAD OF COLUMN LETTER?

THANKS MUCH!!!

Sandeep Warrier · Jul 12, 2009

VBAProIWish said:
sandeep,

This is VERY GOOD STUFF! Thanks much!

And the code wasn't even that long, which was really surprising.

Although my column headers will ALWAYS be in row 1, my column headers are never in a fixed column position.

Is there ANY way you would be able to modify this AWESOME macro to search for the 4 column headers in row 1 by NAME INSTEAD OF COLUMN LETTER?

THANKS MUCH!!!

This Should work.

Code:

Sub SkilledMacro()

    Dim stScenario As String
    Dim lStartDate As Long
    Dim lEndDate As Long
    
    Dim lVacType As Long
    Dim lVacStart As Long
    Dim lVacEnd As Long
    Dim lNoofDays As Long
    Dim l As Long
    
    Rows("1:1").Select
    
    With Selection
    
        .Find(What:="Vacation Type", After:=Cells(1, 1), LookIn:= _
            xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
            xlNext, MatchCase:=False, SearchFormat:=False).Activate
        
        lVacType = ActiveCell.Column
        
        .Find(What:="Vacation Started", After:=Cells(1, 1), LookIn:= _
            xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
            xlNext, MatchCase:=False, SearchFormat:=False).Activate
        
        lVacStart = ActiveCell.Column
        
        .Find(What:="Vacation Ended", After:=Cells(1, 1), LookIn:= _
            xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
            xlNext, MatchCase:=False, SearchFormat:=False).Activate
        
        lVacEnd = ActiveCell.Column
        
        .Find(What:="Number of Days", After:=Cells(1, 1), LookIn:= _
            xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
            xlNext, MatchCase:=False, SearchFormat:=False).Activate
        
        lNoofDays = ActiveCell.Column
    
    End With
    
    l = Columns(lVacType).SpecialCells(xlCellTypeConstants).Count
    
    For i = 2 To l
        
        Cells(i, lNoofDays).Select
        
        stScenario = Cells(i, lVacType).Value
        lStartDate = Cells(i, lVacStart).Value
        lEndDate = Cells(i, lVacEnd).Value
        
        Select Case stScenario
        
        Case "Cold", "COLD", "cold"
            If lEndDate<> 0 Then
                ActiveCell.Value = lEndDate - lStartDate
                If ActiveCell.Value > 7 Then
                    ActiveCell.Interior.ColorIndex = 15
                    Cells(i, lVacEnd).Interior.ColorIndex = 15
                ElseIf ActiveCell.Value<= 7 Then
                    ActiveCell.Interior.ColorIndex = 3
                    Cells(i, lVacEnd).Interior.ColorIndex = 3
                End If
            Else
                ActiveCell.Value = "-"
                ActiveCell.Interior.ColorIndex = 15
                Cells(i, lVacEnd).Interior.ColorIndex = 15
            End If
            
        Case "Warm", "WARM", "warm"
            If lEndDate<> 0 Then
                ActiveCell.Value = lEndDate - lStartDate
                ActiveCell.Interior.ColorIndex = 15
                Cells(i, lVacEnd).Interior.ColorIndex = 15
            Else
                ActiveCell.Value = "-"
                ActiveCell.Interior.ColorIndex = 3
                Cells(i, lVacEnd).Interior.ColorIndex = 3
            End If
        
        End Select
        
    Next i
    
End Sub

Excel Workbook

C

D

E

F

G

H

I

J

K

L

M

1

VacationType

VacationStarted

VacationEnded

NumberofDays

2

Cold

02/11/09

0

3

COLD

02/11/09

-

4

Cold

02/12/09

04/25/09

72

5

Cold

02/12/09

-

6

COLD

02/12/09

02/13/09

1

7

Cold

02/16/09

05/01/09

74

8

cold

02/16/09

-

9

Cold

02/16/09

0

10

Cold

02/18/09

-

11

Cold

02/18/09

-

12

Warm

01/06/09

0

13

Warm

01/06/09

01/09/09

3

14

WARM

01/06/09

0

15

Warm

01/06/09

-

16

Warm

01/06/09

0

17

warm

01/08/09

-

18

Warm

01/13/09

-

19

Warm

01/15/09

01/18/09

3

20

warm

01/20/09

0

21

Warm

01/22/09

0

22

Warm

01/27/09

-

23

Warm

06/02/09

06/19/09

17

Sheet1

VBAProIWish · Jul 13, 2009

sandeep.warrier

All I can say is

WWWWoooWWWWW !!!!

PERFECTION TO THE MAX!

I never thought I'd be able to explain what I want in this macro, let alone actually get the code for it.

You are truly a great programmer!

Many many thanks!

Skilled Macro: Find columns by name and highlight them certain colors based on text in another column

VBAProIWish

Well-known Member

Excel Facts

VBAProIWish

Well-known Member

Sandeep Warrier

Well-known Member

VBAProIWish

Well-known Member

Tom Urtis

MrExcel MVP

VBAProIWish

Well-known Member

Sandeep Warrier

Well-known Member

VBAProIWish

Well-known Member

Sandeep Warrier

Well-known Member

VBAProIWish

Well-known Member

Similar threads

Forum statistics

Share this page

Skilled Macro: Find columns by name and highlight them certain colors based on text in another column

Well-known Member

Excel Facts

Well-known Member

Well-known Member

Well-known Member

MrExcel MVP

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock