Đã Hủy

Activities Log and Report

Activity management Excel Template and Reporting:

Requirements:

1- 1st Excel sheet will be distributed over staff workstations, when accessing this sheet, they will need to enter their Staff Number and Password to log in and access the functionality.

• Users Table will have the following data {staff name, password, Staff Number, Department}

2- After login, they will find a button to click to open a form {Activity Log Form}.

3- This form will have the following fields to fill and save it into the DB {date, activity description, time from, time to, total hours spent, Activity Priority (high, medium or low), Activity status (in progress, waiting other action, delayed, completed, overdue), comments}. If he enters time from and time to, the total time spent is auto calculated, if he enters the total directly no need to enter from and to time fields. And the “Activity Description” would be a drop down list, either the user will select an item directly or will select “Other” so a text field will show up to enter the not listed “activity description”.

4- 2nd Excel file to be used to access the reports Dashboard, this should show these kind of details based on the activities logs available in the DB for Single staff reporting and chart and or All staff report. The dashboard should have:

• Drop list to select Single Staff Name or Select "All Staff" and a calendar to select a date

• If selected Staff Name Only then the report and chart should display the following:

• A BAR Chart for Activity status and another one for activity priority showing the different types and their count on the selected date {for example in the priority chart you should show: High priority, medium and low and their count} for the status chart you show {pending, done, in progress, waiting other action...etc. and their count}

• Activity Duration Chart {you should show all the activities for this selected staff on the selected date and its time spent "duration"}

• If selected one staff name, you also provide a table listing all the activities available in the DB for the selected date with all details and at the end of this table you put the total count of activities on this selected date, total time spent.

** I need this to be done on MS EXCEL and MS Access 2010 where the DB will be placed in a centralized location and I need it to get done in 1 day from the moment I award the project to the freelancer! And to be delivered with all the sources opened with no password protection

• Again… the MS Access only for data storage.. no forms to be built there… all other forms and reports will be on Excel

only serous and confident freelancers please

Good Luck

Kỹ năng: Excel, Microsoft Access

Xem thêm: excel activity log, activity log excel, access activity, access activity log, activity log template access, project activity log excel, excel staff activity dashboard, activity log access, log excel access, access 2010 activity log, project activity access, access activity report, report activity log, project activity log report, activity log forms, activities log excel template, activity log report, excel 2010 activity reports, activity log access 2010, excel access log activity, waiting staff, total freelancer users, total freelancers freelancer, storage freelancer, reporting freelancer

Về Bên Thuê:
( 16 nhận xét ) Doha, Qatar

Mã Dự Án: #1668426

15 freelancer đang chào giá trung bình $476 cho công việc này

bharanisrihari

Hello, Excel VBA expert here. I've done similar projects. Please check PM for details. Thanks!

$750 USD trong 15 ngày
(57 Đánh Giá)
6.3
srinichal

I look forward to deliver the project

$580 USD trong 8 ngày
(3 Đánh Giá)
4.6
aptecpymefree

We can work in your Activities Log and Report. I am a leader of the team. I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MC Thêm

$700 USD trong 10 ngày
(1 Đánh Giá)
3.0
shagoon2u

Experts are ready to start immediately

$500 USD trong 3 ngày
(3 Đánh Giá)
2.9
mzahid32

Hi, I am ready to help you out for your requirement.

$250 USD trong 3 ngày
(3 Đánh Giá)
2.1
mainulislam85

Sir, I read your project brief and understood it, then I will be very happy if I working with you. Please check my portfolio. Thanks.

$400 USD trong 15 ngày
(4 Đánh Giá)
0.6
vvkrishna1983

Hi I am Ready to work. Thanks

$550 USD trong 20 ngày
(0 Đánh Giá)
0.0
raselmama

Check PMB For Details ==== Thanks Text here will be Uzzal as title on Project

$400 USD trong 12 ngày
(0 Đánh Giá)
0.0
Seetha76

Hi I have done projects in Access and excel. I can finish your job up to your expectations.

$300 USD trong 4 ngày
(0 Đánh Giá)
0.0
riyazvohra123

Hi, I have worked on many such similar projects. Gaurantee best work and on time delivery.

$250 USD trong 8 ngày
(0 Đánh Giá)
0.0
sanjay1236

Sir I have 16+ years experience of Software Development and database. I can develop software as per your requirement perfectly

$550 USD trong 10 ngày
(0 Đánh Giá)
0.0
sohailsafdar240

I have made many MS Access tools. I was also the part of Huawei's tool building team but here I am a new freeelancer.

$265 USD trong 3 ngày
(0 Đánh Giá)
0.0
irahmani

Xala Consultants a Norway based ICT firm, established in 2006, is one of the leading providers of end-to-end IT solutions and services to a variety of clients across the globe. We are bidding for this project and confi Thêm

$700 USD trong 5 ngày
(0 Đánh Giá)
0.0
freelancerkks

Hi, Hope you are doing well. I am writing in reply to your project posting. I have worked extensively on excel / VBA based modeling and am an expert in developing excel dashboards. simulation models, application Thêm

$450 USD trong 3 ngày
(0 Đánh Giá)
0.0
nallum

I have used and taught Microsoft Access and Excel professionally since 1992. I am very experienced with all versions and program almost daily in Access and Excel VBA. I frequently interface Access with other applicatio Thêm

$500 USD trong 1 ngày
(0 Đánh Giá)
0.0