romelsms1
06-23-2014, 09:44 AM
Dear all,
I’m trying to create an “template” to my workload in excel but I’m stuck in same “multiple conditions wit operations”
In detail:
I have 3 types of projects: NP,CD,2i with different workload/month
NP = New Project TGA → ABVC = 7 month / 1Manager + 1Info
ABVC → ABPT2 = 5 month / 1Manager
ABPT2 → ... = 2 month / 0,5Manager
CD = derivate body TGA → ABVC = 7 month / 0,6Manager + 0,6Info
ABVC → ABPT2 = 6 month / 0,6Manager + 0,6Info
2i = second Indus TGA → ABVC = 7 month / 0,5Manager + 0,5Info
ABVC → ABPT2 = 7 month / 0,25Manager + 0,25Info
for every month I want to calculate the projects sum in each month for Managers and Infos. 2 persons works on a project (for ex. between TGA and ABVC for 7 month works 1Manager + 1Info ....)
I also tried to create a function for this in VBA but doesn't work as I want...:(( can you help me with this one?
thanks in advance!
I’m trying to create an “template” to my workload in excel but I’m stuck in same “multiple conditions wit operations”
In detail:
I have 3 types of projects: NP,CD,2i with different workload/month
NP = New Project TGA → ABVC = 7 month / 1Manager + 1Info
ABVC → ABPT2 = 5 month / 1Manager
ABPT2 → ... = 2 month / 0,5Manager
CD = derivate body TGA → ABVC = 7 month / 0,6Manager + 0,6Info
ABVC → ABPT2 = 6 month / 0,6Manager + 0,6Info
2i = second Indus TGA → ABVC = 7 month / 0,5Manager + 0,5Info
ABVC → ABPT2 = 7 month / 0,25Manager + 0,25Info
for every month I want to calculate the projects sum in each month for Managers and Infos. 2 persons works on a project (for ex. between TGA and ABVC for 7 month works 1Manager + 1Info ....)
I also tried to create a function for this in VBA but doesn't work as I want...:(( can you help me with this one?
thanks in advance!