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

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.

Taidot: Excel, Visual Basic

Näytä lisää: active report visual basic 2008, active report visual basic, convert access crystal report, use crystal report visual foxpro, create dynamic excel report visual basic, detailed report visual basic hotel management program, access report visual map, convert oracle apps report excel format, example sql server 2000 crystal report visual basic, convert images jpg video visual basic, generate excel report visual basic, crystal report visual basicnet filter, sample crystal report visual foxpro, crystal report visual basic 2008 tutorial graph, convert date cystal report, drag drop time visual schedule, convert crystal report visual basic

Tietoa työnantajasta:
( 1 arvostelu ) Cape Town, South Africa

Projektin tunnus: #31591113

Myönnetty käyttäjälle:


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 Lisää

$60 USD 4 päivässä
(12 Arvostelua)

7 freelanceria on tarjonnut keskimäärin $161 tähän työhön


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 Lisää

$250 USD 5 päivässä
(19 arvostelua)

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 Lisää

$230 USD 7 päivässä
(18 arvostelua)
(3 arvostelua)

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 Lisää

$50 USD 1 päivässä
(2 arvostelua)

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 Lisää

$140 USD 7 päivässä
(0 arvostelua)

I am a export data entry [login to view URL] typing is very speed. I am an honest man. I hope you will give me work and I will do your job well done.

$200 USD 7 päivässä
(0 arvostelua)