help_ how can i do this task faster

[c0259621]

hi guys<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a tricky task which is currently done manually and is very time consuming .<o></o>
<o> </o>
I wanted to know if there is any function that would allow me to do the task faster<o></o>
<o></o>
task is below<o></o>
<o></o>
i have a sheet (hardware sheet) with hardware down the side and model across the top, there is an X marked indicating we have this in stock, now I have another sheet which has a list of models down the side, I need to take all the hardware names where there is an X across to this sheet next the models. <o></o>
i.e.

hardware sheet

<TABLE style="WIDTH: 200pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=267 border=0><COLGROUP><COL style="WIDTH: 137pt; mso-width-source: userset; mso-width-alt: 6692" width=183><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" width=40><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 137pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" width=183 height=20></TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 33pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #eeece1" width=44 rowSpan=2>mod1</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 30pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #eeece1" width=40 rowSpan=2>mod2</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset" height=34><TD class=xl72 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 137pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #eeece1" width=183 height=34> Hardware</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-7010/7010L</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1">X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-7025</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1">X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-7030/7045N</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-7060D/7065DN/7070DW</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1">X</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-7055</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1">X</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=top align=left height=20><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape id=Picture_x0020_292 style="MARGIN-TOP: 6.75pt; Z-INDEX: 1; VISIBILITY: visible; MARGIN-LEFT: 26.25pt; WIDTH: 125.25pt; POSITION: absolute; HEIGHT: 45pt; mso-wrap-style: square" o:gfxdata="UEsDBBQABgAIAAAAIQDI4TOSFQEAAFICAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSTW7DIBCF95V6B8S2snG6qKrKdhb9WbZdpAeYwtimxYCApMntO3ZsqY2sbLJBwPDe+xgo1/vesB2GqJ2t+CovOEMrndK2rfjH5iW75ywmsAqMs1jxA0a+rq+vys3BY2SktrHiXUr+QYgoO+wh5s6jpUrjQg+JlqEVHuQ3tChui+JOSGcT2pSlwYPX5RM2sDWJPe9p+0jy5bHl7PF4cMiquO4Hg7EgFjUBTTzRgPdGS0h0O7Gz6oQsm6hyUo5nYqd9vCF0vpwwVP5D/Q2YdG/UzqAVsncI6RV6QhfSaP/pICihAvxQc+M8WeXnTReoXdNoicrJbU9dzCfHGft8fKIXQjGOlyePNnOuGH9E/QsAAP//AwBQSwMEFAAGAAgAAAAhAK0wP/HBAAAAMgEAAAsAAABfcmVscy8ucmVsc4SPzQrCMBCE74LvEPZu03oQkaa9iOBV9AHWZNsG2yRk49/bm4ugIHibZdhvZur2MY3iRpGtdwqqogRBTntjXa/gdNwt1iA4oTM4ekcKnsTQNvNZfaARU37iwQYWmeJYwZBS2EjJeqAJufCBXHY6HydM+Yy9DKgv2JNcluVKxk8GNF9MsTcK4t5UII7PkJP/s33XWU1br68TufQjQpqI97wsIzH2lBTo0Yazx2jeFr9FVeTmIJtafi1tXgAAAP//AwBQSwMEFAAGAAgAAAAhAEJI238WAgAApwQAAB8AAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1spFTbbtswDH0fsH8Q9J7a85C2MeoUa5sWA7It2NYPUGTGFqYbKMVJ/36U7aRBgG3AqieKRzo8vEg3t3ujWQcYlLMV/3CRcwZWulrZpuLPPx8n15yFKGwttLNQ8RcI/Hb+/t2NKBsUvlWSEYMNpah4G6MvsyzIFowIF86DJWzj0IhIW2yyGsWOmI3Oijy/zIxQls9fqR5EFGyL6j+otJO/oL4XthOBKLUsTz2jRi3fzixK2z2h/+FXmJTLr90KmaorTpWzwlCJeDYC4zHaZme3mleC/QZNOu82G7av+EdaV1POXqgZs3ya5wMb7COTBBdXl0VBsCR8hGT77a9XZbv402WSNYQn40SSVzIpst1KyfMsi0OWhMUtAitm5KohSKz4HbrYAk6WrnGTu+XzwstjMY5cxL6kZgVm3X0rbAOfggcZKV+iPrgQ3a4FUYfkHgqYKj3o6at55Ftr5R+V1klyssdek5x/zyMVXUl4cHJrwMZhKBG0iPQaQqt84AxLMGug/uLnmhRKegyRmuxR2TgkF1B+pwT6roeIEGWbtGxI0+gnwUeA7FPFgeaIrXdfXE2kYhtd/x7eOBQU48DgMcQncIYlg5IgoX0E0S1DkkxHD0f6nrtUyj4Vbdmu4rMpjdsZYlQEZFqZil/naQ11SP1a2Lq/HIXSg00BtO3jpFSHgGm+srMn2iPjl5L+gdP9/DcAAAD//wMAUEsDBBQABgAIAAAAIQCUrQ3f1AAAAKwBAAAqAAAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzrJC/agMxDIf3Qt/BaK91lyGUEl+WEsgakgcQts7n9PwH2wnN29dtlh4EunQRSEKfPn6b7aefxZVzcTEo6GUHgoOOxgWr4HTcvbyCKJWCoTkGVnDjAtvh+Wlz4JlqOyqTS0U0SigKplrTG2LRE3sqMiYObTPG7Km2NltMpD/IMq66bo35NwOGBVPsjYK8NysQx1tqn/9mx3F0mt+jvngO9cELrM2LG5Cy5apAyvvkXnvZXAEfa/T/qeF8i2Ch4dk4wp95L8+J7bcHLjIevgAAAP//AwBQSwMEFAAGAAgAAAAhAItmLWi8BgAA6RsAABoAAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbOxZT28cNRS/I/EdrLm32f/NRt1U2c1uC23aKNkW9eid8c648YxHtjfp3lB7REJCFMQFiRsHBFRqJS7l0wSKoEj9CjzbM7Pj7CxJSgQCmkN25s3P7/n99bN99drDmKFDIiTlSc+rX655iCQ+D2gS9ry749GldQ9JhZMAM56Qnjcn0ru2+e47V/GGz2g64VgE44jEBAGjRG7gnhcplW6srUkfyFhe5ilJ4NuUixgreBXhWiDwEQiI2VqjVuusxZgm3iZwVJrRkMG/RElN8JnY12wISnAM0u9Mp9QnBhsc1DVCzuWACXSIWc8DngE/GpOHykMMSwUfel7N/Hlrm1fX8EY2iKkVY0vjRuYvG5cNCA4aRqYIJ4XQ+qjVvbJd8DcAppZxw+FwMKwX/AwA+z5oaudS5tkardf7Oc8SyD4u8x7U2rWWiy/xby7Nudvv99vdbC6WqQHZx9YSfr3WaW01HLwBWXx7Cd/qbw0GHQdvQBbfWcKPrnQ7LRdvQBGjycESWjt0NMq4F5ApZzcq4esAX69l8AUKoqGILi1iyhO1KtZi/ICLEQA0kGFFE6TmKZliH2JygOOJoFgLwBsEl75Yki+XSFoWkr6gqep576c48UqQ1y++ff3iGXr94unxo+fHj344fvz4+NH3lpcz8AZOwvLAV19/8vuXH6Lfnn316sln1XhZxv/83Uc//fhpNRAyaKHhy8+f/vL86csvPv71mycV8C2BJ2X4mMZEotvkCO3xGHQzhnFnTibifCPGEabOCBwB7wrWQxU5wNtzzKpwfeIa756A4lEFvD574Mx1PxIzRSsk34xiB7jDOetzUWmAm1pWycLjWRJWCxezMm4P48Mq2QOcOK4dzlKomnlQOrYfRMSZ5i7DicIhSYhC+hs/IKRCu/uUOnbdob7gkk8Vuk9RH9NKk4zpxAmkxaAbNAa/zKt0Blc7ttm5h/qcVWm9TQ5dJCQEZhWTHxPmmPE6nikcV7Ec45iVDX4Lq6hqkvtz4ZdxQ6nA0yFhHA0DImXVmDsC9C05/SaGelXp9h02j12kUPSgiuctzHkZuc0PBhGO0yrsPk2iMvY9eQAhitEuV1XwHe5miH4HP+BkpbvvUeK4+/RCcJeGzpQWAaK/zIT2JRRqp/7GNPmzYswoVGMbA2+Lcc/bgqWpKiVunCjBq3D/wsK7jWfJLoFYX1543tbdt3XX+8/X3VW5fNZquyiwUHt182D7YtMlxyub5CllbF/NGbklTZ8sYbEIRkDU48xmkBSbpjSCx6y4O7hQYDMGCa4+oCraj3AKPXbd00xCmbEOJUq5hL2dIVfy1njo05XdGbb1nsHWA4nVDg8suanJ+dagYGOWnNDsP3NBTc3grMKaVzKmoPabCKvrSZ1ZWt1MzZQ6R1qhMvhwWTUgFtaELgRB7wJW7sB2XIuGvQlmJNB2twtw7hbjhYt0kYxwQDIfab2XfVQ3TspjxRwGQOxU+Ejv806xWklaV7P9C9LO4qSyuNYKcbn3/oqX8gheeEnn7Yl0ZEk5OVmCjnpet91oe8jHac+bwrYWHuMUvC5144dZCAdCvhI27E9NZpPlC292c8XcJKjDSYW1+5LCTh1IhVTbWEY2NMynLARYoiXZ+TfaYNaLUsBG+hvMorkOwfCPzQLs6LqWTKfEV2VnlyjadvY1K6V8pojYj4IjNGEzsYfB/TpUQZ+ASjidMBVBv8BRmra2+eQW5yzpygdYBmfpmKURzsqtTtE8ky3c5HExB/NWmh7oVjl3o9z5VTEpf0GqlMP4f6aKXk/guKAZaA/4cC4rMNL52vO4UBGHKpRG1B8JaBxM7YBogeNY+AxBBYfI5leQQ/1rc87yMGkNuz61R0MkKKxHKhKE7EJZMtF3CrN6tnZZlixjZCKqNF2Z2mlPyCFhY10DO3pt91AEoW6qSVYGDO5k/LnvWQZNQt3klPPNqSHF2mtz4O/ufGwyg1JuHTYNTW7/YooVq6odb4bna29ZEf1h0Wa18qwAYaWloJul/RtO4ZxLra1YSxo32vnkwIvLGgOxaIhSOPRB+h+sf1T4zF446AV1zPegtiK4a9DMIGwgqi/ZxgPpAmmJE2icLNEGk2ZlTZu1Ttpq+WJ9wZ1uIfeEsfXMzuLvcxq7aM5ccU4uXqSxMws7tra0laYGz55MUSBN842McUzVxdMOTtEkrPc8uPwBRz+EJ7g+8oDW0LSGpsET3AlBs2Qvcnpe9pBT4LulFJhmTmnmmFZOaeWUdk6B5iy7MskpHahU+pYDbtn0j4fyCw3o4LILkLyoOrdzm38AAAD//wMAUEsDBAoAAAAAAAAAIQDKphSpGVUAABlVAAAbAAAAY2xpcGJvYXJkL21lZGlhL2ltYWdlMS5qcGVn/9j/4AAQSkZJRgABAQEA3ADcAAD/2wBDAAIBAQEBAQIBAQECAgICAgQDAgICAgUEBAMEBgUGBgYFBgYGBwkIBgcJBwYGCAsICQoKCgoKBggLDAsKDAkKCgr/2wBDAQICAgICAgUDAwUKBwYHCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgr/wAARCACKAX8DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9/K+d/wDgpv8Aty6j/wAE+P2cYfjxpnw8h8TyS+I7bS/7Nn1A2ygSpK2/eEfp5fTHevoivz8/4OUf+UeFp/2UPTf/AERdV7XDmEw+Oz3D4evHmhKaTWquvlqeNxDiq+CyTEV6LtOMW0+z+eh87f8AEU94w/6M60z/AMLCT/5Gr7G/4JQf8FTtZ/4KUjxodW+Dtt4T/wCETNns+z6w139p8/zc5zGm3Hl++c1/OjX69/8ABrD9z4xfXR//AG6r9a4y4Q4dyvhyticLQ5Zx5bPmk95JPeTWzPy3hHivP8y4go4fE1uaEua65YraLa2Se6P15ooor8LP2sKKKKACiiigAooooAKKKKACiiigAooooAKKKKAPDv8Agoj+2FdfsKfsvat+0VZ+BI/Ekmm39pbDSpb82wk8+UR7vMCPjGc4xzX50/8AEVB4j/6Mzsf/AAtX/wDkWvq3/g4Q/wCUZHir/sO6T/6VpX88tfsfAPC2RZ1ksq+Mo881Nq/NJaJRfRpdWfknHXE2d5PnEaOEq8sXBO1ovW77pvofv5/wTA/4LVat/wAFEvj9qPwTv/2frfwslh4Zn1YahD4ha7LmOaGPy9hhTGfOznP8PTmvvivwg/4Nl/8Ak/PxD/2TW9/9LLOv3fr43jrK8Dk+fPD4SHLDli7Xb1e+7bPruCsyxubZGsRip80+aSvZLReiSCiiivjj60/LT9qT/g44179nL9o3xt8BoP2U7TVU8IeJbvSk1J/FrQm5EMhTzCgtm25xnGTj1rhE/wCDp7xG7hf+GNLLk4/5HV//AJFr4G/4Kef8pEPjT/2UjVf/AEoevDIf9av+8K/o7LuBeFa+X0ak8PeUoxb96e7Sb+0fz7mHG3E9DMKtOGItGMpJe7DZNpfZP63/AAT4hbxd4M0jxY9qIDqmmW92YA+7y/MjV9ucDON2M1p1zXwX/wCSO+E/+xZsP/SdK6Wv51qxUaskujZ+/wBNuVNN9gooorMsKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAr8/P+DlH/AJR4Wn/ZQ9N/9EXVfoHX5+f8HKP/ACjwtP8Asoem/wDoi6r6PhH/AJKbCf44nz3Ff/JN4r/Az8Dq/V7/AINrPib8P/g54E+OfxK+KXi+x0LQdKh0ibUNU1GcRxQr/pI5J6kkgADJJIABJr8oauQ+Idet9Cn8MW+s3SabdXMdxc2CTsIZZUDKjsmcMyh3AJ5G4461/SGf5RHPcrngpS5VNxu99FJN289LH895FmryXM4YxR5nFSsttXFpfmfrx+1z/wAHNtnper3fhP8AYz+EcOoQQu0a+LPF+9UmI43RWkZDbT1DSOpx1QdvkHxP/wAF7P8AgqD4kv2vIvj9baZGWylrpnhewSNPYFoWY/8AAmNfHNKI5GUuqEqOpA4FcGA4N4ay+koQw0ZPvNKTf33/AAsjuxvF/EePqucsRKPlB8qX3frc+5Phr/wcO/8ABSbwNfRy+J/HXh7xZaqRvtNc8M28eR6B7URNn3JNfev7Fn/Bxj+zf8dtVtPAf7SPhh/htrl06xw6q119p0iZzx80pCvb5P8AfUoO71+EtFc+Z8C8NZlSa9iqcukoe7b5LR/NG+W8bcRZdUTdZ1I9VP3r/N6r5M/rvsb6y1Syh1LTbyK4t7iJZIJ4JA6SIwyrKw4IIIII61LX4O/8EV/+CvniX9l/xtpn7M/7QXieW8+Gmr3It9Lv76ck+Grh2+Vgx6WrMcOnRC28YAYH92r3VdM03S5tc1DUIILK3t2nnu5ZQsccSruLljwFABOemK/BOI+HMbw5j/q9X3ovWMltJfo11XT0aZ+5cP8AEGD4hwPt6WklpKL3i/1T6Pr6pog8T+KPDfgnw9eeLfGGvWel6Xp9u099qF/cLFDbxqMl3diAoHqa/OD9rb/g5S/Z4+FmpXXhH9mH4fXfxBv7d2jbXLy4Nlpe4cbozhpZxn/ZQHsx618Hf8FfP+CrHjf9uj4pXvw4+HmuXNh8K9CvDHpGmwyFBrEiHH224H8WTzGh4RcHG4k18VV+mcMeGuF+rxxObXcnryJ2S/xNat+SaS8z854k8RMR7eWHyuyitOdq7f8AhT0S83e/kfd/xG/4OLf+Cj/jK6kbwn4k8LeE4GJ2Q6P4ZimZR6brvzc/UAV9Gf8ABDv/AIKXftqftcftpXnww/aA+M8uvaEngm+v0sG0m0gUXEc1sqPmGJW4EjjGcc1+Qle7/wDBPr9tnWP2CPix4g+Nnhbw1Fqmt3Xgm80jQ47lv3EF1PNbss0o6siLGx2jG44GQCSPrc44TyqWTVqOCwsFUcbRfKr3/wAT1+dz5bKOKs0jnFGtjMTN01K8lzO1v8K0+Vj+g/8AbN/4KE/sv/sI+Fl1747eORFqF1Cz6X4a0xRPqN/jjMcWRhc8b3KoD/FX5V/tHf8ABzL+03401C4079mv4a6H4K0zcVt7/VoxqV+y9mIYCFD/ALOx8epr87/ix8WviP8AHL4gal8Uviz4vvdd17V7gzX+o38pd3Y9AOyqBwFGAoAAAArna87IvDnJctpKWLj7ap1v8K8lHr6yv8tjvzvxBzjMKrjhJexp9LfE/WXT0VvVn0/rn/BZv/gptr9619c/taa9AzHJSxtbWBB9FSIAV1Xwx/4L1/8ABTH4cX0c198bLXxLaq2ZLHxJoNtMsg9C8aJKPwcV8bpHJISI0LYGTgZpK+qnw9kFSnySwtO3+CP+R8xDP89pz544qpf/ABy/zP28/Y0/4OT/AIKfFDUrTwT+1r4DbwJqM7LGviTTJWudKZjxmVT+9tx7/vFHdgK/Szw/4h0HxZodp4m8L61a6jp19As9lfWM6ywzxsMq6OpIZSOhBr+Revtb/gkl/wAFbPH37Cfj+z+G3xG1W61b4VatehdU0yR2d9Gdzg3lsO2Dy8Y4cA4w2DX5zxR4a4aVGWJylNSWrp3un/hb1T8ndPpY/QeGvETEKtHD5o7xeinazX+JLRrzVmutz9RP+DhD/lGR4q/7Duk/+laV/PLX9Bv/AAXs8R6D4w/4JT634s8Latb3+manqWi3Wn31rKHiuIZLiNkkRhwVKkEH3r+fKvX8Lk48OzT39pL/ANJieV4ltPPoNf8APuP5yPWv2Nv20/jT+wr8ULv4u/Ap9KXV73R5NMmOsWBuIvIeSORsLuXDbol5z619O/8AESB/wUe/5+fAv/hLH/49XwRRX2OMyHJcxr+2xOHjOW12k3ofJYPPc4wFH2OGryhHeydkfe//ABEgf8FHv+fnwL/4Sx/+PV9w/wDBEL/gqD+1B+358TvHXhP4+y+H2tPD2g2t3p/9jaQbZvMkmZG3Eu24YHSvwnr9Tv8Ag1q/5Ln8Vv8AsU7H/wBKmr4/jHhzIsFw1iK1DDQjOKVmkk17yR9ZwlxDneM4iw9GviJSg27pvR+6z4m/4Kef8pEPjT/2UjVf/Sh68Mi/1q/7wr3P/gp5/wApEPjT/wBlI1X/ANKHrwqvt8p/5FWH/wAEP/SUfG5r/wAjWv8A45f+lM/cb9q7/gvv8GP2UPh3oXwf+AGgwePfGtl4cs4NRuTc7NK0uYW6Ao8ifNPIpzmNMAYwXByK/Pb4m/8ABdX/AIKZfEnVJL6H4/nw7bsxMVh4a0e2to4h6BijSN9WcmvkKtXSvA3jbXbE6nong7Vby2Gc3Frp8kiDHX5lUivCy3gzh3Kqd5Uozk95TSbb8k9F8l957WY8X8QZpUtGrKEVtGDasvNrV/P8D6k+HX/Bc7/gpr8O9TS+P7RMmuwqwMll4i0e1uY5R6E+Wrj/AICyn3r9DP2C/wDg4u+Efxv1qx+GP7Wnhe28Ca7dyLDa+JLOcvpFxIeAJd532pJ4BJdPVlr8O5I3idopUKspIZWGCD6Gkqs14K4dzWi4uhGEukoJRa+7R/NMnLOMeIMsqqSrOcesZtyT+/VfJo/rxt7iC7gS6tZkkilQPHJGwKupGQQR1BHen1+Qn/BvT/wU517UdZg/YL+OHiJrqI2rv8OtTvJsvGYxufTSx5Zdm54v7oRk6FAP1B/aV/aJ+Gn7KfwT1748fFrVhaaNoNmZZFUjzLmU8R28QP3pJHIRR6nnABNfz5nPD2PybN3gJrmk2uVr7Sbsml57W6PQ/ecoz7A5vlSx0HyxSfNf7LW6fpvftqX/AI0/HL4S/s7fD+8+KXxr8eaf4d0KxH7+/wBQm2gseiIv3pHOOEUFj2Fflh+1f/wc6SQ6hc+Gf2N/g1FLBGzInijxmW/eY43R2kTDAPUF5M46oD0/Pr9vf9v742ft+/F64+IXxM1WS20e2mdfDXheCYm10q3JwAo6PIQAXkIyx9AAo8Kr9c4c8NcvwlGNbM17So9eW/ux8tPiffp5dT8q4g8RMfiqsqWWv2dNfat70vPX4V+Pn0PrLxz/AMFwv+CnPjq+e8m/aXu9KRmyltoekWdqiD0G2LcfxJPvVLwx/wAFqf8Agpz4Vvlv7X9q3WLsqc+Xqmn2dzGfYrJCRXnfwN/4J+/tpftI6YmvfBf9mzxVrWmSf6rV101oLOT/AHZ5tsb/AEVjWz8WP+CXv/BQH4J6JJ4l+IP7Kni2HToVLXF9p9h9tihUdWkNsX8tR6tge9fWPCcHU6n1ZwoKW3Lanf7tz5dYri6pD6wp13HfmvO337H2l+zR/wAHOfxl8OX9vo/7Vfwc0vxJpxYLPrPhb/Qr2Md28lyYpT7Ax/Wv1T/ZP/bV/Zx/bV8Df8J3+z98QrfVY4lX+0dMlHlXunueiTwn5kPXB5U4+VjX8sLKysVZSCDggjpXafs+ftD/ABe/Zc+KWnfGL4I+MrnRdc05/kmgb5J4yQWhlTpJE2BuRuD9QDXzufeG+UZhSc8CvY1Olvgfk109Vt2Z72R+IWa4GqoY1+1p9b/EvNPr6Pfuj+r+ivnX/gml/wAFCfAX/BQ34CR/EPRoIdM8TaSyWni/w6k242VyVyJEzyYZACyMfRlJJU1yv/BXT/gpHpn/AAT3+AiXfhcW154+8UmS18JafOQywbQPMvZV7xx5GB/E7KOm7H4hTyTMqmbf2aqb9tflt+vpbW+1tT9nnnGXQyv+0XP91bmv5f530tvfQ779s/8A4KO/sqfsI6Gl58cvHn/E2uYTJp3hbSEW41K7X+8sW4BFzxvkZV96/Mn49f8ABz58dNfvZ7D9nL4E6D4dsQSIL/xLPJf3TjsxSMxxof8AZ+f6mvzS+I3xH8dfFzxvqXxI+Jniq91vXdXumuNR1PUJjJLPI3Uknt2AHAAAAAFYlfumS+HGR5fSUsXH21Tre/KvSPb1v8j8UzjxCzrHVWsK/ZU+lrcz9X/lb5n2J4g/4L1f8FRNfumnX9oSCwQnKwaf4W06NV9gTAWP4k1+5P8AwTt+KXjr42fsQ/DP4sfE3XW1PX9e8LQXeq37QpGZ5mLZbagCjp0AAr+XKv6bP+CTH/KNz4N/9iVbfzavn/EzKssy/KaEsLQhTbna8YpO3K+yPe8Oc0zLH5nWjia0ppQvaUm1fmXdn0RRRRX4sfsAV+fn/Byj/wAo8LT/ALKHpv8A6Iuq/QOvz8/4OUf+UeFp/wBlD03/ANEXVfR8I/8AJTYT/HE+e4r/AOSbxX+Bn4HVt/Df4deNfi7480n4ZfDnw9carruuX0dnpenWq5eeVzgAdgO5J4ABJIArEr9S/wDg2K/Zx0Lxf8YfHP7S/iDTo7iXwjp8Gl6CZEz5Fzd7zLKvowijKZ9Jm9a/pHP82jkeUVca1fkWi7tuyX3tX8j+e8iyuWdZtSwadlJ6vskrv8Fp5n1R/wAE/f8AggX+zR+zr4X0/wAZftK+HbL4g+O5YUluotRXzNL02QjJihgPyzFTwZJQ2SMqq19z6T8N/h3oGlLoWheAtFsrFE2pZ2mlwxxKuMYCKoAGPatqiv5ezLOczzbEOtiqrk356LyS2S9D+lMvynLsqoKjhaail5av1e7fqfMP7XH/AASF/Yg/a60C7i8Q/CWw8M+IJUJtfFXhO1SzuopMcM6oBHOM9RIpz2IPNfgj+3Z+w78XP2B/jldfBv4owpcQyR/adA122Qi31WzLELKmfusCMMh5Vh3BBP8AUZXwh/wcMfs5aF8Yf2CNQ+KY06Ntc+HWoQalp91s+cW0sqQXMWeu0qyvj1hWvtOBeLcfgczp4KvNyo1Go2bvyt6Jq+yvo1t13PkONeFsDjstqYyhBRq005XStzJatPu7bPe+mx/P1X6iXH/BUnxJ4o/4INal8Pr3xJI3jez1m28AXVyZD50mmSxNKkzHqd1rFJbk9SVJ7mvy7q3DrmrwaHceG4b+RbC6uobm4tQ3ySSxLIsbkeqrNKB/vmv27Nsnwub+xdZa05xmvk9V6P8AyPxnKs3xOVe29k9KkJQfz2fqv8ypXpH7Jv7LvxN/bH+PGh/AH4UWaNqesTEzXc+fJsbZeZbmUjoiLzxyThRyQK83r9bv+DWj4Y6Nea78W/jHeWiNf2FtpekWExXmOKYzzTAHtkwwflWHE2bTyTI62Mgryilb1bUV9zdzbhvK4ZznVHCTdoybv6JNv77WPsz9lv8A4I8/sF/sZeAxrWu/DbTPFus6fZNc6x4u8ZWqXTfIu53jhcGKBBgkBV3Y6sxGa/CH9un9o8ftV/tReK/i/p+l22n6Pc6g1t4b0yztkhitNOhOy3QIgABKAO3q7sa/oJ/4K6/Eu++E3/BN74teLNNuGinl8MnTY5EOCv22aO0P6Tmv5mq+H8NVi8yeIzTF1HObfIm3e2ilK3RXvHbax9p4iyw2Xxw+W4WChBLnaStfor99nv3JLO0u9Qu4rCwtpJp55FjhhiQs0jk4CgDkkk4Ar9o/+CY//Bvt8M/C/g/TPjT+3NoB13xFfQrc2ngWWYrZaYh5UXOwgzzYwSmfLXO0hiOPjL/ggL+zloPx9/4KBaTrXizT47rTfAmlzeIWt5V3K91GyR22R/syyLIPeMV/Q1XN4j8V43A145bg5uDavOS0eu0U+ndta6rzOjw+4YweMovMcXFTV7Ri9VpvJrr2V+z8jm/Bvwc+Enw70ePw/wCAvhh4f0WxiUKlppejwwRgDp8qKBXmH7Sn/BNz9i39q7QrnSviz8B9EN5PGRFr2kWi2WoQN2dZ4gGYj0fcp7g17nRX45Rx2Nw9f21KpKM+6bT+8/W62DwmIo+yq04yj2aTX3H82n/BUb/gl58Rf+CdHxKt0+3za74E1+V/+EZ8StEFbcvJtbgLwkyjByMK4yy4wyr8rV/Tv/wU+/Zx0H9qL9hz4gfDjVtPjmvLbQp9V0GVly1vf2sbSxOp7Z2lDj+GRh3r+Yiv6M4F4jrcQ5U3iP4tN8sn37P1et/NH8/cbcP0chzNew/h1FeK7Nbr0WlvJn3B8P8A9svUvih/wRg+I/7I/jXVmuNQ8Ca5pF/4baV8u2lTXyh4+eSIpmAHosyrwAK+H6t6bruq6RaX1jp940cWpWotr1FPEsQlSUKfbfGjfVRVSvpsBl9HL51nSVlUm5282op/e038z53HZhVx8KKqO7pwUL+Sba+5NL5H33/wbo/Df4d/FD9t3XtA+JfgLRfEVhH8PLyaOy13S4buFZRd2gDhJVZQwDMM4zgn1r9s/wDhjv8AZH/6NZ+HH/hEWH/xmvxm/wCDZf8A5Pz8Q/8AZNb3/wBLLOv3fr8K8SMTiaXE0owm0uSOza7n7X4e4fD1eHIynBN80t0mec/8Md/sj/8ARrPw4/8ACIsP/jNb/gH4JfBj4VXdxf8Awu+EXhjw3PdxiO6m0DQLazeZAchXMKKWAPODXT0V+fzxWKqR5ZTbXm2fdQw2Gpy5owSfkkfzAf8ABTz/AJSIfGn/ALKRqv8A6UPXhVe6/wDBTz/lIh8af+ykar/6UPXhagswUdSa/rXKf+RVh/8ABD/0lH8tZr/yNK/+OX/pTP1i/wCCE3/BIb4b/FrwPB+2Z+1F4Uj1nT7q7dfBHhi+XNtMsTFWvZ0/5ajeCqI3y/IzMGBXH7CaT4c8PaBpsWjaFoNlZWcMYSG1tLVI441HAUKoAA9hXEfsjeBdL+GX7LHw5+H+jW6xW2keCNLto1QYyVtY8sfUk5JPckmvRK/mPiXO8Znea1K1WT5U2oroop6WX5vqz+j+HsmwmTZZTpUopSaTk+rdtbv127I+QP8Agpr/AMElfgZ+298MNV1zwn4M03QfiZZ2jzaD4isIFgN5Mq5FvdbQBLG5AXe2WQkEHGQf509Z0jU/D+r3Wg61ZSW15Y3L293bTLteKVGKsjDsQQQR7V/XXX8yv/BWrwZpvgH/AIKQ/F/w7pFusVufFsl2kaDAU3McdwwHtmU1+k+FudYuvOtl9WTlGMeaN9ba2aXlqtOmvc/PPEzKMLRhSx9KKjKT5ZW66XTfno9evyPEvhf8RfE/wh+I+hfFPwVfG21bw9q1vqGnTg/dmikDrn2yMEehr9Bv+Dgz9vpP2hvGHgf4D/DzVWHhnTfDdl4i1aKN+Jr++gWWJH9fKt3Qj3nb0Ffm5V3xB4h1jxRqR1fXb57i48iGHzJDk+XFEsUa/RURVHsBX6bisnw2LzWhjpr3qSkl6ytb7tbebPznC5tiMJldfBQfu1XG/pG9/v0v5IpV+rf/AAQo/wCCQXgz4ueHLb9s39qTwsmpaPJcn/hBvC96mYLzy2Ia9uEP+sj3jbHGflbazMCNufykr7J+Hf8AwXg/4KFfCrwFo3wz8C+LvC9jovh/S4NP0qzTwjbEQ28KBEXJGThVHJ5PWuDinCZ7j8t+r5ZJQlJ+9JtpqPZWT1fft6nbwzi8lwOYfWMyi5RivdSSa5u7u1ou3f0P6JrOys9OtI7DT7SKCCFAkMMMYVEUcAADgAegqUgEYIyD1Br+e3/iIf8A+Cmv/RRPDX/hIWv+FH/EQ/8A8FNf+iieGv8AwkLX/CvyD/iF3ErfxU//AAJ//In6v/xEvh3+Wp/4Cv8A5I+7/wDgs7/wRv8Ah/8AHP4eaz+07+zX4Nt9I+IGi2sl7rGk6ZCI4fENugLSHy14FyFBZWUAyY2tklSPwvZWVirAgg4IPavuBv8Ag4d/4KZupR/iF4ZIIwQfCFrz+lfFnijxBeeLPEuo+KtRgt4rjU76a7nitIBFEjyOXYIg4RQScKOAMCv1Tg/LuIMpwcsLmU4zircjTbaXVO6Wi6dtVtY/MeLMwyHNcXHE5fCUZO/Omkk30as3q9b/ACe9z6U/4JA/tiap+xz+2x4X8RXWqvD4Z8T3kWheLIC37s2s8gRZ2HrDIVkz1wrD+Ig63/Bbz9ovUv2hf+Ch/jQDUWm0fwfOnh3Q4t2VjS3GJiP964MzfQgdq+SI5JIpFlicqykFWU4II71e8UeJdZ8Z+JtR8X+I71rnUNVvpbu+uH6yTSOXdj9WJNeu8lwv9urM0vf5HB/emn62uvTQ8pZxif7EeWt+5zqf4NNel7P1KFfph/wRs/4ImaB+1T4Ttv2ov2qo7xPBc87r4a8M207QSa0EYq080i/MkG4MqhSrOVJyFxu/NSws5dRvodPgxvnlWNM+rEAfzr+sr4NfD7QPhP8ACXwz8MfC1osGnaBoVrYWcaLgBIolQHHqcZPuTXyXiNxDjMly+nRwsuWdVv3luoxte3Zu619bH1Xh9kOEzfH1K2JjzQpJe69m3e1+6Vnp10ML4Zfsl/sw/BrSItD+F3wA8I6LbwoFX7FoMAkIH96QqXc+7Emu+s7O00+2SysLWOCGJdscMKBVQegA4AqSiv5+q1q1eXNUk5Pu23+Z+706VKjHlpxSXZKwUUUVkaBXwl/wcX+Hb3W/+CbWo39ohZdK8X6XdT4HRC7xZ/OVa+7a8j/by+ADftRfse/EL4FW0Svd694cmXTAxwBeRYmtznt+9jjr1shxcMBnWHxE/hjOLfpdX/A8vO8LPG5PiKEN5Qkl62dvxP5Z6/Yz/g1o8faK3hD4s/C57hBqKalp2qxxFvmeFo5IWYDuAyqP+BD1Ffjxf2N7pd9NpmpWskFxbytFPBKhVo3U4ZSD0IIIIr27/gnZ+2r4o/YL/af0b45aLbSXmmBWsfE2ko2Pt2nykeYg/wBtSqyJ23xrnjNf0nxXlVXOuH62Fo/E0nHzcWml87W+Z/PHC+Z08nz2jiavwptS8k01f5Xv8j+oGiuM+Af7QXwh/ac+GWnfF74JeNbTXND1KFXintn+eFiATFKh+aKRejIwBBrs6/lmrSqUajp1E1JaNPRp+aP6Yp1Kdampwaaeqa2aCvlL/gtt8QdH+H3/AATM+Js2rTor6xp9vpVlGxGZZp7mJQFHchdzfRSe1fUuratpWg6ZPrWuanb2VnaxNLdXd3MscUKKMlmZiAoA5JJxX4L/APBdX/gqD4d/bM+IWn/Aj4Gaybr4f+D7t5ptUjBCa1qOChlXPWGNcqh/iLu3IK19XwVkuJzfPaThH3KclKT6JJ3S9W1ZL59D5jjDOMNlWSVVN+/Ui4xXVtq1/RXu/u6n590UV6x4l/Z01Twb+xp4b/aU12zeIeMvG95pmi+YMbrWyt0Mki+oaWYrn1gPvX9MVsRSoOCm9ZOy83Zv8k38j+c6NCpXUnFaRV35K6X5tL5nk9ftF/wa0Ko+C3xZcKMnxRpwJ9vs0n+Nfi7X7R/8GtH/ACRT4sf9jTp//pNJXxviN/ySdb1h/wClI+v8Pv8AkqKXpP8A9JZ9P/8ABcfw7feJ/wDglv8AFOw0+Ms8Fpp12wUZ+SDU7WZz+Coa/m9r+sj48/CnSPjr8E/FnwZ17AtPFHh280yVyP8AV+dCyBx7qSGHuBX8qfxM+Hnif4S/ETXPhf41097XV/D2rXGn6jbuMFJoZCjfUZXIPcYNfPeE+Mpyy7EYS/vRnzfKSS/9t/E93xRwdSOPoYq3uyjy/OLb/wDbvwP0A/4NmPiBo/hn9tzxJ4K1G4SO48S+BJ4rAO2DJJBPDMyD1OxXbHoh9K/div5P/wBnf47eOf2Zvjb4a+O/w4uxFq/hnVY7y2V87JlBw8LgdUkQsjD0Y4r+lv8AYj/bi+CP7dnwdsvil8JPEEJuhCq694fmlH2vSbnHzRSp125ztcfK4wQeoHheKGS4mnmMcyhG9OaSb7SWmvZNWt53Pb8Nc4w1TLpZfJ2qRbaXeL109He/lY9loopHdI1LuwVQMkk4AFflJ+nnCftR+P8AR/hX+zZ49+I2v3CR2mjeENRupmkIwdtu5A59TgY75r+UcnJzX63f8F/f+Cqvgvxx4bn/AGHf2dvFUGqQNeK/xA12wl3wExNuTT43HD/OA0jDIBRUzneB+SNf0J4aZLicsymeIrx5ZVmmk9+VLRv1u36WPwbxFzjDZjmkKFB8ypJptbcztdfKy+dwor6b/ZF/Yg8RfG79jn49/tONo0ktr4G8NW8WikpxLd/a7ee5dT3MVpHJn/rsPavmSvvcPjaGJrVaVN3dNqMvVpS/Jnw2IwdfDUaVSasqibXom1+h+h3/AAbQ3sVt+35rFs8ihrj4c36ID1Yi5tGwPwUmv3mr+Y3/AIJdftWaZ+xr+234M+NPiaZ00FLmTT/EZRSxWyuYzE8mByfLLLJgcny8d6/pn0DX9E8VaHZ+JvDWrW9/p2oWyXFjfWkwkinidQyujLwykEEEetfhXijg61LPoYhr3JwVn5q6a/J/M/bfDTF0auRyoJ+9CTuvJ2af5r5Fuiivnz/gpT+3X4G/YM/Zq1f4kavq9sfE19bSWngzRnYGW9v2UhG2dfKj++7HgAY6soP55g8JiMfioYehG85OyXr/AFqfe4rFUMFhp160rRirtn89n/BQDxPbeM/24/i74ps5VkhvfiLq8kTocgr9rkAx+AryOH/Wr/vCn317eanezajqFy81xcStJPNI2WkdjlmJ7kkk0yH/AFq/7wr+vMNRWGw0KS+ykvuVj+UsRWeIxM6r+02/vdz+s34L/wDJHfCf/Ys2H/pOldLXNfBf/kjvhP8A7Fmw/wDSdK6Wv4/r/wAeXq/zP6xo/wAKPogr+a//AILVf8pQvi5/2GbT/wBN9rX9KFfzX/8ABar/AJShfFz/ALDNp/6b7Wv0vwp/5Htb/r0//SoH514n/wDIkpf9fF/6TI+W6KK9h/bC/Z01L4B6r4E1kWLR6V48+GWheJNLmC/I7T2cYuFB9ROkhI7B17EV+6zxFKnXhSk9ZXt52tf8NfkficMPUqUJ1YrSNr/O9vxVvmeQwQSXM6W0KgvI4VASBkk4HJr6aT/gjP8A8FNZEEkf7JeusrDKst5aEEev+ur5iBIOQcEdCK/o1/4Ix/t6eGv2zv2TtH0LVtdibx14I0+DS/FVhI+JpVjTZDegfxLKq8kcBw444z8rxlnmbcP4KGKwlOM43tPmTdr7PRrTdPzaPp+EMlyrPsZPDYupKMrXjZpXtutU9dmvK5+NH/DmT/gpx/0aRr//AIF2n/x6j/hzJ/wU4/6NI1//AMC7T/49X9K1Ffmv/EVs8/580/ul/wDJH6J/xDDJf+ftT74//In81P8Aw5k/4Kcf9Gka/wD+Bdp/8eo/4cyf8FOP+jSNf/8AAu0/+PV+/H7cv7Xvw9/Yk/Zx1/44+O9ShWa0tHi0DTWf95qWoMpEMCL1OWwWI+6gZjwK/D+X/g4I/wCCnUkrOnxd0dAzEhF8KWeFHpzHX1WQcS8acRUJVsNRoqMXa8udXflZvbr6nzOecO8H8P140cTWquUle0eR2XndLfp6HD/8OZP+CnH/AEaRr/8A4F2n/wAer5s1/QtW8L67e+Gdesmtr7TruS1vbdyCYpY2KOhxxkMCOPSv1F/4Jk/8FWf+CmX7Zn7aXgz4J678UNPudBmvGvvFAg8L2kZGnQKZJQXWPKb8LGCMHMgxzivzk/aT/wCTi/H3/Y66r/6Vy19Xk+PzqpmFXCZiqalGMZL2fM9G2teb0Pl83wOTU8vp4rL3UcZSlF+05eiT0t6mB4A/5HvRP+wvbf8Ao1a/rZsP+PGD/riv8hX8k3gD/ke9E/7C9t/6NWv62bD/AI8YP+uK/wAhX574ufHg/Sp/7YfeeFfwYv1h/wC3EtFFFfjZ+uBRRRQAUUUUAfhT/wAF/P8AgmxrHwE+Ml3+158K9AL+CPGl8ZdfjtYjt0jVXOXLADCxTkl1PQPvXjK5/OGv63/HPgbwh8S/CGpeAPH/AIctNX0XV7R7XU9Nv4RJDcQuMMjKeoIr8ZP+ChX/AAbqfFHwBrF98TP2H2fxR4eldpn8GXUwXUrAHkrA7ELdIOwO2QDAw/Wv3HgnjzC1MLDAZlPlnHSM3tJdE30a2u9H3vv+L8ZcEYqOJnjsvhzRlrKK3T6tLqn2Wq9Nvz+/Z4/ax/aN/ZR8St4s/Z7+LuseGLqUj7THYz7re5x0E0DhopQO29TivrbSP+DkD/gozp2krp99P4Hv51TH2+68MlZGPqRHKqZ+ige1fD/jv4c/ED4W+IZvCXxL8D6v4f1S3YrNp2tadJazIQcHKSKD+lY1fomLyXJM1kquIoQqP+ZpN/f1R8Dhc5znK4ulQrTgu12l93RnvX7Uf/BTb9tr9sSzfQ/jb8cNQuNGdsnw9pUaWNifQPFAFEuOxk3H3rwWpbKxvdTu49P02zluJ5nCxQQRl3dj0AA5J9hX2Z+xV/wQy/bP/au1Sz1rxp4Sufhz4QkdWuNd8UWTR3MsR6m3tG2ySEjoW2J/tUVsRkvDuDvNwo010Vl9yW79E2FKhnPEGL91Tq1H1d397ey9WkeH/sN/sYfFH9ur4/aX8FPhtZOkUrifX9ZaMmHSrEMPMnkPrzhV6sxA9SP0T/4OL/g/4G/Z/wD2TPgF8F/htpYs9D8N31/Y6fD/ABFEtoAXY/xOxyzN1LMT3r9If2MP2IPgN+wp8Kovhd8EfDvleaVk1jW7sK97qk4H+tmkAGcchUGFUcAdc/Cf/B0F4d8QeIfhR8JYtA0K8vmi8Q6mZFs7V5SgMEGCdoOK/LaHF0uI+N8JGn7tCDlyp9XyS95/oui9WfplbhVcP8G4pz96tNR5mui5o+6v1fV+iPxWr9o/+DWj/kinxY/7GnT/AP0mkr8d/wDhWnxH/wCif63/AOCqb/4mv2U/4NgPDviDw98F/irFr+h3li8niiwMa3lq8RYC2kyQGAzX13iJUpy4UrJNbw/9KR8r4f06keJ6Taa0l/6Sz9Ra/Iv/AIOFv+CYusa1fT/t6fA7w8bllgSP4i6XZxkuFRQseoqoHICqqS45GEfB+cj9dKZc21veW8lpdwJLFKhSWKRQyupGCCDwQR2r8HyHO8Vw/mUcXQ1to10lF7p/p2dmftueZNhs9y+WFraX1T6xa2a/rVXR/IdXUfCH42fFz4BeMYPiB8F/iLq/hnWbfhL/AEe9aF2XujbTh1PdWBU9xX63f8FJv+Ddyx8c6vqHxn/YUmstLvrlnn1D4fXjiK1lc5JNnKeISf8Ani/yZPDIPlr8mvjN+z58cP2ePE0nhD44fCnXfC+oRuVEOs6dJCJcd43I2yL6MpIPY1/SOT8Q5LxJhv3Mk2170JWuvJp7rzV0fzzm2QZxw9ib1YtJPScb2fmmtn5OzPr7wX/wcX/8FIPC2jppWs694R8QSRqFF9q3hlFmbH977O0an/vmvMP2k/8AgsZ/wUD/AGotFuPCfjn43zaVol0hS40bwpapp0UqHqjvH+9kU9CrOQR2r5fpUR5HEcalmY4VQMkmt6PDfD+Hre2p4WCl35Vp6dvkZVuIs+xFH2VTEzce3M9fXv8AMQkk5JyT1Nd1+zd+zp8U/wBqz4x6N8D/AIO+H31DWtZuRGnB8q1iH+suJWA+SJFyzN6DAySAfcP2Nv8Agjl+2v8Ati6la32lfDm68JeF5WUzeK/FlrJbQeWerQxsBJcn02Dbnqwr9yP2Af8Agm/8Af8Agnt8Pn8N/DCwbUtf1GNf+Eh8XajCou9QYfwjGfKhB5WJTgdSWPNeBxRxzluR0JU6ElUr9IrVRfeTXbtu/Lc9zhrgrMc5rRqV4unR6t6OS7RXn32Xnsb/AOyv+xV8KP2Yf2S9O/ZM0rTIdQ0gaRNbeIZposHVp7hSLqaTv85ZgBn5UCqOFFfzsft+/sa+N/2GP2l9d+CHiq2mewina58M6o6HbqOnOx8mUHoWAG1wOjqw9Cf6iq8K/b4/4J+/BH/goJ8Jj8PPinatZ6nYiSTw34ns4gbrSp2ABZc43xthd8ZIDADkEBh+T8I8YVclzapVxbcqdZ+++qd/i/F3Xb0R+o8VcJ0s4yuFLCpRnSXudrWty/grPuvNn8wFfR/7I/8AwVe/bc/Yt0hPCXwj+KpufDsbZTw14htVvbOLnJEQf54QSScRsoJOSDVz9tL/AIJK/tj/ALFOs3dx4u+HV34h8LROTbeMfDdq9xZtH2MwUFrZvUSADPQsOa+ZK/fk8n4gwV/crUn6SX/Af3NH4W1m2Q4z7VGovVP/AIK/Bn6G+Jf+Dlj9vnWNDfTNE8L+AtIunQqNRttFmlkQ/wB4LLMyZ+qke1fE/wAef2i/jd+0747m+JXx5+JGp+JdZmG0XOoTZWFM58uKNQEiT/YRVX2riq+nf2Dv+CT/AO1P+3d4jtLjwv4UufDvg0yA3/jfWrN0tEjzz5CnabqTHRUOP7zKOa44YDhvhqlLFRpwopbytZ+l9/kt+x1zx3EXEdWOGc51X0j09Wtvm9u58xU6H/Wr/vCvXf2tv2X9c+Bn7Tnjv4OeBvC/iDUNH8MeKLvTdNv59Pd3uIYZCiyMyIFJIGeOOa89i+GnxG81f+KA1v7w/wCYVN/8TXsUcXh69GNWElaSTXo1c8qthMRQrSpTi7xbT9U7H9WXwX/5I74T/wCxZsP/AEnSulrm/g3HJF8IfCkUqFWXw3YhlYYIIt04NdJX8gV/40vV/mf1fS/hR9EFfzX/APBar/lKF8XP+wzaf+m+1r+lCv5xP+CzXgTxvqv/AAU3+LOoaX4N1W5t5dYtDHPb6dK6OPsFsOGC4PNfpPhVKMc9rXdv3b/9KgfnnidGU8kpKKv+8X/pMj5Gr90fjx/wTvH7e/8AwRz+DS+CbSEePvB3wz0q/wDCckhC/awbGHzrIt2EoRdpPAkVMkAsa/En/hWnxH/6J/rf/gqm/wDia/p2/wCCeNrdWP7B/wAHLO9tpIZovhroySxSoVZGFnECCDyCPSvsPEfMq2W08HisNL34VG1/4Ds/JrR+R8n4fZdSzCeLw2Jj7k4JP7915rdeZ/Lzr+ga34V1y88M+JdJuLDUNPuXt76yu4iksEqMVZGU8qwIIIPpXUfAP9oT4xfsw/Eux+LnwN8dXmga7YN+7urVgVlQkbopUbKyxtjlGBB9K/eX/gpz/wAEV/g7+3e1x8U/AOoW/g34kiIBtYjtd1pq+1cKl3GuDuwAomX5gAAQ4AA/Fb9qP/gnN+2N+x9qs9r8aPgpq0GnQuwj8R6Zbtd6bMo/iW4jBVcjna+1sdQK97IuLMk4mwvspNRm1aVOVte9r6SX9NI8POuFs54cxPtIJygneNSN9O17axf9Jn6E/AT/AIOiVtdDg0z9pj9m6e6v4kCzav4N1BFWc/3vs9xjYfYSEfTpW98Vv+DpH4bQaJJH8D/2X9cu9RZCIZvFWqQ28EbdiUtzIzgem5c+or8aaKyl4e8KTr+19h8uaVvuv+GxpHj3iiNH2ftvnyxv99j179sP9uT9ov8Abl+IA8f/AB88ate/ZgyaTo9onk2Omxk5Kwwg4BPGXOXbAyxwMeRKrOwRFJJOAAOtehfAP9k/9o/9qHxBH4c+Avwb17xLM8gSS40+wc20HvLOQI4h7swr9hf+CX//AAQH8J/s5a1p3x3/AGubvT/E3jC0Kz6T4Ztl83TtImByskjN/wAfMy8Y4CIeRvIDDrzbiHIeFMF7O6Tivdpxtf7lsu7f4s5cryHPOKMZ7Szak/eqSvb73u/Jfgjpv+CB/wDwTj1j9k34MXnx/wDi/oJtPHHj22i+z2NxGRLpWlj544mB5SSViJHXsFjB5BFfiN+0n/ycX4+/7HXVf/SuWv6v6/lZ/aO+HPxCuP2hvHk8HgTWXR/GeqMjppcpDA3cuCDt5FfF+HubV83zrHYzEv3pqHold2S8ktD7Dj3KqOV5NgsJhk+WDl6t2V2/Ns4fwB/yPeif9he2/wDRq1/WzYf8eMH/AFxX+Qr+UHwH8NviKnjnRXfwDrQA1a2JJ0qbAHmr/s1/V9YAixhBH/LJf5Vx+LU4yng+V30n/wC2HX4WwnCGL5lb4P8A24+WP27v2kfit4dtPGegfCXU7jS9K+HXh2y1Txrqenzxw317NezeXa6bazSRSrbZRXlln2M6KYwgBfcvC2n/AA1f8Hvi5oXgHR5dW0fxR4g0jUtT8P2F58Vrrxbo+uGwWKSezvFvraOaxMiyqI57c4VyMqR8p2/+Cgnwu8W6NZfExYtGa48IfF/w9pdnq+tLazTR+H9SsZQolukgR5BazW2FMqqRG8C7sCTcOdv9Q/Zt+G37R/hj4of8E7LPwv4s1y58Kavoes+FvA9+119olmNvJYz3MkQeG0hiljkMskzRkI/yh2AQ/K4GFD+z4RpwTupa2urqEX77ukvf5rcyelvhVpH1WLlW+uyc5tWcetnZzkvcVm37nL8LWt93eJ9jfBf4paL8bfhP4e+LXh62lgtPEGkw3sdtPjzIC6gtE+ONyNuQ44yprp64r9nH4UT/AAN+BXhb4T3uqLfXWiaPFBfXqKQs9zjdM6g8hTIzkDsCBXa18biVSWImqXw3dvS+n4H1dB1XQg6vxWV/W2v4hRRRWJqFFFFAGH45+GPw3+J2mnRviR8P9F1+0P8Ay7a1pcV0n1xIpAryy7/4Jqf8E/r66N7dfsc/Dt5Scl/+EXtxz+C17fRXTRxuMw8bUqkorybX5M56uEwld3q04yfmk/zOK+G/7Nv7PfwebzPhV8EPCfh2TGPO0fQLe3kI9N6IGP512tFFZVKtWtLmqSbfdu5rTp06UeWCSXZaBTZIopQBLGrY6bhmnUVmWR/ZLT/n2j/74FOjiiiBEUarnrtGKdRRdgFFed/tD/tZfs5fsn+H4PE37Q/xc0nwta3e/wCxLfysZropjcIokDSSkblyFU4yK73S9Ss9Z0y31fTpfMt7uBJoHwRuRlDKcHkcEVrKhXhSjVlFqMr2dnZ23s9nbqZxrUZ1XTjJOStdX1V9rrpfoT1neKPB/hLxxpMmg+NPC+navYyjEtnqllHcROPdHBB/KtGis4ylF3Tsy2lJWex4Xrv/AATJ/wCCfHiW8Ooaz+x18P5JmbLOnh2GPJ/4ABXVfDT9jb9k34OXial8Lf2b/BWhXUZzHdad4bt45UPqHCbh+Br0qiuyeZZjUhyTrTa7OTa+65ywy/AU588KUU+6ir/kAAUBVGAOgFFFFcR1hRRRQAjokiGORAykYKsMgivJviR+wb+xd8Xr6TVPiT+y54G1a7mYtLd3HhyASux6sXVQxPvnNetUVtRxGIw0uajNxfdNr8jKtQoYiPLVgpLzSf5nifgX/gm7+wV8NdUTW/Bf7JPgS0u423R3L6BFM6H1BlDYr2m3t7e0gS1tYEijjUKkcahVUDsAOgp9FOvisVipc1abk/Nt/mTRw2Gw0bUYKK8kl+Qxra2ZizW6EnqSgpPslp/z7R/98CpKKwuzcAABgCiiigApjW1u7FngQk9SVFfmx/wUy/b8/wCClvwA/b58KfBn9m34ayXfg+9hsHtLZPDIu18QySPieNrgoTDsPyYRkKgb2JBFfpTGzNGrOu1ioJHoa9THZTicuwtDEVJRarRco2d2kv5l0ev9NM83BZph8fia9CnGSdJ2d1ZNvs+q/rZoZ9ktP+faP/vgU9VVQFUAAdAKWvnn/gql+0N8T/2Vv2FvGvx1+DmqW9l4i0X7B9gubqzS4jTzb6CF8o4Kt8kjDnpnNcmDwtXHYunhqfxTkoq+127K51YvE08FhamIn8ME5O29krux9DU2aGG4iaC4iWRGGGR1yCPcGvmj/gkV+0z8Wv2u/wBh3w98cfjdq9tfeIdR1PUYLq4tLFLeNkhupI0ARAFGFUfWvpmqx2Dq5fjamGqW5oScXba6dtCcFi6WPwdPE078s0pK+9mr6nlfjf8AYb/Y1+JF6+peOf2W/AWp3EjbpLi58LWpdz6lggJP1qj4c/4J6/sL+Er0aj4d/ZG+HltOpBWRfClqxB/4Ehr2KimsxzCMORVpW7czt+YngMDKfM6Ub9+VX/IraRouj6BYR6VoOk21laxLtitrSBY40HoFUAAVZoorkbbd2dSSSsgqM2tqTk20f/fAqSikMj+yWo6W0f8A3wKkoooACARgio4LS1tsm2to4933tiAZ/KpKKACiiigAooooAKKKKACiiigAooooAK+av+Civ/BQ+5/YQ07wrp3h39nfxL8RPEXjW4uoNA0rQzsiMsAjLLI6pI4YiUFVWNshW5GK+la87/aS/ag/Z6/ZN8ED4n/tD/ETTfD2nozJZyXQMk9xJjJjgiQNJK2MZCA9s4Fd+WKm8dBTousv5E2nJ20V46766b7HFmPOsFNwrKk/52k1FX1dnptprtufn14z/wCC1X/BTT4Q6Qfib8Yv+CVWp6R4PhIe8urpNQtmgjJx+8neFli6jl4wK+2/2Df28fg3/wAFAvg2Pix8KPtFnPZ3Atdf0G/ZTcaZc7d2xivDow5VxwwB4BBA+SvHv/Bw/wDsy+OrDU/B3w2/ZV+JPjzS7y2ltbuSPSYUgnidSrKV3O2CCchlHBr5+/4NkfFV3bftR/FjwdpcE1ppV/4ZjvP7PlY5iaG82Rhh/eVZnX8TX32YcPQr8P4jF1cF9Vq0uVq0m1JN2acW201vfS58Ngc+nRz2hhaWM+s06vMneKTi0rpqSSTT2trY8a/4LX/ts/GP9rfxH4T0T4p/sm618NIfCd7qsGl3erXM8i6wrvCpePzbaEAKIlPyl/8AWDkd/vv9jX/grd+1P8Xvij4D+BXiv/gml4s8M6Jqj29hc+MLu+vGgtIlh4uGD6eilTtHWQD5uteJ/wDB1B/zRn/uN/8AtnX6vfDH/km3h7/sB2n/AKJStM5zDK1wjgJPBq0/aqK55+41Kza19671tLTpsRlGBzP/AFrxsfrbvH2Tk+SHvrluk9NLLS6s+u5uV8Z/8FTf+Cqfjb/gmt4h8JAfs2ReL9A8U202zWT4oayNvdRMN8Bj+yyg/IyODuGfmGBtyfsyvlX/AILM/spf8NZfsG+K/D+j6abjxB4XQeIfDgRMu09srGSMdyXgaZAB/Ey+lfD8P/2dLOKMMfDmpSdpatWvondNPR2fofZ57/aCymrLAy5asVdaJ3tq1ZprVaH0d8MfiF4c+LXw40H4peD7sT6V4j0e21LTpQQd0M8SyIeO+1hXy7/wVQ/4Ku6V/wAE2h4P0jT/AITJ401vxZJcOulnXTY/ZreLYvm7hDKWLO4UDA+63PGK81/4Nyf2oP8Ahcn7GF18Edb1AS6v8M9U+yIrNljp1yXltj9Ayzxj0Ea182+O9M/4eg/8F/4vCrA33gn4X3Cw3jD5o/sumEySKR0Ilv3Mfur+2K+jy7hzDYbiLFUcfG9HDRnKWrXMkvc1VneV01bc+fx/EGIxGQYatgZWrYhwjHROzb97R3Vo2aZ+lfxa/bl+HH7MP7KejftLftWQp4Tn1PSLWaTwxaXP2u5N9NCJDYwZWMzSLkgthVG0scAZr4u0P/gt3+338f7e58b/ALI//BL/AFnXfCFvI6x6tdvd3RuAp52tDEib/VEMhB7mvFv+CwF/rX7Zf/BZHwB+xRquqzx+HNJvNH0loIJMBGvvKubuYdt/kui57eUK/Zfwf4P8L/D/AMLaf4I8FaFbaZpOlWkdrp2n2cQSK3hRQqooHQAClXw2UcP5bh69fDqtWxC50nKShCD+FJJpttdW9PzdDE5rnuY16NCu6VKg+RtRi5Tmvibumkl2S1PiX9hb/guX8Kv2nPion7OXx5+F1/8ACv4hSXJtbXTNWujJbXdyDg24d443hmPaOReegYnAPtn/AAUq/bguf+CfX7Np/aAtfhqnithr9rpv9lSaubIYmEh8zzBFL02dNvOeor4J/wCDmr9nvw74QuPh3+2J4Ltl03xBcaudF1a+s/3clw6RGe0mJHO9BFKobrjaP4Rjsf8Agrv8XNU+PX/BDH4c/GXXWB1DxJdeG77USBgG4e1lMpH/AAPdXZDIcnx2Jy7G4em40cRPknTbb5ZJ6pS3s9ba3XzsuSWd5tgsPj8HXmnWoQ54VEkuaLWjcdrrrpZ/LX7w/Yi/aVm/bB/ZZ8IftJT+Dl8Pv4ps5p20dL/7ULby7mWHHmlE358rdnaOuO2a4X/gp9+33df8E6fgHpnxstPhZH4ubUPE8GkHTZNZNiIxJBPL5vmCGXOPJxt2j72c8c5H/BFH/lF38JP+wRef+nG6rw7/AIObP+TDvDf/AGU2y/8ASK9rxcDlmBrcafUZwvS9rKPLd/CpNJXvfp3uevjcxxtHhD67CVqvsoyvZfE0m3a1vwsfY/7MX7Rc/wC0X+yf4Y/aZfwgukyeI/DX9q/2Kt8ZxAdrHyvN2Lu+797YOvSvi/4Mf8HFfwm8V/Arx78ZvjP8Gm8L3HhPU7DTtD8O6Z4iF/c67c3KXLBVLQRCJUFsSzkMAG9cK30R/wAExP8AlFj8Lv8AsnS/+gyV+U//AAQF/ZU+HX7SP7bHiLxR8VdDg1fSvAelvqlppN4geCa/e4EcLyIeHVF81gCPvbT2wfXyvJ8inSzSri4Plw81y2bvbnkuVa296yjd3a33PLzLNs6hUy2lhZrmrxfNdK1+WL5tr+7duysntsfoh/wS2/4KnfGz/goH8V/E3hzx5+zZH4J8PadoC6lol+stzK1yTOkflmWSNEk+Vs5VR06V9d/GP4u+APgJ8L9b+MXxS16PTNA8PWD3ep3kgzsQcAADlmZiFVRyWYAda6OOKKFBHDEqKowqquABXzX/AMFdf2dfiX+1J+wR41+E/wAIbZrrX5Ftb6y01HCm/wDs86StACSBuZVO0HqwUd6+Xc8szTO6ajTWHoylFNczfKrpN3f36n0ijmOW5PUcpuvVjGTTaS5nq0rL7tD5Q0//AILu/th/tFa1qN1+w1/wTe1rxX4c024aJ9XvDdXLPjkbxbRiOFyMHy/Mc89TX0d/wTt/4KFftE/tZ/EHxF8J/wBoP9ifXvhfqvhvSo7251DUZJ0gnLyBEiEVxBG6sfnYEM4wh5HGfiD/AIJbf8Fq/hP+xb8IdN/Y3/av+D2t+F5PDF5cQ/27p+nMzqZJmkcXlqwWVJFZiCyhiQB8oI5/V/4DftH/AAL/AGnvBSfET4CfE3SvE+ku2yS406fLwP12Sxth4n77XVT3xX0vFGBo5TGpRWWqENoVeabvrpJu7i7r7Lta/kfO8N42tmjp1nmDnO150uWCtpqrWUlZ9etvM+Zf26/+Ctt9+xj+194G/ZYt/gND4iTxlFYO2uP4lNqbT7TeNbY8kW8m/bt3ffXOccda+u/Hfjrwh8MfBup/ELx94httK0XRrKS71PUbyQJFbwoMszE+w6dSeBzX4/8A/Bcr/lLn8D/+vTQv/TvJXs3/AAc3fHHxB4H/AGXvBvwU0K/eCHxx4jll1cRtjzraySNxEcdjLLE31jFJ8NYTG/2TRoLlliIyc3du9nq7N20V9rIpcRYnBrM61d80aEkoKyW60V0r6tre7Mfxh/wcLfFj4t/E68+H/wCwB+xDrXxBtrBjnUriK6mmuIwceYLW1jLQoccF3JI6qp4rzL9u/wD4K+3H7SH7EPxJ/ZT/AGlv2cdd+FHxLltdOn03StUSbydRSPULd3CiaKOSFwqOwVgwIQ4fPFfoR/wSn/Zf8E/stfsP+BPDfhrRYYdT13w/aa14lvhGPNu726hWZt7dWCBxGo6BUFeOf8HDvwK8AfEP/gn5rPxZ1nRYf+Eg8D6lY3OiamIx5qJPdRW80JbqUZZN23puRT2rry7G8Lx4ko4OhhLRjUio1OeTm5KStJp+603uraJ6HLj8HxI+H62LrYq8pU5OVPkjyqLi7pNe9dLZ31a10Nf/AIN8OP8Agl/4Qz/0G9Z/9L5awP2qf+C4ekeCvjbc/sv/ALFP7P2rfGbxxZzSQah/ZMkn2O1mQ4dF8mOR7gochyNiKf4zg15H+xj8dNd/Zv8A+DcfXfi34VvGt9Vso9YtdLuEOGhuLrVDapIvupm3j/drxH/gjH/wUe/4J/fsDfBbW5vjDF4kf4heJtYeTVtQ0/w+LgJZRgCCFZS4OMmSRvUuM52iuqeQRxeY5lmM6Eq/LWlCFNXV5Xu3JrXlimtt3octPPHhcvy/L4140OalGUqjtpGySUU9Lyd99krn0XZf8F4f2i/2fviBpfhj/god+wPrPgDR9XlCQa/YG4HlDuyxTIVuAvVgkoYDsTxX6SeC/GXhf4ieEdM8e+CNct9T0fWbGK80zULSTdHcQSKHR1PcFSDX5Uf8FJf+Cx3/AATe/bP/AGOvF/wN0yHxVca7eWi3Hhea+8MiNbbUInV4n8zzCUBwUYj+F2HevdP+Dcv4meIPHf8AwTxi8N69cvMvhXxbfabp7u2SLZhHcKn/AAFpnA9Bgdq8nPshjHIlmP1V4apGfLKHvcsk1dSjzXa10auepkmdylnby9YpYiEoc0Ze7eLTs4y5bJ6ap2PvaiiivgD7kKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAr8Tv+CnuoaV8fP8Agut4M+A/7Seryw/D7TtS0PTobK5uDFbm1uEjmk+bI2iaZ/LaQEEAAZGwY/bGvlD/AIKQf8EjvgV/wUVbT/FfiDxDe+FPGWk2ptbLxRplqs/m2+SwinhZl81VYkrhlZdzc4OK+p4QzXBZTmkqmJbjGUJQUkruDltJLfTy11PmuKssxeaZbGnh0pSjOMnFuymo7xb8/PTQ941rUvgT+yb8HLzxLPaaF4N8H+GtNMsv2W3jtbeCFF4VVUAEngADJYkAZJr8jf8Ag291208Uft4fFrxNp6usGo+F7m6gEgwwSTUonXPvgivpD4U/8G+mmLrelt+1l+2n43+Knh7RplksPCNys1nZfJ91X8y6nOz1VNnHGa9o/Yz/AOCTfwx/Yn/al8b/ALSfw3+I1/NB4yivYl8JtpkMNppsU94tykcTIc7YgvlqCPu/SvWo43IMsyfHYWniXWq1oq0uSUY6O9tdb6ttuy2Wp5dXB55mWbYLE1MOqVOi3ePMnLVWvppZaJJXe+x8ef8AB1Bp94dP+DOqi3Y24m1qIygcB8WZCn3wCfwNfqH+z9408NeP/gZ4N8ZeFdWgu7DVPDNjPaTwyhg6tAh7dx0I7EEVxP7dP7Dnwh/b7+CUvwa+LJubXybpbzRdasNv2jTbpQVEibhhgVYqynhlJ6HBHy1+w5/wQk179jX9obw58an/AG09X8Q6X4ZubiWz8Kr4aa0t5/NgliO8m8kUY80twnJA6VyyxmTZlwrQwleu6dbD+0aXK5KfM+ZJNaLWyu/U6Y4TNsv4nrYqjRVSlX9mm+ZRcOVWbaer010P0Mpsscc0bQyoGR1IZWGQQeop1FfFH2B+Fd18SNT/AOCJP/BUX4taVY2csXhbxL4W1S58NWiRkxus8T3WmgDuI7lfs5J4A35r6s/4Nuv2bNQ8L/ALxT+1142t3k1z4ka1JFYXc+TI9hbu2+TJ5/eXJmz6+UprwL/gt1qvhP8Ab9/4KL/Db9j79nXT7fUvFejeZo3iPXrU+Ykck8yO0Llf4bRElkc9jK69VNfr98FvhP4U+BPwl8OfBvwNaCDSfDWjwafYpjkpGgXccfxMQWJ7kmv1LifNeThrDqceXEYmMPad3CndRb/xuz9EfmnDmWc3EVfklzYfDSn7Psp1LOSX+FXXqz8ff+Cz2g+Kv2Mv+CtngH9u0aFPc6Dql3pOqeZCvyyT6f5UNxbZ6BjCkZAJ58w+hr9iPhX8Vfh98bfh/pfxS+Fvim01nQtZtEuNP1CzkDK6MM4PdWHQqcEEEEAisH9pX9mL4KftcfCy8+Dvx38GQazo12wkQMdk1rMAQs8Mg+aKRcnDDsSDkEg/Aqf8G7HjPwBe3mlfs6f8FIvHngzw3qEhNzosemyuzKeCHe3vYEkOOOYxXizx2TZ/lOHoY2s6FaguRS5XKModPh1TX3ffp7MMFm+R5piK2Eo+2pVnzOPMoyjPr8WjT9b/AHa+Yf8ABxj+0povx8+JHw//AGE/gnOPEOv6drn2zWbXTCJSmoTJ5FraAr1k2ySMw/h3rnnIHtv/AAVq/Zj134af8EP9E+D2lxm6m+Gtn4eOpNANwcW6rbzyD23Ss5PoDXsP7B3/AARn/Ze/Yb8Sj4o2txf+NfHO1tninxGiE2rN99reEZWJmyQXJZ8EjdgkH6o8Y+EPDHxB8J6n4F8a6Jb6lo+s2Etlqmn3cYeK5t5UKSRsD1BUkH61eI4jwGAngcNgE50sNLncmrOcm7tpdFa6V9dfIjD8P43GwxuIxzUauIjyKKd1CKVkr9XfV20003PjH/g3/wDj94C+J/8AwTx8L/DTSNdtjr/gae807W9M80CWMPdzTwy7M52NHKoDdNysO1eAf8HM/wC1F8K9R+FHhT9lXw94ittR8UJ4lTXNXtbOUP8A2bbxQSxIJiPuvI0+VXrhCTjIzteOv+DZvwbB8Rbjxb+zv+2H4i8C6bcyMV019DN3NbRscmNLiO6gZlHQBlJ9Sa9Osf8Ag31/ZY039mnxB8EbXxvrc3iXxRd2lxrPxFv7eOe/byJhL5USMdsUbMPmAJLHBZm2jHpUsZwhhOI1m8cTKSlPm5ORpxcnq5S2ajdtKKbei8zzqmE4rxfD7yqWHjFxhy8/OmpKK0UYrVOVkm5WS1fkev8A/BMT/lFj8Lv+ydL/AOgyV+fn/BsP/wAnH/GL/sXbX/0sev1V/Zt/Z20v9nH9mjw5+zXpfie51Wz8OaGdMh1S6gVJZk+bDFVJAIDYwPSvDv8AgnP/AMEl/Af/AATq8f8Aivx94R+L+r+JJfFdhFaz2+padFCsASUyBlKEkkk45ryaOdZfDAZtScta8k4aPVKbfy0fU9Srk+PnjcrqKOlCLU9VpeCXz1XQ+t6ravrWj6BZHUtd1a2srcSIhuLudY0DOwVV3MQMliAB3JA71ZryD9uL9jjwV+3X8Bbv4BePvGOt6Jp9zfw3n2vQpkWQyRbiiurqwkjyQxXjlVORivj8NChUxEI15csG1dpXsurt19D6zETrQoSlRjzTS0Tdrvor9PUP2kv2E/2RP2vNKki+PHwS0PW55ISketpD5F/EMcFLqErIMdQNxX2PNflT/wAE4fCK/sh/8F3tT/Zd/Zx+I134g8CSNqFjq84nEiS2yaa10FlKfIzwXQSHeAPmVhxuIr3SP/g3g+NOmWjeFPDv/BUvxvZ+G5BsfSBodxt8v+4VXUlRuOPuge1fUn/BPr/glN+zj/wT0hvdd8ASX+v+LNUt/I1LxZrezzzDkMYoUUbYYywBIGWYgZY4AH3tDM8qybKMThoY14lVYOMafJKMYt/bfPomu0f8j4itluZ5vmuHxE8GsO6c1KU+eLlJL7K5d0+8tj4G/wCC5X/KXP4H/wDXpoX/AKd5K9q/4OafgN4j8f8A7LfhD42eHtPkuIvAniGVNY8tcmK0vVjj804/hEsUK+3mV7v+2X/wSb8CftkftS+Df2ovEXxe1fRb7wdFZJb6VZadFLFc/Z7prgFnYgjJbacdq+pPF/hDwv4/8Lah4I8baDa6ppGrWclrqWnXsIkiuYXUqyOp4IINYf6z4bB/2VWoe9LDxamrNbvVJvur6m3+rmIxcczo1/djiJJxej2Wja8mlofNn/BIv9sf4cftX/sZeDYtE8SWreJvCugWmjeKNGaYC4t57aIQiUpnOyVUEisOPmI6ggeK/wDBxJ+1d8L/AAL+xtqH7MsWv2154w8bXlmYtItpQ8tnZ29zHcSXMqjlFJiCLnG4sSM7Tjk/ij/wbUfDt/iJP44/Zg/au8R/DmCeVmXTW0o3xtlY5KRTpcwSBB2Dbj0yx616P8JP+CA37N/w6+FPjPw34o+JGueKvGvjXQ5dMufH2sW6NNp8cmN7W0DMwRjjBZnZiONwBIOtKfB2DzmGZ08TKUVNTVLkacXe+strReul20reZlOHFuLymWXVMPGL5XF1OdNSVraR3vJaa2Sbv5Hjn7GfwJ1/9pT/AINyNc+EXhCzNzrF4NXutLtkGWmuLXVDdJGv+0/k7B/v1T/4N6Pi/wDsn/EH4IX37K/xe8E+ED480DWri502PxDo1s1xqdlMd5EbyoWd4pPMDJnIVkwMZx9+fsGfsb6B+wh+zvZfs8+GfG974gs7HUrq7j1G/tUhkJnfeVKoSMA55r57/bT/AOCCP7L/AO1R4+uvjB8PPFep/DTxZfXJudQvdCtEns7m4JyZ2tiybZC3JaN0yTkjOTWn+sGU42pjsFiKkoUqtV1YVIptxfnHRtNfP9I/sLNMHTwWMoU4zq0qSpzpyaSkvKWqTT+X6/WU/wCzp+zbaxGe5+BPgeNFGWd/DFmAB9THXQeBvC3w/wDC2hJD8NfDuj6dpl3i5jTQ7SKGCbcoxIBEArZXHzdxivzU07/g3L8fa4V0v4tf8FKvG2uaKDtk0u30aWPzE9N019Kq/TYa/RT4AfBjw5+zr8FvDPwM8IarqN7pfhXSItO0+51adZLh4Yxhd7Kqg4HAwAAAB2r5fNqOXUKKWHxrrtvVckopLveT1fy+Z9JldbH1qreIwaopLR80ZNvt7q0Xz+R19FFFeCe2FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAV8uf8FXvA/wC3r8Q/gNpXhH9gTxG9hrmpa8LPxJ5F1b20v9nSQybpFuJiDDtdUBKHeQ5x0r6jorrwOLlgMXDERjGTi72krxfqupy43CxxuFnQlJxUla8XZr0fQ+Kf+CT3/BIbwz+wHZXnxU+JevweJvidrlr5V7qkSk2+lwsdzwW5cbnZmxvlbBbaAAozu+1qKKvMsyxmbYyWJxUuacvwXRJdEuxGX5dhMrwkcNho8sF/TbfVsKKKK4TtCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA//9lQSwECLQAUAAYACAAAACEAyOEzkhUBAABSAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAAEYBAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQBCSNt/FgIAAKcEAAAfAAAAAAAAAAAAAAAAADACAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAJStDd/UAAAArAEAACoAAAAAAAAAAAAAAAAAgwQAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc1BLAQItABQABgAIAAAAIQCLZi1ovAYAAOkbAAAaAAAAAAAAAAAAAAAAAJ8FAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbFBLAQItAAoAAAAAAAAAIQDKphSpGVUAABlVAAAbAAAAAAAAAAAAAAAAAJMMAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLmpwZWdQSwUGAAAAAAYABgCwAQAA5WEAAAAA" alt="Brother-Logo-BLUEpc" type="#_x0000_t75" o:spid="_x0000_s1025"><v:imagedata o:title="Brother-Logo-BLUEpc" src="file:///C:\DOCUME~1\AZAIMR~1.WPC\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.jpg"></v:imagedata><?xml:namespace prefix = x ns = "urn:schemas-microsoft-comffice:excel" /><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Bitmap</x:CF> <x:AutoPict></x:AutoPict></x:ClientData></v:shape><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 137pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" width=183 height=20>DCP-8020/8025D/8025DN</TD></TR></TBODY></TABLE></TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-8040/8045D/8045DN</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-8060/8065DN</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1">X</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>DCP-8070D/8085DN</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>MFC-7225N</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1">X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>MFC-7320/7440N/7840W</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>MFC-7360N/7460DN</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #eeece1" height=20>MFC-7420/7820N</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #eeece1">X</TD></TR></TBODY></TABLE>


next sheet which i have to take the model across which have an X next to the hardware is hown below

<TABLE style="WIDTH: 526pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=701 border=0><COLGROUP><COL style="WIDTH: 220pt; mso-width-source: userset; mso-width-alt: 10715" width=293><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl71 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 220pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #d8d8d8" width=293 height=18>Hardware</TD><TD class=xl72 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 306pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8" width=408 colSpan=4>models</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>Mod 1</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">MFC-7225N</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">DCP-7025</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>Mod 2</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">DCP-7025</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">MFC-7225N</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">MFC-7320/7440N/7840W</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">MFC-7420/7820N</TD></TR></TBODY></TABLE>


am i making any sense?

so i have a hardware sheet with all those X and then on the next sheet i have all the models listen i need to birngacorss the hardware name which has an X next to the model

is there anyway of doing this?

 

[theBardd]

Use these array formulae

=IF(ISERROR(SMALL(IF(Sheet1!$B$1:$B$15="X",ROW($A$1:$A$15)),COLUMN(A1))),"",
INDEX(Sheet1!$A$1:$A$15,SMALL(IF(Sheet1!$B$1:$B$15="X",ROW($A$1:$A$15)),COLUMN(A1))))

and

=IF(ISERROR(SMALL(IF(Sheet1!$C$1:$C$15="X",ROW($A$1:$A$15)),COLUMN(A1))),"",
INDEX(Sheet1!$A$1:$A$15,SMALL(IF(Sheet1!$C$1:$C$15="X",ROW($A$1:$A$15)),COLUMN(A1))))


Array formulae are entered by hitting Ctrl-Shift-Enter after typing the formula, not just Enter.

 

[cyrilbrd]

Another alternative to theBardd's solution:

considering that your data is in sheet 1 from A1 to C15 (adjust formula to fit your real data range)

In Sheet2:
Cell A1 "Mod1"
Cell A2 "Mod2"
Cell B1:

=IF(COLUMNS($B1:B1)>COUNTA(Sheet1!$B$2:$B$15),"",INDEX(Sheet1!$A:$A,SMALL(IF(Sheet1!$B$2:$B$15>0,ROW(Sheet1!$B$2:$B$15)),COLUMNS($B1:B1))))

Cell B2:

=IF(COLUMNS($B2:B2)>COUNTA(Sheet1!$C$2:$C$15),"",INDEX(Sheet1!$A:$A,SMALL(IF(Sheet1!$C$2:$C$15>0,ROW(Sheet1!$C$2:$C$15)),COLUMNS($B2:B2))))

Also an array formula Ctrl + shift + enter on a PV or Command + Return on a mac.
Copy to the right as far as needed.


This formula works with anything, not necessarily with "X", so it could be used with values of letters...
Cheers!

 

[c0259621]

thank you for this help, however i have no idea how to use these, and where to insert these

any tips?

 

[theBardd]

Where you would copy the values to, where else?

 

[cyrilbrd]

ur file.

where do you have problems?
use either of the two solutions (formula) following the steps I provided.

Still having difficulties?

 

[c0259621]

thanks i will now have a go with the formula and see how it goes

 

[cyrilbrd]

Keep us posted if you need more help.

Cheers!

 

[cyrilbrd]

Kindly check the file.

 

[hiker95]

c0259621,


Sample raw data in worksheet Hardware:

Excel Workbook
	A	B	C
1		Mod 1	Mod 2
2	Hardware
3	DCP-7010/7010L		X
4	DCP-7025		X
5	DCP-7030/7045N
6	DCP-7060D/7065DN/7070DW	X
7	DCP-7055	X
8	DCP-8020/8025D/8025DN
9	DCP-8040/8045D/8045DN
10	DCP-8060/8065DN	X
11	DCP-8070D/8085DN
12	MFC-7225N		X
13	MFC-7320/7440N/7840W
14	MFC-7360N/7460DN
15	MFC-7420/7820N		X
16
Hardware

After the macro in a new worksheet Results:

Excel Workbook
	A	B	C	D	E
1	Hardware	Models
2	Mod 1	DCP-7060D/7065DN/7070DW	DCP-7055	DCP-8060/8065DN
3	Mod 2	DCP-7010/7010L	DCP-7025	MFC-7225N	MFC-7420/7820N
4
Results

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Option Explicit
Sub ReorgData()
' hiker95, 04/15/2012
' http://www.mrexcel.com/forum/showthread.php?t=627999
Dim wH As Worksheet, wR As Worksheet
Dim r As Long, lr As Long, nr As Long, c As Long, lc As Long, nc As Long
Application.ScreenUpdating = False
Set wH = Worksheets("Hardware")
If Not Evaluate("ISREF(Results!A1)") Then Worksheets.Add(After:=wH).Name = "Results"
Set wR = Worksheets("Results")
wR.UsedRange.Clear
lr = wH.Cells(Rows.Count, 1).End(xlUp).Row
lc = wH.Cells(1, Columns.Count).End(xlToLeft).Column
wR.Cells(1, 1).Resize(lc).Value = Application.Transpose(wH.Cells(1, 1).Resize(, lc).Value)
wR.Cells(1, 1).Resize(, 2) = [{"Hardware","Models"}]
For c = 2 To lc Step 1
  For r = 3 To lr
    If wH.Cells(r, c) = "X" Then
      nr = c
      nc = wR.Cells(nr, Columns.Count).End(xlToLeft).Column + 1
      wR.Cells(nr, nc) = wH.Cells(r, 1).Value
    End If
  Next r
Next c
wR.UsedRange.Columns.AutoFit
wR.Activate
Application.ScreenUpdating = True
End Sub

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm


Then run the ReorgData macro.