Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel task time reporting with charts - URGENT
Sign in to Add to Watch List

Admin Support > Other - Administrative Support

View Change History

The client has made the following changes to the job.


Job awarded.

Feb 2, 2012

Job Description

  |  Change History >>


  • Posted: Thu, Feb 02, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details


I need someone that can code me a basic excel in which I can report the summary and time of different tasks we worked on.

Here is what I need:

1. A list where I can add different tasks in different categories of tasks:
New Feature
New Implementation

I need the categories to be added in a different sheet, where I can edit them (add/remove/edit)

2. I need the following columns:
Item No., Task Type (see above-same as category- selectable from drop-down), Source (drop-down with following options, which can be defined in a separate sheet: FogBugz, Email, Phone, Meeting), Task ID, Date, Title, Description, Observations, Time (hours), Cost
I need columns to be sortable by each item.

3. Reporting:

Total number of tasks (sorted by categories), total number of hours, total cost.
These will text only.

I need the following reports, both text and charts:

a. first report/chart: Time spent on each category of tasks (in hours)- it can be pie or column chartes....

Sign in or Register to see more

Desired Skills
Microsoft Excel
Job ID: 28441984
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Muzammil J.      
Muzammil J.'s identity has been verified.  Learn More
The Company is strongly focus on customer satisfaction. we work in an efficient and cost effective fashion. our modest aim is to provide you...
 0.0   |  Private   |  0 Jobs
Bid ID: 28442615  |  Submitted: Feb 2, 2012 10:12 ET 
Proposal SEALED

 Bahrain  |  
"Bolssra BPO Solutions" Experienced and enthusiastic freelancers (Team of 10 Data Entry Operators) here to work for you. Expertise includes Data...
 4.9   |  Private   |  44 Jobs
Bid ID: 28442564  |  Submitted: Feb 2, 2012 10:09 ET 
Proposal SEALED

 Poland  |  
I am an experienced Excel VBA developer, as well as a business consultant. I create advanced Excel-based tools for SMEs and large corporations. I...
 0.0   |  Private   |  0 Jobs
Bid ID: 28442421  |  Submitted: Feb 2, 2012 10:01 ET 
Within 1 day

 New Zealand  |  
Your project is my number 1 priority. No matter the task, it will be done to your complete satisfaction. We NEVER outsource any of your work. Are...
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 28442065  |  Submitted: Feb 2, 2012 09:44 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »