Work allocation based staff availability hours and task estimated hours

[babuam]

I have written the case in detail below message

[OllieClarke]

Hi @babuam 

I don't know how you've configured your macro. My one does assign work to other offices if there is capacity and capability there, although that's not always true

I think you need to move your filter so that it's immediately after the first append fields tool in container 41, as you only ever want to be looking at people who are able to do the job. So you need to filter out the people who don't have the capability before you count how many people are available.

[babuam]

@OllieClarke I have gone through your output and Macro assigned staff 10 Singapore office task still there is Japan task  117. attached screenshot in the first tab ( as per your comments tab).

I have added filter if
([Category]="A" AND [Category A]="Yes")OR ([Category]="B" AND [Category B]="Yes")OR ([Category]="C" AND [Category C]="Yes") then 1 else 0 endif

after filter ([Office]=[Priority 1 Office]
AND [Available Hours]>=[Estimated hours]) 

Macro assigning the task in the respective office only . Staff 10 is still have available 5 hours. there is Singapore task but macro not assigned to staff.( attached screenshot in the second tab(my output). macro not assigning the  priority 2 office task if the staff has available hours.

Logic is simple: Task should be assigned respective Priority 1 office staff based on availability and capability . if there is no task priority 1 office  should pick the priority 2 office task. 

[OllieClarke]

@babuam 
Task 117 isn't assigned because it takes 5 hours and none of the people capable of doing category B tasks have that time. I've highlighted the staff who can do it below (4-8,10-13).
Once the previous tasks have been assigned, only 11 (1 hour), 12 (2 hours) , and 13 (3 hours) have availability, but none of them has 5 hours.



Again, I'm not sure completely how you've configured your macro, but with my container41 looking like this:

I get the above output. The only difference I've made is the filter tool immediately after the first append field tool

Ollie

[babuam]

@OllieClarke @Staff 10, staff 12 priority 1 office is japan. Macro assigned singapore  Task 111, Task 108 . It should be Japan office right? If there is no work Japan office then it can be assigned Singapore office task.

[babuam]

@OllieClarke Any update on this