Job description
Hi!
I am looking for an Excel specialist
I am a project manager in a manufacturing plant and I need a tool in EXCEL to design a production plan based on Gantt charts. Guidelines:
- charts must be hourly
- possibility to add human resources as well as machine [ productivity/cost per day ].
- indicating dependencies between activities - start to finish etc.
- prioritization
- project cost generator
- simple production orders generator - generated to pdf and later printing on the plant
- generator to pdf of weekly work schedule by day - person / position / daily estimated productivity
- generation of statistics and capacity consumption, efficiency of the plant
I found pare templates paid and free, which contain similar solutions to the above, however, as is often the case in life, ready-made solutions do not fit perfectly. Solutions can be drawn from them.
It would be ideal to embed it in Google sheets / Office 365 in the cloud, however, I do not know if all the functionality can be achieved. This is not a prerequisite.