Convert a tabular fleet activity report into a visual schedule by vehicle and sequential activity

Përfunduar Postuar 2 vite mё parё Paguhet në dorëzim
Përfunduar Paguhet në dorëzim

Have a fleet of vehicles (>50) and get a tabular digital data set extract for total fleet by vehicle registration and vehicle size showing activity, start time and end time in 15 minute time interval buckets over a defined 1-4 day extract period. There are 7 defined activities and a colour code is assigned to each. Vehicle activity will rollover the 24 hour window. For visualisation purposes, want to convert this tabular data set into a visual colour coded activity schedule to identify dead activity times over the time period (single or multiple days) by vehicle registration and size of vehicle. In attached file is shown a sample of 2 vehicles over a 2 to 3 day period and a mock up of the visual schedule. By implication, any 15 minute time buckets that show blank have no activity. The visualisation time period will be from the start of the 1st active time period bucket to the end of the last active time period bucket in the tabular digital data set. For clarity, an activity starting at 10:00 and ending at 11:00 uses 4 time buckets, the 10:00, 10:15, 10:30 and 10:45 time bucket. It is then available for next activity starting at 11:00.

Excel Visual Basic

ID Projekti: #31591113

Rreth projektit

7 propozimet Projekti në distancë Aktiv 2 vite mё parё

Është zgjedhur fitues:

arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Më shumë

$60 USD për 4 ditë
(12 Përshtypje)
3.6

7 profesionistë freelancer dërguan një ofertë mesatare prej $161 për këtë punë

VBAautomation

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010.I can handle your project in a very prudent manner. Give me more details Më shumë

$250 USD për 5 ditë
(19 Përshtypje)
5.3
rayyankabir

Hello, I am the expert on SQL server, Excel, Microsoft Access and also in Power BI. I am also very skilled freelancer who completes his job with 100% client satisfaction. I have also profound knowledge in other sector Më shumë

$230 USD për 7 ditë
(18 Përshtypje)
4.9
jamesdobbs11

Hi Dear! I already check your description with carefully and very interesting your project. Also I have a development experience of project like your project. Specially I have more than 10 years of experience in softwa Më shumë

$50 USD për 1 ditë
(2 Përshtypje)
0.4
talhaasif05

I have great experience in Excel currently I am doing a data entry worth 300$ project I can email you the file If you want. I have a Typing speed of 100 WPM (Words Per Minute). This will be my very first project on thi Më shumë

$140 USD për 7 ditë
(0 Përshtypje)
0.0