176985602337900

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.

Description
Date

Job awarded.

Feb 2, 2012
Close

Job Description

  |  Change History >>

Updated

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

    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

Hi,

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:
Bug
New Feature
New Implementation
Consultation
Others

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
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Muzammil J.      
Muzammil J.'s identity has been verified.  Learn More
 Pakistan
INVITED
The Company is strongly focus on customer satisfaction. we work in an efficient and cost effective fashion. our modest aim is to provide you...
1
  |  
 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...
8
  |  
 4.9   |  Private   |  43 Jobs
Bid ID: 28442564  |  Submitted: Feb 2, 2012 10:09 ET 
Proposal SEALED

 Poland  |  
Winner
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...
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 28442421  |  Submitted: Feb 2, 2012 10:01 ET 
Delivery
Within 1 day
$60.00

 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...
1
  |  
 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 choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »