Formula Help... If, Vlookup, Nesting

K

Kookai

New Member
Joined
May 29, 2011
Messages
32
Hi Guys, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p> </o:p>
am not really good in excel and would like to ask help.... might be easy for u guys....<o:p></o:p>
<o:p> </o:p>
I have 2 work sheets... (request & Report). <o:p></o:p>
<o:p> </o:p>
In Request Sheet, I've got column <o:p></o:p>
<o:p> </o:p>
B1 - Reference <o:p></o:p>
C2 - Date Received <o:p></o:p>
I1 - Status (Pending, awaitng Reply,cancelled,Complete,Under study or blank) <o:p></o:p>
J1 - Reply Date <o:p></o:p>
N1-NOC status (Cancelled,Released,Blank) <o:p></o:p>
<o:p> </o:p>
Now what i want to happen is, in column I1, there is 5 days review cycle after receiving the request. So, if the reviewer, didnt give it after 5 days after received, I1 = Pending , then if its less than 5 days I1 = Under Study. However, if my N1 is RELEASED, I1 = Complete, and if N1 is Cancelled I1 = Cancelled and if N1 is blank my I1 = Awaiting Response, then lastly if C2 is blank, I1 = blank. Is this possible? <o:p></o:p>
<o:p> </o:p>
Then on Report Sheet, <o:p></o:p>
i want to automatically copy B1,C2,J1 of Request sheet on Report Sheet if its complete, and for other 5 statuses.... <o:p></o:p>
<o:p> </o:p>
I have attached a sample excel... thak you very much for all your kind help... <o:p></o:p>
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
Hi,

I cannot help you with the last part of your problem, sorry, but does this give you some help with the IF problem?....


Excel Workbook
BCDEFGHIJKLMN
1ReferenceDate Received*****StatusReply date***NOC Status
2AB12301/06/2011*****Under Study*****
Request



Ak
 
Upvote 0
Hi,

I tried the formula but didnt work... and also, just would like to clarify that the Request would only be "Pending" if todays date pass 5 days after the request received...

Example:
if todays date - C2 >5 = "pending"
if todays date - C2 <5 = "Under Study"

But dont know how to put it in formula... Help please

Thank You
 
Upvote 0
Hi,

does this help?

=IF(N2="Released","Complete",IF(N1="Cancelled","Cancelled",IF(N1="","Awaiting Response",IF(TODAY()-C2>5,"Pending",IF(TODAY()-C2<5,"Under Study","")))))

Ak
 
Upvote 0
Hi AK,


thank You, It works, but why is it not calcualting the Pending & Under study...

please see below sample.... in I column,there are awaiting response that should be "Under Study" (highlighted in blue) ; and there is Pending that should be Complete (Highlighted in gray); and there is Awaiting response that should be Pending (Highlighted in orange)...

Can you please advise what to do... this doing my head in :-( thank You.

<TABLE style="WIDTH: 798pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1063 border=0><COLGROUP><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" width=129><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 5741" width=157><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 300pt; mso-width-source: userset; mso-width-alt: 14628" width=400><TBODY><TR style="HEIGHT: 39pt; mso-height-source: userset" height=52><TD class=xl75 id=td_post_2750480 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 97pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 39pt; BACKGROUND-COLOR: #ccffcc" width=129 height=52>B
​
</TD><TD class=xl76 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=85>C
​
</TD><TD class=xl76 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 118pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=157>I
​
</TD><TD class=xl76 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=111>J
​
</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ffcc99" width=117>N

</TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl113 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=45>TSD-NOC-11-266</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>25-May-11</TD><TD class=xl119 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4" align=left>Awaiting Response</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111></TD><TD class=xl121 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Pending </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400>IF(N3="Released","Complete",IF(N3="Cancelled","Cancelled",IF(N3="","Awaiting Response",IF(TODAY()-C3>5,"Pending",IF(TODAY()-C3<5,</TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl113 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=60>TSD-NOC-11-267</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>25-May-11</TD><TD class=xl119 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4" align=left>Awaiting Response</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111></TD><TD class=xl121 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Pending </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 56.25pt" height=75><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 56.25pt; BACKGROUND-COLOR: transparent" width=129 height=75>TSD-NOC-11-277</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>2-Jun-11</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>Awaiting Response</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>2-Jun-11</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" width=129 height=45>TSD-NOC-11-278</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>2-Jun-11</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>Complete</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>5-Jun-11</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>RELEASED</TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" width=129 height=45>TSD-NOC-11-279</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>5-Jun-11</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>Complete</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>8-Jun-11</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>RELEASED</TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl94 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #bfbfbf" width=129 height=45>TSD-NOC-11-280</TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #bfbfbf" width=85>5-Jun-11</TD><TD class=xl100 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #bfbfbf" align=left>Pending</TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #bfbfbf" width=111>7-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #bfbfbf" width=117>RELEASED </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Complete </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 22.5pt" height=30><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent" width=129 height=30>TSD-NOC-11-281</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>6-Jun-11</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>Awaiting Response</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>7-Jun-11</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: transparent" width=129 height=60>TSD-NOC-11-282</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>6-Jun-11</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>Pending</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>8-Jun-11</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>RELEASED </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" width=129 height=45>TSD-NOC-11-283</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>6-Jun-11</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>Pending</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>8-Jun-11</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>RELEASED </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl113 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=60>TSD-NOC-11-284</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>6-Jun-11</TD><TD class=xl119 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4" align=left>Awaiting Response</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111></TD><TD class=xl121 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Pending </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl94 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #bfbfbf" width=129 height=45>TSD-NOC-11-285</TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #bfbfbf" width=85>6-Jun-11</TD><TD class=xl100 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #bfbfbf" align=left>Pending</TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #bfbfbf" width=111>9-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #bfbfbf" width=117>RELEASED </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Complete </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl113 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=45>TSD-NOC-11-286</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>7-Jun-11</TD><TD class=xl119 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4" align=left>Awaiting Response</TD><TD class=xl114 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111></TD><TD class=xl121 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Pending </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" width=129 height=45>TSD-NOC-11-288</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>8-Jun-11</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>Awaiting Response</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>12-Jun-11</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #b6dde8" width=129 height=60>TSD-NOC-11-289</TD><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=85>12-Jun-11</TD><TD class=xl110 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #b6dde8" align=left>Awaiting Response</TD><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=111></TD><TD class=xl112 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Under study </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #b6dde8" width=129 height=45>TSD-NOC-11-290</TD><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=85>12-Jun-11</TD><TD class=xl110 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #b6dde8" align=left>Awaiting Response</TD><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=111></TD><TD class=xl112 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Under study </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #b6dde8" width=129 height=60>TSD-NOC-11-291</TD><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=85>12-Jun-11</TD><TD class=xl110 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #b6dde8" align=left>Awaiting Response</TD><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=111></TD><TD class=xl112 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #b6dde8" width=117></TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Under study </TD><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 300pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=400></TD></TR></TBODY></TABLE>​
 
Upvote 0
Hi,

Does this work?...

=IF(N2="Released","Complete",IF(N2="Cancelled","Cancelled",IF(TODAY()-C2>5,"Pending",IF(TODAY()-C2<5,"Under Study",IF(N1="","Awaiting Response","")))))

Ak
 
Upvote 0
Hi AK,

thank you again, it is working but got some issues again...

<TABLE style="WIDTH: 605pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=806 border=0><COLGROUP><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" width=129><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 5741" width=157><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5229" width=143><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><TBODY><TR style="HEIGHT: 39pt; mso-height-source: userset" height=52><TD class=xl68 id=td_post_2752144 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 97pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 39pt; BACKGROUND-COLOR: #ccffcc" width=129 height=52>
B​
</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=85>
C​
</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 118pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=157>
I​
</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=111>
J​
</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=117>
N​
</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 107pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: yellow" width=143>
New Formula ​
</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl87 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=45>TSD-NOC-11-266</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>25-May-11</TD>i highlighted all with the problems in green, and put one column for the formula that u have provided... and the remarks after new formula column.

There are "Pending" on New Formula column that should be "Awaiting Response", "completed", "Under Study".
I am sorry for bugging u with this but this really frustrates me :-(

<TD class=xl93 id=td_post_2752144 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4">Awaiting Response</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111> </TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117> </TD><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Ok </TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl87 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=60>TSD-NOC-11-267</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>25-May-11</TD><TD class=xl93 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4">Awaiting Response</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111> </TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117> </TD><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Ok </TD></TR><TR style="HEIGHT: 56.25pt" height=75><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 56.25pt; BACKGROUND-COLOR: #92d050" width=129 height=75>TSD-NOC-11-277</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>2-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Awaiting Response</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>2-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Awaiting Response </TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>TSD-NOC-11-278</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>2-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Complete</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>5-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>RELEASED</TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Completed</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>TSD-NOC-11-279</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>5-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Complete</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>8-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>RELEASED</TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Completed</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>TSD-NOC-11-280</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>5-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Pending</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>7-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>RELEASED </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Completed</TD></TR><TR style="HEIGHT: 22.5pt" height=30><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 22.5pt; BACKGROUND-COLOR: #92d050" width=129 height=30>TSD-NOC-11-281</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>6-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Awaiting Response</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>7-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Awaiting Response </TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>TSD-NOC-11-282</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>6-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Pending</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>8-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>RELEASED </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Completed</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>TSD-NOC-11-283</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>6-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Pending</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>8-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>RELEASED </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Completed</TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl87 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=60>TSD-NOC-11-284</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>6-Jun-11</TD><TD class=xl93 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4">Awaiting Response</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111> </TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117> </TD><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>ok </TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>TSD-NOC-11-285</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>6-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Pending</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>9-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>RELEASED </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Completed</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl87 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #fcd5b4" width=129 height=45>TSD-NOC-11-286</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=85>7-Jun-11</TD><TD class=xl93 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fcd5b4">Awaiting Response</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=111> </TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=117> </TD><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fcd5b4" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>ok </TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>TSD-NOC-11-288</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>8-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Awaiting Response</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>12-Jun-11</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Awaiting Response </TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>TSD-NOC-11-289</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>12-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Awaiting Response</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111> </TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Under Study </TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>TSD-NOC-11-290</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>12-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Awaiting Response</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111> </TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Under Study </TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl97 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>TSD-NOC-11-291</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>12-Jun-11</TD><TD class=xl102 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050">Awaiting Response</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111> </TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 107pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=143>Pending</TD><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64>Under Study </TD></TR></TBODY></TABLE>
 
Upvote 0
Hi,

Try this....

=IF(N2="Released","Completed",IF(N2="Cancelled","Cancelled",IF(AND(TODAY()-C2>5,J2<>""),"Awaiting Review",IF(TODAY()-C2>5,"Pending",IF(TODAY()-C2>5,"Pending",IF(TODAY()-C2<5,"Under Study",IF(N2="","Awaiting Response","")))))))

Ak
 
Upvote 0
Hi AK,

thanks for the response. I have tried the formula it works fine... but didnt read the "completed"

there are awaiting review that should be Completed...
where as the condition is: if N1 = Released, I1 = Completed... but when i tried your formula the value that comes up is Awaiting Review.

conditions:

If N1 = Released, J1 = has a value (date) then, I1 = Completed
if N1 = Cancelled, then I1 = Cancelled
If N1 = blank, J1 = has a value (date) then I1 = Awaiting response
if today - C1 > 5, then I1 = Pending (N1 = blank, and J1 = blank)
if today - C1 < 5, then I1 = Under Study (N1=blank, J1 = blank)
if c1 is blank then I1 is blank.


Hope you can help me still... :-)

P.S... this regard the values on I column... i have tried other formula... yours was in the last column.


<TABLE style="WIDTH: 715pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=951 border=0><COLGROUP><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" width=129><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 5741" width=157><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 134pt; mso-width-source: userset; mso-width-alt: 6509" width=178><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6363" width=174><TBODY><TR style="HEIGHT: 39pt; mso-height-source: userset" height=52><TD class=xl69 id=td_post_2753705 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 97pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 39pt; BACKGROUND-COLOR: #ccffcc" width=129 height=52>
B​
</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=85>
C​
</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 118pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=157>
I​
</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=111>
J​
</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=117>
N​
</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 134pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc" width=178>
REMARKS / SHOULD BE ​
</TD><TD class=xl110 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 131pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" width=174>
AK Formula ​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>
TSD-NOC-11-266​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
25-May-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Awaiting Response​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0 0.5pt; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Pending​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Pending​
</TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>
TSD-NOC-11-267​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
25-May-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Awaiting Response​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Pending​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Pending​
</TD></TR><TR style="HEIGHT: 56.25pt" height=75><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 56.25pt; BACKGROUND-COLOR: transparent" width=129 height=75>
TSD-NOC-11-277​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>
2-Jun-11​
</TD><TD class=xl81 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>
Awaiting Response​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>
2-Jun-11​
</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Awaiting Review​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" width=129 height=45>
TSD-NOC-11-278​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>
2-Jun-11​
</TD><TD class=xl81 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>
Completed​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>
5-Jun-11​
</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>
RELEASED​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Completed​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" width=129 height=45>
TSD-NOC-11-279​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>
5-Jun-11​
</TD><TD class=xl81 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>
Completed​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>
8-Jun-11​
</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>
RELEASED​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Completed​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>
TSD-NOC-11-280​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
5-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Pending​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
7-Jun-11​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
RELEASED ​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Completed​
</TD><TD class=xl114 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: yellow">
Awaiting Review​
</TD></TR><TR style="HEIGHT: 22.5pt" height=30><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent" width=129 height=30>
TSD-NOC-11-281​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>
6-Jun-11​
</TD><TD class=xl81 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>
Awaiting Response​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>
7-Jun-11​
</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Awaiting Review​
</TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>
TSD-NOC-11-282​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
6-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Pending​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
8-Jun-11​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
RELEASED ​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Completed​
</TD><TD class=xl114 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: yellow">
Awaiting Review​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>
TSD-NOC-11-283​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
6-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Pending​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
8-Jun-11​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
RELEASED ​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Completed​
</TD><TD class=xl114 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: yellow">
Awaiting Review​
</TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>
TSD-NOC-11-284​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
6-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Awaiting Response​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Pending​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Pending​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>
TSD-NOC-11-285​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
6-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Pending​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
9-Jun-11​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
RELEASED ​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Completed​
</TD><TD class=xl114 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: yellow">
Awaiting Review​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>
TSD-NOC-11-286​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
7-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Awaiting Response​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Pending​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Pending​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl105 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" width=129 height=45>
TSD-NOC-11-288​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=85>
8-Jun-11​
</TD><TD class=xl81 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" align=left>
Awaiting Response​
</TD><TD class=xl106 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=111>
12-Jun-11​
</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Awaiting Review​
</TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>
TSD-NOC-11-289​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
12-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Awaiting Response​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Under Study ​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Under Study​
</TD></TR><TR style="HEIGHT: 33.75pt" height=45><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: #92d050" width=129 height=45>
TSD-NOC-11-290​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
12-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Awaiting Response​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Under Study ​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Under Study​
</TD></TR><TR style="HEIGHT: 45pt" height=60><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 97pt; BORDER-BOTTOM: #f0f0f0 0.5pt; HEIGHT: 45pt; BACKGROUND-COLOR: #92d050" width=129 height=60>
TSD-NOC-11-291​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=85>
12-Jun-11​
</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #92d050" align=left>
Awaiting Response​
</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 83pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=111>
​
</TD><TD class=xl98 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 88pt; BORDER-BOTTOM: #f0f0f0 0.5pt; BACKGROUND-COLOR: #92d050" width=117>
​
</TD><TD class=xl112 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ccc0da">
Under Study ​
</TD><TD class=xl113 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">
Under Study​
</TD></TR></TBODY></TABLE>
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Populating row headers based on column values
2
Replies
14
Views
1K
Jonam711
J
F
  • Question Question
Looking to index some data based on multiple criteria, then index further data based on the 1st indexed data results
2
Replies
13
Views
910
KRice
K
F
  • Question Question
Count # of values that fall within a certain date range
Replies
1
Views
572
RobP
R
L
  • Locked
  • Question Question
Help Cleaning Up Code
Replies
2
Views
592
RoryA
RoryA
tezza
  • Question Question
Option explicit workbook help
Replies
3
Views
623
igold
igold

Forum statistics

Threads
1,224,567
Messages
6,179,571
Members
452,927
Latest member
whitfieldcraig

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