Spreadsheet: 761248d1640777358-combine-multiple-rows-data-in-to-one-row-joining-data-1-
Sheet: Pivot

Month clearance | JOB | Customer | SO | Date of Entry | Total Job Wt. | Total Job Shipped | Total Job Ship. Bal. | Total Job Release | Total Job Release Bal. | Shipment Plan | Month Ship. Plan | [NAME] | Ship ment Bal. | PBNS | Rel. Bal. | Prod. Bal. | [NAME]. | WIP | B-up | CF | SH | NP |  |  |  | Month clearance | JOB | Phases Cleared | Phases Yet to Clear | LC / BG | Paint Spec. | Remarks | Month Ship ment | Month Ship. Plan
1 Cleared for Shipment | HY-06323 | THE SUPREME INDUSTRIES | Delhi | 2021-09-30 00:00:00 | 789 | 242.149 | 546.851 | 0 | 789 | 607.718 | 607.718 | 42.698 | 565.02 | 206.239 | 17.29799999999999 | 326.676 |  | 287.247 | 156.797 | 41.789 | 88.661 | 32.105 |  |  |  | 1 Cleared for Shipment | HY-06323 | A1/2,3,4,5,62,63,64,65,99,B1/2,3,4,99,C1/2,3,4,99 |  | LC 30/12 | M | 0 | 42.698 | 607.718
 | HY-05856 | AMARA RAJA INFRA | Chennai | 2020-03-03 00:00:00 | 2229 | 844.4389999999999 | 1384.561 | 0.054 | 2228.946 | 407.286 | 407.286 | 16.638 | 390.648 | 56.33 | 0 | 326.185 |  | 326.189 | 123.76 | 46.884 | 0 | 8.133 |  |  |  |  | HY-05856 | A1/15,16,B1/2 |  | LC 28/01 | M | 0 | 16.638 | 407.286
 | HY-06237 | GS PEB & CIVIL WORKS | Pune | 2021-04-30 00:00:00 | 2669 | 1378.005 | 1290.995 | 826.2059999999999 | 1842.794 | 312.995 | 312.995 | 30.622 | 282.373 | 144.116 | 38.23399999999998 | 62.38899999999998 |  | 24.155 | 21.772 | 2.383 | 0 | 75.868 |  |  |  |  | HY-06237 | A1/12,13,97,99 |  | BG 31/12 | M | 0 | 30.622 | 312.995
 | HY-06284 | SVG EXPORTS | Bengaluru | 2021-07-31 00:00:00 | 997.924 | 365.698 | 632.226 | 0 | 997.924 | 288.964 | 288.964 | 127.028 | 161.936 | 113.122 | 1.962999999999967 | 44.20799999999997 |  | 42.245 | 15.158 | 27.087 | 0 | 4.606 |  |  |  |  | HY-06284 | A1/2,3 |  | 0 | M | 0 | 127.028 | 288.964
 | [NAME] | HINTASTICA | Hyderabad | 2021-08-27 00:00:00 | 827 | 578.3299999999999 | 248.6700000000001 | 0 | 827 | 237.282 | 237.282 | 190.888 | 46.39400000000001 | 17.172 | 0.7300000000000075 | 25.96200000000001 |  | 25.232 | 18.864 | 6.368 | 0 | 3.26 |  |  |  |  | [NAME] | A1/4 |  | 0 | M | 0 | 190.888 | 237.282
 | HY-06281 | ROYAL ENFIELD | Chennai | 2021-07-30 00:00:00 | 2249 | 1910.819 | 338.1809999999998 | 0 | 2249 | 202.021 | 202.021 | 133.623 | 68.398 | 12.792 | 1.134999999999998 | 28.19599999999999 |  | 27.064 | 6.891999999999999 | 18.623 | 1.549 | 27.41 |  |  |  |  | HY-06281 | A1/7,8,10,11,97,98,99 |  | LC 31/12 | M | 0 | 133.623 | 202.021
 | HY-06279 | [NAME] | Coimbatore | 2021-07-30 00:00:00 | 213 | 35.029 | 177.971 | 0 | 213 | 160.301 | 160.301 | 32.047 | 128.254 | 88.44399999999999 | 1.370000000000012 | 34.25200000000001 |  | 32.882 | 22.19 | 10.692 | 0 | 5.558 |  |  |  |  | HY-06279 | A1/2 |  | LC 31/1 | M | 0 | 32.047 | 160.301
 | HY-06297 | BEST CORRUGATORS | Bengaluru | 2021-08-25 00:00:00 | 261 | 173.039 | 87.96100000000004 | 0 | 261 | 157.648 | 157.648 | 139.017 | 18.63099999999998 | 9.465 | 1.110223024625157e-16 | 9.16599999999998 |  | 9.183 | 6.631 | 2.552 | 0 | 0 |  |  |  |  | HY-06297 | A1/2,62 |  | 0 | M | 0 | 139.017 | 157.648
 | HY-06337 | POLYHOSE(STEEL STRUCTURES) | Chennai | 2021-10-19 00:00:00 | 298 | 2.616 | 295.384 | 0 | 298 | 142.748 | 142.748 | 0 | 142.748 | 0 | 1.530000000000001 | 139.257 |  | 0 | 0 | 0 | 0 | 3.491 |  |  |  |  | HY-06337 | A1/2 |  | LC 31/12 | M | 0 | 0 | 142.748
 | HY-06232 | MRF | Chennai | 2021-04-28 00:00:00 | 3530.84 | 2135.727 | 1395.113 | 36.621 | 3494.219 | 86.489 | 86.489 | 29.372 | 57.117 | 12.502 | 0.2490000000000057 | 7.611000000000008 |  | 7.363 | 2.897 | 4.425 | 0.041 | 37.004 |  |  |  |  | HY-06232 | A1/10,10,C1/8,D1/2,10 |  | 0 | M | 0 | 29.372 | 86.489
 | HY-06278 | RISING SUN | Bhopal | 2021-07-29 00:00:00 | 183 | 117.231 | 65.769 | 0 | 183 | 79.999 | 79.999 | 68.654 | 11.345 | 9.266 | 0.04299999999999882 | 2.078999999999999 |  | 2.036 | 2.036 | 0 | 0 | 0 |  |  |  |  | HY-06278 | A1/2 |  | 0 | M | 0 | 68.654 | 79.999
 | HY-06217 | ALOK MASTER BATCHES | Delhi | 2021-04-07 00:00:00 | 310 | 221.725 | 88.27500000000003 | 0 | 310 | 62.639 | 62.639 | 29.907 | 32.732 | 4.702 | 0.07900000000000063 | 28.03 |  | 27.951 | 20.676 | 7.275 | 0 | 0 |  |  |  |  | HY-06217 | B1/2 |  | 0 | M | 0 | 29.907 | 62.639
 | HY-06307 | WALKAROO INTERNATIONAL | Coimbatore | 2021-08-31 00:00:00 | 92 | 42.164 | 49.836 | 0 | 92 | 60.46200000000001 | 60.46200000000001 | 41.701 | 18.76100000000001 | 14.022 | 1.285000000000012 | 3.478000000000012 |  | 2.193 | 1.569 | 0.624 | 0 | 1.261 |  |  |  |  | HY-06307 | A1/2 |  | 0 | M | 0 | 41.701 | 60.46200000000001
 | HY-06201 | J MATADEE FREE TRADE ZONE | Chennai | 2021-03-25 00:00:00 | 1947 | 1470.816 | 476.1840000000002 | 26.012 | 1920.988 | 37.19500000000001 | 37.19500000000001 | 1.226 | 35.969 | 2.712 | 0 | 0 |  | 0 | 0 | 0 | 0 | 36.203 |  |  |  |  | HY-06201 | A1/11,99 |  | LC 10/12 | M | 0 | 1.226 | 37.19500000000001
 | HY-06236 | STERIL GENE LIFE SCIENCES | Chennai | 2021-04-30 00:00:00 | 227 | 184.124 | 42.876 | 0 | 227 | 29.375 | 29.375 | 4.68 | 24.695 | 0.817 | 20.699 | 22.514 |  | 1.815 | 0 | 0 | 1.815 | 1.364 |  |  |  |  | HY-06236 | A1/3,4,99 |  | 0 | M | 0 | 4.68 | 29.375
 | HY-06133 | ATC TYRES | Mumbai | 2020-12-31 00:00:00 | 4019 | 3126.906 | 892.0939999999996 | 2432.626 | 1586.374 | 29.014 | 29.014 | 5.945 | 23.069 | 19.748 | 2.877999999999998 | 2.877999999999998 |  | 0 | 0 | 0 | 0 | 0.4430000000000001 |  |  |  |  | HY-06133 | A1/10,11,12 |  | 0 | M | 0 | 5.945 | 29.014
 | HY-06250 | [NAME] | Mumbai | 2021-06-08 00:00:00 | 652 | 464.634 | 187.366 | 0 | 652 | 18.918 | 18.918 | 3.997 | 14.921 | 1.265 | 1.998 | 13.611 |  | 11.614 | 0 | 0 | 11.614 | 0.045 |  |  |  |  | HY-06250 | [NAME] |  | 0 | M | 0 | 3.997 | 18.918
 | HY-06347 | FAIVELEY TRANSPORT RAIL TECHNOLOGIES | Bengaluru | 2021-10-30 00:00:00 | 18 | 15.215 | 2.785 | 0 | 18 | 16.789 | 16.789 | 14.396 | 2.393000000000001 | 2.202 | 7.216449660063518e-16 | 0.1910000000000007 |  | 0.191 | 0 | 0.191 | 0 | 0 |  |  |  |  | HY-06347 | A1/1 |  | LC 10/12 | M | 0 | 14.396 | 16.789
 | [NAME] | MIND SPACE SHELTERS | Pune | 2021-09-28 00:00:00 | 150 | 122.98 | 27.02000000000001 | 0 | 150 | 15.111 | 15.111 | 3.993 | 11.118 | 0.3739999999999997 | 0 | 1.468999999999999 |  | 1.47 | 0.324 | 1.146 | 0 | 9.275 |  |  |  |  | [NAME] | A1/3,99 |  | 0 | M | 0 | 3.993 | 15.111
 | HY-06306 | AURO CURE | Hyderabad | 2021-08-31 00:00:00 | 1403 | 454.317 | 948.683 | 0 | 1403 | 13.149 | 13.149 | 8.737 | 4.412000000000001 | 3.013 | 0 | 1.399000000000001 |  | 2.655 | 0 | 2.655 | 0 | 0 |  |  |  |  | HY-06306 | A1/3 |  | LC 31/3 | M | 0 | 8.737 | 13.149
 | [NAME] | INDO GLOBAL ERECTORS | Pune | 2021-09-30 00:00:00 | 25 | 5.541 | 19.459 | 0 | 25 | 12.261 | 12.261 | 0 | 12.261 | 0 | 1.013 | 12.254 |  | 11.241 | 0 | 0 | 11.241 | 0.007 |  |  |  |  | [NAME] | A1/2,3 |  | 0 | NA | 0 | 0 | 12.261
 | HY-06315 | ROYAL ENFIELD | Chennai | 2021-10-20 00:00:00 | 163 | 124.816 | 38.184 | 0 | 163 | 11.244 | 11.244 | 0 | 11.244 | 1.96 | 4.440892098500626e-16 | 2.381 |  | 2.381 | 1.492 | 0.889 | 0 | 6.903 |  |  |  |  | HY-06315 | [NAME] |  | LC 31/12 | M | 0 | 0 | 11.244
 | HY-06265 | IFGL REFRACTORIES | Bengaluru | 2021-07-08 00:00:00 | 366 | 359.784 | 6.216000000000008 | 0 | 366 | 11.101 | 11.101 | 6.065 | 5.036 | 2.75 | 2.220446049250313e-16 | 1.488 |  | 1.489 | 0 | 1.489 | 0 | 0.798 |  |  |  |  | HY-06265 | A1/3,4,62 |  | LC 31/12 | M | 0 | 6.065 | 11.101
 | HY-05806 | [NAME] | Hyderabad | 2020-01-07 00:00:00 | 1050 | 613.52 | 436.48 | 774.095 | 275.905 | 9.7 | 9.7 | 9.27 | 0.4299999999999997 | 0.396 | 0.0339999999999997 | 0.0339999999999997 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | HY-05806 | A1/2 |  | 0 | S | 0 | 9.27 | 9.7
 | HY-06255 | ATC TYRES | Mumbai | 2021-06-19 00:00:00 | 149 | 125.547 | 23.453 | 0 | 149 | 8.48 | 8.48 | 0 | 8.48 | 8.061 | 0.4190000000000005 | 0.4190000000000005 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | HY-06255 | D1/2 |  | 0 | M | 0 | 0 | 8.48
 | HY-06207 | DR. REDDY LABS | Hyderabad | 2021-03-31 00:00:00 | 915 | 280.845 | 634.155 | 0 | 915 | 6.94 | 6.94 | 4.769 | 2.171 | 1.158 | 0.06200000000000028 | 0.8220000000000003 |  | 0.76 | 0.76 | 0 | 0 | 0.191 |  |  |  |  | HY-06207 | A1/62,63 |  | 0 | M | 0 | 4.769 | 6.94
 | HY-06245 | ATC TYRES | Mumbai | 2021-05-24 00:00:00 | 184 | 170.535 | 13.465 | 0 | 184 | 4.187 | 4.187 | 0 | 4.187 | 1.938 | 2.249 | 2.249 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | HY-06245 | C1/2,63 |  | 0 | M | 0 | 0 | 4.187
 | HY-06244 | VATECH WABAG | Chennai | 2021-05-21 00:00:00 | 81.335 | 199.007 | 0 | 0 | 81.335 | 3.818 | 3.818 | 0 | 3.818 | 3.818 | 0 | 0 |  | 0.649 | 0.223 | 0 | 0 | 0 |  |  |  |  | HY-06244 | A1/2,3,4,6 |  | LC 15/01 | M | 0 | 0 | 3.818
 | HY-06246 | SYSTEMATIC CONSCOM | Delhi | 2021-05-31 00:00:00 | 909 | 897.956 | 11.04399999999998 | 397.987 | 511.013 | 2.96 | 2.96 | 0 | 2.96 | 0.331 | 0 | 0.9339999999999999 |  | 0 | 0 | 0 | 0 | 1.695 |  |  |  |  | HY-06246 | A1/6,64,65 |  | 0 | M | 0 | 0 | 2.96
 | HY-06092 | LORVEN SEED PRO PACK | Hyderabad | 2020-11-25 00:00:00 | 488.5 | 488.48 | 0.01999999999998181 | 163.188 | 325.312 | 2.54 | 2.54 | 2.538 | 0.002000000000000224 | 0 | 2.237793284010081e-16 | 2.237793284010081e-16 |  | 0 | 0 | 0 | 0 | 0.002 |  |  |  |  | HY-06092 | A1/4 |  | 0 | S | 0 | 2.538 | 2.54
 | HY-06227 | MAPAL | Coimbatore | 2021-04-23 00:00:00 | 286 | 222.122 | 63.87799999999996 | 0 | 286 | 1.903 | 1.903 | 0 | 1.903 | 0.019 | 0 | 1.553 |  | 1.707 | 0.998 | 0.709 | 0 | 0.35 |  |  |  |  | HY-06227 | A1/62,64,99 |  | 0 | M | 0 | 0 | 1.903
 | HY-06150 | SALCOMP | Chennai | 2021-01-30 00:00:00 | 5400 | 5023.758999999998 | 376.2410000000018 | 4811.155 | 588.8450000000003 | 0.869 | 0.869 | 0 | 0.869 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0.869 |  |  |  |  | HY-06150 | A1/98 |  | 0 | M | 0 | 0 | 0.869
 | HY-06202 | MRF | Chennai | 2021-03-26 00:00:00 | 4161 | 3233.559 | 927.4409999999998 | 962.347 | 3198.653 | 0.835 | 0.835 | 0 | 0.835 | 0.724 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0.111 |  |  |  |  | HY-06202 | A1/7,9,10 |  | 0 | M | 0 | 0 | 0.835
 | HY-06282 | CHIRIPAL POLY FILMS | Mumbai | 2021-07-30 00:00:00 | 141 | 98.88499999999999 | 42.11500000000001 | 0 | 141 | 0.634 | 0.634 | 0 | 0.634 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0.634 |  |  |  |  | HY-06282 | B1/99,E1/99 |  | 0 | M | 0 | 0 | 0.634
 | HY-06262 | INSTAKART | Chennai | 2021-07-05 00:00:00 | 126.68 | 125.064 | 1.615999999999985 | 0 | 126.68 | 0.562 | 0.562 | 0 | 0.562 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0.562 |  |  |  |  | HY-06262 | A1/2 |  | LC 15/12 | M | 0 | 0 | 0.562
1 Cleared for Shipment Total |  |  |  |  |  |  |  |  |  | 3044.137 | 3044.137 | 947.811 | 2096.326 | 739.458 | 93.26799999999997 | 1101.685 |  | 849.7119999999998 | 403.039 | 175.781 | 114.921 | 258.148 |  |  |  | 1 Cleared for Shipment Total |  |  |  |  |  |  | 947.811 | 3044.137
2 Insp. Cleared | HY-05414 | RDS | Delhi | 2018-10-31 00:00:00 | 673 | 0 | 673 | 0 | 673 | 388.303 | 388.303 | 0 | 388.303 | 8.496 | 1.466000000000065 | 371.926 |  | 370.46 | 309.692 | 60.768 | 0 | 7.881 |  |  |  | 2 Insp. Cleared | HY-05414 | A1/2 |  | BG 12/4 | S | 0 | 0 | 388.303
 | HY-06280 | INDOSPACE ([NAME]) | Mumbai | 2021-07-30 00:00:00 | 975 | 12.048 | 962.952 | 0 | 975 | 184.168 | 184.168 | 0 | 184.168 | 47.295 | 2.88300000000001 | 132.69 |  | 129.807 | 98.356 | 31.451 | 0 | 4.183 |  |  |  |  | HY-06280 | A1/2 |  | 0 | M | 0 | 0 | 184.168
 | HY-06207 | DR. REDDY LABS | Hyderabad | 2021-03-31 00:00:00 | 915 | 280.845 | 634.155 | 0 | 915 | 111.366 | 111.366 | 0 | 111.366 | 101.8 | 1.06581410364015e-14 | 7.666000000000011 |  | 7.666 | 5.736 | 1.93 | 0 | 1.9 |  |  |  |  | HY-06207 | A1/62,63 |  | 0 | M | 0 | 0 | 111.366
 | HY-06133 | ATC TYRES | Mumbai | 2020-12-31 00:00:00 | 4019 | 3126.906 | 892.0939999999996 | 2432.626 | 1586.374 | 84.488 | 84.488 | 0 | 84.488 | 62.93 | 1.278999999999996 | 19.593 |  | 18.314 | 7.658 | 10.656 | 0 | 1.965 |  |  |  |  | HY-06133 | A1/10,11,12 |  | 0 | M | 0 | 0 | 84.488
2 Insp. Cleared Total |  |  |  |  |  |  |  |  |  | 768.325 | 768.325 | 0 | 768.325 | 220.521 | 5.628000000000082 | 531.875 |  | 526.247 | 421.442 | 104.805 | 0 | 15.929 |  |  |  | 2 Insp. Cleared Total |  |  |  |  |  |  | 0 | 768.325
3 Site Clearance Awtd. | HY-06134 | DOZCO INDIA | [NAME] | 2021-01-04 00:00:00 | 387 | 256.643 | 130.357 | 5.27 | 381.73 | 121.065 | 121.065 | 0 | 121.065 | 88.805 | 1.094000000000002 | 22.42 |  | 21.329 | 0 | 0.731 | 20.597 | 9.839999999999998 |  |  |  | 3 Site Clearance Awtd. | HY-06134 |  | [NAME] | LC 30/12 | M | 0 | 0 | 121.065
3 Site Clearance Awtd. Total |  |  |  |  |  |  |  |  |  | 121.065 | 121.065 | 0 | 121.065 | 88.805 | 1.094000000000002 | 22.42 |  | 21.329 | 0 | 0.731 | 20.597 | 9.839999999999998 |  |  |  | 3 Site Clearance Awtd. Total |  |  |  |  |  |  | 0 | 121.065
4 Insp. To be cleared | HY-06306 | AURO CURE | Hyderabad | 2021-08-31 00:00:00 | 1403 | 454.317 | 948.683 | 0 | 1403 | 180 | 180 | 0 | 180 | 0 | 0 | 176.483 |  | 212.914 | 104.105 | 108.809 | 0 | 3.517 |  |  |  | 4 Insp. To be cleared | HY-06306 |  | A1/4,5 | LC 31/3 | M | 0 | 0 | 180
 | HY-06255 | ATC TYRES | Mumbai | 2021-06-19 00:00:00 | 149 | 125.547 | 23.453 | 0 | 149 | 11.466 | 11.466 | 0 | 11.466 | 4.028 | 0 | 7.348000000000002 |  | 7.35 | 0 | 7.35 | 0 | 0.09 |  |  |  |  | HY-06255 |  | D1/3 | 0 | M | 0 | 0 | 11.466
4 Insp. To be cleared Total |  |  |  |  |  |  |  |  |  | 191.466 | 191.466 | 0 | 191.466 | 4.028 | 0 | 183.831 |  | 220.264 | 104.105 | 116.159 | 0 | 3.607 |  |  |  | 4 Insp. To be cleared Total |  |  |  |  |  |  | 0 | 191.466
5 To be Cleared | HY-06232 | MRF | Chennai | 2021-04-28 00:00:00 | 3530.84 | 2135.727 | 1395.113 | 36.621 | 3494.219 | 352.422 | 352.422 | 0 | 352.422 | 183.447 | 59.70199999999997 | 163.141 |  | 103.441 | 38.511 | 59.55 | 5.38 | 5.834 |  |  |  | 5 To be Cleared | HY-06232 |  | A1/8,B1/8,3,4,5,6,7,8,9,62 | 0 | M | 0 | 0 | 352.422
 | HY-06025 | JAYA KRISHNA FLOOR MILLS | Chennai | 2020-09-30 00:00:00 | 223 | 2.573 | 220.427 | 2.6 | 220.4 | 195.824 | 195.824 | 0 | 195.824 | 0 | 2.114000000000004 | 189.851 |  | 0 | 0 | 0 | 0 | 5.973 |  |  |  |  | HY-06025 |  | A1/2 | 0 | M | 0 | 0 | 195.824
 | HY-06284 | SVG EXPORTS | Bengaluru | 2021-07-31 00:00:00 | 997.924 | 365.698 | 632.226 | 0 | 997.924 | 159.294 | 159.294 | 0 | 159.294 | 0 | 1.01400000000001 | 154.315 |  | 0 | 0 | 0 | 0 | 4.978999999999999 |  |  |  |  | HY-06284 |  | A1/4 | 0 | M | 0 | 0 | 159.294
 | HY-06207 | DR. REDDY LABS | Hyderabad | 2021-03-31 00:00:00 | 915 | 280.845 | 634.155 | 0 | 915 | 150 | 150 | 0 | 150 | 21.275 | 0 | 123.593 |  | 236.903 | 192.622 | 33.351 | 10.93 | 5.132 |  |  |  |  | HY-06207 |  | A1/2,4 | 0 | M | 0 | 0 | 150
 | HY-06333 | WHIRLPOOL | Indore | 2021-10-18 00:00:00 | 665 | 10.413 | 654.587 | 0 | 665 | 147.294 | 147.294 | 0 | 147.294 | 31.627 | 1.250000000000014 | 112.1 |  | 110.85 | 82.714 | 21.377 | 6.759 | 3.567000000000001 |  |  |  |  | HY-06333 |  | B1/2,3 | 0 | M | 0 | 0 | 147.294
 | HY-06306 | AURO CURE | Hyderabad | 2021-08-31 00:00:00 | 1403 | 454.317 | 948.683 | 0 | 1403 | 142.064 | 142.064 | 130.274 | 11.79000000000002 | 4.27 | 1.211000000000021 | 7.520000000000021 |  | 6.309 | 2.302 | 4.007 | 0 | 0 |  |  |  |  | HY-06306 |  | A1/4,5 | LC 31/3 | M | 0 | 130.274 | 142.064
 | HY-06275 | ASHOK KHEMKA | Indore | 2021-07-26 00:00:00 | 217 | 0.696 | 216.304 | 0 | 217 | 137.684 | 137.684 | 0 | 137.684 | 1.377 | 2.532999999999987 | 134.254 |  | 131.721 | 83.405 | 48.316 | 0 | 2.053 |  |  |  |  | HY-06275 |  | A1/2 | 0 | M | 0 | 0 | 137.684
 | HY-06173 | [NAME] | Indore | 2021-02-17 00:00:00 | 115 | 0.7190000000000001 | 114.281 | 0 | 115 | 82.039 | 82.039 | 0 | 82.039 | 31.413 | 1.207000000000008 | 48.79700000000001 |  | 47.59 | 22.413 | 25.177 | 0 | 1.829 |  |  |  |  | HY-06173 |  | A1/2 | 0 | M | 0 | 0 | 82.039
 | HY-06237 | GS PEB & CIVIL WORKS | Pune | 2021-04-30 00:00:00 | 2669 | 1378.005 | 1290.995 | 826.2059999999999 | 1842.794 | 73.494 | 73.494 | 0 | 73.494 | 37.90600000000001 | 0 | 34.57899999999999 |  | 34.581 | 10.214 | 23.705 | 0.662 | 1.009 |  |  |  |  | HY-06237 |  | A1/91,93,94 | BG 31/12 | M | 0 | 0 | 73.494
 | HY-06206 | CHARBOOJA KRISHI | Hyderabad | 2021-03-31 00:00:00 | 134 | 4.264 | 129.736 | 0 | 134 | 64.752 | 64.752 | 0 | 64.752 | 51.79199999999999 | 1.32 | 11.061 |  | 9.741 | 9.367 | 0.374 | 0 | 1.899 |  |  |  |  | HY-06206 |  | A1/2 | 0 | M | 0 | 0 | 64.752
 | HY-06244 | VATECH WABAG | Chennai | 2021-05-21 00:00:00 | 81.335 | 199.007 | 0 | 0 | 81.335 | 59.74299999999999 | 59.74299999999999 | 0 | 59.74299999999999 | 2.333 | 0.0009999999999976694 | 57.41 |  | 57.409 | 56.951 | 0.458 | 0 | 0 |  |  |  |  | HY-06244 |  | [NAME] | LC 15/01 | M | 0 | 0 | 59.74299999999999
 | HY-06217 | ALOK MASTER BATCHES | Delhi | 2021-04-07 00:00:00 | 310 | 221.725 | 88.27500000000003 | 0 | 310 | 51.242 | 51.242 | 0 | 51.242 | 15.667 | 10.135 | 28.72 |  | 18.585 | 0.473 | 3.885 | 14.227 | 6.855 |  |  |  |  | HY-06217 |  | B1/3,4,99 | 0 | M | 0 | 0 | 51.242
 | HY-06227 | MAPAL | Coimbatore | 2021-04-23 00:00:00 | 286 | 222.122 | 63.87799999999996 | 0 | 286 | 47.849 | 47.849 | 0 | 47.849 | 1.62 | 0 | 0 |  | 0 | 0 | 0 | 0 | 46.22900000000001 |  |  |  |  | HY-06227 |  | A1/3,4 | 0 | M | 0 | 0 | 47.849
 | HY-06278 | RISING SUN | Bhopal | 2021-07-29 00:00:00 | 183 | 117.231 | 65.769 | 0 | 183 | 40 | 40 | 0 | 40 | 13.699 | 20 | 24.654 |  | 21.78 | 0 | 0.208 | 21.572 | 1.647 |  |  |  |  | HY-06278 |  | A1/3,4,99 | 0 | M | 0 | 0 | 40
 | HY-06307 | WALKAROO INTERNATIONAL | Coimbatore | 2021-08-31 00:00:00 | 92 | 42.164 | 49.836 | 0 | 92 | 29.974 | 29.974 | 0 | 29.974 | 20.569 | 2.518999999999999 | 2.594999999999999 |  | 0.076 | 0 | 0.076 | 0 | 6.81 |  |  |  |  | HY-06307 |  | A1/3,4,99 | 0 | M | 0 | 0 | 29.974
 | HY-06142 | KATALINE INFRA PRODUCTS | Bhopal | 2021-01-12 00:00:00 | 150 | 117.369 | 32.631 | 0 | 150 | 29.254 | 29.254 | 0 | 29.254 | 25.12 | 0.4649999999999999 | 3.067 |  | 2.602 | 0.723 | 1.743 | 0.136 | 1.067 |  |  |  |  | HY-06142 |  | A1/3,4,99 | BG 15/12 | M | 0 | 0 | 29.254
 | HY-06281 | ROYAL ENFIELD | Chennai | 2021-07-30 00:00:00 | 2249 | 1910.819 | 338.1809999999998 | 0 | 2249 | 16.25 | 16.25 | 0 | 16.25 | 9.209 | 0.05200000000000005 | 3.984 |  | 3.932 | 0 | 2.277 | 1.655 | 3.057 |  |  |  |  | HY-06281 |  | A1/13,14,15,95 | LC 31/12 | M | 0 | 0 | 16.25
 | [NAME] | MIND SPACE SHELTERS | Pune | 2021-09-28 00:00:00 | 150 | 122.98 | 27.02000000000001 | 0 | 150 | 15.191 | 15.191 | 0 | 15.191 | 0 | 0.1620000000000008 | 14.061 |  | 13.899 | 0 | 0.621 | 13.278 | 1.13 |  |  |  |  | [NAME] |  | A1/4 | 0 | M | 0 | 0 | 15.191
 | HY-06248 | ZF WIND POWER (COIMBATORE) | Chennai | 2021-05-31 00:00:00 | 16 | 0 | 16 | 0 | 16 | 14.312 | 14.312 | 0 | 14.312 | 5.346 | 0.1910000000000008 | 8.35 |  | 8.158999999999999 | 4.902 | 2.891 | 0.366 | 0.616 |  |  |  |  | HY-06248 |  | C1/5,6,7,8 | 0 | M | 0 | 0 | 14.312
 | HY-06348 | FAIVELEY TRANSPORT RAIL TECHNOLOGIES | Bengaluru | 2021-10-30 00:00:00 | 36 | 20.231 | 15.769 | 0 | 36 | 6.936 | 6.936 | 0 | 6.936 | 4.078 | 0.1779999999999999 | 2.282 |  | 2.104 | 0 | 0.343 | 1.761 | 0.576 |  |  |  |  | HY-06348 |  | A1/2 | LC 10/12 | M | 0 | 0 | 6.936
 | HY-06336 | SYSTEMATIC CONSCOM | Delhi | 2021-10-19 00:00:00 | 72 | 47.341 | 24.659 | 0 | 72 | 6.779 | 6.779 | 0 | 6.779 | 2.093 | 1 | 4.686 |  | 3.686 | 0 | 0 | 3.686 | 0 |  |  |  |  | HY-06336 |  | A1/3,4,99 | 0 | M | 0 | 0 | 6.779
 | HY-06347 | FAIVELEY TRANSPORT RAIL TECHNOLOGIES | Bengaluru | 2021-10-30 00:00:00 | 18 | 15.215 | 2.785 | 0 | 18 | 3.135 | 3.135 | 0 | 3.135 | 1.763 | 0.121 | 1.077 |  | 0.956 | 0 | 0.156 | 0.8 | 0.2949999999999999 |  |  |  |  | HY-06347 |  | A1/2 | LC 10/12 | M | 0 | 0 | 3.135
 | HY-06265 | IFGL REFRACTORIES | Bengaluru | 2021-07-08 00:00:00 | 366 | 359.784 | 6.216000000000008 | 0 | 366 | 2.574 | 2.574 | 0 | 2.574 | 0.887 | 0 | 1.647 |  | 1.647 | 0 | 1.647 | 0 | 0.04000000000000001 |  |  |  |  | HY-06265 |  | A1/99 | LC 31/12 | M | 0 | 0 | 2.574
 | [NAME] | ZF WIND POWER (COIMBATORE) | Chennai | 2021-05-31 00:00:00 | 23 | 22.292 | 0.7079999999999984 | 17.657 | 5.343 | 0.47 | 0.47 | 0 | 0.47 | 0.4409999999999999 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0.029 |  |  |  |  | [NAME] |  | [NAME] | 0 | M | 0 | 0 | 0.47
5 To be Cleared Total |  |  |  |  |  |  |  |  |  | 1828.576 | 1828.576 | 130.274 | 1698.302 | 465.932 | 105.175 | 1131.744 |  | 815.9710000000001 | 504.5970000000002 | 230.162 | 81.212 | 100.626 |  |  |  | 5 To be Cleared Total |  |  |  |  |  |  | 130.274 | 1828.576
6 Prodn Clearance Awtd | HY-06333 | WHIRLPOOL | Indore | 2021-10-18 00:00:00 | 665 | 10.413 | 654.587 | 0 | 665 | 121.855 | 121.855 | 0 | 121.855 | 0 | 119.416 | 119.416 |  | 0 | 0 | 0 | 0 | 2.439 |  |  |  | 6 Prodn Clearance Awtd | HY-06333 |  | B1/2,3 | 0 | M | 0 | 0 | 121.855
 | HY-06338 | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) |  | 80 |  | 0 | 0 | 80 | 80 |  |  |  |  |  |  |  |  |  |  | HY-06338 |  | #[NAME]! | (blank) | (blank) | (blank) |  | 80
 | HY-06237 | GS PEB & CIVIL WORKS | Pune | 2021-04-30 00:00:00 | 2669 | 1378.005 | 1290.995 | 826.2059999999999 | 1842.794 | 55.668 | 55.668 | 0 | 55.668 | 0 | 54.692 | 54.692 |  | 0 | 0 | 0 | 0 | 0.976 |  |  |  |  | HY-06237 |  | A1/91,93,94 | BG 31/12 | M | 0 | 0 | 55.668
 | HY-06207 | DR. REDDY LABS | Hyderabad | 2021-03-31 00:00:00 | 915 | 280.845 | 634.155 | 0 | 915 | 48.689 | 48.689 | 35.631 | 13.058 | 10.141 | 0 | 2.404999999999999 |  | 3.383 | 3.383 | 0 | 0 | 0.512 |  |  |  |  | HY-06207 |  | A1/2,4 | 0 | M | 0 | 35.631 | 48.689
6 Prodn Clearance Awtd Total |  |  |  |  |  |  |  |  |  | 226.212 | 306.212 | 35.631 | 190.581 | 10.141 | 254.108 | 256.513 |  | 3.383 | 3.383 | 0 | 0 | 3.927 |  |  |  | 6 Prodn Clearance Awtd Total |  |  |  |  |  |  | 35.631 | 306.212
8 Racking | HY-80074 | RELIANCE | Hyderabad | 2021-10-29 00:00:00 | 1970.66 | 1362.913 | 607.7470000000001 | 0 | 1970.66 | 450 | 450 | 85.634 | 364.366 | 35.113 | 0 | 329.021 |  | 897.932 | 0 | 1.098 | 622.587 | 0.232 |  |  |  | 8 Racking | HY-80074 |  |  | 0 | 0 | 0 | 85.634 | 450
 | HY-80078 | RELIANCE PROJECT & PROPERTY MANAGEMENT | Hyderabad | 2021-10-29 00:00:00 | 525 | 111.181 | 413.819 | 0 | 525 | 302 | 302 | 45.932 | 256.068 | 7.312 | 0 | 248.29 |  | 301.999 | 0 | 11.993 | 118.618 | 0.466 |  |  |  |  | HY-80078 |  |  | 0 | 0 | 0 | 45.932 | 302
 | HY-80075 | RELIANCE PROJECT & PROPERTY MANAGEMENT SERVICES (MTSS B2C – NAGPUR) | Hyderabad | 2021-10-31 00:00:00 | 225.1 | 267.736 | 0 | 0 | 225.1 | 300 | 300 | 19.889 | 280.111 | 3.356 | 0 | 274.715 |  | 428.631 | 0 | 0.632 | 98.177 | 2.04 |  |  |  |  | HY-80075 |  |  | 0 | 0 | 0 | 19.889 | 300
 | HY-80050 | Siemens Financial Services | Hyderabad | 2021-06-11 00:00:00 | 142 | 129.081 | 12.91899999999998 | 0 | 142 | 129.139 | 129.139 | 129.029 | 0.1100000000000136 | 0.058 | 0.05200000000001364 | 0.05200000000001364 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | HY-80050 |  |  | 0 | 0 | 0 | 129.029 | 129.139
 | HY-80071 | Siemens Financial Services | Hyderabad | 2021-09-29 00:00:00 | 145 | 0 | 145 | 0 | 145 | 127.029 | 127.029 | 0 | 127.029 | 22.255 | 0.09700000000000841 | 102.983 |  | 102.886 | 0 | 2.164 | 0.503 | 1.791 |  |  |  |  | HY-80071 |  |  | 0 | 0 | 0 | 0 | 127.029
 | HY-80072 | Siemens Financial Services | Hyderabad | 2021-09-29 00:00:00 | 117 | 0 | 117 | 0 | 117 | 101.306 | 101.306 | 0 | 101.306 | 17.857 | 0 | 82.033 |  | 82.033 | 0 | 2.301 | 0 | 1.416 |  |  |  |  | HY-80072 |  |  | 0 | 0 | 0 | 0 | 101.306
 | HY-80079 | RELIANCE PROJECT & PROPERTY MANAGEMENT | Hyderabad | 2021-10-29 00:00:00 | 91 | 47.31 | 43.69 | 0 | 91 | 91 | 91 | 7.808 | 83.19200000000001 | 2.955 | 80.156 | 80.156 |  | 0 | 0 | 0 | 0 | 0.081 |  |  |  |  | HY-80079 |  |  | 0 | 0 | 0 | 7.808 | 91
8 Racking Total |  |  |  |  |  |  |  |  |  | 1500.474 | 1500.474 | 288.292 | 1212.182 | 88.90599999999999 | 80.30500000000002 | 1117.25 |  | 1813.481 | 0 | 18.188 | 839.885 | 6.026 |  |  |  | 8 Racking Total |  |  |  |  |  |  | 288.292 | 1500.474
Grand Total |  |  |  |  |  |  |  |  |  | 7680.254999999998 | 7760.254999999998 | 1402.008 | 6278.246999999998 | 1617.791 | 539.578 | 4345.318 |  | 4250.387 | 1436.566 | 645.826 | 1056.615 | 398.1030000000001 |  |  |  | Grand Total |  |  |  |  |  |  | 1402.008 | 7760.254999999998