Lengkap

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.

Kemahiran: Excel, Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 1 ulasan ) Cape Town, South Africa

ID Projek: #31591113

Dianugerahkan kepada:

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 Lagi

$60 USD dalam 4 hari
(12 Ulasan)
3.6

7 pekerja bebas membida secara purata $161 untuk pekerjaan ini

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 Lagi

$250 USD dalam 5 hari
(19 Ulasan)
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 Lagi

$230 USD dalam 7 hari
(18 Ulasan)
4.9
(3 Ulasan)
3.1
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 Lagi

$50 USD dalam sehari
(2 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(0 Ulasan)
0.0
vipinkumar993469

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 dalam 7 hari
(0 Ulasan)
0.0