Spreadsheet: 757460d1638278103-how-to-combine-data-from-mutiple-sheets-and-generate-a-report-natraj-yarn-stock-fresh-copy
Sheet: WARP DETAILS

WARPING SECTION
DATE | LOOM NO. | B.NO. | REED SPACE | REED | MTR | ENDS | YARN CODE | YARN | SKU | SHADE NO. | COLOR | ISSUE | QTY USED (KGS) | QTY GRAM/MTR | RECEIVING BACK | STOCK BEFORE (OS) | STOCK AFTER (CS) | P.O. NO.
2021-11-01 00:00:00 | 8 | 1 | 130 | 84 | 850 | 10960 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 305.44 | 289 | 0.34 | 16.44 | 591.11 | 302.11
2021-11-02 00:00:00 | 3 | 2 | 136 | 84 | 1400 | 11450 | WA114 | COTTON | 2-40-COTTON | ELI | ELI | 1391 | 490 | 0.35 | 901 | 1391 | 901
2021-11-03 00:00:00 | 15 | 3 | 97 | 84 | 1000 | 8180 | WA114 | COTTON | 2-40-COTTON | ELI | ELI | 901 | 255 | 0.255 | 646 | 901 | 646
2021-11-06 00:00:00 | 3 | 4 | 136 | 84 | 350 | 11450 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 260.81 | 125.3 | 0.358 | 135.51 | 277.25 | 151.95
2021-11-09 00:00:00 | 10 | 5 | 436 | 84 | 500 | 11620 | WA114 | COTTON | 2-40-COTTON | ELI | ELI | 615 | 175 | 0.35 | 440 | 628.64 | 453.64
2021-11-10 00:00:00 | 5 | 6 | 108 | 168 | 1050 | 18000 | WA05 | POLYESTER | 150*350 BRIGHT | KORA-BRIGHT | KORA-BRIGHT | 377.7 | 336 | 0.32 | 41.7 | 465.4 | 129.4
2021-11-11 00:00:00 | 8 | 7 | 130 | 84 | 1200 | 10960 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 907.72 | 405.6 | 0.338 | 502.12 | 1966.35 | 1560.75
2021-11-11 00:00:00 | 7 | 8 | 136 | 84 | 1100 | 11440 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 502.12 | 391.6 | 0.356 | 110.52 | 1560.75 | 1169.15
2021-11-12 00:00:00 | 4 | 9 | 136 | 84 | 1380 | 11520 | WA115 | POLYESTER | 150 POLYESTER | TAUPE | TAUPE | 319.76 | 273.24 | 0.198 | 46.52 | 632.74 | 359.5
2021-11-13 00:00:00 | 16 | 10 | 108 | 140 | 700 | 15200 | WA02 | POLYESTER | 150*350 BRIGHT | 9151 BRIGHT | 9151 BRIGHT | 219.12 | 192.5 | 0.275 | 26.62 | 272.6 | 80.1
2021-11-15 00:00:00 | 9 | 11 | 136 | 84 | 1200 | 11500 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 907.2 | 427.2 | 0.356 | 480 | 1169.15 | 741.95
2021-11-15 00:00:00 | 10 | 12 | 136 | 84 | 1200 | 11620 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 480 | 427.2 | 0.356 | 52.8 | 741.95 | 314.75
2021-11-16 00:00:00 | 3 | 13 | 136 | 84 | 1200 | 11450 | WA114 | COTTON | 2-40-COTTON | ELI | ELI | 440 | 420 | 0.35 | 20 | 453.64 | 33.64
2021-11-17 00:00:00 | 15 | 14 | 97 | 84 | 100 | 8160 | WA156 | COTTON | 2/60 COTTON | 2/60 COTTON | 2/60 COTTON | 179 | 17 | 0.17 | 162 | 265.095 | 248.095
2021-11-17 00:00:00 | 4 | 15 | 136 | 84 | 500 | 11520 | WA95 | POLYESTER | 150 POLYESTER | TWISTED DOPE BLACK | TWISTED DOPE BLACK | 324 | 101 | 0.202 | 223 | 555.09 | 454.09
2021-11-18 00:00:00 | 4 | 16 | 136 | 84 | 2000 | 11520 | WA95 | POLYESTER | 150 POLYESTER | TWISTED DOPE BLACK | TWISTED DOPE BLACK | 543.36 | 144.36 | 0.198 | 147.36 | 767.41 | 371.41
2021-11-19 00:00:00 | 15 | 17 | 97 | 84 | 1200 | 8160 | WA114 | COTTON | 2-40-COTTON | ELI | ELI | 1215 | 306 | 0.255 | 909 | 1923.64 | 1617.64
2021-11-20 00:00:00 | 3 | 18 | 136 | 84 | 1400 | 11450 | WA114 | COTTON | 2-40-COTTON | ELI | ELI | 909 | 490 | 0.35 | 419 | 1617.64 | 1127.64
2021-11-22 00:00:00 | 8 | 19 | 130 | 84 | 500 | 10960 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 191.38 | 169 | 0.338 | 22.38 | 314.75 | 145.75
2021-11-22 00:00:00 | 4 | 20 | 136 | 84 | 1000 | 11520 | [NAME] | POLYESTER | 150 POLYESTER | SEA GREEN | SEA GREEN | 215.87 | 202 | 0.202 | 13.87 | 215.87 | 13.87
2021-11-24 00:00:00 | 6 | 21 | 108 | 96 | 1300 | 10250 | WA94 | POLYESTER | 150 POLYESTER | KORA TWISTED | KORA TWISTED | 236.495 | 114.4 | 0.088 | 122.095 | 523.781 | 409.381
2021-11-24 00:00:00 | 6 | 21 | 108 | 96 | 1300 | 10250 | WA95 | POLYESTER | 150 POLYESTER | TWISTED DOPE BLACK | TWISTED DOPE BLACK | 220.5 | 114.4 | 0.088 | 106.1 | 454.09 | 339.69
2021-11-25 00:00:00 | 5 | 22 | 108 | 168 | 1100 | 18000 | WA05 | POLYESTER | 150*350 BRIGHT | KORA-BRIGHT | KORA-BRIGHT | 693.32 | 346.5 | 0.315 | 346.82 | 822.72 | 476.22
2021-11-26 00:00:00 | 8 | 23 | 130 | 84 | 1130 | 10960 | WA54 | COTTON | 2-40 COMED | 2-40 COTTON COMED | 2-40 COTTON COMED | 393.12 | 377.42 | 0.334 | 15.7 | 538.87 | 161.45