trucks

Hi, I have been racking my brain with this for days now trying different things but keep ending up with circular references when I think I am close - I do not think there is anyway to do this without VBA if it is even possible with VBA as I haven't found anything close in searching. In the...

Hi All, I have a sheet where it records a time when one of our trucks goes into a dealer. It also records the time the trucks leaves the dealer. I would like to workout how long the vehicle has been stood in the dealer. That is easy to do, but in order to be accurate, I would like the...

I am trying to setup an automated scheduling spreadsheet in Excel but have hit a road block. The actual problem I'm working on is quite complex so as an example imagine a new delivery business (Acme Shipping) that is purchasing trucks and starting delivery routes. As Acme wants to maximize the...

Good day! I am trying to create a query and I'm having issues with it. I'm hoping for some help. Main table - Owner/Operator (has basic info - name, email address, phone number, Company name) Truck Table - Lists trucks & trailers that are associated to Owner/Operator (one-to-many...

Hi, I am facing a live problem and hoping that someone can help me. I have 3 trucks and bunch of vegetables and fruits and I have to distribute these products in each of these trucks. The parameters that I have to check are Type, Quality and Availability. Explained with the screenshot: <style...

Hello, I have a daily appointment schedule that is going to be shared with 3-4 other people. We all work at the same company but at different locations. The schedule is for a truck washing station for our company trucks. Essentially the different locations are going to send their trucks to...

I have a fleet of truck I'm tracking. I need a minimum amount of trucks every day, depending on the day of the week. Right now I am using nested "IF" statements checked against a cell that has the date in it to pull trucks needed number. I have two questions. First I want to be able to shift...