Formula help

Damo10

Active Member
Joined
Dec 13, 2010
Messages
460
Hi,

I have a formula to wok out the ammount of tanks that are required by dividing the total weight by the maximum weight of the tank size selected, in general this works well but there are occasions where it does not.

The issue arrises on some occasions where fruited tanks are being packed. I also have some formulas in other columns to work out how much goes in each tank based on the result of this formula which works fine but this is where I am experiencing the issue as the last tank that sometimes works out to give a result of more than will fit into the tank.

The example below shows tank 5 as having 17 bags, this exceeds the maximum quantity of the tank 17*83 (col AE)=1440 max weight 1300 col (AL)

What I would like is to ammend the formulas somehow to ensure that the result displayed does not exceed the maximum quantity for the tank size selected, if it does then the ammount of tanks for the run should then be increased.

Please see examples of the formulas and the results I am currently getting

<TABLE style="WIDTH: 819pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1092><COLGROUP><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 125pt; mso-width-source: userset; mso-width-alt: 6070" width=166><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=6 width=47><TBODY><TR style="HEIGHT: 99.95pt; mso-height-source: userset" height=133><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 43pt; HEIGHT: 99.95pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=133 width=57>L</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 41pt; HEIGHT: 99.95pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=133 width=55><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t201 path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:path o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"></v:path><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:lock shapetype="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="Z-INDEX: 5; POSITION: absolute; MARGIN-TOP: 13.5pt; WIDTH: 99.75pt; HEIGHT: 50.25pt; VISIBILITY: hidden; MARGIN-LEFT: 0px" id=UserForm type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAZIjLJr4BAAANBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysk9tu2zAM
hu8H7B0E3a/Ooakzo04xtEsxoFiDbX0AVqZtYTpBUr307UfFShrkohja3VEi9fMTD5dXW63YgD5I
a2o+PZtwhkbYRpqu5g+/1p+WnIUIpgFlDdb8GQO/Wn38cAlV58H1UjBSMKGCmvcxuqooguhRQziz
Dg35Wus1RDr6rmg8/CFlrYrZZHJRaJCGr16kbiACe/LyDVLKit/YXIMZIJCkEtXxTWZU4v3KUJnh
1rufbuMTufg+bDyTTc2pcgY0lYgX2ZHD6FicvOpeBLat1yneti3b1vzzsizPZwvOnsmez88Xk1EO
t5EJ8k9n5XSxLDkTFHAxX07LRc7X37+uIPqvr2sQ5AhDxhGgkyLxmWEjxemfZ/s/PwT0a2o0Z71s
GkyjdCjD4R0p3VGbAjP2ugfT4ZfgUMQcS1lTMccku4IdHj4q6dZSqcSR7NxO/y/dpLpKgTdWPGk0
cZw7jwoiDXzopQuc+Qr1I1IL/bcmY4foMYo+JWwp8Q/CHNt4cBDhMVbI8/B/2knieyHnQ7xFq1ky
CJFIdisDw13ITPuQ3ZyNICRA1aaLk0XYheTFTdt2fF79BQAA//8DAFBLAwQUAAYACAAAACEAU1KJ
YdIAAACrAQAAKgAAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQ
wUoEMQyG74LvUHK3mdmDiGxnLyLsVdYHCG2mU5ympa3ivr3VvTiw4MVLIAn58vHvD59xVR9cakhi
YNQDKBabXBBv4PX0fPcAqjYSR2sSNnDmCofp9mb/wiu1flSXkKvqFKkGltbyI2K1C0eqOmWWvplT
idR6Wzxmsm/kGXfDcI/lNwOmDVMdnYFydDtQp3Pun/9mp3kOlp+SfY8s7coLbN2LO5CK52ZA68vk
UkfdXQGva4z/qRFij2CjEdkFwp/5qLP4bw3cRDx9AQAA//8DAFBLAwQUAAYACAAAACEA/cFa784G
AAA9HAAAGgAAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1s7FlPbxtFFL8j8R1Ge2/j/42jOlXs
2A20aaPYLepxvB7vTjO7s5oZJ/UNtUckJERBXJC4cUBApVbiUj5NoAiK1K/Am5nd9U68JkkbgSjN
Id59+5v3/715s3v12oOIoUMiJOVxx6terniIxD6f0DjoeHdGg0vrHpIKxxPMeEw63pxI79rm++9d
xRs+o8mYYzEZhSQiCBjFcgN3vFCpZGNtTfpAxvIyT0gMz6ZcRFjBrQjWJgIfgYCIrdUqldZahGns
bQJHpRn1GfyLldQEn4mhZkNQjCOQfns6pT4x2MlBVSPkXPaYQIeYdTzgOeFHI/JAeYhhqeBBx6uY
P29t8+oa3kgXMbVibWHdwPyl69IFk4OakSmCcS60Omi0r2zn/A2AqWVcv9/v9as5PwPAvg+WWl2K
PBuD9Wo341kA2ctl3r1Ks9Jw8QX+9SWd291ut9lOdbFMDcheNpbw65VWY6vm4A3I4ptL+EZ3q9dr
OXgDsvjWEn5wpd1quHgDChmND5bQOqCDQco9h0w52ymFrwN8vZLCFyjIhjy7tIgpj9WqXIvwfS4G
ANBAhhWNkZonZIp9yMkejsaCYi0AbxBceGJJvlwiaVlI+oImquN9mODYK0BePf/+1fOn6NXzJ8cP
nx0//On40aPjhz9aXs7CHRwHxYUvv/3sz68/Rn88/ebl4y/K8bKI//WHT375+fNyIFTQwsIXXz75
7dmTF199+vt3j0vgWwKPi/ARjYhEt8gR2ucR2GYc42pOxuJ8K0Yhps4KHALvEtZ9FTrAW3PMynBd
4jrvroDmUQa8Prvv6DoMxUzREsk3wsgB7nLOulyUOuCGllXw8GgWB+XCxayI28f4sEx2D8dOaPuz
BLpmlpSO73shcdTcYzhWOCAxUUg/4weElFh3j1LHr7vUF1zyqUL3KOpiWuqSER07ibRYtEMjiMu8
zGYIteOb3buoy1mZ1dvk0EVCQWBWovyIMMeN1/FM4aiM5QhHrOjwm1iFZUoO58Iv4vpSQaQDwjjq
T4iUZWtuC7C3EPQbGPpVadh32TxykULRgzKeNzHnReQ2P+iFOErKsEMah0XsB/IAUhSjPa7K4Lvc
rRB9D3HA8cpw36XECffpjeAODRyVFgmin8xESSyvE+7k73DOppiYLgMt3enUEY3/rm0zCn3bSnjX
tjveFmxiZcWzc6JZr8L9B1v0Np7FewSqYnmLeteh33Vo763v0Ktq+eL78qIVQ5fWA4mdtc3kHa0c
vKeUsaGaM3JTmtlbwgY0GQBRrzMHTJIfxJIQLnUlgwAHFwhs1iDB1UdUhcMQJzC3Vz3NJJAp60Ci
hEs4LxpyKW+Nh9lf2dNmU59DbOeQWO3yiSXXNTk7buRsjFaBOdNmguqawVmF1a+kTMG21xFW1Uqd
WVrVqGaaoiMtN1m72JzLweW5aUDMvQmTDYJ5CLzcgiO+Fg3nHczIRPvdxigLi4nCRYZIhnhC0hhp
u5djVDVBynJlyRBth00GfXY8xWsFaW3N9g2knSVIRXGNFeKy6L1JlLIMXkQJuJ0sRxYXi5PF6Kjj
tZu1pod8nHS8KRyV4TJKIOpSD5OYBfCSyVfCpv2pxWyqfBHNdmaYWwRVePth/b5ksNMHEiHVNpah
TQ3zKE0BFmtJVv9aE9x6UQaUdKOzaVFfh2T417QAP7qhJdMp8VUx2AWK9p29TVspnykihuHkCI3Z
TOxjCL9OVbBnQiW88TAdQd/A6zntbfPIbc5p0RVfihmcpWOWhDhtt7pEs0q2cNOQch3MXUE9sK1U
d2Pc+U0xJX9BphTT+H9mit5P4BVEfaIj4MO7XoGRrpSOx4UKOXShJKT+QMDgYHoHZAu84oXHkFTw
Ytr8CnKof23NWR6mrOEkqfZpgASF/UiFgpA9aEsm+05hVk33LsuSpYxMRhXUlYlVe0wOCRvpHtjS
e7uHQkh1003SNmBwJ/PPvU8raBzoIadYb04ny/deWwP/9ORjixmMcvuwGWgy/+cq5uPBYle1683y
bO8tGqIfLMasRlYVIKywFbTTsn9NFc651dqOtWRxrZkpB1FcthiI+UCUwIskpP/B/keFz+xHDL2h
jvg+9FYE3y80M0gbyOpLdvBAukFa4hgGJ0u0yaRZWdemo5P2WrZZX/Ckm8s94Wyt2VnifU5n58OZ
K86pxYt0duphx9eWttLVENmTJQqkaXaQMYEp+5i1ixM0DqodDz4oQaAfwBV8kvKAVtO0mqbBFXxn
gmHJfhzqeOlFRoHnlpJj6hmlnmEaGaWRUZoZBYaz9DNMRmlBp9JfTuDLnf7xUPaRBCa49KNK1lSd
L36bfwEAAP//AwBQSwMECgAAAAAAAAAhAHE5v0g7CAAAOwgAABoAAABjbGlwYm9hcmQvbWVkaWEv
aW1hZ2UxLnBuZ4lQTkcNChoKAAAADUlIRFIAAADRAAAAaggGAAAAIje0WQAAAAFzUkdCAK7OHOkA
AAAEZ0FNQQAAsY8L/GEFAAAACXBIWXMAABcRAAAXEQHKJvM/AAAH0ElEQVR4Xu2d4W3rOgyFM1cH
KpBtOkKn6DL52UFyrd46cB2JhzIVR1a+AsG7D7FrmTkfD0Up9enKDxEgAtUROJ/P1/Q6pZ/qszmB
CBCBH4DuIPr+/r7yIgZoQGvg8/OzDNH1moyJFzFAA5YGgIgkQaIMagCIggHEpXApIAIinCioASAK
BhAnwomACIhwoqAGgCgYQJwIJwIiIMKJghoAomAAcSKcCIiACCcKagCIggHEiXAiIAIinCioASAK
BhAnwomACIhwoqAGgCgYQJwIJwIiIMKJghoAomAAcSKcCIiACCcKagCIggHEiXCi14Locrq+TX+L
Jf09Fuv1MR3nhePjzfhd03sXIHXH0hvz3o57CYhMoVtAvWuYgEjHqDfRtx7P2BA5nUc505fhJkAE
RONC1AigGbASSEAERMNCtLmEK5V3hdIOiIBoTIi+dPNAlXC593NuBERANCRElw8BUaZr5nGu9wnO
9aQUiIBoSIi+ptJrSwtbnXfKlHRABERAtOy8qTKw1sFWx5eAq1mXWjqhcty3yZFVO9dKAtb55rWt
pQErxgddVxsSIiWuH5dyrAEpAab3PU4kHS6Np0JAntJz7cTFNr0laiNGagyl61mfjQd6z2ey9zFD
QnRVjlLowG1xBAXRu7WjYT0OBfbG+5qBKon03VhwzsLgWD7IzR9V0tkS/72ByV1vTIiUQzi2/nid
SmXk2i5gUUhBgCyQLKfMweBx+mpgK5y4B3CWYxgWonSTVoZ1i1t8uK0hyorPkfnd9zMlkDtQDUBz
43Hdcy5uldfpDZbSeIaGqBlIk/C2lCc1wr4dmxGfnFOtzqk93iyz1uOpAHoNq+Vg1taq3mEaHqKf
D6BRKZQrtTxZeXmeLIVqRVuYRymQtgpcjn9RKq9drBgrNRfsfCf8a0C0+BA8oi86SG2Lu+Bgagx/
srJIAMU5lHCMuzLNOH7pwmrsf2K3ilepvC65fO8ONI/v5SCq2nGQaUCsP3AlqlyZolxieU7Nset7
M+eEFQvHN+BKoE2wlLqQN8iNZHDkUi7F/OUhWgpPCTZlWXeJYqz9qOu4IYo0PTIQFUu13+uU3k8x
sd5LMS7e88FLuSEhUgJVpYNylnXrW60T5b7Zqsb4LIisRkwak7njwnCpFIPWuzV6KvWGcyI58RWZ
r/b8p0I0uZ1VCtWWc5ZjpOST/X0LNyyCMp2b/Vr+gdeGxl4ncnTiLDdSTrR3Oac6i80aC3PzpRC/
t8LOi2U8iiWd49yenKV2LMM5kXdtaOsiYlVjoZBpa8q5q1qXadTiXgqnZpH6D8RqrKtGzVG3+awh
GxIiJdJNi6CFRsGjyzlzUj6LcgWSvH9R0srz5+tuaPlbi8q1DtDL8UNCJLO3Z++co72tNlSWdmYr
kd7NcyozvEoS0gEcJXGuU5niIeeUv3FVDZ5eAPGMY0yIKj5MJTi1A3oPJ2q568IrXjU3THHJ/i4n
8EdfGxq7sbDYneDNigok63suu0HUYPuSFyCvo2z6C0gNv8vlcYk9jhnWiW7Bc2bGEkgqY+4K0W+C
8LiE+0t5pX1pKm7GvEolrxqY94Ageo3xIar5+veGev0ZEM0fuhJr9Jui1r2ZIAgAVWKKinrv818L
os53A+/94XM9/TcoPDECIsCSf8zEI6RXPgaIgAiIghoAomAAXzkDc+//y0EgAiKcKKgBIAoGkGzc
ZnJ+5DgCERDhREENAFEwgEfOoIy9jYsCERDhREENAFEwgGTzNtn8yHEEIiDCiYIaAKJgAI+cQRl7
GxcFIiDCiYIaAKJgAMnmbbL5keMIRECEEwU1AETBAB45gzL2Ni4KRECEEwU1AETBAJLN22TzI8cR
iIAIJwpqAIiCATxyBmXsbVwUiIAIJwpqAIiCASSbt8nmR44jEAERThTUABAFA3jkDMrY27goEBUg
qnm8SOTPECPkNkJ+ZhyBaAeIRnycyDNF29u1gWhPiIyHIfcmDMbjd0gg2huiAZ+K8OrAAdEzIJpA
kg/aouFxmK4hED0JougTG149+/d0/0C0ESILAvU4yZ9Gg3huak8iYSz2/AiIHgBREp18EFfhyeII
1j+h7yVWQPQgiKQbrSAyoSu4Vu0Dxmoe2lU6lrncPeRA9CCI5GLtCoxeIJLw06a/a3gA0QMgkgBN
QlzPqXqASJagv4/jZE73142AaCNEaquPen/93NJnQ6TGm3uf0o7nE5nrEB432SK8dE6us3dEiGjT
A9FzINrSJNhyTqb7V1WuLUu30r/pMPKkPKtF+ggnsjJ3L060LNEuH9N6lgUTEAHRXhB5yp4eIHr/
um/fKvdaz+16WbvZcxw0FvZoLDh2J/QAUQ4I1fIGIh58XJwXqXJu6S4qW88lkSW4p0NUKM2ASO+g
wIk2OlHVOs88rzDmEECkxbpniVZzLSBqBNH1MrWuHR2t0vxoC0SmW9Z253CizV+9AKJWEE2/R5U+
c1mXW6RUJeFdKTg1AWo7Z7V77VI2VvfEnIg5UZM50c36nW6U+xqEgujPOZ7r4ESbnaWmlEvH4kR8
g3Q3sdWK8yjHAxEQAVFQA0AUDOBRsiXjfFz3D4iACCcKagCIggEkwz8uwx8ltkAERDhRUANFiNIb
vIgBGvBp4Hw+X9NrWrs7neb/4b//g8KLGNRoAIiAhqQR1MAPRPwQASIQi8A/fIMQYfQtQqEAAAAA
SUVORK5CYIJQSwECLQAUAAYACAAAACEANBL/eBQBAABQAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0Nv
bnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAA
AEUBAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQBkiMsmvgEAAA0EAAAfAAAAAAAAAAAAAAAA
AC8CAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAFNSiWHS
AAAAqwEAACoAAAAAAAAAAAAAAAAAKgQAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5n
MS54bWwucmVsc1BLAQItABQABgAIAAAAIQD9wVrvzgYAAD0cAAAaAAAAAAAAAAAAAAAAAEQFAABj
bGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbFBLAQItAAoAAAAAAAAAIQBxOb9IOwgAADsIAAAaAAAA
AAAAAAAAAAAAAEoMAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLnBuZ1BLBQYAAAAABgAGAK8BAAC9
FAAAAAA=
" o:spid="_x0000_s1030"><v:imagedata o:title="" src="file:///C:\Users\Damian\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"></v:imagedata><?xml:namespace prefix = x ns = "urn:schemas-microsoft-com:eek:ffice:excel" /><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:Anchor>12, 0, 4, 18, 30, 78, 4, 85</x:Anchor> <x:AutoLine>False</x:AutoLine> <x:CF>Pict</x:CF> <x:AutoPict></x:AutoPict><x:MapOCX></x:MapOCX></x:ClientData></v:shape>AC</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=86>AE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 125pt; HEIGHT: 99.95pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=133 width=166><v:shape style="Z-INDEX: 6; POSITION: absolute; MARGIN-TOP: 9.75pt; WIDTH: 36pt; HEIGHT: 34.5pt; VISIBILITY: hidden; MARGIN-LEFT: 0px" id=Button2 type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAa++7zrsBAAAMBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysU9tu2zAM
fR/QfxD0vjrxks0w6hRbbxhQrMEuH8DKtC1MN0iKl/79qFhJgzy0w7Y3UaQOj84hLy63WrERfZDW
NHx+PuMMjbCtNH3Df3y/fVtxFiKYFpQ12PAnDPxydfbmAuregxukYIRgQg0NH2J0dVEEMaCGcG4d
Gsp11muIFPq+aD38ImStinI2e19okIavnqGuIQLbePkXUMqKn9hegRkhEKQS9fFN5qjEvyNDbcY7
7765tU/MxZdx7ZlsG07KGdAkES9yIpdRWJy86p8Btp3Xqd52HduSA/OynC2WBPbU8KpaVuVywsNt
ZIIKFssPpB1ngvKLd9WcSqd+w8MrCGK4eRGDSE5k6HBE0EmR+JlxLcXpn8v9nz9tYrSGwkG2LaZJ
OqhweEZA9+RSYMZeDWB6/BgciphrqWnScuqx0+vw8FFJdyuVSjTSObvp/8RMklUKvLZio9HEaew8
Kog072GQLnDma9SPSA76z22mHaLHKIbUsKPGX4nm5OIhQQyPaYU8Dv/HTQLfAzkf4h1azdKBKBKT
3cbAeB8yp33JbswmIgRAatPFyR7sSvLepmU7jle/AQAA//8DAFBLAwQUAAYACAAAACEAU1KJYdIA
AACrAQAAKgAAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQwUoE
MQyG74LvUHK3mdmDiGxnLyLsVdYHCG2mU5ympa3ivr3VvTiw4MVLIAn58vHvD59xVR9cakhiYNQD
KBabXBBv4PX0fPcAqjYSR2sSNnDmCofp9mb/wiu1flSXkKvqFKkGltbyI2K1C0eqOmWWvplTidR6
Wzxmsm/kGXfDcI/lNwOmDVMdnYFydDtQp3Pun/9mp3kOlp+SfY8s7coLbN2LO5CK52ZA68vkUkfd
XQGva4z/qRFij2CjEdkFwp/5qLP4bw3cRDx9AQAA//8DAFBLAwQUAAYACAAAACEA/cFa784GAAA9
HAAAGgAAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1s7FlPbxtFFL8j8R1Ge2/j/42jOlXs2A20
aaPYLepxvB7vTjO7s5oZJ/UNtUckJERBXJC4cUBApVbiUj5NoAiK1K/Am5nd9U68JkkbgSjNId59
+5v3/715s3v12oOIoUMiJOVxx6terniIxD6f0DjoeHdGg0vrHpIKxxPMeEw63pxI79rm++9dxRs+
o8mYYzEZhSQiCBjFcgN3vFCpZGNtTfpAxvIyT0gMz6ZcRFjBrQjWJgIfgYCIrdUqldZahGnsbQJH
pRn1GfyLldQEn4mhZkNQjCOQfns6pT4x2MlBVSPkXPaYQIeYdTzgOeFHI/JAeYhhqeBBx6uYP29t
8+oa3kgXMbVibWHdwPyl69IFk4OakSmCcS60Omi0r2zn/A2AqWVcv9/v9as5PwPAvg+WWl2KPBuD
9Wo341kA2ctl3r1Ks9Jw8QX+9SWd291ut9lOdbFMDcheNpbw65VWY6vm4A3I4ptL+EZ3q9drOXgD
svjWEn5wpd1quHgDChmND5bQOqCDQco9h0w52ymFrwN8vZLCFyjIhjy7tIgpj9WqXIvwfS4GANBA
hhWNkZonZIp9yMkejsaCYi0AbxBceGJJvlwiaVlI+oImquN9mODYK0BePf/+1fOn6NXzJ8cPnx0/
/On40aPjhz9aXs7CHRwHxYUvv/3sz68/Rn88/ebl4y/K8bKI//WHT375+fNyIFTQwsIXXz757dmT
F199+vt3j0vgWwKPi/ARjYhEt8gR2ucR2GYc42pOxuJ8K0Yhps4KHALvEtZ9FTrAW3PMynBd4jrv
roDmUQa8Prvv6DoMxUzREsk3wsgB7nLOulyUOuCGllXw8GgWB+XCxayI28f4sEx2D8dOaPuzBLpm
lpSO73shcdTcYzhWOCAxUUg/4weElFh3j1LHr7vUF1zyqUL3KOpiWuqSER07ibRYtEMjiMu8zGYI
teOb3buoy1mZ1dvk0EVCQWBWovyIMMeN1/FM4aiM5QhHrOjwm1iFZUoO58Iv4vpSQaQDwjjqT4iU
ZWtuC7C3EPQbGPpVadh32TxykULRgzKeNzHnReQ2P+iFOErKsEMah0XsB/IAUhSjPa7K4LvcrRB9
D3HA8cpw36XECffpjeAODRyVFgmin8xESSyvE+7k73DOppiYLgMt3enUEY3/rm0zCn3bSnjXtjve
FmxiZcWzc6JZr8L9B1v0Np7FewSqYnmLeteh33Vo763v0Ktq+eL78qIVQ5fWA4mdtc3kHa0cvKeU
saGaM3JTmtlbwgY0GQBRrzMHTJIfxJIQLnUlgwAHFwhs1iDB1UdUhcMQJzC3Vz3NJJAp60CihEs4
LxpyKW+Nh9lf2dNmU59DbOeQWO3yiSXXNTk7buRsjFaBOdNmguqawVmF1a+kTMG21xFW1UqdWVrV
qGaaoiMtN1m72JzLweW5aUDMvQmTDYJ5CLzcgiO+Fg3nHczIRPvdxigLi4nCRYZIhnhC0hhpu5dj
VDVBynJlyRBth00GfXY8xWsFaW3N9g2knSVIRXGNFeKy6L1JlLIMXkQJuJ0sRxYXi5PF6KjjtZu1
pod8nHS8KRyV4TJKIOpSD5OYBfCSyVfCpv2pxWyqfBHNdmaYWwRVePth/b5ksNMHEiHVNpahTQ3z
KE0BFmtJVv9aE9x6UQaUdKOzaVFfh2T417QAP7qhJdMp8VUx2AWK9p29TVspnykihuHkCI3ZTOxj
CL9OVbBnQiW88TAdQd/A6zntbfPIbc5p0RVfihmcpWOWhDhtt7pEs0q2cNOQch3MXUE9sK1Ud2Pc
+U0xJX9BphTT+H9mit5P4BVEfaIj4MO7XoGRrpSOx4UKOXShJKT+QMDgYHoHZAu84oXHkFTwYtr8
CnKof23NWR6mrOEkqfZpgASF/UiFgpA9aEsm+05hVk33LsuSpYxMRhXUlYlVe0wOCRvpHtjSe7uH
Qkh1003SNmBwJ/PPvU8raBzoIadYb04ny/deWwP/9ORjixmMcvuwGWgy/+cq5uPBYle1683ybO8t
GqIfLMasRlYVIKywFbTTsn9NFc651dqOtWRxrZkpB1FcthiI+UCUwIskpP/B/keFz+xHDL2hjvg+
9FYE3y80M0gbyOpLdvBAukFa4hgGJ0u0yaRZWdemo5P2WrZZX/Ckm8s94Wyt2VnifU5n58OZK86p
xYt0duphx9eWttLVENmTJQqkaXaQMYEp+5i1ixM0DqodDz4oQaAfwBV8kvKAVtO0mqbBFXxngmHJ
fhzqeOlFRoHnlpJj6hmlnmEaGaWRUZoZBYaz9DNMRmlBp9JfTuDLnf7xUPaRBCa49KNK1lSdL36b
fwEAAP//AwBQSwMECgAAAAAAAAAhAIuk+TEnAwAAJwMAABoAAABjbGlwYm9hcmQvbWVkaWEvaW1h
Z2UxLnBuZ4lQTkcNChoKAAAADUlIRFIAAABMAAAASQgGAAAAl1rAmAAAAAFzUkdCAK7OHOkAAAAE
Z0FNQQAAsY8L/GEFAAAACXBIWXMAABcRAAAXEQHKJvM/AAACvElEQVR4Xu2cPY7CMBSE9yKcgJKO
E1BwBGokJMQZtqXjCDRcgZp7UHIQb5KF3TiJ3zzjH5xokKzVKiYhX2bGz7aUL8MPJLDb7UzdvuoP
7M0ODawesMfjYdj6DM7nsxuYuX0bNpsBgXmKgsAILG2MUGFUGBVW1EhNS9KStCQtOebZAzOMGcYM
Y4YxwzxzgMAIzDSrrWNWQqrfzrLC0x1pgF1WZlntp9R7Ku42M6dL2hIghcoiAjuY0xxBchxfb0Zj
/zjAVIpCMBfm6mmPFApC5wwHFgXWC2b50AKBBdjQlW+F2zMM2HEBgh3ZcOh42SoLAnbfz2Rg85W5
W7mkU+T2WO7oGQTsun6vbJC/V52zYFt+BJhBVu4p0604pPLl/qAuWdrnco2WQcDQj22K1iRq0Vnb
LppxNiYHBpUyOBIGVvhInWCGISkuPbDbO0+6k3s+CgyE9VKcC1oGYHW2bMwWzhsV5QXKragF8rDK
MwGLCK0C7yop4MjaAe7bvw75jMCeo1gUyww8faQuh619y578wP6K1MBs69pTfBDCIAJAd7Psg8C6
dZM/wLY1ZaVI5QLI144yCwJmA4T5UmVZ++mL/cXBAjyonMDQTcvzQYXiWjczCWCwygf1lc/3p2FJ
xYjoVhlWmBXI0wh9XcHar6oxrLoit2BPpaxAOSbvGgnV/0CQw2t1IsC3f57CFT35N6dMg1aOeq0P
To1geHtCE9evFLmpUbUrW7PVYbGgqRb7AqFJ5U42YM3qZJBl8OKevQKqGzjKW0B0bbwqVRBjswOp
W6Xa533kVdgIdq3RrrbmeNCavuYCU+tDYJ7OIDACS7trToVRYVSYeqs/x4hMS9KStCQtmSNrUl2D
GcYMY4Yxw1LlS47zMsOYYcywcWRY7VW2YQbWOxBf//Dv74shpda8ZRN14vF/iA0wfvwI/AASaA2T
EflzGAAAAABJRU5ErkJgglBLAQItABQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAAAAAAAAAAAAA
AAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAAMgEAAAsAAAAA
AAAAAAAAAAAARQEAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAGvvu867AQAADAQAAB8AAAAA
AAAAAAAAAAAALwIAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwECLQAUAAYACAAA
ACEAU1KJYdIAAACrAQAAKgAAAAAAAAAAAAAAAAAnBAAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxz
L2RyYXdpbmcxLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAP3BWu/OBgAAPRwAABoAAAAAAAAAAAAA
AAAAQQUAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0ACgAAAAAAAAAhAIuk+TEnAwAA
JwMAABoAAAAAAAAAAAAAAAAARwwAAGNsaXBib2FyZC9tZWRpYS9pbWFnZTEucG5nUEsFBgAAAAAG
AAYArwEAAKYPAAAAAA==
" o:spid="_x0000_s1033"><v:imagedata o:title="" src="file:///C:\Users\Damian\AppData\Local\Temp\msohtmlclip1\01\clip_image002.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:Anchor>31, 0, 4, 13, 33, 48, 4, 59</x:Anchor> <x:AutoLine>False</x:AutoLine> <x:CF>Pict</x:CF> <x:AutoPict></x:AutoPict><x:MapOCX></x:MapOCX></x:ClientData></v:shape><v:shape style="Z-INDEX: 4; POSITION: absolute; MARGIN-TOP: 9.75pt; WIDTH: 78.75pt; HEIGHT: 39pt; VISIBILITY: hidden; MARGIN-LEFT: 55.5pt" id=Button1 type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAgpB7orsBAAAPBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysk9tOGzEQ
hu8r9R0s35fdpKQKKzaIQkGVUIna8gCDd3bXqk+ynW14+453nRDlolSFOx9+f/N7DucXW63YgD5I
a2o+Oyk5QyNsI01X84efNx+WnIUIpgFlDdb8CQO/WL1/dw5V58H1UjAimFBBzfsYXVUUQfSoIZxY
h4buWus1RNr6rmg8/CayVsW8LD8VGqThq2fUNURgGy//A6Ws+IXNFZgBAiGVqA5PskclXk+Gygy3
3v1wa5+ci2/D2jPZ1JwyZ0BTiniRL7KMtsXRq+4ZsG29TnrbtmxLFZidzRcfS4I91Xy5XCzni4mH
28hEEpRlOaNDJkhwejZqp4D9/QsI0X/5O4RsTnZocWDRSZEcmmEtxfGv57tff97EaM2Ms142DaZe
2udh/4xAd1SnwIy96sF0eBkcipi1FDRlc4oxZmz/8FFJdyOVSjbSOtfT/0s5KbFS4LUVG40mTo3n
UUGkjg+9dIEzX6F+RKqh/9pk2yF6jKJPAVsK/J1sTnXcX5DDQ1shN8Qb1ZPoO5LzId6i1SwtyCNZ
GYcGhruQTe0kY6dNTghA6aaDo1EYJXl007wd7ld/AAAA//8DAFBLAwQUAAYACAAAACEAU1KJYdIA
AACrAQAAKgAAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQwUoE
MQyG74LvUHK3mdmDiGxnLyLsVdYHCG2mU5ympa3ivr3VvTiw4MVLIAn58vHvD59xVR9cakhiYNQD
KBabXBBv4PX0fPcAqjYSR2sSNnDmCofp9mb/wiu1flSXkKvqFKkGltbyI2K1C0eqOmWWvplTidR6
Wzxmsm/kGXfDcI/lNwOmDVMdnYFydDtQp3Pun/9mp3kOlp+SfY8s7coLbN2LO5CK52ZA68vkUkfd
XQGva4z/qRFij2CjEdkFwp/5qLP4bw3cRDx9AQAA//8DAFBLAwQUAAYACAAAACEA/cFa784GAAA9
HAAAGgAAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1s7FlPbxtFFL8j8R1Ge2/j/42jOlXs2A20
aaPYLepxvB7vTjO7s5oZJ/UNtUckJERBXJC4cUBApVbiUj5NoAiK1K/Am5nd9U68JkkbgSjNId59
+5v3/715s3v12oOIoUMiJOVxx6terniIxD6f0DjoeHdGg0vrHpIKxxPMeEw63pxI79rm++9dxRs+
o8mYYzEZhSQiCBjFcgN3vFCpZGNtTfpAxvIyT0gMz6ZcRFjBrQjWJgIfgYCIrdUqldZahGnsbQJH
pRn1GfyLldQEn4mhZkNQjCOQfns6pT4x2MlBVSPkXPaYQIeYdTzgOeFHI/JAeYhhqeBBx6uYP29t
8+oa3kgXMbVibWHdwPyl69IFk4OakSmCcS60Omi0r2zn/A2AqWVcv9/v9as5PwPAvg+WWl2KPBuD
9Wo341kA2ctl3r1Ks9Jw8QX+9SWd291ut9lOdbFMDcheNpbw65VWY6vm4A3I4ptL+EZ3q9drOXgD
svjWEn5wpd1quHgDChmND5bQOqCDQco9h0w52ymFrwN8vZLCFyjIhjy7tIgpj9WqXIvwfS4GANBA
hhWNkZonZIp9yMkejsaCYi0AbxBceGJJvlwiaVlI+oImquN9mODYK0BePf/+1fOn6NXzJ8cPnx0/
/On40aPjhz9aXs7CHRwHxYUvv/3sz68/Rn88/ebl4y/K8bKI//WHT375+fNyIFTQwsIXXz757dmT
F199+vt3j0vgWwKPi/ARjYhEt8gR2ucR2GYc42pOxuJ8K0Yhps4KHALvEtZ9FTrAW3PMynBd4jrv
roDmUQa8Prvv6DoMxUzREsk3wsgB7nLOulyUOuCGllXw8GgWB+XCxayI28f4sEx2D8dOaPuzBLpm
lpSO73shcdTcYzhWOCAxUUg/4weElFh3j1LHr7vUF1zyqUL3KOpiWuqSER07ibRYtEMjiMu8zGYI
teOb3buoy1mZ1dvk0EVCQWBWovyIMMeN1/FM4aiM5QhHrOjwm1iFZUoO58Iv4vpSQaQDwjjqT4iU
ZWtuC7C3EPQbGPpVadh32TxykULRgzKeNzHnReQ2P+iFOErKsEMah0XsB/IAUhSjPa7K4LvcrRB9
D3HA8cpw36XECffpjeAODRyVFgmin8xESSyvE+7k73DOppiYLgMt3enUEY3/rm0zCn3bSnjXtjve
FmxiZcWzc6JZr8L9B1v0Np7FewSqYnmLeteh33Vo763v0Ktq+eL78qIVQ5fWA4mdtc3kHa0cvKeU
saGaM3JTmtlbwgY0GQBRrzMHTJIfxJIQLnUlgwAHFwhs1iDB1UdUhcMQJzC3Vz3NJJAp60CihEs4
LxpyKW+Nh9lf2dNmU59DbOeQWO3yiSXXNTk7buRsjFaBOdNmguqawVmF1a+kTMG21xFW1UqdWVrV
qGaaoiMtN1m72JzLweW5aUDMvQmTDYJ5CLzcgiO+Fg3nHczIRPvdxigLi4nCRYZIhnhC0hhpu5dj
VDVBynJlyRBth00GfXY8xWsFaW3N9g2knSVIRXGNFeKy6L1JlLIMXkQJuJ0sRxYXi5PF6KjjtZu1
pod8nHS8KRyV4TJKIOpSD5OYBfCSyVfCpv2pxWyqfBHNdmaYWwRVePth/b5ksNMHEiHVNpahTQ3z
KE0BFmtJVv9aE9x6UQaUdKOzaVFfh2T417QAP7qhJdMp8VUx2AWK9p29TVspnykihuHkCI3ZTOxj
CL9OVbBnQiW88TAdQd/A6zntbfPIbc5p0RVfihmcpWOWhDhtt7pEs0q2cNOQch3MXUE9sK1Ud2Pc
+U0xJX9BphTT+H9mit5P4BVEfaIj4MO7XoGRrpSOx4UKOXShJKT+QMDgYHoHZAu84oXHkFTwYtr8
CnKof23NWR6mrOEkqfZpgASF/UiFgpA9aEsm+05hVk33LsuSpYxMRhXUlYlVe0wOCRvpHtjSe7uH
Qkh1003SNmBwJ/PPvU8raBzoIadYb04ny/deWwP/9ORjixmMcvuwGWgy/+cq5uPBYle1683ybO8t
GqIfLMasRlYVIKywFbTTsn9NFc651dqOtWRxrZkpB1FcthiI+UCUwIskpP/B/keFz+xHDL2hjvg+
9FYE3y80M0gbyOpLdvBAukFa4hgGJ0u0yaRZWdemo5P2WrZZX/Ckm8s94Wyt2VnifU5n58OZK86p
xYt0duphx9eWttLVENmTJQqkaXaQMYEp+5i1ixM0DqodDz4oQaAfwBV8kvKAVtO0mqbBFXxngmHJ
fhzqeOlFRoHnlpJj6hmlnmEaGaWRUZoZBYaz9DNMRmlBp9JfTuDLnf7xUPaRBCa49KNK1lSdL36b
fwEAAP//AwBQSwMECgAAAAAAAAAhALB3/zEYBgAAGAYAABoAAABjbGlwYm9hcmQvbWVkaWEvaW1h
Z2UxLnBuZ4lQTkcNChoKAAAADUlIRFIAAAClAAAAUwgGAAAA/uDH3gAAAAFzUkdCAK7OHOkAAAAE
Z0FNQQAAsY8L/GEFAAAACXBIWXMAABcRAAAXEQHKJvM/AAAFrUlEQVR4Xu2cwVHzMBCF3QhVcEsF
FME5M7lQAyWkBKpIMzlSiLATDLYj6e2uJVmOHjOZf/4hsVert9+TVg6d4w8zUEEGTqeTG17d8FNB
PAyBGbgJ8kGU39/fji/mYAsNfH19hUXpPvuS5Ys5KKwBirJwwlnkGHQUJUVZnRNQlBQlRUn7wvbV
eo5ISpKSpGydAhw/dgqSkqQkKUkKTIrWc0RSkpQkZesU4PixU5CUJCVJSVJgUrSeI5KSpCQpW6cA
x4+dgqQkKUlKkgKTovUckZQkJUnZOgU4fuwUJCVJSVKSFJgUredoA1Je3LH/Ju/wbd7Q6/B2ra56
WxfKuvHf5/z4LivI8qJ8P0YF2XUHd/6QBb8uUbxH9vzN5vroLsKlUnFRXl7jlOxezu4qDD57UhmH
ybG8c/x6EV+rsChp3c9bSPG5lVr3kJ+yoqR1i2mxN/HGHVBu3cVFSet+1nUscECFdRcWJa17b/QT
xwscUGPdZUVpse6PszsEW0dTS7i680toAxXazUeKJLbZEscUvr655QVz2OdAulEUjiO4aZHE4p07
3F0ptqa0WPf17RBuH/1aArzuLTHTRMQEPBW2fx2EYxJeXyqefuEvG+OiKIFlwnHERNvHfkZdlBBM
BOMuJEqLdccn9/gWo6iHmsMkKav7kWhpY0LEjAoHHEDcDiaCwlwzjqFY8XyuORgpI0ooBg/So/YC
ep2SCZO8ZzmpqWOKUMNER8+YvOu5FeO4XQ/Op3YpNd8AFhElTLBnclZTQiI69J6FKNPH5FsiCO0f
xT7+3kNL6zhGssP5XGHdhTY6GPVam4ydm6f83TwuuVjudMLj9h2pwglfFLD2/e5TPo5ZLv/ELRmX
n5RouTLu9vOTEqLeQwuBvVgEM7cynNzZ+wUxPVolusd87Ihg/taK7h5OMI6ukzW7UzbMp+2n7KKE
lWywF1/Fofs8Tigihk4wIQqIJw6IJUwZMI4FWZHwpYKETqBsmBcUJapi3+NMuiTfB2P5jOYUwnJ9
XVxi8T48JAJim4kDFaL88TK02dE2zMuJMoN1e4kBKONNkOYUwkyxuPD/xmK+Pl67zvKFrFvQQxzF
Yy8ifNSa1b6Rpfr6aHF78Z8GxD/jXx9pkmqJ6TZ5UeH/j8V8fcU9hniQdcvpJiw246N/GUVZiXV7
1zY7su4ovTTLCs17Ac2ExSY+O1+IN58oG7Hu4KmJeHmgWRMuxCK+R/+5VUuE+X2jLqNYAoREm02U
bVj30I+ztLSmnwHUDk6yhvbIuvFDEv8C0t3XQstMomzEuseTi4lw0LptaEiv6pcOVoc2LA+FUsq6
OydtkMfEmkeUGazbcoabe9dtOj3yrHGhq0iPFB+eiPq13YTWLSm6v7wYrTyLKGGS1Q1zw2NkgVOJ
dLtuw0MhoUmCRSy9l6U7obFu5WN0xgZ6BlFmsG7v4CwbBM16CDeaVaRcs4uWkDJ4/YTWrXy202rl
6UUJq16/MajRug+vx8hT8XOyySYHF3OoCKL9xYTWLel1/seoI3DWE502rHtMuHXnHOkDwqIeBS+b
9FWNeW/zW+ogsoc6fBue9KQ0dvEtrYN8n0lrefnixEd2e7w3RekrosSWt0dhbBkzRekRZXrLe06i
5RIuRal9FMzYe8s1gc94XYpyKUpa9+Z/WoaiXIiS1r39UoOinImSu+4algMU5VSUtO7NrbvQV2y3
t4Maqp8xyHVAUj5Fs18+4XsoDoqSoqzCsrOefe+hEhlj3WQlKUlKkpKUqptSNcwPSUlSkpQ1VCJj
qJvWJCVJSVKSUnVTqob5ISlJSpKyhkpkDHXTmqQkKUlKUqpuStUwPyQlSUlS1lCJjKFuWpOUJCVJ
SUrVTaka5oekJClJyhoqkTHUTesgKYdf8MUcbKWB0+nkhlf/V9y6bvwP/70nha9tc0BRUoTVFeFN
lPxhBmrLwA/abSF8qwHFuwAAAABJRU5ErkJgglBLAQItABQABgAIAAAAIQA0Ev94FAEAAFACAAAT
AAAAAAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HB
AAAAMgEAAAsAAAAAAAAAAAAAAAAARQEAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAIKQe6K7
AQAADwQAAB8AAAAAAAAAAAAAAAAALwIAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQ
SwECLQAUAAYACAAAACEAU1KJYdIAAACrAQAAKgAAAAAAAAAAAAAAAAAnBAAAY2xpcGJvYXJkL2Ry
YXdpbmdzL19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAP3BWu/OBgAAPRwA
ABoAAAAAAAAAAAAAAAAAQQUAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0ACgAAAAAA
AAAhALB3/zEYBgAAGAYAABoAAAAAAAAAAAAAAAAARwwAAGNsaXBib2FyZC9tZWRpYS9pbWFnZTEu
cG5nUEsFBgAAAAAGAAYArwEAAJcSAAAAAA==
" o:spid="_x0000_s1025"><v:imagedata o:title="" src="file:///C:\Users\Damian\AppData\Local\Temp\msohtmlclip1\01\clip_image003.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:AutoLine>False</x:AutoLine> <x:CF>Pict</x:CF> <x:AutoPict></x:AutoPict><x:MapOCX></x:MapOCX></x:ClientData></v:shape><v:shape style="Z-INDEX: 7; POSITION: absolute; MARGIN-TOP: 15pt; WIDTH: 78.75pt; HEIGHT: 52.5pt; VISIBILITY: hidden; MARGIN-LEFT: 124.5pt" id=CommandButton1 type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAingV5sIBAAATBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysk0tu2zAQ
hvcFcgeC+0ayA6uxEDlonSYoEDRG0h6AoUYiUb5A0qpz+w4l2jG8aIq2uyFn+M/HeVxd77QiA/gg
rWno7LykBAy3rTR9Q79/u31/SUmIzLRMWQMNfYFAr1dn765Y3XvmhOQEFUyoWUNFjK4uisAFaBbO
rQODvs56zSIefV+0nv1EZa2KeVlWhWbS0NWr1A2LjGy9/AspZfkPaNfMDCygpOL18U1mVPzflVlt
hjvvntzGJ3L+ddh4ItuGYuUM01giWmRHDsNjcfKqfxXYdV6neNt1ZIcdmF+Ws6pEsZeGLhfzBZqj
Huwi4RiwXC4uqgtKOPqrqvqwyH4uHt5Q4OLzbzUQcoJB4wjQSZ74zLCR/PTP8/2f11ZrHJJP2xit
mVEiZNtCGqhDMQ6vUe8emxWIsWvBTA8fgwMecyzmTiWdUo1lOzx8VtLdSqUSTbJzU/2f9BSrKznc
WL7VYOI0fR4Uizj2QUgXKPE16GfARvovbcYO0UPkIiXsMPEjYk7NPDiQ8Bgr5Kn4P01F8b2Q8yHe
gdUkGYiIJOPisOE+ZKZ9yDhtEwgKYLXx4mQdxpC8vmnnjs+rXwAAAP//AwBQSwMEFAAGAAgAAAAh
AFNSiWHSAAAAqwEAACoAAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJl
bHOskMFKBDEMhu+C71Byt5nZg4hsZy8i7FXWBwhtplOcpqWt4r691b04sODFSyAJ+fLx7w+fcVUf
XGpIYmDUAygWm1wQb+D19Hz3AKo2EkdrEjZw5gqH6fZm/8IrtX5Ul5Cr6hSpBpbW8iNitQtHqjpl
lr6ZU4nUels8ZrJv5Bl3w3CP5TcDpg1THZ2BcnQ7UKdz7p//Zqd5Dpafkn2PLO3KC2zdizuQiudm
QOvL5FJH3V0Br2uM/6kRYo9goxHZBcKf+aiz+G8N3EQ8fQEAAP//AwBQSwMEFAAGAAgAAAAhAP3B
Wu/OBgAAPRwAABoAAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbOxZT28bRRS/I/EdRntv4/+N
ozpV7NgNtGmj2C3qcbwe704zu7OaGSf1DbVHJCREQVyQuHFAQKVW4lI+TaAIitSvwJuZ3fVOvCZJ
G4EozSHeffub9/+9ebN79dqDiKFDIiTlccerXq54iMQ+n9A46Hh3RoNL6x6SCscTzHhMOt6cSO/a
5vvvXcUbPqPJmGMxGYUkIggYxXIDd7xQqWRjbU36QMbyMk9IDM+mXERYwa0I1iYCH4GAiK3VKpXW
WoRp7G0CR6UZ9Rn8i5XUBJ+JoWZDUIwjkH57OqU+MdjJQVUj5Fz2mECHmHU84DnhRyPyQHmIYang
QcermD9vbfPqGt5IFzG1Ym1h3cD8pevSBZODmpEpgnEutDpotK9s5/wNgKllXL/f7/WrOT8DwL4P
llpdijwbg/VqN+NZANnLZd69SrPScPEF/vUlndvdbrfZTnWxTA3IXjaW8OuVVmOr5uANyOKbS/hG
d6vXazl4A7L41hJ+cKXdarh4AwoZjQ+W0Dqgg0HKPYdMOdspha8DfL2SwhcoyIY8u7SIKY/VqlyL
8H0uBgDQQIYVjZGaJ2SKfcjJHo7GgmItAG8QXHhiSb5cImlZSPqCJqrjfZjg2CtAXj3//tXzp+jV
8yfHD58dP/zp+NGj44c/Wl7Owh0cB8WFL7/97M+vP0Z/PP3m5eMvyvGyiP/1h09++fnzciBU0MLC
F18++e3Zkxdfffr7d49L4FsCj4vwEY2IRLfIEdrnEdhmHONqTsbifCtGIabOChwC7xLWfRU6wFtz
zMpwXeI6766A5lEGvD677+g6DMVM0RLJN8LIAe5yzrpclDrghpZV8PBoFgflwsWsiNvH+LBMdg/H
Tmj7swS6ZpaUju97IXHU3GM4VjggMVFIP+MHhJRYd49Sx6+71Bdc8qlC9yjqYlrqkhEdO4m0WLRD
I4jLvMxmCLXjm927qMtZmdXb5NBFQkFgVqL8iDDHjdfxTOGojOUIR6zo8JtYhWVKDufCL+L6UkGk
A8I46k+IlGVrbguwtxD0Gxj6VWnYd9k8cpFC0YMynjcx50XkNj/ohThKyrBDGodF7AfyAFIUoz2u
yuC73K0QfQ9xwPHKcN+lxAn36Y3gDg0clRYJop/MREksrxPu5O9wzqaYmC4DLd3p1BGN/65tMwp9
20p417Y73hZsYmXFs3OiWa/C/Qdb9DaexXsEqmJ5i3rXod91aO+t79Cravni+/KiFUOX1gOJnbXN
5B2tHLynlLGhmjNyU5rZW8IGNBkAUa8zB0ySH8SSEC51JYMABxcIbNYgwdVHVIXDECcwt1c9zSSQ
KetAooRLOC8acilvjYfZX9nTZlOfQ2znkFjt8okl1zU5O27kbIxWgTnTZoLqmsFZhdWvpEzBttcR
VtVKnVla1ahmmqIjLTdZu9icy8HluWlAzL0Jkw2CeQi83IIjvhYN5x3MyET73cYoC4uJwkWGSIZ4
QtIYabuXY1Q1QcpyZckQbYdNBn12PMVrBWltzfYNpJ0lSEVxjRXisui9SZSyDF5ECbidLEcWF4uT
xeio47WbtaaHfJx0vCkcleEySiDqUg+TmAXwkslXwqb9qcVsqnwRzXZmmFsEVXj7Yf2+ZLDTBxIh
1TaWoU0N8yhNARZrSVb/WhPcelEGlHSjs2lRX4dk+Ne0AD+6oSXTKfFVMdgFivadvU1bKZ8pIobh
5AiN2UzsYwi/TlWwZ0IlvPEwHUHfwOs57W3zyG3OadEVX4oZnKVjloQ4bbe6RLNKtnDTkHIdzF1B
PbCtVHdj3PlNMSV/QaYU0/h/ZoreT+AVRH2iI+DDu16Bka6UjseFCjl0oSSk/kDA4GB6B2QLvOKF
x5BU8GLa/ApyqH9tzVkepqzhJKn2aYAEhf1IhYKQPWhLJvtOYVZN9y7LkqWMTEYV1JWJVXtMDgkb
6R7Y0nu7h0JIddNN0jZgcCfzz71PK2gc6CGnWG9OJ8v3XlsD//TkY4sZjHL7sBloMv/nKubjwWJX
tevN8mzvLRqiHyzGrEZWFSCssBW007J/TRXOudXajrVkca2ZKQdRXLYYiPlAlMCLJKT/wf5Hhc/s
Rwy9oY74PvRWBN8vNDNIG8jqS3bwQLpBWuIYBidLtMmkWVnXpqOT9lq2WV/wpJvLPeFsrdlZ4n1O
Z+fDmSvOqcWLdHbqYcfXlrbS1RDZkyUKpGl2kDGBKfuYtYsTNA6qHQ8+KEGgH8AVfJLygFbTtJqm
wRV8Z4JhyX4c6njpRUaB55aSY+oZpZ5hGhmlkVGaGQWGs/QzTEZpQafSX07gy53+8VD2kQQmuPSj
StZUnS9+m38BAAD//wMAUEsDBAoAAAAAAAAAIQC9XbNS7AcAAOwHAAAaAAAAY2xpcGJvYXJkL21l
ZGlhL2ltYWdlMS5wbmeJUE5HDQoaCgAAAA1JSERSAAAApQAAAG8IBgAAAI1YAAgAAAABc1JHQgCu
zhzpAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAXEQAAFxEByibzPwAAB4FJREFUeF7tnW1uGz0M
hH2uHqiAb9Mj5BS9TH/mIG6UZgFBlTSkPriT3YlhFC9WWlLko6Ek+10/XvpTBAgi8Hw+X+n9SH8E
/sgFReATyP+gfH9/f+mtGJzBwNvbWxvKx0svRSA+AoJSE48uAoKSLiXxysRmUVAKSroICEq6lLDp
Vrw/glJQ0kVAUNKlJF6Z2CwKSkFJFwFBSZcSNt2K90dQCkq6CAhKupTEKxObRUEpKOkiICjpUsKm
W/H+CEpBSRcBQUmXknhlYrMoKAUlXQQEJV1K2HQr3h9BKSjpIiAo6VISr0xsFgWloKSLgKCkSwmb
bsX7c28o/3wE/OP/KobvnwGJSTZ6vqyYPBE2Fvh5byh/GIBMoERA2QNylf0IG4JyQsF+GYGMgPI3
8CVdn31F2Jj18av/PZXSWrYPZVmlVK2kRZTVCBuCckI7LOvIvE0q8ztfEWU1wsaiGN1PKZFi1JK3
E8qIshphYxGQafLfC0qUnJaa7IQSTZIVyY6wscLPW64pUQlbCWVv3Zo2WccL+dRLdoSNhbBZl0D3
Ucre8U+CpLcb9yildROV7omUO92r9oqwcQKMx1jvAaUFOHREZEkSuodng9WaCBE2LGPd2Ob6UCJV
OdRodt21EpYEb17iDwAibGyETeXbsmbLEz8D5WpYEpRl6Y6wQQDk9XffPdDK8jgKJVLio2QnqKwf
a5a+RdggAfLaUKJNRPnRHYKytelAoJV2LICVpTvChqC0ri4m2nmPWkagRODX1oUp+QiyfAJE2CAC
8rpKiZJeS8IIlJ7lQW6z559nWdE7qvLYEJQT6mcJHtoQtL5xg0Auyzcqwy2VTGPoqXjeL8KGJabB
ba51JISS6DknLNuWMCP4W4lE5TiHP8JGMHAWSboWlEjtVkKp0r0N5+tAidaEM0CmvqVSejdSKYVI
JcuSH2FjG1oWTay3uQaUKNmzQHqhrG1ALEuLct3a83uVDUE5Pnu6PVdAh+7h2YCUHxOitWFqP3Jg
nvs0YoMQyGscCe1cR+agekorArx2vbZbH7mPdWdPCuT3hxKpg+crZwiAEprVk6H2iVGEDUI4v++a
cmSN1kuAF0rvxmpktx5hQ1AuXFMiFamVw1YCLIAnQPKXpc8BemrbU/WWrxE2BOUiKC0K4gm2Jfkl
lOn+qF/epzeJWl/2iLLhiVVA2+9bvgOCs2gKyVNnBASlM2ACdX8EBKWgpIuAoKRLyX4lYrcgKAUl
XQQEJV1K2HVsv3+CUlDSRUBQ0qVkvxKxWxCUgpIuAoKSLiXsOrbfP0EpKOkiICjpUrJfidgtCEpB
SRcBQUmXEnYd2++foBSUdBEQlHQp2a9E7BYEpaCki4CgpEsJu47t909QCkq6CAhKupTsVyJ2C4JS
UNJFQFDSpYRdx/b7JygFJV0EBCVdSvYrEbsFQSko6SLAD+XOZ0/2nkxxVqpqz8I8y5eT7PJDaXlE
C3o4Ve2654lsu5NTTrzd9sjvzw/lCHCWPp4HYO1KYm3C1Z5ZtMs+6X25obxq6e5NmtZPqpACtGPT
xA3lFUs3GtON4GsBzQ2lpQyPtDmzdPf8Ven+nJK8UFpK93dTFTQmlW5yKFGZW6EqyEZStdaxEQIs
9U0vS7uWeua20QNajwnq3TxZYpD7F3CMxquUqCyvUBULMLVSb+nXgwSNLV0vj6x6j6dOYPWgHfk5
lJ6Pm4/TOKH0JH22hCNASkX2+obu37ru+TWKHrCHYs9OktLPjetyTii9JcWS+NbsRgnN+yEgSxuo
fc9vT+m2HjGtjOtGteSE0gKZt01rZqO12rGuRIDVkjQKgad09+KQjxlNvnSfvCqMjHe2an3154MS
BcML49G+t0BHP3+C4GqpxqivntLdslEuO3q+tDaNvXHfSikRACOJRgGcmQiWUwA0pp7CWJS8XDda
Fau2ocr79iarZdxWP4p2fEo5Ah3qY1mUo3vUrlsTM6JSR6IsZXcw+c2PCFHlSONZcfrR8JsLSoti
rU7A6K7UCiQaE0ouAgT1R/GyQF+bVOi+E9e5oERlzgrCSECsZbLcECBbaEwzpRstS8p7e8Y4o+4o
JuA6F5SohM6qQi8YyHZ+3TM5rLvjmm9IxazxQPfxjH1z6eb67BuVudHFvGXWepNi9QWNCX1k1yvd
VpVE5f8Ye34/BLElphNteJQSlTmPOnkCMgKkVS1mjlRQqbVs3lBMW/c4add9bLx4oERwWEuVFUiU
dOSPRalm1mVIrZDKIpVuxXO0nzXuhnYcUKJAIEC86zYLkCl4yG4PDDQmpHSzpXukvzUuBrBmvpHO
ASUqMwiO3vUSHE/g0XqsBxZSutxn77d4ENBojDWVt/i7awlFeXg+A12vrzfZ5QYGJapXwj0TrUw2
sotKN4JyNN6rl1C0h+eozI0GMPXLFQUlqgaYxbcWIB4oS+UbKb1lgmfi1uq7uWzzbXSCBjyz1lHf
mAhwrCkFpCKQRUBQCge6CAhKupTElEhmK4JSUNJFQFDSpYRZw2J8a0KZLuitGJzFwPP5fKX3x6dq
j8fxH/r3X1D0PjcGglIQ0k3CTyj1pwiwReAv2IKDJObajNkAAAAASUVORK5CYIJQSwECLQAUAAYA
CAAAACEANBL/eBQBAABQAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBL
AQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAAEUBAABfcmVscy8ucmVsc1BL
AQItABQABgAIAAAAIQCKeBXmwgEAABMEAAAfAAAAAAAAAAAAAAAAAC8CAABjbGlwYm9hcmQvZHJh
d2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAFNSiWHSAAAAqwEAACoAAAAAAAAAAAAA
AAAALgQAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc1BLAQItABQA
BgAIAAAAIQD9wVrvzgYAAD0cAAAaAAAAAAAAAAAAAAAAAEgFAABjbGlwYm9hcmQvdGhlbWUvdGhl
bWUxLnhtbFBLAQItAAoAAAAAAAAAIQC9XbNS7AcAAOwHAAAaAAAAAAAAAAAAAAAAAE4MAABjbGlw
Ym9hcmQvbWVkaWEvaW1hZ2UxLnBuZ1BLBQYAAAAABgAGAK8BAAByFAAAAAA=
" o:spid="_x0000_s1034"><v:imagedata o:title="" src="file:///C:\Users\Damian\AppData\Local\Temp\msohtmlclip1\01\clip_image004.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:Anchor>34, 0, 4, 20, 39, 19, 4, 90</x:Anchor> <x:AutoLine>False</x:AutoLine> <x:CF>Pict</x:CF> <x:AutoPict></x:AutoPict><x:MapOCX></x:MapOCX></x:ClientData></v:shape>AH</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=86>AL</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 38pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=51>AN</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 71pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=94>AO</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=75>AP</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=79>AQ</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 46pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl89 width=61>AT</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=47>AU</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=47>AW</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=47>AW</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=47>AX</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=47>AY</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=47>AZ</TD></TR><TR style="HEIGHT: 102pt; mso-height-source: userset" height=136><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 43pt; HEIGHT: 102pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl86 height=136 width=57>No Bags</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 41pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73 width=55>Total Kg's</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73 width=86>Kg's per bag</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 125pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl76 width=166>Number of Bags or Kg's of Natural</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl77 width=86>Tank Max Kg</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 38pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78 width=51>Total Kg's</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 71pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78 width=94>Number of Tanks</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78 width=75>Average Kg's Natural</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78 width=79>Average Bags per Tank</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 46pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl97 width=61>Mc No</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl79 width=47>Tank 1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=47>Tank 2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=47>Tank 3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=47>Tank 4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=47>Tank 5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=47>Tank 6</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl91 height=20>77.0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>6418</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>83</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: #99ff99; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-pattern: black none" class=xl81>77.0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl82>1300</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83>6417</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83>5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl99>17</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl87>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83>15</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83>17</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl83>0</TD></TR></TBODY></TABLE>

formula for column AO

Rich (BB code):
=IF(AK17="",0.001,IF(L17>0,ROUNDUP(AVERAGE(AN17/AL17),0),ROUNDUP((AN17/AL17),0)))

formula for column AU
Rich (BB code):
=IF(L17="",0,IF(L17>0,ROUND((AH17/AO17),0),ROUND(AN17/AO17,0)))

formula for other columns
Rich (BB code):
=IF(AND(J17="Natural",AO17>=3),ROUND(AP17,0),IF(AND(L17>0,AO17>=3),ROUND(AQ17,0),AH17-AU17))

This formula is the same for the the next 38 columns except the red number increases by 1 each time.

Any help would be great

Regards

Damian
 
Hi,

i have tested it agian today and there is 1 thing that is not quite right with the formula in col AU - a lot of the time if it is a big run saying to put in the maximum quantity of bags that the tank will hold and then this leaves a small ammount for the last tank, could it be ammended so that it averages it out better without going over the maximum tank volume and not leaving a small ammount for the last tank?

examples from todays data

62 bags broken down into 15,12,12,12,11

37 bags broken down into 14,12,11

25 bags broken down into 12,8,5

Regards

Damian
 
Upvote 0

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Damien,

What is the total kg's and what is the tank maximum Kg for each of these 3 scenarios? Would this apply only to "fruited" and not "natural"?

When you post this information I'll see what I can do. My concern is the formulas are getting really long with all the options we've put into the formulas. It may help to move certain portions of the formula to a preliminary calculation cell or 2, so are there any unused columns that could be used for this purpose if needed?

Ron
 
Upvote 0
Hi Ron,

Yes these issues only refer to furited tanks, the naturals are fine.

I do have 2 unused columns that are AG & AS

The maximum tank size for each of these senarios is 800 kg's

Senario 1 total kg's is 3102

Senario 2 total kg's is 1850

Damian
 
Upvote 0
Turns out I didn't need to use any unused columns, so:

Here's the formula for AU17:
=IF(AG17="natural",IF(AL17 < AN17,ROUND(AN17/AO17,0),AN17),IF(INT(AL17/INT(AE17)) >= INT(L17),INT(L17),INT(AQ17)+ROUNDUP((INT(L17)-INT(AQ17)*AO17)/AO17,0)))

Here's the formula to enter in AV17 and then copy across:
=IF($AG17="natural",IF($AN17 > SUM($AU17:AU17)+ROUND($AL17,0),AU17,$AN17-SUM($AU17:AU17)),IF(INT($L17) < SUM($AU17:AU17)+INT($AQ17),INT($L17)-SUM($AU17:AU17),ROUNDUP((INT($L17)-SUM($AU17:AU17))/($AO17-COUNT($AU17:AU17)),0)))

Let me know how these work with your other data.
 
Upvote 0
Hi Ron,

I have tried it out and it does average it out better but I have found there are some runs that have 1 bag missing from the total

example

30 bags into 15,14 - total kg's 1200 max tank weight 800
51 bags into 16,17,17 - total kg's 1850 max tank weight 800
39 bags ito 12,13,13 - total kg's 1275 max tank weight 800

Regards

Damian
 
Upvote 0
It seems to work correct on mine. I get:
15 & 15
17, 17 & 17
20 & 19

Did you copy both formulas?
Did you remember to copy the 2nd formula in AV17 across to the end of data?
 
Upvote 0
Hi Ron,

I think I have found the issue, the number in col L is not always a whole number and the rows where I am getting the incorrect ammounts the numbers are not whole.

When I changed the number in col L it did give me the expected results

example

29.9356774
50.9956234

Regards
 
Upvote 0
When re-doing the formulas this last time, I went back thru this thread to refresh my memory on the criteria we were using. Your 2nd post said only full bags were used, so you'll notice I used only the integer of the number of bags in L17 [see formulas for INT(L17)]. So the formulas use 29 bags and 50 bags in your above example. If you want to round the bags so 29.9356774 would be interpreted as using 30 full bags instead, change all instances of INT(L17) to round(L17,0) in both formulas.
 
Upvote 0
Hi Ron,

Thanks for that, it has done the trick.

I will continue to test on different data when i am back at work next week.

Thanks for your help

Regards

Damian
 
Upvote 0

Forum statistics

Threads
1,215,326
Messages
6,124,258
Members
449,149
Latest member
mwdbActuary

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