J
jovoga
Hello friends,
I use APQP excel sheet for APQP management.
Basic structure of excel spreadsheet is
a) Task Needed/task not needed (if I choose "task not needed", fields - Start date, Planned date, Finished date, Responsible person have value N.A.)
Task
b) Start date
c) Planned date
d) Finished date
e) Responsible person
Important rule: 1 file is for 1 APQP project (yearly 30-40 projects)
My problem is, that manage of each file is very hard and take a long time (i must open each file , check status, send reminder to responsible persons etc...).
Also also for responsible persons is this system not user friendly.
Do you have idea how to manage many projects in Excel without issue as I described above?
Please post your experiences.
I use APQP excel sheet for APQP management.
Basic structure of excel spreadsheet is
a) Task Needed/task not needed (if I choose "task not needed", fields - Start date, Planned date, Finished date, Responsible person have value N.A.)
Task
b) Start date
c) Planned date
d) Finished date
e) Responsible person
Important rule: 1 file is for 1 APQP project (yearly 30-40 projects)
My problem is, that manage of each file is very hard and take a long time (i must open each file , check status, send reminder to responsible persons etc...).
Also also for responsible persons is this system not user friendly.
Do you have idea how to manage many projects in Excel without issue as I described above?
Please post your experiences.