<div>
Where does the 9 in cell F5 come from?
</div>


<div>
you see 9 in F5 because i took number in BF6 (ORD) 4619 &nbsp;and count it (MIDWAY TOP)<br><br>then &nbsp;shows it<br><br>You see i took the first ORD number alone at the begining of that week (because each week is apart)<br><br>as shows<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562141/ex25.PNG" rel="ugc"><br><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562141/ex25.PNG" class="fr-fic fr-dii"></a>
</div>


ex25.PNG

<div>
Where does the 6 in G5 come from?<br />
Why is G9 a different color than G8?<br />
Why is F22 red?
</div>


<div>
<blockquote>Where does the 6 in G5 come from?</blockquote><br>F5 to F14 have the MONDAY AM count &nbsp;the ORD for MONDAY AM count &nbsp;(begining of the week) is 4619 only<br><br>then<br><br>G5 to G14 is &nbsp;MONDAY AM + MONDAY PM = 4619 + 6683 = G5 to G14<br><br><br><blockquote>Why is G9 a different color than G8?</blockquote><br>because after i count &nbsp;Monday AM + monday PM &nbsp;and i have the column G5 to G14 done<br>&nbsp;an hit is &nbsp;317 &nbsp;is &nbsp;an ORD &nbsp;<br><br>&nbsp;<br>Why is F22 red? <br><br>RED because is an HIT ( shows in ORD next weeek) but at the next week&nbsp; not the same week as the green&nbsp;<br><br><br>
</div>


<div>
<blockquote>
F5 to F14 have the MONDAY AM count &nbsp;the ORD for MONDAY AM count &nbsp;(begining of the week) is 4619 only<br />
<br />
then<br />
<br />
G5 to G14 is &nbsp;MONDAY AM + MONDAY PM = 4619 + 6683 = G5 to G14
</blockquote>
I don't understand. 1W2012 only has <u>PM</u> ORDs so why do you say that &quot;F5 to F14 have the MONDAY AM count&quot;?
</div>


<div>
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562142/29216539--2-_4N_to_add_COunt_byPLAY.xlsm" rel="ugc">29216539 (2)_4N_to_add_COunt_byPLAY.xlsm</a><br><br>ok i see my mistake we should shows only the PM&nbsp; where PM is the ONLY&nbsp;<br><br>but when AM are should be shows (because we going all &nbsp;the way down )<br><br>i adjusted the Workbook i means the sheet "BYPLAY" <br><br>here&nbsp;
</div>


29216539--2-_4N_to_add_COunt_byPLAY.xlsm

<div>
Aren't these the correct values?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562146/2021-05-27_06-34-16.png" target="_blank" title="2021-05-27_06-34-16.png (136 KB)"><img alt="2021-05-27_06-34-16.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w22/800_1562146/2021-05-27_06-34-16.png" /></a>
</div>


2021-05-27_06-34-16.png

<div>
Aren't these the correct values? <br><br>Not they don't <br><br>why you say ther are ??
</div>


<div>
Where do the values in G5 to G14 come from?
</div>


<div>
G5 to G14 &nbsp;is the &nbsp;count of BF6 &nbsp;in "sheet1"<br><br>i juts have 4619 &nbsp;then i hit the MIDWAY TOP &nbsp;button in Sheet1 &nbsp;it count the only one ( i erase all others BF8 toBF16)<br><br>so i can have the begining of the week <br><br>in the situation i count like this &nbsp;MONDAY PM = count in &nbsp;shows in G5 to G14<br><br>then <br><br>MONDAY PM + TUESDAY PM = count shows in I5 to I14 &nbsp;<br><br>is progresive by each play&nbsp; not all at the same time
</div>


<div>
The numbers in my first picture are the numbers from 1W2012 as shown here.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562154/2021-05-27_06-58-27.png" target="_blank" title="2021-05-27_06-58-27.png (163 KB)"><img alt="2021-05-27_06-58-27.png" class="file-block lazyload" style="max-width: 768px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562154/2021-05-27_06-58-27.png" /></a>
</div>


2021-05-27_06-58-27.png

<div>
Ok you rigth <br><br>that the numbers <br><br>but i need take one number at the begining<br><br>This time is not all the count as we did <br><br>this time is one count at the begining then add&nbsp; &nbsp;the next&nbsp;&nbsp;
</div>


<div>
also we need look the ORD column wich is the BF column not the Q column<br><br>we are going to count progressively<br><br>that is, I start with one the first<br><br>then add the other and count<br><br>then add another and count<br><br>and so on until the week is completed
</div>


<div>
Okay. I'm working on something else right now so it may be tomorrow or the next day before I can work on this,
</div>


<div>
I'm still not sure I understand something. On Sheet1, cell DD5 is 3 because there are 3 sixes in the first three days of 1W2012. On sheet BYPLAY, should cell F5 be zero (or blank) because there are no sixes in Sheet1 cell BF5, and should G5 be 1 because there is one 6 in cell Sheet1 BF6?<br />
<br />
Todavía no estoy seguro de haber entendido algo. En Sheet1, la celda DD5 es 3 porque hay 3 seises en los primeros tres días de 1W2012. En la hoja BYPLAY, ¿la celda F5 debe ser cero (o en blanco) porque no hay seis en la celda BF5 de Sheet1, y G5 debe ser 1 porque hay un 6 en la celda Sheet1 BF6?
</div>


<div>
<blockquote>On Sheet1, cell DD5 is 3 because there are 3 sixes in the first three days of 1W2012.&nbsp;</blockquote><br>Yes is &nbsp;true<br><br><br><blockquote>On sheet BYPLAY, should cell F5 be zero (or blank) because there are no sixes in Sheet1 cell BF5</blockquote><br>BF5 is empty because is not AM avaliable for that day. in some years are only PM &nbsp;play<br><br>thats why you wont see MONDAY AM &nbsp;and the others days<br><br>we need count AM AND PM &nbsp;<br><br>we will beging &nbsp;with PM in this situation &nbsp;until AM shows up<br><br><br><blockquote>should G5 be 1 because there is one 6 in cell Sheet1 BF6?</blockquote><br>in Column G we see the Result &nbsp;but not the counter<br><br>what you see in G5 to G14 is the numbers in the order we have made (from MAYOR to MINOR)<br><br>9 appear 1 times but is the top to minor<br><br>in G5 to G14 we are counting only the begining Number that is &nbsp;4619<br><br>no other &nbsp;because is the begining <br><br>then in I5 to I14 we count MONDAY PM + TUESDAY PM <br><br><br>please let me knows<br><br><br><br><br>
</div>


<div>
On sheet BYPLAY, should cell F5 be zero (or blank)? Yes or no please. If no then please explain why.<br />
Should G5 be 1. Yes or no please. If no then please explain why.
</div>


<div>
Let me ask my question in another way, On the BYPLAY sheet, are the numbers in column F the counts of the numbers in the first three days of a week, or are they the counts of Monday AM for a week?
</div>


<div>
On sheet BYPLAY, should cell F5 be zero (or blank)? &nbsp;<br><br>F5 in year 1W2012 &nbsp;to 25W2012 will be blank &nbsp;because not AM is<br><br>but in 25W2013 &nbsp;will be AM<br><br><blockquote>Should G5 be 1. Yes or no please. If no then please explain why.&nbsp;</blockquote><br><br>No.<br><br>because we are counting from MAYOR To MInor<br><br><br>the counter don't shows up in BYPLAY only the result<br><br>example<br><br>in sheet 1 you will see this<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562231/ex16.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562231/ex16.PNG" class="fr-fic fr-dib"></a><br>&nbsp;<br><br><br>
</div>


ex16.PNG

<div>
That doesn't help. Please show me <i>all</i> the results in MID TOP for 26W2013. In other words all the green cells in tis picture.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562232/2021-05-28_09-43-55.png" target="_blank" title="2021-05-28_09-43-55.png (194 KB)"><img alt="2021-05-28_09-43-55.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w22/800_1562232/2021-05-28_09-43-55.png" /></a>
</div>


2021-05-28_09-43-55.png

<div>
At least Monday and Tuesday.
</div>


<div>
Here ! Best Expert !<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562235/29216539--2-_4N_to_add_COunt_byPLAY.xlsm" rel="ugc">29216539 (2)_4N_to_add_COunt_byPLAY.xlsm</a><br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562236/ex26.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562236/ex26.PNG" class="fr-fic fr-dib"></a>
</div>


ex26.PNG

<div>
Please attach a picture show where the 9 in F1006 comes from.
</div>


ex27.PNG

<div>
I'm sorry but that makes no sense to me. What do the ONE COUNT TOP numbers which are the counts for the whole week have to do with Monday?<br />
<br />
Lo siento, pero eso no tiene sentido para mí. ¿Qué tienen que ver los números de ONE COUNT TOP que son los recuentos de toda la semana con el lunes?
</div>


<div>
like i say before<br><br>if you see wells &nbsp; the PIC the only value in week avaliable is 2039 &nbsp;(BF1006)<br><br>so thats means im only counting the number 2039 &nbsp;<br><br>Is &nbsp;not like you say the full week 26W2013<br><br>im using the tools i have to count <br><br>&nbsp;<br><br><br>
</div>


<div>
i need count the beging number&nbsp; then + the new number and count<br>always increase by the new number&nbsp;<br><br>i don't need count now the full week
</div>


<div>
2839 =<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACEAAAC5CAYAAACm0VZBAAAL30lEQVR4Ae2ceVBUVxaH+4+ZyiROTZJRk8zEbBVNoolLTBBjIrgBAok0iwqIAiIQIkgDDghNNwgkElRAZe/Xy2tQYyaLscwyk2XimprKnjgz2RejMYvGxKgs3fBNvdaXIlZmwrtY3VLVf5y6bdv9/Pzd8869fc65T9fhlmjvk31qus29Fpw4fGp+CHUGhrYS9m6Jx95YylxDKGGGSPSN+ZiOOXD0yZr9S1iJx19dwox7bmWqtJKCLWksyZ5DcEMp1e52HGgDEYZwyFPRBc4n75gNyw/1VLfOIyFrEUXft2tWQxjiib+FM3z4LBadbEc6uYEaWwgL4kNY8anTexD2zjZqi/7AVaOv4Mrr/8T1N17NeEMkOZ94EcLptiJ3tSGdbKH5aA0VjbO4NymS3ENenA7PPd5nR+6VkD4zkp0xjSnVq7zrmB3fV1PWvpT729NIqg0nIiee5f9qxd6nfQkQdkzn12YKKu4lrlxPbH0Khg/aNDvkoCOm7LJi67Jg7bRg65Kwu+3IAiooIDqnqw17r8OnpruqNpUratN8ajpd0UJ0RQnoVvnQYtrXc6zzOEd7jvnMdAu31POu+wBb+jazFd+YB+Jt9zu09zlxelY/ZQX0rvWD0Lb8qvf4+RiHOES3xPY3Uwk3hBKSG0rIQynk/LsFR69d+85KccwzPqFtOqwny6gNuoG7pAJyH01nSf4MwszZVJxQJkjbtYSno+OjNJIun8TCo3Yaf6inyhpDYlYCRd8JbO9ElbD/0EBN2m8YPT2axLdXEp9yJ1HP1GF1ObynhP1UC5aD6yi+/1Iuv3UMNxlzMX/diuT2IkTLlytIvfpSZu220fJpBXl545nwQCIFX8uaV1Nhn5Dbp6G7fQF5J2WspxtY90gkEUtnsOyAhL3XS4657Z0sZgeMJcieRYaUxELDXcypzKD8W6cXleix0LJzHvMr9OhXxxBtyabgE4tmAM+mRvTukHttyD2SZ3cldUpI3VZsbod3Ic7HmqFeQ7dgaz1vud5GdttxuG0+MQ/E3i/3svq1Cla/tvqslfd7rb537jiQz5z7nV/+swdi96E9mF8pw/yK2Sf2E0TZfjOm/SafmB9CVX5oK1G6uxjzxplMXTiFwPjpzDKmkrHLROk+7X4lrETRP9JZHBZAWE08cSVhTI6eREBjPsZ9pZqdWxiidE8hKx8zULSrmKLHlzE38TbGFKaTt9eLSpj2l2LeV4pxTxErLOHcM/lmptbnU7LXi0qY95ZQ1xjIiOuGM+yWG7gmfxmGZ4q8C2HaU4Jx1yqKX1pF4WPLiI+5ibGLYkndXUapxqAn7BPGFwykdORj3G3E+Gw2qUsnMjk6nMXPexHC9HQid827myhzFFH5cwiOmESgOZ3svWYvKrErD4PxHmakBxOcPovwymTSXzB7N06Y9hox7VpFycurKH65hOI9RowCd4YSunXzt9Sz64vdmPeXYfKspMpq6l3TRbWv4+APR3jv2Idn7SPeO6aa+p4yqu8NZPxf31Ov0//vP0R3kWkJl1Vm8MfKTIZX3X/W+r9W3zt3HMhnzv3OL/9ZN6wqiUuqkrmkKoXfn7X+r9X3BjP+2vV0lq4WWrusPjWd3NeGrCTKfWi6Di6AuuiQhpC7JeQX4jzVwFBDGJHr0yn83C5WahBVov1gHgsWzWXRU/kYHIvRL5zMtPWC1UBRCGdnA3Ufb6S124r1mxrMFTOYef8SipVqoNbEmTDE2SK/3Gej45tqSouDuGNlNiZXh5chlNu6p4VNr6YTkzYV/e4msTymqBJqfqL5QCHJy8cR0FrO2m7t+SpPkkQUwtHdTNP+XBIzxzG5wcy6Hlm8BiYKsflgPgsCL+KSGXPQW9JJlzNYutNIxRHtKSPhiLn1g3ziKqKJKdcTXaYnujyayNYcij5p1ayIMITdZfVUAq2nLahm65Y8jqm1KigMoeabzsfoh1BV9CvhV0JVQB2Htk/89f0cwgvCCMsLZW5uCKE5s4kwxLL05bXU9yqF3oE3cwgr0X6kioKdBvJ35GJ4MoflNSFM1k8iZMdamlwaiy6iC5iSjFe6zpRQLX1XS+WmuczOjGPFYe1dZ8JK/CR3nw3pYxOxOZMI7FgjVg0UVcIDoeysXM3U7ktgoX46iw/I3t1ZKRDKrzbrVw9iLJrIhI0+2FkpEIpf1L8QTWzAeBLfd2quAqpTOgifsGPtraMi+XrGZmWzulvWvMs+PxB9NVRuTCD9nTZPi5N6Ua3joJRQfMLmtmNzifdYKcC6jr4L4Ff5FnebphCrVeqBfF73SPcFALGt80KAON3q++nY5oc4s+fQDWklPKkBl0TTzjiUnFW44T7it5ZSfVrbrsoTrESVUHon2reHMDE9lsQn88ndXkDxG2tpEFhDhKej9UQplWP+zPTnN1J3tIlNx1tpPnXmB/FAAlT/zwhDtB9IIeriUdwUOpIRo6/kd0F3EbR9nafNVnPiTHQ6nngmjMsuvpnI/8hYj6+nqn4aQUnhYh3sohCPPx/JtcMCSTjegdTVTN1TMUSlTyflLaXxWONuWxRC/iiLpKtHMOufVqw/NvCwHMGsjFAy3pO0Z2pEIayn66k338jE7EVkNsUTlzWN4E3FPHRSoM9KFMLZZ2Pz0VJyH4wiZnUM8U4DpV8JphDFIZTDBDbPjx9rl4S1x+bZ4mm9MwYVrPrf54N9LRwnBvsP9/++H0JVw6+EXwlVAXUU9gl7Vz2166efyVflzSX4wRRS32wSawoVjZjSiSrKZ+oY96CBnO0GHnjRjPkLwdNPg4WYsqOVhmNNNP0oYekW+2EsPB3SqTVUhOoYft1Irhx9DWNTE8g5IpguElXCqbTS9kjYe6zYDlZQkDGBKSsfwNzTodkvhJVQqjvK6Tdl1bR2buIhSyj6hHByDwocUBRVwvpxJVU/yh4Q+7c1FJqmEZyXhknkaIUohGybwYS65WQ4M0hrSCQkJ4S4v9fQ1Ks9dyU8Hf2rgfrqJE9Ou1EAQAlYwhA/qwZ6zgbaNG9wBx0x1Qucj1G3tUvyfZJkc4/N9xDtroEXR86H9L90DZ3T7YfwuIJfCdU/BqWEp+jyXT3lLTOZXb2U5e9pb+BQQAYF4XBbsT4Xw5i547gpNpCwF5s8mRr1fzjQURzCbcXWsxZjxijGr88kfMkU5r4k2F0keos6ui04pVv57eoSql/PQZ8c4F0IGRvyO8nor51JcqdM/YEc9KleVcKOjfWUx49kzKY1VL5ZTsmOJOZEj+fujirqjls0r6YCPmHHysNUZQVwR9RkAqJvZ2LIaK66YTgj9feRtLeOZq2JM+0+oRzPtXtK1NJJ5fkTzdS9nkXskslEvNiAzaV9XyGgxM/XGsU/LN+soWT7cgpFzwZqV+LnEEosOFMVdAg/eWHQSgw0IP2/z/khVHX8SviVUBVQxyHuEz1W7KfbaHwyijDzfDLf1d6ROmglpM5KKmPHMq1MT0Totcx4tsFzmlooyy8atmV3K20HKqh4bQWZsaOY+ZwPIBQplXpH68d5ZM0fxeznGr2vhB9C9egLQgm7awMbnCmk1UUy5+4ruK0omYznzDx8zKa530o4WNlO17C2MsLzPCu1gz1ONlB2xKo9jyl8i7qsOM4+z+rcDnatsUJYif6+MdjXfghVQb8SfiVUBdRxaPuE0uK05Yt8Mg2zPM+zili/zHM2UOh5VqIR03KqnKqwEdxSkE7+5hQSMgO5sypP7HlWohCP7olmzKV3EnXIjuXEJtZuiyJmZSS5nwuUn0QhLNYp6O5eTPEpGXtPMxufjiEmK4jUtwW6i0Qh2qQAdMHJlJyWcfRYaN2dTLwpiJS3WrW3OIlC2B2B6KbEU3jKga27hQ1PxxHzQDBp71q8B7FtfxyTho0j9pAT28kGHnbOI+ov0eQd8aJPtJ16iOrFNxBkyiCrJYnEnFDCnatZ16uEII0dZ6LT0b/PKrZiAUu2lVB5Qnujl4IsHjGVYxX9+qyUrJ3ysE81FGsZxSE0nOn5NaALA6LD3cFm2tmMMvrGdJ8f/gxXXzcufGe6w4e/oK/PBbh9Zn4IVf0LQon/An/UzKv0jTlCAAAAAElFTkSuQmCC" class="fr-fic fr-dib"><br>2839 + 2619 =&nbsp;<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACQAAAC5CAYAAABA+J0FAAALkElEQVR4Ae2ce1SUZR7H57/OttWeLqtu5Zbd1DSvSHjDG4moXLyACAoEyFVlhkBgZkC5aZiKiDjAMDfAvCAwA4h61DRS23ar3bUtMRGsjq1ZmVtmJJfPnndsdsmTku9g7xzP/PE9z8v7MM/7ne/ze37P73mf5zeyI0cO40iQORIZgYvjEXqj6SCOBNnr7RU4EmQV3SYcCbJyjDgSnIR66427QyFjp56KC7moTQvxVHgyK2EBS/9aSEm7wW57FKXQ9ksbWLtlJm4xPvjvTESdP4uRPv68fEGPEZNdpEQRMn6aSWTieEZvSOHVK3pKLqxCMfp5vP5WgrHbZBcpUYQqv1hLcrI7Y9Ry1rQb0XyjQj3qPsbt2oq+24SpW7wrEUVIsKHit6MI8H2I/s/0Y8DApxgy8ne8sHsrhi4JCJm6DZiuaTFcLUH7nYaizxKJGfkIrhaNNF1m9SUCqW49+q5t6HbNZcikuYSd19llP0K7orqs/FoJmg/SSCqPJNK0iAWRU/EwZbPtit6uESae0A9FFDTFEZnly7zVfvhbMim8Iigm3phtHlyUQqYuA8ZrOgw/aNFd1WK4pusTMlaFDF1GHAmyfpsicCTIZCmBOBQuXLnIhStf9CF6tnf717Kcd7JxJMhWn8jAkSBLP5GOI+EuIXRMjbo2kiWrJvNioBuuAW5M2ZzAqiMqu9UWp9CRRGLXeeERNQu/9YEEhD/PwDHuzK5XobbTBEQRUh9TkrY/kcTGVaS9qURV7of7k4MYp0uVhpBtEGQcV5N+TEWudiZDnhjBpFqltIQEMqo34okMe5rHYpaiOKiUxoZsyigPyIlKHcNzC6bjV5VC6ltqaQhZbagulvDk8QwLmMLc8kRSj6ejPm6/TxNl1OlHEolLd+PpoY/xVMAMPJU++GX44Vkqt5uUKEIZhxOJzfdm6rIpuEe4/w+u6+NRH7NPKVGE1MfVqJqUpB1NQ3kkjdQj10tVk0oahWzD/k6UohS6E0RsbToJ2ZS4WelU6GbK2O47FbIpcbNSnELH1GQ2xBCRPv16xOjvimt2NMlvSDTbpzclkZw3E595bkzPCiRQ6c7osaOZUS5VgHY4gfiVE/BY6kPoIRWJjWEEDR3EOK1UhN5MY1WBFx6ujzMyIxj/ZUMZuGQhK/ZJREj9lhLl/kTka6fg4vIH7hnlxoxt8SgOp0kTwqqOKIhKcWWi31QCq9JI2TSFF557jOFbV1lne3tWHqJGmcq8DJ9FIxi8IpT4pnTS9kUS7H4fjybFopQiHko/mEDUK5MY7efGVPU85sndGDF5GB6lKdIoZF1t1IQTonRnaoQ7U6Km4b55OclHJVq52lYdqjdTrRFj2lElyiY1qmN9surIIP2E40DW/HUL13GG5q97wnb/15S/9Lme93q7/v8zZA/nRPNwTkwfomd7Pa97PqPn/Z9fy+7NCeO+PkTP9sRcy0radTgSZNadHetGirA1ID1EbS3Y9iXuRHmXEOo2UN6pw9iqJG6zNzPlnsyRBxDdJtEmsKlLT0Wbirg8L2ZsjCDKLCfRnELWlxJt4BmuFVGw3Z+Q2AXEfriVwq+3UXhZS1m7TqINvMsbyMmdxuTBAxjo0p8/Pt0fWWQ8my9p7d43E2XU2y+sJTnBhcExYaR8acR4dgVBLg8wameRNLvSwr59WtIkXFbFkfFjBSXfricr+EEe3ZQlDSHTd/m8WuDB7LiFJH1uRHc+nbi5/XlWlycNIWNHKSXvRBGmmMycvHBWZrsz3N+bsNNaifbtuw1Utm9h06FoQjJ9mZ+zkJB3iij9UaJdaeuUIcx7HTp0ws50exm6DiPGLikJ3aGza6KG/Z2YVG1tOgnZlLhZ6VToZsrY7jsVsilxs1KUQkKAJpzUSy32wUvhiZcilMizxZR2SOQYjR0a8g/FEJsTRFSdgmj5GB5Ym8zG/0gUoBm7dZRdLqL4YhHa9lI0ezy5f2EQiosSEbL2vzCXdenQdqwjPWwIA+QKNl7SSnQorttA1b8zSEgdxYBn+yFbFETCXzay7XuJgnxhhWu8Vob+aina70ooq/PGdYgbPm0SETJ2aNlyPp/Xzpdg6NRjfD+COYOH8dJ7WgxIcBbW1L6V7MZwFmUGEl0eRUzyREYHLSb+S6kWip1aSppTSd7iy/w1fvjnhhLTLKEfsr4l6dBhbL9+jrHsRx36TqM1nr6ZB/6190V56l/buJj/cxLqTTWnQk6FelOgt/q7w4aEA96m9jIMzSnErfdkVqWKzd9KeOLc0Kmh8GAYoSumMWfeIAYnhZN9US+dp7ZmK1wqIL95NaszRuCiellaQjbD1P9QwIZ1IxmndhL65eWNUyGbrdxYmrq0lJ7JQK1fTFDQUzy7YCoLi5YRc3KbNO+pjR0laN5VkJjlbc18EbJfBCxqKrAOfXsyYER56hszX4TsFwH6DvszYEQRurEL+/JvWUWXCUeCzPJZA44EWd25RhwJsrpz+3AkOAn11ht3h0L1H26nsDQav8h5+EbMwyfMB++Q2QQsSyLn7CHMbeLtUpRC5tPVGA5sIF23GnXZGlTFSmL8HuGeuQo0LfupbRVGrjhSoghZ2hoxtzRQe6aemo/r2PVWFqEuw5lmep3q1kYsv7VC//v2bY3Ute2leP1U7l+0guL3arGIVMbWpiiFbB+ub61nz+kCMhaMZHpuCZUf7RXdVbY27SJkbqmhstifScHhJB+tpeqseNvpE0K7381nle9ovFW5aE8dsGt02U3Ics6MUR/JHI/ZROw0sqttv932I5AS2WWNmM9VYzSvIal4I5r36+y2HbsVEiKE2ra9VLfstcvv2IjYSpEKiXN6tofeqnQSupU6Qp1TIadCvSnQW/3dYUOWs2YqG1eTlDAbnwg/vCPmM2XDFnY0N9jtsUUpVHumCm1pEIvnTyAobw1puixeqatg12mJCYVG+pKyr4rKD2p4/fRe9pyVKB4yt1RTpg/Bd/i99Bv4Jx5/cixehnJ2nm6we8YX1WVCTG1pqcN8xkJNSwM7ywJwe8Kd0OMWa0xkTxgrjtC5fZgFUkJMfW4fO/6xAfnQfszQVElDqPZUNaa3jRg/vh6U7bDE89Kw8SzdWyMNoZq3NWSsns+C3BQU+cmERc1k4spUNp+sl8iGPtpBoUlBcOISFsuDCczNJP/vddT81IW9eeNb1YuyobrWRusisfq0hT3NFqrP1P9kU/YHbuII2bkY7HuFnITuoAK36i6hzmlDToV6U6C3ertsqLalnvLqRCISfPHRaKWLGK3fsq2RhhMbCVvhhcu4R+m3Ig/dyXppQljhNZ757G7KtEuYnxxKkL8LgxJexSAVIUtrAzWHMlmcEsSSnUVkLX+RZ+TrpCLUiPlfBvJUQSxJWsPmlt2sk0tIyHKuDkNDMmELJhNaqiF//3oUISMYuFROzv7t7LHzTdptjzLLOQvGAypivVwZ7zmB8bNceX5wP37/zDBGLstgW+uB3/o9dSPm1gaEWKjqVC07T5WzdvlYnkvIxvBPIchvtCtqvG2Ffu7YhHeNteh2pRK/Q29dBv28/vYDNjsJCQ8UFGu0vmsUSgcgdPsq3Iq0zPJJI44EWUVnBY4EWbnww6AOBMc72dCXxyT6oi2nQr2pKEoha2ry5dfI2xNMgNyDl1bOZN6BfDRXJToCb+zYRmGDP/6BE/AtWk7apmkMnumB/0mJMoErvspDqZrCuMRoUr/RU/bFGl4JGIBrnUaaPFf9J5mEyCcyeks6+Z3l6L5fz9qwB3miIBudFD+YLRAKVkxkzNYMKyHD9xq2ZPRjYGG2NVngNz+DZvg0k5flExibr2RjZzllV14jN/QhBhWtlUYhwYbUqslMlIejvlKO/vMMlnv/mckHNdYfXbfnp+lFDXt9h4Yth0IIj5vGwoJoFDkzcQ0LZvlXemnOMZbfkCsteeaL1dv2yJV2Zr70Nv/0Zb1sO5U4Ev4LfURhe6RBuHMAAAAASUVORK5CYII=" class="fr-fic fr-dib"><br><br>2939 + 2619 + 8579 =&nbsp;<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACYAAAC0CAYAAAD4k17mAAALn0lEQVR4Ae2de3BU1R3Hd2o7rYxCZySOFRVQILxDgkAghgQSsoS8XxASCJAEEgiQFwl5bF6QhEchhJD3Pu7uJhEUX1HGCo4KhGBxanXUWp0qSBmtItQX5J39dG7C1uhIy10u3B1m//jNuRvO3vPd7/ndc773/H7noDJjxB5NZY+gREx3CDCLgLlfz6FPM4ksDECduojg7FjSL5oR+k0YMcnmFpIYa+o38PzZdFYlezB1dwobn91EcdEcXDZtJLuvBaNFKWB9Og4dD8d1RQBL36+l7mojdefWssbLi5jPWxD65XuQpDHWp6P13TgW+fui/qCO+m4tBy5tIsF9HOq3mjH0KQTMfM3HqvSzcXZ1wmmcE6MmTMU5Zhp+f1YS2LUxT+jRo/2hnsZvajjwwSqiZ00m8L0WBRm7BsxkETD1Cxi+34O+cBIT4pLI6lXQ+c0INHdWsvvoRjaY15KgDyQkxJNlZ+rR9xsxWRT0sZYfdlFiXkFUUQhhZVEse6tB1i60zkSSnkqRMbPFgLFHh75Di75Lj77XiLFfkG1g/S8wceyxR1PdX5GAPZpKtTUau7Qvr3yFPHZxyH2udz20rf9dR1V6Zjv2aKqi04XYo6kKThdgj3YnAdOw7ZlYFsTPY/ayOcyJnYevLpu8Uxo07fKxL5ExDXmnN7NphRtTN4QRUR5JTMYM3PwWEvFyMflKAis+GkfU/Mdxr0sl/ZVMMp4JIWLGVNStJcoBK2zXUHgqh83pExg9xoX5rRtY5XMPjxVuJvuERjlgBac1FJzOI+doBsmJoxg5ajjDvP2JfTmHrJNKAmvPR/PqKpb7jcWlOIXMo1lkbnVmtNsMFjxdRP4pEbg8D4Ak5y9sy6W01ptJ6idY9PRWsk/mkvNiDGrPUUytyCG/TSlgp/Ioe34lQSHTmZIWSGBBMGEpLkwN8iLscKFyjFm7KUsbyuL1nngleuGdtJAgc7asY5jYjqSutALTtOWTezyXvDdyB0pNmwaNTL5lbcMmYNYv38rSAUwquw7GHIxJZUBq/TvFxzQUtOdTYApnwWp35iydhXvMXIKfKiC3vUDWQVYSY6IeKz62logkHxYWRRG1I4JlIU6MDQ5nRZuiCraAwrZsMl7MYMtrueS9noXmwFwed52J3xEFFezPHVhzYitlO1x4eJYPISfsCFjWnxJY6j6MceWZ5J0qkFVhSPIxK2OiushpTSYmyon7IqNIPi7vq5vYjg3A8shqXkVY5CM8GLeMpJMF5LfLp1ytP14SMPGpLDmaQETwKIaNc8Y9K4jgglACti8j8qC8YlESMHEMKz0Sz9I8P+YnzMcrwWvAPDYuwbdR9DP5mJMEbPC9Mg/NyUH1mvNGLqJtPZFHrqhi5X0TL6TgtP2Z6qPL/+Cjy59IMLH+ULN+d+jfhl6L/z70s3ht/c71S9V9pcnIY0lD7nMz14N4VPeUrkYOGzbkPte7HtrO/6ujaujSY4+mGghYiUErOzOJIRv5gljW0Mz1yjsEmEXgmc81rKsIZXGaH+p0NepUP3w2BRFenUNpr1m2YJc0xiwGDn63h9L2bNJeTCO9NZXUp5LwD3yABzR5VHbJF4WTBuxaWNDUq8fQpUN/pQ7hL7GELJhN4HsGDL2KAfup8xs76inPvJcR5UU0dBuVy7v4+RNUcymV5IeG4dtuGshUUS70bM2cEqO8/XXUbR/P3XGbKO0QZE2fEQmQ6GODXWnq0yFcWMfKCQ8y+0zLQPj552ze7GebgAk9+6krdGZ0yGrSuptlTZ2x/iCbgBm6KthXHcGq9qoBh5czC+qmgBn7DJi6tJh6DbLmWlhBiaVNjA29wa26dgCTyqyDMQdjUhmQWv/O8jExFdDQFkfgFjXq9MWE7l5PzjdNsg62NjAmIJxaybzEJUQeTiWtNY2sk6XsvmpWUI9ZDBgsuyhf5848fRG7v6ym7nIN2g7dwESunB6z6Dl4MZOkEDcm+f6BkeOccJr0MPftLx/MvFMyc/il9+JYqHbD7ZUD1F7VYnonGp+5zqjfbJI1V1Gaj/Xraf0wniX+C/B+u466Lh3ab4tYt3wsri/UyioYpQGzGGj5RsPmlTOZcWgPtVe0mM5uIixsCk+81ohOsZRmBIyWWvY3+eKaFEmCNp60rdOZnL6ejK+bZFWy0hi79jLSdLmM/P0RLC0JJbw8irSz8ibnirOETcBEBWvs0qLvHDRB/CzjJgObgUmd92ypbxNjtjQk9TsOYA7GpDIgtb7Dx24xY+JyUx2Vz0UTlLEIvzQ//LYEoj5WKat6FX+ExK4UEKiiNHciEzPXsF5UsC+ls+XjWtkXV2wGNr12G3u/EBVsHfounX0wVqaZwkOP3sfIMU6MdpnL0s8GlYVy0npAXQiIk7ihW4+hs4HG6slM9IkkseNJBWWPuMVMXBu7tqvG1NNAw4VE4udOIOAdBTfliaCE8+Xsu1iLvt+EuasebasnHgEBJHylMLDmV6IJq4wlTkhinSGeyMTpzG/ezt4+Bd8rxY2fh78sYrM+hrCiUEK3RRJo3kZFj3wbPq0DsbThwiIggrPu5NJ16tB162V1etuAWQMQt6GUxthtAORgzMqA1NLRlQ7GpDIgtb5EHxNj3gLGdzcQpfFHvXkRYVlJ5HWblddjBvZStCeamOaNpB1OIT70fh47uEfZQxLE7jChpeFf1QNrY7p/H+BA8UM4paWzs1/xVWvjgB4TevXUfZtJxpjfMKm5Em2fvEtREn1sMCb+wl/jcPV8hPvHjkSVmUXVpToaFN3ALs6VFgGhWzd4FsG3tdRUT2OSTwRruw4quc4v0NxVxa7P9tPYIS7e1WM65oe3ty+xXymp+cWzCL4vIfGPS4lviCdJiCc5cQqzi7PQ9DYryBhGjDRQdSye2NIQwovDWbpjLTmX5D1PRXz6bXB+AfGJHFh/7dBi6NQh9MmXbGSdIWwA9tPEI+uN5C4dwKQy6mDMwZhUBqTWv1N8bFDBCr06DO2rWZy1hMXH62XN5rQyK5ExAVHB7iz3xXtnNJGe9zKipopGGfNfbQQ2qGC153dR9kUZOWHDGV5bRWO33UxJg8zlRf2eEQ5gN7Si42DsxqWMkVqqX09lY1MMoR7DGZEYR8LTaeT8Uy/rS6/k4UIM2VQciiOmKJjw4jDCRKuMJ/lDraxLnhKBicwOKliDeJrWNRPXYcXz7RSOjNx4t1sHS1tKGxhzALs9DEjtTkdXOhiTyoDU+rb5mBjs6tNTc8iHRal+RJ+pUzpYf+0J7tPzwvsJOIfPxH3m75jYUmkf2390XZXsTBvD+JpMUn1+zZQnlQY2EBPXYziyhLtTk9h5TkPuoruYdnC/soyZenW0fJpCcoSaiL/VUn25hDw/OwAm7kfaU+bKgu2JZJ4pp+jNFNZ63MX4Cg07P69Hp9TRvvqefeytXExAuAtuYW64+jvj/MCvGOHlgbehhH2K7a8Uszc7tRiuNtJ4pYHayyVkq3/LxKZKtJ0GpYXij5O+0LWfCnMYSe83yCoSxcHYtgHW+ibVp8fUo8MkZhY48mCtrChU3lxX3kLQDmC3R/bcwi60/gBHV1qZuNFSImODa7Dmr0tILVzM4s2++GctYd3HJqWXCAQEyx525M/CeU00m55KoaBwGuNXryTlopgKKF+CmyTGRJ3//EeJhPg/gefJSmqvNKI9n8nK5ZNZ8raS5/P3ajn4ahAua0KJO6ulsV+g8fttrI15FDcl9yU19WhpORrA9PhQ1pzTousX0F+tITV7HK7P1Si4YapXx8E3QnFbGUzsJ41oew1ov9vGutjHmHWkXkFg/XqePZtMVJAHnm211HfqMJ/bTPTymYT8Xcn/amHg1IYKKvZ6450VR4I+kS05Hswuzia/R+EsAnGA/HEnl11lERgHksCtO7kcWQQ3Opfd6nqqFppooVkhE9u22k8xqPosXfTSrYidv3CWq90//GLbKoulF+hTxC5cOE93d8cvtv0fGnd97bUnBM4AAAAASUVORK5CYII=" class="fr-fic fr-dib"><br><br>2939 + 2619 + 8579 + 2245&nbsp; =<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACUAAAC3CAYAAACVMJdLAAALv0lEQVR4Ae2ceVTU1xXH58+eNidtjlnOSTS1WbQRY1Dcg7iBEDVsbrigyA6yLw4MMwwgKBhAHJZh1t8MoIlp0yS1zWYiasSeLDY5ntOkOTFJ0ybRYI0aFVnn0/MbnJYuZhj92d8czvxxz/sx7zfvffm++967c+99T7G/tx1vE0W7w463iaING94mPlCjHZExwpTDir17F8WWCEKzQwjNXMraN3bT3GvD5rBLop8eM9Xe10T9mwmsrthEwovZ5GtnELByBZu+FrAMyQSqbciC5VITum49ph4DHR8nsTl0JkF/MGIalGYme8zUSGW1D5h56eRGgoOXEHragtkbQJmu1FOmfpxpVVnUXhLk0ymRKfuQFctFHVW2MAISV5JwSofFYRdr5FF0O1bM52pR65ezMHM5cX/UoZdIwV2q4bFOOWffC+H4B0xgSlo0m4RkktpSWH9sD1Z5dEpgX08juiOJrK6IIkobSVRZFJEVqwj6dTXGXkGe4WsTF88BC9ZeE5aeYTFfM2PqExAGJQIlDNnwNlHcW5+At4lCoYzB6+TslW85e6Wb4VJ8lkJGtnej5xv3o6h8ZwfeJgrtiVK8TRSaExq8TcYIqK4StK9nEF8RzOw1s5m/Nojl5mwK3i5F3SUN6x4ypab8zWyyNfN5LDKQBdoY4nNmM23ZYkIPllAsB6jSLjXag0lsSvTjkaxYkt5SUfTGFjYsnEpAq5Kit9WS6KdHTImgKl5NJT3Nn0lxa4k9qkF5LIm4xffziCaP7UdlAOWcpV0lFHXEELrkTu4afxfjxk9ggv84HigrkBHUCQ0lx9UUdRahPFTA9pc3sGbeeCZVFaA8JhdT19c1dZeaks58SivmMC1wPsteKkF1XC5Qx5VsPxDHxrIIwtXBBIf7M08dT26nWq4lQUPpsULyhTWEJwexMGkRC2uS2fZ6iSSzzrWzeDT7xC+JM1BzvATVURXFR1QUHVM7dczVoBSlx6Ck6NRdGz5Q7hhy1fuYcjHhrvQx5Y4hV/1YYUpN6aFMp+U5a+1s5q6bxdyqJHIPqymRw8gT6VWfUJLfGsnyyLlOy3ODOpB5iwJYbCui+Lgs5rCG0qN5ZGoXE7QunJjfKyl8NZatCyYzW6+UD5SmS4XStpqQ+eOZkrWamPTHmJwYTcorKlRyMaU5UYKqs5Cc2hDmzLqDH02dztLmdLI61TKCOppLxs4nCYpYQPRzRRTplhAQ8Asm1Rc4LQbXtL6V0qMlQTRbyg8msTnJj0k5W0gRzZbDqcSumsC4rDQKj0hjV3kO6q0ccrQLmRE1l0BNJNH585gRNp0FTYXyMOUakuKDacSqgghKCGJhwkKW1KVSeESNWiK/hEdMuUBpjqudlqeqs5iizmJKjpVIBkjsQ6E5UYq3ieLP508zOvn0Bu+Jn48Usb2Rf498dvX1vz5z1Z1GMa4ylXGVKQyX4rMUMrK9Gz3fqJ8UFHdUxvHjyjjEUioZ2d6Nnn+oL4Wh14K3icLuEPA28Thg5Io03c5ybICyY8FwWkVGRTAhWcsIzQ1lvkVN4xWrnEFII3u74ojcPJNl+hyyX8wi891nMPaJuilTYNvOMKjVuSHEvtdK87lmTFeMTkAyhmtN6E5sZeXcO/nZg/dw/0OTCXyhmsY+u8yBbYeA0C8GIo3Y34xg0YJAQj6xyJeXIEba2watw2vboBnhsoriqIeYfqAZU78cOiUutN83o/+sCp2Y2zJgov2DjawKn0vYu3JlcDgE2r/ZSXnDUsJa00i2J7FJuYB5VSkUf2dFkCgVwMPF8z+i7WXRLG/MofhLA4JEiRLiTuEhKBsjo+3maybMvRasA1ZJQv+urctzUP+HHD4fKNfwuCt9TLljyFXvY8rFhLtybDAl5k81vBbLU3mhhOUMW54hWaGEpCeQ3dMmySLqIVMCHX16jJ+oyf9dDrkvZ5P7UhYJSRNRPBVLxUVpVnYPQYnbjOA0Xaz9Zqw9Buxf5pIWPQ3/F/Zg6JUL1IhtxtZnolmYwwPZsZSdMTmTw9wp8WjqPWdqBCjj5SqKNj5K0B4Ve6+2yffDwfmfisbekAnTa+uYGRfBlpPDeZ6jYWE079wUU+1DVmwXtBQr5xC0u4Cy89IknboA3xQo+6AB4xvrWbV+IRFv7WHvoBeAsg200nI8k7xn86j+u0UyXbo1poYE7H1mbP0iIGlyO12AxPKmhm9kA7fj2QdqtKz6mPIxNVoGRvve2NEp26AV62cacnQrnT7PFQVrSfjUjFWuE0ZtCNi+3kFGTRiLd8aRLJ4yekWF9pwVy5Ac/inRt+LQozu0mdiUSOJPNdJ0ronWywbnoQuZzmIJdPTUU2t7igX+D/LAnHu59+F7UCSlsKvbLJPl6RA4cH4nu6rn8mhGPJlnbbR/nUfc0xOZLOgwyHIaxCHw3IVqauoWM12ZScHVNqwD9ewo+iXjqivQX5PGYvBwSRDo6NVR/6sogretI/lzCx3flZGTNoXxLbvQy8KU+KPBYcbwcS5bCoMIqdhC9s4gArZGEXPKjGVAltl3vdOeJuoPpRBfFk50WRRxR2sx9st4QEzcKuxDAkKfGcu14RNGoqNfqhCI2L6HOiXN8LjbA32g3DHkqvcx5WLCXeljyh1DrvoxxJT4U33IgvFkOnGaRTx1oIyWHkGyBfSmmBKjo8+d0ZK4aynTZ/2U+4vSqLskY7RdHHdhoJWG364mXLWMdRseYWppqrygRJZsp4tZVbmckOeV7FQ+yhNaOUGJunRxN7WGp1lVmknxpQZqVJPkBWUfsqA/lUpyrB8RB3dR/r6SvOSJTE5fR/6HOgxy2FP2ITMtf8pkW7Qfs6MDmL5yKn6TfsI4v4eYmJ1B+TVp3IyezT7RKyx68K4aMV8xYLhYS5XaD7/SNHZ+a5YsluwZqBE+dHEWir7P5sOJpHVW0irmKUgUcb8lUOJMtPebnWfdpQIk/rO3BMq1V0ld+kCNllEfUz6mRsvAaN8bKzolYDtXTbE1kmVZIazIiCHto0ZMcl42Y8PAnpM5pOzYQOJvskhPf5yJ5WnUXhLz9KT5We/x8DlvwLmqp6Vbj/F7PZb9i5kUG03WWYv8KZWi29p4dSeV8Q8zNT+VmgtWeUE9211JnnoG94lO2MhI0t+to6VfkNGP7hCwDVqwXDViuKTH/HoEiwIDCfvUglkeP7qN9kEjxnP11J0xICZL7Psong2hswh6R648T2y09zdTfSyJdeUxpNgS2Fb0JPOT15N4VrzTTLbZZ8H4Fy35ugiitFGsKttE2sm9GCVKPBVXfY+XBPFLosVpFX2e129VEvqlSbxxbUM3Bcr15dtV+kCNllkfUz6mRsvAaN8bKzolYBuyIHyhIaspnKVtGnads0iS3+li0mOmRMuz8b1UtuYuYVl8AA/mxFPwmUleUKLlab2so+GLStRNS5my3QtADVMsuqdb2C0sw08ZT/7nMjPlA+XS/NGVXjZ8dswY/1pOacdm1qf68/PIRaxoSCLlw2aZMjicXk0jLZ8oyd0R/s/7PKN2rCbqcAOmflmSJUQbXFw8rVh7/2V5msTngeErOEc3/D9sy3u8eErRqbs2fKDcMeSq9zHlYsJd6WPKHUOu+rHClICtZy/VL29hTcYSwrKCnTfJN12T8SZ5u6OVxq44Vq2dR2htKqUNiwiIDib8A7NM96M7BPZfqKFmz2Jm5iaTe96C9WIV27Om8MTzTRj6fnj7cOmMu9IznXII7PuqjELtLAL0pdQMihcV6KhQ+XG3mL3YI8eG7LDS8Tct+aUzmdmq5ZlBMQ/PSl2TP3fvLkPfI41LyGOmOr4pZ3v5HGY0aqjutyMMNbCjeAr31VXSKlee5/7vd1PTEsy8vGTyLthpv1BO/jZ/Zr7SjEGWA/diYHuoFf37ySRkLiG8Lpm8XaEEbdtCwhnZsqyvz64ReZ6rvcfnOTLP04zP5+lukbtd9Yp9tDMsHexDDvnv/hVX+y4zQJ8scuHyeb7p/uq/+lb09fUAg7LI5csX6e4+g8Mx8G/9/wNA+7pAVnMvUgAAAABJRU5ErkJggg==" class="fr-fic fr-dib"><br><br>so on until the full week is finish
</div>


<div>
Okay, progress! I understand where the numbers come from now but the title in D2:Q2 says MID TOP which is usually just the first three days so why do you say &quot;so on until the full week is finish&quot;?<br />
<br />
¡Está bien, progreso! Entiendo de dónde vienen los números ahora, pero el título en D2: Q2 dice MID TOP, que generalmente es solo los primeros tres días, así que ¿por qué dice &quot;así hasta que termine la semana completa&quot;?
</div>


<div>
<blockquote>why do you say "so on until the full week is finish"?&nbsp;</blockquote><br>is my mistake <br><br>because we count the full week&nbsp;&nbsp;
</div>


<div>
when i beging testing &nbsp;it &nbsp;i just use the MID &nbsp;button <br><br>so i later &nbsp;realize the Full week is needed
</div>


<div>
Okay, so instead of &quot;MID TOP&quot; what should it say?
</div>


<div>
for my &nbsp;is an Number in the list<br><br>we have a lot of number <br><br>but one is an PLAY
</div>


29216924.xlsm

ACCOUNTING ASSISTANT

ADRIANA P

<div>
<blockquote>Please explain about the dark green and red colors.&nbsp;</blockquote>basic is identify the ORD &nbsp;hit in the WEEK TOP <br><br>to see the matching
</div>


<div>
green same week after the week Top<br><br>example an ord match happens after the week top is<br><br>example &nbsp;monday week top happens then tuesday appear in the ORD<br>the combination<br><br><pre><code class="code-1 nolinks" id="code-20-43295269-1"><span><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562262/ex18.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562262/ex18.PNG" class="fr-fic fr-dib"></a>&nbsp;</span>
</code></pre><br><br><br>red next week<br><br>
</div>


ex18.PNG

<div>
Please show me why G2515, G2516, G2517 and G2518 are highlighted.<br />
<br />
Please show me why H2520, H 2521 and H2522 are red.
</div>


<div>
in G2515 to G2518<br><br>if you see the sequence 1740 is shows in MONDAY PM &nbsp;but happens in PLAY in TUESDAY AM &nbsp;so i &nbsp;select it<br><br>H2520 to H2522 &nbsp;TUESDAY AM 38W2015&nbsp; shows 096 this happens in the next WEEK so next week will be red<br>(not the same WEEK)&nbsp;<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562279/ex18.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562279/ex18.PNG" class="fr-fic fr-dib"></a><br><br><br><br>
</div>


<div>
<blockquote>
if you see the sequence 1740 is shows in MONDAY PM &nbsp;but happens in PLAY in TUESDAY AM &nbsp;so i &nbsp;select it
</blockquote>
Are you saying that if any two, three or four sequence of numbers are found in a previous play that they should all be yellow? If so then look at Saturday PM:<br />
48 is in Monday PM<br />
75 is in Thursday AM<br />
10 is in Monday AM<br />
02 is in Friday PM (Note that 02 overlaps 10)<br />
93 is in Friday AM<br />
<br />
so should SAT PM look like this<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562282/2021-05-29_06-23-04.png" target="_blank" title="2021-05-29_06-23-04.png (272 KB)"><img alt="2021-05-29_06-23-04.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w22/800_1562282/2021-05-29_06-23-04.png" /></a>
</div>


2021-05-29_06-23-04.png

<div>
ok you are doing an mistake<br><br>let me explain<br><br>some rules applies<br><br>1- the WEEK TOP have be realize &nbsp;FIRST(Not LATER as you see )<br><br>I means &nbsp;MON PM happens &nbsp;first <br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562284/ex19.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562284/ex19.PNG" class="fr-fic fr-dib"></a><br>then<br><br>2- the ORD happes after the WEEK TOP is create<br><br>1740 &nbsp;happens in PLAY in TUESDAY AM &nbsp;so i &nbsp;select it<br><br>&nbsp;<br><br><br>
</div>


ex19.PNG

<div>
Okay, why is 87 selected in WED PM?<br />
<br />
Also <a href="https://www.rapidtables.com/web/color/RGB_Color.html" rel="ugc">please go here</a>, scroll down to the &quot;RGB color table&quot;, choose the yellow and red colors you want and tell me what the numbers in the fourth column (Decimal Code (R,G,B)) are.
</div>


ex21.PNG

<div>
green #99FF99 &nbsp;<br><br>red #FF9999
</div>


<div>
Okay in THU PM, 052 is selected and I don't 0_5_2 anywhere, so is it selected because both 05 and 25 occur twice?
</div>


<div>
052 is on FRI PM<br><br>as shows <a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562289/ex21.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562289/ex21.PNG" class="fr-fic fr-dib"></a><br><br>
</div>


<div>
052 &nbsp;is&nbsp; an combination&nbsp;
</div>


<div>
<blockquote>
green #99FF99 &nbsp;<br />
<br />
red #FF9999
</blockquote>
I need column 4, not column 3.
</div>


<div>
green&nbsp;<strong>#bfff80</strong>&nbsp;<br>red #ff6666 <br><br><br>sorry but &nbsp;i dont understand &nbsp;!<br><br>
</div>


2021-05-29_09-53-19.png

<div>
yellow (255,255,0)<br><br>red (255,127,80)
</div>


<div>
In your example you don't have anything selected in column 'F' but when I try it I get this.<br />
<br />
En su ejemplo, no tiene nada seleccionado en la columna 'F', pero cuando lo intento, obtengo esto.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562335/2021-05-30_07-08-02.png" target="_blank" title="2021-05-30_07-08-02.png (191 KB)"><img alt="2021-05-30_07-08-02.png" class="file-block lazyload" style="max-width: 612px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562335/2021-05-30_07-08-02.png" /></a>Since 7 and 4 are in 4017 and 2457 and 1 and 0 are in 8011 and 4017, shouldn't they be selected?<br />
<br />
Dado que 7 y 4 están en 4017 y 2457 y 1 y 0 están en 8011 y 4017, ¿no deberían seleccionarse?
</div>


2021-05-30_07-08-02.png

<div>
shouldn't they be selected?<br><br>&nbsp;Yes, you get it&nbsp; rigth . i did not get all because im manually working (a lot of details )
</div>


<div>
For the red, are you saying that I should match the counts in week 1 for example against the ORDs in week 2?<br />
Para el rojo, ¿estás diciendo que debería hacer coincidir los recuentos de la semana 1, por ejemplo, con los ORD de la semana 2?
</div>


<div>
<blockquote>For the red, are you saying that I should match the counts in the current week against the ORDs in the NEXT week?&nbsp;</blockquote><br>the most important are the greens &nbsp;because happens same week<br>i mean very soon <br><br>but &nbsp;<br><br>i realize that many happens too in the &nbsp;next week<br>but i see the red as an second layer not the first &nbsp;(for my the green are priority)<br>then red are second layer<br><br><br>
</div>


<div>
So is this correct?<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562345/2021-05-30_08-05-23.png" target="_blank" title="2021-05-30_08-05-23.png (160 KB)"><img alt="2021-05-30_08-05-23.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w23/800_1562345/2021-05-30_08-05-23.png" /></a>
</div>


2021-05-30_08-05-23.png

<div>
may be &nbsp;an good idea will be create 2 layers each one with one button<br><br>so for exampple i need see &nbsp;same week ( green &nbsp;) y hit the button<br><br>then i need see hit second week i hit the button it clean the same week<br>and shows the second hit layer
</div>


<div>
you can not see any sequence &nbsp; or pattern<br><br>just an table with color
</div>


<div>
<blockquote>
can yiu create an layer ?
</blockquote>
Not easily. How about this where the cells are in both weeks have a red to yellow color gradient?<br />
<br />
No es fácil. ¿Qué tal si las células en ambas semanas tienen un degradado de color rojo a amarillo?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562351/2021-05-30_09-33-41.png" target="_blank" title="2021-05-30_09-33-41.png (153 KB)"><img alt="2021-05-30_09-33-41.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w23/800_1562351/2021-05-30_09-33-41.png" /></a><br />
Those cells have red at the top and yellow at the bottom, but it could be changed to yellow at the top and red at the bottom.
</div>


2021-05-30_09-33-41.png

<div>
That would look like this.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562352/2021-05-30_09-47-00.png" target="_blank" title="2021-05-30_09-47-00.png (174 KB)"><img alt="2021-05-30_09-47-00.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/05_w23/800_1562352/2021-05-30_09-47-00.png" /></a>Hmm, I don't know why the pictures are so different, so for now ignore the difference in selections and just let me know if a two-color gradient is OK.
</div>


2021-05-30_09-47-00.png

<div>
ok this last one you did is more better<br>&nbsp;is ok to me<br><br>can you make an button so i can see with the color and without the color when needed?<br><br>
</div>


29216924a.xlsb

<div>
ok great job <br><br>can be improve with the TIME<br><br>but have an great idea&nbsp; on&nbsp;
</div>


<div>
Great Job <br>Best Expert !
</div>


<div>
i change data &nbsp;to run as needed then i get this<br><br>after hit PLAY button<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562363/ex29.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562363/ex29.PNG" class="fr-fic fr-dii"></a>&nbsp;<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562362/ex28.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562362/ex28.PNG" class="fr-fic fr-dii"></a>
</div>


ex29.PNG

ex28.PNG

<div>
<blockquote>
can be improve with the TIME
</blockquote>
I don't think so.<br />
<br />
Here's a correction for the error.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/05_w23/1562364/29216924b.xlsb" target="_blank" class="file-inline" title="29216924b.xlsb (6.5 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>29216924b.xlsb</a>
</div>


29216924b.xlsb

<div>
<div class="content wysiwyg-content fr-view">
4N by play (eachone)<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562109/29216539--2-_4N_to_add_COunt_byPLAY.xlsm" rel="ugc">29216539 (2)_4N_to_add_COunt_byPLAY.xlsm</a><br><br>1- Sheet "BYPLAY" will be the output<br><br>2- an button by each hit to count AM &nbsp;AND PM &nbsp;by DAY<br><br>example : Monday am = count Monday AM (the begining)<br><br>Monday PM = count Monday AM + Monday PM<br><br>Tuesday AM = Monday AM + MONDAY PM + Tuesday AM = <br><br><br><br><br>
</div>
</div>



4N by play (eachone)
29216539 (2)_4N_to_add_COunt_byPLAY.xlsm
1- Sheet "BYPLAY" will be the output
2- an button by each hit to count AM  AND PM  by DAY
example : Monday am = count Monday AM (the begining)
Monday PM = count Monday AM + Monday PM
Tuesday AM = Monday AM + MONDAY PM + Tuesday AM =

4N Count By each Section

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.