Excel Gantt Chart

IN PROGRESS
Bids
9
Avg Bid (USD)
$101
Project Budget (USD)
$30 - $250

Project Description:
Good day everyone...

I have the following requirement and i hope everyone will read the description and requirements carefully and then bid. I dont want keep on explaining from scratch once i award the project to a freelancer, specially that there is no time, this should be delivered by tonight or tomorrow at MAX.

Requirements:

I have the attached Excel file... there is two sheets {Planning and Chart}, the chart sheet have a list of object(A,B,C..etc) names with the whole 2013 calendar next to each object
The planning sheet, will be like a source of input to draw the chart, it will have data about these objects, you will find for example Object A with Date1, Date2 and Date3 values...

The idea is that we need to read the data in planning sheet and check if it has a record in the chart sheet and then start filling the cells within the dates given to create the gantt chart

Notes:

1- the list of objects in the chart sheet is not fixed! some times it will be like A,B,C,D only and some times will be more!
2- when we run to generate the chart, all previous chart should be cleared and start over as new one.
3- when reading from the planning sheet, if there are more than record for the same object {as in the sample file attached}, then chart should be filled on the same record for that object... (this means, in chart sheet we will have a list with distinct values of object names with many duration filled, but in the planning sheet we will have list with duplicate objects )
4- each object in Plaiing sheet have 3 dates values (date1,date2 and date3)... when we fill these dates in the chart sheet... we need to fill the period from date1 to date2 with color BLUE and the period from date2 to date3 with color RED


Hope the whole idea is clear now... Good luck

* Please remember, this is to be delivered either today late night or tomorrow by midday! bidder with 3 days+ delivery.. thank you,

Skills required:
Excel
Additional Files: READY+SAMPLE.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 3 days
$ 30
in 1 days
$ 40
in 1 days
Hire SHhadun
$ 200
in 1 days
Hire acchusam
$ 100
in 1 days
Hire Sourabhonline
$ 50
in 2 days
Hire MajidAsgari3
$ 170
in 4 days
$ 45
in 2 days
$ 120
in 4 days