logistics

Hi everyone, this is my first post, so apologies if I make any mistake in posting here. I have been browsing through the forum and found some similar threads but none that really matched my problematic. I am currently managing the stock and dispatches for the company I work for. In my...

Hello All, Firstly, I'm glad to be a member on this community and excited to have my first post. Here's my query: So I wanted column F to auto populate the CWT rate for our shipments. This column F would at least show how much cwt the carrier "column E" would charge us for that weight...

Hello everyone, I have a column with values either 0 or 1. Everytime there is one or more 0 below together, I need them to be replaced with increasing values by 1 and do not change the lines with previous 1. Like this: 1 1 /*no change 1 1 /*no change 0 1 /*+1 1 transform...

Afternoon all, Looking for some help/advice please... I hope this makes sense. I have a holiday file which is set out in a similar manner as below and tracks the full year. The actual file has around 400 employees in it but for the sake of this I've just classes a few as different job types...

Hi Folks, I have two systems to harmonize---a logistics system and an accounts management system---which provide different customer numbers: one for invoicing, and one for logistics operations. My task is to incorporate an 'accounts management' report into a logistics systems spreadsheet to...

I am trying to create a variable quantity calculator in excel 2007. I have 20 items. Each item has a different weight ex. 1.36kg or 2.70kg etc. and a specified order quantity ex. 3 x 1.36kg, 1 x 2.70kg etc. My total weight for all 20 items cannot exceed a set value (ex. 50kg). If I zero the...

Hi all, Attachment: https://drive.google.com/file/d/0B6JPJC8HktchYk1kbjNHRHpZb1U/view?usp=sharing In the attachment above, I've made a simple logistics model. Column C shows the daily shipments on each date The shipment capacity is 20000 (cell C6) The shipments follow FIFO i.e. For the 45k...

I have a little bit of a weird request and if anyone can help me it would be very much appreciated. I am trying to create an Excel spreadsheet which will allow me to make bookings of equipment, more specifically we hire out commentary units and public address systems so on the 'home page' I...