Spreadsheet: 731983d1620734241-excel-formula-that-can-convert-total-units-to-cartons-rolls-and-pieces-help-2
Sheet: cccc

 |  |  |  |  |  | HEAD OFFICE FINISHED GOODS INVENTORY POSITION
 |  |  |  |  |  | cccc
 |  |  |  |  |  | HALL B
DATE | DETAILS | UNIT IN | ROLLS IN | TOTAL |  | RECEIPTS |  |  |  | ISSUES
 | WAYBILL/ INVOICE NO. | A ROLL | A CTN | UNITS/CTN | CARTONS | ROLLS | PCS | T/UNITS | CARTONS | ROLLS | PCS | T/UNITS | CLOSING STOCK
 |  | PACK SIZE
2020-11-03 00:00:00 | BAL B/F | 20 | 27 |  | 6 |  | 224
20/03/2020 | 0008754/D7002058 | 20 | 27 |  |  |  |  |  | 6
26/03/2020 | 0022789/0007263 | 20 | 27 |  |  |  |  |  |  |  | 3
2020-08-05 00:00:00 | 0022174/75E0123 | 20 | 27 |  | 8
2020-08-05 00:00:00 | WWCV/0022177/D7002067 | 20 | 27 |  |  |  |  |  | 8
2020-12-05 00:00:00 | 0007278/75E0123 | 20 | 27 |  | 19
13/05/2020 | 0006775/75E0123 | 20 | 27 |  | 13
13/05/2020 | 0007289/D7002072 | 20 | 27 |  |  |  |  |  | 1 | 23
13/05/2020 | /0007280/D7002070 | 20 | 27 |  |  |  |  |  | 4 | 14
15/05/2020 | OSUN/0008779/0009602 | 20 | 27 |  |  |  |  |  | 1
14/05/2020 | 75E0123/0006779 | 20 | 27 |  | 10
18/05/2020 | 75EO123/0007300 | 20 | 27 |  | 24 | 19 | 4
20/05/2020 | YOLA/003371/0010152 | 20 | 27 |  |  |  |  |  | 5
20/05/2020 | O/0022107/0007291 | 20 | 27 |  |  |  |  |  |  |  | 1
22/05/2020 | BENIN/0011518/0009610 | 20 | 27 |  |  |  |  |  |  | 15
2020-03-06 00:00:00 | /0022195/0010206 | 20 | 27 |  |  |  |  |  | 2
2020-05-06 00:00:00 | ABUJA/002862/0011768 | 20 | 27 |  |  |  |  |  | 4
17/06/2020 | ONITSHA/002869/0011771 | 20 | 27 |  |  |  |  |  | 5
17/06/2020 | APAPA/003390/0011772 | 20 | 27 |  |  |  |  |  | 5
29/06/2020 | AKURE/002881/0011774 | 20 | 27 |  |  |  |  |  | 5
29/06/2020 | EKITI/0022705/0010219 | 20 | 27 |  |  |  |  |  | 2
2020-03-07 00:00:00 | WWCV/0022710/REPLACEMENT | 20 | 27 |  |  |  |  |  |  |  | 8
2020-08-07 00:00:00 | ONITSHA/002892/0011777 | 20 | 27 |  |  |  |  |  | 5
2020-08-07 00:00:00 | BENIN/003392/0011776 | 20 | 27 |  |  |  |  |  | 5
23/07/2020 | ABA/0004952/0011781 | 20 | 27 |  |  |  |  |  | 5
05/08/20 | /0007221/0011789 | 20 | 27 |  |  |  |  |  | 1
12/08/20 | [NAME] | 20 | 27 |  |  |  |  |  | 1
11/08/2020 | GMD/0021602 | 20 | 27 |  |  |  |  |  |  |  | 2
14/08/2020 | 75H0123 | 20 | 27 |  | 28
17/08/2020 | 75H0123 | 20 | 27 |  | 16
20/08/2020 | 75H0123 | 20 | 27 |  | 10
18/08/2020 | 75H0123 | 20 | 27 |  | 16
2020-01-09 00:00:00 | 75H0123 | 20 | 27 |  | 3 | 12 | 14
11/09/2020 | YOBE/0022413/D20200911 | 20 | 27 |  |  |  |  |  | 4 | 22
15/09/2020 | /0021361/0007433 | 20 | 27 |  |  |  |  |  |  |  | 5
26/10/2020 | FMC GUSAU/0004084/0010228 | 20 | 27 |  |  |  |  |  |  |  | 100
30/10/2020 | /0002466/0010229 | 20 | 27 |  |  |  |  |  |  |  | 500
05/11/202 | PSN/0022748/0008342 | 20 | 27 |  |  |  |  |  |  | 5
06/11/2020 | PSN/0004205/0013755 | 20 | 27 |  |  |  |  |  | 5
09/11/2020 | /0004209/0010238 | 20 | 27 |  |  |  |  |  |  |  | 200
27/11/2020 | USAU/0004612/0010240 | 20 | 27 |  |  |  |  |  |  |  | 300
28/11/2020 | N/0006579/0013763 | 20 | 27 |  |  |  |  |  | 2
27/11/2020 | GMD/0003875/0010722 | 20 | 27 |  |  |  |  |  |  |  | 2
28/11/2020 | ACPN/0003881/0010724 | 20 | 27 |  |  |  |  |  |  | 3
04/12/2020 | /0002480/0013764 | 20 | 27 |  |  |  |  |  | 1
14/12/2020 | ILORIN DEPOT 0013773 | 20 | 27 |  |  |  |  |  | 2
16/12/2020 | KANO DEPOT 0013774 | 20 | 27 |  |  |  |  |  | 5
20/01/2021 | AKURE DEPOT 0004235/0013781 | 20 | 27 |  |  |  |  |  | 5
21/01/2021 | KANO DEPOT 0002492/0013783 | 20 | 27 |  |  |  |  |  | 5
21/01/2021 | KADUNA DEPOT 0002493/0013782 | 20 | 27 |  |  |  |  |  | 5
26/01/2021 | LTD 0002929/0008439 | 20 | 27 |  |  |  |  |  |  |  | 2
29/01/2021 | 0006491/0008443 | 20 | 27 |  |  |  |  |  |  |  | 3
29/01/2021 | ABUJA DEPOT 0002495/00102447 | 20 | 27 |  |  |  |  |  |  | 5
2021-12-02 00:00:00 | KADUNA DEPOT 0004239/0010249 | 20 | 27 |  |  |  |  |  |  | 10
23/02/2021 | ABUJA DEPOT 0004260/0011061 | 20 | 27 |  |  |  |  |  | 5
23/02/2021 | YOLA DEPOT 0004258/0011062 | 20 | 27 |  |  |  |  |  | 15
2021-06-04 00:00:00 | APAPA DEPOT 0002382/0011074 | 20 | 27 |  |  |  |  |  | 5
15/04/2021 | ABUJA DEPOT 0003080/0011081 | 20 | 27 |  |  |  |  |  | 3
15/04/2021 | DGMD 0007081/0004124 | 20 | 27 |  |  |  |  |  |  |  | 1
16/04/2021 | [NAME] 0003081/0011080 | 20 | 27 |  |  |  |  |  | 5
20/04/2021 | ONITSHA DEPOT 0003083/0011078 | 20 | 27 |  |  |  |  |  | 3
27/04/2021 | ABULE EGBA DEPOT 0006592/0011088 | 20 | 27 |  |  |  |  |  | 3
28/04/2021 | IBADAN 0004447/0011921 | 20 | 27 |  |  |  |  |  | 3
 |  | 20 | 27