My data sheet looks like this,
<TABLE style="WIDTH: 469pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=625 border=0><COLGROUP><COL style="WIDTH: 125pt; mso-width-source: userset; mso-width-alt: 5344" width=167><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 3840" width=120><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 5184" width=162><COL style="WIDTH: 132pt; mso-width-source: userset; mso-width-alt: 5632" width=176><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: windowtext 1pt solid; WIDTH: 125pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=167 height=17>Severity</TD><TD class=xl68 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: #ece9d8; WIDTH: 90pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=120>Status</TD><TD class=xl68 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: #ece9d8; WIDTH: 122pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=162>Date & Time Raised</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: #ece9d8; WIDTH: 132pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=176>Date & Time Closed</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/17/2007 11:18</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">13/11/2008 9:58:10AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">4/28/2008 3:01</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">24/02/2009 8:56:26AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 5</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Acknowledge</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">5/26/2008 15:01</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">8/8/2008 20:24</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">13/10/2008 8:39:02PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">8/19/2008 17:16</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">2/12/2008 10:28:58AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 5</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">8/22/2008 20:24</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">21/10/2008 5:53:01PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/16/2008 17:58</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">15/10/2008 3:01:30PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/19/2008 17:32</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">13/10/2008 1:59:33PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/24/2008 16:40</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">31/10/2008 8:23:43AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/25/2008 12:25</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">1/12/2008 10:25:54AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Service Restored</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/26/2008 10:10</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Service Restored</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/26/2008 16:03</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/30/2008 14:38</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">21/11/2008 2:30:46PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/30/2008 17:40</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">16/10/2008 5:42:07PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 5</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">10/1/2008 8:41</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">23/10/2008 11:19:18AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">10/1/2008 10:54</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">8/10/2008 10:47:10AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">10/1/2008 13:36</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">2/10/2008 2:45:25PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">10/1/2008 17:40</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/10/2008 9:47:58AM</TD></TR></TBODY></TABLE>
Problem: To AVERAGE of elapsed days (workdays between “Date & Time Raised” and “Date & Time Closed”, based on following conditions
Conditions:
1) Severity = “Prod Severity 4” OR “Development Severity 4”
2) Status = “Closed”
3) Month Closed = to be computed based on date & time closed (like =MONTH(Date & Time Closed)
4) Ignore errors (e.g. #VALUE! etc.) while taking average of elapsed days. I am calculating elapsed days as =NETWORKDAYS(LEFT(C9,10),LEFT(D9,10)) ignoring time stamp
Can you suggest a single cell formula which can be entered in a cell. I can't insert new columns in the worksheet to compute part-by-part.
An array formula with all the conditions would be great.
Thanks in advance.
<TABLE style="WIDTH: 469pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=625 border=0><COLGROUP><COL style="WIDTH: 125pt; mso-width-source: userset; mso-width-alt: 5344" width=167><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 3840" width=120><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 5184" width=162><COL style="WIDTH: 132pt; mso-width-source: userset; mso-width-alt: 5632" width=176><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: windowtext 1pt solid; WIDTH: 125pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=167 height=17>Severity</TD><TD class=xl68 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: #ece9d8; WIDTH: 90pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=120>Status</TD><TD class=xl68 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: #ece9d8; WIDTH: 122pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=162>Date & Time Raised</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #c0504d; BORDER-LEFT: #ece9d8; WIDTH: 132pt; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #C0504D none; text-underline-style: none; text-line-through: none" width=176>Date & Time Closed</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/17/2007 11:18</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">13/11/2008 9:58:10AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">4/28/2008 3:01</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">24/02/2009 8:56:26AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 5</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Acknowledge</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">5/26/2008 15:01</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">8/8/2008 20:24</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">13/10/2008 8:39:02PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">8/19/2008 17:16</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">2/12/2008 10:28:58AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 5</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">8/22/2008 20:24</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">21/10/2008 5:53:01PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/16/2008 17:58</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">15/10/2008 3:01:30PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/19/2008 17:32</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">13/10/2008 1:59:33PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/24/2008 16:40</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">31/10/2008 8:23:43AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/25/2008 12:25</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">1/12/2008 10:25:54AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Service Restored</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/26/2008 10:10</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Service Restored</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/26/2008 16:03</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">9/30/2008 14:38</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">21/11/2008 2:30:46PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/30/2008 17:40</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">16/10/2008 5:42:07PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 5</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">10/1/2008 8:41</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">23/10/2008 11:19:18AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Development Severity 4</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">10/1/2008 10:54</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">8/10/2008 10:47:10AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none" height=17>Development Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">10/1/2008 13:36</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #e6b9b8; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #E6B9B8 none; text-underline-style: none; text-line-through: none">2/10/2008 2:45:25PM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: windowtext 1pt solid; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none" height=17>Prod Severity 3</TD><TD class=xl65 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">Closed</TD><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">10/1/2008 17:40</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #f2dddc; BORDER-LEFT: #ece9d8; COLOR: black; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-pattern: #F2DDDC none; text-underline-style: none; text-line-through: none">9/10/2008 9:47:58AM</TD></TR></TBODY></TABLE>
Problem: To AVERAGE of elapsed days (workdays between “Date & Time Raised” and “Date & Time Closed”, based on following conditions
Conditions:
1) Severity = “Prod Severity 4” OR “Development Severity 4”
2) Status = “Closed”
3) Month Closed = to be computed based on date & time closed (like =MONTH(Date & Time Closed)
4) Ignore errors (e.g. #VALUE! etc.) while taking average of elapsed days. I am calculating elapsed days as =NETWORKDAYS(LEFT(C9,10),LEFT(D9,10)) ignoring time stamp
Can you suggest a single cell formula which can be entered in a cell. I can't insert new columns in the worksheet to compute part-by-part.
An array formula with all the conditions would be great.
Thanks in advance.