Hello Experts,
This may take some of your time as it has taken quite a bit of my time with no result. Which is why i post this question here.
Apologies for the vague question.
I am working on a Dashboard that displays the status of employees who have finished it.
Excel has 2 Tabs
1. Dash Board.
2. Look up tables.
1. Dashboard
we have Employee and Their Year and whether Employee has passed the course.
I am trying to build a Dashboard functionality in 'Status'.
Criteria is:
For START, SPEED, LAUNCH:
IF employee falls under Year '2014 START', '2014 SPEED', '2014 LAUNCH', '2015 START', '2015 SPEED', '2015 LAUNCH', then check for Look up 'table A'
If Employee does not have any mandatory or Optional Certificates, then Write 'N/A'
If employee has Passed All Mandatory Certificates (from Look up table A) + passed one of the optional Certificates then Write 'OK'.
If employee has not passed All Mandatory certificates + not passed one of the optional Certificates then Write 'Not OK'.
If Employee Falls Under Year '2016 START', '2016 SPEED', '2016 LAUNCH' then we need to calculate differently.
If Employee does not have any mandatory or Optional Certificates, then Write 'N/A'.
If employee has Passed All Mandatory Certificates from Look up table A + Secures the Minimum points required from Look up Table B then Write 'OK.
If employee has not Passed All Mandatory Certificates from Look up table A + does not Secure the Minimum points required from Look up Table B then Write 'Not OK.
(Course Vs Points is listed in Look up table c)
For 'START & SPEED Completed':
IF 'START & SPEED' are OK then write 'OK' If not 'Not OK'.
If nothing is there, then write 'N/A'
For Course completed
IF 'START & SPEED & Launch' are 'OK' then write 'OK' If not 'Not OK'.
If nothing is there, then write 'N/A'
Huge thanks!
Best Regards,
D.
This may take some of your time as it has taken quite a bit of my time with no result. Which is why i post this question here.
Apologies for the vague question.
I am working on a Dashboard that displays the status of employees who have finished it.
Excel has 2 Tabs
1. Dash Board.
2. Look up tables.
1. Dashboard
we have Employee and Their Year and whether Employee has passed the course.
I am trying to build a Dashboard functionality in 'Status'.
Criteria is:
For START, SPEED, LAUNCH:
IF employee falls under Year '2014 START', '2014 SPEED', '2014 LAUNCH', '2015 START', '2015 SPEED', '2015 LAUNCH', then check for Look up 'table A'
If Employee does not have any mandatory or Optional Certificates, then Write 'N/A'
If employee has Passed All Mandatory Certificates (from Look up table A) + passed one of the optional Certificates then Write 'OK'.
If employee has not passed All Mandatory certificates + not passed one of the optional Certificates then Write 'Not OK'.
If Employee Falls Under Year '2016 START', '2016 SPEED', '2016 LAUNCH' then we need to calculate differently.
If Employee does not have any mandatory or Optional Certificates, then Write 'N/A'.
If employee has Passed All Mandatory Certificates from Look up table A + Secures the Minimum points required from Look up Table B then Write 'OK.
If employee has not Passed All Mandatory Certificates from Look up table A + does not Secure the Minimum points required from Look up Table B then Write 'Not OK.
(Course Vs Points is listed in Look up table c)
For 'START & SPEED Completed':
IF 'START & SPEED' are OK then write 'OK' If not 'Not OK'.
If nothing is there, then write 'N/A'
For Course completed
IF 'START & SPEED & Launch' are 'OK' then write 'OK' If not 'Not OK'.
If nothing is there, then write 'N/A'
Huge thanks!
Best Regards,
D.