I wanna pull data from master sheet to other sheet like i want testing rework to go to testing rework only date wise.
Thanks in Advance
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks in Advance
Date | Month | Where NC Identified | Concern | NC Details | Qty. | Remark | |
9 January 2013 | Jan | Testing | AssemblyRework | Assembly | Water pump mounting bolt observed loose. | 1 | Rework |
30 January 2013 | Jan | Assembly | AssemblyRework | Assembly | Abnormal noise from gear end side(Outer gear position wrong). | 1 | Rework |
12 January 2013 | Jan | Testing | TestingReject | Testing | Lub oil leak from cylinder head no.3(R. Cover joint) | 1 | Reject |
14 January 2013 | Jan | Testing | TestingReject | Testing | Lub oil leak from oil filling body joint. | 1 | Reject |
4 January 2013 | Jan | Testing | Test bed removal Rework | Test bed removal | Gear noise. | 1 | Rework |
30 January 2013 | Jan | Testing | Test bed removal Rework | Test bed removal | Gear noise. | 1 | Rework |
12 January 2013 | Jan | PDI | PackingRework | Packing | Rocker cover mounting nuts observed loose. | 1 | Rework |
21 January 2013 | Jan | PDI | PackingRework | Packing | Alternator lever mounting bolt spring washer missing observed | 1 | Rework |
4 January 2013 | Jan | Assembly | B/oReject | B/o | Dent mark on gear support. | 2 | Reject |
5 January 2013 | Jan | Assembly | B/oReject | B/o | Oil seal housing mounting dowel hole CD minus | 6 | Reject |
6 February 2013 | Feb | Assembly | AssemblyRework | Assembly | M.B. cap mounting stud threading spoiled. | 1 | Rework |
13 February 2013 | Feb | Testing | TestingRework | Testing | Lub oil leak from Rocker cover joint. | 1 | Rework |
4 February 2013 | Feb | Testing | Test bed removal Rework | Test bed removal | Lub oil leak from gear end foot mounting stud( L.O.P filter side) | 1 | Rework |
4 February 2013 | Feb | PDI | packingRework | packing | Water observed in oil filling body. | 1 | Rework |
22 February 2013 | Feb | PDI | packingRework | packing | Alternator belt tension bolt observed wrong(req. 50.003.08.30, obs 50.003.08.25) | 1 | Rework |
1 February 2013 | Feb | Assembly | B/oReject | B/o | Rusty observed . | 7 | Reject |
11 March 2013 | Mar | Assembly | AssemblyRework | Assembly | D262' Engine assembly no. not punched (Missing). | 1 | Rework |
16 March 2013 | Mar | Testing | AssemblyReject | Assembly | Water inlet manifold tapping spoiled. | 1 | Reject |
25 March 2013 | Mar | Testing | TestingRework | Testing | Lub oil leakage from end cover. | 1 | Rework |
30 March 2013 | Mar | Testing | TestingRework | Testing | Engine not taking torque load, then also engine passed & sent for packing. | 2 | Rework |
4 March 2013 | Mar | Testing | Test bed removal Rework | Test bed removal | Blow by High | 1 | Rework |
13 March 2013 | Mar | Testing | Test bed removal Rework | Test bed removal | Low idle rpm high (2500rpm.) | 1 | Rework |
28 March 2013 | Mar | Testing | Test bed removal Rework | Test bed removal | Lube oil leak from Gear casing Stud hole. | 2 | Rework |
4 March 2013 | Mar | PDI | packingRework | packing | Alternator mounting bolt washer missing | 1 | Rework |
30 March 2013 | Mar | PDI | packingRework | packing | Engine Serial number punching wrong (Observed 39.354 instead of 39.1354) | 1 | Rework |
2 March 2013 | Mar | Assembly | b/oReject | b/o | Cylinder head observed without valve guide | 1 | Reject |
2 March 2013 | Mar | Assembly | b/oReject | b/o | Oil seal housing joint observed cut | 2 | Reject |
30 March 2013 | Mar | PDI | b/oReject | b/o | Cap crack observed | 1 | Reject |
6 April 2013 | Apr | PDI | AssemblyRework | Assembly | Water inlet manifold mounting bolt observed loose | 1 | Rework |
27 April 2013 | Apr | Assembly | AssemblyReject | Assembly | Lub oil leak from FIP lubrication pipe mounting hole. | 1 | Reject |
12 April 2013 | Apr | Testing | TestingReject | Testing | Engine seize. | 1 | Reject |
8 April 2013 | Apr | Testing | Test bed removal Rework | Test bed removal | Lube oil leakage from RS pipe mounting face on cylinder head | 1 | Rework |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>