vehicle

I am trying to figure out the best way to only extract certain data from a download from our rating system. Below is an example of how the data is downloaded from the system VEH 1 - 2000 INTERNATIONAL 4000 4900 STRAIGHT TRUCK {1HTSDAAN7YH256306} City State Territory Stated Amount Cost...

Hello all, I am looking for an excel formula which would pickup from whole data , here with attached data for your reference. Data available in columns like from Jan to Dec and output i dont want to show everything in one go so only selected months need to be shown in output summary. which...

I have a excel vehicle tracking system that uses log sheets entered by trip that has a date associated with each entry. This includes kilometers driven for that date and for what vehicle. I have the ability to change the year and month on a report tab that will produce the kilometers per vehicle...

Hi, I want to know in a day & month a vehicle doing how many trips. Basically rotation of the vehicle. Abbreviation codes: Driver Code GU- Gurdeep G- Gafar G1- It will show the that driver done the multi delivery in this trip. For Example- On 2 June Gafar driver done four trips (G1 to G4)...

Hi, i need a help. I need a formula for the calculation for the below data <tbody> <tbody> Location </tbody> <tbody> Vehicle No. </tbody> <tbody> Transport </tbody> <tbody> Weighment </tbody> <tbody> Charges </tbody> <tbody> Total </tbody> <tbody> Credit...

Good Day, I work in Public Transport planning, we compile our time tables (origin + origin time and destination + destination time on a specific route / path) in Ms. Excel. Once the timetable is completed it looks something like this: https://ibb.co/ccNzSNB You will notice that the...

I have a spreadsheet where I need to read today's date from it and the corresponding vehicle registrations for today's date into a new spreadsheet in a tidy format. In it I have a series of days in the month, a column with the date in and then another column with the vehicle reg. I need to take...

Hi, I'm a first timer out of dark Africa I'm trying to track fuel usage for a small fleet. My issue is how to calculate the distance traveled between dates on a specific vehicle. Any help would be much appreciated. <colgroup><col span="2"><col><col><col><col></colgroup><tbody> Vehicle ID...

Hello all, I am not a programmer and I am really struggling getting my Excel workbook to do something that has been very simple in google sheets with query formulas. I am currently gathering data daily with a Google Form into a Google Sheet for daily vehicle checks. I am wanting to be able to...

I have a table that looks like the one below with Work Order # in descending order: <tbody> Employee Work Order # Employee Date Worked Employee Name Employee Total Hours Vehicle Work Order # Vehicle Description Vehicle Date Used Vehicle Total Hours Vehicle Operator S11421 9/26/17 Jason 6...

Hello, I have this code that will update the appropriate vehicle when the selected service is entered. How it works now is one service is entered at a time. On most occasions it would be better to be able to select multiple services. Does anyone have ideas on how to perhaps have the list of...

Sorry my Title might be misleading! Here is what I'm looking for. In column D is the date a vehicle is request to be used from in column H is the registration for the vehicle that will be used. I want column m to tell me if that registration input in column H is already in use for the date in...

Firstly, hello to all. I am a newbie here and also a newbie in excel. I need some help from you please. I have been tasked in work to create the spreadsheet with a userform to input all data. On the userform I have a listbox for vehicle numbers. What I need to do is copy all of the data from...

I am trying to find out if it is possible to create an auto-populating calendar based on the first Monday of the month, or the third Tuesday of the month, etc. The calendar I need to create is for a vehicle inspection monthly calendar. I have 6 vehicles each day of the month that need to be...

Hi! Question.. I have got store list on B3:B7, dates when the vehicle changes for the store on D3:D7, vehicle registrations drop down list on F3:F7 and when the next change is due required on H3:H7.. now what I want to do is if the same vehicle is used for the same store 4 days in a row to be...

Hi! Question.. I have got store list on B3:B7, dates when the vehicle changes for the store on D3:D7, vehicle registrations drop down list on F3:F7 and when the next change is due required on H3:H7.. now what I want to do is if the same vehicle is used for the same store 4 days in a row to be...

I would like to compare 2 separate columns and list out unique rows in another sheet. Column 1 Column 2 Column 3 Column 4 Column 5 MOW204000235 1 No No Vehicle Maint. MOW204000235 1 Yes No Driver Fitness MOW204000235 1 No Yes...

Hi, I am trying to automate some a box on the page. I have a cell with the below =IFERROR(GETPIVOTDATA("[Measures].[Count of c4]",Branches!$B$5,"[Query 1].[Month Name]","[Query 1].[Month Name].&["&$C$7&"]","[Query 1].[Year]","[Query...

Hi all, In A2:A32, I have a list of Toyota vehicle names. In subsequent columns from B:S, I have model years. Each vehicle name does not have the same quantity of model years, some have only 1 other have 11. My question is this: A2 (Camry) has 4 model years (B2: E2) to the right of it. In Z2:Z5...

I was just wondering if I could get some help on sorting data. I recently started working at a car dealership for the summer and I'm having trouble finding the right vehicle trim levels for customers based on the features that they want. What would be the best way to do this in excel? In the...