Need help with dividing the week wise amount in to multiple resource

[moinshaik]

Need help with dividing the week wise amount in to multiple resource dividing by 40 for the first week and dividing by 45 for the other weeks. Please see the below input and the expected output. In the case the week amount is less than 60 then it should be divided in to 2.

Input:

Name	Week 1	Week 2	Week 3	Week 4	Week 5
A	316	422	499	711	766
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
B	50	60	80	90	100
B
B
..etc

Desired Output

Name	Week 1	Week 2	Week 3	Week 4	Week 5
A	315.9	421.9	499.4	711.4	765.7
A	40	45	45	45	45
A	40	45	45	45	45
A	40	45	45	45	45
A	40	45	45	45	45
A	36	45	45	45	45
A	40	45	45	45	45
A	40	45	45	45	45
A	40	17	45	45	45
A		45	45	45	45
A		45	45	45	45
A			49	45	45
A				45	45
A				45	45
A				45	45
A				45	45
A				36	45
A					45
B	50	60	80	90	100
B	25	30	40	40	40
B	25	30	40	40	40
B				10	20

[KarolinaRoza · Accepted solution]

Hi @moinshaik ,

I prepared workflow for you which I hope will be useful. It is not completed by I hope it will be useful and you will be able to continue with it.

It still require some manual intervention but I do not have idea how to make it more efficient. Maybe any of Community Member will be able to advice.. ?

So, in the workflow I prepared logic for rows generation for each week (week1 has slightly diff logic, week 2-3 are the same), you would need to copy the container and adjust column names for next weeks (it is marked in red containers it the workflow).

Let me know if it is helpful and if you need assistance with continuing with your problem.

BTW are you sure about the split for 2nd week.. 

Regards,

Karolina