Hello I hope you are well
so for my graduation project I want to create an MPS (master production schedule)
then the problems that our customers send excel files which different then it is necessary each time to put data manually
that's why I want to load these excel files and copy them automatically for each customer and do the necessary calculations (Prevention for 3 months) ( Total surface, Assembly, Process, tools) from a database to display it on a global dashboard
Inputs:
File Order Book.xlsx
Outputs:
Dashboard that displays all the necessary information
Given:
Database
so for my graduation project I want to create an MPS (master production schedule)
then the problems that our customers send excel files which different then it is necessary each time to put data manually
that's why I want to load these excel files and copy them automatically for each customer and do the necessary calculations (Prevention for 3 months) ( Total surface, Assembly, Process, tools) from a database to display it on a global dashboard
Inputs:
File Order Book.xlsx
Outputs:
Dashboard that displays all the necessary information
Given:
Database
