In Progress

Database/Spreadsheet Creation

I need a database/spreadsheet created where the following data is tracked: (SEE ATTACHED FILE FOR FORMATTING SUGGESTIONS)

Client Number;

Client Name;

Date;

Task Completed;

Number of hours worked on task;

Total number of hours worked during the month for specific client (running total);

Total numbers of hours worked during the month for all clients running total);

Total number of hours worked during the year for specific client (running total); and

Total numbers of hours worked during the year for the specific client.

I then need to be able to print a report that looks something similar to the following:

_____________________________________________________________________________________________

Client No.- Client Name- Date- Task Completed- No. Hours/Task- Ttl/hours mo/client- Ttl/hours Yr/client-

11-101 Hammond, Chris 01/01/11 Worked on MSJ. 1.3 1.3 1.3

11-102 Garner, Ray 01/01/11 Worked on Disc. .3 .3 .3

Total Hours January 2011: 1.6 Total Hours Year 2011: 1.6

_____________________________________________________________________________________________

Client No. Client Name Date Task Completed No. Hours/Task Ttl/hours mo/client Ttl/hours Yr/client

11-101 Hammond, Chris 01/02/11 Telephone call .2 1.5 1.7

11-103 Smith, John 01/02/11 Client meeting .8 .8 .8

Total Hours January 2011: 4.1 Total Hours Year 2011: 4.1

_____________________________________________________________________________________________

Client No. Client Name Date Task Completed No. Hours/Task Ttl/hours mo/client Ttl/hours Yr/client

11-101 Hammond, Chris 02/03/11 Telephone call 1.0 1.0 2.7

11-103 Smith, John 02/03/11 Client meeting .2.0 2.0 2.8

Total Hours February 2011: 3.0 Total Hours Year 2011: 7.1

_____________________________________________________________________________________________

When you enter the Client No., the Client Name should automatically (pre-fill). When you enter the Client Name, the Client Number should automatically pop up (pre-fill). The date should be searchable by Client No., Client Name or date.

Please let me know if you have any [url removed, login to view] task field needs to be able to contain a significant amount of text. The formatting does not have to be exactly as stated. This is just a suggestion.

.

Skills: Data Processing, Excel

See more: january month, month january, be smith, month spreadsheet, suggestion name, spreadsheet 2, smith, searchable database, mo, disc, numbers database, february month, report creation excel, excel spreadsheet hours worked, excel data creation, database processing, fill data spreadsheet, data enter pre, fill excel spreadsheet data, hours worked database, 102 103, need client database excel, excel spreadsheet field, print excel, excel client

About the Employer:
( 20 reviews ) Syracuse, United States

Project ID: #1093295

Awarded to:

gshiels

I am a Management Accountant with 20 years experience and very strong Excel skills. I am new to this site and keen to build up my feedback, so rest assured that you will get excellent service from me.

$100 USD in 2 days
(11 Reviews)
5.0

46 freelancers are bidding on average $74 for this job

BDspeed

**PLS CHECK PMB**

$30 USD in 1 day
(187 Reviews)
6.3
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$150 USD in 3 days
(57 Reviews)
6.3
Balakabd

COuld u plz check ur PMB....Thanx

$30 USD in 1 day
(38 Reviews)
6.0
saninfotech

check pm. Thanks San

$50 USD in 2 days
(87 Reviews)
5.6
SamNanton

See PM for details.

$60 USD in 5 days
(26 Reviews)
5.0
srinichal

I would like to deliver the same asap

$60 USD in 2 days
(8 Reviews)
4.7
torajiv

Details in PM - Thanks in advance

$30 USD in 2 days
(27 Reviews)
4.5
ExactSystems

Please see a better solution on PMB. regards

$75 USD in 2 days
(5 Reviews)
4.6
ansi2

Ready to start

$100 USD in 3 days
(6 Reviews)
3.7
SaraHailes

I've recently completed a similar exercise for an Irish solicitor. Please see PMB for further bid details.

$125 USD in 2 days
(3 Reviews)
3.6
EmpUkbased

Lets start

$100 USD in 2 days
(3 Reviews)
3.6
muthumuni

hi... I can do it with best quality for you. So kindly contact me for get ready your job soon. Thank you.

$33 USD in 3 days
(6 Reviews)
3.5
ConsultOne

See my PM for the conditions of my bid

$350 USD in 10 days
(1 Review)
2.8
naashthebest

Hi, I can get this done exactly according to your requirements. If you are interested with my bid, just drop me a private message and will discuss further.

$100 USD in 3 days
(4 Reviews)
2.5
chch50

Hi, I'm interested with your project. Please see PMB. Thanks. Regards, Charles

$50 USD in 1 day
(4 Reviews)
2.3
vbeh

Ready to start.

$35 USD in 2 days
(3 Reviews)
2.1
reginagraceangel

I want this work. I'm hard working person.

$50 USD in 3 days
(0 Reviews)
0.0
umangbihani

Interested in your job

$30 USD in 1 day
(0 Reviews)
0.0
taimur02

hi, i am interest to take your project. pls give opportunity to do this. thanks, taimur

$30 USD in 3 days
(0 Reviews)
0.0
gilphi

Hi, see my pm

$150 USD in 3 days
(0 Reviews)
0.0