Closed

Create Excel-based work time sheets/project tracking - repost

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: create selection excel, client list graphic design, type marketing jobs, type jobs marketing, total marketing jobs, time tracking project management, time management jobs, sheets jobs, selection criteria job, role marketing department, weeks jobs, project management company names, pr jobs, names graphics design, names graphic design business, mm marketing, media room design, media graphic jobs, media design names, media graphic design jobs, marketing type jobs, marketing information management jobs, make work jobs, list marketing jobs, list graphic design jobs

About the Employer:
( 0 reviews ) India

Project ID: #4971358

29 freelancers are bidding on average $30 for this job

aurinkoa

hi, i did something similar but if you want to talk budget i request is a bit higher then you can offer. if you are interested please let me know.

$94 USD in 3 days
(7 Reviews)
3.9
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. I've done the same project before: ht More

$45 USD in 3 days
(7 Reviews)
3.4
Aldo21

Sir: Here is a progress of the work: https://docs.google.com/file/d/0B5LM-dF66NaoemdmQVA0Ym50R2s/edit?usp=sharing

$25 USD in 3 days
(3 Reviews)
2.0
zExcel

I can help you create this spreadsheet. Let me know if you want me to work with you on this Regards

$24 USD in 1 day
(1 Review)
2.0
TTST

Hi, Want to work with you....... If, you think I am the right person for this please assign me now... Thank you

$25 USD in 3 days
(2 Reviews)
0.4
Afnk24

I have read your requirements, We are new to freelancer but we can do this job properly. We have do similar job for a call-center to Maurice. Contact us if you want to work with professionals team.

$25 USD in 3 days
(0 Reviews)
0.0
avd369

My understanding of your project requirement is as under: 1. You need an excel sheet to calculate weekly work timesheet for workflow and project time tracking, with various columns having dropdowns where the employees More

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

I will complete the whole project on time and excel sheet covers everything needed to track the work schedules of the members or employees.

$25 USD in 3 days
(0 Reviews)
0.0
bluerain05

Hello, I have two master's degrees and I'm quite proficient in excel. I think I can perfectly help you with this project. Thank you.

$35 USD in 3 days
(0 Reviews)
0.0
teimonr

Hello I am ready to start for this project and I am sure you will be happy about results waiting for your feedback

$25 USD in 3 days
(0 Reviews)
0.0
hdlong66

Dear Sir/Madam. I have not experience in this field but let me try your project. Wait for your reply. Thank you.

$30 USD in 30 days
(0 Reviews)
0.0
kishorechitrada

I am having 15 years experience in Excel, i done various projects like this. Please give me one chance i will develop this project with in time.

$25 USD in 3 days
(0 Reviews)
0.0
agrawalknikunj

i am interested in your project. plz give me the further details about your work. send me the brief details regarding work.

$25 USD in 3 days
(0 Reviews)
0.0
sramu1

I have over 15 yrs experience in IT and data processing. I have excellent knowledge in excel and word, I have very good communication skills - both written and oral. I am very confident that I will deliver a quality pr More

$29 USD in 2 days
(0 Reviews)
0.0
alicja1234

Hello, I can make it for You.I have worked with databases and done many projects like this ( see my portfolio data Forex).

$22 USD in 1 day
(0 Reviews)
0.0
vargat81

I can do this. ***********************************************************************************************

$20 USD in 4 days
(0 Reviews)
0.0
kshiteejjain

Hi, This is Kshiteej Jain working as a Dr. Web Designer. so which type of work you want to freelance. please let me know. Thanks :)

$25 USD in 3 days
(0 Reviews)
0.0
cis1985

Hello! I am a graduate of associate in office administration from Systems Plus College Foundation somewhere in Angeles City, Pampanga. I know how to operate Microsoft word 2007, excel, and PowerPoint. I can type accura More

$25 USD in 3 days
(0 Reviews)
0.0
prabhusrinivas

I am a finance professional with Advanced excel skills with over 5 years of reporting experience. I have created various such reports/tracking templates for my company as well as for various other company while i wa More

$25 USD in 1 day
(0 Reviews)
0.0
sdinfo

Hi, Our Data Entry operators are enriched with preparation of MIS and other Reports & are highly exposure on MS office packages (MS Word, Excel, Power Point etc.).They have a excellent typing speed of 35-40 wpm which More

$25 USD in 3 days
(0 Reviews)
0.0