With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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:
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.
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