delivery

Hi everyone, I have been trying to create an algorithm to calculate the delivery efficiency rate (DER) of a logistics delivery company. The variables I have currently are late delivery risk( 1 or 0), distance between departure (customer city) and destination city(order city) , time taken for...

Hi, The code in use is shown below. This is how it works. I have a listbox with customers names. I select a name & when i press the DateTransferButton todays date then is entered into the cell for this customer at colomn G I believe at present if a value is in the G cell then i see a message...

I was given tens of thousands of bills charged to customers. I am trying to determine if the bills are potentially accurate. The only data I have is the actual bill itself. Here's where things get complicated. There are four scenarios, each with their own nuances: Scenario 1 Nuances: 1. Base Fee...

So i have to compare a list of dates to see if the delivery of materials is late Lets say: in column A i have the Regions estimated delivery in column B i have the expected delivery in column C i have a formula that tells me if X date is before today, making it late The report recently changed...

Failing at every turn to get the correct formula. IF cell P1 contains the word Delivery concatenate 3 cells together. This I have been able to do. but adding If Cell P1 is equal to Pickup then merge these 3 cells. When it says Delivery im good but otherwise I will get a False return instead...

I have a calculation Problem In My Application In which I need to Calculate Reverse Amount From Grand Total Amount. I Need Logic/Formula for It Need you guys Help. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...

Good morning, I have a userform which has a drop down list complete with customers names. I use this to then add a date to that customer. This is an example of what i do, I see that the customer has received his parcel so i select his name from the drop down list & then i press my transfer...

I am tracking dates and want to calculate the estimated delivery date in a single cell as I populate dates in each milestone. So I have a 60 day(E), 15 day(F), 5 day(G) notification column. I record the date I receive these notices in their respective column. I want to create an estimated...

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...

<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...

Hi Guys, i am a newbie on VBA ... so apologies in advance if this is a stupid question I have the following Column A == FEdEX AWB #s Coulum B == Delivery date (Empty) I woul dlike to write a function where it reads the tracking number on Column A and extracts the delivery date from the...

good afternoon all. i have a vba program that populates text/list boxes on a form, based on a users request in the form. it reads off a excel sheet that has delivery information for fedex shipments. the cells that contain the delivery "street address" are giving me an issue because they...

Hi all, hoping you can help as I'm a bit lost with this. My data has several columns of information regarding deliveries, the dates they were made and if all the items ordered by the customer were in the delivery. I need a formula to check the data and put a value of "bulk" if a delivery with...

How to calculate total delivery on Excel?

Hello. I need some help with displaying my pivot table values as a % of the row total but nothing is working. I have a pivot that looks like this <tbody> Row Labels On Time Delivery Late Delivery 2019 Jan 142 48 Feb 216 196 Mar 439 92 </tbody> I cannot workout how to change the...

Hi, I am somewhat of a newbie when it comes to excel, but I can usually find my way around with help from google, however this one has me baffled. We have a butchery and we’re starting a new service whereby customers can create their own BBQ Packs and delivery of these items are done to various...

Hi there, I am attempting to separate values for the same ID from different dates. Basically on the earlier date the delivery failed and was redelivered on a later date. Obviously this means the details of the delivery are different for each date. I have tried vlookup but am only able to...

I hope someone can help me out with a pivot table problem that I've yet tofigure out. I have a table setup that counts the number of instances that a trailerdelivers on an hourly basis. E.g., we have 7 deliveries at 08:00 AM. Most ofour deliveries are given an hour to complete the unloading...

Hi all, I have a problem, i want a message to flash up when i enter specific data anywhere in a workbook (regardless of the sheet) IE. If i enter ME1 1XY in a cell i may want this to say: "Delivery probems, check list". The purpose is to alert delivery drivers if we have had problems...

Hi there, I have a schedule showing delivery information and would like to use a formula to show by how many days a delivery was either early or late. I have previously used IF function to show if the delivered date cell is before or after the scheduled date cell. But ideally i would like to...