delivered

Im looking to have a line chart that shows a % for the number of sku's that were delivered on time. At present everything shows at 100% ( which is wrong, as some sku's were delivered outside of their 2 day SLA ). Im not great with charts , so could do with your help. Axis: Chart Date Values...

Hi, I have the following dax formulas for my cumulative total and % cumulative. Its working but not showing the correct cumulative in the technical sense Total Items Delivered: TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile...

Hello, I need to calculate time based on a measured output in a table. Basically I'm try to generate a standard amount of time per output. The rules are: 0 to 1 is 20 minutes flat (even if 0.1 is delivered or 0.9 it's still 20 minutes) and every unit after that is 10 minutes per unit (if 2.3...

Hi, I have a lists of transports. The list contains for each transport the source (warehouse), the desutination (clientID) and the shipment date. Ultimately, I want to show in a 100% bar chart the share of clients that are being delivered daily, up to 4 times per week, up to x times per week...

I'm very new to VBA and I'm trying to automate some processes via Excel. I have a workbook with 3 sheets: Ship In Transit Delivered I would like to be able to move the rows from Ship to In Transit or Delivered based on a value in the "W" column. If the value is In Transit to move it to the next...

Hello, Hope someone can help with this. I have a worksheet with a list of products, dates, delivery locations and amount being delivered (units). The products can be duplicated, as can the dates, but the delivery locations will be different if this is the case. <tbody> Product Date Delivery...

Hi, I have an Excel report, 7 Tabs, 1 for each day of the week. 4 Separate sites fill out this report each morning. All shortages are entered into the table, whichever site opens the report first, second, 3rd or 4th (This will vary from day to day) File is not shared I purposely refrained...

Hello all, new member to the Community looking for help. I was recently given a project at work and it has to do with Excel. I’m supposed to figure out how much product is being shipped and how many are staying behind. I was given a list of Product that has been delivered and a list of the ones...

I have an excel table with a large amount of file names (PDFs) and their description, as part of a list of documents that had to be delivered. All those files are in a folder (hard drive) organized within many subfolders, and I would like to check whether the documents they presented as...

Hi Guys I hope you can help with an excel 2016 issue. I have a report from which I have created a pivot table. From time to time I need to update the dataset and this is causing a few issues. I am logging errors on files being delivered. The key data fields are: Filename Original Date...

Hey guys, I need help with a formula : in A2 I have a customer arrival time 9:48. The time window the customer can be delivered is between 8:00 (B2)- 13:00(C2) and 15:00 (D2) - 18:00 (E2). How can I see if the order was delivered outside the time windows (before 8 after 13, between 13:00 and...

Hi all, This is my first post, so please bear with me. I'm definitely not good at VBA, but I'm continuing to learn as I design new templates and I use forums like these. In the code below, I am taking any items that were delivered late on the "summary" worksheet and moving them to a list...

Hi I have a pivot. Row names are months COL1 is number of delivered COL2 is number of delivered on time How can i add a 3rd column that calculates COL2/COL1. The third column has to work like the other so a new calculated field appears when data from march is added to the dataset. Example...

Recently my company has changed EXCHANGE servers. I have been using CDO for years. Now my emails are not being delivered. I keep getting this message: Remote Server returned '550 5.7.1 RESOLVER.RST.AuthRequired; authentication required' How can I get around this? Thanks.

hello, I have a problem that i'm sure will be an easy fix but i am stumped and cannot get it to work right. The DELIVERED date is in column "O", the "LFD" column is "p". I want the LFD date to populate automatically once the delivered date is manually entered. the LFD date is the delivered...

I am trying to sum a couple ranges based on labels in another row. The reason that I need it to be based on these labels is that the range will change. I have managed to get cell addresses in a very clunky way, but I can't get them to sum. Plus, it seems like there is probably a better way to...

After registering this great book at QUE , how do i find which content is updated. I found the inside cover to be misleading , especially Actually nothing is delivered, instead one has to login to view :( I expected an ebook/pdf with highlighted content of omissions / errors or references to...

Ok so here is what I have. I have a invoice spreadsheet with multiple tabs and it is starting to get lengthy. I have a column for delivered machines, simple yes or no. I want to copy the row where machines delivered "Yes" and paste to another sheet then delete the row when done. I First...