hi
i'm trying to calulate otif (on time in full) for deliveries we make.
B has the order number - i can calulate the number if unique orders (three)
I cannot work out how to calulate how many order were in full (c=3 and I = blank)
(c = 1 ordered, c=3 delivered, I = action: Backorder, Deleted or blank)
in this example, order 42211 was in full
42208 had a B (backorder) and D (deleted) in I so not in full
42210 bad a B (backorder) in I so not in full.
when i go live, there will be 6000 - 10000 lines a day, and i'll run the calulation for a week, so 30000 to 60000 line
A B C D E F G H I
<colgroup><col style="mso-width-source:userset;mso-width-alt:2702;width:57pt" width="76"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3726;width:79pt" width="105"> <col style="mso-width-source:userset;mso-width-alt:1507;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:2759;width:58pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:2929;width:62pt" width="82"> <col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>
i'm trying to calulate otif (on time in full) for deliveries we make.
B has the order number - i can calulate the number if unique orders (three)
I cannot work out how to calulate how many order were in full (c=3 and I = blank)
(c = 1 ordered, c=3 delivered, I = action: Backorder, Deleted or blank)
in this example, order 42211 was in full
42208 had a B (backorder) and D (deleted) in I so not in full
42210 bad a B (backorder) in I so not in full.
when i go live, there will be 6000 - 10000 lines a day, and i'll run the calulation for a week, so 30000 to 60000 line
A B C D E F G H I
12/06/2018 | 42208 | 1 | 10 | 5 | 13/06/2018 | MM | B | |
12/06/2018 | 42208 | 3 | 10 | 5 | 13/06/2018 | 13/06/2018 | MM | |
12/06/2018 | 42208 | 1 | 1 | 1 | 13/06/2018 | MM | ||
12/06/2018 | 42208 | 3 | 1 | 1 | 13/06/2018 | 13/06/2018 | MM | D |
12/06/2018 | 42210 | 1 | 1 | 1 | 13/06/2018 | | MM | |
12/06/2018 | 42210 | 3 | 1 | 0 | 13/06/2018 | MM | B | |
12/06/2018 | 42210 | 1 | 1 | 1 | 13/06/2018 | MM | ||
12/06/2018 | 42210 | 3 | 1 | 1 | 13/06/2018 | 13/06/2018 | MM | |
12/06/2018 | 42210 | 1 | 1 | 1 | 13/06/2018 | | MM | |
12/06/2018 | 42210 | 3 | 1 | 0 | 13/06/2018 | | MM | |
12/06/2018 | 42210 | 1 | 1 | 1 | 13/06/2018 | MM | ||
12/06/2018 | 42210 | 3 | 1 | 1 | 13/06/2018 | 13/06/2018 | MM | |
12/06/2018 | 42211 | 1 | 1 | 1 | 13/06/2018 | MM | ||
12/06/2018 | 42211 | 3 | 1 | 1 | 13/06/2018 | 13/06/2018 | MM |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2702;width:57pt" width="76"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3726;width:79pt" width="105"> <col style="mso-width-source:userset;mso-width-alt:1507;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:2759;width:58pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:2929;width:62pt" width="82"> <col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>