Create Excel-based work time sheets/project tracking

Closed

Description

Create a fast and easy to use, Excel-based weekly work timesheet for workflow and project time tracking in our small PR/media/marketing business.

We want to include a graphic front end interface incorporating our company branding/feel for staff to be presented with, with access to the backend data only for management. We can provide a full graphics/design if required.

The timesheet needs to have drop down selection menus listing our clients and their various departments, allocate job numbers (abbreviated client name/yy-mm-dd/job number of the day), include selection menu for job particulars (our departments/services), a space for staff comments undertaking the role, time started, finished and accumulated time spent.

We also need the capability of expanding the selection criteria at any stage, and to be able to draw information and statistics from the data input.

The goal of this project is to build a capability which will allow us to accurately track time spent on jobs, understand our workflow, organise job schedules, delegate responsibilities and build a database of knowledge from which we can build our business.

Columns:

Date – (drop down menu, date selection)

Clients (list client names

Department

Job Number – automatically allocated using abbreviated client name, date (yy-mm-dd) and job number of the day

Project – Project name

Job Type – (drop down menu listing our

Comments – room for employees to make comments on jobs

Time Started – (drop down menu, clock selection)

Time Finished – (drop down menu, clock selection)

Total Time – accumulated total from start/finish columns

We envisage this as the first of many jobs that we will undertake over coming weeks and months.

Skills: Data Entry, Data Processing, Database Administration, Excel, Website Design

See more: excel timesheet job tracking, us client list in graphic design, type of marketing jobs, type of jobs in marketing, total marketing jobs, time tracking project management, time management jobs, sheets jobs, selection criteria for job, selection criteria for a job, role of marketing department, pr weeks jobs, project management company names, pr marketing jobs, pr jobs, pr and marketing jobs, names graphics design, names for a graphic design business, mm marketing, media room design, media graphic jobs, media graphic design jobs, media design names, media and graphic design jobs, marketing type jobs

Project ID: #4960173

68 freelancers are bidding on average $11/hour for this job

pandeypriya2003

Hello We highly recommend our team for your work. They have vast experience in data entry projects like data mining, data research, email scrapping, profile and account creation. We are capable to provide excellent More

$8 AUD / hour
(555 Reviews)
7.6
qualifiedcoders

hi hope you are doing fine. We have read your requirements and have 10 Data entry experts in our company who have very good typing speed and accuracy. They have Very good knowledge of excel and other microsoft of More

$15 AUD / hour
(32 Reviews)
7.5
Toperfection

Hope you are doing well. I am the Team lead of one of the most experienced and skilled data entry team on freelancer.com and I am interested in offering our services to cater your data entry requirements. I am offer More

$12 AUD / hour
(59 Reviews)
6.8
Teloquence

Consider it done. Check my past reviews for your reference. I have create many such sheets before and I am sure will create user friendly interface for you. Eagerly looking forward for your reply.

$15 AUD / hour
(131 Reviews)
6.3
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this regard. I strongly bel More

$9 AUD / hour
(70 Reviews)
5.9
mxicoders

Greetings from mxicoders We , Mxicoders private limited , a leading software development company , specialist in custom web and smartphone apps development We helps business owners to simplify and automate their More

$9 AUD / hour
(7 Reviews)
5.5
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me Thank you, Farzana Pinky.

$10 AUD / hour
(59 Reviews)
5.5
pkcyber

Hi, I can do this for you. See my sample similar projects below. http://www.youtube.com/watch?v=nzyx9jEnGUo http://www.youtube.com/watch?v=sc27UF_aAQw

$10 AUD / hour
(24 Reviews)
5.4
satsin7

Hello! Thanks for considering my bid. I have done some projects of this nature. Being a management professional, know the need for simplistic but attractive design. I intend to use separate databases for employees and More

$15 AUD / hour
(18 Reviews)
4.6
mandeeps207

Hi there, I have created same type of time sheets in past project. I m ready to finish this task withing time and with full satisfaction. If interested pls reply asap....... thanks & regards: Mandeep Singh

$10 AUD / hour
(35 Reviews)
4.6
ExactSystems

I have a better than excel and a robust solution for this project. Using of excel will create problems with the passage of time as your data will grow. This is happened always in case of excel based applications More

$15 AUD / hour
(5 Reviews)
4.6
expertatwork

Hey veracitymedia, If you are using WINDOWS based system, then we may the right team to approach... please have a look at our profile...we have delivered a lot of such products... thank you.. please reply !

$8 AUD / hour
(39 Reviews)
4.4
aurinkoa

hei. i've created a CRM in excel that i can use for this project. i am highly interested in this project. let's talk for more details.

$12 AUD / hour
(7 Reviews)
3.9
jaylancer43

Hello - I am an Expert Techno-Functional Analyst in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree. I am among the niche full 5 Star bidder becasue I work till More

$10 AUD / hour
(15 Reviews)
3.7
sharly001

Hello, I'm an expert in excel programming using vba/macro/ formula. I can do the task with perfection and you can revise that any time. Also if you need any after support then kindly let me know. Bid price and ti More

$10 AUD / hour
(14 Reviews)
3.7
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experie More

$10 AUD / hour
(7 Reviews)
3.4
Edison1983

Similar Projects:******Please check IOHL, Hotel Management Template in my Portfolio.********* I can provide you with an attractive userform. Good Day!... I'm an Expert in Excel Automation. Having 6+ yrs of Exp. Ha More

$15 AUD / hour
(7 Reviews)
3.3
doinab

Lovely project and nice job. I worked as a consultant and I am familiar with the time sheets and their role.I am also an experienced specialist in excel and I am interested for a long cooperation. Regards Doina

$11 AUD / hour
(6 Reviews)
3.2
tomislav1975

Dear Sir, I have such project finished and with small modification it can be up and running in very litlle time. My area of expertise is project management (time tracking, budget tracking,..) , VBA in Office applicatio More

$15 AUD / hour
(3 Reviews)
3.1
technologiesblue

let start work..hire us and see the difference in your work..i can make the work better for..we always believe in client satisfaction

$12 AUD / hour
(3 Reviews)
2.7