Planned Sequence Compliance

[Anonymous]

Good day all

I require assistance in

1. Calculating the planned delivery sequence (possibly using ranking)

2. Calculating the actual delivery sequence (also ranking).

3. Calculating the adherence actual vs planned.

The scenario.

I have 1 shipment  (trip)(dimension) with 4 customers (dimension) with planned delivery times(dimension):

Customer 1: 07:00

Customer 2: 08:00

Customer 3: 10:00

Customer 4: 12:00

Customer 5: 13:00

Actual delivery time

Customer 1: 07:00

Customer 2: 10:00

Customer 3: 08:00

Customer 4: 12:00

Customer 5: 13:00

You will note the planned sequence 1-2-3-4-5 however actual was 1-4-2-3-5

Calculate on Actual

1 is correct

4 is not correct

2 is not correct

3 is correct as it follows 2

5 not correct as it follows 3

Thus the score for this shipment will be 2 out of 5 (40%)

I would like to calculate this within a table

[neelamsaroha157 · Accepted solution]

Not not what object you want to use for the the sequence but check this if it works for you -

[Anonymous]

HI Neelam

Thank you very much for the reply. Work perfect with the data I provided.

However, how would i handle the following times to still get the same "score"?

Actual delivery time

Customer 1: 07:25

Customer 2: 10:05

Customer 3: 08:42

Customer 4: 12:15

Customer 5: 13:01

[neelamsaroha157]

I didn't get you what you mean. All I can see is the change in the time format and it should work for this time format as well.