Spreadsheet: 131159d1322765094-three-sided-lookup-samples-02
Sheet: Data

ABC & CO
Products | Pack Size | Opening | New Production | Re-Work | Received | Transferred | Samples Issued | Closing
LUDHYANA WH
Category-01
Aerosol | 150-Mls. | 25 | 345 | 0 | 800 | 0 | 100 | 1070
Star | 50-Mls. | 33 | 355 | 0 | 0 | 250 | 0 | 138
Copper | 25-Gms. | 0 | 566 | 0 | 500 | 300 | 0 | 766
Star-01 | 50-Mls. | 20 | 585 | 0 | 0 | 0 | 0 | 605
Star-02 | 1-Kg. | 0 | 200 | 0 | 200 | 100 | 0 | 300
Star-02 | 250-Gms. | 54 | 236 | 0 | 1000 | 300 | 0 | 990
Category-02
Furadon | 8-Kgs. | 207 | 25 | 0 | 1450 | 3 | 0 | 1679
Category-03
Bricks | 400-Mls. | 109 | 360 | 0 | 0 | 0 | 0 | 469
Chips | 1-Ltr. | 115 | 300 | 0 | 1180 | 0 | 0 | 1595
Chops | 25-Mls. | 0 | 200 | 0 | 800 | 530 | 50 | 420
Zoops | 1000-Gms. | 21 | 500 | 0 | 0 | 0 | 0 | 521
Reptile | 25-Mls. | 0 | 260 | 0 | 2950 | 201 | 50 | 2959
Peptile | 800-Gms. | 0 | 2500 | 0 | 254 | 6 | 0 | 2748
Category-05
[NAME] | 25-Kgs. | 2 | 200 | 300 | 0 | 0 | 0 | 502
Brazila | 150-Mls. | 55 | 100 | 0 | 151 | 0 | 0 | 306
Bonzee | 800-Gms. | 63 | 22 | 0 | 177 | 8 | 0 | 254
Chloro | 500-Mls. | 23 | 55 | 0 | 0 | 0 | 0 | 78
[NAME] | 250-Gms. | 116 | 58 | 0 | 500 | 1000 | 100 | -426
Bundles | 100-Gms. | 179 | 800 | 0 | 1000 | 0 | 0 | 1979
Shutter | 50-Gms. | 8 | 600 | 0 | 1400 | 0 | 0 | 2008
Delta | 750-Mls. |  | 700 | 0 | 40 | 0 | 0 | 740
Ochta | 400-Mls. | 22 | 750 | 0 | 1787 | 0 | 0 | 2559
Hexa | 400-Mls. | 99 | 650 | 350 | 3000 | 0 | 0 | 4099
[NAME] | 1000-Gms. | 5 | 850 | 0 | 800 | 0 | 0 | 1655
[NAME] | 10-Kgs. | 0 | 250 | 0 | 20 | 0 | 0 | 270
Silky | 1000-Gms. | 29 | 360 | 250 | 0 | 0 | 0 | 639
Silky | 25-Mls. | 20 | 250 | 0 | 1100 | 1880 | 80 | -590
Silky | 20-Ltrs. | 1 | 0 | 0 | 0 | 0 | 0 | 1
Silky | 500-Mls. | 0 | 0 | 0 | 1240 | 500 | 0 | 740
Toot | 25-Mls. | 79 | 0 | 0 | 0 | 0 | 0 | 79
Tulip | 250-Gms. | 0 | 0 | 0 | 1000 | 0 | 0 | 1000
Tycoon | 400-Mls. | 62 | 0 | 0 | 1500 | 5 | 0 | 1557
Tycoon | 400-Mls. | 0 | 0 | 0 | 300 | 0 | 0 | 300
Victory | 250-Gms. | 62 | 0 | 0 | 650 | 3 | 0 | 709
Category-04
Zinc 1% | 25-Mls. | 1 | 100 | 0 | 0 | 16 | 10 | 75
Bloom | 500-Mls. | 26 | 500 | 0 | 2000 | 0 | 0 | 2526
Copper Liquid | 500-Mls. | 20 | 200 | 250 | 0 | 0 | 0 | 470
Amonia | 25-Mls. | 0 | 360 | 0 | 1000 | 0 | 0 | 1360
Basic | 24-Kgs. | 4 | 502 | 0 | 150 | 100 | 2 | 554
Nutri | 4-kgs. | 19 | 203 | 0 | 400 | 0 | 0 | 622
Best | 3-Ltrs. | 0 | 320 | 280 | 2640 | 56 | 0 | 3184
Fixer | 54-Ltrs. | 11 | 820 | 0 | 20 | 0 | 0 | 851
Fixer | 500-Mls. | 0 | 0 | 0 | 500 | 0 | 0 | 500
Zinc 5% | 200-Ltrs. | 0 | 250 | 0 | 0 | 20 | 2 | 228
Zinc 5% | 3-Ltrs. | 0 | 350 | 0 | 1000 | 20 | 0 | 1330
Zinc 5% | 54-Ltrs. | 1 | 150 | 660 | 0 | 0 | 0 | 811
Zinc 5% | 1-Ltr. | 76 | 450 | 0 | 0 | 2 | 0 | 524
[NAME] | 50-Gms. | 83 | 100 | 250 | 0 | 0 | 0 | 433
[NAME] | 100-Gms. | 40 | 0 | 0 | 650 | 150 | 0 | 540
Potash | 200-Ltrs. | 5 | 20 | 2 | 300 | 150 | 0 | 177
HARYANA WH
Category-01
Aerosol | 150-Mls. | 75 | 395 | 50 | 850 | 50 | 150 | 1120
Star | 50-Mls. | 83 | 405 | 50 | 50 | 300 | 50 | 188
Star-01 | 50-Mls. | 70 | 635 | 50 | 50 | 50 | 50 | 655
[NAME] | 25-Gms. | 100 | 412 | 50 | 50 | 300 | 50 | 212
Oracle 20SC | 50-Mls. | 63 | 306 | 50 | 50 | 150 | 50 | 219
Star-02 | 1-Kg. | 50 | 250 | 50 | 250 | 150 | 50 | 350
Star-02 | 250-Gms. | 104 | 286 | 50 | 1050 | 350 | 50 | 1040
Category-02 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
Furadon | 8-Kgs. | 257 | 75 | 50 | 1500 | 53 | 50 | 1729
Category-03 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
Bricks | 400-Mls. | 159 | 410 | 50 | 50 | 50 | 50 | 519
Chips | 1-Ltr. | 165 | 350 | 50 | 1230 | 50 | 50 | 1645
Chops | 25-Mls. | 50 | 250 | 50 | 850 | 580 | 100 | 470
Zoops | 1000-Gms. | 71 | 550 | 50 | 50 | 50 | 50 | 571
Cool | 25-Mls. | 50 | 350 | 50 | 68 | 50 | 50 | 368
Cooler | 25-Mls. | 70 | 300 | 50 | 50 | 50 | 50 | 320
Reptile | 25-Mls. | 50 | 310 | 50 | 3000 | 251 | 100 | 3009
Peptile | 800-Gms. | 50 | 2550 | 50 | 304 | 56 | 50 | 2798
Category-05 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
[NAME] | 25-Kgs. | 52 | 250 | 350 | 50 | 50 | 50 | 552
Brazila | 150-Mls. | 105 | 150 | 50 | 201 | 50 | 50 | 356
Bonzee | 800-Gms. | 113 | 72 | 50 | 227 | 58 | 50 | 304
Chloro | 500-Mls. | 73 | 105 | 50 | 50 | 50 | 50 | 128
[NAME] | 50-Mls. | 121 | 386 | 250 | 1050 | 50 | 100 | 1607
Confident | 400-Mls. | 112 | 86 | 50 | 1550 | 50 | 50 | 1648
[NAME] | 250-Gms. | 166 | 108 | 50 | 550 | 1050 | 150 | -376
Ochta | 400-Mls. | 72 | 800 | 50 | 1837 | 50 | 50 | 2609
Hexa | 400-Mls. | 149 | 700 | 400 | 3050 | 50 | 50 | 4149
[NAME] | 1000-Gms. | 55 | 900 | 50 | 850 | 50 | 50 | 1705
[NAME] | 10-Kgs. | 50 | 300 | 50 | 70 | 50 | 50 | 320
Silky | 1000-Gms. | 79 | 410 | 300 | 50 | 50 | 50 | 689
Silky | 25-Mls. | 70 | 300 | 50 | 1150 | 1930 | 130 | -540
Silky | 20-Ltrs. | 51 | 50 | 50 | 50 | 50 | 50 | 51
Silky | 500-Mls. | 50 | 50 | 50 | 1290 | 550 | 50 | 790
Toot | 25-Mls. | 129 | 50 | 50 | 50 | 50 | 50 | 129
Tulip | 250-Gms. | 50 | 50 | 50 | 1050 | 50 | 50 | 1050
Tycoon | 400-Mls. | 112 | 50 | 50 | 1550 | 55 | 50 | 1607
Tycoon | 400-Mls. | 50 | 50 | 50 | 350 | 50 | 50 | 350
Victory | 250-Gms. | 112 | 50 | 50 | 700 | 53 | 50 | 759
Category-04 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
Zinc 1% | 25-Mls. | 51 | 150 | 50 | 50 | 66 | 60 | 125
Bloom | 500-Mls. | 76 | 550 | 50 | 2050 | 50 | 50 | 2576
Amonia | 25-Mls. | 50 | 410 | 50 | 1050 | 50 | 50 | 1410
Basic | 24-Kgs. | 54 | 552 | 50 | 200 | 150 | 52 | 604
Nutri | 4-kgs. | 69 | 253 | 50 | 450 | 50 | 50 | 672
Best | 3-Ltrs. | 50 | 370 | 330 | 2690 | 106 | 50 | 3234
Fixer | 54-Ltrs. | 61 | 870 | 50 | 70 | 50 | 50 | 901
Fixer | 500-Mls. | 50 | 50 | 50 | 550 | 50 | 50 | 550
Zinc 5% | 200-Ltrs. | 50 | 300 | 50 | 50 | 70 | 52 | 278
Zinc 5% | 3-Ltrs. | 50 | 400 | 50 | 1050 | 70 | 50 | 1380
Zinc 5% | 54-Ltrs. | 51 | 200 | 710 | 50 | 50 | 50 | 861
Zinc 5% | 1-Ltr. | 126 | 500 | 50 | 50 | 52 | 50 | 574
[NAME] | 25-Gms. | 133 | 250 | 50 | 50 | 300 | 50 | 83
[NAME] | 50-Gms. | 133 | 150 | 300 | 50 | 50 | 50 | 483
[NAME] | 100-Gms. | 90 | 50 | 50 | 700 | 200 | 50 | 590
Potash | 200-Ltrs. | 55 | 70 | 52 | 350 | 200 | 50 | 227
HYDERABAD WH
Category-01
Aerosol | 150-Mls. | 75 | 395 | 50 | 850 | 50 | 150 | 1120
Star | 50-Mls. | 83 | 405 | 50 | 50 | 300 | 50 | 188
Copper | 25-Gms. | 50 | 616 | 50 | 550 | 350 | 50 | 816
Star-01 | 50-Mls. | 70 | 635 | 50 | 50 | 50 | 50 | 655
[NAME] | 25-Gms. | 100 | 412 | 50 | 50 | 300 | 50 | 212
Oracle 20SC | 50-Mls. | 63 | 306 | 50 | 50 | 150 | 50 | 219
Star-02 | 1-Kg. | 50 | 250 | 50 | 250 | 150 | 50 | 350
Star-02 | 250-Gms. | 104 | 286 | 50 | 1050 | 350 | 50 | 1040
Category-02 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
Furadon | 8-Kgs. | 257 | 75 | 50 | 1500 | 53 | 50 | 1729
Category-03 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
Bricks | 400-Mls. | 159 | 410 | 50 | 50 | 50 | 50 | 519
Zoops | 1000-Gms. | 71 | 550 | 50 | 50 | 50 | 50 | 571
Cool | 25-Mls. | 50 | 350 | 50 | 68 | 50 | 50 | 368
Cooler | 25-Mls. | 70 | 300 | 50 | 50 | 50 | 50 | 320
Reptile | 25-Mls. | 50 | 310 | 50 | 3000 | 251 | 100 | 3009
Peptile | 800-Gms. | 50 | 2550 | 50 | 304 | 56 | 50 | 2798
Category-05 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
[NAME] | 25-Kgs. | 52 | 250 | 350 | 50 | 50 | 50 | 552
Brazila | 150-Mls. | 105 | 150 | 50 | 201 | 50 | 50 | 356
Chloro | 500-Mls. | 73 | 105 | 50 | 50 | 50 | 50 | 128
[NAME] | 50-Mls. | 121 | 386 | 250 | 1050 | 50 | 100 | 1607
Confident | 400-Mls. | 112 | 86 | 50 | 1550 | 50 | 50 | 1648
[NAME] | 250-Gms. | 166 | 108 | 50 | 550 | 1050 | 150 | -376
Bundles | 100-Gms. | 229 | 850 | 50 | 1050 | 50 | 50 | 2029
Shutter | 50-Gms. | 58 | 650 | 50 | 1450 | 50 | 50 | 2058
Delta | 750-Mls. | 50 | 750 | 50 | 90 | 50 | 50 | 790
Ochta | 400-Mls. | 72 | 800 | 50 | 1837 | 50 | 50 | 2609
Hexa | 400-Mls. | 149 | 700 | 400 | 3050 | 50 | 50 | 4149
[NAME] | 1000-Gms. | 55 | 900 | 50 | 850 | 50 | 50 | 1705
[NAME] | 10-Kgs. | 50 | 300 | 50 | 70 | 50 | 50 | 320
Silky | 1000-Gms. | 79 | 410 | 300 | 50 | 50 | 50 | 689
Silky | 25-Mls. | 70 | 300 | 50 | 1150 | 1930 | 130 | -540
Silky | 20-Ltrs. | 51 | 50 | 50 | 50 | 50 | 50 | 51
Silky | 500-Mls. | 50 | 50 | 50 | 1290 | 550 | 50 | 790
Toot | 25-Mls. | 129 | 50 | 50 | 50 | 50 | 50 | 129
Tulip | 250-Gms. | 50 | 50 | 50 | 1050 | 50 | 50 | 1050
Tycoon | 400-Mls. | 112 | 50 | 50 | 1550 | 55 | 50 | 1607
Tycoon | 400-Mls. | 50 | 50 | 50 | 350 | 50 | 50 | 350
Victory | 250-Gms. | 112 | 50 | 50 | 700 | 53 | 50 | 759
Category-04 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
Zinc 1% | 25-Mls. | 51 | 150 | 50 | 50 | 66 | 60 | 125
Bloom | 500-Mls. | 76 | 550 | 50 | 2050 | 50 | 50 | 2576
Copper Liquid | 500-Mls. | 70 | 250 | 300 | 50 | 50 | 50 | 520
Amonia | 25-Mls. | 50 | 410 | 50 | 1050 | 50 | 50 | 1410
Basic | 24-Kgs. | 54 | 552 | 50 | 200 | 150 | 52 | 604
Nutri | 4-kgs. | 69 | 253 | 50 | 450 | 50 | 50 | 672
Best | 3-Ltrs. | 50 | 370 | 330 | 2690 | 106 | 50 | 3234
Fixer | 54-Ltrs. | 61 | 870 | 50 | 70 | 50 | 50 | 901
Fixer | 500-Mls. | 50 | 50 | 50 | 550 | 50 | 50 | 550
Zinc 5% | 200-Ltrs. | 50 | 300 | 50 | 50 | 70 | 52 | 278
Zinc 5% | 3-Ltrs. | 50 | 400 | 50 | 1050 | 70 | 50 | 1380
Zinc 5% | 54-Ltrs. | 51 | 200 | 710 | 50 | 50 | 50 | 861
Zinc 5% | 1-Ltr. | 126 | 500 | 50 | 50 | 52 | 50 | 574
[NAME] | 25-Gms. | 133 | 250 | 50 | 50 | 300 | 50 | 83
[NAME] | 50-Gms. | 133 | 150 | 300 | 50 | 50 | 50 | 483
[NAME] | 100-Gms. | 90 | 50 | 50 | 700 | 200 | 50 | 590
Potash | 200-Ltrs. | 55 | 70 | 52 | 350 | 200 | 50 | 227
AHMADABAD WH
Category-01
Aerosol | 150-Mls. | 50 | 370 | 25 | 825 | 25 | 125 | 1095
Star | 50-Mls. | 58 | 380 | 25 | 25 | 275 | 25 | 163
Copper | 25-Gms. | 25 | 591 | 25 | 525 | 325 | 25 | 791
Star-01 | 50-Mls. | 45 | 610 | 25 | 25 | 25 | 25 | 630
[NAME] | 25-Gms. | 75 | 387 | 25 | 25 | 275 | 25 | 187
Oracle 20SC | 50-Mls. | 38 | 281 | 25 | 25 | 125 | 25 | 194
Star-02 | 1-Kg. | 25 | 225 | 25 | 225 | 125 | 25 | 325
Star-02 | 250-Gms. | 79 | 261 | 25 | 1025 | 325 | 25 | 1015
Category-03 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25
Bricks | 400-Mls. | 134 | 385 | 25 | 25 | 25 | 25 | 494
Chips | 1-Ltr. | 140 | 325 | 25 | 1205 | 25 | 25 | 1620
Chops | 25-Mls. | 25 | 225 | 25 | 825 | 555 | 75 | 445
Cool | 25-Mls. | 25 | 325 | 25 | 43 | 25 | 25 | 343
Cooler | 25-Mls. | 45 | 275 | 25 | 25 | 25 | 25 | 295
Reptile | 25-Mls. | 25 | 285 | 25 | 2975 | 226 | 75 | 2984
Peptile | 800-Gms. | 25 | 2525 | 25 | 279 | 31 | 25 | 2773
Category-05 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25
[NAME] | 25-Kgs. | 27 | 225 | 325 | 25 | 25 | 25 | 527
Brazila | 150-Mls. | 80 | 125 | 25 | 176 | 25 | 25 | 331
Bonzee | 800-Gms. | 88 | 47 | 25 | 202 | 33 | 25 | 279
Chloro | 500-Mls. | 48 | 80 | 25 | 25 | 25 | 25 | 103
[NAME] | 50-Mls. | 96 | 361 | 225 | 1025 | 25 | 75 | 1582
Confident | 400-Mls. | 87 | 61 | 25 | 1525 | 25 | 25 | 1623
[NAME] | 250-Gms. | 141 | 83 | 25 | 525 | 1025 | 125 | -401
Bundles | 100-Gms. | 204 | 825 | 25 | 1025 | 25 | 25 | 2004
Shutter | 50-Gms. | 33 | 625 | 25 | 1425 | 25 | 25 | 2033
Delta | 750-Mls. | 25 | 725 | 25 | 65 | 25 | 25 | 765
Ochta | 400-Mls. | 47 | 775 | 25 | 1812 | 25 | 25 | 2584
Hexa | 400-Mls. | 124 | 675 | 375 | 3025 | 25 | 25 | 4124
[NAME] | 1000-Gms. | 30 | 875 | 25 | 825 | 25 | 25 | 1680
[NAME] | 10-Kgs. | 25 | 275 | 25 | 45 | 25 | 25 | 295
Silky | 1000-Gms. | 54 | 385 | 275 | 25 | 25 | 25 | 664
Silky | 25-Mls. | 45 | 275 | 25 | 1125 | 1905 | 105 | -565
Silky | 20-Ltrs. | 26 | 25 | 25 | 25 | 25 | 25 | 26
Silky | 500-Mls. | 25 | 25 | 25 | 1265 | 525 | 25 | 765
Toot | 25-Mls. | 104 | 25 | 25 | 25 | 25 | 25 | 104
Tulip | 250-Gms. | 25 | 25 | 25 | 1025 | 25 | 25 | 1025
Tycoon | 400-Mls. | 87 | 25 | 25 | 1525 | 30 | 25 | 1582
Tycoon | 400-Mls. | 25 | 25 | 25 | 325 | 25 | 25 | 325
Victory | 250-Gms. | 87 | 25 | 25 | 675 | 28 | 25 | 734
Category-04 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25
Zinc 1% | 25-Mls. | 26 | 125 | 25 | 25 | 41 | 35 | 100
Bloom | 500-Mls. | 51 | 525 | 25 | 2025 | 25 | 25 | 2551
Amonia | 25-Mls. | 25 | 385 | 25 | 1025 | 25 | 25 | 1385
Basic | 24-Kgs. | 29 | 527 | 25 | 175 | 125 | 27 | 579
Nutri | 4-kgs. | 44 | 228 | 25 | 425 | 25 | 25 | 647
Best | 3-Ltrs. | 25 | 345 | 305 | 2665 | 81 | 25 | 3209
Fixer | 54-Ltrs. | 36 | 845 | 25 | 45 | 25 | 25 | 876
Fixer | 500-Mls. | 25 | 25 | 25 | 525 | 25 | 25 | 525
Zinc 5% | 200-Ltrs. | 25 | 275 | 25 | 25 | 45 | 27 | 253
Zinc 5% | 3-Ltrs. | 25 | 375 | 25 | 1025 | 45 | 25 | 1355
Zinc 5% | 54-Ltrs. | 26 | 175 | 685 | 25 | 25 | 25 | 836
Zinc 5% | 1-Ltr. | 101 | 475 | 25 | 25 | 27 | 25 | 549
[NAME] | 25-Gms. | 108 | 225 | 25 | 25 | 275 | 25 | 58
[NAME] | 50-Gms. | 108 | 125 | 275 | 25 | 25 | 25 | 458
[NAME] | 100-Gms. | 65 | 25 | 25 | 675 | 175 | 25 | 565
Potash | 200-Ltrs. | 30 | 45 | 27 | 325 | 175 | 25 | 202
JAIPUR WH
Category-05 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25
[NAME] | 25-Kgs. | 27 | 225 | 325 | 25 | 25 | 25 | 527
Brazila | 150-Mls. | 80 | 125 | 25 | 176 | 25 | 25 | 331
Bonzee | 800-Gms. | 88 | 47 | 25 | 202 | 33 | 25 | 279
Chloro | 500-Mls. | 48 | 80 | 25 | 25 | 25 | 25 | 103
[NAME] | 50-Mls. | 96 | 361 | 225 | 1025 | 25 | 75 | 1582
Silky | 1000-Gms. | 54 | 385 | 275 | 25 | 25 | 25 | 664
Silky | 25-Mls. | 45 | 275 | 25 | 1125 | 1905 | 105 | -565
Toot | 25-Mls. | 104 | 25 | 25 | 25 | 25 | 25 | 104
Tulip | 250-Gms. | 25 | 25 | 25 | 1025 | 25 | 25 | 1025
Tycoon | 400-Mls. | 87 | 25 | 25 | 1525 | 30 | 25 | 1582
Tycoon | 400-Mls. | 25 | 25 | 25 | 325 | 25 | 25 | 325
Victory | 250-Gms. | 87 | 25 | 25 | 675 | 28 | 25 | 734
Category-04 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25
Zinc 1% | 25-Mls. | 26 | 125 | 25 | 25 | 41 | 35 | 100
Bloom | 500-Mls. | 51 | 525 | 25 | 2025 | 25 | 25 | 2551
[NAME] | 100-Gms. | 65 | 25 | 25 | 675 | 175 | 25 | 565
Potash | 200-Ltrs. | 30 | 45 | 27 | 325 | 175 | 25 | 202