Create Excel-based work time sheets/project tracking - repost
This project received 32 bids from talented freelancers with an average bid price of $29 USD.Get free quotes for a project like this
Project Budget$10 - $30 USD
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.
Date – (drop down menu, date selection)
Clients (list client names
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.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online