Patrick020
New Member
- Joined
- Mar 20, 2018
- Messages
- 15
Hello everybody.
<o
></o
>
I’m a bit out of my depth with this one!
<o
></o
>
Effectively what I am trying to do is calculate the time commitment of each employee based on a number of criteria. <o
></o
>
<o
></o
>
Each employee is allocated to a number of jobs – the time commitment for each of these jobs is provided in FTE (i.e. if the time required for a job is 2 FTE, this could indicate one employee for two days, or two employees for one day each). <o
></o
>
<o
></o
>
The Criteria are provided in brackets. <o
></o
>
<o
></o
>
Please see the below data: <o
></o
>
<o
></o
>
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD][/TD]
[TD="width: 104, bgcolor: transparent"]Job 1<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Job 2<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Job 3<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Job 4<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Job 5<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]Job 6<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]Answer <o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Criteria 1 (High)<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]High<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]High<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Low<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]High<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]High<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]High<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Criteria 2 (Yes) <o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]No <o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]Yes<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Days FTE<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]2.5<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]3<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]2<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]4<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]1.5<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]2<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 1<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]0.5<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 2<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary <o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]3<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 3<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]1.5<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 4<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]2<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 5<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]Primary<o
></o
>
[/TD]
[TD="width: 64, bgcolor: transparent"]3<o
></o
>
[/TD]
[/TR]
</tbody>[/TABLE]
<o
></o
>
The answer I am trying to calculate has been provided in the final column. <o
></o
>
<o
></o
>
Taking Employee 1 as an example to explain the logic: Employee 1 is not assigned to Job 1, Job 2, Job 4 or Job 6. Employee 1 is assigned to Job 3 but Criteria 1 is not met so we do not include Job 3 in the calculation. <o
></o
>
<o
></o
>
Employee 1 is assigned to Job 5 and both criteria are met. This Job takes 1.5 FTE’s and we can see that three employees are assigned to this Job – therefore 1.5 /3 = 0.5 which is the answer.
Thanks for your help
Patrick
<o


I’m a bit out of my depth with this one!
<o


Effectively what I am trying to do is calculate the time commitment of each employee based on a number of criteria. <o


<o


Each employee is allocated to a number of jobs – the time commitment for each of these jobs is provided in FTE (i.e. if the time required for a job is 2 FTE, this could indicate one employee for two days, or two employees for one day each). <o


<o


The Criteria are provided in brackets. <o


<o


Please see the below data: <o


<o


[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD][/TD]
[TD="width: 104, bgcolor: transparent"]Job 1<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Job 2<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Job 3<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Job 4<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Job 5<o


[/TD]
[TD="width: 64, bgcolor: transparent"]Job 6<o


[/TD]
[TD="width: 64, bgcolor: transparent"]Answer <o


[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Criteria 1 (High)<o


[/TD]
[TD="width: 104, bgcolor: transparent"]High<o


[/TD]
[TD="width: 104, bgcolor: transparent"]High<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Low<o


[/TD]
[TD="width: 104, bgcolor: transparent"]High<o


[/TD]
[TD="width: 104, bgcolor: transparent"]High<o


[/TD]
[TD="width: 64, bgcolor: transparent"]High<o


[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Criteria 2 (Yes) <o


[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o


[/TD]
[TD="width: 104, bgcolor: transparent"]No <o


[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Yes<o


[/TD]
[TD="width: 64, bgcolor: transparent"]Yes<o


[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Days FTE<o


[/TD]
[TD="width: 104, bgcolor: transparent"]2.5<o


[/TD]
[TD="width: 104, bgcolor: transparent"]3<o


[/TD]
[TD="width: 104, bgcolor: transparent"]2<o


[/TD]
[TD="width: 104, bgcolor: transparent"]4<o


[/TD]
[TD="width: 104, bgcolor: transparent"]1.5<o


[/TD]
[TD="width: 64, bgcolor: transparent"]2<o


[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 1<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 64, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 64, bgcolor: transparent"]0.5<o


[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 2<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary <o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 64, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 64, bgcolor: transparent"]3<o


[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 3<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 64, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 64, bgcolor: transparent"]1.5<o


[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 4<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 64, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 64, bgcolor: transparent"]2<o


[/TD]
[/TR]
[TR]
[TD="width: 117, bgcolor: transparent"]Employee 5<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 104, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 104, bgcolor: transparent"]N/A<o


[/TD]
[TD="width: 64, bgcolor: transparent"]Primary<o


[/TD]
[TD="width: 64, bgcolor: transparent"]3<o


[/TD]
[/TR]
</tbody>[/TABLE]
<o


The answer I am trying to calculate has been provided in the final column. <o


<o


Taking Employee 1 as an example to explain the logic: Employee 1 is not assigned to Job 1, Job 2, Job 4 or Job 6. Employee 1 is assigned to Job 3 but Criteria 1 is not met so we do not include Job 3 in the calculation. <o


<o


Employee 1 is assigned to Job 5 and both criteria are met. This Job takes 1.5 FTE’s and we can see that three employees are assigned to this Job – therefore 1.5 /3 = 0.5 which is the answer.
Thanks for your help
Patrick