Gaurav Vohra
New Member
We've three tables:
Table1: Cutting datasheet, here we store data for part no., it's cutting program no. & qty. cut in that program.
Table2: Part & program allocation data, this sheet is to be dynamically updated using data entered in sheet 1 & sheet 3 such that any part is allocated qty. equal to given in po. This qty. may be fulfilled by multiple cutting programs. We need list of all programs & qty. in each program that is used to complete qty. of that part in that particular PO.
Table3: Excess stock for future consumption, this sheet is dynamically updated based on the difference of qty. of part cut & qty. required of that part in pending Pos.
Table 1 & Table 2 will keep on expanding.
Table1: Cutting datasheet, here we store data for part no., it's cutting program no. & qty. cut in that program.
Table2: Part & program allocation data, this sheet is to be dynamically updated using data entered in sheet 1 & sheet 3 such that any part is allocated qty. equal to given in po. This qty. may be fulfilled by multiple cutting programs. We need list of all programs & qty. in each program that is used to complete qty. of that part in that particular PO.
Table3: Excess stock for future consumption, this sheet is dynamically updated based on the difference of qty. of part cut & qty. required of that part in pending Pos.
Table 1 & Table 2 will keep on expanding.