Consolidate on Time Delivery for each supplier and pull results into a different spread sheet

[CSM24]

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Hi,
Could you please offer some advice on following?
Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance,
Sheet 1 “Supplier Register” pulls data down at account level. And incorporates account data to use as a supplier risk database.
Sheet2 “Sup OTD” pulls itemised delivery data for each supplier/order. Delivery performance is calculated using the difference between delivery due date, and date received in the either Early, On Time or Late.
I am looking to

1. Summarize the on time delivery performance per supplier from sheet 2 “Sup OTD”
2. Pull or push the summarised on time delivery performance through to Sheet 1 “Supplier Register” for the relevant supplier.

Notes.
If it makes things easier Early and On Time can be changed to be on time.
On time delivery must be able to be calculated as a percentage on the supplier register.

Best Regards

Mark

 

[CSM24]

Apologies, I thought I had included images of my work sheets, but I assume that you are not allowed to upload images. Sample work books can be provided, but could you tell me the best method to use to attached them to this thread.

Thanks Mark

 

[Logit]

.
This is probably the only FORUM that doesn't provide a means to post workbooks or attachments. You'll need to post your workbook on a cloud site (DropBox.com, Google cloud, etc.) and then list
a link in your next post for download.

 

[CSM24]

Hi Thanks Logit.

 

[CSM24]

Hi, Please see shareable link to a sample work book.
https://drive.google.com/open?id=1CB_rVPekFRxRYqsAZonzcY_pjzImnW_v
Thanks Mark