Hi community,
I would like to make some adjustment to the "actual table" base on the "standard table", I think it is related to multi row formula tool, pls see the logic in the excel,
Thank you
Solved! Go to Solution.
@ryanzhang487 one question how you calculate step start and step end is C2? As per the logic If you -2 it will C0, which is not correct
@binuacs thank you for your reply, I have pm you, thanks
can you please elaborate more on this as I feel this is incomplete information to build any logic
kindly share other sample of data.
Hi, so basically I want to adjust some 'start step' and the 'finish step' in the 'actual' table base on the following cases:
1, if start step = finish step, and not the last step, end step will be adjusted to one step after
2, if start step = finish step and also = last step, start step will be adjusted to one step before
3, else are normal, no adjust needed,
for what is the one step before/ one step after/ last step, they need to refer in the 'look up standard' table (the second table attached)
please read the excel and there is a tab for logic explained,
eventually I want to calculate the efficiency rate% of each worker / work type by using ([end step time] - [start step time] ) actual worked time
I hope that make sense, thank you
Please check whether you are looking for the result like this.
Input was:
Many thanks
Shanker V
I have input/ed different cases to check whether the workflow works dynamically for all the cases.
Please also check whether the output are as expected.
Input:
Output after run:
Many thanks
Shanker V
Hi Shanker, good day,
both of your replies look right! thank you for your work,
could you please share the workflow?
Very much appreciated