Hi Guys
Here I added my input and output you given, please let me know which formula used to calculate output
Binu Baby
[TABLE="width: 744"]
<colgroup><col><col><col span="2"><col span="4"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD="colspan: 8"] PURCHASE MATERIAL STOCK(in Nos)[/TD]
[/TR]
[TR]
[TD]Purschase Date[/TD]
[TD]Gasket 12"[/TD]
[TD]Gasket 8"[/TD]
[TD]Gasket 6"[/TD]
[TD]8" Elbow 90 DEG[/TD]
[TD]8" Elbow 45 DEG[/TD]
[TD]8" Elbow 30 DEG[/TD]
[TD]6" Elbow 90 DEG[/TD]
[/TR]
[TR]
[TD="align: right"]01-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]02-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]03-07-2017[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]04-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]05-07-2017[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]06-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]07-07-2017[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]08-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]09-07-2017[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]10-07-2017[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]11-07-2017[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]12-07-2017[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]13-07-2017[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]14-07-2017[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]15-07-2017[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]16-07-2017[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]17-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
Require output another sheet :
[TABLE="width: 251"]
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"] Material[/TD]
[TD="align: center"]Qty[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]8" Elbow 90 DEG[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]8" Elbow 45 DEG[/TD]
[TD="align: center"]56[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]8" Elbow 30 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]6" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]Gasket 8"[/TD]
[TD="align: center"]34[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]8" Elbow 90 DEG[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]8" Elbow 45 DEG[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]8" Elbow 30 DEG[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]6" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]Gasket 12"[/TD]
[TD="align: center"]23[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]Gasket 8"[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]8" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]6" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
</tbody>[/TABLE]
Here I added my input and output you given, please let me know which formula used to calculate output
Binu Baby
[TABLE="width: 744"]
<colgroup><col><col><col span="2"><col span="4"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD="colspan: 8"] PURCHASE MATERIAL STOCK(in Nos)[/TD]
[/TR]
[TR]
[TD]Purschase Date[/TD]
[TD]Gasket 12"[/TD]
[TD]Gasket 8"[/TD]
[TD]Gasket 6"[/TD]
[TD]8" Elbow 90 DEG[/TD]
[TD]8" Elbow 45 DEG[/TD]
[TD]8" Elbow 30 DEG[/TD]
[TD]6" Elbow 90 DEG[/TD]
[/TR]
[TR]
[TD="align: right"]01-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]02-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]03-07-2017[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]04-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]05-07-2017[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]06-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]07-07-2017[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]08-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]09-07-2017[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]10-07-2017[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]11-07-2017[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]12-07-2017[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]13-07-2017[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]14-07-2017[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]15-07-2017[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]16-07-2017[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]17-07-2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
Require output another sheet :
[TABLE="width: 251"]
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"] Material[/TD]
[TD="align: center"]Qty[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]8" Elbow 90 DEG[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]8" Elbow 45 DEG[/TD]
[TD="align: center"]56[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]8" Elbow 30 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]01-07-2017[/TD]
[TD="align: center"]6" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]Gasket 8"[/TD]
[TD="align: center"]34[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]8" Elbow 90 DEG[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]8" Elbow 45 DEG[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]8" Elbow 30 DEG[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]02-07-2017[/TD]
[TD="align: center"]6" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]Gasket 12"[/TD]
[TD="align: center"]23[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]Gasket 8"[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]8" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]03-07-2017[/TD]
[TD="align: center"]6" Elbow 90 DEG[/TD]
[TD="align: center"]5[/TD]
[/TR]
</tbody>[/TABLE]