truck

Hi guys, Although I've been reading for a number of years, this is my first post. Please bear with me if I do something incorrectly. I have a workbook that is basically taking invoices and rolling them up by date, truck number, and expense type. The problem is there can be multiple invoices...

Hi guys, I've searched high and low for a solution to my specific problem, but to no avail. Hence this post. I am developing an Excel database of drivers and the trucks they drove. These entries are being made via a userform throughout the month as they use the truck. The basic table as...

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

The attached table, first column is the truck code,3rd column is the price of new tires, the 4th column is the depreciation cost https://photos.app.goo.gl/Gtt76KvF51Yt8xCi8 I want to depreciate the cost of new tire over 26 months So i made a formula for the 4th column...

Hi all, I am trying to create a table that I can look up my regular trips but have been out of excel for a long time and now cannot get my mind around the problem. Can somebody please help me to create this "action" as it is driving me crazy trying to achieve the end result. The "From and To"...

I have an excel document with 8000 + rows with 23 columns and desire to populate the UID column with a number with everything associatedwith that item (between row breaks). What formula can I use to populate the UID column automatically insequential order?(I’ve populated thedata shown below)...

Here is the table, it can have a max of 52 rows. <colgroup><col><col><col><col></colgroup><tbody> Truck Date Cleaned Type Cleaning Next Cleaning Due 1 01/18/19 Weekly 01/25/19 3 01/18/19 90 Day 04/18/19 5 01/19/19 Monthly 02/18/19 </tbody> So what I would like to do is take the last...

I have the following formula in cell G22 and it works fine and provides the correct answer...

Hello, I am looking for a formula that will list out all the possible transport modes horizontally to the right of Item. all the transport mode associated with the ship ID can be found on sheet 2. I need to see them all horizontally next to item in sheet 1. Please let me know if you have any...

I have a sheet columns a to i I need a macro to that will read sheet 2 cell a1 in which i will plug truck number example TR-0506 , The macro then needs to go to sheet 1 search cell a1 where it finds the truck and then pull all those rows a to i starting row a3 as a2 will have headers I need a...

Hi, I am trying to create a new column in Power BI that will allow me to group my data by a subset of the entire table. Here is what I am trying to accomplish. <tbody> Event Number Unit Status Group Number 1234 Truck DP 1 1234 Car DP 2 1234 Truck AM 1 1234 Car AM 2 1234 Truck DP 3...

Hello, I'm trying to make a picture look of a truck look like it's "leaving" the spreadsheet at the start of a macro and "arriving" when the macro is complete. Below is the code I have, which is close. However, it's not working quite the way I'd like. Basically what I'm trying to get is for...

I have a set of data that tracks tread depth measurements at multiple points for each truck (64 total measurements per truck, per day); I need to create a set of charts which separates out each truck and tracks their regression over time with the horizontal axis being date and vertical...

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

I have a column of data with no particular structure to the characters. They are notes containing combinations of dates, model numbers ect... I'd like to find just the strings of 10+ numbers. Sometimes the numbers are consecutive, sometimes separated by a "-", "/" or " ". Below is an example of...

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

A new question. I have another spreadsheet which is a conglomeration of data regarding truck trips. Unfortunately the design of the sheet is not conducive to getting data. I have been working on a new concept for this which would allow for sorting of different portions of the trips (basic...

Hi, I need to create a new column that will show the number of staff per vehicle in order to do further calculations. Generally if they had the same amount of staff regardless if another vehicle showed up to the incident I would use a vLookup table however there are two conditions to the number...

No of units. Price/unit. Method. R/ unit 1. 70. Ship 1 10. 60. Truck. 1.5 100. 50. Road. 2 200. 40. Rail...

Hopefully this makes sense... The first sheet we will call "Pick" and is formatted like this: <tbody> SKU Description Call Name BC QTY B/O Aisle Row Tier Truck Stop 1234567 Blah Blah Blah _____ 1 301 A 1 1 1 </tbody> There is an empty row under every entry. The...