Tracking and copying data

K

kckay

Board Regular
Joined
Nov 8, 2010
Messages
134
I have 5 worksheets that have variations of a Deficency Form table (attached is an example of the Sources worksheet). I need to track the "X"'s used to signify the Deficiency Form and copy them onto a summary page. I do not know how many Deficiencies there will be identified in the Deficiency Form, nor the severity. Another wrinkle, using this example, is that the Sources cells may copied to on the worksheet multiple based on the facility code (in this example "Source" - n sources mean n Sources cells). I need to be able to track all of the Deficiencies to place on the Summary. Help!

<TABLE style="WIDTH: 784pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1043><COLGROUP><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5290" span=7 width=149><TBODY><TR style="HEIGHT: 21pt; mso-height-source: userset" height=28><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 784pt; HEIGHT: 21pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl114 height=28 width=1043 colSpan=7>Sources</TD></TR><TR style="HEIGHT: 21pt; mso-height-source: userset" height=28><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 21pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl109 height=28 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl121 width=298 colSpan=2>Sources Summary</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl91 width=149>X - Not evaluated</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl110 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl110 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl111 width=149></TD></TR><TR style="HEIGHT: 19.5pt; mso-height-source: userset" height=26><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 19.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl93 height=26>Source </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl94></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl93>Type</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl95></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl93>Name</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl95></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl96></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl77 height=18 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl80 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl80 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl80 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl80 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl78 height=18 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl80 width=149>Current data</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl79 width=149>Enter changes here:</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl80 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl79 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl80 width=149>Current data</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl84 width=149>Enter changes here:</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 14.4pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl77 height=19 width=149>WSF Status:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl97 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl105 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=149>Data Collection Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl100 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl107 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl77 height=18 width=149>Activity Date:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl98 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl106 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=149>Latitude</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl101 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl108 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl77 height=18 width=149>Constructed Date:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl98 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl106 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=149>Longitude</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl102 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl108 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl77 height=18 width=149>Availability:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl97 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl105 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl107 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl77 height=18 width=149>Water Type:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl99 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl106 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext 0.5pt dotted; BORDER-RIGHT: #f2ecd7" class=xl103 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl85 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl77 height=18 width=149>Annual Operating Period:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl99 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl106 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl104 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl92 height=18 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl82 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl75 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 21pt; mso-height-source: userset" height=28><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 672pt; HEIGHT: 21pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl119 height=28 width=894 colSpan=6>Source Deficiency Form</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl86 width=149></TD></TR><TR style="HEIGHT: 27.6pt" height=37><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: silver; WIDTH: 112pt; HEIGHT: 27.6pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl88 height=37 width=149>Identified Issue?
X=yes blank=no
</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext; BACKGROUND-COLOR: silver; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 width=149>Code</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: silver; WIDTH: 224pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl113 width=298 colSpan=2>Title</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext; BACKGROUND-COLOR: silver; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 width=149>Severity</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext; BACKGROUND-COLOR: silver; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 width=149>Notes</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl87 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112 height=18 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=149>S012</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl117 width=298 colSpan=2>SRC Ground Source Potential GWUDI</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149>Rec.</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112 height=18 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=149>S030</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl117 width=298 colSpan=2>SRC WL CONSTRUCTION</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149>Sig.</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112 height=18 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=149>S031</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl117 width=298 colSpan=2>SRC WL LOCATION</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149>Sig.</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112 height=18 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=149>S034</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl117 width=298 colSpan=2>SRC INTAKE </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149>Rec.</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl112 height=18 width=149></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=149>S997</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl117 width=298 colSpan=2>SRC GE OTHER SOURCE OBSERVATIONS</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149>Rec.</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=149></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=149></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 112pt; HEIGHT: 13.5pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl89 height=18 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl81 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl81 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl81 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl81 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl81 width=149></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl83 width=149></TD></TR></TBODY></TABLE>


Summary worksheet:
<TABLE style="WIDTH: 563pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=751><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3242" width=91><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3754" width=106><COL style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4693" width=132><COL style="WIDTH: 105pt; mso-width-source: userset; mso-width-alt: 4977" width=140><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3498" width=98><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4266" width=120><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 21pt; mso-height-source: userset" height=28><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 563pt; HEIGHT: 21pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl108 height=28 width=751 colSpan=7>Inspection Summary Page</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 563pt; HEIGHT: 15pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl112 height=20 width=751 colSpan=7>Site Visit Info:</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 15pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl89 height=20 width=91>PWSID #:</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl74 width=106></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=132>PWS Name:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl91 width=140> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=98>County Name:</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 90pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl80 width=120> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=64> </TD></TR><TR style="HEIGHT: 28.8pt" height=38><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 28.8pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl93 height=38 width=91>Site Visit Date:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl94 width=106> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl81 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl95 width=140>Inspector:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 164pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl110 width=218 colSpan=2> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl96> </TD></TR><TR style="HEIGHT: 28.8pt" height=38><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 28.8pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl89 height=38 width=91>Letter Date:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl79 width=106> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl83 width=132></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl90 width=140>System Representative</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 164pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl102 width=218 colSpan=2> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl96> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl98 height=19> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl98 height=19> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 28.8pt" height=38><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 28.8pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f2ecd7" class=xl99 height=38 width=91>Source</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f2ecd7" class=xl76 width=106>X - Not evaluated</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f2ecd7" class=xl84 width=132>M&R and Data</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f2ecd7" class=xl76 width=140>X - Not evaluated</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=98></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 90pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=120></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 28.8pt" height=38><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 28.8pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl99 height=38 width=91>Treatment</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl76 width=106>X - Not evaluated</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl84 width=132>Management and Operations</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl76 width=140>X - Not evaluated</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=98></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 90pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=120></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 29.4pt" height=39><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 29.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl100 height=39 width=91>Distribution System</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl76 width=106>N - No deficiencies</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl86 width=132>Operator Compliance</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl77 width=140>X - Not evaluated</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=98></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 90pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=120></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 44.4pt" height=59><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 44.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f2ecd7" class=xl101 height=59 width=91>Finished Water Storage</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f2ecd7" class=xl77 width=106>X - Not evaluated</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=132></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=140></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=98></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 90pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=120></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 15pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 height=20 width=91></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=106></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=132></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 105pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=140></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=98></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; WIDTH: 90pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl85 width=120></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" height=19></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e5e5; WIDTH: 147pt; HEIGHT: 29.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl115 height=39 rowSpan=2 width=197 colSpan=2>Severity Category</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e5e5; WIDTH: 204pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl115 rowSpan=2 width=272 colSpan=2>Number Identified</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e5e5; WIDTH: 164pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl115 rowSpan=2 width=218 colSpan=2> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82 height=19> </TD></TR><TR style="HEIGHT: 33pt; mso-height-source: userset" height=44><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 147pt; HEIGHT: 33pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105 height=44 width=197 colSpan=2>Significant Deficiencies or Major Violations</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 204pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=272 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 164pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=218 colSpan=2> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 147pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105 height=20 width=197 colSpan=2>Other Violations</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 204pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=272 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 164pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=218 colSpan=2> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 147pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl105 height=20 width=197 colSpan=2>Observations-Recommendations</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 204pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=272 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 164pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl106 width=218 colSpan=2> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl82> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl87 height=20> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl87> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl87> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl87> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl87> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7" class=xl87> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: windowtext 1pt solid" class=xl88> </TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 563pt; HEIGHT: 15pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f2ecd7" class=xl103 height=20 width=751 colSpan=7>Deficiency Summary:</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: silver; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl97 height=19 width=91>Code</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext; BACKGROUND-COLOR: silver; WIDTH: 79pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 width=106>Faciltiy ID</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: windowtext; BACKGROUND-COLOR: silver; WIDTH: 99pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 width=132>Severity</TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 68pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 height=19 width=91> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 79pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=106> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 width=132> </TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD><TD style="BORDER-BOTTOM: #f2ecd7; BORDER-LEFT: #f2ecd7; BACKGROUND-COLOR: transparent; BORDER-TOP: #f2ecd7; BORDER-RIGHT: #f2ecd7"></TD></TR></TBODY></TABLE>


There are 2 other summary tables after "Deficiency Summary": "Other Violations Summary" and "Observation Summary" that I need to populate, too.
 
Last edited:

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Looks like I should convert the Deficiency Summary area to a table. Name the table. Then scan over each of the 5 worksheet's Deficiency Form sections and write to the corresponding table.

How do I write to the table? The size of the table may change so would have to add to the end each time.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA code clean up
Replies
9
Views
583
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E

Forum statistics

Threads
1,224,605
Messages
6,179,860
Members
452,948
Latest member
UsmanAli786

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