Spreadsheet: 457177d1461234874-totals-based-on-a-cell-value-test
Sheet: inbound

DS [NAME] packaging Inbound
Load | Date | Quantity |  |  | No | Qty per Pal | DSS pt |  |  |  | Stocks
1 | 19.02.2016 | 26 |  | [NAME] | 1173 | 29.952 | p 26
2 | 22.02.2016 | 26 |  | [NAME] | 1187 | 29.952 | p 26
3 | 22.02.2016 | 26 |  | [NAME] | 1205 | 29.952 | p 26 |  |  |  | Product |  |  | pallets | Qty | DSS pt
4 | 22.02.2016 | 26 |  | [NAME] | 1221 | 29.952 | p 26 |  |  | [NAME] | 9149655 |  |  | 43 | 48.634 | P 26
5 | 23.02.2016 | 26 |  | [NAME] | 1213 | 29.952 | p 26 |  |  | Via [NAME] | 9103764 |  |  | 0 | 0 | P 34
6 | 25.02.2016 | 26 |  | [NAME] | 1229 | 29.808 | p 26 |  |  | [NAME] | 9149653 |  |  | 28 | 32.264 | P 38
7 | 25.02.2016 | 26 |  | [NAME] | 1234 | 29.952 | p 26 |  |  | [NAME] | 9115853 |  |  | 5 | 4.866 | p 29
8 | 25.02.2016 | 17 |  | via spw col sen | 1243 | 18.912 | P 34 |  |  | [NAME] | 9108010 |  |  | 60 | 62.537 | p 28
 |  | 9 |  | [NAME] | 1243 | 10.368 | P 38 |  |  | [NAME] | 9073927 |  |  | 0 | 0 | p 32
9 | 26.02.2016 | 26 |  | [NAME] | 1255 | 29.952 | P 38 |  |  | [NAME] | 9108007 |  |  | 64 | 73.392 | p 27
10 | 29.02.2016 | 13 |  | [NAME] | 1266 | 14.544 | P 38 |  |  | [NAME] | 9115851 |  |  | 72 | 82.176 | p 30
 |  | 13 |  | [NAME] | 1266 | 14.976 | P 26 |  |  | Viavia spw | 9103759 |  |  | 61 | 70.272 | p 33
11 | 29.02.2016 | 26 |  | [NAME] | 1262 | 29.952 | P 38 |  |  | omo lspw | 9146398 |  |  | 31 | 34.752 | p 36
12 | 01.03.2016 | 9 |  | [NAME] | 1295 | 10.368 | p 26
 | 01.03.2016 | 17 |  | [NAME] | 1295 | 19.584 | p 29
13 | 02.03.2016 | 26 |  | [NAME] | 1294 | 29.952 | p 28
14 | 04.03.2016 | 11 |  | [NAME] | 1307 | 12.672 | p 28
 |  | 15 |  | [NAME] | 1307 | 16.512 | p 32 |  |  |  |  |  |  | 364 | 408.893
15 | 04.03.2016 | 26 |  | [NAME] | 1308 | 29.952 | p 27
16 | 09.03.2016 | 10 |  | [NAME] | 1349 | 11.52 | p 26
 |  | 7 |  | [NAME] | 1349 | 8.064 | p 27
 |  | 6 |  | [NAME] | 1349 | 6.912 | p 28 |  |  | Quarantine Stock
 |  | 1 |  | [NAME] | 1349 | 0.672 | p 29
 |  | 2 |  | [NAME] | 1349 | 2.304 | p 30
17 | 09.03.2016 | 26 |  | [NAME] | 1342 | 29.952 | p 30
18 | 09.03.2016 | 20 |  | [NAME] | 1341 | 23.04 | p 26
 |  | 6 |  | [NAME] | 1341 | 6.912 | p 30
19 | 10.03.2016 | 26 |  | viavia spw | 1369 | 29.952 | p 33
20 | 10.03.2016 | 14 |  | omo lspw | 1375 | 16.128 | p 36
 |  | 12 |  | omo lspw | 1375 | 13.824 | p 36
21 | 14.03.2016 | 26 |  | [NAME] | 1407 | 29.952 | p 38
22 | 14.03.2016 | 26 |  | [NAME] | 1397 | 29.952 | p 38
23 | 14.03.2016 | 26 |  | [NAME] | 1427 | 29.952 | p 26
24 | 15.03.2016 | 26 |  | [NAME] | 1409 | 29.952 | p 26
25 | 15.03.2016 | 26 |  | [NAME] | 1400 | 29.952 | p 38
26 | 15.03.2016 | 26 |  | [NAME] | 1399 | 29.952 | p 26
27 | 15.03.2016 | 10 |  | [NAME] | 1391 | 10.752 | p 30
 |  | 13 |  | omo lspw | 1391 | 14.016 | p 36
 |  | 5 |  | [NAME] | 1391 | 5.76 | p 38
28 | 16.03.2016 | 8 |  | [NAME] | 1410 | 9.216 | p 26
 |  | 5 |  | viavia spw | 1410 | 5.76 | p 33
 |  | 13 |  | [NAME] | 1410 | 14.976 | p 38
29 | 13.03.2016 | 22 |  | [NAME] | 1424 | 25.344 | p 26
 |  | 3 |  | viavia spw | 1424 | 3.456 | p 33
 |  | 1 |  | [NAME] | 1424 | 0.864 | p 38
30 | 17.03.2016 | 26 |  | [NAME] | 1443 | 29.952 | p 26
31 | 17.03.2016 | 26 |  | [NAME] | 1436 | 29.952 | p 26
32 | 21.03.2016 | 22 |  | [NAME] | 1471 | 25.344 | p 26
 |  | 4 |  | [NAME] | 1471 | 4.608 | p 30
33 | 21.03.2016 | 26 |  | [NAME] | 1472 | 29.952 | p 30
34 | 23.03.2016 | 26 |  | viavia spw | 1488 | 29.952 | p 33
35 | 23.03.2016 | 13 |  | [NAME] | 1504 | 14.976 | p 30
 |  | 8 |  | via spw col sen | 1504 | 9.216 | p 34
 |  | 5 |  | viavia spw col | 1505 | 5.76 | p 33
36 | 24.03.2016 | 15 |  | viavia spw col | 1507 | 17.28 | p 33
 |  | 11 |  | [NAME] | 1507 | 12.672 | p 38
37 | 24.03.2016 | 26 |  | [NAME] | 1517 | 29.952 | p 38
38 | 24.03.2016 | 26 |  | [NAME] | 1521 | 29.952 | p 38
39 | 29.03.2016 | 26 |  | [NAME] | 1539 | 29.952 | p 26
40 | 29.03.2016 | 26 |  | [NAME] | 1552 | 29.952 | p 29
41 | 29.03.2016 | 26 |  | [NAME] | 1547 | 29.952 | p 26
42 | 29.03.2016 | 26 |  | [NAME] | 1534 | 29.952 | p 38
43 | 30.03.2016 | 26 |  | [NAME] shine | 1559 | 29.952 | p 27
44 | 30.03.2016 | 26 |  | [NAME] shine | 1571 | 29.952 | p 27
45 | 31.04.2016 | 23 |  | [NAME] shine | 1573 | 26.16 | p 27
 |  | 2 |  | [NAME] | 1572 | 1.68 | p 29
 |  | 1 |  | [NAME] | 1572 | 1.152 | p 38
46 | 01.04.2016 | 2 |  | [NAME] | 1582 | 2.304 | p 26
 |  | 24 |  | [NAME] | 1582 | 27.648 | p 26
47 | 01.04.2016 | 16 |  | [NAME] |  | 18.432 | p 26 |  |  | Brought back put in quarenteen from unilever
48 | 04.04.2016 | 26 |  | [NAME] | 1598 | 29.952 | p 26
49 | 04.04.2016 | 8 |  | [NAME] | 1611 | 9.216 | p 26
 |  | 8 |  | [NAME] | 1611 | 9.216 | p 26
 |  | 10 |  | [NAME] | 1611 | 11.52 | p 30
50 | 04.04.2016 | 26 |  | [NAME] | 1612 | 29.952 | p 26
51 | 05.04.2016 | 26 |  | [NAME] | 1624 | 29.952 | p 38
52 | 06.04.2016 | 17 |  | [NAME] | 1644 | 19.584 | p 26
 |  | 9 |  | [NAME] | 1644 | 10.368 | p 38
53 | 07.04.2016 | 24 |  | [NAME] | 1649 | 27.648 | p 26
 |  | 2 |  | [NAME] | 1649 | 2.304 | p 38
54 | 07.04.2016 | 26 |  | [NAME] shine | 1656 | 29.952 | p 27
55 | 08.04.2016 | 10 |  | [NAME] shine | 1680 | 11.52 | p 27
 |  | 11 |  | [NAME] | 1680 | 12.672 | p 30
 |  | 5 |  | [NAME] | 1680 | 5.76 | p 38
56 | 08.04.2016 | 8 |  | [NAME] | 1673 | 9.216 | p 26
 |  | 18 |  | viavia spw col | 1673 | 20.736 | p 33
57 | 08.04.2016 | 15 |  | [NAME] | 1679 | 17.28 | p 30
 |  | 11 |  | [NAME] | 1679 | 12.672 | p 30
58 | 08.04.2016 | 4 |  | [NAME] | 1696 | 4.608 | p 26
 |  | 6 |  | [NAME] | 1696 | 6.912 | p 26
 |  | 7 |  | [NAME] | 1696 | 8.064 | p 30
 |  | 9 |  | viavia spw col | 1696 | 10.224 | p 34
59 | 11.04.2016 | 10 |  | [NAME] |  | 11.52 | p 26 |  |  | Brought back from unilever
60 | 13.04.2016 | 3 |  | [NAME] | 1721 | 3.456 | p 26
 |  | 23 |  | [NAME] | 1721 | 26.496 | p 26
61 | 14.04.2016 | 16 |  | [NAME] | 1737 | 18.432 | p 26
 |  | 10 |  | [NAME] | 1737 | 11.52 | p 30
62 | 15.04.2016 | 26 |  | [NAME] | 1745 | 29.952 | p 38
63 | 15.04.2016 | 26 |  | [NAME] | 1738 | 29.952 | p 26
64 | 18.04.2016 | 26 |  | viavia spw col | 1763 | 29.952 | p 33
65 | 18.04.2016 | 15 |  | viavia spw col | 1770 | 17.28 | p 33
 |  | 11 |  | [NAME] | 1770 | 12.672 | p 38
66 | 18.04.2016 | 15 |  | [NAME] | 1776 | 16.368 | p 26
 |  | 10 |  | [NAME] shine | 1776 | 10.937 | p 28
67 | 18.04.2016 | 26 |  | [NAME] | 1769 | 29.952 | p 38
68 | 18.04.2016 | 26 |  | [NAME] shine | 1775 | 29.952 | p 28
69 | 20.04.2016 | 13 |  | [NAME] shine | 1778 | 14.976 | p 27
 |  | 1 |  | viavia spw col | 1778 | 1.152 | p 33
 |  | 8 |  | [NAME] | 1778 | 9.216 | p 38
 |  | 4 |  | [NAME] | 1779 | 4.608 | p 26