Đã hoàn thành

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.

Kĩ năng: Excel, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Cape Town, South Africa

ID dự án: #31591113

Được trao cho:


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 Thêm

$60 USD trong 4 ngày
(12 Đánh Giá)

7 freelancer chào giá trung bình$161 cho công việc này


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 Thêm

$250 USD trong 5 ngày
(19 Nhận xét)

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 Thêm

$230 USD trong 7 ngày
(18 Nhận xét)
(3 Nhận xét)

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 Thêm

$50 USD trong 1 ngày
(2 Nhận xét)

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 Thêm

$140 USD trong 7 ngày
(0 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)