vehicle

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

Hi All, Ive got a google sheet which automatically updates once my drivers log a fault with their vehicle. The action status of the vehicle changes from available to unavailable when the repairer places the vehicle in-progress meaning they are working on it. i then use vlookups to match the...

Greetings! I need a formula in column D, that reports Yes, if the Vehicle Year is older than 12 years, or KMs are greater than 333,333. And if Vehicle Year is "" then "". Thank you in advance. <tbody> A B C D 1 Name Vehicle Year KMs Meets Washout Criteria 3 Sue 2015...

Hi All, I have some data with two columns with data (data is either available or unavailable in each column) The unavailable status trumps the available status in either column can someone please help with a formula to compare and place the results in column K? thanks Sam...

Hello, I have a macro that grabs a specific email template then attaches a specific PDF file to it then sends it all off without display. Here's the code: <code> Dim objOL As Outlook.Application, msg As MailItem, p$, i%, ap$ 'Below is the location of the all the workflows on the network ap =...

Hello! I've painted myself into a corner here with an IF/AND/OR statement. This is a generalization of what I'm trying to accomplish in Excel 2016. The column VEHICLE doesn't always contain the word "TRUCK" so it needs to be scrutinized. The following string causes Excel to tell me there is...

Hi I've spent all day trying to work out how to do this and have failed. I've been given the task by my manager to highlight a cell per vehicle in a Fleet Service Schedule. Each vehicle is serviced every sixth Monday (every 42 days). Cell B7 is 01/01/2018 and B8 is 02/01/2018...

A1:A5 = No. of Veh., Speed, Circuit in Miles, Interval (min or sec), M/P Hour. The variables in B1:B5. So a typical "what-if" would be something like the Interval must be 1 minute, the Circuit Miles is 120... what would be the other values to meet the 1 min/120 miles set requirements. Other...

Hi I have a spread sheet that searches and lists information from another spread sheet based on 2 types of criteria and records which are vehicles at different locations . I want to put that vehicle information into another spread sheet under the respective location the vehicle works from...

Hi, So far this sum works OK, it looks up if the part stored in N4 has been used in col F, then checks if the vehicle type stored in N2 matches any used in column E. It then draws the qty from col D. However I can only get it to check the vehicle type if its an exact match. But my list in...

Example data in a cell: how can I help you 6/13/17 at 9am. its has been confirmed. Vehicles: G13-4577S G13-5465M G13-5543L G10-7050L G42-1669K Please Install/De-Install the below vehicles: Old Vehicle: 2013 FORD FOCUS 1FADP3F2XDL375864 G13-2158M New Vehicle: 2017 FORD CMAX 1FADP5AU0HL115466...

Hello, I want to extract the last driving kilometer of a vehicle ID, let's say 27001 thru a ComboBox. The database is store in sheets "Data", and the number of vehicle ID is in column C while the driving kilometer is in column G. So, when I change the vehicle ID in ComboBox1 then it will...

Hi all This is my first post so please be gentle :) as this could take some explaining I have a spreadsheet for Vehicle maintenance and need to move some cell info from one worksheet to another then delete the original info So i have a worksheet called Schedule Reminder that has 68 vehicles...

Hi there guys I am trying to build a spreadsheet that can return data from a master spreadsheet the master sheet consists of a number of columns a. vehicle fleet numbers b vehicle types c registration d availability e location i'm trying to find a formula that can on the second report sheet...

Greetings, new user who is not a VBA pro and would appreciate help. I'm also working on a navigate sheets ribbon, which I can post/reciprocate when I finish. I'm working on a workbook, where the user will select from a list (datavalidation) with a range name "AssetType", and based on their...

Hi all, i am new to this site and hope i can explain this issue i have clearly enough for you to assist in helping me out. I am working on a spreedsheet where i have a list of vehicle model descriptions in one column and the appropriate margine percentage in the column next to it. On another...

Wondering if anyone has already built a spreadsheet to compare hybrid vehicles total cost to own versus regular vehicles. With inputs for fuel cost, vehicle cost, insurance, etc. the more detailed the better. THANKS!!

I am a novice VBA/Excel programmer in need of help. I work for a small firm, Brach Engineering, that develops accident reconstruction software. <o:p></o:p> <o:p> </o:p> To give you an idea of what we're looking for, Jon Peltier's “RollingWheel” example...