Tezzadactyl
New Member
- Joined
- Jan 19, 2016
- Messages
- 43
Hi, I have been been trying to sort this problem out by myself, but after spending a lot of time, I haven't been able to find the solution I am after.
I then tried to see how smart AI could be, and although it looked like it was going to give me the results I needed, it could not get it right and i ended up going around in circles.
I am responsible for checking the compliance of drivers of our trucking fleet. Every day I receive an email with a spreadsheet from a company that GPS track our trucks, this shows me the Fleet number of the trucks, time stamps, GPS position and whether the truck is stopped, at idle, or mobile and at what speed its moving at.
I then have the time sheets for our drivers which show start time, break start and stop times, and end of day time.
I want a macro that I can run that will give me a pop up to input from the drivers run sheet, the Fleet number, start time, number of breaks (Up to 5) break start and finish time for each of the breaks, and the end of day time.
When I have input the data from the time sheets, I would like the row that matches the fleet number to be highlighted yellow.
I would then like to search the section of the spreadsheet between that fleet number, and the next occurrence down of any fleet number. this is just to isolate the time stamps relative to just that fleet number.
I would then like to highlight in green, all the rows that completely encapsulate the period of time that was input as a break from the drivers time sheet.
Then searching within that green section, I need any rows where the truck is in motion to be changed from green to red.
If I could have a macro that when I open the spreadsheet, i click on a button, input the timesheet data, then have the highlighted areas indicated, it would save me a lot of time, and guarantee accuracy of my checking.
If I could get this working correctly, I might have further modifications to improve it even more.
I someone can work with me to get this right, I'd be very grateful and also impressed that the human brain can still give better results than AI!
I then tried to see how smart AI could be, and although it looked like it was going to give me the results I needed, it could not get it right and i ended up going around in circles.
I am responsible for checking the compliance of drivers of our trucking fleet. Every day I receive an email with a spreadsheet from a company that GPS track our trucks, this shows me the Fleet number of the trucks, time stamps, GPS position and whether the truck is stopped, at idle, or mobile and at what speed its moving at.
I then have the time sheets for our drivers which show start time, break start and stop times, and end of day time.
I want a macro that I can run that will give me a pop up to input from the drivers run sheet, the Fleet number, start time, number of breaks (Up to 5) break start and finish time for each of the breaks, and the end of day time.
When I have input the data from the time sheets, I would like the row that matches the fleet number to be highlighted yellow.
I would then like to search the section of the spreadsheet between that fleet number, and the next occurrence down of any fleet number. this is just to isolate the time stamps relative to just that fleet number.
I would then like to highlight in green, all the rows that completely encapsulate the period of time that was input as a break from the drivers time sheet.
Then searching within that green section, I need any rows where the truck is in motion to be changed from green to red.
If I could have a macro that when I open the spreadsheet, i click on a button, input the timesheet data, then have the highlighted areas indicated, it would save me a lot of time, and guarantee accuracy of my checking.
If I could get this working correctly, I might have further modifications to improve it even more.
I someone can work with me to get this right, I'd be very grateful and also impressed that the human brain can still give better results than AI!
